[Bug] [SPIKE] Root Cause Analysis of quoting/case handling issues

[colin-rogers-dbt]

Is this a new bug in dbt-snowflake?

• I believe this is a new bug in dbt-snowflake
• I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

We have a number of bugs related to unexpected behavior due to the complexity in handling case sensitivity and quoting. This ticket will track our analysis / map out next steps to address this holistically.

Expected Behavior

Users aren't constantly tripped up by this.

Steps To Reproduce

See attached issues

Relevant log output

No response

Environment

- OS:
- Python:
- dbt-core:
- dbt-snowflake:

Additional Context

No response

[adrianburusdbt]

Linked issues:

• [CT-2178] Handling column names having / while altering the table dbt-adapters#63
• [Bug] dbt unit tests raise an error when QUOTED_IDENTIFIERS_IGNORE_CASE = true in Snowflake #1160
• [Bug] Adding a column with on_schema_change=(append_new_columns, sync_all_columns) fails when the column name contains whitespace #1231
• [Bug] Impossible to use adapter.get_relation to find quoted case-sensitive relations in Snowflake #1252
• [Bug] Unit tests fail when input has a column name with a quoted identifier dbt-adapters#205
• [Bug] Adding a column with on_schema_change=(append_new_columns, sync_all_columns) fails when the column name contains whitespace #1231
• [Bug] Impossible to use adapter.get_relation to find quoted case-sensitive relations in Snowflake #1252
• [Bug] Setting the enable_iceberg_materializations flag to True on a dbt project that is connected to a Snowflake account with QUOTED_IDENTIFIERS_IGNORE_CASE = true results in error tuple.index(x): x not in tuple #1227
• [Bug] Drop temp tables when doing a full refresh on Dynamic table by respecting qualified names #1103

[Tonayya]

Hi @colin-rogers-dbt got another one of these, submitted here just fyi 😄

[amychen1776]

Also has this one dbt-labs/dbt-adapters#265