Skip to content

Create table cluster by expression support #1036

Closed
@rampage644

Description

@rampage644

Currently, cluster by clause in create and alter table statement only supports comma separated list of identifiers (https://github.com/apache/datafusion-sqlparser-rs/blob/84c3a1b325c39c879b68ab712e3b9b3e3e40ed56/src/dialect/snowflake.rs#L452), whereas snowflake supports having expressions there:

create or replace iceberg table snowplow.public_snowplow_manifest.snowplow_web_base_sessions_lifecycle_manifest
    cluster by (to_date(start_tstamp))

Metadata

Metadata

Assignees

Labels

dbtRelated to dbtengineengine team area

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions