Coalesce 2024: implementing real-time slowly changing dimensions (SCD) type 2 with dbt
Learn how Hostinger, a leading European provider of web hosting solutions, leverages dbt to implement slowly changing dimensions (SCD)...and not go bankrupt while doing it at scale.
Learn how Hostinger, a leading European provider of web hosting solutions, leverages dbt to implement slowly changing dimensions (SCD)...and not go bankrupt while doing it at scale.
They'll cover how they used the Debezium connector to tackle the challenges of change data capture (CDC), and how leveraging dynamic incremental predicates allowed them to scale their solution at a fraction of the cost using BigQuery.
Speakers
Augustinas Karvelis, Analytics Engineer @ Hostinger
Valentinas Mitalauskas, Analytics Engineering Lead @ Hostinger