Skip to content
This repository has been archived by the owner on May 17, 2024. It is now read-only.

Numeric Precision does not work while comparing data between Oracle and Snowflake tables #883

Closed
RituSooraj opened this issue Apr 13, 2024 · 1 comment
Labels
bug Something isn't working triage

Comments

@RituSooraj
Copy link

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

#74

@RituSooraj RituSooraj added the bug Something isn't working label Apr 13, 2024
@glebmezh
Copy link
Contributor

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 [email protected] if you have any questions.

-Gleb

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Something isn't working triage
Projects
None yet
Development

No branches or pull requests

2 participants