Search Shortcut cmd + k | ctrl + k
lance

Query Lance datasets directly from DuckDB.

Maintainer(s): Xuanwo

Installing and Loading

INSTALL lance FROM community;
LOAD lance;

Example

SELECT * FROM 's3://bucket/my_dataset.lance';

About lance

Lance is a modern columnar data format optimized for ML/AI workloads, with native cloud storage support. This extension brings Lance into a familiar SQL workflow.

Added Functions

function_name function_type description comment examples
lance_scan table NULL NULL