Quoted table names cause wrong statements being generated
When I have table on snowflake named some_db.some_schema."application" permifrost will generate statement like:
grant select on table some_db.some_schema.application to role some_role
Which will cause snowflake error since the object without quotes does not exist
The correct behaviour should be:
grant select on table some_db.some_schema."application" to role some_role
Using QUOTED_IDENTIFIERS_IGNORE_CASE option is not the solution since it just makes everything in quotes uppercase and what we need is actual name of the table
The only solution I see for now is preserving an original case from show tables query and putting every table in double quotes.
Edited by Alex Ostruk