# Issue in time\_ingestion\_partitioning and copy\_partitions in incremental model

**URL:** <https://discourse.getdbt.com/t/issue-in-time-ingestion-partitioning-and-copy-partitions-in-incremental-model/14301>\
**Category:** Help\
**Tags:** incremental, bigquery, dbt-core\
**Created:** [July 16, 2024, 1:57am UTC](https://discourse.getdbt.com/t/issue-in-time-ingestion-partitioning-and-copy-partitions-in-incremental-model/14301 "2024-07-16T01:57:36Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![seeker](https://avatars.discourse-cdn.com/v4/letter/s/90ced4/32.png) [@seeker](https://discourse.getdbt.com/u/seeker)\
**Post date:** [July 16, 2024, 1:57am UTC](https://discourse.getdbt.com/t/issue-in-time-ingestion-partitioning-and-copy-partitions-in-incremental-model/14301/1 "2024-07-16T01:57:36Z")

</div>

I have a incremental model for bigquery with insert\_overwrite strategy. I am trying to implement time\_ingestion\_partitioning with copy\_partitions enabled for cost saving. But I am getting following error:  
01:42:00 BigQuery adapter: Copying table(s) “/projects/my-project/datasets/my-dataset/tables/my-model\_\_dbt\_tmp$20240712” to “/projects/my-project/datasets/my-dataset/tables/my-model$20240712” with disposition: “WRITE\_TRUNCATE”  
01:42:01 BigQuery adapter: Retry attempt 1 of 1 after error: BadRequest(‘Failed to copy Natural partitioned meta table to Column partitioned meta table: incompatible partitions.’)

I am trying to understand what could be wrong here? I could not find the log mentioned anywhere while googling.

I was following this blog [BigQuery ingestion-time partitioning and partition copy with dbt | dbt Developer Blog](https://docs.getdbt.com/blog/bigquery-ingestion-time-partitioning-and-partition-copy-with-dbt)