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?
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 screenshot of your scenario along with the relevant module configurations and share the images here so that the community can help.
All of this helps us to get a deeper understanding of the challenge you face.
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.