Extract table from Google BigQuery table to Google Cloud Storage

0
votes

I am trying to extract table from Google BigQuery table to Google Cloud Storage using APIs. It does exports data to compressed(GZIP) CSV file to google storage. But it does not give the public access to that file. Is there any option to make exported file public through same API call?

I added another api call to make that file public but it gives me an error insufficientPermissions even after adding required role to the service account.

1
google-cloud-platformgoogle-bigquerygoogle-cloud-storagegoogle-compute-engine
You should instead make a dedicated bucket that is PUBLIC on the bucket level so all objects posted there gets public. – Pentium10

1 Answers

1
votes

You can't perform the 2 operations in the same call.

  • 1 call for extracting data
  • 1 call for changing the ACL, our put your file in a public bucket.

However, you extract data from your database and you let them publicly accessible in bucket? Are you sure?