schemachange icon indicating copy to clipboard operation
schemachange copied to clipboard

Published 20 hours ago • verified publisher icon Snowflake-Labs

Role names containing dashes

Open TLI-BAY opened this issue 1 year ago • 7 comments

https://github.com/Snowflake-Labs/schemachange/blob/2eb5d52b3aa5597465a9478b2a4e35dd913d0e17/schemachange/cli.py#L210C1-L210C1

In case role names contain dashes this leads to a sql error. At the moment additional escaped quotes must be provided in order to get it running. Would be really nice if quotes would be added by default to cover this scenario.

In schemachange 3.4.2 it worked without extra quotes (on snowflake-python-connector 2.8.1) In the current version of schemachange (3.5.3) extra quotes have to be added manually (on snowflake-python-connector 3.0.4)

TLI-BAY avatar Jul 20 '23 12:07 TLI-BAY