Search code examples
google-bigquerytemp-tables

Auto delete temp tables in BigQuery


In BigQuery lot of temp_table_* tables are created, this is clustering the datasets. Is there any way to delete these temp tables automatically?

enter image description here


Solution

  • The temp tables are created from one of the third party consumers, they are using Simba JDBC connector, which internally using the temp_table_ prefix.

    Currently no option to set expire date for these tables, once they introduce the option we will leverage.

    Reference: https://www.simba.com/products/BigQuery/doc/JDBC_InstallGuide/content/jdbc/bq/options/largeresulttable.htm