Set up a Databricks connector so Replit Agent can build data-driven applications backed by your Databricks workspace.
The Databricks connector is available exclusively on the Enterprise plan.
The Databricks connector lets Replit Agent query your Databricks workspace. Builders can create dashboards, reporting tools, and data applications using natural language. No SQL expertise required.Setup is a one-time process that involves a Databricks admin and a Replit organization admin. Once configured, builders with access can use the connector from Replit.This guide covers the full setup across three roles:
Databricks admin: creates the service principal and grants permissions in Databricks.
You must be a Databricks account admin or workspace admin to complete this step.
The Databricks admin creates a machine-to-machine identity, called a service principal, that Replit uses to connect to Databricks.
1
Open Settings
In Databricks, select your avatar in the top-right corner, then select Settings.
2
Select Identity and access
In the Settings sidebar, select Identity and access.
3
Manage service principals
Under Management and permissions, find Service principals and select Manage.
4
Add a new service principal
Select Add service principal, then select Add new.
5
Name the service principal
Enter a clear name for the service principal, then select Add.
6
Confirm the service principal details
After Databricks creates the service principal, confirm it is active. Keep this page open if you need the service principal details while configuring the Replit connector.
7
Grant access
Open the Permissions tab, select Grant access, choose the service principal, set the permission to Manage, then select Save.
The Replit connector needs Databricks SQL Warehouse connection details to route queries to the right compute resource.
1
Open SQL Warehouses
In the Databricks sidebar, select SQL Warehouses.
2
Select or create a warehouse
Select the SQL Warehouse you want Replit Agent to use. If you do not already have one, select Create SQL warehouse and create a new warehouse.
3
Copy connection details
Open the warehouse and select Connection details. Locate the Server hostname and HTTP path values. You need these values when creating the Databricks connector in Replit.
You must be a Replit organization admin to configure connectors.
The Replit admin adds the Databricks connection details to Replit so builders can use the connector.
1
Navigate to Integrations
From your organization home, open the Integrations page. Under Connectors, find Databricks (Service Principal) and select Sign in.
2
Confirm the connection
Replit shows a confirmation dialog before redirecting to Databricks for authentication. Review the details and select Continue to Databricks.
3
Enter the SQL Warehouse HTTP path
Paste the HTTP path from your Databricks SQL Warehouse connection details (for example, /sql/1.0/warehouses/abcdef1234567890), then select Next.
4
Enter the SQL Warehouse server hostname
Paste the Server hostname from the same connection details (for example, abc-12345678-wxyz.cloud.databricks.com), then select Continue to Databricks to complete authentication.
5
Configure access
Use Role-Based Access Control to choose which members or groups in your organization can use this connector.
6
Verify the connector is active
Back on the Integrations page, confirm that Databricks (Service Principal) appears under Connectors with an Active connection status.
After connecting, builders can create applications that use Databricks data with Agent.
1
Start a project
From your Replit home, open the prompt box to start a new project.
2
Select the Databricks App template
Open the Templates dropdown and choose Databricks App under Org templates. The prompt is prefilled with instructions that tell Agent how to use your Databricks connector.
Add your own prompt after the prefilled instructions to describe what you want to build. For inspiration, browse the Databricks Dev Hub templates.
3
Review and iterate
Review the SQL Agent generates, the tables it queries, and the application structure. Iterate by asking for changes in natural language.
Authentication fails after creating the service principal
Verify that the service principal details entered in Replit match the service principal created in Databricks. If credentials were rotated, update the connector in Replit.
Agent can see schemas but queries return empty results
The service principal may have metadata access but no read permission on the data. Grant the required table, schema, or catalog permissions in Databricks and try again.
The connector cannot reach the SQL Warehouse
Verify the Server hostname and HTTP path values match the SQL Warehouse connection details in Databricks.