How Can I Change Sort or Dist Keys Dynamically?

Question

How can I change the Redshift sort or dist keys using a single command or dynamically?

Environment

Redshift destination

Answer

Do the following:

1. Pause the connector.
2. Follow Redshift's instructions to change the sort keys or dist keys.
3. Unpause the connector.