SELECT INTO
Description
SELECT INTO creates a new table and fills it with data computed by a query. The data is not returned to the client, as it is with a normal SELECT. The new table's columns have the names and data types associated with the output columns of the SELECT.
Click here to navigate to the PostgreSQL documentation page for this syntax.
The SELECT INTO is translated to CREATE OR REPLACE TABLE AS in snowflake.
Grammar Syntax
Sample Source Patterns
PostgreSQL
Snowflake
Related EWIs
Last updated