• Complicated user defined metric filters get compiled down to the protocol definition of WhereFilters
Context
We realized recently that filters were basically unconstrained highly structured objects within the semantic layer protocols defined in dbt-semantic-interfaces. We're currently racing to resolve this issue in DSI as defined in DSI#102. We're well on our way to resolving DSI#102 and have a draft PR. In this we define a generic WhereFilterCompiler. which can compile a user specified filter down to a WhereFilter protocol implementation. Once this is merged and released (soon 🤞), we should instantiate a WhereFilterCompiler in the MetricParser and compile the filters at that time.
Instead of going the DSI#102 route, we ended up going the DSI#109 route for ensuring filter structure changes in the protocol. Additionally we began supporting the change of DSI#109 in #8085. So this can be considered done 🙂
QMalcolm
commented
1 year ago
Acceptance Criteria
• Complicated user defined metric filters get compiled down to the protocol definition of
WhereFiltersContext
We realized recently that filters were basically unconstrained highly structured objects within the semantic layer protocols defined in dbt-semantic-interfaces. We're currently racing to resolve this issue in DSI as defined in DSI#102. We're well on our way to resolving DSI#102 and have a draft PR. In this we define a generic WhereFilterCompiler. which can compile a user specified
filterdown to aWhereFilterprotocol implementation. Once this is merged and released (soon 🤞), we should instantiate aWhereFilterCompilerin the MetricParser and compile the filters at that time.