Schema Info

Schema Name: sfdl_prod_drivethru.molo_molocompanies

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717581

created: 2026-04-17 03:00:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocompanies`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocompanies`\n(\n `Id`  string , `Name`  string , `Owner`  string , `PrimaryFaxNumber`  string , `PrimaryPhoneNumber`  string , `City_Id`  string , `Image`  string , `Description`  string , `PartnerId`  string , `MoloAPI_Partner_Id`  string , `CompanyMoloAPI_Partner_Company_Id`  string , `InvoiceAtCompanyLevel`  string , `MoloContactId`  string , `StripeCustomerId`  string , `LoginProviderId`  string , `DefaultCCFee`  string , `Tier1PercentACHFee`  string , `Tier2PercentACHFee`  string , `EnableGlobalContacts`  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_moloCompanies/2026-04-17/1776412695'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocompanies"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCompanies/2026-04-17/1776412695
id: 1717581
processed: 1

raw_data:

{
    "City_Id": 5,
    "CompanyMoloAPI_Partner_Company_Id": 10,
    "DefaultCCFee": 15,
    "Description": 7,
    "EnableGlobalContacts": 18,
    "Id": 0,
    "Image": 6,
    "InvoiceAtCompanyLevel": 11,
    "LoginProviderId": 14,
    "MoloAPI_Partner_Id": 9,
    "MoloContactId": 12,
    "Name": 1,
    "Owner": 2,
    "PartnerId": 8,
    "PrimaryFaxNumber": 3,
    "PrimaryPhoneNumber": 4,
    "StripeCustomerId": 13,
    "Tier1PercentACHFee": 16,
    "Tier2PercentACHFee": 17
}

schema_attributes:

{
    "City_Id": "string",
    "CompanyMoloAPI_Partner_Company_Id": "string",
    "DefaultCCFee": "string",
    "Description": "string",
    "EnableGlobalContacts": "string",
    "Id": "string",
    "Image": "string",
    "InvoiceAtCompanyLevel": "string",
    "LoginProviderId": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloContactId": "string",
    "Name": "string",
    "Owner": "string",
    "PartnerId": "string",
    "PrimaryFaxNumber": "string",
    "PrimaryPhoneNumber": "string",
    "StripeCustomerId": "string",
    "Tier1PercentACHFee": "string",
    "Tier2PercentACHFee": "string"
}

schema_name_id: 1587
schema_scan_id: 162167220
updated: 2026-04-17 03:00:55

Version 1716342

created: 2026-04-16 03:04:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocompanies`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocompanies`\n(\n `Id`  string , `Name`  string , `Owner`  string , `PrimaryFaxNumber`  string , `PrimaryPhoneNumber`  string , `City_Id`  string , `Image`  string , `Description`  string , `PartnerId`  string , `MoloAPI_Partner_Id`  string , `CompanyMoloAPI_Partner_Company_Id`  string , `InvoiceAtCompanyLevel`  string , `MoloContactId`  string , `StripeCustomerId`  string , `LoginProviderId`  string , `DefaultCCFee`  string , `Tier1PercentACHFee`  string , `Tier2PercentACHFee`  string , `EnableGlobalContacts`  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_moloCompanies/2026-04-16/1776326460'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocompanies"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCompanies/2026-04-16/1776326460
id: 1716342
processed: 1

raw_data:

{
    "City_Id": 5,
    "CompanyMoloAPI_Partner_Company_Id": 10,
    "DefaultCCFee": 15,
    "Description": 7,
    "EnableGlobalContacts": 18,
    "Id": 0,
    "Image": 6,
    "InvoiceAtCompanyLevel": 11,
    "LoginProviderId": 14,
    "MoloAPI_Partner_Id": 9,
    "MoloContactId": 12,
    "Name": 1,
    "Owner": 2,
    "PartnerId": 8,
    "PrimaryFaxNumber": 3,
    "PrimaryPhoneNumber": 4,
    "StripeCustomerId": 13,
    "Tier1PercentACHFee": 16,
    "Tier2PercentACHFee": 17
}

schema_attributes:

{
    "City_Id": "string",
    "CompanyMoloAPI_Partner_Company_Id": "string",
    "DefaultCCFee": "string",
    "Description": "string",
    "EnableGlobalContacts": "string",
    "Id": "string",
    "Image": "string",
    "InvoiceAtCompanyLevel": "string",
    "LoginProviderId": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloContactId": "string",
    "Name": "string",
    "Owner": "string",
    "PartnerId": "string",
    "PrimaryFaxNumber": "string",
    "PrimaryPhoneNumber": "string",
    "StripeCustomerId": "string",
    "Tier1PercentACHFee": "string",
    "Tier2PercentACHFee": "string"
}

schema_name_id: 1587
schema_scan_id: 162111709
updated: 2026-04-16 03:05:04

Version 1715145

created: 2026-04-15 03:01:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocompanies`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocompanies`\n(\n `Id`  string , `Name`  string , `Owner`  string , `PrimaryFaxNumber`  string , `PrimaryPhoneNumber`  string , `City_Id`  string , `Image`  string , `Description`  string , `PartnerId`  string , `MoloAPI_Partner_Id`  string , `CompanyMoloAPI_Partner_Company_Id`  string , `InvoiceAtCompanyLevel`  string , `MoloContactId`  string , `StripeCustomerId`  string , `LoginProviderId`  string , `DefaultCCFee`  string , `Tier1PercentACHFee`  string , `Tier2PercentACHFee`  string , `EnableGlobalContacts`  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_moloCompanies/2026-04-15/1776239930'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocompanies"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCompanies/2026-04-15/1776239930
id: 1715145
processed: 1

raw_data:

{
    "City_Id": 5,
    "CompanyMoloAPI_Partner_Company_Id": 10,
    "DefaultCCFee": 15,
    "Description": 7,
    "EnableGlobalContacts": 18,
    "Id": 0,
    "Image": 6,
    "InvoiceAtCompanyLevel": 11,
    "LoginProviderId": 14,
    "MoloAPI_Partner_Id": 9,
    "MoloContactId": 12,
    "Name": 1,
    "Owner": 2,
    "PartnerId": 8,
    "PrimaryFaxNumber": 3,
    "PrimaryPhoneNumber": 4,
    "StripeCustomerId": 13,
    "Tier1PercentACHFee": 16,
    "Tier2PercentACHFee": 17
}

schema_attributes:

{
    "City_Id": "string",
    "CompanyMoloAPI_Partner_Company_Id": "string",
    "DefaultCCFee": "string",
    "Description": "string",
    "EnableGlobalContacts": "string",
    "Id": "string",
    "Image": "string",
    "InvoiceAtCompanyLevel": "string",
    "LoginProviderId": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloContactId": "string",
    "Name": "string",
    "Owner": "string",
    "PartnerId": "string",
    "PrimaryFaxNumber": "string",
    "PrimaryPhoneNumber": "string",
    "StripeCustomerId": "string",
    "Tier1PercentACHFee": "string",
    "Tier2PercentACHFee": "string"
}

schema_name_id: 1587
schema_scan_id: 162055683
updated: 2026-04-15 03:01:39

Version 1713970

created: 2026-04-14 03:04:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocompanies`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocompanies`\n(\n `Id`  string , `Name`  string , `Owner`  string , `PrimaryFaxNumber`  string , `PrimaryPhoneNumber`  string , `City_Id`  string , `Image`  string , `Description`  string , `PartnerId`  string , `MoloAPI_Partner_Id`  string , `CompanyMoloAPI_Partner_Company_Id`  string , `InvoiceAtCompanyLevel`  string , `MoloContactId`  string , `StripeCustomerId`  string , `LoginProviderId`  string , `DefaultCCFee`  string , `Tier1PercentACHFee`  string , `Tier2PercentACHFee`  string , `EnableGlobalContacts`  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_moloCompanies/2026-04-14/1776153654'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocompanies"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCompanies/2026-04-14/1776153654
id: 1713970
processed: 1

raw_data:

{
    "City_Id": 5,
    "CompanyMoloAPI_Partner_Company_Id": 10,
    "DefaultCCFee": 15,
    "Description": 7,
    "EnableGlobalContacts": 18,
    "Id": 0,
    "Image": 6,
    "InvoiceAtCompanyLevel": 11,
    "LoginProviderId": 14,
    "MoloAPI_Partner_Id": 9,
    "MoloContactId": 12,
    "Name": 1,
    "Owner": 2,
    "PartnerId": 8,
    "PrimaryFaxNumber": 3,
    "PrimaryPhoneNumber": 4,
    "StripeCustomerId": 13,
    "Tier1PercentACHFee": 16,
    "Tier2PercentACHFee": 17
}

schema_attributes:

{
    "City_Id": "string",
    "CompanyMoloAPI_Partner_Company_Id": "string",
    "DefaultCCFee": "string",
    "Description": "string",
    "EnableGlobalContacts": "string",
    "Id": "string",
    "Image": "string",
    "InvoiceAtCompanyLevel": "string",
    "LoginProviderId": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloContactId": "string",
    "Name": "string",
    "Owner": "string",
    "PartnerId": "string",
    "PrimaryFaxNumber": "string",
    "PrimaryPhoneNumber": "string",
    "StripeCustomerId": "string",
    "Tier1PercentACHFee": "string",
    "Tier2PercentACHFee": "string"
}

schema_name_id: 1587
schema_scan_id: 162000399
updated: 2026-04-14 03:04:11

Version 1712716

created: 2026-04-13 02:55:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocompanies`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocompanies`\n(\n `Id`  string , `Name`  string , `Owner`  string , `PrimaryFaxNumber`  string , `PrimaryPhoneNumber`  string , `City_Id`  string , `Image`  string , `Description`  string , `PartnerId`  string , `MoloAPI_Partner_Id`  string , `CompanyMoloAPI_Partner_Company_Id`  string , `InvoiceAtCompanyLevel`  string , `MoloContactId`  string , `StripeCustomerId`  string , `LoginProviderId`  string , `DefaultCCFee`  string , `Tier1PercentACHFee`  string , `Tier2PercentACHFee`  string , `EnableGlobalContacts`  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_moloCompanies/2026-04-13/1776066848'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocompanies"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCompanies/2026-04-13/1776066848
id: 1712716
processed: 1

raw_data:

{
    "City_Id": 5,
    "CompanyMoloAPI_Partner_Company_Id": 10,
    "DefaultCCFee": 15,
    "Description": 7,
    "EnableGlobalContacts": 18,
    "Id": 0,
    "Image": 6,
    "InvoiceAtCompanyLevel": 11,
    "LoginProviderId": 14,
    "MoloAPI_Partner_Id": 9,
    "MoloContactId": 12,
    "Name": 1,
    "Owner": 2,
    "PartnerId": 8,
    "PrimaryFaxNumber": 3,
    "PrimaryPhoneNumber": 4,
    "StripeCustomerId": 13,
    "Tier1PercentACHFee": 16,
    "Tier2PercentACHFee": 17
}

schema_attributes:

{
    "City_Id": "string",
    "CompanyMoloAPI_Partner_Company_Id": "string",
    "DefaultCCFee": "string",
    "Description": "string",
    "EnableGlobalContacts": "string",
    "Id": "string",
    "Image": "string",
    "InvoiceAtCompanyLevel": "string",
    "LoginProviderId": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloContactId": "string",
    "Name": "string",
    "Owner": "string",
    "PartnerId": "string",
    "PrimaryFaxNumber": "string",
    "PrimaryPhoneNumber": "string",
    "StripeCustomerId": "string",
    "Tier1PercentACHFee": "string",
    "Tier2PercentACHFee": "string"
}

schema_name_id: 1587
schema_scan_id: 161941488
updated: 2026-04-13 02:55:51

Version 1711509

created: 2026-04-12 02:56:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocompanies`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocompanies`\n(\n `Id`  string , `Name`  string , `Owner`  string , `PrimaryFaxNumber`  string , `PrimaryPhoneNumber`  string , `City_Id`  string , `Image`  string , `Description`  string , `PartnerId`  string , `MoloAPI_Partner_Id`  string , `CompanyMoloAPI_Partner_Company_Id`  string , `InvoiceAtCompanyLevel`  string , `MoloContactId`  string , `StripeCustomerId`  string , `LoginProviderId`  string , `DefaultCCFee`  string , `Tier1PercentACHFee`  string , `Tier2PercentACHFee`  string , `EnableGlobalContacts`  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_moloCompanies/2026-04-12/1775980564'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocompanies"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCompanies/2026-04-12/1775980564
id: 1711509
processed: 1

raw_data:

{
    "City_Id": 5,
    "CompanyMoloAPI_Partner_Company_Id": 10,
    "DefaultCCFee": 15,
    "Description": 7,
    "EnableGlobalContacts": 18,
    "Id": 0,
    "Image": 6,
    "InvoiceAtCompanyLevel": 11,
    "LoginProviderId": 14,
    "MoloAPI_Partner_Id": 9,
    "MoloContactId": 12,
    "Name": 1,
    "Owner": 2,
    "PartnerId": 8,
    "PrimaryFaxNumber": 3,
    "PrimaryPhoneNumber": 4,
    "StripeCustomerId": 13,
    "Tier1PercentACHFee": 16,
    "Tier2PercentACHFee": 17
}

schema_attributes:

{
    "City_Id": "string",
    "CompanyMoloAPI_Partner_Company_Id": "string",
    "DefaultCCFee": "string",
    "Description": "string",
    "EnableGlobalContacts": "string",
    "Id": "string",
    "Image": "string",
    "InvoiceAtCompanyLevel": "string",
    "LoginProviderId": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloContactId": "string",
    "Name": "string",
    "Owner": "string",
    "PartnerId": "string",
    "PrimaryFaxNumber": "string",
    "PrimaryPhoneNumber": "string",
    "StripeCustomerId": "string",
    "Tier1PercentACHFee": "string",
    "Tier2PercentACHFee": "string"
}

schema_name_id: 1587
schema_scan_id: 161892268
updated: 2026-04-12 02:56:58

Version 1710306

created: 2026-04-11 02:59:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocompanies`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocompanies`\n(\n `Id`  string , `Name`  string , `Owner`  string , `PrimaryFaxNumber`  string , `PrimaryPhoneNumber`  string , `City_Id`  string , `Image`  string , `Description`  string , `PartnerId`  string , `MoloAPI_Partner_Id`  string , `CompanyMoloAPI_Partner_Company_Id`  string , `InvoiceAtCompanyLevel`  string , `MoloContactId`  string , `StripeCustomerId`  string , `LoginProviderId`  string , `DefaultCCFee`  string , `Tier1PercentACHFee`  string , `Tier2PercentACHFee`  string , `EnableGlobalContacts`  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_moloCompanies/2026-04-11/1775894324'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocompanies"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCompanies/2026-04-11/1775894324
id: 1710306
processed: 1

raw_data:

{
    "City_Id": 5,
    "CompanyMoloAPI_Partner_Company_Id": 10,
    "DefaultCCFee": 15,
    "Description": 7,
    "EnableGlobalContacts": 18,
    "Id": 0,
    "Image": 6,
    "InvoiceAtCompanyLevel": 11,
    "LoginProviderId": 14,
    "MoloAPI_Partner_Id": 9,
    "MoloContactId": 12,
    "Name": 1,
    "Owner": 2,
    "PartnerId": 8,
    "PrimaryFaxNumber": 3,
    "PrimaryPhoneNumber": 4,
    "StripeCustomerId": 13,
    "Tier1PercentACHFee": 16,
    "Tier2PercentACHFee": 17
}

schema_attributes:

{
    "City_Id": "string",
    "CompanyMoloAPI_Partner_Company_Id": "string",
    "DefaultCCFee": "string",
    "Description": "string",
    "EnableGlobalContacts": "string",
    "Id": "string",
    "Image": "string",
    "InvoiceAtCompanyLevel": "string",
    "LoginProviderId": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloContactId": "string",
    "Name": "string",
    "Owner": "string",
    "PartnerId": "string",
    "PrimaryFaxNumber": "string",
    "PrimaryPhoneNumber": "string",
    "StripeCustomerId": "string",
    "Tier1PercentACHFee": "string",
    "Tier2PercentACHFee": "string"
}

schema_name_id: 1587
schema_scan_id: 161840866
updated: 2026-04-11 03:00:10

Version 1709151

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocompanies`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocompanies`\n(\n `Id`  string , `Name`  string , `Owner`  string , `PrimaryFaxNumber`  string , `PrimaryPhoneNumber`  string , `City_Id`  string , `Image`  string , `Description`  string , `PartnerId`  string , `MoloAPI_Partner_Id`  string , `CompanyMoloAPI_Partner_Company_Id`  string , `InvoiceAtCompanyLevel`  string , `MoloContactId`  string , `StripeCustomerId`  string , `LoginProviderId`  string , `DefaultCCFee`  string , `Tier1PercentACHFee`  string , `Tier2PercentACHFee`  string , `EnableGlobalContacts`  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_moloCompanies/2026-04-10/1775808081'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocompanies"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCompanies/2026-04-10/1775808081
id: 1709151
processed: 1

raw_data:

{
    "City_Id": 5,
    "CompanyMoloAPI_Partner_Company_Id": 10,
    "DefaultCCFee": 15,
    "Description": 7,
    "EnableGlobalContacts": 18,
    "Id": 0,
    "Image": 6,
    "InvoiceAtCompanyLevel": 11,
    "LoginProviderId": 14,
    "MoloAPI_Partner_Id": 9,
    "MoloContactId": 12,
    "Name": 1,
    "Owner": 2,
    "PartnerId": 8,
    "PrimaryFaxNumber": 3,
    "PrimaryPhoneNumber": 4,
    "StripeCustomerId": 13,
    "Tier1PercentACHFee": 16,
    "Tier2PercentACHFee": 17
}

schema_attributes:

{
    "City_Id": "string",
    "CompanyMoloAPI_Partner_Company_Id": "string",
    "DefaultCCFee": "string",
    "Description": "string",
    "EnableGlobalContacts": "string",
    "Id": "string",
    "Image": "string",
    "InvoiceAtCompanyLevel": "string",
    "LoginProviderId": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloContactId": "string",
    "Name": "string",
    "Owner": "string",
    "PartnerId": "string",
    "PrimaryFaxNumber": "string",
    "PrimaryPhoneNumber": "string",
    "StripeCustomerId": "string",
    "Tier1PercentACHFee": "string",
    "Tier2PercentACHFee": "string"
}

schema_name_id: 1587
schema_scan_id: 161785783
updated: 2026-04-10 03:02:21

Version 1708019

created: 2026-04-09 02:58:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocompanies`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocompanies`\n(\n `Id`  string , `Name`  string , `Owner`  string , `PrimaryFaxNumber`  string , `PrimaryPhoneNumber`  string , `City_Id`  string , `Image`  string , `Description`  string , `PartnerId`  string , `MoloAPI_Partner_Id`  string , `CompanyMoloAPI_Partner_Company_Id`  string , `InvoiceAtCompanyLevel`  string , `MoloContactId`  string , `StripeCustomerId`  string , `LoginProviderId`  string , `DefaultCCFee`  string , `Tier1PercentACHFee`  string , `Tier2PercentACHFee`  string , `EnableGlobalContacts`  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_moloCompanies/2026-04-09/1775721419'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocompanies"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCompanies/2026-04-09/1775721419
id: 1708019
processed: 1

raw_data:

{
    "City_Id": 5,
    "CompanyMoloAPI_Partner_Company_Id": 10,
    "DefaultCCFee": 15,
    "Description": 7,
    "EnableGlobalContacts": 18,
    "Id": 0,
    "Image": 6,
    "InvoiceAtCompanyLevel": 11,
    "LoginProviderId": 14,
    "MoloAPI_Partner_Id": 9,
    "MoloContactId": 12,
    "Name": 1,
    "Owner": 2,
    "PartnerId": 8,
    "PrimaryFaxNumber": 3,
    "PrimaryPhoneNumber": 4,
    "StripeCustomerId": 13,
    "Tier1PercentACHFee": 16,
    "Tier2PercentACHFee": 17
}

schema_attributes:

{
    "City_Id": "string",
    "CompanyMoloAPI_Partner_Company_Id": "string",
    "DefaultCCFee": "string",
    "Description": "string",
    "EnableGlobalContacts": "string",
    "Id": "string",
    "Image": "string",
    "InvoiceAtCompanyLevel": "string",
    "LoginProviderId": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloContactId": "string",
    "Name": "string",
    "Owner": "string",
    "PartnerId": "string",
    "PrimaryFaxNumber": "string",
    "PrimaryPhoneNumber": "string",
    "StripeCustomerId": "string",
    "Tier1PercentACHFee": "string",
    "Tier2PercentACHFee": "string"
}

schema_name_id: 1587
schema_scan_id: 161729798
updated: 2026-04-09 02:59:01

Version 1706812

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocompanies`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocompanies`\n(\n `Id`  string , `Name`  string , `Owner`  string , `PrimaryFaxNumber`  string , `PrimaryPhoneNumber`  string , `City_Id`  string , `Image`  string , `Description`  string , `PartnerId`  string , `MoloAPI_Partner_Id`  string , `CompanyMoloAPI_Partner_Company_Id`  string , `InvoiceAtCompanyLevel`  string , `MoloContactId`  string , `StripeCustomerId`  string , `LoginProviderId`  string , `DefaultCCFee`  string , `Tier1PercentACHFee`  string , `Tier2PercentACHFee`  string , `EnableGlobalContacts`  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_moloCompanies/2026-04-08/1775635226'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocompanies"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCompanies/2026-04-08/1775635226
id: 1706812
processed: 1

raw_data:

{
    "City_Id": 5,
    "CompanyMoloAPI_Partner_Company_Id": 10,
    "DefaultCCFee": 15,
    "Description": 7,
    "EnableGlobalContacts": 18,
    "Id": 0,
    "Image": 6,
    "InvoiceAtCompanyLevel": 11,
    "LoginProviderId": 14,
    "MoloAPI_Partner_Id": 9,
    "MoloContactId": 12,
    "Name": 1,
    "Owner": 2,
    "PartnerId": 8,
    "PrimaryFaxNumber": 3,
    "PrimaryPhoneNumber": 4,
    "StripeCustomerId": 13,
    "Tier1PercentACHFee": 16,
    "Tier2PercentACHFee": 17
}

schema_attributes:

{
    "City_Id": "string",
    "CompanyMoloAPI_Partner_Company_Id": "string",
    "DefaultCCFee": "string",
    "Description": "string",
    "EnableGlobalContacts": "string",
    "Id": "string",
    "Image": "string",
    "InvoiceAtCompanyLevel": "string",
    "LoginProviderId": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloContactId": "string",
    "Name": "string",
    "Owner": "string",
    "PartnerId": "string",
    "PrimaryFaxNumber": "string",
    "PrimaryPhoneNumber": "string",
    "StripeCustomerId": "string",
    "Tier1PercentACHFee": "string",
    "Tier2PercentACHFee": "string"
}

schema_name_id: 1587
schema_scan_id: 161675342
updated: 2026-04-08 03:01:51

Version 1705658

created: 2026-04-07 02:55:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocompanies`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocompanies`\n(\n `Id`  string , `Name`  string , `Owner`  string , `PrimaryFaxNumber`  string , `PrimaryPhoneNumber`  string , `City_Id`  string , `Image`  string , `Description`  string , `PartnerId`  string , `MoloAPI_Partner_Id`  string , `CompanyMoloAPI_Partner_Company_Id`  string , `InvoiceAtCompanyLevel`  string , `MoloContactId`  string , `StripeCustomerId`  string , `LoginProviderId`  string , `DefaultCCFee`  string , `Tier1PercentACHFee`  string , `Tier2PercentACHFee`  string , `EnableGlobalContacts`  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_moloCompanies/2026-04-07/1775548400'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocompanies"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCompanies/2026-04-07/1775548400
id: 1705658
processed: 1

raw_data:

{
    "City_Id": 5,
    "CompanyMoloAPI_Partner_Company_Id": 10,
    "DefaultCCFee": 15,
    "Description": 7,
    "EnableGlobalContacts": 18,
    "Id": 0,
    "Image": 6,
    "InvoiceAtCompanyLevel": 11,
    "LoginProviderId": 14,
    "MoloAPI_Partner_Id": 9,
    "MoloContactId": 12,
    "Name": 1,
    "Owner": 2,
    "PartnerId": 8,
    "PrimaryFaxNumber": 3,
    "PrimaryPhoneNumber": 4,
    "StripeCustomerId": 13,
    "Tier1PercentACHFee": 16,
    "Tier2PercentACHFee": 17
}

schema_attributes:

{
    "City_Id": "string",
    "CompanyMoloAPI_Partner_Company_Id": "string",
    "DefaultCCFee": "string",
    "Description": "string",
    "EnableGlobalContacts": "string",
    "Id": "string",
    "Image": "string",
    "InvoiceAtCompanyLevel": "string",
    "LoginProviderId": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloContactId": "string",
    "Name": "string",
    "Owner": "string",
    "PartnerId": "string",
    "PrimaryFaxNumber": "string",
    "PrimaryPhoneNumber": "string",
    "StripeCustomerId": "string",
    "Tier1PercentACHFee": "string",
    "Tier2PercentACHFee": "string"
}

schema_name_id: 1587
schema_scan_id: 161618337
updated: 2026-04-07 02:55:26

Version 1704394

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocompanies`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocompanies`\n(\n `Id`  string , `Name`  string , `Owner`  string , `PrimaryFaxNumber`  string , `PrimaryPhoneNumber`  string , `City_Id`  string , `Image`  string , `Description`  string , `PartnerId`  string , `MoloAPI_Partner_Id`  string , `CompanyMoloAPI_Partner_Company_Id`  string , `InvoiceAtCompanyLevel`  string , `MoloContactId`  string , `StripeCustomerId`  string , `LoginProviderId`  string , `DefaultCCFee`  string , `Tier1PercentACHFee`  string , `Tier2PercentACHFee`  string , `EnableGlobalContacts`  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_moloCompanies/2026-04-06/1775462363'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocompanies"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCompanies/2026-04-06/1775462363
id: 1704394
processed: 1

raw_data:

{
    "City_Id": 5,
    "CompanyMoloAPI_Partner_Company_Id": 10,
    "DefaultCCFee": 15,
    "Description": 7,
    "EnableGlobalContacts": 18,
    "Id": 0,
    "Image": 6,
    "InvoiceAtCompanyLevel": 11,
    "LoginProviderId": 14,
    "MoloAPI_Partner_Id": 9,
    "MoloContactId": 12,
    "Name": 1,
    "Owner": 2,
    "PartnerId": 8,
    "PrimaryFaxNumber": 3,
    "PrimaryPhoneNumber": 4,
    "StripeCustomerId": 13,
    "Tier1PercentACHFee": 16,
    "Tier2PercentACHFee": 17
}

schema_attributes:

{
    "City_Id": "string",
    "CompanyMoloAPI_Partner_Company_Id": "string",
    "DefaultCCFee": "string",
    "Description": "string",
    "EnableGlobalContacts": "string",
    "Id": "string",
    "Image": "string",
    "InvoiceAtCompanyLevel": "string",
    "LoginProviderId": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloContactId": "string",
    "Name": "string",
    "Owner": "string",
    "PartnerId": "string",
    "PrimaryFaxNumber": "string",
    "PrimaryPhoneNumber": "string",
    "StripeCustomerId": "string",
    "Tier1PercentACHFee": "string",
    "Tier2PercentACHFee": "string"
}

schema_name_id: 1587
schema_scan_id: 161561360
updated: 2026-04-06 03:01:26

Version 1703196

created: 2026-04-05 03:01:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocompanies`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocompanies`\n(\n `Id`  string , `Name`  string , `Owner`  string , `PrimaryFaxNumber`  string , `PrimaryPhoneNumber`  string , `City_Id`  string , `Image`  string , `Description`  string , `PartnerId`  string , `MoloAPI_Partner_Id`  string , `CompanyMoloAPI_Partner_Company_Id`  string , `InvoiceAtCompanyLevel`  string , `MoloContactId`  string , `StripeCustomerId`  string , `LoginProviderId`  string , `DefaultCCFee`  string , `Tier1PercentACHFee`  string , `Tier2PercentACHFee`  string , `EnableGlobalContacts`  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_moloCompanies/2026-04-05/1775375992'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocompanies"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCompanies/2026-04-05/1775375992
id: 1703196
processed: 1

raw_data:

{
    "City_Id": 5,
    "CompanyMoloAPI_Partner_Company_Id": 10,
    "DefaultCCFee": 15,
    "Description": 7,
    "EnableGlobalContacts": 18,
    "Id": 0,
    "Image": 6,
    "InvoiceAtCompanyLevel": 11,
    "LoginProviderId": 14,
    "MoloAPI_Partner_Id": 9,
    "MoloContactId": 12,
    "Name": 1,
    "Owner": 2,
    "PartnerId": 8,
    "PrimaryFaxNumber": 3,
    "PrimaryPhoneNumber": 4,
    "StripeCustomerId": 13,
    "Tier1PercentACHFee": 16,
    "Tier2PercentACHFee": 17
}

schema_attributes:

{
    "City_Id": "string",
    "CompanyMoloAPI_Partner_Company_Id": "string",
    "DefaultCCFee": "string",
    "Description": "string",
    "EnableGlobalContacts": "string",
    "Id": "string",
    "Image": "string",
    "InvoiceAtCompanyLevel": "string",
    "LoginProviderId": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloContactId": "string",
    "Name": "string",
    "Owner": "string",
    "PartnerId": "string",
    "PrimaryFaxNumber": "string",
    "PrimaryPhoneNumber": "string",
    "StripeCustomerId": "string",
    "Tier1PercentACHFee": "string",
    "Tier2PercentACHFee": "string"
}

schema_name_id: 1587
schema_scan_id: 161514751
updated: 2026-04-05 03:01:15

Version 1702018

created: 2026-04-04 02:59:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocompanies`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocompanies`\n(\n `Id`  string , `Name`  string , `Owner`  string , `PrimaryFaxNumber`  string , `PrimaryPhoneNumber`  string , `City_Id`  string , `Image`  string , `Description`  string , `PartnerId`  string , `MoloAPI_Partner_Id`  string , `CompanyMoloAPI_Partner_Company_Id`  string , `InvoiceAtCompanyLevel`  string , `MoloContactId`  string , `StripeCustomerId`  string , `LoginProviderId`  string , `DefaultCCFee`  string , `Tier1PercentACHFee`  string , `Tier2PercentACHFee`  string , `EnableGlobalContacts`  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_moloCompanies/2026-04-04/1775289476'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocompanies"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCompanies/2026-04-04/1775289476
id: 1702018
processed: 1

raw_data:

{
    "City_Id": 5,
    "CompanyMoloAPI_Partner_Company_Id": 10,
    "DefaultCCFee": 15,
    "Description": 7,
    "EnableGlobalContacts": 18,
    "Id": 0,
    "Image": 6,
    "InvoiceAtCompanyLevel": 11,
    "LoginProviderId": 14,
    "MoloAPI_Partner_Id": 9,
    "MoloContactId": 12,
    "Name": 1,
    "Owner": 2,
    "PartnerId": 8,
    "PrimaryFaxNumber": 3,
    "PrimaryPhoneNumber": 4,
    "StripeCustomerId": 13,
    "Tier1PercentACHFee": 16,
    "Tier2PercentACHFee": 17
}

schema_attributes:

{
    "City_Id": "string",
    "CompanyMoloAPI_Partner_Company_Id": "string",
    "DefaultCCFee": "string",
    "Description": "string",
    "EnableGlobalContacts": "string",
    "Id": "string",
    "Image": "string",
    "InvoiceAtCompanyLevel": "string",
    "LoginProviderId": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloContactId": "string",
    "Name": "string",
    "Owner": "string",
    "PartnerId": "string",
    "PrimaryFaxNumber": "string",
    "PrimaryPhoneNumber": "string",
    "StripeCustomerId": "string",
    "Tier1PercentACHFee": "string",
    "Tier2PercentACHFee": "string"
}

schema_name_id: 1587
schema_scan_id: 161459760
updated: 2026-04-04 02:59:22

Version 1700895

created: 2026-04-03 03:07:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocompanies`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocompanies`\n(\n `Id`  string , `Name`  string , `Owner`  string , `PrimaryFaxNumber`  string , `PrimaryPhoneNumber`  string , `City_Id`  string , `Image`  string , `Description`  string , `PartnerId`  string , `MoloAPI_Partner_Id`  string , `CompanyMoloAPI_Partner_Company_Id`  string , `InvoiceAtCompanyLevel`  string , `MoloContactId`  string , `StripeCustomerId`  string , `LoginProviderId`  string , `DefaultCCFee`  string , `Tier1PercentACHFee`  string , `Tier2PercentACHFee`  string , `EnableGlobalContacts`  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_moloCompanies/2026-04-03/1775203248'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocompanies"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCompanies/2026-04-03/1775203248
id: 1700895
processed: 1

raw_data:

{
    "City_Id": 5,
    "CompanyMoloAPI_Partner_Company_Id": 10,
    "DefaultCCFee": 15,
    "Description": 7,
    "EnableGlobalContacts": 18,
    "Id": 0,
    "Image": 6,
    "InvoiceAtCompanyLevel": 11,
    "LoginProviderId": 14,
    "MoloAPI_Partner_Id": 9,
    "MoloContactId": 12,
    "Name": 1,
    "Owner": 2,
    "PartnerId": 8,
    "PrimaryFaxNumber": 3,
    "PrimaryPhoneNumber": 4,
    "StripeCustomerId": 13,
    "Tier1PercentACHFee": 16,
    "Tier2PercentACHFee": 17
}

schema_attributes:

{
    "City_Id": "string",
    "CompanyMoloAPI_Partner_Company_Id": "string",
    "DefaultCCFee": "string",
    "Description": "string",
    "EnableGlobalContacts": "string",
    "Id": "string",
    "Image": "string",
    "InvoiceAtCompanyLevel": "string",
    "LoginProviderId": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloContactId": "string",
    "Name": "string",
    "Owner": "string",
    "PartnerId": "string",
    "PrimaryFaxNumber": "string",
    "PrimaryPhoneNumber": "string",
    "StripeCustomerId": "string",
    "Tier1PercentACHFee": "string",
    "Tier2PercentACHFee": "string"
}

schema_name_id: 1587
schema_scan_id: 161401830
updated: 2026-04-03 03:08:10

Schema Scans: 15

Last at 2026-04-17 03:00:43

Scan 162167220

duration: 0:00:11.973418

exit_message:

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

id: 162167220

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_moloCompanies/2026-04-17/1776412695",
        "key": "raw/molo_moloCompanies/2026-04-17/1776412695/Companies.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCompanies",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5393008797275767024,
        "service_name": "drive-thru",
        "span_id": 256117804879378490,
        "trace_id": 13565623801607601215
    }
}

running: False
schema_name_id: 1587
start_time: 2026-04-17 03:00:43
success: True
trace_id: 13565623801607601215

Scan 162111709

duration: 0:00:14.511282

exit_message:

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

id: 162111709

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_moloCompanies/2026-04-16/1776326460",
        "key": "raw/molo_moloCompanies/2026-04-16/1776326460/Companies.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCompanies",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2912417296485679886,
        "service_name": "drive-thru",
        "span_id": 2653967032057193662,
        "trace_id": 6865003589407546315
    }
}

running: False
schema_name_id: 1587
start_time: 2026-04-16 03:04:50
success: True
trace_id: 6865003589407546315

Scan 162055683

duration: 0:00:11.990653

exit_message:

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

id: 162055683

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_moloCompanies/2026-04-15/1776239930",
        "key": "raw/molo_moloCompanies/2026-04-15/1776239930/Companies.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCompanies",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3535865078453118148,
        "service_name": "drive-thru",
        "span_id": 4906843416233436875,
        "trace_id": 12919295405560911327
    }
}

running: False
schema_name_id: 1587
start_time: 2026-04-15 03:01:27
success: True
trace_id: 12919295405560911327

Scan 162000399

duration: 0:00:12.137678

exit_message:

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

id: 162000399

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_moloCompanies/2026-04-14/1776153654",
        "key": "raw/molo_moloCompanies/2026-04-14/1776153654/Companies.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCompanies",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8250234333154324779,
        "service_name": "drive-thru",
        "span_id": 9267888110754642888,
        "trace_id": 3583516938359129908
    }
}

running: False
schema_name_id: 1587
start_time: 2026-04-14 03:03:59
success: True
trace_id: 3583516938359129908

Scan 161941488

duration: 0:00:11.923416

exit_message:

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

id: 161941488

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_moloCompanies/2026-04-13/1776066848",
        "key": "raw/molo_moloCompanies/2026-04-13/1776066848/Companies.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCompanies",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5222187018833376576,
        "service_name": "drive-thru",
        "span_id": 959421677780151337,
        "trace_id": 14354962759032635647
    }
}

running: False
schema_name_id: 1587
start_time: 2026-04-13 02:55:39
success: True
trace_id: 14354962759032635647

Scan 161892268

duration: 0:00:12.190981

exit_message:

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

id: 161892268

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_moloCompanies/2026-04-12/1775980564",
        "key": "raw/molo_moloCompanies/2026-04-12/1775980564/Companies.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCompanies",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12884848265219735931,
        "service_name": "drive-thru",
        "span_id": 2277906478301106137,
        "trace_id": 8787586968858712782
    }
}

running: False
schema_name_id: 1587
start_time: 2026-04-12 02:56:46
success: True
trace_id: 8787586968858712782

Scan 161840866

duration: 0:00:14.628412

exit_message:

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

id: 161840866

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_moloCompanies/2026-04-11/1775894324",
        "key": "raw/molo_moloCompanies/2026-04-11/1775894324/Companies.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCompanies",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9005122389651013169,
        "service_name": "drive-thru",
        "span_id": 6378020582783434147,
        "trace_id": 11546375021123835909
    }
}

running: False
schema_name_id: 1587
start_time: 2026-04-11 02:59:56
success: True
trace_id: 11546375021123835909

Scan 161785783

duration: 0:00:14.550268

exit_message:

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

id: 161785783

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_moloCompanies/2026-04-10/1775808081",
        "key": "raw/molo_moloCompanies/2026-04-10/1775808081/Companies.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCompanies",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4613586122508685114,
        "service_name": "drive-thru",
        "span_id": 14101062756910671440,
        "trace_id": 225251666254146089
    }
}

running: False
schema_name_id: 1587
start_time: 2026-04-10 03:02:06
success: True
trace_id: 225251666254146089

Scan 161729798

duration: 0:00:12.035535

exit_message:

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

id: 161729798

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_moloCompanies/2026-04-09/1775721419",
        "key": "raw/molo_moloCompanies/2026-04-09/1775721419/Companies.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCompanies",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12101156580325703058,
        "service_name": "drive-thru",
        "span_id": 9849992628262562065,
        "trace_id": 17220062943087624616
    }
}

running: False
schema_name_id: 1587
start_time: 2026-04-09 02:58:49
success: True
trace_id: 17220062943087624616

Scan 161675342

duration: 0:00:14.670017

exit_message:

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

id: 161675342

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_moloCompanies/2026-04-08/1775635226",
        "key": "raw/molo_moloCompanies/2026-04-08/1775635226/Companies.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCompanies",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5110030050795964984,
        "service_name": "drive-thru",
        "span_id": 11478074899216503497,
        "trace_id": 15977785375303234358
    }
}

running: False
schema_name_id: 1587
start_time: 2026-04-08 03:01:36
success: True
trace_id: 15977785375303234358

Scan 161618337

duration: 0:00:12.209560

exit_message:

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

id: 161618337

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_moloCompanies/2026-04-07/1775548400",
        "key": "raw/molo_moloCompanies/2026-04-07/1775548400/Companies.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCompanies",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13786783002095285676,
        "service_name": "drive-thru",
        "span_id": 1216107102428713671,
        "trace_id": 8121526494841194069
    }
}

running: False
schema_name_id: 1587
start_time: 2026-04-07 02:55:14
success: True
trace_id: 8121526494841194069

Scan 161561360

duration: 0:00:14.566340

exit_message:

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

id: 161561360

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_moloCompanies/2026-04-06/1775462363",
        "key": "raw/molo_moloCompanies/2026-04-06/1775462363/Companies.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCompanies",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9210769906120466088,
        "service_name": "drive-thru",
        "span_id": 6399142865360847984,
        "trace_id": 602375741776876657
    }
}

running: False
schema_name_id: 1587
start_time: 2026-04-06 03:01:12
success: True
trace_id: 602375741776876657

Scan 161514751

duration: 0:00:14.701574

exit_message:

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

id: 161514751

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_moloCompanies/2026-04-05/1775375992",
        "key": "raw/molo_moloCompanies/2026-04-05/1775375992/Companies.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCompanies",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1354649865287794208,
        "service_name": "drive-thru",
        "span_id": 16010402640920780595,
        "trace_id": 3429498455603031589
    }
}

running: False
schema_name_id: 1587
start_time: 2026-04-05 03:01:01
success: True
trace_id: 3429498455603031589

Scan 161459760

duration: 0:00:11.998181

exit_message:

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

id: 161459760

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_moloCompanies/2026-04-04/1775289476",
        "key": "raw/molo_moloCompanies/2026-04-04/1775289476/Companies.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCompanies",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17119641274529160430,
        "service_name": "drive-thru",
        "span_id": 18062429393845781737,
        "trace_id": 9365864676765719945
    }
}

running: False
schema_name_id: 1587
start_time: 2026-04-04 02:59:10
success: True
trace_id: 9365864676765719945

Scan 161401830

duration: 0:00:12.091234

exit_message:

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

id: 161401830

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_moloCompanies/2026-04-03/1775203248",
        "key": "raw/molo_moloCompanies/2026-04-03/1775203248/Companies.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCompanies",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8219117031739460342,
        "service_name": "drive-thru",
        "span_id": 6051920347946875779,
        "trace_id": 13191779988809323715
    }
}

running: False
schema_name_id: 1587
start_time: 2026-04-03 03:07:58
success: True
trace_id: 13191779988809323715

Partitions:

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

Schema:

attributes:

{
    "City_Id": "string",
    "CompanyMoloAPI_Partner_Company_Id": "string",
    "DefaultCCFee": "string",
    "Description": "string",
    "EnableGlobalContacts": "string",
    "Id": "string",
    "Image": "string",
    "InvoiceAtCompanyLevel": "string",
    "LoginProviderId": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloContactId": "string",
    "Name": "string",
    "Owner": "string",
    "PartnerId": "string",
    "PrimaryFaxNumber": "string",
    "PrimaryPhoneNumber": "string",
    "StripeCustomerId": "string",
    "Tier1PercentACHFee": "string",
    "Tier2PercentACHFee": "string"
}

created: 2026-04-17 03:00:44

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocompanies`\n(\n `Id`  string , `Name`  string , `Owner`  string , `PrimaryFaxNumber`  string , `PrimaryPhoneNumber`  string , `City_Id`  string , `Image`  string , `Description`  string , `PartnerId`  string , `MoloAPI_Partner_Id`  string , `CompanyMoloAPI_Partner_Company_Id`  string , `InvoiceAtCompanyLevel`  string , `MoloContactId`  string , `StripeCustomerId`  string , `LoginProviderId`  string , `DefaultCCFee`  string , `Tier1PercentACHFee`  string , `Tier2PercentACHFee`  string , `EnableGlobalContacts`  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_moloCompanies/2026-04-17/1776412695'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocompanies`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocompanies"
}

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:54:55",
        "disabled": false,
        "format": "raw",
        "id": 1587,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molocompanies"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "City_Id": "string",
            "CompanyMoloAPI_Partner_Company_Id": "string",
            "DefaultCCFee": "string",
            "Description": "string",
            "EnableGlobalContacts": "string",
            "Id": "string",
            "Image": "string",
            "InvoiceAtCompanyLevel": "string",
            "LoginProviderId": "string",
            "MoloAPI_Partner_Id": "string",
            "MoloContactId": "string",
            "Name": "string",
            "Owner": "string",
            "PartnerId": "string",
            "PrimaryFaxNumber": "string",
            "PrimaryPhoneNumber": "string",
            "StripeCustomerId": "string",
            "Tier1PercentACHFee": "string",
            "Tier2PercentACHFee": "string"
        },
        "created": "2026-04-17 03:00:44",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocompanies`\n(\n `Id`  string , `Name`  string , `Owner`  string , `PrimaryFaxNumber`  string , `PrimaryPhoneNumber`  string , `City_Id`  string , `Image`  string , `Description`  string , `PartnerId`  string , `MoloAPI_Partner_Id`  string , `CompanyMoloAPI_Partner_Company_Id`  string , `InvoiceAtCompanyLevel`  string , `MoloContactId`  string , `StripeCustomerId`  string , `LoginProviderId`  string , `DefaultCCFee`  string , `Tier1PercentACHFee`  string , `Tier2PercentACHFee`  string , `EnableGlobalContacts`  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_moloCompanies/2026-04-17/1776412695'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocompanies`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocompanies"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}