Schema Info

Schema Name: sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list

created: 2019-03-02 03:25:37
disabled: False
format: raw
id: 656
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 1717883

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`\n(\n `internal_key`  varchar(128) , `uplid_id`  int , `source`  varchar(9) , `logo_name`  varchar(128) , `logo_id`  varchar(128) , `facility_name`  varchar(128) , `address_1`  varchar(256) , `address_2`  varchar(256) , `city`  varchar(128) , `state`  varchar(32) , `zip`  varchar(32) , `country`  varchar(32) , `product_type`  varchar(128) , `total_units`  bigint , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-17/1776414754'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-17/1776414754
id: 1717883
processed: 1

raw_data:

{
    "_origin": "14",
    "address_1": "6",
    "address_2": "7",
    "city": "8",
    "country": "11",
    "facility_name": "5",
    "internal_key": "0",
    "logo_id": "4",
    "logo_name": "3",
    "product_type": "12",
    "source": "2",
    "state": "9",
    "total_units": "13",
    "uplid_id": "1",
    "zip": "10"
}

schema_attributes:

{
    "_origin": "string",
    "address_1": "varchar(256)",
    "address_2": "varchar(256)",
    "city": "varchar(128)",
    "country": "varchar(32)",
    "facility_name": "varchar(128)",
    "internal_key": "varchar(128)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "product_type": "varchar(128)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

schema_name_id: 656
schema_scan_id: 162167996
updated: 2026-04-17 03:32:56

Version 1716675

created: 2026-04-16 04:11:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`\n(\n `internal_key`  varchar(128) , `uplid_id`  int , `source`  varchar(9) , `logo_name`  varchar(128) , `logo_id`  varchar(128) , `facility_name`  varchar(128) , `address_1`  varchar(256) , `address_2`  varchar(256) , `city`  varchar(128) , `state`  varchar(32) , `zip`  varchar(32) , `country`  varchar(32) , `product_type`  varchar(128) , `total_units`  bigint , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-16/1776330692'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-16/1776330692
id: 1716675
processed: 1

raw_data:

{
    "_origin": "14",
    "address_1": "6",
    "address_2": "7",
    "city": "8",
    "country": "11",
    "facility_name": "5",
    "internal_key": "0",
    "logo_id": "4",
    "logo_name": "3",
    "product_type": "12",
    "source": "2",
    "state": "9",
    "total_units": "13",
    "uplid_id": "1",
    "zip": "10"
}

schema_attributes:

{
    "_origin": "string",
    "address_1": "varchar(256)",
    "address_2": "varchar(256)",
    "city": "varchar(128)",
    "country": "varchar(32)",
    "facility_name": "varchar(128)",
    "internal_key": "varchar(128)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "product_type": "varchar(128)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

schema_name_id: 656
schema_scan_id: 162113334
updated: 2026-04-16 04:11:54

Version 1715418

created: 2026-04-15 03:31:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`\n(\n `internal_key`  varchar(128) , `uplid_id`  int , `source`  varchar(9) , `logo_name`  varchar(128) , `logo_id`  varchar(128) , `facility_name`  varchar(128) , `address_1`  varchar(256) , `address_2`  varchar(256) , `city`  varchar(128) , `state`  varchar(32) , `zip`  varchar(32) , `country`  varchar(32) , `product_type`  varchar(128) , `total_units`  bigint , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-15/1776241886'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-15/1776241886
id: 1715418
processed: 1

raw_data:

{
    "_origin": "14",
    "address_1": "6",
    "address_2": "7",
    "city": "8",
    "country": "11",
    "facility_name": "5",
    "internal_key": "0",
    "logo_id": "4",
    "logo_name": "3",
    "product_type": "12",
    "source": "2",
    "state": "9",
    "total_units": "13",
    "uplid_id": "1",
    "zip": "10"
}

schema_attributes:

{
    "_origin": "string",
    "address_1": "varchar(256)",
    "address_2": "varchar(256)",
    "city": "varchar(128)",
    "country": "varchar(32)",
    "facility_name": "varchar(128)",
    "internal_key": "varchar(128)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "product_type": "varchar(128)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

schema_name_id: 656
schema_scan_id: 162056268
updated: 2026-04-15 03:31:51

Version 1714246

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`\n(\n `internal_key`  varchar(128) , `uplid_id`  int , `source`  varchar(9) , `logo_name`  varchar(128) , `logo_id`  varchar(128) , `facility_name`  varchar(128) , `address_1`  varchar(256) , `address_2`  varchar(256) , `city`  varchar(128) , `state`  varchar(32) , `zip`  varchar(32) , `country`  varchar(32) , `product_type`  varchar(128) , `total_units`  bigint , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-14/1776156018'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-14/1776156018
id: 1714246
processed: 1

raw_data:

{
    "_origin": "14",
    "address_1": "6",
    "address_2": "7",
    "city": "8",
    "country": "11",
    "facility_name": "5",
    "internal_key": "0",
    "logo_id": "4",
    "logo_name": "3",
    "product_type": "12",
    "source": "2",
    "state": "9",
    "total_units": "13",
    "uplid_id": "1",
    "zip": "10"
}

schema_attributes:

{
    "_origin": "string",
    "address_1": "varchar(256)",
    "address_2": "varchar(256)",
    "city": "varchar(128)",
    "country": "varchar(32)",
    "facility_name": "varchar(128)",
    "internal_key": "varchar(128)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "product_type": "varchar(128)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

schema_name_id: 656
schema_scan_id: 162000814
updated: 2026-04-14 03:40:44

Version 1713000

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`\n(\n `internal_key`  varchar(128) , `uplid_id`  int , `source`  varchar(9) , `logo_name`  varchar(128) , `logo_id`  varchar(128) , `facility_name`  varchar(128) , `address_1`  varchar(256) , `address_2`  varchar(256) , `city`  varchar(128) , `state`  varchar(32) , `zip`  varchar(32) , `country`  varchar(32) , `product_type`  varchar(128) , `total_units`  bigint , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-13/1776069541'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-13/1776069541
id: 1713000
processed: 1

raw_data:

{
    "_origin": "14",
    "address_1": "6",
    "address_2": "7",
    "city": "8",
    "country": "11",
    "facility_name": "5",
    "internal_key": "0",
    "logo_id": "4",
    "logo_name": "3",
    "product_type": "12",
    "source": "2",
    "state": "9",
    "total_units": "13",
    "uplid_id": "1",
    "zip": "10"
}

schema_attributes:

{
    "_origin": "string",
    "address_1": "varchar(256)",
    "address_2": "varchar(256)",
    "city": "varchar(128)",
    "country": "varchar(32)",
    "facility_name": "varchar(128)",
    "internal_key": "varchar(128)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "product_type": "varchar(128)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

schema_name_id: 656
schema_scan_id: 161942935
updated: 2026-04-13 03:39:22

Version 1711795

created: 2026-04-12 03:27:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`\n(\n `internal_key`  varchar(128) , `uplid_id`  int , `source`  varchar(9) , `logo_name`  varchar(128) , `logo_id`  varchar(128) , `facility_name`  varchar(128) , `address_1`  varchar(256) , `address_2`  varchar(256) , `city`  varchar(128) , `state`  varchar(32) , `zip`  varchar(32) , `country`  varchar(32) , `product_type`  varchar(128) , `total_units`  bigint , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-12/1775982432'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-12/1775982432
id: 1711795
processed: 1

raw_data:

{
    "_origin": "14",
    "address_1": "6",
    "address_2": "7",
    "city": "8",
    "country": "11",
    "facility_name": "5",
    "internal_key": "0",
    "logo_id": "4",
    "logo_name": "3",
    "product_type": "12",
    "source": "2",
    "state": "9",
    "total_units": "13",
    "uplid_id": "1",
    "zip": "10"
}

schema_attributes:

{
    "_origin": "string",
    "address_1": "varchar(256)",
    "address_2": "varchar(256)",
    "city": "varchar(128)",
    "country": "varchar(32)",
    "facility_name": "varchar(128)",
    "internal_key": "varchar(128)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "product_type": "varchar(128)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

schema_name_id: 656
schema_scan_id: 161893566
updated: 2026-04-12 03:27:34

Version 1710653

created: 2026-04-11 04:02:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`\n(\n `internal_key`  varchar(128) , `uplid_id`  int , `source`  varchar(9) , `logo_name`  varchar(128) , `logo_id`  varchar(128) , `facility_name`  varchar(128) , `address_1`  varchar(256) , `address_2`  varchar(256) , `city`  varchar(128) , `state`  varchar(32) , `zip`  varchar(32) , `country`  varchar(32) , `product_type`  varchar(128) , `total_units`  bigint , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-11/1775898154'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-11/1775898154
id: 1710653
processed: 1

raw_data:

{
    "_origin": "14",
    "address_1": "6",
    "address_2": "7",
    "city": "8",
    "country": "11",
    "facility_name": "5",
    "internal_key": "0",
    "logo_id": "4",
    "logo_name": "3",
    "product_type": "12",
    "source": "2",
    "state": "9",
    "total_units": "13",
    "uplid_id": "1",
    "zip": "10"
}

schema_attributes:

{
    "_origin": "string",
    "address_1": "varchar(256)",
    "address_2": "varchar(256)",
    "city": "varchar(128)",
    "country": "varchar(32)",
    "facility_name": "varchar(128)",
    "internal_key": "varchar(128)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "product_type": "varchar(128)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

schema_name_id: 656
schema_scan_id: 161842659
updated: 2026-04-11 04:02:53

Version 1709433

created: 2026-04-10 03:24:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`\n(\n `internal_key`  varchar(128) , `uplid_id`  int , `source`  varchar(9) , `logo_name`  varchar(128) , `logo_id`  varchar(128) , `facility_name`  varchar(128) , `address_1`  varchar(256) , `address_2`  varchar(256) , `city`  varchar(128) , `state`  varchar(32) , `zip`  varchar(32) , `country`  varchar(32) , `product_type`  varchar(128) , `total_units`  bigint , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-10/1775809464'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-10/1775809464
id: 1709433
processed: 1

raw_data:

{
    "_origin": "14",
    "address_1": "6",
    "address_2": "7",
    "city": "8",
    "country": "11",
    "facility_name": "5",
    "internal_key": "0",
    "logo_id": "4",
    "logo_name": "3",
    "product_type": "12",
    "source": "2",
    "state": "9",
    "total_units": "13",
    "uplid_id": "1",
    "zip": "10"
}

schema_attributes:

{
    "_origin": "string",
    "address_1": "varchar(256)",
    "address_2": "varchar(256)",
    "city": "varchar(128)",
    "country": "varchar(32)",
    "facility_name": "varchar(128)",
    "internal_key": "varchar(128)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "product_type": "varchar(128)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

schema_name_id: 656
schema_scan_id: 161786168
updated: 2026-04-10 03:24:48

Version 1708352

created: 2026-04-09 04:05:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`\n(\n `internal_key`  varchar(128) , `uplid_id`  int , `source`  varchar(9) , `logo_name`  varchar(128) , `logo_id`  varchar(128) , `facility_name`  varchar(128) , `address_1`  varchar(256) , `address_2`  varchar(256) , `city`  varchar(128) , `state`  varchar(32) , `zip`  varchar(32) , `country`  varchar(32) , `product_type`  varchar(128) , `total_units`  bigint , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-09/1775725505'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-09/1775725505
id: 1708352
processed: 1

raw_data:

{
    "_origin": "14",
    "address_1": "6",
    "address_2": "7",
    "city": "8",
    "country": "11",
    "facility_name": "5",
    "internal_key": "0",
    "logo_id": "4",
    "logo_name": "3",
    "product_type": "12",
    "source": "2",
    "state": "9",
    "total_units": "13",
    "uplid_id": "1",
    "zip": "10"
}

schema_attributes:

{
    "_origin": "string",
    "address_1": "varchar(256)",
    "address_2": "varchar(256)",
    "city": "varchar(128)",
    "country": "varchar(32)",
    "facility_name": "varchar(128)",
    "internal_key": "varchar(128)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "product_type": "varchar(128)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

schema_name_id: 656
schema_scan_id: 161731804
updated: 2026-04-09 04:05:40

Version 1707107

created: 2026-04-08 03:35:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`\n(\n `internal_key`  varchar(128) , `uplid_id`  int , `source`  varchar(9) , `logo_name`  varchar(128) , `logo_id`  varchar(128) , `facility_name`  varchar(128) , `address_1`  varchar(256) , `address_2`  varchar(256) , `city`  varchar(128) , `state`  varchar(32) , `zip`  varchar(32) , `country`  varchar(32) , `product_type`  varchar(128) , `total_units`  bigint , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-08/1775637322'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-08/1775637322
id: 1707107
processed: 1

raw_data:

{
    "_origin": "14",
    "address_1": "6",
    "address_2": "7",
    "city": "8",
    "country": "11",
    "facility_name": "5",
    "internal_key": "0",
    "logo_id": "4",
    "logo_name": "3",
    "product_type": "12",
    "source": "2",
    "state": "9",
    "total_units": "13",
    "uplid_id": "1",
    "zip": "10"
}

schema_attributes:

{
    "_origin": "string",
    "address_1": "varchar(256)",
    "address_2": "varchar(256)",
    "city": "varchar(128)",
    "country": "varchar(32)",
    "facility_name": "varchar(128)",
    "internal_key": "varchar(128)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "product_type": "varchar(128)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

schema_name_id: 656
schema_scan_id: 161675816
updated: 2026-04-08 03:35:46

Version 1705958

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`\n(\n `internal_key`  varchar(128) , `uplid_id`  int , `source`  varchar(9) , `logo_name`  varchar(128) , `logo_id`  varchar(128) , `facility_name`  varchar(128) , `address_1`  varchar(256) , `address_2`  varchar(256) , `city`  varchar(128) , `state`  varchar(32) , `zip`  varchar(32) , `country`  varchar(32) , `product_type`  varchar(128) , `total_units`  bigint , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-07/1775552084'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-07/1775552084
id: 1705958
processed: 1

raw_data:

{
    "_origin": "14",
    "address_1": "6",
    "address_2": "7",
    "city": "8",
    "country": "11",
    "facility_name": "5",
    "internal_key": "0",
    "logo_id": "4",
    "logo_name": "3",
    "product_type": "12",
    "source": "2",
    "state": "9",
    "total_units": "13",
    "uplid_id": "1",
    "zip": "10"
}

schema_attributes:

{
    "_origin": "string",
    "address_1": "varchar(256)",
    "address_2": "varchar(256)",
    "city": "varchar(128)",
    "country": "varchar(32)",
    "facility_name": "varchar(128)",
    "internal_key": "varchar(128)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "product_type": "varchar(128)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

schema_name_id: 656
schema_scan_id: 161619903
updated: 2026-04-07 03:55:24

Version 1704720

created: 2026-04-06 04:00:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`\n(\n `internal_key`  varchar(128) , `uplid_id`  int , `source`  varchar(9) , `logo_name`  varchar(128) , `logo_id`  varchar(128) , `facility_name`  varchar(128) , `address_1`  varchar(256) , `address_2`  varchar(256) , `city`  varchar(128) , `state`  varchar(32) , `zip`  varchar(32) , `country`  varchar(32) , `product_type`  varchar(128) , `total_units`  bigint , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-06/1775466027'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-06/1775466027
id: 1704720
processed: 1

raw_data:

{
    "_origin": "14",
    "address_1": "6",
    "address_2": "7",
    "city": "8",
    "country": "11",
    "facility_name": "5",
    "internal_key": "0",
    "logo_id": "4",
    "logo_name": "3",
    "product_type": "12",
    "source": "2",
    "state": "9",
    "total_units": "13",
    "uplid_id": "1",
    "zip": "10"
}

schema_attributes:

{
    "_origin": "string",
    "address_1": "varchar(256)",
    "address_2": "varchar(256)",
    "city": "varchar(128)",
    "country": "varchar(32)",
    "facility_name": "varchar(128)",
    "internal_key": "varchar(128)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "product_type": "varchar(128)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

schema_name_id: 656
schema_scan_id: 161562885
updated: 2026-04-06 04:00:50

Version 1703526

created: 2026-04-05 04:06:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`\n(\n `internal_key`  varchar(128) , `uplid_id`  int , `source`  varchar(9) , `logo_name`  varchar(128) , `logo_id`  varchar(128) , `facility_name`  varchar(128) , `address_1`  varchar(256) , `address_2`  varchar(256) , `city`  varchar(128) , `state`  varchar(32) , `zip`  varchar(32) , `country`  varchar(32) , `product_type`  varchar(128) , `total_units`  bigint , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-05/1775379937'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-05/1775379937
id: 1703526
processed: 1

raw_data:

{
    "_origin": "14",
    "address_1": "6",
    "address_2": "7",
    "city": "8",
    "country": "11",
    "facility_name": "5",
    "internal_key": "0",
    "logo_id": "4",
    "logo_name": "3",
    "product_type": "12",
    "source": "2",
    "state": "9",
    "total_units": "13",
    "uplid_id": "1",
    "zip": "10"
}

schema_attributes:

{
    "_origin": "string",
    "address_1": "varchar(256)",
    "address_2": "varchar(256)",
    "city": "varchar(128)",
    "country": "varchar(32)",
    "facility_name": "varchar(128)",
    "internal_key": "varchar(128)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "product_type": "varchar(128)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

schema_name_id: 656
schema_scan_id: 161516209
updated: 2026-04-05 04:06:15

Version 1702371

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`\n(\n `internal_key`  varchar(128) , `uplid_id`  int , `source`  varchar(9) , `logo_name`  varchar(128) , `logo_id`  varchar(128) , `facility_name`  varchar(128) , `address_1`  varchar(256) , `address_2`  varchar(256) , `city`  varchar(128) , `state`  varchar(32) , `zip`  varchar(32) , `country`  varchar(32) , `product_type`  varchar(128) , `total_units`  bigint , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-04/1775293595'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-04/1775293595
id: 1702371
processed: 1

raw_data:

{
    "_origin": "14",
    "address_1": "6",
    "address_2": "7",
    "city": "8",
    "country": "11",
    "facility_name": "5",
    "internal_key": "0",
    "logo_id": "4",
    "logo_name": "3",
    "product_type": "12",
    "source": "2",
    "state": "9",
    "total_units": "13",
    "uplid_id": "1",
    "zip": "10"
}

schema_attributes:

{
    "_origin": "string",
    "address_1": "varchar(256)",
    "address_2": "varchar(256)",
    "city": "varchar(128)",
    "country": "varchar(32)",
    "facility_name": "varchar(128)",
    "internal_key": "varchar(128)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "product_type": "varchar(128)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

schema_name_id: 656
schema_scan_id: 161461941
updated: 2026-04-04 04:07:07

Version 1701126

created: 2026-04-03 03:34:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`\n(\n `internal_key`  varchar(128) , `uplid_id`  int , `source`  varchar(9) , `logo_name`  varchar(128) , `logo_id`  varchar(128) , `facility_name`  varchar(128) , `address_1`  varchar(256) , `address_2`  varchar(256) , `city`  varchar(128) , `state`  varchar(32) , `zip`  varchar(32) , `country`  varchar(32) , `product_type`  varchar(128) , `total_units`  bigint , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-03/1775205266'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-03/1775205266
id: 1701126
processed: 1

raw_data:

{
    "_origin": "14",
    "address_1": "6",
    "address_2": "7",
    "city": "8",
    "country": "11",
    "facility_name": "5",
    "internal_key": "0",
    "logo_id": "4",
    "logo_name": "3",
    "product_type": "12",
    "source": "2",
    "state": "9",
    "total_units": "13",
    "uplid_id": "1",
    "zip": "10"
}

schema_attributes:

{
    "_origin": "string",
    "address_1": "varchar(256)",
    "address_2": "varchar(256)",
    "city": "varchar(128)",
    "country": "varchar(32)",
    "facility_name": "varchar(128)",
    "internal_key": "varchar(128)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "product_type": "varchar(128)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

schema_name_id: 656
schema_scan_id: 161402151
updated: 2026-04-03 03:34:48

Schema Scans: 15

Last at 2026-04-17 03:32:41

Scan 162167996

duration: 0:00:14.544987

exit_message:

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

id: 162167996

payload:

{
    "datatype_dict": {
        "address_1": "varchar(256)",
        "address_2": "varchar(256)",
        "city": "varchar(128)",
        "country": "varchar(32)",
        "facility_name": "varchar(128)",
        "internal_key": "varchar(128)",
        "logo_id": "varchar(128)",
        "logo_name": "varchar(128)",
        "origin_key": "varchar",
        "product_type": "varchar(128)",
        "source": "varchar(9)",
        "state": "varchar(32)",
        "total_units": "bigint",
        "uplid_id": "int",
        "zip": "varchar(32)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_storedge_customer_list/2026-04-17/1776414754/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-17/1776414754",
        "key": "raw/dwh_dim_storedge_customer_list/2026-04-17/1776414754/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12123410265609190528,
        "service_name": "redshift_unloads",
        "span_id": 10566581452887653450,
        "trace_id": 16639883009287197014
    }
}

running: False
schema_name_id: 656
start_time: 2026-04-17 03:32:41
success: True
trace_id: 16639883009287197014

Scan 162113334

duration: 0:00:14.446585

exit_message:

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

id: 162113334

payload:

{
    "datatype_dict": {
        "address_1": "varchar(256)",
        "address_2": "varchar(256)",
        "city": "varchar(128)",
        "country": "varchar(32)",
        "facility_name": "varchar(128)",
        "internal_key": "varchar(128)",
        "logo_id": "varchar(128)",
        "logo_name": "varchar(128)",
        "origin_key": "varchar",
        "product_type": "varchar(128)",
        "source": "varchar(9)",
        "state": "varchar(32)",
        "total_units": "bigint",
        "uplid_id": "int",
        "zip": "varchar(32)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_storedge_customer_list/2026-04-16/1776330692/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-16/1776330692",
        "key": "raw/dwh_dim_storedge_customer_list/2026-04-16/1776330692/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17181952445685923066,
        "service_name": "redshift_unloads",
        "span_id": 15091425448447180211,
        "trace_id": 16944195248243066214
    }
}

running: False
schema_name_id: 656
start_time: 2026-04-16 04:11:40
success: True
trace_id: 16944195248243066214

Scan 162056268

duration: 0:00:11.893644

exit_message:

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

id: 162056268

payload:

{
    "datatype_dict": {
        "address_1": "varchar(256)",
        "address_2": "varchar(256)",
        "city": "varchar(128)",
        "country": "varchar(32)",
        "facility_name": "varchar(128)",
        "internal_key": "varchar(128)",
        "logo_id": "varchar(128)",
        "logo_name": "varchar(128)",
        "origin_key": "varchar",
        "product_type": "varchar(128)",
        "source": "varchar(9)",
        "state": "varchar(32)",
        "total_units": "bigint",
        "uplid_id": "int",
        "zip": "varchar(32)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_storedge_customer_list/2026-04-15/1776241886/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-15/1776241886",
        "key": "raw/dwh_dim_storedge_customer_list/2026-04-15/1776241886/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3229518835084559064,
        "service_name": "redshift_unloads",
        "span_id": 9778053071724017815,
        "trace_id": 14358990814265029450
    }
}

running: False
schema_name_id: 656
start_time: 2026-04-15 03:31:39
success: True
trace_id: 14358990814265029450

Scan 162000814

duration: 0:00:11.814034

exit_message:

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

id: 162000814

payload:

{
    "datatype_dict": {
        "address_1": "varchar(256)",
        "address_2": "varchar(256)",
        "city": "varchar(128)",
        "country": "varchar(32)",
        "facility_name": "varchar(128)",
        "internal_key": "varchar(128)",
        "logo_id": "varchar(128)",
        "logo_name": "varchar(128)",
        "origin_key": "varchar",
        "product_type": "varchar(128)",
        "source": "varchar(9)",
        "state": "varchar(32)",
        "total_units": "bigint",
        "uplid_id": "int",
        "zip": "varchar(32)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_storedge_customer_list/2026-04-14/1776156018/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-14/1776156018",
        "key": "raw/dwh_dim_storedge_customer_list/2026-04-14/1776156018/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5320390360896114353,
        "service_name": "redshift_unloads",
        "span_id": 11494394466908095541,
        "trace_id": 2677294170037443129
    }
}

running: False
schema_name_id: 656
start_time: 2026-04-14 03:40:32
success: True
trace_id: 2677294170037443129

Scan 161942935

duration: 0:00:14.503614

exit_message:

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

id: 161942935

payload:

{
    "datatype_dict": {
        "address_1": "varchar(256)",
        "address_2": "varchar(256)",
        "city": "varchar(128)",
        "country": "varchar(32)",
        "facility_name": "varchar(128)",
        "internal_key": "varchar(128)",
        "logo_id": "varchar(128)",
        "logo_name": "varchar(128)",
        "origin_key": "varchar",
        "product_type": "varchar(128)",
        "source": "varchar(9)",
        "state": "varchar(32)",
        "total_units": "bigint",
        "uplid_id": "int",
        "zip": "varchar(32)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_storedge_customer_list/2026-04-13/1776069541/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-13/1776069541",
        "key": "raw/dwh_dim_storedge_customer_list/2026-04-13/1776069541/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4292480507523222923,
        "service_name": "redshift_unloads",
        "span_id": 13830178966678543847,
        "trace_id": 2440963141721479200
    }
}

running: False
schema_name_id: 656
start_time: 2026-04-13 03:39:08
success: True
trace_id: 2440963141721479200

Scan 161893566

duration: 0:00:11.982213

exit_message:

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

id: 161893566

payload:

{
    "datatype_dict": {
        "address_1": "varchar(256)",
        "address_2": "varchar(256)",
        "city": "varchar(128)",
        "country": "varchar(32)",
        "facility_name": "varchar(128)",
        "internal_key": "varchar(128)",
        "logo_id": "varchar(128)",
        "logo_name": "varchar(128)",
        "origin_key": "varchar",
        "product_type": "varchar(128)",
        "source": "varchar(9)",
        "state": "varchar(32)",
        "total_units": "bigint",
        "uplid_id": "int",
        "zip": "varchar(32)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_storedge_customer_list/2026-04-12/1775982432/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-12/1775982432",
        "key": "raw/dwh_dim_storedge_customer_list/2026-04-12/1775982432/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17645753354956673337,
        "service_name": "redshift_unloads",
        "span_id": 10844895429747183709,
        "trace_id": 18365038456542524616
    }
}

running: False
schema_name_id: 656
start_time: 2026-04-12 03:27:22
success: True
trace_id: 18365038456542524616

Scan 161842659

duration: 0:00:11.842224

exit_message:

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

id: 161842659

payload:

{
    "datatype_dict": {
        "address_1": "varchar(256)",
        "address_2": "varchar(256)",
        "city": "varchar(128)",
        "country": "varchar(32)",
        "facility_name": "varchar(128)",
        "internal_key": "varchar(128)",
        "logo_id": "varchar(128)",
        "logo_name": "varchar(128)",
        "origin_key": "varchar",
        "product_type": "varchar(128)",
        "source": "varchar(9)",
        "state": "varchar(32)",
        "total_units": "bigint",
        "uplid_id": "int",
        "zip": "varchar(32)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_storedge_customer_list/2026-04-11/1775898154/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-11/1775898154",
        "key": "raw/dwh_dim_storedge_customer_list/2026-04-11/1775898154/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7110894145052974424,
        "service_name": "redshift_unloads",
        "span_id": 11471244919697696045,
        "trace_id": 15039925936179763457
    }
}

running: False
schema_name_id: 656
start_time: 2026-04-11 04:02:41
success: True
trace_id: 15039925936179763457

Scan 161786168

duration: 0:00:12.101802

exit_message:

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

id: 161786168

payload:

{
    "datatype_dict": {
        "address_1": "varchar(256)",
        "address_2": "varchar(256)",
        "city": "varchar(128)",
        "country": "varchar(32)",
        "facility_name": "varchar(128)",
        "internal_key": "varchar(128)",
        "logo_id": "varchar(128)",
        "logo_name": "varchar(128)",
        "origin_key": "varchar",
        "product_type": "varchar(128)",
        "source": "varchar(9)",
        "state": "varchar(32)",
        "total_units": "bigint",
        "uplid_id": "int",
        "zip": "varchar(32)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_storedge_customer_list/2026-04-10/1775809464/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-10/1775809464",
        "key": "raw/dwh_dim_storedge_customer_list/2026-04-10/1775809464/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6816468755620832683,
        "service_name": "redshift_unloads",
        "span_id": 15807664175521954690,
        "trace_id": 4846086289863879150
    }
}

running: False
schema_name_id: 656
start_time: 2026-04-10 03:24:36
success: True
trace_id: 4846086289863879150

Scan 161731804

duration: 0:00:11.944285

exit_message:

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

id: 161731804

payload:

{
    "datatype_dict": {
        "address_1": "varchar(256)",
        "address_2": "varchar(256)",
        "city": "varchar(128)",
        "country": "varchar(32)",
        "facility_name": "varchar(128)",
        "internal_key": "varchar(128)",
        "logo_id": "varchar(128)",
        "logo_name": "varchar(128)",
        "origin_key": "varchar",
        "product_type": "varchar(128)",
        "source": "varchar(9)",
        "state": "varchar(32)",
        "total_units": "bigint",
        "uplid_id": "int",
        "zip": "varchar(32)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_storedge_customer_list/2026-04-09/1775725505/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-09/1775725505",
        "key": "raw/dwh_dim_storedge_customer_list/2026-04-09/1775725505/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15880227143621820604,
        "service_name": "redshift_unloads",
        "span_id": 17551340016840265851,
        "trace_id": 1566092478079014136
    }
}

running: False
schema_name_id: 656
start_time: 2026-04-09 04:05:28
success: True
trace_id: 1566092478079014136

Scan 161675816

duration: 0:00:17.070612

exit_message:

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

id: 161675816

payload:

{
    "datatype_dict": {
        "address_1": "varchar(256)",
        "address_2": "varchar(256)",
        "city": "varchar(128)",
        "country": "varchar(32)",
        "facility_name": "varchar(128)",
        "internal_key": "varchar(128)",
        "logo_id": "varchar(128)",
        "logo_name": "varchar(128)",
        "origin_key": "varchar",
        "product_type": "varchar(128)",
        "source": "varchar(9)",
        "state": "varchar(32)",
        "total_units": "bigint",
        "uplid_id": "int",
        "zip": "varchar(32)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_storedge_customer_list/2026-04-08/1775637322/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-08/1775637322",
        "key": "raw/dwh_dim_storedge_customer_list/2026-04-08/1775637322/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2428402982583537694,
        "service_name": "redshift_unloads",
        "span_id": 3431322462949344388,
        "trace_id": 17918068182304719625
    }
}

running: False
schema_name_id: 656
start_time: 2026-04-08 03:35:29
success: True
trace_id: 17918068182304719625

Scan 161619903

duration: 0:00:14.521204

exit_message:

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

id: 161619903

payload:

{
    "datatype_dict": {
        "address_1": "varchar(256)",
        "address_2": "varchar(256)",
        "city": "varchar(128)",
        "country": "varchar(32)",
        "facility_name": "varchar(128)",
        "internal_key": "varchar(128)",
        "logo_id": "varchar(128)",
        "logo_name": "varchar(128)",
        "origin_key": "varchar",
        "product_type": "varchar(128)",
        "source": "varchar(9)",
        "state": "varchar(32)",
        "total_units": "bigint",
        "uplid_id": "int",
        "zip": "varchar(32)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_storedge_customer_list/2026-04-07/1775552084/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-07/1775552084",
        "key": "raw/dwh_dim_storedge_customer_list/2026-04-07/1775552084/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6555904374484133074,
        "service_name": "redshift_unloads",
        "span_id": 6992500812917115957,
        "trace_id": 11967198322316313245
    }
}

running: False
schema_name_id: 656
start_time: 2026-04-07 03:55:09
success: True
trace_id: 11967198322316313245

Scan 161562885

duration: 0:00:14.511775

exit_message:

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

id: 161562885

payload:

{
    "datatype_dict": {
        "address_1": "varchar(256)",
        "address_2": "varchar(256)",
        "city": "varchar(128)",
        "country": "varchar(32)",
        "facility_name": "varchar(128)",
        "internal_key": "varchar(128)",
        "logo_id": "varchar(128)",
        "logo_name": "varchar(128)",
        "origin_key": "varchar",
        "product_type": "varchar(128)",
        "source": "varchar(9)",
        "state": "varchar(32)",
        "total_units": "bigint",
        "uplid_id": "int",
        "zip": "varchar(32)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_storedge_customer_list/2026-04-06/1775466027/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-06/1775466027",
        "key": "raw/dwh_dim_storedge_customer_list/2026-04-06/1775466027/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8836372959741132311,
        "service_name": "redshift_unloads",
        "span_id": 222055195361332848,
        "trace_id": 2553725864401380273
    }
}

running: False
schema_name_id: 656
start_time: 2026-04-06 04:00:35
success: True
trace_id: 2553725864401380273

Scan 161516209

duration: 0:00:14.568658

exit_message:

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

id: 161516209

payload:

{
    "datatype_dict": {
        "address_1": "varchar(256)",
        "address_2": "varchar(256)",
        "city": "varchar(128)",
        "country": "varchar(32)",
        "facility_name": "varchar(128)",
        "internal_key": "varchar(128)",
        "logo_id": "varchar(128)",
        "logo_name": "varchar(128)",
        "origin_key": "varchar",
        "product_type": "varchar(128)",
        "source": "varchar(9)",
        "state": "varchar(32)",
        "total_units": "bigint",
        "uplid_id": "int",
        "zip": "varchar(32)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_storedge_customer_list/2026-04-05/1775379937/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-05/1775379937",
        "key": "raw/dwh_dim_storedge_customer_list/2026-04-05/1775379937/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8566463138246593870,
        "service_name": "redshift_unloads",
        "span_id": 13924413007548419871,
        "trace_id": 173945219533019262
    }
}

running: False
schema_name_id: 656
start_time: 2026-04-05 04:06:00
success: True
trace_id: 173945219533019262

Scan 161461941

duration: 0:00:12.013285

exit_message:

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

id: 161461941

payload:

{
    "datatype_dict": {
        "address_1": "varchar(256)",
        "address_2": "varchar(256)",
        "city": "varchar(128)",
        "country": "varchar(32)",
        "facility_name": "varchar(128)",
        "internal_key": "varchar(128)",
        "logo_id": "varchar(128)",
        "logo_name": "varchar(128)",
        "origin_key": "varchar",
        "product_type": "varchar(128)",
        "source": "varchar(9)",
        "state": "varchar(32)",
        "total_units": "bigint",
        "uplid_id": "int",
        "zip": "varchar(32)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_storedge_customer_list/2026-04-04/1775293595/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-04/1775293595",
        "key": "raw/dwh_dim_storedge_customer_list/2026-04-04/1775293595/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6838260238276098658,
        "service_name": "redshift_unloads",
        "span_id": 1340200162968529146,
        "trace_id": 9850079056542245832
    }
}

running: False
schema_name_id: 656
start_time: 2026-04-04 04:06:55
success: True
trace_id: 9850079056542245832

Scan 161402151

duration: 0:00:12.009972

exit_message:

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

id: 161402151

payload:

{
    "datatype_dict": {
        "address_1": "varchar(256)",
        "address_2": "varchar(256)",
        "city": "varchar(128)",
        "country": "varchar(32)",
        "facility_name": "varchar(128)",
        "internal_key": "varchar(128)",
        "logo_id": "varchar(128)",
        "logo_name": "varchar(128)",
        "origin_key": "varchar",
        "product_type": "varchar(128)",
        "source": "varchar(9)",
        "state": "varchar(32)",
        "total_units": "bigint",
        "uplid_id": "int",
        "zip": "varchar(32)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_storedge_customer_list/2026-04-03/1775205266/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-03/1775205266",
        "key": "raw/dwh_dim_storedge_customer_list/2026-04-03/1775205266/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17986038154773463441,
        "service_name": "redshift_unloads",
        "span_id": 12185311182914598621,
        "trace_id": 17127906587104502635
    }
}

running: False
schema_name_id: 656
start_time: 2026-04-03 03:34:36
success: True
trace_id: 17127906587104502635

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "address_1": "varchar(256)",
    "address_2": "varchar(256)",
    "city": "varchar(128)",
    "country": "varchar(32)",
    "facility_name": "varchar(128)",
    "internal_key": "varchar(128)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "product_type": "varchar(128)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`\n(\n `internal_key`  varchar(128) , `uplid_id`  int , `source`  varchar(9) , `logo_name`  varchar(128) , `logo_id`  varchar(128) , `facility_name`  varchar(128) , `address_1`  varchar(256) , `address_2`  varchar(256) , `city`  varchar(128) , `state`  varchar(32) , `zip`  varchar(32) , `country`  varchar(32) , `product_type`  varchar(128) , `total_units`  bigint , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-17/1776414754'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list"
}

Server:

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

Raw:

{
    "name": {
        "created": "2019-03-02 03:25:37",
        "disabled": false,
        "format": "raw",
        "id": 656,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_redshift",
            "table": "analytics_dwh_dim_storedge_customer_list"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "address_1": "varchar(256)",
            "address_2": "varchar(256)",
            "city": "varchar(128)",
            "country": "varchar(32)",
            "facility_name": "varchar(128)",
            "internal_key": "varchar(128)",
            "logo_id": "varchar(128)",
            "logo_name": "varchar(128)",
            "product_type": "varchar(128)",
            "source": "varchar(9)",
            "state": "varchar(32)",
            "total_units": "bigint",
            "uplid_id": "int",
            "zip": "varchar(32)"
        },
        "created": "2026-04-17 03:32:42",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`\n(\n `internal_key`  varchar(128) , `uplid_id`  int , `source`  varchar(9) , `logo_name`  varchar(128) , `logo_id`  varchar(128) , `facility_name`  varchar(128) , `address_1`  varchar(256) , `address_2`  varchar(256) , `city`  varchar(128) , `state`  varchar(32) , `zip`  varchar(32) , `country`  varchar(32) , `product_type`  varchar(128) , `total_units`  bigint , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_storedge_customer_list/2026-04-17/1776414754'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_storedge_customer_list"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}