Sunday, September 06, 2015

Can bq load create an empty table?

Can I use (as of today) the Google BigQuery client to create an empty table?  The stackoverflow answer is "No", which seems to be true.  Perhaps I misread the google documentation referred to below, because I kinda sorta thought the answer was "Yes." But its "No".

For the record, or in case of future need.

This stack overflow answer:
http://stackoverflow.com/questions/29746837/bigquery-bq-command-load-only-if-table-is-empty-or-doesnt-exist

This google bigquery documentation:
https://cloud.google.com/bigquery/bq-command-line-tool?hl=en

specifically:
Create a Table from a File 
You can load an uncompressed or gzipped CSV or JSON file from Google Cloud Storage or an uncompressed file from your disk to create a new table. You can create a new table by creating a new schema and then loading the files in separate calls, or you can combine both actions into a single call with the following syntax...

No comments: