Dremio +
Python
Unleash the Agentic Lakehouse within your Python ecosystem.
Choose the Right Tool
Dremio isn't just a UI. It has a rich ecosystem of community-driven Python libraries for every persona.
The Minimalist
Just need to run SQL? Don't overcomplicate it. Get high-performance Arrow Flight results instantly.
The Power User
Live in the terminal? Manage sources, users, and reflections without leaving your command line.
The Engineer
Building pipelines? Need DataFrames? Use a robust toolkit for CI/CD, data science, and complex operations.
The Python Toolkit
Three versatile libraries to supercharge your workflow.
dremio-simple-query
For the Minimalist. A lightweight library with one job: executing SQL queries using the high-performance Arrow Flight protocol.
- Pure SQL Execution
- Arrow Flight Speed
- Zero Bloat
pip install dremio-simple-query
dremio-cli
For the Terminal Power User. A CLI for managing Dremio. Script administrative tasks, explore catalogs, and integrate into CI/CD pipelines.
dremio-cli sql execute "SELECT..."
dremioframe
For the Data Engineer. A comprehensive DataFrame API. Manage reflections, run vacuums, build pipelines, and manage your lakehouse as code.
df = client.table('sales').filter(...)