Schema Info

Schema Name: sfdl_prod_drivethru.molo_molosv_employeehourset

created: 2023-10-17 02:02:41
disabled: False
format: raw
id: 1802
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717703

created: 2026-04-17 03:07:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_employeehourset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_employeehourset`\n(\n `Id`  string , `ActualHours`  string , `BillableHours`  string , `EmployeeId`  string , `SV_LaborInstance_Id`  string , `DateTimePerformed`  string , `DateTimeEntered`  string , `AspNetUserEntered`  string , `TechnicianComments`  string , `HourlyRateWhenAdded`  string , `NeedsApproval`  string , `ApprovalDateTime`  string , `ApprovalUser_Id`  string , `Source`  string , `Notes`  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_EmployeeHourSet/2026-04-17/1776412995'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_employeehourset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EmployeeHourSet/2026-04-17/1776412995
id: 1717703
processed: 1

raw_data:

{
    "ActualHours": 1,
    "ApprovalDateTime": 11,
    "ApprovalUser_Id": 12,
    "AspNetUserEntered": 7,
    "BillableHours": 2,
    "DateTimeEntered": 6,
    "DateTimePerformed": 5,
    "EmployeeId": 3,
    "HourlyRateWhenAdded": 9,
    "Id": 0,
    "NeedsApproval": 10,
    "Notes": 14,
    "SV_LaborInstance_Id": 4,
    "Source": 13,
    "TechnicianComments": 8
}

schema_attributes:

{
    "ActualHours": "string",
    "ApprovalDateTime": "string",
    "ApprovalUser_Id": "string",
    "AspNetUserEntered": "string",
    "BillableHours": "string",
    "DateTimeEntered": "string",
    "DateTimePerformed": "string",
    "EmployeeId": "string",
    "HourlyRateWhenAdded": "string",
    "Id": "string",
    "NeedsApproval": "string",
    "Notes": "string",
    "SV_LaborInstance_Id": "string",
    "Source": "string",
    "TechnicianComments": "string"
}

schema_name_id: 1802
schema_scan_id: 162167700
updated: 2026-04-17 03:07:48

Version 1716558

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_employeehourset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_employeehourset`\n(\n `Id`  string , `ActualHours`  string , `BillableHours`  string , `EmployeeId`  string , `SV_LaborInstance_Id`  string , `DateTimePerformed`  string , `DateTimeEntered`  string , `AspNetUserEntered`  string , `TechnicianComments`  string , `HourlyRateWhenAdded`  string , `NeedsApproval`  string , `ApprovalDateTime`  string , `ApprovalUser_Id`  string , `Source`  string , `Notes`  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_EmployeeHourSet/2026-04-16/1776326695'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_employeehourset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EmployeeHourSet/2026-04-16/1776326695
id: 1716558
processed: 1

raw_data:

{
    "ActualHours": 1,
    "ApprovalDateTime": 11,
    "ApprovalUser_Id": 12,
    "AspNetUserEntered": 7,
    "BillableHours": 2,
    "DateTimeEntered": 6,
    "DateTimePerformed": 5,
    "EmployeeId": 3,
    "HourlyRateWhenAdded": 9,
    "Id": 0,
    "NeedsApproval": 10,
    "Notes": 14,
    "SV_LaborInstance_Id": 4,
    "Source": 13,
    "TechnicianComments": 8
}

schema_attributes:

{
    "ActualHours": "string",
    "ApprovalDateTime": "string",
    "ApprovalUser_Id": "string",
    "AspNetUserEntered": "string",
    "BillableHours": "string",
    "DateTimeEntered": "string",
    "DateTimePerformed": "string",
    "EmployeeId": "string",
    "HourlyRateWhenAdded": "string",
    "Id": "string",
    "NeedsApproval": "string",
    "Notes": "string",
    "SV_LaborInstance_Id": "string",
    "Source": "string",
    "TechnicianComments": "string"
}

schema_name_id: 1802
schema_scan_id: 162112017
updated: 2026-04-16 03:14:01

Version 1715279

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_employeehourset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_employeehourset`\n(\n `Id`  string , `ActualHours`  string , `BillableHours`  string , `EmployeeId`  string , `SV_LaborInstance_Id`  string , `DateTimePerformed`  string , `DateTimeEntered`  string , `AspNetUserEntered`  string , `TechnicianComments`  string , `HourlyRateWhenAdded`  string , `NeedsApproval`  string , `ApprovalDateTime`  string , `ApprovalUser_Id`  string , `Source`  string , `Notes`  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_EmployeeHourSet/2026-04-15/1776240183'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_employeehourset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EmployeeHourSet/2026-04-15/1776240183
id: 1715279
processed: 1

raw_data:

{
    "ActualHours": 1,
    "ApprovalDateTime": 11,
    "ApprovalUser_Id": 12,
    "AspNetUserEntered": 7,
    "BillableHours": 2,
    "DateTimeEntered": 6,
    "DateTimePerformed": 5,
    "EmployeeId": 3,
    "HourlyRateWhenAdded": 9,
    "Id": 0,
    "NeedsApproval": 10,
    "Notes": 14,
    "SV_LaborInstance_Id": 4,
    "Source": 13,
    "TechnicianComments": 8
}

schema_attributes:

{
    "ActualHours": "string",
    "ApprovalDateTime": "string",
    "ApprovalUser_Id": "string",
    "AspNetUserEntered": "string",
    "BillableHours": "string",
    "DateTimeEntered": "string",
    "DateTimePerformed": "string",
    "EmployeeId": "string",
    "HourlyRateWhenAdded": "string",
    "Id": "string",
    "NeedsApproval": "string",
    "Notes": "string",
    "SV_LaborInstance_Id": "string",
    "Source": "string",
    "TechnicianComments": "string"
}

schema_name_id: 1802
schema_scan_id: 162056029
updated: 2026-04-15 03:08:10

Version 1714146

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_employeehourset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_employeehourset`\n(\n `Id`  string , `ActualHours`  string , `BillableHours`  string , `EmployeeId`  string , `SV_LaborInstance_Id`  string , `DateTimePerformed`  string , `DateTimeEntered`  string , `AspNetUserEntered`  string , `TechnicianComments`  string , `HourlyRateWhenAdded`  string , `NeedsApproval`  string , `ApprovalDateTime`  string , `ApprovalUser_Id`  string , `Source`  string , `Notes`  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_EmployeeHourSet/2026-04-14/1776154137'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_employeehourset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EmployeeHourSet/2026-04-14/1776154137
id: 1714146
processed: 1

raw_data:

{
    "ActualHours": 1,
    "ApprovalDateTime": 11,
    "ApprovalUser_Id": 12,
    "AspNetUserEntered": 7,
    "BillableHours": 2,
    "DateTimeEntered": 6,
    "DateTimePerformed": 5,
    "EmployeeId": 3,
    "HourlyRateWhenAdded": 9,
    "Id": 0,
    "NeedsApproval": 10,
    "Notes": 14,
    "SV_LaborInstance_Id": 4,
    "Source": 13,
    "TechnicianComments": 8
}

schema_attributes:

{
    "ActualHours": "string",
    "ApprovalDateTime": "string",
    "ApprovalUser_Id": "string",
    "AspNetUserEntered": "string",
    "BillableHours": "string",
    "DateTimeEntered": "string",
    "DateTimePerformed": "string",
    "EmployeeId": "string",
    "HourlyRateWhenAdded": "string",
    "Id": "string",
    "NeedsApproval": "string",
    "Notes": "string",
    "SV_LaborInstance_Id": "string",
    "Source": "string",
    "TechnicianComments": "string"
}

schema_name_id: 1802
schema_scan_id: 162000666
updated: 2026-04-14 03:11:19

Version 1712913

created: 2026-04-13 03:04:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_employeehourset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_employeehourset`\n(\n `Id`  string , `ActualHours`  string , `BillableHours`  string , `EmployeeId`  string , `SV_LaborInstance_Id`  string , `DateTimePerformed`  string , `DateTimeEntered`  string , `AspNetUserEntered`  string , `TechnicianComments`  string , `HourlyRateWhenAdded`  string , `NeedsApproval`  string , `ApprovalDateTime`  string , `ApprovalUser_Id`  string , `Source`  string , `Notes`  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_EmployeeHourSet/2026-04-13/1776067132'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_employeehourset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EmployeeHourSet/2026-04-13/1776067132
id: 1712913
processed: 1

raw_data:

{
    "ActualHours": 1,
    "ApprovalDateTime": 11,
    "ApprovalUser_Id": 12,
    "AspNetUserEntered": 7,
    "BillableHours": 2,
    "DateTimeEntered": 6,
    "DateTimePerformed": 5,
    "EmployeeId": 3,
    "HourlyRateWhenAdded": 9,
    "Id": 0,
    "NeedsApproval": 10,
    "Notes": 14,
    "SV_LaborInstance_Id": 4,
    "Source": 13,
    "TechnicianComments": 8
}

schema_attributes:

{
    "ActualHours": "string",
    "ApprovalDateTime": "string",
    "ApprovalUser_Id": "string",
    "AspNetUserEntered": "string",
    "BillableHours": "string",
    "DateTimeEntered": "string",
    "DateTimePerformed": "string",
    "EmployeeId": "string",
    "HourlyRateWhenAdded": "string",
    "Id": "string",
    "NeedsApproval": "string",
    "Notes": "string",
    "SV_LaborInstance_Id": "string",
    "Source": "string",
    "TechnicianComments": "string"
}

schema_name_id: 1802
schema_scan_id: 161942615
updated: 2026-04-13 03:04:23

Version 1711704

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_employeehourset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_employeehourset`\n(\n `Id`  string , `ActualHours`  string , `BillableHours`  string , `EmployeeId`  string , `SV_LaborInstance_Id`  string , `DateTimePerformed`  string , `DateTimeEntered`  string , `AspNetUserEntered`  string , `TechnicianComments`  string , `HourlyRateWhenAdded`  string , `NeedsApproval`  string , `ApprovalDateTime`  string , `ApprovalUser_Id`  string , `Source`  string , `Notes`  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_EmployeeHourSet/2026-04-12/1775980827'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_employeehourset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EmployeeHourSet/2026-04-12/1775980827
id: 1711704
processed: 1

raw_data:

{
    "ActualHours": 1,
    "ApprovalDateTime": 11,
    "ApprovalUser_Id": 12,
    "AspNetUserEntered": 7,
    "BillableHours": 2,
    "DateTimeEntered": 6,
    "DateTimePerformed": 5,
    "EmployeeId": 3,
    "HourlyRateWhenAdded": 9,
    "Id": 0,
    "NeedsApproval": 10,
    "Notes": 14,
    "SV_LaborInstance_Id": 4,
    "Source": 13,
    "TechnicianComments": 8
}

schema_attributes:

{
    "ActualHours": "string",
    "ApprovalDateTime": "string",
    "ApprovalUser_Id": "string",
    "AspNetUserEntered": "string",
    "BillableHours": "string",
    "DateTimeEntered": "string",
    "DateTimePerformed": "string",
    "EmployeeId": "string",
    "HourlyRateWhenAdded": "string",
    "Id": "string",
    "NeedsApproval": "string",
    "Notes": "string",
    "SV_LaborInstance_Id": "string",
    "Source": "string",
    "TechnicianComments": "string"
}

schema_name_id: 1802
schema_scan_id: 161893362
updated: 2026-04-12 03:06:01

Version 1710429

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_employeehourset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_employeehourset`\n(\n `Id`  string , `ActualHours`  string , `BillableHours`  string , `EmployeeId`  string , `SV_LaborInstance_Id`  string , `DateTimePerformed`  string , `DateTimeEntered`  string , `AspNetUserEntered`  string , `TechnicianComments`  string , `HourlyRateWhenAdded`  string , `NeedsApproval`  string , `ApprovalDateTime`  string , `ApprovalUser_Id`  string , `Source`  string , `Notes`  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_EmployeeHourSet/2026-04-11/1775894598'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_employeehourset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EmployeeHourSet/2026-04-11/1775894598
id: 1710429
processed: 1

raw_data:

{
    "ActualHours": 1,
    "ApprovalDateTime": 11,
    "ApprovalUser_Id": 12,
    "AspNetUserEntered": 7,
    "BillableHours": 2,
    "DateTimeEntered": 6,
    "DateTimePerformed": 5,
    "EmployeeId": 3,
    "HourlyRateWhenAdded": 9,
    "Id": 0,
    "NeedsApproval": 10,
    "Notes": 14,
    "SV_LaborInstance_Id": 4,
    "Source": 13,
    "TechnicianComments": 8
}

schema_attributes:

{
    "ActualHours": "string",
    "ApprovalDateTime": "string",
    "ApprovalUser_Id": "string",
    "AspNetUserEntered": "string",
    "BillableHours": "string",
    "DateTimeEntered": "string",
    "DateTimePerformed": "string",
    "EmployeeId": "string",
    "HourlyRateWhenAdded": "string",
    "Id": "string",
    "NeedsApproval": "string",
    "Notes": "string",
    "SV_LaborInstance_Id": "string",
    "Source": "string",
    "TechnicianComments": "string"
}

schema_name_id: 1802
schema_scan_id: 161841212
updated: 2026-04-11 03:05:56

Version 1709324

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_employeehourset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_employeehourset`\n(\n `Id`  string , `ActualHours`  string , `BillableHours`  string , `EmployeeId`  string , `SV_LaborInstance_Id`  string , `DateTimePerformed`  string , `DateTimeEntered`  string , `AspNetUserEntered`  string , `TechnicianComments`  string , `HourlyRateWhenAdded`  string , `NeedsApproval`  string , `ApprovalDateTime`  string , `ApprovalUser_Id`  string , `Source`  string , `Notes`  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_EmployeeHourSet/2026-04-10/1775808361'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_employeehourset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EmployeeHourSet/2026-04-10/1775808361
id: 1709324
processed: 1

raw_data:

{
    "ActualHours": 1,
    "ApprovalDateTime": 11,
    "ApprovalUser_Id": 12,
    "AspNetUserEntered": 7,
    "BillableHours": 2,
    "DateTimeEntered": 6,
    "DateTimePerformed": 5,
    "EmployeeId": 3,
    "HourlyRateWhenAdded": 9,
    "Id": 0,
    "NeedsApproval": 10,
    "Notes": 14,
    "SV_LaborInstance_Id": 4,
    "Source": 13,
    "TechnicianComments": 8
}

schema_attributes:

{
    "ActualHours": "string",
    "ApprovalDateTime": "string",
    "ApprovalUser_Id": "string",
    "AspNetUserEntered": "string",
    "BillableHours": "string",
    "DateTimeEntered": "string",
    "DateTimePerformed": "string",
    "EmployeeId": "string",
    "HourlyRateWhenAdded": "string",
    "Id": "string",
    "NeedsApproval": "string",
    "Notes": "string",
    "SV_LaborInstance_Id": "string",
    "Source": "string",
    "TechnicianComments": "string"
}

schema_name_id: 1802
schema_scan_id: 161786023
updated: 2026-04-10 03:09:25

Version 1708234

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_employeehourset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_employeehourset`\n(\n `Id`  string , `ActualHours`  string , `BillableHours`  string , `EmployeeId`  string , `SV_LaborInstance_Id`  string , `DateTimePerformed`  string , `DateTimeEntered`  string , `AspNetUserEntered`  string , `TechnicianComments`  string , `HourlyRateWhenAdded`  string , `NeedsApproval`  string , `ApprovalDateTime`  string , `ApprovalUser_Id`  string , `Source`  string , `Notes`  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_EmployeeHourSet/2026-04-09/1775721686'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_employeehourset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EmployeeHourSet/2026-04-09/1775721686
id: 1708234
processed: 1

raw_data:

{
    "ActualHours": 1,
    "ApprovalDateTime": 11,
    "ApprovalUser_Id": 12,
    "AspNetUserEntered": 7,
    "BillableHours": 2,
    "DateTimeEntered": 6,
    "DateTimePerformed": 5,
    "EmployeeId": 3,
    "HourlyRateWhenAdded": 9,
    "Id": 0,
    "NeedsApproval": 10,
    "Notes": 14,
    "SV_LaborInstance_Id": 4,
    "Source": 13,
    "TechnicianComments": 8
}

schema_attributes:

{
    "ActualHours": "string",
    "ApprovalDateTime": "string",
    "ApprovalUser_Id": "string",
    "AspNetUserEntered": "string",
    "BillableHours": "string",
    "DateTimeEntered": "string",
    "DateTimePerformed": "string",
    "EmployeeId": "string",
    "HourlyRateWhenAdded": "string",
    "Id": "string",
    "NeedsApproval": "string",
    "Notes": "string",
    "SV_LaborInstance_Id": "string",
    "Source": "string",
    "TechnicianComments": "string"
}

schema_name_id: 1802
schema_scan_id: 161730500
updated: 2026-04-09 03:08:33

Version 1707017

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_employeehourset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_employeehourset`\n(\n `Id`  string , `ActualHours`  string , `BillableHours`  string , `EmployeeId`  string , `SV_LaborInstance_Id`  string , `DateTimePerformed`  string , `DateTimeEntered`  string , `AspNetUserEntered`  string , `TechnicianComments`  string , `HourlyRateWhenAdded`  string , `NeedsApproval`  string , `ApprovalDateTime`  string , `ApprovalUser_Id`  string , `Source`  string , `Notes`  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_EmployeeHourSet/2026-04-08/1775635522'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_employeehourset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EmployeeHourSet/2026-04-08/1775635522
id: 1707017
processed: 1

raw_data:

{
    "ActualHours": 1,
    "ApprovalDateTime": 11,
    "ApprovalUser_Id": 12,
    "AspNetUserEntered": 7,
    "BillableHours": 2,
    "DateTimeEntered": 6,
    "DateTimePerformed": 5,
    "EmployeeId": 3,
    "HourlyRateWhenAdded": 9,
    "Id": 0,
    "NeedsApproval": 10,
    "Notes": 14,
    "SV_LaborInstance_Id": 4,
    "Source": 13,
    "TechnicianComments": 8
}

schema_attributes:

{
    "ActualHours": "string",
    "ApprovalDateTime": "string",
    "ApprovalUser_Id": "string",
    "AspNetUserEntered": "string",
    "BillableHours": "string",
    "DateTimeEntered": "string",
    "DateTimePerformed": "string",
    "EmployeeId": "string",
    "HourlyRateWhenAdded": "string",
    "Id": "string",
    "NeedsApproval": "string",
    "Notes": "string",
    "SV_LaborInstance_Id": "string",
    "Source": "string",
    "TechnicianComments": "string"
}

schema_name_id: 1802
schema_scan_id: 161675681
updated: 2026-04-08 03:10:21

Version 1705813

created: 2026-04-07 03:01:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_employeehourset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_employeehourset`\n(\n `Id`  string , `ActualHours`  string , `BillableHours`  string , `EmployeeId`  string , `SV_LaborInstance_Id`  string , `DateTimePerformed`  string , `DateTimeEntered`  string , `AspNetUserEntered`  string , `TechnicianComments`  string , `HourlyRateWhenAdded`  string , `NeedsApproval`  string , `ApprovalDateTime`  string , `ApprovalUser_Id`  string , `Source`  string , `Notes`  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_EmployeeHourSet/2026-04-07/1775548685'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_employeehourset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EmployeeHourSet/2026-04-07/1775548685
id: 1705813
processed: 1

raw_data:

{
    "ActualHours": 1,
    "ApprovalDateTime": 11,
    "ApprovalUser_Id": 12,
    "AspNetUserEntered": 7,
    "BillableHours": 2,
    "DateTimeEntered": 6,
    "DateTimePerformed": 5,
    "EmployeeId": 3,
    "HourlyRateWhenAdded": 9,
    "Id": 0,
    "NeedsApproval": 10,
    "Notes": 14,
    "SV_LaborInstance_Id": 4,
    "Source": 13,
    "TechnicianComments": 8
}

schema_attributes:

{
    "ActualHours": "string",
    "ApprovalDateTime": "string",
    "ApprovalUser_Id": "string",
    "AspNetUserEntered": "string",
    "BillableHours": "string",
    "DateTimeEntered": "string",
    "DateTimePerformed": "string",
    "EmployeeId": "string",
    "HourlyRateWhenAdded": "string",
    "Id": "string",
    "NeedsApproval": "string",
    "Notes": "string",
    "SV_LaborInstance_Id": "string",
    "Source": "string",
    "TechnicianComments": "string"
}

schema_name_id: 1802
schema_scan_id: 161619178
updated: 2026-04-07 03:02:02

Version 1704497

created: 2026-04-06 03:06:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_employeehourset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_employeehourset`\n(\n `Id`  string , `ActualHours`  string , `BillableHours`  string , `EmployeeId`  string , `SV_LaborInstance_Id`  string , `DateTimePerformed`  string , `DateTimeEntered`  string , `AspNetUserEntered`  string , `TechnicianComments`  string , `HourlyRateWhenAdded`  string , `NeedsApproval`  string , `ApprovalDateTime`  string , `ApprovalUser_Id`  string , `Source`  string , `Notes`  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_EmployeeHourSet/2026-04-06/1775462634'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_employeehourset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EmployeeHourSet/2026-04-06/1775462634
id: 1704497
processed: 1

raw_data:

{
    "ActualHours": 1,
    "ApprovalDateTime": 11,
    "ApprovalUser_Id": 12,
    "AspNetUserEntered": 7,
    "BillableHours": 2,
    "DateTimeEntered": 6,
    "DateTimePerformed": 5,
    "EmployeeId": 3,
    "HourlyRateWhenAdded": 9,
    "Id": 0,
    "NeedsApproval": 10,
    "Notes": 14,
    "SV_LaborInstance_Id": 4,
    "Source": 13,
    "TechnicianComments": 8
}

schema_attributes:

{
    "ActualHours": "string",
    "ApprovalDateTime": "string",
    "ApprovalUser_Id": "string",
    "AspNetUserEntered": "string",
    "BillableHours": "string",
    "DateTimeEntered": "string",
    "DateTimePerformed": "string",
    "EmployeeId": "string",
    "HourlyRateWhenAdded": "string",
    "Id": "string",
    "NeedsApproval": "string",
    "Notes": "string",
    "SV_LaborInstance_Id": "string",
    "Source": "string",
    "TechnicianComments": "string"
}

schema_name_id: 1802
schema_scan_id: 161561586
updated: 2026-04-06 03:06:16

Version 1703338

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_employeehourset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_employeehourset`\n(\n `Id`  string , `ActualHours`  string , `BillableHours`  string , `EmployeeId`  string , `SV_LaborInstance_Id`  string , `DateTimePerformed`  string , `DateTimeEntered`  string , `AspNetUserEntered`  string , `TechnicianComments`  string , `HourlyRateWhenAdded`  string , `NeedsApproval`  string , `ApprovalDateTime`  string , `ApprovalUser_Id`  string , `Source`  string , `Notes`  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_EmployeeHourSet/2026-04-05/1775376267'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_employeehourset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EmployeeHourSet/2026-04-05/1775376267
id: 1703338
processed: 1

raw_data:

{
    "ActualHours": 1,
    "ApprovalDateTime": 11,
    "ApprovalUser_Id": 12,
    "AspNetUserEntered": 7,
    "BillableHours": 2,
    "DateTimeEntered": 6,
    "DateTimePerformed": 5,
    "EmployeeId": 3,
    "HourlyRateWhenAdded": 9,
    "Id": 0,
    "NeedsApproval": 10,
    "Notes": 14,
    "SV_LaborInstance_Id": 4,
    "Source": 13,
    "TechnicianComments": 8
}

schema_attributes:

{
    "ActualHours": "string",
    "ApprovalDateTime": "string",
    "ApprovalUser_Id": "string",
    "AspNetUserEntered": "string",
    "BillableHours": "string",
    "DateTimeEntered": "string",
    "DateTimePerformed": "string",
    "EmployeeId": "string",
    "HourlyRateWhenAdded": "string",
    "Id": "string",
    "NeedsApproval": "string",
    "Notes": "string",
    "SV_LaborInstance_Id": "string",
    "Source": "string",
    "TechnicianComments": "string"
}

schema_name_id: 1802
schema_scan_id: 161514919
updated: 2026-04-05 03:06:57

Version 1702204

created: 2026-04-04 03:07:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_employeehourset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_employeehourset`\n(\n `Id`  string , `ActualHours`  string , `BillableHours`  string , `EmployeeId`  string , `SV_LaborInstance_Id`  string , `DateTimePerformed`  string , `DateTimeEntered`  string , `AspNetUserEntered`  string , `TechnicianComments`  string , `HourlyRateWhenAdded`  string , `NeedsApproval`  string , `ApprovalDateTime`  string , `ApprovalUser_Id`  string , `Source`  string , `Notes`  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_EmployeeHourSet/2026-04-04/1775289747'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_employeehourset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EmployeeHourSet/2026-04-04/1775289747
id: 1702204
processed: 1

raw_data:

{
    "ActualHours": 1,
    "ApprovalDateTime": 11,
    "ApprovalUser_Id": 12,
    "AspNetUserEntered": 7,
    "BillableHours": 2,
    "DateTimeEntered": 6,
    "DateTimePerformed": 5,
    "EmployeeId": 3,
    "HourlyRateWhenAdded": 9,
    "Id": 0,
    "NeedsApproval": 10,
    "Notes": 14,
    "SV_LaborInstance_Id": 4,
    "Source": 13,
    "TechnicianComments": 8
}

schema_attributes:

{
    "ActualHours": "string",
    "ApprovalDateTime": "string",
    "ApprovalUser_Id": "string",
    "AspNetUserEntered": "string",
    "BillableHours": "string",
    "DateTimeEntered": "string",
    "DateTimePerformed": "string",
    "EmployeeId": "string",
    "HourlyRateWhenAdded": "string",
    "Id": "string",
    "NeedsApproval": "string",
    "Notes": "string",
    "SV_LaborInstance_Id": "string",
    "Source": "string",
    "TechnicianComments": "string"
}

schema_name_id: 1802
schema_scan_id: 161460486
updated: 2026-04-04 03:07:55

Version 1700981

created: 2026-04-03 03:11:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_employeehourset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_employeehourset`\n(\n `Id`  string , `ActualHours`  string , `BillableHours`  string , `EmployeeId`  string , `SV_LaborInstance_Id`  string , `DateTimePerformed`  string , `DateTimeEntered`  string , `AspNetUserEntered`  string , `TechnicianComments`  string , `HourlyRateWhenAdded`  string , `NeedsApproval`  string , `ApprovalDateTime`  string , `ApprovalUser_Id`  string , `Source`  string , `Notes`  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_EmployeeHourSet/2026-04-03/1775203516'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_employeehourset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EmployeeHourSet/2026-04-03/1775203516
id: 1700981
processed: 1

raw_data:

{
    "ActualHours": 1,
    "ApprovalDateTime": 11,
    "ApprovalUser_Id": 12,
    "AspNetUserEntered": 7,
    "BillableHours": 2,
    "DateTimeEntered": 6,
    "DateTimePerformed": 5,
    "EmployeeId": 3,
    "HourlyRateWhenAdded": 9,
    "Id": 0,
    "NeedsApproval": 10,
    "Notes": 14,
    "SV_LaborInstance_Id": 4,
    "Source": 13,
    "TechnicianComments": 8
}

schema_attributes:

{
    "ActualHours": "string",
    "ApprovalDateTime": "string",
    "ApprovalUser_Id": "string",
    "AspNetUserEntered": "string",
    "BillableHours": "string",
    "DateTimeEntered": "string",
    "DateTimePerformed": "string",
    "EmployeeId": "string",
    "HourlyRateWhenAdded": "string",
    "Id": "string",
    "NeedsApproval": "string",
    "Notes": "string",
    "SV_LaborInstance_Id": "string",
    "Source": "string",
    "TechnicianComments": "string"
}

schema_name_id: 1802
schema_scan_id: 161401950
updated: 2026-04-03 03:11:35

Schema Scans: 15

Last at 2026-04-17 03:07:36

Scan 162167700

duration: 0:00:12.130375

exit_message:

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

id: 162167700

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_EmployeeHourSet/2026-04-17/1776412995",
        "key": "raw/molo_moloSV_EmployeeHourSet/2026-04-17/1776412995/SV_EmployeeHourSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EmployeeHourSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2735025106991448697,
        "service_name": "drive-thru",
        "span_id": 14345308316885356616,
        "trace_id": 16714629391343470564
    }
}

running: False
schema_name_id: 1802
start_time: 2026-04-17 03:07:36
success: True
trace_id: 16714629391343470564

Scan 162112017

duration: 0:00:12.090332

exit_message:

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

id: 162112017

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_EmployeeHourSet/2026-04-16/1776326695",
        "key": "raw/molo_moloSV_EmployeeHourSet/2026-04-16/1776326695/SV_EmployeeHourSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EmployeeHourSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4133645880531545372,
        "service_name": "drive-thru",
        "span_id": 5232301220558905671,
        "trace_id": 6406496656177273293
    }
}

running: False
schema_name_id: 1802
start_time: 2026-04-16 03:13:49
success: True
trace_id: 6406496656177273293

Scan 162056029

duration: 0:00:12.037320

exit_message:

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

id: 162056029

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_EmployeeHourSet/2026-04-15/1776240183",
        "key": "raw/molo_moloSV_EmployeeHourSet/2026-04-15/1776240183/SV_EmployeeHourSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EmployeeHourSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14464906129175273600,
        "service_name": "drive-thru",
        "span_id": 11226824666081920458,
        "trace_id": 10529260398338329394
    }
}

running: False
schema_name_id: 1802
start_time: 2026-04-15 03:07:58
success: True
trace_id: 10529260398338329394

Scan 162000666

duration: 0:00:14.499635

exit_message:

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

id: 162000666

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_EmployeeHourSet/2026-04-14/1776154137",
        "key": "raw/molo_moloSV_EmployeeHourSet/2026-04-14/1776154137/SV_EmployeeHourSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EmployeeHourSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9094162425817346524,
        "service_name": "drive-thru",
        "span_id": 6025294479127913504,
        "trace_id": 16611727930942771635
    }
}

running: False
schema_name_id: 1802
start_time: 2026-04-14 03:11:04
success: True
trace_id: 16611727930942771635

Scan 161942615

duration: 0:00:12.094911

exit_message:

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

id: 161942615

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_EmployeeHourSet/2026-04-13/1776067132",
        "key": "raw/molo_moloSV_EmployeeHourSet/2026-04-13/1776067132/SV_EmployeeHourSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EmployeeHourSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16376991451020623982,
        "service_name": "drive-thru",
        "span_id": 12984856974209345152,
        "trace_id": 15859330386391883019
    }
}

running: False
schema_name_id: 1802
start_time: 2026-04-13 03:04:11
success: True
trace_id: 15859330386391883019

Scan 161893362

duration: 0:00:12.027924

exit_message:

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

id: 161893362

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_EmployeeHourSet/2026-04-12/1775980827",
        "key": "raw/molo_moloSV_EmployeeHourSet/2026-04-12/1775980827/SV_EmployeeHourSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EmployeeHourSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18286433624561607939,
        "service_name": "drive-thru",
        "span_id": 14354600750550911362,
        "trace_id": 8034425043134610380
    }
}

running: False
schema_name_id: 1802
start_time: 2026-04-12 03:05:49
success: True
trace_id: 8034425043134610380

Scan 161841212

duration: 0:00:14.682771

exit_message:

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

id: 161841212

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_EmployeeHourSet/2026-04-11/1775894598",
        "key": "raw/molo_moloSV_EmployeeHourSet/2026-04-11/1775894598/SV_EmployeeHourSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EmployeeHourSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14119168552244821928,
        "service_name": "drive-thru",
        "span_id": 16813992350505226210,
        "trace_id": 11419827341835970941
    }
}

running: False
schema_name_id: 1802
start_time: 2026-04-11 03:05:41
success: True
trace_id: 11419827341835970941

Scan 161786023

duration: 0:00:14.565685

exit_message:

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

id: 161786023

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_EmployeeHourSet/2026-04-10/1775808361",
        "key": "raw/molo_moloSV_EmployeeHourSet/2026-04-10/1775808361/SV_EmployeeHourSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EmployeeHourSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5472570801821502787,
        "service_name": "drive-thru",
        "span_id": 8428709751196701611,
        "trace_id": 8267827487104798757
    }
}

running: False
schema_name_id: 1802
start_time: 2026-04-10 03:09:11
success: True
trace_id: 8267827487104798757

Scan 161730500

duration: 0:00:14.633879

exit_message:

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

id: 161730500

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_EmployeeHourSet/2026-04-09/1775721686",
        "key": "raw/molo_moloSV_EmployeeHourSet/2026-04-09/1775721686/SV_EmployeeHourSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EmployeeHourSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1922948880206856020,
        "service_name": "drive-thru",
        "span_id": 6602441216269967201,
        "trace_id": 12273796128485172211
    }
}

running: False
schema_name_id: 1802
start_time: 2026-04-09 03:08:19
success: True
trace_id: 12273796128485172211

Scan 161675681

duration: 0:00:12.226388

exit_message:

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

id: 161675681

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_EmployeeHourSet/2026-04-08/1775635522",
        "key": "raw/molo_moloSV_EmployeeHourSet/2026-04-08/1775635522/SV_EmployeeHourSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EmployeeHourSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10007916397477249383,
        "service_name": "drive-thru",
        "span_id": 3528621503916889920,
        "trace_id": 3099710871914319262
    }
}

running: False
schema_name_id: 1802
start_time: 2026-04-08 03:10:09
success: True
trace_id: 3099710871914319262

Scan 161619178

duration: 0:00:14.694149

exit_message:

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

id: 161619178

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_EmployeeHourSet/2026-04-07/1775548685",
        "key": "raw/molo_moloSV_EmployeeHourSet/2026-04-07/1775548685/SV_EmployeeHourSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EmployeeHourSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12492407683047300658,
        "service_name": "drive-thru",
        "span_id": 6588815203376843373,
        "trace_id": 11977501620725887113
    }
}

running: False
schema_name_id: 1802
start_time: 2026-04-07 03:01:47
success: True
trace_id: 11977501620725887113

Scan 161561586

duration: 0:00:14.873039

exit_message:

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

id: 161561586

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_EmployeeHourSet/2026-04-06/1775462634",
        "key": "raw/molo_moloSV_EmployeeHourSet/2026-04-06/1775462634/SV_EmployeeHourSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EmployeeHourSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8145216605180534834,
        "service_name": "drive-thru",
        "span_id": 609434007156634149,
        "trace_id": 10888581918056227735
    }
}

running: False
schema_name_id: 1802
start_time: 2026-04-06 03:06:01
success: True
trace_id: 10888581918056227735

Scan 161514919

duration: 0:00:14.464529

exit_message:

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

id: 161514919

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_EmployeeHourSet/2026-04-05/1775376267",
        "key": "raw/molo_moloSV_EmployeeHourSet/2026-04-05/1775376267/SV_EmployeeHourSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EmployeeHourSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7582405100972477816,
        "service_name": "drive-thru",
        "span_id": 11609779047458609884,
        "trace_id": 174705286813192968
    }
}

running: False
schema_name_id: 1802
start_time: 2026-04-05 03:06:42
success: True
trace_id: 174705286813192968

Scan 161460486

duration: 0:00:11.930358

exit_message:

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

id: 161460486

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_EmployeeHourSet/2026-04-04/1775289747",
        "key": "raw/molo_moloSV_EmployeeHourSet/2026-04-04/1775289747/SV_EmployeeHourSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EmployeeHourSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3037942295485625868,
        "service_name": "drive-thru",
        "span_id": 2873471507015349198,
        "trace_id": 1427566169896129401
    }
}

running: False
schema_name_id: 1802
start_time: 2026-04-04 03:07:43
success: True
trace_id: 1427566169896129401

Scan 161401950

duration: 0:00:14.647687

exit_message:

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

id: 161401950

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_EmployeeHourSet/2026-04-03/1775203516",
        "key": "raw/molo_moloSV_EmployeeHourSet/2026-04-03/1775203516/SV_EmployeeHourSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EmployeeHourSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1563228700656090340,
        "service_name": "drive-thru",
        "span_id": 15794072445012914736,
        "trace_id": 13084930343137179839
    }
}

running: False
schema_name_id: 1802
start_time: 2026-04-03 03:11:20
success: True
trace_id: 13084930343137179839

Partitions:

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

Schema:

attributes:

{
    "ActualHours": "string",
    "ApprovalDateTime": "string",
    "ApprovalUser_Id": "string",
    "AspNetUserEntered": "string",
    "BillableHours": "string",
    "DateTimeEntered": "string",
    "DateTimePerformed": "string",
    "EmployeeId": "string",
    "HourlyRateWhenAdded": "string",
    "Id": "string",
    "NeedsApproval": "string",
    "Notes": "string",
    "SV_LaborInstance_Id": "string",
    "Source": "string",
    "TechnicianComments": "string"
}

created: 2026-04-17 03:07:37

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_employeehourset`\n(\n `Id`  string , `ActualHours`  string , `BillableHours`  string , `EmployeeId`  string , `SV_LaborInstance_Id`  string , `DateTimePerformed`  string , `DateTimeEntered`  string , `AspNetUserEntered`  string , `TechnicianComments`  string , `HourlyRateWhenAdded`  string , `NeedsApproval`  string , `ApprovalDateTime`  string , `ApprovalUser_Id`  string , `Source`  string , `Notes`  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_EmployeeHourSet/2026-04-17/1776412995'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_employeehourset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_employeehourset"
}

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:02:41",
        "disabled": false,
        "format": "raw",
        "id": 1802,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molosv_employeehourset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "ActualHours": "string",
            "ApprovalDateTime": "string",
            "ApprovalUser_Id": "string",
            "AspNetUserEntered": "string",
            "BillableHours": "string",
            "DateTimeEntered": "string",
            "DateTimePerformed": "string",
            "EmployeeId": "string",
            "HourlyRateWhenAdded": "string",
            "Id": "string",
            "NeedsApproval": "string",
            "Notes": "string",
            "SV_LaborInstance_Id": "string",
            "Source": "string",
            "TechnicianComments": "string"
        },
        "created": "2026-04-17 03:07:37",
        "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_employeehourset`\n(\n `Id`  string , `ActualHours`  string , `BillableHours`  string , `EmployeeId`  string , `SV_LaborInstance_Id`  string , `DateTimePerformed`  string , `DateTimeEntered`  string , `AspNetUserEntered`  string , `TechnicianComments`  string , `HourlyRateWhenAdded`  string , `NeedsApproval`  string , `ApprovalDateTime`  string , `ApprovalUser_Id`  string , `Source`  string , `Notes`  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_EmployeeHourSet/2026-04-17/1776412995'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_employeehourset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_employeehourset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}