Azure Extension

Search Shortcut cmd + k | ctrl + k

Documentation / Extensions

Azure Extension

The azure extension is a loadable extension that adds a filesystem abstraction for the Azure Blob storage to DuckDB.

This extension is currently in an experimental state. Feel free to try it out, but be aware some things may not work as expected.

Installing and Loading

To install and load the azure extension, run:

INSTALL azure;
LOAD azure;

Authentication is done by setting the connection string:

SET azure_storage_connection_string = '<your_connection_string>';

After setting the connection string, the Azure Blob Storage can be queried:

SELECT count(*) FROM 'azure://<my_container>/<my_file>.<parquet_or_csv>';

Blobs are also supported:

SELECT * FROM 'azure://<my_container>/*.csv';