Databricks PAT integration for AI agents
Browse Unity Catalog, run SQL queries, and ask Genie agents
Connect Databricks PAT to Langdock and use it in chat, in agents and in workflows.
18 actions
Databricks PAT actions
Each action is one step an agent or workflow can run in Databricks PAT.
Read and search
- Get dashboard
Reads a Databricks (Lakeview) dashboard's metadata, its underlying SQL queries, and page structure. Accepts a dashboard ID or a dashboard URL.
- Get Genie response
Gets a Genie response that was still processing when Ask Genie returned. Returns the answer, generated queries, and query results when ready.
- Get notebook
Gets the source content of a Databricks notebook. Accepts a workspace path or a notebook URL of the .../#workspace/<path> form.
- Get SQL result
Fetches the status and result of a SQL query that was submitted with 'Run SQL query'. Use this to check back on a query that was still running.
- Get table metadata
Retrieves detailed metadata for a specific table including description, columns with their types and comments, owner, and tags. Essential for data discovery.
- List catalogs
Lists all Unity Catalog catalogs accessible to the user. Catalogs are the top-level container for data assets.
- List dashboards
Lists the Lakeview dashboards in the workspace. Use 'Get dashboard' on a returned dashboard ID to read its queries and structure.
- List Genie agents
Lists the Genie agents available in the workspace. Genie agents answer natural-language questions about data in Unity Catalog.
- List notebooks
Lists the notebooks, files, and folders directly under a workspace path. Use 'Get notebook' on a returned notebook path to read its content.
- List schemas
Lists all schemas within a specified catalog. Schemas contain tables, views, and other data objects.
- List serving endpoints
Lists all model serving endpoints in the workspace, including agent endpoints. Shows endpoint name, state, and type.
- List SQL warehouses
Lists the SQL warehouses in the workspace. Use this to find the warehouse to run SQL statements against.
- List tables
Lists all tables within a specified catalog and schema. Returns table names, types, and basic metadata.
- List volumes
Lists all volumes within a specified catalog and schema. Volumes are used to store unstructured data like files.
- Run SQL query
Runs a read-only SQL query on a SQL warehouse and returns the result rows. Use this to query tables, run aggregations, or read data from Unity Catalog. Only SELECT-style queries are allowed; write and DDL statements are rejected.
- Search tables
Search for tables across catalogs by name pattern. Useful for discovering datasets when you know part of the name.
Create and update
- Ask Genie
Asks a Genie agent a natural-language question about its configured data. Starts a new conversation or continues an existing one.
- Invoke agent
Sends a message to a Databricks model serving endpoint and returns the reply. Works with chat model endpoints (such as Llama or GPT-OSS), agent endpoints, and legacy supervisor agents. For questions about data in a Genie space, use Ask Genie instead.
Example prompts
Langdock suggests these prompts in the product for Databricks PAT.
- What Databricks catalogs can I access?
- Which Databricks warehouses are available to me?
- Show Databricks dashboards I can access
- What can I use this Databricks integration for?
Setup and permissions
You connect Databricks PAT with an API key from Databricks PAT. Actions then run with the permissions of that key.
An action can ask for your confirmation before it runs. In an agent, each action is set to “Always allow” or “Needs approval”.
Related integrations
Databricks
Browse Databricks data, run SQL queries, and use Genie agents
71 actions
Excel
Read, update, and format cells in your workbooks
26 actions
Google Analytics
Pull reports on traffic, content performance, and real-time users
7 actions
Google Sheets
Read, write, and manage rows in your spreadsheets
16 actions · 1 trigger
Looker
Run Looks, explore models, and browse dashboards
12 actions
Metabase
Run queries, browse dashboards, and explore collections
13 actions