Published inThe Modern ScientistData Vault is Information MappingAt the heart of a data-driven organization is the automation of business processes and information state. Core business capabilities and…2d ago2d ago
Published inThe Modern ScientistThe Death of Hash KeysAn innovation introduced in data vault 2.0 is the adoption of surrogate hash keys to join adjacent tables on. The act of hashing is…Feb 182Feb 182
Published inThe Modern ScientistMiddle out your Data Strategy on Data Vault and Apache IcebergIf we were to swap out each component of a data warehouse over time until every component was replaced, is it still the same data…Jan 28Jan 28
Published inThe Modern Scientistthe Modern Data Vault StackFor decades data analytics has been delivered in a standard pattern of zones and layers, each with a special purpose and governed by…Jan 141Jan 141
Published inThe Modern ScientistDynamic Tables for Data VaultHow experimenting with Dynamic Tables on Snowflake led to improvements in the Data Vault patterns.Dec 10, 20241Dec 10, 20241
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 29, 20242Oct 29, 20242
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 22, 2024Oct 22, 2024
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 16, 2024Oct 16, 2024
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 8, 20241Oct 8, 20241
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 2, 20241Oct 2, 20241
