Meltano

I'm getting this error `jsonschema.exceptions.ValidationError: Decimal('-0.0033000000000000004') is not a multiple of 1E-17` when trying to run tap-mssql target-snowflake. What is causing this? Do float type numbers just cause issues like this?

this is a json schema validation problem, definitely fixable but it's most likely a target issue. There's some things you have to add to get decimals to work properly when they have high precision

One fix is to turn off json schema validation on the target most targets support this

<https://github.com/meltano/target-postgres/blob/8c792d87b8a28205e82deb607e84f45781fdb886/target_postgres/__init__.py#L36-L68>

We did it in postgres here Datateer published something more general here <https://github.com/Datateer/adjust-precision-for-schema>

On a target I wrote I just set decimal.getcontext().prec = precision to a very large number and haven't hit an issue since :shrug:

Hmm so how could I do that on a pre-written target?

```Validate Records (validate_records)

Environment variable: TARGET_SNOWFLAKE_VALIDATE_RECORDS
Default Value: false
Validate every single record message to the corresponding JSON schema. This option is disabled by default and invalid RECORD messages will fail only at load time by Snowflake. Enabling this option will detect invalid records earlier but could cause performance degradation.```
I see that for the transferwise variant there's this setting. Is this what I'm looking for? I'm currently using the default snowflake target

this would be a good test case to add to the sdk (validate target can handle high precision decimals)

<@U06CCB0EUBC> Setting 'validate records: false' worked by the way thank you