BigQuery in JupyterLab on Agent Platform 2.5 Reviews

Miguel I. · Reviewed over 3 years ago

Xiaowu Z. · Reviewed over 3 years ago

Li-Hsien L. · Reviewed over 3 years ago

Dzmitry S. · Reviewed over 3 years ago

This lab should be more complete.

Jose M. · Reviewed over 3 years ago

chandrasekhar rao s. · Reviewed over 3 years ago

no ejecuta el siguiente código da error: %%bigquery df SELECT depdelay as departure_delay, COUNT(1) AS num_flights, APPROX_QUANTILES(arrdelay, 10) AS arrival_delay_deciles FROM `cloud-training-demos.airline_ontime_data.flights` WHERE depdelay is not null GROUP BY depdelay HAVING num_flights > 100 ORDER BY depdelay ASC -------------------------------------------------------------------------- ImportError Traceback (most recent call last) /opt/conda/lib/python3.7/site-packages/google/cloud/bigquery/magics/magics.py in _make_bqstorage_client(client, use_bqstorage_api, client_options) 750 try: --> 751 from google.cloud import bigquery_storage # type: ignore # noqa: F401 752 except ImportError as err: ImportError: cannot import name 'bigquery_storage' from 'google.cloud' (unknown location) The above exception was the direct cause of the following exception: ImportError Traceback (most recent call last) /tmp/ipykernel_7292/1327333500.py in <module> ----> 1 get_ipython().run_cell_magic('bigquery', 'df', 'SELECT\n depdelay as departure_delay,\n COUNT(1) AS num_flights,\n APPROX_QUANTILES(arrdelay, 10) AS arrival_delay_deciles\nFROM\n `cloud-training-demos.airline_ontime_data.flights`\nWHERE\n depdelay is not null\nGROUP BY\n depdelay\nHAVING\n num_flights > 100\nORDER BY\n depdelay ASC\n') /opt/conda/lib/python3.7/site-packages/IPython/core/interactiveshell.py in run_cell_magic(self, magic_name, line, cell) 2471 with self.builtin_trap: 2472 args = (magic_arg_s, cell) -> 2473 result = fn(*args, **kwargs) 2474 return result 2475 /opt/conda/lib/python3.7/site-packages/google/cloud/bigquery/magics/magics.py in _cell_magic(line, query) 592 client, 593 use_bqstorage_api, --> 594 bqstorage_client_options, 595 ) 596 /opt/conda/lib/python3.7/site-packages/google/cloud/bigquery/magics/magics.py in _make_bqstorage_client(client, use_bqstorage_api, client_options) 757 "the --use_rest_api magic option." 758 ) --> 759 raise customized_error from err 760 761 try: 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. ​ Simple 0 1 Python 3 | Idle

Jorge P. · Reviewed over 3 years ago

Mateusz N. · Reviewed over 3 years ago

Daniel P. · Reviewed over 3 years ago

Abhijeet S. · Reviewed over 3 years ago

Gaurav N. · Reviewed over 3 years ago

Ayshwarya M. · Reviewed over 3 years ago

Deepak B. · Reviewed over 3 years ago

Muhammed T. · Reviewed over 3 years ago

Ramandeep K. · Reviewed over 3 years ago

Thanks

Sahayam J. · Reviewed over 3 years ago

Moeka N. · Reviewed over 3 years ago

Mohammad Aamir A. · Reviewed over 3 years ago

Mirosław S. · Reviewed over 3 years ago

Naruenat T. · Reviewed over 3 years ago

chitrashalini s. · Reviewed over 3 years ago

Prasad S. · Reviewed over 3 years ago

Quick introduction to running Jupyter notebook in Vertex AI, run a simple BigQuery query and working with pandas dataframe.

Kaiquan M. · Reviewed over 3 years ago

Kouadio K. · Reviewed over 3 years ago

awesome

SENTHILKUMAAR S. · Reviewed over 3 years ago