AI Analyst for Climate Tech Data with Redshift & Cursor
Build a local AI analyst for climate tech data using Bruin CLI, Redshift, and Cursor.
What
Goal - Build a local AI analyst for climate tech data using Bruin CLI, Redshift, and Cursor.
Audience - Data engineers and analysts working with climate and sustainability data in Redshift.
Prerequisites
- Climate tech data already loaded in Redshift
- Bruin CLI installed
- Cursor installed
- An AI CLI installed for
bruin ai enhance(Claude Code, OpenCode, or Codex) - Bruin MCP configured for Cursor
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.