Schema Info
Schema Name: sfdl_prod_drivethru.molo_moloxerotaxcomponentset
- created: 2023-10-17 02:03:46
- disabled: False
- format: raw
- id: 1822
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "molo_moloxerotaxcomponentset" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717803
- created: 2026-04-17 03:12:17
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxcomponentset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxcomponentset`\n(\n `Id` string , `Name` string , `Rate` string , `IsCompound` string , `XeroTaxRateId` 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_moloXeroTaxComponentSet/2026-04-17/1776413279'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxcomponentset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTaxComponentSet/2026-04-17/1776413279
- id: 1717803
- processed: 1
- raw_data:
{ "Id": 0, "IsCompound": 3, "Name": 1, "Rate": 2, "XeroTaxRateId": 4 } - schema_attributes:
{ "Id": "string", "IsCompound": "string", "Name": "string", "Rate": "string", "XeroTaxRateId": "string" } - schema_name_id: 1822
- schema_scan_id: 162167838
- updated: 2026-04-17 03:12:28
-
Version 1716497
- created: 2026-04-16 03:11:29
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxcomponentset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxcomponentset`\n(\n `Id` string , `Name` string , `Rate` string , `IsCompound` string , `XeroTaxRateId` 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_moloXeroTaxComponentSet/2026-04-16/1776326756'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxcomponentset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTaxComponentSet/2026-04-16/1776326756
- id: 1716497
- processed: 1
- raw_data:
{ "Id": 0, "IsCompound": 3, "Name": 1, "Rate": 2, "XeroTaxRateId": 4 } - schema_attributes:
{ "Id": "string", "IsCompound": "string", "Name": "string", "Rate": "string", "XeroTaxRateId": "string" } - schema_name_id: 1822
- schema_scan_id: 162111939
- updated: 2026-04-16 03:11:40
-
Version 1715307
- created: 2026-04-15 03:09:23
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxcomponentset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxcomponentset`\n(\n `Id` string , `Name` string , `Rate` string , `IsCompound` string , `XeroTaxRateId` 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_moloXeroTaxComponentSet/2026-04-15/1776240218'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxcomponentset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTaxComponentSet/2026-04-15/1776240218
- id: 1715307
- processed: 1
- raw_data:
{ "Id": 0, "IsCompound": 3, "Name": 1, "Rate": 2, "XeroTaxRateId": 4 } - schema_attributes:
{ "Id": "string", "IsCompound": "string", "Name": "string", "Rate": "string", "XeroTaxRateId": "string" } - schema_name_id: 1822
- schema_scan_id: 162056093
- updated: 2026-04-15 03:09:34
-
Version 1714178
- created: 2026-04-14 03:12:17
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxcomponentset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxcomponentset`\n(\n `Id` string , `Name` string , `Rate` string , `IsCompound` string , `XeroTaxRateId` 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_moloXeroTaxComponentSet/2026-04-14/1776154179'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxcomponentset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTaxComponentSet/2026-04-14/1776154179
- id: 1714178
- processed: 1
- raw_data:
{ "Id": 0, "IsCompound": 3, "Name": 1, "Rate": 2, "XeroTaxRateId": 4 } - schema_attributes:
{ "Id": "string", "IsCompound": "string", "Name": "string", "Rate": "string", "XeroTaxRateId": "string" } - schema_name_id: 1822
- schema_scan_id: 162000702
- updated: 2026-04-14 03:12:28
-
Version 1712948
- created: 2026-04-13 03:05:58
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxcomponentset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxcomponentset`\n(\n `Id` string , `Name` string , `Rate` string , `IsCompound` string , `XeroTaxRateId` 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_moloXeroTaxComponentSet/2026-04-13/1776067171'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxcomponentset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTaxComponentSet/2026-04-13/1776067171
- id: 1712948
- processed: 1
- raw_data:
{ "Id": 0, "IsCompound": 3, "Name": 1, "Rate": 2, "XeroTaxRateId": 4 } - schema_attributes:
{ "Id": "string", "IsCompound": "string", "Name": "string", "Rate": "string", "XeroTaxRateId": "string" } - schema_name_id: 1822
- schema_scan_id: 161942750
- updated: 2026-04-13 03:06:12
-
Version 1711768
- created: 2026-04-12 03:08:40
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxcomponentset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxcomponentset`\n(\n `Id` string , `Name` string , `Rate` string , `IsCompound` string , `XeroTaxRateId` 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_moloXeroTaxComponentSet/2026-04-12/1775980875'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxcomponentset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTaxComponentSet/2026-04-12/1775980875
- id: 1711768
- processed: 1
- raw_data:
{ "Id": 0, "IsCompound": 3, "Name": 1, "Rate": 2, "XeroTaxRateId": 4 } - schema_attributes:
{ "Id": "string", "IsCompound": "string", "Name": "string", "Rate": "string", "XeroTaxRateId": "string" } - schema_name_id: 1822
- schema_scan_id: 161893473
- updated: 2026-04-12 03:08:54
-
Version 1710588
- created: 2026-04-11 03:12:35
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxcomponentset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxcomponentset`\n(\n `Id` string , `Name` string , `Rate` string , `IsCompound` string , `XeroTaxRateId` 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_moloXeroTaxComponentSet/2026-04-11/1775894652'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxcomponentset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTaxComponentSet/2026-04-11/1775894652
- id: 1710588
- processed: 1
- raw_data:
{ "Id": 0, "IsCompound": 3, "Name": 1, "Rate": 2, "XeroTaxRateId": 4 } - schema_attributes:
{ "Id": "string", "IsCompound": "string", "Name": "string", "Rate": "string", "XeroTaxRateId": "string" } - schema_name_id: 1822
- schema_scan_id: 161841399
- updated: 2026-04-11 03:12:46
-
Version 1709412
- created: 2026-04-10 03:12:38
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxcomponentset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxcomponentset`\n(\n `Id` string , `Name` string , `Rate` string , `IsCompound` string , `XeroTaxRateId` 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_moloXeroTaxComponentSet/2026-04-10/1775808407'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxcomponentset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTaxComponentSet/2026-04-10/1775808407
- id: 1709412
- processed: 1
- raw_data:
{ "Id": 0, "IsCompound": 3, "Name": 1, "Rate": 2, "XeroTaxRateId": 4 } - schema_attributes:
{ "Id": "string", "IsCompound": "string", "Name": "string", "Rate": "string", "XeroTaxRateId": "string" } - schema_name_id: 1822
- schema_scan_id: 161786117
- updated: 2026-04-10 03:12:52
-
Version 1708269
- created: 2026-04-09 03:09:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxcomponentset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxcomponentset`\n(\n `Id` string , `Name` string , `Rate` string , `IsCompound` string , `XeroTaxRateId` 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_moloXeroTaxComponentSet/2026-04-09/1775721737'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxcomponentset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTaxComponentSet/2026-04-09/1775721737
- id: 1708269
- processed: 1
- raw_data:
{ "Id": 0, "IsCompound": 3, "Name": 1, "Rate": 2, "XeroTaxRateId": 4 } - schema_attributes:
{ "Id": "string", "IsCompound": "string", "Name": "string", "Rate": "string", "XeroTaxRateId": "string" } - schema_name_id: 1822
- schema_scan_id: 161730558
- updated: 2026-04-09 03:10:07
-
Version 1706942
- created: 2026-04-08 03:07:17
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxcomponentset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxcomponentset`\n(\n `Id` string , `Name` string , `Rate` string , `IsCompound` string , `XeroTaxRateId` 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_moloXeroTaxComponentSet/2026-04-08/1775635564'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxcomponentset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTaxComponentSet/2026-04-08/1775635564
- id: 1706942
- processed: 1
- raw_data:
{ "Id": 0, "IsCompound": 3, "Name": 1, "Rate": 2, "XeroTaxRateId": 4 } - schema_attributes:
{ "Id": "string", "IsCompound": "string", "Name": "string", "Rate": "string", "XeroTaxRateId": "string" } - schema_name_id: 1822
- schema_scan_id: 161675587
- updated: 2026-04-08 03:07:28
-
Version 1705822
- created: 2026-04-07 03:02:09
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxcomponentset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxcomponentset`\n(\n `Id` string , `Name` string , `Rate` string , `IsCompound` string , `XeroTaxRateId` 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_moloXeroTaxComponentSet/2026-04-07/1775548725'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxcomponentset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTaxComponentSet/2026-04-07/1775548725
- id: 1705822
- processed: 1
- raw_data:
{ "Id": 0, "IsCompound": 3, "Name": 1, "Rate": 2, "XeroTaxRateId": 4 } - schema_attributes:
{ "Id": "string", "IsCompound": "string", "Name": "string", "Rate": "string", "XeroTaxRateId": "string" } - schema_name_id: 1822
- schema_scan_id: 161619221
- updated: 2026-04-07 03:02:23
-
Version 1704652
- created: 2026-04-06 03:12:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxcomponentset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxcomponentset`\n(\n `Id` string , `Name` string , `Rate` string , `IsCompound` string , `XeroTaxRateId` 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_moloXeroTaxComponentSet/2026-04-06/1775462676'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxcomponentset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTaxComponentSet/2026-04-06/1775462676
- id: 1704652
- processed: 1
- raw_data:
{ "Id": 0, "IsCompound": 3, "Name": 1, "Rate": 2, "XeroTaxRateId": 4 } - schema_attributes:
{ "Id": "string", "IsCompound": "string", "Name": "string", "Rate": "string", "XeroTaxRateId": "string" } - schema_name_id: 1822
- schema_scan_id: 161561802
- updated: 2026-04-06 03:12:18
-
Version 1703385
- created: 2026-04-05 03:08:31
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxcomponentset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxcomponentset`\n(\n `Id` string , `Name` string , `Rate` string , `IsCompound` string , `XeroTaxRateId` 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_moloXeroTaxComponentSet/2026-04-05/1775376306'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxcomponentset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTaxComponentSet/2026-04-05/1775376306
- id: 1703385
- processed: 1
- raw_data:
{ "Id": 0, "IsCompound": 3, "Name": 1, "Rate": 2, "XeroTaxRateId": 4 } - schema_attributes:
{ "Id": "string", "IsCompound": "string", "Name": "string", "Rate": "string", "XeroTaxRateId": "string" } - schema_name_id: 1822
- schema_scan_id: 161514969
- updated: 2026-04-05 03:08:44
-
Version 1702305
- created: 2026-04-04 03:12:18
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxcomponentset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxcomponentset`\n(\n `Id` string , `Name` string , `Rate` string , `IsCompound` string , `XeroTaxRateId` 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_moloXeroTaxComponentSet/2026-04-04/1775289793'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxcomponentset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTaxComponentSet/2026-04-04/1775289793
- id: 1702305
- processed: 1
- raw_data:
{ "Id": 0, "IsCompound": 3, "Name": 1, "Rate": 2, "XeroTaxRateId": 4 } - schema_attributes:
{ "Id": "string", "IsCompound": "string", "Name": "string", "Rate": "string", "XeroTaxRateId": "string" } - schema_name_id: 1822
- schema_scan_id: 161460634
- updated: 2026-04-04 03:12:32
-
Version 1701040
- created: 2026-04-03 03:14:12
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxcomponentset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerotaxcomponentset`\n(\n `Id` string , `Name` string , `Rate` string , `IsCompound` string , `XeroTaxRateId` 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_moloXeroTaxComponentSet/2026-04-03/1775203556'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxcomponentset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroTaxComponentSet/2026-04-03/1775203556
- id: 1701040
- processed: 1
- raw_data:
{ "Id": 0, "IsCompound": 3, "Name": 1, "Rate": 2, "XeroTaxRateId": 4 } - schema_attributes:
{ "Id": "string", "IsCompound": "string", "Name": "string", "Rate": "string", "XeroTaxRateId": "string" } - schema_name_id: 1822
- schema_scan_id: 161402021
- updated: 2026-04-03 03:14:26
Schema Scans: 15
Last at 2026-04-17 03:12:16
-
Scan 162167838
- duration: 0:00:11.608009
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162167838
- 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_moloXeroTaxComponentSet/2026-04-17/1776413279", "key": "raw/molo_moloXeroTaxComponentSet/2026-04-17/1776413279/XeroTaxComponentSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloXeroTaxComponentSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6662154673908138962, "service_name": "drive-thru", "span_id": 10518728121867629118, "trace_id": 10627848391722647781 } } - running: False
- schema_name_id: 1822
- start_time: 2026-04-17 03:12:16
- success: True
- trace_id: 10627848391722647781
-
Scan 162111939
- duration: 0:00:11.669578
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162111939
- 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_moloXeroTaxComponentSet/2026-04-16/1776326756", "key": "raw/molo_moloXeroTaxComponentSet/2026-04-16/1776326756/XeroTaxComponentSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloXeroTaxComponentSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17287772567006337798, "service_name": "drive-thru", "span_id": 17200142517292699479, "trace_id": 4521128788311014700 } } - running: False
- schema_name_id: 1822
- start_time: 2026-04-16 03:11:28
- success: True
- trace_id: 4521128788311014700
-
Scan 162056093
- duration: 0:00:11.522709
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162056093
- 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_moloXeroTaxComponentSet/2026-04-15/1776240218", "key": "raw/molo_moloXeroTaxComponentSet/2026-04-15/1776240218/XeroTaxComponentSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloXeroTaxComponentSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3232939598343538050, "service_name": "drive-thru", "span_id": 2108856060902463654, "trace_id": 3579901111606329638 } } - running: False
- schema_name_id: 1822
- start_time: 2026-04-15 03:09:22
- success: True
- trace_id: 3579901111606329638
-
Scan 162000702
- duration: 0:00:11.862027
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162000702
- 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_moloXeroTaxComponentSet/2026-04-14/1776154179", "key": "raw/molo_moloXeroTaxComponentSet/2026-04-14/1776154179/XeroTaxComponentSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloXeroTaxComponentSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 18221234294806564194, "service_name": "drive-thru", "span_id": 6997493323104144936, "trace_id": 17960297317107406308 } } - running: False
- schema_name_id: 1822
- start_time: 2026-04-14 03:12:16
- success: True
- trace_id: 17960297317107406308
-
Scan 161942750
- duration: 0:00:14.230064
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161942750
- 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_moloXeroTaxComponentSet/2026-04-13/1776067171", "key": "raw/molo_moloXeroTaxComponentSet/2026-04-13/1776067171/XeroTaxComponentSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloXeroTaxComponentSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1809885700205780424, "service_name": "drive-thru", "span_id": 7965661098998778706, "trace_id": 16287062312576935000 } } - running: False
- schema_name_id: 1822
- start_time: 2026-04-13 03:05:58
- success: True
- trace_id: 16287062312576935000
-
Scan 161893473
- duration: 0:00:14.095496
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161893473
- 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_moloXeroTaxComponentSet/2026-04-12/1775980875", "key": "raw/molo_moloXeroTaxComponentSet/2026-04-12/1775980875/XeroTaxComponentSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloXeroTaxComponentSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15471372300531665829, "service_name": "drive-thru", "span_id": 18442914543671813319, "trace_id": 11822484990429537277 } } - running: False
- schema_name_id: 1822
- start_time: 2026-04-12 03:08:40
- success: True
- trace_id: 11822484990429537277
-
Scan 161841399
- duration: 0:00:11.691151
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161841399
- 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_moloXeroTaxComponentSet/2026-04-11/1775894652", "key": "raw/molo_moloXeroTaxComponentSet/2026-04-11/1775894652/XeroTaxComponentSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloXeroTaxComponentSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15354685662265884599, "service_name": "drive-thru", "span_id": 18133073049400909993, "trace_id": 7651187342107440099 } } - running: False
- schema_name_id: 1822
- start_time: 2026-04-11 03:12:35
- success: True
- trace_id: 7651187342107440099
-
Scan 161786117
- duration: 0:00:14.176140
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161786117
- 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_moloXeroTaxComponentSet/2026-04-10/1775808407", "key": "raw/molo_moloXeroTaxComponentSet/2026-04-10/1775808407/XeroTaxComponentSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloXeroTaxComponentSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10129229280348898565, "service_name": "drive-thru", "span_id": 5668569594857511872, "trace_id": 14160073188681260426 } } - running: False
- schema_name_id: 1822
- start_time: 2026-04-10 03:12:38
- success: True
- trace_id: 14160073188681260426
-
Scan 161730558
- duration: 0:00:11.681996
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161730558
- 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_moloXeroTaxComponentSet/2026-04-09/1775721737", "key": "raw/molo_moloXeroTaxComponentSet/2026-04-09/1775721737/XeroTaxComponentSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloXeroTaxComponentSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14303834994159309612, "service_name": "drive-thru", "span_id": 4755488203531014340, "trace_id": 14254512110264278371 } } - running: False
- schema_name_id: 1822
- start_time: 2026-04-09 03:09:56
- success: True
- trace_id: 14254512110264278371
-
Scan 161675587
- duration: 0:00:11.574134
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161675587
- 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_moloXeroTaxComponentSet/2026-04-08/1775635564", "key": "raw/molo_moloXeroTaxComponentSet/2026-04-08/1775635564/XeroTaxComponentSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloXeroTaxComponentSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10474342149004570434, "service_name": "drive-thru", "span_id": 8575963325913803445, "trace_id": 4734464473670719262 } } - running: False
- schema_name_id: 1822
- start_time: 2026-04-08 03:07:16
- success: True
- trace_id: 4734464473670719262
-
Scan 161619221
- duration: 0:00:14.069271
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161619221
- 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_moloXeroTaxComponentSet/2026-04-07/1775548725", "key": "raw/molo_moloXeroTaxComponentSet/2026-04-07/1775548725/XeroTaxComponentSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloXeroTaxComponentSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12663477858476915586, "service_name": "drive-thru", "span_id": 4540698789134410920, "trace_id": 31971186299647414 } } - running: False
- schema_name_id: 1822
- start_time: 2026-04-07 03:02:09
- success: True
- trace_id: 31971186299647414
-
Scan 161561802
- duration: 0:00:11.667628
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161561802
- 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_moloXeroTaxComponentSet/2026-04-06/1775462676", "key": "raw/molo_moloXeroTaxComponentSet/2026-04-06/1775462676/XeroTaxComponentSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloXeroTaxComponentSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15026927709864719464, "service_name": "drive-thru", "span_id": 16499537874315725525, "trace_id": 11463845629469273288 } } - running: False
- schema_name_id: 1822
- start_time: 2026-04-06 03:12:07
- success: True
- trace_id: 11463845629469273288
-
Scan 161514969
- duration: 0:00:14.267059
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161514969
- 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_moloXeroTaxComponentSet/2026-04-05/1775376306", "key": "raw/molo_moloXeroTaxComponentSet/2026-04-05/1775376306/XeroTaxComponentSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloXeroTaxComponentSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5474623737284127884, "service_name": "drive-thru", "span_id": 12440073393781881483, "trace_id": 977117724094868977 } } - running: False
- schema_name_id: 1822
- start_time: 2026-04-05 03:08:30
- success: True
- trace_id: 977117724094868977
-
Scan 161460634
- duration: 0:00:14.269964
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161460634
- 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_moloXeroTaxComponentSet/2026-04-04/1775289793", "key": "raw/molo_moloXeroTaxComponentSet/2026-04-04/1775289793/XeroTaxComponentSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloXeroTaxComponentSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10220007254902662999, "service_name": "drive-thru", "span_id": 7561209984369213625, "trace_id": 16871478677689618750 } } - running: False
- schema_name_id: 1822
- start_time: 2026-04-04 03:12:18
- success: True
- trace_id: 16871478677689618750
-
Scan 161402021
- duration: 0:00:14.241247
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161402021
- 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_moloXeroTaxComponentSet/2026-04-03/1775203556", "key": "raw/molo_moloXeroTaxComponentSet/2026-04-03/1775203556/XeroTaxComponentSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloXeroTaxComponentSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14896351747470729398, "service_name": "drive-thru", "span_id": 14780181913548006529, "trace_id": 8671250666233976491 } } - running: False
- schema_name_id: 1822
- start_time: 2026-04-03 03:14:12
- success: True
- trace_id: 8671250666233976491
- attributes:
{ "Id": "string", "IsCompound": "string", "Name": "string", "Rate": "string", "XeroTaxRateId": "string" } - created: 2026-04-17 03:12: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_moloxerotaxcomponentset`\n(\n `Id` string , `Name` string , `Rate` string , `IsCompound` string , `XeroTaxRateId` 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_moloXeroTaxComponentSet/2026-04-17/1776413279'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxcomponentset`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxcomponentset" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2023-10-17 02:03:46",
"disabled": false,
"format": "raw",
"id": 1822,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "molo_moloxerotaxcomponentset"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"Id": "string",
"IsCompound": "string",
"Name": "string",
"Rate": "string",
"XeroTaxRateId": "string"
},
"created": "2026-04-17 03:12: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_moloxerotaxcomponentset`\n(\n `Id` string , `Name` string , `Rate` string , `IsCompound` string , `XeroTaxRateId` 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_moloXeroTaxComponentSet/2026-04-17/1776413279'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerotaxcomponentset`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerotaxcomponentset"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}