Google Sheet Extension not working

  • 46Views
  • Last Post 21 December 2021
0
votes
Heidi Ellis posted this 19 December 2021

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. 

Order By: Standard | Newest | Votes
0
votes
Nataliia Nikulina posted this 20 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 

 

 

0
votes
Heidi Ellis posted this 20 December 2021

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 

0
votes
Nataliia Nikulina posted this 21 December 2021

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 

Close