Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloonlinepaymentfeeset

created: 2023-10-17 01:59:52
disabled: False
format: raw
id: 1728
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717632

created: 2026-04-17 03:04:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`\n(\n `Id`  string , `FromAmount`  string , `ToAmount`  string , `PercentFee`  string , `CreationDateTime`  string , `LastEditDateTime`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `LastEditUser_Id`  string , `DeletionUser_Id`  string , `MarinaLocation_Id`  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_moloOnlinePaymentFeeSet/2026-04-17/1776412809'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloonlinepaymentfeeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOnlinePaymentFeeSet/2026-04-17/1776412809
id: 1717632
processed: 1

raw_data:

{
    "CreationDateTime": 4,
    "CreationUser_Id": 8,
    "DeletionDateTime": 6,
    "DeletionUser_Id": 10,
    "FromAmount": 1,
    "Id": 0,
    "LastEditDateTime": 5,
    "LastEditUser_Id": 9,
    "MarinaLocation_Id": 11,
    "PercentFee": 3,
    "RecordStatus_Id": 7,
    "ToAmount": 2
}

schema_attributes:

{
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "FromAmount": "string",
    "Id": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "PercentFee": "string",
    "RecordStatus_Id": "string",
    "ToAmount": "string"
}

schema_name_id: 1728
schema_scan_id: 162167553
updated: 2026-04-17 03:04:28

Version 1716463

created: 2026-04-16 03:10:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`\n(\n `Id`  string , `FromAmount`  string , `ToAmount`  string , `PercentFee`  string , `CreationDateTime`  string , `LastEditDateTime`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `LastEditUser_Id`  string , `DeletionUser_Id`  string , `MarinaLocation_Id`  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_moloOnlinePaymentFeeSet/2026-04-16/1776326562'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloonlinepaymentfeeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOnlinePaymentFeeSet/2026-04-16/1776326562
id: 1716463
processed: 1

raw_data:

{
    "CreationDateTime": 4,
    "CreationUser_Id": 8,
    "DeletionDateTime": 6,
    "DeletionUser_Id": 10,
    "FromAmount": 1,
    "Id": 0,
    "LastEditDateTime": 5,
    "LastEditUser_Id": 9,
    "MarinaLocation_Id": 11,
    "PercentFee": 3,
    "RecordStatus_Id": 7,
    "ToAmount": 2
}

schema_attributes:

{
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "FromAmount": "string",
    "Id": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "PercentFee": "string",
    "RecordStatus_Id": "string",
    "ToAmount": "string"
}

schema_name_id: 1728
schema_scan_id: 162111900
updated: 2026-04-16 03:10:24

Version 1715202

created: 2026-04-15 03:04:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`\n(\n `Id`  string , `FromAmount`  string , `ToAmount`  string , `PercentFee`  string , `CreationDateTime`  string , `LastEditDateTime`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `LastEditUser_Id`  string , `DeletionUser_Id`  string , `MarinaLocation_Id`  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_moloOnlinePaymentFeeSet/2026-04-15/1776240032'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloonlinepaymentfeeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOnlinePaymentFeeSet/2026-04-15/1776240032
id: 1715202
processed: 1

raw_data:

{
    "CreationDateTime": 4,
    "CreationUser_Id": 8,
    "DeletionDateTime": 6,
    "DeletionUser_Id": 10,
    "FromAmount": 1,
    "Id": 0,
    "LastEditDateTime": 5,
    "LastEditUser_Id": 9,
    "MarinaLocation_Id": 11,
    "PercentFee": 3,
    "RecordStatus_Id": 7,
    "ToAmount": 2
}

schema_attributes:

{
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "FromAmount": "string",
    "Id": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "PercentFee": "string",
    "RecordStatus_Id": "string",
    "ToAmount": "string"
}

schema_name_id: 1728
schema_scan_id: 162055911
updated: 2026-04-15 03:04:58

Version 1714069

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`\n(\n `Id`  string , `FromAmount`  string , `ToAmount`  string , `PercentFee`  string , `CreationDateTime`  string , `LastEditDateTime`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `LastEditUser_Id`  string , `DeletionUser_Id`  string , `MarinaLocation_Id`  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_moloOnlinePaymentFeeSet/2026-04-14/1776153761'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloonlinepaymentfeeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOnlinePaymentFeeSet/2026-04-14/1776153761
id: 1714069
processed: 1

raw_data:

{
    "CreationDateTime": 4,
    "CreationUser_Id": 8,
    "DeletionDateTime": 6,
    "DeletionUser_Id": 10,
    "FromAmount": 1,
    "Id": 0,
    "LastEditDateTime": 5,
    "LastEditUser_Id": 9,
    "MarinaLocation_Id": 11,
    "PercentFee": 3,
    "RecordStatus_Id": 7,
    "ToAmount": 2
}

schema_attributes:

{
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "FromAmount": "string",
    "Id": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "PercentFee": "string",
    "RecordStatus_Id": "string",
    "ToAmount": "string"
}

schema_name_id: 1728
schema_scan_id: 162000568
updated: 2026-04-14 03:08:20

Version 1712778

created: 2026-04-13 02:58:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`\n(\n `Id`  string , `FromAmount`  string , `ToAmount`  string , `PercentFee`  string , `CreationDateTime`  string , `LastEditDateTime`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `LastEditUser_Id`  string , `DeletionUser_Id`  string , `MarinaLocation_Id`  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_moloOnlinePaymentFeeSet/2026-04-13/1776066955'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloonlinepaymentfeeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOnlinePaymentFeeSet/2026-04-13/1776066955
id: 1712778
processed: 1

raw_data:

{
    "CreationDateTime": 4,
    "CreationUser_Id": 8,
    "DeletionDateTime": 6,
    "DeletionUser_Id": 10,
    "FromAmount": 1,
    "Id": 0,
    "LastEditDateTime": 5,
    "LastEditUser_Id": 9,
    "MarinaLocation_Id": 11,
    "PercentFee": 3,
    "RecordStatus_Id": 7,
    "ToAmount": 2
}

schema_attributes:

{
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "FromAmount": "string",
    "Id": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "PercentFee": "string",
    "RecordStatus_Id": "string",
    "ToAmount": "string"
}

schema_name_id: 1728
schema_scan_id: 161941689
updated: 2026-04-13 02:58:48

Version 1711602

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`\n(\n `Id`  string , `FromAmount`  string , `ToAmount`  string , `PercentFee`  string , `CreationDateTime`  string , `LastEditDateTime`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `LastEditUser_Id`  string , `DeletionUser_Id`  string , `MarinaLocation_Id`  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_moloOnlinePaymentFeeSet/2026-04-12/1775980668'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloonlinepaymentfeeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOnlinePaymentFeeSet/2026-04-12/1775980668
id: 1711602
processed: 1

raw_data:

{
    "CreationDateTime": 4,
    "CreationUser_Id": 8,
    "DeletionDateTime": 6,
    "DeletionUser_Id": 10,
    "FromAmount": 1,
    "Id": 0,
    "LastEditDateTime": 5,
    "LastEditUser_Id": 9,
    "MarinaLocation_Id": 11,
    "PercentFee": 3,
    "RecordStatus_Id": 7,
    "ToAmount": 2
}

schema_attributes:

{
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "FromAmount": "string",
    "Id": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "PercentFee": "string",
    "RecordStatus_Id": "string",
    "ToAmount": "string"
}

schema_name_id: 1728
schema_scan_id: 161892704
updated: 2026-04-12 03:01:17

Version 1710342

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`\n(\n `Id`  string , `FromAmount`  string , `ToAmount`  string , `PercentFee`  string , `CreationDateTime`  string , `LastEditDateTime`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `LastEditUser_Id`  string , `DeletionUser_Id`  string , `MarinaLocation_Id`  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_moloOnlinePaymentFeeSet/2026-04-11/1775894429'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloonlinepaymentfeeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOnlinePaymentFeeSet/2026-04-11/1775894429
id: 1710342
processed: 1

raw_data:

{
    "CreationDateTime": 4,
    "CreationUser_Id": 8,
    "DeletionDateTime": 6,
    "DeletionUser_Id": 10,
    "FromAmount": 1,
    "Id": 0,
    "LastEditDateTime": 5,
    "LastEditUser_Id": 9,
    "MarinaLocation_Id": 11,
    "PercentFee": 3,
    "RecordStatus_Id": 7,
    "ToAmount": 2
}

schema_attributes:

{
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "FromAmount": "string",
    "Id": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "PercentFee": "string",
    "RecordStatus_Id": "string",
    "ToAmount": "string"
}

schema_name_id: 1728
schema_scan_id: 161841030
updated: 2026-04-11 03:02:05

Version 1709205

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`\n(\n `Id`  string , `FromAmount`  string , `ToAmount`  string , `PercentFee`  string , `CreationDateTime`  string , `LastEditDateTime`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `LastEditUser_Id`  string , `DeletionUser_Id`  string , `MarinaLocation_Id`  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_moloOnlinePaymentFeeSet/2026-04-10/1775808186'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloonlinepaymentfeeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOnlinePaymentFeeSet/2026-04-10/1775808186
id: 1709205
processed: 1

raw_data:

{
    "CreationDateTime": 4,
    "CreationUser_Id": 8,
    "DeletionDateTime": 6,
    "DeletionUser_Id": 10,
    "FromAmount": 1,
    "Id": 0,
    "LastEditDateTime": 5,
    "LastEditUser_Id": 9,
    "MarinaLocation_Id": 11,
    "PercentFee": 3,
    "RecordStatus_Id": 7,
    "ToAmount": 2
}

schema_attributes:

{
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "FromAmount": "string",
    "Id": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "PercentFee": "string",
    "RecordStatus_Id": "string",
    "ToAmount": "string"
}

schema_name_id: 1728
schema_scan_id: 161785887
updated: 2026-04-10 03:04:52

Version 1708091

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`\n(\n `Id`  string , `FromAmount`  string , `ToAmount`  string , `PercentFee`  string , `CreationDateTime`  string , `LastEditDateTime`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `LastEditUser_Id`  string , `DeletionUser_Id`  string , `MarinaLocation_Id`  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_moloOnlinePaymentFeeSet/2026-04-09/1775721526'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloonlinepaymentfeeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOnlinePaymentFeeSet/2026-04-09/1775721526
id: 1708091
processed: 1

raw_data:

{
    "CreationDateTime": 4,
    "CreationUser_Id": 8,
    "DeletionDateTime": 6,
    "DeletionUser_Id": 10,
    "FromAmount": 1,
    "Id": 0,
    "LastEditDateTime": 5,
    "LastEditUser_Id": 9,
    "MarinaLocation_Id": 11,
    "PercentFee": 3,
    "RecordStatus_Id": 7,
    "ToAmount": 2
}

schema_attributes:

{
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "FromAmount": "string",
    "Id": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "PercentFee": "string",
    "RecordStatus_Id": "string",
    "ToAmount": "string"
}

schema_name_id: 1728
schema_scan_id: 161730136
updated: 2026-04-09 03:02:19

Version 1706855

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`\n(\n `Id`  string , `FromAmount`  string , `ToAmount`  string , `PercentFee`  string , `CreationDateTime`  string , `LastEditDateTime`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `LastEditUser_Id`  string , `DeletionUser_Id`  string , `MarinaLocation_Id`  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_moloOnlinePaymentFeeSet/2026-04-08/1775635354'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloonlinepaymentfeeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOnlinePaymentFeeSet/2026-04-08/1775635354
id: 1706855
processed: 1

raw_data:

{
    "CreationDateTime": 4,
    "CreationUser_Id": 8,
    "DeletionDateTime": 6,
    "DeletionUser_Id": 10,
    "FromAmount": 1,
    "Id": 0,
    "LastEditDateTime": 5,
    "LastEditUser_Id": 9,
    "MarinaLocation_Id": 11,
    "PercentFee": 3,
    "RecordStatus_Id": 7,
    "ToAmount": 2
}

schema_attributes:

{
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "FromAmount": "string",
    "Id": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "PercentFee": "string",
    "RecordStatus_Id": "string",
    "ToAmount": "string"
}

schema_name_id: 1728
schema_scan_id: 161675431
updated: 2026-04-08 03:03:39

Version 1705723

created: 2026-04-07 02:57:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`\n(\n `Id`  string , `FromAmount`  string , `ToAmount`  string , `PercentFee`  string , `CreationDateTime`  string , `LastEditDateTime`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `LastEditUser_Id`  string , `DeletionUser_Id`  string , `MarinaLocation_Id`  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_moloOnlinePaymentFeeSet/2026-04-07/1775548502'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloonlinepaymentfeeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOnlinePaymentFeeSet/2026-04-07/1775548502
id: 1705723
processed: 1

raw_data:

{
    "CreationDateTime": 4,
    "CreationUser_Id": 8,
    "DeletionDateTime": 6,
    "DeletionUser_Id": 10,
    "FromAmount": 1,
    "Id": 0,
    "LastEditDateTime": 5,
    "LastEditUser_Id": 9,
    "MarinaLocation_Id": 11,
    "PercentFee": 3,
    "RecordStatus_Id": 7,
    "ToAmount": 2
}

schema_attributes:

{
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "FromAmount": "string",
    "Id": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "PercentFee": "string",
    "RecordStatus_Id": "string",
    "ToAmount": "string"
}

schema_name_id: 1728
schema_scan_id: 161618436
updated: 2026-04-07 02:58:04

Version 1704584

created: 2026-04-06 03:09:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`\n(\n `Id`  string , `FromAmount`  string , `ToAmount`  string , `PercentFee`  string , `CreationDateTime`  string , `LastEditDateTime`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `LastEditUser_Id`  string , `DeletionUser_Id`  string , `MarinaLocation_Id`  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_moloOnlinePaymentFeeSet/2026-04-06/1775462469'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloonlinepaymentfeeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOnlinePaymentFeeSet/2026-04-06/1775462469
id: 1704584
processed: 1

raw_data:

{
    "CreationDateTime": 4,
    "CreationUser_Id": 8,
    "DeletionDateTime": 6,
    "DeletionUser_Id": 10,
    "FromAmount": 1,
    "Id": 0,
    "LastEditDateTime": 5,
    "LastEditUser_Id": 9,
    "MarinaLocation_Id": 11,
    "PercentFee": 3,
    "RecordStatus_Id": 7,
    "ToAmount": 2
}

schema_attributes:

{
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "FromAmount": "string",
    "Id": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "PercentFee": "string",
    "RecordStatus_Id": "string",
    "ToAmount": "string"
}

schema_name_id: 1728
schema_scan_id: 161561722
updated: 2026-04-06 03:09:48

Version 1703332

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`\n(\n `Id`  string , `FromAmount`  string , `ToAmount`  string , `PercentFee`  string , `CreationDateTime`  string , `LastEditDateTime`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `LastEditUser_Id`  string , `DeletionUser_Id`  string , `MarinaLocation_Id`  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_moloOnlinePaymentFeeSet/2026-04-05/1775376096'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloonlinepaymentfeeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOnlinePaymentFeeSet/2026-04-05/1775376096
id: 1703332
processed: 1

raw_data:

{
    "CreationDateTime": 4,
    "CreationUser_Id": 8,
    "DeletionDateTime": 6,
    "DeletionUser_Id": 10,
    "FromAmount": 1,
    "Id": 0,
    "LastEditDateTime": 5,
    "LastEditUser_Id": 9,
    "MarinaLocation_Id": 11,
    "PercentFee": 3,
    "RecordStatus_Id": 7,
    "ToAmount": 2
}

schema_attributes:

{
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "FromAmount": "string",
    "Id": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "PercentFee": "string",
    "RecordStatus_Id": "string",
    "ToAmount": "string"
}

schema_name_id: 1728
schema_scan_id: 161514913
updated: 2026-04-05 03:06:40

Version 1702151

created: 2026-04-04 03:04:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`\n(\n `Id`  string , `FromAmount`  string , `ToAmount`  string , `PercentFee`  string , `CreationDateTime`  string , `LastEditDateTime`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `LastEditUser_Id`  string , `DeletionUser_Id`  string , `MarinaLocation_Id`  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_moloOnlinePaymentFeeSet/2026-04-04/1775289579'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloonlinepaymentfeeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOnlinePaymentFeeSet/2026-04-04/1775289579
id: 1702151
processed: 1

raw_data:

{
    "CreationDateTime": 4,
    "CreationUser_Id": 8,
    "DeletionDateTime": 6,
    "DeletionUser_Id": 10,
    "FromAmount": 1,
    "Id": 0,
    "LastEditDateTime": 5,
    "LastEditUser_Id": 9,
    "MarinaLocation_Id": 11,
    "PercentFee": 3,
    "RecordStatus_Id": 7,
    "ToAmount": 2
}

schema_attributes:

{
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "FromAmount": "string",
    "Id": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "PercentFee": "string",
    "RecordStatus_Id": "string",
    "ToAmount": "string"
}

schema_name_id: 1728
schema_scan_id: 161460343
updated: 2026-04-04 03:05:09

Version 1700976

created: 2026-04-03 03:11:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`\n(\n `Id`  string , `FromAmount`  string , `ToAmount`  string , `PercentFee`  string , `CreationDateTime`  string , `LastEditDateTime`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `LastEditUser_Id`  string , `DeletionUser_Id`  string , `MarinaLocation_Id`  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_moloOnlinePaymentFeeSet/2026-04-03/1775203352'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloonlinepaymentfeeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOnlinePaymentFeeSet/2026-04-03/1775203352
id: 1700976
processed: 1

raw_data:

{
    "CreationDateTime": 4,
    "CreationUser_Id": 8,
    "DeletionDateTime": 6,
    "DeletionUser_Id": 10,
    "FromAmount": 1,
    "Id": 0,
    "LastEditDateTime": 5,
    "LastEditUser_Id": 9,
    "MarinaLocation_Id": 11,
    "PercentFee": 3,
    "RecordStatus_Id": 7,
    "ToAmount": 2
}

schema_attributes:

{
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "FromAmount": "string",
    "Id": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "PercentFee": "string",
    "RecordStatus_Id": "string",
    "ToAmount": "string"
}

schema_name_id: 1728
schema_scan_id: 161401946
updated: 2026-04-03 03:11:21

Schema Scans: 15

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

Scan 162167553

duration: 0:00:14.377384

exit_message:

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

id: 162167553

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_moloOnlinePaymentFeeSet/2026-04-17/1776412809",
        "key": "raw/molo_moloOnlinePaymentFeeSet/2026-04-17/1776412809/OnlinePaymentFeeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOnlinePaymentFeeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3052806416416429575,
        "service_name": "drive-thru",
        "span_id": 11992963996805154524,
        "trace_id": 15779153564308079835
    }
}

running: False
schema_name_id: 1728
start_time: 2026-04-17 03:04:13
success: True
trace_id: 15779153564308079835

Scan 162111900

duration: 0:00:14.461821

exit_message:

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

id: 162111900

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_moloOnlinePaymentFeeSet/2026-04-16/1776326562",
        "key": "raw/molo_moloOnlinePaymentFeeSet/2026-04-16/1776326562/OnlinePaymentFeeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOnlinePaymentFeeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9135654702096637033,
        "service_name": "drive-thru",
        "span_id": 5118593836707070185,
        "trace_id": 7271225510531569263
    }
}

running: False
schema_name_id: 1728
start_time: 2026-04-16 03:10:10
success: True
trace_id: 7271225510531569263

Scan 162055911

duration: 0:00:11.787402

exit_message:

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

id: 162055911

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_moloOnlinePaymentFeeSet/2026-04-15/1776240032",
        "key": "raw/molo_moloOnlinePaymentFeeSet/2026-04-15/1776240032/OnlinePaymentFeeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOnlinePaymentFeeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17598393523678695291,
        "service_name": "drive-thru",
        "span_id": 11177784290610821346,
        "trace_id": 3990361700401038236
    }
}

running: False
schema_name_id: 1728
start_time: 2026-04-15 03:04:46
success: True
trace_id: 3990361700401038236

Scan 162000568

duration: 0:00:11.838525

exit_message:

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

id: 162000568

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_moloOnlinePaymentFeeSet/2026-04-14/1776153761",
        "key": "raw/molo_moloOnlinePaymentFeeSet/2026-04-14/1776153761/OnlinePaymentFeeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOnlinePaymentFeeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1544092554919688474,
        "service_name": "drive-thru",
        "span_id": 15747524848875269969,
        "trace_id": 7696358784796897100
    }
}

running: False
schema_name_id: 1728
start_time: 2026-04-14 03:08:08
success: True
trace_id: 7696358784796897100

Scan 161941689

duration: 0:00:14.364729

exit_message:

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

id: 161941689

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_moloOnlinePaymentFeeSet/2026-04-13/1776066955",
        "key": "raw/molo_moloOnlinePaymentFeeSet/2026-04-13/1776066955/OnlinePaymentFeeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOnlinePaymentFeeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14751472631374928859,
        "service_name": "drive-thru",
        "span_id": 12155513818199119113,
        "trace_id": 5759018982192936867
    }
}

running: False
schema_name_id: 1728
start_time: 2026-04-13 02:58:34
success: True
trace_id: 5759018982192936867

Scan 161892704

duration: 0:00:11.900811

exit_message:

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

id: 161892704

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_moloOnlinePaymentFeeSet/2026-04-12/1775980668",
        "key": "raw/molo_moloOnlinePaymentFeeSet/2026-04-12/1775980668/OnlinePaymentFeeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOnlinePaymentFeeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16926593875272913949,
        "service_name": "drive-thru",
        "span_id": 7472051550543528682,
        "trace_id": 13110559833174883798
    }
}

running: False
schema_name_id: 1728
start_time: 2026-04-12 03:01:05
success: True
trace_id: 13110559833174883798

Scan 161841030

duration: 0:00:11.739953

exit_message:

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

id: 161841030

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_moloOnlinePaymentFeeSet/2026-04-11/1775894429",
        "key": "raw/molo_moloOnlinePaymentFeeSet/2026-04-11/1775894429/OnlinePaymentFeeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOnlinePaymentFeeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16122985455498912160,
        "service_name": "drive-thru",
        "span_id": 12278347641261520886,
        "trace_id": 7885900346923189795
    }
}

running: False
schema_name_id: 1728
start_time: 2026-04-11 03:01:54
success: True
trace_id: 7885900346923189795

Scan 161785887

duration: 0:00:14.369113

exit_message:

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

id: 161785887

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_moloOnlinePaymentFeeSet/2026-04-10/1775808186",
        "key": "raw/molo_moloOnlinePaymentFeeSet/2026-04-10/1775808186/OnlinePaymentFeeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOnlinePaymentFeeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3116240468017647599,
        "service_name": "drive-thru",
        "span_id": 1032578260406535999,
        "trace_id": 15491541658848973307
    }
}

running: False
schema_name_id: 1728
start_time: 2026-04-10 03:04:38
success: True
trace_id: 15491541658848973307

Scan 161730136

duration: 0:00:14.358610

exit_message:

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

id: 161730136

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_moloOnlinePaymentFeeSet/2026-04-09/1775721526",
        "key": "raw/molo_moloOnlinePaymentFeeSet/2026-04-09/1775721526/OnlinePaymentFeeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOnlinePaymentFeeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9687175210529785429,
        "service_name": "drive-thru",
        "span_id": 2928120946620498941,
        "trace_id": 3840781053930214957
    }
}

running: False
schema_name_id: 1728
start_time: 2026-04-09 03:02:05
success: True
trace_id: 3840781053930214957

Scan 161675431

duration: 0:00:11.720440

exit_message:

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

id: 161675431

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_moloOnlinePaymentFeeSet/2026-04-08/1775635354",
        "key": "raw/molo_moloOnlinePaymentFeeSet/2026-04-08/1775635354/OnlinePaymentFeeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOnlinePaymentFeeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10794969300383797968,
        "service_name": "drive-thru",
        "span_id": 9420631934208860829,
        "trace_id": 2732047345717471026
    }
}

running: False
schema_name_id: 1728
start_time: 2026-04-08 03:03:27
success: True
trace_id: 2732047345717471026

Scan 161618436

duration: 0:00:11.850262

exit_message:

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

id: 161618436

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_moloOnlinePaymentFeeSet/2026-04-07/1775548502",
        "key": "raw/molo_moloOnlinePaymentFeeSet/2026-04-07/1775548502/OnlinePaymentFeeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOnlinePaymentFeeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5994966811739004382,
        "service_name": "drive-thru",
        "span_id": 2144963597802536713,
        "trace_id": 1451240452081803394
    }
}

running: False
schema_name_id: 1728
start_time: 2026-04-07 02:57:53
success: True
trace_id: 1451240452081803394

Scan 161561722

duration: 0:00:14.376441

exit_message:

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

id: 161561722

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_moloOnlinePaymentFeeSet/2026-04-06/1775462469",
        "key": "raw/molo_moloOnlinePaymentFeeSet/2026-04-06/1775462469/OnlinePaymentFeeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOnlinePaymentFeeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9943789502482645038,
        "service_name": "drive-thru",
        "span_id": 7982880707753044234,
        "trace_id": 18040487856844473377
    }
}

running: False
schema_name_id: 1728
start_time: 2026-04-06 03:09:34
success: True
trace_id: 18040487856844473377

Scan 161514913

duration: 0:00:11.764815

exit_message:

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

id: 161514913

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_moloOnlinePaymentFeeSet/2026-04-05/1775376096",
        "key": "raw/molo_moloOnlinePaymentFeeSet/2026-04-05/1775376096/OnlinePaymentFeeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOnlinePaymentFeeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7063143986289822583,
        "service_name": "drive-thru",
        "span_id": 9361913310862161085,
        "trace_id": 7265197171805143717
    }
}

running: False
schema_name_id: 1728
start_time: 2026-04-05 03:06:28
success: True
trace_id: 7265197171805143717

Scan 161460343

duration: 0:00:11.765850

exit_message:

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

id: 161460343

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_moloOnlinePaymentFeeSet/2026-04-04/1775289579",
        "key": "raw/molo_moloOnlinePaymentFeeSet/2026-04-04/1775289579/OnlinePaymentFeeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOnlinePaymentFeeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13735256777327810158,
        "service_name": "drive-thru",
        "span_id": 11951501578305912373,
        "trace_id": 16386440761295672478
    }
}

running: False
schema_name_id: 1728
start_time: 2026-04-04 03:04:57
success: True
trace_id: 16386440761295672478

Scan 161401946

duration: 0:00:11.901168

exit_message:

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

id: 161401946

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_moloOnlinePaymentFeeSet/2026-04-03/1775203352",
        "key": "raw/molo_moloOnlinePaymentFeeSet/2026-04-03/1775203352/OnlinePaymentFeeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOnlinePaymentFeeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18437533923177739637,
        "service_name": "drive-thru",
        "span_id": 9412033456849637244,
        "trace_id": 65106321781173530
    }
}

running: False
schema_name_id: 1728
start_time: 2026-04-03 03:11:09
success: True
trace_id: 65106321781173530

Partitions:

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

Schema:

attributes:

{
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "FromAmount": "string",
    "Id": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "PercentFee": "string",
    "RecordStatus_Id": "string",
    "ToAmount": "string"
}

created: 2026-04-17 03:04:14

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`\n(\n `Id`  string , `FromAmount`  string , `ToAmount`  string , `PercentFee`  string , `CreationDateTime`  string , `LastEditDateTime`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `LastEditUser_Id`  string , `DeletionUser_Id`  string , `MarinaLocation_Id`  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_moloOnlinePaymentFeeSet/2026-04-17/1776412809'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloonlinepaymentfeeset"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2023-10-17 01:59:52",
        "disabled": false,
        "format": "raw",
        "id": 1728,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_moloonlinepaymentfeeset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "CreationDateTime": "string",
            "CreationUser_Id": "string",
            "DeletionDateTime": "string",
            "DeletionUser_Id": "string",
            "FromAmount": "string",
            "Id": "string",
            "LastEditDateTime": "string",
            "LastEditUser_Id": "string",
            "MarinaLocation_Id": "string",
            "PercentFee": "string",
            "RecordStatus_Id": "string",
            "ToAmount": "string"
        },
        "created": "2026-04-17 03:04:14",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`\n(\n `Id`  string , `FromAmount`  string , `ToAmount`  string , `PercentFee`  string , `CreationDateTime`  string , `LastEditDateTime`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `LastEditUser_Id`  string , `DeletionUser_Id`  string , `MarinaLocation_Id`  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_moloOnlinePaymentFeeSet/2026-04-17/1776412809'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloonlinepaymentfeeset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloonlinepaymentfeeset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}