[SEMANTIC-86] [Feature] Add databricks support for dbt_metrics
Closed this issue · 1 comments
callum-mcdata commented
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 dbt functionality, rather than a Big Idea better suited to a discussion
Describe the feature
Right now dbt_metrics supports Postgres, Redshift, Bigquery, and Snowflake. This is a great subset of the ecosystem but Databricks is a growing adapter base and we should support their needs for metrics!
Describe alternatives you've considered
None
Who will this benefit?
Anyone who is using the dbt-databricks adapter
Are you interested in contributing this feature?
Yea!
Anything else?
No response
callum-mcdata commented
Coalesce & Strings - Databricks supporting odd behavior
coalesce(metric_value,0)
where metric_value is a the max of a string seems to work in databricks while it fails in all other platforms. Databricks seems to support default behavior or casting the numbers to string values. So we'll need to have alternative validation built into databricks to ensure that the underlying column is not a string. We can't use introspective queries to do this - should we cast as number in some component to ensure it is represented correctly?