R2
Ingest Parquet, CSV, and JSON files from Cloudflare R2 storage.
The R2 connector ingests files from Cloudflare R2 object storage.
Supported file formats
The R2 connector reads these formats from a bucket:
| Format | Extensions |
|---|---|
| Parquet | .parquet, .parq |
| CSV | .csv |
| TSV | .tsv |
| JSON | .json |
| JSON Lines | .jsonl, .ndjson |
Each format takes the same options described under file formats. Excel files are not supported over R2; use file upload for Excel.
Create a secret
The R2 connector needs an R2 secret. Create one with connector type R2 and these fields:
| Field | Required | Description |
|---|---|---|
account_id | Yes | Your Cloudflare account ID. |
bucket_name | Yes | The R2 bucket to read from. |
access_key_id | Yes | R2 access key ID. |
secret_access_key | Yes | R2 secret access key. |
Generate the access key pair from your Cloudflare R2 dashboard. The credentials are encrypted and reused for every ingestion and refresh from this bucket.
Ingest a table
Choose the R2 connector
In the Ingestion area, pick R2 and select the R2 secret you created.
Point at the data
Give the path to the file or files in the bucket. Gaur reads the format from the path; set format options such as a CSV delimiter if needed.
Name the table and ingest
Name the resulting table. Gaur runs the ingestion as a background job, infers the schema, and creates the table.
Refreshing
R2 tables support full and append refreshes, on demand or on a schedule. See Refreshes.