databricks-genie

Create and query Databricks Genie Spaces via the Conversation API.

Updated Sep 9, 2017

Search Tags:#sql #natural-language #spaces #databricks #unity-catalog #genie #conversation-api

Ready to run

npx skills add https://github.com/mirakui/dotfiles --skill databricks-genie-mirakui

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: databricks-genie
Source: https://github.com/mirakui/dotfiles/tree/main/claude/skills/databricks-genie
Command: npx skills add https://github.com/mirakui/dotfiles --skill databricks-genie-mirakui

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Databricks Genie Spaces provide natural language interfaces to explore data using SQL over Unity Catalog; this skill lets you create and query Genie Spaces and interact with them via the Conversation API.

Core Features & Use Cases

Space management: create, update, get details, list, and delete Genie Spaces.
Conversation API: ask questions and receive generated SQL and results, with follow-ups.
Reference and testing: inspect table details and test SQL queries against a connected warehouse.

Quick Start

Create or update a Genie Space using your catalog tables, then ask a question via the Conversation API to test it.

Frequently Asked Questions about databricks-genie

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

FAQPage Schema

How do I create a Databricks Genie Space using natural language?▼

To create a Databricks Genie Space using natural language, you use the skill's space management features to build and configure spaces based on your Unity Catalog tables. You can then create, update, list, or delete them directly.

What is needed to query Unity Catalog data with the Genie Conversation API?▼

To query Unity Catalog data with the Genie Conversation API, you need configured Unity Catalog tables and a connected SQL warehouse. The API uses these resources to generate SQL from natural language questions and return query results.

Can I ask follow-up questions when generating SQL from natural language in Genie Spaces?▼

Yes, you can ask follow-up questions when generating SQL from natural language in Genie Spaces. The Conversation API supports interactive sessions, allowing you to ask questions, receive generated SQL and results, and then ask follow-up queries.

Does Databricks Genie support testing SQL queries before running them against a warehouse?▼

Databricks Genie supports testing SQL queries against a connected warehouse. You can inspect table details and test SQL queries directly through the provided Genie tools before executing them on your data.

What are the limitations of using Genie Spaces for natural language SQL generation?▼

Limitations of using Genie Spaces for natural language SQL generation include the strict dependency on pre-configured Unity Catalog tables and an active SQL warehouse. It cannot operate without these underlying Databricks environment components.