리뷰 Configuring, Using, and Auditing VM Service Accounts and Scopes개

I was getting stuck on the last step. Service account had all required access but I could not verify. Boot disk required in the lab was not available.

Zack V. · 대략 1년 전에 리뷰됨

Issue with student-01-e50d83278aae@bigquery-instance:~$ python3 query.py A module that was compiled using NumPy 1.x cannot be run in NumPy 2.0.0 as it may crash. To support both 1.x and 2.x versions of NumPy, modules must be compiled with NumPy 2.0. Some module may need to rebuild instead e.g. with 'pybind11>=2.12'. If you are a user of the module, the easiest solution will be to downgrade to 'numpy<2' or try to upgrade the affected module. We expect that some modules will need time to support NumPy 2.

Bharatkumar P. · 대략 1년 전에 리뷰됨

i have a problem with "Please make a request to BigQuery public dataset with a 'bigquery-qwiklab' service account."

Edison D. · 대략 1년 전에 리뷰됨

Nataliia R. · 대략 1년 전에 리뷰됨

Dad p. · 대략 1년 전에 리뷰됨

Sai S. · 대략 1년 전에 리뷰됨

HAYYYSST

Jerald C. · 대략 1년 전에 리뷰됨

Zaki Zarkasih Al M. · 대략 1년 전에 리뷰됨

Jonas C. · 대략 1년 전에 리뷰됨

This lab is HORRENDOUS. The instructions are TRASH. First - it says to use Debian 10. This is not even an option in GCP anymore. Only 11 and 12. The python setup instructions are AWFUL. These could not have actually been tested. It's impossible. First off, installing all these packages system-wide as root is terrible practice. The instructions should have the user install venv and setup a virtual environment. Newer systems will refuse to install modules at the system level using pip, so these commands won't even work. For simplicity's sake, all of the pip install commands can be run on a single line. You don't need to make people copy/paste ten different lines. And then, the worst part, this code won't even run due to incompatibilities in libraries. NumPy < 2.0 is required, but won't be installed by these instructions. It has to manually be specified using pip. How do you expect people to learn when you provide such garbage instructions? These need to be updated, they clearly haven't been touched in years.

Chris M. · 대략 1년 전에 리뷰됨

Giovanni D. · 대략 1년 전에 리뷰됨

debian 10 no longer exist - there is only debian 11 or 12 to choose

Konrad S. · 대략 1년 전에 리뷰됨

pip3 commands not working

Jasim A. · 대략 1년 전에 리뷰됨

Tom K. · 대략 1년 전에 리뷰됨

pip commands are not working as is, need to use sudo apt install python3.11-venv && python3 -m venv my-venv and then use my-venv/bin/pip install

Aleksey B. · 대략 1년 전에 리뷰됨

Liane A. · 대략 1년 전에 리뷰됨

Eñaut Z. · 대략 1년 전에 리뷰됨

Can't choose Debian 10 image and many errors like that If you are a user of the module, the easiest solution will be to downgrade to 'numpy<2' or try to upgrade the affected module. We expect that some modules will need time to support NumPy 2. Traceback (most recent call last): File "/home/student-02-af562455dd2a/query.py", line 3, in <module> from google.cloud import bigquery File "/usr/local/lib/python3.9/dist-packages/google/cloud/bigquery/__init__.py", line 35, in <module> from google.cloud.bigquery.client import Client File "/usr/local/lib/python3.9/dist-packages/google/cloud/bigquery/client.py", line 69, in <module> from google.cloud.bigquery import _job_helpers File "/usr/local/lib/python3.9/dist-packages/google/cloud/bigquery/_job_helpers.py", line 47, in <module> from google.cloud.bigquery import job File "/usr/local/lib/python3.9/dist-packages/google/cloud/bigquery/job/__init__.py", line 27, in <module> from google.cloud.bigquery.job.copy_ import CopyJob File "/usr/local/lib/python3.9/dist-packages/google/cloud/bigquery/job/copy_.py", line 22, in <module> from google.cloud.bigquery.table import TableReference File "/usr/local/lib/python3.9/dist-packages/google/cloud/bigquery/table.py", line 62, in <module> from google.cloud.bigquery import _pandas_helpers File "/usr/local/lib/python3.9/dist-packages/google/cloud/bigquery/_pandas_helpers.py", line 42, in <module> import db_dtypes # type: ignore File "/usr/local/lib/python3.9/dist-packages/db_dtypes/__init__.py", line 27, in <module> import pyarrow File "/usr/local/lib/python3.9/dist-packages/pyarrow/__init__.py", line 63, in <module> import pyarrow.lib as _lib AttributeError: _ARRAY_API not found A module that was compiled using NumPy 1.x cannot be run in NumPy 2.0.0 as it may crash. To support both 1.x and 2.x versions of NumPy, modules must be compiled with NumPy 2.0. Some module may need to rebuild instead e.g. with 'pybind11>=2.12'. If you are a user of the module, the easiest solution will be to downgrade to 'numpy<2' or try to upgrade the affected module. We expect that some modules will need time to support NumPy 2. Traceback (most recent call last): File "/home/student-02-af562455dd2a/query.py", line 3, in <module> from google.cloud import bigquery File "/usr/local/lib/python3.9/dist-packages/google/cloud/bigquery/__init__.py", line 35, in <module> from google.cloud.bigquery.client import Client File "/usr/local/lib/python3.9/dist-packages/google/cloud/bigquery/client.py", line 69, in <module> from google.cloud.bigquery import _job_helpers File "/usr/local/lib/python3.9/dist-packages/google/cloud/bigquery/_job_helpers.py", line 47, in <module> from google.cloud.bigquery import job File "/usr/local/lib/python3.9/dist-packages/google/cloud/bigquery/job/__init__.py", line 27, in <module> from google.cloud.bigquery.job.copy_ import CopyJob File "/usr/local/lib/python3.9/dist-packages/google/cloud/bigquery/job/copy_.py", line 22, in <module> from google.cloud.bigquery.table import TableReference File "/usr/local/lib/python3.9/dist-packages/google/cloud/bigquery/table.py", line 62, in <module> from google.cloud.bigquery import _pandas_helpers File "/usr/local/lib/python3.9/dist-packages/google/cloud/bigquery/_pandas_helpers.py", line 52, in <module> pyarrow = _versions_helpers.PYARROW_VERSIONS.try_import() File "/usr/local/lib/python3.9/dist-packages/google/cloud/bigquery/_versions_helpers.py", line 78, in try_import import pyarrow File "/usr/local/lib/python3.9/dist-packages/pyarrow/__init__.py", line 63, in <module> import pyarrow.lib as _lib AttributeError: _ARRAY_API not found A module that was compiled using NumPy 1.x cannot be run in NumPy 2.0.0 as it may crash. To support both 1.x and 2.x versions of NumPy, modules must be compiled with NumPy 2.0. Some module may need to rebuild instead e.g. with 'pybind11>=2.12'. If you are a user of the module, the easiest solution will be to downgrade to 'numpy<2' or try to upgrade the affected module. We expect that some modules will need time to support NumPy 2. Traceback (most recent call last): File "/home/student-02-af562455dd2a/query.py", line 3, in <module> from google.cloud import bigquery File "/usr/local/lib/python3.9/dist-packages/google/cloud/bigquery/__init__.py", line 35, in <module> from google.cloud.bigquery.client import Client File "/usr/local/lib/python3.9/dist-packages/google/cloud/bigquery/client.py", line 124, in <module> pyarrow = _versions_helpers.PYARROW_VERSIONS.try_import() File "/usr/local/lib/python3.9/dist-packages/google/cloud/bigquery/_versions_helpers.py", line 78, in try_import import pyarrow File "/usr/local/lib/python3.9/dist-packages/pyarrow/__init__.py", line 63, in <module> import pyarrow.lib as _lib AttributeError: _ARRAY_API not found Traceback (most recent call last): File "/usr/local/lib/python3.9/dist-packages/google/cloud/bigquery/_pandas_helpers.py", line 42, in <module> import db_dtypes # type: ignore File "/usr/local/lib/python3.9/dist-packages/db_dtypes/__init__.py", line 27, in <module> import pyarrow File "/usr/local/lib/python3.9/dist-packages/pyarrow/__init__.py", line 63, in <module> import pyarrow.lib as _lib File "pyarrow/lib.pyx", line 35, in init pyarrow.lib ImportError: numpy.core.multiarray failed to import The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/student-02-af562455dd2a/query.py", line 23, in <module> print(client.query(query).to_dataframe()) File "/usr/local/lib/python3.9/dist-packages/google/cloud/bigquery/job/query.py", line 2053, in to_dataframe return query_result.to_dataframe( File "/usr/local/lib/python3.9/dist-packages/google/cloud/bigquery/table.py", line 2287, in to_dataframe _pandas_helpers.verify_pandas_imports() File "/usr/local/lib/python3.9/dist-packages/google/cloud/bigquery/_pandas_helpers.py", line 1024, in verify_pandas_imports raise ValueError(_NO_DB_TYPES_ERROR) from db_dtypes_import_exception ValueError: Please install the 'db-dtypes' package to use this function

Lassina D. · 대략 1년 전에 리뷰됨

VIJAY K. · 대략 1년 전에 리뷰됨

Amira I. · 대략 1년 전에 리뷰됨

there is no debian 10 boot image

Bala s. · 대략 1년 전에 리뷰됨

Jason R. · 대략 1년 전에 리뷰됨

Deepesh W. · 대략 1년 전에 리뷰됨

COREY W. · 대략 1년 전에 리뷰됨