Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset

created: 2023-10-17 02:02:16
disabled: False
format: raw
id: 1792
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717786

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`\n(\n `Id`  string , `Name`  string , `Status`  string , `XeroTrackingCategoryId`  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_moloXeroTrackingCategoryOptionSet/2026-04-17/1776413280'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTrackingCategoryOptionSet/2026-04-17/1776413280
id: 1717786
processed: 1

raw_data:

{
    "Id": 0,
    "Name": 1,
    "Status": 2,
    "XeroTrackingCategoryId": 3
}

schema_attributes:

{
    "Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroTrackingCategoryId": "string"
}

schema_name_id: 1792
schema_scan_id: 162167819
updated: 2026-04-17 03:11:29

Version 1716501

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`\n(\n `Id`  string , `Name`  string , `Status`  string , `XeroTrackingCategoryId`  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_moloXeroTrackingCategoryOptionSet/2026-04-16/1776326756'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTrackingCategoryOptionSet/2026-04-16/1776326756
id: 1716501
processed: 1

raw_data:

{
    "Id": 0,
    "Name": 1,
    "Status": 2,
    "XeroTrackingCategoryId": 3
}

schema_attributes:

{
    "Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroTrackingCategoryId": "string"
}

schema_name_id: 1792
schema_scan_id: 162111943
updated: 2026-04-16 03:11:50

Version 1715368

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`\n(\n `Id`  string , `Name`  string , `Status`  string , `XeroTrackingCategoryId`  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_moloXeroTrackingCategoryOptionSet/2026-04-15/1776240218'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset"
]

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

raw_data:

{
    "Id": 0,
    "Name": 1,
    "Status": 2,
    "XeroTrackingCategoryId": 3
}

schema_attributes:

{
    "Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroTrackingCategoryId": "string"
}

schema_name_id: 1792
schema_scan_id: 162056168
updated: 2026-04-15 03:12:43

Version 1714214

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`\n(\n `Id`  string , `Name`  string , `Status`  string , `XeroTrackingCategoryId`  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_moloXeroTrackingCategoryOptionSet/2026-04-14/1776154180'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTrackingCategoryOptionSet/2026-04-14/1776154180
id: 1714214
processed: 1

raw_data:

{
    "Id": 0,
    "Name": 1,
    "Status": 2,
    "XeroTrackingCategoryId": 3
}

schema_attributes:

{
    "Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroTrackingCategoryId": "string"
}

schema_name_id: 1792
schema_scan_id: 162000739
updated: 2026-04-14 03:13:56

Version 1712965

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`\n(\n `Id`  string , `Name`  string , `Status`  string , `XeroTrackingCategoryId`  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_moloXeroTrackingCategoryOptionSet/2026-04-13/1776067173'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTrackingCategoryOptionSet/2026-04-13/1776067173
id: 1712965
processed: 1

raw_data:

{
    "Id": 0,
    "Name": 1,
    "Status": 2,
    "XeroTrackingCategoryId": 3
}

schema_attributes:

{
    "Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroTrackingCategoryId": "string"
}

schema_name_id: 1792
schema_scan_id: 161942794
updated: 2026-04-13 03:07:03

Version 1711740

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`\n(\n `Id`  string , `Name`  string , `Status`  string , `XeroTrackingCategoryId`  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_moloXeroTrackingCategoryOptionSet/2026-04-12/1775980875'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTrackingCategoryOptionSet/2026-04-12/1775980875
id: 1711740
processed: 1

raw_data:

{
    "Id": 0,
    "Name": 1,
    "Status": 2,
    "XeroTrackingCategoryId": 3
}

schema_attributes:

{
    "Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroTrackingCategoryId": "string"
}

schema_name_id: 1792
schema_scan_id: 161893431
updated: 2026-04-12 03:07:43

Version 1710589

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`\n(\n `Id`  string , `Name`  string , `Status`  string , `XeroTrackingCategoryId`  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_moloXeroTrackingCategoryOptionSet/2026-04-11/1775894654'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTrackingCategoryOptionSet/2026-04-11/1775894654
id: 1710589
processed: 1

raw_data:

{
    "Id": 0,
    "Name": 1,
    "Status": 2,
    "XeroTrackingCategoryId": 3
}

schema_attributes:

{
    "Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroTrackingCategoryId": "string"
}

schema_name_id: 1792
schema_scan_id: 161841400
updated: 2026-04-11 03:12:51

Version 1709423

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`\n(\n `Id`  string , `Name`  string , `Status`  string , `XeroTrackingCategoryId`  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_moloXeroTrackingCategoryOptionSet/2026-04-10/1775808407'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset"
]

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

raw_data:

{
    "Id": 0,
    "Name": 1,
    "Status": 2,
    "XeroTrackingCategoryId": 3
}

schema_attributes:

{
    "Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroTrackingCategoryId": "string"
}

schema_name_id: 1792
schema_scan_id: 161786131
updated: 2026-04-10 03:13:22

Version 1708227

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`\n(\n `Id`  string , `Name`  string , `Status`  string , `XeroTrackingCategoryId`  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_moloXeroTrackingCategoryOptionSet/2026-04-09/1775721738'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTrackingCategoryOptionSet/2026-04-09/1775721738
id: 1708227
processed: 1

raw_data:

{
    "Id": 0,
    "Name": 1,
    "Status": 2,
    "XeroTrackingCategoryId": 3
}

schema_attributes:

{
    "Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroTrackingCategoryId": "string"
}

schema_name_id: 1792
schema_scan_id: 161730485
updated: 2026-04-09 03:08:12

Version 1707080

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`\n(\n `Id`  string , `Name`  string , `Status`  string , `XeroTrackingCategoryId`  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_moloXeroTrackingCategoryOptionSet/2026-04-08/1775635565'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset"
]

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

raw_data:

{
    "Id": 0,
    "Name": 1,
    "Status": 2,
    "XeroTrackingCategoryId": 3
}

schema_attributes:

{
    "Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroTrackingCategoryId": "string"
}

schema_name_id: 1792
schema_scan_id: 161675758
updated: 2026-04-08 03:13:23

Version 1705875

created: 2026-04-07 03:04:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`\n(\n `Id`  string , `Name`  string , `Status`  string , `XeroTrackingCategoryId`  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_moloXeroTrackingCategoryOptionSet/2026-04-07/1775548726'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTrackingCategoryOptionSet/2026-04-07/1775548726
id: 1705875
processed: 1

raw_data:

{
    "Id": 0,
    "Name": 1,
    "Status": 2,
    "XeroTrackingCategoryId": 3
}

schema_attributes:

{
    "Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroTrackingCategoryId": "string"
}

schema_name_id: 1792
schema_scan_id: 161619448
updated: 2026-04-07 03:05:01

Version 1704668

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`\n(\n `Id`  string , `Name`  string , `Status`  string , `XeroTrackingCategoryId`  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_moloXeroTrackingCategoryOptionSet/2026-04-06/1775462677'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset"
]

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

raw_data:

{
    "Id": 0,
    "Name": 1,
    "Status": 2,
    "XeroTrackingCategoryId": 3
}

schema_attributes:

{
    "Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroTrackingCategoryId": "string"
}

schema_name_id: 1792
schema_scan_id: 161561824
updated: 2026-04-06 03:12:59

Version 1703436

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`\n(\n `Id`  string , `Name`  string , `Status`  string , `XeroTrackingCategoryId`  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_moloXeroTrackingCategoryOptionSet/2026-04-05/1775376306'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset"
]

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

raw_data:

{
    "Id": 0,
    "Name": 1,
    "Status": 2,
    "XeroTrackingCategoryId": 3
}

schema_attributes:

{
    "Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroTrackingCategoryId": "string"
}

schema_name_id: 1792
schema_scan_id: 161515025
updated: 2026-04-05 03:10:40

Version 1702265

created: 2026-04-04 03:10:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`\n(\n `Id`  string , `Name`  string , `Status`  string , `XeroTrackingCategoryId`  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_moloXeroTrackingCategoryOptionSet/2026-04-04/1775289792'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset"
]

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

raw_data:

{
    "Id": 0,
    "Name": 1,
    "Status": 2,
    "XeroTrackingCategoryId": 3
}

schema_attributes:

{
    "Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroTrackingCategoryId": "string"
}

schema_name_id: 1792
schema_scan_id: 161460570
updated: 2026-04-04 03:10:32

Version 1700968

created: 2026-04-03 03:10:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`\n(\n `Id`  string , `Name`  string , `Status`  string , `XeroTrackingCategoryId`  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_moloXeroTrackingCategoryOptionSet/2026-04-03/1775203555'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTrackingCategoryOptionSet/2026-04-03/1775203555
id: 1700968
processed: 1

raw_data:

{
    "Id": 0,
    "Name": 1,
    "Status": 2,
    "XeroTrackingCategoryId": 3
}

schema_attributes:

{
    "Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroTrackingCategoryId": "string"
}

schema_name_id: 1792
schema_scan_id: 161401935
updated: 2026-04-03 03:11:07

Schema Scans: 15

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

Scan 162167819

duration: 0:00:11.558232

exit_message:

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

id: 162167819

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_moloXeroTrackingCategoryOptionSet/2026-04-17/1776413280",
        "key": "raw/molo_moloXeroTrackingCategoryOptionSet/2026-04-17/1776413280/XeroTrackingCategoryOptionSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroTrackingCategoryOptionSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9557579461465971694,
        "service_name": "drive-thru",
        "span_id": 3853222573576806046,
        "trace_id": 5055544105327310187
    }
}

running: False
schema_name_id: 1792
start_time: 2026-04-17 03:11:17
success: True
trace_id: 5055544105327310187

Scan 162111943

duration: 0:00:11.571107

exit_message:

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

id: 162111943

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_moloXeroTrackingCategoryOptionSet/2026-04-16/1776326756",
        "key": "raw/molo_moloXeroTrackingCategoryOptionSet/2026-04-16/1776326756/XeroTrackingCategoryOptionSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroTrackingCategoryOptionSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17313378673278954556,
        "service_name": "drive-thru",
        "span_id": 7837258735867081825,
        "trace_id": 17677294692940551935
    }
}

running: False
schema_name_id: 1792
start_time: 2026-04-16 03:11:38
success: True
trace_id: 17677294692940551935

Scan 162056168

duration: 0:00:11.774751

exit_message:

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

id: 162056168

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_moloXeroTrackingCategoryOptionSet/2026-04-15/1776240218",
        "key": "raw/molo_moloXeroTrackingCategoryOptionSet/2026-04-15/1776240218/XeroTrackingCategoryOptionSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroTrackingCategoryOptionSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5243854736087609763,
        "service_name": "drive-thru",
        "span_id": 13956684375035725354,
        "trace_id": 9076165974823782945
    }
}

running: False
schema_name_id: 1792
start_time: 2026-04-15 03:12:31
success: True
trace_id: 9076165974823782945

Scan 162000739

duration: 0:00:14.102375

exit_message:

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

id: 162000739

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_moloXeroTrackingCategoryOptionSet/2026-04-14/1776154180",
        "key": "raw/molo_moloXeroTrackingCategoryOptionSet/2026-04-14/1776154180/XeroTrackingCategoryOptionSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroTrackingCategoryOptionSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8199640701916442412,
        "service_name": "drive-thru",
        "span_id": 12666759202272441256,
        "trace_id": 16694362847542765144
    }
}

running: False
schema_name_id: 1792
start_time: 2026-04-14 03:13:42
success: True
trace_id: 16694362847542765144

Scan 161942794

duration: 0:00:11.537017

exit_message:

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

id: 161942794

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_moloXeroTrackingCategoryOptionSet/2026-04-13/1776067173",
        "key": "raw/molo_moloXeroTrackingCategoryOptionSet/2026-04-13/1776067173/XeroTrackingCategoryOptionSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroTrackingCategoryOptionSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6623364708120102419,
        "service_name": "drive-thru",
        "span_id": 18018264418814085745,
        "trace_id": 10890036469827352618
    }
}

running: False
schema_name_id: 1792
start_time: 2026-04-13 03:06:51
success: True
trace_id: 10890036469827352618

Scan 161893431

duration: 0:00:14.135780

exit_message:

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

id: 161893431

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_moloXeroTrackingCategoryOptionSet/2026-04-12/1775980875",
        "key": "raw/molo_moloXeroTrackingCategoryOptionSet/2026-04-12/1775980875/XeroTrackingCategoryOptionSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroTrackingCategoryOptionSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11519227921213474922,
        "service_name": "drive-thru",
        "span_id": 3365425569957320698,
        "trace_id": 9595057551540329470
    }
}

running: False
schema_name_id: 1792
start_time: 2026-04-12 03:07:29
success: True
trace_id: 9595057551540329470

Scan 161841400

duration: 0:00:14.118073

exit_message:

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

id: 161841400

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_moloXeroTrackingCategoryOptionSet/2026-04-11/1775894654",
        "key": "raw/molo_moloXeroTrackingCategoryOptionSet/2026-04-11/1775894654/XeroTrackingCategoryOptionSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroTrackingCategoryOptionSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8937569597402269399,
        "service_name": "drive-thru",
        "span_id": 828901301912620796,
        "trace_id": 6986633726044908103
    }
}

running: False
schema_name_id: 1792
start_time: 2026-04-11 03:12:36
success: True
trace_id: 6986633726044908103

Scan 161786131

duration: 0:00:14.170013

exit_message:

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

id: 161786131

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_moloXeroTrackingCategoryOptionSet/2026-04-10/1775808407",
        "key": "raw/molo_moloXeroTrackingCategoryOptionSet/2026-04-10/1775808407/XeroTrackingCategoryOptionSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroTrackingCategoryOptionSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8630354707741913071,
        "service_name": "drive-thru",
        "span_id": 5803380114850960228,
        "trace_id": 6413424688675233373
    }
}

running: False
schema_name_id: 1792
start_time: 2026-04-10 03:13:08
success: True
trace_id: 6413424688675233373

Scan 161730485

duration: 0:00:11.776110

exit_message:

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

id: 161730485

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_moloXeroTrackingCategoryOptionSet/2026-04-09/1775721738",
        "key": "raw/molo_moloXeroTrackingCategoryOptionSet/2026-04-09/1775721738/XeroTrackingCategoryOptionSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroTrackingCategoryOptionSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17881602996947003003,
        "service_name": "drive-thru",
        "span_id": 10065297770571476716,
        "trace_id": 11130430812157986833
    }
}

running: False
schema_name_id: 1792
start_time: 2026-04-09 03:08:00
success: True
trace_id: 11130430812157986833

Scan 161675758

duration: 0:00:14.140921

exit_message:

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

id: 161675758

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_moloXeroTrackingCategoryOptionSet/2026-04-08/1775635565",
        "key": "raw/molo_moloXeroTrackingCategoryOptionSet/2026-04-08/1775635565/XeroTrackingCategoryOptionSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroTrackingCategoryOptionSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2236255178758757837,
        "service_name": "drive-thru",
        "span_id": 9971252707093640714,
        "trace_id": 6066469393602417972
    }
}

running: False
schema_name_id: 1792
start_time: 2026-04-08 03:13:09
success: True
trace_id: 6066469393602417972

Scan 161619448

duration: 0:00:14.095407

exit_message:

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

id: 161619448

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_moloXeroTrackingCategoryOptionSet/2026-04-07/1775548726",
        "key": "raw/molo_moloXeroTrackingCategoryOptionSet/2026-04-07/1775548726/XeroTrackingCategoryOptionSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroTrackingCategoryOptionSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2566347888665470402,
        "service_name": "drive-thru",
        "span_id": 2549510438697575812,
        "trace_id": 3460509553413899878
    }
}

running: False
schema_name_id: 1792
start_time: 2026-04-07 03:04:47
success: True
trace_id: 3460509553413899878

Scan 161561824

duration: 0:00:14.105710

exit_message:

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

id: 161561824

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_moloXeroTrackingCategoryOptionSet/2026-04-06/1775462677",
        "key": "raw/molo_moloXeroTrackingCategoryOptionSet/2026-04-06/1775462677/XeroTrackingCategoryOptionSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroTrackingCategoryOptionSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9058689173210906155,
        "service_name": "drive-thru",
        "span_id": 3467934825689345061,
        "trace_id": 4069851596538592212
    }
}

running: False
schema_name_id: 1792
start_time: 2026-04-06 03:12:45
success: True
trace_id: 4069851596538592212

Scan 161515025

duration: 0:00:14.070756

exit_message:

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

id: 161515025

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_moloXeroTrackingCategoryOptionSet/2026-04-05/1775376306",
        "key": "raw/molo_moloXeroTrackingCategoryOptionSet/2026-04-05/1775376306/XeroTrackingCategoryOptionSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroTrackingCategoryOptionSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17709806080219719503,
        "service_name": "drive-thru",
        "span_id": 11246541466797634834,
        "trace_id": 7231262252815018834
    }
}

running: False
schema_name_id: 1792
start_time: 2026-04-05 03:10:26
success: True
trace_id: 7231262252815018834

Scan 161460570

duration: 0:00:14.127806

exit_message:

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

id: 161460570

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_moloXeroTrackingCategoryOptionSet/2026-04-04/1775289792",
        "key": "raw/molo_moloXeroTrackingCategoryOptionSet/2026-04-04/1775289792/XeroTrackingCategoryOptionSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroTrackingCategoryOptionSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18195894809341054679,
        "service_name": "drive-thru",
        "span_id": 12491910780379877938,
        "trace_id": 8621377446192203991
    }
}

running: False
schema_name_id: 1792
start_time: 2026-04-04 03:10:18
success: True
trace_id: 8621377446192203991

Scan 161401935

duration: 0:00:14.185508

exit_message:

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

id: 161401935

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_moloXeroTrackingCategoryOptionSet/2026-04-03/1775203555",
        "key": "raw/molo_moloXeroTrackingCategoryOptionSet/2026-04-03/1775203555/XeroTrackingCategoryOptionSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroTrackingCategoryOptionSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7014494627070647461,
        "service_name": "drive-thru",
        "span_id": 5479415931682537062,
        "trace_id": 16468346428179014756
    }
}

running: False
schema_name_id: 1792
start_time: 2026-04-03 03:10:53
success: True
trace_id: 16468346428179014756

Partitions:

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

Schema:

attributes:

{
    "Id": "string",
    "Name": "string",
    "Status": "string",
    "XeroTrackingCategoryId": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`\n(\n `Id`  string , `Name`  string , `Status`  string , `XeroTrackingCategoryId`  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_moloXeroTrackingCategoryOptionSet/2026-04-17/1776413280'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset"
}

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:16",
        "disabled": false,
        "format": "raw",
        "id": 1792,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_moloxerotrackingcategoryoptionset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Id": "string",
            "Name": "string",
            "Status": "string",
            "XeroTrackingCategoryId": "string"
        },
        "created": "2026-04-17 03:11:17",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`\n(\n `Id`  string , `Name`  string , `Status`  string , `XeroTrackingCategoryId`  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_moloXeroTrackingCategoryOptionSet/2026-04-17/1776413280'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotrackingcategoryoptionset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}