Snowflake-Labs/schemachange

SQL Syntax error when Snowflake role name includes special characters such as hyphens

jonathancisneros opened this issue · 4 comments

jonathancisneros commented

The USE ROLE and the other USE query template strings here:
https://github.com/Snowflake-Labs/schemachange/blob/master/schemachange/cli.py#L213

are not using quoted values for the placeholder values, if there are special characters in the name of those values, the execution of the reset_session function fails with SQL compilation or syntax error.

please update the USE xxx template strings to support special characters by using quoted values like this:
_q_set_sess_role = 'USE ROLE "{role}";'

dwelden commented

Duplicate of #186?

sfc-gh-tmathew commented

Thank you for highlighting this gap @dwelden @jonathancisneros

Just released 3.7.0 that addressed roles with special characters. Please test it out and let us know if this issue can be closed.

dwelden commented

This issue is resolved.