Repository navigation
[Feature Request] Complete support for Redshift Spectrum #613
Description
I have played around with DBCode in VSCode for a while and have found that it does support Redshift Spectrum but there is not much documented on this. I can query redshift spectrum tables in the SQL editor, however I noticed that in the DB explorer it doesn't show any tables under the redshift spectrum schema I have in my DB. In IntelliJ, database integration is native and it supports Redshift Spectrum and you are also able to actually see the tables under the Redshift Spectrum schema. I suspect the difference between DBCode and IntelliJ's implementation is that DBCode only looks at the information_schema table to get the table listing, whereas IntelliJ must also check the svv_external_tables to get the table listing for Redshift Spectrum. Would it be possible for DBCode to do the same? Thanks.
Activity
mikeburgh commentedon Aug 1, 2025
This has been added to 1.14.24 which has been released, let me know if you need anything else, or if it's not working how you expect it.
rishitank commentedon Aug 2, 2025
@mikeburgh Thanks, however this release seems to have broken Redshift connections: #644
mikeburgh commentedon Aug 2, 2025
Thanks, let me know if you still hit issues once 1.14.25 is out.. should fix the introspection and then let these tables appear.. one thing that trips me up, they show up in their own schema.. not in the main one.. there is also a DB created for them.. but that DB does not hold the schema.. so I don't show the db since it has no schemas it's not really relevant.
rishitank commentedon Aug 4, 2025
Thank you it is working now 🚀