Service Accounts and Roles: Fundamentals Reviews

Macoumba N. · Reviewed 4 ay ago

It worked 100%

Alexis T. · Reviewed 4 ay ago

Problem with Lab "Service Accounts and Roles: Fundamentals" Following instructions to the letter, but when get to the last task: The application now uses the permissions that are associated with this service account. Run the query with the following Python command: python3 query.py The query should return the following output (your numbers may vary): Row year num_babies 0 2008 4255156 1 2006 4273225 2 2003 4096092 3 2004 4118907 4 2002 4027376 5 2005 4145619 6 2001 4031531 7 2007 4324008 HOWEVER When I run: python3 query.py I get the following: Traceback (most recent call last): File "/home/student-03-ff24639a1aa9/query.py", line 23, in <module> print(client.query(query).to_dataframe()) File "/home/student-03-ff24639a1aa9/.local/lib/python3.9/site-packages/google/cloud/bigquery/job/query.py", line 2052, in to_dataframe query_result = wait_for_query(self, progress_bar_type, max_results=max_results) File "/home/student-03-ff24639a1aa9/.local/lib/python3.9/site-packages/google/cloud/bigquery/_tqdm_helpers.py", line 107, in wait_for_query return query_job.result(max_results=max_results) File "/home/student-03-ff24639a1aa9/.local/lib/python3.9/site-packages/google/cloud/bigquery/job/query.py", line 1676, in result while not is_job_done(): File "/home/student-03-ff24639a1aa9/.local/lib/python3.9/site-packages/google/api_core/retry/retry_unary.py", line 293, in retry_wrapped_func return retry_target( File "/home/student-03-ff24639a1aa9/.local/lib/python3.9/site-packages/google/api_core/retry/retry_unary.py", line 153, in retry_target _retry_error_helper( File "/home/student-03-ff24639a1aa9/.local/lib/python3.9/site-packages/google/api_core/retry/retry_base.py", line 212, in _retry_error_helper raise final_exc from source_exc File "/home/student-03-ff24639a1aa9/.local/lib/python3.9/site-packages/google/api_core/retry/retry_unary.py", line 144, in retry_target result = target() File "/home/student-03-ff24639a1aa9/.local/lib/python3.9/site-packages/google/cloud/bigquery/job/query.py", line 1625, in is_job_done raise job_failed_exception google.api_core.exceptions.Forbidden: 403 Access Denied: BigQuery BigQuery: Missing required OAuth scope. Need BigQuery or Cloud Platform read scope.; reason: accessDenied, message: Access Denied: BigQuery BigQuery: Missing required OAuth scope. Need BigQuery or Cloud Platform read scope. Location: US Job ID: f03818d0-3432-4f71-b218-023895c6acb9 Again, followed instructions to the letter, and followed a video on YouTube and matched what they do move for move, but it WILL NOT VERIFY for me. What is going on?

Paul W. · Reviewed 4 ay ago

Felix K. · Reviewed 4 ay ago

We need to add scopes to the VM instance. This step was not mentioned in this lab

Dilip M. · Reviewed 4 ay ago

Mazhar K. · Reviewed 4 ay ago

Wylliams Diogo L. · Reviewed 4 ay ago

Gabriela D. · Reviewed 4 ay ago

Please resolve issue

Luxmi G. · Reviewed 4 ay ago

Rajesh T. · Reviewed 4 ay ago

Steven K. · Reviewed 4 ay ago

Devang S. · Reviewed 4 ay ago

Anusha Lakshmi V. · Reviewed 4 ay ago

Nagarajan R. · Reviewed 4 ay ago

Veilu M. · Reviewed 4 ay ago

Ashwathy J. · Reviewed 4 ay ago

wrong instruction. we need to set BigQuery on enable mode in API settings, and all command: pip3 install --upgrade pip pip3 install google-cloud-bigquery pip3 install pyarrow pip3 install pandas pip3 install db-dtypes implemended under the virtual enviroment only

Evgeny M. · Reviewed 4 ay ago

abhishek t. · Reviewed 4 ay ago

Good lab.

Adiyot Kaunkaew -. · Reviewed 4 ay ago

Gilberto M. · Reviewed 4 ay ago

Srujan K. · Reviewed 4 ay ago

Sarath J. · Reviewed 4 ay ago

durgalakshmi s. · Reviewed 4 ay ago

Bal Kishan R. · Reviewed 4 ay ago

Andrew S. · Reviewed 4 ay ago