Snowflake Solutions Expertise and
Community Trusted By

Enter Your Email Address Here To Join Our Snowflake Solutions Community For Free

Snowflake Solutions Community

Can I use the SELECT INTO syntax for Snowflake?

8.12K viewsSQL
0

Can I use the SELECT INTO syntax for Snowflake?

Gisele Casillas Answered question January 22, 2022
0

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
You are viewing 1 out of 1 answers, click here to view all answers.

Sign in with google.com

To continue, google.com will share your name, email address, and profile picture with this site.

Harness the Power of Data with ITS Solutions

Innovative Solutions for Comprehensive Data Management

Feedback on Q&A