Query Databricks Bundle Quick Reference
Jobs, parameters, tables and grants on one page
TL;DREverything the integration ships, in the shortest useful form. For how and why, follow the links.
Jobs
| Job | Does | Writes |
|---|---|---|
setup | Creates result tables, checks the detections contract | — |
run_fsql_query | Runs one FSQL statement across the mesh | query_mesh_events, fsql_run_audit |
run_query_worker | Launches Query Worker investigations | worker_investigations |
fetch_worker_report | Collects finished reports | worker_investigations |
refresh_connectors | Snapshots what is connected | query_mesh_connectors |
ask_mcp_agent | Asks the mesh a plain-English question | mcp_agent_answers |
load_sample_detections | Synthetic detections, evaluation only | a table you name |
Only fetch_worker_report carries a schedule, and it ships paused.
Common Commands
databricks bundle deploy --profile <profile> --var catalog=my_catalog --var schema=my_schema
databricks bundle run setup --profile <profile>
databricks bundle run run_fsql_query --profile <profile> --params fsql="QUERY detection_finding.** AFTER 1days LIMIT 25"
databricks bundle run run_query_worker --profile <profile> --params max_investigations=0
databricks bundle run fetch_worker_report --profile <profile>
databricks bundle run refresh_connectors --profile <profile>
databricks bundle run ask_mcp_agent --profile <profile> --params question="Which platforms are connected?"
./dashboard/deploy.sh <profile> <dashboard-id>
./agent/deploy_connection.sh <profile>
Key Parameters
| Job | Parameter | Default |
|---|---|---|
run_fsql_query | fsql | — |
run_query_worker | detection_filter | severity = 'Critical' AND status NOT IN ('Resolved', 'Suppressed') |
run_query_worker | worker_question | the full brief, readable in the parameter itself |
run_query_worker | max_investigations | set 0 to plan without launching |
ask_mcp_agent | question | — |
ask_mcp_agent | model | a Databricks foundation model endpoint |
ask_mcp_agent | fsql_timeout | 300 |
Tables
| Table | One row per |
|---|---|
query_mesh_events | OCSF event returned by a federated search |
fsql_run_audit | FSQL run — statement, row count, which connectors answered |
worker_investigations | Query Worker investigation, gaining its report when collected |
mcp_agent_answers | Question asked of the mesh, with the tools the model called |
query_mesh_connectors | Connector in the latest snapshot |
Detections Contract
| Columns | |
|---|---|
| Required | id, name, severity, status |
| Recommended | description, product_name, event_time, actor_user_name, device_hostname, src_ip |
| Optional | mitre_tactic, mitre_technique_uid, mitre_technique, severity_id |
FSQL Patterns That Run
QUERY authentication.** AFTER 7days LIMIT 5
QUERY detection_finding.** WITH %hostname = 'somehost' AFTER 7days LIMIT 20
QUERY network_activity.** WITH %hostname = 'somehost' AFTER 6hours LIMIT 20
QUERY osint_inventory_info.** WITH %hash = '...' LIMIT 10
Entity selectors: %username %hostname %ip %hash %email %filename %processname
Always name an event class and a LIMIT. See the FSQL Cheat Sheet.
Grants
GRANT USE CATALOG ON CATALOG my_catalog TO `security-readers`;
GRANT USE SCHEMA ON SCHEMA my_catalog.my_schema TO `security-readers`;
GRANT SELECT ON SCHEMA my_catalog.my_schema TO `security-readers`;
| To | Also needs |
|---|---|
| Read the dashboard | CAN READ on the dashboard; CAN USE on the warehouse |
| Read a full report | notebook access; serverless compute |
| Ask the mesh | USE_CONNECTION; EXECUTE on the MCP service; own sign-in |
| Ask Genie | CAN RUN on the Genie space |
| See or run jobs | CAN VIEW / CAN MANAGE RUN |
Grant to an account-level group. admins is workspace-local and not a Unity Catalog principal.
Usage Notes
- A deployed bundle shares nothing. Jobs are visible only to whoever deployed them until shared.
- A job run costs the same on Databricks end whether a search returns 20 rows or 20,000 — batch searches rather than running one job per detection.
- Zero rows from a federated search is the weakest result there is. Check
fsql_run_auditfor which connectors answered before reading it as an absence. - MCP authorization expires after 24 hours, or 12 hours idle — see Connecting an MCP Client.
run_fsql_queryhas no such limit. - The report notebook needs serverless compute, not a SQL warehouse.
Updated about 1 hour ago
Did this page help you?