Search code examples
sqlgoogle-bigquerysandbox

How to upload a 9GB file with extension sql.gz to SQL BigQuery Sandbox

I want to upload a 9.6 GB file with the extension .sql.gz to my SQL BigQuery Sandbox (free) account. I received a message that the file is too big and that I need to upload it from the cloud. When trying to upload it from the cloud, I am asked to create a bucket, and if I want to create a bucket, I get the message: "billing must be enabled". Is there any alternative, specifically for an sql.gz file?

Solution

  • As of now, there is no alternative but to upload .gz files files to a bucket in Cloud Storage and use the bq command-line tool to create a new table.

    You may enable billing for your existing project to use Cloud Storage.