If so, is there a patch? I need to select a tool for our new data warehouse, and I can't get PowerDesigner over the line without Reverse Engineer capability. PowerDesigner models Redshift schemas as users with a stereotype of <.

Technical Lead, IFRS17, Actuarial Stream (Consultant) at Sun Life. Is this a known bug/limitation with Redshift reverse engineer? Hands-on Solutions Designer, AWS Cloud, Big Data, Data Engineering, Data Science and Data Analytics. Go to the Preview tab and inspect the CREATE TABLE statement - It does not include the Distribution or Sort settings. Open a table and go to the Extended Attributes tab - None of the Redshift attributes are imported Select my tables from the Database Reverse Engineering list of database tables Provide ODBC credentials to my Redshift database These attributes are all enterable in PowerDesigner under the generic 'Extended Attributes' tab, and while they seem to forward engineer okay (the CREATE TABLE SQL includes any values you set), the Reverse Engineer won't pull them from the database. It gets the table and column information, but misses the Distribution Style/Key, and the Sort style/key.

SAP PowerDesigner seems to support Redshift, but the Reverse Engineering option is not importing some table options. Amazon Web Services (AWS) RedShift Database (via JDBC) - Import. I'm looking for a data modelling tool that supports forward and reverse engineering of database tables for Amazon Redshift. Bridge Specifications Vendor SAP Tool Name PowerDesigner CDM (Conceptual Data Modeling). First post / new member - apologies if I'm doing this wrong.

Powerdesigner redshift