mini lab : BigQuery : 5 Problems

[kdambiec]

Has anyone been able to complete mini lab: Big Query 5?
When I do the lab I am able to create a table containing the male_customers and export it successfully, but when I go to check my progress the progress check is only successful for task 1 and task 3, but it keeps failing for task 3 even though the table has been created.

I'm also able to run a query against the male_customers table

[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