Schema Info

Schema Name: sfdl_prod_drivethru.molo_molopiers

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717676

created: 2026-04-17 03:06:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopiers`\n(\n `Id`  string , `Name`  string , `MarinaLocationId`  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_moloPiers/2026-04-17/1776412811'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopiers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPiers/2026-04-17/1776412811
id: 1717676
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocationId": 2,
    "Name": 1
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string"
}

schema_name_id: 1752
schema_scan_id: 162167659
updated: 2026-04-17 03:06:39

Version 1716364

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopiers`\n(\n `Id`  string , `Name`  string , `MarinaLocationId`  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_moloPiers/2026-04-16/1776326567'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopiers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPiers/2026-04-16/1776326567
id: 1716364
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocationId": 2,
    "Name": 1
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string"
}

schema_name_id: 1752
schema_scan_id: 162111756
updated: 2026-04-16 03:06:16

Version 1715281

created: 2026-04-15 03:08:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopiers`\n(\n `Id`  string , `Name`  string , `MarinaLocationId`  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_moloPiers/2026-04-15/1776240036'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopiers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPiers/2026-04-15/1776240036
id: 1715281
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocationId": 2,
    "Name": 1
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string"
}

schema_name_id: 1752
schema_scan_id: 162056033
updated: 2026-04-15 03:08:17

Version 1714080

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopiers`\n(\n `Id`  string , `Name`  string , `MarinaLocationId`  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_moloPiers/2026-04-14/1776153766'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopiers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPiers/2026-04-14/1776153766
id: 1714080
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocationId": 2,
    "Name": 1
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string"
}

schema_name_id: 1752
schema_scan_id: 162000583
updated: 2026-04-14 03:08:48

Version 1712810

created: 2026-04-13 02:59:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopiers`\n(\n `Id`  string , `Name`  string , `MarinaLocationId`  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_moloPiers/2026-04-13/1776066959'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopiers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPiers/2026-04-13/1776066959
id: 1712810
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocationId": 2,
    "Name": 1
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string"
}

schema_name_id: 1752
schema_scan_id: 161941771
updated: 2026-04-13 02:59:45

Version 1711629

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopiers`\n(\n `Id`  string , `Name`  string , `MarinaLocationId`  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_moloPiers/2026-04-12/1775980673'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopiers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPiers/2026-04-12/1775980673
id: 1711629
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocationId": 2,
    "Name": 1
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string"
}

schema_name_id: 1752
schema_scan_id: 161892800
updated: 2026-04-12 03:02:01

Version 1710497

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopiers`\n(\n `Id`  string , `Name`  string , `MarinaLocationId`  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_moloPiers/2026-04-11/1775894433'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopiers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPiers/2026-04-11/1775894433
id: 1710497
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocationId": 2,
    "Name": 1
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string"
}

schema_name_id: 1752
schema_scan_id: 161841286
updated: 2026-04-11 03:08:28

Version 1709217

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopiers`\n(\n `Id`  string , `Name`  string , `MarinaLocationId`  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_moloPiers/2026-04-10/1775808191'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopiers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPiers/2026-04-10/1775808191
id: 1709217
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocationId": 2,
    "Name": 1
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string"
}

schema_name_id: 1752
schema_scan_id: 161785899
updated: 2026-04-10 03:05:16

Version 1708159

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopiers`\n(\n `Id`  string , `Name`  string , `MarinaLocationId`  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_moloPiers/2026-04-09/1775721529'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopiers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPiers/2026-04-09/1775721529
id: 1708159
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocationId": 2,
    "Name": 1
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string"
}

schema_name_id: 1752
schema_scan_id: 161730360
updated: 2026-04-09 03:05:14

Version 1706861

created: 2026-04-08 03:03:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopiers`\n(\n `Id`  string , `Name`  string , `MarinaLocationId`  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_moloPiers/2026-04-08/1775635358'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopiers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPiers/2026-04-08/1775635358
id: 1706861
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocationId": 2,
    "Name": 1
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string"
}

schema_name_id: 1752
schema_scan_id: 161675441
updated: 2026-04-08 03:03:53

Version 1705727

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopiers`\n(\n `Id`  string , `Name`  string , `MarinaLocationId`  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_moloPiers/2026-04-07/1775548508'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopiers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPiers/2026-04-07/1775548508
id: 1705727
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocationId": 2,
    "Name": 1
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string"
}

schema_name_id: 1752
schema_scan_id: 161618441
updated: 2026-04-07 02:58:11

Version 1704447

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopiers`\n(\n `Id`  string , `Name`  string , `MarinaLocationId`  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_moloPiers/2026-04-06/1775462474'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopiers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPiers/2026-04-06/1775462474
id: 1704447
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocationId": 2,
    "Name": 1
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string"
}

schema_name_id: 1752
schema_scan_id: 161561501
updated: 2026-04-06 03:03:50

Version 1703256

created: 2026-04-05 03:03:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopiers`\n(\n `Id`  string , `Name`  string , `MarinaLocationId`  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_moloPiers/2026-04-05/1775376101'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopiers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPiers/2026-04-05/1775376101
id: 1703256
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocationId": 2,
    "Name": 1
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string"
}

schema_name_id: 1752
schema_scan_id: 161514828
updated: 2026-04-05 03:03:30

Version 1702127

created: 2026-04-04 03:03:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopiers`\n(\n `Id`  string , `Name`  string , `MarinaLocationId`  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_moloPiers/2026-04-04/1775289583'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopiers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPiers/2026-04-04/1775289583
id: 1702127
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocationId": 2,
    "Name": 1
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string"
}

schema_name_id: 1752
schema_scan_id: 161460299
updated: 2026-04-04 03:04:09

Version 1701061

created: 2026-04-03 03:15:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopiers`\n(\n `Id`  string , `Name`  string , `MarinaLocationId`  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_moloPiers/2026-04-03/1775203356'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopiers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPiers/2026-04-03/1775203356
id: 1701061
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocationId": 2,
    "Name": 1
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string"
}

schema_name_id: 1752
schema_scan_id: 161402052
updated: 2026-04-03 03:15:42

Schema Scans: 15

Last at 2026-04-17 03:06:25

Scan 162167659

duration: 0:00:14.167191

exit_message:

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

id: 162167659

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_moloPiers/2026-04-17/1776412811",
        "key": "raw/molo_moloPiers/2026-04-17/1776412811/Piers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2794917546873305755,
        "service_name": "drive-thru",
        "span_id": 6674909611738620376,
        "trace_id": 2158960434551829129
    }
}

running: False
schema_name_id: 1752
start_time: 2026-04-17 03:06:25
success: True
trace_id: 2158960434551829129

Scan 162111756

duration: 0:00:14.170261

exit_message:

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

id: 162111756

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_moloPiers/2026-04-16/1776326567",
        "key": "raw/molo_moloPiers/2026-04-16/1776326567/Piers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5380280193363113698,
        "service_name": "drive-thru",
        "span_id": 2591757966001111766,
        "trace_id": 15039789615147446951
    }
}

running: False
schema_name_id: 1752
start_time: 2026-04-16 03:06:02
success: True
trace_id: 15039789615147446951

Scan 162056033

duration: 0:00:14.294501

exit_message:

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

id: 162056033

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_moloPiers/2026-04-15/1776240036",
        "key": "raw/molo_moloPiers/2026-04-15/1776240036/Piers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16061139849004383739,
        "service_name": "drive-thru",
        "span_id": 4460864197510362108,
        "trace_id": 2997397917181883120
    }
}

running: False
schema_name_id: 1752
start_time: 2026-04-15 03:08:03
success: True
trace_id: 2997397917181883120

Scan 162000583

duration: 0:00:14.120584

exit_message:

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

id: 162000583

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_moloPiers/2026-04-14/1776153766",
        "key": "raw/molo_moloPiers/2026-04-14/1776153766/Piers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9764923484516532453,
        "service_name": "drive-thru",
        "span_id": 17665660943557358845,
        "trace_id": 515359678613936231
    }
}

running: False
schema_name_id: 1752
start_time: 2026-04-14 03:08:34
success: True
trace_id: 515359678613936231

Scan 161941771

duration: 0:00:14.091181

exit_message:

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

id: 161941771

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_moloPiers/2026-04-13/1776066959",
        "key": "raw/molo_moloPiers/2026-04-13/1776066959/Piers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15496509675948699085,
        "service_name": "drive-thru",
        "span_id": 10499913455008137179,
        "trace_id": 18290969626359584524
    }
}

running: False
schema_name_id: 1752
start_time: 2026-04-13 02:59:31
success: True
trace_id: 18290969626359584524

Scan 161892800

duration: 0:00:11.634987

exit_message:

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

id: 161892800

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_moloPiers/2026-04-12/1775980673",
        "key": "raw/molo_moloPiers/2026-04-12/1775980673/Piers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16985754284150533087,
        "service_name": "drive-thru",
        "span_id": 5936189133234171290,
        "trace_id": 8986169537415926065
    }
}

running: False
schema_name_id: 1752
start_time: 2026-04-12 03:01:49
success: True
trace_id: 8986169537415926065

Scan 161841286

duration: 0:00:14.130188

exit_message:

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

id: 161841286

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_moloPiers/2026-04-11/1775894433",
        "key": "raw/molo_moloPiers/2026-04-11/1775894433/Piers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5673654766665254169,
        "service_name": "drive-thru",
        "span_id": 1169299264963133191,
        "trace_id": 4908968863833025536
    }
}

running: False
schema_name_id: 1752
start_time: 2026-04-11 03:08:14
success: True
trace_id: 4908968863833025536

Scan 161785899

duration: 0:00:11.640442

exit_message:

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

id: 161785899

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_moloPiers/2026-04-10/1775808191",
        "key": "raw/molo_moloPiers/2026-04-10/1775808191/Piers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17287702665125652145,
        "service_name": "drive-thru",
        "span_id": 11571967528536335176,
        "trace_id": 1591057058807014924
    }
}

running: False
schema_name_id: 1752
start_time: 2026-04-10 03:05:04
success: True
trace_id: 1591057058807014924

Scan 161730360

duration: 0:00:11.675023

exit_message:

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

id: 161730360

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_moloPiers/2026-04-09/1775721529",
        "key": "raw/molo_moloPiers/2026-04-09/1775721529/Piers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13468360933076973534,
        "service_name": "drive-thru",
        "span_id": 15308714653714777823,
        "trace_id": 3223374869194467254
    }
}

running: False
schema_name_id: 1752
start_time: 2026-04-09 03:05:03
success: True
trace_id: 3223374869194467254

Scan 161675441

duration: 0:00:11.583561

exit_message:

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

id: 161675441

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_moloPiers/2026-04-08/1775635358",
        "key": "raw/molo_moloPiers/2026-04-08/1775635358/Piers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16063953781965929025,
        "service_name": "drive-thru",
        "span_id": 17103824840959729983,
        "trace_id": 5492928042407199263
    }
}

running: False
schema_name_id: 1752
start_time: 2026-04-08 03:03:41
success: True
trace_id: 5492928042407199263

Scan 161618441

duration: 0:00:14.101678

exit_message:

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

id: 161618441

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_moloPiers/2026-04-07/1775548508",
        "key": "raw/molo_moloPiers/2026-04-07/1775548508/Piers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5517223742167103516,
        "service_name": "drive-thru",
        "span_id": 2302665809036559286,
        "trace_id": 5890083038354781517
    }
}

running: False
schema_name_id: 1752
start_time: 2026-04-07 02:57:57
success: True
trace_id: 5890083038354781517

Scan 161561501

duration: 0:00:11.467103

exit_message:

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

id: 161561501

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_moloPiers/2026-04-06/1775462474",
        "key": "raw/molo_moloPiers/2026-04-06/1775462474/Piers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13344652591589273655,
        "service_name": "drive-thru",
        "span_id": 1973003225840819452,
        "trace_id": 4494306603761950031
    }
}

running: False
schema_name_id: 1752
start_time: 2026-04-06 03:03:39
success: True
trace_id: 4494306603761950031

Scan 161514828

duration: 0:00:11.485471

exit_message:

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

id: 161514828

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_moloPiers/2026-04-05/1775376101",
        "key": "raw/molo_moloPiers/2026-04-05/1775376101/Piers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17338853036000974072,
        "service_name": "drive-thru",
        "span_id": 8292566242646924590,
        "trace_id": 2110819356522795778
    }
}

running: False
schema_name_id: 1752
start_time: 2026-04-05 03:03:18
success: True
trace_id: 2110819356522795778

Scan 161460299

duration: 0:00:11.594395

exit_message:

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

id: 161460299

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_moloPiers/2026-04-04/1775289583",
        "key": "raw/molo_moloPiers/2026-04-04/1775289583/Piers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3527519888384618116,
        "service_name": "drive-thru",
        "span_id": 12050857879804190143,
        "trace_id": 1227025865167740071
    }
}

running: False
schema_name_id: 1752
start_time: 2026-04-04 03:03:57
success: True
trace_id: 1227025865167740071

Scan 161402052

duration: 0:00:11.571307

exit_message:

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

id: 161402052

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_moloPiers/2026-04-03/1775203356",
        "key": "raw/molo_moloPiers/2026-04-03/1775203356/Piers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2196292231959667047,
        "service_name": "drive-thru",
        "span_id": 10437286587065216469,
        "trace_id": 13899369936066833237
    }
}

running: False
schema_name_id: 1752
start_time: 2026-04-03 03:15:31
success: True
trace_id: 13899369936066833237

Partitions:

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

Schema:

attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string"
}

created: 2026-04-17 03:06:25

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopiers`\n(\n `Id`  string , `Name`  string , `MarinaLocationId`  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_moloPiers/2026-04-17/1776412811'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopiers`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopiers"
}

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:00:40",
        "disabled": false,
        "format": "raw",
        "id": 1752,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molopiers"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Id": "string",
            "MarinaLocationId": "string",
            "Name": "string"
        },
        "created": "2026-04-17 03:06:25",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopiers`\n(\n `Id`  string , `Name`  string , `MarinaLocationId`  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_moloPiers/2026-04-17/1776412811'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopiers`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopiers"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}