I primary run queries through Google Sheets extension. The past week it is nearly impossible to Refresh the data as it take over 5 minutes to retrieve the data that used to take seconds.
I have tried the same queries on other programs like PG Admin and they are instant so I know its not an issue on my end.
Google Sheet Extension not working
- 96Views
- Last Post 21 December 2021
Hello Heidi,
Thank you for contacting Skyvia Support team.
The reason for a long time of query execution can be a big amount of records in the table.
You can try to execute the following query and check what the outcome is:
SELECT COUNT(*)
FROM table_name
Note that you should specify the name of the table or the Google Sheets sheet to execute the query properly.
We look forward to hearing from you.
Best regards,
Nataliia,
Customer Support Engineer
Literally none of my queries attached to a google sheet are working anymore.
Even when I try to run the query on the Skyvia website, it doesn't connect.
I have tried simple queries as well and they aren't working either. I really think it's something on your side of things since I am not having issues with these queries when I use a different service
Hello Heidi,
Thank you for the update.
You've mentioned that queries associated with a Google Sheets connector don't work anymore.
We were not able to reproduce the error.
Please send us the screenshot of the error if any. Kindly specify the steps we can follow to reproduce the issue on our end.
We look forward to hearing from you.
Best regards,
Nataliia,
Customer Support Engineer