Schema Info

Schema Name: sfdl_prod_drivethru.molo_molostripeterminalset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717698

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripeterminalset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripeterminalset`\n(\n `Id`  string , `Name`  string , `AspNetUserId`  string , `CreationDateTime`  string , `AspNetUserId1`  string , `DeletionDateTime`  string , `StripeId`  string , `DeviceSwVersion`  string , `DeviceType`  string , `IpAddress`  string , `SerialNumber`  string , `MarinaLocation_Id`  string , `IsDefault`  string , `HashId`  string , `RegistrationCode`  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_moloStripeTerminalSet/2026-04-17/1776412990'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripeterminalset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeTerminalSet/2026-04-17/1776412990
id: 1717698
processed: 1

raw_data:

{
    "AspNetUserId": 2,
    "AspNetUserId1": 4,
    "CreationDateTime": 3,
    "DeletionDateTime": 5,
    "DeviceSwVersion": 7,
    "DeviceType": 8,
    "HashId": 13,
    "Id": 0,
    "IpAddress": 9,
    "IsDefault": 12,
    "MarinaLocation_Id": 11,
    "Name": 1,
    "RegistrationCode": 14,
    "SerialNumber": 10,
    "StripeId": 6
}

schema_attributes:

{
    "AspNetUserId": "string",
    "AspNetUserId1": "string",
    "CreationDateTime": "string",
    "DeletionDateTime": "string",
    "DeviceSwVersion": "string",
    "DeviceType": "string",
    "HashId": "string",
    "Id": "string",
    "IpAddress": "string",
    "IsDefault": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RegistrationCode": "string",
    "SerialNumber": "string",
    "StripeId": "string"
}

schema_name_id: 1777
schema_scan_id: 162167688
updated: 2026-04-17 03:07:36

Version 1716457

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripeterminalset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripeterminalset`\n(\n `Id`  string , `Name`  string , `AspNetUserId`  string , `CreationDateTime`  string , `AspNetUserId1`  string , `DeletionDateTime`  string , `StripeId`  string , `DeviceSwVersion`  string , `DeviceType`  string , `IpAddress`  string , `SerialNumber`  string , `MarinaLocation_Id`  string , `IsDefault`  string , `HashId`  string , `RegistrationCode`  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_moloStripeTerminalSet/2026-04-16/1776326691'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripeterminalset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeTerminalSet/2026-04-16/1776326691
id: 1716457
processed: 1

raw_data:

{
    "AspNetUserId": 2,
    "AspNetUserId1": 4,
    "CreationDateTime": 3,
    "DeletionDateTime": 5,
    "DeviceSwVersion": 7,
    "DeviceType": 8,
    "HashId": 13,
    "Id": 0,
    "IpAddress": 9,
    "IsDefault": 12,
    "MarinaLocation_Id": 11,
    "Name": 1,
    "RegistrationCode": 14,
    "SerialNumber": 10,
    "StripeId": 6
}

schema_attributes:

{
    "AspNetUserId": "string",
    "AspNetUserId1": "string",
    "CreationDateTime": "string",
    "DeletionDateTime": "string",
    "DeviceSwVersion": "string",
    "DeviceType": "string",
    "HashId": "string",
    "Id": "string",
    "IpAddress": "string",
    "IsDefault": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RegistrationCode": "string",
    "SerialNumber": "string",
    "StripeId": "string"
}

schema_name_id: 1777
schema_scan_id: 162111892
updated: 2026-04-16 03:10:09

Version 1715338

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripeterminalset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripeterminalset`\n(\n `Id`  string , `Name`  string , `AspNetUserId`  string , `CreationDateTime`  string , `AspNetUserId1`  string , `DeletionDateTime`  string , `StripeId`  string , `DeviceSwVersion`  string , `DeviceType`  string , `IpAddress`  string , `SerialNumber`  string , `MarinaLocation_Id`  string , `IsDefault`  string , `HashId`  string , `RegistrationCode`  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_moloStripeTerminalSet/2026-04-15/1776240184'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripeterminalset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeTerminalSet/2026-04-15/1776240184
id: 1715338
processed: 1

raw_data:

{
    "AspNetUserId": 2,
    "AspNetUserId1": 4,
    "CreationDateTime": 3,
    "DeletionDateTime": 5,
    "DeviceSwVersion": 7,
    "DeviceType": 8,
    "HashId": 13,
    "Id": 0,
    "IpAddress": 9,
    "IsDefault": 12,
    "MarinaLocation_Id": 11,
    "Name": 1,
    "RegistrationCode": 14,
    "SerialNumber": 10,
    "StripeId": 6
}

schema_attributes:

{
    "AspNetUserId": "string",
    "AspNetUserId1": "string",
    "CreationDateTime": "string",
    "DeletionDateTime": "string",
    "DeviceSwVersion": "string",
    "DeviceType": "string",
    "HashId": "string",
    "Id": "string",
    "IpAddress": "string",
    "IsDefault": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RegistrationCode": "string",
    "SerialNumber": "string",
    "StripeId": "string"
}

schema_name_id: 1777
schema_scan_id: 162056130
updated: 2026-04-15 03:11:11

Version 1714096

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripeterminalset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripeterminalset`\n(\n `Id`  string , `Name`  string , `AspNetUserId`  string , `CreationDateTime`  string , `AspNetUserId1`  string , `DeletionDateTime`  string , `StripeId`  string , `DeviceSwVersion`  string , `DeviceType`  string , `IpAddress`  string , `SerialNumber`  string , `MarinaLocation_Id`  string , `IsDefault`  string , `HashId`  string , `RegistrationCode`  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_moloStripeTerminalSet/2026-04-14/1776154124'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripeterminalset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeTerminalSet/2026-04-14/1776154124
id: 1714096
processed: 1

raw_data:

{
    "AspNetUserId": 2,
    "AspNetUserId1": 4,
    "CreationDateTime": 3,
    "DeletionDateTime": 5,
    "DeviceSwVersion": 7,
    "DeviceType": 8,
    "HashId": 13,
    "Id": 0,
    "IpAddress": 9,
    "IsDefault": 12,
    "MarinaLocation_Id": 11,
    "Name": 1,
    "RegistrationCode": 14,
    "SerialNumber": 10,
    "StripeId": 6
}

schema_attributes:

{
    "AspNetUserId": "string",
    "AspNetUserId1": "string",
    "CreationDateTime": "string",
    "DeletionDateTime": "string",
    "DeviceSwVersion": "string",
    "DeviceType": "string",
    "HashId": "string",
    "Id": "string",
    "IpAddress": "string",
    "IsDefault": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RegistrationCode": "string",
    "SerialNumber": "string",
    "StripeId": "string"
}

schema_name_id: 1777
schema_scan_id: 162000603
updated: 2026-04-14 03:09:21

Version 1712873

created: 2026-04-13 03:02:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripeterminalset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripeterminalset`\n(\n `Id`  string , `Name`  string , `AspNetUserId`  string , `CreationDateTime`  string , `AspNetUserId1`  string , `DeletionDateTime`  string , `StripeId`  string , `DeviceSwVersion`  string , `DeviceType`  string , `IpAddress`  string , `SerialNumber`  string , `MarinaLocation_Id`  string , `IsDefault`  string , `HashId`  string , `RegistrationCode`  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_moloStripeTerminalSet/2026-04-13/1776067124'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripeterminalset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeTerminalSet/2026-04-13/1776067124
id: 1712873
processed: 1

raw_data:

{
    "AspNetUserId": 2,
    "AspNetUserId1": 4,
    "CreationDateTime": 3,
    "DeletionDateTime": 5,
    "DeviceSwVersion": 7,
    "DeviceType": 8,
    "HashId": 13,
    "Id": 0,
    "IpAddress": 9,
    "IsDefault": 12,
    "MarinaLocation_Id": 11,
    "Name": 1,
    "RegistrationCode": 14,
    "SerialNumber": 10,
    "StripeId": 6
}

schema_attributes:

{
    "AspNetUserId": "string",
    "AspNetUserId1": "string",
    "CreationDateTime": "string",
    "DeletionDateTime": "string",
    "DeviceSwVersion": "string",
    "DeviceType": "string",
    "HashId": "string",
    "Id": "string",
    "IpAddress": "string",
    "IsDefault": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RegistrationCode": "string",
    "SerialNumber": "string",
    "StripeId": "string"
}

schema_name_id: 1777
schema_scan_id: 161942352
updated: 2026-04-13 03:02:36

Version 1711745

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripeterminalset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripeterminalset`\n(\n `Id`  string , `Name`  string , `AspNetUserId`  string , `CreationDateTime`  string , `AspNetUserId1`  string , `DeletionDateTime`  string , `StripeId`  string , `DeviceSwVersion`  string , `DeviceType`  string , `IpAddress`  string , `SerialNumber`  string , `MarinaLocation_Id`  string , `IsDefault`  string , `HashId`  string , `RegistrationCode`  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_moloStripeTerminalSet/2026-04-12/1775980819'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripeterminalset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeTerminalSet/2026-04-12/1775980819
id: 1711745
processed: 1

raw_data:

{
    "AspNetUserId": 2,
    "AspNetUserId1": 4,
    "CreationDateTime": 3,
    "DeletionDateTime": 5,
    "DeviceSwVersion": 7,
    "DeviceType": 8,
    "HashId": 13,
    "Id": 0,
    "IpAddress": 9,
    "IsDefault": 12,
    "MarinaLocation_Id": 11,
    "Name": 1,
    "RegistrationCode": 14,
    "SerialNumber": 10,
    "StripeId": 6
}

schema_attributes:

{
    "AspNetUserId": "string",
    "AspNetUserId1": "string",
    "CreationDateTime": "string",
    "DeletionDateTime": "string",
    "DeviceSwVersion": "string",
    "DeviceType": "string",
    "HashId": "string",
    "Id": "string",
    "IpAddress": "string",
    "IsDefault": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RegistrationCode": "string",
    "SerialNumber": "string",
    "StripeId": "string"
}

schema_name_id: 1777
schema_scan_id: 161893439
updated: 2026-04-12 03:07:52

Version 1710413

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripeterminalset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripeterminalset`\n(\n `Id`  string , `Name`  string , `AspNetUserId`  string , `CreationDateTime`  string , `AspNetUserId1`  string , `DeletionDateTime`  string , `StripeId`  string , `DeviceSwVersion`  string , `DeviceType`  string , `IpAddress`  string , `SerialNumber`  string , `MarinaLocation_Id`  string , `IsDefault`  string , `HashId`  string , `RegistrationCode`  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_moloStripeTerminalSet/2026-04-11/1775894592'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripeterminalset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeTerminalSet/2026-04-11/1775894592
id: 1710413
processed: 1

raw_data:

{
    "AspNetUserId": 2,
    "AspNetUserId1": 4,
    "CreationDateTime": 3,
    "DeletionDateTime": 5,
    "DeviceSwVersion": 7,
    "DeviceType": 8,
    "HashId": 13,
    "Id": 0,
    "IpAddress": 9,
    "IsDefault": 12,
    "MarinaLocation_Id": 11,
    "Name": 1,
    "RegistrationCode": 14,
    "SerialNumber": 10,
    "StripeId": 6
}

schema_attributes:

{
    "AspNetUserId": "string",
    "AspNetUserId1": "string",
    "CreationDateTime": "string",
    "DeletionDateTime": "string",
    "DeviceSwVersion": "string",
    "DeviceType": "string",
    "HashId": "string",
    "Id": "string",
    "IpAddress": "string",
    "IsDefault": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RegistrationCode": "string",
    "SerialNumber": "string",
    "StripeId": "string"
}

schema_name_id: 1777
schema_scan_id: 161841189
updated: 2026-04-11 03:05:16

Version 1709302

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripeterminalset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripeterminalset`\n(\n `Id`  string , `Name`  string , `AspNetUserId`  string , `CreationDateTime`  string , `AspNetUserId1`  string , `DeletionDateTime`  string , `StripeId`  string , `DeviceSwVersion`  string , `DeviceType`  string , `IpAddress`  string , `SerialNumber`  string , `MarinaLocation_Id`  string , `IsDefault`  string , `HashId`  string , `RegistrationCode`  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_moloStripeTerminalSet/2026-04-10/1775808351'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripeterminalset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeTerminalSet/2026-04-10/1775808351
id: 1709302
processed: 1

raw_data:

{
    "AspNetUserId": 2,
    "AspNetUserId1": 4,
    "CreationDateTime": 3,
    "DeletionDateTime": 5,
    "DeviceSwVersion": 7,
    "DeviceType": 8,
    "HashId": 13,
    "Id": 0,
    "IpAddress": 9,
    "IsDefault": 12,
    "MarinaLocation_Id": 11,
    "Name": 1,
    "RegistrationCode": 14,
    "SerialNumber": 10,
    "StripeId": 6
}

schema_attributes:

{
    "AspNetUserId": "string",
    "AspNetUserId1": "string",
    "CreationDateTime": "string",
    "DeletionDateTime": "string",
    "DeviceSwVersion": "string",
    "DeviceType": "string",
    "HashId": "string",
    "Id": "string",
    "IpAddress": "string",
    "IsDefault": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RegistrationCode": "string",
    "SerialNumber": "string",
    "StripeId": "string"
}

schema_name_id: 1777
schema_scan_id: 161785998
updated: 2026-04-10 03:08:28

Version 1708273

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripeterminalset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripeterminalset`\n(\n `Id`  string , `Name`  string , `AspNetUserId`  string , `CreationDateTime`  string , `AspNetUserId1`  string , `DeletionDateTime`  string , `StripeId`  string , `DeviceSwVersion`  string , `DeviceType`  string , `IpAddress`  string , `SerialNumber`  string , `MarinaLocation_Id`  string , `IsDefault`  string , `HashId`  string , `RegistrationCode`  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_moloStripeTerminalSet/2026-04-09/1775721679'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripeterminalset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeTerminalSet/2026-04-09/1775721679
id: 1708273
processed: 1

raw_data:

{
    "AspNetUserId": 2,
    "AspNetUserId1": 4,
    "CreationDateTime": 3,
    "DeletionDateTime": 5,
    "DeviceSwVersion": 7,
    "DeviceType": 8,
    "HashId": 13,
    "Id": 0,
    "IpAddress": 9,
    "IsDefault": 12,
    "MarinaLocation_Id": 11,
    "Name": 1,
    "RegistrationCode": 14,
    "SerialNumber": 10,
    "StripeId": 6
}

schema_attributes:

{
    "AspNetUserId": "string",
    "AspNetUserId1": "string",
    "CreationDateTime": "string",
    "DeletionDateTime": "string",
    "DeviceSwVersion": "string",
    "DeviceType": "string",
    "HashId": "string",
    "Id": "string",
    "IpAddress": "string",
    "IsDefault": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RegistrationCode": "string",
    "SerialNumber": "string",
    "StripeId": "string"
}

schema_name_id: 1777
schema_scan_id: 161730564
updated: 2026-04-09 03:10:22

Version 1706927

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripeterminalset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripeterminalset`\n(\n `Id`  string , `Name`  string , `AspNetUserId`  string , `CreationDateTime`  string , `AspNetUserId1`  string , `DeletionDateTime`  string , `StripeId`  string , `DeviceSwVersion`  string , `DeviceType`  string , `IpAddress`  string , `SerialNumber`  string , `MarinaLocation_Id`  string , `IsDefault`  string , `HashId`  string , `RegistrationCode`  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_moloStripeTerminalSet/2026-04-08/1775635522'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripeterminalset"
]

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

raw_data:

{
    "AspNetUserId": 2,
    "AspNetUserId1": 4,
    "CreationDateTime": 3,
    "DeletionDateTime": 5,
    "DeviceSwVersion": 7,
    "DeviceType": 8,
    "HashId": 13,
    "Id": 0,
    "IpAddress": 9,
    "IsDefault": 12,
    "MarinaLocation_Id": 11,
    "Name": 1,
    "RegistrationCode": 14,
    "SerialNumber": 10,
    "StripeId": 6
}

schema_attributes:

{
    "AspNetUserId": "string",
    "AspNetUserId1": "string",
    "CreationDateTime": "string",
    "DeletionDateTime": "string",
    "DeviceSwVersion": "string",
    "DeviceType": "string",
    "HashId": "string",
    "Id": "string",
    "IpAddress": "string",
    "IsDefault": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RegistrationCode": "string",
    "SerialNumber": "string",
    "StripeId": "string"
}

schema_name_id: 1777
schema_scan_id: 161675563
updated: 2026-04-08 03:06:49

Version 1705831

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripeterminalset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripeterminalset`\n(\n `Id`  string , `Name`  string , `AspNetUserId`  string , `CreationDateTime`  string , `AspNetUserId1`  string , `DeletionDateTime`  string , `StripeId`  string , `DeviceSwVersion`  string , `DeviceType`  string , `IpAddress`  string , `SerialNumber`  string , `MarinaLocation_Id`  string , `IsDefault`  string , `HashId`  string , `RegistrationCode`  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_moloStripeTerminalSet/2026-04-07/1775548678'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripeterminalset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeTerminalSet/2026-04-07/1775548678
id: 1705831
processed: 1

raw_data:

{
    "AspNetUserId": 2,
    "AspNetUserId1": 4,
    "CreationDateTime": 3,
    "DeletionDateTime": 5,
    "DeviceSwVersion": 7,
    "DeviceType": 8,
    "HashId": 13,
    "Id": 0,
    "IpAddress": 9,
    "IsDefault": 12,
    "MarinaLocation_Id": 11,
    "Name": 1,
    "RegistrationCode": 14,
    "SerialNumber": 10,
    "StripeId": 6
}

schema_attributes:

{
    "AspNetUserId": "string",
    "AspNetUserId1": "string",
    "CreationDateTime": "string",
    "DeletionDateTime": "string",
    "DeviceSwVersion": "string",
    "DeviceType": "string",
    "HashId": "string",
    "Id": "string",
    "IpAddress": "string",
    "IsDefault": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RegistrationCode": "string",
    "SerialNumber": "string",
    "StripeId": "string"
}

schema_name_id: 1777
schema_scan_id: 161619262
updated: 2026-04-07 03:02:48

Version 1704615

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripeterminalset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripeterminalset`\n(\n `Id`  string , `Name`  string , `AspNetUserId`  string , `CreationDateTime`  string , `AspNetUserId1`  string , `DeletionDateTime`  string , `StripeId`  string , `DeviceSwVersion`  string , `DeviceType`  string , `IpAddress`  string , `SerialNumber`  string , `MarinaLocation_Id`  string , `IsDefault`  string , `HashId`  string , `RegistrationCode`  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_moloStripeTerminalSet/2026-04-06/1775462626'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripeterminalset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeTerminalSet/2026-04-06/1775462626
id: 1704615
processed: 1

raw_data:

{
    "AspNetUserId": 2,
    "AspNetUserId1": 4,
    "CreationDateTime": 3,
    "DeletionDateTime": 5,
    "DeviceSwVersion": 7,
    "DeviceType": 8,
    "HashId": 13,
    "Id": 0,
    "IpAddress": 9,
    "IsDefault": 12,
    "MarinaLocation_Id": 11,
    "Name": 1,
    "RegistrationCode": 14,
    "SerialNumber": 10,
    "StripeId": 6
}

schema_attributes:

{
    "AspNetUserId": "string",
    "AspNetUserId1": "string",
    "CreationDateTime": "string",
    "DeletionDateTime": "string",
    "DeviceSwVersion": "string",
    "DeviceType": "string",
    "HashId": "string",
    "Id": "string",
    "IpAddress": "string",
    "IsDefault": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RegistrationCode": "string",
    "SerialNumber": "string",
    "StripeId": "string"
}

schema_name_id: 1777
schema_scan_id: 161561762
updated: 2026-04-06 03:10:59

Version 1703335

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripeterminalset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripeterminalset`\n(\n `Id`  string , `Name`  string , `AspNetUserId`  string , `CreationDateTime`  string , `AspNetUserId1`  string , `DeletionDateTime`  string , `StripeId`  string , `DeviceSwVersion`  string , `DeviceType`  string , `IpAddress`  string , `SerialNumber`  string , `MarinaLocation_Id`  string , `IsDefault`  string , `HashId`  string , `RegistrationCode`  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_moloStripeTerminalSet/2026-04-05/1775376254'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripeterminalset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeTerminalSet/2026-04-05/1775376254
id: 1703335
processed: 1

raw_data:

{
    "AspNetUserId": 2,
    "AspNetUserId1": 4,
    "CreationDateTime": 3,
    "DeletionDateTime": 5,
    "DeviceSwVersion": 7,
    "DeviceType": 8,
    "HashId": 13,
    "Id": 0,
    "IpAddress": 9,
    "IsDefault": 12,
    "MarinaLocation_Id": 11,
    "Name": 1,
    "RegistrationCode": 14,
    "SerialNumber": 10,
    "StripeId": 6
}

schema_attributes:

{
    "AspNetUserId": "string",
    "AspNetUserId1": "string",
    "CreationDateTime": "string",
    "DeletionDateTime": "string",
    "DeviceSwVersion": "string",
    "DeviceType": "string",
    "HashId": "string",
    "Id": "string",
    "IpAddress": "string",
    "IsDefault": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RegistrationCode": "string",
    "SerialNumber": "string",
    "StripeId": "string"
}

schema_name_id: 1777
schema_scan_id: 161514916
updated: 2026-04-05 03:06:51

Version 1702216

created: 2026-04-04 03:08:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripeterminalset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripeterminalset`\n(\n `Id`  string , `Name`  string , `AspNetUserId`  string , `CreationDateTime`  string , `AspNetUserId1`  string , `DeletionDateTime`  string , `StripeId`  string , `DeviceSwVersion`  string , `DeviceType`  string , `IpAddress`  string , `SerialNumber`  string , `MarinaLocation_Id`  string , `IsDefault`  string , `HashId`  string , `RegistrationCode`  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_moloStripeTerminalSet/2026-04-04/1775289740'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripeterminalset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeTerminalSet/2026-04-04/1775289740
id: 1702216
processed: 1

raw_data:

{
    "AspNetUserId": 2,
    "AspNetUserId1": 4,
    "CreationDateTime": 3,
    "DeletionDateTime": 5,
    "DeviceSwVersion": 7,
    "DeviceType": 8,
    "HashId": 13,
    "Id": 0,
    "IpAddress": 9,
    "IsDefault": 12,
    "MarinaLocation_Id": 11,
    "Name": 1,
    "RegistrationCode": 14,
    "SerialNumber": 10,
    "StripeId": 6
}

schema_attributes:

{
    "AspNetUserId": "string",
    "AspNetUserId1": "string",
    "CreationDateTime": "string",
    "DeletionDateTime": "string",
    "DeviceSwVersion": "string",
    "DeviceType": "string",
    "HashId": "string",
    "Id": "string",
    "IpAddress": "string",
    "IsDefault": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RegistrationCode": "string",
    "SerialNumber": "string",
    "StripeId": "string"
}

schema_name_id: 1777
schema_scan_id: 161460502
updated: 2026-04-04 03:08:30

Version 1701083

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripeterminalset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripeterminalset`\n(\n `Id`  string , `Name`  string , `AspNetUserId`  string , `CreationDateTime`  string , `AspNetUserId1`  string , `DeletionDateTime`  string , `StripeId`  string , `DeviceSwVersion`  string , `DeviceType`  string , `IpAddress`  string , `SerialNumber`  string , `MarinaLocation_Id`  string , `IsDefault`  string , `HashId`  string , `RegistrationCode`  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_moloStripeTerminalSet/2026-04-03/1775203509'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripeterminalset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeTerminalSet/2026-04-03/1775203509
id: 1701083
processed: 1

raw_data:

{
    "AspNetUserId": 2,
    "AspNetUserId1": 4,
    "CreationDateTime": 3,
    "DeletionDateTime": 5,
    "DeviceSwVersion": 7,
    "DeviceType": 8,
    "HashId": 13,
    "Id": 0,
    "IpAddress": 9,
    "IsDefault": 12,
    "MarinaLocation_Id": 11,
    "Name": 1,
    "RegistrationCode": 14,
    "SerialNumber": 10,
    "StripeId": 6
}

schema_attributes:

{
    "AspNetUserId": "string",
    "AspNetUserId1": "string",
    "CreationDateTime": "string",
    "DeletionDateTime": "string",
    "DeviceSwVersion": "string",
    "DeviceType": "string",
    "HashId": "string",
    "Id": "string",
    "IpAddress": "string",
    "IsDefault": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RegistrationCode": "string",
    "SerialNumber": "string",
    "StripeId": "string"
}

schema_name_id: 1777
schema_scan_id: 161402085
updated: 2026-04-03 03:18:18

Schema Scans: 15

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

Scan 162167688

duration: 0:00:14.444770

exit_message:

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

id: 162167688

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_moloStripeTerminalSet/2026-04-17/1776412990",
        "key": "raw/molo_moloStripeTerminalSet/2026-04-17/1776412990/StripeTerminalSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeTerminalSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15592460432284209722,
        "service_name": "drive-thru",
        "span_id": 2495949934226613207,
        "trace_id": 14492508974676131291
    }
}

running: False
schema_name_id: 1777
start_time: 2026-04-17 03:07:22
success: True
trace_id: 14492508974676131291

Scan 162111892

duration: 0:00:14.543029

exit_message:

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

id: 162111892

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_moloStripeTerminalSet/2026-04-16/1776326691",
        "key": "raw/molo_moloStripeTerminalSet/2026-04-16/1776326691/StripeTerminalSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeTerminalSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 124271207179828744,
        "service_name": "drive-thru",
        "span_id": 18373753874079442502,
        "trace_id": 2924596572562371513
    }
}

running: False
schema_name_id: 1777
start_time: 2026-04-16 03:09:54
success: True
trace_id: 2924596572562371513

Scan 162056130

duration: 0:00:14.624353

exit_message:

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

id: 162056130

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_moloStripeTerminalSet/2026-04-15/1776240184",
        "key": "raw/molo_moloStripeTerminalSet/2026-04-15/1776240184/StripeTerminalSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeTerminalSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3571699141204415357,
        "service_name": "drive-thru",
        "span_id": 13907250946875406991,
        "trace_id": 6234275886770965323
    }
}

running: False
schema_name_id: 1777
start_time: 2026-04-15 03:10:56
success: True
trace_id: 6234275886770965323

Scan 162000603

duration: 0:00:11.931961

exit_message:

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

id: 162000603

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_moloStripeTerminalSet/2026-04-14/1776154124",
        "key": "raw/molo_moloStripeTerminalSet/2026-04-14/1776154124/StripeTerminalSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeTerminalSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3779833213788657355,
        "service_name": "drive-thru",
        "span_id": 6238512336568409093,
        "trace_id": 17331846634123888339
    }
}

running: False
schema_name_id: 1777
start_time: 2026-04-14 03:09:09
success: True
trace_id: 17331846634123888339

Scan 161942352

duration: 0:00:14.552592

exit_message:

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

id: 161942352

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_moloStripeTerminalSet/2026-04-13/1776067124",
        "key": "raw/molo_moloStripeTerminalSet/2026-04-13/1776067124/StripeTerminalSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeTerminalSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1844932714832415392,
        "service_name": "drive-thru",
        "span_id": 1941690848690783531,
        "trace_id": 16686312590976627511
    }
}

running: False
schema_name_id: 1777
start_time: 2026-04-13 03:02:21
success: True
trace_id: 16686312590976627511

Scan 161893439

duration: 0:00:12.016739

exit_message:

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

id: 161893439

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_moloStripeTerminalSet/2026-04-12/1775980819",
        "key": "raw/molo_moloStripeTerminalSet/2026-04-12/1775980819/StripeTerminalSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeTerminalSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 920127453536867307,
        "service_name": "drive-thru",
        "span_id": 14943789689904069723,
        "trace_id": 13002951647260634749
    }
}

running: False
schema_name_id: 1777
start_time: 2026-04-12 03:07:40
success: True
trace_id: 13002951647260634749

Scan 161841189

duration: 0:00:11.992385

exit_message:

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

id: 161841189

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_moloStripeTerminalSet/2026-04-11/1775894592",
        "key": "raw/molo_moloStripeTerminalSet/2026-04-11/1775894592/StripeTerminalSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeTerminalSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2571339798612869642,
        "service_name": "drive-thru",
        "span_id": 4456491689601544150,
        "trace_id": 16270464842807944972
    }
}

running: False
schema_name_id: 1777
start_time: 2026-04-11 03:05:04
success: True
trace_id: 16270464842807944972

Scan 161785998

duration: 0:00:12.262769

exit_message:

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

id: 161785998

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_moloStripeTerminalSet/2026-04-10/1775808351",
        "key": "raw/molo_moloStripeTerminalSet/2026-04-10/1775808351/StripeTerminalSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeTerminalSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11834054271988419550,
        "service_name": "drive-thru",
        "span_id": 14808534720318647110,
        "trace_id": 2915966729853085323
    }
}

running: False
schema_name_id: 1777
start_time: 2026-04-10 03:08:16
success: True
trace_id: 2915966729853085323

Scan 161730564

duration: 0:00:12.249801

exit_message:

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

id: 161730564

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_moloStripeTerminalSet/2026-04-09/1775721679",
        "key": "raw/molo_moloStripeTerminalSet/2026-04-09/1775721679/StripeTerminalSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeTerminalSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8026886967040640586,
        "service_name": "drive-thru",
        "span_id": 714633374696674129,
        "trace_id": 7983025586937555676
    }
}

running: False
schema_name_id: 1777
start_time: 2026-04-09 03:10:09
success: True
trace_id: 7983025586937555676

Scan 161675563

duration: 0:00:12.176255

exit_message:

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

id: 161675563

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_moloStripeTerminalSet/2026-04-08/1775635522",
        "key": "raw/molo_moloStripeTerminalSet/2026-04-08/1775635522/StripeTerminalSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeTerminalSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17404357680182588199,
        "service_name": "drive-thru",
        "span_id": 15098579127559191876,
        "trace_id": 12700613053496608875
    }
}

running: False
schema_name_id: 1777
start_time: 2026-04-08 03:06:37
success: True
trace_id: 12700613053496608875

Scan 161619262

duration: 0:00:14.494629

exit_message:

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

id: 161619262

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_moloStripeTerminalSet/2026-04-07/1775548678",
        "key": "raw/molo_moloStripeTerminalSet/2026-04-07/1775548678/StripeTerminalSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeTerminalSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1730618608029149097,
        "service_name": "drive-thru",
        "span_id": 2204624267957382822,
        "trace_id": 15988912479105695482
    }
}

running: False
schema_name_id: 1777
start_time: 2026-04-07 03:02:34
success: True
trace_id: 15988912479105695482

Scan 161561762

duration: 0:00:12.007110

exit_message:

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

id: 161561762

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_moloStripeTerminalSet/2026-04-06/1775462626",
        "key": "raw/molo_moloStripeTerminalSet/2026-04-06/1775462626/StripeTerminalSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeTerminalSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1982710754401862544,
        "service_name": "drive-thru",
        "span_id": 5203329884074971777,
        "trace_id": 14309610214074102023
    }
}

running: False
schema_name_id: 1777
start_time: 2026-04-06 03:10:47
success: True
trace_id: 14309610214074102023

Scan 161514916

duration: 0:00:14.609923

exit_message:

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

id: 161514916

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_moloStripeTerminalSet/2026-04-05/1775376254",
        "key": "raw/molo_moloStripeTerminalSet/2026-04-05/1775376254/StripeTerminalSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeTerminalSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15392755086070018784,
        "service_name": "drive-thru",
        "span_id": 7441998980813140756,
        "trace_id": 18035876583217777617
    }
}

running: False
schema_name_id: 1777
start_time: 2026-04-05 03:06:36
success: True
trace_id: 18035876583217777617

Scan 161460502

duration: 0:00:14.658275

exit_message:

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

id: 161460502

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_moloStripeTerminalSet/2026-04-04/1775289740",
        "key": "raw/molo_moloStripeTerminalSet/2026-04-04/1775289740/StripeTerminalSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeTerminalSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5250068426215142290,
        "service_name": "drive-thru",
        "span_id": 12911869829427101252,
        "trace_id": 6910548901174612296
    }
}

running: False
schema_name_id: 1777
start_time: 2026-04-04 03:08:15
success: True
trace_id: 6910548901174612296

Scan 161402085

duration: 0:00:11.961904

exit_message:

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

id: 161402085

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_moloStripeTerminalSet/2026-04-03/1775203509",
        "key": "raw/molo_moloStripeTerminalSet/2026-04-03/1775203509/StripeTerminalSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeTerminalSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1167172248411108895,
        "service_name": "drive-thru",
        "span_id": 14442923949329476769,
        "trace_id": 12185424055817798244
    }
}

running: False
schema_name_id: 1777
start_time: 2026-04-03 03:18:06
success: True
trace_id: 12185424055817798244

Partitions:

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

Schema:

attributes:

{
    "AspNetUserId": "string",
    "AspNetUserId1": "string",
    "CreationDateTime": "string",
    "DeletionDateTime": "string",
    "DeviceSwVersion": "string",
    "DeviceType": "string",
    "HashId": "string",
    "Id": "string",
    "IpAddress": "string",
    "IsDefault": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "RegistrationCode": "string",
    "SerialNumber": "string",
    "StripeId": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripeterminalset`\n(\n `Id`  string , `Name`  string , `AspNetUserId`  string , `CreationDateTime`  string , `AspNetUserId1`  string , `DeletionDateTime`  string , `StripeId`  string , `DeviceSwVersion`  string , `DeviceType`  string , `IpAddress`  string , `SerialNumber`  string , `MarinaLocation_Id`  string , `IsDefault`  string , `HashId`  string , `RegistrationCode`  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_moloStripeTerminalSet/2026-04-17/1776412990'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripeterminalset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripeterminalset"
}

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:38",
        "disabled": false,
        "format": "raw",
        "id": 1777,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molostripeterminalset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "AspNetUserId": "string",
            "AspNetUserId1": "string",
            "CreationDateTime": "string",
            "DeletionDateTime": "string",
            "DeviceSwVersion": "string",
            "DeviceType": "string",
            "HashId": "string",
            "Id": "string",
            "IpAddress": "string",
            "IsDefault": "string",
            "MarinaLocation_Id": "string",
            "Name": "string",
            "RegistrationCode": "string",
            "SerialNumber": "string",
            "StripeId": "string"
        },
        "created": "2026-04-17 03:07:23",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripeterminalset`\n(\n `Id`  string , `Name`  string , `AspNetUserId`  string , `CreationDateTime`  string , `AspNetUserId1`  string , `DeletionDateTime`  string , `StripeId`  string , `DeviceSwVersion`  string , `DeviceType`  string , `IpAddress`  string , `SerialNumber`  string , `MarinaLocation_Id`  string , `IsDefault`  string , `HashId`  string , `RegistrationCode`  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_moloStripeTerminalSet/2026-04-17/1776412990'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripeterminalset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripeterminalset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}