Reading the generated SQL
You asked the "Bakehouse Sales" Genie space: "Show me total revenue by franchise city last quarter." Genie returned a table with cities and revenue figures. Curious about how Genie arrived at these results, you clicked Show code and saw the SQL it generated - a SELECT with a JOIN between sales_transactions and sales_franchises, a WHERE clause for the date range, and a GROUP BY on the city column.
What is the main benefit of reviewing the SQL that Genie generates?
This exercise is part of the course
Introduction to Databricks Genie
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise