Skip to content
This repository was archived by the owner on Mar 6, 2026. It is now read-only.
This repository was archived by the owner on Mar 6, 2026. It is now read-only.

Uninformative Jupyter cell magic error if the query is missing #57

Closed

Description

@plamut

Environment details

BigQuery client v1.24.0, all Python versions.

Steps to reproduce

  1. Fire up a Jupyter notebook or an IPython session and load the bigquery extension:

     %load_ext google.cloud.bigquery
    
  2. 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.

Activity

  1. added
    type: bugError or flaw in code with unintended results or allowing sub-optimal usage patterns.
    priority: p2Moderately-important priority. Fix may not be included in next release.
    on Mar 10, 2020
  2. self-assigned this
    on Mar 10, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

api: bigqueryIssues related to the googleapis/python-bigquery API.priority: p2Moderately-important priority. Fix may not be included in next release.type: bugError or flaw in code with unintended results or allowing sub-optimal usage patterns.

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions