CSV with compression
Read plain CSV or gzip, zstd, and bzip2 compressed files.
SFTP
Polytomic connects SFTP to your data warehouse, databases, and SaaS tools for file based ETL. Read CSV files from an SFTP directory and load them into your data warehouse and other systems on a schedule, so recurring file drops become a real data source, without writing code.
Many files, one table
Combine a directory of files into a single table in your data warehouse.
Built for legacy handoffs
Bring partner and vendor file drops into your data warehouse automatically.
Example workflows
Load SFTP CSV files into your data warehouse and other systems
What you can sync
SFTP is supported as a source. Read CSV files from a directory and land them in your data warehouse, databases, or SaaS tools.
From SFTP
CSV files with a header row
Configurable skipped preamble lines before the header
Gzip, zstd, and bzip2 compressed CSV
Multiple files combined into a single table
A configured directory of files
How it works
Point Polytomic at a directory on your SFTP server and it lists the CSV files there, infers a schema, and loads them into your data warehouse, databases, or SaaS tools on a schedule. Plenty of important data still moves as a nightly file drop, and this turns that handoff into a pipeline nobody has to babysit.
Files in a directory can be treated as one table, which is the usual shape for a recurring export where each file covers a day or a batch. Polytomic tracks the file listing between runs and re-reads the collection when it changes.
- Connect with a host, port, username, and password or SSH key
- Point the connection at a directory of CSV files
- Infer the schema from the header row and a sample of rows
- Combine the directory's files into a single table
- Detect added, removed, and renamed files between runs
- Monitor sync health, record volume, and failures from one interface
How to set up
Polytomic connects to your SFTP server with a configurable host, port, and username, authenticating with either a password or an SSH private key. Point the connection at the directory holding your files and Polytomic reads the CSV files it finds there.
How to get connected
- 1Ensure your SFTP server is reachable and holds CSV files in one directory
- 2In Polytomic, navigate to Connections, then Add Connection, then SFTP
- 3Enter the host, port, and username
- 4Provide a password or paste an unencrypted SSH private key
- 5Enter the directory path containing your files
- 6Test the connection and click Save
See the documentation for full setup details.
Frequently asked questions
Why teams choose Polytomic
No engineering required
Set up and manage syncs without writing code.
Flexible data modeling
Use SQL to define exactly what data gets synced.
Handles scale automatically
Supports large datasets with incremental syncs and bulk APIs.
Start syncing your data with SFTP in minutes
No credit card required. Free trial available.