Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloqb_accountset

created: 2023-10-17 02:00:21
disabled: False
format: raw
id: 1743
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717635

created: 2026-04-17 03:04:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_accountset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_accountset`\n(\n `Id`  string , `Name`  string , `SubAccount`  string , `FullyQualifiedName`  string , `Active`  string , `Classification`  string , `AccountType`  string , `AccountSubType`  string , `CurrentBalance`  string , `CurrentBalanceWithSubAccounts`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `time`  string , `QBAccountCurrencyRef_QBAccount_Id`  string , `MarinaLocation_Id`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `Currency`  string , `QBOCreationDateTime`  string , `QBOLastUpdatedDateTime`  string , `AccountNumber`  string , `CreationDateTime`  string , `CreationAspNetUserId`  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_moloQB_AccountSet/2026-04-17/1776412812'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_accountset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_AccountSet/2026-04-17/1776412812
id: 1717635
processed: 1

raw_data:

{
    "AccountNumber": 22,
    "AccountSubType": 7,
    "AccountType": 6,
    "Active": 4,
    "Classification": 5,
    "CreationAspNetUserId": 24,
    "CreationDateTime": 23,
    "Currency": 19,
    "CurrentBalance": 8,
    "CurrentBalanceWithSubAccounts": 9,
    "DeletionDateTime": 18,
    "FullyQualifiedName": 3,
    "Id": 0,
    "MarinaLocation_Id": 16,
    "Name": 1,
    "QBAccountCurrencyRef_QBAccount_Id": 15,
    "QBOCreationDateTime": 20,
    "QBOLastUpdatedDateTime": 21,
    "QB_ID": 12,
    "RecordStatusId": 17,
    "SubAccount": 2,
    "SyncToken": 13,
    "domain": 10,
    "sparse": 11,
    "time": 14
}

schema_attributes:

{
    "AccountNumber": "string",
    "AccountSubType": "string",
    "AccountType": "string",
    "Active": "string",
    "Classification": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "Currency": "string",
    "CurrentBalance": "string",
    "CurrentBalanceWithSubAccounts": "string",
    "DeletionDateTime": "string",
    "FullyQualifiedName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "QBAccountCurrencyRef_QBAccount_Id": "string",
    "QBOCreationDateTime": "string",
    "QBOLastUpdatedDateTime": "string",
    "QB_ID": "string",
    "RecordStatusId": "string",
    "SubAccount": "string",
    "SyncToken": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

schema_name_id: 1743
schema_scan_id: 162167569
updated: 2026-04-17 03:04:37

Version 1716488

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_accountset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_accountset`\n(\n `Id`  string , `Name`  string , `SubAccount`  string , `FullyQualifiedName`  string , `Active`  string , `Classification`  string , `AccountType`  string , `AccountSubType`  string , `CurrentBalance`  string , `CurrentBalanceWithSubAccounts`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `time`  string , `QBAccountCurrencyRef_QBAccount_Id`  string , `MarinaLocation_Id`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `Currency`  string , `QBOCreationDateTime`  string , `QBOLastUpdatedDateTime`  string , `AccountNumber`  string , `CreationDateTime`  string , `CreationAspNetUserId`  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_moloQB_AccountSet/2026-04-16/1776326568'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_accountset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_AccountSet/2026-04-16/1776326568
id: 1716488
processed: 1

raw_data:

{
    "AccountNumber": 22,
    "AccountSubType": 7,
    "AccountType": 6,
    "Active": 4,
    "Classification": 5,
    "CreationAspNetUserId": 24,
    "CreationDateTime": 23,
    "Currency": 19,
    "CurrentBalance": 8,
    "CurrentBalanceWithSubAccounts": 9,
    "DeletionDateTime": 18,
    "FullyQualifiedName": 3,
    "Id": 0,
    "MarinaLocation_Id": 16,
    "Name": 1,
    "QBAccountCurrencyRef_QBAccount_Id": 15,
    "QBOCreationDateTime": 20,
    "QBOLastUpdatedDateTime": 21,
    "QB_ID": 12,
    "RecordStatusId": 17,
    "SubAccount": 2,
    "SyncToken": 13,
    "domain": 10,
    "sparse": 11,
    "time": 14
}

schema_attributes:

{
    "AccountNumber": "string",
    "AccountSubType": "string",
    "AccountType": "string",
    "Active": "string",
    "Classification": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "Currency": "string",
    "CurrentBalance": "string",
    "CurrentBalanceWithSubAccounts": "string",
    "DeletionDateTime": "string",
    "FullyQualifiedName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "QBAccountCurrencyRef_QBAccount_Id": "string",
    "QBOCreationDateTime": "string",
    "QBOLastUpdatedDateTime": "string",
    "QB_ID": "string",
    "RecordStatusId": "string",
    "SubAccount": "string",
    "SyncToken": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

schema_name_id: 1743
schema_scan_id: 162111930
updated: 2026-04-16 03:11:18

Version 1715223

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_accountset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_accountset`\n(\n `Id`  string , `Name`  string , `SubAccount`  string , `FullyQualifiedName`  string , `Active`  string , `Classification`  string , `AccountType`  string , `AccountSubType`  string , `CurrentBalance`  string , `CurrentBalanceWithSubAccounts`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `time`  string , `QBAccountCurrencyRef_QBAccount_Id`  string , `MarinaLocation_Id`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `Currency`  string , `QBOCreationDateTime`  string , `QBOLastUpdatedDateTime`  string , `AccountNumber`  string , `CreationDateTime`  string , `CreationAspNetUserId`  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_moloQB_AccountSet/2026-04-15/1776240038'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_accountset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_AccountSet/2026-04-15/1776240038
id: 1715223
processed: 1

raw_data:

{
    "AccountNumber": 22,
    "AccountSubType": 7,
    "AccountType": 6,
    "Active": 4,
    "Classification": 5,
    "CreationAspNetUserId": 24,
    "CreationDateTime": 23,
    "Currency": 19,
    "CurrentBalance": 8,
    "CurrentBalanceWithSubAccounts": 9,
    "DeletionDateTime": 18,
    "FullyQualifiedName": 3,
    "Id": 0,
    "MarinaLocation_Id": 16,
    "Name": 1,
    "QBAccountCurrencyRef_QBAccount_Id": 15,
    "QBOCreationDateTime": 20,
    "QBOLastUpdatedDateTime": 21,
    "QB_ID": 12,
    "RecordStatusId": 17,
    "SubAccount": 2,
    "SyncToken": 13,
    "domain": 10,
    "sparse": 11,
    "time": 14
}

schema_attributes:

{
    "AccountNumber": "string",
    "AccountSubType": "string",
    "AccountType": "string",
    "Active": "string",
    "Classification": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "Currency": "string",
    "CurrentBalance": "string",
    "CurrentBalanceWithSubAccounts": "string",
    "DeletionDateTime": "string",
    "FullyQualifiedName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "QBAccountCurrencyRef_QBAccount_Id": "string",
    "QBOCreationDateTime": "string",
    "QBOLastUpdatedDateTime": "string",
    "QB_ID": "string",
    "RecordStatusId": "string",
    "SubAccount": "string",
    "SyncToken": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

schema_name_id: 1743
schema_scan_id: 162055952
updated: 2026-04-15 03:06:00

Version 1714043

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_accountset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_accountset`\n(\n `Id`  string , `Name`  string , `SubAccount`  string , `FullyQualifiedName`  string , `Active`  string , `Classification`  string , `AccountType`  string , `AccountSubType`  string , `CurrentBalance`  string , `CurrentBalanceWithSubAccounts`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `time`  string , `QBAccountCurrencyRef_QBAccount_Id`  string , `MarinaLocation_Id`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `Currency`  string , `QBOCreationDateTime`  string , `QBOLastUpdatedDateTime`  string , `AccountNumber`  string , `CreationDateTime`  string , `CreationAspNetUserId`  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_moloQB_AccountSet/2026-04-14/1776153767'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_accountset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_AccountSet/2026-04-14/1776153767
id: 1714043
processed: 1

raw_data:

{
    "AccountNumber": 22,
    "AccountSubType": 7,
    "AccountType": 6,
    "Active": 4,
    "Classification": 5,
    "CreationAspNetUserId": 24,
    "CreationDateTime": 23,
    "Currency": 19,
    "CurrentBalance": 8,
    "CurrentBalanceWithSubAccounts": 9,
    "DeletionDateTime": 18,
    "FullyQualifiedName": 3,
    "Id": 0,
    "MarinaLocation_Id": 16,
    "Name": 1,
    "QBAccountCurrencyRef_QBAccount_Id": 15,
    "QBOCreationDateTime": 20,
    "QBOLastUpdatedDateTime": 21,
    "QB_ID": 12,
    "RecordStatusId": 17,
    "SubAccount": 2,
    "SyncToken": 13,
    "domain": 10,
    "sparse": 11,
    "time": 14
}

schema_attributes:

{
    "AccountNumber": "string",
    "AccountSubType": "string",
    "AccountType": "string",
    "Active": "string",
    "Classification": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "Currency": "string",
    "CurrentBalance": "string",
    "CurrentBalanceWithSubAccounts": "string",
    "DeletionDateTime": "string",
    "FullyQualifiedName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "QBAccountCurrencyRef_QBAccount_Id": "string",
    "QBOCreationDateTime": "string",
    "QBOLastUpdatedDateTime": "string",
    "QB_ID": "string",
    "RecordStatusId": "string",
    "SubAccount": "string",
    "SyncToken": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

schema_name_id: 1743
schema_scan_id: 162000529
updated: 2026-04-14 03:07:20

Version 1712798

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_accountset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_accountset`\n(\n `Id`  string , `Name`  string , `SubAccount`  string , `FullyQualifiedName`  string , `Active`  string , `Classification`  string , `AccountType`  string , `AccountSubType`  string , `CurrentBalance`  string , `CurrentBalanceWithSubAccounts`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `time`  string , `QBAccountCurrencyRef_QBAccount_Id`  string , `MarinaLocation_Id`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `Currency`  string , `QBOCreationDateTime`  string , `QBOLastUpdatedDateTime`  string , `AccountNumber`  string , `CreationDateTime`  string , `CreationAspNetUserId`  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_moloQB_AccountSet/2026-04-13/1776066961'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_accountset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_AccountSet/2026-04-13/1776066961
id: 1712798
processed: 1

raw_data:

{
    "AccountNumber": 22,
    "AccountSubType": 7,
    "AccountType": 6,
    "Active": 4,
    "Classification": 5,
    "CreationAspNetUserId": 24,
    "CreationDateTime": 23,
    "Currency": 19,
    "CurrentBalance": 8,
    "CurrentBalanceWithSubAccounts": 9,
    "DeletionDateTime": 18,
    "FullyQualifiedName": 3,
    "Id": 0,
    "MarinaLocation_Id": 16,
    "Name": 1,
    "QBAccountCurrencyRef_QBAccount_Id": 15,
    "QBOCreationDateTime": 20,
    "QBOLastUpdatedDateTime": 21,
    "QB_ID": 12,
    "RecordStatusId": 17,
    "SubAccount": 2,
    "SyncToken": 13,
    "domain": 10,
    "sparse": 11,
    "time": 14
}

schema_attributes:

{
    "AccountNumber": "string",
    "AccountSubType": "string",
    "AccountType": "string",
    "Active": "string",
    "Classification": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "Currency": "string",
    "CurrentBalance": "string",
    "CurrentBalanceWithSubAccounts": "string",
    "DeletionDateTime": "string",
    "FullyQualifiedName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "QBAccountCurrencyRef_QBAccount_Id": "string",
    "QBOCreationDateTime": "string",
    "QBOLastUpdatedDateTime": "string",
    "QB_ID": "string",
    "RecordStatusId": "string",
    "SubAccount": "string",
    "SyncToken": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

schema_name_id: 1743
schema_scan_id: 161941742
updated: 2026-04-13 02:59:28

Version 1711608

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_accountset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_accountset`\n(\n `Id`  string , `Name`  string , `SubAccount`  string , `FullyQualifiedName`  string , `Active`  string , `Classification`  string , `AccountType`  string , `AccountSubType`  string , `CurrentBalance`  string , `CurrentBalanceWithSubAccounts`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `time`  string , `QBAccountCurrencyRef_QBAccount_Id`  string , `MarinaLocation_Id`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `Currency`  string , `QBOCreationDateTime`  string , `QBOLastUpdatedDateTime`  string , `AccountNumber`  string , `CreationDateTime`  string , `CreationAspNetUserId`  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_moloQB_AccountSet/2026-04-12/1775980674'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_accountset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_AccountSet/2026-04-12/1775980674
id: 1711608
processed: 1

raw_data:

{
    "AccountNumber": 22,
    "AccountSubType": 7,
    "AccountType": 6,
    "Active": 4,
    "Classification": 5,
    "CreationAspNetUserId": 24,
    "CreationDateTime": 23,
    "Currency": 19,
    "CurrentBalance": 8,
    "CurrentBalanceWithSubAccounts": 9,
    "DeletionDateTime": 18,
    "FullyQualifiedName": 3,
    "Id": 0,
    "MarinaLocation_Id": 16,
    "Name": 1,
    "QBAccountCurrencyRef_QBAccount_Id": 15,
    "QBOCreationDateTime": 20,
    "QBOLastUpdatedDateTime": 21,
    "QB_ID": 12,
    "RecordStatusId": 17,
    "SubAccount": 2,
    "SyncToken": 13,
    "domain": 10,
    "sparse": 11,
    "time": 14
}

schema_attributes:

{
    "AccountNumber": "string",
    "AccountSubType": "string",
    "AccountType": "string",
    "Active": "string",
    "Classification": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "Currency": "string",
    "CurrentBalance": "string",
    "CurrentBalanceWithSubAccounts": "string",
    "DeletionDateTime": "string",
    "FullyQualifiedName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "QBAccountCurrencyRef_QBAccount_Id": "string",
    "QBOCreationDateTime": "string",
    "QBOLastUpdatedDateTime": "string",
    "QB_ID": "string",
    "RecordStatusId": "string",
    "SubAccount": "string",
    "SyncToken": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

schema_name_id: 1743
schema_scan_id: 161892725
updated: 2026-04-12 03:01:31

Version 1710512

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_accountset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_accountset`\n(\n `Id`  string , `Name`  string , `SubAccount`  string , `FullyQualifiedName`  string , `Active`  string , `Classification`  string , `AccountType`  string , `AccountSubType`  string , `CurrentBalance`  string , `CurrentBalanceWithSubAccounts`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `time`  string , `QBAccountCurrencyRef_QBAccount_Id`  string , `MarinaLocation_Id`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `Currency`  string , `QBOCreationDateTime`  string , `QBOLastUpdatedDateTime`  string , `AccountNumber`  string , `CreationDateTime`  string , `CreationAspNetUserId`  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_moloQB_AccountSet/2026-04-11/1775894434'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_accountset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_AccountSet/2026-04-11/1775894434
id: 1710512
processed: 1

raw_data:

{
    "AccountNumber": 22,
    "AccountSubType": 7,
    "AccountType": 6,
    "Active": 4,
    "Classification": 5,
    "CreationAspNetUserId": 24,
    "CreationDateTime": 23,
    "Currency": 19,
    "CurrentBalance": 8,
    "CurrentBalanceWithSubAccounts": 9,
    "DeletionDateTime": 18,
    "FullyQualifiedName": 3,
    "Id": 0,
    "MarinaLocation_Id": 16,
    "Name": 1,
    "QBAccountCurrencyRef_QBAccount_Id": 15,
    "QBOCreationDateTime": 20,
    "QBOLastUpdatedDateTime": 21,
    "QB_ID": 12,
    "RecordStatusId": 17,
    "SubAccount": 2,
    "SyncToken": 13,
    "domain": 10,
    "sparse": 11,
    "time": 14
}

schema_attributes:

{
    "AccountNumber": "string",
    "AccountSubType": "string",
    "AccountType": "string",
    "Active": "string",
    "Classification": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "Currency": "string",
    "CurrentBalance": "string",
    "CurrentBalanceWithSubAccounts": "string",
    "DeletionDateTime": "string",
    "FullyQualifiedName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "QBAccountCurrencyRef_QBAccount_Id": "string",
    "QBOCreationDateTime": "string",
    "QBOLastUpdatedDateTime": "string",
    "QB_ID": "string",
    "RecordStatusId": "string",
    "SubAccount": "string",
    "SyncToken": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

schema_name_id: 1743
schema_scan_id: 161841301
updated: 2026-04-11 03:09:01

Version 1709198

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_accountset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_accountset`\n(\n `Id`  string , `Name`  string , `SubAccount`  string , `FullyQualifiedName`  string , `Active`  string , `Classification`  string , `AccountType`  string , `AccountSubType`  string , `CurrentBalance`  string , `CurrentBalanceWithSubAccounts`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `time`  string , `QBAccountCurrencyRef_QBAccount_Id`  string , `MarinaLocation_Id`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `Currency`  string , `QBOCreationDateTime`  string , `QBOLastUpdatedDateTime`  string , `AccountNumber`  string , `CreationDateTime`  string , `CreationAspNetUserId`  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_moloQB_AccountSet/2026-04-10/1775808192'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_accountset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_AccountSet/2026-04-10/1775808192
id: 1709198
processed: 1

raw_data:

{
    "AccountNumber": 22,
    "AccountSubType": 7,
    "AccountType": 6,
    "Active": 4,
    "Classification": 5,
    "CreationAspNetUserId": 24,
    "CreationDateTime": 23,
    "Currency": 19,
    "CurrentBalance": 8,
    "CurrentBalanceWithSubAccounts": 9,
    "DeletionDateTime": 18,
    "FullyQualifiedName": 3,
    "Id": 0,
    "MarinaLocation_Id": 16,
    "Name": 1,
    "QBAccountCurrencyRef_QBAccount_Id": 15,
    "QBOCreationDateTime": 20,
    "QBOLastUpdatedDateTime": 21,
    "QB_ID": 12,
    "RecordStatusId": 17,
    "SubAccount": 2,
    "SyncToken": 13,
    "domain": 10,
    "sparse": 11,
    "time": 14
}

schema_attributes:

{
    "AccountNumber": "string",
    "AccountSubType": "string",
    "AccountType": "string",
    "Active": "string",
    "Classification": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "Currency": "string",
    "CurrentBalance": "string",
    "CurrentBalanceWithSubAccounts": "string",
    "DeletionDateTime": "string",
    "FullyQualifiedName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "QBAccountCurrencyRef_QBAccount_Id": "string",
    "QBOCreationDateTime": "string",
    "QBOLastUpdatedDateTime": "string",
    "QB_ID": "string",
    "RecordStatusId": "string",
    "SubAccount": "string",
    "SyncToken": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

schema_name_id: 1743
schema_scan_id: 161785879
updated: 2026-04-10 03:04:31

Version 1708105

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_accountset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_accountset`\n(\n `Id`  string , `Name`  string , `SubAccount`  string , `FullyQualifiedName`  string , `Active`  string , `Classification`  string , `AccountType`  string , `AccountSubType`  string , `CurrentBalance`  string , `CurrentBalanceWithSubAccounts`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `time`  string , `QBAccountCurrencyRef_QBAccount_Id`  string , `MarinaLocation_Id`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `Currency`  string , `QBOCreationDateTime`  string , `QBOLastUpdatedDateTime`  string , `AccountNumber`  string , `CreationDateTime`  string , `CreationAspNetUserId`  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_moloQB_AccountSet/2026-04-09/1775721530'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_accountset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_AccountSet/2026-04-09/1775721530
id: 1708105
processed: 1

raw_data:

{
    "AccountNumber": 22,
    "AccountSubType": 7,
    "AccountType": 6,
    "Active": 4,
    "Classification": 5,
    "CreationAspNetUserId": 24,
    "CreationDateTime": 23,
    "Currency": 19,
    "CurrentBalance": 8,
    "CurrentBalanceWithSubAccounts": 9,
    "DeletionDateTime": 18,
    "FullyQualifiedName": 3,
    "Id": 0,
    "MarinaLocation_Id": 16,
    "Name": 1,
    "QBAccountCurrencyRef_QBAccount_Id": 15,
    "QBOCreationDateTime": 20,
    "QBOLastUpdatedDateTime": 21,
    "QB_ID": 12,
    "RecordStatusId": 17,
    "SubAccount": 2,
    "SyncToken": 13,
    "domain": 10,
    "sparse": 11,
    "time": 14
}

schema_attributes:

{
    "AccountNumber": "string",
    "AccountSubType": "string",
    "AccountType": "string",
    "Active": "string",
    "Classification": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "Currency": "string",
    "CurrentBalance": "string",
    "CurrentBalanceWithSubAccounts": "string",
    "DeletionDateTime": "string",
    "FullyQualifiedName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "QBAccountCurrencyRef_QBAccount_Id": "string",
    "QBOCreationDateTime": "string",
    "QBOLastUpdatedDateTime": "string",
    "QB_ID": "string",
    "RecordStatusId": "string",
    "SubAccount": "string",
    "SyncToken": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

schema_name_id: 1743
schema_scan_id: 161730193
updated: 2026-04-09 03:02:51

Version 1706997

created: 2026-04-08 03:09:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_accountset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_accountset`\n(\n `Id`  string , `Name`  string , `SubAccount`  string , `FullyQualifiedName`  string , `Active`  string , `Classification`  string , `AccountType`  string , `AccountSubType`  string , `CurrentBalance`  string , `CurrentBalanceWithSubAccounts`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `time`  string , `QBAccountCurrencyRef_QBAccount_Id`  string , `MarinaLocation_Id`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `Currency`  string , `QBOCreationDateTime`  string , `QBOLastUpdatedDateTime`  string , `AccountNumber`  string , `CreationDateTime`  string , `CreationAspNetUserId`  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_moloQB_AccountSet/2026-04-08/1775635359'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_accountset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_AccountSet/2026-04-08/1775635359
id: 1706997
processed: 1

raw_data:

{
    "AccountNumber": 22,
    "AccountSubType": 7,
    "AccountType": 6,
    "Active": 4,
    "Classification": 5,
    "CreationAspNetUserId": 24,
    "CreationDateTime": 23,
    "Currency": 19,
    "CurrentBalance": 8,
    "CurrentBalanceWithSubAccounts": 9,
    "DeletionDateTime": 18,
    "FullyQualifiedName": 3,
    "Id": 0,
    "MarinaLocation_Id": 16,
    "Name": 1,
    "QBAccountCurrencyRef_QBAccount_Id": 15,
    "QBOCreationDateTime": 20,
    "QBOLastUpdatedDateTime": 21,
    "QB_ID": 12,
    "RecordStatusId": 17,
    "SubAccount": 2,
    "SyncToken": 13,
    "domain": 10,
    "sparse": 11,
    "time": 14
}

schema_attributes:

{
    "AccountNumber": "string",
    "AccountSubType": "string",
    "AccountType": "string",
    "Active": "string",
    "Classification": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "Currency": "string",
    "CurrentBalance": "string",
    "CurrentBalanceWithSubAccounts": "string",
    "DeletionDateTime": "string",
    "FullyQualifiedName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "QBAccountCurrencyRef_QBAccount_Id": "string",
    "QBOCreationDateTime": "string",
    "QBOLastUpdatedDateTime": "string",
    "QB_ID": "string",
    "RecordStatusId": "string",
    "SubAccount": "string",
    "SyncToken": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

schema_name_id: 1743
schema_scan_id: 161675654
updated: 2026-04-08 03:09:31

Version 1705744

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_accountset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_accountset`\n(\n `Id`  string , `Name`  string , `SubAccount`  string , `FullyQualifiedName`  string , `Active`  string , `Classification`  string , `AccountType`  string , `AccountSubType`  string , `CurrentBalance`  string , `CurrentBalanceWithSubAccounts`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `time`  string , `QBAccountCurrencyRef_QBAccount_Id`  string , `MarinaLocation_Id`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `Currency`  string , `QBOCreationDateTime`  string , `QBOLastUpdatedDateTime`  string , `AccountNumber`  string , `CreationDateTime`  string , `CreationAspNetUserId`  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_moloQB_AccountSet/2026-04-07/1775548508'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_accountset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_AccountSet/2026-04-07/1775548508
id: 1705744
processed: 1

raw_data:

{
    "AccountNumber": 22,
    "AccountSubType": 7,
    "AccountType": 6,
    "Active": 4,
    "Classification": 5,
    "CreationAspNetUserId": 24,
    "CreationDateTime": 23,
    "Currency": 19,
    "CurrentBalance": 8,
    "CurrentBalanceWithSubAccounts": 9,
    "DeletionDateTime": 18,
    "FullyQualifiedName": 3,
    "Id": 0,
    "MarinaLocation_Id": 16,
    "Name": 1,
    "QBAccountCurrencyRef_QBAccount_Id": 15,
    "QBOCreationDateTime": 20,
    "QBOLastUpdatedDateTime": 21,
    "QB_ID": 12,
    "RecordStatusId": 17,
    "SubAccount": 2,
    "SyncToken": 13,
    "domain": 10,
    "sparse": 11,
    "time": 14
}

schema_attributes:

{
    "AccountNumber": "string",
    "AccountSubType": "string",
    "AccountType": "string",
    "Active": "string",
    "Classification": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "Currency": "string",
    "CurrentBalance": "string",
    "CurrentBalanceWithSubAccounts": "string",
    "DeletionDateTime": "string",
    "FullyQualifiedName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "QBAccountCurrencyRef_QBAccount_Id": "string",
    "QBOCreationDateTime": "string",
    "QBOLastUpdatedDateTime": "string",
    "QB_ID": "string",
    "RecordStatusId": "string",
    "SubAccount": "string",
    "SyncToken": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

schema_name_id: 1743
schema_scan_id: 161618498
updated: 2026-04-07 02:58:51

Version 1704517

created: 2026-04-06 03:06:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_accountset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_accountset`\n(\n `Id`  string , `Name`  string , `SubAccount`  string , `FullyQualifiedName`  string , `Active`  string , `Classification`  string , `AccountType`  string , `AccountSubType`  string , `CurrentBalance`  string , `CurrentBalanceWithSubAccounts`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `time`  string , `QBAccountCurrencyRef_QBAccount_Id`  string , `MarinaLocation_Id`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `Currency`  string , `QBOCreationDateTime`  string , `QBOLastUpdatedDateTime`  string , `AccountNumber`  string , `CreationDateTime`  string , `CreationAspNetUserId`  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_moloQB_AccountSet/2026-04-06/1775462476'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_accountset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_AccountSet/2026-04-06/1775462476
id: 1704517
processed: 1

raw_data:

{
    "AccountNumber": 22,
    "AccountSubType": 7,
    "AccountType": 6,
    "Active": 4,
    "Classification": 5,
    "CreationAspNetUserId": 24,
    "CreationDateTime": 23,
    "Currency": 19,
    "CurrentBalance": 8,
    "CurrentBalanceWithSubAccounts": 9,
    "DeletionDateTime": 18,
    "FullyQualifiedName": 3,
    "Id": 0,
    "MarinaLocation_Id": 16,
    "Name": 1,
    "QBAccountCurrencyRef_QBAccount_Id": 15,
    "QBOCreationDateTime": 20,
    "QBOLastUpdatedDateTime": 21,
    "QB_ID": 12,
    "RecordStatusId": 17,
    "SubAccount": 2,
    "SyncToken": 13,
    "domain": 10,
    "sparse": 11,
    "time": 14
}

schema_attributes:

{
    "AccountNumber": "string",
    "AccountSubType": "string",
    "AccountType": "string",
    "Active": "string",
    "Classification": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "Currency": "string",
    "CurrentBalance": "string",
    "CurrentBalanceWithSubAccounts": "string",
    "DeletionDateTime": "string",
    "FullyQualifiedName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "QBAccountCurrencyRef_QBAccount_Id": "string",
    "QBOCreationDateTime": "string",
    "QBOLastUpdatedDateTime": "string",
    "QB_ID": "string",
    "RecordStatusId": "string",
    "SubAccount": "string",
    "SyncToken": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

schema_name_id: 1743
schema_scan_id: 161561612
updated: 2026-04-06 03:07:00

Version 1703264

created: 2026-04-05 03:03:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_accountset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_accountset`\n(\n `Id`  string , `Name`  string , `SubAccount`  string , `FullyQualifiedName`  string , `Active`  string , `Classification`  string , `AccountType`  string , `AccountSubType`  string , `CurrentBalance`  string , `CurrentBalanceWithSubAccounts`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `time`  string , `QBAccountCurrencyRef_QBAccount_Id`  string , `MarinaLocation_Id`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `Currency`  string , `QBOCreationDateTime`  string , `QBOLastUpdatedDateTime`  string , `AccountNumber`  string , `CreationDateTime`  string , `CreationAspNetUserId`  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_moloQB_AccountSet/2026-04-05/1775376102'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_accountset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_AccountSet/2026-04-05/1775376102
id: 1703264
processed: 1

raw_data:

{
    "AccountNumber": 22,
    "AccountSubType": 7,
    "AccountType": 6,
    "Active": 4,
    "Classification": 5,
    "CreationAspNetUserId": 24,
    "CreationDateTime": 23,
    "Currency": 19,
    "CurrentBalance": 8,
    "CurrentBalanceWithSubAccounts": 9,
    "DeletionDateTime": 18,
    "FullyQualifiedName": 3,
    "Id": 0,
    "MarinaLocation_Id": 16,
    "Name": 1,
    "QBAccountCurrencyRef_QBAccount_Id": 15,
    "QBOCreationDateTime": 20,
    "QBOLastUpdatedDateTime": 21,
    "QB_ID": 12,
    "RecordStatusId": 17,
    "SubAccount": 2,
    "SyncToken": 13,
    "domain": 10,
    "sparse": 11,
    "time": 14
}

schema_attributes:

{
    "AccountNumber": "string",
    "AccountSubType": "string",
    "AccountType": "string",
    "Active": "string",
    "Classification": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "Currency": "string",
    "CurrentBalance": "string",
    "CurrentBalanceWithSubAccounts": "string",
    "DeletionDateTime": "string",
    "FullyQualifiedName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "QBAccountCurrencyRef_QBAccount_Id": "string",
    "QBOCreationDateTime": "string",
    "QBOLastUpdatedDateTime": "string",
    "QB_ID": "string",
    "RecordStatusId": "string",
    "SubAccount": "string",
    "SyncToken": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

schema_name_id: 1743
schema_scan_id: 161514837
updated: 2026-04-05 03:03:51

Version 1702100

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_accountset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_accountset`\n(\n `Id`  string , `Name`  string , `SubAccount`  string , `FullyQualifiedName`  string , `Active`  string , `Classification`  string , `AccountType`  string , `AccountSubType`  string , `CurrentBalance`  string , `CurrentBalanceWithSubAccounts`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `time`  string , `QBAccountCurrencyRef_QBAccount_Id`  string , `MarinaLocation_Id`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `Currency`  string , `QBOCreationDateTime`  string , `QBOLastUpdatedDateTime`  string , `AccountNumber`  string , `CreationDateTime`  string , `CreationAspNetUserId`  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_moloQB_AccountSet/2026-04-04/1775289584'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_accountset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_AccountSet/2026-04-04/1775289584
id: 1702100
processed: 1

raw_data:

{
    "AccountNumber": 22,
    "AccountSubType": 7,
    "AccountType": 6,
    "Active": 4,
    "Classification": 5,
    "CreationAspNetUserId": 24,
    "CreationDateTime": 23,
    "Currency": 19,
    "CurrentBalance": 8,
    "CurrentBalanceWithSubAccounts": 9,
    "DeletionDateTime": 18,
    "FullyQualifiedName": 3,
    "Id": 0,
    "MarinaLocation_Id": 16,
    "Name": 1,
    "QBAccountCurrencyRef_QBAccount_Id": 15,
    "QBOCreationDateTime": 20,
    "QBOLastUpdatedDateTime": 21,
    "QB_ID": 12,
    "RecordStatusId": 17,
    "SubAccount": 2,
    "SyncToken": 13,
    "domain": 10,
    "sparse": 11,
    "time": 14
}

schema_attributes:

{
    "AccountNumber": "string",
    "AccountSubType": "string",
    "AccountType": "string",
    "Active": "string",
    "Classification": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "Currency": "string",
    "CurrentBalance": "string",
    "CurrentBalanceWithSubAccounts": "string",
    "DeletionDateTime": "string",
    "FullyQualifiedName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "QBAccountCurrencyRef_QBAccount_Id": "string",
    "QBOCreationDateTime": "string",
    "QBOLastUpdatedDateTime": "string",
    "QB_ID": "string",
    "RecordStatusId": "string",
    "SubAccount": "string",
    "SyncToken": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

schema_name_id: 1743
schema_scan_id: 161460180
updated: 2026-04-04 03:03:09

Version 1701070

created: 2026-04-03 03:16:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_accountset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_accountset`\n(\n `Id`  string , `Name`  string , `SubAccount`  string , `FullyQualifiedName`  string , `Active`  string , `Classification`  string , `AccountType`  string , `AccountSubType`  string , `CurrentBalance`  string , `CurrentBalanceWithSubAccounts`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `time`  string , `QBAccountCurrencyRef_QBAccount_Id`  string , `MarinaLocation_Id`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `Currency`  string , `QBOCreationDateTime`  string , `QBOLastUpdatedDateTime`  string , `AccountNumber`  string , `CreationDateTime`  string , `CreationAspNetUserId`  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_moloQB_AccountSet/2026-04-03/1775203357'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_accountset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_AccountSet/2026-04-03/1775203357
id: 1701070
processed: 1

raw_data:

{
    "AccountNumber": 22,
    "AccountSubType": 7,
    "AccountType": 6,
    "Active": 4,
    "Classification": 5,
    "CreationAspNetUserId": 24,
    "CreationDateTime": 23,
    "Currency": 19,
    "CurrentBalance": 8,
    "CurrentBalanceWithSubAccounts": 9,
    "DeletionDateTime": 18,
    "FullyQualifiedName": 3,
    "Id": 0,
    "MarinaLocation_Id": 16,
    "Name": 1,
    "QBAccountCurrencyRef_QBAccount_Id": 15,
    "QBOCreationDateTime": 20,
    "QBOLastUpdatedDateTime": 21,
    "QB_ID": 12,
    "RecordStatusId": 17,
    "SubAccount": 2,
    "SyncToken": 13,
    "domain": 10,
    "sparse": 11,
    "time": 14
}

schema_attributes:

{
    "AccountNumber": "string",
    "AccountSubType": "string",
    "AccountType": "string",
    "Active": "string",
    "Classification": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "Currency": "string",
    "CurrentBalance": "string",
    "CurrentBalanceWithSubAccounts": "string",
    "DeletionDateTime": "string",
    "FullyQualifiedName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "QBAccountCurrencyRef_QBAccount_Id": "string",
    "QBOCreationDateTime": "string",
    "QBOLastUpdatedDateTime": "string",
    "QB_ID": "string",
    "RecordStatusId": "string",
    "SubAccount": "string",
    "SyncToken": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

schema_name_id: 1743
schema_scan_id: 161402064
updated: 2026-04-03 03:16:24

Schema Scans: 15

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

Scan 162167569

duration: 0:00:15.029753

exit_message:

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

id: 162167569

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_moloQB_AccountSet/2026-04-17/1776412812",
        "key": "raw/molo_moloQB_AccountSet/2026-04-17/1776412812/QB_AccountSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQB_AccountSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7567313216709171552,
        "service_name": "drive-thru",
        "span_id": 17706813512905710280,
        "trace_id": 16637289224971645356
    }
}

running: False
schema_name_id: 1743
start_time: 2026-04-17 03:04:22
success: True
trace_id: 16637289224971645356

Scan 162111930

duration: 0:00:12.392006

exit_message:

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

id: 162111930

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_moloQB_AccountSet/2026-04-16/1776326568",
        "key": "raw/molo_moloQB_AccountSet/2026-04-16/1776326568/QB_AccountSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQB_AccountSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15140175263346845252,
        "service_name": "drive-thru",
        "span_id": 7228576657245761190,
        "trace_id": 9126670217126076156
    }
}

running: False
schema_name_id: 1743
start_time: 2026-04-16 03:11:06
success: True
trace_id: 9126670217126076156

Scan 162055952

duration: 0:00:14.802079

exit_message:

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

id: 162055952

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_moloQB_AccountSet/2026-04-15/1776240038",
        "key": "raw/molo_moloQB_AccountSet/2026-04-15/1776240038/QB_AccountSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQB_AccountSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1029519056133211610,
        "service_name": "drive-thru",
        "span_id": 7942101985256026805,
        "trace_id": 9818993882124489086
    }
}

running: False
schema_name_id: 1743
start_time: 2026-04-15 03:05:46
success: True
trace_id: 9818993882124489086

Scan 162000529

duration: 0:00:14.777539

exit_message:

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

id: 162000529

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_moloQB_AccountSet/2026-04-14/1776153767",
        "key": "raw/molo_moloQB_AccountSet/2026-04-14/1776153767/QB_AccountSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQB_AccountSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2749628652160999184,
        "service_name": "drive-thru",
        "span_id": 11612343842382703905,
        "trace_id": 17303031284047784323
    }
}

running: False
schema_name_id: 1743
start_time: 2026-04-14 03:07:05
success: True
trace_id: 17303031284047784323

Scan 161941742

duration: 0:00:14.706747

exit_message:

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

id: 161941742

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_moloQB_AccountSet/2026-04-13/1776066961",
        "key": "raw/molo_moloQB_AccountSet/2026-04-13/1776066961/QB_AccountSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQB_AccountSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10360281837510986772,
        "service_name": "drive-thru",
        "span_id": 14664258385826362899,
        "trace_id": 4148761451807811225
    }
}

running: False
schema_name_id: 1743
start_time: 2026-04-13 02:59:14
success: True
trace_id: 4148761451807811225

Scan 161892725

duration: 0:00:14.810271

exit_message:

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

id: 161892725

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_moloQB_AccountSet/2026-04-12/1775980674",
        "key": "raw/molo_moloQB_AccountSet/2026-04-12/1775980674/QB_AccountSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQB_AccountSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3891628513967083095,
        "service_name": "drive-thru",
        "span_id": 6103589878007113719,
        "trace_id": 9461010473430460471
    }
}

running: False
schema_name_id: 1743
start_time: 2026-04-12 03:01:17
success: True
trace_id: 9461010473430460471

Scan 161841301

duration: 0:00:12.419373

exit_message:

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

id: 161841301

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_moloQB_AccountSet/2026-04-11/1775894434",
        "key": "raw/molo_moloQB_AccountSet/2026-04-11/1775894434/QB_AccountSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQB_AccountSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16870458955304453496,
        "service_name": "drive-thru",
        "span_id": 13224021620125454799,
        "trace_id": 14412949099023065280
    }
}

running: False
schema_name_id: 1743
start_time: 2026-04-11 03:08:49
success: True
trace_id: 14412949099023065280

Scan 161785879

duration: 0:00:14.824814

exit_message:

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

id: 161785879

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_moloQB_AccountSet/2026-04-10/1775808192",
        "key": "raw/molo_moloQB_AccountSet/2026-04-10/1775808192/QB_AccountSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQB_AccountSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16709256899594830428,
        "service_name": "drive-thru",
        "span_id": 15476425210318902833,
        "trace_id": 2641838057314020817
    }
}

running: False
schema_name_id: 1743
start_time: 2026-04-10 03:04:16
success: True
trace_id: 2641838057314020817

Scan 161730193

duration: 0:00:14.805621

exit_message:

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

id: 161730193

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_moloQB_AccountSet/2026-04-09/1775721530",
        "key": "raw/molo_moloQB_AccountSet/2026-04-09/1775721530/QB_AccountSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQB_AccountSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8804606257024526815,
        "service_name": "drive-thru",
        "span_id": 8104065086878718582,
        "trace_id": 17767994998611092998
    }
}

running: False
schema_name_id: 1743
start_time: 2026-04-09 03:02:36
success: True
trace_id: 17767994998611092998

Scan 161675654

duration: 0:00:12.344334

exit_message:

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

id: 161675654

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_moloQB_AccountSet/2026-04-08/1775635359",
        "key": "raw/molo_moloQB_AccountSet/2026-04-08/1775635359/QB_AccountSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQB_AccountSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 94667307249414735,
        "service_name": "drive-thru",
        "span_id": 9215351020208508686,
        "trace_id": 13097232476223366750
    }
}

running: False
schema_name_id: 1743
start_time: 2026-04-08 03:09:19
success: True
trace_id: 13097232476223366750

Scan 161618498

duration: 0:00:14.916285

exit_message:

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

id: 161618498

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_moloQB_AccountSet/2026-04-07/1775548508",
        "key": "raw/molo_moloQB_AccountSet/2026-04-07/1775548508/QB_AccountSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQB_AccountSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2084534001368878726,
        "service_name": "drive-thru",
        "span_id": 13690927710136999575,
        "trace_id": 1975071921683398578
    }
}

running: False
schema_name_id: 1743
start_time: 2026-04-07 02:58:37
success: True
trace_id: 1975071921683398578

Scan 161561612

duration: 0:00:14.773563

exit_message:

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

id: 161561612

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_moloQB_AccountSet/2026-04-06/1775462476",
        "key": "raw/molo_moloQB_AccountSet/2026-04-06/1775462476/QB_AccountSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQB_AccountSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7923945940820195184,
        "service_name": "drive-thru",
        "span_id": 14118849708609008221,
        "trace_id": 5485368034623804034
    }
}

running: False
schema_name_id: 1743
start_time: 2026-04-06 03:06:45
success: True
trace_id: 5485368034623804034

Scan 161514837

duration: 0:00:12.217786

exit_message:

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

id: 161514837

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_moloQB_AccountSet/2026-04-05/1775376102",
        "key": "raw/molo_moloQB_AccountSet/2026-04-05/1775376102/QB_AccountSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQB_AccountSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10646384942065971153,
        "service_name": "drive-thru",
        "span_id": 17470349776797728366,
        "trace_id": 2821999852801507301
    }
}

running: False
schema_name_id: 1743
start_time: 2026-04-05 03:03:39
success: True
trace_id: 2821999852801507301

Scan 161460180

duration: 0:00:12.369116

exit_message:

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

id: 161460180

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_moloQB_AccountSet/2026-04-04/1775289584",
        "key": "raw/molo_moloQB_AccountSet/2026-04-04/1775289584/QB_AccountSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQB_AccountSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 981828119764166468,
        "service_name": "drive-thru",
        "span_id": 8900982531166295141,
        "trace_id": 17611326235511934383
    }
}

running: False
schema_name_id: 1743
start_time: 2026-04-04 03:02:57
success: True
trace_id: 17611326235511934383

Scan 161402064

duration: 0:00:12.376632

exit_message:

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

id: 161402064

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_moloQB_AccountSet/2026-04-03/1775203357",
        "key": "raw/molo_moloQB_AccountSet/2026-04-03/1775203357/QB_AccountSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQB_AccountSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5474576480076793369,
        "service_name": "drive-thru",
        "span_id": 18226019750266065468,
        "trace_id": 7342413745632196812
    }
}

running: False
schema_name_id: 1743
start_time: 2026-04-03 03:16:12
success: True
trace_id: 7342413745632196812

Partitions:

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

Schema:

attributes:

{
    "AccountNumber": "string",
    "AccountSubType": "string",
    "AccountType": "string",
    "Active": "string",
    "Classification": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "Currency": "string",
    "CurrentBalance": "string",
    "CurrentBalanceWithSubAccounts": "string",
    "DeletionDateTime": "string",
    "FullyQualifiedName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "QBAccountCurrencyRef_QBAccount_Id": "string",
    "QBOCreationDateTime": "string",
    "QBOLastUpdatedDateTime": "string",
    "QB_ID": "string",
    "RecordStatusId": "string",
    "SubAccount": "string",
    "SyncToken": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

created: 2026-04-17 03:04:23

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_accountset`\n(\n `Id`  string , `Name`  string , `SubAccount`  string , `FullyQualifiedName`  string , `Active`  string , `Classification`  string , `AccountType`  string , `AccountSubType`  string , `CurrentBalance`  string , `CurrentBalanceWithSubAccounts`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `time`  string , `QBAccountCurrencyRef_QBAccount_Id`  string , `MarinaLocation_Id`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `Currency`  string , `QBOCreationDateTime`  string , `QBOLastUpdatedDateTime`  string , `AccountNumber`  string , `CreationDateTime`  string , `CreationAspNetUserId`  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_moloQB_AccountSet/2026-04-17/1776412812'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_accountset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_accountset"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-10-17 02:00:21",
        "disabled": false,
        "format": "raw",
        "id": 1743,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_moloqb_accountset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "AccountNumber": "string",
            "AccountSubType": "string",
            "AccountType": "string",
            "Active": "string",
            "Classification": "string",
            "CreationAspNetUserId": "string",
            "CreationDateTime": "string",
            "Currency": "string",
            "CurrentBalance": "string",
            "CurrentBalanceWithSubAccounts": "string",
            "DeletionDateTime": "string",
            "FullyQualifiedName": "string",
            "Id": "string",
            "MarinaLocation_Id": "string",
            "Name": "string",
            "QBAccountCurrencyRef_QBAccount_Id": "string",
            "QBOCreationDateTime": "string",
            "QBOLastUpdatedDateTime": "string",
            "QB_ID": "string",
            "RecordStatusId": "string",
            "SubAccount": "string",
            "SyncToken": "string",
            "domain": "string",
            "sparse": "string",
            "time": "string"
        },
        "created": "2026-04-17 03:04:23",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_accountset`\n(\n `Id`  string , `Name`  string , `SubAccount`  string , `FullyQualifiedName`  string , `Active`  string , `Classification`  string , `AccountType`  string , `AccountSubType`  string , `CurrentBalance`  string , `CurrentBalanceWithSubAccounts`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `time`  string , `QBAccountCurrencyRef_QBAccount_Id`  string , `MarinaLocation_Id`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `Currency`  string , `QBOCreationDateTime`  string , `QBOLastUpdatedDateTime`  string , `AccountNumber`  string , `CreationDateTime`  string , `CreationAspNetUserId`  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_moloQB_AccountSet/2026-04-17/1776412812'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_accountset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_accountset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}