Talend integration with Google BigQuery Service Account

One Star SB
One Star

Talend integration with Google BigQuery Service Account

I need to connect Talend with BigQuery with GCE Service Account. Can anyone guide me through the way, please?

Usually, we get a JSON file from GCE API & Services>Credentials against a Service Account but cannot find out a way to use the JSON in the BigQuery components - tBigQueryInput and tBigQueryOutput. The JSON does not have ClientID, ClientSecret pair required in the Talend components mentioned. Though we easily get the same pair in the OAuth key generated against an End User account. I am sure there will be ways to use the JSON file judiciously into Talend to handshake with GCE Service Account. Any help would be appreciated!


Re: Talend integration with Google BigQuery Service Account


Could you please create a new feature jira issue on talend bug tracker?


Best regards


Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach


Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.



Introduction to Talend Open Studio for Data Integration.