Understand Materialization with Render
Use bruin render to see how materialization transforms your SQL queries at runtime - from append inserts to full refresh table recreation.
What
Goal - Understand how Bruin's materialization strategies transform your queries at runtime by using the bruin render command and the render panel in VS Code.
Audience - Data engineers who want to understand what SQL Bruin actually executes behind the scenes.
Prerequisites
- Bruin CLI installed
- A Bruin project with SQL and/or Python assets
More guides
Capstone: add returns to the pipeline
Extend the project, prove the result, and assess the finished pipeline.
Describe the model in its asset definition
Keep the metric definition, owners, limits, and checked examples next to the SQL.
Load and profile the source data
Load local commerce data and check its shape before modeling it.