CREATE Command Reference

Description

Creates various database objects in Singdata Lakehouse.

Syntax

CREATE <object_type> [ IF NOT EXISTS ] <object_name> [ COMMENT '<string_literal>' ]

Parameters

Parameter	Description	Required
<object_type>	The type of object to create, such as TABLE, VIEW, SCHEMA, etc.	Yes
IF NOT EXISTS	Silently skip if the object already exists, no error	No
<object_name>	The object name, may include a schema prefix	Yes
COMMENT	Object description/comment	No

Supported Object Types

Object Type	Syntax Example	Description
Regular Table	CREATE TABLE <name> (col1 TYPE, ...)	Structured two-dimensional data
External Table	CREATE EXTERNAL TABLE <name> USING <format>	Data stored in external systems
View	CREATE VIEW <name> AS SELECT ...	Virtual table, does not store data
Dynamic Table	CREATE DYNAMIC TABLE <name> REFRESH INTERVAL ...	Data object with automatic incremental refresh
Materialized View	CREATE MATERIALIZED VIEW <name> AS SELECT ...	Pre-computed query results
Table Stream	CREATE TABLE STREAM <name> ON TABLE <table>	Captures table-level changes (CDC)
Schema	CREATE SCHEMA <name>	Namespace
External Schema	CREATE EXTERNAL SCHEMA <name> CONNECTION <conn>	Mount an external Schema
External Catalog	CREATE EXTERNAL CATALOG <name> CONNECTION <conn>	Mount an external catalog
Connection	CREATE STORAGE/CATALOG/API CONNECTION <name> ...	Storage/catalog/API connection configuration
Pipe	CREATE PIPE <name> ... AS COPY INTO ...	Continuous data ingestion pipeline
Compute Cluster	CREATE VCLUSTER <name> ...	Virtual compute cluster
Data Share	CREATE SHARE <name>	Cross-instance data sharing
Synonym	CREATE SYNONYM <name> FOR <object>	Object alias
SQL Function	CREATE SQL FUNCTION <name> AS ...	User-defined SQL function
External Function	CREATE EXTERNAL FUNCTION <name> ...	Function that invokes external services
User	CREATE USER <name> ...	System user
Role	CREATE ROLE <name>	Permission role

Required Permissions

Executing CREATE operations requires the corresponding creation permission (such as CREATE TABLE, CREATE VIEW, etc.) on the target Schema or workspace. See the syntax documentation for each object type for specific permission requirements.

Notes

• Most CREATE statements support the IF NOT EXISTS clause, suitable for use in scripts or automated workflows.
• You can attach a description using the COMMENT clause when creating an object.
• Different object types have their own required and optional parameters; see the syntax reference below for details.

Syntax Reference

Data Objects

• CREATE TABLE
• CREATE EXTERNAL TABLE
• CREATE VIEW
• CREATE DYNAMIC TABLE
• CREATE MATERIALIZED VIEW
• CREATE TABLE STREAM

Indexes and Synonyms

• CREATE BLOOMFILTER INDEX
• CREATE INVERTED INDEX
• CREATE VECTOR INDEX
• CREATE SYNONYM

Schema and Catalog

• CREATE SCHEMA
• CREATE EXTERNAL SCHEMA
• CREATE EXTERNAL CATALOG

Connections and Pipes

• CREATE STORAGE CONNECTION
• CREATE CATALOG CONNECTION
• CREATE API CONNECTION
• CREATE PIPE

Compute and Sharing

• CREATE VCLUSTER
• CREATE SHARE

Functions

• CREATE SQL FUNCTION
• CREATE EXTERNAL FUNCTION

Users and Permissions

• CREATE USER
• CREATE ROLE