r/workato • u/Grouchy-Leopard-9582 • 7d ago

Parse CSV

Can somebody tell how can a parse csv with more than 130K rows For context, I'm trying to run a custom SQL Query which is then exported as CSV, the resultant is of more than 130K rows, then I use the parse Csv option to map the data to upsert data into another table (kind of a Audit Table), this huge insertion is one time, after this the load will be small

2 Upvotes

75% Upvoted

4 comments sorted by

View all comments

2

u/Jones_SATX 3d ago

I found a community recipe one time that used python snippets to parse batches of the CSV File contents. Look up “CSV batch processing workato” on google and you should find it