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 MoreData is the fuel of the digital economy. However, its true value is realized only when it is processed quickly, reliably, and structured for analysis and reporting. Real-time data streaming…
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 MoreIn this newsletter, we’ll provide an overview of the possibilities for streaming data using Snowflake. The approaches discussed here focus on how Snowflake’s features and capabilities enable ingestion and processing…
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 More