Databricks

Steps

1. Create a Serverless SQL Warehouse (size depends on your data volume)
2. Create a Service Principal with the following permissions:
   1. Read-only permissions to your intended data tables/views
   2. Create table permission (to create a couple of auxiliary tables with full access)
   3. Permission to access the warehouse (to execute the analyses)
   4. Access to the Query History of the user (for troubleshooting purposes)

A separate set of the above for Development purposes to isolate the impact on Production and avoid accidents. We will be ready to provide detailed step-by-step instructions once your team is ready.