Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloscheduledreportset

created: 2023-10-17 02:01:15
disabled: False
format: raw
id: 1768
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717728

created: 2026-04-17 03:08:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloscheduledreportset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloscheduledreportset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUser`  string , `MarinaLocationId`  string , `CompanyId`  string , `RecordStatusId`  string , `SendTo`  string , `Mode`  string , `RunDay`  string , `DelayDays`  string , `ReportName`  string , `ReportConfig`  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_moloScheduledReportSet/2026-04-17/1776412848'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloscheduledreportset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloScheduledReportSet/2026-04-17/1776412848
id: 1717728
processed: 1

raw_data:

{
    "CompanyId": 4,
    "CreationAspNetUser": 2,
    "CreationDateTime": 1,
    "DelayDays": 9,
    "Id": 0,
    "MarinaLocationId": 3,
    "Mode": 7,
    "RecordStatusId": 5,
    "ReportConfig": 11,
    "ReportName": 10,
    "RunDay": 8,
    "SendTo": 6
}

schema_attributes:

{
    "CompanyId": "string",
    "CreationAspNetUser": "string",
    "CreationDateTime": "string",
    "DelayDays": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Mode": "string",
    "RecordStatusId": "string",
    "ReportConfig": "string",
    "ReportName": "string",
    "RunDay": "string",
    "SendTo": "string"
}

schema_name_id: 1768
schema_scan_id: 162167728
updated: 2026-04-17 03:08:45

Version 1716456

created: 2026-04-16 03:09:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloscheduledreportset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloscheduledreportset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUser`  string , `MarinaLocationId`  string , `CompanyId`  string , `RecordStatusId`  string , `SendTo`  string , `Mode`  string , `RunDay`  string , `DelayDays`  string , `ReportName`  string , `ReportConfig`  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_moloScheduledReportSet/2026-04-16/1776326602'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloscheduledreportset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloScheduledReportSet/2026-04-16/1776326602
id: 1716456
processed: 1

raw_data:

{
    "CompanyId": 4,
    "CreationAspNetUser": 2,
    "CreationDateTime": 1,
    "DelayDays": 9,
    "Id": 0,
    "MarinaLocationId": 3,
    "Mode": 7,
    "RecordStatusId": 5,
    "ReportConfig": 11,
    "ReportName": 10,
    "RunDay": 8,
    "SendTo": 6
}

schema_attributes:

{
    "CompanyId": "string",
    "CreationAspNetUser": "string",
    "CreationDateTime": "string",
    "DelayDays": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Mode": "string",
    "RecordStatusId": "string",
    "ReportConfig": "string",
    "ReportName": "string",
    "RunDay": "string",
    "SendTo": "string"
}

schema_name_id: 1768
schema_scan_id: 162111891
updated: 2026-04-16 03:10:06

Version 1715242

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloscheduledreportset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloscheduledreportset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUser`  string , `MarinaLocationId`  string , `CompanyId`  string , `RecordStatusId`  string , `SendTo`  string , `Mode`  string , `RunDay`  string , `DelayDays`  string , `ReportName`  string , `ReportConfig`  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_moloScheduledReportSet/2026-04-15/1776240072'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloscheduledreportset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloScheduledReportSet/2026-04-15/1776240072
id: 1715242
processed: 1

raw_data:

{
    "CompanyId": 4,
    "CreationAspNetUser": 2,
    "CreationDateTime": 1,
    "DelayDays": 9,
    "Id": 0,
    "MarinaLocationId": 3,
    "Mode": 7,
    "RecordStatusId": 5,
    "ReportConfig": 11,
    "ReportName": 10,
    "RunDay": 8,
    "SendTo": 6
}

schema_attributes:

{
    "CompanyId": "string",
    "CreationAspNetUser": "string",
    "CreationDateTime": "string",
    "DelayDays": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Mode": "string",
    "RecordStatusId": "string",
    "ReportConfig": "string",
    "ReportName": "string",
    "RunDay": "string",
    "SendTo": "string"
}

schema_name_id: 1768
schema_scan_id: 162055978
updated: 2026-04-15 03:06:40

Version 1714061

created: 2026-04-14 03:07:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloscheduledreportset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloscheduledreportset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUser`  string , `MarinaLocationId`  string , `CompanyId`  string , `RecordStatusId`  string , `SendTo`  string , `Mode`  string , `RunDay`  string , `DelayDays`  string , `ReportName`  string , `ReportConfig`  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_moloScheduledReportSet/2026-04-14/1776153837'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloscheduledreportset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloScheduledReportSet/2026-04-14/1776153837
id: 1714061
processed: 1

raw_data:

{
    "CompanyId": 4,
    "CreationAspNetUser": 2,
    "CreationDateTime": 1,
    "DelayDays": 9,
    "Id": 0,
    "MarinaLocationId": 3,
    "Mode": 7,
    "RecordStatusId": 5,
    "ReportConfig": 11,
    "ReportName": 10,
    "RunDay": 8,
    "SendTo": 6
}

schema_attributes:

{
    "CompanyId": "string",
    "CreationAspNetUser": "string",
    "CreationDateTime": "string",
    "DelayDays": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Mode": "string",
    "RecordStatusId": "string",
    "ReportConfig": "string",
    "ReportName": "string",
    "RunDay": "string",
    "SendTo": "string"
}

schema_name_id: 1768
schema_scan_id: 162000560
updated: 2026-04-14 03:08:04

Version 1712856

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloscheduledreportset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloscheduledreportset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUser`  string , `MarinaLocationId`  string , `CompanyId`  string , `RecordStatusId`  string , `SendTo`  string , `Mode`  string , `RunDay`  string , `DelayDays`  string , `ReportName`  string , `ReportConfig`  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_moloScheduledReportSet/2026-04-13/1776066998'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloscheduledreportset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloScheduledReportSet/2026-04-13/1776066998
id: 1712856
processed: 1

raw_data:

{
    "CompanyId": 4,
    "CreationAspNetUser": 2,
    "CreationDateTime": 1,
    "DelayDays": 9,
    "Id": 0,
    "MarinaLocationId": 3,
    "Mode": 7,
    "RecordStatusId": 5,
    "ReportConfig": 11,
    "ReportName": 10,
    "RunDay": 8,
    "SendTo": 6
}

schema_attributes:

{
    "CompanyId": "string",
    "CreationAspNetUser": "string",
    "CreationDateTime": "string",
    "DelayDays": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Mode": "string",
    "RecordStatusId": "string",
    "ReportConfig": "string",
    "ReportName": "string",
    "RunDay": "string",
    "SendTo": "string"
}

schema_name_id: 1768
schema_scan_id: 161941963
updated: 2026-04-13 03:01:06

Version 1711633

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloscheduledreportset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloscheduledreportset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUser`  string , `MarinaLocationId`  string , `CompanyId`  string , `RecordStatusId`  string , `SendTo`  string , `Mode`  string , `RunDay`  string , `DelayDays`  string , `ReportName`  string , `ReportConfig`  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_moloScheduledReportSet/2026-04-12/1775980708'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloscheduledreportset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloScheduledReportSet/2026-04-12/1775980708
id: 1711633
processed: 1

raw_data:

{
    "CompanyId": 4,
    "CreationAspNetUser": 2,
    "CreationDateTime": 1,
    "DelayDays": 9,
    "Id": 0,
    "MarinaLocationId": 3,
    "Mode": 7,
    "RecordStatusId": 5,
    "ReportConfig": 11,
    "ReportName": 10,
    "RunDay": 8,
    "SendTo": 6
}

schema_attributes:

{
    "CompanyId": "string",
    "CreationAspNetUser": "string",
    "CreationDateTime": "string",
    "DelayDays": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Mode": "string",
    "RecordStatusId": "string",
    "ReportConfig": "string",
    "ReportName": "string",
    "RunDay": "string",
    "SendTo": "string"
}

schema_name_id: 1768
schema_scan_id: 161892812
updated: 2026-04-12 03:02:14

Version 1710536

created: 2026-04-11 03:09:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloscheduledreportset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloscheduledreportset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUser`  string , `MarinaLocationId`  string , `CompanyId`  string , `RecordStatusId`  string , `SendTo`  string , `Mode`  string , `RunDay`  string , `DelayDays`  string , `ReportName`  string , `ReportConfig`  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_moloScheduledReportSet/2026-04-11/1775894474'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloscheduledreportset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloScheduledReportSet/2026-04-11/1775894474
id: 1710536
processed: 1

raw_data:

{
    "CompanyId": 4,
    "CreationAspNetUser": 2,
    "CreationDateTime": 1,
    "DelayDays": 9,
    "Id": 0,
    "MarinaLocationId": 3,
    "Mode": 7,
    "RecordStatusId": 5,
    "ReportConfig": 11,
    "ReportName": 10,
    "RunDay": 8,
    "SendTo": 6
}

schema_attributes:

{
    "CompanyId": "string",
    "CreationAspNetUser": "string",
    "CreationDateTime": "string",
    "DelayDays": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Mode": "string",
    "RecordStatusId": "string",
    "ReportConfig": "string",
    "ReportName": "string",
    "RunDay": "string",
    "SendTo": "string"
}

schema_name_id: 1768
schema_scan_id: 161841335
updated: 2026-04-11 03:10:05

Version 1709262

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloscheduledreportset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloscheduledreportset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUser`  string , `MarinaLocationId`  string , `CompanyId`  string , `RecordStatusId`  string , `SendTo`  string , `Mode`  string , `RunDay`  string , `DelayDays`  string , `ReportName`  string , `ReportConfig`  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_moloScheduledReportSet/2026-04-10/1775808233'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloscheduledreportset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloScheduledReportSet/2026-04-10/1775808233
id: 1709262
processed: 1

raw_data:

{
    "CompanyId": 4,
    "CreationAspNetUser": 2,
    "CreationDateTime": 1,
    "DelayDays": 9,
    "Id": 0,
    "MarinaLocationId": 3,
    "Mode": 7,
    "RecordStatusId": 5,
    "ReportConfig": 11,
    "ReportName": 10,
    "RunDay": 8,
    "SendTo": 6
}

schema_attributes:

{
    "CompanyId": "string",
    "CreationAspNetUser": "string",
    "CreationDateTime": "string",
    "DelayDays": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Mode": "string",
    "RecordStatusId": "string",
    "ReportConfig": "string",
    "ReportName": "string",
    "RunDay": "string",
    "SendTo": "string"
}

schema_name_id: 1768
schema_scan_id: 161785949
updated: 2026-04-10 03:06:58

Version 1708195

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloscheduledreportset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloscheduledreportset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUser`  string , `MarinaLocationId`  string , `CompanyId`  string , `RecordStatusId`  string , `SendTo`  string , `Mode`  string , `RunDay`  string , `DelayDays`  string , `ReportName`  string , `ReportConfig`  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_moloScheduledReportSet/2026-04-09/1775721566'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloscheduledreportset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloScheduledReportSet/2026-04-09/1775721566
id: 1708195
processed: 1

raw_data:

{
    "CompanyId": 4,
    "CreationAspNetUser": 2,
    "CreationDateTime": 1,
    "DelayDays": 9,
    "Id": 0,
    "MarinaLocationId": 3,
    "Mode": 7,
    "RecordStatusId": 5,
    "ReportConfig": 11,
    "ReportName": 10,
    "RunDay": 8,
    "SendTo": 6
}

schema_attributes:

{
    "CompanyId": "string",
    "CreationAspNetUser": "string",
    "CreationDateTime": "string",
    "DelayDays": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Mode": "string",
    "RecordStatusId": "string",
    "ReportConfig": "string",
    "ReportName": "string",
    "RunDay": "string",
    "SendTo": "string"
}

schema_name_id: 1768
schema_scan_id: 161730436
updated: 2026-04-09 03:06:58

Version 1707015

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloscheduledreportset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloscheduledreportset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUser`  string , `MarinaLocationId`  string , `CompanyId`  string , `RecordStatusId`  string , `SendTo`  string , `Mode`  string , `RunDay`  string , `DelayDays`  string , `ReportName`  string , `ReportConfig`  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_moloScheduledReportSet/2026-04-08/1775635394'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloscheduledreportset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloScheduledReportSet/2026-04-08/1775635394
id: 1707015
processed: 1

raw_data:

{
    "CompanyId": 4,
    "CreationAspNetUser": 2,
    "CreationDateTime": 1,
    "DelayDays": 9,
    "Id": 0,
    "MarinaLocationId": 3,
    "Mode": 7,
    "RecordStatusId": 5,
    "ReportConfig": 11,
    "ReportName": 10,
    "RunDay": 8,
    "SendTo": 6
}

schema_attributes:

{
    "CompanyId": "string",
    "CreationAspNetUser": "string",
    "CreationDateTime": "string",
    "DelayDays": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Mode": "string",
    "RecordStatusId": "string",
    "ReportConfig": "string",
    "ReportName": "string",
    "RunDay": "string",
    "SendTo": "string"
}

schema_name_id: 1768
schema_scan_id: 161675678
updated: 2026-04-08 03:10:11

Version 1705773

created: 2026-04-07 02:59:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloscheduledreportset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloscheduledreportset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUser`  string , `MarinaLocationId`  string , `CompanyId`  string , `RecordStatusId`  string , `SendTo`  string , `Mode`  string , `RunDay`  string , `DelayDays`  string , `ReportName`  string , `ReportConfig`  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_moloScheduledReportSet/2026-04-07/1775548550'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloscheduledreportset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloScheduledReportSet/2026-04-07/1775548550
id: 1705773
processed: 1

raw_data:

{
    "CompanyId": 4,
    "CreationAspNetUser": 2,
    "CreationDateTime": 1,
    "DelayDays": 9,
    "Id": 0,
    "MarinaLocationId": 3,
    "Mode": 7,
    "RecordStatusId": 5,
    "ReportConfig": 11,
    "ReportName": 10,
    "RunDay": 8,
    "SendTo": 6
}

schema_attributes:

{
    "CompanyId": "string",
    "CreationAspNetUser": "string",
    "CreationDateTime": "string",
    "DelayDays": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Mode": "string",
    "RecordStatusId": "string",
    "ReportConfig": "string",
    "ReportName": "string",
    "RunDay": "string",
    "SendTo": "string"
}

schema_name_id: 1768
schema_scan_id: 161618668
updated: 2026-04-07 02:59:57

Version 1704624

created: 2026-04-06 03:11:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloscheduledreportset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloscheduledreportset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUser`  string , `MarinaLocationId`  string , `CompanyId`  string , `RecordStatusId`  string , `SendTo`  string , `Mode`  string , `RunDay`  string , `DelayDays`  string , `ReportName`  string , `ReportConfig`  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_moloScheduledReportSet/2026-04-06/1775462510'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloscheduledreportset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloScheduledReportSet/2026-04-06/1775462510
id: 1704624
processed: 1

raw_data:

{
    "CompanyId": 4,
    "CreationAspNetUser": 2,
    "CreationDateTime": 1,
    "DelayDays": 9,
    "Id": 0,
    "MarinaLocationId": 3,
    "Mode": 7,
    "RecordStatusId": 5,
    "ReportConfig": 11,
    "ReportName": 10,
    "RunDay": 8,
    "SendTo": 6
}

schema_attributes:

{
    "CompanyId": "string",
    "CreationAspNetUser": "string",
    "CreationDateTime": "string",
    "DelayDays": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Mode": "string",
    "RecordStatusId": "string",
    "ReportConfig": "string",
    "ReportName": "string",
    "RunDay": "string",
    "SendTo": "string"
}

schema_name_id: 1768
schema_scan_id: 161561772
updated: 2026-04-06 03:11:17

Version 1703411

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloscheduledreportset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloscheduledreportset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUser`  string , `MarinaLocationId`  string , `CompanyId`  string , `RecordStatusId`  string , `SendTo`  string , `Mode`  string , `RunDay`  string , `DelayDays`  string , `ReportName`  string , `ReportConfig`  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_moloScheduledReportSet/2026-04-05/1775376137'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloscheduledreportset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloScheduledReportSet/2026-04-05/1775376137
id: 1703411
processed: 1

raw_data:

{
    "CompanyId": 4,
    "CreationAspNetUser": 2,
    "CreationDateTime": 1,
    "DelayDays": 9,
    "Id": 0,
    "MarinaLocationId": 3,
    "Mode": 7,
    "RecordStatusId": 5,
    "ReportConfig": 11,
    "ReportName": 10,
    "RunDay": 8,
    "SendTo": 6
}

schema_attributes:

{
    "CompanyId": "string",
    "CreationAspNetUser": "string",
    "CreationDateTime": "string",
    "DelayDays": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Mode": "string",
    "RecordStatusId": "string",
    "ReportConfig": "string",
    "ReportName": "string",
    "RunDay": "string",
    "SendTo": "string"
}

schema_name_id: 1768
schema_scan_id: 161514997
updated: 2026-04-05 03:09:46

Version 1702140

created: 2026-04-04 03:04:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloscheduledreportset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloscheduledreportset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUser`  string , `MarinaLocationId`  string , `CompanyId`  string , `RecordStatusId`  string , `SendTo`  string , `Mode`  string , `RunDay`  string , `DelayDays`  string , `ReportName`  string , `ReportConfig`  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_moloScheduledReportSet/2026-04-04/1775289619'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloscheduledreportset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloScheduledReportSet/2026-04-04/1775289619
id: 1702140
processed: 1

raw_data:

{
    "CompanyId": 4,
    "CreationAspNetUser": 2,
    "CreationDateTime": 1,
    "DelayDays": 9,
    "Id": 0,
    "MarinaLocationId": 3,
    "Mode": 7,
    "RecordStatusId": 5,
    "ReportConfig": 11,
    "ReportName": 10,
    "RunDay": 8,
    "SendTo": 6
}

schema_attributes:

{
    "CompanyId": "string",
    "CreationAspNetUser": "string",
    "CreationDateTime": "string",
    "DelayDays": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Mode": "string",
    "RecordStatusId": "string",
    "ReportConfig": "string",
    "ReportName": "string",
    "RunDay": "string",
    "SendTo": "string"
}

schema_name_id: 1768
schema_scan_id: 161460321
updated: 2026-04-04 03:04:41

Version 1700866

created: 2026-04-03 03:06:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloscheduledreportset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloscheduledreportset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUser`  string , `MarinaLocationId`  string , `CompanyId`  string , `RecordStatusId`  string , `SendTo`  string , `Mode`  string , `RunDay`  string , `DelayDays`  string , `ReportName`  string , `ReportConfig`  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_moloScheduledReportSet/2026-04-03/1775203391'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloscheduledreportset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloScheduledReportSet/2026-04-03/1775203391
id: 1700866
processed: 1

raw_data:

{
    "CompanyId": 4,
    "CreationAspNetUser": 2,
    "CreationDateTime": 1,
    "DelayDays": 9,
    "Id": 0,
    "MarinaLocationId": 3,
    "Mode": 7,
    "RecordStatusId": 5,
    "ReportConfig": 11,
    "ReportName": 10,
    "RunDay": 8,
    "SendTo": 6
}

schema_attributes:

{
    "CompanyId": "string",
    "CreationAspNetUser": "string",
    "CreationDateTime": "string",
    "DelayDays": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Mode": "string",
    "RecordStatusId": "string",
    "ReportConfig": "string",
    "ReportName": "string",
    "RunDay": "string",
    "SendTo": "string"
}

schema_name_id: 1768
schema_scan_id: 161401783
updated: 2026-04-03 03:06:50

Schema Scans: 15

Last at 2026-04-17 03:08:33

Scan 162167728

duration: 0:00:11.903508

exit_message:

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

id: 162167728

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_moloScheduledReportSet/2026-04-17/1776412848",
        "key": "raw/molo_moloScheduledReportSet/2026-04-17/1776412848/ScheduledReportSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloScheduledReportSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16169067631688638510,
        "service_name": "drive-thru",
        "span_id": 1282939416523053514,
        "trace_id": 9390503913945972209
    }
}

running: False
schema_name_id: 1768
start_time: 2026-04-17 03:08:33
success: True
trace_id: 9390503913945972209

Scan 162111891

duration: 0:00:11.900737

exit_message:

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

id: 162111891

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_moloScheduledReportSet/2026-04-16/1776326602",
        "key": "raw/molo_moloScheduledReportSet/2026-04-16/1776326602/ScheduledReportSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloScheduledReportSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17174589122456819123,
        "service_name": "drive-thru",
        "span_id": 18290024633562464729,
        "trace_id": 12741096562756666950
    }
}

running: False
schema_name_id: 1768
start_time: 2026-04-16 03:09:54
success: True
trace_id: 12741096562756666950

Scan 162055978

duration: 0:00:11.833940

exit_message:

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

id: 162055978

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_moloScheduledReportSet/2026-04-15/1776240072",
        "key": "raw/molo_moloScheduledReportSet/2026-04-15/1776240072/ScheduledReportSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloScheduledReportSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1060005755462149071,
        "service_name": "drive-thru",
        "span_id": 9127860867648705238,
        "trace_id": 12423687984187067042
    }
}

running: False
schema_name_id: 1768
start_time: 2026-04-15 03:06:28
success: True
trace_id: 12423687984187067042

Scan 162000560

duration: 0:00:14.382048

exit_message:

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

id: 162000560

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_moloScheduledReportSet/2026-04-14/1776153837",
        "key": "raw/molo_moloScheduledReportSet/2026-04-14/1776153837/ScheduledReportSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloScheduledReportSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12450530009189401715,
        "service_name": "drive-thru",
        "span_id": 10980492779776983076,
        "trace_id": 8912445879974073329
    }
}

running: False
schema_name_id: 1768
start_time: 2026-04-14 03:07:50
success: True
trace_id: 8912445879974073329

Scan 161941963

duration: 0:00:11.812533

exit_message:

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

id: 161941963

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_moloScheduledReportSet/2026-04-13/1776066998",
        "key": "raw/molo_moloScheduledReportSet/2026-04-13/1776066998/ScheduledReportSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloScheduledReportSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3480732294983987203,
        "service_name": "drive-thru",
        "span_id": 4680326556985292157,
        "trace_id": 438017185735144505
    }
}

running: False
schema_name_id: 1768
start_time: 2026-04-13 03:00:55
success: True
trace_id: 438017185735144505

Scan 161892812

duration: 0:00:14.639069

exit_message:

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

id: 161892812

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_moloScheduledReportSet/2026-04-12/1775980708",
        "key": "raw/molo_moloScheduledReportSet/2026-04-12/1775980708/ScheduledReportSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloScheduledReportSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6367320539702000750,
        "service_name": "drive-thru",
        "span_id": 12617739466891583643,
        "trace_id": 18416645367238098675
    }
}

running: False
schema_name_id: 1768
start_time: 2026-04-12 03:01:59
success: True
trace_id: 18416645367238098675

Scan 161841335

duration: 0:00:14.289947

exit_message:

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

id: 161841335

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_moloScheduledReportSet/2026-04-11/1775894474",
        "key": "raw/molo_moloScheduledReportSet/2026-04-11/1775894474/ScheduledReportSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloScheduledReportSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 206359573394458700,
        "service_name": "drive-thru",
        "span_id": 8121302718054171318,
        "trace_id": 12893908135493304014
    }
}

running: False
schema_name_id: 1768
start_time: 2026-04-11 03:09:51
success: True
trace_id: 12893908135493304014

Scan 161785949

duration: 0:00:14.324484

exit_message:

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

id: 161785949

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_moloScheduledReportSet/2026-04-10/1775808233",
        "key": "raw/molo_moloScheduledReportSet/2026-04-10/1775808233/ScheduledReportSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloScheduledReportSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1453626230939760477,
        "service_name": "drive-thru",
        "span_id": 7227456489563927727,
        "trace_id": 15025375984271257399
    }
}

running: False
schema_name_id: 1768
start_time: 2026-04-10 03:06:44
success: True
trace_id: 15025375984271257399

Scan 161730436

duration: 0:00:14.330628

exit_message:

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

id: 161730436

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_moloScheduledReportSet/2026-04-09/1775721566",
        "key": "raw/molo_moloScheduledReportSet/2026-04-09/1775721566/ScheduledReportSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloScheduledReportSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15008844660798389936,
        "service_name": "drive-thru",
        "span_id": 4504874032930831656,
        "trace_id": 4212801990284845952
    }
}

running: False
schema_name_id: 1768
start_time: 2026-04-09 03:06:44
success: True
trace_id: 4212801990284845952

Scan 161675678

duration: 0:00:12.181075

exit_message:

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

id: 161675678

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_moloScheduledReportSet/2026-04-08/1775635394",
        "key": "raw/molo_moloScheduledReportSet/2026-04-08/1775635394/ScheduledReportSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloScheduledReportSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14164813796654290483,
        "service_name": "drive-thru",
        "span_id": 10299143658348347563,
        "trace_id": 5233237712027363527
    }
}

running: False
schema_name_id: 1768
start_time: 2026-04-08 03:09:59
success: True
trace_id: 5233237712027363527

Scan 161618668

duration: 0:00:14.310123

exit_message:

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

id: 161618668

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_moloScheduledReportSet/2026-04-07/1775548550",
        "key": "raw/molo_moloScheduledReportSet/2026-04-07/1775548550/ScheduledReportSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloScheduledReportSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3720394038187022888,
        "service_name": "drive-thru",
        "span_id": 7108856523158110790,
        "trace_id": 4083084372436698070
    }
}

running: False
schema_name_id: 1768
start_time: 2026-04-07 02:59:43
success: True
trace_id: 4083084372436698070

Scan 161561772

duration: 0:00:11.789540

exit_message:

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

id: 161561772

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_moloScheduledReportSet/2026-04-06/1775462510",
        "key": "raw/molo_moloScheduledReportSet/2026-04-06/1775462510/ScheduledReportSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloScheduledReportSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9211568850540145712,
        "service_name": "drive-thru",
        "span_id": 2305226601791885986,
        "trace_id": 16706582592337811841
    }
}

running: False
schema_name_id: 1768
start_time: 2026-04-06 03:11:05
success: True
trace_id: 16706582592337811841

Scan 161514997

duration: 0:00:14.310449

exit_message:

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

id: 161514997

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_moloScheduledReportSet/2026-04-05/1775376137",
        "key": "raw/molo_moloScheduledReportSet/2026-04-05/1775376137/ScheduledReportSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloScheduledReportSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15017470209605914242,
        "service_name": "drive-thru",
        "span_id": 10695395332897933468,
        "trace_id": 9451739457167824517
    }
}

running: False
schema_name_id: 1768
start_time: 2026-04-05 03:09:31
success: True
trace_id: 9451739457167824517

Scan 161460321

duration: 0:00:14.358731

exit_message:

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

id: 161460321

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_moloScheduledReportSet/2026-04-04/1775289619",
        "key": "raw/molo_moloScheduledReportSet/2026-04-04/1775289619/ScheduledReportSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloScheduledReportSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13413684240016556503,
        "service_name": "drive-thru",
        "span_id": 9551222505025162179,
        "trace_id": 1424970701106166871
    }
}

running: False
schema_name_id: 1768
start_time: 2026-04-04 03:04:26
success: True
trace_id: 1424970701106166871

Scan 161401783

duration: 0:00:14.395918

exit_message:

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

id: 161401783

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_moloScheduledReportSet/2026-04-03/1775203391",
        "key": "raw/molo_moloScheduledReportSet/2026-04-03/1775203391/ScheduledReportSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloScheduledReportSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5627796435354524969,
        "service_name": "drive-thru",
        "span_id": 4392828948333568895,
        "trace_id": 12487784207445933473
    }
}

running: False
schema_name_id: 1768
start_time: 2026-04-03 03:06:36
success: True
trace_id: 12487784207445933473

Partitions:

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

Schema:

attributes:

{
    "CompanyId": "string",
    "CreationAspNetUser": "string",
    "CreationDateTime": "string",
    "DelayDays": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Mode": "string",
    "RecordStatusId": "string",
    "ReportConfig": "string",
    "ReportName": "string",
    "RunDay": "string",
    "SendTo": "string"
}

created: 2026-04-17 03:08:33

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloscheduledreportset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUser`  string , `MarinaLocationId`  string , `CompanyId`  string , `RecordStatusId`  string , `SendTo`  string , `Mode`  string , `RunDay`  string , `DelayDays`  string , `ReportName`  string , `ReportConfig`  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_moloScheduledReportSet/2026-04-17/1776412848'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloscheduledreportset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloscheduledreportset"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-10-17 02:01:15",
        "disabled": false,
        "format": "raw",
        "id": 1768,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_moloscheduledreportset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "CompanyId": "string",
            "CreationAspNetUser": "string",
            "CreationDateTime": "string",
            "DelayDays": "string",
            "Id": "string",
            "MarinaLocationId": "string",
            "Mode": "string",
            "RecordStatusId": "string",
            "ReportConfig": "string",
            "ReportName": "string",
            "RunDay": "string",
            "SendTo": "string"
        },
        "created": "2026-04-17 03:08:33",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloscheduledreportset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUser`  string , `MarinaLocationId`  string , `CompanyId`  string , `RecordStatusId`  string , `SendTo`  string , `Mode`  string , `RunDay`  string , `DelayDays`  string , `ReportName`  string , `ReportConfig`  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_moloScheduledReportSet/2026-04-17/1776412848'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloscheduledreportset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloscheduledreportset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}