Skip to content

CREATE TABLE

Creates a new table in the current/specified schema.

See the Snowflake documentation for more details.

Currently, BodoSQL only supports the CREATE TABLE ... AS SELECT (CTAS) form, and only with the following syntax:

CREATE [ OR REPLACE ] TABLE [ IF NOT EXISTS ] <name>
[ ( <col_name> [ <col_type> ] , <col_name> [ <col_type> ] , ... ) ]
[ COMMENT = <string> ]
AS <query>

BodoSQL can parse additional forms of CREATE TABLE syntax, though they currently do not have any effects:

  • The TRANSIENT keyword
  • The LOCAL, GLOBAL, TEMP, TEMPORARY or VOLATILE keywords
  • A COPY GRANTS clause
  • A CLUSTER BY clause