SaaS Onboarding

Step 1: Login to Databricks and capture the account ID

1. log in to databricks as admin ( https://accounts.azuredatabricks.net )

2. Click on the profile icon at top right corner and copy the account ID
   

   

Step 2: Create Service Principal

1. Navigate to workspaces from left menu bar and click open for the workspace which you wanna onboard

2. Click on the workspace and click on open workspace
   

   

3. Click on the profile icon at top right corner and click settings

3. Click on Identity and access and Click Manage for Service Principals

3. Click on Add service principal and click Add new

4. Select “Databricks managed” and enter the service principal name and click on Add service principal
   

5. Navigate to newly created service principal and click on Secrets tab

6. Click on generate secret button, and then enter the validity of the secret in the number of days and click on generate

7. After creating, you will get the client ID and client secret as shown below, and you need to capture and save them
   

Step 4: Run the SQL query

1. Navigate to workspaces from left menu bar and open the workspace

2. Click on SQL editor and run the following queries in the SQL editor as follows and replace the service principal client id with the one created above in service principal

GRANT USE SCHEMA ON SCHEMA system.compute TO `<service principal client id>`;
GRANT SELECT ON TABLE system.compute.clusters TO `<service principal client id>`;
GRANT USE SCHEMA ON SCHEMA system.billing TO `<service principal client id>`;
GRANT SELECT ON TABLE system.billing.list_prices TO `<service principal client id>`;
GRANT SELECT ON TABLE system.billing.usage TO `<service principal client id>`;

Step 5 : Copy the JDBC URL

1. Click on the existing SQL Warehouse which you wanna connect

2. Go to the connection details and copy the JDBC URL

Step 6: Integrate into Mavvrik portal

1. Go to Mavvrik portal and click on admin and then SaaS
   

   

   
   

2. Click on +account and then select databricks

3. Enter the details captured above i.e.

   • Account id

   • Client id

   • Client Secret

   • JDBC URL
     

     

4. Then click on connect After it is connected, you will see it as below