Databricks genie for ad hoc qna
Reddit r/analytics1w4 min read
Thought I'd do a quick run down of how we've used genie to manage the long tail of ad hoc questions for an HR use case where I work. Setup - Pointed Genie at a curated set of ~[5–6] tables, not the raw warehouse. Headcount snapshot, terminations, reqs/pipeline, and a couple of dim tables (department, location, job level). - The single biggest lever was the semantic layer / instructions. I added column descriptions, defined what "attrition" and "active headcount" actually mean in the instructions, and gave ~[15] example questions (SQL pairs). This made the biggest difference to quality. - Curat