Sign Up Free or Log In to participate!
what is OPTIONS in BigQuery
here while quering
CREATE OR REPLACE TABLE us_dataset.air_quality PARTITION BY DATE(timestamp) OPTIONS (partition_expiration_days=60) AS SELECT * FROM bigquery-public-data.openaq.global_air_quality
we used OPIONS to perform parttition by dates and hint for expiration needs to considered as 60 days
Psst…this one if you’ve been moved to ACG!
Don't have an account?