{"id":1244,"date":"2020-11-16T02:19:25","date_gmt":"2020-11-16T02:19:25","guid":{"rendered":"https:\/\/www.gudusoft.com\/?page_id=1244"},"modified":"2026-07-13T20:37:20","modified_gmt":"2026-07-14T04:37:20","slug":"grabit","status":"publish","type":"page","link":"https:\/\/www.gudusoft.com\/ko\/%ea%b7%b8%eb%9e%98%eb%b9%97\/","title":{"rendered":"SQLFlow-ingester"},"content":{"rendered":"<p><strong>SQLFlow \uc778\uc81c\uc2a4\ud130<\/strong> (formerly Grabit) collects SQL from your data estate \u2014 the DDL of tables, views, stored procedures, functions, triggers, and packages \u2014 and feeds it to SQLFlow for column-level data lineage analysis. It reads from live databases over JDBC, from revision systems like GitHub and Bitbucket, and from the local file system. It extracts <strong>\uba54\ud0c0\ub370\uc774\ud130\ub9cc<\/strong> \uadf8\ub9ac\uace0 \ud14c\uc774\ube14\uc758 \ud589\uc744 \uc804\ud600 \uc77d\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"gd-stats\">\n<div class=\"gd-stat\"><b>13<\/b><span>JDBC\ub97c \ud1b5\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubc29\uc5b8<\/span><\/div>\n<div class=\"gd-stat\"><b>\uba54\ud0c0\ub370\uc774\ud130 \uc804\uc6a9<\/b><span>\uc77d\uae30 \uc804\uc6a9 \u2014 \ud14c\uc774\ube14 \ub370\uc774\ud130\ub97c \uc808\ub300 \uc77d\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/span><\/div>\n<div class=\"gd-stat\"><b>2<\/b><span>\ub0b4\ubcf4\ub0b4\uae30 \ud615\uc2dd \u2014 \ub2e8\uc77c JSON \ubc0f \ubd84\ud560\ub41c JSON<\/span><\/div>\n<div class=\"gd-stat\"><b>\uc5d0\uc5b4\uac2d<\/b><span>\uc77c\ubc18 \ud30c\uc77c \ucd9c\ub825\uc774\uba70, \ucc98\ub9ac\ud560 \ud65c\uc131 \uc5f0\uacb0\uc774 \uc5c6\uc2b5\ub2c8\ub2e4.<\/span><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-group gd-callout is-layout-constrained\"><div class=\"wp-block-group__inner-container\">\n\n<p><strong>3\ubd84 \uc548\uc5d0 \uc2e4\ud589\ud558\uc138\uc694:<\/strong> \uc778\uc81c\uc2a4\ud130\ub97c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc5f0\uacb0\ud558\uba74 \uba54\ud0c0\ub370\uc774\ud130 \ubc88\ub4e4\uc744 \uc0dd\uc131\ud558\uace0, SQLFlow\ub294 \uc774\ub97c \ub300\ud654\ud615 \uc5f4 \uc218\uc900 \uacc4\ubcf4 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc73c\ub85c \ubcc0\ud658\ud569\ub2c8\ub2e4. \ubaa8\ub4e0 \uc791\uc5c5\uc740 \uba85\ub839\uc904\uc5d0\uc11c \uc2e4\ud589\ub418\ubbc0\ub85c cron \uc791\uc5c5\uc73c\ub85c \uac04\ud3b8\ud558\uac8c \uc608\uc57d\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\uc138 \uac00\uc9c0 \uc720\ud615\uc758 \uc18c\uc2a4\uc5d0\uc11c SQL\uc744 \uc218\uc9d1\ud569\ub2c8\ub2e4.<\/h2>\n\n\n\n<div class=\"wp-block-columns are-vertically-aligned-center is-layout-flex wp-container-4\">\n\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow\" style=\"flex-basis:33.33%\">\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2020\/11\/database-400x265.png\" alt=\"\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc5f0\uacb0\" \/><\/figure>\n\n<\/div>\n\n\n\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow\" style=\"flex-basis:66.66%\">\n\n<h3 class=\"wp-block-heading\">\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc5f0\uacb0<\/h3>\n\n\n\n<p>DDL \ucd94\ucd9c \u2014 <code>\ud14c\uc774\ube14 \uc0dd\uc131<\/code>, <code>\ubdf0 \uc0dd\uc131<\/code>Oracle, SQL Server, Snowflake, PostgreSQL \ubc0f 9\uac1c \uc774\uc0c1\uc758 \ub2e4\ub978 SQL \ubc29\uc5b8\uc5d0\uc11c \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800, \ud568\uc218, \ud2b8\ub9ac\uac70 \ubc0f \uc81c\uc57d \uc870\uac74\uc744 JDBC\ub97c \ud1b5\ud574 \uac00\uc838\uc640 SQLFlow\ub85c \uc804\uc1a1\ud558\uc5ec \ubd84\uc11d\ud569\ub2c8\ub2e4.<\/p>\n\n<\/div>\n\n<\/div>\n\n\n\n<div class=\"wp-block-columns are-vertically-aligned-center is-layout-flex wp-container-7\">\n\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow\" style=\"flex-basis:66.66%\">\n\n<h3 class=\"wp-block-heading\">\ubcf5\uc2b5 \uc2dc\uc2a4\ud15c\uc5d0 \uc5f0\uacb0\ud558\uc138\uc694<\/h3>\n\n\n\n<p>GitHub, Bitbucket \ubc0f \uae30\ud0c0 \ubc84\uc804 \uad00\ub9ac \uc2dc\uc2a4\ud15c\uc5d0\uc11c SQL \ud30c\uc77c\uc744 \uc9c1\uc811 \uac00\uc838\uc640 SQLFlow\ub85c \uc804\uc1a1\ud558\uc5ec \ud300\uc5d0\uc11c \uc774\ubbf8 \ubc84\uc804 \uad00\ub9ac \uc911\uc778 \ucf54\ub4dc\uc5d0\uc11c \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uad6c\ucd95\ud558\uc138\uc694.<\/p>\n\n<\/div>\n\n\n\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow\" style=\"flex-basis:33.33%\">\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2020\/11\/githubbitbucket-400x244.png\" alt=\"GitHub \ub610\ub294 Bitbucket\uc5d0 \uc5f0\uacb0\ud558\uc138\uc694\" \/><\/figure>\n\n<\/div>\n\n<\/div>\n\n\n\n<div class=\"wp-block-columns are-vertically-aligned-center is-layout-flex wp-container-10\">\n\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow\" style=\"flex-basis:33.33%\">\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2020\/11\/filesystem-400x256.png\" alt=\"\ud30c\uc77c \uc2dc\uc2a4\ud15c\uc744 \uac80\uc0c9\ud558\uc138\uc694\" \/><\/figure>\n\n<\/div>\n\n\n\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow\" style=\"flex-basis:66.66%\">\n\n<h3 class=\"wp-block-heading\">\ud30c\uc77c \uc2dc\uc2a4\ud15c\uc744 \uac80\uc0c9\ud558\uc138\uc694<\/h3>\n\n\n\n<p>\ub85c\uceec \ub514\ub809\ud130\ub9ac \ud2b8\ub9ac\uc5d0\uc11c SQL \ud30c\uc77c\uc744 \ucc3e\uc544 SQLFlow\ub85c \ud478\uc2dc\ud558\uc5ec \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uc2dc\uac01\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub098 \uc800\uc7a5\uc18c\uc5d0 \uc800\uc7a5\ub418\uc9c0 \uc54a\uc740 \uc2a4\ud06c\ub9bd\ud2b8\ub098 \ub0b4\ubcf4\ub0b4\uae30 \ud30c\uc77c\uc5d0 \uc720\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n\n<\/div>\n\n<\/div>\n\n\n\n<div class=\"wp-block-group gd-panel-navy is-layout-constrained\"><div class=\"wp-block-group__inner-container\">\n\n<h2 class=\"wp-block-heading\">\ub0b4\ubcf4\ub0b4\uae30 \ud615\uc2dd\uc740 \ub2e8\uc77c JSON\uacfc \ubd84\ud560\ub41c JSON \ub450 \uac00\uc9c0\uc785\ub2c8\ub2e4.<\/h2>\n\n\n\n<p>\ub370\uc774\ud130 \uc218\uc9d1\uae30\uac00 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc77d\uc73c\uba74 \uc815\uaddc\ud654\ub41c \uba54\ud0c0\ub370\uc774\ud130 \ubc88\ub4e4\uc744 \uc791\uc131\ud569\ub2c8\ub2e4. \uc774 \ubc88\ub4e4\uc5d0\ub294 \uce74\ud0c8\ub85c\uadf8 \uad6c\uc870\uc640 \ubaa8\ub4e0 \ubdf0, \ud504\ub85c\uc2dc\uc800, \ud568\uc218, \ud2b8\ub9ac\uac70 \ubc0f \uc678\ub798 \ud0a4\uc758 DDL \ud14d\uc2a4\ud2b8\uac00 \ud3ec\ud568\ub429\ub2c8\ub2e4. \ud558\ub098\uc758 \ubaa8\ub378\ub85c \uc9c0\uc6d0\ub418\ub294 \ubaa8\ub4e0 \ubc29\uc5b8\uc744 \ud3ec\uad04\ud558\uba70, \uac01 \uacf5\uae09\uc5c5\uccb4\ub294 \uc790\uc0ac\uc5d0\uc11c \uc9c0\uc6d0\ud558\uc9c0 \uc54a\ub294 \uac1d\uccb4 \uc720\ud615\uc744 \uc0dd\ub7b5\ud569\ub2c8\ub2e4. \uc774 \ubc88\ub4e4\uc740 \ub450 \uac00\uc9c0 \ud615\ud0dc\ub85c \uc81c\uacf5\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th><\/th><th>\ub2e8\uc77c JSON<\/th><th>\ubd84\ud560\ub428(\uae30\ubcf8\uac12)<\/th><\/tr><\/thead><tbody>\n<tr><td>\ub514\uc2a4\ud06c\uc5d0<\/td><td>\ud558\ub098 <code>metadata.json<\/code> \ud30c\uc77c<\/td><td>\ub514\ub809\ud1a0\ub9ac: <code>manifest.json<\/code> + <code>\ubaa9\ub85d\/<\/code> + <code>\uc6d0\ucc9c\/<\/code> + <code>\uc0c9\uc778\/<\/code><\/td><\/tr>\n<tr><td>DDL\uc774 \uc0ac\ub294 \uacf3<\/td><td>\uc778\ub77c\uc778, \uc548\uc5d0 <code>\uc11c\ubc84[].\ucffc\ub9ac[]<\/code><\/td><td>~ \uc548\uc5d0 <code>source\/*.jsonl<\/code>\ubc14\uc774\ud2b8 \uc624\ud504\uc14b\uc73c\ub85c \uc704\uce58\ub97c \uc9c0\uc815\ud569\ub2c8\ub2e4. <code>\uc778\ub371\uc2a4\/*.idx<\/code><\/td><\/tr>\n<tr><td>~\uc5d0 \uac00\uc7a5 \uc801\ud569\ud568<\/td><td>\uc18c\uaddc\ubaa8 \ubc0f \uc911\uaddc\ubaa8 \uce74\ud0c8\ub85c\uadf8<\/td><td>\ub300\uaddc\ubaa8 \uc790\uc0b0 \uad00\ub9ac - \uce74\ud0c8\ub85c\uadf8\ub294 \uc0c1\uc8fc\ud558\uba70, \uc218 GB \uc6a9\ub7c9\uc758 DDL \uc2a4\ud2b8\ub9bc \ubc0f \uac80\uc0c9 \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/td><\/tr>\n<tr><td>\ucd94\uac00 \uae30\ub2a5<\/td><td>\uac00\uc7a5 \uac04\ud3b8\ud558\uac8c \uc12d\ucde8 \uac00\ub2a5<\/td><td>\uc0e4\ub4dc\ubcc4 SHA-256, \uac1d\uccb4\ubcc4 \ucf58\ud150\uce20 \ud574\uc2f1, \uc99d\ubd84 \ub0b4\ubcf4\ub0b4\uae30, \ube14\ub85d \uc555\ucd95<\/td><\/tr>\n<\/tbody><\/table><\/figure>\n\n\n\n<p><strong>\ub2e8\uc77c JSON<\/strong> \uc804\uccb4 \uc790\uc0b0\uc744 \ud558\ub098\uc758 \ud30c\uc77c\uc5d0 \ub2f4\uace0 \ubaa8\ub4e0 \uac1d\uccb4\uc758 DDL\uc744 \uc778\ub77c\uc778\uc73c\ub85c \ud3ec\ud568\uc2dc\ucf1c \ud30c\uc2f1\ud558\uae30 \uac00\uc7a5 \uac04\ub2e8\ud558\uac8c \ub9cc\ub4ed\ub2c8\ub2e4. <strong>\uc870\uac01\ub09c<\/strong> \ub300\uaddc\ubaa8 \ud658\uacbd\uc5d0\uc11c\ub294 \uc774 \ubc29\uc2dd\uc774 \uae30\ubcf8\uac12\uc785\ub2c8\ub2e4. \uc81c\ud55c\ub41c \uba54\ubaa8\ub9ac\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub0b4\ubcf4\ub0b4\uae30\ub97c \uc2a4\ud2b8\ub9ac\ubc0d\ud558\uace0, \uad6c\uc870\uc801 \uce74\ud0c8\ub85c\uadf8\ub97c \uc791\uace0 \uc0c1\uc8fc\uc801\uc73c\ub85c \uc720\uc9c0\ud558\uba70, \uc778\ub371\uc2a4\ub97c \ud1b5\ud574 DDL\uc744 \ubb34\uc791\uc704\ub85c \uac80\uc0c9\ud560 \uc218 \uc788\ub3c4\ub85d \ud558\uace0, \ub9e4\ub2c8\ud398\uc2a4\ud2b8\ub97c \ub9c8\uc9c0\ub9c9\uc5d0 \uae30\ub85d\ud558\uc5ec \uc18c\ube44\uc790\uac00 \ubd88\uc644\uc804\ud558\uac8c \uc791\uc131\ub41c \ub0b4\ubcf4\ub0b4\uae30\ub97c \ubcf4\uc9c0 \uc54a\ub3c4\ub85d \ud569\ub2c8\ub2e4. \ud544\ub4dc\ubcc4 \uc804\uccb4 \ucc38\uc870\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. <a href=\"https:\/\/docs.gudusoft.com\/7.-reference\/exporter-output\/single-json-export\/\">\ub2e8\uc77c JSON \ub0b4\ubcf4\ub0b4\uae30<\/a> \uadf8\ub9ac\uace0 <a href=\"https:\/\/docs.gudusoft.com\/7.-reference\/exporter-output\/sharded-export\/\">\ubd84\ud560\ub41c \ub0b4\ubcf4\ub0b4\uae30<\/a>.<\/p>\n\n<\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">SQL Server \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \ub370\uc774\ud130 \uacc4\ubcf4\ub97c 3\ubd84 \ub9cc\uc5d0 \ud655\uc778\ud558\uc138\uc694<\/h3>\n\n\n\n<figure class=\"wp-block-embed is-type-video\"><div class=\"wp-block-embed__wrapper\"><iframe loading=\"lazy\" width=\"800\" height=\"450\" src=\"https:\/\/www.youtube.com\/embed\/00Lgzy7ktpc\" frameborder=\"0\" allowfullscreen><\/iframe><\/div><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\uba85\ub839\uc904\uc5d0\uc11c \uc608\uc57d\ub41c \uc2dc\uac04\uc5d0 \uc2e4\ud589\ud558\uc138\uc694.<\/h3>\n\n\n\n<p>\uc774 \uc778\uc81c\uc2a4\ud130\ub294 \uba85\ub839\uc904\uc5d0\uc11c \uc2e4\ud589\ub418\ub294 \ub3c5\ub9bd\ud615 Java \ub3c4\uad6c\uc774\ubbc0\ub85c, \uc790\ub3d9\ud654\ub418\uace0 \ubc18\ubcf5 \uac00\ub2a5\ud55c \ucd94\ucd9c\uc744 \uc704\ud574 cron \uc791\uc5c5\uc73c\ub85c \uae54\ub054\ud558\uac8c \uc608\uc57d\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc554\ud638\ub294 \ud658\uacbd \ubcc0\uc218 \ub610\ub294 \ud30c\uc77c\uc5d0\uc11c \uc81c\uacf5\ud560 \uc218 \uc788\uc73c\ubbc0\ub85c \ud504\ub85c\uc138\uc2a4 \uc778\uc218\uc5d0 \ub098\ud0c0\ub098\uc9c0 \uc54a\uc73c\uba70, \uc138\ubd80\uc801\uc778 \ud3ec\ud568\/\uc81c\uc678 \ud544\ud130\ub97c \ud1b5\ud574 \ucd94\ucd9c\ud560 \ub370\uc774\ud130\ubca0\uc774\uc2a4, \uc2a4\ud0a4\ub9c8 \ubc0f \uac1d\uccb4\ub97c \uc815\ud655\ud558\uac8c \uc81c\uc5b4\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \ub2e4\uc74c\uc744 \ucc38\uc870\ud558\uc2ed\uc2dc\uc624. <a href=\"https:\/\/docs.gudusoft.com\/6.-sqlflow-ingester\/introduction\/sqlflow-exporter\/\">SQLFlow Ingester \ubb38\uc11c<\/a> to get started.<\/p>\n\n\n\n<div class=\"wp-block-group alignfull gd-band gd-band-navy gd-cta is-layout-constrained\" style=\"padding-top:56px;padding-bottom:56px\"><div class=\"wp-block-group__inner-container\">\n\n<h2 class=\"wp-block-heading\">\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc790\uc0b0\uc758 \uacc4\ubcf4\ub97c \ud655\uc778\ud558\uc138\uc694<\/h2>\n\n\n<p>SQLFlow Ingester\ub97c \ub2e4\uc6b4\ub85c\ub4dc\ud558\uace0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc9c0\uc815\ud55c \ub2e4\uc74c \uba54\ud0c0\ub370\uc774\ud130\ub97c \uc5f4 \uc218\uc900 \ub370\uc774\ud130 \uacc4\ubcf4\ub85c \ubcc0\ud658\ud558\uc138\uc694.<\/p>\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-12\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/github.com\/sqlparser\/sqlflow_public\/releases\">SQLFlow Ingester \ub2e4\uc6b4\ub85c\ub4dc<\/a><\/div>\n\n\n\n<div class=\"wp-block-button is-style-outline\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/docs.gudusoft.com\/6.-sqlflow-ingester\/introduction\/sqlflow-exporter\/\">\ubb38\uc11c\ub97c \uc77d\uc5b4\ubcf4\uc138\uc694<\/a><\/div>\n<\/div>\n\n<\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>SQLFlow Ingester (formerly Grabit) collects SQL from your data estate \u2014 the DDL of tables, views, stored procedures, functions, triggers, and packages \u2014 and feeds it to SQLFlow for column-level data lineage analysis. It reads from live databases over JDBC, from revision systems like GitHub and Bitbucket, and from the local file system. It extracts metadata only and never reads the rows in your tables. 13database dialects, over JDBC Metadata-onlyread-only \u2014 never reads table data 2export formats \u2014 single JSON and sharded Air-gappedplain-file output, no live connection to consume Run it in 3 minutes: point the ingester at a database,\u2026<\/p>","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"_links":{"self":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages\/1244"}],"collection":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/types\/page"}],"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=1244"}],"version-history":[{"count":82,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages\/1244\/revisions"}],"predecessor-version":[{"id":6829,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages\/1244\/revisions\/6829"}],"wp:attachment":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/media?parent=1244"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}