SQL - Redshift code completion stopped working, can't find schema

Answered

Until the latest update, or maybe the one before, integration between the SQL editor and Redshift was pretty good. I could highlight a SQL statement and run it, and code completion worked for table names.

Now, however, with the Database Navigator plugin, though I can connect to Redshift OK, the editor can't see any of the Redshift schema. When I click on the Schema dropdown all I see is "nothing here". And, frustratingly, even if I explicitly type in a schema name, I can't run any SQL from the editor.

So it appears that something has changed in the most recent versions of Pycharm, and not for the better.

Any advice appreciated.

 

 

 

1 comment
Comment actions Permalink

Please file an issue about it to Database issue-tracker: https://youtrack.jetbrains.com/issues/DBE.

0

Please sign in to leave a comment.