Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings

created: 2024-10-08 17:44:10
disabled: False
format: raw
id: 2508
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748126

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `type`  string , `type_id`  string , `cm_code`  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_newbookchannel_manager_mappings/2024-11-05/1730866400'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchannel_manager_mappings/2024-11-05/1730866400
id: 4748126
processed: 1

raw_data:

{
    "active": 9,
    "booking_channel_id": 4,
    "cm_code": 7,
    "cm_settings": 8,
    "direct_channel_manager_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 5,
    "type_id": 6
}

schema_attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "cm_code": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2508
schema_scan_id: 6674158
updated: 2024-11-05 22:35:48

Version 4747729

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `type`  string , `type_id`  string , `cm_code`  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_newbookchannel_manager_mappings/2024-11-05/1730866328'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchannel_manager_mappings/2024-11-05/1730866328
id: 4747729
processed: 1

raw_data:

{
    "active": 9,
    "booking_channel_id": 4,
    "cm_code": 7,
    "cm_settings": 8,
    "direct_channel_manager_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 5,
    "type_id": 6
}

schema_attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "cm_code": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2508
schema_scan_id: 6673761
updated: 2024-11-05 22:24:38

Version 4747440

created: 2024-11-05 22:16:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `type`  string , `type_id`  string , `cm_code`  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_newbookchannel_manager_mappings/2024-11-05/1730866247'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchannel_manager_mappings/2024-11-05/1730866247
id: 4747440
processed: 1

raw_data:

{
    "active": 9,
    "booking_channel_id": 4,
    "cm_code": 7,
    "cm_settings": 8,
    "direct_channel_manager_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 5,
    "type_id": 6
}

schema_attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "cm_code": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2508
schema_scan_id: 6673472
updated: 2024-11-05 22:16:56

Version 4746622

created: 2024-11-05 04:12:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `type`  string , `type_id`  string , `cm_code`  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_newbookchannel_manager_mappings/2024-11-04/1730785666'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchannel_manager_mappings/2024-11-04/1730785666
id: 4746622
processed: 1

raw_data:

{
    "active": 9,
    "booking_channel_id": 4,
    "cm_code": 7,
    "cm_settings": 8,
    "direct_channel_manager_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 5,
    "type_id": 6
}

schema_attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "cm_code": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2508
schema_scan_id: 6671845
updated: 2024-11-05 04:13:12

Version 4745739

created: 2024-11-05 03:37:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `type`  string , `type_id`  string , `cm_code`  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_newbookchannel_manager_mappings/2024-11-04/1730784787'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchannel_manager_mappings/2024-11-04/1730784787
id: 4745739
processed: 1

raw_data:

{
    "active": 9,
    "booking_channel_id": 4,
    "cm_code": 7,
    "cm_settings": 8,
    "direct_channel_manager_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 5,
    "type_id": 6
}

schema_attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "cm_code": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2508
schema_scan_id: 6670956
updated: 2024-11-05 03:37:36

Version 4745286

created: 2024-11-05 03:25:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `type`  string , `type_id`  string , `cm_code`  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_newbookchannel_manager_mappings/2024-11-04/1730785092'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchannel_manager_mappings/2024-11-04/1730785092
id: 4745286
processed: 1

raw_data:

{
    "active": 9,
    "booking_channel_id": 4,
    "cm_code": 7,
    "cm_settings": 8,
    "direct_channel_manager_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 5,
    "type_id": 6
}

schema_attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "cm_code": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2508
schema_scan_id: 6670503
updated: 2024-11-05 03:25:42

Version 4743935

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `type`  string , `type_id`  string , `cm_code`  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_newbookchannel_manager_mappings/2024-11-04/1730784183'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchannel_manager_mappings/2024-11-04/1730784183
id: 4743935
processed: 1

raw_data:

{
    "active": 9,
    "booking_channel_id": 4,
    "cm_code": 7,
    "cm_settings": 8,
    "direct_channel_manager_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 5,
    "type_id": 6
}

schema_attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "cm_code": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2508
schema_scan_id: 6669152
updated: 2024-11-05 02:49:52

Version 4743758

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `type`  string , `type_id`  string , `cm_code`  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_newbookchannel_manager_mappings/2024-11-04/1730784021'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchannel_manager_mappings/2024-11-04/1730784021
id: 4743758
processed: 1

raw_data:

{
    "active": 9,
    "booking_channel_id": 4,
    "cm_code": 7,
    "cm_settings": 8,
    "direct_channel_manager_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 5,
    "type_id": 6
}

schema_attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "cm_code": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2508
schema_scan_id: 6668975
updated: 2024-11-05 02:45:13

Version 4743083

created: 2024-11-05 02:27:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `type`  string , `type_id`  string , `cm_code`  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_newbookchannel_manager_mappings/2024-11-04/1730783835'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchannel_manager_mappings/2024-11-04/1730783835
id: 4743083
processed: 1

raw_data:

{
    "active": 9,
    "booking_channel_id": 4,
    "cm_code": 7,
    "cm_settings": 8,
    "direct_channel_manager_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 5,
    "type_id": 6
}

schema_attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "cm_code": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2508
schema_scan_id: 6668300
updated: 2024-11-05 02:27:22

Version 4741815

created: 2024-11-05 01:53:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `type`  string , `type_id`  string , `cm_code`  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_newbookchannel_manager_mappings/2024-11-04/1730783734'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchannel_manager_mappings/2024-11-04/1730783734
id: 4741815
processed: 1

raw_data:

{
    "active": 9,
    "booking_channel_id": 4,
    "cm_code": 7,
    "cm_settings": 8,
    "direct_channel_manager_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 5,
    "type_id": 6
}

schema_attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "cm_code": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2508
schema_scan_id: 6667032
updated: 2024-11-05 01:53:43

Version 4741239

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `type`  string , `type_id`  string , `cm_code`  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_newbookchannel_manager_mappings/2024-11-04/1730783639'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchannel_manager_mappings/2024-11-04/1730783639
id: 4741239
processed: 1

raw_data:

{
    "active": 9,
    "booking_channel_id": 4,
    "cm_code": 7,
    "cm_settings": 8,
    "direct_channel_manager_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 5,
    "type_id": 6
}

schema_attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "cm_code": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2508
schema_scan_id: 6666456
updated: 2024-11-05 01:38:35

Version 4740973

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `type`  string , `type_id`  string , `cm_code`  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_newbookchannel_manager_mappings/2024-11-04/1730783489'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchannel_manager_mappings/2024-11-04/1730783489
id: 4740973
processed: 1

raw_data:

{
    "active": 9,
    "booking_channel_id": 4,
    "cm_code": 7,
    "cm_settings": 8,
    "direct_channel_manager_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 5,
    "type_id": 6
}

schema_attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "cm_code": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2508
schema_scan_id: 6666190
updated: 2024-11-05 01:31:38

Version 4740207

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `type`  string , `type_id`  string , `cm_code`  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_newbookchannel_manager_mappings/2024-11-04/1730783271'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchannel_manager_mappings/2024-11-04/1730783271
id: 4740207
processed: 1

raw_data:

{
    "active": 9,
    "booking_channel_id": 4,
    "cm_code": 7,
    "cm_settings": 8,
    "direct_channel_manager_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 5,
    "type_id": 6
}

schema_attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "cm_code": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2508
schema_scan_id: 6665424
updated: 2024-11-05 01:11:29

Version 4739434

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `type`  string , `type_id`  string , `cm_code`  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_newbookchannel_manager_mappings/2024-11-04/1730782873'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchannel_manager_mappings/2024-11-04/1730782873
id: 4739434
processed: 1

raw_data:

{
    "active": 9,
    "booking_channel_id": 4,
    "cm_code": 7,
    "cm_settings": 8,
    "direct_channel_manager_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 5,
    "type_id": 6
}

schema_attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "cm_code": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2508
schema_scan_id: 6664649
updated: 2024-11-05 00:50:43

Version 4738509

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `type`  string , `type_id`  string , `cm_code`  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_newbookchannel_manager_mappings/2024-11-04/1730782780'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchannel_manager_mappings/2024-11-04/1730782780
id: 4738509
processed: 1

raw_data:

{
    "active": 9,
    "booking_channel_id": 4,
    "cm_code": 7,
    "cm_settings": 8,
    "direct_channel_manager_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 5,
    "type_id": 6
}

schema_attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "cm_code": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2508
schema_scan_id: 6663720
updated: 2024-11-05 00:26:32

Schema Scans: 15

Last at 2024-11-05 22:35:36

Scan 6674158

duration: 0:00:11.651142

exit_message:

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

id: 6674158

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_newbookchannel_manager_mappings/2024-11-05/1730866400",
        "key": "raw/newbookdev_newbookchannel_manager_mappings/2024-11-05/1730866400/channel_manager_mappings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12712580745272023535,
        "service_name": "drive-thru",
        "span_id": 5565141007043004241,
        "trace_id": 1738596938838319678
    }
}

running: False
schema_name_id: 2508
start_time: 2024-11-05 22:35:36
success: True
trace_id: 1738596938838319678

Scan 6673761

duration: 0:00:11.501481

exit_message:

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

id: 6673761

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_newbookchannel_manager_mappings/2024-11-05/1730866328",
        "key": "raw/newbookdev_newbookchannel_manager_mappings/2024-11-05/1730866328/channel_manager_mappings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6065892413499432956,
        "service_name": "drive-thru",
        "span_id": 2031610914896597817,
        "trace_id": 1610064375801753942
    }
}

running: False
schema_name_id: 2508
start_time: 2024-11-05 22:24:26
success: True
trace_id: 1610064375801753942

Scan 6673472

duration: 0:00:11.556715

exit_message:

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

id: 6673472

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_newbookchannel_manager_mappings/2024-11-05/1730866247",
        "key": "raw/newbookdev_newbookchannel_manager_mappings/2024-11-05/1730866247/channel_manager_mappings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5339678421472478348,
        "service_name": "drive-thru",
        "span_id": 14230826137726298287,
        "trace_id": 6395103555991400871
    }
}

running: False
schema_name_id: 2508
start_time: 2024-11-05 22:16:44
success: True
trace_id: 6395103555991400871

Scan 6671845

duration: 0:00:14.243009

exit_message:

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

id: 6671845

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_newbookchannel_manager_mappings/2024-11-04/1730785666",
        "key": "raw/newbookdev_newbookchannel_manager_mappings/2024-11-04/1730785666/channel_manager_mappings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17444697001377863839,
        "service_name": "drive-thru",
        "span_id": 11906085026462632427,
        "trace_id": 2847162219463780337
    }
}

running: False
schema_name_id: 2508
start_time: 2024-11-05 04:12:57
success: True
trace_id: 2847162219463780337

Scan 6670956

duration: 0:00:11.575908

exit_message:

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

id: 6670956

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_newbookchannel_manager_mappings/2024-11-04/1730784787",
        "key": "raw/newbookdev_newbookchannel_manager_mappings/2024-11-04/1730784787/channel_manager_mappings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14022767016350109470,
        "service_name": "drive-thru",
        "span_id": 4355955264517882042,
        "trace_id": 9457003012179507644
    }
}

running: False
schema_name_id: 2508
start_time: 2024-11-05 03:37:24
success: True
trace_id: 9457003012179507644

Scan 6670503

duration: 0:00:11.478308

exit_message:

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

id: 6670503

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_newbookchannel_manager_mappings/2024-11-04/1730785092",
        "key": "raw/newbookdev_newbookchannel_manager_mappings/2024-11-04/1730785092/channel_manager_mappings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12669715190483370969,
        "service_name": "drive-thru",
        "span_id": 1083343329309506580,
        "trace_id": 88803881731532806
    }
}

running: False
schema_name_id: 2508
start_time: 2024-11-05 03:25:31
success: True
trace_id: 88803881731532806

Scan 6669152

duration: 0:00:11.499298

exit_message:

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

id: 6669152

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_newbookchannel_manager_mappings/2024-11-04/1730784183",
        "key": "raw/newbookdev_newbookchannel_manager_mappings/2024-11-04/1730784183/channel_manager_mappings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10018676212058135489,
        "service_name": "drive-thru",
        "span_id": 9692593540157008435,
        "trace_id": 6950282794697474385
    }
}

running: False
schema_name_id: 2508
start_time: 2024-11-05 02:49:41
success: True
trace_id: 6950282794697474385

Scan 6668975

duration: 0:00:11.547715

exit_message:

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

id: 6668975

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_newbookchannel_manager_mappings/2024-11-04/1730784021",
        "key": "raw/newbookdev_newbookchannel_manager_mappings/2024-11-04/1730784021/channel_manager_mappings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8755887908477907574,
        "service_name": "drive-thru",
        "span_id": 7866350720664731953,
        "trace_id": 529108573171709091
    }
}

running: False
schema_name_id: 2508
start_time: 2024-11-05 02:45:02
success: True
trace_id: 529108573171709091

Scan 6668300

duration: 0:00:11.489153

exit_message:

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

id: 6668300

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_newbookchannel_manager_mappings/2024-11-04/1730783835",
        "key": "raw/newbookdev_newbookchannel_manager_mappings/2024-11-04/1730783835/channel_manager_mappings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3272660840141217703,
        "service_name": "drive-thru",
        "span_id": 15779335073986066453,
        "trace_id": 2008138470718766828
    }
}

running: False
schema_name_id: 2508
start_time: 2024-11-05 02:27:11
success: True
trace_id: 2008138470718766828

Scan 6667032

duration: 0:00:11.516122

exit_message:

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

id: 6667032

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_newbookchannel_manager_mappings/2024-11-04/1730783734",
        "key": "raw/newbookdev_newbookchannel_manager_mappings/2024-11-04/1730783734/channel_manager_mappings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4599505114687844642,
        "service_name": "drive-thru",
        "span_id": 7403848672759002098,
        "trace_id": 17885213199831581102
    }
}

running: False
schema_name_id: 2508
start_time: 2024-11-05 01:53:31
success: True
trace_id: 17885213199831581102

Scan 6666456

duration: 0:00:11.501798

exit_message:

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

id: 6666456

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_newbookchannel_manager_mappings/2024-11-04/1730783639",
        "key": "raw/newbookdev_newbookchannel_manager_mappings/2024-11-04/1730783639/channel_manager_mappings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12085317928611840928,
        "service_name": "drive-thru",
        "span_id": 4794399730170296545,
        "trace_id": 9491297588900974749
    }
}

running: False
schema_name_id: 2508
start_time: 2024-11-05 01:38:24
success: True
trace_id: 9491297588900974749

Scan 6666190

duration: 0:00:14.013287

exit_message:

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

id: 6666190

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_newbookchannel_manager_mappings/2024-11-04/1730783489",
        "key": "raw/newbookdev_newbookchannel_manager_mappings/2024-11-04/1730783489/channel_manager_mappings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12697991595794006873,
        "service_name": "drive-thru",
        "span_id": 294894751820440010,
        "trace_id": 18321448374474877002
    }
}

running: False
schema_name_id: 2508
start_time: 2024-11-05 01:31:24
success: True
trace_id: 18321448374474877002

Scan 6665424

duration: 0:00:13.902867

exit_message:

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

id: 6665424

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_newbookchannel_manager_mappings/2024-11-04/1730783271",
        "key": "raw/newbookdev_newbookchannel_manager_mappings/2024-11-04/1730783271/channel_manager_mappings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16236639571891548357,
        "service_name": "drive-thru",
        "span_id": 8470516446758052217,
        "trace_id": 14448943911468201588
    }
}

running: False
schema_name_id: 2508
start_time: 2024-11-05 01:11:15
success: True
trace_id: 14448943911468201588

Scan 6664649

duration: 0:00:11.657262

exit_message:

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

id: 6664649

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_newbookchannel_manager_mappings/2024-11-04/1730782873",
        "key": "raw/newbookdev_newbookchannel_manager_mappings/2024-11-04/1730782873/channel_manager_mappings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8932610933058157452,
        "service_name": "drive-thru",
        "span_id": 2576936376741003465,
        "trace_id": 2784024643401331775
    }
}

running: False
schema_name_id: 2508
start_time: 2024-11-05 00:50:31
success: True
trace_id: 2784024643401331775

Scan 6663720

duration: 0:00:13.959175

exit_message:

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

id: 6663720

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_newbookchannel_manager_mappings/2024-11-04/1730782780",
        "key": "raw/newbookdev_newbookchannel_manager_mappings/2024-11-04/1730782780/channel_manager_mappings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9012395288487481339,
        "service_name": "drive-thru",
        "span_id": 5424156832619485639,
        "trace_id": 4078052275947091926
    }
}

running: False
schema_name_id: 2508
start_time: 2024-11-05 00:26:18
success: True
trace_id: 4078052275947091926

Partitions:

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

Schema:

attributes:

{
    "active": "string",
    "booking_channel_id": "string",
    "cm_code": "string",
    "cm_settings": "string",
    "direct_channel_manager_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `type`  string , `type_id`  string , `cm_code`  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_newbookchannel_manager_mappings/2024-11-05/1730866400'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings"
}

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:44:10",
        "disabled": false,
        "format": "raw",
        "id": 2508,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookchannel_manager_mappings"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "active": "string",
            "booking_channel_id": "string",
            "cm_code": "string",
            "cm_settings": "string",
            "direct_channel_manager_id": "string",
            "id": "string",
            "newbook_region": "string",
            "tenant": "string",
            "type": "string",
            "type_id": "string"
        },
        "created": "2024-11-05 22:35:37",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `direct_channel_manager_id`  string , `booking_channel_id`  string , `type`  string , `type_id`  string , `cm_code`  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_newbookchannel_manager_mappings/2024-11-05/1730866400'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_manager_mappings"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}