tuva-health/tuva

Bill Type Code not being formatted in Normalized Input Layer

Closed this issue · 0 comments

Describe the bug - Required
A clear and concise description of what the bug is.

Bill type code is being NULL'd when there are leading zeros as part of the code (e.g. 0111). The normalized input layer should be stripping out these zeros.

Environment - Required

  • Tuva project package version (e.g. 0.6.0): 0.8.0
  • dbt version (e.g. 1.7): 1.5
  • dbt type (e.g. dbt cloud or dbt CLI): CLI
  • Data warehouse (e.g. Snowflake): Snowflake

To Reproduce
Steps to reproduce the behavior:

  1. Go to '...'
  2. Click on '....'
  3. Scroll down to '....'
  4. See error

Expected behavior
A clear and concise description of what you expected to happen.
Bill type codes are cleaned up in the tuva project when issues are minor like leading zeros.

Screenshots
If applicable, add screenshots to help explain your problem.

Additional context
Add any other context about the problem here.