Choose and implement Snowflake architecture blueprints: data lakehouse,
Automate Snowflake data warehouse operations -- list databases, schemas, and tables, execute SQL statements, and manage data workflows via…
Configure Snowflake CI/CD with GitHub Actions, SchemaChange, and Terraform.
Diagnose and fix common Snowflake errors and SQL compilation failures.
Execute Snowflake primary workflow: data loading via stages and COPY
Execute Snowflake data transformation with streams, tasks, and dynamic tables.
Optimize Snowflake costs with resource monitors, warehouse auto-suspend,
Collect Snowflake debug evidence for support tickets and troubleshooting.
Create a minimal working Snowflake example with real SQL queries.
Install and configure Snowflake driver authentication for Node.js and
Identify and avoid Snowflake anti-patterns and common mistakes in SQL,
Implement Snowflake load testing, warehouse scaling, and capacity planning.
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…
Implement Snowflake governance guardrails with network rules, session
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.
Apply Snowflake security best practices: network policies, key rotation, MFA, encryption, and least-privilege access.
Create, alter, and validate Snowflake semantic views using Snowflake CLI (snow).
Upgrade Snowflake drivers, handle breaking changes, and migrate between