Schema Info

Schema Name: sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products

created: 2019-03-02 07:04:03
disabled: False
format: raw
id: 661
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 1718115

created: 2026-04-17 07:13:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`\n(\n `uplid_id`  varchar(128) , `storedge_logo_id`  varchar(128) , `storedge_logo_name`  varchar(128) , `storedge_id`  varchar(128) , `storedge_facility_name`  varchar(128) , `storedge_address`  varchar(256) , `sitelink_logo_id`  varchar(128) , `sitelink_logo_name`  varchar(128) , `sitelink_id`  varchar(128) , `sitelink_facility_name`  varchar(128) , `sitelink_address`  varchar(256) , `sparefoot_logo_id`  varchar(128) , `sparefoot_logo_name`  varchar(128) , `sparefoot_id`  varchar(128) , `sparefoot_facility_name`  varchar(128) , `sparefoot_address`  varchar(256) , `storedge_total_units`  int , `sparefoot_total_units`  int , `sitelink_total_units`  int , `products`  varchar(1028) , `logo_id`  varchar(128) , `logo_name`  varchar(128) , `storedge_webworks`  int , `storedge_fms_with_voyager`  int , `storedge_old_launch_template`  int , `sitelink_merchant_services`  int , `storedge_new_build`  int , `storedge_webworks_link`  int , `storedge_webworks_market`  int , `storedge_cubesmart`  int , `sparefoot_marketplace`  int , `storedge_fms`  int , `storedge_cubesmart_with_fms`  int , `sitelink_web_edition`  int , `storedge_webworks_listing_only`  int , `sitelink_standalone`  int , `fms`  int , `mp`  int , `web`  int , `ms`  int , `intersection_type`  varchar(59) , `_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/pl_biggerfoot_uplid_products/2026-04-17/1776428016'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/pl_biggerfoot_uplid_products/2026-04-17/1776428016
id: 1718115
processed: 1

raw_data:

{
    "_origin": "41",
    "fms": "36",
    "intersection_type": "40",
    "logo_id": "20",
    "logo_name": "21",
    "mp": "37",
    "ms": "39",
    "products": "19",
    "sitelink_address": "10",
    "sitelink_facility_name": "9",
    "sitelink_id": "8",
    "sitelink_logo_id": "6",
    "sitelink_logo_name": "7",
    "sitelink_merchant_services": "25",
    "sitelink_standalone": "35",
    "sitelink_total_units": "18",
    "sitelink_web_edition": "33",
    "sparefoot_address": "15",
    "sparefoot_facility_name": "14",
    "sparefoot_id": "13",
    "sparefoot_logo_id": "11",
    "sparefoot_logo_name": "12",
    "sparefoot_marketplace": "30",
    "sparefoot_total_units": "17",
    "storedge_address": "5",
    "storedge_cubesmart": "29",
    "storedge_cubesmart_with_fms": "32",
    "storedge_facility_name": "4",
    "storedge_fms": "31",
    "storedge_fms_with_voyager": "23",
    "storedge_id": "3",
    "storedge_logo_id": "1",
    "storedge_logo_name": "2",
    "storedge_new_build": "26",
    "storedge_old_launch_template": "24",
    "storedge_total_units": "16",
    "storedge_webworks": "22",
    "storedge_webworks_link": "27",
    "storedge_webworks_listing_only": "34",
    "storedge_webworks_market": "28",
    "uplid_id": "0",
    "web": "38"
}

schema_attributes:

{
    "_origin": "string",
    "fms": "int",
    "intersection_type": "varchar(59)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "mp": "int",
    "ms": "int",
    "products": "varchar(1028)",
    "sitelink_address": "varchar(256)",
    "sitelink_facility_name": "varchar(128)",
    "sitelink_id": "varchar(128)",
    "sitelink_logo_id": "varchar(128)",
    "sitelink_logo_name": "varchar(128)",
    "sitelink_merchant_services": "int",
    "sitelink_standalone": "int",
    "sitelink_total_units": "int",
    "sitelink_web_edition": "int",
    "sparefoot_address": "varchar(256)",
    "sparefoot_facility_name": "varchar(128)",
    "sparefoot_id": "varchar(128)",
    "sparefoot_logo_id": "varchar(128)",
    "sparefoot_logo_name": "varchar(128)",
    "sparefoot_marketplace": "int",
    "sparefoot_total_units": "int",
    "storedge_address": "varchar(256)",
    "storedge_cubesmart": "int",
    "storedge_cubesmart_with_fms": "int",
    "storedge_facility_name": "varchar(128)",
    "storedge_fms": "int",
    "storedge_fms_with_voyager": "int",
    "storedge_id": "varchar(128)",
    "storedge_logo_id": "varchar(128)",
    "storedge_logo_name": "varchar(128)",
    "storedge_new_build": "int",
    "storedge_old_launch_template": "int",
    "storedge_total_units": "int",
    "storedge_webworks": "int",
    "storedge_webworks_link": "int",
    "storedge_webworks_listing_only": "int",
    "storedge_webworks_market": "int",
    "uplid_id": "varchar(128)",
    "web": "int"
}

schema_name_id: 661
schema_scan_id: 162173120
updated: 2026-04-17 07:14:00

Version 1716900

created: 2026-04-16 07:21:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`\n(\n `uplid_id`  varchar(128) , `storedge_logo_id`  varchar(128) , `storedge_logo_name`  varchar(128) , `storedge_id`  varchar(128) , `storedge_facility_name`  varchar(128) , `storedge_address`  varchar(256) , `sitelink_logo_id`  varchar(128) , `sitelink_logo_name`  varchar(128) , `sitelink_id`  varchar(128) , `sitelink_facility_name`  varchar(128) , `sitelink_address`  varchar(256) , `sparefoot_logo_id`  varchar(128) , `sparefoot_logo_name`  varchar(128) , `sparefoot_id`  varchar(128) , `sparefoot_facility_name`  varchar(128) , `sparefoot_address`  varchar(256) , `storedge_total_units`  int , `sparefoot_total_units`  int , `sitelink_total_units`  int , `products`  varchar(1028) , `logo_id`  varchar(128) , `logo_name`  varchar(128) , `storedge_webworks`  int , `storedge_fms_with_voyager`  int , `storedge_old_launch_template`  int , `sitelink_merchant_services`  int , `storedge_new_build`  int , `storedge_webworks_link`  int , `storedge_webworks_market`  int , `storedge_cubesmart`  int , `sparefoot_marketplace`  int , `storedge_fms`  int , `storedge_cubesmart_with_fms`  int , `sitelink_web_edition`  int , `storedge_webworks_listing_only`  int , `sitelink_standalone`  int , `fms`  int , `mp`  int , `web`  int , `ms`  int , `intersection_type`  varchar(59) , `_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/pl_biggerfoot_uplid_products/2026-04-16/1776342049'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/pl_biggerfoot_uplid_products/2026-04-16/1776342049
id: 1716900
processed: 1

raw_data:

{
    "_origin": "41",
    "fms": "36",
    "intersection_type": "40",
    "logo_id": "20",
    "logo_name": "21",
    "mp": "37",
    "ms": "39",
    "products": "19",
    "sitelink_address": "10",
    "sitelink_facility_name": "9",
    "sitelink_id": "8",
    "sitelink_logo_id": "6",
    "sitelink_logo_name": "7",
    "sitelink_merchant_services": "25",
    "sitelink_standalone": "35",
    "sitelink_total_units": "18",
    "sitelink_web_edition": "33",
    "sparefoot_address": "15",
    "sparefoot_facility_name": "14",
    "sparefoot_id": "13",
    "sparefoot_logo_id": "11",
    "sparefoot_logo_name": "12",
    "sparefoot_marketplace": "30",
    "sparefoot_total_units": "17",
    "storedge_address": "5",
    "storedge_cubesmart": "29",
    "storedge_cubesmart_with_fms": "32",
    "storedge_facility_name": "4",
    "storedge_fms": "31",
    "storedge_fms_with_voyager": "23",
    "storedge_id": "3",
    "storedge_logo_id": "1",
    "storedge_logo_name": "2",
    "storedge_new_build": "26",
    "storedge_old_launch_template": "24",
    "storedge_total_units": "16",
    "storedge_webworks": "22",
    "storedge_webworks_link": "27",
    "storedge_webworks_listing_only": "34",
    "storedge_webworks_market": "28",
    "uplid_id": "0",
    "web": "38"
}

schema_attributes:

{
    "_origin": "string",
    "fms": "int",
    "intersection_type": "varchar(59)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "mp": "int",
    "ms": "int",
    "products": "varchar(1028)",
    "sitelink_address": "varchar(256)",
    "sitelink_facility_name": "varchar(128)",
    "sitelink_id": "varchar(128)",
    "sitelink_logo_id": "varchar(128)",
    "sitelink_logo_name": "varchar(128)",
    "sitelink_merchant_services": "int",
    "sitelink_standalone": "int",
    "sitelink_total_units": "int",
    "sitelink_web_edition": "int",
    "sparefoot_address": "varchar(256)",
    "sparefoot_facility_name": "varchar(128)",
    "sparefoot_id": "varchar(128)",
    "sparefoot_logo_id": "varchar(128)",
    "sparefoot_logo_name": "varchar(128)",
    "sparefoot_marketplace": "int",
    "sparefoot_total_units": "int",
    "storedge_address": "varchar(256)",
    "storedge_cubesmart": "int",
    "storedge_cubesmart_with_fms": "int",
    "storedge_facility_name": "varchar(128)",
    "storedge_fms": "int",
    "storedge_fms_with_voyager": "int",
    "storedge_id": "varchar(128)",
    "storedge_logo_id": "varchar(128)",
    "storedge_logo_name": "varchar(128)",
    "storedge_new_build": "int",
    "storedge_old_launch_template": "int",
    "storedge_total_units": "int",
    "storedge_webworks": "int",
    "storedge_webworks_link": "int",
    "storedge_webworks_listing_only": "int",
    "storedge_webworks_market": "int",
    "uplid_id": "varchar(128)",
    "web": "int"
}

schema_name_id: 661
schema_scan_id: 162117444
updated: 2026-04-16 07:21:22

Version 1715685

created: 2026-04-15 07:11:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`\n(\n `uplid_id`  varchar(128) , `storedge_logo_id`  varchar(128) , `storedge_logo_name`  varchar(128) , `storedge_id`  varchar(128) , `storedge_facility_name`  varchar(128) , `storedge_address`  varchar(256) , `sitelink_logo_id`  varchar(128) , `sitelink_logo_name`  varchar(128) , `sitelink_id`  varchar(128) , `sitelink_facility_name`  varchar(128) , `sitelink_address`  varchar(256) , `sparefoot_logo_id`  varchar(128) , `sparefoot_logo_name`  varchar(128) , `sparefoot_id`  varchar(128) , `sparefoot_facility_name`  varchar(128) , `sparefoot_address`  varchar(256) , `storedge_total_units`  int , `sparefoot_total_units`  int , `sitelink_total_units`  int , `products`  varchar(1028) , `logo_id`  varchar(128) , `logo_name`  varchar(128) , `storedge_webworks`  int , `storedge_fms_with_voyager`  int , `storedge_old_launch_template`  int , `sitelink_merchant_services`  int , `storedge_new_build`  int , `storedge_webworks_link`  int , `storedge_webworks_market`  int , `storedge_cubesmart`  int , `sparefoot_marketplace`  int , `storedge_fms`  int , `storedge_cubesmart_with_fms`  int , `sitelink_web_edition`  int , `storedge_webworks_listing_only`  int , `sitelink_standalone`  int , `fms`  int , `mp`  int , `web`  int , `ms`  int , `intersection_type`  varchar(59) , `_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/pl_biggerfoot_uplid_products/2026-04-15/1776255000'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/pl_biggerfoot_uplid_products/2026-04-15/1776255000
id: 1715685
processed: 1

raw_data:

{
    "_origin": "41",
    "fms": "36",
    "intersection_type": "40",
    "logo_id": "20",
    "logo_name": "21",
    "mp": "37",
    "ms": "39",
    "products": "19",
    "sitelink_address": "10",
    "sitelink_facility_name": "9",
    "sitelink_id": "8",
    "sitelink_logo_id": "6",
    "sitelink_logo_name": "7",
    "sitelink_merchant_services": "25",
    "sitelink_standalone": "35",
    "sitelink_total_units": "18",
    "sitelink_web_edition": "33",
    "sparefoot_address": "15",
    "sparefoot_facility_name": "14",
    "sparefoot_id": "13",
    "sparefoot_logo_id": "11",
    "sparefoot_logo_name": "12",
    "sparefoot_marketplace": "30",
    "sparefoot_total_units": "17",
    "storedge_address": "5",
    "storedge_cubesmart": "29",
    "storedge_cubesmart_with_fms": "32",
    "storedge_facility_name": "4",
    "storedge_fms": "31",
    "storedge_fms_with_voyager": "23",
    "storedge_id": "3",
    "storedge_logo_id": "1",
    "storedge_logo_name": "2",
    "storedge_new_build": "26",
    "storedge_old_launch_template": "24",
    "storedge_total_units": "16",
    "storedge_webworks": "22",
    "storedge_webworks_link": "27",
    "storedge_webworks_listing_only": "34",
    "storedge_webworks_market": "28",
    "uplid_id": "0",
    "web": "38"
}

schema_attributes:

{
    "_origin": "string",
    "fms": "int",
    "intersection_type": "varchar(59)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "mp": "int",
    "ms": "int",
    "products": "varchar(1028)",
    "sitelink_address": "varchar(256)",
    "sitelink_facility_name": "varchar(128)",
    "sitelink_id": "varchar(128)",
    "sitelink_logo_id": "varchar(128)",
    "sitelink_logo_name": "varchar(128)",
    "sitelink_merchant_services": "int",
    "sitelink_standalone": "int",
    "sitelink_total_units": "int",
    "sitelink_web_edition": "int",
    "sparefoot_address": "varchar(256)",
    "sparefoot_facility_name": "varchar(128)",
    "sparefoot_id": "varchar(128)",
    "sparefoot_logo_id": "varchar(128)",
    "sparefoot_logo_name": "varchar(128)",
    "sparefoot_marketplace": "int",
    "sparefoot_total_units": "int",
    "storedge_address": "varchar(256)",
    "storedge_cubesmart": "int",
    "storedge_cubesmart_with_fms": "int",
    "storedge_facility_name": "varchar(128)",
    "storedge_fms": "int",
    "storedge_fms_with_voyager": "int",
    "storedge_id": "varchar(128)",
    "storedge_logo_id": "varchar(128)",
    "storedge_logo_name": "varchar(128)",
    "storedge_new_build": "int",
    "storedge_old_launch_template": "int",
    "storedge_total_units": "int",
    "storedge_webworks": "int",
    "storedge_webworks_link": "int",
    "storedge_webworks_listing_only": "int",
    "storedge_webworks_market": "int",
    "uplid_id": "varchar(128)",
    "web": "int"
}

schema_name_id: 661
schema_scan_id: 162061840
updated: 2026-04-15 07:12:12

Version 1714508

created: 2026-04-14 07:21:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`\n(\n `uplid_id`  varchar(128) , `storedge_logo_id`  varchar(128) , `storedge_logo_name`  varchar(128) , `storedge_id`  varchar(128) , `storedge_facility_name`  varchar(128) , `storedge_address`  varchar(256) , `sitelink_logo_id`  varchar(128) , `sitelink_logo_name`  varchar(128) , `sitelink_id`  varchar(128) , `sitelink_facility_name`  varchar(128) , `sitelink_address`  varchar(256) , `sparefoot_logo_id`  varchar(128) , `sparefoot_logo_name`  varchar(128) , `sparefoot_id`  varchar(128) , `sparefoot_facility_name`  varchar(128) , `sparefoot_address`  varchar(256) , `storedge_total_units`  int , `sparefoot_total_units`  int , `sitelink_total_units`  int , `products`  varchar(1028) , `logo_id`  varchar(128) , `logo_name`  varchar(128) , `storedge_webworks`  int , `storedge_fms_with_voyager`  int , `storedge_old_launch_template`  int , `sitelink_merchant_services`  int , `storedge_new_build`  int , `storedge_webworks_link`  int , `storedge_webworks_market`  int , `storedge_cubesmart`  int , `sparefoot_marketplace`  int , `storedge_fms`  int , `storedge_cubesmart_with_fms`  int , `sitelink_web_edition`  int , `storedge_webworks_listing_only`  int , `sitelink_standalone`  int , `fms`  int , `mp`  int , `web`  int , `ms`  int , `intersection_type`  varchar(59) , `_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/pl_biggerfoot_uplid_products/2026-04-14/1776169280'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/pl_biggerfoot_uplid_products/2026-04-14/1776169280
id: 1714508
processed: 1

raw_data:

{
    "_origin": "41",
    "fms": "36",
    "intersection_type": "40",
    "logo_id": "20",
    "logo_name": "21",
    "mp": "37",
    "ms": "39",
    "products": "19",
    "sitelink_address": "10",
    "sitelink_facility_name": "9",
    "sitelink_id": "8",
    "sitelink_logo_id": "6",
    "sitelink_logo_name": "7",
    "sitelink_merchant_services": "25",
    "sitelink_standalone": "35",
    "sitelink_total_units": "18",
    "sitelink_web_edition": "33",
    "sparefoot_address": "15",
    "sparefoot_facility_name": "14",
    "sparefoot_id": "13",
    "sparefoot_logo_id": "11",
    "sparefoot_logo_name": "12",
    "sparefoot_marketplace": "30",
    "sparefoot_total_units": "17",
    "storedge_address": "5",
    "storedge_cubesmart": "29",
    "storedge_cubesmart_with_fms": "32",
    "storedge_facility_name": "4",
    "storedge_fms": "31",
    "storedge_fms_with_voyager": "23",
    "storedge_id": "3",
    "storedge_logo_id": "1",
    "storedge_logo_name": "2",
    "storedge_new_build": "26",
    "storedge_old_launch_template": "24",
    "storedge_total_units": "16",
    "storedge_webworks": "22",
    "storedge_webworks_link": "27",
    "storedge_webworks_listing_only": "34",
    "storedge_webworks_market": "28",
    "uplid_id": "0",
    "web": "38"
}

schema_attributes:

{
    "_origin": "string",
    "fms": "int",
    "intersection_type": "varchar(59)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "mp": "int",
    "ms": "int",
    "products": "varchar(1028)",
    "sitelink_address": "varchar(256)",
    "sitelink_facility_name": "varchar(128)",
    "sitelink_id": "varchar(128)",
    "sitelink_logo_id": "varchar(128)",
    "sitelink_logo_name": "varchar(128)",
    "sitelink_merchant_services": "int",
    "sitelink_standalone": "int",
    "sitelink_total_units": "int",
    "sitelink_web_edition": "int",
    "sparefoot_address": "varchar(256)",
    "sparefoot_facility_name": "varchar(128)",
    "sparefoot_id": "varchar(128)",
    "sparefoot_logo_id": "varchar(128)",
    "sparefoot_logo_name": "varchar(128)",
    "sparefoot_marketplace": "int",
    "sparefoot_total_units": "int",
    "storedge_address": "varchar(256)",
    "storedge_cubesmart": "int",
    "storedge_cubesmart_with_fms": "int",
    "storedge_facility_name": "varchar(128)",
    "storedge_fms": "int",
    "storedge_fms_with_voyager": "int",
    "storedge_id": "varchar(128)",
    "storedge_logo_id": "varchar(128)",
    "storedge_logo_name": "varchar(128)",
    "storedge_new_build": "int",
    "storedge_old_launch_template": "int",
    "storedge_total_units": "int",
    "storedge_webworks": "int",
    "storedge_webworks_link": "int",
    "storedge_webworks_listing_only": "int",
    "storedge_webworks_market": "int",
    "uplid_id": "varchar(128)",
    "web": "int"
}

schema_name_id: 661
schema_scan_id: 162006474
updated: 2026-04-14 07:21:43

Version 1713291

created: 2026-04-13 07:28:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`\n(\n `uplid_id`  varchar(128) , `storedge_logo_id`  varchar(128) , `storedge_logo_name`  varchar(128) , `storedge_id`  varchar(128) , `storedge_facility_name`  varchar(128) , `storedge_address`  varchar(256) , `sitelink_logo_id`  varchar(128) , `sitelink_logo_name`  varchar(128) , `sitelink_id`  varchar(128) , `sitelink_facility_name`  varchar(128) , `sitelink_address`  varchar(256) , `sparefoot_logo_id`  varchar(128) , `sparefoot_logo_name`  varchar(128) , `sparefoot_id`  varchar(128) , `sparefoot_facility_name`  varchar(128) , `sparefoot_address`  varchar(256) , `storedge_total_units`  int , `sparefoot_total_units`  int , `sitelink_total_units`  int , `products`  varchar(1028) , `logo_id`  varchar(128) , `logo_name`  varchar(128) , `storedge_webworks`  int , `storedge_fms_with_voyager`  int , `storedge_old_launch_template`  int , `sitelink_merchant_services`  int , `storedge_new_build`  int , `storedge_webworks_link`  int , `storedge_webworks_market`  int , `storedge_cubesmart`  int , `sparefoot_marketplace`  int , `storedge_fms`  int , `storedge_cubesmart_with_fms`  int , `sitelink_web_edition`  int , `storedge_webworks_listing_only`  int , `sitelink_standalone`  int , `fms`  int , `mp`  int , `web`  int , `ms`  int , `intersection_type`  varchar(59) , `_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/pl_biggerfoot_uplid_products/2026-04-13/1776083270'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/pl_biggerfoot_uplid_products/2026-04-13/1776083270
id: 1713291
processed: 1

raw_data:

{
    "_origin": "41",
    "fms": "36",
    "intersection_type": "40",
    "logo_id": "20",
    "logo_name": "21",
    "mp": "37",
    "ms": "39",
    "products": "19",
    "sitelink_address": "10",
    "sitelink_facility_name": "9",
    "sitelink_id": "8",
    "sitelink_logo_id": "6",
    "sitelink_logo_name": "7",
    "sitelink_merchant_services": "25",
    "sitelink_standalone": "35",
    "sitelink_total_units": "18",
    "sitelink_web_edition": "33",
    "sparefoot_address": "15",
    "sparefoot_facility_name": "14",
    "sparefoot_id": "13",
    "sparefoot_logo_id": "11",
    "sparefoot_logo_name": "12",
    "sparefoot_marketplace": "30",
    "sparefoot_total_units": "17",
    "storedge_address": "5",
    "storedge_cubesmart": "29",
    "storedge_cubesmart_with_fms": "32",
    "storedge_facility_name": "4",
    "storedge_fms": "31",
    "storedge_fms_with_voyager": "23",
    "storedge_id": "3",
    "storedge_logo_id": "1",
    "storedge_logo_name": "2",
    "storedge_new_build": "26",
    "storedge_old_launch_template": "24",
    "storedge_total_units": "16",
    "storedge_webworks": "22",
    "storedge_webworks_link": "27",
    "storedge_webworks_listing_only": "34",
    "storedge_webworks_market": "28",
    "uplid_id": "0",
    "web": "38"
}

schema_attributes:

{
    "_origin": "string",
    "fms": "int",
    "intersection_type": "varchar(59)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "mp": "int",
    "ms": "int",
    "products": "varchar(1028)",
    "sitelink_address": "varchar(256)",
    "sitelink_facility_name": "varchar(128)",
    "sitelink_id": "varchar(128)",
    "sitelink_logo_id": "varchar(128)",
    "sitelink_logo_name": "varchar(128)",
    "sitelink_merchant_services": "int",
    "sitelink_standalone": "int",
    "sitelink_total_units": "int",
    "sitelink_web_edition": "int",
    "sparefoot_address": "varchar(256)",
    "sparefoot_facility_name": "varchar(128)",
    "sparefoot_id": "varchar(128)",
    "sparefoot_logo_id": "varchar(128)",
    "sparefoot_logo_name": "varchar(128)",
    "sparefoot_marketplace": "int",
    "sparefoot_total_units": "int",
    "storedge_address": "varchar(256)",
    "storedge_cubesmart": "int",
    "storedge_cubesmart_with_fms": "int",
    "storedge_facility_name": "varchar(128)",
    "storedge_fms": "int",
    "storedge_fms_with_voyager": "int",
    "storedge_id": "varchar(128)",
    "storedge_logo_id": "varchar(128)",
    "storedge_logo_name": "varchar(128)",
    "storedge_new_build": "int",
    "storedge_old_launch_template": "int",
    "storedge_total_units": "int",
    "storedge_webworks": "int",
    "storedge_webworks_link": "int",
    "storedge_webworks_listing_only": "int",
    "storedge_webworks_market": "int",
    "uplid_id": "varchar(128)",
    "web": "int"
}

schema_name_id: 661
schema_scan_id: 161948470
updated: 2026-04-13 07:28:12

Version 1712103

created: 2026-04-12 07:21:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`\n(\n `uplid_id`  varchar(128) , `storedge_logo_id`  varchar(128) , `storedge_logo_name`  varchar(128) , `storedge_id`  varchar(128) , `storedge_facility_name`  varchar(128) , `storedge_address`  varchar(256) , `sitelink_logo_id`  varchar(128) , `sitelink_logo_name`  varchar(128) , `sitelink_id`  varchar(128) , `sitelink_facility_name`  varchar(128) , `sitelink_address`  varchar(256) , `sparefoot_logo_id`  varchar(128) , `sparefoot_logo_name`  varchar(128) , `sparefoot_id`  varchar(128) , `sparefoot_facility_name`  varchar(128) , `sparefoot_address`  varchar(256) , `storedge_total_units`  int , `sparefoot_total_units`  int , `sitelink_total_units`  int , `products`  varchar(1028) , `logo_id`  varchar(128) , `logo_name`  varchar(128) , `storedge_webworks`  int , `storedge_fms_with_voyager`  int , `storedge_old_launch_template`  int , `sitelink_merchant_services`  int , `storedge_new_build`  int , `storedge_webworks_link`  int , `storedge_webworks_market`  int , `storedge_cubesmart`  int , `sparefoot_marketplace`  int , `storedge_fms`  int , `storedge_cubesmart_with_fms`  int , `sitelink_web_edition`  int , `storedge_webworks_listing_only`  int , `sitelink_standalone`  int , `fms`  int , `mp`  int , `web`  int , `ms`  int , `intersection_type`  varchar(59) , `_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/pl_biggerfoot_uplid_products/2026-04-12/1775996448'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/pl_biggerfoot_uplid_products/2026-04-12/1775996448
id: 1712103
processed: 1

raw_data:

{
    "_origin": "41",
    "fms": "36",
    "intersection_type": "40",
    "logo_id": "20",
    "logo_name": "21",
    "mp": "37",
    "ms": "39",
    "products": "19",
    "sitelink_address": "10",
    "sitelink_facility_name": "9",
    "sitelink_id": "8",
    "sitelink_logo_id": "6",
    "sitelink_logo_name": "7",
    "sitelink_merchant_services": "25",
    "sitelink_standalone": "35",
    "sitelink_total_units": "18",
    "sitelink_web_edition": "33",
    "sparefoot_address": "15",
    "sparefoot_facility_name": "14",
    "sparefoot_id": "13",
    "sparefoot_logo_id": "11",
    "sparefoot_logo_name": "12",
    "sparefoot_marketplace": "30",
    "sparefoot_total_units": "17",
    "storedge_address": "5",
    "storedge_cubesmart": "29",
    "storedge_cubesmart_with_fms": "32",
    "storedge_facility_name": "4",
    "storedge_fms": "31",
    "storedge_fms_with_voyager": "23",
    "storedge_id": "3",
    "storedge_logo_id": "1",
    "storedge_logo_name": "2",
    "storedge_new_build": "26",
    "storedge_old_launch_template": "24",
    "storedge_total_units": "16",
    "storedge_webworks": "22",
    "storedge_webworks_link": "27",
    "storedge_webworks_listing_only": "34",
    "storedge_webworks_market": "28",
    "uplid_id": "0",
    "web": "38"
}

schema_attributes:

{
    "_origin": "string",
    "fms": "int",
    "intersection_type": "varchar(59)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "mp": "int",
    "ms": "int",
    "products": "varchar(1028)",
    "sitelink_address": "varchar(256)",
    "sitelink_facility_name": "varchar(128)",
    "sitelink_id": "varchar(128)",
    "sitelink_logo_id": "varchar(128)",
    "sitelink_logo_name": "varchar(128)",
    "sitelink_merchant_services": "int",
    "sitelink_standalone": "int",
    "sitelink_total_units": "int",
    "sitelink_web_edition": "int",
    "sparefoot_address": "varchar(256)",
    "sparefoot_facility_name": "varchar(128)",
    "sparefoot_id": "varchar(128)",
    "sparefoot_logo_id": "varchar(128)",
    "sparefoot_logo_name": "varchar(128)",
    "sparefoot_marketplace": "int",
    "sparefoot_total_units": "int",
    "storedge_address": "varchar(256)",
    "storedge_cubesmart": "int",
    "storedge_cubesmart_with_fms": "int",
    "storedge_facility_name": "varchar(128)",
    "storedge_fms": "int",
    "storedge_fms_with_voyager": "int",
    "storedge_id": "varchar(128)",
    "storedge_logo_id": "varchar(128)",
    "storedge_logo_name": "varchar(128)",
    "storedge_new_build": "int",
    "storedge_old_launch_template": "int",
    "storedge_total_units": "int",
    "storedge_webworks": "int",
    "storedge_webworks_link": "int",
    "storedge_webworks_listing_only": "int",
    "storedge_webworks_market": "int",
    "uplid_id": "varchar(128)",
    "web": "int"
}

schema_name_id: 661
schema_scan_id: 161899610
updated: 2026-04-12 07:21:13

Version 1710796

created: 2026-04-11 06:03:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`\n(\n `uplid_id`  varchar(128) , `storedge_logo_id`  varchar(128) , `storedge_logo_name`  varchar(128) , `storedge_id`  varchar(128) , `storedge_facility_name`  varchar(128) , `storedge_address`  varchar(256) , `sitelink_logo_id`  varchar(128) , `sitelink_logo_name`  varchar(128) , `sitelink_id`  varchar(128) , `sitelink_facility_name`  varchar(128) , `sitelink_address`  varchar(256) , `sparefoot_logo_id`  varchar(128) , `sparefoot_logo_name`  varchar(128) , `sparefoot_id`  varchar(128) , `sparefoot_facility_name`  varchar(128) , `sparefoot_address`  varchar(256) , `storedge_total_units`  int , `sparefoot_total_units`  int , `sitelink_total_units`  int , `products`  varchar(1028) , `logo_id`  varchar(128) , `logo_name`  varchar(128) , `storedge_webworks`  int , `storedge_fms_with_voyager`  int , `storedge_old_launch_template`  int , `sitelink_merchant_services`  int , `storedge_new_build`  int , `storedge_webworks_link`  int , `storedge_webworks_market`  int , `storedge_cubesmart`  int , `sparefoot_marketplace`  int , `storedge_fms`  int , `storedge_cubesmart_with_fms`  int , `sitelink_web_edition`  int , `storedge_webworks_listing_only`  int , `sitelink_standalone`  int , `fms`  int , `mp`  int , `web`  int , `ms`  int , `intersection_type`  varchar(59) , `_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/pl_biggerfoot_uplid_products/2026-04-11/1775905383'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/pl_biggerfoot_uplid_products/2026-04-11/1775905383
id: 1710796
processed: 1

raw_data:

{
    "_origin": "41",
    "fms": "36",
    "intersection_type": "40",
    "logo_id": "20",
    "logo_name": "21",
    "mp": "37",
    "ms": "39",
    "products": "19",
    "sitelink_address": "10",
    "sitelink_facility_name": "9",
    "sitelink_id": "8",
    "sitelink_logo_id": "6",
    "sitelink_logo_name": "7",
    "sitelink_merchant_services": "25",
    "sitelink_standalone": "35",
    "sitelink_total_units": "18",
    "sitelink_web_edition": "33",
    "sparefoot_address": "15",
    "sparefoot_facility_name": "14",
    "sparefoot_id": "13",
    "sparefoot_logo_id": "11",
    "sparefoot_logo_name": "12",
    "sparefoot_marketplace": "30",
    "sparefoot_total_units": "17",
    "storedge_address": "5",
    "storedge_cubesmart": "29",
    "storedge_cubesmart_with_fms": "32",
    "storedge_facility_name": "4",
    "storedge_fms": "31",
    "storedge_fms_with_voyager": "23",
    "storedge_id": "3",
    "storedge_logo_id": "1",
    "storedge_logo_name": "2",
    "storedge_new_build": "26",
    "storedge_old_launch_template": "24",
    "storedge_total_units": "16",
    "storedge_webworks": "22",
    "storedge_webworks_link": "27",
    "storedge_webworks_listing_only": "34",
    "storedge_webworks_market": "28",
    "uplid_id": "0",
    "web": "38"
}

schema_attributes:

{
    "_origin": "string",
    "fms": "int",
    "intersection_type": "varchar(59)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "mp": "int",
    "ms": "int",
    "products": "varchar(1028)",
    "sitelink_address": "varchar(256)",
    "sitelink_facility_name": "varchar(128)",
    "sitelink_id": "varchar(128)",
    "sitelink_logo_id": "varchar(128)",
    "sitelink_logo_name": "varchar(128)",
    "sitelink_merchant_services": "int",
    "sitelink_standalone": "int",
    "sitelink_total_units": "int",
    "sitelink_web_edition": "int",
    "sparefoot_address": "varchar(256)",
    "sparefoot_facility_name": "varchar(128)",
    "sparefoot_id": "varchar(128)",
    "sparefoot_logo_id": "varchar(128)",
    "sparefoot_logo_name": "varchar(128)",
    "sparefoot_marketplace": "int",
    "sparefoot_total_units": "int",
    "storedge_address": "varchar(256)",
    "storedge_cubesmart": "int",
    "storedge_cubesmart_with_fms": "int",
    "storedge_facility_name": "varchar(128)",
    "storedge_fms": "int",
    "storedge_fms_with_voyager": "int",
    "storedge_id": "varchar(128)",
    "storedge_logo_id": "varchar(128)",
    "storedge_logo_name": "varchar(128)",
    "storedge_new_build": "int",
    "storedge_old_launch_template": "int",
    "storedge_total_units": "int",
    "storedge_webworks": "int",
    "storedge_webworks_link": "int",
    "storedge_webworks_listing_only": "int",
    "storedge_webworks_market": "int",
    "uplid_id": "varchar(128)",
    "web": "int"
}

schema_name_id: 661
schema_scan_id: 161845241
updated: 2026-04-11 06:03:30

Version 1709695

created: 2026-04-10 07:13:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`\n(\n `uplid_id`  varchar(128) , `storedge_logo_id`  varchar(128) , `storedge_logo_name`  varchar(128) , `storedge_id`  varchar(128) , `storedge_facility_name`  varchar(128) , `storedge_address`  varchar(256) , `sitelink_logo_id`  varchar(128) , `sitelink_logo_name`  varchar(128) , `sitelink_id`  varchar(128) , `sitelink_facility_name`  varchar(128) , `sitelink_address`  varchar(256) , `sparefoot_logo_id`  varchar(128) , `sparefoot_logo_name`  varchar(128) , `sparefoot_id`  varchar(128) , `sparefoot_facility_name`  varchar(128) , `sparefoot_address`  varchar(256) , `storedge_total_units`  int , `sparefoot_total_units`  int , `sitelink_total_units`  int , `products`  varchar(1028) , `logo_id`  varchar(128) , `logo_name`  varchar(128) , `storedge_webworks`  int , `storedge_fms_with_voyager`  int , `storedge_old_launch_template`  int , `sitelink_merchant_services`  int , `storedge_new_build`  int , `storedge_webworks_link`  int , `storedge_webworks_market`  int , `storedge_cubesmart`  int , `sparefoot_marketplace`  int , `storedge_fms`  int , `storedge_cubesmart_with_fms`  int , `sitelink_web_edition`  int , `storedge_webworks_listing_only`  int , `sitelink_standalone`  int , `fms`  int , `mp`  int , `web`  int , `ms`  int , `intersection_type`  varchar(59) , `_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/pl_biggerfoot_uplid_products/2026-04-10/1775823213'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/pl_biggerfoot_uplid_products/2026-04-10/1775823213
id: 1709695
processed: 1

raw_data:

{
    "_origin": "41",
    "fms": "36",
    "intersection_type": "40",
    "logo_id": "20",
    "logo_name": "21",
    "mp": "37",
    "ms": "39",
    "products": "19",
    "sitelink_address": "10",
    "sitelink_facility_name": "9",
    "sitelink_id": "8",
    "sitelink_logo_id": "6",
    "sitelink_logo_name": "7",
    "sitelink_merchant_services": "25",
    "sitelink_standalone": "35",
    "sitelink_total_units": "18",
    "sitelink_web_edition": "33",
    "sparefoot_address": "15",
    "sparefoot_facility_name": "14",
    "sparefoot_id": "13",
    "sparefoot_logo_id": "11",
    "sparefoot_logo_name": "12",
    "sparefoot_marketplace": "30",
    "sparefoot_total_units": "17",
    "storedge_address": "5",
    "storedge_cubesmart": "29",
    "storedge_cubesmart_with_fms": "32",
    "storedge_facility_name": "4",
    "storedge_fms": "31",
    "storedge_fms_with_voyager": "23",
    "storedge_id": "3",
    "storedge_logo_id": "1",
    "storedge_logo_name": "2",
    "storedge_new_build": "26",
    "storedge_old_launch_template": "24",
    "storedge_total_units": "16",
    "storedge_webworks": "22",
    "storedge_webworks_link": "27",
    "storedge_webworks_listing_only": "34",
    "storedge_webworks_market": "28",
    "uplid_id": "0",
    "web": "38"
}

schema_attributes:

{
    "_origin": "string",
    "fms": "int",
    "intersection_type": "varchar(59)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "mp": "int",
    "ms": "int",
    "products": "varchar(1028)",
    "sitelink_address": "varchar(256)",
    "sitelink_facility_name": "varchar(128)",
    "sitelink_id": "varchar(128)",
    "sitelink_logo_id": "varchar(128)",
    "sitelink_logo_name": "varchar(128)",
    "sitelink_merchant_services": "int",
    "sitelink_standalone": "int",
    "sitelink_total_units": "int",
    "sitelink_web_edition": "int",
    "sparefoot_address": "varchar(256)",
    "sparefoot_facility_name": "varchar(128)",
    "sparefoot_id": "varchar(128)",
    "sparefoot_logo_id": "varchar(128)",
    "sparefoot_logo_name": "varchar(128)",
    "sparefoot_marketplace": "int",
    "sparefoot_total_units": "int",
    "storedge_address": "varchar(256)",
    "storedge_cubesmart": "int",
    "storedge_cubesmart_with_fms": "int",
    "storedge_facility_name": "varchar(128)",
    "storedge_fms": "int",
    "storedge_fms_with_voyager": "int",
    "storedge_id": "varchar(128)",
    "storedge_logo_id": "varchar(128)",
    "storedge_logo_name": "varchar(128)",
    "storedge_new_build": "int",
    "storedge_old_launch_template": "int",
    "storedge_total_units": "int",
    "storedge_webworks": "int",
    "storedge_webworks_link": "int",
    "storedge_webworks_listing_only": "int",
    "storedge_webworks_market": "int",
    "uplid_id": "varchar(128)",
    "web": "int"
}

schema_name_id: 661
schema_scan_id: 161792116
updated: 2026-04-10 07:13:58

Version 1708553

created: 2026-04-09 07:17:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`\n(\n `uplid_id`  varchar(128) , `storedge_logo_id`  varchar(128) , `storedge_logo_name`  varchar(128) , `storedge_id`  varchar(128) , `storedge_facility_name`  varchar(128) , `storedge_address`  varchar(256) , `sitelink_logo_id`  varchar(128) , `sitelink_logo_name`  varchar(128) , `sitelink_id`  varchar(128) , `sitelink_facility_name`  varchar(128) , `sitelink_address`  varchar(256) , `sparefoot_logo_id`  varchar(128) , `sparefoot_logo_name`  varchar(128) , `sparefoot_id`  varchar(128) , `sparefoot_facility_name`  varchar(128) , `sparefoot_address`  varchar(256) , `storedge_total_units`  int , `sparefoot_total_units`  int , `sitelink_total_units`  int , `products`  varchar(1028) , `logo_id`  varchar(128) , `logo_name`  varchar(128) , `storedge_webworks`  int , `storedge_fms_with_voyager`  int , `storedge_old_launch_template`  int , `sitelink_merchant_services`  int , `storedge_new_build`  int , `storedge_webworks_link`  int , `storedge_webworks_market`  int , `storedge_cubesmart`  int , `sparefoot_marketplace`  int , `storedge_fms`  int , `storedge_cubesmart_with_fms`  int , `sitelink_web_edition`  int , `storedge_webworks_listing_only`  int , `sitelink_standalone`  int , `fms`  int , `mp`  int , `web`  int , `ms`  int , `intersection_type`  varchar(59) , `_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/pl_biggerfoot_uplid_products/2026-04-09/1775737048'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/pl_biggerfoot_uplid_products/2026-04-09/1775737048
id: 1708553
processed: 1

raw_data:

{
    "_origin": "41",
    "fms": "36",
    "intersection_type": "40",
    "logo_id": "20",
    "logo_name": "21",
    "mp": "37",
    "ms": "39",
    "products": "19",
    "sitelink_address": "10",
    "sitelink_facility_name": "9",
    "sitelink_id": "8",
    "sitelink_logo_id": "6",
    "sitelink_logo_name": "7",
    "sitelink_merchant_services": "25",
    "sitelink_standalone": "35",
    "sitelink_total_units": "18",
    "sitelink_web_edition": "33",
    "sparefoot_address": "15",
    "sparefoot_facility_name": "14",
    "sparefoot_id": "13",
    "sparefoot_logo_id": "11",
    "sparefoot_logo_name": "12",
    "sparefoot_marketplace": "30",
    "sparefoot_total_units": "17",
    "storedge_address": "5",
    "storedge_cubesmart": "29",
    "storedge_cubesmart_with_fms": "32",
    "storedge_facility_name": "4",
    "storedge_fms": "31",
    "storedge_fms_with_voyager": "23",
    "storedge_id": "3",
    "storedge_logo_id": "1",
    "storedge_logo_name": "2",
    "storedge_new_build": "26",
    "storedge_old_launch_template": "24",
    "storedge_total_units": "16",
    "storedge_webworks": "22",
    "storedge_webworks_link": "27",
    "storedge_webworks_listing_only": "34",
    "storedge_webworks_market": "28",
    "uplid_id": "0",
    "web": "38"
}

schema_attributes:

{
    "_origin": "string",
    "fms": "int",
    "intersection_type": "varchar(59)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "mp": "int",
    "ms": "int",
    "products": "varchar(1028)",
    "sitelink_address": "varchar(256)",
    "sitelink_facility_name": "varchar(128)",
    "sitelink_id": "varchar(128)",
    "sitelink_logo_id": "varchar(128)",
    "sitelink_logo_name": "varchar(128)",
    "sitelink_merchant_services": "int",
    "sitelink_standalone": "int",
    "sitelink_total_units": "int",
    "sitelink_web_edition": "int",
    "sparefoot_address": "varchar(256)",
    "sparefoot_facility_name": "varchar(128)",
    "sparefoot_id": "varchar(128)",
    "sparefoot_logo_id": "varchar(128)",
    "sparefoot_logo_name": "varchar(128)",
    "sparefoot_marketplace": "int",
    "sparefoot_total_units": "int",
    "storedge_address": "varchar(256)",
    "storedge_cubesmart": "int",
    "storedge_cubesmart_with_fms": "int",
    "storedge_facility_name": "varchar(128)",
    "storedge_fms": "int",
    "storedge_fms_with_voyager": "int",
    "storedge_id": "varchar(128)",
    "storedge_logo_id": "varchar(128)",
    "storedge_logo_name": "varchar(128)",
    "storedge_new_build": "int",
    "storedge_old_launch_template": "int",
    "storedge_total_units": "int",
    "storedge_webworks": "int",
    "storedge_webworks_link": "int",
    "storedge_webworks_listing_only": "int",
    "storedge_webworks_market": "int",
    "uplid_id": "varchar(128)",
    "web": "int"
}

schema_name_id: 661
schema_scan_id: 161736321
updated: 2026-04-09 07:17:56

Version 1707379

created: 2026-04-08 07:17:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`\n(\n `uplid_id`  varchar(128) , `storedge_logo_id`  varchar(128) , `storedge_logo_name`  varchar(128) , `storedge_id`  varchar(128) , `storedge_facility_name`  varchar(128) , `storedge_address`  varchar(256) , `sitelink_logo_id`  varchar(128) , `sitelink_logo_name`  varchar(128) , `sitelink_id`  varchar(128) , `sitelink_facility_name`  varchar(128) , `sitelink_address`  varchar(256) , `sparefoot_logo_id`  varchar(128) , `sparefoot_logo_name`  varchar(128) , `sparefoot_id`  varchar(128) , `sparefoot_facility_name`  varchar(128) , `sparefoot_address`  varchar(256) , `storedge_total_units`  int , `sparefoot_total_units`  int , `sitelink_total_units`  int , `products`  varchar(1028) , `logo_id`  varchar(128) , `logo_name`  varchar(128) , `storedge_webworks`  int , `storedge_fms_with_voyager`  int , `storedge_old_launch_template`  int , `sitelink_merchant_services`  int , `storedge_new_build`  int , `storedge_webworks_link`  int , `storedge_webworks_market`  int , `storedge_cubesmart`  int , `sparefoot_marketplace`  int , `storedge_fms`  int , `storedge_cubesmart_with_fms`  int , `sitelink_web_edition`  int , `storedge_webworks_listing_only`  int , `sitelink_standalone`  int , `fms`  int , `mp`  int , `web`  int , `ms`  int , `intersection_type`  varchar(59) , `_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/pl_biggerfoot_uplid_products/2026-04-08/1775650647'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/pl_biggerfoot_uplid_products/2026-04-08/1775650647
id: 1707379
processed: 1

raw_data:

{
    "_origin": "41",
    "fms": "36",
    "intersection_type": "40",
    "logo_id": "20",
    "logo_name": "21",
    "mp": "37",
    "ms": "39",
    "products": "19",
    "sitelink_address": "10",
    "sitelink_facility_name": "9",
    "sitelink_id": "8",
    "sitelink_logo_id": "6",
    "sitelink_logo_name": "7",
    "sitelink_merchant_services": "25",
    "sitelink_standalone": "35",
    "sitelink_total_units": "18",
    "sitelink_web_edition": "33",
    "sparefoot_address": "15",
    "sparefoot_facility_name": "14",
    "sparefoot_id": "13",
    "sparefoot_logo_id": "11",
    "sparefoot_logo_name": "12",
    "sparefoot_marketplace": "30",
    "sparefoot_total_units": "17",
    "storedge_address": "5",
    "storedge_cubesmart": "29",
    "storedge_cubesmart_with_fms": "32",
    "storedge_facility_name": "4",
    "storedge_fms": "31",
    "storedge_fms_with_voyager": "23",
    "storedge_id": "3",
    "storedge_logo_id": "1",
    "storedge_logo_name": "2",
    "storedge_new_build": "26",
    "storedge_old_launch_template": "24",
    "storedge_total_units": "16",
    "storedge_webworks": "22",
    "storedge_webworks_link": "27",
    "storedge_webworks_listing_only": "34",
    "storedge_webworks_market": "28",
    "uplid_id": "0",
    "web": "38"
}

schema_attributes:

{
    "_origin": "string",
    "fms": "int",
    "intersection_type": "varchar(59)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "mp": "int",
    "ms": "int",
    "products": "varchar(1028)",
    "sitelink_address": "varchar(256)",
    "sitelink_facility_name": "varchar(128)",
    "sitelink_id": "varchar(128)",
    "sitelink_logo_id": "varchar(128)",
    "sitelink_logo_name": "varchar(128)",
    "sitelink_merchant_services": "int",
    "sitelink_standalone": "int",
    "sitelink_total_units": "int",
    "sitelink_web_edition": "int",
    "sparefoot_address": "varchar(256)",
    "sparefoot_facility_name": "varchar(128)",
    "sparefoot_id": "varchar(128)",
    "sparefoot_logo_id": "varchar(128)",
    "sparefoot_logo_name": "varchar(128)",
    "sparefoot_marketplace": "int",
    "sparefoot_total_units": "int",
    "storedge_address": "varchar(256)",
    "storedge_cubesmart": "int",
    "storedge_cubesmart_with_fms": "int",
    "storedge_facility_name": "varchar(128)",
    "storedge_fms": "int",
    "storedge_fms_with_voyager": "int",
    "storedge_id": "varchar(128)",
    "storedge_logo_id": "varchar(128)",
    "storedge_logo_name": "varchar(128)",
    "storedge_new_build": "int",
    "storedge_old_launch_template": "int",
    "storedge_total_units": "int",
    "storedge_webworks": "int",
    "storedge_webworks_link": "int",
    "storedge_webworks_listing_only": "int",
    "storedge_webworks_market": "int",
    "uplid_id": "varchar(128)",
    "web": "int"
}

schema_name_id: 661
schema_scan_id: 161681518
updated: 2026-04-08 07:18:06

Version 1706171

created: 2026-04-07 07:16:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`\n(\n `uplid_id`  varchar(128) , `storedge_logo_id`  varchar(128) , `storedge_logo_name`  varchar(128) , `storedge_id`  varchar(128) , `storedge_facility_name`  varchar(128) , `storedge_address`  varchar(256) , `sitelink_logo_id`  varchar(128) , `sitelink_logo_name`  varchar(128) , `sitelink_id`  varchar(128) , `sitelink_facility_name`  varchar(128) , `sitelink_address`  varchar(256) , `sparefoot_logo_id`  varchar(128) , `sparefoot_logo_name`  varchar(128) , `sparefoot_id`  varchar(128) , `sparefoot_facility_name`  varchar(128) , `sparefoot_address`  varchar(256) , `storedge_total_units`  int , `sparefoot_total_units`  int , `sitelink_total_units`  int , `products`  varchar(1028) , `logo_id`  varchar(128) , `logo_name`  varchar(128) , `storedge_webworks`  int , `storedge_fms_with_voyager`  int , `storedge_old_launch_template`  int , `sitelink_merchant_services`  int , `storedge_new_build`  int , `storedge_webworks_link`  int , `storedge_webworks_market`  int , `storedge_cubesmart`  int , `sparefoot_marketplace`  int , `storedge_fms`  int , `storedge_cubesmart_with_fms`  int , `sitelink_web_edition`  int , `storedge_webworks_listing_only`  int , `sitelink_standalone`  int , `fms`  int , `mp`  int , `web`  int , `ms`  int , `intersection_type`  varchar(59) , `_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/pl_biggerfoot_uplid_products/2026-04-07/1775564179'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/pl_biggerfoot_uplid_products/2026-04-07/1775564179
id: 1706171
processed: 1

raw_data:

{
    "_origin": "41",
    "fms": "36",
    "intersection_type": "40",
    "logo_id": "20",
    "logo_name": "21",
    "mp": "37",
    "ms": "39",
    "products": "19",
    "sitelink_address": "10",
    "sitelink_facility_name": "9",
    "sitelink_id": "8",
    "sitelink_logo_id": "6",
    "sitelink_logo_name": "7",
    "sitelink_merchant_services": "25",
    "sitelink_standalone": "35",
    "sitelink_total_units": "18",
    "sitelink_web_edition": "33",
    "sparefoot_address": "15",
    "sparefoot_facility_name": "14",
    "sparefoot_id": "13",
    "sparefoot_logo_id": "11",
    "sparefoot_logo_name": "12",
    "sparefoot_marketplace": "30",
    "sparefoot_total_units": "17",
    "storedge_address": "5",
    "storedge_cubesmart": "29",
    "storedge_cubesmart_with_fms": "32",
    "storedge_facility_name": "4",
    "storedge_fms": "31",
    "storedge_fms_with_voyager": "23",
    "storedge_id": "3",
    "storedge_logo_id": "1",
    "storedge_logo_name": "2",
    "storedge_new_build": "26",
    "storedge_old_launch_template": "24",
    "storedge_total_units": "16",
    "storedge_webworks": "22",
    "storedge_webworks_link": "27",
    "storedge_webworks_listing_only": "34",
    "storedge_webworks_market": "28",
    "uplid_id": "0",
    "web": "38"
}

schema_attributes:

{
    "_origin": "string",
    "fms": "int",
    "intersection_type": "varchar(59)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "mp": "int",
    "ms": "int",
    "products": "varchar(1028)",
    "sitelink_address": "varchar(256)",
    "sitelink_facility_name": "varchar(128)",
    "sitelink_id": "varchar(128)",
    "sitelink_logo_id": "varchar(128)",
    "sitelink_logo_name": "varchar(128)",
    "sitelink_merchant_services": "int",
    "sitelink_standalone": "int",
    "sitelink_total_units": "int",
    "sitelink_web_edition": "int",
    "sparefoot_address": "varchar(256)",
    "sparefoot_facility_name": "varchar(128)",
    "sparefoot_id": "varchar(128)",
    "sparefoot_logo_id": "varchar(128)",
    "sparefoot_logo_name": "varchar(128)",
    "sparefoot_marketplace": "int",
    "sparefoot_total_units": "int",
    "storedge_address": "varchar(256)",
    "storedge_cubesmart": "int",
    "storedge_cubesmart_with_fms": "int",
    "storedge_facility_name": "varchar(128)",
    "storedge_fms": "int",
    "storedge_fms_with_voyager": "int",
    "storedge_id": "varchar(128)",
    "storedge_logo_id": "varchar(128)",
    "storedge_logo_name": "varchar(128)",
    "storedge_new_build": "int",
    "storedge_old_launch_template": "int",
    "storedge_total_units": "int",
    "storedge_webworks": "int",
    "storedge_webworks_link": "int",
    "storedge_webworks_listing_only": "int",
    "storedge_webworks_market": "int",
    "uplid_id": "varchar(128)",
    "web": "int"
}

schema_name_id: 661
schema_scan_id: 161625260
updated: 2026-04-07 07:16:54

Version 1704877

created: 2026-04-06 06:21:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`\n(\n `uplid_id`  varchar(128) , `storedge_logo_id`  varchar(128) , `storedge_logo_name`  varchar(128) , `storedge_id`  varchar(128) , `storedge_facility_name`  varchar(128) , `storedge_address`  varchar(256) , `sitelink_logo_id`  varchar(128) , `sitelink_logo_name`  varchar(128) , `sitelink_id`  varchar(128) , `sitelink_facility_name`  varchar(128) , `sitelink_address`  varchar(256) , `sparefoot_logo_id`  varchar(128) , `sparefoot_logo_name`  varchar(128) , `sparefoot_id`  varchar(128) , `sparefoot_facility_name`  varchar(128) , `sparefoot_address`  varchar(256) , `storedge_total_units`  int , `sparefoot_total_units`  int , `sitelink_total_units`  int , `products`  varchar(1028) , `logo_id`  varchar(128) , `logo_name`  varchar(128) , `storedge_webworks`  int , `storedge_fms_with_voyager`  int , `storedge_old_launch_template`  int , `sitelink_merchant_services`  int , `storedge_new_build`  int , `storedge_webworks_link`  int , `storedge_webworks_market`  int , `storedge_cubesmart`  int , `sparefoot_marketplace`  int , `storedge_fms`  int , `storedge_cubesmart_with_fms`  int , `sitelink_web_edition`  int , `storedge_webworks_listing_only`  int , `sitelink_standalone`  int , `fms`  int , `mp`  int , `web`  int , `ms`  int , `intersection_type`  varchar(59) , `_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/pl_biggerfoot_uplid_products/2026-04-06/1775474439'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/pl_biggerfoot_uplid_products/2026-04-06/1775474439
id: 1704877
processed: 1

raw_data:

{
    "_origin": "41",
    "fms": "36",
    "intersection_type": "40",
    "logo_id": "20",
    "logo_name": "21",
    "mp": "37",
    "ms": "39",
    "products": "19",
    "sitelink_address": "10",
    "sitelink_facility_name": "9",
    "sitelink_id": "8",
    "sitelink_logo_id": "6",
    "sitelink_logo_name": "7",
    "sitelink_merchant_services": "25",
    "sitelink_standalone": "35",
    "sitelink_total_units": "18",
    "sitelink_web_edition": "33",
    "sparefoot_address": "15",
    "sparefoot_facility_name": "14",
    "sparefoot_id": "13",
    "sparefoot_logo_id": "11",
    "sparefoot_logo_name": "12",
    "sparefoot_marketplace": "30",
    "sparefoot_total_units": "17",
    "storedge_address": "5",
    "storedge_cubesmart": "29",
    "storedge_cubesmart_with_fms": "32",
    "storedge_facility_name": "4",
    "storedge_fms": "31",
    "storedge_fms_with_voyager": "23",
    "storedge_id": "3",
    "storedge_logo_id": "1",
    "storedge_logo_name": "2",
    "storedge_new_build": "26",
    "storedge_old_launch_template": "24",
    "storedge_total_units": "16",
    "storedge_webworks": "22",
    "storedge_webworks_link": "27",
    "storedge_webworks_listing_only": "34",
    "storedge_webworks_market": "28",
    "uplid_id": "0",
    "web": "38"
}

schema_attributes:

{
    "_origin": "string",
    "fms": "int",
    "intersection_type": "varchar(59)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "mp": "int",
    "ms": "int",
    "products": "varchar(1028)",
    "sitelink_address": "varchar(256)",
    "sitelink_facility_name": "varchar(128)",
    "sitelink_id": "varchar(128)",
    "sitelink_logo_id": "varchar(128)",
    "sitelink_logo_name": "varchar(128)",
    "sitelink_merchant_services": "int",
    "sitelink_standalone": "int",
    "sitelink_total_units": "int",
    "sitelink_web_edition": "int",
    "sparefoot_address": "varchar(256)",
    "sparefoot_facility_name": "varchar(128)",
    "sparefoot_id": "varchar(128)",
    "sparefoot_logo_id": "varchar(128)",
    "sparefoot_logo_name": "varchar(128)",
    "sparefoot_marketplace": "int",
    "sparefoot_total_units": "int",
    "storedge_address": "varchar(256)",
    "storedge_cubesmart": "int",
    "storedge_cubesmart_with_fms": "int",
    "storedge_facility_name": "varchar(128)",
    "storedge_fms": "int",
    "storedge_fms_with_voyager": "int",
    "storedge_id": "varchar(128)",
    "storedge_logo_id": "varchar(128)",
    "storedge_logo_name": "varchar(128)",
    "storedge_new_build": "int",
    "storedge_old_launch_template": "int",
    "storedge_total_units": "int",
    "storedge_webworks": "int",
    "storedge_webworks_link": "int",
    "storedge_webworks_listing_only": "int",
    "storedge_webworks_market": "int",
    "uplid_id": "varchar(128)",
    "web": "int"
}

schema_name_id: 661
schema_scan_id: 161565851
updated: 2026-04-06 06:21:15

Version 1703743

created: 2026-04-05 07:26:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`\n(\n `uplid_id`  varchar(128) , `storedge_logo_id`  varchar(128) , `storedge_logo_name`  varchar(128) , `storedge_id`  varchar(128) , `storedge_facility_name`  varchar(128) , `storedge_address`  varchar(256) , `sitelink_logo_id`  varchar(128) , `sitelink_logo_name`  varchar(128) , `sitelink_id`  varchar(128) , `sitelink_facility_name`  varchar(128) , `sitelink_address`  varchar(256) , `sparefoot_logo_id`  varchar(128) , `sparefoot_logo_name`  varchar(128) , `sparefoot_id`  varchar(128) , `sparefoot_facility_name`  varchar(128) , `sparefoot_address`  varchar(256) , `storedge_total_units`  int , `sparefoot_total_units`  int , `sitelink_total_units`  int , `products`  varchar(1028) , `logo_id`  varchar(128) , `logo_name`  varchar(128) , `storedge_webworks`  int , `storedge_fms_with_voyager`  int , `storedge_old_launch_template`  int , `sitelink_merchant_services`  int , `storedge_new_build`  int , `storedge_webworks_link`  int , `storedge_webworks_market`  int , `storedge_cubesmart`  int , `sparefoot_marketplace`  int , `storedge_fms`  int , `storedge_cubesmart_with_fms`  int , `sitelink_web_edition`  int , `storedge_webworks_listing_only`  int , `sitelink_standalone`  int , `fms`  int , `mp`  int , `web`  int , `ms`  int , `intersection_type`  varchar(59) , `_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/pl_biggerfoot_uplid_products/2026-04-05/1775391981'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/pl_biggerfoot_uplid_products/2026-04-05/1775391981
id: 1703743
processed: 1

raw_data:

{
    "_origin": "41",
    "fms": "36",
    "intersection_type": "40",
    "logo_id": "20",
    "logo_name": "21",
    "mp": "37",
    "ms": "39",
    "products": "19",
    "sitelink_address": "10",
    "sitelink_facility_name": "9",
    "sitelink_id": "8",
    "sitelink_logo_id": "6",
    "sitelink_logo_name": "7",
    "sitelink_merchant_services": "25",
    "sitelink_standalone": "35",
    "sitelink_total_units": "18",
    "sitelink_web_edition": "33",
    "sparefoot_address": "15",
    "sparefoot_facility_name": "14",
    "sparefoot_id": "13",
    "sparefoot_logo_id": "11",
    "sparefoot_logo_name": "12",
    "sparefoot_marketplace": "30",
    "sparefoot_total_units": "17",
    "storedge_address": "5",
    "storedge_cubesmart": "29",
    "storedge_cubesmart_with_fms": "32",
    "storedge_facility_name": "4",
    "storedge_fms": "31",
    "storedge_fms_with_voyager": "23",
    "storedge_id": "3",
    "storedge_logo_id": "1",
    "storedge_logo_name": "2",
    "storedge_new_build": "26",
    "storedge_old_launch_template": "24",
    "storedge_total_units": "16",
    "storedge_webworks": "22",
    "storedge_webworks_link": "27",
    "storedge_webworks_listing_only": "34",
    "storedge_webworks_market": "28",
    "uplid_id": "0",
    "web": "38"
}

schema_attributes:

{
    "_origin": "string",
    "fms": "int",
    "intersection_type": "varchar(59)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "mp": "int",
    "ms": "int",
    "products": "varchar(1028)",
    "sitelink_address": "varchar(256)",
    "sitelink_facility_name": "varchar(128)",
    "sitelink_id": "varchar(128)",
    "sitelink_logo_id": "varchar(128)",
    "sitelink_logo_name": "varchar(128)",
    "sitelink_merchant_services": "int",
    "sitelink_standalone": "int",
    "sitelink_total_units": "int",
    "sitelink_web_edition": "int",
    "sparefoot_address": "varchar(256)",
    "sparefoot_facility_name": "varchar(128)",
    "sparefoot_id": "varchar(128)",
    "sparefoot_logo_id": "varchar(128)",
    "sparefoot_logo_name": "varchar(128)",
    "sparefoot_marketplace": "int",
    "sparefoot_total_units": "int",
    "storedge_address": "varchar(256)",
    "storedge_cubesmart": "int",
    "storedge_cubesmart_with_fms": "int",
    "storedge_facility_name": "varchar(128)",
    "storedge_fms": "int",
    "storedge_fms_with_voyager": "int",
    "storedge_id": "varchar(128)",
    "storedge_logo_id": "varchar(128)",
    "storedge_logo_name": "varchar(128)",
    "storedge_new_build": "int",
    "storedge_old_launch_template": "int",
    "storedge_total_units": "int",
    "storedge_webworks": "int",
    "storedge_webworks_link": "int",
    "storedge_webworks_listing_only": "int",
    "storedge_webworks_market": "int",
    "uplid_id": "varchar(128)",
    "web": "int"
}

schema_name_id: 661
schema_scan_id: 161520051
updated: 2026-04-05 07:26:51

Version 1702521

created: 2026-04-04 07:05:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`\n(\n `uplid_id`  varchar(128) , `storedge_logo_id`  varchar(128) , `storedge_logo_name`  varchar(128) , `storedge_id`  varchar(128) , `storedge_facility_name`  varchar(128) , `storedge_address`  varchar(256) , `sitelink_logo_id`  varchar(128) , `sitelink_logo_name`  varchar(128) , `sitelink_id`  varchar(128) , `sitelink_facility_name`  varchar(128) , `sitelink_address`  varchar(256) , `sparefoot_logo_id`  varchar(128) , `sparefoot_logo_name`  varchar(128) , `sparefoot_id`  varchar(128) , `sparefoot_facility_name`  varchar(128) , `sparefoot_address`  varchar(256) , `storedge_total_units`  int , `sparefoot_total_units`  int , `sitelink_total_units`  int , `products`  varchar(1028) , `logo_id`  varchar(128) , `logo_name`  varchar(128) , `storedge_webworks`  int , `storedge_fms_with_voyager`  int , `storedge_old_launch_template`  int , `sitelink_merchant_services`  int , `storedge_new_build`  int , `storedge_webworks_link`  int , `storedge_webworks_market`  int , `storedge_cubesmart`  int , `sparefoot_marketplace`  int , `storedge_fms`  int , `storedge_cubesmart_with_fms`  int , `sitelink_web_edition`  int , `storedge_webworks_listing_only`  int , `sitelink_standalone`  int , `fms`  int , `mp`  int , `web`  int , `ms`  int , `intersection_type`  varchar(59) , `_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/pl_biggerfoot_uplid_products/2026-04-04/1775304311'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/pl_biggerfoot_uplid_products/2026-04-04/1775304311
id: 1702521
processed: 1

raw_data:

{
    "_origin": "41",
    "fms": "36",
    "intersection_type": "40",
    "logo_id": "20",
    "logo_name": "21",
    "mp": "37",
    "ms": "39",
    "products": "19",
    "sitelink_address": "10",
    "sitelink_facility_name": "9",
    "sitelink_id": "8",
    "sitelink_logo_id": "6",
    "sitelink_logo_name": "7",
    "sitelink_merchant_services": "25",
    "sitelink_standalone": "35",
    "sitelink_total_units": "18",
    "sitelink_web_edition": "33",
    "sparefoot_address": "15",
    "sparefoot_facility_name": "14",
    "sparefoot_id": "13",
    "sparefoot_logo_id": "11",
    "sparefoot_logo_name": "12",
    "sparefoot_marketplace": "30",
    "sparefoot_total_units": "17",
    "storedge_address": "5",
    "storedge_cubesmart": "29",
    "storedge_cubesmart_with_fms": "32",
    "storedge_facility_name": "4",
    "storedge_fms": "31",
    "storedge_fms_with_voyager": "23",
    "storedge_id": "3",
    "storedge_logo_id": "1",
    "storedge_logo_name": "2",
    "storedge_new_build": "26",
    "storedge_old_launch_template": "24",
    "storedge_total_units": "16",
    "storedge_webworks": "22",
    "storedge_webworks_link": "27",
    "storedge_webworks_listing_only": "34",
    "storedge_webworks_market": "28",
    "uplid_id": "0",
    "web": "38"
}

schema_attributes:

{
    "_origin": "string",
    "fms": "int",
    "intersection_type": "varchar(59)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "mp": "int",
    "ms": "int",
    "products": "varchar(1028)",
    "sitelink_address": "varchar(256)",
    "sitelink_facility_name": "varchar(128)",
    "sitelink_id": "varchar(128)",
    "sitelink_logo_id": "varchar(128)",
    "sitelink_logo_name": "varchar(128)",
    "sitelink_merchant_services": "int",
    "sitelink_standalone": "int",
    "sitelink_total_units": "int",
    "sitelink_web_edition": "int",
    "sparefoot_address": "varchar(256)",
    "sparefoot_facility_name": "varchar(128)",
    "sparefoot_id": "varchar(128)",
    "sparefoot_logo_id": "varchar(128)",
    "sparefoot_logo_name": "varchar(128)",
    "sparefoot_marketplace": "int",
    "sparefoot_total_units": "int",
    "storedge_address": "varchar(256)",
    "storedge_cubesmart": "int",
    "storedge_cubesmart_with_fms": "int",
    "storedge_facility_name": "varchar(128)",
    "storedge_fms": "int",
    "storedge_fms_with_voyager": "int",
    "storedge_id": "varchar(128)",
    "storedge_logo_id": "varchar(128)",
    "storedge_logo_name": "varchar(128)",
    "storedge_new_build": "int",
    "storedge_old_launch_template": "int",
    "storedge_total_units": "int",
    "storedge_webworks": "int",
    "storedge_webworks_link": "int",
    "storedge_webworks_listing_only": "int",
    "storedge_webworks_market": "int",
    "uplid_id": "varchar(128)",
    "web": "int"
}

schema_name_id: 661
schema_scan_id: 161466387
updated: 2026-04-04 07:05:46

Version 1701387

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`\n(\n `uplid_id`  varchar(128) , `storedge_logo_id`  varchar(128) , `storedge_logo_name`  varchar(128) , `storedge_id`  varchar(128) , `storedge_facility_name`  varchar(128) , `storedge_address`  varchar(256) , `sitelink_logo_id`  varchar(128) , `sitelink_logo_name`  varchar(128) , `sitelink_id`  varchar(128) , `sitelink_facility_name`  varchar(128) , `sitelink_address`  varchar(256) , `sparefoot_logo_id`  varchar(128) , `sparefoot_logo_name`  varchar(128) , `sparefoot_id`  varchar(128) , `sparefoot_facility_name`  varchar(128) , `sparefoot_address`  varchar(256) , `storedge_total_units`  int , `sparefoot_total_units`  int , `sitelink_total_units`  int , `products`  varchar(1028) , `logo_id`  varchar(128) , `logo_name`  varchar(128) , `storedge_webworks`  int , `storedge_fms_with_voyager`  int , `storedge_old_launch_template`  int , `sitelink_merchant_services`  int , `storedge_new_build`  int , `storedge_webworks_link`  int , `storedge_webworks_market`  int , `storedge_cubesmart`  int , `sparefoot_marketplace`  int , `storedge_fms`  int , `storedge_cubesmart_with_fms`  int , `sitelink_web_edition`  int , `storedge_webworks_listing_only`  int , `sitelink_standalone`  int , `fms`  int , `mp`  int , `web`  int , `ms`  int , `intersection_type`  varchar(59) , `_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/pl_biggerfoot_uplid_products/2026-04-03/1775218202'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/pl_biggerfoot_uplid_products/2026-04-03/1775218202
id: 1701387
processed: 1

raw_data:

{
    "_origin": "41",
    "fms": "36",
    "intersection_type": "40",
    "logo_id": "20",
    "logo_name": "21",
    "mp": "37",
    "ms": "39",
    "products": "19",
    "sitelink_address": "10",
    "sitelink_facility_name": "9",
    "sitelink_id": "8",
    "sitelink_logo_id": "6",
    "sitelink_logo_name": "7",
    "sitelink_merchant_services": "25",
    "sitelink_standalone": "35",
    "sitelink_total_units": "18",
    "sitelink_web_edition": "33",
    "sparefoot_address": "15",
    "sparefoot_facility_name": "14",
    "sparefoot_id": "13",
    "sparefoot_logo_id": "11",
    "sparefoot_logo_name": "12",
    "sparefoot_marketplace": "30",
    "sparefoot_total_units": "17",
    "storedge_address": "5",
    "storedge_cubesmart": "29",
    "storedge_cubesmart_with_fms": "32",
    "storedge_facility_name": "4",
    "storedge_fms": "31",
    "storedge_fms_with_voyager": "23",
    "storedge_id": "3",
    "storedge_logo_id": "1",
    "storedge_logo_name": "2",
    "storedge_new_build": "26",
    "storedge_old_launch_template": "24",
    "storedge_total_units": "16",
    "storedge_webworks": "22",
    "storedge_webworks_link": "27",
    "storedge_webworks_listing_only": "34",
    "storedge_webworks_market": "28",
    "uplid_id": "0",
    "web": "38"
}

schema_attributes:

{
    "_origin": "string",
    "fms": "int",
    "intersection_type": "varchar(59)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "mp": "int",
    "ms": "int",
    "products": "varchar(1028)",
    "sitelink_address": "varchar(256)",
    "sitelink_facility_name": "varchar(128)",
    "sitelink_id": "varchar(128)",
    "sitelink_logo_id": "varchar(128)",
    "sitelink_logo_name": "varchar(128)",
    "sitelink_merchant_services": "int",
    "sitelink_standalone": "int",
    "sitelink_total_units": "int",
    "sitelink_web_edition": "int",
    "sparefoot_address": "varchar(256)",
    "sparefoot_facility_name": "varchar(128)",
    "sparefoot_id": "varchar(128)",
    "sparefoot_logo_id": "varchar(128)",
    "sparefoot_logo_name": "varchar(128)",
    "sparefoot_marketplace": "int",
    "sparefoot_total_units": "int",
    "storedge_address": "varchar(256)",
    "storedge_cubesmart": "int",
    "storedge_cubesmart_with_fms": "int",
    "storedge_facility_name": "varchar(128)",
    "storedge_fms": "int",
    "storedge_fms_with_voyager": "int",
    "storedge_id": "varchar(128)",
    "storedge_logo_id": "varchar(128)",
    "storedge_logo_name": "varchar(128)",
    "storedge_new_build": "int",
    "storedge_old_launch_template": "int",
    "storedge_total_units": "int",
    "storedge_webworks": "int",
    "storedge_webworks_link": "int",
    "storedge_webworks_listing_only": "int",
    "storedge_webworks_market": "int",
    "uplid_id": "varchar(128)",
    "web": "int"
}

schema_name_id: 661
schema_scan_id: 161408625
updated: 2026-04-03 07:10:40

Schema Scans: 15

Last at 2026-04-17 07:13:47

Scan 162173120

duration: 0:00:12.572856

exit_message:

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

id: 162173120

payload:

{
    "datatype_dict": {
        "fms": "int",
        "intersection_type": "varchar(59)",
        "logo_id": "varchar(128)",
        "logo_name": "varchar(128)",
        "mp": "int",
        "ms": "int",
        "origin_key": "varchar",
        "products": "varchar(1028)",
        "sitelink_address": "varchar(256)",
        "sitelink_facility_name": "varchar(128)",
        "sitelink_id": "varchar(128)",
        "sitelink_logo_id": "varchar(128)",
        "sitelink_logo_name": "varchar(128)",
        "sitelink_merchant_services": "int",
        "sitelink_standalone": "int",
        "sitelink_total_units": "int",
        "sitelink_web_edition": "int",
        "sparefoot_address": "varchar(256)",
        "sparefoot_facility_name": "varchar(128)",
        "sparefoot_id": "varchar(128)",
        "sparefoot_logo_id": "varchar(128)",
        "sparefoot_logo_name": "varchar(128)",
        "sparefoot_marketplace": "int",
        "sparefoot_total_units": "int",
        "storedge_address": "varchar(256)",
        "storedge_cubesmart": "int",
        "storedge_cubesmart_with_fms": "int",
        "storedge_facility_name": "varchar(128)",
        "storedge_fms": "int",
        "storedge_fms_with_voyager": "int",
        "storedge_id": "varchar(128)",
        "storedge_logo_id": "varchar(128)",
        "storedge_logo_name": "varchar(128)",
        "storedge_new_build": "int",
        "storedge_old_launch_template": "int",
        "storedge_total_units": "int",
        "storedge_webworks": "int",
        "storedge_webworks_link": "int",
        "storedge_webworks_listing_only": "int",
        "storedge_webworks_market": "int",
        "uplid_id": "varchar(128)",
        "web": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/pl_biggerfoot_uplid_products/2026-04-17/1776428016/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/pl_biggerfoot_uplid_products/2026-04-17/1776428016",
        "key": "raw/pl_biggerfoot_uplid_products/2026-04-17/1776428016/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8585405916410585673,
        "service_name": "redshift_unloads",
        "span_id": 11548672430941415958,
        "trace_id": 163924111365644795
    }
}

running: False
schema_name_id: 661
start_time: 2026-04-17 07:13:47
success: True
trace_id: 163924111365644795

Scan 162117444

duration: 0:00:12.743726

exit_message:

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

id: 162117444

payload:

{
    "datatype_dict": {
        "fms": "int",
        "intersection_type": "varchar(59)",
        "logo_id": "varchar(128)",
        "logo_name": "varchar(128)",
        "mp": "int",
        "ms": "int",
        "origin_key": "varchar",
        "products": "varchar(1028)",
        "sitelink_address": "varchar(256)",
        "sitelink_facility_name": "varchar(128)",
        "sitelink_id": "varchar(128)",
        "sitelink_logo_id": "varchar(128)",
        "sitelink_logo_name": "varchar(128)",
        "sitelink_merchant_services": "int",
        "sitelink_standalone": "int",
        "sitelink_total_units": "int",
        "sitelink_web_edition": "int",
        "sparefoot_address": "varchar(256)",
        "sparefoot_facility_name": "varchar(128)",
        "sparefoot_id": "varchar(128)",
        "sparefoot_logo_id": "varchar(128)",
        "sparefoot_logo_name": "varchar(128)",
        "sparefoot_marketplace": "int",
        "sparefoot_total_units": "int",
        "storedge_address": "varchar(256)",
        "storedge_cubesmart": "int",
        "storedge_cubesmart_with_fms": "int",
        "storedge_facility_name": "varchar(128)",
        "storedge_fms": "int",
        "storedge_fms_with_voyager": "int",
        "storedge_id": "varchar(128)",
        "storedge_logo_id": "varchar(128)",
        "storedge_logo_name": "varchar(128)",
        "storedge_new_build": "int",
        "storedge_old_launch_template": "int",
        "storedge_total_units": "int",
        "storedge_webworks": "int",
        "storedge_webworks_link": "int",
        "storedge_webworks_listing_only": "int",
        "storedge_webworks_market": "int",
        "uplid_id": "varchar(128)",
        "web": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/pl_biggerfoot_uplid_products/2026-04-16/1776342049/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/pl_biggerfoot_uplid_products/2026-04-16/1776342049",
        "key": "raw/pl_biggerfoot_uplid_products/2026-04-16/1776342049/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17145795599751116037,
        "service_name": "redshift_unloads",
        "span_id": 11700132283150381707,
        "trace_id": 7223581837126705077
    }
}

running: False
schema_name_id: 661
start_time: 2026-04-16 07:21:09
success: True
trace_id: 7223581837126705077

Scan 162061840

duration: 0:00:15.067433

exit_message:

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

id: 162061840

payload:

{
    "datatype_dict": {
        "fms": "int",
        "intersection_type": "varchar(59)",
        "logo_id": "varchar(128)",
        "logo_name": "varchar(128)",
        "mp": "int",
        "ms": "int",
        "origin_key": "varchar",
        "products": "varchar(1028)",
        "sitelink_address": "varchar(256)",
        "sitelink_facility_name": "varchar(128)",
        "sitelink_id": "varchar(128)",
        "sitelink_logo_id": "varchar(128)",
        "sitelink_logo_name": "varchar(128)",
        "sitelink_merchant_services": "int",
        "sitelink_standalone": "int",
        "sitelink_total_units": "int",
        "sitelink_web_edition": "int",
        "sparefoot_address": "varchar(256)",
        "sparefoot_facility_name": "varchar(128)",
        "sparefoot_id": "varchar(128)",
        "sparefoot_logo_id": "varchar(128)",
        "sparefoot_logo_name": "varchar(128)",
        "sparefoot_marketplace": "int",
        "sparefoot_total_units": "int",
        "storedge_address": "varchar(256)",
        "storedge_cubesmart": "int",
        "storedge_cubesmart_with_fms": "int",
        "storedge_facility_name": "varchar(128)",
        "storedge_fms": "int",
        "storedge_fms_with_voyager": "int",
        "storedge_id": "varchar(128)",
        "storedge_logo_id": "varchar(128)",
        "storedge_logo_name": "varchar(128)",
        "storedge_new_build": "int",
        "storedge_old_launch_template": "int",
        "storedge_total_units": "int",
        "storedge_webworks": "int",
        "storedge_webworks_link": "int",
        "storedge_webworks_listing_only": "int",
        "storedge_webworks_market": "int",
        "uplid_id": "varchar(128)",
        "web": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/pl_biggerfoot_uplid_products/2026-04-15/1776255000/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/pl_biggerfoot_uplid_products/2026-04-15/1776255000",
        "key": "raw/pl_biggerfoot_uplid_products/2026-04-15/1776255000/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3322076336344233646,
        "service_name": "redshift_unloads",
        "span_id": 8064512798662236116,
        "trace_id": 7153038335681537105
    }
}

running: False
schema_name_id: 661
start_time: 2026-04-15 07:11:57
success: True
trace_id: 7153038335681537105

Scan 162006474

duration: 0:00:12.690085

exit_message:

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

id: 162006474

payload:

{
    "datatype_dict": {
        "fms": "int",
        "intersection_type": "varchar(59)",
        "logo_id": "varchar(128)",
        "logo_name": "varchar(128)",
        "mp": "int",
        "ms": "int",
        "origin_key": "varchar",
        "products": "varchar(1028)",
        "sitelink_address": "varchar(256)",
        "sitelink_facility_name": "varchar(128)",
        "sitelink_id": "varchar(128)",
        "sitelink_logo_id": "varchar(128)",
        "sitelink_logo_name": "varchar(128)",
        "sitelink_merchant_services": "int",
        "sitelink_standalone": "int",
        "sitelink_total_units": "int",
        "sitelink_web_edition": "int",
        "sparefoot_address": "varchar(256)",
        "sparefoot_facility_name": "varchar(128)",
        "sparefoot_id": "varchar(128)",
        "sparefoot_logo_id": "varchar(128)",
        "sparefoot_logo_name": "varchar(128)",
        "sparefoot_marketplace": "int",
        "sparefoot_total_units": "int",
        "storedge_address": "varchar(256)",
        "storedge_cubesmart": "int",
        "storedge_cubesmart_with_fms": "int",
        "storedge_facility_name": "varchar(128)",
        "storedge_fms": "int",
        "storedge_fms_with_voyager": "int",
        "storedge_id": "varchar(128)",
        "storedge_logo_id": "varchar(128)",
        "storedge_logo_name": "varchar(128)",
        "storedge_new_build": "int",
        "storedge_old_launch_template": "int",
        "storedge_total_units": "int",
        "storedge_webworks": "int",
        "storedge_webworks_link": "int",
        "storedge_webworks_listing_only": "int",
        "storedge_webworks_market": "int",
        "uplid_id": "varchar(128)",
        "web": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/pl_biggerfoot_uplid_products/2026-04-14/1776169280/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/pl_biggerfoot_uplid_products/2026-04-14/1776169280",
        "key": "raw/pl_biggerfoot_uplid_products/2026-04-14/1776169280/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 18109536080840367580,
        "service_name": "redshift_unloads",
        "span_id": 6122468957696921547,
        "trace_id": 7843859259312204834
    }
}

running: False
schema_name_id: 661
start_time: 2026-04-14 07:21:30
success: True
trace_id: 7843859259312204834

Scan 161948470

duration: 0:00:12.862162

exit_message:

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

id: 161948470

payload:

{
    "datatype_dict": {
        "fms": "int",
        "intersection_type": "varchar(59)",
        "logo_id": "varchar(128)",
        "logo_name": "varchar(128)",
        "mp": "int",
        "ms": "int",
        "origin_key": "varchar",
        "products": "varchar(1028)",
        "sitelink_address": "varchar(256)",
        "sitelink_facility_name": "varchar(128)",
        "sitelink_id": "varchar(128)",
        "sitelink_logo_id": "varchar(128)",
        "sitelink_logo_name": "varchar(128)",
        "sitelink_merchant_services": "int",
        "sitelink_standalone": "int",
        "sitelink_total_units": "int",
        "sitelink_web_edition": "int",
        "sparefoot_address": "varchar(256)",
        "sparefoot_facility_name": "varchar(128)",
        "sparefoot_id": "varchar(128)",
        "sparefoot_logo_id": "varchar(128)",
        "sparefoot_logo_name": "varchar(128)",
        "sparefoot_marketplace": "int",
        "sparefoot_total_units": "int",
        "storedge_address": "varchar(256)",
        "storedge_cubesmart": "int",
        "storedge_cubesmart_with_fms": "int",
        "storedge_facility_name": "varchar(128)",
        "storedge_fms": "int",
        "storedge_fms_with_voyager": "int",
        "storedge_id": "varchar(128)",
        "storedge_logo_id": "varchar(128)",
        "storedge_logo_name": "varchar(128)",
        "storedge_new_build": "int",
        "storedge_old_launch_template": "int",
        "storedge_total_units": "int",
        "storedge_webworks": "int",
        "storedge_webworks_link": "int",
        "storedge_webworks_listing_only": "int",
        "storedge_webworks_market": "int",
        "uplid_id": "varchar(128)",
        "web": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/pl_biggerfoot_uplid_products/2026-04-13/1776083270/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/pl_biggerfoot_uplid_products/2026-04-13/1776083270",
        "key": "raw/pl_biggerfoot_uplid_products/2026-04-13/1776083270/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6775846448903465527,
        "service_name": "redshift_unloads",
        "span_id": 3767381543633893917,
        "trace_id": 11390541044661762454
    }
}

running: False
schema_name_id: 661
start_time: 2026-04-13 07:27:59
success: True
trace_id: 11390541044661762454

Scan 161899610

duration: 0:00:12.688012

exit_message:

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

id: 161899610

payload:

{
    "datatype_dict": {
        "fms": "int",
        "intersection_type": "varchar(59)",
        "logo_id": "varchar(128)",
        "logo_name": "varchar(128)",
        "mp": "int",
        "ms": "int",
        "origin_key": "varchar",
        "products": "varchar(1028)",
        "sitelink_address": "varchar(256)",
        "sitelink_facility_name": "varchar(128)",
        "sitelink_id": "varchar(128)",
        "sitelink_logo_id": "varchar(128)",
        "sitelink_logo_name": "varchar(128)",
        "sitelink_merchant_services": "int",
        "sitelink_standalone": "int",
        "sitelink_total_units": "int",
        "sitelink_web_edition": "int",
        "sparefoot_address": "varchar(256)",
        "sparefoot_facility_name": "varchar(128)",
        "sparefoot_id": "varchar(128)",
        "sparefoot_logo_id": "varchar(128)",
        "sparefoot_logo_name": "varchar(128)",
        "sparefoot_marketplace": "int",
        "sparefoot_total_units": "int",
        "storedge_address": "varchar(256)",
        "storedge_cubesmart": "int",
        "storedge_cubesmart_with_fms": "int",
        "storedge_facility_name": "varchar(128)",
        "storedge_fms": "int",
        "storedge_fms_with_voyager": "int",
        "storedge_id": "varchar(128)",
        "storedge_logo_id": "varchar(128)",
        "storedge_logo_name": "varchar(128)",
        "storedge_new_build": "int",
        "storedge_old_launch_template": "int",
        "storedge_total_units": "int",
        "storedge_webworks": "int",
        "storedge_webworks_link": "int",
        "storedge_webworks_listing_only": "int",
        "storedge_webworks_market": "int",
        "uplid_id": "varchar(128)",
        "web": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/pl_biggerfoot_uplid_products/2026-04-12/1775996448/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/pl_biggerfoot_uplid_products/2026-04-12/1775996448",
        "key": "raw/pl_biggerfoot_uplid_products/2026-04-12/1775996448/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15941102269694631226,
        "service_name": "redshift_unloads",
        "span_id": 5945446849003980698,
        "trace_id": 14971226590006407584
    }
}

running: False
schema_name_id: 661
start_time: 2026-04-12 07:21:00
success: True
trace_id: 14971226590006407584

Scan 161845241

duration: 0:00:15.220511

exit_message:

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

id: 161845241

payload:

{
    "datatype_dict": {
        "fms": "int",
        "intersection_type": "varchar(59)",
        "logo_id": "varchar(128)",
        "logo_name": "varchar(128)",
        "mp": "int",
        "ms": "int",
        "origin_key": "varchar",
        "products": "varchar(1028)",
        "sitelink_address": "varchar(256)",
        "sitelink_facility_name": "varchar(128)",
        "sitelink_id": "varchar(128)",
        "sitelink_logo_id": "varchar(128)",
        "sitelink_logo_name": "varchar(128)",
        "sitelink_merchant_services": "int",
        "sitelink_standalone": "int",
        "sitelink_total_units": "int",
        "sitelink_web_edition": "int",
        "sparefoot_address": "varchar(256)",
        "sparefoot_facility_name": "varchar(128)",
        "sparefoot_id": "varchar(128)",
        "sparefoot_logo_id": "varchar(128)",
        "sparefoot_logo_name": "varchar(128)",
        "sparefoot_marketplace": "int",
        "sparefoot_total_units": "int",
        "storedge_address": "varchar(256)",
        "storedge_cubesmart": "int",
        "storedge_cubesmart_with_fms": "int",
        "storedge_facility_name": "varchar(128)",
        "storedge_fms": "int",
        "storedge_fms_with_voyager": "int",
        "storedge_id": "varchar(128)",
        "storedge_logo_id": "varchar(128)",
        "storedge_logo_name": "varchar(128)",
        "storedge_new_build": "int",
        "storedge_old_launch_template": "int",
        "storedge_total_units": "int",
        "storedge_webworks": "int",
        "storedge_webworks_link": "int",
        "storedge_webworks_listing_only": "int",
        "storedge_webworks_market": "int",
        "uplid_id": "varchar(128)",
        "web": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/pl_biggerfoot_uplid_products/2026-04-11/1775905383/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/pl_biggerfoot_uplid_products/2026-04-11/1775905383",
        "key": "raw/pl_biggerfoot_uplid_products/2026-04-11/1775905383/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2265507162260492799,
        "service_name": "redshift_unloads",
        "span_id": 6817252312773431963,
        "trace_id": 14552073754040926479
    }
}

running: False
schema_name_id: 661
start_time: 2026-04-11 06:03:14
success: True
trace_id: 14552073754040926479

Scan 161792116

duration: 0:00:15.297295

exit_message:

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

id: 161792116

payload:

{
    "datatype_dict": {
        "fms": "int",
        "intersection_type": "varchar(59)",
        "logo_id": "varchar(128)",
        "logo_name": "varchar(128)",
        "mp": "int",
        "ms": "int",
        "origin_key": "varchar",
        "products": "varchar(1028)",
        "sitelink_address": "varchar(256)",
        "sitelink_facility_name": "varchar(128)",
        "sitelink_id": "varchar(128)",
        "sitelink_logo_id": "varchar(128)",
        "sitelink_logo_name": "varchar(128)",
        "sitelink_merchant_services": "int",
        "sitelink_standalone": "int",
        "sitelink_total_units": "int",
        "sitelink_web_edition": "int",
        "sparefoot_address": "varchar(256)",
        "sparefoot_facility_name": "varchar(128)",
        "sparefoot_id": "varchar(128)",
        "sparefoot_logo_id": "varchar(128)",
        "sparefoot_logo_name": "varchar(128)",
        "sparefoot_marketplace": "int",
        "sparefoot_total_units": "int",
        "storedge_address": "varchar(256)",
        "storedge_cubesmart": "int",
        "storedge_cubesmart_with_fms": "int",
        "storedge_facility_name": "varchar(128)",
        "storedge_fms": "int",
        "storedge_fms_with_voyager": "int",
        "storedge_id": "varchar(128)",
        "storedge_logo_id": "varchar(128)",
        "storedge_logo_name": "varchar(128)",
        "storedge_new_build": "int",
        "storedge_old_launch_template": "int",
        "storedge_total_units": "int",
        "storedge_webworks": "int",
        "storedge_webworks_link": "int",
        "storedge_webworks_listing_only": "int",
        "storedge_webworks_market": "int",
        "uplid_id": "varchar(128)",
        "web": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/pl_biggerfoot_uplid_products/2026-04-10/1775823213/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/pl_biggerfoot_uplid_products/2026-04-10/1775823213",
        "key": "raw/pl_biggerfoot_uplid_products/2026-04-10/1775823213/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17015626672494246767,
        "service_name": "redshift_unloads",
        "span_id": 758741100873548611,
        "trace_id": 17999558536943684314
    }
}

running: False
schema_name_id: 661
start_time: 2026-04-10 07:13:43
success: True
trace_id: 17999558536943684314

Scan 161736321

duration: 0:00:12.615543

exit_message:

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

id: 161736321

payload:

{
    "datatype_dict": {
        "fms": "int",
        "intersection_type": "varchar(59)",
        "logo_id": "varchar(128)",
        "logo_name": "varchar(128)",
        "mp": "int",
        "ms": "int",
        "origin_key": "varchar",
        "products": "varchar(1028)",
        "sitelink_address": "varchar(256)",
        "sitelink_facility_name": "varchar(128)",
        "sitelink_id": "varchar(128)",
        "sitelink_logo_id": "varchar(128)",
        "sitelink_logo_name": "varchar(128)",
        "sitelink_merchant_services": "int",
        "sitelink_standalone": "int",
        "sitelink_total_units": "int",
        "sitelink_web_edition": "int",
        "sparefoot_address": "varchar(256)",
        "sparefoot_facility_name": "varchar(128)",
        "sparefoot_id": "varchar(128)",
        "sparefoot_logo_id": "varchar(128)",
        "sparefoot_logo_name": "varchar(128)",
        "sparefoot_marketplace": "int",
        "sparefoot_total_units": "int",
        "storedge_address": "varchar(256)",
        "storedge_cubesmart": "int",
        "storedge_cubesmart_with_fms": "int",
        "storedge_facility_name": "varchar(128)",
        "storedge_fms": "int",
        "storedge_fms_with_voyager": "int",
        "storedge_id": "varchar(128)",
        "storedge_logo_id": "varchar(128)",
        "storedge_logo_name": "varchar(128)",
        "storedge_new_build": "int",
        "storedge_old_launch_template": "int",
        "storedge_total_units": "int",
        "storedge_webworks": "int",
        "storedge_webworks_link": "int",
        "storedge_webworks_listing_only": "int",
        "storedge_webworks_market": "int",
        "uplid_id": "varchar(128)",
        "web": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/pl_biggerfoot_uplid_products/2026-04-09/1775737048/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/pl_biggerfoot_uplid_products/2026-04-09/1775737048",
        "key": "raw/pl_biggerfoot_uplid_products/2026-04-09/1775737048/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2975085512382749530,
        "service_name": "redshift_unloads",
        "span_id": 11780921485466406938,
        "trace_id": 17265045855116338305
    }
}

running: False
schema_name_id: 661
start_time: 2026-04-09 07:17:44
success: True
trace_id: 17265045855116338305

Scan 161681518

duration: 0:00:15.196019

exit_message:

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

id: 161681518

payload:

{
    "datatype_dict": {
        "fms": "int",
        "intersection_type": "varchar(59)",
        "logo_id": "varchar(128)",
        "logo_name": "varchar(128)",
        "mp": "int",
        "ms": "int",
        "origin_key": "varchar",
        "products": "varchar(1028)",
        "sitelink_address": "varchar(256)",
        "sitelink_facility_name": "varchar(128)",
        "sitelink_id": "varchar(128)",
        "sitelink_logo_id": "varchar(128)",
        "sitelink_logo_name": "varchar(128)",
        "sitelink_merchant_services": "int",
        "sitelink_standalone": "int",
        "sitelink_total_units": "int",
        "sitelink_web_edition": "int",
        "sparefoot_address": "varchar(256)",
        "sparefoot_facility_name": "varchar(128)",
        "sparefoot_id": "varchar(128)",
        "sparefoot_logo_id": "varchar(128)",
        "sparefoot_logo_name": "varchar(128)",
        "sparefoot_marketplace": "int",
        "sparefoot_total_units": "int",
        "storedge_address": "varchar(256)",
        "storedge_cubesmart": "int",
        "storedge_cubesmart_with_fms": "int",
        "storedge_facility_name": "varchar(128)",
        "storedge_fms": "int",
        "storedge_fms_with_voyager": "int",
        "storedge_id": "varchar(128)",
        "storedge_logo_id": "varchar(128)",
        "storedge_logo_name": "varchar(128)",
        "storedge_new_build": "int",
        "storedge_old_launch_template": "int",
        "storedge_total_units": "int",
        "storedge_webworks": "int",
        "storedge_webworks_link": "int",
        "storedge_webworks_listing_only": "int",
        "storedge_webworks_market": "int",
        "uplid_id": "varchar(128)",
        "web": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/pl_biggerfoot_uplid_products/2026-04-08/1775650647/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/pl_biggerfoot_uplid_products/2026-04-08/1775650647",
        "key": "raw/pl_biggerfoot_uplid_products/2026-04-08/1775650647/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16875386180435807246,
        "service_name": "redshift_unloads",
        "span_id": 9391461111851293047,
        "trace_id": 10936959904691700143
    }
}

running: False
schema_name_id: 661
start_time: 2026-04-08 07:17:51
success: True
trace_id: 10936959904691700143

Scan 161625260

duration: 0:00:12.817318

exit_message:

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

id: 161625260

payload:

{
    "datatype_dict": {
        "fms": "int",
        "intersection_type": "varchar(59)",
        "logo_id": "varchar(128)",
        "logo_name": "varchar(128)",
        "mp": "int",
        "ms": "int",
        "origin_key": "varchar",
        "products": "varchar(1028)",
        "sitelink_address": "varchar(256)",
        "sitelink_facility_name": "varchar(128)",
        "sitelink_id": "varchar(128)",
        "sitelink_logo_id": "varchar(128)",
        "sitelink_logo_name": "varchar(128)",
        "sitelink_merchant_services": "int",
        "sitelink_standalone": "int",
        "sitelink_total_units": "int",
        "sitelink_web_edition": "int",
        "sparefoot_address": "varchar(256)",
        "sparefoot_facility_name": "varchar(128)",
        "sparefoot_id": "varchar(128)",
        "sparefoot_logo_id": "varchar(128)",
        "sparefoot_logo_name": "varchar(128)",
        "sparefoot_marketplace": "int",
        "sparefoot_total_units": "int",
        "storedge_address": "varchar(256)",
        "storedge_cubesmart": "int",
        "storedge_cubesmart_with_fms": "int",
        "storedge_facility_name": "varchar(128)",
        "storedge_fms": "int",
        "storedge_fms_with_voyager": "int",
        "storedge_id": "varchar(128)",
        "storedge_logo_id": "varchar(128)",
        "storedge_logo_name": "varchar(128)",
        "storedge_new_build": "int",
        "storedge_old_launch_template": "int",
        "storedge_total_units": "int",
        "storedge_webworks": "int",
        "storedge_webworks_link": "int",
        "storedge_webworks_listing_only": "int",
        "storedge_webworks_market": "int",
        "uplid_id": "varchar(128)",
        "web": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/pl_biggerfoot_uplid_products/2026-04-07/1775564179/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/pl_biggerfoot_uplid_products/2026-04-07/1775564179",
        "key": "raw/pl_biggerfoot_uplid_products/2026-04-07/1775564179/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8718093916009709501,
        "service_name": "redshift_unloads",
        "span_id": 13771604120212688042,
        "trace_id": 7068068452408068107
    }
}

running: False
schema_name_id: 661
start_time: 2026-04-07 07:16:41
success: True
trace_id: 7068068452408068107

Scan 161565851

duration: 0:00:15.348911

exit_message:

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

id: 161565851

payload:

{
    "datatype_dict": {
        "fms": "int",
        "intersection_type": "varchar(59)",
        "logo_id": "varchar(128)",
        "logo_name": "varchar(128)",
        "mp": "int",
        "ms": "int",
        "origin_key": "varchar",
        "products": "varchar(1028)",
        "sitelink_address": "varchar(256)",
        "sitelink_facility_name": "varchar(128)",
        "sitelink_id": "varchar(128)",
        "sitelink_logo_id": "varchar(128)",
        "sitelink_logo_name": "varchar(128)",
        "sitelink_merchant_services": "int",
        "sitelink_standalone": "int",
        "sitelink_total_units": "int",
        "sitelink_web_edition": "int",
        "sparefoot_address": "varchar(256)",
        "sparefoot_facility_name": "varchar(128)",
        "sparefoot_id": "varchar(128)",
        "sparefoot_logo_id": "varchar(128)",
        "sparefoot_logo_name": "varchar(128)",
        "sparefoot_marketplace": "int",
        "sparefoot_total_units": "int",
        "storedge_address": "varchar(256)",
        "storedge_cubesmart": "int",
        "storedge_cubesmart_with_fms": "int",
        "storedge_facility_name": "varchar(128)",
        "storedge_fms": "int",
        "storedge_fms_with_voyager": "int",
        "storedge_id": "varchar(128)",
        "storedge_logo_id": "varchar(128)",
        "storedge_logo_name": "varchar(128)",
        "storedge_new_build": "int",
        "storedge_old_launch_template": "int",
        "storedge_total_units": "int",
        "storedge_webworks": "int",
        "storedge_webworks_link": "int",
        "storedge_webworks_listing_only": "int",
        "storedge_webworks_market": "int",
        "uplid_id": "varchar(128)",
        "web": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/pl_biggerfoot_uplid_products/2026-04-06/1775474439/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/pl_biggerfoot_uplid_products/2026-04-06/1775474439",
        "key": "raw/pl_biggerfoot_uplid_products/2026-04-06/1775474439/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8234595954329888324,
        "service_name": "redshift_unloads",
        "span_id": 5500709008416973279,
        "trace_id": 2991517396247998360
    }
}

running: False
schema_name_id: 661
start_time: 2026-04-06 06:21:00
success: True
trace_id: 2991517396247998360

Scan 161520051

duration: 0:00:12.562822

exit_message:

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

id: 161520051

payload:

{
    "datatype_dict": {
        "fms": "int",
        "intersection_type": "varchar(59)",
        "logo_id": "varchar(128)",
        "logo_name": "varchar(128)",
        "mp": "int",
        "ms": "int",
        "origin_key": "varchar",
        "products": "varchar(1028)",
        "sitelink_address": "varchar(256)",
        "sitelink_facility_name": "varchar(128)",
        "sitelink_id": "varchar(128)",
        "sitelink_logo_id": "varchar(128)",
        "sitelink_logo_name": "varchar(128)",
        "sitelink_merchant_services": "int",
        "sitelink_standalone": "int",
        "sitelink_total_units": "int",
        "sitelink_web_edition": "int",
        "sparefoot_address": "varchar(256)",
        "sparefoot_facility_name": "varchar(128)",
        "sparefoot_id": "varchar(128)",
        "sparefoot_logo_id": "varchar(128)",
        "sparefoot_logo_name": "varchar(128)",
        "sparefoot_marketplace": "int",
        "sparefoot_total_units": "int",
        "storedge_address": "varchar(256)",
        "storedge_cubesmart": "int",
        "storedge_cubesmart_with_fms": "int",
        "storedge_facility_name": "varchar(128)",
        "storedge_fms": "int",
        "storedge_fms_with_voyager": "int",
        "storedge_id": "varchar(128)",
        "storedge_logo_id": "varchar(128)",
        "storedge_logo_name": "varchar(128)",
        "storedge_new_build": "int",
        "storedge_old_launch_template": "int",
        "storedge_total_units": "int",
        "storedge_webworks": "int",
        "storedge_webworks_link": "int",
        "storedge_webworks_listing_only": "int",
        "storedge_webworks_market": "int",
        "uplid_id": "varchar(128)",
        "web": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/pl_biggerfoot_uplid_products/2026-04-05/1775391981/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/pl_biggerfoot_uplid_products/2026-04-05/1775391981",
        "key": "raw/pl_biggerfoot_uplid_products/2026-04-05/1775391981/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 848121039387636868,
        "service_name": "redshift_unloads",
        "span_id": 14367602164979021319,
        "trace_id": 18024522188488669251
    }
}

running: False
schema_name_id: 661
start_time: 2026-04-05 07:26:38
success: True
trace_id: 18024522188488669251

Scan 161466387

duration: 0:00:15.031504

exit_message:

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

id: 161466387

payload:

{
    "datatype_dict": {
        "fms": "int",
        "intersection_type": "varchar(59)",
        "logo_id": "varchar(128)",
        "logo_name": "varchar(128)",
        "mp": "int",
        "ms": "int",
        "origin_key": "varchar",
        "products": "varchar(1028)",
        "sitelink_address": "varchar(256)",
        "sitelink_facility_name": "varchar(128)",
        "sitelink_id": "varchar(128)",
        "sitelink_logo_id": "varchar(128)",
        "sitelink_logo_name": "varchar(128)",
        "sitelink_merchant_services": "int",
        "sitelink_standalone": "int",
        "sitelink_total_units": "int",
        "sitelink_web_edition": "int",
        "sparefoot_address": "varchar(256)",
        "sparefoot_facility_name": "varchar(128)",
        "sparefoot_id": "varchar(128)",
        "sparefoot_logo_id": "varchar(128)",
        "sparefoot_logo_name": "varchar(128)",
        "sparefoot_marketplace": "int",
        "sparefoot_total_units": "int",
        "storedge_address": "varchar(256)",
        "storedge_cubesmart": "int",
        "storedge_cubesmart_with_fms": "int",
        "storedge_facility_name": "varchar(128)",
        "storedge_fms": "int",
        "storedge_fms_with_voyager": "int",
        "storedge_id": "varchar(128)",
        "storedge_logo_id": "varchar(128)",
        "storedge_logo_name": "varchar(128)",
        "storedge_new_build": "int",
        "storedge_old_launch_template": "int",
        "storedge_total_units": "int",
        "storedge_webworks": "int",
        "storedge_webworks_link": "int",
        "storedge_webworks_listing_only": "int",
        "storedge_webworks_market": "int",
        "uplid_id": "varchar(128)",
        "web": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/pl_biggerfoot_uplid_products/2026-04-04/1775304311/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/pl_biggerfoot_uplid_products/2026-04-04/1775304311",
        "key": "raw/pl_biggerfoot_uplid_products/2026-04-04/1775304311/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17096507409976042831,
        "service_name": "redshift_unloads",
        "span_id": 8936350601224925417,
        "trace_id": 15292781505991193221
    }
}

running: False
schema_name_id: 661
start_time: 2026-04-04 07:05:31
success: True
trace_id: 15292781505991193221

Scan 161408625

duration: 0:00:15.238487

exit_message:

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

id: 161408625

payload:

{
    "datatype_dict": {
        "fms": "int",
        "intersection_type": "varchar(59)",
        "logo_id": "varchar(128)",
        "logo_name": "varchar(128)",
        "mp": "int",
        "ms": "int",
        "origin_key": "varchar",
        "products": "varchar(1028)",
        "sitelink_address": "varchar(256)",
        "sitelink_facility_name": "varchar(128)",
        "sitelink_id": "varchar(128)",
        "sitelink_logo_id": "varchar(128)",
        "sitelink_logo_name": "varchar(128)",
        "sitelink_merchant_services": "int",
        "sitelink_standalone": "int",
        "sitelink_total_units": "int",
        "sitelink_web_edition": "int",
        "sparefoot_address": "varchar(256)",
        "sparefoot_facility_name": "varchar(128)",
        "sparefoot_id": "varchar(128)",
        "sparefoot_logo_id": "varchar(128)",
        "sparefoot_logo_name": "varchar(128)",
        "sparefoot_marketplace": "int",
        "sparefoot_total_units": "int",
        "storedge_address": "varchar(256)",
        "storedge_cubesmart": "int",
        "storedge_cubesmart_with_fms": "int",
        "storedge_facility_name": "varchar(128)",
        "storedge_fms": "int",
        "storedge_fms_with_voyager": "int",
        "storedge_id": "varchar(128)",
        "storedge_logo_id": "varchar(128)",
        "storedge_logo_name": "varchar(128)",
        "storedge_new_build": "int",
        "storedge_old_launch_template": "int",
        "storedge_total_units": "int",
        "storedge_webworks": "int",
        "storedge_webworks_link": "int",
        "storedge_webworks_listing_only": "int",
        "storedge_webworks_market": "int",
        "uplid_id": "varchar(128)",
        "web": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/pl_biggerfoot_uplid_products/2026-04-03/1775218202/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/pl_biggerfoot_uplid_products/2026-04-03/1775218202",
        "key": "raw/pl_biggerfoot_uplid_products/2026-04-03/1775218202/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6214823955241326067,
        "service_name": "redshift_unloads",
        "span_id": 5450514312700204991,
        "trace_id": 16116297268658081228
    }
}

running: False
schema_name_id: 661
start_time: 2026-04-03 07:10:25
success: True
trace_id: 16116297268658081228

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "fms": "int",
    "intersection_type": "varchar(59)",
    "logo_id": "varchar(128)",
    "logo_name": "varchar(128)",
    "mp": "int",
    "ms": "int",
    "products": "varchar(1028)",
    "sitelink_address": "varchar(256)",
    "sitelink_facility_name": "varchar(128)",
    "sitelink_id": "varchar(128)",
    "sitelink_logo_id": "varchar(128)",
    "sitelink_logo_name": "varchar(128)",
    "sitelink_merchant_services": "int",
    "sitelink_standalone": "int",
    "sitelink_total_units": "int",
    "sitelink_web_edition": "int",
    "sparefoot_address": "varchar(256)",
    "sparefoot_facility_name": "varchar(128)",
    "sparefoot_id": "varchar(128)",
    "sparefoot_logo_id": "varchar(128)",
    "sparefoot_logo_name": "varchar(128)",
    "sparefoot_marketplace": "int",
    "sparefoot_total_units": "int",
    "storedge_address": "varchar(256)",
    "storedge_cubesmart": "int",
    "storedge_cubesmart_with_fms": "int",
    "storedge_facility_name": "varchar(128)",
    "storedge_fms": "int",
    "storedge_fms_with_voyager": "int",
    "storedge_id": "varchar(128)",
    "storedge_logo_id": "varchar(128)",
    "storedge_logo_name": "varchar(128)",
    "storedge_new_build": "int",
    "storedge_old_launch_template": "int",
    "storedge_total_units": "int",
    "storedge_webworks": "int",
    "storedge_webworks_link": "int",
    "storedge_webworks_listing_only": "int",
    "storedge_webworks_market": "int",
    "uplid_id": "varchar(128)",
    "web": "int"
}

created: 2026-04-17 07:13:49

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`\n(\n `uplid_id`  varchar(128) , `storedge_logo_id`  varchar(128) , `storedge_logo_name`  varchar(128) , `storedge_id`  varchar(128) , `storedge_facility_name`  varchar(128) , `storedge_address`  varchar(256) , `sitelink_logo_id`  varchar(128) , `sitelink_logo_name`  varchar(128) , `sitelink_id`  varchar(128) , `sitelink_facility_name`  varchar(128) , `sitelink_address`  varchar(256) , `sparefoot_logo_id`  varchar(128) , `sparefoot_logo_name`  varchar(128) , `sparefoot_id`  varchar(128) , `sparefoot_facility_name`  varchar(128) , `sparefoot_address`  varchar(256) , `storedge_total_units`  int , `sparefoot_total_units`  int , `sitelink_total_units`  int , `products`  varchar(1028) , `logo_id`  varchar(128) , `logo_name`  varchar(128) , `storedge_webworks`  int , `storedge_fms_with_voyager`  int , `storedge_old_launch_template`  int , `sitelink_merchant_services`  int , `storedge_new_build`  int , `storedge_webworks_link`  int , `storedge_webworks_market`  int , `storedge_cubesmart`  int , `sparefoot_marketplace`  int , `storedge_fms`  int , `storedge_cubesmart_with_fms`  int , `sitelink_web_edition`  int , `storedge_webworks_listing_only`  int , `sitelink_standalone`  int , `fms`  int , `mp`  int , `web`  int , `ms`  int , `intersection_type`  varchar(59) , `_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/pl_biggerfoot_uplid_products/2026-04-17/1776428016'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products"
}

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 07:04:03",
        "disabled": false,
        "format": "raw",
        "id": 661,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_redshift",
            "table": "analytics_pl_biggerfoot_uplid_products"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "fms": "int",
            "intersection_type": "varchar(59)",
            "logo_id": "varchar(128)",
            "logo_name": "varchar(128)",
            "mp": "int",
            "ms": "int",
            "products": "varchar(1028)",
            "sitelink_address": "varchar(256)",
            "sitelink_facility_name": "varchar(128)",
            "sitelink_id": "varchar(128)",
            "sitelink_logo_id": "varchar(128)",
            "sitelink_logo_name": "varchar(128)",
            "sitelink_merchant_services": "int",
            "sitelink_standalone": "int",
            "sitelink_total_units": "int",
            "sitelink_web_edition": "int",
            "sparefoot_address": "varchar(256)",
            "sparefoot_facility_name": "varchar(128)",
            "sparefoot_id": "varchar(128)",
            "sparefoot_logo_id": "varchar(128)",
            "sparefoot_logo_name": "varchar(128)",
            "sparefoot_marketplace": "int",
            "sparefoot_total_units": "int",
            "storedge_address": "varchar(256)",
            "storedge_cubesmart": "int",
            "storedge_cubesmart_with_fms": "int",
            "storedge_facility_name": "varchar(128)",
            "storedge_fms": "int",
            "storedge_fms_with_voyager": "int",
            "storedge_id": "varchar(128)",
            "storedge_logo_id": "varchar(128)",
            "storedge_logo_name": "varchar(128)",
            "storedge_new_build": "int",
            "storedge_old_launch_template": "int",
            "storedge_total_units": "int",
            "storedge_webworks": "int",
            "storedge_webworks_link": "int",
            "storedge_webworks_listing_only": "int",
            "storedge_webworks_market": "int",
            "uplid_id": "varchar(128)",
            "web": "int"
        },
        "created": "2026-04-17 07:13:49",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`\n(\n `uplid_id`  varchar(128) , `storedge_logo_id`  varchar(128) , `storedge_logo_name`  varchar(128) , `storedge_id`  varchar(128) , `storedge_facility_name`  varchar(128) , `storedge_address`  varchar(256) , `sitelink_logo_id`  varchar(128) , `sitelink_logo_name`  varchar(128) , `sitelink_id`  varchar(128) , `sitelink_facility_name`  varchar(128) , `sitelink_address`  varchar(256) , `sparefoot_logo_id`  varchar(128) , `sparefoot_logo_name`  varchar(128) , `sparefoot_id`  varchar(128) , `sparefoot_facility_name`  varchar(128) , `sparefoot_address`  varchar(256) , `storedge_total_units`  int , `sparefoot_total_units`  int , `sitelink_total_units`  int , `products`  varchar(1028) , `logo_id`  varchar(128) , `logo_name`  varchar(128) , `storedge_webworks`  int , `storedge_fms_with_voyager`  int , `storedge_old_launch_template`  int , `sitelink_merchant_services`  int , `storedge_new_build`  int , `storedge_webworks_link`  int , `storedge_webworks_market`  int , `storedge_cubesmart`  int , `sparefoot_marketplace`  int , `storedge_fms`  int , `storedge_cubesmart_with_fms`  int , `sitelink_web_edition`  int , `storedge_webworks_listing_only`  int , `sitelink_standalone`  int , `fms`  int , `mp`  int , `web`  int , `ms`  int , `intersection_type`  varchar(59) , `_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/pl_biggerfoot_uplid_products/2026-04-17/1776428016'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_biggerfoot_uplid_products"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}