Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookcontact_emails_notifications

created: 2024-10-08 17:47:52
disabled: False
format: raw
id: 2560
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748499

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_emails_notifications/2024-11-05/1730866430
id: 4748499
processed: 1

raw_data:

{
    "email_action": 4,
    "email_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "email_action": "string",
    "email_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2560
schema_scan_id: 6674531
updated: 2024-11-05 22:48:49

Version 4748011

created: 2024-11-05 22:32:06

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_emails_notifications/2024-11-05/1730866348
id: 4748011
processed: 1

raw_data:

{
    "email_action": 4,
    "email_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "email_action": "string",
    "email_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2560
schema_scan_id: 6674043
updated: 2024-11-05 22:32:17

Version 4747518

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_emails_notifications/2024-11-05/1730866259
id: 4747518
processed: 1

raw_data:

{
    "email_action": 4,
    "email_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "email_action": "string",
    "email_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2560
schema_scan_id: 6673550
updated: 2024-11-05 22:19:11

Version 4746951

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_emails_notifications/2024-11-04/1730785680
id: 4746951
processed: 1

raw_data:

{
    "email_action": 4,
    "email_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "email_action": "string",
    "email_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2560
schema_scan_id: 6672182
updated: 2024-11-05 04:35:13

Version 4745474

created: 2024-11-05 03:30:21

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_emails_notifications/2024-11-04/1730784795
id: 4745474
processed: 1

raw_data:

{
    "email_action": 4,
    "email_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "email_action": "string",
    "email_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2560
schema_scan_id: 6670690
updated: 2024-11-05 03:30:35

Version 4745330

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_emails_notifications/2024-11-04/1730785100
id: 4745330
processed: 1

raw_data:

{
    "email_action": 4,
    "email_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "email_action": "string",
    "email_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2560
schema_scan_id: 6670547
updated: 2024-11-05 03:26:48

Version 4744028

created: 2024-11-05 02:52:10

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_emails_notifications/2024-11-04/1730784192
id: 4744028
processed: 1

raw_data:

{
    "email_action": 4,
    "email_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "email_action": "string",
    "email_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2560
schema_scan_id: 6669246
updated: 2024-11-05 02:52:21

Version 4743774

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_emails_notifications/2024-11-04/1730784029
id: 4743774
processed: 1

raw_data:

{
    "email_action": 4,
    "email_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "email_action": "string",
    "email_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2560
schema_scan_id: 6668991
updated: 2024-11-05 02:45:41

Version 4743325

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_emails_notifications/2024-11-04/1730783880
id: 4743325
processed: 1

raw_data:

{
    "email_action": 4,
    "email_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "email_action": "string",
    "email_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2560
schema_scan_id: 6668543
updated: 2024-11-05 02:33:49

Version 4742398

created: 2024-11-05 02:09:08

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_emails_notifications/2024-11-04/1730783742
id: 4742398
processed: 1

raw_data:

{
    "email_action": 4,
    "email_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "email_action": "string",
    "email_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2560
schema_scan_id: 6667615
updated: 2024-11-05 02:09:22

Version 4741917

created: 2024-11-05 01:56:14

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_emails_notifications/2024-11-04/1730783646
id: 4741917
processed: 1

raw_data:

{
    "email_action": 4,
    "email_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "email_action": "string",
    "email_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2560
schema_scan_id: 6667134
updated: 2024-11-05 01:56:24

Version 4740934

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_emails_notifications/2024-11-04/1730783498
id: 4740934
processed: 1

raw_data:

{
    "email_action": 4,
    "email_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "email_action": "string",
    "email_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2560
schema_scan_id: 6666151
updated: 2024-11-05 01:30:33

Version 4740142

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_emails_notifications/2024-11-04/1730783279
id: 4740142
processed: 1

raw_data:

{
    "email_action": 4,
    "email_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "email_action": "string",
    "email_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2560
schema_scan_id: 6665359
updated: 2024-11-05 01:09:43

Version 4739421

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_emails_notifications/2024-11-04/1730782882
id: 4739421
processed: 1

raw_data:

{
    "email_action": 4,
    "email_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "email_action": "string",
    "email_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2560
schema_scan_id: 6664636
updated: 2024-11-05 00:50:23

Version 4738751

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_emails_notifications/2024-11-04/1730782787
id: 4738751
processed: 1

raw_data:

{
    "email_action": 4,
    "email_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "email_action": "string",
    "email_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2560
schema_scan_id: 6663964
updated: 2024-11-05 00:32:51

Schema Scans: 15

Last at 2024-11-05 22:48:38

Scan 6674531

duration: 0:00:11.433208

exit_message:

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

id: 6674531

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_newbookcontact_emails_notifications/2024-11-05/1730866430",
        "key": "raw/newbookdev_newbookcontact_emails_notifications/2024-11-05/1730866430/contact_emails_notifications.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_emails_notifications",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5893057225274328410,
        "service_name": "drive-thru",
        "span_id": 16585027605110121399,
        "trace_id": 11070252833432895655
    }
}

running: False
schema_name_id: 2560
start_time: 2024-11-05 22:48:38
success: True
trace_id: 11070252833432895655

Scan 6674043

duration: 0:00:11.352374

exit_message:

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

id: 6674043

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_newbookcontact_emails_notifications/2024-11-05/1730866348",
        "key": "raw/newbookdev_newbookcontact_emails_notifications/2024-11-05/1730866348/contact_emails_notifications.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_emails_notifications",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6932686137151595723,
        "service_name": "drive-thru",
        "span_id": 2353808817878792161,
        "trace_id": 15756221344600824211
    }
}

running: False
schema_name_id: 2560
start_time: 2024-11-05 22:32:06
success: True
trace_id: 15756221344600824211

Scan 6673550

duration: 0:00:13.958876

exit_message:

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

id: 6673550

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_newbookcontact_emails_notifications/2024-11-05/1730866259",
        "key": "raw/newbookdev_newbookcontact_emails_notifications/2024-11-05/1730866259/contact_emails_notifications.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_emails_notifications",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 357521435688668553,
        "service_name": "drive-thru",
        "span_id": 15222163761968885730,
        "trace_id": 7364340209041389991
    }
}

running: False
schema_name_id: 2560
start_time: 2024-11-05 22:18:57
success: True
trace_id: 7364340209041389991

Scan 6672182

duration: 0:00:11.492733

exit_message:

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

id: 6672182

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_newbookcontact_emails_notifications/2024-11-04/1730785680",
        "key": "raw/newbookdev_newbookcontact_emails_notifications/2024-11-04/1730785680/contact_emails_notifications.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_emails_notifications",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3977834266756270401,
        "service_name": "drive-thru",
        "span_id": 11505453061524127255,
        "trace_id": 16778661525182085175
    }
}

running: False
schema_name_id: 2560
start_time: 2024-11-05 04:35:01
success: True
trace_id: 16778661525182085175

Scan 6670690

duration: 0:00:14.052874

exit_message:

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

id: 6670690

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_newbookcontact_emails_notifications/2024-11-04/1730784795",
        "key": "raw/newbookdev_newbookcontact_emails_notifications/2024-11-04/1730784795/contact_emails_notifications.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_emails_notifications",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3023421774404688089,
        "service_name": "drive-thru",
        "span_id": 6306707110565149592,
        "trace_id": 2891278330942489850
    }
}

running: False
schema_name_id: 2560
start_time: 2024-11-05 03:30:21
success: True
trace_id: 2891278330942489850

Scan 6670547

duration: 0:00:11.465834

exit_message:

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

id: 6670547

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_newbookcontact_emails_notifications/2024-11-04/1730785100",
        "key": "raw/newbookdev_newbookcontact_emails_notifications/2024-11-04/1730785100/contact_emails_notifications.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_emails_notifications",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 895713079967923550,
        "service_name": "drive-thru",
        "span_id": 9804726853347839608,
        "trace_id": 16109829862430044052
    }
}

running: False
schema_name_id: 2560
start_time: 2024-11-05 03:26:37
success: True
trace_id: 16109829862430044052

Scan 6669246

duration: 0:00:11.492595

exit_message:

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

id: 6669246

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_newbookcontact_emails_notifications/2024-11-04/1730784192",
        "key": "raw/newbookdev_newbookcontact_emails_notifications/2024-11-04/1730784192/contact_emails_notifications.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_emails_notifications",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6688447965528459133,
        "service_name": "drive-thru",
        "span_id": 2340807587441116235,
        "trace_id": 3555362143332020272
    }
}

running: False
schema_name_id: 2560
start_time: 2024-11-05 02:52:09
success: True
trace_id: 3555362143332020272

Scan 6668991

duration: 0:00:13.924677

exit_message:

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

id: 6668991

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_newbookcontact_emails_notifications/2024-11-04/1730784029",
        "key": "raw/newbookdev_newbookcontact_emails_notifications/2024-11-04/1730784029/contact_emails_notifications.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_emails_notifications",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3511446728795921832,
        "service_name": "drive-thru",
        "span_id": 16974928378312222671,
        "trace_id": 12888234857797252142
    }
}

running: False
schema_name_id: 2560
start_time: 2024-11-05 02:45:27
success: True
trace_id: 12888234857797252142

Scan 6668543

duration: 0:00:11.531724

exit_message:

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

id: 6668543

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_newbookcontact_emails_notifications/2024-11-04/1730783880",
        "key": "raw/newbookdev_newbookcontact_emails_notifications/2024-11-04/1730783880/contact_emails_notifications.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_emails_notifications",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5846290444174233124,
        "service_name": "drive-thru",
        "span_id": 12599223633179177072,
        "trace_id": 15588069100442386666
    }
}

running: False
schema_name_id: 2560
start_time: 2024-11-05 02:33:37
success: True
trace_id: 15588069100442386666

Scan 6667615

duration: 0:00:13.887662

exit_message:

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

id: 6667615

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_newbookcontact_emails_notifications/2024-11-04/1730783742",
        "key": "raw/newbookdev_newbookcontact_emails_notifications/2024-11-04/1730783742/contact_emails_notifications.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_emails_notifications",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14867512666436001158,
        "service_name": "drive-thru",
        "span_id": 2733009203313337820,
        "trace_id": 14300585968863337716
    }
}

running: False
schema_name_id: 2560
start_time: 2024-11-05 02:09:08
success: True
trace_id: 14300585968863337716

Scan 6667134

duration: 0:00:11.402365

exit_message:

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

id: 6667134

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_newbookcontact_emails_notifications/2024-11-04/1730783646",
        "key": "raw/newbookdev_newbookcontact_emails_notifications/2024-11-04/1730783646/contact_emails_notifications.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_emails_notifications",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11276204992904458006,
        "service_name": "drive-thru",
        "span_id": 18436665617726062829,
        "trace_id": 3476384091978212460
    }
}

running: False
schema_name_id: 2560
start_time: 2024-11-05 01:56:13
success: True
trace_id: 3476384091978212460

Scan 6666151

duration: 0:00:11.335818

exit_message:

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

id: 6666151

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_newbookcontact_emails_notifications/2024-11-04/1730783498",
        "key": "raw/newbookdev_newbookcontact_emails_notifications/2024-11-04/1730783498/contact_emails_notifications.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_emails_notifications",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2126501487816097824,
        "service_name": "drive-thru",
        "span_id": 9019076834311616864,
        "trace_id": 3984272662057520430
    }
}

running: False
schema_name_id: 2560
start_time: 2024-11-05 01:30:22
success: True
trace_id: 3984272662057520430

Scan 6665359

duration: 0:00:13.922381

exit_message:

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

id: 6665359

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_newbookcontact_emails_notifications/2024-11-04/1730783279",
        "key": "raw/newbookdev_newbookcontact_emails_notifications/2024-11-04/1730783279/contact_emails_notifications.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_emails_notifications",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5941784869228482043,
        "service_name": "drive-thru",
        "span_id": 6486685708098282279,
        "trace_id": 4504793933058924464
    }
}

running: False
schema_name_id: 2560
start_time: 2024-11-05 01:09:29
success: True
trace_id: 4504793933058924464

Scan 6664636

duration: 0:00:11.284795

exit_message:

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

id: 6664636

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_newbookcontact_emails_notifications/2024-11-04/1730782882",
        "key": "raw/newbookdev_newbookcontact_emails_notifications/2024-11-04/1730782882/contact_emails_notifications.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_emails_notifications",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5050098928385597750,
        "service_name": "drive-thru",
        "span_id": 17151174242314037230,
        "trace_id": 1201824348860194246
    }
}

running: False
schema_name_id: 2560
start_time: 2024-11-05 00:50:12
success: True
trace_id: 1201824348860194246

Scan 6663964

duration: 0:00:13.896530

exit_message:

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

id: 6663964

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_newbookcontact_emails_notifications/2024-11-04/1730782787",
        "key": "raw/newbookdev_newbookcontact_emails_notifications/2024-11-04/1730782787/contact_emails_notifications.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_emails_notifications",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5778160403997130230,
        "service_name": "drive-thru",
        "span_id": 2125557653433473834,
        "trace_id": 18375258904083664240
    }
}

running: False
schema_name_id: 2560
start_time: 2024-11-05 00:32:37
success: True
trace_id: 18375258904083664240

Partitions:

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

Schema:

attributes:

{
    "email_action": "string",
    "email_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

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

ddl:

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

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