When I'm trying to insert around 10K rows from retool to the BQ, I'm getting this error.
Is retool is not able to handle large sets of rows? Because this much rows are in our use cases.
Or there is another way to insert large sets of data?
For that error (thank you for sending!), it seems like multiple queries would be best.
https://cloud.google.com/bigquery/docs/troubleshoot-queries#not_enough_resources_for_query_planning_-_too_many_subqueries_or_query_is_too_complex
Would something like this help?
http://community.retool.com/t/how-to-run-a-large-array-of-queries-in-smaller-batches/3170
1 Like