Issue creating table partition by date with data from other table. In Google Cloud

Viewed 17

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") )
0 Answers
Related