Any idea how to troubleshoot this error when runni...
# announcements
a
Any idea how to troubleshoot this error when running
meltano elt
?
decimal.InvalidOperation: [<class 'decimal.DivisionImpossible'>]
It happens when running tap-postgres, when querying a field with a numeric data type
with no precision or scale defined
I see a reference to this error at https://gitlab.com/meltano/target-snowflake/-/issues/23 but can't make sense of it
I got to the bottom of this. The source database is postgres and has a field that is of data type
numeric
without any precision or scale specified. The practice for targets is to validate each field, but without those items specified, there is a divide by null or something happening. So I see this as a problem in the tap
b
Hello, Experiencing this as well, any solution? Thank you!!
a
Brian, we ended up forking the tap