Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloxerotaxrateset

created: 2023-10-17 02:02:20
disabled: False
format: raw
id: 1795
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717798

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxrateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxrateset`\n(\n `Id`  string , `Name`  string , `Status`  string , `CanApplyToAssets`  string , `CanApplyToEquity`  string , `CanApplyToExpenses`  string , `CanApplyToLiabilities`  string , `CanApplyToRevenue`  string , `DisplayTaxRate`  string , `EffectiveRate`  string , `XeroTaxType_Id`  string , `XeroReportTaxTypes_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_moloXeroTaxRateSet/2026-04-17/1776413279'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxrateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTaxRateSet/2026-04-17/1776413279
id: 1717798
processed: 1

raw_data:

{
    "CanApplyToAssets": 3,
    "CanApplyToEquity": 4,
    "CanApplyToExpenses": 5,
    "CanApplyToLiabilities": 6,
    "CanApplyToRevenue": 7,
    "DisplayTaxRate": 8,
    "EffectiveRate": 9,
    "Id": 0,
    "MarinaLocation_Id": 12,
    "Name": 1,
    "Status": 2,
    "XeroReportTaxTypes_Id": 11,
    "XeroTaxType_Id": 10
}

schema_attributes:

{
    "CanApplyToAssets": "string",
    "CanApplyToEquity": "string",
    "CanApplyToExpenses": "string",
    "CanApplyToLiabilities": "string",
    "CanApplyToRevenue": "string",
    "DisplayTaxRate": "string",
    "EffectiveRate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroReportTaxTypes_Id": "string",
    "XeroTaxType_Id": "string"
}

schema_name_id: 1795
schema_scan_id: 162167833
updated: 2026-04-17 03:12:12

Version 1716539

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxrateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxrateset`\n(\n `Id`  string , `Name`  string , `Status`  string , `CanApplyToAssets`  string , `CanApplyToEquity`  string , `CanApplyToExpenses`  string , `CanApplyToLiabilities`  string , `CanApplyToRevenue`  string , `DisplayTaxRate`  string , `EffectiveRate`  string , `XeroTaxType_Id`  string , `XeroReportTaxTypes_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_moloXeroTaxRateSet/2026-04-16/1776326755'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxrateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTaxRateSet/2026-04-16/1776326755
id: 1716539
processed: 1

raw_data:

{
    "CanApplyToAssets": 3,
    "CanApplyToEquity": 4,
    "CanApplyToExpenses": 5,
    "CanApplyToLiabilities": 6,
    "CanApplyToRevenue": 7,
    "DisplayTaxRate": 8,
    "EffectiveRate": 9,
    "Id": 0,
    "MarinaLocation_Id": 12,
    "Name": 1,
    "Status": 2,
    "XeroReportTaxTypes_Id": 11,
    "XeroTaxType_Id": 10
}

schema_attributes:

{
    "CanApplyToAssets": "string",
    "CanApplyToEquity": "string",
    "CanApplyToExpenses": "string",
    "CanApplyToLiabilities": "string",
    "CanApplyToRevenue": "string",
    "DisplayTaxRate": "string",
    "EffectiveRate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroReportTaxTypes_Id": "string",
    "XeroTaxType_Id": "string"
}

schema_name_id: 1795
schema_scan_id: 162111990
updated: 2026-04-16 03:13:17

Version 1715392

created: 2026-04-15 03:13:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxrateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxrateset`\n(\n `Id`  string , `Name`  string , `Status`  string , `CanApplyToAssets`  string , `CanApplyToEquity`  string , `CanApplyToExpenses`  string , `CanApplyToLiabilities`  string , `CanApplyToRevenue`  string , `DisplayTaxRate`  string , `EffectiveRate`  string , `XeroTaxType_Id`  string , `XeroReportTaxTypes_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_moloXeroTaxRateSet/2026-04-15/1776240218'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxrateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTaxRateSet/2026-04-15/1776240218
id: 1715392
processed: 1

raw_data:

{
    "CanApplyToAssets": 3,
    "CanApplyToEquity": 4,
    "CanApplyToExpenses": 5,
    "CanApplyToLiabilities": 6,
    "CanApplyToRevenue": 7,
    "DisplayTaxRate": 8,
    "EffectiveRate": 9,
    "Id": 0,
    "MarinaLocation_Id": 12,
    "Name": 1,
    "Status": 2,
    "XeroReportTaxTypes_Id": 11,
    "XeroTaxType_Id": 10
}

schema_attributes:

{
    "CanApplyToAssets": "string",
    "CanApplyToEquity": "string",
    "CanApplyToExpenses": "string",
    "CanApplyToLiabilities": "string",
    "CanApplyToRevenue": "string",
    "DisplayTaxRate": "string",
    "EffectiveRate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroReportTaxTypes_Id": "string",
    "XeroTaxType_Id": "string"
}

schema_name_id: 1795
schema_scan_id: 162056201
updated: 2026-04-15 03:13:48

Version 1714155

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxrateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxrateset`\n(\n `Id`  string , `Name`  string , `Status`  string , `CanApplyToAssets`  string , `CanApplyToEquity`  string , `CanApplyToExpenses`  string , `CanApplyToLiabilities`  string , `CanApplyToRevenue`  string , `DisplayTaxRate`  string , `EffectiveRate`  string , `XeroTaxType_Id`  string , `XeroReportTaxTypes_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_moloXeroTaxRateSet/2026-04-14/1776154179'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxrateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTaxRateSet/2026-04-14/1776154179
id: 1714155
processed: 1

raw_data:

{
    "CanApplyToAssets": 3,
    "CanApplyToEquity": 4,
    "CanApplyToExpenses": 5,
    "CanApplyToLiabilities": 6,
    "CanApplyToRevenue": 7,
    "DisplayTaxRate": 8,
    "EffectiveRate": 9,
    "Id": 0,
    "MarinaLocation_Id": 12,
    "Name": 1,
    "Status": 2,
    "XeroReportTaxTypes_Id": 11,
    "XeroTaxType_Id": 10
}

schema_attributes:

{
    "CanApplyToAssets": "string",
    "CanApplyToEquity": "string",
    "CanApplyToExpenses": "string",
    "CanApplyToLiabilities": "string",
    "CanApplyToRevenue": "string",
    "DisplayTaxRate": "string",
    "EffectiveRate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroReportTaxTypes_Id": "string",
    "XeroTaxType_Id": "string"
}

schema_name_id: 1795
schema_scan_id: 162000675
updated: 2026-04-14 03:11:35

Version 1712964

created: 2026-04-13 03:06:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxrateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxrateset`\n(\n `Id`  string , `Name`  string , `Status`  string , `CanApplyToAssets`  string , `CanApplyToEquity`  string , `CanApplyToExpenses`  string , `CanApplyToLiabilities`  string , `CanApplyToRevenue`  string , `DisplayTaxRate`  string , `EffectiveRate`  string , `XeroTaxType_Id`  string , `XeroReportTaxTypes_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_moloXeroTaxRateSet/2026-04-13/1776067172'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxrateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTaxRateSet/2026-04-13/1776067172
id: 1712964
processed: 1

raw_data:

{
    "CanApplyToAssets": 3,
    "CanApplyToEquity": 4,
    "CanApplyToExpenses": 5,
    "CanApplyToLiabilities": 6,
    "CanApplyToRevenue": 7,
    "DisplayTaxRate": 8,
    "EffectiveRate": 9,
    "Id": 0,
    "MarinaLocation_Id": 12,
    "Name": 1,
    "Status": 2,
    "XeroReportTaxTypes_Id": 11,
    "XeroTaxType_Id": 10
}

schema_attributes:

{
    "CanApplyToAssets": "string",
    "CanApplyToEquity": "string",
    "CanApplyToExpenses": "string",
    "CanApplyToLiabilities": "string",
    "CanApplyToRevenue": "string",
    "DisplayTaxRate": "string",
    "EffectiveRate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroReportTaxTypes_Id": "string",
    "XeroTaxType_Id": "string"
}

schema_name_id: 1795
schema_scan_id: 161942785
updated: 2026-04-13 03:07:02

Version 1711783

created: 2026-04-12 03:15:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxrateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxrateset`\n(\n `Id`  string , `Name`  string , `Status`  string , `CanApplyToAssets`  string , `CanApplyToEquity`  string , `CanApplyToExpenses`  string , `CanApplyToLiabilities`  string , `CanApplyToRevenue`  string , `DisplayTaxRate`  string , `EffectiveRate`  string , `XeroTaxType_Id`  string , `XeroReportTaxTypes_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_moloXeroTaxRateSet/2026-04-12/1775980874'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxrateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTaxRateSet/2026-04-12/1775980874
id: 1711783
processed: 1

raw_data:

{
    "CanApplyToAssets": 3,
    "CanApplyToEquity": 4,
    "CanApplyToExpenses": 5,
    "CanApplyToLiabilities": 6,
    "CanApplyToRevenue": 7,
    "DisplayTaxRate": 8,
    "EffectiveRate": 9,
    "Id": 0,
    "MarinaLocation_Id": 12,
    "Name": 1,
    "Status": 2,
    "XeroReportTaxTypes_Id": 11,
    "XeroTaxType_Id": 10
}

schema_attributes:

{
    "CanApplyToAssets": "string",
    "CanApplyToEquity": "string",
    "CanApplyToExpenses": "string",
    "CanApplyToLiabilities": "string",
    "CanApplyToRevenue": "string",
    "DisplayTaxRate": "string",
    "EffectiveRate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroReportTaxTypes_Id": "string",
    "XeroTaxType_Id": "string"
}

schema_name_id: 1795
schema_scan_id: 161893522
updated: 2026-04-12 03:15:43

Version 1710513

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxrateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxrateset`\n(\n `Id`  string , `Name`  string , `Status`  string , `CanApplyToAssets`  string , `CanApplyToEquity`  string , `CanApplyToExpenses`  string , `CanApplyToLiabilities`  string , `CanApplyToRevenue`  string , `DisplayTaxRate`  string , `EffectiveRate`  string , `XeroTaxType_Id`  string , `XeroReportTaxTypes_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_moloXeroTaxRateSet/2026-04-11/1775894653'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxrateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTaxRateSet/2026-04-11/1775894653
id: 1710513
processed: 1

raw_data:

{
    "CanApplyToAssets": 3,
    "CanApplyToEquity": 4,
    "CanApplyToExpenses": 5,
    "CanApplyToLiabilities": 6,
    "CanApplyToRevenue": 7,
    "DisplayTaxRate": 8,
    "EffectiveRate": 9,
    "Id": 0,
    "MarinaLocation_Id": 12,
    "Name": 1,
    "Status": 2,
    "XeroReportTaxTypes_Id": 11,
    "XeroTaxType_Id": 10
}

schema_attributes:

{
    "CanApplyToAssets": "string",
    "CanApplyToEquity": "string",
    "CanApplyToExpenses": "string",
    "CanApplyToLiabilities": "string",
    "CanApplyToRevenue": "string",
    "DisplayTaxRate": "string",
    "EffectiveRate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroReportTaxTypes_Id": "string",
    "XeroTaxType_Id": "string"
}

schema_name_id: 1795
schema_scan_id: 161841303
updated: 2026-04-11 03:09:08

Version 1709344

created: 2026-04-10 03:09:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxrateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxrateset`\n(\n `Id`  string , `Name`  string , `Status`  string , `CanApplyToAssets`  string , `CanApplyToEquity`  string , `CanApplyToExpenses`  string , `CanApplyToLiabilities`  string , `CanApplyToRevenue`  string , `DisplayTaxRate`  string , `EffectiveRate`  string , `XeroTaxType_Id`  string , `XeroReportTaxTypes_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_moloXeroTaxRateSet/2026-04-10/1775808407'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxrateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTaxRateSet/2026-04-10/1775808407
id: 1709344
processed: 1

raw_data:

{
    "CanApplyToAssets": 3,
    "CanApplyToEquity": 4,
    "CanApplyToExpenses": 5,
    "CanApplyToLiabilities": 6,
    "CanApplyToRevenue": 7,
    "DisplayTaxRate": 8,
    "EffectiveRate": 9,
    "Id": 0,
    "MarinaLocation_Id": 12,
    "Name": 1,
    "Status": 2,
    "XeroReportTaxTypes_Id": 11,
    "XeroTaxType_Id": 10
}

schema_attributes:

{
    "CanApplyToAssets": "string",
    "CanApplyToEquity": "string",
    "CanApplyToExpenses": "string",
    "CanApplyToLiabilities": "string",
    "CanApplyToRevenue": "string",
    "DisplayTaxRate": "string",
    "EffectiveRate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroReportTaxTypes_Id": "string",
    "XeroTaxType_Id": "string"
}

schema_name_id: 1795
schema_scan_id: 161786042
updated: 2026-04-10 03:10:06

Version 1708285

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxrateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxrateset`\n(\n `Id`  string , `Name`  string , `Status`  string , `CanApplyToAssets`  string , `CanApplyToEquity`  string , `CanApplyToExpenses`  string , `CanApplyToLiabilities`  string , `CanApplyToRevenue`  string , `DisplayTaxRate`  string , `EffectiveRate`  string , `XeroTaxType_Id`  string , `XeroReportTaxTypes_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_moloXeroTaxRateSet/2026-04-09/1775721737'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxrateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTaxRateSet/2026-04-09/1775721737
id: 1708285
processed: 1

raw_data:

{
    "CanApplyToAssets": 3,
    "CanApplyToEquity": 4,
    "CanApplyToExpenses": 5,
    "CanApplyToLiabilities": 6,
    "CanApplyToRevenue": 7,
    "DisplayTaxRate": 8,
    "EffectiveRate": 9,
    "Id": 0,
    "MarinaLocation_Id": 12,
    "Name": 1,
    "Status": 2,
    "XeroReportTaxTypes_Id": 11,
    "XeroTaxType_Id": 10
}

schema_attributes:

{
    "CanApplyToAssets": "string",
    "CanApplyToEquity": "string",
    "CanApplyToExpenses": "string",
    "CanApplyToLiabilities": "string",
    "CanApplyToRevenue": "string",
    "DisplayTaxRate": "string",
    "EffectiveRate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroReportTaxTypes_Id": "string",
    "XeroTaxType_Id": "string"
}

schema_name_id: 1795
schema_scan_id: 161730581
updated: 2026-04-09 03:10:51

Version 1707053

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxrateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxrateset`\n(\n `Id`  string , `Name`  string , `Status`  string , `CanApplyToAssets`  string , `CanApplyToEquity`  string , `CanApplyToExpenses`  string , `CanApplyToLiabilities`  string , `CanApplyToRevenue`  string , `DisplayTaxRate`  string , `EffectiveRate`  string , `XeroTaxType_Id`  string , `XeroReportTaxTypes_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_moloXeroTaxRateSet/2026-04-08/1775635565'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxrateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTaxRateSet/2026-04-08/1775635565
id: 1707053
processed: 1

raw_data:

{
    "CanApplyToAssets": 3,
    "CanApplyToEquity": 4,
    "CanApplyToExpenses": 5,
    "CanApplyToLiabilities": 6,
    "CanApplyToRevenue": 7,
    "DisplayTaxRate": 8,
    "EffectiveRate": 9,
    "Id": 0,
    "MarinaLocation_Id": 12,
    "Name": 1,
    "Status": 2,
    "XeroReportTaxTypes_Id": 11,
    "XeroTaxType_Id": 10
}

schema_attributes:

{
    "CanApplyToAssets": "string",
    "CanApplyToEquity": "string",
    "CanApplyToExpenses": "string",
    "CanApplyToLiabilities": "string",
    "CanApplyToRevenue": "string",
    "DisplayTaxRate": "string",
    "EffectiveRate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroReportTaxTypes_Id": "string",
    "XeroTaxType_Id": "string"
}

schema_name_id: 1795
schema_scan_id: 161675721
updated: 2026-04-08 03:11:57

Version 1705826

created: 2026-04-07 03:02:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxrateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxrateset`\n(\n `Id`  string , `Name`  string , `Status`  string , `CanApplyToAssets`  string , `CanApplyToEquity`  string , `CanApplyToExpenses`  string , `CanApplyToLiabilities`  string , `CanApplyToRevenue`  string , `DisplayTaxRate`  string , `EffectiveRate`  string , `XeroTaxType_Id`  string , `XeroReportTaxTypes_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_moloXeroTaxRateSet/2026-04-07/1775548725'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxrateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTaxRateSet/2026-04-07/1775548725
id: 1705826
processed: 1

raw_data:

{
    "CanApplyToAssets": 3,
    "CanApplyToEquity": 4,
    "CanApplyToExpenses": 5,
    "CanApplyToLiabilities": 6,
    "CanApplyToRevenue": 7,
    "DisplayTaxRate": 8,
    "EffectiveRate": 9,
    "Id": 0,
    "MarinaLocation_Id": 12,
    "Name": 1,
    "Status": 2,
    "XeroReportTaxTypes_Id": 11,
    "XeroTaxType_Id": 10
}

schema_attributes:

{
    "CanApplyToAssets": "string",
    "CanApplyToEquity": "string",
    "CanApplyToExpenses": "string",
    "CanApplyToLiabilities": "string",
    "CanApplyToRevenue": "string",
    "DisplayTaxRate": "string",
    "EffectiveRate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroReportTaxTypes_Id": "string",
    "XeroTaxType_Id": "string"
}

schema_name_id: 1795
schema_scan_id: 161619238
updated: 2026-04-07 03:02:31

Version 1704651

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxrateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxrateset`\n(\n `Id`  string , `Name`  string , `Status`  string , `CanApplyToAssets`  string , `CanApplyToEquity`  string , `CanApplyToExpenses`  string , `CanApplyToLiabilities`  string , `CanApplyToRevenue`  string , `DisplayTaxRate`  string , `EffectiveRate`  string , `XeroTaxType_Id`  string , `XeroReportTaxTypes_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_moloXeroTaxRateSet/2026-04-06/1775462677'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxrateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTaxRateSet/2026-04-06/1775462677
id: 1704651
processed: 1

raw_data:

{
    "CanApplyToAssets": 3,
    "CanApplyToEquity": 4,
    "CanApplyToExpenses": 5,
    "CanApplyToLiabilities": 6,
    "CanApplyToRevenue": 7,
    "DisplayTaxRate": 8,
    "EffectiveRate": 9,
    "Id": 0,
    "MarinaLocation_Id": 12,
    "Name": 1,
    "Status": 2,
    "XeroReportTaxTypes_Id": 11,
    "XeroTaxType_Id": 10
}

schema_attributes:

{
    "CanApplyToAssets": "string",
    "CanApplyToEquity": "string",
    "CanApplyToExpenses": "string",
    "CanApplyToLiabilities": "string",
    "CanApplyToRevenue": "string",
    "DisplayTaxRate": "string",
    "EffectiveRate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroReportTaxTypes_Id": "string",
    "XeroTaxType_Id": "string"
}

schema_name_id: 1795
schema_scan_id: 161561800
updated: 2026-04-06 03:12:20

Version 1703458

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxrateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxrateset`\n(\n `Id`  string , `Name`  string , `Status`  string , `CanApplyToAssets`  string , `CanApplyToEquity`  string , `CanApplyToExpenses`  string , `CanApplyToLiabilities`  string , `CanApplyToRevenue`  string , `DisplayTaxRate`  string , `EffectiveRate`  string , `XeroTaxType_Id`  string , `XeroReportTaxTypes_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_moloXeroTaxRateSet/2026-04-05/1775376306'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxrateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTaxRateSet/2026-04-05/1775376306
id: 1703458
processed: 1

raw_data:

{
    "CanApplyToAssets": 3,
    "CanApplyToEquity": 4,
    "CanApplyToExpenses": 5,
    "CanApplyToLiabilities": 6,
    "CanApplyToRevenue": 7,
    "DisplayTaxRate": 8,
    "EffectiveRate": 9,
    "Id": 0,
    "MarinaLocation_Id": 12,
    "Name": 1,
    "Status": 2,
    "XeroReportTaxTypes_Id": 11,
    "XeroTaxType_Id": 10
}

schema_attributes:

{
    "CanApplyToAssets": "string",
    "CanApplyToEquity": "string",
    "CanApplyToExpenses": "string",
    "CanApplyToLiabilities": "string",
    "CanApplyToRevenue": "string",
    "DisplayTaxRate": "string",
    "EffectiveRate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroReportTaxTypes_Id": "string",
    "XeroTaxType_Id": "string"
}

schema_name_id: 1795
schema_scan_id: 161515051
updated: 2026-04-05 03:11:27

Version 1702260

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxrateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxrateset`\n(\n `Id`  string , `Name`  string , `Status`  string , `CanApplyToAssets`  string , `CanApplyToEquity`  string , `CanApplyToExpenses`  string , `CanApplyToLiabilities`  string , `CanApplyToRevenue`  string , `DisplayTaxRate`  string , `EffectiveRate`  string , `XeroTaxType_Id`  string , `XeroReportTaxTypes_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_moloXeroTaxRateSet/2026-04-04/1775289792'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxrateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTaxRateSet/2026-04-04/1775289792
id: 1702260
processed: 1

raw_data:

{
    "CanApplyToAssets": 3,
    "CanApplyToEquity": 4,
    "CanApplyToExpenses": 5,
    "CanApplyToLiabilities": 6,
    "CanApplyToRevenue": 7,
    "DisplayTaxRate": 8,
    "EffectiveRate": 9,
    "Id": 0,
    "MarinaLocation_Id": 12,
    "Name": 1,
    "Status": 2,
    "XeroReportTaxTypes_Id": 11,
    "XeroTaxType_Id": 10
}

schema_attributes:

{
    "CanApplyToAssets": "string",
    "CanApplyToEquity": "string",
    "CanApplyToExpenses": "string",
    "CanApplyToLiabilities": "string",
    "CanApplyToRevenue": "string",
    "DisplayTaxRate": "string",
    "EffectiveRate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroReportTaxTypes_Id": "string",
    "XeroTaxType_Id": "string"
}

schema_name_id: 1795
schema_scan_id: 161460563
updated: 2026-04-04 03:10:18

Version 1701047

created: 2026-04-03 03:14:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxrateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxrateset`\n(\n `Id`  string , `Name`  string , `Status`  string , `CanApplyToAssets`  string , `CanApplyToEquity`  string , `CanApplyToExpenses`  string , `CanApplyToLiabilities`  string , `CanApplyToRevenue`  string , `DisplayTaxRate`  string , `EffectiveRate`  string , `XeroTaxType_Id`  string , `XeroReportTaxTypes_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_moloXeroTaxRateSet/2026-04-03/1775203556'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxrateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTaxRateSet/2026-04-03/1775203556
id: 1701047
processed: 1

raw_data:

{
    "CanApplyToAssets": 3,
    "CanApplyToEquity": 4,
    "CanApplyToExpenses": 5,
    "CanApplyToLiabilities": 6,
    "CanApplyToRevenue": 7,
    "DisplayTaxRate": 8,
    "EffectiveRate": 9,
    "Id": 0,
    "MarinaLocation_Id": 12,
    "Name": 1,
    "Status": 2,
    "XeroReportTaxTypes_Id": 11,
    "XeroTaxType_Id": 10
}

schema_attributes:

{
    "CanApplyToAssets": "string",
    "CanApplyToEquity": "string",
    "CanApplyToExpenses": "string",
    "CanApplyToLiabilities": "string",
    "CanApplyToRevenue": "string",
    "DisplayTaxRate": "string",
    "EffectiveRate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroReportTaxTypes_Id": "string",
    "XeroTaxType_Id": "string"
}

schema_name_id: 1795
schema_scan_id: 161402029
updated: 2026-04-03 03:14:46

Schema Scans: 15

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

Scan 162167833

duration: 0:00:14.302272

exit_message:

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

id: 162167833

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_moloXeroTaxRateSet/2026-04-17/1776413279",
        "key": "raw/molo_moloXeroTaxRateSet/2026-04-17/1776413279/XeroTaxRateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroTaxRateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14575225297698929585,
        "service_name": "drive-thru",
        "span_id": 1546187108751367548,
        "trace_id": 1284838628809571695
    }
}

running: False
schema_name_id: 1795
start_time: 2026-04-17 03:11:58
success: True
trace_id: 1284838628809571695

Scan 162111990

duration: 0:00:11.894034

exit_message:

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

id: 162111990

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_moloXeroTaxRateSet/2026-04-16/1776326755",
        "key": "raw/molo_moloXeroTaxRateSet/2026-04-16/1776326755/XeroTaxRateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroTaxRateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9093999042456000291,
        "service_name": "drive-thru",
        "span_id": 11651691591440476192,
        "trace_id": 35691410682276471
    }
}

running: False
schema_name_id: 1795
start_time: 2026-04-16 03:13:05
success: True
trace_id: 35691410682276471

Scan 162056201

duration: 0:00:11.718740

exit_message:

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

id: 162056201

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_moloXeroTaxRateSet/2026-04-15/1776240218",
        "key": "raw/molo_moloXeroTaxRateSet/2026-04-15/1776240218/XeroTaxRateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroTaxRateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7074661935051870070,
        "service_name": "drive-thru",
        "span_id": 17687235782988732345,
        "trace_id": 11788468584682721488
    }
}

running: False
schema_name_id: 1795
start_time: 2026-04-15 03:13:36
success: True
trace_id: 11788468584682721488

Scan 162000675

duration: 0:00:11.833560

exit_message:

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

id: 162000675

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_moloXeroTaxRateSet/2026-04-14/1776154179",
        "key": "raw/molo_moloXeroTaxRateSet/2026-04-14/1776154179/XeroTaxRateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroTaxRateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5385246854512110997,
        "service_name": "drive-thru",
        "span_id": 1154305076337200276,
        "trace_id": 17545202005102720561
    }
}

running: False
schema_name_id: 1795
start_time: 2026-04-14 03:11:23
success: True
trace_id: 17545202005102720561

Scan 161942785

duration: 0:00:14.375240

exit_message:

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

id: 161942785

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_moloXeroTaxRateSet/2026-04-13/1776067172",
        "key": "raw/molo_moloXeroTaxRateSet/2026-04-13/1776067172/XeroTaxRateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroTaxRateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3069361937830742587,
        "service_name": "drive-thru",
        "span_id": 17612816508322559287,
        "trace_id": 1066702554555761704
    }
}

running: False
schema_name_id: 1795
start_time: 2026-04-13 03:06:47
success: True
trace_id: 1066702554555761704

Scan 161893522

duration: 0:00:14.339410

exit_message:

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

id: 161893522

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_moloXeroTaxRateSet/2026-04-12/1775980874",
        "key": "raw/molo_moloXeroTaxRateSet/2026-04-12/1775980874/XeroTaxRateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroTaxRateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14436476438639431586,
        "service_name": "drive-thru",
        "span_id": 13949582930820074555,
        "trace_id": 10310862860753630156
    }
}

running: False
schema_name_id: 1795
start_time: 2026-04-12 03:15:29
success: True
trace_id: 10310862860753630156

Scan 161841303

duration: 0:00:14.287608

exit_message:

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

id: 161841303

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_moloXeroTaxRateSet/2026-04-11/1775894653",
        "key": "raw/molo_moloXeroTaxRateSet/2026-04-11/1775894653/XeroTaxRateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroTaxRateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4381330050317800925,
        "service_name": "drive-thru",
        "span_id": 18431844084186936204,
        "trace_id": 17074114544707491704
    }
}

running: False
schema_name_id: 1795
start_time: 2026-04-11 03:08:54
success: True
trace_id: 17074114544707491704

Scan 161786042

duration: 0:00:14.479072

exit_message:

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

id: 161786042

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_moloXeroTaxRateSet/2026-04-10/1775808407",
        "key": "raw/molo_moloXeroTaxRateSet/2026-04-10/1775808407/XeroTaxRateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroTaxRateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16521542586305755553,
        "service_name": "drive-thru",
        "span_id": 5479674528410432398,
        "trace_id": 3702537527979728613
    }
}

running: False
schema_name_id: 1795
start_time: 2026-04-10 03:09:51
success: True
trace_id: 3702537527979728613

Scan 161730581

duration: 0:00:14.415577

exit_message:

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

id: 161730581

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_moloXeroTaxRateSet/2026-04-09/1775721737",
        "key": "raw/molo_moloXeroTaxRateSet/2026-04-09/1775721737/XeroTaxRateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroTaxRateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11108672898799143023,
        "service_name": "drive-thru",
        "span_id": 4468710522730579674,
        "trace_id": 15216091066352218350
    }
}

running: False
schema_name_id: 1795
start_time: 2026-04-09 03:10:37
success: True
trace_id: 15216091066352218350

Scan 161675721

duration: 0:00:11.943265

exit_message:

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

id: 161675721

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_moloXeroTaxRateSet/2026-04-08/1775635565",
        "key": "raw/molo_moloXeroTaxRateSet/2026-04-08/1775635565/XeroTaxRateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroTaxRateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12686729240038740564,
        "service_name": "drive-thru",
        "span_id": 4949351617887774018,
        "trace_id": 3467403868139443434
    }
}

running: False
schema_name_id: 1795
start_time: 2026-04-08 03:11:45
success: True
trace_id: 3467403868139443434

Scan 161619238

duration: 0:00:11.916271

exit_message:

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

id: 161619238

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_moloXeroTaxRateSet/2026-04-07/1775548725",
        "key": "raw/molo_moloXeroTaxRateSet/2026-04-07/1775548725/XeroTaxRateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroTaxRateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8206818241233246698,
        "service_name": "drive-thru",
        "span_id": 3899046098967348012,
        "trace_id": 12824175869127060824
    }
}

running: False
schema_name_id: 1795
start_time: 2026-04-07 03:02:19
success: True
trace_id: 12824175869127060824

Scan 161561800

duration: 0:00:14.434576

exit_message:

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

id: 161561800

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_moloXeroTaxRateSet/2026-04-06/1775462677",
        "key": "raw/molo_moloXeroTaxRateSet/2026-04-06/1775462677/XeroTaxRateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroTaxRateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2352981970819822444,
        "service_name": "drive-thru",
        "span_id": 4284820434222560519,
        "trace_id": 3082853735107355793
    }
}

running: False
schema_name_id: 1795
start_time: 2026-04-06 03:12:05
success: True
trace_id: 3082853735107355793

Scan 161515051

duration: 0:00:11.750696

exit_message:

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

id: 161515051

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_moloXeroTaxRateSet/2026-04-05/1775376306",
        "key": "raw/molo_moloXeroTaxRateSet/2026-04-05/1775376306/XeroTaxRateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroTaxRateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2285434103125713289,
        "service_name": "drive-thru",
        "span_id": 15005860872717143533,
        "trace_id": 7407687833655253279
    }
}

running: False
schema_name_id: 1795
start_time: 2026-04-05 03:11:15
success: True
trace_id: 7407687833655253279

Scan 161460563

duration: 0:00:11.929767

exit_message:

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

id: 161460563

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_moloXeroTaxRateSet/2026-04-04/1775289792",
        "key": "raw/molo_moloXeroTaxRateSet/2026-04-04/1775289792/XeroTaxRateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroTaxRateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13240569997990908732,
        "service_name": "drive-thru",
        "span_id": 1838777102196270769,
        "trace_id": 5264619126119657210
    }
}

running: False
schema_name_id: 1795
start_time: 2026-04-04 03:10:06
success: True
trace_id: 5264619126119657210

Scan 161402029

duration: 0:00:14.319156

exit_message:

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

id: 161402029

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_moloXeroTaxRateSet/2026-04-03/1775203556",
        "key": "raw/molo_moloXeroTaxRateSet/2026-04-03/1775203556/XeroTaxRateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroTaxRateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5940101313475674615,
        "service_name": "drive-thru",
        "span_id": 17719811698197668184,
        "trace_id": 11414623713996516909
    }
}

running: False
schema_name_id: 1795
start_time: 2026-04-03 03:14:32
success: True
trace_id: 11414623713996516909

Partitions:

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

Schema:

attributes:

{
    "CanApplyToAssets": "string",
    "CanApplyToEquity": "string",
    "CanApplyToExpenses": "string",
    "CanApplyToLiabilities": "string",
    "CanApplyToRevenue": "string",
    "DisplayTaxRate": "string",
    "EffectiveRate": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroReportTaxTypes_Id": "string",
    "XeroTaxType_Id": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxrateset`\n(\n `Id`  string , `Name`  string , `Status`  string , `CanApplyToAssets`  string , `CanApplyToEquity`  string , `CanApplyToExpenses`  string , `CanApplyToLiabilities`  string , `CanApplyToRevenue`  string , `DisplayTaxRate`  string , `EffectiveRate`  string , `XeroTaxType_Id`  string , `XeroReportTaxTypes_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_moloXeroTaxRateSet/2026-04-17/1776413279'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxrateset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxrateset"
}

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:02:20",
        "disabled": false,
        "format": "raw",
        "id": 1795,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_moloxerotaxrateset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "CanApplyToAssets": "string",
            "CanApplyToEquity": "string",
            "CanApplyToExpenses": "string",
            "CanApplyToLiabilities": "string",
            "CanApplyToRevenue": "string",
            "DisplayTaxRate": "string",
            "EffectiveRate": "string",
            "Id": "string",
            "MarinaLocation_Id": "string",
            "Name": "string",
            "Status": "string",
            "XeroReportTaxTypes_Id": "string",
            "XeroTaxType_Id": "string"
        },
        "created": "2026-04-17 03:11:58",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxrateset`\n(\n `Id`  string , `Name`  string , `Status`  string , `CanApplyToAssets`  string , `CanApplyToEquity`  string , `CanApplyToExpenses`  string , `CanApplyToLiabilities`  string , `CanApplyToRevenue`  string , `DisplayTaxRate`  string , `EffectiveRate`  string , `XeroTaxType_Id`  string , `XeroReportTaxTypes_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_moloXeroTaxRateSet/2026-04-17/1776413279'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxrateset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxrateset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}