Executing the same script on two schemas with multiple tables

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?