Schema Info

Schema Name: sfdl_prod_drivethru.molo_molocontracttypeset

created: 2025-04-11 02:00:12
disabled: False
format: raw
id: 3479
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717565

created: 2026-04-17 02:59:57

ddl:

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

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

schema_attributes:

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

schema_name_id: 3479
schema_scan_id: 162167170
updated: 2026-04-17 03:00:10

Version 1716326

created: 2026-04-16 03:04:02

ddl:

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

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

schema_attributes:

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

schema_name_id: 3479
schema_scan_id: 162111678
updated: 2026-04-16 03:04:13

Version 1715142

created: 2026-04-15 03:01:24

ddl:

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

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

schema_attributes:

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

schema_name_id: 3479
schema_scan_id: 162055676
updated: 2026-04-15 03:01:35

Version 1713932

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 3479
schema_scan_id: 162000318
updated: 2026-04-14 03:02:01

Version 1712731

created: 2026-04-13 02:56:16

ddl:

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

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

schema_attributes:

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

schema_name_id: 3479
schema_scan_id: 161941511
updated: 2026-04-13 02:56:27

Version 1711515

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 3479
schema_scan_id: 161892279
updated: 2026-04-12 02:57:11

Version 1710382

created: 2026-04-11 03:03:45

ddl:

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

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

schema_attributes:

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

schema_name_id: 3479
schema_scan_id: 161841127
updated: 2026-04-11 03:03:59

Version 1709159

created: 2026-04-10 03:02:30

ddl:

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

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

schema_attributes:

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

schema_name_id: 3479
schema_scan_id: 161785798
updated: 2026-04-10 03:02:44

Version 1708028

created: 2026-04-09 02:59:13

ddl:

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

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

schema_attributes:

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

schema_name_id: 3479
schema_scan_id: 161729823
updated: 2026-04-09 02:59:27

Version 1706842

created: 2026-04-08 03:02:56

ddl:

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

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

schema_attributes:

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

schema_name_id: 3479
schema_scan_id: 161675407
updated: 2026-04-08 03:03:10

Version 1705672

created: 2026-04-07 02:55:48

ddl:

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

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

schema_attributes:

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

schema_name_id: 3479
schema_scan_id: 161618355
updated: 2026-04-07 02:55:59

Version 1704512

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 3479
schema_scan_id: 161561607
updated: 2026-04-06 03:06:49

Version 1703184

created: 2026-04-05 03:00:18

ddl:

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

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

schema_attributes:

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

schema_name_id: 3479
schema_scan_id: 161514710
updated: 2026-04-05 03:00:32

Version 1702059

created: 2026-04-04 03:01:00

ddl:

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

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

schema_attributes:

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

schema_name_id: 3479
schema_scan_id: 161459891
updated: 2026-04-04 03:01:14

Version 1700851

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 3479
schema_scan_id: 161401751
updated: 2026-04-03 03:06:01

Schema Scans: 15

Last at 2026-04-17 02:59:56

Scan 162167170

duration: 0:00:14.124261

exit_message:

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

id: 162167170

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_moloContractTypeSet/2026-04-17/1776412698",
        "key": "raw/molo_moloContractTypeSet/2026-04-17/1776412698/ContractTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloContractTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5388742862973362470,
        "service_name": "drive-thru",
        "span_id": 10623361840642010311,
        "trace_id": 246728278057441993
    }
}

running: False
schema_name_id: 3479
start_time: 2026-04-17 02:59:56
success: True
trace_id: 246728278057441993

Scan 162111678

duration: 0:00:11.635103

exit_message:

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

id: 162111678

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_moloContractTypeSet/2026-04-16/1776326463",
        "key": "raw/molo_moloContractTypeSet/2026-04-16/1776326463/ContractTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloContractTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7758557997250699457,
        "service_name": "drive-thru",
        "span_id": 7953472206020631586,
        "trace_id": 9076543542278962874
    }
}

running: False
schema_name_id: 3479
start_time: 2026-04-16 03:04:02
success: True
trace_id: 9076543542278962874

Scan 162055676

duration: 0:00:11.609643

exit_message:

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

id: 162055676

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_moloContractTypeSet/2026-04-15/1776239933",
        "key": "raw/molo_moloContractTypeSet/2026-04-15/1776239933/ContractTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloContractTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1573107930093895224,
        "service_name": "drive-thru",
        "span_id": 89279534856295955,
        "trace_id": 10767096105405720843
    }
}

running: False
schema_name_id: 3479
start_time: 2026-04-15 03:01:24
success: True
trace_id: 10767096105405720843

Scan 162000318

duration: 0:00:14.148049

exit_message:

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

id: 162000318

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_moloContractTypeSet/2026-04-14/1776153658",
        "key": "raw/molo_moloContractTypeSet/2026-04-14/1776153658/ContractTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloContractTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 695418525753037658,
        "service_name": "drive-thru",
        "span_id": 12869024035159713368,
        "trace_id": 10049113817004085996
    }
}

running: False
schema_name_id: 3479
start_time: 2026-04-14 03:01:47
success: True
trace_id: 10049113817004085996

Scan 161941511

duration: 0:00:11.471326

exit_message:

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

id: 161941511

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_moloContractTypeSet/2026-04-13/1776066850",
        "key": "raw/molo_moloContractTypeSet/2026-04-13/1776066850/ContractTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloContractTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12193126469284014671,
        "service_name": "drive-thru",
        "span_id": 14021922926787567070,
        "trace_id": 17195202730767863557
    }
}

running: False
schema_name_id: 3479
start_time: 2026-04-13 02:56:16
success: True
trace_id: 17195202730767863557

Scan 161892279

duration: 0:00:11.473370

exit_message:

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

id: 161892279

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_moloContractTypeSet/2026-04-12/1775980566",
        "key": "raw/molo_moloContractTypeSet/2026-04-12/1775980566/ContractTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloContractTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12978856466708993026,
        "service_name": "drive-thru",
        "span_id": 5843690969512140909,
        "trace_id": 12264341354039595762
    }
}

running: False
schema_name_id: 3479
start_time: 2026-04-12 02:57:00
success: True
trace_id: 12264341354039595762

Scan 161841127

duration: 0:00:14.084383

exit_message:

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

id: 161841127

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_moloContractTypeSet/2026-04-11/1775894327",
        "key": "raw/molo_moloContractTypeSet/2026-04-11/1775894327/ContractTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloContractTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3201838463937386610,
        "service_name": "drive-thru",
        "span_id": 12088764245183327144,
        "trace_id": 13131400618557108735
    }
}

running: False
schema_name_id: 3479
start_time: 2026-04-11 03:03:45
success: True
trace_id: 13131400618557108735

Scan 161785798

duration: 0:00:14.163517

exit_message:

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

id: 161785798

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_moloContractTypeSet/2026-04-10/1775808083",
        "key": "raw/molo_moloContractTypeSet/2026-04-10/1775808083/ContractTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloContractTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6339589340428038626,
        "service_name": "drive-thru",
        "span_id": 10897618270988073888,
        "trace_id": 16424555330659258293
    }
}

running: False
schema_name_id: 3479
start_time: 2026-04-10 03:02:30
success: True
trace_id: 16424555330659258293

Scan 161729823

duration: 0:00:14.092648

exit_message:

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

id: 161729823

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_moloContractTypeSet/2026-04-09/1775721421",
        "key": "raw/molo_moloContractTypeSet/2026-04-09/1775721421/ContractTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloContractTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6201058258279426440,
        "service_name": "drive-thru",
        "span_id": 16117549025664695201,
        "trace_id": 12846872191187220524
    }
}

running: False
schema_name_id: 3479
start_time: 2026-04-09 02:59:13
success: True
trace_id: 12846872191187220524

Scan 161675407

duration: 0:00:14.034907

exit_message:

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

id: 161675407

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_moloContractTypeSet/2026-04-08/1775635229",
        "key": "raw/molo_moloContractTypeSet/2026-04-08/1775635229/ContractTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloContractTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6651031300467137790,
        "service_name": "drive-thru",
        "span_id": 1315910932819525659,
        "trace_id": 14238592394495395492
    }
}

running: False
schema_name_id: 3479
start_time: 2026-04-08 03:02:56
success: True
trace_id: 14238592394495395492

Scan 161618355

duration: 0:00:11.569726

exit_message:

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

id: 161618355

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_moloContractTypeSet/2026-04-07/1775548403",
        "key": "raw/molo_moloContractTypeSet/2026-04-07/1775548403/ContractTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloContractTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14784874764894367403,
        "service_name": "drive-thru",
        "span_id": 5873473209642841413,
        "trace_id": 7378290744356634500
    }
}

running: False
schema_name_id: 3479
start_time: 2026-04-07 02:55:48
success: True
trace_id: 7378290744356634500

Scan 161561607

duration: 0:00:11.489840

exit_message:

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

id: 161561607

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_moloContractTypeSet/2026-04-06/1775462366",
        "key": "raw/molo_moloContractTypeSet/2026-04-06/1775462366/ContractTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloContractTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3490047539270789909,
        "service_name": "drive-thru",
        "span_id": 10227433503182225621,
        "trace_id": 13568497598631038518
    }
}

running: False
schema_name_id: 3479
start_time: 2026-04-06 03:06:37
success: True
trace_id: 13568497598631038518

Scan 161514710

duration: 0:00:14.159362

exit_message:

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

id: 161514710

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_moloContractTypeSet/2026-04-05/1775375994",
        "key": "raw/molo_moloContractTypeSet/2026-04-05/1775375994/ContractTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloContractTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6933461061243672849,
        "service_name": "drive-thru",
        "span_id": 15992078549080391082,
        "trace_id": 7972623303974174631
    }
}

running: False
schema_name_id: 3479
start_time: 2026-04-05 03:00:17
success: True
trace_id: 7972623303974174631

Scan 161459891

duration: 0:00:14.159385

exit_message:

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

id: 161459891

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_moloContractTypeSet/2026-04-04/1775289478",
        "key": "raw/molo_moloContractTypeSet/2026-04-04/1775289478/ContractTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloContractTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15214204008864455912,
        "service_name": "drive-thru",
        "span_id": 13481320227089047246,
        "trace_id": 6760903619208331333
    }
}

running: False
schema_name_id: 3479
start_time: 2026-04-04 03:00:59
success: True
trace_id: 6760903619208331333

Scan 161401751

duration: 0:00:14.099874

exit_message:

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

id: 161401751

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_moloContractTypeSet/2026-04-03/1775203251",
        "key": "raw/molo_moloContractTypeSet/2026-04-03/1775203251/ContractTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloContractTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4521561326998877106,
        "service_name": "drive-thru",
        "span_id": 11162946443559733803,
        "trace_id": 16734940309660037270
    }
}

running: False
schema_name_id: 3479
start_time: 2026-04-03 03:05:47
success: True
trace_id: 16734940309660037270

Partitions:

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

Schema:

attributes:

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

created: 2026-04-17 02:59:57

ddl:

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

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