{"id":70,"date":"2024-09-03T02:21:16","date_gmt":"2024-09-03T02:21:16","guid":{"rendered":"https:\/\/www.nnt-consulting.com\/tech\/blog\/?p=70"},"modified":"2025-09-29T09:44:22","modified_gmt":"2025-09-29T09:44:22","slug":"gcp-bigquery-partitioning","status":"publish","type":"post","link":"https:\/\/www.nnt-consulting.com\/tech\/blog\/gcp-bigquery-partitioning\/","title":{"rendered":"GCP BigQuery Partitioning \uc0b4\ud3b4\ubcf4\uae30"},"content":{"rendered":"<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/bigquery-300x300.png\" alt=\"\" class=\"wp-image-66\" srcset=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/bigquery-300x300.png 300w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/bigquery-150x150.png 150w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/bigquery-500x500.png 500w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/bigquery.png 512w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><figcaption class=\"wp-element-caption\">GCP BigQuery Partitioning \uc0b4\ud3b4\ubcf4\uae30<\/figcaption><\/figure>\n<\/div>\n\n\n<p><\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"\ubaa9\ucc28 \ud1a0\uae00\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/gcp-bigquery-partitioning\/#%EB%93%A4%EC%96%B4%EA%B0%80%EB%A9%B0\" >\ub4e4\uc5b4\uac00\uba70<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/gcp-bigquery-partitioning\/#%ED%8C%8C%ED%8B%B0%EC%85%94%EB%8B%9DPartitioning%EC%9D%B4%EB%9E%80\" >\ud30c\ud2f0\uc154\ub2dd(Partitioning)\uc774\ub780?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/gcp-bigquery-partitioning\/#BigQuery_%ED%8C%8C%ED%8B%B0%EC%85%94%EB%8B%9D%EC%9D%98_%EA%B8%B0%EB%B3%B8_%EA%B0%9C%EB%85%90\" >BigQuery \ud30c\ud2f0\uc154\ub2dd\uc758 \uae30\ubcf8 \uac1c\ub150<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/gcp-bigquery-partitioning\/#%ED%8C%8C%ED%8B%B0%EC%85%98%EC%9C%BC%EB%A1%9C_%EB%82%98%EB%88%88_%ED%85%8C%EC%9D%B4%EB%B8%94%EA%B3%BC_%ED%91%9C%EC%A4%80_%ED%85%8C%EC%9D%B4%EB%B8%94_%EB%B9%84%EA%B5%90\" >\ud30c\ud2f0\uc158\uc73c\ub85c \ub098\ub208 \ud14c\uc774\ube14\uacfc \ud45c\uc900 \ud14c\uc774\ube14 \ube44\uad50<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/gcp-bigquery-partitioning\/#%ED%91%9C%EC%A4%80_%ED%85%8C%EC%9D%B4%EB%B8%94\" >\ud45c\uc900 \ud14c\uc774\ube14<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/gcp-bigquery-partitioning\/#%ED%8C%8C%ED%8B%B0%EC%85%98%EC%9D%84_%EB%82%98%EB%88%88_%ED%85%8C%EC%9D%B4%EB%B8%94Partitioned_Table\" >\ud30c\ud2f0\uc158\uc744 \ub098\ub208 \ud14c\uc774\ube14(Partitioned Table)<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/gcp-bigquery-partitioning\/#Partitioned_Table%EC%9D%B4_%ED%95%84%EC%9A%94%ED%95%9C_%EA%B2%BD%EC%9A%B0\" >Partitioned Table\uc774 \ud544\uc694\ud55c \uacbd\uc6b0<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/gcp-bigquery-partitioning\/#%ED%8C%8C%ED%8B%B0%EC%85%94%EB%8B%9D%EC%9D%B4_%EC%9D%B4%EB%93%9D%EC%9D%B8_%EA%B2%BD%EC%9A%B0\" >\ud30c\ud2f0\uc154\ub2dd\uc774 \uc774\ub4dd\uc778 \uacbd\uc6b0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/gcp-bigquery-partitioning\/#%ED%8C%8C%ED%8B%B0%EC%85%94%EB%8B%9D%EC%9D%B4_%ED%95%84%EC%9A%94%ED%95%98%EC%A7%80_%EC%95%8A%EC%9D%80_%EA%B2%BD%EC%9A%B0\" >\ud30c\ud2f0\uc154\ub2dd\uc774 \ud544\uc694\ud558\uc9c0 \uc54a\uc740 \uacbd\uc6b0<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/gcp-bigquery-partitioning\/#%ED%8C%8C%ED%8B%B0%EC%85%98_%EB%82%98%EB%88%84%EA%B8%B0%EC%9D%98_%EC%9C%A0%ED%98%95\" >\ud30c\ud2f0\uc158 \ub098\ub204\uae30\uc758 \uc720\ud615<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/gcp-bigquery-partitioning\/#1_%EC%8B%9C%EA%B0%84_%EB%8B%A8%EC%9C%84_%EC%97%B4%EB%A1%9C_%ED%8C%8C%ED%8B%B0%EC%85%98_%EB%82%98%EB%88%84%EA%B8%B0\" >1. \uc2dc\uac04 \ub2e8\uc704 \uc5f4\ub85c \ud30c\ud2f0\uc158 \ub098\ub204\uae30<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/gcp-bigquery-partitioning\/#2_%EC%A0%95%EC%88%98_%EB%8B%A8%EC%9C%84_%EC%97%B4%EB%A1%9C_%ED%8C%8C%ED%8B%B0%EC%85%98_%EB%82%98%EB%88%84%EA%B8%B0\" >2. \uc815\uc218 \ub2e8\uc704 \uc5f4\ub85c \ud30c\ud2f0\uc158 \ub098\ub204\uae30<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/gcp-bigquery-partitioning\/#3_%EC%88%98%EC%A7%91_%EC%8B%9C%EA%B0%84_%EA%B8%B0%EC%A4%80%EC%9C%BC%EB%A1%9C_%ED%8C%8C%ED%8B%B0%EC%85%98_%EB%82%98%EB%88%84%EA%B8%B0\" >3. \uc218\uc9d1 \uc2dc\uac04 \uae30\uc900\uc73c\ub85c \ud30c\ud2f0\uc158 \ub098\ub204\uae30<\/a><\/li><\/ul><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/gcp-bigquery-partitioning\/#%EA%B2%B0%EB%A1%A0\" >\uacb0\ub860<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%EB%93%A4%EC%96%B4%EA%B0%80%EB%A9%B0\"><\/span>\ub4e4\uc5b4\uac00\uba70<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\ud604\ub300 \ube44\uc988\ub2c8\uc2a4 \ud658\uacbd\uc5d0\uc11c \ub370\uc774\ud130\ub294 \uac00\uc7a5 \uc911\uc694\ud55c \uc790\uc0b0 \uc911 \ud558\ub098\ub85c \uc790\ub9ac \uc7a1\uc558\uc2b5\ub2c8\ub2e4. \uae30\uc5c5\ub4e4\uc740 \ub370\uc774\ud130 \ubd84\uc11d\uc744 \ud1b5\ud574 \uace0\uac1d\uc758 \ud589\ub3d9\uc744 \uc608\uce21\ud558\uace0, \uc2dc\uc7a5 \ud2b8\ub80c\ub4dc\ub97c \ud30c\uc545\ud558\uba70, \ube44\uc988\ub2c8\uc2a4 \uc804\ub7b5\uc744 \ucd5c\uc801\ud654\ud558\ub294 \ub370 \uc9d1\uc911\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ub370\uc774\ud130 \uc911\uc2ec\uc758 \uc811\uadfc \ubc29\uc2dd\uc5d0\uc11c \uc911\uc694\ud55c \uc5ed\ud560\uc744 \ud558\ub294 \uac83\uc774 \ubc14\ub85c <strong>\ube45\ub370\uc774\ud130 \ubd84\uc11d \ud50c\ub7ab\ud3fc<\/strong>\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>Google BigQuery\ub294 \uc774\ub7ec\ud55c \uc694\uad6c\ub97c \ucda9\uc871\uc2dc\ud0a4\uae30 \uc704\ud574 \uc124\uacc4\ub41c \uac15\ub825\ud55c \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4 \uc194\ub8e8\uc158\uc785\ub2c8\ub2e4. BigQuery\ub294 \ub6f0\uc5b4\ub09c \uc131\ub2a5\uacfc \ud655\uc7a5\uc131\uc744 \uc790\ub791\ud558\uba70, \uae30\uc5c5\ub4e4\uc774 \ub300\uaddc\ubaa8 \ub370\uc774\ud130\ub97c \uc2e4\uc2dc\uac04\uc73c\ub85c \ubd84\uc11d\ud560 \uc218 \uc788\ub3c4\ub85d \uc9c0\uc6d0\ud569\ub2c8\ub2e4. \ud558\uc9c0\ub9cc BigQuery\ub97c \ucd5c\uc801\ud654\ud558\uc5ec \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \uc798 \uc774\ud574\ud558\uc9c0 \ubabb\ud558\uba74, \ub370\uc774\ud130 \ubd84\uc11d\uc758 \uc18d\ub3c4\uc640 \ube44\uc6a9\uc5d0\uc11c \ube44\ud6a8\uc728\uc774 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc774\ubc88 \ube14\ub85c\uadf8 \uae00\uc5d0\uc11c\ub294 BigQuery\uc758 \uc131\ub2a5\uc744 \uadf9\ub300\ud654\ud560 \uc218 \uc788\ub294 \ud575\uc2ec \uae30\ub2a5 \uc911 \ud558\ub098\uc778 <a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/partitioned-tables\" target=\"_blank\" rel=\"noopener\">\ud30c\ud2f0\uc154\ub2dd(Partitioning)<\/a>\uc5d0 \ub300\ud574 \uc18c\uac1c\ud558\uace0\uc790 \ud569\ub2c8\ub2e4. \ud30c\ud2f0\uc154\ub2dd\uc740 \ub370\uc774\ud130 \uc800\uc7a5 \ubc0f \ucffc\ub9ac \ud6a8\uc728\uc131\uc744 \ud06c\uac8c \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\ub294 \ubc29\ubc95\uc73c\ub85c, \uc774\ub97c \uc798 \ud65c\uc6a9\ud558\uba74 \ub370\uc774\ud130 \ubd84\uc11d\uc758 \uc18d\ub3c4\uc640 \ube44\uc6a9\uc744 \ud68d\uae30\uc801\uc73c\ub85c \uac1c\uc120\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%ED%8C%8C%ED%8B%B0%EC%85%94%EB%8B%9DPartitioning%EC%9D%B4%EB%9E%80\"><\/span>\ud30c\ud2f0\uc154\ub2dd(Partitioning)\uc774\ub780?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"BigQuery_%ED%8C%8C%ED%8B%B0%EC%85%94%EB%8B%9D%EC%9D%98_%EA%B8%B0%EB%B3%B8_%EA%B0%9C%EB%85%90\"><\/span>BigQuery \ud30c\ud2f0\uc154\ub2dd\uc758 \uae30\ubcf8 \uac1c\ub150<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\ud30c\ud2f0\uc154\ub2dd\uc740 \ud14c\uc774\ube14\uc744 \ud2b9\uc815 \uae30\uc900\uc5d0 \ub530\ub77c \uc5ec\ub7ec \uac1c\uc758 \uc791\uc740 \ubd80\ubd84(\ud30c\ud2f0\uc158)\uc73c\ub85c \ub098\ub204\ub294 \uac83\uc744 \ub9d0\ud569\ub2c8\ub2e4. \ud30c\ud2f0\uc158\uc744 \uc0ac\uc6a9\ud558\uba74 \ub370\uc774\ud130\uac00 \uc2dc\uac04, \ubc94\uc8fc, \ubc88\ud638 \ub4f1 \ud2b9\uc815 \uae30\uc900\uc5d0 \ub530\ub77c \ubd84\ud560\ub429\ub2c8\ub2e4. \ucffc\ub9ac\ub97c \uc2e4\ud589\ud560 \ub54c, BigQuery\ub294 \uc804\uccb4 \ud14c\uc774\ube14\uc744 \uc2a4\uce94\ud558\uc9c0 \uc54a\uace0 \ucffc\ub9ac\uc5d0 \ud544\uc694\ud55c \ud30c\ud2f0\uc158\ub9cc \uc2a4\uce94\ud569\ub2c8\ub2e4. \uc774\ub294 \ud544\uc694\ud55c \ub370\uc774\ud130\uc758 \ubc94\uc704\ub97c \uc904\uc5ec \ucffc\ub9ac \uc131\ub2a5\uc744 \ud06c\uac8c \ud5a5\uc0c1\uc2dc\ud0b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ub0a0\uc9dc \uae30\ubc18 \ud30c\ud2f0\uc158 \ud14c\uc774\ube14\uc5d0\uc11c \ud2b9\uc815 \ub0a0\uc9dc \ubc94\uc704\uc758 \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\ub294 \uacbd\uc6b0, \ud574\ub2f9 \ub0a0\uc9dc \ubc94\uc704\uc758 \ud30c\ud2f0\uc158\ub9cc \uc2a4\uce94\ud558\uac8c \ub429\ub2c8\ub2e4. \uc774\ub294 \ucffc\ub9ac\uc758 I\/O \ube44\uc6a9\uc744 \uac10\uc18c\uc2dc\ud0a4\uace0 \ucc98\ub9ac \uc18d\ub3c4\ub97c \uc99d\uac00\uc2dc\ud0b5\ub2c8\ub2e4. BigQuery\ub294 \ucc98\ub9ac\ud558\ub294 \ub370\uc774\ud130 \uc591\uc5d0 \ub530\ub77c \ube44\uc6a9\uc774 \ubd80\uacfc<sup data-fn=\"3f83eba8-581e-466d-b503-f833eafe136c\" class=\"fn\"><a id=\"3f83eba8-581e-466d-b503-f833eafe136c-link\" href=\"#3f83eba8-581e-466d-b503-f833eafe136c\">1<\/a><\/sup>\ub418\uae30 \ub54c\ubb38\uc5d0, \ud30c\ud2f0\uc154\ub2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud544\uc694\ud55c \ub370\uc774\ud130\ub9cc \uc2a4\uce94\ud55c\ub2e4\uba74 \uc804\uccb4 \ube44\uc6a9\uc744 \uc808\uac10\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%ED%8C%8C%ED%8B%B0%EC%85%98%EC%9C%BC%EB%A1%9C_%EB%82%98%EB%88%88_%ED%85%8C%EC%9D%B4%EB%B8%94%EA%B3%BC_%ED%91%9C%EC%A4%80_%ED%85%8C%EC%9D%B4%EB%B8%94_%EB%B9%84%EA%B5%90\"><\/span>\ud30c\ud2f0\uc158\uc73c\ub85c \ub098\ub208 \ud14c\uc774\ube14\uacfc \ud45c\uc900 \ud14c\uc774\ube14 \ube44\uad50<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%ED%91%9C%EC%A4%80_%ED%85%8C%EC%9D%B4%EB%B8%94\"><\/span>\ud45c\uc900 \ud14c\uc774\ube14<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\uc608\ub97c \ub4e4\uc5b4, \uc544\ub798\uc640 \uac19\uc740 \ucffc\ub9ac\ub97c \uc0b4\ud3b4\ubd05\uc2dc\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers cbp-highlight-hover\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(1 * 0.6 * .875rem);--cbp-line-highlight-color:rgba(201, 218, 248, 0.2);line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>CREATE OR REPLACE TABLE `TEST_DATASET_US.test_table_not_partitioned` \nAS (\n  SELECT\n    *\n  FROM\n    `bigquery-public-data.google_trends.top_terms`\n  WHERE\n    week BETWEEN \"2015-01-01\" AND \"2024-07-15\"\n);<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">OR<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">REPLACE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">TABLE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">`<\/span><span style=\"color: #A3BE8C\">TEST_DATASET_US.test_table_not_partitioned<\/span><span style=\"color: #ECEFF4\">`<\/span><span style=\"color: #D8DEE9FF\"> <\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">AS<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  <\/span><span style=\"color: #81A1C1\">SELECT<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #81A1C1\">*<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  <\/span><span style=\"color: #81A1C1\">FROM<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #ECEFF4\">`<\/span><span style=\"color: #A3BE8C\">bigquery-public-data.google_trends.top_terms<\/span><span style=\"color: #ECEFF4\">`<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  <\/span><span style=\"color: #81A1C1\">WHERE<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #81A1C1\">week<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">BETWEEN<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #A3BE8C\">2015-01-01<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">AND<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #A3BE8C\">2024-07-15<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">);<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>\uc704 \ucffc\ub9ac\ub294 \ube45\ucffc\ub9ac \ud37c\ube14\ub9ad \ub370\uc774\ud130\uc758 \uad6c\uae00 \ud2b8\ub80c\ub4dc \ub370\uc774\ud130\uc138\ud2b8\uc5d0\uc11c top_terms \ud14c\uc774\ube14\uc744 \uc120\ud0dd\ud558\uc5ec \ud30c\ud2f0\uc158\ub418\uc9c0 \uc54a\uc740 \ud45c\uc900 \ud14c\uc774\ube14\ub85c \ub9cc\ub4dc\ub294 \ucffc\ub9ac\uc785\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \uc0dd\uc131\ub41c \ud14c\uc774\ube14\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>&nbsp;<\/p>\n\n\n<div class=\"wp-block-image wp-image-100 size-full\">\n<figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1780\" height=\"722\" src=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_example_not_partitioned.png\" alt=\"\uadf8\ub9bc 1. \ud30c\ud2f0\uc158 \uc5c6\ub294 \ud45c\uc900 \ud14c\uc774\ube14\uc758 \uc608\uc2dc \ubaa8\uc2b5\" class=\"wp-image-100\" style=\"width:840px;height:auto\" srcset=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_example_not_partitioned.png 1780w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_example_not_partitioned-300x122.png 300w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_example_not_partitioned-1024x415.png 1024w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_example_not_partitioned-768x312.png 768w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_example_not_partitioned-1536x623.png 1536w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_example_not_partitioned-900x365.png 900w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_example_not_partitioned-500x203.png 500w\" sizes=\"auto, (max-width: 1780px) 100vw, 1780px\" \/><figcaption class=\"wp-element-caption\">\uadf8\ub9bc 1. \ud30c\ud2f0\uc158 \uc5c6\ub294 \ud45c\uc900 \ud14c\uc774\ube14\uc758 \uc608\uc2dc \ubaa8\uc2b5<\/figcaption><\/figure>\n<\/div>\n\n\n<p>\uc804\uccb4 \uc6a9\ub7c9\uc740 \uc57d 2.91GB\ub97c \ucc28\uc9c0\ud558\uace0 \uc788\ub294 \uac83\uc744 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n<div class=\"wp-block-image wp-image-101 size-full\">\n<figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"524\" height=\"230\" src=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_storage_info_not_partitioned.png\" alt=\"\uadf8\ub9bc 2. \ud30c\ud2f0\uc158 \uc5c6\ub294 \ud45c\uc900 \ud14c\uc774\ube14\uc758 \uc2a4\ud1a0\ub9ac\uc9c0 \uc815\ubcf4\" class=\"wp-image-101\" style=\"width:310px;height:auto\" srcset=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_storage_info_not_partitioned.png 524w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_storage_info_not_partitioned-300x132.png 300w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_storage_info_not_partitioned-500x219.png 500w\" sizes=\"auto, (max-width: 524px) 100vw, 524px\" \/><figcaption class=\"wp-element-caption\">\uadf8\ub9bc 2. \ud30c\ud2f0\uc158 \uc5c6\ub294 \ud45c\uc900 \ud14c\uc774\ube14\uc758 \uc2a4\ud1a0\ub9ac\uc9c0 \uc815\ubcf4<\/figcaption><\/figure>\n<\/div>\n\n\n<p>\uc704 \ud14c\uc774\ube14\uc5d0\uc11c <code>week<\/code>\uac00 2024\ub144 6\uc6d4 23\uc77c\uc5d0 \ud574\ub2f9\ud558\ub294 \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\uace0 \uc2f6\ub2e4\uace0 \uac00\uc815\ud574 \ubd05\uc2dc\ub2e4. \uc774 \ud14c\uc774\ube14\uc740 \ud30c\ud2f0\uc154\ub2dd\uc774 \ub418\uc5b4\uc788\uc9c0 \uc54a\uae30 \ub54c\ubb38\uc5d0, <code>week=\"2024-06-23\"<\/code>\uc778 \ud589\uc744 \ucc3e\uc73c\ub824\uba74 \ud14c\uc774\ube14\uc758 \ubaa8\ub4e0 \ubd80\ubd84\uc744 \uc870\ud68c\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers cbp-highlight-hover\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(1 * 0.6 * .875rem);--cbp-line-highlight-color:rgba(201, 218, 248, 0.2);line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>SELECT\n  *\nFROM\n  `TEST_DATASET_US.test_table_not_partitioned`\nWHERE\n  week = \"2024-06-23\"<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  <\/span><span style=\"color: #81A1C1\">*<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">FROM<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  <\/span><span style=\"color: #ECEFF4\">`<\/span><span style=\"color: #A3BE8C\">TEST_DATASET_US.test_table_not_partitioned<\/span><span style=\"color: #ECEFF4\">`<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">WHERE<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  <\/span><span style=\"color: #81A1C1\">week<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #A3BE8C\">2024-06-23<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><\/span><\/code><\/pre><\/div>\n\n\n<div class=\"wp-block-image wp-image-108 size-full\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"2356\" height=\"144\" src=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_not_partitioned.png\" alt=\"\uadf8\ub9bc 3. \uc608\uc0c1\ub418\ub294 \ucc98\ub9ac\ub7c9\uc744 \ubbf8\ub9ac \ud655\uc778\ud574 \ubcfc \uc218 \uc788\ub2e4.\" class=\"wp-image-108\" srcset=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_not_partitioned.png 2356w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_not_partitioned-300x18.png 300w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_not_partitioned-1024x63.png 1024w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_not_partitioned-768x47.png 768w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_not_partitioned-1536x94.png 1536w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_not_partitioned-2048x125.png 2048w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_not_partitioned-900x55.png 900w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_not_partitioned-500x31.png 500w\" sizes=\"auto, (max-width: 2356px) 100vw, 2356px\" \/><figcaption class=\"wp-element-caption\">\uadf8\ub9bc 3. \uc608\uc0c1\ub418\ub294 \ucc98\ub9ac\ub7c9\uc744 \ubbf8\ub9ac \ud655\uc778\ud574 \ubcfc \uc218 \uc788\ub2e4.<\/figcaption><\/figure>\n<\/div>\n\n\n<p>&nbsp;<\/p>\n\n\n<div class=\"wp-block-image wp-image-107 size-full\">\n<figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"566\" height=\"332\" src=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_job_info_not_partitioned.png\" alt=\"\uadf8\ub9bc 4. \uc2e4\uc81c\ub85c \ucffc\ub9ac\uac00 \ucc98\ub9ac\/\uccad\uad6c\ud55c \ubc14\uc774\ud2b8. \ud574\ub2f9 \ubc14\uc774\ud2b8\ub97c \uae30\uc900\uc73c\ub85c \ube45\ucffc\ub9ac \ube44\uc6a9\uc774 \uccad\uad6c\ub41c\ub2e4.\" class=\"wp-image-107\" style=\"width:322px;height:auto\" srcset=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_job_info_not_partitioned.png 566w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_job_info_not_partitioned-300x176.png 300w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_job_info_not_partitioned-500x293.png 500w\" sizes=\"auto, (max-width: 566px) 100vw, 566px\" \/><figcaption class=\"wp-element-caption\">\uadf8\ub9bc 4. \uc2e4\uc81c\ub85c \ucffc\ub9ac\uac00 \ucc98\ub9ac\/\uccad\uad6c\ud55c \ubc14\uc774\ud2b8. \ud574\ub2f9 \ubc14\uc774\ud2b8\ub97c \uae30\uc900\uc73c\ub85c \ube45\ucffc\ub9ac \ube44\uc6a9\uc774 \uccad\uad6c\ub41c\ub2e4.<\/figcaption><\/figure>\n<\/div>\n\n\n<p>\ud14c\uc774\ube14 \uc804\uccb4\uac00 \ucc28\uc9c0\ud558\ub294 \uc2a4\ud1a0\ub9ac\uc9c0\uc640 \ucffc\ub9ac\uac00 \ucc98\ub9ac\ud55c \ubc14\uc774\ud2b8\ub97c \ube44\uad50\ud574 \ubcf4\uba74, \ud574\ub2f9 \ucffc\ub9ac\uac00 \uc804\uccb4 \ud14c\uc774\ube14\uc744 \uc870\ud68c\ud588\ub2e4\ub294 \uac83\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n<div class=\"wp-block-image wp-image-106 size-full\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"2326\" height=\"670\" src=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_output_not_partitioned.png\" alt=\"\uadf8\ub9bc 5. \ucffc\ub9ac \uacb0\uacfc \ud14c\uc774\ube14. \uc57d 15.7\ub9cc \uac1c\uc758 \ud589\uc774 \ubc18\ud658\ub418\uc5c8\ub2e4.\" class=\"wp-image-106\" srcset=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_output_not_partitioned.png 2326w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_output_not_partitioned-300x86.png 300w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_output_not_partitioned-1024x295.png 1024w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_output_not_partitioned-768x221.png 768w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_output_not_partitioned-1536x442.png 1536w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_output_not_partitioned-2048x590.png 2048w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_output_not_partitioned-900x259.png 900w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_output_not_partitioned-500x144.png 500w\" sizes=\"auto, (max-width: 2326px) 100vw, 2326px\" \/><figcaption class=\"wp-element-caption\">\uadf8\ub9bc 5. \ucffc\ub9ac \uacb0\uacfc \ud14c\uc774\ube14. \uc57d 15.7\ub9cc \uac1c\uc758 \ud589\uc774 \ubc18\ud658\ub418\uc5c8\ub2e4.<\/figcaption><\/figure>\n<\/div>\n\n\n<p>\uc774\ucc98\ub7fc, \ud30c\ud2f0\uc154\ub2dd\uc774 \ub418\uc9c0 \uc54a\uc740 \ud14c\uc774\ube14\uc5d0\uc11c \ucffc\ub9ac\ud560 \ub54c\ub294 \ud14c\uc774\ube14 \uc804\uccb4\ub97c \uc870\ud68c\ud574\uc57c \ud558\ub294 \uac83\uc744 \ud655\uc778\ud574 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%ED%8C%8C%ED%8B%B0%EC%85%98%EC%9D%84_%EB%82%98%EB%88%88_%ED%85%8C%EC%9D%B4%EB%B8%94Partitioned_Table\"><\/span>\ud30c\ud2f0\uc158\uc744 \ub098\ub208 \ud14c\uc774\ube14(Partitioned Table)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\uc774\ubc88\uc5d0\ub294 <code>week<\/code> \uc5f4\uc744 \uae30\uc900\uc73c\ub85c \ud30c\ud2f0\uc158\uc744 \ub098\ub208 \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uc5b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers cbp-blur-enabled\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(2 * 0.6 * .875rem);--cbp-line-highlight-color:rgba(201, 218, 248, 0.2);line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>CREATE OR REPLACE TABLE `TEST_DATASET_US.test_table_partitioned`\nPARTITION BY\n  week \nAS (\n  SELECT\n    *\n  FROM\n    `bigquery-public-data.google_trends.top_terms`\n  WHERE\n    week BETWEEN \"2015-01-01\" AND \"2024-07-15\"\n);<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">OR<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">REPLACE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">TABLE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">`<\/span><span style=\"color: #A3BE8C\">TEST_DATASET_US.test_table_partitioned<\/span><span style=\"color: #ECEFF4\">`<\/span><\/span>\n<span class=\"line cbp-line-highlight cbp-no-blur\"><span style=\"color: #81A1C1\">PARTITION<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">BY<\/span><\/span>\n<span class=\"line cbp-line-highlight cbp-no-blur\"><span style=\"color: #D8DEE9FF\">  <\/span><span style=\"color: #81A1C1\">week<\/span><span style=\"color: #D8DEE9FF\"> <\/span><\/span>\n<span class=\"line cbp-line-highlight cbp-no-blur\"><span style=\"color: #81A1C1\">AS<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><\/span>\n<span class=\"line cbp-line-highlight cbp-no-blur\"><span style=\"color: #D8DEE9FF\">  <\/span><span style=\"color: #81A1C1\">SELECT<\/span><\/span>\n<span class=\"line cbp-line-highlight cbp-no-blur\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #81A1C1\">*<\/span><\/span>\n<span class=\"line cbp-line-highlight cbp-no-blur\"><span style=\"color: #D8DEE9FF\">  <\/span><span style=\"color: #81A1C1\">FROM<\/span><\/span>\n<span class=\"line cbp-line-highlight cbp-no-blur\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #ECEFF4\">`<\/span><span style=\"color: #A3BE8C\">bigquery-public-data.google_trends.top_terms<\/span><span style=\"color: #ECEFF4\">`<\/span><\/span>\n<span class=\"line cbp-line-highlight cbp-no-blur\"><span style=\"color: #D8DEE9FF\">  <\/span><span style=\"color: #81A1C1\">WHERE<\/span><\/span>\n<span class=\"line cbp-line-highlight cbp-no-blur\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #81A1C1\">week<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">BETWEEN<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #A3BE8C\">2015-01-01<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">AND<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #A3BE8C\">2024-07-15<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><\/span>\n<span class=\"line cbp-line-highlight cbp-no-blur\"><span style=\"color: #D8DEE9FF\">);<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p><code>week<\/code>\uc5f4\uc740 \ub370\uc774\ud130\ud0c0\uc785\uc774 <code>DATE<\/code>\uc774\uae30 \ub54c\ubb38\uc5d0 \ud574\ub2f9 \uc5f4\uc744 \uae30\uc900\uc73c\ub85c \ubc14\ub85c \ud30c\ud2f0\uc158\uc744 \ub098\ub20c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ub9cc\ub4e4\uc5b4\uc9c4 \ud14c\uc774\ube14\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"741\" src=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_example_partitioned-1024x741.jpg\" alt=\"\uadf8\ub9bc 6. \ud30c\ud2f0\uc158\uc744 \ub098\ub208 \ud14c\uc774\ube14\uc758 \uc608\uc2dc \ubaa8\uc2b5\" class=\"wp-image-126\" srcset=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_example_partitioned-1024x741.jpg 1024w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_example_partitioned-300x217.jpg 300w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_example_partitioned-768x556.jpg 768w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_example_partitioned-1536x1112.jpg 1536w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_example_partitioned-2048x1482.jpg 2048w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_example_partitioned-900x651.jpg 900w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_example_partitioned-500x362.jpg 500w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">\uadf8\ub9bc 6. \ud30c\ud2f0\uc158\uc744 \ub098\ub208 \ud14c\uc774\ube14\uc758 \uc608\uc2dc \ubaa8\uc2b5<\/figcaption><\/figure>\n<\/div>\n\n\n<p>&nbsp;\ud30c\ud2f0\uc158\uc5d0 \ub300\ud55c \uba54\ud0c0\ub370\uc774\ud130\ub97c \uc81c\uc678\ud558\uba74 \ud14c\uc774\ube14\uc774 \ucc28\uc9c0\ud558\ub294 \uc6a9\ub7c9\uc740 \ud45c\uc900 \ud14c\uc774\ube14\uacfc \ub2e4\ub974\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"592\" height=\"572\" src=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_storage_info_partitioned.png\" alt=\"\uadf8\ub9bc 7. \ud30c\ud2f0\uc158\uc744 \ub098\ub208 \ud14c\uc774\ube14\uc758 \uc2a4\ud1a0\ub9ac\uc9c0 \uc815\ubcf4\" class=\"wp-image-128\" style=\"width:310px;height:auto\" srcset=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_storage_info_partitioned.png 592w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_storage_info_partitioned-300x290.png 300w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_storage_info_partitioned-500x483.png 500w\" sizes=\"auto, (max-width: 592px) 100vw, 592px\" \/><figcaption class=\"wp-element-caption\">\uadf8\ub9bc 7. \ud30c\ud2f0\uc158\uc744 \ub098\ub208 \ud14c\uc774\ube14\uc758 \uc2a4\ud1a0\ub9ac\uc9c0 \uc815\ubcf4<\/figcaption><\/figure>\n<\/div>\n\n\n<p>\uc774\ubc88\uc5d0\ub294 \ud30c\ud2f0\uc158\uc744 \ub098\ub208 \ud14c\uc774\ube14\uc5d0\uc11c \ub9c8\ucc2c\uac00\uc9c0\ub85c <code>week<\/code>\uac00 2024\ub144 6\uc6d4 23\uc77c\uc5d0 \ud574\ub2f9\ud558\ub294 \ub370\uc774\ud130\ub97c \uc870\ud68c\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers cbp-highlight-hover\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(1 * 0.6 * .875rem);--cbp-line-highlight-color:rgba(201, 218, 248, 0.2);line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>SELECT\n  *\nFROM\n  `TEST_DATASET_US.test_table_partitioned`\nWHERE\n  week = \"2024-06-23\"<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  <\/span><span style=\"color: #81A1C1\">*<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">FROM<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  <\/span><span style=\"color: #ECEFF4\">`<\/span><span style=\"color: #A3BE8C\">TEST_DATASET_US.test_table_partitioned<\/span><span style=\"color: #ECEFF4\">`<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">WHERE<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  <\/span><span style=\"color: #81A1C1\">week<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #A3BE8C\">2024-06-23<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><\/span><\/code><\/pre><\/div>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"63\" src=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_partitioned-1024x63.png\" alt=\"\uadf8\ub9bc 8. \ub9c8\ucc2c\uac00\uc9c0\ub85c \uc608\uc0c1\ub418\ub294 \ucc98\ub9ac\ub7c9\uc744 \ubbf8\ub9ac \ud655\uc778\ud574 \ubcfc \uc218 \uc788\ub2e4.\" class=\"wp-image-125\" srcset=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_partitioned-1024x63.png 1024w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_partitioned-300x18.png 300w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_partitioned-768x47.png 768w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_partitioned-1536x94.png 1536w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_partitioned-2048x125.png 2048w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_partitioned-900x55.png 900w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_partitioned-500x31.png 500w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">\uadf8\ub9bc 8. \ub9c8\ucc2c\uac00\uc9c0\ub85c \uc608\uc0c1\ub418\ub294 \ucc98\ub9ac\ub7c9\uc744 \ubbf8\ub9ac \ud655\uc778\ud574 \ubcfc \uc218 \uc788\ub2e4.<\/figcaption><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"610\" height=\"344\" src=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_job_info_partitioned.png\" alt=\"\" class=\"wp-image-124\" srcset=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_job_info_partitioned.png 610w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_job_info_partitioned-300x169.png 300w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_job_info_partitioned-500x282.png 500w\" sizes=\"auto, (max-width: 610px) 100vw, 610px\" \/><figcaption class=\"wp-element-caption\">\uadf8\ub9bc 9. \uc2e4\uc81c\ub85c \ucffc\ub9ac\uac00 \ucc98\ub9ac\/\uccad\uad6c\ud55c \ubc14\uc774\ud2b8.<\/figcaption><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"368\" src=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_output_partitioned-1024x368.png\" alt=\"\" class=\"wp-image-130\" style=\"width:840px;height:auto\" srcset=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_output_partitioned-1024x368.png 1024w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_output_partitioned-300x108.png 300w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_output_partitioned-768x276.png 768w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_output_partitioned-1536x551.png 1536w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_output_partitioned-2048x735.png 2048w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_output_partitioned-900x323.png 900w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/table_select_query_output_partitioned-500x179.png 500w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">\uadf8\ub9bc 10. \ucffc\ub9ac \uacb0\uacfc \ud14c\uc774\ube14. \uc57d 15.7\ub9cc \uac1c\uc758 \ud589\uc774 \ubc18\ud658\ub418\uc5c8\ub2e4.<\/figcaption><\/figure>\n<\/div>\n\n\n<p>\ud14c\uc774\ube14\uc744 \uc2a4\uce94\ud558\uae30 \uc804\uc5d0 \ud504\ub8e8\ub2dd\uc774 \uc801\uc6a9\ub418\uc5b4, <code>WHERE<\/code>\uc808\uc5d0 \uc801\uc6a9\ud55c \ud544\ud130\uc640 \uc77c\uce58\ud558\uc9c0 \uc54a\ub294 \ud30c\ud2f0\uc158\uc740 \uac74\ub108\ub6f0\uace0 \uc77c\uce58\ud558\ub294 \ud30c\ud2f0\uc158\ub9cc \uc2a4\uce94\ud55c \uac83\uc744 \ud655\uc778\ud574 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"359\" src=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/query_job_compare_not_partitioned-1024x359.png\" alt=\"\" class=\"wp-image-134\" srcset=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/query_job_compare_not_partitioned-1024x359.png 1024w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/query_job_compare_not_partitioned-300x105.png 300w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/query_job_compare_not_partitioned-768x269.png 768w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/query_job_compare_not_partitioned-1536x539.png 1536w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/query_job_compare_not_partitioned-2048x718.png 2048w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/query_job_compare_not_partitioned-900x316.png 900w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/query_job_compare_not_partitioned-500x175.png 500w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"369\" src=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/query_job_compare_partitioned-1024x369.png\" alt=\"\uadf8\ub9bc 11-12. \ud45c\uc900 \ud14c\uc774\ube14 \/ \ud30c\ud2f0\uc158\uc73c\ub85c \ub098\ub208 \ud14c\uc774\ube14\uc758 \uc2e4\ud589 \uc138\ubd80\uc815\ubcf4 \ube44\uad50\" class=\"wp-image-135\" srcset=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/query_job_compare_partitioned-1024x369.png 1024w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/query_job_compare_partitioned-300x108.png 300w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/query_job_compare_partitioned-768x276.png 768w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/query_job_compare_partitioned-1536x553.png 1536w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/query_job_compare_partitioned-2048x737.png 2048w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/query_job_compare_partitioned-900x324.png 900w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/query_job_compare_partitioned-500x180.png 500w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">\uadf8\ub9bc 11-12. \ud45c\uc900 \ud14c\uc774\ube14 \/ \ud30c\ud2f0\uc158\uc73c\ub85c \ub098\ub208 \ud14c\uc774\ube14\uc758 \uc2e4\ud589 \uc138\ubd80\uc815\ubcf4 \ube44\uad50<\/figcaption><\/figure>\n<\/div>\n\n\n<p>\ud45c\uc900 \ud14c\uc774\ube14\uacfc \ud30c\ud2f0\uc158\uc73c\ub85c \ub098\ub208 \ud14c\uc774\ube14\uc758 \uc2e4\ud589 \uc138\ubd80\uc815\ubcf4\ub97c \ube44\uad50\ud574 \ubcf4\uba74, \ud45c\uc900 \ud14c\uc774\ube14\uc5d0\uc11c \ucffc\ub9ac\ud560 \ub54c \uc0ac\uc6a9\ud55c \uc2ac\ub86f \uc2dc\uac04\uacfc \uc77d\uc740 \ub808\ucf54\ub4dc \uc218\uac00 \ud6e8\uc52c \ub354 \ub192\uc740 \uac83\uc744 \ud655\uc778\ud574 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Partitioned_Table%EC%9D%B4_%ED%95%84%EC%9A%94%ED%95%9C_%EA%B2%BD%EC%9A%B0\"><\/span>Partitioned Table\uc774 \ud544\uc694\ud55c \uacbd\uc6b0<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\uadf8\ub807\ub2e4\uba74 \uc5b4\ub5a4 \ub370\uc774\ud130\ub97c \ud30c\ud2f0\uc158\uc73c\ub85c \ub098\ub204\ub294 \uac83\uc774 \uc88b\uc744\uae4c\uc694? \ubaa8\ub4e0 \ud14c\uc774\ube14\uc744 \ubc18\ub4dc\uc2dc \ud30c\ud2f0\uc158\uc73c\ub85c \ub098\ub220\uc57c \ud560\uae4c\uc694? \uadf8\ub807\uc9c0\ub294 \uc54a\uc2b5\ub2c8\ub2e4. \ud30c\ud2f0\uc158\uc73c\ub85c \ub098\ub204\ub294 \uac83\uc774 \ubc18\ub4dc\uc2dc \ud56d\uc0c1 \uc774\ub4dd\uc778 \uac83\uc740 \uc544\ub2c8\uae30 \ub54c\ubb38\uc5d0, \ub370\uc774\ud130\uac00 \uc5b4\ub5a4 \uc885\ub958\uc758 \ub370\uc774\ud130\uc778\uc9c0, \ud574\ub2f9 \ub370\uc774\ud130\uc14b\uc5d0 \ub300\ud55c \ucffc\ub9ac\ub294 \uc8fc\ub85c \uc5b4\ub5a4 \ucffc\ub9ac\uac00 \uc774\ub904\uc9c0\ub294\uc9c0 \ub4f1 \ub2e4\uc591\ud55c \uc0c1\ud669\uc5d0 \ub530\ub77c \ud30c\ud2f0\uc154\ub2dd\uc774 \ud544\uc694\ud55c\uc9c0 \ub530\uc838\ubd10\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%ED%8C%8C%ED%8B%B0%EC%85%94%EB%8B%9D%EC%9D%B4_%EC%9D%B4%EB%93%9D%EC%9D%B8_%EA%B2%BD%EC%9A%B0\"><\/span>\ud30c\ud2f0\uc154\ub2dd\uc774 \uc774\ub4dd\uc778 \uacbd\uc6b0<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\ud14c\uc774\ube14 \uc804\uccb4\uac00 \uc544\ub2cc \uc77c\ubd80\ubd84\uc5d0 \ub300\ud55c \uc2a4\uce94\uc774 \uc790\uc8fc \uc774\ub904\uc838\uc57c \ud558\ub294 \uacbd\uc6b0<\/strong>\n<ul class=\"wp-block-list\">\n<li>\uc704 \uc608\uc2dc\uc5d0\uc11c \ubcf4\uc5ec\uc900 \uac83\ucc98\ub7fc, \ud14c\uc774\ube14\uc5d0\uc11c \ud2b9\uc815\ud55c \uac12\uc744 \uac00\uc9c0\ub294 \ud589\uc744 \uc870\ud68c\ud560 \uc77c\uc774 \ub9ce\uc740 \uacbd\uc6b0\uc5d0 \ud30c\ud2f0\uc154\ub2dd\uc774 \uc774\ub4dd\uc774 \ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ub85c\uadf8 \ub370\uc774\ud130\ub97c \ub0a0\uc9dc\ubcc4\ub85c \uc870\ud68c\ud558\uac70\ub098 \ud2b9\uc815 ID \ubc94\uc704\uc758 \ub370\uc774\ud130\ub97c \uc790\uc8fc \uc870\ud68c\ud558\ub294 \uacbd\uc6b0\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\uc2dc\uac04 \uae30\ubc18 \ub370\uc774\ud130\uac00 \ub9ce\uace0, \ud2b9\uc815 \uae30\uac04\uc758 \ub370\uc774\ud130\ub97c \uc790\uc8fc \uc870\ud68c\ud558\ub294 \uacbd\uc6b0<\/strong>\n<ul class=\"wp-block-list\">\n<li>\uc6f9 \ub85c\uadf8, \ud2b8\ub79c\uc7ad\uc158 \uae30\ub85d, IoT \uc13c\uc11c \ub370\uc774\ud130\uc640 \uac19\uc774 \uc2dc\uac04\uc774 \uc911\uc694\ud55c \ub370\uc774\ud130\ub294 \uc2dc\uac04 \uae30\ubc18\uc73c\ub85c \ud30c\ud2f0\uc154\ub2dd\ud558\uba74 \ud6a8\uc728\uc801\uc785\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ud2b9\uc815 \ub0a0\uc9dc\ub098 \uc6d4\ubcc4 \ub370\uc774\ud130\ub97c \uc870\ud68c\ud560 \ub54c, \ud574\ub2f9 \uae30\uac04\uc758 \ud30c\ud2f0\uc158\ub9cc \uc2a4\uce94\ud558\uba74 \ub418\ubbc0\ub85c \uc131\ub2a5\uc774 \ud06c\uac8c \ud5a5\uc0c1\ub429\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\ub370\uc774\ud130\uac00 \uc8fc\uae30\uc801\uc73c\ub85c \uc5c5\ub370\uc774\ud2b8\ub418\uac70\ub098, \ub370\uc774\ud130 \uc218\uba85\uc774 \uc77c\uc815\ud55c \uacbd\uc6b0<\/strong>\n<ul class=\"wp-block-list\">\n<li>\uc6d4\ubcc4 \ud310\ub9e4 \ub370\uc774\ud130\ub098 \ubd84\uae30\ubcc4 \uc7ac\ubb34 \ub370\uc774\ud130\ucc98\ub7fc \uc8fc\uae30\uc801\uc73c\ub85c \uc5c5\ub370\uc774\ud2b8\ub418\ub294 \ub370\uc774\ud130\ub294 \ud574\ub2f9 \uc8fc\uae30 \uae30\uc900\uc73c\ub85c \ud30c\ud2f0\uc154\ub2dd\ud558\uba74 \uad00\ub9ac\uac00 \uc6a9\uc774\ud569\ub2c8\ub2e4. \ub610\ud55c, \uc77c\uc815 \uae30\uac04\uc774 \uc9c0\ub098\uba74 \uc0ad\uc81c\ub418\ub294 \ub370\uc774\ud130\uc758 \uacbd\uc6b0, \ud30c\ud2f0\uc154\ub2dd\uc744 \ud1b5\ud574 \uc624\ub798\ub41c \ud30c\ud2f0\uc158\uc744 \uc190\uc27d\uac8c \uc0ad\uc81c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\uc815\uc218 \uac12 \ubc94\uc704\uc5d0 \ub530\ub77c \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\ub294 \uacbd\uc6b0\uac00 \ub9ce\uc740 \uacbd\uc6b0<\/strong>\n<ul class=\"wp-block-list\">\n<li>\uace0\uac1d ID, \uc81c\ud488 ID \ub4f1 \uc815\uc218 \uac12 \ubc94\uc704\uc5d0 \ub530\ub77c \ub370\uc774\ud130\ub97c \uc790\uc8fc \uc870\ud68c\ud558\ub294 \uacbd\uc6b0, \uc815\uc218 \ubc94\uc704 \ud30c\ud2f0\uc154\ub2dd\uc744 \ud1b5\ud574 \uc131\ub2a5\uc744 \ucd5c\uc801\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ud2b9\uc815 \uace0\uac1d ID \ubc94\uc704\uc5d0 \ud574\ub2f9\ud558\ub294 \ub370\uc774\ud130\ub97c \uc870\ud68c\ud560 \ub54c \uc720\uc6a9\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\ub370\uc774\ud130\uc758 \ud06c\uae30\uac00 \ub9e4\uc6b0 \ud070 \uacbd\uc6b0<\/strong>\n<ul class=\"wp-block-list\">\n<li>\ub370\uc774\ud130\uc14b\uc774 \ub9e4\uc6b0 \ucee4\uc11c \uc804\uccb4 \ub370\uc774\ud130\ub97c \uc2a4\uce94\ud558\ub294 \ube44\uc6a9\uc774 \ub9e4\uc6b0 \ub192\uc740 \uacbd\uc6b0, \ud30c\ud2f0\uc154\ub2dd\uc744 \ud1b5\ud574 \ucffc\ub9ac \uc131\ub2a5\uc744 \ucd5c\uc801\ud654\ud558\uace0 \ube44\uc6a9\uc744 \uc808\uac10\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub300\uaddc\ubaa8 \ub85c\uadf8 \ub370\uc774\ud130\ub098 \uc18c\uc15c \ubbf8\ub514\uc5b4 \ub370\uc774\ud130, <a href=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/ga4-%ec%9c%a0%ec%a0%80-%ed%96%89%eb%8f%99-%eb%8d%b0%ec%9d%b4%ed%84%b0-%eb%8b%a4%eb%a3%a8%ea%b8%b0\/\">GA4 \ub370\uc774\ud130<\/a>\ub97c \uc608\ub85c \ub4e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%ED%8C%8C%ED%8B%B0%EC%85%94%EB%8B%9D%EC%9D%B4_%ED%95%84%EC%9A%94%ED%95%98%EC%A7%80_%EC%95%8A%EC%9D%80_%EA%B2%BD%EC%9A%B0\"><\/span>\ud30c\ud2f0\uc154\ub2dd\uc774 \ud544\uc694\ud558\uc9c0 \uc54a\uc740 \uacbd\uc6b0<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\ub370\uc774\ud130\uac00 \uc791\uace0, \uc804\uccb4 \ub370\uc774\ud130\ub97c \uc790\uc8fc \uc870\ud68c\ud558\ub294 \uacbd\uc6b0<\/strong>\n<ul class=\"wp-block-list\">\n<li>\ub370\uc774\ud130\uc14b\uc774 \ube44\uad50\uc801 \uc791\uac70\ub098, \ub300\ubd80\ubd84\uc758 \ucffc\ub9ac\uac00 \uc804\uccb4 \ud14c\uc774\ube14\uc744 \ub300\uc0c1\uc73c\ub85c \uc218\ud589\ub418\ub294 \uacbd\uc6b0\uc5d0\ub294 \ud30c\ud2f0\uc154\ub2dd\uc758 \uc774\uc810\uc774 \ud06c\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uc774 \uacbd\uc6b0, \ud30c\ud2f0\uc154\ub2dd\uc73c\ub85c \uc778\ud55c \ucd94\uac00\uc801\uc778 \uad00\ub9ac \ubcf5\uc7a1\uc131\ub9cc \uc99d\uac00\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\ub370\uc774\ud130\uc758 \ubcc0\uacbd\uc774 \ube48\ubc88\ud558\uace0, \ud30c\ud2f0\uc158 \ud0a4\uac00 \uc790\uc8fc \ubc14\ub00c\ub294 \uacbd\uc6b0<\/strong>\n<ul class=\"wp-block-list\">\n<li>\ub370\uc774\ud130\uac00 \ube48\ubc88\ud558\uac8c \ubcc0\uacbd\ub418\uace0, \ud30c\ud2f0\uc158 \ud0a4\uac00 \uc790\uc8fc \ubc14\ub00c\ub294 \uacbd\uc6b0\uc5d0\ub294 \ud30c\ud2f0\uc154\ub2dd\uc758 \uad00\ub9ac\uac00 \ubcf5\uc7a1\ud574\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uacbd\uc6b0, \ud30c\ud2f0\uc154\ub2dd\uc758 \uc774\uc810\uc774 \uac10\uc18c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>2\uac1c \uc774\uc0c1\uc758 \uc5ec\ub7ec \uc5f4\uc5d0 \ub300\ud55c \ud544\ud130\ub9c1\/\uc9d1\uacc4\uac00 \ud544\uc694\ud55c \uacbd\uc6b0<\/strong>\n<ul class=\"wp-block-list\">\n<li>\ud30c\ud2f0\uc154\ub2dd\uc740 1\uac1c \uc5f4\uc5d0 \ub300\ud574\uc11c\ub9cc \uac00\ub2a5\ud558\uae30 \ub54c\ubb38\uc5d0, \uc5ec\ub7ec \uc5f4\uc5d0 \ub300\ud55c \ucffc\ub9ac\ub97c \uc218\ud589\ud574\uc57c \ud558\ub294 \uacbd\uc6b0\uc5d0\ub294 \ud30c\ud2f0\uc154\ub2dd \ub300\uc2e0 \ud074\ub7ec\uc2a4\ud130\ub9c1 \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\ud30c\ud2f0\uc154\ub2dd\uc774 \uc218\ud589\ub418\ub294 \uc5f4\uc758 \uce74\ub514\ub110\ub9ac\ud2f0\uac00 \ub108\ubb34 \ud070 \uacbd\uc6b0<\/strong>\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/cloud.google.com\/bigquery\/quotas?hl=ko#partitioned_tables\" target=\"_blank\" rel=\"noopener\">\uad6c\uae00 \uacf5\uc2dd \ubb38\uc11c<\/a>\uc5d0 \ub530\ub974\uba74 \ud30c\ud2f0\uc158\uc73c\ub85c \ub098\ub208 \ud14c\uc774\ube14\uc5d0\uc11c \uac00\ub2a5\ud55c \ud30c\ud2f0\uc158\uc758 \uac1c\uc218\ub294 \ucd5c\ub300 1\ub9cc \uac1c \uae4c\uc9c0\uc774\uba70, \ub2e8\uc77c \uc791\uc5c5\uc5d0\uc11c\ub294 \ucd5c\ub300 4\ucc9c \uac1c\uc758 \ud30c\ud2f0\uc158\uc5d0\uc11c \uc791\uc5c5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uc218\ubcf4\ub2e4 \ud30c\ud2f0\uc158\uc774 \uc218\ud589\ub420 \uc5f4\uc758 \uce74\ub514\ub110\ub9ac\ud2f0\uac00 \ud074 \uacbd\uc6b0, \ud574\ub2f9 \ud14c\uc774\ube14\uc5d0\ub294 \ud30c\ud2f0\uc154\ub2dd\uc774 \uc801\ud569\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%ED%8C%8C%ED%8B%B0%EC%85%98_%EB%82%98%EB%88%84%EA%B8%B0%EC%9D%98_%EC%9C%A0%ED%98%95\"><\/span>\ud30c\ud2f0\uc158 \ub098\ub204\uae30\uc758 \uc720\ud615<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\uc704 \uc608\uc2dc\uc5d0\uc11c <code>week<\/code>\uc5f4 \ub300\uc2e0 <code>term<\/code>\uc5f4\uc5d0 \ub300\ud574 \ud30c\ud2f0\uc158\uc744 \ub098\ub208 \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4 \uc218 \uc788\uc744\uae4c\uc694? \uc774\uc804 \ucffc\ub9ac\uc5d0\uc11c <code>PARTITION BY<\/code> \ub4a4\uc5d0 <code>week<\/code> \ub300\uc2e0 <code>term<\/code>\uc5f4\uc744 \ub123\uc73c\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \uc5d0\ub7ec\ub97c \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers cbp-highlight-hover\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(1 * 0.6 * .875rem);--cbp-line-highlight-color:rgba(201, 218, 248, 0.2);line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>CREATE OR REPLACE TABLE `TEST_DATASET_US.test_table_partitioned`\nPARTITION BY\n  term\nAS (\n  SELECT\n    *\n  FROM\n    `bigquery-public-data.google_trends.top_terms`\n);<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">OR<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">REPLACE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">TABLE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">`<\/span><span style=\"color: #A3BE8C\">TEST_DATASET_US.test_table_partitioned<\/span><span style=\"color: #ECEFF4\">`<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">PARTITION<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">BY<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  term<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">AS<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  <\/span><span style=\"color: #81A1C1\">SELECT<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #81A1C1\">*<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  <\/span><span style=\"color: #81A1C1\">FROM<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #ECEFF4\">`<\/span><span style=\"color: #A3BE8C\">bigquery-public-data.google_trends.top_terms<\/span><span style=\"color: #ECEFF4\">`<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">);<\/span><\/span><\/code><\/pre><\/div>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"169\" src=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/string_partition_error-1024x169.png\" alt=\"\uadf8\ub9bc 13. term \uc5f4\uc5d0 \ub300\ud574 \ud30c\ud2f0\uc158 \ub098\ub204\uae30\ub97c \uc2dc\ub3c4\ud588\uc744 \uacbd\uc6b0\" class=\"wp-image-139\" style=\"width:840px;height:auto\" srcset=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/string_partition_error-1024x169.png 1024w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/string_partition_error-300x49.png 300w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/string_partition_error-768x127.png 768w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/string_partition_error-1536x253.png 1536w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/string_partition_error-900x148.png 900w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/string_partition_error-500x82.png 500w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/string_partition_error.png 1916w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">\uadf8\ub9bc 13. term \uc5f4\uc5d0 \ub300\ud574 \ud30c\ud2f0\uc158 \ub098\ub204\uae30\ub97c \uc2dc\ub3c4\ud588\uc744 \uacbd\uc6b0<\/figcaption><\/figure>\n<\/div>\n\n\n<p>\uc704\uc5d0\uc11c \ud655\uc778 \uac00\ub2a5\ud55c \uac83\ucc98\ub7fc, \ubaa8\ub4e0 \ub370\uc774\ud130 \ud0c0\uc785\uc5d0 \ub300\ud574 \ud30c\ud2f0\uc158 \ub098\ub204\uae30\uac00 \uac00\ub2a5\ud55c \uac83\uc740 \uc544\ub2d9\ub2c8\ub2e4. \uc5b4\ub5a4 \uc5f4\uc5d0 \ub300\ud574 \ud30c\ud2f0\uc158 \ub098\ub204\uae30\uac00 \uac00\ub2a5\ud560\uae4c\uc694?<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">1. <a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/creating-partitioned-tables?hl=ko#create_a_time-unit_column-partitioned_table\" target=\"_blank\" rel=\"noopener\">\uc2dc\uac04 \ub2e8\uc704 \uc5f4\ub85c \ud30c\ud2f0\uc158 \ub098\ub204\uae30<\/a><\/h4>\n\n\n\n<p>\uac00\uc7a5 \uc77c\ubc18\uc801\uc73c\ub85c \uc0ac\uc6a9\ub418\ub294 \ud30c\ud2f0\uc154\ub2dd \uc720\ud615\uc740 \uc2dc\uac04 \ub2e8\uc704 \uc5f4\uc744 \uae30\uc900\uc73c\ub85c \ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \uc774\ub294 \ub370\uc774\ud130\uac00 \uc2dc\uac04\uc5d0 \ub530\ub77c \ucd95\uc801\ub418\uba70, \uc2dc\uac04 \ubc94\uc704\uc5d0 \ub530\ub77c \ucffc\ub9ac\ud558\ub294 \uacbd\uc6b0\uc5d0 \ub9e4\uc6b0 \uc720\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ud574\ub2f9\ub418\ub294 \ub370\uc774\ud130 \ud0c0\uc785\uc73c\ub85c <code>DATE<\/code>,&nbsp;<code>TIMESTAMP<\/code>&nbsp;\ub610\ub294&nbsp;<code>DATETIME<\/code>\uc774 \uc874\uc7ac\ud558\uba70, \ud574\ub2f9 \ub370\uc774\ud130 \ud0c0\uc785\ubcc4\ub85c <code>_TRUNC<\/code> surfix \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc2dc\uac04, \uc77c\uc77c, \uc8fc\uac04, \uc6d4\uac04, \uc5f0\uac04 \ub4f1 \ub2e4\uc591\ud55c \ubc94\uc704\ub85c \ud30c\ud2f0\uc154\ub2dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ub2e4\uc74c\uc740 <code>TIMESTAMP<\/code> \ub370\uc774\ud130\ud0c0\uc785 \uc5f4\uc5d0 \ub300\ud574 \uc8fc\uac04 \uae30\uc900 \ud30c\ud2f0\uc158\uc744 \ub098\ub208 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\ub294 \ucffc\ub9ac \uc608\uc2dc\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers cbp-highlight-hover\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(1 * 0.6 * .875rem);--cbp-line-highlight-color:rgba(201, 218, 248, 0.2);line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>CREATE TABLE\n  mydataset.newtable (transaction_id INT64, transaction_ts TIMESTAMP)\nPARTITION BY\n  TIMESTAMP_TRUNC(transaction_ts, WEEK)\n  OPTIONS (\n    partition_expiration_days = 3,\n    require_partition_filter = TRUE\n  );<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">TABLE<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  mydataset.newtable (transaction_id INT64, transaction_ts <\/span><span style=\"color: #81A1C1\">TIMESTAMP<\/span><span style=\"color: #D8DEE9FF\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">PARTITION<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">BY<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  TIMESTAMP_TRUNC(transaction_ts, <\/span><span style=\"color: #81A1C1\">WEEK<\/span><span style=\"color: #D8DEE9FF\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  OPTIONS (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    partition_expiration_days <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">3<\/span><span style=\"color: #D8DEE9FF\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    require_partition_filter <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> TRUE<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  );<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">2. <a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/creating-partitioned-tables?hl=ko#create_an_integer-range_partitioned_table\" target=\"_blank\" rel=\"noopener\">\uc815\uc218 \ub2e8\uc704 \uc5f4\ub85c \ud30c\ud2f0\uc158 \ub098\ub204\uae30<\/a><\/h4>\n\n\n\n<p>\uc815\uc218 \ub2e8\uc704 \uc5f4\uc744 \uae30\uc900\uc73c\ub85c \ud30c\ud2f0\uc154\ub2dd\ud558\ub294 \uac83\uc740 \ud2b9\uc815 \uc815\uc218 \uac12 \ubc94\uc704\ub85c \ub370\uc774\ud130\ub97c \ubd84\ud560\ud558\uace0, \ud574\ub2f9 \ubc94\uc704\ub97c \uae30\ubc18\uc73c\ub85c \ucffc\ub9ac\ud560 \ub54c \uc720\uc6a9\ud569\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ud30c\ud2f0\uc154\ub2dd\uc740 \uc8fc\ub85c \uace0\uac1d ID, \uc81c\ud488 ID, \uc8fc\ubb38 \ubc88\ud638 \ub4f1\uacfc \uac19\uc774 \uc815\uc218 \uac12\uc73c\ub85c \uc815\uc758\ub41c \ub370\uc774\ud130\ub97c \ub354 \ud6a8\uc728\uc801\uc73c\ub85c \uad00\ub9ac\ud558\uace0 \ucffc\ub9ac \uc131\ub2a5\uc744 \ucd5c\uc801\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ud574\ub2f9\ub418\ub294 \ub370\uc774\ud130 \ud0c0\uc785\uc73c\ub85c <code>INTEGER<\/code>\ud0c0\uc785\uc774 \uc874\uc7ac\ud558\uba70, \uc815\uc218 \ub2e8\uc704 \uc5f4\ub85c \ud30c\ud2f0\uc154\ub2dd\ud560 \ub54c\ub294 <code>RANGE_BUCKET<\/code> \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud2b9\uc815 \uc815\uc218 \uac12 \ubc94\uc704\ub85c \ub370\uc774\ud130\ub97c \ubd84\ud560\ud55c \ud6c4 \uc815\uc218 \ubc94\uc704\ubcc4\ub85c \ud30c\ud2f0\uc154\ub2dd \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ub2e4\uc74c\uc740 \uace0\uac1d ID\ub97c \uae30\uc900\uc73c\ub85c 1000 \ub2e8\uc704\ub85c \ud30c\ud2f0\uc154\ub2dd\ub41c \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\ub294 \uc608\uc2dc\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers cbp-highlight-hover\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(2 * 0.6 * .875rem);--cbp-line-highlight-color:rgba(201, 218, 248, 0.2);line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>CREATE TABLE \n  mydataset.customer_orders (\n    customer_id INT64,\n    order_id INT64,\n    order_date DATE,\n    total_amount FLOAT64\n  )\nPARTITION BY\n  RANGE_BUCKET(customer_id, GENERATE_ARRAY(0, 10000, 1000))\n  OPTIONS (\n    require_partition_filter = TRUE\n  );<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">TABLE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  mydataset.customer_orders (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    customer_id INT64,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    order_id INT64,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    order_date <\/span><span style=\"color: #81A1C1\">DATE<\/span><span style=\"color: #D8DEE9FF\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    total_amount FLOAT64<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  )<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">PARTITION<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">BY<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  RANGE_BUCKET(customer_id, GENERATE_ARRAY(<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">, <\/span><span style=\"color: #B48EAD\">10000<\/span><span style=\"color: #D8DEE9FF\">, <\/span><span style=\"color: #B48EAD\">1000<\/span><span style=\"color: #D8DEE9FF\">))<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  OPTIONS (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    require_partition_filter <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> TRUE<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  );<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">3. <a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/creating-partitioned-tables?hl=ko#create_an_ingestion-time_partitioned_table\" target=\"_blank\" rel=\"noopener\">\uc218\uc9d1 \uc2dc\uac04 \uae30\uc900\uc73c\ub85c \ud30c\ud2f0\uc158 \ub098\ub204\uae30<\/a><\/h4>\n\n\n\n<p>\uc218\uc9d1 \uc2dc\uac04 \uae30\uc900\uc73c\ub85c \ud30c\ud2f0\uc154\ub2dd\ud558\ub294 \uac83\uc740 \ub370\uc774\ud130\uac00 \uc2dc\uc2a4\ud15c\uc5d0 \uc218\uc9d1\ub41c \uc2dc\uac04\uc5d0 \ub530\ub77c \ub370\uc774\ud130\ub97c \ubd84\ud560\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \uc774\ub294 \uc8fc\ub85c \uc2e4\uc2dc\uac04 \ub370\uc774\ud130 \uc2a4\ud2b8\ub9ac\ubc0d \ub610\ub294 \ub85c\uadf8 \ub370\uc774\ud130\uc640 \uac19\uc774 \uc9c0\uc18d\uc801\uc73c\ub85c \uc218\uc9d1\ub418\ub294 \ub370\uc774\ud130\uc5d0 \uc720\uc6a9\ud569\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ub370\uc774\ud130\ub294 \ud2b9\uc815 \uc218\uc9d1 \uc2dc\uac04 \ubc94\uc704\uc5d0 \ub530\ub77c \ucffc\ub9ac\ud560 \ud544\uc694\uac00 \uc788\ub294 \uacbd\uc6b0\uac00 \ub9ce\uae30 \ub54c\ubb38\uc5d0, \uc218\uc9d1 \uc2dc\uac04 \uae30\uc900 \ud30c\ud2f0\uc154\ub2dd\uc744 \ud1b5\ud574 \ucffc\ub9ac \uc131\ub2a5\uc744 \ucd5c\uc801\ud654\ud558\uace0 \ube44\uc6a9\uc744 \uc808\uac10\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc774 \uacbd\uc6b0\uc5d0\ub294 \ud30c\ud2f0\uc158\uc758 \uae30\uc900\uc774 \ub418\ub294 \uc5f4\ub85c \ud14c\uc774\ube14 \ub0b4\uc758 \uc5f4\uc744 \uc120\ud0dd\ud558\ub294 \uac83\uc774 \uc544\ub2c8\ub77c, \ub0b4\ubd80\uc801\uc73c\ub85c \uc874\uc7ac\ud558\ub294 \uc5f4\uc778 <code>_PARTITIONTIME<\/code> \/ <code>_PARTITIONDATE<\/code> \uc5f4\uc774 \ud30c\ud2f0\uc158\uc758 \ub300\uc0c1\uc774 \ub418\uba70, \uc2dc\uac04 \ub2e8\uc704 \uc5f4\uc5d0 \ub300\ud574 \ud30c\ud2f0\uc158 \ub098\ub204\uae30\ub97c \ud560 \ub54c\uc640 \ub9c8\ucc2c\uac00\uc9c0\ub85c \uc6d0\ud558\ub294 \uc2dc\uac04 \ubc94\uc704\uc5d0 \ub300\ud574 \ud30c\ud2f0\uc154\ub2dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ub2e4\uc74c\uc740 \uc218\uc9d1 \uc2dc\uac04 \uae30\uc900\uc73c\ub85c \uc6d4\uac04 \ud30c\ud2f0\uc158\uc744 \ub098\ub208 \ud14c\uc774\ube14\uc744 \ub9cc\ub4dc\ub294 \uc608\uc2dc\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers cbp-highlight-hover\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(1 * 0.6 * .875rem);--cbp-line-highlight-color:rgba(201, 218, 248, 0.2);line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>CREATE TABLE\n  mydataset.newtable (transaction_id INT64)\nPARTITION BY\n  DATE_TRUNC(_PARTITIONTIME, MONTH)\n  OPTIONS (\n    partition_expiration_days = 3,\n    require_partition_filter = TRUE\n  );<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">TABLE<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  mydataset.newtable (transaction_id INT64)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">PARTITION<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">BY<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  DATE_TRUNC(_PARTITIONTIME, <\/span><span style=\"color: #81A1C1\">MONTH<\/span><span style=\"color: #D8DEE9FF\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  OPTIONS (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    partition_expiration_days <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">3<\/span><span style=\"color: #D8DEE9FF\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    require_partition_filter <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> TRUE<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  );<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%EA%B2%B0%EB%A1%A0\"><\/span>\uacb0\ub860<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\ud30c\ud2f0\uc154\ub2dd\uc740 BigQuery\uc5d0\uc11c \ub370\uc774\ud130 \ubd84\uc11d\uc758 \ud6a8\uc728\uc131\uc744 \uadf9\ub300\ud654\ud558\ub294 \uc911\uc694\ud55c \uae30\ub2a5\uc785\ub2c8\ub2e4. \uc801\uc808\ud55c \ud30c\ud2f0\uc154\ub2dd\uc744 \ud1b5\ud574 \ucffc\ub9ac \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0a4\uace0 \ube44\uc6a9\uc744 \uc808\uac10\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130\uc758 \ud2b9\uc131\uacfc \ucffc\ub9ac \ud328\ud134\uc5d0 \ub9de\ub294 \ud30c\ud2f0\uc154\ub2dd\uc744 \uc120\ud0dd\ud558\uba74, \ub300\uaddc\ubaa8 \ub370\uc774\ud130\uc14b\uc5d0\uc11c\ub3c4 \ube60\ub974\uace0 \ud6a8\uc728\uc801\uc778 \ubd84\uc11d\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ub2e4\uc74c \uae00\uc5d0\uc11c\ub294 \ub610 \ub2e4\ub978 \uc131\ub2a5 \ucd5c\uc801\ud654 \uae30\ubc95\uc778 <strong>\ud074\ub7ec\uc2a4\ud130\ub9c1(Clustering)<\/strong>\uc5d0 \ub300\ud574 \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \ud074\ub7ec\uc2a4\ud130\ub9c1\uc740 \ub370\uc774\ud130\ub97c \ud2b9\uc815 \uc5f4\uc744 \uae30\uc900\uc73c\ub85c \ubb3c\ub9ac\uc801\uc73c\ub85c \uc815\ub82c\ud558\uc5ec \ucffc\ub9ac \uc131\ub2a5\uc744 \ub354\uc6b1 \ud5a5\uc0c1\uc2dc\ud0a4\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \ud074\ub7ec\uc2a4\ud130\ub9c1\uc758 \uac1c\ub150\uacfc \uc2e4\uc804 \uc801\uc6a9 \ubc29\ubc95\uc744 \ud1b5\ud574, \uc5ec\ub7ec\ubd84\uc758 \ub370\uc774\ud130 \ubd84\uc11d \uc791\uc5c5\uc774 \uc5b4\ub5bb\uac8c \ud55c \ub2e8\uacc4 \ub354 \ubc1c\uc804\ud560 \uc218 \uc788\ub294\uc9c0 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n<ol class=\"wp-block-footnotes\"><li id=\"3f83eba8-581e-466d-b503-f833eafe136c\"><a href=\"https:\/\/cloud.google.com\/bigquery\/pricing?hl=ko#on_demand_pricing\" target=\"_blank\" rel=\"noopener\">\uc8fc\ubb38\ud615 \uac00\uaca9 \ucc45\uc815 \ubaa8\ub378<\/a> \uae30\uc900 <a href=\"#3f83eba8-581e-466d-b503-f833eafe136c-link\" aria-label=\"1 \uac01\uc8fc \ucc38\uc870\ub85c \ub118\uc5b4\uac00\uc138\uc694\">\u21a9\ufe0e<\/a><\/li><\/ol>","protected":false},"excerpt":{"rendered":"<p>\ub4e4\uc5b4\uac00\uba70 \ud604\ub300 \ube44\uc988\ub2c8\uc2a4 \ud658\uacbd\uc5d0\uc11c \ub370\uc774\ud130\ub294 \uac00\uc7a5 \uc911\uc694\ud55c \uc790\uc0b0 \uc911 \ud558\ub098\ub85c \uc790\ub9ac \uc7a1\uc558\uc2b5\ub2c8\ub2e4. \uae30\uc5c5\ub4e4\uc740 \ub370\uc774\ud130 \ubd84\uc11d\uc744 \ud1b5\ud574 \uace0\uac1d\uc758 \ud589\ub3d9\uc744 \uc608\uce21\ud558\uace0, \uc2dc\uc7a5 \ud2b8\ub80c\ub4dc\ub97c \ud30c\uc545\ud558\uba70, \ube44\uc988\ub2c8\uc2a4 \uc804\ub7b5\uc744 \ucd5c\uc801\ud654\ud558\ub294 \ub370 \uc9d1\uc911\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ub370\uc774\ud130 \uc911\uc2ec\uc758 \uc811\uadfc \ubc29\uc2dd\uc5d0\uc11c \uc911\uc694\ud55c \uc5ed\ud560\uc744 \ud558\ub294 \uac83\uc774 \ubc14\ub85c \ube45\ub370\uc774\ud130 \ubd84\uc11d \ud50c\ub7ab\ud3fc\uc785\ub2c8\ub2e4. Google BigQuery\ub294 \uc774\ub7ec\ud55c \uc694\uad6c\ub97c \ucda9\uc871\uc2dc\ud0a4\uae30 \uc704\ud574 \uc124\uacc4\ub41c \uac15\ub825\ud55c \ub370\uc774\ud130 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"[{\"content\":\"<a href=\\\"https:\/\/cloud.google.com\/bigquery\/pricing?hl=ko#on_demand_pricing\\\">\uc8fc\ubb38\ud615 \uac00\uaca9 \ucc45\uc815 \ubaa8\ub378<\/a> \uae30\uc900\",\"id\":\"3f83eba8-581e-466d-b503-f833eafe136c\"}]"},"categories":[1],"tags":[5,20,12,18,21,22],"class_list":["post-70","post","type-post","status-publish","format-standard","hentry","category-1","tag-bigquery","tag-bigquery-partitioning","tag-gcp","tag-gcp-bigquery","tag-partitioned-table","tag-query-optimize","col-md-12"],"_links":{"self":[{"href":"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-json\/wp\/v2\/posts\/70","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-json\/wp\/v2\/comments?post=70"}],"version-history":[{"count":43,"href":"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-json\/wp\/v2\/posts\/70\/revisions"}],"predecessor-version":[{"id":620,"href":"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-json\/wp\/v2\/posts\/70\/revisions\/620"}],"wp:attachment":[{"href":"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-json\/wp\/v2\/media?parent=70"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-json\/wp\/v2\/categories?post=70"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-json\/wp\/v2\/tags?post=70"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}