Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloqb_taxagencyset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717640

created: 2026-04-17 03:04:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_taxagencyset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_taxagencyset`\n(\n `Id`  string , `TaxTrackedOnPurchases`  string , `TaxTrackedOnSales`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `DisplayName`  string , `time`  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_moloQB_TaxAgencySet/2026-04-17/1776412814'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_taxagencyset"
]

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

raw_data:

{
    "DisplayName": 7,
    "Id": 0,
    "MarinaLocation_Id": 9,
    "QB_ID": 5,
    "SyncToken": 6,
    "TaxTrackedOnPurchases": 1,
    "TaxTrackedOnSales": 2,
    "domain": 3,
    "sparse": 4,
    "time": 8
}

schema_attributes:

{
    "DisplayName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "QB_ID": "string",
    "SyncToken": "string",
    "TaxTrackedOnPurchases": "string",
    "TaxTrackedOnSales": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

schema_name_id: 1645
schema_scan_id: 162167592
updated: 2026-04-17 03:04:52

Version 1716406

created: 2026-04-16 03:08:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_taxagencyset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_taxagencyset`\n(\n `Id`  string , `TaxTrackedOnPurchases`  string , `TaxTrackedOnSales`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `DisplayName`  string , `time`  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_moloQB_TaxAgencySet/2026-04-16/1776326569'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_taxagencyset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_TaxAgencySet/2026-04-16/1776326569
id: 1716406
processed: 1

raw_data:

{
    "DisplayName": 7,
    "Id": 0,
    "MarinaLocation_Id": 9,
    "QB_ID": 5,
    "SyncToken": 6,
    "TaxTrackedOnPurchases": 1,
    "TaxTrackedOnSales": 2,
    "domain": 3,
    "sparse": 4,
    "time": 8
}

schema_attributes:

{
    "DisplayName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "QB_ID": "string",
    "SyncToken": "string",
    "TaxTrackedOnPurchases": "string",
    "TaxTrackedOnSales": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

schema_name_id: 1645
schema_scan_id: 162111835
updated: 2026-04-16 03:08:14

Version 1715267

created: 2026-04-15 03:07:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_taxagencyset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_taxagencyset`\n(\n `Id`  string , `TaxTrackedOnPurchases`  string , `TaxTrackedOnSales`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `DisplayName`  string , `time`  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_moloQB_TaxAgencySet/2026-04-15/1776240038'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_taxagencyset"
]

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

raw_data:

{
    "DisplayName": 7,
    "Id": 0,
    "MarinaLocation_Id": 9,
    "QB_ID": 5,
    "SyncToken": 6,
    "TaxTrackedOnPurchases": 1,
    "TaxTrackedOnSales": 2,
    "domain": 3,
    "sparse": 4,
    "time": 8
}

schema_attributes:

{
    "DisplayName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "QB_ID": "string",
    "SyncToken": "string",
    "TaxTrackedOnPurchases": "string",
    "TaxTrackedOnSales": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

schema_name_id: 1645
schema_scan_id: 162056012
updated: 2026-04-15 03:07:37

Version 1714067

created: 2026-04-14 03:08:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_taxagencyset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_taxagencyset`\n(\n `Id`  string , `TaxTrackedOnPurchases`  string , `TaxTrackedOnSales`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `DisplayName`  string , `time`  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_moloQB_TaxAgencySet/2026-04-14/1776153768'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_taxagencyset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_TaxAgencySet/2026-04-14/1776153768
id: 1714067
processed: 1

raw_data:

{
    "DisplayName": 7,
    "Id": 0,
    "MarinaLocation_Id": 9,
    "QB_ID": 5,
    "SyncToken": 6,
    "TaxTrackedOnPurchases": 1,
    "TaxTrackedOnSales": 2,
    "domain": 3,
    "sparse": 4,
    "time": 8
}

schema_attributes:

{
    "DisplayName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "QB_ID": "string",
    "SyncToken": "string",
    "TaxTrackedOnPurchases": "string",
    "TaxTrackedOnSales": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

schema_name_id: 1645
schema_scan_id: 162000566
updated: 2026-04-14 03:08:19

Version 1712833

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_taxagencyset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_taxagencyset`\n(\n `Id`  string , `TaxTrackedOnPurchases`  string , `TaxTrackedOnSales`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `DisplayName`  string , `time`  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_moloQB_TaxAgencySet/2026-04-13/1776066962'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_taxagencyset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_TaxAgencySet/2026-04-13/1776066962
id: 1712833
processed: 1

raw_data:

{
    "DisplayName": 7,
    "Id": 0,
    "MarinaLocation_Id": 9,
    "QB_ID": 5,
    "SyncToken": 6,
    "TaxTrackedOnPurchases": 1,
    "TaxTrackedOnSales": 2,
    "domain": 3,
    "sparse": 4,
    "time": 8
}

schema_attributes:

{
    "DisplayName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "QB_ID": "string",
    "SyncToken": "string",
    "TaxTrackedOnPurchases": "string",
    "TaxTrackedOnSales": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

schema_name_id: 1645
schema_scan_id: 161941854
updated: 2026-04-13 03:00:23

Version 1711630

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_taxagencyset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_taxagencyset`\n(\n `Id`  string , `TaxTrackedOnPurchases`  string , `TaxTrackedOnSales`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `DisplayName`  string , `time`  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_moloQB_TaxAgencySet/2026-04-12/1775980675'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_taxagencyset"
]

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

raw_data:

{
    "DisplayName": 7,
    "Id": 0,
    "MarinaLocation_Id": 9,
    "QB_ID": 5,
    "SyncToken": 6,
    "TaxTrackedOnPurchases": 1,
    "TaxTrackedOnSales": 2,
    "domain": 3,
    "sparse": 4,
    "time": 8
}

schema_attributes:

{
    "DisplayName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "QB_ID": "string",
    "SyncToken": "string",
    "TaxTrackedOnPurchases": "string",
    "TaxTrackedOnSales": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

schema_name_id: 1645
schema_scan_id: 161892801
updated: 2026-04-12 03:02:04

Version 1710393

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_taxagencyset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_taxagencyset`\n(\n `Id`  string , `TaxTrackedOnPurchases`  string , `TaxTrackedOnSales`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `DisplayName`  string , `time`  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_moloQB_TaxAgencySet/2026-04-11/1775894435'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_taxagencyset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_TaxAgencySet/2026-04-11/1775894435
id: 1710393
processed: 1

raw_data:

{
    "DisplayName": 7,
    "Id": 0,
    "MarinaLocation_Id": 9,
    "QB_ID": 5,
    "SyncToken": 6,
    "TaxTrackedOnPurchases": 1,
    "TaxTrackedOnSales": 2,
    "domain": 3,
    "sparse": 4,
    "time": 8
}

schema_attributes:

{
    "DisplayName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "QB_ID": "string",
    "SyncToken": "string",
    "TaxTrackedOnPurchases": "string",
    "TaxTrackedOnSales": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

schema_name_id: 1645
schema_scan_id: 161841142
updated: 2026-04-11 03:04:21

Version 1709228

created: 2026-04-10 03:05:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_taxagencyset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_taxagencyset`\n(\n `Id`  string , `TaxTrackedOnPurchases`  string , `TaxTrackedOnSales`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `DisplayName`  string , `time`  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_moloQB_TaxAgencySet/2026-04-10/1775808194'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_taxagencyset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_TaxAgencySet/2026-04-10/1775808194
id: 1709228
processed: 1

raw_data:

{
    "DisplayName": 7,
    "Id": 0,
    "MarinaLocation_Id": 9,
    "QB_ID": 5,
    "SyncToken": 6,
    "TaxTrackedOnPurchases": 1,
    "TaxTrackedOnSales": 2,
    "domain": 3,
    "sparse": 4,
    "time": 8
}

schema_attributes:

{
    "DisplayName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "QB_ID": "string",
    "SyncToken": "string",
    "TaxTrackedOnPurchases": "string",
    "TaxTrackedOnSales": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

schema_name_id: 1645
schema_scan_id: 161785910
updated: 2026-04-10 03:05:40

Version 1708172

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_taxagencyset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_taxagencyset`\n(\n `Id`  string , `TaxTrackedOnPurchases`  string , `TaxTrackedOnSales`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `DisplayName`  string , `time`  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_moloQB_TaxAgencySet/2026-04-09/1775721532'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_taxagencyset"
]

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

raw_data:

{
    "DisplayName": 7,
    "Id": 0,
    "MarinaLocation_Id": 9,
    "QB_ID": 5,
    "SyncToken": 6,
    "TaxTrackedOnPurchases": 1,
    "TaxTrackedOnSales": 2,
    "domain": 3,
    "sparse": 4,
    "time": 8
}

schema_attributes:

{
    "DisplayName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "QB_ID": "string",
    "SyncToken": "string",
    "TaxTrackedOnPurchases": "string",
    "TaxTrackedOnSales": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

schema_name_id: 1645
schema_scan_id: 161730390
updated: 2026-04-09 03:05:59

Version 1706873

created: 2026-04-08 03:04:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_taxagencyset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_taxagencyset`\n(\n `Id`  string , `TaxTrackedOnPurchases`  string , `TaxTrackedOnSales`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `DisplayName`  string , `time`  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_moloQB_TaxAgencySet/2026-04-08/1775635359'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_taxagencyset"
]

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

raw_data:

{
    "DisplayName": 7,
    "Id": 0,
    "MarinaLocation_Id": 9,
    "QB_ID": 5,
    "SyncToken": 6,
    "TaxTrackedOnPurchases": 1,
    "TaxTrackedOnSales": 2,
    "domain": 3,
    "sparse": 4,
    "time": 8
}

schema_attributes:

{
    "DisplayName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "QB_ID": "string",
    "SyncToken": "string",
    "TaxTrackedOnPurchases": "string",
    "TaxTrackedOnSales": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

schema_name_id: 1645
schema_scan_id: 161675460
updated: 2026-04-08 03:04:24

Version 1705696

created: 2026-04-07 02:56:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_taxagencyset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_taxagencyset`\n(\n `Id`  string , `TaxTrackedOnPurchases`  string , `TaxTrackedOnSales`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `DisplayName`  string , `time`  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_moloQB_TaxAgencySet/2026-04-07/1775548509'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_taxagencyset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_TaxAgencySet/2026-04-07/1775548509
id: 1705696
processed: 1

raw_data:

{
    "DisplayName": 7,
    "Id": 0,
    "MarinaLocation_Id": 9,
    "QB_ID": 5,
    "SyncToken": 6,
    "TaxTrackedOnPurchases": 1,
    "TaxTrackedOnSales": 2,
    "domain": 3,
    "sparse": 4,
    "time": 8
}

schema_attributes:

{
    "DisplayName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "QB_ID": "string",
    "SyncToken": "string",
    "TaxTrackedOnPurchases": "string",
    "TaxTrackedOnSales": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

schema_name_id: 1645
schema_scan_id: 161618395
updated: 2026-04-07 02:57:00

Version 1704444

created: 2026-04-06 03:03:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_taxagencyset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_taxagencyset`\n(\n `Id`  string , `TaxTrackedOnPurchases`  string , `TaxTrackedOnSales`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `DisplayName`  string , `time`  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_moloQB_TaxAgencySet/2026-04-06/1775462476'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_taxagencyset"
]

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

raw_data:

{
    "DisplayName": 7,
    "Id": 0,
    "MarinaLocation_Id": 9,
    "QB_ID": 5,
    "SyncToken": 6,
    "TaxTrackedOnPurchases": 1,
    "TaxTrackedOnSales": 2,
    "domain": 3,
    "sparse": 4,
    "time": 8
}

schema_attributes:

{
    "DisplayName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "QB_ID": "string",
    "SyncToken": "string",
    "TaxTrackedOnPurchases": "string",
    "TaxTrackedOnSales": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

schema_name_id: 1645
schema_scan_id: 161561492
updated: 2026-04-06 03:03:48

Version 1703297

created: 2026-04-05 03:04:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_taxagencyset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_taxagencyset`\n(\n `Id`  string , `TaxTrackedOnPurchases`  string , `TaxTrackedOnSales`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `DisplayName`  string , `time`  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_moloQB_TaxAgencySet/2026-04-05/1775376102'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_taxagencyset"
]

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

raw_data:

{
    "DisplayName": 7,
    "Id": 0,
    "MarinaLocation_Id": 9,
    "QB_ID": 5,
    "SyncToken": 6,
    "TaxTrackedOnPurchases": 1,
    "TaxTrackedOnSales": 2,
    "domain": 3,
    "sparse": 4,
    "time": 8
}

schema_attributes:

{
    "DisplayName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "QB_ID": "string",
    "SyncToken": "string",
    "TaxTrackedOnPurchases": "string",
    "TaxTrackedOnSales": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

schema_name_id: 1645
schema_scan_id: 161514874
updated: 2026-04-05 03:05:10

Version 1702164

created: 2026-04-04 03:05:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_taxagencyset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_taxagencyset`\n(\n `Id`  string , `TaxTrackedOnPurchases`  string , `TaxTrackedOnSales`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `DisplayName`  string , `time`  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_moloQB_TaxAgencySet/2026-04-04/1775289586'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_taxagencyset"
]

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

raw_data:

{
    "DisplayName": 7,
    "Id": 0,
    "MarinaLocation_Id": 9,
    "QB_ID": 5,
    "SyncToken": 6,
    "TaxTrackedOnPurchases": 1,
    "TaxTrackedOnSales": 2,
    "domain": 3,
    "sparse": 4,
    "time": 8
}

schema_attributes:

{
    "DisplayName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "QB_ID": "string",
    "SyncToken": "string",
    "TaxTrackedOnPurchases": "string",
    "TaxTrackedOnSales": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

schema_name_id: 1645
schema_scan_id: 161460372
updated: 2026-04-04 03:05:47

Version 1700850

created: 2026-04-03 03:05:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_taxagencyset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_taxagencyset`\n(\n `Id`  string , `TaxTrackedOnPurchases`  string , `TaxTrackedOnSales`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `DisplayName`  string , `time`  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_moloQB_TaxAgencySet/2026-04-03/1775203359'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_taxagencyset"
]

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

raw_data:

{
    "DisplayName": 7,
    "Id": 0,
    "MarinaLocation_Id": 9,
    "QB_ID": 5,
    "SyncToken": 6,
    "TaxTrackedOnPurchases": 1,
    "TaxTrackedOnSales": 2,
    "domain": 3,
    "sparse": 4,
    "time": 8
}

schema_attributes:

{
    "DisplayName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "QB_ID": "string",
    "SyncToken": "string",
    "TaxTrackedOnPurchases": "string",
    "TaxTrackedOnSales": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

schema_name_id: 1645
schema_scan_id: 161401746
updated: 2026-04-03 03:05:56

Schema Scans: 15

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

Scan 162167592

duration: 0:00:14.461070

exit_message:

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

id: 162167592

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_TaxAgencySet/2026-04-17/1776412814",
        "key": "raw/molo_moloQB_TaxAgencySet/2026-04-17/1776412814/QB_TaxAgencySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQB_TaxAgencySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10877215109503272412,
        "service_name": "drive-thru",
        "span_id": 1557650255900420742,
        "trace_id": 6708127072037116094
    }
}

running: False
schema_name_id: 1645
start_time: 2026-04-17 03:04:37
success: True
trace_id: 6708127072037116094

Scan 162111835

duration: 0:00:11.745318

exit_message:

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

id: 162111835

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_TaxAgencySet/2026-04-16/1776326569",
        "key": "raw/molo_moloQB_TaxAgencySet/2026-04-16/1776326569/QB_TaxAgencySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQB_TaxAgencySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5263679706707697789,
        "service_name": "drive-thru",
        "span_id": 14794140656965622306,
        "trace_id": 488416395758505643
    }
}

running: False
schema_name_id: 1645
start_time: 2026-04-16 03:08:03
success: True
trace_id: 488416395758505643

Scan 162056012

duration: 0:00:11.699351

exit_message:

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

id: 162056012

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_TaxAgencySet/2026-04-15/1776240038",
        "key": "raw/molo_moloQB_TaxAgencySet/2026-04-15/1776240038/QB_TaxAgencySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQB_TaxAgencySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8303377623182841242,
        "service_name": "drive-thru",
        "span_id": 947446331756254904,
        "trace_id": 8955036951863136390
    }
}

running: False
schema_name_id: 1645
start_time: 2026-04-15 03:07:26
success: True
trace_id: 8955036951863136390

Scan 162000566

duration: 0:00:14.331335

exit_message:

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

id: 162000566

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_TaxAgencySet/2026-04-14/1776153768",
        "key": "raw/molo_moloQB_TaxAgencySet/2026-04-14/1776153768/QB_TaxAgencySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQB_TaxAgencySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9346933628188536885,
        "service_name": "drive-thru",
        "span_id": 13751756624159903078,
        "trace_id": 11162459507383709549
    }
}

running: False
schema_name_id: 1645
start_time: 2026-04-14 03:08:05
success: True
trace_id: 11162459507383709549

Scan 161941854

duration: 0:00:14.248561

exit_message:

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

id: 161941854

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_TaxAgencySet/2026-04-13/1776066962",
        "key": "raw/molo_moloQB_TaxAgencySet/2026-04-13/1776066962/QB_TaxAgencySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQB_TaxAgencySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14903486580529094425,
        "service_name": "drive-thru",
        "span_id": 11974868466044997530,
        "trace_id": 12766409342992829347
    }
}

running: False
schema_name_id: 1645
start_time: 2026-04-13 03:00:09
success: True
trace_id: 12766409342992829347

Scan 161892801

duration: 0:00:14.282680

exit_message:

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

id: 161892801

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_TaxAgencySet/2026-04-12/1775980675",
        "key": "raw/molo_moloQB_TaxAgencySet/2026-04-12/1775980675/QB_TaxAgencySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQB_TaxAgencySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5973889492236811886,
        "service_name": "drive-thru",
        "span_id": 7250327364563619144,
        "trace_id": 13069685723723834986
    }
}

running: False
schema_name_id: 1645
start_time: 2026-04-12 03:01:50
success: True
trace_id: 13069685723723834986

Scan 161841142

duration: 0:00:11.826252

exit_message:

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

id: 161841142

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_TaxAgencySet/2026-04-11/1775894435",
        "key": "raw/molo_moloQB_TaxAgencySet/2026-04-11/1775894435/QB_TaxAgencySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQB_TaxAgencySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11340360864320028832,
        "service_name": "drive-thru",
        "span_id": 6175302264861484466,
        "trace_id": 9167596184004012213
    }
}

running: False
schema_name_id: 1645
start_time: 2026-04-11 03:04:09
success: True
trace_id: 9167596184004012213

Scan 161785910

duration: 0:00:11.756568

exit_message:

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

id: 161785910

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_TaxAgencySet/2026-04-10/1775808194",
        "key": "raw/molo_moloQB_TaxAgencySet/2026-04-10/1775808194/QB_TaxAgencySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQB_TaxAgencySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3265716636161599541,
        "service_name": "drive-thru",
        "span_id": 12614625240430170312,
        "trace_id": 10874752141154011512
    }
}

running: False
schema_name_id: 1645
start_time: 2026-04-10 03:05:28
success: True
trace_id: 10874752141154011512

Scan 161730390

duration: 0:00:14.270298

exit_message:

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

id: 161730390

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_TaxAgencySet/2026-04-09/1775721532",
        "key": "raw/molo_moloQB_TaxAgencySet/2026-04-09/1775721532/QB_TaxAgencySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQB_TaxAgencySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6123856913773291385,
        "service_name": "drive-thru",
        "span_id": 4713295383664799953,
        "trace_id": 16941245119886869721
    }
}

running: False
schema_name_id: 1645
start_time: 2026-04-09 03:05:45
success: True
trace_id: 16941245119886869721

Scan 161675460

duration: 0:00:14.276951

exit_message:

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

id: 161675460

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_TaxAgencySet/2026-04-08/1775635359",
        "key": "raw/molo_moloQB_TaxAgencySet/2026-04-08/1775635359/QB_TaxAgencySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQB_TaxAgencySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18143042356081757065,
        "service_name": "drive-thru",
        "span_id": 1437451437347065470,
        "trace_id": 9205306075215523508
    }
}

running: False
schema_name_id: 1645
start_time: 2026-04-08 03:04:09
success: True
trace_id: 9205306075215523508

Scan 161618395

duration: 0:00:14.245900

exit_message:

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

id: 161618395

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_TaxAgencySet/2026-04-07/1775548509",
        "key": "raw/molo_moloQB_TaxAgencySet/2026-04-07/1775548509/QB_TaxAgencySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQB_TaxAgencySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5850105761702325987,
        "service_name": "drive-thru",
        "span_id": 9996836292586489309,
        "trace_id": 6017879323503874622
    }
}

running: False
schema_name_id: 1645
start_time: 2026-04-07 02:56:46
success: True
trace_id: 6017879323503874622

Scan 161561492

duration: 0:00:14.207053

exit_message:

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

id: 161561492

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_TaxAgencySet/2026-04-06/1775462476",
        "key": "raw/molo_moloQB_TaxAgencySet/2026-04-06/1775462476/QB_TaxAgencySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQB_TaxAgencySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6839708838187538008,
        "service_name": "drive-thru",
        "span_id": 4191112455395141607,
        "trace_id": 11437494575775247202
    }
}

running: False
schema_name_id: 1645
start_time: 2026-04-06 03:03:34
success: True
trace_id: 11437494575775247202

Scan 161514874

duration: 0:00:14.400482

exit_message:

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

id: 161514874

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_TaxAgencySet/2026-04-05/1775376102",
        "key": "raw/molo_moloQB_TaxAgencySet/2026-04-05/1775376102/QB_TaxAgencySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQB_TaxAgencySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7375566104812903466,
        "service_name": "drive-thru",
        "span_id": 12453278797090329292,
        "trace_id": 14349775931273484139
    }
}

running: False
schema_name_id: 1645
start_time: 2026-04-05 03:04:56
success: True
trace_id: 14349775931273484139

Scan 161460372

duration: 0:00:14.238668

exit_message:

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

id: 161460372

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_TaxAgencySet/2026-04-04/1775289586",
        "key": "raw/molo_moloQB_TaxAgencySet/2026-04-04/1775289586/QB_TaxAgencySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQB_TaxAgencySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16791538438804953695,
        "service_name": "drive-thru",
        "span_id": 13251817562991813245,
        "trace_id": 12133711466743689593
    }
}

running: False
schema_name_id: 1645
start_time: 2026-04-04 03:05:33
success: True
trace_id: 12133711466743689593

Scan 161401746

duration: 0:00:11.702259

exit_message:

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

id: 161401746

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloQB_TaxAgencySet/2026-04-03/1775203359",
        "key": "raw/molo_moloQB_TaxAgencySet/2026-04-03/1775203359/QB_TaxAgencySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloQB_TaxAgencySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8853982778926065432,
        "service_name": "drive-thru",
        "span_id": 1019694431428431842,
        "trace_id": 1783880043100256644
    }
}

running: False
schema_name_id: 1645
start_time: 2026-04-03 03:05:44
success: True
trace_id: 1783880043100256644

Partitions:

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

Schema:

attributes:

{
    "DisplayName": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "QB_ID": "string",
    "SyncToken": "string",
    "TaxTrackedOnPurchases": "string",
    "TaxTrackedOnSales": "string",
    "domain": "string",
    "sparse": "string",
    "time": "string"
}

created: 2026-04-17 03:04:38

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_taxagencyset`\n(\n `Id`  string , `TaxTrackedOnPurchases`  string , `TaxTrackedOnSales`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `DisplayName`  string , `time`  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_moloQB_TaxAgencySet/2026-04-17/1776412814'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_taxagencyset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_taxagencyset"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-10-17 01:56:55",
        "disabled": false,
        "format": "raw",
        "id": 1645,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_moloqb_taxagencyset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "DisplayName": "string",
            "Id": "string",
            "MarinaLocation_Id": "string",
            "QB_ID": "string",
            "SyncToken": "string",
            "TaxTrackedOnPurchases": "string",
            "TaxTrackedOnSales": "string",
            "domain": "string",
            "sparse": "string",
            "time": "string"
        },
        "created": "2026-04-17 03:04:38",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloqb_taxagencyset`\n(\n `Id`  string , `TaxTrackedOnPurchases`  string , `TaxTrackedOnSales`  string , `domain`  string , `sparse`  string , `QB_ID`  string , `SyncToken`  string , `DisplayName`  string , `time`  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_moloQB_TaxAgencySet/2026-04-17/1776412814'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloqb_taxagencyset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloqb_taxagencyset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}