Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookfacilities_categories

created: 2024-10-08 17:58:15
disabled: False
format: raw
id: 2703
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748737

created: 2024-11-05 22:58:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `max_combined`  string , `display_order`  string , `hireable`  string , `housekeeping`  string , `restrict_start_time`  string , `restrict_end_time`  string , `restrict_hire_interval`  string , `restrict_hire_interval_multiplier`  string , `online_hire_interval`  string , `online_hire_interval_multiplier`  string , `online_hire_entire_duration`  string , `online_group_description`  string , `online_hireable`  string , `default_inventory_item_id`  string , `appointments`  string , `system_template_terms_and_conditions`  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_newbookfacilities_categories/2024-11-05/1730866494'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_categories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_categories/2024-11-05/1730866494
id: 4748737
processed: 1

raw_data:

{
    "active": 24,
    "appointments": 22,
    "default_inventory_item_id": 21,
    "display_order": 9,
    "hireable": 10,
    "housekeeping": 11,
    "id": 2,
    "max_adults": 4,
    "max_animals": 7,
    "max_children": 5,
    "max_combined": 8,
    "max_infants": 6,
    "name": 3,
    "newbook_region": 0,
    "online_group_description": 19,
    "online_hire_entire_duration": 18,
    "online_hire_interval": 16,
    "online_hire_interval_multiplier": 17,
    "online_hireable": 20,
    "restrict_end_time": 13,
    "restrict_hire_interval": 14,
    "restrict_hire_interval_multiplier": 15,
    "restrict_start_time": 12,
    "system_template_terms_and_conditions": 23,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "appointments": "string",
    "default_inventory_item_id": "string",
    "display_order": "string",
    "hireable": "string",
    "housekeeping": "string",
    "id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "name": "string",
    "newbook_region": "string",
    "online_group_description": "string",
    "online_hire_entire_duration": "string",
    "online_hire_interval": "string",
    "online_hire_interval_multiplier": "string",
    "online_hireable": "string",
    "restrict_end_time": "string",
    "restrict_hire_interval": "string",
    "restrict_hire_interval_multiplier": "string",
    "restrict_start_time": "string",
    "system_template_terms_and_conditions": "string",
    "tenant": "string"
}

schema_name_id: 2703
schema_scan_id: 6674769
updated: 2024-11-05 22:58:54

Version 4748196

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `max_combined`  string , `display_order`  string , `hireable`  string , `housekeeping`  string , `restrict_start_time`  string , `restrict_end_time`  string , `restrict_hire_interval`  string , `restrict_hire_interval_multiplier`  string , `online_hire_interval`  string , `online_hire_interval_multiplier`  string , `online_hire_entire_duration`  string , `online_group_description`  string , `online_hireable`  string , `default_inventory_item_id`  string , `appointments`  string , `system_template_terms_and_conditions`  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_newbookfacilities_categories/2024-11-05/1730866410'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_categories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_categories/2024-11-05/1730866410
id: 4748196
processed: 1

raw_data:

{
    "active": 24,
    "appointments": 22,
    "default_inventory_item_id": 21,
    "display_order": 9,
    "hireable": 10,
    "housekeeping": 11,
    "id": 2,
    "max_adults": 4,
    "max_animals": 7,
    "max_children": 5,
    "max_combined": 8,
    "max_infants": 6,
    "name": 3,
    "newbook_region": 0,
    "online_group_description": 19,
    "online_hire_entire_duration": 18,
    "online_hire_interval": 16,
    "online_hire_interval_multiplier": 17,
    "online_hireable": 20,
    "restrict_end_time": 13,
    "restrict_hire_interval": 14,
    "restrict_hire_interval_multiplier": 15,
    "restrict_start_time": 12,
    "system_template_terms_and_conditions": 23,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "appointments": "string",
    "default_inventory_item_id": "string",
    "display_order": "string",
    "hireable": "string",
    "housekeeping": "string",
    "id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "name": "string",
    "newbook_region": "string",
    "online_group_description": "string",
    "online_hire_entire_duration": "string",
    "online_hire_interval": "string",
    "online_hire_interval_multiplier": "string",
    "online_hireable": "string",
    "restrict_end_time": "string",
    "restrict_hire_interval": "string",
    "restrict_hire_interval_multiplier": "string",
    "restrict_start_time": "string",
    "system_template_terms_and_conditions": "string",
    "tenant": "string"
}

schema_name_id: 2703
schema_scan_id: 6674228
updated: 2024-11-05 22:37:53

Version 4747702

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `max_combined`  string , `display_order`  string , `hireable`  string , `housekeeping`  string , `restrict_start_time`  string , `restrict_end_time`  string , `restrict_hire_interval`  string , `restrict_hire_interval_multiplier`  string , `online_hire_interval`  string , `online_hire_interval_multiplier`  string , `online_hire_entire_duration`  string , `online_group_description`  string , `online_hireable`  string , `default_inventory_item_id`  string , `appointments`  string , `system_template_terms_and_conditions`  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_newbookfacilities_categories/2024-11-05/1730866296'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_categories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_categories/2024-11-05/1730866296
id: 4747702
processed: 1

raw_data:

{
    "active": 24,
    "appointments": 22,
    "default_inventory_item_id": 21,
    "display_order": 9,
    "hireable": 10,
    "housekeeping": 11,
    "id": 2,
    "max_adults": 4,
    "max_animals": 7,
    "max_children": 5,
    "max_combined": 8,
    "max_infants": 6,
    "name": 3,
    "newbook_region": 0,
    "online_group_description": 19,
    "online_hire_entire_duration": 18,
    "online_hire_interval": 16,
    "online_hire_interval_multiplier": 17,
    "online_hireable": 20,
    "restrict_end_time": 13,
    "restrict_hire_interval": 14,
    "restrict_hire_interval_multiplier": 15,
    "restrict_start_time": 12,
    "system_template_terms_and_conditions": 23,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "appointments": "string",
    "default_inventory_item_id": "string",
    "display_order": "string",
    "hireable": "string",
    "housekeeping": "string",
    "id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "name": "string",
    "newbook_region": "string",
    "online_group_description": "string",
    "online_hire_entire_duration": "string",
    "online_hire_interval": "string",
    "online_hire_interval_multiplier": "string",
    "online_hireable": "string",
    "restrict_end_time": "string",
    "restrict_hire_interval": "string",
    "restrict_hire_interval_multiplier": "string",
    "restrict_start_time": "string",
    "system_template_terms_and_conditions": "string",
    "tenant": "string"
}

schema_name_id: 2703
schema_scan_id: 6673734
updated: 2024-11-05 22:24:00

Version 4747001

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `max_combined`  string , `display_order`  string , `hireable`  string , `housekeeping`  string , `restrict_start_time`  string , `restrict_end_time`  string , `restrict_hire_interval`  string , `restrict_hire_interval_multiplier`  string , `online_hire_interval`  string , `online_hire_interval_multiplier`  string , `online_hire_entire_duration`  string , `online_group_description`  string , `online_hireable`  string , `default_inventory_item_id`  string , `appointments`  string , `system_template_terms_and_conditions`  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_newbookfacilities_categories/2024-11-04/1730785712'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_categories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_categories/2024-11-04/1730785712
id: 4747001
processed: 1

raw_data:

{
    "active": 24,
    "appointments": 22,
    "default_inventory_item_id": 21,
    "display_order": 9,
    "hireable": 10,
    "housekeeping": 11,
    "id": 2,
    "max_adults": 4,
    "max_animals": 7,
    "max_children": 5,
    "max_combined": 8,
    "max_infants": 6,
    "name": 3,
    "newbook_region": 0,
    "online_group_description": 19,
    "online_hire_entire_duration": 18,
    "online_hire_interval": 16,
    "online_hire_interval_multiplier": 17,
    "online_hireable": 20,
    "restrict_end_time": 13,
    "restrict_hire_interval": 14,
    "restrict_hire_interval_multiplier": 15,
    "restrict_start_time": 12,
    "system_template_terms_and_conditions": 23,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "appointments": "string",
    "default_inventory_item_id": "string",
    "display_order": "string",
    "hireable": "string",
    "housekeeping": "string",
    "id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "name": "string",
    "newbook_region": "string",
    "online_group_description": "string",
    "online_hire_entire_duration": "string",
    "online_hire_interval": "string",
    "online_hire_interval_multiplier": "string",
    "online_hireable": "string",
    "restrict_end_time": "string",
    "restrict_hire_interval": "string",
    "restrict_hire_interval_multiplier": "string",
    "restrict_start_time": "string",
    "system_template_terms_and_conditions": "string",
    "tenant": "string"
}

schema_name_id: 2703
schema_scan_id: 6672232
updated: 2024-11-05 04:39:58

Version 4745610

created: 2024-11-05 03:34:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `max_combined`  string , `display_order`  string , `hireable`  string , `housekeeping`  string , `restrict_start_time`  string , `restrict_end_time`  string , `restrict_hire_interval`  string , `restrict_hire_interval_multiplier`  string , `online_hire_interval`  string , `online_hire_interval_multiplier`  string , `online_hire_entire_duration`  string , `online_group_description`  string , `online_hireable`  string , `default_inventory_item_id`  string , `appointments`  string , `system_template_terms_and_conditions`  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_newbookfacilities_categories/2024-11-04/1730784814'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_categories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_categories/2024-11-04/1730784814
id: 4745610
processed: 1

raw_data:

{
    "active": 24,
    "appointments": 22,
    "default_inventory_item_id": 21,
    "display_order": 9,
    "hireable": 10,
    "housekeeping": 11,
    "id": 2,
    "max_adults": 4,
    "max_animals": 7,
    "max_children": 5,
    "max_combined": 8,
    "max_infants": 6,
    "name": 3,
    "newbook_region": 0,
    "online_group_description": 19,
    "online_hire_entire_duration": 18,
    "online_hire_interval": 16,
    "online_hire_interval_multiplier": 17,
    "online_hireable": 20,
    "restrict_end_time": 13,
    "restrict_hire_interval": 14,
    "restrict_hire_interval_multiplier": 15,
    "restrict_start_time": 12,
    "system_template_terms_and_conditions": 23,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "appointments": "string",
    "default_inventory_item_id": "string",
    "display_order": "string",
    "hireable": "string",
    "housekeeping": "string",
    "id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "name": "string",
    "newbook_region": "string",
    "online_group_description": "string",
    "online_hire_entire_duration": "string",
    "online_hire_interval": "string",
    "online_hire_interval_multiplier": "string",
    "online_hireable": "string",
    "restrict_end_time": "string",
    "restrict_hire_interval": "string",
    "restrict_hire_interval_multiplier": "string",
    "restrict_start_time": "string",
    "system_template_terms_and_conditions": "string",
    "tenant": "string"
}

schema_name_id: 2703
schema_scan_id: 6670827
updated: 2024-11-05 03:34:11

Version 4745414

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `max_combined`  string , `display_order`  string , `hireable`  string , `housekeeping`  string , `restrict_start_time`  string , `restrict_end_time`  string , `restrict_hire_interval`  string , `restrict_hire_interval_multiplier`  string , `online_hire_interval`  string , `online_hire_interval_multiplier`  string , `online_hire_entire_duration`  string , `online_group_description`  string , `online_hireable`  string , `default_inventory_item_id`  string , `appointments`  string , `system_template_terms_and_conditions`  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_newbookfacilities_categories/2024-11-04/1730785119'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_categories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_categories/2024-11-04/1730785119
id: 4745414
processed: 1

raw_data:

{
    "active": 24,
    "appointments": 22,
    "default_inventory_item_id": 21,
    "display_order": 9,
    "hireable": 10,
    "housekeeping": 11,
    "id": 2,
    "max_adults": 4,
    "max_animals": 7,
    "max_children": 5,
    "max_combined": 8,
    "max_infants": 6,
    "name": 3,
    "newbook_region": 0,
    "online_group_description": 19,
    "online_hire_entire_duration": 18,
    "online_hire_interval": 16,
    "online_hire_interval_multiplier": 17,
    "online_hireable": 20,
    "restrict_end_time": 13,
    "restrict_hire_interval": 14,
    "restrict_hire_interval_multiplier": 15,
    "restrict_start_time": 12,
    "system_template_terms_and_conditions": 23,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "appointments": "string",
    "default_inventory_item_id": "string",
    "display_order": "string",
    "hireable": "string",
    "housekeeping": "string",
    "id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "name": "string",
    "newbook_region": "string",
    "online_group_description": "string",
    "online_hire_entire_duration": "string",
    "online_hire_interval": "string",
    "online_hire_interval_multiplier": "string",
    "online_hireable": "string",
    "restrict_end_time": "string",
    "restrict_hire_interval": "string",
    "restrict_hire_interval_multiplier": "string",
    "restrict_start_time": "string",
    "system_template_terms_and_conditions": "string",
    "tenant": "string"
}

schema_name_id: 2703
schema_scan_id: 6670631
updated: 2024-11-05 03:29:01

Version 4744594

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `max_combined`  string , `display_order`  string , `hireable`  string , `housekeeping`  string , `restrict_start_time`  string , `restrict_end_time`  string , `restrict_hire_interval`  string , `restrict_hire_interval_multiplier`  string , `online_hire_interval`  string , `online_hire_interval_multiplier`  string , `online_hire_entire_duration`  string , `online_group_description`  string , `online_hireable`  string , `default_inventory_item_id`  string , `appointments`  string , `system_template_terms_and_conditions`  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_newbookfacilities_categories/2024-11-04/1730784211'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_categories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_categories/2024-11-04/1730784211
id: 4744594
processed: 1

raw_data:

{
    "active": 24,
    "appointments": 22,
    "default_inventory_item_id": 21,
    "display_order": 9,
    "hireable": 10,
    "housekeeping": 11,
    "id": 2,
    "max_adults": 4,
    "max_animals": 7,
    "max_children": 5,
    "max_combined": 8,
    "max_infants": 6,
    "name": 3,
    "newbook_region": 0,
    "online_group_description": 19,
    "online_hire_entire_duration": 18,
    "online_hire_interval": 16,
    "online_hire_interval_multiplier": 17,
    "online_hireable": 20,
    "restrict_end_time": 13,
    "restrict_hire_interval": 14,
    "restrict_hire_interval_multiplier": 15,
    "restrict_start_time": 12,
    "system_template_terms_and_conditions": 23,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "appointments": "string",
    "default_inventory_item_id": "string",
    "display_order": "string",
    "hireable": "string",
    "housekeeping": "string",
    "id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "name": "string",
    "newbook_region": "string",
    "online_group_description": "string",
    "online_hire_entire_duration": "string",
    "online_hire_interval": "string",
    "online_hire_interval_multiplier": "string",
    "online_hireable": "string",
    "restrict_end_time": "string",
    "restrict_hire_interval": "string",
    "restrict_hire_interval_multiplier": "string",
    "restrict_start_time": "string",
    "system_template_terms_and_conditions": "string",
    "tenant": "string"
}

schema_name_id: 2703
schema_scan_id: 6669811
updated: 2024-11-05 03:07:31

Version 4743960

created: 2024-11-05 02:50:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `max_combined`  string , `display_order`  string , `hireable`  string , `housekeeping`  string , `restrict_start_time`  string , `restrict_end_time`  string , `restrict_hire_interval`  string , `restrict_hire_interval_multiplier`  string , `online_hire_interval`  string , `online_hire_interval_multiplier`  string , `online_hire_entire_duration`  string , `online_group_description`  string , `online_hireable`  string , `default_inventory_item_id`  string , `appointments`  string , `system_template_terms_and_conditions`  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_newbookfacilities_categories/2024-11-04/1730784048'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_categories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_categories/2024-11-04/1730784048
id: 4743960
processed: 1

raw_data:

{
    "active": 24,
    "appointments": 22,
    "default_inventory_item_id": 21,
    "display_order": 9,
    "hireable": 10,
    "housekeeping": 11,
    "id": 2,
    "max_adults": 4,
    "max_animals": 7,
    "max_children": 5,
    "max_combined": 8,
    "max_infants": 6,
    "name": 3,
    "newbook_region": 0,
    "online_group_description": 19,
    "online_hire_entire_duration": 18,
    "online_hire_interval": 16,
    "online_hire_interval_multiplier": 17,
    "online_hireable": 20,
    "restrict_end_time": 13,
    "restrict_hire_interval": 14,
    "restrict_hire_interval_multiplier": 15,
    "restrict_start_time": 12,
    "system_template_terms_and_conditions": 23,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "appointments": "string",
    "default_inventory_item_id": "string",
    "display_order": "string",
    "hireable": "string",
    "housekeeping": "string",
    "id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "name": "string",
    "newbook_region": "string",
    "online_group_description": "string",
    "online_hire_entire_duration": "string",
    "online_hire_interval": "string",
    "online_hire_interval_multiplier": "string",
    "online_hireable": "string",
    "restrict_end_time": "string",
    "restrict_hire_interval": "string",
    "restrict_hire_interval_multiplier": "string",
    "restrict_start_time": "string",
    "system_template_terms_and_conditions": "string",
    "tenant": "string"
}

schema_name_id: 2703
schema_scan_id: 6669177
updated: 2024-11-05 02:50:34

Version 4742615

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `max_combined`  string , `display_order`  string , `hireable`  string , `housekeeping`  string , `restrict_start_time`  string , `restrict_end_time`  string , `restrict_hire_interval`  string , `restrict_hire_interval_multiplier`  string , `online_hire_interval`  string , `online_hire_interval_multiplier`  string , `online_hire_entire_duration`  string , `online_group_description`  string , `online_hireable`  string , `default_inventory_item_id`  string , `appointments`  string , `system_template_terms_and_conditions`  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_newbookfacilities_categories/2024-11-04/1730783762'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_categories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_categories/2024-11-04/1730783762
id: 4742615
processed: 1

raw_data:

{
    "active": 24,
    "appointments": 22,
    "default_inventory_item_id": 21,
    "display_order": 9,
    "hireable": 10,
    "housekeeping": 11,
    "id": 2,
    "max_adults": 4,
    "max_animals": 7,
    "max_children": 5,
    "max_combined": 8,
    "max_infants": 6,
    "name": 3,
    "newbook_region": 0,
    "online_group_description": 19,
    "online_hire_entire_duration": 18,
    "online_hire_interval": 16,
    "online_hire_interval_multiplier": 17,
    "online_hireable": 20,
    "restrict_end_time": 13,
    "restrict_hire_interval": 14,
    "restrict_hire_interval_multiplier": 15,
    "restrict_start_time": 12,
    "system_template_terms_and_conditions": 23,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "appointments": "string",
    "default_inventory_item_id": "string",
    "display_order": "string",
    "hireable": "string",
    "housekeeping": "string",
    "id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "name": "string",
    "newbook_region": "string",
    "online_group_description": "string",
    "online_hire_entire_duration": "string",
    "online_hire_interval": "string",
    "online_hire_interval_multiplier": "string",
    "online_hireable": "string",
    "restrict_end_time": "string",
    "restrict_hire_interval": "string",
    "restrict_hire_interval_multiplier": "string",
    "restrict_start_time": "string",
    "system_template_terms_and_conditions": "string",
    "tenant": "string"
}

schema_name_id: 2703
schema_scan_id: 6667832
updated: 2024-11-05 02:15:06

Version 4742442

created: 2024-11-05 02:10:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `max_combined`  string , `display_order`  string , `hireable`  string , `housekeeping`  string , `restrict_start_time`  string , `restrict_end_time`  string , `restrict_hire_interval`  string , `restrict_hire_interval_multiplier`  string , `online_hire_interval`  string , `online_hire_interval_multiplier`  string , `online_hire_entire_duration`  string , `online_group_description`  string , `online_hireable`  string , `default_inventory_item_id`  string , `appointments`  string , `system_template_terms_and_conditions`  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_newbookfacilities_categories/2024-11-04/1730783842'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_categories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_categories/2024-11-04/1730783842
id: 4742442
processed: 1

raw_data:

{
    "active": 24,
    "appointments": 22,
    "default_inventory_item_id": 21,
    "display_order": 9,
    "hireable": 10,
    "housekeeping": 11,
    "id": 2,
    "max_adults": 4,
    "max_animals": 7,
    "max_children": 5,
    "max_combined": 8,
    "max_infants": 6,
    "name": 3,
    "newbook_region": 0,
    "online_group_description": 19,
    "online_hire_entire_duration": 18,
    "online_hire_interval": 16,
    "online_hire_interval_multiplier": 17,
    "online_hireable": 20,
    "restrict_end_time": 13,
    "restrict_hire_interval": 14,
    "restrict_hire_interval_multiplier": 15,
    "restrict_start_time": 12,
    "system_template_terms_and_conditions": 23,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "appointments": "string",
    "default_inventory_item_id": "string",
    "display_order": "string",
    "hireable": "string",
    "housekeeping": "string",
    "id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "name": "string",
    "newbook_region": "string",
    "online_group_description": "string",
    "online_hire_entire_duration": "string",
    "online_hire_interval": "string",
    "online_hire_interval_multiplier": "string",
    "online_hireable": "string",
    "restrict_end_time": "string",
    "restrict_hire_interval": "string",
    "restrict_hire_interval_multiplier": "string",
    "restrict_start_time": "string",
    "system_template_terms_and_conditions": "string",
    "tenant": "string"
}

schema_name_id: 2703
schema_scan_id: 6667657
updated: 2024-11-05 02:10:31

Version 4741772

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `max_combined`  string , `display_order`  string , `hireable`  string , `housekeeping`  string , `restrict_start_time`  string , `restrict_end_time`  string , `restrict_hire_interval`  string , `restrict_hire_interval_multiplier`  string , `online_hire_interval`  string , `online_hire_interval_multiplier`  string , `online_hire_entire_duration`  string , `online_group_description`  string , `online_hireable`  string , `default_inventory_item_id`  string , `appointments`  string , `system_template_terms_and_conditions`  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_newbookfacilities_categories/2024-11-04/1730783660'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_categories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_categories/2024-11-04/1730783660
id: 4741772
processed: 1

raw_data:

{
    "active": 24,
    "appointments": 22,
    "default_inventory_item_id": 21,
    "display_order": 9,
    "hireable": 10,
    "housekeeping": 11,
    "id": 2,
    "max_adults": 4,
    "max_animals": 7,
    "max_children": 5,
    "max_combined": 8,
    "max_infants": 6,
    "name": 3,
    "newbook_region": 0,
    "online_group_description": 19,
    "online_hire_entire_duration": 18,
    "online_hire_interval": 16,
    "online_hire_interval_multiplier": 17,
    "online_hireable": 20,
    "restrict_end_time": 13,
    "restrict_hire_interval": 14,
    "restrict_hire_interval_multiplier": 15,
    "restrict_start_time": 12,
    "system_template_terms_and_conditions": 23,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "appointments": "string",
    "default_inventory_item_id": "string",
    "display_order": "string",
    "hireable": "string",
    "housekeeping": "string",
    "id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "name": "string",
    "newbook_region": "string",
    "online_group_description": "string",
    "online_hire_entire_duration": "string",
    "online_hire_interval": "string",
    "online_hire_interval_multiplier": "string",
    "online_hireable": "string",
    "restrict_end_time": "string",
    "restrict_hire_interval": "string",
    "restrict_hire_interval_multiplier": "string",
    "restrict_start_time": "string",
    "system_template_terms_and_conditions": "string",
    "tenant": "string"
}

schema_name_id: 2703
schema_scan_id: 6666988
updated: 2024-11-05 01:52:36

Version 4740965

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `max_combined`  string , `display_order`  string , `hireable`  string , `housekeeping`  string , `restrict_start_time`  string , `restrict_end_time`  string , `restrict_hire_interval`  string , `restrict_hire_interval_multiplier`  string , `online_hire_interval`  string , `online_hire_interval_multiplier`  string , `online_hire_entire_duration`  string , `online_group_description`  string , `online_hireable`  string , `default_inventory_item_id`  string , `appointments`  string , `system_template_terms_and_conditions`  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_newbookfacilities_categories/2024-11-04/1730783517'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_categories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_categories/2024-11-04/1730783517
id: 4740965
processed: 1

raw_data:

{
    "active": 24,
    "appointments": 22,
    "default_inventory_item_id": 21,
    "display_order": 9,
    "hireable": 10,
    "housekeeping": 11,
    "id": 2,
    "max_adults": 4,
    "max_animals": 7,
    "max_children": 5,
    "max_combined": 8,
    "max_infants": 6,
    "name": 3,
    "newbook_region": 0,
    "online_group_description": 19,
    "online_hire_entire_duration": 18,
    "online_hire_interval": 16,
    "online_hire_interval_multiplier": 17,
    "online_hireable": 20,
    "restrict_end_time": 13,
    "restrict_hire_interval": 14,
    "restrict_hire_interval_multiplier": 15,
    "restrict_start_time": 12,
    "system_template_terms_and_conditions": 23,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "appointments": "string",
    "default_inventory_item_id": "string",
    "display_order": "string",
    "hireable": "string",
    "housekeeping": "string",
    "id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "name": "string",
    "newbook_region": "string",
    "online_group_description": "string",
    "online_hire_entire_duration": "string",
    "online_hire_interval": "string",
    "online_hire_interval_multiplier": "string",
    "online_hireable": "string",
    "restrict_end_time": "string",
    "restrict_hire_interval": "string",
    "restrict_hire_interval_multiplier": "string",
    "restrict_start_time": "string",
    "system_template_terms_and_conditions": "string",
    "tenant": "string"
}

schema_name_id: 2703
schema_scan_id: 6666182
updated: 2024-11-05 01:31:24

Version 4740225

created: 2024-11-05 01:11:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `max_combined`  string , `display_order`  string , `hireable`  string , `housekeeping`  string , `restrict_start_time`  string , `restrict_end_time`  string , `restrict_hire_interval`  string , `restrict_hire_interval_multiplier`  string , `online_hire_interval`  string , `online_hire_interval_multiplier`  string , `online_hire_entire_duration`  string , `online_group_description`  string , `online_hireable`  string , `default_inventory_item_id`  string , `appointments`  string , `system_template_terms_and_conditions`  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_newbookfacilities_categories/2024-11-04/1730783300'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_categories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_categories/2024-11-04/1730783300
id: 4740225
processed: 1

raw_data:

{
    "active": 24,
    "appointments": 22,
    "default_inventory_item_id": 21,
    "display_order": 9,
    "hireable": 10,
    "housekeeping": 11,
    "id": 2,
    "max_adults": 4,
    "max_animals": 7,
    "max_children": 5,
    "max_combined": 8,
    "max_infants": 6,
    "name": 3,
    "newbook_region": 0,
    "online_group_description": 19,
    "online_hire_entire_duration": 18,
    "online_hire_interval": 16,
    "online_hire_interval_multiplier": 17,
    "online_hireable": 20,
    "restrict_end_time": 13,
    "restrict_hire_interval": 14,
    "restrict_hire_interval_multiplier": 15,
    "restrict_start_time": 12,
    "system_template_terms_and_conditions": 23,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "appointments": "string",
    "default_inventory_item_id": "string",
    "display_order": "string",
    "hireable": "string",
    "housekeeping": "string",
    "id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "name": "string",
    "newbook_region": "string",
    "online_group_description": "string",
    "online_hire_entire_duration": "string",
    "online_hire_interval": "string",
    "online_hire_interval_multiplier": "string",
    "online_hireable": "string",
    "restrict_end_time": "string",
    "restrict_hire_interval": "string",
    "restrict_hire_interval_multiplier": "string",
    "restrict_start_time": "string",
    "system_template_terms_and_conditions": "string",
    "tenant": "string"
}

schema_name_id: 2703
schema_scan_id: 6665441
updated: 2024-11-05 01:11:53

Version 4739308

created: 2024-11-05 00:47:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `max_combined`  string , `display_order`  string , `hireable`  string , `housekeeping`  string , `restrict_start_time`  string , `restrict_end_time`  string , `restrict_hire_interval`  string , `restrict_hire_interval_multiplier`  string , `online_hire_interval`  string , `online_hire_interval_multiplier`  string , `online_hire_entire_duration`  string , `online_group_description`  string , `online_hireable`  string , `default_inventory_item_id`  string , `appointments`  string , `system_template_terms_and_conditions`  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_newbookfacilities_categories/2024-11-04/1730782901'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_categories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_categories/2024-11-04/1730782901
id: 4739308
processed: 1

raw_data:

{
    "active": 24,
    "appointments": 22,
    "default_inventory_item_id": 21,
    "display_order": 9,
    "hireable": 10,
    "housekeeping": 11,
    "id": 2,
    "max_adults": 4,
    "max_animals": 7,
    "max_children": 5,
    "max_combined": 8,
    "max_infants": 6,
    "name": 3,
    "newbook_region": 0,
    "online_group_description": 19,
    "online_hire_entire_duration": 18,
    "online_hire_interval": 16,
    "online_hire_interval_multiplier": 17,
    "online_hireable": 20,
    "restrict_end_time": 13,
    "restrict_hire_interval": 14,
    "restrict_hire_interval_multiplier": 15,
    "restrict_start_time": 12,
    "system_template_terms_and_conditions": 23,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "appointments": "string",
    "default_inventory_item_id": "string",
    "display_order": "string",
    "hireable": "string",
    "housekeeping": "string",
    "id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "name": "string",
    "newbook_region": "string",
    "online_group_description": "string",
    "online_hire_entire_duration": "string",
    "online_hire_interval": "string",
    "online_hire_interval_multiplier": "string",
    "online_hireable": "string",
    "restrict_end_time": "string",
    "restrict_hire_interval": "string",
    "restrict_hire_interval_multiplier": "string",
    "restrict_start_time": "string",
    "system_template_terms_and_conditions": "string",
    "tenant": "string"
}

schema_name_id: 2703
schema_scan_id: 6664523
updated: 2024-11-05 00:47:31

Version 4738815

created: 2024-11-05 00:34:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `max_combined`  string , `display_order`  string , `hireable`  string , `housekeeping`  string , `restrict_start_time`  string , `restrict_end_time`  string , `restrict_hire_interval`  string , `restrict_hire_interval_multiplier`  string , `online_hire_interval`  string , `online_hire_interval_multiplier`  string , `online_hire_entire_duration`  string , `online_group_description`  string , `online_hireable`  string , `default_inventory_item_id`  string , `appointments`  string , `system_template_terms_and_conditions`  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_newbookfacilities_categories/2024-11-04/1730782801'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_categories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_categories/2024-11-04/1730782801
id: 4738815
processed: 1

raw_data:

{
    "active": 24,
    "appointments": 22,
    "default_inventory_item_id": 21,
    "display_order": 9,
    "hireable": 10,
    "housekeeping": 11,
    "id": 2,
    "max_adults": 4,
    "max_animals": 7,
    "max_children": 5,
    "max_combined": 8,
    "max_infants": 6,
    "name": 3,
    "newbook_region": 0,
    "online_group_description": 19,
    "online_hire_entire_duration": 18,
    "online_hire_interval": 16,
    "online_hire_interval_multiplier": 17,
    "online_hireable": 20,
    "restrict_end_time": 13,
    "restrict_hire_interval": 14,
    "restrict_hire_interval_multiplier": 15,
    "restrict_start_time": 12,
    "system_template_terms_and_conditions": 23,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "appointments": "string",
    "default_inventory_item_id": "string",
    "display_order": "string",
    "hireable": "string",
    "housekeeping": "string",
    "id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "name": "string",
    "newbook_region": "string",
    "online_group_description": "string",
    "online_hire_entire_duration": "string",
    "online_hire_interval": "string",
    "online_hire_interval_multiplier": "string",
    "online_hireable": "string",
    "restrict_end_time": "string",
    "restrict_hire_interval": "string",
    "restrict_hire_interval_multiplier": "string",
    "restrict_start_time": "string",
    "system_template_terms_and_conditions": "string",
    "tenant": "string"
}

schema_name_id: 2703
schema_scan_id: 6664028
updated: 2024-11-05 00:34:31

Schema Scans: 15

Last at 2024-11-05 22:58:39

Scan 6674769

duration: 0:00:14.621057

exit_message:

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

id: 6674769

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_newbookfacilities_categories/2024-11-05/1730866494",
        "key": "raw/newbookdev_newbookfacilities_categories/2024-11-05/1730866494/facilities_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8248987960473391841,
        "service_name": "drive-thru",
        "span_id": 3569828883428612416,
        "trace_id": 4678237261733125075
    }
}

running: False
schema_name_id: 2703
start_time: 2024-11-05 22:58:39
success: True
trace_id: 4678237261733125075

Scan 6674228

duration: 0:00:12.136434

exit_message:

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

id: 6674228

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_newbookfacilities_categories/2024-11-05/1730866410",
        "key": "raw/newbookdev_newbookfacilities_categories/2024-11-05/1730866410/facilities_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4333525627772241479,
        "service_name": "drive-thru",
        "span_id": 14833551069349371238,
        "trace_id": 12722247842759900035
    }
}

running: False
schema_name_id: 2703
start_time: 2024-11-05 22:37:41
success: True
trace_id: 12722247842759900035

Scan 6673734

duration: 0:00:14.544764

exit_message:

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

id: 6673734

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_newbookfacilities_categories/2024-11-05/1730866296",
        "key": "raw/newbookdev_newbookfacilities_categories/2024-11-05/1730866296/facilities_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16586470026351273648,
        "service_name": "drive-thru",
        "span_id": 7939114845283131885,
        "trace_id": 4963364657387041200
    }
}

running: False
schema_name_id: 2703
start_time: 2024-11-05 22:23:45
success: True
trace_id: 4963364657387041200

Scan 6672232

duration: 0:00:12.140788

exit_message:

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

id: 6672232

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_newbookfacilities_categories/2024-11-04/1730785712",
        "key": "raw/newbookdev_newbookfacilities_categories/2024-11-04/1730785712/facilities_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2952025884534130709,
        "service_name": "drive-thru",
        "span_id": 3280582862136461424,
        "trace_id": 14525159467757629089
    }
}

running: False
schema_name_id: 2703
start_time: 2024-11-05 04:39:46
success: True
trace_id: 14525159467757629089

Scan 6670827

duration: 0:00:12.233630

exit_message:

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

id: 6670827

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_newbookfacilities_categories/2024-11-04/1730784814",
        "key": "raw/newbookdev_newbookfacilities_categories/2024-11-04/1730784814/facilities_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9173527589056369409,
        "service_name": "drive-thru",
        "span_id": 18356505254538525671,
        "trace_id": 4907997965372389442
    }
}

running: False
schema_name_id: 2703
start_time: 2024-11-05 03:33:59
success: True
trace_id: 4907997965372389442

Scan 6670631

duration: 0:00:14.473466

exit_message:

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

id: 6670631

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_newbookfacilities_categories/2024-11-04/1730785119",
        "key": "raw/newbookdev_newbookfacilities_categories/2024-11-04/1730785119/facilities_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 343132974438582592,
        "service_name": "drive-thru",
        "span_id": 10676604392668156283,
        "trace_id": 15025154488231291910
    }
}

running: False
schema_name_id: 2703
start_time: 2024-11-05 03:28:46
success: True
trace_id: 15025154488231291910

Scan 6669811

duration: 0:00:14.479897

exit_message:

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

id: 6669811

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_newbookfacilities_categories/2024-11-04/1730784211",
        "key": "raw/newbookdev_newbookfacilities_categories/2024-11-04/1730784211/facilities_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9172658637105283758,
        "service_name": "drive-thru",
        "span_id": 6504673935147764853,
        "trace_id": 14452134828819782757
    }
}

running: False
schema_name_id: 2703
start_time: 2024-11-05 03:07:17
success: True
trace_id: 14452134828819782757

Scan 6669177

duration: 0:00:14.325476

exit_message:

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

id: 6669177

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_newbookfacilities_categories/2024-11-04/1730784048",
        "key": "raw/newbookdev_newbookfacilities_categories/2024-11-04/1730784048/facilities_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9102445205840940281,
        "service_name": "drive-thru",
        "span_id": 7410107701760094217,
        "trace_id": 15206965930196926090
    }
}

running: False
schema_name_id: 2703
start_time: 2024-11-05 02:50:20
success: True
trace_id: 15206965930196926090

Scan 6667832

duration: 0:00:12.094701

exit_message:

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

id: 6667832

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_newbookfacilities_categories/2024-11-04/1730783762",
        "key": "raw/newbookdev_newbookfacilities_categories/2024-11-04/1730783762/facilities_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1979032936788235321,
        "service_name": "drive-thru",
        "span_id": 13200077228196768726,
        "trace_id": 7547151232149409605
    }
}

running: False
schema_name_id: 2703
start_time: 2024-11-05 02:14:54
success: True
trace_id: 7547151232149409605

Scan 6667657

duration: 0:00:12.107522

exit_message:

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

id: 6667657

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_newbookfacilities_categories/2024-11-04/1730783842",
        "key": "raw/newbookdev_newbookfacilities_categories/2024-11-04/1730783842/facilities_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 651216114472418987,
        "service_name": "drive-thru",
        "span_id": 9899595072131128218,
        "trace_id": 12016265111767447195
    }
}

running: False
schema_name_id: 2703
start_time: 2024-11-05 02:10:18
success: True
trace_id: 12016265111767447195

Scan 6666988

duration: 0:00:14.221047

exit_message:

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

id: 6666988

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_newbookfacilities_categories/2024-11-04/1730783660",
        "key": "raw/newbookdev_newbookfacilities_categories/2024-11-04/1730783660/facilities_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4015515643841322313,
        "service_name": "drive-thru",
        "span_id": 10626853760882501932,
        "trace_id": 12695680264924791964
    }
}

running: False
schema_name_id: 2703
start_time: 2024-11-05 01:52:21
success: True
trace_id: 12695680264924791964

Scan 6666182

duration: 0:00:14.298821

exit_message:

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

id: 6666182

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_newbookfacilities_categories/2024-11-04/1730783517",
        "key": "raw/newbookdev_newbookfacilities_categories/2024-11-04/1730783517/facilities_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7632153966595439014,
        "service_name": "drive-thru",
        "span_id": 7626779463030005002,
        "trace_id": 1767664218555855776
    }
}

running: False
schema_name_id: 2703
start_time: 2024-11-05 01:31:10
success: True
trace_id: 1767664218555855776

Scan 6665441

duration: 0:00:12.028710

exit_message:

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

id: 6665441

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_newbookfacilities_categories/2024-11-04/1730783300",
        "key": "raw/newbookdev_newbookfacilities_categories/2024-11-04/1730783300/facilities_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6500547506503052674,
        "service_name": "drive-thru",
        "span_id": 5398765469048992354,
        "trace_id": 14354996909511448350
    }
}

running: False
schema_name_id: 2703
start_time: 2024-11-05 01:11:41
success: True
trace_id: 14354996909511448350

Scan 6664523

duration: 0:00:14.626820

exit_message:

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

id: 6664523

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_newbookfacilities_categories/2024-11-04/1730782901",
        "key": "raw/newbookdev_newbookfacilities_categories/2024-11-04/1730782901/facilities_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9527473451688499283,
        "service_name": "drive-thru",
        "span_id": 1396137908899092026,
        "trace_id": 5608294995025814551
    }
}

running: False
schema_name_id: 2703
start_time: 2024-11-05 00:47:16
success: True
trace_id: 5608294995025814551

Scan 6664028

duration: 0:00:12.092887

exit_message:

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

id: 6664028

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_newbookfacilities_categories/2024-11-04/1730782801",
        "key": "raw/newbookdev_newbookfacilities_categories/2024-11-04/1730782801/facilities_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18148068730939448453,
        "service_name": "drive-thru",
        "span_id": 15086092174730780384,
        "trace_id": 5505737839163124220
    }
}

running: False
schema_name_id: 2703
start_time: 2024-11-05 00:34:19
success: True
trace_id: 5505737839163124220

Partitions:

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

Schema:

attributes:

{
    "active": "string",
    "appointments": "string",
    "default_inventory_item_id": "string",
    "display_order": "string",
    "hireable": "string",
    "housekeeping": "string",
    "id": "string",
    "max_adults": "string",
    "max_animals": "string",
    "max_children": "string",
    "max_combined": "string",
    "max_infants": "string",
    "name": "string",
    "newbook_region": "string",
    "online_group_description": "string",
    "online_hire_entire_duration": "string",
    "online_hire_interval": "string",
    "online_hire_interval_multiplier": "string",
    "online_hireable": "string",
    "restrict_end_time": "string",
    "restrict_hire_interval": "string",
    "restrict_hire_interval_multiplier": "string",
    "restrict_start_time": "string",
    "system_template_terms_and_conditions": "string",
    "tenant": "string"
}

created: 2024-11-05 22:58:40

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `max_combined`  string , `display_order`  string , `hireable`  string , `housekeeping`  string , `restrict_start_time`  string , `restrict_end_time`  string , `restrict_hire_interval`  string , `restrict_hire_interval_multiplier`  string , `online_hire_interval`  string , `online_hire_interval_multiplier`  string , `online_hire_entire_duration`  string , `online_group_description`  string , `online_hireable`  string , `default_inventory_item_id`  string , `appointments`  string , `system_template_terms_and_conditions`  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_newbookfacilities_categories/2024-11-05/1730866494'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_categories"
}

Server:

hostname: schemamanager-5447774fc6-4w58v
name: schema_manager
process_start: 2026-04-02 21:43:44
sf_env: dev
version: 2427328685

Raw:

{
    "name": {
        "created": "2024-10-08 17:58:15",
        "disabled": false,
        "format": "raw",
        "id": 2703,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookfacilities_categories"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "active": "string",
            "appointments": "string",
            "default_inventory_item_id": "string",
            "display_order": "string",
            "hireable": "string",
            "housekeeping": "string",
            "id": "string",
            "max_adults": "string",
            "max_animals": "string",
            "max_children": "string",
            "max_combined": "string",
            "max_infants": "string",
            "name": "string",
            "newbook_region": "string",
            "online_group_description": "string",
            "online_hire_entire_duration": "string",
            "online_hire_interval": "string",
            "online_hire_interval_multiplier": "string",
            "online_hireable": "string",
            "restrict_end_time": "string",
            "restrict_hire_interval": "string",
            "restrict_hire_interval_multiplier": "string",
            "restrict_start_time": "string",
            "system_template_terms_and_conditions": "string",
            "tenant": "string"
        },
        "created": "2024-11-05 22:58:40",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `max_adults`  string , `max_children`  string , `max_infants`  string , `max_animals`  string , `max_combined`  string , `display_order`  string , `hireable`  string , `housekeeping`  string , `restrict_start_time`  string , `restrict_end_time`  string , `restrict_hire_interval`  string , `restrict_hire_interval_multiplier`  string , `online_hire_interval`  string , `online_hire_interval_multiplier`  string , `online_hire_entire_duration`  string , `online_group_description`  string , `online_hireable`  string , `default_inventory_item_id`  string , `appointments`  string , `system_template_terms_and_conditions`  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_newbookfacilities_categories/2024-11-05/1730866494'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_categories`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_categories"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}