Google Certified Professional Data Engineer

Sign Up Free or Log In to participate!

BigQuery

what is OPTIONS in  BigQuery

Sudhakar H

here while quering

Sudhakar H

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

Sudhakar H

we used OPIONS to perform parttition by dates and hint for expiration needs to considered as 60 days

0 Answers

Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!

Get Started
Who’s going to be learning?