Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloinsurancestatusset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717618

created: 2026-04-17 03:03:06

ddl:

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

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

schema_attributes:

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

schema_name_id: 1616
schema_scan_id: 162167437
updated: 2026-04-17 03:03:20

Version 1716374

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1616
schema_scan_id: 162111776
updated: 2026-04-16 03:06:46

Version 1715195

created: 2026-04-15 03:04:19

ddl:

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

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

schema_attributes:

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

schema_name_id: 1616
schema_scan_id: 162055890
updated: 2026-04-15 03:04:32

Version 1713964

created: 2026-04-14 03:03:45

ddl:

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

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

schema_attributes:

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

schema_name_id: 1616
schema_scan_id: 162000393
updated: 2026-04-14 03:03:59

Version 1712757

created: 2026-04-13 02:57:19

ddl:

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

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

schema_attributes:

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

schema_name_id: 1616
schema_scan_id: 161941565
updated: 2026-04-13 02:57:33

Version 1711573

created: 2026-04-12 03:00:07

ddl:

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

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

schema_attributes:

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

schema_name_id: 1616
schema_scan_id: 161892552
updated: 2026-04-12 03:00:20

Version 1710351

created: 2026-04-11 03:02:22

ddl:

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

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

schema_attributes:

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

schema_name_id: 1616
schema_scan_id: 161841055
updated: 2026-04-11 03:02:33

Version 1709174

created: 2026-04-10 03:03:19

ddl:

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

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

schema_attributes:

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

schema_name_id: 1616
schema_scan_id: 161785840
updated: 2026-04-10 03:03:32

Version 1708077

created: 2026-04-09 03:01:28

ddl:

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

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

schema_attributes:

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

schema_name_id: 1616
schema_scan_id: 161730065
updated: 2026-04-09 03:01:42

Version 1706930

created: 2026-04-08 03:06:48

ddl:

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

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

schema_attributes:

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

schema_name_id: 1616
schema_scan_id: 161675568
updated: 2026-04-08 03:07:02

Version 1705678

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1616
schema_scan_id: 161618367
updated: 2026-04-07 02:56:16

Version 1704428

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1616
schema_scan_id: 161561445
updated: 2026-04-06 03:02:58

Version 1703189

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1616
schema_scan_id: 161514728
updated: 2026-04-05 03:00:49

Version 1702081

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1616
schema_scan_id: 161460003
updated: 2026-04-04 03:02:04

Version 1700819

created: 2026-04-03 03:03:37

ddl:

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

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

schema_attributes:

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

schema_name_id: 1616
schema_scan_id: 161401651
updated: 2026-04-03 03:03:48

Schema Scans: 15

Last at 2026-04-17 03:03:06

Scan 162167437

duration: 0:00:14.070863

exit_message:

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

id: 162167437

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_moloInsuranceStatusSet/2026-04-17/1776412733",
        "key": "raw/molo_moloInsuranceStatusSet/2026-04-17/1776412733/InsuranceStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInsuranceStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3969154243008980500,
        "service_name": "drive-thru",
        "span_id": 3019558716423074240,
        "trace_id": 7449822837367589519
    }
}

running: False
schema_name_id: 1616
start_time: 2026-04-17 03:03:06
success: True
trace_id: 7449822837367589519

Scan 162111776

duration: 0:00:11.573078

exit_message:

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

id: 162111776

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_moloInsuranceStatusSet/2026-04-16/1776326491",
        "key": "raw/molo_moloInsuranceStatusSet/2026-04-16/1776326491/InsuranceStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInsuranceStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2829395716119568350,
        "service_name": "drive-thru",
        "span_id": 15626201806524946355,
        "trace_id": 17065299615107996603
    }
}

running: False
schema_name_id: 1616
start_time: 2026-04-16 03:06:35
success: True
trace_id: 17065299615107996603

Scan 162055890

duration: 0:00:14.049688

exit_message:

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

id: 162055890

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_moloInsuranceStatusSet/2026-04-15/1776239961",
        "key": "raw/molo_moloInsuranceStatusSet/2026-04-15/1776239961/InsuranceStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInsuranceStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7935690274878544589,
        "service_name": "drive-thru",
        "span_id": 12996625780331923353,
        "trace_id": 348280987269013486
    }
}

running: False
schema_name_id: 1616
start_time: 2026-04-15 03:04:18
success: True
trace_id: 348280987269013486

Scan 162000393

duration: 0:00:14.103703

exit_message:

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

id: 162000393

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_moloInsuranceStatusSet/2026-04-14/1776153687",
        "key": "raw/molo_moloInsuranceStatusSet/2026-04-14/1776153687/InsuranceStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInsuranceStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16265578746101490120,
        "service_name": "drive-thru",
        "span_id": 15651562165916445056,
        "trace_id": 12253288439039696835
    }
}

running: False
schema_name_id: 1616
start_time: 2026-04-14 03:03:45
success: True
trace_id: 12253288439039696835

Scan 161941565

duration: 0:00:13.972027

exit_message:

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

id: 161941565

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_moloInsuranceStatusSet/2026-04-13/1776066881",
        "key": "raw/molo_moloInsuranceStatusSet/2026-04-13/1776066881/InsuranceStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInsuranceStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18009054242787307611,
        "service_name": "drive-thru",
        "span_id": 6269155642539255308,
        "trace_id": 454640204241718767
    }
}

running: False
schema_name_id: 1616
start_time: 2026-04-13 02:57:19
success: True
trace_id: 454640204241718767

Scan 161892552

duration: 0:00:14.038757

exit_message:

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

id: 161892552

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_moloInsuranceStatusSet/2026-04-12/1775980595",
        "key": "raw/molo_moloInsuranceStatusSet/2026-04-12/1775980595/InsuranceStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInsuranceStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16113694450792959807,
        "service_name": "drive-thru",
        "span_id": 2837066768233209105,
        "trace_id": 7424447057326484364
    }
}

running: False
schema_name_id: 1616
start_time: 2026-04-12 03:00:06
success: True
trace_id: 7424447057326484364

Scan 161841055

duration: 0:00:11.468624

exit_message:

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

id: 161841055

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_moloInsuranceStatusSet/2026-04-11/1775894357",
        "key": "raw/molo_moloInsuranceStatusSet/2026-04-11/1775894357/InsuranceStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInsuranceStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10803781436709741454,
        "service_name": "drive-thru",
        "span_id": 4986722149697642078,
        "trace_id": 16678355055878727799
    }
}

running: False
schema_name_id: 1616
start_time: 2026-04-11 03:02:22
success: True
trace_id: 16678355055878727799

Scan 161785840

duration: 0:00:14.048370

exit_message:

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

id: 161785840

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_moloInsuranceStatusSet/2026-04-10/1775808112",
        "key": "raw/molo_moloInsuranceStatusSet/2026-04-10/1775808112/InsuranceStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInsuranceStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14094799695334267938,
        "service_name": "drive-thru",
        "span_id": 6515204955068667594,
        "trace_id": 8402690518525435098
    }
}

running: False
schema_name_id: 1616
start_time: 2026-04-10 03:03:18
success: True
trace_id: 8402690518525435098

Scan 161730065

duration: 0:00:14.132161

exit_message:

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

id: 161730065

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_moloInsuranceStatusSet/2026-04-09/1775721451",
        "key": "raw/molo_moloInsuranceStatusSet/2026-04-09/1775721451/InsuranceStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInsuranceStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6479994597254285756,
        "service_name": "drive-thru",
        "span_id": 8331914310916465574,
        "trace_id": 17536799451666946163
    }
}

running: False
schema_name_id: 1616
start_time: 2026-04-09 03:01:28
success: True
trace_id: 17536799451666946163

Scan 161675568

duration: 0:00:13.921985

exit_message:

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

id: 161675568

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_moloInsuranceStatusSet/2026-04-08/1775635259",
        "key": "raw/molo_moloInsuranceStatusSet/2026-04-08/1775635259/InsuranceStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInsuranceStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6663675586575175141,
        "service_name": "drive-thru",
        "span_id": 810424843021168143,
        "trace_id": 18428764732221092925
    }
}

running: False
schema_name_id: 1616
start_time: 2026-04-08 03:06:48
success: True
trace_id: 18428764732221092925

Scan 161618367

duration: 0:00:11.453981

exit_message:

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

id: 161618367

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_moloInsuranceStatusSet/2026-04-07/1775548431",
        "key": "raw/molo_moloInsuranceStatusSet/2026-04-07/1775548431/InsuranceStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInsuranceStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17095913157163210364,
        "service_name": "drive-thru",
        "span_id": 13214471740470210636,
        "trace_id": 14446623200433511669
    }
}

running: False
schema_name_id: 1616
start_time: 2026-04-07 02:56:05
success: True
trace_id: 14446623200433511669

Scan 161561445

duration: 0:00:11.471112

exit_message:

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

id: 161561445

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_moloInsuranceStatusSet/2026-04-06/1775462399",
        "key": "raw/molo_moloInsuranceStatusSet/2026-04-06/1775462399/InsuranceStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInsuranceStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7797431988553084888,
        "service_name": "drive-thru",
        "span_id": 5525581451284075954,
        "trace_id": 4679750924230270080
    }
}

running: False
schema_name_id: 1616
start_time: 2026-04-06 03:02:46
success: True
trace_id: 4679750924230270080

Scan 161514728

duration: 0:00:14.081071

exit_message:

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

id: 161514728

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_moloInsuranceStatusSet/2026-04-05/1775376024",
        "key": "raw/molo_moloInsuranceStatusSet/2026-04-05/1775376024/InsuranceStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInsuranceStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2415666293706993673,
        "service_name": "drive-thru",
        "span_id": 17068267141759471006,
        "trace_id": 7381019503695499962
    }
}

running: False
schema_name_id: 1616
start_time: 2026-04-05 03:00:35
success: True
trace_id: 7381019503695499962

Scan 161460003

duration: 0:00:13.934974

exit_message:

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

id: 161460003

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_moloInsuranceStatusSet/2026-04-04/1775289507",
        "key": "raw/molo_moloInsuranceStatusSet/2026-04-04/1775289507/InsuranceStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInsuranceStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17913456369190199984,
        "service_name": "drive-thru",
        "span_id": 13943063606807515166,
        "trace_id": 2893358058591397076
    }
}

running: False
schema_name_id: 1616
start_time: 2026-04-04 03:01:50
success: True
trace_id: 2893358058591397076

Scan 161401651

duration: 0:00:11.570667

exit_message:

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

id: 161401651

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_moloInsuranceStatusSet/2026-04-03/1775203279",
        "key": "raw/molo_moloInsuranceStatusSet/2026-04-03/1775203279/InsuranceStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInsuranceStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17579008288411722229,
        "service_name": "drive-thru",
        "span_id": 8614620329767152409,
        "trace_id": 4516510743474689257
    }
}

running: False
schema_name_id: 1616
start_time: 2026-04-03 03:03:36
success: True
trace_id: 4516510743474689257

Partitions:

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

Schema:

attributes:

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

created: 2026-04-17 03:03:06

ddl:

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

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