Schema Info

Schema Name: sfdl_prod_drivethru.molo_molosv_timerset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717778

created: 2026-04-17 03:10:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_timerset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_timerset`\n(\n `Id`  string , `OverrideHours`  string , `Comments`  string , `StartDateTime`  string , `StartLatitude`  string , `StartLongitude`  string , `StartDirection`  string , `StartSpeed`  string , `StartHorizontalAccuracy`  string , `StartVerticalAccuracy`  string , `AspNetUserId`  string , `EndDateTime`  string , `EndLatitude`  string , `EndLongitude`  string , `EndDirection`  string , `EndSpeed`  string , `EndHorizontalAccuracy`  string , `EndVerticalAccuracy`  string , `StartAspNetUser_Id`  string , `JobId`  string , `EmployeeHourId`  string , `CancellationDate`  string , `HasNoImages`  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_TimerSet/2026-04-17/1776413127'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_timerset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_TimerSet/2026-04-17/1776413127
id: 1717778
processed: 1

raw_data:

{
    "AspNetUserId": 10,
    "CancellationDate": 21,
    "Comments": 2,
    "EmployeeHourId": 20,
    "EndDateTime": 11,
    "EndDirection": 14,
    "EndHorizontalAccuracy": 16,
    "EndLatitude": 12,
    "EndLongitude": 13,
    "EndSpeed": 15,
    "EndVerticalAccuracy": 17,
    "HasNoImages": 22,
    "Id": 0,
    "JobId": 19,
    "OverrideHours": 1,
    "StartAspNetUser_Id": 18,
    "StartDateTime": 3,
    "StartDirection": 6,
    "StartHorizontalAccuracy": 8,
    "StartLatitude": 4,
    "StartLongitude": 5,
    "StartSpeed": 7,
    "StartVerticalAccuracy": 9
}

schema_attributes:

{
    "AspNetUserId": "string",
    "CancellationDate": "string",
    "Comments": "string",
    "EmployeeHourId": "string",
    "EndDateTime": "string",
    "EndDirection": "string",
    "EndHorizontalAccuracy": "string",
    "EndLatitude": "string",
    "EndLongitude": "string",
    "EndSpeed": "string",
    "EndVerticalAccuracy": "string",
    "HasNoImages": "string",
    "Id": "string",
    "JobId": "string",
    "OverrideHours": "string",
    "StartAspNetUser_Id": "string",
    "StartDateTime": "string",
    "StartDirection": "string",
    "StartHorizontalAccuracy": "string",
    "StartLatitude": "string",
    "StartLongitude": "string",
    "StartSpeed": "string",
    "StartVerticalAccuracy": "string"
}

schema_name_id: 1784
schema_scan_id: 162167802
updated: 2026-04-17 03:10:57

Version 1716555

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_timerset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_timerset`\n(\n `Id`  string , `OverrideHours`  string , `Comments`  string , `StartDateTime`  string , `StartLatitude`  string , `StartLongitude`  string , `StartDirection`  string , `StartSpeed`  string , `StartHorizontalAccuracy`  string , `StartVerticalAccuracy`  string , `AspNetUserId`  string , `EndDateTime`  string , `EndLatitude`  string , `EndLongitude`  string , `EndDirection`  string , `EndSpeed`  string , `EndHorizontalAccuracy`  string , `EndVerticalAccuracy`  string , `StartAspNetUser_Id`  string , `JobId`  string , `EmployeeHourId`  string , `CancellationDate`  string , `HasNoImages`  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_TimerSet/2026-04-16/1776326732'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_timerset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_TimerSet/2026-04-16/1776326732
id: 1716555
processed: 1

raw_data:

{
    "AspNetUserId": 10,
    "CancellationDate": 21,
    "Comments": 2,
    "EmployeeHourId": 20,
    "EndDateTime": 11,
    "EndDirection": 14,
    "EndHorizontalAccuracy": 16,
    "EndLatitude": 12,
    "EndLongitude": 13,
    "EndSpeed": 15,
    "EndVerticalAccuracy": 17,
    "HasNoImages": 22,
    "Id": 0,
    "JobId": 19,
    "OverrideHours": 1,
    "StartAspNetUser_Id": 18,
    "StartDateTime": 3,
    "StartDirection": 6,
    "StartHorizontalAccuracy": 8,
    "StartLatitude": 4,
    "StartLongitude": 5,
    "StartSpeed": 7,
    "StartVerticalAccuracy": 9
}

schema_attributes:

{
    "AspNetUserId": "string",
    "CancellationDate": "string",
    "Comments": "string",
    "EmployeeHourId": "string",
    "EndDateTime": "string",
    "EndDirection": "string",
    "EndHorizontalAccuracy": "string",
    "EndLatitude": "string",
    "EndLongitude": "string",
    "EndSpeed": "string",
    "EndVerticalAccuracy": "string",
    "HasNoImages": "string",
    "Id": "string",
    "JobId": "string",
    "OverrideHours": "string",
    "StartAspNetUser_Id": "string",
    "StartDateTime": "string",
    "StartDirection": "string",
    "StartHorizontalAccuracy": "string",
    "StartLatitude": "string",
    "StartLongitude": "string",
    "StartSpeed": "string",
    "StartVerticalAccuracy": "string"
}

schema_name_id: 1784
schema_scan_id: 162112013
updated: 2026-04-16 03:13:54

Version 1715335

created: 2026-04-15 03:10:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_timerset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_timerset`\n(\n `Id`  string , `OverrideHours`  string , `Comments`  string , `StartDateTime`  string , `StartLatitude`  string , `StartLongitude`  string , `StartDirection`  string , `StartSpeed`  string , `StartHorizontalAccuracy`  string , `StartVerticalAccuracy`  string , `AspNetUserId`  string , `EndDateTime`  string , `EndLatitude`  string , `EndLongitude`  string , `EndDirection`  string , `EndSpeed`  string , `EndHorizontalAccuracy`  string , `EndVerticalAccuracy`  string , `StartAspNetUser_Id`  string , `JobId`  string , `EmployeeHourId`  string , `CancellationDate`  string , `HasNoImages`  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_TimerSet/2026-04-15/1776240197'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_timerset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_TimerSet/2026-04-15/1776240197
id: 1715335
processed: 1

raw_data:

{
    "AspNetUserId": 10,
    "CancellationDate": 21,
    "Comments": 2,
    "EmployeeHourId": 20,
    "EndDateTime": 11,
    "EndDirection": 14,
    "EndHorizontalAccuracy": 16,
    "EndLatitude": 12,
    "EndLongitude": 13,
    "EndSpeed": 15,
    "EndVerticalAccuracy": 17,
    "HasNoImages": 22,
    "Id": 0,
    "JobId": 19,
    "OverrideHours": 1,
    "StartAspNetUser_Id": 18,
    "StartDateTime": 3,
    "StartDirection": 6,
    "StartHorizontalAccuracy": 8,
    "StartLatitude": 4,
    "StartLongitude": 5,
    "StartSpeed": 7,
    "StartVerticalAccuracy": 9
}

schema_attributes:

{
    "AspNetUserId": "string",
    "CancellationDate": "string",
    "Comments": "string",
    "EmployeeHourId": "string",
    "EndDateTime": "string",
    "EndDirection": "string",
    "EndHorizontalAccuracy": "string",
    "EndLatitude": "string",
    "EndLongitude": "string",
    "EndSpeed": "string",
    "EndVerticalAccuracy": "string",
    "HasNoImages": "string",
    "Id": "string",
    "JobId": "string",
    "OverrideHours": "string",
    "StartAspNetUser_Id": "string",
    "StartDateTime": "string",
    "StartDirection": "string",
    "StartHorizontalAccuracy": "string",
    "StartLatitude": "string",
    "StartLongitude": "string",
    "StartSpeed": "string",
    "StartVerticalAccuracy": "string"
}

schema_name_id: 1784
schema_scan_id: 162056127
updated: 2026-04-15 03:10:58

Version 1714173

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_timerset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_timerset`\n(\n `Id`  string , `OverrideHours`  string , `Comments`  string , `StartDateTime`  string , `StartLatitude`  string , `StartLongitude`  string , `StartDirection`  string , `StartSpeed`  string , `StartHorizontalAccuracy`  string , `StartVerticalAccuracy`  string , `AspNetUserId`  string , `EndDateTime`  string , `EndLatitude`  string , `EndLongitude`  string , `EndDirection`  string , `EndSpeed`  string , `EndHorizontalAccuracy`  string , `EndVerticalAccuracy`  string , `StartAspNetUser_Id`  string , `JobId`  string , `EmployeeHourId`  string , `CancellationDate`  string , `HasNoImages`  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_TimerSet/2026-04-14/1776154164'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_timerset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_TimerSet/2026-04-14/1776154164
id: 1714173
processed: 1

raw_data:

{
    "AspNetUserId": 10,
    "CancellationDate": 21,
    "Comments": 2,
    "EmployeeHourId": 20,
    "EndDateTime": 11,
    "EndDirection": 14,
    "EndHorizontalAccuracy": 16,
    "EndLatitude": 12,
    "EndLongitude": 13,
    "EndSpeed": 15,
    "EndVerticalAccuracy": 17,
    "HasNoImages": 22,
    "Id": 0,
    "JobId": 19,
    "OverrideHours": 1,
    "StartAspNetUser_Id": 18,
    "StartDateTime": 3,
    "StartDirection": 6,
    "StartHorizontalAccuracy": 8,
    "StartLatitude": 4,
    "StartLongitude": 5,
    "StartSpeed": 7,
    "StartVerticalAccuracy": 9
}

schema_attributes:

{
    "AspNetUserId": "string",
    "CancellationDate": "string",
    "Comments": "string",
    "EmployeeHourId": "string",
    "EndDateTime": "string",
    "EndDirection": "string",
    "EndHorizontalAccuracy": "string",
    "EndLatitude": "string",
    "EndLongitude": "string",
    "EndSpeed": "string",
    "EndVerticalAccuracy": "string",
    "HasNoImages": "string",
    "Id": "string",
    "JobId": "string",
    "OverrideHours": "string",
    "StartAspNetUser_Id": "string",
    "StartDateTime": "string",
    "StartDirection": "string",
    "StartHorizontalAccuracy": "string",
    "StartLatitude": "string",
    "StartLongitude": "string",
    "StartSpeed": "string",
    "StartVerticalAccuracy": "string"
}

schema_name_id: 1784
schema_scan_id: 162000697
updated: 2026-04-14 03:12:19

Version 1712968

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_timerset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_timerset`\n(\n `Id`  string , `OverrideHours`  string , `Comments`  string , `StartDateTime`  string , `StartLatitude`  string , `StartLongitude`  string , `StartDirection`  string , `StartSpeed`  string , `StartHorizontalAccuracy`  string , `StartVerticalAccuracy`  string , `AspNetUserId`  string , `EndDateTime`  string , `EndLatitude`  string , `EndLongitude`  string , `EndDirection`  string , `EndSpeed`  string , `EndHorizontalAccuracy`  string , `EndVerticalAccuracy`  string , `StartAspNetUser_Id`  string , `JobId`  string , `EmployeeHourId`  string , `CancellationDate`  string , `HasNoImages`  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_TimerSet/2026-04-13/1776067159'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_timerset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_TimerSet/2026-04-13/1776067159
id: 1712968
processed: 1

raw_data:

{
    "AspNetUserId": 10,
    "CancellationDate": 21,
    "Comments": 2,
    "EmployeeHourId": 20,
    "EndDateTime": 11,
    "EndDirection": 14,
    "EndHorizontalAccuracy": 16,
    "EndLatitude": 12,
    "EndLongitude": 13,
    "EndSpeed": 15,
    "EndVerticalAccuracy": 17,
    "HasNoImages": 22,
    "Id": 0,
    "JobId": 19,
    "OverrideHours": 1,
    "StartAspNetUser_Id": 18,
    "StartDateTime": 3,
    "StartDirection": 6,
    "StartHorizontalAccuracy": 8,
    "StartLatitude": 4,
    "StartLongitude": 5,
    "StartSpeed": 7,
    "StartVerticalAccuracy": 9
}

schema_attributes:

{
    "AspNetUserId": "string",
    "CancellationDate": "string",
    "Comments": "string",
    "EmployeeHourId": "string",
    "EndDateTime": "string",
    "EndDirection": "string",
    "EndHorizontalAccuracy": "string",
    "EndLatitude": "string",
    "EndLongitude": "string",
    "EndSpeed": "string",
    "EndVerticalAccuracy": "string",
    "HasNoImages": "string",
    "Id": "string",
    "JobId": "string",
    "OverrideHours": "string",
    "StartAspNetUser_Id": "string",
    "StartDateTime": "string",
    "StartDirection": "string",
    "StartHorizontalAccuracy": "string",
    "StartLatitude": "string",
    "StartLongitude": "string",
    "StartSpeed": "string",
    "StartVerticalAccuracy": "string"
}

schema_name_id: 1784
schema_scan_id: 161942817
updated: 2026-04-13 03:07:19

Version 1711681

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_timerset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_timerset`\n(\n `Id`  string , `OverrideHours`  string , `Comments`  string , `StartDateTime`  string , `StartLatitude`  string , `StartLongitude`  string , `StartDirection`  string , `StartSpeed`  string , `StartHorizontalAccuracy`  string , `StartVerticalAccuracy`  string , `AspNetUserId`  string , `EndDateTime`  string , `EndLatitude`  string , `EndLongitude`  string , `EndDirection`  string , `EndSpeed`  string , `EndHorizontalAccuracy`  string , `EndVerticalAccuracy`  string , `StartAspNetUser_Id`  string , `JobId`  string , `EmployeeHourId`  string , `CancellationDate`  string , `HasNoImages`  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_TimerSet/2026-04-12/1775980859'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_timerset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_TimerSet/2026-04-12/1775980859
id: 1711681
processed: 1

raw_data:

{
    "AspNetUserId": 10,
    "CancellationDate": 21,
    "Comments": 2,
    "EmployeeHourId": 20,
    "EndDateTime": 11,
    "EndDirection": 14,
    "EndHorizontalAccuracy": 16,
    "EndLatitude": 12,
    "EndLongitude": 13,
    "EndSpeed": 15,
    "EndVerticalAccuracy": 17,
    "HasNoImages": 22,
    "Id": 0,
    "JobId": 19,
    "OverrideHours": 1,
    "StartAspNetUser_Id": 18,
    "StartDateTime": 3,
    "StartDirection": 6,
    "StartHorizontalAccuracy": 8,
    "StartLatitude": 4,
    "StartLongitude": 5,
    "StartSpeed": 7,
    "StartVerticalAccuracy": 9
}

schema_attributes:

{
    "AspNetUserId": "string",
    "CancellationDate": "string",
    "Comments": "string",
    "EmployeeHourId": "string",
    "EndDateTime": "string",
    "EndDirection": "string",
    "EndHorizontalAccuracy": "string",
    "EndLatitude": "string",
    "EndLongitude": "string",
    "EndSpeed": "string",
    "EndVerticalAccuracy": "string",
    "HasNoImages": "string",
    "Id": "string",
    "JobId": "string",
    "OverrideHours": "string",
    "StartAspNetUser_Id": "string",
    "StartDateTime": "string",
    "StartDirection": "string",
    "StartHorizontalAccuracy": "string",
    "StartLatitude": "string",
    "StartLongitude": "string",
    "StartSpeed": "string",
    "StartVerticalAccuracy": "string"
}

schema_name_id: 1784
schema_scan_id: 161893214
updated: 2026-04-12 03:04:31

Version 1710557

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_timerset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_timerset`\n(\n `Id`  string , `OverrideHours`  string , `Comments`  string , `StartDateTime`  string , `StartLatitude`  string , `StartLongitude`  string , `StartDirection`  string , `StartSpeed`  string , `StartHorizontalAccuracy`  string , `StartVerticalAccuracy`  string , `AspNetUserId`  string , `EndDateTime`  string , `EndLatitude`  string , `EndLongitude`  string , `EndDirection`  string , `EndSpeed`  string , `EndHorizontalAccuracy`  string , `EndVerticalAccuracy`  string , `StartAspNetUser_Id`  string , `JobId`  string , `EmployeeHourId`  string , `CancellationDate`  string , `HasNoImages`  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_TimerSet/2026-04-11/1775894627'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_timerset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_TimerSet/2026-04-11/1775894627
id: 1710557
processed: 1

raw_data:

{
    "AspNetUserId": 10,
    "CancellationDate": 21,
    "Comments": 2,
    "EmployeeHourId": 20,
    "EndDateTime": 11,
    "EndDirection": 14,
    "EndHorizontalAccuracy": 16,
    "EndLatitude": 12,
    "EndLongitude": 13,
    "EndSpeed": 15,
    "EndVerticalAccuracy": 17,
    "HasNoImages": 22,
    "Id": 0,
    "JobId": 19,
    "OverrideHours": 1,
    "StartAspNetUser_Id": 18,
    "StartDateTime": 3,
    "StartDirection": 6,
    "StartHorizontalAccuracy": 8,
    "StartLatitude": 4,
    "StartLongitude": 5,
    "StartSpeed": 7,
    "StartVerticalAccuracy": 9
}

schema_attributes:

{
    "AspNetUserId": "string",
    "CancellationDate": "string",
    "Comments": "string",
    "EmployeeHourId": "string",
    "EndDateTime": "string",
    "EndDirection": "string",
    "EndHorizontalAccuracy": "string",
    "EndLatitude": "string",
    "EndLongitude": "string",
    "EndSpeed": "string",
    "EndVerticalAccuracy": "string",
    "HasNoImages": "string",
    "Id": "string",
    "JobId": "string",
    "OverrideHours": "string",
    "StartAspNetUser_Id": "string",
    "StartDateTime": "string",
    "StartDirection": "string",
    "StartHorizontalAccuracy": "string",
    "StartLatitude": "string",
    "StartLongitude": "string",
    "StartSpeed": "string",
    "StartVerticalAccuracy": "string"
}

schema_name_id: 1784
schema_scan_id: 161841362
updated: 2026-04-11 03:10:57

Version 1709315

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_timerset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_timerset`\n(\n `Id`  string , `OverrideHours`  string , `Comments`  string , `StartDateTime`  string , `StartLatitude`  string , `StartLongitude`  string , `StartDirection`  string , `StartSpeed`  string , `StartHorizontalAccuracy`  string , `StartVerticalAccuracy`  string , `AspNetUserId`  string , `EndDateTime`  string , `EndLatitude`  string , `EndLongitude`  string , `EndDirection`  string , `EndSpeed`  string , `EndHorizontalAccuracy`  string , `EndVerticalAccuracy`  string , `StartAspNetUser_Id`  string , `JobId`  string , `EmployeeHourId`  string , `CancellationDate`  string , `HasNoImages`  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_TimerSet/2026-04-10/1775808388'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_timerset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_TimerSet/2026-04-10/1775808388
id: 1709315
processed: 1

raw_data:

{
    "AspNetUserId": 10,
    "CancellationDate": 21,
    "Comments": 2,
    "EmployeeHourId": 20,
    "EndDateTime": 11,
    "EndDirection": 14,
    "EndHorizontalAccuracy": 16,
    "EndLatitude": 12,
    "EndLongitude": 13,
    "EndSpeed": 15,
    "EndVerticalAccuracy": 17,
    "HasNoImages": 22,
    "Id": 0,
    "JobId": 19,
    "OverrideHours": 1,
    "StartAspNetUser_Id": 18,
    "StartDateTime": 3,
    "StartDirection": 6,
    "StartHorizontalAccuracy": 8,
    "StartLatitude": 4,
    "StartLongitude": 5,
    "StartSpeed": 7,
    "StartVerticalAccuracy": 9
}

schema_attributes:

{
    "AspNetUserId": "string",
    "CancellationDate": "string",
    "Comments": "string",
    "EmployeeHourId": "string",
    "EndDateTime": "string",
    "EndDirection": "string",
    "EndHorizontalAccuracy": "string",
    "EndLatitude": "string",
    "EndLongitude": "string",
    "EndSpeed": "string",
    "EndVerticalAccuracy": "string",
    "HasNoImages": "string",
    "Id": "string",
    "JobId": "string",
    "OverrideHours": "string",
    "StartAspNetUser_Id": "string",
    "StartDateTime": "string",
    "StartDirection": "string",
    "StartHorizontalAccuracy": "string",
    "StartLatitude": "string",
    "StartLongitude": "string",
    "StartSpeed": "string",
    "StartVerticalAccuracy": "string"
}

schema_name_id: 1784
schema_scan_id: 161786013
updated: 2026-04-10 03:09:00

Version 1708180

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_timerset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_timerset`\n(\n `Id`  string , `OverrideHours`  string , `Comments`  string , `StartDateTime`  string , `StartLatitude`  string , `StartLongitude`  string , `StartDirection`  string , `StartSpeed`  string , `StartHorizontalAccuracy`  string , `StartVerticalAccuracy`  string , `AspNetUserId`  string , `EndDateTime`  string , `EndLatitude`  string , `EndLongitude`  string , `EndDirection`  string , `EndSpeed`  string , `EndHorizontalAccuracy`  string , `EndVerticalAccuracy`  string , `StartAspNetUser_Id`  string , `JobId`  string , `EmployeeHourId`  string , `CancellationDate`  string , `HasNoImages`  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_TimerSet/2026-04-09/1775721717'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_timerset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_TimerSet/2026-04-09/1775721717
id: 1708180
processed: 1

raw_data:

{
    "AspNetUserId": 10,
    "CancellationDate": 21,
    "Comments": 2,
    "EmployeeHourId": 20,
    "EndDateTime": 11,
    "EndDirection": 14,
    "EndHorizontalAccuracy": 16,
    "EndLatitude": 12,
    "EndLongitude": 13,
    "EndSpeed": 15,
    "EndVerticalAccuracy": 17,
    "HasNoImages": 22,
    "Id": 0,
    "JobId": 19,
    "OverrideHours": 1,
    "StartAspNetUser_Id": 18,
    "StartDateTime": 3,
    "StartDirection": 6,
    "StartHorizontalAccuracy": 8,
    "StartLatitude": 4,
    "StartLongitude": 5,
    "StartSpeed": 7,
    "StartVerticalAccuracy": 9
}

schema_attributes:

{
    "AspNetUserId": "string",
    "CancellationDate": "string",
    "Comments": "string",
    "EmployeeHourId": "string",
    "EndDateTime": "string",
    "EndDirection": "string",
    "EndHorizontalAccuracy": "string",
    "EndLatitude": "string",
    "EndLongitude": "string",
    "EndSpeed": "string",
    "EndVerticalAccuracy": "string",
    "HasNoImages": "string",
    "Id": "string",
    "JobId": "string",
    "OverrideHours": "string",
    "StartAspNetUser_Id": "string",
    "StartDateTime": "string",
    "StartDirection": "string",
    "StartHorizontalAccuracy": "string",
    "StartLatitude": "string",
    "StartLongitude": "string",
    "StartSpeed": "string",
    "StartVerticalAccuracy": "string"
}

schema_name_id: 1784
schema_scan_id: 161730407
updated: 2026-04-09 03:06:16

Version 1706917

created: 2026-04-08 03:06:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_timerset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_timerset`\n(\n `Id`  string , `OverrideHours`  string , `Comments`  string , `StartDateTime`  string , `StartLatitude`  string , `StartLongitude`  string , `StartDirection`  string , `StartSpeed`  string , `StartHorizontalAccuracy`  string , `StartVerticalAccuracy`  string , `AspNetUserId`  string , `EndDateTime`  string , `EndLatitude`  string , `EndLongitude`  string , `EndDirection`  string , `EndSpeed`  string , `EndHorizontalAccuracy`  string , `EndVerticalAccuracy`  string , `StartAspNetUser_Id`  string , `JobId`  string , `EmployeeHourId`  string , `CancellationDate`  string , `HasNoImages`  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_TimerSet/2026-04-08/1775635548'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_timerset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_TimerSet/2026-04-08/1775635548
id: 1706917
processed: 1

raw_data:

{
    "AspNetUserId": 10,
    "CancellationDate": 21,
    "Comments": 2,
    "EmployeeHourId": 20,
    "EndDateTime": 11,
    "EndDirection": 14,
    "EndHorizontalAccuracy": 16,
    "EndLatitude": 12,
    "EndLongitude": 13,
    "EndSpeed": 15,
    "EndVerticalAccuracy": 17,
    "HasNoImages": 22,
    "Id": 0,
    "JobId": 19,
    "OverrideHours": 1,
    "StartAspNetUser_Id": 18,
    "StartDateTime": 3,
    "StartDirection": 6,
    "StartHorizontalAccuracy": 8,
    "StartLatitude": 4,
    "StartLongitude": 5,
    "StartSpeed": 7,
    "StartVerticalAccuracy": 9
}

schema_attributes:

{
    "AspNetUserId": "string",
    "CancellationDate": "string",
    "Comments": "string",
    "EmployeeHourId": "string",
    "EndDateTime": "string",
    "EndDirection": "string",
    "EndHorizontalAccuracy": "string",
    "EndLatitude": "string",
    "EndLongitude": "string",
    "EndSpeed": "string",
    "EndVerticalAccuracy": "string",
    "HasNoImages": "string",
    "Id": "string",
    "JobId": "string",
    "OverrideHours": "string",
    "StartAspNetUser_Id": "string",
    "StartDateTime": "string",
    "StartDirection": "string",
    "StartHorizontalAccuracy": "string",
    "StartLatitude": "string",
    "StartLongitude": "string",
    "StartSpeed": "string",
    "StartVerticalAccuracy": "string"
}

schema_name_id: 1784
schema_scan_id: 161675549
updated: 2026-04-08 03:06:25

Version 1705841

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_timerset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_timerset`\n(\n `Id`  string , `OverrideHours`  string , `Comments`  string , `StartDateTime`  string , `StartLatitude`  string , `StartLongitude`  string , `StartDirection`  string , `StartSpeed`  string , `StartHorizontalAccuracy`  string , `StartVerticalAccuracy`  string , `AspNetUserId`  string , `EndDateTime`  string , `EndLatitude`  string , `EndLongitude`  string , `EndDirection`  string , `EndSpeed`  string , `EndHorizontalAccuracy`  string , `EndVerticalAccuracy`  string , `StartAspNetUser_Id`  string , `JobId`  string , `EmployeeHourId`  string , `CancellationDate`  string , `HasNoImages`  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_TimerSet/2026-04-07/1775548710'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_timerset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_TimerSet/2026-04-07/1775548710
id: 1705841
processed: 1

raw_data:

{
    "AspNetUserId": 10,
    "CancellationDate": 21,
    "Comments": 2,
    "EmployeeHourId": 20,
    "EndDateTime": 11,
    "EndDirection": 14,
    "EndHorizontalAccuracy": 16,
    "EndLatitude": 12,
    "EndLongitude": 13,
    "EndSpeed": 15,
    "EndVerticalAccuracy": 17,
    "HasNoImages": 22,
    "Id": 0,
    "JobId": 19,
    "OverrideHours": 1,
    "StartAspNetUser_Id": 18,
    "StartDateTime": 3,
    "StartDirection": 6,
    "StartHorizontalAccuracy": 8,
    "StartLatitude": 4,
    "StartLongitude": 5,
    "StartSpeed": 7,
    "StartVerticalAccuracy": 9
}

schema_attributes:

{
    "AspNetUserId": "string",
    "CancellationDate": "string",
    "Comments": "string",
    "EmployeeHourId": "string",
    "EndDateTime": "string",
    "EndDirection": "string",
    "EndHorizontalAccuracy": "string",
    "EndLatitude": "string",
    "EndLongitude": "string",
    "EndSpeed": "string",
    "EndVerticalAccuracy": "string",
    "HasNoImages": "string",
    "Id": "string",
    "JobId": "string",
    "OverrideHours": "string",
    "StartAspNetUser_Id": "string",
    "StartDateTime": "string",
    "StartDirection": "string",
    "StartHorizontalAccuracy": "string",
    "StartLatitude": "string",
    "StartLongitude": "string",
    "StartSpeed": "string",
    "StartVerticalAccuracy": "string"
}

schema_name_id: 1784
schema_scan_id: 161619325
updated: 2026-04-07 03:03:15

Version 1704658

created: 2026-04-06 03:12:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_timerset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_timerset`\n(\n `Id`  string , `OverrideHours`  string , `Comments`  string , `StartDateTime`  string , `StartLatitude`  string , `StartLongitude`  string , `StartDirection`  string , `StartSpeed`  string , `StartHorizontalAccuracy`  string , `StartVerticalAccuracy`  string , `AspNetUserId`  string , `EndDateTime`  string , `EndLatitude`  string , `EndLongitude`  string , `EndDirection`  string , `EndSpeed`  string , `EndHorizontalAccuracy`  string , `EndVerticalAccuracy`  string , `StartAspNetUser_Id`  string , `JobId`  string , `EmployeeHourId`  string , `CancellationDate`  string , `HasNoImages`  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_TimerSet/2026-04-06/1775462660'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_timerset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_TimerSet/2026-04-06/1775462660
id: 1704658
processed: 1

raw_data:

{
    "AspNetUserId": 10,
    "CancellationDate": 21,
    "Comments": 2,
    "EmployeeHourId": 20,
    "EndDateTime": 11,
    "EndDirection": 14,
    "EndHorizontalAccuracy": 16,
    "EndLatitude": 12,
    "EndLongitude": 13,
    "EndSpeed": 15,
    "EndVerticalAccuracy": 17,
    "HasNoImages": 22,
    "Id": 0,
    "JobId": 19,
    "OverrideHours": 1,
    "StartAspNetUser_Id": 18,
    "StartDateTime": 3,
    "StartDirection": 6,
    "StartHorizontalAccuracy": 8,
    "StartLatitude": 4,
    "StartLongitude": 5,
    "StartSpeed": 7,
    "StartVerticalAccuracy": 9
}

schema_attributes:

{
    "AspNetUserId": "string",
    "CancellationDate": "string",
    "Comments": "string",
    "EmployeeHourId": "string",
    "EndDateTime": "string",
    "EndDirection": "string",
    "EndHorizontalAccuracy": "string",
    "EndLatitude": "string",
    "EndLongitude": "string",
    "EndSpeed": "string",
    "EndVerticalAccuracy": "string",
    "HasNoImages": "string",
    "Id": "string",
    "JobId": "string",
    "OverrideHours": "string",
    "StartAspNetUser_Id": "string",
    "StartDateTime": "string",
    "StartDirection": "string",
    "StartHorizontalAccuracy": "string",
    "StartLatitude": "string",
    "StartLongitude": "string",
    "StartSpeed": "string",
    "StartVerticalAccuracy": "string"
}

schema_name_id: 1784
schema_scan_id: 161561810
updated: 2026-04-06 03:12:35

Version 1703345

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_timerset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_timerset`\n(\n `Id`  string , `OverrideHours`  string , `Comments`  string , `StartDateTime`  string , `StartLatitude`  string , `StartLongitude`  string , `StartDirection`  string , `StartSpeed`  string , `StartHorizontalAccuracy`  string , `StartVerticalAccuracy`  string , `AspNetUserId`  string , `EndDateTime`  string , `EndLatitude`  string , `EndLongitude`  string , `EndDirection`  string , `EndSpeed`  string , `EndHorizontalAccuracy`  string , `EndVerticalAccuracy`  string , `StartAspNetUser_Id`  string , `JobId`  string , `EmployeeHourId`  string , `CancellationDate`  string , `HasNoImages`  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_TimerSet/2026-04-05/1775376292'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_timerset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_TimerSet/2026-04-05/1775376292
id: 1703345
processed: 1

raw_data:

{
    "AspNetUserId": 10,
    "CancellationDate": 21,
    "Comments": 2,
    "EmployeeHourId": 20,
    "EndDateTime": 11,
    "EndDirection": 14,
    "EndHorizontalAccuracy": 16,
    "EndLatitude": 12,
    "EndLongitude": 13,
    "EndSpeed": 15,
    "EndVerticalAccuracy": 17,
    "HasNoImages": 22,
    "Id": 0,
    "JobId": 19,
    "OverrideHours": 1,
    "StartAspNetUser_Id": 18,
    "StartDateTime": 3,
    "StartDirection": 6,
    "StartHorizontalAccuracy": 8,
    "StartLatitude": 4,
    "StartLongitude": 5,
    "StartSpeed": 7,
    "StartVerticalAccuracy": 9
}

schema_attributes:

{
    "AspNetUserId": "string",
    "CancellationDate": "string",
    "Comments": "string",
    "EmployeeHourId": "string",
    "EndDateTime": "string",
    "EndDirection": "string",
    "EndHorizontalAccuracy": "string",
    "EndLatitude": "string",
    "EndLongitude": "string",
    "EndSpeed": "string",
    "EndVerticalAccuracy": "string",
    "HasNoImages": "string",
    "Id": "string",
    "JobId": "string",
    "OverrideHours": "string",
    "StartAspNetUser_Id": "string",
    "StartDateTime": "string",
    "StartDirection": "string",
    "StartHorizontalAccuracy": "string",
    "StartLatitude": "string",
    "StartLongitude": "string",
    "StartSpeed": "string",
    "StartVerticalAccuracy": "string"
}

schema_name_id: 1784
schema_scan_id: 161514926
updated: 2026-04-05 03:07:15

Version 1702244

created: 2026-04-04 03:09:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_timerset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_timerset`\n(\n `Id`  string , `OverrideHours`  string , `Comments`  string , `StartDateTime`  string , `StartLatitude`  string , `StartLongitude`  string , `StartDirection`  string , `StartSpeed`  string , `StartHorizontalAccuracy`  string , `StartVerticalAccuracy`  string , `AspNetUserId`  string , `EndDateTime`  string , `EndLatitude`  string , `EndLongitude`  string , `EndDirection`  string , `EndSpeed`  string , `EndHorizontalAccuracy`  string , `EndVerticalAccuracy`  string , `StartAspNetUser_Id`  string , `JobId`  string , `EmployeeHourId`  string , `CancellationDate`  string , `HasNoImages`  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_TimerSet/2026-04-04/1775289773'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_timerset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_TimerSet/2026-04-04/1775289773
id: 1702244
processed: 1

raw_data:

{
    "AspNetUserId": 10,
    "CancellationDate": 21,
    "Comments": 2,
    "EmployeeHourId": 20,
    "EndDateTime": 11,
    "EndDirection": 14,
    "EndHorizontalAccuracy": 16,
    "EndLatitude": 12,
    "EndLongitude": 13,
    "EndSpeed": 15,
    "EndVerticalAccuracy": 17,
    "HasNoImages": 22,
    "Id": 0,
    "JobId": 19,
    "OverrideHours": 1,
    "StartAspNetUser_Id": 18,
    "StartDateTime": 3,
    "StartDirection": 6,
    "StartHorizontalAccuracy": 8,
    "StartLatitude": 4,
    "StartLongitude": 5,
    "StartSpeed": 7,
    "StartVerticalAccuracy": 9
}

schema_attributes:

{
    "AspNetUserId": "string",
    "CancellationDate": "string",
    "Comments": "string",
    "EmployeeHourId": "string",
    "EndDateTime": "string",
    "EndDirection": "string",
    "EndHorizontalAccuracy": "string",
    "EndLatitude": "string",
    "EndLongitude": "string",
    "EndSpeed": "string",
    "EndVerticalAccuracy": "string",
    "HasNoImages": "string",
    "Id": "string",
    "JobId": "string",
    "OverrideHours": "string",
    "StartAspNetUser_Id": "string",
    "StartDateTime": "string",
    "StartDirection": "string",
    "StartHorizontalAccuracy": "string",
    "StartLatitude": "string",
    "StartLongitude": "string",
    "StartSpeed": "string",
    "StartVerticalAccuracy": "string"
}

schema_name_id: 1784
schema_scan_id: 161460537
updated: 2026-04-04 03:09:44

Version 1701021

created: 2026-04-03 03:13:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_timerset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_timerset`\n(\n `Id`  string , `OverrideHours`  string , `Comments`  string , `StartDateTime`  string , `StartLatitude`  string , `StartLongitude`  string , `StartDirection`  string , `StartSpeed`  string , `StartHorizontalAccuracy`  string , `StartVerticalAccuracy`  string , `AspNetUserId`  string , `EndDateTime`  string , `EndLatitude`  string , `EndLongitude`  string , `EndDirection`  string , `EndSpeed`  string , `EndHorizontalAccuracy`  string , `EndVerticalAccuracy`  string , `StartAspNetUser_Id`  string , `JobId`  string , `EmployeeHourId`  string , `CancellationDate`  string , `HasNoImages`  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_TimerSet/2026-04-03/1775203540'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_timerset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_TimerSet/2026-04-03/1775203540
id: 1701021
processed: 1

raw_data:

{
    "AspNetUserId": 10,
    "CancellationDate": 21,
    "Comments": 2,
    "EmployeeHourId": 20,
    "EndDateTime": 11,
    "EndDirection": 14,
    "EndHorizontalAccuracy": 16,
    "EndLatitude": 12,
    "EndLongitude": 13,
    "EndSpeed": 15,
    "EndVerticalAccuracy": 17,
    "HasNoImages": 22,
    "Id": 0,
    "JobId": 19,
    "OverrideHours": 1,
    "StartAspNetUser_Id": 18,
    "StartDateTime": 3,
    "StartDirection": 6,
    "StartHorizontalAccuracy": 8,
    "StartLatitude": 4,
    "StartLongitude": 5,
    "StartSpeed": 7,
    "StartVerticalAccuracy": 9
}

schema_attributes:

{
    "AspNetUserId": "string",
    "CancellationDate": "string",
    "Comments": "string",
    "EmployeeHourId": "string",
    "EndDateTime": "string",
    "EndDirection": "string",
    "EndHorizontalAccuracy": "string",
    "EndLatitude": "string",
    "EndLongitude": "string",
    "EndSpeed": "string",
    "EndVerticalAccuracy": "string",
    "HasNoImages": "string",
    "Id": "string",
    "JobId": "string",
    "OverrideHours": "string",
    "StartAspNetUser_Id": "string",
    "StartDateTime": "string",
    "StartDirection": "string",
    "StartHorizontalAccuracy": "string",
    "StartLatitude": "string",
    "StartLongitude": "string",
    "StartSpeed": "string",
    "StartVerticalAccuracy": "string"
}

schema_name_id: 1784
schema_scan_id: 161401996
updated: 2026-04-03 03:13:27

Schema Scans: 15

Last at 2026-04-17 03:10:42

Scan 162167802

duration: 0:00:14.874423

exit_message:

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

id: 162167802

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_TimerSet/2026-04-17/1776413127",
        "key": "raw/molo_moloSV_TimerSet/2026-04-17/1776413127/SV_TimerSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_TimerSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4791519451069928923,
        "service_name": "drive-thru",
        "span_id": 8283792348235954694,
        "trace_id": 11980887173811028887
    }
}

running: False
schema_name_id: 1784
start_time: 2026-04-17 03:10:42
success: True
trace_id: 11980887173811028887

Scan 162112013

duration: 0:00:14.967769

exit_message:

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

id: 162112013

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_TimerSet/2026-04-16/1776326732",
        "key": "raw/molo_moloSV_TimerSet/2026-04-16/1776326732/SV_TimerSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_TimerSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1345180851846668069,
        "service_name": "drive-thru",
        "span_id": 15545621078533037321,
        "trace_id": 5330177108934093371
    }
}

running: False
schema_name_id: 1784
start_time: 2026-04-16 03:13:39
success: True
trace_id: 5330177108934093371

Scan 162056127

duration: 0:00:12.387930

exit_message:

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

id: 162056127

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_TimerSet/2026-04-15/1776240197",
        "key": "raw/molo_moloSV_TimerSet/2026-04-15/1776240197/SV_TimerSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_TimerSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9731803479233188991,
        "service_name": "drive-thru",
        "span_id": 1445739435337249391,
        "trace_id": 2908305151988399160
    }
}

running: False
schema_name_id: 1784
start_time: 2026-04-15 03:10:45
success: True
trace_id: 2908305151988399160

Scan 162000697

duration: 0:00:12.357543

exit_message:

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

id: 162000697

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_TimerSet/2026-04-14/1776154164",
        "key": "raw/molo_moloSV_TimerSet/2026-04-14/1776154164/SV_TimerSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_TimerSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16660757233866533634,
        "service_name": "drive-thru",
        "span_id": 3879520220190701929,
        "trace_id": 16194102513600093101
    }
}

running: False
schema_name_id: 1784
start_time: 2026-04-14 03:12:06
success: True
trace_id: 16194102513600093101

Scan 161942817

duration: 0:00:14.676522

exit_message:

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

id: 161942817

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_TimerSet/2026-04-13/1776067159",
        "key": "raw/molo_moloSV_TimerSet/2026-04-13/1776067159/SV_TimerSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_TimerSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6915518985513678367,
        "service_name": "drive-thru",
        "span_id": 17488730131805704561,
        "trace_id": 5785416473972202162
    }
}

running: False
schema_name_id: 1784
start_time: 2026-04-13 03:07:05
success: True
trace_id: 5785416473972202162

Scan 161893214

duration: 0:00:14.828056

exit_message:

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

id: 161893214

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_TimerSet/2026-04-12/1775980859",
        "key": "raw/molo_moloSV_TimerSet/2026-04-12/1775980859/SV_TimerSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_TimerSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17615962113310762340,
        "service_name": "drive-thru",
        "span_id": 495646854736813408,
        "trace_id": 1647513273988833818
    }
}

running: False
schema_name_id: 1784
start_time: 2026-04-12 03:04:16
success: True
trace_id: 1647513273988833818

Scan 161841362

duration: 0:00:15.392861

exit_message:

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

id: 161841362

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_TimerSet/2026-04-11/1775894627",
        "key": "raw/molo_moloSV_TimerSet/2026-04-11/1775894627/SV_TimerSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_TimerSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15519053746294584711,
        "service_name": "drive-thru",
        "span_id": 13873222595106259557,
        "trace_id": 5494787233257307042
    }
}

running: False
schema_name_id: 1784
start_time: 2026-04-11 03:10:42
success: True
trace_id: 5494787233257307042

Scan 161786013

duration: 0:00:14.970085

exit_message:

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

id: 161786013

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_TimerSet/2026-04-10/1775808388",
        "key": "raw/molo_moloSV_TimerSet/2026-04-10/1775808388/SV_TimerSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_TimerSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1732853991740398073,
        "service_name": "drive-thru",
        "span_id": 11600765490643642660,
        "trace_id": 10567661216442537870
    }
}

running: False
schema_name_id: 1784
start_time: 2026-04-10 03:08:45
success: True
trace_id: 10567661216442537870

Scan 161730407

duration: 0:00:12.311308

exit_message:

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

id: 161730407

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_TimerSet/2026-04-09/1775721717",
        "key": "raw/molo_moloSV_TimerSet/2026-04-09/1775721717/SV_TimerSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_TimerSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15958391419194096688,
        "service_name": "drive-thru",
        "span_id": 6722901303892556447,
        "trace_id": 15384820021833158063
    }
}

running: False
schema_name_id: 1784
start_time: 2026-04-09 03:06:04
success: True
trace_id: 15384820021833158063

Scan 161675549

duration: 0:00:12.292676

exit_message:

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

id: 161675549

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_TimerSet/2026-04-08/1775635548",
        "key": "raw/molo_moloSV_TimerSet/2026-04-08/1775635548/SV_TimerSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_TimerSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9860988835901597902,
        "service_name": "drive-thru",
        "span_id": 17656337413965485932,
        "trace_id": 12001766626271179183
    }
}

running: False
schema_name_id: 1784
start_time: 2026-04-08 03:06:13
success: True
trace_id: 12001766626271179183

Scan 161619325

duration: 0:00:12.439579

exit_message:

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

id: 161619325

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_TimerSet/2026-04-07/1775548710",
        "key": "raw/molo_moloSV_TimerSet/2026-04-07/1775548710/SV_TimerSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_TimerSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18259441415404576821,
        "service_name": "drive-thru",
        "span_id": 9029809323958992248,
        "trace_id": 16439335981700849761
    }
}

running: False
schema_name_id: 1784
start_time: 2026-04-07 03:03:03
success: True
trace_id: 16439335981700849761

Scan 161561810

duration: 0:00:14.741540

exit_message:

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

id: 161561810

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_TimerSet/2026-04-06/1775462660",
        "key": "raw/molo_moloSV_TimerSet/2026-04-06/1775462660/SV_TimerSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_TimerSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1325681923449792003,
        "service_name": "drive-thru",
        "span_id": 14143377832303618619,
        "trace_id": 209579835672107010
    }
}

running: False
schema_name_id: 1784
start_time: 2026-04-06 03:12:21
success: True
trace_id: 209579835672107010

Scan 161514926

duration: 0:00:14.851631

exit_message:

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

id: 161514926

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_TimerSet/2026-04-05/1775376292",
        "key": "raw/molo_moloSV_TimerSet/2026-04-05/1775376292/SV_TimerSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_TimerSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9927788032837255096,
        "service_name": "drive-thru",
        "span_id": 852918842821656269,
        "trace_id": 14759320976790774719
    }
}

running: False
schema_name_id: 1784
start_time: 2026-04-05 03:07:00
success: True
trace_id: 14759320976790774719

Scan 161460537

duration: 0:00:14.848731

exit_message:

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

id: 161460537

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_TimerSet/2026-04-04/1775289773",
        "key": "raw/molo_moloSV_TimerSet/2026-04-04/1775289773/SV_TimerSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_TimerSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2770404539041712665,
        "service_name": "drive-thru",
        "span_id": 2044713914811100253,
        "trace_id": 7968892899461855949
    }
}

running: False
schema_name_id: 1784
start_time: 2026-04-04 03:09:29
success: True
trace_id: 7968892899461855949

Scan 161401996

duration: 0:00:14.863023

exit_message:

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

id: 161401996

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_TimerSet/2026-04-03/1775203540",
        "key": "raw/molo_moloSV_TimerSet/2026-04-03/1775203540/SV_TimerSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_TimerSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13125107872075988540,
        "service_name": "drive-thru",
        "span_id": 14919142559250600704,
        "trace_id": 3576876949731624069
    }
}

running: False
schema_name_id: 1784
start_time: 2026-04-03 03:13:13
success: True
trace_id: 3576876949731624069

Partitions:

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

Schema:

attributes:

{
    "AspNetUserId": "string",
    "CancellationDate": "string",
    "Comments": "string",
    "EmployeeHourId": "string",
    "EndDateTime": "string",
    "EndDirection": "string",
    "EndHorizontalAccuracy": "string",
    "EndLatitude": "string",
    "EndLongitude": "string",
    "EndSpeed": "string",
    "EndVerticalAccuracy": "string",
    "HasNoImages": "string",
    "Id": "string",
    "JobId": "string",
    "OverrideHours": "string",
    "StartAspNetUser_Id": "string",
    "StartDateTime": "string",
    "StartDirection": "string",
    "StartHorizontalAccuracy": "string",
    "StartLatitude": "string",
    "StartLongitude": "string",
    "StartSpeed": "string",
    "StartVerticalAccuracy": "string"
}

created: 2026-04-17 03:10:43

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_timerset`\n(\n `Id`  string , `OverrideHours`  string , `Comments`  string , `StartDateTime`  string , `StartLatitude`  string , `StartLongitude`  string , `StartDirection`  string , `StartSpeed`  string , `StartHorizontalAccuracy`  string , `StartVerticalAccuracy`  string , `AspNetUserId`  string , `EndDateTime`  string , `EndLatitude`  string , `EndLongitude`  string , `EndDirection`  string , `EndSpeed`  string , `EndHorizontalAccuracy`  string , `EndVerticalAccuracy`  string , `StartAspNetUser_Id`  string , `JobId`  string , `EmployeeHourId`  string , `CancellationDate`  string , `HasNoImages`  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_TimerSet/2026-04-17/1776413127'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_timerset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_timerset"
}

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:56",
        "disabled": false,
        "format": "raw",
        "id": 1784,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molosv_timerset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "AspNetUserId": "string",
            "CancellationDate": "string",
            "Comments": "string",
            "EmployeeHourId": "string",
            "EndDateTime": "string",
            "EndDirection": "string",
            "EndHorizontalAccuracy": "string",
            "EndLatitude": "string",
            "EndLongitude": "string",
            "EndSpeed": "string",
            "EndVerticalAccuracy": "string",
            "HasNoImages": "string",
            "Id": "string",
            "JobId": "string",
            "OverrideHours": "string",
            "StartAspNetUser_Id": "string",
            "StartDateTime": "string",
            "StartDirection": "string",
            "StartHorizontalAccuracy": "string",
            "StartLatitude": "string",
            "StartLongitude": "string",
            "StartSpeed": "string",
            "StartVerticalAccuracy": "string"
        },
        "created": "2026-04-17 03:10:43",
        "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_timerset`\n(\n `Id`  string , `OverrideHours`  string , `Comments`  string , `StartDateTime`  string , `StartLatitude`  string , `StartLongitude`  string , `StartDirection`  string , `StartSpeed`  string , `StartHorizontalAccuracy`  string , `StartVerticalAccuracy`  string , `AspNetUserId`  string , `EndDateTime`  string , `EndLatitude`  string , `EndLongitude`  string , `EndDirection`  string , `EndSpeed`  string , `EndHorizontalAccuracy`  string , `EndVerticalAccuracy`  string , `StartAspNetUser_Id`  string , `JobId`  string , `EmployeeHourId`  string , `CancellationDate`  string , `HasNoImages`  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_TimerSet/2026-04-17/1776413127'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_timerset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_timerset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}