The vortex extension requires DuckDB 1.4.2+.

The vortex extension allows you to read and write files using the Vortex file format. It is currently available for the Linux (linux_amd64, linux_arm64) and macOS (osx_amd64, osx_arm64) distributions.

Installing and Loading

To install and load the extension, run:

INSTALL vortex; LOAD vortex; 

Reading Vortex Files

Using the read_vortex function to read Vortex files:

SELECT * FROM read_vortex('my.vortex'); 

┌───────┐ │ i │ │ int64 │ ├───────┤ │ 0 │ │ 1 │ │ 2 │ └───────┘ 

Writing Vortex Files

You can write Vortex files as follows:

COPY (SELECT * FROM generate_series(0, 3) t(i)) TO 'my.vortex' (FORMAT vortex);