Yashwanth Sundaram

@yashwanth_sundaram

Free member

Platform engineer focused on cost optimization and Kafka at scale.

Coimbatore, Tamil Nadu0–2 years1 questions0 answers

KafkaSQL

Streak: 1d
XP: 168
Lessons done: 1
Studio passes: 1

First LessonFirst Ticket

Share on X Share on LinkedIn

Questions

votes

answers

views

SCD Type 2 for customers: valid_to NULL or sentinel date?

Designing dim_customer SCD2 in Snowflake. Team is split on valid_to IS NULL for the current row versus a '9999-12-31' sentinel. Downstream dbt models and BI tools mix both patterns already. What are the real pros and cons in production pipelines?

Data Warehousingwarehousingscd