How to add dynamic values to query in workflows

[Bose_28]

Hi ,
I have a query block on loop, that has to execute the below snowflake statement.
execute immediate $$ declare rs RESULTSET; query varchar default 'SELECT * FROM '; final varchar; tableName STRING := {{ code2.data[0] }}; begin final := 'SELECT * FROM ' || tableName || ';'; rs:= (execute immediate :final); return table(rs); end; $$;

The table name is in code2.data. I would like to loop over the tableNames and execute the query.

But I'm recieving [null] as output.
The logs say "Invalid identifier '1'". Error at line 6 position 21.

Can someone help me solve this.

[jg80]

I think you would need to disable prepared statements for the resource. There is some discussion on this in the below link (though for apps, I would guess it works for workflows too). Buyer beware in regards to opening up the danger of SQL injection in doing so.

Replace table names with a temporary variable value

I have many queries on the retool and all query runs a BigQuery SQL and returns data. These all queries contains a single table name, but when I wanted to change a table name I have to do this in all queries which is a bit repetitive process. Is there any way when I have put my table name in a temporary variable and put that variable at place of table names in SQL?

One other thought would be a branch in the code that is used to direct toward one table or another. This would get exceedingly complicated and difficult to maintain if the number of possible tables is large (more than two, IMO ).