Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Download data from S3 in another Account

Is it possible to download files from another companies s3 account using the aws key and secret?

4 Community Answers

Matillion Agent  

Ian Funnell —

Hi Kevin,

It certainly is, yes. Please see this document which explains how to set up the authorization, and the Matillion S3 Load component.

Best regards,
Ian


Kevin Leonard —

Hello,

We are not able to implement the steps in the link posted. All we have is an aws secret and key. The s3 bucket we need to access is owned by another organization who gave us an account that has access to 1 bucket.

Is there a way to access data in this scenario?


Kevin Leonard —

This step is not possible in our situation:

The S3-bucket-owning account grants S3 privileges to the “root” identity of the Matillion account. This minimises the coupling between the accounts.


Matillion Agent  

Ian Funnell —

Hi Kevin,

Understood, yes. There are also two other approaches that you can take.

  1. Set up a new Matillion Environment and instead of choosing “Instance Credentials” for the AWS credentials, follow the Manage link and set up a new “User Defined Credentials” using your Access Key ID and Secret Access Key. Use that new Environment to run your S3 Load.
  2. In the S3 Load component, set the IAM Role ARN to a role ARN that is attached to your Redshift cluster, and which has been given the necessary permissions to access S3

Best regards,
Ian

Post Your Community Answer

To add an answer please login