Amazon Redshift Data Modeling with SqlDBM

Amazon Redshift data modelling with SqlDBM

At SqlDBM, one of our core beliefs that we really strive to infuse into everything we do, is to truly listen to our users’ requests and feedback. A significant percentage of our users expressed that they would want the ability to design Redshift databases using SqlDBM. We listened and actualized that.

After almost two years on the market, SqlDBM is proud to announce that it is releasing Amazon Redshift Data Modeling support. Now the users of Redshift will be able to seamlessly create data models in SqlDBM and then generate Redshift DDLs – all this can be done online and in collaboration with other team members.  And of course, you can take advantage of and adapt SqlDBM features into your Redshift projects such as Dark/Light Theme, Subject Areas, Relationships, Diagrams, View Modes, Revision history etc.

Redshift Support in SqlDBM has plenty of great features, and some of the important ones are listed below:

Support for most popular menu options

  • Undo/Redo and Zoom
  • Subject Areas and Diagrams
  • Add New Table, Relationship, Note
  • Change View Mode: Table Names Only, All Columns , Only PK/FK Columns etc.


Support for access to “Backup” table option and “Compression Encoding” Column option 

  • User has the ability to turn on or off table backup, which allows whether the table should be included in automated and manual cluster snapshots.
  • Also user can set Compression Encoding to specify the type of compression that is applied to a column of data values as rows are added to a table.


Generate Redshift DDLs / Forward Engineer support

User can design Redshift database and easily materialize their beautiful designs into valuable SQL script. Forward Engineer feature has various options:

– Use Safe Scripts, to create table/schema only if it does not exists

– Create / Drop Schema

– Create / Drop Table

Please check out Redshift with SqlDBM at, let us know how we can improve SqlDBM to resolve your current issues related to Redshift database  designing/modeling. Help us get the next update to SqlDBM in the best possible shape. Your feedback is important to securing a solid update release, and we greatly appreciate your assistance.