search

dbeaver / dbeaver

Free universal database tool and SQL client
https://dbeaver.io
Apache License 2.0
40.62k stars 3.5k forks source link

AWS Redshift Spectrum external tables and Data share tables not being displayed in database tree objects #22293

Open suresh3004 opened 11 months ago

suresh3004 commented 11 months ago

Description

Hello Team,

We are connecting to AWS Redshift using Okta IDP and MFA authentication. We have used Redshift JDBC driver redshift-jdbc42-2.1.0.24.jar and using DBeaver version - Version 23.3.1.202312281614.

We have used following blog to Connecting DBeaver to AWS Redshift Using SAML Federation and MFA

https://bambooengineering.io/connecting-dbeaver-to-redshift-using-saml-federation-and-mfa/

We are able to establish connection to AWS Redshift Using Okta SAML Federation and MFA but unfortunately we are unable to view AWS Redshift Spectrum external tables and Data share tables in database tree objects. When we try to browse external schema it doesn't list any tables but we can able to run query against external tables.

DBeaver Version

23.3.1.202312281614

Operating System

macOS Monterey Version 12.3

Database and driver

  1. AWS Redshift
  2. JDB driver - redshift-jdbc42-2.1.0.24.jar

Steps to reproduce

https://bambooengineering.io/connecting-dbeaver-to-redshift-using-saml-federation-and-mfa/

Additional context

No response

LonwoLonwo commented 10 months ago

Hello @suresh3004

Could you please provide your connection settings tab screen? You can remove all sensitive data from it.

suresh3004 commented 10 months ago

Hi @LonwoLonwo Please find attached connection settings tab screen and let us know if you need additional details.

Redshift-Okta-MFA Cpnnection detials.docx

LonwoLonwo commented 10 months ago

So, I'm not sure, that you actually did the Copy operation for the Redshift driver. Because I can see the PostgreSQL logo on your screens, not the Redshift one. Could you please try again to create a new driver, but like a copy of the Redshift driver?

suresh3004 commented 10 months ago

@LonwoLonwo We did copy operation from Redshift driver. First time it will work as expected. we are able to browse external and data share tables from Data base tree view. The issue is when we we select AWS Redshift JDBC driver and click Find Class from driver manager then working connection profile will broken. Please find attached sequence of steps to reproduce the issue.

Redshift-Okta-MFA-issue.docx

LonwoLonwo commented 10 months ago

Did you try to avoid this step?

3) In Libraries tab select AWS Redshift Jar then click Find Class then click OK

Because you already have the class name on the Settings tab.

suresh3004 commented 10 months ago

@LonwoLonwo If we skip that step It will work.

LonwoLonwo commented 10 months ago

Ok. I left this ticket with a "minor" status because finding the class name was unnecessary. Thanks for the bug report.

skumarappa commented 1 month ago

@LonwoLonwo Any luck on fixing this issue? There are many of our DB users keep reporting this issue because their working connection broken by knowing or without knowing opening user defined driver name and click okay then connection it will getting broken. We would appreciate if we are able to get fix for this issue. Thanks!