GoogleBigQuery另存为表格 [英] GoogleBigQuery save as table

问题描述

我使用Google BigQuery运行了此查询:

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

看到结果后，我想将结果另存为CSV或JSON.但是GoogleBigQuery要求我另存为表格.列出了三个参数.
当我单击第二个下拉列表Destination dataset时，没有任何显示.我无法选择.因此，我无法成功保存结果. 我该如何解决这个问题?

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?

推荐答案

重新加载UI并只需确保您的浏览器不会阻止任何加载在页面上的javascript即可.如果您有AdBlock或类似的广告，请确保已在BigQuery用户界面中将其禁用.

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.

这篇关于GoogleBigQuery另存为表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！