Opiniones sobre Configuración, uso y revisión de las cuentas de servicio y los permisos de las VMs

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. · Se revisó hace alrededor de 1 año

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. · Se revisó hace alrededor de 1 año

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

Edison D. · Se revisó hace alrededor de 1 año

Nataliia R. · Se revisó hace alrededor de 1 año

Dad p. · Se revisó hace alrededor de 1 año

Sai S. · Se revisó hace alrededor de 1 año

HAYYYSST

Jerald C. · Se revisó hace alrededor de 1 año

Zaki Zarkasih Al M. · Se revisó hace alrededor de 1 año

Jonas C. · Se revisó hace alrededor de 1 año

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. · Se revisó hace alrededor de 1 año

Giovanni D. · Se revisó hace alrededor de 1 año

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

Konrad S. · Se revisó hace alrededor de 1 año

pip3 commands not working

Jasim A. · Se revisó hace alrededor de 1 año

Tom K. · Se revisó hace alrededor de 1 año

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. · Se revisó hace alrededor de 1 año

Liane A. · Se revisó hace alrededor de 1 año

Eñaut Z. · Se revisó hace alrededor de 1 año

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. · Se revisó hace alrededor de 1 año

VIJAY K. · Se revisó hace alrededor de 1 año

Amira I. · Se revisó hace alrededor de 1 año

there is no debian 10 boot image

Bala s. · Se revisó hace alrededor de 1 año

Jason R. · Se revisó hace alrededor de 1 año

Deepesh W. · Se revisó hace alrededor de 1 año

COREY W. · Se revisó hace alrededor de 1 año