Data Validation script in python

[Tulsi]

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

[Tulsi]

May someone please suggest if any better way to achieve this.