​
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.
ToolData ImportLive ConnectionMetadata Sync
Power BISupportedSupportedSupported
ExcelSupportedSupportedSupported
TableauSupportedSupportedSupported
LookerN/ASupportedSupported
ThoughtSpotSupportedSupportedSupported
SigmaSupportedPreviewPreview
DomoSupportedPreviewN/A
Amazon QuickSightSupportedSupportedNot Supported
HexSupportedSupportedSupported
DeepnoteSupportedSupportedN/A
QlikSupportedNot SupportedPreview
MicroStrategySupportedNot SupportedNot Supported
SisenseSupportedNot SupportedNot Supported
HashboardSupportedNot supportedNot Supported
SteepSupportedNot SupportedNot Supported
Superset / PresetN/ASupportedPreview
MetabaseN/ASupportedPreview
LightdashN/ASupportedSupported
HolisticsN/ASupportedPreview
Mode AnalyticsN/ASupportedN/A
RedashN/ASupportedN/A
RetoolN/ASupportedN/A
Looker StudioN/APreviewN/A
SQL IDEsN/ASupportedN/A
RowZeroSupportedN/AN/A
JupyterSupportedN/AN/A
PythonSupportedN/AN/A
OtherDepends on tool applicabilityDepends on JDBC supportDepends 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.
ToolBuild DatasetsMetadata Sync
dbtSupportedBeta
AirflowSupportedN/A
PrefectSupportedN/A
DagsterSupportedN/A
OtherUsing Native Application API

​
Security

Honeydew does not process any data exchanged between a tool and Snowflake. Per-User API Keys: For organizations requiring granular user access and audit trail, Honeydew offers per-user API keys. This feature enables individual user identification at the Honeydew level and seamless integration with per-user Snowflake credentials. Per-user API keys are particularly valuable when:
  • Integrating BI tools while maintaining per-user separation, when the BI tool does not support user-level OAuth.
  • Using per-user Snowflake credentials (such as OAuth)
  • Requiring detailed audit trails of which user performed specific queries
See security for more details.