Skip to content

v1.17.0

Choose a tag to compare

@marcociav-exmergo marcociav-exmergo released this 01 Nov 01:27
· 156 commits to main since this release
b4e56e3

Semantics Everywhere

Dex 1.17.0 is here, and so is "Semantics Everywhere".
This release gives your agent more of the context it needs
to work on your data: what your models mean, how to use them, and how to check
that their results match your intent.
This builds on the declarations work shipped in 1.16.x.

Declarations define a model’s grain, population, relationships, and
aggregation rules. Dex turns them into dbt metadata and tests, and proposes
matching definitions for MetricFlow, Apache Ossie, SLayer, or Cube.

In 1.17.0, your agent can also read declarations back from Ossie, SLayer, and
Cube while exploring, even without a dbt project. That means it can pick up the
rules you've already recorded and check them against the data in a later
session. You can keep the semantic layer you use; Dex reports any parts of a
declaration it cannot represent there.

We've also added refactor comparison so you can check whether a SQL rewrite
changed its results, full refreshes for incremental models, and clearer docs
to help you get started. The details are below.

What's Changed

Downstream-visible changes

  • Native semantic layers return their grain and declarations to explore profile|map --use-project, including composite primary keys and metadata readback without a dbt project, by @marcociav-exmergo in #999
  • transform compare checks whether a planned refactor preserves output names, types, and the exact row multiset, including duplicates and NULLs, across all eight warehouse connectors. It reports not_checked when an exact comparison is unavailable; equivalence holds for the compared inputs. By @marcociav-exmergo in #1019
  • dex procedure publishes the engine's agent procedure, with a paste-ready block and a stale-copy check for CI; a new metadata-quality evaluation measures declared intent against the built result, by @marcociav-exmergo in #1016
  • Verification lowers the severity of a fan-out when the declared grain is proven unique, and explore profile --target dev lets declarations be drafted from dev-only builds without widening the source allowlist, by @marcociav-exmergo in #991
  • Jinja control-flow models validate through fresh dbt compilation with governed compile-time queries. Population prose follows its withholding policy, and declaration checks handle narrower grains and literal filters in join conditions more accurately. By @marcociav-exmergo in #1001
  • transform build --full-refresh rebuilds selected incremental models on dev with full-rebuild pricing and refresh evidence. Builds isolate dbt artifacts by default, readers follow the current artifacts, and results from another invocation cannot count as a successful build. The change also fixes BigQuery control-flow planning and isolates mutation and comparison runs from inherited DBT_ENGINE_* settings. By @marcociav-exmergo in #1023

Bug fixes

  • The local dbt semantic catalog omits Dex-generated population text from descriptions and search matching, screening existing compiled artifacts without a rebuild. Authored descriptions are preserved where identifiable; the hosted dbt Cloud catalog is unchanged. By @costajohnt in #1017
  • Reconciliation advice names the configured Ossie, SLayer, or Cube authoring command for dangling references by @MbappeWU in #979
  • Semantic queries disclose sub-threshold PII flags on grouped or filtered dimensions by @MbappeWU in #980
  • Named, literal-only VALUES lists are accepted as SQL sources so row attribution can measure models that use them by @costajohnt in #954
  • Drafted grain evidence says “carried through unchanged” once across CTE hops by @MbappeWU in #993
  • transform plan accepts leading inline config() headers when SQL follows on the same line by @DewellNaa in #1011

Documentation

  • A guided local quickstart, installation and connection setup, task-based workflows, and troubleshooting replace the jump straight into dense reference material. CLI pages have command indexes and expandable usage and options; existing documentation URLs are preserved. By @marcociav-exmergo in #1023

Removed

  • Removed the unimplemented dex viz preview command from the CLI, skills, and current documentation by @marcociav-exmergo in #1023

New Contributors

Full Changelog: v1.16.6...v1.17.0