Schema Info

Schema Name: sfdl_prod_drivethru.molo_molotasktypes

created: 2023-10-17 02:03:02
disabled: False
format: raw
id: 1810
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717816

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1810
schema_scan_id: 162167852
updated: 2026-04-17 03:13:14

Version 1716503

created: 2026-04-16 03:11:41

ddl:

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

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

schema_attributes:

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

schema_name_id: 1810
schema_scan_id: 162111946
updated: 2026-04-16 03:11:55

Version 1715341

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1810
schema_scan_id: 162056135
updated: 2026-04-15 03:11:23

Version 1714165

created: 2026-04-14 03:11:50

ddl:

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

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

schema_attributes:

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

schema_name_id: 1810
schema_scan_id: 162000688
updated: 2026-04-14 03:12:04

Version 1712969

created: 2026-04-13 03:07:10

ddl:

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

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

schema_attributes:

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

schema_name_id: 1810
schema_scan_id: 161942826
updated: 2026-04-13 03:07:24

Version 1711779

created: 2026-04-12 03:14:44

ddl:

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

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

schema_attributes:

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

schema_name_id: 1810
schema_scan_id: 161893514
updated: 2026-04-12 03:14:58

Version 1710565

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1810
schema_scan_id: 161841372
updated: 2026-04-11 03:11:22

Version 1709319

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1810
schema_scan_id: 161786017
updated: 2026-04-10 03:09:11

Version 1708184

created: 2026-04-09 03:06:16

ddl:

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

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

schema_attributes:

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

schema_name_id: 1810
schema_scan_id: 161730416
updated: 2026-04-09 03:06:30

Version 1707034

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1810
schema_scan_id: 161675698
updated: 2026-04-08 03:11:01

Version 1705809

created: 2026-04-07 03:01:45

ddl:

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

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

schema_attributes:

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

schema_name_id: 1810
schema_scan_id: 161619170
updated: 2026-04-07 03:01:59

Version 1704489

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1810
schema_scan_id: 161561576
updated: 2026-04-06 03:05:54

Version 1703435

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1810
schema_scan_id: 161515024
updated: 2026-04-05 03:10:36

Version 1702185

created: 2026-04-04 03:06:32

ddl:

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

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

schema_attributes:

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

schema_name_id: 1810
schema_scan_id: 161460429
updated: 2026-04-04 03:06:43

Version 1701020

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1810
schema_scan_id: 161401995
updated: 2026-04-03 03:13:25

Schema Scans: 15

Last at 2026-04-17 03:13:00

Scan 162167852

duration: 0:00:14.142960

exit_message:

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

id: 162167852

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_moloTaskTypes/2026-04-17/1776413131",
        "key": "raw/molo_moloTaskTypes/2026-04-17/1776413131/TaskTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTaskTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 426292561587388281,
        "service_name": "drive-thru",
        "span_id": 13343424920838319112,
        "trace_id": 11008396942571999682
    }
}

running: False
schema_name_id: 1810
start_time: 2026-04-17 03:13:00
success: True
trace_id: 11008396942571999682

Scan 162111946

duration: 0:00:13.994830

exit_message:

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

id: 162111946

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_moloTaskTypes/2026-04-16/1776326733",
        "key": "raw/molo_moloTaskTypes/2026-04-16/1776326733/TaskTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTaskTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11832584605058431700,
        "service_name": "drive-thru",
        "span_id": 9842806409447317713,
        "trace_id": 5338839009712504166
    }
}

running: False
schema_name_id: 1810
start_time: 2026-04-16 03:11:41
success: True
trace_id: 5338839009712504166

Scan 162056135

duration: 0:00:14.089928

exit_message:

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

id: 162056135

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_moloTaskTypes/2026-04-15/1776240200",
        "key": "raw/molo_moloTaskTypes/2026-04-15/1776240200/TaskTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTaskTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10926064959154583748,
        "service_name": "drive-thru",
        "span_id": 6342270272803548248,
        "trace_id": 5300372212011558135
    }
}

running: False
schema_name_id: 1810
start_time: 2026-04-15 03:11:09
success: True
trace_id: 5300372212011558135

Scan 162000688

duration: 0:00:14.032298

exit_message:

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

id: 162000688

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_moloTaskTypes/2026-04-14/1776154166",
        "key": "raw/molo_moloTaskTypes/2026-04-14/1776154166/TaskTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTaskTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 647370858876076590,
        "service_name": "drive-thru",
        "span_id": 15893735664095298493,
        "trace_id": 13986945321138905308
    }
}

running: False
schema_name_id: 1810
start_time: 2026-04-14 03:11:50
success: True
trace_id: 13986945321138905308

Scan 161942826

duration: 0:00:14.202086

exit_message:

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

id: 161942826

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_moloTaskTypes/2026-04-13/1776067160",
        "key": "raw/molo_moloTaskTypes/2026-04-13/1776067160/TaskTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTaskTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5265920155645481568,
        "service_name": "drive-thru",
        "span_id": 10153210460108845224,
        "trace_id": 15444537316735562015
    }
}

running: False
schema_name_id: 1810
start_time: 2026-04-13 03:07:10
success: True
trace_id: 15444537316735562015

Scan 161893514

duration: 0:00:14.063680

exit_message:

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

id: 161893514

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_moloTaskTypes/2026-04-12/1775980860",
        "key": "raw/molo_moloTaskTypes/2026-04-12/1775980860/TaskTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTaskTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11861874513081605028,
        "service_name": "drive-thru",
        "span_id": 9898667118352676059,
        "trace_id": 7635717091176239202
    }
}

running: False
schema_name_id: 1810
start_time: 2026-04-12 03:14:44
success: True
trace_id: 7635717091176239202

Scan 161841372

duration: 0:00:11.445976

exit_message:

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

id: 161841372

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_moloTaskTypes/2026-04-11/1775894629",
        "key": "raw/molo_moloTaskTypes/2026-04-11/1775894629/TaskTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTaskTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15348406388948765615,
        "service_name": "drive-thru",
        "span_id": 11126196831830138275,
        "trace_id": 7474527702206030566
    }
}

running: False
schema_name_id: 1810
start_time: 2026-04-11 03:11:10
success: True
trace_id: 7474527702206030566

Scan 161786017

duration: 0:00:14.254876

exit_message:

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

id: 161786017

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_moloTaskTypes/2026-04-10/1775808390",
        "key": "raw/molo_moloTaskTypes/2026-04-10/1775808390/TaskTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTaskTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11806228313120551409,
        "service_name": "drive-thru",
        "span_id": 3126577740963877036,
        "trace_id": 13471556499837581016
    }
}

running: False
schema_name_id: 1810
start_time: 2026-04-10 03:08:57
success: True
trace_id: 13471556499837581016

Scan 161730416

duration: 0:00:14.092935

exit_message:

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

id: 161730416

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_moloTaskTypes/2026-04-09/1775721719",
        "key": "raw/molo_moloTaskTypes/2026-04-09/1775721719/TaskTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTaskTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14074762088908967955,
        "service_name": "drive-thru",
        "span_id": 11142141226797101576,
        "trace_id": 12641184185155861519
    }
}

running: False
schema_name_id: 1810
start_time: 2026-04-09 03:06:16
success: True
trace_id: 12641184185155861519

Scan 161675698

duration: 0:00:14.080783

exit_message:

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

id: 161675698

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_moloTaskTypes/2026-04-08/1775635551",
        "key": "raw/molo_moloTaskTypes/2026-04-08/1775635551/TaskTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTaskTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11552660286314669662,
        "service_name": "drive-thru",
        "span_id": 4546246253511932965,
        "trace_id": 16911517293715847031
    }
}

running: False
schema_name_id: 1810
start_time: 2026-04-08 03:10:47
success: True
trace_id: 16911517293715847031

Scan 161619170

duration: 0:00:14.167104

exit_message:

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

id: 161619170

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_moloTaskTypes/2026-04-07/1775548712",
        "key": "raw/molo_moloTaskTypes/2026-04-07/1775548712/TaskTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTaskTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17636925591512101291,
        "service_name": "drive-thru",
        "span_id": 665579252492253670,
        "trace_id": 282922687698332107
    }
}

running: False
schema_name_id: 1810
start_time: 2026-04-07 03:01:45
success: True
trace_id: 282922687698332107

Scan 161561576

duration: 0:00:14.079197

exit_message:

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

id: 161561576

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_moloTaskTypes/2026-04-06/1775462662",
        "key": "raw/molo_moloTaskTypes/2026-04-06/1775462662/TaskTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTaskTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14080083326157279074,
        "service_name": "drive-thru",
        "span_id": 10565713413120123547,
        "trace_id": 5493828207490495904
    }
}

running: False
schema_name_id: 1810
start_time: 2026-04-06 03:05:40
success: True
trace_id: 5493828207490495904

Scan 161515024

duration: 0:00:11.479295

exit_message:

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

id: 161515024

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_moloTaskTypes/2026-04-05/1775376293",
        "key": "raw/molo_moloTaskTypes/2026-04-05/1775376293/TaskTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTaskTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16408764304305665674,
        "service_name": "drive-thru",
        "span_id": 7155706269020540472,
        "trace_id": 83331676017494440
    }
}

running: False
schema_name_id: 1810
start_time: 2026-04-05 03:10:25
success: True
trace_id: 83331676017494440

Scan 161460429

duration: 0:00:11.601516

exit_message:

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

id: 161460429

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_moloTaskTypes/2026-04-04/1775289775",
        "key": "raw/molo_moloTaskTypes/2026-04-04/1775289775/TaskTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTaskTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1163938235531606879,
        "service_name": "drive-thru",
        "span_id": 10563052117706615919,
        "trace_id": 5413171895312579243
    }
}

running: False
schema_name_id: 1810
start_time: 2026-04-04 03:06:32
success: True
trace_id: 5413171895312579243

Scan 161401995

duration: 0:00:14.019595

exit_message:

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

id: 161401995

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_moloTaskTypes/2026-04-03/1775203541",
        "key": "raw/molo_moloTaskTypes/2026-04-03/1775203541/TaskTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTaskTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17554627182977687638,
        "service_name": "drive-thru",
        "span_id": 16961386327583585373,
        "trace_id": 16427012949166105450
    }
}

running: False
schema_name_id: 1810
start_time: 2026-04-03 03:13:11
success: True
trace_id: 16427012949166105450

Partitions:

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

Schema:

attributes:

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

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

ddl:

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

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