Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloinvoicetypeset

created: 2023-10-17 01:57:22
disabled: False
format: raw
id: 1657
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717655

created: 2026-04-17 03:05:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoicetypeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoicetypeset`\n(\n `Id`  string , `Name`  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_moloInvoiceTypeSet/2026-04-17/1776412797'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoicetypeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceTypeSet/2026-04-17/1776412797
id: 1717655
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1657
schema_scan_id: 162167622
updated: 2026-04-17 03:05:38

Version 1716354

created: 2026-04-16 03:05:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoicetypeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoicetypeset`\n(\n `Id`  string , `Name`  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_moloInvoiceTypeSet/2026-04-16/1776326553'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoicetypeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceTypeSet/2026-04-16/1776326553
id: 1716354
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1657
schema_scan_id: 162111737
updated: 2026-04-16 03:05:46

Version 1715190

created: 2026-04-15 03:04:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoicetypeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoicetypeset`\n(\n `Id`  string , `Name`  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_moloInvoiceTypeSet/2026-04-15/1776240023'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoicetypeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceTypeSet/2026-04-15/1776240023
id: 1715190
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1657
schema_scan_id: 162055884
updated: 2026-04-15 03:04:17

Version 1714065

created: 2026-04-14 03:07:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoicetypeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoicetypeset`\n(\n `Id`  string , `Name`  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_moloInvoiceTypeSet/2026-04-14/1776153751'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoicetypeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceTypeSet/2026-04-14/1776153751
id: 1714065
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1657
schema_scan_id: 162000564
updated: 2026-04-14 03:08:11

Version 1712771

created: 2026-04-13 02:58:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoicetypeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoicetypeset`\n(\n `Id`  string , `Name`  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_moloInvoiceTypeSet/2026-04-13/1776066945'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoicetypeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceTypeSet/2026-04-13/1776066945
id: 1712771
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1657
schema_scan_id: 161941665
updated: 2026-04-13 02:58:33

Version 1711607

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoicetypeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoicetypeset`\n(\n `Id`  string , `Name`  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_moloInvoiceTypeSet/2026-04-12/1775980659'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoicetypeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceTypeSet/2026-04-12/1775980659
id: 1711607
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1657
schema_scan_id: 161892723
updated: 2026-04-12 03:01:28

Version 1710453

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoicetypeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoicetypeset`\n(\n `Id`  string , `Name`  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_moloInvoiceTypeSet/2026-04-11/1775894419'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoicetypeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceTypeSet/2026-04-11/1775894419
id: 1710453
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1657
schema_scan_id: 161841242
updated: 2026-04-11 03:06:50

Version 1709340

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoicetypeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoicetypeset`\n(\n `Id`  string , `Name`  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_moloInvoiceTypeSet/2026-04-10/1775808177'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoicetypeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceTypeSet/2026-04-10/1775808177
id: 1709340
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1657
schema_scan_id: 161786039
updated: 2026-04-10 03:09:54

Version 1708072

created: 2026-04-09 03:01:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoicetypeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoicetypeset`\n(\n `Id`  string , `Name`  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_moloInvoiceTypeSet/2026-04-09/1775721514'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoicetypeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceTypeSet/2026-04-09/1775721514
id: 1708072
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1657
schema_scan_id: 161730051
updated: 2026-04-09 03:01:33

Version 1706851

created: 2026-04-08 03:03:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoicetypeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoicetypeset`\n(\n `Id`  string , `Name`  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_moloInvoiceTypeSet/2026-04-08/1775635344'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoicetypeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceTypeSet/2026-04-08/1775635344
id: 1706851
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1657
schema_scan_id: 161675429
updated: 2026-04-08 03:03:33

Version 1705683

created: 2026-04-07 02:56:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoicetypeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoicetypeset`\n(\n `Id`  string , `Name`  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_moloInvoiceTypeSet/2026-04-07/1775548494'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoicetypeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceTypeSet/2026-04-07/1775548494
id: 1705683
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1657
schema_scan_id: 161618375
updated: 2026-04-07 02:56:29

Version 1704395

created: 2026-04-06 03:01:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoicetypeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoicetypeset`\n(\n `Id`  string , `Name`  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_moloInvoiceTypeSet/2026-04-06/1775462461'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoicetypeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceTypeSet/2026-04-06/1775462461
id: 1704395
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1657
schema_scan_id: 161561362
updated: 2026-04-06 03:01:27

Version 1703305

created: 2026-04-05 03:05:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoicetypeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoicetypeset`\n(\n `Id`  string , `Name`  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_moloInvoiceTypeSet/2026-04-05/1775376087'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoicetypeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceTypeSet/2026-04-05/1775376087
id: 1703305
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1657
schema_scan_id: 161514883
updated: 2026-04-05 03:05:35

Version 1702123

created: 2026-04-04 03:03:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoicetypeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoicetypeset`\n(\n `Id`  string , `Name`  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_moloInvoiceTypeSet/2026-04-04/1775289570'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoicetypeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceTypeSet/2026-04-04/1775289570
id: 1702123
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1657
schema_scan_id: 161460291
updated: 2026-04-04 03:04:01

Version 1700826

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoicetypeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoicetypeset`\n(\n `Id`  string , `Name`  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_moloInvoiceTypeSet/2026-04-03/1775203343'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoicetypeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceTypeSet/2026-04-03/1775203343
id: 1700826
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1657
schema_scan_id: 161401689
updated: 2026-04-03 03:04:26

Schema Scans: 15

Last at 2026-04-17 03:05:26

Scan 162167622

duration: 0:00:11.695771

exit_message:

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

id: 162167622

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_moloInvoiceTypeSet/2026-04-17/1776412797",
        "key": "raw/molo_moloInvoiceTypeSet/2026-04-17/1776412797/InvoiceTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 396528615322113081,
        "service_name": "drive-thru",
        "span_id": 511043716748308091,
        "trace_id": 3485162864241984496
    }
}

running: False
schema_name_id: 1657
start_time: 2026-04-17 03:05:26
success: True
trace_id: 3485162864241984496

Scan 162111737

duration: 0:00:14.207184

exit_message:

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

id: 162111737

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_moloInvoiceTypeSet/2026-04-16/1776326553",
        "key": "raw/molo_moloInvoiceTypeSet/2026-04-16/1776326553/InvoiceTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7266128084750492993,
        "service_name": "drive-thru",
        "span_id": 5727057957853569977,
        "trace_id": 7072136717423928243
    }
}

running: False
schema_name_id: 1657
start_time: 2026-04-16 03:05:32
success: True
trace_id: 7072136717423928243

Scan 162055884

duration: 0:00:11.699870

exit_message:

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

id: 162055884

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_moloInvoiceTypeSet/2026-04-15/1776240023",
        "key": "raw/molo_moloInvoiceTypeSet/2026-04-15/1776240023/InvoiceTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3907882474191023508,
        "service_name": "drive-thru",
        "span_id": 4285059800807552822,
        "trace_id": 337414629368370560
    }
}

running: False
schema_name_id: 1657
start_time: 2026-04-15 03:04:05
success: True
trace_id: 337414629368370560

Scan 162000564

duration: 0:00:11.660012

exit_message:

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

id: 162000564

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_moloInvoiceTypeSet/2026-04-14/1776153751",
        "key": "raw/molo_moloInvoiceTypeSet/2026-04-14/1776153751/InvoiceTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16332179954018216524,
        "service_name": "drive-thru",
        "span_id": 15673024288080553367,
        "trace_id": 3703485325422074951
    }
}

running: False
schema_name_id: 1657
start_time: 2026-04-14 03:07:59
success: True
trace_id: 3703485325422074951

Scan 161941665

duration: 0:00:11.737747

exit_message:

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

id: 161941665

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_moloInvoiceTypeSet/2026-04-13/1776066945",
        "key": "raw/molo_moloInvoiceTypeSet/2026-04-13/1776066945/InvoiceTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6062673320330089929,
        "service_name": "drive-thru",
        "span_id": 12863523829288978885,
        "trace_id": 16258291415140554585
    }
}

running: False
schema_name_id: 1657
start_time: 2026-04-13 02:58:21
success: True
trace_id: 16258291415140554585

Scan 161892723

duration: 0:00:11.556849

exit_message:

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

id: 161892723

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_moloInvoiceTypeSet/2026-04-12/1775980659",
        "key": "raw/molo_moloInvoiceTypeSet/2026-04-12/1775980659/InvoiceTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15031905924209996023,
        "service_name": "drive-thru",
        "span_id": 17760810341859681763,
        "trace_id": 13885016960308755279
    }
}

running: False
schema_name_id: 1657
start_time: 2026-04-12 03:01:16
success: True
trace_id: 13885016960308755279

Scan 161841242

duration: 0:00:11.589124

exit_message:

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

id: 161841242

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_moloInvoiceTypeSet/2026-04-11/1775894419",
        "key": "raw/molo_moloInvoiceTypeSet/2026-04-11/1775894419/InvoiceTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13691866223425666211,
        "service_name": "drive-thru",
        "span_id": 5299785440646257232,
        "trace_id": 2143155437586168283
    }
}

running: False
schema_name_id: 1657
start_time: 2026-04-11 03:06:39
success: True
trace_id: 2143155437586168283

Scan 161786039

duration: 0:00:14.234531

exit_message:

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

id: 161786039

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_moloInvoiceTypeSet/2026-04-10/1775808177",
        "key": "raw/molo_moloInvoiceTypeSet/2026-04-10/1775808177/InvoiceTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1332672429995423583,
        "service_name": "drive-thru",
        "span_id": 8454424068467434243,
        "trace_id": 7577969261276852369
    }
}

running: False
schema_name_id: 1657
start_time: 2026-04-10 03:09:40
success: True
trace_id: 7577969261276852369

Scan 161730051

duration: 0:00:11.611959

exit_message:

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

id: 161730051

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_moloInvoiceTypeSet/2026-04-09/1775721514",
        "key": "raw/molo_moloInvoiceTypeSet/2026-04-09/1775721514/InvoiceTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3595219173793558524,
        "service_name": "drive-thru",
        "span_id": 2167086732642843265,
        "trace_id": 1981907618775386777
    }
}

running: False
schema_name_id: 1657
start_time: 2026-04-09 03:01:21
success: True
trace_id: 1981907618775386777

Scan 161675429

duration: 0:00:14.071368

exit_message:

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

id: 161675429

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_moloInvoiceTypeSet/2026-04-08/1775635344",
        "key": "raw/molo_moloInvoiceTypeSet/2026-04-08/1775635344/InvoiceTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15053073865862369298,
        "service_name": "drive-thru",
        "span_id": 17146136257737244313,
        "trace_id": 9654525279073237760
    }
}

running: False
schema_name_id: 1657
start_time: 2026-04-08 03:03:19
success: True
trace_id: 9654525279073237760

Scan 161618375

duration: 0:00:11.487394

exit_message:

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

id: 161618375

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_moloInvoiceTypeSet/2026-04-07/1775548494",
        "key": "raw/molo_moloInvoiceTypeSet/2026-04-07/1775548494/InvoiceTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1755324266519720722,
        "service_name": "drive-thru",
        "span_id": 1300772042371056054,
        "trace_id": 17947288144935515425
    }
}

running: False
schema_name_id: 1657
start_time: 2026-04-07 02:56:17
success: True
trace_id: 17947288144935515425

Scan 161561362

duration: 0:00:14.115947

exit_message:

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

id: 161561362

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_moloInvoiceTypeSet/2026-04-06/1775462461",
        "key": "raw/molo_moloInvoiceTypeSet/2026-04-06/1775462461/InvoiceTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14856158922663665176,
        "service_name": "drive-thru",
        "span_id": 11618476012045140826,
        "trace_id": 4543217271856991917
    }
}

running: False
schema_name_id: 1657
start_time: 2026-04-06 03:01:13
success: True
trace_id: 4543217271856991917

Scan 161514883

duration: 0:00:14.232884

exit_message:

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

id: 161514883

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_moloInvoiceTypeSet/2026-04-05/1775376087",
        "key": "raw/molo_moloInvoiceTypeSet/2026-04-05/1775376087/InvoiceTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4011880352391049853,
        "service_name": "drive-thru",
        "span_id": 12090756620987627549,
        "trace_id": 4874907730256097037
    }
}

running: False
schema_name_id: 1657
start_time: 2026-04-05 03:05:21
success: True
trace_id: 4874907730256097037

Scan 161460291

duration: 0:00:11.600784

exit_message:

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

id: 161460291

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_moloInvoiceTypeSet/2026-04-04/1775289570",
        "key": "raw/molo_moloInvoiceTypeSet/2026-04-04/1775289570/InvoiceTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16096720113642431943,
        "service_name": "drive-thru",
        "span_id": 1509323182027224465,
        "trace_id": 10086237813796377209
    }
}

running: False
schema_name_id: 1657
start_time: 2026-04-04 03:03:50
success: True
trace_id: 10086237813796377209

Scan 161401689

duration: 0:00:14.164835

exit_message:

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

id: 161401689

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_moloInvoiceTypeSet/2026-04-03/1775203343",
        "key": "raw/molo_moloInvoiceTypeSet/2026-04-03/1775203343/InvoiceTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4166175117520912405,
        "service_name": "drive-thru",
        "span_id": 137091595483117203,
        "trace_id": 4208655627478091733
    }
}

running: False
schema_name_id: 1657
start_time: 2026-04-03 03:04:12
success: True
trace_id: 4208655627478091733

Partitions:

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

Schema:

attributes:

{
    "Id": "string",
    "Name": "string"
}

created: 2026-04-17 03:05:26

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoicetypeset`\n(\n `Id`  string , `Name`  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_moloInvoiceTypeSet/2026-04-17/1776412797'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoicetypeset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoicetypeset"
}

Server:

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

Raw:

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