Redshift DDL

As you develop the model for your Amazon Redshift  database schemas, tables, columns with their data types, as well as columns-level constraints, Hackolade dynamically generates the corresponding DDL scripts.

The script can also be exported to the file system via the menu Tools > Forward-Engineering, or via the Command-Line Interface.

A button lets the user apply to a selected instance the script to create schemas, tables and views.

If you store JSON within SUPER columns, Hackolade allows for the schema design of those documents.  However, the corresponding JSON structure is not forward-engineered in the DDL script, but is useful for developers, analysts and designers.