Schema Info
Schema Name: sfdl_stage_rds.ess_esscore_units
- created: 2021-07-12 13:44:44
- disabled: False
- format: raw
- id: 1131
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_stage_rds", "table": "ess_esscore_units" } - type: rds
Schema Versions: 4
-
Version 550887
- created: 2023-06-15 18:19:08
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.ess_esscore_units`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.ess_esscore_units`\n(\n `id` int , `unit_type_id` int , `name` varchar(255) , `notes` string , `created_at` timestamp , `updated_at` timestamp , `creator_id` int , `updater_id` int , `status` varchar(32) , `gate_key` varchar(255) , `doorking_directory_code` varchar(255) , `gate_key_pending_move_out` varchar(255) , `site_map_top` int , `site_map_left` int , `site_map_width` int , `site_map_height` int , `customer_id` int , `doorking_ent_code` varchar(255) , `auto_generate_customer_access_code` smallint , `prodatakey` string , `site_map_label_orientation` varchar(255) , `site_map_rotation` int , `form_updater_id` int , `form_updated_at` timestamp , `settings` string , `site_map_font_color` varchar(255) , `site_map_font_size` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '~', '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-rds-ess-stage/raw/esscore_units/2023-06-15/1686871147'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_rds.ess_esscore_units" ] - hive_path: s3://sfdl-rds-ess-stage/raw/esscore_units/2023-06-15/1686871147
- id: 550887
- processed: 1
- raw_data:
{ "auto_generate_customer_access_code": 18, "created_at": 4, "creator_id": 6, "customer_id": 16, "doorking_directory_code": 10, "doorking_ent_code": 17, "form_updated_at": 23, "form_updater_id": 22, "gate_key": 9, "gate_key_pending_move_out": 11, "id": 0, "name": 2, "notes": 3, "prodatakey": 19, "settings": 24, "site_map_font_color": 25, "site_map_font_size": 26, "site_map_height": 15, "site_map_label_orientation": 20, "site_map_left": 13, "site_map_rotation": 21, "site_map_top": 12, "site_map_width": 14, "status": 8, "unit_type_id": 1, "updated_at": 5, "updater_id": 7 } - schema_attributes:
{ "auto_generate_customer_access_code": "smallint", "created_at": "timestamp", "creator_id": "int", "customer_id": "int", "doorking_directory_code": "varchar(255)", "doorking_ent_code": "varchar(255)", "form_updated_at": "timestamp", "form_updater_id": "int", "gate_key": "varchar(255)", "gate_key_pending_move_out": "varchar(255)", "id": "int", "name": "varchar(255)", "notes": "string", "prodatakey": "string", "settings": "string", "site_map_font_color": "varchar(255)", "site_map_font_size": "int", "site_map_height": "int", "site_map_label_orientation": "varchar(255)", "site_map_left": "int", "site_map_rotation": "int", "site_map_top": "int", "site_map_width": "int", "status": "varchar(32)", "unit_type_id": "int", "updated_at": "timestamp", "updater_id": "int" } - schema_name_id: 1131
- schema_scan_id: 4963349
- updated: 2023-06-15 18:19:19
-
Version 402922
- created: 2022-06-22 20:54:38
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.ess_esscore_units`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.ess_esscore_units`\n(\n `id` int , `unit_type_id` int , `name` varchar(255) , `notes` string , `created_at` timestamp , `updated_at` timestamp , `creator_id` int , `updater_id` int , `status` varchar(32) , `gate_key` varchar(255) , `doorking_directory_code` varchar(255) , `gate_key_pending_move_out` varchar(255) , `site_map_top` int , `site_map_left` int , `site_map_width` int , `site_map_height` int , `customer_id` int , `doorking_ent_code` varchar(255) , `auto_generate_customer_access_code` smallint , `prodatakey` string , `site_map_label_orientation` varchar(255) , `site_map_rotation` int , `form_updater_id` int , `form_updated_at` timestamp , `settings` string , `site_map_font_color` varchar(255) , `site_map_font_size` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '~', '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-rds-ess-stage/raw/esscore_units/2022-06-23/1655949276'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_rds.ess_esscore_units" ] - hive_path: s3://sfdl-rds-ess-stage/raw/esscore_units/2022-06-23/1655949276
- id: 402922
- processed: 1
- raw_data:
{ "auto_generate_customer_access_code": 18, "created_at": 4, "creator_id": 6, "customer_id": 16, "doorking_directory_code": 10, "doorking_ent_code": 17, "form_updated_at": 23, "form_updater_id": 22, "gate_key": 9, "gate_key_pending_move_out": 11, "id": 0, "name": 2, "notes": 3, "prodatakey": 19, "settings": 24, "site_map_font_color": 25, "site_map_font_size": 26, "site_map_height": 15, "site_map_label_orientation": 20, "site_map_left": 13, "site_map_rotation": 21, "site_map_top": 12, "site_map_width": 14, "status": 8, "unit_type_id": 1, "updated_at": 5, "updater_id": 7 } - schema_attributes:
{ "auto_generate_customer_access_code": "smallint", "created_at": "timestamp", "creator_id": "int", "customer_id": "int", "doorking_directory_code": "varchar(255)", "doorking_ent_code": "varchar(255)", "form_updated_at": "timestamp", "form_updater_id": "int", "gate_key": "varchar(255)", "gate_key_pending_move_out": "varchar(255)", "id": "int", "name": "varchar(255)", "notes": "string", "prodatakey": "string", "settings": "string", "site_map_font_color": "varchar(255)", "site_map_font_size": "int", "site_map_height": "int", "site_map_label_orientation": "varchar(255)", "site_map_left": "int", "site_map_rotation": "int", "site_map_top": "int", "site_map_width": "int", "status": "varchar(32)", "unit_type_id": "int", "updated_at": "timestamp", "updater_id": "int" } - schema_name_id: 1131
- schema_scan_id: 3933513
- updated: 2022-06-22 20:54:49
-
Version 402827
- created: 2022-06-22 16:02:29
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.ess_esscore_units`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.ess_esscore_units`\n(\n `id` int , `unit_type_id` int , `name` varchar(255) , `notes` string , `created_at` timestamp , `updated_at` timestamp , `creator_id` int , `updater_id` int , `status` varchar(32) , `gate_key` varchar(255) , `doorking_directory_code` varchar(255) , `gate_key_pending_move_out` varchar(255) , `site_map_top` int , `site_map_left` int , `site_map_width` int , `site_map_height` int , `customer_id` int , `doorking_ent_code` varchar(255) , `auto_generate_customer_access_code` smallint , `prodatakey` string , `site_map_label_orientation` varchar(255) , `site_map_rotation` int , `form_updater_id` int , `form_updated_at` timestamp , `settings` string , `site_map_font_color` varchar(255) , `site_map_font_size` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '~', '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-rds-ess-stage/raw/esscore_units/2022-06-22/1655931747'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_rds.ess_esscore_units" ] - hive_path: s3://sfdl-rds-ess-stage/raw/esscore_units/2022-06-22/1655931747
- id: 402827
- processed: 1
- raw_data:
{ "auto_generate_customer_access_code": 18, "created_at": 4, "creator_id": 6, "customer_id": 16, "doorking_directory_code": 10, "doorking_ent_code": 17, "form_updated_at": 23, "form_updater_id": 22, "gate_key": 9, "gate_key_pending_move_out": 11, "id": 0, "name": 2, "notes": 3, "prodatakey": 19, "settings": 24, "site_map_font_color": 25, "site_map_font_size": 26, "site_map_height": 15, "site_map_label_orientation": 20, "site_map_left": 13, "site_map_rotation": 21, "site_map_top": 12, "site_map_width": 14, "status": 8, "unit_type_id": 1, "updated_at": 5, "updater_id": 7 } - schema_attributes:
{ "auto_generate_customer_access_code": "smallint", "created_at": "timestamp", "creator_id": "int", "customer_id": "int", "doorking_directory_code": "varchar(255)", "doorking_ent_code": "varchar(255)", "form_updated_at": "timestamp", "form_updater_id": "int", "gate_key": "varchar(255)", "gate_key_pending_move_out": "varchar(255)", "id": "int", "name": "varchar(255)", "notes": "string", "prodatakey": "string", "settings": "string", "site_map_font_color": "varchar(255)", "site_map_font_size": "int", "site_map_height": "int", "site_map_label_orientation": "varchar(255)", "site_map_left": "int", "site_map_rotation": "int", "site_map_top": "int", "site_map_width": "int", "status": "varchar(32)", "unit_type_id": "int", "updated_at": "timestamp", "updater_id": "int" } - schema_name_id: 1131
- schema_scan_id: 3932930
- updated: 2022-06-22 16:02:40
-
Version 341574
- created: 2021-07-24 00:08:12
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.ess_esscore_units`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.ess_esscore_units`\n(\n `id` int , `unit_type_id` int , `name` varchar(255) , `notes` string , `created_at` timestamp , `updated_at` timestamp , `creator_id` int , `updater_id` int , `status` varchar(32) , `gate_key` varchar(255) , `doorking_directory_code` varchar(255) , `gate_key_pending_move_out` varchar(255) , `site_map_top` int , `site_map_left` int , `site_map_width` int , `site_map_height` int , `customer_id` int , `doorking_ent_code` varchar(255) , `auto_generate_customer_access_code` smallint , `prodatakey` string , `site_map_label_orientation` varchar(255) , `site_map_rotation` int , `form_updater_id` int , `form_updated_at` timestamp , `settings` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '~', '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-rds-ess-stage/raw/esscore_units/2021-07-24/1627103291'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_rds.ess_esscore_units" ] - hive_path: s3://sfdl-rds-ess-stage/raw/esscore_units/2021-07-24/1627103291
- id: 341574
- processed: 1
- raw_data:
{ "auto_generate_customer_access_code": 18, "created_at": 4, "creator_id": 6, "customer_id": 16, "doorking_directory_code": 10, "doorking_ent_code": 17, "form_updated_at": 23, "form_updater_id": 22, "gate_key": 9, "gate_key_pending_move_out": 11, "id": 0, "name": 2, "notes": 3, "prodatakey": 19, "settings": 24, "site_map_height": 15, "site_map_label_orientation": 20, "site_map_left": 13, "site_map_rotation": 21, "site_map_top": 12, "site_map_width": 14, "status": 8, "unit_type_id": 1, "updated_at": 5, "updater_id": 7 } - schema_attributes:
{ "auto_generate_customer_access_code": "smallint", "created_at": "timestamp", "creator_id": "int", "customer_id": "int", "doorking_directory_code": "varchar(255)", "doorking_ent_code": "varchar(255)", "form_updated_at": "timestamp", "form_updater_id": "int", "gate_key": "varchar(255)", "gate_key_pending_move_out": "varchar(255)", "id": "int", "name": "varchar(255)", "notes": "string", "prodatakey": "string", "settings": "string", "site_map_height": "int", "site_map_label_orientation": "varchar(255)", "site_map_left": "int", "site_map_rotation": "int", "site_map_top": "int", "site_map_width": "int", "status": "varchar(32)", "unit_type_id": "int", "updated_at": "timestamp", "updater_id": "int" } - schema_name_id: 1131
- schema_scan_id: 3410644
- updated: 2021-07-24 00:08:23
Schema Scans: 4
Last at 2023-06-15 18:19:08
-
Scan 4963349
- duration: 0:00:11.009821
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 4963349
- payload:
{ "datatype_dict": { "auto_generate_customer_access_code": "smallint", "created_at": "timestamp", "creator_id": "int", "customer_id": "int", "doorking_directory_code": "varchar(255)", "doorking_ent_code": "varchar(255)", "form_updated_at": "timestamp", "form_updater_id": "int", "gate_key": "varchar(255)", "gate_key_pending_move_out": "varchar(255)", "id": "int", "name": "varchar(255)", "notes": "string", "prodatakey": "string", "settings": "string", "site_map_font_color": "varchar(255)", "site_map_font_size": "int", "site_map_height": "int", "site_map_label_orientation": "varchar(255)", "site_map_left": "int", "site_map_rotation": "int", "site_map_top": "int", "site_map_width": "int", "status": "varchar(32)", "unit_type_id": "int", "updated_at": "timestamp", "updater_id": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "~" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-rds-ess-stage", "hive_path": "s3://sfdl-rds-ess-stage/raw/esscore_units/2023-06-15/1686871147", "key": "raw/esscore_units/2023-06-15/1686871147/split.ess_core.units0.dat.gz" }, "schema": { "name": "sfdl_stage_rds.ess_esscore_units", "type": "rds" } } - running: False
- schema_name_id: 1131
- start_time: 2023-06-15 18:19:08
- success: True
- trace_id: 2068050118608323118
-
Scan 3933513
- duration: 0:00:14.050681
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 0, "partitions_applied": false, "success": true } - id: 3933513
- payload:
{ "datatype_dict": { "auto_generate_customer_access_code": "smallint", "created_at": "timestamp", "creator_id": "int", "customer_id": "int", "doorking_directory_code": "varchar(255)", "doorking_ent_code": "varchar(255)", "form_updated_at": "timestamp", "form_updater_id": "int", "gate_key": "varchar(255)", "gate_key_pending_move_out": "varchar(255)", "id": "int", "name": "varchar(255)", "notes": "string", "prodatakey": "string", "settings": "string", "site_map_font_color": "varchar(255)", "site_map_font_size": "int", "site_map_height": "int", "site_map_label_orientation": "varchar(255)", "site_map_left": "int", "site_map_rotation": "int", "site_map_top": "int", "site_map_width": "int", "status": "varchar(32)", "unit_type_id": "int", "updated_at": "timestamp", "updater_id": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "~" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-rds-ess-stage", "hive_path": "s3://sfdl-rds-ess-stage/raw/esscore_units/2022-06-23/1655949276", "key": "raw/esscore_units/2022-06-23/1655949276/split.ess_core.units0.dat.gz" }, "schema": { "name": "sfdl_stage_rds.ess_esscore_units", "type": "rds" } } - running: False
- schema_name_id: 1131
- start_time: 2022-06-22 20:54:37
- success: True
- trace_id: 4123414877099820217
-
Scan 3932930
- duration: 0:00:14.237742
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 0, "partitions_applied": false, "success": true } - id: 3932930
- payload:
{ "datatype_dict": { "auto_generate_customer_access_code": "smallint", "created_at": "timestamp", "creator_id": "int", "customer_id": "int", "doorking_directory_code": "varchar(255)", "doorking_ent_code": "varchar(255)", "form_updated_at": "timestamp", "form_updater_id": "int", "gate_key": "varchar(255)", "gate_key_pending_move_out": "varchar(255)", "id": "int", "name": "varchar(255)", "notes": "string", "prodatakey": "string", "settings": "string", "site_map_font_color": "varchar(255)", "site_map_font_size": "int", "site_map_height": "int", "site_map_label_orientation": "varchar(255)", "site_map_left": "int", "site_map_rotation": "int", "site_map_top": "int", "site_map_width": "int", "status": "varchar(32)", "unit_type_id": "int", "updated_at": "timestamp", "updater_id": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "~" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-rds-ess-stage", "hive_path": "s3://sfdl-rds-ess-stage/raw/esscore_units/2022-06-22/1655931747", "key": "raw/esscore_units/2022-06-22/1655931747/split.ess_core.units0.dat.gz" }, "schema": { "name": "sfdl_stage_rds.ess_esscore_units", "type": "rds" } } - running: False
- schema_name_id: 1131
- start_time: 2022-06-22 16:02:29
- success: True
- trace_id: 4223436651309113287
-
Scan 3410644
- duration: 0:00:14.314176
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 0, "partitions_applied": false, "success": true } - id: 3410644
- payload:
{ "datatype_dict": { "auto_generate_customer_access_code": "smallint", "created_at": "timestamp", "creator_id": "int", "customer_id": "int", "doorking_directory_code": "varchar(255)", "doorking_ent_code": "varchar(255)", "form_updated_at": "timestamp", "form_updater_id": "int", "gate_key": "varchar(255)", "gate_key_pending_move_out": "varchar(255)", "id": "int", "name": "varchar(255)", "notes": "string", "prodatakey": "string", "settings": "string", "site_map_height": "int", "site_map_label_orientation": "varchar(255)", "site_map_left": "int", "site_map_rotation": "int", "site_map_top": "int", "site_map_width": "int", "status": "varchar(32)", "unit_type_id": "int", "updated_at": "timestamp", "updater_id": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "~" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-rds-ess-stage", "hive_path": "s3://sfdl-rds-ess-stage/raw/esscore_units/2021-07-24/1627103291", "key": "raw/esscore_units/2021-07-24/1627103291/split.ess_core.units0.dat.gz" }, "schema": { "name": "sfdl_stage_rds.ess_esscore_units", "type": "rds" } } - running: False
- schema_name_id: 1131
- start_time: 2021-07-24 00:08:12
- success: True
- trace_id: 5205480364743369137
- attributes:
{ "auto_generate_customer_access_code": "smallint", "created_at": "timestamp", "creator_id": "int", "customer_id": "int", "doorking_directory_code": "varchar(255)", "doorking_ent_code": "varchar(255)", "form_updated_at": "timestamp", "form_updater_id": "int", "gate_key": "varchar(255)", "gate_key_pending_move_out": "varchar(255)", "id": "int", "name": "varchar(255)", "notes": "string", "prodatakey": "string", "settings": "string", "site_map_font_color": "varchar(255)", "site_map_font_size": "int", "site_map_height": "int", "site_map_label_orientation": "varchar(255)", "site_map_left": "int", "site_map_rotation": "int", "site_map_top": "int", "site_map_width": "int", "status": "varchar(32)", "unit_type_id": "int", "updated_at": "timestamp", "updater_id": "int" } - created: 2023-06-15 18:19:08
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.ess_esscore_units`\n(\n `id` int , `unit_type_id` int , `name` varchar(255) , `notes` string , `created_at` timestamp , `updated_at` timestamp , `creator_id` int , `updater_id` int , `status` varchar(32) , `gate_key` varchar(255) , `doorking_directory_code` varchar(255) , `gate_key_pending_move_out` varchar(255) , `site_map_top` int , `site_map_left` int , `site_map_width` int , `site_map_height` int , `customer_id` int , `doorking_ent_code` varchar(255) , `auto_generate_customer_access_code` smallint , `prodatakey` string , `site_map_label_orientation` varchar(255) , `site_map_rotation` int , `form_updater_id` int , `form_updated_at` timestamp , `settings` string , `site_map_font_color` varchar(255) , `site_map_font_size` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '~', '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-rds-ess-stage/raw/esscore_units/2023-06-15/1686871147'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.ess_esscore_units`", "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.ess_esscore_units" }
- hostname: schemamanager-5c55c886bf-h2ts4
- name: schema_manager
- process_start: 2025-10-21 13:03:27
- sf_env: stage
- version: 2112174301
{
"name": {
"created": "2021-07-12 13:44:44",
"disabled": false,
"format": "raw",
"id": 1131,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_stage_rds",
"table": "ess_esscore_units"
},
"type": "rds"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"auto_generate_customer_access_code": "smallint",
"created_at": "timestamp",
"creator_id": "int",
"customer_id": "int",
"doorking_directory_code": "varchar(255)",
"doorking_ent_code": "varchar(255)",
"form_updated_at": "timestamp",
"form_updater_id": "int",
"gate_key": "varchar(255)",
"gate_key_pending_move_out": "varchar(255)",
"id": "int",
"name": "varchar(255)",
"notes": "string",
"prodatakey": "string",
"settings": "string",
"site_map_font_color": "varchar(255)",
"site_map_font_size": "int",
"site_map_height": "int",
"site_map_label_orientation": "varchar(255)",
"site_map_left": "int",
"site_map_rotation": "int",
"site_map_top": "int",
"site_map_width": "int",
"status": "varchar(32)",
"unit_type_id": "int",
"updated_at": "timestamp",
"updater_id": "int"
},
"created": "2023-06-15 18:19:08",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.ess_esscore_units`\n(\n `id` int , `unit_type_id` int , `name` varchar(255) , `notes` string , `created_at` timestamp , `updated_at` timestamp , `creator_id` int , `updater_id` int , `status` varchar(32) , `gate_key` varchar(255) , `doorking_directory_code` varchar(255) , `gate_key_pending_move_out` varchar(255) , `site_map_top` int , `site_map_left` int , `site_map_width` int , `site_map_height` int , `customer_id` int , `doorking_ent_code` varchar(255) , `auto_generate_customer_access_code` smallint , `prodatakey` string , `site_map_label_orientation` varchar(255) , `site_map_rotation` int , `form_updater_id` int , `form_updated_at` timestamp , `settings` string , `site_map_font_color` varchar(255) , `site_map_font_size` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '~', '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-rds-ess-stage/raw/esscore_units/2023-06-15/1686871147'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.ess_esscore_units`",
"repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.ess_esscore_units"
}
},
"server": {
"hostname": "schemamanager-5c55c886bf-h2ts4",
"name": "schema_manager",
"process_start": "2025-10-21 13:03:27",
"sf_env": "stage",
"version": "2112174301"
}
}