I'm doing a course from Google. Modernizing Data Lakes and Data Warehouses. And in the quest they ask to create a partition table and populate all the info from the source table, I execute my code, the table is created but empty. I also try to create empty table and next insert, and also no info in my table., in this case the log says that are inserted: XXX lines. But when I check the preview, or I query a SELECT *, my table is still empty. Please, why is happening this? Help!
#standardSQL
CREATE OR REPLACE TABLE
covid_598.oxford_policy_tracker_527
PARTITION BY
date OPTIONS ( partition_expiration_days=360 ) AS (
SELECT
oxford.*
FROM
bigquery-public-data.covid19_govt_response AS oxford
WHERE
alpha_3_code NOT IN ("GBR",
"BRA",
"CAN",
"USA") )