Send data to SFTP¶
Note
This topic contains information about configuring a destination that sends query results to SFTP using orchestrations. To configure a destination that sends audiences to SFTP using campaigns see this topic .
Secure File Transfer Protocol (SFTP) is a network protocol that provides file access, file transfer, and file management over any reliable data stream.
Amperity can be configured to send Apache Parquet, CSV, JSON, NDJSON, PSV, or TSV files to any SFTP site.
Get details¶
Review the following details before configuring credentials for SFTP and before configuring Amperity to send Apache Parquet, CSV, JSON, NDJSON, PSV, or TSV files to any SFTP site.
![]() |
Credential settings Choose “passphrase” or “private-key” as the credential type, and then configure a combination of hostname, username and passphrase, host public key, port number, and private key settings as required by the credential type. |
![]() |
Required configuration settings
Note All other Amperity file format settings for SFTP are optional. |
Included SFTP site¶
Every Amperity tenant includes an SFTP site with a hostname of <tenant>.sftp.amperity.com
. For example, if your company name is ACME, then your tenant’s SFTP hostname is acme.sftp.amperity.com
. (The hostname is always all lowercase.)
Note
The SFTP site is provisioned by an Amperity administrator after the initial tenant creation. As such, the SFTP site is not immediately available, but this is not a long process. When the SFTP site is ready, Amperity will use SnapPass to send you the connection details. If you wish to use RSA key-based authentication, please provide the public key to your Amperity administrator when requesting SFTP access.
Once this site is provisioned, you may configure the SFTP site as an SFTP source or an SFTP destination to support any desired workflow. External customer processes can be configured to connect to the site using SFTP, after which they can add data to or pick up data from the site to support any external workflow.
Caution
The SFTP server has a 30-day limit on data and after 30 days, data may be moved automatically to an archive location. This location is still accessible to Amperity in case it becomes necessary to reuse it.
Important
The hostname for the SFTP site is always <tenant-name>.sftp.amperity.com
. Some older tenants may still be using the legacy address sftp.amperity.com
, if so, please contact your Amperity administrator about migrating.
Configure credentials¶
Configure credentials for SFTP before adding a destination.
An individual with access to SFTP should use SnapPass to securely share credential details with the individual who will configure Amperity.
To configure credentials for SFTP
![]() |
From the Settings page, select the Credentials tab, and then click the Add credential button. |
![]() |
In the Credentials settings dialog box, do the following: From the Plugin dropdown, select SFTP. Assign the credential a name and description that ensures other users of Amperity can recognize when to use this destination. From the Credential type dropdown, select “passphrase” or “private-key”. |
![]() |
The settings that are available for a credential are determined by the credential type and by the settings that are required by the SFTP site. The following credential settings are available for SFTP sites. Configure the settings that are required by the SFTP site to which Amperity will connect, and then click Save. Host public key
Passphrase
Port
Private key
Username
|
Add destination¶
Use a sandbox to configure a destination for SFTP. Before promoting your changes, send a test audience, and then verify the the results in SFTP. After the end-to-end workflow has been verified, push the destination from the sandbox to production.
To add a destination for SFTP
![]() |
Open the Destinations page, and then click the Add destination button. ![]() To configure a destination for SFTP, do one of the following:
|
![]() |
Select the credential for SFTP from the Credential dropdown, and then click Continue. Tip Click the “Test connection” link on the “Configure destination” page to verify that Amperity can connect to SFTP. |
![]() |
In the “Destination settings” dialog box, assign the destination a name and description that ensures other users of Amperity can recognize when to use this destination. Configure business user access By default a destination is available to all users who have permission to view personally identifiable information (PII). Enable the Admin only checkbox to restrict access to only users assigned to the Datagrid Operator and Datagrid Administrator policies. Enable the PII setting checkbox to allow users with limited access to PII access to this destination. Restricted PII access is enabled when the Restrict PII access policy option that prevents users who are assigned to that option from viewing data that is marked as PII anywhere in Amperity and from sending that data to any downstream workflow. |
![]() |
Configure the following settings, and then click “Save”. Compression
Escape character
File format
Filename template
Header
Line ending
PGP public key
Quote mode
Remote folder
Success file
Use Zip64?
Row Number
|
![]() |
After this destination is configured:
|
Workflow actions¶
A workflow will occasionally show an error that describes what prevented a workflow from completing successfully. These first appear as alerts in the notifications pane. The alert describes the error, and then links to the Workflows tab.
Open the Workflows page to review a list of workflow actions, choose an action to resolve the workflow error, and then follow the steps that are shown.
![]() |
You may receive a notifications error for a configured SFTP destination. This appears as an alert in the notifications pane on the Destinations tab. ![]() If you receive a notification error, review the details, and then click the View Workflow link to open this notification error in the Workflows page. |
![]() |
On the Workflows page, review the individual steps to determine which step(s) have errors that require your attention, and then click Show Resolutions to review the list of workflow actions that were generated for this error. ![]() |
![]() |
A list of individual workflow actions are shown. Review the list to identify which action you should take. ![]() Some workflow actions are common across workflows and will often be available, such as retrying a specific task within a workflow or restarting a workflow. These types of actions can often resolve an error. In certain cases, actions are specific and are shown when certain conditions exist in your tenant. These types of actions typically must be resolved and may require steps that must be done upstream or downstream from your Amperity workflow. Amperity provides a series of workflow actions that can help resolve specific issues that may arise with SFTP, including: |
![]() |
Select a workflow action from the list of actions, and then review the steps for resolving that error. ![]() After you have completed the steps in the workflow action, click Continue to rerun the workflow. |
Invalid credentials¶
The credentials that are defined in Amperity are invalid.
To resolve this error, verify that the credentials required by this workflow are valid.
Open the Credentials page.
Review the details for the credentials used with this workflow. Update the credentials for SFTP if required.
Return to the workflow action, and then click Resolve to retry this workflow.