The problem I’m having
Using partition copy with dbt I get the following error:
Could not parse partition config: at path []: Additional properties are not allowed ('copy_partitions' was unexpected)
Refer to documentation - BigQuery ingestion-time partitioning and partition copy with dbt | dbt Developer Blog
What I’ve already tried
{{ config(
materialized = 'table',
incremental_strategy = 'insert_overwrite',
partition_by = {'field': 'timestamp_created',
"data_type": 'timestamp',
"granularity": 'day',
"copy_partitions": true
},
tags=["daily"]
) }}