Examining Billing data with BigQuery Reviews

The BigQuery Auto importer for the CSV dataset did not create the columns correctly. Everything was a string

Jon H. · Reviewed ما يقرب من 8 سنوات ago

The BigQuery Auto importer for the CSV dataset did not create the columns correctly. Everything was a string

Jon H. · Reviewed ما يقرب من 8 سنوات ago

José S. · Reviewed ما يقرب من 8 سنوات ago

TONNY O. · Reviewed ما يقرب من 8 سنوات ago

The query structure in BigQuery has altered significantly such that none of the existing queries are valid anymore. The column names after import are not always automatically updated, meaning string_column_8 is needed to be used instead of "cost" for the first several. Angle brackets are no longer valid syntax, and the interface is now wildly different.

Todd C. · Reviewed ما يقرب من 8 سنوات ago

Jukka P. · Reviewed ما يقرب من 8 سنوات ago

The instructions are for the legacy UI and the syntax for all the queries require backticks instead of brackets around the column name in the new UI. Also, the import initially shows 45 rows in the new UI because the auto schema detection doesn't strip the header row. If new instructions are created, the advanced options of "remove 1 header" are needed.

Brad G. · Reviewed ما يقرب من 8 سنوات ago

Evandro S. · Reviewed ما يقرب من 8 سنوات ago

Pierre V. · Reviewed ما يقرب من 8 سنوات ago

SQL Queries not correct in the lab...please review..need ` instead of [....also need to tell user to set Skip 1 row..otherwise you don't get the headers. Fix small query and big queries.

Kevin D. · Reviewed ما يقرب من 8 سنوات ago

Chris C. · Reviewed ما يقرب من 8 سنوات ago

Thierry F. · Reviewed ما يقرب من 8 سنوات ago

Fey X. · Reviewed ما يقرب من 8 سنوات ago

Its a good lab

Mahesh J. · Reviewed ما يقرب من 8 سنوات ago

I reported this lab. Kindly check

Gerald G. · Reviewed ما يقرب من 8 سنوات ago

lab is nice, but the copy/paste reference uses [] instead of `` and the WHERE clauses also fail as they should be refered in short name - at least that's how I got it working. :] e.g. I used WHERE (cost > 0) instead of WHERE ([cloud-training-prod-bucket.arch_infra.billing_data.cost] > 0)

Ondrej K. · Reviewed ما يقرب من 8 سنوات ago

2

Luis H. · Reviewed ما يقرب من 8 سنوات ago

Lab doesn't work properly with the new BigQuery UI (table generation is not typed by ex)

yann C. · Reviewed ما يقرب من 8 سنوات ago

Ashwin R. · Reviewed ما يقرب من 8 سنوات ago

Daniel V. · Reviewed ما يقرب من 8 سنوات ago

Herman F. · Reviewed ما يقرب من 8 سنوات ago

Thank you for the good lab

Jerome J. · Reviewed ما يقرب من 8 سنوات ago

Task 4: Use larger data - None of these queries work.

David G. · Reviewed ما يقرب من 8 سنوات ago

Lucas B. · Reviewed ما يقرب من 8 سنوات ago

Cosmin G. · Reviewed ما يقرب من 8 سنوات ago