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
TableauSupportedSupportedSupported
LookerN/ASupportedSupported
Power BISupportedSupportedSupported
ExcelSupportedSupportedSupported
ThoughtSpotSupportedSupportedPreview
SigmaSupportedPreviewPreview
DomoSupportedPreviewN/A
Amazon QuickSightSupportedSupportedNot Supported
HexSupportedSupportedSupported
QlikSupportedNot SupportedNot Supported
MicroStrategySupportedNot SupportedNot Supported
SisenseSupportedNot SupportedNot Supported
Mode AnalyticsN/ASupportedN/A
Superset / PresetN/ASupportedPreview
MetabaseN/ASupportedPreview
LightdashN/ASupportedPreview
RedashN/ASupportedN/A
Looker StudioN/APreviewN/A
SQL IDEsN/ASupportedN/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.

See security for more details.