Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookcontact_emails_blacklist

created: 2024-10-08 17:48:15
disabled: False
format: raw
id: 2564
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748386

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_emails_blacklist/2024-11-05/1730866429
id: 4748386
processed: 1

raw_data:

{
    "added_on": 4,
    "id": 2,
    "newbook_region": 0,
    "sender": 3,
    "tenant": 1
}

schema_attributes:

{
    "added_on": "string",
    "id": "string",
    "newbook_region": "string",
    "sender": "string",
    "tenant": "string"
}

schema_name_id: 2564
schema_scan_id: 6674418
updated: 2024-11-05 22:44:40

Version 4748023

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_emails_blacklist/2024-11-05/1730866347
id: 4748023
processed: 1

raw_data:

{
    "added_on": 4,
    "id": 2,
    "newbook_region": 0,
    "sender": 3,
    "tenant": 1
}

schema_attributes:

{
    "added_on": "string",
    "id": "string",
    "newbook_region": "string",
    "sender": "string",
    "tenant": "string"
}

schema_name_id: 2564
schema_scan_id: 6674055
updated: 2024-11-05 22:32:42

Version 4747510

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

ddl:

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

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

raw_data:

{
    "added_on": 4,
    "id": 2,
    "newbook_region": 0,
    "sender": 3,
    "tenant": 1
}

schema_attributes:

{
    "added_on": "string",
    "id": "string",
    "newbook_region": "string",
    "sender": "string",
    "tenant": "string"
}

schema_name_id: 2564
schema_scan_id: 6673542
updated: 2024-11-05 22:18:59

Version 4746043

created: 2024-11-05 03:47:15

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_emails_blacklist/2024-11-04/1730785679
id: 4746043
processed: 1

raw_data:

{
    "added_on": 4,
    "id": 2,
    "newbook_region": 0,
    "sender": 3,
    "tenant": 1
}

schema_attributes:

{
    "added_on": "string",
    "id": "string",
    "newbook_region": "string",
    "sender": "string",
    "tenant": "string"
}

schema_name_id: 2564
schema_scan_id: 6671264
updated: 2024-11-05 03:47:26

Version 4745955

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

ddl:

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

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

raw_data:

{
    "added_on": 4,
    "id": 2,
    "newbook_region": 0,
    "sender": 3,
    "tenant": 1
}

schema_attributes:

{
    "added_on": "string",
    "id": "string",
    "newbook_region": "string",
    "sender": "string",
    "tenant": "string"
}

schema_name_id: 2564
schema_scan_id: 6671175
updated: 2024-11-05 03:44:13

Version 4745308

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

ddl:

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

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

raw_data:

{
    "added_on": 4,
    "id": 2,
    "newbook_region": 0,
    "sender": 3,
    "tenant": 1
}

schema_attributes:

{
    "added_on": "string",
    "id": "string",
    "newbook_region": "string",
    "sender": "string",
    "tenant": "string"
}

schema_name_id: 2564
schema_scan_id: 6670525
updated: 2024-11-05 03:26:14

Version 4744619

created: 2024-11-05 03:07:58

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_emails_blacklist/2024-11-04/1730784191
id: 4744619
processed: 1

raw_data:

{
    "added_on": 4,
    "id": 2,
    "newbook_region": 0,
    "sender": 3,
    "tenant": 1
}

schema_attributes:

{
    "added_on": "string",
    "id": "string",
    "newbook_region": "string",
    "sender": "string",
    "tenant": "string"
}

schema_name_id: 2564
schema_scan_id: 6669836
updated: 2024-11-05 03:08:11

Version 4743772

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_emails_blacklist/2024-11-04/1730784028
id: 4743772
processed: 1

raw_data:

{
    "added_on": 4,
    "id": 2,
    "newbook_region": 0,
    "sender": 3,
    "tenant": 1
}

schema_attributes:

{
    "added_on": "string",
    "id": "string",
    "newbook_region": "string",
    "sender": "string",
    "tenant": "string"
}

schema_name_id: 2564
schema_scan_id: 6668989
updated: 2024-11-05 02:45:36

Version 4742587

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

ddl:

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

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

raw_data:

{
    "added_on": 4,
    "id": 2,
    "newbook_region": 0,
    "sender": 3,
    "tenant": 1
}

schema_attributes:

{
    "added_on": "string",
    "id": "string",
    "newbook_region": "string",
    "sender": "string",
    "tenant": "string"
}

schema_name_id: 2564
schema_scan_id: 6667804
updated: 2024-11-05 02:14:21

Version 4742394

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

ddl:

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

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

raw_data:

{
    "added_on": 4,
    "id": 2,
    "newbook_region": 0,
    "sender": 3,
    "tenant": 1
}

schema_attributes:

{
    "added_on": "string",
    "id": "string",
    "newbook_region": "string",
    "sender": "string",
    "tenant": "string"
}

schema_name_id: 2564
schema_scan_id: 6667611
updated: 2024-11-05 02:09:15

Version 4741659

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

ddl:

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

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

raw_data:

{
    "added_on": 4,
    "id": 2,
    "newbook_region": 0,
    "sender": 3,
    "tenant": 1
}

schema_attributes:

{
    "added_on": "string",
    "id": "string",
    "newbook_region": "string",
    "sender": "string",
    "tenant": "string"
}

schema_name_id: 2564
schema_scan_id: 6666876
updated: 2024-11-05 01:49:35

Version 4741044

created: 2024-11-05 01:33:19

ddl:

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

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

raw_data:

{
    "added_on": 4,
    "id": 2,
    "newbook_region": 0,
    "sender": 3,
    "tenant": 1
}

schema_attributes:

{
    "added_on": "string",
    "id": "string",
    "newbook_region": "string",
    "sender": "string",
    "tenant": "string"
}

schema_name_id: 2564
schema_scan_id: 6666261
updated: 2024-11-05 01:33:32

Version 4740160

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

ddl:

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

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

raw_data:

{
    "added_on": 4,
    "id": 2,
    "newbook_region": 0,
    "sender": 3,
    "tenant": 1
}

schema_attributes:

{
    "added_on": "string",
    "id": "string",
    "newbook_region": "string",
    "sender": "string",
    "tenant": "string"
}

schema_name_id: 2564
schema_scan_id: 6665377
updated: 2024-11-05 01:10:11

Version 4739407

created: 2024-11-05 00:49:49

ddl:

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

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

raw_data:

{
    "added_on": 4,
    "id": 2,
    "newbook_region": 0,
    "sender": 3,
    "tenant": 1
}

schema_attributes:

{
    "added_on": "string",
    "id": "string",
    "newbook_region": "string",
    "sender": "string",
    "tenant": "string"
}

schema_name_id: 2564
schema_scan_id: 6664622
updated: 2024-11-05 00:50:03

Version 4738448

created: 2024-11-05 00:24:43

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_emails_blacklist/2024-11-04/1730782744
id: 4738448
processed: 1

raw_data:

{
    "added_on": 4,
    "id": 2,
    "newbook_region": 0,
    "sender": 3,
    "tenant": 1
}

schema_attributes:

{
    "added_on": "string",
    "id": "string",
    "newbook_region": "string",
    "sender": "string",
    "tenant": "string"
}

schema_name_id: 2564
schema_scan_id: 6663660
updated: 2024-11-05 00:24:54

Schema Scans: 15

Last at 2024-11-05 22:44:26

Scan 6674418

duration: 0:00:14.056352

exit_message:

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

id: 6674418

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_blacklist/2024-11-05/1730866429",
        "key": "raw/newbookdev_newbookcontact_emails_blacklist/2024-11-05/1730866429/contact_emails_blacklist.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_emails_blacklist",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18299606509553507794,
        "service_name": "drive-thru",
        "span_id": 15828586732872484070,
        "trace_id": 2662015748370656255
    }
}

running: False
schema_name_id: 2564
start_time: 2024-11-05 22:44:26
success: True
trace_id: 2662015748370656255

Scan 6674055

duration: 0:00:11.597688

exit_message:

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

id: 6674055

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_blacklist/2024-11-05/1730866347",
        "key": "raw/newbookdev_newbookcontact_emails_blacklist/2024-11-05/1730866347/contact_emails_blacklist.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_emails_blacklist",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14941254239948774964,
        "service_name": "drive-thru",
        "span_id": 3087918960572594457,
        "trace_id": 4876997407815260521
    }
}

running: False
schema_name_id: 2564
start_time: 2024-11-05 22:32:30
success: True
trace_id: 4876997407815260521

Scan 6673542

duration: 0:00:13.870443

exit_message:

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

id: 6673542

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_blacklist/2024-11-05/1730866259",
        "key": "raw/newbookdev_newbookcontact_emails_blacklist/2024-11-05/1730866259/contact_emails_blacklist.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_emails_blacklist",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7086891768902414406,
        "service_name": "drive-thru",
        "span_id": 11602969461800456615,
        "trace_id": 12494606205481706957
    }
}

running: False
schema_name_id: 2564
start_time: 2024-11-05 22:18:45
success: True
trace_id: 12494606205481706957

Scan 6671264

duration: 0:00:11.625258

exit_message:

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

id: 6671264

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_blacklist/2024-11-04/1730785679",
        "key": "raw/newbookdev_newbookcontact_emails_blacklist/2024-11-04/1730785679/contact_emails_blacklist.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_emails_blacklist",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6913597391393053272,
        "service_name": "drive-thru",
        "span_id": 6640280981607489416,
        "trace_id": 17291887014244034577
    }
}

running: False
schema_name_id: 2564
start_time: 2024-11-05 03:47:14
success: True
trace_id: 17291887014244034577

Scan 6671175

duration: 0:00:11.480092

exit_message:

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

id: 6671175

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_blacklist/2024-11-04/1730785100",
        "key": "raw/newbookdev_newbookcontact_emails_blacklist/2024-11-04/1730785100/contact_emails_blacklist.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_emails_blacklist",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9242692010500266404,
        "service_name": "drive-thru",
        "span_id": 2518363707586669050,
        "trace_id": 3751415202152531204
    }
}

running: False
schema_name_id: 2564
start_time: 2024-11-05 03:44:02
success: True
trace_id: 3751415202152531204

Scan 6670525

duration: 0:00:11.450976

exit_message:

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

id: 6670525

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_blacklist/2024-11-04/1730784795",
        "key": "raw/newbookdev_newbookcontact_emails_blacklist/2024-11-04/1730784795/contact_emails_blacklist.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_emails_blacklist",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9062434292699167057,
        "service_name": "drive-thru",
        "span_id": 11068953312126398296,
        "trace_id": 11131706001886600438
    }
}

running: False
schema_name_id: 2564
start_time: 2024-11-05 03:26:03
success: True
trace_id: 11131706001886600438

Scan 6669836

duration: 0:00:13.803948

exit_message:

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

id: 6669836

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_blacklist/2024-11-04/1730784191",
        "key": "raw/newbookdev_newbookcontact_emails_blacklist/2024-11-04/1730784191/contact_emails_blacklist.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_emails_blacklist",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2089841531437149543,
        "service_name": "drive-thru",
        "span_id": 10233044936875170231,
        "trace_id": 1790392260792042671
    }
}

running: False
schema_name_id: 2564
start_time: 2024-11-05 03:07:58
success: True
trace_id: 1790392260792042671

Scan 6668989

duration: 0:00:11.347150

exit_message:

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

id: 6668989

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_blacklist/2024-11-04/1730784028",
        "key": "raw/newbookdev_newbookcontact_emails_blacklist/2024-11-04/1730784028/contact_emails_blacklist.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_emails_blacklist",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8298757971659704816,
        "service_name": "drive-thru",
        "span_id": 1050594922748812607,
        "trace_id": 10776503375447541169
    }
}

running: False
schema_name_id: 2564
start_time: 2024-11-05 02:45:25
success: True
trace_id: 10776503375447541169

Scan 6667804

duration: 0:00:13.825196

exit_message:

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

id: 6667804

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_blacklist/2024-11-04/1730783880",
        "key": "raw/newbookdev_newbookcontact_emails_blacklist/2024-11-04/1730783880/contact_emails_blacklist.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_emails_blacklist",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5211886577399100798,
        "service_name": "drive-thru",
        "span_id": 14725379969006488887,
        "trace_id": 2898306548660797938
    }
}

running: False
schema_name_id: 2564
start_time: 2024-11-05 02:14:08
success: True
trace_id: 2898306548660797938

Scan 6667611

duration: 0:00:11.392227

exit_message:

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

id: 6667611

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_blacklist/2024-11-04/1730783742",
        "key": "raw/newbookdev_newbookcontact_emails_blacklist/2024-11-04/1730783742/contact_emails_blacklist.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_emails_blacklist",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9992956164918109303,
        "service_name": "drive-thru",
        "span_id": 16230620063622701009,
        "trace_id": 15974148393250596301
    }
}

running: False
schema_name_id: 2564
start_time: 2024-11-05 02:09:04
success: True
trace_id: 15974148393250596301

Scan 6666876

duration: 0:00:11.356939

exit_message:

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

id: 6666876

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_blacklist/2024-11-04/1730783646",
        "key": "raw/newbookdev_newbookcontact_emails_blacklist/2024-11-04/1730783646/contact_emails_blacklist.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_emails_blacklist",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17754437166971575271,
        "service_name": "drive-thru",
        "span_id": 6394629160206838725,
        "trace_id": 16410120531757357251
    }
}

running: False
schema_name_id: 2564
start_time: 2024-11-05 01:49:24
success: True
trace_id: 16410120531757357251

Scan 6666261

duration: 0:00:13.836207

exit_message:

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

id: 6666261

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_blacklist/2024-11-04/1730783498",
        "key": "raw/newbookdev_newbookcontact_emails_blacklist/2024-11-04/1730783498/contact_emails_blacklist.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_emails_blacklist",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7222849433375227233,
        "service_name": "drive-thru",
        "span_id": 12277769440273088670,
        "trace_id": 14802317020632544303
    }
}

running: False
schema_name_id: 2564
start_time: 2024-11-05 01:33:18
success: True
trace_id: 14802317020632544303

Scan 6665377

duration: 0:00:13.701198

exit_message:

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

id: 6665377

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_blacklist/2024-11-04/1730783279",
        "key": "raw/newbookdev_newbookcontact_emails_blacklist/2024-11-04/1730783279/contact_emails_blacklist.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_emails_blacklist",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5783132495547963133,
        "service_name": "drive-thru",
        "span_id": 50377011628462348,
        "trace_id": 14565289509989173907
    }
}

running: False
schema_name_id: 2564
start_time: 2024-11-05 01:09:58
success: True
trace_id: 14565289509989173907

Scan 6664622

duration: 0:00:13.819200

exit_message:

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

id: 6664622

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_blacklist/2024-11-04/1730782882",
        "key": "raw/newbookdev_newbookcontact_emails_blacklist/2024-11-04/1730782882/contact_emails_blacklist.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_emails_blacklist",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18076062369747106391,
        "service_name": "drive-thru",
        "span_id": 9794325729749296111,
        "trace_id": 9503647316749580564
    }
}

running: False
schema_name_id: 2564
start_time: 2024-11-05 00:49:49
success: True
trace_id: 9503647316749580564

Scan 6663660

duration: 0:00:11.394294

exit_message:

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

id: 6663660

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_blacklist/2024-11-04/1730782744",
        "key": "raw/newbookdev_newbookcontact_emails_blacklist/2024-11-04/1730782744/contact_emails_blacklist.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_emails_blacklist",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10381158330116447097,
        "service_name": "drive-thru",
        "span_id": 1275021375529864434,
        "trace_id": 6378832602045643780
    }
}

running: False
schema_name_id: 2564
start_time: 2024-11-05 00:24:42
success: True
trace_id: 6378832602045643780

Partitions:

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

Schema:

attributes:

{
    "added_on": "string",
    "id": "string",
    "newbook_region": "string",
    "sender": "string",
    "tenant": "string"
}

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

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_blacklist`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `sender`  string , `added_on`  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_blacklist/2024-11-05/1730866429'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_emails_blacklist`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_emails_blacklist"
}

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:48:15",
        "disabled": false,
        "format": "raw",
        "id": 2564,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookcontact_emails_blacklist"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "added_on": "string",
            "id": "string",
            "newbook_region": "string",
            "sender": "string",
            "tenant": "string"
        },
        "created": "2024-11-05 22:44:27",
        "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_blacklist`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `sender`  string , `added_on`  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_blacklist/2024-11-05/1730866429'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_emails_blacklist`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_emails_blacklist"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}