Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items

created: 2024-10-08 17:42:46
disabled: False
format: raw
id: 2489
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_dev_drivethru",
    "table": "newbookdev_newbookbookings_rule_templates_inventory_items"
}

type: drivethrucsv

Schema Versions: 15

Version 4748259

created: 2024-11-05 22:39:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `item_type`  string , `calculation_type`  string , `description`  string , `daytype`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_other_tariffs`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `include_in_payment_plan`  string , `disburse_to_owners`  string , `refundable`  string , `discounts_apply`  string , `set_id`  string , `set_name`  string , `set_visible`  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_newbookbookings_rule_templates_inventory_items/2024-11-05/1730866385'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_rule_templates_inventory_items/2024-11-05/1730866385
id: 4748259
processed: 1

raw_data:

{
    "amount": 18,
    "calculation_type": 8,
    "daysofweek": 14,
    "daytype": 10,
    "description": 9,
    "disburse_to_owners": 30,
    "discounts_apply": 32,
    "gl_account_id": 6,
    "gl_category_id": 5,
    "guest_visible": 25,
    "id": 2,
    "ignore_other_tariffs": 15,
    "ignore_period_from": 16,
    "ignore_period_to": 17,
    "include_in_deposit": 28,
    "include_in_payment_plan": 29,
    "include_in_stay_cost": 27,
    "interval": 11,
    "interval_limit": 13,
    "interval_multiplier": 12,
    "inventory_item_id": 4,
    "item_type": 7,
    "newbook_region": 0,
    "per_adult": 19,
    "per_animal": 22,
    "per_child": 20,
    "per_infant": 21,
    "qty": 23,
    "refundable": 31,
    "set_id": 33,
    "set_name": 34,
    "set_visible": 35,
    "tax_free": 24,
    "template_id": 3,
    "tenant": 1,
    "travel_agent_commission": 26
}

schema_attributes:

{
    "amount": "string",
    "calculation_type": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_other_tariffs": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_payment_plan": "string",
    "include_in_stay_cost": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "item_type": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "qty": "string",
    "refundable": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "template_id": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

schema_name_id: 2489
schema_scan_id: 6674291
updated: 2024-11-05 22:40:12

Version 4747818

created: 2024-11-05 22:26:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `item_type`  string , `calculation_type`  string , `description`  string , `daytype`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_other_tariffs`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `include_in_payment_plan`  string , `disburse_to_owners`  string , `refundable`  string , `discounts_apply`  string , `set_id`  string , `set_name`  string , `set_visible`  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_newbookbookings_rule_templates_inventory_items/2024-11-05/1730866317'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_rule_templates_inventory_items/2024-11-05/1730866317
id: 4747818
processed: 1

raw_data:

{
    "amount": 18,
    "calculation_type": 8,
    "daysofweek": 14,
    "daytype": 10,
    "description": 9,
    "disburse_to_owners": 30,
    "discounts_apply": 32,
    "gl_account_id": 6,
    "gl_category_id": 5,
    "guest_visible": 25,
    "id": 2,
    "ignore_other_tariffs": 15,
    "ignore_period_from": 16,
    "ignore_period_to": 17,
    "include_in_deposit": 28,
    "include_in_payment_plan": 29,
    "include_in_stay_cost": 27,
    "interval": 11,
    "interval_limit": 13,
    "interval_multiplier": 12,
    "inventory_item_id": 4,
    "item_type": 7,
    "newbook_region": 0,
    "per_adult": 19,
    "per_animal": 22,
    "per_child": 20,
    "per_infant": 21,
    "qty": 23,
    "refundable": 31,
    "set_id": 33,
    "set_name": 34,
    "set_visible": 35,
    "tax_free": 24,
    "template_id": 3,
    "tenant": 1,
    "travel_agent_commission": 26
}

schema_attributes:

{
    "amount": "string",
    "calculation_type": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_other_tariffs": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_payment_plan": "string",
    "include_in_stay_cost": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "item_type": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "qty": "string",
    "refundable": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "template_id": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

schema_name_id: 2489
schema_scan_id: 6673850
updated: 2024-11-05 22:27:00

Version 4747492

created: 2024-11-05 22:18:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `item_type`  string , `calculation_type`  string , `description`  string , `daytype`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_other_tariffs`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `include_in_payment_plan`  string , `disburse_to_owners`  string , `refundable`  string , `discounts_apply`  string , `set_id`  string , `set_name`  string , `set_visible`  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_newbookbookings_rule_templates_inventory_items/2024-11-05/1730866240'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_rule_templates_inventory_items/2024-11-05/1730866240
id: 4747492
processed: 1

raw_data:

{
    "amount": 18,
    "calculation_type": 8,
    "daysofweek": 14,
    "daytype": 10,
    "description": 9,
    "disburse_to_owners": 30,
    "discounts_apply": 32,
    "gl_account_id": 6,
    "gl_category_id": 5,
    "guest_visible": 25,
    "id": 2,
    "ignore_other_tariffs": 15,
    "ignore_period_from": 16,
    "ignore_period_to": 17,
    "include_in_deposit": 28,
    "include_in_payment_plan": 29,
    "include_in_stay_cost": 27,
    "interval": 11,
    "interval_limit": 13,
    "interval_multiplier": 12,
    "inventory_item_id": 4,
    "item_type": 7,
    "newbook_region": 0,
    "per_adult": 19,
    "per_animal": 22,
    "per_child": 20,
    "per_infant": 21,
    "qty": 23,
    "refundable": 31,
    "set_id": 33,
    "set_name": 34,
    "set_visible": 35,
    "tax_free": 24,
    "template_id": 3,
    "tenant": 1,
    "travel_agent_commission": 26
}

schema_attributes:

{
    "amount": "string",
    "calculation_type": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_other_tariffs": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_payment_plan": "string",
    "include_in_stay_cost": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "item_type": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "qty": "string",
    "refundable": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "template_id": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

schema_name_id: 2489
schema_scan_id: 6673524
updated: 2024-11-05 22:18:25

Version 4746641

created: 2024-11-05 04:14:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `item_type`  string , `calculation_type`  string , `description`  string , `daytype`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_other_tariffs`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `include_in_payment_plan`  string , `disburse_to_owners`  string , `refundable`  string , `discounts_apply`  string , `set_id`  string , `set_name`  string , `set_visible`  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_newbookbookings_rule_templates_inventory_items/2024-11-04/1730785659'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_rule_templates_inventory_items/2024-11-04/1730785659
id: 4746641
processed: 1

raw_data:

{
    "amount": 18,
    "calculation_type": 8,
    "daysofweek": 14,
    "daytype": 10,
    "description": 9,
    "disburse_to_owners": 30,
    "discounts_apply": 32,
    "gl_account_id": 6,
    "gl_category_id": 5,
    "guest_visible": 25,
    "id": 2,
    "ignore_other_tariffs": 15,
    "ignore_period_from": 16,
    "ignore_period_to": 17,
    "include_in_deposit": 28,
    "include_in_payment_plan": 29,
    "include_in_stay_cost": 27,
    "interval": 11,
    "interval_limit": 13,
    "interval_multiplier": 12,
    "inventory_item_id": 4,
    "item_type": 7,
    "newbook_region": 0,
    "per_adult": 19,
    "per_animal": 22,
    "per_child": 20,
    "per_infant": 21,
    "qty": 23,
    "refundable": 31,
    "set_id": 33,
    "set_name": 34,
    "set_visible": 35,
    "tax_free": 24,
    "template_id": 3,
    "tenant": 1,
    "travel_agent_commission": 26
}

schema_attributes:

{
    "amount": "string",
    "calculation_type": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_other_tariffs": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_payment_plan": "string",
    "include_in_stay_cost": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "item_type": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "qty": "string",
    "refundable": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "template_id": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

schema_name_id: 2489
schema_scan_id: 6671864
updated: 2024-11-05 04:14:13

Version 4746167

created: 2024-11-05 03:51:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `item_type`  string , `calculation_type`  string , `description`  string , `daytype`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_other_tariffs`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `include_in_payment_plan`  string , `disburse_to_owners`  string , `refundable`  string , `discounts_apply`  string , `set_id`  string , `set_name`  string , `set_visible`  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_newbookbookings_rule_templates_inventory_items/2024-11-04/1730785088'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_rule_templates_inventory_items/2024-11-04/1730785088
id: 4746167
processed: 1

raw_data:

{
    "amount": 18,
    "calculation_type": 8,
    "daysofweek": 14,
    "daytype": 10,
    "description": 9,
    "disburse_to_owners": 30,
    "discounts_apply": 32,
    "gl_account_id": 6,
    "gl_category_id": 5,
    "guest_visible": 25,
    "id": 2,
    "ignore_other_tariffs": 15,
    "ignore_period_from": 16,
    "ignore_period_to": 17,
    "include_in_deposit": 28,
    "include_in_payment_plan": 29,
    "include_in_stay_cost": 27,
    "interval": 11,
    "interval_limit": 13,
    "interval_multiplier": 12,
    "inventory_item_id": 4,
    "item_type": 7,
    "newbook_region": 0,
    "per_adult": 19,
    "per_animal": 22,
    "per_child": 20,
    "per_infant": 21,
    "qty": 23,
    "refundable": 31,
    "set_id": 33,
    "set_name": 34,
    "set_visible": 35,
    "tax_free": 24,
    "template_id": 3,
    "tenant": 1,
    "travel_agent_commission": 26
}

schema_attributes:

{
    "amount": "string",
    "calculation_type": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_other_tariffs": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_payment_plan": "string",
    "include_in_stay_cost": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "item_type": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "qty": "string",
    "refundable": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "template_id": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

schema_name_id: 2489
schema_scan_id: 6671388
updated: 2024-11-05 03:51:51

Version 4745236

created: 2024-11-05 03:24:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `item_type`  string , `calculation_type`  string , `description`  string , `daytype`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_other_tariffs`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `include_in_payment_plan`  string , `disburse_to_owners`  string , `refundable`  string , `discounts_apply`  string , `set_id`  string , `set_name`  string , `set_visible`  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_newbookbookings_rule_templates_inventory_items/2024-11-04/1730784782'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_rule_templates_inventory_items/2024-11-04/1730784782
id: 4745236
processed: 1

raw_data:

{
    "amount": 18,
    "calculation_type": 8,
    "daysofweek": 14,
    "daytype": 10,
    "description": 9,
    "disburse_to_owners": 30,
    "discounts_apply": 32,
    "gl_account_id": 6,
    "gl_category_id": 5,
    "guest_visible": 25,
    "id": 2,
    "ignore_other_tariffs": 15,
    "ignore_period_from": 16,
    "ignore_period_to": 17,
    "include_in_deposit": 28,
    "include_in_payment_plan": 29,
    "include_in_stay_cost": 27,
    "interval": 11,
    "interval_limit": 13,
    "interval_multiplier": 12,
    "inventory_item_id": 4,
    "item_type": 7,
    "newbook_region": 0,
    "per_adult": 19,
    "per_animal": 22,
    "per_child": 20,
    "per_infant": 21,
    "qty": 23,
    "refundable": 31,
    "set_id": 33,
    "set_name": 34,
    "set_visible": 35,
    "tax_free": 24,
    "template_id": 3,
    "tenant": 1,
    "travel_agent_commission": 26
}

schema_attributes:

{
    "amount": "string",
    "calculation_type": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_other_tariffs": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_payment_plan": "string",
    "include_in_stay_cost": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "item_type": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "qty": "string",
    "refundable": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "template_id": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

schema_name_id: 2489
schema_scan_id: 6670453
updated: 2024-11-05 03:24:22

Version 4744346

created: 2024-11-05 03:00:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `item_type`  string , `calculation_type`  string , `description`  string , `daytype`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_other_tariffs`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `include_in_payment_plan`  string , `disburse_to_owners`  string , `refundable`  string , `discounts_apply`  string , `set_id`  string , `set_name`  string , `set_visible`  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_newbookbookings_rule_templates_inventory_items/2024-11-04/1730784179'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_rule_templates_inventory_items/2024-11-04/1730784179
id: 4744346
processed: 1

raw_data:

{
    "amount": 18,
    "calculation_type": 8,
    "daysofweek": 14,
    "daytype": 10,
    "description": 9,
    "disburse_to_owners": 30,
    "discounts_apply": 32,
    "gl_account_id": 6,
    "gl_category_id": 5,
    "guest_visible": 25,
    "id": 2,
    "ignore_other_tariffs": 15,
    "ignore_period_from": 16,
    "ignore_period_to": 17,
    "include_in_deposit": 28,
    "include_in_payment_plan": 29,
    "include_in_stay_cost": 27,
    "interval": 11,
    "interval_limit": 13,
    "interval_multiplier": 12,
    "inventory_item_id": 4,
    "item_type": 7,
    "newbook_region": 0,
    "per_adult": 19,
    "per_animal": 22,
    "per_child": 20,
    "per_infant": 21,
    "qty": 23,
    "refundable": 31,
    "set_id": 33,
    "set_name": 34,
    "set_visible": 35,
    "tax_free": 24,
    "template_id": 3,
    "tenant": 1,
    "travel_agent_commission": 26
}

schema_attributes:

{
    "amount": "string",
    "calculation_type": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_other_tariffs": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_payment_plan": "string",
    "include_in_stay_cost": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "item_type": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "qty": "string",
    "refundable": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "template_id": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

schema_name_id: 2489
schema_scan_id: 6669563
updated: 2024-11-05 03:00:43

Version 4743775

created: 2024-11-05 02:45:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `item_type`  string , `calculation_type`  string , `description`  string , `daytype`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_other_tariffs`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `include_in_payment_plan`  string , `disburse_to_owners`  string , `refundable`  string , `discounts_apply`  string , `set_id`  string , `set_name`  string , `set_visible`  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_newbookbookings_rule_templates_inventory_items/2024-11-04/1730784017'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_rule_templates_inventory_items/2024-11-04/1730784017
id: 4743775
processed: 1

raw_data:

{
    "amount": 18,
    "calculation_type": 8,
    "daysofweek": 14,
    "daytype": 10,
    "description": 9,
    "disburse_to_owners": 30,
    "discounts_apply": 32,
    "gl_account_id": 6,
    "gl_category_id": 5,
    "guest_visible": 25,
    "id": 2,
    "ignore_other_tariffs": 15,
    "ignore_period_from": 16,
    "ignore_period_to": 17,
    "include_in_deposit": 28,
    "include_in_payment_plan": 29,
    "include_in_stay_cost": 27,
    "interval": 11,
    "interval_limit": 13,
    "interval_multiplier": 12,
    "inventory_item_id": 4,
    "item_type": 7,
    "newbook_region": 0,
    "per_adult": 19,
    "per_animal": 22,
    "per_child": 20,
    "per_infant": 21,
    "qty": 23,
    "refundable": 31,
    "set_id": 33,
    "set_name": 34,
    "set_visible": 35,
    "tax_free": 24,
    "template_id": 3,
    "tenant": 1,
    "travel_agent_commission": 26
}

schema_attributes:

{
    "amount": "string",
    "calculation_type": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_other_tariffs": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_payment_plan": "string",
    "include_in_stay_cost": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "item_type": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "qty": "string",
    "refundable": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "template_id": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

schema_name_id: 2489
schema_scan_id: 6668992
updated: 2024-11-05 02:45:44

Version 4743039

created: 2024-11-05 02:26:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `item_type`  string , `calculation_type`  string , `description`  string , `daytype`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_other_tariffs`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `include_in_payment_plan`  string , `disburse_to_owners`  string , `refundable`  string , `discounts_apply`  string , `set_id`  string , `set_name`  string , `set_visible`  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_newbookbookings_rule_templates_inventory_items/2024-11-04/1730783871'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_rule_templates_inventory_items/2024-11-04/1730783871
id: 4743039
processed: 1

raw_data:

{
    "amount": 18,
    "calculation_type": 8,
    "daysofweek": 14,
    "daytype": 10,
    "description": 9,
    "disburse_to_owners": 30,
    "discounts_apply": 32,
    "gl_account_id": 6,
    "gl_category_id": 5,
    "guest_visible": 25,
    "id": 2,
    "ignore_other_tariffs": 15,
    "ignore_period_from": 16,
    "ignore_period_to": 17,
    "include_in_deposit": 28,
    "include_in_payment_plan": 29,
    "include_in_stay_cost": 27,
    "interval": 11,
    "interval_limit": 13,
    "interval_multiplier": 12,
    "inventory_item_id": 4,
    "item_type": 7,
    "newbook_region": 0,
    "per_adult": 19,
    "per_animal": 22,
    "per_child": 20,
    "per_infant": 21,
    "qty": 23,
    "refundable": 31,
    "set_id": 33,
    "set_name": 34,
    "set_visible": 35,
    "tax_free": 24,
    "template_id": 3,
    "tenant": 1,
    "travel_agent_commission": 26
}

schema_attributes:

{
    "amount": "string",
    "calculation_type": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_other_tariffs": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_payment_plan": "string",
    "include_in_stay_cost": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "item_type": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "qty": "string",
    "refundable": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "template_id": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

schema_name_id: 2489
schema_scan_id: 6668256
updated: 2024-11-05 02:26:14

Version 4742191

created: 2024-11-05 02:03:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `item_type`  string , `calculation_type`  string , `description`  string , `daytype`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_other_tariffs`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `include_in_payment_plan`  string , `disburse_to_owners`  string , `refundable`  string , `discounts_apply`  string , `set_id`  string , `set_name`  string , `set_visible`  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_newbookbookings_rule_templates_inventory_items/2024-11-04/1730783729'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_rule_templates_inventory_items/2024-11-04/1730783729
id: 4742191
processed: 1

raw_data:

{
    "amount": 18,
    "calculation_type": 8,
    "daysofweek": 14,
    "daytype": 10,
    "description": 9,
    "disburse_to_owners": 30,
    "discounts_apply": 32,
    "gl_account_id": 6,
    "gl_category_id": 5,
    "guest_visible": 25,
    "id": 2,
    "ignore_other_tariffs": 15,
    "ignore_period_from": 16,
    "ignore_period_to": 17,
    "include_in_deposit": 28,
    "include_in_payment_plan": 29,
    "include_in_stay_cost": 27,
    "interval": 11,
    "interval_limit": 13,
    "interval_multiplier": 12,
    "inventory_item_id": 4,
    "item_type": 7,
    "newbook_region": 0,
    "per_adult": 19,
    "per_animal": 22,
    "per_child": 20,
    "per_infant": 21,
    "qty": 23,
    "refundable": 31,
    "set_id": 33,
    "set_name": 34,
    "set_visible": 35,
    "tax_free": 24,
    "template_id": 3,
    "tenant": 1,
    "travel_agent_commission": 26
}

schema_attributes:

{
    "amount": "string",
    "calculation_type": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_other_tariffs": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_payment_plan": "string",
    "include_in_stay_cost": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "item_type": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "qty": "string",
    "refundable": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "template_id": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

schema_name_id: 2489
schema_scan_id: 6667408
updated: 2024-11-05 02:03:47

Version 4741642

created: 2024-11-05 01:48:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `item_type`  string , `calculation_type`  string , `description`  string , `daytype`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_other_tariffs`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `include_in_payment_plan`  string , `disburse_to_owners`  string , `refundable`  string , `discounts_apply`  string , `set_id`  string , `set_name`  string , `set_visible`  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_newbookbookings_rule_templates_inventory_items/2024-11-04/1730783636'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_rule_templates_inventory_items/2024-11-04/1730783636
id: 4741642
processed: 1

raw_data:

{
    "amount": 18,
    "calculation_type": 8,
    "daysofweek": 14,
    "daytype": 10,
    "description": 9,
    "disburse_to_owners": 30,
    "discounts_apply": 32,
    "gl_account_id": 6,
    "gl_category_id": 5,
    "guest_visible": 25,
    "id": 2,
    "ignore_other_tariffs": 15,
    "ignore_period_from": 16,
    "ignore_period_to": 17,
    "include_in_deposit": 28,
    "include_in_payment_plan": 29,
    "include_in_stay_cost": 27,
    "interval": 11,
    "interval_limit": 13,
    "interval_multiplier": 12,
    "inventory_item_id": 4,
    "item_type": 7,
    "newbook_region": 0,
    "per_adult": 19,
    "per_animal": 22,
    "per_child": 20,
    "per_infant": 21,
    "qty": 23,
    "refundable": 31,
    "set_id": 33,
    "set_name": 34,
    "set_visible": 35,
    "tax_free": 24,
    "template_id": 3,
    "tenant": 1,
    "travel_agent_commission": 26
}

schema_attributes:

{
    "amount": "string",
    "calculation_type": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_other_tariffs": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_payment_plan": "string",
    "include_in_stay_cost": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "item_type": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "qty": "string",
    "refundable": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "template_id": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

schema_name_id: 2489
schema_scan_id: 6666859
updated: 2024-11-05 01:49:11

Version 4740777

created: 2024-11-05 01:26:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `item_type`  string , `calculation_type`  string , `description`  string , `daytype`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_other_tariffs`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `include_in_payment_plan`  string , `disburse_to_owners`  string , `refundable`  string , `discounts_apply`  string , `set_id`  string , `set_name`  string , `set_visible`  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_newbookbookings_rule_templates_inventory_items/2024-11-04/1730783485'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_rule_templates_inventory_items/2024-11-04/1730783485
id: 4740777
processed: 1

raw_data:

{
    "amount": 18,
    "calculation_type": 8,
    "daysofweek": 14,
    "daytype": 10,
    "description": 9,
    "disburse_to_owners": 30,
    "discounts_apply": 32,
    "gl_account_id": 6,
    "gl_category_id": 5,
    "guest_visible": 25,
    "id": 2,
    "ignore_other_tariffs": 15,
    "ignore_period_from": 16,
    "ignore_period_to": 17,
    "include_in_deposit": 28,
    "include_in_payment_plan": 29,
    "include_in_stay_cost": 27,
    "interval": 11,
    "interval_limit": 13,
    "interval_multiplier": 12,
    "inventory_item_id": 4,
    "item_type": 7,
    "newbook_region": 0,
    "per_adult": 19,
    "per_animal": 22,
    "per_child": 20,
    "per_infant": 21,
    "qty": 23,
    "refundable": 31,
    "set_id": 33,
    "set_name": 34,
    "set_visible": 35,
    "tax_free": 24,
    "template_id": 3,
    "tenant": 1,
    "travel_agent_commission": 26
}

schema_attributes:

{
    "amount": "string",
    "calculation_type": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_other_tariffs": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_payment_plan": "string",
    "include_in_stay_cost": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "item_type": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "qty": "string",
    "refundable": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "template_id": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

schema_name_id: 2489
schema_scan_id: 6665994
updated: 2024-11-05 01:26:24

Version 4740098

created: 2024-11-05 01:08:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `item_type`  string , `calculation_type`  string , `description`  string , `daytype`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_other_tariffs`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `include_in_payment_plan`  string , `disburse_to_owners`  string , `refundable`  string , `discounts_apply`  string , `set_id`  string , `set_name`  string , `set_visible`  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_newbookbookings_rule_templates_inventory_items/2024-11-04/1730783267'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_rule_templates_inventory_items/2024-11-04/1730783267
id: 4740098
processed: 1

raw_data:

{
    "amount": 18,
    "calculation_type": 8,
    "daysofweek": 14,
    "daytype": 10,
    "description": 9,
    "disburse_to_owners": 30,
    "discounts_apply": 32,
    "gl_account_id": 6,
    "gl_category_id": 5,
    "guest_visible": 25,
    "id": 2,
    "ignore_other_tariffs": 15,
    "ignore_period_from": 16,
    "ignore_period_to": 17,
    "include_in_deposit": 28,
    "include_in_payment_plan": 29,
    "include_in_stay_cost": 27,
    "interval": 11,
    "interval_limit": 13,
    "interval_multiplier": 12,
    "inventory_item_id": 4,
    "item_type": 7,
    "newbook_region": 0,
    "per_adult": 19,
    "per_animal": 22,
    "per_child": 20,
    "per_infant": 21,
    "qty": 23,
    "refundable": 31,
    "set_id": 33,
    "set_name": 34,
    "set_visible": 35,
    "tax_free": 24,
    "template_id": 3,
    "tenant": 1,
    "travel_agent_commission": 26
}

schema_attributes:

{
    "amount": "string",
    "calculation_type": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_other_tariffs": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_payment_plan": "string",
    "include_in_stay_cost": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "item_type": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "qty": "string",
    "refundable": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "template_id": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

schema_name_id: 2489
schema_scan_id: 6665315
updated: 2024-11-05 01:08:31

Version 4739254

created: 2024-11-05 00:45:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `item_type`  string , `calculation_type`  string , `description`  string , `daytype`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_other_tariffs`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `include_in_payment_plan`  string , `disburse_to_owners`  string , `refundable`  string , `discounts_apply`  string , `set_id`  string , `set_name`  string , `set_visible`  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_newbookbookings_rule_templates_inventory_items/2024-11-04/1730782869'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_rule_templates_inventory_items/2024-11-04/1730782869
id: 4739254
processed: 1

raw_data:

{
    "amount": 18,
    "calculation_type": 8,
    "daysofweek": 14,
    "daytype": 10,
    "description": 9,
    "disburse_to_owners": 30,
    "discounts_apply": 32,
    "gl_account_id": 6,
    "gl_category_id": 5,
    "guest_visible": 25,
    "id": 2,
    "ignore_other_tariffs": 15,
    "ignore_period_from": 16,
    "ignore_period_to": 17,
    "include_in_deposit": 28,
    "include_in_payment_plan": 29,
    "include_in_stay_cost": 27,
    "interval": 11,
    "interval_limit": 13,
    "interval_multiplier": 12,
    "inventory_item_id": 4,
    "item_type": 7,
    "newbook_region": 0,
    "per_adult": 19,
    "per_animal": 22,
    "per_child": 20,
    "per_infant": 21,
    "qty": 23,
    "refundable": 31,
    "set_id": 33,
    "set_name": 34,
    "set_visible": 35,
    "tax_free": 24,
    "template_id": 3,
    "tenant": 1,
    "travel_agent_commission": 26
}

schema_attributes:

{
    "amount": "string",
    "calculation_type": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_other_tariffs": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_payment_plan": "string",
    "include_in_stay_cost": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "item_type": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "qty": "string",
    "refundable": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "template_id": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

schema_name_id: 2489
schema_scan_id: 6664469
updated: 2024-11-05 00:46:06

Version 4738704

created: 2024-11-05 00:31:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `item_type`  string , `calculation_type`  string , `description`  string , `daytype`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_other_tariffs`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `include_in_payment_plan`  string , `disburse_to_owners`  string , `refundable`  string , `discounts_apply`  string , `set_id`  string , `set_name`  string , `set_visible`  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_newbookbookings_rule_templates_inventory_items/2024-11-04/1730782777'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_rule_templates_inventory_items/2024-11-04/1730782777
id: 4738704
processed: 1

raw_data:

{
    "amount": 18,
    "calculation_type": 8,
    "daysofweek": 14,
    "daytype": 10,
    "description": 9,
    "disburse_to_owners": 30,
    "discounts_apply": 32,
    "gl_account_id": 6,
    "gl_category_id": 5,
    "guest_visible": 25,
    "id": 2,
    "ignore_other_tariffs": 15,
    "ignore_period_from": 16,
    "ignore_period_to": 17,
    "include_in_deposit": 28,
    "include_in_payment_plan": 29,
    "include_in_stay_cost": 27,
    "interval": 11,
    "interval_limit": 13,
    "interval_multiplier": 12,
    "inventory_item_id": 4,
    "item_type": 7,
    "newbook_region": 0,
    "per_adult": 19,
    "per_animal": 22,
    "per_child": 20,
    "per_infant": 21,
    "qty": 23,
    "refundable": 31,
    "set_id": 33,
    "set_name": 34,
    "set_visible": 35,
    "tax_free": 24,
    "template_id": 3,
    "tenant": 1,
    "travel_agent_commission": 26
}

schema_attributes:

{
    "amount": "string",
    "calculation_type": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_other_tariffs": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_payment_plan": "string",
    "include_in_stay_cost": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "item_type": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "qty": "string",
    "refundable": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "template_id": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

schema_name_id: 2489
schema_scan_id: 6663917
updated: 2024-11-05 00:31:37

Schema Scans: 15

Last at 2024-11-05 22:39:57

Scan 6674291

duration: 0:00:14.934927

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6674291

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_newbookbookings_rule_templates_inventory_items/2024-11-05/1730866385",
        "key": "raw/newbookdev_newbookbookings_rule_templates_inventory_items/2024-11-05/1730866385/bookings_rule_templates_inventory_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4687980676373008413,
        "service_name": "drive-thru",
        "span_id": 16159447474824697686,
        "trace_id": 9584224490163005397
    }
}

running: False
schema_name_id: 2489
start_time: 2024-11-05 22:39:57
success: True
trace_id: 9584224490163005397

Scan 6673850

duration: 0:00:14.875757

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6673850

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_newbookbookings_rule_templates_inventory_items/2024-11-05/1730866317",
        "key": "raw/newbookdev_newbookbookings_rule_templates_inventory_items/2024-11-05/1730866317/bookings_rule_templates_inventory_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15369235322966419127,
        "service_name": "drive-thru",
        "span_id": 7884642544857462487,
        "trace_id": 12026959617152884072
    }
}

running: False
schema_name_id: 2489
start_time: 2024-11-05 22:26:45
success: True
trace_id: 12026959617152884072

Scan 6673524

duration: 0:00:12.144531

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6673524

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_newbookbookings_rule_templates_inventory_items/2024-11-05/1730866240",
        "key": "raw/newbookdev_newbookbookings_rule_templates_inventory_items/2024-11-05/1730866240/bookings_rule_templates_inventory_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1342924450704531357,
        "service_name": "drive-thru",
        "span_id": 3132490550921116399,
        "trace_id": 1692865015588163235
    }
}

running: False
schema_name_id: 2489
start_time: 2024-11-05 22:18:13
success: True
trace_id: 1692865015588163235

Scan 6671864

duration: 0:00:12.445235

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6671864

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_newbookbookings_rule_templates_inventory_items/2024-11-04/1730785659",
        "key": "raw/newbookdev_newbookbookings_rule_templates_inventory_items/2024-11-04/1730785659/bookings_rule_templates_inventory_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8312311960600342162,
        "service_name": "drive-thru",
        "span_id": 2266072019134349138,
        "trace_id": 6475956577901676255
    }
}

running: False
schema_name_id: 2489
start_time: 2024-11-05 04:14:01
success: True
trace_id: 6475956577901676255

Scan 6671388

duration: 0:00:15.022105

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6671388

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_newbookbookings_rule_templates_inventory_items/2024-11-04/1730785088",
        "key": "raw/newbookdev_newbookbookings_rule_templates_inventory_items/2024-11-04/1730785088/bookings_rule_templates_inventory_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7852668664664184540,
        "service_name": "drive-thru",
        "span_id": 15176126445956072390,
        "trace_id": 2327435455884095215
    }
}

running: False
schema_name_id: 2489
start_time: 2024-11-05 03:51:36
success: True
trace_id: 2327435455884095215

Scan 6670453

duration: 0:00:12.099152

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6670453

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_newbookbookings_rule_templates_inventory_items/2024-11-04/1730784782",
        "key": "raw/newbookdev_newbookbookings_rule_templates_inventory_items/2024-11-04/1730784782/bookings_rule_templates_inventory_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6767295055717894577,
        "service_name": "drive-thru",
        "span_id": 12004203710770262632,
        "trace_id": 6504814309597731225
    }
}

running: False
schema_name_id: 2489
start_time: 2024-11-05 03:24:10
success: True
trace_id: 6504814309597731225

Scan 6669563

duration: 0:00:14.847402

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6669563

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_newbookbookings_rule_templates_inventory_items/2024-11-04/1730784179",
        "key": "raw/newbookdev_newbookbookings_rule_templates_inventory_items/2024-11-04/1730784179/bookings_rule_templates_inventory_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6142998262584778867,
        "service_name": "drive-thru",
        "span_id": 1874951785936263635,
        "trace_id": 118333893883811121
    }
}

running: False
schema_name_id: 2489
start_time: 2024-11-05 03:00:28
success: True
trace_id: 118333893883811121

Scan 6668992

duration: 0:00:12.274541

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6668992

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_newbookbookings_rule_templates_inventory_items/2024-11-04/1730784017",
        "key": "raw/newbookdev_newbookbookings_rule_templates_inventory_items/2024-11-04/1730784017/bookings_rule_templates_inventory_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1737354143028749222,
        "service_name": "drive-thru",
        "span_id": 18078795663373567020,
        "trace_id": 8190165500595160806
    }
}

running: False
schema_name_id: 2489
start_time: 2024-11-05 02:45:31
success: True
trace_id: 8190165500595160806

Scan 6668256

duration: 0:00:12.477515

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6668256

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_newbookbookings_rule_templates_inventory_items/2024-11-04/1730783871",
        "key": "raw/newbookdev_newbookbookings_rule_templates_inventory_items/2024-11-04/1730783871/bookings_rule_templates_inventory_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17386416163837503292,
        "service_name": "drive-thru",
        "span_id": 11833242280354384015,
        "trace_id": 12501277564618275288
    }
}

running: False
schema_name_id: 2489
start_time: 2024-11-05 02:26:01
success: True
trace_id: 12501277564618275288

Scan 6667408

duration: 0:00:14.698964

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6667408

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_newbookbookings_rule_templates_inventory_items/2024-11-04/1730783729",
        "key": "raw/newbookdev_newbookbookings_rule_templates_inventory_items/2024-11-04/1730783729/bookings_rule_templates_inventory_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3428095165763604609,
        "service_name": "drive-thru",
        "span_id": 11277895721603158585,
        "trace_id": 14077402390573044071
    }
}

running: False
schema_name_id: 2489
start_time: 2024-11-05 02:03:32
success: True
trace_id: 14077402390573044071

Scan 6666859

duration: 0:00:14.889809

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6666859

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_newbookbookings_rule_templates_inventory_items/2024-11-04/1730783636",
        "key": "raw/newbookdev_newbookbookings_rule_templates_inventory_items/2024-11-04/1730783636/bookings_rule_templates_inventory_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2464208212754535487,
        "service_name": "drive-thru",
        "span_id": 3506654617360385810,
        "trace_id": 3097798584373158303
    }
}

running: False
schema_name_id: 2489
start_time: 2024-11-05 01:48:56
success: True
trace_id: 3097798584373158303

Scan 6665994

duration: 0:00:12.128226

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6665994

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_newbookbookings_rule_templates_inventory_items/2024-11-04/1730783485",
        "key": "raw/newbookdev_newbookbookings_rule_templates_inventory_items/2024-11-04/1730783485/bookings_rule_templates_inventory_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1955387997219135143,
        "service_name": "drive-thru",
        "span_id": 1591096689192057183,
        "trace_id": 2247045273787655593
    }
}

running: False
schema_name_id: 2489
start_time: 2024-11-05 01:26:12
success: True
trace_id: 2247045273787655593

Scan 6665315

duration: 0:00:12.435426

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6665315

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_newbookbookings_rule_templates_inventory_items/2024-11-04/1730783267",
        "key": "raw/newbookdev_newbookbookings_rule_templates_inventory_items/2024-11-04/1730783267/bookings_rule_templates_inventory_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16297410005613181755,
        "service_name": "drive-thru",
        "span_id": 12464054141491816877,
        "trace_id": 14246538617621978115
    }
}

running: False
schema_name_id: 2489
start_time: 2024-11-05 01:08:19
success: True
trace_id: 14246538617621978115

Scan 6664469

duration: 0:00:14.662645

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6664469

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_newbookbookings_rule_templates_inventory_items/2024-11-04/1730782869",
        "key": "raw/newbookdev_newbookbookings_rule_templates_inventory_items/2024-11-04/1730782869/bookings_rule_templates_inventory_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17116998548288940198,
        "service_name": "drive-thru",
        "span_id": 12193282814625195434,
        "trace_id": 5460119420486956086
    }
}

running: False
schema_name_id: 2489
start_time: 2024-11-05 00:45:52
success: True
trace_id: 5460119420486956086

Scan 6663917

duration: 0:00:14.698655

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6663917

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_newbookbookings_rule_templates_inventory_items/2024-11-04/1730782777",
        "key": "raw/newbookdev_newbookbookings_rule_templates_inventory_items/2024-11-04/1730782777/bookings_rule_templates_inventory_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 789517397937010089,
        "service_name": "drive-thru",
        "span_id": 602908137186608749,
        "trace_id": 15716179751898089327
    }
}

running: False
schema_name_id: 2489
start_time: 2024-11-05 00:31:22
success: True
trace_id: 15716179751898089327

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "amount": "string",
    "calculation_type": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_other_tariffs": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_payment_plan": "string",
    "include_in_stay_cost": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "item_type": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "qty": "string",
    "refundable": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "template_id": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

created: 2024-11-05 22:39:58

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `item_type`  string , `calculation_type`  string , `description`  string , `daytype`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_other_tariffs`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `include_in_payment_plan`  string , `disburse_to_owners`  string , `refundable`  string , `discounts_apply`  string , `set_id`  string , `set_name`  string , `set_visible`  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_newbookbookings_rule_templates_inventory_items/2024-11-05/1730866385'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items"
}

Server:

hostname: schemamanager-5447774fc6-4w58v
name: schema_manager
process_start: 2026-04-02 21:43:44
sf_env: dev
version: 2427328685

Raw:

{
    "name": {
        "created": "2024-10-08 17:42:46",
        "disabled": false,
        "format": "raw",
        "id": 2489,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookbookings_rule_templates_inventory_items"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "amount": "string",
            "calculation_type": "string",
            "daysofweek": "string",
            "daytype": "string",
            "description": "string",
            "disburse_to_owners": "string",
            "discounts_apply": "string",
            "gl_account_id": "string",
            "gl_category_id": "string",
            "guest_visible": "string",
            "id": "string",
            "ignore_other_tariffs": "string",
            "ignore_period_from": "string",
            "ignore_period_to": "string",
            "include_in_deposit": "string",
            "include_in_payment_plan": "string",
            "include_in_stay_cost": "string",
            "interval": "string",
            "interval_limit": "string",
            "interval_multiplier": "string",
            "inventory_item_id": "string",
            "item_type": "string",
            "newbook_region": "string",
            "per_adult": "string",
            "per_animal": "string",
            "per_child": "string",
            "per_infant": "string",
            "qty": "string",
            "refundable": "string",
            "set_id": "string",
            "set_name": "string",
            "set_visible": "string",
            "tax_free": "string",
            "template_id": "string",
            "tenant": "string",
            "travel_agent_commission": "string"
        },
        "created": "2024-11-05 22:39:58",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `item_type`  string , `calculation_type`  string , `description`  string , `daytype`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_other_tariffs`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `include_in_payment_plan`  string , `disburse_to_owners`  string , `refundable`  string , `discounts_apply`  string , `set_id`  string , `set_name`  string , `set_visible`  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_newbookbookings_rule_templates_inventory_items/2024-11-05/1730866385'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_rule_templates_inventory_items"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}