Record-level CRUD and bulk operations — create, update, delete, upsert, CSV import, multi-table foreign-key loads, AI-generated sample data.
Bulk reads, multi-page iteration, and analytics over Dataverse data.
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
Pre-ship model slim — find and remove UNUSED COLUMNS and orphan measures from a PBIP semantic model before publishing.
Execute comprehensive database smoke tests to validate connectivity, query performance, data integrity, and backup/restore operations…
MUST use when writing Snowflake queries.
Choose and implement Snowflake architecture blueprints: data lakehouse,
Execute Snowflake primary workflow: data loading via stages and COPY
Execute Snowflake data transformation with streams, tasks, and dynamic tables.
Collect Snowflake debug evidence for support tickets and troubleshooting.
Use when writing Snowflake SQL, building data pipelines with Dynamic Tables or Streams/Tasks, using Cortex AI functions, creating Cortex…
Configure Snowflake enterprise RBAC with system roles, custom role hierarchies,
Configure Snowflake local development with testing, mocking, and fast iteration.
Execute migration to Snowflake from Redshift, BigQuery, or on-prem databases with data transfer, schema conversion, and validation…
Build on Snowflake's AI Data Cloud with snow CLI, Cortex AI (COMPLETE, SUMMARIZE, AI_FILTER), Native Apps, and Snowpark.
Implement Snowflake governance guardrails with network rules, session
Execute Snowflake production readiness checklist with monitoring and
Implement Snowflake reference architecture with medallion pattern and
Implement Snowflake reliability patterns: replication, failover, Time Travel recovery, and application-level resilience for Snowflake…
Apply production-ready Snowflake SDK patterns for snowflake-sdk and snowflake-connector-python.
Database migration best practices across PostgreSQL, MySQL, and common ORMs (Prisma, Drizzle, Kysely, Django, TypeORM, golang-migrate)…