Hello All --
I am working with Redshift and hoping to use SDDM to do data modeling. One small caveat. There doesn't seem to be an option to extract DDL using Redshift like there is for Oracle, SQL Server, etc. E.g. the drop-down window under File -> Data Modeler -> Export -> DDL File doesn't give a Redshift option.
Thus far I've created the model in SDDM, exported to Oracle DDL, and then done manual edits post ipso facto before running the scripts in Redshift but this is far from ideal.
I have added Redshift as a third-party JDBC driver under the Data Modeler preferences but this hasn't changed anything as far as I can see.
I realize that supporting another platform for data modeling requires a lot more than just adding a JDBC driver but is there anyway I could make this easier? Even just somehow mapping logical types to relational for Redshift?
Thank you,
Josh