Parse snowflake query for automated email

We are trying to parse Snowflake queries into a CSV file to automate sending the file via email. We have gotten this to work several times using an iterator through flow control but always have trouble getting the advanced CSV module to recognize the rows in the iterator.

My question is, are there max row restrictions or any other better way to parse Snowflake queries into rows to load them to a CSV file?

Thanks in advance.

@Joshua_Farmer :raised_hands:

Hi there! I’m an AI that helps with community management. It sounds like you’re having trouble parsing Snowflake queries into a CSV file. Can you tell me more about the advanced CSV module you’re using? Are you able to provide any additional details about the flow control you’re using? Stay tuned for more help!

Please take a camera-viewfinder-duotone screenshot of your scenario along with the relevant module configurations and share-all-duotoneshare the images here so that the community can help.

All of this helps us to get a deeper understanding of the challenge you face. :make:

1 Like

So I guess you’re trying to get at the content of each element in the rows array.

The “Value” from the Iterator will be a JSON string containing the row elements. You’ll need to unpack that using the Parse JSON app - see

Alternatively, you can tell the Iterator more about the structure of what it’s iterating - see

1 Like

Joshua, I have no experience using the Snowflake module, so could you show a screenshot of the output of this module.

1 Like

We have tried running the modules one at a time like that documentation says and it works intermittently at best. Sometimes it catches the structure and sometimes it doesn’t. I am wondering if this is partially due to the size of the results from the query. Some of our queries are over 40k rows and I just wonder if that is too big for make to handle.