# Documentation error in bigquery insert\_overwrite strategy section?

**URL:** <https://discourse.getdbt.com/t/documentation-error-in-bigquery-insert-overwrite-strategy-section/4483>\
**Category:** Archive\
**Created:** [June 14, 2022, 10:49pm UTC](https://discourse.getdbt.com/t/documentation-error-in-bigquery-insert-overwrite-strategy-section/4483 "2022-06-14T22:49:51Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![soulshaolin](https://avatars.discourse-cdn.com/v4/letter/s/b3f665/32.png) [@soulshaolin](https://discourse.getdbt.com/u/soulshaolin)\
**Post date:** [June 14, 2022, 10:49pm UTC](https://discourse.getdbt.com/t/documentation-error-in-bigquery-insert-overwrite-strategy-section/4483/1 "2022-06-14T22:49:51Z")

</div>

Hello,

I’m really not sure where to post this.

Looking at the query below found [here](https://docs.getdbt.com/reference/resource-configs/bigquery-configs#static-partitions) it seems that there is a mismatch between the date format. timestamp is no matching signature for date. Basically the ` set partitions_to_replace` should be set as date or the `where date(event_timestamp)` should be left as a timestamp.

I’m wondering if this is really a mistake or if I’m missing anything…?

```auto
{% set partitions_to_replace = [
  'timestamp(current_date)',
  'timestamp(date_sub(current_date, interval 1 day))'
] %}

{{
  config(
    materialized = 'incremental',
    incremental_strategy = 'insert_overwrite',
    partition_by = {'field': 'session_start', 'data_type': 'timestamp'},
    partitions = partitions_to_replace
  )
}}

with events as (

    select * from {{ref('events')}}

    {% if is_incremental() %}
        -- recalculate yesterday + today
        where date(event_timestamp) in ({{ partitions_to_replace | join(',') }})
    {% endif %}

),

... rest of model ...

```
