Schema Info

Schema Name: sfdl_prod_drivethru.molo_molomoloprovidersset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717663

created: 2026-04-17 03:05:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomoloprovidersset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomoloprovidersset`\n(\n `Id`  string , `FirstName`  string , `MiddleName`  string , `LastName`  string , `CompanyName`  string , `Photo`  string , `WebsiteURL`  string , `Offering`  string , `Description`  string , `Email`  string , `Notes`  string , `HashId`  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_moloMoloProvidersSet/2026-04-17/1776412806'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomoloprovidersset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMoloProvidersSet/2026-04-17/1776412806
id: 1717663
processed: 1

raw_data:

{
    "CompanyName": 4,
    "Description": 8,
    "Email": 9,
    "FirstName": 1,
    "HashId": 11,
    "Id": 0,
    "LastName": 3,
    "MiddleName": 2,
    "Notes": 10,
    "Offering": 7,
    "Photo": 5,
    "WebsiteURL": 6
}

schema_attributes:

{
    "CompanyName": "string",
    "Description": "string",
    "Email": "string",
    "FirstName": "string",
    "HashId": "string",
    "Id": "string",
    "LastName": "string",
    "MiddleName": "string",
    "Notes": "string",
    "Offering": "string",
    "Photo": "string",
    "WebsiteURL": "string"
}

schema_name_id: 1674
schema_scan_id: 162167640
updated: 2026-04-17 03:06:04

Version 1716399

created: 2026-04-16 03:07:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomoloprovidersset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomoloprovidersset`\n(\n `Id`  string , `FirstName`  string , `MiddleName`  string , `LastName`  string , `CompanyName`  string , `Photo`  string , `WebsiteURL`  string , `Offering`  string , `Description`  string , `Email`  string , `Notes`  string , `HashId`  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_moloMoloProvidersSet/2026-04-16/1776326560'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomoloprovidersset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMoloProvidersSet/2026-04-16/1776326560
id: 1716399
processed: 1

raw_data:

{
    "CompanyName": 4,
    "Description": 8,
    "Email": 9,
    "FirstName": 1,
    "HashId": 11,
    "Id": 0,
    "LastName": 3,
    "MiddleName": 2,
    "Notes": 10,
    "Offering": 7,
    "Photo": 5,
    "WebsiteURL": 6
}

schema_attributes:

{
    "CompanyName": "string",
    "Description": "string",
    "Email": "string",
    "FirstName": "string",
    "HashId": "string",
    "Id": "string",
    "LastName": "string",
    "MiddleName": "string",
    "Notes": "string",
    "Offering": "string",
    "Photo": "string",
    "WebsiteURL": "string"
}

schema_name_id: 1674
schema_scan_id: 162111824
updated: 2026-04-16 03:07:58

Version 1715249

created: 2026-04-15 03:06:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomoloprovidersset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomoloprovidersset`\n(\n `Id`  string , `FirstName`  string , `MiddleName`  string , `LastName`  string , `CompanyName`  string , `Photo`  string , `WebsiteURL`  string , `Offering`  string , `Description`  string , `Email`  string , `Notes`  string , `HashId`  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_moloMoloProvidersSet/2026-04-15/1776240030'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomoloprovidersset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMoloProvidersSet/2026-04-15/1776240030
id: 1715249
processed: 1

raw_data:

{
    "CompanyName": 4,
    "Description": 8,
    "Email": 9,
    "FirstName": 1,
    "HashId": 11,
    "Id": 0,
    "LastName": 3,
    "MiddleName": 2,
    "Notes": 10,
    "Offering": 7,
    "Photo": 5,
    "WebsiteURL": 6
}

schema_attributes:

{
    "CompanyName": "string",
    "Description": "string",
    "Email": "string",
    "FirstName": "string",
    "HashId": "string",
    "Id": "string",
    "LastName": "string",
    "MiddleName": "string",
    "Notes": "string",
    "Offering": "string",
    "Photo": "string",
    "WebsiteURL": "string"
}

schema_name_id: 1674
schema_scan_id: 162055987
updated: 2026-04-15 03:06:55

Version 1714010

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomoloprovidersset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomoloprovidersset`\n(\n `Id`  string , `FirstName`  string , `MiddleName`  string , `LastName`  string , `CompanyName`  string , `Photo`  string , `WebsiteURL`  string , `Offering`  string , `Description`  string , `Email`  string , `Notes`  string , `HashId`  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_moloMoloProvidersSet/2026-04-14/1776153758'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomoloprovidersset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMoloProvidersSet/2026-04-14/1776153758
id: 1714010
processed: 1

raw_data:

{
    "CompanyName": 4,
    "Description": 8,
    "Email": 9,
    "FirstName": 1,
    "HashId": 11,
    "Id": 0,
    "LastName": 3,
    "MiddleName": 2,
    "Notes": 10,
    "Offering": 7,
    "Photo": 5,
    "WebsiteURL": 6
}

schema_attributes:

{
    "CompanyName": "string",
    "Description": "string",
    "Email": "string",
    "FirstName": "string",
    "HashId": "string",
    "Id": "string",
    "LastName": "string",
    "MiddleName": "string",
    "Notes": "string",
    "Offering": "string",
    "Photo": "string",
    "WebsiteURL": "string"
}

schema_name_id: 1674
schema_scan_id: 162000481
updated: 2026-04-14 03:05:56

Version 1712797

created: 2026-04-13 02:59:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomoloprovidersset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomoloprovidersset`\n(\n `Id`  string , `FirstName`  string , `MiddleName`  string , `LastName`  string , `CompanyName`  string , `Photo`  string , `WebsiteURL`  string , `Offering`  string , `Description`  string , `Email`  string , `Notes`  string , `HashId`  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_moloMoloProvidersSet/2026-04-13/1776066953'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomoloprovidersset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMoloProvidersSet/2026-04-13/1776066953
id: 1712797
processed: 1

raw_data:

{
    "CompanyName": 4,
    "Description": 8,
    "Email": 9,
    "FirstName": 1,
    "HashId": 11,
    "Id": 0,
    "LastName": 3,
    "MiddleName": 2,
    "Notes": 10,
    "Offering": 7,
    "Photo": 5,
    "WebsiteURL": 6
}

schema_attributes:

{
    "CompanyName": "string",
    "Description": "string",
    "Email": "string",
    "FirstName": "string",
    "HashId": "string",
    "Id": "string",
    "LastName": "string",
    "MiddleName": "string",
    "Notes": "string",
    "Offering": "string",
    "Photo": "string",
    "WebsiteURL": "string"
}

schema_name_id: 1674
schema_scan_id: 161941741
updated: 2026-04-13 02:59:26

Version 1711595

created: 2026-04-12 03:00:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomoloprovidersset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomoloprovidersset`\n(\n `Id`  string , `FirstName`  string , `MiddleName`  string , `LastName`  string , `CompanyName`  string , `Photo`  string , `WebsiteURL`  string , `Offering`  string , `Description`  string , `Email`  string , `Notes`  string , `HashId`  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_moloMoloProvidersSet/2026-04-12/1775980666'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomoloprovidersset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMoloProvidersSet/2026-04-12/1775980666
id: 1711595
processed: 1

raw_data:

{
    "CompanyName": 4,
    "Description": 8,
    "Email": 9,
    "FirstName": 1,
    "HashId": 11,
    "Id": 0,
    "LastName": 3,
    "MiddleName": 2,
    "Notes": 10,
    "Offering": 7,
    "Photo": 5,
    "WebsiteURL": 6
}

schema_attributes:

{
    "CompanyName": "string",
    "Description": "string",
    "Email": "string",
    "FirstName": "string",
    "HashId": "string",
    "Id": "string",
    "LastName": "string",
    "MiddleName": "string",
    "Notes": "string",
    "Offering": "string",
    "Photo": "string",
    "WebsiteURL": "string"
}

schema_name_id: 1674
schema_scan_id: 161892679
updated: 2026-04-12 03:01:09

Version 1710380

created: 2026-04-11 03:03:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomoloprovidersset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomoloprovidersset`\n(\n `Id`  string , `FirstName`  string , `MiddleName`  string , `LastName`  string , `CompanyName`  string , `Photo`  string , `WebsiteURL`  string , `Offering`  string , `Description`  string , `Email`  string , `Notes`  string , `HashId`  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_moloMoloProvidersSet/2026-04-11/1775894426'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomoloprovidersset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMoloProvidersSet/2026-04-11/1775894426
id: 1710380
processed: 1

raw_data:

{
    "CompanyName": 4,
    "Description": 8,
    "Email": 9,
    "FirstName": 1,
    "HashId": 11,
    "Id": 0,
    "LastName": 3,
    "MiddleName": 2,
    "Notes": 10,
    "Offering": 7,
    "Photo": 5,
    "WebsiteURL": 6
}

schema_attributes:

{
    "CompanyName": "string",
    "Description": "string",
    "Email": "string",
    "FirstName": "string",
    "HashId": "string",
    "Id": "string",
    "LastName": "string",
    "MiddleName": "string",
    "Notes": "string",
    "Offering": "string",
    "Photo": "string",
    "WebsiteURL": "string"
}

schema_name_id: 1674
schema_scan_id: 161841123
updated: 2026-04-11 03:03:49

Version 1709215

created: 2026-04-10 03:04:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomoloprovidersset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomoloprovidersset`\n(\n `Id`  string , `FirstName`  string , `MiddleName`  string , `LastName`  string , `CompanyName`  string , `Photo`  string , `WebsiteURL`  string , `Offering`  string , `Description`  string , `Email`  string , `Notes`  string , `HashId`  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_moloMoloProvidersSet/2026-04-10/1775808183'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomoloprovidersset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMoloProvidersSet/2026-04-10/1775808183
id: 1709215
processed: 1

raw_data:

{
    "CompanyName": 4,
    "Description": 8,
    "Email": 9,
    "FirstName": 1,
    "HashId": 11,
    "Id": 0,
    "LastName": 3,
    "MiddleName": 2,
    "Notes": 10,
    "Offering": 7,
    "Photo": 5,
    "WebsiteURL": 6
}

schema_attributes:

{
    "CompanyName": "string",
    "Description": "string",
    "Email": "string",
    "FirstName": "string",
    "HashId": "string",
    "Id": "string",
    "LastName": "string",
    "MiddleName": "string",
    "Notes": "string",
    "Offering": "string",
    "Photo": "string",
    "WebsiteURL": "string"
}

schema_name_id: 1674
schema_scan_id: 161785897
updated: 2026-04-10 03:05:11

Version 1708087

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomoloprovidersset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomoloprovidersset`\n(\n `Id`  string , `FirstName`  string , `MiddleName`  string , `LastName`  string , `CompanyName`  string , `Photo`  string , `WebsiteURL`  string , `Offering`  string , `Description`  string , `Email`  string , `Notes`  string , `HashId`  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_moloMoloProvidersSet/2026-04-09/1775721524'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomoloprovidersset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMoloProvidersSet/2026-04-09/1775721524
id: 1708087
processed: 1

raw_data:

{
    "CompanyName": 4,
    "Description": 8,
    "Email": 9,
    "FirstName": 1,
    "HashId": 11,
    "Id": 0,
    "LastName": 3,
    "MiddleName": 2,
    "Notes": 10,
    "Offering": 7,
    "Photo": 5,
    "WebsiteURL": 6
}

schema_attributes:

{
    "CompanyName": "string",
    "Description": "string",
    "Email": "string",
    "FirstName": "string",
    "HashId": "string",
    "Id": "string",
    "LastName": "string",
    "MiddleName": "string",
    "Notes": "string",
    "Offering": "string",
    "Photo": "string",
    "WebsiteURL": "string"
}

schema_name_id: 1674
schema_scan_id: 161730106
updated: 2026-04-09 03:02:02

Version 1706970

created: 2026-04-08 03:08:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomoloprovidersset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomoloprovidersset`\n(\n `Id`  string , `FirstName`  string , `MiddleName`  string , `LastName`  string , `CompanyName`  string , `Photo`  string , `WebsiteURL`  string , `Offering`  string , `Description`  string , `Email`  string , `Notes`  string , `HashId`  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_moloMoloProvidersSet/2026-04-08/1775635352'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomoloprovidersset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMoloProvidersSet/2026-04-08/1775635352
id: 1706970
processed: 1

raw_data:

{
    "CompanyName": 4,
    "Description": 8,
    "Email": 9,
    "FirstName": 1,
    "HashId": 11,
    "Id": 0,
    "LastName": 3,
    "MiddleName": 2,
    "Notes": 10,
    "Offering": 7,
    "Photo": 5,
    "WebsiteURL": 6
}

schema_attributes:

{
    "CompanyName": "string",
    "Description": "string",
    "Email": "string",
    "FirstName": "string",
    "HashId": "string",
    "Id": "string",
    "LastName": "string",
    "MiddleName": "string",
    "Notes": "string",
    "Offering": "string",
    "Photo": "string",
    "WebsiteURL": "string"
}

schema_name_id: 1674
schema_scan_id: 161675626
updated: 2026-04-08 03:08:34

Version 1705725

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomoloprovidersset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomoloprovidersset`\n(\n `Id`  string , `FirstName`  string , `MiddleName`  string , `LastName`  string , `CompanyName`  string , `Photo`  string , `WebsiteURL`  string , `Offering`  string , `Description`  string , `Email`  string , `Notes`  string , `HashId`  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_moloMoloProvidersSet/2026-04-07/1775548502'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomoloprovidersset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMoloProvidersSet/2026-04-07/1775548502
id: 1705725
processed: 1

raw_data:

{
    "CompanyName": 4,
    "Description": 8,
    "Email": 9,
    "FirstName": 1,
    "HashId": 11,
    "Id": 0,
    "LastName": 3,
    "MiddleName": 2,
    "Notes": 10,
    "Offering": 7,
    "Photo": 5,
    "WebsiteURL": 6
}

schema_attributes:

{
    "CompanyName": "string",
    "Description": "string",
    "Email": "string",
    "FirstName": "string",
    "HashId": "string",
    "Id": "string",
    "LastName": "string",
    "MiddleName": "string",
    "Notes": "string",
    "Offering": "string",
    "Photo": "string",
    "WebsiteURL": "string"
}

schema_name_id: 1674
schema_scan_id: 161618438
updated: 2026-04-07 02:58:06

Version 1704578

created: 2026-04-06 03:09:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomoloprovidersset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomoloprovidersset`\n(\n `Id`  string , `FirstName`  string , `MiddleName`  string , `LastName`  string , `CompanyName`  string , `Photo`  string , `WebsiteURL`  string , `Offering`  string , `Description`  string , `Email`  string , `Notes`  string , `HashId`  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_moloMoloProvidersSet/2026-04-06/1775462467'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomoloprovidersset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMoloProvidersSet/2026-04-06/1775462467
id: 1704578
processed: 1

raw_data:

{
    "CompanyName": 4,
    "Description": 8,
    "Email": 9,
    "FirstName": 1,
    "HashId": 11,
    "Id": 0,
    "LastName": 3,
    "MiddleName": 2,
    "Notes": 10,
    "Offering": 7,
    "Photo": 5,
    "WebsiteURL": 6
}

schema_attributes:

{
    "CompanyName": "string",
    "Description": "string",
    "Email": "string",
    "FirstName": "string",
    "HashId": "string",
    "Id": "string",
    "LastName": "string",
    "MiddleName": "string",
    "Notes": "string",
    "Offering": "string",
    "Photo": "string",
    "WebsiteURL": "string"
}

schema_name_id: 1674
schema_scan_id: 161561712
updated: 2026-04-06 03:09:34

Version 1703254

created: 2026-04-05 03:03:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomoloprovidersset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomoloprovidersset`\n(\n `Id`  string , `FirstName`  string , `MiddleName`  string , `LastName`  string , `CompanyName`  string , `Photo`  string , `WebsiteURL`  string , `Offering`  string , `Description`  string , `Email`  string , `Notes`  string , `HashId`  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_moloMoloProvidersSet/2026-04-05/1775376094'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomoloprovidersset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMoloProvidersSet/2026-04-05/1775376094
id: 1703254
processed: 1

raw_data:

{
    "CompanyName": 4,
    "Description": 8,
    "Email": 9,
    "FirstName": 1,
    "HashId": 11,
    "Id": 0,
    "LastName": 3,
    "MiddleName": 2,
    "Notes": 10,
    "Offering": 7,
    "Photo": 5,
    "WebsiteURL": 6
}

schema_attributes:

{
    "CompanyName": "string",
    "Description": "string",
    "Email": "string",
    "FirstName": "string",
    "HashId": "string",
    "Id": "string",
    "LastName": "string",
    "MiddleName": "string",
    "Notes": "string",
    "Offering": "string",
    "Photo": "string",
    "WebsiteURL": "string"
}

schema_name_id: 1674
schema_scan_id: 161514826
updated: 2026-04-05 03:03:30

Version 1702145

created: 2026-04-04 03:04:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomoloprovidersset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomoloprovidersset`\n(\n `Id`  string , `FirstName`  string , `MiddleName`  string , `LastName`  string , `CompanyName`  string , `Photo`  string , `WebsiteURL`  string , `Offering`  string , `Description`  string , `Email`  string , `Notes`  string , `HashId`  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_moloMoloProvidersSet/2026-04-04/1775289576'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomoloprovidersset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMoloProvidersSet/2026-04-04/1775289576
id: 1702145
processed: 1

raw_data:

{
    "CompanyName": 4,
    "Description": 8,
    "Email": 9,
    "FirstName": 1,
    "HashId": 11,
    "Id": 0,
    "LastName": 3,
    "MiddleName": 2,
    "Notes": 10,
    "Offering": 7,
    "Photo": 5,
    "WebsiteURL": 6
}

schema_attributes:

{
    "CompanyName": "string",
    "Description": "string",
    "Email": "string",
    "FirstName": "string",
    "HashId": "string",
    "Id": "string",
    "LastName": "string",
    "MiddleName": "string",
    "Notes": "string",
    "Offering": "string",
    "Photo": "string",
    "WebsiteURL": "string"
}

schema_name_id: 1674
schema_scan_id: 161460334
updated: 2026-04-04 03:04:59

Version 1700887

created: 2026-04-03 03:07:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomoloprovidersset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomoloprovidersset`\n(\n `Id`  string , `FirstName`  string , `MiddleName`  string , `LastName`  string , `CompanyName`  string , `Photo`  string , `WebsiteURL`  string , `Offering`  string , `Description`  string , `Email`  string , `Notes`  string , `HashId`  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_moloMoloProvidersSet/2026-04-03/1775203349'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomoloprovidersset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMoloProvidersSet/2026-04-03/1775203349
id: 1700887
processed: 1

raw_data:

{
    "CompanyName": 4,
    "Description": 8,
    "Email": 9,
    "FirstName": 1,
    "HashId": 11,
    "Id": 0,
    "LastName": 3,
    "MiddleName": 2,
    "Notes": 10,
    "Offering": 7,
    "Photo": 5,
    "WebsiteURL": 6
}

schema_attributes:

{
    "CompanyName": "string",
    "Description": "string",
    "Email": "string",
    "FirstName": "string",
    "HashId": "string",
    "Id": "string",
    "LastName": "string",
    "MiddleName": "string",
    "Notes": "string",
    "Offering": "string",
    "Photo": "string",
    "WebsiteURL": "string"
}

schema_name_id: 1674
schema_scan_id: 161401817
updated: 2026-04-03 03:07:47

Schema Scans: 15

Last at 2026-04-17 03:05:50

Scan 162167640

duration: 0:00:14.358357

exit_message:

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

id: 162167640

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_moloMoloProvidersSet/2026-04-17/1776412806",
        "key": "raw/molo_moloMoloProvidersSet/2026-04-17/1776412806/MoloProvidersSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMoloProvidersSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17692417486585607965,
        "service_name": "drive-thru",
        "span_id": 17995165907741346776,
        "trace_id": 6928894353502466824
    }
}

running: False
schema_name_id: 1674
start_time: 2026-04-17 03:05:50
success: True
trace_id: 6928894353502466824

Scan 162111824

duration: 0:00:11.785891

exit_message:

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

id: 162111824

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_moloMoloProvidersSet/2026-04-16/1776326560",
        "key": "raw/molo_moloMoloProvidersSet/2026-04-16/1776326560/MoloProvidersSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMoloProvidersSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2143395654506695158,
        "service_name": "drive-thru",
        "span_id": 13910243295829734975,
        "trace_id": 10591369116226265443
    }
}

running: False
schema_name_id: 1674
start_time: 2026-04-16 03:07:46
success: True
trace_id: 10591369116226265443

Scan 162055987

duration: 0:00:11.675477

exit_message:

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

id: 162055987

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_moloMoloProvidersSet/2026-04-15/1776240030",
        "key": "raw/molo_moloMoloProvidersSet/2026-04-15/1776240030/MoloProvidersSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMoloProvidersSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13471935107804398970,
        "service_name": "drive-thru",
        "span_id": 12988502291108815601,
        "trace_id": 9115679210388260342
    }
}

running: False
schema_name_id: 1674
start_time: 2026-04-15 03:06:44
success: True
trace_id: 9115679210388260342

Scan 162000481

duration: 0:00:14.407780

exit_message:

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

id: 162000481

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_moloMoloProvidersSet/2026-04-14/1776153758",
        "key": "raw/molo_moloMoloProvidersSet/2026-04-14/1776153758/MoloProvidersSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMoloProvidersSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12489697656629814721,
        "service_name": "drive-thru",
        "span_id": 9026649050041204670,
        "trace_id": 295508866891032806
    }
}

running: False
schema_name_id: 1674
start_time: 2026-04-14 03:05:42
success: True
trace_id: 295508866891032806

Scan 161941741

duration: 0:00:14.304478

exit_message:

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

id: 161941741

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_moloMoloProvidersSet/2026-04-13/1776066953",
        "key": "raw/molo_moloMoloProvidersSet/2026-04-13/1776066953/MoloProvidersSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMoloProvidersSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18160561989125926832,
        "service_name": "drive-thru",
        "span_id": 15599380694836638553,
        "trace_id": 4935372135624326401
    }
}

running: False
schema_name_id: 1674
start_time: 2026-04-13 02:59:12
success: True
trace_id: 4935372135624326401

Scan 161892679

duration: 0:00:14.218140

exit_message:

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

id: 161892679

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_moloMoloProvidersSet/2026-04-12/1775980666",
        "key": "raw/molo_moloMoloProvidersSet/2026-04-12/1775980666/MoloProvidersSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMoloProvidersSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8957015802869521298,
        "service_name": "drive-thru",
        "span_id": 11218581355034628739,
        "trace_id": 10226895374682540176
    }
}

running: False
schema_name_id: 1674
start_time: 2026-04-12 03:00:55
success: True
trace_id: 10226895374682540176

Scan 161841123

duration: 0:00:14.276628

exit_message:

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

id: 161841123

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_moloMoloProvidersSet/2026-04-11/1775894426",
        "key": "raw/molo_moloMoloProvidersSet/2026-04-11/1775894426/MoloProvidersSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMoloProvidersSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12022401427552480559,
        "service_name": "drive-thru",
        "span_id": 7401461950125180421,
        "trace_id": 12363678485803061371
    }
}

running: False
schema_name_id: 1674
start_time: 2026-04-11 03:03:35
success: True
trace_id: 12363678485803061371

Scan 161785897

duration: 0:00:14.347412

exit_message:

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

id: 161785897

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_moloMoloProvidersSet/2026-04-10/1775808183",
        "key": "raw/molo_moloMoloProvidersSet/2026-04-10/1775808183/MoloProvidersSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMoloProvidersSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10428168260398000974,
        "service_name": "drive-thru",
        "span_id": 8344186856717900273,
        "trace_id": 1989967785659706060
    }
}

running: False
schema_name_id: 1674
start_time: 2026-04-10 03:04:57
success: True
trace_id: 1989967785659706060

Scan 161730106

duration: 0:00:11.799867

exit_message:

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

id: 161730106

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_moloMoloProvidersSet/2026-04-09/1775721524",
        "key": "raw/molo_moloMoloProvidersSet/2026-04-09/1775721524/MoloProvidersSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMoloProvidersSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10434537452883480983,
        "service_name": "drive-thru",
        "span_id": 8455752952484809786,
        "trace_id": 9490380966093266937
    }
}

running: False
schema_name_id: 1674
start_time: 2026-04-09 03:01:50
success: True
trace_id: 9490380966093266937

Scan 161675626

duration: 0:00:11.760188

exit_message:

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

id: 161675626

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_moloMoloProvidersSet/2026-04-08/1775635352",
        "key": "raw/molo_moloMoloProvidersSet/2026-04-08/1775635352/MoloProvidersSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMoloProvidersSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15958462652528013016,
        "service_name": "drive-thru",
        "span_id": 9333005888401655730,
        "trace_id": 4512306246483397194
    }
}

running: False
schema_name_id: 1674
start_time: 2026-04-08 03:08:22
success: True
trace_id: 4512306246483397194

Scan 161618438

duration: 0:00:11.713270

exit_message:

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

id: 161618438

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_moloMoloProvidersSet/2026-04-07/1775548502",
        "key": "raw/molo_moloMoloProvidersSet/2026-04-07/1775548502/MoloProvidersSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMoloProvidersSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8247068927349717103,
        "service_name": "drive-thru",
        "span_id": 16304808050406836542,
        "trace_id": 11817498870606217544
    }
}

running: False
schema_name_id: 1674
start_time: 2026-04-07 02:57:54
success: True
trace_id: 11817498870606217544

Scan 161561712

duration: 0:00:14.317774

exit_message:

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

id: 161561712

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_moloMoloProvidersSet/2026-04-06/1775462467",
        "key": "raw/molo_moloMoloProvidersSet/2026-04-06/1775462467/MoloProvidersSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMoloProvidersSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17684484295923468530,
        "service_name": "drive-thru",
        "span_id": 6337466384825648634,
        "trace_id": 12978965041625643011
    }
}

running: False
schema_name_id: 1674
start_time: 2026-04-06 03:09:19
success: True
trace_id: 12978965041625643011

Scan 161514826

duration: 0:00:14.244110

exit_message:

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

id: 161514826

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_moloMoloProvidersSet/2026-04-05/1775376094",
        "key": "raw/molo_moloMoloProvidersSet/2026-04-05/1775376094/MoloProvidersSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMoloProvidersSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9390784671445889540,
        "service_name": "drive-thru",
        "span_id": 18181774741143471630,
        "trace_id": 9440057118562092603
    }
}

running: False
schema_name_id: 1674
start_time: 2026-04-05 03:03:16
success: True
trace_id: 9440057118562092603

Scan 161460334

duration: 0:00:14.294933

exit_message:

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

id: 161460334

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_moloMoloProvidersSet/2026-04-04/1775289576",
        "key": "raw/molo_moloMoloProvidersSet/2026-04-04/1775289576/MoloProvidersSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMoloProvidersSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4203574816219505373,
        "service_name": "drive-thru",
        "span_id": 2269383571597133653,
        "trace_id": 11837276730843942954
    }
}

running: False
schema_name_id: 1674
start_time: 2026-04-04 03:04:45
success: True
trace_id: 11837276730843942954

Scan 161401817

duration: 0:00:11.786457

exit_message:

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

id: 161401817

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_moloMoloProvidersSet/2026-04-03/1775203349",
        "key": "raw/molo_moloMoloProvidersSet/2026-04-03/1775203349/MoloProvidersSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMoloProvidersSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13875162142069905135,
        "service_name": "drive-thru",
        "span_id": 11341605932230568227,
        "trace_id": 2438463078445597944
    }
}

running: False
schema_name_id: 1674
start_time: 2026-04-03 03:07:35
success: True
trace_id: 2438463078445597944

Partitions:

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

Schema:

attributes:

{
    "CompanyName": "string",
    "Description": "string",
    "Email": "string",
    "FirstName": "string",
    "HashId": "string",
    "Id": "string",
    "LastName": "string",
    "MiddleName": "string",
    "Notes": "string",
    "Offering": "string",
    "Photo": "string",
    "WebsiteURL": "string"
}

created: 2026-04-17 03:05:50

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomoloprovidersset`\n(\n `Id`  string , `FirstName`  string , `MiddleName`  string , `LastName`  string , `CompanyName`  string , `Photo`  string , `WebsiteURL`  string , `Offering`  string , `Description`  string , `Email`  string , `Notes`  string , `HashId`  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_moloMoloProvidersSet/2026-04-17/1776412806'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomoloprovidersset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomoloprovidersset"
}

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:57:56",
        "disabled": false,
        "format": "raw",
        "id": 1674,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molomoloprovidersset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "CompanyName": "string",
            "Description": "string",
            "Email": "string",
            "FirstName": "string",
            "HashId": "string",
            "Id": "string",
            "LastName": "string",
            "MiddleName": "string",
            "Notes": "string",
            "Offering": "string",
            "Photo": "string",
            "WebsiteURL": "string"
        },
        "created": "2026-04-17 03:05:50",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomoloprovidersset`\n(\n `Id`  string , `FirstName`  string , `MiddleName`  string , `LastName`  string , `CompanyName`  string , `Photo`  string , `WebsiteURL`  string , `Offering`  string , `Description`  string , `Email`  string , `Notes`  string , `HashId`  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_moloMoloProvidersSet/2026-04-17/1776412806'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomoloprovidersset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomoloprovidersset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}