Implement `DbtBuild<EXECUTION_MODE>Operator` in Astronomer Cosmos

[sanromeo]

Hello, I want to suggest the implementation of a new operator: DbtBuild<EXECUTION_MODE>Operator. This operator would be a valuable addition for users looking to streamline their data build processes using dbt within the Astronomer Cosmos.

Proposed Feature: The DbtBuild<EXECUTION_MODE>Operator would unify the functionality of existing operators such as DbtRun<EXECUTION_MODE>Operator, DbtTest<EXECUTION_MODE>Operator, and others. This unified operator would handle running models, testing, seeding seeds, and taking snapshots, all in a single task. (https://docs.getdbt.com/reference/commands/build)

Benefits:

• Simplicity: Reduces the complexity of workflows by combining multiple tasks into one.
• Efficiency: Saves time and resources by managing all dbt-related tasks in one operator.
• Consistency: Ensures consistent execution of dbt tasks across different stages of the data pipeline.

I believe this feature would greatly enhance the utility and user experience of Astronomer Cosmos, particularly for those integrating dbt build command into their workflows.

Looking forward to your thoughts on this suggestion.

[dosubot[bot]]

🤖

It seems like you've got this under control, if you want help or have specific questions, let me know what I can do for you!

[tatiana]

We'd love to see this feature implemented, @sanromeo! Please, let us know if you or your team would like to make this contribution.

[dylanharper-qz]

@tatiana I started work on this here: https://github.com/astronomer/astronomer-cosmos/pull/780

But then I noticed this work and wonder if I should wait for it to be finished: https://github.com/astronomer/astronomer-cosmos/pull/774

At Quizlet, we're excited about having a Build operator because it will let us completely migrate to Cosmos. One of our daily dbt runs uses third party packages with thousands of models and tests. Without this sort of operator we weren't sure how to handle it with Cosmos.

[tatiana]

Hi @dylanharper-qz thanks a lot for working on this!

Good news: we merged #774 yesterday.

At Quizlet, we're excited about having a Build operator because it will let us completely migrate to Cosmos. One of our daily dbt runs uses third party packages with thousands of models and tests. Without this sort of operator we weren't sure how to handle it with Cosmos.

This is certainly a challenge more people face. There's a lot of value in the work you started!