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?
Este exercício faz parte do curso
Introduction to Databricks Genie
Exercício interativo prático
Transforme a teoria em ação com um de nossos exercícios interativos
Começar o exercício