AS query_statement

Create table option

Description

Used to create a new table based on the results of that query. For more information please refer to Query syntax.

AS query_statement is supported by Snowflake.

Sample Source

BigQuery (Input Code)

CREATE TABLE table1
AS (
  SELECT * FROM table2
);

Snowflake (Output Code)

CREATE TABLE table1
AS (
  SELECT * FROM table2
);