We’re closing down our application and archiving our databases, therefore won’t be using redash anymore. I want to keep a copy of all the queries we used operationally incase we need to spin up a db for audit etc in the future.

Is there a way to download all the SQL queries? (not the output, the query itself)

Yes of course. This is one of the example scripts built into redash-toolbelt: redash-toolbelt/query_export.py at master · getredash/redash-toolbelt · GitHub

If you already have Python 3 on your system this shouldn’t take more than a few minutes to complete.