Schema Info

Schema Name: sfdl_prod_drivethru.molo_molovendorbillstatus

created: 2025-07-11 02:21:13
disabled: False
format: raw
id: 4264
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_prod_drivethru",
    "table": "molo_molovendorbillstatus"
}

type: drivethrucsv

Schema Versions: 15

Version 1717767

created: 2026-04-17 03:10:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillstatus`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillstatus`\n(\n `Status`  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-prod/raw/molo_moloVendorBillStatus/2026-04-17/1776413272'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillstatus"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillStatus/2026-04-17/1776413272
id: 1717767
processed: 1
raw_data:
```
{
    "Status": 0
}
```
schema_attributes:
```
{
    "Status": "string"
}
```
schema_name_id: 4264
schema_scan_id: 162167788
updated: 2026-04-17 03:10:23

Version 1716515

created: 2026-04-16 03:12:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillstatus`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillstatus`\n(\n `Status`  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-prod/raw/molo_moloVendorBillStatus/2026-04-16/1776326749'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillstatus"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillStatus/2026-04-16/1776326749
id: 1716515
processed: 1
raw_data:
```
{
    "Status": 0
}
```
schema_attributes:
```
{
    "Status": "string"
}
```
schema_name_id: 4264
schema_scan_id: 162111962
updated: 2026-04-16 03:12:23

Version 1715364

created: 2026-04-15 03:12:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillstatus`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillstatus`\n(\n `Status`  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-prod/raw/molo_moloVendorBillStatus/2026-04-15/1776240211'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillstatus"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillStatus/2026-04-15/1776240211
id: 1715364
processed: 1
raw_data:
```
{
    "Status": 0
}
```
schema_attributes:
```
{
    "Status": "string"
}
```
schema_name_id: 4264
schema_scan_id: 162056165
updated: 2026-04-15 03:12:31

Version 1714210

created: 2026-04-14 03:13:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillstatus`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillstatus`\n(\n `Status`  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-prod/raw/molo_moloVendorBillStatus/2026-04-14/1776154174'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillstatus"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillStatus/2026-04-14/1776154174
id: 1714210
processed: 1
raw_data:
```
{
    "Status": 0
}
```
schema_attributes:
```
{
    "Status": "string"
}
```
schema_name_id: 4264
schema_scan_id: 162000735
updated: 2026-04-14 03:13:46

Version 1712896

created: 2026-04-13 03:03:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillstatus`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillstatus`\n(\n `Status`  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-prod/raw/molo_moloVendorBillStatus/2026-04-13/1776067166'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillstatus"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillStatus/2026-04-13/1776067166
id: 1712896
processed: 1
raw_data:
```
{
    "Status": 0
}
```
schema_attributes:
```
{
    "Status": "string"
}
```
schema_name_id: 4264
schema_scan_id: 161942579
updated: 2026-04-13 03:03:45

Version 1711726

created: 2026-04-12 03:06:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillstatus`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillstatus`\n(\n `Status`  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-prod/raw/molo_moloVendorBillStatus/2026-04-12/1775980870'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillstatus"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillStatus/2026-04-12/1775980870
id: 1711726
processed: 1
raw_data:
```
{
    "Status": 0
}
```
schema_attributes:
```
{
    "Status": "string"
}
```
schema_name_id: 4264
schema_scan_id: 161893406
updated: 2026-04-12 03:07:08

Version 1710461

created: 2026-04-11 03:06:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillstatus`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillstatus`\n(\n `Status`  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-prod/raw/molo_moloVendorBillStatus/2026-04-11/1775894646'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillstatus"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillStatus/2026-04-11/1775894646
id: 1710461
processed: 1
raw_data:
```
{
    "Status": 0
}
```
schema_attributes:
```
{
    "Status": "string"
}
```
schema_name_id: 4264
schema_scan_id: 161841250
updated: 2026-04-11 03:07:10

Version 1709336

created: 2026-04-10 03:09:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillstatus`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillstatus`\n(\n `Status`  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-prod/raw/molo_moloVendorBillStatus/2026-04-10/1775808401'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillstatus"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillStatus/2026-04-10/1775808401
id: 1709336
processed: 1
raw_data:
```
{
    "Status": 0
}
```
schema_attributes:
```
{
    "Status": "string"
}
```
schema_name_id: 4264
schema_scan_id: 161786035
updated: 2026-04-10 03:09:52

Version 1708143

created: 2026-04-09 03:04:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillstatus`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillstatus`\n(\n `Status`  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-prod/raw/molo_moloVendorBillStatus/2026-04-09/1775721730'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillstatus"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillStatus/2026-04-09/1775721730
id: 1708143
processed: 1
raw_data:
```
{
    "Status": 0
}
```
schema_attributes:
```
{
    "Status": "string"
}
```
schema_name_id: 4264
schema_scan_id: 161730311
updated: 2026-04-09 03:04:23

Version 1707076

created: 2026-04-08 03:12:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillstatus`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillstatus`\n(\n `Status`  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-prod/raw/molo_moloVendorBillStatus/2026-04-08/1775635560'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillstatus"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillStatus/2026-04-08/1775635560
id: 1707076
processed: 1
raw_data:
```
{
    "Status": 0
}
```
schema_attributes:
```
{
    "Status": "string"
}
```
schema_name_id: 4264
schema_scan_id: 161675753
updated: 2026-04-08 03:13:12

Version 1705828

created: 2026-04-07 03:02:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillstatus`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillstatus`\n(\n `Status`  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-prod/raw/molo_moloVendorBillStatus/2026-04-07/1775548720'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillstatus"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillStatus/2026-04-07/1775548720
id: 1705828
processed: 1
raw_data:
```
{
    "Status": 0
}
```
schema_attributes:
```
{
    "Status": "string"
}
```
schema_name_id: 4264
schema_scan_id: 161619247
updated: 2026-04-07 03:02:37

Version 1704619

created: 2026-04-06 03:10:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillstatus`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillstatus`\n(\n `Status`  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-prod/raw/molo_moloVendorBillStatus/2026-04-06/1775462672'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillstatus"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillStatus/2026-04-06/1775462672
id: 1704619
processed: 1
raw_data:
```
{
    "Status": 0
}
```
schema_attributes:
```
{
    "Status": "string"
}
```
schema_name_id: 4264
schema_scan_id: 161561767
updated: 2026-04-06 03:11:06

Version 1703399

created: 2026-04-05 03:09:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillstatus`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillstatus`\n(\n `Status`  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-prod/raw/molo_moloVendorBillStatus/2026-04-05/1775376301'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillstatus"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillStatus/2026-04-05/1775376301
id: 1703399
processed: 1
raw_data:
```
{
    "Status": 0
}
```
schema_attributes:
```
{
    "Status": "string"
}
```
schema_name_id: 4264
schema_scan_id: 161514984
updated: 2026-04-05 03:09:16

Version 1702301

created: 2026-04-04 03:12:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillstatus`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillstatus`\n(\n `Status`  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-prod/raw/molo_moloVendorBillStatus/2026-04-04/1775289786'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillstatus"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillStatus/2026-04-04/1775289786
id: 1702301
processed: 1
raw_data:
```
{
    "Status": 0
}
```
schema_attributes:
```
{
    "Status": "string"
}
```
schema_name_id: 4264
schema_scan_id: 161460630
updated: 2026-04-04 03:12:15

Version 1701032

created: 2026-04-03 03:13:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillstatus`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillstatus`\n(\n `Status`  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-prod/raw/molo_moloVendorBillStatus/2026-04-03/1775203551'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillstatus"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillStatus/2026-04-03/1775203551
id: 1701032
processed: 1
raw_data:
```
{
    "Status": 0
}
```
schema_attributes:
```
{
    "Status": "string"
}
```
schema_name_id: 4264
schema_scan_id: 161402011
updated: 2026-04-03 03:14:05

Schema Scans: 15

Last at 2026-04-17 03:10:11

Scan 162167788

duration: 0:00:11.408962

exit_message:

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

id: 162167788

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillStatus/2026-04-17/1776413272",
        "key": "raw/molo_moloVendorBillStatus/2026-04-17/1776413272/VendorBillStatus.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBillStatus",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4075643150813570875,
        "service_name": "drive-thru",
        "span_id": 5287646568996713680,
        "trace_id": 5525339945579858362
    }
}

running: False
schema_name_id: 4264
start_time: 2026-04-17 03:10:11
success: True
trace_id: 5525339945579858362

Scan 162111962

duration: 0:00:11.522796

exit_message:

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

id: 162111962

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillStatus/2026-04-16/1776326749",
        "key": "raw/molo_moloVendorBillStatus/2026-04-16/1776326749/VendorBillStatus.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBillStatus",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13730252041079145566,
        "service_name": "drive-thru",
        "span_id": 11897373364406595836,
        "trace_id": 14108255390389678959
    }
}

running: False
schema_name_id: 4264
start_time: 2026-04-16 03:12:12
success: True
trace_id: 14108255390389678959

Scan 162056165

duration: 0:00:11.489934

exit_message:

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

id: 162056165

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillStatus/2026-04-15/1776240211",
        "key": "raw/molo_moloVendorBillStatus/2026-04-15/1776240211/VendorBillStatus.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBillStatus",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1741850782315742891,
        "service_name": "drive-thru",
        "span_id": 4536262312062916360,
        "trace_id": 3821753179876362269
    }
}

running: False
schema_name_id: 4264
start_time: 2026-04-15 03:12:19
success: True
trace_id: 3821753179876362269

Scan 162000735

duration: 0:00:14.022328

exit_message:

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

id: 162000735

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillStatus/2026-04-14/1776154174",
        "key": "raw/molo_moloVendorBillStatus/2026-04-14/1776154174/VendorBillStatus.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBillStatus",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11768175773644045858,
        "service_name": "drive-thru",
        "span_id": 16796309182527425901,
        "trace_id": 2007430958644918449
    }
}

running: False
schema_name_id: 4264
start_time: 2026-04-14 03:13:32
success: True
trace_id: 2007430958644918449

Scan 161942579

duration: 0:00:11.492410

exit_message:

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

id: 161942579

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillStatus/2026-04-13/1776067166",
        "key": "raw/molo_moloVendorBillStatus/2026-04-13/1776067166/VendorBillStatus.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBillStatus",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16040127996458584040,
        "service_name": "drive-thru",
        "span_id": 10920034792433919806,
        "trace_id": 10246609670541608006
    }
}

running: False
schema_name_id: 4264
start_time: 2026-04-13 03:03:33
success: True
trace_id: 10246609670541608006

Scan 161893406

duration: 0:00:14.022365

exit_message:

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

id: 161893406

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillStatus/2026-04-12/1775980870",
        "key": "raw/molo_moloVendorBillStatus/2026-04-12/1775980870/VendorBillStatus.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBillStatus",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6136377059255675225,
        "service_name": "drive-thru",
        "span_id": 15320134768376393336,
        "trace_id": 1249970011251244664
    }
}

running: False
schema_name_id: 4264
start_time: 2026-04-12 03:06:54
success: True
trace_id: 1249970011251244664

Scan 161841250

duration: 0:00:13.956503

exit_message:

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

id: 161841250

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillStatus/2026-04-11/1775894646",
        "key": "raw/molo_moloVendorBillStatus/2026-04-11/1775894646/VendorBillStatus.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBillStatus",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8972781700733913967,
        "service_name": "drive-thru",
        "span_id": 13886554213974909651,
        "trace_id": 15591937089132776312
    }
}

running: False
schema_name_id: 4264
start_time: 2026-04-11 03:06:56
success: True
trace_id: 15591937089132776312

Scan 161786035

duration: 0:00:14.201714

exit_message:

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

id: 161786035

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillStatus/2026-04-10/1775808401",
        "key": "raw/molo_moloVendorBillStatus/2026-04-10/1775808401/VendorBillStatus.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBillStatus",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11677917533797342114,
        "service_name": "drive-thru",
        "span_id": 14752009607277153140,
        "trace_id": 8932042103645607257
    }
}

running: False
schema_name_id: 4264
start_time: 2026-04-10 03:09:37
success: True
trace_id: 8932042103645607257

Scan 161730311

duration: 0:00:14.261685

exit_message:

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

id: 161730311

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillStatus/2026-04-09/1775721730",
        "key": "raw/molo_moloVendorBillStatus/2026-04-09/1775721730/VendorBillStatus.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBillStatus",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9677041722660009025,
        "service_name": "drive-thru",
        "span_id": 10320666545128690141,
        "trace_id": 14394506400354246054
    }
}

running: False
schema_name_id: 4264
start_time: 2026-04-09 03:04:08
success: True
trace_id: 14394506400354246054

Scan 161675753

duration: 0:00:14.168071

exit_message:

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

id: 161675753

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillStatus/2026-04-08/1775635560",
        "key": "raw/molo_moloVendorBillStatus/2026-04-08/1775635560/VendorBillStatus.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBillStatus",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4086575705033636181,
        "service_name": "drive-thru",
        "span_id": 2860337142108163272,
        "trace_id": 15820218822148750102
    }
}

running: False
schema_name_id: 4264
start_time: 2026-04-08 03:12:58
success: True
trace_id: 15820218822148750102

Scan 161619247

duration: 0:00:14.105014

exit_message:

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

id: 161619247

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillStatus/2026-04-07/1775548720",
        "key": "raw/molo_moloVendorBillStatus/2026-04-07/1775548720/VendorBillStatus.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBillStatus",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8659451477107412741,
        "service_name": "drive-thru",
        "span_id": 13267825456532409380,
        "trace_id": 16906094324502839977
    }
}

running: False
schema_name_id: 4264
start_time: 2026-04-07 03:02:23
success: True
trace_id: 16906094324502839977

Scan 161561767

duration: 0:00:11.413504

exit_message:

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

id: 161561767

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillStatus/2026-04-06/1775462672",
        "key": "raw/molo_moloVendorBillStatus/2026-04-06/1775462672/VendorBillStatus.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBillStatus",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6168882590214007864,
        "service_name": "drive-thru",
        "span_id": 16975438921959761264,
        "trace_id": 9237398629677792980
    }
}

running: False
schema_name_id: 4264
start_time: 2026-04-06 03:10:54
success: True
trace_id: 9237398629677792980

Scan 161514984

duration: 0:00:11.398432

exit_message:

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

id: 161514984

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillStatus/2026-04-05/1775376301",
        "key": "raw/molo_moloVendorBillStatus/2026-04-05/1775376301/VendorBillStatus.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBillStatus",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3526017945174006579,
        "service_name": "drive-thru",
        "span_id": 4795538307035511501,
        "trace_id": 17155279755606149978
    }
}

running: False
schema_name_id: 4264
start_time: 2026-04-05 03:09:05
success: True
trace_id: 17155279755606149978

Scan 161460630

duration: 0:00:11.419630

exit_message:

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

id: 161460630

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillStatus/2026-04-04/1775289786",
        "key": "raw/molo_moloVendorBillStatus/2026-04-04/1775289786/VendorBillStatus.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBillStatus",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14447271968698818425,
        "service_name": "drive-thru",
        "span_id": 13431428543905595817,
        "trace_id": 16567193408570445429
    }
}

running: False
schema_name_id: 4264
start_time: 2026-04-04 03:12:04
success: True
trace_id: 16567193408570445429

Scan 161402011

duration: 0:00:14.044259

exit_message:

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

id: 161402011

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillStatus/2026-04-03/1775203551",
        "key": "raw/molo_moloVendorBillStatus/2026-04-03/1775203551/VendorBillStatus.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBillStatus",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14344713577362988587,
        "service_name": "drive-thru",
        "span_id": 3785112616348777592,
        "trace_id": 7527233487162462974
    }
}

running: False
schema_name_id: 4264
start_time: 2026-04-03 03:13:51
success: True
trace_id: 7527233487162462974

Partitions:

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

Schema:

attributes:
```
{
    "Status": "string"
}
```
created: 2026-04-17 03:10:12

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillstatus`\n(\n `Status`  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-prod/raw/molo_moloVendorBillStatus/2026-04-17/1776413272'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillstatus`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillstatus"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2025-07-11 02:21:13",
        "disabled": false,
        "format": "raw",
        "id": 4264,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molovendorbillstatus"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Status": "string"
        },
        "created": "2026-04-17 03:10:12",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillstatus`\n(\n `Status`  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-prod/raw/molo_moloVendorBillStatus/2026-04-17/1776413272'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillstatus`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillstatus"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}