mitch-zink/snowflake-table-comparison — reverse-engineered prompt

Build me a simple Streamlit app that helps me compare two Snowflake tables and quickly see what is different between them.

I want to connect to Snowflake, pick two tables, and get a clear comparison across a few views. Show row by row differences and matches, including summary counts. Show column differences too, like missing columns or datatype mismatches. Add aggregate checks for things like counts, sums, and distinct values on shared columns. I also want a schema level view that compares row counts for tables across two schemas, and a date based view that compares unique key counts by month and year so gaps in time are easy to spot.

Make the UI easy to use and visual, with tables and clear flags for matches and mismatches. It should run locally with straightforward setup in Python. If the Snowflake login flow has issues in a hosted environment, prioritize making it work well locally first. Look up current docs online if you need to.