Templated Variables

These are useful to produce consistent query output when defining data transformations and materializing data through Views. These are not available during ad-hoc querying.

Variable	Description	Data Type	Example
@start_ts	A placeholder that is used to encode the start date of the data being ingested	Datetime	SELECT timestamp, value from table_1 where timestamp ≥ @start_ts;
@end_ts	A placeholder that is used to encode the start date of the data being ingested	Datetime	SELECT timestamp, value from table_1 where timestamp ≤ @end_ts;
@timezone	A placeholder used to specify the timezone for the timestamp column	String	SELECT timestamp AT TIMEZONE @timezone FROM table_1;
@execution_ts	Used to encode the date and time at which point the query is being executed. This is used specifically in Full Refresh Materialization to add an upper cap on timestamp column	Datetime	SELECT timestamp, value from table_1 where timestamp ≤ @execution_ts;