Schema Info
Schema Name: sfdl_dev_redshift.analytics_dwh_dim_unit
- created: 2018-03-22 15:38:08
- disabled: False
- format: raw
- id: 667
- is_partitioned: False
- is_schema_datatyped: False
- name:
{ "database": "sfdl_dev_redshift", "table": "analytics_dwh_dim_unit" } - type: redshift
Schema Versions: 3
-
Version 4708840
- created: 2024-08-14 12:25:11
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`", "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/dwh_dim_unit/2024-08-14/1723656159'\n", "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-dev/raw/dwh_dim_unit/2024-08-14/1723656159
- id: 4708840
- 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: 667
- schema_scan_id: 6565226
- updated: 2024-08-14 12:25:24
-
Version 4705926
- created: 2024-05-14 06:13:34
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`", "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/dwh_dim_unit/2024-05-14/1715685082'\n", "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-dev/raw/dwh_dim_unit/2024-05-14/1715685082
- id: 4705926
- 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: 667
- schema_scan_id: 6490614
- updated: 2024-05-14 06:13:45
-
Version 4705775
- created: 2024-05-13 15:32:18
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`", "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_dwh_dim_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/dwh_dim_unit/2024-05-13/1715632185'\n", "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_dwh_dim_unit" ] - hive_path: s3://sfdl-redshift-analytics-dev/raw/dwh_dim_unit/2024-05-13/1715632185
- id: 4705775
- 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: 667
- schema_scan_id: 6490177
- updated: 2024-05-13 15:32:32
Schema Scans: 3
Last at 2024-08-14 12:25:10
-
Scan 6565226
- duration: 0:00:14.924431
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6565226
- 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-dev", "key": "meta/dwh_dim_unit/2024-08-14/1723656159/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-dev", "hive_path": "s3://sfdl-redshift-analytics-dev/raw/dwh_dim_unit/2024-08-14/1723656159", "key": "raw/dwh_dim_unit/2024-08-14/1723656159/0007_part_00.gz" }, "schema": { "name": "sfdl_dev_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 10976450954121613366, "service_name": "redshift_unloads", "span_id": 6963829447968824243, "trace_id": 5060576990237439079 } } - running: False
- schema_name_id: 667
- start_time: 2024-08-14 12:25:10
- success: True
- trace_id: 5060576990237439079
-
Scan 6490614
- duration: 0:00:12.362117
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6490614
- 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-dev", "key": "meta/dwh_dim_unit/2024-05-14/1715685082/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-dev", "hive_path": "s3://sfdl-redshift-analytics-dev/raw/dwh_dim_unit/2024-05-14/1715685082", "key": "raw/dwh_dim_unit/2024-05-14/1715685082/0007_part_00.gz" }, "schema": { "name": "sfdl_dev_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 517663093432872666, "service_name": "redshift_unloads", "span_id": 7364986461098178626, "trace_id": 6367005759483821524 } } - running: False
- schema_name_id: 667
- start_time: 2024-05-14 06:13:33
- success: True
- trace_id: 6367005759483821524
-
Scan 6490177
- duration: 0:00:14.892355
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6490177
- 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-dev", "key": "meta/dwh_dim_unit/2024-05-13/1715632185/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-dev", "hive_path": "s3://sfdl-redshift-analytics-dev/raw/dwh_dim_unit/2024-05-13/1715632185", "key": "raw/dwh_dim_unit/2024-05-13/1715632185/0007_part_00.gz" }, "schema": { "name": "sfdl_dev_redshift.analytics_dwh_dim_unit", "type": "redshift" }, "trace_context": { "parent_id": 16487680994129903339, "service_name": "redshift_unloads", "span_id": 15638383353212861635, "trace_id": 8418567621736183456 } } - running: False
- schema_name_id: 667
- start_time: 2024-05-13 15:32:17
- success: True
- trace_id: 8418567621736183456
- 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: 2024-08-14 12:25:11
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/dwh_dim_unit/2024-08-14/1723656159'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_dwh_dim_unit`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_dwh_dim_unit" }
- hostname: schemamanager-5447774fc6-4w58v
- name: schema_manager
- process_start: 2026-04-02 21:43:44
- sf_env: dev
- version: 2427328685
{
"name": {
"created": "2018-03-22 15:38:08",
"disabled": false,
"format": "raw",
"id": 667,
"is_partitioned": false,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_dev_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": "2024-08-14 12:25:11",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/dwh_dim_unit/2024-08-14/1723656159'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_dwh_dim_unit`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_dwh_dim_unit"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}