Skip to content

CREATE TABLE

Creates a new table in the current/specified schema.

See the Snowflake documentation for more details.

Syntax

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> ] 
[ TAG | TAGS | PROPERTY | PROPERTIES | TBLPROPERTY | TBLPROPERTIES (<key1> = <value1>, <key2> = <value2>, ...) ]
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