Fields discovered automatically
Column names and types are inferred by sampling records in your CSV, JSON, and Parquet files.
Cloudflare R2
Polytomic connects Cloudflare R2 to your data warehouse, databases, and SaaS tools for ETL and reverse ETL. Read CSV, JSON, and Parquet files into your data warehouse, or write synced data back into R2, without writing code.
Many files, one table
Group files that share a folder pattern, such as daily exports, into a single table.
Full bidirectional ETL
Read objects from R2 into your warehouse, or write synced data back into R2.
Example workflows
Load CRM, billing, and product exports from R2 into your data warehouse
What you can sync
Move data between R2 and your data warehouse, databases, and SaaS tools, in both directions.
From Cloudflare R2
CSV, JSON, and Parquet files
Compressed files in gzip, zstd, and bzip2
Multiple files combined into one table by folder pattern
Fields and types discovered automatically from sampled records
File name, size, and last modified as extra columns
To Cloudflare R2
CSV, JSON lines, JSON array, or Parquet files
A single file replaced with the latest data
Timestamped snapshots of the complete dataset
Delta files containing only the records that changed
Any subfolder path you choose within the bucket
How it works
Connect an R2 bucket with an access key and Polytomic discovers each CSV, JSON, and Parquet file as an object it can read, inferring fields automatically. Write synced data back into the bucket in any of those formats.
A folder pattern groups files that belong together, such as daily exports, into a single table. When files are grouped this way, each sync compares the current bucket listing against the last run and skips reprocessing when nothing has changed.
- Automatically discover CSV, JSON, and Parquet files as tables
- Group files that share a folder pattern into one table
- Infer field names and types by sampling file records
- Read gzip, zstd, and bzip2 compressed files automatically
- Skip reprocessing grouped files when nothing has changed
- Write CSV, JSON, or Parquet files back into the bucket
How to set up
Cloudflare R2 connections authenticate with an R2 API access key rather than an OAuth flow. Create the key in Cloudflare, then enter it along with your account ID and bucket name in Polytomic.
How to get connected
- 1In Cloudflare, create an R2 API token and note its access key ID and secret access key
- 2In Polytomic, go to Connections, click Add connection, and select Cloudflare R2
- 3Enter the account ID, access key ID, secret access key, and bucket name, then click 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 Cloudflare R2 in minutes
No credit card required. Free trial available.