BigQuery を使った請求データの検証 のレビュー

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

Holtan Jon · 8年弱前にレビュー済み

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

Holtan Jon · 8年弱前にレビュー済み

Saúl Noriega Iriondo José · 8年弱前にレビュー済み

OUMA TONNY · 8年弱前にレビュー済み

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.

Carr Todd · 8年弱前にレビュー済み

Palomäki Jukka · 8年弱前にレビュー済み

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.

Geesaman Brad · 8年弱前にレビュー済み

Silva Evandro · 8年弱前にレビュー済み

Villard Pierre · 8年弱前にレビュー済み

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.

Dunetz Kevin · 8年弱前にレビュー済み

Carmichael Chris · 8年弱前にレビュー済み

Falvo Thierry · 8年弱前にレビュー済み

X H LIU Fey · 8年弱前にレビュー済み

Its a good lab

J GAVANDAR Mahesh · 8年弱前にレビュー済み

I reported this lab. Kindly check

Gomez Gerald · 8年弱前にレビュー済み

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)

Kunc Ondrej · 8年弱前にレビュー済み

2

Heredia Luis · 8年弱前にレビュー済み

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

Chatelain yann · 8年弱前にレビュー済み

Racherla Ashwin · 8年弱前にレビュー済み

Velasquez Daniel · 8年弱前にレビュー済み

Faesi Herman · 8年弱前にレビュー済み

Thank you for the good lab

Jerome Jerome · 8年弱前にレビュー済み

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

Gallegos David · 8年弱前にレビュー済み

Bauer Lucas · 8年弱前にレビュー済み

Gavagiuc Cosmin · 8年弱前にレビュー済み