Hey All,
I’m getting an internal Error:
An internal error occurred and the request could not be completed. This is usually caused by a transient issue. Retrying the job with back-off as described in the BigQuery SLA should solve the problem: https://cloud.google.com/bigquery/sla. If the error continues to occur please contact support at https://cloud.google.com/support. Error: 80324028
While trying to run the below query:
CREATE EXTERNAL TABLE test_eastus2.test
WITH CONNECTION azure-eastus2.test_Azure
OPTIONS (
format = ‘CSV’, uris = [‘azure://test.blob.core.windows.net/test-sdk/homes.csv’]);
Does your csv file have public access? If file is in local you can try installing cloud SDK and then try again.
@VishalBulbule I followed this article - https://cloud.google.com/bigquery/docs/omni-azure-create-connection#assigning-a-role
And I want to load data from Azure. So I followed the above article, and added the role in Azure, does my file still need to be public?
Also, I’m running the query on Bigquery Web App
@utkarsharma2 did you every figure this out? We’re getting the same error for some azure storage accounts, but on others, and trying to track it down. It’s not permissions (they are the same), we’re assuming some other azure security tool/setting is blocking the connection, but the error isn’t giving us any hints as to what.