How do we create temporary tables?

Snowflake - Interview Questions

In the CREATE TABLE DDL, specify the TEMPORARY keyword (or the TEMP abbreviation) to create a temporary table. The following syntax must be used to create temporary tables:

Create temporary table mytable (id number, creation_date date);

More Technologies Interview Questions

Machine Learning

Artificial Intelligence