Before I dive into cursors and loops in Snowflake, I was wondering if maybe what I want to do could be done with configurations in DataGrip.
I have a script that:
1. Has a variable “table_name”
2. Then it runs a simple query with this $table_name on two different schemas
3. Keeps both outputs and then compares them
I would like to run this for about 60 different tables, and plus in the future, I would like to see if instead of two different schemas, I could run it on same schema but two different sources?