Closed gjsjohnmurray closed 1 year ago
Does the SQLTools channel of your Output tab give any clues about what's happening when you manually trigger the lookup with ctrl+space?
I'm not seeing similar problems with the standard PostgreSQL driver, so you might need to report this to the author of the dedicated driver.
@gjsjohnmurray thank you for the reply.
I tried using ctrl+space again. I had more patience this time. Upon waiting 20-30 seconds after pressing ctrl+space intellisense in sql tools gave me table options under a schema.
Similarly, in the select statement I wrote the table alias then ".", pressed ctrl+space, and had to wait ~45 seconds for column names to be suggested by intellisense.
Do you have any idea on why it is taking so long for table and column names to be suggested? Is this an issue with "SQL tools" extension, the "Redshift Driver (Dedicated ver)" extension, or something else? Any guidance would be appreciated!
This file holds the queries that the driver runs on behalf of the main extension:
https://github.com/kj-9/sqltools-redshift-driver/blob/main/src/ls/queries.ts
Maybe they can be made more efficient.
@Data-Science-Link if you want to pursue this please open an issue on the extension repo at https://github.com/kj-9/sqltools-redshift-driver and maybe link to this one.
I'm closing this here.
Originally posted by @Data-Science-Link in https://github.com/mtxr/vscode-sqltools/issues/110#issuecomment-1252898329