# Databricks

UI Bakery allows you to easily connect to a Databricks SQL database with no need for additional layers like APIs or third-party services.

## Configuration

### Prerequisites

If your database is hosted behind a Firewall, you need to add our [IP addresses](https://docs.uibakery.io/concepts/data-sources#whitelisting-ip-addresses) to the Firewall whitelist.

### Connecting the data source

Now, to connect your data source, follow the steps below:

1. On the **Data sources** page, click **Connect**, and select *Databricks* in the Data sources list.
2. Specify all the required credentials and click **Test connection**.
3. Once the connection is verified, click **Connect Datasource** to complete the setup.

<figure><img src="https://837703843-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUX6zPRMFFK0yrTghj7cY%2Fuploads%2Fq3n777FvdRhOVSghSLDZ%2FCleanShot%202025-04-14%20at%2012.04.41%402x-min.png?alt=media&#x26;token=cbdc1483-b319-4408-9236-c17f2c0133ec" alt=""><figcaption></figcaption></figure>

UI Bakery will extract the database structure and store column types. This data will be used to suggest the proper [table columns and form field types](https://docs.uibakery.io/concepts/components/work-with-components/field-types-and-types-recognition).

If you need to be able to override the default data source catalog with a custom value in the action, you can enable the **Allow override catalog name in action** setting in the *Data source connection* windo&#x77;**.** \
Once enabled, you will be able to specify a custom database when configuring an action. In case a database is not specified, the default data source database will be used.

<figure><img src="https://837703843-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUX6zPRMFFK0yrTghj7cY%2Fuploads%2F0kDYDd3TSHbUWgQNQf5D%2Fspaces_UX6zPRMFFK0yrTghj7cY_uploads_git-blob-8518a70097861ec746bd4af896dabbe1826ef4b6_Screenshot%202024-05-29%20at%2013.56.48-min.png?alt=media&#x26;token=1daf9a84-4af3-4d2a-ada4-fc469504bcb0" alt=""><figcaption></figcaption></figure>

## Usage

Once you have established the connection between UI Bakery and Databricks, you can access its data - load it and send it back.&#x20;

UI Bakery supports the [SQL Query](https://docs.uibakery.io/reference/working-with-actions/sql-query) action step for this data source.