{"id":14748,"date":"2021-08-11T12:02:32","date_gmt":"2021-08-11T04:02:32","guid":{"rendered":"https:\/\/www.microfusion.cloud\/hk\/?post_type=cloud_solution&#038;p=14748"},"modified":"2023-06-05T10:41:36","modified_gmt":"2023-06-05T02:41:36","slug":"data-warehouse","status":"publish","type":"cloud_solution","link":"https:\/\/www.microfusion.cloud\/hk\/cloud-solution\/gcp\/data-warehouse\/","title":{"rendered":"Bigquery\u2014\u5927\u6578\u64da\u8cc7\u6599\u5009\u5132\u670d\u52d9"},"content":{"rendered":"<div class=\"block block-image-text margin-large\" id=\"product-description\">\n                <div class=\"row align-items-lg-center margin-bottom\">\n            <div class=\"col-lg-5\" data-fos=\"fade-up\" data-fos-lg-delay=\"\">\n                <img loading=\"lazy\" decoding=\"async\" width=\"768\" height=\"449\" src=\"https:\/\/mf-web-plugin-hk.storage.googleapis.com\/wp-content\/uploads\/2021\/08\/GCP-Data-Warehouse-B-768x449.jpg\" class=\"attachment-medium_large size-medium_large\" alt=\"\u6d1e\u5bdf\u6578\u64da\u8cc7\u8a0a\" srcset=\"https:\/\/mf-web-plugin-hk.storage.googleapis.com\/wp-content\/uploads\/2021\/08\/GCP-Data-Warehouse-B-768x449.jpg 768w, https:\/\/mf-web-plugin-hk.storage.googleapis.com\/wp-content\/uploads\/2021\/08\/GCP-Data-Warehouse-B-300x175.jpg 300w, https:\/\/mf-web-plugin-hk.storage.googleapis.com\/wp-content\/uploads\/2021\/08\/GCP-Data-Warehouse-B.jpg 770w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/>            <\/div>\n            <div class=\"col-lg-5 offset-lg-1\" data-fos=\"fade-up\" data-fos-lg-delay=\"100\">\n                <div class=\"image-text-content\">\n                                            <h2 class=\"block-heading text-left\">\u6d1e\u5bdf\u6578\u64da\u8cc7\u8a0a<br \/>\r\n\u7cbe\u6e96\u6b78\u7d0d\u5546\u696d\u6c7a\u7b56<\/h2>\n                                        <div class=\"article-content text-left\">\n                        <p>\u516c\u53f8\u64c1\u6709\u6210\u5806\u7684\u6578\u64da\uff0c\u537b\u4e0d\u77e5\u9053\u5982\u4f55\u904b\u7528\uff1f\u773c\u770b\u8cc7\u6599\u8d8a\u4f86\u8d8a\u591a\uff0c\u537b\u4e0d\u77e5\u9053\u8a72\u5982\u4f55\u8f49\u5316\u70ba\u5546\u6a5f\uff1f\u516c\u53f8\u64c1\u6709\u8a31\u591a\u9802\u5c16\u8cc7\u6599\u79d1\u5b78\u5bb6\uff0c\u537b\u82b1\u4e86\u5f88\u591a\u6642\u9593\u5728\u67b6\u69cb\u7684\u5efa\u69cb\u8207\u7dad\u6301\u904b\u4f5c\uff1f\u5b8f\u5ead\u79d1\u6280\u63d0\u4f9b\u7684\u5927\u6578\u64da\u8cc7\u6599\u5009\u5132\u670d\u52d9\uff0c\u5354\u52a9\u60a8\u904b\u7528 BigQuery \u89e3\u6c7a\u4ee5\u4e0a\u554f\u984c\uff0c\u5f9e\u6578\u64da\u8cc7\u6599\u6b78\u7d0d\u51fa\u7cbe\u6e96\u5546\u696d\u6c7a\u7b56\u3002<\/p>\n                    <\/div>\n                                    <\/div>\n            <\/div>\n        <\/div>\n    <\/div>\n\n<\/div>\n<\/div><div class=\"block block-custom-container\" id=\"\">\n    <div class=\"container\">\n    <div class=\"article-content\">    <div class=\"fullwidth-block__interior\">\n        \n\n<h2 class=\"wp-block-heading\">\u4ec0\u9ebc\u662f\u8cc7\u6599\u5009\u5132\uff1f<\/h2>\n\n\n\n<p style=\"text-align: left;\"><span style=\"font-weight: 400;\">\u8cc7\u6599\u5009\u5132\u670d\u52d9<\/span><span style=\"font-weight: 400;\">\uff0c<\/span><span style=\"font-weight: 400;\">\u662f<\/span><span style=\"font-weight: 400;\">\u7528\u4f86\u67e5\u8a62\u3001\u5206\u6790\u548c\u5831\u544a\u5404\u7a2e\u4f86\u6e90\u7684\u7d50\u69cb\u5316\u548c\u534a\u7d50\u69cb\u5316\u8cc7\u6599\uff0c\u50cf\u662f\u92b7\u552e\u9ede\u4ea4\u6613\u3001<\/span><span style=\"font-weight: 400;\">\u71df\u92b7<\/span><span style=\"font-weight: 400;\">\u81ea\u52d5\u5316\u3001\u5ba2\u6236\u95dc\u4fc2\u7ba1\u7406\u7b49\u3002\u9019\u985e\u8cc7\u6599\u7ba1\u7406\u7cfb\u7d71\u53ef\u5c07\u76ee\u524d\u8cc7\u6599\u548c\u6b77\u4f86\u8cc7\u6599<\/span><span style=\"font-weight: 400;\">\u96c6\u4e2d<\/span><span style=\"font-weight: 400;\">\u5132\u5b58\u5728\u540c\u4e00\u500b\u5730\u65b9\uff0c\u4e26\u5f9e\u4e2d\u8403\u53d6\u91cd\u5927\u50f9\u503c\uff0c\u6210\u70ba\u7d44\u7e54\u7684\u55ae\u4e00\u8cc7\u8a0a\u4f86\u6e90\u3001\u52a9\u7d44\u8077\u5be6\u73fe\u5546\u696d\u667a\u6167\u3002<\/span><\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n\n\n    <\/div>\n    <\/div>\n<\/div><\/div><div class=\"container\">\n    <div class=\"article-content\">\n\n<\/div>\n<\/div>\n<div class=\"block block-features padding-large\" id=\"advantage\">\n    <div class=\"container\">\n        <div class=\"row justify-content-center\" data-fos=\"fade-up\">\n            <div class=\"col-lg-10 col-xl-8\">\n                                    <h2 class=\"block-heading text-center\">\u7121\u4f3a\u670d\u5668\u8cc7\u6599\u5009\u5132\u6280\u8853 <br \/>\r\nBigQuery\u52a9\u60a8\u6975\u5927\u5316\u6642\u9593\u50f9\u503c<\/h2>\n                                                    <div class=\"description text-center\">\n                        <p>\u82e5\u4f7f\u7528\u50b3\u7d71\u6280\u8853\u67b6\u8a2d\u8cc7\u6599\u5009\u5132\uff0c\u4e45\u800c\u4e45\u4e4b\u4fbf\u9700\u9762\u5c0d\u6578\u64da\u5c0e\u5165\u9700\u7d93\u904e\u975e\u5e38\u8907\u96dc\u7684ETL\uff0c\u6216\u662f\u5728\u7ba1\u7406\u6578\u64da\u5009\u5eab\u6642\uff0c\u6703\u9700\u8981\u6578\u64da\u5eab\u5de5\u7a0b\u5e2b\u6295\u5165\u5927\u91cf\u6642\u9593\u4f86\u5b8c\u6210\u7b49\u554f\u984c\u3002\u800cBigQuery\u670d\u52d9\u501f\u52a9\u7121\u4f3a\u670d\u5668\u8cc7\u6599\u5009\u5132\u6280\u8853\uff0c\u53ef\u4ee5\u5728\u5e55\u5f8c\u9032\u884c\u6240\u6709\u8cc7\u6e90\u4f48\u5efa\u4f5c\u696d\uff0c\u8b93\u60a8\u5c08\u5fc3\u8655\u7406\u8cc7\u6599\u548c\u5206\u6790\u5de5\u4f5c\uff0c\u4e0d\u5fc5\u7169\u60f1\u5347\u7d1a\u3001\u4fdd\u8b77\u53ca\u7ba1\u7406\u57fa\u790e\u67b6\u69cb\u7b49\u4e8b\u52d9\uff0c\u6975\u5927\u5316\u60a8\u7684\u6642\u9593\u50f9\u503c\uff01<\/p>\n                    <\/div>\n                            <\/div>\n        <\/div>\n        <div class=\"row justify-content-center\">\n                            <div class=\"col-lg-10\">\n                    <div class=\"accordion-list row\">\n                                                    <div class=\"col-md-6\">\n                                <div class=\"accordion-card\" itemscope itemprop=\"mainEntity\" itemtype=\"https:\/\/schema.org\/Question\" data-fos=\"fade-up\">\n    <div class=\"accordion-card-header active\">\n        <h3 class=\"h5\" itemprop=\"name\">\u5373\u6642\u9810\u6e2c\u5206\u6790\uff0c\u6df1\u5165\u5206\u6790\u8cc7\u6599<\/h3>\n    <\/div>\n    <div class=\"accordion-card-content\" itemscope itemprop=\"acceptedAnswer\" itemtype=\"https:\/\/schema.org\/Answer\" style=\"display:block;\">\n        <div class=\"article-content\" itemprop=\"text\">\n            <p class=\"p1\">\u4f7f\u7528BigQuery\u670d\u52d9\uff0c\u60a8\u53ef\u4ee5\u5373\u6642\u67e5\u8a62\u4e32\u6d41\u8cc7\u6599\u3001\u53d6\u5f97\u6240\u6709\u696d\u52d9\u7a0b\u5e8f\u7684\u6700\u65b0\u8cc7\u8a0a\uff0c\u4e26\u904b\u7528\u5167\u5efa\u7684\u6a5f\u5668\u5b78\u7fd2\u6280\u8853\uff0c\u8f15\u9b06\u9810\u6e2c\u696d\u52d9\u7d50\u679c\uff0c\u904e\u7a0b\u4e2d\u5b8c\u5168\u4e0d\u9700\u8981\u79fb\u52d5\u8cc7\u6599\u3002<\/p>\n        <\/div>\n    <\/div>\n<\/div><div class=\"accordion-card\" itemscope itemprop=\"mainEntity\" itemtype=\"https:\/\/schema.org\/Question\" data-fos=\"fade-up\">\n    <div class=\"accordion-card-header active\">\n        <h3 class=\"h5\" itemprop=\"name\">\u8f15\u9b06\u6253\u9020 AI \u57fa\u790e<\/h3>\n    <\/div>\n    <div class=\"accordion-card-content\" itemscope itemprop=\"acceptedAnswer\" itemtype=\"https:\/\/schema.org\/Answer\" style=\"display:block;\">\n        <div class=\"article-content\" itemprop=\"text\">\n            <p><span style=\"font-weight: 400;\">BigQuery<\/span><span style=\"font-weight: 400;\">\u00a0\u4e0d\u50c5\u63d0\u4f9b\u53ef\u5c07\u6a5f\u5668\u5b78\u7fd2\u6280\u8853\u5c0e\u5165\u8cc7\u6599\u7684\u00a0<\/span><span style=\"font-weight: 400;\">BigQuery<\/span><span style=\"font-weight: 400;\"> ML\uff0c\u4e5f\u8207\u00a0AI\u00a0\u5e73\u53f0\u9810\u6e2c\u548c\u00a0TensorFlow\u00a0\u76f8\u4e92\u6574\u5408\uff0c\u53ea\u9700\u8981\u4f7f\u7528\u539f\u6709\u7684\u00a0SQL\u00a0\u5de5\u5177\u8207SQL\u8a9e\u6cd5\uff0c\u5373\u53ef\u5728\u5e7e\u5206\u9418\u5167\u4ee5\u7d50\u69cb\u5316\u8cc7\u6599\u8a13\u7df4\u51fa\u529f\u80fd\u5f37\u5927\u7684\u6a21\u578b\u3002<\/span><\/p>\n        <\/div>\n    <\/div>\n<\/div><div class=\"accordion-card\" itemscope itemprop=\"mainEntity\" itemtype=\"https:\/\/schema.org\/Question\" data-fos=\"fade-up\">\n    <div class=\"accordion-card-header active\">\n        <h3 class=\"h5\" itemprop=\"name\">\u8cc7\u6599\u7372\u5f97\u5b8c\u5584\u4fdd\u8b77\uff0c\u4f5c\u696d\u74b0\u5883\u503c\u5f97\u4fe1\u8cf4\uff0c\u5927\u5e45\u7c21\u5316\u5206\u6790\u904e\u7a0b<\/h3>\n    <\/div>\n    <div class=\"accordion-card-content\" itemscope itemprop=\"acceptedAnswer\" itemtype=\"https:\/\/schema.org\/Answer\" style=\"display:block;\">\n        <div class=\"article-content\" itemprop=\"text\">\n            <p><span style=\"font-weight: 400;\">BigQuery<\/span><span style=\"font-weight: 400;\">\u00a0\u7684\u5b89\u5168\u3001\u7ba1\u7406\u8207\u53ef\u9760\u6027\u63a7\u7ba1\u6a5f\u5236\u76f8\u7576\u7a69\u56fa\uff0c\u63d0\u4f9b\u9ad8\u53ef\u7528\u6027\u548c\u00a099.99%\u00a0\u7684\u904b\u4f5c\u6642\u9593\u670d\u52d9\u6c34\u6e96\u5354\u8b70\uff0c\u9084\u53ef\u5229\u7528\u9810\u8a2d\u7684\u52a0\u5bc6\u6a5f\u5236\u548c\u5ba2\u6236\u7ba1\u7406\u7684\u52a0\u5bc6\u91d1\u9470<\/span><span style=\"font-weight: 400;\">\uff0c<\/span><span style=\"font-weight: 400;\">\u4fdd\u8b77\u8cc7\u6599\u5b89\u5168\u3002<\/span><\/p>\n        <\/div>\n    <\/div>\n<\/div>                            <\/div>\n                                                    <div class=\"col-md-6\">\n                                <div class=\"accordion-card\" itemscope itemprop=\"mainEntity\" itemtype=\"https:\/\/schema.org\/Question\" data-fos=\"fade-up\">\n    <div class=\"accordion-card-header active\">\n        <h3 class=\"h5\" itemprop=\"name\">\u806f\u5408\u67e5\u8a62\u548c\u908f\u8f2f\u5f0f\u8cc7\u6599\u5009\u5132\u6280\u8853<\/h3>\n    <\/div>\n    <div class=\"accordion-card-content\" itemscope itemprop=\"acceptedAnswer\" itemtype=\"https:\/\/schema.org\/Answer\" style=\"display:block;\">\n        <div class=\"article-content\" itemprop=\"text\">\n            <p><span style=\"font-weight: 400;\">\u900f\u904e\u529f\u80fd\u5f37\u5927\u7684\u806f\u5408\u67e5\u8a62<\/span><span style=\"font-weight: 400;\">\u6280\u8853<\/span><span style=\"font-weight: 400;\">\uff0c<\/span><span style=\"font-weight: 400;\">BigQuery<\/span><span style=\"font-weight: 400;\">\u00a0\u5b8c\u5168\u4e0d\u9700\u79fb\u52d5\u8cc7\u6599\u5eab\uff0c\u4fbf\u80fd\u8655\u7406\u7269\u4ef6\u5132\u5b58\u7a7a\u9593\u00a0<\/span><span style=\"font-weight: 400;\">\uff08<\/span><span style=\"font-weight: 400;\">Cloud Storage<\/span><span style=\"font-weight: 400;\">\uff09<\/span><span style=\"font-weight: 400;\">\u00a0\u4e2d\uff0c\u63a1\u7528\u00a0Parquet\u00a0\u548c\u6700\u4f73\u5316\u55ae\u6b04\u5f0f\u8cc7\u6599\u5217\u00a0<\/span><span style=\"font-weight: 400;\">\uff08<\/span><span style=\"font-weight: 400;\">ORC<\/span><span style=\"font-weight: 400;\">\uff09<\/span><span style=\"font-weight: 400;\">\u00a0\u7b49<\/span><span style=\"font-weight: 400;\">\uff0c<\/span><span style=\"font-weight: 400;\">\u958b\u653e\u539f\u59cb\u78bc\u6a94\u6848\u683c\u5f0f\u7684\u5916\u90e8\u8cc7\u6599\u4f86\u6e90\uff0c\u4e5f\u53ef\u8655\u7406\u4ea4\u6613\u5f0f\u8cc7\u6599\u5eab<\/span><span style=\"font-weight: 400;\">\uff08<\/span><span style=\"font-weight: 400;\">Bigtable\u00a0\u548c\u00a0Cloud SQL<\/span><span style=\"font-weight: 400;\">\uff09\u00a0\uff0c<\/span><span style=\"font-weight: 400;\">\u6216\u96f2\u7aef\u786c\u789f\u8a66\u7b97\u8868\u4e2d\u7684\u5916\u90e8\u8cc7\u6599\u4f86\u6e90\u3002<\/span><\/p>\n        <\/div>\n    <\/div>\n<\/div><div class=\"accordion-card\" itemscope itemprop=\"mainEntity\" itemtype=\"https:\/\/schema.org\/Question\" data-fos=\"fade-up\">\n    <div class=\"accordion-card-header active\">\n        <h3 class=\"h5\" itemprop=\"name\">BigQuery\u8cc7\u6599\u79fb\u8f49\u670d\u52d9<\/h3>\n    <\/div>\n    <div class=\"accordion-card-content\" itemscope itemprop=\"acceptedAnswer\" itemtype=\"https:\/\/schema.org\/Answer\" style=\"display:block;\">\n        <div class=\"article-content\" itemprop=\"text\">\n            <p>\u5168\u4ee3\u7ba1\u7684 BigQuery \u8cc7\u6599\u79fb\u8f49\u670d\u52d9\u6703\u81ea\u52d5\u4f9d\u64da\u6392\u5b9a\u7684\u6642\u7a0b\uff0c\u5c07 Google Marketing Platform\u3001Google Ads\u3001YouTube \u548c\u5408\u4f5c\u5925\u4f34\u7684\u8edf\u9ad4\u5f0f\u670d\u52d9 \uff08SaaS\uff09\u61c9\u7528\u7a0b\u5f0f\u7b49\u5916\u90e8\u8cc7\u6599\u4f86\u6e90\u4e2d\u7684\u8cc7\u6599\u79fb\u8f49\u81f3BigQuery\u3002\u6b64\u5916\uff0c\u4f7f\u7528\u8005\u4e5f\u80fd\u8f15\u9b06\u5c07\u8cc7\u6599\u5f9e Teradata \u548c Amazon S3 \u7b49\u79fb\u8f49\u81f3 BigQuery\u3002<\/p>\n        <\/div>\n    <\/div>\n<\/div><div class=\"accordion-card\" itemscope itemprop=\"mainEntity\" itemtype=\"https:\/\/schema.org\/Question\" data-fos=\"fade-up\">\n    <div class=\"accordion-card-header active\">\n        <h3 class=\"h5\" itemprop=\"name\">\u5927\u5e45\u4e0b\u964d\u7e3d\u6301\u6709\u6210\u672c( TCO )<\/h3>\n    <\/div>\n    <div class=\"accordion-card-content\" itemscope itemprop=\"acceptedAnswer\" itemtype=\"https:\/\/schema.org\/Answer\" style=\"display:block;\">\n        <div class=\"article-content\" itemprop=\"text\">\n            <p>\u50b3\u7d71\u7684\u4f01\u696d\u6578\u64da\u5009\u5eab ( EDW ) \u9700\u8981\u6602\u8cb4\u7684\u7522\u54c1\u8a31\u53ef\u3001\u5927\u91cf\u7684\u786c\u9ad4\u6295\u8cc7\u548c\u7dad\u8b77\u6210\u672c\u3002\u4f7f\u7528Google\u958b\u767c\u7684 BigQuery\u670d\u52d9\uff0c\u501f\u52a9\u7121\u4f3a\u670d\u5668\u8cc7\u6599\u5009\u5132\u6280\u8853\uff0c\u5927\u898f\u6a21\u57f7\u884c\u6578\u64da\u5206\u6790\u4f5c\u696d\uff0c\u80fd\u70ba\u4f01\u696d\u7bc0\u7701\u5927\u91cf\u6210\u672c\u3002\u9077\u79fb\u81f3BigQuery\u53ef\u964d\u4f4e\u9ad8\u905452%\u7e3d\u6301\u6709\u6210\u672c( TCO )\u3002<\/p>\n        <\/div>\n    <\/div>\n<\/div>                            <\/div>\n                                            <\/div>\n                <\/div>\n                    <\/div>\n    <\/div>\n<\/div>\n<div class=\"container\">\n    <div class=\"article-content\">\n\n<div class=\"block block-why-choose-us margin-large\" id=\"\">\n            <h2 class=\"block-heading\" data-fos=\"fade-up\" data-fos-delay=\"150\">\u8cc7\u6599\u5009\u5132\u7684\u5efa\u7f6e\u904e\u7a0b-ETL<\/h2>\n            <div class=\"row margin\">\n                    <div class=\"col-12 col-md-6 col-lg-4 why-choose-us-item-wrapper\" data-fos=\"fade-up\" data-fos-md-delay=\"100\" data-fos-lg-delay=\"100\">\n                <div class=\"why-choose-us-item\">\n                    <span class=\"number\">01<\/span>\n                    <h5 class=\"why-choose-us-item-title\">\u64f7\u53d6 \uff08extract\uff09<\/h5>\n                    <div class=\"why-choose-us-item-description\">\n                        <p>\u5f9e\u55ae\u500b\u6216\u591a\u500b\u8cc7\u6599\u4f86\u6e90\u64f7\u53d6\u8cc7\u6599<\/p>\n                    <\/div>\n                <\/div>\n            <\/div>\n                    <div class=\"col-12 col-md-6 col-lg-4 why-choose-us-item-wrapper\" data-fos=\"fade-up\" data-fos-md-delay=\"0\" data-fos-lg-delay=\"200\">\n                <div class=\"why-choose-us-item\">\n                    <span class=\"number\">02<\/span>\n                    <h5 class=\"why-choose-us-item-title\">\u8f49\u63db \uff08transform\uff09<\/h5>\n                    <div class=\"why-choose-us-item-description\">\n                        <p>\u7372\u53d6\u8cc7\u6599\u3001\u6e05\u7406\u8cc7\u6599\u4e26\u5c07\u8cc7\u6599\u8f49\u63db\u70ba\u901a\u7528\u683c\u5f0f\uff0c\u4ee5\u4fbf\u5132\u5b58\u5728\u8cc7\u6599\u5009\u5132\u4e2d<\/p>\n                    <\/div>\n                <\/div>\n            <\/div>\n                    <div class=\"col-12 col-md-6 col-lg-4 why-choose-us-item-wrapper\" data-fos=\"fade-up\" data-fos-md-delay=\"100\" data-fos-lg-delay=\"0\">\n                <div class=\"why-choose-us-item\">\n                    <span class=\"number\">03<\/span>\n                    <h5 class=\"why-choose-us-item-title\">\u8f09\u5165 \uff08load\uff09<\/h5>\n                    <div class=\"why-choose-us-item-description\">\n                        <p>\u5c07\u683c\u5f0f\u5316\u5f8c\u7684\u8cc7\u6599\u63d2\u5165\u8cc7\u6599\u5009\u5132<\/p>\n                    <\/div>\n                <\/div>\n            <\/div>\n            <\/div>\n<\/div>\n\n<\/div>\n<\/div>\n<div class=\"block block-fullwidth-image-text background-black padding-large rel\" id=\"packages\">\n    <div class=\"bg-image-wrapper h-100 abs\">\n        <div class=\"bg-image background-default h-100 abs\" style=\"background-image: url('https:\/\/mf-web-plugin-hk.storage.googleapis.com\/wp-content\/uploads\/2021\/08\/GCP-Data-Warehouse-C.jpg')\"><\/div>\n            <\/div>\n    <div class=\"container\">\n        <div class=\"row\">\n            <div class=\"col-lg-7 offset-lg-5\" data-fos=\"fade-up\" data-fos-lg-delay=\"0\">\n                                    <h2 class=\"block-heading\">\u5b8f\u5ead\u7522\u696d\u61c9\u7528\u65b9\u6848<\/h2>\n                                <div class=\"fullwidth-image-text-content article-content\">\n                    <p>\u5a92\u9ad4\u696d\u60f3\u8981\u63d0\u5347\u5ee3\u544a\u6548\u76ca\u8207\u89e3\u6c7a\u8a02\u95b1\u7528\u6236\u6708\u6708\u4e0b\u964d\u7684\u96e3\u984c\uff0c\u537b\u82e6\u7121\u89e3\u65b9\uff1f\u96fb\u5546\u3001\u96f6\u552e\u696d\u9762\u81e8\u6d88\u8cbb\u8005\u90fd\u662f\u901b\u901b\u537b\u4e0d\u4e0b\u55ae\u3001\u6703\u54e1\u4e0d\u65b7\u6d41\u5931\u7684\u56f0\u5883\uff1f\u904a\u6232\u696d\u82b1\u8cbb\u9f90\u5927\u958b\u767c\u6210\u672c\u537b\u63d0\u5347\u4e0d\u4e86\u73a9\u5bb6\u7c98\u5ea6\uff1f<\/p>\n<p>\u4e0a\u8ff0\u9019\u4e9b\u96e3\u984c\uff0c\u5c31\u4ea4\u7d66\u5b8f\u5ead\u79d1\u6280 ETL \u89e3\u6c7a\u65b9\u6848\u3002\u6211\u5011\u7684\u89e3\u6c7a\u65b9\u6848\u4ee5\u76f8\u5b9c\u6536\u8cbb\uff0c\u70ba\u60a8\u63d0\u4f9b\u4e00\u7ad9\u5f0f\u5f9e\u8cc7\u6599\u8f38\u5165\u3001\u8403\u53d6\u3001\u6e05\u6d17\u3001\u8f49\u5316\u5230\u8f09\u5165\u5206\u6790\u670d\u52d9\uff0c\u4f7f\u7528 Google Cloud \u5167\u5efa\u958b\u767c\u7684BigQuery\uff0c\u4e0d\u50c5\u80fd\u652f\u63f4\u591a\u7a2e\u8cc7\u6599\u683c\u5f0f\uff08\u5982 CSV\u3001JSON\u3001AVRO\uff09\uff0c\u66f4\u80fd\u77ed\u6642\u9593\u5167\u8655\u7406PB\u898f\u6a21\u7684\u8cc7\u6599\uff0c\u518d\u900f\u904e Dataprep \u548c Dataflow \u7684\u6e05\u6d17\u8ddf\u8f49\u5316\u7a0b\u5e8f\uff0c\u6700\u7d42\u5c07\u7d50\u679c\u8f38\u51fa\u5230\u5b8c\u5168\u514d\u8cbb\u7684 Data Studio\uff0c\u5448\u73fe\u6578\u64da\u6210\u679c\uff0c\u5354\u52a9\u5404\u7522\u696d\u5ba2\u6236\u6d1e\u5bdf\u6578\u64da\u4e2d\u7684\u5967\u79d8\uff0c\u4f5c\u51fa\u6700\u7cbe\u6e96\u7684\u5546\u696d\u6c7a\u7b56\u3002<\/p>\n                <\/div>\n            <\/div>\n        <\/div>\n    <\/div>\n<\/div>\n<div class=\"container\">\n    <div class=\"article-content\">\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2>\u5e38\u898b\u554f\u984c<\/h2>\n<h3>\u751a\u9ebc\u662f\u8cc7\u6599\u5009\u5132\u670d\u52d9\uff1f<\/h3>\n<p>\u8cc7\u6599\u5009\u5132\u670d\u52d9\u662f\u7528\u4f86\u67e5\u8a62\u3001\u5206\u6790\u548c\u5831\u544a\u5404\u7a2e\u5982\u92b7\u552e\u9ede\u4ea4\u6613\u3001\u71df\u92b7\u81ea\u52d5\u5316\u3001\u5ba2\u6236\u95dc\u4fc2\u7ba1\u7406\u7b49\u7d50\u69cb\u5316\u3001\u534a\u7d50\u69cb\u5316\u8cc7\u6599\u7684\u670d\u52d9\u3002\u9019\u985e\u8cc7\u6599\u7ba1\u7406\u670d\u52d9\u53ef\u5c07\u4f01\u696d\u7684\u8cc7\u6599\u96c6\u4e2d\u5132\u5b58\u5728\u540c\u4e00\u500b\u5730\u65b9\uff0c\u5f9e\u4e2d\u8403\u53d6\u91cd\u5927\u50f9\u503c\uff0c\u6210\u70ba\u4f01\u696d\u7684\u55ae\u4e00\u8cc7\u8a0a\u4f86\u6e90\u3001\u52a9\u4f01\u696d\u5be6\u73fe\u5546\u696d\u667a\u6167\u3002<\/p>\n<h3>\u751a\u9ebc\u662fBigQuery\uff1f<\/h3>\n<p>BigQuery\u662f\u7531Google Cloud\u63d0\u4f9b\u7684\u4e00\u500b\u5168\u4ee3\u7ba1\u96f2\u7aef\u6578\u64da\u5009\u5eab\uff0c\u652f\u63f4\u683cCSV\u3001JSON\u3001Avro\u3001Parquet\u548cORC\u7b49\u591a\u7a2e\u6578\u64da\u683c\u5f0f\uff0c\u4f7f\u7528BigQuery\u670d\u52d9\uff0c\u53ef\u4ee5\u5927\u5927\u7c21\u5316\u6578\u64da\u5206\u6790\u548c\u67e5\u8a62\u7684\u6d41\u7a0b\u3002BigQuery\u6709\u9ad8\u53ef\u7528\u6027\u3001\u9ad8\u6548\u7387\u548c\u4f4e\u6210\u672c\u7b49\u512a\u9ede\u3002<\/p>\n\n\n\n<\/div>\n<\/div>\n<div class=\"block block-featured-case-studies margin-large-top padding-large shape-bg-color-right\" id=\"case-studies\">\n    <div class=\"shape-bg-image\"><\/div>\n    <div class=\"container\">\n        <div class=\"block-heading-wrapper d-flex justify-content-between justify-content-lg-start align-items-center\" data-fos=\"fade-up\">\n                            <h2 class=\"block-heading\">\u6210\u529f\u6848\u4f8b\u5206\u4eab<\/h2>\n                        <div class=\"featured-case-studies-slider-control default-slider-arrows-control\"><\/div>\n        <\/div>\n        <div class=\"featured-case-studies-slider slider-default\">\n            <div class=\"featured-case-study-slide rel slide-default\">\n    <div class=\"row featured-case-study-slide-image-wrapper\">\n        <div class=\"col-lg-8 col-xl-7\">\n            <div class=\"featured-case-study-slide-image object-fit-image-wrapper-4-3\">\n                <img loading=\"lazy\" decoding=\"async\" width=\"768\" height=\"392\" src=\"https:\/\/mf-web-plugin-hk.storage.googleapis.com\/wp-content\/uploads\/2021\/08\/customer-stories-ETtoday-A-768x392.jpg\" class=\"attachment-medium_large size-medium_large wp-post-image\" alt=\"customer stories ETtoday\" srcset=\"https:\/\/mf-web-plugin-hk.storage.googleapis.com\/wp-content\/uploads\/2021\/08\/customer-stories-ETtoday-A-768x392.jpg 768w, https:\/\/mf-web-plugin-hk.storage.googleapis.com\/wp-content\/uploads\/2021\/08\/customer-stories-ETtoday-A-300x153.jpg 300w, https:\/\/mf-web-plugin-hk.storage.googleapis.com\/wp-content\/uploads\/2021\/08\/customer-stories-ETtoday-A-1024x523.jpg 1024w, https:\/\/mf-web-plugin-hk.storage.googleapis.com\/wp-content\/uploads\/2021\/08\/customer-stories-ETtoday-A-1536x784.jpg 1536w, https:\/\/mf-web-plugin-hk.storage.googleapis.com\/wp-content\/uploads\/2021\/08\/customer-stories-ETtoday-A.jpg 1920w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/>            <\/div>\n        <\/div>\n    <\/div>\n    <div class=\"row rel featured-case-study-slide-content-wrapper justify-content-center justify-content-lg-start\">\n        <div class=\"col-sm-11 col-lg-7 col-xl-6 offset-lg-5\">\n            <a href=\"https:\/\/www.microfusion.cloud\/hk\/case-study\/ettoday\/\" class=\"featured-case-study-slide-content\" aria-label=\"Link To Case Study\">\n                <h3 class=\"featured-case-study-slide-title\">\u6771\u68ee\u65b0\u805e\u96f2<\/h3>\n                                <div class=\"description\">\n                    <p>\u63a1\u7528 Google Cloud Interconnect\uff0c\u5e6b\u52a9\u6771\u68ee\u65b0\u805e\u96f2\u6210\u529f\u9023\u7d50\u5730\u7aef\u8207\u96f2\u7aef\u7684\u8a2d\u5099\uff0c\u70ba\u91cd\u5927\u65b0\u805e\u767c\u751f\u7522\u751f\u77ac\u9593\u6d41\u91cf\u72c0\u6cc1\u627e\u5230\u6700\u4f73\u89e3\u6c7a\u65b9\u6848\u3002<\/p>\n                <\/div>\n                <div class=\"row\">\n                    <div class=\"col-6\">\n                                                    <div class=\"featured-case-study-slide-logo\">\n                                <img loading=\"lazy\" decoding=\"async\" width=\"237\" height=\"100\" src=\"https:\/\/mf-web-plugin-hk.storage.googleapis.com\/wp-content\/uploads\/2021\/08\/et-today.png\" class=\"attachment-medium_large size-medium_large\" alt=\"Ettoday logo\" \/>                            <\/div>\n                                            <\/div>\n                    <div class=\"col-6 d-flex align-items-end justify-content-end\">\n                        <span class=\"more-btn-circle-arrow\">Learn more<\/span>\n                    <\/div>\n                <\/div>\n            <\/a>\n        <\/div>\n    <\/div>\n<\/div><div class=\"featured-case-study-slide rel slide-default\">\n    <div class=\"row featured-case-study-slide-image-wrapper\">\n        <div class=\"col-lg-8 col-xl-7\">\n            <div class=\"featured-case-study-slide-image object-fit-image-wrapper-4-3\">\n                <img loading=\"lazy\" decoding=\"async\" width=\"768\" height=\"392\" src=\"https:\/\/mf-web-plugin-hk.storage.googleapis.com\/wp-content\/uploads\/2021\/10\/marie-claire-A-768x392.jpg\" class=\"attachment-medium_large size-medium_large wp-post-image\" alt=\"\" srcset=\"https:\/\/mf-web-plugin-hk.storage.googleapis.com\/wp-content\/uploads\/2021\/10\/marie-claire-A-768x392.jpg 768w, https:\/\/mf-web-plugin-hk.storage.googleapis.com\/wp-content\/uploads\/2021\/10\/marie-claire-A-300x153.jpg 300w, https:\/\/mf-web-plugin-hk.storage.googleapis.com\/wp-content\/uploads\/2021\/10\/marie-claire-A-1024x523.jpg 1024w, https:\/\/mf-web-plugin-hk.storage.googleapis.com\/wp-content\/uploads\/2021\/10\/marie-claire-A-1536x784.jpg 1536w, https:\/\/mf-web-plugin-hk.storage.googleapis.com\/wp-content\/uploads\/2021\/10\/marie-claire-A.jpg 1920w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/>            <\/div>\n        <\/div>\n    <\/div>\n    <div class=\"row rel featured-case-study-slide-content-wrapper justify-content-center justify-content-lg-start\">\n        <div class=\"col-sm-11 col-lg-7 col-xl-6 offset-lg-5\">\n            <a href=\"https:\/\/www.microfusion.cloud\/hk\/case-study\/marieclaire\/\" class=\"featured-case-study-slide-content\" aria-label=\"Link To Case Study\">\n                <h3 class=\"featured-case-study-slide-title\">\u7f8e\u9e97\u4f73\u4eba\u96dc\u8a8c<\/h3>\n                                <div class=\"description\">\n                    <p>\u5f71\u97f3\u7cfb\u7d71\u6578\u4f4d\u5316\u66f4\u65b0\uff0c\u63a7\u5236\u6210\u672c\u5275\u9020\u71df\u6536\uff0c\u570b\u969b\u6307\u6a19\u6027\u6642\u5c1a\u5a92\u9ad4\uff0c\u5c07\u7cfb\u7d71\u5f9e\u50b3\u7d71 IDC \u5347\u7d1a\u8f49\u81f3Google Cloud (GCP)<\/p>\n                <\/div>\n                <div class=\"row\">\n                    <div class=\"col-6\">\n                                                    <div class=\"featured-case-study-slide-logo\">\n                                <img loading=\"lazy\" decoding=\"async\" width=\"240\" height=\"40\" src=\"https:\/\/mf-web-plugin-hk.storage.googleapis.com\/wp-content\/uploads\/2021\/10\/marie-claire-logo-2.png\" class=\"attachment-medium_large size-medium_large\" alt=\"\" \/>                            <\/div>\n                                            <\/div>\n                    <div class=\"col-6 d-flex align-items-end justify-content-end\">\n                        <span class=\"more-btn-circle-arrow\">Learn more<\/span>\n                    <\/div>\n                <\/div>\n            <\/a>\n        <\/div>\n    <\/div>\n<\/div>        <\/div>\n    <\/div>\n<\/div>\n<div class=\"container\">\n    <div class=\"article-content\">","protected":false},"excerpt":{"rendered":"<p>Bigquery \u670d\u52d9\u52a9\u4f60\u5c07\u6d77\u91cf\u6578\u64da\u5316\u7e41\u70ba\u7c21\uff0c\u6dec\u7149\u51fa\u6700\u5177\u5546\u696d\u50f9\u503c\u7684\u524d\u77bb\u8cc7\u8a0a<\/p>\n","protected":false},"author":20,"featured_media":16540,"parent":14513,"menu_order":0,"template":"","class_list":["post-14748","cloud_solution","type-cloud_solution","status-publish","has-post-thumbnail","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.microfusion.cloud\/hk\/wp-json\/wp\/v2\/cloud_solution\/14748","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microfusion.cloud\/hk\/wp-json\/wp\/v2\/cloud_solution"}],"about":[{"href":"https:\/\/www.microfusion.cloud\/hk\/wp-json\/wp\/v2\/types\/cloud_solution"}],"author":[{"embeddable":true,"href":"https:\/\/www.microfusion.cloud\/hk\/wp-json\/wp\/v2\/users\/20"}],"up":[{"embeddable":true,"href":"https:\/\/www.microfusion.cloud\/hk\/wp-json\/wp\/v2\/cloud_solution\/14513"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microfusion.cloud\/hk\/wp-json\/wp\/v2\/media\/16540"}],"wp:attachment":[{"href":"https:\/\/www.microfusion.cloud\/hk\/wp-json\/wp\/v2\/media?parent=14748"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}