Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloinvoiceitemtypeset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717634

created: 2026-04-17 03:04:22

ddl:

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

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

schema_attributes:

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

schema_name_id: 1651
schema_scan_id: 162167568
updated: 2026-04-17 03:04:34

Version 1716519

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1651
schema_scan_id: 162111967
updated: 2026-04-16 03:12:31

Version 1715203

created: 2026-04-15 03:04:47

ddl:

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

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

schema_attributes:

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

schema_name_id: 1651
schema_scan_id: 162055912
updated: 2026-04-15 03:05:00

Version 1714055

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1651
schema_scan_id: 162000547
updated: 2026-04-14 03:07:50

Version 1712767

created: 2026-04-13 02:57:55

ddl:

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

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

schema_attributes:

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

schema_name_id: 1651
schema_scan_id: 161941605
updated: 2026-04-13 02:58:09

Version 1711571

created: 2026-04-12 03:00:02

ddl:

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

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

schema_attributes:

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

schema_name_id: 1651
schema_scan_id: 161892530
updated: 2026-04-12 03:00:23

Version 1710441

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1651
schema_scan_id: 161841227
updated: 2026-04-11 03:06:24

Version 1709218

created: 2026-04-10 03:05:08

ddl:

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

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

schema_attributes:

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

schema_name_id: 1651
schema_scan_id: 161785901
updated: 2026-04-10 03:05:19

Version 1708120

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1651
schema_scan_id: 161730250
updated: 2026-04-09 03:03:24

Version 1706950

created: 2026-04-08 03:07:34

ddl:

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

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

schema_attributes:

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

schema_name_id: 1651
schema_scan_id: 161675596
updated: 2026-04-08 03:07:45

Version 1705707

created: 2026-04-07 02:57:11

ddl:

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

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

schema_attributes:

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

schema_name_id: 1651
schema_scan_id: 161618409
updated: 2026-04-07 02:57:25

Version 1704563

created: 2026-04-06 03:08:38

ddl:

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

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

schema_attributes:

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

schema_name_id: 1651
schema_scan_id: 161561682
updated: 2026-04-06 03:08:49

Version 1703211

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1651
schema_scan_id: 161514771
updated: 2026-04-05 03:01:46

Version 1702102

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1651
schema_scan_id: 161460202
updated: 2026-04-04 03:03:18

Version 1700909

created: 2026-04-03 03:08:37

ddl:

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

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

schema_attributes:

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

schema_name_id: 1651
schema_scan_id: 161401858
updated: 2026-04-03 03:08:51

Schema Scans: 15

Last at 2026-04-17 03:04:22

Scan 162167568

duration: 0:00:11.639820

exit_message:

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

id: 162167568

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_moloInvoiceItemTypeSet/2026-04-17/1776412777",
        "key": "raw/molo_moloInvoiceItemTypeSet/2026-04-17/1776412777/InvoiceItemTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceItemTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9711348500192491763,
        "service_name": "drive-thru",
        "span_id": 12157677119909933935,
        "trace_id": 5691171228123513384
    }
}

running: False
schema_name_id: 1651
start_time: 2026-04-17 03:04:22
success: True
trace_id: 5691171228123513384

Scan 162111967

duration: 0:00:11.510232

exit_message:

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

id: 162111967

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_moloInvoiceItemTypeSet/2026-04-16/1776326533",
        "key": "raw/molo_moloInvoiceItemTypeSet/2026-04-16/1776326533/InvoiceItemTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceItemTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12382903030489898434,
        "service_name": "drive-thru",
        "span_id": 11670468818237444511,
        "trace_id": 1361956183234248521
    }
}

running: False
schema_name_id: 1651
start_time: 2026-04-16 03:12:19
success: True
trace_id: 1361956183234248521

Scan 162055912

duration: 0:00:14.048030

exit_message:

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

id: 162055912

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_moloInvoiceItemTypeSet/2026-04-15/1776240003",
        "key": "raw/molo_moloInvoiceItemTypeSet/2026-04-15/1776240003/InvoiceItemTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceItemTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 709341107457511086,
        "service_name": "drive-thru",
        "span_id": 3555269868032673232,
        "trace_id": 12960499405786775834
    }
}

running: False
schema_name_id: 1651
start_time: 2026-04-15 03:04:46
success: True
trace_id: 12960499405786775834

Scan 162000547

duration: 0:00:14.071975

exit_message:

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

id: 162000547

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_moloInvoiceItemTypeSet/2026-04-14/1776153729",
        "key": "raw/molo_moloInvoiceItemTypeSet/2026-04-14/1776153729/InvoiceItemTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceItemTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1383455575652529351,
        "service_name": "drive-thru",
        "span_id": 11696361462939601675,
        "trace_id": 12281108455696159220
    }
}

running: False
schema_name_id: 1651
start_time: 2026-04-14 03:07:36
success: True
trace_id: 12281108455696159220

Scan 161941605

duration: 0:00:14.136595

exit_message:

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

id: 161941605

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_moloInvoiceItemTypeSet/2026-04-13/1776066924",
        "key": "raw/molo_moloInvoiceItemTypeSet/2026-04-13/1776066924/InvoiceItemTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceItemTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9177056079278008553,
        "service_name": "drive-thru",
        "span_id": 18026443486661754153,
        "trace_id": 4675632310369520054
    }
}

running: False
schema_name_id: 1651
start_time: 2026-04-13 02:57:55
success: True
trace_id: 4675632310369520054

Scan 161892530

duration: 0:00:32.232370

exit_message:

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

id: 161892530

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_moloInvoiceItemTypeSet/2026-04-12/1775980638",
        "key": "raw/molo_moloInvoiceItemTypeSet/2026-04-12/1775980638/InvoiceItemTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceItemTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15413319062419616165,
        "service_name": "drive-thru",
        "span_id": 10272285498990589740,
        "trace_id": 8031947562848815114
    }
}

running: False
schema_name_id: 1651
start_time: 2026-04-12 02:59:51
success: True
trace_id: 8031947562848815114

Scan 161841227

duration: 0:00:11.465417

exit_message:

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

id: 161841227

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_moloInvoiceItemTypeSet/2026-04-11/1775894399",
        "key": "raw/molo_moloInvoiceItemTypeSet/2026-04-11/1775894399/InvoiceItemTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceItemTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3200825736466586388,
        "service_name": "drive-thru",
        "span_id": 11700769907174898615,
        "trace_id": 14328427686791211710
    }
}

running: False
schema_name_id: 1651
start_time: 2026-04-11 03:06:12
success: True
trace_id: 14328427686791211710

Scan 161785901

duration: 0:00:11.631600

exit_message:

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

id: 161785901

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_moloInvoiceItemTypeSet/2026-04-10/1775808155",
        "key": "raw/molo_moloInvoiceItemTypeSet/2026-04-10/1775808155/InvoiceItemTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceItemTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14017814891838468377,
        "service_name": "drive-thru",
        "span_id": 7432507478916881023,
        "trace_id": 14313659045146544833
    }
}

running: False
schema_name_id: 1651
start_time: 2026-04-10 03:05:07
success: True
trace_id: 14313659045146544833

Scan 161730250

duration: 0:00:11.556869

exit_message:

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

id: 161730250

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_moloInvoiceItemTypeSet/2026-04-09/1775721493",
        "key": "raw/molo_moloInvoiceItemTypeSet/2026-04-09/1775721493/InvoiceItemTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceItemTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11191316140786714893,
        "service_name": "drive-thru",
        "span_id": 2403442657487643691,
        "trace_id": 4374125208514947960
    }
}

running: False
schema_name_id: 1651
start_time: 2026-04-09 03:03:12
success: True
trace_id: 4374125208514947960

Scan 161675596

duration: 0:00:11.436909

exit_message:

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

id: 161675596

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_moloInvoiceItemTypeSet/2026-04-08/1775635312",
        "key": "raw/molo_moloInvoiceItemTypeSet/2026-04-08/1775635312/InvoiceItemTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceItemTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3943732567068246558,
        "service_name": "drive-thru",
        "span_id": 15775880927391953346,
        "trace_id": 6972910327792066394
    }
}

running: False
schema_name_id: 1651
start_time: 2026-04-08 03:07:34
success: True
trace_id: 6972910327792066394

Scan 161618409

duration: 0:00:14.002080

exit_message:

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

id: 161618409

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_moloInvoiceItemTypeSet/2026-04-07/1775548474",
        "key": "raw/molo_moloInvoiceItemTypeSet/2026-04-07/1775548474/InvoiceItemTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceItemTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16967556543240571623,
        "service_name": "drive-thru",
        "span_id": 16794807292977521401,
        "trace_id": 11116908845240548618
    }
}

running: False
schema_name_id: 1651
start_time: 2026-04-07 02:57:11
success: True
trace_id: 11116908845240548618

Scan 161561682

duration: 0:00:11.533452

exit_message:

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

id: 161561682

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_moloInvoiceItemTypeSet/2026-04-06/1775462440",
        "key": "raw/molo_moloInvoiceItemTypeSet/2026-04-06/1775462440/InvoiceItemTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceItemTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10728663623257871762,
        "service_name": "drive-thru",
        "span_id": 53357159324881418,
        "trace_id": 7117498100379983411
    }
}

running: False
schema_name_id: 1651
start_time: 2026-04-06 03:08:38
success: True
trace_id: 7117498100379983411

Scan 161514771

duration: 0:00:14.008947

exit_message:

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

id: 161514771

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_moloInvoiceItemTypeSet/2026-04-05/1775376065",
        "key": "raw/molo_moloInvoiceItemTypeSet/2026-04-05/1775376065/InvoiceItemTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceItemTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4530150131240037416,
        "service_name": "drive-thru",
        "span_id": 13269485170688561548,
        "trace_id": 7415900114564141964
    }
}

running: False
schema_name_id: 1651
start_time: 2026-04-05 03:01:32
success: True
trace_id: 7415900114564141964

Scan 161460202

duration: 0:00:13.992766

exit_message:

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

id: 161460202

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_moloInvoiceItemTypeSet/2026-04-04/1775289548",
        "key": "raw/molo_moloInvoiceItemTypeSet/2026-04-04/1775289548/InvoiceItemTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceItemTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15331212032694792805,
        "service_name": "drive-thru",
        "span_id": 15126134754223432138,
        "trace_id": 14787467805929309451
    }
}

running: False
schema_name_id: 1651
start_time: 2026-04-04 03:03:05
success: True
trace_id: 14787467805929309451

Scan 161401858

duration: 0:00:13.976477

exit_message:

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

id: 161401858

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_moloInvoiceItemTypeSet/2026-04-03/1775203322",
        "key": "raw/molo_moloInvoiceItemTypeSet/2026-04-03/1775203322/InvoiceItemTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceItemTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3496115578174553542,
        "service_name": "drive-thru",
        "span_id": 13920115676923575244,
        "trace_id": 18077348244814991444
    }
}

running: False
schema_name_id: 1651
start_time: 2026-04-03 03:08:37
success: True
trace_id: 18077348244814991444

Partitions:

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

Schema:

attributes:

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

created: 2026-04-17 03:04:22

ddl:

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

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