Schema Info
Schema Name: sfdl_prod_redshift.analytics_dwh_dim_unit
- created: 2018-02-28 10:50:24
- disabled: False
- format: raw
- id: 245
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_redshift", "table": "analytics_dwh_dim_unit" } - type: redshift
Schema Versions: 15
-
Version 1717899
- created: 2026-04-17 03:43:00
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_unit/2026-04-17/1776415206'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit/2026-04-17/1776415206
- id: 1717899
- 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: 245
- schema_scan_id: 162168030
- updated: 2026-04-17 03:43:11
-
Version 1716667
- created: 2026-04-16 04:09:59
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_unit/2026-04-16/1776330409'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit/2026-04-16/1776330409
- id: 1716667
- 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: 245
- schema_scan_id: 162113324
- updated: 2026-04-16 04:10:10
-
Version 1715577
- created: 2026-04-15 04:01:38
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_unit/2026-04-15/1776243459'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit/2026-04-15/1776243459
- id: 1715577
- 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: 245
- schema_scan_id: 162057520
- updated: 2026-04-15 04:01:52
-
Version 1714261
- created: 2026-04-14 03:51:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_unit/2026-04-14/1776156490'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit/2026-04-14/1776156490
- id: 1714261
- 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: 245
- schema_scan_id: 162000914
- updated: 2026-04-14 03:52:21
-
Version 1713023
- created: 2026-04-13 03:54:09
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_unit/2026-04-13/1776070251'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit/2026-04-13/1776070251
- id: 1713023
- 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: 245
- schema_scan_id: 161943080
- updated: 2026-04-13 03:54:20
-
Version 1711833
- created: 2026-04-12 03:53:26
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_unit/2026-04-12/1775983831'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit/2026-04-12/1775983831
- id: 1711833
- 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: 245
- schema_scan_id: 161893685
- updated: 2026-04-12 03:53:39
-
Version 1710625
- created: 2026-04-11 03:46:05
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_unit/2026-04-11/1775896990'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit/2026-04-11/1775896990
- id: 1710625
- 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: 245
- schema_scan_id: 161841481
- updated: 2026-04-11 03:46:17
-
Version 1709446
- created: 2026-04-10 03:30:43
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_unit/2026-04-10/1775809679'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit/2026-04-10/1775809679
- id: 1709446
- 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: 245
- schema_scan_id: 161786195
- updated: 2026-04-10 03:30:54
-
Version 1708328
- created: 2026-04-09 03:44:21
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_unit/2026-04-09/1775724091'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit/2026-04-09/1775724091
- id: 1708328
- 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: 245
- schema_scan_id: 161730670
- updated: 2026-04-09 03:44:32
-
Version 1707147
- created: 2026-04-08 04:06:05
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_unit/2026-04-08/1775638990'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit/2026-04-08/1775638990
- id: 1707147
- 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: 245
- schema_scan_id: 161677004
- updated: 2026-04-08 04:06:17
-
Version 1705933
- created: 2026-04-07 03:49:52
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_unit/2026-04-07/1775551634'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit/2026-04-07/1775551634
- id: 1705933
- 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: 245
- schema_scan_id: 161619803
- updated: 2026-04-07 03:50:04
-
Version 1704696
- created: 2026-04-06 03:44:26
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_unit/2026-04-06/1775464877'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit/2026-04-06/1775464877
- id: 1704696
- 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: 245
- schema_scan_id: 161561892
- updated: 2026-04-06 03:44:40
-
Version 1703520
- created: 2026-04-05 04:04:11
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_unit/2026-04-05/1775379668'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit/2026-04-05/1775379668
- id: 1703520
- 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: 245
- schema_scan_id: 161516201
- updated: 2026-04-05 04:04:24
-
Version 1702321
- created: 2026-04-04 03:27:59
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_unit/2026-04-04/1775291128'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit/2026-04-04/1775291128
- id: 1702321
- 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: 245
- schema_scan_id: 161460688
- updated: 2026-04-04 03:28:13
-
Version 1701172
- created: 2026-04-03 03:59:43
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_unit/2026-04-03/1775206462'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit/2026-04-03/1775206462
- id: 1701172
- 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: 245
- schema_scan_id: 161402880
- updated: 2026-04-03 03:59:54
Schema Scans: 15
Last at 2026-04-17 03:42:59
-
Scan 162168030
- duration: 0:00:12.534473
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162168030
- 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-prod", "key": "meta/dwh_dim_unit/2026-04-17/1776415206/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit/2026-04-17/1776415206", "key": "raw/dwh_dim_unit/2026-04-17/1776415206/0007_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 14428556604465210099, "service_name": "redshift_unloads", "span_id": 8687547779831365361, "trace_id": 18112169066082786253 } } - running: False
- schema_name_id: 245
- start_time: 2026-04-17 03:42:59
- success: True
- trace_id: 18112169066082786253
-
Scan 162113324
- duration: 0:00:12.336437
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162113324
- 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-prod", "key": "meta/dwh_dim_unit/2026-04-16/1776330409/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit/2026-04-16/1776330409", "key": "raw/dwh_dim_unit/2026-04-16/1776330409/0007_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 11423260147799163107, "service_name": "redshift_unloads", "span_id": 7611376481613973332, "trace_id": 12955539135690881353 } } - running: False
- schema_name_id: 245
- start_time: 2026-04-16 04:09:58
- success: True
- trace_id: 12955539135690881353
-
Scan 162057520
- duration: 0:00:15.041708
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162057520
- 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-prod", "key": "meta/dwh_dim_unit/2026-04-15/1776243459/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit/2026-04-15/1776243459", "key": "raw/dwh_dim_unit/2026-04-15/1776243459/0007_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 12055610622591838918, "service_name": "redshift_unloads", "span_id": 5244580975899498846, "trace_id": 16386626390914445001 } } - running: False
- schema_name_id: 245
- start_time: 2026-04-15 04:01:37
- success: True
- trace_id: 16386626390914445001
-
Scan 162000914
- duration: 0:01:14.960364
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162000914
- 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-prod", "key": "meta/dwh_dim_unit/2026-04-14/1776156490/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit/2026-04-14/1776156490", "key": "raw/dwh_dim_unit/2026-04-14/1776156490/0007_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 12308947515169390612, "service_name": "redshift_unloads", "span_id": 7131064408504069156, "trace_id": 13792033356683616135 } } - running: False
- schema_name_id: 245
- start_time: 2026-04-14 03:51:06
- success: True
- trace_id: 13792033356683616135
-
Scan 161943080
- duration: 0:00:12.321338
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161943080
- 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-prod", "key": "meta/dwh_dim_unit/2026-04-13/1776070251/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit/2026-04-13/1776070251", "key": "raw/dwh_dim_unit/2026-04-13/1776070251/0007_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 1087604317564623433, "service_name": "redshift_unloads", "span_id": 13706083287962722030, "trace_id": 12263961133848460843 } } - running: False
- schema_name_id: 245
- start_time: 2026-04-13 03:54:08
- success: True
- trace_id: 12263961133848460843
-
Scan 161893685
- duration: 0:00:14.973633
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161893685
- 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-prod", "key": "meta/dwh_dim_unit/2026-04-12/1775983831/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit/2026-04-12/1775983831", "key": "raw/dwh_dim_unit/2026-04-12/1775983831/0007_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 14840823821549508040, "service_name": "redshift_unloads", "span_id": 7543019198965408768, "trace_id": 4672296919911216595 } } - running: False
- schema_name_id: 245
- start_time: 2026-04-12 03:53:24
- success: True
- trace_id: 4672296919911216595
-
Scan 161841481
- duration: 0:00:12.235302
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161841481
- 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-prod", "key": "meta/dwh_dim_unit/2026-04-11/1775896990/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit/2026-04-11/1775896990", "key": "raw/dwh_dim_unit/2026-04-11/1775896990/0007_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 9904550933427288475, "service_name": "redshift_unloads", "span_id": 3203295028557757764, "trace_id": 6016810094665010234 } } - running: False
- schema_name_id: 245
- start_time: 2026-04-11 03:46:04
- success: True
- trace_id: 6016810094665010234
-
Scan 161786195
- duration: 0:00:12.275132
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161786195
- 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-prod", "key": "meta/dwh_dim_unit/2026-04-10/1775809679/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit/2026-04-10/1775809679", "key": "raw/dwh_dim_unit/2026-04-10/1775809679/0007_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 2469065721689356894, "service_name": "redshift_unloads", "span_id": 13767442480706459216, "trace_id": 9125595183317781451 } } - running: False
- schema_name_id: 245
- start_time: 2026-04-10 03:30:42
- success: True
- trace_id: 9125595183317781451
-
Scan 161730670
- duration: 0:00:12.352997
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161730670
- 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-prod", "key": "meta/dwh_dim_unit/2026-04-09/1775724091/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit/2026-04-09/1775724091", "key": "raw/dwh_dim_unit/2026-04-09/1775724091/0007_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 9106997890730037010, "service_name": "redshift_unloads", "span_id": 9642490296086201065, "trace_id": 14727882923963540691 } } - running: False
- schema_name_id: 245
- start_time: 2026-04-09 03:44:19
- success: True
- trace_id: 14727882923963540691
-
Scan 161677004
- duration: 0:00:12.265158
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161677004
- 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-prod", "key": "meta/dwh_dim_unit/2026-04-08/1775638990/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit/2026-04-08/1775638990", "key": "raw/dwh_dim_unit/2026-04-08/1775638990/0007_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 1469810275746051967, "service_name": "redshift_unloads", "span_id": 579441233037831509, "trace_id": 6504458497834215032 } } - running: False
- schema_name_id: 245
- start_time: 2026-04-08 04:06:04
- success: True
- trace_id: 6504458497834215032
-
Scan 161619803
- duration: 0:00:12.310504
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161619803
- 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-prod", "key": "meta/dwh_dim_unit/2026-04-07/1775551634/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit/2026-04-07/1775551634", "key": "raw/dwh_dim_unit/2026-04-07/1775551634/0007_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 8172448012738710066, "service_name": "redshift_unloads", "span_id": 11035966454116007951, "trace_id": 4316105275932894197 } } - running: False
- schema_name_id: 245
- start_time: 2026-04-07 03:49:51
- success: True
- trace_id: 4316105275932894197
-
Scan 161561892
- duration: 0:00:14.804960
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161561892
- 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-prod", "key": "meta/dwh_dim_unit/2026-04-06/1775464877/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit/2026-04-06/1775464877", "key": "raw/dwh_dim_unit/2026-04-06/1775464877/0007_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 14499488138820473766, "service_name": "redshift_unloads", "span_id": 13343324222377462742, "trace_id": 10470398954210552444 } } - running: False
- schema_name_id: 245
- start_time: 2026-04-06 03:44:25
- success: True
- trace_id: 10470398954210552444
-
Scan 161516201
- duration: 0:00:14.787953
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161516201
- 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-prod", "key": "meta/dwh_dim_unit/2026-04-05/1775379668/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit/2026-04-05/1775379668", "key": "raw/dwh_dim_unit/2026-04-05/1775379668/0007_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 15590222086123502601, "service_name": "redshift_unloads", "span_id": 18330576088068570738, "trace_id": 7544922665916156105 } } - running: False
- schema_name_id: 245
- start_time: 2026-04-05 04:04:10
- success: True
- trace_id: 7544922665916156105
-
Scan 161460688
- duration: 0:00:14.879660
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161460688
- 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-prod", "key": "meta/dwh_dim_unit/2026-04-04/1775291128/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit/2026-04-04/1775291128", "key": "raw/dwh_dim_unit/2026-04-04/1775291128/0007_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 11984066688857904795, "service_name": "redshift_unloads", "span_id": 17257046323854871135, "trace_id": 13942440521372909649 } } - running: False
- schema_name_id: 245
- start_time: 2026-04-04 03:27:58
- success: True
- trace_id: 13942440521372909649
-
Scan 161402880
- duration: 0:00:12.232189
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161402880
- 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-prod", "key": "meta/dwh_dim_unit/2026-04-03/1775206462/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit/2026-04-03/1775206462", "key": "raw/dwh_dim_unit/2026-04-03/1775206462/0007_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 8182143463261973498, "service_name": "redshift_unloads", "span_id": 5222882625967003042, "trace_id": 108089339842274829 } } - running: False
- schema_name_id: 245
- start_time: 2026-04-03 03:59:42
- success: True
- trace_id: 108089339842274829
- 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:43:00
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_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-prod/raw/dwh_dim_unit/2026-04-17/1776415206'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2018-02-28 10:50:24",
"disabled": false,
"format": "raw",
"id": 245,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_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:43:00",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_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-prod/raw/dwh_dim_unit/2026-04-17/1776415206'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}