{"id":3493,"date":"2022-04-25T07:19:32","date_gmt":"2022-04-25T15:19:32","guid":{"rendered":"https:\/\/www.gudusoft.com\/?p=3493"},"modified":"2022-05-19T01:40:00","modified_gmt":"2022-05-19T09:40:00","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":"<div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-1 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#e8eaf0;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1310.4px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-0 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><div class=\"fusion-text fusion-text-1\" style=\"line-height:26px;\"><h2><strong>\ub370\uc774\ud130 \uacc4\ubcf4 \uc678\ubd80 \ud14c\uc774\ube14 \uc0dd\uc131 | Gudu SQLFlow<\/strong><\/h2>\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>\n<div id=\"attachment_3544\" style=\"width: 596px\" class=\"wp-caption aligncenter\"><img aria-describedby=\"caption-attachment-3544\" decoding=\"async\" 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-200x165.png 200w, 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-400x329.png 400w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/Data_Lineage_Create_External_Table.png 586w\" sizes=\"(max-width: 586px) 100vw, 586px\" \/><p id=\"caption-attachment-3544\" class=\"wp-caption-text\">\ub370\uc774\ud130 \uacc4\ubcf4 \uc678\ubd80 \ud14c\uc774\ube14 \uc0dd\uc131<\/p><\/div>\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>\n<h3>BigQuery \uc678\ubd80 \ud14c\uc774\ube14 \uc0dd\uc131<\/h3>\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>\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\/%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4%ec%9d%98-%ec%a4%91%ec%9a%94%ec%84%b1\/\">\ub370\uc774\ud130 \uacc4\ubcf4<\/a><\/strong> \uc774 SQL \ubb38\uc744 \ubd84\uc11d\ud55c \ud6c4.<\/p>\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>\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>\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>\n<figure class=\"wp-block-image size-large\"><\/figure>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"https:\/\/sqlflow.gudusoft.com\"><img decoding=\"async\" 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-200x40.png 200w, 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-400x79.png 400w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/data-lineage-bigquery-create-external-table-1.png 439w\" sizes=\"(max-width: 439px) 100vw, 439px\" \/><\/a><figcaption>\ub370\uc774\ud130 \uacc4\ubcf4 \uc678\ubd80 \ud14c\uc774\ube14 \uc0dd\uc131<\/figcaption><\/figure>\n<\/div>\n<h3 class=\"wp-block-heading\">\ub208\uc1a1\uc774 \uc678\ubd80 \ud14c\uc774\ube14 \uc0dd\uc131<\/h3>\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>\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>\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>\n<p>\ubd84\ud560\ub41c \uc678\ubd80 \ud14c\uc774\ube14\uc744 \ub9cc\ub4ed\ub2c8\ub2e4.<\/p>\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>\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>\n<figure class=\"wp-block-image size-large\"><\/figure>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"https:\/\/sqlflow.gudusoft.com\"><img decoding=\"async\" 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-200x50.png 200w, 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-400x101.png 400w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/04\/data-lineage-snowflake-create-external-table.png 428w\" sizes=\"(max-width: 428px) 100vw, 428px\" \/><\/a><figcaption>\ub370\uc774\ud130 \uacc4\ubcf4 \uc678\ubd80 \ud14c\uc774\ube14 \uc0dd\uc131<\/figcaption><\/figure>\n<\/div>\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>\n<h2 class=\"wp-block-heading\">SQL Server \ubc0f Azure Synapse Analytics<\/h2>\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>\n<p>Azure Synapse Analytics\uc5d0\uc11c \uc0dd\uc131\ub41c \uc678\ubd80 \ud14c\uc774\ube14\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<ul>\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>\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>\n<li>Azure Data Lake Store\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\uace0 \uc800\uc7a5\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\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>\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>\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>\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>\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>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><a href=\"https:\/\/sqlflow.gudusoft.com\"><img decoding=\"async\" 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-200x23.png 200w, 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-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-768x89.png 768w, 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-1024x119.png 1024w, 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><figcaption>SQL Server create exernal table data lineage<\/figcaption><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\">AWS Redshift \uc678\ubd80 \ud14c\uc774\ube14 \uc0dd\uc131<\/h2>\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>\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>\n<pre class=\"wp-block-code\"><code>create external table spectrum.sales(\r\nsalesid integer,\r\nlistid integer,\r\nsellerid integer,\r\nbuyerid integer,\r\neventid integer,\r\ndateid smallint,\r\nqtysold smallint,\r\npricepaid decimal(8,2),\r\ncommission decimal(8,2),\r\nsaletime timestamp)\r\nrow format delimited\r\nfields terminated by '\\t'\r\nstored as textfile\r\nlocation 's3:\/\/awssampledbuswest2\/tickit\/spectrum\/sales\/'\r\ntable properties ('numRows'='172000');<\/code><\/pre>\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>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/sqlflow.gudusoft.com\"><img decoding=\"async\" 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-200x67.png 200w, 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-400x134.png 400w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/data-lineage-redshift-create-external-table-600x201.png 600w, https:\/\/www.gudusoft.com\/wp-content\/uploads\/2022\/05\/data-lineage-redshift-create-external-table.png 644w\" sizes=\"(max-width: 644px) 100vw, 644px\" \/><\/a><figcaption>Redshift Create External Table Data Lineage<\/figcaption><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\">\uacb0\ub860\u00a0<\/h2>\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)<\/p>\n<\/div><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-0{width:100% !important;margin-top : 0px;margin-bottom : 0px;}.fusion-builder-column-0 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1024px) {.fusion-body .fusion-builder-column-0{width:100% !important;}.fusion-builder-column-0 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-0{width:100% !important;}.fusion-builder-column-0 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-1{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":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],"_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":49,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts\/3493\/revisions"}],"predecessor-version":[{"id":3898,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts\/3493\/revisions\/3898"}],"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}]}}