astronomer avatar

Cosmos Dbt Fusion

If you're running dbt Fusion (not Core) with Astronomer Cosmos on Airflow, this walks you through the Fusion-specific setup that trips people up. It requires Cosmos 1.11 or later and only works with LOCAL execution mode pointing to the Fusion binary. The skill covers binary installation via Dockerfile, ExecutionConfig constraints, and warehouse compatibility (Snowflake, Databricks, BigQuery, Redshift only during preview). Notably clear about what won't work: no async mode, no virtualenv since Fusion is a binary. Includes both DbtDag and DbtTaskGroup patterns with actual code. The validation checklist at the end is practical, especially the note about testing a manual run before declaring victory.

skills.sh installs
925
GitHub stars
459
last updated
Aug 21, 2026

Install

$ npx -y skills add astronomer/agents --skill cosmos-dbt-fusion --agent claude-code

Installs into .claude/skills of the current project.

Files

Cosmos + dbt Fusion: Implementation Checklist

Execute steps in order. This skill covers Fusion-specific constraints only.

Version note: dbt Fusion support was introduced in Cosmos 1.11.0. Requires Cosmos ≥1.11.

Reference: See reference/cosmos-config.md for ProfileConfig, operator_args, and Airflow 3 compatibility details.

Before starting, confirm: (1) dbt engine = Fusion (not Core → use cosmos-dbt-core), (2) warehouse = Snowflake, Databricks, Bigquery and Redshift only.

Fusion-Specific Constraints

ConstraintDetails
No asyncAIRFLOW_ASYNC not supported
No virtualenvFusion is a binary, not a Python package
Warehouse supportSnowflake, Databricks, Bigquery and Redshift support while in preview

1. Confirm Cosmos Version

CRITICAL: Cosmos 1.11.0 introduced dbt Fusion compatibility.

# Check installed version
pip show astronomer-cosmos

# Install/upgrade if needed
pip install "astronomer-cosmos>=1.11.0"

Validate: pip show astronomer-cosmos reports version ≥ 1.11.0


Sponsors

Details

Repository
github.com/astronomer/agents
Category
Databases
First seen
May 16, 2026

More from astronomer/agents

All 24

Recommended

More Databases
1mindrally avatarfastify-typescriptmindrally/skillsGuidelines for building high-performance APIs with Fastify and TypeScript, covering validation, Prisma integration, and testing best practices883skills.sh installs
2moizibnyousaf avatarbackend-developmentmoizibnyousaf/ai-agent-skillsBackend API design, database architecture, microservices patterns, and test-driven development. Use for designing APIs, database schemas, or backend system arch874skills.sh installs
3mindrally avatarkyselymindrally/skillsGuidelines for developing with Kysely, a type-safe TypeScript SQL query builder with autocompletion support815skills.sh installs
4ovachiever avatarsecurity-auditorovachiever/droid-tingsContinuous security vulnerability scanning for OWASP Top 10, common vulnerabilities, and insecure patterns. Use when reviewing code, before deployments, or on f781skills.sh installs
5kirkluokun avatarstock-trade-journalkirkluokun/awesome-a-stock-openclawskills按统一规则记录交易流水。按个股落 Markdown,同时写入 SQLite 便于统计与量化复盘。773skills.sh installs
6syncfusion avatarsyncfusion-react-query-buildersyncfusion/react-ui-components-skillsComprehensive guide to implementing Syncfusion React Query Builder component. Use this skill when building advanced filter interfaces, creating complex data que734skills.sh installs