使用 JavaScript 的 Google-Big Query [英] Google-Big Query with JavaScript
本文介绍了使用 JavaScript 的 Google-Big Query的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我对 google apis 和 JavaScript 有点陌生，
i am kind of new with google apis and JavaScript,
是否有人提供我如何使用 JavaScript 连接 Google-Big Query api 并将数据从示例表加载到简单 HTML 页面的示例或教程.
Does any one have a example or a tutorials of how i can connect with the Google-Big Query api using JavaScript and load data from the sample tables to a simple HTML page.
在此先感谢您.
推荐答案
试试这个:
<html>
<head>
<script src="https://apis.google.com/js/client.js"></script>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script>
<script>
// User Submitted Variables
var project_id = 'XXXXXXXXXXX';
var client_id = 'XXXXXXXXXXXXXXXXXX.apps.googleusercontent.com';
var config = {
'client_id': client_id,
'scope': 'https://www.googleapis.com/auth/bigquery'
};
function showProjects() {
var request = gapi.client.bigquery.projects.list();
request.execute(function(response) {
$('#result_box').html(JSON.stringify(response, null));
});
}
function showDatasets() {
var request = gapi.client.bigquery.datasets.list({
'projectId':'publicdata'
});
request.execute(function(response) {
$('#result_box').html(JSON.stringify(response.result.datasets, null));
});
}
function runQuery() {
var request = gapi.client.bigquery.jobs.query({
'projectId': project_id,
'timeoutMs': '30000',
'query': 'SELECT TOP(repository_language, 5) as language, COUNT(*) as count FROM [publicdata:samples.github_timeline] WHERE repository_language != "";'
});
request.execute(function(response) {
console.log(response);
$('#result_box').html(JSON.stringify(response.result.rows, null));
});
}
function auth() {
gapi.auth.authorize(config, function() {
gapi.client.load('bigquery', 'v2');
$('#client_initiated').html('BigQuery client initiated');
$('#auth_button').fadeOut();
$('#projects_button').fadeIn();
$('#dataset_button').fadeIn();
$('#query_button').fadeIn();
});
}
</script>
</head>
<body>
<h2>BigQuery + JavaScript Example</h2>
<button id="auth_button" onclick="auth();">Authorize</button>
<div id="client_initiated"></div>
<button id="projects_button" style="display:none;" onclick="showProjects();">Show Projects</button>
<button id="dataset_button" style="display:none;" onclick="showDatasets();">Show datasets</button>
<button id="query_button" style="display:none;" onclick="runQuery();">Run Query</button>
<div id="result_box"></div>
</body>
</html>
这篇关于使用 JavaScript 的 Google-Big Query的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
