Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloseasonalchargemethods

created: 2023-10-17 02:01:04
disabled: False
format: raw
id: 1763
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717720

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1763
schema_scan_id: 162167720
updated: 2026-04-17 03:08:27

Version 1716511

created: 2026-04-16 03:12:02

ddl:

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

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

schema_attributes:

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

schema_name_id: 1763
schema_scan_id: 162111956
updated: 2026-04-16 03:12:13

Version 1715262

created: 2026-04-15 03:07:20

ddl:

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

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

schema_attributes:

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

schema_name_id: 1763
schema_scan_id: 162056007
updated: 2026-04-15 03:07:33

Version 1714064

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1763
schema_scan_id: 162000563
updated: 2026-04-14 03:08:12

Version 1712845

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1763
schema_scan_id: 161941915
updated: 2026-04-13 03:00:45

Version 1711628

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1763
schema_scan_id: 161892797
updated: 2026-04-12 03:02:02

Version 1710408

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1763
schema_scan_id: 161841182
updated: 2026-04-11 03:05:04

Version 1709292

created: 2026-04-10 03:07:55

ddl:

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

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

schema_attributes:

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

schema_name_id: 1763
schema_scan_id: 161785986
updated: 2026-04-10 03:08:06

Version 1708155

created: 2026-04-09 03:04:49

ddl:

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

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

schema_attributes:

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

schema_name_id: 1763
schema_scan_id: 161730348
updated: 2026-04-09 03:05:02

Version 1706918

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1763
schema_scan_id: 161675551
updated: 2026-04-08 03:06:28

Version 1705777

created: 2026-04-07 02:59:49

ddl:

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

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

schema_attributes:

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

schema_name_id: 1763
schema_scan_id: 161618683
updated: 2026-04-07 03:00:00

Version 1704595

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1763
schema_scan_id: 161561739
updated: 2026-04-06 03:10:16

Version 1703327

created: 2026-04-05 03:06:22

ddl:

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

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

schema_attributes:

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

schema_name_id: 1763
schema_scan_id: 161514909
updated: 2026-04-05 03:06:33

Version 1702201

created: 2026-04-04 03:07:29

ddl:

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

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

schema_attributes:

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

schema_name_id: 1763
schema_scan_id: 161460477
updated: 2026-04-04 03:07:43

Version 1700870

created: 2026-04-03 03:06:45

ddl:

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

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

schema_attributes:

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

schema_name_id: 1763
schema_scan_id: 161401791
updated: 2026-04-03 03:06:59

Schema Scans: 15

Last at 2026-04-17 03:08:15

Scan 162167720

duration: 0:00:11.466538

exit_message:

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

id: 162167720

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_moloSeasonalChargeMethods/2026-04-17/1776412849",
        "key": "raw/molo_moloSeasonalChargeMethods/2026-04-17/1776412849/SeasonalChargeMethods.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSeasonalChargeMethods",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14570801328536331069,
        "service_name": "drive-thru",
        "span_id": 9249043095390978604,
        "trace_id": 883461153565694534
    }
}

running: False
schema_name_id: 1763
start_time: 2026-04-17 03:08:15
success: True
trace_id: 883461153565694534

Scan 162111956

duration: 0:00:11.491149

exit_message:

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

id: 162111956

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_moloSeasonalChargeMethods/2026-04-16/1776326602",
        "key": "raw/molo_moloSeasonalChargeMethods/2026-04-16/1776326602/SeasonalChargeMethods.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSeasonalChargeMethods",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18123696950892217875,
        "service_name": "drive-thru",
        "span_id": 7428957364665825344,
        "trace_id": 3679971722653752347
    }
}

running: False
schema_name_id: 1763
start_time: 2026-04-16 03:12:01
success: True
trace_id: 3679971722653752347

Scan 162056007

duration: 0:00:14.011991

exit_message:

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

id: 162056007

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_moloSeasonalChargeMethods/2026-04-15/1776240072",
        "key": "raw/molo_moloSeasonalChargeMethods/2026-04-15/1776240072/SeasonalChargeMethods.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSeasonalChargeMethods",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7813980043507572283,
        "service_name": "drive-thru",
        "span_id": 15954525055843296593,
        "trace_id": 3266288899312144402
    }
}

running: False
schema_name_id: 1763
start_time: 2026-04-15 03:07:19
success: True
trace_id: 3266288899312144402

Scan 162000563

duration: 0:00:13.923995

exit_message:

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

id: 162000563

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_moloSeasonalChargeMethods/2026-04-14/1776153837",
        "key": "raw/molo_moloSeasonalChargeMethods/2026-04-14/1776153837/SeasonalChargeMethods.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSeasonalChargeMethods",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4437970914885347446,
        "service_name": "drive-thru",
        "span_id": 14003670715182480089,
        "trace_id": 13028508305130897163
    }
}

running: False
schema_name_id: 1763
start_time: 2026-04-14 03:07:58
success: True
trace_id: 13028508305130897163

Scan 161941915

duration: 0:00:11.527291

exit_message:

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

id: 161941915

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_moloSeasonalChargeMethods/2026-04-13/1776066997",
        "key": "raw/molo_moloSeasonalChargeMethods/2026-04-13/1776066997/SeasonalChargeMethods.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSeasonalChargeMethods",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12220202956992669255,
        "service_name": "drive-thru",
        "span_id": 12103771359260262794,
        "trace_id": 10864370248482260595
    }
}

running: False
schema_name_id: 1763
start_time: 2026-04-13 03:00:33
success: True
trace_id: 10864370248482260595

Scan 161892797

duration: 0:00:14.034107

exit_message:

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

id: 161892797

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_moloSeasonalChargeMethods/2026-04-12/1775980707",
        "key": "raw/molo_moloSeasonalChargeMethods/2026-04-12/1775980707/SeasonalChargeMethods.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSeasonalChargeMethods",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15839550055349733241,
        "service_name": "drive-thru",
        "span_id": 10008953713799896480,
        "trace_id": 14585726130944417308
    }
}

running: False
schema_name_id: 1763
start_time: 2026-04-12 03:01:48
success: True
trace_id: 14585726130944417308

Scan 161841182

duration: 0:00:13.995293

exit_message:

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

id: 161841182

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_moloSeasonalChargeMethods/2026-04-11/1775894474",
        "key": "raw/molo_moloSeasonalChargeMethods/2026-04-11/1775894474/SeasonalChargeMethods.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSeasonalChargeMethods",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7104303672389150580,
        "service_name": "drive-thru",
        "span_id": 5380582678396915151,
        "trace_id": 2377741052654391598
    }
}

running: False
schema_name_id: 1763
start_time: 2026-04-11 03:04:50
success: True
trace_id: 2377741052654391598

Scan 161785986

duration: 0:00:11.559505

exit_message:

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

id: 161785986

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_moloSeasonalChargeMethods/2026-04-10/1775808234",
        "key": "raw/molo_moloSeasonalChargeMethods/2026-04-10/1775808234/SeasonalChargeMethods.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSeasonalChargeMethods",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6546262092184989520,
        "service_name": "drive-thru",
        "span_id": 9509646843497630589,
        "trace_id": 8881588985329350711
    }
}

running: False
schema_name_id: 1763
start_time: 2026-04-10 03:07:54
success: True
trace_id: 8881588985329350711

Scan 161730348

duration: 0:00:14.076581

exit_message:

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

id: 161730348

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_moloSeasonalChargeMethods/2026-04-09/1775721567",
        "key": "raw/molo_moloSeasonalChargeMethods/2026-04-09/1775721567/SeasonalChargeMethods.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSeasonalChargeMethods",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2013990450476806890,
        "service_name": "drive-thru",
        "span_id": 1285178892440179129,
        "trace_id": 14750628101799169831
    }
}

running: False
schema_name_id: 1763
start_time: 2026-04-09 03:04:48
success: True
trace_id: 14750628101799169831

Scan 161675551

duration: 0:00:11.661817

exit_message:

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

id: 161675551

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_moloSeasonalChargeMethods/2026-04-08/1775635393",
        "key": "raw/molo_moloSeasonalChargeMethods/2026-04-08/1775635393/SeasonalChargeMethods.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSeasonalChargeMethods",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1177528509483262595,
        "service_name": "drive-thru",
        "span_id": 3719537320248825398,
        "trace_id": 9152066343591356182
    }
}

running: False
schema_name_id: 1763
start_time: 2026-04-08 03:06:16
success: True
trace_id: 9152066343591356182

Scan 161618683

duration: 0:00:11.588755

exit_message:

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

id: 161618683

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_moloSeasonalChargeMethods/2026-04-07/1775548551",
        "key": "raw/molo_moloSeasonalChargeMethods/2026-04-07/1775548551/SeasonalChargeMethods.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSeasonalChargeMethods",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6631169341530003430,
        "service_name": "drive-thru",
        "span_id": 2770540070899257018,
        "trace_id": 12652556835639592864
    }
}

running: False
schema_name_id: 1763
start_time: 2026-04-07 02:59:48
success: True
trace_id: 12652556835639592864

Scan 161561739

duration: 0:00:14.069617

exit_message:

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

id: 161561739

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_moloSeasonalChargeMethods/2026-04-06/1775462510",
        "key": "raw/molo_moloSeasonalChargeMethods/2026-04-06/1775462510/SeasonalChargeMethods.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSeasonalChargeMethods",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18116383510754316801,
        "service_name": "drive-thru",
        "span_id": 6369144823103993901,
        "trace_id": 2372272463503672969
    }
}

running: False
schema_name_id: 1763
start_time: 2026-04-06 03:10:02
success: True
trace_id: 2372272463503672969

Scan 161514909

duration: 0:00:11.610627

exit_message:

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

id: 161514909

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_moloSeasonalChargeMethods/2026-04-05/1775376137",
        "key": "raw/molo_moloSeasonalChargeMethods/2026-04-05/1775376137/SeasonalChargeMethods.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSeasonalChargeMethods",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1315847727919711500,
        "service_name": "drive-thru",
        "span_id": 4031737112755092777,
        "trace_id": 9438088068935203635
    }
}

running: False
schema_name_id: 1763
start_time: 2026-04-05 03:06:21
success: True
trace_id: 9438088068935203635

Scan 161460477

duration: 0:00:14.055739

exit_message:

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

id: 161460477

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_moloSeasonalChargeMethods/2026-04-04/1775289619",
        "key": "raw/molo_moloSeasonalChargeMethods/2026-04-04/1775289619/SeasonalChargeMethods.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSeasonalChargeMethods",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9908454245724852762,
        "service_name": "drive-thru",
        "span_id": 9066510051224982108,
        "trace_id": 11080547662899739662
    }
}

running: False
schema_name_id: 1763
start_time: 2026-04-04 03:07:29
success: True
trace_id: 11080547662899739662

Scan 161401791

duration: 0:00:13.995321

exit_message:

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

id: 161401791

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_moloSeasonalChargeMethods/2026-04-03/1775203392",
        "key": "raw/molo_moloSeasonalChargeMethods/2026-04-03/1775203392/SeasonalChargeMethods.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSeasonalChargeMethods",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1445782749806610122,
        "service_name": "drive-thru",
        "span_id": 14584307589169689543,
        "trace_id": 1571532299335968422
    }
}

running: False
schema_name_id: 1763
start_time: 2026-04-03 03:06:45
success: True
trace_id: 1571532299335968422

Partitions:

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

Schema:

attributes:

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

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

ddl:

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

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