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