Retrieve data from other tables with query loop

[Patric]

Hi

yes, it is possible, but you have to code the database access / retrieve yourself.

See this:

Custom SQL (external database) for Query Loop

Is there a way to query an external database and stick the results in a variable, or something, that can then be used in a query loop? Example: I have a need to create employee lists by department. The data is coming from an external database (Google BigQuery). What I would like to do is embed the SQL in a code block, have it save the results to a variable, or JSON, or whatever, and then output the results through a query loop.

Cheers

Patric