Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookdefault_tasks

created: 2024-10-08 17:55:56
disabled: False
format: raw
id: 2672
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748574

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `priority`  string , `description`  string , `daytype`  string , `ignore_period_from`  string , `ignore_period_to`  string , `groupwith`  string , `interval`  string , `interval_multiplier`  string , `daysofweek`  string , `run_on_days`  string , `colour`  string , `chart_display_name`  string , `min_length`  string , `max_length`  string , `contact_template_id`  string , `contact_template_booking_status`  string , `allow_before_departure`  string , `billing_set_id`  string , `change_site_status`  string , `allow_online`  string , `allow_cm`  string , `booking_placed_after`  string , `booking_placed_before`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-05/1730866468'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookdefault_tasks"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-05/1730866468
id: 4748574
processed: 1

raw_data:

{
    "active": 27,
    "allow_before_departure": 20,
    "allow_cm": 24,
    "allow_online": 23,
    "billing_set_id": 21,
    "booking_placed_after": 25,
    "booking_placed_before": 26,
    "change_site_status": 22,
    "chart_display_name": 15,
    "colour": 14,
    "contact_template_booking_status": 19,
    "contact_template_id": 18,
    "daysofweek": 12,
    "daytype": 6,
    "description": 5,
    "groupwith": 9,
    "id": 2,
    "ignore_period_from": 7,
    "ignore_period_to": 8,
    "interval": 10,
    "interval_multiplier": 11,
    "max_length": 17,
    "min_length": 16,
    "newbook_region": 0,
    "priority": 4,
    "run_on_days": 13,
    "tenant": 1,
    "type_id": 3
}

schema_attributes:

{
    "active": "string",
    "allow_before_departure": "string",
    "allow_cm": "string",
    "allow_online": "string",
    "billing_set_id": "string",
    "booking_placed_after": "string",
    "booking_placed_before": "string",
    "change_site_status": "string",
    "chart_display_name": "string",
    "colour": "string",
    "contact_template_booking_status": "string",
    "contact_template_id": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "groupwith": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "max_length": "string",
    "min_length": "string",
    "newbook_region": "string",
    "priority": "string",
    "run_on_days": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 2672
schema_scan_id: 6674606
updated: 2024-11-05 22:52:01

Version 4748135

created: 2024-11-05 22:35:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `priority`  string , `description`  string , `daytype`  string , `ignore_period_from`  string , `ignore_period_to`  string , `groupwith`  string , `interval`  string , `interval_multiplier`  string , `daysofweek`  string , `run_on_days`  string , `colour`  string , `chart_display_name`  string , `min_length`  string , `max_length`  string , `contact_template_id`  string , `contact_template_booking_status`  string , `allow_before_departure`  string , `billing_set_id`  string , `change_site_status`  string , `allow_online`  string , `allow_cm`  string , `booking_placed_after`  string , `booking_placed_before`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-05/1730866381'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookdefault_tasks"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-05/1730866381
id: 4748135
processed: 1

raw_data:

{
    "active": 27,
    "allow_before_departure": 20,
    "allow_cm": 24,
    "allow_online": 23,
    "billing_set_id": 21,
    "booking_placed_after": 25,
    "booking_placed_before": 26,
    "change_site_status": 22,
    "chart_display_name": 15,
    "colour": 14,
    "contact_template_booking_status": 19,
    "contact_template_id": 18,
    "daysofweek": 12,
    "daytype": 6,
    "description": 5,
    "groupwith": 9,
    "id": 2,
    "ignore_period_from": 7,
    "ignore_period_to": 8,
    "interval": 10,
    "interval_multiplier": 11,
    "max_length": 17,
    "min_length": 16,
    "newbook_region": 0,
    "priority": 4,
    "run_on_days": 13,
    "tenant": 1,
    "type_id": 3
}

schema_attributes:

{
    "active": "string",
    "allow_before_departure": "string",
    "allow_cm": "string",
    "allow_online": "string",
    "billing_set_id": "string",
    "booking_placed_after": "string",
    "booking_placed_before": "string",
    "change_site_status": "string",
    "chart_display_name": "string",
    "colour": "string",
    "contact_template_booking_status": "string",
    "contact_template_id": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "groupwith": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "max_length": "string",
    "min_length": "string",
    "newbook_region": "string",
    "priority": "string",
    "run_on_days": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 2672
schema_scan_id: 6674167
updated: 2024-11-05 22:36:07

Version 4747595

created: 2024-11-05 22:20:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `priority`  string , `description`  string , `daytype`  string , `ignore_period_from`  string , `ignore_period_to`  string , `groupwith`  string , `interval`  string , `interval_multiplier`  string , `daysofweek`  string , `run_on_days`  string , `colour`  string , `chart_display_name`  string , `min_length`  string , `max_length`  string , `contact_template_id`  string , `contact_template_booking_status`  string , `allow_before_departure`  string , `billing_set_id`  string , `change_site_status`  string , `allow_online`  string , `allow_cm`  string , `booking_placed_after`  string , `booking_placed_before`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-05/1730866276'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookdefault_tasks"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-05/1730866276
id: 4747595
processed: 1

raw_data:

{
    "active": 27,
    "allow_before_departure": 20,
    "allow_cm": 24,
    "allow_online": 23,
    "billing_set_id": 21,
    "booking_placed_after": 25,
    "booking_placed_before": 26,
    "change_site_status": 22,
    "chart_display_name": 15,
    "colour": 14,
    "contact_template_booking_status": 19,
    "contact_template_id": 18,
    "daysofweek": 12,
    "daytype": 6,
    "description": 5,
    "groupwith": 9,
    "id": 2,
    "ignore_period_from": 7,
    "ignore_period_to": 8,
    "interval": 10,
    "interval_multiplier": 11,
    "max_length": 17,
    "min_length": 16,
    "newbook_region": 0,
    "priority": 4,
    "run_on_days": 13,
    "tenant": 1,
    "type_id": 3
}

schema_attributes:

{
    "active": "string",
    "allow_before_departure": "string",
    "allow_cm": "string",
    "allow_online": "string",
    "billing_set_id": "string",
    "booking_placed_after": "string",
    "booking_placed_before": "string",
    "change_site_status": "string",
    "chart_display_name": "string",
    "colour": "string",
    "contact_template_booking_status": "string",
    "contact_template_id": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "groupwith": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "max_length": "string",
    "min_length": "string",
    "newbook_region": "string",
    "priority": "string",
    "run_on_days": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 2672
schema_scan_id: 6673627
updated: 2024-11-05 22:21:12

Version 4746788

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `priority`  string , `description`  string , `daytype`  string , `ignore_period_from`  string , `ignore_period_to`  string , `groupwith`  string , `interval`  string , `interval_multiplier`  string , `daysofweek`  string , `run_on_days`  string , `colour`  string , `chart_display_name`  string , `min_length`  string , `max_length`  string , `contact_template_id`  string , `contact_template_booking_status`  string , `allow_before_departure`  string , `billing_set_id`  string , `change_site_status`  string , `allow_online`  string , `allow_cm`  string , `booking_placed_after`  string , `booking_placed_before`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-04/1730785697'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookdefault_tasks"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-04/1730785697
id: 4746788
processed: 1

raw_data:

{
    "active": 27,
    "allow_before_departure": 20,
    "allow_cm": 24,
    "allow_online": 23,
    "billing_set_id": 21,
    "booking_placed_after": 25,
    "booking_placed_before": 26,
    "change_site_status": 22,
    "chart_display_name": 15,
    "colour": 14,
    "contact_template_booking_status": 19,
    "contact_template_id": 18,
    "daysofweek": 12,
    "daytype": 6,
    "description": 5,
    "groupwith": 9,
    "id": 2,
    "ignore_period_from": 7,
    "ignore_period_to": 8,
    "interval": 10,
    "interval_multiplier": 11,
    "max_length": 17,
    "min_length": 16,
    "newbook_region": 0,
    "priority": 4,
    "run_on_days": 13,
    "tenant": 1,
    "type_id": 3
}

schema_attributes:

{
    "active": "string",
    "allow_before_departure": "string",
    "allow_cm": "string",
    "allow_online": "string",
    "billing_set_id": "string",
    "booking_placed_after": "string",
    "booking_placed_before": "string",
    "change_site_status": "string",
    "chart_display_name": "string",
    "colour": "string",
    "contact_template_booking_status": "string",
    "contact_template_id": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "groupwith": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "max_length": "string",
    "min_length": "string",
    "newbook_region": "string",
    "priority": "string",
    "run_on_days": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 2672
schema_scan_id: 6672016
updated: 2024-11-05 04:23:29

Version 4746101

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `priority`  string , `description`  string , `daytype`  string , `ignore_period_from`  string , `ignore_period_to`  string , `groupwith`  string , `interval`  string , `interval_multiplier`  string , `daysofweek`  string , `run_on_days`  string , `colour`  string , `chart_display_name`  string , `min_length`  string , `max_length`  string , `contact_template_id`  string , `contact_template_booking_status`  string , `allow_before_departure`  string , `billing_set_id`  string , `change_site_status`  string , `allow_online`  string , `allow_cm`  string , `booking_placed_after`  string , `booking_placed_before`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-04/1730785111'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookdefault_tasks"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-04/1730785111
id: 4746101
processed: 1

raw_data:

{
    "active": 27,
    "allow_before_departure": 20,
    "allow_cm": 24,
    "allow_online": 23,
    "billing_set_id": 21,
    "booking_placed_after": 25,
    "booking_placed_before": 26,
    "change_site_status": 22,
    "chart_display_name": 15,
    "colour": 14,
    "contact_template_booking_status": 19,
    "contact_template_id": 18,
    "daysofweek": 12,
    "daytype": 6,
    "description": 5,
    "groupwith": 9,
    "id": 2,
    "ignore_period_from": 7,
    "ignore_period_to": 8,
    "interval": 10,
    "interval_multiplier": 11,
    "max_length": 17,
    "min_length": 16,
    "newbook_region": 0,
    "priority": 4,
    "run_on_days": 13,
    "tenant": 1,
    "type_id": 3
}

schema_attributes:

{
    "active": "string",
    "allow_before_departure": "string",
    "allow_cm": "string",
    "allow_online": "string",
    "billing_set_id": "string",
    "booking_placed_after": "string",
    "booking_placed_before": "string",
    "change_site_status": "string",
    "chart_display_name": "string",
    "colour": "string",
    "contact_template_booking_status": "string",
    "contact_template_id": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "groupwith": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "max_length": "string",
    "min_length": "string",
    "newbook_region": "string",
    "priority": "string",
    "run_on_days": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 2672
schema_scan_id: 6671322
updated: 2024-11-05 03:49:29

Version 4744648

created: 2024-11-05 03:08:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `priority`  string , `description`  string , `daytype`  string , `ignore_period_from`  string , `ignore_period_to`  string , `groupwith`  string , `interval`  string , `interval_multiplier`  string , `daysofweek`  string , `run_on_days`  string , `colour`  string , `chart_display_name`  string , `min_length`  string , `max_length`  string , `contact_template_id`  string , `contact_template_booking_status`  string , `allow_before_departure`  string , `billing_set_id`  string , `change_site_status`  string , `allow_online`  string , `allow_cm`  string , `booking_placed_after`  string , `booking_placed_before`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-04/1730784806'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookdefault_tasks"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-04/1730784806
id: 4744648
processed: 1

raw_data:

{
    "active": 27,
    "allow_before_departure": 20,
    "allow_cm": 24,
    "allow_online": 23,
    "billing_set_id": 21,
    "booking_placed_after": 25,
    "booking_placed_before": 26,
    "change_site_status": 22,
    "chart_display_name": 15,
    "colour": 14,
    "contact_template_booking_status": 19,
    "contact_template_id": 18,
    "daysofweek": 12,
    "daytype": 6,
    "description": 5,
    "groupwith": 9,
    "id": 2,
    "ignore_period_from": 7,
    "ignore_period_to": 8,
    "interval": 10,
    "interval_multiplier": 11,
    "max_length": 17,
    "min_length": 16,
    "newbook_region": 0,
    "priority": 4,
    "run_on_days": 13,
    "tenant": 1,
    "type_id": 3
}

schema_attributes:

{
    "active": "string",
    "allow_before_departure": "string",
    "allow_cm": "string",
    "allow_online": "string",
    "billing_set_id": "string",
    "booking_placed_after": "string",
    "booking_placed_before": "string",
    "change_site_status": "string",
    "chart_display_name": "string",
    "colour": "string",
    "contact_template_booking_status": "string",
    "contact_template_id": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "groupwith": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "max_length": "string",
    "min_length": "string",
    "newbook_region": "string",
    "priority": "string",
    "run_on_days": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 2672
schema_scan_id: 6669865
updated: 2024-11-05 03:08:57

Version 4744148

created: 2024-11-05 02:55:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `priority`  string , `description`  string , `daytype`  string , `ignore_period_from`  string , `ignore_period_to`  string , `groupwith`  string , `interval`  string , `interval_multiplier`  string , `daysofweek`  string , `run_on_days`  string , `colour`  string , `chart_display_name`  string , `min_length`  string , `max_length`  string , `contact_template_id`  string , `contact_template_booking_status`  string , `allow_before_departure`  string , `billing_set_id`  string , `change_site_status`  string , `allow_online`  string , `allow_cm`  string , `booking_placed_after`  string , `booking_placed_before`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-04/1730784040'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookdefault_tasks"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-04/1730784040
id: 4744148
processed: 1

raw_data:

{
    "active": 27,
    "allow_before_departure": 20,
    "allow_cm": 24,
    "allow_online": 23,
    "billing_set_id": 21,
    "booking_placed_after": 25,
    "booking_placed_before": 26,
    "change_site_status": 22,
    "chart_display_name": 15,
    "colour": 14,
    "contact_template_booking_status": 19,
    "contact_template_id": 18,
    "daysofweek": 12,
    "daytype": 6,
    "description": 5,
    "groupwith": 9,
    "id": 2,
    "ignore_period_from": 7,
    "ignore_period_to": 8,
    "interval": 10,
    "interval_multiplier": 11,
    "max_length": 17,
    "min_length": 16,
    "newbook_region": 0,
    "priority": 4,
    "run_on_days": 13,
    "tenant": 1,
    "type_id": 3
}

schema_attributes:

{
    "active": "string",
    "allow_before_departure": "string",
    "allow_cm": "string",
    "allow_online": "string",
    "billing_set_id": "string",
    "booking_placed_after": "string",
    "booking_placed_before": "string",
    "change_site_status": "string",
    "chart_display_name": "string",
    "colour": "string",
    "contact_template_booking_status": "string",
    "contact_template_id": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "groupwith": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "max_length": "string",
    "min_length": "string",
    "newbook_region": "string",
    "priority": "string",
    "run_on_days": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 2672
schema_scan_id: 6669365
updated: 2024-11-05 02:55:32

Version 4744073

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `priority`  string , `description`  string , `daytype`  string , `ignore_period_from`  string , `ignore_period_to`  string , `groupwith`  string , `interval`  string , `interval_multiplier`  string , `daysofweek`  string , `run_on_days`  string , `colour`  string , `chart_display_name`  string , `min_length`  string , `max_length`  string , `contact_template_id`  string , `contact_template_booking_status`  string , `allow_before_departure`  string , `billing_set_id`  string , `change_site_status`  string , `allow_online`  string , `allow_cm`  string , `booking_placed_after`  string , `booking_placed_before`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-04/1730784203'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookdefault_tasks"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-04/1730784203
id: 4744073
processed: 1

raw_data:

{
    "active": 27,
    "allow_before_departure": 20,
    "allow_cm": 24,
    "allow_online": 23,
    "billing_set_id": 21,
    "booking_placed_after": 25,
    "booking_placed_before": 26,
    "change_site_status": 22,
    "chart_display_name": 15,
    "colour": 14,
    "contact_template_booking_status": 19,
    "contact_template_id": 18,
    "daysofweek": 12,
    "daytype": 6,
    "description": 5,
    "groupwith": 9,
    "id": 2,
    "ignore_period_from": 7,
    "ignore_period_to": 8,
    "interval": 10,
    "interval_multiplier": 11,
    "max_length": 17,
    "min_length": 16,
    "newbook_region": 0,
    "priority": 4,
    "run_on_days": 13,
    "tenant": 1,
    "type_id": 3
}

schema_attributes:

{
    "active": "string",
    "allow_before_departure": "string",
    "allow_cm": "string",
    "allow_online": "string",
    "billing_set_id": "string",
    "booking_placed_after": "string",
    "booking_placed_before": "string",
    "change_site_status": "string",
    "chart_display_name": "string",
    "colour": "string",
    "contact_template_booking_status": "string",
    "contact_template_id": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "groupwith": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "max_length": "string",
    "min_length": "string",
    "newbook_region": "string",
    "priority": "string",
    "run_on_days": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 2672
schema_scan_id: 6669290
updated: 2024-11-05 02:53:30

Version 4743330

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `priority`  string , `description`  string , `daytype`  string , `ignore_period_from`  string , `ignore_period_to`  string , `groupwith`  string , `interval`  string , `interval_multiplier`  string , `daysofweek`  string , `run_on_days`  string , `colour`  string , `chart_display_name`  string , `min_length`  string , `max_length`  string , `contact_template_id`  string , `contact_template_booking_status`  string , `allow_before_departure`  string , `billing_set_id`  string , `change_site_status`  string , `allow_online`  string , `allow_cm`  string , `booking_placed_after`  string , `booking_placed_before`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-04/1730783889'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookdefault_tasks"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-04/1730783889
id: 4743330
processed: 1

raw_data:

{
    "active": 27,
    "allow_before_departure": 20,
    "allow_cm": 24,
    "allow_online": 23,
    "billing_set_id": 21,
    "booking_placed_after": 25,
    "booking_placed_before": 26,
    "change_site_status": 22,
    "chart_display_name": 15,
    "colour": 14,
    "contact_template_booking_status": 19,
    "contact_template_id": 18,
    "daysofweek": 12,
    "daytype": 6,
    "description": 5,
    "groupwith": 9,
    "id": 2,
    "ignore_period_from": 7,
    "ignore_period_to": 8,
    "interval": 10,
    "interval_multiplier": 11,
    "max_length": 17,
    "min_length": 16,
    "newbook_region": 0,
    "priority": 4,
    "run_on_days": 13,
    "tenant": 1,
    "type_id": 3
}

schema_attributes:

{
    "active": "string",
    "allow_before_departure": "string",
    "allow_cm": "string",
    "allow_online": "string",
    "billing_set_id": "string",
    "booking_placed_after": "string",
    "booking_placed_before": "string",
    "change_site_status": "string",
    "chart_display_name": "string",
    "colour": "string",
    "contact_template_booking_status": "string",
    "contact_template_id": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "groupwith": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "max_length": "string",
    "min_length": "string",
    "newbook_region": "string",
    "priority": "string",
    "run_on_days": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 2672
schema_scan_id: 6668545
updated: 2024-11-05 02:33:55

Version 4741954

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `priority`  string , `description`  string , `daytype`  string , `ignore_period_from`  string , `ignore_period_to`  string , `groupwith`  string , `interval`  string , `interval_multiplier`  string , `daysofweek`  string , `run_on_days`  string , `colour`  string , `chart_display_name`  string , `min_length`  string , `max_length`  string , `contact_template_id`  string , `contact_template_booking_status`  string , `allow_before_departure`  string , `billing_set_id`  string , `change_site_status`  string , `allow_online`  string , `allow_cm`  string , `booking_placed_after`  string , `booking_placed_before`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-04/1730783753'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookdefault_tasks"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-04/1730783753
id: 4741954
processed: 1

raw_data:

{
    "active": 27,
    "allow_before_departure": 20,
    "allow_cm": 24,
    "allow_online": 23,
    "billing_set_id": 21,
    "booking_placed_after": 25,
    "booking_placed_before": 26,
    "change_site_status": 22,
    "chart_display_name": 15,
    "colour": 14,
    "contact_template_booking_status": 19,
    "contact_template_id": 18,
    "daysofweek": 12,
    "daytype": 6,
    "description": 5,
    "groupwith": 9,
    "id": 2,
    "ignore_period_from": 7,
    "ignore_period_to": 8,
    "interval": 10,
    "interval_multiplier": 11,
    "max_length": 17,
    "min_length": 16,
    "newbook_region": 0,
    "priority": 4,
    "run_on_days": 13,
    "tenant": 1,
    "type_id": 3
}

schema_attributes:

{
    "active": "string",
    "allow_before_departure": "string",
    "allow_cm": "string",
    "allow_online": "string",
    "billing_set_id": "string",
    "booking_placed_after": "string",
    "booking_placed_before": "string",
    "change_site_status": "string",
    "chart_display_name": "string",
    "colour": "string",
    "contact_template_booking_status": "string",
    "contact_template_id": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "groupwith": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "max_length": "string",
    "min_length": "string",
    "newbook_region": "string",
    "priority": "string",
    "run_on_days": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 2672
schema_scan_id: 6667171
updated: 2024-11-05 01:57:18

Version 4741314

created: 2024-11-05 01:40:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `priority`  string , `description`  string , `daytype`  string , `ignore_period_from`  string , `ignore_period_to`  string , `groupwith`  string , `interval`  string , `interval_multiplier`  string , `daysofweek`  string , `run_on_days`  string , `colour`  string , `chart_display_name`  string , `min_length`  string , `max_length`  string , `contact_template_id`  string , `contact_template_booking_status`  string , `allow_before_departure`  string , `billing_set_id`  string , `change_site_status`  string , `allow_online`  string , `allow_cm`  string , `booking_placed_after`  string , `booking_placed_before`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-04/1730783654'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookdefault_tasks"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-04/1730783654
id: 4741314
processed: 1

raw_data:

{
    "active": 27,
    "allow_before_departure": 20,
    "allow_cm": 24,
    "allow_online": 23,
    "billing_set_id": 21,
    "booking_placed_after": 25,
    "booking_placed_before": 26,
    "change_site_status": 22,
    "chart_display_name": 15,
    "colour": 14,
    "contact_template_booking_status": 19,
    "contact_template_id": 18,
    "daysofweek": 12,
    "daytype": 6,
    "description": 5,
    "groupwith": 9,
    "id": 2,
    "ignore_period_from": 7,
    "ignore_period_to": 8,
    "interval": 10,
    "interval_multiplier": 11,
    "max_length": 17,
    "min_length": 16,
    "newbook_region": 0,
    "priority": 4,
    "run_on_days": 13,
    "tenant": 1,
    "type_id": 3
}

schema_attributes:

{
    "active": "string",
    "allow_before_departure": "string",
    "allow_cm": "string",
    "allow_online": "string",
    "billing_set_id": "string",
    "booking_placed_after": "string",
    "booking_placed_before": "string",
    "change_site_status": "string",
    "chart_display_name": "string",
    "colour": "string",
    "contact_template_booking_status": "string",
    "contact_template_id": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "groupwith": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "max_length": "string",
    "min_length": "string",
    "newbook_region": "string",
    "priority": "string",
    "run_on_days": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 2672
schema_scan_id: 6666531
updated: 2024-11-05 01:40:35

Version 4740983

created: 2024-11-05 01:31:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `priority`  string , `description`  string , `daytype`  string , `ignore_period_from`  string , `ignore_period_to`  string , `groupwith`  string , `interval`  string , `interval_multiplier`  string , `daysofweek`  string , `run_on_days`  string , `colour`  string , `chart_display_name`  string , `min_length`  string , `max_length`  string , `contact_template_id`  string , `contact_template_booking_status`  string , `allow_before_departure`  string , `billing_set_id`  string , `change_site_status`  string , `allow_online`  string , `allow_cm`  string , `booking_placed_after`  string , `booking_placed_before`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-04/1730783509'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookdefault_tasks"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-04/1730783509
id: 4740983
processed: 1

raw_data:

{
    "active": 27,
    "allow_before_departure": 20,
    "allow_cm": 24,
    "allow_online": 23,
    "billing_set_id": 21,
    "booking_placed_after": 25,
    "booking_placed_before": 26,
    "change_site_status": 22,
    "chart_display_name": 15,
    "colour": 14,
    "contact_template_booking_status": 19,
    "contact_template_id": 18,
    "daysofweek": 12,
    "daytype": 6,
    "description": 5,
    "groupwith": 9,
    "id": 2,
    "ignore_period_from": 7,
    "ignore_period_to": 8,
    "interval": 10,
    "interval_multiplier": 11,
    "max_length": 17,
    "min_length": 16,
    "newbook_region": 0,
    "priority": 4,
    "run_on_days": 13,
    "tenant": 1,
    "type_id": 3
}

schema_attributes:

{
    "active": "string",
    "allow_before_departure": "string",
    "allow_cm": "string",
    "allow_online": "string",
    "billing_set_id": "string",
    "booking_placed_after": "string",
    "booking_placed_before": "string",
    "change_site_status": "string",
    "chart_display_name": "string",
    "colour": "string",
    "contact_template_booking_status": "string",
    "contact_template_id": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "groupwith": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "max_length": "string",
    "min_length": "string",
    "newbook_region": "string",
    "priority": "string",
    "run_on_days": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 2672
schema_scan_id: 6666200
updated: 2024-11-05 01:31:52

Version 4740206

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `priority`  string , `description`  string , `daytype`  string , `ignore_period_from`  string , `ignore_period_to`  string , `groupwith`  string , `interval`  string , `interval_multiplier`  string , `daysofweek`  string , `run_on_days`  string , `colour`  string , `chart_display_name`  string , `min_length`  string , `max_length`  string , `contact_template_id`  string , `contact_template_booking_status`  string , `allow_before_departure`  string , `billing_set_id`  string , `change_site_status`  string , `allow_online`  string , `allow_cm`  string , `booking_placed_after`  string , `booking_placed_before`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-04/1730783291'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookdefault_tasks"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-04/1730783291
id: 4740206
processed: 1

raw_data:

{
    "active": 27,
    "allow_before_departure": 20,
    "allow_cm": 24,
    "allow_online": 23,
    "billing_set_id": 21,
    "booking_placed_after": 25,
    "booking_placed_before": 26,
    "change_site_status": 22,
    "chart_display_name": 15,
    "colour": 14,
    "contact_template_booking_status": 19,
    "contact_template_id": 18,
    "daysofweek": 12,
    "daytype": 6,
    "description": 5,
    "groupwith": 9,
    "id": 2,
    "ignore_period_from": 7,
    "ignore_period_to": 8,
    "interval": 10,
    "interval_multiplier": 11,
    "max_length": 17,
    "min_length": 16,
    "newbook_region": 0,
    "priority": 4,
    "run_on_days": 13,
    "tenant": 1,
    "type_id": 3
}

schema_attributes:

{
    "active": "string",
    "allow_before_departure": "string",
    "allow_cm": "string",
    "allow_online": "string",
    "billing_set_id": "string",
    "booking_placed_after": "string",
    "booking_placed_before": "string",
    "change_site_status": "string",
    "chart_display_name": "string",
    "colour": "string",
    "contact_template_booking_status": "string",
    "contact_template_id": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "groupwith": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "max_length": "string",
    "min_length": "string",
    "newbook_region": "string",
    "priority": "string",
    "run_on_days": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 2672
schema_scan_id: 6665423
updated: 2024-11-05 01:11:28

Version 4739565

created: 2024-11-05 00:54:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `priority`  string , `description`  string , `daytype`  string , `ignore_period_from`  string , `ignore_period_to`  string , `groupwith`  string , `interval`  string , `interval_multiplier`  string , `daysofweek`  string , `run_on_days`  string , `colour`  string , `chart_display_name`  string , `min_length`  string , `max_length`  string , `contact_template_id`  string , `contact_template_booking_status`  string , `allow_before_departure`  string , `billing_set_id`  string , `change_site_status`  string , `allow_online`  string , `allow_cm`  string , `booking_placed_after`  string , `booking_placed_before`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-04/1730782893'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookdefault_tasks"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-04/1730782893
id: 4739565
processed: 1

raw_data:

{
    "active": 27,
    "allow_before_departure": 20,
    "allow_cm": 24,
    "allow_online": 23,
    "billing_set_id": 21,
    "booking_placed_after": 25,
    "booking_placed_before": 26,
    "change_site_status": 22,
    "chart_display_name": 15,
    "colour": 14,
    "contact_template_booking_status": 19,
    "contact_template_id": 18,
    "daysofweek": 12,
    "daytype": 6,
    "description": 5,
    "groupwith": 9,
    "id": 2,
    "ignore_period_from": 7,
    "ignore_period_to": 8,
    "interval": 10,
    "interval_multiplier": 11,
    "max_length": 17,
    "min_length": 16,
    "newbook_region": 0,
    "priority": 4,
    "run_on_days": 13,
    "tenant": 1,
    "type_id": 3
}

schema_attributes:

{
    "active": "string",
    "allow_before_departure": "string",
    "allow_cm": "string",
    "allow_online": "string",
    "billing_set_id": "string",
    "booking_placed_after": "string",
    "booking_placed_before": "string",
    "change_site_status": "string",
    "chart_display_name": "string",
    "colour": "string",
    "contact_template_booking_status": "string",
    "contact_template_id": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "groupwith": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "max_length": "string",
    "min_length": "string",
    "newbook_region": "string",
    "priority": "string",
    "run_on_days": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 2672
schema_scan_id: 6664780
updated: 2024-11-05 00:54:12

Version 4738504

created: 2024-11-05 00:26:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `priority`  string , `description`  string , `daytype`  string , `ignore_period_from`  string , `ignore_period_to`  string , `groupwith`  string , `interval`  string , `interval_multiplier`  string , `daysofweek`  string , `run_on_days`  string , `colour`  string , `chart_display_name`  string , `min_length`  string , `max_length`  string , `contact_template_id`  string , `contact_template_booking_status`  string , `allow_before_departure`  string , `billing_set_id`  string , `change_site_status`  string , `allow_online`  string , `allow_cm`  string , `booking_placed_after`  string , `booking_placed_before`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-04/1730782747'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookdefault_tasks"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-04/1730782747
id: 4738504
processed: 1

raw_data:

{
    "active": 27,
    "allow_before_departure": 20,
    "allow_cm": 24,
    "allow_online": 23,
    "billing_set_id": 21,
    "booking_placed_after": 25,
    "booking_placed_before": 26,
    "change_site_status": 22,
    "chart_display_name": 15,
    "colour": 14,
    "contact_template_booking_status": 19,
    "contact_template_id": 18,
    "daysofweek": 12,
    "daytype": 6,
    "description": 5,
    "groupwith": 9,
    "id": 2,
    "ignore_period_from": 7,
    "ignore_period_to": 8,
    "interval": 10,
    "interval_multiplier": 11,
    "max_length": 17,
    "min_length": 16,
    "newbook_region": 0,
    "priority": 4,
    "run_on_days": 13,
    "tenant": 1,
    "type_id": 3
}

schema_attributes:

{
    "active": "string",
    "allow_before_departure": "string",
    "allow_cm": "string",
    "allow_online": "string",
    "billing_set_id": "string",
    "booking_placed_after": "string",
    "booking_placed_before": "string",
    "change_site_status": "string",
    "chart_display_name": "string",
    "colour": "string",
    "contact_template_booking_status": "string",
    "contact_template_id": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "groupwith": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "max_length": "string",
    "min_length": "string",
    "newbook_region": "string",
    "priority": "string",
    "run_on_days": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 2672
schema_scan_id: 6663713
updated: 2024-11-05 00:26:19

Schema Scans: 15

Last at 2024-11-05 22:51:48

Scan 6674606

duration: 0:00:12.267288

exit_message:

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

id: 6674606

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_newbookdefault_tasks/2024-11-05/1730866468",
        "key": "raw/newbookdev_newbookdefault_tasks/2024-11-05/1730866468/default_tasks.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdefault_tasks",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6128584176602768932,
        "service_name": "drive-thru",
        "span_id": 1171235622754433611,
        "trace_id": 3751913071563262339
    }
}

running: False
schema_name_id: 2672
start_time: 2024-11-05 22:51:48
success: True
trace_id: 3751913071563262339

Scan 6674167

duration: 0:00:12.222088

exit_message:

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

id: 6674167

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_newbookdefault_tasks/2024-11-05/1730866381",
        "key": "raw/newbookdev_newbookdefault_tasks/2024-11-05/1730866381/default_tasks.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdefault_tasks",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6858964083617052226,
        "service_name": "drive-thru",
        "span_id": 15574671158619444785,
        "trace_id": 11132814216315657931
    }
}

running: False
schema_name_id: 2672
start_time: 2024-11-05 22:35:54
success: True
trace_id: 11132814216315657931

Scan 6673627

duration: 0:00:14.531545

exit_message:

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

id: 6673627

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_newbookdefault_tasks/2024-11-05/1730866276",
        "key": "raw/newbookdev_newbookdefault_tasks/2024-11-05/1730866276/default_tasks.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdefault_tasks",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9332675204423649591,
        "service_name": "drive-thru",
        "span_id": 17396956916310563056,
        "trace_id": 8548389009447433552
    }
}

running: False
schema_name_id: 2672
start_time: 2024-11-05 22:20:57
success: True
trace_id: 8548389009447433552

Scan 6672016

duration: 0:00:14.806882

exit_message:

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

id: 6672016

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_newbookdefault_tasks/2024-11-04/1730785697",
        "key": "raw/newbookdev_newbookdefault_tasks/2024-11-04/1730785697/default_tasks.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdefault_tasks",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2578898934980712227,
        "service_name": "drive-thru",
        "span_id": 13988908544808591307,
        "trace_id": 7857141381656964531
    }
}

running: False
schema_name_id: 2672
start_time: 2024-11-05 04:23:14
success: True
trace_id: 7857141381656964531

Scan 6671322

duration: 0:00:12.328041

exit_message:

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

id: 6671322

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_newbookdefault_tasks/2024-11-04/1730785111",
        "key": "raw/newbookdev_newbookdefault_tasks/2024-11-04/1730785111/default_tasks.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdefault_tasks",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1697180001804084358,
        "service_name": "drive-thru",
        "span_id": 14620008578256927022,
        "trace_id": 16011698489490862661
    }
}

running: False
schema_name_id: 2672
start_time: 2024-11-05 03:49:17
success: True
trace_id: 16011698489490862661

Scan 6669865

duration: 0:00:14.614163

exit_message:

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

id: 6669865

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_newbookdefault_tasks/2024-11-04/1730784806",
        "key": "raw/newbookdev_newbookdefault_tasks/2024-11-04/1730784806/default_tasks.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdefault_tasks",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7295209163592891428,
        "service_name": "drive-thru",
        "span_id": 15705490694330909944,
        "trace_id": 13865312955286819546
    }
}

running: False
schema_name_id: 2672
start_time: 2024-11-05 03:08:42
success: True
trace_id: 13865312955286819546

Scan 6669365

duration: 0:00:14.513137

exit_message:

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

id: 6669365

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_newbookdefault_tasks/2024-11-04/1730784040",
        "key": "raw/newbookdev_newbookdefault_tasks/2024-11-04/1730784040/default_tasks.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdefault_tasks",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1793477612450106326,
        "service_name": "drive-thru",
        "span_id": 17386422174659484193,
        "trace_id": 7001836727849122827
    }
}

running: False
schema_name_id: 2672
start_time: 2024-11-05 02:55:17
success: True
trace_id: 7001836727849122827

Scan 6669290

duration: 0:00:12.009604

exit_message:

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

id: 6669290

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_newbookdefault_tasks/2024-11-04/1730784203",
        "key": "raw/newbookdev_newbookdefault_tasks/2024-11-04/1730784203/default_tasks.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdefault_tasks",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6658202333931803224,
        "service_name": "drive-thru",
        "span_id": 9871963969240000938,
        "trace_id": 2849859872001259691
    }
}

running: False
schema_name_id: 2672
start_time: 2024-11-05 02:53:18
success: True
trace_id: 2849859872001259691

Scan 6668545

duration: 0:00:14.427312

exit_message:

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

id: 6668545

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_newbookdefault_tasks/2024-11-04/1730783889",
        "key": "raw/newbookdev_newbookdefault_tasks/2024-11-04/1730783889/default_tasks.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdefault_tasks",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14573123168296983302,
        "service_name": "drive-thru",
        "span_id": 2761783640228965629,
        "trace_id": 14564875118672812166
    }
}

running: False
schema_name_id: 2672
start_time: 2024-11-05 02:33:40
success: True
trace_id: 14564875118672812166

Scan 6667171

duration: 0:00:12.107414

exit_message:

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

id: 6667171

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_newbookdefault_tasks/2024-11-04/1730783753",
        "key": "raw/newbookdev_newbookdefault_tasks/2024-11-04/1730783753/default_tasks.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdefault_tasks",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18262526206210151485,
        "service_name": "drive-thru",
        "span_id": 18033194779779164358,
        "trace_id": 14817208645441528591
    }
}

running: False
schema_name_id: 2672
start_time: 2024-11-05 01:57:06
success: True
trace_id: 14817208645441528591

Scan 6666531

duration: 0:00:11.778776

exit_message:

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

id: 6666531

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_newbookdefault_tasks/2024-11-04/1730783654",
        "key": "raw/newbookdev_newbookdefault_tasks/2024-11-04/1730783654/default_tasks.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdefault_tasks",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13711246171354094459,
        "service_name": "drive-thru",
        "span_id": 11158688665434260873,
        "trace_id": 18312763924480985311
    }
}

running: False
schema_name_id: 2672
start_time: 2024-11-05 01:40:24
success: True
trace_id: 18312763924480985311

Scan 6666200

duration: 0:00:11.908858

exit_message:

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

id: 6666200

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_newbookdefault_tasks/2024-11-04/1730783509",
        "key": "raw/newbookdev_newbookdefault_tasks/2024-11-04/1730783509/default_tasks.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdefault_tasks",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3212915483612890021,
        "service_name": "drive-thru",
        "span_id": 9092144622344319617,
        "trace_id": 1369569465056128253
    }
}

running: False
schema_name_id: 2672
start_time: 2024-11-05 01:31:40
success: True
trace_id: 1369569465056128253

Scan 6665423

duration: 0:00:14.583695

exit_message:

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

id: 6665423

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_newbookdefault_tasks/2024-11-04/1730783291",
        "key": "raw/newbookdev_newbookdefault_tasks/2024-11-04/1730783291/default_tasks.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdefault_tasks",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11393901196745237051,
        "service_name": "drive-thru",
        "span_id": 9130445009874570823,
        "trace_id": 15547022538894168478
    }
}

running: False
schema_name_id: 2672
start_time: 2024-11-05 01:11:13
success: True
trace_id: 15547022538894168478

Scan 6664780

duration: 0:00:12.164450

exit_message:

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

id: 6664780

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_newbookdefault_tasks/2024-11-04/1730782893",
        "key": "raw/newbookdev_newbookdefault_tasks/2024-11-04/1730782893/default_tasks.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdefault_tasks",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7890151216756998985,
        "service_name": "drive-thru",
        "span_id": 17997454982058504160,
        "trace_id": 15215906236810175648
    }
}

running: False
schema_name_id: 2672
start_time: 2024-11-05 00:54:00
success: True
trace_id: 15215906236810175648

Scan 6663713

duration: 0:00:12.015300

exit_message:

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

id: 6663713

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_newbookdefault_tasks/2024-11-04/1730782747",
        "key": "raw/newbookdev_newbookdefault_tasks/2024-11-04/1730782747/default_tasks.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdefault_tasks",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8598464890616844737,
        "service_name": "drive-thru",
        "span_id": 6731544852013347929,
        "trace_id": 3467143102735303917
    }
}

running: False
schema_name_id: 2672
start_time: 2024-11-05 00:26:07
success: True
trace_id: 3467143102735303917

Partitions:

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

Schema:

attributes:

{
    "active": "string",
    "allow_before_departure": "string",
    "allow_cm": "string",
    "allow_online": "string",
    "billing_set_id": "string",
    "booking_placed_after": "string",
    "booking_placed_before": "string",
    "change_site_status": "string",
    "chart_display_name": "string",
    "colour": "string",
    "contact_template_booking_status": "string",
    "contact_template_id": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "groupwith": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "max_length": "string",
    "min_length": "string",
    "newbook_region": "string",
    "priority": "string",
    "run_on_days": "string",
    "tenant": "string",
    "type_id": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `priority`  string , `description`  string , `daytype`  string , `ignore_period_from`  string , `ignore_period_to`  string , `groupwith`  string , `interval`  string , `interval_multiplier`  string , `daysofweek`  string , `run_on_days`  string , `colour`  string , `chart_display_name`  string , `min_length`  string , `max_length`  string , `contact_template_id`  string , `contact_template_booking_status`  string , `allow_before_departure`  string , `billing_set_id`  string , `change_site_status`  string , `allow_online`  string , `allow_cm`  string , `booking_placed_after`  string , `booking_placed_before`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-05/1730866468'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookdefault_tasks"
}

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:55:56",
        "disabled": false,
        "format": "raw",
        "id": 2672,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookdefault_tasks"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "active": "string",
            "allow_before_departure": "string",
            "allow_cm": "string",
            "allow_online": "string",
            "billing_set_id": "string",
            "booking_placed_after": "string",
            "booking_placed_before": "string",
            "change_site_status": "string",
            "chart_display_name": "string",
            "colour": "string",
            "contact_template_booking_status": "string",
            "contact_template_id": "string",
            "daysofweek": "string",
            "daytype": "string",
            "description": "string",
            "groupwith": "string",
            "id": "string",
            "ignore_period_from": "string",
            "ignore_period_to": "string",
            "interval": "string",
            "interval_multiplier": "string",
            "max_length": "string",
            "min_length": "string",
            "newbook_region": "string",
            "priority": "string",
            "run_on_days": "string",
            "tenant": "string",
            "type_id": "string"
        },
        "created": "2024-11-05 22:51:50",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `priority`  string , `description`  string , `daytype`  string , `ignore_period_from`  string , `ignore_period_to`  string , `groupwith`  string , `interval`  string , `interval_multiplier`  string , `daysofweek`  string , `run_on_days`  string , `colour`  string , `chart_display_name`  string , `min_length`  string , `max_length`  string , `contact_template_id`  string , `contact_template_booking_status`  string , `allow_before_departure`  string , `billing_set_id`  string , `change_site_status`  string , `allow_online`  string , `allow_cm`  string , `booking_placed_after`  string , `booking_placed_before`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdefault_tasks/2024-11-05/1730866468'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookdefault_tasks`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookdefault_tasks"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}