Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloaddresstypeset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717572

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1570
schema_scan_id: 162167192
updated: 2026-04-17 03:00:28

Version 1716413

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1570
schema_scan_id: 162111847
updated: 2026-04-16 03:08:29

Version 1715129

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1570
schema_scan_id: 162055642
updated: 2026-04-15 03:00:54

Version 1713949

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1570
schema_scan_id: 162000370
updated: 2026-04-14 03:03:05

Version 1712710

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1570
schema_scan_id: 161941477
updated: 2026-04-13 02:55:36

Version 1711493

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1570
schema_scan_id: 161892239
updated: 2026-04-12 02:56:20

Version 1710318

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1570
schema_scan_id: 161840932
updated: 2026-04-11 03:00:50

Version 1709141

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1570
schema_scan_id: 161785769
updated: 2026-04-10 03:01:53

Version 1708002

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1570
schema_scan_id: 161729694
updated: 2026-04-09 02:57:59

Version 1706792

created: 2026-04-08 03:00:32

ddl:

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

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

schema_attributes:

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

schema_name_id: 1570
schema_scan_id: 161675243
updated: 2026-04-08 03:00:43

Version 1705632

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1570
schema_scan_id: 161618309
updated: 2026-04-07 02:54:28

Version 1704400

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1570
schema_scan_id: 161561370
updated: 2026-04-06 03:01:41

Version 1703174

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1570
schema_scan_id: 161514674
updated: 2026-04-05 03:00:06

Version 1702029

created: 2026-04-04 02:59:38

ddl:

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

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

schema_attributes:

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

schema_name_id: 1570
schema_scan_id: 161459797
updated: 2026-04-04 02:59:52

Version 1700940

created: 2026-04-03 03:09:44

ddl:

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

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

schema_attributes:

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

schema_name_id: 1570
schema_scan_id: 161401895
updated: 2026-04-03 03:09:55

Schema Scans: 15

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

Scan 162167192

duration: 0:00:14.105202

exit_message:

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

id: 162167192

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_moloAddressTypeSet/2026-04-17/1776412687",
        "key": "raw/molo_moloAddressTypeSet/2026-04-17/1776412687/AddressTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAddressTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17282486253659333905,
        "service_name": "drive-thru",
        "span_id": 8658111126719410839,
        "trace_id": 7518480853845110916
    }
}

running: False
schema_name_id: 1570
start_time: 2026-04-17 03:00:14
success: True
trace_id: 7518480853845110916

Scan 162111847

duration: 0:00:11.529509

exit_message:

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

id: 162111847

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_moloAddressTypeSet/2026-04-16/1776326453",
        "key": "raw/molo_moloAddressTypeSet/2026-04-16/1776326453/AddressTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAddressTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18171850173853363019,
        "service_name": "drive-thru",
        "span_id": 87520932286194248,
        "trace_id": 10382722428881646571
    }
}

running: False
schema_name_id: 1570
start_time: 2026-04-16 03:08:18
success: True
trace_id: 10382722428881646571

Scan 162055642

duration: 0:00:11.498252

exit_message:

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

id: 162055642

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_moloAddressTypeSet/2026-04-15/1776239926",
        "key": "raw/molo_moloAddressTypeSet/2026-04-15/1776239926/AddressTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAddressTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11141975556173033837,
        "service_name": "drive-thru",
        "span_id": 13928454472158445471,
        "trace_id": 15312349634563961368
    }
}

running: False
schema_name_id: 1570
start_time: 2026-04-15 03:00:43
success: True
trace_id: 15312349634563961368

Scan 162000370

duration: 0:00:11.585891

exit_message:

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

id: 162000370

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_moloAddressTypeSet/2026-04-14/1776153650",
        "key": "raw/molo_moloAddressTypeSet/2026-04-14/1776153650/AddressTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAddressTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7919838729288223476,
        "service_name": "drive-thru",
        "span_id": 15987296347107144423,
        "trace_id": 1300276191329362639
    }
}

running: False
schema_name_id: 1570
start_time: 2026-04-14 03:02:53
success: True
trace_id: 1300276191329362639

Scan 161941477

duration: 0:00:11.518061

exit_message:

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

id: 161941477

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_moloAddressTypeSet/2026-04-13/1776066840",
        "key": "raw/molo_moloAddressTypeSet/2026-04-13/1776066840/AddressTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAddressTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2784097709783267112,
        "service_name": "drive-thru",
        "span_id": 4178962485248181303,
        "trace_id": 3253554379087689776
    }
}

running: False
schema_name_id: 1570
start_time: 2026-04-13 02:55:25
success: True
trace_id: 3253554379087689776

Scan 161892239

duration: 0:00:14.102083

exit_message:

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

id: 161892239

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_moloAddressTypeSet/2026-04-12/1775980556",
        "key": "raw/molo_moloAddressTypeSet/2026-04-12/1775980556/AddressTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAddressTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14505136101029908284,
        "service_name": "drive-thru",
        "span_id": 8712743910265973116,
        "trace_id": 11450848439433083304
    }
}

running: False
schema_name_id: 1570
start_time: 2026-04-12 02:56:06
success: True
trace_id: 11450848439433083304

Scan 161840932

duration: 0:00:11.521218

exit_message:

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

id: 161840932

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_moloAddressTypeSet/2026-04-11/1775894315",
        "key": "raw/molo_moloAddressTypeSet/2026-04-11/1775894315/AddressTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAddressTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16845963568155855716,
        "service_name": "drive-thru",
        "span_id": 11962152652427508625,
        "trace_id": 956473660167809810
    }
}

running: False
schema_name_id: 1570
start_time: 2026-04-11 03:00:39
success: True
trace_id: 956473660167809810

Scan 161785769

duration: 0:00:14.045468

exit_message:

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

id: 161785769

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_moloAddressTypeSet/2026-04-10/1775808075",
        "key": "raw/molo_moloAddressTypeSet/2026-04-10/1775808075/AddressTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAddressTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6524010702654540180,
        "service_name": "drive-thru",
        "span_id": 2432593226715298150,
        "trace_id": 8505071187697784131
    }
}

running: False
schema_name_id: 1570
start_time: 2026-04-10 03:01:39
success: True
trace_id: 8505071187697784131

Scan 161729694

duration: 0:00:14.113569

exit_message:

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

id: 161729694

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_moloAddressTypeSet/2026-04-09/1775721416",
        "key": "raw/molo_moloAddressTypeSet/2026-04-09/1775721416/AddressTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAddressTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11380273848017760257,
        "service_name": "drive-thru",
        "span_id": 16354030282431023245,
        "trace_id": 8409191747391698383
    }
}

running: False
schema_name_id: 1570
start_time: 2026-04-09 02:57:45
success: True
trace_id: 8409191747391698383

Scan 161675243

duration: 0:00:11.627883

exit_message:

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

id: 161675243

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_moloAddressTypeSet/2026-04-08/1775635219",
        "key": "raw/molo_moloAddressTypeSet/2026-04-08/1775635219/AddressTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAddressTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2992717713662947912,
        "service_name": "drive-thru",
        "span_id": 11002291614588449701,
        "trace_id": 4333707830148085120
    }
}

running: False
schema_name_id: 1570
start_time: 2026-04-08 03:00:31
success: True
trace_id: 4333707830148085120

Scan 161618309

duration: 0:00:11.452284

exit_message:

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

id: 161618309

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_moloAddressTypeSet/2026-04-07/1775548394",
        "key": "raw/molo_moloAddressTypeSet/2026-04-07/1775548394/AddressTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAddressTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11539598755337345902,
        "service_name": "drive-thru",
        "span_id": 6713115181804946040,
        "trace_id": 13750183464298233706
    }
}

running: False
schema_name_id: 1570
start_time: 2026-04-07 02:54:17
success: True
trace_id: 13750183464298233706

Scan 161561370

duration: 0:00:14.039716

exit_message:

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

id: 161561370

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_moloAddressTypeSet/2026-04-06/1775462357",
        "key": "raw/molo_moloAddressTypeSet/2026-04-06/1775462357/AddressTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAddressTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6457841037813169624,
        "service_name": "drive-thru",
        "span_id": 8233373313100296900,
        "trace_id": 4617927823568987470
    }
}

running: False
schema_name_id: 1570
start_time: 2026-04-06 03:01:27
success: True
trace_id: 4617927823568987470

Scan 161514674

duration: 0:00:14.132069

exit_message:

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

id: 161514674

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_moloAddressTypeSet/2026-04-05/1775375984",
        "key": "raw/molo_moloAddressTypeSet/2026-04-05/1775375984/AddressTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAddressTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5916568629129503632,
        "service_name": "drive-thru",
        "span_id": 13248992893382553771,
        "trace_id": 5394828395533371942
    }
}

running: False
schema_name_id: 1570
start_time: 2026-04-05 02:59:52
success: True
trace_id: 5394828395533371942

Scan 161459797

duration: 0:00:14.091753

exit_message:

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

id: 161459797

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_moloAddressTypeSet/2026-04-04/1775289475",
        "key": "raw/molo_moloAddressTypeSet/2026-04-04/1775289475/AddressTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAddressTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14613266601345722224,
        "service_name": "drive-thru",
        "span_id": 6908557619976115496,
        "trace_id": 10307095166582117376
    }
}

running: False
schema_name_id: 1570
start_time: 2026-04-04 02:59:38
success: True
trace_id: 10307095166582117376

Scan 161401895

duration: 0:00:11.531339

exit_message:

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

id: 161401895

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_moloAddressTypeSet/2026-04-03/1775203244",
        "key": "raw/molo_moloAddressTypeSet/2026-04-03/1775203244/AddressTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAddressTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3784797335277558117,
        "service_name": "drive-thru",
        "span_id": 17745820537038068421,
        "trace_id": 10972575374362045002
    }
}

running: False
schema_name_id: 1570
start_time: 2026-04-03 03:09:44
success: True
trace_id: 10972575374362045002

Partitions:

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

Schema:

attributes:

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

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

ddl:

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

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