Schema Info
Schema Name: sfdl_dev_redshift.analytics_pl_biggerfoot_uplid_products
- created: 2022-02-08 19:12:51
- disabled: False
- format: raw
- id: 1700
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_dev_redshift", "table": "analytics_pl_biggerfoot_uplid_products" } - type: redshift
Schema Versions: 3
-
Version 4708852
- created: 2024-08-14 14:06:01
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`", "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_pl_biggerfoot_uplid_products`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/pl_biggerfoot_uplid_products/2024-08-14/1723662339'\n", "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_pl_biggerfoot_uplid_products" ] - hive_path: s3://sfdl-redshift-analytics-dev/raw/pl_biggerfoot_uplid_products/2024-08-14/1723662339
- id: 4708852
- 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: 1700
- schema_scan_id: 6565881
- updated: 2024-08-14 14:06:15
-
Version 4705950
- created: 2024-05-14 08:14:39
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`", "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_pl_biggerfoot_uplid_products`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/pl_biggerfoot_uplid_products/2024-05-14/1715692439'\n", "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_pl_biggerfoot_uplid_products" ] - hive_path: s3://sfdl-redshift-analytics-dev/raw/pl_biggerfoot_uplid_products/2024-05-14/1715692439
- id: 4705950
- 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: 1700
- schema_scan_id: 6490646
- updated: 2024-05-14 08:14:53
-
Version 4705787
- created: 2024-05-13 17:30:32
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`", "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_pl_biggerfoot_uplid_products`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/pl_biggerfoot_uplid_products/2024-05-13/1715639401'\n", "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_pl_biggerfoot_uplid_products" ] - hive_path: s3://sfdl-redshift-analytics-dev/raw/pl_biggerfoot_uplid_products/2024-05-13/1715639401
- id: 4705787
- 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: 1700
- schema_scan_id: 6490387
- updated: 2024-05-13 17:30:44
Schema Scans: 3
Last at 2024-08-14 14:06:00
-
Scan 6565881
- duration: 0:00:15.188260
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6565881
- 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-dev", "key": "meta/pl_biggerfoot_uplid_products/2024-08-14/1723662339/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-dev", "hive_path": "s3://sfdl-redshift-analytics-dev/raw/pl_biggerfoot_uplid_products/2024-08-14/1723662339", "key": "raw/pl_biggerfoot_uplid_products/2024-08-14/1723662339/0007_part_00.gz" }, "schema": { "name": "sfdl_dev_redshift.analytics_pl_biggerfoot_uplid_products", "type": "redshift" }, "trace_context": { "parent_id": 12805888039550396677, "service_name": "redshift_unloads", "span_id": 12542914908688078458, "trace_id": 14276351330044243151 } } - running: False
- schema_name_id: 1700
- start_time: 2024-08-14 14:06:00
- success: True
- trace_id: 14276351330044243151
-
Scan 6490646
- duration: 0:00:15.169111
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6490646
- 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-dev", "key": "meta/pl_biggerfoot_uplid_products/2024-05-14/1715692439/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-dev", "hive_path": "s3://sfdl-redshift-analytics-dev/raw/pl_biggerfoot_uplid_products/2024-05-14/1715692439", "key": "raw/pl_biggerfoot_uplid_products/2024-05-14/1715692439/0007_part_00.gz" }, "schema": { "name": "sfdl_dev_redshift.analytics_pl_biggerfoot_uplid_products", "type": "redshift" }, "trace_context": { "parent_id": 2908744894413939394, "service_name": "redshift_unloads", "span_id": 4613235987073891291, "trace_id": 5034665683193676771 } } - running: False
- schema_name_id: 1700
- start_time: 2024-05-14 08:14:37
- success: True
- trace_id: 5034665683193676771
-
Scan 6490387
- duration: 0:00:12.844054
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6490387
- 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-dev", "key": "meta/pl_biggerfoot_uplid_products/2024-05-13/1715639401/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-dev", "hive_path": "s3://sfdl-redshift-analytics-dev/raw/pl_biggerfoot_uplid_products/2024-05-13/1715639401", "key": "raw/pl_biggerfoot_uplid_products/2024-05-13/1715639401/0007_part_00.gz" }, "schema": { "name": "sfdl_dev_redshift.analytics_pl_biggerfoot_uplid_products", "type": "redshift" }, "trace_context": { "parent_id": 9555233750611166780, "service_name": "redshift_unloads", "span_id": 15973479190762331101, "trace_id": 7735955828406277053 } } - running: False
- schema_name_id: 1700
- start_time: 2024-05-13 17:30:31
- success: True
- trace_id: 7735955828406277053
- 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: 2024-08-14 14:06:01
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/pl_biggerfoot_uplid_products/2024-08-14/1723662339'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_pl_biggerfoot_uplid_products`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_pl_biggerfoot_uplid_products" }
- hostname: schemamanager-5447774fc6-4w58v
- name: schema_manager
- process_start: 2026-04-02 21:43:44
- sf_env: dev
- version: 2427328685
{
"name": {
"created": "2022-02-08 19:12:51",
"disabled": false,
"format": "raw",
"id": 1700,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_dev_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": "2024-08-14 14:06:01",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/pl_biggerfoot_uplid_products/2024-08-14/1723662339'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_pl_biggerfoot_uplid_products`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_pl_biggerfoot_uplid_products"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}