BigQuery用户界面-数据集缺失 [英] BigQuery UI - Datasets missing

问题描述

我的BigQuery用户界面有一个奇怪的问题(请访问 https://bigquery.cloud.google.com/queries/my-project-name ).我不知道为什么，但是当我完全意识到它们的存在时，我看不到我项目的任何数据集.我的代码仍然可以命中这些数据集及其表.我没有办法看到他们.

I have a weird issue with my BigQuery UI (going on https://bigquery.cloud.google.com/queries/my-project-name). I don't know why, but I see no datasets for my projects, when I'm fully aware they exist. My code can still hit these datasets and their tables. There is just no way for me to see them.

在UI本身中，如果我手动键入整个查询，我仍然可以查询它们，但是能够看到我的架构结构可能会有所帮助.

In the UI itself, I can still query them if I type the whole query by hand, but being able to see my structure for my schema could be helpful.

当我在chrome上的开发人员工具中检查网络"标签时，我注意到我收到无法加载资源:net :: ERR_CACHE_MISS".然后，我决定尽一切可能重置自己的缓存.我清除了Cookie，隐身了，尝试了其他浏览器，甚至其他计算机.什么都没带回来我的数据集.

When I check my network tab in the developer tools on chrome, I notice that I receive "Failed to load ressource: net::ERR_CACHE_MISS". I then decided to do everything I could to reset my own cache. I cleared my cookies, went incognito, I tried other browsers, even other computers. NOTHING brings back my datasets.

任何人都遇到过这种情况，并且对如何强制缓存命中有任何想法?

Anyone encountered this and has any ideas how to force my cache to hit?

推荐答案

前一段时间我遇到了同样的问题.当我得到错误时，我就苦苦挣扎，最终找到了重置此错误的方法.好像是服务器端缓存的某些内容导致此不正确的缓存命中.重置服务器端缓存的方法是使用不存在的项目访问URL，因此类似

I had the same problem a while back. When I got the error, I struggled with it and I ended up finding a way to reset this. Seems like it's something cached server-side that makes this incorrect cache-hit. The way to reset the server-side cache is to hit a URL with a project that doesn't exist, so something like https://bigquery.cloud.google.com/queries/bogus-nonexistant-project should reset it all

这篇关于BigQuery用户界面-数据集缺失的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！