[X] I have searched the existing issues, and I could not find an existing issue for this feature
[X] I am requesting a straightforward change to existing dbt-semantic-interfaces functionality, rather than a Big Idea better suited to a discussion
Describe the feature
Enable sub-daily TimeGranularity options.
In order to support metrics that require time spine joins, will need to add support for sub-daily time spines. These can be very inefficient for queries that don't require that small of granularity, so we will also enable support for multiple time spines. This will allow us to choose the best time spine available to build an efficient query.
Is this your first time submitting a feature request?
Describe the feature
Enable sub-daily
TimeGranularity
options. In order to support metrics that require time spine joins, will need to add support for sub-daily time spines. These can be very inefficient for queries that don't require that small of granularity, so we will also enable support for multiple time spines. This will allow us to choose the best time spine available to build an efficient query.Describe alternatives you've considered
No response
Who will this benefit?
No response
Are you interested in contributing this feature?
No response
Anything else?
No response