Hi, so i'm noticing a python decimal precision err...
# troubleshooting
m
Hi, so i'm noticing a python decimal precision error on the
target-snowflake
i have a source that's 1e-18
DECIMAL
(mysql) and the validation step is failing on the
target-snowflake
. To validate, or not validate? i have a simple fix that ignores anything above 1e-10. thoughts? seems a python issue, not a per se tap/target issue
main issue here i don't want to turn off validate for every table
e
What's the error message for the validation failure?
m
it's failing here
failed = instance % dB
at
multipleOf
e
i have a simple fix that ignores anything above 1e-10. thoughts? seems a python issue, not a per se tap/target issue
well, what does the fix look like? 😅 If there's something we can do in the SDK, by all means log a bug (or a feature request).
m
arg. it's not a good fix. wither way here is an example
-595754541689989.897787660000000000
decimal(36,18) -> results in failure
👀 1