CREATE VIEW

Description

Creates a new view. (BigQuery SQL Language Reference Create view statement)

This syntax is fully supported in Snowflake.

Grammar Syntax

CREATE [ OR REPLACE ] VIEW [ IF NOT EXISTS ] view_name
[(view_column_name_list)]
[OPTIONS(view_option_list)]
AS query_expression

view_column_name_list :=
  view_column[, ...]

view_column :=
  column_name [OPTIONS(view_column_option_list)]

Sample Source Patterns

Input Code:

BigQuery

IN -> BigQuery_01.sql

CREATE VIEW myuser
AS 
SELECT lastname FROM users;

CREATE OR REPLACE VIEW myuser2
AS 
SELECT lastname FROM users2;

CREATE VIEW IF NOT EXISTS myuser2
AS 
SELECT lastname FROM users2;

Output Code:

Snowflake

OUT -> BigQuery_01.sql

CREATE VIEW myuser
AS
SELECT lastname FROM
users;

CREATE OR REPLACE VIEW myuser2
AS
SELECT lastname FROM
users2;

CREATE VIEW myuser3
AS
SELECT lastname FROM
users3;

Known Issues

There are no known Issues.

Related EWIs

There are no related EWIs.