{"id":2601,"date":"2020-12-16T14:32:00","date_gmt":"2020-12-16T06:32:00","guid":{"rendered":"https:\/\/www.gudusoft.com\/?p=2601"},"modified":"2020-12-18T15:40:27","modified_gmt":"2020-12-18T07:40:27","slug":"3-ways-to-capture-data-lineage-in-sql-and-save-in-csv-in-just-1-minute","status":"publish","type":"post","link":"https:\/\/www.gudusoft.com\/ko\/%eb%8b%a8-1%eb%b6%84-%eb%a7%8c%ec%97%90-sql%ec%97%90%ec%84%9c-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4%eb%a5%bc-%ec%ba%a1%ec%b2%98%ed%95%98%ea%b3%a0-csv%eb%a1%9c-%ec%a0%80%ec%9e%a5%ed%95%98\/","title":{"rendered":"SQL\uc5d0\uc11c \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \ucea1\ucc98\ud558\uace0 \ub2e8 1\ubd84 \ub9cc\uc5d0 CSV\ub85c \uc800\uc7a5\ud558\ub294 3\uac00\uc9c0 \ubc29\ubc95"},"content":{"rendered":"<p>\uc544\uc2dc\ub2e4\uc2dc\ud53c, \ub370\uc774\ud130 \ub9ac\ub2c8\uc9c0\ub294 \uae30\uc5c5 \ud658\uacbd\uc5d0\uc11c \ub9e4\uc6b0 \uc911\uc694\ud569\ub2c8\ub2e4.<\/p>\n<p>\ub2e4\uc591\ud55c \ubcc0\uacbd\uacfc \uacbd\ub85c\uc0c1\uc758 \uc774\ub3d9\uc744 \ud1b5\ud574 \uc18c\uc2a4\uc5d0\uc11c \ubaa9\uc801\uc9c0\uae4c\uc9c0 \ub370\uc774\ud130 \ud750\ub984\/\uc774\ub3d9\uc744 \ubc1c\uacac\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc774 \uae00\uc5d0\uc11c\ub294 SQL\uc5d0\uc11c \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \ucea1\ucc98\ud558\uace0 \ubcc0\uacbd \uc0ac\ud56d\uacfc \ud649\uc744 CSV \ud30c\uc77c\ub85c \ub2e8 1\ubd84 \ub9cc\uc5d0 \uc800\uc7a5\ud558\ub294 3\uac00\uc9c0 \ubc29\ubc95\uc744 \ubcf4\uc5ec\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc774 CSV \ud30c\uc77c\uc744 \uc0ac\uc6a9\ud558\uba74 Microsoft Excel\uc5d0\uc11c \uc5f4\uc5b4 \ub370\uc774\ud130 \uc774\ub3d9\uc744 \ubd84\uc11d\ud558\uac70\ub098 CSV \ud30c\uc77c\uc758 \uba54\ud0c0\ub370\uc774\ud130\ub97c \ub370\uc774\ud130 \uce74\ud0c8\ub85c\uadf8\ub85c \uac00\uc838\uc640\uc11c \ucd94\uac00 \uc870\uc0ac\ub97c \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h3>1. SQLFlow Cloud \uc6f9\uc744 \uc0ac\uc6a9\ud558\uc138\uc694<\/h3>\n<p>\uc0ac\uc774\ud2b8\ub97c \uc5f0 \ud6c4: <a href=\"https:\/\/sqlflow.gudusoft.com\">https:\/\/sqlflow.gudusoft.com<\/a>\ubd84\uc11d\uc774 \ud544\uc694\ud55c SQL \uc2a4\ud06c\ub9bd\ud2b8\ub97c \ubd99\uc5ec\ub123\uac70\ub098 \uc5ec\ub7ec SQL \ud30c\uc77c\uc744 \ud3ec\ud568\ud55c zip \ud30c\uc77c\uc744 \uc5c5\ub85c\ub4dc\ud558\uae30\ub9cc \ud558\uba74 \ub429\ub2c8\ub2e4.<\/p>\n<p>\uc2dc\uac01\ud654 \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uba74 \ub370\uc774\ud130 \uacc4\ud1b5\uc774 \uc774\uc640 \uac19\uc774 \uc2dc\uac01\ud654\ub418\uba70, \uadf8 \uacb0\uacfc\ub97c CSV \ud30c\uc77c\ub85c \ub2e4\uc6b4\ub85c\ub4dc\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p><a href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=sqlflow-post&amp;utm_medium=post\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-2605 size-full\" title=\"CSV\uc758 \ub370\uc774\ud130 \uacc4\ubcf4\" src=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2020\/12\/data-lineage-csv.png\" alt=\"CSV\uc758 \ub370\uc774\ud130 \uacc4\ubcf4\" width=\"847\" height=\"476\" srcset=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2020\/12\/data-lineage-csv.png 847w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2020\/12\/data-lineage-csv-300x169.png 300w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2020\/12\/data-lineage-csv-768x432.png 768w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2020\/12\/data-lineage-csv-200x112.png 200w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2020\/12\/data-lineage-csv-400x225.png 400w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2020\/12\/data-lineage-csv-600x337.png 600w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2020\/12\/data-lineage-csv-800x450.png 800w\" sizes=\"(max-width: 847px) 100vw, 847px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3>2. SQLFlow Rest API \uc0ac\uc6a9<\/h3>\n<p>Java, Python, C# \ub4f1\uacfc \uac19\uc740 \uc120\ud638\ud558\ub294 \ud504\ub85c\uadf8\ub798\ubc0d \uc5b8\uc5b4\ub85c \ub2e8\uc77c SQL \ud30c\uc77c\uc774\ub098 \uc5ec\ub7ec SQL \ud30c\uc77c\uc744 \ud3ec\ud568\ud558\ub294 zip \ud30c\uc77c\uc744 SQLFlow \uc11c\ubc84\uc5d0 \uc81c\ucd9c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc6d0\ud558\ub294 \ub370\uc774\ud130 \uacc4\ud1b5\uc744 CSV, JSON, Graphml \ud615\uc2dd\uc73c\ub85c \ubc18\ud658\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc790\uc138\ud55c \uc9c0\uce68\uc744 \ud655\uc778\ud558\ub824\uba74 \uc544\ub798 \uc774\ubbf8\uc9c0\ub97c \ud074\ub9ad\ud558\uc138\uc694.<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.gudusoft.com\/ko\/sqlflow-restful-api\/?utm_source=sqlflow-post&amp;utm_medium=post\"><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-2607 size-large\" src=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2020\/12\/sqlflow-rest-api-1024x503.png\" alt=\"SQLFlow REST API\" width=\"1024\" height=\"503\" srcset=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2020\/12\/sqlflow-rest-api-1024x503.png 1024w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2020\/12\/sqlflow-rest-api-300x147.png 300w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2020\/12\/sqlflow-rest-api-768x377.png 768w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2020\/12\/sqlflow-rest-api-200x98.png 200w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2020\/12\/sqlflow-rest-api-400x196.png 400w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2020\/12\/sqlflow-rest-api-600x295.png 600w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2020\/12\/sqlflow-rest-api-800x393.png 800w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2020\/12\/sqlflow-rest-api.png 1130w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3>3. Grabit \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uc138\uc694<\/h3>\n<p>\ub3c5\ub9bd\ud615 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. <a href=\"https:\/\/www.gudusoft.com\/ko\/%ea%b7%b8%eb%9e%98%eb%b9%97\/\">\uadf8\ub798\ube57<\/a> \ud30c\uc77c \uc2dc\uc2a4\ud15c, Github\/Bitbucket, \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c SQL \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc218\uc9d1\ud569\ub2c8\ub2e4.<\/p>\n<p>\uadf8\ub9ac\uace0 SQLFlow\ub85c \ubcf4\ub0b4\uc11c \ubd84\uc11d\uc744 \uac70\uccd0 CSV, JSON, Graphml \ud615\uc2dd\uc73c\ub85c \ub370\uc774\ud130 \uacc4\ud1b5\uc744 \uc5bb\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc774 \ub3c4\uad6c\ub294 \ud604\uc7ac \ubca0\ud0c0 \ub2e8\uacc4\uc5d0 \uc788\uc73c\ubbc0\ub85c \uc6d0\ud558\uc2dc\uba74 \uc2dc\ub3c4\ud574 \ubcf4\uc138\uc694. <a href=\"https:\/\/www.gudusoft.com\/ko\/grabit-beta-%ea%b0%80%ec%9e%85\/\">\uac00\uc785\ud558\ub2e4<\/a> \uadf8\ub7ec\uba74 \ub354 \uc790\uc138\ud55c \uc815\ubcf4\ub97c \ubcf4\ub0b4\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.<\/p>","protected":false},"excerpt":{"rendered":"<p>As you may know, data linage is quite important in the enterprise environment, it discovers the data flow\/movement from its source to destination via various changes and hops on its way. In this article, I will show you 3 ways to capture data lineage in SQL and save the changes and hops in a CSV file in just 1 minute. With this CSV file in hand, you can open it with Microsoft Excel to analyze the data movement or import the metadata in the CSV file into your data catalog for further investigation. 1. Use the SQLFlow Cloud web After\u2026<\/p>","protected":false},"author":1,"featured_media":2605,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[38],"tags":[],"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\/2601"}],"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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/comments?post=2601"}],"version-history":[{"count":9,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts\/2601\/revisions"}],"predecessor-version":[{"id":2618,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts\/2601\/revisions\/2618"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/media\/2605"}],"wp:attachment":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/media?parent=2601"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/categories?post=2601"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/tags?post=2601"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}