Hi, how to rotate s3 credentials when using an external catalog without being disruptive on the views and mat views created pointing to tables in the external catalog?

The S3 rotation is not support. You can use the instance profile instead.