Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link

created: 2024-10-08 18:28:17
disabled: False
format: raw
id: 2991
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749494

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `guest_id`  string , `primary_client`  string , `instance_id`  string , `booking_id`  string , `booking_site_name`  string , `booking_source_name`  string , `booking_adults`  string , `booking_children`  string , `booking_infants`  string , `booking_animals`  string , `discount_id`  string , `discount_code_id`  string , `booking_period_from`  string , `booking_period_to`  string , `booking_status`  string , `booking_booked_by`  string , `booking_booked_when`  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_newbookshared_guests_bookings_link/2024-11-05/1730866600'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_guests_bookings_link/2024-11-05/1730866600
id: 4749494
processed: 1

raw_data:

{
    "booking_adults": 9,
    "booking_animals": 12,
    "booking_booked_by": 18,
    "booking_booked_when": 19,
    "booking_children": 10,
    "booking_id": 6,
    "booking_infants": 11,
    "booking_period_from": 15,
    "booking_period_to": 16,
    "booking_site_name": 7,
    "booking_source_name": 8,
    "booking_status": 17,
    "discount_code_id": 14,
    "discount_id": 13,
    "guest_id": 3,
    "id": 2,
    "instance_id": 5,
    "newbook_region": 0,
    "primary_client": 4,
    "tenant": 1
}

schema_attributes:

{
    "booking_adults": "string",
    "booking_animals": "string",
    "booking_booked_by": "string",
    "booking_booked_when": "string",
    "booking_children": "string",
    "booking_id": "string",
    "booking_infants": "string",
    "booking_period_from": "string",
    "booking_period_to": "string",
    "booking_site_name": "string",
    "booking_source_name": "string",
    "booking_status": "string",
    "discount_code_id": "string",
    "discount_id": "string",
    "guest_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

schema_name_id: 2991
schema_scan_id: 6675567
updated: 2024-11-05 23:57:30

Version 4748972

created: 2024-11-05 23:11:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `guest_id`  string , `primary_client`  string , `instance_id`  string , `booking_id`  string , `booking_site_name`  string , `booking_source_name`  string , `booking_adults`  string , `booking_children`  string , `booking_infants`  string , `booking_animals`  string , `discount_id`  string , `discount_code_id`  string , `booking_period_from`  string , `booking_period_to`  string , `booking_status`  string , `booking_booked_by`  string , `booking_booked_when`  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_newbookshared_guests_bookings_link/2024-11-05/1730866543'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_guests_bookings_link/2024-11-05/1730866543
id: 4748972
processed: 1

raw_data:

{
    "booking_adults": 9,
    "booking_animals": 12,
    "booking_booked_by": 18,
    "booking_booked_when": 19,
    "booking_children": 10,
    "booking_id": 6,
    "booking_infants": 11,
    "booking_period_from": 15,
    "booking_period_to": 16,
    "booking_site_name": 7,
    "booking_source_name": 8,
    "booking_status": 17,
    "discount_code_id": 14,
    "discount_id": 13,
    "guest_id": 3,
    "id": 2,
    "instance_id": 5,
    "newbook_region": 0,
    "primary_client": 4,
    "tenant": 1
}

schema_attributes:

{
    "booking_adults": "string",
    "booking_animals": "string",
    "booking_booked_by": "string",
    "booking_booked_when": "string",
    "booking_children": "string",
    "booking_id": "string",
    "booking_infants": "string",
    "booking_period_from": "string",
    "booking_period_to": "string",
    "booking_site_name": "string",
    "booking_source_name": "string",
    "booking_status": "string",
    "discount_code_id": "string",
    "discount_id": "string",
    "guest_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

schema_name_id: 2991
schema_scan_id: 6675004
updated: 2024-11-05 23:11:53

Version 4748481

created: 2024-11-05 22:47:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `guest_id`  string , `primary_client`  string , `instance_id`  string , `booking_id`  string , `booking_site_name`  string , `booking_source_name`  string , `booking_adults`  string , `booking_children`  string , `booking_infants`  string , `booking_animals`  string , `discount_id`  string , `discount_code_id`  string , `booking_period_from`  string , `booking_period_to`  string , `booking_status`  string , `booking_booked_by`  string , `booking_booked_when`  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_newbookshared_guests_bookings_link/2024-11-05/1730866431'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_guests_bookings_link/2024-11-05/1730866431
id: 4748481
processed: 1

raw_data:

{
    "booking_adults": 9,
    "booking_animals": 12,
    "booking_booked_by": 18,
    "booking_booked_when": 19,
    "booking_children": 10,
    "booking_id": 6,
    "booking_infants": 11,
    "booking_period_from": 15,
    "booking_period_to": 16,
    "booking_site_name": 7,
    "booking_source_name": 8,
    "booking_status": 17,
    "discount_code_id": 14,
    "discount_id": 13,
    "guest_id": 3,
    "id": 2,
    "instance_id": 5,
    "newbook_region": 0,
    "primary_client": 4,
    "tenant": 1
}

schema_attributes:

{
    "booking_adults": "string",
    "booking_animals": "string",
    "booking_booked_by": "string",
    "booking_booked_when": "string",
    "booking_children": "string",
    "booking_id": "string",
    "booking_infants": "string",
    "booking_period_from": "string",
    "booking_period_to": "string",
    "booking_site_name": "string",
    "booking_source_name": "string",
    "booking_status": "string",
    "discount_code_id": "string",
    "discount_id": "string",
    "guest_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

schema_name_id: 2991
schema_scan_id: 6674513
updated: 2024-11-05 22:48:02

Version 4747094

created: 2024-11-05 04:49:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `guest_id`  string , `primary_client`  string , `instance_id`  string , `booking_id`  string , `booking_site_name`  string , `booking_source_name`  string , `booking_adults`  string , `booking_children`  string , `booking_infants`  string , `booking_animals`  string , `discount_id`  string , `discount_code_id`  string , `booking_period_from`  string , `booking_period_to`  string , `booking_status`  string , `booking_booked_by`  string , `booking_booked_when`  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_newbookshared_guests_bookings_link/2024-11-04/1730785793'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_guests_bookings_link/2024-11-04/1730785793
id: 4747094
processed: 1

raw_data:

{
    "booking_adults": 9,
    "booking_animals": 12,
    "booking_booked_by": 18,
    "booking_booked_when": 19,
    "booking_children": 10,
    "booking_id": 6,
    "booking_infants": 11,
    "booking_period_from": 15,
    "booking_period_to": 16,
    "booking_site_name": 7,
    "booking_source_name": 8,
    "booking_status": 17,
    "discount_code_id": 14,
    "discount_id": 13,
    "guest_id": 3,
    "id": 2,
    "instance_id": 5,
    "newbook_region": 0,
    "primary_client": 4,
    "tenant": 1
}

schema_attributes:

{
    "booking_adults": "string",
    "booking_animals": "string",
    "booking_booked_by": "string",
    "booking_booked_when": "string",
    "booking_children": "string",
    "booking_id": "string",
    "booking_infants": "string",
    "booking_period_from": "string",
    "booking_period_to": "string",
    "booking_site_name": "string",
    "booking_source_name": "string",
    "booking_status": "string",
    "discount_code_id": "string",
    "discount_id": "string",
    "guest_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

schema_name_id: 2991
schema_scan_id: 6672326
updated: 2024-11-05 04:49:54

Version 4746431

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `guest_id`  string , `primary_client`  string , `instance_id`  string , `booking_id`  string , `booking_site_name`  string , `booking_source_name`  string , `booking_adults`  string , `booking_children`  string , `booking_infants`  string , `booking_animals`  string , `discount_id`  string , `discount_code_id`  string , `booking_period_from`  string , `booking_period_to`  string , `booking_status`  string , `booking_booked_by`  string , `booking_booked_when`  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_newbookshared_guests_bookings_link/2024-11-04/1730785165'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_guests_bookings_link/2024-11-04/1730785165
id: 4746431
processed: 1

raw_data:

{
    "booking_adults": 9,
    "booking_animals": 12,
    "booking_booked_by": 18,
    "booking_booked_when": 19,
    "booking_children": 10,
    "booking_id": 6,
    "booking_infants": 11,
    "booking_period_from": 15,
    "booking_period_to": 16,
    "booking_site_name": 7,
    "booking_source_name": 8,
    "booking_status": 17,
    "discount_code_id": 14,
    "discount_id": 13,
    "guest_id": 3,
    "id": 2,
    "instance_id": 5,
    "newbook_region": 0,
    "primary_client": 4,
    "tenant": 1
}

schema_attributes:

{
    "booking_adults": "string",
    "booking_animals": "string",
    "booking_booked_by": "string",
    "booking_booked_when": "string",
    "booking_children": "string",
    "booking_id": "string",
    "booking_infants": "string",
    "booking_period_from": "string",
    "booking_period_to": "string",
    "booking_site_name": "string",
    "booking_source_name": "string",
    "booking_status": "string",
    "discount_code_id": "string",
    "discount_id": "string",
    "guest_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

schema_name_id: 2991
schema_scan_id: 6671652
updated: 2024-11-05 04:02:59

Version 4745701

created: 2024-11-05 03:36:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `guest_id`  string , `primary_client`  string , `instance_id`  string , `booking_id`  string , `booking_site_name`  string , `booking_source_name`  string , `booking_adults`  string , `booking_children`  string , `booking_infants`  string , `booking_animals`  string , `discount_id`  string , `discount_code_id`  string , `booking_period_from`  string , `booking_period_to`  string , `booking_status`  string , `booking_booked_by`  string , `booking_booked_when`  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_newbookshared_guests_bookings_link/2024-11-04/1730784860'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_guests_bookings_link/2024-11-04/1730784860
id: 4745701
processed: 1

raw_data:

{
    "booking_adults": 9,
    "booking_animals": 12,
    "booking_booked_by": 18,
    "booking_booked_when": 19,
    "booking_children": 10,
    "booking_id": 6,
    "booking_infants": 11,
    "booking_period_from": 15,
    "booking_period_to": 16,
    "booking_site_name": 7,
    "booking_source_name": 8,
    "booking_status": 17,
    "discount_code_id": 14,
    "discount_id": 13,
    "guest_id": 3,
    "id": 2,
    "instance_id": 5,
    "newbook_region": 0,
    "primary_client": 4,
    "tenant": 1
}

schema_attributes:

{
    "booking_adults": "string",
    "booking_animals": "string",
    "booking_booked_by": "string",
    "booking_booked_when": "string",
    "booking_children": "string",
    "booking_id": "string",
    "booking_infants": "string",
    "booking_period_from": "string",
    "booking_period_to": "string",
    "booking_site_name": "string",
    "booking_source_name": "string",
    "booking_status": "string",
    "discount_code_id": "string",
    "discount_id": "string",
    "guest_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

schema_name_id: 2991
schema_scan_id: 6670917
updated: 2024-11-05 03:36:32

Version 4745139

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `guest_id`  string , `primary_client`  string , `instance_id`  string , `booking_id`  string , `booking_site_name`  string , `booking_source_name`  string , `booking_adults`  string , `booking_children`  string , `booking_infants`  string , `booking_animals`  string , `discount_id`  string , `discount_code_id`  string , `booking_period_from`  string , `booking_period_to`  string , `booking_status`  string , `booking_booked_by`  string , `booking_booked_when`  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_newbookshared_guests_bookings_link/2024-11-04/1730784256'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_guests_bookings_link/2024-11-04/1730784256
id: 4745139
processed: 1

raw_data:

{
    "booking_adults": 9,
    "booking_animals": 12,
    "booking_booked_by": 18,
    "booking_booked_when": 19,
    "booking_children": 10,
    "booking_id": 6,
    "booking_infants": 11,
    "booking_period_from": 15,
    "booking_period_to": 16,
    "booking_site_name": 7,
    "booking_source_name": 8,
    "booking_status": 17,
    "discount_code_id": 14,
    "discount_id": 13,
    "guest_id": 3,
    "id": 2,
    "instance_id": 5,
    "newbook_region": 0,
    "primary_client": 4,
    "tenant": 1
}

schema_attributes:

{
    "booking_adults": "string",
    "booking_animals": "string",
    "booking_booked_by": "string",
    "booking_booked_when": "string",
    "booking_children": "string",
    "booking_id": "string",
    "booking_infants": "string",
    "booking_period_from": "string",
    "booking_period_to": "string",
    "booking_site_name": "string",
    "booking_source_name": "string",
    "booking_status": "string",
    "discount_code_id": "string",
    "discount_id": "string",
    "guest_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

schema_name_id: 2991
schema_scan_id: 6670356
updated: 2024-11-05 03:21:49

Version 4744107

created: 2024-11-05 02:54:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `guest_id`  string , `primary_client`  string , `instance_id`  string , `booking_id`  string , `booking_site_name`  string , `booking_source_name`  string , `booking_adults`  string , `booking_children`  string , `booking_infants`  string , `booking_animals`  string , `discount_id`  string , `discount_code_id`  string , `booking_period_from`  string , `booking_period_to`  string , `booking_status`  string , `booking_booked_by`  string , `booking_booked_when`  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_newbookshared_guests_bookings_link/2024-11-04/1730784094'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_guests_bookings_link/2024-11-04/1730784094
id: 4744107
processed: 1

raw_data:

{
    "booking_adults": 9,
    "booking_animals": 12,
    "booking_booked_by": 18,
    "booking_booked_when": 19,
    "booking_children": 10,
    "booking_id": 6,
    "booking_infants": 11,
    "booking_period_from": 15,
    "booking_period_to": 16,
    "booking_site_name": 7,
    "booking_source_name": 8,
    "booking_status": 17,
    "discount_code_id": 14,
    "discount_id": 13,
    "guest_id": 3,
    "id": 2,
    "instance_id": 5,
    "newbook_region": 0,
    "primary_client": 4,
    "tenant": 1
}

schema_attributes:

{
    "booking_adults": "string",
    "booking_animals": "string",
    "booking_booked_by": "string",
    "booking_booked_when": "string",
    "booking_children": "string",
    "booking_id": "string",
    "booking_infants": "string",
    "booking_period_from": "string",
    "booking_period_to": "string",
    "booking_site_name": "string",
    "booking_source_name": "string",
    "booking_status": "string",
    "discount_code_id": "string",
    "discount_id": "string",
    "guest_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

schema_name_id: 2991
schema_scan_id: 6669324
updated: 2024-11-05 02:54:27

Version 4743781

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `guest_id`  string , `primary_client`  string , `instance_id`  string , `booking_id`  string , `booking_site_name`  string , `booking_source_name`  string , `booking_adults`  string , `booking_children`  string , `booking_infants`  string , `booking_animals`  string , `discount_id`  string , `discount_code_id`  string , `booking_period_from`  string , `booking_period_to`  string , `booking_status`  string , `booking_booked_by`  string , `booking_booked_when`  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_newbookshared_guests_bookings_link/2024-11-04/1730783929'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_guests_bookings_link/2024-11-04/1730783929
id: 4743781
processed: 1

raw_data:

{
    "booking_adults": 9,
    "booking_animals": 12,
    "booking_booked_by": 18,
    "booking_booked_when": 19,
    "booking_children": 10,
    "booking_id": 6,
    "booking_infants": 11,
    "booking_period_from": 15,
    "booking_period_to": 16,
    "booking_site_name": 7,
    "booking_source_name": 8,
    "booking_status": 17,
    "discount_code_id": 14,
    "discount_id": 13,
    "guest_id": 3,
    "id": 2,
    "instance_id": 5,
    "newbook_region": 0,
    "primary_client": 4,
    "tenant": 1
}

schema_attributes:

{
    "booking_adults": "string",
    "booking_animals": "string",
    "booking_booked_by": "string",
    "booking_booked_when": "string",
    "booking_children": "string",
    "booking_id": "string",
    "booking_infants": "string",
    "booking_period_from": "string",
    "booking_period_to": "string",
    "booking_site_name": "string",
    "booking_source_name": "string",
    "booking_status": "string",
    "discount_code_id": "string",
    "discount_id": "string",
    "guest_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

schema_name_id: 2991
schema_scan_id: 6668998
updated: 2024-11-05 02:45:52

Version 4742275

created: 2024-11-05 02:05:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `guest_id`  string , `primary_client`  string , `instance_id`  string , `booking_id`  string , `booking_site_name`  string , `booking_source_name`  string , `booking_adults`  string , `booking_children`  string , `booking_infants`  string , `booking_animals`  string , `discount_id`  string , `discount_code_id`  string , `booking_period_from`  string , `booking_period_to`  string , `booking_status`  string , `booking_booked_by`  string , `booking_booked_when`  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_newbookshared_guests_bookings_link/2024-11-04/1730783808'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_guests_bookings_link/2024-11-04/1730783808
id: 4742275
processed: 1

raw_data:

{
    "booking_adults": 9,
    "booking_animals": 12,
    "booking_booked_by": 18,
    "booking_booked_when": 19,
    "booking_children": 10,
    "booking_id": 6,
    "booking_infants": 11,
    "booking_period_from": 15,
    "booking_period_to": 16,
    "booking_site_name": 7,
    "booking_source_name": 8,
    "booking_status": 17,
    "discount_code_id": 14,
    "discount_id": 13,
    "guest_id": 3,
    "id": 2,
    "instance_id": 5,
    "newbook_region": 0,
    "primary_client": 4,
    "tenant": 1
}

schema_attributes:

{
    "booking_adults": "string",
    "booking_animals": "string",
    "booking_booked_by": "string",
    "booking_booked_when": "string",
    "booking_children": "string",
    "booking_id": "string",
    "booking_infants": "string",
    "booking_period_from": "string",
    "booking_period_to": "string",
    "booking_site_name": "string",
    "booking_source_name": "string",
    "booking_status": "string",
    "discount_code_id": "string",
    "discount_id": "string",
    "guest_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

schema_name_id: 2991
schema_scan_id: 6667492
updated: 2024-11-05 02:06:04

Version 4742180

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `guest_id`  string , `primary_client`  string , `instance_id`  string , `booking_id`  string , `booking_site_name`  string , `booking_source_name`  string , `booking_adults`  string , `booking_children`  string , `booking_infants`  string , `booking_animals`  string , `discount_id`  string , `discount_code_id`  string , `booking_period_from`  string , `booking_period_to`  string , `booking_status`  string , `booking_booked_by`  string , `booking_booked_when`  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_newbookshared_guests_bookings_link/2024-11-04/1730783695'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_guests_bookings_link/2024-11-04/1730783695
id: 4742180
processed: 1

raw_data:

{
    "booking_adults": 9,
    "booking_animals": 12,
    "booking_booked_by": 18,
    "booking_booked_when": 19,
    "booking_children": 10,
    "booking_id": 6,
    "booking_infants": 11,
    "booking_period_from": 15,
    "booking_period_to": 16,
    "booking_site_name": 7,
    "booking_source_name": 8,
    "booking_status": 17,
    "discount_code_id": 14,
    "discount_id": 13,
    "guest_id": 3,
    "id": 2,
    "instance_id": 5,
    "newbook_region": 0,
    "primary_client": 4,
    "tenant": 1
}

schema_attributes:

{
    "booking_adults": "string",
    "booking_animals": "string",
    "booking_booked_by": "string",
    "booking_booked_when": "string",
    "booking_children": "string",
    "booking_id": "string",
    "booking_infants": "string",
    "booking_period_from": "string",
    "booking_period_to": "string",
    "booking_site_name": "string",
    "booking_source_name": "string",
    "booking_status": "string",
    "discount_code_id": "string",
    "discount_id": "string",
    "guest_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

schema_name_id: 2991
schema_scan_id: 6667398
updated: 2024-11-05 02:03:27

Version 4741462

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `guest_id`  string , `primary_client`  string , `instance_id`  string , `booking_id`  string , `booking_site_name`  string , `booking_source_name`  string , `booking_adults`  string , `booking_children`  string , `booking_infants`  string , `booking_animals`  string , `discount_id`  string , `discount_code_id`  string , `booking_period_from`  string , `booking_period_to`  string , `booking_status`  string , `booking_booked_by`  string , `booking_booked_when`  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_newbookshared_guests_bookings_link/2024-11-04/1730783567'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_guests_bookings_link/2024-11-04/1730783567
id: 4741462
processed: 1

raw_data:

{
    "booking_adults": 9,
    "booking_animals": 12,
    "booking_booked_by": 18,
    "booking_booked_when": 19,
    "booking_children": 10,
    "booking_id": 6,
    "booking_infants": 11,
    "booking_period_from": 15,
    "booking_period_to": 16,
    "booking_site_name": 7,
    "booking_source_name": 8,
    "booking_status": 17,
    "discount_code_id": 14,
    "discount_id": 13,
    "guest_id": 3,
    "id": 2,
    "instance_id": 5,
    "newbook_region": 0,
    "primary_client": 4,
    "tenant": 1
}

schema_attributes:

{
    "booking_adults": "string",
    "booking_animals": "string",
    "booking_booked_by": "string",
    "booking_booked_when": "string",
    "booking_children": "string",
    "booking_id": "string",
    "booking_infants": "string",
    "booking_period_from": "string",
    "booking_period_to": "string",
    "booking_site_name": "string",
    "booking_source_name": "string",
    "booking_status": "string",
    "discount_code_id": "string",
    "discount_id": "string",
    "guest_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

schema_name_id: 2991
schema_scan_id: 6666679
updated: 2024-11-05 01:44:25

Version 4740481

created: 2024-11-05 01:18:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `guest_id`  string , `primary_client`  string , `instance_id`  string , `booking_id`  string , `booking_site_name`  string , `booking_source_name`  string , `booking_adults`  string , `booking_children`  string , `booking_infants`  string , `booking_animals`  string , `discount_id`  string , `discount_code_id`  string , `booking_period_from`  string , `booking_period_to`  string , `booking_status`  string , `booking_booked_by`  string , `booking_booked_when`  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_newbookshared_guests_bookings_link/2024-11-04/1730783346'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_guests_bookings_link/2024-11-04/1730783346
id: 4740481
processed: 1

raw_data:

{
    "booking_adults": 9,
    "booking_animals": 12,
    "booking_booked_by": 18,
    "booking_booked_when": 19,
    "booking_children": 10,
    "booking_id": 6,
    "booking_infants": 11,
    "booking_period_from": 15,
    "booking_period_to": 16,
    "booking_site_name": 7,
    "booking_source_name": 8,
    "booking_status": 17,
    "discount_code_id": 14,
    "discount_id": 13,
    "guest_id": 3,
    "id": 2,
    "instance_id": 5,
    "newbook_region": 0,
    "primary_client": 4,
    "tenant": 1
}

schema_attributes:

{
    "booking_adults": "string",
    "booking_animals": "string",
    "booking_booked_by": "string",
    "booking_booked_when": "string",
    "booking_children": "string",
    "booking_id": "string",
    "booking_infants": "string",
    "booking_period_from": "string",
    "booking_period_to": "string",
    "booking_site_name": "string",
    "booking_source_name": "string",
    "booking_status": "string",
    "discount_code_id": "string",
    "discount_id": "string",
    "guest_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

schema_name_id: 2991
schema_scan_id: 6665698
updated: 2024-11-05 01:18:40

Version 4739718

created: 2024-11-05 00:58:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `guest_id`  string , `primary_client`  string , `instance_id`  string , `booking_id`  string , `booking_site_name`  string , `booking_source_name`  string , `booking_adults`  string , `booking_children`  string , `booking_infants`  string , `booking_animals`  string , `discount_id`  string , `discount_code_id`  string , `booking_period_from`  string , `booking_period_to`  string , `booking_status`  string , `booking_booked_by`  string , `booking_booked_when`  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_newbookshared_guests_bookings_link/2024-11-04/1730782968'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_guests_bookings_link/2024-11-04/1730782968
id: 4739718
processed: 1

raw_data:

{
    "booking_adults": 9,
    "booking_animals": 12,
    "booking_booked_by": 18,
    "booking_booked_when": 19,
    "booking_children": 10,
    "booking_id": 6,
    "booking_infants": 11,
    "booking_period_from": 15,
    "booking_period_to": 16,
    "booking_site_name": 7,
    "booking_source_name": 8,
    "booking_status": 17,
    "discount_code_id": 14,
    "discount_id": 13,
    "guest_id": 3,
    "id": 2,
    "instance_id": 5,
    "newbook_region": 0,
    "primary_client": 4,
    "tenant": 1
}

schema_attributes:

{
    "booking_adults": "string",
    "booking_animals": "string",
    "booking_booked_by": "string",
    "booking_booked_when": "string",
    "booking_children": "string",
    "booking_id": "string",
    "booking_infants": "string",
    "booking_period_from": "string",
    "booking_period_to": "string",
    "booking_site_name": "string",
    "booking_source_name": "string",
    "booking_status": "string",
    "discount_code_id": "string",
    "discount_id": "string",
    "guest_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

schema_name_id: 2991
schema_scan_id: 6664935
updated: 2024-11-05 00:58:11

Version 4738942

created: 2024-11-05 00:37:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `guest_id`  string , `primary_client`  string , `instance_id`  string , `booking_id`  string , `booking_site_name`  string , `booking_source_name`  string , `booking_adults`  string , `booking_children`  string , `booking_infants`  string , `booking_animals`  string , `discount_id`  string , `discount_code_id`  string , `booking_period_from`  string , `booking_period_to`  string , `booking_status`  string , `booking_booked_by`  string , `booking_booked_when`  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_newbookshared_guests_bookings_link/2024-11-04/1730782835'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_guests_bookings_link/2024-11-04/1730782835
id: 4738942
processed: 1

raw_data:

{
    "booking_adults": 9,
    "booking_animals": 12,
    "booking_booked_by": 18,
    "booking_booked_when": 19,
    "booking_children": 10,
    "booking_id": 6,
    "booking_infants": 11,
    "booking_period_from": 15,
    "booking_period_to": 16,
    "booking_site_name": 7,
    "booking_source_name": 8,
    "booking_status": 17,
    "discount_code_id": 14,
    "discount_id": 13,
    "guest_id": 3,
    "id": 2,
    "instance_id": 5,
    "newbook_region": 0,
    "primary_client": 4,
    "tenant": 1
}

schema_attributes:

{
    "booking_adults": "string",
    "booking_animals": "string",
    "booking_booked_by": "string",
    "booking_booked_when": "string",
    "booking_children": "string",
    "booking_id": "string",
    "booking_infants": "string",
    "booking_period_from": "string",
    "booking_period_to": "string",
    "booking_site_name": "string",
    "booking_source_name": "string",
    "booking_status": "string",
    "discount_code_id": "string",
    "discount_id": "string",
    "guest_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

schema_name_id: 2991
schema_scan_id: 6664156
updated: 2024-11-05 00:37:55

Schema Scans: 15

Last at 2024-11-05 23:57:18

Scan 6675567

duration: 0:00:11.911151

exit_message:

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

id: 6675567

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_newbookshared_guests_bookings_link/2024-11-05/1730866600",
        "key": "raw/newbookdev_newbookshared_guests_bookings_link/2024-11-05/1730866600/shared_guests_bookings_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17784055568423507950,
        "service_name": "drive-thru",
        "span_id": 13816456042740363996,
        "trace_id": 13566812468668793886
    }
}

running: False
schema_name_id: 2991
start_time: 2024-11-05 23:57:18
success: True
trace_id: 13566812468668793886

Scan 6675004

duration: 0:00:12.016857

exit_message:

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

id: 6675004

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_newbookshared_guests_bookings_link/2024-11-05/1730866543",
        "key": "raw/newbookdev_newbookshared_guests_bookings_link/2024-11-05/1730866543/shared_guests_bookings_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4131641089298978632,
        "service_name": "drive-thru",
        "span_id": 7057143101107590102,
        "trace_id": 17264878673993581749
    }
}

running: False
schema_name_id: 2991
start_time: 2024-11-05 23:11:41
success: True
trace_id: 17264878673993581749

Scan 6674513

duration: 0:00:11.845643

exit_message:

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

id: 6674513

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_newbookshared_guests_bookings_link/2024-11-05/1730866431",
        "key": "raw/newbookdev_newbookshared_guests_bookings_link/2024-11-05/1730866431/shared_guests_bookings_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14977715245112860482,
        "service_name": "drive-thru",
        "span_id": 5977053491166162209,
        "trace_id": 14456869673361833430
    }
}

running: False
schema_name_id: 2991
start_time: 2024-11-05 22:47:50
success: True
trace_id: 14456869673361833430

Scan 6672326

duration: 0:00:14.507555

exit_message:

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

id: 6672326

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_newbookshared_guests_bookings_link/2024-11-04/1730785793",
        "key": "raw/newbookdev_newbookshared_guests_bookings_link/2024-11-04/1730785793/shared_guests_bookings_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8816496928452289178,
        "service_name": "drive-thru",
        "span_id": 10862254783702929679,
        "trace_id": 7650874683989722858
    }
}

running: False
schema_name_id: 2991
start_time: 2024-11-05 04:49:39
success: True
trace_id: 7650874683989722858

Scan 6671652

duration: 0:00:11.936426

exit_message:

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

id: 6671652

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_newbookshared_guests_bookings_link/2024-11-04/1730785165",
        "key": "raw/newbookdev_newbookshared_guests_bookings_link/2024-11-04/1730785165/shared_guests_bookings_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13434958505011424475,
        "service_name": "drive-thru",
        "span_id": 930439139214352253,
        "trace_id": 7464241544447874555
    }
}

running: False
schema_name_id: 2991
start_time: 2024-11-05 04:02:47
success: True
trace_id: 7464241544447874555

Scan 6670917

duration: 0:00:11.708149

exit_message:

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

id: 6670917

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_newbookshared_guests_bookings_link/2024-11-04/1730784860",
        "key": "raw/newbookdev_newbookshared_guests_bookings_link/2024-11-04/1730784860/shared_guests_bookings_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4039455106748389050,
        "service_name": "drive-thru",
        "span_id": 11282040910224029397,
        "trace_id": 2096899339517335316
    }
}

running: False
schema_name_id: 2991
start_time: 2024-11-05 03:36:20
success: True
trace_id: 2096899339517335316

Scan 6670356

duration: 0:00:11.709540

exit_message:

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

id: 6670356

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_newbookshared_guests_bookings_link/2024-11-04/1730784256",
        "key": "raw/newbookdev_newbookshared_guests_bookings_link/2024-11-04/1730784256/shared_guests_bookings_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7167526399728807843,
        "service_name": "drive-thru",
        "span_id": 13773028294681032321,
        "trace_id": 18152837284020282244
    }
}

running: False
schema_name_id: 2991
start_time: 2024-11-05 03:21:37
success: True
trace_id: 18152837284020282244

Scan 6669324

duration: 0:00:14.401226

exit_message:

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

id: 6669324

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_newbookshared_guests_bookings_link/2024-11-04/1730784094",
        "key": "raw/newbookdev_newbookshared_guests_bookings_link/2024-11-04/1730784094/shared_guests_bookings_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15106594391343029951,
        "service_name": "drive-thru",
        "span_id": 619532237244009967,
        "trace_id": 3001562740131154541
    }
}

running: False
schema_name_id: 2991
start_time: 2024-11-05 02:54:12
success: True
trace_id: 3001562740131154541

Scan 6668998

duration: 0:00:14.241696

exit_message:

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

id: 6668998

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_newbookshared_guests_bookings_link/2024-11-04/1730783929",
        "key": "raw/newbookdev_newbookshared_guests_bookings_link/2024-11-04/1730783929/shared_guests_bookings_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3291164434199104447,
        "service_name": "drive-thru",
        "span_id": 7074547147514055251,
        "trace_id": 15409164113944179618
    }
}

running: False
schema_name_id: 2991
start_time: 2024-11-05 02:45:38
success: True
trace_id: 15409164113944179618

Scan 6667492

duration: 0:00:11.717244

exit_message:

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

id: 6667492

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_newbookshared_guests_bookings_link/2024-11-04/1730783808",
        "key": "raw/newbookdev_newbookshared_guests_bookings_link/2024-11-04/1730783808/shared_guests_bookings_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11384147991605290500,
        "service_name": "drive-thru",
        "span_id": 1068948780742582864,
        "trace_id": 6209331485790394618
    }
}

running: False
schema_name_id: 2991
start_time: 2024-11-05 02:05:52
success: True
trace_id: 6209331485790394618

Scan 6667398

duration: 0:00:11.810939

exit_message:

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

id: 6667398

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_newbookshared_guests_bookings_link/2024-11-04/1730783695",
        "key": "raw/newbookdev_newbookshared_guests_bookings_link/2024-11-04/1730783695/shared_guests_bookings_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15937144357224962928,
        "service_name": "drive-thru",
        "span_id": 9639985223309226667,
        "trace_id": 12432489572970482499
    }
}

running: False
schema_name_id: 2991
start_time: 2024-11-05 02:03:15
success: True
trace_id: 12432489572970482499

Scan 6666679

duration: 0:00:11.731669

exit_message:

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

id: 6666679

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_newbookshared_guests_bookings_link/2024-11-04/1730783567",
        "key": "raw/newbookdev_newbookshared_guests_bookings_link/2024-11-04/1730783567/shared_guests_bookings_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11099609446368437501,
        "service_name": "drive-thru",
        "span_id": 2866870524344386423,
        "trace_id": 4471587191554449346
    }
}

running: False
schema_name_id: 2991
start_time: 2024-11-05 01:44:14
success: True
trace_id: 4471587191554449346

Scan 6665698

duration: 0:00:14.267764

exit_message:

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

id: 6665698

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_newbookshared_guests_bookings_link/2024-11-04/1730783346",
        "key": "raw/newbookdev_newbookshared_guests_bookings_link/2024-11-04/1730783346/shared_guests_bookings_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5009244615119044954,
        "service_name": "drive-thru",
        "span_id": 8343529140715595824,
        "trace_id": 6516445032848949987
    }
}

running: False
schema_name_id: 2991
start_time: 2024-11-05 01:18:26
success: True
trace_id: 6516445032848949987

Scan 6664935

duration: 0:00:11.982106

exit_message:

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

id: 6664935

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_newbookshared_guests_bookings_link/2024-11-04/1730782968",
        "key": "raw/newbookdev_newbookshared_guests_bookings_link/2024-11-04/1730782968/shared_guests_bookings_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4156142533150798477,
        "service_name": "drive-thru",
        "span_id": 7544794233237836115,
        "trace_id": 6018815700383816109
    }
}

running: False
schema_name_id: 2991
start_time: 2024-11-05 00:57:59
success: True
trace_id: 6018815700383816109

Scan 6664156

duration: 0:00:14.447394

exit_message:

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

id: 6664156

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_newbookshared_guests_bookings_link/2024-11-04/1730782835",
        "key": "raw/newbookdev_newbookshared_guests_bookings_link/2024-11-04/1730782835/shared_guests_bookings_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13825997538180153947,
        "service_name": "drive-thru",
        "span_id": 13615560805335769063,
        "trace_id": 18070058411460829804
    }
}

running: False
schema_name_id: 2991
start_time: 2024-11-05 00:37:41
success: True
trace_id: 18070058411460829804

Partitions:

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

Schema:

attributes:

{
    "booking_adults": "string",
    "booking_animals": "string",
    "booking_booked_by": "string",
    "booking_booked_when": "string",
    "booking_children": "string",
    "booking_id": "string",
    "booking_infants": "string",
    "booking_period_from": "string",
    "booking_period_to": "string",
    "booking_site_name": "string",
    "booking_source_name": "string",
    "booking_status": "string",
    "discount_code_id": "string",
    "discount_id": "string",
    "guest_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `guest_id`  string , `primary_client`  string , `instance_id`  string , `booking_id`  string , `booking_site_name`  string , `booking_source_name`  string , `booking_adults`  string , `booking_children`  string , `booking_infants`  string , `booking_animals`  string , `discount_id`  string , `discount_code_id`  string , `booking_period_from`  string , `booking_period_to`  string , `booking_status`  string , `booking_booked_by`  string , `booking_booked_when`  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_newbookshared_guests_bookings_link/2024-11-05/1730866600'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link"
}

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 18:28:17",
        "disabled": false,
        "format": "raw",
        "id": 2991,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookshared_guests_bookings_link"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "booking_adults": "string",
            "booking_animals": "string",
            "booking_booked_by": "string",
            "booking_booked_when": "string",
            "booking_children": "string",
            "booking_id": "string",
            "booking_infants": "string",
            "booking_period_from": "string",
            "booking_period_to": "string",
            "booking_site_name": "string",
            "booking_source_name": "string",
            "booking_status": "string",
            "discount_code_id": "string",
            "discount_id": "string",
            "guest_id": "string",
            "id": "string",
            "instance_id": "string",
            "newbook_region": "string",
            "primary_client": "string",
            "tenant": "string"
        },
        "created": "2024-11-05 23:57:19",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `guest_id`  string , `primary_client`  string , `instance_id`  string , `booking_id`  string , `booking_site_name`  string , `booking_source_name`  string , `booking_adults`  string , `booking_children`  string , `booking_infants`  string , `booking_animals`  string , `discount_id`  string , `discount_code_id`  string , `booking_period_from`  string , `booking_period_to`  string , `booking_status`  string , `booking_booked_by`  string , `booking_booked_when`  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_newbookshared_guests_bookings_link/2024-11-05/1730866600'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_guests_bookings_link"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}