Five Stars

Using a Google Service Account in tBigQueryOutput

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.
Tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions
Moderator

Re: Using a Google Service Account in tBigQueryOutput

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

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

Re: Using a Google Service Account in tBigQueryOutput

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

 

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

Re: Using a Google Service Account in tBigQueryOutput

thank you. I will take a look.

Five Stars

Re: Using a Google Service Account in tBigQueryOutput

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

Moderator

Re: Using a Google Service Account in tBigQueryOutput

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

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

Re: Using a Google Service Account in tBigQueryOutput