Using BigQuery Omni with AWS - Export is failing

I am at the final step of the Using BigQuery Omni with AWS and the export is failing. Anyone else facing the issue or has the solution for this ?

Export query results to AWS S3

The query

EXPORT DATA WITH CONNECTION `aws-us-east-1.bq-omni-aws-connector`
OPTIONS(uri="s3://qwiklabs-gcp-00-5c220593090b/exports/*", format="CSV")
AS SELECT * FROM `qwiklabs-gcp-00-5c220593090b.bq_omni_demo.bq-omni-table`

The error :

BigQuery received AccessDenied from S3 for 'PUT_OBJECT' on bucket 'qwiklabs-gcp-01-c575ec395749' path 'exports/000000000000' in region 'us-east-1' using Connection 'aws-us-east-1.bq-omni-aws-connector'. This could due to insufficient permission, or the path doesn't exist.

This is the last step for the Yellow Challenge completion. Swift help will be much appreciated.

0 5 1,073
5 REPLIES 5
Top Labels in this Space