{"repo":"isaacbrodsky/duckdb-zipfs","free":true,"listed":false,"github":"https://github.com/isaacbrodsky/duckdb-zipfs","clone":"git clone https://github.com/isaacbrodsky/duckdb-zipfs.git","description":"DuckDB extension to read files within zip archives.","language":"C++","stars":67,"topics":["duckdb","duckdb-extension","zip"],"license":"MIT","category":"data-pipelines","readme_excerpt":"This is a DuckDB extension that adds support for reading files from within zip archives) and other archive formats such as tar . Get started Load from the community extensions repository: To read a file: To read a file from azure blob storage (or other file system): To read the table of contents of a zip file: File names URL quick reference Description --- --- zip://a.zip/ .csv Local zip file named a.zip , containing csv files. zip://http://example.com/a.zip/ .csv Web hosted zip file named a.zip , containing csv files. archive://a.tar.gz!! .csv Local archive file named a.tar.gz , containg csv files. compressed://a.jsonl.bz2 Local compressed ndjson file a.jsonl.bz2 . Function Description --- --- zip contents Read the table of contents of a zip file archive contents Read the table of contents of an archive file File names passed into the zip:// URL scheme are expected to end with .zip , which indicates the end of the zip file name. The path after that is taken to be the file path within the zip archive. Globbing within the zip archive is supported, but see below for performance limitations. A glob query looks like: Globbing for multiple zip files: You may use options to turn this behavior off and instead choose some string to split on: Using zipfs split also means you can read other archives supported by libarchive: (note different URL scheme, and libarchive is not available on Windows) It is also possible to read from a variety of compressed file formats directly: Archive vs z","default_branch":null,"files":null,"tree":[],"storefront":"/r/isaacbrodsky","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/isaacbrodsky/duckdb-zipfs/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}