Question

How to change the Redshift Sort/Dist Keys via a single command / dynamically. 

Environment

Destination: Redshift

Answer

1. Pause the connector
2. Follow Redshift instructions to change the Sort keys or Dist keys. 
3. Unpause the connector

Cause

You do not want to follow the long process as outlined in our Redshift documentation.