3229329 - Physical options of Redshift tables are not reversed when using a data source - SAP PD

• Reversing using a live connection to an Amazon Redshift database, table options are missing, i.e. the distribution style and columns, the sort style and columns, etc.
• Table attributes are not reversed:
    [ DISTSTYLE { AUTO | EVEN | KEY | ALL } ] 
    [ DISTKEY ( column_name ) ]
    [ [COMPOUND | INTERLEAVED ] SORTKEY ( column_name [,...]) |  [ SORTKEY AUTO ] ]
    [ ENCODE AUTO ]
• No problem when using script files.

• SAP PowerDesigner (PD) 16.7
• Amazon Redshift

re, keys, BACKUP, NULL, CR#826930, CR826930, 826930 , KBA , BC-SYB-PD , PowerDesigner , Known Error