No, you cannot use the SELECT INTO syntax for Snowflake as it does not have that statement. However, there are other alternatives that can be used instead such as CREATE TABLE as SELECT statement in order to create a table by copying or duplicating the existing table or based on the result of the SELECT query.
With CREATE TABLE as SELECT you are able to:
-Create a table with selected columns, by changing column names and data types from an existing table.
-Create a table with the result of a query or duplicated a table from an existing table.
Gisele Casillas Answered question January 22, 2022