Enterprise Features

This page provides an updated list of available enterprise features. To access these features, you will need an enterprise or trial license. For more details, see Licensing Databend.

Enterprise Feature List

Feature	Category	Description
Vacuum Temp Files	Storage	- Free up storage by removing temporary files, notably join, aggregate, and sort spill files. - Set retention and file limits as needed.
Vacuum Dropped Table	Storage	Optimizes storage by deleting data files of dropped tables. Offers a recovery option and a dry-run preview.
Vacuum Historical Data	Storage	Deep clean your storage space: - Remove orphan segment and block files. - Safely preview the removal of data files using the dry-run option.
Virtual Column	Query	Enhance efficiency in querying Variant data: - Virtual columns streamline queries, eliminating the need to traverse the entire nested structure. Direct data retrieval accelerates query execution. - Virtual columns significantly cut memory usage in Variant data, reducing the risk of memory overflows.
Aggregating Index	Query	Elevate your query speed with aggregating indexes: - Supercharge queries through precomputed and indexed aggregations. - Customize the index to meet your unique data analysis requirements.
Computed Column	Query	Computed columns save you time and effort by enabling derivation of new columns from existing ones: - Automatic updates ensure accurate and consistent data. - Advanced analysis and calculations can now be performed within the database. - Two types of computed columns: stored and virtual. Virtual columns save you space as they are calculated on-the-fly when queried.
Python UDF	Query	A Python UDF allows you to invoke Python code from a SQL query via Databend's built-in handler, enabling seamless integration of Python logic within your SQL queries.
ATTACH TABLE	Query	Attach Table enables you to seamlessly connect a table in the cloud service platform to an existing table deployed in a private deployment environment without the need to physically move the data.
Stream	Data Streaming	Efficient data change management with stream: - Append-only mode supported: Instantly capture data insertions in real-time. - Seamlessly leverage streams for direct querying and analysis, ensuring swift insights.
Masking Policy	Security	Enhance your data security with role-based masking feature: - Safeguard sensitive information through customizable data masking. - Preserve data usability while reinforcing security.
Storage Encryption	Security	Enhance the security of your server-side data encryption, safeguarding your data from unauthorized access by the storage vendor: - Choose encryption through service-managed keys, KMS managed keys, or customer-managed keys. Options may vary by storage type. - Currently supported on Alibaba Cloud OSS. See the deploy guide for encryption parameters for each storage vendor.
Fail-Safe	Security	Recover table data from S3-compatible object storage.
BendSave	Recovery	BendSave is a command-line tool for backing up and restoring both metadata and actual data files in Databend.

Databend Community vs. Enterprise

This section compares Databend Community with Databend Enterprise in the following modules:

Core Functionalities

Functionality	Databend Community	Databend Enterprise
Distributed Metadata Management	✓	✓
Distributed SQL Engine	✓	✓
Distributed Storage Engine	✓	✓
Distributed Scheduling Engine	✓	✓
Vectorized Engine	✓	✓
Distributed Transaction	✓	✓
Multi-version Data	✓	✓
Time Travel	✓	✓
Performance Optimizer	✓	✓
Multi-tenancy and Permission Management	✓	✓
Standard Data Types	✓	✓
Semi-structured Data Type (JSON)	✓	✓
Unstructured Data Types	Parquet/CSV/TSV/JSON/ORC	Parquet/CSV/TSV/JSON/ORC
Advanced Compression	✓	✓
Vector Storage	✓	✓
Apache Hive Query	✓	✓
Apache Iceberg Query	✓	✓
Semi-structured Data Query	✓	✓
External User-defined Functions	✓	✓
Large Query Resource Isolation Protection (Spill)	✓	✓

Extended Functionalities

Functionality	Databend Community	Databend Enterprise
Cluster Mode	✕	✓
Materialized Views	✕	✓
AI Functions (Sentiment Analysis, Data Annotation, etc.)	✕	✓ (HuggingFace Open Source Models)

Deployment

Functionality	Databend Community	Databend Enterprise
Deployment Support: K8s, Baremetal, Installer	✓	✓
Backend Storage Support: S3, Azblob, GCS, OSS, COS	✓	✓
x86_64 & ARM64 Architecture	✓	✓
Compatible with LoongArch, openEuler, etc.	✓	✓
Monitoring and Alerting APIs	✓	✓

Ecosystem

Functionality	Databend Community	Databend Enterprise
Driver Support: Go, Java, Rust, JS, Python	✓	✓
Native REST APIs	✓	✓
Native Client BendSQL	✓	✓

Security

Functionality	Databend Community	Databend Enterprise
Audit Functionality	✓	✓
Access Control RBAC	✓	✓
Password Strength and Expiry Policy	✓	✓
Whitelist Management	✓	✓
Storage Encryption	✕	✓
Data Dynamic Masking Policy	✕	✓

Data Import & Export

Functionality	Databend Community	Databend Enterprise
Data Processing during Import	✓	✓
Data Streaming	✕	✓
CDC Real-time Data Import	✕	✓
Data Export Formats	Parquet/ORC/CSV/NDJSON	Parquet/ORC/CSV/NDJSON

Query Optimizations

Functionality	Databend Community	Databend Enterprise
Aggregation Query Acceleration Optimization	✕	✓
JSON Query Acceleration Optimization	✕	✓
Precomputation Capability	✕	✓

Storage Optimizations

Functionality	Databend Community	Databend Enterprise
Cold/Hot Data Separation	✕	✓
Automatic Expiry Data Cleaning	✕	✓
Automatic Garbage Data Cleaning	✕	✓

Customer Support

Functionality	Databend Community	Databend Enterprise
24/7 Support & Emergency Response	✕	✓
Deployment and Upgrade	✕	✓
Operational Support	✕	✓