Sign inSign up

beckm/duckdb-ui

By beckm

Updated about 12 hours ago

Image
0

1.5K

beckm/duckdb-ui repository overview

DuckDB HTTP UI mit automatischem Azure Blob Storage Mount via BlobFuse2.

Quick Start

docker run --rm -it --privileged \
  -e AZURE_STORAGE_ACCOUNT="deinaccount" \
  -e AZURE_STORAGE_SAS_TOKEN="" \
  -e AZURE_STORAGE_CONTAINERS="bronze" \
  -p 80:4200 \
  beckm/duckdb-ui
docker run --rm -it --cap-add SYS_ADMIN --device /dev/fuse \
  -e AZURE_STORAGE_ACCOUNT="deinaccount" \
  -e AZURE_STORAGE_SAS_TOKEN="" \
  -e AZURE_STORAGE_CONTAINERS="bronze" \
  -p 80:4200 \
  beckm/duckdb-ui
docker run --rm -it --privileged -e AZURE_STORAGE_ACCOUNT="deinaccount" -e AZURE_STORAGE_SAS_TOKEN="" -e AZURE_STORAGE_CONTAINERS="bronze" -p 80:4200 beckm/duckdb-ui
docker run --rm -it --cap-add SYS_ADMIN --device /dev/fuse -e AZURE_STORAGE_ACCOUNT="deinaccount" -e AZURE_STORAGE_SAS_TOKEN="" -e AZURE_STORAGE_CONTAINERS="bronze" -p 80:4200 beckm/duckdb-ui

UI erreichbar unter http://localhost:80

Jeder Azure Blob Storage Container wird via BlobFuse2 lokal unter /<containername> gemountet, z. B. /bronze.

Features

  • DuckDB CLI 1.5.4 mit HTTP UI Server
  • BlobFuse2 Mounts via Key, SAS-Token, Service Principal oder Managed Identity
  • Mehrere Container gleichzeitig mountbar (z. B. bronze silver gold)
  • nginx Reverse-Proxy inkl. WebSocket-Support
  • Ubuntu 24.04 Basis

Authentication

VariableBeschreibung
AZURE_STORAGE_ACCOUNTStorage Account Name (Pflicht)
AZURE_STORAGE_KEYAccount Key
AZURE_STORAGE_SAS_TOKENSAS-Token (mit/ohne ?)
AZURE_TENANT_ID + AZURE_CLIENT_ID + AZURE_CLIENT_SECRETService Principal
AZURE_CLIENT_ID (allein)Managed Identity
AZURE_STORAGE_CONTAINERSLeerzeichen-getrennte Liste (Default: bronze)
View in DuckDB anlegen
CREATE VIEW view01 AS 
SELECT * FROM delta_scan('/bronze/deltatables/');

Tag summary

Content type

Image

Digest

sha256:34dae846c

Size

224.3 MB

Last updated

about 12 hours ago

docker pull beckm/duckdb-ui