Partitioned By

Create table option

Description

PARTITIONED BY is an optional clause that controls table partitioning.

This is not supported by Snowflake but all data in Snowflake tables is automatically divided into micro-partitions, which are contiguous units of storage. Each micro-partition contains between 50 MB and 500 MB of uncompressed data. For more information please refer to Micro-partitions & Data Clustering.

Micro-partitioning is automatically performed on all Snowflake tables.

Sample Source

Hive

CREATE TABLE table1(
    transaction_id INT, 
    transaction_date DATE
)
PARTITION BY transaction_date;

Snowflake

CREATE TABLE table1(
    transaction_id INT, 
    transaction_date DATE
)
----** MSC-WARNING - MSC-HVXXXX - MICRO-PARTITIONING IS AUTOMATICALLY PERFORMED ON ALL SNOWFLAKE TABLES. **
--PARTITION BY transaction_date
;

Known Issues

No issues were found.

Related EWIs

1. MSC-HVXXXX: Micro-partitioning is automatically performed on all Snowflake tables.