Schema Info

Schema Name: sfdl_prod_drivethru.molo_molocustomfieldtypeset

created: 2023-10-17 01:54:02
disabled: False
format: raw
id: 1563
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717575

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1563
schema_scan_id: 162167204
updated: 2026-04-17 03:00:43

Version 1716332

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1563
schema_scan_id: 162111684
updated: 2026-04-16 03:04:29

Version 1715147

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1563
schema_scan_id: 162055691
updated: 2026-04-15 03:01:50

Version 1713935

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1563
schema_scan_id: 162000325
updated: 2026-04-14 03:02:14

Version 1712733

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1563
schema_scan_id: 161941515
updated: 2026-04-13 02:56:34

Version 1711539

created: 2026-04-12 02:58:15

ddl:

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

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

schema_attributes:

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

schema_name_id: 1563
schema_scan_id: 161892347
updated: 2026-04-12 02:58:26

Version 1710311

created: 2026-04-11 03:00:19

ddl:

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

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

schema_attributes:

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

schema_name_id: 1563
schema_scan_id: 161840909
updated: 2026-04-11 03:00:30

Version 1709163

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1563
schema_scan_id: 161785807
updated: 2026-04-10 03:02:58

Version 1708050

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1563
schema_scan_id: 161729917
updated: 2026-04-09 03:00:35

Version 1706856

created: 2026-04-08 03:03:31

ddl:

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

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

schema_attributes:

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

schema_name_id: 1563
schema_scan_id: 161675434
updated: 2026-04-08 03:03:42

Version 1705629

created: 2026-04-07 02:54:13

ddl:

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

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

schema_attributes:

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

schema_name_id: 1563
schema_scan_id: 161618306
updated: 2026-04-07 02:54:24

Version 1704414

created: 2026-04-06 03:02:02

ddl:

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

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

schema_attributes:

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

schema_name_id: 1563
schema_scan_id: 161561397
updated: 2026-04-06 03:02:13

Version 1703181

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1563
schema_scan_id: 161514708
updated: 2026-04-05 03:00:28

Version 1702056

created: 2026-04-04 03:00:51

ddl:

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

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

schema_attributes:

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

schema_name_id: 1563
schema_scan_id: 161459885
updated: 2026-04-04 03:01:09

Version 1700856

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1563
schema_scan_id: 161401760
updated: 2026-04-03 03:06:16

Schema Scans: 15

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

Scan 162167204

duration: 0:00:14.218036

exit_message:

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

id: 162167204

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_moloCustomFieldTypeSet/2026-04-17/1776412700",
        "key": "raw/molo_moloCustomFieldTypeSet/2026-04-17/1776412700/CustomFieldTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCustomFieldTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5374656797673679238,
        "service_name": "drive-thru",
        "span_id": 16638330935792248698,
        "trace_id": 16161286747630617642
    }
}

running: False
schema_name_id: 1563
start_time: 2026-04-17 03:00:29
success: True
trace_id: 16161286747630617642

Scan 162111684

duration: 0:00:14.019760

exit_message:

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

id: 162111684

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_moloCustomFieldTypeSet/2026-04-16/1776326464",
        "key": "raw/molo_moloCustomFieldTypeSet/2026-04-16/1776326464/CustomFieldTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCustomFieldTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14390682892521951192,
        "service_name": "drive-thru",
        "span_id": 7892419000332824653,
        "trace_id": 13124402109882813620
    }
}

running: False
schema_name_id: 1563
start_time: 2026-04-16 03:04:15
success: True
trace_id: 13124402109882813620

Scan 162055691

duration: 0:00:11.472397

exit_message:

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

id: 162055691

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_moloCustomFieldTypeSet/2026-04-15/1776239934",
        "key": "raw/molo_moloCustomFieldTypeSet/2026-04-15/1776239934/CustomFieldTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCustomFieldTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10697109071677318385,
        "service_name": "drive-thru",
        "span_id": 3995144240864726592,
        "trace_id": 18373884975141743836
    }
}

running: False
schema_name_id: 1563
start_time: 2026-04-15 03:01:38
success: True
trace_id: 18373884975141743836

Scan 162000325

duration: 0:00:14.193643

exit_message:

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

id: 162000325

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_moloCustomFieldTypeSet/2026-04-14/1776153659",
        "key": "raw/molo_moloCustomFieldTypeSet/2026-04-14/1776153659/CustomFieldTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCustomFieldTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17626896180253117485,
        "service_name": "drive-thru",
        "span_id": 18319118883691254302,
        "trace_id": 5796479824347037891
    }
}

running: False
schema_name_id: 1563
start_time: 2026-04-14 03:02:00
success: True
trace_id: 5796479824347037891

Scan 161941515

duration: 0:00:13.955268

exit_message:

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

id: 161941515

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_moloCustomFieldTypeSet/2026-04-13/1776066852",
        "key": "raw/molo_moloCustomFieldTypeSet/2026-04-13/1776066852/CustomFieldTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCustomFieldTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12200401049467468732,
        "service_name": "drive-thru",
        "span_id": 18175378374835001640,
        "trace_id": 1890897346070716146
    }
}

running: False
schema_name_id: 1563
start_time: 2026-04-13 02:56:20
success: True
trace_id: 1890897346070716146

Scan 161892347

duration: 0:00:11.444125

exit_message:

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

id: 161892347

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_moloCustomFieldTypeSet/2026-04-12/1775980568",
        "key": "raw/molo_moloCustomFieldTypeSet/2026-04-12/1775980568/CustomFieldTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCustomFieldTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1009577237488390605,
        "service_name": "drive-thru",
        "span_id": 14925081751483900127,
        "trace_id": 5410819248226727729
    }
}

running: False
schema_name_id: 1563
start_time: 2026-04-12 02:58:14
success: True
trace_id: 5410819248226727729

Scan 161840909

duration: 0:00:11.500691

exit_message:

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

id: 161840909

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_moloCustomFieldTypeSet/2026-04-11/1775894328",
        "key": "raw/molo_moloCustomFieldTypeSet/2026-04-11/1775894328/CustomFieldTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCustomFieldTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11959094210155322524,
        "service_name": "drive-thru",
        "span_id": 13506879470153075643,
        "trace_id": 949864098751143542
    }
}

running: False
schema_name_id: 1563
start_time: 2026-04-11 03:00:19
success: True
trace_id: 949864098751143542

Scan 161785807

duration: 0:00:14.204509

exit_message:

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

id: 161785807

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_moloCustomFieldTypeSet/2026-04-10/1775808084",
        "key": "raw/molo_moloCustomFieldTypeSet/2026-04-10/1775808084/CustomFieldTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCustomFieldTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 311946297568666878,
        "service_name": "drive-thru",
        "span_id": 12785013602600749632,
        "trace_id": 9499174319197414517
    }
}

running: False
schema_name_id: 1563
start_time: 2026-04-10 03:02:44
success: True
trace_id: 9499174319197414517

Scan 161729917

duration: 0:00:14.038689

exit_message:

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

id: 161729917

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_moloCustomFieldTypeSet/2026-04-09/1775721423",
        "key": "raw/molo_moloCustomFieldTypeSet/2026-04-09/1775721423/CustomFieldTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCustomFieldTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3500339673210890869,
        "service_name": "drive-thru",
        "span_id": 15244510773933860544,
        "trace_id": 5982054003913845066
    }
}

running: False
schema_name_id: 1563
start_time: 2026-04-09 03:00:21
success: True
trace_id: 5982054003913845066

Scan 161675434

duration: 0:00:11.444293

exit_message:

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

id: 161675434

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_moloCustomFieldTypeSet/2026-04-08/1775635231",
        "key": "raw/molo_moloCustomFieldTypeSet/2026-04-08/1775635231/CustomFieldTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCustomFieldTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13221239645727339538,
        "service_name": "drive-thru",
        "span_id": 11022765117950283934,
        "trace_id": 13023155150737595584
    }
}

running: False
schema_name_id: 1563
start_time: 2026-04-08 03:03:30
success: True
trace_id: 13023155150737595584

Scan 161618306

duration: 0:00:11.470397

exit_message:

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

id: 161618306

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_moloCustomFieldTypeSet/2026-04-07/1775548405",
        "key": "raw/molo_moloCustomFieldTypeSet/2026-04-07/1775548405/CustomFieldTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCustomFieldTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9687741813366162449,
        "service_name": "drive-thru",
        "span_id": 17924531941474256058,
        "trace_id": 5888974069894681710
    }
}

running: False
schema_name_id: 1563
start_time: 2026-04-07 02:54:13
success: True
trace_id: 5888974069894681710

Scan 161561397

duration: 0:00:11.553614

exit_message:

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

id: 161561397

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_moloCustomFieldTypeSet/2026-04-06/1775462368",
        "key": "raw/molo_moloCustomFieldTypeSet/2026-04-06/1775462368/CustomFieldTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCustomFieldTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 710897432333348907,
        "service_name": "drive-thru",
        "span_id": 14647894833139363193,
        "trace_id": 11727054627078133870
    }
}

running: False
schema_name_id: 1563
start_time: 2026-04-06 03:02:01
success: True
trace_id: 11727054627078133870

Scan 161514708

duration: 0:00:11.535286

exit_message:

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

id: 161514708

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_moloCustomFieldTypeSet/2026-04-05/1775375996",
        "key": "raw/molo_moloCustomFieldTypeSet/2026-04-05/1775375996/CustomFieldTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCustomFieldTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5488283376753951480,
        "service_name": "drive-thru",
        "span_id": 13955082377831780412,
        "trace_id": 6937008168501940933
    }
}

running: False
schema_name_id: 1563
start_time: 2026-04-05 03:00:16
success: True
trace_id: 6937008168501940933

Scan 161459885

duration: 0:00:18.193270

exit_message:

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

id: 161459885

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_moloCustomFieldTypeSet/2026-04-04/1775289479",
        "key": "raw/molo_moloCustomFieldTypeSet/2026-04-04/1775289479/CustomFieldTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCustomFieldTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5019932061781396956,
        "service_name": "drive-thru",
        "span_id": 6139178344060409111,
        "trace_id": 3989015932148936615
    }
}

running: False
schema_name_id: 1563
start_time: 2026-04-04 03:00:50
success: True
trace_id: 3989015932148936615

Scan 161401760

duration: 0:00:11.657122

exit_message:

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

id: 161401760

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_moloCustomFieldTypeSet/2026-04-03/1775203253",
        "key": "raw/molo_moloCustomFieldTypeSet/2026-04-03/1775203253/CustomFieldTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCustomFieldTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8153746493297121273,
        "service_name": "drive-thru",
        "span_id": 16537525848915192139,
        "trace_id": 2622310389501999498
    }
}

running: False
schema_name_id: 1563
start_time: 2026-04-03 03:06:04
success: True
trace_id: 2622310389501999498

Partitions:

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

Schema:

attributes:

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

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

ddl:

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

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