Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloactivitytypeset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717552

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1560
schema_scan_id: 162167137
updated: 2026-04-17 02:59:36

Version 1716412

created: 2026-04-16 03:08:17

ddl:

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

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

schema_attributes:

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

schema_name_id: 1560
schema_scan_id: 162111845
updated: 2026-04-16 03:08:31

Version 1715117

created: 2026-04-15 02:59:59

ddl:

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

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

schema_attributes:

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

schema_name_id: 1560
schema_scan_id: 162055606
updated: 2026-04-15 03:00:11

Version 1713987

created: 2026-04-14 03:04:41

ddl:

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

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

schema_attributes:

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

schema_name_id: 1560
schema_scan_id: 162000428
updated: 2026-04-14 03:04:53

Version 1712715

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1560
schema_scan_id: 161941486
updated: 2026-04-13 02:55:50

Version 1711498

created: 2026-04-12 02:56:20

ddl:

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

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

schema_attributes:

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

schema_name_id: 1560
schema_scan_id: 161892251
updated: 2026-04-12 02:56:32

Version 1710335

created: 2026-04-11 03:01:37

ddl:

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

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

schema_attributes:

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

schema_name_id: 1560
schema_scan_id: 161841010
updated: 2026-04-11 03:01:51

Version 1709147

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1560
schema_scan_id: 161785778
updated: 2026-04-10 03:02:08

Version 1708013

created: 2026-04-09 02:58:30

ddl:

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

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

schema_attributes:

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

schema_name_id: 1560
schema_scan_id: 161729775
updated: 2026-04-09 02:58:41

Version 1706826

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1560
schema_scan_id: 161675368
updated: 2026-04-08 03:02:26

Version 1705646

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1560
schema_scan_id: 161618324
updated: 2026-04-07 02:55:02

Version 1704392

created: 2026-04-06 03:01:12

ddl:

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

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

schema_attributes:

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

schema_name_id: 1560
schema_scan_id: 161561359
updated: 2026-04-06 03:01:23

Version 1703192

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1560
schema_scan_id: 161514741
updated: 2026-04-05 03:01:00

Version 1702032

created: 2026-04-04 02:59:50

ddl:

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

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

schema_attributes:

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

schema_name_id: 1560
schema_scan_id: 161459810
updated: 2026-04-04 03:00:01

Version 1700892

created: 2026-04-03 03:07:51

ddl:

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

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

schema_attributes:

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

schema_name_id: 1560
schema_scan_id: 161401826
updated: 2026-04-03 03:08:05

Schema Scans: 15

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

Scan 162167137

duration: 0:00:14.044400

exit_message:

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

id: 162167137

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_moloActivityTypeSet/2026-04-17/1776412689",
        "key": "raw/molo_moloActivityTypeSet/2026-04-17/1776412689/ActivityTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloActivityTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14454769016725069186,
        "service_name": "drive-thru",
        "span_id": 12178915465976354122,
        "trace_id": 11992013755450435938
    }
}

running: False
schema_name_id: 1560
start_time: 2026-04-17 02:59:22
success: True
trace_id: 11992013755450435938

Scan 162111845

duration: 0:00:14.144153

exit_message:

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

id: 162111845

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_moloActivityTypeSet/2026-04-16/1776326450",
        "key": "raw/molo_moloActivityTypeSet/2026-04-16/1776326450/ActivityTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloActivityTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 278036305492487440,
        "service_name": "drive-thru",
        "span_id": 12458537476175874765,
        "trace_id": 1665558685196526494
    }
}

running: False
schema_name_id: 1560
start_time: 2026-04-16 03:08:16
success: True
trace_id: 1665558685196526494

Scan 162055606

duration: 0:00:11.575355

exit_message:

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

id: 162055606

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_moloActivityTypeSet/2026-04-15/1776239924",
        "key": "raw/molo_moloActivityTypeSet/2026-04-15/1776239924/ActivityTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloActivityTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12224489557264444647,
        "service_name": "drive-thru",
        "span_id": 15336232581816935598,
        "trace_id": 10338767045287481387
    }
}

running: False
schema_name_id: 1560
start_time: 2026-04-15 02:59:59
success: True
trace_id: 10338767045287481387

Scan 162000428

duration: 0:00:11.486711

exit_message:

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

id: 162000428

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_moloActivityTypeSet/2026-04-14/1776153645",
        "key": "raw/molo_moloActivityTypeSet/2026-04-14/1776153645/ActivityTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloActivityTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12625220053502610741,
        "service_name": "drive-thru",
        "span_id": 9777945768668511417,
        "trace_id": 12748725123821966833
    }
}

running: False
schema_name_id: 1560
start_time: 2026-04-14 03:04:41
success: True
trace_id: 12748725123821966833

Scan 161941486

duration: 0:00:14.028650

exit_message:

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

id: 161941486

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_moloActivityTypeSet/2026-04-13/1776066838",
        "key": "raw/molo_moloActivityTypeSet/2026-04-13/1776066838/ActivityTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloActivityTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7122179670420430596,
        "service_name": "drive-thru",
        "span_id": 16963299718100733898,
        "trace_id": 5563749844024767904
    }
}

running: False
schema_name_id: 1560
start_time: 2026-04-13 02:55:36
success: True
trace_id: 5563749844024767904

Scan 161892251

duration: 0:00:11.578106

exit_message:

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

id: 161892251

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_moloActivityTypeSet/2026-04-12/1775980555",
        "key": "raw/molo_moloActivityTypeSet/2026-04-12/1775980555/ActivityTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloActivityTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8205789461193218960,
        "service_name": "drive-thru",
        "span_id": 104974957509446328,
        "trace_id": 4016447938215405199
    }
}

running: False
schema_name_id: 1560
start_time: 2026-04-12 02:56:20
success: True
trace_id: 4016447938215405199

Scan 161841010

duration: 0:00:14.022303

exit_message:

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

id: 161841010

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_moloActivityTypeSet/2026-04-11/1775894318",
        "key": "raw/molo_moloActivityTypeSet/2026-04-11/1775894318/ActivityTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloActivityTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16504284217527012766,
        "service_name": "drive-thru",
        "span_id": 9134882478882173009,
        "trace_id": 10266905757720686520
    }
}

running: False
schema_name_id: 1560
start_time: 2026-04-11 03:01:37
success: True
trace_id: 10266905757720686520

Scan 161785778

duration: 0:00:11.482192

exit_message:

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

id: 161785778

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_moloActivityTypeSet/2026-04-10/1775808074",
        "key": "raw/molo_moloActivityTypeSet/2026-04-10/1775808074/ActivityTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloActivityTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11531578145419278011,
        "service_name": "drive-thru",
        "span_id": 16039532824175924112,
        "trace_id": 13926568020262242968
    }
}

running: False
schema_name_id: 1560
start_time: 2026-04-10 03:01:57
success: True
trace_id: 13926568020262242968

Scan 161729775

duration: 0:00:11.552250

exit_message:

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

id: 161729775

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_moloActivityTypeSet/2026-04-09/1775721411",
        "key": "raw/molo_moloActivityTypeSet/2026-04-09/1775721411/ActivityTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloActivityTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9006402188608125638,
        "service_name": "drive-thru",
        "span_id": 3311287573724690067,
        "trace_id": 17334469373067841909
    }
}

running: False
schema_name_id: 1560
start_time: 2026-04-09 02:58:29
success: True
trace_id: 17334469373067841909

Scan 161675368

duration: 0:00:11.423591

exit_message:

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

id: 161675368

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_moloActivityTypeSet/2026-04-08/1775635220",
        "key": "raw/molo_moloActivityTypeSet/2026-04-08/1775635220/ActivityTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloActivityTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10796414170674190715,
        "service_name": "drive-thru",
        "span_id": 10227049260191786864,
        "trace_id": 3780588235224823808
    }
}

running: False
schema_name_id: 1560
start_time: 2026-04-08 03:02:15
success: True
trace_id: 3780588235224823808

Scan 161618324

duration: 0:00:11.429180

exit_message:

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

id: 161618324

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_moloActivityTypeSet/2026-04-07/1775548395",
        "key": "raw/molo_moloActivityTypeSet/2026-04-07/1775548395/ActivityTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloActivityTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6741557241706968608,
        "service_name": "drive-thru",
        "span_id": 7402575828576523696,
        "trace_id": 9344165105979256962
    }
}

running: False
schema_name_id: 1560
start_time: 2026-04-07 02:54:50
success: True
trace_id: 9344165105979256962

Scan 161561359

duration: 0:00:11.528333

exit_message:

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

id: 161561359

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_moloActivityTypeSet/2026-04-06/1775462355",
        "key": "raw/molo_moloActivityTypeSet/2026-04-06/1775462355/ActivityTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloActivityTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5413811668099130527,
        "service_name": "drive-thru",
        "span_id": 9270537407241775007,
        "trace_id": 16137551338521184069
    }
}

running: False
schema_name_id: 1560
start_time: 2026-04-06 03:01:11
success: True
trace_id: 16137551338521184069

Scan 161514741

duration: 0:00:13.975495

exit_message:

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

id: 161514741

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_moloActivityTypeSet/2026-04-05/1775375984",
        "key": "raw/molo_moloActivityTypeSet/2026-04-05/1775375984/ActivityTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloActivityTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14118510766532135247,
        "service_name": "drive-thru",
        "span_id": 11804208743713407937,
        "trace_id": 2839300399844661678
    }
}

running: False
schema_name_id: 1560
start_time: 2026-04-05 03:00:46
success: True
trace_id: 2839300399844661678

Scan 161459810

duration: 0:00:11.564178

exit_message:

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

id: 161459810

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_moloActivityTypeSet/2026-04-04/1775289466",
        "key": "raw/molo_moloActivityTypeSet/2026-04-04/1775289466/ActivityTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloActivityTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9192021683506734410,
        "service_name": "drive-thru",
        "span_id": 16404163119907557049,
        "trace_id": 7789097199456297269
    }
}

running: False
schema_name_id: 1560
start_time: 2026-04-04 02:59:50
success: True
trace_id: 7789097199456297269

Scan 161401826

duration: 0:00:14.048725

exit_message:

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

id: 161401826

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_moloActivityTypeSet/2026-04-03/1775203244",
        "key": "raw/molo_moloActivityTypeSet/2026-04-03/1775203244/ActivityTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloActivityTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4903284494157327908,
        "service_name": "drive-thru",
        "span_id": 8271935014061874997,
        "trace_id": 3806108393111585649
    }
}

running: False
schema_name_id: 1560
start_time: 2026-04-03 03:07:51
success: True
trace_id: 3806108393111585649

Partitions:

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

Schema:

attributes:

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

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

ddl:

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

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