Amazon S3

Owned by EazyDI Main Account
Last updated: Mar 31, 2024 by John Yanguas
2 min read

version: 1.0.0

Category: File System

Tier: 1

Type: Source, Target

Authentication:

  • Basic authentication. Enter the actual access key and secret key.

  • Temporary security credentials using assume role. Enter the secret access key and secret key of an IAM user with no permissions to access Amazon S3 bucket.

Files Supported:

  • Csv files

  • Excel Files

Supported Save Mode as Target:

  • Append

  • Overwrite

  • New

See: https://eazydi-doc.atlassian.net/wiki/spaces/EazyDIDOC/pages/3801164

Connection Properties

 

image-20240331-025658.png

 

 

Name

Mandatory

Description

Name

Mandatory

Description

Connection Name

Yes

Name of the connection

Description

No

Description of connection

Folder Path

Yes

  • format can be bucket name e.g. mybucket

  • or bucket name/folder1/folder2... e.g. mybucket/myfolder or mybucket/myfolder/mynestedfolder

Region Name (of the s3 bucket)

Yes

 

Access Key

Yes

 

Secret Key

Yes

 

IAM Role ARN

No

The IAM Role ARN for temporary credentials for credentials that has no direct access to s3 bucket but can assume a role

External Id

No

Indicates the External id used for the IAM Role ARN (If necessary)

 

Reading Objects

 

image-20240331-031206.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

For excel objects indicate and choose the sheet name from the drop down

 

 

For date string handling See https://eazydi-doc.atlassian.net/wiki/spaces/EazyDIDOC/pages/3538945