{"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":"

\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

\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

\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

\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

1. SQLFlow Cloud \uc6f9\uc744 \uc0ac\uc6a9\ud558\uc138\uc694<\/h3>\n

\uc0ac\uc774\ud2b8\ub97c \uc5f0 \ud6c4: 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

\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

\"CSV\uc758<\/a><\/p>\n

 <\/p>\n

2. SQLFlow Rest API \uc0ac\uc6a9<\/h3>\n

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

\uc6d0\ud558\ub294 \ub370\uc774\ud130 \uacc4\ud1b5\uc744 CSV, JSON, Graphml \ud615\uc2dd\uc73c\ub85c \ubc18\ud658\ud569\ub2c8\ub2e4.<\/p>\n

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

\"SQLFlow<\/a><\/p>\n

 <\/p>\n

3. Grabit \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uc138\uc694<\/h3>\n

\ub3c5\ub9bd\ud615 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \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

\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

\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. \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":"

As you may know, data linage is quite important in the enterprise environment, it […]<\/p>","protected":false},"author":1,"featured_media":2605,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[38],"tags":[],"_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}]}}