Schema Info

Schema Name: sfdl_prod_drivethru.molo_molosliptypes

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717668

created: 2026-04-17 03:06:04

ddl:

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

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

schema_attributes:

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

schema_name_id: 1679
schema_scan_id: 162167647
updated: 2026-04-17 03:06:18

Version 1716525

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1679
schema_scan_id: 162111977
updated: 2026-04-16 03:12:48

Version 1715261

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1679
schema_scan_id: 162056006
updated: 2026-04-15 03:07:25

Version 1714068

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1679
schema_scan_id: 162000567
updated: 2026-04-14 03:08:21

Version 1712850

created: 2026-04-13 03:00:39

ddl:

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

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

schema_attributes:

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

schema_name_id: 1679
schema_scan_id: 161941926
updated: 2026-04-13 03:00:53

Version 1711652

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1679
schema_scan_id: 161892954
updated: 2026-04-12 03:02:50

Version 1710427

created: 2026-04-11 03:05:35

ddl:

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

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

schema_attributes:

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

schema_name_id: 1679
schema_scan_id: 161841210
updated: 2026-04-11 03:05:49

Version 1709396

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1679
schema_scan_id: 161786100
updated: 2026-04-10 03:12:07

Version 1708244

created: 2026-04-09 03:08:48

ddl:

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

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

schema_attributes:

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

schema_name_id: 1679
schema_scan_id: 161730511
updated: 2026-04-09 03:08:59

Version 1706925

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1679
schema_scan_id: 161675560
updated: 2026-04-08 03:06:48

Version 1705783

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1679
schema_scan_id: 161618710
updated: 2026-04-07 03:00:13

Version 1704462

created: 2026-04-06 03:04:25

ddl:

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

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

schema_attributes:

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

schema_name_id: 1679
schema_scan_id: 161561534
updated: 2026-04-06 03:04:36

Version 1703344

created: 2026-04-05 03:06:57

ddl:

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

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

schema_attributes:

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

schema_name_id: 1679
schema_scan_id: 161514925
updated: 2026-04-05 03:07:11

Version 1702149

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1679
schema_scan_id: 161460341
updated: 2026-04-04 03:05:06

Version 1701079

created: 2026-04-03 03:17:38

ddl:

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

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

schema_attributes:

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

schema_name_id: 1679
schema_scan_id: 161402078
updated: 2026-04-03 03:17:49

Schema Scans: 15

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

Scan 162167647

duration: 0:00:14.115000

exit_message:

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

id: 162167647

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_moloSlipTypes/2026-04-17/1776412852",
        "key": "raw/molo_moloSlipTypes/2026-04-17/1776412852/SlipTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 933623281617736310,
        "service_name": "drive-thru",
        "span_id": 8553254373541861216,
        "trace_id": 10139720673863567796
    }
}

running: False
schema_name_id: 1679
start_time: 2026-04-17 03:06:04
success: True
trace_id: 10139720673863567796

Scan 162111977

duration: 0:00:11.562968

exit_message:

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

id: 162111977

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_moloSlipTypes/2026-04-16/1776326605",
        "key": "raw/molo_moloSlipTypes/2026-04-16/1776326605/SlipTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4322300719608380473,
        "service_name": "drive-thru",
        "span_id": 10678347865838166174,
        "trace_id": 3734144483795009320
    }
}

running: False
schema_name_id: 1679
start_time: 2026-04-16 03:12:37
success: True
trace_id: 3734144483795009320

Scan 162056006

duration: 0:00:11.550933

exit_message:

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

id: 162056006

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_moloSlipTypes/2026-04-15/1776240075",
        "key": "raw/molo_moloSlipTypes/2026-04-15/1776240075/SlipTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4273574129581785701,
        "service_name": "drive-thru",
        "span_id": 1325732972434818467,
        "trace_id": 10270191589785714277
    }
}

running: False
schema_name_id: 1679
start_time: 2026-04-15 03:07:14
success: True
trace_id: 10270191589785714277

Scan 162000567

duration: 0:00:14.168668

exit_message:

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

id: 162000567

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_moloSlipTypes/2026-04-14/1776153841",
        "key": "raw/molo_moloSlipTypes/2026-04-14/1776153841/SlipTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15274352971111715114,
        "service_name": "drive-thru",
        "span_id": 823181228895966305,
        "trace_id": 267520142819540808
    }
}

running: False
schema_name_id: 1679
start_time: 2026-04-14 03:08:07
success: True
trace_id: 267520142819540808

Scan 161941926

duration: 0:00:14.087935

exit_message:

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

id: 161941926

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_moloSlipTypes/2026-04-13/1776067000",
        "key": "raw/molo_moloSlipTypes/2026-04-13/1776067000/SlipTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11682422665335627299,
        "service_name": "drive-thru",
        "span_id": 4368433084044268226,
        "trace_id": 5208799436474333355
    }
}

running: False
schema_name_id: 1679
start_time: 2026-04-13 03:00:38
success: True
trace_id: 5208799436474333355

Scan 161892954

duration: 0:00:11.515964

exit_message:

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

id: 161892954

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_moloSlipTypes/2026-04-12/1775980711",
        "key": "raw/molo_moloSlipTypes/2026-04-12/1775980711/SlipTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10085825418705513885,
        "service_name": "drive-thru",
        "span_id": 14019094748411698529,
        "trace_id": 4498927309183827180
    }
}

running: False
schema_name_id: 1679
start_time: 2026-04-12 03:02:39
success: True
trace_id: 4498927309183827180

Scan 161841210

duration: 0:00:13.959767

exit_message:

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

id: 161841210

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_moloSlipTypes/2026-04-11/1775894478",
        "key": "raw/molo_moloSlipTypes/2026-04-11/1775894478/SlipTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6708003252208555263,
        "service_name": "drive-thru",
        "span_id": 13749021206604013477,
        "trace_id": 4339274115000482721
    }
}

running: False
schema_name_id: 1679
start_time: 2026-04-11 03:05:35
success: True
trace_id: 4339274115000482721

Scan 161786100

duration: 0:00:11.553596

exit_message:

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

id: 161786100

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_moloSlipTypes/2026-04-10/1775808236",
        "key": "raw/molo_moloSlipTypes/2026-04-10/1775808236/SlipTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6388993756771809102,
        "service_name": "drive-thru",
        "span_id": 9514750951678346271,
        "trace_id": 12002783242463198777
    }
}

running: False
schema_name_id: 1679
start_time: 2026-04-10 03:11:56
success: True
trace_id: 12002783242463198777

Scan 161730511

duration: 0:00:11.469079

exit_message:

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

id: 161730511

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_moloSlipTypes/2026-04-09/1775721568",
        "key": "raw/molo_moloSlipTypes/2026-04-09/1775721568/SlipTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14029133705055268288,
        "service_name": "drive-thru",
        "span_id": 12685509562046942129,
        "trace_id": 10850967159981525818
    }
}

running: False
schema_name_id: 1679
start_time: 2026-04-09 03:08:47
success: True
trace_id: 10850967159981525818

Scan 161675560

duration: 0:00:13.988951

exit_message:

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

id: 161675560

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_moloSlipTypes/2026-04-08/1775635397",
        "key": "raw/molo_moloSlipTypes/2026-04-08/1775635397/SlipTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6338809746343399732,
        "service_name": "drive-thru",
        "span_id": 14784037593449287793,
        "trace_id": 16989987682158871672
    }
}

running: False
schema_name_id: 1679
start_time: 2026-04-08 03:06:34
success: True
trace_id: 16989987682158871672

Scan 161618710

duration: 0:00:11.512637

exit_message:

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

id: 161618710

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_moloSlipTypes/2026-04-07/1775548554",
        "key": "raw/molo_moloSlipTypes/2026-04-07/1775548554/SlipTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4256463457612873196,
        "service_name": "drive-thru",
        "span_id": 11942673959177997880,
        "trace_id": 341854981565571017
    }
}

running: False
schema_name_id: 1679
start_time: 2026-04-07 03:00:02
success: True
trace_id: 341854981565571017

Scan 161561534

duration: 0:00:11.488827

exit_message:

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

id: 161561534

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_moloSlipTypes/2026-04-06/1775462513",
        "key": "raw/molo_moloSlipTypes/2026-04-06/1775462513/SlipTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1861575444371975281,
        "service_name": "drive-thru",
        "span_id": 17856467595562287887,
        "trace_id": 13126701095067471260
    }
}

running: False
schema_name_id: 1679
start_time: 2026-04-06 03:04:25
success: True
trace_id: 13126701095067471260

Scan 161514925

duration: 0:00:14.004208

exit_message:

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

id: 161514925

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_moloSlipTypes/2026-04-05/1775376140",
        "key": "raw/molo_moloSlipTypes/2026-04-05/1775376140/SlipTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8122581099252290242,
        "service_name": "drive-thru",
        "span_id": 2137855172517889459,
        "trace_id": 14653032447785914635
    }
}

running: False
schema_name_id: 1679
start_time: 2026-04-05 03:06:57
success: True
trace_id: 14653032447785914635

Scan 161460341

duration: 0:00:13.944179

exit_message:

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

id: 161460341

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_moloSlipTypes/2026-04-04/1775289623",
        "key": "raw/molo_moloSlipTypes/2026-04-04/1775289623/SlipTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7884675880294845709,
        "service_name": "drive-thru",
        "span_id": 8538724221264904881,
        "trace_id": 12284740058181565538
    }
}

running: False
schema_name_id: 1679
start_time: 2026-04-04 03:04:52
success: True
trace_id: 12284740058181565538

Scan 161402078

duration: 0:00:11.488393

exit_message:

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

id: 161402078

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_moloSlipTypes/2026-04-03/1775203396",
        "key": "raw/molo_moloSlipTypes/2026-04-03/1775203396/SlipTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4051861457646340412,
        "service_name": "drive-thru",
        "span_id": 8326432395883639949,
        "trace_id": 3950146468967756150
    }
}

running: False
schema_name_id: 1679
start_time: 2026-04-03 03:17:38
success: True
trace_id: 3950146468967756150

Partitions:

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

Schema:

attributes:

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

created: 2026-04-17 03:06:04

ddl:

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

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