Querying Databricks SQL Data

Prerequisites:

Query data

  1. Select SQL from the navigation menu in Databricks.

  2. Click Create → Query.

  3. 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

Copyright © 2014-2024 Immuta Inc. All rights reserved.