Schema Info

Schema Name: sfdl_prod_drivethru.molo_molophonetypes

created: 2023-10-17 02:00:10
disabled: False
format: raw
id: 1737
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717677

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1737
schema_scan_id: 162167660
updated: 2026-04-17 03:06:45

Version 1716361

created: 2026-04-16 03:05:56

ddl:

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

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

schema_attributes:

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

schema_name_id: 1737
schema_scan_id: 162111749
updated: 2026-04-16 03:06:07

Version 1715221

created: 2026-04-15 03:05:38

ddl:

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

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

schema_attributes:

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

schema_name_id: 1737
schema_scan_id: 162055950
updated: 2026-04-15 03:05:49

Version 1714082

created: 2026-04-14 03:08:38

ddl:

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

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

schema_attributes:

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

schema_name_id: 1737
schema_scan_id: 162000585
updated: 2026-04-14 03:08:49

Version 1712829

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1737
schema_scan_id: 161941842
updated: 2026-04-13 03:00:19

Version 1711596

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1737
schema_scan_id: 161892688
updated: 2026-04-12 03:01:11

Version 1710390

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1737
schema_scan_id: 161841138
updated: 2026-04-11 03:04:15

Version 1709184

created: 2026-04-10 03:03:47

ddl:

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

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

schema_attributes:

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

schema_name_id: 1737
schema_scan_id: 161785864
updated: 2026-04-10 03:04:01

Version 1708098

created: 2026-04-09 03:02:21

ddl:

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

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

schema_attributes:

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

schema_name_id: 1737
schema_scan_id: 161730168
updated: 2026-04-09 03:02:35

Version 1706872

created: 2026-04-08 03:04:08

ddl:

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

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

schema_attributes:

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

schema_name_id: 1737
schema_scan_id: 161675458
updated: 2026-04-08 03:04:21

Version 1705747

created: 2026-04-07 02:58:46

ddl:

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

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

schema_attributes:

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

schema_name_id: 1737
schema_scan_id: 161618511
updated: 2026-04-07 02:59:00

Version 1704453

created: 2026-04-06 03:03:57

ddl:

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

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

schema_attributes:

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

schema_name_id: 1737
schema_scan_id: 161561512
updated: 2026-04-06 03:04:09

Version 1703257

created: 2026-04-05 03:03:25

ddl:

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

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

schema_attributes:

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

schema_name_id: 1737
schema_scan_id: 161514831
updated: 2026-04-05 03:03:39

Version 1702162

created: 2026-04-04 03:05:27

ddl:

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

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

schema_attributes:

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

schema_name_id: 1737
schema_scan_id: 161460369
updated: 2026-04-04 03:05:41

Version 1700936

created: 2026-04-03 03:09:40

ddl:

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

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

schema_attributes:

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

schema_name_id: 1737
schema_scan_id: 161401890
updated: 2026-04-03 03:09:51

Schema Scans: 15

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

Scan 162167660

duration: 0:00:14.189385

exit_message:

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

id: 162167660

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_moloPhoneTypes/2026-04-17/1776412811",
        "key": "raw/molo_moloPhoneTypes/2026-04-17/1776412811/PhoneTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPhoneTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1423258294606968125,
        "service_name": "drive-thru",
        "span_id": 15391658146858599929,
        "trace_id": 919209310904388536
    }
}

running: False
schema_name_id: 1737
start_time: 2026-04-17 03:06:30
success: True
trace_id: 919209310904388536

Scan 162111749

duration: 0:00:11.414135

exit_message:

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

id: 162111749

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_moloPhoneTypes/2026-04-16/1776326567",
        "key": "raw/molo_moloPhoneTypes/2026-04-16/1776326567/PhoneTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPhoneTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11458572408203147868,
        "service_name": "drive-thru",
        "span_id": 7037796845824029348,
        "trace_id": 14768976052526960296
    }
}

running: False
schema_name_id: 1737
start_time: 2026-04-16 03:05:55
success: True
trace_id: 14768976052526960296

Scan 162055950

duration: 0:00:11.459695

exit_message:

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

id: 162055950

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_moloPhoneTypes/2026-04-15/1776240036",
        "key": "raw/molo_moloPhoneTypes/2026-04-15/1776240036/PhoneTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPhoneTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16227650597021517753,
        "service_name": "drive-thru",
        "span_id": 6948739706622593857,
        "trace_id": 3021072818896133415
    }
}

running: False
schema_name_id: 1737
start_time: 2026-04-15 03:05:37
success: True
trace_id: 3021072818896133415

Scan 162000585

duration: 0:00:11.551448

exit_message:

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

id: 162000585

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_moloPhoneTypes/2026-04-14/1776153766",
        "key": "raw/molo_moloPhoneTypes/2026-04-14/1776153766/PhoneTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPhoneTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4439887405756656201,
        "service_name": "drive-thru",
        "span_id": 2234910291806253590,
        "trace_id": 13845872574737528549
    }
}

running: False
schema_name_id: 1737
start_time: 2026-04-14 03:08:38
success: True
trace_id: 13845872574737528549

Scan 161941842

duration: 0:00:14.019198

exit_message:

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

id: 161941842

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_moloPhoneTypes/2026-04-13/1776066959",
        "key": "raw/molo_moloPhoneTypes/2026-04-13/1776066959/PhoneTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPhoneTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2973339916597218324,
        "service_name": "drive-thru",
        "span_id": 326471273317908002,
        "trace_id": 6910329710907080449
    }
}

running: False
schema_name_id: 1737
start_time: 2026-04-13 03:00:05
success: True
trace_id: 6910329710907080449

Scan 161892688

duration: 0:00:14.045995

exit_message:

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

id: 161892688

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_moloPhoneTypes/2026-04-12/1775980673",
        "key": "raw/molo_moloPhoneTypes/2026-04-12/1775980673/PhoneTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPhoneTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 984334010545201985,
        "service_name": "drive-thru",
        "span_id": 7813435205355967388,
        "trace_id": 6198732264454000363
    }
}

running: False
schema_name_id: 1737
start_time: 2026-04-12 03:00:57
success: True
trace_id: 6198732264454000363

Scan 161841138

duration: 0:00:14.094619

exit_message:

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

id: 161841138

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_moloPhoneTypes/2026-04-11/1775894433",
        "key": "raw/molo_moloPhoneTypes/2026-04-11/1775894433/PhoneTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPhoneTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15695636539462153028,
        "service_name": "drive-thru",
        "span_id": 9164401694901591887,
        "trace_id": 7119900590118596871
    }
}

running: False
schema_name_id: 1737
start_time: 2026-04-11 03:04:01
success: True
trace_id: 7119900590118596871

Scan 161785864

duration: 0:00:14.262660

exit_message:

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

id: 161785864

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_moloPhoneTypes/2026-04-10/1775808190",
        "key": "raw/molo_moloPhoneTypes/2026-04-10/1775808190/PhoneTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPhoneTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9740920503442908962,
        "service_name": "drive-thru",
        "span_id": 10207779186474939617,
        "trace_id": 16472028265841180301
    }
}

running: False
schema_name_id: 1737
start_time: 2026-04-10 03:03:47
success: True
trace_id: 16472028265841180301

Scan 161730168

duration: 0:00:14.007603

exit_message:

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

id: 161730168

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_moloPhoneTypes/2026-04-09/1775721530",
        "key": "raw/molo_moloPhoneTypes/2026-04-09/1775721530/PhoneTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPhoneTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18226681439077883305,
        "service_name": "drive-thru",
        "span_id": 13636624906479108802,
        "trace_id": 5796685085935041898
    }
}

running: False
schema_name_id: 1737
start_time: 2026-04-09 03:02:21
success: True
trace_id: 5796685085935041898

Scan 161675458

duration: 0:00:14.159889

exit_message:

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

id: 161675458

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_moloPhoneTypes/2026-04-08/1775635357",
        "key": "raw/molo_moloPhoneTypes/2026-04-08/1775635357/PhoneTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPhoneTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9152643294241668372,
        "service_name": "drive-thru",
        "span_id": 10135142226735054607,
        "trace_id": 9519711357028928377
    }
}

running: False
schema_name_id: 1737
start_time: 2026-04-08 03:04:07
success: True
trace_id: 9519711357028928377

Scan 161618511

duration: 0:00:14.305718

exit_message:

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

id: 161618511

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_moloPhoneTypes/2026-04-07/1775548507",
        "key": "raw/molo_moloPhoneTypes/2026-04-07/1775548507/PhoneTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPhoneTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15757718367582267887,
        "service_name": "drive-thru",
        "span_id": 17743615701477068437,
        "trace_id": 10330281360020207452
    }
}

running: False
schema_name_id: 1737
start_time: 2026-04-07 02:58:45
success: True
trace_id: 10330281360020207452

Scan 161561512

duration: 0:00:11.501864

exit_message:

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

id: 161561512

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_moloPhoneTypes/2026-04-06/1775462474",
        "key": "raw/molo_moloPhoneTypes/2026-04-06/1775462474/PhoneTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPhoneTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1609207386791217241,
        "service_name": "drive-thru",
        "span_id": 8295164891926794798,
        "trace_id": 1196557672418695900
    }
}

running: False
schema_name_id: 1737
start_time: 2026-04-06 03:03:57
success: True
trace_id: 1196557672418695900

Scan 161514831

duration: 0:00:14.127263

exit_message:

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

id: 161514831

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_moloPhoneTypes/2026-04-05/1775376100",
        "key": "raw/molo_moloPhoneTypes/2026-04-05/1775376100/PhoneTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPhoneTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1641108806105284368,
        "service_name": "drive-thru",
        "span_id": 16636240993845486263,
        "trace_id": 18381794049684465391
    }
}

running: False
schema_name_id: 1737
start_time: 2026-04-05 03:03:25
success: True
trace_id: 18381794049684465391

Scan 161460369

duration: 0:00:14.011893

exit_message:

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

id: 161460369

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_moloPhoneTypes/2026-04-04/1775289583",
        "key": "raw/molo_moloPhoneTypes/2026-04-04/1775289583/PhoneTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPhoneTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8019207180621804761,
        "service_name": "drive-thru",
        "span_id": 4083942954576315165,
        "trace_id": 3181578182473455297
    }
}

running: False
schema_name_id: 1737
start_time: 2026-04-04 03:05:27
success: True
trace_id: 3181578182473455297

Scan 161401890

duration: 0:00:11.599644

exit_message:

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

id: 161401890

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_moloPhoneTypes/2026-04-03/1775203355",
        "key": "raw/molo_moloPhoneTypes/2026-04-03/1775203355/PhoneTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPhoneTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11337234893964817989,
        "service_name": "drive-thru",
        "span_id": 11704077535062281156,
        "trace_id": 855849486907070566
    }
}

running: False
schema_name_id: 1737
start_time: 2026-04-03 03:09:39
success: True
trace_id: 855849486907070566

Partitions:

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

Schema:

attributes:

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

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

ddl:

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

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