Amazon S3 ETL
Configure daily automated exports of transactional data to Amazon S3 storage
Connect Apphud's Daily Data Exports to your own Amazon S3 bucket — receive a gzip-compressed .csv snapshot of all transaction data delivered automatically once a day, ready for your data warehouse or analytics pipeline.
How to Add Integration?
Step 1 - Preparations in AWS
Sign in to your Amazon Console and navigate to Identity and Access Management (IAM).
Create the IAM policy
Open Policies and click Create Policy.
Copy the JSON below into the JSON tab of the policy permissions and replace apphud-test-export with your custom bucket name:
{
"Version": "2012-10-17",
"Statement": [
{
"Sid": "ListObjectsInBucket",
"Effect": "Allow",
"Action": [
"s3:ListBucket"
],
"Resource": [
"arn:aws:s3:::apphud-test-export"
]
},
{
"Sid": "AllObjectActions",
"Effect": "Allow",
"Action": "s3:*Object",
"Resource": [
"arn:aws:s3:::apphud-test-export/*"
]
}
]
}The resulting policy permissions should look like this:
Create an IAM user and attach the policy
Open Users and click Add Users.
Enter a user name (for example, Apphud) and select Programmatic access type:
Create a group with the policy you just created and add your user to that group:
After creating the user, download the .csv credentials or copy the Access Key ID and Secret Key:
Step 2 - Authentication
In Apphud, open Connections → Integrations (the All or ETL tab). Find Amazon S3 ETL and click Add Connection.
Choose a Source and enter connection Name.
Fill in all fields with data and credentials obtained in Step 1 — Bucket name and Access Key ID:
Step 3 - Additional Configuration
Send only new or updated events
You can receive only new and updated transactions since the last export instead of the full dataset. The default value is ON, which is the recommended value.
Step 4 - Enable and save
Enable integration and click Save. Once enabled, allow up to 24 hours for the first delivery to appear in your S3 bucket.
What gets exported
See Daily Data Exports → Data Format for the full list of CSV columns. Files are delivered as gzip-compressed .csv once per day. Attribution data is not part of the export.
Updated about 2 months ago
