We’re excited to connect you with one of our experts! Please fill out this form with your contact information and a brief overview of the topics you’d like to discuss during your free consultation. This will ensure we match you with the best expert to address your specific needs.
Introduction dbt Labs has recently acquired SDF, a company known for its cutting-edge SQL comprehension technology. This acquisition brings several key benefits, including: Faster dbt project compilation Improved developer experience…
Read MoreUnderstanding Data Vault on Wide Tables Storing data as wide tables in a data lake while applying a logical Data Vault layer using views presents unique challenges. The goal is…
Read MoreHow Coalesce Manages Column Propagation Change is inevitable in data management. Whether you like it or not, IT table structures evolve due to various reasons. When these changes occur, they…
Read MoreInvesting in Data Warehousing Data warehousing is a crucial step for businesses looking to manage, integrate, and analyze large volumes of data efficiently. But at what point should a company…
Read MoreWhat is a Business Glossary? A Business Glossary is a structured collection of business terms with clear definitions, ensuring consistency and accuracy across an organization. It serves as a single…
Read MorePII Business Keys In modern data architecture, handling Personally Identifiable Information (PII) is a crucial aspect of maintaining data privacy and integrity. One common challenge in Data Vault modeling is…
Read MoreWhat is a Microbatch? Microbatch is an innovative incremental strategy designed for large time-series datasets. Introduced in dbt Core version 1.9 (currently in beta), it complements existing incremental strategies by…
Read MoreUnderstanding Effectivity Satellites in Data Vault Effectivity satellites play a crucial role in Data Vault modeling by tracking changes and deletions in source systems. In this article, we’ll explore when…
Read MoreMulti-Active Satellites vs. Dependent Child Links In the realm of Data Vault modeling, practitioners often encounter scenarios where multiple descriptive entries are valid simultaneously for a single business entity. Two…
Read MoreInterview with Julien Redmond Welcome to another edition of Data Vault Friday! I'm Michael Olschimke, CEO of Scalefree, and every Friday at 11 o'clock, we dive into discussions about Data…
Read MoreModelling Salesforce History Tables Salesforce tracks changes to configured attributes by storing them in history tables. This data, which includes record ID, field name, old and new values, and timestamps,…
Read MoreData Quality Testing In today’s data-driven world, poor data quality can lead to costly mistakes. From misguided strategic decisions to operational inefficiencies and poor customer experiences, the impact of bad…
Read More