Schema Info
Schema Name: sfdl_prod_rds.ess_esscore_unit_types
- created: 2021-07-26 18:34:42
- disabled: False
- format: raw
- id: 937
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_rds", "table": "ess_esscore_unit_types" } - type: rds
Schema Versions: 3
-
Version 1397415
- created: 2025-07-24 01:37:06
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.ess_esscore_unit_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.ess_esscore_unit_types`\n(\n `id` int , `site_id` int , `width` decimal , `length` decimal , `height` decimal , `description` string , `created_at` timestamp , `updated_at` timestamp , `price_in_cents` int , `deposit_in_cents` int , `name` varchar(255) , `setup_fee_in_cents` int , `reservation_price_in_cents` int , `setup_fee_name` varchar(255) , `archived` smallint , `additional_deposit_name` varchar(255) , `additional_deposit_in_cents` int , `image` varchar(255) , `insured` smallint , `rent_tax_rate_id` int , `setup_fee_tax_rate_id` int , `rental_rate_change_rule_id` bigint , `unit_type_rate_change_rule_id` bigint , `agreement_template_id` bigint , `allow_tenant_protection` smallint , `photo_file_name` varchar(255) \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-prod/raw/esscore_unit_types/2025-07-24/1753339025'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_rds.ess_esscore_unit_types" ] - hive_path: s3://sfdl-rds-ess-prod/raw/esscore_unit_types/2025-07-24/1753339025
- id: 1397415
- processed: 1
- raw_data:
{ "additional_deposit_in_cents": 16, "additional_deposit_name": 15, "agreement_template_id": 23, "allow_tenant_protection": 24, "archived": 14, "created_at": 6, "deposit_in_cents": 9, "description": 5, "height": 4, "id": 0, "image": 17, "insured": 18, "length": 3, "name": 10, "photo_file_name": 25, "price_in_cents": 8, "rent_tax_rate_id": 19, "rental_rate_change_rule_id": 21, "reservation_price_in_cents": 12, "setup_fee_in_cents": 11, "setup_fee_name": 13, "setup_fee_tax_rate_id": 20, "site_id": 1, "unit_type_rate_change_rule_id": 22, "updated_at": 7, "width": 2 } - schema_attributes:
{ "additional_deposit_in_cents": "int", "additional_deposit_name": "varchar(255)", "agreement_template_id": "bigint", "allow_tenant_protection": "smallint", "archived": "smallint", "created_at": "timestamp", "deposit_in_cents": "int", "description": "string", "height": "decimal", "id": "int", "image": "varchar(255)", "insured": "smallint", "length": "decimal", "name": "varchar(255)", "photo_file_name": "varchar(255)", "price_in_cents": "int", "rent_tax_rate_id": "int", "rental_rate_change_rule_id": "bigint", "reservation_price_in_cents": "int", "setup_fee_in_cents": "int", "setup_fee_name": "varchar(255)", "setup_fee_tax_rate_id": "int", "site_id": "int", "unit_type_rate_change_rule_id": "bigint", "updated_at": "timestamp", "width": "decimal" } - schema_name_id: 937
- schema_scan_id: 146212101
- updated: 2025-07-24 01:37:20
-
Version 1372807
- created: 2025-07-04 00:21:27
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.ess_esscore_unit_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.ess_esscore_unit_types`\n(\n `id` int , `site_id` int , `width` decimal , `length` decimal , `height` decimal , `description` string , `created_at` timestamp , `updated_at` timestamp , `price_in_cents` int , `deposit_in_cents` int , `name` varchar(255) , `setup_fee_in_cents` int , `reservation_price_in_cents` int , `setup_fee_name` varchar(255) , `archived` smallint , `additional_deposit_name` varchar(255) , `additional_deposit_in_cents` int , `image` varchar(255) , `insured` smallint , `rent_tax_rate_id` int , `setup_fee_tax_rate_id` int , `rental_rate_change_rule_id` bigint , `unit_type_rate_change_rule_id` bigint , `agreement_template_id` bigint , `allow_tenant_protection` smallint , `photo_file_name` varchar(255) \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-prod/raw/esscore_unit_types/2025-07-04/1751606486'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_rds.ess_esscore_unit_types" ] - hive_path: s3://sfdl-rds-ess-prod/raw/esscore_unit_types/2025-07-04/1751606486
- id: 1372807
- processed: 1
- raw_data:
{ "additional_deposit_in_cents": 16, "additional_deposit_name": 15, "agreement_template_id": 23, "allow_tenant_protection": 24, "archived": 14, "created_at": 6, "deposit_in_cents": 9, "description": 5, "height": 4, "id": 0, "image": 17, "insured": 18, "length": 3, "name": 10, "photo_file_name": 25, "price_in_cents": 8, "rent_tax_rate_id": 19, "rental_rate_change_rule_id": 21, "reservation_price_in_cents": 12, "setup_fee_in_cents": 11, "setup_fee_name": 13, "setup_fee_tax_rate_id": 20, "site_id": 1, "unit_type_rate_change_rule_id": 22, "updated_at": 7, "width": 2 } - schema_attributes:
{ "additional_deposit_in_cents": "int", "additional_deposit_name": "varchar(255)", "agreement_template_id": "bigint", "allow_tenant_protection": "smallint", "archived": "smallint", "created_at": "timestamp", "deposit_in_cents": "int", "description": "string", "height": "decimal", "id": "int", "image": "varchar(255)", "insured": "smallint", "length": "decimal", "name": "varchar(255)", "photo_file_name": "varchar(255)", "price_in_cents": "int", "rent_tax_rate_id": "int", "rental_rate_change_rule_id": "bigint", "reservation_price_in_cents": "int", "setup_fee_in_cents": "int", "setup_fee_name": "varchar(255)", "setup_fee_tax_rate_id": "int", "site_id": "int", "unit_type_rate_change_rule_id": "bigint", "updated_at": "timestamp", "width": "decimal" } - schema_name_id: 937
- schema_scan_id: 145008097
- updated: 2025-07-04 00:21:38
-
Version 1332691
- created: 2025-06-02 09:37:08
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.ess_esscore_unit_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.ess_esscore_unit_types`\n(\n `id` int , `site_id` int , `width` decimal , `length` decimal , `height` decimal , `description` string , `created_at` timestamp , `updated_at` timestamp , `price_in_cents` int , `deposit_in_cents` int , `name` varchar(255) , `setup_fee_in_cents` int , `reservation_price_in_cents` int , `setup_fee_name` varchar(255) , `archived` smallint , `additional_deposit_name` varchar(255) , `additional_deposit_in_cents` int , `image` varchar(255) , `insured` smallint , `rent_tax_rate_id` int , `setup_fee_tax_rate_id` int , `rental_rate_change_rule_id` bigint , `unit_type_rate_change_rule_id` bigint , `agreement_template_id` bigint , `allow_tenant_protection` smallint , `photo_file_name` varchar(255) \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-prod/raw/esscore_unit_types/2025-06-02/1748875026'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_rds.ess_esscore_unit_types" ] - hive_path: s3://sfdl-rds-ess-prod/raw/esscore_unit_types/2025-06-02/1748875026
- id: 1332691
- processed: 1
- raw_data:
{ "additional_deposit_in_cents": 16, "additional_deposit_name": 15, "agreement_template_id": 23, "allow_tenant_protection": 24, "archived": 14, "created_at": 6, "deposit_in_cents": 9, "description": 5, "height": 4, "id": 0, "image": 17, "insured": 18, "length": 3, "name": 10, "photo_file_name": 25, "price_in_cents": 8, "rent_tax_rate_id": 19, "rental_rate_change_rule_id": 21, "reservation_price_in_cents": 12, "setup_fee_in_cents": 11, "setup_fee_name": 13, "setup_fee_tax_rate_id": 20, "site_id": 1, "unit_type_rate_change_rule_id": 22, "updated_at": 7, "width": 2 } - schema_attributes:
{ "additional_deposit_in_cents": "int", "additional_deposit_name": "varchar(255)", "agreement_template_id": "bigint", "allow_tenant_protection": "smallint", "archived": "smallint", "created_at": "timestamp", "deposit_in_cents": "int", "description": "string", "height": "decimal", "id": "int", "image": "varchar(255)", "insured": "smallint", "length": "decimal", "name": "varchar(255)", "photo_file_name": "varchar(255)", "price_in_cents": "int", "rent_tax_rate_id": "int", "rental_rate_change_rule_id": "bigint", "reservation_price_in_cents": "int", "setup_fee_in_cents": "int", "setup_fee_name": "varchar(255)", "setup_fee_tax_rate_id": "int", "site_id": "int", "unit_type_rate_change_rule_id": "bigint", "updated_at": "timestamp", "width": "decimal" } - schema_name_id: 937
- schema_scan_id: 143165014
- updated: 2025-06-02 09:37:21
Schema Scans: 3
Last at 2025-07-24 01:37:06
-
Scan 146212101
- duration: 0:00:13.638099
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 146212101
- payload:
{ "datatype_dict": { "additional_deposit_in_cents": "int", "additional_deposit_name": "varchar(255)", "agreement_template_id": "bigint", "allow_tenant_protection": "smallint", "archived": "smallint", "created_at": "timestamp", "deposit_in_cents": "int", "description": "string", "height": "decimal", "id": "int", "image": "varchar(255)", "insured": "smallint", "length": "decimal", "name": "varchar(255)", "photo_file_name": "varchar(255)", "price_in_cents": "int", "rent_tax_rate_id": "int", "rental_rate_change_rule_id": "bigint", "reservation_price_in_cents": "int", "setup_fee_in_cents": "int", "setup_fee_name": "varchar(255)", "setup_fee_tax_rate_id": "int", "site_id": "int", "unit_type_rate_change_rule_id": "bigint", "updated_at": "timestamp", "width": "decimal" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "~" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-rds-ess-prod", "hive_path": "s3://sfdl-rds-ess-prod/raw/esscore_unit_types/2025-07-24/1753339025", "key": "raw/esscore_unit_types/2025-07-24/1753339025/split.ess_core.unit_types0.dat.gz" }, "schema": { "name": "sfdl_prod_rds.ess_esscore_unit_types", "type": "rds" } } - running: False
- schema_name_id: 937
- start_time: 2025-07-24 01:37:06
- success: True
- trace_id: 10654356790302108988
-
Scan 145008097
- duration: 0:00:11.045293
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 145008097
- payload:
{ "datatype_dict": { "additional_deposit_in_cents": "int", "additional_deposit_name": "varchar(255)", "agreement_template_id": "bigint", "allow_tenant_protection": "smallint", "archived": "smallint", "created_at": "timestamp", "deposit_in_cents": "int", "description": "string", "height": "decimal", "id": "int", "image": "varchar(255)", "insured": "smallint", "length": "decimal", "name": "varchar(255)", "photo_file_name": "varchar(255)", "price_in_cents": "int", "rent_tax_rate_id": "int", "rental_rate_change_rule_id": "bigint", "reservation_price_in_cents": "int", "setup_fee_in_cents": "int", "setup_fee_name": "varchar(255)", "setup_fee_tax_rate_id": "int", "site_id": "int", "unit_type_rate_change_rule_id": "bigint", "updated_at": "timestamp", "width": "decimal" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "~" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-rds-ess-prod", "hive_path": "s3://sfdl-rds-ess-prod/raw/esscore_unit_types/2025-07-04/1751606486", "key": "raw/esscore_unit_types/2025-07-04/1751606486/split.ess_core.unit_types0.dat.gz" }, "schema": { "name": "sfdl_prod_rds.ess_esscore_unit_types", "type": "rds" } } - running: False
- schema_name_id: 937
- start_time: 2025-07-04 00:21:27
- success: True
- trace_id: 15012790532931473720
-
Scan 143165014
- duration: 0:00:13.623975
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 143165014
- payload:
{ "datatype_dict": { "additional_deposit_in_cents": "int", "additional_deposit_name": "varchar(255)", "agreement_template_id": "bigint", "allow_tenant_protection": "smallint", "archived": "smallint", "created_at": "timestamp", "deposit_in_cents": "int", "description": "string", "height": "decimal", "id": "int", "image": "varchar(255)", "insured": "smallint", "length": "decimal", "name": "varchar(255)", "photo_file_name": "varchar(255)", "price_in_cents": "int", "rent_tax_rate_id": "int", "rental_rate_change_rule_id": "bigint", "reservation_price_in_cents": "int", "setup_fee_in_cents": "int", "setup_fee_name": "varchar(255)", "setup_fee_tax_rate_id": "int", "site_id": "int", "unit_type_rate_change_rule_id": "bigint", "updated_at": "timestamp", "width": "decimal" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "~" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-rds-ess-prod", "hive_path": "s3://sfdl-rds-ess-prod/raw/esscore_unit_types/2025-06-02/1748875026", "key": "raw/esscore_unit_types/2025-06-02/1748875026/split.ess_core.unit_types0.dat.gz" }, "schema": { "name": "sfdl_prod_rds.ess_esscore_unit_types", "type": "rds" } } - running: False
- schema_name_id: 937
- start_time: 2025-06-02 09:37:08
- success: True
- trace_id: 1680198544742362076
- attributes:
{ "additional_deposit_in_cents": "int", "additional_deposit_name": "varchar(255)", "agreement_template_id": "bigint", "allow_tenant_protection": "smallint", "archived": "smallint", "created_at": "timestamp", "deposit_in_cents": "int", "description": "string", "height": "decimal", "id": "int", "image": "varchar(255)", "insured": "smallint", "length": "decimal", "name": "varchar(255)", "photo_file_name": "varchar(255)", "price_in_cents": "int", "rent_tax_rate_id": "int", "rental_rate_change_rule_id": "bigint", "reservation_price_in_cents": "int", "setup_fee_in_cents": "int", "setup_fee_name": "varchar(255)", "setup_fee_tax_rate_id": "int", "site_id": "int", "unit_type_rate_change_rule_id": "bigint", "updated_at": "timestamp", "width": "decimal" } - created: 2025-07-24 01:37:06
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.ess_esscore_unit_types`\n(\n `id` int , `site_id` int , `width` decimal , `length` decimal , `height` decimal , `description` string , `created_at` timestamp , `updated_at` timestamp , `price_in_cents` int , `deposit_in_cents` int , `name` varchar(255) , `setup_fee_in_cents` int , `reservation_price_in_cents` int , `setup_fee_name` varchar(255) , `archived` smallint , `additional_deposit_name` varchar(255) , `additional_deposit_in_cents` int , `image` varchar(255) , `insured` smallint , `rent_tax_rate_id` int , `setup_fee_tax_rate_id` int , `rental_rate_change_rule_id` bigint , `unit_type_rate_change_rule_id` bigint , `agreement_template_id` bigint , `allow_tenant_protection` smallint , `photo_file_name` varchar(255) \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-prod/raw/esscore_unit_types/2025-07-24/1753339025'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.ess_esscore_unit_types`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.ess_esscore_unit_types" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2021-07-26 18:34:42",
"disabled": false,
"format": "raw",
"id": 937,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_rds",
"table": "ess_esscore_unit_types"
},
"type": "rds"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"additional_deposit_in_cents": "int",
"additional_deposit_name": "varchar(255)",
"agreement_template_id": "bigint",
"allow_tenant_protection": "smallint",
"archived": "smallint",
"created_at": "timestamp",
"deposit_in_cents": "int",
"description": "string",
"height": "decimal",
"id": "int",
"image": "varchar(255)",
"insured": "smallint",
"length": "decimal",
"name": "varchar(255)",
"photo_file_name": "varchar(255)",
"price_in_cents": "int",
"rent_tax_rate_id": "int",
"rental_rate_change_rule_id": "bigint",
"reservation_price_in_cents": "int",
"setup_fee_in_cents": "int",
"setup_fee_name": "varchar(255)",
"setup_fee_tax_rate_id": "int",
"site_id": "int",
"unit_type_rate_change_rule_id": "bigint",
"updated_at": "timestamp",
"width": "decimal"
},
"created": "2025-07-24 01:37:06",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.ess_esscore_unit_types`\n(\n `id` int , `site_id` int , `width` decimal , `length` decimal , `height` decimal , `description` string , `created_at` timestamp , `updated_at` timestamp , `price_in_cents` int , `deposit_in_cents` int , `name` varchar(255) , `setup_fee_in_cents` int , `reservation_price_in_cents` int , `setup_fee_name` varchar(255) , `archived` smallint , `additional_deposit_name` varchar(255) , `additional_deposit_in_cents` int , `image` varchar(255) , `insured` smallint , `rent_tax_rate_id` int , `setup_fee_tax_rate_id` int , `rental_rate_change_rule_id` bigint , `unit_type_rate_change_rule_id` bigint , `agreement_template_id` bigint , `allow_tenant_protection` smallint , `photo_file_name` varchar(255) \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-prod/raw/esscore_unit_types/2025-07-24/1753339025'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.ess_esscore_unit_types`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.ess_esscore_unit_types"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}