{"id":3493,"date":"2022-04-25T07:19:32","date_gmt":"2022-04-25T15:19:32","guid":{"rendered":"https:\/\/www.gudusoft.com\/?p=3493"},"modified":"2026-07-11T22:56:12","modified_gmt":"2026-07-12T06:56:12","slug":"data-lineage-create-external-table","status":"publish","type":"post","link":"https:\/\/www.gudusoft.com\/ko\/%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4-%ec%83%9d%ec%84%b1-%ec%99%b8%eb%b6%80-%ed%85%8c%ec%9d%b4%eb%b8%94\/","title":{"rendered":"\ub370\uc774\ud130 \uacc4\ubcf4 \uc678\ubd80 \ud14c\uc774\ube14 \uc0dd\uc131 | Gudu SQLFlow"},"content":{"rendered":"<p><\/p>\r\n<h2><strong>\ub370\uc774\ud130 \uacc4\ubcf4 \uc678\ubd80 \ud14c\uc774\ube14 \uc0dd\uc131 | Gudu SQLFlow<\/strong><\/h2>\r\n<p>\ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc5d0\uc11c \uc6d0\ubcf8 \ub370\uc774\ud130\ub294 \ud56d\uc0c1 Amazon S3, Google Cloud Storage, Microsoft Azure\uc640 \uac19\uc740 \ub300\uc6a9\ub7c9 \uc800\uc7a5\uc18c\uc5d0\uc11c \uac00\uc838\uc624\uace0, \uc774\ub7ec\ud55c \ub370\uc774\ud130\ub294 BigQuery, Snowflake, Redshift, Microsoft Azure\uc640 \uac19\uc740 \uc2dc\uc2a4\ud15c\uc5d0 \ub85c\ub4dc\ub429\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ub370\uc774\ud130\ub97c \ub85c\ub4dc\ud558\uac70\ub098 \uc0ac\uc6a9\ud558\ub294 \ub370 \uc0ac\uc6a9\ub418\ub294 \ubc29\ubc95 \uc911 \ud558\ub098\ub294 create external table SQL \ubb38\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \uc678\ubd80 \ud30c\uc77c\uc5d0\uc11c \uc678\ubd80 \ud14c\uc774\ube14\ub85c\uc758 \ub370\uc774\ud130 \uacc4\ubcf4\ub294 \ub2e4\uc74c\uc744 \ud1b5\ud574 \uc27d\uac8c \ucea1\ucc98\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <strong>Gudu SQLFlow<\/strong> create external table SQL \ucffc\ub9ac\ub97c \uad6c\ubb38 \ubd84\uc11d\ud558\uc5ec. \uc774 \ub370\uc774\ud130\ub97c \uac00\uc9c0\uace0, <strong>Gudu SQLFlow<\/strong> \ub370\uc774\ud130 \ubd84\uc11d \uacfc\uc815\uc5d0\uc11c \uc624\ub958\ub97c \uadfc\ubcf8 \uc6d0\uc778\uae4c\uc9c0 \ucd94\uc801\ud558\ub294 \uae30\ub2a5\uc744 \ud06c\uac8c \uac04\uc18c\ud654\ud569\ub2c8\ub2e4.<\/p>\r\n<figure id=\"attachment_3544\" aria-describedby=\"caption-attachment-3544\" style=\"width: 586px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" loading=\"lazy\" class=\"size-full wp-image-3544\" src=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/Data_Lineage_Create_External_Table.png\" alt=\"\ub370\uc774\ud130 \uacc4\ubcf4 \uc678\ubd80 \ud14c\uc774\ube14 \uc0dd\uc131\" width=\"586\" height=\"482\" srcset=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/Data_Lineage_Create_External_Table.png 586w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/Data_Lineage_Create_External_Table-300x247.png 300w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/Data_Lineage_Create_External_Table-200x165.png 200w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/Data_Lineage_Create_External_Table-400x329.png 400w\" sizes=\"(max-width: 586px) 100vw, 586px\" \/><figcaption id=\"caption-attachment-3544\" class=\"wp-caption-text\">\ub370\uc774\ud130 \uacc4\ubcf4 \uc678\ubd80 \ud14c\uc774\ube14 \uc0dd\uc131<\/figcaption><\/figure>\r\n<p>\uc774 \uae00\uc5d0\uc11c\ub294 BigQuery, Snowflake, Redshift, Microsoft Azure\uc5d0\uc11c \uc0ac\uc6a9\ub418\ub294 \uc678\ubd80 \ud14c\uc774\ube14 \uc0dd\uc131 SQL \ubb38\uc744 \uc18c\uac1c\ud558\uace0, \uc0dd\uc131\ub41c \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. <strong>Gudu SQLFlow<\/strong> SQL \uc2a4\ud06c\ub9bd\ud2b8\ub97c \ubd84\uc11d\ud55c \ud6c4.<\/p>\r\n<h3>BigQuery \uc678\ubd80 \ud14c\uc774\ube14 \uc0dd\uc131<\/h3>\r\n<p>\uc678\ubd80 \ud14c\uc774\ube14\uc744 \uc0ac\uc6a9\ud558\uba74 BigQuery\uac00 BigQuery \uc800\uc7a5\uc18c \uc678\ubd80\uc5d0 \uc800\uc7a5\ub41c \ub370\uc774\ud130\ub97c \ucffc\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc678\ubd80 \ud14c\uc774\ube14\uc5d0 \ub300\ud55c \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \ub2e4\uc74c\uc744 \ucc38\uc870\ud558\uc138\uc694. <strong><a href=\"https:\/\/cloud.google.com\/bigquery\/external-data-cloud-storage\">\uc678\ubd80 \ub370\uc774\ud130 \uc18c\uc2a4 \uc18c\uac1c<\/a><\/strong>.<\/p>\r\n<p><strong>Gudu SQLFlow<\/strong> BigQuery\uc5d0\uc11c \uc678\ubd80 \ud14c\uc774\ube14 \uc0dd\uc131 \ubb38\uc744 \ubd84\uc11d\ud558\uace0 \uc0dd\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <strong><a href=\"https:\/\/www.gudusoft.com\/ko\/whats-data-lineage-why-important\/\">\ub370\uc774\ud130 \uacc4\ubcf4<\/a><\/strong> \uc774 SQL \ubb38\uc744 \ubd84\uc11d\ud55c \ud6c4.<\/p>\r\n<p>BigQuery\uc5d0\uc11c \uc678\ubd80 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\ub294 SQL \ucffc\ub9ac\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\r\n\r\n<pre class=\"wp-block-code\"><code>\uc678\ubd80 \ud14c\uc774\ube14 dataset.CsvTable(x INT64, y STRING) OPTIONS(format=&#039;CSV&#039;, uris=[&#039;gs:\/\/bucket\/path1.csv&#039;], field_delimiter=&#039;|&#039;, max_bad_records=5)\ub97c \uc0dd\uc131 \ub610\ub294 \uad50\uccb4\ud569\ub2c8\ub2e4.<\/code><\/pre>\r\n\r\n\r\n\r\n<p>\uc704 SQL\uc5d0\uc11c \uc0dd\uc131\ub41c \ub370\uc774\ud130 \uacc4\ubcf4\ub294 Google Storage\uc5d0 \uc800\uc7a5\ub41c gs:\/\/bucket\/path1.csv \ud30c\uc77c\uc774 dataset.CsvTable \uc678\ubd80 \ud14c\uc774\ube14\uc758 \uc18c\uc2a4\ub85c \ucc98\ub9ac\ub418\ub294 \uac83\uc744 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><\/figure>\r\n\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter\"><a href=\"https:\/\/sqlflow.gudusoft.com\"><img decoding=\"async\" loading=\"lazy\" width=\"439\" height=\"87\" class=\"wp-image-3576\" src=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/data-lineage-bigquery-create-external-table-1.png\" alt=\"\ub370\uc774\ud130 \uacc4\ubcf4 \uc678\ubd80 \ud14c\uc774\ube14 \uc0dd\uc131\" srcset=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/data-lineage-bigquery-create-external-table-1.png 439w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/data-lineage-bigquery-create-external-table-1-300x59.png 300w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/data-lineage-bigquery-create-external-table-1-200x40.png 200w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/data-lineage-bigquery-create-external-table-1-400x79.png 400w\" sizes=\"(max-width: 439px) 100vw, 439px\" \/><\/a>\r\n<figcaption>\ub370\uc774\ud130 \uacc4\ubcf4 \uc678\ubd80 \ud14c\uc774\ube14 \uc0dd\uc131<\/figcaption>\r\n<\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\">\ub208\uc1a1\uc774 \uc678\ubd80 \ud14c\uc774\ube14 \uc0dd\uc131<\/h3>\r\n\r\n\r\n\r\n<p>Snowflake\ub294 \uc9c0\uc815\ub41c \uc678\ubd80 \ub2e8\uacc4\uc5d0\uc11c \ud558\ub098 \uc774\uc0c1\uc758 \ud30c\uc77c \uc9d1\ud569\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uc77d\uace0 \ub2e8\uc77c VARIANT \uc5f4\uc5d0 \ub370\uc774\ud130\ub97c \ucd9c\ub825\ud558\ub294 \uc678\ubd80 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4. <a class=\"rank-math-link\" href=\"https:\/\/docs.snowflake.com\/en\/sql-reference\/sql\/create-external-table.html\"><strong>\uc678\ubd80 \ud14c\uc774\ube14 \ubb38 \uc0dd\uc131<\/strong><\/a> \ud604\uc7ac\/\uc9c0\uc815\ub41c \uc2a4\ud0a4\ub9c8\uc5d0 \uc0c8 \uc678\ubd80 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\uac70\ub098 \uae30\uc874 \uc678\ubd80 \ud14c\uc774\ube14\uc744 \ubc14\uafc9\ub2c8\ub2e4.<\/p>\r\n\r\n\r\n\r\n<p>\uc678\ubd80 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\uae30 \uc804\uc5d0 \ub2e4\uc74c\uc774 \ud544\uc694\ud569\ub2c8\ub2e4. <a class=\"rank-math-link\" href=\"https:\/\/docs.snowflake.com\/en\/sql-reference\/sql\/create-stage.html\"><strong>\uc678\ubd80 \ubb34\ub300\ub97c \ub9cc\ub4e4\ub2e4<\/strong><\/a> \ub370\uc774\ud130 \ud30c\uc77c\uc774 \uc800\uc7a5\ub418\ub294 \uc800\uc7a5 \uc704\uce58\uc785\ub2c8\ub2e4.<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-code\"><code>\uc2a4\ud14c\uc774\uc9c0 s1\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4 url=&#039;s3:\/\/mybucket\/files\/logs\/&#039; ... ;<\/code><\/pre>\r\n\r\n\r\n\r\n<p>\ubd84\ud560\ub41c \uc678\ubd80 \ud14c\uc774\ube14\uc744 \ub9cc\ub4ed\ub2c8\ub2e4.<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-code\"><code>et1(date_part date as to_date(split_part(metadata$filename, &#039;\/&#039;, 3) || &#039;\/&#039; || split_part(metadata$filename, &#039;\/&#039;, 4) || &#039;\/&#039; || split_part(metadata$filename, &#039;\/&#039;, 5), &#039;YYYY\/MM\/DD&#039;), timestamp bigint as (value:timestamp::bigint), col2 varchar as (value:col2::varchar)) (date_part)\ub85c \ubd84\ud560 location=@s1\/logs\/ auto_refresh = true file_format = (type = parquet) aws_sns_topic = &#039;arn:aws:sns:us-west-2:001234567890:s3_mybucket&#039;; \uc678\ubd80 \ud14c\uc774\ube14 \uc0dd\uc131<\/code><\/pre>\r\n\r\n\r\n\r\n<p>Gudu SQLFlow\ub294 Snowflake\uc5d0\uc11c \uc678\ubd80 \ud14c\uc774\ube14 \ucffc\ub9ac \ubb38\uc744 \uc0dd\uc131\ud558\uace0 \uc678\ubd80 \uc2a4\ud14c\uc774\uc9c0\uc758 \ud30c\uc77c\uacfc \uc678\ubd80 \ud14c\uc774\ube14 \uac04\uc758 \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \ub2e4\uc74c\uacfc \uac19\uc774 \uad6c\ucd95\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><\/figure>\r\n\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter\"><a href=\"https:\/\/sqlflow.gudusoft.com\"><img decoding=\"async\" loading=\"lazy\" width=\"428\" height=\"108\" class=\"wp-image-3505\" src=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/data-lineage-snowflake-create-external-table.png\" alt=\"\ub370\uc774\ud130 \uacc4\ubcf4 \uc678\ubd80 \ud14c\uc774\ube14 \uc0dd\uc131\" srcset=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/data-lineage-snowflake-create-external-table.png 428w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/data-lineage-snowflake-create-external-table-300x76.png 300w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/data-lineage-snowflake-create-external-table-200x50.png 200w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/data-lineage-snowflake-create-external-table-400x101.png 400w\" sizes=\"(max-width: 428px) 100vw, 428px\" \/><\/a>\r\n<figcaption>\ub370\uc774\ud130 \uacc4\ubcf4 \uc678\ubd80 \ud14c\uc774\ube14 \uc0dd\uc131<\/figcaption>\r\n<\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n<p>Snowflake\uc5d0\uc11c\ub294 \uc678\ubd80 \ud30c\uc77c\uc758 \ub370\uc774\ud130\ub3c4 \ub2e4\uc74c\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud14c\uc774\ube14\ub85c \uc774\ub3d9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <strong><a class=\"rank-math-link\" href=\"https:\/\/github.com\/sqlparser\/sqlflow_public\/tree\/master\/databases\/snowflake\/copy-from-json\">\ubcf5\uc0ac\ud558\ub2e4<\/a><\/strong> SQL \ubb38\uacfc Gudu SQLFlow\ub3c4 SQL \ucffc\ub9ac \ubb38\uc73c\ub85c \ubcf5\uc0ac\ub41c \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uac10\uc9c0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\">SQL Server \ubc0f Azure Synapse Analytics<\/h2>\r\n\r\n\r\n\r\n<p>\uc678\ubd80 \ud14c\uc774\ube14 \uc0dd\uc131 \uba85\ub839\uc740 PolyBase\uac00 Hadoop \ud074\ub7ec\uc2a4\ud130 \ub610\ub294 Azure Blob \uc800\uc7a5\uc18c\uc5d0 \uc800\uc7a5\ub41c \ub370\uc774\ud130\uc5d0 \uc561\uc138\uc2a4\ud560 \uc218 \uc788\ub294 \uc678\ubd80 \ud14c\uc774\ube14\uc744 \ub9cc\ub4ed\ub2c8\ub2e4. Hadoop \ud074\ub7ec\uc2a4\ud130 \ub610\ub294 Azure Blob \uc800\uc7a5\uc18c\uc5d0 \uc800\uc7a5\ub41c \ub370\uc774\ud130\ub97c \ucc38\uc870\ud558\ub294 PolyBase \uc678\ubd80 \ud14c\uc774\ube14\uc785\ub2c8\ub2e4.<\/p>\r\n\r\n\r\n\r\n<p>Azure Synapse Analytics\uc5d0\uc11c \uc0dd\uc131\ub41c \uc678\ubd80 \ud14c\uc774\ube14\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\r\n\r\n\r\n\r\n<ul>\r\n<li>Transact-SQL \ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec Hadoop \ub610\ub294 Azure Blob \uc800\uc7a5\uc18c \ub370\uc774\ud130\ub97c \ucffc\ub9ac\ud569\ub2c8\ub2e4.<\/li>\r\n<li>Hadoop \ub610\ub294 Azure Blob \uc2a4\ud1a0\ub9ac\uc9c0\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc640 \uc800\uc7a5\ud569\ub2c8\ub2e4.<\/li>\r\n<li>Azure Data Lake Store\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\uace0 \uc800\uc7a5\ud569\ub2c8\ub2e4.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p>\uc678\ubd80 \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\ub824\uba74 \uba3c\uc800 \uc678\ubd80 \ub370\uc774\ud130 \uc18c\uc2a4\ub97c \ub9cc\ub4e4\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-code\"><code>(TYPE = HADOOP, LOCATION = &#039;abfss:\/\/data@pbasetr.azuredatalakestore.net&#039;)\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc678\ubd80 \ub370\uc774\ud130 \uc6d0\ubcf8 AzureDataLakeStore\ub97c \ub9cc\ub4ed\ub2c8\ub2e4.<\/code><\/pre>\r\n\r\n\r\n\r\n<p>\uadf8\ub7f0 \ub2e4\uc74c \uc774 SQL \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc678\ubd80 \ud14c\uc774\ube14\uc744 \ub9cc\ub4ed\ub2c8\ub2e4.<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-code\"><code>\uc678\ubd80 \ud14c\uc774\ube14 [dbo].[DimProductexternal] ( [\uc81c\ud488 \ud0a4] [\uc815\uc218] NULL\uc774 \uc544\ub2d8, [\uc81c\ud488 \ub808\uc774\ube14] nvarchar NULL, [\uc81c\ud488 \uc774\ub984] nvarchar NULL)\uc744 \ub9cc\ub4ed\ub2c8\ub2e4. \uc704\uce58=&#039;\/DimProduct\/&#039;, \ub370\uc774\ud130 \uc18c\uc2a4=AzureDataLakeStore, \ud30c\uc77c \ud615\uc2dd=TextFileFormat, \uac70\ubd80 \uc720\ud615=VALUE, \uac70\ubd80 \uac12=0)\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/code><\/pre>\r\n\r\n\r\n\r\n<p>Gudu SQLFlow\uc5d0\uc11c create external table \uba85\ub839\ubb38\uc744 \uad6c\ubb38 \ubd84\uc11d\ud55c \ud6c4 \uc0dd\uc131\ub41c \ub370\uc774\ud130 \uacc4\ubcf4\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\r\n\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter size-large is-resized\"><a href=\"https:\/\/sqlflow.gudusoft.com\"><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-3752\" src=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/data-lineage-sqlserver-create-external-table-1-1024x119.png\" alt=\"\" width=\"899\" height=\"104\" srcset=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/data-lineage-sqlserver-create-external-table-1-1024x119.png 1024w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/data-lineage-sqlserver-create-external-table-1-300x35.png 300w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/data-lineage-sqlserver-create-external-table-1-768x89.png 768w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/data-lineage-sqlserver-create-external-table-1-200x23.png 200w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/data-lineage-sqlserver-create-external-table-1-400x46.png 400w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/data-lineage-sqlserver-create-external-table-1-600x69.png 600w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/data-lineage-sqlserver-create-external-table-1-800x93.png 800w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/data-lineage-sqlserver-create-external-table-1.png 1080w\" sizes=\"(max-width: 899px) 100vw, 899px\" \/><\/a>\r\n<figcaption>SQL Server\uc5d0\uc11c \uc678\ubd80 \ud14c\uc774\ube14 \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/figcaption>\r\n<\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\">AWS Redshift \uc678\ubd80 \ud14c\uc774\ube14 \uc0dd\uc131<\/h2>\r\n\r\n\r\n\r\n<p>Amazon Redshift, AWS Glue, Amazon Athena \ub610\ub294 Apache Hive \uba54\ud0c0\uc2a4\ud1a0\uc5b4\uc5d0\uc11c \uc678\ubd80 \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc678\ubd80 \ud14c\uc774\ube14\uc774 AWS Glue, Athena \ub610\ub294 Hive \uba54\ud0c0\uc2a4\ud1a0\uc5b4\uc5d0 \uc815\uc758\ub41c \uacbd\uc6b0 \uba3c\uc800 \uc678\ubd80 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ucc38\uc870\ud558\ub294 \uc678\ubd80 \uc2a4\ud0a4\ub9c8\ub97c \ub9cc\ub4ed\ub2c8\ub2e4. \uadf8\ub7f0 \ub2e4\uc74c Amazon Redshift\uc5d0\uc11c \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4 \ud544\uc694 \uc5c6\uc774 \ud14c\uc774\ube14 \uc774\ub984 \uc55e\uc5d0 \uc2a4\ud0a4\ub9c8 \uc774\ub984\uc744 \uc811\ub450\uc0ac\ub85c \ubd99\uc5ec SELECT \ubb38\uc5d0\uc11c \uc678\ubd80 \ud14c\uc774\ube14\uc744 \ucc38\uc870\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\u00a0<\/p>\r\n\r\n\r\n\r\n<p>\ub2e4\uc74c \uc608\uc81c\uc5d0\uc11c\ub294 Amazon Redshift \uc678\ubd80 \uc2a4\ud0a4\ub9c8\uc5d0 SALES\ub77c\ub294 \uc774\ub984\uc758 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4.\u00a0<code>\uc2a4\ud399\ud2b8\ub7fc<\/code>\ub370\uc774\ud130\ub294 \ud0ed\uc73c\ub85c \uad6c\ubd84\ub41c \ud14d\uc2a4\ud2b8 \ud30c\uc77c\uc5d0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-code\"><code>\uc678\ubd80 \ud14c\uc774\ube14 spectrum.sales( salesid \uc815\uc218, listid \uc815\uc218, sellerid \uc815\uc218, buyerid \uc815\uc218, eventid \uc815\uc218, dateid smallint, qtysold smallint, pricepaid \uc18c\uc218\uc810(8,2), commission \uc18c\uc218\uc810(8,2), saletime \ud0c0\uc784\uc2a4\ud0ec\ud504)\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4. \ud589 \ud615\uc2dd\uc740 &#039;t&#039;\ub85c \ub05d\ub098\ub294 \uad6c\ubd84\ub41c \ud544\ub4dc\ub97c \ud3ec\ud568\ud558\uace0 \ud14d\uc2a4\ud2b8 \ud30c\uc77c\ub85c \uc800\uc7a5\ub429\ub2c8\ub2e4. \uc704\uce58 &#039;s3:\/\/awssampledbuswest2\/tickit\/spectrum\/sales\/&#039; \ud14c\uc774\ube14 \uc18d\uc131(&#039;numRows&#039;=&#039;172000&#039;);<\/code><\/pre>\r\n\r\n\r\n\r\n<p>\uc704\uc758 SQL\uc744 \uad6c\ubb38 \ubd84\uc11d\ud55c \ud6c4 Gudu SQLFlow\uc5d0\uc11c \uc0dd\uc131\ub41c \ub370\uc774\ud130 \uacc4\ubcf4\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\r\n\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/sqlflow.gudusoft.com\"><img decoding=\"async\" loading=\"lazy\" width=\"644\" height=\"216\" class=\"wp-image-3799\" src=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/data-lineage-redshift-create-external-table.png\" alt=\"\" srcset=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/data-lineage-redshift-create-external-table.png 644w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/data-lineage-redshift-create-external-table-300x101.png 300w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/data-lineage-redshift-create-external-table-200x67.png 200w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/data-lineage-redshift-create-external-table-400x134.png 400w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/data-lineage-redshift-create-external-table-600x201.png 600w\" sizes=\"(max-width: 644px) 100vw, 644px\" \/><\/a>\r\n<figcaption>Redshift \uc678\ubd80 \ud14c\uc774\ube14 \uc0dd\uc131 \ub370\uc774\ud130 \uacc4\ubcf4<\/figcaption>\r\n<\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\">\uacb0\ub860\u00a0<\/h2>\r\n\r\n\r\n\r\n<p>\uc800\ud76c \uae30\uc0ac\ub97c \uc77d\uc5b4\uc8fc\uc154\uc11c \uac10\uc0ac\ud569\ub2c8\ub2e4. \uc774 \uae30\uc0ac\uac00 \uadc0\ud558\uaed8\uc11c \uc800\ud76c \uae30\uc0ac\ub97c \ub354 \uc798 \uc774\ud574\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub41c\ub2e4\uba74, <strong>\ub370\uc774\ud130 \uacc4\ubcf4\ub294 \uc5b4\ub5bb\uac8c \uc678\ubd80 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud569\ub2c8\uae4c?<\/strong>, \uc6b0\ub9ac\ub294 \ub9e4\uc6b0 \uae30\uc060 \uac83\uc785\ub2c8\ub2e4. \ub354 \ub9ce\uc740 \uac83\uc744 \uc54c\uace0 \uc2f6\ub2e4\uba74 <strong>\ub370\uc774\ud130 \uacc4\ubcf4 \uc678\ubd80 \ud14c\uc774\ube14 \uc0dd\uc131<\/strong>, \uc800\ud76c \uc6f9\uc0ac\uc774\ud2b8\ub97c \ubc29\ubb38\ud574 \uc8fc\uc2dc\uae30\ub97c \ubc14\ub78d\ub2c8\ub2e4. <strong><a href=\"https:\/\/sqlflow.gudusoft.com\">Gudu SQLFlow<\/a><\/strong> \uc790\uc138\ud55c \ub0b4\uc6a9\uc740. (Ryan\uc774 2022\ub144 4\uc6d4 25\uc77c\uc5d0 \ud3b8\uc9d1)<br \/><br \/><\/p>\r\n\r\n<p><\/p>","protected":false},"excerpt":{"rendered":"<p>\ub370\uc774\ud130 \uacc4\ubcf4: \uc678\ubd80 \ud14c\uc774\ube14 \uc0dd\uc131 | Gudu SQLFlow \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc5d0\uc11c \uc6d0\ubcf8 \ub370\uc774\ud130\ub294 \ud56d\uc0c1 Amazon S3, Google Cloud Storage, Microsoft Azure\uc640 \uac19\uc740 \ub300\uc6a9\ub7c9 \uc2a4\ud1a0\ub9ac\uc9c0\uc5d0 \uc800\uc7a5\ub418\uba70, \uc774\ub7ec\ud55c \ub370\uc774\ud130\ub294 BigQuery, Snowflake, Redshift, Microsoft Azure\uc640 \uac19\uc740 \uc2dc\uc2a4\ud15c\uc5d0 \ub85c\ub4dc\ub429\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ub370\uc774\ud130\ub97c \ub85c\ub4dc\ud558\uac70\ub098 \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95 \uc911 \ud558\ub098\ub294 \uc678\ubd80 \ud14c\uc774\ube14 \uc0dd\uc131 SQL \ubb38\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. Gudu SQLFlow\ub294 \uc678\ubd80 \ud30c\uc77c\uc5d0\uc11c \uc678\ubd80 \ud14c\uc774\ube14\ub85c\uc758 \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uc678\ubd80 \ud14c\uc774\ube14 \uc0dd\uc131 SQL \ucffc\ub9ac\ub97c \ud30c\uc2f1\ud558\uc5ec \uc27d\uac8c \ucea1\ucc98\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub807\uac8c \uc5bb\uc740 \ub370\uc774\ud130\ub97c \ubc14\ud0d5\uc73c\ub85c Gudu\ub294\u2026<\/p>","protected":false},"author":27,"featured_media":3544,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[31],"tags":[81,83,79,55,75,82,80],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"_links":{"self":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts\/3493"}],"collection":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/comments?post=3493"}],"version-history":[{"count":50,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts\/3493\/revisions"}],"predecessor-version":[{"id":6618,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts\/3493\/revisions\/6618"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/media\/3544"}],"wp:attachment":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/media?parent=3493"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/categories?post=3493"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/tags?post=3493"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}