AI Functions
This section provides reference information for Databend's built-in AI functions, which enable natural language processing, vector embeddings, and text generation capabilities directly through SQL.
info
Databend's AI functions leverage OpenAI models and also support Azure OpenAI service for improved data privacy. These functions require an OpenAI API key configured in Databend and are available by default on Databend Cloud.
Available AI Functions
| Function | Description | Example |
|---|---|---|
| AI_TO_SQL | Converts natural language instructions into SQL queries | SELECT * FROM ai_to_sql('Get all products with price less than 100') |
| AI_EMBEDDING_VECTOR | Generates vector embeddings for text data | SELECT ai_embedding_vector('How to use Databend') |
| AI_TEXT_COMPLETION | Generates text completions based on a given prompt | SELECT ai_text_completion('What is a data warehouse?') |