# How to handle temporary tables in BigQuery?

**URL:** <https://discourse.greatexpectations.io/t/how-to-handle-temporary-tables-in-bigquery/375>\
**Category:** Archive\
**Tags:** how-to\
**Created:** [September 8, 2020, 4:12pm UTC](https://discourse.greatexpectations.io/t/how-to-handle-temporary-tables-in-bigquery/375 "2020-09-08T16:12:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dennys](https://yyz1.discourse-cdn.com/flex031/user_avatar/discourse.greatexpectations.io/dennys/32/74_2.png) [@dennys](https://discourse.greatexpectations.io/u/dennys)\
**Post date:** [September 8, 2020, 4:12pm UTC](https://discourse.greatexpectations.io/t/how-to-handle-temporary-tables-in-bigquery/375/1 "2020-09-08T16:12:57Z")

</div>

I’m wondering if there is any way to set expiration time at table level for temporary tables created by Great Expectations on BigQuery?

As far as I know the suggestion is to set a default\_table\_expiration time at dataset level but what if I need to store a different kind of tables in the same dataset?

---

<div class="post-metadata">

**Author:** ![eugene.mandel](https://yyz1.discourse-cdn.com/flex031/user_avatar/discourse.greatexpectations.io/eugene.mandel/32/22_2.png) [@eugene.mandel](https://discourse.greatexpectations.io/u/eugene.mandel)\
**Post date:** [September 11, 2020, 4:32am UTC](https://discourse.greatexpectations.io/t/how-to-handle-temporary-tables-in-bigquery/375/2 "2020-09-11T04:32:01Z")

</div>

Great Expectations does not currently provide a configuration option to control the expiration of the temporary table it creates in BigQuery.

You can update the table after it is created, as described in BigQuery documentation: [https://cloud.google.com/bigquery/docs/managing-tables#updating\_a\_tables\_expiration\_time](https://cloud.google.com/bigquery/docs/managing-tables#updating_a_tables_expiration_time)

---

<div class="post-metadata">

**Author:** ![dennys](https://yyz1.discourse-cdn.com/flex031/user_avatar/discourse.greatexpectations.io/dennys/32/74_2.png) [@dennys](https://discourse.greatexpectations.io/u/dennys)\
**Post date:** [September 25, 2020, 3:25pm UTC](https://discourse.greatexpectations.io/t/how-to-handle-temporary-tables-in-bigquery/375/3 "2020-09-25T15:25:00Z")

</div>

It’s good to know it, thanks @eugene.mandel