DataEngBytes 2023 - BRI-T1-10 Rishu Saxena & John Cosgrove
summary
Shows how Coalesce runs only on Snowflake with a pushdown model (no data stored in the tool), auto-generates pattern-based SQL (example: SCD2 code that would be ~200 lines is produced instantly), and exposes lineage down to column level with query IDs and failure codes. Describes a three-layer mindset replicate transform mobilize, real-time compile cadence (every 5–30 minutes) and built-in DQ tests, Git-based deployments, and reusable architecture patterns that turn dimensional modeling into automated, auditable pipelines.
AI-written summary · about
chapters (10)
- 0:00Introduction
- 1:45Data as business transformation
- 5:39Customer data focus
- 10:14Modern data stack challenges
- 14:24Data for revenue and advantage
- 17:32Data stack as predictive engine
- 20:00Unstructured data lakes problem
- 22:08Coalesce introduction
- 26:41Scalable data models
- 29:52Change management in pipelines
related talks
29mDataEngBytes 2023 - SYD-T1-08 - Rishu Saxena & John Cosgrove
17mDataEngBytes 2023 - SYD-T1-05 - Patrick Cuba
20mDataEngBytes 2023 PER-T1-10 - Matthew Carter
19mDataEngBytes 2023 - SYD-T3-06 - James Weakley
19mDataEngBytes 2023 - MEL-T1-04 - Michael Hyatt
27mAgile Data Platforms : Innovate at the speed of thought
27mDataOps & Full Snowflake Automation In 1 Click
21mDataEngBytes 2023 - SYD-T3-04 - Abhinav Goyal
