Databricks

UI Bakery allows you to easily connect to a Databricks SQL database with no need for additional layers (APIs or 3rd-party services).

Prerequisites

If your database is hosted behind a Firewall, add the following IP address to the Firewall whitelist:

52.176.109.125

Configuration

Go to the Data sources page –> Connect –> Choose Databricks. Enter your credentials and click Test connection.

If the connection is successful, click Connect Data source. 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 an action, you can enable the setting Allow override catalog name in action:

Once enabled, when configuring the action, you will be able to specify the custom database:

In case a database is not specified, the default data source database will be used.

Usage

Once you have the connection between UI Bakery and Databricks, you can access its data, i.e. load and send it back. The below action types are supported:

SQL query

Last updated