EVEN

Target database: Amazon Redshift, Azure Synapse SQL

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

See also:

• Entities

• Distribution styles (Amazon Redshift documentation)

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

Notes

Distribution style EVEN can be used with tables and materialized views in Amazon Redshift and Azure Synapse SQL.

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

Examples

Amazon Redshift distribution style EVEN

Distribution style definition:

DISTRIBUTION STYLE: EVEN

DDL generated by Agile Data Engine:

CREATE TABLE pub.F_TRIP (
  ...
) DISTSTYLE EVEN;

Azure Synapse SQL round-robin distribution

Distribution style definition:

DISTRIBUTION STYLE: EVEN

DDL generated by Agile Data Engine:

CREATE TABLE [pub].[F_TRIP] (
  ...
) WITH (DISTRIBUTION = ROUND_ROBIN);