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 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.
For this destination, we give you the ability to export all columns as they are
represented in your model.
If you need to 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 company, email,
name, and primaryKey. These fields are mapped to new fields in the CSV, and 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 view different versions of the same file, you can right-click on the
file in Dropbox. Click Activity and then Version history.
This destination will not respect any sorting that you have in your model. It
will export results file sorted by ID.
Need help?
Our team is relentlessly focused on your success. We're ready to jump on a call to help unblock you.
Connection issues with your data warehouse?
Confusing API responses from destination systems?
Unsupported destination objects or modes?
Help with complex SQL queries?
or
Feature Requests?
If you see something that's missing from our app, let us know and we'll work with you to build it!
We want to hear your suggestions for new sources, destinations, and other features that would help you activate your data.