Querying Databricks SQL Data
Prerequisites:
Query data
Select SQL from the navigation menu in Databricks.
Click Create → Query.
Run your query as you normally would:
SELECT concat(pickup_zip, '-', dropoff_zip) as route, AVG(fare_amount) as average_fare FROM `samples`.`nyctaxi`.`trips` GROUP BY 1 ORDER BY 2 DESC LIMIT 1000
Last updated
Was this helpful?