{"action":"created","comment":{"url":"https://api.github.com/repos/GoogleCloudPlatform/community/pulls/comments/117519342","pull_request_review_id":39238344,"id":117519342,"diff_hunk":"@@ -0,0 +1,301 @@\n+---\n+title: Exploratory queries with Google BigQuery\n+description: Use BigQuery to investigate arbitrarily large datasets.\n+author: jerjou\n+tags: Data Science, BigQuery\n+date_published: 2017-05-10\n+---\n+[Google BigQuery](/bigquery) is a fully-managed service for data\n+exploration using an SQL syntax. Once data has been loaded into the service, it\n+can be queried at interactive speeds, without having to know beforehand what\n+you're looking for.\n+\n+There has been much already written about using BigQuery for data analysis - for\n+example:\n+\n+* [Analyzing Financial Time Series using BigQuery](/solutions/time-series/bigquery-financial-forex)\n+* [How to forecast demand with Google BigQuery, public datasets and TensorFlow](/blog/big-data/2016/05/how-to-forecast-demand-with-google-bigquery-public-datasets-and-tensorflow)","path":"tutorials/data-science-exploration/index.md","position":17,"original_position":17,"commit_id":"e2ba5d5b24b7d6ddb6653c9616dd6e09936132ca","original_commit_id":"d0985b809d5624ab34fb3d62abf9e22adfd1861b","user":{"login":"puneith","id":8098778,"avatar_url":"https://avatars0.githubusercontent.com/u/8098778?v=3","gravatar_id":"","url":"https://api.github.com/users/puneith","html_url":"https://github.com/puneith","followers_url":"https://api.github.com/users/puneith/followers","following_url":"https://api.github.com/users/puneith/following{/other_user}","gists_url":"https://api.github.com/users/puneith/gists{/gist_id}","starred_url":"https://api.github.com/users/puneith/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/puneith/subscriptions","organizations_url":"https://api.github.com/users/puneith/orgs","repos_url":"https://api.github.com/users/puneith/repos","events_url":"https://api.github.com/users/puneith/events{/privacy}","received_events_url":"https://api.github.com/users/puneith/received_events","type":"User","site_admin":false},"body":"The financial time-series model is not correct. ","created_at":"2017-05-19T16:17:07Z","updated_at":"2017-05-19T16:17:07Z","html_url":"https://github.com/GoogleCloudPlatform/community/pull/156#discussion_r117519342","pull_request_url":"https://api.github.com/repos/GoogleCloudPlatform/community/pulls/156","_links":{"self":{"href":"https://api.github.com/repos/GoogleCloudPlatform/community/pulls/comments/117519342"},"html":{"href":"https://github.com/GoogleCloudPlatform/community/pull/156#discussion_r117519342"},"pull_request":{"href":"https://api.github.com/repos/GoogleCloudPlatform/community/pulls/156"}}},"pull_request":{"url":"https://api.github.com/repos/GoogleCloudPlatform/community/pulls/156","id":119951005,"html_url":"https://github.com/GoogleCloudPlatform/community/pull/156","diff_url":"https://github.com/GoogleCloudPlatform/community/pull/156.diff","patch_url":"https://github.com/GoogleCloudPlatform/community/pull/156.patch","issue_url":"https://api.github.com/repos/GoogleCloudPlatform/community/issues/156","number":156,"state":"open","locked":false,"title":"Some Data Science tutorials.","user":{"login":"jerjou","id":913439,"avatar_url":"https://avatars2.githubusercontent.com/u/913439?v=3","gravatar_id":"","url":"https://api.github.com/users/jerjou","html_url":"https://github.com/jerjou","followers_url":"https://api.github.com/users/jerjou/followers","following_url":"https://api.github.com/users/jerjou/following{/other_user}","gists_url":"https://api.github.com/users/jerjou/gists{/gist_id}","starred_url":"https://api.github.com/users/jerjou/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jerjou/subscriptions","organizations_url":"https://api.github.com/users/jerjou/orgs","repos_url":"https://api.github.com/users/jerjou/repos","events_url":"https://api.github.com/users/jerjou/events{/privacy}","received_events_url":"https://api.github.com/users/jerjou/received_events","type":"User","site_admin":false},"body":"","created_at":"2017-05-10T18:39:02Z","updated_at":"2017-05-19T16:17:07Z","closed_at":null,"merged_at":null,"merge_commit_sha":"2f822032c7e5294280581685bdd76c67079c9e09","assignee":{"login":"jerjou","id":913439,"avatar_url":"https://avatars2.githubusercontent.com/u/913439?v=3","gravatar_id":"","url":"https://api.github.com/users/jerjou","html_url":"https://github.com/jerjou","followers_url":"https://api.github.com/users/jerjou/followers","following_url":"https://api.github.com/users/jerjou/following{/other_user}","gists_url":"https://api.github.com/users/jerjou/gists{/gist_id}","starred_url":"https://api.github.com/users/jerjou/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jerjou/subscriptions","organizations_url":"https://api.github.com/users/jerjou/orgs","repos_url":"https://api.github.com/users/jerjou/repos","events_url":"https://api.github.com/users/jerjou/events{/privacy}","received_events_url":"https://api.github.com/users/jerjou/received_events","type":"User","site_admin":false},"assignees":[{"login":"jerjou","id":913439,"avatar_url":"https://avatars2.githubusercontent.com/u/913439?v=3","gravatar_id":"","url":"https://api.github.com/users/jerjou","html_url":"https://github.com/jerjou","followers_url":"https://api.github.com/users/jerjou/followers","following_url":"https://api.github.com/users/jerjou/following{/other_user}","gists_url":"https://api.github.com/users/jerjou/gists{/gist_id}","starred_url":"https://api.github.com/users/jerjou/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jerjou/subscriptions","organizations_url":"https://api.github.com/users/jerjou/orgs","repos_url":"https://api.github.com/users/jerjou/repos","events_url":"https://api.github.com/users/jerjou/events{/privacy}","received_events_url":"https://api.github.com/users/jerjou/received_events","type":"User","site_admin":false}],"requested_reviewers":[],"milestone":null,"commits_url":"https://api.github.com/repos/GoogleCloudPlatform/community/pulls/156/commits","review_comments_url":"https://api.github.com/repos/GoogleCloudPlatform/community/pulls/156/comments","review_comment_url":"https://api.github.com/repos/GoogleCloudPlatform/community/pulls/comments{/number}","comments_url":"https://api.github.com/repos/GoogleCloudPlatform/community/issues/156/comments","statuses_url":"https://api.github.com/repos/GoogleCloudPlatform/community/statuses/e2ba5d5b24b7d6ddb6653c9616dd6e09936132ca","head":{"label":"jerjou:data-science","ref":"data-science","sha":"e2ba5d5b24b7d6ddb6653c9616dd6e09936132ca","user":{"login":"jerjou","id":913439,"avatar_url":"https://avatars2.githubusercontent.com/u/913439?v=3","gravatar_id":"","url":"https://api.github.com/users/jerjou","html_url":"https://github.com/jerjou","followers_url":"https://api.github.com/users/jerjou/followers","following_url":"https://api.github.com/users/jerjou/following{/other_user}","gists_url":"https://api.github.com/users/jerjou/gists{/gist_id}","starred_url":"https://api.github.com/users/jerjou/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jerjou/subscriptions","organizations_url":"https://api.github.com/users/jerjou/orgs","repos_url":"https://api.github.com/users/jerjou/repos","events_url":"https://api.github.com/users/jerjou/events{/privacy}","received_events_url":"https://api.github.com/users/jerjou/received_events","type":"User","site_admin":false},"repo":{"id":90294355,"name":"community","full_name":"jerjou/community","owner":{"login":"jerjou","id":913439,"avatar_url":"https://avatars2.githubusercontent.com/u/913439?v=3","gravatar_id":"","url":"https://api.github.com/users/jerjou","html_url":"https://github.com/jerjou","followers_url":"https://api.github.com/users/jerjou/followers","following_url":"https://api.github.com/users/jerjou/following{/other_user}","gists_url":"https://api.github.com/users/jerjou/gists{/gist_id}","starred_url":"https://api.github.com/users/jerjou/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jerjou/subscriptions","organizations_url":"https://api.github.com/users/jerjou/orgs","repos_url":"https://api.github.com/users/jerjou/repos","events_url":"https://api.github.com/users/jerjou/events{/privacy}","received_events_url":"https://api.github.com/users/jerjou/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/jerjou/community","description":"Google Cloud Platform Community","fork":true,"url":"https://api.github.com/repos/jerjou/community","forks_url":"https://api.github.com/repos/jerjou/community/forks","keys_url":"https://api.github.com/repos/jerjou/community/keys{/key_id}","collaborators_url":"https://api.github.com/repos/jerjou/community/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/jerjou/community/teams","hooks_url":"https://api.github.com/repos/jerjou/community/hooks","issue_events_url":"https://api.github.com/repos/jerjou/community/issues/events{/number}","events_url":"https://api.github.com/repos/jerjou/community/events","assignees_url":"https://api.github.com/repos/jerjou/community/assignees{/user}","branches_url":"https://api.github.com/repos/jerjou/community/branches{/branch}","tags_url":"https://api.github.com/repos/jerjou/community/tags","blobs_url":"https://api.github.com/repos/jerjou/community/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/jerjou/community/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/jerjou/community/git/refs{/sha}","trees_url":"https://api.github.com/repos/jerjou/community/git/trees{/sha}","statuses_url":"https://api.github.com/repos/jerjou/community/statuses/{sha}","languages_url":"https://api.github.com/repos/jerjou/community/languages","stargazers_url":"https://api.github.com/repos/jerjou/community/stargazers","contributors_url":"https://api.github.com/repos/jerjou/community/contributors","subscribers_url":"https://api.github.com/repos/jerjou/community/subscribers","subscription_url":"https://api.github.com/repos/jerjou/community/subscription","commits_url":"https://api.github.com/repos/jerjou/community/commits{/sha}","git_commits_url":"https://api.github.com/repos/jerjou/community/git/commits{/sha}","comments_url":"https://api.github.com/repos/jerjou/community/comments{/number}","issue_comment_url":"https://api.github.com/repos/jerjou/community/issues/comments{/number}","contents_url":"https://api.github.com/repos/jerjou/community/contents/{+path}","compare_url":"https://api.github.com/repos/jerjou/community/compare/{base}...{head}","merges_url":"https://api.github.com/repos/jerjou/community/merges","archive_url":"https://api.github.com/repos/jerjou/community/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/jerjou/community/downloads","issues_url":"https://api.github.com/repos/jerjou/community/issues{/number}","pulls_url":"https://api.github.com/repos/jerjou/community/pulls{/number}","milestones_url":"https://api.github.com/repos/jerjou/community/milestones{/number}","notifications_url":"https://api.github.com/repos/jerjou/community/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/jerjou/community/labels{/name}","releases_url":"https://api.github.com/repos/jerjou/community/releases{/id}","deployments_url":"https://api.github.com/repos/jerjou/community/deployments","created_at":"2017-05-04T18:08:23Z","updated_at":"2017-05-04T18:08:25Z","pushed_at":"2017-05-18T18:22:26Z","git_url":"git://github.com/jerjou/community.git","ssh_url":"git@github.com:jerjou/community.git","clone_url":"https://github.com/jerjou/community.git","svn_url":"https://github.com/jerjou/community","homepage":"https://cloud.google.com/community","size":8362,"stargazers_count":0,"watchers_count":0,"language":"JavaScript","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"GoogleCloudPlatform:master","ref":"master","sha":"d531da68a15d8d97c6c47213471796b91e8fd6f9","user":{"login":"GoogleCloudPlatform","id":2810941,"avatar_url":"https://avatars3.githubusercontent.com/u/2810941?v=3","gravatar_id":"","url":"https://api.github.com/users/GoogleCloudPlatform","html_url":"https://github.com/GoogleCloudPlatform","followers_url":"https://api.github.com/users/GoogleCloudPlatform/followers","following_url":"https://api.github.com/users/GoogleCloudPlatform/following{/other_user}","gists_url":"https://api.github.com/users/GoogleCloudPlatform/gists{/gist_id}","starred_url":"https://api.github.com/users/GoogleCloudPlatform/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/GoogleCloudPlatform/subscriptions","organizations_url":"https://api.github.com/users/GoogleCloudPlatform/orgs","repos_url":"https://api.github.com/users/GoogleCloudPlatform/repos","events_url":"https://api.github.com/users/GoogleCloudPlatform/events{/privacy}","received_events_url":"https://api.github.com/users/GoogleCloudPlatform/received_events","type":"Organization","site_admin":false},"repo":{"id":50372538,"name":"community","full_name":"GoogleCloudPlatform/community","owner":{"login":"GoogleCloudPlatform","id":2810941,"avatar_url":"https://avatars3.githubusercontent.com/u/2810941?v=3","gravatar_id":"","url":"https://api.github.com/users/GoogleCloudPlatform","html_url":"https://github.com/GoogleCloudPlatform","followers_url":"https://api.github.com/users/GoogleCloudPlatform/followers","following_url":"https://api.github.com/users/GoogleCloudPlatform/following{/other_user}","gists_url":"https://api.github.com/users/GoogleCloudPlatform/gists{/gist_id}","starred_url":"https://api.github.com/users/GoogleCloudPlatform/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/GoogleCloudPlatform/subscriptions","organizations_url":"https://api.github.com/users/GoogleCloudPlatform/orgs","repos_url":"https://api.github.com/users/GoogleCloudPlatform/repos","events_url":"https://api.github.com/users/GoogleCloudPlatform/events{/privacy}","received_events_url":"https://api.github.com/users/GoogleCloudPlatform/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/GoogleCloudPlatform/community","description":"Google Cloud Platform Community","fork":false,"url":"https://api.github.com/repos/GoogleCloudPlatform/community","forks_url":"https://api.github.com/repos/GoogleCloudPlatform/community/forks","keys_url":"https://api.github.com/repos/GoogleCloudPlatform/community/keys{/key_id}","collaborators_url":"https://api.github.com/repos/GoogleCloudPlatform/community/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/GoogleCloudPlatform/community/teams","hooks_url":"https://api.github.com/repos/GoogleCloudPlatform/community/hooks","issue_events_url":"https://api.github.com/repos/GoogleCloudPlatform/community/issues/events{/number}","events_url":"https://api.github.com/repos/GoogleCloudPlatform/community/events","assignees_url":"https://api.github.com/repos/GoogleCloudPlatform/community/assignees{/user}","branches_url":"https://api.github.com/repos/GoogleCloudPlatform/community/branches{/branch}","tags_url":"https://api.github.com/repos/GoogleCloudPlatform/community/tags","blobs_url":"https://api.github.com/repos/GoogleCloudPlatform/community/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/GoogleCloudPlatform/community/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/GoogleCloudPlatform/community/git/refs{/sha}","trees_url":"https://api.github.com/repos/GoogleCloudPlatform/community/git/trees{/sha}","statuses_url":"https://api.github.com/repos/GoogleCloudPlatform/community/statuses/{sha}","languages_url":"https://api.github.com/repos/GoogleCloudPlatform/community/languages","stargazers_url":"https://api.github.com/repos/GoogleCloudPlatform/community/stargazers","contributors_url":"https://api.github.com/repos/GoogleCloudPlatform/community/contributors","subscribers_url":"https://api.github.com/repos/GoogleCloudPlatform/community/subscribers","subscription_url":"https://api.github.com/repos/GoogleCloudPlatform/community/subscription","commits_url":"https://api.github.com/repos/GoogleCloudPlatform/community/commits{/sha}","git_commits_url":"https://api.github.com/repos/GoogleCloudPlatform/community/git/commits{/sha}","comments_url":"https://api.github.com/repos/GoogleCloudPlatform/community/comments{/number}","issue_comment_url":"https://api.github.com/repos/GoogleCloudPlatform/community/issues/comments{/number}","contents_url":"https://api.github.com/repos/GoogleCloudPlatform/community/contents/{+path}","compare_url":"https://api.github.com/repos/GoogleCloudPlatform/community/compare/{base}...{head}","merges_url":"https://api.github.com/repos/GoogleCloudPlatform/community/merges","archive_url":"https://api.github.com/repos/GoogleCloudPlatform/community/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/GoogleCloudPlatform/community/downloads","issues_url":"https://api.github.com/repos/GoogleCloudPlatform/community/issues{/number}","pulls_url":"https://api.github.com/repos/GoogleCloudPlatform/community/pulls{/number}","milestones_url":"https://api.github.com/repos/GoogleCloudPlatform/community/milestones{/number}","notifications_url":"https://api.github.com/repos/GoogleCloudPlatform/community/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/GoogleCloudPlatform/community/labels{/name}","releases_url":"https://api.github.com/repos/GoogleCloudPlatform/community/releases{/id}","deployments_url":"https://api.github.com/repos/GoogleCloudPlatform/community/deployments","created_at":"2016-01-25T18:46:16Z","updated_at":"2017-05-18T11:16:25Z","pushed_at":"2017-05-18T18:22:27Z","git_url":"git://github.com/GoogleCloudPlatform/community.git","ssh_url":"git@github.com:GoogleCloudPlatform/community.git","clone_url":"https://github.com/GoogleCloudPlatform/community.git","svn_url":"https://github.com/GoogleCloudPlatform/community","homepage":"https://cloud.google.com/community","size":8022,"stargazers_count":46,"watchers_count":46,"language":"JavaScript","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":59,"mirror_url":null,"open_issues_count":33,"forks":59,"open_issues":33,"watchers":46,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/GoogleCloudPlatform/community/pulls/156"},"html":{"href":"https://github.com/GoogleCloudPlatform/community/pull/156"},"issue":{"href":"https://api.github.com/repos/GoogleCloudPlatform/community/issues/156"},"comments":{"href":"https://api.github.com/repos/GoogleCloudPlatform/community/issues/156/comments"},"review_comments":{"href":"https://api.github.com/repos/GoogleCloudPlatform/community/pulls/156/comments"},"review_comment":{"href":"https://api.github.com/repos/GoogleCloudPlatform/community/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/GoogleCloudPlatform/community/pulls/156/commits"},"statuses":{"href":"https://api.github.com/repos/GoogleCloudPlatform/community/statuses/e2ba5d5b24b7d6ddb6653c9616dd6e09936132ca"}}}}
{"actor":{"display_login":"puneith"}}