Support dbt clone

[tatiana]

Context

Cosmos 1.7 does not support dbt clone.

The dbt clone command clones selected nodes from the specified state to the target schema(s). This command makes use of the clone materialization:

• If your data platform supports zero-copy cloning of tables (Snowflake, Databricks, or BigQuery), and this model exists as a table in the source environment, dbt will create it in your target environment as a clone.
• Otherwise, dbt will create a simple pointer view (select * from the source object)
• By default, dbt clone will not recreate pre-existing relations in the current target. To override this, use the --full-refresh flag.
• You may want to specify a higher number of threads to decrease execution time since individual clone statements are independent of one another.

The clone command is useful for:

• blue/green continuous deployment (on data warehouses that support zero-copy cloning tables)
• cloning current production state into development schema(s)
• handling incremental models in dbt Cloud CI jobs (on data warehouses that support zero-copy cloning tables)
• testing code changes on downstream dependencies in your BI tool

https://docs.getdbt.com/reference/commands/clone

Acceptance criteria

• Implement a Cosmos operator that supports dbt clone for either Snowflake, Databricks or BQ