tBigQueryOutput component issue in Auth_code generation

Five Stars

tBigQueryOutput component issue in Auth_code generation

Hi,

With this post i want to understand 2 things:

 

1) Internal processing of tBigQueryOutput component ? Is it generating bq or gsutil query to load data to google big query.

 

2) Facing below error while generating Auth_code for the component:

 

Starting job test_bq at 18:01 12/10/2017.

[statistics] connecting to socket on port 3811
[statistics] connected
Exception in component tBigQueryOutput_1_tBQBE
java.lang.NullPointerException
at com.google.api.client.repackaged.com.google.common.base.Preconditions.checkNotNull(Preconditions.java:191)
at com.google.api.client.util.Preconditions.checkNotNull(Preconditions.java:127)
at com.google.api.client.json.jackson2.JacksonFactory.createJsonParser(JacksonFactory.java:92)
at com.google.api.client.json.JsonObjectParser.parseAndClose(JsonObjectParser.java:85)
at com.google.api.client.json.JsonObjectParser.parseAndClose(JsonObjectParser.java:81)
at com.google.api.client.auth.oauth2.TokenResponseException.from(TokenResponseException.java:88)
at com.google.api.client.auth.oauth2.TokenRequest.executeUnparsed(TokenRequest.java:287)
at com.google.api.client.auth.oauth2.TokenRequest.execute(TokenRequest.java:307)
at com.google.api.client.auth.oauth2.Credential.executeRefreshToken(Credential.java:570)
at com.google.api.client.googleapis.auth.oauth2.GoogleCredential.executeRefreshToken(GoogleCredential.java:362)
at com.google.api.client.auth.oauth2.Credential.refreshToken(Credential.java:489)
at local_project.test_bq_0_1.test_bq.tFileInputDelimited_1Process(test_bq.java:879)
at local_project.test_bq_0_1.test_bq.runJobInTOS(test_bq.java:1388)
at local_project.test_bq_0_1.test_bq.main(test_bq.java:1245)
[statistics] disconnected
Job test_bq ended at 18:01 12/10/2017. [exit code=1]

 

Talend bigquery auth_code.PNG

 

 

Moderator

Re: tBigQueryOutput component issue in Auth_code generation

Hi,

Are your connection parameters Client Id, Client Secret Ok with you?

Here are online documents about component reference:TalendHelpCenter:tBigQueryOutput and the related scenario:TalendHelpCenterSmiley Frustratedcenario: Writing data in BigQuery.

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.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

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

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads