'How can I refresh datasets/resources in the new Google BigQuery Web UI?
I'm creating tables via the Big Query command-line utility, but occasionally ad-hoc querying with the new web UI. After creating a table via the CLI, how do I refresh the datasets/resources section in the new Google BigQuery Web UI so that I can see the newly-created table? The old UI had a "refresh" drop-down menu item next to the dataset name.
I do not want to reload the entire webpage because it removes the text I have in the query editor and requires me to search for the tables again. I would ideally like to just refresh the list of datasets in the "Resources" section.
Solution 1:[1]
The BigQuery team is already considering the possibility to add the "Refresh" button that was available in the Classic UI, to the New UI, in order to be able to reload the datasets and tables on a project without the need of reloading the entire page, as is needed now in order to see all the changes in the BigQuery project.
There are already several public Feature Requests available in the Public Issue Tracker, but let me share with you the one which is receiving more attention from other users. Feel free to "star" this issue in order to highlight its importance and leave a comment if you feel like there is anything relevant you want to add to the discussion.
Rest assured that this topic is already being discussed internally and the BigQuery team will update the public Feature Request whenever there is any relevant information to be shared with the users.
Solution 2:[2]
I have found a workaround for anyone still waiting.
If you click the search box in the project/dataset "Explorer" sidebar, then press enter, it will refresh the list.
This one... https://i.stack.imgur.com/Uce18.png
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | dsesto |
| Solution 2 | Hugh |