[Feature] Add support for composite entities #1770
Description
Is this your first time submitting a feature request?
- I have read the expectations for open source contributors
- I have searched the existing issues, and I could not find an existing issue for this feature
- I am requesting a straightforward extension of existing metricflow functionality, rather than a Big Idea better suited to a discussion
Describe the feature
Today users must define a concatenated string using solutions like dbt_utils.generate_surrogate_key to be able to use composite join keys.
However this is an anti pattern on Database indexes. This feature request is to consider extending support for composite entities in Semantic models.
Describe alternatives you've considered
Utilizing concatenated strings to create a single surrogate key instead of using composite keys.
Who will this benefit?
This will benefit all Metricflow users who wish to use it for Enterprise use cases.
Are you interested in contributing this feature?
Yes
Anything else?
No response