SFTP

1. In Polytomic, go to Connections → Add Connection → SFTP.

2. Polytomic supports authenticating to SFTP using either a password or a keypair:

3. Enter all credentials to your SFTP server as well as the server path to the directory containing your files.
4. Click Save.

Syncing from SFTP servers

Use Bulk Syncs to sync files from SFTP servers to your data warehouses, databases, and cloud storage buckets like S3.

Syncing to SFTP servers

Use Model Syncs to sync to SFTP servers from your data warehouses, databases, SaaS tools like Salesforce, and cloud storage buckets like S3.

Concatenating source files

If you would like the files in your SFTP directory concatenated into one table in your destination (e.g. one table in your data warehouse), you should check the Files are time-based snapshots box. This is typically desired if you're (for example) dealing with daily archives of financial transactions. All files share the same format but their data is split.

Once you check that box, you will be asked to enter a Collection name. This will be the name of the output table containing your concatenated data once you activate a sync: