Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookinstances
  • created: 2024-10-08 17:53:28
  • disabled: False
  • format: raw
  • id: 2637
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_dev_drivethru",
    "table": "newbookdev_newbookinstances"
}
  • type: drivethrucsv
Schema Versions: 15
    • created: 2024-11-05 23:14:37
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `api_key`  string , `corporation_id`  string , `corporation_sync`  string , `duplicate_detection`  string , `tax_id`  string , `login_code`  string , `newbook_generic_url`  string , `weather_station_code`  string , `bom_radar_code`  string , `lat`  string , `long`  string , `name`  string , `trading_name`  string , `created_when`  string , `opened_on`  string , `newbook_contract_date`  string , `newbook_start_date`  string , `newbook_review_date`  string , `newbook_stop_date`  string , `physical_street`  string , `physical_city`  string , `physical_state_id`  string , `physical_postcode`  string , `physical_country_id`  string , `mailing_street`  string , `mailing_city`  string , `mailing_state_id`  string , `mailing_postcode`  string , `mailing_country_id`  string , `sales_email`  string , `sales_phone`  string , `sales_fax`  string , `admin_email`  string , `admin_phone`  string , `admin_fax`  string , `survey_email`  string , `error_email`  string , `contact_person`  string , `manager_name`  string , `opening_time`  string , `closing_time`  string , `checkin_time`  string , `checkout_time`  string , `date_format`  string , `time_format`  string , `website`  string , `allow_children`  string , `allow_infants`  string , `allow_animals`  string , `status`  string , `read_only`  string , `grace_period`  string , `firstrun`  string , `login_type`  string , `secure_login`  string , `default_client_account_id`  string , `base_license_account_id`  string , `additional_license_account_id`  string , `ewn_registration_key`  string , `facebook_page_id`  string , `instance_type`  string , `software_type`  string , `previous_supplier_id`  string , `migration_type`  string , `future_supplier_id`  string , `future_supplier_reason`  string , `individual_invoice`  string , `last_updated`  string , `total_bookings`  string , `last_booking_timestamp`  string , `last_booking_data`  string , `basic_information`  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_newbookinstances/2024-11-05/1730866510'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances/2024-11-05/1730866510
    • id: 4749021
    • processed: 1
    • raw_data: 
      {
    "additional_license_account_id": 60,
    "admin_email": 35,
    "admin_fax": 37,
    "admin_phone": 36,
    "allow_animals": 51,
    "allow_children": 49,
    "allow_infants": 50,
    "api_key": 3,
    "base_license_account_id": 59,
    "basic_information": 74,
    "bom_radar_code": 11,
    "checkin_time": 44,
    "checkout_time": 45,
    "closing_time": 43,
    "contact_person": 40,
    "corporation_id": 4,
    "corporation_sync": 5,
    "created_when": 16,
    "date_format": 46,
    "default_client_account_id": 58,
    "duplicate_detection": 6,
    "error_email": 39,
    "ewn_registration_key": 61,
    "facebook_page_id": 62,
    "firstrun": 55,
    "future_supplier_id": 67,
    "future_supplier_reason": 68,
    "grace_period": 54,
    "id": 2,
    "individual_invoice": 69,
    "instance_type": 63,
    "last_booking_data": 73,
    "last_booking_timestamp": 72,
    "last_updated": 70,
    "lat": 12,
    "login_code": 8,
    "login_type": 56,
    "long": 13,
    "mailing_city": 28,
    "mailing_country_id": 31,
    "mailing_postcode": 30,
    "mailing_state_id": 29,
    "mailing_street": 27,
    "manager_name": 41,
    "migration_type": 66,
    "name": 14,
    "newbook_contract_date": 18,
    "newbook_generic_url": 9,
    "newbook_region": 0,
    "newbook_review_date": 20,
    "newbook_start_date": 19,
    "newbook_stop_date": 21,
    "opened_on": 17,
    "opening_time": 42,
    "physical_city": 23,
    "physical_country_id": 26,
    "physical_postcode": 25,
    "physical_state_id": 24,
    "physical_street": 22,
    "previous_supplier_id": 65,
    "read_only": 53,
    "sales_email": 32,
    "sales_fax": 34,
    "sales_phone": 33,
    "secure_login": 57,
    "software_type": 64,
    "status": 52,
    "survey_email": 38,
    "tax_id": 7,
    "tenant": 1,
    "time_format": 47,
    "total_bookings": 71,
    "trading_name": 15,
    "weather_station_code": 10,
    "website": 48
}
    • schema_attributes: 
      {
    "additional_license_account_id": "string",
    "admin_email": "string",
    "admin_fax": "string",
    "admin_phone": "string",
    "allow_animals": "string",
    "allow_children": "string",
    "allow_infants": "string",
    "api_key": "string",
    "base_license_account_id": "string",
    "basic_information": "string",
    "bom_radar_code": "string",
    "checkin_time": "string",
    "checkout_time": "string",
    "closing_time": "string",
    "contact_person": "string",
    "corporation_id": "string",
    "corporation_sync": "string",
    "created_when": "string",
    "date_format": "string",
    "default_client_account_id": "string",
    "duplicate_detection": "string",
    "error_email": "string",
    "ewn_registration_key": "string",
    "facebook_page_id": "string",
    "firstrun": "string",
    "future_supplier_id": "string",
    "future_supplier_reason": "string",
    "grace_period": "string",
    "id": "string",
    "individual_invoice": "string",
    "instance_type": "string",
    "last_booking_data": "string",
    "last_booking_timestamp": "string",
    "last_updated": "string",
    "lat": "string",
    "login_code": "string",
    "login_type": "string",
    "long": "string",
    "mailing_city": "string",
    "mailing_country_id": "string",
    "mailing_postcode": "string",
    "mailing_state_id": "string",
    "mailing_street": "string",
    "manager_name": "string",
    "migration_type": "string",
    "name": "string",
    "newbook_contract_date": "string",
    "newbook_generic_url": "string",
    "newbook_region": "string",
    "newbook_review_date": "string",
    "newbook_start_date": "string",
    "newbook_stop_date": "string",
    "opened_on": "string",
    "opening_time": "string",
    "physical_city": "string",
    "physical_country_id": "string",
    "physical_postcode": "string",
    "physical_state_id": "string",
    "physical_street": "string",
    "previous_supplier_id": "string",
    "read_only": "string",
    "sales_email": "string",
    "sales_fax": "string",
    "sales_phone": "string",
    "secure_login": "string",
    "software_type": "string",
    "status": "string",
    "survey_email": "string",
    "tax_id": "string",
    "tenant": "string",
    "time_format": "string",
    "total_bookings": "string",
    "trading_name": "string",
    "weather_station_code": "string",
    "website": "string"
}
    • schema_name_id: 2637
    • schema_scan_id: 6675052
    • updated: 2024-11-05 23:14:51
    • created: 2024-11-05 22:42:54
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `api_key`  string , `corporation_id`  string , `corporation_sync`  string , `duplicate_detection`  string , `tax_id`  string , `login_code`  string , `newbook_generic_url`  string , `weather_station_code`  string , `bom_radar_code`  string , `lat`  string , `long`  string , `name`  string , `trading_name`  string , `created_when`  string , `opened_on`  string , `newbook_contract_date`  string , `newbook_start_date`  string , `newbook_review_date`  string , `newbook_stop_date`  string , `physical_street`  string , `physical_city`  string , `physical_state_id`  string , `physical_postcode`  string , `physical_country_id`  string , `mailing_street`  string , `mailing_city`  string , `mailing_state_id`  string , `mailing_postcode`  string , `mailing_country_id`  string , `sales_email`  string , `sales_phone`  string , `sales_fax`  string , `admin_email`  string , `admin_phone`  string , `admin_fax`  string , `survey_email`  string , `error_email`  string , `contact_person`  string , `manager_name`  string , `opening_time`  string , `closing_time`  string , `checkin_time`  string , `checkout_time`  string , `date_format`  string , `time_format`  string , `website`  string , `allow_children`  string , `allow_infants`  string , `allow_animals`  string , `status`  string , `read_only`  string , `grace_period`  string , `firstrun`  string , `login_type`  string , `secure_login`  string , `default_client_account_id`  string , `base_license_account_id`  string , `additional_license_account_id`  string , `ewn_registration_key`  string , `facebook_page_id`  string , `instance_type`  string , `software_type`  string , `previous_supplier_id`  string , `migration_type`  string , `future_supplier_id`  string , `future_supplier_reason`  string , `individual_invoice`  string , `last_updated`  string , `total_bookings`  string , `last_booking_timestamp`  string , `last_booking_data`  string , `basic_information`  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_newbookinstances/2024-11-05/1730866433'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances/2024-11-05/1730866433
    • id: 4748341
    • processed: 1
    • raw_data: 
      {
    "additional_license_account_id": 60,
    "admin_email": 35,
    "admin_fax": 37,
    "admin_phone": 36,
    "allow_animals": 51,
    "allow_children": 49,
    "allow_infants": 50,
    "api_key": 3,
    "base_license_account_id": 59,
    "basic_information": 74,
    "bom_radar_code": 11,
    "checkin_time": 44,
    "checkout_time": 45,
    "closing_time": 43,
    "contact_person": 40,
    "corporation_id": 4,
    "corporation_sync": 5,
    "created_when": 16,
    "date_format": 46,
    "default_client_account_id": 58,
    "duplicate_detection": 6,
    "error_email": 39,
    "ewn_registration_key": 61,
    "facebook_page_id": 62,
    "firstrun": 55,
    "future_supplier_id": 67,
    "future_supplier_reason": 68,
    "grace_period": 54,
    "id": 2,
    "individual_invoice": 69,
    "instance_type": 63,
    "last_booking_data": 73,
    "last_booking_timestamp": 72,
    "last_updated": 70,
    "lat": 12,
    "login_code": 8,
    "login_type": 56,
    "long": 13,
    "mailing_city": 28,
    "mailing_country_id": 31,
    "mailing_postcode": 30,
    "mailing_state_id": 29,
    "mailing_street": 27,
    "manager_name": 41,
    "migration_type": 66,
    "name": 14,
    "newbook_contract_date": 18,
    "newbook_generic_url": 9,
    "newbook_region": 0,
    "newbook_review_date": 20,
    "newbook_start_date": 19,
    "newbook_stop_date": 21,
    "opened_on": 17,
    "opening_time": 42,
    "physical_city": 23,
    "physical_country_id": 26,
    "physical_postcode": 25,
    "physical_state_id": 24,
    "physical_street": 22,
    "previous_supplier_id": 65,
    "read_only": 53,
    "sales_email": 32,
    "sales_fax": 34,
    "sales_phone": 33,
    "secure_login": 57,
    "software_type": 64,
    "status": 52,
    "survey_email": 38,
    "tax_id": 7,
    "tenant": 1,
    "time_format": 47,
    "total_bookings": 71,
    "trading_name": 15,
    "weather_station_code": 10,
    "website": 48
}
    • schema_attributes: 
      {
    "additional_license_account_id": "string",
    "admin_email": "string",
    "admin_fax": "string",
    "admin_phone": "string",
    "allow_animals": "string",
    "allow_children": "string",
    "allow_infants": "string",
    "api_key": "string",
    "base_license_account_id": "string",
    "basic_information": "string",
    "bom_radar_code": "string",
    "checkin_time": "string",
    "checkout_time": "string",
    "closing_time": "string",
    "contact_person": "string",
    "corporation_id": "string",
    "corporation_sync": "string",
    "created_when": "string",
    "date_format": "string",
    "default_client_account_id": "string",
    "duplicate_detection": "string",
    "error_email": "string",
    "ewn_registration_key": "string",
    "facebook_page_id": "string",
    "firstrun": "string",
    "future_supplier_id": "string",
    "future_supplier_reason": "string",
    "grace_period": "string",
    "id": "string",
    "individual_invoice": "string",
    "instance_type": "string",
    "last_booking_data": "string",
    "last_booking_timestamp": "string",
    "last_updated": "string",
    "lat": "string",
    "login_code": "string",
    "login_type": "string",
    "long": "string",
    "mailing_city": "string",
    "mailing_country_id": "string",
    "mailing_postcode": "string",
    "mailing_state_id": "string",
    "mailing_street": "string",
    "manager_name": "string",
    "migration_type": "string",
    "name": "string",
    "newbook_contract_date": "string",
    "newbook_generic_url": "string",
    "newbook_region": "string",
    "newbook_review_date": "string",
    "newbook_start_date": "string",
    "newbook_stop_date": "string",
    "opened_on": "string",
    "opening_time": "string",
    "physical_city": "string",
    "physical_country_id": "string",
    "physical_postcode": "string",
    "physical_state_id": "string",
    "physical_street": "string",
    "previous_supplier_id": "string",
    "read_only": "string",
    "sales_email": "string",
    "sales_fax": "string",
    "sales_phone": "string",
    "secure_login": "string",
    "software_type": "string",
    "status": "string",
    "survey_email": "string",
    "tax_id": "string",
    "tenant": "string",
    "time_format": "string",
    "total_bookings": "string",
    "trading_name": "string",
    "weather_station_code": "string",
    "website": "string"
}
    • schema_name_id: 2637
    • schema_scan_id: 6674373
    • updated: 2024-11-05 22:43:05
    • created: 2024-11-05 22:25:15
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `api_key`  string , `corporation_id`  string , `corporation_sync`  string , `duplicate_detection`  string , `tax_id`  string , `login_code`  string , `newbook_generic_url`  string , `weather_station_code`  string , `bom_radar_code`  string , `lat`  string , `long`  string , `name`  string , `trading_name`  string , `created_when`  string , `opened_on`  string , `newbook_contract_date`  string , `newbook_start_date`  string , `newbook_review_date`  string , `newbook_stop_date`  string , `physical_street`  string , `physical_city`  string , `physical_state_id`  string , `physical_postcode`  string , `physical_country_id`  string , `mailing_street`  string , `mailing_city`  string , `mailing_state_id`  string , `mailing_postcode`  string , `mailing_country_id`  string , `sales_email`  string , `sales_phone`  string , `sales_fax`  string , `admin_email`  string , `admin_phone`  string , `admin_fax`  string , `survey_email`  string , `error_email`  string , `contact_person`  string , `manager_name`  string , `opening_time`  string , `closing_time`  string , `checkin_time`  string , `checkout_time`  string , `date_format`  string , `time_format`  string , `website`  string , `allow_children`  string , `allow_infants`  string , `allow_animals`  string , `status`  string , `read_only`  string , `grace_period`  string , `firstrun`  string , `login_type`  string , `secure_login`  string , `default_client_account_id`  string , `base_license_account_id`  string , `additional_license_account_id`  string , `ewn_registration_key`  string , `facebook_page_id`  string , `instance_type`  string , `software_type`  string , `previous_supplier_id`  string , `migration_type`  string , `future_supplier_id`  string , `future_supplier_reason`  string , `individual_invoice`  string , `last_updated`  string , `total_bookings`  string , `last_booking_timestamp`  string , `last_booking_data`  string , `basic_information`  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_newbookinstances/2024-11-05/1730866313'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances/2024-11-05/1730866313
    • id: 4747761
    • processed: 1
    • raw_data: 
      {
    "additional_license_account_id": 60,
    "admin_email": 35,
    "admin_fax": 37,
    "admin_phone": 36,
    "allow_animals": 51,
    "allow_children": 49,
    "allow_infants": 50,
    "api_key": 3,
    "base_license_account_id": 59,
    "basic_information": 74,
    "bom_radar_code": 11,
    "checkin_time": 44,
    "checkout_time": 45,
    "closing_time": 43,
    "contact_person": 40,
    "corporation_id": 4,
    "corporation_sync": 5,
    "created_when": 16,
    "date_format": 46,
    "default_client_account_id": 58,
    "duplicate_detection": 6,
    "error_email": 39,
    "ewn_registration_key": 61,
    "facebook_page_id": 62,
    "firstrun": 55,
    "future_supplier_id": 67,
    "future_supplier_reason": 68,
    "grace_period": 54,
    "id": 2,
    "individual_invoice": 69,
    "instance_type": 63,
    "last_booking_data": 73,
    "last_booking_timestamp": 72,
    "last_updated": 70,
    "lat": 12,
    "login_code": 8,
    "login_type": 56,
    "long": 13,
    "mailing_city": 28,
    "mailing_country_id": 31,
    "mailing_postcode": 30,
    "mailing_state_id": 29,
    "mailing_street": 27,
    "manager_name": 41,
    "migration_type": 66,
    "name": 14,
    "newbook_contract_date": 18,
    "newbook_generic_url": 9,
    "newbook_region": 0,
    "newbook_review_date": 20,
    "newbook_start_date": 19,
    "newbook_stop_date": 21,
    "opened_on": 17,
    "opening_time": 42,
    "physical_city": 23,
    "physical_country_id": 26,
    "physical_postcode": 25,
    "physical_state_id": 24,
    "physical_street": 22,
    "previous_supplier_id": 65,
    "read_only": 53,
    "sales_email": 32,
    "sales_fax": 34,
    "sales_phone": 33,
    "secure_login": 57,
    "software_type": 64,
    "status": 52,
    "survey_email": 38,
    "tax_id": 7,
    "tenant": 1,
    "time_format": 47,
    "total_bookings": 71,
    "trading_name": 15,
    "weather_station_code": 10,
    "website": 48
}
    • schema_attributes: 
      {
    "additional_license_account_id": "string",
    "admin_email": "string",
    "admin_fax": "string",
    "admin_phone": "string",
    "allow_animals": "string",
    "allow_children": "string",
    "allow_infants": "string",
    "api_key": "string",
    "base_license_account_id": "string",
    "basic_information": "string",
    "bom_radar_code": "string",
    "checkin_time": "string",
    "checkout_time": "string",
    "closing_time": "string",
    "contact_person": "string",
    "corporation_id": "string",
    "corporation_sync": "string",
    "created_when": "string",
    "date_format": "string",
    "default_client_account_id": "string",
    "duplicate_detection": "string",
    "error_email": "string",
    "ewn_registration_key": "string",
    "facebook_page_id": "string",
    "firstrun": "string",
    "future_supplier_id": "string",
    "future_supplier_reason": "string",
    "grace_period": "string",
    "id": "string",
    "individual_invoice": "string",
    "instance_type": "string",
    "last_booking_data": "string",
    "last_booking_timestamp": "string",
    "last_updated": "string",
    "lat": "string",
    "login_code": "string",
    "login_type": "string",
    "long": "string",
    "mailing_city": "string",
    "mailing_country_id": "string",
    "mailing_postcode": "string",
    "mailing_state_id": "string",
    "mailing_street": "string",
    "manager_name": "string",
    "migration_type": "string",
    "name": "string",
    "newbook_contract_date": "string",
    "newbook_generic_url": "string",
    "newbook_region": "string",
    "newbook_review_date": "string",
    "newbook_start_date": "string",
    "newbook_stop_date": "string",
    "opened_on": "string",
    "opening_time": "string",
    "physical_city": "string",
    "physical_country_id": "string",
    "physical_postcode": "string",
    "physical_state_id": "string",
    "physical_street": "string",
    "previous_supplier_id": "string",
    "read_only": "string",
    "sales_email": "string",
    "sales_fax": "string",
    "sales_phone": "string",
    "secure_login": "string",
    "software_type": "string",
    "status": "string",
    "survey_email": "string",
    "tax_id": "string",
    "tenant": "string",
    "time_format": "string",
    "total_bookings": "string",
    "trading_name": "string",
    "weather_station_code": "string",
    "website": "string"
}
    • schema_name_id: 2637
    • schema_scan_id: 6673790
    • updated: 2024-11-05 22:25:26
    • created: 2024-11-05 04:31:46
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `api_key`  string , `corporation_id`  string , `corporation_sync`  string , `duplicate_detection`  string , `tax_id`  string , `login_code`  string , `newbook_generic_url`  string , `weather_station_code`  string , `bom_radar_code`  string , `lat`  string , `long`  string , `name`  string , `trading_name`  string , `created_when`  string , `opened_on`  string , `newbook_contract_date`  string , `newbook_start_date`  string , `newbook_review_date`  string , `newbook_stop_date`  string , `physical_street`  string , `physical_city`  string , `physical_state_id`  string , `physical_postcode`  string , `physical_country_id`  string , `mailing_street`  string , `mailing_city`  string , `mailing_state_id`  string , `mailing_postcode`  string , `mailing_country_id`  string , `sales_email`  string , `sales_phone`  string , `sales_fax`  string , `admin_email`  string , `admin_phone`  string , `admin_fax`  string , `survey_email`  string , `error_email`  string , `contact_person`  string , `manager_name`  string , `opening_time`  string , `closing_time`  string , `checkin_time`  string , `checkout_time`  string , `date_format`  string , `time_format`  string , `website`  string , `allow_children`  string , `allow_infants`  string , `allow_animals`  string , `status`  string , `read_only`  string , `grace_period`  string , `firstrun`  string , `login_type`  string , `secure_login`  string , `default_client_account_id`  string , `base_license_account_id`  string , `additional_license_account_id`  string , `ewn_registration_key`  string , `facebook_page_id`  string , `instance_type`  string , `software_type`  string , `previous_supplier_id`  string , `migration_type`  string , `future_supplier_id`  string , `future_supplier_reason`  string , `individual_invoice`  string , `last_updated`  string , `total_bookings`  string , `last_booking_timestamp`  string , `last_booking_data`  string , `basic_information`  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_newbookinstances/2024-11-04/1730785723'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances/2024-11-04/1730785723
    • id: 4746906
    • processed: 1
    • raw_data: 
      {
    "additional_license_account_id": 60,
    "admin_email": 35,
    "admin_fax": 37,
    "admin_phone": 36,
    "allow_animals": 51,
    "allow_children": 49,
    "allow_infants": 50,
    "api_key": 3,
    "base_license_account_id": 59,
    "basic_information": 74,
    "bom_radar_code": 11,
    "checkin_time": 44,
    "checkout_time": 45,
    "closing_time": 43,
    "contact_person": 40,
    "corporation_id": 4,
    "corporation_sync": 5,
    "created_when": 16,
    "date_format": 46,
    "default_client_account_id": 58,
    "duplicate_detection": 6,
    "error_email": 39,
    "ewn_registration_key": 61,
    "facebook_page_id": 62,
    "firstrun": 55,
    "future_supplier_id": 67,
    "future_supplier_reason": 68,
    "grace_period": 54,
    "id": 2,
    "individual_invoice": 69,
    "instance_type": 63,
    "last_booking_data": 73,
    "last_booking_timestamp": 72,
    "last_updated": 70,
    "lat": 12,
    "login_code": 8,
    "login_type": 56,
    "long": 13,
    "mailing_city": 28,
    "mailing_country_id": 31,
    "mailing_postcode": 30,
    "mailing_state_id": 29,
    "mailing_street": 27,
    "manager_name": 41,
    "migration_type": 66,
    "name": 14,
    "newbook_contract_date": 18,
    "newbook_generic_url": 9,
    "newbook_region": 0,
    "newbook_review_date": 20,
    "newbook_start_date": 19,
    "newbook_stop_date": 21,
    "opened_on": 17,
    "opening_time": 42,
    "physical_city": 23,
    "physical_country_id": 26,
    "physical_postcode": 25,
    "physical_state_id": 24,
    "physical_street": 22,
    "previous_supplier_id": 65,
    "read_only": 53,
    "sales_email": 32,
    "sales_fax": 34,
    "sales_phone": 33,
    "secure_login": 57,
    "software_type": 64,
    "status": 52,
    "survey_email": 38,
    "tax_id": 7,
    "tenant": 1,
    "time_format": 47,
    "total_bookings": 71,
    "trading_name": 15,
    "weather_station_code": 10,
    "website": 48
}
    • schema_attributes: 
      {
    "additional_license_account_id": "string",
    "admin_email": "string",
    "admin_fax": "string",
    "admin_phone": "string",
    "allow_animals": "string",
    "allow_children": "string",
    "allow_infants": "string",
    "api_key": "string",
    "base_license_account_id": "string",
    "basic_information": "string",
    "bom_radar_code": "string",
    "checkin_time": "string",
    "checkout_time": "string",
    "closing_time": "string",
    "contact_person": "string",
    "corporation_id": "string",
    "corporation_sync": "string",
    "created_when": "string",
    "date_format": "string",
    "default_client_account_id": "string",
    "duplicate_detection": "string",
    "error_email": "string",
    "ewn_registration_key": "string",
    "facebook_page_id": "string",
    "firstrun": "string",
    "future_supplier_id": "string",
    "future_supplier_reason": "string",
    "grace_period": "string",
    "id": "string",
    "individual_invoice": "string",
    "instance_type": "string",
    "last_booking_data": "string",
    "last_booking_timestamp": "string",
    "last_updated": "string",
    "lat": "string",
    "login_code": "string",
    "login_type": "string",
    "long": "string",
    "mailing_city": "string",
    "mailing_country_id": "string",
    "mailing_postcode": "string",
    "mailing_state_id": "string",
    "mailing_street": "string",
    "manager_name": "string",
    "migration_type": "string",
    "name": "string",
    "newbook_contract_date": "string",
    "newbook_generic_url": "string",
    "newbook_region": "string",
    "newbook_review_date": "string",
    "newbook_start_date": "string",
    "newbook_stop_date": "string",
    "opened_on": "string",
    "opening_time": "string",
    "physical_city": "string",
    "physical_country_id": "string",
    "physical_postcode": "string",
    "physical_state_id": "string",
    "physical_street": "string",
    "previous_supplier_id": "string",
    "read_only": "string",
    "sales_email": "string",
    "sales_fax": "string",
    "sales_phone": "string",
    "secure_login": "string",
    "software_type": "string",
    "status": "string",
    "survey_email": "string",
    "tax_id": "string",
    "tenant": "string",
    "time_format": "string",
    "total_bookings": "string",
    "trading_name": "string",
    "weather_station_code": "string",
    "website": "string"
}
    • schema_name_id: 2637
    • schema_scan_id: 6672137
    • updated: 2024-11-05 04:31:57
    • created: 2024-11-05 03:29:58
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `api_key`  string , `corporation_id`  string , `corporation_sync`  string , `duplicate_detection`  string , `tax_id`  string , `login_code`  string , `newbook_generic_url`  string , `weather_station_code`  string , `bom_radar_code`  string , `lat`  string , `long`  string , `name`  string , `trading_name`  string , `created_when`  string , `opened_on`  string , `newbook_contract_date`  string , `newbook_start_date`  string , `newbook_review_date`  string , `newbook_stop_date`  string , `physical_street`  string , `physical_city`  string , `physical_state_id`  string , `physical_postcode`  string , `physical_country_id`  string , `mailing_street`  string , `mailing_city`  string , `mailing_state_id`  string , `mailing_postcode`  string , `mailing_country_id`  string , `sales_email`  string , `sales_phone`  string , `sales_fax`  string , `admin_email`  string , `admin_phone`  string , `admin_fax`  string , `survey_email`  string , `error_email`  string , `contact_person`  string , `manager_name`  string , `opening_time`  string , `closing_time`  string , `checkin_time`  string , `checkout_time`  string , `date_format`  string , `time_format`  string , `website`  string , `allow_children`  string , `allow_infants`  string , `allow_animals`  string , `status`  string , `read_only`  string , `grace_period`  string , `firstrun`  string , `login_type`  string , `secure_login`  string , `default_client_account_id`  string , `base_license_account_id`  string , `additional_license_account_id`  string , `ewn_registration_key`  string , `facebook_page_id`  string , `instance_type`  string , `software_type`  string , `previous_supplier_id`  string , `migration_type`  string , `future_supplier_id`  string , `future_supplier_reason`  string , `individual_invoice`  string , `last_updated`  string , `total_bookings`  string , `last_booking_timestamp`  string , `last_booking_data`  string , `basic_information`  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_newbookinstances/2024-11-04/1730784821'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances/2024-11-04/1730784821
    • id: 4745460
    • processed: 1
    • raw_data: 
      {
    "additional_license_account_id": 60,
    "admin_email": 35,
    "admin_fax": 37,
    "admin_phone": 36,
    "allow_animals": 51,
    "allow_children": 49,
    "allow_infants": 50,
    "api_key": 3,
    "base_license_account_id": 59,
    "basic_information": 74,
    "bom_radar_code": 11,
    "checkin_time": 44,
    "checkout_time": 45,
    "closing_time": 43,
    "contact_person": 40,
    "corporation_id": 4,
    "corporation_sync": 5,
    "created_when": 16,
    "date_format": 46,
    "default_client_account_id": 58,
    "duplicate_detection": 6,
    "error_email": 39,
    "ewn_registration_key": 61,
    "facebook_page_id": 62,
    "firstrun": 55,
    "future_supplier_id": 67,
    "future_supplier_reason": 68,
    "grace_period": 54,
    "id": 2,
    "individual_invoice": 69,
    "instance_type": 63,
    "last_booking_data": 73,
    "last_booking_timestamp": 72,
    "last_updated": 70,
    "lat": 12,
    "login_code": 8,
    "login_type": 56,
    "long": 13,
    "mailing_city": 28,
    "mailing_country_id": 31,
    "mailing_postcode": 30,
    "mailing_state_id": 29,
    "mailing_street": 27,
    "manager_name": 41,
    "migration_type": 66,
    "name": 14,
    "newbook_contract_date": 18,
    "newbook_generic_url": 9,
    "newbook_region": 0,
    "newbook_review_date": 20,
    "newbook_start_date": 19,
    "newbook_stop_date": 21,
    "opened_on": 17,
    "opening_time": 42,
    "physical_city": 23,
    "physical_country_id": 26,
    "physical_postcode": 25,
    "physical_state_id": 24,
    "physical_street": 22,
    "previous_supplier_id": 65,
    "read_only": 53,
    "sales_email": 32,
    "sales_fax": 34,
    "sales_phone": 33,
    "secure_login": 57,
    "software_type": 64,
    "status": 52,
    "survey_email": 38,
    "tax_id": 7,
    "tenant": 1,
    "time_format": 47,
    "total_bookings": 71,
    "trading_name": 15,
    "weather_station_code": 10,
    "website": 48
}
    • schema_attributes: 
      {
    "additional_license_account_id": "string",
    "admin_email": "string",
    "admin_fax": "string",
    "admin_phone": "string",
    "allow_animals": "string",
    "allow_children": "string",
    "allow_infants": "string",
    "api_key": "string",
    "base_license_account_id": "string",
    "basic_information": "string",
    "bom_radar_code": "string",
    "checkin_time": "string",
    "checkout_time": "string",
    "closing_time": "string",
    "contact_person": "string",
    "corporation_id": "string",
    "corporation_sync": "string",
    "created_when": "string",
    "date_format": "string",
    "default_client_account_id": "string",
    "duplicate_detection": "string",
    "error_email": "string",
    "ewn_registration_key": "string",
    "facebook_page_id": "string",
    "firstrun": "string",
    "future_supplier_id": "string",
    "future_supplier_reason": "string",
    "grace_period": "string",
    "id": "string",
    "individual_invoice": "string",
    "instance_type": "string",
    "last_booking_data": "string",
    "last_booking_timestamp": "string",
    "last_updated": "string",
    "lat": "string",
    "login_code": "string",
    "login_type": "string",
    "long": "string",
    "mailing_city": "string",
    "mailing_country_id": "string",
    "mailing_postcode": "string",
    "mailing_state_id": "string",
    "mailing_street": "string",
    "manager_name": "string",
    "migration_type": "string",
    "name": "string",
    "newbook_contract_date": "string",
    "newbook_generic_url": "string",
    "newbook_region": "string",
    "newbook_review_date": "string",
    "newbook_start_date": "string",
    "newbook_stop_date": "string",
    "opened_on": "string",
    "opening_time": "string",
    "physical_city": "string",
    "physical_country_id": "string",
    "physical_postcode": "string",
    "physical_state_id": "string",
    "physical_street": "string",
    "previous_supplier_id": "string",
    "read_only": "string",
    "sales_email": "string",
    "sales_fax": "string",
    "sales_phone": "string",
    "secure_login": "string",
    "software_type": "string",
    "status": "string",
    "survey_email": "string",
    "tax_id": "string",
    "tenant": "string",
    "time_format": "string",
    "total_bookings": "string",
    "trading_name": "string",
    "weather_station_code": "string",
    "website": "string"
}
    • schema_name_id: 2637
    • schema_scan_id: 6670675
    • updated: 2024-11-05 03:30:12
    • created: 2024-11-05 03:29:38
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `api_key`  string , `corporation_id`  string , `corporation_sync`  string , `duplicate_detection`  string , `tax_id`  string , `login_code`  string , `newbook_generic_url`  string , `weather_station_code`  string , `bom_radar_code`  string , `lat`  string , `long`  string , `name`  string , `trading_name`  string , `created_when`  string , `opened_on`  string , `newbook_contract_date`  string , `newbook_start_date`  string , `newbook_review_date`  string , `newbook_stop_date`  string , `physical_street`  string , `physical_city`  string , `physical_state_id`  string , `physical_postcode`  string , `physical_country_id`  string , `mailing_street`  string , `mailing_city`  string , `mailing_state_id`  string , `mailing_postcode`  string , `mailing_country_id`  string , `sales_email`  string , `sales_phone`  string , `sales_fax`  string , `admin_email`  string , `admin_phone`  string , `admin_fax`  string , `survey_email`  string , `error_email`  string , `contact_person`  string , `manager_name`  string , `opening_time`  string , `closing_time`  string , `checkin_time`  string , `checkout_time`  string , `date_format`  string , `time_format`  string , `website`  string , `allow_children`  string , `allow_infants`  string , `allow_animals`  string , `status`  string , `read_only`  string , `grace_period`  string , `firstrun`  string , `login_type`  string , `secure_login`  string , `default_client_account_id`  string , `base_license_account_id`  string , `additional_license_account_id`  string , `ewn_registration_key`  string , `facebook_page_id`  string , `instance_type`  string , `software_type`  string , `previous_supplier_id`  string , `migration_type`  string , `future_supplier_id`  string , `future_supplier_reason`  string , `individual_invoice`  string , `last_updated`  string , `total_bookings`  string , `last_booking_timestamp`  string , `last_booking_data`  string , `basic_information`  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_newbookinstances/2024-11-04/1730785126'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances/2024-11-04/1730785126
    • id: 4745446
    • processed: 1
    • raw_data: 
      {
    "additional_license_account_id": 60,
    "admin_email": 35,
    "admin_fax": 37,
    "admin_phone": 36,
    "allow_animals": 51,
    "allow_children": 49,
    "allow_infants": 50,
    "api_key": 3,
    "base_license_account_id": 59,
    "basic_information": 74,
    "bom_radar_code": 11,
    "checkin_time": 44,
    "checkout_time": 45,
    "closing_time": 43,
    "contact_person": 40,
    "corporation_id": 4,
    "corporation_sync": 5,
    "created_when": 16,
    "date_format": 46,
    "default_client_account_id": 58,
    "duplicate_detection": 6,
    "error_email": 39,
    "ewn_registration_key": 61,
    "facebook_page_id": 62,
    "firstrun": 55,
    "future_supplier_id": 67,
    "future_supplier_reason": 68,
    "grace_period": 54,
    "id": 2,
    "individual_invoice": 69,
    "instance_type": 63,
    "last_booking_data": 73,
    "last_booking_timestamp": 72,
    "last_updated": 70,
    "lat": 12,
    "login_code": 8,
    "login_type": 56,
    "long": 13,
    "mailing_city": 28,
    "mailing_country_id": 31,
    "mailing_postcode": 30,
    "mailing_state_id": 29,
    "mailing_street": 27,
    "manager_name": 41,
    "migration_type": 66,
    "name": 14,
    "newbook_contract_date": 18,
    "newbook_generic_url": 9,
    "newbook_region": 0,
    "newbook_review_date": 20,
    "newbook_start_date": 19,
    "newbook_stop_date": 21,
    "opened_on": 17,
    "opening_time": 42,
    "physical_city": 23,
    "physical_country_id": 26,
    "physical_postcode": 25,
    "physical_state_id": 24,
    "physical_street": 22,
    "previous_supplier_id": 65,
    "read_only": 53,
    "sales_email": 32,
    "sales_fax": 34,
    "sales_phone": 33,
    "secure_login": 57,
    "software_type": 64,
    "status": 52,
    "survey_email": 38,
    "tax_id": 7,
    "tenant": 1,
    "time_format": 47,
    "total_bookings": 71,
    "trading_name": 15,
    "weather_station_code": 10,
    "website": 48
}
    • schema_attributes: 
      {
    "additional_license_account_id": "string",
    "admin_email": "string",
    "admin_fax": "string",
    "admin_phone": "string",
    "allow_animals": "string",
    "allow_children": "string",
    "allow_infants": "string",
    "api_key": "string",
    "base_license_account_id": "string",
    "basic_information": "string",
    "bom_radar_code": "string",
    "checkin_time": "string",
    "checkout_time": "string",
    "closing_time": "string",
    "contact_person": "string",
    "corporation_id": "string",
    "corporation_sync": "string",
    "created_when": "string",
    "date_format": "string",
    "default_client_account_id": "string",
    "duplicate_detection": "string",
    "error_email": "string",
    "ewn_registration_key": "string",
    "facebook_page_id": "string",
    "firstrun": "string",
    "future_supplier_id": "string",
    "future_supplier_reason": "string",
    "grace_period": "string",
    "id": "string",
    "individual_invoice": "string",
    "instance_type": "string",
    "last_booking_data": "string",
    "last_booking_timestamp": "string",
    "last_updated": "string",
    "lat": "string",
    "login_code": "string",
    "login_type": "string",
    "long": "string",
    "mailing_city": "string",
    "mailing_country_id": "string",
    "mailing_postcode": "string",
    "mailing_state_id": "string",
    "mailing_street": "string",
    "manager_name": "string",
    "migration_type": "string",
    "name": "string",
    "newbook_contract_date": "string",
    "newbook_generic_url": "string",
    "newbook_region": "string",
    "newbook_review_date": "string",
    "newbook_start_date": "string",
    "newbook_stop_date": "string",
    "opened_on": "string",
    "opening_time": "string",
    "physical_city": "string",
    "physical_country_id": "string",
    "physical_postcode": "string",
    "physical_state_id": "string",
    "physical_street": "string",
    "previous_supplier_id": "string",
    "read_only": "string",
    "sales_email": "string",
    "sales_fax": "string",
    "sales_phone": "string",
    "secure_login": "string",
    "software_type": "string",
    "status": "string",
    "survey_email": "string",
    "tax_id": "string",
    "tenant": "string",
    "time_format": "string",
    "total_bookings": "string",
    "trading_name": "string",
    "weather_station_code": "string",
    "website": "string"
}
    • schema_name_id: 2637
    • schema_scan_id: 6670663
    • updated: 2024-11-05 03:29:52
    • created: 2024-11-05 03:22:50
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `api_key`  string , `corporation_id`  string , `corporation_sync`  string , `duplicate_detection`  string , `tax_id`  string , `login_code`  string , `newbook_generic_url`  string , `weather_station_code`  string , `bom_radar_code`  string , `lat`  string , `long`  string , `name`  string , `trading_name`  string , `created_when`  string , `opened_on`  string , `newbook_contract_date`  string , `newbook_start_date`  string , `newbook_review_date`  string , `newbook_stop_date`  string , `physical_street`  string , `physical_city`  string , `physical_state_id`  string , `physical_postcode`  string , `physical_country_id`  string , `mailing_street`  string , `mailing_city`  string , `mailing_state_id`  string , `mailing_postcode`  string , `mailing_country_id`  string , `sales_email`  string , `sales_phone`  string , `sales_fax`  string , `admin_email`  string , `admin_phone`  string , `admin_fax`  string , `survey_email`  string , `error_email`  string , `contact_person`  string , `manager_name`  string , `opening_time`  string , `closing_time`  string , `checkin_time`  string , `checkout_time`  string , `date_format`  string , `time_format`  string , `website`  string , `allow_children`  string , `allow_infants`  string , `allow_animals`  string , `status`  string , `read_only`  string , `grace_period`  string , `firstrun`  string , `login_type`  string , `secure_login`  string , `default_client_account_id`  string , `base_license_account_id`  string , `additional_license_account_id`  string , `ewn_registration_key`  string , `facebook_page_id`  string , `instance_type`  string , `software_type`  string , `previous_supplier_id`  string , `migration_type`  string , `future_supplier_id`  string , `future_supplier_reason`  string , `individual_invoice`  string , `last_updated`  string , `total_bookings`  string , `last_booking_timestamp`  string , `last_booking_data`  string , `basic_information`  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_newbookinstances/2024-11-04/1730784217'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances/2024-11-04/1730784217
    • id: 4745186
    • processed: 1
    • raw_data: 
      {
    "additional_license_account_id": 60,
    "admin_email": 35,
    "admin_fax": 37,
    "admin_phone": 36,
    "allow_animals": 51,
    "allow_children": 49,
    "allow_infants": 50,
    "api_key": 3,
    "base_license_account_id": 59,
    "basic_information": 74,
    "bom_radar_code": 11,
    "checkin_time": 44,
    "checkout_time": 45,
    "closing_time": 43,
    "contact_person": 40,
    "corporation_id": 4,
    "corporation_sync": 5,
    "created_when": 16,
    "date_format": 46,
    "default_client_account_id": 58,
    "duplicate_detection": 6,
    "error_email": 39,
    "ewn_registration_key": 61,
    "facebook_page_id": 62,
    "firstrun": 55,
    "future_supplier_id": 67,
    "future_supplier_reason": 68,
    "grace_period": 54,
    "id": 2,
    "individual_invoice": 69,
    "instance_type": 63,
    "last_booking_data": 73,
    "last_booking_timestamp": 72,
    "last_updated": 70,
    "lat": 12,
    "login_code": 8,
    "login_type": 56,
    "long": 13,
    "mailing_city": 28,
    "mailing_country_id": 31,
    "mailing_postcode": 30,
    "mailing_state_id": 29,
    "mailing_street": 27,
    "manager_name": 41,
    "migration_type": 66,
    "name": 14,
    "newbook_contract_date": 18,
    "newbook_generic_url": 9,
    "newbook_region": 0,
    "newbook_review_date": 20,
    "newbook_start_date": 19,
    "newbook_stop_date": 21,
    "opened_on": 17,
    "opening_time": 42,
    "physical_city": 23,
    "physical_country_id": 26,
    "physical_postcode": 25,
    "physical_state_id": 24,
    "physical_street": 22,
    "previous_supplier_id": 65,
    "read_only": 53,
    "sales_email": 32,
    "sales_fax": 34,
    "sales_phone": 33,
    "secure_login": 57,
    "software_type": 64,
    "status": 52,
    "survey_email": 38,
    "tax_id": 7,
    "tenant": 1,
    "time_format": 47,
    "total_bookings": 71,
    "trading_name": 15,
    "weather_station_code": 10,
    "website": 48
}
    • schema_attributes: 
      {
    "additional_license_account_id": "string",
    "admin_email": "string",
    "admin_fax": "string",
    "admin_phone": "string",
    "allow_animals": "string",
    "allow_children": "string",
    "allow_infants": "string",
    "api_key": "string",
    "base_license_account_id": "string",
    "basic_information": "string",
    "bom_radar_code": "string",
    "checkin_time": "string",
    "checkout_time": "string",
    "closing_time": "string",
    "contact_person": "string",
    "corporation_id": "string",
    "corporation_sync": "string",
    "created_when": "string",
    "date_format": "string",
    "default_client_account_id": "string",
    "duplicate_detection": "string",
    "error_email": "string",
    "ewn_registration_key": "string",
    "facebook_page_id": "string",
    "firstrun": "string",
    "future_supplier_id": "string",
    "future_supplier_reason": "string",
    "grace_period": "string",
    "id": "string",
    "individual_invoice": "string",
    "instance_type": "string",
    "last_booking_data": "string",
    "last_booking_timestamp": "string",
    "last_updated": "string",
    "lat": "string",
    "login_code": "string",
    "login_type": "string",
    "long": "string",
    "mailing_city": "string",
    "mailing_country_id": "string",
    "mailing_postcode": "string",
    "mailing_state_id": "string",
    "mailing_street": "string",
    "manager_name": "string",
    "migration_type": "string",
    "name": "string",
    "newbook_contract_date": "string",
    "newbook_generic_url": "string",
    "newbook_region": "string",
    "newbook_review_date": "string",
    "newbook_start_date": "string",
    "newbook_stop_date": "string",
    "opened_on": "string",
    "opening_time": "string",
    "physical_city": "string",
    "physical_country_id": "string",
    "physical_postcode": "string",
    "physical_state_id": "string",
    "physical_street": "string",
    "previous_supplier_id": "string",
    "read_only": "string",
    "sales_email": "string",
    "sales_fax": "string",
    "sales_phone": "string",
    "secure_login": "string",
    "software_type": "string",
    "status": "string",
    "survey_email": "string",
    "tax_id": "string",
    "tenant": "string",
    "time_format": "string",
    "total_bookings": "string",
    "trading_name": "string",
    "weather_station_code": "string",
    "website": "string"
}
    • schema_name_id: 2637
    • schema_scan_id: 6670401
    • updated: 2024-11-05 03:23:01
    • created: 2024-11-05 02:41:54
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `api_key`  string , `corporation_id`  string , `corporation_sync`  string , `duplicate_detection`  string , `tax_id`  string , `login_code`  string , `newbook_generic_url`  string , `weather_station_code`  string , `bom_radar_code`  string , `lat`  string , `long`  string , `name`  string , `trading_name`  string , `created_when`  string , `opened_on`  string , `newbook_contract_date`  string , `newbook_start_date`  string , `newbook_review_date`  string , `newbook_stop_date`  string , `physical_street`  string , `physical_city`  string , `physical_state_id`  string , `physical_postcode`  string , `physical_country_id`  string , `mailing_street`  string , `mailing_city`  string , `mailing_state_id`  string , `mailing_postcode`  string , `mailing_country_id`  string , `sales_email`  string , `sales_phone`  string , `sales_fax`  string , `admin_email`  string , `admin_phone`  string , `admin_fax`  string , `survey_email`  string , `error_email`  string , `contact_person`  string , `manager_name`  string , `opening_time`  string , `closing_time`  string , `checkin_time`  string , `checkout_time`  string , `date_format`  string , `time_format`  string , `website`  string , `allow_children`  string , `allow_infants`  string , `allow_animals`  string , `status`  string , `read_only`  string , `grace_period`  string , `firstrun`  string , `login_type`  string , `secure_login`  string , `default_client_account_id`  string , `base_license_account_id`  string , `additional_license_account_id`  string , `ewn_registration_key`  string , `facebook_page_id`  string , `instance_type`  string , `software_type`  string , `previous_supplier_id`  string , `migration_type`  string , `future_supplier_id`  string , `future_supplier_reason`  string , `individual_invoice`  string , `last_updated`  string , `total_bookings`  string , `last_booking_timestamp`  string , `last_booking_data`  string , `basic_information`  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_newbookinstances/2024-11-04/1730783900'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances/2024-11-04/1730783900
    • id: 4743637
    • processed: 1
    • raw_data: 
      {
    "additional_license_account_id": 60,
    "admin_email": 35,
    "admin_fax": 37,
    "admin_phone": 36,
    "allow_animals": 51,
    "allow_children": 49,
    "allow_infants": 50,
    "api_key": 3,
    "base_license_account_id": 59,
    "basic_information": 74,
    "bom_radar_code": 11,
    "checkin_time": 44,
    "checkout_time": 45,
    "closing_time": 43,
    "contact_person": 40,
    "corporation_id": 4,
    "corporation_sync": 5,
    "created_when": 16,
    "date_format": 46,
    "default_client_account_id": 58,
    "duplicate_detection": 6,
    "error_email": 39,
    "ewn_registration_key": 61,
    "facebook_page_id": 62,
    "firstrun": 55,
    "future_supplier_id": 67,
    "future_supplier_reason": 68,
    "grace_period": 54,
    "id": 2,
    "individual_invoice": 69,
    "instance_type": 63,
    "last_booking_data": 73,
    "last_booking_timestamp": 72,
    "last_updated": 70,
    "lat": 12,
    "login_code": 8,
    "login_type": 56,
    "long": 13,
    "mailing_city": 28,
    "mailing_country_id": 31,
    "mailing_postcode": 30,
    "mailing_state_id": 29,
    "mailing_street": 27,
    "manager_name": 41,
    "migration_type": 66,
    "name": 14,
    "newbook_contract_date": 18,
    "newbook_generic_url": 9,
    "newbook_region": 0,
    "newbook_review_date": 20,
    "newbook_start_date": 19,
    "newbook_stop_date": 21,
    "opened_on": 17,
    "opening_time": 42,
    "physical_city": 23,
    "physical_country_id": 26,
    "physical_postcode": 25,
    "physical_state_id": 24,
    "physical_street": 22,
    "previous_supplier_id": 65,
    "read_only": 53,
    "sales_email": 32,
    "sales_fax": 34,
    "sales_phone": 33,
    "secure_login": 57,
    "software_type": 64,
    "status": 52,
    "survey_email": 38,
    "tax_id": 7,
    "tenant": 1,
    "time_format": 47,
    "total_bookings": 71,
    "trading_name": 15,
    "weather_station_code": 10,
    "website": 48
}
    • schema_attributes: 
      {
    "additional_license_account_id": "string",
    "admin_email": "string",
    "admin_fax": "string",
    "admin_phone": "string",
    "allow_animals": "string",
    "allow_children": "string",
    "allow_infants": "string",
    "api_key": "string",
    "base_license_account_id": "string",
    "basic_information": "string",
    "bom_radar_code": "string",
    "checkin_time": "string",
    "checkout_time": "string",
    "closing_time": "string",
    "contact_person": "string",
    "corporation_id": "string",
    "corporation_sync": "string",
    "created_when": "string",
    "date_format": "string",
    "default_client_account_id": "string",
    "duplicate_detection": "string",
    "error_email": "string",
    "ewn_registration_key": "string",
    "facebook_page_id": "string",
    "firstrun": "string",
    "future_supplier_id": "string",
    "future_supplier_reason": "string",
    "grace_period": "string",
    "id": "string",
    "individual_invoice": "string",
    "instance_type": "string",
    "last_booking_data": "string",
    "last_booking_timestamp": "string",
    "last_updated": "string",
    "lat": "string",
    "login_code": "string",
    "login_type": "string",
    "long": "string",
    "mailing_city": "string",
    "mailing_country_id": "string",
    "mailing_postcode": "string",
    "mailing_state_id": "string",
    "mailing_street": "string",
    "manager_name": "string",
    "migration_type": "string",
    "name": "string",
    "newbook_contract_date": "string",
    "newbook_generic_url": "string",
    "newbook_region": "string",
    "newbook_review_date": "string",
    "newbook_start_date": "string",
    "newbook_stop_date": "string",
    "opened_on": "string",
    "opening_time": "string",
    "physical_city": "string",
    "physical_country_id": "string",
    "physical_postcode": "string",
    "physical_state_id": "string",
    "physical_street": "string",
    "previous_supplier_id": "string",
    "read_only": "string",
    "sales_email": "string",
    "sales_fax": "string",
    "sales_phone": "string",
    "secure_login": "string",
    "software_type": "string",
    "status": "string",
    "survey_email": "string",
    "tax_id": "string",
    "tenant": "string",
    "time_format": "string",
    "total_bookings": "string",
    "trading_name": "string",
    "weather_station_code": "string",
    "website": "string"
}
    • schema_name_id: 2637
    • schema_scan_id: 6668853
    • updated: 2024-11-05 02:42:05
    • created: 2024-11-05 02:35:26
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `api_key`  string , `corporation_id`  string , `corporation_sync`  string , `duplicate_detection`  string , `tax_id`  string , `login_code`  string , `newbook_generic_url`  string , `weather_station_code`  string , `bom_radar_code`  string , `lat`  string , `long`  string , `name`  string , `trading_name`  string , `created_when`  string , `opened_on`  string , `newbook_contract_date`  string , `newbook_start_date`  string , `newbook_review_date`  string , `newbook_stop_date`  string , `physical_street`  string , `physical_city`  string , `physical_state_id`  string , `physical_postcode`  string , `physical_country_id`  string , `mailing_street`  string , `mailing_city`  string , `mailing_state_id`  string , `mailing_postcode`  string , `mailing_country_id`  string , `sales_email`  string , `sales_phone`  string , `sales_fax`  string , `admin_email`  string , `admin_phone`  string , `admin_fax`  string , `survey_email`  string , `error_email`  string , `contact_person`  string , `manager_name`  string , `opening_time`  string , `closing_time`  string , `checkin_time`  string , `checkout_time`  string , `date_format`  string , `time_format`  string , `website`  string , `allow_children`  string , `allow_infants`  string , `allow_animals`  string , `status`  string , `read_only`  string , `grace_period`  string , `firstrun`  string , `login_type`  string , `secure_login`  string , `default_client_account_id`  string , `base_license_account_id`  string , `additional_license_account_id`  string , `ewn_registration_key`  string , `facebook_page_id`  string , `instance_type`  string , `software_type`  string , `previous_supplier_id`  string , `migration_type`  string , `future_supplier_id`  string , `future_supplier_reason`  string , `individual_invoice`  string , `last_updated`  string , `total_bookings`  string , `last_booking_timestamp`  string , `last_booking_data`  string , `basic_information`  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_newbookinstances/2024-11-04/1730784055'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances/2024-11-04/1730784055
    • id: 4743394
    • processed: 1
    • raw_data: 
      {
    "additional_license_account_id": 60,
    "admin_email": 35,
    "admin_fax": 37,
    "admin_phone": 36,
    "allow_animals": 51,
    "allow_children": 49,
    "allow_infants": 50,
    "api_key": 3,
    "base_license_account_id": 59,
    "basic_information": 74,
    "bom_radar_code": 11,
    "checkin_time": 44,
    "checkout_time": 45,
    "closing_time": 43,
    "contact_person": 40,
    "corporation_id": 4,
    "corporation_sync": 5,
    "created_when": 16,
    "date_format": 46,
    "default_client_account_id": 58,
    "duplicate_detection": 6,
    "error_email": 39,
    "ewn_registration_key": 61,
    "facebook_page_id": 62,
    "firstrun": 55,
    "future_supplier_id": 67,
    "future_supplier_reason": 68,
    "grace_period": 54,
    "id": 2,
    "individual_invoice": 69,
    "instance_type": 63,
    "last_booking_data": 73,
    "last_booking_timestamp": 72,
    "last_updated": 70,
    "lat": 12,
    "login_code": 8,
    "login_type": 56,
    "long": 13,
    "mailing_city": 28,
    "mailing_country_id": 31,
    "mailing_postcode": 30,
    "mailing_state_id": 29,
    "mailing_street": 27,
    "manager_name": 41,
    "migration_type": 66,
    "name": 14,
    "newbook_contract_date": 18,
    "newbook_generic_url": 9,
    "newbook_region": 0,
    "newbook_review_date": 20,
    "newbook_start_date": 19,
    "newbook_stop_date": 21,
    "opened_on": 17,
    "opening_time": 42,
    "physical_city": 23,
    "physical_country_id": 26,
    "physical_postcode": 25,
    "physical_state_id": 24,
    "physical_street": 22,
    "previous_supplier_id": 65,
    "read_only": 53,
    "sales_email": 32,
    "sales_fax": 34,
    "sales_phone": 33,
    "secure_login": 57,
    "software_type": 64,
    "status": 52,
    "survey_email": 38,
    "tax_id": 7,
    "tenant": 1,
    "time_format": 47,
    "total_bookings": 71,
    "trading_name": 15,
    "weather_station_code": 10,
    "website": 48
}
    • schema_attributes: 
      {
    "additional_license_account_id": "string",
    "admin_email": "string",
    "admin_fax": "string",
    "admin_phone": "string",
    "allow_animals": "string",
    "allow_children": "string",
    "allow_infants": "string",
    "api_key": "string",
    "base_license_account_id": "string",
    "basic_information": "string",
    "bom_radar_code": "string",
    "checkin_time": "string",
    "checkout_time": "string",
    "closing_time": "string",
    "contact_person": "string",
    "corporation_id": "string",
    "corporation_sync": "string",
    "created_when": "string",
    "date_format": "string",
    "default_client_account_id": "string",
    "duplicate_detection": "string",
    "error_email": "string",
    "ewn_registration_key": "string",
    "facebook_page_id": "string",
    "firstrun": "string",
    "future_supplier_id": "string",
    "future_supplier_reason": "string",
    "grace_period": "string",
    "id": "string",
    "individual_invoice": "string",
    "instance_type": "string",
    "last_booking_data": "string",
    "last_booking_timestamp": "string",
    "last_updated": "string",
    "lat": "string",
    "login_code": "string",
    "login_type": "string",
    "long": "string",
    "mailing_city": "string",
    "mailing_country_id": "string",
    "mailing_postcode": "string",
    "mailing_state_id": "string",
    "mailing_street": "string",
    "manager_name": "string",
    "migration_type": "string",
    "name": "string",
    "newbook_contract_date": "string",
    "newbook_generic_url": "string",
    "newbook_region": "string",
    "newbook_review_date": "string",
    "newbook_start_date": "string",
    "newbook_stop_date": "string",
    "opened_on": "string",
    "opening_time": "string",
    "physical_city": "string",
    "physical_country_id": "string",
    "physical_postcode": "string",
    "physical_state_id": "string",
    "physical_street": "string",
    "previous_supplier_id": "string",
    "read_only": "string",
    "sales_email": "string",
    "sales_fax": "string",
    "sales_phone": "string",
    "secure_login": "string",
    "software_type": "string",
    "status": "string",
    "survey_email": "string",
    "tax_id": "string",
    "tenant": "string",
    "time_format": "string",
    "total_bookings": "string",
    "trading_name": "string",
    "weather_station_code": "string",
    "website": "string"
}
    • schema_name_id: 2637
    • schema_scan_id: 6668608
    • updated: 2024-11-05 02:35:39
    • created: 2024-11-05 02:13:38
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `api_key`  string , `corporation_id`  string , `corporation_sync`  string , `duplicate_detection`  string , `tax_id`  string , `login_code`  string , `newbook_generic_url`  string , `weather_station_code`  string , `bom_radar_code`  string , `lat`  string , `long`  string , `name`  string , `trading_name`  string , `created_when`  string , `opened_on`  string , `newbook_contract_date`  string , `newbook_start_date`  string , `newbook_review_date`  string , `newbook_stop_date`  string , `physical_street`  string , `physical_city`  string , `physical_state_id`  string , `physical_postcode`  string , `physical_country_id`  string , `mailing_street`  string , `mailing_city`  string , `mailing_state_id`  string , `mailing_postcode`  string , `mailing_country_id`  string , `sales_email`  string , `sales_phone`  string , `sales_fax`  string , `admin_email`  string , `admin_phone`  string , `admin_fax`  string , `survey_email`  string , `error_email`  string , `contact_person`  string , `manager_name`  string , `opening_time`  string , `closing_time`  string , `checkin_time`  string , `checkout_time`  string , `date_format`  string , `time_format`  string , `website`  string , `allow_children`  string , `allow_infants`  string , `allow_animals`  string , `status`  string , `read_only`  string , `grace_period`  string , `firstrun`  string , `login_type`  string , `secure_login`  string , `default_client_account_id`  string , `base_license_account_id`  string , `additional_license_account_id`  string , `ewn_registration_key`  string , `facebook_page_id`  string , `instance_type`  string , `software_type`  string , `previous_supplier_id`  string , `migration_type`  string , `future_supplier_id`  string , `future_supplier_reason`  string , `individual_invoice`  string , `last_updated`  string , `total_bookings`  string , `last_booking_timestamp`  string , `last_booking_data`  string , `basic_information`  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_newbookinstances/2024-11-04/1730783768'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances/2024-11-04/1730783768
    • id: 4742565
    • processed: 1
    • raw_data: 
      {
    "additional_license_account_id": 60,
    "admin_email": 35,
    "admin_fax": 37,
    "admin_phone": 36,
    "allow_animals": 51,
    "allow_children": 49,
    "allow_infants": 50,
    "api_key": 3,
    "base_license_account_id": 59,
    "basic_information": 74,
    "bom_radar_code": 11,
    "checkin_time": 44,
    "checkout_time": 45,
    "closing_time": 43,
    "contact_person": 40,
    "corporation_id": 4,
    "corporation_sync": 5,
    "created_when": 16,
    "date_format": 46,
    "default_client_account_id": 58,
    "duplicate_detection": 6,
    "error_email": 39,
    "ewn_registration_key": 61,
    "facebook_page_id": 62,
    "firstrun": 55,
    "future_supplier_id": 67,
    "future_supplier_reason": 68,
    "grace_period": 54,
    "id": 2,
    "individual_invoice": 69,
    "instance_type": 63,
    "last_booking_data": 73,
    "last_booking_timestamp": 72,
    "last_updated": 70,
    "lat": 12,
    "login_code": 8,
    "login_type": 56,
    "long": 13,
    "mailing_city": 28,
    "mailing_country_id": 31,
    "mailing_postcode": 30,
    "mailing_state_id": 29,
    "mailing_street": 27,
    "manager_name": 41,
    "migration_type": 66,
    "name": 14,
    "newbook_contract_date": 18,
    "newbook_generic_url": 9,
    "newbook_region": 0,
    "newbook_review_date": 20,
    "newbook_start_date": 19,
    "newbook_stop_date": 21,
    "opened_on": 17,
    "opening_time": 42,
    "physical_city": 23,
    "physical_country_id": 26,
    "physical_postcode": 25,
    "physical_state_id": 24,
    "physical_street": 22,
    "previous_supplier_id": 65,
    "read_only": 53,
    "sales_email": 32,
    "sales_fax": 34,
    "sales_phone": 33,
    "secure_login": 57,
    "software_type": 64,
    "status": 52,
    "survey_email": 38,
    "tax_id": 7,
    "tenant": 1,
    "time_format": 47,
    "total_bookings": 71,
    "trading_name": 15,
    "weather_station_code": 10,
    "website": 48
}
    • schema_attributes: 
      {
    "additional_license_account_id": "string",
    "admin_email": "string",
    "admin_fax": "string",
    "admin_phone": "string",
    "allow_animals": "string",
    "allow_children": "string",
    "allow_infants": "string",
    "api_key": "string",
    "base_license_account_id": "string",
    "basic_information": "string",
    "bom_radar_code": "string",
    "checkin_time": "string",
    "checkout_time": "string",
    "closing_time": "string",
    "contact_person": "string",
    "corporation_id": "string",
    "corporation_sync": "string",
    "created_when": "string",
    "date_format": "string",
    "default_client_account_id": "string",
    "duplicate_detection": "string",
    "error_email": "string",
    "ewn_registration_key": "string",
    "facebook_page_id": "string",
    "firstrun": "string",
    "future_supplier_id": "string",
    "future_supplier_reason": "string",
    "grace_period": "string",
    "id": "string",
    "individual_invoice": "string",
    "instance_type": "string",
    "last_booking_data": "string",
    "last_booking_timestamp": "string",
    "last_updated": "string",
    "lat": "string",
    "login_code": "string",
    "login_type": "string",
    "long": "string",
    "mailing_city": "string",
    "mailing_country_id": "string",
    "mailing_postcode": "string",
    "mailing_state_id": "string",
    "mailing_street": "string",
    "manager_name": "string",
    "migration_type": "string",
    "name": "string",
    "newbook_contract_date": "string",
    "newbook_generic_url": "string",
    "newbook_region": "string",
    "newbook_review_date": "string",
    "newbook_start_date": "string",
    "newbook_stop_date": "string",
    "opened_on": "string",
    "opening_time": "string",
    "physical_city": "string",
    "physical_country_id": "string",
    "physical_postcode": "string",
    "physical_state_id": "string",
    "physical_street": "string",
    "previous_supplier_id": "string",
    "read_only": "string",
    "sales_email": "string",
    "sales_fax": "string",
    "sales_phone": "string",
    "secure_login": "string",
    "software_type": "string",
    "status": "string",
    "survey_email": "string",
    "tax_id": "string",
    "tenant": "string",
    "time_format": "string",
    "total_bookings": "string",
    "trading_name": "string",
    "weather_station_code": "string",
    "website": "string"
}
    • schema_name_id: 2637
    • schema_scan_id: 6667782
    • updated: 2024-11-05 02:13:51
    • created: 2024-11-05 01:58:20
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `api_key`  string , `corporation_id`  string , `corporation_sync`  string , `duplicate_detection`  string , `tax_id`  string , `login_code`  string , `newbook_generic_url`  string , `weather_station_code`  string , `bom_radar_code`  string , `lat`  string , `long`  string , `name`  string , `trading_name`  string , `created_when`  string , `opened_on`  string , `newbook_contract_date`  string , `newbook_start_date`  string , `newbook_review_date`  string , `newbook_stop_date`  string , `physical_street`  string , `physical_city`  string , `physical_state_id`  string , `physical_postcode`  string , `physical_country_id`  string , `mailing_street`  string , `mailing_city`  string , `mailing_state_id`  string , `mailing_postcode`  string , `mailing_country_id`  string , `sales_email`  string , `sales_phone`  string , `sales_fax`  string , `admin_email`  string , `admin_phone`  string , `admin_fax`  string , `survey_email`  string , `error_email`  string , `contact_person`  string , `manager_name`  string , `opening_time`  string , `closing_time`  string , `checkin_time`  string , `checkout_time`  string , `date_format`  string , `time_format`  string , `website`  string , `allow_children`  string , `allow_infants`  string , `allow_animals`  string , `status`  string , `read_only`  string , `grace_period`  string , `firstrun`  string , `login_type`  string , `secure_login`  string , `default_client_account_id`  string , `base_license_account_id`  string , `additional_license_account_id`  string , `ewn_registration_key`  string , `facebook_page_id`  string , `instance_type`  string , `software_type`  string , `previous_supplier_id`  string , `migration_type`  string , `future_supplier_id`  string , `future_supplier_reason`  string , `individual_invoice`  string , `last_updated`  string , `total_bookings`  string , `last_booking_timestamp`  string , `last_booking_data`  string , `basic_information`  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_newbookinstances/2024-11-04/1730783665'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances/2024-11-04/1730783665
    • id: 4741999
    • processed: 1
    • raw_data: 
      {
    "additional_license_account_id": 60,
    "admin_email": 35,
    "admin_fax": 37,
    "admin_phone": 36,
    "allow_animals": 51,
    "allow_children": 49,
    "allow_infants": 50,
    "api_key": 3,
    "base_license_account_id": 59,
    "basic_information": 74,
    "bom_radar_code": 11,
    "checkin_time": 44,
    "checkout_time": 45,
    "closing_time": 43,
    "contact_person": 40,
    "corporation_id": 4,
    "corporation_sync": 5,
    "created_when": 16,
    "date_format": 46,
    "default_client_account_id": 58,
    "duplicate_detection": 6,
    "error_email": 39,
    "ewn_registration_key": 61,
    "facebook_page_id": 62,
    "firstrun": 55,
    "future_supplier_id": 67,
    "future_supplier_reason": 68,
    "grace_period": 54,
    "id": 2,
    "individual_invoice": 69,
    "instance_type": 63,
    "last_booking_data": 73,
    "last_booking_timestamp": 72,
    "last_updated": 70,
    "lat": 12,
    "login_code": 8,
    "login_type": 56,
    "long": 13,
    "mailing_city": 28,
    "mailing_country_id": 31,
    "mailing_postcode": 30,
    "mailing_state_id": 29,
    "mailing_street": 27,
    "manager_name": 41,
    "migration_type": 66,
    "name": 14,
    "newbook_contract_date": 18,
    "newbook_generic_url": 9,
    "newbook_region": 0,
    "newbook_review_date": 20,
    "newbook_start_date": 19,
    "newbook_stop_date": 21,
    "opened_on": 17,
    "opening_time": 42,
    "physical_city": 23,
    "physical_country_id": 26,
    "physical_postcode": 25,
    "physical_state_id": 24,
    "physical_street": 22,
    "previous_supplier_id": 65,
    "read_only": 53,
    "sales_email": 32,
    "sales_fax": 34,
    "sales_phone": 33,
    "secure_login": 57,
    "software_type": 64,
    "status": 52,
    "survey_email": 38,
    "tax_id": 7,
    "tenant": 1,
    "time_format": 47,
    "total_bookings": 71,
    "trading_name": 15,
    "weather_station_code": 10,
    "website": 48
}
    • schema_attributes: 
      {
    "additional_license_account_id": "string",
    "admin_email": "string",
    "admin_fax": "string",
    "admin_phone": "string",
    "allow_animals": "string",
    "allow_children": "string",
    "allow_infants": "string",
    "api_key": "string",
    "base_license_account_id": "string",
    "basic_information": "string",
    "bom_radar_code": "string",
    "checkin_time": "string",
    "checkout_time": "string",
    "closing_time": "string",
    "contact_person": "string",
    "corporation_id": "string",
    "corporation_sync": "string",
    "created_when": "string",
    "date_format": "string",
    "default_client_account_id": "string",
    "duplicate_detection": "string",
    "error_email": "string",
    "ewn_registration_key": "string",
    "facebook_page_id": "string",
    "firstrun": "string",
    "future_supplier_id": "string",
    "future_supplier_reason": "string",
    "grace_period": "string",
    "id": "string",
    "individual_invoice": "string",
    "instance_type": "string",
    "last_booking_data": "string",
    "last_booking_timestamp": "string",
    "last_updated": "string",
    "lat": "string",
    "login_code": "string",
    "login_type": "string",
    "long": "string",
    "mailing_city": "string",
    "mailing_country_id": "string",
    "mailing_postcode": "string",
    "mailing_state_id": "string",
    "mailing_street": "string",
    "manager_name": "string",
    "migration_type": "string",
    "name": "string",
    "newbook_contract_date": "string",
    "newbook_generic_url": "string",
    "newbook_region": "string",
    "newbook_review_date": "string",
    "newbook_start_date": "string",
    "newbook_stop_date": "string",
    "opened_on": "string",
    "opening_time": "string",
    "physical_city": "string",
    "physical_country_id": "string",
    "physical_postcode": "string",
    "physical_state_id": "string",
    "physical_street": "string",
    "previous_supplier_id": "string",
    "read_only": "string",
    "sales_email": "string",
    "sales_fax": "string",
    "sales_phone": "string",
    "secure_login": "string",
    "software_type": "string",
    "status": "string",
    "survey_email": "string",
    "tax_id": "string",
    "tenant": "string",
    "time_format": "string",
    "total_bookings": "string",
    "trading_name": "string",
    "weather_station_code": "string",
    "website": "string"
}
    • schema_name_id: 2637
    • schema_scan_id: 6667213
    • updated: 2024-11-05 01:58:31
    • created: 2024-11-05 01:35:05
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `api_key`  string , `corporation_id`  string , `corporation_sync`  string , `duplicate_detection`  string , `tax_id`  string , `login_code`  string , `newbook_generic_url`  string , `weather_station_code`  string , `bom_radar_code`  string , `lat`  string , `long`  string , `name`  string , `trading_name`  string , `created_when`  string , `opened_on`  string , `newbook_contract_date`  string , `newbook_start_date`  string , `newbook_review_date`  string , `newbook_stop_date`  string , `physical_street`  string , `physical_city`  string , `physical_state_id`  string , `physical_postcode`  string , `physical_country_id`  string , `mailing_street`  string , `mailing_city`  string , `mailing_state_id`  string , `mailing_postcode`  string , `mailing_country_id`  string , `sales_email`  string , `sales_phone`  string , `sales_fax`  string , `admin_email`  string , `admin_phone`  string , `admin_fax`  string , `survey_email`  string , `error_email`  string , `contact_person`  string , `manager_name`  string , `opening_time`  string , `closing_time`  string , `checkin_time`  string , `checkout_time`  string , `date_format`  string , `time_format`  string , `website`  string , `allow_children`  string , `allow_infants`  string , `allow_animals`  string , `status`  string , `read_only`  string , `grace_period`  string , `firstrun`  string , `login_type`  string , `secure_login`  string , `default_client_account_id`  string , `base_license_account_id`  string , `additional_license_account_id`  string , `ewn_registration_key`  string , `facebook_page_id`  string , `instance_type`  string , `software_type`  string , `previous_supplier_id`  string , `migration_type`  string , `future_supplier_id`  string , `future_supplier_reason`  string , `individual_invoice`  string , `last_updated`  string , `total_bookings`  string , `last_booking_timestamp`  string , `last_booking_data`  string , `basic_information`  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_newbookinstances/2024-11-04/1730783524'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances/2024-11-04/1730783524
    • id: 4741110
    • processed: 1
    • raw_data: 
      {
    "additional_license_account_id": 60,
    "admin_email": 35,
    "admin_fax": 37,
    "admin_phone": 36,
    "allow_animals": 51,
    "allow_children": 49,
    "allow_infants": 50,
    "api_key": 3,
    "base_license_account_id": 59,
    "basic_information": 74,
    "bom_radar_code": 11,
    "checkin_time": 44,
    "checkout_time": 45,
    "closing_time": 43,
    "contact_person": 40,
    "corporation_id": 4,
    "corporation_sync": 5,
    "created_when": 16,
    "date_format": 46,
    "default_client_account_id": 58,
    "duplicate_detection": 6,
    "error_email": 39,
    "ewn_registration_key": 61,
    "facebook_page_id": 62,
    "firstrun": 55,
    "future_supplier_id": 67,
    "future_supplier_reason": 68,
    "grace_period": 54,
    "id": 2,
    "individual_invoice": 69,
    "instance_type": 63,
    "last_booking_data": 73,
    "last_booking_timestamp": 72,
    "last_updated": 70,
    "lat": 12,
    "login_code": 8,
    "login_type": 56,
    "long": 13,
    "mailing_city": 28,
    "mailing_country_id": 31,
    "mailing_postcode": 30,
    "mailing_state_id": 29,
    "mailing_street": 27,
    "manager_name": 41,
    "migration_type": 66,
    "name": 14,
    "newbook_contract_date": 18,
    "newbook_generic_url": 9,
    "newbook_region": 0,
    "newbook_review_date": 20,
    "newbook_start_date": 19,
    "newbook_stop_date": 21,
    "opened_on": 17,
    "opening_time": 42,
    "physical_city": 23,
    "physical_country_id": 26,
    "physical_postcode": 25,
    "physical_state_id": 24,
    "physical_street": 22,
    "previous_supplier_id": 65,
    "read_only": 53,
    "sales_email": 32,
    "sales_fax": 34,
    "sales_phone": 33,
    "secure_login": 57,
    "software_type": 64,
    "status": 52,
    "survey_email": 38,
    "tax_id": 7,
    "tenant": 1,
    "time_format": 47,
    "total_bookings": 71,
    "trading_name": 15,
    "weather_station_code": 10,
    "website": 48
}
    • schema_attributes: 
      {
    "additional_license_account_id": "string",
    "admin_email": "string",
    "admin_fax": "string",
    "admin_phone": "string",
    "allow_animals": "string",
    "allow_children": "string",
    "allow_infants": "string",
    "api_key": "string",
    "base_license_account_id": "string",
    "basic_information": "string",
    "bom_radar_code": "string",
    "checkin_time": "string",
    "checkout_time": "string",
    "closing_time": "string",
    "contact_person": "string",
    "corporation_id": "string",
    "corporation_sync": "string",
    "created_when": "string",
    "date_format": "string",
    "default_client_account_id": "string",
    "duplicate_detection": "string",
    "error_email": "string",
    "ewn_registration_key": "string",
    "facebook_page_id": "string",
    "firstrun": "string",
    "future_supplier_id": "string",
    "future_supplier_reason": "string",
    "grace_period": "string",
    "id": "string",
    "individual_invoice": "string",
    "instance_type": "string",
    "last_booking_data": "string",
    "last_booking_timestamp": "string",
    "last_updated": "string",
    "lat": "string",
    "login_code": "string",
    "login_type": "string",
    "long": "string",
    "mailing_city": "string",
    "mailing_country_id": "string",
    "mailing_postcode": "string",
    "mailing_state_id": "string",
    "mailing_street": "string",
    "manager_name": "string",
    "migration_type": "string",
    "name": "string",
    "newbook_contract_date": "string",
    "newbook_generic_url": "string",
    "newbook_region": "string",
    "newbook_review_date": "string",
    "newbook_start_date": "string",
    "newbook_stop_date": "string",
    "opened_on": "string",
    "opening_time": "string",
    "physical_city": "string",
    "physical_country_id": "string",
    "physical_postcode": "string",
    "physical_state_id": "string",
    "physical_street": "string",
    "previous_supplier_id": "string",
    "read_only": "string",
    "sales_email": "string",
    "sales_fax": "string",
    "sales_phone": "string",
    "secure_login": "string",
    "software_type": "string",
    "status": "string",
    "survey_email": "string",
    "tax_id": "string",
    "tenant": "string",
    "time_format": "string",
    "total_bookings": "string",
    "trading_name": "string",
    "weather_station_code": "string",
    "website": "string"
}
    • schema_name_id: 2637
    • schema_scan_id: 6666326
    • updated: 2024-11-05 01:35:16
    • created: 2024-11-05 01:13:04
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `api_key`  string , `corporation_id`  string , `corporation_sync`  string , `duplicate_detection`  string , `tax_id`  string , `login_code`  string , `newbook_generic_url`  string , `weather_station_code`  string , `bom_radar_code`  string , `lat`  string , `long`  string , `name`  string , `trading_name`  string , `created_when`  string , `opened_on`  string , `newbook_contract_date`  string , `newbook_start_date`  string , `newbook_review_date`  string , `newbook_stop_date`  string , `physical_street`  string , `physical_city`  string , `physical_state_id`  string , `physical_postcode`  string , `physical_country_id`  string , `mailing_street`  string , `mailing_city`  string , `mailing_state_id`  string , `mailing_postcode`  string , `mailing_country_id`  string , `sales_email`  string , `sales_phone`  string , `sales_fax`  string , `admin_email`  string , `admin_phone`  string , `admin_fax`  string , `survey_email`  string , `error_email`  string , `contact_person`  string , `manager_name`  string , `opening_time`  string , `closing_time`  string , `checkin_time`  string , `checkout_time`  string , `date_format`  string , `time_format`  string , `website`  string , `allow_children`  string , `allow_infants`  string , `allow_animals`  string , `status`  string , `read_only`  string , `grace_period`  string , `firstrun`  string , `login_type`  string , `secure_login`  string , `default_client_account_id`  string , `base_license_account_id`  string , `additional_license_account_id`  string , `ewn_registration_key`  string , `facebook_page_id`  string , `instance_type`  string , `software_type`  string , `previous_supplier_id`  string , `migration_type`  string , `future_supplier_id`  string , `future_supplier_reason`  string , `individual_invoice`  string , `last_updated`  string , `total_bookings`  string , `last_booking_timestamp`  string , `last_booking_data`  string , `basic_information`  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_newbookinstances/2024-11-04/1730783306'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances/2024-11-04/1730783306
    • id: 4740275
    • processed: 1
    • raw_data: 
      {
    "additional_license_account_id": 60,
    "admin_email": 35,
    "admin_fax": 37,
    "admin_phone": 36,
    "allow_animals": 51,
    "allow_children": 49,
    "allow_infants": 50,
    "api_key": 3,
    "base_license_account_id": 59,
    "basic_information": 74,
    "bom_radar_code": 11,
    "checkin_time": 44,
    "checkout_time": 45,
    "closing_time": 43,
    "contact_person": 40,
    "corporation_id": 4,
    "corporation_sync": 5,
    "created_when": 16,
    "date_format": 46,
    "default_client_account_id": 58,
    "duplicate_detection": 6,
    "error_email": 39,
    "ewn_registration_key": 61,
    "facebook_page_id": 62,
    "firstrun": 55,
    "future_supplier_id": 67,
    "future_supplier_reason": 68,
    "grace_period": 54,
    "id": 2,
    "individual_invoice": 69,
    "instance_type": 63,
    "last_booking_data": 73,
    "last_booking_timestamp": 72,
    "last_updated": 70,
    "lat": 12,
    "login_code": 8,
    "login_type": 56,
    "long": 13,
    "mailing_city": 28,
    "mailing_country_id": 31,
    "mailing_postcode": 30,
    "mailing_state_id": 29,
    "mailing_street": 27,
    "manager_name": 41,
    "migration_type": 66,
    "name": 14,
    "newbook_contract_date": 18,
    "newbook_generic_url": 9,
    "newbook_region": 0,
    "newbook_review_date": 20,
    "newbook_start_date": 19,
    "newbook_stop_date": 21,
    "opened_on": 17,
    "opening_time": 42,
    "physical_city": 23,
    "physical_country_id": 26,
    "physical_postcode": 25,
    "physical_state_id": 24,
    "physical_street": 22,
    "previous_supplier_id": 65,
    "read_only": 53,
    "sales_email": 32,
    "sales_fax": 34,
    "sales_phone": 33,
    "secure_login": 57,
    "software_type": 64,
    "status": 52,
    "survey_email": 38,
    "tax_id": 7,
    "tenant": 1,
    "time_format": 47,
    "total_bookings": 71,
    "trading_name": 15,
    "weather_station_code": 10,
    "website": 48
}
    • schema_attributes: 
      {
    "additional_license_account_id": "string",
    "admin_email": "string",
    "admin_fax": "string",
    "admin_phone": "string",
    "allow_animals": "string",
    "allow_children": "string",
    "allow_infants": "string",
    "api_key": "string",
    "base_license_account_id": "string",
    "basic_information": "string",
    "bom_radar_code": "string",
    "checkin_time": "string",
    "checkout_time": "string",
    "closing_time": "string",
    "contact_person": "string",
    "corporation_id": "string",
    "corporation_sync": "string",
    "created_when": "string",
    "date_format": "string",
    "default_client_account_id": "string",
    "duplicate_detection": "string",
    "error_email": "string",
    "ewn_registration_key": "string",
    "facebook_page_id": "string",
    "firstrun": "string",
    "future_supplier_id": "string",
    "future_supplier_reason": "string",
    "grace_period": "string",
    "id": "string",
    "individual_invoice": "string",
    "instance_type": "string",
    "last_booking_data": "string",
    "last_booking_timestamp": "string",
    "last_updated": "string",
    "lat": "string",
    "login_code": "string",
    "login_type": "string",
    "long": "string",
    "mailing_city": "string",
    "mailing_country_id": "string",
    "mailing_postcode": "string",
    "mailing_state_id": "string",
    "mailing_street": "string",
    "manager_name": "string",
    "migration_type": "string",
    "name": "string",
    "newbook_contract_date": "string",
    "newbook_generic_url": "string",
    "newbook_region": "string",
    "newbook_review_date": "string",
    "newbook_start_date": "string",
    "newbook_stop_date": "string",
    "opened_on": "string",
    "opening_time": "string",
    "physical_city": "string",
    "physical_country_id": "string",
    "physical_postcode": "string",
    "physical_state_id": "string",
    "physical_street": "string",
    "previous_supplier_id": "string",
    "read_only": "string",
    "sales_email": "string",
    "sales_fax": "string",
    "sales_phone": "string",
    "secure_login": "string",
    "software_type": "string",
    "status": "string",
    "survey_email": "string",
    "tax_id": "string",
    "tenant": "string",
    "time_format": "string",
    "total_bookings": "string",
    "trading_name": "string",
    "weather_station_code": "string",
    "website": "string"
}
    • schema_name_id: 2637
    • schema_scan_id: 6665492
    • updated: 2024-11-05 01:13:17
    • created: 2024-11-05 00:55:31
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `api_key`  string , `corporation_id`  string , `corporation_sync`  string , `duplicate_detection`  string , `tax_id`  string , `login_code`  string , `newbook_generic_url`  string , `weather_station_code`  string , `bom_radar_code`  string , `lat`  string , `long`  string , `name`  string , `trading_name`  string , `created_when`  string , `opened_on`  string , `newbook_contract_date`  string , `newbook_start_date`  string , `newbook_review_date`  string , `newbook_stop_date`  string , `physical_street`  string , `physical_city`  string , `physical_state_id`  string , `physical_postcode`  string , `physical_country_id`  string , `mailing_street`  string , `mailing_city`  string , `mailing_state_id`  string , `mailing_postcode`  string , `mailing_country_id`  string , `sales_email`  string , `sales_phone`  string , `sales_fax`  string , `admin_email`  string , `admin_phone`  string , `admin_fax`  string , `survey_email`  string , `error_email`  string , `contact_person`  string , `manager_name`  string , `opening_time`  string , `closing_time`  string , `checkin_time`  string , `checkout_time`  string , `date_format`  string , `time_format`  string , `website`  string , `allow_children`  string , `allow_infants`  string , `allow_animals`  string , `status`  string , `read_only`  string , `grace_period`  string , `firstrun`  string , `login_type`  string , `secure_login`  string , `default_client_account_id`  string , `base_license_account_id`  string , `additional_license_account_id`  string , `ewn_registration_key`  string , `facebook_page_id`  string , `instance_type`  string , `software_type`  string , `previous_supplier_id`  string , `migration_type`  string , `future_supplier_id`  string , `future_supplier_reason`  string , `individual_invoice`  string , `last_updated`  string , `total_bookings`  string , `last_booking_timestamp`  string , `last_booking_data`  string , `basic_information`  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_newbookinstances/2024-11-04/1730782907'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances/2024-11-04/1730782907
    • id: 4739621
    • processed: 1
    • raw_data: 
      {
    "additional_license_account_id": 60,
    "admin_email": 35,
    "admin_fax": 37,
    "admin_phone": 36,
    "allow_animals": 51,
    "allow_children": 49,
    "allow_infants": 50,
    "api_key": 3,
    "base_license_account_id": 59,
    "basic_information": 74,
    "bom_radar_code": 11,
    "checkin_time": 44,
    "checkout_time": 45,
    "closing_time": 43,
    "contact_person": 40,
    "corporation_id": 4,
    "corporation_sync": 5,
    "created_when": 16,
    "date_format": 46,
    "default_client_account_id": 58,
    "duplicate_detection": 6,
    "error_email": 39,
    "ewn_registration_key": 61,
    "facebook_page_id": 62,
    "firstrun": 55,
    "future_supplier_id": 67,
    "future_supplier_reason": 68,
    "grace_period": 54,
    "id": 2,
    "individual_invoice": 69,
    "instance_type": 63,
    "last_booking_data": 73,
    "last_booking_timestamp": 72,
    "last_updated": 70,
    "lat": 12,
    "login_code": 8,
    "login_type": 56,
    "long": 13,
    "mailing_city": 28,
    "mailing_country_id": 31,
    "mailing_postcode": 30,
    "mailing_state_id": 29,
    "mailing_street": 27,
    "manager_name": 41,
    "migration_type": 66,
    "name": 14,
    "newbook_contract_date": 18,
    "newbook_generic_url": 9,
    "newbook_region": 0,
    "newbook_review_date": 20,
    "newbook_start_date": 19,
    "newbook_stop_date": 21,
    "opened_on": 17,
    "opening_time": 42,
    "physical_city": 23,
    "physical_country_id": 26,
    "physical_postcode": 25,
    "physical_state_id": 24,
    "physical_street": 22,
    "previous_supplier_id": 65,
    "read_only": 53,
    "sales_email": 32,
    "sales_fax": 34,
    "sales_phone": 33,
    "secure_login": 57,
    "software_type": 64,
    "status": 52,
    "survey_email": 38,
    "tax_id": 7,
    "tenant": 1,
    "time_format": 47,
    "total_bookings": 71,
    "trading_name": 15,
    "weather_station_code": 10,
    "website": 48
}
    • schema_attributes: 
      {
    "additional_license_account_id": "string",
    "admin_email": "string",
    "admin_fax": "string",
    "admin_phone": "string",
    "allow_animals": "string",
    "allow_children": "string",
    "allow_infants": "string",
    "api_key": "string",
    "base_license_account_id": "string",
    "basic_information": "string",
    "bom_radar_code": "string",
    "checkin_time": "string",
    "checkout_time": "string",
    "closing_time": "string",
    "contact_person": "string",
    "corporation_id": "string",
    "corporation_sync": "string",
    "created_when": "string",
    "date_format": "string",
    "default_client_account_id": "string",
    "duplicate_detection": "string",
    "error_email": "string",
    "ewn_registration_key": "string",
    "facebook_page_id": "string",
    "firstrun": "string",
    "future_supplier_id": "string",
    "future_supplier_reason": "string",
    "grace_period": "string",
    "id": "string",
    "individual_invoice": "string",
    "instance_type": "string",
    "last_booking_data": "string",
    "last_booking_timestamp": "string",
    "last_updated": "string",
    "lat": "string",
    "login_code": "string",
    "login_type": "string",
    "long": "string",
    "mailing_city": "string",
    "mailing_country_id": "string",
    "mailing_postcode": "string",
    "mailing_state_id": "string",
    "mailing_street": "string",
    "manager_name": "string",
    "migration_type": "string",
    "name": "string",
    "newbook_contract_date": "string",
    "newbook_generic_url": "string",
    "newbook_region": "string",
    "newbook_review_date": "string",
    "newbook_start_date": "string",
    "newbook_stop_date": "string",
    "opened_on": "string",
    "opening_time": "string",
    "physical_city": "string",
    "physical_country_id": "string",
    "physical_postcode": "string",
    "physical_state_id": "string",
    "physical_street": "string",
    "previous_supplier_id": "string",
    "read_only": "string",
    "sales_email": "string",
    "sales_fax": "string",
    "sales_phone": "string",
    "secure_login": "string",
    "software_type": "string",
    "status": "string",
    "survey_email": "string",
    "tax_id": "string",
    "tenant": "string",
    "time_format": "string",
    "total_bookings": "string",
    "trading_name": "string",
    "weather_station_code": "string",
    "website": "string"
}
    • schema_name_id: 2637
    • schema_scan_id: 6664838
    • updated: 2024-11-05 00:55:42
    • created: 2024-11-05 00:39:54
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `api_key`  string , `corporation_id`  string , `corporation_sync`  string , `duplicate_detection`  string , `tax_id`  string , `login_code`  string , `newbook_generic_url`  string , `weather_station_code`  string , `bom_radar_code`  string , `lat`  string , `long`  string , `name`  string , `trading_name`  string , `created_when`  string , `opened_on`  string , `newbook_contract_date`  string , `newbook_start_date`  string , `newbook_review_date`  string , `newbook_stop_date`  string , `physical_street`  string , `physical_city`  string , `physical_state_id`  string , `physical_postcode`  string , `physical_country_id`  string , `mailing_street`  string , `mailing_city`  string , `mailing_state_id`  string , `mailing_postcode`  string , `mailing_country_id`  string , `sales_email`  string , `sales_phone`  string , `sales_fax`  string , `admin_email`  string , `admin_phone`  string , `admin_fax`  string , `survey_email`  string , `error_email`  string , `contact_person`  string , `manager_name`  string , `opening_time`  string , `closing_time`  string , `checkin_time`  string , `checkout_time`  string , `date_format`  string , `time_format`  string , `website`  string , `allow_children`  string , `allow_infants`  string , `allow_animals`  string , `status`  string , `read_only`  string , `grace_period`  string , `firstrun`  string , `login_type`  string , `secure_login`  string , `default_client_account_id`  string , `base_license_account_id`  string , `additional_license_account_id`  string , `ewn_registration_key`  string , `facebook_page_id`  string , `instance_type`  string , `software_type`  string , `previous_supplier_id`  string , `migration_type`  string , `future_supplier_id`  string , `future_supplier_reason`  string , `individual_invoice`  string , `last_updated`  string , `total_bookings`  string , `last_booking_timestamp`  string , `last_booking_data`  string , `basic_information`  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_newbookinstances/2024-11-04/1730782806'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances/2024-11-04/1730782806
    • id: 4739027
    • processed: 1
    • raw_data: 
      {
    "additional_license_account_id": 60,
    "admin_email": 35,
    "admin_fax": 37,
    "admin_phone": 36,
    "allow_animals": 51,
    "allow_children": 49,
    "allow_infants": 50,
    "api_key": 3,
    "base_license_account_id": 59,
    "basic_information": 74,
    "bom_radar_code": 11,
    "checkin_time": 44,
    "checkout_time": 45,
    "closing_time": 43,
    "contact_person": 40,
    "corporation_id": 4,
    "corporation_sync": 5,
    "created_when": 16,
    "date_format": 46,
    "default_client_account_id": 58,
    "duplicate_detection": 6,
    "error_email": 39,
    "ewn_registration_key": 61,
    "facebook_page_id": 62,
    "firstrun": 55,
    "future_supplier_id": 67,
    "future_supplier_reason": 68,
    "grace_period": 54,
    "id": 2,
    "individual_invoice": 69,
    "instance_type": 63,
    "last_booking_data": 73,
    "last_booking_timestamp": 72,
    "last_updated": 70,
    "lat": 12,
    "login_code": 8,
    "login_type": 56,
    "long": 13,
    "mailing_city": 28,
    "mailing_country_id": 31,
    "mailing_postcode": 30,
    "mailing_state_id": 29,
    "mailing_street": 27,
    "manager_name": 41,
    "migration_type": 66,
    "name": 14,
    "newbook_contract_date": 18,
    "newbook_generic_url": 9,
    "newbook_region": 0,
    "newbook_review_date": 20,
    "newbook_start_date": 19,
    "newbook_stop_date": 21,
    "opened_on": 17,
    "opening_time": 42,
    "physical_city": 23,
    "physical_country_id": 26,
    "physical_postcode": 25,
    "physical_state_id": 24,
    "physical_street": 22,
    "previous_supplier_id": 65,
    "read_only": 53,
    "sales_email": 32,
    "sales_fax": 34,
    "sales_phone": 33,
    "secure_login": 57,
    "software_type": 64,
    "status": 52,
    "survey_email": 38,
    "tax_id": 7,
    "tenant": 1,
    "time_format": 47,
    "total_bookings": 71,
    "trading_name": 15,
    "weather_station_code": 10,
    "website": 48
}
    • schema_attributes: 
      {
    "additional_license_account_id": "string",
    "admin_email": "string",
    "admin_fax": "string",
    "admin_phone": "string",
    "allow_animals": "string",
    "allow_children": "string",
    "allow_infants": "string",
    "api_key": "string",
    "base_license_account_id": "string",
    "basic_information": "string",
    "bom_radar_code": "string",
    "checkin_time": "string",
    "checkout_time": "string",
    "closing_time": "string",
    "contact_person": "string",
    "corporation_id": "string",
    "corporation_sync": "string",
    "created_when": "string",
    "date_format": "string",
    "default_client_account_id": "string",
    "duplicate_detection": "string",
    "error_email": "string",
    "ewn_registration_key": "string",
    "facebook_page_id": "string",
    "firstrun": "string",
    "future_supplier_id": "string",
    "future_supplier_reason": "string",
    "grace_period": "string",
    "id": "string",
    "individual_invoice": "string",
    "instance_type": "string",
    "last_booking_data": "string",
    "last_booking_timestamp": "string",
    "last_updated": "string",
    "lat": "string",
    "login_code": "string",
    "login_type": "string",
    "long": "string",
    "mailing_city": "string",
    "mailing_country_id": "string",
    "mailing_postcode": "string",
    "mailing_state_id": "string",
    "mailing_street": "string",
    "manager_name": "string",
    "migration_type": "string",
    "name": "string",
    "newbook_contract_date": "string",
    "newbook_generic_url": "string",
    "newbook_region": "string",
    "newbook_review_date": "string",
    "newbook_start_date": "string",
    "newbook_stop_date": "string",
    "opened_on": "string",
    "opening_time": "string",
    "physical_city": "string",
    "physical_country_id": "string",
    "physical_postcode": "string",
    "physical_state_id": "string",
    "physical_street": "string",
    "previous_supplier_id": "string",
    "read_only": "string",
    "sales_email": "string",
    "sales_fax": "string",
    "sales_phone": "string",
    "secure_login": "string",
    "software_type": "string",
    "status": "string",
    "survey_email": "string",
    "tax_id": "string",
    "tenant": "string",
    "time_format": "string",
    "total_bookings": "string",
    "trading_name": "string",
    "weather_station_code": "string",
    "website": "string"
}
    • schema_name_id: 2637
    • schema_scan_id: 6664242
    • updated: 2024-11-05 00:40:07
Schema Scans: 15
Last at 2024-11-05 23:14:35
    • duration: 0:00:16.157272
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6675052
    • 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_newbookinstances/2024-11-05/1730866510",
        "key": "raw/newbookdev_newbookinstances/2024-11-05/1730866510/instances.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5681878915584778853,
        "service_name": "drive-thru",
        "span_id": 6009636859445449543,
        "trace_id": 10369850238703094529
    }
}
    • running: False
    • schema_name_id: 2637
    • start_time: 2024-11-05 23:14:35
    • success: True
    • trace_id: 10369850238703094529
    • duration: 0:00:13.597622
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6674373
    • 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_newbookinstances/2024-11-05/1730866433",
        "key": "raw/newbookdev_newbookinstances/2024-11-05/1730866433/instances.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4940640535470548360,
        "service_name": "drive-thru",
        "span_id": 2309098714510895147,
        "trace_id": 3252038519937522263
    }
}
    • running: False
    • schema_name_id: 2637
    • start_time: 2024-11-05 22:42:51
    • success: True
    • trace_id: 3252038519937522263
    • duration: 0:00:13.578535
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6673790
    • 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_newbookinstances/2024-11-05/1730866313",
        "key": "raw/newbookdev_newbookinstances/2024-11-05/1730866313/instances.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3251203537901564386,
        "service_name": "drive-thru",
        "span_id": 2166820253836119645,
        "trace_id": 3725614389675683593
    }
}
    • running: False
    • schema_name_id: 2637
    • start_time: 2024-11-05 22:25:13
    • success: True
    • trace_id: 3725614389675683593
    • duration: 0:00:13.664196
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6672137
    • 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_newbookinstances/2024-11-04/1730785723",
        "key": "raw/newbookdev_newbookinstances/2024-11-04/1730785723/instances.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1048341656629550640,
        "service_name": "drive-thru",
        "span_id": 1228286281615617076,
        "trace_id": 17103507838493589681
    }
}
    • running: False
    • schema_name_id: 2637
    • start_time: 2024-11-05 04:31:43
    • success: True
    • trace_id: 17103507838493589681
    • duration: 0:00:15.788064
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6670675
    • 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_newbookinstances/2024-11-04/1730784821",
        "key": "raw/newbookdev_newbookinstances/2024-11-04/1730784821/instances.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14616394592700679783,
        "service_name": "drive-thru",
        "span_id": 1329673530800139767,
        "trace_id": 15392580693269553221
    }
}
    • running: False
    • schema_name_id: 2637
    • start_time: 2024-11-05 03:29:56
    • success: True
    • trace_id: 15392580693269553221
    • duration: 0:00:15.784871
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6670663
    • 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_newbookinstances/2024-11-04/1730785126",
        "key": "raw/newbookdev_newbookinstances/2024-11-04/1730785126/instances.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8389934482643034724,
        "service_name": "drive-thru",
        "span_id": 8792258829979906818,
        "trace_id": 14225386920019971086
    }
}
    • running: False
    • schema_name_id: 2637
    • start_time: 2024-11-05 03:29:36
    • success: True
    • trace_id: 14225386920019971086
    • duration: 0:00:13.475074
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6670401
    • 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_newbookinstances/2024-11-04/1730784217",
        "key": "raw/newbookdev_newbookinstances/2024-11-04/1730784217/instances.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4536644146266487003,
        "service_name": "drive-thru",
        "span_id": 16532594922121429829,
        "trace_id": 18237845075734428410
    }
}
    • running: False
    • schema_name_id: 2637
    • start_time: 2024-11-05 03:22:48
    • success: True
    • trace_id: 18237845075734428410
    • duration: 0:00:13.279750
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6668853
    • 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_newbookinstances/2024-11-04/1730783900",
        "key": "raw/newbookdev_newbookinstances/2024-11-04/1730783900/instances.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18445415673260969651,
        "service_name": "drive-thru",
        "span_id": 14250136832648713720,
        "trace_id": 3056538998638260058
    }
}
    • running: False
    • schema_name_id: 2637
    • start_time: 2024-11-05 02:41:51
    • success: True
    • trace_id: 3056538998638260058
    • duration: 0:00:15.916989
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6668608
    • 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_newbookinstances/2024-11-04/1730784055",
        "key": "raw/newbookdev_newbookinstances/2024-11-04/1730784055/instances.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3710961562754847615,
        "service_name": "drive-thru",
        "span_id": 14368860855203904296,
        "trace_id": 923107537392122677
    }
}
    • running: False
    • schema_name_id: 2637
    • start_time: 2024-11-05 02:35:24
    • success: True
    • trace_id: 923107537392122677
    • duration: 0:00:15.762898
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6667782
    • 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_newbookinstances/2024-11-04/1730783768",
        "key": "raw/newbookdev_newbookinstances/2024-11-04/1730783768/instances.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4410651334053605417,
        "service_name": "drive-thru",
        "span_id": 9812028945176895566,
        "trace_id": 7078920297429393801
    }
}
    • running: False
    • schema_name_id: 2637
    • start_time: 2024-11-05 02:13:35
    • success: True
    • trace_id: 7078920297429393801
    • duration: 0:00:13.500088
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6667213
    • 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_newbookinstances/2024-11-04/1730783665",
        "key": "raw/newbookdev_newbookinstances/2024-11-04/1730783665/instances.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12107679307046086699,
        "service_name": "drive-thru",
        "span_id": 2027904102901086333,
        "trace_id": 5095403481912942344
    }
}
    • running: False
    • schema_name_id: 2637
    • start_time: 2024-11-05 01:58:18
    • success: True
    • trace_id: 5095403481912942344
    • duration: 0:00:13.302583
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6666326
    • 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_newbookinstances/2024-11-04/1730783524",
        "key": "raw/newbookdev_newbookinstances/2024-11-04/1730783524/instances.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8831245163016214677,
        "service_name": "drive-thru",
        "span_id": 14685782447409358856,
        "trace_id": 7818903007398766834
    }
}
    • running: False
    • schema_name_id: 2637
    • start_time: 2024-11-05 01:35:02
    • success: True
    • trace_id: 7818903007398766834
    • duration: 0:00:16.054876
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6665492
    • 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_newbookinstances/2024-11-04/1730783306",
        "key": "raw/newbookdev_newbookinstances/2024-11-04/1730783306/instances.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5714148676900542389,
        "service_name": "drive-thru",
        "span_id": 17605786380454962186,
        "trace_id": 11749279328936316344
    }
}
    • running: False
    • schema_name_id: 2637
    • start_time: 2024-11-05 01:13:01
    • success: True
    • trace_id: 11749279328936316344
    • duration: 0:00:13.401389
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6664838
    • 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_newbookinstances/2024-11-04/1730782907",
        "key": "raw/newbookdev_newbookinstances/2024-11-04/1730782907/instances.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12771407680275694055,
        "service_name": "drive-thru",
        "span_id": 15727003070379673431,
        "trace_id": 9274938425758648135
    }
}
    • running: False
    • schema_name_id: 2637
    • start_time: 2024-11-05 00:55:28
    • success: True
    • trace_id: 9274938425758648135
    • duration: 0:00:15.828973
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6664242
    • 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_newbookinstances/2024-11-04/1730782806",
        "key": "raw/newbookdev_newbookinstances/2024-11-04/1730782806/instances.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2220209187285948538,
        "service_name": "drive-thru",
        "span_id": 4683931863178773261,
        "trace_id": 1933788503902428544
    }
}
    • running: False
    • schema_name_id: 2637
    • start_time: 2024-11-05 00:39:51
    • success: True
    • trace_id: 1933788503902428544
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "additional_license_account_id": "string",
    "admin_email": "string",
    "admin_fax": "string",
    "admin_phone": "string",
    "allow_animals": "string",
    "allow_children": "string",
    "allow_infants": "string",
    "api_key": "string",
    "base_license_account_id": "string",
    "basic_information": "string",
    "bom_radar_code": "string",
    "checkin_time": "string",
    "checkout_time": "string",
    "closing_time": "string",
    "contact_person": "string",
    "corporation_id": "string",
    "corporation_sync": "string",
    "created_when": "string",
    "date_format": "string",
    "default_client_account_id": "string",
    "duplicate_detection": "string",
    "error_email": "string",
    "ewn_registration_key": "string",
    "facebook_page_id": "string",
    "firstrun": "string",
    "future_supplier_id": "string",
    "future_supplier_reason": "string",
    "grace_period": "string",
    "id": "string",
    "individual_invoice": "string",
    "instance_type": "string",
    "last_booking_data": "string",
    "last_booking_timestamp": "string",
    "last_updated": "string",
    "lat": "string",
    "login_code": "string",
    "login_type": "string",
    "long": "string",
    "mailing_city": "string",
    "mailing_country_id": "string",
    "mailing_postcode": "string",
    "mailing_state_id": "string",
    "mailing_street": "string",
    "manager_name": "string",
    "migration_type": "string",
    "name": "string",
    "newbook_contract_date": "string",
    "newbook_generic_url": "string",
    "newbook_region": "string",
    "newbook_review_date": "string",
    "newbook_start_date": "string",
    "newbook_stop_date": "string",
    "opened_on": "string",
    "opening_time": "string",
    "physical_city": "string",
    "physical_country_id": "string",
    "physical_postcode": "string",
    "physical_state_id": "string",
    "physical_street": "string",
    "previous_supplier_id": "string",
    "read_only": "string",
    "sales_email": "string",
    "sales_fax": "string",
    "sales_phone": "string",
    "secure_login": "string",
    "software_type": "string",
    "status": "string",
    "survey_email": "string",
    "tax_id": "string",
    "tenant": "string",
    "time_format": "string",
    "total_bookings": "string",
    "trading_name": "string",
    "weather_station_code": "string",
    "website": "string"
}
  • created: 2024-11-05 23:14:37
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `api_key`  string , `corporation_id`  string , `corporation_sync`  string , `duplicate_detection`  string , `tax_id`  string , `login_code`  string , `newbook_generic_url`  string , `weather_station_code`  string , `bom_radar_code`  string , `lat`  string , `long`  string , `name`  string , `trading_name`  string , `created_when`  string , `opened_on`  string , `newbook_contract_date`  string , `newbook_start_date`  string , `newbook_review_date`  string , `newbook_stop_date`  string , `physical_street`  string , `physical_city`  string , `physical_state_id`  string , `physical_postcode`  string , `physical_country_id`  string , `mailing_street`  string , `mailing_city`  string , `mailing_state_id`  string , `mailing_postcode`  string , `mailing_country_id`  string , `sales_email`  string , `sales_phone`  string , `sales_fax`  string , `admin_email`  string , `admin_phone`  string , `admin_fax`  string , `survey_email`  string , `error_email`  string , `contact_person`  string , `manager_name`  string , `opening_time`  string , `closing_time`  string , `checkin_time`  string , `checkout_time`  string , `date_format`  string , `time_format`  string , `website`  string , `allow_children`  string , `allow_infants`  string , `allow_animals`  string , `status`  string , `read_only`  string , `grace_period`  string , `firstrun`  string , `login_type`  string , `secure_login`  string , `default_client_account_id`  string , `base_license_account_id`  string , `additional_license_account_id`  string , `ewn_registration_key`  string , `facebook_page_id`  string , `instance_type`  string , `software_type`  string , `previous_supplier_id`  string , `migration_type`  string , `future_supplier_id`  string , `future_supplier_reason`  string , `individual_invoice`  string , `last_updated`  string , `total_bookings`  string , `last_booking_timestamp`  string , `last_booking_data`  string , `basic_information`  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_newbookinstances/2024-11-05/1730866510'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances"
}
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:53:28",
        "disabled": false,
        "format": "raw",
        "id": 2637,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookinstances"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "additional_license_account_id": "string",
            "admin_email": "string",
            "admin_fax": "string",
            "admin_phone": "string",
            "allow_animals": "string",
            "allow_children": "string",
            "allow_infants": "string",
            "api_key": "string",
            "base_license_account_id": "string",
            "basic_information": "string",
            "bom_radar_code": "string",
            "checkin_time": "string",
            "checkout_time": "string",
            "closing_time": "string",
            "contact_person": "string",
            "corporation_id": "string",
            "corporation_sync": "string",
            "created_when": "string",
            "date_format": "string",
            "default_client_account_id": "string",
            "duplicate_detection": "string",
            "error_email": "string",
            "ewn_registration_key": "string",
            "facebook_page_id": "string",
            "firstrun": "string",
            "future_supplier_id": "string",
            "future_supplier_reason": "string",
            "grace_period": "string",
            "id": "string",
            "individual_invoice": "string",
            "instance_type": "string",
            "last_booking_data": "string",
            "last_booking_timestamp": "string",
            "last_updated": "string",
            "lat": "string",
            "login_code": "string",
            "login_type": "string",
            "long": "string",
            "mailing_city": "string",
            "mailing_country_id": "string",
            "mailing_postcode": "string",
            "mailing_state_id": "string",
            "mailing_street": "string",
            "manager_name": "string",
            "migration_type": "string",
            "name": "string",
            "newbook_contract_date": "string",
            "newbook_generic_url": "string",
            "newbook_region": "string",
            "newbook_review_date": "string",
            "newbook_start_date": "string",
            "newbook_stop_date": "string",
            "opened_on": "string",
            "opening_time": "string",
            "physical_city": "string",
            "physical_country_id": "string",
            "physical_postcode": "string",
            "physical_state_id": "string",
            "physical_street": "string",
            "previous_supplier_id": "string",
            "read_only": "string",
            "sales_email": "string",
            "sales_fax": "string",
            "sales_phone": "string",
            "secure_login": "string",
            "software_type": "string",
            "status": "string",
            "survey_email": "string",
            "tax_id": "string",
            "tenant": "string",
            "time_format": "string",
            "total_bookings": "string",
            "trading_name": "string",
            "weather_station_code": "string",
            "website": "string"
        },
        "created": "2024-11-05 23:14:37",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `api_key`  string , `corporation_id`  string , `corporation_sync`  string , `duplicate_detection`  string , `tax_id`  string , `login_code`  string , `newbook_generic_url`  string , `weather_station_code`  string , `bom_radar_code`  string , `lat`  string , `long`  string , `name`  string , `trading_name`  string , `created_when`  string , `opened_on`  string , `newbook_contract_date`  string , `newbook_start_date`  string , `newbook_review_date`  string , `newbook_stop_date`  string , `physical_street`  string , `physical_city`  string , `physical_state_id`  string , `physical_postcode`  string , `physical_country_id`  string , `mailing_street`  string , `mailing_city`  string , `mailing_state_id`  string , `mailing_postcode`  string , `mailing_country_id`  string , `sales_email`  string , `sales_phone`  string , `sales_fax`  string , `admin_email`  string , `admin_phone`  string , `admin_fax`  string , `survey_email`  string , `error_email`  string , `contact_person`  string , `manager_name`  string , `opening_time`  string , `closing_time`  string , `checkin_time`  string , `checkout_time`  string , `date_format`  string , `time_format`  string , `website`  string , `allow_children`  string , `allow_infants`  string , `allow_animals`  string , `status`  string , `read_only`  string , `grace_period`  string , `firstrun`  string , `login_type`  string , `secure_login`  string , `default_client_account_id`  string , `base_license_account_id`  string , `additional_license_account_id`  string , `ewn_registration_key`  string , `facebook_page_id`  string , `instance_type`  string , `software_type`  string , `previous_supplier_id`  string , `migration_type`  string , `future_supplier_id`  string , `future_supplier_reason`  string , `individual_invoice`  string , `last_updated`  string , `total_bookings`  string , `last_booking_timestamp`  string , `last_booking_data`  string , `basic_information`  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_newbookinstances/2024-11-05/1730866510'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances"
        }
    },
    "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