Connecting Jedox to Databricks: A Beginner’s Guide
If you’re working with large datasets and advanced analytics, Databricks is a powerful platform that combines data engineering, machine learning, and analytics in one place. But what if you want to bring that data into Jedox for planning and reporting? In this guide, we’ll walk through the basics of connecting to Databricks via its REST API and pulling data into Jedox.
Step 1: Open Databricks and Understand the Structure
Start by logging into Databricks. Once inside, you’ll see the Catalog section on the left-hand side. Here’s what the main components mean:
Catalog: The top-level container for organizing data assets.
Workspace: Your environment where notebooks, jobs, and data live.
Database: A logical grouping of tables within a catalog.
Table: The actual dataset you query. In our example, the table is orders_2_drillthrough.
In the screenshot above, you can see:
Catalog: main
Workspace: default
Database: default
Table: orders_2_drillthrough
This table contains columns like Year, Month, Products, Customers, and Measures—perfect for analysis in Jedox.
Step 2: Generate a Bearer Token
To access Databricks programmatically, you need an authentication...