Schema Info

Schema Name: sfdl_prod_redshift.analytics_reference_dim_zip

created: 2018-05-08 15:04:08
disabled: False
format: raw
id: 424
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_prod_redshift",
    "table": "analytics_reference_dim_zip"
}

type: redshift

Schema Versions: 15

Version 1717891

created: 2026-04-17 03:39:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_zip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_zip`\n(\n `zip_key`  varchar(5) , `msa`  varchar(150) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-17/1776415179'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_zip"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-17/1776415179
id: 1717891
processed: 1

raw_data:

{
    "_origin": "2",
    "msa": "1",
    "zip_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "msa": "varchar(150)",
    "zip_key": "varchar(5)"
}

schema_name_id: 424
schema_scan_id: 162168008
updated: 2026-04-17 03:40:06

Version 1716670

created: 2026-04-16 04:10:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_zip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_zip`\n(\n `zip_key`  varchar(5) , `msa`  varchar(150) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-16/1776330595'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_zip"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-16/1776330595
id: 1716670
processed: 1

raw_data:

{
    "_origin": "2",
    "msa": "1",
    "zip_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "msa": "varchar(150)",
    "zip_key": "varchar(5)"
}

schema_name_id: 424
schema_scan_id: 162113327
updated: 2026-04-16 04:10:19

Version 1715581

created: 2026-04-15 04:01:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_zip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_zip`\n(\n `zip_key`  varchar(5) , `msa`  varchar(150) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-15/1776243675'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_zip"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-15/1776243675
id: 1715581
processed: 1

raw_data:

{
    "_origin": "2",
    "msa": "1",
    "zip_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "msa": "varchar(150)",
    "zip_key": "varchar(5)"
}

schema_name_id: 424
schema_scan_id: 162057555
updated: 2026-04-15 04:02:09

Version 1714266

created: 2026-04-14 03:58:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_zip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_zip`\n(\n `zip_key`  varchar(5) , `msa`  varchar(150) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-14/1776157065'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_zip"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-14/1776157065
id: 1714266
processed: 1

raw_data:

{
    "_origin": "2",
    "msa": "1",
    "zip_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "msa": "varchar(150)",
    "zip_key": "varchar(5)"
}

schema_name_id: 424
schema_scan_id: 162001399
updated: 2026-04-14 03:58:31

Version 1713010

created: 2026-04-13 03:45:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_zip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_zip`\n(\n `zip_key`  varchar(5) , `msa`  varchar(150) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-13/1776069911'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_zip"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-13/1776069911
id: 1713010
processed: 1

raw_data:

{
    "_origin": "2",
    "msa": "1",
    "zip_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "msa": "varchar(150)",
    "zip_key": "varchar(5)"
}

schema_name_id: 424
schema_scan_id: 161942957
updated: 2026-04-13 03:45:29

Version 1711852

created: 2026-04-12 03:57:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_zip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_zip`\n(\n `zip_key`  varchar(5) , `msa`  varchar(150) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-12/1775984152'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_zip"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-12/1775984152
id: 1711852
processed: 1

raw_data:

{
    "_origin": "2",
    "msa": "1",
    "zip_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "msa": "varchar(150)",
    "zip_key": "varchar(5)"
}

schema_name_id: 424
schema_scan_id: 161894001
updated: 2026-04-12 03:57:11

Version 1710607

created: 2026-04-11 03:40:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_zip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_zip`\n(\n `zip_key`  varchar(5) , `msa`  varchar(150) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-11/1775896814'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_zip"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-11/1775896814
id: 1710607
processed: 1

raw_data:

{
    "_origin": "2",
    "msa": "1",
    "zip_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "msa": "varchar(150)",
    "zip_key": "varchar(5)"
}

schema_name_id: 424
schema_scan_id: 161841442
updated: 2026-04-11 03:40:43

Version 1709490

created: 2026-04-10 04:06:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_zip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_zip`\n(\n `zip_key`  varchar(5) , `msa`  varchar(150) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-10/1775811985'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_zip"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-10/1775811985
id: 1709490
processed: 1

raw_data:

{
    "_origin": "2",
    "msa": "1",
    "zip_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "msa": "varchar(150)",
    "zip_key": "varchar(5)"
}

schema_name_id: 424
schema_scan_id: 161787379
updated: 2026-04-10 04:06:47

Version 1708334

created: 2026-04-09 03:46:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_zip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_zip`\n(\n `zip_key`  varchar(5) , `msa`  varchar(150) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-09/1775724369'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_zip"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-09/1775724369
id: 1708334
processed: 1

raw_data:

{
    "_origin": "2",
    "msa": "1",
    "zip_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "msa": "varchar(150)",
    "zip_key": "varchar(5)"
}

schema_name_id: 424
schema_scan_id: 161730697
updated: 2026-04-09 03:46:39

Version 1707088

created: 2026-04-08 03:21:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_zip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_zip`\n(\n `zip_key`  varchar(5) , `msa`  varchar(150) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-08/1775636435'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_zip"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-08/1775636435
id: 1707088
processed: 1

raw_data:

{
    "_origin": "2",
    "msa": "1",
    "zip_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "msa": "varchar(150)",
    "zip_key": "varchar(5)"
}

schema_name_id: 424
schema_scan_id: 161675785
updated: 2026-04-08 03:21:14

Version 1705909

created: 2026-04-07 03:32:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_zip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_zip`\n(\n `zip_key`  varchar(5) , `msa`  varchar(150) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-07/1775550719'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_zip"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-07/1775550719
id: 1705909
processed: 1

raw_data:

{
    "_origin": "2",
    "msa": "1",
    "zip_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "msa": "varchar(150)",
    "zip_key": "varchar(5)"
}

schema_name_id: 424
schema_scan_id: 161619674
updated: 2026-04-07 03:32:20

Version 1704735

created: 2026-04-06 04:02:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_zip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_zip`\n(\n `zip_key`  varchar(5) , `msa`  varchar(150) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-06/1775466116'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_zip"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-06/1775466116
id: 1704735
processed: 1

raw_data:

{
    "_origin": "2",
    "msa": "1",
    "zip_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "msa": "varchar(150)",
    "zip_key": "varchar(5)"
}

schema_name_id: 424
schema_scan_id: 161562941
updated: 2026-04-06 04:02:24

Version 1703509

created: 2026-04-05 03:58:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_zip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_zip`\n(\n `zip_key`  varchar(5) , `msa`  varchar(150) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-05/1775379450'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_zip"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-05/1775379450
id: 1703509
processed: 1

raw_data:

{
    "_origin": "2",
    "msa": "1",
    "zip_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "msa": "varchar(150)",
    "zip_key": "varchar(5)"
}

schema_name_id: 424
schema_scan_id: 161515787
updated: 2026-04-05 03:58:30

Version 1702310

created: 2026-04-04 03:24:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_zip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_zip`\n(\n `zip_key`  varchar(5) , `msa`  varchar(150) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-04/1775291053'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_zip"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-04/1775291053
id: 1702310
processed: 1

raw_data:

{
    "_origin": "2",
    "msa": "1",
    "zip_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "msa": "varchar(150)",
    "zip_key": "varchar(5)"
}

schema_name_id: 424
schema_scan_id: 161460669
updated: 2026-04-04 03:24:32

Version 1701114

created: 2026-04-03 03:33:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_zip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_zip`\n(\n `zip_key`  varchar(5) , `msa`  varchar(150) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-03/1775205211'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_zip"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-03/1775205211
id: 1701114
processed: 1

raw_data:

{
    "_origin": "2",
    "msa": "1",
    "zip_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "msa": "varchar(150)",
    "zip_key": "varchar(5)"
}

schema_name_id: 424
schema_scan_id: 161402139
updated: 2026-04-03 03:33:54

Schema Scans: 15

Last at 2026-04-17 03:39:52

Scan 162168008

duration: 0:00:14.067920

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162168008

payload:

{
    "datatype_dict": {
        "msa": "varchar(150)",
        "origin_key": "varchar",
        "zip_key": "varchar(5)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_zip/2026-04-17/1776415179/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-17/1776415179",
        "key": "raw/reference_dim_zip/2026-04-17/1776415179/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_zip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10993398839946255447,
        "service_name": "redshift_unloads",
        "span_id": 12301869429643500529,
        "trace_id": 6673274836406461594
    }
}

running: False
schema_name_id: 424
start_time: 2026-04-17 03:39:52
success: True
trace_id: 6673274836406461594

Scan 162113327

duration: 0:00:14.150224

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162113327

payload:

{
    "datatype_dict": {
        "msa": "varchar(150)",
        "origin_key": "varchar",
        "zip_key": "varchar(5)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_zip/2026-04-16/1776330595/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-16/1776330595",
        "key": "raw/reference_dim_zip/2026-04-16/1776330595/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_zip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10051205217298359244,
        "service_name": "redshift_unloads",
        "span_id": 1398978472560047779,
        "trace_id": 1264531138935118859
    }
}

running: False
schema_name_id: 424
start_time: 2026-04-16 04:10:05
success: True
trace_id: 1264531138935118859

Scan 162057555

duration: 0:00:14.153755

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162057555

payload:

{
    "datatype_dict": {
        "msa": "varchar(150)",
        "origin_key": "varchar",
        "zip_key": "varchar(5)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_zip/2026-04-15/1776243675/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-15/1776243675",
        "key": "raw/reference_dim_zip/2026-04-15/1776243675/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_zip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1806682888011629149,
        "service_name": "redshift_unloads",
        "span_id": 9256101945654662549,
        "trace_id": 18071808067493498775
    }
}

running: False
schema_name_id: 424
start_time: 2026-04-15 04:01:55
success: True
trace_id: 18071808067493498775

Scan 162001399

duration: 0:00:11.571987

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162001399

payload:

{
    "datatype_dict": {
        "msa": "varchar(150)",
        "origin_key": "varchar",
        "zip_key": "varchar(5)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_zip/2026-04-14/1776157065/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-14/1776157065",
        "key": "raw/reference_dim_zip/2026-04-14/1776157065/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_zip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10733762262390485111,
        "service_name": "redshift_unloads",
        "span_id": 16986349131648818677,
        "trace_id": 5143824140341704427
    }
}

running: False
schema_name_id: 424
start_time: 2026-04-14 03:58:20
success: True
trace_id: 5143824140341704427

Scan 161942957

duration: 0:00:11.593172

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161942957

payload:

{
    "datatype_dict": {
        "msa": "varchar(150)",
        "origin_key": "varchar",
        "zip_key": "varchar(5)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_zip/2026-04-13/1776069911/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-13/1776069911",
        "key": "raw/reference_dim_zip/2026-04-13/1776069911/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_zip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1221054438963682955,
        "service_name": "redshift_unloads",
        "span_id": 10544360611905926478,
        "trace_id": 11405950707130312316
    }
}

running: False
schema_name_id: 424
start_time: 2026-04-13 03:45:18
success: True
trace_id: 11405950707130312316

Scan 161894001

duration: 0:00:11.582647

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161894001

payload:

{
    "datatype_dict": {
        "msa": "varchar(150)",
        "origin_key": "varchar",
        "zip_key": "varchar(5)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_zip/2026-04-12/1775984152/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-12/1775984152",
        "key": "raw/reference_dim_zip/2026-04-12/1775984152/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_zip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1048657950365178003,
        "service_name": "redshift_unloads",
        "span_id": 7414158690014527673,
        "trace_id": 13563076004658775716
    }
}

running: False
schema_name_id: 424
start_time: 2026-04-12 03:57:00
success: True
trace_id: 13563076004658775716

Scan 161841442

duration: 0:00:14.051337

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161841442

payload:

{
    "datatype_dict": {
        "msa": "varchar(150)",
        "origin_key": "varchar",
        "zip_key": "varchar(5)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_zip/2026-04-11/1775896814/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-11/1775896814",
        "key": "raw/reference_dim_zip/2026-04-11/1775896814/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_zip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10034570500237527677,
        "service_name": "redshift_unloads",
        "span_id": 13850126102858976367,
        "trace_id": 9041497646656281582
    }
}

running: False
schema_name_id: 424
start_time: 2026-04-11 03:40:29
success: True
trace_id: 9041497646656281582

Scan 161787379

duration: 0:00:14.130187

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161787379

payload:

{
    "datatype_dict": {
        "msa": "varchar(150)",
        "origin_key": "varchar",
        "zip_key": "varchar(5)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_zip/2026-04-10/1775811985/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-10/1775811985",
        "key": "raw/reference_dim_zip/2026-04-10/1775811985/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_zip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1157166354599970396,
        "service_name": "redshift_unloads",
        "span_id": 9116428876791161667,
        "trace_id": 6215233474244500985
    }
}

running: False
schema_name_id: 424
start_time: 2026-04-10 04:06:33
success: True
trace_id: 6215233474244500985

Scan 161730697

duration: 0:00:14.124104

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161730697

payload:

{
    "datatype_dict": {
        "msa": "varchar(150)",
        "origin_key": "varchar",
        "zip_key": "varchar(5)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_zip/2026-04-09/1775724369/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-09/1775724369",
        "key": "raw/reference_dim_zip/2026-04-09/1775724369/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_zip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 122357065474249162,
        "service_name": "redshift_unloads",
        "span_id": 15098433303580538830,
        "trace_id": 14102243539339374283
    }
}

running: False
schema_name_id: 424
start_time: 2026-04-09 03:46:24
success: True
trace_id: 14102243539339374283

Scan 161675785

duration: 0:00:14.146343

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161675785

payload:

{
    "datatype_dict": {
        "msa": "varchar(150)",
        "origin_key": "varchar",
        "zip_key": "varchar(5)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_zip/2026-04-08/1775636435/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-08/1775636435",
        "key": "raw/reference_dim_zip/2026-04-08/1775636435/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_zip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4489450470977347671,
        "service_name": "redshift_unloads",
        "span_id": 9378153307210139042,
        "trace_id": 14080375651893712435
    }
}

running: False
schema_name_id: 424
start_time: 2026-04-08 03:20:59
success: True
trace_id: 14080375651893712435

Scan 161619674

duration: 0:00:14.097881

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161619674

payload:

{
    "datatype_dict": {
        "msa": "varchar(150)",
        "origin_key": "varchar",
        "zip_key": "varchar(5)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_zip/2026-04-07/1775550719/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-07/1775550719",
        "key": "raw/reference_dim_zip/2026-04-07/1775550719/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_zip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17391974874947718151,
        "service_name": "redshift_unloads",
        "span_id": 1224373792854307676,
        "trace_id": 9545992526276720695
    }
}

running: False
schema_name_id: 424
start_time: 2026-04-07 03:32:06
success: True
trace_id: 9545992526276720695

Scan 161562941

duration: 0:00:14.109526

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161562941

payload:

{
    "datatype_dict": {
        "msa": "varchar(150)",
        "origin_key": "varchar",
        "zip_key": "varchar(5)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_zip/2026-04-06/1775466116/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-06/1775466116",
        "key": "raw/reference_dim_zip/2026-04-06/1775466116/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_zip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15211826349460081447,
        "service_name": "redshift_unloads",
        "span_id": 2443510267465145471,
        "trace_id": 14880956020920031871
    }
}

running: False
schema_name_id: 424
start_time: 2026-04-06 04:02:10
success: True
trace_id: 14880956020920031871

Scan 161515787

duration: 0:00:11.621854

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161515787

payload:

{
    "datatype_dict": {
        "msa": "varchar(150)",
        "origin_key": "varchar",
        "zip_key": "varchar(5)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_zip/2026-04-05/1775379450/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-05/1775379450",
        "key": "raw/reference_dim_zip/2026-04-05/1775379450/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_zip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16292545373736359685,
        "service_name": "redshift_unloads",
        "span_id": 13527835206560581742,
        "trace_id": 438817237658769935
    }
}

running: False
schema_name_id: 424
start_time: 2026-04-05 03:58:18
success: True
trace_id: 438817237658769935

Scan 161460669

duration: 0:00:11.742317

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161460669

payload:

{
    "datatype_dict": {
        "msa": "varchar(150)",
        "origin_key": "varchar",
        "zip_key": "varchar(5)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_zip/2026-04-04/1775291053/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-04/1775291053",
        "key": "raw/reference_dim_zip/2026-04-04/1775291053/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_zip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14303104498470165111,
        "service_name": "redshift_unloads",
        "span_id": 5415052357147778103,
        "trace_id": 9151832082599500857
    }
}

running: False
schema_name_id: 424
start_time: 2026-04-04 03:24:20
success: True
trace_id: 9151832082599500857

Scan 161402139

duration: 0:00:14.091873

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161402139

payload:

{
    "datatype_dict": {
        "msa": "varchar(150)",
        "origin_key": "varchar",
        "zip_key": "varchar(5)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_zip/2026-04-03/1775205211/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-03/1775205211",
        "key": "raw/reference_dim_zip/2026-04-03/1775205211/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_zip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16849862177606053403,
        "service_name": "redshift_unloads",
        "span_id": 16312044809022234443,
        "trace_id": 2178298815016365667
    }
}

running: False
schema_name_id: 424
start_time: 2026-04-03 03:33:40
success: True
trace_id: 2178298815016365667

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "_origin": "string",
    "msa": "varchar(150)",
    "zip_key": "varchar(5)"
}

created: 2026-04-17 03:39:53

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_zip`\n(\n `zip_key`  varchar(5) , `msa`  varchar(150) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-17/1776415179'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_zip`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_zip"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2018-05-08 15:04:08",
        "disabled": false,
        "format": "raw",
        "id": 424,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_redshift",
            "table": "analytics_reference_dim_zip"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "msa": "varchar(150)",
            "zip_key": "varchar(5)"
        },
        "created": "2026-04-17 03:39:53",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_zip`\n(\n `zip_key`  varchar(5) , `msa`  varchar(150) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_zip/2026-04-17/1776415179'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_zip`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_zip"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}