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

Is this a new bug in dbt-snowflake?

[X] I believe this is a new bug in dbt-snowflake
[X] 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 "https://github.com/dbt-labs/dbt-snowflake/blob/29467c32c005de99fdce868fa551e728928a50bf/dbt/include/snowflake/macros/adapters.sql#L12"

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

dbt-labs / dbt-snowflake