Schema Info

Schema Name: sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list

created: 2019-03-02 03:26:18
disabled: False
format: raw
id: 657
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 1717865

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_sparefoot_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(26) , `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_sparefoot_customer_list/2026-04-17/1776413981'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_sparefoot_customer_list/2026-04-17/1776413981
id: 1717865
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(26)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

schema_name_id: 657
schema_scan_id: 162167911
updated: 2026-04-17 03:20:10

Version 1716668

created: 2026-04-16 04:09:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_sparefoot_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(26) , `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_sparefoot_customer_list/2026-04-16/1776330584'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_sparefoot_customer_list/2026-04-16/1776330584
id: 1716668
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(26)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

schema_name_id: 657
schema_scan_id: 162113325
updated: 2026-04-16 04:10:10

Version 1715420

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_sparefoot_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(26) , `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_sparefoot_customer_list/2026-04-15/1776241918'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_sparefoot_customer_list/2026-04-15/1776241918
id: 1715420
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(26)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

schema_name_id: 657
schema_scan_id: 162056270
updated: 2026-04-15 03:32:21

Version 1714247

created: 2026-04-14 03:41:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_sparefoot_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(26) , `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_sparefoot_customer_list/2026-04-14/1776156046'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_sparefoot_customer_list/2026-04-14/1776156046
id: 1714247
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(26)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

schema_name_id: 657
schema_scan_id: 162000815
updated: 2026-04-14 03:41:12

Version 1713003

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_sparefoot_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(26) , `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_sparefoot_customer_list/2026-04-13/1776069550'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_sparefoot_customer_list/2026-04-13/1776069550
id: 1713003
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(26)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

schema_name_id: 657
schema_scan_id: 161942938
updated: 2026-04-13 03:39:32

Version 1711797

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_sparefoot_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(26) , `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_sparefoot_customer_list/2026-04-12/1775982446'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_sparefoot_customer_list/2026-04-12/1775982446
id: 1711797
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(26)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

schema_name_id: 657
schema_scan_id: 161893569
updated: 2026-04-12 03:27:51

Version 1710634

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_sparefoot_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(26) , `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_sparefoot_customer_list/2026-04-11/1775897806'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_sparefoot_customer_list/2026-04-11/1775897806
id: 1710634
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(26)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

schema_name_id: 657
schema_scan_id: 161841863
updated: 2026-04-11 03:57:18

Version 1709493

created: 2026-04-10 04:14:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_sparefoot_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(26) , `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_sparefoot_customer_list/2026-04-10/1775812446'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_sparefoot_customer_list/2026-04-10/1775812446
id: 1709493
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(26)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

schema_name_id: 657
schema_scan_id: 161787383
updated: 2026-04-10 04:14:46

Version 1708307

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_sparefoot_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(26) , `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_sparefoot_customer_list/2026-04-09/1775723375'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_sparefoot_customer_list/2026-04-09/1775723375
id: 1708307
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(26)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

schema_name_id: 657
schema_scan_id: 161730625
updated: 2026-04-09 03:29:55

Version 1707152

created: 2026-04-08 04:18:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_sparefoot_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(26) , `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_sparefoot_customer_list/2026-04-08/1775639872'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_sparefoot_customer_list/2026-04-08/1775639872
id: 1707152
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(26)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

schema_name_id: 657
schema_scan_id: 161677035
updated: 2026-04-08 04:18:28

Version 1705955

created: 2026-04-07 03:54:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_sparefoot_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(26) , `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_sparefoot_customer_list/2026-04-07/1775552072'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_sparefoot_customer_list/2026-04-07/1775552072
id: 1705955
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(26)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

schema_name_id: 657
schema_scan_id: 161619861
updated: 2026-04-07 03:55:00

Version 1704691

created: 2026-04-06 03:40:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_sparefoot_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(26) , `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_sparefoot_customer_list/2026-04-06/1775464832'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_sparefoot_customer_list/2026-04-06/1775464832
id: 1704691
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(26)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

schema_name_id: 657
schema_scan_id: 161561886
updated: 2026-04-06 03:41:09

Version 1703525

created: 2026-04-05 04:04:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_sparefoot_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(26) , `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_sparefoot_customer_list/2026-04-05/1775379857'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_sparefoot_customer_list/2026-04-05/1775379857
id: 1703525
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(26)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

schema_name_id: 657
schema_scan_id: 161516208
updated: 2026-04-05 04:04:47

Version 1702368

created: 2026-04-04 04:02:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_sparefoot_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(26) , `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_sparefoot_customer_list/2026-04-04/1775293358'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_sparefoot_customer_list/2026-04-04/1775293358
id: 1702368
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(26)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

schema_name_id: 657
schema_scan_id: 161461933
updated: 2026-04-04 04:03:00

Version 1701133

created: 2026-04-03 03:35:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_sparefoot_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(26) , `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_sparefoot_customer_list/2026-04-03/1775205303'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_sparefoot_customer_list/2026-04-03/1775205303
id: 1701133
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(26)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

schema_name_id: 657
schema_scan_id: 161402160
updated: 2026-04-03 03:35:38

Schema Scans: 15

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

Scan 162167911

duration: 0:00:12.086999

exit_message:

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

id: 162167911

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(26)",
        "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_sparefoot_customer_list/2026-04-17/1776413981/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_sparefoot_customer_list/2026-04-17/1776413981",
        "key": "raw/dwh_dim_sparefoot_customer_list/2026-04-17/1776413981/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15153502730504409452,
        "service_name": "redshift_unloads",
        "span_id": 17203438941557207156,
        "trace_id": 7734189565753787274
    }
}

running: False
schema_name_id: 657
start_time: 2026-04-17 03:19:58
success: True
trace_id: 7734189565753787274

Scan 162113325

duration: 0:00:12.133612

exit_message:

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

id: 162113325

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(26)",
        "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_sparefoot_customer_list/2026-04-16/1776330584/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_sparefoot_customer_list/2026-04-16/1776330584",
        "key": "raw/dwh_dim_sparefoot_customer_list/2026-04-16/1776330584/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2631416099378529150,
        "service_name": "redshift_unloads",
        "span_id": 3673184000807459966,
        "trace_id": 17681147703006110594
    }
}

running: False
schema_name_id: 657
start_time: 2026-04-16 04:09:58
success: True
trace_id: 17681147703006110594

Scan 162056270

duration: 0:00:14.665753

exit_message:

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

id: 162056270

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(26)",
        "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_sparefoot_customer_list/2026-04-15/1776241918/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_sparefoot_customer_list/2026-04-15/1776241918",
        "key": "raw/dwh_dim_sparefoot_customer_list/2026-04-15/1776241918/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15957621340432593556,
        "service_name": "redshift_unloads",
        "span_id": 10903677042352261332,
        "trace_id": 7461137419967467162
    }
}

running: False
schema_name_id: 657
start_time: 2026-04-15 03:32:06
success: True
trace_id: 7461137419967467162

Scan 162000815

duration: 0:00:11.948694

exit_message:

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

id: 162000815

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(26)",
        "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_sparefoot_customer_list/2026-04-14/1776156046/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_sparefoot_customer_list/2026-04-14/1776156046",
        "key": "raw/dwh_dim_sparefoot_customer_list/2026-04-14/1776156046/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2253812536888045090,
        "service_name": "redshift_unloads",
        "span_id": 13572276465164754469,
        "trace_id": 14927611589029354236
    }
}

running: False
schema_name_id: 657
start_time: 2026-04-14 03:41:00
success: True
trace_id: 14927611589029354236

Scan 161942938

duration: 0:00:14.363196

exit_message:

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

id: 161942938

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(26)",
        "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_sparefoot_customer_list/2026-04-13/1776069550/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_sparefoot_customer_list/2026-04-13/1776069550",
        "key": "raw/dwh_dim_sparefoot_customer_list/2026-04-13/1776069550/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3324248393542473843,
        "service_name": "redshift_unloads",
        "span_id": 17620854888078248375,
        "trace_id": 8798635622384603009
    }
}

running: False
schema_name_id: 657
start_time: 2026-04-13 03:39:17
success: True
trace_id: 8798635622384603009

Scan 161893569

duration: 0:00:11.948119

exit_message:

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

id: 161893569

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(26)",
        "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_sparefoot_customer_list/2026-04-12/1775982446/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_sparefoot_customer_list/2026-04-12/1775982446",
        "key": "raw/dwh_dim_sparefoot_customer_list/2026-04-12/1775982446/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 558578074531578147,
        "service_name": "redshift_unloads",
        "span_id": 5396232234312809819,
        "trace_id": 15917661968374132620
    }
}

running: False
schema_name_id: 657
start_time: 2026-04-12 03:27:39
success: True
trace_id: 15917661968374132620

Scan 161841863

duration: 0:00:14.538307

exit_message:

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

id: 161841863

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(26)",
        "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_sparefoot_customer_list/2026-04-11/1775897806/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_sparefoot_customer_list/2026-04-11/1775897806",
        "key": "raw/dwh_dim_sparefoot_customer_list/2026-04-11/1775897806/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9160138470953917202,
        "service_name": "redshift_unloads",
        "span_id": 10206462939258105359,
        "trace_id": 74801441269341901
    }
}

running: False
schema_name_id: 657
start_time: 2026-04-11 03:57:03
success: True
trace_id: 74801441269341901

Scan 161787383

duration: 0:00:17.260430

exit_message:

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

id: 161787383

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(26)",
        "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_sparefoot_customer_list/2026-04-10/1775812446/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_sparefoot_customer_list/2026-04-10/1775812446",
        "key": "raw/dwh_dim_sparefoot_customer_list/2026-04-10/1775812446/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 18368519244551687114,
        "service_name": "redshift_unloads",
        "span_id": 8750549947743700029,
        "trace_id": 3568735126168596267
    }
}

running: False
schema_name_id: 657
start_time: 2026-04-10 04:14:29
success: True
trace_id: 3568735126168596267

Scan 161730625

duration: 0:00:11.972982

exit_message:

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

id: 161730625

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(26)",
        "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_sparefoot_customer_list/2026-04-09/1775723375/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_sparefoot_customer_list/2026-04-09/1775723375",
        "key": "raw/dwh_dim_sparefoot_customer_list/2026-04-09/1775723375/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13306069198022994900,
        "service_name": "redshift_unloads",
        "span_id": 10090147589278207233,
        "trace_id": 10240348360624154905
    }
}

running: False
schema_name_id: 657
start_time: 2026-04-09 03:29:43
success: True
trace_id: 10240348360624154905

Scan 161677035

duration: 0:00:14.612801

exit_message:

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

id: 161677035

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(26)",
        "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_sparefoot_customer_list/2026-04-08/1775639872/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_sparefoot_customer_list/2026-04-08/1775639872",
        "key": "raw/dwh_dim_sparefoot_customer_list/2026-04-08/1775639872/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5132593445254072835,
        "service_name": "redshift_unloads",
        "span_id": 9389744341795613184,
        "trace_id": 7974224927395414976
    }
}

running: False
schema_name_id: 657
start_time: 2026-04-08 04:18:13
success: True
trace_id: 7974224927395414976

Scan 161619861

duration: 0:00:14.423007

exit_message:

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

id: 161619861

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(26)",
        "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_sparefoot_customer_list/2026-04-07/1775552072/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_sparefoot_customer_list/2026-04-07/1775552072",
        "key": "raw/dwh_dim_sparefoot_customer_list/2026-04-07/1775552072/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10160252027431244673,
        "service_name": "redshift_unloads",
        "span_id": 8199375376368343247,
        "trace_id": 13202961161042435911
    }
}

running: False
schema_name_id: 657
start_time: 2026-04-07 03:54:46
success: True
trace_id: 13202961161042435911

Scan 161561886

duration: 0:00:11.991533

exit_message:

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

id: 161561886

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(26)",
        "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_sparefoot_customer_list/2026-04-06/1775464832/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_sparefoot_customer_list/2026-04-06/1775464832",
        "key": "raw/dwh_dim_sparefoot_customer_list/2026-04-06/1775464832/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5070245860654833036,
        "service_name": "redshift_unloads",
        "span_id": 8870272015985454356,
        "trace_id": 4008255412097487831
    }
}

running: False
schema_name_id: 657
start_time: 2026-04-06 03:40:57
success: True
trace_id: 4008255412097487831

Scan 161516208

duration: 0:00:14.530809

exit_message:

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

id: 161516208

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(26)",
        "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_sparefoot_customer_list/2026-04-05/1775379857/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_sparefoot_customer_list/2026-04-05/1775379857",
        "key": "raw/dwh_dim_sparefoot_customer_list/2026-04-05/1775379857/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14549200705471358691,
        "service_name": "redshift_unloads",
        "span_id": 16448850986220595633,
        "trace_id": 6858778725392532815
    }
}

running: False
schema_name_id: 657
start_time: 2026-04-05 04:04:33
success: True
trace_id: 6858778725392532815

Scan 161461933

duration: 0:00:14.423438

exit_message:

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

id: 161461933

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(26)",
        "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_sparefoot_customer_list/2026-04-04/1775293358/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_sparefoot_customer_list/2026-04-04/1775293358",
        "key": "raw/dwh_dim_sparefoot_customer_list/2026-04-04/1775293358/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11603581369854992433,
        "service_name": "redshift_unloads",
        "span_id": 16964680390817721639,
        "trace_id": 6781798578076329136
    }
}

running: False
schema_name_id: 657
start_time: 2026-04-04 04:02:46
success: True
trace_id: 6781798578076329136

Scan 161402160

duration: 0:00:14.423636

exit_message:

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

id: 161402160

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(26)",
        "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_sparefoot_customer_list/2026-04-03/1775205303/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_sparefoot_customer_list/2026-04-03/1775205303",
        "key": "raw/dwh_dim_sparefoot_customer_list/2026-04-03/1775205303/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8553998306712064591,
        "service_name": "redshift_unloads",
        "span_id": 2354724480407292021,
        "trace_id": 13880811504640397078
    }
}

running: False
schema_name_id: 657
start_time: 2026-04-03 03:35:24
success: True
trace_id: 13880811504640397078

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(26)",
    "source": "varchar(9)",
    "state": "varchar(32)",
    "total_units": "bigint",
    "uplid_id": "int",
    "zip": "varchar(32)"
}

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

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_sparefoot_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(26) , `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_sparefoot_customer_list/2026-04-17/1776413981'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_sparefoot_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:26:18",
        "disabled": false,
        "format": "raw",
        "id": 657,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_redshift",
            "table": "analytics_dwh_dim_sparefoot_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(26)",
            "source": "varchar(9)",
            "state": "varchar(32)",
            "total_units": "bigint",
            "uplid_id": "int",
            "zip": "varchar(32)"
        },
        "created": "2026-04-17 03:19:59",
        "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_sparefoot_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(26) , `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_sparefoot_customer_list/2026-04-17/1776413981'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_sparefoot_customer_list"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}