Patrick CubainThe 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 29Oct 29
Patrick CubainThe 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
Patrick CubaSnowflake 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
Patrick CubainThe 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
Patrick CubainThe 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
Patrick CubainThe 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
Patrick CubainThe 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
Patrick CubainThe 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
Patrick CubainThe 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
Patrick CubainThe Modern ScientistData Vault on Snowflake and Apache IcebergA good data vault model is a data model that reflects the business architecture by accurately representing business objects as defined by…Jul 30Jul 30