kj-9/sqltools-redshift-driver

Include External Schemas in connection tree view

r4nyc opened this issue · 9 comments

r4nyc commented

Currently it appears that the tree view is only showing local schemas (The schemas you get back from the query "SELECT * FROM svv_redshift_schemas")

It would be very helpful to include external schemas as well. External schemas are commonly used to expose data in other databases or the Glue Hive Meta store.
https://docs.aws.amazon.com/redshift/latest/dg/r_CREATE_EXTERNAL_SCHEMA.html

You can get the combined list of schemas with the query
SELECT * FROM svv_all_schemas
Or you can just get the external schemas
SELECT * FROM svv_external_schemas

kj-9 commented

Sorry for my late reply and I closed this issue by mistake...

As you mentioned, it may be not hard work to show external tables by adjusting some queries.
Currently, I'm refactoring to make this repository as a single code base for the redshift driver, and after that I'll work on this topic.

kj-9 commented

Repoen this issue.

r4nyc commented
  • 👍1
pbayerle commented

hello, curious if there are any updates as to when this will be resolved 🙂

kj-9 commented

Hi @pbayerle .
Sorry for my late reply.

I'm currently don't have much time to fix this issue. So, sorry again I can't tell you when to be resolved.
If you could help this issue, a PR is appreciated.

peterbayerle commented

Hello, I just created a PR addressing this issue. I tested this locally and everything seems to work. I'm not sure how to search for schemas and tables in SQL tools (am I using an old version of the extension?) but changed the queries associated with this search functionality, too.

kj-9 commented

Thank you so much for the very quick response @peterbayerle !
I tested this in my environment and worked well.

I merged #2 and I will publish this feature as v0.0.3 soon.

  • 😄1
kj-9 commented

I just published v0.0.3. please check out.
Thanks again for huge help @peterbayerle !

  • 👍1
peterbayerle commented

happy to help @kj-9! I use this tool every day at work and am happy to continue making contributions in my spare time

  • ❤️2