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

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.

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

Usage

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

UI Bakery supports the SQL Query action step for this data source.