How to handle temporary tables in BigQuery?

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?

1 Like

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

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

1 Like