redash icon indicating copy to clipboard operation
redash copied to clipboard
verified publisher icon getredash

BigQuery- can't list tables

Open galgoogle opened this issue 7 years ago • 6 comments

When creating a BigQuery query on Redash the tables aren't being listed- although marked it in the connection.

image

In the logs, I see a timeout after only a few tables.

image

Technical details:

  • Redash Version: v4.0.0-rc.1+b3791
  • Browser/OS: All browsers
  • How did you install Redash: GCP

galgoogle avatar Mar 29 '18 11:03 galgoogle

Working for me .. 4.0.0-rc.1+b3786 image

darylerwin avatar Mar 29 '18 16:03 darylerwin

@darylerwin how many tables do you have? We have a few hundreds.

galgoogle avatar Apr 08 '18 09:04 galgoogle

Not nearly that many .. less than a hundred.

darylerwin avatar Apr 08 '18 16:04 darylerwin

@galgoogle Could you paste more your log. If the worker requests are a timeout, then you should change REDASH_JOB_EXPIRY_TIME Environment Variable. https://redash.io/help/open-source/admin-guide/env-vars-settings

kyoshidajp avatar Apr 20 '18 14:04 kyoshidajp

I tried this with ~260 tables and it seems to work. The main issue I see is that it takes a long time to satisfy the request so the schema viewer appears blank for a while. I suppose it makes sense that it would time out if it takes too long. Perhaps this would be better if it was multiple smaller request (e.g. 100 tables at a time)

emtwo avatar Nov 02 '18 14:11 emtwo

any workaround on this? i use 10.1.0.b50633 and i am facing the same issue.

samsulmaarif avatar Oct 05 '22 14:10 samsulmaarif

colleagues, I have the same problem can anyone advise how to solve it?

ursuser avatar Mar 21 '23 10:03 ursuser