Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments

created: 2024-10-08 17:49:02
disabled: False
format: raw
id: 2576
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748943

created: 2024-11-05 23:10:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `suggestion_id`  string , `name`  string , `content`  string , `content_type`  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_newbookfeature_suggestions_attachments/2024-11-05/1730866497'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfeature_suggestions_attachments/2024-11-05/1730866497
id: 4748943
processed: 1

raw_data:

{
    "content": 5,
    "content_type": 6,
    "id": 2,
    "name": 4,
    "newbook_region": 0,
    "suggestion_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "content": "string",
    "content_type": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "suggestion_id": "string",
    "tenant": "string"
}

schema_name_id: 2576
schema_scan_id: 6674975
updated: 2024-11-05 23:10:19

Version 4748321

created: 2024-11-05 22:42:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `suggestion_id`  string , `name`  string , `content`  string , `content_type`  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_newbookfeature_suggestions_attachments/2024-11-05/1730866414'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfeature_suggestions_attachments/2024-11-05/1730866414
id: 4748321
processed: 1

raw_data:

{
    "content": 5,
    "content_type": 6,
    "id": 2,
    "name": 4,
    "newbook_region": 0,
    "suggestion_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "content": "string",
    "content_type": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "suggestion_id": "string",
    "tenant": "string"
}

schema_name_id: 2576
schema_scan_id: 6674353
updated: 2024-11-05 22:42:20

Version 4747726

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `suggestion_id`  string , `name`  string , `content`  string , `content_type`  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_newbookfeature_suggestions_attachments/2024-11-05/1730866298'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfeature_suggestions_attachments/2024-11-05/1730866298
id: 4747726
processed: 1

raw_data:

{
    "content": 5,
    "content_type": 6,
    "id": 2,
    "name": 4,
    "newbook_region": 0,
    "suggestion_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "content": "string",
    "content_type": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "suggestion_id": "string",
    "tenant": "string"
}

schema_name_id: 2576
schema_scan_id: 6673758
updated: 2024-11-05 22:24:33

Version 4746747

created: 2024-11-05 04:20:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `suggestion_id`  string , `name`  string , `content`  string , `content_type`  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_newbookfeature_suggestions_attachments/2024-11-04/1730785714'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfeature_suggestions_attachments/2024-11-04/1730785714
id: 4746747
processed: 1

raw_data:

{
    "content": 5,
    "content_type": 6,
    "id": 2,
    "name": 4,
    "newbook_region": 0,
    "suggestion_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "content": "string",
    "content_type": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "suggestion_id": "string",
    "tenant": "string"
}

schema_name_id: 2576
schema_scan_id: 6671973
updated: 2024-11-05 04:20:33

Version 4745422

created: 2024-11-05 03:28:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `suggestion_id`  string , `name`  string , `content`  string , `content_type`  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_newbookfeature_suggestions_attachments/2024-11-04/1730785120'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfeature_suggestions_attachments/2024-11-04/1730785120
id: 4745422
processed: 1

raw_data:

{
    "content": 5,
    "content_type": 6,
    "id": 2,
    "name": 4,
    "newbook_region": 0,
    "suggestion_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "content": "string",
    "content_type": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "suggestion_id": "string",
    "tenant": "string"
}

schema_name_id: 2576
schema_scan_id: 6670639
updated: 2024-11-05 03:29:10

Version 4745412

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `suggestion_id`  string , `name`  string , `content`  string , `content_type`  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_newbookfeature_suggestions_attachments/2024-11-04/1730784815'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfeature_suggestions_attachments/2024-11-04/1730784815
id: 4745412
processed: 1

raw_data:

{
    "content": 5,
    "content_type": 6,
    "id": 2,
    "name": 4,
    "newbook_region": 0,
    "suggestion_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "content": "string",
    "content_type": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "suggestion_id": "string",
    "tenant": "string"
}

schema_name_id: 2576
schema_scan_id: 6670629
updated: 2024-11-05 03:28:55

Version 4744707

created: 2024-11-05 03:10:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `suggestion_id`  string , `name`  string , `content`  string , `content_type`  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_newbookfeature_suggestions_attachments/2024-11-04/1730784212'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfeature_suggestions_attachments/2024-11-04/1730784212
id: 4744707
processed: 1

raw_data:

{
    "content": 5,
    "content_type": 6,
    "id": 2,
    "name": 4,
    "newbook_region": 0,
    "suggestion_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "content": "string",
    "content_type": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "suggestion_id": "string",
    "tenant": "string"
}

schema_name_id: 2576
schema_scan_id: 6669924
updated: 2024-11-05 03:10:31

Version 4743917

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `suggestion_id`  string , `name`  string , `content`  string , `content_type`  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_newbookfeature_suggestions_attachments/2024-11-04/1730784049'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfeature_suggestions_attachments/2024-11-04/1730784049
id: 4743917
processed: 1

raw_data:

{
    "content": 5,
    "content_type": 6,
    "id": 2,
    "name": 4,
    "newbook_region": 0,
    "suggestion_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "content": "string",
    "content_type": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "suggestion_id": "string",
    "tenant": "string"
}

schema_name_id: 2576
schema_scan_id: 6669134
updated: 2024-11-05 02:49:24

Version 4743511

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `suggestion_id`  string , `name`  string , `content`  string , `content_type`  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_newbookfeature_suggestions_attachments/2024-11-04/1730783896'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfeature_suggestions_attachments/2024-11-04/1730783896
id: 4743511
processed: 1

raw_data:

{
    "content": 5,
    "content_type": 6,
    "id": 2,
    "name": 4,
    "newbook_region": 0,
    "suggestion_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "content": "string",
    "content_type": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "suggestion_id": "string",
    "tenant": "string"
}

schema_name_id: 2576
schema_scan_id: 6668728
updated: 2024-11-05 02:38:47

Version 4742541

created: 2024-11-05 02:12:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `suggestion_id`  string , `name`  string , `content`  string , `content_type`  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_newbookfeature_suggestions_attachments/2024-11-04/1730783763'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfeature_suggestions_attachments/2024-11-04/1730783763
id: 4742541
processed: 1

raw_data:

{
    "content": 5,
    "content_type": 6,
    "id": 2,
    "name": 4,
    "newbook_region": 0,
    "suggestion_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "content": "string",
    "content_type": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "suggestion_id": "string",
    "tenant": "string"
}

schema_name_id: 2576
schema_scan_id: 6667758
updated: 2024-11-05 02:13:09

Version 4741381

created: 2024-11-05 01:42:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `suggestion_id`  string , `name`  string , `content`  string , `content_type`  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_newbookfeature_suggestions_attachments/2024-11-04/1730783661'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfeature_suggestions_attachments/2024-11-04/1730783661
id: 4741381
processed: 1

raw_data:

{
    "content": 5,
    "content_type": 6,
    "id": 2,
    "name": 4,
    "newbook_region": 0,
    "suggestion_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "content": "string",
    "content_type": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "suggestion_id": "string",
    "tenant": "string"
}

schema_name_id: 2576
schema_scan_id: 6666598
updated: 2024-11-05 01:42:18

Version 4741097

created: 2024-11-05 01:34:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `suggestion_id`  string , `name`  string , `content`  string , `content_type`  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_newbookfeature_suggestions_attachments/2024-11-04/1730783519'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfeature_suggestions_attachments/2024-11-04/1730783519
id: 4741097
processed: 1

raw_data:

{
    "content": 5,
    "content_type": 6,
    "id": 2,
    "name": 4,
    "newbook_region": 0,
    "suggestion_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "content": "string",
    "content_type": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "suggestion_id": "string",
    "tenant": "string"
}

schema_name_id: 2576
schema_scan_id: 6666314
updated: 2024-11-05 01:34:56

Version 4739952

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `suggestion_id`  string , `name`  string , `content`  string , `content_type`  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_newbookfeature_suggestions_attachments/2024-11-04/1730783301'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfeature_suggestions_attachments/2024-11-04/1730783301
id: 4739952
processed: 1

raw_data:

{
    "content": 5,
    "content_type": 6,
    "id": 2,
    "name": 4,
    "newbook_region": 0,
    "suggestion_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "content": "string",
    "content_type": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "suggestion_id": "string",
    "tenant": "string"
}

schema_name_id: 2576
schema_scan_id: 6665169
updated: 2024-11-05 01:04:36

Version 4739557

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `suggestion_id`  string , `name`  string , `content`  string , `content_type`  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_newbookfeature_suggestions_attachments/2024-11-04/1730782902'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfeature_suggestions_attachments/2024-11-04/1730782902
id: 4739557
processed: 1

raw_data:

{
    "content": 5,
    "content_type": 6,
    "id": 2,
    "name": 4,
    "newbook_region": 0,
    "suggestion_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "content": "string",
    "content_type": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "suggestion_id": "string",
    "tenant": "string"
}

schema_name_id: 2576
schema_scan_id: 6664773
updated: 2024-11-05 00:54:00

Version 4738374

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `suggestion_id`  string , `name`  string , `content`  string , `content_type`  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_newbookfeature_suggestions_attachments/2024-11-04/1730782749'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfeature_suggestions_attachments/2024-11-04/1730782749
id: 4738374
processed: 1

raw_data:

{
    "content": 5,
    "content_type": 6,
    "id": 2,
    "name": 4,
    "newbook_region": 0,
    "suggestion_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "content": "string",
    "content_type": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "suggestion_id": "string",
    "tenant": "string"
}

schema_name_id: 2576
schema_scan_id: 6663585
updated: 2024-11-05 00:23:04

Schema Scans: 15

Last at 2024-11-05 23:10:05

Scan 6674975

duration: 0:00:14.048266

exit_message:

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

id: 6674975

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_newbookfeature_suggestions_attachments/2024-11-05/1730866497",
        "key": "raw/newbookdev_newbookfeature_suggestions_attachments/2024-11-05/1730866497/feature_suggestions_attachments.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3734278759257543944,
        "service_name": "drive-thru",
        "span_id": 14133378904208605506,
        "trace_id": 16130586101923103262
    }
}

running: False
schema_name_id: 2576
start_time: 2024-11-05 23:10:05
success: True
trace_id: 16130586101923103262

Scan 6674353

duration: 0:00:11.510211

exit_message:

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

id: 6674353

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_newbookfeature_suggestions_attachments/2024-11-05/1730866414",
        "key": "raw/newbookdev_newbookfeature_suggestions_attachments/2024-11-05/1730866414/feature_suggestions_attachments.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1472197920873152259,
        "service_name": "drive-thru",
        "span_id": 15359021143054022469,
        "trace_id": 147589971178819098
    }
}

running: False
schema_name_id: 2576
start_time: 2024-11-05 22:42:08
success: True
trace_id: 147589971178819098

Scan 6673758

duration: 0:00:11.314436

exit_message:

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

id: 6673758

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_newbookfeature_suggestions_attachments/2024-11-05/1730866298",
        "key": "raw/newbookdev_newbookfeature_suggestions_attachments/2024-11-05/1730866298/feature_suggestions_attachments.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 960232778806892384,
        "service_name": "drive-thru",
        "span_id": 11280898652741516609,
        "trace_id": 4226357262472033083
    }
}

running: False
schema_name_id: 2576
start_time: 2024-11-05 22:24:21
success: True
trace_id: 4226357262472033083

Scan 6671973

duration: 0:00:11.476873

exit_message:

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

id: 6671973

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_newbookfeature_suggestions_attachments/2024-11-04/1730785714",
        "key": "raw/newbookdev_newbookfeature_suggestions_attachments/2024-11-04/1730785714/feature_suggestions_attachments.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10965052062720698673,
        "service_name": "drive-thru",
        "span_id": 15832196252518735086,
        "trace_id": 5738328744285469777
    }
}

running: False
schema_name_id: 2576
start_time: 2024-11-05 04:20:22
success: True
trace_id: 5738328744285469777

Scan 6670639

duration: 0:00:11.364500

exit_message:

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

id: 6670639

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_newbookfeature_suggestions_attachments/2024-11-04/1730785120",
        "key": "raw/newbookdev_newbookfeature_suggestions_attachments/2024-11-04/1730785120/feature_suggestions_attachments.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9638580827214627248,
        "service_name": "drive-thru",
        "span_id": 16930919156228775364,
        "trace_id": 158422780713227588
    }
}

running: False
schema_name_id: 2576
start_time: 2024-11-05 03:28:59
success: True
trace_id: 158422780713227588

Scan 6670629

duration: 0:00:11.312866

exit_message:

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

id: 6670629

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_newbookfeature_suggestions_attachments/2024-11-04/1730784815",
        "key": "raw/newbookdev_newbookfeature_suggestions_attachments/2024-11-04/1730784815/feature_suggestions_attachments.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15767046241007402588,
        "service_name": "drive-thru",
        "span_id": 7198863944370717063,
        "trace_id": 8972903624130153888
    }
}

running: False
schema_name_id: 2576
start_time: 2024-11-05 03:28:43
success: True
trace_id: 8972903624130153888

Scan 6669924

duration: 0:00:13.815832

exit_message:

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

id: 6669924

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_newbookfeature_suggestions_attachments/2024-11-04/1730784212",
        "key": "raw/newbookdev_newbookfeature_suggestions_attachments/2024-11-04/1730784212/feature_suggestions_attachments.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11480661563117112159,
        "service_name": "drive-thru",
        "span_id": 14174351881558064316,
        "trace_id": 567154385816641225
    }
}

running: False
schema_name_id: 2576
start_time: 2024-11-05 03:10:17
success: True
trace_id: 567154385816641225

Scan 6669134

duration: 0:00:11.345527

exit_message:

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

id: 6669134

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_newbookfeature_suggestions_attachments/2024-11-04/1730784049",
        "key": "raw/newbookdev_newbookfeature_suggestions_attachments/2024-11-04/1730784049/feature_suggestions_attachments.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5876399461999219796,
        "service_name": "drive-thru",
        "span_id": 14353294659282180977,
        "trace_id": 12503142265377032580
    }
}

running: False
schema_name_id: 2576
start_time: 2024-11-05 02:49:13
success: True
trace_id: 12503142265377032580

Scan 6668728

duration: 0:00:14.017513

exit_message:

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

id: 6668728

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_newbookfeature_suggestions_attachments/2024-11-04/1730783896",
        "key": "raw/newbookdev_newbookfeature_suggestions_attachments/2024-11-04/1730783896/feature_suggestions_attachments.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5064738915669101791,
        "service_name": "drive-thru",
        "span_id": 2150900099947522424,
        "trace_id": 13041499971791076158
    }
}

running: False
schema_name_id: 2576
start_time: 2024-11-05 02:38:33
success: True
trace_id: 13041499971791076158

Scan 6667758

duration: 0:00:11.479750

exit_message:

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

id: 6667758

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_newbookfeature_suggestions_attachments/2024-11-04/1730783763",
        "key": "raw/newbookdev_newbookfeature_suggestions_attachments/2024-11-04/1730783763/feature_suggestions_attachments.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5962488393628964100,
        "service_name": "drive-thru",
        "span_id": 15496064070863014,
        "trace_id": 6664255294179156186
    }
}

running: False
schema_name_id: 2576
start_time: 2024-11-05 02:12:58
success: True
trace_id: 6664255294179156186

Scan 6666598

duration: 0:00:11.416045

exit_message:

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

id: 6666598

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_newbookfeature_suggestions_attachments/2024-11-04/1730783661",
        "key": "raw/newbookdev_newbookfeature_suggestions_attachments/2024-11-04/1730783661/feature_suggestions_attachments.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15278757895318325831,
        "service_name": "drive-thru",
        "span_id": 9892380587226888228,
        "trace_id": 9889230179023716397
    }
}

running: False
schema_name_id: 2576
start_time: 2024-11-05 01:42:07
success: True
trace_id: 9889230179023716397

Scan 6666314

duration: 0:00:11.401403

exit_message:

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

id: 6666314

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_newbookfeature_suggestions_attachments/2024-11-04/1730783519",
        "key": "raw/newbookdev_newbookfeature_suggestions_attachments/2024-11-04/1730783519/feature_suggestions_attachments.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16733540483678726514,
        "service_name": "drive-thru",
        "span_id": 9771831822549653602,
        "trace_id": 15398568327418075526
    }
}

running: False
schema_name_id: 2576
start_time: 2024-11-05 01:34:45
success: True
trace_id: 15398568327418075526

Scan 6665169

duration: 0:00:13.879988

exit_message:

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

id: 6665169

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_newbookfeature_suggestions_attachments/2024-11-04/1730783301",
        "key": "raw/newbookdev_newbookfeature_suggestions_attachments/2024-11-04/1730783301/feature_suggestions_attachments.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 309087272433093141,
        "service_name": "drive-thru",
        "span_id": 2637584348192352322,
        "trace_id": 17704457582894776742
    }
}

running: False
schema_name_id: 2576
start_time: 2024-11-05 01:04:23
success: True
trace_id: 17704457582894776742

Scan 6664773

duration: 0:00:11.656903

exit_message:

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

id: 6664773

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_newbookfeature_suggestions_attachments/2024-11-04/1730782902",
        "key": "raw/newbookdev_newbookfeature_suggestions_attachments/2024-11-04/1730782902/feature_suggestions_attachments.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4648807025274416611,
        "service_name": "drive-thru",
        "span_id": 14358920159044702661,
        "trace_id": 17410031350666993271
    }
}

running: False
schema_name_id: 2576
start_time: 2024-11-05 00:53:48
success: True
trace_id: 17410031350666993271

Scan 6663585

duration: 0:00:13.903424

exit_message:

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

id: 6663585

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_newbookfeature_suggestions_attachments/2024-11-04/1730782749",
        "key": "raw/newbookdev_newbookfeature_suggestions_attachments/2024-11-04/1730782749/feature_suggestions_attachments.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfeature_suggestions_attachments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12139838436301549566,
        "service_name": "drive-thru",
        "span_id": 16871181295556062617,
        "trace_id": 9132996506470204208
    }
}

running: False
schema_name_id: 2576
start_time: 2024-11-05 00:22:50
success: True
trace_id: 9132996506470204208

Partitions:

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

Schema:

attributes:

{
    "content": "string",
    "content_type": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "suggestion_id": "string",
    "tenant": "string"
}

created: 2024-11-05 23:10:05

ddl:

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

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