Schema Info

Schema Name: sfdl_prod_redshift.analytics_dwh_dim_uplid

created: 2018-11-19 15:31:02
disabled: False
format: raw
id: 578
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 1717855

created: 2026-04-17 03:19:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_uplid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_uplid`\n(\n `audit_id`  bigint , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `zip`  varchar(7) , `matched`  int , `match_info`  varchar(50) , `deprecated`  int , `duplicate_of`  int , `created_at`  timestamp , `updated_at`  timestamp , `_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/dwh_dim_uplid/2026-04-17/1776413944'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_uplid"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_uplid/2026-04-17/1776413944
id: 1717855
processed: 1

raw_data:

{
    "_origin": "13",
    "audit_id": "0",
    "city": "4",
    "created_at": "11",
    "deprecated": "9",
    "duplicate_of": "10",
    "match_info": "8",
    "matched": "7",
    "state": "5",
    "street_address_1": "2",
    "street_address_2": "3",
    "updated_at": "12",
    "uplid_key": "1",
    "zip": "6"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "deprecated": "int",
    "duplicate_of": "int",
    "match_info": "varchar(50)",
    "matched": "int",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_key": "int",
    "zip": "varchar(7)"
}

schema_name_id: 578
schema_scan_id: 162167901
updated: 2026-04-17 03:19:43

Version 1716652

created: 2026-04-16 04:06:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_uplid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_uplid`\n(\n `audit_id`  bigint , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `zip`  varchar(7) , `matched`  int , `match_info`  varchar(50) , `deprecated`  int , `duplicate_of`  int , `created_at`  timestamp , `updated_at`  timestamp , `_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/dwh_dim_uplid/2026-04-16/1776330396'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_uplid"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_uplid/2026-04-16/1776330396
id: 1716652
processed: 1

raw_data:

{
    "_origin": "13",
    "audit_id": "0",
    "city": "4",
    "created_at": "11",
    "deprecated": "9",
    "duplicate_of": "10",
    "match_info": "8",
    "matched": "7",
    "state": "5",
    "street_address_1": "2",
    "street_address_2": "3",
    "updated_at": "12",
    "uplid_key": "1",
    "zip": "6"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "deprecated": "int",
    "duplicate_of": "int",
    "match_info": "varchar(50)",
    "matched": "int",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_key": "int",
    "zip": "varchar(7)"
}

schema_name_id: 578
schema_scan_id: 162113304
updated: 2026-04-16 04:07:04

Version 1715423

created: 2026-04-15 03:32:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_uplid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_uplid`\n(\n `audit_id`  bigint , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `zip`  varchar(7) , `matched`  int , `match_info`  varchar(50) , `deprecated`  int , `duplicate_of`  int , `created_at`  timestamp , `updated_at`  timestamp , `_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/dwh_dim_uplid/2026-04-15/1776241946'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_uplid"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_uplid/2026-04-15/1776241946
id: 1715423
processed: 1

raw_data:

{
    "_origin": "13",
    "audit_id": "0",
    "city": "4",
    "created_at": "11",
    "deprecated": "9",
    "duplicate_of": "10",
    "match_info": "8",
    "matched": "7",
    "state": "5",
    "street_address_1": "2",
    "street_address_2": "3",
    "updated_at": "12",
    "uplid_key": "1",
    "zip": "6"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "deprecated": "int",
    "duplicate_of": "int",
    "match_info": "varchar(50)",
    "matched": "int",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_key": "int",
    "zip": "varchar(7)"
}

schema_name_id: 578
schema_scan_id: 162056273
updated: 2026-04-15 03:32:47

Version 1714279

created: 2026-04-14 04:02:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_uplid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_uplid`\n(\n `audit_id`  bigint , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `zip`  varchar(7) , `matched`  int , `match_info`  varchar(50) , `deprecated`  int , `duplicate_of`  int , `created_at`  timestamp , `updated_at`  timestamp , `_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/dwh_dim_uplid/2026-04-14/1776157353'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_uplid"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_uplid/2026-04-14/1776157353
id: 1714279
processed: 1

raw_data:

{
    "_origin": "13",
    "audit_id": "0",
    "city": "4",
    "created_at": "11",
    "deprecated": "9",
    "duplicate_of": "10",
    "match_info": "8",
    "matched": "7",
    "state": "5",
    "street_address_1": "2",
    "street_address_2": "3",
    "updated_at": "12",
    "uplid_key": "1",
    "zip": "6"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "deprecated": "int",
    "duplicate_of": "int",
    "match_info": "varchar(50)",
    "matched": "int",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_key": "int",
    "zip": "varchar(7)"
}

schema_name_id: 578
schema_scan_id: 162001916
updated: 2026-04-14 04:03:02

Version 1713006

created: 2026-04-13 03:39:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_uplid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_uplid`\n(\n `audit_id`  bigint , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `zip`  varchar(7) , `matched`  int , `match_info`  varchar(50) , `deprecated`  int , `duplicate_of`  int , `created_at`  timestamp , `updated_at`  timestamp , `_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/dwh_dim_uplid/2026-04-13/1776069565'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_uplid"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_uplid/2026-04-13/1776069565
id: 1713006
processed: 1

raw_data:

{
    "_origin": "13",
    "audit_id": "0",
    "city": "4",
    "created_at": "11",
    "deprecated": "9",
    "duplicate_of": "10",
    "match_info": "8",
    "matched": "7",
    "state": "5",
    "street_address_1": "2",
    "street_address_2": "3",
    "updated_at": "12",
    "uplid_key": "1",
    "zip": "6"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "deprecated": "int",
    "duplicate_of": "int",
    "match_info": "varchar(50)",
    "matched": "int",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_key": "int",
    "zip": "varchar(7)"
}

schema_name_id: 578
schema_scan_id: 161942941
updated: 2026-04-13 03:39:48

Version 1711843

created: 2026-04-12 03:55:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_uplid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_uplid`\n(\n `audit_id`  bigint , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `zip`  varchar(7) , `matched`  int , `match_info`  varchar(50) , `deprecated`  int , `duplicate_of`  int , `created_at`  timestamp , `updated_at`  timestamp , `_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/dwh_dim_uplid/2026-04-12/1775984131'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_uplid"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_uplid/2026-04-12/1775984131
id: 1711843
processed: 1

raw_data:

{
    "_origin": "13",
    "audit_id": "0",
    "city": "4",
    "created_at": "11",
    "deprecated": "9",
    "duplicate_of": "10",
    "match_info": "8",
    "matched": "7",
    "state": "5",
    "street_address_1": "2",
    "street_address_2": "3",
    "updated_at": "12",
    "uplid_key": "1",
    "zip": "6"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "deprecated": "int",
    "duplicate_of": "int",
    "match_info": "varchar(50)",
    "matched": "int",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_key": "int",
    "zip": "varchar(7)"
}

schema_name_id: 578
schema_scan_id: 161893841
updated: 2026-04-12 03:56:04

Version 1710635

created: 2026-04-11 03:57:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_uplid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_uplid`\n(\n `audit_id`  bigint , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `zip`  varchar(7) , `matched`  int , `match_info`  varchar(50) , `deprecated`  int , `duplicate_of`  int , `created_at`  timestamp , `updated_at`  timestamp , `_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/dwh_dim_uplid/2026-04-11/1775897797'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_uplid"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_uplid/2026-04-11/1775897797
id: 1710635
processed: 1

raw_data:

{
    "_origin": "13",
    "audit_id": "0",
    "city": "4",
    "created_at": "11",
    "deprecated": "9",
    "duplicate_of": "10",
    "match_info": "8",
    "matched": "7",
    "state": "5",
    "street_address_1": "2",
    "street_address_2": "3",
    "updated_at": "12",
    "uplid_key": "1",
    "zip": "6"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "deprecated": "int",
    "duplicate_of": "int",
    "match_info": "varchar(50)",
    "matched": "int",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_key": "int",
    "zip": "varchar(7)"
}

schema_name_id: 578
schema_scan_id: 161841864
updated: 2026-04-11 03:57:16

Version 1709458

created: 2026-04-10 03:57:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_uplid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_uplid`\n(\n `audit_id`  bigint , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `zip`  varchar(7) , `matched`  int , `match_info`  varchar(50) , `deprecated`  int , `duplicate_of`  int , `created_at`  timestamp , `updated_at`  timestamp , `_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/dwh_dim_uplid/2026-04-10/1775811383'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_uplid"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_uplid/2026-04-10/1775811383
id: 1709458
processed: 1

raw_data:

{
    "_origin": "13",
    "audit_id": "0",
    "city": "4",
    "created_at": "11",
    "deprecated": "9",
    "duplicate_of": "10",
    "match_info": "8",
    "matched": "7",
    "state": "5",
    "street_address_1": "2",
    "street_address_2": "3",
    "updated_at": "12",
    "uplid_key": "1",
    "zip": "6"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "deprecated": "int",
    "duplicate_of": "int",
    "match_info": "varchar(50)",
    "matched": "int",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_key": "int",
    "zip": "varchar(7)"
}

schema_name_id: 578
schema_scan_id: 161786659
updated: 2026-04-10 03:57:40

Version 1708305

created: 2026-04-09 03:29:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_uplid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_uplid`\n(\n `audit_id`  bigint , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `zip`  varchar(7) , `matched`  int , `match_info`  varchar(50) , `deprecated`  int , `duplicate_of`  int , `created_at`  timestamp , `updated_at`  timestamp , `_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/dwh_dim_uplid/2026-04-09/1775723360'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_uplid"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_uplid/2026-04-09/1775723360
id: 1708305
processed: 1

raw_data:

{
    "_origin": "13",
    "audit_id": "0",
    "city": "4",
    "created_at": "11",
    "deprecated": "9",
    "duplicate_of": "10",
    "match_info": "8",
    "matched": "7",
    "state": "5",
    "street_address_1": "2",
    "street_address_2": "3",
    "updated_at": "12",
    "uplid_key": "1",
    "zip": "6"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "deprecated": "int",
    "duplicate_of": "int",
    "match_info": "varchar(50)",
    "matched": "int",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_key": "int",
    "zip": "varchar(7)"
}

schema_name_id: 578
schema_scan_id: 161730623
updated: 2026-04-09 03:29:44

Version 1707134

created: 2026-04-08 04:01:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_uplid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_uplid`\n(\n `audit_id`  bigint , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `zip`  varchar(7) , `matched`  int , `match_info`  varchar(50) , `deprecated`  int , `duplicate_of`  int , `created_at`  timestamp , `updated_at`  timestamp , `_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/dwh_dim_uplid/2026-04-08/1775638826'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_uplid"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_uplid/2026-04-08/1775638826
id: 1707134
processed: 1

raw_data:

{
    "_origin": "13",
    "audit_id": "0",
    "city": "4",
    "created_at": "11",
    "deprecated": "9",
    "duplicate_of": "10",
    "match_info": "8",
    "matched": "7",
    "state": "5",
    "street_address_1": "2",
    "street_address_2": "3",
    "updated_at": "12",
    "uplid_key": "1",
    "zip": "6"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "deprecated": "int",
    "duplicate_of": "int",
    "match_info": "varchar(50)",
    "matched": "int",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_key": "int",
    "zip": "varchar(7)"
}

schema_name_id: 578
schema_scan_id: 161676862
updated: 2026-04-08 04:01:56

Version 1705936

created: 2026-04-07 03:50:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_uplid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_uplid`\n(\n `audit_id`  bigint , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `zip`  varchar(7) , `matched`  int , `match_info`  varchar(50) , `deprecated`  int , `duplicate_of`  int , `created_at`  timestamp , `updated_at`  timestamp , `_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/dwh_dim_uplid/2026-04-07/1775551798'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_uplid"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_uplid/2026-04-07/1775551798
id: 1705936
processed: 1

raw_data:

{
    "_origin": "13",
    "audit_id": "0",
    "city": "4",
    "created_at": "11",
    "deprecated": "9",
    "duplicate_of": "10",
    "match_info": "8",
    "matched": "7",
    "state": "5",
    "street_address_1": "2",
    "street_address_2": "3",
    "updated_at": "12",
    "uplid_key": "1",
    "zip": "6"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "deprecated": "int",
    "duplicate_of": "int",
    "match_info": "varchar(50)",
    "matched": "int",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_key": "int",
    "zip": "varchar(7)"
}

schema_name_id: 578
schema_scan_id: 161619806
updated: 2026-04-07 03:50:21

Version 1704727

created: 2026-04-06 04:01:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_uplid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_uplid`\n(\n `audit_id`  bigint , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `zip`  varchar(7) , `matched`  int , `match_info`  varchar(50) , `deprecated`  int , `duplicate_of`  int , `created_at`  timestamp , `updated_at`  timestamp , `_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/dwh_dim_uplid/2026-04-06/1775466073'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_uplid"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_uplid/2026-04-06/1775466073
id: 1704727
processed: 1

raw_data:

{
    "_origin": "13",
    "audit_id": "0",
    "city": "4",
    "created_at": "11",
    "deprecated": "9",
    "duplicate_of": "10",
    "match_info": "8",
    "matched": "7",
    "state": "5",
    "street_address_1": "2",
    "street_address_2": "3",
    "updated_at": "12",
    "uplid_key": "1",
    "zip": "6"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "deprecated": "int",
    "duplicate_of": "int",
    "match_info": "varchar(50)",
    "matched": "int",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_key": "int",
    "zip": "varchar(7)"
}

schema_name_id: 578
schema_scan_id: 161562918
updated: 2026-04-06 04:01:50

Version 1703494

created: 2026-04-05 03:49:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_uplid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_uplid`\n(\n `audit_id`  bigint , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `zip`  varchar(7) , `matched`  int , `match_info`  varchar(50) , `deprecated`  int , `duplicate_of`  int , `created_at`  timestamp , `updated_at`  timestamp , `_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/dwh_dim_uplid/2026-04-05/1775378940'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_uplid"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_uplid/2026-04-05/1775378940
id: 1703494
processed: 1

raw_data:

{
    "_origin": "13",
    "audit_id": "0",
    "city": "4",
    "created_at": "11",
    "deprecated": "9",
    "duplicate_of": "10",
    "match_info": "8",
    "matched": "7",
    "state": "5",
    "street_address_1": "2",
    "street_address_2": "3",
    "updated_at": "12",
    "uplid_key": "1",
    "zip": "6"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "deprecated": "int",
    "duplicate_of": "int",
    "match_info": "varchar(50)",
    "matched": "int",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_key": "int",
    "zip": "varchar(7)"
}

schema_name_id: 578
schema_scan_id: 161515149
updated: 2026-04-05 03:49:26

Version 1702369

created: 2026-04-04 04:02:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_uplid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_uplid`\n(\n `audit_id`  bigint , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `zip`  varchar(7) , `matched`  int , `match_info`  varchar(50) , `deprecated`  int , `duplicate_of`  int , `created_at`  timestamp , `updated_at`  timestamp , `_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/dwh_dim_uplid/2026-04-04/1775293363'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_uplid"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_uplid/2026-04-04/1775293363
id: 1702369
processed: 1

raw_data:

{
    "_origin": "13",
    "audit_id": "0",
    "city": "4",
    "created_at": "11",
    "deprecated": "9",
    "duplicate_of": "10",
    "match_info": "8",
    "matched": "7",
    "state": "5",
    "street_address_1": "2",
    "street_address_2": "3",
    "updated_at": "12",
    "uplid_key": "1",
    "zip": "6"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "deprecated": "int",
    "duplicate_of": "int",
    "match_info": "varchar(50)",
    "matched": "int",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_key": "int",
    "zip": "varchar(7)"
}

schema_name_id: 578
schema_scan_id: 161461934
updated: 2026-04-04 04:03:09

Version 1701135

created: 2026-04-03 03:35:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_uplid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_uplid`\n(\n `audit_id`  bigint , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `zip`  varchar(7) , `matched`  int , `match_info`  varchar(50) , `deprecated`  int , `duplicate_of`  int , `created_at`  timestamp , `updated_at`  timestamp , `_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/dwh_dim_uplid/2026-04-03/1775205319'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_uplid"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_uplid/2026-04-03/1775205319
id: 1701135
processed: 1

raw_data:

{
    "_origin": "13",
    "audit_id": "0",
    "city": "4",
    "created_at": "11",
    "deprecated": "9",
    "duplicate_of": "10",
    "match_info": "8",
    "matched": "7",
    "state": "5",
    "street_address_1": "2",
    "street_address_2": "3",
    "updated_at": "12",
    "uplid_key": "1",
    "zip": "6"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "deprecated": "int",
    "duplicate_of": "int",
    "match_info": "varchar(50)",
    "matched": "int",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_key": "int",
    "zip": "varchar(7)"
}

schema_name_id: 578
schema_scan_id: 161402162
updated: 2026-04-03 03:35:41

Schema Scans: 15

Last at 2026-04-17 03:19:31

Scan 162167901

duration: 0:00:11.877907

exit_message:

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

id: 162167901

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(255)",
        "created_at": "timestamp",
        "deprecated": "int",
        "duplicate_of": "int",
        "match_info": "varchar(50)",
        "matched": "int",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address_1": "varchar(255)",
        "street_address_2": "varchar(255)",
        "updated_at": "timestamp",
        "uplid_key": "int",
        "zip": "varchar(7)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_uplid/2026-04-17/1776413944/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_uplid/2026-04-17/1776413944",
        "key": "raw/dwh_dim_uplid/2026-04-17/1776413944/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_uplid",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15060947182689799911,
        "service_name": "redshift_unloads",
        "span_id": 3751202298621656202,
        "trace_id": 17601118045558289325
    }
}

running: False
schema_name_id: 578
start_time: 2026-04-17 03:19:31
success: True
trace_id: 17601118045558289325

Scan 162113304

duration: 0:00:12.258750

exit_message:

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

id: 162113304

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(255)",
        "created_at": "timestamp",
        "deprecated": "int",
        "duplicate_of": "int",
        "match_info": "varchar(50)",
        "matched": "int",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address_1": "varchar(255)",
        "street_address_2": "varchar(255)",
        "updated_at": "timestamp",
        "uplid_key": "int",
        "zip": "varchar(7)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_uplid/2026-04-16/1776330396/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_uplid/2026-04-16/1776330396",
        "key": "raw/dwh_dim_uplid/2026-04-16/1776330396/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_uplid",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3170278539803000747,
        "service_name": "redshift_unloads",
        "span_id": 1353169693339460606,
        "trace_id": 16618288074757175095
    }
}

running: False
schema_name_id: 578
start_time: 2026-04-16 04:06:52
success: True
trace_id: 16618288074757175095

Scan 162056273

duration: 0:00:11.805911

exit_message:

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

id: 162056273

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(255)",
        "created_at": "timestamp",
        "deprecated": "int",
        "duplicate_of": "int",
        "match_info": "varchar(50)",
        "matched": "int",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address_1": "varchar(255)",
        "street_address_2": "varchar(255)",
        "updated_at": "timestamp",
        "uplid_key": "int",
        "zip": "varchar(7)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_uplid/2026-04-15/1776241946/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_uplid/2026-04-15/1776241946",
        "key": "raw/dwh_dim_uplid/2026-04-15/1776241946/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_uplid",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3789941082515770224,
        "service_name": "redshift_unloads",
        "span_id": 6341289977288854668,
        "trace_id": 2651702817585997205
    }
}

running: False
schema_name_id: 578
start_time: 2026-04-15 03:32:36
success: True
trace_id: 2651702817585997205

Scan 162001916

duration: 0:00:14.509839

exit_message:

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

id: 162001916

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(255)",
        "created_at": "timestamp",
        "deprecated": "int",
        "duplicate_of": "int",
        "match_info": "varchar(50)",
        "matched": "int",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address_1": "varchar(255)",
        "street_address_2": "varchar(255)",
        "updated_at": "timestamp",
        "uplid_key": "int",
        "zip": "varchar(7)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_uplid/2026-04-14/1776157353/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_uplid/2026-04-14/1776157353",
        "key": "raw/dwh_dim_uplid/2026-04-14/1776157353/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_uplid",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12540307896716310165,
        "service_name": "redshift_unloads",
        "span_id": 1516145814193591715,
        "trace_id": 1773937251667965048
    }
}

running: False
schema_name_id: 578
start_time: 2026-04-14 04:02:48
success: True
trace_id: 1773937251667965048

Scan 161942941

duration: 0:00:14.423237

exit_message:

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

id: 161942941

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(255)",
        "created_at": "timestamp",
        "deprecated": "int",
        "duplicate_of": "int",
        "match_info": "varchar(50)",
        "matched": "int",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address_1": "varchar(255)",
        "street_address_2": "varchar(255)",
        "updated_at": "timestamp",
        "uplid_key": "int",
        "zip": "varchar(7)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_uplid/2026-04-13/1776069565/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_uplid/2026-04-13/1776069565",
        "key": "raw/dwh_dim_uplid/2026-04-13/1776069565/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_uplid",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6505790109678375591,
        "service_name": "redshift_unloads",
        "span_id": 7789819717554353839,
        "trace_id": 3606453681026694205
    }
}

running: False
schema_name_id: 578
start_time: 2026-04-13 03:39:34
success: True
trace_id: 3606453681026694205

Scan 161893841

duration: 0:00:11.872545

exit_message:

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

id: 161893841

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(255)",
        "created_at": "timestamp",
        "deprecated": "int",
        "duplicate_of": "int",
        "match_info": "varchar(50)",
        "matched": "int",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address_1": "varchar(255)",
        "street_address_2": "varchar(255)",
        "updated_at": "timestamp",
        "uplid_key": "int",
        "zip": "varchar(7)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_uplid/2026-04-12/1775984131/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_uplid/2026-04-12/1775984131",
        "key": "raw/dwh_dim_uplid/2026-04-12/1775984131/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_uplid",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9577908103866234768,
        "service_name": "redshift_unloads",
        "span_id": 1111204343340381088,
        "trace_id": 5398298644314754876
    }
}

running: False
schema_name_id: 578
start_time: 2026-04-12 03:55:52
success: True
trace_id: 5398298644314754876

Scan 161841864

duration: 0:00:11.966161

exit_message:

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

id: 161841864

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(255)",
        "created_at": "timestamp",
        "deprecated": "int",
        "duplicate_of": "int",
        "match_info": "varchar(50)",
        "matched": "int",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address_1": "varchar(255)",
        "street_address_2": "varchar(255)",
        "updated_at": "timestamp",
        "uplid_key": "int",
        "zip": "varchar(7)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_uplid/2026-04-11/1775897797/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_uplid/2026-04-11/1775897797",
        "key": "raw/dwh_dim_uplid/2026-04-11/1775897797/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_uplid",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5233114554689423391,
        "service_name": "redshift_unloads",
        "span_id": 4103294065945288958,
        "trace_id": 9900848770504799516
    }
}

running: False
schema_name_id: 578
start_time: 2026-04-11 03:57:04
success: True
trace_id: 9900848770504799516

Scan 161786659

duration: 0:00:11.968679

exit_message:

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

id: 161786659

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(255)",
        "created_at": "timestamp",
        "deprecated": "int",
        "duplicate_of": "int",
        "match_info": "varchar(50)",
        "matched": "int",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address_1": "varchar(255)",
        "street_address_2": "varchar(255)",
        "updated_at": "timestamp",
        "uplid_key": "int",
        "zip": "varchar(7)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_uplid/2026-04-10/1775811383/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_uplid/2026-04-10/1775811383",
        "key": "raw/dwh_dim_uplid/2026-04-10/1775811383/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_uplid",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5935227981957433470,
        "service_name": "redshift_unloads",
        "span_id": 8693776389448231796,
        "trace_id": 14936732811015671906
    }
}

running: False
schema_name_id: 578
start_time: 2026-04-10 03:57:28
success: True
trace_id: 14936732811015671906

Scan 161730623

duration: 0:00:11.831373

exit_message:

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

id: 161730623

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(255)",
        "created_at": "timestamp",
        "deprecated": "int",
        "duplicate_of": "int",
        "match_info": "varchar(50)",
        "matched": "int",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address_1": "varchar(255)",
        "street_address_2": "varchar(255)",
        "updated_at": "timestamp",
        "uplid_key": "int",
        "zip": "varchar(7)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_uplid/2026-04-09/1775723360/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_uplid/2026-04-09/1775723360",
        "key": "raw/dwh_dim_uplid/2026-04-09/1775723360/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_uplid",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 604475529222377440,
        "service_name": "redshift_unloads",
        "span_id": 9614747665819425953,
        "trace_id": 4781441300973889228
    }
}

running: False
schema_name_id: 578
start_time: 2026-04-09 03:29:32
success: True
trace_id: 4781441300973889228

Scan 161676862

duration: 0:00:14.325505

exit_message:

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

id: 161676862

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(255)",
        "created_at": "timestamp",
        "deprecated": "int",
        "duplicate_of": "int",
        "match_info": "varchar(50)",
        "matched": "int",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address_1": "varchar(255)",
        "street_address_2": "varchar(255)",
        "updated_at": "timestamp",
        "uplid_key": "int",
        "zip": "varchar(7)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_uplid/2026-04-08/1775638826/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_uplid/2026-04-08/1775638826",
        "key": "raw/dwh_dim_uplid/2026-04-08/1775638826/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_uplid",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 464282271347183727,
        "service_name": "redshift_unloads",
        "span_id": 8980588286688308451,
        "trace_id": 8314920732233964123
    }
}

running: False
schema_name_id: 578
start_time: 2026-04-08 04:01:41
success: True
trace_id: 8314920732233964123

Scan 161619806

duration: 0:00:11.824044

exit_message:

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

id: 161619806

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(255)",
        "created_at": "timestamp",
        "deprecated": "int",
        "duplicate_of": "int",
        "match_info": "varchar(50)",
        "matched": "int",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address_1": "varchar(255)",
        "street_address_2": "varchar(255)",
        "updated_at": "timestamp",
        "uplid_key": "int",
        "zip": "varchar(7)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_uplid/2026-04-07/1775551798/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_uplid/2026-04-07/1775551798",
        "key": "raw/dwh_dim_uplid/2026-04-07/1775551798/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_uplid",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3877700369578517570,
        "service_name": "redshift_unloads",
        "span_id": 523232085266366204,
        "trace_id": 2669716615113201338
    }
}

running: False
schema_name_id: 578
start_time: 2026-04-07 03:50:09
success: True
trace_id: 2669716615113201338

Scan 161562918

duration: 0:00:14.445194

exit_message:

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

id: 161562918

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(255)",
        "created_at": "timestamp",
        "deprecated": "int",
        "duplicate_of": "int",
        "match_info": "varchar(50)",
        "matched": "int",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address_1": "varchar(255)",
        "street_address_2": "varchar(255)",
        "updated_at": "timestamp",
        "uplid_key": "int",
        "zip": "varchar(7)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_uplid/2026-04-06/1775466073/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_uplid/2026-04-06/1775466073",
        "key": "raw/dwh_dim_uplid/2026-04-06/1775466073/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_uplid",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15860889116601337070,
        "service_name": "redshift_unloads",
        "span_id": 1708981113402775228,
        "trace_id": 7359232627444586330
    }
}

running: False
schema_name_id: 578
start_time: 2026-04-06 04:01:36
success: True
trace_id: 7359232627444586330

Scan 161515149

duration: 0:00:14.362529

exit_message:

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

id: 161515149

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(255)",
        "created_at": "timestamp",
        "deprecated": "int",
        "duplicate_of": "int",
        "match_info": "varchar(50)",
        "matched": "int",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address_1": "varchar(255)",
        "street_address_2": "varchar(255)",
        "updated_at": "timestamp",
        "uplid_key": "int",
        "zip": "varchar(7)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_uplid/2026-04-05/1775378940/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_uplid/2026-04-05/1775378940",
        "key": "raw/dwh_dim_uplid/2026-04-05/1775378940/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_uplid",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15534444252276461985,
        "service_name": "redshift_unloads",
        "span_id": 12975104052349301978,
        "trace_id": 3388354299731433188
    }
}

running: False
schema_name_id: 578
start_time: 2026-04-05 03:49:11
success: True
trace_id: 3388354299731433188

Scan 161461934

duration: 0:00:14.398471

exit_message:

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

id: 161461934

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(255)",
        "created_at": "timestamp",
        "deprecated": "int",
        "duplicate_of": "int",
        "match_info": "varchar(50)",
        "matched": "int",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address_1": "varchar(255)",
        "street_address_2": "varchar(255)",
        "updated_at": "timestamp",
        "uplid_key": "int",
        "zip": "varchar(7)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_uplid/2026-04-04/1775293363/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_uplid/2026-04-04/1775293363",
        "key": "raw/dwh_dim_uplid/2026-04-04/1775293363/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_uplid",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 18227323572236255106,
        "service_name": "redshift_unloads",
        "span_id": 1038067962824414265,
        "trace_id": 7488272420437586540
    }
}

running: False
schema_name_id: 578
start_time: 2026-04-04 04:02:55
success: True
trace_id: 7488272420437586540

Scan 161402162

duration: 0:00:11.897149

exit_message:

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

id: 161402162

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(255)",
        "created_at": "timestamp",
        "deprecated": "int",
        "duplicate_of": "int",
        "match_info": "varchar(50)",
        "matched": "int",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address_1": "varchar(255)",
        "street_address_2": "varchar(255)",
        "updated_at": "timestamp",
        "uplid_key": "int",
        "zip": "varchar(7)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_uplid/2026-04-03/1775205319/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_uplid/2026-04-03/1775205319",
        "key": "raw/dwh_dim_uplid/2026-04-03/1775205319/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_uplid",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17044965558430453915,
        "service_name": "redshift_unloads",
        "span_id": 1663057379940007595,
        "trace_id": 13808478634396181906
    }
}

running: False
schema_name_id: 578
start_time: 2026-04-03 03:35:30
success: True
trace_id: 13808478634396181906

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "deprecated": "int",
    "duplicate_of": "int",
    "match_info": "varchar(50)",
    "matched": "int",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_key": "int",
    "zip": "varchar(7)"
}

created: 2026-04-17 03:19:32

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_uplid`\n(\n `audit_id`  bigint , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `zip`  varchar(7) , `matched`  int , `match_info`  varchar(50) , `deprecated`  int , `duplicate_of`  int , `created_at`  timestamp , `updated_at`  timestamp , `_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/dwh_dim_uplid/2026-04-17/1776413944'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_uplid`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_uplid"
}

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-11-19 15:31:02",
        "disabled": false,
        "format": "raw",
        "id": 578,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_redshift",
            "table": "analytics_dwh_dim_uplid"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "audit_id": "bigint",
            "city": "varchar(255)",
            "created_at": "timestamp",
            "deprecated": "int",
            "duplicate_of": "int",
            "match_info": "varchar(50)",
            "matched": "int",
            "state": "varchar(2)",
            "street_address_1": "varchar(255)",
            "street_address_2": "varchar(255)",
            "updated_at": "timestamp",
            "uplid_key": "int",
            "zip": "varchar(7)"
        },
        "created": "2026-04-17 03:19:32",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_uplid`\n(\n `audit_id`  bigint , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `zip`  varchar(7) , `matched`  int , `match_info`  varchar(50) , `deprecated`  int , `duplicate_of`  int , `created_at`  timestamp , `updated_at`  timestamp , `_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/dwh_dim_uplid/2026-04-17/1776413944'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_uplid`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_uplid"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}