Schema Info

Schema Name: sfdl_prod_drivethru.molo_molotransactionmethodset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717781

created: 2026-04-17 03:10:58

ddl:

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

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

schema_attributes:

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

schema_name_id: 1786
schema_scan_id: 162167808
updated: 2026-04-17 03:11:09

Version 1716507

created: 2026-04-16 03:11:50

ddl:

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

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

schema_attributes:

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

schema_name_id: 1786
schema_scan_id: 162111951
updated: 2026-04-16 03:12:02

Version 1715345

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1786
schema_scan_id: 162056138
updated: 2026-04-15 03:11:38

Version 1714190

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1786
schema_scan_id: 162000714
updated: 2026-04-14 03:12:57

Version 1712889

created: 2026-04-13 03:03:20

ddl:

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

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

schema_attributes:

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

schema_name_id: 1786
schema_scan_id: 161942566
updated: 2026-04-13 03:03:34

Version 1711731

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1786
schema_scan_id: 161893419
updated: 2026-04-12 03:07:22

Version 1710579

created: 2026-04-11 03:11:53

ddl:

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

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

schema_attributes:

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

schema_name_id: 1786
schema_scan_id: 161841389
updated: 2026-04-11 03:12:04

Version 1709404

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1786
schema_scan_id: 161786108
updated: 2026-04-10 03:12:28

Version 1708262

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1786
schema_scan_id: 161730545
updated: 2026-04-09 03:09:51

Version 1707072

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1786
schema_scan_id: 161675744
updated: 2026-04-08 03:12:59

Version 1705839

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1786
schema_scan_id: 161619318
updated: 2026-04-07 03:03:11

Version 1704645

created: 2026-04-06 03:11:51

ddl:

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

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

schema_attributes:

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

schema_name_id: 1786
schema_scan_id: 161561794
updated: 2026-04-06 03:12:05

Version 1703446

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1786
schema_scan_id: 161515036
updated: 2026-04-05 03:10:58

Version 1702235

created: 2026-04-04 03:09:05

ddl:

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

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

schema_attributes:

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

schema_name_id: 1786
schema_scan_id: 161460524
updated: 2026-04-04 03:09:19

Version 1700924

created: 2026-04-03 03:09:13

ddl:

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

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

schema_attributes:

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

schema_name_id: 1786
schema_scan_id: 161401878
updated: 2026-04-03 03:09:27

Schema Scans: 15

Last at 2026-04-17 03:10:57

Scan 162167808

duration: 0:00:11.509211

exit_message:

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

id: 162167808

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_moloTransactionMethodSet/2026-04-17/1776413134",
        "key": "raw/molo_moloTransactionMethodSet/2026-04-17/1776413134/TransactionMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransactionMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4831614383539574141,
        "service_name": "drive-thru",
        "span_id": 11990315793864125485,
        "trace_id": 1456634510194331722
    }
}

running: False
schema_name_id: 1786
start_time: 2026-04-17 03:10:57
success: True
trace_id: 1456634510194331722

Scan 162111951

duration: 0:00:11.470495

exit_message:

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

id: 162111951

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_moloTransactionMethodSet/2026-04-16/1776326734",
        "key": "raw/molo_moloTransactionMethodSet/2026-04-16/1776326734/TransactionMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransactionMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12630368092376014580,
        "service_name": "drive-thru",
        "span_id": 12211868871265640832,
        "trace_id": 1170962063798426709
    }
}

running: False
schema_name_id: 1786
start_time: 2026-04-16 03:11:50
success: True
trace_id: 1170962063798426709

Scan 162056138

duration: 0:00:14.030520

exit_message:

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

id: 162056138

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_moloTransactionMethodSet/2026-04-15/1776240200",
        "key": "raw/molo_moloTransactionMethodSet/2026-04-15/1776240200/TransactionMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransactionMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1722503526403394256,
        "service_name": "drive-thru",
        "span_id": 10668248084834054069,
        "trace_id": 15457022849308591918
    }
}

running: False
schema_name_id: 1786
start_time: 2026-04-15 03:11:24
success: True
trace_id: 15457022849308591918

Scan 162000714

duration: 0:00:14.059626

exit_message:

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

id: 162000714

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_moloTransactionMethodSet/2026-04-14/1776154167",
        "key": "raw/molo_moloTransactionMethodSet/2026-04-14/1776154167/TransactionMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransactionMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17563982720846840178,
        "service_name": "drive-thru",
        "span_id": 4461510887705166421,
        "trace_id": 14484566965167343285
    }
}

running: False
schema_name_id: 1786
start_time: 2026-04-14 03:12:43
success: True
trace_id: 14484566965167343285

Scan 161942566

duration: 0:00:13.975005

exit_message:

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

id: 161942566

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_moloTransactionMethodSet/2026-04-13/1776067161",
        "key": "raw/molo_moloTransactionMethodSet/2026-04-13/1776067161/TransactionMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransactionMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10378748680525428356,
        "service_name": "drive-thru",
        "span_id": 8373844042568842811,
        "trace_id": 2842465048084529218
    }
}

running: False
schema_name_id: 1786
start_time: 2026-04-13 03:03:20
success: True
trace_id: 2842465048084529218

Scan 161893419

duration: 0:00:14.030550

exit_message:

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

id: 161893419

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_moloTransactionMethodSet/2026-04-12/1775980862",
        "key": "raw/molo_moloTransactionMethodSet/2026-04-12/1775980862/TransactionMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransactionMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13734882557651603251,
        "service_name": "drive-thru",
        "span_id": 15819618858339298245,
        "trace_id": 14879724386491540719
    }
}

running: False
schema_name_id: 1786
start_time: 2026-04-12 03:07:08
success: True
trace_id: 14879724386491540719

Scan 161841389

duration: 0:00:11.589633

exit_message:

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

id: 161841389

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_moloTransactionMethodSet/2026-04-11/1775894630",
        "key": "raw/molo_moloTransactionMethodSet/2026-04-11/1775894630/TransactionMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransactionMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6852449385735413141,
        "service_name": "drive-thru",
        "span_id": 6729664573375234086,
        "trace_id": 5071558520421104643
    }
}

running: False
schema_name_id: 1786
start_time: 2026-04-11 03:11:52
success: True
trace_id: 5071558520421104643

Scan 161786108

duration: 0:00:14.275555

exit_message:

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

id: 161786108

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_moloTransactionMethodSet/2026-04-10/1775808391",
        "key": "raw/molo_moloTransactionMethodSet/2026-04-10/1775808391/TransactionMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransactionMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7677599398416265642,
        "service_name": "drive-thru",
        "span_id": 17617958603685445428,
        "trace_id": 14223575750525422277
    }
}

running: False
schema_name_id: 1786
start_time: 2026-04-10 03:12:14
success: True
trace_id: 14223575750525422277

Scan 161730545

duration: 0:00:11.493356

exit_message:

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

id: 161730545

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_moloTransactionMethodSet/2026-04-09/1775721720",
        "key": "raw/molo_moloTransactionMethodSet/2026-04-09/1775721720/TransactionMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransactionMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2703645808086101402,
        "service_name": "drive-thru",
        "span_id": 1002697871657900822,
        "trace_id": 14906678096591160573
    }
}

running: False
schema_name_id: 1786
start_time: 2026-04-09 03:09:40
success: True
trace_id: 14906678096591160573

Scan 161675744

duration: 0:00:11.406072

exit_message:

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

id: 161675744

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_moloTransactionMethodSet/2026-04-08/1775635551",
        "key": "raw/molo_moloTransactionMethodSet/2026-04-08/1775635551/TransactionMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransactionMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4680391906158200375,
        "service_name": "drive-thru",
        "span_id": 3247532608740338727,
        "trace_id": 4347913429283955445
    }
}

running: False
schema_name_id: 1786
start_time: 2026-04-08 03:12:47
success: True
trace_id: 4347913429283955445

Scan 161619318

duration: 0:00:13.982002

exit_message:

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

id: 161619318

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_moloTransactionMethodSet/2026-04-07/1775548713",
        "key": "raw/molo_moloTransactionMethodSet/2026-04-07/1775548713/TransactionMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransactionMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4384200687427911908,
        "service_name": "drive-thru",
        "span_id": 5785385063135702768,
        "trace_id": 17167497410776196892
    }
}

running: False
schema_name_id: 1786
start_time: 2026-04-07 03:02:57
success: True
trace_id: 17167497410776196892

Scan 161561794

duration: 0:00:14.010537

exit_message:

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

id: 161561794

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_moloTransactionMethodSet/2026-04-06/1775462663",
        "key": "raw/molo_moloTransactionMethodSet/2026-04-06/1775462663/TransactionMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransactionMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8188615874509899238,
        "service_name": "drive-thru",
        "span_id": 1174111280612120544,
        "trace_id": 12602256970721194100
    }
}

running: False
schema_name_id: 1786
start_time: 2026-04-06 03:11:51
success: True
trace_id: 12602256970721194100

Scan 161515036

duration: 0:00:11.452730

exit_message:

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

id: 161515036

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_moloTransactionMethodSet/2026-04-05/1775376294",
        "key": "raw/molo_moloTransactionMethodSet/2026-04-05/1775376294/TransactionMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransactionMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16121616493725019761,
        "service_name": "drive-thru",
        "span_id": 14464957445274524727,
        "trace_id": 7791127355899227281
    }
}

running: False
schema_name_id: 1786
start_time: 2026-04-05 03:10:47
success: True
trace_id: 7791127355899227281

Scan 161460524

duration: 0:00:14.279589

exit_message:

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

id: 161460524

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_moloTransactionMethodSet/2026-04-04/1775289776",
        "key": "raw/molo_moloTransactionMethodSet/2026-04-04/1775289776/TransactionMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransactionMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1480646504735516304,
        "service_name": "drive-thru",
        "span_id": 5770371235541664075,
        "trace_id": 14121122576706573196
    }
}

running: False
schema_name_id: 1786
start_time: 2026-04-04 03:09:05
success: True
trace_id: 14121122576706573196

Scan 161401878

duration: 0:00:14.009035

exit_message:

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

id: 161401878

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_moloTransactionMethodSet/2026-04-03/1775203542",
        "key": "raw/molo_moloTransactionMethodSet/2026-04-03/1775203542/TransactionMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransactionMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15994282740234019641,
        "service_name": "drive-thru",
        "span_id": 13134730636549310506,
        "trace_id": 2224564168422866153
    }
}

running: False
schema_name_id: 1786
start_time: 2026-04-03 03:09:13
success: True
trace_id: 2224564168422866153

Partitions:

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

Schema:

attributes:

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

created: 2026-04-17 03:10:58

ddl:

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

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