Data Table Expiration Date

[ytomizawa]

Per these instructions (https://cloud.google.com/bigquery/docs/managing-tables#updating_a_tables_expiration_time), if I set a default table expiration time at the dataset level, will this apply to ALL tables (new ones moving forward as well as existing tables)? In other words, will the expiration time be updated for existing tables, and if that expiration date has passed, those tables will be deleted? Thank you for any insight you can provide.

[josegutierrez]

Once the property table expiration is applied to a dataset level, all newly-created tables in the dataset will have an expiration Time property set to the creation time plus the value in this property, and changing the value will only affect new tables, not existing ones. Those already existing tables will still adhere to the original table expiration setting, not the new setting. For updating those already existing tables, you may want to consider updating the table expiration via SQL update on the expiration_timestamp option, or any of the other available methods. You can see more information in the next document.