Schema Info

Schema Name: sfdl_prod_drivethru.molo_molosv_jobtemplateset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717800

created: 2026-04-17 03:12:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_jobtemplateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_jobtemplateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `JobName`  string , `InternalJobComments`  string , `CustomerJobComments`  string , `ModifiedDateTime`  string , `ModifiedUser`  string , `SV_JobTemplateStatus_Id`  string , `MarinaLocation_Id`  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_moloSV_JobTemplateSet/2026-04-17/1776412999'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_jobtemplateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_JobTemplateSet/2026-04-17/1776412999
id: 1717800
processed: 1

raw_data:

{
    "CreationDateTime": 1,
    "CreationUserId": 2,
    "CustomerJobComments": 5,
    "Id": 0,
    "InternalJobComments": 4,
    "JobName": 3,
    "MarinaLocation_Id": 9,
    "ModifiedDateTime": 6,
    "ModifiedUser": 7,
    "SV_JobTemplateStatus_Id": 8
}

schema_attributes:

{
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "CustomerJobComments": "string",
    "Id": "string",
    "InternalJobComments": "string",
    "JobName": "string",
    "MarinaLocation_Id": "string",
    "ModifiedDateTime": "string",
    "ModifiedUser": "string",
    "SV_JobTemplateStatus_Id": "string"
}

schema_name_id: 1761
schema_scan_id: 162167835
updated: 2026-04-17 03:12:17

Version 1716542

created: 2026-04-16 03:13:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_jobtemplateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_jobtemplateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `JobName`  string , `InternalJobComments`  string , `CustomerJobComments`  string , `ModifiedDateTime`  string , `ModifiedUser`  string , `SV_JobTemplateStatus_Id`  string , `MarinaLocation_Id`  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_moloSV_JobTemplateSet/2026-04-16/1776326698'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_jobtemplateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_JobTemplateSet/2026-04-16/1776326698
id: 1716542
processed: 1

raw_data:

{
    "CreationDateTime": 1,
    "CreationUserId": 2,
    "CustomerJobComments": 5,
    "Id": 0,
    "InternalJobComments": 4,
    "JobName": 3,
    "MarinaLocation_Id": 9,
    "ModifiedDateTime": 6,
    "ModifiedUser": 7,
    "SV_JobTemplateStatus_Id": 8
}

schema_attributes:

{
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "CustomerJobComments": "string",
    "Id": "string",
    "InternalJobComments": "string",
    "JobName": "string",
    "MarinaLocation_Id": "string",
    "ModifiedDateTime": "string",
    "ModifiedUser": "string",
    "SV_JobTemplateStatus_Id": "string"
}

schema_name_id: 1761
schema_scan_id: 162111995
updated: 2026-04-16 03:13:24

Version 1715351

created: 2026-04-15 03:11:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_jobtemplateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_jobtemplateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `JobName`  string , `InternalJobComments`  string , `CustomerJobComments`  string , `ModifiedDateTime`  string , `ModifiedUser`  string , `SV_JobTemplateStatus_Id`  string , `MarinaLocation_Id`  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_moloSV_JobTemplateSet/2026-04-15/1776240186'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_jobtemplateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_JobTemplateSet/2026-04-15/1776240186
id: 1715351
processed: 1

raw_data:

{
    "CreationDateTime": 1,
    "CreationUserId": 2,
    "CustomerJobComments": 5,
    "Id": 0,
    "InternalJobComments": 4,
    "JobName": 3,
    "MarinaLocation_Id": 9,
    "ModifiedDateTime": 6,
    "ModifiedUser": 7,
    "SV_JobTemplateStatus_Id": 8
}

schema_attributes:

{
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "CustomerJobComments": "string",
    "Id": "string",
    "InternalJobComments": "string",
    "JobName": "string",
    "MarinaLocation_Id": "string",
    "ModifiedDateTime": "string",
    "ModifiedUser": "string",
    "SV_JobTemplateStatus_Id": "string"
}

schema_name_id: 1761
schema_scan_id: 162056149
updated: 2026-04-15 03:11:55

Version 1714181

created: 2026-04-14 03:12:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_jobtemplateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_jobtemplateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `JobName`  string , `InternalJobComments`  string , `CustomerJobComments`  string , `ModifiedDateTime`  string , `ModifiedUser`  string , `SV_JobTemplateStatus_Id`  string , `MarinaLocation_Id`  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_moloSV_JobTemplateSet/2026-04-14/1776154142'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_jobtemplateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_JobTemplateSet/2026-04-14/1776154142
id: 1714181
processed: 1

raw_data:

{
    "CreationDateTime": 1,
    "CreationUserId": 2,
    "CustomerJobComments": 5,
    "Id": 0,
    "InternalJobComments": 4,
    "JobName": 3,
    "MarinaLocation_Id": 9,
    "ModifiedDateTime": 6,
    "ModifiedUser": 7,
    "SV_JobTemplateStatus_Id": 8
}

schema_attributes:

{
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "CustomerJobComments": "string",
    "Id": "string",
    "InternalJobComments": "string",
    "JobName": "string",
    "MarinaLocation_Id": "string",
    "ModifiedDateTime": "string",
    "ModifiedUser": "string",
    "SV_JobTemplateStatus_Id": "string"
}

schema_name_id: 1761
schema_scan_id: 162000705
updated: 2026-04-14 03:12:40

Version 1712939

created: 2026-04-13 03:05:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_jobtemplateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_jobtemplateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `JobName`  string , `InternalJobComments`  string , `CustomerJobComments`  string , `ModifiedDateTime`  string , `ModifiedUser`  string , `SV_JobTemplateStatus_Id`  string , `MarinaLocation_Id`  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_moloSV_JobTemplateSet/2026-04-13/1776067138'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_jobtemplateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_JobTemplateSet/2026-04-13/1776067138
id: 1712939
processed: 1

raw_data:

{
    "CreationDateTime": 1,
    "CreationUserId": 2,
    "CustomerJobComments": 5,
    "Id": 0,
    "InternalJobComments": 4,
    "JobName": 3,
    "MarinaLocation_Id": 9,
    "ModifiedDateTime": 6,
    "ModifiedUser": 7,
    "SV_JobTemplateStatus_Id": 8
}

schema_attributes:

{
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "CustomerJobComments": "string",
    "Id": "string",
    "InternalJobComments": "string",
    "JobName": "string",
    "MarinaLocation_Id": "string",
    "ModifiedDateTime": "string",
    "ModifiedUser": "string",
    "SV_JobTemplateStatus_Id": "string"
}

schema_name_id: 1761
schema_scan_id: 161942731
updated: 2026-04-13 03:05:50

Version 1711696

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_jobtemplateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_jobtemplateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `JobName`  string , `InternalJobComments`  string , `CustomerJobComments`  string , `ModifiedDateTime`  string , `ModifiedUser`  string , `SV_JobTemplateStatus_Id`  string , `MarinaLocation_Id`  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_moloSV_JobTemplateSet/2026-04-12/1775980833'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_jobtemplateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_JobTemplateSet/2026-04-12/1775980833
id: 1711696
processed: 1

raw_data:

{
    "CreationDateTime": 1,
    "CreationUserId": 2,
    "CustomerJobComments": 5,
    "Id": 0,
    "InternalJobComments": 4,
    "JobName": 3,
    "MarinaLocation_Id": 9,
    "ModifiedDateTime": 6,
    "ModifiedUser": 7,
    "SV_JobTemplateStatus_Id": 8
}

schema_attributes:

{
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "CustomerJobComments": "string",
    "Id": "string",
    "InternalJobComments": "string",
    "JobName": "string",
    "MarinaLocation_Id": "string",
    "ModifiedDateTime": "string",
    "ModifiedUser": "string",
    "SV_JobTemplateStatus_Id": "string"
}

schema_name_id: 1761
schema_scan_id: 161893323
updated: 2026-04-12 03:05:26

Version 1710564

created: 2026-04-11 03:11:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_jobtemplateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_jobtemplateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `JobName`  string , `InternalJobComments`  string , `CustomerJobComments`  string , `ModifiedDateTime`  string , `ModifiedUser`  string , `SV_JobTemplateStatus_Id`  string , `MarinaLocation_Id`  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_moloSV_JobTemplateSet/2026-04-11/1775894604'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_jobtemplateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_JobTemplateSet/2026-04-11/1775894604
id: 1710564
processed: 1

raw_data:

{
    "CreationDateTime": 1,
    "CreationUserId": 2,
    "CustomerJobComments": 5,
    "Id": 0,
    "InternalJobComments": 4,
    "JobName": 3,
    "MarinaLocation_Id": 9,
    "ModifiedDateTime": 6,
    "ModifiedUser": 7,
    "SV_JobTemplateStatus_Id": 8
}

schema_attributes:

{
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "CustomerJobComments": "string",
    "Id": "string",
    "InternalJobComments": "string",
    "JobName": "string",
    "MarinaLocation_Id": "string",
    "ModifiedDateTime": "string",
    "ModifiedUser": "string",
    "SV_JobTemplateStatus_Id": "string"
}

schema_name_id: 1761
schema_scan_id: 161841371
updated: 2026-04-11 03:11:21

Version 1709354

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_jobtemplateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_jobtemplateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `JobName`  string , `InternalJobComments`  string , `CustomerJobComments`  string , `ModifiedDateTime`  string , `ModifiedUser`  string , `SV_JobTemplateStatus_Id`  string , `MarinaLocation_Id`  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_moloSV_JobTemplateSet/2026-04-10/1775808366'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_jobtemplateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_JobTemplateSet/2026-04-10/1775808366
id: 1709354
processed: 1

raw_data:

{
    "CreationDateTime": 1,
    "CreationUserId": 2,
    "CustomerJobComments": 5,
    "Id": 0,
    "InternalJobComments": 4,
    "JobName": 3,
    "MarinaLocation_Id": 9,
    "ModifiedDateTime": 6,
    "ModifiedUser": 7,
    "SV_JobTemplateStatus_Id": 8
}

schema_attributes:

{
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "CustomerJobComments": "string",
    "Id": "string",
    "InternalJobComments": "string",
    "JobName": "string",
    "MarinaLocation_Id": "string",
    "ModifiedDateTime": "string",
    "ModifiedUser": "string",
    "SV_JobTemplateStatus_Id": "string"
}

schema_name_id: 1761
schema_scan_id: 161786053
updated: 2026-04-10 03:10:32

Version 1708275

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_jobtemplateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_jobtemplateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `JobName`  string , `InternalJobComments`  string , `CustomerJobComments`  string , `ModifiedDateTime`  string , `ModifiedUser`  string , `SV_JobTemplateStatus_Id`  string , `MarinaLocation_Id`  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_moloSV_JobTemplateSet/2026-04-09/1775721697'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_jobtemplateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_JobTemplateSet/2026-04-09/1775721697
id: 1708275
processed: 1

raw_data:

{
    "CreationDateTime": 1,
    "CreationUserId": 2,
    "CustomerJobComments": 5,
    "Id": 0,
    "InternalJobComments": 4,
    "JobName": 3,
    "MarinaLocation_Id": 9,
    "ModifiedDateTime": 6,
    "ModifiedUser": 7,
    "SV_JobTemplateStatus_Id": 8
}

schema_attributes:

{
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "CustomerJobComments": "string",
    "Id": "string",
    "InternalJobComments": "string",
    "JobName": "string",
    "MarinaLocation_Id": "string",
    "ModifiedDateTime": "string",
    "ModifiedUser": "string",
    "SV_JobTemplateStatus_Id": "string"
}

schema_name_id: 1761
schema_scan_id: 161730568
updated: 2026-04-09 03:10:24

Version 1707038

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_jobtemplateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_jobtemplateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `JobName`  string , `InternalJobComments`  string , `CustomerJobComments`  string , `ModifiedDateTime`  string , `ModifiedUser`  string , `SV_JobTemplateStatus_Id`  string , `MarinaLocation_Id`  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_moloSV_JobTemplateSet/2026-04-08/1775635527'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_jobtemplateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_JobTemplateSet/2026-04-08/1775635527
id: 1707038
processed: 1

raw_data:

{
    "CreationDateTime": 1,
    "CreationUserId": 2,
    "CustomerJobComments": 5,
    "Id": 0,
    "InternalJobComments": 4,
    "JobName": 3,
    "MarinaLocation_Id": 9,
    "ModifiedDateTime": 6,
    "ModifiedUser": 7,
    "SV_JobTemplateStatus_Id": 8
}

schema_attributes:

{
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "CustomerJobComments": "string",
    "Id": "string",
    "InternalJobComments": "string",
    "JobName": "string",
    "MarinaLocation_Id": "string",
    "ModifiedDateTime": "string",
    "ModifiedUser": "string",
    "SV_JobTemplateStatus_Id": "string"
}

schema_name_id: 1761
schema_scan_id: 161675703
updated: 2026-04-08 03:11:11

Version 1705854

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_jobtemplateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_jobtemplateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `JobName`  string , `InternalJobComments`  string , `CustomerJobComments`  string , `ModifiedDateTime`  string , `ModifiedUser`  string , `SV_JobTemplateStatus_Id`  string , `MarinaLocation_Id`  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_moloSV_JobTemplateSet/2026-04-07/1775548690'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_jobtemplateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_JobTemplateSet/2026-04-07/1775548690
id: 1705854
processed: 1

raw_data:

{
    "CreationDateTime": 1,
    "CreationUserId": 2,
    "CustomerJobComments": 5,
    "Id": 0,
    "InternalJobComments": 4,
    "JobName": 3,
    "MarinaLocation_Id": 9,
    "ModifiedDateTime": 6,
    "ModifiedUser": 7,
    "SV_JobTemplateStatus_Id": 8
}

schema_attributes:

{
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "CustomerJobComments": "string",
    "Id": "string",
    "InternalJobComments": "string",
    "JobName": "string",
    "MarinaLocation_Id": "string",
    "ModifiedDateTime": "string",
    "ModifiedUser": "string",
    "SV_JobTemplateStatus_Id": "string"
}

schema_name_id: 1761
schema_scan_id: 161619362
updated: 2026-04-07 03:03:50

Version 1704639

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_jobtemplateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_jobtemplateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `JobName`  string , `InternalJobComments`  string , `CustomerJobComments`  string , `ModifiedDateTime`  string , `ModifiedUser`  string , `SV_JobTemplateStatus_Id`  string , `MarinaLocation_Id`  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_moloSV_JobTemplateSet/2026-04-06/1775462640'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_jobtemplateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_JobTemplateSet/2026-04-06/1775462640
id: 1704639
processed: 1

raw_data:

{
    "CreationDateTime": 1,
    "CreationUserId": 2,
    "CustomerJobComments": 5,
    "Id": 0,
    "InternalJobComments": 4,
    "JobName": 3,
    "MarinaLocation_Id": 9,
    "ModifiedDateTime": 6,
    "ModifiedUser": 7,
    "SV_JobTemplateStatus_Id": 8
}

schema_attributes:

{
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "CustomerJobComments": "string",
    "Id": "string",
    "InternalJobComments": "string",
    "JobName": "string",
    "MarinaLocation_Id": "string",
    "ModifiedDateTime": "string",
    "ModifiedUser": "string",
    "SV_JobTemplateStatus_Id": "string"
}

schema_name_id: 1761
schema_scan_id: 161561788
updated: 2026-04-06 03:11:51

Version 1703429

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_jobtemplateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_jobtemplateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `JobName`  string , `InternalJobComments`  string , `CustomerJobComments`  string , `ModifiedDateTime`  string , `ModifiedUser`  string , `SV_JobTemplateStatus_Id`  string , `MarinaLocation_Id`  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_moloSV_JobTemplateSet/2026-04-05/1775376272'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_jobtemplateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_JobTemplateSet/2026-04-05/1775376272
id: 1703429
processed: 1

raw_data:

{
    "CreationDateTime": 1,
    "CreationUserId": 2,
    "CustomerJobComments": 5,
    "Id": 0,
    "InternalJobComments": 4,
    "JobName": 3,
    "MarinaLocation_Id": 9,
    "ModifiedDateTime": 6,
    "ModifiedUser": 7,
    "SV_JobTemplateStatus_Id": 8
}

schema_attributes:

{
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "CustomerJobComments": "string",
    "Id": "string",
    "InternalJobComments": "string",
    "JobName": "string",
    "MarinaLocation_Id": "string",
    "ModifiedDateTime": "string",
    "ModifiedUser": "string",
    "SV_JobTemplateStatus_Id": "string"
}

schema_name_id: 1761
schema_scan_id: 161515017
updated: 2026-04-05 03:10:25

Version 1702295

created: 2026-04-04 03:11:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_jobtemplateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_jobtemplateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `JobName`  string , `InternalJobComments`  string , `CustomerJobComments`  string , `ModifiedDateTime`  string , `ModifiedUser`  string , `SV_JobTemplateStatus_Id`  string , `MarinaLocation_Id`  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_moloSV_JobTemplateSet/2026-04-04/1775289752'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_jobtemplateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_JobTemplateSet/2026-04-04/1775289752
id: 1702295
processed: 1

raw_data:

{
    "CreationDateTime": 1,
    "CreationUserId": 2,
    "CustomerJobComments": 5,
    "Id": 0,
    "InternalJobComments": 4,
    "JobName": 3,
    "MarinaLocation_Id": 9,
    "ModifiedDateTime": 6,
    "ModifiedUser": 7,
    "SV_JobTemplateStatus_Id": 8
}

schema_attributes:

{
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "CustomerJobComments": "string",
    "Id": "string",
    "InternalJobComments": "string",
    "JobName": "string",
    "MarinaLocation_Id": "string",
    "ModifiedDateTime": "string",
    "ModifiedUser": "string",
    "SV_JobTemplateStatus_Id": "string"
}

schema_name_id: 1761
schema_scan_id: 161460625
updated: 2026-04-04 03:12:03

Version 1701010

created: 2026-04-03 03:12:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_jobtemplateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_jobtemplateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `JobName`  string , `InternalJobComments`  string , `CustomerJobComments`  string , `ModifiedDateTime`  string , `ModifiedUser`  string , `SV_JobTemplateStatus_Id`  string , `MarinaLocation_Id`  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_moloSV_JobTemplateSet/2026-04-03/1775203520'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_jobtemplateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_JobTemplateSet/2026-04-03/1775203520
id: 1701010
processed: 1

raw_data:

{
    "CreationDateTime": 1,
    "CreationUserId": 2,
    "CustomerJobComments": 5,
    "Id": 0,
    "InternalJobComments": 4,
    "JobName": 3,
    "MarinaLocation_Id": 9,
    "ModifiedDateTime": 6,
    "ModifiedUser": 7,
    "SV_JobTemplateStatus_Id": 8
}

schema_attributes:

{
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "CustomerJobComments": "string",
    "Id": "string",
    "InternalJobComments": "string",
    "JobName": "string",
    "MarinaLocation_Id": "string",
    "ModifiedDateTime": "string",
    "ModifiedUser": "string",
    "SV_JobTemplateStatus_Id": "string"
}

schema_name_id: 1761
schema_scan_id: 161401984
updated: 2026-04-03 03:12:51

Schema Scans: 15

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

Scan 162167835

duration: 0:00:14.293141

exit_message:

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

id: 162167835

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_moloSV_JobTemplateSet/2026-04-17/1776412999",
        "key": "raw/molo_moloSV_JobTemplateSet/2026-04-17/1776412999/SV_JobTemplateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_JobTemplateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1825359073348338267,
        "service_name": "drive-thru",
        "span_id": 16975565379630807343,
        "trace_id": 13355418897793304295
    }
}

running: False
schema_name_id: 1761
start_time: 2026-04-17 03:12:03
success: True
trace_id: 13355418897793304295

Scan 162111995

duration: 0:00:11.703812

exit_message:

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

id: 162111995

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_moloSV_JobTemplateSet/2026-04-16/1776326698",
        "key": "raw/molo_moloSV_JobTemplateSet/2026-04-16/1776326698/SV_JobTemplateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_JobTemplateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8742818296514471548,
        "service_name": "drive-thru",
        "span_id": 14378779998759519764,
        "trace_id": 2012497125534630301
    }
}

running: False
schema_name_id: 1761
start_time: 2026-04-16 03:13:13
success: True
trace_id: 2012497125534630301

Scan 162056149

duration: 0:00:14.292559

exit_message:

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

id: 162056149

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_moloSV_JobTemplateSet/2026-04-15/1776240186",
        "key": "raw/molo_moloSV_JobTemplateSet/2026-04-15/1776240186/SV_JobTemplateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_JobTemplateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5711958752326643178,
        "service_name": "drive-thru",
        "span_id": 14224759896365292029,
        "trace_id": 17881869671249779196
    }
}

running: False
schema_name_id: 1761
start_time: 2026-04-15 03:11:41
success: True
trace_id: 17881869671249779196

Scan 162000705

duration: 0:00:14.256043

exit_message:

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

id: 162000705

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_moloSV_JobTemplateSet/2026-04-14/1776154142",
        "key": "raw/molo_moloSV_JobTemplateSet/2026-04-14/1776154142/SV_JobTemplateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_JobTemplateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15243622995014808133,
        "service_name": "drive-thru",
        "span_id": 2499260201620303133,
        "trace_id": 6529282340901238032
    }
}

running: False
schema_name_id: 1761
start_time: 2026-04-14 03:12:26
success: True
trace_id: 6529282340901238032

Scan 161942731

duration: 0:00:11.780108

exit_message:

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

id: 161942731

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_moloSV_JobTemplateSet/2026-04-13/1776067138",
        "key": "raw/molo_moloSV_JobTemplateSet/2026-04-13/1776067138/SV_JobTemplateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_JobTemplateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3128182844681518256,
        "service_name": "drive-thru",
        "span_id": 6833589979745481133,
        "trace_id": 18034673944924204864
    }
}

running: False
schema_name_id: 1761
start_time: 2026-04-13 03:05:38
success: True
trace_id: 18034673944924204864

Scan 161893323

duration: 0:00:11.675430

exit_message:

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

id: 161893323

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_moloSV_JobTemplateSet/2026-04-12/1775980833",
        "key": "raw/molo_moloSV_JobTemplateSet/2026-04-12/1775980833/SV_JobTemplateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_JobTemplateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16859537479932735544,
        "service_name": "drive-thru",
        "span_id": 17251145069842943101,
        "trace_id": 13020090544858987739
    }
}

running: False
schema_name_id: 1761
start_time: 2026-04-12 03:05:14
success: True
trace_id: 13020090544858987739

Scan 161841371

duration: 0:00:14.304550

exit_message:

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

id: 161841371

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_moloSV_JobTemplateSet/2026-04-11/1775894604",
        "key": "raw/molo_moloSV_JobTemplateSet/2026-04-11/1775894604/SV_JobTemplateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_JobTemplateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11292373863183298882,
        "service_name": "drive-thru",
        "span_id": 18078333861777923434,
        "trace_id": 2708030815425902010
    }
}

running: False
schema_name_id: 1761
start_time: 2026-04-11 03:11:07
success: True
trace_id: 2708030815425902010

Scan 161786053

duration: 0:00:14.244394

exit_message:

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

id: 161786053

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_moloSV_JobTemplateSet/2026-04-10/1775808366",
        "key": "raw/molo_moloSV_JobTemplateSet/2026-04-10/1775808366/SV_JobTemplateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_JobTemplateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15791099949284087478,
        "service_name": "drive-thru",
        "span_id": 11712244783048069592,
        "trace_id": 11133108853569512250
    }
}

running: False
schema_name_id: 1761
start_time: 2026-04-10 03:10:18
success: True
trace_id: 11133108853569512250

Scan 161730568

duration: 0:00:14.269661

exit_message:

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

id: 161730568

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_moloSV_JobTemplateSet/2026-04-09/1775721697",
        "key": "raw/molo_moloSV_JobTemplateSet/2026-04-09/1775721697/SV_JobTemplateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_JobTemplateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13244094813367095185,
        "service_name": "drive-thru",
        "span_id": 9002676813716423143,
        "trace_id": 17845959822756146766
    }
}

running: False
schema_name_id: 1761
start_time: 2026-04-09 03:10:10
success: True
trace_id: 17845959822756146766

Scan 161675703

duration: 0:00:11.847518

exit_message:

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

id: 161675703

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_moloSV_JobTemplateSet/2026-04-08/1775635527",
        "key": "raw/molo_moloSV_JobTemplateSet/2026-04-08/1775635527/SV_JobTemplateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_JobTemplateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16265207587626967599,
        "service_name": "drive-thru",
        "span_id": 2246859046743833340,
        "trace_id": 1488987920644382271
    }
}

running: False
schema_name_id: 1761
start_time: 2026-04-08 03:11:00
success: True
trace_id: 1488987920644382271

Scan 161619362

duration: 0:00:14.304677

exit_message:

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

id: 161619362

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_moloSV_JobTemplateSet/2026-04-07/1775548690",
        "key": "raw/molo_moloSV_JobTemplateSet/2026-04-07/1775548690/SV_JobTemplateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_JobTemplateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3067863090951478104,
        "service_name": "drive-thru",
        "span_id": 898853235631577448,
        "trace_id": 656458309134825088
    }
}

running: False
schema_name_id: 1761
start_time: 2026-04-07 03:03:35
success: True
trace_id: 656458309134825088

Scan 161561788

duration: 0:00:14.320379

exit_message:

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

id: 161561788

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_moloSV_JobTemplateSet/2026-04-06/1775462640",
        "key": "raw/molo_moloSV_JobTemplateSet/2026-04-06/1775462640/SV_JobTemplateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_JobTemplateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2214248836919381517,
        "service_name": "drive-thru",
        "span_id": 452912334975280950,
        "trace_id": 4677722839449556068
    }
}

running: False
schema_name_id: 1761
start_time: 2026-04-06 03:11:37
success: True
trace_id: 4677722839449556068

Scan 161515017

duration: 0:00:11.641372

exit_message:

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

id: 161515017

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_moloSV_JobTemplateSet/2026-04-05/1775376272",
        "key": "raw/molo_moloSV_JobTemplateSet/2026-04-05/1775376272/SV_JobTemplateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_JobTemplateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7979525671409218142,
        "service_name": "drive-thru",
        "span_id": 11316472813644616560,
        "trace_id": 807740606126966780
    }
}

running: False
schema_name_id: 1761
start_time: 2026-04-05 03:10:13
success: True
trace_id: 807740606126966780

Scan 161460625

duration: 0:00:14.168374

exit_message:

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

id: 161460625

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_moloSV_JobTemplateSet/2026-04-04/1775289752",
        "key": "raw/molo_moloSV_JobTemplateSet/2026-04-04/1775289752/SV_JobTemplateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_JobTemplateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12421194130059907438,
        "service_name": "drive-thru",
        "span_id": 12339441359671887012,
        "trace_id": 11297353681370001553
    }
}

running: False
schema_name_id: 1761
start_time: 2026-04-04 03:11:49
success: True
trace_id: 11297353681370001553

Scan 161401984

duration: 0:00:11.729632

exit_message:

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

id: 161401984

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_moloSV_JobTemplateSet/2026-04-03/1775203520",
        "key": "raw/molo_moloSV_JobTemplateSet/2026-04-03/1775203520/SV_JobTemplateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_JobTemplateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10568904431001780724,
        "service_name": "drive-thru",
        "span_id": 7875448574478061174,
        "trace_id": 10558263000353159142
    }
}

running: False
schema_name_id: 1761
start_time: 2026-04-03 03:12:39
success: True
trace_id: 10558263000353159142

Partitions:

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

Schema:

attributes:

{
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "CustomerJobComments": "string",
    "Id": "string",
    "InternalJobComments": "string",
    "JobName": "string",
    "MarinaLocation_Id": "string",
    "ModifiedDateTime": "string",
    "ModifiedUser": "string",
    "SV_JobTemplateStatus_Id": "string"
}

created: 2026-04-17 03:12:03

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_jobtemplateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `JobName`  string , `InternalJobComments`  string , `CustomerJobComments`  string , `ModifiedDateTime`  string , `ModifiedUser`  string , `SV_JobTemplateStatus_Id`  string , `MarinaLocation_Id`  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_moloSV_JobTemplateSet/2026-04-17/1776412999'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_jobtemplateset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_jobtemplateset"
}

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:00",
        "disabled": false,
        "format": "raw",
        "id": 1761,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molosv_jobtemplateset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "CreationDateTime": "string",
            "CreationUserId": "string",
            "CustomerJobComments": "string",
            "Id": "string",
            "InternalJobComments": "string",
            "JobName": "string",
            "MarinaLocation_Id": "string",
            "ModifiedDateTime": "string",
            "ModifiedUser": "string",
            "SV_JobTemplateStatus_Id": "string"
        },
        "created": "2026-04-17 03:12:03",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_jobtemplateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `JobName`  string , `InternalJobComments`  string , `CustomerJobComments`  string , `ModifiedDateTime`  string , `ModifiedUser`  string , `SV_JobTemplateStatus_Id`  string , `MarinaLocation_Id`  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_moloSV_JobTemplateSet/2026-04-17/1776412999'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_jobtemplateset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_jobtemplateset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}