Loss of precision/space postgresQL to Snowflake with JDBC Incremental Load component

Matillion ETL
1

I’m trying to use the JDBC Incremental Load component to load data from postgresQL to Snowflake. When I load numeric fields with decimal values, they come across as number(38,0) and it truncates the value. How do I make sure the values come across with their decimal values?

2

Hi Julie,

 

That's maybe one for tech support in case it's a known issue. Meanwhile, perhaps there's a workaround if you manually adjust the datatype of the Snowflake column in the target table?

 

Best regards,

Ian