Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookota_error_emails

created: 2024-10-08 18:07:03
disabled: False
format: raw
id: 2794
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749288

created: 2024-11-05 23:34:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookota_error_emails`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookota_error_emails`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_channel_manager_id`  string , `channel_response_message_md5`  string , `sent_when`  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_newbookota_error_emails/2024-11-05/1730866574'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookota_error_emails"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookota_error_emails/2024-11-05/1730866574
id: 4749288
processed: 1

raw_data:

{
    "channel_response_message_md5": 4,
    "id": 2,
    "instance_channel_manager_id": 3,
    "newbook_region": 0,
    "sent_when": 5,
    "tenant": 1
}

schema_attributes:

{
    "channel_response_message_md5": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "newbook_region": "string",
    "sent_when": "string",
    "tenant": "string"
}

schema_name_id: 2794
schema_scan_id: 6675320
updated: 2024-11-05 23:34:55

Version 4748823

created: 2024-11-05 23:03:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookota_error_emails`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookota_error_emails`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_channel_manager_id`  string , `channel_response_message_md5`  string , `sent_when`  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_newbookota_error_emails/2024-11-05/1730866516'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookota_error_emails"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookota_error_emails/2024-11-05/1730866516
id: 4748823
processed: 1

raw_data:

{
    "channel_response_message_md5": 4,
    "id": 2,
    "instance_channel_manager_id": 3,
    "newbook_region": 0,
    "sent_when": 5,
    "tenant": 1
}

schema_attributes:

{
    "channel_response_message_md5": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "newbook_region": "string",
    "sent_when": "string",
    "tenant": "string"
}

schema_name_id: 2794
schema_scan_id: 6674855
updated: 2024-11-05 23:03:38

Version 4748332

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookota_error_emails`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookota_error_emails`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_channel_manager_id`  string , `channel_response_message_md5`  string , `sent_when`  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_newbookota_error_emails/2024-11-05/1730866386'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookota_error_emails"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookota_error_emails/2024-11-05/1730866386
id: 4748332
processed: 1

raw_data:

{
    "channel_response_message_md5": 4,
    "id": 2,
    "instance_channel_manager_id": 3,
    "newbook_region": 0,
    "sent_when": 5,
    "tenant": 1
}

schema_attributes:

{
    "channel_response_message_md5": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "newbook_region": "string",
    "sent_when": "string",
    "tenant": "string"
}

schema_name_id: 2794
schema_scan_id: 6674364
updated: 2024-11-05 22:42:44

Version 4747218

created: 2024-11-05 05:03:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookota_error_emails`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookota_error_emails`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_channel_manager_id`  string , `channel_response_message_md5`  string , `sent_when`  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_newbookota_error_emails/2024-11-04/1730785772'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookota_error_emails"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookota_error_emails/2024-11-04/1730785772
id: 4747218
processed: 1

raw_data:

{
    "channel_response_message_md5": 4,
    "id": 2,
    "instance_channel_manager_id": 3,
    "newbook_region": 0,
    "sent_when": 5,
    "tenant": 1
}

schema_attributes:

{
    "channel_response_message_md5": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "newbook_region": "string",
    "sent_when": "string",
    "tenant": "string"
}

schema_name_id: 2794
schema_scan_id: 6672457
updated: 2024-11-05 05:03:23

Version 4746632

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookota_error_emails`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookota_error_emails`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_channel_manager_id`  string , `channel_response_message_md5`  string , `sent_when`  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_newbookota_error_emails/2024-11-04/1730785153'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookota_error_emails"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookota_error_emails/2024-11-04/1730785153
id: 4746632
processed: 1

raw_data:

{
    "channel_response_message_md5": 4,
    "id": 2,
    "instance_channel_manager_id": 3,
    "newbook_region": 0,
    "sent_when": 5,
    "tenant": 1
}

schema_attributes:

{
    "channel_response_message_md5": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "newbook_region": "string",
    "sent_when": "string",
    "tenant": "string"
}

schema_name_id: 2794
schema_scan_id: 6671855
updated: 2024-11-05 04:13:44

Version 4745637

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookota_error_emails`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookota_error_emails`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_channel_manager_id`  string , `channel_response_message_md5`  string , `sent_when`  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_newbookota_error_emails/2024-11-04/1730784848'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookota_error_emails"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookota_error_emails/2024-11-04/1730784848
id: 4745637
processed: 1

raw_data:

{
    "channel_response_message_md5": 4,
    "id": 2,
    "instance_channel_manager_id": 3,
    "newbook_region": 0,
    "sent_when": 5,
    "tenant": 1
}

schema_attributes:

{
    "channel_response_message_md5": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "newbook_region": "string",
    "sent_when": "string",
    "tenant": "string"
}

schema_name_id: 2794
schema_scan_id: 6670854
updated: 2024-11-05 03:34:51

Version 4745079

created: 2024-11-05 03:20:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookota_error_emails`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookota_error_emails`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_channel_manager_id`  string , `channel_response_message_md5`  string , `sent_when`  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_newbookota_error_emails/2024-11-04/1730784244'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookota_error_emails"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookota_error_emails/2024-11-04/1730784244
id: 4745079
processed: 1

raw_data:

{
    "channel_response_message_md5": 4,
    "id": 2,
    "instance_channel_manager_id": 3,
    "newbook_region": 0,
    "sent_when": 5,
    "tenant": 1
}

schema_attributes:

{
    "channel_response_message_md5": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "newbook_region": "string",
    "sent_when": "string",
    "tenant": "string"
}

schema_name_id: 2794
schema_scan_id: 6670296
updated: 2024-11-05 03:20:19

Version 4744574

created: 2024-11-05 03:06:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookota_error_emails`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookota_error_emails`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_channel_manager_id`  string , `channel_response_message_md5`  string , `sent_when`  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_newbookota_error_emails/2024-11-04/1730784082'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookota_error_emails"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookota_error_emails/2024-11-04/1730784082
id: 4744574
processed: 1

raw_data:

{
    "channel_response_message_md5": 4,
    "id": 2,
    "instance_channel_manager_id": 3,
    "newbook_region": 0,
    "sent_when": 5,
    "tenant": 1
}

schema_attributes:

{
    "channel_response_message_md5": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "newbook_region": "string",
    "sent_when": "string",
    "tenant": "string"
}

schema_name_id: 2794
schema_scan_id: 6669791
updated: 2024-11-05 03:06:57

Version 4743678

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookota_error_emails`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookota_error_emails`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_channel_manager_id`  string , `channel_response_message_md5`  string , `sent_when`  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_newbookota_error_emails/2024-11-04/1730783920'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookota_error_emails"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookota_error_emails/2024-11-04/1730783920
id: 4743678
processed: 1

raw_data:

{
    "channel_response_message_md5": 4,
    "id": 2,
    "instance_channel_manager_id": 3,
    "newbook_region": 0,
    "sent_when": 5,
    "tenant": 1
}

schema_attributes:

{
    "channel_response_message_md5": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "newbook_region": "string",
    "sent_when": "string",
    "tenant": "string"
}

schema_name_id: 2794
schema_scan_id: 6668895
updated: 2024-11-05 02:43:10

Version 4742762

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookota_error_emails`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookota_error_emails`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_channel_manager_id`  string , `channel_response_message_md5`  string , `sent_when`  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_newbookota_error_emails/2024-11-04/1730783795'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookota_error_emails"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookota_error_emails/2024-11-04/1730783795
id: 4742762
processed: 1

raw_data:

{
    "channel_response_message_md5": 4,
    "id": 2,
    "instance_channel_manager_id": 3,
    "newbook_region": 0,
    "sent_when": 5,
    "tenant": 1
}

schema_attributes:

{
    "channel_response_message_md5": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "newbook_region": "string",
    "sent_when": "string",
    "tenant": "string"
}

schema_name_id: 2794
schema_scan_id: 6667979
updated: 2024-11-05 02:18:56

Version 4741708

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookota_error_emails`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookota_error_emails`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_channel_manager_id`  string , `channel_response_message_md5`  string , `sent_when`  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_newbookota_error_emails/2024-11-04/1730783617'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookota_error_emails"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookota_error_emails/2024-11-04/1730783617
id: 4741708
processed: 1

raw_data:

{
    "channel_response_message_md5": 4,
    "id": 2,
    "instance_channel_manager_id": 3,
    "newbook_region": 0,
    "sent_when": 5,
    "tenant": 1
}

schema_attributes:

{
    "channel_response_message_md5": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "newbook_region": "string",
    "sent_when": "string",
    "tenant": "string"
}

schema_name_id: 2794
schema_scan_id: 6666925
updated: 2024-11-05 01:50:55

Version 4741385

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookota_error_emails`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookota_error_emails`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_channel_manager_id`  string , `channel_response_message_md5`  string , `sent_when`  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_newbookota_error_emails/2024-11-04/1730783552'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookota_error_emails"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookota_error_emails/2024-11-04/1730783552
id: 4741385
processed: 1

raw_data:

{
    "channel_response_message_md5": 4,
    "id": 2,
    "instance_channel_manager_id": 3,
    "newbook_region": 0,
    "sent_when": 5,
    "tenant": 1
}

schema_attributes:

{
    "channel_response_message_md5": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "newbook_region": "string",
    "sent_when": "string",
    "tenant": "string"
}

schema_name_id: 2794
schema_scan_id: 6666602
updated: 2024-11-05 01:42:22

Version 4740631

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookota_error_emails`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookota_error_emails`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_channel_manager_id`  string , `channel_response_message_md5`  string , `sent_when`  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_newbookota_error_emails/2024-11-04/1730783334'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookota_error_emails"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookota_error_emails/2024-11-04/1730783334
id: 4740631
processed: 1

raw_data:

{
    "channel_response_message_md5": 4,
    "id": 2,
    "instance_channel_manager_id": 3,
    "newbook_region": 0,
    "sent_when": 5,
    "tenant": 1
}

schema_attributes:

{
    "channel_response_message_md5": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "newbook_region": "string",
    "sent_when": "string",
    "tenant": "string"
}

schema_name_id: 2794
schema_scan_id: 6665848
updated: 2024-11-05 01:22:35

Version 4739690

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookota_error_emails`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookota_error_emails`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_channel_manager_id`  string , `channel_response_message_md5`  string , `sent_when`  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_newbookota_error_emails/2024-11-04/1730782933'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookota_error_emails"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookota_error_emails/2024-11-04/1730782933
id: 4739690
processed: 1

raw_data:

{
    "channel_response_message_md5": 4,
    "id": 2,
    "instance_channel_manager_id": 3,
    "newbook_region": 0,
    "sent_when": 5,
    "tenant": 1
}

schema_attributes:

{
    "channel_response_message_md5": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "newbook_region": "string",
    "sent_when": "string",
    "tenant": "string"
}

schema_name_id: 2794
schema_scan_id: 6664907
updated: 2024-11-05 00:57:30

Version 4738962

created: 2024-11-05 00:38:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookota_error_emails`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookota_error_emails`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_channel_manager_id`  string , `channel_response_message_md5`  string , `sent_when`  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_newbookota_error_emails/2024-11-04/1730782826'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookota_error_emails"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookota_error_emails/2024-11-04/1730782826
id: 4738962
processed: 1

raw_data:

{
    "channel_response_message_md5": 4,
    "id": 2,
    "instance_channel_manager_id": 3,
    "newbook_region": 0,
    "sent_when": 5,
    "tenant": 1
}

schema_attributes:

{
    "channel_response_message_md5": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "newbook_region": "string",
    "sent_when": "string",
    "tenant": "string"
}

schema_name_id: 2794
schema_scan_id: 6664176
updated: 2024-11-05 00:38:26

Schema Scans: 15

Last at 2024-11-05 23:34:44

Scan 6675320

duration: 0:00:11.397458

exit_message:

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

id: 6675320

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_newbookota_error_emails/2024-11-05/1730866574",
        "key": "raw/newbookdev_newbookota_error_emails/2024-11-05/1730866574/ota_error_emails.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookota_error_emails",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9877108266247834790,
        "service_name": "drive-thru",
        "span_id": 14639103499996596257,
        "trace_id": 9470657051030045601
    }
}

running: False
schema_name_id: 2794
start_time: 2024-11-05 23:34:44
success: True
trace_id: 9470657051030045601

Scan 6674855

duration: 0:00:11.534940

exit_message:

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

id: 6674855

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_newbookota_error_emails/2024-11-05/1730866516",
        "key": "raw/newbookdev_newbookota_error_emails/2024-11-05/1730866516/ota_error_emails.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookota_error_emails",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6987079169437976993,
        "service_name": "drive-thru",
        "span_id": 15180051510535147272,
        "trace_id": 7871877512208291899
    }
}

running: False
schema_name_id: 2794
start_time: 2024-11-05 23:03:26
success: True
trace_id: 7871877512208291899

Scan 6674364

duration: 0:00:11.487538

exit_message:

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

id: 6674364

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_newbookota_error_emails/2024-11-05/1730866386",
        "key": "raw/newbookdev_newbookota_error_emails/2024-11-05/1730866386/ota_error_emails.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookota_error_emails",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 478629049396311694,
        "service_name": "drive-thru",
        "span_id": 10507794096623850566,
        "trace_id": 11927808850042848599
    }
}

running: False
schema_name_id: 2794
start_time: 2024-11-05 22:42:32
success: True
trace_id: 11927808850042848599

Scan 6672457

duration: 0:00:11.457554

exit_message:

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

id: 6672457

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_newbookota_error_emails/2024-11-04/1730785772",
        "key": "raw/newbookdev_newbookota_error_emails/2024-11-04/1730785772/ota_error_emails.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookota_error_emails",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6204091060852335279,
        "service_name": "drive-thru",
        "span_id": 17518039269692208463,
        "trace_id": 6670983610114551568
    }
}

running: False
schema_name_id: 2794
start_time: 2024-11-05 05:03:12
success: True
trace_id: 6670983610114551568

Scan 6671855

duration: 0:00:11.432263

exit_message:

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

id: 6671855

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_newbookota_error_emails/2024-11-04/1730785153",
        "key": "raw/newbookdev_newbookota_error_emails/2024-11-04/1730785153/ota_error_emails.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookota_error_emails",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 285415783746877286,
        "service_name": "drive-thru",
        "span_id": 12910964704537437779,
        "trace_id": 10255519762785466776
    }
}

running: False
schema_name_id: 2794
start_time: 2024-11-05 04:13:33
success: True
trace_id: 10255519762785466776

Scan 6670854

duration: 0:00:11.436149

exit_message:

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

id: 6670854

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_newbookota_error_emails/2024-11-04/1730784848",
        "key": "raw/newbookdev_newbookota_error_emails/2024-11-04/1730784848/ota_error_emails.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookota_error_emails",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6255618004619915542,
        "service_name": "drive-thru",
        "span_id": 16792478633813320042,
        "trace_id": 2470340588283976756
    }
}

running: False
schema_name_id: 2794
start_time: 2024-11-05 03:34:40
success: True
trace_id: 2470340588283976756

Scan 6670296

duration: 0:00:14.089972

exit_message:

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

id: 6670296

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_newbookota_error_emails/2024-11-04/1730784244",
        "key": "raw/newbookdev_newbookota_error_emails/2024-11-04/1730784244/ota_error_emails.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookota_error_emails",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15804310077174718900,
        "service_name": "drive-thru",
        "span_id": 11257138918645806278,
        "trace_id": 3112722834531651338
    }
}

running: False
schema_name_id: 2794
start_time: 2024-11-05 03:20:06
success: True
trace_id: 3112722834531651338

Scan 6669791

duration: 0:00:13.955094

exit_message:

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

id: 6669791

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_newbookota_error_emails/2024-11-04/1730784082",
        "key": "raw/newbookdev_newbookota_error_emails/2024-11-04/1730784082/ota_error_emails.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookota_error_emails",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16395979389121454265,
        "service_name": "drive-thru",
        "span_id": 15062358308071051631,
        "trace_id": 4450170402950282855
    }
}

running: False
schema_name_id: 2794
start_time: 2024-11-05 03:06:43
success: True
trace_id: 4450170402950282855

Scan 6668895

duration: 0:00:13.993877

exit_message:

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

id: 6668895

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_newbookota_error_emails/2024-11-04/1730783920",
        "key": "raw/newbookdev_newbookota_error_emails/2024-11-04/1730783920/ota_error_emails.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookota_error_emails",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5974075044939642709,
        "service_name": "drive-thru",
        "span_id": 13283544649605443758,
        "trace_id": 9512622219533920904
    }
}

running: False
schema_name_id: 2794
start_time: 2024-11-05 02:42:57
success: True
trace_id: 9512622219533920904

Scan 6667979

duration: 0:00:11.485110

exit_message:

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

id: 6667979

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_newbookota_error_emails/2024-11-04/1730783795",
        "key": "raw/newbookdev_newbookota_error_emails/2024-11-04/1730783795/ota_error_emails.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookota_error_emails",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 469765841764831712,
        "service_name": "drive-thru",
        "span_id": 17057905762084850732,
        "trace_id": 826533917350378924
    }
}

running: False
schema_name_id: 2794
start_time: 2024-11-05 02:18:44
success: True
trace_id: 826533917350378924

Scan 6666925

duration: 0:00:13.877920

exit_message:

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

id: 6666925

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_newbookota_error_emails/2024-11-04/1730783617",
        "key": "raw/newbookdev_newbookota_error_emails/2024-11-04/1730783617/ota_error_emails.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookota_error_emails",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10085938926612306088,
        "service_name": "drive-thru",
        "span_id": 12500610600007776752,
        "trace_id": 6286243396254882073
    }
}

running: False
schema_name_id: 2794
start_time: 2024-11-05 01:50:41
success: True
trace_id: 6286243396254882073

Scan 6666602

duration: 0:00:11.412415

exit_message:

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

id: 6666602

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_newbookota_error_emails/2024-11-04/1730783552",
        "key": "raw/newbookdev_newbookota_error_emails/2024-11-04/1730783552/ota_error_emails.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookota_error_emails",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5891760913428721367,
        "service_name": "drive-thru",
        "span_id": 14157826588007821491,
        "trace_id": 1791243747985059429
    }
}

running: False
schema_name_id: 2794
start_time: 2024-11-05 01:42:11
success: True
trace_id: 1791243747985059429

Scan 6665848

duration: 0:00:11.387926

exit_message:

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

id: 6665848

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_newbookota_error_emails/2024-11-04/1730783334",
        "key": "raw/newbookdev_newbookota_error_emails/2024-11-04/1730783334/ota_error_emails.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookota_error_emails",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6485810837392279955,
        "service_name": "drive-thru",
        "span_id": 10117982862956236452,
        "trace_id": 11501354524304145925
    }
}

running: False
schema_name_id: 2794
start_time: 2024-11-05 01:22:23
success: True
trace_id: 11501354524304145925

Scan 6664907

duration: 0:00:11.306001

exit_message:

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

id: 6664907

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_newbookota_error_emails/2024-11-04/1730782933",
        "key": "raw/newbookdev_newbookota_error_emails/2024-11-04/1730782933/ota_error_emails.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookota_error_emails",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7806532376062109901,
        "service_name": "drive-thru",
        "span_id": 13427276712325097062,
        "trace_id": 12502923370730001028
    }
}

running: False
schema_name_id: 2794
start_time: 2024-11-05 00:57:19
success: True
trace_id: 12502923370730001028

Scan 6664176

duration: 0:00:14.049718

exit_message:

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

id: 6664176

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_newbookota_error_emails/2024-11-04/1730782826",
        "key": "raw/newbookdev_newbookota_error_emails/2024-11-04/1730782826/ota_error_emails.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookota_error_emails",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4375326965704121479,
        "service_name": "drive-thru",
        "span_id": 6944327369884239591,
        "trace_id": 2417627430054517290
    }
}

running: False
schema_name_id: 2794
start_time: 2024-11-05 00:38:12
success: True
trace_id: 2417627430054517290

Partitions:

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

Schema:

attributes:

{
    "channel_response_message_md5": "string",
    "id": "string",
    "instance_channel_manager_id": "string",
    "newbook_region": "string",
    "sent_when": "string",
    "tenant": "string"
}

created: 2024-11-05 23:34:44

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookota_error_emails`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_channel_manager_id`  string , `channel_response_message_md5`  string , `sent_when`  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_newbookota_error_emails/2024-11-05/1730866574'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookota_error_emails`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookota_error_emails"
}

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 18:07:03",
        "disabled": false,
        "format": "raw",
        "id": 2794,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookota_error_emails"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "channel_response_message_md5": "string",
            "id": "string",
            "instance_channel_manager_id": "string",
            "newbook_region": "string",
            "sent_when": "string",
            "tenant": "string"
        },
        "created": "2024-11-05 23:34:44",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookota_error_emails`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_channel_manager_id`  string , `channel_response_message_md5`  string , `sent_when`  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_newbookota_error_emails/2024-11-05/1730866574'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookota_error_emails`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookota_error_emails"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}