{"id":6750,"date":"2026-07-12T02:06:00","date_gmt":"2026-07-12T10:06:00","guid":{"rendered":"https:\/\/www.gudusoft.com\/bigquery-data-lineage\/"},"modified":"2026-07-12T02:06:00","modified_gmt":"2026-07-12T10:06:00","slug":"bigquery-data-lineage","status":"publish","type":"page","link":"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\/","title":{"rendered":"BigQuery \ub370\uc774\ud130 \uacc4\ubcf4: Google BigQuery SQL\uc758 \uc5f4 \uc218\uc900 \uacc4\ubcf4"},"content":{"rendered":"<p><strong>BigQuery \ub370\uc774\ud130 \uacc4\ubcf4<\/strong> \uc774\ub294 BigQuery \ud504\ub85c\uc81d\ud2b8\uc5d0\uc11c \ub370\uc774\ud130\uac00 \uc5b4\ub5bb\uac8c \uc774\ub3d9\ud558\ub294\uc9c0 \ubcf4\uc5ec\uc8fc\ub294 \uc9c0\ub3c4\uc785\ub2c8\ub2e4. \uc5b4\ub5a4 \uc6d0\ubcf8 \ud14c\uc774\ube14\uacfc \uc5f4\uc774 \uac01 \ud30c\uc0dd \ud14c\uc774\ube14, \ubdf0 \ubc0f \uc608\uc57d\ub41c \ucffc\ub9ac\uc5d0 \ub370\uc774\ud130\ub97c \uc81c\uacf5\ud558\ub294\uc9c0, \uadf8\ub9ac\uace0 \uc5b4\ub5a4 \ud45c\ud604\uc2dd\uc774 \ub370\uc774\ud130\ub97c \ubcc0\ud658\ud558\ub294\uc9c0\ub97c \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. Google Dataplex\ub294 \ud14c\uc774\ube14 \uc218\uc900\uc5d0\uc11c BigQuery \uc791\uc5c5\uc758 \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uc790\ub3d9\uc73c\ub85c \ucea1\ucc98\ud569\ub2c8\ub2e4. \uc5b4\ub5a4 \ub370\uc774\ud130\uac00 \uc5b4\ub5a4 \uacbd\ub85c\ub85c \uc774\ub3d9\ud588\ub294\uc9c0 \ud655\uc778\ud558\ub824\uba74 \ub2e4\uc74c\uc744 \ucc38\uc870\ud558\uc138\uc694. <em>\uceec\ub7fc<\/em> \uc5b4\ub5a4 \ud568\uc218\uc640 \uc870\uc778\uc744 \ud1b5\ud574 \uc5b4\ub5a4 \uc815\ubcf4\ub97c \uc785\ub825\ud574\uc57c \ud558\ub294\uc9c0, \uadf8\ub9ac\uace0 SQL \uc790\uccb4\ub97c \uc5b4\ub5bb\uac8c \ud30c\uc2f1\ud574\uc57c \ud558\ub294\uc9c0\ub97c \uc54c\uc544\uc57c \ud569\ub2c8\ub2e4. <strong>Gudu SQLFlow<\/strong> \uc774 \uae30\ub2a5\uc740 \uc911\ucca9\ub41c \uad6c\ubb38\uc744 \ud574\uacb0\ud558\ub294 \uc804\uc6a9 BigQuery \ubc29\uc5b8 \ud30c\uc11c\ub97c \ud1b5\ud574 \uc815\ud655\ud788 \uadf8 \uc5ed\ud560\uc744 \uc218\ud589\ud569\ub2c8\ub2e4. <code>\uad6c\uc870<\/code> \uc804\uc9c0, <code>\uc5b8\ub124\uc2a4\ud2b8<\/code>\ubcc4 \ud655\uc7a5 \ubc0f \uc5f4 \ub2e8\uc704\uc758 \uc138\ubd84\ud654\ub41c \ubdf0 \uccb4\uc778.<\/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>30\ucd08 \uc548\uc5d0 \uc2dc\ub3c4\ud574 \ubcf4\uc138\uc694:<\/strong> BigQuery \ucffc\ub9ac\ub97c \ubd99\uc5ec\ub123\uc73c\uc138\uc694. <a href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=gudusoft&amp;utm_medium=website&amp;utm_campaign=bigquery-data-lineage\" target=\"_blank\" rel=\"noreferrer noopener\">\ubb34\ub8cc SQLFlow \uacc4\ubcf4 \uc2dc\uac01\ud654 \ub3c4\uad6c<\/a>BigQuery \ubc29\uc5b8\uc744 \uc120\ud0dd\ud558\uba74 \ub300\ud654\ud615 \uc5f4 \uc218\uc900 \uacc4\ubcf4\ub3c4\ub97c \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud074\ub77c\uc6b0\ub4dc \uc5d0\ub514\uc158\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\">BigQuery \uacc4\ubcf4 \ucd94\uc801\uc774 \uc0dd\uac01\ubcf4\ub2e4 \uc5b4\ub824\uc6b4 \uc774\uc720<\/h2>\n\n\n\n<p>BigQuery\uc758 SQL\uc740 \uc77c\ubc18\uc801\uc778 ANSI SQL\uc774 \uc544\ub2d9\ub2c8\ub2e4. \ud2b9\ud788 \uc138 \uac00\uc9c0 \uae30\ub2a5 \ub54c\ubb38\uc5d0 \ub2e8\uc77c \ubb38\ubc95\uc5d0 \uc758\uc874\ud558\ub294 \ub370\uc774\ud130 \uacc4\ubcf4 \ub3c4\uad6c\uac00 \uc81c\ub300\ub85c \uc791\ub3d9\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<ul><li><strong>\uc911\ucca9\ub418\uace0 \ubc18\ubcf5\ub418\ub294 \uc5f4.<\/strong> BigQuery\uc758 \ub2e8\uc77c \uc5f4\uc740 \ub2e4\uc74c\uacfc \uac19\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <code>\uad6c\uc870<\/code> \ub2e4\ub978 \ud544\ub4dc\ub97c \ud3ec\ud568\ud558\uac70\ub098 <code>\uc815\ub82c<\/code> \uad6c\uc870\uccb4\uc758 \uacbd\uc6b0. \uc2e4\uc81c \uacc4\ubcf4\ub294 \ub0b4\ubd80\uae4c\uc9c0 \ub3c4\ub2ec\ud574\uc57c \ud569\ub2c8\ub2e4. <code>\uc8fc\ubb38.\uace0\uac1d.\uc774\uba54\uc77c<\/code> \ub294 \ub2e4\ub978 \uacc4\ubcf4 \ub178\ub4dc\uc785\ub2c8\ub2e4. <code>\uc8fc\ubb38.\uace0\uac1d.\uad6d\uac00<\/code>\ube44\ub85d \ub458 \ub2e4 \ubb3c\ub9ac\uc801\uc73c\ub85c \uac19\uc740 \uacf5\uac04\uc5d0 \uc0b4\uace0 \uc788\uc9c0\ub9cc \ub9d0\uc785\ub2c8\ub2e4.<\/li>\n<li><strong><code>\uc5b8\ub124\uc2a4\ud2b8<\/code>.<\/strong> \ubc18\ubcf5\ub418\ub294 \ud544\ub4dc\ub97c \ud3c9\uba74\ud654\ud558\uba74 \ud55c \ud589\uc774 \uc5ec\ub7ec \ud589\uc73c\ub85c \ubc14\ub00c\uace0 \ucffc\ub9ac \uc911\uac04\uc5d0 \ud30c\uc0dd \uad00\uacc4\uac00 \ub3c4\uc785\ub429\ub2c8\ub2e4. \uc774\ub97c \ubaa8\ub378\ub9c1\ud558\uc9c0 \uc54a\ub294 \ud30c\uc11c\ub294... <code>\uc5b8\ub124\uc2a4\ud2b8<\/code> \ud3c9\uba74\ud654\ub41c \ubcc4\uce6d\uacfc \ud574\ub2f9 \ubcc4\uce6d\uc774 \uc720\ub798\ub41c \ubc30\uc5f4 \ud544\ub4dc \uc0ac\uc774\uc758 \uc5f0\uacb0 \uace0\ub9ac\uac00 \uc0ac\ub77c\uc9d1\ub2c8\ub2e4.<\/li>\n<li><strong>\ubcc4\uc758 \ud33d\ucc3d.<\/strong> <code>\uc120\ud0dd\ud558\ub2e4 *<\/code> \ubdf0 \uccb4\uc778\uc744 \ud1b5\ud574 \ucc98\ub9ac\ud55c\ub2e4\ub294 \uac83\uc740 \ucd9c\ub825 \uc5f4\uc774 \ucffc\ub9ac \ud14d\uc2a4\ud2b8 \uc5b4\ub514\uc5d0\ub3c4 \uba85\uc2dc\ub418\uc5b4 \uc788\uc9c0 \uc54a\ub2e4\ub294 \uac83\uc744 \uc758\ubbf8\ud569\ub2c8\ub2e4. \ub530\ub77c\uc11c \uc774\ub97c \ud655\uc778\ud558\ub824\uba74 \ub208\uc55e\uc5d0 \uc788\ub294 \ub2e8\uc77c \ucffc\ub9ac\ubb38\ubfd0\ub9cc \uc544\ub2c8\ub77c \ud14c\uc774\ube14 \ubc0f \ubdf0 \uc815\uc758\ub3c4 \ud544\uc694\ud569\ub2c8\ub2e4.<\/li><\/ul>\n\n\n\n<p>SQLFlow\ub294 BigQuery \uc804\uc6a9 \ud30c\uc11c(\ub2e4\uc74c \uc911 \ud558\ub098)\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. <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\/\">39\uac1c\uc758 \ubc29\uc5b8\ubcc4 \uad6c\ubb38 \ubd84\uc11d\uae30<\/a> \uc81c\ud488 \uc790\uccb4\uc5d0 (\ub2e8\uc77c \uc77c\ubc18 \ubb38\ubc95\uc774 \uc544\ub2cc) \uc138 \uac00\uc9c0 \ubaa8\ub450\ub97c \ucc98\ub9ac\ud558\ub294 \uae30\ub2a5\uc774 \ud3ec\ud568\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. CTE, \uc11c\ube0c\ucffc\ub9ac, \ubdf0 \ubc0f \uc2a4\ud0c0 \ud655\uc7a5\uc744 \ud1b5\ud574 \ubaa8\ub4e0 \uc5f4 \ucc38\uc870\ub97c \ud574\uacb0\ud558\uace0 \uc911\ucca9 \uad6c\uc870\ub97c \ubaa8\ub378\ub9c1\ud569\ub2c8\ub2e4. <code>\uad6c\uc870<\/code> \ud544\ub4dc\ub97c \uc77c\uae09 \uacc4\ubcf4 \ub178\ub4dc\ub85c \uac04\uc8fc\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Dataplex\ub294 \ud14c\uc774\ube14 \uc218\uc900\uc758 \uc791\uc5c5 \uacc4\ubcf4\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. \uadf8 \ub2e4\uc74c\uc5d0\ub294 \ubb34\uc5c7\uc744 \ud574\uc57c \ud560\uae4c\uc694?<\/h2>\n\n\n\n<p>Dataplex(Google Cloud\uc758 \ub370\uc774\ud130 \uac70\ubc84\ub10c\uc2a4 \uacc4\uce35)\ub294 \uc2e4\uc81c\ub85c \ub9e4\uc6b0 \ub6f0\uc5b4\ub09c \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. BigQuery \uc791\uc5c5\uc774 \uc2e4\ud589\ub418\ub294 \ub3d9\uc548 \uc774\ub97c \uad00\ucc30\ud558\uace0 \uac01 \uc791\uc5c5\uc774 \uc5b4\ub5a4 \ud14c\uc774\ube14\uc744 \uc77d\uace0 \uc37c\ub294\uc9c0 \uae30\ub85d\ud569\ub2c8\ub2e4. \uc608\uc57d\ub41c \ucffc\ub9ac\uac00 \uc5b4\ub5a4 \ud14c\uc774\ube14\uc744 \ucc44\uc6b0\ub294\uc9c0 \uc54c\uace0 \uc2f6\ub2e4\uba74 Dataplex\ub97c \uc0ac\uc6a9\ud558\uba74 \ub429\ub2c8\ub2e4. <code>dw.\uc77c\uc77c\uc218\uc775<\/code> ~\uc5d0\uc11c <code>raw.orders<\/code>\ub370\uc774\ud130\ud50c\ub809\uc2a4\uc5d0\uc11c \uc774\ubbf8 \uc54c\ub824\ub4dc\ub838\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc2e4\ud589 \uc911\uc778 \uc791\uc5c5 \uad00\ucc30\ub85c\ub294 \ud14c\uc774\ube14 \uac04\uc758 \ubcc0\ud658 \ub85c\uc9c1, \uc989 \uc5b4\ub5a4 \uc18c\uc2a4 \uc5f4\uc774 \uc5b4\ub5a4 \ucd9c\ub825 \uc5f4\ub85c \uc804\ub2ec\ub418\ub294\uc9c0, \uc5b4\ub5a4 \ud45c\ud604\uc2dd, \ud544\ud130 \ubc0f \uc870\uc778\uc744 \uac70\uce58\ub294\uc9c0 \uc54c \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uc815\ubcf4\ub294 SQL \ud14d\uc2a4\ud2b8\uc5d0\ub9cc \uc874\uc7ac\ud558\ubbc0\ub85c \ucd94\ucd9c\ud558\ub824\uba74 SQL \uad6c\ubb38 \ubd84\uc11d\uc774 \ud544\uc694\ud569\ub2c8\ub2e4. \ub450 \uc811\uadfc \ubc29\uc2dd\uc740 \uc11c\ub85c \ub2e4\ub978 \uc9c8\ubb38\uc5d0 \ub300\ud55c \ub2f5\uc744 \uc81c\uc2dc\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>\uc9c8\ubb38<\/th><th>\ub370\uc774\ud130\ud50c\ub809\uc2a4 \uc791\uc5c5 \uacc4\ubcf4<\/th><th>SQLFlow\uc5d0\uc11c \ud30c\uc2f1\ud55c \uacc4\ubcf4<\/th><\/tr><\/thead><tbody>\n<tr><td>\uc774 \uc791\uc5c5\uc740 \uc5b4\ub5a4 \ud14c\uc774\ube14\uacfc \uad00\ub828\uc774 \uc788\ub098\uc694?<\/td><td>\uc608, \uc791\uc5c5 \uc2e4\ud589 \uc2dc \uc790\ub3d9\uc73c\ub85c \ubc1c\uc0dd\ud569\ub2c8\ub2e4.<\/td><td>\ub124, SQL\uc5d0\uc11c\uc694.<\/td><\/tr>\n<tr><td>\uc5b4\ub5a4 \uceec\ub7fc\uc5d0 \ub370\uc774\ud130\uac00 \uacf5\uae09\ub418\ub098\uc694? <code>\uc77c\uc77c \ub9e4\ucd9c \ucd1d\uc561<\/code>?<\/td><td>\uc544\ub2c8\uc694 - \ud14c\uc774\ube14 \uc138\ubd84\ud654<\/td><td>\uc608, \ucd9c\ub825 \uc5f4\ubcc4\ub85c \uadf8\ub807\uc2b5\ub2c8\ub2e4.<\/td><\/tr>\n<tr><td>\uac01 \ucd9c\ub825 \uc5f4\uc744 \uacc4\uc0b0\ud558\ub294 \ud45c\ud604\uc2dd\uc740 \ubb34\uc5c7\uc785\ub2c8\uae4c?<\/td><td>\uc544\ub2c8\uc694<\/td><td>\uc608: \ud568\uc218, \ud615\ubcc0\ud658, \uc9d1\ud569\uccb4<\/td><\/tr>\n<tr><td>\uc5b4\ub5a4 \uc5f4\uc774 \ud544\ud130\ub9c1 \ub610\ub294 \uc870\uc778(\uac04\uc811 \uacc4\ubcf4)\uc5d0\ub9cc \uc0ac\uc6a9\ub429\ub2c8\uae4c?<\/td><td>\uc544\ub2c8\uc694<\/td><td>\ub124, \ubcc4\ub3c4\uc758 \ud1a0\uae00 \uac00\ub2a5\ud55c \ub808\uc774\uc5b4\ub85c \uc81c\uacf5\ub429\ub2c8\ub2e4.<\/td><\/tr>\n<tr><td>\uc544\uc9c1 \uc2e4\ud589\ub418\uc9c0 \uc54a\uc740 SQL\uc5d0 \ub300\ud55c \ucf54\ub4dc \uacc4\ubcf4(\ucf54\ub4dc \uac80\ud1a0, \ub9c8\uc774\uadf8\ub808\uc774\uc158)<\/td><td>\uc544\ub2c8\uc694, \uc2e4\ud589\ub41c \uc791\uc5c5\uc774 \ud544\uc694\ud569\ub2c8\ub2e4.<\/td><td>\uc608, SQL \ud14d\uc2a4\ud2b8\uc5d0 \ub300\ud55c \uc815\uc801 \ubd84\uc11d\uc785\ub2c8\ub2e4.<\/td><\/tr>\n<\/tbody><\/table><\/figure>\n\n\n\n<p>\uc77c\ubc18\uc801\uc73c\ub85c \ud300\uc740 Dataplex\ub97c \uc0c1\uc2dc \uc791\uc5c5 \uc778\ubca4\ud1a0\ub9ac \uad00\ub9ac\uc5d0 \uc0ac\uc6a9\ud558\uace0, &quot;\uc774 \uc5f4\uc744 \ubcc0\uacbd\ud558\uba74 \uc5b4\ub5a4 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud558\ub294\uc9c0&quot; \ub610\ub294 &quot;\uc774 \uc22b\uc790\ub294 \uc815\ud655\ud788 \uc5b4\ub514\uc5d0\uc11c \ub098\uc628 \uac83\uc778\uc9c0&quot;\uc640 \uac19\uc740 \uc9c8\ubb38\uc5d0 \uc5f4 \uc815\ubc00\ub3c4\ub85c \ub2f5\ud574\uc57c \ud560 \ub54c\ub294 SQL \uad6c\ubb38 \ubd84\uc11d\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc608\uc2dc: CREATE TABLE AS SELECT with UNNEST<\/h2>\n\n\n\n<p>\ub2e4\uc74c\uc740 \uc77c\ubc18\uc801\uc778 BigQuery \ud328\ud134\uc785\ub2c8\ub2e4. \ubc18\ubcf5\ub418\ub294 \ub370\uc774\ud130\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc8fc\ubb38 \ud14c\uc774\ube14\uc5d0\uc11c \ub2e8\uc77c \uc218\uc775 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. <code>\ub77c\uc778 \ud56d\ubaa9<\/code> \uad6c\uc870.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE dw.order_line_revenue AS SELECT o.order_id, o.customer.email AS customer_email, li.product_id, li.qty * li.unit_price AS line_revenue FROM raw.orders AS o, UNNEST(o.line_items) AS li WHERE o.status = &#039;COMPLETE&#039;;<\/code><\/pre>\n\n\n\n<p>\uc774 \uac12\uc744 SQLFlow\uc5d0 \uc785\ub825\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \uc5f4 \uc218\uc900 \uacc4\ubcf4\uac00 \uc0dd\uc131\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<ul><li><code>\uc8fc\ubb38 \ub77c\uc778 \uc218\uc775.\uace0\uac1d \uc774\uba54\uc77c<\/code> \uc911\ucca9 \ud544\ub4dc\uc5d0\uc11c \uac00\uc838\uc628 \uac83\uc785\ub2c8\ub2e4. <code>raw.orders.customer.email<\/code> \u2014 \uad6c\uc870\uccb4 \uc804\uccb4\uac00 \uc544\ub2c8\ub77c \uad6c\uc870\uccb4\uc758 \ud2b9\uc815 \uba64\ubc84\uc785\ub2c8\ub2e4. <code>\uace0\uac1d<\/code> \uc5f4.<\/li>\n<li><code>\uc8fc\ubb38 \ub77c\uc778 \uc218\uc775.\ub77c\uc778 \uc218\uc775<\/code> ~\uc5d0\uc11c \uc720\ub798\ud569\ub2c8\ub2e4 <code>raw.orders.line_items.qty<\/code> \uadf8\ub9ac\uace0 <code>raw.orders.line_items.unit_price<\/code>\ub97c \ud1b5\ud574 <code>\uc5b8\ub124\uc2a4\ud2b8<\/code> \ubcc4\uba85 <code>\ub9ac<\/code> \uadf8\ub9ac\uace0 \uacf1\uc148\uc785\ub2c8\ub2e4. \ub450 \uc18c\uc2a4 \ud544\ub4dc \ubaa8\ub450 \ubc18\ubcf5\ub418\ub294 \uad6c\uc870\uccb4 \ub0b4\uc5d0 \uc788\uc73c\uba70, SQLFlow\ub294 \ud3c9\uba74\ud654 \uacfc\uc815\uc744 \ucd94\uc801\ud569\ub2c8\ub2e4.<\/li>\n<li><code>raw.orders.status<\/code> \ub2e4\uc74c\uacfc \uac19\uc774 \ub098\ud0c0\ub0a9\ub2c8\ub2e4 <strong>\uac04\uc811 \ud608\ud1b5<\/strong>: \ucd9c\ub825 \uacb0\uacfc\uc5d0\ub294 \uc804\ud600 \ub098\ud0c0\ub098\uc9c0 \uc54a\uc9c0\ub9cc, <code>\uc5b4\ub514<\/code> \ud544\ud130\ub294 \uacb0\uacfc\uc758 \ubaa8\ub4e0 \ud589\uc744 \uc870\uc815\ud558\ub294 \uae30\ub2a5\uc744 \ud569\ub2c8\ub2e4. SQLFlow\ub294 \uc9c1\uc811\uc801\uc778 \ub370\uc774\ud130 \ud750\ub984\uacfc \uac04\uc811\uc801\uc778 \uc601\ud5a5(WHERE, JOIN, GROUP BY \uc5f4)\uc744 \uc11c\ub85c \ub2e4\ub978 \uad00\uacc4 \uc720\ud615\uc73c\ub85c \ubaa8\ub378\ub9c1\ud558\uc5ec \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc5d0\uc11c \uac1c\ubcc4\uc801\uc73c\ub85c \uc804\ud658\ud560 \uc218 \uc788\ub3c4\ub85d \ud569\ub2c8\ub2e4. \ub300\ubd80\ubd84\uc758 \ub370\uc774\ud130 \uacc4\ubcf4 \ub3c4\uad6c\ub294 \uc774\ub7ec\ud55c \uad6c\ubd84\uc744 \uc804\ud600 \ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/li><\/ul>\n\n\n\n<p>\uac04\uc811 \uacc4\ubcf4\ub294 \uac89\uc73c\ub85c \ubcf4\uc774\ub294 \uac83\ubcf4\ub2e4 \ud6e8\uc52c \uc911\uc694\ud569\ub2c8\ub2e4. \ub204\uad70\uac00\uac00 \uc5f4\uac70\ud615 \uac12\uc744 \ubcc0\uacbd\ud558\uba74... <code>\uc0c1\ud0dc<\/code>\uc21c\uc804\ud788 \uc9c1\uacc4 \ud608\ud1b5 \ucd94\uc801 \ub3c4\uad6c\ub77c\uace0 \ud569\ub2c8\ub2e4. <code>\ub77c\uc778 \uc218\uc775<\/code> \uc601\ud5a5\uc744 \ubc1b\uc9c0 \uc54a\ub294\ub2e4\uace0\uc694? \uc544\ub2d9\ub2c8\ub2e4. \ubaa8\ub4e0 \ud558\uc704 \uc218\uc775 \uc218\uce58\uac00 \ubcc0\ud569\ub2c8\ub2e4. \uac04\uc811\uc801\uc778 \uc5f0\uad00\uc131\uc744 \uace0\ub824\ud558\uc9c0 \uc54a\uc740 \uc601\ud5a5 \ubd84\uc11d\uc740 \uc0ac\uac01\uc9c0\ub300\uac00 \uc788\ub294 \uc601\ud5a5 \ubd84\uc11d\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc608\uc57d\ub41c \ucffc\ub9ac \ubc0f \ubdf0 \uccb4\uc778 \ucd94\uc801<\/h2>\n\n\n\n<p>\ub300\ubd80\ubd84\uc758 BigQuery \ud658\uacbd\uc5d0\uc11c \uc911\uc694\ud55c \ub370\uc774\ud130 \uacc4\ubcf4\ub294 \ub2e8\uc77c \ucffc\ub9ac\ubb38\uc774 \uc544\ub2c8\ub77c \uc5ec\ub7ec \ub2e8\uacc4\uac00 \uc5f0\uacb0\ub41c \uc0ac\uc2ac\uacfc \uac19\uc2b5\ub2c8\ub2e4. \uc6d0\uc2dc \ud14c\uc774\ube14, \ubdf0 \uacc4\uce35, \ubcf4\uace0 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\ub294 \uc608\uc57d\ub41c \ucffc\ub9ac, \uadf8\ub9ac\uace0 \uadf8 \uc704\uc5d0 \ub610 \ub2e4\ub978 \ubdf0\uac00 \uc774\uc5b4\uc9c0\ub294 \uad6c\uc870\uc785\ub2c8\ub2e4. \uac1c\ubcc4 \ub9c1\ud06c\ub294 \uc27d\uac8c \ud30c\uc545\ud560 \uc218 \uc788\uc9c0\ub9cc, \uc18c\uc2a4 \uc5f4\uc5d0\uc11c \ub300\uc2dc\ubcf4\ub4dc \ud544\ub4dc\uae4c\uc9c0\uc758 \uc804\uccb4 \uacbd\ub85c\ub294 \uadf8\ub807\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>SQLFlow\ub294 \uc804\uccb4 \ub370\uc774\ud130 \uc138\ud2b8\ub97c \ud568\uaed8 \ubd84\uc11d\ud569\ub2c8\ub2e4. \ubdf0 DDL\uacfc \uc608\uc57d\ub41c \ucffc\ub9ac SQL(\ubd99\uc5ec\ub123\uae30, \ud30c\uc77c \uc5c5\ub85c\ub4dc, JDBC\ub97c \ud1b5\ud55c \uc2e4\uc2dc\uac04 \uba54\ud0c0\ub370\uc774\ud130, dbt \ub9e4\ub2c8\ud398\uc2a4\ud2b8 \ub610\ub294 Grabit \uba54\ud0c0\ub370\uc774\ud130 \ucd94\ucd9c)\uc744 \uc81c\uacf5\ud558\uba74 \ubdf0 \uac04 \ucc38\uc870\ub97c \ud574\uacb0\ud558\uace0 \uc804\uccb4 \uc5f0\uacb0\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4. <code>\uc120\ud0dd\ud558\ub2e4 *<\/code> \uac01 \uacc4\uce35\uc758 \uc2e4\uc81c \uc2a4\ud0a4\ub9c8\ub97c \uae30\uc900\uc73c\ub85c \ud655\uc7a5\ub418\uba70, \uacb0\uacfc \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc744 \ud1b5\ud574 \ucd9c\ub825 \uc5f4\uc744 \ud074\ub9ad\ud558\uc5ec \ubaa8\ub4e0 \uc911\uac04 \ubdf0\ub97c \uac70\uccd0 \uc6d0\uc2dc \ud14c\uc774\ube14\uc758 \uc18c\uc2a4 \uc5f4\uae4c\uc9c0 \uac70\uc2ac\ub7ec \uc62c\ub77c\uac08 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub0b4\ubcf4\ub0b4\uae30 \ud615\uc2dd\uc740 JSON, CSV, PNG \ub610\ub294 REST API\ub97c \ud1b5\ud55c \ud504\ub85c\uadf8\ub798\ubc0d \ubc29\uc2dd\uc774\uba70, \uc5d4\ud130\ud504\ub77c\uc774\uc988 \ud658\uacbd\uc5d0\uc11c\ub294 \ub370\uc774\ud130 \uacc4\ubcf4\ub97c DataHub, Microsoft Purview \ub610\ub294 OpenMetadata\ub85c \ud478\uc2dc\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uac15\uc81c\ub418\uc9c0 \uc54a\uc740 \uc81c\uc57d \uc870\uac74\uc758 ER \ub2e4\uc774\uc5b4\uadf8\ub7a8<\/h2>\n\n\n\n<p>BigQuery\ub294 \uae30\ubcf8 \ud0a4\uc640 \uc678\ub798 \ud0a4\ub9cc \uc9c0\uc6d0\ud569\ub2c8\ub2e4. <code>\uc2dc\ud589\ub418\uc9c0 \uc54a\uc74c<\/code> \uc81c\uc57d \uc870\uac74: \ucd5c\uc801\ud654 \ub3c4\uad6c\uc640 \ubb38\uc11c\ud654\ub97c \uc704\ud574 DDL\uc5d0 \uc120\uc5b8\ub418\uc9c0\ub9cc, \uc791\uc131 \uc2dc\uc810\uc5d0\ub294 \uac80\uc0ac\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uac15\uc81c\ub418\uc9c0 \uc54a\uae30 \ub54c\ubb38\uc5d0 \ub9ce\uc740 \ud300\uc5d0\uc11c \uc774\ub97c \uc4f8\ubaa8\uc5c6\ub294 \uba54\ud0c0\ub370\uc774\ud130\ub85c \uac04\uc8fc\ud569\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uadf8\ub807\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uc81c\uc57d \uc870\uac74\uc740 ER \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc5d0 \uaf2d \ud544\uc694\ud55c \uad00\uacc4 \uc120\uc5b8\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>SQLFlow\uc758 ER \ucd94\ub860\uc740 BigQuery\ub97c \uc774\ud574\ud569\ub2c8\ub2e4. <code>\uc2dc\ud589\ub418\uc9c0 \uc54a\uc74c<\/code> PK\/FK \uad00\uc6a9\uad6c: DDL\uc744 \uc2e4\ud589\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \uc81c\uc57d \uc870\uac74\uc73c\ub85c\ubd80\ud130 \uc5d4\ud2f0\ud2f0-\uad00\uacc4 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc744 \uadf8\ub824\uc90d\ub2c8\ub2e4. <code>\uae30\ubcf8 \ud0a4(order_id) \ucd94\uac00\ub294 \uac15\uc81c\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/code> \uadf8\ub9ac\uace0 \uc77c\uce58\ud558\ub294 <code>\uc678\uad6d \ud0a4 ... \ucc38\uc870 ... \uc801\uc6a9\ub418\uc9c0 \uc54a\uc74c<\/code> \uc120\uc5b8\ubb38\ub4e4\uc744 \ud1b5\ud574, \uae30\uc874\uc5d0 \ubcf4\uc720\ud558\uace0 \uc788\ub294 DDL\ub85c\ubd80\ud130 \ubc14\ub85c \uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc758 ER \ubaa8\ub378\uc744 \uc0dd\uc131\ud560 \uc218 \uc788\uc73c\uba70, \uc774 \ubaa8\ub378\uc5d0 \ud3ec\ud568\ub41c \uc2a4\ud0a4\ub9c8\ub4e4\uc758 \uad00\uacc4 \ubb38\uc11c\ub294 \ub2e4\ub978 \uacf3\uc5d0\ub294 \uc874\uc7ac\ud558\uc9c0 \uc54a\uc744 \uac00\ub2a5\uc131\uc774 \ub192\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\ud300\uc5d0\uc11c BigQuery \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uc0ac\uc6a9\ud558\ub294 \uc6a9\ub3c4\ub294 \ubb34\uc5c7\uc778\uac00\uc694?<\/h2>\n\n\n\n<ul><li><strong>\uc2a4\ud0a4\ub9c8 \ubcc0\uacbd \uc804 \uc601\ud5a5 \ubd84\uc11d:<\/strong> \uceec\ub7fc\uc774 \uc2e4\uc81c\ub85c \uc81c\uacf5\ud558\ub294 \ubaa8\ub4e0 \uc608\uc57d\ub41c \ucffc\ub9ac, \ubcf4\uae30 \ubc0f \ubcf4\uace0\uc11c\ub97c \ucc3e\uc2b5\ub2c8\ub2e4(\ub2e4\uc74c \uacbd\ub85c\ub97c \ud1b5\ud574\uc11c\ub3c4 \ud3ec\ud568). <code>\uc5b8\ub124\uc2a4\ud2b8<\/code> \uad6c\uc870\uccb4 \uc811\uadfc \uad8c\ud55c \u2014 \uc774\ub984\uc744 \ubc14\uafb8\uac70\ub098 \ub2e4\uc2dc \uc785\ub825\ud558\uae30 \uc804\uc5d0.<\/li>\n<li><strong>\uc798\ubabb\ub41c \uc22b\uc790 \ub514\ubc84\uae45:<\/strong> \ub300\uc2dc\ubcf4\ub4dc \uba54\ud2b8\ub9ad \ud558\ub098\uc5d0\uc11c \ubdf0 \uccb4\uc778\uc744 \ub530\ub77c \uc5ed\ubc29\ud5a5\uc73c\ub85c \uc774\ub3d9\ud558\uc5ec \ud574\ub2f9 \uba54\ud2b8\ub9ad\uc744 \uc0dd\uc131\ud55c \uc815\ud655\ud55c \uc18c\uc2a4 \ud544\ub4dc \ubc0f \ud45c\ud604\uc2dd\uc744 \ucc3e\uc2b5\ub2c8\ub2e4.<\/li>\n<li><strong>\uc774\uc8fc \uacc4\ud68d:<\/strong> BigQuery\ub85c \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\uac70\ub098 BigQuery\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc62c \ub54c, \uc885\uc18d\uc131 \uadf8\ub798\ud504\ub294 \uc5b4\ub5a4 \uc21c\uc11c\ub85c \ub370\uc774\ud130\ub97c \uac00\uc838\uc640\uc57c \ud558\uace0 \uc5b4\ub5a4 \ub370\uc774\ud130\ub97c \uc548\uc804\ud558\uac8c \ub0a8\uaca8\ub458 \uc218 \uc788\ub294\uc9c0 \uc54c\ub824\uc90d\ub2c8\ub2e4. SQLFlow\ub3c4 \ub3d9\uc77c\ud55c \uc5f4 \uc218\uc900 \uadf8\ub798\ud504\ub97c \uad6c\ucd95\ud569\ub2c8\ub2e4. <a href=\"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\/\">\ub208\uc1a1\uc774<\/a> \uadf8\ub9ac\uace0 <a href=\"https:\/\/www.gudusoft.com\/ko\/%ec%a0%81%ec%83%89%ed%8e%b8%ec%9d%b4-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4\/\">\uc544\ub9c8\uc874 \ub808\ub4dc\uc2dc\ud504\ud2b8<\/a>\ub530\ub77c\uc11c \ud558\ub098\uc758 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc591\ucabd\uc5d0\uc11c \uc6e8\uc5b4\ud558\uc6b0\uc2a4 \uac04 \ub9c8\uc774\uadf8\ub808\uc774\uc158\uc744 \ub9e4\ud551\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li><strong>\uaddc\uc815 \uc900\uc218 \ubc0f \uac10\uc0ac:<\/strong> \uac10\uc0ac\uc790\uac00 \uc694\uad6c\ud558\ub294 \uc5f4 \ub2e8\uc704\ub85c \uaddc\uc81c\ub41c \ucd9c\ub825\uc5d0 \ud3ec\ud568\ub418\ub294 \uc18c\uc2a4 \ud544\ub4dc\ub97c \uc785\uc99d\ud574\uc57c \ud558\uba70, \uc774 \ucd9c\ub825\uc740 \uc218\ub3d9\uc73c\ub85c \uad00\ub9ac\ud558\ub294 \uac83\uc774 \uc544\ub2c8\ub77c SQL\uc5d0\uc11c \uc0dd\uc131\ub418\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\uac1c\uc778\uc815\ubcf4 \ubcf4\ud638, \ubc30\ud3ec \ubc0f \uac00\uaca9 \ucc45\uc815<\/h2>\n\n\n\n<p>SQLFlow\ub294 SQL \ucf54\ub4dc\uc640 \uc2a4\ud0a4\ub9c8 \uba54\ud0c0\ub370\uc774\ud130\uc5d0 \ub300\ud55c \uc815\uc801 \ubd84\uc11d\ub9cc \uc218\ud589\ud569\ub2c8\ub2e4. BigQuery \ud14c\uc774\ube14\uc758 \ud589\uc744 \uc77d\uc9c0 \uc54a\uc73c\uba70, \ub370\uc774\ud130 \uc561\uc138\uc2a4 \uad8c\ud55c\uc774 \uc788\ub294 \uc11c\ube44\uc2a4 \uacc4\uc815\ub3c4 \ud544\uc694\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. SQL \ud14d\uc2a4\ud2b8\uc640 DDL\ub9cc\uc73c\ub85c\ub3c4 \ucda9\ubd84\ud569\ub2c8\ub2e4. SQLFlow \ud074\ub77c\uc6b0\ub4dc\ub294 \ubb34\ub8cc \ud2f0\uc5b4\ub97c \uc81c\uacf5\ud558\uba70, \ud504\ub9ac\ubbf8\uc5c4 \ud2f0\uc5b4\ub294 \uc6d4 $49.99\ub2ec\ub7ec\uc785\ub2c8\ub2e4. \uaddc\uc81c \ud658\uacbd\uc758 \uacbd\uc6b0, <a href=\"https:\/\/www.gudusoft.com\/ko\/sqlflow-on-premise-%eb%b2%84%ec%a0%84\/\">\uc628\ud504\ub808\ubbf8\uc2a4 SQLFlow<\/a> \uc790\uccb4 \ub124\ud2b8\uc6cc\ud06c \ub0b4\uc758 Docker \ub610\ub294 Kubernetes \ud658\uacbd\uc5d0\uc11c \uc2e4\ud589\ub418\uba70, \ud544\uc694\ud55c \uacbd\uc6b0 \uc5d0\uc5b4\uac2d \uad6c\uc131\ub3c4 \uac00\ub2a5\ud569\ub2c8\ub2e4. \uc6d4 $500 \ub610\ub294 \uc120\ud0dd\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc720\ud615\ub2f9 \uc77c\ud68c\uc131 $4,800\uc758 \uc694\uae08\uc774 \ubd80\uacfc\ub429\ub2c8\ub2e4. \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \ub2e4\uc74c\uc5d0\uc11c \ud655\uc778\ud558\uc138\uc694. <a href=\"https:\/\/www.gudusoft.com\/ko\/%ea%b0%80%ea%b2%a9\/\">\uac00\uaca9 \ud398\uc774\uc9c0<\/a>\uc5d4\ud130\ud504\ub77c\uc774\uc988 \ud658\uacbd\uc5d0\uc11c\ub294 100\uac1c \uc774\uc0c1\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \ubc31\ub9cc \uac1c \uc774\uc0c1\uc758 \uc5f4\uc744 \ud3ec\ud568\ud558\ub294 \ub300\uaddc\ubaa8 \ud658\uacbd\uc744 \uc77c\uad04 \uc2a4\uce94\ud558\uace0, \uc99d\ubd84 \uc2a4\uce94 \ubc0f \uc601\uad6c\uc801\uc778 \ub370\uc774\ud130 \uacc4\ubcf4 \uc800\uc7a5\uc18c\ub97c \ud65c\uc6a9\ud569\ub2c8\ub2e4.<\/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\">Dataplex\uc5d0\uc11c \uc774\ubbf8 BigQuery \uacc4\ubcf4 \uc815\ubcf4\ub97c \uc81c\uacf5\ud558\uc9c0 \uc54a\ub098\uc694?<\/h3>\n\n\n<p>\ub124, \ud14c\uc774\ube14 \uc218\uc900\uc5d0\uc11c\ub294 \uac00\ub2a5\ud569\ub2c8\ub2e4. Dataplex\ub294 \uac01 BigQuery \uc791\uc5c5\uc774 \uc77d\uace0 \uc4f0\ub294 \ud14c\uc774\ube14\uc744 \uc790\ub3d9\uc73c\ub85c \uae30\ub85d\ud558\ubbc0\ub85c, \uc791\uc5c5 \uc778\ubca4\ud1a0\ub9ac\uac00 \ub9e4\uc6b0 \uc815\ud655\ud569\ub2c8\ub2e4. \ud558\uc9c0\ub9cc SQL \ub0b4\ubd80\uc758 \ubcc0\ud658 \ub85c\uc9c1, \uc989 \uc5b4\ub5a4 \uc5f4\uc774 \uc5b4\ub5a4 \ud45c\ud604\uc2dd\uc744 \ud1b5\ud574 \ub2e4\ub978 \uc5f4\uc5d0 \uc804\ub2ec\ub418\ub294\uc9c0\ub294 \ucd94\ucd9c\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uc774\ub97c \uc704\ud574\uc11c\ub294 SQL\uc744 \ud30c\uc2f1\ud558\ub294 \ub3c4\uad6c\uac00 \ud544\uc694\ud55c\ub370, SQLFlow\uac00 \ubc14\ub85c \uadf8 \uc5ed\ud560\uc744 \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\ub294 STRUCT \ubc0f ARRAY \uc5f4\uc744 \ud1b5\ud574 \ucd94\uc801 \uacc4\ubcf4\ub97c \ucd94\uc801\ud560 \uc218 \uc788\uc2b5\ub2c8\uae4c?<\/h3>\n\n\n<p>\uc608. BigQuery \ud30c\uc11c\ub294 \uc911\ucca9\ub41c \uad6c\uc870\uccb4 \ud544\ub4dc\ub97c \uac1c\ubcc4 \uacc4\ubcf4 \ub178\ub4dc\ub85c \ubaa8\ub378\ub9c1\ud569\ub2c8\ub2e4. <code>\uace0\uac1d \uc774\uba54\uc77c<\/code> \uadf8\ub9ac\uace0 <code>\uace0\uac1d.\uad6d\uac00<\/code> \ubcc4\uac1c\uc758 \uacc4\ubcf4\ub97c \uac00\uc9c0\uace0 \uc788\uc73c\uba70, \uc5ec\ub7ec \ubd84\uc57c\ub97c \uac70\uccd0 \ucd94\uc801\ub429\ub2c8\ub2e4. <code>\uc5b8\ub124\uc2a4\ud2b8<\/code> \ubc18\ubcf5\ub418\ub294 \uc5f4\uc758 \ud3c9\uba74\ud654.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\ub294 BigQuery \ubdf0\uc5d0\uc11c SELECT *\ub97c \uc5b4\ub5bb\uac8c \ucc98\ub9ac\ud558\ub098\uc694?<\/h3>\n\n\n<p>\uc2a4\ud0c0 \ud45c\ud604\uc2dd\uc740 \uc2e4\uc81c \ud14c\uc774\ube14 \ubc0f \ubdf0 \uc815\uc758\uc5d0 \ub300\ud574 \ud655\uc7a5\ub418\ubbc0\ub85c \ubaa8\ub4e0 \uc554\uc2dc\uc801 \uc5f4\uc5d0 \uba85\uc2dc\uc801\uc778 \uacc4\ubcf4\uac00 \ubd80\uc5ec\ub429\ub2c8\ub2e4. \uc774\ub294 \ub2e4\uc911 \uacc4\uce35 \ubdf0 \uccb4\uc778\uc744 \ud1b5\ud574 \uc791\ub3d9\ud558\uba70, \uc0c1\uc704 \ubdf0 \ub4a4\uc5d0 \uc788\ub294 \uc5f4\uc740 \uc0c1\uc704 \ubdf0 \ub4a4\uc5d0 \uc788\uc2b5\ub2c8\ub2e4. <code>\uc120\ud0dd\ud558\ub2e4 *<\/code> \uc5ec\ub7ec \uc0c1\ub958 \uad00\uc810\uc5d0\uc11c \uc815\uc758\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\uc608\uc57d\ub41c \ucffc\ub9ac\uc640 \ubdf0 \uc804\ubc18\uc5d0 \uac78\uccd0 \uacc4\ubcf4\ub97c \ud568\uaed8 \ub9e4\ud551\ud560 \uc218 \uc788\uc2b5\ub2c8\uae4c?<\/h3>\n\n\n<p>\uc608. \uc608\uc57d\ub41c \ucffc\ub9ac SQL\uacfc \ubdf0 DDL\uc744 \ud558\ub098\uc758 \uc791\uc5c5\uc73c\ub85c \ubd84\uc11d\ud558\uba74 SQLFlow\uac00 \uc804\uccb4 \uacfc\uc815\uc744 \uc5f0\uacb0\ud574 \uc8fc\ubbc0\ub85c, \ubcf4\uace0\uc11c \uc5f4\uc744 \uad6c\uccb4\ud654\ub41c \ucffc\ub9ac\uc640 \ubaa8\ub4e0 \uc911\uac04 \ubdf0\ub97c \uac70\uccd0 \uc6d0\ubcf8 \uc18c\uc2a4 \uc5f4\uae4c\uc9c0 \ucd94\uc801\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\ub294 BigQuery \ub370\uc774\ud130\uc5d0 \ub300\ud55c \uc811\uadfc \uad8c\ud55c\uc774 \ud544\uc694\ud55c\uac00\uc694?<\/h3>\n\n\n<p>\uc544\ub2c8\uc694. \uc774\ub294 \uc815\uc801 \ubd84\uc11d\uc785\ub2c8\ub2e4. SQL \ud14d\uc2a4\ud2b8\uc640 \uc120\ud0dd\uc801\uc73c\ub85c \uc2a4\ud0a4\ub9c8 \uba54\ud0c0\ub370\uc774\ud130\ub9cc \ubd84\uc11d\ud569\ub2c8\ub2e4. \ud14c\uc774\ube14 \ud589 \ub370\uc774\ud130\ub294 \uc808\ub300 \uc77d\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uc628\ud504\ub808\ubbf8\uc2a4 \ud658\uacbd\uc5d0\uc11c\ub294 SQL \ud14d\uc2a4\ud2b8\uc870\ucc28\ub3c4 \ub124\ud2b8\uc6cc\ud06c \ub0b4\uc5d0 \uc720\uc9c0\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow \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 \uacc4\uc815\uc740 \uc6d4 $49.99\uc785\ub2c8\ub2e4. SQLFlow On-Premise\ub294 \uc120\ud0dd\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc720\ud615\ub2f9 \uc6d4 $500 \ub610\ub294 \uc77c\ud68c\uc131 \uacb0\uc81c \uc2dc $4,800\uc774\uba70, \ub450 \ub300\uc758 \uc11c\ubc84\uc5d0 \uc124\uce58\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/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\">BigQuery \uacc4\ubcf4\ub97c \uc9c0\uae08 \ud655\uc778\ud558\uc138\uc694<\/h2>\n\n\n<p>BigQuery \ucffc\ub9ac\ub97c \ubb34\ub8cc \uc2dc\uac01\ud654 \ub3c4\uad6c\uc5d0 \ubd99\uc5ec\ub123\uac70\ub098, \uc804\uccb4 \ud504\ub85c\uc81d\ud2b8 \uc2a4\uce94\uc5d0 \ub300\ud574 \uc800\ud76c\uc640 \uc0c1\ub2f4\ud574 \ubcf4\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=bigquery-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\\\/bigquery-data-lineage\\\/\",\n            \"description\": \"Automated SQL data lineage tool with a dedicated BigQuery dialect parser: column-level lineage through STRUCT fields, UNNEST, star expansion, view chains, and scheduled queries.\",\n            \"featureList\": \"BigQuery column-level lineage, nested STRUCT field lineage, UNNEST tracing, star expansion, indirect\\\/impact lineage, ER diagrams from NOT ENFORCED constraints, dbt support, REST API, DataHub\\\/Purview\\\/OpenMetadata export\",\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\": \"Doesn't Dataplex already give me BigQuery lineage?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes, at the table level. Dataplex automatically records which tables each BigQuery job reads and writes. It does not extract the transform logic inside the SQL \\u2014 which columns feed which, through which expressions. For that you need a tool that parses the SQL, which is what SQLFlow does.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Can SQLFlow trace lineage through STRUCT and ARRAY columns?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes. The BigQuery parser models nested struct fields as individual lineage nodes, so customer.email and customer.country have separate lineage, and it traces fields through UNNEST flattening of repeated columns.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"How does SQLFlow handle SELECT * in BigQuery views?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Star expressions are expanded against the actual table and view definitions, so every implicit column gets explicit lineage, even through multi-layer view chains.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Can it map lineage across scheduled queries and views together?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes. Analyze the scheduled-query SQL and view DDL as one job and SQLFlow stitches the end-to-end chain from reporting columns back to raw source columns.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Does SQLFlow need access to my BigQuery data?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"No. It is static analysis of SQL text plus optional schema metadata. Table row data is never read. With the On-Premise edition, even the SQL text stays inside your network.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"What does SQLFlow cost?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"SQLFlow Cloud starts free; premium accounts are $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>BigQuery data lineage is the map of how data moves through your BigQuery project: which source tables and columns feed each derived table, view, and scheduled query, and which expressions transform the data along the way. Google&#8217;s Dataplex captures lineage automatically for BigQuery jobs at the table level; to see which columns feed which, and through which functions and joins, you have to parse the SQL itself. Gudu SQLFlow does exactly that, with a dedicated BigQuery dialect parser that resolves nested STRUCT fields, UNNEST, star expansion, and view chains down to column granularity. Try it in 30 seconds: paste any\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\/6750"}],"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=6750"}],"version-history":[{"count":0,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages\/6750\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/media?parent=6750"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}