Redshift - Cluster Inspection - Schemas not loading

[Jonnokc]

Describe the bug
With Redshift connections, within the connection tree, the schemas directory is blank and does not load. Just says "nothing here".

However the schemas and tables do exist and intellisense detects them.

To Reproduce
Steps to reproduce the behavior:

1. Connect to Redshift cluster
2. Expand database
3. Expand Schemas

Expected behavior
I expect to see another sub folder for each schema and to be able to expand each of these to see the tables within each schema.

Screenshots

Desktop (please complete the following information):

• SQLTools Version v0.22.11
• VSCode Version: 1.47.3
• OS: Mac
• Driver:
  • PostgreSQL/Redshift
  • MySQL/MariaDB
  • MSSQL/Azure
  • SQLite
  • Other? Which...
• Database version: Redshift 1.0.17498

[rfrank14]

Seeing this issue as well on Windows 10.

[mtxr]

Can you update it to v0.23? You shoudl be able to see more errors in the logs there. Also please update the driver to lastest version.

@rfrank14 @Jonnokc

[salidux]

Same here on macOS Catalina, VSCode Version: 1.48.0, SQLTools v0.23.0, and Redshift driver v0.2.0

[1598898995671] INFO  (ext): EXECUTING COMMAND => sqltools.selectConnection
[1598898995672] INFO  (ext): EXECUTING COMMAND => sqltools.getConnections
[1598898995673] INFO  (ls): REQUEST RECEIVED => connection/GetConnectionsRequest
[1598898995673] INFO  (ext): EXECUTING COMMAND => sqltools.getConnections
[1598898995674] INFO  (ls): REQUEST RECEIVED => connection/GetConnectionsRequest
[1598898995675] INFO  (ls): REQUEST RECEIVED => connection/GetConnectionPasswordRequest
[1598898997110] INFO  (ls): REQUEST RECEIVED => connection/ConnectRequest
[1598898997111] INFO  (ls): Connection instance created for Redshift.
    ns: "conn-manager"
[1598898998176] INFO  (ext): Connection explorer changed. Will be updated.
    ns: "conn-man:explorer"
[1598898998181] INFO  (ext): EXECUTING COMMAND => sqltools.getConnections
[1598898998182] INFO  (ls): REQUEST RECEIVED => connection/GetConnectionsRequest
[1598898998197] INFO  (ext): Connection explorer changed. Will be updated.
    ns: "conn-man:explorer"
[1598898998235] INFO  (ext): EXECUTING COMMAND => sqltools.getConnections
[1598898998236] INFO  (ls): REQUEST RECEIVED => connection/GetConnectionsRequest
[1598898998236] INFO  (ext): EXECUTING COMMAND => sqltools.getConnections
[1598898998239] INFO  (ls): REQUEST RECEIVED => connection/GetConnectionsRequest
[1598898998240] INFO  (ext): Connection explorer changed. Will be updated.
    ns: "conn-man:explorer"
[1598898998445] INFO  (ext): EXECUTING COMMAND => sqltools.getConnections
[1598898998445] INFO  (ls): REQUEST RECEIVED => connection/GetConnectionsRequest
[1598899010776] INFO  (ext): EXECUTING COMMAND => sqltools.getChildrenForTreeItem
[1598899010776] INFO  (ls): REQUEST RECEIVED => connection/GetChildrenForTreeItemRequest
[1598899014166] INFO  (ext): EXECUTING COMMAND => sqltools.getChildrenForTreeItem
[1598899014167] INFO  (ls): REQUEST RECEIVED => connection/GetChildrenForTreeItemRequest
[1598899018634] INFO  (ext): EXECUTING COMMAND => sqltools.getChildrenForTreeItem
[1598899018635] INFO  (ls): REQUEST RECEIVED => connection/GetChildrenForTreeItemRequest

[kbec]

In the interest of housekeeping, I think this is a duplicate of #604.

[gjsjohnmurray]

Duplicate