architect-data-warehousing
CommunityDesign robust Snowflake schemas for Braze data
Authordelta-and-beta
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Helps data architects design, audit, and manage Snowflake schemas and ETL pipelines that consume Braze Secure Data Sharing so queries are correct, performant, and compliant with retention and PII policies.
Core Features & Use Cases
- Schema & Entity Modeling: Maps Braze entities to Snowflake tables and recommends stable join keys (for example, external_user_id) and naming conventions.
- ETL Patterns & Query Optimization: Provides incremental extraction patterns, deduplication techniques (QUALIFY ROW_NUMBER()), time-based partitioning guidance, and sample SQL for cross-channel joins.
- Governance & Retention Planning: Explains Secure Data Sharing semantics, region alignment, two-year anonymization windows, and approaches to snapshot or copy data to preserve non-anonymized records.
- Use case: Audit a Braze data share to remove full-table scans, add time-bounded filters, and produce a repeatable incremental load recipe.
Quick Start
Ask the skill to audit a Snowflake database consumed from Braze and produce schema, ETL, performance, and retention recommendations.
Dependency Matrix
Required Modules
None requiredComponents
references
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: architect-data-warehousing Download link: https://github.com/delta-and-beta/braze-agency/archive/main.zip#architect-data-warehousing Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.