topic Re: Using a Google Service Account in tBigQueryOutput in Talend Studio

Using a Google Service Account in tBigQueryOutput

JamesR1 — Sat, 16 Nov 2024 09:09:58 GMT

I have been using the tBigQueryOutput component for several months now. I have it configured using Google OAuth credentials ClientID, Secret and Authorization Code. However every few months the secret and auth code have to be regenerated and all my jobs updated.

I made the process of updating the secret and auth code much easier by storing them in a context and setting the component properties using context variables. However I would like to setup these components to use a service account which does not expire the tokens but cannot figure out how or where to enter my private key.

Has anyone else successfully configured the tBigQueryOutput component to use a Google Service Account versus OAuth credentials?

Thank you in advance.

BTW, I am using Talend Open Studio 6.3.0 on a Windows 7 machine.

Re: Using a Google Service Account in tBigQueryOutput

Anonymous — Wed, 25 Oct 2017 08:25:02 GMT

Hello,

Our apologies for the deletion and we have already restored your topic on forum. Thanks for your time.

So far, the current release of the tBigQueryInput allows only the authorization with a client secret.

Here is a custom component written by talend community user and shared on talend exchange portal. It supports the service account in Google Analytics components.

The link:https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%252F1%252Fproducts%252F546&pi=marketplace%252F1%252Fproducts%252F546%252Fitems%252F2690

Hope it will help.

Best regards

Sabrina

Re: Using a Google Service Account in tBigQueryOutput

JamesR1 — Wed, 25 Oct 2017 22:33:23 GMT

thank you. I will take a look.

Re: Using a Google Service Account in tBigQueryOutput

JamesR1 — Wed, 25 Oct 2017 22:44:41 GMT

Unfortunately it does not appear to work with Google Big Query. FWIW Google Big Query is different than Google Analytics.

Re: Using a Google Service Account in tBigQueryOutput

Anonymous — Thu, 26 Oct 2017 08:05:07 GMT

Hi,

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

https://jira.talendforge.org/secure/Dashboard.jspa

Best regards

Sabrina

Re: Using a Google Service Account in tBigQueryOutput

JamesR1 — Fri, 27 Oct 2017 18:59:52 GMT

https://jira.talendforge.org/browse/TBD-5895

Re: Using a Google Service Account in tBigQueryOutput

philw66 — Mon, 22 Jan 2018 20:18:10 GMT

Any follow up on this request? There does not seem to be any activity on the Jira ticket since creation.

Re: Using a Google Service Account in tBigQueryOutput

philw66 — Tue, 19 Jun 2018 21:57:51 GMT

Appears that this feature request has been accepted and is slated for v7.1.1

https://jira.talendforge.org/browse/TBD-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel