INTERLEAVED_SORT_KEY

Target database: Amazon Redshift

Defining INTERLEAVED_SORT_KEY for an entity creates an INTERLEAVED SORTKEY in Redshift.

See also:

• SORT_KEY

• Working with sort keys (Amazon Redshift documentation)

Usage

Pick one or several attributes to form the key and give a name to the key.

Notes

INTERLEAVED_SORT_KEY can be used with tables and materialized views in Amazon Redshift.

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

Examples

Amazon Redshift INTERLEAVED SORTKEY

Key definition:

KEY NAME: INT_SORTKEY_F_TRIP
KEY TYPE: INTERLEAVED_SORT_KEY
ATTRIBUTE 1: vendorid

DDL generated by Agile Data Engine:

CREATE TABLE pub.F_TRIP (
  ...
) INTERLEAVED SORTKEY (vendorid);