use dbt-snowflake>=1.5.0 create a model in your project: #in my_model.sqlselectcast(1asnumeric)as_numeric, cast(1asinteger)as_integer, cast(1asdecimal)as_decimal rundbt show -s my_model --output JSON get this! ❯ dbt show -s my_model --output json 20:33:15 Running with dbt...
If the precision in the value overflows the precision defined in the datatype declaration, null is returned instead of the fractional decimal value. Solution Setspark.sql.ansi.enabledtotruein your cluster'sSpark config(AWS|Azure|GCP).