cancel
Showing results for 
Search instead for 
Did you mean: 

BigQuery->SQL->Dump to CSV

tstack
Deputy Chef I
Deputy Chef I

Hello Out there, I've been trying to create a CSV file from a Custom Select Qurery Action in Big Query. I am using variables to create a List to repeat through and update a final list to dump into csv. I've used variables previously succesfully, but with using the Custom Sql for BQ, my initial list is not ever populated.

Any advice or help would be great.

Thank you.



3 REPLIES 3

pam
Deputy Chef I
Deputy Chef I

Tracy - I believe step 6 should actually be FOR EACH item in...the list from step 2, not the variable list from step 3. Without seeing what's in step 9 - I assume you're using These_are_the_updates list as the Source


tstack
Deputy Chef I
Deputy Chef I

Thanks for the response Pam. I had tried that as well. What I am seeing is that due to the nature of the Big Query Response, the rows are not in a array. It looks like I may need to add a step to parse the response so I can use the data pills.

Did you tried in debug/trace option for each step if records are coming across within the Recipe ?