Project Manager Add Saved SQL Collection

I use Project Manager for organization and launching automation designer apps and scripts. I can't wrap my head around Saved SQL Collections and Saved SQL under "Add".

Can someone tell me what this is used for and a simple example. thanks in advance.

John

Hey John,

It's a way to conveniently access your Named (Saved) SQL and execute your code. See snap below. The list shown are the SQL statements and scripts that I have saved in my Named SQL Recall panel.

Thanks you Gary. That's better than loading in editor and running it.

In case you're wondering why, in the project tab (not the Connections tab pictured), Add -> Saved SQL [Collection] and many more are disabled, that's probably because you're trying to add directly in a schema. You can only add Saved SQL in a project or subproject.

I have no idea how subprojects works and which makes more sense.