CREATE TRANSIENT TABLE

Creates a table without storing its historical data for Time Travel.

Transient tables are used to hold transitory data that does not require a data protection or recovery mechanism. TiDB Cloud Lake does not hold historical data for a transient table so you will not be able to query from a previous version of the transient table with the Time Travel feature, for example, the AT clause in the SELECT statement will not work for transient tables. Please note that you can still drop and undrop a transient table.

Syntax

CREATE [ OR REPLACE ] TRANSIENT TABLE
       [ IF NOT EXISTS ]
       [ <database_name>. ]<table_name>
       ...

The omitted parts follow the syntax of CREATE TABLE.

Examples

This examples creates a transient table named visits:

CREATE TRANSIENT TABLE visits (
  visitor_id BIGINT
);