mini lab : BigQuery : 5 Problems

[kdambiec]

...

[kalpeshdhotre]

@kdambiec Yes facing same problem! have you reported?

[RAOKS]

Just now checked lab and all tasks are working fine. I am able complete lab

[Sbf_y]

Used the following query but task 2 doesn't work, task 3 is checked though..

CREATE OR REPLACE TABLE \`${PROJECT_ID}.${DATASET_NAME}.${MALE_TABLE_NAME}\` AS
SELECT *
FROM \`${PROJECT_ID}.${DATASET_NAME}.${TABLE_NAME}\`
WHERE Gender = 'Male'

[Sbf_y]

Well, apparently it only need CustomerID, Gender but didn't indicate as required in the instruction...

This works
bq query --use_legacy_sql=false 'CREATE OR REPLACE TABLE customer_details.male_customers AS SELECT CustomerID, Gender FROM customer_details.customers WHERE Gender = "Male"'

[RAOKS]

mini lab : BigQuery : 5 -Solution code