Genie Agent works with selected Unity Catalog data. The analyst describes business terms and examples, and users ask questions across an agreed area.
What is an Active Client
Sales and support may use the same name for two different metrics. A Genie Agent answers using curated data once an analyst supplies tables, instructions, and SQL examples. For the first test, define which event makes a customer active and over what period. Specify whether test records count and which time zone applies. Settle these details before colleagues start asking in their own words.
Test Question and SQL Checker
Build small sample tables with duplicate actions and customers with no new activity. Ask for active customers by week and compare the result with the analyst’s query. Check the date field, how duplicates were removed, and whether the first partial week was included. Then rephrase the question and verify that the metric definition still holds.
If a question can mean two things, add a clarification to the agent instructions. Asking which definition the user means can be more useful than returning a number without context.
Checking access in the workspace
Run the same query under accounts with different roles. Check opening tables and the ability to view SQL. Separately evaluate the time and load on calculations for several characteristic requests. When updating the scheme, go back to the control examples so that a new field with a similar name does not change the meaning of the answer imperceptibly.
Suitable tasks
- Address differences in indicator definition
- Verify received SQL with a control request
Strengths
- Allows you to specify examples and terms for a limited subject area
- Shows query results and available SQL context
Limitations
- Configure permissions and visible data before use
- An incomplete metric definition can produce a plausible but incorrect answer
Selection and conditions
- Free access
- Not confirmed
- Trial period
- Not confirmed
- No sign-up required
- Not confirmed
- Russian interface
- Not confirmed
- Local installation
- Not confirmed
- API
- Yes
“Not confirmed” means there is not enough information. The feature may still be available; check the developer’s terms.
- Input formats
- Text, Data
- Result
- Code, Data
Terms
Cost depends on your plan and the compute used for queries. Check the current terms for your workspace. Configure permissions and visible data before use.From task to first result
Practical example
- Task
- Address differences in indicator definition
- What to prepare
- A practice database without personal information and a question about its contents.
Task brief or prompt
Task for a configured agent: show monthly order counts from the practice database. First check the tables and field meanings, then prepare a read only query. Do not modify records; compare the result with an independent control query.
Expected result
A query and answer from the practice database with verifiable selection criteria.
How to check the result
- Check JOINs, filters, dates and duplicate counting.
- Use the least permissions needed; do not invent a value when a row is absent.
An editorial teaching example of a task brief, not the result of hands-on testing of the service. Check that the required mode is available, that you have rights to the source material and that the intended use of the result is permitted.
Check details
Official sources
- Official review of Genie Agents
- Databricks Genie developer's manual
- Calculations and platform conditions
This description is based on the developer’s material. Features, prices and availability may change; check the primary source before use.
