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 and check if all the required permissions are there. — Aswin
– Aswin, Commented Jan 27, 2023 at 6: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
– dwssc2023, Commented Jan 31, 2023 at 22:03

Aswin · Accepted Answer · 2023-02-01 03:37:23Z

0

Answer recommended by Microsoft Azure Collective

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:

answered Feb 1, 2023 at 3:37

Aswin

7,3342 gold badges9 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1