01
Assistant Nl2sql Smoke V1
Evaluates Databricks' Assistant NL2SQL — query intent translation, schema-constrained generation, and result reliability — across 3 test cases graded case by case by an LLM judge.
Mapped capabilities
3 scenarios
- Query Intent Translation
- Schema-Constrained Generation
- Result Reliability
Public sample case
- Input
- How many orders are completed?
- Expected behavior
- sql: SELECT COUNT(*) FROM orders WHERE status = 'completed';
- Check
- Pass / fail check
Public sample case
- Input
- Total revenue from completed orders?
- Expected behavior
- sql: SELECT SUM(amount) FROM orders WHERE status = 'completed';
- Check
- Pass / fail check
Public sample case
- Input
- Number of customers in each country?
- Expected behavior
- sql: SELECT country, COUNT(*) FROM customers GROUP BY country;
- Check
- Pass / fail check
Example criterion: Databricks reliably translates analyst questions into accurate SQL that returns trustworthy business results.



