Skip to main content
Skip table of contents

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:

Target DBMS

Feature

Amazon Redshift

ALL distribution

Azure Synapse SQL

Replicated tables


See also:


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:

DEFINITION
DISTRIBUTION STYLE: ALL

DDL generated by Agile Data Engine:

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

Azure Synapse SQL replicated table

Distribution style definition:

DEFINITION
DISTRIBUTION STYLE: ALL

DDL generated by Agile Data Engine:

SQL
CREATE TABLE [pub].[F_TRIP] (
  ...
) WITH (DISTRIBUTION = REPLICATE);
JavaScript errors detected

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

If this problem persists, please contact our support.