Possibly related to the above post.. Meltano Lab's...
# troubleshooting
j
Possibly related to the above post.. Meltano Lab's
target-snowflake
is not creating the table with proper NUMBER precision. For example, `--dump=catalog`'s one of the fields in stream are
Copy code
"AMT_EXCL_TAX": {
                "multipleOf": 0.0001,
                "type": [
                    "null",
                    "number"
                ]
            },
but in snowflake it is created as
Copy code
AMT_EXCL_TAX NUMBER(38,0)
while the correct field would be
Copy code
AMT_EXCL_TAX NUMBER(34, 4)
😞 Any ideas if this and https://meltano.slack.com/archives/C01TCRBBJD7/p1688918685352879 are related?
v
Quick of it is Decimals aren't handled very well with the SDK targets right now. There's a few options to fix this but that's the short of it we should definietly get an issue in for this and fix it