Dynamic Tables for Data VaultHow experimenting with Dynamic Tables on Snowflake led to improvements in the Data Vault patterns.Dec 101Dec 101
Published inThe Modern ScientistSimple PIT table ConstructsMany data engineers question why data vault chooses to split staged data in your data pipeline into three table types (hubs, links and…Oct 291Oct 291
Published inThe Modern ScientistData Vault solves Time-Crime.It’s an age-old problem when processing data into a target data model designed to track true changes; are the records being processed in…Oct 22Oct 22
Published inThe Modern ScientistSnowflake Data Clean Room (Native App)Circle back to December 2023 and Snowflake acquires Samooha, a company whose sole product are data clean rooms built on Snowflake. Both…Oct 16Oct 16
Published inThe Modern ScientistThe Different Grains of Multi-Active Records.Common feedback when data professionals learn of what a data vault model is, is that they foresee the large number of tables being…Oct 81Oct 81
Published inThe Modern ScientistData Vault on Snowflake: …and the other 80% of the world’s dataShockingly most of the world’s data is not in a structured or semi-structured form; according to Gartner, 80% of the world’s data is…Oct 21Oct 21
Published inThe Modern ScientistThe Link between Effectivity Satellites and Driver Keys.Within the Data Vault community there is a misconception of what an effectivity satellite table is, how to model it, where it should be…Sep 24Sep 24
Published inThe Modern ScientistData Vault in Snowflake: Amp it up on Data Vault knowledgeAccording to Gartner’s hype-cycle for AI 2024, Generative AI (GenAI) sits on the “Peak of inflated expectations”, which Gartner describes…Sep 10Sep 10
Published inThe Modern ScientistData Vault on Snowflake: How to Twine on SnowflakeTo begin with, what do we mean by twine? In the data modelling community, we refer to twine as the technique to intertwine two or more…Aug 27Aug 27
Published inThe Modern ScientistData Vault on Snowflake: a Classification & Tagging FrameworkA common challenge in modelling any data is identifying what (if any) data needs to be highly protected, confidential or private and what…Aug 13Aug 13
