Partition with BigQuery Target

[JavierElaniin]

Hi, I checked the docs but I can't find an example to set up partitions in BigQuery, does anyone have implemented this?

[flarco]

Can you try:

streams:
  my_schema.another_table:
    object: my_dataset.{stream_table}
    target_options:
      table_keys:
        partition: [ DATE_TRUNC(transaction_date, MONTH) ]

or

streams:
  my_schema.another_table:
    object: my_dataset.{stream_table}
    target_options:
      table_ddl: |
         CREATE TABLE my_dataset.{stream_table} ({col_types}) 
          PARTITION BY
            DATE_TRUNC(transaction_date, MONTH)
            OPTIONS (
              partition_expiration_days = 3,
              require_partition_filter = TRUE)

[JavierElaniin]

I'll try this

[JavierElaniin]

Thanks @flarco I got it working using the Python Wrapper