Google Cloud Fundamentals: Getting Started with BigQuery Reviews

Keerthi J. · Reviewed over 5 years ago

Saiyam G. · Reviewed over 5 years ago

Sourabh S. · Reviewed over 5 years ago

Vincent O. · Reviewed over 5 years ago

Bhuwan C. · Reviewed over 5 years ago

Gordon H. · Reviewed over 5 years ago

Aksharada A. · Reviewed over 5 years ago

Ankur B. · Reviewed over 5 years ago

Paul G. · Reviewed over 5 years ago

Wasim M. · Reviewed over 5 years ago

DENNIS O. · Reviewed over 5 years ago

Houston H. · Reviewed over 5 years ago

Jose d. · Reviewed over 5 years ago

Mike C. · Reviewed over 5 years ago

I loaded the csv file into BigQuery but the "check status" didn't give me the green tick. Not sure why it isn't working. Here is the proof I have loaded successfully by running the bq command in cloud shell: Welcome to Cloud Shell! Type "help" to get started. To set your Cloud Platform project in this session use “gcloud config set project [PROJECT_ID]” student_04_20f2629c8371@cloudshell:~$ bq query "select string_field_10 as request, count(*) as requestcount from logdata.accesslog group by request order by requestcount desc" BigQuery error in query operation: Cannot start a job without a project id. student_04_20f2629c8371@cloudshell:~$ gcloud config set project qwiklabs-gcp-04-e897145ce51d Updated property [core/project]. student_04_20f2629c8371@cloudshell:~ (qwiklabs-gcp-04-e897145ce51d)$ bq query "select string_field_10 as request, count(*) as requestcount from logdata.accesslog group by request order by reques tcount desc" Waiting on bqjob_r4998024264c00333_000001785d017d3b_1 ... (0s) Current status: DONE +----------------------------------------+--------------+ | request | requestcount | +----------------------------------------+--------------+ | GET /store HTTP/1.0 | 337293 | | GET /index.html HTTP/1.0 | 336193 | | GET /products HTTP/1.0 | 280937 | | GET /services HTTP/1.0 | 169090 | | GET /products/desserttoppings HTTP/1.0 | 56580 | | GET /products/floorwaxes HTTP/1.0 | 56451 | | GET /careers HTTP/1.0 | 56412 | | GET /services/turnipwinding HTTP/1.0 | 56401 | | GET /services/spacetravel HTTP/1.0 | 56176 | | GET /favicon.ico HTTP/1.0 | 55845 | +----------------------------------------+--------------+ student_04_20f2629c8371@cloudshell:~ (qwiklabs-gcp-04-e897145ce51d)$

Sudarmo S. · Reviewed over 5 years ago

My progress hasn't been recorded, in spite of having followed the instructions word by word, multiple times. UDATE - I was able to complete the lab by closing and restarting it.

Daniele　Mancuso D. · Reviewed over 5 years ago

Dilum K. · Reviewed over 5 years ago

cannot check my progress, Even I complete task2 it shows zero

Dilum K. · Reviewed over 5 years ago

My progress hasn't been recorded, in spite of having followed the instructions word by word, multiple times.

Daniele　Mancuso D. · Reviewed over 5 years ago

Anton P. · Reviewed over 5 years ago

Nickil N. · Reviewed over 5 years ago

great lab

Manuel I. · Reviewed over 5 years ago

WIlliams G. · Reviewed over 5 years ago

Amar W. · Reviewed over 5 years ago

Bruno R. · Reviewed over 5 years ago