Bigquery s3 integration

Question

Does BigQuery have the ability to import data from s3? If not, what is the best alternative way you can offer?

Answer 1

BigQuery does not support the direct reception of data from S3 buckets. However, it’s easy to transfer data from S3 buckets to Google Cloud Storage using the gsutil command-line tool. I would suggest moving the data to Cloud Storage and then mastering it in BigQuery.

https://developers.google.com/storage/docs/gsutil