Skip to main content

Connecting Redash to IOMETE

Redash is an open-source business intelligence platform for data visualization and collaboration. It connects to various data sources, lets you write queries, and share dashboards with your team.

This guide walks you through connecting Redash to your IOMETE compute cluster.

Adding IOMETE as a Data Source​

  1. Click the Settings icon, then click New Data Source.
Redash data sources page with New Data Source button | IOMETERedash data sources page with New Data Source button | IOMETE
  1. Select Apache Spark SQL (or Databricks) from the list of available data sources.
Choosing a data source type in Redash | IOMETEChoosing a data source type in Redash | IOMETE
  1. Fill in the connection fields using the values from your IOMETE compute cluster connection details.
Redash data source configuration form | IOMETERedash data source configuration form | IOMETE
PropertyValue
Host{domain or IP address}
Port{server port}
HTTP Path/data-plane/{namespace}/lakehouse/{compute_cluster_name}
Username (User ID){your user name}
Password{personal access token}
Database{database name}
HTTP Schemehttp/https

You can find these values on the compute cluster details page in the IOMETE console:

IOMETE compute cluster connection details | IOMETEIOMETE compute cluster connection details | IOMETE
  1. Click Test Connection to verify the connection.
Successful connection test in Redash | IOMETESuccessful connection test in Redash | IOMETE

Running Your First Query​

Once connected, navigate to Queries in the navbar. Select your IOMETE data source from the dropdown, write a query in the editor, and click Execute.

Query results displayed in Redash | IOMETEQuery results displayed in Redash | IOMETE

ON THIS PAGE