Schema Info
Schema Name: sfdl_stage_rds.ess_esscore_line_items
- created: 2021-07-12 13:41:45
- disabled: False
- format: raw
- id: 1082
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_stage_rds", "table": "ess_esscore_line_items" } - type: rds
Schema Versions: 4
-
Version 550946
- created: 2023-06-15 19:02:08
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.ess_esscore_line_items`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.ess_esscore_line_items`\n(\n `id` int , `billable_id` int , `billable_type` varchar(255) , `amount_in_cents` int , `description` varchar(255) , `action` varchar(255) , `created_at` timestamp , `updated_at` timestamp , `charge_on` date , `site_id` int , `amount_paid_in_cents` int , `archived` smallint , `tax_in_cents` int , `change_log` string , `tax_rate` decimal(6,5) , `tax_paid_in_cents` int , `quickbooks_id` varchar(255) , `paid_through_ends_on` date , `action_name` varchar(255) , `overriding_line_item_id` int , `auto_charge` smallint , `running_balance_in_cents` int , `due_on` date , `prepayment_ends_on` date , `customer_id` int , `quantity` int , `unit_price_in_cents` int , `promotion_amount` decimal(7,2) , `applied_promotion_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-stage/raw/esscore_line_items/2023-06-16/1686873708'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_rds.ess_esscore_line_items" ] - hive_path: s3://sfdl-rds-ess-stage/raw/esscore_line_items/2023-06-16/1686873708
- id: 550946
- processed: 1
- raw_data:
{ "action": 5, "action_name": 18, "amount_in_cents": 3, "amount_paid_in_cents": 10, "applied_promotion_id": 28, "archived": 11, "auto_charge": 20, "billable_id": 1, "billable_type": 2, "change_log": 13, "charge_on": 8, "created_at": 6, "customer_id": 24, "description": 4, "due_on": 22, "id": 0, "notified_at": 30, "notify_at": 29, "overriding_line_item_id": 19, "paid_through_ends_on": 17, "prepayment_ends_on": 23, "promotion_amount": 27, "quantity": 25, "quickbooks_id": 16, "running_balance_in_cents": 21, "site_id": 9, "tax_in_cents": 12, "tax_paid_in_cents": 15, "tax_rate": 14, "unit_price_in_cents": 26, "updated_at": 7 } - schema_attributes:
{ "action": "varchar(255)", "action_name": "varchar(255)", "amount_in_cents": "int", "amount_paid_in_cents": "int", "applied_promotion_id": "bigint", "archived": "smallint", "auto_charge": "smallint", "billable_id": "int", "billable_type": "varchar(255)", "change_log": "string", "charge_on": "date", "created_at": "timestamp", "customer_id": "int", "description": "varchar(255)", "due_on": "date", "id": "int", "notified_at": "timestamp", "notify_at": "timestamp", "overriding_line_item_id": "int", "paid_through_ends_on": "date", "prepayment_ends_on": "date", "promotion_amount": "decimal(7,2)", "quantity": "int", "quickbooks_id": "varchar(255)", "running_balance_in_cents": "int", "site_id": "int", "tax_in_cents": "int", "tax_paid_in_cents": "int", "tax_rate": "decimal(6,5)", "unit_price_in_cents": "int", "updated_at": "timestamp" } - schema_name_id: 1082
- schema_scan_id: 4963480
- updated: 2023-06-15 19:02:19
-
Version 402925
- created: 2022-06-22 21:07:24
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.ess_esscore_line_items`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.ess_esscore_line_items`\n(\n `id` int , `billable_id` int , `billable_type` varchar(255) , `amount_in_cents` int , `description` varchar(255) , `action` varchar(255) , `created_at` timestamp , `updated_at` timestamp , `charge_on` date , `site_id` int , `amount_paid_in_cents` int , `archived` smallint , `tax_in_cents` int , `change_log` string , `tax_rate` decimal(6,5) , `tax_paid_in_cents` int , `quickbooks_id` varchar(255) , `paid_through_ends_on` date , `action_name` varchar(255) , `overriding_line_item_id` int , `auto_charge` smallint , `running_balance_in_cents` int , `due_on` date , `prepayment_ends_on` date , `customer_id` int , `quantity` int , `unit_price_in_cents` int , `promotion_amount` decimal(7,2) , `applied_promotion_id` bigint \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_line_items/2022-06-23/1655950026'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_rds.ess_esscore_line_items" ] - hive_path: s3://sfdl-rds-ess-stage/raw/esscore_line_items/2022-06-23/1655950026
- id: 402925
- processed: 1
- raw_data:
{ "action": 5, "action_name": 18, "amount_in_cents": 3, "amount_paid_in_cents": 10, "applied_promotion_id": 28, "archived": 11, "auto_charge": 20, "billable_id": 1, "billable_type": 2, "change_log": 13, "charge_on": 8, "created_at": 6, "customer_id": 24, "description": 4, "due_on": 22, "id": 0, "overriding_line_item_id": 19, "paid_through_ends_on": 17, "prepayment_ends_on": 23, "promotion_amount": 27, "quantity": 25, "quickbooks_id": 16, "running_balance_in_cents": 21, "site_id": 9, "tax_in_cents": 12, "tax_paid_in_cents": 15, "tax_rate": 14, "unit_price_in_cents": 26, "updated_at": 7 } - schema_attributes:
{ "action": "varchar(255)", "action_name": "varchar(255)", "amount_in_cents": "int", "amount_paid_in_cents": "int", "applied_promotion_id": "bigint", "archived": "smallint", "auto_charge": "smallint", "billable_id": "int", "billable_type": "varchar(255)", "change_log": "string", "charge_on": "date", "created_at": "timestamp", "customer_id": "int", "description": "varchar(255)", "due_on": "date", "id": "int", "overriding_line_item_id": "int", "paid_through_ends_on": "date", "prepayment_ends_on": "date", "promotion_amount": "decimal(7,2)", "quantity": "int", "quickbooks_id": "varchar(255)", "running_balance_in_cents": "int", "site_id": "int", "tax_in_cents": "int", "tax_paid_in_cents": "int", "tax_rate": "decimal(6,5)", "unit_price_in_cents": "int", "updated_at": "timestamp" } - schema_name_id: 1082
- schema_scan_id: 3933532
- updated: 2022-06-22 21:07:36
-
Version 402819
- created: 2022-06-22 15:56:31
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.ess_esscore_line_items`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.ess_esscore_line_items`\n(\n `id` int , `billable_id` int , `billable_type` varchar(255) , `amount_in_cents` int , `description` varchar(255) , `action` varchar(255) , `created_at` timestamp , `updated_at` timestamp , `charge_on` date , `site_id` int , `amount_paid_in_cents` int , `archived` smallint , `tax_in_cents` int , `change_log` string , `tax_rate` decimal(6,5) , `tax_paid_in_cents` int , `quickbooks_id` varchar(255) , `paid_through_ends_on` date , `action_name` varchar(255) , `overriding_line_item_id` int , `auto_charge` smallint , `running_balance_in_cents` int , `due_on` date , `prepayment_ends_on` date , `customer_id` int , `quantity` int , `unit_price_in_cents` int , `promotion_amount` decimal(7,2) , `applied_promotion_id` bigint \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_line_items/2022-06-22/1655931375'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_rds.ess_esscore_line_items" ] - hive_path: s3://sfdl-rds-ess-stage/raw/esscore_line_items/2022-06-22/1655931375
- id: 402819
- processed: 1
- raw_data:
{ "action": 5, "action_name": 18, "amount_in_cents": 3, "amount_paid_in_cents": 10, "applied_promotion_id": 28, "archived": 11, "auto_charge": 20, "billable_id": 1, "billable_type": 2, "change_log": 13, "charge_on": 8, "created_at": 6, "customer_id": 24, "description": 4, "due_on": 22, "id": 0, "overriding_line_item_id": 19, "paid_through_ends_on": 17, "prepayment_ends_on": 23, "promotion_amount": 27, "quantity": 25, "quickbooks_id": 16, "running_balance_in_cents": 21, "site_id": 9, "tax_in_cents": 12, "tax_paid_in_cents": 15, "tax_rate": 14, "unit_price_in_cents": 26, "updated_at": 7 } - schema_attributes:
{ "action": "varchar(255)", "action_name": "varchar(255)", "amount_in_cents": "int", "amount_paid_in_cents": "int", "applied_promotion_id": "bigint", "archived": "smallint", "auto_charge": "smallint", "billable_id": "int", "billable_type": "varchar(255)", "change_log": "string", "charge_on": "date", "created_at": "timestamp", "customer_id": "int", "description": "varchar(255)", "due_on": "date", "id": "int", "overriding_line_item_id": "int", "paid_through_ends_on": "date", "prepayment_ends_on": "date", "promotion_amount": "decimal(7,2)", "quantity": "int", "quickbooks_id": "varchar(255)", "running_balance_in_cents": "int", "site_id": "int", "tax_in_cents": "int", "tax_paid_in_cents": "int", "tax_rate": "decimal(6,5)", "unit_price_in_cents": "int", "updated_at": "timestamp" } - schema_name_id: 1082
- schema_scan_id: 3932906
- updated: 2022-06-22 15:56:42
-
Version 341530
- created: 2021-07-23 23:47:48
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.ess_esscore_line_items`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.ess_esscore_line_items`\n(\n `id` int , `billable_id` int , `billable_type` varchar(255) , `amount_in_cents` int , `description` varchar(255) , `action` varchar(255) , `created_at` timestamp , `updated_at` timestamp , `charge_on` date , `site_id` int , `amount_paid_in_cents` int , `archived` smallint , `tax_in_cents` int , `change_log` string , `tax_rate` decimal(6,5) , `tax_paid_in_cents` int , `quickbooks_id` varchar(255) , `paid_through_ends_on` date , `action_name` varchar(255) , `overriding_line_item_id` int , `auto_charge` smallint , `running_balance_in_cents` int , `due_on` date , `prepayment_ends_on` date , `customer_id` int , `quantity` int , `unit_price_in_cents` int , `promotion_amount` decimal(7,2) , `applied_promotion_id` bigint \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_line_items/2021-07-24/1627102048'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_rds.ess_esscore_line_items" ] - hive_path: s3://sfdl-rds-ess-stage/raw/esscore_line_items/2021-07-24/1627102048
- id: 341530
- processed: 1
- raw_data:
{ "action": 5, "action_name": 18, "amount_in_cents": 3, "amount_paid_in_cents": 10, "applied_promotion_id": 28, "archived": 11, "auto_charge": 20, "billable_id": 1, "billable_type": 2, "change_log": 13, "charge_on": 8, "created_at": 6, "customer_id": 24, "description": 4, "due_on": 22, "id": 0, "overriding_line_item_id": 19, "paid_through_ends_on": 17, "prepayment_ends_on": 23, "promotion_amount": 27, "quantity": 25, "quickbooks_id": 16, "running_balance_in_cents": 21, "site_id": 9, "tax_in_cents": 12, "tax_paid_in_cents": 15, "tax_rate": 14, "unit_price_in_cents": 26, "updated_at": 7 } - schema_attributes:
{ "action": "varchar(255)", "action_name": "varchar(255)", "amount_in_cents": "int", "amount_paid_in_cents": "int", "applied_promotion_id": "bigint", "archived": "smallint", "auto_charge": "smallint", "billable_id": "int", "billable_type": "varchar(255)", "change_log": "string", "charge_on": "date", "created_at": "timestamp", "customer_id": "int", "description": "varchar(255)", "due_on": "date", "id": "int", "overriding_line_item_id": "int", "paid_through_ends_on": "date", "prepayment_ends_on": "date", "promotion_amount": "decimal(7,2)", "quantity": "int", "quickbooks_id": "varchar(255)", "running_balance_in_cents": "int", "site_id": "int", "tax_in_cents": "int", "tax_paid_in_cents": "int", "tax_rate": "decimal(6,5)", "unit_price_in_cents": "int", "updated_at": "timestamp" } - schema_name_id: 1082
- schema_scan_id: 3410599
- updated: 2021-07-23 23:47:59
Schema Scans: 4
Last at 2023-06-15 19:02:08
-
Scan 4963480
- duration: 0:00:11.269324
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 4963480
- payload:
{ "datatype_dict": { "action": "varchar(255)", "action_name": "varchar(255)", "amount_in_cents": "int", "amount_paid_in_cents": "int", "applied_promotion_id": "bigint", "archived": "smallint", "auto_charge": "smallint", "billable_id": "int", "billable_type": "varchar(255)", "change_log": "string", "charge_on": "date", "created_at": "timestamp", "customer_id": "int", "description": "varchar(255)", "due_on": "date", "id": "int", "notified_at": "timestamp", "notify_at": "timestamp", "overriding_line_item_id": "int", "paid_through_ends_on": "date", "prepayment_ends_on": "date", "promotion_amount": "decimal(7,2)", "quantity": "int", "quickbooks_id": "varchar(255)", "running_balance_in_cents": "int", "site_id": "int", "tax_in_cents": "int", "tax_paid_in_cents": "int", "tax_rate": "decimal(6,5)", "unit_price_in_cents": "int", "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-stage", "hive_path": "s3://sfdl-rds-ess-stage/raw/esscore_line_items/2023-06-16/1686873708", "key": "raw/esscore_line_items/2023-06-16/1686873708/split.ess_core.line_items0.dat.gz" }, "schema": { "name": "sfdl_stage_rds.ess_esscore_line_items", "type": "rds" } } - running: False
- schema_name_id: 1082
- start_time: 2023-06-15 19:02:08
- success: True
- trace_id: 16824631049524707141
-
Scan 3933532
- duration: 0:00:14.303571
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 0, "partitions_applied": false, "success": true } - id: 3933532
- payload:
{ "datatype_dict": { "action": "varchar(255)", "action_name": "varchar(255)", "amount_in_cents": "int", "amount_paid_in_cents": "int", "applied_promotion_id": "bigint", "archived": "smallint", "auto_charge": "smallint", "billable_id": "int", "billable_type": "varchar(255)", "change_log": "string", "charge_on": "date", "created_at": "timestamp", "customer_id": "int", "description": "varchar(255)", "due_on": "date", "id": "int", "overriding_line_item_id": "int", "paid_through_ends_on": "date", "prepayment_ends_on": "date", "promotion_amount": "decimal(7,2)", "quantity": "int", "quickbooks_id": "varchar(255)", "running_balance_in_cents": "int", "site_id": "int", "tax_in_cents": "int", "tax_paid_in_cents": "int", "tax_rate": "decimal(6,5)", "unit_price_in_cents": "int", "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-stage", "hive_path": "s3://sfdl-rds-ess-stage/raw/esscore_line_items/2022-06-23/1655950026", "key": "raw/esscore_line_items/2022-06-23/1655950026/split.ess_core.line_items0.dat.gz" }, "schema": { "name": "sfdl_stage_rds.ess_esscore_line_items", "type": "rds" } } - running: False
- schema_name_id: 1082
- start_time: 2022-06-22 21:07:24
- success: True
- trace_id: 3815810628573277414
-
Scan 3932906
- duration: 0:00:14.267859
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 0, "partitions_applied": false, "success": true } - id: 3932906
- payload:
{ "datatype_dict": { "action": "varchar(255)", "action_name": "varchar(255)", "amount_in_cents": "int", "amount_paid_in_cents": "int", "applied_promotion_id": "bigint", "archived": "smallint", "auto_charge": "smallint", "billable_id": "int", "billable_type": "varchar(255)", "change_log": "string", "charge_on": "date", "created_at": "timestamp", "customer_id": "int", "description": "varchar(255)", "due_on": "date", "id": "int", "overriding_line_item_id": "int", "paid_through_ends_on": "date", "prepayment_ends_on": "date", "promotion_amount": "decimal(7,2)", "quantity": "int", "quickbooks_id": "varchar(255)", "running_balance_in_cents": "int", "site_id": "int", "tax_in_cents": "int", "tax_paid_in_cents": "int", "tax_rate": "decimal(6,5)", "unit_price_in_cents": "int", "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-stage", "hive_path": "s3://sfdl-rds-ess-stage/raw/esscore_line_items/2022-06-22/1655931375", "key": "raw/esscore_line_items/2022-06-22/1655931375/split.ess_core.line_items0.dat.gz" }, "schema": { "name": "sfdl_stage_rds.ess_esscore_line_items", "type": "rds" } } - running: False
- schema_name_id: 1082
- start_time: 2022-06-22 15:56:31
- success: True
- trace_id: 9312951574010342406
-
Scan 3410599
- duration: 0:00:15.229343
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 0, "partitions_applied": false, "success": true } - id: 3410599
- payload:
{ "datatype_dict": { "action": "varchar(255)", "action_name": "varchar(255)", "amount_in_cents": "int", "amount_paid_in_cents": "int", "applied_promotion_id": "bigint", "archived": "smallint", "auto_charge": "smallint", "billable_id": "int", "billable_type": "varchar(255)", "change_log": "string", "charge_on": "date", "created_at": "timestamp", "customer_id": "int", "description": "varchar(255)", "due_on": "date", "id": "int", "overriding_line_item_id": "int", "paid_through_ends_on": "date", "prepayment_ends_on": "date", "promotion_amount": "decimal(7,2)", "quantity": "int", "quickbooks_id": "varchar(255)", "running_balance_in_cents": "int", "site_id": "int", "tax_in_cents": "int", "tax_paid_in_cents": "int", "tax_rate": "decimal(6,5)", "unit_price_in_cents": "int", "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-stage", "hive_path": "s3://sfdl-rds-ess-stage/raw/esscore_line_items/2021-07-24/1627102048", "key": "raw/esscore_line_items/2021-07-24/1627102048/split.ess_core.line_items0.dat.gz" }, "schema": { "name": "sfdl_stage_rds.ess_esscore_line_items", "type": "rds" } } - running: False
- schema_name_id: 1082
- start_time: 2021-07-23 23:47:46
- success: True
- trace_id: 5055447145570697966
- attributes:
{ "action": "varchar(255)", "action_name": "varchar(255)", "amount_in_cents": "int", "amount_paid_in_cents": "int", "applied_promotion_id": "bigint", "archived": "smallint", "auto_charge": "smallint", "billable_id": "int", "billable_type": "varchar(255)", "change_log": "string", "charge_on": "date", "created_at": "timestamp", "customer_id": "int", "description": "varchar(255)", "due_on": "date", "id": "int", "notified_at": "timestamp", "notify_at": "timestamp", "overriding_line_item_id": "int", "paid_through_ends_on": "date", "prepayment_ends_on": "date", "promotion_amount": "decimal(7,2)", "quantity": "int", "quickbooks_id": "varchar(255)", "running_balance_in_cents": "int", "site_id": "int", "tax_in_cents": "int", "tax_paid_in_cents": "int", "tax_rate": "decimal(6,5)", "unit_price_in_cents": "int", "updated_at": "timestamp" } - created: 2023-06-15 19:02: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_line_items`\n(\n `id` int , `billable_id` int , `billable_type` varchar(255) , `amount_in_cents` int , `description` varchar(255) , `action` varchar(255) , `created_at` timestamp , `updated_at` timestamp , `charge_on` date , `site_id` int , `amount_paid_in_cents` int , `archived` smallint , `tax_in_cents` int , `change_log` string , `tax_rate` decimal(6,5) , `tax_paid_in_cents` int , `quickbooks_id` varchar(255) , `paid_through_ends_on` date , `action_name` varchar(255) , `overriding_line_item_id` int , `auto_charge` smallint , `running_balance_in_cents` int , `due_on` date , `prepayment_ends_on` date , `customer_id` int , `quantity` int , `unit_price_in_cents` int , `promotion_amount` decimal(7,2) , `applied_promotion_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-stage/raw/esscore_line_items/2023-06-16/1686873708'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.ess_esscore_line_items`", "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.ess_esscore_line_items" }
- 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:41:45",
"disabled": false,
"format": "raw",
"id": 1082,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_stage_rds",
"table": "ess_esscore_line_items"
},
"type": "rds"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"action": "varchar(255)",
"action_name": "varchar(255)",
"amount_in_cents": "int",
"amount_paid_in_cents": "int",
"applied_promotion_id": "bigint",
"archived": "smallint",
"auto_charge": "smallint",
"billable_id": "int",
"billable_type": "varchar(255)",
"change_log": "string",
"charge_on": "date",
"created_at": "timestamp",
"customer_id": "int",
"description": "varchar(255)",
"due_on": "date",
"id": "int",
"notified_at": "timestamp",
"notify_at": "timestamp",
"overriding_line_item_id": "int",
"paid_through_ends_on": "date",
"prepayment_ends_on": "date",
"promotion_amount": "decimal(7,2)",
"quantity": "int",
"quickbooks_id": "varchar(255)",
"running_balance_in_cents": "int",
"site_id": "int",
"tax_in_cents": "int",
"tax_paid_in_cents": "int",
"tax_rate": "decimal(6,5)",
"unit_price_in_cents": "int",
"updated_at": "timestamp"
},
"created": "2023-06-15 19:02: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_line_items`\n(\n `id` int , `billable_id` int , `billable_type` varchar(255) , `amount_in_cents` int , `description` varchar(255) , `action` varchar(255) , `created_at` timestamp , `updated_at` timestamp , `charge_on` date , `site_id` int , `amount_paid_in_cents` int , `archived` smallint , `tax_in_cents` int , `change_log` string , `tax_rate` decimal(6,5) , `tax_paid_in_cents` int , `quickbooks_id` varchar(255) , `paid_through_ends_on` date , `action_name` varchar(255) , `overriding_line_item_id` int , `auto_charge` smallint , `running_balance_in_cents` int , `due_on` date , `prepayment_ends_on` date , `customer_id` int , `quantity` int , `unit_price_in_cents` int , `promotion_amount` decimal(7,2) , `applied_promotion_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-stage/raw/esscore_line_items/2023-06-16/1686873708'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.ess_esscore_line_items`",
"repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.ess_esscore_line_items"
}
},
"server": {
"hostname": "schemamanager-5c55c886bf-h2ts4",
"name": "schema_manager",
"process_start": "2025-10-21 13:03:27",
"sf_env": "stage",
"version": "2112174301"
}
}