Schema Info
Schema Name: sfdl_dev_rds.ess_esscore_unit_types
- created: 2021-07-11 12:53:32
- disabled: False
- format: raw
- id: 1594
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_dev_rds", "table": "ess_esscore_unit_types" } - type: rds
Schema Versions: 3
-
Version 4685459
- created: 2021-07-22 18:55:20
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`", "DROP TABLE IF EXISTS `sfdl_dev_rds.ess_esscore_unit_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/esscore_unit_types/2021-07-22/1626998119'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_rds.ess_esscore_unit_types" ] - hive_path: s3://sfdl-rds-ess-dev/raw/esscore_unit_types/2021-07-22/1626998119
- id: 4685459
- 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: 1594
- schema_scan_id: 5817186
- updated: 2021-07-22 18:55:31
-
Version 4685358
- created: 2021-07-21 11:50:50
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`", "DROP TABLE IF EXISTS `sfdl_dev_rds.ess_esscore_unit_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/esscore_unit_types/2021-07-21/1626886240'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_rds.ess_esscore_unit_types" ] - hive_path: s3://sfdl-rds-ess-dev/raw/esscore_unit_types/2021-07-21/1626886240
- id: 4685358
- 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: 1594
- schema_scan_id: 5816779
- updated: 2021-07-21 11:51:01
-
Version 4685156
- created: 2021-07-11 12:53:32
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`", "DROP TABLE IF EXISTS `sfdl_dev_rds.ess_esscore_unit_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/esscore_unit_types/2021-07-11/1626026011'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_rds.ess_esscore_unit_types" ] - hive_path: s3://sfdl-rds-ess-dev/raw/esscore_unit_types/2021-07-11/1626026011
- id: 4685156
- 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: 1594
- schema_scan_id: 5813339
- updated: 2021-07-11 12:53:43
Schema Scans: 3
Last at 2021-07-22 18:55:20
-
Scan 5817186
- duration: 0:00:13.990208
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 0, "partitions_applied": false, "success": true } - id: 5817186
- 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-dev", "hive_path": "s3://sfdl-rds-ess-dev/raw/esscore_unit_types/2021-07-22/1626998119", "key": "raw/esscore_unit_types/2021-07-22/1626998119/split.ess_core.unit_types0.dat.gz" }, "schema": { "name": "sfdl_dev_rds.ess_esscore_unit_types", "type": "rds" } } - running: False
- schema_name_id: 1594
- start_time: 2021-07-22 18:55:20
- success: True
- trace_id: 9203462643987796727
-
Scan 5816779
- duration: 0:00:13.906092
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 0, "partitions_applied": false, "success": true } - id: 5816779
- 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-dev", "hive_path": "s3://sfdl-rds-ess-dev/raw/esscore_unit_types/2021-07-21/1626886240", "key": "raw/esscore_unit_types/2021-07-21/1626886240/split.ess_core.unit_types0.dat.gz" }, "schema": { "name": "sfdl_dev_rds.ess_esscore_unit_types", "type": "rds" } } - running: False
- schema_name_id: 1594
- start_time: 2021-07-21 11:50:50
- success: True
- trace_id: 15829878950991538041
-
Scan 5813339
- duration: 0:00:13.749954
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 0, "partitions_applied": false, "success": true } - id: 5813339
- 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-dev", "hive_path": "s3://sfdl-rds-ess-dev/raw/esscore_unit_types/2021-07-11/1626026011", "key": "raw/esscore_unit_types/2021-07-11/1626026011/split.ess_core.unit_types0.dat.gz" }, "schema": { "name": "sfdl_dev_rds.ess_esscore_unit_types", "type": "rds" } } - running: False
- schema_name_id: 1594
- start_time: 2021-07-11 12:53:32
- success: True
- trace_id: 16155578000290332988
- 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: 2021-07-22 18:55:20
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/esscore_unit_types/2021-07-22/1626998119'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_rds.ess_esscore_unit_types`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_rds.ess_esscore_unit_types" }
- hostname: schemamanager-5447774fc6-4w58v
- name: schema_manager
- process_start: 2026-04-02 21:43:44
- sf_env: dev
- version: 2427328685
{
"name": {
"created": "2021-07-11 12:53:32",
"disabled": false,
"format": "raw",
"id": 1594,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_dev_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": "2021-07-22 18:55:20",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/esscore_unit_types/2021-07-22/1626998119'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_rds.ess_esscore_unit_types`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_rds.ess_esscore_unit_types"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}