Practical notes for Snowflake, Databricks, and SQL.

This site is organized into three focused libraries: Snowflake platform playbooks, Databricks delivery patterns, and reusable SQL examples.

63 Published articles

32 Snowflake-focused notes

16 Databricks-focused notes

Start Here

Snowflake Playbooks Warehouse design, cost attribution, ingestion, governance, CLI setup, and Snowflake platform patterns. Databricks Playbooks Lakehouse delivery notes, notebooks, jobs, environments, assistant workflows, and platform implementation ideas. SQL Articles Reusable SQL for deduping, validation, transformations, rankings, retention, SQL Server, and warehouse checks. Data Engineering Lab Runnable Snowflake labs for ingestion, transformation, scheduling, monitoring, and platform operations. AI/Data Science Lab Runnable Snowflake labs for data science, Cortex AI, LLMs, model lifecycle, governance, and Gen AI patterns. About and Focus A quick view of the Snowflake, Databricks, and SQL problems that shape the content here.

Featured Reads

Snowflake FinOps Estimate Cost Per Query in Snowflake With Better Cost Attribution Use warehouse history and query metadata to explain spend in language stakeholders understand. Snowflake Pipelines Build Incremental Snowflake Pipelines With Streams, Tasks, and Dynamic Tables Show when each refresh pattern is the right operational choice. Databricks Workflows Build Production Databricks Workflows With Quality Gates Separate ingestion, transformation, validation, publishing, and recovery into an operable lakehouse workflow. SQL Server Operate SQL Server Triggers and Stored Procedures Safely Keep transaction-heavy SQL Server automation visible, controlled, and maintainable.

Recently Posted

Jun 17, 2026 Databricks Platform Architecture A reference for how Databricks is organized: the split between control plane and data plane, Unity Catalog's 3-level namespace, the available compute types, and what Delta Lake provides at the storage layer. Jun 17, 2026 Deploy Databricks Projects with Declarative Automation Bundles A practical reference for Declarative Automation Bundles (DABs): project structure, environment targets, bundle commands, Git Folders, and wiring up a CI/CD pipeline with GitHub Actions. Jun 17, 2026 Govern Data in Unity Catalog A practical reference for Unity Catalog data governance: the difference between managed and external tables, GRANT/REVOKE/DENY privilege rules, column-level masking, row-level security with row filters, and attribute-based access control. Jun 17, 2026 Ingest Data into Databricks with COPY INTO, Auto Loader, and Lakeflow Connect A practical reference for the four main ways to bring data into Databricks: COPY INTO for batch loads, Auto Loader for incremental file ingestion, Lakeflow Connect for managed connectors, and JDBC for database sources. Jun 17, 2026 Monitor Databricks Jobs and Troubleshoot Spark Performance A practical guide to monitoring Databricks job runs, reading the Spark UI, diagnosing data skew and spill, tuning shuffle partitions, and diagnosing common cluster startup failures. Jun 17, 2026 Operate Delta Lake Tables with Time Travel, VACUUM, and Liquid Clustering A practical reference for Delta Lake table operations: querying history, reverting changes, purging deleted data, compacting files, and clustering for query performance.