Set up an SFTP data destination to export data from Singular automatically to an SFTP Server.
Note: Data destinations are an enterprise feature (learn more).
Setup Instructions
To add an SFTP data destination in Singular:
- In your Singular account, go to Settings > Data Destinations and click Add a new destination.
- Type in either "SFTP Destination" (to export aggregated marketing data) or "SFTP User-Level Destination" (to export user-level data).
- In the window that opens, fill in the bucket name you created:
- Fill in the Username, Password, Hostname, and Port Number.
- Select the output format - "CSV" or "Parquet".
- Choose the output path in your SFTP, e.g., "singular_marketing_data/{date}{extension}".
- The schema of the data loaded into the destination. For your schema options, see Data Destinations: Aggregated Marketing Data Schemas and Data Destinations: User-Level Data Schemas.
Note that Singular supports several placeholders (macros) that will get expanded automatically:
| Placeholder | Description | Example |
| {date} | Date of the data being exported from Singular | 2020-03-19 |
| {day} | The day part of the data being exported from Singular (zero-padded) | 19 |
| {month} | The month part of the data being exported from Singular | 03 |
| {year} | The year part of the data being exported from Singular | 2020 |
| {extension} | Output file extension | .csv or .parquet |
| {job_timestamp} | The exact time the ETL job started running. Use this if you would like to have a new file every day (for example, have a new folder for each run with all the dates that were pulled in that job) |
2020-03-20 12:13:14 |
| {job_date} |
The date the ETL job started running. Similar to {job_timestamp}, but contains only the date of the job rather than the full timestamp. |
2020-03-20 |