Breadcrumbs

Databricks Onboarding

Step 1: Login to Databricks and capture the account ID

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

  2. image-20260401-091241.png

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

    image-20260401-091526.png

Step 2: Create Service Principal

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

image-20250508-072609.png

  1. Click on the workspace and click on open workspace

    image-20250513-070744.png

     

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

image-20250508-142303.png

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

image-20250508-142204.png

  1. Click on Add service principal and click Add new

image-20250508-142612.png

 

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

image-20250508-142647.png

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

image-20250508-143147.png

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

image-20250506-113420.png

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

image-20250506-113825.png

Step 4: Run the SQL query

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

image-20260505-064034.png 
GRANT USE SCHEMA ON SCHEMA system.billing TO `{service_principal_id}`;                                                                         
GRANT SELECT ON TABLE system.billing.usage TO `{service_principal_id}`;                                                                        
GRANT SELECT ON TABLE system.billing.list_prices TO `{service_principal_id}`;
GRANT USE SCHEMA ON SCHEMA system.access TO `{service_principal_id}`;
GRANT SELECT ON TABLE system.access.workspaces_latest TO `{service_principal_id}`;

Step 5 : Copy the JDBC URL

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

image-20250508-071609.png

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

image-20250507-095701.png

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 and click connect

    • Account id

    • Client id

    • Client Secret

    • JDBC URL

      image-20250507-111948.png