# using historic data from a target incremental table as part of a build

**URL:** <https://discourse.getdbt.com/t/using-historic-data-from-a-target-incremental-table-as-part-of-a-build/19375>\
**Category:** Help\
**Tags:** incremental, bigquery, dbt-core\
**Created:** [May 14, 2025, 4:35am UTC](https://discourse.getdbt.com/t/using-historic-data-from-a-target-incremental-table-as-part-of-a-build/19375 "2025-05-14T04:35:05Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![proetman](https://avatars.discourse-cdn.com/v4/letter/p/df788c/32.png) [@proetman](https://discourse.getdbt.com/u/proetman)\
**Post date:** [May 14, 2025, 4:35am UTC](https://discourse.getdbt.com/t/using-historic-data-from-a-target-incremental-table-as-part-of-a-build/19375/1 "2025-05-14T04:35:05Z")

</div>

TABLE\_A -------\> TABLE\_B-------\>TARGET (new partition)

```
                        (historic partition)

```

```auto

```

---

<div class="post-metadata">

**Author:** ![a\_slack\_user](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/a_slack_user/32/1629_2.png) [@a\_slack\_user](https://discourse.getdbt.com/u/a_slack_user)\
**Post date:** [May 14, 2025, 12:34pm UTC](https://discourse.getdbt.com/t/using-historic-data-from-a-target-incremental-table-as-part-of-a-build/19375/2 "2025-05-14T12:34:55Z")

</div>

Please add more detail about what you are trying to accomplish, what the problem is, and what you’ve already tried.

Note: `@Owen` originally [posted this reply in Slack](https://getdbt.slack.com/archives/CBSQTAPLG/p1747225765134339?thread_ts=1747197326.041789&cid=CBSQTAPLG). It might not have transferred perfectly.