Data connector for AWS S3
The data connector for S3 enables you to directly import a dataset from an AWS S3 bucket.
It can be used to import delimiter separated value files to InfoSum Platform, such as data exported from AWS Redshift.
Before starting, you will need the following information to hand:
- Access key ID
- Access key secret
- File name
To configure a connection, log in to the Platform if you haven't already and either create a dataset or access the Bunker of an existing dataset. Once you're in the Bunker, select Import a dataset or use the Import tab, and locate the S3 connector.
Click Connect and enter your credentials as shown below.
The above form contains the following fields:
- Access Key ID: Customer needs to authenticate using their AWS credentials
- Access Secret Key: Customer needs to authenticate using their AWS credentials
- Bucket Name: Specify the bucket name (no leading s3 identifier, e.g. "bucket-name" not "s3://bucket-name")
- Prefix: Optionally add extra path in this box [SubFolder/NextFolder/]
When you have completed all required fields, click Connect.
Next, copy the file name into the Key box and select Download, then Connect. A subset of the data will then appear as a preview. You can perform some minor manipulations at this point, such as selecting which columns to import, renaming columns and excluding rows.
When you're happy with the preview, accept the settings and select a blank import configuration, then you'll be taken to the Import Wizard. This will show how our Platform has understood your dataset and mapped columns into our Global Schema.
If this looks correct, accept the Wizard Settings, otherwise untick the boxes so they can be correctly mapped during the later normalisation phase.