{"id":2520,"date":"2025-02-10T17:31:45","date_gmt":"2025-02-10T09:31:45","guid":{"rendered":"https:\/\/aws-oncloudai.com\/?p=2520"},"modified":"2025-02-10T17:44:54","modified_gmt":"2025-02-10T09:44:54","slug":"aydsjck","status":"publish","type":"post","link":"https:\/\/aws-oncloudai.com\/ko\/\uc544\uc774\uc988\uc81c\uc774\ud06c\/","title":{"rendered":"AWS Redshift: \ud074\ub77c\uc6b0\ub4dc\uc758 \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4"},"content":{"rendered":"<p><span style=\"color: #000000;\">\uc624\ub298\ub0a0\uc758 \ub370\uc774\ud130 \uc911\uc2ec \uc138\uacc4\uc5d0\uc11c \uae30\uc5c5\uc740 \ud1b5\ucc30\ub825\uc744 \uc5bb\uace0 \uc815\ubcf4\uc5d0 \uc785\uac01\ud55c \uc758\uc0ac \uacb0\uc815\uc744 \ub0b4\ub9ac\uae30 \uc704\ud574 \ubc29\ub300\ud55c \uc591\uc758 \ub370\uc774\ud130\ub97c \ucc98\ub9ac\ud558\uace0 \ubd84\uc11d\ud574\uc57c \ud569\ub2c8\ub2e4. \uae30\uc874\uc758 \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4 \uc194\ub8e8\uc158\uc740 \uc885\uc885 \ubcf5\uc7a1\ud55c \uc778\ud504\ub77c, \ub192\uc740 \ube44\uc6a9, \ud655\uc7a5\uc131 \ubb38\uc81c\ub97c \uc548\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc5ec\uae30\uc11c AWS Redshift\uac00 \ub4f1\uc7a5\ud569\ub2c8\ub2e4.<\/span><\/p>\n<p>&nbsp;<\/p>\n<h3 id=\"heading-what-is-aws-redshift\" class=\"permalink-heading\"><span style=\"color: #000000;\">AWS Redshift\ub780 \ubb34\uc5c7\uc778\uac00\uc694?<\/span><\/h3>\n<p><span style=\"color: #000000;\">Amazon Redshift\ub294 Amazon Web Services(AWS)\uac00 \uc81c\uacf5\ud558\ub294 \uc644\uc804 \uad00\ub9ac\ud615 \ud074\ub77c\uc6b0\ub4dc \uae30\ubc18 \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4 \uc11c\ube44\uc2a4\uc785\ub2c8\ub2e4. \ucd5c\uc18c\ud55c\uc758 \uad00\ub9ac \uc624\ubc84\ud5e4\ub4dc\ub85c \uc6d0\ud65c\ud558\uac8c \ud655\uc7a5\ud558\uba74\uc11c \ub300\ub7c9\uc758 \ub370\uc774\ud130\ub97c \uc2e4\uc2dc\uac04\uc73c\ub85c \uc800\uc7a5\ud558\uace0 \ubd84\uc11d\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. PostgreSQL \uae30\ubc18\uc73c\ub85c \uad6c\ucd95\ub418\uc5c8\uc9c0\ub9cc \ubcf5\uc7a1\ud55c \ubd84\uc11d \ucffc\ub9ac\uc5d0 \ucd5c\uc801\ud654\ub418\uc5b4 \uc788\uc5b4 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc9d5 \uc791\uc5c5\uc5d0 \uc774\uc0c1\uc801\uc785\ub2c8\ub2e4.<\/span><\/p>\n<p><span style=\"color: #000000;\">Redshift\ub97c \uc0ac\uc6a9\ud558\uba74 \ub2e4\uc74c \uc791\uc5c5\uc744 \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<ul>\n<li><span style=\"color: #000000;\"><strong>\ub300\uc6a9\ub7c9 \ub370\uc774\ud130 \uc138\ud2b8\uc758 \ud6a8\uc728\uc801\uc778 \uc800\uc7a5<\/strong><\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>\ubcf5\uc7a1\ud55c \ucffc\ub9ac \uc2e4\ud589<\/strong>\ud1b5\ucc30\ub825\uc744 \uc5bb\uc73c\ub824\uba74<\/span><\/li>\n<li><span style=\"color: #000000;\">\uc218\uc694\uc5d0 \ub530\ub978 \ubcc0\ud654<strong>\ud655\uc7a5 \ub610\ub294 \ucd95\uc18c<\/strong><\/span><\/li>\n<li><span style=\"color: #000000;\">\uc26c\uc6b4<strong>\ub2e4\ub978 AWS \uc11c\ube44\uc2a4\uc640\uc758 \ud1b5\ud569<\/strong><\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"wp-image-2522 aligncenter\" src=\"http:\/\/aws-oncloudai.com\/wp-content\/uploads\/2025\/02\/xz-300x166.png\" alt=\"\" width=\"466\" height=\"258\" srcset=\"https:\/\/aws-oncloudai.com\/wp-content\/uploads\/2025\/02\/xz-300x166.png 300w, https:\/\/aws-oncloudai.com\/wp-content\/uploads\/2025\/02\/xz-18x10.png 18w, https:\/\/aws-oncloudai.com\/wp-content\/uploads\/2025\/02\/xz.png 302w\" sizes=\"(max-width: 466px) 100vw, 466px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3 id=\"heading-key-features-of-aws-redshift\" class=\"permalink-heading\"><span style=\"color: #000000;\">AWS Redshift\uc758 \uc8fc\uc694 \uae30\ub2a5<\/span><\/h3>\n<ol>\n<li><span style=\"color: #000000;\"><strong>\ud655\uc7a5\uc131<\/strong>AWS Redshift\ub294 \ud655\uc7a5\uc131\uc774 \ub9e4\uc6b0 \ub6f0\uc5b4\ub098\uc11c \uc801\uc740 \uc591\uc758 \ub370\uc774\ud130\ub85c \uc2dc\uc791\ud574\uc11c \uc131\ub2a5 \uc800\ud558\ub97c \uac71\uc815\ud558\uc9c0 \uc54a\uace0\ub3c4 \ud398\ud0c0\ubc14\uc774\ud2b8 \uaddc\ubaa8\uc758 \ub370\uc774\ud130\uae4c\uc9c0 \ud655\uc7a5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. Redshift\ub294 \uc18d\ub3c4 \uc800\ud558 \uc5c6\uc774 \ub9e4\uc6b0 \ud070 \ub370\uc774\ud130 \uc138\ud2b8\uc5d0 \ub300\ud55c \ubcf5\uc7a1\ud55c \ucffc\ub9ac\ub97c \ucc98\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>\uc131\ub2a5<\/strong>Redshift\ub294 \ub300\uaddc\ubaa8 \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4 \uc6cc\ud06c\ub85c\ub4dc\ub97c \ucc98\ub9ac\ud558\ub3c4\ub85d \uc124\uacc4\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc774 \uae30\uc220\uc740 \uceec\ub7fc \uae30\ubc18 \uc800\uc7a5\uc18c\ub97c \uc0ac\uc6a9\ud558\ubbc0\ub85c \ub300\uc6a9\ub7c9 \ub370\uc774\ud130 \uc138\ud2b8\ub97c \ub354 \ube60\ub974\uac8c \uc77d\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130\uac00 \uc555\ucd95\ub418\uc5b4 \ub354 \ud6a8\uc728\uc801\uc73c\ub85c \uc800\uc7a5\ub429\ub2c8\ub2e4. \ub610\ud55c, \ub300\ub7c9 \ubcd1\ub82c \ucc98\ub9ac(MPP)\ub97c \ud65c\uc6a9\ud558\uc5ec \ucffc\ub9ac \ubd80\ud558\ub97c \uc5ec\ub7ec \ub178\ub4dc\uc5d0 \ubd84\uc0b0\uc2dc\ucf1c \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0b5\ub2c8\ub2e4.<\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>\uc644\uc804 \uad00\ub9ac\ub428<\/strong>\uad11\ubc94\uc704\ud55c \uc124\uc815\uacfc \uc720\uc9c0 \uad00\ub9ac\uac00 \ud544\uc694\ud55c \uae30\uc874 \uc628\ud504\ub808\ubbf8\uc2a4 \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc640 \ub2ec\ub9ac AWS Redshift\ub294 \uc644\ubcbd\ud558\uac8c \uad00\ub9ac\ub429\ub2c8\ub2e4. \uc989, AWS\uc5d0\uc11c \ud558\ub4dc\uc6e8\uc5b4 \ud504\ub85c\ube44\uc800\ub2dd, \ud328\uce58, \ubc31\uc5c5 \ubc0f \ud655\uc7a5\uc744 \ucc98\ub9ac\ud558\ubbc0\ub85c \uc778\ud504\ub77c\uac00 \uc544\ub2cc \ub370\uc774\ud130\uc5d0 \uc9d1\uc911\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>\ubcf4\uc548<\/strong>Redshift\ub294 \ubcf4\uc548\uc744 \ucd5c\uc6b0\uc120\uc73c\ub85c \uc0dd\uac01\ud569\ub2c8\ub2e4. \ub370\uc774\ud130\ub294 \uc800\uc7a5 \uc911\uacfc \uc804\uc1a1 \uc911 \ubaa8\ub450 \uc5c5\uacc4 \ud45c\uc900 \uc554\ud638\ud654 \ubc29\ubc95\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc554\ud638\ud654\ub429\ub2c8\ub2e4. AWS Identity and Access Management(IAM) \ubc0f Virtual Private Cloud(VPC)\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc548\uc804\ud55c \ub124\ud2b8\uc6cc\ud06c \uc561\uc138\uc2a4\ub97c \ud1b5\ud574 \ub370\uc774\ud130 \uc561\uc138\uc2a4\ub97c \uc81c\uc5b4\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>\ube44\uc6a9 \ud6a8\uc728\uc801<\/strong>Redshift\ub294 \uc0ac\uc6a9\ub7c9 \uae30\ubc18 \uc9c0\ubd88 \ubc0f \uc608\uc57d \uc778\uc2a4\ud134\uc2a4 \ub4f1 \uc720\uc5f0\ud55c \uac00\uaca9 \uc635\uc158\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc989, \uc0ac\uc6a9 \ud328\ud134\uc5d0 \ub530\ub77c \ube44\uc6a9\uc744 \ucd5c\uc801\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uac8c\ub2e4\uac00 \uc644\ubcbd\ud558\uac8c \uad00\ub9ac\ub418\ubbc0\ub85c \uc790\uccb4 \uc778\ud504\ub77c\ub97c \uad00\ub9ac\ud558\ub294 \ub370 \ub4dc\ub294 \uc6b4\uc601 \ube44\uc6a9\uc744 \uc808\uac10\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>AWS \uc5d0\ucf54\uc2dc\uc2a4\ud15c\uacfc\uc758 \ud1b5\ud569<\/strong>Redshift\ub294 Amazon S3(\ub370\uc774\ud130 \uc800\uc7a5\uc6a9), AWS Glue(ETL \ud504\ub85c\uc138\uc2a4\uc6a9), AWS SageMaker(\uba38\uc2e0 \ub7ec\ub2dd\uc6a9) \ub4f1 \ub2e4\ub978 AWS \uc11c\ube44\uc2a4\uc640 \uc6d0\ud65c\ud558\uac8c \ud1b5\ud569\ub429\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \uc885\ub2e8 \uac04 \ub370\uc774\ud130 \ud30c\uc774\ud504\ub77c\uc778\uc744 \ub354 \uc27d\uac8c \uad6c\ucd95\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>\ub370\uc774\ud130 \uacf5\uc720<\/strong>Redshift\ub294 Redshift \ud074\ub7ec\uc2a4\ud130 \uac04\uc758 \ub370\uc774\ud130 \uacf5\uc720\ub97c \uc9c0\uc6d0\ud558\ubbc0\ub85c \uc870\uc9c1\uc5d0\uc11c \uc2dc\uc2a4\ud15c \uac04\uc5d0 \ub370\uc774\ud130\ub97c \ubcf5\uc0ac\ud558\uac70\ub098 \uc774\ub3d9\ud558\uc9c0 \uc54a\uace0\ub3c4 \uc190\uc27d\uac8c \ub370\uc774\ud130 \uc138\ud2b8\ub97c \uacf5\uc720\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \ub370\uc774\ud130 \ubcf4\uc548\uc744 \uc720\uc9c0\ud558\uba74\uc11c \ud611\uc5c5\uc744 \uac1c\uc120\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4.<\/span><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<h3 id=\"heading-how-does-redshift-work\" class=\"permalink-heading\"><span style=\"color: #000000;\">Redshift\ub294 \uc5b4\ub5bb\uac8c \uc791\ub3d9\ud558\ub098\uc694?<\/span><\/h3>\n<p><span style=\"color: #000000;\">Redshift\uc758 \ud575\uc2ec\uc740 \ub2e4\uc74c\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\uc785\ub2c8\ub2e4.<strong>\uceec\ub7fc \uc800\uc7a5<\/strong>\uadf8\ub9ac\uace0<strong>\ubcd1\ub82c \ucc98\ub9ac<\/strong>\ucffc\ub9ac \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0b5\ub2c8\ub2e4. \uc790\uc138\ud788 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<ol>\n<li><span style=\"color: #000000;\"><strong>\uceec\ub7fc \uc800\uc7a5<\/strong>\uae30\uc874\uc758 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c\ub294 \ub370\uc774\ud130\uac00 \ud589\ubcc4\ub85c \uc800\uc7a5\ub429\ub2c8\ub2e4. \ud558\uc9c0\ub9cc Redshift\uc5d0\uc11c\ub294 \ub370\uc774\ud130\uac00 \uc5f4 \ub2e8\uc704\ub85c \uc800\uc7a5\ub429\ub2c8\ub2e4. \uc774\ub807\uac8c \ud558\uba74 \uc804\uccb4 \ub370\uc774\ud130 \ud589\uc744 \uc77d\ub294 \ub300\uc2e0 \ud544\uc694\ud55c \uc5f4\ub9cc \uc77d\uc73c\ubbc0\ub85c \ucffc\ub9ac \uc2e4\ud589 \uc18d\ub3c4\uac00 \ube68\ub77c\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \uace0\uac1d \ub370\uc774\ud130 \ud14c\uc774\ube14\uc744 \ucffc\ub9ac\ud558\uace0 \ub098\uc774 \uc5f4\ub9cc \ud544\uc694\ud55c \uacbd\uc6b0 Redshift\ub294 \uc774\ub984\uc774\ub098 \uc8fc\uc18c\uc640 \uac19\uc740 \ub2e4\ub978 \uc5f4\uc744 \ub85c\ub4dc\ud558\uc9c0 \uc54a\uace0\ub3c4 \ud574\ub2f9 \ub370\uc774\ud130\ub97c \ube60\ub974\uac8c \uc2a4\uce94\ud558\uc5ec \ubc18\ud658\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>\ub300\uaddc\ubaa8 \ubcd1\ub82c \ucc98\ub9ac(MPP)<\/strong> Redshift\ub294 MPP\ub77c\ub294 \ubd84\uc0b0 \uc544\ud0a4\ud14d\ucc98\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \ucffc\ub9ac\ub97c \uc2e4\ud589\ud558\uba74 Redshift\ub294 \ucffc\ub9ac\ub97c \ub354 \uc791\uc740 \ubd80\ubd84\uc73c\ub85c \ub098\ub204\uc5b4 \uc5ec\ub7ec \ub178\ub4dc(\ucef4\ud4e8\ud130)\uc5d0\uc11c \ub3d9\uc2dc\uc5d0 \ucc98\ub9ac\ud569\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \ub300\uc6a9\ub7c9 \ub370\uc774\ud130 \uc138\ud2b8\uc5d0 \ub300\ud574\uc11c\ub3c4 \ub354 \ube60\ub978 \ucffc\ub9ac \uc2e4\ud589\uc774 \ubcf4\uc7a5\ub429\ub2c8\ub2e4.<\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>\ub370\uc774\ud130 \ubd84\ud3ec<\/strong>\ud6a8\uc728\uc801\uc778 \ucffc\ub9ac \uc2e4\ud589\uc744 \ubcf4\uc7a5\ud558\uae30 \uc704\ud574 Redshift\ub294 \uc5ec\ub7ec \ub178\ub4dc\uc5d0 \ub370\uc774\ud130\ub97c \ubd84\uc0b0\ud569\ub2c8\ub2e4. \ucffc\ub9ac \ud328\ud134\uc5d0 \ub530\ub77c \ub370\uc774\ud130\uac00 \ubd84\ud3ec\ub418\ub294 \ubc29\uc2dd\uc744 \uc81c\uc5b4\ud560 \uc218 \uc788\uc73c\ubbc0\ub85c \ub370\uc774\ud130\ub97c \uac80\uc0c9\ud558\ub294 \ub370 \ud544\uc694\ud55c \uc2dc\uac04\uc744 \uc904\uc774\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4.<\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>\ub370\uc774\ud130 \uc555\ucd95<\/strong>Redshift\ub294 \ub2e4\uc591\ud55c \uc778\ucf54\ub529 \ubc29\ubc95\uc744 \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \uc555\ucd95\ud569\ub2c8\ub2e4. \uc774\ub807\uac8c \ud558\uba74 \ub370\uc774\ud130\uc5d0 \ud544\uc694\ud55c \uc800\uc7a5 \uacf5\uac04\uc774 \uc904\uc5b4\ub4e4\uc5b4 \ube44\uc6a9\uc774 \uc808\uac10\ub418\uace0, \uac80\uc0ac\ud574\uc57c \ud560 \ub370\uc774\ud130\uac00 \uc904\uc5b4\ub4e4\uc5b4 \ucffc\ub9ac \ucc98\ub9ac \uc18d\ub3c4\uac00 \ube68\ub77c\uc9d1\ub2c8\ub2e4.<\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>\ucffc\ub9ac \ucd5c\uc801\ud654<\/strong>Redshift\uc5d0\ub294 \ucffc\ub9ac\uac00 \uac00\ub2a5\ud55c \ud55c \ud6a8\uc728\uc801\uc73c\ub85c \uc2e4\ud589\ub418\ub3c4\ub85d \ubcf4\uc7a5\ud558\ub294 \ucffc\ub9ac \ucd5c\uc801\ud654 \ud504\ub85c\uadf8\ub7a8\uc774 \ub0b4\uc7a5\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130 \ubd84\ud3ec\uc640 \uc778\ub371\uc2f1 \uc804\ub7b5\uc5d0 \ub530\ub77c \uc790\ub3d9\uc73c\ub85c \ucd5c\uc801\uc758 \uc2e4\ud589 \uacc4\ud68d\uc744 \uc120\ud0dd\ud569\ub2c8\ub2e4.<\/span><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<h3 id=\"heading-setting-up-aws-redshift\" class=\"permalink-heading\"><span style=\"color: #000000;\">AWS Redshift \uc124\uc815<\/span><\/h3>\n<p><span style=\"color: #000000;\">Redshift \uc124\uc815\uc740 \ube44\uad50\uc801 \uac04\ub2e8\ud569\ub2c8\ub2e4. \uac01 \ub2e8\uacc4\uc5d0 \ub300\ud55c \uac04\ub7b5\ud55c \uac1c\uc694\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<ol>\n<li><span style=\"color: #000000;\"><strong>Redshift \ud074\ub7ec\uc2a4\ud130 \uc0dd\uc131<\/strong>\uba3c\uc800 Redshift \ud074\ub7ec\uc2a4\ud130\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4. \uadc0\ud558\uc758 \ub370\uc774\ud130\ub294 \uc774 \ud074\ub7ec\uc2a4\ud130\uc5d0 \uc800\uc7a5\ub429\ub2c8\ub2e4. \uc124\uc815 \uacfc\uc815\uc5d0\uc11c \uc800\uc7a5\uc18c \ubc0f \uc131\ub2a5 \uc694\uad6c \uc0ac\ud56d\uc5d0 \ub530\ub77c \ud074\ub7ec\uc2a4\ud130 \ud06c\uae30\uc640 \ub178\ub4dc \uc218\ub97c \uc120\ud0dd\ud569\ub2c8\ub2e4.<\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>\ubcf4\uc548 \uad6c\uc131<\/strong>\ub2e4\uc74c\uc73c\ub85c \ubcf4\uc548\uc744 \uc124\uc815\ud558\uc138\uc694. \uc5ec\uae30\uc5d0\ub294 \uac00\uc0c1 \uc0ac\uc124 \ud074\ub77c\uc6b0\ub4dc(VPC)\ub97c \uc0dd\uc131\ud558\uace0 IAM \uc5ed\ud560\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc561\uc138\uc2a4 \uc81c\uc5b4 \uc815\ucc45\uc744 \uc124\uc815\ud558\ub294 \uac83\uc774 \ud3ec\ud568\ub429\ub2c8\ub2e4. \ub610\ud55c, \uc800\uc7a5 \uc911\uacfc \uc804\uc1a1 \uc911\uc5d0 \ub370\uc774\ud130\ub97c \uc554\ud638\ud654\ud558\uc5ec \ubcf4\ud638\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>\ub370\uc774\ud130 \ub85c\ub529 \uc911<\/strong>\ud074\ub7ec\uc2a4\ud130\ub97c \uc124\uc815\ud55c \ud6c4 Redshift\uc5d0 \ub370\uc774\ud130\ub97c \ub85c\ub4dc\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. AWS\ub294 \ub2e4\uc74c\uc744 \ud3ec\ud568\ud558\uc5ec \ub370\uc774\ud130 \ub85c\ub4dc\ub97c \uc704\ud55c \uc5ec\ub7ec \uac00\uc9c0 \ubc29\ubc95\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<strong>\uc544\ub9c8\uc874 S3<\/strong>,<strong>AWS \uae00\ub8e8<\/strong>\ub610\ub294<strong>Redshift COPY \uba85\ub839<\/strong>.<\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>\ucffc\ub9ac \uc2e4\ud589<\/strong>\ub370\uc774\ud130\ub97c \ub85c\ub4dc\ud55c \ud6c4 \uc0ac\uc6a9\uc744 \uc2dc\uc791\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<strong>SQL<\/strong>\uc774\uc5d0 \ub300\ud55c \ucffc\ub9ac\ub97c \uc2e4\ud589\ud574 \ubcf4\uc138\uc694. Redshift\ub294 \ud45c\uc900 SQL \uad6c\ubb38\uc744 \uc9c0\uc6d0\ud558\ubbc0\ub85c BI \ud50c\ub7ab\ud3fc \ubc0f \ub370\uc774\ud130 \uc2dc\uac01\ud654 \ub3c4\uad6c\uc640 \uac19\uc740 \ub2e4\ub978 \ub3c4\uad6c\uc640 \uc27d\uac8c \ud1b5\ud569\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>\uc131\ub2a5 \ubaa8\ub2c8\ud130\ub9c1<\/strong>AWS\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \ub2e4\uc591\ud55c \ubaa8\ub2c8\ud130\ub9c1 \ub3c4\uad6c\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4.<strong>\ud074\ub77c\uc6b0\ub4dc\uc6cc\uce58<\/strong>Redshift \ud074\ub7ec\uc2a4\ud130\uc758 \uc131\ub2a5\uc744 \ucd94\uc801\ud569\ub2c8\ub2e4. \uc774\ub294 \ubcd1\ubaa9 \ud604\uc0c1\uc744 \ud30c\uc545\ud558\uace0 \ub354 \ub098\uc740 \uc131\ub2a5\uc744 \uc704\ud574 \ucffc\ub9ac\ub97c \ucd5c\uc801\ud654\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4.<\/span><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<h3 id=\"heading-use-cases-for-aws-redshift\" class=\"permalink-heading\"><span style=\"color: #000000;\">AWS Redshift \uc0ac\uc6a9 \uc0ac\ub840<\/span><\/h3>\n<p><span style=\"color: #000000;\">AWS Redshift\ub294 \ub2e4\uc591\ud55c \uc0ac\uc6a9 \uc0ac\ub840\uc5d0 \uc801\ud569\ud569\ub2c8\ub2e4.<\/span><\/p>\n<ol>\n<li><span style=\"color: #000000;\"><strong>\ube44\uc988\ub2c8\uc2a4 \uc778\ud154\ub9ac\uc804\uc2a4(BI)<\/strong> \ud68c\uc0ac\uc5d0\uc11c\ub294 Redshift\ub97c \uc0ac\uc6a9\ud558\uc5ec \ubcf4\uace0\uc11c\uc640 \ub300\uc2dc\ubcf4\ub4dc\ub97c \uc2e4\ud589\ud558\uace0 \uace0\uac1d \ud589\ub3d9, \ub9e4\ucd9c \ubc0f \uae30\ud0c0 \uc9c0\ud45c\uc5d0 \ub300\ud55c \uc2ec\uce35 \ubd84\uc11d\uc744 \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>\ub370\uc774\ud130 \ub808\uc774\ud06c \ud1b5\ud569<\/strong>Redshift\ub294 Amazon S3\uc640 \uc27d\uac8c \ud1b5\ud569\ub418\ubbc0\ub85c \ub370\uc774\ud130 \ub808\uc774\ud06c\uc5d0 \uc800\uc7a5\ub41c \ub370\uc774\ud130\ub97c \ubd84\uc11d\ud558\ub294 \ub370 \uc774\uc0c1\uc801\uc785\ub2c8\ub2e4. Redshift\uc758 \uad6c\uc870\ud654\ub41c \ub370\uc774\ud130\uc640 S3\uc758 \ube44\uad6c\uc870\ud654\ub41c \ub370\uc774\ud130\ub97c \uacb0\ud569\ud558\uba74 \ub354\uc6b1 \ud3ec\uad04\uc801\uc778 \ubd84\uc11d\uc744 \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>ETL \uc6cc\ud06c\ud50c\ub85c<\/strong>Redshift\ub97c \uc0ac\uc6a9\ud558\uba74 ETL(\ucd94\ucd9c, \ubcc0\ud658, \ub85c\ub4dc) \uc6cc\ud06c\ud50c\ub85c\ub97c \uad6c\ucd95\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. AWS Glue\ub098 \ub2e4\ub978 ETL \ub3c4\uad6c\uc640 \ud1b5\ud569\ud558\uba74 \ub2e4\uc591\ud55c \uc18c\uc2a4\uc758 \ub370\uc774\ud130\ub97c Redshift\ub85c \uc62e\uaca8\uc11c \ucc98\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>\uc2e4\uc2dc\uac04 \ubd84\uc11d<\/strong>Redshift Spectrum\uc744 \uc0ac\uc6a9\ud558\uba74 Redshift\uc640 Amazon S3\uc5d0 \uc800\uc7a5\ub41c \ub370\uc774\ud130\uc5d0 \ub300\ud574 \ucffc\ub9ac\ub97c \uc2e4\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \ub300\uaddc\ubaa8 \ub370\uc774\ud130 \uc138\ud2b8\uc758 \uc2e4\uc2dc\uac04 \ubd84\uc11d\uc774 \uac00\ub2a5\ud574\uc838 \ub354 \ub098\uc740 \uc758\uc0ac \uacb0\uc815\uc774 \uac00\ub2a5\ud574\uc9d1\ub2c8\ub2e4.<\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>\uba38\uc2e0 \ub7ec\ub2dd<\/strong>Redshift\ub97c Amazon SageMaker\uc640 \ud1b5\ud569\ud558\uba74 \uba38\uc2e0 \ub7ec\ub2dd \ubaa8\ub378\uc744 \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\uc5d0 \ub300\ud55c \uc608\uce21 \ubd84\uc11d\uc744 \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<h3 id=\"heading-pricing\" class=\"permalink-heading\"><span style=\"color: #000000;\">\uac00\uaca9<\/span><\/h3>\n<p><span style=\"color: #000000;\">Redshift \uac00\uaca9\uc740 \ub178\ub4dc \uc720\ud615 \ubc0f \uc218, \uc0ac\uc6a9\ud558\ub294 \uc800\uc7a5 \uc6a9\ub7c9, \ub370\uc774\ud130 \uc804\uc1a1 \ube44\uc6a9\uc744 \ud3ec\ud568\ud55c \ub2e4\uc591\ud55c \uc694\uc778\uc5d0 \ub530\ub77c \ub2ec\ub77c\uc9d1\ub2c8\ub2e4. AWS\uc5d0\uc11c \uc81c\uacf5<strong>\uc8fc\ubb38\ud615 \uac00\uaca9 \ucc45\uc815<\/strong>(\uc0ac\uc6a9\ud558\uba74\uc11c \uc9c0\ubd88) \ubc0f<strong>\uc608\uc57d \uac00\uaca9<\/strong>(\uc7a5\uae30 \uc57d\uc815\uc5d0 \ub300\ud55c \uc120\ubd88\uc740 \ud560\uc778\ub41c \uac00\uaca9\uc73c\ub85c \uc81c\uacf5\ub429\ub2c8\ub2e4). \ud074\ub7ec\uc2a4\ud130 \ud06c\uae30\ub97c \uc870\uc815\ud558\uac70\ub098 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc744 \ub54c \uc911\uc9c0\ud558\uac70\ub098 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<strong>\uc544\ub9c8\uc874 \ub808\ub4dc\uc2dc\ud504\ud2b8 \uc2a4\ud399\ud2b8\ub7fc<\/strong>\ud568\uc218\ub294 S3\uc5d0\uc11c \uc9c1\uc811 \ub370\uc774\ud130\ub97c \ucffc\ub9ac\ud558\uc5ec \ube44\uc6a9\uc744 \ucd5c\uc801\ud654\ud569\ub2c8\ub2e4.<\/span><\/p>\n<p>&nbsp;<\/p>\n<h3 id=\"heading-conclusion\" class=\"permalink-heading\"><span style=\"color: #000000;\">\uacb0\ub860\uc801\uc73c\ub85c<\/span><\/h3>\n<p><span style=\"color: #000000;\">AWS Redshift\ub294 \uac15\ub825\ud558\uace0 \ud655\uc7a5 \uac00\ub2a5\ud55c \ud074\ub77c\uc6b0\ub4dc \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4 \uc194\ub8e8\uc158\uc785\ub2c8\ub2e4. \uace0\uc131\ub2a5, \uc0ac\uc6a9 \ud3b8\uc758\uc131, \uad11\ubc94\uc704\ud55c AWS \uc0dd\ud0dc\uacc4\uc640\uc758 \ud1b5\ud569 \ub4f1\uc758 \ud2b9\uc9d5\uc774 \uacb0\ud569\ub418\uc5b4 \ub300\uaddc\ubaa8 \ub370\uc774\ud130 \uc138\ud2b8\ub97c \ud6a8\uc728\uc801\uc73c\ub85c \ubd84\uc11d\ud558\ub824\ub294 \ubaa8\ub4e0 \uaddc\ubaa8\uc758 \uae30\uc5c5\uc5d0 \ub9e4\uc6b0 \uc801\ud569\ud55c \uc120\ud0dd\uc785\ub2c8\ub2e4. \ub370\uc774\ud130 \ub808\uc774\ud06c\ub97c \uad6c\ucd95\ud558\ub4e0, \ubcf5\uc7a1\ud55c \ubd84\uc11d\uc744 \uc2e4\ud589\ud558\ub4e0, \uba38\uc2e0 \ub7ec\ub2dd\uc744 \ud65c\uc6a9\ud558\ub4e0, Redshift\ub294 \ub370\uc774\ud130\ub97c \ube60\ub974\uace0 \uc548\uc804\ud558\uac8c \uc774\ud574\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4.<\/span><\/p>","protected":false},"excerpt":{"rendered":"<p>\uc624\ub298\ub0a0\uc758 \ub370\uc774\ud130 \uc911\uc2ec \uc138\uacc4\uc5d0\uc11c \uae30\uc5c5\uc740 \ud1b5\ucc30\ub825\uc744 \uc5bb\uace0 \uc815\ubcf4\uc5d0 \uc785\uac01\ud55c \uc758\uc0ac \uacb0\uc815\uc744 \ub0b4\ub9ac\uae30 \uc704\ud574 \ubc29\ub300\ud55c \uc591\uc758 \ub370\uc774\ud130\ub97c \ucc98\ub9ac\ud558\uace0 \ubd84\uc11d\ud574\uc57c \ud569\ub2c8\ub2e4. \uae30\uc874\uc758 \ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4 \uc194\ub8e8\uc158\uc740 \uc885\uc885 \ubcf5\uc7a1\ud55c \uc778\ud504\ub77c, \ub192\uc740 \ube44\uc6a9, \ud655\uc7a5\uc131 \ubb38\uc81c\ub97c \uc548\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>","protected":false},"author":1,"featured_media":2523,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[65],"tags":[],"class_list":["post-2520","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\/2520","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=2520"}],"version-history":[{"count":0,"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/posts\/2520\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/media\/2523"}],"wp:attachment":[{"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/media?parent=2520"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/categories?post=2520"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/tags?post=2520"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}