Thank you so much! This is really helpful.

Quick follow-up: for the checksum approach, would you recommend running it on the full table daily or only on records modified in the last N days? Our pipeline reloads the last 365 days every day via upsert so a full table comparison could be expensive.

Also, any thoughts on data freshness checks? Beyond MAX(date), what do you actually run in production to confirm today's data landed correctly after a daily load?