Table of Contents
Amazon Simple Storage Service (Amazon S3) is storage for the Internet. It's highly scalable, reliable, fast, and inexpensive.Overview
This destination allows you to pull results from your model and write a CSV file to an S3 bucket.Initial Setup
To get started, you will need an S3 bucket and the key ID and secret key for an IAM user. The "Bucket Name" should just be the name of the bucket, not a URL. The IAM user needs to have programmatic access enabled and permission to write to the S3 path you want to use.
Supported Authentication Methods
Currently, we support authentication with a programmatic access key for an IAM user.Syncing to S3 Bucket
This destination ignores the concept of additions, changes, removals and will send the full results of your model. For example, if your model has 1,000 records, your CSV results file will be 1,000 records.File Name
The object key field will allow you to specify the prefix and the name of the file that you want to use for your results. In the screenshot below, we've specified that we want the file to be called results.csv, with a custom prefix.
You can also timestamp variables in the file name, surrounding each with {}.
We currently support these timestamp variables: YYYY, MM, DD, HH, mm. All dates and times will be UTC.For example: upload/{YYYY}-{MM}-{DD}-{HH}-{mm}-result.csv.Columns to Sync
For this destination, we give you the ability to export all columns as they are represented in your model.
If you need remap the fields that you're exporting, maybe because you don't want
to alter your model, you can manually map fields. Only the fields that you map
will be exported in this instance. In this example, we're exporting id, email,
name, and eventtype. These fields are mapped to new fields in the CSV as
user_id, email, and username, and event, respectively. All other columns from
your results are ignored.
CSV Header
We provide you the option to include a CSV header with your exported results.