Databend Python Binding


Keywords
ai, bigdata, database, lakehouse, olap, rust, serverless, snowflake
License
Apache-2.0
Install
pip install databend==1.2.242

Documentation

Databend: The Next-Gen Cloud [Data+AI] Analytics

databend

🐋 Introduction

Databend, built in Rust, is an open-source cloud data warehouse that serves as a cost-effective alternative to Snowflake. With its focus on fast query execution and data ingestion, it's designed for complex analysis of the world's largest datasets.

⚡ Performance

Databend vs. Snowflake

Databend vs. Snowflake

🚀 Why Databend

  • Cloud-Native: Integrates with AWS S3, Azure Blob, Google Cloud, and more.

  • High Performance: Rust-built, with cutting-edge, high-speed vectorized execution. 👉 ClickBench.

  • Cost-Effective: Designed for scalable storage and computation, reducing costs while enhancing performance. 👉 TPC-H.

  • AI-Powered Analytics: Enables advanced analytics with AI Functions.

  • Data Simplification: Streamlines data ingestion, no external ETL needed. 👉 Data Loading.

  • Format Flexibility: Supports multiple data formats and types, including JSON, CSV, Parquet, GEO, and more.

  • ACID Transactions: Ensures data integrity with atomic, consistent, isolated, and durable operations.

  • Version Control: Provides Git-like version control for data, allowing querying, cloning, and reverting at any point.

  • Schemaless: VARIANT data type enabling schemaless data storage and flexible data modeling.

  • Flexible Indexing: Virtual Column, Aggregating Index, and Full-Text Index, for faster data retrieval.

  • Community-Driven: Join a welcoming community for a user-friendly cloud analytics experience.

📐 Architecture

Databend Architecture

🚀 Try Databend

1. Databend Serverless Cloud

The fastest way to try Databend, Databend Cloud

2. Install Databend from Docker

Prepare the image (once) from Docker Hub (this will download about 170 MB data):

docker pull datafuselabs/databend

To run Databend quickly:

docker run --net=host  datafuselabs/databend

🚀 Getting Started

Connecting to Databend
Data Import and Export
Loading Data From Other Databases
Querying Semi-structured Data
Visualize Tools with Databend
Managing Users
Managing Databases
Managing Tables
Managing Data
Managing Views
AI Functions
Data Management
Accessing Data Lake
Security
Performance

🤝 Contributing

Databend thrives on community contributions! Whether it's through ideas, code, or documentation, every effort helps in enhancing our project. As a token of our appreciation, once your code is merged, your name will be eternally preserved in the system.contributors table.

Here are some resources to help you get started:

👥 Community

For guidance on using Databend, we recommend starting with the official documentation. If you need further assistance, explore the following community channels:

🛣️ Roadmap

Stay updated with Databend's development journey. Here are our roadmap milestones:

📜 License

Databend is released under a combination of two licenses: the Apache License 2.0 and the Elastic License 2.0.

When contributing to Databend, you can find the relevant license header in each file.

For more information, see the LICENSE file and Licensing FAQs.

🙏 Acknowledgement

  • Inspiration: Databend's design draws inspiration from industry leaders ClickHouse and Snowflake.

  • Computing Model: Our computing foundation is built upon Arrow2, a faster and more secure rendition of the Apache Arrow Columnar Format.

  • Documentation Hosting: The Databend documentation website proudly runs on Vercel.