# Backfill data in tables

**URL:** <https://discourse.getdbt.com/t/backfill-data-in-tables/2463>\
**Category:** Archive\
**Created:** [April 30, 2021, 3:56am UTC](https://discourse.getdbt.com/t/backfill-data-in-tables/2463 "2021-04-30T03:56:30Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![oldfaust](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/oldfaust/32/706_2.png) [@oldfaust](https://discourse.getdbt.com/u/oldfaust)\
**Post date:** [April 30, 2021, 3:56am UTC](https://discourse.getdbt.com/t/backfill-data-in-tables/2463/1 "2021-04-30T03:56:30Z")

</div>

I’m using Bigquery scheduled queries to prepare the data for analytics.

There is a backfill feature which can run your queries with @run\_time parameter with values from the past - say every hour for the last week.

Of course the queries have to be using this parameter but the backfill feature supplies it with the right values.

How can we achieve the same with dbt?

Thanks

---

<div class="post-metadata">

**Author:** ![alaenaroberds](https://avatars.discourse-cdn.com/v4/letter/a/46a35a/32.png) [@alaenaroberds](https://discourse.getdbt.com/u/alaenaroberds)\
**Post date:** [September 23, 2021, 9:27pm UTC](https://discourse.getdbt.com/t/backfill-data-in-tables/2463/2 "2021-09-23T21:27:09Z")

</div>

I am also curious about backfilling data on some specified time range in dbt.

---

<div class="post-metadata">

**Author:** ![lacework\_abhishek](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/lacework_abhishek/32/1107_2.png) [@lacework\_abhishek](https://discourse.getdbt.com/u/lacework_abhishek)\
**Post date:** [July 12, 2022, 4:34pm UTC](https://discourse.getdbt.com/t/backfill-data-in-tables/2463/3 "2022-07-12T16:34:18Z")

</div>

me too. This has me blocked!