snowflake-reference-architecture

Solid

Implement Snowflake reference architecture with medallion pattern and Snowflake-native design. Use when designing a new Snowflake data platform, setting up bronze/silver/gold layers, or establishing architecture standards for a Snowflake deployment. Trigger with phrases like "snowflake architecture", "snowflake medallion", "snowflake best practices layout", "snowflake data platform design".

AI & Automation 2,266 stars 315 forks Updated today 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 Reference Architecture ## Overview Production-ready Snowflake architecture using the medallion pattern (bronze/silver/gold), role-based access, and workload-isolated warehouses. ## Architecture Overview ``` ┌──────────────────────┐ │ Data Sources │ │ (S3, APIs, DBs, SaaS) │ └──────────┬───────────┘ │ ┌──────────▼───────────┐ │ BRONZE (Raw) │ │ Snowpipe / COPY │ │ VARIANT columns │ └──────────┬───────────┘ │ Streams + Tasks ┌──────────▼───────────┐ │ SILVER (Cleansed) │ │ Typed columns │ │ Deduped, validated │ └──────────┬───────────┘ │ Dynamic Tables ┌──────────▼───────────┐ │ GOLD (Business) │ │ Aggregated │ │ Analytics-ready │ └──────────┬───────────┘ │ ┌──────────▼───────────┐ │ Consumers │ │ BI tools, APIs, │ │ Data Sharing │ └──────────────────────┘ ``` ## Database La...

Details

Author
jeremylongshore
Repository
jeremylongshore/claude-code-plugins-plus-skills
Created
7 months ago
Last Updated
today
Language
Python
License
MIT

Integrates with

Anthropic · AI

Similar Skills

Semantically similar based on skill content — not just same category

AI & Automation Featured

snowflake-architecture-variants

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".

2,266 Updated today
jeremylongshore
AI & Automation Solid

snowflake-development

Use when writing Snowflake SQL, building data pipelines with Dynamic Tables or Streams/Tasks, using Cortex AI functions, creating Cortex Agents, writing Snowpark Python, configuring dbt for Snowflake, or troubleshooting Snowflake errors.

16,642 Updated yesterday
alirezarezvani
AI & Automation Featured

snowflake-enterprise-rbac

Configure Snowflake enterprise RBAC with system roles, custom role hierarchies, SSO/SCIM integration, and least-privilege access patterns. Use when implementing role-based access control, configuring SSO with SAML/OIDC, or setting up organization-level governance in Snowflake. Trigger with phrases like "snowflake RBAC", "snowflake roles", "snowflake SSO", "snowflake SCIM", "snowflake permissions", "snowflake access control".

2,266 Updated today
jeremylongshore
AI & Automation Solid

snowflake-reliability-patterns

Implement Snowflake reliability patterns: replication, failover, Time Travel recovery, and application-level resilience for Snowflake integrations. Use when building fault-tolerant pipelines, configuring disaster recovery, or adding resilience to production Snowflake services. Trigger with phrases like "snowflake reliability", "snowflake failover", "snowflake replication", "snowflake disaster recovery", "snowflake Time Travel".

2,266 Updated today
jeremylongshore
AI & Automation Featured

snowflake-development

Comprehensive Snowflake development assistant covering SQL best practices, data pipeline design (Dynamic Tables, Streams, Tasks, Snowpipe), Cortex AI functions, Cortex Agents, Snowpark Python, dbt integration, performance tuning, and security hardening.

39,227 Updated today
sickn33