I have a fairly large query (19k rows) that used to run successfully but is now returning with "exception: the coordinates or dimensions of the range are invalid". The query runs fine inside of skyvia and I am able to do a full download to csv from here so it seems to be only inside of google-sheets. I deleted the sheet and created a clean/blank sheet with the same results.
I'd try accessing the query through the "Gallery" and then running it through the "edit" sql function. I've had problems for weeks now and was able to hack my way around it by going through those steps rather than "refresh sheet".
I can't even do that anymore. The Google Sheet functionality is broken from what they tell me and will take time to repair.
Agree - even through the gallery it still breaks (works maybe one time out of ten).
"exception: the coordinates or dimensions of the range are invalid"
This issue is fixed. Please try your scenario again and let us know the results.
No error message - but - I only get a couple hundred records where I expect to get 18k.
