Question
How to change the Redshift Sort/Dist Keys via a single command / dynamically.
Environment
Destination: Redshift
Answer
- Pause the connector
- Follow Redshift instructions to change the Sort keys or Dist keys.
- Unpause the connector
Cause
You do not want to follow the long process as outlined in our Redshift documentation.