Databricks
Databricks connection helps you connect to a Databricks SQL warehouse and run queries directly from Infoveave.
Adding a Databricks Connection
To create a new Databricks connection:
- Go to the Database section.
- Select Databricks from the available connectors.
- Fill in the required connection details in the New Databricks Connection form.
Connection Parameters
When setting up a Databricks connection, you need to provide the following details:
| Field | Description |
|---|---|
| Name | A unique name to identify your connection. |
| Port | Port number for Databricks (default is 443). |
| Server | The Databricks SQL warehouse server endpoint. |
| Username | Your Databricks username. |
| Password | The corresponding password or personal access token. |
| Database | The Databricks database you want to connect to. |
| Schema | The schema inside the database to be used (optional). |
| Fetch from external links | Toggle option to enable fetching data from external links (optional). |
Steps to Validate and Save
- After filling in the details, click Validate to verify the connection.
- If validation succeeds, click Save to store the connection.
- You can now use Databricks as a datasource in your Infoveave workspace.
Example Use Case
With a Databricks connection configured, you can:
- Run queries on large-scale data stored in Databricks.
- Use Databricks SQL warehouse for fast analytics and data exploration.
- Integrate Databricks datasets into Infoveave Infoboards for dashboards, reports, and insights.