Schema Info

Schema Name: sfdl_stage_redshift.analytics_dwh_dim_uplid

created: 2018-11-19 15:59:59
disabled: False
format: raw
id: 665
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 906647

created: 2026-04-17 03:49:57

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_uplid/2026-04-17/1776415784
id: 906647
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: 665
schema_scan_id: 6415227
updated: 2026-04-17 03:50:11

Version 906417

created: 2026-04-16 04:00:24

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_uplid/2026-04-16/1776329991
id: 906417
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: 665
schema_scan_id: 6414667
updated: 2026-04-16 04:00:37

Version 906210

created: 2026-04-15 03:52:39

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_uplid/2026-04-15/1776243147
id: 906210
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: 665
schema_scan_id: 6414186
updated: 2026-04-15 03:52:53

Version 905982

created: 2026-04-14 03:52:40

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_uplid/2026-04-14/1776156746
id: 905982
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: 665
schema_scan_id: 6413668
updated: 2026-04-14 03:52:54

Version 905776

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_uplid/2026-04-13/1776069254
id: 905776
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: 665
schema_scan_id: 6413132
updated: 2026-04-13 03:34:45

Version 905572

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_uplid/2026-04-12/1775984095
id: 905572
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: 665
schema_scan_id: 6412736
updated: 2026-04-12 03:55:20

Version 905385

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_uplid/2026-04-11/1775897306
id: 905385
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: 665
schema_scan_id: 6412370
updated: 2026-04-11 03:48:51

Version 905154

created: 2026-04-10 03:42:13

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_uplid/2026-04-10/1775810514
id: 905154
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: 665
schema_scan_id: 6411859
updated: 2026-04-10 03:42:27

Version 904933

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_uplid/2026-04-09/1775724936
id: 904933
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: 665
schema_scan_id: 6411335
updated: 2026-04-09 03:56:07

Version 904734

created: 2026-04-08 03:56:48

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_uplid/2026-04-08/1775638590
id: 904734
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: 665
schema_scan_id: 6410857
updated: 2026-04-08 03:57:00

Version 904520

created: 2026-04-07 03:47:20

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_uplid/2026-04-07/1775551628
id: 904520
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: 665
schema_scan_id: 6410346
updated: 2026-04-07 03:47:31

Version 904305

created: 2026-04-06 03:56:06

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_uplid/2026-04-06/1775465751
id: 904305
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: 665
schema_scan_id: 6409799
updated: 2026-04-06 03:56:19

Version 904109

created: 2026-04-05 04:04:31

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_uplid/2026-04-05/1775379848
id: 904109
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: 665
schema_scan_id: 6409417
updated: 2026-04-05 04:04:44

Version 903899

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_uplid/2026-04-04/1775291931
id: 903899
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: 665
schema_scan_id: 6409028
updated: 2026-04-04 03:39:31

Version 903679

created: 2026-04-03 03:45:08

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_uplid/2026-04-03/1775205896
id: 903679
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: 665
schema_scan_id: 6408533
updated: 2026-04-03 03:45:22

Schema Scans: 15

Last at 2026-04-17 03:49:56

Scan 6415227

duration: 0:00:14.716972

exit_message:

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

id: 6415227

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

running: False
schema_name_id: 665
start_time: 2026-04-17 03:49:56
success: True
trace_id: 6442408641638016345

Scan 6414667

duration: 0:00:14.468062

exit_message:

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

id: 6414667

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

running: False
schema_name_id: 665
start_time: 2026-04-16 04:00:23
success: True
trace_id: 9949778409824733400

Scan 6414186

duration: 0:00:14.472980

exit_message:

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

id: 6414186

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

running: False
schema_name_id: 665
start_time: 2026-04-15 03:52:38
success: True
trace_id: 6540753449947316448

Scan 6413668

duration: 0:00:14.630084

exit_message:

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

id: 6413668

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

running: False
schema_name_id: 665
start_time: 2026-04-14 03:52:39
success: True
trace_id: 856733790452995653

Scan 6413132

duration: 0:00:11.946641

exit_message:

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

id: 6413132

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

running: False
schema_name_id: 665
start_time: 2026-04-13 03:34:33
success: True
trace_id: 12779964988877824354

Scan 6412736

duration: 0:00:14.481540

exit_message:

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

id: 6412736

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

running: False
schema_name_id: 665
start_time: 2026-04-12 03:55:06
success: True
trace_id: 193841019433179046

Scan 6412370

duration: 0:00:14.572230

exit_message:

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

id: 6412370

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

running: False
schema_name_id: 665
start_time: 2026-04-11 03:48:36
success: True
trace_id: 17158999852268069661

Scan 6411859

duration: 0:00:14.544218

exit_message:

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

id: 6411859

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

running: False
schema_name_id: 665
start_time: 2026-04-10 03:42:13
success: True
trace_id: 606710758645845487

Scan 6411335

duration: 0:00:14.506134

exit_message:

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

id: 6411335

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

running: False
schema_name_id: 665
start_time: 2026-04-09 03:55:52
success: True
trace_id: 1719513273583943900

Scan 6410857

duration: 0:00:12.121200

exit_message:

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

id: 6410857

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

running: False
schema_name_id: 665
start_time: 2026-04-08 03:56:48
success: True
trace_id: 13998156571141916309

Scan 6410346

duration: 0:00:12.000780

exit_message:

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

id: 6410346

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

running: False
schema_name_id: 665
start_time: 2026-04-07 03:47:19
success: True
trace_id: 14923391045792834078

Scan 6409799

duration: 0:00:14.436933

exit_message:

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

id: 6409799

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

running: False
schema_name_id: 665
start_time: 2026-04-06 03:56:05
success: True
trace_id: 9108801797033139797

Scan 6409417

duration: 0:00:14.436063

exit_message:

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

id: 6409417

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

running: False
schema_name_id: 665
start_time: 2026-04-05 04:04:30
success: True
trace_id: 6685118464874770689

Scan 6409028

duration: 0:00:14.419654

exit_message:

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

id: 6409028

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

running: False
schema_name_id: 665
start_time: 2026-04-04 03:39:16
success: True
trace_id: 10031043547425346479

Scan 6408533

duration: 0:00:14.398380

exit_message:

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

id: 6408533

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

running: False
schema_name_id: 665
start_time: 2026-04-03 03:45:08
success: True
trace_id: 13664875915630740012

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:49:57

ddl:

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

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-11-19 15:59:59",
        "disabled": false,
        "format": "raw",
        "id": 665,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_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:49:57",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/dwh_dim_uplid/2026-04-17/1776415784'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_uplid`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_uplid"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}