Core Components
Cache [beta]
Core Components
Cache [beta]
Cache management functions
| Name | Description |
|---|---|
duckdb.cache | Caches Parquet, CSV, Delta, or Iceberg file to disk |
duckdb.cache_info | Returns metadata about cached files |
duckdb.cache_delete | Deletes a file from the cache |
You can choose to cache a particular file by calling:
This query will block while the file is downloaded. While the download is occurring, you will not be able to query this file.
Once completed, the cached file will be automatically used for future queries to this file.
Limitations (beta)
Currently files must be removed manually from disk. Files are stored in the duckdb_cache
directory inside the Postgres data directory. In the future, you will be able to set a
maximum cache size and delete files manually from SQL.