Share via

Connect Lovable to Databricks

Lovable is a no-code application platform that lets teams build and deploy apps without writing code. With the Azure Databricks integration, Lovable-hosted apps can query data stored in your Azure Databricks lakehouse using the Databricks REST API and OAuth machine-to-machine (M2M) authentication.

For example, you can build forecasting dashboards or reporting apps backed by lakehouse data.

Prerequisites

Before you configure the integration, you need the following:

  • A Databricks workspace. See Create a workspace.
  • A Databricks service principal with access to the workspace.
  • An OAuth secret for the service principal. Save the client ID and secret. The secret is shown only once.
  • An existing SQL warehouse in your workspace. The service principal must have access to the SQL warehouse.
  • A Lovable account.

Step 1: Get the Azure Databricks connection details

To connect from Lovable, you need the following values from your Azure Databricks workspace:

  • Workspace URL: The URL of your Azure Databricks workspace, such as https://dbc-1234567890123456.cloud.databricks.com. See Get identifiers for workspace objects.
  • Client ID: The application ID of your service principal. This is the same value as the client ID displayed when you generated the OAuth secret.
  • Client secret: The OAuth secret you generated for the service principal.

Step 2: Configure the connection in Lovable

To connect your Lovable app to Azure Databricks, see Connect your app to Databricks in the Lovable documentation.

Lovable stores these credentials as encrypted environment variables and passes them to your app at runtime.

Step 3: Query Azure Databricks data

After you configure the connection, create a Lovable app that queries Azure Databricks data. When you describe the app you want to build, the Lovable agent automatically discovers available SQL warehouses and uses the Databricks REST API to run SQL queries.

Additional resources

  • Last updated on