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. Dataebend 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.

caution

Concurrent modifications (including write operations) on transient tables may cause data corruption, making the data unreadable. This defect is being addressed. Until fixed, please avoid concurrent modifications on transient tables.

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
);