Schema Info
Schema Name: sfdl_dev_drivethru.newbookdev_newbookrepeat_charges
- created: 2024-10-08 18:22:18
- disabled: False
- format: raw
- id: 2935
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_dev_drivethru", "table": "newbookdev_newbookrepeat_charges" } - type: drivethrucsv
Schema Versions: 15
-
Version 4749172
- created: 2024-11-05 23:25:26
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `inventory_item_id` string , `account_id` string , `invoice_description` string , `invoiced_to` string , `invoice_system_template_id` string , `invoice_email_template_id` string , `gl_category_id` string , `gl_account_id` string , `type` string , `description` string , `amount` string , `tax_free` string , `benefit_guest` string , `generate_invoice` string , `generate_daily_charges` string , `interval` string , `interval_multiplier` string , `period_from` string , `period_from_linked` string , `period_to` string , `period_to_linked` string , `next_run` string , `cancelled_when` string , `cancelled_by` string , `prorata_start` string , `prorata_end` string , `include_in_stay_cost` string , `booking_market_segment_id` string , `disburse_to_owners` string , `travel_agent_commission` string , `guest_visible` string , `from_category` string , `status` string , `removed_when` string , `removed_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-05/1730866592'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookrepeat_charges" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-05/1730866592
- id: 4749172
- processed: 1
- raw_data:
{ "account_id": 5, "amount": 14, "benefit_guest": 16, "booking_id": 3, "booking_market_segment_id": 31, "cancelled_by": 27, "cancelled_when": 26, "description": 13, "disburse_to_owners": 32, "from_category": 35, "generate_daily_charges": 18, "generate_invoice": 17, "gl_account_id": 11, "gl_category_id": 10, "guest_visible": 34, "id": 2, "include_in_stay_cost": 30, "interval": 19, "interval_multiplier": 20, "inventory_item_id": 4, "invoice_description": 6, "invoice_email_template_id": 9, "invoice_system_template_id": 8, "invoiced_to": 7, "newbook_region": 0, "next_run": 25, "period_from": 21, "period_from_linked": 22, "period_to": 23, "period_to_linked": 24, "prorata_end": 29, "prorata_start": 28, "removed_by": 38, "removed_when": 37, "status": 36, "tax_free": 15, "tenant": 1, "travel_agent_commission": 33, "type": 12 } - schema_attributes:
{ "account_id": "string", "amount": "string", "benefit_guest": "string", "booking_id": "string", "booking_market_segment_id": "string", "cancelled_by": "string", "cancelled_when": "string", "description": "string", "disburse_to_owners": "string", "from_category": "string", "generate_daily_charges": "string", "generate_invoice": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "include_in_stay_cost": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "invoice_description": "string", "invoice_email_template_id": "string", "invoice_system_template_id": "string", "invoiced_to": "string", "newbook_region": "string", "next_run": "string", "period_from": "string", "period_from_linked": "string", "period_to": "string", "period_to_linked": "string", "prorata_end": "string", "prorata_start": "string", "removed_by": "string", "removed_when": "string", "status": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string", "type": "string" } - schema_name_id: 2935
- schema_scan_id: 6675204
- updated: 2024-11-05 23:25:40
-
Version 4748940
- created: 2024-11-05 23:09:54
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `inventory_item_id` string , `account_id` string , `invoice_description` string , `invoiced_to` string , `invoice_system_template_id` string , `invoice_email_template_id` string , `gl_category_id` string , `gl_account_id` string , `type` string , `description` string , `amount` string , `tax_free` string , `benefit_guest` string , `generate_invoice` string , `generate_daily_charges` string , `interval` string , `interval_multiplier` string , `period_from` string , `period_from_linked` string , `period_to` string , `period_to_linked` string , `next_run` string , `cancelled_when` string , `cancelled_by` string , `prorata_start` string , `prorata_end` string , `include_in_stay_cost` string , `booking_market_segment_id` string , `disburse_to_owners` string , `travel_agent_commission` string , `guest_visible` string , `from_category` string , `status` string , `removed_when` string , `removed_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-05/1730866534'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookrepeat_charges" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-05/1730866534
- id: 4748940
- processed: 1
- raw_data:
{ "account_id": 5, "amount": 14, "benefit_guest": 16, "booking_id": 3, "booking_market_segment_id": 31, "cancelled_by": 27, "cancelled_when": 26, "description": 13, "disburse_to_owners": 32, "from_category": 35, "generate_daily_charges": 18, "generate_invoice": 17, "gl_account_id": 11, "gl_category_id": 10, "guest_visible": 34, "id": 2, "include_in_stay_cost": 30, "interval": 19, "interval_multiplier": 20, "inventory_item_id": 4, "invoice_description": 6, "invoice_email_template_id": 9, "invoice_system_template_id": 8, "invoiced_to": 7, "newbook_region": 0, "next_run": 25, "period_from": 21, "period_from_linked": 22, "period_to": 23, "period_to_linked": 24, "prorata_end": 29, "prorata_start": 28, "removed_by": 38, "removed_when": 37, "status": 36, "tax_free": 15, "tenant": 1, "travel_agent_commission": 33, "type": 12 } - schema_attributes:
{ "account_id": "string", "amount": "string", "benefit_guest": "string", "booking_id": "string", "booking_market_segment_id": "string", "cancelled_by": "string", "cancelled_when": "string", "description": "string", "disburse_to_owners": "string", "from_category": "string", "generate_daily_charges": "string", "generate_invoice": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "include_in_stay_cost": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "invoice_description": "string", "invoice_email_template_id": "string", "invoice_system_template_id": "string", "invoiced_to": "string", "newbook_region": "string", "next_run": "string", "period_from": "string", "period_from_linked": "string", "period_to": "string", "period_to_linked": "string", "prorata_end": "string", "prorata_start": "string", "removed_by": "string", "removed_when": "string", "status": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string", "type": "string" } - schema_name_id: 2935
- schema_scan_id: 6674972
- updated: 2024-11-05 23:10:05
-
Version 4748449
- created: 2024-11-05 22:46:37
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `inventory_item_id` string , `account_id` string , `invoice_description` string , `invoiced_to` string , `invoice_system_template_id` string , `invoice_email_template_id` string , `gl_category_id` string , `gl_account_id` string , `type` string , `description` string , `amount` string , `tax_free` string , `benefit_guest` string , `generate_invoice` string , `generate_daily_charges` string , `interval` string , `interval_multiplier` string , `period_from` string , `period_from_linked` string , `period_to` string , `period_to_linked` string , `next_run` string , `cancelled_when` string , `cancelled_by` string , `prorata_start` string , `prorata_end` string , `include_in_stay_cost` string , `booking_market_segment_id` string , `disburse_to_owners` string , `travel_agent_commission` string , `guest_visible` string , `from_category` string , `status` string , `removed_when` string , `removed_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-05/1730866415'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookrepeat_charges" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-05/1730866415
- id: 4748449
- processed: 1
- raw_data:
{ "account_id": 5, "amount": 14, "benefit_guest": 16, "booking_id": 3, "booking_market_segment_id": 31, "cancelled_by": 27, "cancelled_when": 26, "description": 13, "disburse_to_owners": 32, "from_category": 35, "generate_daily_charges": 18, "generate_invoice": 17, "gl_account_id": 11, "gl_category_id": 10, "guest_visible": 34, "id": 2, "include_in_stay_cost": 30, "interval": 19, "interval_multiplier": 20, "inventory_item_id": 4, "invoice_description": 6, "invoice_email_template_id": 9, "invoice_system_template_id": 8, "invoiced_to": 7, "newbook_region": 0, "next_run": 25, "period_from": 21, "period_from_linked": 22, "period_to": 23, "period_to_linked": 24, "prorata_end": 29, "prorata_start": 28, "removed_by": 38, "removed_when": 37, "status": 36, "tax_free": 15, "tenant": 1, "travel_agent_commission": 33, "type": 12 } - schema_attributes:
{ "account_id": "string", "amount": "string", "benefit_guest": "string", "booking_id": "string", "booking_market_segment_id": "string", "cancelled_by": "string", "cancelled_when": "string", "description": "string", "disburse_to_owners": "string", "from_category": "string", "generate_daily_charges": "string", "generate_invoice": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "include_in_stay_cost": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "invoice_description": "string", "invoice_email_template_id": "string", "invoice_system_template_id": "string", "invoiced_to": "string", "newbook_region": "string", "next_run": "string", "period_from": "string", "period_from_linked": "string", "period_to": "string", "period_to_linked": "string", "prorata_end": "string", "prorata_start": "string", "removed_by": "string", "removed_when": "string", "status": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string", "type": "string" } - schema_name_id: 2935
- schema_scan_id: 6674479
- updated: 2024-11-05 22:46:48
-
Version 4747240
- created: 2024-11-05 05:06:11
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `inventory_item_id` string , `account_id` string , `invoice_description` string , `invoiced_to` string , `invoice_system_template_id` string , `invoice_email_template_id` string , `gl_category_id` string , `gl_account_id` string , `type` string , `description` string , `amount` string , `tax_free` string , `benefit_guest` string , `generate_invoice` string , `generate_daily_charges` string , `interval` string , `interval_multiplier` string , `period_from` string , `period_from_linked` string , `period_to` string , `period_to_linked` string , `next_run` string , `cancelled_when` string , `cancelled_by` string , `prorata_start` string , `prorata_end` string , `include_in_stay_cost` string , `booking_market_segment_id` string , `disburse_to_owners` string , `travel_agent_commission` string , `guest_visible` string , `from_category` string , `status` string , `removed_when` string , `removed_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730785786'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookrepeat_charges" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730785786
- id: 4747240
- processed: 1
- raw_data:
{ "account_id": 5, "amount": 14, "benefit_guest": 16, "booking_id": 3, "booking_market_segment_id": 31, "cancelled_by": 27, "cancelled_when": 26, "description": 13, "disburse_to_owners": 32, "from_category": 35, "generate_daily_charges": 18, "generate_invoice": 17, "gl_account_id": 11, "gl_category_id": 10, "guest_visible": 34, "id": 2, "include_in_stay_cost": 30, "interval": 19, "interval_multiplier": 20, "inventory_item_id": 4, "invoice_description": 6, "invoice_email_template_id": 9, "invoice_system_template_id": 8, "invoiced_to": 7, "newbook_region": 0, "next_run": 25, "period_from": 21, "period_from_linked": 22, "period_to": 23, "period_to_linked": 24, "prorata_end": 29, "prorata_start": 28, "removed_by": 38, "removed_when": 37, "status": 36, "tax_free": 15, "tenant": 1, "travel_agent_commission": 33, "type": 12 } - schema_attributes:
{ "account_id": "string", "amount": "string", "benefit_guest": "string", "booking_id": "string", "booking_market_segment_id": "string", "cancelled_by": "string", "cancelled_when": "string", "description": "string", "disburse_to_owners": "string", "from_category": "string", "generate_daily_charges": "string", "generate_invoice": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "include_in_stay_cost": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "invoice_description": "string", "invoice_email_template_id": "string", "invoice_system_template_id": "string", "invoiced_to": "string", "newbook_region": "string", "next_run": "string", "period_from": "string", "period_from_linked": "string", "period_to": "string", "period_to_linked": "string", "prorata_end": "string", "prorata_start": "string", "removed_by": "string", "removed_when": "string", "status": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string", "type": "string" } - schema_name_id: 2935
- schema_scan_id: 6672508
- updated: 2024-11-05 05:06:23
-
Version 4745647
- created: 2024-11-05 03:34:58
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `inventory_item_id` string , `account_id` string , `invoice_description` string , `invoiced_to` string , `invoice_system_template_id` string , `invoice_email_template_id` string , `gl_category_id` string , `gl_account_id` string , `type` string , `description` string , `amount` string , `tax_free` string , `benefit_guest` string , `generate_invoice` string , `generate_daily_charges` string , `interval` string , `interval_multiplier` string , `period_from` string , `period_from_linked` string , `period_to` string , `period_to_linked` string , `next_run` string , `cancelled_when` string , `cancelled_by` string , `prorata_start` string , `prorata_end` string , `include_in_stay_cost` string , `booking_market_segment_id` string , `disburse_to_owners` string , `travel_agent_commission` string , `guest_visible` string , `from_category` string , `status` string , `removed_when` string , `removed_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730784856'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookrepeat_charges" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730784856
- id: 4745647
- processed: 1
- raw_data:
{ "account_id": 5, "amount": 14, "benefit_guest": 16, "booking_id": 3, "booking_market_segment_id": 31, "cancelled_by": 27, "cancelled_when": 26, "description": 13, "disburse_to_owners": 32, "from_category": 35, "generate_daily_charges": 18, "generate_invoice": 17, "gl_account_id": 11, "gl_category_id": 10, "guest_visible": 34, "id": 2, "include_in_stay_cost": 30, "interval": 19, "interval_multiplier": 20, "inventory_item_id": 4, "invoice_description": 6, "invoice_email_template_id": 9, "invoice_system_template_id": 8, "invoiced_to": 7, "newbook_region": 0, "next_run": 25, "period_from": 21, "period_from_linked": 22, "period_to": 23, "period_to_linked": 24, "prorata_end": 29, "prorata_start": 28, "removed_by": 38, "removed_when": 37, "status": 36, "tax_free": 15, "tenant": 1, "travel_agent_commission": 33, "type": 12 } - schema_attributes:
{ "account_id": "string", "amount": "string", "benefit_guest": "string", "booking_id": "string", "booking_market_segment_id": "string", "cancelled_by": "string", "cancelled_when": "string", "description": "string", "disburse_to_owners": "string", "from_category": "string", "generate_daily_charges": "string", "generate_invoice": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "include_in_stay_cost": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "invoice_description": "string", "invoice_email_template_id": "string", "invoice_system_template_id": "string", "invoiced_to": "string", "newbook_region": "string", "next_run": "string", "period_from": "string", "period_from_linked": "string", "period_to": "string", "period_to_linked": "string", "prorata_end": "string", "prorata_start": "string", "removed_by": "string", "removed_when": "string", "status": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string", "type": "string" } - schema_name_id: 2935
- schema_scan_id: 6670864
- updated: 2024-11-05 03:35:09
-
Version 4745644
- created: 2024-11-05 03:34:52
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `inventory_item_id` string , `account_id` string , `invoice_description` string , `invoiced_to` string , `invoice_system_template_id` string , `invoice_email_template_id` string , `gl_category_id` string , `gl_account_id` string , `type` string , `description` string , `amount` string , `tax_free` string , `benefit_guest` string , `generate_invoice` string , `generate_daily_charges` string , `interval` string , `interval_multiplier` string , `period_from` string , `period_from_linked` string , `period_to` string , `period_to_linked` string , `next_run` string , `cancelled_when` string , `cancelled_by` string , `prorata_start` string , `prorata_end` string , `include_in_stay_cost` string , `booking_market_segment_id` string , `disburse_to_owners` string , `travel_agent_commission` string , `guest_visible` string , `from_category` string , `status` string , `removed_when` string , `removed_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730785161'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookrepeat_charges" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730785161
- id: 4745644
- processed: 1
- raw_data:
{ "account_id": 5, "amount": 14, "benefit_guest": 16, "booking_id": 3, "booking_market_segment_id": 31, "cancelled_by": 27, "cancelled_when": 26, "description": 13, "disburse_to_owners": 32, "from_category": 35, "generate_daily_charges": 18, "generate_invoice": 17, "gl_account_id": 11, "gl_category_id": 10, "guest_visible": 34, "id": 2, "include_in_stay_cost": 30, "interval": 19, "interval_multiplier": 20, "inventory_item_id": 4, "invoice_description": 6, "invoice_email_template_id": 9, "invoice_system_template_id": 8, "invoiced_to": 7, "newbook_region": 0, "next_run": 25, "period_from": 21, "period_from_linked": 22, "period_to": 23, "period_to_linked": 24, "prorata_end": 29, "prorata_start": 28, "removed_by": 38, "removed_when": 37, "status": 36, "tax_free": 15, "tenant": 1, "travel_agent_commission": 33, "type": 12 } - schema_attributes:
{ "account_id": "string", "amount": "string", "benefit_guest": "string", "booking_id": "string", "booking_market_segment_id": "string", "cancelled_by": "string", "cancelled_when": "string", "description": "string", "disburse_to_owners": "string", "from_category": "string", "generate_daily_charges": "string", "generate_invoice": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "include_in_stay_cost": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "invoice_description": "string", "invoice_email_template_id": "string", "invoice_system_template_id": "string", "invoiced_to": "string", "newbook_region": "string", "next_run": "string", "period_from": "string", "period_from_linked": "string", "period_to": "string", "period_to_linked": "string", "prorata_end": "string", "prorata_start": "string", "removed_by": "string", "removed_when": "string", "status": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string", "type": "string" } - schema_name_id: 2935
- schema_scan_id: 6670860
- updated: 2024-11-05 03:35:03
-
Version 4744430
- created: 2024-11-05 03:02:47
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `inventory_item_id` string , `account_id` string , `invoice_description` string , `invoiced_to` string , `invoice_system_template_id` string , `invoice_email_template_id` string , `gl_category_id` string , `gl_account_id` string , `type` string , `description` string , `amount` string , `tax_free` string , `benefit_guest` string , `generate_invoice` string , `generate_daily_charges` string , `interval` string , `interval_multiplier` string , `period_from` string , `period_from_linked` string , `period_to` string , `period_to_linked` string , `next_run` string , `cancelled_when` string , `cancelled_by` string , `prorata_start` string , `prorata_end` string , `include_in_stay_cost` string , `booking_market_segment_id` string , `disburse_to_owners` string , `travel_agent_commission` string , `guest_visible` string , `from_category` string , `status` string , `removed_when` string , `removed_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730784090'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookrepeat_charges" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730784090
- id: 4744430
- processed: 1
- raw_data:
{ "account_id": 5, "amount": 14, "benefit_guest": 16, "booking_id": 3, "booking_market_segment_id": 31, "cancelled_by": 27, "cancelled_when": 26, "description": 13, "disburse_to_owners": 32, "from_category": 35, "generate_daily_charges": 18, "generate_invoice": 17, "gl_account_id": 11, "gl_category_id": 10, "guest_visible": 34, "id": 2, "include_in_stay_cost": 30, "interval": 19, "interval_multiplier": 20, "inventory_item_id": 4, "invoice_description": 6, "invoice_email_template_id": 9, "invoice_system_template_id": 8, "invoiced_to": 7, "newbook_region": 0, "next_run": 25, "period_from": 21, "period_from_linked": 22, "period_to": 23, "period_to_linked": 24, "prorata_end": 29, "prorata_start": 28, "removed_by": 38, "removed_when": 37, "status": 36, "tax_free": 15, "tenant": 1, "travel_agent_commission": 33, "type": 12 } - schema_attributes:
{ "account_id": "string", "amount": "string", "benefit_guest": "string", "booking_id": "string", "booking_market_segment_id": "string", "cancelled_by": "string", "cancelled_when": "string", "description": "string", "disburse_to_owners": "string", "from_category": "string", "generate_daily_charges": "string", "generate_invoice": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "include_in_stay_cost": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "invoice_description": "string", "invoice_email_template_id": "string", "invoice_system_template_id": "string", "invoiced_to": "string", "newbook_region": "string", "next_run": "string", "period_from": "string", "period_from_linked": "string", "period_to": "string", "period_to_linked": "string", "prorata_end": "string", "prorata_start": "string", "removed_by": "string", "removed_when": "string", "status": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string", "type": "string" } - schema_name_id: 2935
- schema_scan_id: 6669646
- updated: 2024-11-05 03:02:58
-
Version 4744284
- created: 2024-11-05 02:58:49
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `inventory_item_id` string , `account_id` string , `invoice_description` string , `invoiced_to` string , `invoice_system_template_id` string , `invoice_email_template_id` string , `gl_category_id` string , `gl_account_id` string , `type` string , `description` string , `amount` string , `tax_free` string , `benefit_guest` string , `generate_invoice` string , `generate_daily_charges` string , `interval` string , `interval_multiplier` string , `period_from` string , `period_from_linked` string , `period_to` string , `period_to_linked` string , `next_run` string , `cancelled_when` string , `cancelled_by` string , `prorata_start` string , `prorata_end` string , `include_in_stay_cost` string , `booking_market_segment_id` string , `disburse_to_owners` string , `travel_agent_commission` string , `guest_visible` string , `from_category` string , `status` string , `removed_when` string , `removed_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730784252'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookrepeat_charges" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730784252
- id: 4744284
- processed: 1
- raw_data:
{ "account_id": 5, "amount": 14, "benefit_guest": 16, "booking_id": 3, "booking_market_segment_id": 31, "cancelled_by": 27, "cancelled_when": 26, "description": 13, "disburse_to_owners": 32, "from_category": 35, "generate_daily_charges": 18, "generate_invoice": 17, "gl_account_id": 11, "gl_category_id": 10, "guest_visible": 34, "id": 2, "include_in_stay_cost": 30, "interval": 19, "interval_multiplier": 20, "inventory_item_id": 4, "invoice_description": 6, "invoice_email_template_id": 9, "invoice_system_template_id": 8, "invoiced_to": 7, "newbook_region": 0, "next_run": 25, "period_from": 21, "period_from_linked": 22, "period_to": 23, "period_to_linked": 24, "prorata_end": 29, "prorata_start": 28, "removed_by": 38, "removed_when": 37, "status": 36, "tax_free": 15, "tenant": 1, "travel_agent_commission": 33, "type": 12 } - schema_attributes:
{ "account_id": "string", "amount": "string", "benefit_guest": "string", "booking_id": "string", "booking_market_segment_id": "string", "cancelled_by": "string", "cancelled_when": "string", "description": "string", "disburse_to_owners": "string", "from_category": "string", "generate_daily_charges": "string", "generate_invoice": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "include_in_stay_cost": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "invoice_description": "string", "invoice_email_template_id": "string", "invoice_system_template_id": "string", "invoiced_to": "string", "newbook_region": "string", "next_run": "string", "period_from": "string", "period_from_linked": "string", "period_to": "string", "period_to_linked": "string", "prorata_end": "string", "prorata_start": "string", "removed_by": "string", "removed_when": "string", "status": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string", "type": "string" } - schema_name_id: 2935
- schema_scan_id: 6669501
- updated: 2024-11-05 02:59:00
-
Version 4743563
- created: 2024-11-05 02:39:54
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `inventory_item_id` string , `account_id` string , `invoice_description` string , `invoiced_to` string , `invoice_system_template_id` string , `invoice_email_template_id` string , `gl_category_id` string , `gl_account_id` string , `type` string , `description` string , `amount` string , `tax_free` string , `benefit_guest` string , `generate_invoice` string , `generate_daily_charges` string , `interval` string , `interval_multiplier` string , `period_from` string , `period_from_linked` string , `period_to` string , `period_to_linked` string , `next_run` string , `cancelled_when` string , `cancelled_by` string , `prorata_start` string , `prorata_end` string , `include_in_stay_cost` string , `booking_market_segment_id` string , `disburse_to_owners` string , `travel_agent_commission` string , `guest_visible` string , `from_category` string , `status` string , `removed_when` string , `removed_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730783926'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookrepeat_charges" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730783926
- id: 4743563
- processed: 1
- raw_data:
{ "account_id": 5, "amount": 14, "benefit_guest": 16, "booking_id": 3, "booking_market_segment_id": 31, "cancelled_by": 27, "cancelled_when": 26, "description": 13, "disburse_to_owners": 32, "from_category": 35, "generate_daily_charges": 18, "generate_invoice": 17, "gl_account_id": 11, "gl_category_id": 10, "guest_visible": 34, "id": 2, "include_in_stay_cost": 30, "interval": 19, "interval_multiplier": 20, "inventory_item_id": 4, "invoice_description": 6, "invoice_email_template_id": 9, "invoice_system_template_id": 8, "invoiced_to": 7, "newbook_region": 0, "next_run": 25, "period_from": 21, "period_from_linked": 22, "period_to": 23, "period_to_linked": 24, "prorata_end": 29, "prorata_start": 28, "removed_by": 38, "removed_when": 37, "status": 36, "tax_free": 15, "tenant": 1, "travel_agent_commission": 33, "type": 12 } - schema_attributes:
{ "account_id": "string", "amount": "string", "benefit_guest": "string", "booking_id": "string", "booking_market_segment_id": "string", "cancelled_by": "string", "cancelled_when": "string", "description": "string", "disburse_to_owners": "string", "from_category": "string", "generate_daily_charges": "string", "generate_invoice": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "include_in_stay_cost": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "invoice_description": "string", "invoice_email_template_id": "string", "invoice_system_template_id": "string", "invoiced_to": "string", "newbook_region": "string", "next_run": "string", "period_from": "string", "period_from_linked": "string", "period_to": "string", "period_to_linked": "string", "prorata_end": "string", "prorata_start": "string", "removed_by": "string", "removed_when": "string", "status": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string", "type": "string" } - schema_name_id: 2935
- schema_scan_id: 6668780
- updated: 2024-11-05 02:40:04
-
Version 4742790
- created: 2024-11-05 02:19:30
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `inventory_item_id` string , `account_id` string , `invoice_description` string , `invoiced_to` string , `invoice_system_template_id` string , `invoice_email_template_id` string , `gl_category_id` string , `gl_account_id` string , `type` string , `description` string , `amount` string , `tax_free` string , `benefit_guest` string , `generate_invoice` string , `generate_daily_charges` string , `interval` string , `interval_multiplier` string , `period_from` string , `period_from_linked` string , `period_to` string , `period_to_linked` string , `next_run` string , `cancelled_when` string , `cancelled_by` string , `prorata_start` string , `prorata_end` string , `include_in_stay_cost` string , `booking_market_segment_id` string , `disburse_to_owners` string , `travel_agent_commission` string , `guest_visible` string , `from_category` string , `status` string , `removed_when` string , `removed_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730783804'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookrepeat_charges" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730783804
- id: 4742790
- processed: 1
- raw_data:
{ "account_id": 5, "amount": 14, "benefit_guest": 16, "booking_id": 3, "booking_market_segment_id": 31, "cancelled_by": 27, "cancelled_when": 26, "description": 13, "disburse_to_owners": 32, "from_category": 35, "generate_daily_charges": 18, "generate_invoice": 17, "gl_account_id": 11, "gl_category_id": 10, "guest_visible": 34, "id": 2, "include_in_stay_cost": 30, "interval": 19, "interval_multiplier": 20, "inventory_item_id": 4, "invoice_description": 6, "invoice_email_template_id": 9, "invoice_system_template_id": 8, "invoiced_to": 7, "newbook_region": 0, "next_run": 25, "period_from": 21, "period_from_linked": 22, "period_to": 23, "period_to_linked": 24, "prorata_end": 29, "prorata_start": 28, "removed_by": 38, "removed_when": 37, "status": 36, "tax_free": 15, "tenant": 1, "travel_agent_commission": 33, "type": 12 } - schema_attributes:
{ "account_id": "string", "amount": "string", "benefit_guest": "string", "booking_id": "string", "booking_market_segment_id": "string", "cancelled_by": "string", "cancelled_when": "string", "description": "string", "disburse_to_owners": "string", "from_category": "string", "generate_daily_charges": "string", "generate_invoice": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "include_in_stay_cost": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "invoice_description": "string", "invoice_email_template_id": "string", "invoice_system_template_id": "string", "invoiced_to": "string", "newbook_region": "string", "next_run": "string", "period_from": "string", "period_from_linked": "string", "period_to": "string", "period_to_linked": "string", "prorata_end": "string", "prorata_start": "string", "removed_by": "string", "removed_when": "string", "status": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string", "type": "string" } - schema_name_id: 2935
- schema_scan_id: 6668007
- updated: 2024-11-05 02:19:44
-
Version 4741358
- created: 2024-11-05 01:41:31
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `inventory_item_id` string , `account_id` string , `invoice_description` string , `invoiced_to` string , `invoice_system_template_id` string , `invoice_email_template_id` string , `gl_category_id` string , `gl_account_id` string , `type` string , `description` string , `amount` string , `tax_free` string , `benefit_guest` string , `generate_invoice` string , `generate_daily_charges` string , `interval` string , `interval_multiplier` string , `period_from` string , `period_from_linked` string , `period_to` string , `period_to_linked` string , `next_run` string , `cancelled_when` string , `cancelled_by` string , `prorata_start` string , `prorata_end` string , `include_in_stay_cost` string , `booking_market_segment_id` string , `disburse_to_owners` string , `travel_agent_commission` string , `guest_visible` string , `from_category` string , `status` string , `removed_when` string , `removed_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730783560'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookrepeat_charges" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730783560
- id: 4741358
- processed: 1
- raw_data:
{ "account_id": 5, "amount": 14, "benefit_guest": 16, "booking_id": 3, "booking_market_segment_id": 31, "cancelled_by": 27, "cancelled_when": 26, "description": 13, "disburse_to_owners": 32, "from_category": 35, "generate_daily_charges": 18, "generate_invoice": 17, "gl_account_id": 11, "gl_category_id": 10, "guest_visible": 34, "id": 2, "include_in_stay_cost": 30, "interval": 19, "interval_multiplier": 20, "inventory_item_id": 4, "invoice_description": 6, "invoice_email_template_id": 9, "invoice_system_template_id": 8, "invoiced_to": 7, "newbook_region": 0, "next_run": 25, "period_from": 21, "period_from_linked": 22, "period_to": 23, "period_to_linked": 24, "prorata_end": 29, "prorata_start": 28, "removed_by": 38, "removed_when": 37, "status": 36, "tax_free": 15, "tenant": 1, "travel_agent_commission": 33, "type": 12 } - schema_attributes:
{ "account_id": "string", "amount": "string", "benefit_guest": "string", "booking_id": "string", "booking_market_segment_id": "string", "cancelled_by": "string", "cancelled_when": "string", "description": "string", "disburse_to_owners": "string", "from_category": "string", "generate_daily_charges": "string", "generate_invoice": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "include_in_stay_cost": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "invoice_description": "string", "invoice_email_template_id": "string", "invoice_system_template_id": "string", "invoiced_to": "string", "newbook_region": "string", "next_run": "string", "period_from": "string", "period_from_linked": "string", "period_to": "string", "period_to_linked": "string", "prorata_end": "string", "prorata_start": "string", "removed_by": "string", "removed_when": "string", "status": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string", "type": "string" } - schema_name_id: 2935
- schema_scan_id: 6666575
- updated: 2024-11-05 01:41:45
-
Version 4741094
- created: 2024-11-05 01:34:37
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `inventory_item_id` string , `account_id` string , `invoice_description` string , `invoiced_to` string , `invoice_system_template_id` string , `invoice_email_template_id` string , `gl_category_id` string , `gl_account_id` string , `type` string , `description` string , `amount` string , `tax_free` string , `benefit_guest` string , `generate_invoice` string , `generate_daily_charges` string , `interval` string , `interval_multiplier` string , `period_from` string , `period_from_linked` string , `period_to` string , `period_to_linked` string , `next_run` string , `cancelled_when` string , `cancelled_by` string , `prorata_start` string , `prorata_end` string , `include_in_stay_cost` string , `booking_market_segment_id` string , `disburse_to_owners` string , `travel_agent_commission` string , `guest_visible` string , `from_category` string , `status` string , `removed_when` string , `removed_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730783619'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookrepeat_charges" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730783619
- id: 4741094
- processed: 1
- raw_data:
{ "account_id": 5, "amount": 14, "benefit_guest": 16, "booking_id": 3, "booking_market_segment_id": 31, "cancelled_by": 27, "cancelled_when": 26, "description": 13, "disburse_to_owners": 32, "from_category": 35, "generate_daily_charges": 18, "generate_invoice": 17, "gl_account_id": 11, "gl_category_id": 10, "guest_visible": 34, "id": 2, "include_in_stay_cost": 30, "interval": 19, "interval_multiplier": 20, "inventory_item_id": 4, "invoice_description": 6, "invoice_email_template_id": 9, "invoice_system_template_id": 8, "invoiced_to": 7, "newbook_region": 0, "next_run": 25, "period_from": 21, "period_from_linked": 22, "period_to": 23, "period_to_linked": 24, "prorata_end": 29, "prorata_start": 28, "removed_by": 38, "removed_when": 37, "status": 36, "tax_free": 15, "tenant": 1, "travel_agent_commission": 33, "type": 12 } - schema_attributes:
{ "account_id": "string", "amount": "string", "benefit_guest": "string", "booking_id": "string", "booking_market_segment_id": "string", "cancelled_by": "string", "cancelled_when": "string", "description": "string", "disburse_to_owners": "string", "from_category": "string", "generate_daily_charges": "string", "generate_invoice": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "include_in_stay_cost": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "invoice_description": "string", "invoice_email_template_id": "string", "invoice_system_template_id": "string", "invoiced_to": "string", "newbook_region": "string", "next_run": "string", "period_from": "string", "period_from_linked": "string", "period_to": "string", "period_to_linked": "string", "prorata_end": "string", "prorata_start": "string", "removed_by": "string", "removed_when": "string", "status": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string", "type": "string" } - schema_name_id: 2935
- schema_scan_id: 6666311
- updated: 2024-11-05 01:34:50
-
Version 4740653
- created: 2024-11-05 01:22:59
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `inventory_item_id` string , `account_id` string , `invoice_description` string , `invoiced_to` string , `invoice_system_template_id` string , `invoice_email_template_id` string , `gl_category_id` string , `gl_account_id` string , `type` string , `description` string , `amount` string , `tax_free` string , `benefit_guest` string , `generate_invoice` string , `generate_daily_charges` string , `interval` string , `interval_multiplier` string , `period_from` string , `period_from_linked` string , `period_to` string , `period_to_linked` string , `next_run` string , `cancelled_when` string , `cancelled_by` string , `prorata_start` string , `prorata_end` string , `include_in_stay_cost` string , `booking_market_segment_id` string , `disburse_to_owners` string , `travel_agent_commission` string , `guest_visible` string , `from_category` string , `status` string , `removed_when` string , `removed_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730783342'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookrepeat_charges" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730783342
- id: 4740653
- processed: 1
- raw_data:
{ "account_id": 5, "amount": 14, "benefit_guest": 16, "booking_id": 3, "booking_market_segment_id": 31, "cancelled_by": 27, "cancelled_when": 26, "description": 13, "disburse_to_owners": 32, "from_category": 35, "generate_daily_charges": 18, "generate_invoice": 17, "gl_account_id": 11, "gl_category_id": 10, "guest_visible": 34, "id": 2, "include_in_stay_cost": 30, "interval": 19, "interval_multiplier": 20, "inventory_item_id": 4, "invoice_description": 6, "invoice_email_template_id": 9, "invoice_system_template_id": 8, "invoiced_to": 7, "newbook_region": 0, "next_run": 25, "period_from": 21, "period_from_linked": 22, "period_to": 23, "period_to_linked": 24, "prorata_end": 29, "prorata_start": 28, "removed_by": 38, "removed_when": 37, "status": 36, "tax_free": 15, "tenant": 1, "travel_agent_commission": 33, "type": 12 } - schema_attributes:
{ "account_id": "string", "amount": "string", "benefit_guest": "string", "booking_id": "string", "booking_market_segment_id": "string", "cancelled_by": "string", "cancelled_when": "string", "description": "string", "disburse_to_owners": "string", "from_category": "string", "generate_daily_charges": "string", "generate_invoice": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "include_in_stay_cost": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "invoice_description": "string", "invoice_email_template_id": "string", "invoice_system_template_id": "string", "invoiced_to": "string", "newbook_region": "string", "next_run": "string", "period_from": "string", "period_from_linked": "string", "period_to": "string", "period_to_linked": "string", "prorata_end": "string", "prorata_start": "string", "removed_by": "string", "removed_when": "string", "status": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string", "type": "string" } - schema_name_id: 2935
- schema_scan_id: 6665870
- updated: 2024-11-05 01:23:10
-
Version 4739734
- created: 2024-11-05 00:58:27
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `inventory_item_id` string , `account_id` string , `invoice_description` string , `invoiced_to` string , `invoice_system_template_id` string , `invoice_email_template_id` string , `gl_category_id` string , `gl_account_id` string , `type` string , `description` string , `amount` string , `tax_free` string , `benefit_guest` string , `generate_invoice` string , `generate_daily_charges` string , `interval` string , `interval_multiplier` string , `period_from` string , `period_from_linked` string , `period_to` string , `period_to_linked` string , `next_run` string , `cancelled_when` string , `cancelled_by` string , `prorata_start` string , `prorata_end` string , `include_in_stay_cost` string , `booking_market_segment_id` string , `disburse_to_owners` string , `travel_agent_commission` string , `guest_visible` string , `from_category` string , `status` string , `removed_when` string , `removed_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730782941'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookrepeat_charges" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730782941
- id: 4739734
- processed: 1
- raw_data:
{ "account_id": 5, "amount": 14, "benefit_guest": 16, "booking_id": 3, "booking_market_segment_id": 31, "cancelled_by": 27, "cancelled_when": 26, "description": 13, "disburse_to_owners": 32, "from_category": 35, "generate_daily_charges": 18, "generate_invoice": 17, "gl_account_id": 11, "gl_category_id": 10, "guest_visible": 34, "id": 2, "include_in_stay_cost": 30, "interval": 19, "interval_multiplier": 20, "inventory_item_id": 4, "invoice_description": 6, "invoice_email_template_id": 9, "invoice_system_template_id": 8, "invoiced_to": 7, "newbook_region": 0, "next_run": 25, "period_from": 21, "period_from_linked": 22, "period_to": 23, "period_to_linked": 24, "prorata_end": 29, "prorata_start": 28, "removed_by": 38, "removed_when": 37, "status": 36, "tax_free": 15, "tenant": 1, "travel_agent_commission": 33, "type": 12 } - schema_attributes:
{ "account_id": "string", "amount": "string", "benefit_guest": "string", "booking_id": "string", "booking_market_segment_id": "string", "cancelled_by": "string", "cancelled_when": "string", "description": "string", "disburse_to_owners": "string", "from_category": "string", "generate_daily_charges": "string", "generate_invoice": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "include_in_stay_cost": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "invoice_description": "string", "invoice_email_template_id": "string", "invoice_system_template_id": "string", "invoiced_to": "string", "newbook_region": "string", "next_run": "string", "period_from": "string", "period_from_linked": "string", "period_to": "string", "period_to_linked": "string", "prorata_end": "string", "prorata_start": "string", "removed_by": "string", "removed_when": "string", "status": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string", "type": "string" } - schema_name_id: 2935
- schema_scan_id: 6664950
- updated: 2024-11-05 00:58:40
-
Version 4739165
- created: 2024-11-05 00:43:29
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `inventory_item_id` string , `account_id` string , `invoice_description` string , `invoiced_to` string , `invoice_system_template_id` string , `invoice_email_template_id` string , `gl_category_id` string , `gl_account_id` string , `type` string , `description` string , `amount` string , `tax_free` string , `benefit_guest` string , `generate_invoice` string , `generate_daily_charges` string , `interval` string , `interval_multiplier` string , `period_from` string , `period_from_linked` string , `period_to` string , `period_to_linked` string , `next_run` string , `cancelled_when` string , `cancelled_by` string , `prorata_start` string , `prorata_end` string , `include_in_stay_cost` string , `booking_market_segment_id` string , `disburse_to_owners` string , `travel_agent_commission` string , `guest_visible` string , `from_category` string , `status` string , `removed_when` string , `removed_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730782832'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookrepeat_charges" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730782832
- id: 4739165
- processed: 1
- raw_data:
{ "account_id": 5, "amount": 14, "benefit_guest": 16, "booking_id": 3, "booking_market_segment_id": 31, "cancelled_by": 27, "cancelled_when": 26, "description": 13, "disburse_to_owners": 32, "from_category": 35, "generate_daily_charges": 18, "generate_invoice": 17, "gl_account_id": 11, "gl_category_id": 10, "guest_visible": 34, "id": 2, "include_in_stay_cost": 30, "interval": 19, "interval_multiplier": 20, "inventory_item_id": 4, "invoice_description": 6, "invoice_email_template_id": 9, "invoice_system_template_id": 8, "invoiced_to": 7, "newbook_region": 0, "next_run": 25, "period_from": 21, "period_from_linked": 22, "period_to": 23, "period_to_linked": 24, "prorata_end": 29, "prorata_start": 28, "removed_by": 38, "removed_when": 37, "status": 36, "tax_free": 15, "tenant": 1, "travel_agent_commission": 33, "type": 12 } - schema_attributes:
{ "account_id": "string", "amount": "string", "benefit_guest": "string", "booking_id": "string", "booking_market_segment_id": "string", "cancelled_by": "string", "cancelled_when": "string", "description": "string", "disburse_to_owners": "string", "from_category": "string", "generate_daily_charges": "string", "generate_invoice": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "include_in_stay_cost": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "invoice_description": "string", "invoice_email_template_id": "string", "invoice_system_template_id": "string", "invoiced_to": "string", "newbook_region": "string", "next_run": "string", "period_from": "string", "period_from_linked": "string", "period_to": "string", "period_to_linked": "string", "prorata_end": "string", "prorata_start": "string", "removed_by": "string", "removed_when": "string", "status": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string", "type": "string" } - schema_name_id: 2935
- schema_scan_id: 6664380
- updated: 2024-11-05 00:43:40
Schema Scans: 15
Last at 2024-11-05 23:25:25
-
Scan 6675204
- duration: 0:00:15.019791
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6675204
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-05/1730866592", "key": "raw/newbookdev_newbookrepeat_charges/2024-11-05/1730866592/repeat_charges.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookrepeat_charges", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2080625994504752331, "service_name": "drive-thru", "span_id": 4987704409150787884, "trace_id": 10305954253581068689 } } - running: False
- schema_name_id: 2935
- start_time: 2024-11-05 23:25:25
- success: True
- trace_id: 10305954253581068689
-
Scan 6674972
- duration: 0:00:12.612446
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6674972
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-05/1730866534", "key": "raw/newbookdev_newbookrepeat_charges/2024-11-05/1730866534/repeat_charges.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookrepeat_charges", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7011133813842162098, "service_name": "drive-thru", "span_id": 5595031050120096816, "trace_id": 3641439021206771559 } } - running: False
- schema_name_id: 2935
- start_time: 2024-11-05 23:09:52
- success: True
- trace_id: 3641439021206771559
-
Scan 6674479
- duration: 0:00:12.640694
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6674479
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-05/1730866415", "key": "raw/newbookdev_newbookrepeat_charges/2024-11-05/1730866415/repeat_charges.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookrepeat_charges", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16781719326491581150, "service_name": "drive-thru", "span_id": 13181349748667767553, "trace_id": 5512551342555313802 } } - running: False
- schema_name_id: 2935
- start_time: 2024-11-05 22:46:35
- success: True
- trace_id: 5512551342555313802
-
Scan 6672508
- duration: 0:00:12.618464
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6672508
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730785786", "key": "raw/newbookdev_newbookrepeat_charges/2024-11-04/1730785786/repeat_charges.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookrepeat_charges", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15490252706800890411, "service_name": "drive-thru", "span_id": 10993359089415939923, "trace_id": 7283242959579820590 } } - running: False
- schema_name_id: 2935
- start_time: 2024-11-05 05:06:10
- success: True
- trace_id: 7283242959579820590
-
Scan 6670864
- duration: 0:00:12.370172
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6670864
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730784856", "key": "raw/newbookdev_newbookrepeat_charges/2024-11-04/1730784856/repeat_charges.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookrepeat_charges", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14791919815088128709, "service_name": "drive-thru", "span_id": 5468449605634917935, "trace_id": 12442047257752457592 } } - running: False
- schema_name_id: 2935
- start_time: 2024-11-05 03:34:57
- success: True
- trace_id: 12442047257752457592
-
Scan 6670860
- duration: 0:00:12.309023
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6670860
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730785161", "key": "raw/newbookdev_newbookrepeat_charges/2024-11-04/1730785161/repeat_charges.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookrepeat_charges", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17750385514176257655, "service_name": "drive-thru", "span_id": 1853590944808097976, "trace_id": 11754650315972042997 } } - running: False
- schema_name_id: 2935
- start_time: 2024-11-05 03:34:50
- success: True
- trace_id: 11754650315972042997
-
Scan 6669646
- duration: 0:00:12.015557
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6669646
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730784090", "key": "raw/newbookdev_newbookrepeat_charges/2024-11-04/1730784090/repeat_charges.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookrepeat_charges", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16323714549389995467, "service_name": "drive-thru", "span_id": 16276666162500183012, "trace_id": 1908617613602567160 } } - running: False
- schema_name_id: 2935
- start_time: 2024-11-05 03:02:46
- success: True
- trace_id: 1908617613602567160
-
Scan 6669501
- duration: 0:00:12.270894
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6669501
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730784252", "key": "raw/newbookdev_newbookrepeat_charges/2024-11-04/1730784252/repeat_charges.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookrepeat_charges", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8196044459537404077, "service_name": "drive-thru", "span_id": 173722609979875698, "trace_id": 14476571741666336963 } } - running: False
- schema_name_id: 2935
- start_time: 2024-11-05 02:58:48
- success: True
- trace_id: 14476571741666336963
-
Scan 6668780
- duration: 0:00:12.257531
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6668780
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730783926", "key": "raw/newbookdev_newbookrepeat_charges/2024-11-04/1730783926/repeat_charges.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookrepeat_charges", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1970425581189092624, "service_name": "drive-thru", "span_id": 117064332135057484, "trace_id": 8063321645821009656 } } - running: False
- schema_name_id: 2935
- start_time: 2024-11-05 02:39:52
- success: True
- trace_id: 8063321645821009656
-
Scan 6668007
- duration: 0:00:14.740454
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6668007
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730783804", "key": "raw/newbookdev_newbookrepeat_charges/2024-11-04/1730783804/repeat_charges.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookrepeat_charges", "type": "drivethrucsv" }, "trace_context": { "parent_id": 18000322237218351074, "service_name": "drive-thru", "span_id": 5229486008950082502, "trace_id": 12443051175440285548 } } - running: False
- schema_name_id: 2935
- start_time: 2024-11-05 02:19:29
- success: True
- trace_id: 12443051175440285548
-
Scan 6666575
- duration: 0:00:15.006371
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6666575
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730783560", "key": "raw/newbookdev_newbookrepeat_charges/2024-11-04/1730783560/repeat_charges.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookrepeat_charges", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7779036722898976828, "service_name": "drive-thru", "span_id": 1334078560051414910, "trace_id": 12095377152726846079 } } - running: False
- schema_name_id: 2935
- start_time: 2024-11-05 01:41:30
- success: True
- trace_id: 12095377152726846079
-
Scan 6666311
- duration: 0:00:14.845797
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6666311
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730783619", "key": "raw/newbookdev_newbookrepeat_charges/2024-11-04/1730783619/repeat_charges.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookrepeat_charges", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8648447225105601202, "service_name": "drive-thru", "span_id": 1356231751068733168, "trace_id": 11893202705440676074 } } - running: False
- schema_name_id: 2935
- start_time: 2024-11-05 01:34:35
- success: True
- trace_id: 11893202705440676074
-
Scan 6665870
- duration: 0:00:12.295478
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6665870
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730783342", "key": "raw/newbookdev_newbookrepeat_charges/2024-11-04/1730783342/repeat_charges.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookrepeat_charges", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5490588864793851023, "service_name": "drive-thru", "span_id": 1427033586041617988, "trace_id": 4528989089596636710 } } - running: False
- schema_name_id: 2935
- start_time: 2024-11-05 01:22:58
- success: True
- trace_id: 4528989089596636710
-
Scan 6664950
- duration: 0:00:14.713036
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6664950
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730782941", "key": "raw/newbookdev_newbookrepeat_charges/2024-11-04/1730782941/repeat_charges.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookrepeat_charges", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1332234626328457654, "service_name": "drive-thru", "span_id": 3701707886911932416, "trace_id": 2443184089433634556 } } - running: False
- schema_name_id: 2935
- start_time: 2024-11-05 00:58:25
- success: True
- trace_id: 2443184089433634556
-
Scan 6664380
- duration: 0:00:12.341293
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6664380
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-04/1730782832", "key": "raw/newbookdev_newbookrepeat_charges/2024-11-04/1730782832/repeat_charges.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookrepeat_charges", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3335337929003071347, "service_name": "drive-thru", "span_id": 15407578050452824107, "trace_id": 1833358116338426736 } } - running: False
- schema_name_id: 2935
- start_time: 2024-11-05 00:43:28
- success: True
- trace_id: 1833358116338426736
- attributes:
{ "account_id": "string", "amount": "string", "benefit_guest": "string", "booking_id": "string", "booking_market_segment_id": "string", "cancelled_by": "string", "cancelled_when": "string", "description": "string", "disburse_to_owners": "string", "from_category": "string", "generate_daily_charges": "string", "generate_invoice": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "include_in_stay_cost": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "invoice_description": "string", "invoice_email_template_id": "string", "invoice_system_template_id": "string", "invoiced_to": "string", "newbook_region": "string", "next_run": "string", "period_from": "string", "period_from_linked": "string", "period_to": "string", "period_to_linked": "string", "prorata_end": "string", "prorata_start": "string", "removed_by": "string", "removed_when": "string", "status": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string", "type": "string" } - created: 2024-11-05 23:25:26
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `inventory_item_id` string , `account_id` string , `invoice_description` string , `invoiced_to` string , `invoice_system_template_id` string , `invoice_email_template_id` string , `gl_category_id` string , `gl_account_id` string , `type` string , `description` string , `amount` string , `tax_free` string , `benefit_guest` string , `generate_invoice` string , `generate_daily_charges` string , `interval` string , `interval_multiplier` string , `period_from` string , `period_from_linked` string , `period_to` string , `period_to_linked` string , `next_run` string , `cancelled_when` string , `cancelled_by` string , `prorata_start` string , `prorata_end` string , `include_in_stay_cost` string , `booking_market_segment_id` string , `disburse_to_owners` string , `travel_agent_commission` string , `guest_visible` string , `from_category` string , `status` string , `removed_when` string , `removed_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-05/1730866592'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookrepeat_charges" }
- hostname: schemamanager-5447774fc6-4w58v
- name: schema_manager
- process_start: 2026-04-02 21:43:44
- sf_env: dev
- version: 2427328685
{
"name": {
"created": "2024-10-08 18:22:18",
"disabled": false,
"format": "raw",
"id": 2935,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_dev_drivethru",
"table": "newbookdev_newbookrepeat_charges"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"account_id": "string",
"amount": "string",
"benefit_guest": "string",
"booking_id": "string",
"booking_market_segment_id": "string",
"cancelled_by": "string",
"cancelled_when": "string",
"description": "string",
"disburse_to_owners": "string",
"from_category": "string",
"generate_daily_charges": "string",
"generate_invoice": "string",
"gl_account_id": "string",
"gl_category_id": "string",
"guest_visible": "string",
"id": "string",
"include_in_stay_cost": "string",
"interval": "string",
"interval_multiplier": "string",
"inventory_item_id": "string",
"invoice_description": "string",
"invoice_email_template_id": "string",
"invoice_system_template_id": "string",
"invoiced_to": "string",
"newbook_region": "string",
"next_run": "string",
"period_from": "string",
"period_from_linked": "string",
"period_to": "string",
"period_to_linked": "string",
"prorata_end": "string",
"prorata_start": "string",
"removed_by": "string",
"removed_when": "string",
"status": "string",
"tax_free": "string",
"tenant": "string",
"travel_agent_commission": "string",
"type": "string"
},
"created": "2024-11-05 23:25:26",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `inventory_item_id` string , `account_id` string , `invoice_description` string , `invoiced_to` string , `invoice_system_template_id` string , `invoice_email_template_id` string , `gl_category_id` string , `gl_account_id` string , `type` string , `description` string , `amount` string , `tax_free` string , `benefit_guest` string , `generate_invoice` string , `generate_daily_charges` string , `interval` string , `interval_multiplier` string , `period_from` string , `period_from_linked` string , `period_to` string , `period_to_linked` string , `next_run` string , `cancelled_when` string , `cancelled_by` string , `prorata_start` string , `prorata_end` string , `include_in_stay_cost` string , `booking_market_segment_id` string , `disburse_to_owners` string , `travel_agent_commission` string , `guest_visible` string , `from_category` string , `status` string , `removed_when` string , `removed_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrepeat_charges/2024-11-05/1730866592'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookrepeat_charges`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookrepeat_charges"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}