Databricks

The Databricks Lakehouse Platform provides a unified set of tools for building, deploying, sharing, and maintaining enterprise-grade data solutions at scale.

Databricks integrates with cloud storage and security in your cloud account, and manages and deploys cloud infrastructure on your behalf. Datagrid users can continuously pull data from Databricks.

With the Databricks connector, Datagrid users can:

Read and ingest from Databricks and transform data into interactive insights.
Clean, process, and enrich raw data into business-ready format.
Create automations to ingest, run flows, or export data from Databricks on a schedule.
Perform data engineering tasks on ingested data including processing, cleaning, enriching, and transforming data into insights.

Configuration guide

There are two primary ways to establish a Databricks connector in Datagrid. Databricks SQL connection or Databricks volumes

Databricks SQL

This connection support Personal Access Tokens

or Service Principal

Databricks Volumes

Similarly Databricks Volumes supports both PAT and Service Principal

Requirements:

Datagrid Subscription
Databricks Subscription
Web Browser (Safari, Chrome, Edge, Firefox)

Data Access

API	Supported	Notes
REST API

Don't see endpoints you are looking for? We're always happy to make new endpoints available. Request an endpoint here!

Integration Capabilities Supported by the Connector

Toric ingest and writes data to Databricks via the RESET API. The Databricks connector supports source, destination, and storage capabilities in Toric.

Configure Databricks Connector | Toric

Step by step set up for connecting Microsoft SQL to Toric

www.toric.com

Transforming Raw Data into Insights: Toric's Data Staging Capabilities Explained | Toric

Discover how Toric's data staging options enable data analysts to easily transform raw data into structured and optimized formats for seamless querying and analysis.