dbt Semantic Layer updates and fixes for April 2024
The dbt Labs team continues to work on adding new features, fixing bugs, and increasing reliability for the dbt Semantic Layer and MetricFlow. This release note includes fixes, updates, and deprecations for in April 2024.
New features
Google Sheets
- Saved selections — You can save your query selections within the Google Sheets application. They can be made private or public and refresh upon loading.
- Display metric label — Metrics are now displayed by their labels as
metric_name.
Updates
- Metadata in metrics — Metrics now supports the
metaoption under the config property. Previously, we only supported the now deprecatedmetatag.
Google Sheets
- Explore saved queries — Added support to allow jumping off from or exploring MetricFlow-defined saved queries directly.
- Query dimensions — Added support to query dimensions without metrics. Previously, you needed a dimension.
- Time filters — Added support for time presets and complex time range filters such as "between", "after", and "before".
- Dimension value population — Added supported to automatically populate dimension values when you select a "where" filter, removing the need to manually type them. Previously, you needed to manually type the dimension values.
- Entity querying — Added support to directly query entities, expanding the flexibility of data requests.
- Exclude column headers — Added an option to exclude column headers, which is useful for populating templates with only the required data.
Deprecation
Tableau
METRICS_AND_DIMENSIONS— TheMETRICS_AND_DIMENSIONSdata source has been deprecated for all accounts not actively using it. We encourage users to transition to the "ALL" data source for future integrations.
0