[Feature] Possibility to run a custom dbt command

[michal-mrazek]

Description

Helo,
my apologies if this has been asked already. AFAIK cosmos supports only a limited set of dbt operations and in our workflow, we need to run also other dbt commands. For example dbt source freshness. Is there a way we can run this dbt command without the BashOperator, rather in cosmos, using the same settings and profiles please?

What we currently do is that we build a custom operator on top of DbtVirtualenvBaseOperator and make the self._base_cmd configurable based on the input. I wonder if this would be the correct way or we can do it better with cosmos? Thanks :)

Use case/motivation

No response

Related issues

No response

Are you willing to submit a PR?

• Yes, I am willing to submit a PR!

[pankajastro]

FYI: We have PR #1107 to support dbt source freshness

[michal-mrazek]

Thanks! Is there please a plan to also support the dbt clone? :)

[pankajastro]

I think it will be a good addition. Would you like to submit a PR for the clone command? We have some operator implementations here https://github.com/astronomer/astronomer-cosmos/tree/main/cosmos/operators

[michal-mrazek]

Thanks, will do!

[github-actions]

This issue is stale because it has been open for 30 days with no activity.