Environment details
BigQuery client v1.24.0, all Python versions.
Steps to reproduce
-
Fire up a Jupyter notebook or an IPython session and load the bigquery extension:
%load_ext google.cloud.bigquery
-
Use the bigquery cell magic without specifying the query:
%%bigquery --project my-project --destination_table my_dataset.my_table
Actual result:
An error message is displayed, but is kind of misleading:
ERROR:
table_id must be a fully-qualified ID in standard SQL format, e.g., "project.dataset.table_id", got
It might make the user wonder why the table ID is incorrect even if --destination is correctly specified.
Expected result:
The error message should explain that the query is missing in the cell body.
Proposed solution
The current implementation assumes that any query without whitespace represents a table ID, but it fails to check if the query is non-empty in the first place. The latter check should be added.