Schema Info
Schema Name: sfdl_stage_redshift.analytics_dwh_dim_unit
- created: 2018-02-20 23:56:13
- disabled: False
- format: raw
- id: 379
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_stage_redshift", "table": "analytics_dwh_dim_unit" } - type: redshift
Schema Versions: 15
-
Version 906626
- created: 2026-04-17 03:41:12
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_unit`\n(\n `audit_id` bigint , `unit_key` bigint , `facility_key` int , `unit_type_key` int , `regular_price` decimal , `sparefoot_price` decimal , `quantity` int , `climate_controlled` int , `vehicle` int , `drive_up` int , `active` int , `publish` int , `approve` int , `grouping_hash` varchar(32) , `reservation_window` int , `length` decimal , `width` decimal , `floor` int , `height` decimal , `humidity_controlled` int , `outdoor_access` int , `alarm` int , `power` int , `covered` int , `door_type` varchar(9) , `door_width` decimal , `door_height` decimal , `door_length` decimal , `update_time` timestamp , `_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/dwh_dim_unit/2026-04-17/1776415101'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_unit/2026-04-17/1776415101
- id: 906626
- processed: 1
- raw_data:
{ "_origin": "29", "active": "10", "alarm": "21", "approve": "12", "audit_id": "0", "climate_controlled": "7", "covered": "23", "door_height": "26", "door_length": "27", "door_type": "24", "door_width": "25", "drive_up": "9", "facility_key": "2", "floor": "17", "grouping_hash": "13", "height": "18", "humidity_controlled": "19", "length": "15", "outdoor_access": "20", "power": "22", "publish": "11", "quantity": "6", "regular_price": "4", "reservation_window": "14", "sparefoot_price": "5", "unit_key": "1", "unit_type_key": "3", "update_time": "28", "vehicle": "8", "width": "16" } - schema_attributes:
{ "_origin": "string", "active": "int", "alarm": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "covered": "int", "door_height": "decimal", "door_length": "decimal", "door_type": "varchar(9)", "door_width": "decimal", "drive_up": "int", "facility_key": "int", "floor": "int", "grouping_hash": "varchar(32)", "height": "decimal", "humidity_controlled": "int", "is_physical_unit": "string", "length": "decimal", "outdoor_access": "int", "power": "int", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "update_time": "timestamp", "vehicle": "int", "width": "decimal" } - schema_name_id: 379
- schema_scan_id: 6415206
- updated: 2026-04-17 03:41:26
-
Version 906437
- created: 2026-04-16 04:09:41
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_unit`\n(\n `audit_id` bigint , `unit_key` bigint , `facility_key` int , `unit_type_key` int , `regular_price` decimal , `sparefoot_price` decimal , `quantity` int , `climate_controlled` int , `vehicle` int , `drive_up` int , `active` int , `publish` int , `approve` int , `grouping_hash` varchar(32) , `reservation_window` int , `length` decimal , `width` decimal , `floor` int , `height` decimal , `humidity_controlled` int , `outdoor_access` int , `alarm` int , `power` int , `covered` int , `door_type` varchar(9) , `door_width` decimal , `door_height` decimal , `door_length` decimal , `update_time` timestamp , `_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/dwh_dim_unit/2026-04-16/1776330406'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_unit/2026-04-16/1776330406
- id: 906437
- processed: 1
- raw_data:
{ "_origin": "29", "active": "10", "alarm": "21", "approve": "12", "audit_id": "0", "climate_controlled": "7", "covered": "23", "door_height": "26", "door_length": "27", "door_type": "24", "door_width": "25", "drive_up": "9", "facility_key": "2", "floor": "17", "grouping_hash": "13", "height": "18", "humidity_controlled": "19", "length": "15", "outdoor_access": "20", "power": "22", "publish": "11", "quantity": "6", "regular_price": "4", "reservation_window": "14", "sparefoot_price": "5", "unit_key": "1", "unit_type_key": "3", "update_time": "28", "vehicle": "8", "width": "16" } - schema_attributes:
{ "_origin": "string", "active": "int", "alarm": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "covered": "int", "door_height": "decimal", "door_length": "decimal", "door_type": "varchar(9)", "door_width": "decimal", "drive_up": "int", "facility_key": "int", "floor": "int", "grouping_hash": "varchar(32)", "height": "decimal", "humidity_controlled": "int", "is_physical_unit": "string", "length": "decimal", "outdoor_access": "int", "power": "int", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "update_time": "timestamp", "vehicle": "int", "width": "decimal" } - schema_name_id: 379
- schema_scan_id: 6414687
- updated: 2026-04-16 04:09:55
-
Version 906226
- created: 2026-04-15 04:03:35
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_unit`\n(\n `audit_id` bigint , `unit_key` bigint , `facility_key` int , `unit_type_key` int , `regular_price` decimal , `sparefoot_price` decimal , `quantity` int , `climate_controlled` int , `vehicle` int , `drive_up` int , `active` int , `publish` int , `approve` int , `grouping_hash` varchar(32) , `reservation_window` int , `length` decimal , `width` decimal , `floor` int , `height` decimal , `humidity_controlled` int , `outdoor_access` int , `alarm` int , `power` int , `covered` int , `door_type` varchar(9) , `door_width` decimal , `door_height` decimal , `door_length` decimal , `update_time` timestamp , `_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/dwh_dim_unit/2026-04-15/1776243657'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_unit/2026-04-15/1776243657
- id: 906226
- processed: 1
- raw_data:
{ "_origin": "29", "active": "10", "alarm": "21", "approve": "12", "audit_id": "0", "climate_controlled": "7", "covered": "23", "door_height": "26", "door_length": "27", "door_type": "24", "door_width": "25", "drive_up": "9", "facility_key": "2", "floor": "17", "grouping_hash": "13", "height": "18", "humidity_controlled": "19", "length": "15", "outdoor_access": "20", "power": "22", "publish": "11", "quantity": "6", "regular_price": "4", "reservation_window": "14", "sparefoot_price": "5", "unit_key": "1", "unit_type_key": "3", "update_time": "28", "vehicle": "8", "width": "16" } - schema_attributes:
{ "_origin": "string", "active": "int", "alarm": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "covered": "int", "door_height": "decimal", "door_length": "decimal", "door_type": "varchar(9)", "door_width": "decimal", "drive_up": "int", "facility_key": "int", "floor": "int", "grouping_hash": "varchar(32)", "height": "decimal", "humidity_controlled": "int", "is_physical_unit": "string", "length": "decimal", "outdoor_access": "int", "power": "int", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "update_time": "timestamp", "vehicle": "int", "width": "decimal" } - schema_name_id: 379
- schema_scan_id: 6414202
- updated: 2026-04-15 04:03:48
-
Version 906014
- created: 2026-04-14 04:01:21
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_unit`\n(\n `audit_id` bigint , `unit_key` bigint , `facility_key` int , `unit_type_key` int , `regular_price` decimal , `sparefoot_price` decimal , `quantity` int , `climate_controlled` int , `vehicle` int , `drive_up` int , `active` int , `publish` int , `approve` int , `grouping_hash` varchar(32) , `reservation_window` int , `length` decimal , `width` decimal , `floor` int , `height` decimal , `humidity_controlled` int , `outdoor_access` int , `alarm` int , `power` int , `covered` int , `door_type` varchar(9) , `door_width` decimal , `door_height` decimal , `door_length` decimal , `update_time` timestamp , `_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/dwh_dim_unit/2026-04-14/1776157100'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_unit/2026-04-14/1776157100
- id: 906014
- processed: 1
- raw_data:
{ "_origin": "29", "active": "10", "alarm": "21", "approve": "12", "audit_id": "0", "climate_controlled": "7", "covered": "23", "door_height": "26", "door_length": "27", "door_type": "24", "door_width": "25", "drive_up": "9", "facility_key": "2", "floor": "17", "grouping_hash": "13", "height": "18", "humidity_controlled": "19", "length": "15", "outdoor_access": "20", "power": "22", "publish": "11", "quantity": "6", "regular_price": "4", "reservation_window": "14", "sparefoot_price": "5", "unit_key": "1", "unit_type_key": "3", "update_time": "28", "vehicle": "8", "width": "16" } - schema_attributes:
{ "_origin": "string", "active": "int", "alarm": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "covered": "int", "door_height": "decimal", "door_length": "decimal", "door_type": "varchar(9)", "door_width": "decimal", "drive_up": "int", "facility_key": "int", "floor": "int", "grouping_hash": "varchar(32)", "height": "decimal", "humidity_controlled": "int", "is_physical_unit": "string", "length": "decimal", "outdoor_access": "int", "power": "int", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "update_time": "timestamp", "vehicle": "int", "width": "decimal" } - schema_name_id: 379
- schema_scan_id: 6413700
- updated: 2026-04-14 04:01:33
-
Version 905795
- created: 2026-04-13 03:58:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_unit`\n(\n `audit_id` bigint , `unit_key` bigint , `facility_key` int , `unit_type_key` int , `regular_price` decimal , `sparefoot_price` decimal , `quantity` int , `climate_controlled` int , `vehicle` int , `drive_up` int , `active` int , `publish` int , `approve` int , `grouping_hash` varchar(32) , `reservation_window` int , `length` decimal , `width` decimal , `floor` int , `height` decimal , `humidity_controlled` int , `outdoor_access` int , `alarm` int , `power` int , `covered` int , `door_type` varchar(9) , `door_width` decimal , `door_height` decimal , `door_length` decimal , `update_time` timestamp , `_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/dwh_dim_unit/2026-04-13/1776070510'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_unit/2026-04-13/1776070510
- id: 905795
- processed: 1
- raw_data:
{ "_origin": "29", "active": "10", "alarm": "21", "approve": "12", "audit_id": "0", "climate_controlled": "7", "covered": "23", "door_height": "26", "door_length": "27", "door_type": "24", "door_width": "25", "drive_up": "9", "facility_key": "2", "floor": "17", "grouping_hash": "13", "height": "18", "humidity_controlled": "19", "length": "15", "outdoor_access": "20", "power": "22", "publish": "11", "quantity": "6", "regular_price": "4", "reservation_window": "14", "sparefoot_price": "5", "unit_key": "1", "unit_type_key": "3", "update_time": "28", "vehicle": "8", "width": "16" } - schema_attributes:
{ "_origin": "string", "active": "int", "alarm": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "covered": "int", "door_height": "decimal", "door_length": "decimal", "door_type": "varchar(9)", "door_width": "decimal", "drive_up": "int", "facility_key": "int", "floor": "int", "grouping_hash": "varchar(32)", "height": "decimal", "humidity_controlled": "int", "is_physical_unit": "string", "length": "decimal", "outdoor_access": "int", "power": "int", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "update_time": "timestamp", "vehicle": "int", "width": "decimal" } - schema_name_id: 379
- schema_scan_id: 6413151
- updated: 2026-04-13 03:58:18
-
Version 905582
- created: 2026-04-12 03:58:44
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_unit`\n(\n `audit_id` bigint , `unit_key` bigint , `facility_key` int , `unit_type_key` int , `regular_price` decimal , `sparefoot_price` decimal , `quantity` int , `climate_controlled` int , `vehicle` int , `drive_up` int , `active` int , `publish` int , `approve` int , `grouping_hash` varchar(32) , `reservation_window` int , `length` decimal , `width` decimal , `floor` int , `height` decimal , `humidity_controlled` int , `outdoor_access` int , `alarm` int , `power` int , `covered` int , `door_type` varchar(9) , `door_width` decimal , `door_height` decimal , `door_length` decimal , `update_time` timestamp , `_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/dwh_dim_unit/2026-04-12/1775984129'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_unit/2026-04-12/1775984129
- id: 905582
- processed: 1
- raw_data:
{ "_origin": "29", "active": "10", "alarm": "21", "approve": "12", "audit_id": "0", "climate_controlled": "7", "covered": "23", "door_height": "26", "door_length": "27", "door_type": "24", "door_width": "25", "drive_up": "9", "facility_key": "2", "floor": "17", "grouping_hash": "13", "height": "18", "humidity_controlled": "19", "length": "15", "outdoor_access": "20", "power": "22", "publish": "11", "quantity": "6", "regular_price": "4", "reservation_window": "14", "sparefoot_price": "5", "unit_key": "1", "unit_type_key": "3", "update_time": "28", "vehicle": "8", "width": "16" } - schema_attributes:
{ "_origin": "string", "active": "int", "alarm": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "covered": "int", "door_height": "decimal", "door_length": "decimal", "door_type": "varchar(9)", "door_width": "decimal", "drive_up": "int", "facility_key": "int", "floor": "int", "grouping_hash": "varchar(32)", "height": "decimal", "humidity_controlled": "int", "is_physical_unit": "string", "length": "decimal", "outdoor_access": "int", "power": "int", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "update_time": "timestamp", "vehicle": "int", "width": "decimal" } - schema_name_id: 379
- schema_scan_id: 6412746
- updated: 2026-04-12 03:58:58
-
Version 905379
- created: 2026-04-11 03:48:09
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_unit`\n(\n `audit_id` bigint , `unit_key` bigint , `facility_key` int , `unit_type_key` int , `regular_price` decimal , `sparefoot_price` decimal , `quantity` int , `climate_controlled` int , `vehicle` int , `drive_up` int , `active` int , `publish` int , `approve` int , `grouping_hash` varchar(32) , `reservation_window` int , `length` decimal , `width` decimal , `floor` int , `height` decimal , `humidity_controlled` int , `outdoor_access` int , `alarm` int , `power` int , `covered` int , `door_type` varchar(9) , `door_width` decimal , `door_height` decimal , `door_length` decimal , `update_time` timestamp , `_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/dwh_dim_unit/2026-04-11/1775897106'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_unit/2026-04-11/1775897106
- id: 905379
- processed: 1
- raw_data:
{ "_origin": "29", "active": "10", "alarm": "21", "approve": "12", "audit_id": "0", "climate_controlled": "7", "covered": "23", "door_height": "26", "door_length": "27", "door_type": "24", "door_width": "25", "drive_up": "9", "facility_key": "2", "floor": "17", "grouping_hash": "13", "height": "18", "humidity_controlled": "19", "length": "15", "outdoor_access": "20", "power": "22", "publish": "11", "quantity": "6", "regular_price": "4", "reservation_window": "14", "sparefoot_price": "5", "unit_key": "1", "unit_type_key": "3", "update_time": "28", "vehicle": "8", "width": "16" } - schema_attributes:
{ "_origin": "string", "active": "int", "alarm": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "covered": "int", "door_height": "decimal", "door_length": "decimal", "door_type": "varchar(9)", "door_width": "decimal", "drive_up": "int", "facility_key": "int", "floor": "int", "grouping_hash": "varchar(32)", "height": "decimal", "humidity_controlled": "int", "is_physical_unit": "string", "length": "decimal", "outdoor_access": "int", "power": "int", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "update_time": "timestamp", "vehicle": "int", "width": "decimal" } - schema_name_id: 379
- schema_scan_id: 6412363
- updated: 2026-04-11 03:48:21
-
Version 905172
- created: 2026-04-10 03:59:48
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_unit`\n(\n `audit_id` bigint , `unit_key` bigint , `facility_key` int , `unit_type_key` int , `regular_price` decimal , `sparefoot_price` decimal , `quantity` int , `climate_controlled` int , `vehicle` int , `drive_up` int , `active` int , `publish` int , `approve` int , `grouping_hash` varchar(32) , `reservation_window` int , `length` decimal , `width` decimal , `floor` int , `height` decimal , `humidity_controlled` int , `outdoor_access` int , `alarm` int , `power` int , `covered` int , `door_type` varchar(9) , `door_width` decimal , `door_height` decimal , `door_length` decimal , `update_time` timestamp , `_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/dwh_dim_unit/2026-04-10/1775811397'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_unit/2026-04-10/1775811397
- id: 905172
- processed: 1
- raw_data:
{ "_origin": "29", "active": "10", "alarm": "21", "approve": "12", "audit_id": "0", "climate_controlled": "7", "covered": "23", "door_height": "26", "door_length": "27", "door_type": "24", "door_width": "25", "drive_up": "9", "facility_key": "2", "floor": "17", "grouping_hash": "13", "height": "18", "humidity_controlled": "19", "length": "15", "outdoor_access": "20", "power": "22", "publish": "11", "quantity": "6", "regular_price": "4", "reservation_window": "14", "sparefoot_price": "5", "unit_key": "1", "unit_type_key": "3", "update_time": "28", "vehicle": "8", "width": "16" } - schema_attributes:
{ "_origin": "string", "active": "int", "alarm": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "covered": "int", "door_height": "decimal", "door_length": "decimal", "door_type": "varchar(9)", "door_width": "decimal", "drive_up": "int", "facility_key": "int", "floor": "int", "grouping_hash": "varchar(32)", "height": "decimal", "humidity_controlled": "int", "is_physical_unit": "string", "length": "decimal", "outdoor_access": "int", "power": "int", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "update_time": "timestamp", "vehicle": "int", "width": "decimal" } - schema_name_id: 379
- schema_scan_id: 6411877
- updated: 2026-04-10 03:59:59
-
Version 904966
- created: 2026-04-09 04:03:23
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_unit`\n(\n `audit_id` bigint , `unit_key` bigint , `facility_key` int , `unit_type_key` int , `regular_price` decimal , `sparefoot_price` decimal , `quantity` int , `climate_controlled` int , `vehicle` int , `drive_up` int , `active` int , `publish` int , `approve` int , `grouping_hash` varchar(32) , `reservation_window` int , `length` decimal , `width` decimal , `floor` int , `height` decimal , `humidity_controlled` int , `outdoor_access` int , `alarm` int , `power` int , `covered` int , `door_type` varchar(9) , `door_width` decimal , `door_height` decimal , `door_length` decimal , `update_time` timestamp , `_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/dwh_dim_unit/2026-04-09/1775725213'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_unit/2026-04-09/1775725213
- id: 904966
- processed: 1
- raw_data:
{ "_origin": "29", "active": "10", "alarm": "21", "approve": "12", "audit_id": "0", "climate_controlled": "7", "covered": "23", "door_height": "26", "door_length": "27", "door_type": "24", "door_width": "25", "drive_up": "9", "facility_key": "2", "floor": "17", "grouping_hash": "13", "height": "18", "humidity_controlled": "19", "length": "15", "outdoor_access": "20", "power": "22", "publish": "11", "quantity": "6", "regular_price": "4", "reservation_window": "14", "sparefoot_price": "5", "unit_key": "1", "unit_type_key": "3", "update_time": "28", "vehicle": "8", "width": "16" } - schema_attributes:
{ "_origin": "string", "active": "int", "alarm": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "covered": "int", "door_height": "decimal", "door_length": "decimal", "door_type": "varchar(9)", "door_width": "decimal", "drive_up": "int", "facility_key": "int", "floor": "int", "grouping_hash": "varchar(32)", "height": "decimal", "humidity_controlled": "int", "is_physical_unit": "string", "length": "decimal", "outdoor_access": "int", "power": "int", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "update_time": "timestamp", "vehicle": "int", "width": "decimal" } - schema_name_id: 379
- schema_scan_id: 6411369
- updated: 2026-04-09 04:03:34
-
Version 904731
- created: 2026-04-08 03:55:34
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_unit`\n(\n `audit_id` bigint , `unit_key` bigint , `facility_key` int , `unit_type_key` int , `regular_price` decimal , `sparefoot_price` decimal , `quantity` int , `climate_controlled` int , `vehicle` int , `drive_up` int , `active` int , `publish` int , `approve` int , `grouping_hash` varchar(32) , `reservation_window` int , `length` decimal , `width` decimal , `floor` int , `height` decimal , `humidity_controlled` int , `outdoor_access` int , `alarm` int , `power` int , `covered` int , `door_type` varchar(9) , `door_width` decimal , `door_height` decimal , `door_length` decimal , `update_time` timestamp , `_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/dwh_dim_unit/2026-04-08/1775638352'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_unit/2026-04-08/1775638352
- id: 904731
- processed: 1
- raw_data:
{ "_origin": "29", "active": "10", "alarm": "21", "approve": "12", "audit_id": "0", "climate_controlled": "7", "covered": "23", "door_height": "26", "door_length": "27", "door_type": "24", "door_width": "25", "drive_up": "9", "facility_key": "2", "floor": "17", "grouping_hash": "13", "height": "18", "humidity_controlled": "19", "length": "15", "outdoor_access": "20", "power": "22", "publish": "11", "quantity": "6", "regular_price": "4", "reservation_window": "14", "sparefoot_price": "5", "unit_key": "1", "unit_type_key": "3", "update_time": "28", "vehicle": "8", "width": "16" } - schema_attributes:
{ "_origin": "string", "active": "int", "alarm": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "covered": "int", "door_height": "decimal", "door_length": "decimal", "door_type": "varchar(9)", "door_width": "decimal", "drive_up": "int", "facility_key": "int", "floor": "int", "grouping_hash": "varchar(32)", "height": "decimal", "humidity_controlled": "int", "is_physical_unit": "string", "length": "decimal", "outdoor_access": "int", "power": "int", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "update_time": "timestamp", "vehicle": "int", "width": "decimal" } - schema_name_id: 379
- schema_scan_id: 6410853
- updated: 2026-04-08 03:55:45
-
Version 904538
- created: 2026-04-07 03:57:31
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_unit`\n(\n `audit_id` bigint , `unit_key` bigint , `facility_key` int , `unit_type_key` int , `regular_price` decimal , `sparefoot_price` decimal , `quantity` int , `climate_controlled` int , `vehicle` int , `drive_up` int , `active` int , `publish` int , `approve` int , `grouping_hash` varchar(32) , `reservation_window` int , `length` decimal , `width` decimal , `floor` int , `height` decimal , `humidity_controlled` int , `outdoor_access` int , `alarm` int , `power` int , `covered` int , `door_type` varchar(9) , `door_width` decimal , `door_height` decimal , `door_length` decimal , `update_time` timestamp , `_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/dwh_dim_unit/2026-04-07/1775552040'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_unit/2026-04-07/1775552040
- id: 904538
- processed: 1
- raw_data:
{ "_origin": "29", "active": "10", "alarm": "21", "approve": "12", "audit_id": "0", "climate_controlled": "7", "covered": "23", "door_height": "26", "door_length": "27", "door_type": "24", "door_width": "25", "drive_up": "9", "facility_key": "2", "floor": "17", "grouping_hash": "13", "height": "18", "humidity_controlled": "19", "length": "15", "outdoor_access": "20", "power": "22", "publish": "11", "quantity": "6", "regular_price": "4", "reservation_window": "14", "sparefoot_price": "5", "unit_key": "1", "unit_type_key": "3", "update_time": "28", "vehicle": "8", "width": "16" } - schema_attributes:
{ "_origin": "string", "active": "int", "alarm": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "covered": "int", "door_height": "decimal", "door_length": "decimal", "door_type": "varchar(9)", "door_width": "decimal", "drive_up": "int", "facility_key": "int", "floor": "int", "grouping_hash": "varchar(32)", "height": "decimal", "humidity_controlled": "int", "is_physical_unit": "string", "length": "decimal", "outdoor_access": "int", "power": "int", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "update_time": "timestamp", "vehicle": "int", "width": "decimal" } - schema_name_id: 379
- schema_scan_id: 6410364
- updated: 2026-04-07 03:57:42
-
Version 904319
- created: 2026-04-06 04:04:09
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_unit`\n(\n `audit_id` bigint , `unit_key` bigint , `facility_key` int , `unit_type_key` int , `regular_price` decimal , `sparefoot_price` decimal , `quantity` int , `climate_controlled` int , `vehicle` int , `drive_up` int , `active` int , `publish` int , `approve` int , `grouping_hash` varchar(32) , `reservation_window` int , `length` decimal , `width` decimal , `floor` int , `height` decimal , `humidity_controlled` int , `outdoor_access` int , `alarm` int , `power` int , `covered` int , `door_type` varchar(9) , `door_width` decimal , `door_height` decimal , `door_length` decimal , `update_time` timestamp , `_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/dwh_dim_unit/2026-04-06/1775466082'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_unit/2026-04-06/1775466082
- id: 904319
- processed: 1
- raw_data:
{ "_origin": "29", "active": "10", "alarm": "21", "approve": "12", "audit_id": "0", "climate_controlled": "7", "covered": "23", "door_height": "26", "door_length": "27", "door_type": "24", "door_width": "25", "drive_up": "9", "facility_key": "2", "floor": "17", "grouping_hash": "13", "height": "18", "humidity_controlled": "19", "length": "15", "outdoor_access": "20", "power": "22", "publish": "11", "quantity": "6", "regular_price": "4", "reservation_window": "14", "sparefoot_price": "5", "unit_key": "1", "unit_type_key": "3", "update_time": "28", "vehicle": "8", "width": "16" } - schema_attributes:
{ "_origin": "string", "active": "int", "alarm": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "covered": "int", "door_height": "decimal", "door_length": "decimal", "door_type": "varchar(9)", "door_width": "decimal", "drive_up": "int", "facility_key": "int", "floor": "int", "grouping_hash": "varchar(32)", "height": "decimal", "humidity_controlled": "int", "is_physical_unit": "string", "length": "decimal", "outdoor_access": "int", "power": "int", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "update_time": "timestamp", "vehicle": "int", "width": "decimal" } - schema_name_id: 379
- schema_scan_id: 6409814
- updated: 2026-04-06 04:04:23
-
Version 904093
- created: 2026-04-05 03:36:39
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_unit`\n(\n `audit_id` bigint , `unit_key` bigint , `facility_key` int , `unit_type_key` int , `regular_price` decimal , `sparefoot_price` decimal , `quantity` int , `climate_controlled` int , `vehicle` int , `drive_up` int , `active` int , `publish` int , `approve` int , `grouping_hash` varchar(32) , `reservation_window` int , `length` decimal , `width` decimal , `floor` int , `height` decimal , `humidity_controlled` int , `outdoor_access` int , `alarm` int , `power` int , `covered` int , `door_type` varchar(9) , `door_width` decimal , `door_height` decimal , `door_length` decimal , `update_time` timestamp , `_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/dwh_dim_unit/2026-04-05/1775377990'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_unit/2026-04-05/1775377990
- id: 904093
- processed: 1
- raw_data:
{ "_origin": "29", "active": "10", "alarm": "21", "approve": "12", "audit_id": "0", "climate_controlled": "7", "covered": "23", "door_height": "26", "door_length": "27", "door_type": "24", "door_width": "25", "drive_up": "9", "facility_key": "2", "floor": "17", "grouping_hash": "13", "height": "18", "humidity_controlled": "19", "length": "15", "outdoor_access": "20", "power": "22", "publish": "11", "quantity": "6", "regular_price": "4", "reservation_window": "14", "sparefoot_price": "5", "unit_key": "1", "unit_type_key": "3", "update_time": "28", "vehicle": "8", "width": "16" } - schema_attributes:
{ "_origin": "string", "active": "int", "alarm": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "covered": "int", "door_height": "decimal", "door_length": "decimal", "door_type": "varchar(9)", "door_width": "decimal", "drive_up": "int", "facility_key": "int", "floor": "int", "grouping_hash": "varchar(32)", "height": "decimal", "humidity_controlled": "int", "is_physical_unit": "string", "length": "decimal", "outdoor_access": "int", "power": "int", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "update_time": "timestamp", "vehicle": "int", "width": "decimal" } - schema_name_id: 379
- schema_scan_id: 6409401
- updated: 2026-04-05 03:36:53
-
Version 903915
- created: 2026-04-04 03:47:16
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_unit`\n(\n `audit_id` bigint , `unit_key` bigint , `facility_key` int , `unit_type_key` int , `regular_price` decimal , `sparefoot_price` decimal , `quantity` int , `climate_controlled` int , `vehicle` int , `drive_up` int , `active` int , `publish` int , `approve` int , `grouping_hash` varchar(32) , `reservation_window` int , `length` decimal , `width` decimal , `floor` int , `height` decimal , `humidity_controlled` int , `outdoor_access` int , `alarm` int , `power` int , `covered` int , `door_type` varchar(9) , `door_width` decimal , `door_height` decimal , `door_length` decimal , `update_time` timestamp , `_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/dwh_dim_unit/2026-04-04/1775292245'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_unit/2026-04-04/1775292245
- id: 903915
- processed: 1
- raw_data:
{ "_origin": "29", "active": "10", "alarm": "21", "approve": "12", "audit_id": "0", "climate_controlled": "7", "covered": "23", "door_height": "26", "door_length": "27", "door_type": "24", "door_width": "25", "drive_up": "9", "facility_key": "2", "floor": "17", "grouping_hash": "13", "height": "18", "humidity_controlled": "19", "length": "15", "outdoor_access": "20", "power": "22", "publish": "11", "quantity": "6", "regular_price": "4", "reservation_window": "14", "sparefoot_price": "5", "unit_key": "1", "unit_type_key": "3", "update_time": "28", "vehicle": "8", "width": "16" } - schema_attributes:
{ "_origin": "string", "active": "int", "alarm": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "covered": "int", "door_height": "decimal", "door_length": "decimal", "door_type": "varchar(9)", "door_width": "decimal", "drive_up": "int", "facility_key": "int", "floor": "int", "grouping_hash": "varchar(32)", "height": "decimal", "humidity_controlled": "int", "is_physical_unit": "string", "length": "decimal", "outdoor_access": "int", "power": "int", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "update_time": "timestamp", "vehicle": "int", "width": "decimal" } - schema_name_id: 379
- schema_scan_id: 6409044
- updated: 2026-04-04 03:47:27
-
Version 903699
- created: 2026-04-03 03:58:37
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_unit`\n(\n `audit_id` bigint , `unit_key` bigint , `facility_key` int , `unit_type_key` int , `regular_price` decimal , `sparefoot_price` decimal , `quantity` int , `climate_controlled` int , `vehicle` int , `drive_up` int , `active` int , `publish` int , `approve` int , `grouping_hash` varchar(32) , `reservation_window` int , `length` decimal , `width` decimal , `floor` int , `height` decimal , `humidity_controlled` int , `outdoor_access` int , `alarm` int , `power` int , `covered` int , `door_type` varchar(9) , `door_width` decimal , `door_height` decimal , `door_length` decimal , `update_time` timestamp , `_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/dwh_dim_unit/2026-04-03/1775206514'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_unit/2026-04-03/1775206514
- id: 903699
- processed: 1
- raw_data:
{ "_origin": "29", "active": "10", "alarm": "21", "approve": "12", "audit_id": "0", "climate_controlled": "7", "covered": "23", "door_height": "26", "door_length": "27", "door_type": "24", "door_width": "25", "drive_up": "9", "facility_key": "2", "floor": "17", "grouping_hash": "13", "height": "18", "humidity_controlled": "19", "length": "15", "outdoor_access": "20", "power": "22", "publish": "11", "quantity": "6", "regular_price": "4", "reservation_window": "14", "sparefoot_price": "5", "unit_key": "1", "unit_type_key": "3", "update_time": "28", "vehicle": "8", "width": "16" } - schema_attributes:
{ "_origin": "string", "active": "int", "alarm": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "covered": "int", "door_height": "decimal", "door_length": "decimal", "door_type": "varchar(9)", "door_width": "decimal", "drive_up": "int", "facility_key": "int", "floor": "int", "grouping_hash": "varchar(32)", "height": "decimal", "humidity_controlled": "int", "is_physical_unit": "string", "length": "decimal", "outdoor_access": "int", "power": "int", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "update_time": "timestamp", "vehicle": "int", "width": "decimal" } - schema_name_id: 379
- schema_scan_id: 6408553
- updated: 2026-04-03 03:58:51
Schema Scans: 15
Last at 2026-04-17 03:41:11
-
Scan 6415206
- duration: 0:00:15.069922
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6415206
- payload:
{ "datatype_dict": { "active": "int", "alarm": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "covered": "int", "door_height": "decimal", "door_length": "decimal", "door_type": "varchar(9)", "door_width": "decimal", "drive_up": "int", "facility_key": "int", "floor": "int", "grouping_hash": "varchar(32)", "height": "decimal", "humidity_controlled": "int", "length": "decimal", "origin_key": "varchar", "outdoor_access": "int", "power": "int", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "update_time": "timestamp", "vehicle": "int", "width": "decimal" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_dim_unit/2026-04-17/1776415101/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_unit/2026-04-17/1776415101", "key": "raw/dwh_dim_unit/2026-04-17/1776415101/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 11056449562538361391, "service_name": "redshift_unloads", "span_id": 139434906459942001, "trace_id": 18144333247607752453 } } - running: False
- schema_name_id: 379
- start_time: 2026-04-17 03:41:11
- success: True
- trace_id: 18144333247607752453
-
Scan 6414687
- duration: 0:00:15.089997
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6414687
- payload:
{ "datatype_dict": { "active": "int", "alarm": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "covered": "int", "door_height": "decimal", "door_length": "decimal", "door_type": "varchar(9)", "door_width": "decimal", "drive_up": "int", "facility_key": "int", "floor": "int", "grouping_hash": "varchar(32)", "height": "decimal", "humidity_controlled": "int", "length": "decimal", "origin_key": "varchar", "outdoor_access": "int", "power": "int", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "update_time": "timestamp", "vehicle": "int", "width": "decimal" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_dim_unit/2026-04-16/1776330406/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_unit/2026-04-16/1776330406", "key": "raw/dwh_dim_unit/2026-04-16/1776330406/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 9308538508869789070, "service_name": "redshift_unloads", "span_id": 12826995517603129853, "trace_id": 501924583287751977 } } - running: False
- schema_name_id: 379
- start_time: 2026-04-16 04:09:40
- success: True
- trace_id: 501924583287751977
-
Scan 6414202
- duration: 0:00:14.950795
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6414202
- payload:
{ "datatype_dict": { "active": "int", "alarm": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "covered": "int", "door_height": "decimal", "door_length": "decimal", "door_type": "varchar(9)", "door_width": "decimal", "drive_up": "int", "facility_key": "int", "floor": "int", "grouping_hash": "varchar(32)", "height": "decimal", "humidity_controlled": "int", "length": "decimal", "origin_key": "varchar", "outdoor_access": "int", "power": "int", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "update_time": "timestamp", "vehicle": "int", "width": "decimal" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_dim_unit/2026-04-15/1776243657/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_unit/2026-04-15/1776243657", "key": "raw/dwh_dim_unit/2026-04-15/1776243657/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 8703473704189130887, "service_name": "redshift_unloads", "span_id": 608973374731322243, "trace_id": 4700234475906101802 } } - running: False
- schema_name_id: 379
- start_time: 2026-04-15 04:03:34
- success: True
- trace_id: 4700234475906101802
-
Scan 6413700
- duration: 0:00:12.563614
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6413700
- payload:
{ "datatype_dict": { "active": "int", "alarm": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "covered": "int", "door_height": "decimal", "door_length": "decimal", "door_type": "varchar(9)", "door_width": "decimal", "drive_up": "int", "facility_key": "int", "floor": "int", "grouping_hash": "varchar(32)", "height": "decimal", "humidity_controlled": "int", "length": "decimal", "origin_key": "varchar", "outdoor_access": "int", "power": "int", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "update_time": "timestamp", "vehicle": "int", "width": "decimal" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_dim_unit/2026-04-14/1776157100/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_unit/2026-04-14/1776157100", "key": "raw/dwh_dim_unit/2026-04-14/1776157100/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 15115460726175498295, "service_name": "redshift_unloads", "span_id": 9265823732821634966, "trace_id": 6999772366919378675 } } - running: False
- schema_name_id: 379
- start_time: 2026-04-14 04:01:20
- success: True
- trace_id: 6999772366919378675
-
Scan 6413151
- duration: 0:00:12.446777
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6413151
- payload:
{ "datatype_dict": { "active": "int", "alarm": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "covered": "int", "door_height": "decimal", "door_length": "decimal", "door_type": "varchar(9)", "door_width": "decimal", "drive_up": "int", "facility_key": "int", "floor": "int", "grouping_hash": "varchar(32)", "height": "decimal", "humidity_controlled": "int", "length": "decimal", "origin_key": "varchar", "outdoor_access": "int", "power": "int", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "update_time": "timestamp", "vehicle": "int", "width": "decimal" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_dim_unit/2026-04-13/1776070510/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_unit/2026-04-13/1776070510", "key": "raw/dwh_dim_unit/2026-04-13/1776070510/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 16687972224976607386, "service_name": "redshift_unloads", "span_id": 8044045790934590404, "trace_id": 14934403595840995782 } } - running: False
- schema_name_id: 379
- start_time: 2026-04-13 03:58:06
- success: True
- trace_id: 14934403595840995782
-
Scan 6412746
- duration: 0:00:14.901745
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6412746
- payload:
{ "datatype_dict": { "active": "int", "alarm": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "covered": "int", "door_height": "decimal", "door_length": "decimal", "door_type": "varchar(9)", "door_width": "decimal", "drive_up": "int", "facility_key": "int", "floor": "int", "grouping_hash": "varchar(32)", "height": "decimal", "humidity_controlled": "int", "length": "decimal", "origin_key": "varchar", "outdoor_access": "int", "power": "int", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "update_time": "timestamp", "vehicle": "int", "width": "decimal" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_dim_unit/2026-04-12/1775984129/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_unit/2026-04-12/1775984129", "key": "raw/dwh_dim_unit/2026-04-12/1775984129/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 16401786255237101971, "service_name": "redshift_unloads", "span_id": 14259115050871455631, "trace_id": 128981817351885367 } } - running: False
- schema_name_id: 379
- start_time: 2026-04-12 03:58:43
- success: True
- trace_id: 128981817351885367
-
Scan 6412363
- duration: 0:00:12.413744
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6412363
- payload:
{ "datatype_dict": { "active": "int", "alarm": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "covered": "int", "door_height": "decimal", "door_length": "decimal", "door_type": "varchar(9)", "door_width": "decimal", "drive_up": "int", "facility_key": "int", "floor": "int", "grouping_hash": "varchar(32)", "height": "decimal", "humidity_controlled": "int", "length": "decimal", "origin_key": "varchar", "outdoor_access": "int", "power": "int", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "update_time": "timestamp", "vehicle": "int", "width": "decimal" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_dim_unit/2026-04-11/1775897106/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_unit/2026-04-11/1775897106", "key": "raw/dwh_dim_unit/2026-04-11/1775897106/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 11035999545767083576, "service_name": "redshift_unloads", "span_id": 15717332173444890794, "trace_id": 1894412203465135674 } } - running: False
- schema_name_id: 379
- start_time: 2026-04-11 03:48:08
- success: True
- trace_id: 1894412203465135674
-
Scan 6411877
- duration: 0:00:12.409994
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6411877
- payload:
{ "datatype_dict": { "active": "int", "alarm": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "covered": "int", "door_height": "decimal", "door_length": "decimal", "door_type": "varchar(9)", "door_width": "decimal", "drive_up": "int", "facility_key": "int", "floor": "int", "grouping_hash": "varchar(32)", "height": "decimal", "humidity_controlled": "int", "length": "decimal", "origin_key": "varchar", "outdoor_access": "int", "power": "int", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "update_time": "timestamp", "vehicle": "int", "width": "decimal" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_dim_unit/2026-04-10/1775811397/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_unit/2026-04-10/1775811397", "key": "raw/dwh_dim_unit/2026-04-10/1775811397/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 11903137847429314178, "service_name": "redshift_unloads", "span_id": 5970727159074937240, "trace_id": 7104925171459999520 } } - running: False
- schema_name_id: 379
- start_time: 2026-04-10 03:59:47
- success: True
- trace_id: 7104925171459999520
-
Scan 6411369
- duration: 0:00:12.330597
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6411369
- payload:
{ "datatype_dict": { "active": "int", "alarm": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "covered": "int", "door_height": "decimal", "door_length": "decimal", "door_type": "varchar(9)", "door_width": "decimal", "drive_up": "int", "facility_key": "int", "floor": "int", "grouping_hash": "varchar(32)", "height": "decimal", "humidity_controlled": "int", "length": "decimal", "origin_key": "varchar", "outdoor_access": "int", "power": "int", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "update_time": "timestamp", "vehicle": "int", "width": "decimal" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_dim_unit/2026-04-09/1775725213/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_unit/2026-04-09/1775725213", "key": "raw/dwh_dim_unit/2026-04-09/1775725213/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 18077575204624519118, "service_name": "redshift_unloads", "span_id": 15675195528984937323, "trace_id": 5512374474267052979 } } - running: False
- schema_name_id: 379
- start_time: 2026-04-09 04:03:22
- success: True
- trace_id: 5512374474267052979
-
Scan 6410853
- duration: 0:00:12.350397
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6410853
- payload:
{ "datatype_dict": { "active": "int", "alarm": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "covered": "int", "door_height": "decimal", "door_length": "decimal", "door_type": "varchar(9)", "door_width": "decimal", "drive_up": "int", "facility_key": "int", "floor": "int", "grouping_hash": "varchar(32)", "height": "decimal", "humidity_controlled": "int", "length": "decimal", "origin_key": "varchar", "outdoor_access": "int", "power": "int", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "update_time": "timestamp", "vehicle": "int", "width": "decimal" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_dim_unit/2026-04-08/1775638352/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_unit/2026-04-08/1775638352", "key": "raw/dwh_dim_unit/2026-04-08/1775638352/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 17697900101270493712, "service_name": "redshift_unloads", "span_id": 15436904155670100112, "trace_id": 12500981678594689396 } } - running: False
- schema_name_id: 379
- start_time: 2026-04-08 03:55:33
- success: True
- trace_id: 12500981678594689396
-
Scan 6410364
- duration: 0:00:12.537309
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6410364
- payload:
{ "datatype_dict": { "active": "int", "alarm": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "covered": "int", "door_height": "decimal", "door_length": "decimal", "door_type": "varchar(9)", "door_width": "decimal", "drive_up": "int", "facility_key": "int", "floor": "int", "grouping_hash": "varchar(32)", "height": "decimal", "humidity_controlled": "int", "length": "decimal", "origin_key": "varchar", "outdoor_access": "int", "power": "int", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "update_time": "timestamp", "vehicle": "int", "width": "decimal" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_dim_unit/2026-04-07/1775552040/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_unit/2026-04-07/1775552040", "key": "raw/dwh_dim_unit/2026-04-07/1775552040/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 183178923285041506, "service_name": "redshift_unloads", "span_id": 16121652411372019055, "trace_id": 11944096482287528553 } } - running: False
- schema_name_id: 379
- start_time: 2026-04-07 03:57:30
- success: True
- trace_id: 11944096482287528553
-
Scan 6409814
- duration: 0:00:15.032179
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6409814
- payload:
{ "datatype_dict": { "active": "int", "alarm": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "covered": "int", "door_height": "decimal", "door_length": "decimal", "door_type": "varchar(9)", "door_width": "decimal", "drive_up": "int", "facility_key": "int", "floor": "int", "grouping_hash": "varchar(32)", "height": "decimal", "humidity_controlled": "int", "length": "decimal", "origin_key": "varchar", "outdoor_access": "int", "power": "int", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "update_time": "timestamp", "vehicle": "int", "width": "decimal" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_dim_unit/2026-04-06/1775466082/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_unit/2026-04-06/1775466082", "key": "raw/dwh_dim_unit/2026-04-06/1775466082/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 18358000190599918788, "service_name": "redshift_unloads", "span_id": 14091954762811393261, "trace_id": 9198713867484109645 } } - running: False
- schema_name_id: 379
- start_time: 2026-04-06 04:04:08
- success: True
- trace_id: 9198713867484109645
-
Scan 6409401
- duration: 0:00:14.964502
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6409401
- payload:
{ "datatype_dict": { "active": "int", "alarm": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "covered": "int", "door_height": "decimal", "door_length": "decimal", "door_type": "varchar(9)", "door_width": "decimal", "drive_up": "int", "facility_key": "int", "floor": "int", "grouping_hash": "varchar(32)", "height": "decimal", "humidity_controlled": "int", "length": "decimal", "origin_key": "varchar", "outdoor_access": "int", "power": "int", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "update_time": "timestamp", "vehicle": "int", "width": "decimal" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_dim_unit/2026-04-05/1775377990/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_unit/2026-04-05/1775377990", "key": "raw/dwh_dim_unit/2026-04-05/1775377990/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 16560997719479882984, "service_name": "redshift_unloads", "span_id": 9132920548402219367, "trace_id": 6193812179181950498 } } - running: False
- schema_name_id: 379
- start_time: 2026-04-05 03:36:38
- success: True
- trace_id: 6193812179181950498
-
Scan 6409044
- duration: 0:00:12.322352
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6409044
- payload:
{ "datatype_dict": { "active": "int", "alarm": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "covered": "int", "door_height": "decimal", "door_length": "decimal", "door_type": "varchar(9)", "door_width": "decimal", "drive_up": "int", "facility_key": "int", "floor": "int", "grouping_hash": "varchar(32)", "height": "decimal", "humidity_controlled": "int", "length": "decimal", "origin_key": "varchar", "outdoor_access": "int", "power": "int", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "update_time": "timestamp", "vehicle": "int", "width": "decimal" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_dim_unit/2026-04-04/1775292245/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_unit/2026-04-04/1775292245", "key": "raw/dwh_dim_unit/2026-04-04/1775292245/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 16725943884710467491, "service_name": "redshift_unloads", "span_id": 10313937755385859173, "trace_id": 15674665233853659551 } } - running: False
- schema_name_id: 379
- start_time: 2026-04-04 03:47:15
- success: True
- trace_id: 15674665233853659551
-
Scan 6408553
- duration: 0:00:14.965335
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6408553
- payload:
{ "datatype_dict": { "active": "int", "alarm": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "covered": "int", "door_height": "decimal", "door_length": "decimal", "door_type": "varchar(9)", "door_width": "decimal", "drive_up": "int", "facility_key": "int", "floor": "int", "grouping_hash": "varchar(32)", "height": "decimal", "humidity_controlled": "int", "length": "decimal", "origin_key": "varchar", "outdoor_access": "int", "power": "int", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "update_time": "timestamp", "vehicle": "int", "width": "decimal" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_dim_unit/2026-04-03/1775206514/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_unit/2026-04-03/1775206514", "key": "raw/dwh_dim_unit/2026-04-03/1775206514/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 9347455045531249637, "service_name": "redshift_unloads", "span_id": 7688371184896882455, "trace_id": 5036515121092318722 } } - running: False
- schema_name_id: 379
- start_time: 2026-04-03 03:58:36
- success: True
- trace_id: 5036515121092318722
- attributes:
{ "_origin": "string", "active": "int", "alarm": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "covered": "int", "door_height": "decimal", "door_length": "decimal", "door_type": "varchar(9)", "door_width": "decimal", "drive_up": "int", "facility_key": "int", "floor": "int", "grouping_hash": "varchar(32)", "height": "decimal", "humidity_controlled": "int", "is_physical_unit": "string", "length": "decimal", "outdoor_access": "int", "power": "int", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "update_time": "timestamp", "vehicle": "int", "width": "decimal" } - created: 2026-04-17 03:41:12
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_unit`\n(\n `audit_id` bigint , `unit_key` bigint , `facility_key` int , `unit_type_key` int , `regular_price` decimal , `sparefoot_price` decimal , `quantity` int , `climate_controlled` int , `vehicle` int , `drive_up` int , `active` int , `publish` int , `approve` int , `grouping_hash` varchar(32) , `reservation_window` int , `length` decimal , `width` decimal , `floor` int , `height` decimal , `humidity_controlled` int , `outdoor_access` int , `alarm` int , `power` int , `covered` int , `door_type` varchar(9) , `door_width` decimal , `door_height` decimal , `door_length` decimal , `update_time` timestamp , `_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/dwh_dim_unit/2026-04-17/1776415101'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_unit`", "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_unit" }
- hostname: schemamanager-5c55c886bf-h2ts4
- name: schema_manager
- process_start: 2025-10-21 13:03:27
- sf_env: stage
- version: 2112174301
{
"name": {
"created": "2018-02-20 23:56:13",
"disabled": false,
"format": "raw",
"id": 379,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_stage_redshift",
"table": "analytics_dwh_dim_unit"
},
"type": "redshift"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"_origin": "string",
"active": "int",
"alarm": "int",
"approve": "int",
"audit_id": "bigint",
"climate_controlled": "int",
"covered": "int",
"door_height": "decimal",
"door_length": "decimal",
"door_type": "varchar(9)",
"door_width": "decimal",
"drive_up": "int",
"facility_key": "int",
"floor": "int",
"grouping_hash": "varchar(32)",
"height": "decimal",
"humidity_controlled": "int",
"is_physical_unit": "string",
"length": "decimal",
"outdoor_access": "int",
"power": "int",
"publish": "int",
"quantity": "int",
"regular_price": "decimal",
"reservation_window": "int",
"sparefoot_price": "decimal",
"unit_key": "bigint",
"unit_type_key": "int",
"update_time": "timestamp",
"vehicle": "int",
"width": "decimal"
},
"created": "2026-04-17 03:41:12",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_unit`\n(\n `audit_id` bigint , `unit_key` bigint , `facility_key` int , `unit_type_key` int , `regular_price` decimal , `sparefoot_price` decimal , `quantity` int , `climate_controlled` int , `vehicle` int , `drive_up` int , `active` int , `publish` int , `approve` int , `grouping_hash` varchar(32) , `reservation_window` int , `length` decimal , `width` decimal , `floor` int , `height` decimal , `humidity_controlled` int , `outdoor_access` int , `alarm` int , `power` int , `covered` int , `door_type` varchar(9) , `door_width` decimal , `door_height` decimal , `door_length` decimal , `update_time` timestamp , `_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/dwh_dim_unit/2026-04-17/1776415101'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_unit`",
"repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_unit"
}
},
"server": {
"hostname": "schemamanager-5c55c886bf-h2ts4",
"name": "schema_manager",
"process_start": "2025-10-21 13:03:27",
"sf_env": "stage",
"version": "2112174301"
}
}