Resources
Blog posts, guides, and initiatives we believe in: data warehousing, BI, analytics, and Snowflake tools.
ExperienceIsaac Asimov — Cinematic Tribute
An immersive, high-end digital experience: the Psychohistory Engine, the Three Laws, the Seldon Projection, and more.
Enter the terminalInitiatives we believe in
External tools and projects we support and recommend.
Declarative tool for object management automation in Snowflake. Official documentation.
We faithfully believe in this initiative.
DataFrames for the new era. High-performance, open-source library for data manipulation in Python and Rust—fast, expressive, and easy to use.
We faithfully believe in this initiative.
Open-source modern data exploration and visualization platform. Fast, lightweight, and loaded with 40+ chart types—from no-code builder to SQL IDE.
We faithfully believe in this initiative.
The world's most advanced open source relational database. Over 35 years of active development—reliable, feature-rich, and high performance.
We faithfully believe in this initiative.
Articles
Late Arriving Dimensions: How to Handle Delayed Dimension Data in a Data Warehouse
Preventing orphaned records and maintaining data accuracy. Strategies for temporary keys, SCDs, effective dates, and reprocessing facts when dimension data arrives late.
Snowflake's COPY Command: The Key to Efficient Data Loading
The power of data loading in Snowflake. COPY INTO syntax, stages, PUT, file formats, error handling, and best practices for efficient data ingestion.
Snowflake Tasks: The Silent Engine of Automation in Snowflake
Schedule and automate SQL operations with native Tasks. DAGs, dependencies, stored procedures, ETL patterns, and when to use Tasks vs external orchestrators.
Time Travel in Snowflake – Recover the Past and More
Access historical data, restore information, and ensure data integrity. Time Travel, UNDROP, Zero Copy Cloning, and Fail-safe.
Zero Copy Cloning in Snowflake – Revolutionizing Data Management
Instant, efficient cloning of tables, schemas, or databases without duplicating data. Shared micro-partitions, copy-on-write, and top use cases.
Inmon vs. Kimball
From application data to corporate data. Key differences between dimensional marts and normalized DWH, pros and cons, and the hybrid approach.
Medallion Architecture: A Strategic Framework for Modern Data Management
Organize your data into Bronze, Silver, and Gold layers. Comparison with Lambda and Kappa, benefits, and platform-agnostic implementation.
The Hidden Backbone of a Robust Data Warehouse: Dimensions Done Right
It's not about size or speed—it's about the strength of your dimensions. Connectivity, hierarchies, SCDs, and how to evaluate them.