databricks-genie

Create and query Databricks Genie Spaces for natural language SQL exploration.

3|Updated Jan 2, 2025
One-click install
npx skills add https://github.com/ScottHMcKean/genai_notebooks --skill databricks-genie-scotthmckean
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: databricks-genie
Source: https://github.com/ScottHMcKean/genai_notebooks/tree/main/.cursor/skills/databricks-genie
Command: npx skills add https://github.com/ScottHMcKean/genai_notebooks --skill databricks-genie-scotthmckean

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill simplifies the process of creating and interacting with Databricks Genie Spaces, enabling natural language exploration of structured data without writing SQL.

Core Features & Use Cases

  • Genie Space Creation: Easily create or update Genie Spaces, defining their display name, associated tables, descriptions, and sample questions.
  • Natural Language Querying: Ask questions in plain English to a Genie Space and receive data-driven answers.
  • Use Case: A business analyst needs to quickly understand sales trends. They use this Skill to create a Genie Space for the sales data, then ask questions like "What were total sales last month?" or "Who are our top customers?" directly through the conversational interface.

Quick Start

Create a Genie Space for sales analytics using the 'my_catalog.sales.customers' and 'my_catalog.sales.orders' tables.

Frequently Asked Questions about databricks-genie

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

FAQPage Schema
How do I query Databricks Unity Catalog tables using natural language instead of SQL?

You can query Databricks Unity Catalog tables using natural language by creating a Genie Space with this Skill, which leverages the Conversation API to translate plain English questions into SQL and return data-driven answers.

What do I need to set up before creating a Databricks Genie Space for data exploration?

To create a Genie Space, you need access to Databricks Unity Catalog tables and a configured SQL warehouse. This Skill uses these dependencies to build conversational interfaces and inspect table schemas for natural language exploration.

Can I programmatically manage and update Databricks Genie Spaces?

Yes, you can programmatically manage Databricks Genie Spaces using this Skill to create or update display names, associate tables, define descriptions, and configure sample questions for your structured data.

How does Databricks Genie handle conversational data exploration for business analysts?

Databricks Genie handles conversational data exploration by allowing business analysts to ask plain English questions directly to structured data, receiving immediate data-driven answers without writing manual SQL queries.

What is the best way to inspect table schemas before asking questions to a Databricks Genie Space?

The best way to inspect table schemas before querying is using this Skill's built-in table schema inspection feature, which validates Unity Catalog table structures to ensure accurate natural language to SQL translation.