Skip to content

RedShift Specific Notes

Jump to bottom
Tim Kirschke edited this page Mar 20, 2024 · 1 revision

How and when to use the Distkey in RedShift

The effective utilization of Distkey in AWS Redshift significantly impacts query performance by optimizing table organization. Tables containing fewer than 10,000 records benefit from the 'DISTSTYLE ALL' command for distribution. For tables exceeding 10,000 records, employing the 'DISTSTYLE KEY' command enhances organization. When designating the Distkey for a Hub and Satellite, prioritize the Hash Key. For Link Distkeys, select the Hash Key of the referenced Hub with the highest cardinality for optimal performance (dbt documentation on how to implement)

Avoid unnecessary satellite splits

To counter AWS Redshift's poor join performance, it's advisable to minimize unnecessary satellite splits. By doing so, the number of required joins decreases, directly enhancing the overall performance of the data vault

Table of Content

  1. Staging
    1. Prejoining
    2. Derived Columns
    3. Add new columns to Hashdiff
  2. DV-Entities
    1. Hubs
      1. Standard Hub
    2. Links
      1. Standard Link
      2. Non-Historized Link
      3. Dependent Child Keys
    3. Satellites
      1. Standard Satellite
        1. Standard Satellite v0
        2. Standard Satellite v1
      2. Multi-Active Satellite
        1. Multi-Active Satellite v0
        2. Multi-Active Satellite v1
      3. Record-Tracking Satellite
      4. Non-Historized Satellite
    4. Reference Data
      1. Reference Hub
      2. Reference Satellite
        1. Reference Satellite v0
        2. Reference Satellite v1
      3. Reference Tables
    5. Business Vault
      1. PIT
        1. Hook Cleanup PITs
      2. Snapshot Control
        1. Snapshot Control v0
        2. Snapshot Control v1
  3. General
    1. Global Variables
    2. Multi-Source Entites
    3. How To Track Effectivity
    4. The rsrc_static Attribute
    5. Adaper Specific Notes
      1. RedShift
      2. PostgeSQL
      3. Exasol
      4. Synapse
  4. Releases
Clone this wiki locally