Using a Google Service Account in tBigQueryOutput

[JamesR1]

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.

[Anonymous]

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%...

Hope it will help.

Best regards

Sabrina

[JamesR1]

thank you. I will take a look.

[JamesR1]

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

[Anonymous · Accepted solution]

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

[JamesR1]

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

[philw66]

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

[philw66]

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:al...