Schema Info

Schema Name: sfdl_stage_redshift.analytics_dwh_dim_uplid_address

created: 2018-11-19 16:00:05
disabled: False
format: raw
id: 666
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 906648

created: 2026-04-17 03:50:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_uplid_address`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_uplid_address`\n(\n `audit_id`  bigint , `uplid_address_key`  int , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `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_address/2026-04-17/1776415791'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_uplid_address"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_uplid_address/2026-04-17/1776415791
id: 906648
processed: 1

raw_data:

{
    "_origin": "9",
    "audit_id": "0",
    "city": "5",
    "created_at": "7",
    "state": "6",
    "street_address_1": "3",
    "street_address_2": "4",
    "updated_at": "8",
    "uplid_address_key": "1",
    "uplid_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_address_key": "int",
    "uplid_key": "int"
}

schema_name_id: 666
schema_scan_id: 6415228
updated: 2026-04-17 03:50:13

Version 906400

created: 2026-04-16 03:58:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_uplid_address`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_uplid_address`\n(\n `audit_id`  bigint , `uplid_address_key`  int , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `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_address/2026-04-16/1776329877'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_uplid_address"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_uplid_address/2026-04-16/1776329877
id: 906400
processed: 1

raw_data:

{
    "_origin": "9",
    "audit_id": "0",
    "city": "5",
    "created_at": "7",
    "state": "6",
    "street_address_1": "3",
    "street_address_2": "4",
    "updated_at": "8",
    "uplid_address_key": "1",
    "uplid_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_address_key": "int",
    "uplid_key": "int"
}

schema_name_id: 666
schema_scan_id: 6414650
updated: 2026-04-16 03:58:39

Version 906211

created: 2026-04-15 03:53:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_uplid_address`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_uplid_address`\n(\n `audit_id`  bigint , `uplid_address_key`  int , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `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_address/2026-04-15/1776243155'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_uplid_address"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_uplid_address/2026-04-15/1776243155
id: 906211
processed: 1

raw_data:

{
    "_origin": "9",
    "audit_id": "0",
    "city": "5",
    "created_at": "7",
    "state": "6",
    "street_address_1": "3",
    "street_address_2": "4",
    "updated_at": "8",
    "uplid_address_key": "1",
    "uplid_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_address_key": "int",
    "uplid_key": "int"
}

schema_name_id: 666
schema_scan_id: 6414187
updated: 2026-04-15 03:53:14

Version 906000

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_uplid_address`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_uplid_address`\n(\n `audit_id`  bigint , `uplid_address_key`  int , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `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_address/2026-04-14/1776156895'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_uplid_address"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_uplid_address/2026-04-14/1776156895
id: 906000
processed: 1

raw_data:

{
    "_origin": "9",
    "audit_id": "0",
    "city": "5",
    "created_at": "7",
    "state": "6",
    "street_address_1": "3",
    "street_address_2": "4",
    "updated_at": "8",
    "uplid_address_key": "1",
    "uplid_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_address_key": "int",
    "uplid_key": "int"
}

schema_name_id: 666
schema_scan_id: 6413686
updated: 2026-04-14 03:55:18

Version 905777

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_address`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_uplid_address`\n(\n `audit_id`  bigint , `uplid_address_key`  int , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `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_address/2026-04-13/1776069261'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_uplid_address"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_uplid_address/2026-04-13/1776069261
id: 905777
processed: 1

raw_data:

{
    "_origin": "9",
    "audit_id": "0",
    "city": "5",
    "created_at": "7",
    "state": "6",
    "street_address_1": "3",
    "street_address_2": "4",
    "updated_at": "8",
    "uplid_address_key": "1",
    "uplid_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_address_key": "int",
    "uplid_key": "int"
}

schema_name_id: 666
schema_scan_id: 6413133
updated: 2026-04-13 03:34:48

Version 905560

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_uplid_address`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_uplid_address`\n(\n `audit_id`  bigint , `uplid_address_key`  int , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `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_address/2026-04-12/1775983067'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_uplid_address"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_uplid_address/2026-04-12/1775983067
id: 905560
processed: 1

raw_data:

{
    "_origin": "9",
    "audit_id": "0",
    "city": "5",
    "created_at": "7",
    "state": "6",
    "street_address_1": "3",
    "street_address_2": "4",
    "updated_at": "8",
    "uplid_address_key": "1",
    "uplid_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_address_key": "int",
    "uplid_key": "int"
}

schema_name_id: 666
schema_scan_id: 6412723
updated: 2026-04-12 03:38:14

Version 905386

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_uplid_address`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_uplid_address`\n(\n `audit_id`  bigint , `uplid_address_key`  int , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `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_address/2026-04-11/1775897316'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_uplid_address"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_uplid_address/2026-04-11/1775897316
id: 905386
processed: 1

raw_data:

{
    "_origin": "9",
    "audit_id": "0",
    "city": "5",
    "created_at": "7",
    "state": "6",
    "street_address_1": "3",
    "street_address_2": "4",
    "updated_at": "8",
    "uplid_address_key": "1",
    "uplid_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_address_key": "int",
    "uplid_key": "int"
}

schema_name_id: 666
schema_scan_id: 6412371
updated: 2026-04-11 03:48:59

Version 905163

created: 2026-04-10 03:55:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_uplid_address`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_uplid_address`\n(\n `audit_id`  bigint , `uplid_address_key`  int , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `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_address/2026-04-10/1775811317'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_uplid_address"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_uplid_address/2026-04-10/1775811317
id: 905163
processed: 1

raw_data:

{
    "_origin": "9",
    "audit_id": "0",
    "city": "5",
    "created_at": "7",
    "state": "6",
    "street_address_1": "3",
    "street_address_2": "4",
    "updated_at": "8",
    "uplid_address_key": "1",
    "uplid_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_address_key": "int",
    "uplid_key": "int"
}

schema_name_id: 666
schema_scan_id: 6411868
updated: 2026-04-10 03:55:45

Version 904932

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_uplid_address`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_uplid_address`\n(\n `audit_id`  bigint , `uplid_address_key`  int , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `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_address/2026-04-09/1775724930'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_uplid_address"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_uplid_address/2026-04-09/1775724930
id: 904932
processed: 1

raw_data:

{
    "_origin": "9",
    "audit_id": "0",
    "city": "5",
    "created_at": "7",
    "state": "6",
    "street_address_1": "3",
    "street_address_2": "4",
    "updated_at": "8",
    "uplid_address_key": "1",
    "uplid_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_address_key": "int",
    "uplid_key": "int"
}

schema_name_id: 666
schema_scan_id: 6411334
updated: 2026-04-09 03:56:04

Version 904735

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_uplid_address`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_uplid_address`\n(\n `audit_id`  bigint , `uplid_address_key`  int , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `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_address/2026-04-08/1775638602'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_uplid_address"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_uplid_address/2026-04-08/1775638602
id: 904735
processed: 1

raw_data:

{
    "_origin": "9",
    "audit_id": "0",
    "city": "5",
    "created_at": "7",
    "state": "6",
    "street_address_1": "3",
    "street_address_2": "4",
    "updated_at": "8",
    "uplid_address_key": "1",
    "uplid_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_address_key": "int",
    "uplid_key": "int"
}

schema_name_id: 666
schema_scan_id: 6410858
updated: 2026-04-08 03:57:12

Version 904521

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_uplid_address`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_uplid_address`\n(\n `audit_id`  bigint , `uplid_address_key`  int , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `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_address/2026-04-07/1775551636'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_uplid_address"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_uplid_address/2026-04-07/1775551636
id: 904521
processed: 1

raw_data:

{
    "_origin": "9",
    "audit_id": "0",
    "city": "5",
    "created_at": "7",
    "state": "6",
    "street_address_1": "3",
    "street_address_2": "4",
    "updated_at": "8",
    "uplid_address_key": "1",
    "uplid_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_address_key": "int",
    "uplid_key": "int"
}

schema_name_id: 666
schema_scan_id: 6410347
updated: 2026-04-07 03:47:48

Version 904291

created: 2026-04-06 03:46:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_uplid_address`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_uplid_address`\n(\n `audit_id`  bigint , `uplid_address_key`  int , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `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_address/2026-04-06/1775465185'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_uplid_address"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_uplid_address/2026-04-06/1775465185
id: 904291
processed: 1

raw_data:

{
    "_origin": "9",
    "audit_id": "0",
    "city": "5",
    "created_at": "7",
    "state": "6",
    "street_address_1": "3",
    "street_address_2": "4",
    "updated_at": "8",
    "uplid_address_key": "1",
    "uplid_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_address_key": "int",
    "uplid_key": "int"
}

schema_name_id: 666
schema_scan_id: 6409785
updated: 2026-04-06 03:46:48

Version 904112

created: 2026-04-05 04:04:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_uplid_address`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_uplid_address`\n(\n `audit_id`  bigint , `uplid_address_key`  int , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `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_address/2026-04-05/1775379855'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_uplid_address"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_uplid_address/2026-04-05/1775379855
id: 904112
processed: 1

raw_data:

{
    "_origin": "9",
    "audit_id": "0",
    "city": "5",
    "created_at": "7",
    "state": "6",
    "street_address_1": "3",
    "street_address_2": "4",
    "updated_at": "8",
    "uplid_address_key": "1",
    "uplid_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_address_key": "int",
    "uplid_key": "int"
}

schema_name_id: 666
schema_scan_id: 6409420
updated: 2026-04-05 04:04:56

Version 903897

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_uplid_address`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_uplid_address`\n(\n `audit_id`  bigint , `uplid_address_key`  int , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `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_address/2026-04-04/1775291939'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_uplid_address"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_uplid_address/2026-04-04/1775291939
id: 903897
processed: 1

raw_data:

{
    "_origin": "9",
    "audit_id": "0",
    "city": "5",
    "created_at": "7",
    "state": "6",
    "street_address_1": "3",
    "street_address_2": "4",
    "updated_at": "8",
    "uplid_address_key": "1",
    "uplid_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_address_key": "int",
    "uplid_key": "int"
}

schema_name_id: 666
schema_scan_id: 6409026
updated: 2026-04-04 03:39:25

Version 903686

created: 2026-04-03 03:50:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_uplid_address`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_uplid_address`\n(\n `audit_id`  bigint , `uplid_address_key`  int , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `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_address/2026-04-03/1775206206'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_uplid_address"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_uplid_address/2026-04-03/1775206206
id: 903686
processed: 1

raw_data:

{
    "_origin": "9",
    "audit_id": "0",
    "city": "5",
    "created_at": "7",
    "state": "6",
    "street_address_1": "3",
    "street_address_2": "4",
    "updated_at": "8",
    "uplid_address_key": "1",
    "uplid_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_address_key": "int",
    "uplid_key": "int"
}

schema_name_id: 666
schema_scan_id: 6408540
updated: 2026-04-03 03:50:33

Schema Scans: 15

Last at 2026-04-17 03:50:02

Scan 6415228

duration: 0:00:11.886352

exit_message:

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

id: 6415228

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(255)",
        "created_at": "timestamp",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address_1": "varchar(255)",
        "street_address_2": "varchar(255)",
        "updated_at": "timestamp",
        "uplid_address_key": "int",
        "uplid_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_uplid_address/2026-04-17/1776415791/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_address/2026-04-17/1776415791",
        "key": "raw/dwh_dim_uplid_address/2026-04-17/1776415791/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_uplid_address",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10952274190583054931,
        "service_name": "redshift_unloads",
        "span_id": 15877647875236196605,
        "trace_id": 1139734761696057244
    }
}

running: False
schema_name_id: 666
start_time: 2026-04-17 03:50:02
success: True
trace_id: 1139734761696057244

Scan 6414650

duration: 0:00:11.787184

exit_message:

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

id: 6414650

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(255)",
        "created_at": "timestamp",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address_1": "varchar(255)",
        "street_address_2": "varchar(255)",
        "updated_at": "timestamp",
        "uplid_address_key": "int",
        "uplid_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_uplid_address/2026-04-16/1776329877/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_address/2026-04-16/1776329877",
        "key": "raw/dwh_dim_uplid_address/2026-04-16/1776329877/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_uplid_address",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 18315991680083376249,
        "service_name": "redshift_unloads",
        "span_id": 12167170781723692280,
        "trace_id": 9039990633779714575
    }
}

running: False
schema_name_id: 666
start_time: 2026-04-16 03:58:27
success: True
trace_id: 9039990633779714575

Scan 6414187

duration: 0:00:14.387056

exit_message:

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

id: 6414187

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(255)",
        "created_at": "timestamp",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address_1": "varchar(255)",
        "street_address_2": "varchar(255)",
        "updated_at": "timestamp",
        "uplid_address_key": "int",
        "uplid_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_uplid_address/2026-04-15/1776243155/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_address/2026-04-15/1776243155",
        "key": "raw/dwh_dim_uplid_address/2026-04-15/1776243155/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_uplid_address",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3753162577881421412,
        "service_name": "redshift_unloads",
        "span_id": 12968817178490638028,
        "trace_id": 2224402806348348686
    }
}

running: False
schema_name_id: 666
start_time: 2026-04-15 03:53:00
success: True
trace_id: 2224402806348348686

Scan 6413686

duration: 0:00:11.749353

exit_message:

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

id: 6413686

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(255)",
        "created_at": "timestamp",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address_1": "varchar(255)",
        "street_address_2": "varchar(255)",
        "updated_at": "timestamp",
        "uplid_address_key": "int",
        "uplid_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_uplid_address/2026-04-14/1776156895/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_address/2026-04-14/1776156895",
        "key": "raw/dwh_dim_uplid_address/2026-04-14/1776156895/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_uplid_address",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3030419333491656099,
        "service_name": "redshift_unloads",
        "span_id": 6298011576709685178,
        "trace_id": 15556418610225335266
    }
}

running: False
schema_name_id: 666
start_time: 2026-04-14 03:55:07
success: True
trace_id: 15556418610225335266

Scan 6413133

duration: 0:00:14.478279

exit_message:

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

id: 6413133

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(255)",
        "created_at": "timestamp",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address_1": "varchar(255)",
        "street_address_2": "varchar(255)",
        "updated_at": "timestamp",
        "uplid_address_key": "int",
        "uplid_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_uplid_address/2026-04-13/1776069261/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_address/2026-04-13/1776069261",
        "key": "raw/dwh_dim_uplid_address/2026-04-13/1776069261/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_uplid_address",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17272539971969338480,
        "service_name": "redshift_unloads",
        "span_id": 10130060366011982560,
        "trace_id": 5497646351926732173
    }
}

running: False
schema_name_id: 666
start_time: 2026-04-13 03:34:34
success: True
trace_id: 5497646351926732173

Scan 6412723

duration: 0:00:14.324087

exit_message:

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

id: 6412723

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(255)",
        "created_at": "timestamp",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address_1": "varchar(255)",
        "street_address_2": "varchar(255)",
        "updated_at": "timestamp",
        "uplid_address_key": "int",
        "uplid_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_uplid_address/2026-04-12/1775983067/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_address/2026-04-12/1775983067",
        "key": "raw/dwh_dim_uplid_address/2026-04-12/1775983067/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_uplid_address",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8287336772701994821,
        "service_name": "redshift_unloads",
        "span_id": 12418170638225684458,
        "trace_id": 6680205606901895131
    }
}

running: False
schema_name_id: 666
start_time: 2026-04-12 03:37:59
success: True
trace_id: 6680205606901895131

Scan 6412371

duration: 0:00:11.734951

exit_message:

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

id: 6412371

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(255)",
        "created_at": "timestamp",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address_1": "varchar(255)",
        "street_address_2": "varchar(255)",
        "updated_at": "timestamp",
        "uplid_address_key": "int",
        "uplid_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_uplid_address/2026-04-11/1775897316/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_address/2026-04-11/1775897316",
        "key": "raw/dwh_dim_uplid_address/2026-04-11/1775897316/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_uplid_address",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13334303049105305642,
        "service_name": "redshift_unloads",
        "span_id": 17694784061932916740,
        "trace_id": 6758186637351925406
    }
}

running: False
schema_name_id: 666
start_time: 2026-04-11 03:48:48
success: True
trace_id: 6758186637351925406

Scan 6411868

duration: 0:00:11.841727

exit_message:

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

id: 6411868

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(255)",
        "created_at": "timestamp",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address_1": "varchar(255)",
        "street_address_2": "varchar(255)",
        "updated_at": "timestamp",
        "uplid_address_key": "int",
        "uplid_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_uplid_address/2026-04-10/1775811317/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_address/2026-04-10/1775811317",
        "key": "raw/dwh_dim_uplid_address/2026-04-10/1775811317/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_uplid_address",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15756014472485722041,
        "service_name": "redshift_unloads",
        "span_id": 390498051078163054,
        "trace_id": 11011679105411281507
    }
}

running: False
schema_name_id: 666
start_time: 2026-04-10 03:55:33
success: True
trace_id: 11011679105411281507

Scan 6411334

duration: 0:00:11.887427

exit_message:

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

id: 6411334

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(255)",
        "created_at": "timestamp",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address_1": "varchar(255)",
        "street_address_2": "varchar(255)",
        "updated_at": "timestamp",
        "uplid_address_key": "int",
        "uplid_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_uplid_address/2026-04-09/1775724930/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_address/2026-04-09/1775724930",
        "key": "raw/dwh_dim_uplid_address/2026-04-09/1775724930/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_uplid_address",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11358946603360556450,
        "service_name": "redshift_unloads",
        "span_id": 9338263726906737284,
        "trace_id": 17175667051912561128
    }
}

running: False
schema_name_id: 666
start_time: 2026-04-09 03:55:52
success: True
trace_id: 17175667051912561128

Scan 6410858

duration: 0:00:14.452163

exit_message:

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

id: 6410858

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(255)",
        "created_at": "timestamp",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address_1": "varchar(255)",
        "street_address_2": "varchar(255)",
        "updated_at": "timestamp",
        "uplid_address_key": "int",
        "uplid_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_uplid_address/2026-04-08/1775638602/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_address/2026-04-08/1775638602",
        "key": "raw/dwh_dim_uplid_address/2026-04-08/1775638602/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_uplid_address",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6197644964638646600,
        "service_name": "redshift_unloads",
        "span_id": 15397503731378111113,
        "trace_id": 17486591837827994269
    }
}

running: False
schema_name_id: 666
start_time: 2026-04-08 03:56:57
success: True
trace_id: 17486591837827994269

Scan 6410347

duration: 0:00:14.342087

exit_message:

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

id: 6410347

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(255)",
        "created_at": "timestamp",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address_1": "varchar(255)",
        "street_address_2": "varchar(255)",
        "updated_at": "timestamp",
        "uplid_address_key": "int",
        "uplid_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_uplid_address/2026-04-07/1775551636/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_address/2026-04-07/1775551636",
        "key": "raw/dwh_dim_uplid_address/2026-04-07/1775551636/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_uplid_address",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17188215465490697176,
        "service_name": "redshift_unloads",
        "span_id": 5463885235782824197,
        "trace_id": 6138269471369716016
    }
}

running: False
schema_name_id: 666
start_time: 2026-04-07 03:47:34
success: True
trace_id: 6138269471369716016

Scan 6409785

duration: 0:00:11.897736

exit_message:

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

id: 6409785

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(255)",
        "created_at": "timestamp",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address_1": "varchar(255)",
        "street_address_2": "varchar(255)",
        "updated_at": "timestamp",
        "uplid_address_key": "int",
        "uplid_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_uplid_address/2026-04-06/1775465185/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_address/2026-04-06/1775465185",
        "key": "raw/dwh_dim_uplid_address/2026-04-06/1775465185/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_uplid_address",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3578316187629165626,
        "service_name": "redshift_unloads",
        "span_id": 3053136275474242838,
        "trace_id": 8256147527930362340
    }
}

running: False
schema_name_id: 666
start_time: 2026-04-06 03:46:37
success: True
trace_id: 8256147527930362340

Scan 6409420

duration: 0:00:14.418721

exit_message:

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

id: 6409420

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(255)",
        "created_at": "timestamp",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address_1": "varchar(255)",
        "street_address_2": "varchar(255)",
        "updated_at": "timestamp",
        "uplid_address_key": "int",
        "uplid_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_uplid_address/2026-04-05/1775379855/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_address/2026-04-05/1775379855",
        "key": "raw/dwh_dim_uplid_address/2026-04-05/1775379855/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_uplid_address",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5644863183065062446,
        "service_name": "redshift_unloads",
        "span_id": 7269388333131380061,
        "trace_id": 10344783608956507371
    }
}

running: False
schema_name_id: 666
start_time: 2026-04-05 04:04:41
success: True
trace_id: 10344783608956507371

Scan 6409026

duration: 0:00:11.763342

exit_message:

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

id: 6409026

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(255)",
        "created_at": "timestamp",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address_1": "varchar(255)",
        "street_address_2": "varchar(255)",
        "updated_at": "timestamp",
        "uplid_address_key": "int",
        "uplid_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_uplid_address/2026-04-04/1775291939/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_address/2026-04-04/1775291939",
        "key": "raw/dwh_dim_uplid_address/2026-04-04/1775291939/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_uplid_address",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17213050896655626248,
        "service_name": "redshift_unloads",
        "span_id": 4114589431470782699,
        "trace_id": 1438282209117640568
    }
}

running: False
schema_name_id: 666
start_time: 2026-04-04 03:39:13
success: True
trace_id: 1438282209117640568

Scan 6408540

duration: 0:00:14.359287

exit_message:

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

id: 6408540

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(255)",
        "created_at": "timestamp",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address_1": "varchar(255)",
        "street_address_2": "varchar(255)",
        "updated_at": "timestamp",
        "uplid_address_key": "int",
        "uplid_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_uplid_address/2026-04-03/1775206206/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_address/2026-04-03/1775206206",
        "key": "raw/dwh_dim_uplid_address/2026-04-03/1775206206/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_uplid_address",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12897514903479214018,
        "service_name": "redshift_unloads",
        "span_id": 12910509893709708107,
        "trace_id": 114789208323657143
    }
}

running: False
schema_name_id: 666
start_time: 2026-04-03 03:50:18
success: True
trace_id: 114789208323657143

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(255)",
    "created_at": "timestamp",
    "state": "varchar(2)",
    "street_address_1": "varchar(255)",
    "street_address_2": "varchar(255)",
    "updated_at": "timestamp",
    "uplid_address_key": "int",
    "uplid_key": "int"
}

created: 2026-04-17 03:50:02

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_address`\n(\n `audit_id`  bigint , `uplid_address_key`  int , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `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_address/2026-04-17/1776415791'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_uplid_address`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_uplid_address"
}

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 16:00:05",
        "disabled": false,
        "format": "raw",
        "id": 666,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_redshift",
            "table": "analytics_dwh_dim_uplid_address"
        },
        "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",
            "state": "varchar(2)",
            "street_address_1": "varchar(255)",
            "street_address_2": "varchar(255)",
            "updated_at": "timestamp",
            "uplid_address_key": "int",
            "uplid_key": "int"
        },
        "created": "2026-04-17 03:50:02",
        "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_address`\n(\n `audit_id`  bigint , `uplid_address_key`  int , `uplid_key`  int , `street_address_1`  varchar(255) , `street_address_2`  varchar(255) , `city`  varchar(255) , `state`  varchar(2) , `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_address/2026-04-17/1776415791'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_uplid_address`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_uplid_address"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}