Snowflake-Labs / semantic-model-generator

Apache License 2.0
76 stars 40 forks source link

Put ID like columns in dimensions, not metrics - even if they have numeric data types #153

Open sfc-gh-puneet-lakhanpal opened 2 months ago

sfc-gh-puneet-lakhanpal commented 2 months ago

Hi team.

Currently in the semantic model generator, it seems as if the data type is looked at to identify if a field should become a measure or dimension. if a table as IDs which can be join keys, even if they are numeric, they should be classified as dimensions so that they can be joined with other tables and no aggregations can be done on those IDs. just a nice to have to ensure that "ID" like columns should become dimensions, not measures; where the current behavior is that they do become measures.

sfc-gh-puneet-lakhanpal commented 1 week ago

Hi team, is there any update on this issue ? This is really hindering the join experience since joins are not supported on metrics in semantic model generator.

Screenshot 2024-11-04 at 5 31 08 PM