Schema Info

Schema Name: sfdl_prod_drivethru.molo_mologltrackingcodeset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717617

created: 2026-04-17 03:03:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_mologltrackingcodeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_mologltrackingcodeset`\n(\n `Id`  string , `Code`  string , `Name`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-17/1776412732'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_mologltrackingcodeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-17/1776412732
id: 1717617
processed: 1

raw_data:

{
    "Code": 1,
    "CreationAspNetUserId": 4,
    "CreationDateTime": 3,
    "DeletionAspNetUserId": 7,
    "DeletionDateTime": 6,
    "Id": 0,
    "MarinaLocation_Id": 8,
    "Name": 2,
    "RecordStatusId": 5
}

schema_attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RecordStatusId": "string"
}

schema_name_id: 1622
schema_scan_id: 162167433
updated: 2026-04-17 03:03:16

Version 1716347

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_mologltrackingcodeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_mologltrackingcodeset`\n(\n `Id`  string , `Code`  string , `Name`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-16/1776326491'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_mologltrackingcodeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-16/1776326491
id: 1716347
processed: 1

raw_data:

{
    "Code": 1,
    "CreationAspNetUserId": 4,
    "CreationDateTime": 3,
    "DeletionAspNetUserId": 7,
    "DeletionDateTime": 6,
    "Id": 0,
    "MarinaLocation_Id": 8,
    "Name": 2,
    "RecordStatusId": 5
}

schema_attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RecordStatusId": "string"
}

schema_name_id: 1622
schema_scan_id: 162111721
updated: 2026-04-16 03:05:24

Version 1715179

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_mologltrackingcodeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_mologltrackingcodeset`\n(\n `Id`  string , `Code`  string , `Name`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-15/1776239961'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_mologltrackingcodeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-15/1776239961
id: 1715179
processed: 1

raw_data:

{
    "Code": 1,
    "CreationAspNetUserId": 4,
    "CreationDateTime": 3,
    "DeletionAspNetUserId": 7,
    "DeletionDateTime": 6,
    "Id": 0,
    "MarinaLocation_Id": 8,
    "Name": 2,
    "RecordStatusId": 5
}

schema_attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RecordStatusId": "string"
}

schema_name_id: 1622
schema_scan_id: 162055848
updated: 2026-04-15 03:03:41

Version 1714038

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_mologltrackingcodeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_mologltrackingcodeset`\n(\n `Id`  string , `Code`  string , `Name`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-14/1776153687'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_mologltrackingcodeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-14/1776153687
id: 1714038
processed: 1

raw_data:

{
    "Code": 1,
    "CreationAspNetUserId": 4,
    "CreationDateTime": 3,
    "DeletionAspNetUserId": 7,
    "DeletionDateTime": 6,
    "Id": 0,
    "MarinaLocation_Id": 8,
    "Name": 2,
    "RecordStatusId": 5
}

schema_attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RecordStatusId": "string"
}

schema_name_id: 1622
schema_scan_id: 162000523
updated: 2026-04-14 03:07:04

Version 1712753

created: 2026-04-13 02:57:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_mologltrackingcodeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_mologltrackingcodeset`\n(\n `Id`  string , `Code`  string , `Name`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-13/1776066880'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_mologltrackingcodeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-13/1776066880
id: 1712753
processed: 1

raw_data:

{
    "Code": 1,
    "CreationAspNetUserId": 4,
    "CreationDateTime": 3,
    "DeletionAspNetUserId": 7,
    "DeletionDateTime": 6,
    "Id": 0,
    "MarinaLocation_Id": 8,
    "Name": 2,
    "RecordStatusId": 5
}

schema_attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RecordStatusId": "string"
}

schema_name_id: 1622
schema_scan_id: 161941559
updated: 2026-04-13 02:57:22

Version 1711554

created: 2026-04-12 02:59:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_mologltrackingcodeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_mologltrackingcodeset`\n(\n `Id`  string , `Code`  string , `Name`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-12/1775980596'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_mologltrackingcodeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-12/1775980596
id: 1711554
processed: 1

raw_data:

{
    "Code": 1,
    "CreationAspNetUserId": 4,
    "CreationDateTime": 3,
    "DeletionAspNetUserId": 7,
    "DeletionDateTime": 6,
    "Id": 0,
    "MarinaLocation_Id": 8,
    "Name": 2,
    "RecordStatusId": 5
}

schema_attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RecordStatusId": "string"
}

schema_name_id: 1622
schema_scan_id: 161892423
updated: 2026-04-12 02:59:29

Version 1710412

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_mologltrackingcodeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_mologltrackingcodeset`\n(\n `Id`  string , `Code`  string , `Name`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-11/1775894356'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_mologltrackingcodeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-11/1775894356
id: 1710412
processed: 1

raw_data:

{
    "Code": 1,
    "CreationAspNetUserId": 4,
    "CreationDateTime": 3,
    "DeletionAspNetUserId": 7,
    "DeletionDateTime": 6,
    "Id": 0,
    "MarinaLocation_Id": 8,
    "Name": 2,
    "RecordStatusId": 5
}

schema_attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RecordStatusId": "string"
}

schema_name_id: 1622
schema_scan_id: 161841186
updated: 2026-04-11 03:05:15

Version 1709202

created: 2026-04-10 03:04:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_mologltrackingcodeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_mologltrackingcodeset`\n(\n `Id`  string , `Code`  string , `Name`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-10/1775808113'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_mologltrackingcodeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-10/1775808113
id: 1709202
processed: 1

raw_data:

{
    "Code": 1,
    "CreationAspNetUserId": 4,
    "CreationDateTime": 3,
    "DeletionAspNetUserId": 7,
    "DeletionDateTime": 6,
    "Id": 0,
    "MarinaLocation_Id": 8,
    "Name": 2,
    "RecordStatusId": 5
}

schema_attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RecordStatusId": "string"
}

schema_name_id: 1622
schema_scan_id: 161785884
updated: 2026-04-10 03:04:42

Version 1708063

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_mologltrackingcodeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_mologltrackingcodeset`\n(\n `Id`  string , `Code`  string , `Name`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-09/1775721450'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_mologltrackingcodeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-09/1775721450
id: 1708063
processed: 1

raw_data:

{
    "Code": 1,
    "CreationAspNetUserId": 4,
    "CreationDateTime": 3,
    "DeletionAspNetUserId": 7,
    "DeletionDateTime": 6,
    "Id": 0,
    "MarinaLocation_Id": 8,
    "Name": 2,
    "RecordStatusId": 5
}

schema_attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RecordStatusId": "string"
}

schema_name_id: 1622
schema_scan_id: 161730013
updated: 2026-04-09 03:01:15

Version 1706926

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_mologltrackingcodeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_mologltrackingcodeset`\n(\n `Id`  string , `Code`  string , `Name`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-08/1775635259'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_mologltrackingcodeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-08/1775635259
id: 1706926
processed: 1

raw_data:

{
    "Code": 1,
    "CreationAspNetUserId": 4,
    "CreationDateTime": 3,
    "DeletionAspNetUserId": 7,
    "DeletionDateTime": 6,
    "Id": 0,
    "MarinaLocation_Id": 8,
    "Name": 2,
    "RecordStatusId": 5
}

schema_attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RecordStatusId": "string"
}

schema_name_id: 1622
schema_scan_id: 161675561
updated: 2026-04-08 03:06:50

Version 1705703

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_mologltrackingcodeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_mologltrackingcodeset`\n(\n `Id`  string , `Code`  string , `Name`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-07/1775548432'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_mologltrackingcodeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-07/1775548432
id: 1705703
processed: 1

raw_data:

{
    "Code": 1,
    "CreationAspNetUserId": 4,
    "CreationDateTime": 3,
    "DeletionAspNetUserId": 7,
    "DeletionDateTime": 6,
    "Id": 0,
    "MarinaLocation_Id": 8,
    "Name": 2,
    "RecordStatusId": 5
}

schema_attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RecordStatusId": "string"
}

schema_name_id: 1622
schema_scan_id: 161618405
updated: 2026-04-07 02:57:17

Version 1704436

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_mologltrackingcodeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_mologltrackingcodeset`\n(\n `Id`  string , `Code`  string , `Name`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-06/1775462399'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_mologltrackingcodeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-06/1775462399
id: 1704436
processed: 1

raw_data:

{
    "Code": 1,
    "CreationAspNetUserId": 4,
    "CreationDateTime": 3,
    "DeletionAspNetUserId": 7,
    "DeletionDateTime": 6,
    "Id": 0,
    "MarinaLocation_Id": 8,
    "Name": 2,
    "RecordStatusId": 5
}

schema_attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RecordStatusId": "string"
}

schema_name_id: 1622
schema_scan_id: 161561456
updated: 2026-04-06 03:03:16

Version 1703245

created: 2026-04-05 03:02:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_mologltrackingcodeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_mologltrackingcodeset`\n(\n `Id`  string , `Code`  string , `Name`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-05/1775376023'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_mologltrackingcodeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-05/1775376023
id: 1703245
processed: 1

raw_data:

{
    "Code": 1,
    "CreationAspNetUserId": 4,
    "CreationDateTime": 3,
    "DeletionAspNetUserId": 7,
    "DeletionDateTime": 6,
    "Id": 0,
    "MarinaLocation_Id": 8,
    "Name": 2,
    "RecordStatusId": 5
}

schema_attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RecordStatusId": "string"
}

schema_name_id: 1622
schema_scan_id: 161514813
updated: 2026-04-05 03:03:06

Version 1702073

created: 2026-04-04 03:01:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_mologltrackingcodeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_mologltrackingcodeset`\n(\n `Id`  string , `Code`  string , `Name`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-04/1775289506'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_mologltrackingcodeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-04/1775289506
id: 1702073
processed: 1

raw_data:

{
    "Code": 1,
    "CreationAspNetUserId": 4,
    "CreationDateTime": 3,
    "DeletionAspNetUserId": 7,
    "DeletionDateTime": 6,
    "Id": 0,
    "MarinaLocation_Id": 8,
    "Name": 2,
    "RecordStatusId": 5
}

schema_attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RecordStatusId": "string"
}

schema_name_id: 1622
schema_scan_id: 161459970
updated: 2026-04-04 03:01:49

Version 1700928

created: 2026-04-03 03:09:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_mologltrackingcodeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_mologltrackingcodeset`\n(\n `Id`  string , `Code`  string , `Name`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-03/1775203278'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_mologltrackingcodeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-03/1775203278
id: 1700928
processed: 1

raw_data:

{
    "Code": 1,
    "CreationAspNetUserId": 4,
    "CreationDateTime": 3,
    "DeletionAspNetUserId": 7,
    "DeletionDateTime": 6,
    "Id": 0,
    "MarinaLocation_Id": 8,
    "Name": 2,
    "RecordStatusId": 5
}

schema_attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RecordStatusId": "string"
}

schema_name_id: 1622
schema_scan_id: 161401882
updated: 2026-04-03 03:09:28

Schema Scans: 15

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

Scan 162167433

duration: 0:00:14.155767

exit_message:

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

id: 162167433

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_moloGLTrackingCodeSet/2026-04-17/1776412732",
        "key": "raw/molo_moloGLTrackingCodeSet/2026-04-17/1776412732/GLTrackingCodeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloGLTrackingCodeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5205453401950197033,
        "service_name": "drive-thru",
        "span_id": 3161965178896225559,
        "trace_id": 7875459363957768040
    }
}

running: False
schema_name_id: 1622
start_time: 2026-04-17 03:03:02
success: True
trace_id: 7875459363957768040

Scan 162111721

duration: 0:00:14.256647

exit_message:

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

id: 162111721

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_moloGLTrackingCodeSet/2026-04-16/1776326491",
        "key": "raw/molo_moloGLTrackingCodeSet/2026-04-16/1776326491/GLTrackingCodeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloGLTrackingCodeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12962461628126930269,
        "service_name": "drive-thru",
        "span_id": 12147235270890047467,
        "trace_id": 18080842423965335799
    }
}

running: False
schema_name_id: 1622
start_time: 2026-04-16 03:05:10
success: True
trace_id: 18080842423965335799

Scan 162055848

duration: 0:00:14.387429

exit_message:

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

id: 162055848

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_moloGLTrackingCodeSet/2026-04-15/1776239961",
        "key": "raw/molo_moloGLTrackingCodeSet/2026-04-15/1776239961/GLTrackingCodeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloGLTrackingCodeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2712981022377875693,
        "service_name": "drive-thru",
        "span_id": 12935421340261384356,
        "trace_id": 835846164098033600
    }
}

running: False
schema_name_id: 1622
start_time: 2026-04-15 03:03:27
success: True
trace_id: 835846164098033600

Scan 162000523

duration: 0:00:11.871411

exit_message:

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

id: 162000523

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_moloGLTrackingCodeSet/2026-04-14/1776153687",
        "key": "raw/molo_moloGLTrackingCodeSet/2026-04-14/1776153687/GLTrackingCodeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloGLTrackingCodeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2601964065923084861,
        "service_name": "drive-thru",
        "span_id": 14298332656397661297,
        "trace_id": 2376191604169195267
    }
}

running: False
schema_name_id: 1622
start_time: 2026-04-14 03:06:52
success: True
trace_id: 2376191604169195267

Scan 161941559

duration: 0:00:14.263780

exit_message:

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

id: 161941559

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_moloGLTrackingCodeSet/2026-04-13/1776066880",
        "key": "raw/molo_moloGLTrackingCodeSet/2026-04-13/1776066880/GLTrackingCodeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloGLTrackingCodeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8891663176009412861,
        "service_name": "drive-thru",
        "span_id": 6487133890251657377,
        "trace_id": 17277918294569619497
    }
}

running: False
schema_name_id: 1622
start_time: 2026-04-13 02:57:08
success: True
trace_id: 17277918294569619497

Scan 161892423

duration: 0:00:14.131782

exit_message:

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

id: 161892423

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_moloGLTrackingCodeSet/2026-04-12/1775980596",
        "key": "raw/molo_moloGLTrackingCodeSet/2026-04-12/1775980596/GLTrackingCodeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloGLTrackingCodeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7253525291188428254,
        "service_name": "drive-thru",
        "span_id": 2468459483475448372,
        "trace_id": 17918551397108177104
    }
}

running: False
schema_name_id: 1622
start_time: 2026-04-12 02:59:15
success: True
trace_id: 17918551397108177104

Scan 161841186

duration: 0:00:11.773395

exit_message:

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

id: 161841186

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_moloGLTrackingCodeSet/2026-04-11/1775894356",
        "key": "raw/molo_moloGLTrackingCodeSet/2026-04-11/1775894356/GLTrackingCodeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloGLTrackingCodeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8697857948118093137,
        "service_name": "drive-thru",
        "span_id": 109317324974039976,
        "trace_id": 14700852329701172323
    }
}

running: False
schema_name_id: 1622
start_time: 2026-04-11 03:05:03
success: True
trace_id: 14700852329701172323

Scan 161785884

duration: 0:00:14.324713

exit_message:

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

id: 161785884

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_moloGLTrackingCodeSet/2026-04-10/1775808113",
        "key": "raw/molo_moloGLTrackingCodeSet/2026-04-10/1775808113/GLTrackingCodeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloGLTrackingCodeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12369624229593715335,
        "service_name": "drive-thru",
        "span_id": 15714428773942274141,
        "trace_id": 1265572331893416849
    }
}

running: False
schema_name_id: 1622
start_time: 2026-04-10 03:04:28
success: True
trace_id: 1265572331893416849

Scan 161730013

duration: 0:00:14.688814

exit_message:

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

id: 161730013

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_moloGLTrackingCodeSet/2026-04-09/1775721450",
        "key": "raw/molo_moloGLTrackingCodeSet/2026-04-09/1775721450/GLTrackingCodeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloGLTrackingCodeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9778112216159253465,
        "service_name": "drive-thru",
        "span_id": 5525652979369887864,
        "trace_id": 5392162077510321184
    }
}

running: False
schema_name_id: 1622
start_time: 2026-04-09 03:01:01
success: True
trace_id: 5392162077510321184

Scan 161675561

duration: 0:00:14.299104

exit_message:

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

id: 161675561

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_moloGLTrackingCodeSet/2026-04-08/1775635259",
        "key": "raw/molo_moloGLTrackingCodeSet/2026-04-08/1775635259/GLTrackingCodeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloGLTrackingCodeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10194311782354179266,
        "service_name": "drive-thru",
        "span_id": 7791834824898005869,
        "trace_id": 7065006121509833301
    }
}

running: False
schema_name_id: 1622
start_time: 2026-04-08 03:06:36
success: True
trace_id: 7065006121509833301

Scan 161618405

duration: 0:00:14.436757

exit_message:

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

id: 161618405

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_moloGLTrackingCodeSet/2026-04-07/1775548432",
        "key": "raw/molo_moloGLTrackingCodeSet/2026-04-07/1775548432/GLTrackingCodeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloGLTrackingCodeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17349217840265211280,
        "service_name": "drive-thru",
        "span_id": 2878095109625566682,
        "trace_id": 3195760163765183493
    }
}

running: False
schema_name_id: 1622
start_time: 2026-04-07 02:57:02
success: True
trace_id: 3195760163765183493

Scan 161561456

duration: 0:00:11.835552

exit_message:

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

id: 161561456

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_moloGLTrackingCodeSet/2026-04-06/1775462399",
        "key": "raw/molo_moloGLTrackingCodeSet/2026-04-06/1775462399/GLTrackingCodeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloGLTrackingCodeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11691559785461843569,
        "service_name": "drive-thru",
        "span_id": 1556400849976498939,
        "trace_id": 6071976276373540785
    }
}

running: False
schema_name_id: 1622
start_time: 2026-04-06 03:03:04
success: True
trace_id: 6071976276373540785

Scan 161514813

duration: 0:00:14.243565

exit_message:

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

id: 161514813

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_moloGLTrackingCodeSet/2026-04-05/1775376023",
        "key": "raw/molo_moloGLTrackingCodeSet/2026-04-05/1775376023/GLTrackingCodeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloGLTrackingCodeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17966942872221500453,
        "service_name": "drive-thru",
        "span_id": 16061179030770449390,
        "trace_id": 9341787676273375604
    }
}

running: False
schema_name_id: 1622
start_time: 2026-04-05 03:02:52
success: True
trace_id: 9341787676273375604

Scan 161459970

duration: 0:00:14.333209

exit_message:

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

id: 161459970

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_moloGLTrackingCodeSet/2026-04-04/1775289506",
        "key": "raw/molo_moloGLTrackingCodeSet/2026-04-04/1775289506/GLTrackingCodeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloGLTrackingCodeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3197480845613978028,
        "service_name": "drive-thru",
        "span_id": 7098692040101694744,
        "trace_id": 6287909512737355598
    }
}

running: False
schema_name_id: 1622
start_time: 2026-04-04 03:01:34
success: True
trace_id: 6287909512737355598

Scan 161401882

duration: 0:00:11.735284

exit_message:

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

id: 161401882

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_moloGLTrackingCodeSet/2026-04-03/1775203278",
        "key": "raw/molo_moloGLTrackingCodeSet/2026-04-03/1775203278/GLTrackingCodeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloGLTrackingCodeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3805791177540074378,
        "service_name": "drive-thru",
        "span_id": 9380692998503759843,
        "trace_id": 17368897590484282159
    }
}

running: False
schema_name_id: 1622
start_time: 2026-04-03 03:09:17
success: True
trace_id: 17368897590484282159

Partitions:

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

Schema:

attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RecordStatusId": "string"
}

created: 2026-04-17 03:03:02

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_mologltrackingcodeset`\n(\n `Id`  string , `Code`  string , `Name`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-17/1776412732'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_mologltrackingcodeset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_mologltrackingcodeset"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-10-17 01:56:06",
        "disabled": false,
        "format": "raw",
        "id": 1622,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_mologltrackingcodeset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Code": "string",
            "CreationAspNetUserId": "string",
            "CreationDateTime": "string",
            "DeletionAspNetUserId": "string",
            "DeletionDateTime": "string",
            "Id": "string",
            "MarinaLocation_Id": "string",
            "Name": "string",
            "RecordStatusId": "string"
        },
        "created": "2026-04-17 03:03:02",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_mologltrackingcodeset`\n(\n `Id`  string , `Code`  string , `Name`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocation_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloGLTrackingCodeSet/2026-04-17/1776412732'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_mologltrackingcodeset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_mologltrackingcodeset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}