[Feature] Cloud Ephemeral Job

[trouze]

Is this your first time submitting a feature request?

• I have read the expectations for open source contributors
• I have searched the existing issues, and I could not find an existing issue for this feature
• I am requesting a straightforward extension of existing dbt functionality, rather than a Big Idea better suited to a discussion

Describe the feature

Through this, we could support a sort of ephemeral cloud job that:

• creates a deploy job on platform in the specified environment
• triggers that job, polls for results
• gets the results logs and prints them out to the terminal
• cleans up / removes the job (maybe?)

The use-case for this is we sometimes get asked about being able to perform the dbt-core like behavior where in the CLI you can easily swap --target, which you cannot do in cloud (of course you need access).

Describe alternatives you've considered

No response

Who will this benefit?

No response

Are you interested in contributing this feature?

No response

Anything else?

No response