Cluster By

Specifies one or more columns or column expressions in the table as the clustering key.

Grammar Syntax

CLUSTER BY ( expr [ , expr , ... ] )

This syntax is fully supported by Snowflake.

Sample Source Patterns

ANSI SQL Input Code

CREATE TABLE TABLE01 (COL1 INT, COL2 INT) CLUSTER BY (COL1);

Snowflake Output Code

CREATE TABLE TABLE01 (COL1 INT, COL2 INT) CLUSTER BY (COL1);