Databricks
Overview
Connect Superblocks to Databricks to build apps with read and write access to a Databricks database:
Setting up Databricks
1. Add integration
Select Databricks from the integrations page.
2. Configure settings
Fill out the form with the following settings:
| Setting | Required | Description |
|---|---|---|
| Name | TRUE | Name that will be displayed to users when selecting this integration in Superblocks |
| Host | TRUE | Hostname or IP address to connect to |
| Port | TRUE | Port to use when connecting to Databricks |
| Path | TRUE | HTTP Path to use when connecting to Databricks |
| Access Token | TRUE | Access Token for the database |
| Default Catalog | FALSE | Catalog to be used when connecting to Databricks |
| Default Schema | FALSE | Schema to be used when connecting to Databricks |
3. Test and save
Click Test Connection to check that Superblocks can connect to the data source.
info
If using Superblocks Cloud, add these Superblocks IPs to your allowlist (not necessary for On-Premise-Agent).
After connecting successfully, click Create to save the integration.
4. Set profiles
Optionally, configure different profiles for separate development environments.
success
Databricks connected Now you can use Databricks in any Application, Workflow, or Scheduled Job.
Creating Databricks steps
Connect to your Databricks integration from Superblocks by creating steps in Application APIs, Workflows and Scheduled Jobs. You can configure a Superblocks Databricks integration with read only, read/write, or write only users. You can then configure a Superblocks Databricks step to read from a database, as well as modify/delete data. To get started, enter your SQL query into the text area of the Databricks step. Then click "Run" to see the Result and Executed SQL statement below.
info
See the basic CRUD guide for additional information in setting up a CRUD app
Troubleshooting
Check out our guide on common errors across database integrations. If you are encountering an error that you don't see in the guide, or the provided steps are insufficient to resolve the error, please contact us at help@superblocks.com.