If you are using Google BigQuery web interface I suggest to try superQuery Chrome extension:
https://chrome.google.com/webstore/detail/superquery-bigquery-optim/lfckfngaeoheoppemkocjjebloiamfdc
by superquery.io @EVALUEX1
You will have features like