BigQuery Component Error

g7XneJXR_jxs — Sat, 16 Nov 2024 04:53:54 GMT

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)

Re: BigQuery Component Error

Anonymous — Thu, 22 Aug 2019 08:04:08 GMT

Hello,

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

Best regards

Sabrina

Re: BigQuery Component Error

g7XneJXR_jxs — Thu, 22 Aug 2019 09:07:08 GMT

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

Below is the screenshots

Re: BigQuery Component Error

g7XneJXR_jxs — Thu, 22 Aug 2019 09:12:44 GMT

BigQuery permssions

topic Re: BigQuery Component Error in Talend Studio

BigQuery Component Error

Re: BigQuery Component Error

Re: BigQuery Component Error

Re: BigQuery Component Error