Aggregate Awareness in Semantic Layer

In-Depth Discussions
1

It would be great if dbt had some way of supporting Aggregate Awareness. i.e. if there is a model in day level, and an aggregate model in week level, depending on whether the query is in day, week, or month level, if dbt semantic layer could automatically pick the right table, it can significantly improve performance.