CODEWITHSUNDEEP
google-bigquery
Stephan Rayner
Stephan Rayner

Reputation: 3

How to Set Big Query Require Partition Filter in BQ Commandline With Ingestion Partition Tables

I am trying to add a partition filter requirement to a table after creating it. I know one can do this for tables that are partitioned by a column thanks to this post and kennethmac2000 but I this solution doesn't appear to work for ingestion date partitioned tables.

At first I tried

bq update --require_partition_filter project:dataset.table

and I then I tried

bq update --time_partitioning_type DAY --require_partition_filter project:dataset.table

and both result in...

UpdateTable() got an unexpected keyword argument 'range_partitioning'

Any and all help would be greatly appreciated.

Upvotes: 0

Views: 399

Answers (1)

Graham Polley
Graham Polley

Reputation: 14791

It works fine for me on CLI version:

$ gcloud --version
Google Cloud SDK 215.0.0
beta 2018.07.16
bq 2.0.34
core 2018.09.04
gsutil 4.33

enter image description here

$ bq update --require_partition_filter --time_partitioning_type=DAY grey-sort-challenge:afl_ml.partition_filter_test
Table 'grey-sort-challenge:afl_ml.partition_filter_test' successfully updated.

enter image description here

Upvotes: 2

Related Questions