snowflake-architecture-variants

Featured

Choose and implement Snowflake architecture blueprints: data lakehouse, data mesh, data sharing, and Snowpark-native patterns for different scales. Use when designing Snowflake data platforms, choosing between architectures, or implementing data sharing and Snowpark patterns. Trigger with phrases like "snowflake architecture", "snowflake lakehouse", "snowflake data mesh", "snowflake data sharing", "snowflake Snowpark".

AI & Automation 2,926 stars 433 forks Updated yesterday MIT

Install

View on GitHub

Quality Score: 99/100

Stars 20%
100
Recency 20%
100
Frontmatter 20%
70
Documentation 15%
100
Issue Health 10%
50
License 10%
100
Description 5%
100

Skill Content

# Snowflake Architecture Variants ## Overview Three validated architecture blueprints for Snowflake deployments: traditional data warehouse, lakehouse with Iceberg, and data mesh with data sharing. ## Variant A: Traditional Data Warehouse **Best for:** Single team, centralized analytics, < 50 users ``` ┌──────────────────────────┐ │ Snowflake Account │ │ │ │ ┌────────┐ ┌────────┐ │ │ │ Bronze │→ │ Silver │→ Gold │ │ └────────┘ └────────┘ │ │ │ │ ┌─────────────────────┐ │ │ │ Single ETL Warehouse │ │ │ └─────────────────────┘ │ │ │ │ ┌──────────┐ ┌──────────┐ │ │ │ BI Tools │ │ Analysts │ │ │ └──────────┘ └──────────┘ │ └──────────────────────────────┘ ``` ```sql -- Simple single-account setup CREATE DATABASE DW; CREATE SCHEMA DW.RAW; CREATE SCHEMA DW.CURATED; CREATE SCHEMA DW.ANALYTICS; CREATE WAREHOUSE ETL_WH WAREHOUSE_SIZE = 'MEDIUM' AUTO_SUSPEND = 120; CREATE WAREHOUSE QUERY_WH WAREHOUSE_SIZE = 'SMALL' AUTO_SUSPEND = 60; ``` ## Variant B: Lakehouse with Iceberg Tables **Best for:** Hybrid cloud/on-prem, existing data lake, open table format requirement ``` ┌──────────────────────┐ ┌─────────────────────┐ │ External Storage │ │ Snowflake Account │ │ (S3/GCS/Azure) │ │ │ │ │ │ ┌────────────────┐ │ │ ┌─────────────┐ │←───→│ │ Iceberg Tables │ │ │ │ Parquet...

Details

Author
jeremylongshore
Repository
jeremylongshore/claude-code-plugins-plus-skills
Created
1 years ago
Last Updated
yesterday
Language
Python
License
MIT

Integrates with

Bundled in these plugins

Similar Skills

Semantically similar based on skill content — not just same category