Auto-Generate Column Schema from Your Database
Use the Bruin extension to automatically pull column names and data types from your database into your asset definitions - no manual entry needed.
What
Goal - Automatically generate and maintain column metadata for your assets by pulling schema information directly from the destination database.
Audience - Data engineers who want to keep their asset metadata in sync with the actual database schema without manual updates.
Prerequisites
- Bruin CLI installed
- The Bruin VS Code or Cursor extension installed
- An asset that has been materialized in the destination database
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.