In Oracle/Postgres it is possible to write a script that will run other scripts/files such as
compile_script.sql (contains)
@script1.sql
@script2.sql
@script3.sql
When you run compile_script.sql it runs all three of those scripts.
In snowSQL (command line tool for SnowFlake) you can run the sql in a file with a !source compile_script.sql but I am unable to determine how I can have that run other files as I can do in Oracle/Postgres.
How would I go about running all of or part of the scripts in a directory without having to run each of them by hand?
Asked by Joe W
(1058 rep)
Apr 17, 2023, 06:20 PM