Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloactivitystatusset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717559

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1574
schema_scan_id: 162167156
updated: 2026-04-17 02:59:54

Version 1716310

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1574
schema_scan_id: 162111638
updated: 2026-04-16 03:03:08

Version 1715144

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1574
schema_scan_id: 162055682
updated: 2026-04-15 03:01:41

Version 1713925

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1574
schema_scan_id: 162000295
updated: 2026-04-14 03:01:43

Version 1712692

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1574
schema_scan_id: 161941451
updated: 2026-04-13 02:54:54

Version 1711514

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1574
schema_scan_id: 161892278
updated: 2026-04-12 02:57:13

Version 1710315

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1574
schema_scan_id: 161840925
updated: 2026-04-11 03:00:44

Version 1709176

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1574
schema_scan_id: 161785845
updated: 2026-04-10 03:03:36

Version 1708049

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1574
schema_scan_id: 161729903
updated: 2026-04-09 03:00:35

Version 1706840

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1574
schema_scan_id: 161675402
updated: 2026-04-08 03:03:02

Version 1705621

created: 2026-04-07 02:53:50

ddl:

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

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

schema_attributes:

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

schema_name_id: 1574
schema_scan_id: 161618298
updated: 2026-04-07 02:54:04

Version 1704476

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1574
schema_scan_id: 161561556
updated: 2026-04-06 03:05:17

Version 1703191

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1574
schema_scan_id: 161514740
updated: 2026-04-05 03:00:59

Version 1702022

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1574
schema_scan_id: 161459780
updated: 2026-04-04 02:59:34

Version 1700811

created: 2026-04-03 03:02:51

ddl:

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

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

schema_attributes:

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

schema_name_id: 1574
schema_scan_id: 161401600
updated: 2026-04-03 03:03:05

Schema Scans: 15

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

Scan 162167156

duration: 0:00:14.076065

exit_message:

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

id: 162167156

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_moloActivityStatusSet/2026-04-17/1776412686",
        "key": "raw/molo_moloActivityStatusSet/2026-04-17/1776412686/ActivityStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloActivityStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6690656007949389525,
        "service_name": "drive-thru",
        "span_id": 10550706536976605783,
        "trace_id": 18322115720028403880
    }
}

running: False
schema_name_id: 1574
start_time: 2026-04-17 02:59:40
success: True
trace_id: 18322115720028403880

Scan 162111638

duration: 0:00:14.114665

exit_message:

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

id: 162111638

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_moloActivityStatusSet/2026-04-16/1776326451",
        "key": "raw/molo_moloActivityStatusSet/2026-04-16/1776326451/ActivityStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloActivityStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18139394798209146451,
        "service_name": "drive-thru",
        "span_id": 3035843184687357382,
        "trace_id": 4255949698950302467
    }
}

running: False
schema_name_id: 1574
start_time: 2026-04-16 03:02:54
success: True
trace_id: 4255949698950302467

Scan 162055682

duration: 0:00:14.172465

exit_message:

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

id: 162055682

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_moloActivityStatusSet/2026-04-15/1776239922",
        "key": "raw/molo_moloActivityStatusSet/2026-04-15/1776239922/ActivityStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloActivityStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12728293776955234253,
        "service_name": "drive-thru",
        "span_id": 16347602989611650046,
        "trace_id": 2574369317719640616
    }
}

running: False
schema_name_id: 1574
start_time: 2026-04-15 03:01:27
success: True
trace_id: 2574369317719640616

Scan 162000295

duration: 0:00:11.631086

exit_message:

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

id: 162000295

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_moloActivityStatusSet/2026-04-14/1776153645",
        "key": "raw/molo_moloActivityStatusSet/2026-04-14/1776153645/ActivityStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloActivityStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10313863812357383604,
        "service_name": "drive-thru",
        "span_id": 7754113906265719586,
        "trace_id": 9995410934133008848
    }
}

running: False
schema_name_id: 1574
start_time: 2026-04-14 03:01:32
success: True
trace_id: 9995410934133008848

Scan 161941451

duration: 0:00:14.068371

exit_message:

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

id: 161941451

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_moloActivityStatusSet/2026-04-13/1776066835",
        "key": "raw/molo_moloActivityStatusSet/2026-04-13/1776066835/ActivityStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloActivityStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13074278120321483215,
        "service_name": "drive-thru",
        "span_id": 4846163048646911542,
        "trace_id": 2491239846034969052
    }
}

running: False
schema_name_id: 1574
start_time: 2026-04-13 02:54:40
success: True
trace_id: 2491239846034969052

Scan 161892278

duration: 0:00:14.080314

exit_message:

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

id: 161892278

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_moloActivityStatusSet/2026-04-12/1775980557",
        "key": "raw/molo_moloActivityStatusSet/2026-04-12/1775980557/ActivityStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloActivityStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8683812741881440385,
        "service_name": "drive-thru",
        "span_id": 5389769503986145719,
        "trace_id": 16366981495565385082
    }
}

running: False
schema_name_id: 1574
start_time: 2026-04-12 02:56:59
success: True
trace_id: 16366981495565385082

Scan 161840925

duration: 0:00:13.998269

exit_message:

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

id: 161840925

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_moloActivityStatusSet/2026-04-11/1775894317",
        "key": "raw/molo_moloActivityStatusSet/2026-04-11/1775894317/ActivityStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloActivityStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8549225831482502646,
        "service_name": "drive-thru",
        "span_id": 15484596080316420841,
        "trace_id": 744652378928949386
    }
}

running: False
schema_name_id: 1574
start_time: 2026-04-11 03:00:30
success: True
trace_id: 744652378928949386

Scan 161785845

duration: 0:00:11.680062

exit_message:

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

id: 161785845

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_moloActivityStatusSet/2026-04-10/1775808073",
        "key": "raw/molo_moloActivityStatusSet/2026-04-10/1775808073/ActivityStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloActivityStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7448214073241948140,
        "service_name": "drive-thru",
        "span_id": 1770449650502682672,
        "trace_id": 14207640766566982349
    }
}

running: False
schema_name_id: 1574
start_time: 2026-04-10 03:03:25
success: True
trace_id: 14207640766566982349

Scan 161729903

duration: 0:00:19.847785

exit_message:

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

id: 161729903

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_moloActivityStatusSet/2026-04-09/1775721413",
        "key": "raw/molo_moloActivityStatusSet/2026-04-09/1775721413/ActivityStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloActivityStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4143531651816450772,
        "service_name": "drive-thru",
        "span_id": 14423871137756831063,
        "trace_id": 6321755367955247355
    }
}

running: False
schema_name_id: 1574
start_time: 2026-04-09 03:00:15
success: True
trace_id: 6321755367955247355

Scan 161675402

duration: 0:00:13.987522

exit_message:

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

id: 161675402

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_moloActivityStatusSet/2026-04-08/1775635222",
        "key": "raw/molo_moloActivityStatusSet/2026-04-08/1775635222/ActivityStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloActivityStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 494155359278768859,
        "service_name": "drive-thru",
        "span_id": 7042926030997574088,
        "trace_id": 12559204308023977986
    }
}

running: False
schema_name_id: 1574
start_time: 2026-04-08 03:02:48
success: True
trace_id: 12559204308023977986

Scan 161618298

duration: 0:00:14.155759

exit_message:

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

id: 161618298

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_moloActivityStatusSet/2026-04-07/1775548390",
        "key": "raw/molo_moloActivityStatusSet/2026-04-07/1775548390/ActivityStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloActivityStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4669872109883116330,
        "service_name": "drive-thru",
        "span_id": 8154904289702230652,
        "trace_id": 8842333805283323318
    }
}

running: False
schema_name_id: 1574
start_time: 2026-04-07 02:53:50
success: True
trace_id: 8842333805283323318

Scan 161561556

duration: 0:00:14.040940

exit_message:

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

id: 161561556

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_moloActivityStatusSet/2026-04-06/1775462357",
        "key": "raw/molo_moloActivityStatusSet/2026-04-06/1775462357/ActivityStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloActivityStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10898707542773749594,
        "service_name": "drive-thru",
        "span_id": 9676333770750732337,
        "trace_id": 2686217433119818448
    }
}

running: False
schema_name_id: 1574
start_time: 2026-04-06 03:05:03
success: True
trace_id: 2686217433119818448

Scan 161514740

duration: 0:00:14.005127

exit_message:

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

id: 161514740

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_moloActivityStatusSet/2026-04-05/1775375983",
        "key": "raw/molo_moloActivityStatusSet/2026-04-05/1775375983/ActivityStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloActivityStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13173803560488093385,
        "service_name": "drive-thru",
        "span_id": 7629419133937128352,
        "trace_id": 18058528908061464768
    }
}

running: False
schema_name_id: 1574
start_time: 2026-04-05 03:00:45
success: True
trace_id: 18058528908061464768

Scan 161459780

duration: 0:00:11.534741

exit_message:

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

id: 161459780

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_moloActivityStatusSet/2026-04-04/1775289467",
        "key": "raw/molo_moloActivityStatusSet/2026-04-04/1775289467/ActivityStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloActivityStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 229825912701013162,
        "service_name": "drive-thru",
        "span_id": 13225109889781061743,
        "trace_id": 8720292334085669549
    }
}

running: False
schema_name_id: 1574
start_time: 2026-04-04 02:59:23
success: True
trace_id: 8720292334085669549

Scan 161401600

duration: 0:00:14.141248

exit_message:

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

id: 161401600

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_moloActivityStatusSet/2026-04-03/1775203241",
        "key": "raw/molo_moloActivityStatusSet/2026-04-03/1775203241/ActivityStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloActivityStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 472026940132336407,
        "service_name": "drive-thru",
        "span_id": 8376007226436003182,
        "trace_id": 16337208245580727906
    }
}

running: False
schema_name_id: 1574
start_time: 2026-04-03 03:02:50
success: True
trace_id: 16337208245580727906

Partitions:

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

Schema:

attributes:

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

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

ddl:

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

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