{"id":3554,"date":"2022-04-26T06:51:53","date_gmt":"2022-04-26T14:51:53","guid":{"rendered":"https:\/\/www.gudusoft.com\/?p=3554"},"modified":"2026-07-11T22:56:12","modified_gmt":"2026-07-12T06:56:12","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":"

<\/p>\r\n

Amazon Redshift \ub370\uc774\ud130 \uacc4\ubcf4 | Gudu SQLFlow<\/strong><\/h2>\r\n\r\n

Amazon \ucc3d\uace0 \ud658\uacbd\uc5d0\uc11c \ub2e4\uc74c\uc744 \uc0ac\uc6a9\ud558\uc138\uc694. \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>\r\n\r\n

\"Amazon
Amazon Redshift \ub370\uc774\ud130 \uacc4\ubcf4<\/figcaption><\/figure>\r\n\r\n

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. \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>\r\n\r\n\r\n\r\n

\uc5bb\ub294 \ud55c \uac00\uc9c0 \ubc29\ubc95 \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. Redshift \uc0ac\uc6a9\uc790 \ud65c\ub3d9 \ub85c\uadf8<\/a><\/strong> \uadf8\ub9ac\uace0 \uad6c\ub450<\/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>\r\n\r\n\r\n\r\n

Redshift \uc0ac\uc6a9\uc790 \ud65c\ub3d9 \ub85c\uadf8<\/h3>\r\n\r\n\r\n\r\n

\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>\r\n\r\n\r\n\r\n

\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>\r\n\r\n\r\n\r\n

\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\uc5f4 \uc774\ub984<\/th>\r\n\uc124\uba85<\/th>\r\n<\/tr>\r\n<\/thead>\r\n
\uae30\ub85d \uc2dc\uac04<\/td>\r\n\uc0ac\uac74\uc774 \ubc1c\uc0dd\ud55c \uc2dc\uac04.<\/td>\r\n<\/tr>\r\n
\ub514\ube44<\/td>\r\n\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc774\ub984.<\/td>\r\n<\/tr>\r\n
\uc0ac\uc6a9\uc790<\/td>\r\n\uc0ac\uc6a9\uc790 \uc774\ub984.<\/td>\r\n<\/tr>\r\n
\ud53c\ub514<\/td>\r\n\ud574\ub2f9 \uba85\ub839\ubb38\uacfc \uc5f0\uad00\ub41c \ud504\ub85c\uc138\uc2a4 ID\uc785\ub2c8\ub2e4.<\/td>\r\n<\/tr>\r\n
\uc0ac\uc6a9\uc790 ID<\/td>\r\n\uc0ac\uc6a9\uc790 ID.<\/td>\r\n<\/tr>\r\n
xid<\/td>\r\n\uac70\ub798 ID.<\/td>\r\n<\/tr>\r\n
\uc9c8\ubb38<\/td>\r\nLOG: \uc811\ub450\uc0ac \ub4a4\uc5d0 \uc904\ubc14\uafc8\uc744 \ud3ec\ud568\ud55c \ucffc\ub9ac \ud14d\uc2a4\ud2b8\uac00 \uc635\ub2c8\ub2e4.<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n
Redshift user activity log<\/figcaption>\r\n<\/figure>\r\n\r\n\r\n\r\n

\ud655\uc778\ud574\uc8fc\uc138\uc694 \uc774 \uae30\uc0ac<\/a> \ub85c\uae45\uc744 \ud65c\uc131\ud654\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf4\uc138\uc694.<\/p>\r\n

\r\n\r\n<\/p>\r\n

Amazon Redshift \uc0ac\uc6a9\uc790 \ud65c\ub3d9 \uac10\uc0ac \ub85c\uadf8 \uc0d8\ud50c<\/h5>\r\n

\r\n\r\n<\/p>\r\n

'2018-05-21T06:00:09Z UTC [db=prod_sales user=duc pid=99753 userid=95 xid=6728324]' \ub85c\uadf8: SumoProdbackUp.organization \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4(select * from SumoProd.simpleuser) '2018-05-21T06:00:09Z UTC [db=vendor user=ankit pid=36616 userid=53 xid=2956702]' \ub85c\uadf8: SumoProd.employee\uc5d0\uc11c \uc0ad\uc81c WHERE id = 38; '2018-05-21T06:20:09Z UTC [db=dev user=himanshu pid=64458 userid=35 xid=5143208]' \ub85c\uadf8: testuser3 \uc0ac\uc6a9\uc790\ub97c \uc0ad\uc81c\ud569\ub2c8\ub2e4.<\/code><\/pre>\r\n
\r\n\r\n<\/p>\r\n
 <\/p>\r\n
\r\n\r\n<\/p>\r\n
\uc790\ub3d9 \ub370\uc774\ud130 \uacc4\ud1b5 \ubd84\uc11d<\/h3>\r\n
\r\n\r\n<\/p>\r\n
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>\r\n
\r\n\r\n<\/p>\r\n
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>\r\n
\r\n\r\n<\/p>\r\n
<\/figure>\r\n
\r\n\r\n<\/p>\r\n
\"Amazon<\/a>\r\n
Amazon Redshift \ub370\uc774\ud130 \uacc4\ubcf4<\/figcaption>\r\n<\/figure>\r\n
\r\n\r\n\r\n\r\n<\/p>\r\n
 <\/p>\r\n
<\/p>\r\n
\uacb0\ub860<\/strong>\u00a0<\/h3>\r\n
\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. Amazon Redshift \ub370\uc774\ud130 \uacc4\ubcf4<\/strong>. \ub354 \uc54c\uace0 \uc2f6\ub2e4\uba74 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. 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! (Ryan\uc774 2022\ub144 4\uc6d4 26\uc77c\uc5d0 \ud3b8\uc9d1)<\/strong><\/p>\r\n
<\/p>","protected":false},"excerpt":{"rendered":"
Amazon Redshift Data Lineage | Gudu SQLFlow In your Amazon warehouse environment, use Amazon Redshift Spectrum to query data directly from files on Amazon S3, save data in Redshift databases, and use Business Intelligence tools such as Tableau, PowerBI, Looker, Qlik, Superset to generate reports from the data. The data originates from your business source system and lands on Amazon S3, then using an ETL tool such as DBT to transfer and store it in Redshift Database for later uses. In order to have an overview of the data flow in your Amazon warehouse system, you need a data lineage\u2026<\/p>","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],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"_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":32,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts\/3554\/revisions"}],"predecessor-version":[{"id":6616,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts\/3554\/revisions\/6616"}],"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}]}}