{"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\/es\/linaje-de-datos-de-copos-de-nieve\/","title":{"rendered":"Linaje de datos automatizado de la base de datos Snowflake"},"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\/es\/agarrar\/\">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>Este diagrama muestra el flujo de datos en una base de datos de Snowflake. Se origin\u00f3 en una fuente de datos de AWS S3, se copi\u00f3 a la base de datos de Snowflake mediante los comandos &quot;create stage&quot;, &quot;create file format&quot; y &quot;copy into snowflake&quot;. Posteriormente, se guard\u00f3 en una tabla temporal mediante la instrucci\u00f3n &quot;create Temporary Table&quot;. Finalmente, los datos se agregaron a la vista que utilizar\u00e1n el BI y otros sistemas.<\/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=\"datos de copos de nieve del escenario\"><img decoding=\"async\" width=\"909\" height=\"277\" alt=\"datos de copos de nieve del escenario\" 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>Haga clic en el icono para elegir su forma preferida de utilizar SQLFlow<\/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;\">Modo GUI<\/h2><\/a><\/div><div class=\"fusion-clearfix\"><\/div><div class=\"content-container\" style=\"color:#5d5f64;\">\n<p>Descubra el linaje de datos mediante la GUI<\/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;\">Modo de l\u00ednea de comandos<\/h2><\/a><\/div><div class=\"fusion-clearfix\"><\/div><div class=\"content-container\" style=\"color:#5d5f64;\">\n<p>Linaje de datos automatizado con l\u00ednea de comandos<\/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;\">Diagrama automatizado de linaje de datos de copos de nieve<\/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=\"linaje de datos de copos de nieve\" rel=\"noopener noreferrer\"><img decoding=\"async\" width=\"800\" height=\"891\" alt=\"linaje de datos de copos de nieve\" 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 admite m\u00e1s de 20 bases de datos principales, como Snowflake, SQL Server, Oracle, etc.<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. La versi\u00f3n SQLFlow On-Premise tiene licencia seg\u00fan el sitio; todos los usuarios dentro de una organizaci\u00f3n no necesitan pagar ninguna tarifa adicional.<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\/es\/enviar-un-ticket\/\">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\/es\/wp-json\/wp\/v2\/pages\/2906"}],"collection":[{"href":"https:\/\/www.gudusoft.com\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.gudusoft.com\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/es\/wp-json\/wp\/v2\/comments?post=2906"}],"version-history":[{"count":27,"href":"https:\/\/www.gudusoft.com\/es\/wp-json\/wp\/v2\/pages\/2906\/revisions"}],"predecessor-version":[{"id":3048,"href":"https:\/\/www.gudusoft.com\/es\/wp-json\/wp\/v2\/pages\/2906\/revisions\/3048"}],"wp:attachment":[{"href":"https:\/\/www.gudusoft.com\/es\/wp-json\/wp\/v2\/media?parent=2906"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}