error loading table on bigquery dashboard but queries works fine

0
votes

I clicked a table on bigquery dashboard, got this error:

error message

However, I can get data when I do a select on this table. (That means the table does exist)

I already have the highest admin privilege so it shouldn't be a permission issue.

I created this table with python script, which collects data, writes into a csv file, and upload the csv file to bigquery everyday. After I created the table I once changed the schema both in the script and on the dashboard. Not sure if that's the cause, but the table loading error occurred several days after I changed the schema.

1
google-bigquery
If you try to fetch the table data using Tables.get api do you get the same error? - Tamir Klein
@TamirKlein I tried bigquery.Client in the python library, the get_table it provides works without errors. - Kingston Chan
If you can't see the table schema and info in BigQuery WebUI old and new with the correct user and you are able to get it via Python code than I suggest you open a support ticket with Google directly. - Tamir Klein
@TamirKlein OK, thank you for your help :) - Kingston Chan
Do you have any addblock extension in your browser by any chance?, if so, try disabling it and try again. - F10

1 Answers

0
votes

If you have Addblock extensions, this might be the root cause of this issue. Thus, try disabling it, then try running your query again.

Hope it helps.