How to Create snowflake table with primary keys and and partition columns ? Sample DDL?

Question

I need some sample DDL to create a snowflake table with primary keys and partition columns.

Nimantha · Accepted Answer · 2022-06-15 02:02:03Z

1

The documentation can sometimes be a little overwhelming, I get it, so here is an example.

CREATE OR REPLACE TABLE stack_overflow (
    post_id          INTEGER,
    post_str         VARCHAR(20),
    post_timestamp   TIMESTAMP_LTZ,
    PRIMARY KEY (post_id, post_str))
CLUSTER BY (to_date(post_timestamp));

https://docs.snowflake.com/en/sql-reference/sql/create-table.html

edited Jun 15, 2022 at 2:02

Nimantha

6,5276 gold badges32 silver badges78 bronze badges

answered Sep 16, 2020 at 11:42

Rich Murnane

3,0202 gold badges16 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to Create snowflake table with primary keys and and partition columns ? Sample DDL?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related