{"id":3554,"date":"2022-04-26T06:51:53","date_gmt":"2022-04-26T14:51:53","guid":{"rendered":"https:\/\/www.gudusoft.com\/?p=3554"},"modified":"2022-05-19T01:36:03","modified_gmt":"2022-05-19T09:36:03","slug":"amazon-redshift-data-lineage-gudu-sqlflow","status":"publish","type":"post","link":"https:\/\/www.gudusoft.com\/ko\/%ec%95%84%eb%a7%88%ec%a1%b4-%eb%a0%88%eb%93%9c%ec%8b%9c%ed%94%84%ed%8a%b8-%eb%8d%b0%ec%9d%b4%ed%84%b0-%eb%9d%bc%ec%9d%b8%ec%a7%80-gudu-sqlflow\/","title":{"rendered":"Amazon Redshift \ub370\uc774\ud130 \uacc4\ubcf4 | Gudu SQLFlow"},"content":{"rendered":"<div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-1 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#e8eaf0;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1310.4px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-0 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><div class=\"fusion-text fusion-text-1\" style=\"line-height:26px;\"><h2><strong>Amazon Redshift \ub370\uc774\ud130 \uacc4\ubcf4 | Gudu SQLFlow<\/strong><\/h2>\n<p>Amazon \ucc3d\uace0 \ud658\uacbd\uc5d0\uc11c \ub2e4\uc74c\uc744 \uc0ac\uc6a9\ud558\uc138\uc694. <strong><a class=\"rank-math-link\" href=\"https:\/\/docs.aws.amazon.com\/redshift\/latest\/dg\/c-getting-started-using-spectrum.html\">\uc544\ub9c8\uc874 \ub808\ub4dc\uc2dc\ud504\ud2b8 \uc2a4\ud399\ud2b8\ub7fc<\/a><\/strong> Amazon S3\uc758 \ud30c\uc77c\uc5d0\uc11c \uc9c1\uc811 \ub370\uc774\ud130\ub97c \ucffc\ub9ac\ud558\uace0, Redshift \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\uace0, Tableau, PowerBI, Looker, Qlik, Superset\uacfc \uac19\uc740 Business Intelligence \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\uc5d0\uc11c \ubcf4\uace0\uc11c\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4. \ub370\uc774\ud130\ub294 \ube44\uc988\ub2c8\uc2a4 \uc18c\uc2a4 \uc2dc\uc2a4\ud15c\uc5d0\uc11c \uc2dc\uc791\ud558\uc5ec Amazon S3\uc5d0 \ub3c4\ucc29\ud55c \ub2e4\uc74c DBT\uc640 \uac19\uc740 ETL \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub098\uc911\uc5d0 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub3c4\ub85d Redshift Database\uc5d0 \uc804\uc1a1\ud558\uc5ec \uc800\uc7a5\ud569\ub2c8\ub2e4.<\/p>\n<div id=\"attachment_3581\" style=\"width: 587px\" class=\"wp-caption aligncenter\"><img aria-describedby=\"caption-attachment-3581\" decoding=\"async\" class=\"size-full wp-image-3581\" src=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/Amazon_Redshift_Data_Lineage.png\" alt=\"Amazon Redshift \ub370\uc774\ud130 \uacc4\ubcf4\" width=\"577\" height=\"402\" srcset=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/Amazon_Redshift_Data_Lineage-200x139.png 200w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/Amazon_Redshift_Data_Lineage-300x209.png 300w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/Amazon_Redshift_Data_Lineage-400x279.png 400w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/Amazon_Redshift_Data_Lineage.png 577w\" sizes=\"(max-width: 577px) 100vw, 577px\" \/><p id=\"caption-attachment-3581\" class=\"wp-caption-text\">Amazon Redshift \ub370\uc774\ud130 \uacc4\ubcf4<\/p><\/div>\n<p>Amazon \ucc3d\uace0 \uc2dc\uc2a4\ud15c\uc758 \ub370\uc774\ud130 \ud750\ub984\uc744 \uac1c\uc694\ub85c \ud30c\uc545\ud558\ub824\uba74 \ub2e4\uc74c\uc774 \ud544\uc694\ud569\ub2c8\ub2e4. <strong>\ub370\uc774\ud130 \uacc4\ubcf4 \ub3c4\uad6c<\/strong> \ub370\uc774\ud130\uac00 \ud2b9\uc815 \uc704\uce58\uc5d0 \ub3c4\ub2ec\ud55c \uacfc\uc815\uacfc \ub370\uc774\ud130\uac00 \ube44\uc988\ub2c8\uc2a4 \uc2dc\uc2a4\ud15c\uc744 \ud1b5\uacfc\ud558\uba74\uc11c \ubc1c\uc0dd\ud558\ub294 \uc911\uac04 \ub2e8\uacc4\uc640 \ubcc0\ud658\uc744 \uc774\ud574\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4.<\/p>\n<p>\uc5bb\ub294 \ud55c \uac00\uc9c0 \ubc29\ubc95 <strong><a class=\"rank-math-link\" href=\"https:\/\/www.gudusoft.com\/ko\/%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4%ec%9d%98-%ec%a4%91%ec%9a%94%ec%84%b1\/\">\ub370\uc774\ud130 \ub77c\uc778\uc9c0<\/a><\/strong> Amazon \uc6e8\uc5b4\ud558\uc6b0\uc2a4 \ud658\uacbd\uc5d0\uc11c \uc790\ub3d9\uc73c\ub85c \ub370\uc774\ud130 \ub85c\ub529, \ubcc0\ud658 \ubc0f \ubd84\uc11d \uc911\uc5d0 \uc0ac\uc6a9\ub41c \ubaa8\ub4e0 SQL \ucffc\ub9ac\ub97c \ubd84\uc11d\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \uc88b\uc740 \uc18c\uc2dd\uc740 \ubaa8\ub4e0 SQL \ubb38\uc774 \ub2e4\uc74c\uc5d0 \uc800\uc7a5\ub41c\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. <strong><a class=\"rank-math-link\" href=\"https:\/\/docs.aws.amazon.com\/redshift\/latest\/mgmt\/db-auditing.html#db-auditing-logs\">Redshift \uc0ac\uc6a9\uc790 \ud65c\ub3d9 \ub85c\uadf8<\/a><\/strong> \uadf8\ub9ac\uace0 <strong>\uad6c\ub450<\/strong><strong> SQL\ud50c\ub85c\uc6b0<\/strong> \ub85c\uadf8 \ud30c\uc77c\uc744 \uad6c\ubb38 \ubd84\uc11d\ud558\uc5ec \uc790\ub3d9\uc73c\ub85c \ub370\uc774\ud130 \uacc4\ud1b5\uc744 \ud30c\uc545\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h3 class=\"wp-block-heading\">Redshift \uc0ac\uc6a9\uc790 \ud65c\ub3d9 \ub85c\uadf8<\/h3>\n<p>\uc0ac\uc6a9\uc790 \ud65c\ub3d9 \ub85c\uadf8\ub294 \uc8fc\ub85c \ubb38\uc81c \ud574\uacb0 \ubaa9\uc801\uc73c\ub85c \uc720\uc6a9\ud558\uba70 \uc5ec\uae30\uc11c\ub294 \ub370\uc774\ud130 \uacc4\ubcf4 \uac80\uc0c9\uc5d0 \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uc774\ub294 \uc0ac\uc6a9\uc790\uc640 \uc2dc\uc2a4\ud15c\uc774 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uc218\ud589\ud558\ub294 \ucffc\ub9ac \uc720\ud615\uc5d0 \ub300\ud55c \uc815\ubcf4\ub97c \ucd94\uc801\ud569\ub2c8\ub2e4.<\/p>\n<p><strong>\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uc2e4\ud589\ub418\uae30 \uc804\uc5d0 \uac01 \ucffc\ub9ac\ub97c \uae30\ub85d\ud569\ub2c8\ub2e4.<\/strong><\/p>\n<figure id=\"w251aac30c24c10b9c18b4\" class=\"wp-block-table\">\n<table>\n<thead>\n<tr>\n<th>\uc5f4 \uc774\ub984<\/th>\n<th>\uc124\uba85<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\uae30\ub85d \uc2dc\uac04<\/td>\n<td>\uc0ac\uac74\uc774 \ubc1c\uc0dd\ud55c \uc2dc\uac04.<\/td>\n<\/tr>\n<tr>\n<td>\ub514\ube44<\/td>\n<td>\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc774\ub984.<\/td>\n<\/tr>\n<tr>\n<td>\uc0ac\uc6a9\uc790<\/td>\n<td>\uc0ac\uc6a9\uc790 \uc774\ub984.<\/td>\n<\/tr>\n<tr>\n<td>\ud53c\ub514<\/td>\n<td>\ud574\ub2f9 \uba85\ub839\ubb38\uacfc \uc5f0\uad00\ub41c \ud504\ub85c\uc138\uc2a4 ID\uc785\ub2c8\ub2e4.<\/td>\n<\/tr>\n<tr>\n<td>\uc0ac\uc6a9\uc790 ID<\/td>\n<td>\uc0ac\uc6a9\uc790 ID.<\/td>\n<\/tr>\n<tr>\n<td>xid<\/td>\n<td>\uac70\ub798 ID.<\/td>\n<\/tr>\n<tr>\n<td>\uc9c8\ubb38<\/td>\n<td>LOG: \uc811\ub450\uc0ac \ub4a4\uc5d0 \uc904\ubc14\uafc8\uc744 \ud3ec\ud568\ud55c \ucffc\ub9ac \ud14d\uc2a4\ud2b8\uac00 \uc635\ub2c8\ub2e4.<\/td>\n<\/tr>\n<\/tbody>\n<\/table><figcaption>Redshift user activity log<\/figcaption><\/figure>\n<p>\ud655\uc778\ud574\uc8fc\uc138\uc694 <a class=\"rank-math-link\" href=\"https:\/\/docs.aws.amazon.com\/redshift\/latest\/mgmt\/db-auditing.html#db-auditing-logs\">\uc774 \uae30\uc0ac<\/a> \ub85c\uae45\uc744 \ud65c\uc131\ud654\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf4\uc138\uc694.<\/p>\n<\/p>\n<h5 class=\"wp-block-heading\">Amazon Redshift \uc0ac\uc6a9\uc790 \ud65c\ub3d9 \uac10\uc0ac \ub85c\uadf8 \uc0d8\ud50c<\/h5>\n<\/p>\n<pre class=\"wp-block-code\"><code>&#039;2018-05-21T06:00:09Z UTC [db=prod_sales user=duc pid=99753 userid=95 xid=6728324]&#039; \ub85c\uadf8: SumoProdbackUp.organization \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4(select * from SumoProd.simpleuser) &#039;2018-05-21T06:00:09Z UTC [db=vendor user=ankit pid=36616 userid=53 xid=2956702]&#039; \ub85c\uadf8: SumoProd.employee\uc5d0\uc11c \uc0ad\uc81c WHERE id = 38; &#039;2018-05-21T06:20:09Z UTC [db=dev user=himanshu pid=64458 userid=35 xid=5143208]&#039; \ub85c\uadf8: testuser3 \uc0ac\uc6a9\uc790\ub97c \uc0ad\uc81c\ud569\ub2c8\ub2e4.<\/code><\/pre>\n<\/p>\n<p>&nbsp;<\/p>\n<\/p>\n<h3 class=\"wp-block-heading\">\uc790\ub3d9 \ub370\uc774\ud130 \uacc4\ud1b5 \ubd84\uc11d<\/h3>\n<\/p>\n<p><strong><a class=\"rank-math-link\" href=\"https:\/\/sqlflow.gudusoft.com\">Gudu SQLFlow<\/a><\/strong> \ub370\uc774\ud130\ubca0\uc774\uc2a4, ETL, Business Intelligence, Cloud, Hadoop \ud658\uacbd\uc5d0\uc11c SQL \uc2a4\ud06c\ub9bd\ud2b8\uc640 \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800\ub97c \uad6c\ubb38 \ubd84\uc11d\ud558\uc5ec SQL \ub370\uc774\ud130 \uacc4\ubcf4 \ubd84\uc11d\uc744 \uc790\ub3d9\ud654\ud558\ub294 \ub3c4\uad6c\uc785\ub2c8\ub2e4. \ub610\ud55c Redshift \uc0ac\uc6a9\uc790 \ud65c\ub3d9 \ub85c\uadf8 \ud30c\uc77c\uc744 \ubd84\uc11d\ud558\uc5ec \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \ubc1c\uacac\ud558\uace0 \ubaa8\ub4e0 \ub370\uc774\ud130 \uc774\ub3d9\uc744 \uadf8\ub798\ud53d\uc73c\ub85c \ud45c\ud604\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<\/p>\n<p>Amazon Redshift \uc0ac\uc6a9\uc790 \ud65c\ub3d9 \ub85c\uadf8 \ud30c\uc77c\uc744 \ubd84\uc11d\ud55c \ud6c4 \uc0dd\uc131\ub41c \ub370\uc774\ud130 \uacc4\ubcf4 \uadf8\ub9bc\uc758 \uc77c\ubd80\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<\/p>\n<figure class=\"wp-block-image size-large\"><\/figure>\n<\/p>\n<figure class=\"wp-block-image alignnone wp-image-3564\"><a href=\"https:\/\/sqlflow.gudusoft.com\"><img decoding=\"async\" width=\"1024\" height=\"300\" class=\"wp-image-3564\" src=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/amazon-redshift-user-activity-log-data-lineage-1024x300.png\" alt=\"Amazon Redshift \ub370\uc774\ud130 \uacc4\ubcf4\u00a0\" srcset=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/amazon-redshift-user-activity-log-data-lineage-200x59.png 200w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/amazon-redshift-user-activity-log-data-lineage-300x88.png 300w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/amazon-redshift-user-activity-log-data-lineage-400x117.png 400w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/amazon-redshift-user-activity-log-data-lineage-600x176.png 600w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/amazon-redshift-user-activity-log-data-lineage-768x225.png 768w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/amazon-redshift-user-activity-log-data-lineage-800x234.png 800w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/amazon-redshift-user-activity-log-data-lineage-1024x300.png 1024w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/amazon-redshift-user-activity-log-data-lineage-1200x352.png 1200w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/amazon-redshift-user-activity-log-data-lineage-1536x450.png 1536w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/amazon-redshift-user-activity-log-data-lineage.png 1778w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>Amazon Redshift \ub370\uc774\ud130 \uacc4\ubcf4<\/figcaption><\/figure>\n<\/p>\n<p>&nbsp;<\/p>\n<\/p>\n<h3><strong>\uacb0\ub860<\/strong>\u00a0<\/h3>\n<p>\uc800\ud76c \uae30\uc0ac\ub97c \uc77d\uc5b4\uc8fc\uc154\uc11c \uac10\uc0ac\ud569\ub2c8\ub2e4. \uc774 \uae30\uc0ac\uac00 \uc5ec\ub7ec\ubd84\uc774 \ub354 \uc798 \uc774\ud574\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub418\uae30\ub97c \ubc14\ub78d\ub2c8\ub2e4. <strong>Amazon Redshift \ub370\uc774\ud130 \uacc4\ubcf4<\/strong>. \ub354 \uc54c\uace0 \uc2f6\ub2e4\uba74 <strong>Amazon Redshift \ub370\uc774\ud130 \uacc4\ubcf4<\/strong>, \uc800\ud76c \uc6f9\uc0ac\uc774\ud2b8\ub97c \ubc29\ubb38\ud574 \uc8fc\uc2dc\uae30\ub97c \ubc14\ub78d\ub2c8\ub2e4. <a href=\"https:\/\/sqlflow.gudusoft.com\"><strong>Gudu SQLFlow<\/strong><\/a> \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 Gudu SQLFlow\ub97c \ucc38\uc870\ud558\uc138\uc694. \ub370\uc774\ud130 \uacc4\ubcf4 \ubd84\uc11d \ub3c4\uad6c\uc778 Gudu SQLFlow\ub294 SQL \uc2a4\ud06c\ub9bd\ud2b8 \ud30c\uc77c\uc744 \ubd84\uc11d\ud558\uace0, \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uc5bb\uace0, \uc2dc\uac01\uc801 \ud45c\uc2dc\ub97c \uc218\ud589\ud560 \uc218 \uc788\uc744 \ubfd0\ub9cc \uc544\ub2c8\ub77c \uc0ac\uc6a9\uc790\uac00 CSV \ud615\uc2dd\uc73c\ub85c \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uc81c\uacf5\ud558\uace0 \uc2dc\uac01\uc801 \ud45c\uc2dc\ub97c \uc218\ud589\ud560 \uc218 \uc788\ub3c4\ub85d \ud569\ub2c8\ub2e4. \ub2e4\uc2dc \ud55c\ubc88 \uac10\uc0ac\ub4dc\ub9bd\ub2c8\ub2e4! <strong>(Ryan\uc774 2022\ub144 4\uc6d4 26\uc77c\uc5d0 \ud3b8\uc9d1)<\/strong><\/p>\n<\/div><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-0{width:100% !important;margin-top : 0px;margin-bottom : 0px;}.fusion-builder-column-0 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1024px) {.fusion-body .fusion-builder-column-0{width:100% !important;}.fusion-builder-column-0 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-0{width:100% !important;}.fusion-builder-column-0 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-1{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":27,"featured_media":3583,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[14],"tags":[89,90,91,75,92],"_links":{"self":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts\/3554"}],"collection":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/comments?post=3554"}],"version-history":[{"count":31,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts\/3554\/revisions"}],"predecessor-version":[{"id":3896,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts\/3554\/revisions\/3896"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/media\/3583"}],"wp:attachment":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/media?parent=3554"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/categories?post=3554"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/tags?post=3554"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}