Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbooksupport_requests_cc

created: 2024-10-08 18:31:20
disabled: False
format: raw
id: 3019
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749399

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksupport_requests_cc/2024-11-05/1730866607
id: 4749399
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "recipient": 4,
    "recipient_name": 5,
    "request_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "request_id": "string",
    "tenant": "string"
}

schema_name_id: 3019
schema_scan_id: 6675437
updated: 2024-11-05 23:46:45

Version 4749276

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksupport_requests_cc/2024-11-05/1730866555
id: 4749276
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "recipient": 4,
    "recipient_name": 5,
    "request_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "request_id": "string",
    "tenant": "string"
}

schema_name_id: 3019
schema_scan_id: 6675308
updated: 2024-11-05 23:33:38

Version 4748474

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksupport_requests_cc/2024-11-05/1730866448
id: 4748474
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "recipient": 4,
    "recipient_name": 5,
    "request_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "request_id": "string",
    "tenant": "string"
}

schema_name_id: 3019
schema_scan_id: 6674506
updated: 2024-11-05 22:47:42

Version 4747103

created: 2024-11-05 04:50:37

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksupport_requests_cc/2024-11-04/1730785802
id: 4747103
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "recipient": 4,
    "recipient_name": 5,
    "request_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "request_id": "string",
    "tenant": "string"
}

schema_name_id: 3019
schema_scan_id: 6672335
updated: 2024-11-05 04:50:48

Version 4746496

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksupport_requests_cc/2024-11-04/1730785169
id: 4746496
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "recipient": 4,
    "recipient_name": 5,
    "request_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "request_id": "string",
    "tenant": "string"
}

schema_name_id: 3019
schema_scan_id: 6671717
updated: 2024-11-05 04:06:16

Version 4745786

created: 2024-11-05 03:38:52

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksupport_requests_cc/2024-11-04/1730784865
id: 4745786
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "recipient": 4,
    "recipient_name": 5,
    "request_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "request_id": "string",
    "tenant": "string"
}

schema_name_id: 3019
schema_scan_id: 6671003
updated: 2024-11-05 03:39:03

Version 4744959

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksupport_requests_cc/2024-11-04/1730784261
id: 4744959
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "recipient": 4,
    "recipient_name": 5,
    "request_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "request_id": "string",
    "tenant": "string"
}

schema_name_id: 3019
schema_scan_id: 6670176
updated: 2024-11-05 03:17:09

Version 4743721

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksupport_requests_cc/2024-11-04/1730784099
id: 4743721
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "recipient": 4,
    "recipient_name": 5,
    "request_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "request_id": "string",
    "tenant": "string"
}

schema_name_id: 3019
schema_scan_id: 6668938
updated: 2024-11-05 02:44:16

Version 4743327

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksupport_requests_cc/2024-11-04/1730783855
id: 4743327
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "recipient": 4,
    "recipient_name": 5,
    "request_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "request_id": "string",
    "tenant": "string"
}

schema_name_id: 3019
schema_scan_id: 6668544
updated: 2024-11-05 02:33:53

Version 4742840

created: 2024-11-05 02:20:49

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksupport_requests_cc/2024-11-04/1730783813
id: 4742840
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "recipient": 4,
    "recipient_name": 5,
    "request_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "request_id": "string",
    "tenant": "string"
}

schema_name_id: 3019
schema_scan_id: 6668057
updated: 2024-11-05 02:21:03

Version 4742186

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksupport_requests_cc/2024-11-04/1730783699
id: 4742186
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "recipient": 4,
    "recipient_name": 5,
    "request_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "request_id": "string",
    "tenant": "string"
}

schema_name_id: 3019
schema_scan_id: 6667403
updated: 2024-11-05 02:03:37

Version 4741243

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksupport_requests_cc/2024-11-04/1730783570
id: 4741243
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "recipient": 4,
    "recipient_name": 5,
    "request_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "request_id": "string",
    "tenant": "string"
}

schema_name_id: 3019
schema_scan_id: 6666460
updated: 2024-11-05 01:38:44

Version 4740717

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksupport_requests_cc/2024-11-04/1730783351
id: 4740717
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "recipient": 4,
    "recipient_name": 5,
    "request_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "request_id": "string",
    "tenant": "string"
}

schema_name_id: 3019
schema_scan_id: 6665934
updated: 2024-11-05 01:24:49

Version 4739598

created: 2024-11-05 00:54:54

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksupport_requests_cc/2024-11-04/1730782949
id: 4739598
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "recipient": 4,
    "recipient_name": 5,
    "request_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "request_id": "string",
    "tenant": "string"
}

schema_name_id: 3019
schema_scan_id: 6664815
updated: 2024-11-05 00:55:04

Version 4739295

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksupport_requests_cc/2024-11-04/1730782839
id: 4739295
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "recipient": 4,
    "recipient_name": 5,
    "request_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "request_id": "string",
    "tenant": "string"
}

schema_name_id: 3019
schema_scan_id: 6664511
updated: 2024-11-05 00:47:08

Schema Scans: 15

Last at 2024-11-05 23:46:33

Scan 6675437

duration: 0:00:11.566596

exit_message:

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

id: 6675437

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_newbooksupport_requests_cc/2024-11-05/1730866607",
        "key": "raw/newbookdev_newbooksupport_requests_cc/2024-11-05/1730866607/support_requests_cc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooksupport_requests_cc",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12601258087780624002,
        "service_name": "drive-thru",
        "span_id": 2052881732927316324,
        "trace_id": 5261813028044884355
    }
}

running: False
schema_name_id: 3019
start_time: 2024-11-05 23:46:33
success: True
trace_id: 5261813028044884355

Scan 6675308

duration: 0:00:11.626432

exit_message:

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

id: 6675308

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_newbooksupport_requests_cc/2024-11-05/1730866555",
        "key": "raw/newbookdev_newbooksupport_requests_cc/2024-11-05/1730866555/support_requests_cc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooksupport_requests_cc",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4143585271557593270,
        "service_name": "drive-thru",
        "span_id": 11205725770416521090,
        "trace_id": 10297828836337351593
    }
}

running: False
schema_name_id: 3019
start_time: 2024-11-05 23:33:27
success: True
trace_id: 10297828836337351593

Scan 6674506

duration: 0:00:11.559009

exit_message:

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

id: 6674506

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_newbooksupport_requests_cc/2024-11-05/1730866448",
        "key": "raw/newbookdev_newbooksupport_requests_cc/2024-11-05/1730866448/support_requests_cc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooksupport_requests_cc",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16716159107936429661,
        "service_name": "drive-thru",
        "span_id": 16079658087450773599,
        "trace_id": 16814442604517593426
    }
}

running: False
schema_name_id: 3019
start_time: 2024-11-05 22:47:30
success: True
trace_id: 16814442604517593426

Scan 6672335

duration: 0:00:11.490273

exit_message:

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

id: 6672335

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_newbooksupport_requests_cc/2024-11-04/1730785802",
        "key": "raw/newbookdev_newbooksupport_requests_cc/2024-11-04/1730785802/support_requests_cc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooksupport_requests_cc",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7800180942099561007,
        "service_name": "drive-thru",
        "span_id": 15357372474835954340,
        "trace_id": 13604710079404258416
    }
}

running: False
schema_name_id: 3019
start_time: 2024-11-05 04:50:36
success: True
trace_id: 13604710079404258416

Scan 6671717

duration: 0:00:14.490309

exit_message:

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

id: 6671717

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_newbooksupport_requests_cc/2024-11-04/1730785169",
        "key": "raw/newbookdev_newbooksupport_requests_cc/2024-11-04/1730785169/support_requests_cc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooksupport_requests_cc",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3071409687079606646,
        "service_name": "drive-thru",
        "span_id": 6623018392920290009,
        "trace_id": 16245107137076320951
    }
}

running: False
schema_name_id: 3019
start_time: 2024-11-05 04:06:01
success: True
trace_id: 16245107137076320951

Scan 6671003

duration: 0:00:11.605918

exit_message:

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

id: 6671003

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_newbooksupport_requests_cc/2024-11-04/1730784865",
        "key": "raw/newbookdev_newbooksupport_requests_cc/2024-11-04/1730784865/support_requests_cc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooksupport_requests_cc",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7432934155005290172,
        "service_name": "drive-thru",
        "span_id": 3271172200119289197,
        "trace_id": 9588057481255902223
    }
}

running: False
schema_name_id: 3019
start_time: 2024-11-05 03:38:51
success: True
trace_id: 9588057481255902223

Scan 6670176

duration: 0:00:11.401001

exit_message:

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

id: 6670176

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_newbooksupport_requests_cc/2024-11-04/1730784261",
        "key": "raw/newbookdev_newbooksupport_requests_cc/2024-11-04/1730784261/support_requests_cc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooksupport_requests_cc",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18229623736660622255,
        "service_name": "drive-thru",
        "span_id": 1103801641052293148,
        "trace_id": 15431141225571187604
    }
}

running: False
schema_name_id: 3019
start_time: 2024-11-05 03:16:58
success: True
trace_id: 15431141225571187604

Scan 6668938

duration: 0:00:11.375434

exit_message:

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

id: 6668938

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_newbooksupport_requests_cc/2024-11-04/1730784099",
        "key": "raw/newbookdev_newbooksupport_requests_cc/2024-11-04/1730784099/support_requests_cc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooksupport_requests_cc",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1304962992233924974,
        "service_name": "drive-thru",
        "span_id": 9639774807552659070,
        "trace_id": 10326884053813588049
    }
}

running: False
schema_name_id: 3019
start_time: 2024-11-05 02:44:05
success: True
trace_id: 10326884053813588049

Scan 6668544

duration: 0:00:13.939967

exit_message:

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

id: 6668544

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_newbooksupport_requests_cc/2024-11-04/1730783855",
        "key": "raw/newbookdev_newbooksupport_requests_cc/2024-11-04/1730783855/support_requests_cc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooksupport_requests_cc",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5412451156655172524,
        "service_name": "drive-thru",
        "span_id": 577122569135947776,
        "trace_id": 5228796282160681056
    }
}

running: False
schema_name_id: 3019
start_time: 2024-11-05 02:33:40
success: True
trace_id: 5228796282160681056

Scan 6668057

duration: 0:00:14.000956

exit_message:

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

id: 6668057

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_newbooksupport_requests_cc/2024-11-04/1730783813",
        "key": "raw/newbookdev_newbooksupport_requests_cc/2024-11-04/1730783813/support_requests_cc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooksupport_requests_cc",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16687746138643905285,
        "service_name": "drive-thru",
        "span_id": 9625988272447137515,
        "trace_id": 16324730251640370981
    }
}

running: False
schema_name_id: 3019
start_time: 2024-11-05 02:20:49
success: True
trace_id: 16324730251640370981

Scan 6667403

duration: 0:00:11.452511

exit_message:

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

id: 6667403

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_newbooksupport_requests_cc/2024-11-04/1730783699",
        "key": "raw/newbookdev_newbooksupport_requests_cc/2024-11-04/1730783699/support_requests_cc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooksupport_requests_cc",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6123198339611218575,
        "service_name": "drive-thru",
        "span_id": 1645752340932128349,
        "trace_id": 10952456972494710422
    }
}

running: False
schema_name_id: 3019
start_time: 2024-11-05 02:03:26
success: True
trace_id: 10952456972494710422

Scan 6666460

duration: 0:00:11.444077

exit_message:

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

id: 6666460

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_newbooksupport_requests_cc/2024-11-04/1730783570",
        "key": "raw/newbookdev_newbooksupport_requests_cc/2024-11-04/1730783570/support_requests_cc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooksupport_requests_cc",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17503051459251218297,
        "service_name": "drive-thru",
        "span_id": 4977139286419120297,
        "trace_id": 5977894253739075323
    }
}

running: False
schema_name_id: 3019
start_time: 2024-11-05 01:38:32
success: True
trace_id: 5977894253739075323

Scan 6665934

duration: 0:00:11.406679

exit_message:

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

id: 6665934

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_newbooksupport_requests_cc/2024-11-04/1730783351",
        "key": "raw/newbookdev_newbooksupport_requests_cc/2024-11-04/1730783351/support_requests_cc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooksupport_requests_cc",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8378582758406995199,
        "service_name": "drive-thru",
        "span_id": 1937975251709248034,
        "trace_id": 1878718748621592120
    }
}

running: False
schema_name_id: 3019
start_time: 2024-11-05 01:24:38
success: True
trace_id: 1878718748621592120

Scan 6664815

duration: 0:00:11.283155

exit_message:

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

id: 6664815

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_newbooksupport_requests_cc/2024-11-04/1730782949",
        "key": "raw/newbookdev_newbooksupport_requests_cc/2024-11-04/1730782949/support_requests_cc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooksupport_requests_cc",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3072409909969294936,
        "service_name": "drive-thru",
        "span_id": 15134987183319142223,
        "trace_id": 15050417486747685331
    }
}

running: False
schema_name_id: 3019
start_time: 2024-11-05 00:54:53
success: True
trace_id: 15050417486747685331

Scan 6664511

duration: 0:00:11.351104

exit_message:

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

id: 6664511

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_newbooksupport_requests_cc/2024-11-04/1730782839",
        "key": "raw/newbookdev_newbooksupport_requests_cc/2024-11-04/1730782839/support_requests_cc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooksupport_requests_cc",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1490901631999956094,
        "service_name": "drive-thru",
        "span_id": 6251628427089395756,
        "trace_id": 2814091350644363546
    }
}

running: False
schema_name_id: 3019
start_time: 2024-11-05 00:46:57
success: True
trace_id: 2814091350644363546

Partitions:

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

Schema:

attributes:

{
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "request_id": "string",
    "tenant": "string"
}

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

ddl:

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

Server:

hostname: schemamanager-5447774fc6-4w58v
name: schema_manager
process_start: 2026-04-02 21:43:44
sf_env: dev
version: 2427328685

Raw:

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