tBiqQueryInput asking for elevated permission to run select queries

[DJose1656543464]

Hi,

I am running a select query (Eg select * from dataset.tablename) using the tBigQueryInput Component. Big query read only permissions on the data set, should be enough to perform a query like this, but its asking for 'bigquery dataset create permission' as well. Could you please confirm on the minimum permissions required on BigQuery for this particular use case?

-Error Log

'google.cloud.bigquery.BigQueryException: Access Denied: User do no have bigquery.dataset.create permission in project

[Anonymous]

Hello,

Could you please clarify in which Talend version/edition you are?

There is a limitation from BigQuery-connector.

As it was explained BigQuery configuration needs to be able to write temporary info into datasets which is impossible with "viewer" role for datasets.

Our Admin rights are able to perform BigQuery operation

Best regards

Sabrina

[DJose1656543464]

I'm using Talend studio 7.3.1 (Talend Cloud Big Data)

[Anonymous]

Hello,

You need 'bigquery.datasets.create' permission for your Bigquery account when performing BigQuery operation.

It is the limitation from BigQuery-connector not talend.

Best regards

Sabrina

[Tins1980 · Accepted solution]

I got this to work by removing the space between "#standardSQL and \r\n.

Works:

"#standardSQL\r\n

Doesn't work:

"#standardSQL \r\n

RTFM:

"Must be separated from the query by a newline character"

My update to the FM:

"Must be separated from the query by ONLY a newline character"