calogica/dbt-expectations

Test macro for numeric precision and scale

samousavih opened this issue · 1 comments

Is your feature request related to a problem? Please describe.
This package allows asserting column types by "expect_column_values_to_be_of_type". However, it doesn't include precision and scale when it comes to numeric types.

Describe the solution you'd like
Adding a new macro which can assert numeric types with precision and scale as parameters.

Describe alternatives you've considered
No alternative

Additional context
I have implemented this in my own project as I need to assert numeric types accurately.

The same should also exist for varchar sizes in order to test that a column size didn't accidentally shrink.