Partition comparison between source and target (mysql and snowflake)

Issue

This Content is from Stack Overflow. Question asked by Alia

I have to do partition comparison between source and target. Source will be MySql, Teradata and target will be snowflake, GCP. I am not sure from where to start. Please suggest what all steps are required for partition check. i am doing comparison in python.

Example- In mysql we have table A and in snowflake we have same table A. Now we need to do partition check. partition column is same or not ,number of partition.

please suggest what all checks we can do for partition and how.



Solution

This question is not yet answered, be the first one who answer using the comment. Later the confirmed answer will be published as the solution.

This Question and Answer are collected from stackoverflow and tested by JTuto community, is licensed under the terms of CC BY-SA 2.5. - CC BY-SA 3.0. - CC BY-SA 4.0.

people found this article helpful. What about you?