Numeric Precision does not work while comparing data between Oracle and Snowflake tables
RituSooraj opened this issue · 1 comments
I am using data_diff.diff_tables () (https://data-diff.readthedocs.io/en/latest/python-api.html) in order to compare the records between Source : Oracle and Target : Snowflake tables.
The code snippet is
record_diff = diff_tables(source,target,key_columns,extra_columns,update_columns, bisection_factor,min_update,threaded,bisection_threshold,max_threadpool_size)
for sign, columns in record_diff:
print(sign,columns)
The Oracle table has Column A as -0.19 , Column B as 0.00
and Snowflake table has Column A as -0.19 and Column B as 0.00
But the results are
-,[-0,0]
+,[0,0]
What changes should be brought in order to capture the precision between records in the 2 tables and display only rows that have differences ?
I am using Windows Machine and data-diff version v0.11.0
Hi @RituSooraj,
Thank you for trying out data-diff and for taking the time to open this issue. We made a hard decision to sunset the data-diff package and won't provide further development or support. Diffing functionality will continue to be available in Datafold Cloud. We have completely rewritten the diffing engine in the cloud over the past few months and have solved the fundamental issues with the original algorithm used in the data-diff package. Feel free to take it for a trial or contact us at support@datafold.com if you have any questions.
-Gleb