{"id":2906,"date":"2021-01-24T22:38:43","date_gmt":"2021-01-25T06:38:43","guid":{"rendered":"https:\/\/www.gudusoft.com\/?page_id=2906"},"modified":"2021-03-24T00:57:44","modified_gmt":"2021-03-24T08:57:44","slug":"snowflake-data-lineage","status":"publish","type":"page","link":"https:\/\/www.gudusoft.com\/ko\/%eb%88%88%ec%86%a1%ec%9d%b4-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4\/","title":{"rendered":"Snowflake \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc790\ub3d9\ud654\ub41c \ub370\uc774\ud130 \uacc4\ubcf4"},"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\"><h4>SQLFlow including <a href=\"https:\/\/www.gudusoft.com\/ko\/%ea%b7%b8%eb%9e%98%eb%b9%97\/\">the grabit tool<\/a> connect to snowflake database and get the lineage for all the objects in the database. It will\u00a0 analyse the Sql, DDL,procedures, functions. All snowflake specific SQL statements are supoprted including: create stage, copy into, create file format and etc.<\/h4>\n<\/div><div class=\"fusion-text fusion-text-2\"><p>\uc774 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc740 \uc2a4\ub178\uc6b0\ud50c\ub808\uc774\ud06c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ub370\uc774\ud130 \ud750\ub984\uc744 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. AWS S3 \ub370\uc774\ud130 \uc18c\uc2a4\uc5d0\uc11c \uc0dd\uc131\ub41c \uc774 \ub370\uc774\ud130\ub294 create stage, create file format, copy into snowplay \uba85\ub839\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc2a4\ub178\uc6b0\ud50c\ub808\uc774\ud06c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c \ubcf5\uc0ac\ub429\ub2c8\ub2e4. \uadf8\ub7f0 \ub2e4\uc74c create temporary table \ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc784\uc2dc \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ub418\uace0, \ub9c8\uc9c0\ub9c9\uc73c\ub85c BI \ubc0f \uae30\ud0c0 \uc2dc\uc2a4\ud15c\uc5d0\uc11c \uc0ac\uc6a9\ud560 \ubdf0\uc5d0 \ub370\uc774\ud130\uac00 \uc9d1\uacc4\ub429\ub2c8\ub2e4.<\/p>\n<\/div><div style=\"text-align:center;\"><span class=\"fusion-imageframe imageframe-none imageframe-1 hover-type-none\"><a class=\"fusion-no-lightbox\" href=\"https:\/\/sqlflow.gudusoft.com\" target=\"_self\" aria-label=\"\uc2a4\ud14c\uc774\uc9c0\uc758 \ub208\uc1a1\uc774 \ub370\uc774\ud130\"><img decoding=\"async\" width=\"909\" height=\"277\" alt=\"\uc2a4\ud14c\uc774\uc9c0\uc758 \ub208\uc1a1\uc774 \ub370\uc774\ud130\" src=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2021\/03\/snowflake-data-from-stage.png\" class=\"img-responsive wp-image-3029\" srcset=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2021\/03\/snowflake-data-from-stage-200x61.png 200w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2021\/03\/snowflake-data-from-stage-400x122.png 400w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2021\/03\/snowflake-data-from-stage-600x183.png 600w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2021\/03\/snowflake-data-from-stage-800x244.png 800w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2021\/03\/snowflake-data-from-stage.png 909w\" sizes=\"(max-width: 1024px) 100vw, (max-width: 640px) 100vw, 909px\" \/><\/a><\/span><\/div><div class=\"fusion-separator fusion-full-width-sep\" style=\"align-self: center;margin-left: auto;margin-right: auto;margin-top:10px;margin-bottom:20px;width:100%;\"><\/div><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-0{width:100% !important;margin-top : 0px;margin-bottom : 20px;}.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;order : 0;}.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;order : 0;}.fusion-builder-column-0 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-1 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;\"><style type=\"text\/css\">@media only screen and (max-width:1024px) {.fusion-title.fusion-title-1{margin-top:10px!important;margin-bottom:20px!important;}}<\/style><div class=\"fusion-title title fusion-title-1 fusion-sep-none fusion-title-center fusion-title-text fusion-title-size-three\" style=\"margin-top:10px;margin-bottom:20px;\"><h3 class=\"title-heading-center\" style=\"margin:0;\"><h3>SQLFlow\ub97c \uc0ac\uc6a9\ud558\ub294 \ub370 \uac00\uc7a5 \uc801\ud569\ud55c \ubc29\ubc95\uc744 \uc120\ud0dd\ud558\ub824\uba74 \uc544\uc774\ucf58\uc744 \ud074\ub9ad\ud558\uc138\uc694.<\/h3><\/h3><\/div><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-1{width:100% !important;margin-top : 0px;margin-bottom : 20px;}.fusion-builder-column-1 > .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-1{width:100% !important;order : 0;}.fusion-builder-column-1 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-1{width:100% !important;order : 0;}.fusion-builder-column-1 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-2 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-content-boxes content-boxes columns row fusion-columns-2 fusion-columns-total-2 fusion-content-boxes-1 content-boxes-icon-on-top content-left\" data-animationoffset=\"100%\" style=\"margin-top:50px;margin-bottom:20px;\"><style type=\"text\/css\">.fusion-content-boxes-1 .heading .content-box-heading {color:#202020;}\n\t\t\t\t\t.fusion-content-boxes-1 .fusion-content-box-hover .link-area-link-icon-hover .heading .content-box-heading,\n\t\t\t\t\t.fusion-content-boxes-1 .fusion-content-box-hover .link-area-link-icon-hover .heading .heading-link .content-box-heading,\n\t\t\t\t\t.fusion-content-boxes-1 .fusion-content-box-hover .link-area-box-hover .heading .content-box-heading,\n\t\t\t\t\t.fusion-content-boxes-1 .fusion-content-box-hover .link-area-box-hover .heading .heading-link .content-box-heading,\n\t\t\t\t\t.fusion-content-boxes-1 .fusion-content-box-hover .link-area-link-icon-hover.link-area-box .fusion-read-more,\n\t\t\t\t\t.fusion-content-boxes-1 .fusion-content-box-hover .link-area-link-icon-hover.link-area-box .fusion-read-more::after,\n\t\t\t\t\t.fusion-content-boxes-1 .fusion-content-box-hover .link-area-link-icon-hover.link-area-box .fusion-read-more::before,\n\t\t\t\t\t.fusion-content-boxes-1 .fusion-content-box-hover .fusion-read-more:hover:after,\n\t\t\t\t\t.fusion-content-boxes-1 .fusion-content-box-hover .fusion-read-more:hover:before,\n\t\t\t\t\t.fusion-content-boxes-1 .fusion-content-box-hover .fusion-read-more:hover,\n\t\t\t\t\t.fusion-content-boxes-1 .fusion-content-box-hover .link-area-box-hover.link-area-box .fusion-read-more,\n\t\t\t\t\t.fusion-content-boxes-1 .fusion-content-box-hover .link-area-box-hover.link-area-box .fusion-read-more::after,\n\t\t\t\t\t.fusion-content-boxes-1 .fusion-content-box-hover .link-area-box-hover.link-area-box .fusion-read-more::before,\n\t\t\t\t\t.fusion-content-boxes-1 .fusion-content-box-hover .link-area-link-icon-hover .icon .circle-no,\n\t\t\t\t\t.fusion-content-boxes-1 .heading .heading-link:hover .content-box-heading {\n\t\t\t\t\t\tcolor: #ffa737;\n\t\t\t\t\t}\n\t\t\t\t\t.fusion-content-boxes-1 .fusion-content-box-hover .link-area-box-hover .icon .circle-no {\n\t\t\t\t\t\tcolor: #ffa737 !important;\n\t\t\t\t\t}.fusion-content-boxes-1 .fusion-content-box-hover .link-area-box.link-area-box-hover .fusion-content-box-button {background: #ffb251;color: #ffffff;}.fusion-content-boxes-1 .fusion-content-box-hover .link-area-box.link-area-box-hover .fusion-content-box-button .fusion-button-text {color: #ffffff;}\n\t\t\t\t\t.fusion-content-boxes-1 .fusion-content-box-hover .link-area-link-icon-hover .heading .icon > span {\n\t\t\t\t\t\tbackground-color: transparent !important;\n\t\t\t\t\t}\n\t\t\t\t\t.fusion-content-boxes-1 .fusion-content-box-hover .link-area-box-hover .heading .icon > span {\n\t\t\t\t\t\tborder-color: #ffa737 !important;\n\t\t\t\t\t}<\/style><div class=\"fusion-column content-box-column content-box-column content-box-column-1 col-lg-6 col-md-6 col-sm-6 fusion-content-box-hover content-box-column-first-in-row\"><div class=\"col content-box-wrapper content-wrapper link-area-link-icon link-type-text icon-hover-animation-slide\" style=\"background-color:rgba(255,255,255,0);\" data-animationoffset=\"100%\"><div class=\"heading heading-with-icon icon-left\"><a class=\"heading-link\" href=\"https:\/\/github.com\/sqlparser\/sqlflow_public\/tree\/master\/databases\/snowflake\" target=\"_self\"><div class=\"icon\"><i style=\"background-color:transparent;border-color:transparent;height:auto;width: 60px;line-height:normal;color:#ffa737;font-size:60px;\" aria-hidden=\"true\" class=\"fontawesome-icon fa-chart-area fas circle-no\"><\/i><\/div><h2 class=\"content-box-heading\" style=\"font-size:28px;line-height:33px;\">GUI \ubaa8\ub4dc<\/h2><\/a><\/div><div class=\"fusion-clearfix\"><\/div><div class=\"content-container\" style=\"color:#5d5f64;\">\n<p>GUI\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130 \uacc4\ud1b5\uc744 \uac80\uc0c9\ud558\uc138\uc694<\/p>\n<\/div><\/div><\/div><div class=\"fusion-column content-box-column content-box-column content-box-column-2 col-lg-6 col-md-6 col-sm-6 fusion-content-box-hover content-box-column-last content-box-column-last-in-row\"><div class=\"col content-box-wrapper content-wrapper link-area-link-icon link-type-text icon-hover-animation-slide\" style=\"background-color:rgba(255,255,255,0);\" data-animationoffset=\"100%\"><div class=\"heading heading-with-icon icon-left\"><a class=\"heading-link\" href=\"https:\/\/github.com\/sqlparser\/sqlflow_public\/blob\/master\/databases\/snowflake\/grabit-snowflake-command-line.md\" target=\"_self\"><div class=\"icon\"><i style=\"background-color:transparent;border-color:transparent;height:auto;width: 60px;line-height:normal;color:#ffa737;font-size:60px;\" aria-hidden=\"true\" class=\"fontawesome-icon fa-terminal fas circle-no\"><\/i><\/div><h2 class=\"content-box-heading\" style=\"font-size:28px;line-height:33px;\">\uba85\ub839\uc904 \ubaa8\ub4dc<\/h2><\/a><\/div><div class=\"fusion-clearfix\"><\/div><div class=\"content-container\" style=\"color:#5d5f64;\">\n<p>\uba85\ub839\uc904\uc744 \uc0ac\uc6a9\ud55c \uc790\ub3d9\ud654\ub41c \ub370\uc774\ud130 \uacc4\ubcf4<\/p>\n<\/div><\/div><\/div><style type=\"text\/css\">\n\t\t\t\t\t\t.fusion-content-boxes-1 .fusion-content-box-hover .heading-link:hover .icon i.circle-yes,\n\t\t\t\t\t\t.fusion-content-boxes-1 .fusion-content-box-hover .link-area-box:hover .heading-link .icon i.circle-yes,\n\t\t\t\t\t\t.fusion-content-boxes-1 .fusion-content-box-hover .link-area-link-icon-hover .heading .icon i.circle-yes,\n\t\t\t\t\t\t.fusion-content-boxes-1 .fusion-content-box-hover .link-area-box-hover .heading .icon i.circle-yes {\n\t\t\t\t\t\t\tbackground-color: transparent !important;\n\t\t\t\t\t\t\tborder-color: #ffa737 !important;\n\t\t\t\t\t\t}<\/style><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-2{width:100% !important;margin-top : 0px;margin-bottom : 20px;}.fusion-builder-column-2 > .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-2{width:100% !important;order : 0;}.fusion-builder-column-2 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-2{width:100% !important;order : 0;}.fusion-builder-column-2 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-3 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;\"><style type=\"text\/css\">@media only screen and (max-width:1024px) {.fusion-title.fusion-title-2{margin-top:10px!important;margin-bottom:30px!important;}}<\/style><div class=\"fusion-title title fusion-title-2 fusion-sep-none fusion-title-center fusion-title-text fusion-title-size-one\" style=\"margin-top:10px;margin-bottom:30px;\"><h1 class=\"title-heading-center\" style=\"margin:0;\"><h2 style=\"text-align: center;\">\uc790\ub3d9\ud654\ub41c \ub208\uc1a1\uc774 \ub370\uc774\ud130 \uacc4\ud1b5\ub3c4<\/h2><\/h1><\/div><div style=\"text-align:center;\"><span class=\"fusion-imageframe imageframe-none imageframe-2 hover-type-none\"><a class=\"fusion-no-lightbox\" href=\"https:\/\/sqlflow.gudusoft.com\" target=\"_blank\" aria-label=\"\ub208\uc1a1\uc774 \ub370\uc774\ud130 \uacc4\ubcf4\" rel=\"noopener noreferrer\"><img decoding=\"async\" width=\"800\" height=\"891\" alt=\"\ub208\uc1a1\uc774 \ub370\uc774\ud130 \uacc4\ubcf4\" src=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2021\/03\/grabit-data-lineage-overview-e1616562916534.png\" class=\"img-responsive wp-image-2979\"\/><\/a><\/span><\/div><div class=\"fusion-separator fusion-full-width-sep\" style=\"align-self: center;margin-left: auto;margin-right: auto;margin-top:10px;margin-bottom:30px;width:100%;\"><\/div><div class=\"fusion-text fusion-text-3\"><h4>1. SQLFlow\ub294 Snowflake, SQL Server, Oracle \ub4f1 20\uac1c \uc774\uc0c1\uc758 \uc8fc\uc694 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc9c0\uc6d0\ud569\ub2c8\ub2e4.<br \/>\n2. You will install The SQLFlow On-Premise version on your own site; users inside your organization can access the data lineage document freely without the need to log in as <a href=\"https:\/\/sqlflow.gudusoft.com\">the SQLFlow Cloud<\/a> does.<br \/>\n3. SQLFlow \uc628\ud504\ub808\ubbf8\uc2a4 \ubc84\uc804\uc740 \uc0ac\uc774\ud2b8\uc5d0 \ub530\ub77c \ub77c\uc774\uc13c\uc2a4\uac00 \ubd80\uc5ec\ub418\ubbc0\ub85c \uc870\uc9c1 \ub0b4\uc758 \ubaa8\ub4e0 \uc0ac\uc6a9\uc790\ub294 \ucd94\uac00 \ube44\uc6a9\uc744 \uc9c0\ubd88\ud560 \ud544\uc694\uac00 \uc5c6\uc2b5\ub2c8\ub2e4.<br \/>\n4. The SQLFlow On-Premise version can be customized and integrate into your owner data catalog, and support other data warehouses as well, feel free to <a href=\"https:\/\/www.gudusoft.com\/ko\/%ed%8b%b0%ec%bc%93-%ec%a0%9c%ec%b6%9c\/\">contact us<\/a> for further information.<\/h4>\n<\/div><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-3{width:100% !important;margin-top : 0px;margin-bottom : 20px;}.fusion-builder-column-3 > .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-3{width:100% !important;order : 0;}.fusion-builder-column-3 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-3{width:100% !important;order : 0;}.fusion-builder-column-3 > .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":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages\/2906"}],"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=2906"}],"version-history":[{"count":27,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages\/2906\/revisions"}],"predecessor-version":[{"id":3048,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages\/2906\/revisions\/3048"}],"wp:attachment":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/media?parent=2906"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}