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:
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:
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;