Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions

created: 2024-10-08 18:33:57
disabled: False
format: raw
id: 3043
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749458

created: 2024-11-05 23:53:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `email`  string , `account_id`  string , `priority`  string , `auto_replies`  string , `manual_replies`  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_newbooktickets_emails_exceptions/2024-11-05/1730866621'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_emails_exceptions/2024-11-05/1730866621
id: 4749458
processed: 1

raw_data:

{
    "account_id": 4,
    "active": 8,
    "auto_replies": 6,
    "email": 3,
    "id": 2,
    "manual_replies": 7,
    "newbook_region": 0,
    "priority": 5,
    "tenant": 1
}

schema_attributes:

{
    "account_id": "string",
    "active": "string",
    "auto_replies": "string",
    "email": "string",
    "id": "string",
    "manual_replies": "string",
    "newbook_region": "string",
    "priority": "string",
    "tenant": "string"
}

schema_name_id: 3043
schema_scan_id: 6675519
updated: 2024-11-05 23:53:24

Version 4749120

created: 2024-11-05 23:21:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `email`  string , `account_id`  string , `priority`  string , `auto_replies`  string , `manual_replies`  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_newbooktickets_emails_exceptions/2024-11-05/1730866578'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_emails_exceptions/2024-11-05/1730866578
id: 4749120
processed: 1

raw_data:

{
    "account_id": 4,
    "active": 8,
    "auto_replies": 6,
    "email": 3,
    "id": 2,
    "manual_replies": 7,
    "newbook_region": 0,
    "priority": 5,
    "tenant": 1
}

schema_attributes:

{
    "account_id": "string",
    "active": "string",
    "auto_replies": "string",
    "email": "string",
    "id": "string",
    "manual_replies": "string",
    "newbook_region": "string",
    "priority": "string",
    "tenant": "string"
}

schema_name_id: 3043
schema_scan_id: 6675152
updated: 2024-11-05 23:21:51

Version 4748720

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `email`  string , `account_id`  string , `priority`  string , `auto_replies`  string , `manual_replies`  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_newbooktickets_emails_exceptions/2024-11-05/1730866479'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_emails_exceptions/2024-11-05/1730866479
id: 4748720
processed: 1

raw_data:

{
    "account_id": 4,
    "active": 8,
    "auto_replies": 6,
    "email": 3,
    "id": 2,
    "manual_replies": 7,
    "newbook_region": 0,
    "priority": 5,
    "tenant": 1
}

schema_attributes:

{
    "account_id": "string",
    "active": "string",
    "auto_replies": "string",
    "email": "string",
    "id": "string",
    "manual_replies": "string",
    "newbook_region": "string",
    "priority": "string",
    "tenant": "string"
}

schema_name_id: 3043
schema_scan_id: 6674752
updated: 2024-11-05 22:58:09

Version 4747186

created: 2024-11-05 04:59:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `email`  string , `account_id`  string , `priority`  string , `auto_replies`  string , `manual_replies`  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_newbooktickets_emails_exceptions/2024-11-04/1730785819'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_emails_exceptions/2024-11-04/1730785819
id: 4747186
processed: 1

raw_data:

{
    "account_id": 4,
    "active": 8,
    "auto_replies": 6,
    "email": 3,
    "id": 2,
    "manual_replies": 7,
    "newbook_region": 0,
    "priority": 5,
    "tenant": 1
}

schema_attributes:

{
    "account_id": "string",
    "active": "string",
    "auto_replies": "string",
    "email": "string",
    "id": "string",
    "manual_replies": "string",
    "newbook_region": "string",
    "priority": "string",
    "tenant": "string"
}

schema_name_id: 3043
schema_scan_id: 6672418
updated: 2024-11-05 04:59:48

Version 4746544

created: 2024-11-05 04:08:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `email`  string , `account_id`  string , `priority`  string , `auto_replies`  string , `manual_replies`  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_newbooktickets_emails_exceptions/2024-11-04/1730785179'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_emails_exceptions/2024-11-04/1730785179
id: 4746544
processed: 1

raw_data:

{
    "account_id": 4,
    "active": 8,
    "auto_replies": 6,
    "email": 3,
    "id": 2,
    "manual_replies": 7,
    "newbook_region": 0,
    "priority": 5,
    "tenant": 1
}

schema_attributes:

{
    "account_id": "string",
    "active": "string",
    "auto_replies": "string",
    "email": "string",
    "id": "string",
    "manual_replies": "string",
    "newbook_region": "string",
    "priority": "string",
    "tenant": "string"
}

schema_name_id: 3043
schema_scan_id: 6671767
updated: 2024-11-05 04:08:54

Version 4745712

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `email`  string , `account_id`  string , `priority`  string , `auto_replies`  string , `manual_replies`  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_newbooktickets_emails_exceptions/2024-11-04/1730784874'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_emails_exceptions/2024-11-04/1730784874
id: 4745712
processed: 1

raw_data:

{
    "account_id": 4,
    "active": 8,
    "auto_replies": 6,
    "email": 3,
    "id": 2,
    "manual_replies": 7,
    "newbook_region": 0,
    "priority": 5,
    "tenant": 1
}

schema_attributes:

{
    "account_id": "string",
    "active": "string",
    "auto_replies": "string",
    "email": "string",
    "id": "string",
    "manual_replies": "string",
    "newbook_region": "string",
    "priority": "string",
    "tenant": "string"
}

schema_name_id: 3043
schema_scan_id: 6670929
updated: 2024-11-05 03:36:48

Version 4745581

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `email`  string , `account_id`  string , `priority`  string , `auto_replies`  string , `manual_replies`  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_newbooktickets_emails_exceptions/2024-11-04/1730784270'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_emails_exceptions/2024-11-04/1730784270
id: 4745581
processed: 1

raw_data:

{
    "account_id": 4,
    "active": 8,
    "auto_replies": 6,
    "email": 3,
    "id": 2,
    "manual_replies": 7,
    "newbook_region": 0,
    "priority": 5,
    "tenant": 1
}

schema_attributes:

{
    "account_id": "string",
    "active": "string",
    "auto_replies": "string",
    "email": "string",
    "id": "string",
    "manual_replies": "string",
    "newbook_region": "string",
    "priority": "string",
    "tenant": "string"
}

schema_name_id: 3043
schema_scan_id: 6670798
updated: 2024-11-05 03:33:23

Version 4744189

created: 2024-11-05 02:56:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `email`  string , `account_id`  string , `priority`  string , `auto_replies`  string , `manual_replies`  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_newbooktickets_emails_exceptions/2024-11-04/1730784109'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_emails_exceptions/2024-11-04/1730784109
id: 4744189
processed: 1

raw_data:

{
    "account_id": 4,
    "active": 8,
    "auto_replies": 6,
    "email": 3,
    "id": 2,
    "manual_replies": 7,
    "newbook_region": 0,
    "priority": 5,
    "tenant": 1
}

schema_attributes:

{
    "account_id": "string",
    "active": "string",
    "auto_replies": "string",
    "email": "string",
    "id": "string",
    "manual_replies": "string",
    "newbook_region": "string",
    "priority": "string",
    "tenant": "string"
}

schema_name_id: 3043
schema_scan_id: 6669406
updated: 2024-11-05 02:56:33

Version 4743868

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `email`  string , `account_id`  string , `priority`  string , `auto_replies`  string , `manual_replies`  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_newbooktickets_emails_exceptions/2024-11-04/1730783941'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_emails_exceptions/2024-11-04/1730783941
id: 4743868
processed: 1

raw_data:

{
    "account_id": 4,
    "active": 8,
    "auto_replies": 6,
    "email": 3,
    "id": 2,
    "manual_replies": 7,
    "newbook_region": 0,
    "priority": 5,
    "tenant": 1
}

schema_attributes:

{
    "account_id": "string",
    "active": "string",
    "auto_replies": "string",
    "email": "string",
    "id": "string",
    "manual_replies": "string",
    "newbook_region": "string",
    "priority": "string",
    "tenant": "string"
}

schema_name_id: 3043
schema_scan_id: 6669085
updated: 2024-11-05 02:48:09

Version 4742878

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `email`  string , `account_id`  string , `priority`  string , `auto_replies`  string , `manual_replies`  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_newbooktickets_emails_exceptions/2024-11-04/1730783822'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_emails_exceptions/2024-11-04/1730783822
id: 4742878
processed: 1

raw_data:

{
    "account_id": 4,
    "active": 8,
    "auto_replies": 6,
    "email": 3,
    "id": 2,
    "manual_replies": 7,
    "newbook_region": 0,
    "priority": 5,
    "tenant": 1
}

schema_attributes:

{
    "account_id": "string",
    "active": "string",
    "auto_replies": "string",
    "email": "string",
    "id": "string",
    "manual_replies": "string",
    "newbook_region": "string",
    "priority": "string",
    "tenant": "string"
}

schema_name_id: 3043
schema_scan_id: 6668095
updated: 2024-11-05 02:21:58

Version 4742211

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `email`  string , `account_id`  string , `priority`  string , `auto_replies`  string , `manual_replies`  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_newbooktickets_emails_exceptions/2024-11-04/1730783706'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_emails_exceptions/2024-11-04/1730783706
id: 4742211
processed: 1

raw_data:

{
    "account_id": 4,
    "active": 8,
    "auto_replies": 6,
    "email": 3,
    "id": 2,
    "manual_replies": 7,
    "newbook_region": 0,
    "priority": 5,
    "tenant": 1
}

schema_attributes:

{
    "account_id": "string",
    "active": "string",
    "auto_replies": "string",
    "email": "string",
    "id": "string",
    "manual_replies": "string",
    "newbook_region": "string",
    "priority": "string",
    "tenant": "string"
}

schema_name_id: 3043
schema_scan_id: 6667428
updated: 2024-11-05 02:04:19

Version 4741565

created: 2024-11-05 01:46:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `email`  string , `account_id`  string , `priority`  string , `auto_replies`  string , `manual_replies`  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_newbooktickets_emails_exceptions/2024-11-04/1730783579'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_emails_exceptions/2024-11-04/1730783579
id: 4741565
processed: 1

raw_data:

{
    "account_id": 4,
    "active": 8,
    "auto_replies": 6,
    "email": 3,
    "id": 2,
    "manual_replies": 7,
    "newbook_region": 0,
    "priority": 5,
    "tenant": 1
}

schema_attributes:

{
    "account_id": "string",
    "active": "string",
    "auto_replies": "string",
    "email": "string",
    "id": "string",
    "manual_replies": "string",
    "newbook_region": "string",
    "priority": "string",
    "tenant": "string"
}

schema_name_id: 3043
schema_scan_id: 6666782
updated: 2024-11-05 01:47:09

Version 4740719

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `email`  string , `account_id`  string , `priority`  string , `auto_replies`  string , `manual_replies`  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_newbooktickets_emails_exceptions/2024-11-04/1730783361'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_emails_exceptions/2024-11-04/1730783361
id: 4740719
processed: 1

raw_data:

{
    "account_id": 4,
    "active": 8,
    "auto_replies": 6,
    "email": 3,
    "id": 2,
    "manual_replies": 7,
    "newbook_region": 0,
    "priority": 5,
    "tenant": 1
}

schema_attributes:

{
    "account_id": "string",
    "active": "string",
    "auto_replies": "string",
    "email": "string",
    "id": "string",
    "manual_replies": "string",
    "newbook_region": "string",
    "priority": "string",
    "tenant": "string"
}

schema_name_id: 3043
schema_scan_id: 6665936
updated: 2024-11-05 01:24:51

Version 4740012

created: 2024-11-05 01:06:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `email`  string , `account_id`  string , `priority`  string , `auto_replies`  string , `manual_replies`  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_newbooktickets_emails_exceptions/2024-11-04/1730782959'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_emails_exceptions/2024-11-04/1730782959
id: 4740012
processed: 1

raw_data:

{
    "account_id": 4,
    "active": 8,
    "auto_replies": 6,
    "email": 3,
    "id": 2,
    "manual_replies": 7,
    "newbook_region": 0,
    "priority": 5,
    "tenant": 1
}

schema_attributes:

{
    "account_id": "string",
    "active": "string",
    "auto_replies": "string",
    "email": "string",
    "id": "string",
    "manual_replies": "string",
    "newbook_region": "string",
    "priority": "string",
    "tenant": "string"
}

schema_name_id: 3043
schema_scan_id: 6665229
updated: 2024-11-05 01:06:14

Version 4739277

created: 2024-11-05 00:46:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `email`  string , `account_id`  string , `priority`  string , `auto_replies`  string , `manual_replies`  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_newbooktickets_emails_exceptions/2024-11-04/1730782846'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_emails_exceptions/2024-11-04/1730782846
id: 4739277
processed: 1

raw_data:

{
    "account_id": 4,
    "active": 8,
    "auto_replies": 6,
    "email": 3,
    "id": 2,
    "manual_replies": 7,
    "newbook_region": 0,
    "priority": 5,
    "tenant": 1
}

schema_attributes:

{
    "account_id": "string",
    "active": "string",
    "auto_replies": "string",
    "email": "string",
    "id": "string",
    "manual_replies": "string",
    "newbook_region": "string",
    "priority": "string",
    "tenant": "string"
}

schema_name_id: 3043
schema_scan_id: 6664492
updated: 2024-11-05 00:46:41

Schema Scans: 15

Last at 2024-11-05 23:53:12

Scan 6675519

duration: 0:00:11.582108

exit_message:

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

id: 6675519

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_newbooktickets_emails_exceptions/2024-11-05/1730866621",
        "key": "raw/newbookdev_newbooktickets_emails_exceptions/2024-11-05/1730866621/tickets_emails_exceptions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1962881863171480651,
        "service_name": "drive-thru",
        "span_id": 4976059070277249718,
        "trace_id": 14926907664810777817
    }
}

running: False
schema_name_id: 3043
start_time: 2024-11-05 23:53:12
success: True
trace_id: 14926907664810777817

Scan 6675152

duration: 0:00:14.119638

exit_message:

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

id: 6675152

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_newbooktickets_emails_exceptions/2024-11-05/1730866578",
        "key": "raw/newbookdev_newbooktickets_emails_exceptions/2024-11-05/1730866578/tickets_emails_exceptions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5332207412463780164,
        "service_name": "drive-thru",
        "span_id": 11471894283250211090,
        "trace_id": 11070840375934156937
    }
}

running: False
schema_name_id: 3043
start_time: 2024-11-05 23:21:37
success: True
trace_id: 11070840375934156937

Scan 6674752

duration: 0:00:11.623449

exit_message:

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

id: 6674752

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_newbooktickets_emails_exceptions/2024-11-05/1730866479",
        "key": "raw/newbookdev_newbooktickets_emails_exceptions/2024-11-05/1730866479/tickets_emails_exceptions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7267671463746106047,
        "service_name": "drive-thru",
        "span_id": 16047188375704939312,
        "trace_id": 11534052427729617128
    }
}

running: False
schema_name_id: 3043
start_time: 2024-11-05 22:57:58
success: True
trace_id: 11534052427729617128

Scan 6672418

duration: 0:00:14.086141

exit_message:

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

id: 6672418

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_newbooktickets_emails_exceptions/2024-11-04/1730785819",
        "key": "raw/newbookdev_newbooktickets_emails_exceptions/2024-11-04/1730785819/tickets_emails_exceptions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 763320510471207590,
        "service_name": "drive-thru",
        "span_id": 14055244140808582872,
        "trace_id": 8365118802548017471
    }
}

running: False
schema_name_id: 3043
start_time: 2024-11-05 04:59:34
success: True
trace_id: 8365118802548017471

Scan 6671767

duration: 0:00:14.082110

exit_message:

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

id: 6671767

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_newbooktickets_emails_exceptions/2024-11-04/1730785179",
        "key": "raw/newbookdev_newbooktickets_emails_exceptions/2024-11-04/1730785179/tickets_emails_exceptions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11009103828849457436,
        "service_name": "drive-thru",
        "span_id": 212953589434293105,
        "trace_id": 6941337826262439322
    }
}

running: False
schema_name_id: 3043
start_time: 2024-11-05 04:08:40
success: True
trace_id: 6941337826262439322

Scan 6670929

duration: 0:00:11.325354

exit_message:

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

id: 6670929

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_newbooktickets_emails_exceptions/2024-11-04/1730784874",
        "key": "raw/newbookdev_newbooktickets_emails_exceptions/2024-11-04/1730784874/tickets_emails_exceptions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18103498325943100866,
        "service_name": "drive-thru",
        "span_id": 2296192488501743820,
        "trace_id": 510395802909761707
    }
}

running: False
schema_name_id: 3043
start_time: 2024-11-05 03:36:37
success: True
trace_id: 510395802909761707

Scan 6670798

duration: 0:00:11.610479

exit_message:

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

id: 6670798

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_newbooktickets_emails_exceptions/2024-11-04/1730784270",
        "key": "raw/newbookdev_newbooktickets_emails_exceptions/2024-11-04/1730784270/tickets_emails_exceptions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14406303796302927098,
        "service_name": "drive-thru",
        "span_id": 2623704259384032185,
        "trace_id": 7940464649937817956
    }
}

running: False
schema_name_id: 3043
start_time: 2024-11-05 03:33:11
success: True
trace_id: 7940464649937817956

Scan 6669406

duration: 0:00:11.476146

exit_message:

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

id: 6669406

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_newbooktickets_emails_exceptions/2024-11-04/1730784109",
        "key": "raw/newbookdev_newbooktickets_emails_exceptions/2024-11-04/1730784109/tickets_emails_exceptions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7910513529065625484,
        "service_name": "drive-thru",
        "span_id": 6363031426181917496,
        "trace_id": 5041300381330810548
    }
}

running: False
schema_name_id: 3043
start_time: 2024-11-05 02:56:21
success: True
trace_id: 5041300381330810548

Scan 6669085

duration: 0:00:11.529758

exit_message:

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

id: 6669085

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_newbooktickets_emails_exceptions/2024-11-04/1730783941",
        "key": "raw/newbookdev_newbooktickets_emails_exceptions/2024-11-04/1730783941/tickets_emails_exceptions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7813560050674965903,
        "service_name": "drive-thru",
        "span_id": 575467294175144148,
        "trace_id": 2838074614051206752
    }
}

running: False
schema_name_id: 3043
start_time: 2024-11-05 02:47:58
success: True
trace_id: 2838074614051206752

Scan 6668095

duration: 0:00:11.416351

exit_message:

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

id: 6668095

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_newbooktickets_emails_exceptions/2024-11-04/1730783822",
        "key": "raw/newbookdev_newbooktickets_emails_exceptions/2024-11-04/1730783822/tickets_emails_exceptions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4168370719253725787,
        "service_name": "drive-thru",
        "span_id": 5118436581153737134,
        "trace_id": 13074763441791727146
    }
}

running: False
schema_name_id: 3043
start_time: 2024-11-05 02:21:46
success: True
trace_id: 13074763441791727146

Scan 6667428

duration: 0:00:13.993201

exit_message:

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

id: 6667428

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_newbooktickets_emails_exceptions/2024-11-04/1730783706",
        "key": "raw/newbookdev_newbooktickets_emails_exceptions/2024-11-04/1730783706/tickets_emails_exceptions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4219271096483544102,
        "service_name": "drive-thru",
        "span_id": 5330818259542343469,
        "trace_id": 12167813978909052713
    }
}

running: False
schema_name_id: 3043
start_time: 2024-11-05 02:04:05
success: True
trace_id: 12167813978909052713

Scan 6666782

duration: 0:00:13.853151

exit_message:

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

id: 6666782

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_newbooktickets_emails_exceptions/2024-11-04/1730783579",
        "key": "raw/newbookdev_newbooktickets_emails_exceptions/2024-11-04/1730783579/tickets_emails_exceptions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2712671335871361539,
        "service_name": "drive-thru",
        "span_id": 3660729476047709026,
        "trace_id": 3784930876894549017
    }
}

running: False
schema_name_id: 3043
start_time: 2024-11-05 01:46:55
success: True
trace_id: 3784930876894549017

Scan 6665936

duration: 0:00:11.521200

exit_message:

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

id: 6665936

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_newbooktickets_emails_exceptions/2024-11-04/1730783361",
        "key": "raw/newbookdev_newbooktickets_emails_exceptions/2024-11-04/1730783361/tickets_emails_exceptions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8238877052793419685,
        "service_name": "drive-thru",
        "span_id": 16375257532582530234,
        "trace_id": 15183085128248847778
    }
}

running: False
schema_name_id: 3043
start_time: 2024-11-05 01:24:39
success: True
trace_id: 15183085128248847778

Scan 6665229

duration: 0:00:14.019056

exit_message:

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

id: 6665229

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_newbooktickets_emails_exceptions/2024-11-04/1730782959",
        "key": "raw/newbookdev_newbooktickets_emails_exceptions/2024-11-04/1730782959/tickets_emails_exceptions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12234896643108142729,
        "service_name": "drive-thru",
        "span_id": 6116826023000255239,
        "trace_id": 7220533954862140392
    }
}

running: False
schema_name_id: 3043
start_time: 2024-11-05 01:06:00
success: True
trace_id: 7220533954862140392

Scan 6664492

duration: 0:00:11.565575

exit_message:

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

id: 6664492

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_newbooktickets_emails_exceptions/2024-11-04/1730782846",
        "key": "raw/newbookdev_newbooktickets_emails_exceptions/2024-11-04/1730782846/tickets_emails_exceptions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1935129536713006092,
        "service_name": "drive-thru",
        "span_id": 14920356896334133953,
        "trace_id": 15812715048723395375
    }
}

running: False
schema_name_id: 3043
start_time: 2024-11-05 00:46:29
success: True
trace_id: 15812715048723395375

Partitions:

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

Schema:

attributes:

{
    "account_id": "string",
    "active": "string",
    "auto_replies": "string",
    "email": "string",
    "id": "string",
    "manual_replies": "string",
    "newbook_region": "string",
    "priority": "string",
    "tenant": "string"
}

created: 2024-11-05 23:53:13

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `email`  string , `account_id`  string , `priority`  string , `auto_replies`  string , `manual_replies`  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_newbooktickets_emails_exceptions/2024-11-05/1730866621'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions"
}

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:33:57",
        "disabled": false,
        "format": "raw",
        "id": 3043,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbooktickets_emails_exceptions"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "account_id": "string",
            "active": "string",
            "auto_replies": "string",
            "email": "string",
            "id": "string",
            "manual_replies": "string",
            "newbook_region": "string",
            "priority": "string",
            "tenant": "string"
        },
        "created": "2024-11-05 23:53:13",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `email`  string , `account_id`  string , `priority`  string , `auto_replies`  string , `manual_replies`  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_newbooktickets_emails_exceptions/2024-11-05/1730866621'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktickets_emails_exceptions"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}