Google sheet Invalid token

  • 131Views
  • Last Post 05 March 2021
0
votes
Grover Skyvia posted this 30 October 2020

Dear Team,

We have production critical projects running on google sheet getting data from redshift.

We are getting an invalid token error in google sheets.
What I believe its more like a timeout issue as the query loads only 1100 records with very slow speed. The refreshing sheet used to be way faster updating 500 rows which are now 20 rows.

Query: https://app.skyvia.com/#/16316/query/6809

Please guide as ASAP

Thanks, Akshay

 

Attached Files

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 31 October 2020

Hello Akshay,

 

Unfortunately, we cannot access your saved query.

Please specify the following details:

- specify the query you are trying to use;

- whether the same query works in Skyvia Query Tool?

 

Best regards,

Mariia

0
votes
Grover Skyvia posted this 02 November 2020

Dear Maria,

- This is the query I'm using "SELECT *  FROM skyvia.pricing_data_livefeed"


- Yes query works perfectly in skyvia query tool and also in google sheets but it updates very slowly and throws the error "invalid token error" after refreshing 1000 rows.

Would be great if you can help as so many business processes things are getting delayed.

0
votes
Grover Skyvia posted this 04 November 2020

Dear Maria,

Any update on this?

0
votes
Dmitriy Muzurov posted this 05 November 2020

Hi,

Thank you for getting back to us.

We raised a ticket with our development team to investigate this.

Once there are any details, we will let you know.

0
votes
Dmitriy Muzurov posted this 05 March 2021

Hello,

We are from Skyvia Technical Team.

pageSize parameter was increased and the issue should be fixed.

Should you have any questions, do not hesitate to contact us back.

Close