Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloxerocreditnoteset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717782

created: 2026-04-17 03:11:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerocreditnoteset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerocreditnoteset`\n(\n `Id`  string , `Date`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `UpdatedDateUTC`  string , `CurrencyCode`  string , `FullyPaidOnDate`  string , `CreditNoteID`  string , `CreditNoteNumber`  string , `SentToContact`  string , `CurrencyRate`  string , `RemainingCredit`  string , `XeroInvoiceId`  string , `XeroCreditNoteType_Id`  string , `XeroContact_Id`  string , `XeroInvoiceStatus_Id`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-17/1776413274'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerocreditnoteset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-17/1776413274
id: 1717782
processed: 1

raw_data:

{
    "CreditNoteID": 8,
    "CreditNoteNumber": 9,
    "CurrencyCode": 6,
    "CurrencyRate": 11,
    "Date": 1,
    "FullyPaidOnDate": 7,
    "Id": 0,
    "MarinaLocation_Id": 17,
    "RemainingCredit": 12,
    "SentToContact": 10,
    "SubTotal": 2,
    "Total": 4,
    "TotalTax": 3,
    "UpdatedDateUTC": 5,
    "XeroContact_Id": 15,
    "XeroCreditNoteType_Id": 14,
    "XeroInvoiceId": 13,
    "XeroInvoiceStatus_Id": 16
}

schema_attributes:

{
    "CreditNoteID": "string",
    "CreditNoteNumber": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "FullyPaidOnDate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RemainingCredit": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalTax": "string",
    "UpdatedDateUTC": "string",
    "XeroContact_Id": "string",
    "XeroCreditNoteType_Id": "string",
    "XeroInvoiceId": "string",
    "XeroInvoiceStatus_Id": "string"
}

schema_name_id: 1769
schema_scan_id: 162167810
updated: 2026-04-17 03:11:13

Version 1716522

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerocreditnoteset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerocreditnoteset`\n(\n `Id`  string , `Date`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `UpdatedDateUTC`  string , `CurrencyCode`  string , `FullyPaidOnDate`  string , `CreditNoteID`  string , `CreditNoteNumber`  string , `SentToContact`  string , `CurrencyRate`  string , `RemainingCredit`  string , `XeroInvoiceId`  string , `XeroCreditNoteType_Id`  string , `XeroContact_Id`  string , `XeroInvoiceStatus_Id`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-16/1776326751'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerocreditnoteset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-16/1776326751
id: 1716522
processed: 1

raw_data:

{
    "CreditNoteID": 8,
    "CreditNoteNumber": 9,
    "CurrencyCode": 6,
    "CurrencyRate": 11,
    "Date": 1,
    "FullyPaidOnDate": 7,
    "Id": 0,
    "MarinaLocation_Id": 17,
    "RemainingCredit": 12,
    "SentToContact": 10,
    "SubTotal": 2,
    "Total": 4,
    "TotalTax": 3,
    "UpdatedDateUTC": 5,
    "XeroContact_Id": 15,
    "XeroCreditNoteType_Id": 14,
    "XeroInvoiceId": 13,
    "XeroInvoiceStatus_Id": 16
}

schema_attributes:

{
    "CreditNoteID": "string",
    "CreditNoteNumber": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "FullyPaidOnDate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RemainingCredit": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalTax": "string",
    "UpdatedDateUTC": "string",
    "XeroContact_Id": "string",
    "XeroCreditNoteType_Id": "string",
    "XeroInvoiceId": "string",
    "XeroInvoiceStatus_Id": "string"
}

schema_name_id: 1769
schema_scan_id: 162111973
updated: 2026-04-16 03:12:44

Version 1715297

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerocreditnoteset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerocreditnoteset`\n(\n `Id`  string , `Date`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `UpdatedDateUTC`  string , `CurrencyCode`  string , `FullyPaidOnDate`  string , `CreditNoteID`  string , `CreditNoteNumber`  string , `SentToContact`  string , `CurrencyRate`  string , `RemainingCredit`  string , `XeroInvoiceId`  string , `XeroCreditNoteType_Id`  string , `XeroContact_Id`  string , `XeroInvoiceStatus_Id`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-15/1776240212'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerocreditnoteset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-15/1776240212
id: 1715297
processed: 1

raw_data:

{
    "CreditNoteID": 8,
    "CreditNoteNumber": 9,
    "CurrencyCode": 6,
    "CurrencyRate": 11,
    "Date": 1,
    "FullyPaidOnDate": 7,
    "Id": 0,
    "MarinaLocation_Id": 17,
    "RemainingCredit": 12,
    "SentToContact": 10,
    "SubTotal": 2,
    "Total": 4,
    "TotalTax": 3,
    "UpdatedDateUTC": 5,
    "XeroContact_Id": 15,
    "XeroCreditNoteType_Id": 14,
    "XeroInvoiceId": 13,
    "XeroInvoiceStatus_Id": 16
}

schema_attributes:

{
    "CreditNoteID": "string",
    "CreditNoteNumber": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "FullyPaidOnDate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RemainingCredit": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalTax": "string",
    "UpdatedDateUTC": "string",
    "XeroContact_Id": "string",
    "XeroCreditNoteType_Id": "string",
    "XeroInvoiceId": "string",
    "XeroInvoiceStatus_Id": "string"
}

schema_name_id: 1769
schema_scan_id: 162056073
updated: 2026-04-15 03:09:08

Version 1714201

created: 2026-04-14 03:13:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerocreditnoteset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerocreditnoteset`\n(\n `Id`  string , `Date`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `UpdatedDateUTC`  string , `CurrencyCode`  string , `FullyPaidOnDate`  string , `CreditNoteID`  string , `CreditNoteNumber`  string , `SentToContact`  string , `CurrencyRate`  string , `RemainingCredit`  string , `XeroInvoiceId`  string , `XeroCreditNoteType_Id`  string , `XeroContact_Id`  string , `XeroInvoiceStatus_Id`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-14/1776154176'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerocreditnoteset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-14/1776154176
id: 1714201
processed: 1

raw_data:

{
    "CreditNoteID": 8,
    "CreditNoteNumber": 9,
    "CurrencyCode": 6,
    "CurrencyRate": 11,
    "Date": 1,
    "FullyPaidOnDate": 7,
    "Id": 0,
    "MarinaLocation_Id": 17,
    "RemainingCredit": 12,
    "SentToContact": 10,
    "SubTotal": 2,
    "Total": 4,
    "TotalTax": 3,
    "UpdatedDateUTC": 5,
    "XeroContact_Id": 15,
    "XeroCreditNoteType_Id": 14,
    "XeroInvoiceId": 13,
    "XeroInvoiceStatus_Id": 16
}

schema_attributes:

{
    "CreditNoteID": "string",
    "CreditNoteNumber": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "FullyPaidOnDate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RemainingCredit": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalTax": "string",
    "UpdatedDateUTC": "string",
    "XeroContact_Id": "string",
    "XeroCreditNoteType_Id": "string",
    "XeroInvoiceId": "string",
    "XeroInvoiceStatus_Id": "string"
}

schema_name_id: 1769
schema_scan_id: 162000725
updated: 2026-04-14 03:13:22

Version 1712938

created: 2026-04-13 03:05:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerocreditnoteset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerocreditnoteset`\n(\n `Id`  string , `Date`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `UpdatedDateUTC`  string , `CurrencyCode`  string , `FullyPaidOnDate`  string , `CreditNoteID`  string , `CreditNoteNumber`  string , `SentToContact`  string , `CurrencyRate`  string , `RemainingCredit`  string , `XeroInvoiceId`  string , `XeroCreditNoteType_Id`  string , `XeroContact_Id`  string , `XeroInvoiceStatus_Id`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-13/1776067169'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerocreditnoteset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-13/1776067169
id: 1712938
processed: 1

raw_data:

{
    "CreditNoteID": 8,
    "CreditNoteNumber": 9,
    "CurrencyCode": 6,
    "CurrencyRate": 11,
    "Date": 1,
    "FullyPaidOnDate": 7,
    "Id": 0,
    "MarinaLocation_Id": 17,
    "RemainingCredit": 12,
    "SentToContact": 10,
    "SubTotal": 2,
    "Total": 4,
    "TotalTax": 3,
    "UpdatedDateUTC": 5,
    "XeroContact_Id": 15,
    "XeroCreditNoteType_Id": 14,
    "XeroInvoiceId": 13,
    "XeroInvoiceStatus_Id": 16
}

schema_attributes:

{
    "CreditNoteID": "string",
    "CreditNoteNumber": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "FullyPaidOnDate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RemainingCredit": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalTax": "string",
    "UpdatedDateUTC": "string",
    "XeroContact_Id": "string",
    "XeroCreditNoteType_Id": "string",
    "XeroInvoiceId": "string",
    "XeroInvoiceStatus_Id": "string"
}

schema_name_id: 1769
schema_scan_id: 161942728
updated: 2026-04-13 03:05:48

Version 1711760

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerocreditnoteset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerocreditnoteset`\n(\n `Id`  string , `Date`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `UpdatedDateUTC`  string , `CurrencyCode`  string , `FullyPaidOnDate`  string , `CreditNoteID`  string , `CreditNoteNumber`  string , `SentToContact`  string , `CurrencyRate`  string , `RemainingCredit`  string , `XeroInvoiceId`  string , `XeroCreditNoteType_Id`  string , `XeroContact_Id`  string , `XeroInvoiceStatus_Id`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-12/1775980872'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerocreditnoteset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-12/1775980872
id: 1711760
processed: 1

raw_data:

{
    "CreditNoteID": 8,
    "CreditNoteNumber": 9,
    "CurrencyCode": 6,
    "CurrencyRate": 11,
    "Date": 1,
    "FullyPaidOnDate": 7,
    "Id": 0,
    "MarinaLocation_Id": 17,
    "RemainingCredit": 12,
    "SentToContact": 10,
    "SubTotal": 2,
    "Total": 4,
    "TotalTax": 3,
    "UpdatedDateUTC": 5,
    "XeroContact_Id": 15,
    "XeroCreditNoteType_Id": 14,
    "XeroInvoiceId": 13,
    "XeroInvoiceStatus_Id": 16
}

schema_attributes:

{
    "CreditNoteID": "string",
    "CreditNoteNumber": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "FullyPaidOnDate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RemainingCredit": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalTax": "string",
    "UpdatedDateUTC": "string",
    "XeroContact_Id": "string",
    "XeroCreditNoteType_Id": "string",
    "XeroInvoiceId": "string",
    "XeroInvoiceStatus_Id": "string"
}

schema_name_id: 1769
schema_scan_id: 161893462
updated: 2026-04-12 03:08:31

Version 1710587

created: 2026-04-11 03:12:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerocreditnoteset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerocreditnoteset`\n(\n `Id`  string , `Date`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `UpdatedDateUTC`  string , `CurrencyCode`  string , `FullyPaidOnDate`  string , `CreditNoteID`  string , `CreditNoteNumber`  string , `SentToContact`  string , `CurrencyRate`  string , `RemainingCredit`  string , `XeroInvoiceId`  string , `XeroCreditNoteType_Id`  string , `XeroContact_Id`  string , `XeroInvoiceStatus_Id`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-11/1775894648'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerocreditnoteset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-11/1775894648
id: 1710587
processed: 1

raw_data:

{
    "CreditNoteID": 8,
    "CreditNoteNumber": 9,
    "CurrencyCode": 6,
    "CurrencyRate": 11,
    "Date": 1,
    "FullyPaidOnDate": 7,
    "Id": 0,
    "MarinaLocation_Id": 17,
    "RemainingCredit": 12,
    "SentToContact": 10,
    "SubTotal": 2,
    "Total": 4,
    "TotalTax": 3,
    "UpdatedDateUTC": 5,
    "XeroContact_Id": 15,
    "XeroCreditNoteType_Id": 14,
    "XeroInvoiceId": 13,
    "XeroInvoiceStatus_Id": 16
}

schema_attributes:

{
    "CreditNoteID": "string",
    "CreditNoteNumber": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "FullyPaidOnDate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RemainingCredit": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalTax": "string",
    "UpdatedDateUTC": "string",
    "XeroContact_Id": "string",
    "XeroCreditNoteType_Id": "string",
    "XeroInvoiceId": "string",
    "XeroInvoiceStatus_Id": "string"
}

schema_name_id: 1769
schema_scan_id: 161841398
updated: 2026-04-11 03:12:37

Version 1709350

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerocreditnoteset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerocreditnoteset`\n(\n `Id`  string , `Date`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `UpdatedDateUTC`  string , `CurrencyCode`  string , `FullyPaidOnDate`  string , `CreditNoteID`  string , `CreditNoteNumber`  string , `SentToContact`  string , `CurrencyRate`  string , `RemainingCredit`  string , `XeroInvoiceId`  string , `XeroCreditNoteType_Id`  string , `XeroContact_Id`  string , `XeroInvoiceStatus_Id`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-10/1775808403'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerocreditnoteset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-10/1775808403
id: 1709350
processed: 1

raw_data:

{
    "CreditNoteID": 8,
    "CreditNoteNumber": 9,
    "CurrencyCode": 6,
    "CurrencyRate": 11,
    "Date": 1,
    "FullyPaidOnDate": 7,
    "Id": 0,
    "MarinaLocation_Id": 17,
    "RemainingCredit": 12,
    "SentToContact": 10,
    "SubTotal": 2,
    "Total": 4,
    "TotalTax": 3,
    "UpdatedDateUTC": 5,
    "XeroContact_Id": 15,
    "XeroCreditNoteType_Id": 14,
    "XeroInvoiceId": 13,
    "XeroInvoiceStatus_Id": 16
}

schema_attributes:

{
    "CreditNoteID": "string",
    "CreditNoteNumber": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "FullyPaidOnDate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RemainingCredit": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalTax": "string",
    "UpdatedDateUTC": "string",
    "XeroContact_Id": "string",
    "XeroCreditNoteType_Id": "string",
    "XeroInvoiceId": "string",
    "XeroInvoiceStatus_Id": "string"
}

schema_name_id: 1769
schema_scan_id: 161786049
updated: 2026-04-10 03:10:18

Version 1708253

created: 2026-04-09 03:09:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerocreditnoteset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerocreditnoteset`\n(\n `Id`  string , `Date`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `UpdatedDateUTC`  string , `CurrencyCode`  string , `FullyPaidOnDate`  string , `CreditNoteID`  string , `CreditNoteNumber`  string , `SentToContact`  string , `CurrencyRate`  string , `RemainingCredit`  string , `XeroInvoiceId`  string , `XeroCreditNoteType_Id`  string , `XeroContact_Id`  string , `XeroInvoiceStatus_Id`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-09/1775721733'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerocreditnoteset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-09/1775721733
id: 1708253
processed: 1

raw_data:

{
    "CreditNoteID": 8,
    "CreditNoteNumber": 9,
    "CurrencyCode": 6,
    "CurrencyRate": 11,
    "Date": 1,
    "FullyPaidOnDate": 7,
    "Id": 0,
    "MarinaLocation_Id": 17,
    "RemainingCredit": 12,
    "SentToContact": 10,
    "SubTotal": 2,
    "Total": 4,
    "TotalTax": 3,
    "UpdatedDateUTC": 5,
    "XeroContact_Id": 15,
    "XeroCreditNoteType_Id": 14,
    "XeroInvoiceId": 13,
    "XeroInvoiceStatus_Id": 16
}

schema_attributes:

{
    "CreditNoteID": "string",
    "CreditNoteNumber": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "FullyPaidOnDate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RemainingCredit": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalTax": "string",
    "UpdatedDateUTC": "string",
    "XeroContact_Id": "string",
    "XeroCreditNoteType_Id": "string",
    "XeroInvoiceId": "string",
    "XeroInvoiceStatus_Id": "string"
}

schema_name_id: 1769
schema_scan_id: 161730522
updated: 2026-04-09 03:09:24

Version 1706933

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerocreditnoteset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerocreditnoteset`\n(\n `Id`  string , `Date`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `UpdatedDateUTC`  string , `CurrencyCode`  string , `FullyPaidOnDate`  string , `CreditNoteID`  string , `CreditNoteNumber`  string , `SentToContact`  string , `CurrencyRate`  string , `RemainingCredit`  string , `XeroInvoiceId`  string , `XeroCreditNoteType_Id`  string , `XeroContact_Id`  string , `XeroInvoiceStatus_Id`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-08/1775635562'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerocreditnoteset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-08/1775635562
id: 1706933
processed: 1

raw_data:

{
    "CreditNoteID": 8,
    "CreditNoteNumber": 9,
    "CurrencyCode": 6,
    "CurrencyRate": 11,
    "Date": 1,
    "FullyPaidOnDate": 7,
    "Id": 0,
    "MarinaLocation_Id": 17,
    "RemainingCredit": 12,
    "SentToContact": 10,
    "SubTotal": 2,
    "Total": 4,
    "TotalTax": 3,
    "UpdatedDateUTC": 5,
    "XeroContact_Id": 15,
    "XeroCreditNoteType_Id": 14,
    "XeroInvoiceId": 13,
    "XeroInvoiceStatus_Id": 16
}

schema_attributes:

{
    "CreditNoteID": "string",
    "CreditNoteNumber": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "FullyPaidOnDate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RemainingCredit": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalTax": "string",
    "UpdatedDateUTC": "string",
    "XeroContact_Id": "string",
    "XeroCreditNoteType_Id": "string",
    "XeroInvoiceId": "string",
    "XeroInvoiceStatus_Id": "string"
}

schema_name_id: 1769
schema_scan_id: 161675571
updated: 2026-04-08 03:07:04

Version 1705885

created: 2026-04-07 03:05:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerocreditnoteset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerocreditnoteset`\n(\n `Id`  string , `Date`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `UpdatedDateUTC`  string , `CurrencyCode`  string , `FullyPaidOnDate`  string , `CreditNoteID`  string , `CreditNoteNumber`  string , `SentToContact`  string , `CurrencyRate`  string , `RemainingCredit`  string , `XeroInvoiceId`  string , `XeroCreditNoteType_Id`  string , `XeroContact_Id`  string , `XeroInvoiceStatus_Id`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-07/1775548722'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerocreditnoteset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-07/1775548722
id: 1705885
processed: 1

raw_data:

{
    "CreditNoteID": 8,
    "CreditNoteNumber": 9,
    "CurrencyCode": 6,
    "CurrencyRate": 11,
    "Date": 1,
    "FullyPaidOnDate": 7,
    "Id": 0,
    "MarinaLocation_Id": 17,
    "RemainingCredit": 12,
    "SentToContact": 10,
    "SubTotal": 2,
    "Total": 4,
    "TotalTax": 3,
    "UpdatedDateUTC": 5,
    "XeroContact_Id": 15,
    "XeroCreditNoteType_Id": 14,
    "XeroInvoiceId": 13,
    "XeroInvoiceStatus_Id": 16
}

schema_attributes:

{
    "CreditNoteID": "string",
    "CreditNoteNumber": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "FullyPaidOnDate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RemainingCredit": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalTax": "string",
    "UpdatedDateUTC": "string",
    "XeroContact_Id": "string",
    "XeroCreditNoteType_Id": "string",
    "XeroInvoiceId": "string",
    "XeroInvoiceStatus_Id": "string"
}

schema_name_id: 1769
schema_scan_id: 161619494
updated: 2026-04-07 03:05:45

Version 1704529

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerocreditnoteset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerocreditnoteset`\n(\n `Id`  string , `Date`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `UpdatedDateUTC`  string , `CurrencyCode`  string , `FullyPaidOnDate`  string , `CreditNoteID`  string , `CreditNoteNumber`  string , `SentToContact`  string , `CurrencyRate`  string , `RemainingCredit`  string , `XeroInvoiceId`  string , `XeroCreditNoteType_Id`  string , `XeroContact_Id`  string , `XeroInvoiceStatus_Id`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-06/1775462674'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerocreditnoteset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-06/1775462674
id: 1704529
processed: 1

raw_data:

{
    "CreditNoteID": 8,
    "CreditNoteNumber": 9,
    "CurrencyCode": 6,
    "CurrencyRate": 11,
    "Date": 1,
    "FullyPaidOnDate": 7,
    "Id": 0,
    "MarinaLocation_Id": 17,
    "RemainingCredit": 12,
    "SentToContact": 10,
    "SubTotal": 2,
    "Total": 4,
    "TotalTax": 3,
    "UpdatedDateUTC": 5,
    "XeroContact_Id": 15,
    "XeroCreditNoteType_Id": 14,
    "XeroInvoiceId": 13,
    "XeroInvoiceStatus_Id": 16
}

schema_attributes:

{
    "CreditNoteID": "string",
    "CreditNoteNumber": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "FullyPaidOnDate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RemainingCredit": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalTax": "string",
    "UpdatedDateUTC": "string",
    "XeroContact_Id": "string",
    "XeroCreditNoteType_Id": "string",
    "XeroInvoiceId": "string",
    "XeroInvoiceStatus_Id": "string"
}

schema_name_id: 1769
schema_scan_id: 161561635
updated: 2026-04-06 03:07:35

Version 1703454

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerocreditnoteset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerocreditnoteset`\n(\n `Id`  string , `Date`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `UpdatedDateUTC`  string , `CurrencyCode`  string , `FullyPaidOnDate`  string , `CreditNoteID`  string , `CreditNoteNumber`  string , `SentToContact`  string , `CurrencyRate`  string , `RemainingCredit`  string , `XeroInvoiceId`  string , `XeroCreditNoteType_Id`  string , `XeroContact_Id`  string , `XeroInvoiceStatus_Id`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-05/1775376303'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerocreditnoteset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-05/1775376303
id: 1703454
processed: 1

raw_data:

{
    "CreditNoteID": 8,
    "CreditNoteNumber": 9,
    "CurrencyCode": 6,
    "CurrencyRate": 11,
    "Date": 1,
    "FullyPaidOnDate": 7,
    "Id": 0,
    "MarinaLocation_Id": 17,
    "RemainingCredit": 12,
    "SentToContact": 10,
    "SubTotal": 2,
    "Total": 4,
    "TotalTax": 3,
    "UpdatedDateUTC": 5,
    "XeroContact_Id": 15,
    "XeroCreditNoteType_Id": 14,
    "XeroInvoiceId": 13,
    "XeroInvoiceStatus_Id": 16
}

schema_attributes:

{
    "CreditNoteID": "string",
    "CreditNoteNumber": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "FullyPaidOnDate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RemainingCredit": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalTax": "string",
    "UpdatedDateUTC": "string",
    "XeroContact_Id": "string",
    "XeroCreditNoteType_Id": "string",
    "XeroInvoiceId": "string",
    "XeroInvoiceStatus_Id": "string"
}

schema_name_id: 1769
schema_scan_id: 161515044
updated: 2026-04-05 03:11:18

Version 1702286

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerocreditnoteset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerocreditnoteset`\n(\n `Id`  string , `Date`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `UpdatedDateUTC`  string , `CurrencyCode`  string , `FullyPaidOnDate`  string , `CreditNoteID`  string , `CreditNoteNumber`  string , `SentToContact`  string , `CurrencyRate`  string , `RemainingCredit`  string , `XeroInvoiceId`  string , `XeroCreditNoteType_Id`  string , `XeroContact_Id`  string , `XeroInvoiceStatus_Id`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-04/1775289788'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerocreditnoteset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-04/1775289788
id: 1702286
processed: 1

raw_data:

{
    "CreditNoteID": 8,
    "CreditNoteNumber": 9,
    "CurrencyCode": 6,
    "CurrencyRate": 11,
    "Date": 1,
    "FullyPaidOnDate": 7,
    "Id": 0,
    "MarinaLocation_Id": 17,
    "RemainingCredit": 12,
    "SentToContact": 10,
    "SubTotal": 2,
    "Total": 4,
    "TotalTax": 3,
    "UpdatedDateUTC": 5,
    "XeroContact_Id": 15,
    "XeroCreditNoteType_Id": 14,
    "XeroInvoiceId": 13,
    "XeroInvoiceStatus_Id": 16
}

schema_attributes:

{
    "CreditNoteID": "string",
    "CreditNoteNumber": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "FullyPaidOnDate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RemainingCredit": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalTax": "string",
    "UpdatedDateUTC": "string",
    "XeroContact_Id": "string",
    "XeroCreditNoteType_Id": "string",
    "XeroInvoiceId": "string",
    "XeroInvoiceStatus_Id": "string"
}

schema_name_id: 1769
schema_scan_id: 161460601
updated: 2026-04-04 03:11:33

Version 1701043

created: 2026-04-03 03:14:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerocreditnoteset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerocreditnoteset`\n(\n `Id`  string , `Date`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `UpdatedDateUTC`  string , `CurrencyCode`  string , `FullyPaidOnDate`  string , `CreditNoteID`  string , `CreditNoteNumber`  string , `SentToContact`  string , `CurrencyRate`  string , `RemainingCredit`  string , `XeroInvoiceId`  string , `XeroCreditNoteType_Id`  string , `XeroContact_Id`  string , `XeroInvoiceStatus_Id`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-03/1775203552'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerocreditnoteset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-03/1775203552
id: 1701043
processed: 1

raw_data:

{
    "CreditNoteID": 8,
    "CreditNoteNumber": 9,
    "CurrencyCode": 6,
    "CurrencyRate": 11,
    "Date": 1,
    "FullyPaidOnDate": 7,
    "Id": 0,
    "MarinaLocation_Id": 17,
    "RemainingCredit": 12,
    "SentToContact": 10,
    "SubTotal": 2,
    "Total": 4,
    "TotalTax": 3,
    "UpdatedDateUTC": 5,
    "XeroContact_Id": 15,
    "XeroCreditNoteType_Id": 14,
    "XeroInvoiceId": 13,
    "XeroInvoiceStatus_Id": 16
}

schema_attributes:

{
    "CreditNoteID": "string",
    "CreditNoteNumber": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "FullyPaidOnDate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RemainingCredit": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalTax": "string",
    "UpdatedDateUTC": "string",
    "XeroContact_Id": "string",
    "XeroCreditNoteType_Id": "string",
    "XeroInvoiceId": "string",
    "XeroInvoiceStatus_Id": "string"
}

schema_name_id: 1769
schema_scan_id: 161402023
updated: 2026-04-03 03:14:32

Schema Scans: 15

Last at 2026-04-17 03:11:02

Scan 162167810

duration: 0:00:11.948573

exit_message:

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

id: 162167810

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_moloXeroCreditNoteSet/2026-04-17/1776413274",
        "key": "raw/molo_moloXeroCreditNoteSet/2026-04-17/1776413274/XeroCreditNoteSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroCreditNoteSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2371348655997587043,
        "service_name": "drive-thru",
        "span_id": 4618299526645074686,
        "trace_id": 10131419451020785189
    }
}

running: False
schema_name_id: 1769
start_time: 2026-04-17 03:11:02
success: True
trace_id: 10131419451020785189

Scan 162111973

duration: 0:00:14.542849

exit_message:

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

id: 162111973

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_moloXeroCreditNoteSet/2026-04-16/1776326751",
        "key": "raw/molo_moloXeroCreditNoteSet/2026-04-16/1776326751/XeroCreditNoteSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroCreditNoteSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4049628881135659984,
        "service_name": "drive-thru",
        "span_id": 9154090597991463020,
        "trace_id": 15730911026450960631
    }
}

running: False
schema_name_id: 1769
start_time: 2026-04-16 03:12:29
success: True
trace_id: 15730911026450960631

Scan 162056073

duration: 0:00:14.532658

exit_message:

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

id: 162056073

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_moloXeroCreditNoteSet/2026-04-15/1776240212",
        "key": "raw/molo_moloXeroCreditNoteSet/2026-04-15/1776240212/XeroCreditNoteSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroCreditNoteSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2760849801684164066,
        "service_name": "drive-thru",
        "span_id": 14051689235872373015,
        "trace_id": 12372690744196954199
    }
}

running: False
schema_name_id: 1769
start_time: 2026-04-15 03:08:54
success: True
trace_id: 12372690744196954199

Scan 162000725

duration: 0:00:14.498356

exit_message:

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

id: 162000725

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_moloXeroCreditNoteSet/2026-04-14/1776154176",
        "key": "raw/molo_moloXeroCreditNoteSet/2026-04-14/1776154176/XeroCreditNoteSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroCreditNoteSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 882964206693346980,
        "service_name": "drive-thru",
        "span_id": 17601000395657558749,
        "trace_id": 9800712591436075725
    }
}

running: False
schema_name_id: 1769
start_time: 2026-04-14 03:13:08
success: True
trace_id: 9800712591436075725

Scan 161942728

duration: 0:00:14.706677

exit_message:

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

id: 161942728

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_moloXeroCreditNoteSet/2026-04-13/1776067169",
        "key": "raw/molo_moloXeroCreditNoteSet/2026-04-13/1776067169/XeroCreditNoteSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroCreditNoteSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 940522917772273772,
        "service_name": "drive-thru",
        "span_id": 13854932315288439642,
        "trace_id": 1337038542200586141
    }
}

running: False
schema_name_id: 1769
start_time: 2026-04-13 03:05:33
success: True
trace_id: 1337038542200586141

Scan 161893462

duration: 0:00:11.892005

exit_message:

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

id: 161893462

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_moloXeroCreditNoteSet/2026-04-12/1775980872",
        "key": "raw/molo_moloXeroCreditNoteSet/2026-04-12/1775980872/XeroCreditNoteSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroCreditNoteSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2313295803846052388,
        "service_name": "drive-thru",
        "span_id": 17878366388289019526,
        "trace_id": 839497378247529231
    }
}

running: False
schema_name_id: 1769
start_time: 2026-04-12 03:08:19
success: True
trace_id: 839497378247529231

Scan 161841398

duration: 0:00:14.527128

exit_message:

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

id: 161841398

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_moloXeroCreditNoteSet/2026-04-11/1775894648",
        "key": "raw/molo_moloXeroCreditNoteSet/2026-04-11/1775894648/XeroCreditNoteSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroCreditNoteSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4335261611013701605,
        "service_name": "drive-thru",
        "span_id": 16467457955641396482,
        "trace_id": 16069910276209314644
    }
}

running: False
schema_name_id: 1769
start_time: 2026-04-11 03:12:23
success: True
trace_id: 16069910276209314644

Scan 161786049

duration: 0:00:12.093611

exit_message:

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

id: 161786049

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_moloXeroCreditNoteSet/2026-04-10/1775808403",
        "key": "raw/molo_moloXeroCreditNoteSet/2026-04-10/1775808403/XeroCreditNoteSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroCreditNoteSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9023841774174014302,
        "service_name": "drive-thru",
        "span_id": 14581349665941739352,
        "trace_id": 17777839050137836824
    }
}

running: False
schema_name_id: 1769
start_time: 2026-04-10 03:10:06
success: True
trace_id: 17777839050137836824

Scan 161730522

duration: 0:00:11.891982

exit_message:

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

id: 161730522

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_moloXeroCreditNoteSet/2026-04-09/1775721733",
        "key": "raw/molo_moloXeroCreditNoteSet/2026-04-09/1775721733/XeroCreditNoteSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroCreditNoteSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7367141360592867874,
        "service_name": "drive-thru",
        "span_id": 8524612078908256118,
        "trace_id": 3978211258085050520
    }
}

running: False
schema_name_id: 1769
start_time: 2026-04-09 03:09:12
success: True
trace_id: 3978211258085050520

Scan 161675571

duration: 0:00:14.525512

exit_message:

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

id: 161675571

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_moloXeroCreditNoteSet/2026-04-08/1775635562",
        "key": "raw/molo_moloXeroCreditNoteSet/2026-04-08/1775635562/XeroCreditNoteSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroCreditNoteSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3778262519438680526,
        "service_name": "drive-thru",
        "span_id": 6218188221048554198,
        "trace_id": 18236580678975247499
    }
}

running: False
schema_name_id: 1769
start_time: 2026-04-08 03:06:50
success: True
trace_id: 18236580678975247499

Scan 161619494

duration: 0:00:14.742430

exit_message:

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

id: 161619494

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_moloXeroCreditNoteSet/2026-04-07/1775548722",
        "key": "raw/molo_moloXeroCreditNoteSet/2026-04-07/1775548722/XeroCreditNoteSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroCreditNoteSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10835896267485367354,
        "service_name": "drive-thru",
        "span_id": 16132929872434311066,
        "trace_id": 13566320223768977601
    }
}

running: False
schema_name_id: 1769
start_time: 2026-04-07 03:05:30
success: True
trace_id: 13566320223768977601

Scan 161561635

duration: 0:00:14.474863

exit_message:

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

id: 161561635

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_moloXeroCreditNoteSet/2026-04-06/1775462674",
        "key": "raw/molo_moloXeroCreditNoteSet/2026-04-06/1775462674/XeroCreditNoteSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroCreditNoteSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10040840628113113231,
        "service_name": "drive-thru",
        "span_id": 7784325213747257882,
        "trace_id": 7513822281819952109
    }
}

running: False
schema_name_id: 1769
start_time: 2026-04-06 03:07:21
success: True
trace_id: 7513822281819952109

Scan 161515044

duration: 0:00:14.529495

exit_message:

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

id: 161515044

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_moloXeroCreditNoteSet/2026-04-05/1775376303",
        "key": "raw/molo_moloXeroCreditNoteSet/2026-04-05/1775376303/XeroCreditNoteSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroCreditNoteSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5547023477931537935,
        "service_name": "drive-thru",
        "span_id": 14198409099658136597,
        "trace_id": 11342581580504277192
    }
}

running: False
schema_name_id: 1769
start_time: 2026-04-05 03:11:03
success: True
trace_id: 11342581580504277192

Scan 161460601

duration: 0:00:14.639148

exit_message:

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

id: 161460601

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_moloXeroCreditNoteSet/2026-04-04/1775289788",
        "key": "raw/molo_moloXeroCreditNoteSet/2026-04-04/1775289788/XeroCreditNoteSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroCreditNoteSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 471370017318239512,
        "service_name": "drive-thru",
        "span_id": 1323827301449246028,
        "trace_id": 14875056408308647669
    }
}

running: False
schema_name_id: 1769
start_time: 2026-04-04 03:11:19
success: True
trace_id: 14875056408308647669

Scan 161402023

duration: 0:00:11.918252

exit_message:

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

id: 161402023

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_moloXeroCreditNoteSet/2026-04-03/1775203552",
        "key": "raw/molo_moloXeroCreditNoteSet/2026-04-03/1775203552/XeroCreditNoteSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroCreditNoteSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12772529469895637687,
        "service_name": "drive-thru",
        "span_id": 7494030524994876402,
        "trace_id": 11067387502931102259
    }
}

running: False
schema_name_id: 1769
start_time: 2026-04-03 03:14:20
success: True
trace_id: 11067387502931102259

Partitions:

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

Schema:

attributes:

{
    "CreditNoteID": "string",
    "CreditNoteNumber": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "FullyPaidOnDate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RemainingCredit": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalTax": "string",
    "UpdatedDateUTC": "string",
    "XeroContact_Id": "string",
    "XeroCreditNoteType_Id": "string",
    "XeroInvoiceId": "string",
    "XeroInvoiceStatus_Id": "string"
}

created: 2026-04-17 03:11:02

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerocreditnoteset`\n(\n `Id`  string , `Date`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `UpdatedDateUTC`  string , `CurrencyCode`  string , `FullyPaidOnDate`  string , `CreditNoteID`  string , `CreditNoteNumber`  string , `SentToContact`  string , `CurrencyRate`  string , `RemainingCredit`  string , `XeroInvoiceId`  string , `XeroCreditNoteType_Id`  string , `XeroContact_Id`  string , `XeroInvoiceStatus_Id`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-17/1776413274'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerocreditnoteset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerocreditnoteset"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-10-17 02:01:17",
        "disabled": false,
        "format": "raw",
        "id": 1769,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_moloxerocreditnoteset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "CreditNoteID": "string",
            "CreditNoteNumber": "string",
            "CurrencyCode": "string",
            "CurrencyRate": "string",
            "Date": "string",
            "FullyPaidOnDate": "string",
            "Id": "string",
            "MarinaLocation_Id": "string",
            "RemainingCredit": "string",
            "SentToContact": "string",
            "SubTotal": "string",
            "Total": "string",
            "TotalTax": "string",
            "UpdatedDateUTC": "string",
            "XeroContact_Id": "string",
            "XeroCreditNoteType_Id": "string",
            "XeroInvoiceId": "string",
            "XeroInvoiceStatus_Id": "string"
        },
        "created": "2026-04-17 03:11:02",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerocreditnoteset`\n(\n `Id`  string , `Date`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `UpdatedDateUTC`  string , `CurrencyCode`  string , `FullyPaidOnDate`  string , `CreditNoteID`  string , `CreditNoteNumber`  string , `SentToContact`  string , `CurrencyRate`  string , `RemainingCredit`  string , `XeroInvoiceId`  string , `XeroCreditNoteType_Id`  string , `XeroContact_Id`  string , `XeroInvoiceStatus_Id`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroCreditNoteSet/2026-04-17/1776413274'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerocreditnoteset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerocreditnoteset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}