Vertex AI 2.5 の JupyterLab で BigQuery を利用する のレビュー

Thota Jagadeesh · 3年以上前にレビュー済み

Thota Jagadeesh · 3年以上前にレビュー済み

Pallavi Pallavi · 3年以上前にレビュー済み

Grzesinski Marcin · 3年以上前にレビュー済み

Outdated lab throwing an error when running BigQuery query: it says that the default BigQuery storage API client cannot be used. The lab must include the `--use_rest_api` magic option for it to work.

Tonato Ramon · 3年以上前にレビュー済み

--------------------------------------------------------------------------- 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) 709 try: --> 710 from google.cloud import bigquery_storage # noqa: F401 711 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_8367/2264461258.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) 579 580 bqstorage_client = _make_bqstorage_client( --> 581 client, use_bqstorage_api, bqstorage_client_options, 582 ) 583 /opt/conda/lib/python3.7/site-packages/google/cloud/bigquery/magics/magics.py in _make_bqstorage_client(client, use_bqstorage_api, client_options) 716 "the --use_rest_api magic option." 717 ) --> 718 raise customized_error from err 719 720 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.

Abhishek Gaurav · 3年以上前にレビュー済み

It just woks

Moriyama Takuro · 3年以上前にレビュー済み

Ong Gabriel · 3年以上前にレビュー済み

Dhubey Ankit · 3年以上前にレビュー済み

Palanivelu Prakash · 3年以上前にレビュー済み

sake sireesha · 3年以上前にレビュー済み

タスク 2. BigQuery クエリを実行する ノートブックの最初のセルでShift + Enterを押して、次の Python インストール コマンドを実行しgoogle-cloud-bigquery、バージョンのライブラリをインストールし2.30.0ます。 上記の内容を実施することができませんでした。

yu to · 3年以上前にレビュー済み

Syed Sohail · 3年以上前にレビュー済み

Dhubey Ankit · 3年以上前にレビュー済み

Valverde Llanos Norberto · 3年以上前にレビュー済み

k sreekanth · 3年以上前にレビュー済み

the view seems changed, the way to find notebook through vertex AI differs somehow. Besides, the notebook seems require the installation of `google-cloud-bigquery-storage` and `pyarrow` to launch use of `bigquery`

Zhou Guangting · 3年以上前にレビュー済み

murugan senthil · 3年以上前にレビュー済み

GOOGLEUSER G - Tavo · 3年以上前にレビュー済み

Error while running code in Notebook. Couldn't complete the lab. Please fix the errors.

Thipparthy Raghuram · 3年以上前にレビュー済み

Alexandra Almeida Carvalho Catarina · 3年以上前にレビュー済み

Lab didnt work as expected as google cloud bigquery storage library was not installed as part of the pip install command. Needed to run !pip install google-cloud-bigquery-storage Then it worked fine.

Lees James · 3年以上前にレビュー済み

Gugan R · 3年以上前にレビュー済み

Gugan R · 3年以上前にレビュー済み

Task 2. Execute a BigQuery query 3. Enter the following query in the second cell of the notebook: %%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 IMPORT ERROR: --------------------------------------------------------------------------- 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) 709 try: --> 710 from google.cloud import bigquery_storage # noqa: F401 711 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_7047/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) 579 580 bqstorage_client = _make_bqstorage_client( --> 581 client, use_bqstorage_api, bqstorage_client_options, 582 ) 583 /opt/conda/lib/python3.7/site-packages/google/cloud/bigquery/magics/magics.py in _make_bqstorage_client(client, use_bqstorage_api, client_options) 716 "the --use_rest_api magic option." 717 ) --> 718 raise customized_error from err 719 720 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. HELP PLEASE ?

Brawenec Manuel · 3年以上前にレビュー済み