Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloaccountstatus

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717558

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1561
schema_scan_id: 162167155
updated: 2026-04-17 02:59:51

Version 1716319

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1561
schema_scan_id: 162111668
updated: 2026-04-16 03:03:45

Version 1715122

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1561
schema_scan_id: 162055626
updated: 2026-04-15 03:00:38

Version 1713936

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1561
schema_scan_id: 162000335
updated: 2026-04-14 03:02:19

Version 1712694

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1561
schema_scan_id: 161941455
updated: 2026-04-13 02:54:56

Version 1711517

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1561
schema_scan_id: 161892287
updated: 2026-04-12 02:57:21

Version 1710296

created: 2026-04-11 02:59:12

ddl:

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

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

schema_attributes:

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

schema_name_id: 1561
schema_scan_id: 161840784
updated: 2026-04-11 02:59:26

Version 1709135

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1561
schema_scan_id: 161785735
updated: 2026-04-10 03:01:27

Version 1707995

created: 2026-04-09 02:57:11

ddl:

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

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

schema_attributes:

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

schema_name_id: 1561
schema_scan_id: 161729639
updated: 2026-04-09 02:57:22

Version 1706818

created: 2026-04-08 03:01:51

ddl:

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

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

schema_attributes:

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

schema_name_id: 1561
schema_scan_id: 161675354
updated: 2026-04-08 03:02:03

Version 1705608

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1561
schema_scan_id: 161618285
updated: 2026-04-07 02:53:36

Version 1704485

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1561
schema_scan_id: 161561570
updated: 2026-04-06 03:05:43

Version 1703175

created: 2026-04-05 02:59:56

ddl:

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

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

schema_attributes:

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

schema_name_id: 1561
schema_scan_id: 161514681
updated: 2026-04-05 03:00:09

Version 1702019

created: 2026-04-04 02:59:13

ddl:

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

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

schema_attributes:

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

schema_name_id: 1561
schema_scan_id: 161459765
updated: 2026-04-04 02:59:24

Version 1700835

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1561
schema_scan_id: 161401712
updated: 2026-04-03 03:05:05

Schema Scans: 15

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

Scan 162167155

duration: 0:00:11.460321

exit_message:

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

id: 162167155

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_moloAccountStatus/2026-04-17/1776412685",
        "key": "raw/molo_moloAccountStatus/2026-04-17/1776412685/AccountStatus.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAccountStatus",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12624602757384628829,
        "service_name": "drive-thru",
        "span_id": 17557009409358736128,
        "trace_id": 16387119920570893257
    }
}

running: False
schema_name_id: 1561
start_time: 2026-04-17 02:59:40
success: True
trace_id: 16387119920570893257

Scan 162111668

duration: 0:00:11.633319

exit_message:

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

id: 162111668

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_moloAccountStatus/2026-04-16/1776326448",
        "key": "raw/molo_moloAccountStatus/2026-04-16/1776326448/AccountStatus.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAccountStatus",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 824672432798760925,
        "service_name": "drive-thru",
        "span_id": 14956339812279787927,
        "trace_id": 1092079243428286609
    }
}

running: False
schema_name_id: 1561
start_time: 2026-04-16 03:03:33
success: True
trace_id: 1092079243428286609

Scan 162055626

duration: 0:00:14.061305

exit_message:

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

id: 162055626

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_moloAccountStatus/2026-04-15/1776239920",
        "key": "raw/molo_moloAccountStatus/2026-04-15/1776239920/AccountStatus.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAccountStatus",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10388943482994956372,
        "service_name": "drive-thru",
        "span_id": 16908648407751549135,
        "trace_id": 6649494350438931749
    }
}

running: False
schema_name_id: 1561
start_time: 2026-04-15 03:00:24
success: True
trace_id: 6649494350438931749

Scan 162000335

duration: 0:00:14.149087

exit_message:

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

id: 162000335

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_moloAccountStatus/2026-04-14/1776153642",
        "key": "raw/molo_moloAccountStatus/2026-04-14/1776153642/AccountStatus.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAccountStatus",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12740137824463899123,
        "service_name": "drive-thru",
        "span_id": 5797059972437097379,
        "trace_id": 12234897770190102072
    }
}

running: False
schema_name_id: 1561
start_time: 2026-04-14 03:02:05
success: True
trace_id: 12234897770190102072

Scan 161941455

duration: 0:00:11.475332

exit_message:

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

id: 161941455

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_moloAccountStatus/2026-04-13/1776066835",
        "key": "raw/molo_moloAccountStatus/2026-04-13/1776066835/AccountStatus.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAccountStatus",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11297530902394299565,
        "service_name": "drive-thru",
        "span_id": 6650278294315063087,
        "trace_id": 148665053651528723
    }
}

running: False
schema_name_id: 1561
start_time: 2026-04-13 02:54:44
success: True
trace_id: 148665053651528723

Scan 161892287

duration: 0:00:14.039597

exit_message:

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

id: 161892287

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_moloAccountStatus/2026-04-12/1775980554",
        "key": "raw/molo_moloAccountStatus/2026-04-12/1775980554/AccountStatus.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAccountStatus",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8176310143942124089,
        "service_name": "drive-thru",
        "span_id": 1011678117687916804,
        "trace_id": 15105131639609950437
    }
}

running: False
schema_name_id: 1561
start_time: 2026-04-12 02:57:07
success: True
trace_id: 15105131639609950437

Scan 161840784

duration: 0:00:14.184081

exit_message:

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

id: 161840784

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_moloAccountStatus/2026-04-11/1775894312",
        "key": "raw/molo_moloAccountStatus/2026-04-11/1775894312/AccountStatus.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAccountStatus",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11599894444366581396,
        "service_name": "drive-thru",
        "span_id": 17665811591419634562,
        "trace_id": 7581603465926560150
    }
}

running: False
schema_name_id: 1561
start_time: 2026-04-11 02:59:12
success: True
trace_id: 7581603465926560150

Scan 161785735

duration: 0:00:11.695500

exit_message:

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

id: 161785735

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_moloAccountStatus/2026-04-10/1775808071",
        "key": "raw/molo_moloAccountStatus/2026-04-10/1775808071/AccountStatus.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAccountStatus",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 414754005115545276,
        "service_name": "drive-thru",
        "span_id": 4002686402285235608,
        "trace_id": 7555883486065459314
    }
}

running: False
schema_name_id: 1561
start_time: 2026-04-10 03:01:15
success: True
trace_id: 7555883486065459314

Scan 161729639

duration: 0:00:11.480716

exit_message:

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

id: 161729639

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_moloAccountStatus/2026-04-09/1775721409",
        "key": "raw/molo_moloAccountStatus/2026-04-09/1775721409/AccountStatus.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAccountStatus",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4816543991407361850,
        "service_name": "drive-thru",
        "span_id": 13140021830658941575,
        "trace_id": 15766687543549096574
    }
}

running: False
schema_name_id: 1561
start_time: 2026-04-09 02:57:10
success: True
trace_id: 15766687543549096574

Scan 161675354

duration: 0:00:11.486474

exit_message:

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

id: 161675354

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_moloAccountStatus/2026-04-08/1775635216",
        "key": "raw/molo_moloAccountStatus/2026-04-08/1775635216/AccountStatus.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAccountStatus",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14289130222129151985,
        "service_name": "drive-thru",
        "span_id": 6910565880468531025,
        "trace_id": 16087395551660976
    }
}

running: False
schema_name_id: 1561
start_time: 2026-04-08 03:01:51
success: True
trace_id: 16087395551660976

Scan 161618285

duration: 0:00:14.247704

exit_message:

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

id: 161618285

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_moloAccountStatus/2026-04-07/1775548389",
        "key": "raw/molo_moloAccountStatus/2026-04-07/1775548389/AccountStatus.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAccountStatus",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9134251012727527375,
        "service_name": "drive-thru",
        "span_id": 6420571981785783085,
        "trace_id": 3160755866431512861
    }
}

running: False
schema_name_id: 1561
start_time: 2026-04-07 02:53:22
success: True
trace_id: 3160755866431512861

Scan 161561570

duration: 0:00:14.029387

exit_message:

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

id: 161561570

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_moloAccountStatus/2026-04-06/1775462353",
        "key": "raw/molo_moloAccountStatus/2026-04-06/1775462353/AccountStatus.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAccountStatus",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12561420357455856301,
        "service_name": "drive-thru",
        "span_id": 7525786103754387612,
        "trace_id": 17943881981238939368
    }
}

running: False
schema_name_id: 1561
start_time: 2026-04-06 03:05:29
success: True
trace_id: 17943881981238939368

Scan 161514681

duration: 0:00:14.178396

exit_message:

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

id: 161514681

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_moloAccountStatus/2026-04-05/1775375982",
        "key": "raw/molo_moloAccountStatus/2026-04-05/1775375982/AccountStatus.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAccountStatus",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9365121757419625825,
        "service_name": "drive-thru",
        "span_id": 13061850845322329505,
        "trace_id": 9718694666931945493
    }
}

running: False
schema_name_id: 1561
start_time: 2026-04-05 02:59:55
success: True
trace_id: 9718694666931945493

Scan 161459765

duration: 0:00:11.551018

exit_message:

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

id: 161459765

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_moloAccountStatus/2026-04-04/1775289465",
        "key": "raw/molo_moloAccountStatus/2026-04-04/1775289465/AccountStatus.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAccountStatus",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18214867012975810494,
        "service_name": "drive-thru",
        "span_id": 8509041578910318901,
        "trace_id": 9379431397753371357
    }
}

running: False
schema_name_id: 1561
start_time: 2026-04-04 02:59:13
success: True
trace_id: 9379431397753371357

Scan 161401712

duration: 0:00:14.036598

exit_message:

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

id: 161401712

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_moloAccountStatus/2026-04-03/1775203238",
        "key": "raw/molo_moloAccountStatus/2026-04-03/1775203238/AccountStatus.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAccountStatus",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5766388090229173137,
        "service_name": "drive-thru",
        "span_id": 11823051501979412314,
        "trace_id": 2759380819756913229
    }
}

running: False
schema_name_id: 1561
start_time: 2026-04-03 03:04:51
success: True
trace_id: 2759380819756913229

Partitions:

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

Schema:

attributes:

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

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

ddl:

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

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