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. |
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, HDFS | ✓ | ✓ |
| 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 | ✕ | ✓ |