Can we add require partition filter to table in biq query?

Completed

Follow

Labinot Dvorani

August 16, 2022 16:30

Hi Team, 

would this be an effective way of forcing users to add a partition condition to their queries in Big Query in an attempt to help keep query costs down?

Also, would this be removed when tables/views are updated?

ALTER TABLE mydataset.mypartitionedtable
  SET OPTIONS (
    require_partition_filter = true);

https://cloud.google.com/bigquery/docs/managing-partitioned-tables#sql_1

0

• Official comment

  

  Sarath Botlagunta August 16, 2022 17:32

  Thats correct. Unless table is dropped and recreated or this property is specifically updated, it should persist.

  Comment actions Permalink

Please sign in to leave a comment.