Dataiku
This guide walks you through connecting Dataiku to IOMETE using the Arrow Flight SQL JDBC driver.
Prerequisites
- A running IOMETE cluster with an active compute resource
- Access to the Dataiku Administration panel
- Your IOMETE username and personal access token
Download the JDBC Driver
IOMETE provides a custom release of the Arrow Flight SQL JDBC driver with additional support for HTTP CONNECT proxy tunneling, making it suitable for enterprise environments where outbound connections may be restricted.
Download the latest JAR from the iomete-artifacts GitHub repository. Artifacts follow the naming convention:
flight-sql-jdbc-driver-<upstream>-iomete.<release>.jar
For example: flight-sql-jdbc-driver-19.0.0-iomete.1.jar
The standard Apache Arrow Flight SQL JDBC driver is also compatible with IOMETE. The IOMETE custom driver is functionally identical to the upstream release — the only addition is native HTTP CONNECT proxy support. If you don't need proxy tunneling, either driver works.
See the Arrow Flight SQL JDBC Driver documentation for proxy configuration details, JDBC URL parameters, and download instructions.
Save the JAR file to a directory accessible by your Dataiku instance.
Configure the Connection in Dataiku
Step 1: Open the Administration Panel
Navigate to the Administration section from the Dataiku home screen.
Step 2: Access Connections
Select Connections from the left-hand menu.
Step 3: Create a New SQL Connection
Search for Other and select Other SQL databases.
Step 4: Configure the Connection
You will see the connection setup form:
Fill in the following settings:
| Field | Value |
|---|---|
| JDBC driver class | org.apache.arrow.driver.jdbc.ArrowFlightJdbcDriver |
| JDBC URL | Your IOMETE compute JDBC connection string (remove any embedded username/password) |
| Driver jars directory | Path to the directory containing the downloaded JAR file |
| SQL dialect | SparkSQL (via JDBC) |
| User | Your IOMETE username |
| Password | Your IOMETE personal access token |
| Can browse catalogs | ✓ Enabled |
You can find the JDBC connection string in the IOMETE console under your compute resource's connection details. Make sure to remove any user and password parameters from the URL, as these are configured separately.
Verify the Connection
After saving your configuration, use Dataiku's Test button to verify the connection. Once successful, you can start creating datasets and running queries against your IOMETE lakehouse.