Schema Info

Schema Name: sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list

created: 2019-03-02 03:29:19
disabled: False
format: raw
id: 659
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 1717879

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_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_biggerfoot_customer_list/2026-04-17/1776414733'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_biggerfoot_customer_list/2026-04-17/1776414733
id: 1717879
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: 659
schema_scan_id: 162167992
updated: 2026-04-17 03:32:44

Version 1716630

created: 2026-04-16 03:55:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_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_biggerfoot_customer_list/2026-04-16/1776329705'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_biggerfoot_customer_list/2026-04-16/1776329705
id: 1716630
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: 659
schema_scan_id: 162112354
updated: 2026-04-16 03:55:33

Version 1715413

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_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_biggerfoot_customer_list/2026-04-15/1776241851'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_biggerfoot_customer_list/2026-04-15/1776241851
id: 1715413
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: 659
schema_scan_id: 162056263
updated: 2026-04-15 03:31:23

Version 1714245

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_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_biggerfoot_customer_list/2026-04-14/1776156003'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_biggerfoot_customer_list/2026-04-14/1776156003
id: 1714245
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: 659
schema_scan_id: 162000813
updated: 2026-04-14 03:40:24

Version 1713001

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_biggerfoot_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_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_biggerfoot_customer_list/2026-04-13/1776069536'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_biggerfoot_customer_list/2026-04-13/1776069536
id: 1713001
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: 659
schema_scan_id: 161942936
updated: 2026-04-13 03:39:20

Version 1711807

created: 2026-04-12 03:41:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_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_biggerfoot_customer_list/2026-04-12/1775983275'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_biggerfoot_customer_list/2026-04-12/1775983275
id: 1711807
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: 659
schema_scan_id: 161893598
updated: 2026-04-12 03:41:42

Version 1710632

created: 2026-04-11 03:55:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_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_biggerfoot_customer_list/2026-04-11/1775897748'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_biggerfoot_customer_list/2026-04-11/1775897748
id: 1710632
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: 659
schema_scan_id: 161841723
updated: 2026-04-11 03:56:10

Version 1709463

created: 2026-04-10 04:02:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_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_biggerfoot_customer_list/2026-04-10/1775811732'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_biggerfoot_customer_list/2026-04-10/1775811732
id: 1709463
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: 659
schema_scan_id: 161787347
updated: 2026-04-10 04:02:36

Version 1708304

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_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_biggerfoot_customer_list/2026-04-09/1775723354'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_biggerfoot_customer_list/2026-04-09/1775723354
id: 1708304
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: 659
schema_scan_id: 161730622
updated: 2026-04-09 03:29:44

Version 1707106

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_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_biggerfoot_customer_list/2026-04-08/1775637311'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_biggerfoot_customer_list/2026-04-08/1775637311
id: 1707106
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: 659
schema_scan_id: 161675815
updated: 2026-04-08 03:35:35

Version 1705963

created: 2026-04-07 04:03:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_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_biggerfoot_customer_list/2026-04-07/1775552607'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_biggerfoot_customer_list/2026-04-07/1775552607
id: 1705963
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: 659
schema_scan_id: 161620880
updated: 2026-04-07 04:03:47

Version 1704716

created: 2026-04-06 04:00:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_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_biggerfoot_customer_list/2026-04-06/1775465931'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_biggerfoot_customer_list/2026-04-06/1775465931
id: 1704716
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: 659
schema_scan_id: 161562838
updated: 2026-04-06 04:00:21

Version 1703492

created: 2026-04-05 03:48:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_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_biggerfoot_customer_list/2026-04-05/1775378919'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_biggerfoot_customer_list/2026-04-05/1775378919
id: 1703492
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: 659
schema_scan_id: 161515147
updated: 2026-04-05 03:49:04

Version 1702359

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_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_biggerfoot_customer_list/2026-04-04/1775292948'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_biggerfoot_customer_list/2026-04-04/1775292948
id: 1702359
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: 659
schema_scan_id: 161460988
updated: 2026-04-04 03:56:19

Version 1701129

created: 2026-04-03 03:34:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_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_biggerfoot_customer_list/2026-04-03/1775205260'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_biggerfoot_customer_list/2026-04-03/1775205260
id: 1701129
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: 659
schema_scan_id: 161402155
updated: 2026-04-03 03:34:56

Schema Scans: 15

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

Scan 162167992

duration: 0:00:14.502206

exit_message:

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

id: 162167992

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_biggerfoot_customer_list/2026-04-17/1776414733/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_biggerfoot_customer_list/2026-04-17/1776414733",
        "key": "raw/dwh_dim_biggerfoot_customer_list/2026-04-17/1776414733/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3344120283926791865,
        "service_name": "redshift_unloads",
        "span_id": 15397058982076975020,
        "trace_id": 9960553714517375608
    }
}

running: False
schema_name_id: 659
start_time: 2026-04-17 03:32:29
success: True
trace_id: 9960553714517375608

Scan 162112354

duration: 0:00:11.955315

exit_message:

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

id: 162112354

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_biggerfoot_customer_list/2026-04-16/1776329705/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_biggerfoot_customer_list/2026-04-16/1776329705",
        "key": "raw/dwh_dim_biggerfoot_customer_list/2026-04-16/1776329705/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12502727725146614559,
        "service_name": "redshift_unloads",
        "span_id": 13522902718646967692,
        "trace_id": 6741018842400749494
    }
}

running: False
schema_name_id: 659
start_time: 2026-04-16 03:55:21
success: True
trace_id: 6741018842400749494

Scan 162056263

duration: 0:00:14.427531

exit_message:

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

id: 162056263

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_biggerfoot_customer_list/2026-04-15/1776241851/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_biggerfoot_customer_list/2026-04-15/1776241851",
        "key": "raw/dwh_dim_biggerfoot_customer_list/2026-04-15/1776241851/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13301204737419572546,
        "service_name": "redshift_unloads",
        "span_id": 7714804955078002080,
        "trace_id": 13478192630835530747
    }
}

running: False
schema_name_id: 659
start_time: 2026-04-15 03:31:08
success: True
trace_id: 13478192630835530747

Scan 162000813

duration: 0:00:11.966335

exit_message:

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

id: 162000813

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_biggerfoot_customer_list/2026-04-14/1776156003/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_biggerfoot_customer_list/2026-04-14/1776156003",
        "key": "raw/dwh_dim_biggerfoot_customer_list/2026-04-14/1776156003/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14451657392669389313,
        "service_name": "redshift_unloads",
        "span_id": 11193598381227977585,
        "trace_id": 4554774503396025979
    }
}

running: False
schema_name_id: 659
start_time: 2026-04-14 03:40:12
success: True
trace_id: 4554774503396025979

Scan 161942936

duration: 0:00:11.928412

exit_message:

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

id: 161942936

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_biggerfoot_customer_list/2026-04-13/1776069536/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_biggerfoot_customer_list/2026-04-13/1776069536",
        "key": "raw/dwh_dim_biggerfoot_customer_list/2026-04-13/1776069536/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8548245901437034196,
        "service_name": "redshift_unloads",
        "span_id": 15379804393698362947,
        "trace_id": 12287803974754898290
    }
}

running: False
schema_name_id: 659
start_time: 2026-04-13 03:39:08
success: True
trace_id: 12287803974754898290

Scan 161893598

duration: 0:00:11.929999

exit_message:

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

id: 161893598

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_biggerfoot_customer_list/2026-04-12/1775983275/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_biggerfoot_customer_list/2026-04-12/1775983275",
        "key": "raw/dwh_dim_biggerfoot_customer_list/2026-04-12/1775983275/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1134573302520380430,
        "service_name": "redshift_unloads",
        "span_id": 13489705709385662111,
        "trace_id": 4481901201883517165
    }
}

running: False
schema_name_id: 659
start_time: 2026-04-12 03:41:30
success: True
trace_id: 4481901201883517165

Scan 161841723

duration: 0:00:11.998813

exit_message:

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

id: 161841723

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_biggerfoot_customer_list/2026-04-11/1775897748/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_biggerfoot_customer_list/2026-04-11/1775897748",
        "key": "raw/dwh_dim_biggerfoot_customer_list/2026-04-11/1775897748/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8425113775734810202,
        "service_name": "redshift_unloads",
        "span_id": 4447844615600316411,
        "trace_id": 1043351264149942792
    }
}

running: False
schema_name_id: 659
start_time: 2026-04-11 03:55:58
success: True
trace_id: 1043351264149942792

Scan 161787347

duration: 0:00:11.853257

exit_message:

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

id: 161787347

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_biggerfoot_customer_list/2026-04-10/1775811732/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_biggerfoot_customer_list/2026-04-10/1775811732",
        "key": "raw/dwh_dim_biggerfoot_customer_list/2026-04-10/1775811732/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7932050087403448212,
        "service_name": "redshift_unloads",
        "span_id": 14720767396182421228,
        "trace_id": 9485849940092964368
    }
}

running: False
schema_name_id: 659
start_time: 2026-04-10 04:02:24
success: True
trace_id: 9485849940092964368

Scan 161730622

duration: 0:00:14.552959

exit_message:

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

id: 161730622

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_biggerfoot_customer_list/2026-04-09/1775723354/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_biggerfoot_customer_list/2026-04-09/1775723354",
        "key": "raw/dwh_dim_biggerfoot_customer_list/2026-04-09/1775723354/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14466864314387306737,
        "service_name": "redshift_unloads",
        "span_id": 15207994981313972910,
        "trace_id": 17327062023038760312
    }
}

running: False
schema_name_id: 659
start_time: 2026-04-09 03:29:30
success: True
trace_id: 17327062023038760312

Scan 161675815

duration: 0:00:14.624691

exit_message:

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

id: 161675815

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_biggerfoot_customer_list/2026-04-08/1775637311/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_biggerfoot_customer_list/2026-04-08/1775637311",
        "key": "raw/dwh_dim_biggerfoot_customer_list/2026-04-08/1775637311/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5271553821080951893,
        "service_name": "redshift_unloads",
        "span_id": 1662379705009510873,
        "trace_id": 11068299638423476713
    }
}

running: False
schema_name_id: 659
start_time: 2026-04-08 03:35:20
success: True
trace_id: 11068299638423476713

Scan 161620880

duration: 0:00:12.120474

exit_message:

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

id: 161620880

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_biggerfoot_customer_list/2026-04-07/1775552607/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_biggerfoot_customer_list/2026-04-07/1775552607",
        "key": "raw/dwh_dim_biggerfoot_customer_list/2026-04-07/1775552607/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15466628010358411077,
        "service_name": "redshift_unloads",
        "span_id": 15577507344334035979,
        "trace_id": 12973140184479293355
    }
}

running: False
schema_name_id: 659
start_time: 2026-04-07 04:03:35
success: True
trace_id: 12973140184479293355

Scan 161562838

duration: 0:00:14.679464

exit_message:

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

id: 161562838

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_biggerfoot_customer_list/2026-04-06/1775465931/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_biggerfoot_customer_list/2026-04-06/1775465931",
        "key": "raw/dwh_dim_biggerfoot_customer_list/2026-04-06/1775465931/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 604501522212682885,
        "service_name": "redshift_unloads",
        "span_id": 10547231542672055514,
        "trace_id": 2959908559010330216
    }
}

running: False
schema_name_id: 659
start_time: 2026-04-06 04:00:07
success: True
trace_id: 2959908559010330216

Scan 161515147

duration: 0:00:11.886261

exit_message:

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

id: 161515147

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_biggerfoot_customer_list/2026-04-05/1775378919/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_biggerfoot_customer_list/2026-04-05/1775378919",
        "key": "raw/dwh_dim_biggerfoot_customer_list/2026-04-05/1775378919/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15160065039093476144,
        "service_name": "redshift_unloads",
        "span_id": 7424069742419517307,
        "trace_id": 330125620761394510
    }
}

running: False
schema_name_id: 659
start_time: 2026-04-05 03:48:52
success: True
trace_id: 330125620761394510

Scan 161460988

duration: 0:00:14.490440

exit_message:

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

id: 161460988

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_biggerfoot_customer_list/2026-04-04/1775292948/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_biggerfoot_customer_list/2026-04-04/1775292948",
        "key": "raw/dwh_dim_biggerfoot_customer_list/2026-04-04/1775292948/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9617382391207303019,
        "service_name": "redshift_unloads",
        "span_id": 866648484793835527,
        "trace_id": 8635558381326460211
    }
}

running: False
schema_name_id: 659
start_time: 2026-04-04 03:56:05
success: True
trace_id: 8635558381326460211

Scan 161402155

duration: 0:00:11.939534

exit_message:

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

id: 161402155

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_biggerfoot_customer_list/2026-04-03/1775205260/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_biggerfoot_customer_list/2026-04-03/1775205260",
        "key": "raw/dwh_dim_biggerfoot_customer_list/2026-04-03/1775205260/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13532874720089511443,
        "service_name": "redshift_unloads",
        "span_id": 2200973434916544270,
        "trace_id": 16257048804791274202
    }
}

running: False
schema_name_id: 659
start_time: 2026-04-03 03:34:45
success: True
trace_id: 16257048804791274202

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:30

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_biggerfoot_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_biggerfoot_customer_list/2026-04-17/1776414733'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_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:29:19",
        "disabled": false,
        "format": "raw",
        "id": 659,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_redshift",
            "table": "analytics_dwh_dim_biggerfoot_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:30",
        "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_biggerfoot_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_biggerfoot_customer_list/2026-04-17/1776414733'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_biggerfoot_customer_list"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}