Quoting issues #261
Quoting issues #261
Conversation
|
Anyone did look into this improvement? It seems this is what I'm facing too. I'm trying to generate the SQL query including the external schema's tables however the generated SQL is formatted with the double quotes on the schema name or table name. Redshift isn't supporting the quotes in the query though |
|
@Honza-m I figured out the change isn't fixing my issue. I'm setting the schema = |
Hi,
I've run into the issue described here and partially fixed here. On my project, it seems like Redshift will not only quote the table name, but also the schema name in some instances, which breaks more stuff than the initial fix addresses.
By unquoting the schema and table names in a couple of extra places, I was able to get my project to autogenerate migrations for the offending schemas without issues. The problems mostly occurred around foreign key resolving, as far as I can tell.
These changes worked for my project, but I'm unfamiliar with inner workings of sqlalchemy dialects, so if there is a better place for unquoting the names please let me know. I've also struggled with coming up with unit tests for these changes, so any advise would be much appreciated.