Snowflake for SQL Server Users - Part 15 - Table types
Snowflake has a richer set of options for how tables are created, than we have in SQL Server.
CREATE TABLE Variants
As well as a CREATE TABLE statement as you would already be familiar with in SQL Server, Snowflake offers these variants:
CREATE TABLE tablename AS SELECT
This is basically similar to a SELECT INTO in SQL Server. It executes the SELECT query and creates a table from the results (including the data).
2019-11-15