Skip to main content
Skip table of contents


Target database: Amazon Redshift, Azure Synapse SQL

Defining distribution style KEY for an entity uses different features depending on the target database management system:

Target DMBS


Amazon Redshift

KEY distribution

Azure Synapse SQL

Hash distribution

See also:


Distribution style KEY can be used with tables and materialized views in Redshift and Synapse SQL.

Check Export SQL/Entity SQL after defining a distribution style to see generated DDL.


See DISTRIBUTION_KEY for Amazon Redshift and Azure Synapse SQL examples.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.