I want to be able to run out of two gmail inboxes as a service user. Authentication happens in the resource itself and is used for all users of the platform. In a script can I specify the resource of the query or do I have to do create multiple queries and if/else their execution?

Hi @mslade ! Thanks for reaching out. The functionality that @MiguelOrtiz suggested above should now be enabled for all Cloud organizations. :slightly_smiling_face: [image]

Dynamic Resource for Query

💬 Queries and Resources

MiguelOrtiz September 12, 2024, 4:11am 2

Hey @mslade,

You may want to check out (and request to the Reotol team) this beta functionality which introduces a new fx toggle next to the resource in a query.

Hope this helps!

Topic		Replies	Views
Pass Resource as a Parameter 💬 Queries and Resources resource-connection , sql	4	504	July 4, 2024
Use one resource query but have it connect to different DB depending on select box (mssql) 💬 Feature Requests mssql	3	1866	March 10, 2023
How to dynamically set resource Id from JS? 💬 Queries and Resources javascript , queries	6	53	February 25, 2025
Best way to dynamically set query datasource and trigger query 💬 App Building	11	1567	July 11, 2024
Running the same SQL against different hosts/databases: can Resource be parameterized in a query? 💬 Queries and Resources	11	1383	August 3, 2023

Dynamic Resource for Query

Related topics