BigQuery Component Error

Highlighted
Five Stars

BigQuery Component Error

Hi, 

 

Talend Open Studio for Big Data

Talend Version - 7.2.1

Component Used - tBigQueryInput

 

 

The below query is working fine in BigQuery console, but throwing error in Talend.

 

SQL -> SELECT TABLE_NAME FROM `xxx`.INFORMATION_SCHEMA.TABLES

 

[statistics] connected
Running Query : SELECT TABLE_NAME FROM `xxx`.INFORMATION_SCHEMA.TABLES
Exception in component tBigQueryInput_1 (bg)
com.google.api.client.googleapis.json.GoogleJsonResponseException: 400 Bad Request
{
"code" : 400,
"errors" : [ {
"domain" : "global",
"message" : "Illegal operation on INFORMATION_SCHEMA view: Project_ID:xxx.INFORMATION_SCHEMA.TABLES",
"reason" : "invalid"
} ],
"message" : "Illegal operation on INFORMATION_SCHEMA view: Project_ID:xxx.INFORMATION_SCHEMA.TABLES",
"status" : "INVALID_ARGUMENT"
}
at com.google.api.client.googleapis.json.GoogleJsonResponseException.from(GoogleJsonResponseException.java:145)
at com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:113)
at com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:40)
at com.google.api.client.googleapis.services.AbstractGoogleClientRequest$1.interceptResponse(AbstractGoogleClientRequest.java:312)
at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:1049)
at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:410)
at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:343)
at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.execute(AbstractGoogleClientRequest.java:460)
at gab.bg_0_1.bg$1BigQueryUtil_tBigQueryInput_1.getLocation(bg.java:459)
at gab.bg_0_1.bg$1BigQueryUtil_tBigQueryInput_1.executeQuery(bg.java:487)
at gab.bg_0_1.bg.tBigQueryInput_1Process(bg.java:571)
at gab.bg_0_1.bg.runJobInTOS(bg.java:884)
at gab.bg_0_1.bg.main(bg.java:734)

 

 

 

 

 

Highlighted
Moderator

Re: BigQuery Component Error

Hello,

Did you define table schema in talend studio? Could you please post your tBigQueryInput component setting screenshot on community?

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.
Highlighted
Five Stars

Re: BigQuery Component Error

Did you define table schema in talend studio? --> Yes

Below is the screenshots 

 

canvas.JPGcanvas_2.JPGschema.JPG

Highlighted
Five Stars

Re: BigQuery Component Error

BigQuery permssions

 

permissions.JPG

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog