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?

1 comment


Currently it's not possible to run script on all schemas automatically. 

Feel free to create feature request on YouTrack: https://youtrack.jetbrains.com/issues/DBE 


Please sign in to leave a comment.