Convert a LookML repository to Honeydew semantics.
This section is about converting LookML to Honeydew.See Looker Integration on how to use Looker as a BI tool operating
on a Honeydew schema (whether it was migrated from LookML or not).
Dimensions are converted to table attributes (as part of their entity) or to Calculated Attributes -
depending on their expression
Dimension Groups are converted to multiple attributes
Metadata (such as descriptions and display names) are imported as part of the conversion
Measures and dimensions expressions that are using Snowflake SQL syntax are converted fully, including lineage and dependencies.
Measure aggregation types are converted to SQL aggregation functions.
Limitations:
Liquify templates are not converted
Looker Parameters and User attributes conversion is not automatic.
They can be manually converted to Parameters
Some Looker advanced functionality is not supported as-is (such as sql_where join filters) and
requires manual conversion.
Convert a Tableau data source to Honeydew semantics.
This section is about converting Tableau Data Source to Honeydew.See Tableau Integration on how to use Tableau as a BI tool operating
on a Honeydew schema (whether it was migrated from Tableau or not).
Convert a Power BI Semantic Model to Honeydew semantics.
This section is about converting a Power BI Semantic Model to Honeydew.See Power BI Integration on how to use Power BI as a BI tool operating
on a Honeydew schema (whether it was migrated from Power BI or not).
Table fields are converted to table attributes (as part of the entity)
Metadata (such as descriptions, folders and display names) is imported as part of the conversion
Limitations:
Calculated DAX columns and measures are copied without conversion to SQL, and require manual conversion.
Data source that resides in Fabric or is loaded to a Data Import, can’t be mapped
to the Snowflake source automatically and requires manual adjustment of Entity Source Tables.
Automatic conversion of DAX to calculated attributes and metrics is coming soon.
dbt can be both a source for Honeydew, and a target for Honeydew.To use Honeydew to generate dbt models,see dbt integration section.Also, see overview of a data pipeline for Honeydew and dbt interoperability.
Unlike conversion from BI (Tableau, Looker or Power BI), Honeydew does not replace dbt transformations,
but allows to add a semantic model on top of them.Honeydew dbt import tool processes the compiled dbt manifest (manifest.json) to extract metadata.
dbt tests are used to detect relationships and keys.
When mapping Snowflake tables in Honeydew UI, Honeydew automatically extracts relevant metadata if
defined, such as comments, primary keys or foreign keys.