Azure Synapse Copy Data from BigQuery, Source ERROR [HY000] [Microsoft][BigQuery] (131) Unable to authenticate with Google BigQuery Storage API

Question

I am getting this error at the Source tab at the Use query (Table, Query) Query, when doing a copy data activity at the Azure Synapse pipeline.

Unable to authenticate with Google BigQuery Storage API:

.

The strange thing is I can preview data at the Source dataset, I can also preview data when select the Use query Table option.

I can even run query to select the table's schema

SELECT
*
FROM
`3082`.INFORMATION_SCHEMA.TABLES
WHERE table_type = 'BASE TABLE'

but I get this authentication error when selecting columns

SELECT
*
FROM
`3082.gcp_billing_export_v1_019F74_6EA5E8_C96548`;

Refer this [MS document](https://learn.microsoft.com/en-us/power-query/connectors/google-bigquery#unable-to-authenticate-with-google-bigquery-storage-api) and check if all the required permissions are there. — Aswin, Jan 27 '23 at 06:22
@Aswin, thank you for answering this question. I was missing the BigQuery user role. Please post the above comment again as answer so I can mark it. — dwssc2023, Jan 31 '23 at 22:03

score 0 · Accepted Answer · answered Feb 01 '23 at 03:37

ERROR [HY000] [Microsoft][BigQuery] (131) Unable to authenticate with Google BigQuery Storage API. Check your account permissions

The above error is due to issue in authentication of BigQuery Storage API. The permission required to access data from BigQuery are,

The role BigQuery User will help in giving above permissions.

Reference:

1 Answers1