I ran this query with Google BigQuery:
SELECT repo.id, count(*) as count FROM (
TABLE_DATE_RANGE([githubarchive:day.events_],
TIMESTAMP('2015-01-01'),
TIMESTAMP('2015-06-01')
))
WHERE type = 'ForkEvent' group by repo.id
After I see the results, I want to save results as CSV or JSON. But GoogleBigQuery asks me to save as table. There are three parameters listed.
When I click the second drop down list Destination dataset, nothing shows up. I cannot make any selection. Therefore, I cannot save results successfully.
How can I solve this problem?
Reloading the UI and simply making sure your browser doesn't block any javascript loaded on the page should do it. If you have AdBlock or similar make sure it's disabled for the BigQuery UI.
Other than this, you can directly write the results of the query to a table in query mode, using the Destination Table option that is available under Show Options.

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With