AWS S3
Amazon Simple Storage Service (Amazon S3) is a cloud object storage service with industry-leading scalability, data availability, security, and performance.
Features
Feature name | Supported | |
---|---|---|
Column Hashing | True | Column level |
Blocking | True | Column level |
Incremental | True | Merge, Append |
Custom data | True | |
History | False | |
ReSync | True | Table level |
Templates | False |
Supported file types
- JSON Newline
- CSV
- Parquet
Configuration options
We support many different configuration options for loading your data. If we do not support a configuration needed for your specific use case, please reach out to hello@weld.app.
π§ Setup Guide
Prerequisites
An AWS S3 bucket containing files with supported file types and encodings.
Step 1 - Create an IAM Policy for Weld
- Open your AWS IAM console.
- Go to Policies and then select Create Policy
- Go to the JSON tab
- Copy the following policy and paste it in the JSON tab, replacing
{BUCKET_NAME}
with the name of your S3 bucket.
{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": [
"s3:GetObjectAcl",
"s3:GetObject",
"s3:ListBucket",
"s3:GetObjectVersion"
],
"Resource": [
"arn:aws:s3:::{BUCKET_NAME}",
"arn:aws:s3:::{BUCKET_NAME}/*"
],
"Condition": {
"ForAnyValue:IpAddress": {
"aws:SourceIp": ["35.156.133.78", "3.65.119.169", "3.64.84.139"]
}
}
}
]
}
- Click Next: Tags
- Click Next: Review
- Name the policy
Weld-S3-Access
- Click Create Policy
Step 2 - Create a User for Weld
- Go to Users and then select Add users.
- Name the user
Weld-S3
- Select Access key - Programmatic access as the AWS credential type
- Click Next: Permissions
- Click Attach existing policies directly and select the
Weld-S3-Access
policy - Click Next: Tags
- Click Next: Review
- Click Create user
- Note the Access Key ID and Secret Access Key for next step.
Step 3 - Authenticate Weld
- Input the Access Key ID from previous step in the Weld App
- Input Secret Access Key from previous step in the Weld App
- Input the bucket name
- Select the region the bucket is located in.
- Click Connect
The configuration will be finalized and you will be able to start loading data from your AWS S3 bucket.