The file name 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 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.
You can also set a File Name Timestamp Offset. By default, the date/time used to generate the file name (above) is the date/time that the
sync takes place; you can enter a number of seconds to offset this (offset can be positive or negative).
Ex. To set the date in the file name to 24 hours before the sync takes place, input -86400. The default offset is 0.
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 Customer ID, Email,
Name, and Price. These fields are mapped to new fields in the CSV as
customer_id, email, and name, and price, respectively. All other columns from
your results are ignored.
If a file at that path already exists at the time of a sync, Hightouch will
overwrite it. To keep different versions of the same results file, you can
enable versioning in your bucket, or your application can copy the data to
another location.
This destination will not respect any sorting that you have in your model. It
will export results file sorted by ID.
Ready to get started?
Jump right in or a book a demo. Your first destination is always free.