+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Data Validation script in python (/thread-11595.html)
Data Validation script in python - Tulsi - Jul-17-2018
Hello Techie,
may someone please help me how to do Data validation automation using Python.
my source is SQL SERVER and Target is SNOWFLAKE. i am using informatica to load data from source (sql)
to target snowflake.
may someone if possible kindly share their expertise, how to approach for python way.
Thanks a lot
My Idea is to pass date as parameter to compare source and target count.
Will it be something like this.
1. Established connection with snowflake.
2. Established Connection with Source
Two Parameter : Lastmodified Parameter or CreatedDatetime: Supply value for these 2 parameter.
Based on the Parameter value total record count will fetch and store in array[x] for Source And ARRAY [Y]
For target.
Compare the 2 and saved the result in table in sql with column, parameter and Count Diff of src and target.
The challenge here is how to connect to snowflake and sql.
May someone please share their expertise with some other way.
Thanks
RE: Data Validation script in python - Tulsi - Jul-17-2018
May someone please suggest if any better way to achieve this.