BigQuery in JupyterLab on Vertex AI Reviews

Shakaib K. · Reviewed over 5 years ago

pok

Raihan N. · Reviewed over 5 years ago

Hiroaki S. · Reviewed over 5 years ago

Raihan N. · Reviewed over 5 years ago

Problem with %%bigquery df https://www.coursera.org/learn/smart-analytics-machine-learning-ai-gcp/discussions/weeks/1/threads/HME_vu4nRIKBP77uJ4SClw

Przemysław D. · Reviewed over 5 years ago

Shakaib K. · Reviewed over 5 years ago

error occurred! 626 # is available and can be imported. 627 from google.cloud import bigquery_storage_v1 --> 628 from google.cloud import bigquery_storage_v1beta1 629 630 if "$" in table.table_id: ImportError: cannot import name 'bigquery_storage_v1beta1' from 'google.cloud' (unknown location)

강희 이. · Reviewed over 5 years ago

Juan S. · Reviewed over 5 years ago

execute a bigquery query give this reply--------------------------------------------------------------------------- ImportError Traceback (most recent call last) /opt/conda/lib/python3.7/site-packages/google/cloud/bigquery/magics.py in _make_bqstorage_client(use_bqstorage_api, credentials) 605 try: --> 606 from google.cloud import bigquery_storage_v1 607 except ImportError as err: ImportError: cannot import name 'bigquery_storage_v1' from 'google.cloud' (unknown location) The above exception was the direct cause of the following exception: ImportError Traceback (most recent call last) <ipython-input-1-eebd8689873d> in <module> ----> 1 get_ipython().run_cell_magic('bigquery', 'df', 'SELECT name, SUM(number) as count\nFROM `bigquery-public-data.usa_names.usa_1910_current`\nGROUP BY name\nORDER BY count DESC\nLIMIT 10\n') /opt/conda/lib/python3.7/site-packages/IPython/core/interactiveshell.py in run_cell_magic(self, magic_name, line, cell) 2369 with self.builtin_trap: 2370 args = (magic_arg_s, cell) -> 2371 result = fn(*args, **kwargs) 2372 return result 2373 /opt/conda/lib/python3.7/site-packages/google/cloud/bigquery/magics.py in _cell_magic(line, query) 505 if context._connection: 506 client._connection = context._connection --> 507 bqstorage_client = _make_bqstorage_client(use_bqstorage_api, context.credentials) 508 509 close_transports = functools.partial(_close_transports, client, bqstorage_client) /opt/conda/lib/python3.7/site-packages/google/cloud/bigquery/magics.py in _make_bqstorage_client(use_bqstorage_api, credentials) 612 "the --use_rest_api magic option." 613 ) --> 614 six.raise_from(customized_error, err) 615 616 try: /opt/conda/lib/python3.7/site-packages/six.py in raise_from(value, from_value) ImportError: The default BigQuery Storage API client cannot be used, install the missing google-cloud-bigquery-storage and pyarrow packages to use it. Alternatively, use the classic REST API by specifying the --use_rest_api magic option.

Vaibhav M. · Reviewed over 5 years ago

jean-luc L. · Reviewed over 5 years ago

pb of the notebook: ImportError: The default BigQuery Storage API client cannot be used, install the missing google-cloud-bigquery-storage and pyarrow packages to use it. Alternatively, use the classic REST API by specifying the --use_rest_api magic option.

Shania X. · Reviewed over 5 years ago

awesome

Kiran E. · Reviewed over 5 years ago

Stefan P. · Reviewed over 5 years ago

lab has technical issue

Gourab D. · Reviewed over 5 years ago

Jenil P. · Reviewed over 5 years ago

Supplied Qwiklab Jupyter Notebook not installed with Big Query leading to query failures, connection failures. Could not complete lab.

Timothy L. · Reviewed over 5 years ago

Denis Apolinario S. · Reviewed over 5 years ago

Catalina V. · Reviewed over 5 years ago

Jyothi B. · Reviewed over 5 years ago

dont work

flavio A. · Reviewed over 5 years ago

some problems running the code

Hermes J. · Reviewed over 5 years ago

Kieran K. · Reviewed over 5 years ago

didnt work

Sebastián F. · Reviewed over 5 years ago