[Feature] dbt source rendering: Use . instead of _ between schema & table

[corsettigyg]

Description

Currently in cosmos, sources are rendered as emptyOperators with a task_id of {schema}_{table}_source

The main issue with this naming convention is that the usual convention of naming tables with the schema uses dot (.) instead of underscore (_), and by using underscore in the naming of our tasks, it is not possible to properly identify where the schema name ends and where the table name begins.

Use case/motivation

By having a logical separation of the schema and the table, it is easy to extend cosmos and add extra features to the sources. At my company we are adding sensors before the sources, but the process becomes way harder because of something as simple as using the _ instead of . in the name of the task.

Related issues

No response

Are you willing to submit a PR?

• Yes, I am willing to submit a PR!

[tatiana]

@corsettigyg, thanks for your feedback! Would this address the issue if we were to use __ instead of _ as a separator between schema & table?

[corsettigyg]

@tatiana totally

[tatiana]

I just discussed this with @pankajkoti and @pankajastro, and I was concerned about making this change backwards compatible.

The preferred approach is to make it backwards compatible by having yet another configuration—and having a ticket to make the default __ in Cosmos 2.0. We'll squeeze in this change in Cosmos 1.8. The configuration could be within RenderConfig.

@corsettigyg, would you by any chance have bandwith of contributing to this?