Querying Databricks SQL Data

Prerequisites:

• Databricks Unity Catalog integration configured with Immuta

• Databricks SQL tables registered as Immuta data sources

Query data

1. Select SQL from the navigation menu in Databricks.

2. Click Create → Query.

3. Run your query as you normally would:

   Copy

   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