Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites

created: 2024-10-08 17:38:46
disabled: False
format: raw
id: 2434
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4747862

created: 2024-11-05 22:27:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `name`  string , `short_description`  string , `description`  string , `street`  string , `city`  string , `state_id`  string , `postcode`  string , `country_id`  string , `lat`  string , `long`  string , `slideouts`  string , `display_order`  string , `status`  string , `level_id`  string , `slab_size_id`  string , `manager_id`  string , `gl_category_id`  string , `gl_account_id`  string , `opened_on`  string , `closed_on`  string , `show_online`  string , `override_category_features`  string , `overbooking`  string , `occupancy`  string , `pos_identifier`  string , `default_security_area`  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_newbookaccommodation_sites/2024-11-05/1730866349'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites/2024-11-05/1730866349
id: 4747862
processed: 1

raw_data:

{
    "category_id": 3,
    "city": 8,
    "closed_on": 23,
    "country_id": 11,
    "default_security_area": 29,
    "description": 6,
    "display_order": 15,
    "gl_account_id": 21,
    "gl_category_id": 20,
    "id": 2,
    "lat": 12,
    "level_id": 17,
    "long": 13,
    "manager_id": 19,
    "name": 4,
    "newbook_region": 0,
    "occupancy": 27,
    "opened_on": 22,
    "overbooking": 26,
    "override_category_features": 25,
    "pos_identifier": 28,
    "postcode": 10,
    "short_description": 5,
    "show_online": 24,
    "slab_size_id": 18,
    "slideouts": 14,
    "state_id": 9,
    "status": 16,
    "street": 7,
    "tenant": 1
}

schema_attributes:

{
    "category_id": "string",
    "city": "string",
    "closed_on": "string",
    "country_id": "string",
    "default_security_area": "string",
    "description": "string",
    "display_order": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "lat": "string",
    "level_id": "string",
    "long": "string",
    "manager_id": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "opened_on": "string",
    "overbooking": "string",
    "override_category_features": "string",
    "pos_identifier": "string",
    "postcode": "string",
    "short_description": "string",
    "show_online": "string",
    "slab_size_id": "string",
    "slideouts": "string",
    "state_id": "string",
    "status": "string",
    "street": "string",
    "tenant": "string"
}

schema_name_id: 2434
schema_scan_id: 6673894
updated: 2024-11-05 22:28:08

Version 4747670

created: 2024-11-05 22:22:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `name`  string , `short_description`  string , `description`  string , `street`  string , `city`  string , `state_id`  string , `postcode`  string , `country_id`  string , `lat`  string , `long`  string , `slideouts`  string , `display_order`  string , `status`  string , `level_id`  string , `slab_size_id`  string , `manager_id`  string , `gl_category_id`  string , `gl_account_id`  string , `opened_on`  string , `closed_on`  string , `show_online`  string , `override_category_features`  string , `overbooking`  string , `occupancy`  string , `pos_identifier`  string , `default_security_area`  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_newbookaccommodation_sites/2024-11-05/1730866286'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites/2024-11-05/1730866286
id: 4747670
processed: 1

raw_data:

{
    "category_id": 3,
    "city": 8,
    "closed_on": 23,
    "country_id": 11,
    "default_security_area": 29,
    "description": 6,
    "display_order": 15,
    "gl_account_id": 21,
    "gl_category_id": 20,
    "id": 2,
    "lat": 12,
    "level_id": 17,
    "long": 13,
    "manager_id": 19,
    "name": 4,
    "newbook_region": 0,
    "occupancy": 27,
    "opened_on": 22,
    "overbooking": 26,
    "override_category_features": 25,
    "pos_identifier": 28,
    "postcode": 10,
    "short_description": 5,
    "show_online": 24,
    "slab_size_id": 18,
    "slideouts": 14,
    "state_id": 9,
    "status": 16,
    "street": 7,
    "tenant": 1
}

schema_attributes:

{
    "category_id": "string",
    "city": "string",
    "closed_on": "string",
    "country_id": "string",
    "default_security_area": "string",
    "description": "string",
    "display_order": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "lat": "string",
    "level_id": "string",
    "long": "string",
    "manager_id": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "opened_on": "string",
    "overbooking": "string",
    "override_category_features": "string",
    "pos_identifier": "string",
    "postcode": "string",
    "short_description": "string",
    "show_online": "string",
    "slab_size_id": "string",
    "slideouts": "string",
    "state_id": "string",
    "status": "string",
    "street": "string",
    "tenant": "string"
}

schema_name_id: 2434
schema_scan_id: 6673702
updated: 2024-11-05 22:23:08

Version 4747381

created: 2024-11-05 22:14:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `name`  string , `short_description`  string , `description`  string , `street`  string , `city`  string , `state_id`  string , `postcode`  string , `country_id`  string , `lat`  string , `long`  string , `slideouts`  string , `display_order`  string , `status`  string , `level_id`  string , `slab_size_id`  string , `manager_id`  string , `gl_category_id`  string , `gl_account_id`  string , `opened_on`  string , `closed_on`  string , `show_online`  string , `override_category_features`  string , `overbooking`  string , `occupancy`  string , `pos_identifier`  string , `default_security_area`  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_newbookaccommodation_sites/2024-11-05/1730866225'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites/2024-11-05/1730866225
id: 4747381
processed: 1

raw_data:

{
    "category_id": 3,
    "city": 8,
    "closed_on": 23,
    "country_id": 11,
    "default_security_area": 29,
    "description": 6,
    "display_order": 15,
    "gl_account_id": 21,
    "gl_category_id": 20,
    "id": 2,
    "lat": 12,
    "level_id": 17,
    "long": 13,
    "manager_id": 19,
    "name": 4,
    "newbook_region": 0,
    "occupancy": 27,
    "opened_on": 22,
    "overbooking": 26,
    "override_category_features": 25,
    "pos_identifier": 28,
    "postcode": 10,
    "short_description": 5,
    "show_online": 24,
    "slab_size_id": 18,
    "slideouts": 14,
    "state_id": 9,
    "status": 16,
    "street": 7,
    "tenant": 1
}

schema_attributes:

{
    "category_id": "string",
    "city": "string",
    "closed_on": "string",
    "country_id": "string",
    "default_security_area": "string",
    "description": "string",
    "display_order": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "lat": "string",
    "level_id": "string",
    "long": "string",
    "manager_id": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "opened_on": "string",
    "overbooking": "string",
    "override_category_features": "string",
    "pos_identifier": "string",
    "postcode": "string",
    "short_description": "string",
    "show_online": "string",
    "slab_size_id": "string",
    "slideouts": "string",
    "state_id": "string",
    "status": "string",
    "street": "string",
    "tenant": "string"
}

schema_name_id: 2434
schema_scan_id: 6673411
updated: 2024-11-05 22:14:55

Version 4746624

created: 2024-11-05 04:13:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `name`  string , `short_description`  string , `description`  string , `street`  string , `city`  string , `state_id`  string , `postcode`  string , `country_id`  string , `lat`  string , `long`  string , `slideouts`  string , `display_order`  string , `status`  string , `level_id`  string , `slab_size_id`  string , `manager_id`  string , `gl_category_id`  string , `gl_account_id`  string , `opened_on`  string , `closed_on`  string , `show_online`  string , `override_category_features`  string , `overbooking`  string , `occupancy`  string , `pos_identifier`  string , `default_security_area`  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_newbookaccommodation_sites/2024-11-04/1730785639'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites/2024-11-04/1730785639
id: 4746624
processed: 1

raw_data:

{
    "category_id": 3,
    "city": 8,
    "closed_on": 23,
    "country_id": 11,
    "default_security_area": 29,
    "description": 6,
    "display_order": 15,
    "gl_account_id": 21,
    "gl_category_id": 20,
    "id": 2,
    "lat": 12,
    "level_id": 17,
    "long": 13,
    "manager_id": 19,
    "name": 4,
    "newbook_region": 0,
    "occupancy": 27,
    "opened_on": 22,
    "overbooking": 26,
    "override_category_features": 25,
    "pos_identifier": 28,
    "postcode": 10,
    "short_description": 5,
    "show_online": 24,
    "slab_size_id": 18,
    "slideouts": 14,
    "state_id": 9,
    "status": 16,
    "street": 7,
    "tenant": 1
}

schema_attributes:

{
    "category_id": "string",
    "city": "string",
    "closed_on": "string",
    "country_id": "string",
    "default_security_area": "string",
    "description": "string",
    "display_order": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "lat": "string",
    "level_id": "string",
    "long": "string",
    "manager_id": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "opened_on": "string",
    "overbooking": "string",
    "override_category_features": "string",
    "pos_identifier": "string",
    "postcode": "string",
    "short_description": "string",
    "show_online": "string",
    "slab_size_id": "string",
    "slideouts": "string",
    "state_id": "string",
    "status": "string",
    "street": "string",
    "tenant": "string"
}

schema_name_id: 2434
schema_scan_id: 6671847
updated: 2024-11-05 04:13:21

Version 4745339

created: 2024-11-05 03:26:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `name`  string , `short_description`  string , `description`  string , `street`  string , `city`  string , `state_id`  string , `postcode`  string , `country_id`  string , `lat`  string , `long`  string , `slideouts`  string , `display_order`  string , `status`  string , `level_id`  string , `slab_size_id`  string , `manager_id`  string , `gl_category_id`  string , `gl_account_id`  string , `opened_on`  string , `closed_on`  string , `show_online`  string , `override_category_features`  string , `overbooking`  string , `occupancy`  string , `pos_identifier`  string , `default_security_area`  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_newbookaccommodation_sites/2024-11-04/1730784770'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites/2024-11-04/1730784770
id: 4745339
processed: 1

raw_data:

{
    "category_id": 3,
    "city": 8,
    "closed_on": 23,
    "country_id": 11,
    "default_security_area": 29,
    "description": 6,
    "display_order": 15,
    "gl_account_id": 21,
    "gl_category_id": 20,
    "id": 2,
    "lat": 12,
    "level_id": 17,
    "long": 13,
    "manager_id": 19,
    "name": 4,
    "newbook_region": 0,
    "occupancy": 27,
    "opened_on": 22,
    "overbooking": 26,
    "override_category_features": 25,
    "pos_identifier": 28,
    "postcode": 10,
    "short_description": 5,
    "show_online": 24,
    "slab_size_id": 18,
    "slideouts": 14,
    "state_id": 9,
    "status": 16,
    "street": 7,
    "tenant": 1
}

schema_attributes:

{
    "category_id": "string",
    "city": "string",
    "closed_on": "string",
    "country_id": "string",
    "default_security_area": "string",
    "description": "string",
    "display_order": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "lat": "string",
    "level_id": "string",
    "long": "string",
    "manager_id": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "opened_on": "string",
    "overbooking": "string",
    "override_category_features": "string",
    "pos_identifier": "string",
    "postcode": "string",
    "short_description": "string",
    "show_online": "string",
    "slab_size_id": "string",
    "slideouts": "string",
    "state_id": "string",
    "status": "string",
    "street": "string",
    "tenant": "string"
}

schema_name_id: 2434
schema_scan_id: 6670556
updated: 2024-11-05 03:27:04

Version 4745168

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `name`  string , `short_description`  string , `description`  string , `street`  string , `city`  string , `state_id`  string , `postcode`  string , `country_id`  string , `lat`  string , `long`  string , `slideouts`  string , `display_order`  string , `status`  string , `level_id`  string , `slab_size_id`  string , `manager_id`  string , `gl_category_id`  string , `gl_account_id`  string , `opened_on`  string , `closed_on`  string , `show_online`  string , `override_category_features`  string , `overbooking`  string , `occupancy`  string , `pos_identifier`  string , `default_security_area`  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_newbookaccommodation_sites/2024-11-04/1730785076'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites/2024-11-04/1730785076
id: 4745168
processed: 1

raw_data:

{
    "category_id": 3,
    "city": 8,
    "closed_on": 23,
    "country_id": 11,
    "default_security_area": 29,
    "description": 6,
    "display_order": 15,
    "gl_account_id": 21,
    "gl_category_id": 20,
    "id": 2,
    "lat": 12,
    "level_id": 17,
    "long": 13,
    "manager_id": 19,
    "name": 4,
    "newbook_region": 0,
    "occupancy": 27,
    "opened_on": 22,
    "overbooking": 26,
    "override_category_features": 25,
    "pos_identifier": 28,
    "postcode": 10,
    "short_description": 5,
    "show_online": 24,
    "slab_size_id": 18,
    "slideouts": 14,
    "state_id": 9,
    "status": 16,
    "street": 7,
    "tenant": 1
}

schema_attributes:

{
    "category_id": "string",
    "city": "string",
    "closed_on": "string",
    "country_id": "string",
    "default_security_area": "string",
    "description": "string",
    "display_order": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "lat": "string",
    "level_id": "string",
    "long": "string",
    "manager_id": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "opened_on": "string",
    "overbooking": "string",
    "override_category_features": "string",
    "pos_identifier": "string",
    "postcode": "string",
    "short_description": "string",
    "show_online": "string",
    "slab_size_id": "string",
    "slideouts": "string",
    "state_id": "string",
    "status": "string",
    "street": "string",
    "tenant": "string"
}

schema_name_id: 2434
schema_scan_id: 6670385
updated: 2024-11-05 03:22:34

Version 4743861

created: 2024-11-05 02:47:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `name`  string , `short_description`  string , `description`  string , `street`  string , `city`  string , `state_id`  string , `postcode`  string , `country_id`  string , `lat`  string , `long`  string , `slideouts`  string , `display_order`  string , `status`  string , `level_id`  string , `slab_size_id`  string , `manager_id`  string , `gl_category_id`  string , `gl_account_id`  string , `opened_on`  string , `closed_on`  string , `show_online`  string , `override_category_features`  string , `overbooking`  string , `occupancy`  string , `pos_identifier`  string , `default_security_area`  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_newbookaccommodation_sites/2024-11-04/1730784167'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites/2024-11-04/1730784167
id: 4743861
processed: 1

raw_data:

{
    "category_id": 3,
    "city": 8,
    "closed_on": 23,
    "country_id": 11,
    "default_security_area": 29,
    "description": 6,
    "display_order": 15,
    "gl_account_id": 21,
    "gl_category_id": 20,
    "id": 2,
    "lat": 12,
    "level_id": 17,
    "long": 13,
    "manager_id": 19,
    "name": 4,
    "newbook_region": 0,
    "occupancy": 27,
    "opened_on": 22,
    "overbooking": 26,
    "override_category_features": 25,
    "pos_identifier": 28,
    "postcode": 10,
    "short_description": 5,
    "show_online": 24,
    "slab_size_id": 18,
    "slideouts": 14,
    "state_id": 9,
    "status": 16,
    "street": 7,
    "tenant": 1
}

schema_attributes:

{
    "category_id": "string",
    "city": "string",
    "closed_on": "string",
    "country_id": "string",
    "default_security_area": "string",
    "description": "string",
    "display_order": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "lat": "string",
    "level_id": "string",
    "long": "string",
    "manager_id": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "opened_on": "string",
    "overbooking": "string",
    "override_category_features": "string",
    "pos_identifier": "string",
    "postcode": "string",
    "short_description": "string",
    "show_online": "string",
    "slab_size_id": "string",
    "slideouts": "string",
    "state_id": "string",
    "status": "string",
    "street": "string",
    "tenant": "string"
}

schema_name_id: 2434
schema_scan_id: 6669078
updated: 2024-11-05 02:47:58

Version 4743716

created: 2024-11-05 02:43:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `name`  string , `short_description`  string , `description`  string , `street`  string , `city`  string , `state_id`  string , `postcode`  string , `country_id`  string , `lat`  string , `long`  string , `slideouts`  string , `display_order`  string , `status`  string , `level_id`  string , `slab_size_id`  string , `manager_id`  string , `gl_category_id`  string , `gl_account_id`  string , `opened_on`  string , `closed_on`  string , `show_online`  string , `override_category_features`  string , `overbooking`  string , `occupancy`  string , `pos_identifier`  string , `default_security_area`  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_newbookaccommodation_sites/2024-11-04/1730784005'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites/2024-11-04/1730784005
id: 4743716
processed: 1

raw_data:

{
    "category_id": 3,
    "city": 8,
    "closed_on": 23,
    "country_id": 11,
    "default_security_area": 29,
    "description": 6,
    "display_order": 15,
    "gl_account_id": 21,
    "gl_category_id": 20,
    "id": 2,
    "lat": 12,
    "level_id": 17,
    "long": 13,
    "manager_id": 19,
    "name": 4,
    "newbook_region": 0,
    "occupancy": 27,
    "opened_on": 22,
    "overbooking": 26,
    "override_category_features": 25,
    "pos_identifier": 28,
    "postcode": 10,
    "short_description": 5,
    "show_online": 24,
    "slab_size_id": 18,
    "slideouts": 14,
    "state_id": 9,
    "status": 16,
    "street": 7,
    "tenant": 1
}

schema_attributes:

{
    "category_id": "string",
    "city": "string",
    "closed_on": "string",
    "country_id": "string",
    "default_security_area": "string",
    "description": "string",
    "display_order": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "lat": "string",
    "level_id": "string",
    "long": "string",
    "manager_id": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "opened_on": "string",
    "overbooking": "string",
    "override_category_features": "string",
    "pos_identifier": "string",
    "postcode": "string",
    "short_description": "string",
    "show_online": "string",
    "slab_size_id": "string",
    "slideouts": "string",
    "state_id": "string",
    "status": "string",
    "street": "string",
    "tenant": "string"
}

schema_name_id: 2434
schema_scan_id: 6668933
updated: 2024-11-05 02:44:09

Version 4743029

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `name`  string , `short_description`  string , `description`  string , `street`  string , `city`  string , `state_id`  string , `postcode`  string , `country_id`  string , `lat`  string , `long`  string , `slideouts`  string , `display_order`  string , `status`  string , `level_id`  string , `slab_size_id`  string , `manager_id`  string , `gl_category_id`  string , `gl_account_id`  string , `opened_on`  string , `closed_on`  string , `show_online`  string , `override_category_features`  string , `overbooking`  string , `occupancy`  string , `pos_identifier`  string , `default_security_area`  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_newbookaccommodation_sites/2024-11-04/1730783831'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites/2024-11-04/1730783831
id: 4743029
processed: 1

raw_data:

{
    "category_id": 3,
    "city": 8,
    "closed_on": 23,
    "country_id": 11,
    "default_security_area": 29,
    "description": 6,
    "display_order": 15,
    "gl_account_id": 21,
    "gl_category_id": 20,
    "id": 2,
    "lat": 12,
    "level_id": 17,
    "long": 13,
    "manager_id": 19,
    "name": 4,
    "newbook_region": 0,
    "occupancy": 27,
    "opened_on": 22,
    "overbooking": 26,
    "override_category_features": 25,
    "pos_identifier": 28,
    "postcode": 10,
    "short_description": 5,
    "show_online": 24,
    "slab_size_id": 18,
    "slideouts": 14,
    "state_id": 9,
    "status": 16,
    "street": 7,
    "tenant": 1
}

schema_attributes:

{
    "category_id": "string",
    "city": "string",
    "closed_on": "string",
    "country_id": "string",
    "default_security_area": "string",
    "description": "string",
    "display_order": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "lat": "string",
    "level_id": "string",
    "long": "string",
    "manager_id": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "opened_on": "string",
    "overbooking": "string",
    "override_category_features": "string",
    "pos_identifier": "string",
    "postcode": "string",
    "short_description": "string",
    "show_online": "string",
    "slab_size_id": "string",
    "slideouts": "string",
    "state_id": "string",
    "status": "string",
    "street": "string",
    "tenant": "string"
}

schema_name_id: 2434
schema_scan_id: 6668245
updated: 2024-11-05 02:25:57

Version 4742282

created: 2024-11-05 02:06:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `name`  string , `short_description`  string , `description`  string , `street`  string , `city`  string , `state_id`  string , `postcode`  string , `country_id`  string , `lat`  string , `long`  string , `slideouts`  string , `display_order`  string , `status`  string , `level_id`  string , `slab_size_id`  string , `manager_id`  string , `gl_category_id`  string , `gl_account_id`  string , `opened_on`  string , `closed_on`  string , `show_online`  string , `override_category_features`  string , `overbooking`  string , `occupancy`  string , `pos_identifier`  string , `default_security_area`  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_newbookaccommodation_sites/2024-11-04/1730783717'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites/2024-11-04/1730783717
id: 4742282
processed: 1

raw_data:

{
    "category_id": 3,
    "city": 8,
    "closed_on": 23,
    "country_id": 11,
    "default_security_area": 29,
    "description": 6,
    "display_order": 15,
    "gl_account_id": 21,
    "gl_category_id": 20,
    "id": 2,
    "lat": 12,
    "level_id": 17,
    "long": 13,
    "manager_id": 19,
    "name": 4,
    "newbook_region": 0,
    "occupancy": 27,
    "opened_on": 22,
    "overbooking": 26,
    "override_category_features": 25,
    "pos_identifier": 28,
    "postcode": 10,
    "short_description": 5,
    "show_online": 24,
    "slab_size_id": 18,
    "slideouts": 14,
    "state_id": 9,
    "status": 16,
    "street": 7,
    "tenant": 1
}

schema_attributes:

{
    "category_id": "string",
    "city": "string",
    "closed_on": "string",
    "country_id": "string",
    "default_security_area": "string",
    "description": "string",
    "display_order": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "lat": "string",
    "level_id": "string",
    "long": "string",
    "manager_id": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "opened_on": "string",
    "overbooking": "string",
    "override_category_features": "string",
    "pos_identifier": "string",
    "postcode": "string",
    "short_description": "string",
    "show_online": "string",
    "slab_size_id": "string",
    "slideouts": "string",
    "state_id": "string",
    "status": "string",
    "street": "string",
    "tenant": "string"
}

schema_name_id: 2434
schema_scan_id: 6667499
updated: 2024-11-05 02:06:15

Version 4741757

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `name`  string , `short_description`  string , `description`  string , `street`  string , `city`  string , `state_id`  string , `postcode`  string , `country_id`  string , `lat`  string , `long`  string , `slideouts`  string , `display_order`  string , `status`  string , `level_id`  string , `slab_size_id`  string , `manager_id`  string , `gl_category_id`  string , `gl_account_id`  string , `opened_on`  string , `closed_on`  string , `show_online`  string , `override_category_features`  string , `overbooking`  string , `occupancy`  string , `pos_identifier`  string , `default_security_area`  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_newbookaccommodation_sites/2024-11-04/1730783627'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites/2024-11-04/1730783627
id: 4741757
processed: 1

raw_data:

{
    "category_id": 3,
    "city": 8,
    "closed_on": 23,
    "country_id": 11,
    "default_security_area": 29,
    "description": 6,
    "display_order": 15,
    "gl_account_id": 21,
    "gl_category_id": 20,
    "id": 2,
    "lat": 12,
    "level_id": 17,
    "long": 13,
    "manager_id": 19,
    "name": 4,
    "newbook_region": 0,
    "occupancy": 27,
    "opened_on": 22,
    "overbooking": 26,
    "override_category_features": 25,
    "pos_identifier": 28,
    "postcode": 10,
    "short_description": 5,
    "show_online": 24,
    "slab_size_id": 18,
    "slideouts": 14,
    "state_id": 9,
    "status": 16,
    "street": 7,
    "tenant": 1
}

schema_attributes:

{
    "category_id": "string",
    "city": "string",
    "closed_on": "string",
    "country_id": "string",
    "default_security_area": "string",
    "description": "string",
    "display_order": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "lat": "string",
    "level_id": "string",
    "long": "string",
    "manager_id": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "opened_on": "string",
    "overbooking": "string",
    "override_category_features": "string",
    "pos_identifier": "string",
    "postcode": "string",
    "short_description": "string",
    "show_online": "string",
    "slab_size_id": "string",
    "slideouts": "string",
    "state_id": "string",
    "status": "string",
    "street": "string",
    "tenant": "string"
}

schema_name_id: 2434
schema_scan_id: 6666974
updated: 2024-11-05 01:52:12

Version 4740812

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `name`  string , `short_description`  string , `description`  string , `street`  string , `city`  string , `state_id`  string , `postcode`  string , `country_id`  string , `lat`  string , `long`  string , `slideouts`  string , `display_order`  string , `status`  string , `level_id`  string , `slab_size_id`  string , `manager_id`  string , `gl_category_id`  string , `gl_account_id`  string , `opened_on`  string , `closed_on`  string , `show_online`  string , `override_category_features`  string , `overbooking`  string , `occupancy`  string , `pos_identifier`  string , `default_security_area`  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_newbookaccommodation_sites/2024-11-04/1730783473'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites/2024-11-04/1730783473
id: 4740812
processed: 1

raw_data:

{
    "category_id": 3,
    "city": 8,
    "closed_on": 23,
    "country_id": 11,
    "default_security_area": 29,
    "description": 6,
    "display_order": 15,
    "gl_account_id": 21,
    "gl_category_id": 20,
    "id": 2,
    "lat": 12,
    "level_id": 17,
    "long": 13,
    "manager_id": 19,
    "name": 4,
    "newbook_region": 0,
    "occupancy": 27,
    "opened_on": 22,
    "overbooking": 26,
    "override_category_features": 25,
    "pos_identifier": 28,
    "postcode": 10,
    "short_description": 5,
    "show_online": 24,
    "slab_size_id": 18,
    "slideouts": 14,
    "state_id": 9,
    "status": 16,
    "street": 7,
    "tenant": 1
}

schema_attributes:

{
    "category_id": "string",
    "city": "string",
    "closed_on": "string",
    "country_id": "string",
    "default_security_area": "string",
    "description": "string",
    "display_order": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "lat": "string",
    "level_id": "string",
    "long": "string",
    "manager_id": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "opened_on": "string",
    "overbooking": "string",
    "override_category_features": "string",
    "pos_identifier": "string",
    "postcode": "string",
    "short_description": "string",
    "show_online": "string",
    "slab_size_id": "string",
    "slideouts": "string",
    "state_id": "string",
    "status": "string",
    "street": "string",
    "tenant": "string"
}

schema_name_id: 2434
schema_scan_id: 6666029
updated: 2024-11-05 01:27:20

Version 4739999

created: 2024-11-05 01:05:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `name`  string , `short_description`  string , `description`  string , `street`  string , `city`  string , `state_id`  string , `postcode`  string , `country_id`  string , `lat`  string , `long`  string , `slideouts`  string , `display_order`  string , `status`  string , `level_id`  string , `slab_size_id`  string , `manager_id`  string , `gl_category_id`  string , `gl_account_id`  string , `opened_on`  string , `closed_on`  string , `show_online`  string , `override_category_features`  string , `overbooking`  string , `occupancy`  string , `pos_identifier`  string , `default_security_area`  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_newbookaccommodation_sites/2024-11-04/1730783254'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites/2024-11-04/1730783254
id: 4739999
processed: 1

raw_data:

{
    "category_id": 3,
    "city": 8,
    "closed_on": 23,
    "country_id": 11,
    "default_security_area": 29,
    "description": 6,
    "display_order": 15,
    "gl_account_id": 21,
    "gl_category_id": 20,
    "id": 2,
    "lat": 12,
    "level_id": 17,
    "long": 13,
    "manager_id": 19,
    "name": 4,
    "newbook_region": 0,
    "occupancy": 27,
    "opened_on": 22,
    "overbooking": 26,
    "override_category_features": 25,
    "pos_identifier": 28,
    "postcode": 10,
    "short_description": 5,
    "show_online": 24,
    "slab_size_id": 18,
    "slideouts": 14,
    "state_id": 9,
    "status": 16,
    "street": 7,
    "tenant": 1
}

schema_attributes:

{
    "category_id": "string",
    "city": "string",
    "closed_on": "string",
    "country_id": "string",
    "default_security_area": "string",
    "description": "string",
    "display_order": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "lat": "string",
    "level_id": "string",
    "long": "string",
    "manager_id": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "opened_on": "string",
    "overbooking": "string",
    "override_category_features": "string",
    "pos_identifier": "string",
    "postcode": "string",
    "short_description": "string",
    "show_online": "string",
    "slab_size_id": "string",
    "slideouts": "string",
    "state_id": "string",
    "status": "string",
    "street": "string",
    "tenant": "string"
}

schema_name_id: 2434
schema_scan_id: 6665216
updated: 2024-11-05 01:05:49

Version 4739321

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `name`  string , `short_description`  string , `description`  string , `street`  string , `city`  string , `state_id`  string , `postcode`  string , `country_id`  string , `lat`  string , `long`  string , `slideouts`  string , `display_order`  string , `status`  string , `level_id`  string , `slab_size_id`  string , `manager_id`  string , `gl_category_id`  string , `gl_account_id`  string , `opened_on`  string , `closed_on`  string , `show_online`  string , `override_category_features`  string , `overbooking`  string , `occupancy`  string , `pos_identifier`  string , `default_security_area`  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_newbookaccommodation_sites/2024-11-04/1730782857'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites/2024-11-04/1730782857
id: 4739321
processed: 1

raw_data:

{
    "category_id": 3,
    "city": 8,
    "closed_on": 23,
    "country_id": 11,
    "default_security_area": 29,
    "description": 6,
    "display_order": 15,
    "gl_account_id": 21,
    "gl_category_id": 20,
    "id": 2,
    "lat": 12,
    "level_id": 17,
    "long": 13,
    "manager_id": 19,
    "name": 4,
    "newbook_region": 0,
    "occupancy": 27,
    "opened_on": 22,
    "overbooking": 26,
    "override_category_features": 25,
    "pos_identifier": 28,
    "postcode": 10,
    "short_description": 5,
    "show_online": 24,
    "slab_size_id": 18,
    "slideouts": 14,
    "state_id": 9,
    "status": 16,
    "street": 7,
    "tenant": 1
}

schema_attributes:

{
    "category_id": "string",
    "city": "string",
    "closed_on": "string",
    "country_id": "string",
    "default_security_area": "string",
    "description": "string",
    "display_order": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "lat": "string",
    "level_id": "string",
    "long": "string",
    "manager_id": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "opened_on": "string",
    "overbooking": "string",
    "override_category_features": "string",
    "pos_identifier": "string",
    "postcode": "string",
    "short_description": "string",
    "show_online": "string",
    "slab_size_id": "string",
    "slideouts": "string",
    "state_id": "string",
    "status": "string",
    "street": "string",
    "tenant": "string"
}

schema_name_id: 2434
schema_scan_id: 6664536
updated: 2024-11-05 00:47:48

Version 4738780

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `name`  string , `short_description`  string , `description`  string , `street`  string , `city`  string , `state_id`  string , `postcode`  string , `country_id`  string , `lat`  string , `long`  string , `slideouts`  string , `display_order`  string , `status`  string , `level_id`  string , `slab_size_id`  string , `manager_id`  string , `gl_category_id`  string , `gl_account_id`  string , `opened_on`  string , `closed_on`  string , `show_online`  string , `override_category_features`  string , `overbooking`  string , `occupancy`  string , `pos_identifier`  string , `default_security_area`  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_newbookaccommodation_sites/2024-11-04/1730782768'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites/2024-11-04/1730782768
id: 4738780
processed: 1

raw_data:

{
    "category_id": 3,
    "city": 8,
    "closed_on": 23,
    "country_id": 11,
    "default_security_area": 29,
    "description": 6,
    "display_order": 15,
    "gl_account_id": 21,
    "gl_category_id": 20,
    "id": 2,
    "lat": 12,
    "level_id": 17,
    "long": 13,
    "manager_id": 19,
    "name": 4,
    "newbook_region": 0,
    "occupancy": 27,
    "opened_on": 22,
    "overbooking": 26,
    "override_category_features": 25,
    "pos_identifier": 28,
    "postcode": 10,
    "short_description": 5,
    "show_online": 24,
    "slab_size_id": 18,
    "slideouts": 14,
    "state_id": 9,
    "status": 16,
    "street": 7,
    "tenant": 1
}

schema_attributes:

{
    "category_id": "string",
    "city": "string",
    "closed_on": "string",
    "country_id": "string",
    "default_security_area": "string",
    "description": "string",
    "display_order": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "lat": "string",
    "level_id": "string",
    "long": "string",
    "manager_id": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "opened_on": "string",
    "overbooking": "string",
    "override_category_features": "string",
    "pos_identifier": "string",
    "postcode": "string",
    "short_description": "string",
    "show_online": "string",
    "slab_size_id": "string",
    "slideouts": "string",
    "state_id": "string",
    "status": "string",
    "street": "string",
    "tenant": "string"
}

schema_name_id: 2434
schema_scan_id: 6663993
updated: 2024-11-05 00:33:41

Schema Scans: 15

Last at 2024-11-05 22:27:56

Scan 6673894

duration: 0:00:12.081445

exit_message:

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

id: 6673894

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_newbookaccommodation_sites/2024-11-05/1730866349",
        "key": "raw/newbookdev_newbookaccommodation_sites/2024-11-05/1730866349/accommodation_sites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 122479011972154443,
        "service_name": "drive-thru",
        "span_id": 6814097959721531910,
        "trace_id": 10118049212538470740
    }
}

running: False
schema_name_id: 2434
start_time: 2024-11-05 22:27:56
success: True
trace_id: 10118049212538470740

Scan 6673702

duration: 0:00:12.032814

exit_message:

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

id: 6673702

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_newbookaccommodation_sites/2024-11-05/1730866286",
        "key": "raw/newbookdev_newbookaccommodation_sites/2024-11-05/1730866286/accommodation_sites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3825606457450160307,
        "service_name": "drive-thru",
        "span_id": 45844910945067781,
        "trace_id": 417687382818793566
    }
}

running: False
schema_name_id: 2434
start_time: 2024-11-05 22:22:56
success: True
trace_id: 417687382818793566

Scan 6673411

duration: 0:00:23.778754

exit_message:

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

id: 6673411

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_newbookaccommodation_sites/2024-11-05/1730866225",
        "key": "raw/newbookdev_newbookaccommodation_sites/2024-11-05/1730866225/accommodation_sites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9484881756845685447,
        "service_name": "drive-thru",
        "span_id": 11884607012955873683,
        "trace_id": 17785876537393474935
    }
}

running: False
schema_name_id: 2434
start_time: 2024-11-05 22:14:31
success: True
trace_id: 17785876537393474935

Scan 6671847

duration: 0:00:12.361888

exit_message:

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

id: 6671847

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_newbookaccommodation_sites/2024-11-04/1730785639",
        "key": "raw/newbookdev_newbookaccommodation_sites/2024-11-04/1730785639/accommodation_sites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6499934044993551268,
        "service_name": "drive-thru",
        "span_id": 8923152491837039766,
        "trace_id": 11989299449809422070
    }
}

running: False
schema_name_id: 2434
start_time: 2024-11-05 04:13:09
success: True
trace_id: 11989299449809422070

Scan 6670556

duration: 0:00:14.599358

exit_message:

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

id: 6670556

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_newbookaccommodation_sites/2024-11-04/1730784770",
        "key": "raw/newbookdev_newbookaccommodation_sites/2024-11-04/1730784770/accommodation_sites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3878575883488441191,
        "service_name": "drive-thru",
        "span_id": 9769303490694152149,
        "trace_id": 8771767598973401279
    }
}

running: False
schema_name_id: 2434
start_time: 2024-11-05 03:26:50
success: True
trace_id: 8771767598973401279

Scan 6670385

duration: 0:00:11.966021

exit_message:

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

id: 6670385

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_newbookaccommodation_sites/2024-11-04/1730785076",
        "key": "raw/newbookdev_newbookaccommodation_sites/2024-11-04/1730785076/accommodation_sites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16052766957555619652,
        "service_name": "drive-thru",
        "span_id": 10332852372850577152,
        "trace_id": 5244437645121261042
    }
}

running: False
schema_name_id: 2434
start_time: 2024-11-05 03:22:22
success: True
trace_id: 5244437645121261042

Scan 6669078

duration: 0:00:12.027514

exit_message:

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

id: 6669078

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_newbookaccommodation_sites/2024-11-04/1730784167",
        "key": "raw/newbookdev_newbookaccommodation_sites/2024-11-04/1730784167/accommodation_sites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8899380047773394359,
        "service_name": "drive-thru",
        "span_id": 17482443555790632216,
        "trace_id": 17366187440505205017
    }
}

running: False
schema_name_id: 2434
start_time: 2024-11-05 02:47:46
success: True
trace_id: 17366187440505205017

Scan 6668933

duration: 0:00:12.071513

exit_message:

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

id: 6668933

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_newbookaccommodation_sites/2024-11-04/1730784005",
        "key": "raw/newbookdev_newbookaccommodation_sites/2024-11-04/1730784005/accommodation_sites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14492286672238725665,
        "service_name": "drive-thru",
        "span_id": 15998192332341171800,
        "trace_id": 16122793263115876501
    }
}

running: False
schema_name_id: 2434
start_time: 2024-11-05 02:43:57
success: True
trace_id: 16122793263115876501

Scan 6668245

duration: 0:00:12.090506

exit_message:

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

id: 6668245

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_newbookaccommodation_sites/2024-11-04/1730783831",
        "key": "raw/newbookdev_newbookaccommodation_sites/2024-11-04/1730783831/accommodation_sites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10684925459502192545,
        "service_name": "drive-thru",
        "span_id": 10772433759155747691,
        "trace_id": 3041147560554477415
    }
}

running: False
schema_name_id: 2434
start_time: 2024-11-05 02:25:45
success: True
trace_id: 3041147560554477415

Scan 6667499

duration: 0:00:14.674456

exit_message:

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

id: 6667499

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_newbookaccommodation_sites/2024-11-04/1730783717",
        "key": "raw/newbookdev_newbookaccommodation_sites/2024-11-04/1730783717/accommodation_sites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13989567154634654458,
        "service_name": "drive-thru",
        "span_id": 11981338936061145833,
        "trace_id": 6951991058151683718
    }
}

running: False
schema_name_id: 2434
start_time: 2024-11-05 02:06:01
success: True
trace_id: 6951991058151683718

Scan 6666974

duration: 0:00:14.539258

exit_message:

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

id: 6666974

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_newbookaccommodation_sites/2024-11-04/1730783627",
        "key": "raw/newbookdev_newbookaccommodation_sites/2024-11-04/1730783627/accommodation_sites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8564451221976824702,
        "service_name": "drive-thru",
        "span_id": 4910850594573684476,
        "trace_id": 4984068438972864584
    }
}

running: False
schema_name_id: 2434
start_time: 2024-11-05 01:51:58
success: True
trace_id: 4984068438972864584

Scan 6666029

duration: 0:00:12.031153

exit_message:

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

id: 6666029

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_newbookaccommodation_sites/2024-11-04/1730783473",
        "key": "raw/newbookdev_newbookaccommodation_sites/2024-11-04/1730783473/accommodation_sites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3185600145397817940,
        "service_name": "drive-thru",
        "span_id": 16409494655436027250,
        "trace_id": 13218592708898754031
    }
}

running: False
schema_name_id: 2434
start_time: 2024-11-05 01:27:08
success: True
trace_id: 13218592708898754031

Scan 6665216

duration: 0:00:14.554519

exit_message:

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

id: 6665216

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_newbookaccommodation_sites/2024-11-04/1730783254",
        "key": "raw/newbookdev_newbookaccommodation_sites/2024-11-04/1730783254/accommodation_sites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11141786211965139789,
        "service_name": "drive-thru",
        "span_id": 4661926042906853479,
        "trace_id": 11047893041996174501
    }
}

running: False
schema_name_id: 2434
start_time: 2024-11-05 01:05:35
success: True
trace_id: 11047893041996174501

Scan 6664536

duration: 0:00:12.088842

exit_message:

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

id: 6664536

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_newbookaccommodation_sites/2024-11-04/1730782857",
        "key": "raw/newbookdev_newbookaccommodation_sites/2024-11-04/1730782857/accommodation_sites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8770124054353046294,
        "service_name": "drive-thru",
        "span_id": 2986348958378694563,
        "trace_id": 15882630175335152110
    }
}

running: False
schema_name_id: 2434
start_time: 2024-11-05 00:47:36
success: True
trace_id: 15882630175335152110

Scan 6663993

duration: 0:00:14.491394

exit_message:

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

id: 6663993

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_newbookaccommodation_sites/2024-11-04/1730782768",
        "key": "raw/newbookdev_newbookaccommodation_sites/2024-11-04/1730782768/accommodation_sites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17598770699022908535,
        "service_name": "drive-thru",
        "span_id": 9933972849344685181,
        "trace_id": 18344170322481709341
    }
}

running: False
schema_name_id: 2434
start_time: 2024-11-05 00:33:26
success: True
trace_id: 18344170322481709341

Partitions:

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

Schema:

attributes:

{
    "category_id": "string",
    "city": "string",
    "closed_on": "string",
    "country_id": "string",
    "default_security_area": "string",
    "description": "string",
    "display_order": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "lat": "string",
    "level_id": "string",
    "long": "string",
    "manager_id": "string",
    "name": "string",
    "newbook_region": "string",
    "occupancy": "string",
    "opened_on": "string",
    "overbooking": "string",
    "override_category_features": "string",
    "pos_identifier": "string",
    "postcode": "string",
    "short_description": "string",
    "show_online": "string",
    "slab_size_id": "string",
    "slideouts": "string",
    "state_id": "string",
    "status": "string",
    "street": "string",
    "tenant": "string"
}

created: 2024-11-05 22:27:57

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `name`  string , `short_description`  string , `description`  string , `street`  string , `city`  string , `state_id`  string , `postcode`  string , `country_id`  string , `lat`  string , `long`  string , `slideouts`  string , `display_order`  string , `status`  string , `level_id`  string , `slab_size_id`  string , `manager_id`  string , `gl_category_id`  string , `gl_account_id`  string , `opened_on`  string , `closed_on`  string , `show_online`  string , `override_category_features`  string , `overbooking`  string , `occupancy`  string , `pos_identifier`  string , `default_security_area`  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_newbookaccommodation_sites/2024-11-05/1730866349'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites"
}

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:38:46",
        "disabled": false,
        "format": "raw",
        "id": 2434,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookaccommodation_sites"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "category_id": "string",
            "city": "string",
            "closed_on": "string",
            "country_id": "string",
            "default_security_area": "string",
            "description": "string",
            "display_order": "string",
            "gl_account_id": "string",
            "gl_category_id": "string",
            "id": "string",
            "lat": "string",
            "level_id": "string",
            "long": "string",
            "manager_id": "string",
            "name": "string",
            "newbook_region": "string",
            "occupancy": "string",
            "opened_on": "string",
            "overbooking": "string",
            "override_category_features": "string",
            "pos_identifier": "string",
            "postcode": "string",
            "short_description": "string",
            "show_online": "string",
            "slab_size_id": "string",
            "slideouts": "string",
            "state_id": "string",
            "status": "string",
            "street": "string",
            "tenant": "string"
        },
        "created": "2024-11-05 22:27:57",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `name`  string , `short_description`  string , `description`  string , `street`  string , `city`  string , `state_id`  string , `postcode`  string , `country_id`  string , `lat`  string , `long`  string , `slideouts`  string , `display_order`  string , `status`  string , `level_id`  string , `slab_size_id`  string , `manager_id`  string , `gl_category_id`  string , `gl_account_id`  string , `opened_on`  string , `closed_on`  string , `show_online`  string , `override_category_features`  string , `overbooking`  string , `occupancy`  string , `pos_identifier`  string , `default_security_area`  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_newbookaccommodation_sites/2024-11-05/1730866349'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}