CODEWITHSUNDEEP
oracle-sqldeveloperamazon-redshift
Michael Black
Michael Black

Reputation: 689

Oracle SQL Developer + AWS Redshift : Can only view tables

I've gotten SQL Developer to be able to connect to my RedShift cluster but I can only see the tables. I can't see any of the views? Does anyone know if that's possible or if I should just be considering a different tool to work with Redshift?

If I use other tools (i.e. Aginity) I can see the views so I know it's not a DB permission thing, it must be a JDBC+SQL-Develop thing.

What tool do you use for RedShift?

Upvotes: 0

Views: 539

Answers (1)

thatjeffsmith
thatjeffsmith

Reputation: 22447

Our redshift support is presented for a singular use case: copying/moving your data to the Oracle Autonomous Data Warehouse (ADW)

enter image description here

Can you connect and browse to a redshift instance? Yes. But that's not the desired use case.

Upvotes: 2

Related Questions