Can you specify the IAM Role ARN to use with the Text Output component?

Matillion ETL
1

I need to write some extracts to an S3 bucket in a different AWS account than my Redshift cluster. In order to do this, I need to chain an IAM role to the default role being used in Redshift. Is there any way to specify what IAM Role ARN to use in the Text Output component or do I need to do this using the S3 Unload component or a SQL Script component?

2

Hi @ZachB​

I appreciate this is an old post, I just wanted to check in to see if you were able to achieve this. If not let me know and we can pick this up and look into this for you.

Kind regards, Joe

3

Hi @JoeCommunityManager​ ,

I wasn't able to find a way to do it using the Text Output component, so I ended up just writing a python script that leveraged the AWS API.

Thanks,

Zach

4

Thanks for sharing that @ZachB​

If you need anything else, please do not hesitate to ask :)

Kind regards, Joe