`case_sensitive_cols` parameter for generating unit tests via `generate_unit_test_template`

[dbeatty10]

Describe the feature

There is a case_sensitive_cols parameter for both generate_source and generate_base_model that indicates whether you want column names to be in lowercase, or to match the case from the source relation (only if True).

We want to do this for generate_unit_test_template too.

Describe alternatives you've considered

If we don't implement this, then there will be no way to support case-sensitive column names.

This is okay for now, because dbt unit tests don't support case-sensitive column names yet:

• [Bug] Unit tests fail when input has a column name with a quoted identifier dbt-adapters#205
• [Bug] Unit tests fail when input contain reserved-word-named columns dbt-core#10112

See dbt-labs/dbt-adapters#204 for an open PR.

Additional context

Here is a related issue: #254

Who will this benefit?

This is only relevant to folks that use all of the following:

• unit tests
• codegen to scaffold unit tests
• case-sensitive column names

Are you interested in contributing this feature?

[github-actions]

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please comment on the issue or else it will be closed in 7 days.