Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons

created: 2024-10-08 18:10:49
disabled: False
format: raw
id: 2828
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748921

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `original_id`  string , `name`  string , `status_type`  string , `display_order`  string , `active`  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_newbookleads_status_reasons/2024-11-05/1730866537'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookleads_status_reasons/2024-11-05/1730866537
id: 4748921
processed: 1

raw_data:

{
    "active": 7,
    "display_order": 6,
    "id": 2,
    "name": 4,
    "newbook_region": 0,
    "original_id": 3,
    "status_type": 5,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "original_id": "string",
    "status_type": "string",
    "tenant": "string"
}

schema_name_id: 2828
schema_scan_id: 6674953
updated: 2024-11-05 23:09:08

Version 4748616

created: 2024-11-05 22:53:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `original_id`  string , `name`  string , `status_type`  string , `display_order`  string , `active`  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_newbookleads_status_reasons/2024-11-05/1730866475'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookleads_status_reasons/2024-11-05/1730866475
id: 4748616
processed: 1

raw_data:

{
    "active": 7,
    "display_order": 6,
    "id": 2,
    "name": 4,
    "newbook_region": 0,
    "original_id": 3,
    "status_type": 5,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "original_id": "string",
    "status_type": "string",
    "tenant": "string"
}

schema_name_id: 2828
schema_scan_id: 6674648
updated: 2024-11-05 22:53:47

Version 4747926

created: 2024-11-05 22:29:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `original_id`  string , `name`  string , `status_type`  string , `display_order`  string , `active`  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_newbookleads_status_reasons/2024-11-05/1730866341'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookleads_status_reasons/2024-11-05/1730866341
id: 4747926
processed: 1

raw_data:

{
    "active": 7,
    "display_order": 6,
    "id": 2,
    "name": 4,
    "newbook_region": 0,
    "original_id": 3,
    "status_type": 5,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "original_id": "string",
    "status_type": "string",
    "tenant": "string"
}

schema_name_id: 2828
schema_scan_id: 6673958
updated: 2024-11-05 22:29:50

Version 4746960

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `original_id`  string , `name`  string , `status_type`  string , `display_order`  string , `active`  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_newbookleads_status_reasons/2024-11-04/1730785745'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookleads_status_reasons/2024-11-04/1730785745
id: 4746960
processed: 1

raw_data:

{
    "active": 7,
    "display_order": 6,
    "id": 2,
    "name": 4,
    "newbook_region": 0,
    "original_id": 3,
    "status_type": 5,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "original_id": "string",
    "status_type": "string",
    "tenant": "string"
}

schema_name_id: 2828
schema_scan_id: 6672191
updated: 2024-11-05 04:35:51

Version 4746316

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `original_id`  string , `name`  string , `status_type`  string , `display_order`  string , `active`  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_newbookleads_status_reasons/2024-11-04/1730785138'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookleads_status_reasons/2024-11-04/1730785138
id: 4746316
processed: 1

raw_data:

{
    "active": 7,
    "display_order": 6,
    "id": 2,
    "name": 4,
    "newbook_region": 0,
    "original_id": 3,
    "status_type": 5,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "original_id": "string",
    "status_type": "string",
    "tenant": "string"
}

schema_name_id: 2828
schema_scan_id: 6671537
updated: 2024-11-05 03:58:02

Version 4745501

created: 2024-11-05 03:31:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `original_id`  string , `name`  string , `status_type`  string , `display_order`  string , `active`  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_newbookleads_status_reasons/2024-11-04/1730784833'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookleads_status_reasons/2024-11-04/1730784833
id: 4745501
processed: 1

raw_data:

{
    "active": 7,
    "display_order": 6,
    "id": 2,
    "name": 4,
    "newbook_region": 0,
    "original_id": 3,
    "status_type": 5,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "original_id": "string",
    "status_type": "string",
    "tenant": "string"
}

schema_name_id: 2828
schema_scan_id: 6670718
updated: 2024-11-05 03:31:17

Version 4744187

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `original_id`  string , `name`  string , `status_type`  string , `display_order`  string , `active`  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_newbookleads_status_reasons/2024-11-04/1730784229'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookleads_status_reasons/2024-11-04/1730784229
id: 4744187
processed: 1

raw_data:

{
    "active": 7,
    "display_order": 6,
    "id": 2,
    "name": 4,
    "newbook_region": 0,
    "original_id": 3,
    "status_type": 5,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "original_id": "string",
    "status_type": "string",
    "tenant": "string"
}

schema_name_id: 2828
schema_scan_id: 6669404
updated: 2024-11-05 02:56:28

Version 4744113

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `original_id`  string , `name`  string , `status_type`  string , `display_order`  string , `active`  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_newbookleads_status_reasons/2024-11-04/1730784067'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookleads_status_reasons/2024-11-04/1730784067
id: 4744113
processed: 1

raw_data:

{
    "active": 7,
    "display_order": 6,
    "id": 2,
    "name": 4,
    "newbook_region": 0,
    "original_id": 3,
    "status_type": 5,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "original_id": "string",
    "status_type": "string",
    "tenant": "string"
}

schema_name_id: 2828
schema_scan_id: 6669330
updated: 2024-11-05 02:54:33

Version 4742752

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `original_id`  string , `name`  string , `status_type`  string , `display_order`  string , `active`  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_newbookleads_status_reasons/2024-11-04/1730783781'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookleads_status_reasons/2024-11-04/1730783781
id: 4742752
processed: 1

raw_data:

{
    "active": 7,
    "display_order": 6,
    "id": 2,
    "name": 4,
    "newbook_region": 0,
    "original_id": 3,
    "status_type": 5,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "original_id": "string",
    "status_type": "string",
    "tenant": "string"
}

schema_name_id: 2828
schema_scan_id: 6667969
updated: 2024-11-05 02:18:43

Version 4742746

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `original_id`  string , `name`  string , `status_type`  string , `display_order`  string , `active`  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_newbookleads_status_reasons/2024-11-04/1730783909'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookleads_status_reasons/2024-11-04/1730783909
id: 4742746
processed: 1

raw_data:

{
    "active": 7,
    "display_order": 6,
    "id": 2,
    "name": 4,
    "newbook_region": 0,
    "original_id": 3,
    "status_type": 5,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "original_id": "string",
    "status_type": "string",
    "tenant": "string"
}

schema_name_id: 2828
schema_scan_id: 6667962
updated: 2024-11-05 02:18:33

Version 4742091

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `original_id`  string , `name`  string , `status_type`  string , `display_order`  string , `active`  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_newbookleads_status_reasons/2024-11-04/1730783675'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookleads_status_reasons/2024-11-04/1730783675
id: 4742091
processed: 1

raw_data:

{
    "active": 7,
    "display_order": 6,
    "id": 2,
    "name": 4,
    "newbook_region": 0,
    "original_id": 3,
    "status_type": 5,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "original_id": "string",
    "status_type": "string",
    "tenant": "string"
}

schema_name_id: 2828
schema_scan_id: 6667308
updated: 2024-11-05 02:01:00

Version 4741317

created: 2024-11-05 01:40:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `original_id`  string , `name`  string , `status_type`  string , `display_order`  string , `active`  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_newbookleads_status_reasons/2024-11-04/1730783537'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookleads_status_reasons/2024-11-04/1730783537
id: 4741317
processed: 1

raw_data:

{
    "active": 7,
    "display_order": 6,
    "id": 2,
    "name": 4,
    "newbook_region": 0,
    "original_id": 3,
    "status_type": 5,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "original_id": "string",
    "status_type": "string",
    "tenant": "string"
}

schema_name_id: 2828
schema_scan_id: 6666534
updated: 2024-11-05 01:40:39

Version 4740325

created: 2024-11-05 01:14:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `original_id`  string , `name`  string , `status_type`  string , `display_order`  string , `active`  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_newbookleads_status_reasons/2024-11-04/1730783318'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookleads_status_reasons/2024-11-04/1730783318
id: 4740325
processed: 1

raw_data:

{
    "active": 7,
    "display_order": 6,
    "id": 2,
    "name": 4,
    "newbook_region": 0,
    "original_id": 3,
    "status_type": 5,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "original_id": "string",
    "status_type": "string",
    "tenant": "string"
}

schema_name_id: 2828
schema_scan_id: 6665543
updated: 2024-11-05 01:14:32

Version 4739663

created: 2024-11-05 00:56:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `original_id`  string , `name`  string , `status_type`  string , `display_order`  string , `active`  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_newbookleads_status_reasons/2024-11-04/1730782919'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookleads_status_reasons/2024-11-04/1730782919
id: 4739663
processed: 1

raw_data:

{
    "active": 7,
    "display_order": 6,
    "id": 2,
    "name": 4,
    "newbook_region": 0,
    "original_id": 3,
    "status_type": 5,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "original_id": "string",
    "status_type": "string",
    "tenant": "string"
}

schema_name_id: 2828
schema_scan_id: 6664880
updated: 2024-11-05 00:56:46

Version 4738579

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `original_id`  string , `name`  string , `status_type`  string , `display_order`  string , `active`  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_newbookleads_status_reasons/2024-11-04/1730782754'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookleads_status_reasons/2024-11-04/1730782754
id: 4738579
processed: 1

raw_data:

{
    "active": 7,
    "display_order": 6,
    "id": 2,
    "name": 4,
    "newbook_region": 0,
    "original_id": 3,
    "status_type": 5,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "original_id": "string",
    "status_type": "string",
    "tenant": "string"
}

schema_name_id: 2828
schema_scan_id: 6663792
updated: 2024-11-05 00:28:19

Schema Scans: 15

Last at 2024-11-05 23:08:54

Scan 6674953

duration: 0:00:14.132412

exit_message:

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

id: 6674953

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_newbookleads_status_reasons/2024-11-05/1730866537",
        "key": "raw/newbookdev_newbookleads_status_reasons/2024-11-05/1730866537/leads_status_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11260164200044424084,
        "service_name": "drive-thru",
        "span_id": 3567769865645868443,
        "trace_id": 1920555004224177169
    }
}

running: False
schema_name_id: 2828
start_time: 2024-11-05 23:08:54
success: True
trace_id: 1920555004224177169

Scan 6674648

duration: 0:00:11.559638

exit_message:

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

id: 6674648

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_newbookleads_status_reasons/2024-11-05/1730866475",
        "key": "raw/newbookdev_newbookleads_status_reasons/2024-11-05/1730866475/leads_status_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13458581202390814810,
        "service_name": "drive-thru",
        "span_id": 1204859678850998198,
        "trace_id": 9404082760287274208
    }
}

running: False
schema_name_id: 2828
start_time: 2024-11-05 22:53:35
success: True
trace_id: 9404082760287274208

Scan 6673958

duration: 0:00:14.005833

exit_message:

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

id: 6673958

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_newbookleads_status_reasons/2024-11-05/1730866341",
        "key": "raw/newbookdev_newbookleads_status_reasons/2024-11-05/1730866341/leads_status_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9806113439932899581,
        "service_name": "drive-thru",
        "span_id": 10701169126171111688,
        "trace_id": 17853389234582649789
    }
}

running: False
schema_name_id: 2828
start_time: 2024-11-05 22:29:36
success: True
trace_id: 17853389234582649789

Scan 6672191

duration: 0:00:14.062259

exit_message:

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

id: 6672191

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_newbookleads_status_reasons/2024-11-04/1730785745",
        "key": "raw/newbookdev_newbookleads_status_reasons/2024-11-04/1730785745/leads_status_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4230060324665267606,
        "service_name": "drive-thru",
        "span_id": 9100803817874699420,
        "trace_id": 9823160177807337023
    }
}

running: False
schema_name_id: 2828
start_time: 2024-11-05 04:35:37
success: True
trace_id: 9823160177807337023

Scan 6671537

duration: 0:00:11.630776

exit_message:

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

id: 6671537

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_newbookleads_status_reasons/2024-11-04/1730785138",
        "key": "raw/newbookdev_newbookleads_status_reasons/2024-11-04/1730785138/leads_status_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11471676345225687072,
        "service_name": "drive-thru",
        "span_id": 4957313363678999810,
        "trace_id": 17333138739693045881
    }
}

running: False
schema_name_id: 2828
start_time: 2024-11-05 03:57:50
success: True
trace_id: 17333138739693045881

Scan 6670718

duration: 0:00:11.254166

exit_message:

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

id: 6670718

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_newbookleads_status_reasons/2024-11-04/1730784833",
        "key": "raw/newbookdev_newbookleads_status_reasons/2024-11-04/1730784833/leads_status_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2287986268132153060,
        "service_name": "drive-thru",
        "span_id": 17116750078295094558,
        "trace_id": 1309309416335568567
    }
}

running: False
schema_name_id: 2828
start_time: 2024-11-05 03:31:06
success: True
trace_id: 1309309416335568567

Scan 6669404

duration: 0:00:11.430169

exit_message:

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

id: 6669404

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_newbookleads_status_reasons/2024-11-04/1730784229",
        "key": "raw/newbookdev_newbookleads_status_reasons/2024-11-04/1730784229/leads_status_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7650290655809683222,
        "service_name": "drive-thru",
        "span_id": 17795632790857469337,
        "trace_id": 1545766122936449056
    }
}

running: False
schema_name_id: 2828
start_time: 2024-11-05 02:56:17
success: True
trace_id: 1545766122936449056

Scan 6669330

duration: 0:00:14.101270

exit_message:

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

id: 6669330

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_newbookleads_status_reasons/2024-11-04/1730784067",
        "key": "raw/newbookdev_newbookleads_status_reasons/2024-11-04/1730784067/leads_status_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8447444657563463505,
        "service_name": "drive-thru",
        "span_id": 4706543608584395571,
        "trace_id": 4890708167075099430
    }
}

running: False
schema_name_id: 2828
start_time: 2024-11-05 02:54:19
success: True
trace_id: 4890708167075099430

Scan 6667969

duration: 0:00:11.450667

exit_message:

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

id: 6667969

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_newbookleads_status_reasons/2024-11-04/1730783781",
        "key": "raw/newbookdev_newbookleads_status_reasons/2024-11-04/1730783781/leads_status_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1748211622667751578,
        "service_name": "drive-thru",
        "span_id": 6715877196376707797,
        "trace_id": 15138672003547196905
    }
}

running: False
schema_name_id: 2828
start_time: 2024-11-05 02:18:31
success: True
trace_id: 15138672003547196905

Scan 6667962

duration: 0:00:11.578202

exit_message:

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

id: 6667962

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_newbookleads_status_reasons/2024-11-04/1730783909",
        "key": "raw/newbookdev_newbookleads_status_reasons/2024-11-04/1730783909/leads_status_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2309446230632851118,
        "service_name": "drive-thru",
        "span_id": 18008367938101235606,
        "trace_id": 11403634483996702939
    }
}

running: False
schema_name_id: 2828
start_time: 2024-11-05 02:18:21
success: True
trace_id: 11403634483996702939

Scan 6667308

duration: 0:00:11.516324

exit_message:

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

id: 6667308

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_newbookleads_status_reasons/2024-11-04/1730783675",
        "key": "raw/newbookdev_newbookleads_status_reasons/2024-11-04/1730783675/leads_status_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7611902960448516504,
        "service_name": "drive-thru",
        "span_id": 9988541212260869400,
        "trace_id": 17383075021669183166
    }
}

running: False
schema_name_id: 2828
start_time: 2024-11-05 02:00:49
success: True
trace_id: 17383075021669183166

Scan 6666534

duration: 0:00:11.420712

exit_message:

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

id: 6666534

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_newbookleads_status_reasons/2024-11-04/1730783537",
        "key": "raw/newbookdev_newbookleads_status_reasons/2024-11-04/1730783537/leads_status_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14562651932813894155,
        "service_name": "drive-thru",
        "span_id": 4373435566119966036,
        "trace_id": 10851526520687428545
    }
}

running: False
schema_name_id: 2828
start_time: 2024-11-05 01:40:27
success: True
trace_id: 10851526520687428545

Scan 6665543

duration: 0:00:11.479520

exit_message:

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

id: 6665543

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_newbookleads_status_reasons/2024-11-04/1730783318",
        "key": "raw/newbookdev_newbookleads_status_reasons/2024-11-04/1730783318/leads_status_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7517053480130370881,
        "service_name": "drive-thru",
        "span_id": 7720601291366730421,
        "trace_id": 6129879910275216749
    }
}

running: False
schema_name_id: 2828
start_time: 2024-11-05 01:14:20
success: True
trace_id: 6129879910275216749

Scan 6664880

duration: 0:00:11.372758

exit_message:

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

id: 6664880

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_newbookleads_status_reasons/2024-11-04/1730782919",
        "key": "raw/newbookdev_newbookleads_status_reasons/2024-11-04/1730782919/leads_status_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8635771079091577099,
        "service_name": "drive-thru",
        "span_id": 9940506261134102667,
        "trace_id": 6540463092972071346
    }
}

running: False
schema_name_id: 2828
start_time: 2024-11-05 00:56:34
success: True
trace_id: 6540463092972071346

Scan 6663792

duration: 0:00:11.420554

exit_message:

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

id: 6663792

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_newbookleads_status_reasons/2024-11-04/1730782754",
        "key": "raw/newbookdev_newbookleads_status_reasons/2024-11-04/1730782754/leads_status_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14569077173183899235,
        "service_name": "drive-thru",
        "span_id": 15191484605625659237,
        "trace_id": 15850909361649749877
    }
}

running: False
schema_name_id: 2828
start_time: 2024-11-05 00:28:08
success: True
trace_id: 15850909361649749877

Partitions:

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

Schema:

attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "original_id": "string",
    "status_type": "string",
    "tenant": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `original_id`  string , `name`  string , `status_type`  string , `display_order`  string , `active`  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_newbookleads_status_reasons/2024-11-05/1730866537'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookleads_status_reasons"
}

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