Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloslippedestal

created: 2023-10-17 01:59:22
disabled: False
format: raw
id: 1713
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717662

created: 2026-04-17 03:05:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslippedestal`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslippedestal`\n(\n `Slips_Id`  string , `Pedestals_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_moloSlipPedestal/2026-04-17/1776412850'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslippedestal"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPedestal/2026-04-17/1776412850
id: 1717662
processed: 1

raw_data:

{
    "Pedestals_Id": 1,
    "Slips_Id": 0
}

schema_attributes:

{
    "Pedestals_Id": "string",
    "Slips_Id": "string"
}

schema_name_id: 1713
schema_scan_id: 162167637
updated: 2026-04-17 03:05:58

Version 1716513

created: 2026-04-16 03:12:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslippedestal`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslippedestal`\n(\n `Slips_Id`  string , `Pedestals_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_moloSlipPedestal/2026-04-16/1776326603'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslippedestal"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPedestal/2026-04-16/1776326603
id: 1716513
processed: 1

raw_data:

{
    "Pedestals_Id": 1,
    "Slips_Id": 0
}

schema_attributes:

{
    "Pedestals_Id": "string",
    "Slips_Id": "string"
}

schema_name_id: 1713
schema_scan_id: 162111958
updated: 2026-04-16 03:12:18

Version 1715270

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslippedestal`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslippedestal`\n(\n `Slips_Id`  string , `Pedestals_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_moloSlipPedestal/2026-04-15/1776240073'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslippedestal"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPedestal/2026-04-15/1776240073
id: 1715270
processed: 1

raw_data:

{
    "Pedestals_Id": 1,
    "Slips_Id": 0
}

schema_attributes:

{
    "Pedestals_Id": "string",
    "Slips_Id": "string"
}

schema_name_id: 1713
schema_scan_id: 162056015
updated: 2026-04-15 03:07:49

Version 1714104

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslippedestal`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslippedestal`\n(\n `Slips_Id`  string , `Pedestals_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_moloSlipPedestal/2026-04-14/1776153838'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslippedestal"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPedestal/2026-04-14/1776153838
id: 1714104
processed: 1

raw_data:

{
    "Pedestals_Id": 1,
    "Slips_Id": 0
}

schema_attributes:

{
    "Pedestals_Id": "string",
    "Slips_Id": "string"
}

schema_name_id: 1713
schema_scan_id: 162000617
updated: 2026-04-14 03:09:42

Version 1712868

created: 2026-04-13 03:01:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslippedestal`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslippedestal`\n(\n `Slips_Id`  string , `Pedestals_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_moloSlipPedestal/2026-04-13/1776066998'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslippedestal"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPedestal/2026-04-13/1776066998
id: 1712868
processed: 1

raw_data:

{
    "Pedestals_Id": 1,
    "Slips_Id": 0
}

schema_attributes:

{
    "Pedestals_Id": "string",
    "Slips_Id": "string"
}

schema_name_id: 1713
schema_scan_id: 161942020
updated: 2026-04-13 03:01:26

Version 1711638

created: 2026-04-12 03:02:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslippedestal`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslippedestal`\n(\n `Slips_Id`  string , `Pedestals_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_moloSlipPedestal/2026-04-12/1775980709'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslippedestal"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPedestal/2026-04-12/1775980709
id: 1711638
processed: 1

raw_data:

{
    "Pedestals_Id": 1,
    "Slips_Id": 0
}

schema_attributes:

{
    "Pedestals_Id": "string",
    "Slips_Id": "string"
}

schema_name_id: 1713
schema_scan_id: 161892831
updated: 2026-04-12 03:02:21

Version 1710377

created: 2026-04-11 03:03:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslippedestal`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslippedestal`\n(\n `Slips_Id`  string , `Pedestals_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_moloSlipPedestal/2026-04-11/1775894476'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslippedestal"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPedestal/2026-04-11/1775894476
id: 1710377
processed: 1

raw_data:

{
    "Pedestals_Id": 1,
    "Slips_Id": 0
}

schema_attributes:

{
    "Pedestals_Id": "string",
    "Slips_Id": "string"
}

schema_name_id: 1713
schema_scan_id: 161841121
updated: 2026-04-11 03:03:45

Version 1709397

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslippedestal`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslippedestal`\n(\n `Slips_Id`  string , `Pedestals_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_moloSlipPedestal/2026-04-10/1775808235'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslippedestal"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPedestal/2026-04-10/1775808235
id: 1709397
processed: 1

raw_data:

{
    "Pedestals_Id": 1,
    "Slips_Id": 0
}

schema_attributes:

{
    "Pedestals_Id": "string",
    "Slips_Id": "string"
}

schema_name_id: 1713
schema_scan_id: 161786099
updated: 2026-04-10 03:12:10

Version 1708111

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslippedestal`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslippedestal`\n(\n `Slips_Id`  string , `Pedestals_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_moloSlipPedestal/2026-04-09/1775721566'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslippedestal"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPedestal/2026-04-09/1775721566
id: 1708111
processed: 1

raw_data:

{
    "Pedestals_Id": 1,
    "Slips_Id": 0
}

schema_attributes:

{
    "Pedestals_Id": "string",
    "Slips_Id": "string"
}

schema_name_id: 1713
schema_scan_id: 161730211
updated: 2026-04-09 03:02:58

Version 1707014

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslippedestal`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslippedestal`\n(\n `Slips_Id`  string , `Pedestals_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_moloSlipPedestal/2026-04-08/1775635395'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslippedestal"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPedestal/2026-04-08/1775635395
id: 1707014
processed: 1

raw_data:

{
    "Pedestals_Id": 1,
    "Slips_Id": 0
}

schema_attributes:

{
    "Pedestals_Id": "string",
    "Slips_Id": "string"
}

schema_name_id: 1713
schema_scan_id: 161675679
updated: 2026-04-08 03:10:13

Version 1705781

created: 2026-04-07 02:59:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslippedestal`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslippedestal`\n(\n `Slips_Id`  string , `Pedestals_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_moloSlipPedestal/2026-04-07/1775548552'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslippedestal"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPedestal/2026-04-07/1775548552
id: 1705781
processed: 1

raw_data:

{
    "Pedestals_Id": 1,
    "Slips_Id": 0
}

schema_attributes:

{
    "Pedestals_Id": "string",
    "Slips_Id": "string"
}

schema_name_id: 1713
schema_scan_id: 161618694
updated: 2026-04-07 03:00:09

Version 1704625

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslippedestal`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslippedestal`\n(\n `Slips_Id`  string , `Pedestals_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_moloSlipPedestal/2026-04-06/1775462511'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslippedestal"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPedestal/2026-04-06/1775462511
id: 1704625
processed: 1

raw_data:

{
    "Pedestals_Id": 1,
    "Slips_Id": 0
}

schema_attributes:

{
    "Pedestals_Id": "string",
    "Slips_Id": "string"
}

schema_name_id: 1713
schema_scan_id: 161561774
updated: 2026-04-06 03:11:20

Version 1703352

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslippedestal`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslippedestal`\n(\n `Slips_Id`  string , `Pedestals_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_moloSlipPedestal/2026-04-05/1775376138'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslippedestal"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPedestal/2026-04-05/1775376138
id: 1703352
processed: 1

raw_data:

{
    "Pedestals_Id": 1,
    "Slips_Id": 0
}

schema_attributes:

{
    "Pedestals_Id": "string",
    "Slips_Id": "string"
}

schema_name_id: 1713
schema_scan_id: 161514934
updated: 2026-04-05 03:07:30

Version 1702222

created: 2026-04-04 03:08:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslippedestal`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslippedestal`\n(\n `Slips_Id`  string , `Pedestals_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_moloSlipPedestal/2026-04-04/1775289620'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslippedestal"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPedestal/2026-04-04/1775289620
id: 1702222
processed: 1

raw_data:

{
    "Pedestals_Id": 1,
    "Slips_Id": 0
}

schema_attributes:

{
    "Pedestals_Id": "string",
    "Slips_Id": "string"
}

schema_name_id: 1713
schema_scan_id: 161460508
updated: 2026-04-04 03:08:43

Version 1700954

created: 2026-04-03 03:10:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslippedestal`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslippedestal`\n(\n `Slips_Id`  string , `Pedestals_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_moloSlipPedestal/2026-04-03/1775203393'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslippedestal"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPedestal/2026-04-03/1775203393
id: 1700954
processed: 1

raw_data:

{
    "Pedestals_Id": 1,
    "Slips_Id": 0
}

schema_attributes:

{
    "Pedestals_Id": "string",
    "Slips_Id": "string"
}

schema_name_id: 1713
schema_scan_id: 161401913
updated: 2026-04-03 03:10:32

Schema Scans: 15

Last at 2026-04-17 03:05:46

Scan 162167637

duration: 0:00:11.624433

exit_message:

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

id: 162167637

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_moloSlipPedestal/2026-04-17/1776412850",
        "key": "raw/molo_moloSlipPedestal/2026-04-17/1776412850/SlipPedestal.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipPedestal",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15762063600386993043,
        "service_name": "drive-thru",
        "span_id": 11710212072160315375,
        "trace_id": 8333978297704437706
    }
}

running: False
schema_name_id: 1713
start_time: 2026-04-17 03:05:46
success: True
trace_id: 8333978297704437706

Scan 162111958

duration: 0:00:14.236382

exit_message:

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

id: 162111958

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_moloSlipPedestal/2026-04-16/1776326603",
        "key": "raw/molo_moloSlipPedestal/2026-04-16/1776326603/SlipPedestal.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipPedestal",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7704219190709590063,
        "service_name": "drive-thru",
        "span_id": 16704495430662851179,
        "trace_id": 14470322818610773070
    }
}

running: False
schema_name_id: 1713
start_time: 2026-04-16 03:12:04
success: True
trace_id: 14470322818610773070

Scan 162056015

duration: 0:00:14.199527

exit_message:

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

id: 162056015

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_moloSlipPedestal/2026-04-15/1776240073",
        "key": "raw/molo_moloSlipPedestal/2026-04-15/1776240073/SlipPedestal.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipPedestal",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9444031683070621021,
        "service_name": "drive-thru",
        "span_id": 2218021612830146723,
        "trace_id": 7481496085098383683
    }
}

running: False
schema_name_id: 1713
start_time: 2026-04-15 03:07:35
success: True
trace_id: 7481496085098383683

Scan 162000617

duration: 0:00:14.200662

exit_message:

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

id: 162000617

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_moloSlipPedestal/2026-04-14/1776153838",
        "key": "raw/molo_moloSlipPedestal/2026-04-14/1776153838/SlipPedestal.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipPedestal",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15978521506086306704,
        "service_name": "drive-thru",
        "span_id": 11860690223845862428,
        "trace_id": 11244234476776951686
    }
}

running: False
schema_name_id: 1713
start_time: 2026-04-14 03:09:28
success: True
trace_id: 11244234476776951686

Scan 161942020

duration: 0:00:11.653927

exit_message:

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

id: 161942020

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_moloSlipPedestal/2026-04-13/1776066998",
        "key": "raw/molo_moloSlipPedestal/2026-04-13/1776066998/SlipPedestal.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipPedestal",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16094430487116334184,
        "service_name": "drive-thru",
        "span_id": 9297203562719433335,
        "trace_id": 12314664262868802850
    }
}

running: False
schema_name_id: 1713
start_time: 2026-04-13 03:01:15
success: True
trace_id: 12314664262868802850

Scan 161892831

duration: 0:00:14.023156

exit_message:

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

id: 161892831

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_moloSlipPedestal/2026-04-12/1775980709",
        "key": "raw/molo_moloSlipPedestal/2026-04-12/1775980709/SlipPedestal.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipPedestal",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12513777521056096732,
        "service_name": "drive-thru",
        "span_id": 10943693791068324111,
        "trace_id": 14829254466610346431
    }
}

running: False
schema_name_id: 1713
start_time: 2026-04-12 03:02:07
success: True
trace_id: 14829254466610346431

Scan 161841121

duration: 0:00:14.119082

exit_message:

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

id: 161841121

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_moloSlipPedestal/2026-04-11/1775894476",
        "key": "raw/molo_moloSlipPedestal/2026-04-11/1775894476/SlipPedestal.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipPedestal",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5781606316861211401,
        "service_name": "drive-thru",
        "span_id": 3626560837409548224,
        "trace_id": 3141724177140719054
    }
}

running: False
schema_name_id: 1713
start_time: 2026-04-11 03:03:31
success: True
trace_id: 3141724177140719054

Scan 161786099

duration: 0:00:14.258308

exit_message:

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

id: 161786099

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_moloSlipPedestal/2026-04-10/1775808235",
        "key": "raw/molo_moloSlipPedestal/2026-04-10/1775808235/SlipPedestal.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipPedestal",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17947641375609749620,
        "service_name": "drive-thru",
        "span_id": 12892235715097434599,
        "trace_id": 12013750299922981555
    }
}

running: False
schema_name_id: 1713
start_time: 2026-04-10 03:11:56
success: True
trace_id: 12013750299922981555

Scan 161730211

duration: 0:00:14.226125

exit_message:

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

id: 161730211

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_moloSlipPedestal/2026-04-09/1775721566",
        "key": "raw/molo_moloSlipPedestal/2026-04-09/1775721566/SlipPedestal.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipPedestal",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9069610656415151541,
        "service_name": "drive-thru",
        "span_id": 7758337566261418087,
        "trace_id": 9624633089924146211
    }
}

running: False
schema_name_id: 1713
start_time: 2026-04-09 03:02:44
success: True
trace_id: 9624633089924146211

Scan 161675679

duration: 0:00:14.393993

exit_message:

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

id: 161675679

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_moloSlipPedestal/2026-04-08/1775635395",
        "key": "raw/molo_moloSlipPedestal/2026-04-08/1775635395/SlipPedestal.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipPedestal",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16803912856638707970,
        "service_name": "drive-thru",
        "span_id": 16703561427455074969,
        "trace_id": 5860192564858076938
    }
}

running: False
schema_name_id: 1713
start_time: 2026-04-08 03:09:59
success: True
trace_id: 5860192564858076938

Scan 161618694

duration: 0:00:14.206839

exit_message:

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

id: 161618694

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_moloSlipPedestal/2026-04-07/1775548552",
        "key": "raw/molo_moloSlipPedestal/2026-04-07/1775548552/SlipPedestal.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipPedestal",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 334350160010331624,
        "service_name": "drive-thru",
        "span_id": 58957231364602453,
        "trace_id": 6109598234745192749
    }
}

running: False
schema_name_id: 1713
start_time: 2026-04-07 02:59:55
success: True
trace_id: 6109598234745192749

Scan 161561774

duration: 0:00:14.079990

exit_message:

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

id: 161561774

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_moloSlipPedestal/2026-04-06/1775462511",
        "key": "raw/molo_moloSlipPedestal/2026-04-06/1775462511/SlipPedestal.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipPedestal",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8201587260033620117,
        "service_name": "drive-thru",
        "span_id": 15948307849627300478,
        "trace_id": 12000709510808378081
    }
}

running: False
schema_name_id: 1713
start_time: 2026-04-06 03:11:06
success: True
trace_id: 12000709510808378081

Scan 161514934

duration: 0:00:11.543220

exit_message:

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

id: 161514934

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_moloSlipPedestal/2026-04-05/1775376138",
        "key": "raw/molo_moloSlipPedestal/2026-04-05/1775376138/SlipPedestal.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipPedestal",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12807941913865956149,
        "service_name": "drive-thru",
        "span_id": 4994675884336646851,
        "trace_id": 11192451951214251493
    }
}

running: False
schema_name_id: 1713
start_time: 2026-04-05 03:07:18
success: True
trace_id: 11192451951214251493

Scan 161460508

duration: 0:00:11.619406

exit_message:

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

id: 161460508

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_moloSlipPedestal/2026-04-04/1775289620",
        "key": "raw/molo_moloSlipPedestal/2026-04-04/1775289620/SlipPedestal.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipPedestal",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15740150822792630148,
        "service_name": "drive-thru",
        "span_id": 7804514163935176161,
        "trace_id": 11471942437754992981
    }
}

running: False
schema_name_id: 1713
start_time: 2026-04-04 03:08:32
success: True
trace_id: 11471942437754992981

Scan 161401913

duration: 0:00:11.771765

exit_message:

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

id: 161401913

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_moloSlipPedestal/2026-04-03/1775203393",
        "key": "raw/molo_moloSlipPedestal/2026-04-03/1775203393/SlipPedestal.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipPedestal",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15437436598460565861,
        "service_name": "drive-thru",
        "span_id": 5540183495183024484,
        "trace_id": 10050905897211865847
    }
}

running: False
schema_name_id: 1713
start_time: 2026-04-03 03:10:20
success: True
trace_id: 10050905897211865847

Partitions:

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

Schema:

attributes:

{
    "Pedestals_Id": "string",
    "Slips_Id": "string"
}

created: 2026-04-17 03:05:46

ddl:

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

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