Schema Info

Schema Name: sfdl_prod_drivethru.molo_molocashdrawerauditsset

created: 2023-10-17 01:55:50
disabled: False
format: raw
id: 1614
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717571

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocashdrawerauditsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocashdrawerauditsset`\n(\n `Id`  string , `ActionDateTime`  string , `Reason`  string , `DrawerName`  string , `Amount`  string , `Change`  string , `AspNetUser_Id`  string , `MarinaLocation_Id`  string , `CashDrawerActions_Id`  string , `Contact_Id`  string , `Invoice_Id`  string , `IsVoid`  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_moloCashDrawerAuditsSet/2026-04-17/1776412695'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocashdrawerauditsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCashDrawerAuditsSet/2026-04-17/1776412695
id: 1717571
processed: 1

raw_data:

{
    "ActionDateTime": 1,
    "Amount": 4,
    "AspNetUser_Id": 6,
    "CashDrawerActions_Id": 8,
    "Change": 5,
    "Contact_Id": 9,
    "DrawerName": 3,
    "Id": 0,
    "Invoice_Id": 10,
    "IsVoid": 11,
    "MarinaLocation_Id": 7,
    "Reason": 2
}

schema_attributes:

{
    "ActionDateTime": "string",
    "Amount": "string",
    "AspNetUser_Id": "string",
    "CashDrawerActions_Id": "string",
    "Change": "string",
    "Contact_Id": "string",
    "DrawerName": "string",
    "Id": "string",
    "Invoice_Id": "string",
    "IsVoid": "string",
    "MarinaLocation_Id": "string",
    "Reason": "string"
}

schema_name_id: 1614
schema_scan_id: 162167191
updated: 2026-04-17 03:00:28

Version 1716442

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocashdrawerauditsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocashdrawerauditsset`\n(\n `Id`  string , `ActionDateTime`  string , `Reason`  string , `DrawerName`  string , `Amount`  string , `Change`  string , `AspNetUser_Id`  string , `MarinaLocation_Id`  string , `CashDrawerActions_Id`  string , `Contact_Id`  string , `Invoice_Id`  string , `IsVoid`  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_moloCashDrawerAuditsSet/2026-04-16/1776326459'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocashdrawerauditsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCashDrawerAuditsSet/2026-04-16/1776326459
id: 1716442
processed: 1

raw_data:

{
    "ActionDateTime": 1,
    "Amount": 4,
    "AspNetUser_Id": 6,
    "CashDrawerActions_Id": 8,
    "Change": 5,
    "Contact_Id": 9,
    "DrawerName": 3,
    "Id": 0,
    "Invoice_Id": 10,
    "IsVoid": 11,
    "MarinaLocation_Id": 7,
    "Reason": 2
}

schema_attributes:

{
    "ActionDateTime": "string",
    "Amount": "string",
    "AspNetUser_Id": "string",
    "CashDrawerActions_Id": "string",
    "Change": "string",
    "Contact_Id": "string",
    "DrawerName": "string",
    "Id": "string",
    "Invoice_Id": "string",
    "IsVoid": "string",
    "MarinaLocation_Id": "string",
    "Reason": "string"
}

schema_name_id: 1614
schema_scan_id: 162111877
updated: 2026-04-16 03:09:37

Version 1715128

created: 2026-04-15 03:00:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocashdrawerauditsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocashdrawerauditsset`\n(\n `Id`  string , `ActionDateTime`  string , `Reason`  string , `DrawerName`  string , `Amount`  string , `Change`  string , `AspNetUser_Id`  string , `MarinaLocation_Id`  string , `CashDrawerActions_Id`  string , `Contact_Id`  string , `Invoice_Id`  string , `IsVoid`  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_moloCashDrawerAuditsSet/2026-04-15/1776239929'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocashdrawerauditsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCashDrawerAuditsSet/2026-04-15/1776239929
id: 1715128
processed: 1

raw_data:

{
    "ActionDateTime": 1,
    "Amount": 4,
    "AspNetUser_Id": 6,
    "CashDrawerActions_Id": 8,
    "Change": 5,
    "Contact_Id": 9,
    "DrawerName": 3,
    "Id": 0,
    "Invoice_Id": 10,
    "IsVoid": 11,
    "MarinaLocation_Id": 7,
    "Reason": 2
}

schema_attributes:

{
    "ActionDateTime": "string",
    "Amount": "string",
    "AspNetUser_Id": "string",
    "CashDrawerActions_Id": "string",
    "Change": "string",
    "Contact_Id": "string",
    "DrawerName": "string",
    "Id": "string",
    "Invoice_Id": "string",
    "IsVoid": "string",
    "MarinaLocation_Id": "string",
    "Reason": "string"
}

schema_name_id: 1614
schema_scan_id: 162055640
updated: 2026-04-15 03:00:55

Version 1713971

created: 2026-04-14 03:04:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocashdrawerauditsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocashdrawerauditsset`\n(\n `Id`  string , `ActionDateTime`  string , `Reason`  string , `DrawerName`  string , `Amount`  string , `Change`  string , `AspNetUser_Id`  string , `MarinaLocation_Id`  string , `CashDrawerActions_Id`  string , `Contact_Id`  string , `Invoice_Id`  string , `IsVoid`  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_moloCashDrawerAuditsSet/2026-04-14/1776153654'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocashdrawerauditsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCashDrawerAuditsSet/2026-04-14/1776153654
id: 1713971
processed: 1

raw_data:

{
    "ActionDateTime": 1,
    "Amount": 4,
    "AspNetUser_Id": 6,
    "CashDrawerActions_Id": 8,
    "Change": 5,
    "Contact_Id": 9,
    "DrawerName": 3,
    "Id": 0,
    "Invoice_Id": 10,
    "IsVoid": 11,
    "MarinaLocation_Id": 7,
    "Reason": 2
}

schema_attributes:

{
    "ActionDateTime": "string",
    "Amount": "string",
    "AspNetUser_Id": "string",
    "CashDrawerActions_Id": "string",
    "Change": "string",
    "Contact_Id": "string",
    "DrawerName": "string",
    "Id": "string",
    "Invoice_Id": "string",
    "IsVoid": "string",
    "MarinaLocation_Id": "string",
    "Reason": "string"
}

schema_name_id: 1614
schema_scan_id: 162000401
updated: 2026-04-14 03:04:11

Version 1712726

created: 2026-04-13 02:56:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocashdrawerauditsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocashdrawerauditsset`\n(\n `Id`  string , `ActionDateTime`  string , `Reason`  string , `DrawerName`  string , `Amount`  string , `Change`  string , `AspNetUser_Id`  string , `MarinaLocation_Id`  string , `CashDrawerActions_Id`  string , `Contact_Id`  string , `Invoice_Id`  string , `IsVoid`  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_moloCashDrawerAuditsSet/2026-04-13/1776066847'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocashdrawerauditsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCashDrawerAuditsSet/2026-04-13/1776066847
id: 1712726
processed: 1

raw_data:

{
    "ActionDateTime": 1,
    "Amount": 4,
    "AspNetUser_Id": 6,
    "CashDrawerActions_Id": 8,
    "Change": 5,
    "Contact_Id": 9,
    "DrawerName": 3,
    "Id": 0,
    "Invoice_Id": 10,
    "IsVoid": 11,
    "MarinaLocation_Id": 7,
    "Reason": 2
}

schema_attributes:

{
    "ActionDateTime": "string",
    "Amount": "string",
    "AspNetUser_Id": "string",
    "CashDrawerActions_Id": "string",
    "Change": "string",
    "Contact_Id": "string",
    "DrawerName": "string",
    "Id": "string",
    "Invoice_Id": "string",
    "IsVoid": "string",
    "MarinaLocation_Id": "string",
    "Reason": "string"
}

schema_name_id: 1614
schema_scan_id: 161941503
updated: 2026-04-13 02:56:17

Version 1711522

created: 2026-04-12 02:57:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocashdrawerauditsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocashdrawerauditsset`\n(\n `Id`  string , `ActionDateTime`  string , `Reason`  string , `DrawerName`  string , `Amount`  string , `Change`  string , `AspNetUser_Id`  string , `MarinaLocation_Id`  string , `CashDrawerActions_Id`  string , `Contact_Id`  string , `Invoice_Id`  string , `IsVoid`  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_moloCashDrawerAuditsSet/2026-04-12/1775980563'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocashdrawerauditsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCashDrawerAuditsSet/2026-04-12/1775980563
id: 1711522
processed: 1

raw_data:

{
    "ActionDateTime": 1,
    "Amount": 4,
    "AspNetUser_Id": 6,
    "CashDrawerActions_Id": 8,
    "Change": 5,
    "Contact_Id": 9,
    "DrawerName": 3,
    "Id": 0,
    "Invoice_Id": 10,
    "IsVoid": 11,
    "MarinaLocation_Id": 7,
    "Reason": 2
}

schema_attributes:

{
    "ActionDateTime": "string",
    "Amount": "string",
    "AspNetUser_Id": "string",
    "CashDrawerActions_Id": "string",
    "Change": "string",
    "Contact_Id": "string",
    "DrawerName": "string",
    "Id": "string",
    "Invoice_Id": "string",
    "IsVoid": "string",
    "MarinaLocation_Id": "string",
    "Reason": "string"
}

schema_name_id: 1614
schema_scan_id: 161892292
updated: 2026-04-12 02:57:31

Version 1710366

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocashdrawerauditsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocashdrawerauditsset`\n(\n `Id`  string , `ActionDateTime`  string , `Reason`  string , `DrawerName`  string , `Amount`  string , `Change`  string , `AspNetUser_Id`  string , `MarinaLocation_Id`  string , `CashDrawerActions_Id`  string , `Contact_Id`  string , `Invoice_Id`  string , `IsVoid`  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_moloCashDrawerAuditsSet/2026-04-11/1775894323'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocashdrawerauditsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCashDrawerAuditsSet/2026-04-11/1775894323
id: 1710366
processed: 1

raw_data:

{
    "ActionDateTime": 1,
    "Amount": 4,
    "AspNetUser_Id": 6,
    "CashDrawerActions_Id": 8,
    "Change": 5,
    "Contact_Id": 9,
    "DrawerName": 3,
    "Id": 0,
    "Invoice_Id": 10,
    "IsVoid": 11,
    "MarinaLocation_Id": 7,
    "Reason": 2
}

schema_attributes:

{
    "ActionDateTime": "string",
    "Amount": "string",
    "AspNetUser_Id": "string",
    "CashDrawerActions_Id": "string",
    "Change": "string",
    "Contact_Id": "string",
    "DrawerName": "string",
    "Id": "string",
    "Invoice_Id": "string",
    "IsVoid": "string",
    "MarinaLocation_Id": "string",
    "Reason": "string"
}

schema_name_id: 1614
schema_scan_id: 161841102
updated: 2026-04-11 03:03:17

Version 1709154

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocashdrawerauditsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocashdrawerauditsset`\n(\n `Id`  string , `ActionDateTime`  string , `Reason`  string , `DrawerName`  string , `Amount`  string , `Change`  string , `AspNetUser_Id`  string , `MarinaLocation_Id`  string , `CashDrawerActions_Id`  string , `Contact_Id`  string , `Invoice_Id`  string , `IsVoid`  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_moloCashDrawerAuditsSet/2026-04-10/1775808080'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocashdrawerauditsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCashDrawerAuditsSet/2026-04-10/1775808080
id: 1709154
processed: 1

raw_data:

{
    "ActionDateTime": 1,
    "Amount": 4,
    "AspNetUser_Id": 6,
    "CashDrawerActions_Id": 8,
    "Change": 5,
    "Contact_Id": 9,
    "DrawerName": 3,
    "Id": 0,
    "Invoice_Id": 10,
    "IsVoid": 11,
    "MarinaLocation_Id": 7,
    "Reason": 2
}

schema_attributes:

{
    "ActionDateTime": "string",
    "Amount": "string",
    "AspNetUser_Id": "string",
    "CashDrawerActions_Id": "string",
    "Change": "string",
    "Contact_Id": "string",
    "DrawerName": "string",
    "Id": "string",
    "Invoice_Id": "string",
    "IsVoid": "string",
    "MarinaLocation_Id": "string",
    "Reason": "string"
}

schema_name_id: 1614
schema_scan_id: 161785790
updated: 2026-04-10 03:02:30

Version 1708021

created: 2026-04-09 02:58:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocashdrawerauditsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocashdrawerauditsset`\n(\n `Id`  string , `ActionDateTime`  string , `Reason`  string , `DrawerName`  string , `Amount`  string , `Change`  string , `AspNetUser_Id`  string , `MarinaLocation_Id`  string , `CashDrawerActions_Id`  string , `Contact_Id`  string , `Invoice_Id`  string , `IsVoid`  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_moloCashDrawerAuditsSet/2026-04-09/1775721419'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocashdrawerauditsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCashDrawerAuditsSet/2026-04-09/1775721419
id: 1708021
processed: 1

raw_data:

{
    "ActionDateTime": 1,
    "Amount": 4,
    "AspNetUser_Id": 6,
    "CashDrawerActions_Id": 8,
    "Change": 5,
    "Contact_Id": 9,
    "DrawerName": 3,
    "Id": 0,
    "Invoice_Id": 10,
    "IsVoid": 11,
    "MarinaLocation_Id": 7,
    "Reason": 2
}

schema_attributes:

{
    "ActionDateTime": "string",
    "Amount": "string",
    "AspNetUser_Id": "string",
    "CashDrawerActions_Id": "string",
    "Change": "string",
    "Contact_Id": "string",
    "DrawerName": "string",
    "Id": "string",
    "Invoice_Id": "string",
    "IsVoid": "string",
    "MarinaLocation_Id": "string",
    "Reason": "string"
}

schema_name_id: 1614
schema_scan_id: 161729802
updated: 2026-04-09 02:59:06

Version 1706839

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocashdrawerauditsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocashdrawerauditsset`\n(\n `Id`  string , `ActionDateTime`  string , `Reason`  string , `DrawerName`  string , `Amount`  string , `Change`  string , `AspNetUser_Id`  string , `MarinaLocation_Id`  string , `CashDrawerActions_Id`  string , `Contact_Id`  string , `Invoice_Id`  string , `IsVoid`  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_moloCashDrawerAuditsSet/2026-04-08/1775635227'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocashdrawerauditsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCashDrawerAuditsSet/2026-04-08/1775635227
id: 1706839
processed: 1

raw_data:

{
    "ActionDateTime": 1,
    "Amount": 4,
    "AspNetUser_Id": 6,
    "CashDrawerActions_Id": 8,
    "Change": 5,
    "Contact_Id": 9,
    "DrawerName": 3,
    "Id": 0,
    "Invoice_Id": 10,
    "IsVoid": 11,
    "MarinaLocation_Id": 7,
    "Reason": 2
}

schema_attributes:

{
    "ActionDateTime": "string",
    "Amount": "string",
    "AspNetUser_Id": "string",
    "CashDrawerActions_Id": "string",
    "Change": "string",
    "Contact_Id": "string",
    "DrawerName": "string",
    "Id": "string",
    "Invoice_Id": "string",
    "IsVoid": "string",
    "MarinaLocation_Id": "string",
    "Reason": "string"
}

schema_name_id: 1614
schema_scan_id: 161675400
updated: 2026-04-08 03:02:59

Version 1705639

created: 2026-04-07 02:54:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocashdrawerauditsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocashdrawerauditsset`\n(\n `Id`  string , `ActionDateTime`  string , `Reason`  string , `DrawerName`  string , `Amount`  string , `Change`  string , `AspNetUser_Id`  string , `MarinaLocation_Id`  string , `CashDrawerActions_Id`  string , `Contact_Id`  string , `Invoice_Id`  string , `IsVoid`  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_moloCashDrawerAuditsSet/2026-04-07/1775548400'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocashdrawerauditsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCashDrawerAuditsSet/2026-04-07/1775548400
id: 1705639
processed: 1

raw_data:

{
    "ActionDateTime": 1,
    "Amount": 4,
    "AspNetUser_Id": 6,
    "CashDrawerActions_Id": 8,
    "Change": 5,
    "Contact_Id": 9,
    "DrawerName": 3,
    "Id": 0,
    "Invoice_Id": 10,
    "IsVoid": 11,
    "MarinaLocation_Id": 7,
    "Reason": 2
}

schema_attributes:

{
    "ActionDateTime": "string",
    "Amount": "string",
    "AspNetUser_Id": "string",
    "CashDrawerActions_Id": "string",
    "Change": "string",
    "Contact_Id": "string",
    "DrawerName": "string",
    "Id": "string",
    "Invoice_Id": "string",
    "IsVoid": "string",
    "MarinaLocation_Id": "string",
    "Reason": "string"
}

schema_name_id: 1614
schema_scan_id: 161618317
updated: 2026-04-07 02:54:46

Version 1704379

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocashdrawerauditsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocashdrawerauditsset`\n(\n `Id`  string , `ActionDateTime`  string , `Reason`  string , `DrawerName`  string , `Amount`  string , `Change`  string , `AspNetUser_Id`  string , `MarinaLocation_Id`  string , `CashDrawerActions_Id`  string , `Contact_Id`  string , `Invoice_Id`  string , `IsVoid`  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_moloCashDrawerAuditsSet/2026-04-06/1775462363'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocashdrawerauditsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCashDrawerAuditsSet/2026-04-06/1775462363
id: 1704379
processed: 1

raw_data:

{
    "ActionDateTime": 1,
    "Amount": 4,
    "AspNetUser_Id": 6,
    "CashDrawerActions_Id": 8,
    "Change": 5,
    "Contact_Id": 9,
    "DrawerName": 3,
    "Id": 0,
    "Invoice_Id": 10,
    "IsVoid": 11,
    "MarinaLocation_Id": 7,
    "Reason": 2
}

schema_attributes:

{
    "ActionDateTime": "string",
    "Amount": "string",
    "AspNetUser_Id": "string",
    "CashDrawerActions_Id": "string",
    "Change": "string",
    "Contact_Id": "string",
    "DrawerName": "string",
    "Id": "string",
    "Invoice_Id": "string",
    "IsVoid": "string",
    "MarinaLocation_Id": "string",
    "Reason": "string"
}

schema_name_id: 1614
schema_scan_id: 161561241
updated: 2026-04-06 03:00:21

Version 1703236

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocashdrawerauditsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocashdrawerauditsset`\n(\n `Id`  string , `ActionDateTime`  string , `Reason`  string , `DrawerName`  string , `Amount`  string , `Change`  string , `AspNetUser_Id`  string , `MarinaLocation_Id`  string , `CashDrawerActions_Id`  string , `Contact_Id`  string , `Invoice_Id`  string , `IsVoid`  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_moloCashDrawerAuditsSet/2026-04-05/1775375991'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocashdrawerauditsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCashDrawerAuditsSet/2026-04-05/1775375991
id: 1703236
processed: 1

raw_data:

{
    "ActionDateTime": 1,
    "Amount": 4,
    "AspNetUser_Id": 6,
    "CashDrawerActions_Id": 8,
    "Change": 5,
    "Contact_Id": 9,
    "DrawerName": 3,
    "Id": 0,
    "Invoice_Id": 10,
    "IsVoid": 11,
    "MarinaLocation_Id": 7,
    "Reason": 2
}

schema_attributes:

{
    "ActionDateTime": "string",
    "Amount": "string",
    "AspNetUser_Id": "string",
    "CashDrawerActions_Id": "string",
    "Change": "string",
    "Contact_Id": "string",
    "DrawerName": "string",
    "Id": "string",
    "Invoice_Id": "string",
    "IsVoid": "string",
    "MarinaLocation_Id": "string",
    "Reason": "string"
}

schema_name_id: 1614
schema_scan_id: 161514804
updated: 2026-04-05 03:02:45

Version 1702036

created: 2026-04-04 02:59:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocashdrawerauditsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocashdrawerauditsset`\n(\n `Id`  string , `ActionDateTime`  string , `Reason`  string , `DrawerName`  string , `Amount`  string , `Change`  string , `AspNetUser_Id`  string , `MarinaLocation_Id`  string , `CashDrawerActions_Id`  string , `Contact_Id`  string , `Invoice_Id`  string , `IsVoid`  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_moloCashDrawerAuditsSet/2026-04-04/1775289476'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocashdrawerauditsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCashDrawerAuditsSet/2026-04-04/1775289476
id: 1702036
processed: 1

raw_data:

{
    "ActionDateTime": 1,
    "Amount": 4,
    "AspNetUser_Id": 6,
    "CashDrawerActions_Id": 8,
    "Change": 5,
    "Contact_Id": 9,
    "DrawerName": 3,
    "Id": 0,
    "Invoice_Id": 10,
    "IsVoid": 11,
    "MarinaLocation_Id": 7,
    "Reason": 2
}

schema_attributes:

{
    "ActionDateTime": "string",
    "Amount": "string",
    "AspNetUser_Id": "string",
    "CashDrawerActions_Id": "string",
    "Change": "string",
    "Contact_Id": "string",
    "DrawerName": "string",
    "Id": "string",
    "Invoice_Id": "string",
    "IsVoid": "string",
    "MarinaLocation_Id": "string",
    "Reason": "string"
}

schema_name_id: 1614
schema_scan_id: 161459817
updated: 2026-04-04 03:00:13

Version 1700896

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocashdrawerauditsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocashdrawerauditsset`\n(\n `Id`  string , `ActionDateTime`  string , `Reason`  string , `DrawerName`  string , `Amount`  string , `Change`  string , `AspNetUser_Id`  string , `MarinaLocation_Id`  string , `CashDrawerActions_Id`  string , `Contact_Id`  string , `Invoice_Id`  string , `IsVoid`  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_moloCashDrawerAuditsSet/2026-04-03/1775203248'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocashdrawerauditsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCashDrawerAuditsSet/2026-04-03/1775203248
id: 1700896
processed: 1

raw_data:

{
    "ActionDateTime": 1,
    "Amount": 4,
    "AspNetUser_Id": 6,
    "CashDrawerActions_Id": 8,
    "Change": 5,
    "Contact_Id": 9,
    "DrawerName": 3,
    "Id": 0,
    "Invoice_Id": 10,
    "IsVoid": 11,
    "MarinaLocation_Id": 7,
    "Reason": 2
}

schema_attributes:

{
    "ActionDateTime": "string",
    "Amount": "string",
    "AspNetUser_Id": "string",
    "CashDrawerActions_Id": "string",
    "Change": "string",
    "Contact_Id": "string",
    "DrawerName": "string",
    "Id": "string",
    "Invoice_Id": "string",
    "IsVoid": "string",
    "MarinaLocation_Id": "string",
    "Reason": "string"
}

schema_name_id: 1614
schema_scan_id: 161401832
updated: 2026-04-03 03:08:13

Schema Scans: 15

Last at 2026-04-17 03:00:14

Scan 162167191

duration: 0:00:14.497175

exit_message:

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

id: 162167191

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_moloCashDrawerAuditsSet/2026-04-17/1776412695",
        "key": "raw/molo_moloCashDrawerAuditsSet/2026-04-17/1776412695/CashDrawerAuditsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCashDrawerAuditsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15677283474081642466,
        "service_name": "drive-thru",
        "span_id": 4677825623001870537,
        "trace_id": 13515910802121784084
    }
}

running: False
schema_name_id: 1614
start_time: 2026-04-17 03:00:14
success: True
trace_id: 13515910802121784084

Scan 162111877

duration: 0:00:14.466772

exit_message:

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

id: 162111877

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_moloCashDrawerAuditsSet/2026-04-16/1776326459",
        "key": "raw/molo_moloCashDrawerAuditsSet/2026-04-16/1776326459/CashDrawerAuditsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCashDrawerAuditsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4636652659167668268,
        "service_name": "drive-thru",
        "span_id": 10241093326597707824,
        "trace_id": 14878237521271627037
    }
}

running: False
schema_name_id: 1614
start_time: 2026-04-16 03:09:23
success: True
trace_id: 14878237521271627037

Scan 162055640

duration: 0:00:14.459750

exit_message:

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

id: 162055640

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_moloCashDrawerAuditsSet/2026-04-15/1776239929",
        "key": "raw/molo_moloCashDrawerAuditsSet/2026-04-15/1776239929/CashDrawerAuditsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCashDrawerAuditsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14743566153245824122,
        "service_name": "drive-thru",
        "span_id": 11546396826619144598,
        "trace_id": 8242173877029389722
    }
}

running: False
schema_name_id: 1614
start_time: 2026-04-15 03:00:41
success: True
trace_id: 8242173877029389722

Scan 162000401

duration: 0:00:12.072650

exit_message:

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

id: 162000401

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_moloCashDrawerAuditsSet/2026-04-14/1776153654",
        "key": "raw/molo_moloCashDrawerAuditsSet/2026-04-14/1776153654/CashDrawerAuditsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCashDrawerAuditsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14290330853725202434,
        "service_name": "drive-thru",
        "span_id": 939227009794223002,
        "trace_id": 11414927743728432250
    }
}

running: False
schema_name_id: 1614
start_time: 2026-04-14 03:03:59
success: True
trace_id: 11414927743728432250

Scan 161941503

duration: 0:00:14.516401

exit_message:

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

id: 161941503

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_moloCashDrawerAuditsSet/2026-04-13/1776066847",
        "key": "raw/molo_moloCashDrawerAuditsSet/2026-04-13/1776066847/CashDrawerAuditsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCashDrawerAuditsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12974829227423122168,
        "service_name": "drive-thru",
        "span_id": 12754803110744033225,
        "trace_id": 206856033777625044
    }
}

running: False
schema_name_id: 1614
start_time: 2026-04-13 02:56:03
success: True
trace_id: 206856033777625044

Scan 161892292

duration: 0:00:11.930626

exit_message:

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

id: 161892292

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_moloCashDrawerAuditsSet/2026-04-12/1775980563",
        "key": "raw/molo_moloCashDrawerAuditsSet/2026-04-12/1775980563/CashDrawerAuditsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCashDrawerAuditsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13557381358114319250,
        "service_name": "drive-thru",
        "span_id": 13944553293070296763,
        "trace_id": 13008290129589762142
    }
}

running: False
schema_name_id: 1614
start_time: 2026-04-12 02:57:19
success: True
trace_id: 13008290129589762142

Scan 161841102

duration: 0:00:14.462092

exit_message:

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

id: 161841102

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_moloCashDrawerAuditsSet/2026-04-11/1775894323",
        "key": "raw/molo_moloCashDrawerAuditsSet/2026-04-11/1775894323/CashDrawerAuditsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCashDrawerAuditsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9633706865630394119,
        "service_name": "drive-thru",
        "span_id": 16672108916263894035,
        "trace_id": 18118249259605758950
    }
}

running: False
schema_name_id: 1614
start_time: 2026-04-11 03:03:03
success: True
trace_id: 18118249259605758950

Scan 161785790

duration: 0:00:14.855774

exit_message:

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

id: 161785790

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_moloCashDrawerAuditsSet/2026-04-10/1775808080",
        "key": "raw/molo_moloCashDrawerAuditsSet/2026-04-10/1775808080/CashDrawerAuditsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCashDrawerAuditsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8640367423024624032,
        "service_name": "drive-thru",
        "span_id": 11808112879392592761,
        "trace_id": 16198596989231116061
    }
}

running: False
schema_name_id: 1614
start_time: 2026-04-10 03:02:15
success: True
trace_id: 16198596989231116061

Scan 161729802

duration: 0:00:14.642853

exit_message:

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

id: 161729802

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_moloCashDrawerAuditsSet/2026-04-09/1775721419",
        "key": "raw/molo_moloCashDrawerAuditsSet/2026-04-09/1775721419/CashDrawerAuditsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCashDrawerAuditsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6351316203580260934,
        "service_name": "drive-thru",
        "span_id": 239360053883450139,
        "trace_id": 5355349353127435286
    }
}

running: False
schema_name_id: 1614
start_time: 2026-04-09 02:58:52
success: True
trace_id: 5355349353127435286

Scan 161675400

duration: 0:00:11.851478

exit_message:

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

id: 161675400

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_moloCashDrawerAuditsSet/2026-04-08/1775635227",
        "key": "raw/molo_moloCashDrawerAuditsSet/2026-04-08/1775635227/CashDrawerAuditsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCashDrawerAuditsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2784280458631051615,
        "service_name": "drive-thru",
        "span_id": 1421046085303913553,
        "trace_id": 7255362108929827505
    }
}

running: False
schema_name_id: 1614
start_time: 2026-04-08 03:02:47
success: True
trace_id: 7255362108929827505

Scan 161618317

duration: 0:00:14.462815

exit_message:

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

id: 161618317

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_moloCashDrawerAuditsSet/2026-04-07/1775548400",
        "key": "raw/molo_moloCashDrawerAuditsSet/2026-04-07/1775548400/CashDrawerAuditsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCashDrawerAuditsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4306717831078925785,
        "service_name": "drive-thru",
        "span_id": 10758339878264030336,
        "trace_id": 14233898191622087372
    }
}

running: False
schema_name_id: 1614
start_time: 2026-04-07 02:54:32
success: True
trace_id: 14233898191622087372

Scan 161561241

duration: 0:00:14.537135

exit_message:

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

id: 161561241

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_moloCashDrawerAuditsSet/2026-04-06/1775462363",
        "key": "raw/molo_moloCashDrawerAuditsSet/2026-04-06/1775462363/CashDrawerAuditsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCashDrawerAuditsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1944332472293074369,
        "service_name": "drive-thru",
        "span_id": 9485967768591651642,
        "trace_id": 4682690964778053984
    }
}

running: False
schema_name_id: 1614
start_time: 2026-04-06 03:00:07
success: True
trace_id: 4682690964778053984

Scan 161514804

duration: 0:00:14.471988

exit_message:

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

id: 161514804

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_moloCashDrawerAuditsSet/2026-04-05/1775375991",
        "key": "raw/molo_moloCashDrawerAuditsSet/2026-04-05/1775375991/CashDrawerAuditsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCashDrawerAuditsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10196107002860902812,
        "service_name": "drive-thru",
        "span_id": 12650962939572083214,
        "trace_id": 1891004175542450361
    }
}

running: False
schema_name_id: 1614
start_time: 2026-04-05 03:02:31
success: True
trace_id: 1891004175542450361

Scan 161459817

duration: 0:00:14.482867

exit_message:

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

id: 161459817

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_moloCashDrawerAuditsSet/2026-04-04/1775289476",
        "key": "raw/molo_moloCashDrawerAuditsSet/2026-04-04/1775289476/CashDrawerAuditsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCashDrawerAuditsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17332658000570349652,
        "service_name": "drive-thru",
        "span_id": 11953773615083676829,
        "trace_id": 12521888440065199034
    }
}

running: False
schema_name_id: 1614
start_time: 2026-04-04 02:59:59
success: True
trace_id: 12521888440065199034

Scan 161401832

duration: 0:00:12.021342

exit_message:

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

id: 161401832

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_moloCashDrawerAuditsSet/2026-04-03/1775203248",
        "key": "raw/molo_moloCashDrawerAuditsSet/2026-04-03/1775203248/CashDrawerAuditsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCashDrawerAuditsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3403256719589593314,
        "service_name": "drive-thru",
        "span_id": 10213820918965275292,
        "trace_id": 11886536806263880250
    }
}

running: False
schema_name_id: 1614
start_time: 2026-04-03 03:08:01
success: True
trace_id: 11886536806263880250

Partitions:

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

Schema:

attributes:

{
    "ActionDateTime": "string",
    "Amount": "string",
    "AspNetUser_Id": "string",
    "CashDrawerActions_Id": "string",
    "Change": "string",
    "Contact_Id": "string",
    "DrawerName": "string",
    "Id": "string",
    "Invoice_Id": "string",
    "IsVoid": "string",
    "MarinaLocation_Id": "string",
    "Reason": "string"
}

created: 2026-04-17 03:00: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_molocashdrawerauditsset`\n(\n `Id`  string , `ActionDateTime`  string , `Reason`  string , `DrawerName`  string , `Amount`  string , `Change`  string , `AspNetUser_Id`  string , `MarinaLocation_Id`  string , `CashDrawerActions_Id`  string , `Contact_Id`  string , `Invoice_Id`  string , `IsVoid`  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_moloCashDrawerAuditsSet/2026-04-17/1776412695'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocashdrawerauditsset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocashdrawerauditsset"
}

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:55:50",
        "disabled": false,
        "format": "raw",
        "id": 1614,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molocashdrawerauditsset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "ActionDateTime": "string",
            "Amount": "string",
            "AspNetUser_Id": "string",
            "CashDrawerActions_Id": "string",
            "Change": "string",
            "Contact_Id": "string",
            "DrawerName": "string",
            "Id": "string",
            "Invoice_Id": "string",
            "IsVoid": "string",
            "MarinaLocation_Id": "string",
            "Reason": "string"
        },
        "created": "2026-04-17 03:00: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_molocashdrawerauditsset`\n(\n `Id`  string , `ActionDateTime`  string , `Reason`  string , `DrawerName`  string , `Amount`  string , `Change`  string , `AspNetUser_Id`  string , `MarinaLocation_Id`  string , `CashDrawerActions_Id`  string , `Contact_Id`  string , `Invoice_Id`  string , `IsVoid`  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_moloCashDrawerAuditsSet/2026-04-17/1776412695'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocashdrawerauditsset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocashdrawerauditsset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}