Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookcontact_history

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748485

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `type`  string , `action`  string , `notes`  string , `timestamp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-05/1730866431'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-05/1730866431
id: 4748485
processed: 1

raw_data:

{
    "action": 5,
    "id": 2,
    "newbook_region": 0,
    "notes": 6,
    "tenant": 1,
    "timestamp": 7,
    "type": 4,
    "type_id": 3
}

schema_attributes:

{
    "action": "string",
    "id": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string",
    "timestamp": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2563
schema_scan_id: 6674517
updated: 2024-11-05 22:48:12

Version 4748075

created: 2024-11-05 22:34:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `type`  string , `action`  string , `notes`  string , `timestamp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-05/1730866349'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-05/1730866349
id: 4748075
processed: 1

raw_data:

{
    "action": 5,
    "id": 2,
    "newbook_region": 0,
    "notes": 6,
    "tenant": 1,
    "timestamp": 7,
    "type": 4,
    "type_id": 3
}

schema_attributes:

{
    "action": "string",
    "id": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string",
    "timestamp": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2563
schema_scan_id: 6674107
updated: 2024-11-05 22:34:17

Version 4747488

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `type`  string , `action`  string , `notes`  string , `timestamp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-05/1730866260'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-05/1730866260
id: 4747488
processed: 1

raw_data:

{
    "action": 5,
    "id": 2,
    "newbook_region": 0,
    "notes": 6,
    "tenant": 1,
    "timestamp": 7,
    "type": 4,
    "type_id": 3
}

schema_attributes:

{
    "action": "string",
    "id": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string",
    "timestamp": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2563
schema_scan_id: 6673520
updated: 2024-11-05 22:18:20

Version 4746692

created: 2024-11-05 04:16:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `type`  string , `action`  string , `notes`  string , `timestamp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-04/1730785680'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-04/1730785680
id: 4746692
processed: 1

raw_data:

{
    "action": 5,
    "id": 2,
    "newbook_region": 0,
    "notes": 6,
    "tenant": 1,
    "timestamp": 7,
    "type": 4,
    "type_id": 3
}

schema_attributes:

{
    "action": "string",
    "id": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string",
    "timestamp": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2563
schema_scan_id: 6671916
updated: 2024-11-05 04:16:56

Version 4746021

created: 2024-11-05 03:46:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `type`  string , `action`  string , `notes`  string , `timestamp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-04/1730785101'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-04/1730785101
id: 4746021
processed: 1

raw_data:

{
    "action": 5,
    "id": 2,
    "newbook_region": 0,
    "notes": 6,
    "tenant": 1,
    "timestamp": 7,
    "type": 4,
    "type_id": 3
}

schema_attributes:

{
    "action": "string",
    "id": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string",
    "timestamp": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2563
schema_scan_id: 6671242
updated: 2024-11-05 03:46:41

Version 4745173

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `type`  string , `action`  string , `notes`  string , `timestamp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-04/1730784795'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_history"
]

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

raw_data:

{
    "action": 5,
    "id": 2,
    "newbook_region": 0,
    "notes": 6,
    "tenant": 1,
    "timestamp": 7,
    "type": 4,
    "type_id": 3
}

schema_attributes:

{
    "action": "string",
    "id": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string",
    "timestamp": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2563
schema_scan_id: 6670390
updated: 2024-11-05 03:22:44

Version 4744799

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `type`  string , `action`  string , `notes`  string , `timestamp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-04/1730784192'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-04/1730784192
id: 4744799
processed: 1

raw_data:

{
    "action": 5,
    "id": 2,
    "newbook_region": 0,
    "notes": 6,
    "tenant": 1,
    "timestamp": 7,
    "type": 4,
    "type_id": 3
}

schema_attributes:

{
    "action": "string",
    "id": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string",
    "timestamp": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2563
schema_scan_id: 6670016
updated: 2024-11-05 03:12:52

Version 4743860

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `type`  string , `action`  string , `notes`  string , `timestamp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-04/1730784029'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-04/1730784029
id: 4743860
processed: 1

raw_data:

{
    "action": 5,
    "id": 2,
    "newbook_region": 0,
    "notes": 6,
    "tenant": 1,
    "timestamp": 7,
    "type": 4,
    "type_id": 3
}

schema_attributes:

{
    "action": "string",
    "id": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string",
    "timestamp": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2563
schema_scan_id: 6669077
updated: 2024-11-05 02:48:00

Version 4743278

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `type`  string , `action`  string , `notes`  string , `timestamp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-04/1730783881'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-04/1730783881
id: 4743278
processed: 1

raw_data:

{
    "action": 5,
    "id": 2,
    "newbook_region": 0,
    "notes": 6,
    "tenant": 1,
    "timestamp": 7,
    "type": 4,
    "type_id": 3
}

schema_attributes:

{
    "action": "string",
    "id": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string",
    "timestamp": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2563
schema_scan_id: 6668495
updated: 2024-11-05 02:32:33

Version 4742517

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `type`  string , `action`  string , `notes`  string , `timestamp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-04/1730783742'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_history"
]

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

raw_data:

{
    "action": 5,
    "id": 2,
    "newbook_region": 0,
    "notes": 6,
    "tenant": 1,
    "timestamp": 7,
    "type": 4,
    "type_id": 3
}

schema_attributes:

{
    "action": "string",
    "id": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string",
    "timestamp": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2563
schema_scan_id: 6667734
updated: 2024-11-05 02:12:34

Version 4741681

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `type`  string , `action`  string , `notes`  string , `timestamp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-04/1730783646'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_history"
]

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

raw_data:

{
    "action": 5,
    "id": 2,
    "newbook_region": 0,
    "notes": 6,
    "tenant": 1,
    "timestamp": 7,
    "type": 4,
    "type_id": 3
}

schema_attributes:

{
    "action": "string",
    "id": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string",
    "timestamp": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2563
schema_scan_id: 6666898
updated: 2024-11-05 01:50:10

Version 4740837

created: 2024-11-05 01:27:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `type`  string , `action`  string , `notes`  string , `timestamp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-04/1730783498'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_history"
]

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

raw_data:

{
    "action": 5,
    "id": 2,
    "newbook_region": 0,
    "notes": 6,
    "tenant": 1,
    "timestamp": 7,
    "type": 4,
    "type_id": 3
}

schema_attributes:

{
    "action": "string",
    "id": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string",
    "timestamp": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2563
schema_scan_id: 6666054
updated: 2024-11-05 01:27:58

Version 4739874

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `type`  string , `action`  string , `notes`  string , `timestamp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-04/1730783280'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-04/1730783280
id: 4739874
processed: 1

raw_data:

{
    "action": 5,
    "id": 2,
    "newbook_region": 0,
    "notes": 6,
    "tenant": 1,
    "timestamp": 7,
    "type": 4,
    "type_id": 3
}

schema_attributes:

{
    "action": "string",
    "id": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string",
    "timestamp": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2563
schema_scan_id: 6665091
updated: 2024-11-05 01:02:28

Version 4739199

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `type`  string , `action`  string , `notes`  string , `timestamp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-04/1730782882'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_history"
]

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

raw_data:

{
    "action": 5,
    "id": 2,
    "newbook_region": 0,
    "notes": 6,
    "tenant": 1,
    "timestamp": 7,
    "type": 4,
    "type_id": 3
}

schema_attributes:

{
    "action": "string",
    "id": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string",
    "timestamp": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2563
schema_scan_id: 6664415
updated: 2024-11-05 00:44:38

Version 4738314

created: 2024-11-05 00:21:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `type`  string , `action`  string , `notes`  string , `timestamp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-04/1730782744'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_history"
]

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

raw_data:

{
    "action": 5,
    "id": 2,
    "newbook_region": 0,
    "notes": 6,
    "tenant": 1,
    "timestamp": 7,
    "type": 4,
    "type_id": 3
}

schema_attributes:

{
    "action": "string",
    "id": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string",
    "timestamp": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2563
schema_scan_id: 6663523
updated: 2024-11-05 00:21:23

Schema Scans: 15

Last at 2024-11-05 22:47:58

Scan 6674517

duration: 0:00:14.139567

exit_message:

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

id: 6674517

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-05/1730866431",
        "key": "raw/newbookdev_newbookcontact_history/2024-11-05/1730866431/contact_history.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10713904036570865499,
        "service_name": "drive-thru",
        "span_id": 13583107196461571611,
        "trace_id": 6491880621830009119
    }
}

running: False
schema_name_id: 2563
start_time: 2024-11-05 22:47:58
success: True
trace_id: 6491880621830009119

Scan 6674107

duration: 0:00:14.104687

exit_message:

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

id: 6674107

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-05/1730866349",
        "key": "raw/newbookdev_newbookcontact_history/2024-11-05/1730866349/contact_history.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2775615944780045363,
        "service_name": "drive-thru",
        "span_id": 6632726535556250635,
        "trace_id": 2855136513635539949
    }
}

running: False
schema_name_id: 2563
start_time: 2024-11-05 22:34:03
success: True
trace_id: 2855136513635539949

Scan 6673520

duration: 0:00:11.387728

exit_message:

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

id: 6673520

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-05/1730866260",
        "key": "raw/newbookdev_newbookcontact_history/2024-11-05/1730866260/contact_history.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6007227908140752283,
        "service_name": "drive-thru",
        "span_id": 13289558378650623500,
        "trace_id": 17932407859626378633
    }
}

running: False
schema_name_id: 2563
start_time: 2024-11-05 22:18:08
success: True
trace_id: 17932407859626378633

Scan 6671916

duration: 0:00:11.748739

exit_message:

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

id: 6671916

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-04/1730785680",
        "key": "raw/newbookdev_newbookcontact_history/2024-11-04/1730785680/contact_history.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9990727620570404411,
        "service_name": "drive-thru",
        "span_id": 8588255004898632511,
        "trace_id": 12369172517779774355
    }
}

running: False
schema_name_id: 2563
start_time: 2024-11-05 04:16:44
success: True
trace_id: 12369172517779774355

Scan 6671242

duration: 0:00:14.102011

exit_message:

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

id: 6671242

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-04/1730785101",
        "key": "raw/newbookdev_newbookcontact_history/2024-11-04/1730785101/contact_history.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18113241753695422339,
        "service_name": "drive-thru",
        "span_id": 337506516390865533,
        "trace_id": 17520685659771732537
    }
}

running: False
schema_name_id: 2563
start_time: 2024-11-05 03:46:27
success: True
trace_id: 17520685659771732537

Scan 6670390

duration: 0:00:11.525677

exit_message:

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

id: 6670390

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-04/1730784795",
        "key": "raw/newbookdev_newbookcontact_history/2024-11-04/1730784795/contact_history.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10662178765494128837,
        "service_name": "drive-thru",
        "span_id": 16854032467375430095,
        "trace_id": 5676840149542063858
    }
}

running: False
schema_name_id: 2563
start_time: 2024-11-05 03:22:32
success: True
trace_id: 5676840149542063858

Scan 6670016

duration: 0:00:14.232594

exit_message:

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

id: 6670016

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-04/1730784192",
        "key": "raw/newbookdev_newbookcontact_history/2024-11-04/1730784192/contact_history.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6250013673342611047,
        "service_name": "drive-thru",
        "span_id": 2036717548987195420,
        "trace_id": 2762090194187875178
    }
}

running: False
schema_name_id: 2563
start_time: 2024-11-05 03:12:38
success: True
trace_id: 2762090194187875178

Scan 6669077

duration: 0:00:14.049368

exit_message:

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

id: 6669077

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-04/1730784029",
        "key": "raw/newbookdev_newbookcontact_history/2024-11-04/1730784029/contact_history.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7387377227479569281,
        "service_name": "drive-thru",
        "span_id": 3257461724891462307,
        "trace_id": 1071809196366454381
    }
}

running: False
schema_name_id: 2563
start_time: 2024-11-05 02:47:46
success: True
trace_id: 1071809196366454381

Scan 6668495

duration: 0:00:11.320764

exit_message:

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

id: 6668495

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-04/1730783881",
        "key": "raw/newbookdev_newbookcontact_history/2024-11-04/1730783881/contact_history.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14589589729729233879,
        "service_name": "drive-thru",
        "span_id": 5476764982237798706,
        "trace_id": 8828509189356186404
    }
}

running: False
schema_name_id: 2563
start_time: 2024-11-05 02:32:22
success: True
trace_id: 8828509189356186404

Scan 6667734

duration: 0:00:14.027462

exit_message:

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

id: 6667734

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-04/1730783742",
        "key": "raw/newbookdev_newbookcontact_history/2024-11-04/1730783742/contact_history.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10871119745250388753,
        "service_name": "drive-thru",
        "span_id": 13280291241479965902,
        "trace_id": 2110754735236099633
    }
}

running: False
schema_name_id: 2563
start_time: 2024-11-05 02:12:20
success: True
trace_id: 2110754735236099633

Scan 6666898

duration: 0:00:11.340926

exit_message:

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

id: 6666898

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-04/1730783646",
        "key": "raw/newbookdev_newbookcontact_history/2024-11-04/1730783646/contact_history.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7819530983555492109,
        "service_name": "drive-thru",
        "span_id": 12056805169682088095,
        "trace_id": 8699296319291431436
    }
}

running: False
schema_name_id: 2563
start_time: 2024-11-05 01:49:58
success: True
trace_id: 8699296319291431436

Scan 6666054

duration: 0:00:11.321796

exit_message:

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

id: 6666054

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-04/1730783498",
        "key": "raw/newbookdev_newbookcontact_history/2024-11-04/1730783498/contact_history.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10448030386894494799,
        "service_name": "drive-thru",
        "span_id": 17826239873186673930,
        "trace_id": 4162443086973550491
    }
}

running: False
schema_name_id: 2563
start_time: 2024-11-05 01:27:47
success: True
trace_id: 4162443086973550491

Scan 6665091

duration: 0:00:14.257030

exit_message:

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

id: 6665091

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-04/1730783280",
        "key": "raw/newbookdev_newbookcontact_history/2024-11-04/1730783280/contact_history.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3132889304634567654,
        "service_name": "drive-thru",
        "span_id": 13140170483873391817,
        "trace_id": 16724431266282482652
    }
}

running: False
schema_name_id: 2563
start_time: 2024-11-05 01:02:14
success: True
trace_id: 16724431266282482652

Scan 6664415

duration: 0:00:11.389769

exit_message:

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

id: 6664415

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-04/1730782882",
        "key": "raw/newbookdev_newbookcontact_history/2024-11-04/1730782882/contact_history.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 770772728686832735,
        "service_name": "drive-thru",
        "span_id": 8139780918971348154,
        "trace_id": 5915146814830935111
    }
}

running: False
schema_name_id: 2563
start_time: 2024-11-05 00:44:27
success: True
trace_id: 5915146814830935111

Scan 6663523

duration: 0:00:11.339492

exit_message:

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

id: 6663523

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-04/1730782744",
        "key": "raw/newbookdev_newbookcontact_history/2024-11-04/1730782744/contact_history.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11873674386174413886,
        "service_name": "drive-thru",
        "span_id": 7202070115044686422,
        "trace_id": 1205603926607149837
    }
}

running: False
schema_name_id: 2563
start_time: 2024-11-05 00:21:12
success: True
trace_id: 1205603926607149837

Partitions:

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

Schema:

attributes:

{
    "action": "string",
    "id": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string",
    "timestamp": "string",
    "type": "string",
    "type_id": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `type`  string , `action`  string , `notes`  string , `timestamp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-05/1730866431'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_history`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_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 17:48:06",
        "disabled": false,
        "format": "raw",
        "id": 2563,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookcontact_history"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "action": "string",
            "id": "string",
            "newbook_region": "string",
            "notes": "string",
            "tenant": "string",
            "timestamp": "string",
            "type": "string",
            "type_id": "string"
        },
        "created": "2024-11-05 22:47:58",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_history`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type_id`  string , `type`  string , `action`  string , `notes`  string , `timestamp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_history/2024-11-05/1730866431'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_history`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_history"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}