Schema Info
Schema Name: sfdl_prod_rds.ess_esscore_rentals
- created: 2021-07-26 18:33:14
- disabled: False
- format: raw
- id: 933
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_rds", "table": "ess_esscore_rentals" } - type: rds
Schema Versions: 3
-
Version 1372699
- created: 2025-07-03 23:55:08
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.ess_esscore_rentals`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.ess_esscore_rentals`\n(\n `id` int , `unit_id` int , `customer_id` int , `billing_cycle` int , `canceled_at` timestamp , `available_at` timestamp , `created_at` timestamp , `updated_at` timestamp , `amount_rented_for_in_cents` int , `creator_id` int , `updater_id` int , `site_id` int , `approved_creation_at` timestamp , `approved_cancelation_at` timestamp , `rented_on` date , `deposit_in_cents` int , `prorated_amount_in_cents` int , `originally_rented_on` date , `discount` decimal(5,4) , `pending_prorated_in_cents` int , `setup_fee_in_cents` int , `reservation_id` int , `move_in_on` date , `deposit_refunded_in_cents` int , `deposit_not_refunded_explanation` string , `plan_price_in_cents` int , `paid_through_ends_on` date , `move_out_on` date , `additional_deposit_in_cents` int , `additional_deposit_refunded_in_cents` int , `additional_deposit_not_refunded_explanation` string , `moved_out_at` timestamp , `next_due_on` date , `billing_day_of_month` int , `tax_rate_id` int , `setup_fee_tax_rate` decimal(5,4) , `move_out_finalizer_id` int , `move_out_scheduler_id` int , `exempt_from_rate_management` smallint , `agreement` varchar(255) , `agreement_signature` string , `agreement_signed_at` timestamp , `agreement_signer_id` int , `agreement_signed_externally` smallint , `settings` string , `form_updater_id` int , `form_updated_at` timestamp , `tenant_protection_addendum` varchar(255) , `tpp_declined_at` timestamp , `marketplace_reservation_id` bigint , `self_insured_policy_expires_on` date , `agreement_signed_externally_at` timestamp \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_rentals/2025-07-04/1751604765'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_rds.ess_esscore_rentals" ] - hive_path: s3://sfdl-rds-ess-prod/raw/esscore_rentals/2025-07-04/1751604765
- id: 1372699
- processed: 1
- raw_data:
{ "additional_deposit_in_cents": 28, "additional_deposit_not_refunded_explanation": 30, "additional_deposit_refunded_in_cents": 29, "agreement": 39, "agreement_signature": 40, "agreement_signed_at": 41, "agreement_signed_externally": 43, "agreement_signed_externally_at": 51, "agreement_signer_id": 42, "amount_rented_for_in_cents": 8, "approved_cancelation_at": 13, "approved_creation_at": 12, "available_at": 5, "billing_cycle": 3, "billing_day_of_month": 33, "canceled_at": 4, "created_at": 6, "creator_id": 9, "customer_id": 2, "deposit_in_cents": 15, "deposit_not_refunded_explanation": 24, "deposit_refunded_in_cents": 23, "discount": 18, "exempt_from_rate_management": 38, "form_updated_at": 46, "form_updater_id": 45, "id": 0, "marketplace_reservation_id": 49, "move_in_on": 22, "move_out_finalizer_id": 36, "move_out_on": 27, "move_out_scheduler_id": 37, "moved_out_at": 31, "next_due_on": 32, "originally_rented_on": 17, "paid_through_ends_on": 26, "pending_prorated_in_cents": 19, "plan_price_in_cents": 25, "prorated_amount_in_cents": 16, "rented_on": 14, "reservation_id": 21, "self_insured_policy_expires_on": 50, "settings": 44, "setup_fee_in_cents": 20, "setup_fee_tax_rate": 35, "site_id": 11, "tax_rate_id": 34, "tenant_protection_addendum": 47, "tpp_declined_at": 48, "unit_id": 1, "updated_at": 7, "updater_id": 10 } - schema_attributes:
{ "additional_deposit_in_cents": "int", "additional_deposit_not_refunded_explanation": "string", "additional_deposit_refunded_in_cents": "int", "agreement": "varchar(255)", "agreement_signature": "string", "agreement_signed_at": "timestamp", "agreement_signed_externally": "smallint", "agreement_signed_externally_at": "timestamp", "agreement_signer_id": "int", "amount_rented_for_in_cents": "int", "approved_cancelation_at": "timestamp", "approved_creation_at": "timestamp", "available_at": "timestamp", "billing_cycle": "int", "billing_day_of_month": "int", "canceled_at": "timestamp", "created_at": "timestamp", "creator_id": "int", "customer_id": "int", "deposit_in_cents": "int", "deposit_not_refunded_explanation": "string", "deposit_refunded_in_cents": "int", "discount": "decimal(5,4)", "exempt_from_rate_management": "smallint", "form_updated_at": "timestamp", "form_updater_id": "int", "id": "int", "marketplace_reservation_id": "bigint", "move_in_on": "date", "move_out_finalizer_id": "int", "move_out_on": "date", "move_out_scheduler_id": "int", "moved_out_at": "timestamp", "next_due_on": "date", "originally_rented_on": "date", "paid_through_ends_on": "date", "pending_prorated_in_cents": "int", "plan_price_in_cents": "int", "prorated_amount_in_cents": "int", "rented_on": "date", "reservation_id": "int", "self_insured_policy_expires_on": "date", "settings": "string", "setup_fee_in_cents": "int", "setup_fee_tax_rate": "decimal(5,4)", "site_id": "int", "tax_rate_id": "int", "tenant_protection_addendum": "varchar(255)", "tpp_declined_at": "timestamp", "unit_id": "int", "updated_at": "timestamp", "updater_id": "int" } - schema_name_id: 933
- schema_scan_id: 145006834
- updated: 2025-07-03 23:55:22
-
Version 1332656
- created: 2025-06-02 09:23:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.ess_esscore_rentals`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.ess_esscore_rentals`\n(\n `id` int , `unit_id` int , `customer_id` int , `billing_cycle` int , `canceled_at` timestamp , `available_at` timestamp , `created_at` timestamp , `updated_at` timestamp , `amount_rented_for_in_cents` int , `creator_id` int , `updater_id` int , `site_id` int , `approved_creation_at` timestamp , `approved_cancelation_at` timestamp , `rented_on` date , `deposit_in_cents` int , `prorated_amount_in_cents` int , `originally_rented_on` date , `discount` decimal(5,4) , `pending_prorated_in_cents` int , `setup_fee_in_cents` int , `reservation_id` int , `move_in_on` date , `deposit_refunded_in_cents` int , `deposit_not_refunded_explanation` string , `plan_price_in_cents` int , `paid_through_ends_on` date , `move_out_on` date , `additional_deposit_in_cents` int , `additional_deposit_refunded_in_cents` int , `additional_deposit_not_refunded_explanation` string , `moved_out_at` timestamp , `next_due_on` date , `billing_day_of_month` int , `tax_rate_id` int , `setup_fee_tax_rate` decimal(5,4) , `move_out_finalizer_id` int , `move_out_scheduler_id` int , `exempt_from_rate_management` smallint , `agreement` varchar(255) , `agreement_signature` string , `agreement_signed_at` timestamp , `agreement_signer_id` int , `agreement_signed_externally` smallint , `settings` string , `form_updater_id` int , `form_updated_at` timestamp , `tenant_protection_addendum` varchar(255) , `tpp_declined_at` timestamp , `marketplace_reservation_id` bigint , `self_insured_policy_expires_on` date , `agreement_signed_externally_at` timestamp \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_rentals/2025-06-02/1748874067'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_rds.ess_esscore_rentals" ] - hive_path: s3://sfdl-rds-ess-prod/raw/esscore_rentals/2025-06-02/1748874067
- id: 1332656
- processed: 1
- raw_data:
{ "additional_deposit_in_cents": 28, "additional_deposit_not_refunded_explanation": 30, "additional_deposit_refunded_in_cents": 29, "agreement": 39, "agreement_signature": 40, "agreement_signed_at": 41, "agreement_signed_externally": 43, "agreement_signed_externally_at": 51, "agreement_signer_id": 42, "amount_rented_for_in_cents": 8, "approved_cancelation_at": 13, "approved_creation_at": 12, "available_at": 5, "billing_cycle": 3, "billing_day_of_month": 33, "canceled_at": 4, "created_at": 6, "creator_id": 9, "customer_id": 2, "deposit_in_cents": 15, "deposit_not_refunded_explanation": 24, "deposit_refunded_in_cents": 23, "discount": 18, "exempt_from_rate_management": 38, "form_updated_at": 46, "form_updater_id": 45, "id": 0, "marketplace_reservation_id": 49, "move_in_on": 22, "move_out_finalizer_id": 36, "move_out_on": 27, "move_out_scheduler_id": 37, "moved_out_at": 31, "next_due_on": 32, "originally_rented_on": 17, "paid_through_ends_on": 26, "pending_prorated_in_cents": 19, "plan_price_in_cents": 25, "prorated_amount_in_cents": 16, "rented_on": 14, "reservation_id": 21, "self_insured_policy_expires_on": 50, "settings": 44, "setup_fee_in_cents": 20, "setup_fee_tax_rate": 35, "site_id": 11, "tax_rate_id": 34, "tenant_protection_addendum": 47, "tpp_declined_at": 48, "unit_id": 1, "updated_at": 7, "updater_id": 10 } - schema_attributes:
{ "additional_deposit_in_cents": "int", "additional_deposit_not_refunded_explanation": "string", "additional_deposit_refunded_in_cents": "int", "agreement": "varchar(255)", "agreement_signature": "string", "agreement_signed_at": "timestamp", "agreement_signed_externally": "smallint", "agreement_signed_externally_at": "timestamp", "agreement_signer_id": "int", "amount_rented_for_in_cents": "int", "approved_cancelation_at": "timestamp", "approved_creation_at": "timestamp", "available_at": "timestamp", "billing_cycle": "int", "billing_day_of_month": "int", "canceled_at": "timestamp", "created_at": "timestamp", "creator_id": "int", "customer_id": "int", "deposit_in_cents": "int", "deposit_not_refunded_explanation": "string", "deposit_refunded_in_cents": "int", "discount": "decimal(5,4)", "exempt_from_rate_management": "smallint", "form_updated_at": "timestamp", "form_updater_id": "int", "id": "int", "marketplace_reservation_id": "bigint", "move_in_on": "date", "move_out_finalizer_id": "int", "move_out_on": "date", "move_out_scheduler_id": "int", "moved_out_at": "timestamp", "next_due_on": "date", "originally_rented_on": "date", "paid_through_ends_on": "date", "pending_prorated_in_cents": "int", "plan_price_in_cents": "int", "prorated_amount_in_cents": "int", "rented_on": "date", "reservation_id": "int", "self_insured_policy_expires_on": "date", "settings": "string", "setup_fee_in_cents": "int", "setup_fee_tax_rate": "decimal(5,4)", "site_id": "int", "tax_rate_id": "int", "tenant_protection_addendum": "varchar(255)", "tpp_declined_at": "timestamp", "unit_id": "int", "updated_at": "timestamp", "updater_id": "int" } - schema_name_id: 933
- schema_scan_id: 143164547
- updated: 2025-06-02 09:23:30
-
Version 1331278
- created: 2025-06-01 09:32:12
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.ess_esscore_rentals`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.ess_esscore_rentals`\n(\n `id` int , `unit_id` int , `customer_id` int , `billing_cycle` int , `canceled_at` timestamp , `available_at` timestamp , `created_at` timestamp , `updated_at` timestamp , `amount_rented_for_in_cents` int , `creator_id` int , `updater_id` int , `site_id` int , `approved_creation_at` timestamp , `approved_cancelation_at` timestamp , `rented_on` date , `deposit_in_cents` int , `prorated_amount_in_cents` int , `originally_rented_on` date , `discount` decimal(5,4) , `pending_prorated_in_cents` int , `setup_fee_in_cents` int , `reservation_id` int , `move_in_on` date , `deposit_refunded_in_cents` int , `deposit_not_refunded_explanation` string , `plan_price_in_cents` int , `paid_through_ends_on` date , `move_out_on` date , `additional_deposit_in_cents` int , `additional_deposit_refunded_in_cents` int , `additional_deposit_not_refunded_explanation` string , `moved_out_at` timestamp , `next_due_on` date , `billing_day_of_month` int , `tax_rate_id` int , `setup_fee_tax_rate` decimal(5,4) , `move_out_finalizer_id` int , `move_out_scheduler_id` int , `exempt_from_rate_management` smallint , `agreement` varchar(255) , `agreement_signature` string , `agreement_signed_at` timestamp , `agreement_signer_id` int , `agreement_signed_externally` smallint , `settings` string , `form_updater_id` int , `form_updated_at` timestamp , `tenant_protection_addendum` varchar(255) , `tpp_declined_at` timestamp , `marketplace_reservation_id` bigint , `self_insured_policy_expires_on` date , `agreement_signed_externally_at` timestamp \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_rentals/2025-06-01/1748788207'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_rds.ess_esscore_rentals" ] - hive_path: s3://sfdl-rds-ess-prod/raw/esscore_rentals/2025-06-01/1748788207
- id: 1331278
- processed: 1
- raw_data:
{ "additional_deposit_in_cents": 28, "additional_deposit_not_refunded_explanation": 30, "additional_deposit_refunded_in_cents": 29, "agreement": 39, "agreement_signature": 40, "agreement_signed_at": 41, "agreement_signed_externally": 43, "agreement_signed_externally_at": 51, "agreement_signer_id": 42, "amount_rented_for_in_cents": 8, "approved_cancelation_at": 13, "approved_creation_at": 12, "available_at": 5, "billing_cycle": 3, "billing_day_of_month": 33, "canceled_at": 4, "created_at": 6, "creator_id": 9, "customer_id": 2, "deposit_in_cents": 15, "deposit_not_refunded_explanation": 24, "deposit_refunded_in_cents": 23, "discount": 18, "exempt_from_rate_management": 38, "form_updated_at": 46, "form_updater_id": 45, "id": 0, "marketplace_reservation_id": 49, "move_in_on": 22, "move_out_finalizer_id": 36, "move_out_on": 27, "move_out_scheduler_id": 37, "moved_out_at": 31, "next_due_on": 32, "originally_rented_on": 17, "paid_through_ends_on": 26, "pending_prorated_in_cents": 19, "plan_price_in_cents": 25, "prorated_amount_in_cents": 16, "rented_on": 14, "reservation_id": 21, "self_insured_policy_expires_on": 50, "settings": 44, "setup_fee_in_cents": 20, "setup_fee_tax_rate": 35, "site_id": 11, "tax_rate_id": 34, "tenant_protection_addendum": 47, "tpp_declined_at": 48, "unit_id": 1, "updated_at": 7, "updater_id": 10 } - schema_attributes:
{ "additional_deposit_in_cents": "int", "additional_deposit_not_refunded_explanation": "string", "additional_deposit_refunded_in_cents": "int", "agreement": "varchar(255)", "agreement_signature": "string", "agreement_signed_at": "timestamp", "agreement_signed_externally": "smallint", "agreement_signed_externally_at": "timestamp", "agreement_signer_id": "int", "amount_rented_for_in_cents": "int", "approved_cancelation_at": "timestamp", "approved_creation_at": "timestamp", "available_at": "timestamp", "billing_cycle": "int", "billing_day_of_month": "int", "canceled_at": "timestamp", "created_at": "timestamp", "creator_id": "int", "customer_id": "int", "deposit_in_cents": "int", "deposit_not_refunded_explanation": "string", "deposit_refunded_in_cents": "int", "discount": "decimal(5,4)", "exempt_from_rate_management": "smallint", "form_updated_at": "timestamp", "form_updater_id": "int", "id": "int", "marketplace_reservation_id": "bigint", "move_in_on": "date", "move_out_finalizer_id": "int", "move_out_on": "date", "move_out_scheduler_id": "int", "moved_out_at": "timestamp", "next_due_on": "date", "originally_rented_on": "date", "paid_through_ends_on": "date", "pending_prorated_in_cents": "int", "plan_price_in_cents": "int", "prorated_amount_in_cents": "int", "rented_on": "date", "reservation_id": "int", "self_insured_policy_expires_on": "date", "settings": "string", "setup_fee_in_cents": "int", "setup_fee_tax_rate": "decimal(5,4)", "site_id": "int", "tax_rate_id": "int", "tenant_protection_addendum": "varchar(255)", "tpp_declined_at": "timestamp", "unit_id": "int", "updated_at": "timestamp", "updater_id": "int" } - schema_name_id: 933
- schema_scan_id: 143108454
- updated: 2025-06-01 09:32:25
Schema Scans: 3
Last at 2025-07-03 23:55:08
-
Scan 145006834
- duration: 0:00:13.830645
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 145006834
- payload:
{ "datatype_dict": { "additional_deposit_in_cents": "int", "additional_deposit_not_refunded_explanation": "string", "additional_deposit_refunded_in_cents": "int", "agreement": "varchar(255)", "agreement_signature": "string", "agreement_signed_at": "timestamp", "agreement_signed_externally": "smallint", "agreement_signed_externally_at": "timestamp", "agreement_signer_id": "int", "amount_rented_for_in_cents": "int", "approved_cancelation_at": "timestamp", "approved_creation_at": "timestamp", "available_at": "timestamp", "billing_cycle": "int", "billing_day_of_month": "int", "canceled_at": "timestamp", "created_at": "timestamp", "creator_id": "int", "customer_id": "int", "deposit_in_cents": "int", "deposit_not_refunded_explanation": "string", "deposit_refunded_in_cents": "int", "discount": "decimal(5,4)", "exempt_from_rate_management": "smallint", "form_updated_at": "timestamp", "form_updater_id": "int", "id": "int", "marketplace_reservation_id": "bigint", "move_in_on": "date", "move_out_finalizer_id": "int", "move_out_on": "date", "move_out_scheduler_id": "int", "moved_out_at": "timestamp", "next_due_on": "date", "originally_rented_on": "date", "paid_through_ends_on": "date", "pending_prorated_in_cents": "int", "plan_price_in_cents": "int", "prorated_amount_in_cents": "int", "rented_on": "date", "reservation_id": "int", "self_insured_policy_expires_on": "date", "settings": "string", "setup_fee_in_cents": "int", "setup_fee_tax_rate": "decimal(5,4)", "site_id": "int", "tax_rate_id": "int", "tenant_protection_addendum": "varchar(255)", "tpp_declined_at": "timestamp", "unit_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-prod", "hive_path": "s3://sfdl-rds-ess-prod/raw/esscore_rentals/2025-07-04/1751604765", "key": "raw/esscore_rentals/2025-07-04/1751604765/split.ess_core.rentals0.dat.gz" }, "schema": { "name": "sfdl_prod_rds.ess_esscore_rentals", "type": "rds" } } - running: False
- schema_name_id: 933
- start_time: 2025-07-03 23:55:08
- success: True
- trace_id: 10705882920290130133
-
Scan 143164547
- duration: 0:00:23.984943
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 143164547
- payload:
{ "datatype_dict": { "additional_deposit_in_cents": "int", "additional_deposit_not_refunded_explanation": "string", "additional_deposit_refunded_in_cents": "int", "agreement": "varchar(255)", "agreement_signature": "string", "agreement_signed_at": "timestamp", "agreement_signed_externally": "smallint", "agreement_signed_externally_at": "timestamp", "agreement_signer_id": "int", "amount_rented_for_in_cents": "int", "approved_cancelation_at": "timestamp", "approved_creation_at": "timestamp", "available_at": "timestamp", "billing_cycle": "int", "billing_day_of_month": "int", "canceled_at": "timestamp", "created_at": "timestamp", "creator_id": "int", "customer_id": "int", "deposit_in_cents": "int", "deposit_not_refunded_explanation": "string", "deposit_refunded_in_cents": "int", "discount": "decimal(5,4)", "exempt_from_rate_management": "smallint", "form_updated_at": "timestamp", "form_updater_id": "int", "id": "int", "marketplace_reservation_id": "bigint", "move_in_on": "date", "move_out_finalizer_id": "int", "move_out_on": "date", "move_out_scheduler_id": "int", "moved_out_at": "timestamp", "next_due_on": "date", "originally_rented_on": "date", "paid_through_ends_on": "date", "pending_prorated_in_cents": "int", "plan_price_in_cents": "int", "prorated_amount_in_cents": "int", "rented_on": "date", "reservation_id": "int", "self_insured_policy_expires_on": "date", "settings": "string", "setup_fee_in_cents": "int", "setup_fee_tax_rate": "decimal(5,4)", "site_id": "int", "tax_rate_id": "int", "tenant_protection_addendum": "varchar(255)", "tpp_declined_at": "timestamp", "unit_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-prod", "hive_path": "s3://sfdl-rds-ess-prod/raw/esscore_rentals/2025-06-02/1748874067", "key": "raw/esscore_rentals/2025-06-02/1748874067/split.ess_core.rentals0.dat.gz" }, "schema": { "name": "sfdl_prod_rds.ess_esscore_rentals", "type": "rds" } } - running: False
- schema_name_id: 933
- start_time: 2025-06-02 09:23:06
- success: True
- trace_id: 5321995625692603751
-
Scan 143108454
- duration: 0:00:13.833927
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 143108454
- payload:
{ "datatype_dict": { "additional_deposit_in_cents": "int", "additional_deposit_not_refunded_explanation": "string", "additional_deposit_refunded_in_cents": "int", "agreement": "varchar(255)", "agreement_signature": "string", "agreement_signed_at": "timestamp", "agreement_signed_externally": "smallint", "agreement_signed_externally_at": "timestamp", "agreement_signer_id": "int", "amount_rented_for_in_cents": "int", "approved_cancelation_at": "timestamp", "approved_creation_at": "timestamp", "available_at": "timestamp", "billing_cycle": "int", "billing_day_of_month": "int", "canceled_at": "timestamp", "created_at": "timestamp", "creator_id": "int", "customer_id": "int", "deposit_in_cents": "int", "deposit_not_refunded_explanation": "string", "deposit_refunded_in_cents": "int", "discount": "decimal(5,4)", "exempt_from_rate_management": "smallint", "form_updated_at": "timestamp", "form_updater_id": "int", "id": "int", "marketplace_reservation_id": "bigint", "move_in_on": "date", "move_out_finalizer_id": "int", "move_out_on": "date", "move_out_scheduler_id": "int", "moved_out_at": "timestamp", "next_due_on": "date", "originally_rented_on": "date", "paid_through_ends_on": "date", "pending_prorated_in_cents": "int", "plan_price_in_cents": "int", "prorated_amount_in_cents": "int", "rented_on": "date", "reservation_id": "int", "self_insured_policy_expires_on": "date", "settings": "string", "setup_fee_in_cents": "int", "setup_fee_tax_rate": "decimal(5,4)", "site_id": "int", "tax_rate_id": "int", "tenant_protection_addendum": "varchar(255)", "tpp_declined_at": "timestamp", "unit_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-prod", "hive_path": "s3://sfdl-rds-ess-prod/raw/esscore_rentals/2025-06-01/1748788207", "key": "raw/esscore_rentals/2025-06-01/1748788207/split.ess_core.rentals0.dat.gz" }, "schema": { "name": "sfdl_prod_rds.ess_esscore_rentals", "type": "rds" } } - running: False
- schema_name_id: 933
- start_time: 2025-06-01 09:32:11
- success: True
- trace_id: 1245988995973110109
- attributes:
{ "additional_deposit_in_cents": "int", "additional_deposit_not_refunded_explanation": "string", "additional_deposit_refunded_in_cents": "int", "agreement": "varchar(255)", "agreement_signature": "string", "agreement_signed_at": "timestamp", "agreement_signed_externally": "smallint", "agreement_signed_externally_at": "timestamp", "agreement_signer_id": "int", "amount_rented_for_in_cents": "int", "approved_cancelation_at": "timestamp", "approved_creation_at": "timestamp", "available_at": "timestamp", "billing_cycle": "int", "billing_day_of_month": "int", "canceled_at": "timestamp", "created_at": "timestamp", "creator_id": "int", "customer_id": "int", "deposit_in_cents": "int", "deposit_not_refunded_explanation": "string", "deposit_refunded_in_cents": "int", "discount": "decimal(5,4)", "exempt_from_rate_management": "smallint", "form_updated_at": "timestamp", "form_updater_id": "int", "id": "int", "marketplace_reservation_id": "bigint", "move_in_on": "date", "move_out_finalizer_id": "int", "move_out_on": "date", "move_out_scheduler_id": "int", "moved_out_at": "timestamp", "next_due_on": "date", "originally_rented_on": "date", "paid_through_ends_on": "date", "pending_prorated_in_cents": "int", "plan_price_in_cents": "int", "prorated_amount_in_cents": "int", "rented_on": "date", "reservation_id": "int", "self_insured_policy_expires_on": "date", "settings": "string", "setup_fee_in_cents": "int", "setup_fee_tax_rate": "decimal(5,4)", "site_id": "int", "tax_rate_id": "int", "tenant_protection_addendum": "varchar(255)", "tpp_declined_at": "timestamp", "unit_id": "int", "updated_at": "timestamp", "updater_id": "int" } - created: 2025-07-03 23:55:08
- 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_rentals`\n(\n `id` int , `unit_id` int , `customer_id` int , `billing_cycle` int , `canceled_at` timestamp , `available_at` timestamp , `created_at` timestamp , `updated_at` timestamp , `amount_rented_for_in_cents` int , `creator_id` int , `updater_id` int , `site_id` int , `approved_creation_at` timestamp , `approved_cancelation_at` timestamp , `rented_on` date , `deposit_in_cents` int , `prorated_amount_in_cents` int , `originally_rented_on` date , `discount` decimal(5,4) , `pending_prorated_in_cents` int , `setup_fee_in_cents` int , `reservation_id` int , `move_in_on` date , `deposit_refunded_in_cents` int , `deposit_not_refunded_explanation` string , `plan_price_in_cents` int , `paid_through_ends_on` date , `move_out_on` date , `additional_deposit_in_cents` int , `additional_deposit_refunded_in_cents` int , `additional_deposit_not_refunded_explanation` string , `moved_out_at` timestamp , `next_due_on` date , `billing_day_of_month` int , `tax_rate_id` int , `setup_fee_tax_rate` decimal(5,4) , `move_out_finalizer_id` int , `move_out_scheduler_id` int , `exempt_from_rate_management` smallint , `agreement` varchar(255) , `agreement_signature` string , `agreement_signed_at` timestamp , `agreement_signer_id` int , `agreement_signed_externally` smallint , `settings` string , `form_updater_id` int , `form_updated_at` timestamp , `tenant_protection_addendum` varchar(255) , `tpp_declined_at` timestamp , `marketplace_reservation_id` bigint , `self_insured_policy_expires_on` date , `agreement_signed_externally_at` timestamp \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_rentals/2025-07-04/1751604765'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.ess_esscore_rentals`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.ess_esscore_rentals" }
- 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:33:14",
"disabled": false,
"format": "raw",
"id": 933,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_rds",
"table": "ess_esscore_rentals"
},
"type": "rds"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"additional_deposit_in_cents": "int",
"additional_deposit_not_refunded_explanation": "string",
"additional_deposit_refunded_in_cents": "int",
"agreement": "varchar(255)",
"agreement_signature": "string",
"agreement_signed_at": "timestamp",
"agreement_signed_externally": "smallint",
"agreement_signed_externally_at": "timestamp",
"agreement_signer_id": "int",
"amount_rented_for_in_cents": "int",
"approved_cancelation_at": "timestamp",
"approved_creation_at": "timestamp",
"available_at": "timestamp",
"billing_cycle": "int",
"billing_day_of_month": "int",
"canceled_at": "timestamp",
"created_at": "timestamp",
"creator_id": "int",
"customer_id": "int",
"deposit_in_cents": "int",
"deposit_not_refunded_explanation": "string",
"deposit_refunded_in_cents": "int",
"discount": "decimal(5,4)",
"exempt_from_rate_management": "smallint",
"form_updated_at": "timestamp",
"form_updater_id": "int",
"id": "int",
"marketplace_reservation_id": "bigint",
"move_in_on": "date",
"move_out_finalizer_id": "int",
"move_out_on": "date",
"move_out_scheduler_id": "int",
"moved_out_at": "timestamp",
"next_due_on": "date",
"originally_rented_on": "date",
"paid_through_ends_on": "date",
"pending_prorated_in_cents": "int",
"plan_price_in_cents": "int",
"prorated_amount_in_cents": "int",
"rented_on": "date",
"reservation_id": "int",
"self_insured_policy_expires_on": "date",
"settings": "string",
"setup_fee_in_cents": "int",
"setup_fee_tax_rate": "decimal(5,4)",
"site_id": "int",
"tax_rate_id": "int",
"tenant_protection_addendum": "varchar(255)",
"tpp_declined_at": "timestamp",
"unit_id": "int",
"updated_at": "timestamp",
"updater_id": "int"
},
"created": "2025-07-03 23:55:08",
"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_rentals`\n(\n `id` int , `unit_id` int , `customer_id` int , `billing_cycle` int , `canceled_at` timestamp , `available_at` timestamp , `created_at` timestamp , `updated_at` timestamp , `amount_rented_for_in_cents` int , `creator_id` int , `updater_id` int , `site_id` int , `approved_creation_at` timestamp , `approved_cancelation_at` timestamp , `rented_on` date , `deposit_in_cents` int , `prorated_amount_in_cents` int , `originally_rented_on` date , `discount` decimal(5,4) , `pending_prorated_in_cents` int , `setup_fee_in_cents` int , `reservation_id` int , `move_in_on` date , `deposit_refunded_in_cents` int , `deposit_not_refunded_explanation` string , `plan_price_in_cents` int , `paid_through_ends_on` date , `move_out_on` date , `additional_deposit_in_cents` int , `additional_deposit_refunded_in_cents` int , `additional_deposit_not_refunded_explanation` string , `moved_out_at` timestamp , `next_due_on` date , `billing_day_of_month` int , `tax_rate_id` int , `setup_fee_tax_rate` decimal(5,4) , `move_out_finalizer_id` int , `move_out_scheduler_id` int , `exempt_from_rate_management` smallint , `agreement` varchar(255) , `agreement_signature` string , `agreement_signed_at` timestamp , `agreement_signer_id` int , `agreement_signed_externally` smallint , `settings` string , `form_updater_id` int , `form_updated_at` timestamp , `tenant_protection_addendum` varchar(255) , `tpp_declined_at` timestamp , `marketplace_reservation_id` bigint , `self_insured_policy_expires_on` date , `agreement_signed_externally_at` timestamp \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_rentals/2025-07-04/1751604765'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.ess_esscore_rentals`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.ess_esscore_rentals"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}