Queries without defined relationships
You ask Genie: "Show me total booking revenue by destination." This requires data from the bookings table (revenue), the properties table (linking bookings to destinations), and the destinations table (location names), joined via bookings.propertyid, properties.propertyid, and properties.destination_id.
What happens if you ask this cross-table question without defined relationships between tables?
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