search

mtxr / vscode-sqltools

Database management for VSCode
https://vscode-sqltools.mteixeira.dev?utm_source=github&utm_medium=homepage-link
MIT License
1.48k stars 296 forks source link

Redshift Driver not Introspecting Database #1007

Closed broander closed 1 year ago

broander commented 1 year ago

I'm connecting to a Redshift instance, and successfully connecting, but the driver in VSCode is not successfully introspecting any of the objects in the database like the schemas, etc. Using the postgres driver in DBeaver I am able to see the objects in the DB.

VSCode SQL Tools Redshift driver: image

DBeaver Postgres driver: image

Here's what the SQL Tools output looks like when initiating a connection: [1665499153104] INFO (ext): Connection explorer changed. Will be updated. ns: "conn-man:explorer" [1665499153108] INFO (ext): EXECUTING COMMAND => sqltools.getConnections [1665499153109] INFO (ls): REQUEST RECEIVED => connection/GetConnectionsRequest [1665499153115] INFO (ext): EXECUTING COMMAND => sqltools.getChildrenForTreeItem [1665499153116] INFO (ls): REQUEST RECEIVED => connection/GetChildrenForTreeItemRequest [1665499153152] INFO (ext): EXECUTING COMMAND => sqltools.getConnections [1665499153153] INFO (ls): REQUEST RECEIVED => connection/GetConnectionsRequest [1665499153155] INFO (ext): EXECUTING COMMAND => sqltools.getConnections [1665499153157] INFO (ls): REQUEST RECEIVED => connection/GetConnectionsRequest [1665499153157] INFO (ext): Connection explorer changed. Will be updated. ns: "conn-man:explorer" [1665499153189] INFO (ext): EXECUTING COMMAND => sqltools.getConnections [1665499153190] INFO (ls): REQUEST RECEIVED => connection/GetConnectionsRequest [1665499153191] INFO (ext): EXECUTING COMMAND => sqltools.getConnections [1665499153191] INFO (ls): REQUEST RECEIVED => connection/GetConnectionsRequest [1665499153191] INFO (ext): Connection explorer changed. Will be updated. ns: "conn-man:explorer" [1665499153414] INFO (ext): EXECUTING COMMAND => sqltools.getConnections [1665499153415] INFO (ls): REQUEST RECEIVED => connection/GetConnectionsRequest [1665499153420] INFO (ext): EXECUTING COMMAND => sqltools.getChildrenForTreeItem [1665499153421] INFO (ls): REQUEST RECEIVED => connection/GetChildrenForTreeItemRequest [1665499176074] INFO (ext): Connection explorer changed. Will be updated. ns: "conn-man:explorer" [1665499176081] INFO (ext): EXECUTING COMMAND => sqltools.getConnections [1665499176083] INFO (ls): REQUEST RECEIVED => connection/GetConnectionsRequest [1665499176087] INFO (ext): EXECUTING COMMAND => sqltools.getChildrenForTreeItem [1665499176088] INFO (ls): REQUEST RECEIVED => connection/GetChildrenForTreeItemRequest

Expected behavior is it should show the DB objects like in the DBeaver screenshot above.

Desktop (please complete the following information):

Thanks for your help!

gjsjohnmurray commented 1 year ago

Please install the community contributed driver from https://marketplace.visualstudio.com/items?itemName=kj.sqltools-driver-redshift and define a connection to use that.

broander commented 1 year ago

Perfect, didn't notice there was a dedicated driver. I just tried it and it works fine. Thank you!