Skip to main content

Dictionary

This page provides a comprehensive overview of Dictionary operations in Databend, organized by functionality for easy reference.

Dictionary Management

CommandDescription
CREATE DICTIONARYCreates a new dictionary for accessing external data sources
DROP DICTIONARYRemoves a dictionary

Dictionary Information

CommandDescription
SHOW DICTIONARIESLists all dictionaries in the current database
SHOW CREATE DICTIONARYDisplays the CREATE statement for an existing dictionary
note

Dictionaries in Databend allow you to directly query data from external sources (like MySQL, Redis) in real-time without ETL processes. This helps solve data consistency issues, improves query performance, and simplifies data management. You can query external data using the dict_get function.

Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today