Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories
  • created: 2024-10-08 17:38:58
  • disabled: False
  • format: raw
  • id: 2437
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_dev_drivethru",
    "table": "newbookdev_newbookaccommodation_categories"
}
  • type: drivethrucsv
Schema Versions: 15
    • created: 2024-11-05 22:30:44
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `short_description`  string , `description`  string , `website_url`  string , `display_order`  string , `preference_order`  string , `minimum_sites_online`  string , `minimum_sites_cm`  string , `online_bookings_future_days_minimum`  string , `online_bookings_future_days_maximum`  string , `cm_bookings_future_days_minimum`  string , `cm_bookings_future_days_maximum`  string , `bookings_split_after`  string , `bookings_split_count`  string , `bookings_split_length`  string , `cm_bookings_split_after`  string , `cm_bookings_split_count`  string , `cm_bookings_split_length`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `tax_free`  string , `system_template_receipts`  string , `system_template_invoices`  string , `system_template_clients_account_statement`  string , `system_template_receipts_trust`  string , `system_template_invoices_trust`  string , `system_template_clients_account_statement_trust`  string , `housekeeping`  string , `occupancy`  string , `allow_dirty_bookings`  string , `allow_same_day_backtoback`  string , `allow_same_day_access_card_unavailable`  string , `booking_action`  string , `instance_channel_manager_id`  string , `cm_roomcode`  string , `type_id`  string , `default_tariff_type`  string , `placeholder_image`  string , `engine_site_count`  string , `engine_min_nights`  string , `engine_max_nights`  string , `engine_base_price`  string , `engine_additional_adults`  string , `engine_additional_children`  string , `engine_additional_infants`  string , `engine_additional_animals`  string , `engine_included_combined`  string , `engine_included_adults`  string , `engine_included_children`  string , `engine_included_infants`  string , `engine_included_animals`  string , `engine_extras_combined`  string , `engine_use_equipment`  string , `virtual_tour_url`  string , `active`  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_newbookaccommodation_categories/2024-11-05/1730866342'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories/2024-11-05/1730866342
    • id: 4747966
    • processed: 1
    • raw_data: 
      {
    "active": 64,
    "allow_dirty_bookings": 39,
    "allow_same_day_access_card_unavailable": 41,
    "allow_same_day_backtoback": 40,
    "booking_action": 42,
    "bookings_split_after": 15,
    "bookings_split_count": 16,
    "bookings_split_length": 17,
    "cm_bookings_future_days_maximum": 14,
    "cm_bookings_future_days_minimum": 13,
    "cm_bookings_split_after": 18,
    "cm_bookings_split_count": 19,
    "cm_bookings_split_length": 20,
    "cm_roomcode": 44,
    "default_tariff_type": 46,
    "description": 5,
    "display_order": 7,
    "engine_additional_adults": 52,
    "engine_additional_animals": 55,
    "engine_additional_children": 53,
    "engine_additional_infants": 54,
    "engine_base_price": 51,
    "engine_extras_combined": 61,
    "engine_included_adults": 57,
    "engine_included_animals": 60,
    "engine_included_children": 58,
    "engine_included_combined": 56,
    "engine_included_infants": 59,
    "engine_max_nights": 50,
    "engine_min_nights": 49,
    "engine_site_count": 48,
    "engine_use_equipment": 62,
    "gl_account_id": 29,
    "gl_category_id": 28,
    "housekeeping": 37,
    "id": 2,
    "instance_channel_manager_id": 43,
    "inventory_item_id": 27,
    "max_adults": 21,
    "max_animals": 24,
    "max_children": 22,
    "max_combined": 26,
    "max_infants": 23,
    "min_combined": 25,
    "minimum_sites_cm": 10,
    "minimum_sites_online": 9,
    "name": 3,
    "newbook_region": 0,
    "occupancy": 38,
    "online_bookings_future_days_maximum": 12,
    "online_bookings_future_days_minimum": 11,
    "placeholder_image": 47,
    "preference_order": 8,
    "short_description": 4,
    "system_template_clients_account_statement": 33,
    "system_template_clients_account_statement_trust": 36,
    "system_template_invoices": 32,
    "system_template_invoices_trust": 35,
    "system_template_receipts": 31,
    "system_template_receipts_trust": 34,
    "tax_free": 30,
    "tenant": 1,
    "type_id": 45,
    "virtual_tour_url": 63,
    "website_url": 6
}
    • schema_attributes: 
      {
    "active": "string",
    "allow_dirty_bookings": "string",
    "allow_same_day_access_card_unavailable": "string",
    "allow_same_day_backtoback": "string",
    "booking_action": "string",
    "bookings_split_after": "string",
    "bookings_split_count": "string",
    "bookings_split_length": "string",
    "cm_bookings_future_days_maximum": "string",
    "cm_bookings_future_days_minimum": "string",
    "cm_bookings_split_after": "string",
    "cm_bookings_split_count": "string",
    "cm_bookings_split_length": "string",
    "cm_roomcode": "string",
    "default_tariff_type": "string",
    "description": "string",
    "display_order": "string",
    "engine_additional_adults": "string",
    "engine_additional_animals": "string",
    "engine_additional_children": "string",
    "engine_additional_infants": "string",
    "engine_base_price": "string",
    "engine_extras_combined": "string",
    "engine_included_adults": "string",
    "engine_included_animals": "string",
    "engine_included_children": "string",
    "engine_included_combined": "string",
    "engine_included_infants": "string",
    "engine_max_nights": "string",
    "engine_min_nights": "string",
    "engine_site_count": "string",
    "engine_use_equipment": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "housekeeping": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "inventory_item_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "min_combined": "string",
    "minimum_sites_cm": "string",
    "minimum_sites_online": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "online_bookings_future_days_maximum": "string",
    "online_bookings_future_days_minimum": "string",
    "placeholder_image": "string",
    "preference_order": "string",
    "short_description": "string",
    "system_template_clients_account_statement": "string",
    "system_template_clients_account_statement_trust": "string",
    "system_template_invoices": "string",
    "system_template_invoices_trust": "string",
    "system_template_receipts": "string",
    "system_template_receipts_trust": "string",
    "tax_free": "string",
    "tenant": "string",
    "type_id": "string",
    "virtual_tour_url": "string",
    "website_url": "string"
}
    • schema_name_id: 2437
    • schema_scan_id: 6673997
    • updated: 2024-11-05 22:30:57
    • created: 2024-11-05 22:21:19
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `short_description`  string , `description`  string , `website_url`  string , `display_order`  string , `preference_order`  string , `minimum_sites_online`  string , `minimum_sites_cm`  string , `online_bookings_future_days_minimum`  string , `online_bookings_future_days_maximum`  string , `cm_bookings_future_days_minimum`  string , `cm_bookings_future_days_maximum`  string , `bookings_split_after`  string , `bookings_split_count`  string , `bookings_split_length`  string , `cm_bookings_split_after`  string , `cm_bookings_split_count`  string , `cm_bookings_split_length`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `tax_free`  string , `system_template_receipts`  string , `system_template_invoices`  string , `system_template_clients_account_statement`  string , `system_template_receipts_trust`  string , `system_template_invoices_trust`  string , `system_template_clients_account_statement_trust`  string , `housekeeping`  string , `occupancy`  string , `allow_dirty_bookings`  string , `allow_same_day_backtoback`  string , `allow_same_day_access_card_unavailable`  string , `booking_action`  string , `instance_channel_manager_id`  string , `cm_roomcode`  string , `type_id`  string , `default_tariff_type`  string , `placeholder_image`  string , `engine_site_count`  string , `engine_min_nights`  string , `engine_max_nights`  string , `engine_base_price`  string , `engine_additional_adults`  string , `engine_additional_children`  string , `engine_additional_infants`  string , `engine_additional_animals`  string , `engine_included_combined`  string , `engine_included_adults`  string , `engine_included_children`  string , `engine_included_infants`  string , `engine_included_animals`  string , `engine_extras_combined`  string , `engine_use_equipment`  string , `virtual_tour_url`  string , `active`  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_newbookaccommodation_categories/2024-11-05/1730866280'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories/2024-11-05/1730866280
    • id: 4747609
    • processed: 1
    • raw_data: 
      {
    "active": 64,
    "allow_dirty_bookings": 39,
    "allow_same_day_access_card_unavailable": 41,
    "allow_same_day_backtoback": 40,
    "booking_action": 42,
    "bookings_split_after": 15,
    "bookings_split_count": 16,
    "bookings_split_length": 17,
    "cm_bookings_future_days_maximum": 14,
    "cm_bookings_future_days_minimum": 13,
    "cm_bookings_split_after": 18,
    "cm_bookings_split_count": 19,
    "cm_bookings_split_length": 20,
    "cm_roomcode": 44,
    "default_tariff_type": 46,
    "description": 5,
    "display_order": 7,
    "engine_additional_adults": 52,
    "engine_additional_animals": 55,
    "engine_additional_children": 53,
    "engine_additional_infants": 54,
    "engine_base_price": 51,
    "engine_extras_combined": 61,
    "engine_included_adults": 57,
    "engine_included_animals": 60,
    "engine_included_children": 58,
    "engine_included_combined": 56,
    "engine_included_infants": 59,
    "engine_max_nights": 50,
    "engine_min_nights": 49,
    "engine_site_count": 48,
    "engine_use_equipment": 62,
    "gl_account_id": 29,
    "gl_category_id": 28,
    "housekeeping": 37,
    "id": 2,
    "instance_channel_manager_id": 43,
    "inventory_item_id": 27,
    "max_adults": 21,
    "max_animals": 24,
    "max_children": 22,
    "max_combined": 26,
    "max_infants": 23,
    "min_combined": 25,
    "minimum_sites_cm": 10,
    "minimum_sites_online": 9,
    "name": 3,
    "newbook_region": 0,
    "occupancy": 38,
    "online_bookings_future_days_maximum": 12,
    "online_bookings_future_days_minimum": 11,
    "placeholder_image": 47,
    "preference_order": 8,
    "short_description": 4,
    "system_template_clients_account_statement": 33,
    "system_template_clients_account_statement_trust": 36,
    "system_template_invoices": 32,
    "system_template_invoices_trust": 35,
    "system_template_receipts": 31,
    "system_template_receipts_trust": 34,
    "tax_free": 30,
    "tenant": 1,
    "type_id": 45,
    "virtual_tour_url": 63,
    "website_url": 6
}
    • schema_attributes: 
      {
    "active": "string",
    "allow_dirty_bookings": "string",
    "allow_same_day_access_card_unavailable": "string",
    "allow_same_day_backtoback": "string",
    "booking_action": "string",
    "bookings_split_after": "string",
    "bookings_split_count": "string",
    "bookings_split_length": "string",
    "cm_bookings_future_days_maximum": "string",
    "cm_bookings_future_days_minimum": "string",
    "cm_bookings_split_after": "string",
    "cm_bookings_split_count": "string",
    "cm_bookings_split_length": "string",
    "cm_roomcode": "string",
    "default_tariff_type": "string",
    "description": "string",
    "display_order": "string",
    "engine_additional_adults": "string",
    "engine_additional_animals": "string",
    "engine_additional_children": "string",
    "engine_additional_infants": "string",
    "engine_base_price": "string",
    "engine_extras_combined": "string",
    "engine_included_adults": "string",
    "engine_included_animals": "string",
    "engine_included_children": "string",
    "engine_included_combined": "string",
    "engine_included_infants": "string",
    "engine_max_nights": "string",
    "engine_min_nights": "string",
    "engine_site_count": "string",
    "engine_use_equipment": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "housekeeping": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "inventory_item_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "min_combined": "string",
    "minimum_sites_cm": "string",
    "minimum_sites_online": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "online_bookings_future_days_maximum": "string",
    "online_bookings_future_days_minimum": "string",
    "placeholder_image": "string",
    "preference_order": "string",
    "short_description": "string",
    "system_template_clients_account_statement": "string",
    "system_template_clients_account_statement_trust": "string",
    "system_template_invoices": "string",
    "system_template_invoices_trust": "string",
    "system_template_receipts": "string",
    "system_template_receipts_trust": "string",
    "tax_free": "string",
    "tenant": "string",
    "type_id": "string",
    "virtual_tour_url": "string",
    "website_url": "string"
}
    • schema_name_id: 2437
    • schema_scan_id: 6673641
    • updated: 2024-11-05 22:21:33
    • created: 2024-11-05 22:11:19
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `short_description`  string , `description`  string , `website_url`  string , `display_order`  string , `preference_order`  string , `minimum_sites_online`  string , `minimum_sites_cm`  string , `online_bookings_future_days_minimum`  string , `online_bookings_future_days_maximum`  string , `cm_bookings_future_days_minimum`  string , `cm_bookings_future_days_maximum`  string , `bookings_split_after`  string , `bookings_split_count`  string , `bookings_split_length`  string , `cm_bookings_split_after`  string , `cm_bookings_split_count`  string , `cm_bookings_split_length`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `tax_free`  string , `system_template_receipts`  string , `system_template_invoices`  string , `system_template_clients_account_statement`  string , `system_template_receipts_trust`  string , `system_template_invoices_trust`  string , `system_template_clients_account_statement_trust`  string , `housekeeping`  string , `occupancy`  string , `allow_dirty_bookings`  string , `allow_same_day_backtoback`  string , `allow_same_day_access_card_unavailable`  string , `booking_action`  string , `instance_channel_manager_id`  string , `cm_roomcode`  string , `type_id`  string , `default_tariff_type`  string , `placeholder_image`  string , `engine_site_count`  string , `engine_min_nights`  string , `engine_max_nights`  string , `engine_base_price`  string , `engine_additional_adults`  string , `engine_additional_children`  string , `engine_additional_infants`  string , `engine_additional_animals`  string , `engine_included_combined`  string , `engine_included_adults`  string , `engine_included_children`  string , `engine_included_infants`  string , `engine_included_animals`  string , `engine_extras_combined`  string , `engine_use_equipment`  string , `virtual_tour_url`  string , `active`  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_newbookaccommodation_categories/2024-11-05/1730866222'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories/2024-11-05/1730866222
    • id: 4747337
    • processed: 1
    • raw_data: 
      {
    "active": 64,
    "allow_dirty_bookings": 39,
    "allow_same_day_access_card_unavailable": 41,
    "allow_same_day_backtoback": 40,
    "booking_action": 42,
    "bookings_split_after": 15,
    "bookings_split_count": 16,
    "bookings_split_length": 17,
    "cm_bookings_future_days_maximum": 14,
    "cm_bookings_future_days_minimum": 13,
    "cm_bookings_split_after": 18,
    "cm_bookings_split_count": 19,
    "cm_bookings_split_length": 20,
    "cm_roomcode": 44,
    "default_tariff_type": 46,
    "description": 5,
    "display_order": 7,
    "engine_additional_adults": 52,
    "engine_additional_animals": 55,
    "engine_additional_children": 53,
    "engine_additional_infants": 54,
    "engine_base_price": 51,
    "engine_extras_combined": 61,
    "engine_included_adults": 57,
    "engine_included_animals": 60,
    "engine_included_children": 58,
    "engine_included_combined": 56,
    "engine_included_infants": 59,
    "engine_max_nights": 50,
    "engine_min_nights": 49,
    "engine_site_count": 48,
    "engine_use_equipment": 62,
    "gl_account_id": 29,
    "gl_category_id": 28,
    "housekeeping": 37,
    "id": 2,
    "instance_channel_manager_id": 43,
    "inventory_item_id": 27,
    "max_adults": 21,
    "max_animals": 24,
    "max_children": 22,
    "max_combined": 26,
    "max_infants": 23,
    "min_combined": 25,
    "minimum_sites_cm": 10,
    "minimum_sites_online": 9,
    "name": 3,
    "newbook_region": 0,
    "occupancy": 38,
    "online_bookings_future_days_maximum": 12,
    "online_bookings_future_days_minimum": 11,
    "placeholder_image": 47,
    "preference_order": 8,
    "short_description": 4,
    "system_template_clients_account_statement": 33,
    "system_template_clients_account_statement_trust": 36,
    "system_template_invoices": 32,
    "system_template_invoices_trust": 35,
    "system_template_receipts": 31,
    "system_template_receipts_trust": 34,
    "tax_free": 30,
    "tenant": 1,
    "type_id": 45,
    "virtual_tour_url": 63,
    "website_url": 6
}
    • schema_attributes: 
      {
    "active": "string",
    "allow_dirty_bookings": "string",
    "allow_same_day_access_card_unavailable": "string",
    "allow_same_day_backtoback": "string",
    "booking_action": "string",
    "bookings_split_after": "string",
    "bookings_split_count": "string",
    "bookings_split_length": "string",
    "cm_bookings_future_days_maximum": "string",
    "cm_bookings_future_days_minimum": "string",
    "cm_bookings_split_after": "string",
    "cm_bookings_split_count": "string",
    "cm_bookings_split_length": "string",
    "cm_roomcode": "string",
    "default_tariff_type": "string",
    "description": "string",
    "display_order": "string",
    "engine_additional_adults": "string",
    "engine_additional_animals": "string",
    "engine_additional_children": "string",
    "engine_additional_infants": "string",
    "engine_base_price": "string",
    "engine_extras_combined": "string",
    "engine_included_adults": "string",
    "engine_included_animals": "string",
    "engine_included_children": "string",
    "engine_included_combined": "string",
    "engine_included_infants": "string",
    "engine_max_nights": "string",
    "engine_min_nights": "string",
    "engine_site_count": "string",
    "engine_use_equipment": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "housekeeping": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "inventory_item_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "min_combined": "string",
    "minimum_sites_cm": "string",
    "minimum_sites_online": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "online_bookings_future_days_maximum": "string",
    "online_bookings_future_days_minimum": "string",
    "placeholder_image": "string",
    "preference_order": "string",
    "short_description": "string",
    "system_template_clients_account_statement": "string",
    "system_template_clients_account_statement_trust": "string",
    "system_template_invoices": "string",
    "system_template_invoices_trust": "string",
    "system_template_receipts": "string",
    "system_template_receipts_trust": "string",
    "tax_free": "string",
    "tenant": "string",
    "type_id": "string",
    "virtual_tour_url": "string",
    "website_url": "string"
}
    • schema_name_id: 2437
    • schema_scan_id: 6673369
    • updated: 2024-11-05 22:11:33
    • created: 2024-11-05 04:08:20
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `short_description`  string , `description`  string , `website_url`  string , `display_order`  string , `preference_order`  string , `minimum_sites_online`  string , `minimum_sites_cm`  string , `online_bookings_future_days_minimum`  string , `online_bookings_future_days_maximum`  string , `cm_bookings_future_days_minimum`  string , `cm_bookings_future_days_maximum`  string , `bookings_split_after`  string , `bookings_split_count`  string , `bookings_split_length`  string , `cm_bookings_split_after`  string , `cm_bookings_split_count`  string , `cm_bookings_split_length`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `tax_free`  string , `system_template_receipts`  string , `system_template_invoices`  string , `system_template_clients_account_statement`  string , `system_template_receipts_trust`  string , `system_template_invoices_trust`  string , `system_template_clients_account_statement_trust`  string , `housekeeping`  string , `occupancy`  string , `allow_dirty_bookings`  string , `allow_same_day_backtoback`  string , `allow_same_day_access_card_unavailable`  string , `booking_action`  string , `instance_channel_manager_id`  string , `cm_roomcode`  string , `type_id`  string , `default_tariff_type`  string , `placeholder_image`  string , `engine_site_count`  string , `engine_min_nights`  string , `engine_max_nights`  string , `engine_base_price`  string , `engine_additional_adults`  string , `engine_additional_children`  string , `engine_additional_infants`  string , `engine_additional_animals`  string , `engine_included_combined`  string , `engine_included_adults`  string , `engine_included_children`  string , `engine_included_infants`  string , `engine_included_animals`  string , `engine_extras_combined`  string , `engine_use_equipment`  string , `virtual_tour_url`  string , `active`  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_newbookaccommodation_categories/2024-11-04/1730785635'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories/2024-11-04/1730785635
    • id: 4746538
    • processed: 1
    • raw_data: 
      {
    "active": 64,
    "allow_dirty_bookings": 39,
    "allow_same_day_access_card_unavailable": 41,
    "allow_same_day_backtoback": 40,
    "booking_action": 42,
    "bookings_split_after": 15,
    "bookings_split_count": 16,
    "bookings_split_length": 17,
    "cm_bookings_future_days_maximum": 14,
    "cm_bookings_future_days_minimum": 13,
    "cm_bookings_split_after": 18,
    "cm_bookings_split_count": 19,
    "cm_bookings_split_length": 20,
    "cm_roomcode": 44,
    "default_tariff_type": 46,
    "description": 5,
    "display_order": 7,
    "engine_additional_adults": 52,
    "engine_additional_animals": 55,
    "engine_additional_children": 53,
    "engine_additional_infants": 54,
    "engine_base_price": 51,
    "engine_extras_combined": 61,
    "engine_included_adults": 57,
    "engine_included_animals": 60,
    "engine_included_children": 58,
    "engine_included_combined": 56,
    "engine_included_infants": 59,
    "engine_max_nights": 50,
    "engine_min_nights": 49,
    "engine_site_count": 48,
    "engine_use_equipment": 62,
    "gl_account_id": 29,
    "gl_category_id": 28,
    "housekeeping": 37,
    "id": 2,
    "instance_channel_manager_id": 43,
    "inventory_item_id": 27,
    "max_adults": 21,
    "max_animals": 24,
    "max_children": 22,
    "max_combined": 26,
    "max_infants": 23,
    "min_combined": 25,
    "minimum_sites_cm": 10,
    "minimum_sites_online": 9,
    "name": 3,
    "newbook_region": 0,
    "occupancy": 38,
    "online_bookings_future_days_maximum": 12,
    "online_bookings_future_days_minimum": 11,
    "placeholder_image": 47,
    "preference_order": 8,
    "short_description": 4,
    "system_template_clients_account_statement": 33,
    "system_template_clients_account_statement_trust": 36,
    "system_template_invoices": 32,
    "system_template_invoices_trust": 35,
    "system_template_receipts": 31,
    "system_template_receipts_trust": 34,
    "tax_free": 30,
    "tenant": 1,
    "type_id": 45,
    "virtual_tour_url": 63,
    "website_url": 6
}
    • schema_attributes: 
      {
    "active": "string",
    "allow_dirty_bookings": "string",
    "allow_same_day_access_card_unavailable": "string",
    "allow_same_day_backtoback": "string",
    "booking_action": "string",
    "bookings_split_after": "string",
    "bookings_split_count": "string",
    "bookings_split_length": "string",
    "cm_bookings_future_days_maximum": "string",
    "cm_bookings_future_days_minimum": "string",
    "cm_bookings_split_after": "string",
    "cm_bookings_split_count": "string",
    "cm_bookings_split_length": "string",
    "cm_roomcode": "string",
    "default_tariff_type": "string",
    "description": "string",
    "display_order": "string",
    "engine_additional_adults": "string",
    "engine_additional_animals": "string",
    "engine_additional_children": "string",
    "engine_additional_infants": "string",
    "engine_base_price": "string",
    "engine_extras_combined": "string",
    "engine_included_adults": "string",
    "engine_included_animals": "string",
    "engine_included_children": "string",
    "engine_included_combined": "string",
    "engine_included_infants": "string",
    "engine_max_nights": "string",
    "engine_min_nights": "string",
    "engine_site_count": "string",
    "engine_use_equipment": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "housekeeping": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "inventory_item_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "min_combined": "string",
    "minimum_sites_cm": "string",
    "minimum_sites_online": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "online_bookings_future_days_maximum": "string",
    "online_bookings_future_days_minimum": "string",
    "placeholder_image": "string",
    "preference_order": "string",
    "short_description": "string",
    "system_template_clients_account_statement": "string",
    "system_template_clients_account_statement_trust": "string",
    "system_template_invoices": "string",
    "system_template_invoices_trust": "string",
    "system_template_receipts": "string",
    "system_template_receipts_trust": "string",
    "tax_free": "string",
    "tenant": "string",
    "type_id": "string",
    "virtual_tour_url": "string",
    "website_url": "string"
}
    • schema_name_id: 2437
    • schema_scan_id: 6671761
    • updated: 2024-11-05 04:08:34
    • created: 2024-11-05 03:38:05
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `short_description`  string , `description`  string , `website_url`  string , `display_order`  string , `preference_order`  string , `minimum_sites_online`  string , `minimum_sites_cm`  string , `online_bookings_future_days_minimum`  string , `online_bookings_future_days_maximum`  string , `cm_bookings_future_days_minimum`  string , `cm_bookings_future_days_maximum`  string , `bookings_split_after`  string , `bookings_split_count`  string , `bookings_split_length`  string , `cm_bookings_split_after`  string , `cm_bookings_split_count`  string , `cm_bookings_split_length`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `tax_free`  string , `system_template_receipts`  string , `system_template_invoices`  string , `system_template_clients_account_statement`  string , `system_template_receipts_trust`  string , `system_template_invoices_trust`  string , `system_template_clients_account_statement_trust`  string , `housekeeping`  string , `occupancy`  string , `allow_dirty_bookings`  string , `allow_same_day_backtoback`  string , `allow_same_day_access_card_unavailable`  string , `booking_action`  string , `instance_channel_manager_id`  string , `cm_roomcode`  string , `type_id`  string , `default_tariff_type`  string , `placeholder_image`  string , `engine_site_count`  string , `engine_min_nights`  string , `engine_max_nights`  string , `engine_base_price`  string , `engine_additional_adults`  string , `engine_additional_children`  string , `engine_additional_infants`  string , `engine_additional_animals`  string , `engine_included_combined`  string , `engine_included_adults`  string , `engine_included_children`  string , `engine_included_infants`  string , `engine_included_animals`  string , `engine_extras_combined`  string , `engine_use_equipment`  string , `virtual_tour_url`  string , `active`  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_newbookaccommodation_categories/2024-11-04/1730785074'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories/2024-11-04/1730785074
    • id: 4745761
    • processed: 1
    • raw_data: 
      {
    "active": 64,
    "allow_dirty_bookings": 39,
    "allow_same_day_access_card_unavailable": 41,
    "allow_same_day_backtoback": 40,
    "booking_action": 42,
    "bookings_split_after": 15,
    "bookings_split_count": 16,
    "bookings_split_length": 17,
    "cm_bookings_future_days_maximum": 14,
    "cm_bookings_future_days_minimum": 13,
    "cm_bookings_split_after": 18,
    "cm_bookings_split_count": 19,
    "cm_bookings_split_length": 20,
    "cm_roomcode": 44,
    "default_tariff_type": 46,
    "description": 5,
    "display_order": 7,
    "engine_additional_adults": 52,
    "engine_additional_animals": 55,
    "engine_additional_children": 53,
    "engine_additional_infants": 54,
    "engine_base_price": 51,
    "engine_extras_combined": 61,
    "engine_included_adults": 57,
    "engine_included_animals": 60,
    "engine_included_children": 58,
    "engine_included_combined": 56,
    "engine_included_infants": 59,
    "engine_max_nights": 50,
    "engine_min_nights": 49,
    "engine_site_count": 48,
    "engine_use_equipment": 62,
    "gl_account_id": 29,
    "gl_category_id": 28,
    "housekeeping": 37,
    "id": 2,
    "instance_channel_manager_id": 43,
    "inventory_item_id": 27,
    "max_adults": 21,
    "max_animals": 24,
    "max_children": 22,
    "max_combined": 26,
    "max_infants": 23,
    "min_combined": 25,
    "minimum_sites_cm": 10,
    "minimum_sites_online": 9,
    "name": 3,
    "newbook_region": 0,
    "occupancy": 38,
    "online_bookings_future_days_maximum": 12,
    "online_bookings_future_days_minimum": 11,
    "placeholder_image": 47,
    "preference_order": 8,
    "short_description": 4,
    "system_template_clients_account_statement": 33,
    "system_template_clients_account_statement_trust": 36,
    "system_template_invoices": 32,
    "system_template_invoices_trust": 35,
    "system_template_receipts": 31,
    "system_template_receipts_trust": 34,
    "tax_free": 30,
    "tenant": 1,
    "type_id": 45,
    "virtual_tour_url": 63,
    "website_url": 6
}
    • schema_attributes: 
      {
    "active": "string",
    "allow_dirty_bookings": "string",
    "allow_same_day_access_card_unavailable": "string",
    "allow_same_day_backtoback": "string",
    "booking_action": "string",
    "bookings_split_after": "string",
    "bookings_split_count": "string",
    "bookings_split_length": "string",
    "cm_bookings_future_days_maximum": "string",
    "cm_bookings_future_days_minimum": "string",
    "cm_bookings_split_after": "string",
    "cm_bookings_split_count": "string",
    "cm_bookings_split_length": "string",
    "cm_roomcode": "string",
    "default_tariff_type": "string",
    "description": "string",
    "display_order": "string",
    "engine_additional_adults": "string",
    "engine_additional_animals": "string",
    "engine_additional_children": "string",
    "engine_additional_infants": "string",
    "engine_base_price": "string",
    "engine_extras_combined": "string",
    "engine_included_adults": "string",
    "engine_included_animals": "string",
    "engine_included_children": "string",
    "engine_included_combined": "string",
    "engine_included_infants": "string",
    "engine_max_nights": "string",
    "engine_min_nights": "string",
    "engine_site_count": "string",
    "engine_use_equipment": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "housekeeping": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "inventory_item_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "min_combined": "string",
    "minimum_sites_cm": "string",
    "minimum_sites_online": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "online_bookings_future_days_maximum": "string",
    "online_bookings_future_days_minimum": "string",
    "placeholder_image": "string",
    "preference_order": "string",
    "short_description": "string",
    "system_template_clients_account_statement": "string",
    "system_template_clients_account_statement_trust": "string",
    "system_template_invoices": "string",
    "system_template_invoices_trust": "string",
    "system_template_receipts": "string",
    "system_template_receipts_trust": "string",
    "tax_free": "string",
    "tenant": "string",
    "type_id": "string",
    "virtual_tour_url": "string",
    "website_url": "string"
}
    • schema_name_id: 2437
    • schema_scan_id: 6670976
    • updated: 2024-11-05 03:38:16
    • created: 2024-11-05 03:34:25
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `short_description`  string , `description`  string , `website_url`  string , `display_order`  string , `preference_order`  string , `minimum_sites_online`  string , `minimum_sites_cm`  string , `online_bookings_future_days_minimum`  string , `online_bookings_future_days_maximum`  string , `cm_bookings_future_days_minimum`  string , `cm_bookings_future_days_maximum`  string , `bookings_split_after`  string , `bookings_split_count`  string , `bookings_split_length`  string , `cm_bookings_split_after`  string , `cm_bookings_split_count`  string , `cm_bookings_split_length`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `tax_free`  string , `system_template_receipts`  string , `system_template_invoices`  string , `system_template_clients_account_statement`  string , `system_template_receipts_trust`  string , `system_template_invoices_trust`  string , `system_template_clients_account_statement_trust`  string , `housekeeping`  string , `occupancy`  string , `allow_dirty_bookings`  string , `allow_same_day_backtoback`  string , `allow_same_day_access_card_unavailable`  string , `booking_action`  string , `instance_channel_manager_id`  string , `cm_roomcode`  string , `type_id`  string , `default_tariff_type`  string , `placeholder_image`  string , `engine_site_count`  string , `engine_min_nights`  string , `engine_max_nights`  string , `engine_base_price`  string , `engine_additional_adults`  string , `engine_additional_children`  string , `engine_additional_infants`  string , `engine_additional_animals`  string , `engine_included_combined`  string , `engine_included_adults`  string , `engine_included_children`  string , `engine_included_infants`  string , `engine_included_animals`  string , `engine_extras_combined`  string , `engine_use_equipment`  string , `virtual_tour_url`  string , `active`  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_newbookaccommodation_categories/2024-11-04/1730784770'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories/2024-11-04/1730784770
    • id: 4745627
    • processed: 1
    • raw_data: 
      {
    "active": 64,
    "allow_dirty_bookings": 39,
    "allow_same_day_access_card_unavailable": 41,
    "allow_same_day_backtoback": 40,
    "booking_action": 42,
    "bookings_split_after": 15,
    "bookings_split_count": 16,
    "bookings_split_length": 17,
    "cm_bookings_future_days_maximum": 14,
    "cm_bookings_future_days_minimum": 13,
    "cm_bookings_split_after": 18,
    "cm_bookings_split_count": 19,
    "cm_bookings_split_length": 20,
    "cm_roomcode": 44,
    "default_tariff_type": 46,
    "description": 5,
    "display_order": 7,
    "engine_additional_adults": 52,
    "engine_additional_animals": 55,
    "engine_additional_children": 53,
    "engine_additional_infants": 54,
    "engine_base_price": 51,
    "engine_extras_combined": 61,
    "engine_included_adults": 57,
    "engine_included_animals": 60,
    "engine_included_children": 58,
    "engine_included_combined": 56,
    "engine_included_infants": 59,
    "engine_max_nights": 50,
    "engine_min_nights": 49,
    "engine_site_count": 48,
    "engine_use_equipment": 62,
    "gl_account_id": 29,
    "gl_category_id": 28,
    "housekeeping": 37,
    "id": 2,
    "instance_channel_manager_id": 43,
    "inventory_item_id": 27,
    "max_adults": 21,
    "max_animals": 24,
    "max_children": 22,
    "max_combined": 26,
    "max_infants": 23,
    "min_combined": 25,
    "minimum_sites_cm": 10,
    "minimum_sites_online": 9,
    "name": 3,
    "newbook_region": 0,
    "occupancy": 38,
    "online_bookings_future_days_maximum": 12,
    "online_bookings_future_days_minimum": 11,
    "placeholder_image": 47,
    "preference_order": 8,
    "short_description": 4,
    "system_template_clients_account_statement": 33,
    "system_template_clients_account_statement_trust": 36,
    "system_template_invoices": 32,
    "system_template_invoices_trust": 35,
    "system_template_receipts": 31,
    "system_template_receipts_trust": 34,
    "tax_free": 30,
    "tenant": 1,
    "type_id": 45,
    "virtual_tour_url": 63,
    "website_url": 6
}
    • schema_attributes: 
      {
    "active": "string",
    "allow_dirty_bookings": "string",
    "allow_same_day_access_card_unavailable": "string",
    "allow_same_day_backtoback": "string",
    "booking_action": "string",
    "bookings_split_after": "string",
    "bookings_split_count": "string",
    "bookings_split_length": "string",
    "cm_bookings_future_days_maximum": "string",
    "cm_bookings_future_days_minimum": "string",
    "cm_bookings_split_after": "string",
    "cm_bookings_split_count": "string",
    "cm_bookings_split_length": "string",
    "cm_roomcode": "string",
    "default_tariff_type": "string",
    "description": "string",
    "display_order": "string",
    "engine_additional_adults": "string",
    "engine_additional_animals": "string",
    "engine_additional_children": "string",
    "engine_additional_infants": "string",
    "engine_base_price": "string",
    "engine_extras_combined": "string",
    "engine_included_adults": "string",
    "engine_included_animals": "string",
    "engine_included_children": "string",
    "engine_included_combined": "string",
    "engine_included_infants": "string",
    "engine_max_nights": "string",
    "engine_min_nights": "string",
    "engine_site_count": "string",
    "engine_use_equipment": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "housekeeping": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "inventory_item_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "min_combined": "string",
    "minimum_sites_cm": "string",
    "minimum_sites_online": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "online_bookings_future_days_maximum": "string",
    "online_bookings_future_days_minimum": "string",
    "placeholder_image": "string",
    "preference_order": "string",
    "short_description": "string",
    "system_template_clients_account_statement": "string",
    "system_template_clients_account_statement_trust": "string",
    "system_template_invoices": "string",
    "system_template_invoices_trust": "string",
    "system_template_receipts": "string",
    "system_template_receipts_trust": "string",
    "tax_free": "string",
    "tenant": "string",
    "type_id": "string",
    "virtual_tour_url": "string",
    "website_url": "string"
}
    • schema_name_id: 2437
    • schema_scan_id: 6670842
    • updated: 2024-11-05 03:34:36
    • created: 2024-11-05 02:57:51
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `short_description`  string , `description`  string , `website_url`  string , `display_order`  string , `preference_order`  string , `minimum_sites_online`  string , `minimum_sites_cm`  string , `online_bookings_future_days_minimum`  string , `online_bookings_future_days_maximum`  string , `cm_bookings_future_days_minimum`  string , `cm_bookings_future_days_maximum`  string , `bookings_split_after`  string , `bookings_split_count`  string , `bookings_split_length`  string , `cm_bookings_split_after`  string , `cm_bookings_split_count`  string , `cm_bookings_split_length`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `tax_free`  string , `system_template_receipts`  string , `system_template_invoices`  string , `system_template_clients_account_statement`  string , `system_template_receipts_trust`  string , `system_template_invoices_trust`  string , `system_template_clients_account_statement_trust`  string , `housekeeping`  string , `occupancy`  string , `allow_dirty_bookings`  string , `allow_same_day_backtoback`  string , `allow_same_day_access_card_unavailable`  string , `booking_action`  string , `instance_channel_manager_id`  string , `cm_roomcode`  string , `type_id`  string , `default_tariff_type`  string , `placeholder_image`  string , `engine_site_count`  string , `engine_min_nights`  string , `engine_max_nights`  string , `engine_base_price`  string , `engine_additional_adults`  string , `engine_additional_children`  string , `engine_additional_infants`  string , `engine_additional_animals`  string , `engine_included_combined`  string , `engine_included_adults`  string , `engine_included_children`  string , `engine_included_infants`  string , `engine_included_animals`  string , `engine_extras_combined`  string , `engine_use_equipment`  string , `virtual_tour_url`  string , `active`  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_newbookaccommodation_categories/2024-11-04/1730784165'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories/2024-11-04/1730784165
    • id: 4744248
    • processed: 1
    • raw_data: 
      {
    "active": 64,
    "allow_dirty_bookings": 39,
    "allow_same_day_access_card_unavailable": 41,
    "allow_same_day_backtoback": 40,
    "booking_action": 42,
    "bookings_split_after": 15,
    "bookings_split_count": 16,
    "bookings_split_length": 17,
    "cm_bookings_future_days_maximum": 14,
    "cm_bookings_future_days_minimum": 13,
    "cm_bookings_split_after": 18,
    "cm_bookings_split_count": 19,
    "cm_bookings_split_length": 20,
    "cm_roomcode": 44,
    "default_tariff_type": 46,
    "description": 5,
    "display_order": 7,
    "engine_additional_adults": 52,
    "engine_additional_animals": 55,
    "engine_additional_children": 53,
    "engine_additional_infants": 54,
    "engine_base_price": 51,
    "engine_extras_combined": 61,
    "engine_included_adults": 57,
    "engine_included_animals": 60,
    "engine_included_children": 58,
    "engine_included_combined": 56,
    "engine_included_infants": 59,
    "engine_max_nights": 50,
    "engine_min_nights": 49,
    "engine_site_count": 48,
    "engine_use_equipment": 62,
    "gl_account_id": 29,
    "gl_category_id": 28,
    "housekeeping": 37,
    "id": 2,
    "instance_channel_manager_id": 43,
    "inventory_item_id": 27,
    "max_adults": 21,
    "max_animals": 24,
    "max_children": 22,
    "max_combined": 26,
    "max_infants": 23,
    "min_combined": 25,
    "minimum_sites_cm": 10,
    "minimum_sites_online": 9,
    "name": 3,
    "newbook_region": 0,
    "occupancy": 38,
    "online_bookings_future_days_maximum": 12,
    "online_bookings_future_days_minimum": 11,
    "placeholder_image": 47,
    "preference_order": 8,
    "short_description": 4,
    "system_template_clients_account_statement": 33,
    "system_template_clients_account_statement_trust": 36,
    "system_template_invoices": 32,
    "system_template_invoices_trust": 35,
    "system_template_receipts": 31,
    "system_template_receipts_trust": 34,
    "tax_free": 30,
    "tenant": 1,
    "type_id": 45,
    "virtual_tour_url": 63,
    "website_url": 6
}
    • schema_attributes: 
      {
    "active": "string",
    "allow_dirty_bookings": "string",
    "allow_same_day_access_card_unavailable": "string",
    "allow_same_day_backtoback": "string",
    "booking_action": "string",
    "bookings_split_after": "string",
    "bookings_split_count": "string",
    "bookings_split_length": "string",
    "cm_bookings_future_days_maximum": "string",
    "cm_bookings_future_days_minimum": "string",
    "cm_bookings_split_after": "string",
    "cm_bookings_split_count": "string",
    "cm_bookings_split_length": "string",
    "cm_roomcode": "string",
    "default_tariff_type": "string",
    "description": "string",
    "display_order": "string",
    "engine_additional_adults": "string",
    "engine_additional_animals": "string",
    "engine_additional_children": "string",
    "engine_additional_infants": "string",
    "engine_base_price": "string",
    "engine_extras_combined": "string",
    "engine_included_adults": "string",
    "engine_included_animals": "string",
    "engine_included_children": "string",
    "engine_included_combined": "string",
    "engine_included_infants": "string",
    "engine_max_nights": "string",
    "engine_min_nights": "string",
    "engine_site_count": "string",
    "engine_use_equipment": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "housekeeping": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "inventory_item_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "min_combined": "string",
    "minimum_sites_cm": "string",
    "minimum_sites_online": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "online_bookings_future_days_maximum": "string",
    "online_bookings_future_days_minimum": "string",
    "placeholder_image": "string",
    "preference_order": "string",
    "short_description": "string",
    "system_template_clients_account_statement": "string",
    "system_template_clients_account_statement_trust": "string",
    "system_template_invoices": "string",
    "system_template_invoices_trust": "string",
    "system_template_receipts": "string",
    "system_template_receipts_trust": "string",
    "tax_free": "string",
    "tenant": "string",
    "type_id": "string",
    "virtual_tour_url": "string",
    "website_url": "string"
}
    • schema_name_id: 2437
    • schema_scan_id: 6669464
    • updated: 2024-11-05 02:58:04
    • created: 2024-11-05 02:41:08
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `short_description`  string , `description`  string , `website_url`  string , `display_order`  string , `preference_order`  string , `minimum_sites_online`  string , `minimum_sites_cm`  string , `online_bookings_future_days_minimum`  string , `online_bookings_future_days_maximum`  string , `cm_bookings_future_days_minimum`  string , `cm_bookings_future_days_maximum`  string , `bookings_split_after`  string , `bookings_split_count`  string , `bookings_split_length`  string , `cm_bookings_split_after`  string , `cm_bookings_split_count`  string , `cm_bookings_split_length`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `tax_free`  string , `system_template_receipts`  string , `system_template_invoices`  string , `system_template_clients_account_statement`  string , `system_template_receipts_trust`  string , `system_template_invoices_trust`  string , `system_template_clients_account_statement_trust`  string , `housekeeping`  string , `occupancy`  string , `allow_dirty_bookings`  string , `allow_same_day_backtoback`  string , `allow_same_day_access_card_unavailable`  string , `booking_action`  string , `instance_channel_manager_id`  string , `cm_roomcode`  string , `type_id`  string , `default_tariff_type`  string , `placeholder_image`  string , `engine_site_count`  string , `engine_min_nights`  string , `engine_max_nights`  string , `engine_base_price`  string , `engine_additional_adults`  string , `engine_additional_children`  string , `engine_additional_infants`  string , `engine_additional_animals`  string , `engine_included_combined`  string , `engine_included_adults`  string , `engine_included_children`  string , `engine_included_infants`  string , `engine_included_animals`  string , `engine_extras_combined`  string , `engine_use_equipment`  string , `virtual_tour_url`  string , `active`  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_newbookaccommodation_categories/2024-11-04/1730784003'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories/2024-11-04/1730784003
    • id: 4743609
    • processed: 1
    • raw_data: 
      {
    "active": 64,
    "allow_dirty_bookings": 39,
    "allow_same_day_access_card_unavailable": 41,
    "allow_same_day_backtoback": 40,
    "booking_action": 42,
    "bookings_split_after": 15,
    "bookings_split_count": 16,
    "bookings_split_length": 17,
    "cm_bookings_future_days_maximum": 14,
    "cm_bookings_future_days_minimum": 13,
    "cm_bookings_split_after": 18,
    "cm_bookings_split_count": 19,
    "cm_bookings_split_length": 20,
    "cm_roomcode": 44,
    "default_tariff_type": 46,
    "description": 5,
    "display_order": 7,
    "engine_additional_adults": 52,
    "engine_additional_animals": 55,
    "engine_additional_children": 53,
    "engine_additional_infants": 54,
    "engine_base_price": 51,
    "engine_extras_combined": 61,
    "engine_included_adults": 57,
    "engine_included_animals": 60,
    "engine_included_children": 58,
    "engine_included_combined": 56,
    "engine_included_infants": 59,
    "engine_max_nights": 50,
    "engine_min_nights": 49,
    "engine_site_count": 48,
    "engine_use_equipment": 62,
    "gl_account_id": 29,
    "gl_category_id": 28,
    "housekeeping": 37,
    "id": 2,
    "instance_channel_manager_id": 43,
    "inventory_item_id": 27,
    "max_adults": 21,
    "max_animals": 24,
    "max_children": 22,
    "max_combined": 26,
    "max_infants": 23,
    "min_combined": 25,
    "minimum_sites_cm": 10,
    "minimum_sites_online": 9,
    "name": 3,
    "newbook_region": 0,
    "occupancy": 38,
    "online_bookings_future_days_maximum": 12,
    "online_bookings_future_days_minimum": 11,
    "placeholder_image": 47,
    "preference_order": 8,
    "short_description": 4,
    "system_template_clients_account_statement": 33,
    "system_template_clients_account_statement_trust": 36,
    "system_template_invoices": 32,
    "system_template_invoices_trust": 35,
    "system_template_receipts": 31,
    "system_template_receipts_trust": 34,
    "tax_free": 30,
    "tenant": 1,
    "type_id": 45,
    "virtual_tour_url": 63,
    "website_url": 6
}
    • schema_attributes: 
      {
    "active": "string",
    "allow_dirty_bookings": "string",
    "allow_same_day_access_card_unavailable": "string",
    "allow_same_day_backtoback": "string",
    "booking_action": "string",
    "bookings_split_after": "string",
    "bookings_split_count": "string",
    "bookings_split_length": "string",
    "cm_bookings_future_days_maximum": "string",
    "cm_bookings_future_days_minimum": "string",
    "cm_bookings_split_after": "string",
    "cm_bookings_split_count": "string",
    "cm_bookings_split_length": "string",
    "cm_roomcode": "string",
    "default_tariff_type": "string",
    "description": "string",
    "display_order": "string",
    "engine_additional_adults": "string",
    "engine_additional_animals": "string",
    "engine_additional_children": "string",
    "engine_additional_infants": "string",
    "engine_base_price": "string",
    "engine_extras_combined": "string",
    "engine_included_adults": "string",
    "engine_included_animals": "string",
    "engine_included_children": "string",
    "engine_included_combined": "string",
    "engine_included_infants": "string",
    "engine_max_nights": "string",
    "engine_min_nights": "string",
    "engine_site_count": "string",
    "engine_use_equipment": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "housekeeping": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "inventory_item_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "min_combined": "string",
    "minimum_sites_cm": "string",
    "minimum_sites_online": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "online_bookings_future_days_maximum": "string",
    "online_bookings_future_days_minimum": "string",
    "placeholder_image": "string",
    "preference_order": "string",
    "short_description": "string",
    "system_template_clients_account_statement": "string",
    "system_template_clients_account_statement_trust": "string",
    "system_template_invoices": "string",
    "system_template_invoices_trust": "string",
    "system_template_receipts": "string",
    "system_template_receipts_trust": "string",
    "tax_free": "string",
    "tenant": "string",
    "type_id": "string",
    "virtual_tour_url": "string",
    "website_url": "string"
}
    • schema_name_id: 2437
    • schema_scan_id: 6668824
    • updated: 2024-11-05 02:41:19
    • created: 2024-11-05 02:11:38
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `short_description`  string , `description`  string , `website_url`  string , `display_order`  string , `preference_order`  string , `minimum_sites_online`  string , `minimum_sites_cm`  string , `online_bookings_future_days_minimum`  string , `online_bookings_future_days_maximum`  string , `cm_bookings_future_days_minimum`  string , `cm_bookings_future_days_maximum`  string , `bookings_split_after`  string , `bookings_split_count`  string , `bookings_split_length`  string , `cm_bookings_split_after`  string , `cm_bookings_split_count`  string , `cm_bookings_split_length`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `tax_free`  string , `system_template_receipts`  string , `system_template_invoices`  string , `system_template_clients_account_statement`  string , `system_template_receipts_trust`  string , `system_template_invoices_trust`  string , `system_template_clients_account_statement_trust`  string , `housekeeping`  string , `occupancy`  string , `allow_dirty_bookings`  string , `allow_same_day_backtoback`  string , `allow_same_day_access_card_unavailable`  string , `booking_action`  string , `instance_channel_manager_id`  string , `cm_roomcode`  string , `type_id`  string , `default_tariff_type`  string , `placeholder_image`  string , `engine_site_count`  string , `engine_min_nights`  string , `engine_max_nights`  string , `engine_base_price`  string , `engine_additional_adults`  string , `engine_additional_children`  string , `engine_additional_infants`  string , `engine_additional_animals`  string , `engine_included_combined`  string , `engine_included_adults`  string , `engine_included_children`  string , `engine_included_infants`  string , `engine_included_animals`  string , `engine_extras_combined`  string , `engine_use_equipment`  string , `virtual_tour_url`  string , `active`  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_newbookaccommodation_categories/2024-11-04/1730783860'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories/2024-11-04/1730783860
    • id: 4742493
    • processed: 1
    • raw_data: 
      {
    "active": 64,
    "allow_dirty_bookings": 39,
    "allow_same_day_access_card_unavailable": 41,
    "allow_same_day_backtoback": 40,
    "booking_action": 42,
    "bookings_split_after": 15,
    "bookings_split_count": 16,
    "bookings_split_length": 17,
    "cm_bookings_future_days_maximum": 14,
    "cm_bookings_future_days_minimum": 13,
    "cm_bookings_split_after": 18,
    "cm_bookings_split_count": 19,
    "cm_bookings_split_length": 20,
    "cm_roomcode": 44,
    "default_tariff_type": 46,
    "description": 5,
    "display_order": 7,
    "engine_additional_adults": 52,
    "engine_additional_animals": 55,
    "engine_additional_children": 53,
    "engine_additional_infants": 54,
    "engine_base_price": 51,
    "engine_extras_combined": 61,
    "engine_included_adults": 57,
    "engine_included_animals": 60,
    "engine_included_children": 58,
    "engine_included_combined": 56,
    "engine_included_infants": 59,
    "engine_max_nights": 50,
    "engine_min_nights": 49,
    "engine_site_count": 48,
    "engine_use_equipment": 62,
    "gl_account_id": 29,
    "gl_category_id": 28,
    "housekeeping": 37,
    "id": 2,
    "instance_channel_manager_id": 43,
    "inventory_item_id": 27,
    "max_adults": 21,
    "max_animals": 24,
    "max_children": 22,
    "max_combined": 26,
    "max_infants": 23,
    "min_combined": 25,
    "minimum_sites_cm": 10,
    "minimum_sites_online": 9,
    "name": 3,
    "newbook_region": 0,
    "occupancy": 38,
    "online_bookings_future_days_maximum": 12,
    "online_bookings_future_days_minimum": 11,
    "placeholder_image": 47,
    "preference_order": 8,
    "short_description": 4,
    "system_template_clients_account_statement": 33,
    "system_template_clients_account_statement_trust": 36,
    "system_template_invoices": 32,
    "system_template_invoices_trust": 35,
    "system_template_receipts": 31,
    "system_template_receipts_trust": 34,
    "tax_free": 30,
    "tenant": 1,
    "type_id": 45,
    "virtual_tour_url": 63,
    "website_url": 6
}
    • schema_attributes: 
      {
    "active": "string",
    "allow_dirty_bookings": "string",
    "allow_same_day_access_card_unavailable": "string",
    "allow_same_day_backtoback": "string",
    "booking_action": "string",
    "bookings_split_after": "string",
    "bookings_split_count": "string",
    "bookings_split_length": "string",
    "cm_bookings_future_days_maximum": "string",
    "cm_bookings_future_days_minimum": "string",
    "cm_bookings_split_after": "string",
    "cm_bookings_split_count": "string",
    "cm_bookings_split_length": "string",
    "cm_roomcode": "string",
    "default_tariff_type": "string",
    "description": "string",
    "display_order": "string",
    "engine_additional_adults": "string",
    "engine_additional_animals": "string",
    "engine_additional_children": "string",
    "engine_additional_infants": "string",
    "engine_base_price": "string",
    "engine_extras_combined": "string",
    "engine_included_adults": "string",
    "engine_included_animals": "string",
    "engine_included_children": "string",
    "engine_included_combined": "string",
    "engine_included_infants": "string",
    "engine_max_nights": "string",
    "engine_min_nights": "string",
    "engine_site_count": "string",
    "engine_use_equipment": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "housekeeping": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "inventory_item_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "min_combined": "string",
    "minimum_sites_cm": "string",
    "minimum_sites_online": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "online_bookings_future_days_maximum": "string",
    "online_bookings_future_days_minimum": "string",
    "placeholder_image": "string",
    "preference_order": "string",
    "short_description": "string",
    "system_template_clients_account_statement": "string",
    "system_template_clients_account_statement_trust": "string",
    "system_template_invoices": "string",
    "system_template_invoices_trust": "string",
    "system_template_receipts": "string",
    "system_template_receipts_trust": "string",
    "tax_free": "string",
    "tenant": "string",
    "type_id": "string",
    "virtual_tour_url": "string",
    "website_url": "string"
}
    • schema_name_id: 2437
    • schema_scan_id: 6667708
    • updated: 2024-11-05 02:11:52
    • created: 2024-11-05 02:07:25
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `short_description`  string , `description`  string , `website_url`  string , `display_order`  string , `preference_order`  string , `minimum_sites_online`  string , `minimum_sites_cm`  string , `online_bookings_future_days_minimum`  string , `online_bookings_future_days_maximum`  string , `cm_bookings_future_days_minimum`  string , `cm_bookings_future_days_maximum`  string , `bookings_split_after`  string , `bookings_split_count`  string , `bookings_split_length`  string , `cm_bookings_split_after`  string , `cm_bookings_split_count`  string , `cm_bookings_split_length`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `tax_free`  string , `system_template_receipts`  string , `system_template_invoices`  string , `system_template_clients_account_statement`  string , `system_template_receipts_trust`  string , `system_template_invoices_trust`  string , `system_template_clients_account_statement_trust`  string , `housekeeping`  string , `occupancy`  string , `allow_dirty_bookings`  string , `allow_same_day_backtoback`  string , `allow_same_day_access_card_unavailable`  string , `booking_action`  string , `instance_channel_manager_id`  string , `cm_roomcode`  string , `type_id`  string , `default_tariff_type`  string , `placeholder_image`  string , `engine_site_count`  string , `engine_min_nights`  string , `engine_max_nights`  string , `engine_base_price`  string , `engine_additional_adults`  string , `engine_additional_children`  string , `engine_additional_infants`  string , `engine_additional_animals`  string , `engine_included_combined`  string , `engine_included_adults`  string , `engine_included_children`  string , `engine_included_infants`  string , `engine_included_animals`  string , `engine_extras_combined`  string , `engine_use_equipment`  string , `virtual_tour_url`  string , `active`  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_newbookaccommodation_categories/2024-11-04/1730783715'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories/2024-11-04/1730783715
    • id: 4742332
    • processed: 1
    • raw_data: 
      {
    "active": 64,
    "allow_dirty_bookings": 39,
    "allow_same_day_access_card_unavailable": 41,
    "allow_same_day_backtoback": 40,
    "booking_action": 42,
    "bookings_split_after": 15,
    "bookings_split_count": 16,
    "bookings_split_length": 17,
    "cm_bookings_future_days_maximum": 14,
    "cm_bookings_future_days_minimum": 13,
    "cm_bookings_split_after": 18,
    "cm_bookings_split_count": 19,
    "cm_bookings_split_length": 20,
    "cm_roomcode": 44,
    "default_tariff_type": 46,
    "description": 5,
    "display_order": 7,
    "engine_additional_adults": 52,
    "engine_additional_animals": 55,
    "engine_additional_children": 53,
    "engine_additional_infants": 54,
    "engine_base_price": 51,
    "engine_extras_combined": 61,
    "engine_included_adults": 57,
    "engine_included_animals": 60,
    "engine_included_children": 58,
    "engine_included_combined": 56,
    "engine_included_infants": 59,
    "engine_max_nights": 50,
    "engine_min_nights": 49,
    "engine_site_count": 48,
    "engine_use_equipment": 62,
    "gl_account_id": 29,
    "gl_category_id": 28,
    "housekeeping": 37,
    "id": 2,
    "instance_channel_manager_id": 43,
    "inventory_item_id": 27,
    "max_adults": 21,
    "max_animals": 24,
    "max_children": 22,
    "max_combined": 26,
    "max_infants": 23,
    "min_combined": 25,
    "minimum_sites_cm": 10,
    "minimum_sites_online": 9,
    "name": 3,
    "newbook_region": 0,
    "occupancy": 38,
    "online_bookings_future_days_maximum": 12,
    "online_bookings_future_days_minimum": 11,
    "placeholder_image": 47,
    "preference_order": 8,
    "short_description": 4,
    "system_template_clients_account_statement": 33,
    "system_template_clients_account_statement_trust": 36,
    "system_template_invoices": 32,
    "system_template_invoices_trust": 35,
    "system_template_receipts": 31,
    "system_template_receipts_trust": 34,
    "tax_free": 30,
    "tenant": 1,
    "type_id": 45,
    "virtual_tour_url": 63,
    "website_url": 6
}
    • schema_attributes: 
      {
    "active": "string",
    "allow_dirty_bookings": "string",
    "allow_same_day_access_card_unavailable": "string",
    "allow_same_day_backtoback": "string",
    "booking_action": "string",
    "bookings_split_after": "string",
    "bookings_split_count": "string",
    "bookings_split_length": "string",
    "cm_bookings_future_days_maximum": "string",
    "cm_bookings_future_days_minimum": "string",
    "cm_bookings_split_after": "string",
    "cm_bookings_split_count": "string",
    "cm_bookings_split_length": "string",
    "cm_roomcode": "string",
    "default_tariff_type": "string",
    "description": "string",
    "display_order": "string",
    "engine_additional_adults": "string",
    "engine_additional_animals": "string",
    "engine_additional_children": "string",
    "engine_additional_infants": "string",
    "engine_base_price": "string",
    "engine_extras_combined": "string",
    "engine_included_adults": "string",
    "engine_included_animals": "string",
    "engine_included_children": "string",
    "engine_included_combined": "string",
    "engine_included_infants": "string",
    "engine_max_nights": "string",
    "engine_min_nights": "string",
    "engine_site_count": "string",
    "engine_use_equipment": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "housekeeping": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "inventory_item_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "min_combined": "string",
    "minimum_sites_cm": "string",
    "minimum_sites_online": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "online_bookings_future_days_maximum": "string",
    "online_bookings_future_days_minimum": "string",
    "placeholder_image": "string",
    "preference_order": "string",
    "short_description": "string",
    "system_template_clients_account_statement": "string",
    "system_template_clients_account_statement_trust": "string",
    "system_template_invoices": "string",
    "system_template_invoices_trust": "string",
    "system_template_receipts": "string",
    "system_template_receipts_trust": "string",
    "tax_free": "string",
    "tenant": "string",
    "type_id": "string",
    "virtual_tour_url": "string",
    "website_url": "string"
}
    • schema_name_id: 2437
    • schema_scan_id: 6667548
    • updated: 2024-11-05 02:07:39
    • created: 2024-11-05 01:47:55
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `short_description`  string , `description`  string , `website_url`  string , `display_order`  string , `preference_order`  string , `minimum_sites_online`  string , `minimum_sites_cm`  string , `online_bookings_future_days_minimum`  string , `online_bookings_future_days_maximum`  string , `cm_bookings_future_days_minimum`  string , `cm_bookings_future_days_maximum`  string , `bookings_split_after`  string , `bookings_split_count`  string , `bookings_split_length`  string , `cm_bookings_split_after`  string , `cm_bookings_split_count`  string , `cm_bookings_split_length`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `tax_free`  string , `system_template_receipts`  string , `system_template_invoices`  string , `system_template_clients_account_statement`  string , `system_template_receipts_trust`  string , `system_template_invoices_trust`  string , `system_template_clients_account_statement_trust`  string , `housekeeping`  string , `occupancy`  string , `allow_dirty_bookings`  string , `allow_same_day_backtoback`  string , `allow_same_day_access_card_unavailable`  string , `booking_action`  string , `instance_channel_manager_id`  string , `cm_roomcode`  string , `type_id`  string , `default_tariff_type`  string , `placeholder_image`  string , `engine_site_count`  string , `engine_min_nights`  string , `engine_max_nights`  string , `engine_base_price`  string , `engine_additional_adults`  string , `engine_additional_children`  string , `engine_additional_infants`  string , `engine_additional_animals`  string , `engine_included_combined`  string , `engine_included_adults`  string , `engine_included_children`  string , `engine_included_infants`  string , `engine_included_animals`  string , `engine_extras_combined`  string , `engine_use_equipment`  string , `virtual_tour_url`  string , `active`  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_newbookaccommodation_categories/2024-11-04/1730783596'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories/2024-11-04/1730783596
    • id: 4741604
    • processed: 1
    • raw_data: 
      {
    "active": 64,
    "allow_dirty_bookings": 39,
    "allow_same_day_access_card_unavailable": 41,
    "allow_same_day_backtoback": 40,
    "booking_action": 42,
    "bookings_split_after": 15,
    "bookings_split_count": 16,
    "bookings_split_length": 17,
    "cm_bookings_future_days_maximum": 14,
    "cm_bookings_future_days_minimum": 13,
    "cm_bookings_split_after": 18,
    "cm_bookings_split_count": 19,
    "cm_bookings_split_length": 20,
    "cm_roomcode": 44,
    "default_tariff_type": 46,
    "description": 5,
    "display_order": 7,
    "engine_additional_adults": 52,
    "engine_additional_animals": 55,
    "engine_additional_children": 53,
    "engine_additional_infants": 54,
    "engine_base_price": 51,
    "engine_extras_combined": 61,
    "engine_included_adults": 57,
    "engine_included_animals": 60,
    "engine_included_children": 58,
    "engine_included_combined": 56,
    "engine_included_infants": 59,
    "engine_max_nights": 50,
    "engine_min_nights": 49,
    "engine_site_count": 48,
    "engine_use_equipment": 62,
    "gl_account_id": 29,
    "gl_category_id": 28,
    "housekeeping": 37,
    "id": 2,
    "instance_channel_manager_id": 43,
    "inventory_item_id": 27,
    "max_adults": 21,
    "max_animals": 24,
    "max_children": 22,
    "max_combined": 26,
    "max_infants": 23,
    "min_combined": 25,
    "minimum_sites_cm": 10,
    "minimum_sites_online": 9,
    "name": 3,
    "newbook_region": 0,
    "occupancy": 38,
    "online_bookings_future_days_maximum": 12,
    "online_bookings_future_days_minimum": 11,
    "placeholder_image": 47,
    "preference_order": 8,
    "short_description": 4,
    "system_template_clients_account_statement": 33,
    "system_template_clients_account_statement_trust": 36,
    "system_template_invoices": 32,
    "system_template_invoices_trust": 35,
    "system_template_receipts": 31,
    "system_template_receipts_trust": 34,
    "tax_free": 30,
    "tenant": 1,
    "type_id": 45,
    "virtual_tour_url": 63,
    "website_url": 6
}
    • schema_attributes: 
      {
    "active": "string",
    "allow_dirty_bookings": "string",
    "allow_same_day_access_card_unavailable": "string",
    "allow_same_day_backtoback": "string",
    "booking_action": "string",
    "bookings_split_after": "string",
    "bookings_split_count": "string",
    "bookings_split_length": "string",
    "cm_bookings_future_days_maximum": "string",
    "cm_bookings_future_days_minimum": "string",
    "cm_bookings_split_after": "string",
    "cm_bookings_split_count": "string",
    "cm_bookings_split_length": "string",
    "cm_roomcode": "string",
    "default_tariff_type": "string",
    "description": "string",
    "display_order": "string",
    "engine_additional_adults": "string",
    "engine_additional_animals": "string",
    "engine_additional_children": "string",
    "engine_additional_infants": "string",
    "engine_base_price": "string",
    "engine_extras_combined": "string",
    "engine_included_adults": "string",
    "engine_included_animals": "string",
    "engine_included_children": "string",
    "engine_included_combined": "string",
    "engine_included_infants": "string",
    "engine_max_nights": "string",
    "engine_min_nights": "string",
    "engine_site_count": "string",
    "engine_use_equipment": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "housekeeping": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "inventory_item_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "min_combined": "string",
    "minimum_sites_cm": "string",
    "minimum_sites_online": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "online_bookings_future_days_maximum": "string",
    "online_bookings_future_days_minimum": "string",
    "placeholder_image": "string",
    "preference_order": "string",
    "short_description": "string",
    "system_template_clients_account_statement": "string",
    "system_template_clients_account_statement_trust": "string",
    "system_template_invoices": "string",
    "system_template_invoices_trust": "string",
    "system_template_receipts": "string",
    "system_template_receipts_trust": "string",
    "tax_free": "string",
    "tenant": "string",
    "type_id": "string",
    "virtual_tour_url": "string",
    "website_url": "string"
}
    • schema_name_id: 2437
    • schema_scan_id: 6666819
    • updated: 2024-11-05 01:48:06
    • created: 2024-11-05 01:24:18
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `short_description`  string , `description`  string , `website_url`  string , `display_order`  string , `preference_order`  string , `minimum_sites_online`  string , `minimum_sites_cm`  string , `online_bookings_future_days_minimum`  string , `online_bookings_future_days_maximum`  string , `cm_bookings_future_days_minimum`  string , `cm_bookings_future_days_maximum`  string , `bookings_split_after`  string , `bookings_split_count`  string , `bookings_split_length`  string , `cm_bookings_split_after`  string , `cm_bookings_split_count`  string , `cm_bookings_split_length`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `tax_free`  string , `system_template_receipts`  string , `system_template_invoices`  string , `system_template_clients_account_statement`  string , `system_template_receipts_trust`  string , `system_template_invoices_trust`  string , `system_template_clients_account_statement_trust`  string , `housekeeping`  string , `occupancy`  string , `allow_dirty_bookings`  string , `allow_same_day_backtoback`  string , `allow_same_day_access_card_unavailable`  string , `booking_action`  string , `instance_channel_manager_id`  string , `cm_roomcode`  string , `type_id`  string , `default_tariff_type`  string , `placeholder_image`  string , `engine_site_count`  string , `engine_min_nights`  string , `engine_max_nights`  string , `engine_base_price`  string , `engine_additional_adults`  string , `engine_additional_children`  string , `engine_additional_infants`  string , `engine_additional_animals`  string , `engine_included_combined`  string , `engine_included_adults`  string , `engine_included_children`  string , `engine_included_infants`  string , `engine_included_animals`  string , `engine_extras_combined`  string , `engine_use_equipment`  string , `virtual_tour_url`  string , `active`  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_newbookaccommodation_categories/2024-11-04/1730783471'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories/2024-11-04/1730783471
    • id: 4740704
    • processed: 1
    • raw_data: 
      {
    "active": 64,
    "allow_dirty_bookings": 39,
    "allow_same_day_access_card_unavailable": 41,
    "allow_same_day_backtoback": 40,
    "booking_action": 42,
    "bookings_split_after": 15,
    "bookings_split_count": 16,
    "bookings_split_length": 17,
    "cm_bookings_future_days_maximum": 14,
    "cm_bookings_future_days_minimum": 13,
    "cm_bookings_split_after": 18,
    "cm_bookings_split_count": 19,
    "cm_bookings_split_length": 20,
    "cm_roomcode": 44,
    "default_tariff_type": 46,
    "description": 5,
    "display_order": 7,
    "engine_additional_adults": 52,
    "engine_additional_animals": 55,
    "engine_additional_children": 53,
    "engine_additional_infants": 54,
    "engine_base_price": 51,
    "engine_extras_combined": 61,
    "engine_included_adults": 57,
    "engine_included_animals": 60,
    "engine_included_children": 58,
    "engine_included_combined": 56,
    "engine_included_infants": 59,
    "engine_max_nights": 50,
    "engine_min_nights": 49,
    "engine_site_count": 48,
    "engine_use_equipment": 62,
    "gl_account_id": 29,
    "gl_category_id": 28,
    "housekeeping": 37,
    "id": 2,
    "instance_channel_manager_id": 43,
    "inventory_item_id": 27,
    "max_adults": 21,
    "max_animals": 24,
    "max_children": 22,
    "max_combined": 26,
    "max_infants": 23,
    "min_combined": 25,
    "minimum_sites_cm": 10,
    "minimum_sites_online": 9,
    "name": 3,
    "newbook_region": 0,
    "occupancy": 38,
    "online_bookings_future_days_maximum": 12,
    "online_bookings_future_days_minimum": 11,
    "placeholder_image": 47,
    "preference_order": 8,
    "short_description": 4,
    "system_template_clients_account_statement": 33,
    "system_template_clients_account_statement_trust": 36,
    "system_template_invoices": 32,
    "system_template_invoices_trust": 35,
    "system_template_receipts": 31,
    "system_template_receipts_trust": 34,
    "tax_free": 30,
    "tenant": 1,
    "type_id": 45,
    "virtual_tour_url": 63,
    "website_url": 6
}
    • schema_attributes: 
      {
    "active": "string",
    "allow_dirty_bookings": "string",
    "allow_same_day_access_card_unavailable": "string",
    "allow_same_day_backtoback": "string",
    "booking_action": "string",
    "bookings_split_after": "string",
    "bookings_split_count": "string",
    "bookings_split_length": "string",
    "cm_bookings_future_days_maximum": "string",
    "cm_bookings_future_days_minimum": "string",
    "cm_bookings_split_after": "string",
    "cm_bookings_split_count": "string",
    "cm_bookings_split_length": "string",
    "cm_roomcode": "string",
    "default_tariff_type": "string",
    "description": "string",
    "display_order": "string",
    "engine_additional_adults": "string",
    "engine_additional_animals": "string",
    "engine_additional_children": "string",
    "engine_additional_infants": "string",
    "engine_base_price": "string",
    "engine_extras_combined": "string",
    "engine_included_adults": "string",
    "engine_included_animals": "string",
    "engine_included_children": "string",
    "engine_included_combined": "string",
    "engine_included_infants": "string",
    "engine_max_nights": "string",
    "engine_min_nights": "string",
    "engine_site_count": "string",
    "engine_use_equipment": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "housekeeping": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "inventory_item_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "min_combined": "string",
    "minimum_sites_cm": "string",
    "minimum_sites_online": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "online_bookings_future_days_maximum": "string",
    "online_bookings_future_days_minimum": "string",
    "placeholder_image": "string",
    "preference_order": "string",
    "short_description": "string",
    "system_template_clients_account_statement": "string",
    "system_template_clients_account_statement_trust": "string",
    "system_template_invoices": "string",
    "system_template_invoices_trust": "string",
    "system_template_receipts": "string",
    "system_template_receipts_trust": "string",
    "tax_free": "string",
    "tenant": "string",
    "type_id": "string",
    "virtual_tour_url": "string",
    "website_url": "string"
}
    • schema_name_id: 2437
    • schema_scan_id: 6665921
    • updated: 2024-11-05 01:24:29
    • created: 2024-11-05 01:04:43
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `short_description`  string , `description`  string , `website_url`  string , `display_order`  string , `preference_order`  string , `minimum_sites_online`  string , `minimum_sites_cm`  string , `online_bookings_future_days_minimum`  string , `online_bookings_future_days_maximum`  string , `cm_bookings_future_days_minimum`  string , `cm_bookings_future_days_maximum`  string , `bookings_split_after`  string , `bookings_split_count`  string , `bookings_split_length`  string , `cm_bookings_split_after`  string , `cm_bookings_split_count`  string , `cm_bookings_split_length`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `tax_free`  string , `system_template_receipts`  string , `system_template_invoices`  string , `system_template_clients_account_statement`  string , `system_template_receipts_trust`  string , `system_template_invoices_trust`  string , `system_template_clients_account_statement_trust`  string , `housekeeping`  string , `occupancy`  string , `allow_dirty_bookings`  string , `allow_same_day_backtoback`  string , `allow_same_day_access_card_unavailable`  string , `booking_action`  string , `instance_channel_manager_id`  string , `cm_roomcode`  string , `type_id`  string , `default_tariff_type`  string , `placeholder_image`  string , `engine_site_count`  string , `engine_min_nights`  string , `engine_max_nights`  string , `engine_base_price`  string , `engine_additional_adults`  string , `engine_additional_children`  string , `engine_additional_infants`  string , `engine_additional_animals`  string , `engine_included_combined`  string , `engine_included_adults`  string , `engine_included_children`  string , `engine_included_infants`  string , `engine_included_animals`  string , `engine_extras_combined`  string , `engine_use_equipment`  string , `virtual_tour_url`  string , `active`  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_newbookaccommodation_categories/2024-11-04/1730783253'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories/2024-11-04/1730783253
    • id: 4739966
    • processed: 1
    • raw_data: 
      {
    "active": 64,
    "allow_dirty_bookings": 39,
    "allow_same_day_access_card_unavailable": 41,
    "allow_same_day_backtoback": 40,
    "booking_action": 42,
    "bookings_split_after": 15,
    "bookings_split_count": 16,
    "bookings_split_length": 17,
    "cm_bookings_future_days_maximum": 14,
    "cm_bookings_future_days_minimum": 13,
    "cm_bookings_split_after": 18,
    "cm_bookings_split_count": 19,
    "cm_bookings_split_length": 20,
    "cm_roomcode": 44,
    "default_tariff_type": 46,
    "description": 5,
    "display_order": 7,
    "engine_additional_adults": 52,
    "engine_additional_animals": 55,
    "engine_additional_children": 53,
    "engine_additional_infants": 54,
    "engine_base_price": 51,
    "engine_extras_combined": 61,
    "engine_included_adults": 57,
    "engine_included_animals": 60,
    "engine_included_children": 58,
    "engine_included_combined": 56,
    "engine_included_infants": 59,
    "engine_max_nights": 50,
    "engine_min_nights": 49,
    "engine_site_count": 48,
    "engine_use_equipment": 62,
    "gl_account_id": 29,
    "gl_category_id": 28,
    "housekeeping": 37,
    "id": 2,
    "instance_channel_manager_id": 43,
    "inventory_item_id": 27,
    "max_adults": 21,
    "max_animals": 24,
    "max_children": 22,
    "max_combined": 26,
    "max_infants": 23,
    "min_combined": 25,
    "minimum_sites_cm": 10,
    "minimum_sites_online": 9,
    "name": 3,
    "newbook_region": 0,
    "occupancy": 38,
    "online_bookings_future_days_maximum": 12,
    "online_bookings_future_days_minimum": 11,
    "placeholder_image": 47,
    "preference_order": 8,
    "short_description": 4,
    "system_template_clients_account_statement": 33,
    "system_template_clients_account_statement_trust": 36,
    "system_template_invoices": 32,
    "system_template_invoices_trust": 35,
    "system_template_receipts": 31,
    "system_template_receipts_trust": 34,
    "tax_free": 30,
    "tenant": 1,
    "type_id": 45,
    "virtual_tour_url": 63,
    "website_url": 6
}
    • schema_attributes: 
      {
    "active": "string",
    "allow_dirty_bookings": "string",
    "allow_same_day_access_card_unavailable": "string",
    "allow_same_day_backtoback": "string",
    "booking_action": "string",
    "bookings_split_after": "string",
    "bookings_split_count": "string",
    "bookings_split_length": "string",
    "cm_bookings_future_days_maximum": "string",
    "cm_bookings_future_days_minimum": "string",
    "cm_bookings_split_after": "string",
    "cm_bookings_split_count": "string",
    "cm_bookings_split_length": "string",
    "cm_roomcode": "string",
    "default_tariff_type": "string",
    "description": "string",
    "display_order": "string",
    "engine_additional_adults": "string",
    "engine_additional_animals": "string",
    "engine_additional_children": "string",
    "engine_additional_infants": "string",
    "engine_base_price": "string",
    "engine_extras_combined": "string",
    "engine_included_adults": "string",
    "engine_included_animals": "string",
    "engine_included_children": "string",
    "engine_included_combined": "string",
    "engine_included_infants": "string",
    "engine_max_nights": "string",
    "engine_min_nights": "string",
    "engine_site_count": "string",
    "engine_use_equipment": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "housekeeping": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "inventory_item_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "min_combined": "string",
    "minimum_sites_cm": "string",
    "minimum_sites_online": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "online_bookings_future_days_maximum": "string",
    "online_bookings_future_days_minimum": "string",
    "placeholder_image": "string",
    "preference_order": "string",
    "short_description": "string",
    "system_template_clients_account_statement": "string",
    "system_template_clients_account_statement_trust": "string",
    "system_template_invoices": "string",
    "system_template_invoices_trust": "string",
    "system_template_receipts": "string",
    "system_template_receipts_trust": "string",
    "tax_free": "string",
    "tenant": "string",
    "type_id": "string",
    "virtual_tour_url": "string",
    "website_url": "string"
}
    • schema_name_id: 2437
    • schema_scan_id: 6665181
    • updated: 2024-11-05 01:04:57
    • created: 2024-11-05 00:47:21
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `short_description`  string , `description`  string , `website_url`  string , `display_order`  string , `preference_order`  string , `minimum_sites_online`  string , `minimum_sites_cm`  string , `online_bookings_future_days_minimum`  string , `online_bookings_future_days_maximum`  string , `cm_bookings_future_days_minimum`  string , `cm_bookings_future_days_maximum`  string , `bookings_split_after`  string , `bookings_split_count`  string , `bookings_split_length`  string , `cm_bookings_split_after`  string , `cm_bookings_split_count`  string , `cm_bookings_split_length`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `tax_free`  string , `system_template_receipts`  string , `system_template_invoices`  string , `system_template_clients_account_statement`  string , `system_template_receipts_trust`  string , `system_template_invoices_trust`  string , `system_template_clients_account_statement_trust`  string , `housekeeping`  string , `occupancy`  string , `allow_dirty_bookings`  string , `allow_same_day_backtoback`  string , `allow_same_day_access_card_unavailable`  string , `booking_action`  string , `instance_channel_manager_id`  string , `cm_roomcode`  string , `type_id`  string , `default_tariff_type`  string , `placeholder_image`  string , `engine_site_count`  string , `engine_min_nights`  string , `engine_max_nights`  string , `engine_base_price`  string , `engine_additional_adults`  string , `engine_additional_children`  string , `engine_additional_infants`  string , `engine_additional_animals`  string , `engine_included_combined`  string , `engine_included_adults`  string , `engine_included_children`  string , `engine_included_infants`  string , `engine_included_animals`  string , `engine_extras_combined`  string , `engine_use_equipment`  string , `virtual_tour_url`  string , `active`  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_newbookaccommodation_categories/2024-11-04/1730782855'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories/2024-11-04/1730782855
    • id: 4739311
    • processed: 1
    • raw_data: 
      {
    "active": 64,
    "allow_dirty_bookings": 39,
    "allow_same_day_access_card_unavailable": 41,
    "allow_same_day_backtoback": 40,
    "booking_action": 42,
    "bookings_split_after": 15,
    "bookings_split_count": 16,
    "bookings_split_length": 17,
    "cm_bookings_future_days_maximum": 14,
    "cm_bookings_future_days_minimum": 13,
    "cm_bookings_split_after": 18,
    "cm_bookings_split_count": 19,
    "cm_bookings_split_length": 20,
    "cm_roomcode": 44,
    "default_tariff_type": 46,
    "description": 5,
    "display_order": 7,
    "engine_additional_adults": 52,
    "engine_additional_animals": 55,
    "engine_additional_children": 53,
    "engine_additional_infants": 54,
    "engine_base_price": 51,
    "engine_extras_combined": 61,
    "engine_included_adults": 57,
    "engine_included_animals": 60,
    "engine_included_children": 58,
    "engine_included_combined": 56,
    "engine_included_infants": 59,
    "engine_max_nights": 50,
    "engine_min_nights": 49,
    "engine_site_count": 48,
    "engine_use_equipment": 62,
    "gl_account_id": 29,
    "gl_category_id": 28,
    "housekeeping": 37,
    "id": 2,
    "instance_channel_manager_id": 43,
    "inventory_item_id": 27,
    "max_adults": 21,
    "max_animals": 24,
    "max_children": 22,
    "max_combined": 26,
    "max_infants": 23,
    "min_combined": 25,
    "minimum_sites_cm": 10,
    "minimum_sites_online": 9,
    "name": 3,
    "newbook_region": 0,
    "occupancy": 38,
    "online_bookings_future_days_maximum": 12,
    "online_bookings_future_days_minimum": 11,
    "placeholder_image": 47,
    "preference_order": 8,
    "short_description": 4,
    "system_template_clients_account_statement": 33,
    "system_template_clients_account_statement_trust": 36,
    "system_template_invoices": 32,
    "system_template_invoices_trust": 35,
    "system_template_receipts": 31,
    "system_template_receipts_trust": 34,
    "tax_free": 30,
    "tenant": 1,
    "type_id": 45,
    "virtual_tour_url": 63,
    "website_url": 6
}
    • schema_attributes: 
      {
    "active": "string",
    "allow_dirty_bookings": "string",
    "allow_same_day_access_card_unavailable": "string",
    "allow_same_day_backtoback": "string",
    "booking_action": "string",
    "bookings_split_after": "string",
    "bookings_split_count": "string",
    "bookings_split_length": "string",
    "cm_bookings_future_days_maximum": "string",
    "cm_bookings_future_days_minimum": "string",
    "cm_bookings_split_after": "string",
    "cm_bookings_split_count": "string",
    "cm_bookings_split_length": "string",
    "cm_roomcode": "string",
    "default_tariff_type": "string",
    "description": "string",
    "display_order": "string",
    "engine_additional_adults": "string",
    "engine_additional_animals": "string",
    "engine_additional_children": "string",
    "engine_additional_infants": "string",
    "engine_base_price": "string",
    "engine_extras_combined": "string",
    "engine_included_adults": "string",
    "engine_included_animals": "string",
    "engine_included_children": "string",
    "engine_included_combined": "string",
    "engine_included_infants": "string",
    "engine_max_nights": "string",
    "engine_min_nights": "string",
    "engine_site_count": "string",
    "engine_use_equipment": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "housekeeping": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "inventory_item_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "min_combined": "string",
    "minimum_sites_cm": "string",
    "minimum_sites_online": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "online_bookings_future_days_maximum": "string",
    "online_bookings_future_days_minimum": "string",
    "placeholder_image": "string",
    "preference_order": "string",
    "short_description": "string",
    "system_template_clients_account_statement": "string",
    "system_template_clients_account_statement_trust": "string",
    "system_template_invoices": "string",
    "system_template_invoices_trust": "string",
    "system_template_receipts": "string",
    "system_template_receipts_trust": "string",
    "tax_free": "string",
    "tenant": "string",
    "type_id": "string",
    "virtual_tour_url": "string",
    "website_url": "string"
}
    • schema_name_id: 2437
    • schema_scan_id: 6664524
    • updated: 2024-11-05 00:47:32
    • created: 2024-11-05 00:31:47
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `short_description`  string , `description`  string , `website_url`  string , `display_order`  string , `preference_order`  string , `minimum_sites_online`  string , `minimum_sites_cm`  string , `online_bookings_future_days_minimum`  string , `online_bookings_future_days_maximum`  string , `cm_bookings_future_days_minimum`  string , `cm_bookings_future_days_maximum`  string , `bookings_split_after`  string , `bookings_split_count`  string , `bookings_split_length`  string , `cm_bookings_split_after`  string , `cm_bookings_split_count`  string , `cm_bookings_split_length`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `tax_free`  string , `system_template_receipts`  string , `system_template_invoices`  string , `system_template_clients_account_statement`  string , `system_template_receipts_trust`  string , `system_template_invoices_trust`  string , `system_template_clients_account_statement_trust`  string , `housekeeping`  string , `occupancy`  string , `allow_dirty_bookings`  string , `allow_same_day_backtoback`  string , `allow_same_day_access_card_unavailable`  string , `booking_action`  string , `instance_channel_manager_id`  string , `cm_roomcode`  string , `type_id`  string , `default_tariff_type`  string , `placeholder_image`  string , `engine_site_count`  string , `engine_min_nights`  string , `engine_max_nights`  string , `engine_base_price`  string , `engine_additional_adults`  string , `engine_additional_children`  string , `engine_additional_infants`  string , `engine_additional_animals`  string , `engine_included_combined`  string , `engine_included_adults`  string , `engine_included_children`  string , `engine_included_infants`  string , `engine_included_animals`  string , `engine_extras_combined`  string , `engine_use_equipment`  string , `virtual_tour_url`  string , `active`  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_newbookaccommodation_categories/2024-11-04/1730782766'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories/2024-11-04/1730782766
    • id: 4738719
    • processed: 1
    • raw_data: 
      {
    "active": 64,
    "allow_dirty_bookings": 39,
    "allow_same_day_access_card_unavailable": 41,
    "allow_same_day_backtoback": 40,
    "booking_action": 42,
    "bookings_split_after": 15,
    "bookings_split_count": 16,
    "bookings_split_length": 17,
    "cm_bookings_future_days_maximum": 14,
    "cm_bookings_future_days_minimum": 13,
    "cm_bookings_split_after": 18,
    "cm_bookings_split_count": 19,
    "cm_bookings_split_length": 20,
    "cm_roomcode": 44,
    "default_tariff_type": 46,
    "description": 5,
    "display_order": 7,
    "engine_additional_adults": 52,
    "engine_additional_animals": 55,
    "engine_additional_children": 53,
    "engine_additional_infants": 54,
    "engine_base_price": 51,
    "engine_extras_combined": 61,
    "engine_included_adults": 57,
    "engine_included_animals": 60,
    "engine_included_children": 58,
    "engine_included_combined": 56,
    "engine_included_infants": 59,
    "engine_max_nights": 50,
    "engine_min_nights": 49,
    "engine_site_count": 48,
    "engine_use_equipment": 62,
    "gl_account_id": 29,
    "gl_category_id": 28,
    "housekeeping": 37,
    "id": 2,
    "instance_channel_manager_id": 43,
    "inventory_item_id": 27,
    "max_adults": 21,
    "max_animals": 24,
    "max_children": 22,
    "max_combined": 26,
    "max_infants": 23,
    "min_combined": 25,
    "minimum_sites_cm": 10,
    "minimum_sites_online": 9,
    "name": 3,
    "newbook_region": 0,
    "occupancy": 38,
    "online_bookings_future_days_maximum": 12,
    "online_bookings_future_days_minimum": 11,
    "placeholder_image": 47,
    "preference_order": 8,
    "short_description": 4,
    "system_template_clients_account_statement": 33,
    "system_template_clients_account_statement_trust": 36,
    "system_template_invoices": 32,
    "system_template_invoices_trust": 35,
    "system_template_receipts": 31,
    "system_template_receipts_trust": 34,
    "tax_free": 30,
    "tenant": 1,
    "type_id": 45,
    "virtual_tour_url": 63,
    "website_url": 6
}
    • schema_attributes: 
      {
    "active": "string",
    "allow_dirty_bookings": "string",
    "allow_same_day_access_card_unavailable": "string",
    "allow_same_day_backtoback": "string",
    "booking_action": "string",
    "bookings_split_after": "string",
    "bookings_split_count": "string",
    "bookings_split_length": "string",
    "cm_bookings_future_days_maximum": "string",
    "cm_bookings_future_days_minimum": "string",
    "cm_bookings_split_after": "string",
    "cm_bookings_split_count": "string",
    "cm_bookings_split_length": "string",
    "cm_roomcode": "string",
    "default_tariff_type": "string",
    "description": "string",
    "display_order": "string",
    "engine_additional_adults": "string",
    "engine_additional_animals": "string",
    "engine_additional_children": "string",
    "engine_additional_infants": "string",
    "engine_base_price": "string",
    "engine_extras_combined": "string",
    "engine_included_adults": "string",
    "engine_included_animals": "string",
    "engine_included_children": "string",
    "engine_included_combined": "string",
    "engine_included_infants": "string",
    "engine_max_nights": "string",
    "engine_min_nights": "string",
    "engine_site_count": "string",
    "engine_use_equipment": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "housekeeping": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "inventory_item_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "min_combined": "string",
    "minimum_sites_cm": "string",
    "minimum_sites_online": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "online_bookings_future_days_maximum": "string",
    "online_bookings_future_days_minimum": "string",
    "placeholder_image": "string",
    "preference_order": "string",
    "short_description": "string",
    "system_template_clients_account_statement": "string",
    "system_template_clients_account_statement_trust": "string",
    "system_template_invoices": "string",
    "system_template_invoices_trust": "string",
    "system_template_receipts": "string",
    "system_template_receipts_trust": "string",
    "tax_free": "string",
    "tenant": "string",
    "type_id": "string",
    "virtual_tour_url": "string",
    "website_url": "string"
}
    • schema_name_id: 2437
    • schema_scan_id: 6663931
    • updated: 2024-11-05 00:31:58
Schema Scans: 15
Last at 2024-11-05 22:30:41
    • duration: 0:00:15.853160
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6673997
    • 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_newbookaccommodation_categories/2024-11-05/1730866342",
        "key": "raw/newbookdev_newbookaccommodation_categories/2024-11-05/1730866342/accommodation_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9569108370900680797,
        "service_name": "drive-thru",
        "span_id": 2975416814410180258,
        "trace_id": 2217043882116148125
    }
}
    • running: False
    • schema_name_id: 2437
    • start_time: 2024-11-05 22:30:41
    • success: True
    • trace_id: 2217043882116148125
    • duration: 0:00:15.558768
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6673641
    • 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_newbookaccommodation_categories/2024-11-05/1730866280",
        "key": "raw/newbookdev_newbookaccommodation_categories/2024-11-05/1730866280/accommodation_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11075398885720044255,
        "service_name": "drive-thru",
        "span_id": 12283676360649369395,
        "trace_id": 15720267040269073749
    }
}
    • running: False
    • schema_name_id: 2437
    • start_time: 2024-11-05 22:21:17
    • success: True
    • trace_id: 15720267040269073749
    • duration: 0:00:15.954826
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6673369
    • 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_newbookaccommodation_categories/2024-11-05/1730866222",
        "key": "raw/newbookdev_newbookaccommodation_categories/2024-11-05/1730866222/accommodation_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7939277822634712760,
        "service_name": "drive-thru",
        "span_id": 12450860558978481353,
        "trace_id": 965430794717109324
    }
}
    • running: False
    • schema_name_id: 2437
    • start_time: 2024-11-05 22:11:17
    • success: True
    • trace_id: 965430794717109324
    • duration: 0:00:16.089486
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6671761
    • 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_newbookaccommodation_categories/2024-11-04/1730785635",
        "key": "raw/newbookdev_newbookaccommodation_categories/2024-11-04/1730785635/accommodation_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 930492576309914378,
        "service_name": "drive-thru",
        "span_id": 15563661795875549636,
        "trace_id": 7945148578946407068
    }
}
    • running: False
    • schema_name_id: 2437
    • start_time: 2024-11-05 04:08:17
    • success: True
    • trace_id: 7945148578946407068
    • duration: 0:00:13.110336
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6670976
    • 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_newbookaccommodation_categories/2024-11-04/1730785074",
        "key": "raw/newbookdev_newbookaccommodation_categories/2024-11-04/1730785074/accommodation_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6405885538649882917,
        "service_name": "drive-thru",
        "span_id": 9456311820246183869,
        "trace_id": 18212760720988531938
    }
}
    • running: False
    • schema_name_id: 2437
    • start_time: 2024-11-05 03:38:03
    • success: True
    • trace_id: 18212760720988531938
    • duration: 0:00:13.144130
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6670842
    • 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_newbookaccommodation_categories/2024-11-04/1730784770",
        "key": "raw/newbookdev_newbookaccommodation_categories/2024-11-04/1730784770/accommodation_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1482913001656676206,
        "service_name": "drive-thru",
        "span_id": 1373134387047192221,
        "trace_id": 13696389936109782799
    }
}
    • running: False
    • schema_name_id: 2437
    • start_time: 2024-11-05 03:34:23
    • success: True
    • trace_id: 13696389936109782799
    • duration: 0:00:15.564226
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6669464
    • 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_newbookaccommodation_categories/2024-11-04/1730784165",
        "key": "raw/newbookdev_newbookaccommodation_categories/2024-11-04/1730784165/accommodation_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6642825895753740270,
        "service_name": "drive-thru",
        "span_id": 3042090849231733701,
        "trace_id": 17437763797826691509
    }
}
    • running: False
    • schema_name_id: 2437
    • start_time: 2024-11-05 02:57:49
    • success: True
    • trace_id: 17437763797826691509
    • duration: 0:00:12.976091
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6668824
    • 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_newbookaccommodation_categories/2024-11-04/1730784003",
        "key": "raw/newbookdev_newbookaccommodation_categories/2024-11-04/1730784003/accommodation_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15584282126089320769,
        "service_name": "drive-thru",
        "span_id": 15994549149082037149,
        "trace_id": 14427000511115124957
    }
}
    • running: False
    • schema_name_id: 2437
    • start_time: 2024-11-05 02:41:06
    • success: True
    • trace_id: 14427000511115124957
    • duration: 0:00:15.544496
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6667708
    • 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_newbookaccommodation_categories/2024-11-04/1730783860",
        "key": "raw/newbookdev_newbookaccommodation_categories/2024-11-04/1730783860/accommodation_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8050147301475314693,
        "service_name": "drive-thru",
        "span_id": 6284003550955420361,
        "trace_id": 14355328227079900178
    }
}
    • running: False
    • schema_name_id: 2437
    • start_time: 2024-11-05 02:11:36
    • success: True
    • trace_id: 14355328227079900178
    • duration: 0:00:15.569654
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6667548
    • 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_newbookaccommodation_categories/2024-11-04/1730783715",
        "key": "raw/newbookdev_newbookaccommodation_categories/2024-11-04/1730783715/accommodation_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11937770093712407828,
        "service_name": "drive-thru",
        "span_id": 12621895115084684472,
        "trace_id": 7631379375052471167
    }
}
    • running: False
    • schema_name_id: 2437
    • start_time: 2024-11-05 02:07:23
    • success: True
    • trace_id: 7631379375052471167
    • duration: 0:00:13.002755
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6666819
    • 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_newbookaccommodation_categories/2024-11-04/1730783596",
        "key": "raw/newbookdev_newbookaccommodation_categories/2024-11-04/1730783596/accommodation_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8905950610805366520,
        "service_name": "drive-thru",
        "span_id": 9986470595192938614,
        "trace_id": 2657983821910569281
    }
}
    • running: False
    • schema_name_id: 2437
    • start_time: 2024-11-05 01:47:53
    • success: True
    • trace_id: 2657983821910569281
    • duration: 0:00:12.951596
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6665921
    • 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_newbookaccommodation_categories/2024-11-04/1730783471",
        "key": "raw/newbookdev_newbookaccommodation_categories/2024-11-04/1730783471/accommodation_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14840315929904515927,
        "service_name": "drive-thru",
        "span_id": 4020194217680231753,
        "trace_id": 1256859468701425316
    }
}
    • running: False
    • schema_name_id: 2437
    • start_time: 2024-11-05 01:24:16
    • success: True
    • trace_id: 1256859468701425316
    • duration: 0:00:15.325995
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6665181
    • 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_newbookaccommodation_categories/2024-11-04/1730783253",
        "key": "raw/newbookdev_newbookaccommodation_categories/2024-11-04/1730783253/accommodation_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7635274580129490983,
        "service_name": "drive-thru",
        "span_id": 15133307949418163288,
        "trace_id": 87894765514792233
    }
}
    • running: False
    • schema_name_id: 2437
    • start_time: 2024-11-05 01:04:41
    • success: True
    • trace_id: 87894765514792233
    • duration: 0:00:13.109006
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6664524
    • 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_newbookaccommodation_categories/2024-11-04/1730782855",
        "key": "raw/newbookdev_newbookaccommodation_categories/2024-11-04/1730782855/accommodation_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10422381451557396166,
        "service_name": "drive-thru",
        "span_id": 17822414273516881950,
        "trace_id": 8913017472968381990
    }
}
    • running: False
    • schema_name_id: 2437
    • start_time: 2024-11-05 00:47:19
    • success: True
    • trace_id: 8913017472968381990
    • duration: 0:00:13.146760
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6663931
    • 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_newbookaccommodation_categories/2024-11-04/1730782766",
        "key": "raw/newbookdev_newbookaccommodation_categories/2024-11-04/1730782766/accommodation_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9518937079766484870,
        "service_name": "drive-thru",
        "span_id": 15410264405940734332,
        "trace_id": 1918447113404529017
    }
}
    • running: False
    • schema_name_id: 2437
    • start_time: 2024-11-05 00:31:45
    • success: True
    • trace_id: 1918447113404529017
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "active": "string",
    "allow_dirty_bookings": "string",
    "allow_same_day_access_card_unavailable": "string",
    "allow_same_day_backtoback": "string",
    "booking_action": "string",
    "bookings_split_after": "string",
    "bookings_split_count": "string",
    "bookings_split_length": "string",
    "cm_bookings_future_days_maximum": "string",
    "cm_bookings_future_days_minimum": "string",
    "cm_bookings_split_after": "string",
    "cm_bookings_split_count": "string",
    "cm_bookings_split_length": "string",
    "cm_roomcode": "string",
    "default_tariff_type": "string",
    "description": "string",
    "display_order": "string",
    "engine_additional_adults": "string",
    "engine_additional_animals": "string",
    "engine_additional_children": "string",
    "engine_additional_infants": "string",
    "engine_base_price": "string",
    "engine_extras_combined": "string",
    "engine_included_adults": "string",
    "engine_included_animals": "string",
    "engine_included_children": "string",
    "engine_included_combined": "string",
    "engine_included_infants": "string",
    "engine_max_nights": "string",
    "engine_min_nights": "string",
    "engine_site_count": "string",
    "engine_use_equipment": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "housekeeping": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "inventory_item_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "min_combined": "string",
    "minimum_sites_cm": "string",
    "minimum_sites_online": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "online_bookings_future_days_maximum": "string",
    "online_bookings_future_days_minimum": "string",
    "placeholder_image": "string",
    "preference_order": "string",
    "short_description": "string",
    "system_template_clients_account_statement": "string",
    "system_template_clients_account_statement_trust": "string",
    "system_template_invoices": "string",
    "system_template_invoices_trust": "string",
    "system_template_receipts": "string",
    "system_template_receipts_trust": "string",
    "tax_free": "string",
    "tenant": "string",
    "type_id": "string",
    "virtual_tour_url": "string",
    "website_url": "string"
}
  • created: 2024-11-05 22:30:44
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `short_description`  string , `description`  string , `website_url`  string , `display_order`  string , `preference_order`  string , `minimum_sites_online`  string , `minimum_sites_cm`  string , `online_bookings_future_days_minimum`  string , `online_bookings_future_days_maximum`  string , `cm_bookings_future_days_minimum`  string , `cm_bookings_future_days_maximum`  string , `bookings_split_after`  string , `bookings_split_count`  string , `bookings_split_length`  string , `cm_bookings_split_after`  string , `cm_bookings_split_count`  string , `cm_bookings_split_length`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `tax_free`  string , `system_template_receipts`  string , `system_template_invoices`  string , `system_template_clients_account_statement`  string , `system_template_receipts_trust`  string , `system_template_invoices_trust`  string , `system_template_clients_account_statement_trust`  string , `housekeeping`  string , `occupancy`  string , `allow_dirty_bookings`  string , `allow_same_day_backtoback`  string , `allow_same_day_access_card_unavailable`  string , `booking_action`  string , `instance_channel_manager_id`  string , `cm_roomcode`  string , `type_id`  string , `default_tariff_type`  string , `placeholder_image`  string , `engine_site_count`  string , `engine_min_nights`  string , `engine_max_nights`  string , `engine_base_price`  string , `engine_additional_adults`  string , `engine_additional_children`  string , `engine_additional_infants`  string , `engine_additional_animals`  string , `engine_included_combined`  string , `engine_included_adults`  string , `engine_included_children`  string , `engine_included_infants`  string , `engine_included_animals`  string , `engine_extras_combined`  string , `engine_use_equipment`  string , `virtual_tour_url`  string , `active`  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_newbookaccommodation_categories/2024-11-05/1730866342'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories"
}
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:38:58",
        "disabled": false,
        "format": "raw",
        "id": 2437,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookaccommodation_categories"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "active": "string",
            "allow_dirty_bookings": "string",
            "allow_same_day_access_card_unavailable": "string",
            "allow_same_day_backtoback": "string",
            "booking_action": "string",
            "bookings_split_after": "string",
            "bookings_split_count": "string",
            "bookings_split_length": "string",
            "cm_bookings_future_days_maximum": "string",
            "cm_bookings_future_days_minimum": "string",
            "cm_bookings_split_after": "string",
            "cm_bookings_split_count": "string",
            "cm_bookings_split_length": "string",
            "cm_roomcode": "string",
            "default_tariff_type": "string",
            "description": "string",
            "display_order": "string",
            "engine_additional_adults": "string",
            "engine_additional_animals": "string",
            "engine_additional_children": "string",
            "engine_additional_infants": "string",
            "engine_base_price": "string",
            "engine_extras_combined": "string",
            "engine_included_adults": "string",
            "engine_included_animals": "string",
            "engine_included_children": "string",
            "engine_included_combined": "string",
            "engine_included_infants": "string",
            "engine_max_nights": "string",
            "engine_min_nights": "string",
            "engine_site_count": "string",
            "engine_use_equipment": "string",
            "gl_account_id": "string",
            "gl_category_id": "string",
            "housekeeping": "string",
            "id": "string",
            "instance_channel_manager_id": "string",
            "inventory_item_id": "string",
            "max_adults": "string",
            "max_animals": "string",
            "max_children": "string",
            "max_combined": "string",
            "max_infants": "string",
            "min_combined": "string",
            "minimum_sites_cm": "string",
            "minimum_sites_online": "string",
            "name": "string",
            "newbook_region": "string",
            "occupancy": "string",
            "online_bookings_future_days_maximum": "string",
            "online_bookings_future_days_minimum": "string",
            "placeholder_image": "string",
            "preference_order": "string",
            "short_description": "string",
            "system_template_clients_account_statement": "string",
            "system_template_clients_account_statement_trust": "string",
            "system_template_invoices": "string",
            "system_template_invoices_trust": "string",
            "system_template_receipts": "string",
            "system_template_receipts_trust": "string",
            "tax_free": "string",
            "tenant": "string",
            "type_id": "string",
            "virtual_tour_url": "string",
            "website_url": "string"
        },
        "created": "2024-11-05 22:30:44",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `short_description`  string , `description`  string , `website_url`  string , `display_order`  string , `preference_order`  string , `minimum_sites_online`  string , `minimum_sites_cm`  string , `online_bookings_future_days_minimum`  string , `online_bookings_future_days_maximum`  string , `cm_bookings_future_days_minimum`  string , `cm_bookings_future_days_maximum`  string , `bookings_split_after`  string , `bookings_split_count`  string , `bookings_split_length`  string , `cm_bookings_split_after`  string , `cm_bookings_split_count`  string , `cm_bookings_split_length`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `tax_free`  string , `system_template_receipts`  string , `system_template_invoices`  string , `system_template_clients_account_statement`  string , `system_template_receipts_trust`  string , `system_template_invoices_trust`  string , `system_template_clients_account_statement_trust`  string , `housekeeping`  string , `occupancy`  string , `allow_dirty_bookings`  string , `allow_same_day_backtoback`  string , `allow_same_day_access_card_unavailable`  string , `booking_action`  string , `instance_channel_manager_id`  string , `cm_roomcode`  string , `type_id`  string , `default_tariff_type`  string , `placeholder_image`  string , `engine_site_count`  string , `engine_min_nights`  string , `engine_max_nights`  string , `engine_base_price`  string , `engine_additional_adults`  string , `engine_additional_children`  string , `engine_additional_infants`  string , `engine_additional_animals`  string , `engine_included_combined`  string , `engine_included_adults`  string , `engine_included_children`  string , `engine_included_infants`  string , `engine_included_animals`  string , `engine_extras_combined`  string , `engine_use_equipment`  string , `virtual_tour_url`  string , `active`  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_newbookaccommodation_categories/2024-11-05/1730866342'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}
©2019 SpareFoot Data Platform