Quick Presets:

Ingestion & Partition Inputs

1 GB500 GB1 TB2 TB

Sizing Metrics & Architecture Score

Health Score: 80/100
Total Partitions
365
Over 365 days retention
Avg Size / Partition
7.14 GB
Compressed storage
Total Table Footprint
2.55 TB
Raw: 8.9 TB
Files per Partition
~29 files
Total: 10,585 files
Oversized Partition WarningAverage partition size is 7.1 GB. Queries filtering by partition key will still scan excessive data without fine-grained pruning.
💡 Engine Best Practices (SNOWFLAKE):
  • Snowflake uses automatic micro-partitioning (50-500 MB uncompressed). Use CLUSTER BY instead of manual directory partitioning.

Generated SNOWFLAKE Partitioned DDL

-- Snowflake Table with Automatic Clustering
CREATE OR REPLACE TABLE fact_events (
  event_id STRING NOT NULL,
  event_timestamp TIMESTAMP_NTZ NOT NULL,
  user_id STRING,
  event_type STRING,
  payload VARIANT,
  inserted_at TIMESTAMP_NTZ DEFAULT CURRENT_TIMESTAMP()
)
CLUSTER BY (DATE(event_timestamp), user_id, event_type);

-- Verify clustering health
SELECT SYSTEM$CLUSTERING_INFORMATION('fact_events', '(DATE(event_timestamp), user_id, event_type)');