What SQL and AI function capabilities does the Databricks lakehouse offer?
Databricks SQL offers AI Functions for LLM calls and document processing. ai_query is the general-purpose function for custom prompts against Foundation Model APIs and other serving endpoints. ai_parse_document parses PDFs and other documents, including PDF, JPG, PNG, TIFF, DOC/DOCX and PPT/PPTX, into structured elements such as text, tables and headers.
What are the main AI agent paths on Databricks and how do I choose?
The Agent Bricks docs describe Genie Agents as the recommended low-code agent for governed data and documents, and the Agent Bricks CLI as the code-first path for custom agents. The CLI can run agents on Agent Runtime and serve them through Agent Server. The docs label Supervisor Agent and Knowledge Assistant as legacy offerings. The Genie One MCP server gives agents natural-language access to governed business data.
What ingestion limits apply to Knowledge Assistant documents?
Knowledge Assistant builds a chatbot that answers questions about your documents, using files in a Unity Catalog volume, a table with a file column, or an AI Search index, and it exposes the result as an agent endpoint for your applications. Ingestion skips files larger than 100 MB, and PDF, DOC, DOCX, PPT, and PPTX files with more than 500 pages, so split very large documents into smaller files. TXT and MD files have no page limit, and each PowerPoint slide counts as one page. Databricks labels Knowledge Assistant a legacy offering and recommends Genie Agents for new low-code agents.
Which AI Functions are available in Databricks SQL?
Databricks SQL includes AI Functions grouped by purpose. ai_query is the general-purpose function for custom prompts and any supported Foundation Model API. Document-processing functions include ai_parse_document, ai_extract, and ai_classify, and ai_gen covers content generation. Text transformation functions include ai_fix_grammar, ai_translate, ai_summarize, and ai_mask, and vector_search is listed under vector search.
What does Agent Bricks provide for building and running production agents on Databricks?
Databricks describes Agent Bricks as the Databricks agent developer platform. Its building blocks include Agent Runtime, which hosts agents from any framework on Databricks-hosted compute, and Agent Server, which handles synchronous, streaming, and background runs with crash recovery. It also offers connections to MCP servers, including a Genie One MCP server, and retrieval from AI Search indexes.
How are model calls, MCP servers, and skills governed for agents built on Agent Bricks?
Databricks describes Unity Gateway as providing one API for frontier and open models, so you can switch models without changing agent code. Unity Gateway applies guardrails, rate limits, and usage tracking to models, MCP servers, and skills. Observability uses MLflow Tracing to record agent steps, and evaluation uses LLM judges, custom scorers, and expert feedback.
How do I summarize text in SQL with ai_summarize?
ai_summarize(content, max_words) returns a summary of a string using a Databricks Foundation Model API chat endpoint. The max_words value is a best-effort target and defaults to 50; setting it to 0 removes the word limit. It returns NULL for NULL input. The function is in Public Preview, requires Databricks Runtime 15.4 LTS or later (18.2 recommended), and is not available on Databricks SQL Classic.
How do I classify the sentiment of text in Databricks SQL?
Call ai_analyze_sentiment(content) on a STRING column. It returns one of four labels: positive, negative, neutral, or mixed, and NULL when sentiment cannot be detected. The function is in Public Preview, requires Databricks Runtime 15.4 LTS or later (18.2 recommended), and is tuned for English although the model handles several languages. It is not available on Databricks SQL Classic, and pricing is listed on the SQL pricing page.
What endpoint types does Databricks AI Search offer, and what should I know before creating one?
AI Search endpoints come in Standard and Storage Optimized types. You can create them in the UI under Compute, then AI Search, with the Python SDK, through the REST API, or as a bundle resource, and optionally assign a usage policy for cost tracking. If Databricks computes embeddings, you can use a pre-configured Foundation Model APIs endpoint or a new serving endpoint, and Databricks recommends turning off the scale-to-zero default. Storage Optimized endpoints support only Triggered sync mode, while Standard endpoints support both Triggered and Continuous.
What does ai_translate do in Databricks SQL?
ai_translate(content, to_lang) translates a STRING into a target language inside a SQL query. The to_lang argument accepts IETF BCP 47 codes, full language names, or descriptive phrases. The documented supported languages are English, French, German, Hindi, Italian, Portuguese, Spanish, and Thai. For example, SELECT ai_translate('Hello, how are you?', 'es') returns a Spanish greeting. The function is in Public Preview and requires Databricks Runtime 15.4 LTS or later.
How do I transcribe audio files to text with speaker labels in Databricks?
Use ai_transcribe, a Beta SQL function that converts audio into time-stamped segments with automatic speaker labels, returned as a VARIANT that other AI functions can consume. The input can be a FILE expression or BINARY bytes, such as the content column from read_files with the binaryFile format on a Unity Catalog volume. It supports MP3, WAV, FLAC, Opus, and M4A, but not video, and English and Spanish are the supported languages. An admin must enable AI Transcribe on the Previews page.
Which Databricks SQL AI functions are general-purpose, and which are task-specific?
ai_query is the general-purpose function for custom prompts: you provide any prompt and choose any supported Foundation Model API model. ai_gen also accepts a free-form prompt, but the overview groups it under content generation. The other functions are task-specific and each does one job, such as ai_extract, ai_classify, ai_summarize, ai_mask, ai_translate, ai_analyze_sentiment, ai_forecast, and ai_parse_document. The overview groups functions by task so you can pick a narrow function for a known task and use ai_query for custom prompts.
How do memory pipelines move agent conversation history into long-term agent memory?
A memory pipeline connects one session store to one memory store, and it is in Beta. For each actor, it distills durable facts from new conversations with an LLM, merges and deduplicates them into topic-based entries in the memory store, and consolidates overlapping entries over time. Each actor has a checkpoint, so later runs pick up where the last one stopped.