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:
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);