Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

GoogleBigQuery save as table

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?

like image 213
Sining Ma Avatar asked Dec 28 '25 23:12

Sining Ma


1 Answers

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.

enter image description here

like image 194
Pentium10 Avatar answered Dec 31 '25 00:12

Pentium10