Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookcrs_rates

created: 2024-10-08 17:45:41
disabled: False
format: raw
id: 2529
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748597

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_rates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_rates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `tariff_type_id`  string , `category_id`  string , `stop_sold`  string , `closed_for_arrivals`  string , `closed_for_departures`  string , `min_stay_duration`  string , `max_stay_duration`  string , `min_days_in_advance`  string , `max_days_in_advance`  string , `included_adults`  string , `included_children`  string , `included_infants`  string , `included_animals`  string , `included_combined`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `min_charge_per_night`  string , `base_price`  string , `additional_adult_price`  string , `additional_child_price`  string , `additional_infant_price`  string , `additional_animal_price`  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_newbookcrs_rates/2024-11-05/1730866445'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_rates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcrs_rates/2024-11-05/1730866445
id: 4748597
processed: 1

raw_data:

{
    "additional_adult_price": 27,
    "additional_animal_price": 30,
    "additional_child_price": 28,
    "additional_infant_price": 29,
    "base_price": 26,
    "category_id": 6,
    "closed_for_arrivals": 8,
    "closed_for_departures": 9,
    "date": 3,
    "id": 2,
    "included_adults": 14,
    "included_animals": 17,
    "included_children": 15,
    "included_combined": 18,
    "included_infants": 16,
    "instance_id": 4,
    "max_adults": 19,
    "max_animals": 22,
    "max_children": 20,
    "max_combined": 24,
    "max_days_in_advance": 13,
    "max_infants": 21,
    "max_stay_duration": 11,
    "min_charge_per_night": 25,
    "min_combined": 23,
    "min_days_in_advance": 12,
    "min_stay_duration": 10,
    "newbook_region": 0,
    "stop_sold": 7,
    "tariff_type_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "additional_adult_price": "string",
    "additional_animal_price": "string",
    "additional_child_price": "string",
    "additional_infant_price": "string",
    "base_price": "string",
    "category_id": "string",
    "closed_for_arrivals": "string",
    "closed_for_departures": "string",
    "date": "string",
    "id": "string",
    "included_adults": "string",
    "included_animals": "string",
    "included_children": "string",
    "included_combined": "string",
    "included_infants": "string",
    "instance_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_days_in_advance": "string",
    "max_infants": "string",
    "max_stay_duration": "string",
    "min_charge_per_night": "string",
    "min_combined": "string",
    "min_days_in_advance": "string",
    "min_stay_duration": "string",
    "newbook_region": "string",
    "stop_sold": "string",
    "tariff_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2529
schema_scan_id: 6674629
updated: 2024-11-05 22:52:58

Version 4748082

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_rates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_rates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `tariff_type_id`  string , `category_id`  string , `stop_sold`  string , `closed_for_arrivals`  string , `closed_for_departures`  string , `min_stay_duration`  string , `max_stay_duration`  string , `min_days_in_advance`  string , `max_days_in_advance`  string , `included_adults`  string , `included_children`  string , `included_infants`  string , `included_animals`  string , `included_combined`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `min_charge_per_night`  string , `base_price`  string , `additional_adult_price`  string , `additional_child_price`  string , `additional_infant_price`  string , `additional_animal_price`  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_newbookcrs_rates/2024-11-05/1730866360'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_rates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcrs_rates/2024-11-05/1730866360
id: 4748082
processed: 1

raw_data:

{
    "additional_adult_price": 27,
    "additional_animal_price": 30,
    "additional_child_price": 28,
    "additional_infant_price": 29,
    "base_price": 26,
    "category_id": 6,
    "closed_for_arrivals": 8,
    "closed_for_departures": 9,
    "date": 3,
    "id": 2,
    "included_adults": 14,
    "included_animals": 17,
    "included_children": 15,
    "included_combined": 18,
    "included_infants": 16,
    "instance_id": 4,
    "max_adults": 19,
    "max_animals": 22,
    "max_children": 20,
    "max_combined": 24,
    "max_days_in_advance": 13,
    "max_infants": 21,
    "max_stay_duration": 11,
    "min_charge_per_night": 25,
    "min_combined": 23,
    "min_days_in_advance": 12,
    "min_stay_duration": 10,
    "newbook_region": 0,
    "stop_sold": 7,
    "tariff_type_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "additional_adult_price": "string",
    "additional_animal_price": "string",
    "additional_child_price": "string",
    "additional_infant_price": "string",
    "base_price": "string",
    "category_id": "string",
    "closed_for_arrivals": "string",
    "closed_for_departures": "string",
    "date": "string",
    "id": "string",
    "included_adults": "string",
    "included_animals": "string",
    "included_children": "string",
    "included_combined": "string",
    "included_infants": "string",
    "instance_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_days_in_advance": "string",
    "max_infants": "string",
    "max_stay_duration": "string",
    "min_charge_per_night": "string",
    "min_combined": "string",
    "min_days_in_advance": "string",
    "min_stay_duration": "string",
    "newbook_region": "string",
    "stop_sold": "string",
    "tariff_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2529
schema_scan_id: 6674114
updated: 2024-11-05 22:34:29

Version 4747552

created: 2024-11-05 22:19:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_rates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_rates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `tariff_type_id`  string , `category_id`  string , `stop_sold`  string , `closed_for_arrivals`  string , `closed_for_departures`  string , `min_stay_duration`  string , `max_stay_duration`  string , `min_days_in_advance`  string , `max_days_in_advance`  string , `included_adults`  string , `included_children`  string , `included_infants`  string , `included_animals`  string , `included_combined`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `min_charge_per_night`  string , `base_price`  string , `additional_adult_price`  string , `additional_child_price`  string , `additional_infant_price`  string , `additional_animal_price`  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_newbookcrs_rates/2024-11-05/1730866265'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_rates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcrs_rates/2024-11-05/1730866265
id: 4747552
processed: 1

raw_data:

{
    "additional_adult_price": 27,
    "additional_animal_price": 30,
    "additional_child_price": 28,
    "additional_infant_price": 29,
    "base_price": 26,
    "category_id": 6,
    "closed_for_arrivals": 8,
    "closed_for_departures": 9,
    "date": 3,
    "id": 2,
    "included_adults": 14,
    "included_animals": 17,
    "included_children": 15,
    "included_combined": 18,
    "included_infants": 16,
    "instance_id": 4,
    "max_adults": 19,
    "max_animals": 22,
    "max_children": 20,
    "max_combined": 24,
    "max_days_in_advance": 13,
    "max_infants": 21,
    "max_stay_duration": 11,
    "min_charge_per_night": 25,
    "min_combined": 23,
    "min_days_in_advance": 12,
    "min_stay_duration": 10,
    "newbook_region": 0,
    "stop_sold": 7,
    "tariff_type_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "additional_adult_price": "string",
    "additional_animal_price": "string",
    "additional_child_price": "string",
    "additional_infant_price": "string",
    "base_price": "string",
    "category_id": "string",
    "closed_for_arrivals": "string",
    "closed_for_departures": "string",
    "date": "string",
    "id": "string",
    "included_adults": "string",
    "included_animals": "string",
    "included_children": "string",
    "included_combined": "string",
    "included_infants": "string",
    "instance_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_days_in_advance": "string",
    "max_infants": "string",
    "max_stay_duration": "string",
    "min_charge_per_night": "string",
    "min_combined": "string",
    "min_days_in_advance": "string",
    "min_stay_duration": "string",
    "newbook_region": "string",
    "stop_sold": "string",
    "tariff_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2529
schema_scan_id: 6673584
updated: 2024-11-05 22:20:02

Version 4746733

created: 2024-11-05 04:19:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_rates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_rates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `tariff_type_id`  string , `category_id`  string , `stop_sold`  string , `closed_for_arrivals`  string , `closed_for_departures`  string , `min_stay_duration`  string , `max_stay_duration`  string , `min_days_in_advance`  string , `max_days_in_advance`  string , `included_adults`  string , `included_children`  string , `included_infants`  string , `included_animals`  string , `included_combined`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `min_charge_per_night`  string , `base_price`  string , `additional_adult_price`  string , `additional_child_price`  string , `additional_infant_price`  string , `additional_animal_price`  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_newbookcrs_rates/2024-11-04/1730785686'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_rates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcrs_rates/2024-11-04/1730785686
id: 4746733
processed: 1

raw_data:

{
    "additional_adult_price": 27,
    "additional_animal_price": 30,
    "additional_child_price": 28,
    "additional_infant_price": 29,
    "base_price": 26,
    "category_id": 6,
    "closed_for_arrivals": 8,
    "closed_for_departures": 9,
    "date": 3,
    "id": 2,
    "included_adults": 14,
    "included_animals": 17,
    "included_children": 15,
    "included_combined": 18,
    "included_infants": 16,
    "instance_id": 4,
    "max_adults": 19,
    "max_animals": 22,
    "max_children": 20,
    "max_combined": 24,
    "max_days_in_advance": 13,
    "max_infants": 21,
    "max_stay_duration": 11,
    "min_charge_per_night": 25,
    "min_combined": 23,
    "min_days_in_advance": 12,
    "min_stay_duration": 10,
    "newbook_region": 0,
    "stop_sold": 7,
    "tariff_type_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "additional_adult_price": "string",
    "additional_animal_price": "string",
    "additional_child_price": "string",
    "additional_infant_price": "string",
    "base_price": "string",
    "category_id": "string",
    "closed_for_arrivals": "string",
    "closed_for_departures": "string",
    "date": "string",
    "id": "string",
    "included_adults": "string",
    "included_animals": "string",
    "included_children": "string",
    "included_combined": "string",
    "included_infants": "string",
    "instance_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_days_in_advance": "string",
    "max_infants": "string",
    "max_stay_duration": "string",
    "min_charge_per_night": "string",
    "min_combined": "string",
    "min_days_in_advance": "string",
    "min_stay_duration": "string",
    "newbook_region": "string",
    "stop_sold": "string",
    "tariff_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2529
schema_scan_id: 6671957
updated: 2024-11-05 04:19:34

Version 4746055

created: 2024-11-05 03:47:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_rates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_rates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `tariff_type_id`  string , `category_id`  string , `stop_sold`  string , `closed_for_arrivals`  string , `closed_for_departures`  string , `min_stay_duration`  string , `max_stay_duration`  string , `min_days_in_advance`  string , `max_days_in_advance`  string , `included_adults`  string , `included_children`  string , `included_infants`  string , `included_animals`  string , `included_combined`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `min_charge_per_night`  string , `base_price`  string , `additional_adult_price`  string , `additional_child_price`  string , `additional_infant_price`  string , `additional_animal_price`  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_newbookcrs_rates/2024-11-04/1730785104'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_rates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcrs_rates/2024-11-04/1730785104
id: 4746055
processed: 1

raw_data:

{
    "additional_adult_price": 27,
    "additional_animal_price": 30,
    "additional_child_price": 28,
    "additional_infant_price": 29,
    "base_price": 26,
    "category_id": 6,
    "closed_for_arrivals": 8,
    "closed_for_departures": 9,
    "date": 3,
    "id": 2,
    "included_adults": 14,
    "included_animals": 17,
    "included_children": 15,
    "included_combined": 18,
    "included_infants": 16,
    "instance_id": 4,
    "max_adults": 19,
    "max_animals": 22,
    "max_children": 20,
    "max_combined": 24,
    "max_days_in_advance": 13,
    "max_infants": 21,
    "max_stay_duration": 11,
    "min_charge_per_night": 25,
    "min_combined": 23,
    "min_days_in_advance": 12,
    "min_stay_duration": 10,
    "newbook_region": 0,
    "stop_sold": 7,
    "tariff_type_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "additional_adult_price": "string",
    "additional_animal_price": "string",
    "additional_child_price": "string",
    "additional_infant_price": "string",
    "base_price": "string",
    "category_id": "string",
    "closed_for_arrivals": "string",
    "closed_for_departures": "string",
    "date": "string",
    "id": "string",
    "included_adults": "string",
    "included_animals": "string",
    "included_children": "string",
    "included_combined": "string",
    "included_infants": "string",
    "instance_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_days_in_advance": "string",
    "max_infants": "string",
    "max_stay_duration": "string",
    "min_charge_per_night": "string",
    "min_combined": "string",
    "min_days_in_advance": "string",
    "min_stay_duration": "string",
    "newbook_region": "string",
    "stop_sold": "string",
    "tariff_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2529
schema_scan_id: 6671275
updated: 2024-11-05 03:47:52

Version 4745264

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_rates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_rates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `tariff_type_id`  string , `category_id`  string , `stop_sold`  string , `closed_for_arrivals`  string , `closed_for_departures`  string , `min_stay_duration`  string , `max_stay_duration`  string , `min_days_in_advance`  string , `max_days_in_advance`  string , `included_adults`  string , `included_children`  string , `included_infants`  string , `included_animals`  string , `included_combined`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `min_charge_per_night`  string , `base_price`  string , `additional_adult_price`  string , `additional_child_price`  string , `additional_infant_price`  string , `additional_animal_price`  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_newbookcrs_rates/2024-11-04/1730784799'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_rates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcrs_rates/2024-11-04/1730784799
id: 4745264
processed: 1

raw_data:

{
    "additional_adult_price": 27,
    "additional_animal_price": 30,
    "additional_child_price": 28,
    "additional_infant_price": 29,
    "base_price": 26,
    "category_id": 6,
    "closed_for_arrivals": 8,
    "closed_for_departures": 9,
    "date": 3,
    "id": 2,
    "included_adults": 14,
    "included_animals": 17,
    "included_children": 15,
    "included_combined": 18,
    "included_infants": 16,
    "instance_id": 4,
    "max_adults": 19,
    "max_animals": 22,
    "max_children": 20,
    "max_combined": 24,
    "max_days_in_advance": 13,
    "max_infants": 21,
    "max_stay_duration": 11,
    "min_charge_per_night": 25,
    "min_combined": 23,
    "min_days_in_advance": 12,
    "min_stay_duration": 10,
    "newbook_region": 0,
    "stop_sold": 7,
    "tariff_type_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "additional_adult_price": "string",
    "additional_animal_price": "string",
    "additional_child_price": "string",
    "additional_infant_price": "string",
    "base_price": "string",
    "category_id": "string",
    "closed_for_arrivals": "string",
    "closed_for_departures": "string",
    "date": "string",
    "id": "string",
    "included_adults": "string",
    "included_animals": "string",
    "included_children": "string",
    "included_combined": "string",
    "included_infants": "string",
    "instance_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_days_in_advance": "string",
    "max_infants": "string",
    "max_stay_duration": "string",
    "min_charge_per_night": "string",
    "min_combined": "string",
    "min_days_in_advance": "string",
    "min_stay_duration": "string",
    "newbook_region": "string",
    "stop_sold": "string",
    "tariff_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2529
schema_scan_id: 6670481
updated: 2024-11-05 03:25:08

Version 4745012

created: 2024-11-05 03:18:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_rates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_rates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `tariff_type_id`  string , `category_id`  string , `stop_sold`  string , `closed_for_arrivals`  string , `closed_for_departures`  string , `min_stay_duration`  string , `max_stay_duration`  string , `min_days_in_advance`  string , `max_days_in_advance`  string , `included_adults`  string , `included_children`  string , `included_infants`  string , `included_animals`  string , `included_combined`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `min_charge_per_night`  string , `base_price`  string , `additional_adult_price`  string , `additional_child_price`  string , `additional_infant_price`  string , `additional_animal_price`  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_newbookcrs_rates/2024-11-04/1730784196'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_rates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcrs_rates/2024-11-04/1730784196
id: 4745012
processed: 1

raw_data:

{
    "additional_adult_price": 27,
    "additional_animal_price": 30,
    "additional_child_price": 28,
    "additional_infant_price": 29,
    "base_price": 26,
    "category_id": 6,
    "closed_for_arrivals": 8,
    "closed_for_departures": 9,
    "date": 3,
    "id": 2,
    "included_adults": 14,
    "included_animals": 17,
    "included_children": 15,
    "included_combined": 18,
    "included_infants": 16,
    "instance_id": 4,
    "max_adults": 19,
    "max_animals": 22,
    "max_children": 20,
    "max_combined": 24,
    "max_days_in_advance": 13,
    "max_infants": 21,
    "max_stay_duration": 11,
    "min_charge_per_night": 25,
    "min_combined": 23,
    "min_days_in_advance": 12,
    "min_stay_duration": 10,
    "newbook_region": 0,
    "stop_sold": 7,
    "tariff_type_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "additional_adult_price": "string",
    "additional_animal_price": "string",
    "additional_child_price": "string",
    "additional_infant_price": "string",
    "base_price": "string",
    "category_id": "string",
    "closed_for_arrivals": "string",
    "closed_for_departures": "string",
    "date": "string",
    "id": "string",
    "included_adults": "string",
    "included_animals": "string",
    "included_children": "string",
    "included_combined": "string",
    "included_infants": "string",
    "instance_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_days_in_advance": "string",
    "max_infants": "string",
    "max_stay_duration": "string",
    "min_charge_per_night": "string",
    "min_combined": "string",
    "min_days_in_advance": "string",
    "min_stay_duration": "string",
    "newbook_region": "string",
    "stop_sold": "string",
    "tariff_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2529
schema_scan_id: 6670229
updated: 2024-11-05 03:18:29

Version 4743811

created: 2024-11-05 02:46:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_rates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_rates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `tariff_type_id`  string , `category_id`  string , `stop_sold`  string , `closed_for_arrivals`  string , `closed_for_departures`  string , `min_stay_duration`  string , `max_stay_duration`  string , `min_days_in_advance`  string , `max_days_in_advance`  string , `included_adults`  string , `included_children`  string , `included_infants`  string , `included_animals`  string , `included_combined`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `min_charge_per_night`  string , `base_price`  string , `additional_adult_price`  string , `additional_child_price`  string , `additional_infant_price`  string , `additional_animal_price`  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_newbookcrs_rates/2024-11-04/1730784033'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_rates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcrs_rates/2024-11-04/1730784033
id: 4743811
processed: 1

raw_data:

{
    "additional_adult_price": 27,
    "additional_animal_price": 30,
    "additional_child_price": 28,
    "additional_infant_price": 29,
    "base_price": 26,
    "category_id": 6,
    "closed_for_arrivals": 8,
    "closed_for_departures": 9,
    "date": 3,
    "id": 2,
    "included_adults": 14,
    "included_animals": 17,
    "included_children": 15,
    "included_combined": 18,
    "included_infants": 16,
    "instance_id": 4,
    "max_adults": 19,
    "max_animals": 22,
    "max_children": 20,
    "max_combined": 24,
    "max_days_in_advance": 13,
    "max_infants": 21,
    "max_stay_duration": 11,
    "min_charge_per_night": 25,
    "min_combined": 23,
    "min_days_in_advance": 12,
    "min_stay_duration": 10,
    "newbook_region": 0,
    "stop_sold": 7,
    "tariff_type_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "additional_adult_price": "string",
    "additional_animal_price": "string",
    "additional_child_price": "string",
    "additional_infant_price": "string",
    "base_price": "string",
    "category_id": "string",
    "closed_for_arrivals": "string",
    "closed_for_departures": "string",
    "date": "string",
    "id": "string",
    "included_adults": "string",
    "included_animals": "string",
    "included_children": "string",
    "included_combined": "string",
    "included_infants": "string",
    "instance_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_days_in_advance": "string",
    "max_infants": "string",
    "max_stay_duration": "string",
    "min_charge_per_night": "string",
    "min_combined": "string",
    "min_days_in_advance": "string",
    "min_stay_duration": "string",
    "newbook_region": "string",
    "stop_sold": "string",
    "tariff_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2529
schema_scan_id: 6669027
updated: 2024-11-05 02:46:42

Version 4743415

created: 2024-11-05 02:36:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_rates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_rates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `tariff_type_id`  string , `category_id`  string , `stop_sold`  string , `closed_for_arrivals`  string , `closed_for_departures`  string , `min_stay_duration`  string , `max_stay_duration`  string , `min_days_in_advance`  string , `max_days_in_advance`  string , `included_adults`  string , `included_children`  string , `included_infants`  string , `included_animals`  string , `included_combined`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `min_charge_per_night`  string , `base_price`  string , `additional_adult_price`  string , `additional_child_price`  string , `additional_infant_price`  string , `additional_animal_price`  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_newbookcrs_rates/2024-11-04/1730783884'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_rates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcrs_rates/2024-11-04/1730783884
id: 4743415
processed: 1

raw_data:

{
    "additional_adult_price": 27,
    "additional_animal_price": 30,
    "additional_child_price": 28,
    "additional_infant_price": 29,
    "base_price": 26,
    "category_id": 6,
    "closed_for_arrivals": 8,
    "closed_for_departures": 9,
    "date": 3,
    "id": 2,
    "included_adults": 14,
    "included_animals": 17,
    "included_children": 15,
    "included_combined": 18,
    "included_infants": 16,
    "instance_id": 4,
    "max_adults": 19,
    "max_animals": 22,
    "max_children": 20,
    "max_combined": 24,
    "max_days_in_advance": 13,
    "max_infants": 21,
    "max_stay_duration": 11,
    "min_charge_per_night": 25,
    "min_combined": 23,
    "min_days_in_advance": 12,
    "min_stay_duration": 10,
    "newbook_region": 0,
    "stop_sold": 7,
    "tariff_type_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "additional_adult_price": "string",
    "additional_animal_price": "string",
    "additional_child_price": "string",
    "additional_infant_price": "string",
    "base_price": "string",
    "category_id": "string",
    "closed_for_arrivals": "string",
    "closed_for_departures": "string",
    "date": "string",
    "id": "string",
    "included_adults": "string",
    "included_animals": "string",
    "included_children": "string",
    "included_combined": "string",
    "included_infants": "string",
    "instance_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_days_in_advance": "string",
    "max_infants": "string",
    "max_stay_duration": "string",
    "min_charge_per_night": "string",
    "min_combined": "string",
    "min_days_in_advance": "string",
    "min_stay_duration": "string",
    "newbook_region": "string",
    "stop_sold": "string",
    "tariff_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2529
schema_scan_id: 6668631
updated: 2024-11-05 02:36:13

Version 4741920

created: 2024-11-05 01:56:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_rates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_rates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `tariff_type_id`  string , `category_id`  string , `stop_sold`  string , `closed_for_arrivals`  string , `closed_for_departures`  string , `min_stay_duration`  string , `max_stay_duration`  string , `min_days_in_advance`  string , `max_days_in_advance`  string , `included_adults`  string , `included_children`  string , `included_infants`  string , `included_animals`  string , `included_combined`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `min_charge_per_night`  string , `base_price`  string , `additional_adult_price`  string , `additional_child_price`  string , `additional_infant_price`  string , `additional_animal_price`  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_newbookcrs_rates/2024-11-04/1730783746'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_rates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcrs_rates/2024-11-04/1730783746
id: 4741920
processed: 1

raw_data:

{
    "additional_adult_price": 27,
    "additional_animal_price": 30,
    "additional_child_price": 28,
    "additional_infant_price": 29,
    "base_price": 26,
    "category_id": 6,
    "closed_for_arrivals": 8,
    "closed_for_departures": 9,
    "date": 3,
    "id": 2,
    "included_adults": 14,
    "included_animals": 17,
    "included_children": 15,
    "included_combined": 18,
    "included_infants": 16,
    "instance_id": 4,
    "max_adults": 19,
    "max_animals": 22,
    "max_children": 20,
    "max_combined": 24,
    "max_days_in_advance": 13,
    "max_infants": 21,
    "max_stay_duration": 11,
    "min_charge_per_night": 25,
    "min_combined": 23,
    "min_days_in_advance": 12,
    "min_stay_duration": 10,
    "newbook_region": 0,
    "stop_sold": 7,
    "tariff_type_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "additional_adult_price": "string",
    "additional_animal_price": "string",
    "additional_child_price": "string",
    "additional_infant_price": "string",
    "base_price": "string",
    "category_id": "string",
    "closed_for_arrivals": "string",
    "closed_for_departures": "string",
    "date": "string",
    "id": "string",
    "included_adults": "string",
    "included_animals": "string",
    "included_children": "string",
    "included_combined": "string",
    "included_infants": "string",
    "instance_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_days_in_advance": "string",
    "max_infants": "string",
    "max_stay_duration": "string",
    "min_charge_per_night": "string",
    "min_combined": "string",
    "min_days_in_advance": "string",
    "min_stay_duration": "string",
    "newbook_region": "string",
    "stop_sold": "string",
    "tariff_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2529
schema_scan_id: 6667137
updated: 2024-11-05 01:56:28

Version 4741262

created: 2024-11-05 01:39:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_rates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_rates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `tariff_type_id`  string , `category_id`  string , `stop_sold`  string , `closed_for_arrivals`  string , `closed_for_departures`  string , `min_stay_duration`  string , `max_stay_duration`  string , `min_days_in_advance`  string , `max_days_in_advance`  string , `included_adults`  string , `included_children`  string , `included_infants`  string , `included_animals`  string , `included_combined`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `min_charge_per_night`  string , `base_price`  string , `additional_adult_price`  string , `additional_child_price`  string , `additional_infant_price`  string , `additional_animal_price`  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_newbookcrs_rates/2024-11-04/1730783649'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_rates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcrs_rates/2024-11-04/1730783649
id: 4741262
processed: 1

raw_data:

{
    "additional_adult_price": 27,
    "additional_animal_price": 30,
    "additional_child_price": 28,
    "additional_infant_price": 29,
    "base_price": 26,
    "category_id": 6,
    "closed_for_arrivals": 8,
    "closed_for_departures": 9,
    "date": 3,
    "id": 2,
    "included_adults": 14,
    "included_animals": 17,
    "included_children": 15,
    "included_combined": 18,
    "included_infants": 16,
    "instance_id": 4,
    "max_adults": 19,
    "max_animals": 22,
    "max_children": 20,
    "max_combined": 24,
    "max_days_in_advance": 13,
    "max_infants": 21,
    "max_stay_duration": 11,
    "min_charge_per_night": 25,
    "min_combined": 23,
    "min_days_in_advance": 12,
    "min_stay_duration": 10,
    "newbook_region": 0,
    "stop_sold": 7,
    "tariff_type_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "additional_adult_price": "string",
    "additional_animal_price": "string",
    "additional_child_price": "string",
    "additional_infant_price": "string",
    "base_price": "string",
    "category_id": "string",
    "closed_for_arrivals": "string",
    "closed_for_departures": "string",
    "date": "string",
    "id": "string",
    "included_adults": "string",
    "included_animals": "string",
    "included_children": "string",
    "included_combined": "string",
    "included_infants": "string",
    "instance_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_days_in_advance": "string",
    "max_infants": "string",
    "max_stay_duration": "string",
    "min_charge_per_night": "string",
    "min_combined": "string",
    "min_days_in_advance": "string",
    "min_stay_duration": "string",
    "newbook_region": "string",
    "stop_sold": "string",
    "tariff_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2529
schema_scan_id: 6666479
updated: 2024-11-05 01:39:12

Version 4741102

created: 2024-11-05 01:34:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_rates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_rates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `tariff_type_id`  string , `category_id`  string , `stop_sold`  string , `closed_for_arrivals`  string , `closed_for_departures`  string , `min_stay_duration`  string , `max_stay_duration`  string , `min_days_in_advance`  string , `max_days_in_advance`  string , `included_adults`  string , `included_children`  string , `included_infants`  string , `included_animals`  string , `included_combined`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `min_charge_per_night`  string , `base_price`  string , `additional_adult_price`  string , `additional_child_price`  string , `additional_infant_price`  string , `additional_animal_price`  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_newbookcrs_rates/2024-11-04/1730783502'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_rates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcrs_rates/2024-11-04/1730783502
id: 4741102
processed: 1

raw_data:

{
    "additional_adult_price": 27,
    "additional_animal_price": 30,
    "additional_child_price": 28,
    "additional_infant_price": 29,
    "base_price": 26,
    "category_id": 6,
    "closed_for_arrivals": 8,
    "closed_for_departures": 9,
    "date": 3,
    "id": 2,
    "included_adults": 14,
    "included_animals": 17,
    "included_children": 15,
    "included_combined": 18,
    "included_infants": 16,
    "instance_id": 4,
    "max_adults": 19,
    "max_animals": 22,
    "max_children": 20,
    "max_combined": 24,
    "max_days_in_advance": 13,
    "max_infants": 21,
    "max_stay_duration": 11,
    "min_charge_per_night": 25,
    "min_combined": 23,
    "min_days_in_advance": 12,
    "min_stay_duration": 10,
    "newbook_region": 0,
    "stop_sold": 7,
    "tariff_type_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "additional_adult_price": "string",
    "additional_animal_price": "string",
    "additional_child_price": "string",
    "additional_infant_price": "string",
    "base_price": "string",
    "category_id": "string",
    "closed_for_arrivals": "string",
    "closed_for_departures": "string",
    "date": "string",
    "id": "string",
    "included_adults": "string",
    "included_animals": "string",
    "included_children": "string",
    "included_combined": "string",
    "included_infants": "string",
    "instance_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_days_in_advance": "string",
    "max_infants": "string",
    "max_stay_duration": "string",
    "min_charge_per_night": "string",
    "min_combined": "string",
    "min_days_in_advance": "string",
    "min_stay_duration": "string",
    "newbook_region": "string",
    "stop_sold": "string",
    "tariff_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2529
schema_scan_id: 6666319
updated: 2024-11-05 01:35:02

Version 4739908

created: 2024-11-05 01:03:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_rates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_rates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `tariff_type_id`  string , `category_id`  string , `stop_sold`  string , `closed_for_arrivals`  string , `closed_for_departures`  string , `min_stay_duration`  string , `max_stay_duration`  string , `min_days_in_advance`  string , `max_days_in_advance`  string , `included_adults`  string , `included_children`  string , `included_infants`  string , `included_animals`  string , `included_combined`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `min_charge_per_night`  string , `base_price`  string , `additional_adult_price`  string , `additional_child_price`  string , `additional_infant_price`  string , `additional_animal_price`  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_newbookcrs_rates/2024-11-04/1730783284'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_rates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcrs_rates/2024-11-04/1730783284
id: 4739908
processed: 1

raw_data:

{
    "additional_adult_price": 27,
    "additional_animal_price": 30,
    "additional_child_price": 28,
    "additional_infant_price": 29,
    "base_price": 26,
    "category_id": 6,
    "closed_for_arrivals": 8,
    "closed_for_departures": 9,
    "date": 3,
    "id": 2,
    "included_adults": 14,
    "included_animals": 17,
    "included_children": 15,
    "included_combined": 18,
    "included_infants": 16,
    "instance_id": 4,
    "max_adults": 19,
    "max_animals": 22,
    "max_children": 20,
    "max_combined": 24,
    "max_days_in_advance": 13,
    "max_infants": 21,
    "max_stay_duration": 11,
    "min_charge_per_night": 25,
    "min_combined": 23,
    "min_days_in_advance": 12,
    "min_stay_duration": 10,
    "newbook_region": 0,
    "stop_sold": 7,
    "tariff_type_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "additional_adult_price": "string",
    "additional_animal_price": "string",
    "additional_child_price": "string",
    "additional_infant_price": "string",
    "base_price": "string",
    "category_id": "string",
    "closed_for_arrivals": "string",
    "closed_for_departures": "string",
    "date": "string",
    "id": "string",
    "included_adults": "string",
    "included_animals": "string",
    "included_children": "string",
    "included_combined": "string",
    "included_infants": "string",
    "instance_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_days_in_advance": "string",
    "max_infants": "string",
    "max_stay_duration": "string",
    "min_charge_per_night": "string",
    "min_combined": "string",
    "min_days_in_advance": "string",
    "min_stay_duration": "string",
    "newbook_region": "string",
    "stop_sold": "string",
    "tariff_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2529
schema_scan_id: 6665125
updated: 2024-11-05 01:03:22

Version 4739546

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_rates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_rates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `tariff_type_id`  string , `category_id`  string , `stop_sold`  string , `closed_for_arrivals`  string , `closed_for_departures`  string , `min_stay_duration`  string , `max_stay_duration`  string , `min_days_in_advance`  string , `max_days_in_advance`  string , `included_adults`  string , `included_children`  string , `included_infants`  string , `included_animals`  string , `included_combined`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `min_charge_per_night`  string , `base_price`  string , `additional_adult_price`  string , `additional_child_price`  string , `additional_infant_price`  string , `additional_animal_price`  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_newbookcrs_rates/2024-11-04/1730782886'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_rates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcrs_rates/2024-11-04/1730782886
id: 4739546
processed: 1

raw_data:

{
    "additional_adult_price": 27,
    "additional_animal_price": 30,
    "additional_child_price": 28,
    "additional_infant_price": 29,
    "base_price": 26,
    "category_id": 6,
    "closed_for_arrivals": 8,
    "closed_for_departures": 9,
    "date": 3,
    "id": 2,
    "included_adults": 14,
    "included_animals": 17,
    "included_children": 15,
    "included_combined": 18,
    "included_infants": 16,
    "instance_id": 4,
    "max_adults": 19,
    "max_animals": 22,
    "max_children": 20,
    "max_combined": 24,
    "max_days_in_advance": 13,
    "max_infants": 21,
    "max_stay_duration": 11,
    "min_charge_per_night": 25,
    "min_combined": 23,
    "min_days_in_advance": 12,
    "min_stay_duration": 10,
    "newbook_region": 0,
    "stop_sold": 7,
    "tariff_type_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "additional_adult_price": "string",
    "additional_animal_price": "string",
    "additional_child_price": "string",
    "additional_infant_price": "string",
    "base_price": "string",
    "category_id": "string",
    "closed_for_arrivals": "string",
    "closed_for_departures": "string",
    "date": "string",
    "id": "string",
    "included_adults": "string",
    "included_animals": "string",
    "included_children": "string",
    "included_combined": "string",
    "included_infants": "string",
    "instance_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_days_in_advance": "string",
    "max_infants": "string",
    "max_stay_duration": "string",
    "min_charge_per_night": "string",
    "min_combined": "string",
    "min_days_in_advance": "string",
    "min_stay_duration": "string",
    "newbook_region": "string",
    "stop_sold": "string",
    "tariff_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2529
schema_scan_id: 6664761
updated: 2024-11-05 00:53:40

Version 4738643

created: 2024-11-05 00:29:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_rates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_rates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `tariff_type_id`  string , `category_id`  string , `stop_sold`  string , `closed_for_arrivals`  string , `closed_for_departures`  string , `min_stay_duration`  string , `max_stay_duration`  string , `min_days_in_advance`  string , `max_days_in_advance`  string , `included_adults`  string , `included_children`  string , `included_infants`  string , `included_animals`  string , `included_combined`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `min_charge_per_night`  string , `base_price`  string , `additional_adult_price`  string , `additional_child_price`  string , `additional_infant_price`  string , `additional_animal_price`  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_newbookcrs_rates/2024-11-04/1730782745'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_rates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcrs_rates/2024-11-04/1730782745
id: 4738643
processed: 1

raw_data:

{
    "additional_adult_price": 27,
    "additional_animal_price": 30,
    "additional_child_price": 28,
    "additional_infant_price": 29,
    "base_price": 26,
    "category_id": 6,
    "closed_for_arrivals": 8,
    "closed_for_departures": 9,
    "date": 3,
    "id": 2,
    "included_adults": 14,
    "included_animals": 17,
    "included_children": 15,
    "included_combined": 18,
    "included_infants": 16,
    "instance_id": 4,
    "max_adults": 19,
    "max_animals": 22,
    "max_children": 20,
    "max_combined": 24,
    "max_days_in_advance": 13,
    "max_infants": 21,
    "max_stay_duration": 11,
    "min_charge_per_night": 25,
    "min_combined": 23,
    "min_days_in_advance": 12,
    "min_stay_duration": 10,
    "newbook_region": 0,
    "stop_sold": 7,
    "tariff_type_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "additional_adult_price": "string",
    "additional_animal_price": "string",
    "additional_child_price": "string",
    "additional_infant_price": "string",
    "base_price": "string",
    "category_id": "string",
    "closed_for_arrivals": "string",
    "closed_for_departures": "string",
    "date": "string",
    "id": "string",
    "included_adults": "string",
    "included_animals": "string",
    "included_children": "string",
    "included_combined": "string",
    "included_infants": "string",
    "instance_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_days_in_advance": "string",
    "max_infants": "string",
    "max_stay_duration": "string",
    "min_charge_per_night": "string",
    "min_combined": "string",
    "min_days_in_advance": "string",
    "min_stay_duration": "string",
    "newbook_region": "string",
    "stop_sold": "string",
    "tariff_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2529
schema_scan_id: 6663855
updated: 2024-11-05 00:29:59

Schema Scans: 15

Last at 2024-11-05 22:52:45

Scan 6674629

duration: 0:00:12.465707

exit_message:

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

id: 6674629

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_newbookcrs_rates/2024-11-05/1730866445",
        "key": "raw/newbookdev_newbookcrs_rates/2024-11-05/1730866445/crs_rates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcrs_rates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13220612007905822084,
        "service_name": "drive-thru",
        "span_id": 6450715467512172209,
        "trace_id": 10499194296288066180
    }
}

running: False
schema_name_id: 2529
start_time: 2024-11-05 22:52:45
success: True
trace_id: 10499194296288066180

Scan 6674114

duration: 0:00:12.307255

exit_message:

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

id: 6674114

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_newbookcrs_rates/2024-11-05/1730866360",
        "key": "raw/newbookdev_newbookcrs_rates/2024-11-05/1730866360/crs_rates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcrs_rates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6893095305298247151,
        "service_name": "drive-thru",
        "span_id": 8545109477653733020,
        "trace_id": 8174233447607012436
    }
}

running: False
schema_name_id: 2529
start_time: 2024-11-05 22:34:17
success: True
trace_id: 8174233447607012436

Scan 6673584

duration: 0:00:11.943933

exit_message:

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

id: 6673584

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_newbookcrs_rates/2024-11-05/1730866265",
        "key": "raw/newbookdev_newbookcrs_rates/2024-11-05/1730866265/crs_rates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcrs_rates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3784885355004849285,
        "service_name": "drive-thru",
        "span_id": 15908192218620895033,
        "trace_id": 3963582601281508620
    }
}

running: False
schema_name_id: 2529
start_time: 2024-11-05 22:19:51
success: True
trace_id: 3963582601281508620

Scan 6671957

duration: 0:00:12.289501

exit_message:

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

id: 6671957

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_newbookcrs_rates/2024-11-04/1730785686",
        "key": "raw/newbookdev_newbookcrs_rates/2024-11-04/1730785686/crs_rates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcrs_rates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12299273507429275973,
        "service_name": "drive-thru",
        "span_id": 15859337643737452458,
        "trace_id": 11160381780681721611
    }
}

running: False
schema_name_id: 2529
start_time: 2024-11-05 04:19:22
success: True
trace_id: 11160381780681721611

Scan 6671275

duration: 0:00:14.843043

exit_message:

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

id: 6671275

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_newbookcrs_rates/2024-11-04/1730785104",
        "key": "raw/newbookdev_newbookcrs_rates/2024-11-04/1730785104/crs_rates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcrs_rates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13423012036698460297,
        "service_name": "drive-thru",
        "span_id": 9144018611809921208,
        "trace_id": 6417496580330118385
    }
}

running: False
schema_name_id: 2529
start_time: 2024-11-05 03:47:38
success: True
trace_id: 6417496580330118385

Scan 6670481

duration: 0:00:14.388295

exit_message:

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

id: 6670481

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_newbookcrs_rates/2024-11-04/1730784799",
        "key": "raw/newbookdev_newbookcrs_rates/2024-11-04/1730784799/crs_rates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcrs_rates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6179269691246960906,
        "service_name": "drive-thru",
        "span_id": 7443797639291689574,
        "trace_id": 10719466721733025849
    }
}

running: False
schema_name_id: 2529
start_time: 2024-11-05 03:24:54
success: True
trace_id: 10719466721733025849

Scan 6670229

duration: 0:00:11.629073

exit_message:

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

id: 6670229

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_newbookcrs_rates/2024-11-04/1730784196",
        "key": "raw/newbookdev_newbookcrs_rates/2024-11-04/1730784196/crs_rates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcrs_rates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1883617810186706021,
        "service_name": "drive-thru",
        "span_id": 3664694120778447108,
        "trace_id": 13531124585995596500
    }
}

running: False
schema_name_id: 2529
start_time: 2024-11-05 03:18:18
success: True
trace_id: 13531124585995596500

Scan 6669027

duration: 0:00:11.926704

exit_message:

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

id: 6669027

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_newbookcrs_rates/2024-11-04/1730784033",
        "key": "raw/newbookdev_newbookcrs_rates/2024-11-04/1730784033/crs_rates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcrs_rates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12310977707017121831,
        "service_name": "drive-thru",
        "span_id": 16645507436644787766,
        "trace_id": 10370250892848930094
    }
}

running: False
schema_name_id: 2529
start_time: 2024-11-05 02:46:30
success: True
trace_id: 10370250892848930094

Scan 6668631

duration: 0:00:12.146803

exit_message:

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

id: 6668631

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_newbookcrs_rates/2024-11-04/1730783884",
        "key": "raw/newbookdev_newbookcrs_rates/2024-11-04/1730783884/crs_rates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcrs_rates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17883900691700383091,
        "service_name": "drive-thru",
        "span_id": 16260665003182761172,
        "trace_id": 17560365208900833755
    }
}

running: False
schema_name_id: 2529
start_time: 2024-11-05 02:36:01
success: True
trace_id: 17560365208900833755

Scan 6667137

duration: 0:00:12.025097

exit_message:

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

id: 6667137

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_newbookcrs_rates/2024-11-04/1730783746",
        "key": "raw/newbookdev_newbookcrs_rates/2024-11-04/1730783746/crs_rates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcrs_rates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18170324154822789256,
        "service_name": "drive-thru",
        "span_id": 14604900718496823059,
        "trace_id": 11020676908618173366
    }
}

running: False
schema_name_id: 2529
start_time: 2024-11-05 01:56:16
success: True
trace_id: 11020676908618173366

Scan 6666479

duration: 0:00:12.139853

exit_message:

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

id: 6666479

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_newbookcrs_rates/2024-11-04/1730783649",
        "key": "raw/newbookdev_newbookcrs_rates/2024-11-04/1730783649/crs_rates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcrs_rates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 474408689288610013,
        "service_name": "drive-thru",
        "span_id": 3170929993368837977,
        "trace_id": 10580951857970395882
    }
}

running: False
schema_name_id: 2529
start_time: 2024-11-05 01:39:00
success: True
trace_id: 10580951857970395882

Scan 6666319

duration: 0:00:11.956338

exit_message:

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

id: 6666319

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_newbookcrs_rates/2024-11-04/1730783502",
        "key": "raw/newbookdev_newbookcrs_rates/2024-11-04/1730783502/crs_rates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcrs_rates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9962863317280238214,
        "service_name": "drive-thru",
        "span_id": 6792626658281753441,
        "trace_id": 2587641887734331855
    }
}

running: False
schema_name_id: 2529
start_time: 2024-11-05 01:34:50
success: True
trace_id: 2587641887734331855

Scan 6665125

duration: 0:00:12.010469

exit_message:

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

id: 6665125

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_newbookcrs_rates/2024-11-04/1730783284",
        "key": "raw/newbookdev_newbookcrs_rates/2024-11-04/1730783284/crs_rates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcrs_rates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8393080132724863040,
        "service_name": "drive-thru",
        "span_id": 14790767792396970448,
        "trace_id": 11960888933611800832
    }
}

running: False
schema_name_id: 2529
start_time: 2024-11-05 01:03:10
success: True
trace_id: 11960888933611800832

Scan 6664761

duration: 0:00:14.622072

exit_message:

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

id: 6664761

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_newbookcrs_rates/2024-11-04/1730782886",
        "key": "raw/newbookdev_newbookcrs_rates/2024-11-04/1730782886/crs_rates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcrs_rates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11141942498707653071,
        "service_name": "drive-thru",
        "span_id": 7743475263864113334,
        "trace_id": 6027854863952836773
    }
}

running: False
schema_name_id: 2529
start_time: 2024-11-05 00:53:25
success: True
trace_id: 6027854863952836773

Scan 6663855

duration: 0:00:14.601775

exit_message:

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

id: 6663855

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_newbookcrs_rates/2024-11-04/1730782745",
        "key": "raw/newbookdev_newbookcrs_rates/2024-11-04/1730782745/crs_rates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcrs_rates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11757698891619569779,
        "service_name": "drive-thru",
        "span_id": 2035678883657583856,
        "trace_id": 9663386394742543063
    }
}

running: False
schema_name_id: 2529
start_time: 2024-11-05 00:29:45
success: True
trace_id: 9663386394742543063

Partitions:

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

Schema:

attributes:

{
    "additional_adult_price": "string",
    "additional_animal_price": "string",
    "additional_child_price": "string",
    "additional_infant_price": "string",
    "base_price": "string",
    "category_id": "string",
    "closed_for_arrivals": "string",
    "closed_for_departures": "string",
    "date": "string",
    "id": "string",
    "included_adults": "string",
    "included_animals": "string",
    "included_children": "string",
    "included_combined": "string",
    "included_infants": "string",
    "instance_id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_days_in_advance": "string",
    "max_infants": "string",
    "max_stay_duration": "string",
    "min_charge_per_night": "string",
    "min_combined": "string",
    "min_days_in_advance": "string",
    "min_stay_duration": "string",
    "newbook_region": "string",
    "stop_sold": "string",
    "tariff_type_id": "string",
    "tenant": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_rates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `tariff_type_id`  string , `category_id`  string , `stop_sold`  string , `closed_for_arrivals`  string , `closed_for_departures`  string , `min_stay_duration`  string , `max_stay_duration`  string , `min_days_in_advance`  string , `max_days_in_advance`  string , `included_adults`  string , `included_children`  string , `included_infants`  string , `included_animals`  string , `included_combined`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `min_charge_per_night`  string , `base_price`  string , `additional_adult_price`  string , `additional_child_price`  string , `additional_infant_price`  string , `additional_animal_price`  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_newbookcrs_rates/2024-11-05/1730866445'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_rates`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_rates"
}

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:45:41",
        "disabled": false,
        "format": "raw",
        "id": 2529,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookcrs_rates"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "additional_adult_price": "string",
            "additional_animal_price": "string",
            "additional_child_price": "string",
            "additional_infant_price": "string",
            "base_price": "string",
            "category_id": "string",
            "closed_for_arrivals": "string",
            "closed_for_departures": "string",
            "date": "string",
            "id": "string",
            "included_adults": "string",
            "included_animals": "string",
            "included_children": "string",
            "included_combined": "string",
            "included_infants": "string",
            "instance_id": "string",
            "max_adults": "string",
            "max_animals": "string",
            "max_children": "string",
            "max_combined": "string",
            "max_days_in_advance": "string",
            "max_infants": "string",
            "max_stay_duration": "string",
            "min_charge_per_night": "string",
            "min_combined": "string",
            "min_days_in_advance": "string",
            "min_stay_duration": "string",
            "newbook_region": "string",
            "stop_sold": "string",
            "tariff_type_id": "string",
            "tenant": "string"
        },
        "created": "2024-11-05 22:52:46",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_rates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `tariff_type_id`  string , `category_id`  string , `stop_sold`  string , `closed_for_arrivals`  string , `closed_for_departures`  string , `min_stay_duration`  string , `max_stay_duration`  string , `min_days_in_advance`  string , `max_days_in_advance`  string , `included_adults`  string , `included_children`  string , `included_infants`  string , `included_animals`  string , `included_combined`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `min_combined`  string , `max_combined`  string , `min_charge_per_night`  string , `base_price`  string , `additional_adult_price`  string , `additional_child_price`  string , `additional_infant_price`  string , `additional_animal_price`  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_newbookcrs_rates/2024-11-05/1730866445'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_rates`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_rates"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}