Skip to Content
0
May 27, 2020 at 02:54 PM

Is there a way to run a loop through the output of SQL transformation?

169 Views

I have run the following in SQL transform in Data Services

select stag_table from op_schem.dataset where tx=23

This gave me 40 tables. Is there a way, I can do a "select * from" on each of these 40 tables and load them into flat files?