{"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":"2026-07-12T02:05:58","modified_gmt":"2026-07-12T10:05:58","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 \uacc4\ubcf4: \ucffc\ub9ac \uae30\ub85d\uc5d0\uc11c \uc5f4 \uc218\uc900 \uacc4\ubcf4 \ud655\uc778"},"content":{"rendered":"<p><strong>\uc2a4\ub178\uc6b0\ud50c\ub808\uc774\ud06c \ub370\uc774\ud130 \uacc4\ubcf4<\/strong> \uc774\ub294 Snowflake \uacc4\uc815\uc744 \ud1b5\ud574 \ub370\uc774\ud130\uac00 \uc774\ub3d9\ud558\ub294 \ubc29\uc2dd\uc744 \uc5f4 \uc218\uc900\uc5d0\uc11c \ubcf4\uc5ec\uc8fc\ub294 \uc9c0\ub3c4\uc785\ub2c8\ub2e4. \uc989, \uc5b4\ub5a4 \uc18c\uc2a4 \ud14c\uc774\ube14\uacfc \uc5f4\uc774 \uac01 \ub300\uc0c1 \ud14c\uc774\ube14, \ubdf0 \ub610\ub294 \ub300\uc2dc\ubcf4\ub4dc\uc5d0 \ub370\uc774\ud130\ub97c \uc81c\uacf5\ud558\ub294\uc9c0, \uadf8\ub9ac\uace0 \uc5b4\ub5a4 \ubcc0\ud658(\uc870\uc778, <code>\ub2e8\uc870\ub86d\uac8c \ud558\ub2e4<\/code> \ud655\uc7a5, \ucc3d \ud568\uc218, \ud544\ud130 \ub4f1\uc740 \uadf8 \uacfc\uc815\uc5d0\uc11c \ucd94\uac00\ub429\ub2c8\ub2e4. Snowflake\ub294 <code>\uacc4\uc815 \uc0ac\uc6a9\ub7c9<\/code> \ubdf0\ub294 \uc5b4\ub5a4 \uac1d\uccb4\uc5d0 \uc811\uadfc\ud588\ub294\uc9c0 \uc54c\ub824\uc8fc\uc9c0\ub9cc, \ud14c\uc774\ube14 \uc218\uc900\uc758 \uc811\uadfc \uae30\ub85d\uae4c\uc9c0\ub9cc \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. \ud55c \uc5f4\uc774 \ub2e4\ub978 \uc5f4\uc744 \uc5b4\ub5bb\uac8c \uacc4\uc0b0\ud588\ub294\uc9c0 \uc54c\uc544\ubcf4\ub824\uba74 SQL \ucffc\ub9ac \uc790\uccb4\ub97c \ubd84\uc11d\ud574\uc57c \ud569\ub2c8\ub2e4. <strong>Gudu SQLFlow<\/strong> \uc774 \ub3c4\uad6c\ub294 \uc815\ud655\ud788 \uadf8\ub7ec\ud55c \uae30\ub2a5\uc744 \uc218\ud589\ud569\ub2c8\ub2e4. Snowflake \ucffc\ub9ac \uae30\ub85d, DDL \ubc0f \ubdf0\ub97c \uc218\uc9d1\ud558\uace0 Snowflake \uc804\uc6a9 \ubb38\ubc95\uc744 \uc0ac\uc6a9\ud558\uc5ec \ubaa8\ub4e0 \ubb38\uc7a5\uc744 \uad6c\ubb38 \ubd84\uc11d\ud55c \ub2e4\uc74c \ub300\ud654\ud615 \uc5f4 \uc218\uc900 \uacc4\ubcf4 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained\" style=\"background-color:#eef7fb;padding-top:24px;padding-bottom:24px\"><div class=\"wp-block-group__inner-container\">\n\n<p><strong>\uc9c0\uae08 \ubc14\ub85c \ud655\uc778\ud558\uc138\uc694:<\/strong> Snowflake \ucffc\ub9ac\ub97c \uc5ec\uae30\uc5d0 \ubd99\uc5ec\ub123\uc73c\uc138\uc694. <a href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=gudusoft&amp;utm_medium=website&amp;utm_campaign=snowflake-data-lineage\" target=\"_blank\" rel=\"noreferrer noopener\">\ubb34\ub8cc \uc628\ub77c\uc778 \uc2a4\ub178\uc6b0\ud50c\ub808\uc774\ud06c \uacc4\ubcf4 \uc2dc\uac01\ud654 \ub3c4\uad6c<\/a> \u2014 Snowflake \ubc29\uc5b8\uc744 \uc120\ud0dd\ud558\uba74 \ub300\ud654\ud615 \uc5f4 \uc218\uc900 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc744 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud074\ub77c\uc6b0\ub4dc \ubc84\uc804\uc740 \ubb34\ub8cc \ud2f0\uc5b4\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Snowflake\uac00 \uae30\ubcf8\uc801\uc73c\ub85c \uc81c\uacf5\ud558\ub294 \uae30\ub2a5\uacfc \uadf8 \ud55c\uacc4\ub294 \ubb34\uc5c7\uc77c\uae4c\uc694?<\/h2>\n\n\n\n<p>Snowflake\ub294 \uc774\ubbf8 \ub9ce\uc740 \uac83\uc744 \uae30\ub85d\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. <code>\uacc4\uc815 \uc0ac\uc6a9\ub7c9<\/code> \uc2a4\ud0a4\ub9c8\ub294 \uacc4\uc815 \ud65c\ub3d9\uc5d0 \ub300\ud55c \uac1c\uc694\ub97c \uc81c\uacf5\ud558\uba70, \uc774\ub97c \ud1b5\ud574 \ucffc\ub9ac\uac00 \uc5b4\ub5a4 \ud14c\uc774\ube14\uc744 \uc77d\uc5c8\uace0 \uc5b4\ub5a4 \uac1d\uccb4\ub97c \uc218\uc815\ud588\ub294\uc9c0 \uc7ac\uad6c\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub294 \uc561\uc138\uc2a4 \uac10\uc0ac \ubc0f \ub300\ub7b5\uc801\uc778 \uc885\uc18d\uc131 \ud30c\uc545\uc5d0 \ub9e4\uc6b0 \uc720\uc6a9\ud558\uba70, Snowflake\uc758 \ubaa8\ub4e0 \uacc4\ubcf4 \uc804\ub7b5\uc740 \uc774\ub7ec\ud55c \uc6d0\uaca9 \uce21\uc815 \ub370\uc774\ud130\ub97c \ubb34\uc2dc\ud558\ub294 \ub300\uc2e0 \uc774\ub97c \uae30\ubc18\uc73c\ub85c \uc2dc\uc791\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uacc4\uc815 \uc0ac\uc6a9\ub7c9 \uc6d0\uaca9 \uce21\uc815 \ub370\uc774\ud130\uc5d0\uc11c \uc54c \uc218 \uc5c6\ub294 \uc815\ubcf4\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. <em>\ubcc0\ud658<\/em> \uceec\ub7fc \ub2e8\uc704\uc758 \ub370\uc774\ud130 \uacc4\ubcf4. \ucffc\ub9ac\uac00 \uc5b4\ub5a4 \ubd80\ubd84\uc744 \uac74\ub4dc\ub838\ub294\uc9c0 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4. <code>raw.orders<\/code> \uadf8\ub9ac\uace0 \uc37c\ub2e4 <code>\ubd84\uc11d.\uc218\uc775<\/code> \uadf8\uac83\uc740 \ub2f9\uc2e0\uc5d0\uac8c \ub9d0\ud574\uc8fc\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4 <code>\ucd1d \uc218\uc775<\/code> ~\uc774\ub2e4 <code>SUM(\uc8fc\ubb38 \uc218\ub7c9)<\/code> \uc0c1\ud0dc \ud544\ud130 \uc774\ud6c4\uc5d0 \ub610\ub294 <code>\uc790\uaca9<\/code> \uc808\uc774 \ucd9c\ub825\uc5d0 \uc804\ud600 \ub098\ud0c0\ub098\uc9c0 \uc54a\ub294 \uc5f4\uc744 \uae30\uc900\uc73c\ub85c \ud589\uc744 \uc870\uc6a9\ud788 \uc0ad\uc81c\ud588\uc2b5\ub2c8\ub2e4. \ud574\ub2f9 \uc815\ubcf4\ub294 \uc815\ud655\ud788 \ud55c \uacf3, \uc989 \ubb38\uc758 SQL \ud14d\uc2a4\ud2b8\uc5d0\ub9cc \uc874\uc7ac\ud569\ub2c8\ub2e4. \uc774\ub97c \ucd94\ucd9c\ud558\ub824\uba74 \uc2e4\uc81c Snowflake SQL \ud30c\uc11c, \uc989 \ud574\ub2f9 \uc5f4\uc744 \uc774\ud574\ud558\ub294 \ud30c\uc11c\uac00 \ud544\uc694\ud569\ub2c8\ub2e4. <code>\ub2e8\uc870\ub86d\uac8c \ud558\ub2e4<\/code>, <code>\uc790\uaca9<\/code>\ubc18\uad6c\uc870\ud654\ub41c <code>\ubcc0\uc885<\/code> \uacbd\ub85c, \ub2e4\ub2e8\uacc4 CTE \ubc0f <code>\uc120\ud0dd\ud558\ub2e4 *<\/code> \uc2e4\uc81c \uc2a4\ud0a4\ub9c8\uc5d0 \ub300\ud55c \ud655\uc7a5.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">QUERY_HISTORY\uc5d0\uc11c \ube4c\ub4dc \uacc4\ubcf4: \uc2e4\uc81c\ub85c \uc2e4\ud589\ub41c \ud56d\ubaa9<\/h2>\n\n\n\n<p>SQLFlow\ub294 \uc9c0\uc6d0\ud569\ub2c8\ub2e4. <strong>Snowflake \ucffc\ub9ac \uae30\ub85d\uc744 \uae30\ubcf8 \uc785\ub825\uc73c\ub85c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/strong>\ubb38\uc11c\ub098 \uc608\uc57d\ub41c \uc791\uc5c5 \uad6c\uc131\uc744 \ubcf4\uace0 \ud30c\uc774\ud504\ub77c\uc778\uc744 \ucd94\uce21\ud558\ub294 \ub300\uc2e0, Snowflake\uac00 \uc2e4\uc81c\ub85c \uc2e4\ud589\ud55c \ubb38\uc7a5\uc744 SQLFlow\uc5d0 \uc785\ub825\ud569\ub2c8\ub2e4. <code>\ud14c\uc774\ube14\uc744 SELECT \ud615\uc2dd\uc73c\ub85c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/code>, <code>\ub07c\uc6cc \ub123\ub2e4<\/code>, <code>\ubcd1\ud569<\/code>, \uadf8\ub9ac\uace0 <code>\ubcf5\uc0ac<\/code> \ucffc\ub9ac \uae30\ub85d\uc758 \uba85\ub839\ubb38\uacfc \ud574\ub2f9 \uba85\ub839\ubb38\uc5d0 \uc2a4\ud0a4\ub9c8 \ucee8\ud14d\uc2a4\ud2b8\ub97c \uc81c\uacf5\ud558\ub294 DDL \ubc0f \ubdf0 \uc815\uc758\ub97c \ud568\uaed8 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. \uacb0\uacfc\uc801\uc73c\ub85c \uc2e4\uc81c \uc0c1\ud669\uc5d0 \uae30\ubc18\ud55c \uacc4\ubcf4\ub97c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<ul><li><strong>\uc784\uc2dc SQL \ucffc\ub9ac\ub85c \uc778\ud55c \uc0ac\uac01\uc9c0\ub300\uac00 \uc5c6\uc2b5\ub2c8\ub2e4.<\/strong> \uc77c\ud68c\uc131 \ubc31\ud544, \ubd84\uc11d\uac00\uac00 \uc791\uc131\ud55c CTAS \ubb38, \ub178\ud2b8\ubd81\uc774\ub098 BI \ub3c4\uad6c\uc5d0\uc11c \uc2e4\ud589\ub41c \ucffc\ub9ac\ub294 \ubaa8\ub450 \ucffc\ub9ac \uae30\ub85d\uc5d0 \ub098\ud0c0\ub098\ubbc0\ub85c \ub370\uc774\ud130 \uacc4\ubcf4\uc5d0 \ud45c\uc2dc\ub429\ub2c8\ub2e4. \uc624\ucf00\uc2a4\ud2b8\ub808\uc774\ud130\uc758 \ub9ac\ud3ec\uc9c0\ud1a0\ub9ac\ub9cc \uc2a4\uce94\ud558\ub294 \uad6c\uc131 \uae30\ubc18 \uc811\uadfc \ubc29\uc2dd\uc740 \uc774\ub7ec\ud55c \ucffc\ub9ac\ub97c \uc644\uc804\ud788 \ub193\uce69\ub2c8\ub2e4.<\/li>\n<li><strong>\ubdf0\uac00 \uc62c\ubc14\ub974\uac8c \ud45c\uc2dc\ub429\ub2c8\ub2e4.<\/strong> SQLFlow\ub294 \ucffc\ub9ac \uae30\ub85d\uacfc \ud568\uaed8 \ubdf0 \uc815\uc758\ub97c \uc218\uc9d1\ud558\ubbc0\ub85c, \ubdf0 \uc815\uc758\ub97c \ub300\uc0c1\uc73c\ub85c \ud558\ub294 \ucffc\ub9ac\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. <code>vw_customer_360<\/code> \ubdf0 \ubcf8\ubb38\uc744 \ub530\ub77c \uae30\ubcf8 \ud14c\uc774\ube14\uacfc \uc5f4\uae4c\uc9c0 \ucd94\uc801\ud569\ub2c8\ub2e4.<\/li>\n<li><strong>\uc2a4\ud0c0 \ud655\uc7a5\uc740 \uc2e4\uc81c \uc2a4\ud0a4\ub9c8\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/strong> DDL\uc774 \ub85c\ub4dc\ub41c \uc0c1\ud0dc\uc785\ub2c8\ub2e4. <code>\uc120\ud0dd\ud558\ub2e4 *<\/code> \uc2e4\uc81c \uc5f4 \ubaa9\ub85d\uc73c\ub85c \ud655\uc7a5\ub418\ubbc0\ub85c \uc5f4 \uc218\uc900\uc758 \uacbd\uacc4\uac00 \ud14c\uc774\ube14 \uc218\uc900\uc758 \ucd94\uce21\uc73c\ub85c \ucd95\uc18c\ub418\uc9c0 \uc54a\uace0 \uc815\ud655\ud558\uac8c \uc720\uc9c0\ub429\ub2c8\ub2e4.<\/li><\/ul>\n\n\n\n<p>SQLFlow\ub294 \ubd99\uc5ec\ub123\uc740 SQL \ubc0f \uc5c5\ub85c\ub4dc\ub41c \ud30c\uc77c \uc678\uc5d0\ub3c4 JDBC \ubc0f dbt \ub9e4\ub2c8\ud398\uc2a4\ud2b8 \ud30c\uc77c\uc744 \ud1b5\ud55c \uc2e4\uc2dc\uac04 \uba54\ud0c0\ub370\uc774\ud130\ub97c \ud5c8\uc6a9\ud558\ubbc0\ub85c \uc2e4\ud589\ub41c \ucffc\ub9ac \uacc4\ubcf4\uc640 \ubaa8\ub378 \uc815\uc758 \uacc4\ubcf4\ub97c \ud558\ub098\uc758 \uadf8\ub798\ud504\ub85c \uacb0\ud569\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc5ec\ub7ec \uc6e8\uc5b4\ud558\uc6b0\uc2a4\ub97c \uc6b4\uc601\ud558\ub294 \uacbd\uc6b0 Redshift \ucffc\ub9ac \ub85c\uadf8\ub3c4 \ub3d9\uc77c\ud55c \ubc29\uc2dd\uc73c\ub85c \ucc98\ub9ac\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc2e4\uc81c Snowflake SQL\uc744 \ud1b5\ud55c \uc5f4 \uc218\uc900 \uacc4\ubcf4<\/h2>\n\n\n\n<p>Snowflake SQL\uc740 \uc77c\ubc18\uc801\uc778 ANSI \ud45c\uc900\uc774 \uc544\ub2d9\ub2c8\ub2e4. \ubc18\uc815\ud615\ud654\ub41c \ud488\ubaa9\uc744 \ud480\uc5b4\uc11c \uac01 \uace0\uac1d\uc758 \uc0c1\uc704 3\uac1c \uc8fc\ubb38\ub9cc \ub0a8\uae30\ub294 \ud30c\uc774\ud504\ub77c\uc778 \ub2e8\uacc4\ub97c \uc0dd\uac01\ud574 \ubcf4\uc138\uc694.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE OR REPLACE TABLE analytics.top_customer_orders AS SELECT o.customer_id, f.value:sku::STRING AS sku, f.value:qty::NUMBER AS quantity, o.order_total FROM raw.orders o, LATERAL FLATTEN(input =&gt; o.line_items) f QUALIFY ROW_NUMBER() OVER ( PARTITION BY o.customer_id ORDER BY o.order_total DESC ) &lt;= 3;<\/code><\/pre>\n\n\n\n<p>\uc774 \ud558\ub098\uc758 \uc9c4\uc220\uc5d0 \ub300\ud55c \uc815\ud655\ud55c \uacc4\ubcf4 \ubd84\uc11d\uc744 \uc704\ud574\uc11c\ub294 \ub2e4\uc74c \uc0ac\ud56d\uc744 \uc785\uc99d\ud574\uc57c \ud569\ub2c8\ub2e4. <code>\uc2a4\ucfe0<\/code> \uadf8\ub9ac\uace0 <code>\uc218\ub7c9<\/code> ~\uc5d0\uc11c \ud30c\uc0dd\ub418\ub2e4 <code>raw.orders.line_items<\/code> VARIANT \uceec\ub7fc\uc744 \ud1b5\ud574 <code>\ub2e8\uc870\ub86d\uac8c \ud558\ub2e4<\/code> \ud14c\uc774\ube14 \ud568\uc218\uc640 \ud615\ubcc0\ud658; <code>\uace0\uac1d ID<\/code> \uadf8\ub9ac\uace0 <code>\uc8fc\ubb38 \ucd1d\uc561<\/code> \uc9c1\uc811 \ud750\ub978\ub2e4\ub294 \uac83; \uadf8\ub9ac\uace0 \uadf8\uac83\uc740 <code>\uc790\uaca9<\/code> \uc870\ud56d\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4 <code>\uace0\uac1d ID<\/code> \uadf8\ub9ac\uace0 <code>\uc8fc\ubb38 \ucd1d\uc561<\/code> \uacb0\uacfc \uc9d1\ud569\uc744 \ub450 \ubc88\uc9f8\ub85c \uad6c\uc131\ud569\ub2c8\ub2e4. \ub370\uc774\ud130 \ud750\ub984\uc774 \uc544\ub2c8\ub77c \ud589 \ud544\ud130\ub9c1\uc774 \uc601\ud5a5\uc744 \ubbf8\uce58\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. SQLFlow\uc758 Snowflake \ud30c\uc11c\ub294 \uc774 \ubaa8\ub4e0 \uac83\uc744 \ubaa8\ub378\ub9c1\ud569\ub2c8\ub2e4. \uc65c\ub0d0\ud558\uba74 \uadf8 \uc544\ub798\uc5d0 \uc788\ub294 \uacc4\ubcf4 \uc5d4\uc9c4(\ub3d9\uc77c\ud55c) \ub54c\ubb38\uc785\ub2c8\ub2e4. <a href=\"https:\/\/www.sqlparser.com\/\">\uc77c\ubc18 SQL \ud30c\uc11c<\/a> (\uc57d 13,600\uac1c\uc758 \ubc29\uc5b8\ubcc4 \ud14c\uc2a4\ud2b8 \ud53d\uc2a4\ucc98\ub97c \ud1b5\ud574 \uac80\uc99d\ub41c) \uc5d4\uc9c4\uc740 \ubb38\uc758 \uc804\uccb4 \uc758\ubbf8 \ubaa8\ub378\uc744 \ud1b5\ud574 \ubaa8\ub4e0 \uc5f4 \ucc38\uc870\ub97c \ud574\uacb0\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc9c1\uacc4 \ud608\ud1b5 vs. \uac04\uc811 \ud608\ud1b5: QUALIFY\uac00 \uc911\uc694\ud55c \uc774\uc720<\/h2>\n\n\n\n<p>\uc800\uac83 <code>\uc790\uaca9<\/code> \uc774 \uc870\ud56d\uc740 \ub300\ubd80\ubd84\uc758 \uacc4\ubcf4 \ubd84\uc11d \ub3c4\uad6c\uac00 \uac04\uacfc\ud558\ub294 \ucc28\uc774\uc810\uc744 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. <strong>\uc9c1\uacc4 \ud608\ud1b5<\/strong> \ub370\uc774\ud130 \ud750\ub984\uc785\ub2c8\ub2e4: <code>\uc8fc\ubb38 \ucd1d\uc561<\/code> \ub545\uc5d0 <code>\ucd5c\uace0 \uace0\uac1d \uc8fc\ubb38 \uc218.\ucd1d \uc8fc\ubb38\ub7c9<\/code>. <strong>\uac04\uc811 \ud608\ud1b5<\/strong> \uc601\ud5a5\ub825\uc774 \uc788\uc2b5\ub2c8\ub2e4: <code>\uc8fc\ubb38 \ucd1d\uc561<\/code> \ub610\ud55c \uc708\ub3c4\uc6b0 \ud544\ud130\ub97c \ud1b5\uacfc\ud558\ub294 \ud589\uc744 \uacb0\uc815\ud558\ubbc0\ub85c \uacc4\uc0b0 \ubc29\uc2dd\uc774 \ubcc0\uacbd\ub418\uba74 \ud544\ud130\uc5d0 \uc804\ud600 \uc601\ud5a5\uc744 \ubc1b\uc9c0 \uc54a\ub294 \uc5f4\uc758 \ucd9c\ub825\uc5d0\ub3c4 \uc601\ud5a5\uc744 \ubbf8\uce69\ub2c8\ub2e4. SQLFlow\ub294 \uc9c1\uc811 \ubc0f \uac04\uc811 \uacc4\ubcf4\ub97c \uc11c\ub85c \ub2e4\ub978, \ubcc4\ub3c4\ub85c \uc804\ud658 \uac00\ub2a5\ud55c \uad00\uacc4 \uc720\ud615\uc73c\ub85c \uae30\ub85d\ud569\ub2c8\ub2e4. Snowflake\uc5d0 \ub300\ud55c \uc601\ud5a5 \ubd84\uc11d\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. <code>\uc790\uaca9<\/code>, <code>\uc5b4\ub514<\/code>\ucc38\uc5ec \uc870\uac74 \ubc0f <code>\uadf8\ub8f9\ud654 \uae30\uc900<\/code> \ud0a4\uc5d0\ub294 \uc2e4\uc81c \ube44\uc988\ub2c8\uc2a4 \ub85c\uc9c1\uc774 \ub2f4\uaca8 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub294 \uc815\ud655\ud55c \ud3ed\ubc1c \ubc18\uacbd\uacfc \uc548\uc2ec\ud560 \uc218 \uc788\ub294 \uacfc\uc18c\ud3c9\uac00 \uc0ac\uc774\uc758 \ucc28\uc774\uc640 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Snowflake\uc758 dbt<\/h2>\n\n\n\n<p>Snowflake \ubcc0\ud658\uc774 dbt\ub97c \ud1b5\ud574 \uc2e4\ud589\ub418\ub294 \uacbd\uc6b0 SQLFlow\ub294 \ub2e4\uc74c\uc744 \uac00\uc838\uc635\ub2c8\ub2e4. <strong>dbt \ub9e4\ub2c8\ud398\uc2a4\ud2b8<\/strong> SQLFlow\ub294 dbt \ubb38\uc11c\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 \ubaa8\ub378 \uac04 \uadf8\ub798\ud504\ubcf4\ub2e4 \ub354 \uc2ec\uce35\uc801\uc778 \uc5f4 \uc218\uc900\uc758 \ubaa8\ub378 \uacc4\ubcf4\ub97c \uc9c1\uc811 \uc0dd\uc131\ud569\ub2c8\ub2e4. \ub610\ud55c SQLFlow\ub294 \uc6e8\uc5b4\ud558\uc6b0\uc2a4 \uce21 \ub370\uc774\ud130(DDL, \ubdf0, \ucffc\ub9ac \uae30\ub85d)\ub3c4 \uc218\uc9d1\ud558\ubbc0\ub85c dbt \ud504\ub85c\uc81d\ud2b8\uc5d0\uc11c \uc120\uc5b8\ud55c \ub0b4\uc6a9\uacfc Snowflake \uacc4\uc815\uc5d0\uc11c \uc2e4\uc81c\ub85c \uc2e4\ud589\ub418\ub294 \ub0b4\uc6a9\uc744 \ub300\uc870\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ub204\uad70\uac00\uac00 dbt\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc2e4\ud589\ud55c \uc784\uc2dc CTAS \ucffc\ub9ac\ub3c4 \ubaa8\ub378\uacfc \ud568\uaed8 \ub3d9\uc77c\ud55c \uadf8\ub798\ud504\uc5d0 \ud45c\uc2dc\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Snowflake \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uc5bb\ub294 \ubc29\ubc95: \uc138 \uac00\uc9c0 \uacbd\ub85c<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>\uae38<\/th><th>\uc785\ub825<\/th><th>~\uc5d0 \uac00\uc7a5 \uc801\ud569\ud568<\/th><\/tr><\/thead><tbody>\n<tr><td><a href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=gudusoft&amp;utm_medium=website&amp;utm_campaign=snowflake-data-lineage\">SQLFlow \ud074\ub77c\uc6b0\ub4dc<\/a><\/td><td>SQL \ubd99\uc5ec\ub123\uae30, \ud30c\uc77c \uc5c5\ub85c\ub4dc, \ube0c\ub77c\uc6b0\uc800\uc5d0\uc11c \uc18c\uc2a4 \uc5f0\uacb0<\/td><td>\uc624\ub298 \ud55c\ubc88 \uc0ac\uc6a9\ud574 \ubcfc\uac8c\uc694. \uac1c\ubcc4 \ubb38\uc758 \ubc0f \ud504\ub85c\uc81d\ud2b8 \ucc98\ub9ac\uac00 \uac00\ub2a5\ud569\ub2c8\ub2e4. \ubb34\ub8cc \ubc84\uc804, \ud504\ub9ac\ubbf8\uc5c4 \ubc84\uc804\uc740 \uc6d4 $49.99\ub2ec\ub7ec\uc785\ub2c8\ub2e4.<\/td><\/tr>\n<tr><td><a href=\"https:\/\/www.gudusoft.com\/ko\/sqlflow-on-premise-%eb%b2%84%ec%a0%84\/\">\uc628\ud504\ub808\ubbf8\uc2a4 SQLFlow<\/a><\/td><td>\ucffc\ub9ac \uae30\ub85d, DDL, dbt \ub9e4\ub2c8\ud398\uc2a4\ud2b8 \ub4f1 \ubaa8\ub4e0 \uc815\ubcf4\uac00 \ub124\ud2b8\uc6cc\ud06c \ub0b4\uc5d0 \uc788\uc2b5\ub2c8\ub2e4.<\/td><td>SQL \ud14d\uc2a4\ud2b8\uac00 \uc778\ud504\ub77c \uc678\ubd80\ub85c \uc720\ucd9c\ub418\uc5b4\uc11c\ub294 \uc548 \ub418\ub294 \uaddc\uc81c \ud658\uacbd. Docker\/Kubernetes; \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc720\ud615\ubcc4 \uc6d4 $500 \ub610\ub294 \uc77c\ud68c\uc131 $4,800.<\/td><\/tr>\n<tr><td>REST API \/ \uc790\ubc14 \ub77c\uc774\ube0c\ub7ec\ub9ac \/ \uc790\ubc14\uc2a4\ud06c\ub9bd\ud2b8 \uc704\uc82f<\/td><td>\ud504\ub85c\uadf8\ub7a8 \ubd84\uc11d \ubc0f \uc784\ubca0\ub514\ub4dc \ub2e4\uc774\uc5b4\uadf8\ub7a8<\/td><td>\ud50c\ub7ab\ud3fc\uc774\ub098 \uce74\ud0c8\ub85c\uadf8\uc5d0 \uacc4\ubcf4 \uae30\ub2a5\uc744 \uad6c\ucd95\ud558\uc138\uc694.<\/td><\/tr>\n<\/tbody><\/table><\/figure>\n\n\n\n<p>SQLFlow\ub294 \uc5d4\ud130\ud504\ub77c\uc774\uc988 \uaddc\ubaa8\uc5d0\uc11c 100\uac1c \uc774\uc0c1\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \ubc31\ub9cc \uac1c \uc774\uc0c1\uc758 \uc5f4\uc744 \ud3ec\ud568\ud558\ub294 \ud658\uacbd\uc744 \uc99d\ubd84 \uc2a4\uce94 \ubc0f \uc601\uad6c\uc801\uc778 \ub370\uc774\ud130 \uacc4\ubcf4 \uc800\uc7a5\uc18c\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc77c\uad04 \uc2a4\uce94\ud558\uace0 \uacb0\uacfc\ub97c \ub0b4\ubcf4\ub0c5\ub2c8\ub2e4. <strong>DataHub, Microsoft Purview \ubc0f OpenMetadata<\/strong> \u2014 \uc774\ub97c \ud1b5\ud574 Snowflake\uc758 \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uae30\uc874\uc5d0 \uc6b4\uc601 \uc911\uc778 \uce74\ud0c8\ub85c\uadf8 \ud50c\ub7ab\ud3fc\uc73c\ub85c \ud1b5\ud569\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uce74\ud0c8\ub85c\uadf8 \ud50c\ub7ab\ud3fc\uc740 \uc804\uccb4 \uc2a4\ud0dd\uc5d0 \uac78\uccd0 \uc778\ubca4\ud1a0\ub9ac, \uc18c\uc720\uad8c \ubc0f \uac80\uc0c9 \uae30\ub2a5\uc744 \uc81c\uacf5\ud558\uba70, \ubcf5\uc7a1\ud55c SQL \ucffc\ub9ac\ub97c \uc815\ud655\ud55c \uc5f4 \uc218\uc900\uc758 \uc815\ubcf4\ub85c \ud30c\uc2f1\ud558\ub294 \ub370\uc5d0\ub294 \ud2b9\uc218 \uc5d4\uc9c4\uc744 \ud65c\uc6a9\ud558\uba74 \ub354\uc6b1 \ud6a8\uacfc\uc801\uc785\ub2c8\ub2e4. SQLFlow\ub294 \uc5c4\uaca9\ud55c \uac1c\uc778\uc815\ubcf4 \ubcf4\ud638 \uc815\ucc45\uc744 \uc900\uc218\ud558\uba70, SQL \ucf54\ub4dc\uc640 \uc2a4\ud0a4\ub9c8 \uba54\ud0c0\ub370\uc774\ud130\uc5d0 \ub300\ud55c \uc815\uc801 \ubd84\uc11d\ub9cc \uc218\ud589\ud558\uace0 Snowflake \ud14c\uc774\ube14\uc758 \ud589\uc740 \uc808\ub300 \uc77d\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc2a4\ub178\uc6b0\ud50c\ub808\uc774\ud06c\ub97c \ub118\uc5b4\uc11c: 39\uac1c \ubc29\uc5b8\uc5d0 \uac78\uce5c \ud558\ub098\uc758 \uacc4\ubcf4 \uadf8\ub798\ud504<\/h2>\n\n\n\n<p>Snowflake \uacc4\uc815\uc774 \ub2e8\ub3c5\uc73c\ub85c \uc6b4\uc601\ub418\ub294 \uacbd\uc6b0\ub294 \ub4dc\ubb45\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc73c\ub85c \uae30\uc874 Oracle \ub610\ub294 SQL Server \uc2dc\uc2a4\ud15c\uc774 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc5d0 \ub370\uc774\ud130\ub97c \uc81c\uacf5\ud558\uace0, Spark \ub610\ub294 Databricks \uc791\uc5c5\uc774 \uadf8 \uc606\uc5d0 \uc788\uc73c\uba70, \uadf8 \uc704\uc5d0 BI \ub808\uc774\uc5b4 SQL\uc774 \uc788\ub294 \ud658\uacbd\uc774 \ub9ce\uc2b5\ub2c8\ub2e4. SQLFlow\ub294 39\uac1c\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubc0f \ucffc\ub9ac \uc5d4\uc9c4\uc5d0 \ub300\ud55c \ubc29\uc5b8\ubcc4 \ud30c\uc11c\ub97c \uc81c\uacf5\ud558\ubbc0\ub85c Snowflake \ucffc\ub9ac \uae30\ub85d\uc744 \uc77d\ub294 \ub370 \uc0ac\uc6a9\ub418\ub294 \ub3d9\uc77c\ud55c \uc5d4\uc9c4\uc774 \ub2e4\ub978 \uc791\uc5c5\ub3c4 \ucc98\ub9ac\ud569\ub2c8\ub2e4. <a href=\"https:\/\/www.gudusoft.com\/ko\/%eb%b9%85%ec%bf%bc%eb%a6%ac-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4\/\">BigQuery \ub370\uc774\ud130 \uacc4\ubcf4<\/a> \uadf8\ub9ac\uace0 <a href=\"https:\/\/www.gudusoft.com\/ko\/%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b8%8c%eb%a6%ad%ec%8a%a4-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4\/\">Databricks\uc640 Spark SQL \uacc4\ubcf4<\/a>\ub610\ud55c Oracle PL\/SQL \ubc0f T-SQL\uacfc \uac19\uc740 \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800 \uc911\uc2ec\uc758 \uc18c\uc2a4(\ud504\ub85c\uc2dc\uc800 \ub0b4 \ub3d9\uc801 SQL \ud3ec\ud568)\ub3c4 \uc9c0\uc6d0\ud569\ub2c8\ub2e4. \uc774\ub294 \ud2b9\ud788 Snowflake\ub85c \ub9c8\uc774\uadf8\ub808\uc774\uc158\ud560 \ub54c \uc911\uc694\ud55c\ub370, \ub808\uac70\uc2dc \uc2dc\uc2a4\ud15c\uc758 \uc885\uc18d\uc131 \uadf8\ub798\ud504\ub97c \ub9c8\uc774\uadf8\ub808\uc774\uc158 \uc804\uc5d0 \uc815\ud655\ud558\uac8c \ub9e4\ud551\ud574\uc57c \ud558\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. \uc5d4\uc9c4 \uc791\ub3d9 \ubc29\uc2dd\uc5d0 \ub300\ud55c \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \ub2e4\uc74c\uc744 \ucc38\uc870\ud558\uc2ed\uc2dc\uc624. <a href=\"https:\/\/www.gudusoft.com\/ko\/sql-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4-%eb%8f%84%ea%b5%ac\/\">SQL \ub370\uc774\ud130 \uacc4\ubcf4 \ub3c4\uad6c \uac1c\uc694<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc790\uc8fc \ubb3b\ub294 \uc9c8\ubb38<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Snowflake\uc758 ACCOUNT_USAGE \ubdf0\ub9cc\uc73c\ub85c \uceec\ub7fc \uc218\uc900\uc758 \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uc5bb\uc744 \uc218 \uc788\ub098\uc694?<\/h3>\n\n\n<p>\uc544\ub2c8\uc694. \uacc4\uc815 \uc0ac\uc6a9\ub7c9 \uc6d0\uaca9 \uce21\uc815\uc740 \ud14c\uc774\ube14 \uc218\uc900\uc758 \uc561\uc138\uc2a4 \uae30\ub85d, \uc989 \ucffc\ub9ac\uac00 \uc5b4\ub5a4 \uac1d\uccb4\ub97c \uc77d\uace0 \uc37c\ub294\uc9c0\uc5d0 \ub300\ud55c \uc815\ubcf4\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc5f4 \uc218\uc900\uc758 \ubcc0\ud658 \ub0b4\uc5ed(\uc5b4\ub5a4 \uc18c\uc2a4 \uc5f4\uc774 \uc5b4\ub5a4 \ud568\uc218\uc640 \ud544\ud130\ub97c \uac70\uccd0 \uc5b4\ub5a4 \ucd9c\ub825 \uc5f4\ub85c \uc804\ub2ec\ub418\ub294\uc9c0)\uc744 \ud655\uc778\ud558\ub824\uba74 SQL \ubb38 \uc790\uccb4\uc758 SQL \ud14d\uc2a4\ud2b8\ub97c \uad6c\ubb38 \ubd84\uc11d\ud574\uc57c \ud558\ub294\ub370, SQLFlow\uac00 \ubc14\ub85c \uc774 \uc791\uc5c5\uc744 \uc218\ud589\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\ub294 Snowflake \uacc4\uc815 \uc815\ubcf4\ub97c \uc5b4\ub5bb\uac8c \uc218\uc9d1\ud558\ub098\uc694?<\/h3>\n\n\n<p>\uc5ec\ub7ec \uac00\uc9c0 \ubc29\ubc95\uc774 \uc788\uc2b5\ub2c8\ub2e4. Snowflake \ucffc\ub9ac \uae30\ub85d\uc744 \uae30\ubcf8 \uc785\ub825\uc73c\ub85c \uc0ac\uc6a9\ud558\uac70\ub098, JDBC\ub97c \ud1b5\ud574 \uc2e4\uc2dc\uac04 \uc2a4\ud0a4\ub9c8 \uba54\ud0c0\ub370\uc774\ud130\ub97c \uc804\uc1a1\ud558\uac70\ub098, DDL \ubc0f \ubdf0 \uc815\uc758\ub97c \uc5c5\ub85c\ub4dc\ud558\uac70\ub098, SQL \ubb38\uc744 \ubd99\uc5ec\ub123\uac70\ub098, dbt \ub9e4\ub2c8\ud398\uc2a4\ud2b8 \ud30c\uc77c\uc744 \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95 \ub4f1\uc774 \uc788\uc2b5\ub2c8\ub2e4. \ucffc\ub9ac \uae30\ub85d\uacfc DDL\uc744 \ud568\uaed8 \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \uac00\uc7a5 \uac15\ub825\ud55c \uc870\ud569\uc785\ub2c8\ub2e4. \uc2e4\uc81c\ub85c \uc2e4\ud589\ub41c \ubb38\uc7a5\uc744 \uae30\ubc18\uc73c\ub85c \uad6c\ucd95\ub41c \uacc4\ubcf4\uc640 \uc2a4\ud0c0 \ud655\uc7a5 \ubc0f \ubdf0 \ud574\uc11d\uc744 \uc704\ud55c \uc804\uccb4 \uc2a4\ud0a4\ub9c8 \ucee8\ud14d\uc2a4\ud2b8\ub97c \uc81c\uacf5\ud558\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\ub294 FLATTEN \ubc0f QUALIFY\uc640 \uac19\uc740 Snowflake \uace0\uc720 \uad6c\ubb38\uc744 \uc774\ud574\ud569\ub2c8\uae4c?<\/h3>\n\n\n<p>\ub124. SQLFlow\ub294 \uc77c\ubc18\uc801\uc778 ANSI \ud30c\uc11c\uac00 \uc544\ub2cc Snowflake \uc804\uc6a9 \ubb38\ubc95\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4. <code>\uce21\uba74\uc73c\ub85c \ud3c9\ud3c9\ud558\uac8c<\/code>, <code>\uc790\uaca9<\/code>VARIANT \uacbd\ub85c \ud45c\ud604\uc2dd\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. <code>\uac12:sku::\ubb38\uc790\uc5f4<\/code>, \uadf8\ub9ac\uace0 <code>\ud14c\uc774\ube14\uc744 SELECT \ud615\uc2dd\uc73c\ub85c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/code> \uc5f4 \uc218\uc900\uc5d0\uc11c \uad6c\ubb38 \ubd84\uc11d \ubc0f \ucd94\uc801\uc774 \uc218\ud589\ub418\uba70 \ud544\ud130 \uc808\uc740 \uac04\uc811 \uacc4\ubcf4\ub85c \ucea1\ucc98\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\ub294 Snowflake \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130\ub97c \uc77d\uc744 \uc218 \uc788\ub098\uc694?<\/h3>\n\n\n<p>\uc544\ub2c8\uc694. SQLFlow\ub294 SQL \ucf54\ub4dc\uc5d0 \ub300\ud55c \uc815\uc801 \ubd84\uc11d\uc744 \uc218\ud589\ud558\uace0 \uc120\ud0dd\uc801\uc73c\ub85c \uc2a4\ud0a4\ub9c8 \uba54\ud0c0\ub370\uc774\ud130(\ud14c\uc774\ube14 \ubc0f \uc5f4 \uc815\uc758)\ub97c \uc77d\uc2b5\ub2c8\ub2e4. \ud14c\uc774\ube14 \ud589\uc740 \uc808\ub300 \uc77d\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uc628\ud504\ub808\ubbf8\uc2a4 \uc5d0\ub514\uc158\uc758 \uacbd\uc6b0 SQL \ud14d\uc2a4\ud2b8\uc870\ucc28 \ub124\ud2b8\uc6cc\ud06c \ub0b4\uc5d0 \uc720\uc9c0\ub418\ubbc0\ub85c \ucffc\ub9ac \uae30\ub85d\uc5d0 \ubbfc\uac10\ud55c \ub9ac\ud130\ub7f4\uc774 \ud3ec\ud568\ub41c \uacbd\uc6b0 \ud2b9\ud788 \uc911\uc694\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Snowflake \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \ub0b4 \ub370\uc774\ud130 \uce74\ud0c8\ub85c\uadf8\ub85c \ub0b4\ubcf4\ub0bc \uc218 \uc788\ub098\uc694?<\/h3>\n\n\n<p>\uc608. \uc5d4\ud130\ud504\ub77c\uc774\uc988 \ubc30\ud3ec\uc5d0\ub294 DataHub, Microsoft Purview \ubc0f OpenMetadata\uc6a9 \ub0b4\ubcf4\ub0b4\uae30 \uc5b4\ub311\ud130\uc640 JSON, CSV \ubc0f PNG \ub0b4\ubcf4\ub0b4\uae30, \uadf8\ub9ac\uace0 \uc0ac\uc6a9\uc790 \uc9c0\uc815 \ud1b5\ud569\uc744 \uc704\ud55c REST API\uac00 \ud3ec\ud568\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\ub97c \uc0ac\uc6a9\ud55c Snowflake \uacc4\ubcf4 \ucd94\uc801 \ube44\uc6a9\uc740 \uc5bc\ub9c8\uc778\uac00\uc694?<\/h3>\n\n\n<p>SQLFlow Cloud\ub294 \ubb34\ub8cc\ub85c \uc2dc\uc791\ud558\uba70, \ud504\ub9ac\ubbf8\uc5c4 \ubc84\uc804\uc740 \uc6d4 $49.99\uc785\ub2c8\ub2e4. SQLFlow On-Premise\ub294 \uc6d4 $500 \ub610\ub294 \uc120\ud0dd\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc720\ud615(Snowflake\ub294 \ud558\ub098\uc758 \uc720\ud615\uc73c\ub85c \uac04\uc8fc)\ub2f9 \uc77c\ud68c\uc131 $4,800\uc774\uba70, \ub450 \ub300\uc758 \uc11c\ubc84\uc5d0 \uc124\uce58\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \ub2e4\uc74c\uc744 \ucc38\uc870\ud558\uc2ed\uc2dc\uc624. <a href=\"https:\/\/www.gudusoft.com\/ko\/%ea%b0%80%ea%b2%a9\/\">\uac00\uaca9<\/a> \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \ub2e4\uc74c\uc744 \ucc38\uc870\ud558\uc138\uc694.<\/p>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained\" style=\"background-color:#60d5f6;padding-top:32px;padding-bottom:32px\"><div class=\"wp-block-group__inner-container\">\n\n<h2 class=\"wp-block-heading\">\uc624\ub298 \ubc14\ub85c \ub2f9\uc2e0\uc758 \uc2a4\ub178\uc6b0\ud50c\ub808\uc774\ud06c \uac00\uacc4\ub3c4\ub97c \uadf8\ub824\ubcf4\uc138\uc694.<\/h2>\n\n\n<p>Snowflake \ucffc\ub9ac\ub97c \ubb34\ub8cc \uc2dc\uac01\ud654 \ub3c4\uad6c\uc5d0 \ubd99\uc5ec\ub123\uac70\ub098, \ucffc\ub9ac \uae30\ub85d \ubc0f \uc804\uccb4 \uc790\uc0b0\uc5d0 \ub300\ud55c \ubd84\uc11d \uc11c\ube44\uc2a4\ub97c \ubb38\uc758\ud574 \uc8fc\uc138\uc694.<\/p>\n\n\n<div class=\"wp-block-buttons is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=gudusoft&amp;utm_medium=website&amp;utm_campaign=snowflake-data-lineage\" target=\"_blank\" rel=\"noreferrer noopener\">SQLFlow\ub97c \ubb34\ub8cc\ub85c \uc0ac\uc6a9\ud574 \ubcf4\uc138\uc694.<\/a><\/div>\n<\/div>\n\n\n<div class=\"wp-block-buttons is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/www.gudusoft.com\/ko\/%ec%97%b0%eb%9d%bd%ed%95%98%eb%8b%a4\/\">\uae30\uc5c5\uc6a9 \ub370\ubaa8\ub97c \uc694\uccad\ud558\uc138\uc694<\/a><\/div>\n<\/div>\n\n<\/div><\/div>\n\n\n\n<script type=\"application\/ld+json\">{\n    \"@context\": \"https:\\\/\\\/schema.org\",\n    \"@graph\": [\n        {\n            \"@type\": \"SoftwareApplication\",\n            \"name\": \"Gudu SQLFlow\",\n            \"applicationCategory\": \"DeveloperApplication\",\n            \"applicationSubCategory\": \"SQL Data Lineage Tool\",\n            \"operatingSystem\": \"Web, Linux, Windows, macOS\",\n            \"url\": \"https:\\\/\\\/www.gudusoft.com\\\/snowflake-data-lineage\\\/\",\n            \"description\": \"Automated Snowflake data lineage: SQLFlow ingests Snowflake query history, DDL, views, and dbt manifests and produces interactive column-level lineage diagrams, including FLATTEN, QUALIFY, and indirect lineage.\",\n            \"featureList\": \"Snowflake query history ingestion, column-level lineage, indirect\\\/impact lineage, dbt manifest support, JDBC metadata ingestion, REST API, DataHub\\\/Purview\\\/OpenMetadata export, AI lineage query\",\n            \"softwareVersion\": \"8.2.3\",\n            \"offers\": [\n                {\n                    \"@type\": \"Offer\",\n                    \"name\": \"SQLFlow Cloud Free\",\n                    \"price\": \"0\",\n                    \"priceCurrency\": \"USD\"\n                },\n                {\n                    \"@type\": \"Offer\",\n                    \"name\": \"SQLFlow Cloud Premium\",\n                    \"price\": \"49.99\",\n                    \"priceCurrency\": \"USD\",\n                    \"priceSpecification\": {\n                        \"@type\": \"UnitPriceSpecification\",\n                        \"price\": \"49.99\",\n                        \"priceCurrency\": \"USD\",\n                        \"billingIncrement\": 1,\n                        \"unitText\": \"MONTH\"\n                    }\n                },\n                {\n                    \"@type\": \"Offer\",\n                    \"name\": \"SQLFlow On-Premise\",\n                    \"price\": \"4800\",\n                    \"priceCurrency\": \"USD\"\n                }\n            ],\n            \"publisher\": {\n                \"@type\": \"Organization\",\n                \"name\": \"Gudu Software\",\n                \"url\": \"https:\\\/\\\/www.gudusoft.com\\\/\"\n            }\n        },\n        {\n            \"@type\": \"FAQPage\",\n            \"mainEntity\": [\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Can I get column-level lineage from Snowflake's ACCOUNT_USAGE views alone?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"No. Account-usage telemetry gives you table-level access history. Column-level transform lineage requires parsing the SQL text of the statements themselves, which is what SQLFlow does.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"How does SQLFlow ingest my Snowflake account?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Snowflake query history as a native input, live schema metadata over JDBC, uploaded DDL and view definitions, pasted SQL, and dbt manifest files. Query history plus DDL gives lineage built from statements that actually ran, with full schema context.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Does SQLFlow understand Snowflake-specific syntax like FLATTEN and QUALIFY?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes. SQLFlow uses a dedicated Snowflake grammar, so LATERAL FLATTEN, QUALIFY, VARIANT path expressions, and CREATE TABLE AS SELECT are parsed and traced at column level, with filter clauses captured as indirect lineage.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Does SQLFlow read the data in my Snowflake tables?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"No. SQLFlow performs static analysis of SQL code and optionally reads schema metadata. It never reads table rows. With the On-Premise edition, even your SQL text stays inside your network.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Can I export Snowflake lineage to my data catalog?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes. Enterprise deployments include export adapters for DataHub, Microsoft Purview, and OpenMetadata, plus JSON, CSV, and PNG exports and a REST API for custom integrations.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"What does Snowflake lineage with SQLFlow cost?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"SQLFlow Cloud starts free; premium is $49.99\\\/month. SQLFlow On-Premise is $500\\\/month or $4,800 one-time per selected database type, installable on two servers.\"\n                    }\n                }\n            ]\n        }\n    ]\n}<\/script>","protected":false},"excerpt":{"rendered":"<p>Snowflake data lineage is the column-level map of how data moves through your Snowflake account: which source tables and columns feed each target table, view, or dashboard, and which transformations \u2014 joins, FLATTEN expansions, window functions, filters \u2014 happen along the way. Snowflake&#8217;s ACCOUNT_USAGE views tell you which objects were accessed, but they stop at table-level access history; to know how one column was computed from another, you have to parse the SQL itself. Gudu SQLFlow does exactly that: it ingests your Snowflake query history, DDL, and views, parses every statement with a Snowflake-specific grammar, and produces an interactive column-level\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\/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":30,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages\/2906\/revisions"}],"predecessor-version":[{"id":6749,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages\/2906\/revisions\/6749"}],"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}]}}