Skip to content

CREATE VIEW

Creates a new view in the current/specified schema.

See the Snowflake documentation for more details.

Currently, BodoSQL only supports the following syntax:

CREATE [ OR REPLACE ] VIEW [ IF NOT EXISTS ] <name> 
[ ( <column_list> ) ]
as <select statement>

BodoSQL can parse additional forms of CREATE VIEW syntax purely for the purposes of allowing view inlining:

  • The SECURE keyword
  • The LOCAL, GLOBAL, TEMP, TEMPORARY or VOLATILE keywords
  • The RECURSIVE keyword
  • A COPY GRANTS clause
  • A view-level COMMENT
  • A view-level WITH TAG clause
  • A view-level ROW ACCESS POLICY clause