Schema Info

Schema Name: sfdl_prod_drivethru.molo_molofuelcloudproductset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717607

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFuelCloudProductSet/2026-04-17/1776412731
id: 1717607
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1648
schema_scan_id: 162167382
updated: 2026-04-17 03:02:41

Version 1716365

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFuelCloudProductSet/2026-04-16/1776326489
id: 1716365
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1648
schema_scan_id: 162111758
updated: 2026-04-16 03:06:18

Version 1715174

created: 2026-04-15 03:03:12

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFuelCloudProductSet/2026-04-15/1776239959
id: 1715174
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1648
schema_scan_id: 162055827
updated: 2026-04-15 03:03:24

Version 1714041

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFuelCloudProductSet/2026-04-14/1776153686
id: 1714041
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1648
schema_scan_id: 162000525
updated: 2026-04-14 03:07:12

Version 1712754

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFuelCloudProductSet/2026-04-13/1776066879
id: 1712754
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1648
schema_scan_id: 161941561
updated: 2026-04-13 02:57:26

Version 1711570

created: 2026-04-12 03:00:00

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFuelCloudProductSet/2026-04-12/1775980594
id: 1711570
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1648
schema_scan_id: 161892544
updated: 2026-04-12 03:00:14

Version 1710362

created: 2026-04-11 03:02:50

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFuelCloudProductSet/2026-04-11/1775894355
id: 1710362
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1648
schema_scan_id: 161841082
updated: 2026-04-11 03:03:02

Version 1709274

created: 2026-04-10 03:07:16

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFuelCloudProductSet/2026-04-10/1775808110
id: 1709274
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1648
schema_scan_id: 161785967
updated: 2026-04-10 03:07:27

Version 1708061

created: 2026-04-09 03:00:59

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 1648
schema_scan_id: 161730005
updated: 2026-04-09 03:01:13

Version 1706903

created: 2026-04-08 03:05:33

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFuelCloudProductSet/2026-04-08/1775635257
id: 1706903
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1648
schema_scan_id: 161675522
updated: 2026-04-08 03:05:46

Version 1705671

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFuelCloudProductSet/2026-04-07/1775548431
id: 1705671
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1648
schema_scan_id: 161618354
updated: 2026-04-07 02:55:58

Version 1704555

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFuelCloudProductSet/2026-04-06/1775462398
id: 1704555
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1648
schema_scan_id: 161561670
updated: 2026-04-06 03:08:32

Version 1703240

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFuelCloudProductSet/2026-04-05/1775376021
id: 1703240
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1648
schema_scan_id: 161514808
updated: 2026-04-05 03:02:52

Version 1702079

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFuelCloudProductSet/2026-04-04/1775289505
id: 1702079
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1648
schema_scan_id: 161460001
updated: 2026-04-04 03:02:04

Version 1700878

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFuelCloudProductSet/2026-04-03/1775203277
id: 1700878
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1648
schema_scan_id: 161401806
updated: 2026-04-03 03:07:21

Schema Scans: 15

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

Scan 162167382

duration: 0:00:14.040573

exit_message:

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

id: 162167382

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_moloFuelCloudProductSet/2026-04-17/1776412731",
        "key": "raw/molo_moloFuelCloudProductSet/2026-04-17/1776412731/FuelCloudProductSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFuelCloudProductSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6736849824437405222,
        "service_name": "drive-thru",
        "span_id": 6072833539706333896,
        "trace_id": 12409104472576984523
    }
}

running: False
schema_name_id: 1648
start_time: 2026-04-17 03:02:27
success: True
trace_id: 12409104472576984523

Scan 162111758

duration: 0:00:14.117247

exit_message:

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

id: 162111758

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_moloFuelCloudProductSet/2026-04-16/1776326489",
        "key": "raw/molo_moloFuelCloudProductSet/2026-04-16/1776326489/FuelCloudProductSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFuelCloudProductSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16367119585913652055,
        "service_name": "drive-thru",
        "span_id": 14979111322311952563,
        "trace_id": 4702601102343612891
    }
}

running: False
schema_name_id: 1648
start_time: 2026-04-16 03:06:04
success: True
trace_id: 4702601102343612891

Scan 162055827

duration: 0:00:11.624593

exit_message:

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

id: 162055827

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_moloFuelCloudProductSet/2026-04-15/1776239959",
        "key": "raw/molo_moloFuelCloudProductSet/2026-04-15/1776239959/FuelCloudProductSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFuelCloudProductSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 668076773369495919,
        "service_name": "drive-thru",
        "span_id": 13947131600519943501,
        "trace_id": 16057222124135655010
    }
}

running: False
schema_name_id: 1648
start_time: 2026-04-15 03:03:12
success: True
trace_id: 16057222124135655010

Scan 162000525

duration: 0:00:14.074573

exit_message:

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

id: 162000525

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_moloFuelCloudProductSet/2026-04-14/1776153686",
        "key": "raw/molo_moloFuelCloudProductSet/2026-04-14/1776153686/FuelCloudProductSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFuelCloudProductSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10173299171175444585,
        "service_name": "drive-thru",
        "span_id": 4554247121636968683,
        "trace_id": 5120030599517073527
    }
}

running: False
schema_name_id: 1648
start_time: 2026-04-14 03:06:58
success: True
trace_id: 5120030599517073527

Scan 161941561

duration: 0:00:11.417148

exit_message:

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

id: 161941561

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_moloFuelCloudProductSet/2026-04-13/1776066879",
        "key": "raw/molo_moloFuelCloudProductSet/2026-04-13/1776066879/FuelCloudProductSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFuelCloudProductSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1392081438871109387,
        "service_name": "drive-thru",
        "span_id": 1436550236404887135,
        "trace_id": 16280106850046900645
    }
}

running: False
schema_name_id: 1648
start_time: 2026-04-13 02:57:15
success: True
trace_id: 16280106850046900645

Scan 161892544

duration: 0:00:14.344087

exit_message:

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

id: 161892544

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_moloFuelCloudProductSet/2026-04-12/1775980594",
        "key": "raw/molo_moloFuelCloudProductSet/2026-04-12/1775980594/FuelCloudProductSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFuelCloudProductSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7962972356455081181,
        "service_name": "drive-thru",
        "span_id": 17908263274223709399,
        "trace_id": 12377265470953314521
    }
}

running: False
schema_name_id: 1648
start_time: 2026-04-12 02:59:59
success: True
trace_id: 12377265470953314521

Scan 161841082

duration: 0:00:11.927101

exit_message:

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

id: 161841082

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_moloFuelCloudProductSet/2026-04-11/1775894355",
        "key": "raw/molo_moloFuelCloudProductSet/2026-04-11/1775894355/FuelCloudProductSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFuelCloudProductSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2360382040019300304,
        "service_name": "drive-thru",
        "span_id": 4419268753804363883,
        "trace_id": 3349577168458386193
    }
}

running: False
schema_name_id: 1648
start_time: 2026-04-11 03:02:50
success: True
trace_id: 3349577168458386193

Scan 161785967

duration: 0:00:11.601202

exit_message:

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

id: 161785967

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_moloFuelCloudProductSet/2026-04-10/1775808110",
        "key": "raw/molo_moloFuelCloudProductSet/2026-04-10/1775808110/FuelCloudProductSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFuelCloudProductSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11471262810519870583,
        "service_name": "drive-thru",
        "span_id": 7401837107873490690,
        "trace_id": 10717906163974808088
    }
}

running: False
schema_name_id: 1648
start_time: 2026-04-10 03:07:16
success: True
trace_id: 10717906163974808088

Scan 161730005

duration: 0:00:14.107656

exit_message:

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

id: 161730005

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_moloFuelCloudProductSet/2026-04-09/1775721450",
        "key": "raw/molo_moloFuelCloudProductSet/2026-04-09/1775721450/FuelCloudProductSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFuelCloudProductSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8627335155800015367,
        "service_name": "drive-thru",
        "span_id": 5612321067081672519,
        "trace_id": 12614983871080780099
    }
}

running: False
schema_name_id: 1648
start_time: 2026-04-09 03:00:59
success: True
trace_id: 12614983871080780099

Scan 161675522

duration: 0:00:14.051185

exit_message:

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

id: 161675522

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_moloFuelCloudProductSet/2026-04-08/1775635257",
        "key": "raw/molo_moloFuelCloudProductSet/2026-04-08/1775635257/FuelCloudProductSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFuelCloudProductSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2280491523013772920,
        "service_name": "drive-thru",
        "span_id": 12678099849474475333,
        "trace_id": 6995683369880748356
    }
}

running: False
schema_name_id: 1648
start_time: 2026-04-08 03:05:32
success: True
trace_id: 6995683369880748356

Scan 161618354

duration: 0:00:14.030221

exit_message:

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

id: 161618354

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_moloFuelCloudProductSet/2026-04-07/1775548431",
        "key": "raw/molo_moloFuelCloudProductSet/2026-04-07/1775548431/FuelCloudProductSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFuelCloudProductSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5996386400833796992,
        "service_name": "drive-thru",
        "span_id": 9191483559494877140,
        "trace_id": 17080237029697002942
    }
}

running: False
schema_name_id: 1648
start_time: 2026-04-07 02:55:44
success: True
trace_id: 17080237029697002942

Scan 161561670

duration: 0:00:11.525139

exit_message:

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

id: 161561670

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_moloFuelCloudProductSet/2026-04-06/1775462398",
        "key": "raw/molo_moloFuelCloudProductSet/2026-04-06/1775462398/FuelCloudProductSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFuelCloudProductSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16486297313306802973,
        "service_name": "drive-thru",
        "span_id": 11797053483119079678,
        "trace_id": 8662684553907454108
    }
}

running: False
schema_name_id: 1648
start_time: 2026-04-06 03:08:20
success: True
trace_id: 8662684553907454108

Scan 161514808

duration: 0:00:13.922134

exit_message:

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

id: 161514808

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_moloFuelCloudProductSet/2026-04-05/1775376021",
        "key": "raw/molo_moloFuelCloudProductSet/2026-04-05/1775376021/FuelCloudProductSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFuelCloudProductSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7175469710504407592,
        "service_name": "drive-thru",
        "span_id": 15869683926589231054,
        "trace_id": 1583083260881027964
    }
}

running: False
schema_name_id: 1648
start_time: 2026-04-05 03:02:38
success: True
trace_id: 1583083260881027964

Scan 161460001

duration: 0:00:14.127364

exit_message:

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

id: 161460001

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_moloFuelCloudProductSet/2026-04-04/1775289505",
        "key": "raw/molo_moloFuelCloudProductSet/2026-04-04/1775289505/FuelCloudProductSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFuelCloudProductSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9391823815052901476,
        "service_name": "drive-thru",
        "span_id": 1508107714470925844,
        "trace_id": 6780668780703064389
    }
}

running: False
schema_name_id: 1648
start_time: 2026-04-04 03:01:50
success: True
trace_id: 6780668780703064389

Scan 161401806

duration: 0:00:11.603064

exit_message:

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

id: 161401806

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_moloFuelCloudProductSet/2026-04-03/1775203277",
        "key": "raw/molo_moloFuelCloudProductSet/2026-04-03/1775203277/FuelCloudProductSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFuelCloudProductSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11409743360752105713,
        "service_name": "drive-thru",
        "span_id": 5048649438385686287,
        "trace_id": 16237456743981509663
    }
}

running: False
schema_name_id: 1648
start_time: 2026-04-03 03:07:09
success: True
trace_id: 16237456743981509663

Partitions:

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

Schema:

attributes:

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

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

ddl:

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

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