Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloxerophonetypeset

created: 2023-10-17 02:02:14
disabled: False
format: raw
id: 1791
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717830

created: 2026-04-17 03:13:49

ddl:

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

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

schema_attributes:

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

schema_name_id: 1791
schema_scan_id: 162167867
updated: 2026-04-17 03:14:03

Version 1716568

created: 2026-04-16 03:14:09

ddl:

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

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

schema_attributes:

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

schema_name_id: 1791
schema_scan_id: 162112028
updated: 2026-04-16 03:14:20

Version 1715356

created: 2026-04-15 03:11:56

ddl:

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

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

schema_attributes:

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

schema_name_id: 1791
schema_scan_id: 162056155
updated: 2026-04-15 03:12:07

Version 1714176

created: 2026-04-14 03:12:15

ddl:

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

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

schema_attributes:

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

schema_name_id: 1791
schema_scan_id: 162000700
updated: 2026-04-14 03:12:26

Version 1712904

created: 2026-04-13 03:03:46

ddl:

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

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

schema_attributes:

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

schema_name_id: 1791
schema_scan_id: 161942596
updated: 2026-04-13 03:04:00

Version 1711764

created: 2026-04-12 03:08:31

ddl:

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

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

schema_attributes:

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

schema_name_id: 1791
schema_scan_id: 161893467
updated: 2026-04-12 03:08:42

Version 1710500

created: 2026-04-11 03:08:24

ddl:

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

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

schema_attributes:

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

schema_name_id: 1791
schema_scan_id: 161841289
updated: 2026-04-11 03:08:37

Version 1709414

created: 2026-04-10 03:12:43

ddl:

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

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

schema_attributes:

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

schema_name_id: 1791
schema_scan_id: 161786118
updated: 2026-04-10 03:12:54

Version 1708284

created: 2026-04-09 03:10:36

ddl:

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

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

schema_attributes:

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

schema_name_id: 1791
schema_scan_id: 161730580
updated: 2026-04-09 03:10:48

Version 1706977

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1791
schema_scan_id: 161675633
updated: 2026-04-08 03:08:50

Version 1705866

created: 2026-04-07 03:04:11

ddl:

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

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

schema_attributes:

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

schema_name_id: 1791
schema_scan_id: 161619395
updated: 2026-04-07 03:04:25

Version 1704664

created: 2026-04-06 03:12:37

ddl:

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

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

schema_attributes:

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

schema_name_id: 1791
schema_scan_id: 161561821
updated: 2026-04-06 03:12:50

Version 1703453

created: 2026-04-05 03:11:03

ddl:

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

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

schema_attributes:

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

schema_name_id: 1791
schema_scan_id: 161515043
updated: 2026-04-05 03:11:15

Version 1702254

created: 2026-04-04 03:09:53

ddl:

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

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

schema_attributes:

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

schema_name_id: 1791
schema_scan_id: 161460554
updated: 2026-04-04 03:10:04

Version 1701097

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1791
schema_scan_id: 161402102
updated: 2026-04-03 03:21:23

Schema Scans: 15

Last at 2026-04-17 03:13:49

Scan 162167867

duration: 0:00:14.050136

exit_message:

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

id: 162167867

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_moloXeroPhoneTypeSet/2026-04-17/1776413279",
        "key": "raw/molo_moloXeroPhoneTypeSet/2026-04-17/1776413279/XeroPhoneTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroPhoneTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11850117181162978316,
        "service_name": "drive-thru",
        "span_id": 15700159071642596799,
        "trace_id": 15955248227161051106
    }
}

running: False
schema_name_id: 1791
start_time: 2026-04-17 03:13:49
success: True
trace_id: 15955248227161051106

Scan 162112028

duration: 0:00:11.475762

exit_message:

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

id: 162112028

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_moloXeroPhoneTypeSet/2026-04-16/1776326754",
        "key": "raw/molo_moloXeroPhoneTypeSet/2026-04-16/1776326754/XeroPhoneTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroPhoneTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8255298194069876580,
        "service_name": "drive-thru",
        "span_id": 5037768675785842150,
        "trace_id": 6139465945885102325
    }
}

running: False
schema_name_id: 1791
start_time: 2026-04-16 03:14:08
success: True
trace_id: 6139465945885102325

Scan 162056155

duration: 0:00:11.572347

exit_message:

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

id: 162056155

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_moloXeroPhoneTypeSet/2026-04-15/1776240217",
        "key": "raw/molo_moloXeroPhoneTypeSet/2026-04-15/1776240217/XeroPhoneTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroPhoneTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4729035448623624679,
        "service_name": "drive-thru",
        "span_id": 1334694228629411318,
        "trace_id": 2248484283771225661
    }
}

running: False
schema_name_id: 1791
start_time: 2026-04-15 03:11:56
success: True
trace_id: 2248484283771225661

Scan 162000700

duration: 0:00:11.451087

exit_message:

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

id: 162000700

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_moloXeroPhoneTypeSet/2026-04-14/1776154178",
        "key": "raw/molo_moloXeroPhoneTypeSet/2026-04-14/1776154178/XeroPhoneTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroPhoneTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7665867978155887270,
        "service_name": "drive-thru",
        "span_id": 12446275002633121318,
        "trace_id": 10959686334119916101
    }
}

running: False
schema_name_id: 1791
start_time: 2026-04-14 03:12:15
success: True
trace_id: 10959686334119916101

Scan 161942596

duration: 0:00:14.003503

exit_message:

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

id: 161942596

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_moloXeroPhoneTypeSet/2026-04-13/1776067172",
        "key": "raw/molo_moloXeroPhoneTypeSet/2026-04-13/1776067172/XeroPhoneTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroPhoneTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1377066858326761576,
        "service_name": "drive-thru",
        "span_id": 8730573706015615455,
        "trace_id": 5519509558553241252
    }
}

running: False
schema_name_id: 1791
start_time: 2026-04-13 03:03:46
success: True
trace_id: 5519509558553241252

Scan 161893467

duration: 0:00:11.539154

exit_message:

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

id: 161893467

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_moloXeroPhoneTypeSet/2026-04-12/1775980874",
        "key": "raw/molo_moloXeroPhoneTypeSet/2026-04-12/1775980874/XeroPhoneTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroPhoneTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11480207519683028322,
        "service_name": "drive-thru",
        "span_id": 8797689701369741926,
        "trace_id": 17009624398603746007
    }
}

running: False
schema_name_id: 1791
start_time: 2026-04-12 03:08:31
success: True
trace_id: 17009624398603746007

Scan 161841289

duration: 0:00:13.942323

exit_message:

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

id: 161841289

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_moloXeroPhoneTypeSet/2026-04-11/1775894653",
        "key": "raw/molo_moloXeroPhoneTypeSet/2026-04-11/1775894653/XeroPhoneTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroPhoneTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9307889918505344217,
        "service_name": "drive-thru",
        "span_id": 2509483746269970653,
        "trace_id": 2766898172410961548
    }
}

running: False
schema_name_id: 1791
start_time: 2026-04-11 03:08:23
success: True
trace_id: 2766898172410961548

Scan 161786118

duration: 0:00:11.603119

exit_message:

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

id: 161786118

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_moloXeroPhoneTypeSet/2026-04-10/1775808407",
        "key": "raw/molo_moloXeroPhoneTypeSet/2026-04-10/1775808407/XeroPhoneTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroPhoneTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14355767503175609945,
        "service_name": "drive-thru",
        "span_id": 15336018724886698011,
        "trace_id": 4511623091560535303
    }
}

running: False
schema_name_id: 1791
start_time: 2026-04-10 03:12:42
success: True
trace_id: 4511623091560535303

Scan 161730580

duration: 0:00:11.530677

exit_message:

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

id: 161730580

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_moloXeroPhoneTypeSet/2026-04-09/1775721737",
        "key": "raw/molo_moloXeroPhoneTypeSet/2026-04-09/1775721737/XeroPhoneTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroPhoneTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8021921255240213230,
        "service_name": "drive-thru",
        "span_id": 10989504492449333056,
        "trace_id": 15386001170500743213
    }
}

running: False
schema_name_id: 1791
start_time: 2026-04-09 03:10:36
success: True
trace_id: 15386001170500743213

Scan 161675633

duration: 0:00:14.122011

exit_message:

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

id: 161675633

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_moloXeroPhoneTypeSet/2026-04-08/1775635565",
        "key": "raw/molo_moloXeroPhoneTypeSet/2026-04-08/1775635565/XeroPhoneTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroPhoneTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13201619676681213466,
        "service_name": "drive-thru",
        "span_id": 2309476102658687406,
        "trace_id": 8279062703839046732
    }
}

running: False
schema_name_id: 1791
start_time: 2026-04-08 03:08:36
success: True
trace_id: 8279062703839046732

Scan 161619395

duration: 0:00:13.975958

exit_message:

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

id: 161619395

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_moloXeroPhoneTypeSet/2026-04-07/1775548724",
        "key": "raw/molo_moloXeroPhoneTypeSet/2026-04-07/1775548724/XeroPhoneTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroPhoneTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10329954466677731000,
        "service_name": "drive-thru",
        "span_id": 8616326361512910190,
        "trace_id": 7679022168627425957
    }
}

running: False
schema_name_id: 1791
start_time: 2026-04-07 03:04:11
success: True
trace_id: 7679022168627425957

Scan 161561821

duration: 0:00:14.020658

exit_message:

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

id: 161561821

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_moloXeroPhoneTypeSet/2026-04-06/1775462677",
        "key": "raw/molo_moloXeroPhoneTypeSet/2026-04-06/1775462677/XeroPhoneTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroPhoneTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1456646792805103645,
        "service_name": "drive-thru",
        "span_id": 7776025175713754593,
        "trace_id": 14489352713063372536
    }
}

running: False
schema_name_id: 1791
start_time: 2026-04-06 03:12:36
success: True
trace_id: 14489352713063372536

Scan 161515043

duration: 0:00:11.614084

exit_message:

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

id: 161515043

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_moloXeroPhoneTypeSet/2026-04-05/1775376307",
        "key": "raw/molo_moloXeroPhoneTypeSet/2026-04-05/1775376307/XeroPhoneTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroPhoneTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16403953228854347397,
        "service_name": "drive-thru",
        "span_id": 16315426386339715320,
        "trace_id": 1032944926360280278
    }
}

running: False
schema_name_id: 1791
start_time: 2026-04-05 03:11:03
success: True
trace_id: 1032944926360280278

Scan 161460554

duration: 0:00:11.398960

exit_message:

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

id: 161460554

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_moloXeroPhoneTypeSet/2026-04-04/1775289791",
        "key": "raw/molo_moloXeroPhoneTypeSet/2026-04-04/1775289791/XeroPhoneTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroPhoneTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6777439852852875264,
        "service_name": "drive-thru",
        "span_id": 8463021591419020815,
        "trace_id": 18012915407932395374
    }
}

running: False
schema_name_id: 1791
start_time: 2026-04-04 03:09:53
success: True
trace_id: 18012915407932395374

Scan 161402102

duration: 0:00:14.100448

exit_message:

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

id: 161402102

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_moloXeroPhoneTypeSet/2026-04-03/1775203555",
        "key": "raw/molo_moloXeroPhoneTypeSet/2026-04-03/1775203555/XeroPhoneTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroPhoneTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17595522650386299769,
        "service_name": "drive-thru",
        "span_id": 12064232246748325473,
        "trace_id": 17887349294406017292
    }
}

running: False
schema_name_id: 1791
start_time: 2026-04-03 03:21:09
success: True
trace_id: 17887349294406017292

Partitions:

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

Schema:

attributes:

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

created: 2026-04-17 03:13:49

ddl:

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

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