ALL

Target database: Amazon Redshift, Azure Synapse SQL

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

See also:

• Entities

• Distribution styles (Amazon Redshift documentation)

• Design guidance for using replicated tables in Synapse SQL pool (Microsoft documentation)

Notes

Distribution style ALL can be used with tables in Amazon Redshift and Azure Synapse SQL.

Distribution style ALL can also be used with materialized views in Amazon Redshift.

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

Examples

Amazon Redshift distribution style ALL

Distribution style definition:

DISTRIBUTION STYLE: ALL

DDL generated by Agile Data Engine:

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

Azure Synapse SQL replicated table

Distribution style definition:

DISTRIBUTION STYLE: ALL

DDL generated by Agile Data Engine:

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