InTowards Data EngineeringbyAvigarg·Oct 8Snowflake as a Metadata Hub for Open Data — Concept and a Hands-On AWS Glue + Iceberg POCUnderstanding the metadata-hub idea first, then building one side of it with Snowflake Horizon Catalog, AWS Glue, Apache Iceberg, and Lake…
Avigarg·Aug 1Snowflake Dynamic Tables Just Got Smarter with Adaptive RefreshHow Adaptive Refresh differs from AUTO — and why it matters for real-world data pipelines
Avigarg·Jul 16Snowflake Doesn’t Enforce Your Primary Key. So What Is Protecting Your Fact Table?Most teams declare constraints in Snowflake, get none of the checking, and don’t realize there’s a third thing they were supposed to add.A response icon3A response icon3
Avigarg·Jun 25Implementing CI/CD for dbt Core and Snowflake Using Azure DevOps — A Practical, Beginner-Friendly…A real-world walkthrough of how to take a dbt change from a developer’s laptop to Snowflake Production — safely, automatically, and with…
Avigarg·Jun 9Snowflake Storage Lifecycle Policies: A Smarter Way to Pay for Data You Can’t DeleteUnderstand it, set it up step by step, and get your archived data back when you need it
Avigarg·May 14Snowflake Search Optimization Service Explained ClearlyWhen normal partition pruning is not enough, SOS can be the performance lever you needA response icon1A response icon1
Avigarg·May 12Data Vault 2.0 Made Simple — Part 2: Building a Mini Data Vault DemoA walkable, banking-flavored demo of how Hubs, Links, and Satellites actually take shape — and where the discipline matters.
Avigarg·Apr 28Snowflake CI/CD Is Not Just DevOps — It Is a Governance ControlWhy enterprise data teams need to rethink Snowflake deployments as governed, auditable, and AI-ready platform controls.
Avigarg·Sep 4, 2025Data Vault 2.0 Made Simple — Part 1: Fundamentals ExplainedWhy Another Data Modeling Approach?A response icon1A response icon1
Avigarg·Jul 23, 2025Real-Time Data Ingestion Pipeline: Kafka to Snowflake via Snowpipe StreamingOverview