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.
LinkedIn
Twitter
