connect URI:
Object-storage configuration
For S3-compatible stores, pass credentials and a local read cache:Credentials can also come from the standard AWS environment. The cache keeps hot
superfiles on local disk so warm queries don’t re-fetch from object storage.
Connect options
| Option (Python / Node.js / Rust) | Description |
|---|---|
endpoint, region, keys / with_s3_endpoint(...) | S3-compatible endpoint, region, and credentials |
cache_dir / cacheDir / with_cache_dir | local disk-cache directory for remote-backed tables |
cache_budget_bytes / cacheBudgetBytes / with_cache_budget_bytes | disk-cache budget, in bytes |
cold_fetch_mode / coldFetchMode / with_cold_fetch_mode | how cold-cache misses are serviced |
Limitations
memory://is ephemeral and can’t be mutated.update/deleteneed a path ors3://URI.- Object-storage reads are cached locally. Cold queries fetch from the store; size the cache (
cache_budget_bytes) for your working set.
