Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookemail_inboxes_users

created: 2024-10-08 17:55:16
disabled: False
format: raw
id: 2663
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748703

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookemail_inboxes_users/2024-11-05/1730866477
id: 4748703
processed: 1

raw_data:

{
    "id": 2,
    "inbox_id": 3,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 5,
    "user_type": 4
}

schema_attributes:

{
    "id": "string",
    "inbox_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string",
    "user_type": "string"
}

schema_name_id: 2663
schema_scan_id: 6674735
updated: 2024-11-05 22:57:27

Version 4748065

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookemail_inboxes_users/2024-11-05/1730866391
id: 4748065
processed: 1

raw_data:

{
    "id": 2,
    "inbox_id": 3,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 5,
    "user_type": 4
}

schema_attributes:

{
    "id": "string",
    "inbox_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string",
    "user_type": "string"
}

schema_name_id: 2663
schema_scan_id: 6674097
updated: 2024-11-05 22:34:00

Version 4747613

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookemail_inboxes_users/2024-11-05/1730866282
id: 4747613
processed: 1

raw_data:

{
    "id": 2,
    "inbox_id": 3,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 5,
    "user_type": 4
}

schema_attributes:

{
    "id": "string",
    "inbox_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string",
    "user_type": "string"
}

schema_name_id: 2663
schema_scan_id: 6673645
updated: 2024-11-05 22:21:37

Version 4746807

created: 2024-11-05 04:24:39

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookemail_inboxes_users/2024-11-04/1730785702
id: 4746807
processed: 1

raw_data:

{
    "id": 2,
    "inbox_id": 3,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 5,
    "user_type": 4
}

schema_attributes:

{
    "id": "string",
    "inbox_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string",
    "user_type": "string"
}

schema_name_id: 2663
schema_scan_id: 6672037
updated: 2024-11-05 04:24:50

Version 4746063

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookemail_inboxes_users/2024-11-04/1730785114
id: 4746063
processed: 1

raw_data:

{
    "id": 2,
    "inbox_id": 3,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 5,
    "user_type": 4
}

schema_attributes:

{
    "id": "string",
    "inbox_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string",
    "user_type": "string"
}

schema_name_id: 2663
schema_scan_id: 6671284
updated: 2024-11-05 03:48:08

Version 4745814

created: 2024-11-05 03:39:45

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookemail_inboxes_users/2024-11-04/1730784809
id: 4745814
processed: 1

raw_data:

{
    "id": 2,
    "inbox_id": 3,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 5,
    "user_type": 4
}

schema_attributes:

{
    "id": "string",
    "inbox_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string",
    "user_type": "string"
}

schema_name_id: 2663
schema_scan_id: 6671032
updated: 2024-11-05 03:39:58

Version 4744658

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookemail_inboxes_users/2024-11-04/1730784205
id: 4744658
processed: 1

raw_data:

{
    "id": 2,
    "inbox_id": 3,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 5,
    "user_type": 4
}

schema_attributes:

{
    "id": "string",
    "inbox_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string",
    "user_type": "string"
}

schema_name_id: 2663
schema_scan_id: 6669875
updated: 2024-11-05 03:09:11

Version 4743275

created: 2024-11-05 02:32:16

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookemail_inboxes_users/2024-11-04/1730784043
id: 4743275
processed: 1

raw_data:

{
    "id": 2,
    "inbox_id": 3,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 5,
    "user_type": 4
}

schema_attributes:

{
    "id": "string",
    "inbox_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string",
    "user_type": "string"
}

schema_name_id: 2663
schema_scan_id: 6668492
updated: 2024-11-05 02:32:27

Version 4742645

created: 2024-11-05 02:15:39

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookemail_inboxes_users/2024-11-04/1730783891
id: 4742645
processed: 1

raw_data:

{
    "id": 2,
    "inbox_id": 3,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 5,
    "user_type": 4
}

schema_attributes:

{
    "id": "string",
    "inbox_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string",
    "user_type": "string"
}

schema_name_id: 2663
schema_scan_id: 6667862
updated: 2024-11-05 02:15:50

Version 4742568

created: 2024-11-05 02:13:41

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookemail_inboxes_users/2024-11-04/1730783757
id: 4742568
processed: 1

raw_data:

{
    "id": 2,
    "inbox_id": 3,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 5,
    "user_type": 4
}

schema_attributes:

{
    "id": "string",
    "inbox_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string",
    "user_type": "string"
}

schema_name_id: 2663
schema_scan_id: 6667785
updated: 2024-11-05 02:13:52

Version 4741434

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookemail_inboxes_users/2024-11-04/1730783607
id: 4741434
processed: 1

raw_data:

{
    "id": 2,
    "inbox_id": 3,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 5,
    "user_type": 4
}

schema_attributes:

{
    "id": "string",
    "inbox_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string",
    "user_type": "string"
}

schema_name_id: 2663
schema_scan_id: 6666651
updated: 2024-11-05 01:43:42

Version 4741135

created: 2024-11-05 01:35:43

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookemail_inboxes_users/2024-11-04/1730783512
id: 4741135
processed: 1

raw_data:

{
    "id": 2,
    "inbox_id": 3,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 5,
    "user_type": 4
}

schema_attributes:

{
    "id": "string",
    "inbox_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string",
    "user_type": "string"
}

schema_name_id: 2663
schema_scan_id: 6666352
updated: 2024-11-05 01:35:54

Version 4739942

created: 2024-11-05 01:04:05

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookemail_inboxes_users/2024-11-04/1730783294
id: 4739942
processed: 1

raw_data:

{
    "id": 2,
    "inbox_id": 3,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 5,
    "user_type": 4
}

schema_attributes:

{
    "id": "string",
    "inbox_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string",
    "user_type": "string"
}

schema_name_id: 2663
schema_scan_id: 6665159
updated: 2024-11-05 01:04:16

Version 4739541

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookemail_inboxes_users/2024-11-04/1730782896
id: 4739541
processed: 1

raw_data:

{
    "id": 2,
    "inbox_id": 3,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 5,
    "user_type": 4
}

schema_attributes:

{
    "id": "string",
    "inbox_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string",
    "user_type": "string"
}

schema_name_id: 2663
schema_scan_id: 6664756
updated: 2024-11-05 00:53:34

Version 4738598

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookemail_inboxes_users/2024-11-04/1730782797
id: 4738598
processed: 1

raw_data:

{
    "id": 2,
    "inbox_id": 3,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 5,
    "user_type": 4
}

schema_attributes:

{
    "id": "string",
    "inbox_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string",
    "user_type": "string"
}

schema_name_id: 2663
schema_scan_id: 6663811
updated: 2024-11-05 00:28:48

Schema Scans: 15

Last at 2024-11-05 22:57:13

Scan 6674735

duration: 0:00:14.101589

exit_message:

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

id: 6674735

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_newbookemail_inboxes_users/2024-11-05/1730866477",
        "key": "raw/newbookdev_newbookemail_inboxes_users/2024-11-05/1730866477/email_inboxes_users.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookemail_inboxes_users",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13525400968795373782,
        "service_name": "drive-thru",
        "span_id": 8578863674809460915,
        "trace_id": 13591965504328661794
    }
}

running: False
schema_name_id: 2663
start_time: 2024-11-05 22:57:13
success: True
trace_id: 13591965504328661794

Scan 6674097

duration: 0:00:14.234257

exit_message:

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

id: 6674097

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_newbookemail_inboxes_users/2024-11-05/1730866391",
        "key": "raw/newbookdev_newbookemail_inboxes_users/2024-11-05/1730866391/email_inboxes_users.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookemail_inboxes_users",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4753790693978612724,
        "service_name": "drive-thru",
        "span_id": 14515420606010917000,
        "trace_id": 11997937841423322489
    }
}

running: False
schema_name_id: 2663
start_time: 2024-11-05 22:33:46
success: True
trace_id: 11997937841423322489

Scan 6673645

duration: 0:00:13.909553

exit_message:

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

id: 6673645

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_newbookemail_inboxes_users/2024-11-05/1730866282",
        "key": "raw/newbookdev_newbookemail_inboxes_users/2024-11-05/1730866282/email_inboxes_users.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookemail_inboxes_users",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13316849666155125812,
        "service_name": "drive-thru",
        "span_id": 2923183897634509740,
        "trace_id": 8225453162279940102
    }
}

running: False
schema_name_id: 2663
start_time: 2024-11-05 22:21:24
success: True
trace_id: 8225453162279940102

Scan 6672037

duration: 0:00:11.562880

exit_message:

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

id: 6672037

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_newbookemail_inboxes_users/2024-11-04/1730785702",
        "key": "raw/newbookdev_newbookemail_inboxes_users/2024-11-04/1730785702/email_inboxes_users.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookemail_inboxes_users",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16902308557539595941,
        "service_name": "drive-thru",
        "span_id": 12064648293344323248,
        "trace_id": 10617541422078149019
    }
}

running: False
schema_name_id: 2663
start_time: 2024-11-05 04:24:39
success: True
trace_id: 10617541422078149019

Scan 6671284

duration: 0:00:11.473548

exit_message:

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

id: 6671284

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_newbookemail_inboxes_users/2024-11-04/1730785114",
        "key": "raw/newbookdev_newbookemail_inboxes_users/2024-11-04/1730785114/email_inboxes_users.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookemail_inboxes_users",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3632238467117441869,
        "service_name": "drive-thru",
        "span_id": 2098330343572373689,
        "trace_id": 2404578867762451518
    }
}

running: False
schema_name_id: 2663
start_time: 2024-11-05 03:47:56
success: True
trace_id: 2404578867762451518

Scan 6671032

duration: 0:00:14.006698

exit_message:

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

id: 6671032

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_newbookemail_inboxes_users/2024-11-04/1730784809",
        "key": "raw/newbookdev_newbookemail_inboxes_users/2024-11-04/1730784809/email_inboxes_users.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookemail_inboxes_users",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17893531867280154961,
        "service_name": "drive-thru",
        "span_id": 17391125822343067526,
        "trace_id": 10146631618234823903
    }
}

running: False
schema_name_id: 2663
start_time: 2024-11-05 03:39:44
success: True
trace_id: 10146631618234823903

Scan 6669875

duration: 0:00:14.089104

exit_message:

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

id: 6669875

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_newbookemail_inboxes_users/2024-11-04/1730784205",
        "key": "raw/newbookdev_newbookemail_inboxes_users/2024-11-04/1730784205/email_inboxes_users.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookemail_inboxes_users",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2946921007725378894,
        "service_name": "drive-thru",
        "span_id": 17758990835938911188,
        "trace_id": 7490779704240620560
    }
}

running: False
schema_name_id: 2663
start_time: 2024-11-05 03:08:57
success: True
trace_id: 7490779704240620560

Scan 6668492

duration: 0:00:11.508576

exit_message:

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

id: 6668492

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_newbookemail_inboxes_users/2024-11-04/1730784043",
        "key": "raw/newbookdev_newbookemail_inboxes_users/2024-11-04/1730784043/email_inboxes_users.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookemail_inboxes_users",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6369406742103880625,
        "service_name": "drive-thru",
        "span_id": 9631745824908968502,
        "trace_id": 17071288526179138648
    }
}

running: False
schema_name_id: 2663
start_time: 2024-11-05 02:32:16
success: True
trace_id: 17071288526179138648

Scan 6667862

duration: 0:00:11.361823

exit_message:

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

id: 6667862

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_newbookemail_inboxes_users/2024-11-04/1730783891",
        "key": "raw/newbookdev_newbookemail_inboxes_users/2024-11-04/1730783891/email_inboxes_users.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookemail_inboxes_users",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8890737740266900487,
        "service_name": "drive-thru",
        "span_id": 2053243637804348479,
        "trace_id": 15457791345548341164
    }
}

running: False
schema_name_id: 2663
start_time: 2024-11-05 02:15:38
success: True
trace_id: 15457791345548341164

Scan 6667785

duration: 0:00:11.343522

exit_message:

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

id: 6667785

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_newbookemail_inboxes_users/2024-11-04/1730783757",
        "key": "raw/newbookdev_newbookemail_inboxes_users/2024-11-04/1730783757/email_inboxes_users.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookemail_inboxes_users",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5780850513497379051,
        "service_name": "drive-thru",
        "span_id": 17461502874272949102,
        "trace_id": 15506722798116098348
    }
}

running: False
schema_name_id: 2663
start_time: 2024-11-05 02:13:40
success: True
trace_id: 15506722798116098348

Scan 6666651

duration: 0:00:11.919029

exit_message:

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

id: 6666651

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_newbookemail_inboxes_users/2024-11-04/1730783607",
        "key": "raw/newbookdev_newbookemail_inboxes_users/2024-11-04/1730783607/email_inboxes_users.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookemail_inboxes_users",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6497413243654901435,
        "service_name": "drive-thru",
        "span_id": 16933397014055522186,
        "trace_id": 12601532584463163596
    }
}

running: False
schema_name_id: 2663
start_time: 2024-11-05 01:43:30
success: True
trace_id: 12601532584463163596

Scan 6666352

duration: 0:00:11.455367

exit_message:

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

id: 6666352

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_newbookemail_inboxes_users/2024-11-04/1730783512",
        "key": "raw/newbookdev_newbookemail_inboxes_users/2024-11-04/1730783512/email_inboxes_users.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookemail_inboxes_users",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2846500837020214510,
        "service_name": "drive-thru",
        "span_id": 1264571880022218972,
        "trace_id": 5421260993704619324
    }
}

running: False
schema_name_id: 2663
start_time: 2024-11-05 01:35:43
success: True
trace_id: 5421260993704619324

Scan 6665159

duration: 0:00:11.455247

exit_message:

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

id: 6665159

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_newbookemail_inboxes_users/2024-11-04/1730783294",
        "key": "raw/newbookdev_newbookemail_inboxes_users/2024-11-04/1730783294/email_inboxes_users.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookemail_inboxes_users",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13651205128237146732,
        "service_name": "drive-thru",
        "span_id": 13377951463657055620,
        "trace_id": 6773631287700449969
    }
}

running: False
schema_name_id: 2663
start_time: 2024-11-05 01:04:05
success: True
trace_id: 6773631287700449969

Scan 6664756

duration: 0:00:11.489338

exit_message:

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

id: 6664756

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_newbookemail_inboxes_users/2024-11-04/1730782896",
        "key": "raw/newbookdev_newbookemail_inboxes_users/2024-11-04/1730782896/email_inboxes_users.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookemail_inboxes_users",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6263308494529850671,
        "service_name": "drive-thru",
        "span_id": 7622661645767330764,
        "trace_id": 17359631873346548096
    }
}

running: False
schema_name_id: 2663
start_time: 2024-11-05 00:53:23
success: True
trace_id: 17359631873346548096

Scan 6663811

duration: 0:00:11.475306

exit_message:

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

id: 6663811

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_newbookemail_inboxes_users/2024-11-04/1730782797",
        "key": "raw/newbookdev_newbookemail_inboxes_users/2024-11-04/1730782797/email_inboxes_users.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookemail_inboxes_users",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10120902066023332025,
        "service_name": "drive-thru",
        "span_id": 14613415972143531396,
        "trace_id": 6879438607762170480
    }
}

running: False
schema_name_id: 2663
start_time: 2024-11-05 00:28:36
success: True
trace_id: 6879438607762170480

Partitions:

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

Schema:

attributes:

{
    "id": "string",
    "inbox_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string",
    "user_type": "string"
}

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

ddl:

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

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