Hi @PSAmmirata :
Could you please create a support ticket for this. You write with such great detail that you can copy and paste this text “as is”. I think there is an issue here with our snaps. Another customer is having a similar issue.
They are getting a similar auth error which is happening when executing the Redshift COPY sql which sources from S3. I suspect the CREDENTIALS clause (aws_iam_role=) and something with our AWS role plumbing.
It would be great to link your ticket to this ticket. A support ticket has a bit more visibility for you, and ensures more dev cycles too.
Maybe, your other community post hints at getting to the bottom of this issue. It has been answered, but we could supply more details too.
