Integrate via Direct Connect


  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.