{"id":2956,"date":"2025-04-30T17:35:33","date_gmt":"2025-04-30T09:35:33","guid":{"rendered":"https:\/\/aws-oncloudai.com\/?p=2956"},"modified":"2025-04-30T17:35:33","modified_gmt":"2025-04-30T09:35:33","slug":"asycjjxyzjsj","status":"publish","type":"post","link":"https:\/\/aws-oncloudai.com\/ko\/asycjjxyzjsj\/","title":{"rendered":"Amazon Redshift \uc0ac\uc6a9 \uc2dc\ub098\ub9ac\uc624 \ubc0f \ubaa8\ubc94 \uc0ac\ub840"},"content":{"rendered":"<p>AWS \ud074\ub77c\uc6b0\ub4dc \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4 \uc11c\ube44\uc2a4\uc758 \ud575\uc2ec \uad6c\uc131\uc6d0\uc778 Amazon Redshift\ub294 \ub192\uc740 \uc131\ub2a5, \ud655\uc7a5\uc131, \ube44\uc6a9 \ud6a8\uc728\uc131 \ub355\ubd84\uc5d0 \uc810\uc810 \ub354 \ub9ce\uc740 \ud68c\uc0ac\uac00 \ub370\uc774\ud130 \uae30\ubc18 \uc758\uc0ac \uacb0\uc815\uc744 \ub2ec\uc131\ud558\ub294 \ub370 \uc120\ud638\ud558\ub294 \uc194\ub8e8\uc158\uc774 \ub418\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uae00\uc5d0\uc11c\ub294 Redshift\uc758 \uc77c\ubc18\uc801\uc778 \uc0ac\uc6a9 \uc2dc\ub098\ub9ac\uc624\ub97c \ubd84\uc11d\ud558\uace0, \uae30\uc5c5\uc774 \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4 \uad6c\ucd95\uc5d0 \ub4dc\ub294 \ub178\ub825\uc744 \uc808\ubc18\uc73c\ub85c \uc904\uc774\uba74\uc11c \ub450 \ubc30\uc758 \uacb0\uacfc\ub97c \uc5bb\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub418\ub294 \uba87 \uac00\uc9c0 \uc2e4\uc6a9\uc801\uc778 \uad6c\ud604 \ubaa8\ubc94 \uc0ac\ub840\ub97c \uacf5\uc720\ud569\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<h4>\uc65c Amazon Redshift\ub97c \uc120\ud0dd\ud574\uc57c \ud560\uae4c\uc694?<\/h4>\n<p>\uae30\uc874\uc758 \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\ub294 \uc77c\ubc18\uc801\uc73c\ub85c \ud655\uc7a5\uc131\uc774 \ub0ae\uace0, \uc6b4\uc601\uacfc \uc720\uc9c0\uad00\ub9ac\uac00 \ubcf5\uc7a1\ud558\uba70, \ube44\uc6a9\uc774 \ub9ce\uc774 \ub4dc\ub294 \ub4f1\uc758 \ubb38\uc81c\uac00 \uc788\uc2b5\ub2c8\ub2e4. Amazon Redshift\ub294 \ube60\ub978 \ucffc\ub9ac \ucc98\ub9ac\ub97c \uc9c0\uc6d0\ud558\ub294 \ub3d9\uc2dc\uc5d0 \ub2e4\uc74c\uacfc \uac19\uc740 \uc774\uc810\uc744 \uc81c\uacf5\ud558\ub294 \ud074\ub77c\uc6b0\ub4dc \uae30\ubc18 MPP(\ub300\uaddc\ubaa8 \ubcd1\ub82c \ucc98\ub9ac) \uc544\ud0a4\ud14d\ucc98\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n<ul>\n<li><strong>\ub192\uc740 \ube44\uc6a9 \uc131\ub2a5<\/strong>: \ub85c\uceec\uc5d0 \uad6c\ucd95\ub41c \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\ubcf4\ub2e4 10\ubc30 \uc774\uc0c1 \uc800\ub834\ud569\ub2c8\ub2e4.<\/li>\n<li><strong>\uc11c\ubc84\ub9ac\uc2a4 \uc120\ud0dd \uc0ac\ud56d<\/strong>: \uc8fc\ubb38\ud615 \uccad\uad6c\ub97c \uc9c0\uc6d0\ud558\uba70 \ud074\ub7ec\uc2a4\ud130 \uad00\ub9ac\uac00 \ud544\uc694 \uc5c6\uc2b5\ub2c8\ub2e4.<\/li>\n<li><strong>AWS \ub124\uc774\ud2f0\ube0c \uc5d0\ucf54\uc2dc\uc2a4\ud15c\uacfc \uace0\ub3c4\ub85c \ud1b5\ud569\ub428<\/strong>: S3, Glue, QuickSight, Amazon Bedrock \ub4f1\uc758 \uc11c\ube44\uc2a4\uc5d0 \uc6d0\ud65c\ud558\uac8c \uc561\uc138\uc2a4 \uac00\ub2a5<\/li>\n<li><strong>PB \uc218\uc900\uc758 \ud655\uc7a5\uc131<\/strong>: \ube45\ub370\uc774\ud130 \ubd84\uc11d \ubc0f \uc2e4\uc2dc\uac04 \ub370\uc774\ud130 \ucffc\ub9ac\uc758 \uc694\uad6c\uc5d0 \ub9de\ucdb0 \uc870\uc815\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h4>\uc77c\ubc18\uc801\uc778 \uc0ac\uc6a9 \uc2dc\ub098\ub9ac\uc624<\/h4>\n<p>&nbsp;<\/p>\n<h5>1. \ube44\uc988\ub2c8\uc2a4 \uc778\ud154\ub9ac\uc804\uc2a4(BI) \ubcf4\uace0\uc11c \ubc0f \ub300\uc2dc\ubcf4\ub4dc<\/h5>\n<p>Redshift\ub294 Amazon QuickSight\ub098 Power BI, Tableau \ub4f1\uc758 \ub3c4\uad6c\uc640 \ud1b5\ud569\ud558\uc5ec \ub2e4\ucc28\uc6d0 \ub370\uc774\ud130 \uc2dc\uac01\ud654\ub97c \uad6c\ud604\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc778 \uc751\uc6a9 \ubd84\uc57c\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<ul>\n<li>\ud310\ub9e4 \ubc0f \uc6b4\uc601 \ubd84\uc11d<\/li>\n<li>\uc0ac\uc6a9\uc790 \uc720\uc9c0 \ubc0f \uc804\ud658 \ud37c\ub110 \ucd94\uc801<\/li>\n<li>\ub2e4\uc911 \ucc44\ub110 \uc804\uc790\uc0c1\uac70\ub798 \ub370\uc774\ud130 \uc9d1\uacc4.<\/li>\n<\/ul>\n<blockquote><p>\u2705 <strong>\uc2e4\uc6a9\uc801\uc778 \uc870\uc5b8<\/strong>: Redshift Materialized Views\ub97c \ud65c\uc131\ud654\ud558\uc5ec \uc694\uc57d \ub370\uc774\ud130\ub97c \uc815\uae30\uc801\uc73c\ub85c \uc0c8\ub85c \uace0\uce58\uace0 \ubcf4\uace0\uc11c \uc751\ub2f5 \uc18d\ub3c4\ub97c \ub192\uc785\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p><\/blockquote>\n<h5>2. \uc2e4\uc2dc\uac04 \ub610\ub294 \uc900\uc2e4\uc2dc\uac04 \ub370\uc774\ud130 \ubd84\uc11d<\/h5>\n<p>Redshift Streaming(Kinesis \ub610\ub294 MSK\uc5d0\uc11c \uc2e4\uc2dc\uac04 \ub370\uc774\ud130 \uac00\uc838\uc624\uae30 \uc9c0\uc6d0)\uc744 \uc0ac\uc6a9\ud558\uba74 \uc0ac\uc6a9\uc790\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc2e4\uc2dc\uac04 \uc774\ubca4\ud2b8\ub97c \ubd84\uc11d\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<ul>\n<li>\uc2e4\uc2dc\uac04 \uad11\uace0 \ub178\ucd9c \ubc0f \ud074\ub9ad \ubaa8\ub2c8\ud130\ub9c1<\/li>\n<li>IoT \uae30\uae30 \uc0c1\ud0dc \ubd84\uc11d<\/li>\n<li>\uc0ac\uc6a9\uc790 \ud589\ub3d9 \ub85c\uadf8 \ubd84\uc11d.<\/li>\n<\/ul>\n<blockquote><p>\u2705 <strong>\uc2e4\uc6a9\uc801\uc778 \uc870\uc5b8<\/strong>: Amazon Kinesis Firehose\uc640 \uacb0\ud569\ud558\uc5ec \ub370\uc774\ud130 \uc2a4\ud2b8\ub9bc\uc744 \uc2e4\uc2dc\uac04\uc73c\ub85c Redshift\uc5d0 \uc804\uc1a1\ud558\uc5ec \uc9c0\uc5f0 \uc2dc\uac04\uc744 \uc904\uc785\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p><\/blockquote>\n<h5>3. \ub370\uc774\ud130 \ub808\uc774\ud06c \ubd84\uc11d \ubc0f \uc5f0\ud569 \ucffc\ub9ac<\/h5>\n<p>Redshift Spectrum\uc744 \uc0ac\uc6a9\ud558\uba74 \uc0ac\uc6a9\uc790\ub294 \ub370\uc774\ud130\ub97c \ubcf5\uc0ac\ud558\uc9c0 \uc54a\uace0\ub3c4 S3\uc5d0 \uc800\uc7a5\ub41c \uc624\ud508 \ud3ec\ub9f7(\uc608: Parquet, ORC) \ud30c\uc77c\uc744 \uc9c1\uc811 \ucffc\ub9ac\ud558\uc5ec \ubd84\uc11d \ubc94\uc704\ub97c \ud655\uc7a5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<ul>\n<li>\ub300\uaddc\ubaa8 \ub85c\uadf8 \ub610\ub294 \uacfc\uac70 \ubcf4\uad00 \ub370\uc774\ud130 \ubd84\uc11d<\/li>\n<li>\ub2e4\uc591\ud55c \uc18c\uc2a4\uc758 \ub370\uc774\ud130 \ud1b5\ud569<\/li>\n<li>\ud06c\ub85c\uc2a4 \uc2dc\uc2a4\ud15c \ub370\uc774\ud130 \ucffc\ub9ac.<\/li>\n<\/ul>\n<blockquote><p>\u2705 <strong>\uc2e4\uc6a9\uc801\uc778 \uc870\uc5b8<\/strong>: S3 \ub370\uc774\ud130\uc5d0 \ub300\ud55c \ud569\ub9ac\uc801\uc778 \ubd84\ud560 \ubc0f \uc555\ucd95 \ud615\uc2dd\uc744 \uc124\uc815\ud558\uc5ec Spectrum \ucffc\ub9ac \uc131\ub2a5\uc744 \uac1c\uc120\ud569\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p><\/blockquote>\n<h5>4. \ub370\uc774\ud130 \uacfc\ud559 \ubaa8\ub378\ub9c1 \ubc0f \uba38\uc2e0 \ub7ec\ub2dd \ud1b5\ud569<\/h5>\n<p>Redshift\ub294 SQL + Python \ud558\uc774\ube0c\ub9ac\ub4dc \uac1c\ubc1c\uc744 \uc9c0\uc6d0\ud558\uace0 Amazon SageMaker \uc5f0\uacb0\uc774 \ub0b4\uc7a5\ub418\uc5b4 \uc788\uc5b4 \ub2e4\uc74c\uacfc \uac19\uc740 \uacbd\uc6b0\uc5d0 \uc801\ud569\ud569\ub2c8\ub2e4.<\/p>\n<ul>\n<li>\ud2b9\uc9d5 \uc5d4\uc9c0\ub2c8\uc5b4\ub9c1 \ubc0f \ub370\uc774\ud130 \uc804\ucc98\ub9ac<\/li>\n<li>\ubaa8\ub378 \uacb0\uacfc\uc758 \uc2dc\uac01\ud654;<\/li>\n<li>\ubaa8\ub378 \ubc30\ud3ec \ud6c4 \ub370\uc774\ud130 \ubaa8\ub2c8\ud130\ub9c1.<\/li>\n<\/ul>\n<blockquote><p>\u2705 <strong>\uc2e4\uc6a9\uc801\uc778 \uc870\uc5b8<\/strong>: Redshift ML\uc744 \uc0ac\uc6a9\ud558\uba74 \uba38\uc2e0 \ub7ec\ub2dd \ubaa8\ub378\uc744 \ube60\ub974\uac8c \ud6c8\ub828\ud558\uace0 \ubc30\ud3ec\ud558\uc5ec \uc885\ub2e8 \uac04 \uc9c0\ub2a5\ud615 \ubd84\uc11d \ud504\ub85c\uc138\uc2a4\ub97c \ub2ec\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p><\/blockquote>\n<h4>\ubaa8\ubc94 \uc0ac\ub840 \ubc0f \ucd5c\uc801\ud654 \uc81c\uc548<\/h4>\n<p>&nbsp;<\/p>\n<table>\n<thead>\n<tr>\n<th>\ubc94\uc8fc<\/th>\n<th>\uc81c\uc548<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\ud14c\uc774\ube14 \ub514\uc790\uc778<\/td>\n<td>\ud569\ub9ac\uc801\uc778 \uc124\uc815 <code>\ub514\uc2a4\ud2b8\ud0a4<\/code> \/ <code>\uc815\ub82c \ud0a4<\/code>\ub370\uc774\ud130 \uc65c\uace1\uc744 \ubc29\uc9c0\ud569\ub2c8\ub2e4.<\/td>\n<\/tr>\n<tr>\n<td>\ucffc\ub9ac \ucd5c\uc801\ud654<\/td>\n<td>\uc0ac\uc6a9 <code>\uc124\uba85\ud558\ub2e4<\/code> \ub290\ub9b0 \ucffc\ub9ac\ub97c \ubd84\uc11d\ud558\uace0 \ub178\ub4dc \uac04 \ub300\ud615 \ud14c\uc774\ube14 JOIN\uc744 \ubc29\uc9c0\ud569\ub2c8\ub2e4.<\/td>\n<\/tr>\n<tr>\n<td>\ube44\uc6a9 \uad00\ub9ac<\/td>\n<td>Redshift Spectrum\uc744 \uc0ac\uc6a9\ud558\uba74 \ucffc\ub9ac \ube48\ub3c4\uac00 \ub0ae\uc740 \ub370\uc774\ud130\uc5d0 \ub300\ud55c \ube44\uc6a9\uc744 \uc904\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/td>\n<\/tr>\n<tr>\n<td>\uc790\ub3d9 \uc720\uc9c0 \uad00\ub9ac<\/td>\n<td>\uc815\uae30\uc801\uc73c\ub85c \uc2e4\ud589 <code>\uc9c4\uacf5<\/code> \uadf8\ub9ac\uace0 <code>\ubd84\uc11d\ud558\ub2e4<\/code> \ud14c\uc774\ube14 \uc131\ub2a5 \uc720\uc9c0<\/td>\n<\/tr>\n<tr>\n<td>\uc548\uc804 \uad00\ub9ac<\/td>\n<td>VPC, IAM \ubc0f \ub370\uc774\ud130 \uc554\ud638\ud654\ub97c \ud1b5\ud574 \uc5d4\ud130\ud504\ub77c\uc774\uc988 \uc218\uc900\uc758 \ubcf4\uc548 \ubcf4\ud638\uac00 \ub2ec\uc131\ub429\ub2c8\ub2e4.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<h4>\uc694\uc57d\ud558\ub2e4<\/h4>\n<p>\ubbfc\ucca9\ud55c BI \ud50c\ub7ab\ud3fc \uad6c\ucd95, \uc2e4\uc2dc\uac04 \ubd84\uc11d \uc2dc\uc2a4\ud15c \uc124\uc815, \ub300\uaddc\ubaa8 \ucffc\ub9ac\ub97c \uc704\ud55c \ub370\uc774\ud130 \ub808\uc774\ud06c \uc5f0\uacb0 \ub4f1 Amazon Redshift\ub294 \uae30\uc5c5\uc5d0 \uc720\uc5f0\ud558\uace0 \uc548\uc815\uc801\uc778 \ub370\uc774\ud130 \ubd84\uc11d \uae30\ubc18\uc744 \uc81c\uacf5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud074\ub77c\uc6b0\ub4dc\ub85c \ube60\ub974\uac8c \uc804\ud658\ud558\uace0 \ud074\ub77c\uc6b0\ub4dc \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\ub97c \uad6c\ucd95\ud558\uace0\uc790 \ud558\ub294 \uace0\uac1d\uc744 \uc704\ud574 <strong>AWS \uacf5\uc778 \ud30c\ud2b8\ub108<\/strong>\ub2e4\uc74c\uacfc \uac19\uc740 \uc11c\ube44\uc2a4 \uc9c0\uc6d0\uc744 \uc81c\uacf5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<ul>\n<li>Redshift \uc194\ub8e8\uc158 \uc120\ud0dd \ubc0f PoC \ud658\uacbd \uad6c\ucd95;<\/li>\n<li>\uc544\ud0a4\ud14d\ucc98 \uc124\uacc4 \ubc0f \ubc30\ud3ec \uc11c\ube44\uc2a4<\/li>\n<li>\ub370\uc774\ud130 \ub9c8\uc774\uadf8\ub808\uc774\uc158 \ubc0f \ud1b5\ud569<\/li>\n<li>AWS \uccb4\ud5d8\ud310 \ud560\ub2f9\ub7c9\uacfc \ud65c\ub3d9 \ub9ac\uc18c\uc2a4 \ud328\ud0a4\uc9c0\ub97c \uc2e0\uccad\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>\ud398\uc774\uc9c0 \ud558\ub2e8\uc758 QR \ucf54\ub4dc\ub97c \uc2a4\uce94\ud558\uc5ec \ubb38\uc758\ud558\uc2dc\uba74 Amazon Redshift \uc194\ub8e8\uc158\uc5d0 \ub300\ud574 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\uace0, \ub370\uc774\ud130\ub97c \ud1b5\ud574 \ube44\uc988\ub2c8\uc2a4 \uc131\uc7a5\uc744 \ucd09\uc9c4\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4!<\/p>","protected":false},"excerpt":{"rendered":"<p>AWS \ud074\ub77c\uc6b0\ub4dc \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4 \uc11c\ube44\uc2a4\uc758 \ud575\uc2ec \uad6c\uc131\uc6d0\uc778 Amazon Redshift\ub294 \ub192\uc740 \uc131\ub2a5, \ud655\uc7a5\uc131, \ube44\uc6a9 \ud6a8\uc728\uc131 \ub355\ubd84\uc5d0 \uc810\uc810 \ub354 \ub9ce\uc740 \ud68c\uc0ac\uac00 \ub370\uc774\ud130 \uae30\ubc18 \uc758\uc0ac \uacb0\uc815\uc744 \ub2ec\uc131\ud558\ub294 \ub370 \uc120\ud638\ud558\ub294 \uc194\ub8e8\uc158\uc774 \ub418\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uae00\uc5d0\uc11c\ub294 Redshift\uc758 \uc77c\ubc18\uc801\uc778 \uc0ac\uc6a9 \uc2dc\ub098\ub9ac\uc624\ub97c \ubd84\uc11d\ud558\uace0, \uae30\uc5c5\uc774 \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4 \uad6c\ucd95\uc5d0 \ub4dc\ub294 \ub178\ub825\uc744 \uc808\ubc18\uc73c\ub85c \uc904\uc774\uba74\uc11c \ub450 \ubc30\uc758 \uacb0\uacfc\ub97c \uc5bb\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub418\ub294 \uba87 \uac00\uc9c0 \uc2e4\uc6a9\uc801\uc778 \uad6c\ud604 \ubaa8\ubc94 \uc0ac\ub840\ub97c \uacf5\uc720\ud569\ub2c8\ub2e4.<\/p>","protected":false},"author":1,"featured_media":2960,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[65],"tags":[],"class_list":["post-2956","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technical-sharing"],"_links":{"self":[{"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/posts\/2956","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/comments?post=2956"}],"version-history":[{"count":0,"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/posts\/2956\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/media\/2960"}],"wp:attachment":[{"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/media?parent=2956"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/categories?post=2956"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/tags?post=2956"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}