Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloquickbooksettingsset

created: 2023-10-17 01:56:42
disabled: False
format: raw
id: 1639
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717691

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloquickbooksettingsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloquickbooksettingsset`\n(\n `Id`  string , `CashClearingAccount`  string , `CheckClearingAccount`  string , `VisaClearingAccount`  string , `MastercardClearingAccount`  string , `AmericanExpressClearingAccount`  string , `DiscoverClearingAccount`  string , `BankAccountClearingAccount`  string , `DiscountsAccount`  string , `PrepaymentAccount`  string , `OverpaymentAccount`  string , `MarinaLocation_Id`  string , `WireTransferClearingAccount`  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_moloQuickbookSettingsSet/2026-04-17/1776412814'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloquickbooksettingsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQuickbookSettingsSet/2026-04-17/1776412814
id: 1717691
processed: 1

raw_data:

{
    "AmericanExpressClearingAccount": 5,
    "BankAccountClearingAccount": 7,
    "CashClearingAccount": 1,
    "CheckClearingAccount": 2,
    "DiscountsAccount": 8,
    "DiscoverClearingAccount": 6,
    "Id": 0,
    "MarinaLocation_Id": 11,
    "MastercardClearingAccount": 4,
    "OverpaymentAccount": 10,
    "PrepaymentAccount": 9,
    "VisaClearingAccount": 3,
    "WireTransferClearingAccount": 12
}

schema_attributes:

{
    "AmericanExpressClearingAccount": "string",
    "BankAccountClearingAccount": "string",
    "CashClearingAccount": "string",
    "CheckClearingAccount": "string",
    "DiscountsAccount": "string",
    "DiscoverClearingAccount": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MastercardClearingAccount": "string",
    "OverpaymentAccount": "string",
    "PrepaymentAccount": "string",
    "VisaClearingAccount": "string",
    "WireTransferClearingAccount": "string"
}

schema_name_id: 1639
schema_scan_id: 162167677
updated: 2026-04-17 03:07:21

Version 1716446

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloquickbooksettingsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloquickbooksettingsset`\n(\n `Id`  string , `CashClearingAccount`  string , `CheckClearingAccount`  string , `VisaClearingAccount`  string , `MastercardClearingAccount`  string , `AmericanExpressClearingAccount`  string , `DiscoverClearingAccount`  string , `BankAccountClearingAccount`  string , `DiscountsAccount`  string , `PrepaymentAccount`  string , `OverpaymentAccount`  string , `MarinaLocation_Id`  string , `WireTransferClearingAccount`  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_moloQuickbookSettingsSet/2026-04-16/1776326570'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloquickbooksettingsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQuickbookSettingsSet/2026-04-16/1776326570
id: 1716446
processed: 1

raw_data:

{
    "AmericanExpressClearingAccount": 5,
    "BankAccountClearingAccount": 7,
    "CashClearingAccount": 1,
    "CheckClearingAccount": 2,
    "DiscountsAccount": 8,
    "DiscoverClearingAccount": 6,
    "Id": 0,
    "MarinaLocation_Id": 11,
    "MastercardClearingAccount": 4,
    "OverpaymentAccount": 10,
    "PrepaymentAccount": 9,
    "VisaClearingAccount": 3,
    "WireTransferClearingAccount": 12
}

schema_attributes:

{
    "AmericanExpressClearingAccount": "string",
    "BankAccountClearingAccount": "string",
    "CashClearingAccount": "string",
    "CheckClearingAccount": "string",
    "DiscountsAccount": "string",
    "DiscoverClearingAccount": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MastercardClearingAccount": "string",
    "OverpaymentAccount": "string",
    "PrepaymentAccount": "string",
    "VisaClearingAccount": "string",
    "WireTransferClearingAccount": "string"
}

schema_name_id: 1639
schema_scan_id: 162111881
updated: 2026-04-16 03:09:40

Version 1715210

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloquickbooksettingsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloquickbooksettingsset`\n(\n `Id`  string , `CashClearingAccount`  string , `CheckClearingAccount`  string , `VisaClearingAccount`  string , `MastercardClearingAccount`  string , `AmericanExpressClearingAccount`  string , `DiscoverClearingAccount`  string , `BankAccountClearingAccount`  string , `DiscountsAccount`  string , `PrepaymentAccount`  string , `OverpaymentAccount`  string , `MarinaLocation_Id`  string , `WireTransferClearingAccount`  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_moloQuickbookSettingsSet/2026-04-15/1776240039'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloquickbooksettingsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQuickbookSettingsSet/2026-04-15/1776240039
id: 1715210
processed: 1

raw_data:

{
    "AmericanExpressClearingAccount": 5,
    "BankAccountClearingAccount": 7,
    "CashClearingAccount": 1,
    "CheckClearingAccount": 2,
    "DiscountsAccount": 8,
    "DiscoverClearingAccount": 6,
    "Id": 0,
    "MarinaLocation_Id": 11,
    "MastercardClearingAccount": 4,
    "OverpaymentAccount": 10,
    "PrepaymentAccount": 9,
    "VisaClearingAccount": 3,
    "WireTransferClearingAccount": 12
}

schema_attributes:

{
    "AmericanExpressClearingAccount": "string",
    "BankAccountClearingAccount": "string",
    "CashClearingAccount": "string",
    "CheckClearingAccount": "string",
    "DiscountsAccount": "string",
    "DiscoverClearingAccount": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MastercardClearingAccount": "string",
    "OverpaymentAccount": "string",
    "PrepaymentAccount": "string",
    "VisaClearingAccount": "string",
    "WireTransferClearingAccount": "string"
}

schema_name_id: 1639
schema_scan_id: 162055926
updated: 2026-04-15 03:05:20

Version 1714051

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloquickbooksettingsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloquickbooksettingsset`\n(\n `Id`  string , `CashClearingAccount`  string , `CheckClearingAccount`  string , `VisaClearingAccount`  string , `MastercardClearingAccount`  string , `AmericanExpressClearingAccount`  string , `DiscoverClearingAccount`  string , `BankAccountClearingAccount`  string , `DiscountsAccount`  string , `PrepaymentAccount`  string , `OverpaymentAccount`  string , `MarinaLocation_Id`  string , `WireTransferClearingAccount`  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_moloQuickbookSettingsSet/2026-04-14/1776153769'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloquickbooksettingsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQuickbookSettingsSet/2026-04-14/1776153769
id: 1714051
processed: 1

raw_data:

{
    "AmericanExpressClearingAccount": 5,
    "BankAccountClearingAccount": 7,
    "CashClearingAccount": 1,
    "CheckClearingAccount": 2,
    "DiscountsAccount": 8,
    "DiscoverClearingAccount": 6,
    "Id": 0,
    "MarinaLocation_Id": 11,
    "MastercardClearingAccount": 4,
    "OverpaymentAccount": 10,
    "PrepaymentAccount": 9,
    "VisaClearingAccount": 3,
    "WireTransferClearingAccount": 12
}

schema_attributes:

{
    "AmericanExpressClearingAccount": "string",
    "BankAccountClearingAccount": "string",
    "CashClearingAccount": "string",
    "CheckClearingAccount": "string",
    "DiscountsAccount": "string",
    "DiscoverClearingAccount": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MastercardClearingAccount": "string",
    "OverpaymentAccount": "string",
    "PrepaymentAccount": "string",
    "VisaClearingAccount": "string",
    "WireTransferClearingAccount": "string"
}

schema_name_id: 1639
schema_scan_id: 162000540
updated: 2026-04-14 03:07:37

Version 1712813

created: 2026-04-13 02:59:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloquickbooksettingsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloquickbooksettingsset`\n(\n `Id`  string , `CashClearingAccount`  string , `CheckClearingAccount`  string , `VisaClearingAccount`  string , `MastercardClearingAccount`  string , `AmericanExpressClearingAccount`  string , `DiscoverClearingAccount`  string , `BankAccountClearingAccount`  string , `DiscountsAccount`  string , `PrepaymentAccount`  string , `OverpaymentAccount`  string , `MarinaLocation_Id`  string , `WireTransferClearingAccount`  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_moloQuickbookSettingsSet/2026-04-13/1776066963'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloquickbooksettingsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQuickbookSettingsSet/2026-04-13/1776066963
id: 1712813
processed: 1

raw_data:

{
    "AmericanExpressClearingAccount": 5,
    "BankAccountClearingAccount": 7,
    "CashClearingAccount": 1,
    "CheckClearingAccount": 2,
    "DiscountsAccount": 8,
    "DiscoverClearingAccount": 6,
    "Id": 0,
    "MarinaLocation_Id": 11,
    "MastercardClearingAccount": 4,
    "OverpaymentAccount": 10,
    "PrepaymentAccount": 9,
    "VisaClearingAccount": 3,
    "WireTransferClearingAccount": 12
}

schema_attributes:

{
    "AmericanExpressClearingAccount": "string",
    "BankAccountClearingAccount": "string",
    "CashClearingAccount": "string",
    "CheckClearingAccount": "string",
    "DiscountsAccount": "string",
    "DiscoverClearingAccount": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MastercardClearingAccount": "string",
    "OverpaymentAccount": "string",
    "PrepaymentAccount": "string",
    "VisaClearingAccount": "string",
    "WireTransferClearingAccount": "string"
}

schema_name_id: 1639
schema_scan_id: 161941785
updated: 2026-04-13 02:59:51

Version 1711580

created: 2026-04-12 03:00:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloquickbooksettingsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloquickbooksettingsset`\n(\n `Id`  string , `CashClearingAccount`  string , `CheckClearingAccount`  string , `VisaClearingAccount`  string , `MastercardClearingAccount`  string , `AmericanExpressClearingAccount`  string , `DiscoverClearingAccount`  string , `BankAccountClearingAccount`  string , `DiscountsAccount`  string , `PrepaymentAccount`  string , `OverpaymentAccount`  string , `MarinaLocation_Id`  string , `WireTransferClearingAccount`  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_moloQuickbookSettingsSet/2026-04-12/1775980675'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloquickbooksettingsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQuickbookSettingsSet/2026-04-12/1775980675
id: 1711580
processed: 1

raw_data:

{
    "AmericanExpressClearingAccount": 5,
    "BankAccountClearingAccount": 7,
    "CashClearingAccount": 1,
    "CheckClearingAccount": 2,
    "DiscountsAccount": 8,
    "DiscoverClearingAccount": 6,
    "Id": 0,
    "MarinaLocation_Id": 11,
    "MastercardClearingAccount": 4,
    "OverpaymentAccount": 10,
    "PrepaymentAccount": 9,
    "VisaClearingAccount": 3,
    "WireTransferClearingAccount": 12
}

schema_attributes:

{
    "AmericanExpressClearingAccount": "string",
    "BankAccountClearingAccount": "string",
    "CashClearingAccount": "string",
    "CheckClearingAccount": "string",
    "DiscountsAccount": "string",
    "DiscoverClearingAccount": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MastercardClearingAccount": "string",
    "OverpaymentAccount": "string",
    "PrepaymentAccount": "string",
    "VisaClearingAccount": "string",
    "WireTransferClearingAccount": "string"
}

schema_name_id: 1639
schema_scan_id: 161892592
updated: 2026-04-12 03:00:37

Version 1710389

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloquickbooksettingsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloquickbooksettingsset`\n(\n `Id`  string , `CashClearingAccount`  string , `CheckClearingAccount`  string , `VisaClearingAccount`  string , `MastercardClearingAccount`  string , `AmericanExpressClearingAccount`  string , `DiscoverClearingAccount`  string , `BankAccountClearingAccount`  string , `DiscountsAccount`  string , `PrepaymentAccount`  string , `OverpaymentAccount`  string , `MarinaLocation_Id`  string , `WireTransferClearingAccount`  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_moloQuickbookSettingsSet/2026-04-11/1775894436'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloquickbooksettingsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQuickbookSettingsSet/2026-04-11/1775894436
id: 1710389
processed: 1

raw_data:

{
    "AmericanExpressClearingAccount": 5,
    "BankAccountClearingAccount": 7,
    "CashClearingAccount": 1,
    "CheckClearingAccount": 2,
    "DiscountsAccount": 8,
    "DiscoverClearingAccount": 6,
    "Id": 0,
    "MarinaLocation_Id": 11,
    "MastercardClearingAccount": 4,
    "OverpaymentAccount": 10,
    "PrepaymentAccount": 9,
    "VisaClearingAccount": 3,
    "WireTransferClearingAccount": 12
}

schema_attributes:

{
    "AmericanExpressClearingAccount": "string",
    "BankAccountClearingAccount": "string",
    "CashClearingAccount": "string",
    "CheckClearingAccount": "string",
    "DiscountsAccount": "string",
    "DiscoverClearingAccount": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MastercardClearingAccount": "string",
    "OverpaymentAccount": "string",
    "PrepaymentAccount": "string",
    "VisaClearingAccount": "string",
    "WireTransferClearingAccount": "string"
}

schema_name_id: 1639
schema_scan_id: 161841137
updated: 2026-04-11 03:04:12

Version 1709252

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloquickbooksettingsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloquickbooksettingsset`\n(\n `Id`  string , `CashClearingAccount`  string , `CheckClearingAccount`  string , `VisaClearingAccount`  string , `MastercardClearingAccount`  string , `AmericanExpressClearingAccount`  string , `DiscoverClearingAccount`  string , `BankAccountClearingAccount`  string , `DiscountsAccount`  string , `PrepaymentAccount`  string , `OverpaymentAccount`  string , `MarinaLocation_Id`  string , `WireTransferClearingAccount`  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_moloQuickbookSettingsSet/2026-04-10/1775808193'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloquickbooksettingsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQuickbookSettingsSet/2026-04-10/1775808193
id: 1709252
processed: 1

raw_data:

{
    "AmericanExpressClearingAccount": 5,
    "BankAccountClearingAccount": 7,
    "CashClearingAccount": 1,
    "CheckClearingAccount": 2,
    "DiscountsAccount": 8,
    "DiscoverClearingAccount": 6,
    "Id": 0,
    "MarinaLocation_Id": 11,
    "MastercardClearingAccount": 4,
    "OverpaymentAccount": 10,
    "PrepaymentAccount": 9,
    "VisaClearingAccount": 3,
    "WireTransferClearingAccount": 12
}

schema_attributes:

{
    "AmericanExpressClearingAccount": "string",
    "BankAccountClearingAccount": "string",
    "CashClearingAccount": "string",
    "CheckClearingAccount": "string",
    "DiscountsAccount": "string",
    "DiscoverClearingAccount": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MastercardClearingAccount": "string",
    "OverpaymentAccount": "string",
    "PrepaymentAccount": "string",
    "VisaClearingAccount": "string",
    "WireTransferClearingAccount": "string"
}

schema_name_id: 1639
schema_scan_id: 161785938
updated: 2026-04-10 03:06:33

Version 1708174

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloquickbooksettingsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloquickbooksettingsset`\n(\n `Id`  string , `CashClearingAccount`  string , `CheckClearingAccount`  string , `VisaClearingAccount`  string , `MastercardClearingAccount`  string , `AmericanExpressClearingAccount`  string , `DiscoverClearingAccount`  string , `BankAccountClearingAccount`  string , `DiscountsAccount`  string , `PrepaymentAccount`  string , `OverpaymentAccount`  string , `MarinaLocation_Id`  string , `WireTransferClearingAccount`  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_moloQuickbookSettingsSet/2026-04-09/1775721532'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloquickbooksettingsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQuickbookSettingsSet/2026-04-09/1775721532
id: 1708174
processed: 1

raw_data:

{
    "AmericanExpressClearingAccount": 5,
    "BankAccountClearingAccount": 7,
    "CashClearingAccount": 1,
    "CheckClearingAccount": 2,
    "DiscountsAccount": 8,
    "DiscoverClearingAccount": 6,
    "Id": 0,
    "MarinaLocation_Id": 11,
    "MastercardClearingAccount": 4,
    "OverpaymentAccount": 10,
    "PrepaymentAccount": 9,
    "VisaClearingAccount": 3,
    "WireTransferClearingAccount": 12
}

schema_attributes:

{
    "AmericanExpressClearingAccount": "string",
    "BankAccountClearingAccount": "string",
    "CashClearingAccount": "string",
    "CheckClearingAccount": "string",
    "DiscountsAccount": "string",
    "DiscoverClearingAccount": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MastercardClearingAccount": "string",
    "OverpaymentAccount": "string",
    "PrepaymentAccount": "string",
    "VisaClearingAccount": "string",
    "WireTransferClearingAccount": "string"
}

schema_name_id: 1639
schema_scan_id: 161730393
updated: 2026-04-09 03:06:03

Version 1706959

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloquickbooksettingsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloquickbooksettingsset`\n(\n `Id`  string , `CashClearingAccount`  string , `CheckClearingAccount`  string , `VisaClearingAccount`  string , `MastercardClearingAccount`  string , `AmericanExpressClearingAccount`  string , `DiscoverClearingAccount`  string , `BankAccountClearingAccount`  string , `DiscountsAccount`  string , `PrepaymentAccount`  string , `OverpaymentAccount`  string , `MarinaLocation_Id`  string , `WireTransferClearingAccount`  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_moloQuickbookSettingsSet/2026-04-08/1775635360'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloquickbooksettingsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQuickbookSettingsSet/2026-04-08/1775635360
id: 1706959
processed: 1

raw_data:

{
    "AmericanExpressClearingAccount": 5,
    "BankAccountClearingAccount": 7,
    "CashClearingAccount": 1,
    "CheckClearingAccount": 2,
    "DiscountsAccount": 8,
    "DiscoverClearingAccount": 6,
    "Id": 0,
    "MarinaLocation_Id": 11,
    "MastercardClearingAccount": 4,
    "OverpaymentAccount": 10,
    "PrepaymentAccount": 9,
    "VisaClearingAccount": 3,
    "WireTransferClearingAccount": 12
}

schema_attributes:

{
    "AmericanExpressClearingAccount": "string",
    "BankAccountClearingAccount": "string",
    "CashClearingAccount": "string",
    "CheckClearingAccount": "string",
    "DiscountsAccount": "string",
    "DiscoverClearingAccount": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MastercardClearingAccount": "string",
    "OverpaymentAccount": "string",
    "PrepaymentAccount": "string",
    "VisaClearingAccount": "string",
    "WireTransferClearingAccount": "string"
}

schema_name_id: 1639
schema_scan_id: 161675608
updated: 2026-04-08 03:08:07

Version 1705721

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloquickbooksettingsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloquickbooksettingsset`\n(\n `Id`  string , `CashClearingAccount`  string , `CheckClearingAccount`  string , `VisaClearingAccount`  string , `MastercardClearingAccount`  string , `AmericanExpressClearingAccount`  string , `DiscoverClearingAccount`  string , `BankAccountClearingAccount`  string , `DiscountsAccount`  string , `PrepaymentAccount`  string , `OverpaymentAccount`  string , `MarinaLocation_Id`  string , `WireTransferClearingAccount`  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_moloQuickbookSettingsSet/2026-04-07/1775548510'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloquickbooksettingsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQuickbookSettingsSet/2026-04-07/1775548510
id: 1705721
processed: 1

raw_data:

{
    "AmericanExpressClearingAccount": 5,
    "BankAccountClearingAccount": 7,
    "CashClearingAccount": 1,
    "CheckClearingAccount": 2,
    "DiscountsAccount": 8,
    "DiscoverClearingAccount": 6,
    "Id": 0,
    "MarinaLocation_Id": 11,
    "MastercardClearingAccount": 4,
    "OverpaymentAccount": 10,
    "PrepaymentAccount": 9,
    "VisaClearingAccount": 3,
    "WireTransferClearingAccount": 12
}

schema_attributes:

{
    "AmericanExpressClearingAccount": "string",
    "BankAccountClearingAccount": "string",
    "CashClearingAccount": "string",
    "CheckClearingAccount": "string",
    "DiscountsAccount": "string",
    "DiscoverClearingAccount": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MastercardClearingAccount": "string",
    "OverpaymentAccount": "string",
    "PrepaymentAccount": "string",
    "VisaClearingAccount": "string",
    "WireTransferClearingAccount": "string"
}

schema_name_id: 1639
schema_scan_id: 161618434
updated: 2026-04-07 02:57:57

Version 1704520

created: 2026-04-06 03:06:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloquickbooksettingsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloquickbooksettingsset`\n(\n `Id`  string , `CashClearingAccount`  string , `CheckClearingAccount`  string , `VisaClearingAccount`  string , `MastercardClearingAccount`  string , `AmericanExpressClearingAccount`  string , `DiscoverClearingAccount`  string , `BankAccountClearingAccount`  string , `DiscountsAccount`  string , `PrepaymentAccount`  string , `OverpaymentAccount`  string , `MarinaLocation_Id`  string , `WireTransferClearingAccount`  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_moloQuickbookSettingsSet/2026-04-06/1775462477'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloquickbooksettingsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQuickbookSettingsSet/2026-04-06/1775462477
id: 1704520
processed: 1

raw_data:

{
    "AmericanExpressClearingAccount": 5,
    "BankAccountClearingAccount": 7,
    "CashClearingAccount": 1,
    "CheckClearingAccount": 2,
    "DiscountsAccount": 8,
    "DiscoverClearingAccount": 6,
    "Id": 0,
    "MarinaLocation_Id": 11,
    "MastercardClearingAccount": 4,
    "OverpaymentAccount": 10,
    "PrepaymentAccount": 9,
    "VisaClearingAccount": 3,
    "WireTransferClearingAccount": 12
}

schema_attributes:

{
    "AmericanExpressClearingAccount": "string",
    "BankAccountClearingAccount": "string",
    "CashClearingAccount": "string",
    "CheckClearingAccount": "string",
    "DiscountsAccount": "string",
    "DiscoverClearingAccount": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MastercardClearingAccount": "string",
    "OverpaymentAccount": "string",
    "PrepaymentAccount": "string",
    "VisaClearingAccount": "string",
    "WireTransferClearingAccount": "string"
}

schema_name_id: 1639
schema_scan_id: 161561616
updated: 2026-04-06 03:07:09

Version 1703273

created: 2026-04-05 03:04:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloquickbooksettingsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloquickbooksettingsset`\n(\n `Id`  string , `CashClearingAccount`  string , `CheckClearingAccount`  string , `VisaClearingAccount`  string , `MastercardClearingAccount`  string , `AmericanExpressClearingAccount`  string , `DiscoverClearingAccount`  string , `BankAccountClearingAccount`  string , `DiscountsAccount`  string , `PrepaymentAccount`  string , `OverpaymentAccount`  string , `MarinaLocation_Id`  string , `WireTransferClearingAccount`  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_moloQuickbookSettingsSet/2026-04-05/1775376103'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloquickbooksettingsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQuickbookSettingsSet/2026-04-05/1775376103
id: 1703273
processed: 1

raw_data:

{
    "AmericanExpressClearingAccount": 5,
    "BankAccountClearingAccount": 7,
    "CashClearingAccount": 1,
    "CheckClearingAccount": 2,
    "DiscountsAccount": 8,
    "DiscoverClearingAccount": 6,
    "Id": 0,
    "MarinaLocation_Id": 11,
    "MastercardClearingAccount": 4,
    "OverpaymentAccount": 10,
    "PrepaymentAccount": 9,
    "VisaClearingAccount": 3,
    "WireTransferClearingAccount": 12
}

schema_attributes:

{
    "AmericanExpressClearingAccount": "string",
    "BankAccountClearingAccount": "string",
    "CashClearingAccount": "string",
    "CheckClearingAccount": "string",
    "DiscountsAccount": "string",
    "DiscoverClearingAccount": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MastercardClearingAccount": "string",
    "OverpaymentAccount": "string",
    "PrepaymentAccount": "string",
    "VisaClearingAccount": "string",
    "WireTransferClearingAccount": "string"
}

schema_name_id: 1639
schema_scan_id: 161514851
updated: 2026-04-05 03:04:15

Version 1702158

created: 2026-04-04 03:05:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloquickbooksettingsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloquickbooksettingsset`\n(\n `Id`  string , `CashClearingAccount`  string , `CheckClearingAccount`  string , `VisaClearingAccount`  string , `MastercardClearingAccount`  string , `AmericanExpressClearingAccount`  string , `DiscoverClearingAccount`  string , `BankAccountClearingAccount`  string , `DiscountsAccount`  string , `PrepaymentAccount`  string , `OverpaymentAccount`  string , `MarinaLocation_Id`  string , `WireTransferClearingAccount`  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_moloQuickbookSettingsSet/2026-04-04/1775289586'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloquickbooksettingsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQuickbookSettingsSet/2026-04-04/1775289586
id: 1702158
processed: 1

raw_data:

{
    "AmericanExpressClearingAccount": 5,
    "BankAccountClearingAccount": 7,
    "CashClearingAccount": 1,
    "CheckClearingAccount": 2,
    "DiscountsAccount": 8,
    "DiscoverClearingAccount": 6,
    "Id": 0,
    "MarinaLocation_Id": 11,
    "MastercardClearingAccount": 4,
    "OverpaymentAccount": 10,
    "PrepaymentAccount": 9,
    "VisaClearingAccount": 3,
    "WireTransferClearingAccount": 12
}

schema_attributes:

{
    "AmericanExpressClearingAccount": "string",
    "BankAccountClearingAccount": "string",
    "CashClearingAccount": "string",
    "CheckClearingAccount": "string",
    "DiscountsAccount": "string",
    "DiscoverClearingAccount": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MastercardClearingAccount": "string",
    "OverpaymentAccount": "string",
    "PrepaymentAccount": "string",
    "VisaClearingAccount": "string",
    "WireTransferClearingAccount": "string"
}

schema_name_id: 1639
schema_scan_id: 161460358
updated: 2026-04-04 03:05:29

Version 1700920

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloquickbooksettingsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloquickbooksettingsset`\n(\n `Id`  string , `CashClearingAccount`  string , `CheckClearingAccount`  string , `VisaClearingAccount`  string , `MastercardClearingAccount`  string , `AmericanExpressClearingAccount`  string , `DiscoverClearingAccount`  string , `BankAccountClearingAccount`  string , `DiscountsAccount`  string , `PrepaymentAccount`  string , `OverpaymentAccount`  string , `MarinaLocation_Id`  string , `WireTransferClearingAccount`  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_moloQuickbookSettingsSet/2026-04-03/1775203359'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloquickbooksettingsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQuickbookSettingsSet/2026-04-03/1775203359
id: 1700920
processed: 1

raw_data:

{
    "AmericanExpressClearingAccount": 5,
    "BankAccountClearingAccount": 7,
    "CashClearingAccount": 1,
    "CheckClearingAccount": 2,
    "DiscountsAccount": 8,
    "DiscoverClearingAccount": 6,
    "Id": 0,
    "MarinaLocation_Id": 11,
    "MastercardClearingAccount": 4,
    "OverpaymentAccount": 10,
    "PrepaymentAccount": 9,
    "VisaClearingAccount": 3,
    "WireTransferClearingAccount": 12
}

schema_attributes:

{
    "AmericanExpressClearingAccount": "string",
    "BankAccountClearingAccount": "string",
    "CashClearingAccount": "string",
    "CheckClearingAccount": "string",
    "DiscountsAccount": "string",
    "DiscoverClearingAccount": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MastercardClearingAccount": "string",
    "OverpaymentAccount": "string",
    "PrepaymentAccount": "string",
    "VisaClearingAccount": "string",
    "WireTransferClearingAccount": "string"
}

schema_name_id: 1639
schema_scan_id: 161401874
updated: 2026-04-03 03:09:13

Schema Scans: 15

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

Scan 162167677

duration: 0:00:14.315950

exit_message:

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

id: 162167677

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_moloQuickbookSettingsSet/2026-04-17/1776412814",
        "key": "raw/molo_moloQuickbookSettingsSet/2026-04-17/1776412814/QuickbookSettingsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQuickbookSettingsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18444878777509050601,
        "service_name": "drive-thru",
        "span_id": 16172360255258058451,
        "trace_id": 14003972445700924894
    }
}

running: False
schema_name_id: 1639
start_time: 2026-04-17 03:07:07
success: True
trace_id: 14003972445700924894

Scan 162111881

duration: 0:00:11.993220

exit_message:

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

id: 162111881

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_moloQuickbookSettingsSet/2026-04-16/1776326570",
        "key": "raw/molo_moloQuickbookSettingsSet/2026-04-16/1776326570/QuickbookSettingsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQuickbookSettingsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15612500549139958870,
        "service_name": "drive-thru",
        "span_id": 5389307184075352051,
        "trace_id": 5065895692139555429
    }
}

running: False
schema_name_id: 1639
start_time: 2026-04-16 03:09:29
success: True
trace_id: 5065895692139555429

Scan 162055926

duration: 0:00:11.795020

exit_message:

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

id: 162055926

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_moloQuickbookSettingsSet/2026-04-15/1776240039",
        "key": "raw/molo_moloQuickbookSettingsSet/2026-04-15/1776240039/QuickbookSettingsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQuickbookSettingsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 985153024342431212,
        "service_name": "drive-thru",
        "span_id": 10889223641424263629,
        "trace_id": 2534478902915916291
    }
}

running: False
schema_name_id: 1639
start_time: 2026-04-15 03:05:09
success: True
trace_id: 2534478902915916291

Scan 162000540

duration: 0:00:14.434801

exit_message:

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

id: 162000540

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_moloQuickbookSettingsSet/2026-04-14/1776153769",
        "key": "raw/molo_moloQuickbookSettingsSet/2026-04-14/1776153769/QuickbookSettingsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQuickbookSettingsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1495541231288187901,
        "service_name": "drive-thru",
        "span_id": 2551998144947483546,
        "trace_id": 391843187742074999
    }
}

running: False
schema_name_id: 1639
start_time: 2026-04-14 03:07:23
success: True
trace_id: 391843187742074999

Scan 161941785

duration: 0:00:11.949887

exit_message:

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

id: 161941785

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_moloQuickbookSettingsSet/2026-04-13/1776066963",
        "key": "raw/molo_moloQuickbookSettingsSet/2026-04-13/1776066963/QuickbookSettingsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQuickbookSettingsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 296499352067132853,
        "service_name": "drive-thru",
        "span_id": 8656399058134711364,
        "trace_id": 10877780113068826331
    }
}

running: False
schema_name_id: 1639
start_time: 2026-04-13 02:59:39
success: True
trace_id: 10877780113068826331

Scan 161892592

duration: 0:00:14.293787

exit_message:

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

id: 161892592

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_moloQuickbookSettingsSet/2026-04-12/1775980675",
        "key": "raw/molo_moloQuickbookSettingsSet/2026-04-12/1775980675/QuickbookSettingsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQuickbookSettingsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11877908863460035671,
        "service_name": "drive-thru",
        "span_id": 1884157342957025488,
        "trace_id": 6247568766068393907
    }
}

running: False
schema_name_id: 1639
start_time: 2026-04-12 03:00:23
success: True
trace_id: 6247568766068393907

Scan 161841137

duration: 0:00:11.806243

exit_message:

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

id: 161841137

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_moloQuickbookSettingsSet/2026-04-11/1775894436",
        "key": "raw/molo_moloQuickbookSettingsSet/2026-04-11/1775894436/QuickbookSettingsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQuickbookSettingsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2511355753020130307,
        "service_name": "drive-thru",
        "span_id": 7569308059307783769,
        "trace_id": 13109870056013734581
    }
}

running: False
schema_name_id: 1639
start_time: 2026-04-11 03:04:00
success: True
trace_id: 13109870056013734581

Scan 161785938

duration: 0:00:11.874590

exit_message:

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

id: 161785938

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_moloQuickbookSettingsSet/2026-04-10/1775808193",
        "key": "raw/molo_moloQuickbookSettingsSet/2026-04-10/1775808193/QuickbookSettingsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQuickbookSettingsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16394273506036758709,
        "service_name": "drive-thru",
        "span_id": 14614505660063304807,
        "trace_id": 13015811360168874017
    }
}

running: False
schema_name_id: 1639
start_time: 2026-04-10 03:06:21
success: True
trace_id: 13015811360168874017

Scan 161730393

duration: 0:00:14.364995

exit_message:

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

id: 161730393

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_moloQuickbookSettingsSet/2026-04-09/1775721532",
        "key": "raw/molo_moloQuickbookSettingsSet/2026-04-09/1775721532/QuickbookSettingsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQuickbookSettingsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17382919118505541026,
        "service_name": "drive-thru",
        "span_id": 17030983607936781132,
        "trace_id": 7749986561284023166
    }
}

running: False
schema_name_id: 1639
start_time: 2026-04-09 03:05:48
success: True
trace_id: 7749986561284023166

Scan 161675608

duration: 0:00:11.753271

exit_message:

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

id: 161675608

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_moloQuickbookSettingsSet/2026-04-08/1775635360",
        "key": "raw/molo_moloQuickbookSettingsSet/2026-04-08/1775635360/QuickbookSettingsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQuickbookSettingsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5233204047921126126,
        "service_name": "drive-thru",
        "span_id": 15357808093520932144,
        "trace_id": 15205904626713095894
    }
}

running: False
schema_name_id: 1639
start_time: 2026-04-08 03:07:56
success: True
trace_id: 15205904626713095894

Scan 161618434

duration: 0:00:14.372525

exit_message:

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

id: 161618434

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_moloQuickbookSettingsSet/2026-04-07/1775548510",
        "key": "raw/molo_moloQuickbookSettingsSet/2026-04-07/1775548510/QuickbookSettingsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQuickbookSettingsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10375735371430661660,
        "service_name": "drive-thru",
        "span_id": 14520863316394236377,
        "trace_id": 2487785968016935127
    }
}

running: False
schema_name_id: 1639
start_time: 2026-04-07 02:57:43
success: True
trace_id: 2487785968016935127

Scan 161561616

duration: 0:00:14.481505

exit_message:

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

id: 161561616

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_moloQuickbookSettingsSet/2026-04-06/1775462477",
        "key": "raw/molo_moloQuickbookSettingsSet/2026-04-06/1775462477/QuickbookSettingsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQuickbookSettingsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12720867573958706696,
        "service_name": "drive-thru",
        "span_id": 3395171868953775328,
        "trace_id": 16386686050366397270
    }
}

running: False
schema_name_id: 1639
start_time: 2026-04-06 03:06:55
success: True
trace_id: 16386686050366397270

Scan 161514851

duration: 0:00:14.447560

exit_message:

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

id: 161514851

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_moloQuickbookSettingsSet/2026-04-05/1775376103",
        "key": "raw/molo_moloQuickbookSettingsSet/2026-04-05/1775376103/QuickbookSettingsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQuickbookSettingsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1945459742260095642,
        "service_name": "drive-thru",
        "span_id": 17146926525880117499,
        "trace_id": 12429517146978180878
    }
}

running: False
schema_name_id: 1639
start_time: 2026-04-05 03:04:00
success: True
trace_id: 12429517146978180878

Scan 161460358

duration: 0:00:11.899983

exit_message:

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

id: 161460358

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_moloQuickbookSettingsSet/2026-04-04/1775289586",
        "key": "raw/molo_moloQuickbookSettingsSet/2026-04-04/1775289586/QuickbookSettingsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQuickbookSettingsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15391234877614452145,
        "service_name": "drive-thru",
        "span_id": 1714515591349615736,
        "trace_id": 5415370876641592411
    }
}

running: False
schema_name_id: 1639
start_time: 2026-04-04 03:05:18
success: True
trace_id: 5415370876641592411

Scan 161401874

duration: 0:00:11.955164

exit_message:

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

id: 161401874

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_moloQuickbookSettingsSet/2026-04-03/1775203359",
        "key": "raw/molo_moloQuickbookSettingsSet/2026-04-03/1775203359/QuickbookSettingsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQuickbookSettingsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2537061136896138233,
        "service_name": "drive-thru",
        "span_id": 17441611610179398244,
        "trace_id": 13094086327684881583
    }
}

running: False
schema_name_id: 1639
start_time: 2026-04-03 03:09:01
success: True
trace_id: 13094086327684881583

Partitions:

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

Schema:

attributes:

{
    "AmericanExpressClearingAccount": "string",
    "BankAccountClearingAccount": "string",
    "CashClearingAccount": "string",
    "CheckClearingAccount": "string",
    "DiscountsAccount": "string",
    "DiscoverClearingAccount": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MastercardClearingAccount": "string",
    "OverpaymentAccount": "string",
    "PrepaymentAccount": "string",
    "VisaClearingAccount": "string",
    "WireTransferClearingAccount": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloquickbooksettingsset`\n(\n `Id`  string , `CashClearingAccount`  string , `CheckClearingAccount`  string , `VisaClearingAccount`  string , `MastercardClearingAccount`  string , `AmericanExpressClearingAccount`  string , `DiscoverClearingAccount`  string , `BankAccountClearingAccount`  string , `DiscountsAccount`  string , `PrepaymentAccount`  string , `OverpaymentAccount`  string , `MarinaLocation_Id`  string , `WireTransferClearingAccount`  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_moloQuickbookSettingsSet/2026-04-17/1776412814'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloquickbooksettingsset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloquickbooksettingsset"
}

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:56:42",
        "disabled": false,
        "format": "raw",
        "id": 1639,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_moloquickbooksettingsset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "AmericanExpressClearingAccount": "string",
            "BankAccountClearingAccount": "string",
            "CashClearingAccount": "string",
            "CheckClearingAccount": "string",
            "DiscountsAccount": "string",
            "DiscoverClearingAccount": "string",
            "Id": "string",
            "MarinaLocation_Id": "string",
            "MastercardClearingAccount": "string",
            "OverpaymentAccount": "string",
            "PrepaymentAccount": "string",
            "VisaClearingAccount": "string",
            "WireTransferClearingAccount": "string"
        },
        "created": "2026-04-17 03:07:08",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloquickbooksettingsset`\n(\n `Id`  string , `CashClearingAccount`  string , `CheckClearingAccount`  string , `VisaClearingAccount`  string , `MastercardClearingAccount`  string , `AmericanExpressClearingAccount`  string , `DiscoverClearingAccount`  string , `BankAccountClearingAccount`  string , `DiscountsAccount`  string , `PrepaymentAccount`  string , `OverpaymentAccount`  string , `MarinaLocation_Id`  string , `WireTransferClearingAccount`  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_moloQuickbookSettingsSet/2026-04-17/1776412814'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloquickbooksettingsset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloquickbooksettingsset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}