databricks-ai-functions

Run AI functions for parsing, extraction, classification, and forecasting in Databricks SQL and PySpark pipelines.

31|18|Updated Apr 4, 2026
One-click install
npx skills add https://github.com/ThomazRossito/data-agents --skill databricks-ai-functions-thomazrossito
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: databricks-ai-functions
Source: https://github.com/ThomazRossito/data-agents/tree/main/skills/databricks/databricks-ai-functions
Command: npx skills add https://github.com/ThomazRossito/data-agents --skill databricks-ai-functions-thomazrossito

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill removes the operational overhead of managing model endpoints and boilerplate code by enabling AI capabilities (classification, extraction, summarization, translation, redaction, similarity, document parsing, and forecasting) directly inside Databricks SQL and PySpark pipelines so teams can deploy large-scale batch and streaming AI workflows with minimal integration effort.

Core Features & Use Cases

  • Task-specific AI Functions: ai_classify, ai_extract, ai_summarize, ai_mask, ai_translate, ai_fix_grammar, ai_gen, ai_analyze_sentiment, ai_similarity for direct column-level enrichment.
  • General-purpose and Multimodal: ai_query for complex nested JSON outputs, custom endpoints, and image+text multimodal inputs.
  • Document Parsing & RAG: ai_parse_document for PDFs/images/DOCX plus patterns to parse → chunk → index → query for retrieval-augmented generation.
  • Time Series Forecasting: ai_forecast as a table-valued function for business forecasting use cases.
  • Production Patterns: Centralized config.yml, failOnError handling, DLT/DSPy pipeline examples, batch and streaming designs, and Vector Search integration for RAG systems.

Quick Start

Use ai_parse_document to extract text from PDFs in a Unity Catalog volume, then run ai_summarize and ai_extract to generate summaries and structured fields and write the results to a Delta table.

Frequently Asked Questions about databricks-ai-functions

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I run AI classification and extraction directly in Databricks SQL?

You can run AI classification and extraction directly in Databricks SQL using built-in functions like ai_classify and ai_extract for column-level data enrichment without managing external model endpoints.

Can I parse PDFs and build a RAG pipeline inside PySpark?

You can parse PDFs and build a RAG pipeline inside PySpark using the ai_parse_document function to extract text, followed by chunking, indexing, and querying with Vector Search integration.

What Databricks Runtime version is required for AI functions and document parsing?

AI functions require Databricks Runtime 15.1 or higher, while ai_parse_document specifically needs DBR 17.1 or above, and ai_forecast requires a Pro or Serverless SQL warehouse.

Does Databricks SQL support time series forecasting for business analytics?

Databricks SQL supports time series forecasting for business analytics through the ai_forecast table-valued function, which requires a Pro or Serverless SQL warehouse to execute.

How do I redact PII and translate text in a Databricks streaming pipeline?

You can redact PII and translate text in a Databricks streaming pipeline using the ai_mask and ai_translate functions to process data continuously with AI-driven column-level enrichment.

What is the best way to manage AI prompts across multiple Databricks SQL queries?

The best way to manage AI prompts across multiple Databricks SQL queries is by centralizing prompts and model names in a config.yml file, ensuring consistent execution across batch and streaming workflows.