"Do data architects exist anymore?" Wow, as a recovering data architect that's a loaded question.
dbt data quality - Implementing data quality tests and using dbt extensions for enhanced data quality checks.
Event streams have always been problematic to analyze in SQL. This is how we do it.
"When I see David Jayatillake and Tristan Handy comment on Firebolt's approach it is clear that Firebolt is on track."
"If you cannot constrain a thing, you cannot ingest that thing."
"There's no point in measuring anything, if the data team can't measure itself."
This has nothing to do with the DW itself. But if you miss it, you'll fail with your warehouse project.
Rob says: delete nothing, update only metadata.
An issue many coming into the data warehouse world is difficulty with is managing time variance at scale and efficiency.
One of the more common and costly mistakes in the many data implementations is confusion about keys.
I'm not a fan of dimensional modeling. It exists to solve physical problems, not logical problems.