Support for Amazon Redshift

I have been playing around with Amazon Redshift. See my experiences at: http://redshiftuser.wordpress.com/ Redshift presents itself as Postgres, but has different underlying management tables (eg for table metadata). DbVis connects fine to Redshift and works well for queries. However, dbVis doesn't correctly populate the hierarchy tree. So, here's a Feature Request to add Redshift support to dbVis. Thanks!

Thank you! Actually, it seems that in the few months since I last used Redshift, things have become better. The hierarchy works correctly for Tables, so it seems that my request is now somewhat obsolete!

Hi John, I just installed the DBVis latest version, but can't view Schemas name and any objects within the Schema. Could you please share how you were able to get the object hierarchy working correctly? Thank you! Raymond

One issue with Redshift in DbVisualizer, namely that object name did not appear in the Databases tab, has been fixed in the just released DbVisualizer 9.1. To access Redshift in DbVisualizer you should select the Generic database type in the connection setup. An alternative is that you chose PostgreSQL, but note that not all features work with Redshift. Best Regards, Hans

Where/How should we report additional issues with RedShift? New tickets, this ticket? For instance: * extracting DDL for a table generates a "max_index_keys" error. * DbVis does extract SORTKEY & DISTKEY * DbVis does not extract column ENCODE * Max Rows doesn't seem to work

Hi Jason, I have recorded the issues you mentioned and added your vote for adding official support for Redshift. Best Regards, Hans

I'd like to vote for official full support of Redshift, too! Also, extracting DDL for a table still generates a "max_index_keys" error. As a workaround, I was able to generate basic DDL by configuring the connection's database type as Generic (instead of PostgreSQL)