Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookreport_history

created: 2024-10-08 18:26:37
disabled: False
format: raw
id: 2976
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749199

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreport_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreport_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `report_settings`  string , `report_status`  string , `generated_by`  string , `generated_when`  string , `completed_when`  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_newbookreport_history/2024-11-05/1730866593'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreport_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreport_history/2024-11-05/1730866593
id: 4749199
processed: 1

raw_data:

{
    "action_id": 3,
    "completed_when": 8,
    "generated_by": 6,
    "generated_when": 7,
    "id": 2,
    "newbook_region": 0,
    "report_settings": 4,
    "report_status": 5,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "completed_when": "string",
    "generated_by": "string",
    "generated_when": "string",
    "id": "string",
    "newbook_region": "string",
    "report_settings": "string",
    "report_status": "string",
    "tenant": "string"
}

schema_name_id: 2976
schema_scan_id: 6675231
updated: 2024-11-05 23:27:30

Version 4748961

created: 2024-11-05 23:11:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreport_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreport_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `report_settings`  string , `report_status`  string , `generated_by`  string , `generated_when`  string , `completed_when`  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_newbookreport_history/2024-11-05/1730866535'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreport_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreport_history/2024-11-05/1730866535
id: 4748961
processed: 1

raw_data:

{
    "action_id": 3,
    "completed_when": 8,
    "generated_by": 6,
    "generated_when": 7,
    "id": 2,
    "newbook_region": 0,
    "report_settings": 4,
    "report_status": 5,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "completed_when": "string",
    "generated_by": "string",
    "generated_when": "string",
    "id": "string",
    "newbook_region": "string",
    "report_settings": "string",
    "report_status": "string",
    "tenant": "string"
}

schema_name_id: 2976
schema_scan_id: 6674993
updated: 2024-11-05 23:11:19

Version 4748432

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreport_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreport_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `report_settings`  string , `report_status`  string , `generated_by`  string , `generated_when`  string , `completed_when`  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_newbookreport_history/2024-11-05/1730866417'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreport_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreport_history/2024-11-05/1730866417
id: 4748432
processed: 1

raw_data:

{
    "action_id": 3,
    "completed_when": 8,
    "generated_by": 6,
    "generated_when": 7,
    "id": 2,
    "newbook_region": 0,
    "report_settings": 4,
    "report_status": 5,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "completed_when": "string",
    "generated_by": "string",
    "generated_when": "string",
    "id": "string",
    "newbook_region": "string",
    "report_settings": "string",
    "report_status": "string",
    "tenant": "string"
}

schema_name_id: 2976
schema_scan_id: 6674464
updated: 2024-11-05 22:46:13

Version 4746987

created: 2024-11-05 04:38:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreport_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreport_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `report_settings`  string , `report_status`  string , `generated_by`  string , `generated_when`  string , `completed_when`  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_newbookreport_history/2024-11-04/1730785786'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreport_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreport_history/2024-11-04/1730785786
id: 4746987
processed: 1

raw_data:

{
    "action_id": 3,
    "completed_when": 8,
    "generated_by": 6,
    "generated_when": 7,
    "id": 2,
    "newbook_region": 0,
    "report_settings": 4,
    "report_status": 5,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "completed_when": "string",
    "generated_by": "string",
    "generated_when": "string",
    "id": "string",
    "newbook_region": "string",
    "report_settings": "string",
    "report_status": "string",
    "tenant": "string"
}

schema_name_id: 2976
schema_scan_id: 6672218
updated: 2024-11-05 04:38:26

Version 4746423

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreport_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreport_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `report_settings`  string , `report_status`  string , `generated_by`  string , `generated_when`  string , `completed_when`  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_newbookreport_history/2024-11-04/1730785161'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreport_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreport_history/2024-11-04/1730785161
id: 4746423
processed: 1

raw_data:

{
    "action_id": 3,
    "completed_when": 8,
    "generated_by": 6,
    "generated_when": 7,
    "id": 2,
    "newbook_region": 0,
    "report_settings": 4,
    "report_status": 5,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "completed_when": "string",
    "generated_by": "string",
    "generated_when": "string",
    "id": "string",
    "newbook_region": "string",
    "report_settings": "string",
    "report_status": "string",
    "tenant": "string"
}

schema_name_id: 2976
schema_scan_id: 6671644
updated: 2024-11-05 04:02:36

Version 4745698

created: 2024-11-05 03:36:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreport_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreport_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `report_settings`  string , `report_status`  string , `generated_by`  string , `generated_when`  string , `completed_when`  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_newbookreport_history/2024-11-04/1730784856'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreport_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreport_history/2024-11-04/1730784856
id: 4745698
processed: 1

raw_data:

{
    "action_id": 3,
    "completed_when": 8,
    "generated_by": 6,
    "generated_when": 7,
    "id": 2,
    "newbook_region": 0,
    "report_settings": 4,
    "report_status": 5,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "completed_when": "string",
    "generated_by": "string",
    "generated_when": "string",
    "id": "string",
    "newbook_region": "string",
    "report_settings": "string",
    "report_status": "string",
    "tenant": "string"
}

schema_name_id: 2976
schema_scan_id: 6670915
updated: 2024-11-05 03:36:31

Version 4745132

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreport_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreport_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `report_settings`  string , `report_status`  string , `generated_by`  string , `generated_when`  string , `completed_when`  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_newbookreport_history/2024-11-04/1730784252'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreport_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreport_history/2024-11-04/1730784252
id: 4745132
processed: 1

raw_data:

{
    "action_id": 3,
    "completed_when": 8,
    "generated_by": 6,
    "generated_when": 7,
    "id": 2,
    "newbook_region": 0,
    "report_settings": 4,
    "report_status": 5,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "completed_when": "string",
    "generated_by": "string",
    "generated_when": "string",
    "id": "string",
    "newbook_region": "string",
    "report_settings": "string",
    "report_status": "string",
    "tenant": "string"
}

schema_name_id: 2976
schema_scan_id: 6670349
updated: 2024-11-05 03:21:37

Version 4743655

created: 2024-11-05 02:42:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreport_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreport_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `report_settings`  string , `report_status`  string , `generated_by`  string , `generated_when`  string , `completed_when`  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_newbookreport_history/2024-11-04/1730784090'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreport_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreport_history/2024-11-04/1730784090
id: 4743655
processed: 1

raw_data:

{
    "action_id": 3,
    "completed_when": 8,
    "generated_by": 6,
    "generated_when": 7,
    "id": 2,
    "newbook_region": 0,
    "report_settings": 4,
    "report_status": 5,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "completed_when": "string",
    "generated_by": "string",
    "generated_when": "string",
    "id": "string",
    "newbook_region": "string",
    "report_settings": "string",
    "report_status": "string",
    "tenant": "string"
}

schema_name_id: 2976
schema_scan_id: 6668872
updated: 2024-11-05 02:42:34

Version 4743475

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreport_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreport_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `report_settings`  string , `report_status`  string , `generated_by`  string , `generated_when`  string , `completed_when`  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_newbookreport_history/2024-11-04/1730783926'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreport_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreport_history/2024-11-04/1730783926
id: 4743475
processed: 1

raw_data:

{
    "action_id": 3,
    "completed_when": 8,
    "generated_by": 6,
    "generated_when": 7,
    "id": 2,
    "newbook_region": 0,
    "report_settings": 4,
    "report_status": 5,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "completed_when": "string",
    "generated_by": "string",
    "generated_when": "string",
    "id": "string",
    "newbook_region": "string",
    "report_settings": "string",
    "report_status": "string",
    "tenant": "string"
}

schema_name_id: 2976
schema_scan_id: 6668692
updated: 2024-11-05 02:37:50

Version 4742725

created: 2024-11-05 02:17:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreport_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreport_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `report_settings`  string , `report_status`  string , `generated_by`  string , `generated_when`  string , `completed_when`  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_newbookreport_history/2024-11-04/1730783804'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreport_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreport_history/2024-11-04/1730783804
id: 4742725
processed: 1

raw_data:

{
    "action_id": 3,
    "completed_when": 8,
    "generated_by": 6,
    "generated_when": 7,
    "id": 2,
    "newbook_region": 0,
    "report_settings": 4,
    "report_status": 5,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "completed_when": "string",
    "generated_by": "string",
    "generated_when": "string",
    "id": "string",
    "newbook_region": "string",
    "report_settings": "string",
    "report_status": "string",
    "tenant": "string"
}

schema_name_id: 2976
schema_scan_id: 6667943
updated: 2024-11-05 02:17:58

Version 4742193

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreport_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreport_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `report_settings`  string , `report_status`  string , `generated_by`  string , `generated_when`  string , `completed_when`  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_newbookreport_history/2024-11-04/1730783692'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreport_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreport_history/2024-11-04/1730783692
id: 4742193
processed: 1

raw_data:

{
    "action_id": 3,
    "completed_when": 8,
    "generated_by": 6,
    "generated_when": 7,
    "id": 2,
    "newbook_region": 0,
    "report_settings": 4,
    "report_status": 5,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "completed_when": "string",
    "generated_by": "string",
    "generated_when": "string",
    "id": "string",
    "newbook_region": "string",
    "report_settings": "string",
    "report_status": "string",
    "tenant": "string"
}

schema_name_id: 2976
schema_scan_id: 6667410
updated: 2024-11-05 02:03:46

Version 4741291

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreport_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreport_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `report_settings`  string , `report_status`  string , `generated_by`  string , `generated_when`  string , `completed_when`  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_newbookreport_history/2024-11-04/1730783561'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreport_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreport_history/2024-11-04/1730783561
id: 4741291
processed: 1

raw_data:

{
    "action_id": 3,
    "completed_when": 8,
    "generated_by": 6,
    "generated_when": 7,
    "id": 2,
    "newbook_region": 0,
    "report_settings": 4,
    "report_status": 5,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "completed_when": "string",
    "generated_by": "string",
    "generated_when": "string",
    "id": "string",
    "newbook_region": "string",
    "report_settings": "string",
    "report_status": "string",
    "tenant": "string"
}

schema_name_id: 2976
schema_scan_id: 6666508
updated: 2024-11-05 01:40:02

Version 4740193

created: 2024-11-05 01:10:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreport_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreport_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `report_settings`  string , `report_status`  string , `generated_by`  string , `generated_when`  string , `completed_when`  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_newbookreport_history/2024-11-04/1730783342'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreport_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreport_history/2024-11-04/1730783342
id: 4740193
processed: 1

raw_data:

{
    "action_id": 3,
    "completed_when": 8,
    "generated_by": 6,
    "generated_when": 7,
    "id": 2,
    "newbook_region": 0,
    "report_settings": 4,
    "report_status": 5,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "completed_when": "string",
    "generated_by": "string",
    "generated_when": "string",
    "id": "string",
    "newbook_region": "string",
    "report_settings": "string",
    "report_status": "string",
    "tenant": "string"
}

schema_name_id: 2976
schema_scan_id: 6665410
updated: 2024-11-05 01:11:05

Version 4739555

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreport_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreport_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `report_settings`  string , `report_status`  string , `generated_by`  string , `generated_when`  string , `completed_when`  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_newbookreport_history/2024-11-04/1730782941'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreport_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreport_history/2024-11-04/1730782941
id: 4739555
processed: 1

raw_data:

{
    "action_id": 3,
    "completed_when": 8,
    "generated_by": 6,
    "generated_when": 7,
    "id": 2,
    "newbook_region": 0,
    "report_settings": 4,
    "report_status": 5,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "completed_when": "string",
    "generated_by": "string",
    "generated_when": "string",
    "id": "string",
    "newbook_region": "string",
    "report_settings": "string",
    "report_status": "string",
    "tenant": "string"
}

schema_name_id: 2976
schema_scan_id: 6664770
updated: 2024-11-05 00:53:52

Version 4739014

created: 2024-11-05 00:39:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreport_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreport_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `report_settings`  string , `report_status`  string , `generated_by`  string , `generated_when`  string , `completed_when`  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_newbookreport_history/2024-11-04/1730782832'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreport_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreport_history/2024-11-04/1730782832
id: 4739014
processed: 1

raw_data:

{
    "action_id": 3,
    "completed_when": 8,
    "generated_by": 6,
    "generated_when": 7,
    "id": 2,
    "newbook_region": 0,
    "report_settings": 4,
    "report_status": 5,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "completed_when": "string",
    "generated_by": "string",
    "generated_when": "string",
    "id": "string",
    "newbook_region": "string",
    "report_settings": "string",
    "report_status": "string",
    "tenant": "string"
}

schema_name_id: 2976
schema_scan_id: 6664229
updated: 2024-11-05 00:39:50

Schema Scans: 15

Last at 2024-11-05 23:27:18

Scan 6675231

duration: 0:00:11.645000

exit_message:

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

id: 6675231

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_newbookreport_history/2024-11-05/1730866593",
        "key": "raw/newbookdev_newbookreport_history/2024-11-05/1730866593/report_history.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreport_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9112379658989072358,
        "service_name": "drive-thru",
        "span_id": 4190879723568466224,
        "trace_id": 9251882597319069606
    }
}

running: False
schema_name_id: 2976
start_time: 2024-11-05 23:27:18
success: True
trace_id: 9251882597319069606

Scan 6674993

duration: 0:00:11.722499

exit_message:

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

id: 6674993

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_newbookreport_history/2024-11-05/1730866535",
        "key": "raw/newbookdev_newbookreport_history/2024-11-05/1730866535/report_history.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreport_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5114758706085592837,
        "service_name": "drive-thru",
        "span_id": 9631856999505680384,
        "trace_id": 15173166378170418085
    }
}

running: False
schema_name_id: 2976
start_time: 2024-11-05 23:11:07
success: True
trace_id: 15173166378170418085

Scan 6674464

duration: 0:00:11.571902

exit_message:

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

id: 6674464

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_newbookreport_history/2024-11-05/1730866417",
        "key": "raw/newbookdev_newbookreport_history/2024-11-05/1730866417/report_history.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreport_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8650621831457803737,
        "service_name": "drive-thru",
        "span_id": 13165647358369781516,
        "trace_id": 1255920556947579377
    }
}

running: False
schema_name_id: 2976
start_time: 2024-11-05 22:46:01
success: True
trace_id: 1255920556947579377

Scan 6672218

duration: 0:00:14.103919

exit_message:

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

id: 6672218

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_newbookreport_history/2024-11-04/1730785786",
        "key": "raw/newbookdev_newbookreport_history/2024-11-04/1730785786/report_history.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreport_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14910991092117099924,
        "service_name": "drive-thru",
        "span_id": 15212723350304607421,
        "trace_id": 17383428891420783522
    }
}

running: False
schema_name_id: 2976
start_time: 2024-11-05 04:38:12
success: True
trace_id: 17383428891420783522

Scan 6671644

duration: 0:00:11.663820

exit_message:

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

id: 6671644

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_newbookreport_history/2024-11-04/1730785161",
        "key": "raw/newbookdev_newbookreport_history/2024-11-04/1730785161/report_history.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreport_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14857196596218096685,
        "service_name": "drive-thru",
        "span_id": 5886988978898022598,
        "trace_id": 4249090977589499027
    }
}

running: False
schema_name_id: 2976
start_time: 2024-11-05 04:02:25
success: True
trace_id: 4249090977589499027

Scan 6670915

duration: 0:00:11.503422

exit_message:

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

id: 6670915

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_newbookreport_history/2024-11-04/1730784856",
        "key": "raw/newbookdev_newbookreport_history/2024-11-04/1730784856/report_history.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreport_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18438784078296489576,
        "service_name": "drive-thru",
        "span_id": 10161095549399397949,
        "trace_id": 15470514460606038272
    }
}

running: False
schema_name_id: 2976
start_time: 2024-11-05 03:36:20
success: True
trace_id: 15470514460606038272

Scan 6670349

duration: 0:00:11.369453

exit_message:

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

id: 6670349

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_newbookreport_history/2024-11-04/1730784252",
        "key": "raw/newbookdev_newbookreport_history/2024-11-04/1730784252/report_history.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreport_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15938740243312925269,
        "service_name": "drive-thru",
        "span_id": 13317651331917205907,
        "trace_id": 12900303879559291150
    }
}

running: False
schema_name_id: 2976
start_time: 2024-11-05 03:21:26
success: True
trace_id: 12900303879559291150

Scan 6668872

duration: 0:00:11.436040

exit_message:

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

id: 6668872

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_newbookreport_history/2024-11-04/1730784090",
        "key": "raw/newbookdev_newbookreport_history/2024-11-04/1730784090/report_history.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreport_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3247628598868704243,
        "service_name": "drive-thru",
        "span_id": 7231385012524943176,
        "trace_id": 11457273908744873417
    }
}

running: False
schema_name_id: 2976
start_time: 2024-11-05 02:42:22
success: True
trace_id: 11457273908744873417

Scan 6668692

duration: 0:00:11.424262

exit_message:

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

id: 6668692

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_newbookreport_history/2024-11-04/1730783926",
        "key": "raw/newbookdev_newbookreport_history/2024-11-04/1730783926/report_history.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreport_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17577211995219332317,
        "service_name": "drive-thru",
        "span_id": 5783107314365551681,
        "trace_id": 17538813835705532742
    }
}

running: False
schema_name_id: 2976
start_time: 2024-11-05 02:37:38
success: True
trace_id: 17538813835705532742

Scan 6667943

duration: 0:00:11.364686

exit_message:

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

id: 6667943

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_newbookreport_history/2024-11-04/1730783804",
        "key": "raw/newbookdev_newbookreport_history/2024-11-04/1730783804/report_history.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreport_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14340631364262013095,
        "service_name": "drive-thru",
        "span_id": 1231058716100498232,
        "trace_id": 2469902640968743587
    }
}

running: False
schema_name_id: 2976
start_time: 2024-11-05 02:17:47
success: True
trace_id: 2469902640968743587

Scan 6667410

duration: 0:00:11.413338

exit_message:

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

id: 6667410

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_newbookreport_history/2024-11-04/1730783692",
        "key": "raw/newbookdev_newbookreport_history/2024-11-04/1730783692/report_history.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreport_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11353088650358823751,
        "service_name": "drive-thru",
        "span_id": 14355604941606041081,
        "trace_id": 984958862638573140
    }
}

running: False
schema_name_id: 2976
start_time: 2024-11-05 02:03:35
success: True
trace_id: 984958862638573140

Scan 6666508

duration: 0:00:13.995095

exit_message:

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

id: 6666508

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_newbookreport_history/2024-11-04/1730783561",
        "key": "raw/newbookdev_newbookreport_history/2024-11-04/1730783561/report_history.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreport_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5231961843003066513,
        "service_name": "drive-thru",
        "span_id": 10016587098693296958,
        "trace_id": 11347889848165691533
    }
}

running: False
schema_name_id: 2976
start_time: 2024-11-05 01:39:48
success: True
trace_id: 11347889848165691533

Scan 6665410

duration: 0:00:14.046774

exit_message:

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

id: 6665410

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_newbookreport_history/2024-11-04/1730783342",
        "key": "raw/newbookdev_newbookreport_history/2024-11-04/1730783342/report_history.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreport_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5253185912068317131,
        "service_name": "drive-thru",
        "span_id": 8806710231286600891,
        "trace_id": 14889298580436524788
    }
}

running: False
schema_name_id: 2976
start_time: 2024-11-05 01:10:51
success: True
trace_id: 14889298580436524788

Scan 6664770

duration: 0:00:11.643543

exit_message:

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

id: 6664770

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_newbookreport_history/2024-11-04/1730782941",
        "key": "raw/newbookdev_newbookreport_history/2024-11-04/1730782941/report_history.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreport_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2264605382617769442,
        "service_name": "drive-thru",
        "span_id": 10757219089285877532,
        "trace_id": 15207921765774292092
    }
}

running: False
schema_name_id: 2976
start_time: 2024-11-05 00:53:40
success: True
trace_id: 15207921765774292092

Scan 6664229

duration: 0:00:13.922378

exit_message:

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

id: 6664229

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_newbookreport_history/2024-11-04/1730782832",
        "key": "raw/newbookdev_newbookreport_history/2024-11-04/1730782832/report_history.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreport_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13142746090229774495,
        "service_name": "drive-thru",
        "span_id": 5896645078289801759,
        "trace_id": 14615195650291273714
    }
}

running: False
schema_name_id: 2976
start_time: 2024-11-05 00:39:36
success: True
trace_id: 14615195650291273714

Partitions:

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

Schema:

attributes:

{
    "action_id": "string",
    "completed_when": "string",
    "generated_by": "string",
    "generated_when": "string",
    "id": "string",
    "newbook_region": "string",
    "report_settings": "string",
    "report_status": "string",
    "tenant": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreport_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `report_settings`  string , `report_status`  string , `generated_by`  string , `generated_when`  string , `completed_when`  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_newbookreport_history/2024-11-05/1730866593'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreport_history`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreport_history"
}

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