Skip to main content
Archived

Option to create Redshift SORT and DISTRIBUTION Keys on Table Creation

Related products:Integrations
  • September 17, 2018
  • 0 replies
  • 11 views
M
Forum|alt.badge.img

Redshift is a powerful columnar-based Data Warehouse but requires some tuning out of the gate to enable its full potential. One of the most important components is the selection of the Sort and Distribution keys.

Currently, the Redshift writer allows for table creation (IF NOT EXISTS) but does not expand upon the traditional SQL statement for the creation of Sort and Distribution Keys.

Requesting an extra option on the REDSHIFT WRITER to allow for the selection of Sort and Distribution keys if the writer is creating the table.

Redshift Sort Keys:

https://docs.aws.amazon.com/redshift/latest/dg/c_best-practices-sort-key.html

Redshift Dist Keys:

https://docs.aws.amazon.com/redshift/latest/dg/c_best-practices-best-dist-key.html

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

Community Stats

32,711
Posts
124,125
Replies
41,197
Members
Terms & ConditionsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.