Schema Info
Schema Name: sfdl_prod_rds.ess_esscore_operations_line_items
- created: 2021-07-26 18:03:38
- disabled: False
- format: raw
- id: 895
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_rds", "table": "ess_esscore_operations_line_items" } - type: rds
Schema Versions: 3
-
Version 1397410
- created: 2025-07-24 01:29:17
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.ess_esscore_operations_line_items`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.ess_esscore_operations_line_items`\n(\n `id` bigint , `site_id` int , `addon_id` bigint , `creator_id` bigint , `amount` decimal(7,2) , `amount_paid` decimal(7,2) , `kind` int , `name` varchar(255) , `description` string , `due_at` timestamp , `invoiced_at` timestamp , `charge_at` timestamp , `deleted_at` timestamp , `created_at` timestamp , `updated_at` timestamp , `department_id` bigint , `tax` decimal(7,2) , `tax_paid` decimal(7,2) , `tax_category` int , `marked_uncollectable_at` timestamp , `billing_cycle_starts_on` date , `billing_cycle_ends_on` date , `notes` string , `paid_at` timestamp , `parent_line_item_id` bigint , `notify_at` timestamp , `notified_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_operations_line_items/2025-07-24/1753338555'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_rds.ess_esscore_operations_line_items" ] - hive_path: s3://sfdl-rds-ess-prod/raw/esscore_operations_line_items/2025-07-24/1753338555
- id: 1397410
- processed: 1
- raw_data:
{ "addon_id": 2, "amount": 4, "amount_paid": 5, "billing_cycle_ends_on": 21, "billing_cycle_starts_on": 20, "charge_at": 11, "created_at": 13, "creator_id": 3, "deleted_at": 12, "department_id": 15, "description": 8, "due_at": 9, "id": 0, "invoiced_at": 10, "kind": 6, "marked_uncollectable_at": 19, "name": 7, "notes": 22, "notified_at": 26, "notify_at": 25, "paid_at": 23, "parent_line_item_id": 24, "site_id": 1, "tax": 16, "tax_category": 18, "tax_paid": 17, "updated_at": 14 } - schema_attributes:
{ "addon_id": "bigint", "amount": "decimal(7,2)", "amount_paid": "decimal(7,2)", "billing_cycle_ends_on": "date", "billing_cycle_starts_on": "date", "charge_at": "timestamp", "created_at": "timestamp", "creator_id": "bigint", "deleted_at": "timestamp", "department_id": "bigint", "description": "string", "due_at": "timestamp", "id": "bigint", "invoiced_at": "timestamp", "kind": "int", "marked_uncollectable_at": "timestamp", "name": "varchar(255)", "notes": "string", "notified_at": "timestamp", "notify_at": "timestamp", "paid_at": "timestamp", "parent_line_item_id": "bigint", "site_id": "int", "tax": "decimal(7,2)", "tax_category": "int", "tax_paid": "decimal(7,2)", "updated_at": "timestamp" } - schema_name_id: 895
- schema_scan_id: 146212058
- updated: 2025-07-24 01:29:30
-
Version 1372692
- created: 2025-07-03 23:39:45
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.ess_esscore_operations_line_items`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.ess_esscore_operations_line_items`\n(\n `id` bigint , `site_id` int , `addon_id` bigint , `creator_id` bigint , `amount` decimal(7,2) , `amount_paid` decimal(7,2) , `kind` int , `name` varchar(255) , `description` string , `due_at` timestamp , `invoiced_at` timestamp , `charge_at` timestamp , `deleted_at` timestamp , `created_at` timestamp , `updated_at` timestamp , `department_id` bigint , `tax` decimal(7,2) , `tax_paid` decimal(7,2) , `tax_category` int , `marked_uncollectable_at` timestamp , `billing_cycle_starts_on` date , `billing_cycle_ends_on` date , `notes` string , `paid_at` timestamp , `parent_line_item_id` bigint , `notify_at` timestamp , `notified_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_operations_line_items/2025-07-04/1751603983'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_rds.ess_esscore_operations_line_items" ] - hive_path: s3://sfdl-rds-ess-prod/raw/esscore_operations_line_items/2025-07-04/1751603983
- id: 1372692
- processed: 1
- raw_data:
{ "addon_id": 2, "amount": 4, "amount_paid": 5, "billing_cycle_ends_on": 21, "billing_cycle_starts_on": 20, "charge_at": 11, "created_at": 13, "creator_id": 3, "deleted_at": 12, "department_id": 15, "description": 8, "due_at": 9, "id": 0, "invoiced_at": 10, "kind": 6, "marked_uncollectable_at": 19, "name": 7, "notes": 22, "notified_at": 26, "notify_at": 25, "paid_at": 23, "parent_line_item_id": 24, "site_id": 1, "tax": 16, "tax_category": 18, "tax_paid": 17, "updated_at": 14 } - schema_attributes:
{ "addon_id": "bigint", "amount": "decimal(7,2)", "amount_paid": "decimal(7,2)", "billing_cycle_ends_on": "date", "billing_cycle_starts_on": "date", "charge_at": "timestamp", "created_at": "timestamp", "creator_id": "bigint", "deleted_at": "timestamp", "department_id": "bigint", "description": "string", "due_at": "timestamp", "id": "bigint", "invoiced_at": "timestamp", "kind": "int", "marked_uncollectable_at": "timestamp", "name": "varchar(255)", "notes": "string", "notified_at": "timestamp", "notify_at": "timestamp", "paid_at": "timestamp", "parent_line_item_id": "bigint", "site_id": "int", "tax": "decimal(7,2)", "tax_category": "int", "tax_paid": "decimal(7,2)", "updated_at": "timestamp" } - schema_name_id: 895
- schema_scan_id: 145006278
- updated: 2025-07-03 23:40:01
-
Version 1332729
- created: 2025-06-02 09:50:55
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.ess_esscore_operations_line_items`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.ess_esscore_operations_line_items`\n(\n `id` bigint , `site_id` int , `addon_id` bigint , `creator_id` bigint , `amount` decimal(7,2) , `amount_paid` decimal(7,2) , `kind` int , `name` varchar(255) , `description` string , `due_at` timestamp , `invoiced_at` timestamp , `charge_at` timestamp , `deleted_at` timestamp , `created_at` timestamp , `updated_at` timestamp , `department_id` bigint , `tax` decimal(7,2) , `tax_paid` decimal(7,2) , `tax_category` int , `marked_uncollectable_at` timestamp , `billing_cycle_starts_on` date , `billing_cycle_ends_on` date , `notes` string , `paid_at` timestamp , `parent_line_item_id` bigint , `notify_at` timestamp , `notified_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_operations_line_items/2025-06-02/1748875853'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_rds.ess_esscore_operations_line_items" ] - hive_path: s3://sfdl-rds-ess-prod/raw/esscore_operations_line_items/2025-06-02/1748875853
- id: 1332729
- processed: 1
- raw_data:
{ "addon_id": 2, "amount": 4, "amount_paid": 5, "billing_cycle_ends_on": 21, "billing_cycle_starts_on": 20, "charge_at": 11, "created_at": 13, "creator_id": 3, "deleted_at": 12, "department_id": 15, "description": 8, "due_at": 9, "id": 0, "invoiced_at": 10, "kind": 6, "marked_uncollectable_at": 19, "name": 7, "notes": 22, "notified_at": 26, "notify_at": 25, "paid_at": 23, "parent_line_item_id": 24, "site_id": 1, "tax": 16, "tax_category": 18, "tax_paid": 17, "updated_at": 14 } - schema_attributes:
{ "addon_id": "bigint", "amount": "decimal(7,2)", "amount_paid": "decimal(7,2)", "billing_cycle_ends_on": "date", "billing_cycle_starts_on": "date", "charge_at": "timestamp", "created_at": "timestamp", "creator_id": "bigint", "deleted_at": "timestamp", "department_id": "bigint", "description": "string", "due_at": "timestamp", "id": "bigint", "invoiced_at": "timestamp", "kind": "int", "marked_uncollectable_at": "timestamp", "name": "varchar(255)", "notes": "string", "notified_at": "timestamp", "notify_at": "timestamp", "paid_at": "timestamp", "parent_line_item_id": "bigint", "site_id": "int", "tax": "decimal(7,2)", "tax_category": "int", "tax_paid": "decimal(7,2)", "updated_at": "timestamp" } - schema_name_id: 895
- schema_scan_id: 143165934
- updated: 2025-06-02 09:51:08
Schema Scans: 3
Last at 2025-07-24 01:29:17
-
Scan 146212058
- duration: 0:00:13.583139
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 146212058
- payload:
{ "datatype_dict": { "addon_id": "bigint", "amount": "decimal(7,2)", "amount_paid": "decimal(7,2)", "billing_cycle_ends_on": "date", "billing_cycle_starts_on": "date", "charge_at": "timestamp", "created_at": "timestamp", "creator_id": "bigint", "deleted_at": "timestamp", "department_id": "bigint", "description": "string", "due_at": "timestamp", "id": "bigint", "invoiced_at": "timestamp", "kind": "int", "marked_uncollectable_at": "timestamp", "name": "varchar(255)", "notes": "string", "notified_at": "timestamp", "notify_at": "timestamp", "paid_at": "timestamp", "parent_line_item_id": "bigint", "site_id": "int", "tax": "decimal(7,2)", "tax_category": "int", "tax_paid": "decimal(7,2)", "updated_at": "timestamp" }, "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_operations_line_items/2025-07-24/1753338555", "key": "raw/esscore_operations_line_items/2025-07-24/1753338555/split.ess_core.operations_line_items0.dat.gz" }, "schema": { "name": "sfdl_prod_rds.ess_esscore_operations_line_items", "type": "rds" } } - running: False
- schema_name_id: 895
- start_time: 2025-07-24 01:29:17
- success: True
- trace_id: 3235554173085739947
-
Scan 145006278
- duration: 0:00:16.201214
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 145006278
- payload:
{ "datatype_dict": { "addon_id": "bigint", "amount": "decimal(7,2)", "amount_paid": "decimal(7,2)", "billing_cycle_ends_on": "date", "billing_cycle_starts_on": "date", "charge_at": "timestamp", "created_at": "timestamp", "creator_id": "bigint", "deleted_at": "timestamp", "department_id": "bigint", "description": "string", "due_at": "timestamp", "id": "bigint", "invoiced_at": "timestamp", "kind": "int", "marked_uncollectable_at": "timestamp", "name": "varchar(255)", "notes": "string", "notified_at": "timestamp", "notify_at": "timestamp", "paid_at": "timestamp", "parent_line_item_id": "bigint", "site_id": "int", "tax": "decimal(7,2)", "tax_category": "int", "tax_paid": "decimal(7,2)", "updated_at": "timestamp" }, "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_operations_line_items/2025-07-04/1751603983", "key": "raw/esscore_operations_line_items/2025-07-04/1751603983/split.ess_core.operations_line_items0.dat.gz" }, "schema": { "name": "sfdl_prod_rds.ess_esscore_operations_line_items", "type": "rds" } } - running: False
- schema_name_id: 895
- start_time: 2025-07-03 23:39:44
- success: True
- trace_id: 2540170298810176866
-
Scan 143165934
- duration: 0:00:13.711712
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 143165934
- payload:
{ "datatype_dict": { "addon_id": "bigint", "amount": "decimal(7,2)", "amount_paid": "decimal(7,2)", "billing_cycle_ends_on": "date", "billing_cycle_starts_on": "date", "charge_at": "timestamp", "created_at": "timestamp", "creator_id": "bigint", "deleted_at": "timestamp", "department_id": "bigint", "description": "string", "due_at": "timestamp", "id": "bigint", "invoiced_at": "timestamp", "kind": "int", "marked_uncollectable_at": "timestamp", "name": "varchar(255)", "notes": "string", "notified_at": "timestamp", "notify_at": "timestamp", "paid_at": "timestamp", "parent_line_item_id": "bigint", "site_id": "int", "tax": "decimal(7,2)", "tax_category": "int", "tax_paid": "decimal(7,2)", "updated_at": "timestamp" }, "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_operations_line_items/2025-06-02/1748875853", "key": "raw/esscore_operations_line_items/2025-06-02/1748875853/split.ess_core.operations_line_items0.dat.gz" }, "schema": { "name": "sfdl_prod_rds.ess_esscore_operations_line_items", "type": "rds" } } - running: False
- schema_name_id: 895
- start_time: 2025-06-02 09:50:55
- success: True
- trace_id: 1252846238824250300
- attributes:
{ "addon_id": "bigint", "amount": "decimal(7,2)", "amount_paid": "decimal(7,2)", "billing_cycle_ends_on": "date", "billing_cycle_starts_on": "date", "charge_at": "timestamp", "created_at": "timestamp", "creator_id": "bigint", "deleted_at": "timestamp", "department_id": "bigint", "description": "string", "due_at": "timestamp", "id": "bigint", "invoiced_at": "timestamp", "kind": "int", "marked_uncollectable_at": "timestamp", "name": "varchar(255)", "notes": "string", "notified_at": "timestamp", "notify_at": "timestamp", "paid_at": "timestamp", "parent_line_item_id": "bigint", "site_id": "int", "tax": "decimal(7,2)", "tax_category": "int", "tax_paid": "decimal(7,2)", "updated_at": "timestamp" } - created: 2025-07-24 01:29:17
- 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_operations_line_items`\n(\n `id` bigint , `site_id` int , `addon_id` bigint , `creator_id` bigint , `amount` decimal(7,2) , `amount_paid` decimal(7,2) , `kind` int , `name` varchar(255) , `description` string , `due_at` timestamp , `invoiced_at` timestamp , `charge_at` timestamp , `deleted_at` timestamp , `created_at` timestamp , `updated_at` timestamp , `department_id` bigint , `tax` decimal(7,2) , `tax_paid` decimal(7,2) , `tax_category` int , `marked_uncollectable_at` timestamp , `billing_cycle_starts_on` date , `billing_cycle_ends_on` date , `notes` string , `paid_at` timestamp , `parent_line_item_id` bigint , `notify_at` timestamp , `notified_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_operations_line_items/2025-07-24/1753338555'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.ess_esscore_operations_line_items`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.ess_esscore_operations_line_items" }
- 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:03:38",
"disabled": false,
"format": "raw",
"id": 895,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_rds",
"table": "ess_esscore_operations_line_items"
},
"type": "rds"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"addon_id": "bigint",
"amount": "decimal(7,2)",
"amount_paid": "decimal(7,2)",
"billing_cycle_ends_on": "date",
"billing_cycle_starts_on": "date",
"charge_at": "timestamp",
"created_at": "timestamp",
"creator_id": "bigint",
"deleted_at": "timestamp",
"department_id": "bigint",
"description": "string",
"due_at": "timestamp",
"id": "bigint",
"invoiced_at": "timestamp",
"kind": "int",
"marked_uncollectable_at": "timestamp",
"name": "varchar(255)",
"notes": "string",
"notified_at": "timestamp",
"notify_at": "timestamp",
"paid_at": "timestamp",
"parent_line_item_id": "bigint",
"site_id": "int",
"tax": "decimal(7,2)",
"tax_category": "int",
"tax_paid": "decimal(7,2)",
"updated_at": "timestamp"
},
"created": "2025-07-24 01:29:17",
"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_operations_line_items`\n(\n `id` bigint , `site_id` int , `addon_id` bigint , `creator_id` bigint , `amount` decimal(7,2) , `amount_paid` decimal(7,2) , `kind` int , `name` varchar(255) , `description` string , `due_at` timestamp , `invoiced_at` timestamp , `charge_at` timestamp , `deleted_at` timestamp , `created_at` timestamp , `updated_at` timestamp , `department_id` bigint , `tax` decimal(7,2) , `tax_paid` decimal(7,2) , `tax_category` int , `marked_uncollectable_at` timestamp , `billing_cycle_starts_on` date , `billing_cycle_ends_on` date , `notes` string , `paid_at` timestamp , `parent_line_item_id` bigint , `notify_at` timestamp , `notified_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_operations_line_items/2025-07-24/1753338555'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.ess_esscore_operations_line_items`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.ess_esscore_operations_line_items"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}