Supported Tools
BI and Query Tools
Honeydew supports a variety of BI tools, both on-premise and cloud-based.
Two modes of operation are possible:
- Data Import: bring data from a dynamic dataset.
- Live Connection: live queries that use any metrics and dimensions in the semantic layer (running on Honeydew SQL interface).
Note not every tool has both functionalities. Tools marked with “N/A” below do not have the relevant functionality.
Tool | Data Import | Live Connection | Metadata Sync |
---|---|---|---|
Tableau | Supported | Supported | Supported |
Looker | N/A | Supported | Supported |
Power BI | Supported | Supported | Supported |
Excel | Supported | Supported | Supported |
ThoughtSpot | Supported | Supported | Preview |
Sigma | Supported | Preview | Preview |
Domo | Supported | Preview | N/A |
Amazon QuickSight | Supported | Supported | Not Supported |
Hex | Supported | Supported | Supported |
Qlik | Supported | Not Supported | Not Supported |
MicroStrategy | Supported | Not Supported | Not Supported |
Sisense | Supported | Not Supported | Not Supported |
Mode Analytics | N/A | Supported | N/A |
Superset / Preset | N/A | Supported | Preview |
Metabase | N/A | Supported | Preview |
Lightdash | N/A | Supported | Preview |
Redash | N/A | Supported | N/A |
Looker Studio | N/A | Preview | N/A |
SQL IDEs | N/A | Supported | N/A |
Other | Depends on tool applicability | Depends on JDBC support | Depends on client capabilities |
Live connection
Tools that have a live connection ability generate queries to run directly on the data warehouse.
Data import
Tools that have a data import ability typically include an in-memory database or a cube they can load data in for performance. They can import data from dynamic dataset using the native application, or by reading from a deployed table or a view.
Metadata Sync
Applicable to tools that support a live connection and can show metadata such as field descriptions or folders.
With Metadata Sync, Honeydew can synchronize centrally defined metadata into the tool.
Orchestration and Documentation Tools
Honeydew provides a query generator that can be integrated in data transformation orchestration such as Airflow or dbt Cloud.
If a data transformation step or model is based on a Honeydew Dynamic Dataset, then every data rebuild can use Honeydew to maintain the model consistency and leverage the capabilities of the semantic layer.
In addition, Honeydew provides metadata APIs that allow integration with catalog and documentation tools.
Integration can be based on the Honeydew SQL interface or the Honeydew Snowflake Native App.
Tool | Build Datasets | Metadata Sync |
---|---|---|
dbt | Supported | Beta |
Airflow | Supported | N/A |
Prefect | Supported | N/A |
Dagster | Supported | N/A |
Other | Using Native Application API |
Security
Honeydew does not process any data exchanged between a tool and Snowflake.
See security for more details.
Was this page helpful?