topic BigQuery->SQL->Dump to CSV in Workato Pros Discussion Board

BigQuery->SQL->Dump to CSV

tstack — Wed, 23 Mar 2022 01:46:49 GMT

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.

Re: BigQuery->SQL->Dump to CSV

pam — Wed, 23 Mar 2022 01:57:48 GMT

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

Re: BigQuery->SQL->Dump to CSV

tstack — Wed, 23 Mar 2022 04:07:21 GMT

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.

Re: BigQuery->SQL->Dump to CSV

levajar — Wed, 12 Apr 2023 13:02:48 GMT

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