Schema Info
Schema Name: sfdl_stage_redshift.analytics_pl_biggerfoot_uplid_products
- created: 2019-07-02 19:39:55
- disabled: False
- format: raw
- id: 858
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_stage_redshift", "table": "analytics_pl_biggerfoot_uplid_products" } - type: redshift
Schema Versions: 3
-
Version 868543
- created: 2025-09-26 05:31:00
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_pl_biggerfoot_uplid_products`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/pl_biggerfoot_uplid_products/2025-09-26/1758882641'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_pl_biggerfoot_uplid_products" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/pl_biggerfoot_uplid_products/2025-09-26/1758882641
- id: 868543
- 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: 858
- schema_scan_id: 6326526
- updated: 2025-09-26 05:31:11
-
Version 868324
- created: 2025-09-25 05:31:02
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_pl_biggerfoot_uplid_products`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/pl_biggerfoot_uplid_products/2025-09-25/1758796243'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_pl_biggerfoot_uplid_products" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/pl_biggerfoot_uplid_products/2025-09-25/1758796243
- id: 868324
- 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: 858
- schema_scan_id: 6326107
- updated: 2025-09-25 05:31:16
-
Version 868106
- created: 2025-09-24 05:16:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_pl_biggerfoot_uplid_products`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/pl_biggerfoot_uplid_products/2025-09-24/1758708951'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_pl_biggerfoot_uplid_products" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/pl_biggerfoot_uplid_products/2025-09-24/1758708951
- id: 868106
- 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: 858
- schema_scan_id: 6325684
- updated: 2025-09-24 05:16:59
Schema Scans: 3
Last at 2025-09-26 05:30:58
-
Scan 6326526
- duration: 0:00:12.668723
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6326526
- 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-stage", "key": "meta/pl_biggerfoot_uplid_products/2025-09-26/1758882641/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/pl_biggerfoot_uplid_products/2025-09-26/1758882641", "key": "raw/pl_biggerfoot_uplid_products/2025-09-26/1758882641/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_pl_biggerfoot_uplid_products", "type": "redshift" }, "trace_context": { "parent_id": 17303166442076924368, "service_name": "redshift_unloads", "span_id": 16980128175865278835, "trace_id": 8042626111739533994 } } - running: False
- schema_name_id: 858
- start_time: 2025-09-26 05:30:58
- success: True
- trace_id: 8042626111739533994
-
Scan 6326107
- duration: 0:00:15.151326
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6326107
- 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-stage", "key": "meta/pl_biggerfoot_uplid_products/2025-09-25/1758796243/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/pl_biggerfoot_uplid_products/2025-09-25/1758796243", "key": "raw/pl_biggerfoot_uplid_products/2025-09-25/1758796243/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_pl_biggerfoot_uplid_products", "type": "redshift" }, "trace_context": { "parent_id": 2934005065615468803, "service_name": "redshift_unloads", "span_id": 6102508193594826681, "trace_id": 7617659748112365536 } } - running: False
- schema_name_id: 858
- start_time: 2025-09-25 05:31:00
- success: True
- trace_id: 7617659748112365536
-
Scan 6325684
- duration: 0:00:15.149896
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6325684
- 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-stage", "key": "meta/pl_biggerfoot_uplid_products/2025-09-24/1758708951/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/pl_biggerfoot_uplid_products/2025-09-24/1758708951", "key": "raw/pl_biggerfoot_uplid_products/2025-09-24/1758708951/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_pl_biggerfoot_uplid_products", "type": "redshift" }, "trace_context": { "parent_id": 4996497047196833328, "service_name": "redshift_unloads", "span_id": 1164525917982075792, "trace_id": 9196859038684331567 } } - running: False
- schema_name_id: 858
- start_time: 2025-09-24 05:16:44
- success: True
- trace_id: 9196859038684331567
- 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: 2025-09-26 05:31:00
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/pl_biggerfoot_uplid_products/2025-09-26/1758882641'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_pl_biggerfoot_uplid_products`", "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_pl_biggerfoot_uplid_products" }
- hostname: schemamanager-5c55c886bf-h2ts4
- name: schema_manager
- process_start: 2025-10-21 13:03:27
- sf_env: stage
- version: 2112174301
{
"name": {
"created": "2019-07-02 19:39:55",
"disabled": false,
"format": "raw",
"id": 858,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_stage_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": "2025-09-26 05:31:00",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/pl_biggerfoot_uplid_products/2025-09-26/1758882641'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_pl_biggerfoot_uplid_products`",
"repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_pl_biggerfoot_uplid_products"
}
},
"server": {
"hostname": "schemamanager-5c55c886bf-h2ts4",
"name": "schema_manager",
"process_start": "2025-10-21 13:03:27",
"sf_env": "stage",
"version": "2112174301"
}
}