https://community.databricks.com/t5/data-engineering/can-i-use-sql-to-create-a-table-and-set-an-expiration-date/m-p/36045#M26030 <P>Not that I am aware of but you could create a job with a notebook task that runs a drop table &lt;tablename&gt; statement then set it to run on a trigger in the job when you want it to be deleted.&nbsp;</P> Wed, 28 Jun 2023 23:30:51 GMT mkm 2023-06-28T23:30:51Z https://community.databricks.com/t5/data-engineering/can-i-use-sql-to-create-a-table-and-set-an-expiration-date/m-p/35892#M25987 <P class="">Can I use SQL to create a table and set and expiration date? So that the table will be deleted automatically after the expiration date.</P> Wed, 28 Jun 2023 21:29:53 GMT https://community.databricks.com/t5/data-engineering/can-i-use-sql-to-create-a-table-and-set-an-expiration-date/m-p/35892#M25987 whleeman 2023-06-28T21:29:53Z https://community.databricks.com/t5/data-engineering/can-i-use-sql-to-create-a-table-and-set-an-expiration-date/m-p/36045#M26030 <P>Not that I am aware of but you could create a job with a notebook task that runs a drop table &lt;tablename&gt; statement then set it to run on a trigger in the job when you want it to be deleted.&nbsp;</P> Wed, 28 Jun 2023 23:30:51 GMT https://community.databricks.com/t5/data-engineering/can-i-use-sql-to-create-a-table-and-set-an-expiration-date/m-p/36045#M26030 mkm 2023-06-28T23:30:51Z https://community.databricks.com/t5/data-engineering/can-i-use-sql-to-create-a-table-and-set-an-expiration-date/m-p/36094#M26045 <P>Right now it i not possible. You can always create a custom trigger solution with parameter to call notebook and delete the table.</P> Thu, 29 Jun 2023 00:10:04 GMT https://community.databricks.com/t5/data-engineering/can-i-use-sql-to-create-a-table-and-set-an-expiration-date/m-p/36094#M26045 prakash1 2023-06-29T00:10:04Z