Export your data models and segments

Sync your model profiles and attributes into a SFTP server to enable personalization and rapid data retrieval in your apps and websites.

Overview

This destination service allows DinMo to insert new files or update existing ones in a SFTP server, based on your DinMo models or segments.

To use this service, follow these three steps:

1. Create a SFTP destination. Follow our step-by-step guide to establish this connection.

2. Create your DinMo model or segment representing the data you want to send to your SFTP server.

3. Activate your model or segment with the SFTP destination to start synchronization.

Every time the activation runs:

• If the file does not yet exist: DinMo will create it with all the rows in the query results

• If the file already exists: DinMo will overwrite it, with only the lines added since the last sync.

If you don't want to overwrite existing files, we recommend using the timestamp in your file names.

Activation Setup

Once the SFTP destination is configured, create an activation to begin syncing your data. To do so, go to the Activations tab and click on "New activation". You will be asked to choose the model or segment you want to send to your SFTP server and select your SFTP destination you've just created

Then, you can configure your activation:

• Indicate the folder where you wish to store your file. By default, the file will be sent to the home folder of the SFTP server.

The user needs to have access to the target directory and file with write privileges. A permission denied error message during a sync indicates the user may not have write permissions for both the directory or the file.

• Indicate the name you wish to give to your file.

If you don't want to override existing files, we recommend including timestamp variables in the filename. To do so, you just need to surround each variable with {}. DinMo supports these timestamp variables:

• {YYYY}: Full year (e.g., 2025)

• {YY}: Last two digits of the year (e.g., 25)

• {MM}: Month (01-12)

• {DD}: Day of the month (01-31)

• {HH}: Hour (00-23)

• {mm}: Minute (00-59)

• {ss}: Second (00-59)

• {ms}: Millisecond (000-999)

• {X}: Unix timestamp in seconds

• {x}: Unix timestamp in milliseconds

For example: {YY}-{MM}-{DD}_export will be 25-04-14_export.csv for the upload of April 14th 2025.

• Select file format. DinMo supports CSV, JSON (and new delimited JSON), XML and Apache Parquet.he preceding example shows how to selectively export the id, email and location. These columns are mapped to new fields in the destination file as user_id, user_email and user_location. Hightouch exports these fields to the new fields in the file and ignores all other columns from your results

  • For the CSV option, you'll be asked to choose the CSV delimiter and if you want to include the CSV headers.

• Map all the DinMo attributes that you want to include in your file. You can of course rename any column you're syncing but choosing your "custom attribute name".

The example above shows how to export the age, name, phone_number and boolean is_active. These columns are mapped to new fields in the destination file as age, last name , phone and is_active. DinMo exports these fields to the new fields in the file and ignores all other columns from your model/segment.

Scheduling

Define how frequently your data is sent in your SFTP server. With each scheduled update:

• DinMo will perform a delta operation, inserting the rows that were added since the last sync.