{"id":11982,"date":"2020-11-18T16:57:45","date_gmt":"2020-11-18T08:57:45","guid":{"rendered":"https:\/\/www.microfusion.cloud\/hk\/?p=11982"},"modified":"2023-03-30T09:06:18","modified_gmt":"2023-03-30T01:06:18","slug":"gcp-bigquery-20201118","status":"publish","type":"post","link":"https:\/\/www.microfusion.cloud\/hk\/2020\/11\/18\/gcp-bigquery-20201118\/","title":{"rendered":"BigQuery \u5efa\u7acbsource dataset"},"content":{"rendered":"<p><\/p>\n\n\n<p>\u00a0<\/p>\n<p>\u5e38\u5e38\u89ba\u5f97\u8cc7\u6599\u5eab\u5361\u5361\u55ce\uff1f\u5c07\u8cc7\u6599\u5c0e\u5165 <a href=\"https:\/\/www.microfusion.cloud\/hk\/cloud-solution\/gcp\/data-warehouse\/\">BigQuery<\/a> \uff0c\u4e26\u4e14\u4f7f\u7528 Query\u8a9e\u6cd5\u641c\u5c0bTable\u5167\u7684\u8cc7\u6599\uff0c\u5c31\u53ef\u4ee5\u89e3\u6c7a\u8cc7\u6599\u5eab\u6548\u7387\u904e\u4f4e\u7684\u554f\u984c\u5594\uff01\u5feb\u4f86\u770b\u67b6\u69cb\u5e2b\u7684\u5c08\u696d\u6559\u5b78\u5427~<\/p>\n<p><strong>1. \u9ede\u64ca GCP Console \u2192 BigQuery<\/strong><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/mf-web-plugin-hk.storage.googleapis.com\/wp-content\/uploads\/2020\/11\/01-1.jpg\" sizes=\"auto, (max-width: 559px) 100vw, 559px\" srcset=\"https:\/\/mf-web-plugin-hk.storage.googleapis.com\/wp-content\/uploads\/2020\/11\/01-1.jpg 559w, https:\/\/mf-web-plugin-hk.storage.googleapis.com\/wp-content\/uploads\/2020\/11\/01-1-300x197.jpg 300w\" alt=\"\" width=\"559\" height=\"368\" \/><\/p>\n<p>\u00a0<\/p>\n<p><b>2. \u9ede\u64caCreate Dataset<\/b><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/mf-web-plugin-hk.storage.googleapis.com\/wp-content\/uploads\/2020\/11\/02-1-1024x456.jpg\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" srcset=\"https:\/\/mf-web-plugin-hk.storage.googleapis.com\/wp-content\/uploads\/2020\/11\/02-1-1024x456.jpg 1024w, https:\/\/mf-web-plugin-hk.storage.googleapis.com\/wp-content\/uploads\/2020\/11\/02-1-300x134.jpg 300w, https:\/\/mf-web-plugin-hk.storage.googleapis.com\/wp-content\/uploads\/2020\/11\/02-1-768x342.jpg 768w, https:\/\/mf-web-plugin-hk.storage.googleapis.com\/wp-content\/uploads\/2020\/11\/02-1-600x267.jpg 600w, https:\/\/mf-web-plugin-hk.storage.googleapis.com\/wp-content\/uploads\/2020\/11\/02-1.jpg 1444w\" alt=\"\" width=\"1024\" height=\"456\" \/><\/p>\n<p>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0 \u5e38\u5e38\u89ba\u5f97\u8cc7\u6599\u5eab\u5361\u5361\u55ce\uff1f\u5c07\u8cc7\u6599\u5c0e\u5165 BigQuery \uff0c\u4e26\u4e14\u4f7f\u7528 Query\u8a9e\u6cd5\u641c\u5c0bTable\u5167\u7684\u8cc7\u6599\uff0c\u5c31\u53ef\u4ee5\u89e3\u6c7a\u8cc7\u6599\u5eab\u6548\u7387\u904e\u4f4e\u7684\u554f\u984c\u5594\uff01\u5feb\u4f86\u770b\u67b6\u69cb\u5e2b\u7684\u5c08\u696d\u6559\u5b78\u5427~ 1. \u9ede\u64ca GCP Console \u2192 BigQuery \u00a0 2. \u9ede\u64caCreate Dataset \u00a0<\/p>\n","protected":false},"author":3,"featured_media":11998,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[173],"tags":[199,172],"class_list":["post-11982","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technical_gcp","tag-gcp"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.microfusion.cloud\/hk\/wp-json\/wp\/v2\/posts\/11982","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microfusion.cloud\/hk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microfusion.cloud\/hk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microfusion.cloud\/hk\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microfusion.cloud\/hk\/wp-json\/wp\/v2\/comments?post=11982"}],"version-history":[{"count":8,"href":"https:\/\/www.microfusion.cloud\/hk\/wp-json\/wp\/v2\/posts\/11982\/revisions"}],"predecessor-version":[{"id":20374,"href":"https:\/\/www.microfusion.cloud\/hk\/wp-json\/wp\/v2\/posts\/11982\/revisions\/20374"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microfusion.cloud\/hk\/wp-json\/wp\/v2\/media\/11998"}],"wp:attachment":[{"href":"https:\/\/www.microfusion.cloud\/hk\/wp-json\/wp\/v2\/media?parent=11982"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.microfusion.cloud\/hk\/wp-json\/wp\/v2\/categories?post=11982"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microfusion.cloud\/hk\/wp-json\/wp\/v2\/tags?post=11982"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}