Schema Info

Schema Name: sfdl_stage_redshift.analytics_reference_dim_zip

created: 2018-05-09 10:27:31
disabled: False
format: raw
id: 517
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 906638

created: 2026-04-17 03:45:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_zip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_zip/2026-04-17/1776415494'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_zip"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_zip/2026-04-17/1776415494
id: 906638
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: 517
schema_scan_id: 6415218
updated: 2026-04-17 03:45:15

Version 906416

created: 2026-04-16 04:00:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_zip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_zip/2026-04-16/1776330010'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_zip"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_zip/2026-04-16/1776330010
id: 906416
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: 517
schema_scan_id: 6414666
updated: 2026-04-16 04:00:33

Version 906200

created: 2026-04-15 03:46:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_zip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_zip/2026-04-15/1776242799'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_zip"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_zip/2026-04-15/1776242799
id: 906200
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: 517
schema_scan_id: 6414176
updated: 2026-04-15 03:47:10

Version 905993

created: 2026-04-14 03:53:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_zip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_zip/2026-04-14/1776156807'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_zip"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_zip/2026-04-14/1776156807
id: 905993
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: 517
schema_scan_id: 6413679
updated: 2026-04-14 03:53:52

Version 905789

created: 2026-04-13 03:40:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_zip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_zip/2026-04-13/1776069631'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_zip"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_zip/2026-04-13/1776069631
id: 905789
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: 517
schema_scan_id: 6413145
updated: 2026-04-13 03:41:07

Version 905593

created: 2026-04-12 04:03:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_zip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_zip/2026-04-12/1775984575'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_zip"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_zip/2026-04-12/1775984575
id: 905593
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: 517
schema_scan_id: 6412757
updated: 2026-04-12 04:03:28

Version 905382

created: 2026-04-11 03:48:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_zip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_zip/2026-04-11/1775897293'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_zip"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_zip/2026-04-11/1775897293
id: 905382
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: 517
schema_scan_id: 6412367
updated: 2026-04-11 03:48:44

Version 905130

created: 2026-04-10 03:19:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_zip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_zip/2026-04-10/1775809144'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_zip"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_zip/2026-04-10/1775809144
id: 905130
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: 517
schema_scan_id: 6411834
updated: 2026-04-10 03:19:29

Version 904919

created: 2026-04-09 03:49:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_zip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_zip/2026-04-09/1775724558'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_zip"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_zip/2026-04-09/1775724558
id: 904919
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: 517
schema_scan_id: 6411321
updated: 2026-04-09 03:49:51

Version 904723

created: 2026-04-08 03:42:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_zip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_zip/2026-04-08/1775637740'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_zip"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_zip/2026-04-08/1775637740
id: 904723
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: 517
schema_scan_id: 6410845
updated: 2026-04-08 03:42:47

Version 904490

created: 2026-04-07 03:33:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_zip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_zip/2026-04-07/1775550768'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_zip"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_zip/2026-04-07/1775550768
id: 904490
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: 517
schema_scan_id: 6410313
updated: 2026-04-07 03:33:25

Version 904300

created: 2026-04-06 03:55:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_zip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_zip/2026-04-06/1775465715'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_zip"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_zip/2026-04-06/1775465715
id: 904300
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: 517
schema_scan_id: 6409794
updated: 2026-04-06 03:55:43

Version 904074

created: 2026-04-05 03:25:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_zip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_zip/2026-04-05/1775377531'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_zip"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_zip/2026-04-05/1775377531
id: 904074
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: 517
schema_scan_id: 6409381
updated: 2026-04-05 03:26:05

Version 903868

created: 2026-04-04 03:22:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_zip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_zip/2026-04-04/1775290943'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_zip"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_zip/2026-04-04/1775290943
id: 903868
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: 517
schema_scan_id: 6408997
updated: 2026-04-04 03:22:52

Version 903664

created: 2026-04-03 03:44:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_zip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_zip/2026-04-03/1775205808'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_zip"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_zip/2026-04-03/1775205808
id: 903664
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: 517
schema_scan_id: 6408518
updated: 2026-04-03 03:44:17

Schema Scans: 15

Last at 2026-04-17 03:45:03

Scan 6415218

duration: 0:00:11.707132

exit_message:

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

id: 6415218

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-stage",
            "key": "meta/reference_dim_zip/2026-04-17/1776415494/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_zip/2026-04-17/1776415494",
        "key": "raw/reference_dim_zip/2026-04-17/1776415494/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_zip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1675466117218678779,
        "service_name": "redshift_unloads",
        "span_id": 3617880182248950115,
        "trace_id": 5880119386509581181
    }
}

running: False
schema_name_id: 517
start_time: 2026-04-17 03:45:03
success: True
trace_id: 5880119386509581181

Scan 6414666

duration: 0:00:11.611884

exit_message:

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

id: 6414666

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-stage",
            "key": "meta/reference_dim_zip/2026-04-16/1776330010/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_zip/2026-04-16/1776330010",
        "key": "raw/reference_dim_zip/2026-04-16/1776330010/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_zip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9576090572726159681,
        "service_name": "redshift_unloads",
        "span_id": 7377129278763740362,
        "trace_id": 16485155320675845983
    }
}

running: False
schema_name_id: 517
start_time: 2026-04-16 04:00:21
success: True
trace_id: 16485155320675845983

Scan 6414176

duration: 0:00:14.094278

exit_message:

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

id: 6414176

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-stage",
            "key": "meta/reference_dim_zip/2026-04-15/1776242799/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_zip/2026-04-15/1776242799",
        "key": "raw/reference_dim_zip/2026-04-15/1776242799/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_zip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6125299890010212919,
        "service_name": "redshift_unloads",
        "span_id": 3488678707268605031,
        "trace_id": 4623279837403209664
    }
}

running: False
schema_name_id: 517
start_time: 2026-04-15 03:46:56
success: True
trace_id: 4623279837403209664

Scan 6413679

duration: 0:00:14.127014

exit_message:

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

id: 6413679

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-stage",
            "key": "meta/reference_dim_zip/2026-04-14/1776156807/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_zip/2026-04-14/1776156807",
        "key": "raw/reference_dim_zip/2026-04-14/1776156807/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_zip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13677902397399580439,
        "service_name": "redshift_unloads",
        "span_id": 12016661932723344650,
        "trace_id": 9824331854769484795
    }
}

running: False
schema_name_id: 517
start_time: 2026-04-14 03:53:38
success: True
trace_id: 9824331854769484795

Scan 6413145

duration: 0:00:14.206346

exit_message:

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

id: 6413145

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-stage",
            "key": "meta/reference_dim_zip/2026-04-13/1776069631/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_zip/2026-04-13/1776069631",
        "key": "raw/reference_dim_zip/2026-04-13/1776069631/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_zip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12516737880774294925,
        "service_name": "redshift_unloads",
        "span_id": 13053769077957095513,
        "trace_id": 5486777461641733847
    }
}

running: False
schema_name_id: 517
start_time: 2026-04-13 03:40:52
success: True
trace_id: 5486777461641733847

Scan 6412757

duration: 0:00:14.188695

exit_message:

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

id: 6412757

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-stage",
            "key": "meta/reference_dim_zip/2026-04-12/1775984575/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_zip/2026-04-12/1775984575",
        "key": "raw/reference_dim_zip/2026-04-12/1775984575/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_zip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8901153131935278102,
        "service_name": "redshift_unloads",
        "span_id": 14143521345395649365,
        "trace_id": 1346881649477800172
    }
}

running: False
schema_name_id: 517
start_time: 2026-04-12 04:03:14
success: True
trace_id: 1346881649477800172

Scan 6412367

duration: 0:00:11.599719

exit_message:

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

id: 6412367

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-stage",
            "key": "meta/reference_dim_zip/2026-04-11/1775897293/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_zip/2026-04-11/1775897293",
        "key": "raw/reference_dim_zip/2026-04-11/1775897293/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_zip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 186536309538483523,
        "service_name": "redshift_unloads",
        "span_id": 16315989322871733665,
        "trace_id": 6310044316750893794
    }
}

running: False
schema_name_id: 517
start_time: 2026-04-11 03:48:32
success: True
trace_id: 6310044316750893794

Scan 6411834

duration: 0:00:14.253375

exit_message:

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

id: 6411834

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-stage",
            "key": "meta/reference_dim_zip/2026-04-10/1775809144/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_zip/2026-04-10/1775809144",
        "key": "raw/reference_dim_zip/2026-04-10/1775809144/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_zip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13385118074770096637,
        "service_name": "redshift_unloads",
        "span_id": 18304407553419422111,
        "trace_id": 8607478460511907625
    }
}

running: False
schema_name_id: 517
start_time: 2026-04-10 03:19:15
success: True
trace_id: 8607478460511907625

Scan 6411321

duration: 0:00:14.246305

exit_message:

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

id: 6411321

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-stage",
            "key": "meta/reference_dim_zip/2026-04-09/1775724558/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_zip/2026-04-09/1775724558",
        "key": "raw/reference_dim_zip/2026-04-09/1775724558/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_zip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4612560789063358822,
        "service_name": "redshift_unloads",
        "span_id": 5994217855165418048,
        "trace_id": 16879352006177868097
    }
}

running: False
schema_name_id: 517
start_time: 2026-04-09 03:49:36
success: True
trace_id: 16879352006177868097

Scan 6410845

duration: 0:00:14.278025

exit_message:

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

id: 6410845

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-stage",
            "key": "meta/reference_dim_zip/2026-04-08/1775637740/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_zip/2026-04-08/1775637740",
        "key": "raw/reference_dim_zip/2026-04-08/1775637740/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_zip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10385304945439836180,
        "service_name": "redshift_unloads",
        "span_id": 5312061042760267630,
        "trace_id": 12032791079138906184
    }
}

running: False
schema_name_id: 517
start_time: 2026-04-08 03:42:33
success: True
trace_id: 12032791079138906184

Scan 6410313

duration: 0:00:11.830763

exit_message:

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

id: 6410313

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-stage",
            "key": "meta/reference_dim_zip/2026-04-07/1775550768/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_zip/2026-04-07/1775550768",
        "key": "raw/reference_dim_zip/2026-04-07/1775550768/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_zip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16365141735407579886,
        "service_name": "redshift_unloads",
        "span_id": 2352016171058226795,
        "trace_id": 13982666717848819303
    }
}

running: False
schema_name_id: 517
start_time: 2026-04-07 03:33:13
success: True
trace_id: 13982666717848819303

Scan 6409794

duration: 0:00:14.127711

exit_message:

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

id: 6409794

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-stage",
            "key": "meta/reference_dim_zip/2026-04-06/1775465715/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_zip/2026-04-06/1775465715",
        "key": "raw/reference_dim_zip/2026-04-06/1775465715/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_zip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15120872069330779736,
        "service_name": "redshift_unloads",
        "span_id": 1403255893827149318,
        "trace_id": 91767010124670623
    }
}

running: False
schema_name_id: 517
start_time: 2026-04-06 03:55:29
success: True
trace_id: 91767010124670623

Scan 6409381

duration: 0:00:14.214278

exit_message:

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

id: 6409381

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-stage",
            "key": "meta/reference_dim_zip/2026-04-05/1775377531/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_zip/2026-04-05/1775377531",
        "key": "raw/reference_dim_zip/2026-04-05/1775377531/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_zip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7567239834063986686,
        "service_name": "redshift_unloads",
        "span_id": 7907188454787558643,
        "trace_id": 6596181736395303942
    }
}

running: False
schema_name_id: 517
start_time: 2026-04-05 03:25:51
success: True
trace_id: 6596181736395303942

Scan 6408997

duration: 0:00:14.273979

exit_message:

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

id: 6408997

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-stage",
            "key": "meta/reference_dim_zip/2026-04-04/1775290943/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_zip/2026-04-04/1775290943",
        "key": "raw/reference_dim_zip/2026-04-04/1775290943/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_zip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4403026278248021452,
        "service_name": "redshift_unloads",
        "span_id": 6271245118178518668,
        "trace_id": 11765020314385068094
    }
}

running: False
schema_name_id: 517
start_time: 2026-04-04 03:22:38
success: True
trace_id: 11765020314385068094

Scan 6408518

duration: 0:00:14.099088

exit_message:

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

id: 6408518

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-stage",
            "key": "meta/reference_dim_zip/2026-04-03/1775205808/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_zip/2026-04-03/1775205808",
        "key": "raw/reference_dim_zip/2026-04-03/1775205808/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_zip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 18383721489958719635,
        "service_name": "redshift_unloads",
        "span_id": 9891268463935629464,
        "trace_id": 10445322812646558894
    }
}

running: False
schema_name_id: 517
start_time: 2026-04-03 03:44:03
success: True
trace_id: 10445322812646558894

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:45:04

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_zip/2026-04-17/1776415494'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_zip`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_zip"
}

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2018-05-09 10:27:31",
        "disabled": false,
        "format": "raw",
        "id": 517,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_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:45:04",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_zip/2026-04-17/1776415494'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_zip`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_zip"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}