We have a corporate policy to update our AWS credentials periodically. As such we need to modify the credentials on our memsql S3 ingestion pipelines.
I looked at the ALTER PIPELINE docs here:
It doesn’t appear that I can alter the CREDENTIALS field.
I have tried various ALTER statements with no success.
Is my only option to do a SHOW CREATE PIPELINE … EXTENDED, then STOP the pipeline. Then DESTROY the pipeline, then CREATE the pipeline using the output of SHOW CREATE… plus the modified AWS key?