{"id":7187,"date":"2024-06-13T16:10:26","date_gmt":"2024-06-13T07:10:26","guid":{"rendered":"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/?post_type=technique&#038;p=7187"},"modified":"2024-10-10T13:20:42","modified_gmt":"2024-10-10T04:20:42","slug":"bigquery","status":"publish","type":"technique","link":"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/technique\/bigquery\/","title":{"rendered":"\u30bf\u30b0\u30a4\u30d9\u30f3\u30c8\u30c7\u30fc\u30bf\u3092BigQuery\u306b\u53d6\u308a\u8fbc\u3080"},"content":{"rendered":"\n<p id=\"block-f34a8e6014f44563a6c6f4c4a803a14d\">Content Analytics\u3067\u53d6\u5f97\u3057\u3066\u3044\u308b\u30e6\u30fc\u30b6\u30fc\u306e\u30b3\u30f3\u30c6\u30f3\u30c4\u5358\u4f4d\u30bf\u30b0\u30a4\u30d9\u30f3\u30c8\u30c7\u30fc\u30bf\u306f\u3001\u30c7\u30fc\u30bf\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u6a5f\u80fd\u3092\u4f7f\u3046\u3053\u3068\u3067\u3001CDP\u3084MA\u30c4\u30fc\u30eb\u306a\u3069\u306b\u53d6\u308a\u8fbc\u3093\u3067\u3044\u305f\u3060\u304f\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-text-align-left has-background\" style=\"background-color:#ebf3f7\">\u8a2d\u5b9a\u306e\u6d41\u308c<\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1920\" height=\"888\" src=\"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-content\/uploads\/2024\/06\/export_to_bigquery_001.avif\" alt=\"\" class=\"wp-image-7188\"\/><\/figure>\n\n\n\n<p class=\"has-text-align-center has-small-font-size\">\u30c7\u30fc\u30bf\u6d3b\u7528\u30a4\u30e1\u30fc\u30b8<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/technique\/bigquery#step1\">\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u4f5c\u6210<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/technique\/bigquery#step2\">\u304a\u5ba2\u69d8\u74b0\u5883\u306eCloud Storage\u306b\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u4f5c\u6210\u6a29\u9650\u3092\u4ed8\u4e0e<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/technique\/bigquery#step3\">\u30b3\u30f3\u30c6\u30f3\u30c4\u540d\u767b\u9332<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/technique\/bigquery#step4\">\u30c7\u30fc\u30bf\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\uff08AM2:00-6:00\u306e\u9593\u3067\u81ea\u52d5\u5b9f\u884c\uff09<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/technique\/bigquery#step5\">\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u30d5\u30a1\u30a4\u30eb\u3092\u304a\u5ba2\u69d8\u74b0\u5883\u306eCloud Storage\u306b\u30b3\u30d4\u30fc<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/technique\/bigquery#step6\">BigQuery\u306b\u30c7\u30fc\u30bf\u8ee2\u9001<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/technique\/bigquery#step7\">\u5206\u6790\u8005\u306e\u305f\u3081\u306b\u30c7\u30fc\u30bf\u3092\u4e8b\u524d\u52a0\u5de5<\/a><\/li>\n<\/ol>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"step1\">STEP1: \u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u4f5c\u6210<\/h4>\n\n\n\n<p id=\"block-c1bb6c68a49b4ab181d0ee1ac35da4b2\">Content Analytics\u306e \u7d44\u7e54\u7ba1\u7406 &gt; \u30c7\u30fc\u30bf\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u304b\u3089\u3001\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<br>\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u306e\u4f5c\u6210\u65b9\u6cd5\u306f\u4e0b\u8a18\u306e\u6a5f\u80fd\u30ac\u30a4\u30c9\u3092\u3054\u89a7\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<p class=\"has-background\" id=\"block-06787c6f9f6643a2b45606e277e10236\" style=\"background-color:#cccccc\"><strong>\u3010\u6a5f\u80fd\u30ac\u30a4\u30c9\u30ea\u30f3\u30af\u3011<\/strong><br><strong><span style=\"text-decoration: underline;\"><a href=\"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/functionguide\/dataexport\/\" data-type=\"link\" data-id=\"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/functionguide\/dataexport\/\" target=\"_blank\" rel=\"noreferrer noopener\">\u30c7\u30fc\u30bf\u30a8\u30af\u30b9\u30dd\u30fc\u30c8<\/a><\/span><\/strong>\uff1a\u884c\u52d5\u30ed\u30b0\u3084\u3001\u767b\u9332\u6e08\u307f\u306e\u30b3\u30f3\u30c6\u30f3\u30c4\u540d\/\u30b3\u30f3\u30c6\u30f3\u30c4\u30bf\u30b0\u3092\u51fa\u529b\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"has-small-font-size\">\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u4f5c\u6210\u5f8c\u306b\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u30ad\u30fc\u30d5\u30a1\u30a4\u30eb\u306f\u3001\u5916\u90e8\u306b\u6d41\u51fa\u3057\u306a\u3044\u3088\u3046\u306b\u5927\u5207\u306b\u7ba1\u7406\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/li>\n\n\n\n<li class=\"has-small-font-size\">\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u304c\u4f5c\u6210\u3055\u308c\u305f\u3089\u3001\u30a2\u30ab\u30a6\u30f3\u30c8\u306e\u60c5\u5831\u304c\u753b\u9762\u306b\u8868\u793a\u3055\u308c\u307e\u3059\u3002 \u5f8c\u7d9a\u306e\u624b\u9806\u3067\u4f7f\u3046\u305f\u3081\u3001\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u306e\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u3068\u3001GCS\u30d0\u30b1\u30c3\u30c8\u540d\u3092\u30b3\u30d4\u30fc\u3057\u3066\u63a7\u3048\u3066\u304a\u304d\u307e\u3057\u3087\u3046\u3002<\/li>\n<\/ul>\n\n\n\n<p id=\"block-50682cb5bc364dfc87243a1a2ff26cb3\">\u6b21\u306b\u3001\u30bf\u30b0\u30a4\u30d9\u30f3\u30c8\u30c7\u30fc\u30bf\u3092\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u305f\u3044\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u6307\u5b9a\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1920\" height=\"672\" src=\"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-content\/uploads\/2024\/06\/export_to_bigquery_002.avif\" alt=\"\" class=\"wp-image-7191\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p id=\"block-8e5a27c7e07c4b5e9f7352f4d893ce34\">\u3053\u308c\u3067\u3001Content Analytics\u5074\u306e\u8a2d\u5b9a\u306f\u5b8c\u4e86\u3067\u3059\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-alpha-channel-opacity has-background is-style-default\" style=\"background-color:#cccccc;color:#cccccc\"\/>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"step2\">STEP2: \u304a\u5ba2\u69d8\u74b0\u5883\u306eCloud Storage\u306b\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u4f5c\u6210\u6a29\u9650\u3092\u4ed8\u4e0e<\/h4>\n\n\n\n<p id=\"block-9c491adf2a8a4c7399bdd27014ce7a3d\">\u4eca\u56de\u306e\u624b\u9806\u3067\u306f\u3001BigQuery\u3078\u306e\u53d6\u308a\u8fbc\u307f\u306b\u300cBigQuery Data Transfer\u300d\u3092\u4f7f\u7528\u3059\u308b\u305f\u3081\u3001\u304a\u5ba2\u69d8\u74b0\u5883\u306eCloud Storage\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-black-color has-text-color has-link-color wp-elements-8823acb23bbad2b30a40f1fbefbdaefa\" id=\"block-c851bcbba4f6441da308131bc382b8a1\">\u307e\u305a\u3001Cloud Storage\u306b\u30d0\u30b1\u30c3\u30c8\u3092\u4f5c\u6210\u3057\u307e\u3057\u3087\u3046\u3002 \u4eca\u56de\u306e\u624b\u9806\u3067\u306f\u3001\u30d0\u30b1\u30c3\u30c8\u540d\u3092\u300c<strong><font color=\"red\">ca-tagdata-1234abcd<\/font><\/strong>\u300d\u3068\u3057\u307e\u3059\uff08GCS\u30d0\u30b1\u30c3\u30c8\u540d\u306f\u5168\u4e16\u754c\u3067\u30e6\u30cb\u30fc\u30af\u306a\u540d\u79f0\u306b\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\uff09\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1920\" height=\"1362\" src=\"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-content\/uploads\/2024\/06\/export_to_bigquery_003.png\" alt=\"\" class=\"wp-image-7193\" srcset=\"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-content\/uploads\/2024\/06\/export_to_bigquery_003.png 1920w, https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-content\/uploads\/2024\/06\/export_to_bigquery_003-300x213.png 300w, https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-content\/uploads\/2024\/06\/export_to_bigquery_003-1024x726.png 1024w, https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-content\/uploads\/2024\/06\/export_to_bigquery_003-768x545.png 768w, https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-content\/uploads\/2024\/06\/export_to_bigquery_003-1536x1090.png 1536w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/figure>\n\n\n\n<p id=\"block-c71d207e7e8c4d18990079713aac853e\"><br>\u4f5c\u6210\u3057\u305f\u30d0\u30b1\u30c3\u30c8\u306b\u3001<strong>Storage\u7ba1\u7406\u8005<\/strong>\u6a29\u9650\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002 STEP1\u3067\u4f5c\u6210\u3057\u305f\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u306e\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u3092\u8ffd\u52a0\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-flexible-table-block-table is-style-regular\"><table class=\"has-cyan-bluish-gray-background-color has-background\"><tbody><tr><td style=\"background-color:#cccccc\"><strong>\u5165\u529b\u9805\u76ee<\/strong><\/td><td style=\"background-color:#cccccc\"><strong>\u5165\u529b\u5024<\/strong><\/td><\/tr><tr><td style=\"background-color:#cccccc\"><strong>\u65b0\u3057\u3044\u30d7\u30ea\u30f3\u30b7\u30d1\u30eb<\/strong><\/td><td>STEP1\u3067\u4f5c\u6210\u3057\u305f\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u306e\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9<\/td><\/tr><tr><td style=\"background-color:#cccccc\"><strong>\u30ed\u30fc\u30eb<\/strong><\/td><td>Storage \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u7ba1\u7406\u8005 <br>\uff08\u518d\u53d6\u308a\u8fbc\u307f\u6642\u3092\u3057\u305f\u3044\u5834\u5408\u306b\u3001\u4e0a\u66f8\u304d(\u524a\u9664)\u3059\u308b\u305f\u3081\u3001\u7ba1\u7406\u8005\u3068\u3057\u3066\u3044\u308b\uff09<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1920\" height=\"791\" src=\"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-content\/uploads\/2024\/06\/export_to_bigquery_004.avif\" alt=\"\" class=\"wp-image-7194\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-alpha-channel-opacity has-background is-style-default\" style=\"background-color:#cccccc;color:#cccccc\"\/>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"step3\">STEP3: \u5206\u6790\u5bfe\u8c61\u306e\u30b3\u30f3\u30c6\u30f3\u30c4\u540d\u3092\u767b\u9332<\/h4>\n\n\n\n<p id=\"block-7ccf69901cbb4cb9bfe4a485097eeced\">Content Analytics\u3067\u8a8d\u8b58\u6e08\u307f\u306e\u30b3\u30f3\u30c6\u30f3\u30c4\u306f\u3001\u30b3\u30f3\u30c6\u30f3\u30c4\u3092\u8b58\u5225\u3059\u308bID\u304c\u63a1\u756a\u3055\u308c\u3066\u3044\u307e\u3059\u304c\u3001\u30e9\u30f3\u30c0\u30e0\u306a32\u6841\u306e\u6587\u5b57\u5217\u306e\u305f\u3081\u3001\u8996\u8a8d\u6027\u304c\u3088\u304f\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<p id=\"block-b99ae13ba47c4424a9e8b335d417ed48\">\u5206\u6790\u8005\u304c\u30b3\u30f3\u30c6\u30f3\u30c4\u3092\u628a\u63e1\u3057\u3084\u3059\u304f\u3059\u308b\u305f\u3081\u306b\u3001\u5206\u6790\u5bfe\u8c61\u306e\u30b3\u30f3\u30c6\u30f3\u30c4\u306b\u306f\u3001Content Analytics\u4e0a\u3067\u540d\u79f0\u3092\u767b\u9332\u3057\u3066\u304a\u304f\u3053\u3068\u3092\u63a8\u5968\u3057\u307e\u3059\u3002<br>\u25bc\u30b3\u30f3\u30c6\u30f3\u30c4\u540d\u767b\u9332\u65b9\u6cd5\u306f\u3053\u3061\u3089<\/p>\n\n\n\n<p class=\"has-background\" id=\"block-06787c6f9f6643a2b45606e277e10236\" style=\"background-color:#cccccc\"><strong>\u3010\u6a5f\u80fd\u30ac\u30a4\u30c9\u30ea\u30f3\u30af\u3011<\/strong><br><a href=\"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/functionguide\/report\/contentname\/\" data-type=\"link\" data-id=\"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/functionguide\/dataexport\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>\u30b3\u30f3\u30c6\u30f3\u30c4\u540d\u767b\u9332<\/strong><\/a>\uff1a\u5206\u6790\u3092\u3057\u3084\u3059\u304f\u3059\u308b\u305f\u3081\u306b\u5bfe\u8c61\u306e\u30b3\u30f3\u30c6\u30f3\u30c4\u306b\u540d\u524d\u3092\u4ed8\u3051\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-video\"><video height=\"720\" style=\"aspect-ratio: 1124 \/ 720;\" width=\"1124\" controls src=\"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-content\/uploads\/2024\/06\/export_to_bigquery_mov.mov\"><\/video><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-alpha-channel-opacity has-background is-style-default\" style=\"background-color:#cccccc;color:#cccccc\"\/>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"step4\">STEP4: \u30c7\u30fc\u30bf\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\uff08AM2:00-6:00\u306e\u9593\u3067\u81ea\u52d5\u5b9f\u884c\uff09<\/h4>\n\n\n\n<p id=\"block-3992346785d64c82b22b25791f9c4525\">\u30bf\u30b0\u30a4\u30d9\u30f3\u30c8\u306e\u30c7\u30fc\u30bf\u3001\u30b3\u30f3\u30c6\u30f3\u30c4\u30de\u30b9\u30bf\u306e\u30c7\u30fc\u30bf\u3092Cloud Storage\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-alpha-channel-opacity has-background is-style-default\" style=\"background-color:#cccccc;color:#cccccc\"\/>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"step5\">STEP5: \u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u30d5\u30a1\u30a4\u30eb\u3092\u304a\u5ba2\u69d8\u74b0\u5883\u306eCloud Storage\u306b\u30b3\u30d4\u30fc<\/h4>\n\n\n\n<p>\uff11\uff0eGoogle Cloud\u306eSDK\u3092\u4f7f\u7528\u3057\u3001\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3055\u308c\u305f\u30d5\u30a1\u30a4\u30eb\u3092\u3001\u304a\u5ba2\u69d8\u306eCloud Storage\u306b\u30b3\u30d4\u30fc\u3057\u307e\u3059\u3002<br>SDK\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306f<a href=\"https:\/\/cloud.google.com\/sdk\/docs\/install?hl=ja\" target=\"blank\" rel=\"noopener\"><strong>Google Coud\u306e\u30d8\u30eb\u30d7\u30da\u30fc\u30b8<\/strong><\/a>\u3092\u53c2\u8003\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<br>\uff12\uff0eSDK\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u304c\u5b8c\u4e86\u3057\u305f\u3089\u3001\u5b9f\u969b\u306b\u30d5\u30a1\u30a4\u30eb\u3092\u30b3\u30d4\u30fc\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<br>\u307e\u305a\u3001\u30bf\u30fc\u30df\u30ca\u30eb\uff08\u30b3\u30de\u30f3\u30c9\u30d7\u30ed\u30f3\u30d7\u30c8\u306a\u3069\uff09\u3092\u958b\u304d\u3001\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3067\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u8a8d\u8a3c\u3057\u307e\u3059\u3002\u4e0b\u8a18\u306e\u9752\u5b57\u3092\u66f8\u304d\u63db\u3048\u3066\u3054\u5229\u7528\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gcloud auth activate-service-account {STEP1\u3067\u4f5c\u6210\u3057\u305f\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u306e\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9} --key-file {\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u4f5c\u6210\u6642\u306b\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u305f\u30ad\u30fc\u30d5\u30a1\u30a4\u30eb\u306e\u30d1\u30b9}<\/code><\/pre>\n\n\n\n<p id=\"block-47d06c9383aa431983199cf5ac441834\">\u4ee5\u4e0b\u306e\u30e1\u30c3\u30bb\u30fc\u30b8\u304c\u8868\u793a\u3055\u308c\u308b\u3068\u3001\u8a8d\u8a3c\u6210\u529f\u3067\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Activated service account credentials for: &#91;{STEP1\u3067\u4f5c\u6210\u3057\u305f\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u306e\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9}]<\/code><\/pre>\n\n\n\n<p>\uff13\uff0e\u6b21\u306b\u3001\u30d5\u30a1\u30a4\u30eb\u30b3\u30d4\u30fc\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002 \u30bf\u30b0\u30a4\u30d9\u30f3\u30c8\u30c7\u30fc\u30bf\u306f\u81a8\u5927\u306a\u91cf\u306b\u306a\u308b\u53ef\u80fd\u6027\u304c\u3042\u308b\u305f\u3081\u3001\u5bfe\u8c61\u65e5\u4ed8\u3092\u6307\u5b9a\u3059\u308b\u65b9\u6cd5\u3092\u5171\u6709\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gsutil -m cp -r gs:\/\/{STEP1\u3067\u4f5c\u6210\u3055\u308c\u305fGCS\u30d0\u30b1\u30c3\u30c8\u540d}\/projects\/{\u5bfe\u8c61\u30d7\u30ed\u30b8\u30a7\u30af\u30c8ID}\/{\u5bfe\u8c61\u65e5\u4ed8} gs:\/\/{\u304a\u5ba2\u69d8\u74b0\u5883\u306eGCS\u30d0\u30b1\u30c3\u30c8\u540d}<\/code><\/pre>\n\n\n\n<p id=\"block-accd0bf2c544496fabdec95a6d2cef82\">\u203b \u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u5bfe\u8c61\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306eGCS\u30d0\u30b1\u30c3\u30c8\u540d\u3084\u30d7\u30ed\u30b8\u30a7\u30af\u30c8ID\u306f\u4e0b\u8a18\u304b\u3089\u3082\u3054\u78ba\u8a8d\u3044\u305f\u3060\u3051\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"260\" src=\"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-content\/uploads\/2024\/06\/export_to_bigquery_015.avif\" alt=\"\" class=\"wp-image-7277\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1920\" height=\"1277\" src=\"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-content\/uploads\/2024\/06\/export_to_bigquery_005-1.avif\" alt=\"\" class=\"wp-image-7197\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p id=\"block-ba097750a51248ed9fe6ec7306daa35d\">\u4ee5\u4e0b\u306e\u30e1\u30c3\u30bb\u30fc\u30b8\u304c\u8868\u793a\u3055\u308c\u308b\u3068\u3001\u30b3\u30d4\u30fc\u6210\u529f\u3067\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Operation completed over xxx objects\/xxx KiB.<\/code><\/pre>\n\n\n\n<p class=\"has-small-font-size\">\u203b\u6a29\u9650\u30a8\u30e9\u30fc\uff08AccessDeniedException 403\uff09\u3092\u8868\u793a\u3055\u308c\u305f\u5834\u5408\u306f\u3001<a href=\"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/technique\/export_to_bigquery#block-c71d207e7e8c4d18990079713aac853e\" data-type=\"link\" data-id=\"https:\/\/help.contentanalytics.jp\/export_to_bigqueryblock-c71d207e7e8c4d18990079713aac853e\"><strong>\u6a29\u9650<\/strong><\/a>\u304c\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u308b\u304b\u3069\u3046\u304b\u3054\u78ba\u8a8d\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<p id=\"block-0a4d37f2fb32441c95e48b7748922986\">\u307e\u305f\u3001\u5bfe\u8c61\u65e5\u4ed8\u3092\u7d5e\u3089\u305a\u306b\u9023\u643a\u3059\u308b\u5834\u5408\u306f\u3001\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gsutil -m cp -r  gs:\/\/{STEP1\u3067\u4f5c\u6210\u3055\u308c\u305fGCS\u30d0\u30b1\u30c3\u30c8\u540d}\/projects\/{\u5bfe\u8c61\u30d7\u30ed\u30b8\u30a7\u30af\u30c8ID}  gs:\/\/{\u304a\u5ba2\u69d8\u74b0\u5883\u306eGCS\u30d0\u30b1\u30c3\u30c8\u540d}<\/code><\/pre>\n\n\n\n<p><span style=\"color: rgb(55, 53, 47); font-family: Inter, Inter-fallback, Helvetica, &quot;Apple Color Emoji&quot;, &quot;Segoe UI Emoji&quot;, NotoColorEmoji, &quot;Noto Color Emoji&quot;, &quot;Segoe UI Symbol&quot;, &quot;Android Emoji&quot;, EmojiSymbols, -apple-system, BlinkMacSystemFont, &quot;Segoe UI&quot;, Roboto, &quot;Helvetica Neue&quot;, &quot;Noto Sans&quot;, sans-serif;\">\u30b3\u30de\u30f3\u30c9\u304c\u6210\u529f\u3057\u305f\u3089\u3001\u304a\u5ba2\u69d8\u74b0\u5883\u306eCloud Storage\u306b\u30d5\u30a1\u30a4\u30eb\u304c\u5b58\u5728\u3059\u308b\u304b\u78ba\u8a8d\u3057\u307e\u3057\u3087\u3046\u3002<\/span><\/p>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-alpha-channel-opacity has-background is-style-default\" style=\"background-color:#cccccc;color:#cccccc\"\/>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"step6\">STEP6: BigQuery\u306b\u30c7\u30fc\u30bf\u8ee2\u9001<\/h4>\n\n\n\n<p id=\"block-8eef0693841844a7bc3c735afb347ccc\">Cloud Storage\u304b\u3089\u53d6\u308a\u8fbc\u3080BigQuery\u306e\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u30fb\u30c6\u30fc\u30d6\u30eb\u3092\u6e96\u5099\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p id=\"block-44abc36a97fd4574b92b9d7f9a3e33e9\">\u307e\u305a\u306f\u3001\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002 \u4eca\u56de\u306e\u624b\u9806\u3067\u306f\u3001\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u540d\u3092\u300cca_tagdata\u300d\u3068\u3057\u307e\u3059\u3002 \u4e0b\u8a18SQL\u306e\u300c{project_id}\u300d\u306f\u3001\u304a\u5ba2\u69d8\u306eGCP\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8ID\u306b\u66f8\u304d\u63db\u3048\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE SCHEMA `{project_id}.ca_tagdata`;<\/code><\/pre>\n\n\n\n<p id=\"block-e004d373f28e4c30a6830ba5c1b836b1\">\u4ee5\u964d\u306e\u624b\u9806\u3067SQL\u306e\u30b5\u30f3\u30d7\u30eb\u3092\u8f09\u305b\u3066\u3044\u307e\u3059\u304c\u3001\u30d7\u30ed\u30b8\u30a7\u30af\u30c8ID\u3092\u6307\u5b9a\u3057\u3066\u3044\u307e\u305b\u3093\u3002 GCP\u30b3\u30f3\u30bd\u30fc\u30eb\u4e0a\u306e\u9078\u629e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u304c\u8ffd\u52a0\u5bfe\u8c61\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067\u3042\u308b\u304b\u3054\u78ba\u8a8d\u306e\u4e0a\u3001SQL\u3092\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u3082\u3057\u304f\u306f\u3001\u5404SQL\u306b\u30d7\u30ed\u30b8\u30a7\u30af\u30c8ID\u3092\u8ffd\u52a0\u3057\u3066\u3044\u305f\u3060\u3044\u3066\u3082\u69cb\u3044\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<p id=\"block-7dcaf2d488f544c6b4d6fe85b606a008\">\u6b21\u306b\u3001\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u5185\u306b\u8ee2\u9001\u7528\u306e\u30c6\u30fc\u30d6\u30eb\u30923\u3064\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE ca_tagdata.tagdata (\n    event_id STRING NOT NULL OPTIONS(description=\"\u30bf\u30b0\u30a4\u30d9\u30f3\u30c8ID\"),\n    timestamp TIMESTAMP NOT NULL OPTIONS(description=\"\u30a4\u30d9\u30f3\u30c8\u767a\u706b\u65e5\u6642\"),\n    project_id STRING NOT NULL OPTIONS(description=\"\u30d7\u30ed\u30b8\u30a7\u30af\u30c8ID\"),\n    session_id STRING NOT NULL OPTIONS(description=\"\u30bb\u30c3\u30b7\u30e7\u30f3ID\"),\n    view_id STRING NOT NULL OPTIONS(description=\"\u30da\u30fc\u30b8\u30d3\u30e5\u30fcID\"),\n    client_id STRING OPTIONS(description=\"\u30af\u30e9\u30a4\u30a2\u30f3\u30c8ID\"),\n    user_id STRING OPTIONS(description=\"\u30e6\u30fc\u30b6ID\"),\n    normalized_url STRING OPTIONS(description=\"URL(\u6b63\u898f\u5316\u6e08)\"),\n    original_url STRING OPTIONS(description=\"URL(\u6b63\u898f\u5316\u524d)\"),\n    title STRING OPTIONS(description=\"\u30bf\u30a4\u30c8\u30eb\"),\n    device STRING OPTIONS(description=\"\u30c7\u30d0\u30a4\u30b9\"),\n    event_type STRING NOT NULL OPTIONS(description=\"\u30a4\u30d9\u30f3\u30c8\u30bf\u30a4\u30d7\"),\n    content_id STRING OPTIONS(description=\"\u30b3\u30f3\u30c6\u30f3\u30c4ID\"),\n    second INT64 OPTIONS(description=\"\u95b2\u89a7\u79d2\u6570\"),\n    clicks_count INT64 OPTIONS(description=\"\u30af\u30ea\u30c3\u30af\u6570\"),\n    dimension1 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f31\"),\n    dimension2 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f32\"),\n    dimension3 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f33\"),\n    dimension4 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f34\"),\n    dimension5 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f35\"),\n    dimension6 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f36\"),\n    dimension7 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f37\"),\n    dimension8 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f38\"),\n    dimension9 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f39\"),\n    dimension10 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f310\"),\n    dimension11 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f311\"),\n    dimension12 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f312\"),\n    dimension13 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f313\"),\n    dimension14 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f314\"),\n    dimension15 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f315\"),\n    dimension16 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f316\"),\n    dimension17 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f317\"),\n    dimension18 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f318\"),\n    dimension19 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f319\"),\n    dimension20 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f320\"),\n    event_category STRING OPTIONS(description=\"\u30a4\u30d9\u30f3\u30c8\u30ab\u30c6\u30b4\u30ea\"),\n    event_action STRING OPTIONS(description=\"\u30a4\u30d9\u30f3\u30c8\u30a2\u30af\u30b7\u30e7\u30f3\"),\n    event_label STRING OPTIONS(description=\"\u30a4\u30d9\u30f3\u30c8\u30e9\u30d9\u30eb\"),\n    event_value FLOAT64 OPTIONS(description=\"\u30a4\u30d9\u30f3\u30c8\u5024\"),\n    created_at TIMESTAMP NOT NULL OPTIONS(description=\"\u30ec\u30b3\u30fc\u30c9\u767b\u9332\u65e5\u6642\"),\n    updated_at TIMESTAMP NOT NULL OPTIONS(description=\"\u30ec\u30b3\u30fc\u30c9\u66f4\u65b0\u65e5\u6642\"),\n    ssc_id STRING OPTIONS(description=\"\u30b5\u30fc\u30d0\u30b5\u30a4\u30c9Cookie\u3067\u751f\u6210\u3057\u305f\u30af\u30e9\u30a4\u30a2\u30f3\u30c8ID\"),\n) PARTITION BY DATE_TRUNC(timestamp, DAY) CLUSTER BY event_type\n;\n\nCREATE TABLE ca_tagdata.content (\n    content_id STRING NOT NULL OPTIONS(description=\"\u30b3\u30f3\u30c6\u30f3\u30c4ID\"),\n    project_id INT64 NOT NULL OPTIONS(description=\"\u30d7\u30ed\u30b8\u30a7\u30af\u30c8ID\"),\n    url STRING NOT NULL OPTIONS(description=\"URL\"),\n    name STRING NOT NULL OPTIONS(description=\"\u30b3\u30f3\u30c6\u30f3\u30c4\u540d\"),\n    created_at TIMESTAMP NOT NULL OPTIONS(description=\"\u30ec\u30b3\u30fc\u30c9\u767b\u9332\u65e5\u6642\"),\n    updated_at TIMESTAMP NOT NULL OPTIONS(description=\"\u30ec\u30b3\u30fc\u30c9\u66f4\u65b0\u65e5\u6642\"),\n);\n\nCREATE TABLE ca_tagdata.content_tags (\n    content_id STRING NOT NULL OPTIONS(description=\"\u30b3\u30f3\u30c6\u30f3\u30c4ID\"),\n    project_id INT64 NOT NULL OPTIONS(description=\"\u30d7\u30ed\u30b8\u30a7\u30af\u30c8ID\"),\n    name STRING NOT NULL OPTIONS(description=\"\u30bf\u30b0\u540d\"),\n);<\/code><\/pre>\n\n\n\n<p id=\"block-aa7a99dcf17946ff8bd7a89bb318f448\">\u6b21\u306b\u3001Cloud Storage\u306e\u30d5\u30a1\u30a4\u30eb\u3092BigQuery\u306b\u53d6\u308a\u8fbc\u3080\u305f\u3081\u306e\u300c\u30c7\u30fc\u30bf\u8ee2\u9001\u300d\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"851\" height=\"707\" src=\"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-content\/uploads\/2024\/06\/export_to_bigquery_006.png\" alt=\"\" class=\"wp-image-7201\" srcset=\"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-content\/uploads\/2024\/06\/export_to_bigquery_006.png 851w, https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-content\/uploads\/2024\/06\/export_to_bigquery_006-300x249.png 300w, https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-content\/uploads\/2024\/06\/export_to_bigquery_006-768x638.png 768w\" sizes=\"auto, (max-width: 851px) 100vw, 851px\" \/><\/figure>\n\n\n\n<p id=\"block-1d96ff5d2007419993c0c44a9c96a667\"><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>\u307e\u305a\u306f\u3001<strong>\u30bf\u30b0\u30a4\u30d9\u30f3\u30c8\u30c7\u30fc\u30bf\u7528<\/strong>\u306e\u8a2d\u5b9a\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-flexible-table-block-table is-scroll-on-mobile is-style-regular\"><table class=\"has-cyan-bluish-gray-background-color has-background has-fixed-layout\"><tbody><tr><td style=\"background-color:#cccccc;width:30%\"><strong>\u5165\u529b\u9805\u76ee<\/strong><\/td><td colspan=\"2\" style=\"background-color:#cccccc\"><strong>\u5165\u529b\u5024<\/strong><\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\"><strong>\u30bd\u30fc\u30b9\u30bf\u30a4\u30d7<\/strong><\/td><td>Google Cloud Storage<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\"><strong>\u8ee2\u9001\u69cb\u6210\u540d<\/strong><\/td><td>ca_tagdata<\/td><td>\u7ba1\u7406\u3057\u3084\u3059\u3044\u540d\u524d\u3092\u5165\u529b<\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\"><strong>\u30b9\u30b1\u30b8\u30e5\u30fc\u30eb\u30aa\u30d7\u30b7\u30e7\u30f3<\/strong><\/td><td>\u30aa\u30f3\u30c7\u30de\u30f3\u30c9<\/td><td>\u30aa\u30f3\u30c7\u30de\u30f3\u30c9\u306f\u624b\u52d5\u5b9f\u884c<\/td><\/tr><tr><td colspan=\"3\" style=\"background-color:#cccccc;width:30%\"><strong>\u8ee2\u9001\u5148\u306e\u8a2d\u5b9a<\/strong><\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8<\/td><td>ca_tagdata<\/td><td>\u8ee2\u9001\u5148\u306e\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3092\u6307\u5b9a<\/td><\/tr><tr><td colspan=\"3\" style=\"background-color:#cccccc;width:30%\"><strong>\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u306e\u8a73\u7d30<\/strong><\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">Destination table<\/td><td>tagdata<\/td><td>\u8ee2\u9001\u5148\u30c6\u30fc\u30d6\u30eb\u3092\u6307\u5b9a<\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">Cloud Storage URI<\/td><td>{\u304a\u5ba2\u69d8\u74b0\u5883\u306eGCS\u30d0\u30b1\u30c3\u30c8\u540d}\/*\/tagdata_*.csv.gz<\/td><td>10\u6708\u3044\u3063\u3071\u3044\u306e\u30c7\u30fc\u30bf\u3092\u8ee2\u9001\u3057\u305f\u3044\u306a\u3089{\u304a\u5ba2\u69d8\u74b0\u5883\u306eGCS\u30d0\u30b1\u30c3\u30c8\u540d}\/<em>202410*\/tagdata_<\/em>.csv.gz<\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">Write preference<\/td><td>APPEND<\/td><td>\u300cAPPEND\u300d\u306f\u8ffd\u52a0<br>\u6bce\u56de\u4e0a\u66f8\u304d\u3059\u308b\u306a\u3089\u300cMIRROR\u300d\u3092\u9078\u629e<\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">Delete source files after transfer<\/td><td>\u30c1\u30a7\u30c3\u30af\u3059\u308b<\/td><td>\u30c7\u30fc\u30bf\u8ffd\u52a0\u5f8c\u306fCloud Storage\u304b\u3089\u30d5\u30a1\u30a4\u30eb\u3092\u524a\u9664\u3057\u307e\u3059\u3002<\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">File format<\/td><td>CSV<\/td><td><\/td><\/tr><tr><td colspan=\"3\" style=\"background-color:#cccccc;width:30%\"><strong>Transfer Options\uff08\u4ee5\u4e0b\u306e\u9805\u76ee\u3092\u5909\u66f4\u3059\u308b\uff09<\/strong><\/td><\/tr><tr><td style=\"background-color:#cccccc\">Number of errors allowed<\/td><td>0<\/td><td>\u7121\u8996\u3067\u304d\u308b\u4e0d\u826f\u30ec\u30b3\u30fc\u30c9\u306e\u6700\u5927\u6570\u3002<\/td><\/tr><tr><td style=\"background-color:#cccccc\">Decimal target types<\/td><td>\u7a7a\u767d<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">Ignore unknown values<\/td><td>\u30c1\u30a7\u30c3\u30af\u3059\u308b<\/td><td>\u30b9\u30ad\u30fc\u30de\u306b\u4e00\u81f4\u3057\u306a\u3044\u5024\u3092\u542b\u3080\u884c\u3092\u53d7\u3051\u5165\u308c\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002\u4e0d\u660e\u306a\u5024\u306f\u7121\u8996\u3055\u308c\u307e\u3059\u3002 CSV \u306e\u5834\u5408\u3001\u884c\u672b\u306e\u4f59\u5206\u306a\u5024\u306f\u7121\u8996\u3055\u308c\u307e\u3059\u3002<\/td><\/tr><tr><td style=\"background-color:#cccccc\">Use avro logical types<\/td><td>\u30c1\u30a7\u30c3\u30af\u3057\u306a\u3044<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc\">Parquet enum as string<\/td><td>\u30c1\u30a7\u30c3\u30af\u3057\u306a\u3044<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc\">Parquet enable list inference<\/td><td>\u30c1\u30a7\u30c3\u30af\u3057\u306a\u3044<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc\">Reference file schema url<\/td><td>\u7a7a\u767d<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">Field delimiter<\/td><td>,<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">Quote character\u3000<\/td><td>\"<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">Header rows to skip<\/td><td>1<\/td><td>1\u884c\u76ee\u306f\u30d8\u30c3\u30c0\u30fc\u306e\u305f\u3081\u30b9\u30ad\u30c3\u30d7\u3059\u308b<\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">Allow quoted newlines<\/td><td>\u30c1\u30a7\u30c3\u30af\u3059\u308b<\/td><td>CSV \u30d5\u30a1\u30a4\u30eb\u5185\u3067\u6539\u884c\u6587\u5b57\u3092\u542b\u3080\u5f15\u7528\u7b26\u3067\u56f2\u307e\u308c\u305f\u30c7\u30fc\u30bf \u30bb\u30af\u30b7\u30e7\u30f3\u3092\u8a31\u53ef\u3057\u307e\u3059\u3002<\/td><\/tr><tr><td style=\"width:30%;background-color:#cccccc\">Allow jagged rows<\/td><td>\u30c1\u30a7\u30c3\u30af\u3059\u308b<\/td><td>\u672b\u5c3e\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u5217\u304c\u6b20\u843d\u3057\u3066\u3044\u308b\u884c\u3092\u53d7\u3051\u5165\u308c\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002\u6b20\u843d\u3057\u3066\u3044\u308b\u5024\u306f null \u3067\u57cb\u3081\u3089\u308c\u307e\u3059\u3002<\/td><\/tr><tr><td style=\"background-color:#cccccc\">Preserve ASCII control characters<\/td><td>\u30c1\u30a7\u30c3\u30af\u3057\u306a\u3044<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc\">Encoding<\/td><td>UTF-8<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc\">\u66f4\u65b0\u30a6\u30a3\u30f3\u30c9\u30a6<\/td><td>\u7a7a\u767d<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc\">\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8<\/td><td>\u7a7a\u767d<\/td><td><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u30c7\u30fc\u30bf\u8ee2\u9001\u60c5\u5831\u3092\u5165\u529b\u3057\u3001\u4fdd\u5b58\u3059\u308b\u3068\u3001\u30c7\u30fc\u30bf\u8ee2\u9001\u5b9f\u884c\u30e6\u30fc\u30b6\u306e\u9078\u629e\u304c\u6c42\u3081\u3089\u308c\u307e\u3059\u3002 \u3053\u3053\u3067\u306f\u3001\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u306f\u306a\u304f\u3001\u304a\u5ba2\u69d8\u81ea\u8eab\u306e\u30e6\u30fc\u30b6\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"455\" height=\"525\" src=\"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-content\/uploads\/2024\/06\/export_to_bigquery_007_3.png\" alt=\"\" class=\"wp-image-7280\" srcset=\"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-content\/uploads\/2024\/06\/export_to_bigquery_007_3.png 455w, https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-content\/uploads\/2024\/06\/export_to_bigquery_007_3-260x300.png 260w\" sizes=\"auto, (max-width: 455px) 100vw, 455px\" \/><\/figure>\n<\/div>\n\n\n<p id=\"block-8bfbe248fa7e4aec811e7550e590b600\"><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>\u6b21\u306b\u3001<strong>\u30b3\u30f3\u30c6\u30f3\u30c4\u30de\u30b9\u30bf\u7528<\/strong>\u306e\u8a2d\u5b9a\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-flexible-table-block-table is-scroll-on-mobile is-style-regular\"><table class=\"has-cyan-bluish-gray-background-color has-background has-fixed-layout\"><tbody><tr><td style=\"background-color:#cccccc;width:30%\"><strong>\u5165\u529b\u9805\u76ee<\/strong><\/td><td colspan=\"2\" style=\"background-color:#cccccc\"><strong>\u5165\u529b\u5024<\/strong><\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\"><strong>\u30bd\u30fc\u30b9\u30bf\u30a4\u30d7<\/strong><\/td><td>Google Cloud Storage<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\"><strong>\u8ee2\u9001\u69cb\u6210\u540d<\/strong><\/td><td>ca_content<\/td><td>\u7ba1\u7406\u3057\u3084\u3059\u3044\u540d\u524d\u3092\u5165\u529b<\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\"><strong>\u30b9\u30b1\u30b8\u30e5\u30fc\u30eb\u30aa\u30d7\u30b7\u30e7\u30f3<\/strong><\/td><td>\u30aa\u30f3\u30c7\u30de\u30f3\u30c9<\/td><td>\u30aa\u30f3\u30c7\u30de\u30f3\u30c9\u306f\u624b\u52d5\u5b9f\u884c<\/td><\/tr><tr><td colspan=\"3\" style=\"background-color:#cccccc;width:30%\"><strong>\u8ee2\u9001\u5148\u306e\u8a2d\u5b9a<\/strong><\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8<\/td><td>ca_tagdata<\/td><td>\u8ee2\u9001\u5148\u306e\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3092\u6307\u5b9a<\/td><\/tr><tr><td colspan=\"3\" style=\"background-color:#cccccc;width:30%\"><strong>\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u306e\u8a73\u7d30<\/strong><\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">Destination table<\/td><td>content<\/td><td>\u8ee2\u9001\u5148\u30c6\u30fc\u30d6\u30eb\u3092\u6307\u5b9a<\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">Cloud Storage URI<\/td><td>{\u304a\u5ba2\u69d8\u74b0\u5883\u306eGCS\u30d0\u30b1\u30c3\u30c8\u540d}\/*\/{yyyymmdd}\/contents_*.csv.gz<\/td><td>\u6700\u65b0\u306e\u30d5\u30a1\u30a4\u30eb1\u4ef6\u3067OK\u3001yyyymmdd\u306e\u90e8\u5206\u3092\u66f8\u304d\u63db\u3048\u3066\u304f\u3060\u3055\u3044<\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">Write preference<\/td><td>MIRROR<\/td><td>\u300cAPPEND\u300d\u306f\u8ffd\u52a0<br>\u6bce\u56de\u4e0a\u66f8\u304d\u3059\u308b\u306a\u3089\u300cMIRROR\u300d\u3092\u9078\u629e<\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">Delete source files after transfer<\/td><td>\u30c1\u30a7\u30c3\u30af\u3059\u308b<\/td><td>\u30c7\u30fc\u30bf\u8ffd\u52a0\u5f8c\u306fCloud Storage\u304b\u3089\u30d5\u30a1\u30a4\u30eb\u3092\u524a\u9664\u3057\u307e\u3059\u3002<\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">File format<\/td><td>CSV<\/td><td><\/td><\/tr><tr><td colspan=\"3\" style=\"background-color:#cccccc;width:30%\"><strong>Transfer Options\uff08\u4ee5\u4e0b\u306e\u9805\u76ee\u3092\u5909\u66f4\u3059\u308b\uff09<\/strong><\/td><\/tr><tr><td style=\"background-color:#cccccc\">Number of errors allowed<\/td><td>0<\/td><td>\u7121\u8996\u3067\u304d\u308b\u4e0d\u826f\u30ec\u30b3\u30fc\u30c9\u306e\u6700\u5927\u6570\u3002<\/td><\/tr><tr><td style=\"background-color:#cccccc\">Decimal target types<\/td><td>\u7a7a\u767d<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">Ignore unknown values<\/td><td>\u30c1\u30a7\u30c3\u30af\u3059\u308b<\/td><td>\u30b9\u30ad\u30fc\u30de\u306b\u4e00\u81f4\u3057\u306a\u3044\u5024\u3092\u542b\u3080\u884c\u3092\u53d7\u3051\u5165\u308c\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002\u4e0d\u660e\u306a\u5024\u306f\u7121\u8996\u3055\u308c\u307e\u3059\u3002 CSV \u306e\u5834\u5408\u3001\u884c\u672b\u306e\u4f59\u5206\u306a\u5024\u306f\u7121\u8996\u3055\u308c\u307e\u3059\u3002<\/td><\/tr><tr><td style=\"background-color:#cccccc\">Use avro logical types<\/td><td>\u30c1\u30a7\u30c3\u30af\u3057\u306a\u3044<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc\">Parquet enum as string<\/td><td>\u30c1\u30a7\u30c3\u30af\u3057\u306a\u3044<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc\">Parquet enable list inference<\/td><td>\u30c1\u30a7\u30c3\u30af\u3057\u306a\u3044<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc\">Reference file schema url<\/td><td>\u7a7a\u767d<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">Field delimiter<\/td><td>,<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">Quote character\u3000<\/td><td>\"<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">Header rows to skip<\/td><td>1<\/td><td>1\u884c\u76ee\u306f\u30d8\u30c3\u30c0\u30fc\u306e\u305f\u3081\u30b9\u30ad\u30c3\u30d7\u3059\u308b<\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">Allow quoted newlines<\/td><td>\u30c1\u30a7\u30c3\u30af\u3059\u308b<\/td><td>CSV \u30d5\u30a1\u30a4\u30eb\u5185\u3067\u6539\u884c\u6587\u5b57\u3092\u542b\u3080\u5f15\u7528\u7b26\u3067\u56f2\u307e\u308c\u305f\u30c7\u30fc\u30bf \u30bb\u30af\u30b7\u30e7\u30f3\u3092\u8a31\u53ef\u3057\u307e\u3059\u3002<\/td><\/tr><tr><td style=\"width:30%;background-color:#cccccc\">Allow jagged rows<\/td><td>\u30c1\u30a7\u30c3\u30af\u3059\u308b<\/td><td>\u672b\u5c3e\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u5217\u304c\u6b20\u843d\u3057\u3066\u3044\u308b\u884c\u3092\u53d7\u3051\u5165\u308c\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002\u6b20\u843d\u3057\u3066\u3044\u308b\u5024\u306f null \u3067\u57cb\u3081\u3089\u308c\u307e\u3059\u3002<\/td><\/tr><tr><td style=\"background-color:#cccccc\">Preserve ASCII control characters<\/td><td>\u30c1\u30a7\u30c3\u30af\u3057\u306a\u3044<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc\">Encoding<\/td><td>UTF-8<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc\">\u66f4\u65b0\u30a6\u30a3\u30f3\u30c9\u30a6<\/td><td>\u7a7a\u767d<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc\">\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8<\/td><td>\u7a7a\u767d<\/td><td><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p id=\"block-f505ddc1501148cf86004304e9d05c31\">\u6b21\u306b\u3001<strong>\u30b3\u30f3\u30c6\u30f3\u30c4\u30bf\u30b0\u30c7\u30fc\u30bf\u7528<\/strong>\u306e\u8a2d\u5b9a\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-flexible-table-block-table is-scroll-on-mobile is-style-regular\"><table class=\"has-cyan-bluish-gray-background-color has-background has-fixed-layout\"><tbody><tr><td style=\"background-color:#cccccc;width:30%\"><strong>\u5165\u529b\u9805\u76ee<\/strong><\/td><td colspan=\"2\" style=\"background-color:#cccccc\"><strong>\u5165\u529b\u5024<\/strong><\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\"><strong>\u30bd\u30fc\u30b9\u30bf\u30a4\u30d7<\/strong><\/td><td>Google Cloud Storage<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\"><strong>\u8ee2\u9001\u69cb\u6210\u540d<\/strong><\/td><td>ca_content_tags<\/td><td>\u7ba1\u7406\u3057\u3084\u3059\u3044\u540d\u524d\u3092\u5165\u529b<\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\"><strong>\u30b9\u30b1\u30b8\u30e5\u30fc\u30eb\u30aa\u30d7\u30b7\u30e7\u30f3<\/strong><\/td><td>\u30aa\u30f3\u30c7\u30de\u30f3\u30c9<\/td><td>\u30aa\u30f3\u30c7\u30de\u30f3\u30c9\u306f\u624b\u52d5\u5b9f\u884c<\/td><\/tr><tr><td colspan=\"3\" style=\"background-color:#cccccc;width:30%\"><strong>\u8ee2\u9001\u5148\u306e\u8a2d\u5b9a<\/strong><\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8<\/td><td>ca_tagdata<\/td><td>\u8ee2\u9001\u5148\u306e\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3092\u6307\u5b9a<\/td><\/tr><tr><td colspan=\"3\" style=\"background-color:#cccccc;width:30%\"><strong>\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u306e\u8a73\u7d30<\/strong><\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">Destination table<\/td><td>content_tags<\/td><td>\u8ee2\u9001\u5148\u30c6\u30fc\u30d6\u30eb\u3092\u6307\u5b9a<\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">Cloud Storage URI<\/td><td>{\u304a\u5ba2\u69d8\u74b0\u5883\u306eGCS\u30d0\u30b1\u30c3\u30c8\u540d}\/*\/{yyyymmdd}\/content_tags_*.csv.gz<\/td><td>\u6700\u65b0\u306e\u30d5\u30a1\u30a4\u30eb1\u4ef6\u3067OK\u3001yyyymmdd\u306e\u90e8\u5206\u3092\u66f8\u304d\u63db\u3048\u3066\u304f\u3060\u3055\u3044<\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">Write preference<\/td><td>MIRROR<\/td><td>\u300cAPPEND\u300d\u306f\u8ffd\u52a0<br>\u6bce\u56de\u4e0a\u66f8\u304d\u3059\u308b\u306a\u3089\u300cMIRROR\u300d\u3092\u9078\u629e<\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">Delete source files after transfer<\/td><td>\u30c1\u30a7\u30c3\u30af\u3059\u308b<\/td><td>\u30c7\u30fc\u30bf\u8ffd\u52a0\u5f8c\u306fCloud Storage\u304b\u3089\u30d5\u30a1\u30a4\u30eb\u3092\u524a\u9664\u3057\u307e\u3059\u3002<\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">File format<\/td><td>CSV<\/td><td><\/td><\/tr><tr><td colspan=\"3\" style=\"background-color:#cccccc;width:30%\"><strong>Transfer Options\uff08\u4ee5\u4e0b\u306e\u9805\u76ee\u3092\u5909\u66f4\u3059\u308b\uff09<\/strong><\/td><\/tr><tr><td style=\"background-color:#cccccc\">Number of errors allowed<\/td><td>0<\/td><td>\u7121\u8996\u3067\u304d\u308b\u4e0d\u826f\u30ec\u30b3\u30fc\u30c9\u306e\u6700\u5927\u6570\u3002<\/td><\/tr><tr><td style=\"background-color:#cccccc\">Decimal target types<\/td><td>\u7a7a\u767d<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">Ignore unknown values<\/td><td>\u30c1\u30a7\u30c3\u30af\u3059\u308b<\/td><td>\u30b9\u30ad\u30fc\u30de\u306b\u4e00\u81f4\u3057\u306a\u3044\u5024\u3092\u542b\u3080\u884c\u3092\u53d7\u3051\u5165\u308c\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002\u4e0d\u660e\u306a\u5024\u306f\u7121\u8996\u3055\u308c\u307e\u3059\u3002 CSV \u306e\u5834\u5408\u3001\u884c\u672b\u306e\u4f59\u5206\u306a\u5024\u306f\u7121\u8996\u3055\u308c\u307e\u3059\u3002<\/td><\/tr><tr><td style=\"background-color:#cccccc\">Use avro logical types<\/td><td>\u30c1\u30a7\u30c3\u30af\u3057\u306a\u3044<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc\">Parquet enum as string<\/td><td>\u30c1\u30a7\u30c3\u30af\u3057\u306a\u3044<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc\">Parquet enable list inference<\/td><td>\u30c1\u30a7\u30c3\u30af\u3057\u306a\u3044<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc\">Reference file schema url<\/td><td>\u7a7a\u767d<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">Field delimiter<\/td><td>,<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">Quote character\u3000<\/td><td>\"<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">Header rows to skip<\/td><td>1<\/td><td>1\u884c\u76ee\u306f\u30d8\u30c3\u30c0\u30fc\u306e\u305f\u3081\u30b9\u30ad\u30c3\u30d7\u3059\u308b<\/td><\/tr><tr><td style=\"background-color:#cccccc;width:30%\">Allow quoted newlines<\/td><td>\u30c1\u30a7\u30c3\u30af\u3059\u308b<\/td><td>CSV \u30d5\u30a1\u30a4\u30eb\u5185\u3067\u6539\u884c\u6587\u5b57\u3092\u542b\u3080\u5f15\u7528\u7b26\u3067\u56f2\u307e\u308c\u305f\u30c7\u30fc\u30bf \u30bb\u30af\u30b7\u30e7\u30f3\u3092\u8a31\u53ef\u3057\u307e\u3059\u3002<\/td><\/tr><tr><td style=\"width:30%;background-color:#cccccc\">Allow jagged rows<\/td><td>\u30c1\u30a7\u30c3\u30af\u3059\u308b<\/td><td>\u672b\u5c3e\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u5217\u304c\u6b20\u843d\u3057\u3066\u3044\u308b\u884c\u3092\u53d7\u3051\u5165\u308c\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002\u6b20\u843d\u3057\u3066\u3044\u308b\u5024\u306f null \u3067\u57cb\u3081\u3089\u308c\u307e\u3059\u3002<\/td><\/tr><tr><td style=\"background-color:#cccccc\">Preserve ASCII control characters<\/td><td>\u30c1\u30a7\u30c3\u30af\u3057\u306a\u3044<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc\">Encoding<\/td><td>UTF-8<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc\">\u66f4\u65b0\u30a6\u30a3\u30f3\u30c9\u30a6<\/td><td>\u7a7a\u767d<\/td><td><\/td><\/tr><tr><td style=\"background-color:#cccccc\">\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8<\/td><td>\u7a7a\u767d<\/td><td><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p id=\"block-50fd5204ccf244ef8f7fb8333d593987\">\u30c7\u30fc\u30bf\u8ee2\u9001\u8a2d\u5b9a\u304c\u4f5c\u6210\u3067\u304d\u305f\u3089\u3001\u8ee2\u9001\u3092\u5b9f\u884c\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1920\" height=\"433\" src=\"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-content\/uploads\/2024\/06\/export_to_bigquery_008.avif\" alt=\"\" class=\"wp-image-7261\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1920\" height=\"904\" src=\"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-content\/uploads\/2024\/06\/export_to_bigquery_009.avif\" alt=\"\" class=\"wp-image-7262\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>\u3057\u3070\u3089\u304f\u7d4c\u3064\u3068\u3001\u8ee2\u9001\u304c\u5b8c\u4e86\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1920\" height=\"863\" src=\"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-content\/uploads\/2024\/06\/export_to_bigquery_010.avif\" alt=\"\" class=\"wp-image-7263\" style=\"width:840px;height:auto\"\/><\/figure>\n\n\n\n<p><br>\u5b9f\u884c\u30ed\u30b0\u3092\u898b\u3066\u3001\u6210\u529f\u3057\u305f\u304b\u78ba\u8a8d\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"484\" src=\"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-content\/uploads\/2024\/06\/export_to_bigquery_011.avif\" alt=\"\" class=\"wp-image-7264\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p id=\"block-1f84bc472d2f475492ec88c27bd5b29f\">\u30c7\u30fc\u30bf\u8ee2\u9001\u306e\u5b9f\u884c\u30ed\u30b0\u306b\u4ee5\u4e0b\u306e\u30e1\u30c3\u30bb\u30fc\u30b8\u304c\u8868\u793a\u3055\u308c\u308b\u3068\u3001\u6210\u529f\u3067\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Summary: succeeded xxx jobs, failed 0 jobs.<\/code><\/pre>\n\n\n\n<p id=\"block-7412347704604172b7f3433025e82655\">\u6b21\u306b\u3001BigQuery\u306b\u30c7\u30fc\u30bf\u304c\u767b\u9332\u3055\u308c\u305f\u304b\u3001\u78ba\u8a8d\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1920\" height=\"543\" src=\"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-content\/uploads\/2024\/06\/export_to_bigquery_012.avif\" alt=\"\" class=\"wp-image-7265\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>\u4ee5\u4e0a\u3067\u3001BigQuery\u306b\u30c7\u30fc\u30bf\u3092\u53d6\u308a\u8fbc\u3080\u624b\u9806\u306f\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002 \u3053\u306e\u307e\u307e\u5206\u6790\u306b\u9032\u3093\u3067\u3082\u69cb\u3044\u307e\u305b\u3093\u304c\u3001\u5206\u6790\u8005\u306e\u305f\u3081\u306b\u6b21\u306eSTEP\u3067\u4e8b\u524d\u30c7\u30fc\u30bf\u52a0\u5de5\u3057\u3066\u304a\u304f\u3053\u3068\u3092\u63a8\u5968\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-alpha-channel-opacity has-background is-style-default\" style=\"background-color:#cccccc;color:#cccccc\"\/>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"step7\">STEP7: \u5206\u6790\u8005\u306e\u305f\u3081\u306b\u30c7\u30fc\u30bf\u3092\u4e8b\u524d\u52a0\u5de5<\/h4>\n\n\n\n<p><span style=\"color: rgb(55, 53, 47); font-family: Inter, Inter-fallback, Helvetica, &quot;Apple Color Emoji&quot;, &quot;Segoe UI Emoji&quot;, NotoColorEmoji, &quot;Noto Color Emoji&quot;, &quot;Segoe UI Symbol&quot;, &quot;Android Emoji&quot;, EmojiSymbols, -apple-system, BlinkMacSystemFont, &quot;Segoe UI&quot;, Roboto, &quot;Helvetica Neue&quot;, &quot;Noto Sans&quot;, sans-serif;\">tagdata\u306b\u306f\u3001\u4ee5\u4e0b3\u3064\u306e\u30a4\u30d9\u30f3\u30c8\u304c1\u3064\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u683c\u7d0d\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/span><br>\u30001. \u30da\u30fc\u30b8\u30d3\u30e5\u30fc\u30a4\u30d9\u30f3\u30c8<br>\u30002. \u30b3\u30f3\u30c6\u30f3\u30c4\u30a4\u30d9\u30f3\u30c8<br>\u30003. \u30ab\u30b9\u30bf\u30e0\u30a4\u30d9\u30f3\u30c8<br>\u307e\u305f\u3001\u30c7\u30fc\u30bf\u8ee2\u9001\u306e\u30b3\u30b9\u30c8\u3092\u524a\u6e1b\u3059\u308b\u305f\u3081\u3001\u30da\u30fc\u30b8\u30d3\u30e5\u30fc\u5358\u4f4d\u306e\u30c7\u30fc\u30bf\u306f\u30b3\u30f3\u30c6\u30f3\u30c4\u30a4\u30d9\u30f3\u30c8\u306b\u306f\u4fdd\u6301\u3057\u3066\u3044\u307e\u305b\u3093\uff08\u4f8b: \u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3\u3001\u30e6\u30fc\u30b6ID\u306a\u3069\uff09\u3002<br>\u5206\u6790\u8005\u306e\u5229\u4fbf\u6027\u3092\u8003\u3048\u3066\u3001\u4e8b\u524d\u306b\u30c7\u30fc\u30bf\u52a0\u5de5\u3057\u3066\u304a\u304f\u3053\u3068\u3092\u63a8\u5968\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1920\" height=\"1034\" src=\"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-content\/uploads\/2024\/06\/export_to_bigquery_013.avif\" alt=\"\" class=\"wp-image-7266\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p id=\"block-518d06d419c744ce9a7589a12c8210a8\">\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u5185\u306b\u30a4\u30d9\u30f3\u30c8\u5358\u4f4d\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE ca_tagdata.page_view (\n    event_id STRING NOT NULL OPTIONS(description=\"\u30bf\u30b0\u30a4\u30d9\u30f3\u30c8ID\"),\n    access_date DATE NOT NULL OPTIONS(description=\"\u30a4\u30d9\u30f3\u30c8\u767a\u706b\u65e5\u4ed8\"),\n    timestamp TIMESTAMP NOT NULL OPTIONS(description=\"\u30a4\u30d9\u30f3\u30c8\u767a\u706b\u65e5\u6642\"),\n    project_id STRING NOT NULL OPTIONS(description=\"\u30d7\u30ed\u30b8\u30a7\u30af\u30c8ID\"),\n    session_id STRING NOT NULL OPTIONS(description=\"\u30bb\u30c3\u30b7\u30e7\u30f3ID\"),\n    view_id STRING NOT NULL OPTIONS(description=\"\u30da\u30fc\u30b8\u30d3\u30e5\u30fcID\"),\n    client_id STRING OPTIONS(description=\"\u30af\u30e9\u30a4\u30a2\u30f3\u30c8ID\"),\n    ssc_id STRING OPTIONS(description=\"\u30b5\u30fc\u30d0\u30b5\u30a4\u30c9Cookie\u3067\u751f\u6210\u3057\u305f\u30af\u30e9\u30a4\u30a2\u30f3\u30c8ID\"),\n    user_id STRING OPTIONS(description=\"\u30e6\u30fc\u30b6ID\"),\n    normalized_url STRING OPTIONS(description=\"URL(\u6b63\u898f\u5316\u6e08)\"),\n    original_url STRING OPTIONS(description=\"URL(\u6b63\u898f\u5316\u524d)\"),\n    title STRING OPTIONS(description=\"\u30bf\u30a4\u30c8\u30eb\"),\n    device STRING OPTIONS(description=\"\u30c7\u30d0\u30a4\u30b9\"),\n    dimension1 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f31\"),\n    dimension2 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f32\"),\n    dimension3 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f33\"),\n    dimension4 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f34\"),\n    dimension5 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f35\"),\n    dimension6 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f36\"),\n    dimension7 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f37\"),\n    dimension8 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f38\"),\n    dimension9 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f39\"),\n    dimension10 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f310\"),\n    dimension11 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f311\"),\n    dimension12 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f312\"),\n    dimension13 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f313\"),\n    dimension14 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f314\"),\n    dimension15 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f315\"),\n    dimension16 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f316\"),\n    dimension17 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f317\"),\n    dimension18 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f318\"),\n    dimension19 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f319\"),\n    dimension20 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f320\"),\n    created_at TIMESTAMP NOT NULL OPTIONS(description=\"\u30ec\u30b3\u30fc\u30c9\u767b\u9332\u65e5\u6642\"),\n    updated_at TIMESTAMP NOT NULL OPTIONS(description=\"\u30ec\u30b3\u30fc\u30c9\u66f4\u65b0\u65e5\u6642\"),\n) PARTITION BY access_date\n;\n\nCREATE TABLE ca_tagdata.content_event (\n    event_id STRING NOT NULL OPTIONS(description=\"\u30bf\u30b0\u30a4\u30d9\u30f3\u30c8ID\"),\n    access_date DATE NOT NULL OPTIONS(description=\"\u30a4\u30d9\u30f3\u30c8\u767a\u706b\u65e5\u4ed8\"),\n    timestamp TIMESTAMP NOT NULL OPTIONS(description=\"\u30a4\u30d9\u30f3\u30c8\u767a\u706b\u65e5\u6642\"),\n    project_id STRING NOT NULL OPTIONS(description=\"\u30d7\u30ed\u30b8\u30a7\u30af\u30c8ID\"),\n    session_id STRING NOT NULL OPTIONS(description=\"\u30bb\u30c3\u30b7\u30e7\u30f3ID\"),\n    view_id STRING NOT NULL OPTIONS(description=\"\u30da\u30fc\u30b8\u30d3\u30e5\u30fcID\"),\n    client_id STRING OPTIONS(description=\"\u30af\u30e9\u30a4\u30a2\u30f3\u30c8ID\"),\n    ssc_id STRING OPTIONS(description=\"\u30b5\u30fc\u30d0\u30b5\u30a4\u30c9Cookie\u3067\u751f\u6210\u3057\u305f\u30af\u30e9\u30a4\u30a2\u30f3\u30c8ID\"),\n    user_id STRING OPTIONS(description=\"\u30e6\u30fc\u30b6ID\"),\n    normalized_url STRING OPTIONS(description=\"URL(\u6b63\u898f\u5316\u6e08)\"),\n    original_url STRING OPTIONS(description=\"URL(\u6b63\u898f\u5316\u524d)\"),\n    title STRING OPTIONS(description=\"\u30bf\u30a4\u30c8\u30eb\"),\n    device STRING OPTIONS(description=\"\u30c7\u30d0\u30a4\u30b9\"),\n    content_id STRING OPTIONS(description=\"\u8868\u793a\u7528\u30b3\u30f3\u30c6\u30f3\u30c4ID\"),\n    second INT64 OPTIONS(description=\"\u95b2\u89a7\u79d2\u6570\"),\n    clicks_count INT64 OPTIONS(description=\"\u30af\u30ea\u30c3\u30af\u6570\"),\n    dimension1 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f31\"),\n    dimension2 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f32\"),\n    dimension3 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f33\"),\n    dimension4 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f34\"),\n    dimension5 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f35\"),\n    dimension6 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f36\"),\n    dimension7 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f37\"),\n    dimension8 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f38\"),\n    dimension9 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f39\"),\n    dimension10 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f310\"),\n    dimension11 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f311\"),\n    dimension12 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f312\"),\n    dimension13 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f313\"),\n    dimension14 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f314\"),\n    dimension15 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f315\"),\n    dimension16 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f316\"),\n    dimension17 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f317\"),\n    dimension18 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f318\"),\n    dimension19 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f319\"),\n    dimension20 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f320\"),\n    created_at TIMESTAMP NOT NULL OPTIONS(description=\"\u30ec\u30b3\u30fc\u30c9\u767b\u9332\u65e5\u6642\"),\n    updated_at TIMESTAMP NOT NULL OPTIONS(description=\"\u30ec\u30b3\u30fc\u30c9\u66f4\u65b0\u65e5\u6642\"),\n) PARTITION BY access_date\n;\n\nCREATE TABLE ca_tagdata.custom_event (\n    event_id STRING NOT NULL OPTIONS(description=\"\u30bf\u30b0\u30a4\u30d9\u30f3\u30c8ID\"),\n    access_date DATE NOT NULL OPTIONS(description=\"\u30a4\u30d9\u30f3\u30c8\u767a\u706b\u65e5\u4ed8\"),\n    timestamp TIMESTAMP NOT NULL OPTIONS(description=\"\u30a4\u30d9\u30f3\u30c8\u767a\u706b\u65e5\u6642\"),\n    project_id STRING NOT NULL OPTIONS(description=\"\u30d7\u30ed\u30b8\u30a7\u30af\u30c8ID\"),\n    session_id STRING NOT NULL OPTIONS(description=\"\u30bb\u30c3\u30b7\u30e7\u30f3ID\"),\n    view_id STRING NOT NULL OPTIONS(description=\"\u30da\u30fc\u30b8\u30d3\u30e5\u30fcID\"),\n    client_id STRING OPTIONS(description=\"\u30af\u30e9\u30a4\u30a2\u30f3\u30c8ID\"),\n    ssc_id STRING OPTIONS(description=\"\u30b5\u30fc\u30d0\u30b5\u30a4\u30c9Cookie\u3067\u751f\u6210\u3057\u305f\u30af\u30e9\u30a4\u30a2\u30f3\u30c8ID\"),\n    user_id STRING OPTIONS(description=\"\u30e6\u30fc\u30b6ID\"),\n    normalized_url STRING OPTIONS(description=\"URL(\u6b63\u898f\u5316\u6e08)\"),\n    original_url STRING OPTIONS(description=\"URL(\u6b63\u898f\u5316\u524d)\"),\n    title STRING OPTIONS(description=\"\u30bf\u30a4\u30c8\u30eb\"),\n    device STRING OPTIONS(description=\"\u30c7\u30d0\u30a4\u30b9\"),\n    dimension1 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f31\"),\n    dimension2 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f32\"),\n    dimension3 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f33\"),\n    dimension4 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f34\"),\n    dimension5 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f35\"),\n    dimension6 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f36\"),\n    dimension7 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f37\"),\n    dimension8 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f38\"),\n    dimension9 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f39\"),\n    dimension10 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f310\"),\n    dimension11 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f311\"),\n    dimension12 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f312\"),\n    dimension13 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f313\"),\n    dimension14 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f314\"),\n    dimension15 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f315\"),\n    dimension16 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f316\"),\n    dimension17 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f317\"),\n    dimension18 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f318\"),\n    dimension19 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f319\"),\n    dimension20 STRING OPTIONS(description=\"\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f320\"),\n    event_category STRING OPTIONS(description=\"\u30a4\u30d9\u30f3\u30c8\u30ab\u30c6\u30b4\u30ea\"),\n    event_action STRING OPTIONS(description=\"\u30a4\u30d9\u30f3\u30c8\u30a2\u30af\u30b7\u30e7\u30f3\"),\n    event_label STRING OPTIONS(description=\"\u30a4\u30d9\u30f3\u30c8\u30e9\u30d9\u30eb\"),\n    event_value FLOAT64 OPTIONS(description=\"\u30a4\u30d9\u30f3\u30c8\u5024\"),\n    created_at TIMESTAMP NOT NULL OPTIONS(description=\"\u30ec\u30b3\u30fc\u30c9\u767b\u9332\u65e5\u6642\"),\n    updated_at TIMESTAMP NOT NULL OPTIONS(description=\"\u30ec\u30b3\u30fc\u30c9\u66f4\u65b0\u65e5\u6642\"),\n) PARTITION BY access_date\n;<\/code><\/pre>\n\n\n\n<p id=\"block-9b43b52e802241b1975e2c7261a5f26a\">\u30c6\u30fc\u30d6\u30eb\u306e\u4f5c\u6210\u304c\u5b8c\u4e86\u3057\u305f\u3089\u3001\u5404\u30c6\u30fc\u30d6\u30eb\u306b\u30c7\u30fc\u30bf\u3092\u30b3\u30d4\u30fc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>MERGE ca_tagdata.page_view T\nUSING (\n  SELECT * except(row_num) FROM (\n    SELECT\n      event_id,\n      DATE(timestamp, 'Asia\/Tokyo') AS access_date,\n      timestamp,\n      project_id,\n      session_id,\n      view_id,\n      client_id,\n      ssc_id,\n      user_id,\n      normalized_url,\n      original_url,\n      title,\n      device,\n      dimension1,\n      dimension2,\n      dimension3,\n      dimension4,\n      dimension5,\n      dimension6,\n      dimension7,\n      dimension8,\n      dimension9,\n      dimension10,\n      dimension11,\n      dimension12,\n      dimension13,\n      dimension14,\n      dimension15,\n      dimension16,\n      dimension17,\n      dimension18,\n      dimension19,\n      dimension20,\n      created_at,\n      updated_at,\n      -- \u66f4\u65b0\u30c7\u30fc\u30bf\u304c\u9023\u643a\u3055\u308c\u308b\u30d1\u30bf\u30fc\u30f3\u304c\u3042\u308b\u306e\u3067\u3001\u6700\u7d42\u66f4\u65b0\u30c7\u30fc\u30bf\u306e\u307f\u53d6\u308a\u8fbc\u3080\u7528\u306bROW_NUMBER\u3092\u632f\u308b\n      -- \uff08\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3\u306e\u30b9\u30b3\u30fc\u30d7\"\u30bb\u30c3\u30b7\u30e7\u30f3\"\u306e\u30c7\u30fc\u30bf\u304c\u30bb\u30c3\u30c8\u3055\u308c\u305f\u3001\u306a\u3069\uff09\n      ROW_NUMBER() OVER (\n        PARTITION BY event_id\n        ORDER BY updated_at DESC\n      ) AS row_num,\n    FROM ca_tagdata.tagdata WHERE event_type = 'page_view'\n  )\n  WHERE row_num = 1\n) S ON\n  T.event_id = S.event_id\nWHEN MATCHED THEN UPDATE SET\n  ssc_id = S.ssc_id,\n  user_id = S.user_id,\n  dimension1 = S.dimension1,\n  dimension2 = S.dimension2,\n  dimension3 = S.dimension3,\n  dimension4 = S.dimension4,\n  dimension5 = S.dimension5,\n  dimension6 = S.dimension6,\n  dimension7 = S.dimension7,\n  dimension8 = S.dimension8,\n  dimension9 = S.dimension9,\n  dimension10 = S.dimension10,\n  dimension11 = S.dimension11,\n  dimension12 = S.dimension12,\n  dimension13 = S.dimension13,\n  dimension14 = S.dimension14,\n  dimension15 = S.dimension15,\n  dimension16 = S.dimension16,\n  dimension17 = S.dimension17,\n  dimension18 = S.dimension18,\n  dimension19 = S.dimension19,\n  dimension20 = S.dimension20,\n  updated_at = S.updated_at\nWHEN NOT MATCHED THEN INSERT ROW;\n\n\nMERGE ca_tagdata.content_event T\nUSING (\n  WITH page_views AS (\n    SELECT\n      project_id,\n      session_id,\n      view_id,\n      client_id,\n      ssc_id,\n      user_id,\n      normalized_url,\n      original_url,\n      title,\n      device,\n      dimension1,\n      dimension2,\n      dimension3,\n      dimension4,\n      dimension5,\n      dimension6,\n      dimension7,\n      dimension8,\n      dimension9,\n      dimension10,\n      dimension11,\n      dimension12,\n      dimension13,\n      dimension14,\n      dimension15,\n      dimension16,\n      dimension17,\n      dimension18,\n      dimension19,\n      dimension20,\n    FROM ca_tagdata.page_view\n  )\n  SELECT * except(row_num) FROM (\n    SELECT\n      t.event_id,\n      DATE(t.timestamp, 'Asia\/Tokyo') AS access_date,\n      t.timestamp,\n      t.project_id,\n      t.session_id,\n      t.view_id,\n      pv.client_id,\n      pv.ssc_id,\n      pv.user_id,\n      pv.normalized_url,\n      pv.original_url,\n      pv.title,\n      pv.device,\n      t.content_id,\n      t.second,\n      t.clicks_count,\n      pv.dimension1,\n      pv.dimension2,\n      pv.dimension3,\n      pv.dimension4,\n      pv.dimension5,\n      pv.dimension6,\n      pv.dimension7,\n      pv.dimension8,\n      pv.dimension9,\n      pv.dimension10,\n      pv.dimension11,\n      pv.dimension12,\n      pv.dimension13,\n      pv.dimension14,\n      pv.dimension15,\n      pv.dimension16,\n      pv.dimension17,\n      pv.dimension18,\n      pv.dimension19,\n      pv.dimension20,\n      t.created_at,\n      t.updated_at,\n      -- \u66f4\u65b0\u30c7\u30fc\u30bf\u304c\u9023\u643a\u3055\u308c\u308b\u30d1\u30bf\u30fc\u30f3\u304c\u3042\u308b\u306e\u3067\u3001\u6700\u7d42\u66f4\u65b0\u30c7\u30fc\u30bf\u306e\u307f\u53d6\u308a\u8fbc\u3080\u7528\u306bROW_NUMBER\u3092\u632f\u308b\n      -- \uff08\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3\u306e\u30b9\u30b3\u30fc\u30d7\"\u30bb\u30c3\u30b7\u30e7\u30f3\"\u306e\u30c7\u30fc\u30bf\u304c\u30bb\u30c3\u30c8\u3055\u308c\u305f\u3001\u306a\u3069\uff09\n      ROW_NUMBER() OVER (\n        PARTITION BY t.event_id\n        ORDER BY t.updated_at DESC\n      ) AS row_num,\n    FROM ca_tagdata.tagdata t\n    INNER JOIN page_views pv ON\n      pv.project_id = t.project_id AND\n      pv.session_id = t.session_id AND\n      pv.view_id = t.view_id\n    WHERE t.event_type = 'content_event'\n  )\n  WHERE row_num = 1\n) S ON\n  T.event_id = S.event_id\nWHEN MATCHED THEN UPDATE SET\n  ssc_id = S.ssc_id,\n  user_id = S.user_id,\n  second = CASE WHEN S.second &gt; T.second THEN S.second ELSE T.second END,\n  clicks_count = CASE WHEN S.clicks_count &gt; T.clicks_count THEN S.clicks_count ELSE T.clicks_count END,\n  dimension1 = S.dimension1,\n  dimension2 = S.dimension2,\n  dimension3 = S.dimension3,\n  dimension4 = S.dimension4,\n  dimension5 = S.dimension5,\n  dimension6 = S.dimension6,\n  dimension7 = S.dimension7,\n  dimension8 = S.dimension8,\n  dimension9 = S.dimension9,\n  dimension10 = S.dimension10,\n  dimension11 = S.dimension11,\n  dimension12 = S.dimension12,\n  dimension13 = S.dimension13,\n  dimension14 = S.dimension14,\n  dimension15 = S.dimension15,\n  dimension16 = S.dimension16,\n  dimension17 = S.dimension17,\n  dimension18 = S.dimension18,\n  dimension19 = S.dimension19,\n  dimension20 = S.dimension20,\n  updated_at = S.updated_at\nWHEN NOT MATCHED THEN INSERT ROW;\n\n\nMERGE ca_tagdata.custom_event T\nUSING (\n  WITH page_views AS (\n\t  SELECT\n      project_id,\n      session_id,\n      view_id,\n      client_id,\n      ssc_id,\n      user_id,\n      normalized_url,\n      original_url,\n      title,\n      device,\n      dimension1,\n      dimension2,\n      dimension3,\n      dimension4,\n      dimension5,\n      dimension6,\n      dimension7,\n      dimension8,\n      dimension9,\n      dimension10,\n      dimension11,\n      dimension12,\n      dimension13,\n      dimension14,\n      dimension15,\n      dimension16,\n      dimension17,\n      dimension18,\n      dimension19,\n      dimension20,\n    FROM ca_tagdata.page_view\n\t)\n  SELECT * except(row_num) FROM (\n    SELECT\n      t.event_id,\n      DATE(t.timestamp, 'Asia\/Tokyo') AS access_date,\n      t.timestamp,\n      t.project_id,\n      t.session_id,\n      t.view_id,\n      pv.client_id,\n      pv.ssc_id,\n      pv.user_id,\n      pv.normalized_url,\n      pv.original_url,\n      pv.title,\n      pv.device,\n      pv.dimension1,\n      pv.dimension2,\n      pv.dimension3,\n      pv.dimension4,\n      pv.dimension5,\n      pv.dimension6,\n      pv.dimension7,\n      pv.dimension8,\n      pv.dimension9,\n      pv.dimension10,\n      pv.dimension11,\n      pv.dimension12,\n      pv.dimension13,\n      pv.dimension14,\n      pv.dimension15,\n      pv.dimension16,\n      pv.dimension17,\n      pv.dimension18,\n      pv.dimension19,\n      pv.dimension20,\n      t.event_category,\n      t.event_action,\n      t.event_label,\n      t.event_value,\n      t.created_at,\n      t.updated_at,\n      -- \u66f4\u65b0\u30c7\u30fc\u30bf\u304c\u9023\u643a\u3055\u308c\u308b\u30d1\u30bf\u30fc\u30f3\u304c\u3042\u308b\u306e\u3067\u3001\u6700\u7d42\u66f4\u65b0\u30c7\u30fc\u30bf\u306e\u307f\u53d6\u308a\u8fbc\u3080\u7528\u306bROW_NUMBER\u3092\u632f\u308b\n      -- \uff08\u30ab\u30b9\u30bf\u30e0\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3\u306e\u30b9\u30b3\u30fc\u30d7\"\u30bb\u30c3\u30b7\u30e7\u30f3\"\u306e\u30c7\u30fc\u30bf\u304c\u30bb\u30c3\u30c8\u3055\u308c\u305f\u3001\u306a\u3069\uff09\n      ROW_NUMBER() OVER (\n        PARTITION BY t.event_id\n        ORDER BY t.updated_at DESC\n      ) AS row_num,\n    FROM ca_tagdata.tagdata t\n    INNER JOIN page_views pv ON\n      pv.project_id = t.project_id AND\n      pv.session_id = t.session_id AND\n      pv.view_id = t.view_id\n    WHERE t.event_type = 'custom_event'\n  )\n  WHERE row_num = 1\n) S ON\n  T.event_id = S.event_id\nWHEN MATCHED THEN UPDATE SET\n  ssc_id = S.ssc_id,\n  user_id = S.user_id,\n  dimension1 = S.dimension1,\n  dimension2 = S.dimension2,\n  dimension3 = S.dimension3,\n  dimension4 = S.dimension4,\n  dimension5 = S.dimension5,\n  dimension6 = S.dimension6,\n  dimension7 = S.dimension7,\n  dimension8 = S.dimension8,\n  dimension9 = S.dimension9,\n  dimension10 = S.dimension10,\n  dimension11 = S.dimension11,\n  dimension12 = S.dimension12,\n  dimension13 = S.dimension13,\n  dimension14 = S.dimension14,\n  dimension15 = S.dimension15,\n  dimension16 = S.dimension16,\n  dimension17 = S.dimension17,\n  dimension18 = S.dimension18,\n  dimension19 = S.dimension19,\n  dimension20 = S.dimension20,\n  updated_at = S.updated_at\nWHEN NOT MATCHED THEN INSERT ROW;<\/code><\/pre>\n\n\n\n<p id=\"block-13009ce9ba3443c493579183b854a7c8\">\u5404\u30c6\u30fc\u30d6\u30eb\u3078\u306eSQL\u304c\u6b63\u5e38\u7d42\u4e86\u3057\u305f\u3089\u3001\u5b9f\u969b\u306b\u30c7\u30fc\u30bf\u304c\u767b\u9332\u3067\u304d\u305f\u304b\u78ba\u8a8d\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p id=\"block-e1fdde38272d496582f2755b7983f56b\">\u4ee5\u4e0a\u3067\u3001\u3059\u3079\u3066\u306e\u624b\u9806\u306f\u5b8c\u4e86\u3067\u3059\u3002 <br>\u304a\u75b2\u308c\u69d8\u3067\u3057\u305f\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"Content Analytics\u3067\u53d6\u5f97\u3057\u3066\u3044\u308b\u30e6\u30fc\u30b6\u30fc\u306e\u30b3\u30f3\u30c6\u30f3\u30c4\u5358\u4f4d\u30bf\u30b0\u30a4\u30d9\u30f3\u30c8\u30c7\u30fc\u30bf\u306f\u3001\u30c7\u30fc\u30bf\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u6a5f\u80fd\u3092\u4f7f\u3046\u3053\u3068\u3067\u3001CDP\u3084MA\u30c4\u30fc\u30eb\u306a\u3069\u306b\u53d6\u308a\u8fbc\u3093\u3067\u3044\u305f\u3060\u304f\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002 \u8a2d\u5b9a\u306e\u6d41\u308c \u30c7\u30fc\u30bf\u6d3b\u7528\u30a4\u30e1\u30fc\u30b8 [&hellip;]","protected":false},"author":6,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","format":"standard","meta":{"footnotes":""},"techniquetaxonomy":[23],"class_list":["post-7187","technique","type-technique","status-publish","format-standard","hentry","techniquetaxonomy-report"],"_links":{"self":[{"href":"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-json\/wp\/v2\/technique\/7187","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-json\/wp\/v2\/technique"}],"about":[{"href":"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-json\/wp\/v2\/types\/technique"}],"author":[{"embeddable":true,"href":"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-json\/wp\/v2\/comments?post=7187"}],"version-history":[{"count":27,"href":"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-json\/wp\/v2\/technique\/7187\/revisions"}],"predecessor-version":[{"id":7762,"href":"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-json\/wp\/v2\/technique\/7187\/revisions\/7762"}],"wp:attachment":[{"href":"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-json\/wp\/v2\/media?parent=7187"}],"wp:term":[{"taxonomy":"techniquetaxonomy","embeddable":true,"href":"https:\/\/www.uncovertruth.co.jp\/service\/ca\/help\/wp-json\/wp\/v2\/techniquetaxonomy?post=7187"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}