Skip to content

BigQuery: Table.from_string() doesn't support GCP project ID with org prefix #7827

@salvador-bynd

Description

@salvador-bynd

Environment details

  1. BigQuery
  2. Google App-Engine standard (Python 2.7)
  3. Python 2.7
  4. google-cloud-bigquery==1.10.0

Code example

from google.cloud import bigquery from google.cloud.bigquery import Table # Standard SQL (works fine) # SELECT * FROM `google.com:my-project.mydataset.mytable` LIMIT 1 # Works fine table = Table.from_string('my-project.mydataset.mytable') # Fails table = Table.from_string('google.com:my-project.mydataset.mytable') Traceback (most recent call last): File "<stdin>", line 1, in <module> File "/tmp/vv/local/lib/python2.7/site-packages/google/cloud/bigquery/table.py", line 815, in from_string return cls(TableReference.from_string(full_table_id)) File "/tmp/vv/local/lib/python2.7/site-packages/google/cloud/bigquery/table.py", line 246, in from_string "got {}".format(table_id) ValueError: Too many parts in table_id. Must be a fully-qualified table ID in standard SQL format. e.g. "project.dataset.table", got google.com:my-project.mydataset.mytable

Metadata

Metadata

Assignees

Labels

api: bigqueryIssues related to the BigQuery API.type: feature request‘Nice-to-have’ improvement, new feature or different behavior or design.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions