Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels

created: 2024-10-08 17:37:21
disabled: False
format: raw
id: 2414
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4747998

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `cm_roomcode`  string , `cm_settings`  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_newbookaccommodation_categories_channels/2024-11-05/1730866343'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories_channels/2024-11-05/1730866343
id: 4747998
processed: 1

raw_data:

{
    "active": 8,
    "booking_channel_id": 5,
    "category_id": 3,
    "cm_roomcode": 6,
    "cm_settings": 7,
    "direct_channel_manager_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "category_id": "string",
    "cm_roomcode": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2414
schema_scan_id: 6674030
updated: 2024-11-05 22:31:56

Version 4747571

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `cm_roomcode`  string , `cm_settings`  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_newbookaccommodation_categories_channels/2024-11-05/1730866281'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories_channels/2024-11-05/1730866281
id: 4747571
processed: 1

raw_data:

{
    "active": 8,
    "booking_channel_id": 5,
    "category_id": 3,
    "cm_roomcode": 6,
    "cm_settings": 7,
    "direct_channel_manager_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "category_id": "string",
    "cm_roomcode": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2414
schema_scan_id: 6673603
updated: 2024-11-05 22:20:31

Version 4747340

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `cm_roomcode`  string , `cm_settings`  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_newbookaccommodation_categories_channels/2024-11-05/1730866222'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories_channels/2024-11-05/1730866222
id: 4747340
processed: 1

raw_data:

{
    "active": 8,
    "booking_channel_id": 5,
    "category_id": 3,
    "cm_roomcode": 6,
    "cm_settings": 7,
    "direct_channel_manager_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "category_id": "string",
    "cm_roomcode": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2414
schema_scan_id: 6673372
updated: 2024-11-05 22:11:51

Version 4746765

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `cm_roomcode`  string , `cm_settings`  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_newbookaccommodation_categories_channels/2024-11-04/1730785635'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories_channels/2024-11-04/1730785635
id: 4746765
processed: 1

raw_data:

{
    "active": 8,
    "booking_channel_id": 5,
    "category_id": 3,
    "cm_roomcode": 6,
    "cm_settings": 7,
    "direct_channel_manager_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "category_id": "string",
    "cm_roomcode": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2414
schema_scan_id: 6671994
updated: 2024-11-05 04:21:47

Version 4745882

created: 2024-11-05 03:41:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `cm_roomcode`  string , `cm_settings`  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_newbookaccommodation_categories_channels/2024-11-04/1730785074'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories_channels/2024-11-04/1730785074
id: 4745882
processed: 1

raw_data:

{
    "active": 8,
    "booking_channel_id": 5,
    "category_id": 3,
    "cm_roomcode": 6,
    "cm_settings": 7,
    "direct_channel_manager_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "category_id": "string",
    "cm_roomcode": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2414
schema_scan_id: 6671099
updated: 2024-11-05 03:42:05

Version 4745607

created: 2024-11-05 03:33:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `cm_roomcode`  string , `cm_settings`  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_newbookaccommodation_categories_channels/2024-11-04/1730784769'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories_channels/2024-11-04/1730784769
id: 4745607
processed: 1

raw_data:

{
    "active": 8,
    "booking_channel_id": 5,
    "category_id": 3,
    "cm_roomcode": 6,
    "cm_settings": 7,
    "direct_channel_manager_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "category_id": "string",
    "cm_roomcode": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2414
schema_scan_id: 6670824
updated: 2024-11-05 03:34:07

Version 4744852

created: 2024-11-05 03:14:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `cm_roomcode`  string , `cm_settings`  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_newbookaccommodation_categories_channels/2024-11-04/1730784165'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories_channels/2024-11-04/1730784165
id: 4744852
processed: 1

raw_data:

{
    "active": 8,
    "booking_channel_id": 5,
    "category_id": 3,
    "cm_roomcode": 6,
    "cm_settings": 7,
    "direct_channel_manager_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "category_id": "string",
    "cm_roomcode": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2414
schema_scan_id: 6670069
updated: 2024-11-05 03:14:16

Version 4743704

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `cm_roomcode`  string , `cm_settings`  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_newbookaccommodation_categories_channels/2024-11-04/1730784003'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories_channels/2024-11-04/1730784003
id: 4743704
processed: 1

raw_data:

{
    "active": 8,
    "booking_channel_id": 5,
    "category_id": 3,
    "cm_roomcode": 6,
    "cm_settings": 7,
    "direct_channel_manager_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "category_id": "string",
    "cm_roomcode": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2414
schema_scan_id: 6668921
updated: 2024-11-05 02:43:51

Version 4743026

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `cm_roomcode`  string , `cm_settings`  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_newbookaccommodation_categories_channels/2024-11-04/1730783831'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels"
]

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

raw_data:

{
    "active": 8,
    "booking_channel_id": 5,
    "category_id": 3,
    "cm_roomcode": 6,
    "cm_settings": 7,
    "direct_channel_manager_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "category_id": "string",
    "cm_roomcode": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2414
schema_scan_id: 6668243
updated: 2024-11-05 02:25:53

Version 4742236

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `cm_roomcode`  string , `cm_settings`  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_newbookaccommodation_categories_channels/2024-11-04/1730783715'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories_channels/2024-11-04/1730783715
id: 4742236
processed: 1

raw_data:

{
    "active": 8,
    "booking_channel_id": 5,
    "category_id": 3,
    "cm_roomcode": 6,
    "cm_settings": 7,
    "direct_channel_manager_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "category_id": "string",
    "cm_roomcode": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2414
schema_scan_id: 6667453
updated: 2024-11-05 02:04:59

Version 4741780

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `cm_roomcode`  string , `cm_settings`  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_newbookaccommodation_categories_channels/2024-11-04/1730783626'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories_channels/2024-11-04/1730783626
id: 4741780
processed: 1

raw_data:

{
    "active": 8,
    "booking_channel_id": 5,
    "category_id": 3,
    "cm_roomcode": 6,
    "cm_settings": 7,
    "direct_channel_manager_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "category_id": "string",
    "cm_roomcode": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2414
schema_scan_id: 6666997
updated: 2024-11-05 01:52:47

Version 4740398

created: 2024-11-05 01:16:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `cm_roomcode`  string , `cm_settings`  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_newbookaccommodation_categories_channels/2024-11-04/1730783471'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories_channels/2024-11-04/1730783471
id: 4740398
processed: 1

raw_data:

{
    "active": 8,
    "booking_channel_id": 5,
    "category_id": 3,
    "cm_roomcode": 6,
    "cm_settings": 7,
    "direct_channel_manager_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "category_id": "string",
    "cm_roomcode": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2414
schema_scan_id: 6665615
updated: 2024-11-05 01:16:27

Version 4740099

created: 2024-11-05 01:08:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `cm_roomcode`  string , `cm_settings`  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_newbookaccommodation_categories_channels/2024-11-04/1730783253'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories_channels/2024-11-04/1730783253
id: 4740099
processed: 1

raw_data:

{
    "active": 8,
    "booking_channel_id": 5,
    "category_id": 3,
    "cm_roomcode": 6,
    "cm_settings": 7,
    "direct_channel_manager_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "category_id": "string",
    "cm_roomcode": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2414
schema_scan_id: 6665316
updated: 2024-11-05 01:08:34

Version 4739001

created: 2024-11-05 00:39:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `cm_roomcode`  string , `cm_settings`  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_newbookaccommodation_categories_channels/2024-11-04/1730782855'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories_channels/2024-11-04/1730782855
id: 4739001
processed: 1

raw_data:

{
    "active": 8,
    "booking_channel_id": 5,
    "category_id": 3,
    "cm_roomcode": 6,
    "cm_settings": 7,
    "direct_channel_manager_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "category_id": "string",
    "cm_roomcode": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2414
schema_scan_id: 6664216
updated: 2024-11-05 00:39:25

Version 4738760

created: 2024-11-05 00:32:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `cm_roomcode`  string , `cm_settings`  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_newbookaccommodation_categories_channels/2024-11-04/1730782767'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories_channels/2024-11-04/1730782767
id: 4738760
processed: 1

raw_data:

{
    "active": 8,
    "booking_channel_id": 5,
    "category_id": 3,
    "cm_roomcode": 6,
    "cm_settings": 7,
    "direct_channel_manager_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "category_id": "string",
    "cm_roomcode": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2414
schema_scan_id: 6663973
updated: 2024-11-05 00:33:02

Schema Scans: 15

Last at 2024-11-05 22:31:42

Scan 6674030

duration: 0:00:14.126260

exit_message:

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

id: 6674030

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_categories_channels/2024-11-05/1730866343",
        "key": "raw/newbookdev_newbookaccommodation_categories_channels/2024-11-05/1730866343/accommodation_categories_channels.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 157092785503484842,
        "service_name": "drive-thru",
        "span_id": 16041376218078850185,
        "trace_id": 12400860079246560972
    }
}

running: False
schema_name_id: 2414
start_time: 2024-11-05 22:31:42
success: True
trace_id: 12400860079246560972

Scan 6673603

duration: 0:00:11.413982

exit_message:

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

id: 6673603

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_categories_channels/2024-11-05/1730866281",
        "key": "raw/newbookdev_newbookaccommodation_categories_channels/2024-11-05/1730866281/accommodation_categories_channels.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2577765200947763453,
        "service_name": "drive-thru",
        "span_id": 18399481197012978754,
        "trace_id": 2634775595989618210
    }
}

running: False
schema_name_id: 2414
start_time: 2024-11-05 22:20:20
success: True
trace_id: 2634775595989618210

Scan 6673372

duration: 0:00:14.135697

exit_message:

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

id: 6673372

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_categories_channels/2024-11-05/1730866222",
        "key": "raw/newbookdev_newbookaccommodation_categories_channels/2024-11-05/1730866222/accommodation_categories_channels.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14235676797738002651,
        "service_name": "drive-thru",
        "span_id": 12353746354779359518,
        "trace_id": 14356557918612082062
    }
}

running: False
schema_name_id: 2414
start_time: 2024-11-05 22:11:37
success: True
trace_id: 14356557918612082062

Scan 6671994

duration: 0:00:11.619096

exit_message:

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

id: 6671994

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_categories_channels/2024-11-04/1730785635",
        "key": "raw/newbookdev_newbookaccommodation_categories_channels/2024-11-04/1730785635/accommodation_categories_channels.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3092319535358189078,
        "service_name": "drive-thru",
        "span_id": 14039212181252802129,
        "trace_id": 1085769418630987493
    }
}

running: False
schema_name_id: 2414
start_time: 2024-11-05 04:21:36
success: True
trace_id: 1085769418630987493

Scan 6671099

duration: 0:00:11.595433

exit_message:

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

id: 6671099

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_categories_channels/2024-11-04/1730785074",
        "key": "raw/newbookdev_newbookaccommodation_categories_channels/2024-11-04/1730785074/accommodation_categories_channels.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17789562564447675007,
        "service_name": "drive-thru",
        "span_id": 502956415695414400,
        "trace_id": 11014221739431474030
    }
}

running: False
schema_name_id: 2414
start_time: 2024-11-05 03:41:54
success: True
trace_id: 11014221739431474030

Scan 6670824

duration: 0:00:11.451592

exit_message:

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

id: 6670824

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_categories_channels/2024-11-04/1730784769",
        "key": "raw/newbookdev_newbookaccommodation_categories_channels/2024-11-04/1730784769/accommodation_categories_channels.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9411589176341874480,
        "service_name": "drive-thru",
        "span_id": 11090938891505638836,
        "trace_id": 11925342563939890073
    }
}

running: False
schema_name_id: 2414
start_time: 2024-11-05 03:33:56
success: True
trace_id: 11925342563939890073

Scan 6670069

duration: 0:00:11.456200

exit_message:

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

id: 6670069

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_categories_channels/2024-11-04/1730784165",
        "key": "raw/newbookdev_newbookaccommodation_categories_channels/2024-11-04/1730784165/accommodation_categories_channels.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1116401301626278209,
        "service_name": "drive-thru",
        "span_id": 9695583784979700338,
        "trace_id": 15858883420894961673
    }
}

running: False
schema_name_id: 2414
start_time: 2024-11-05 03:14:05
success: True
trace_id: 15858883420894961673

Scan 6668921

duration: 0:00:13.987895

exit_message:

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

id: 6668921

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_categories_channels/2024-11-04/1730784003",
        "key": "raw/newbookdev_newbookaccommodation_categories_channels/2024-11-04/1730784003/accommodation_categories_channels.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2464712169055763008,
        "service_name": "drive-thru",
        "span_id": 6098867812195946750,
        "trace_id": 15773988808021917733
    }
}

running: False
schema_name_id: 2414
start_time: 2024-11-05 02:43:37
success: True
trace_id: 15773988808021917733

Scan 6668243

duration: 0:00:11.546032

exit_message:

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

id: 6668243

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_categories_channels/2024-11-04/1730783831",
        "key": "raw/newbookdev_newbookaccommodation_categories_channels/2024-11-04/1730783831/accommodation_categories_channels.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1532282892731785248,
        "service_name": "drive-thru",
        "span_id": 11465557313546320913,
        "trace_id": 14774971298243080722
    }
}

running: False
schema_name_id: 2414
start_time: 2024-11-05 02:25:42
success: True
trace_id: 14774971298243080722

Scan 6667453

duration: 0:00:11.750267

exit_message:

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

id: 6667453

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_categories_channels/2024-11-04/1730783715",
        "key": "raw/newbookdev_newbookaccommodation_categories_channels/2024-11-04/1730783715/accommodation_categories_channels.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3530537553429368330,
        "service_name": "drive-thru",
        "span_id": 18093151838776922938,
        "trace_id": 4117827845863489254
    }
}

running: False
schema_name_id: 2414
start_time: 2024-11-05 02:04:48
success: True
trace_id: 4117827845863489254

Scan 6666997

duration: 0:00:11.440423

exit_message:

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

id: 6666997

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_categories_channels/2024-11-04/1730783626",
        "key": "raw/newbookdev_newbookaccommodation_categories_channels/2024-11-04/1730783626/accommodation_categories_channels.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 180162381388422613,
        "service_name": "drive-thru",
        "span_id": 3775299955288827862,
        "trace_id": 6758448653263310108
    }
}

running: False
schema_name_id: 2414
start_time: 2024-11-05 01:52:36
success: True
trace_id: 6758448653263310108

Scan 6665615

duration: 0:00:11.736489

exit_message:

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

id: 6665615

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_categories_channels/2024-11-04/1730783471",
        "key": "raw/newbookdev_newbookaccommodation_categories_channels/2024-11-04/1730783471/accommodation_categories_channels.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15850767178557433889,
        "service_name": "drive-thru",
        "span_id": 10475295827067678515,
        "trace_id": 11906092633936852322
    }
}

running: False
schema_name_id: 2414
start_time: 2024-11-05 01:16:15
success: True
trace_id: 11906092633936852322

Scan 6665316

duration: 0:00:13.973581

exit_message:

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

id: 6665316

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_categories_channels/2024-11-04/1730783253",
        "key": "raw/newbookdev_newbookaccommodation_categories_channels/2024-11-04/1730783253/accommodation_categories_channels.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13671411596454855484,
        "service_name": "drive-thru",
        "span_id": 15211830400802472032,
        "trace_id": 12528331646018706782
    }
}

running: False
schema_name_id: 2414
start_time: 2024-11-05 01:08:20
success: True
trace_id: 12528331646018706782

Scan 6664216

duration: 0:00:11.464473

exit_message:

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

id: 6664216

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_categories_channels/2024-11-04/1730782855",
        "key": "raw/newbookdev_newbookaccommodation_categories_channels/2024-11-04/1730782855/accommodation_categories_channels.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12821578443785064722,
        "service_name": "drive-thru",
        "span_id": 13995430135733392104,
        "trace_id": 4105363577932807245
    }
}

running: False
schema_name_id: 2414
start_time: 2024-11-05 00:39:14
success: True
trace_id: 4105363577932807245

Scan 6663973

duration: 0:00:11.340475

exit_message:

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

id: 6663973

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_categories_channels/2024-11-04/1730782767",
        "key": "raw/newbookdev_newbookaccommodation_categories_channels/2024-11-04/1730782767/accommodation_categories_channels.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16857553836375211269,
        "service_name": "drive-thru",
        "span_id": 13144827709976538486,
        "trace_id": 15885716761192557566
    }
}

running: False
schema_name_id: 2414
start_time: 2024-11-05 00:32:51
success: True
trace_id: 15885716761192557566

Partitions:

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

Schema:

attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "category_id": "string",
    "cm_roomcode": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

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

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_categories_channels`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `cm_roomcode`  string , `cm_settings`  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_newbookaccommodation_categories_channels/2024-11-05/1730866343'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels"
}

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:37:21",
        "disabled": false,
        "format": "raw",
        "id": 2414,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookaccommodation_categories_channels"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "active": "string",
            "booking_channel_id": "string",
            "category_id": "string",
            "cm_roomcode": "string",
            "cm_settings": "string",
            "direct_channel_manager_id": "string",
            "id": "string",
            "newbook_region": "string",
            "tenant": "string"
        },
        "created": "2024-11-05 22:31:42",
        "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_categories_channels`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `cm_roomcode`  string , `cm_settings`  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_newbookaccommodation_categories_channels/2024-11-05/1730866343'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_channels"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}