[Bug] $ gets converted to [$] for snowflake column descriptions

[LewendbtLabs]

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

The "$" is getting converted to "[$]" and our usual escape mechanisms (", ', >, . , markdown) aren't working for it. I can create descriptions with "$" directly in Snowflake, so it seems to be a dbt thing. The column descriptions are being persisted to the database. The dbt documentation is generated as expected.

According to @mikealfare "

dbt-snowflake/dbt/include/snowflake/macros/adapters.sql

Line 12 in 29467c3

{{ adapter.quote(column_name) }} COMMENT $${{ column_dict[matched_column]['description'] | replace('$', '[$]') }}$$

"

Expected Behavior

The $ should show up as $ in the column description in snowflake.

Steps To Reproduce

My writeup is in the dbt notion .

Essentially you need a yml file for the column description with a $ in the comments.
Then,
+persist_docs:
columns: true

Relevant log output

No response

Environment

- OS:running in dbt cloud
- Python: whatever cloud runs
- dbt-core: latest version of dbt
- dbt-snowflake: latest version

Additional Context

No response

[LewendbtLabs]

This was also discussed in an internal slack channel. https://dbt-labs.slack.com/archives/C067EUS2D7S/p1721830759272439