CSV, JSON, and Parquet
Read delimited, JSON lines, and columnar files, including compressed ones.
Dropbox
Polytomic connects Dropbox to your data warehouse, databases, and SaaS tools for file based ETL. Read CSV, JSON, and Parquet files from a Dropbox folder and load them into your data warehouse and other systems on a schedule, without writing code.
Glob and capture patterns
Match files by pattern and turn parts of the path into columns.
Many files, one table
Combine a folder of files into a single table in your data warehouse.
Example workflows
Load Dropbox CSV and Parquet files into your data warehouse
What you can sync
Dropbox is supported as a source. Read files from a folder and land them in your data warehouse, databases, or SaaS tools.
From Dropbox
CSV files with configurable headers and skipped lines
JSON arrays and JSON lines files
Parquet files using their embedded schema
Gzip, zstd, and bzip2 compressed CSV and JSON
Glob patterns with path values captured as columns
To your destinations
Data warehouses including Snowflake, BigQuery, and Databricks
Databases including PostgreSQL and MySQL
Cloud storage including Amazon S3 and Google Cloud Storage
SaaS tools including Salesforce, HubSpot, and spreadsheets
How it works
Connect Dropbox with OAuth and point Polytomic at a folder. It lists the folder recursively, treats files as tables, and loads them into your data warehouse, databases, or SaaS tools on a schedule, which turns a shared folder into a real data source.
Patterns are what make this practical for recurring drops. You can match files with a glob, combine many files into one table, and capture values out of the file path itself so a dated folder becomes a column rather than information you lose on load.
- Connect Dropbox with OAuth and select a folder
- List files recursively and expose them as tables
- Match files with glob and capture patterns
- Infer schema from CSV headers, sampled JSON, or the Parquet schema
- Combine a set of matching files into a single table
- Monitor sync health, record volume, and failures from one interface
How to set up
Polytomic connects to Dropbox using OAuth with offline refresh, so the connection stays alive without reauthorizing. It reads content within the authorizing user's namespace, so authorize with an account that can see the folders you want to sync.
How to get connected
- 1In Polytomic, navigate to Connections, then Add Connection, then Dropbox
- 2Click Connect to Dropbox and authorize the account
- 3Enter the folder path holding your files
- 4Add a glob or capture pattern if you want to match a set of files
- 5Confirm the inferred schema
- 6Click Save
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 Dropbox in minutes
No credit card required. Free trial available.