KEY

Target database: Amazon Redshift, Azure Synapse SQL

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

See also:

• DISTRIBUTION_KEY

• Entities

• Distribution styles (Amazon Redshift documentation)

• Guidance for designing distributed tables using dedicated SQL pool in Azure Synapse Analytics (Microsoft documentation)

Notes

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.

Examples

See DISTRIBUTION_KEY for Amazon Redshift and Azure Synapse SQL examples.