Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloresourceblockset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717712

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceblockset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceblockset`\n(\n `Id`  string , `StartTime`  string , `EndTime`  string , `Type`  string , `Hours`  string , `ResourceRateId`  string , `Offers_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_moloResourceBlockSet/2026-04-17/1776412846'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceblockset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceBlockSet/2026-04-17/1776412846
id: 1717712
processed: 1

raw_data:

{
    "EndTime": 2,
    "Hours": 4,
    "Id": 0,
    "Offers_Id": 6,
    "ResourceRateId": 5,
    "StartTime": 1,
    "Type": 3
}

schema_attributes:

{
    "EndTime": "string",
    "Hours": "string",
    "Id": "string",
    "Offers_Id": "string",
    "ResourceRateId": "string",
    "StartTime": "string",
    "Type": "string"
}

schema_name_id: 1656
schema_scan_id: 162167712
updated: 2026-04-17 03:08:12

Version 1716381

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceblockset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceblockset`\n(\n `Id`  string , `StartTime`  string , `EndTime`  string , `Type`  string , `Hours`  string , `ResourceRateId`  string , `Offers_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_moloResourceBlockSet/2026-04-16/1776326600'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceblockset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceBlockSet/2026-04-16/1776326600
id: 1716381
processed: 1

raw_data:

{
    "EndTime": 2,
    "Hours": 4,
    "Id": 0,
    "Offers_Id": 6,
    "ResourceRateId": 5,
    "StartTime": 1,
    "Type": 3
}

schema_attributes:

{
    "EndTime": "string",
    "Hours": "string",
    "Id": "string",
    "Offers_Id": "string",
    "ResourceRateId": "string",
    "StartTime": "string",
    "Type": "string"
}

schema_name_id: 1656
schema_scan_id: 162111791
updated: 2026-04-16 03:07:11

Version 1715256

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceblockset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceblockset`\n(\n `Id`  string , `StartTime`  string , `EndTime`  string , `Type`  string , `Hours`  string , `ResourceRateId`  string , `Offers_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_moloResourceBlockSet/2026-04-15/1776240070'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceblockset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceBlockSet/2026-04-15/1776240070
id: 1715256
processed: 1

raw_data:

{
    "EndTime": 2,
    "Hours": 4,
    "Id": 0,
    "Offers_Id": 6,
    "ResourceRateId": 5,
    "StartTime": 1,
    "Type": 3
}

schema_attributes:

{
    "EndTime": "string",
    "Hours": "string",
    "Id": "string",
    "Offers_Id": "string",
    "ResourceRateId": "string",
    "StartTime": "string",
    "Type": "string"
}

schema_name_id: 1656
schema_scan_id: 162056001
updated: 2026-04-15 03:07:19

Version 1714099

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceblockset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceblockset`\n(\n `Id`  string , `StartTime`  string , `EndTime`  string , `Type`  string , `Hours`  string , `ResourceRateId`  string , `Offers_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_moloResourceBlockSet/2026-04-14/1776153834'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceblockset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceBlockSet/2026-04-14/1776153834
id: 1714099
processed: 1

raw_data:

{
    "EndTime": 2,
    "Hours": 4,
    "Id": 0,
    "Offers_Id": 6,
    "ResourceRateId": 5,
    "StartTime": 1,
    "Type": 3
}

schema_attributes:

{
    "EndTime": "string",
    "Hours": "string",
    "Id": "string",
    "Offers_Id": "string",
    "ResourceRateId": "string",
    "StartTime": "string",
    "Type": "string"
}

schema_name_id: 1656
schema_scan_id: 162000609
updated: 2026-04-14 03:09:33

Version 1712862

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceblockset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceblockset`\n(\n `Id`  string , `StartTime`  string , `EndTime`  string , `Type`  string , `Hours`  string , `ResourceRateId`  string , `Offers_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_moloResourceBlockSet/2026-04-13/1776066994'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceblockset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceBlockSet/2026-04-13/1776066994
id: 1712862
processed: 1

raw_data:

{
    "EndTime": 2,
    "Hours": 4,
    "Id": 0,
    "Offers_Id": 6,
    "ResourceRateId": 5,
    "StartTime": 1,
    "Type": 3
}

schema_attributes:

{
    "EndTime": "string",
    "Hours": "string",
    "Id": "string",
    "Offers_Id": "string",
    "ResourceRateId": "string",
    "StartTime": "string",
    "Type": "string"
}

schema_name_id: 1656
schema_scan_id: 161941991
updated: 2026-04-13 03:01:20

Version 1711619

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceblockset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceblockset`\n(\n `Id`  string , `StartTime`  string , `EndTime`  string , `Type`  string , `Hours`  string , `ResourceRateId`  string , `Offers_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_moloResourceBlockSet/2026-04-12/1775980705'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceblockset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceBlockSet/2026-04-12/1775980705
id: 1711619
processed: 1

raw_data:

{
    "EndTime": 2,
    "Hours": 4,
    "Id": 0,
    "Offers_Id": 6,
    "ResourceRateId": 5,
    "StartTime": 1,
    "Type": 3
}

schema_attributes:

{
    "EndTime": "string",
    "Hours": "string",
    "Id": "string",
    "Offers_Id": "string",
    "ResourceRateId": "string",
    "StartTime": "string",
    "Type": "string"
}

schema_name_id: 1656
schema_scan_id: 161892772
updated: 2026-04-12 03:01:46

Version 1710407

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceblockset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceblockset`\n(\n `Id`  string , `StartTime`  string , `EndTime`  string , `Type`  string , `Hours`  string , `ResourceRateId`  string , `Offers_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_moloResourceBlockSet/2026-04-11/1775894472'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceblockset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceBlockSet/2026-04-11/1775894472
id: 1710407
processed: 1

raw_data:

{
    "EndTime": 2,
    "Hours": 4,
    "Id": 0,
    "Offers_Id": 6,
    "ResourceRateId": 5,
    "StartTime": 1,
    "Type": 3
}

schema_attributes:

{
    "EndTime": "string",
    "Hours": "string",
    "Id": "string",
    "Offers_Id": "string",
    "ResourceRateId": "string",
    "StartTime": "string",
    "Type": "string"
}

schema_name_id: 1656
schema_scan_id: 161841181
updated: 2026-04-11 03:05:01

Version 1709377

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceblockset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceblockset`\n(\n `Id`  string , `StartTime`  string , `EndTime`  string , `Type`  string , `Hours`  string , `ResourceRateId`  string , `Offers_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_moloResourceBlockSet/2026-04-10/1775808231'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceblockset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceBlockSet/2026-04-10/1775808231
id: 1709377
processed: 1

raw_data:

{
    "EndTime": 2,
    "Hours": 4,
    "Id": 0,
    "Offers_Id": 6,
    "ResourceRateId": 5,
    "StartTime": 1,
    "Type": 3
}

schema_attributes:

{
    "EndTime": "string",
    "Hours": "string",
    "Id": "string",
    "Offers_Id": "string",
    "ResourceRateId": "string",
    "StartTime": "string",
    "Type": "string"
}

schema_name_id: 1656
schema_scan_id: 161786078
updated: 2026-04-10 03:11:25

Version 1708149

created: 2026-04-09 03:04:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceblockset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceblockset`\n(\n `Id`  string , `StartTime`  string , `EndTime`  string , `Type`  string , `Hours`  string , `ResourceRateId`  string , `Offers_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_moloResourceBlockSet/2026-04-09/1775721563'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceblockset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceBlockSet/2026-04-09/1775721563
id: 1708149
processed: 1

raw_data:

{
    "EndTime": 2,
    "Hours": 4,
    "Id": 0,
    "Offers_Id": 6,
    "ResourceRateId": 5,
    "StartTime": 1,
    "Type": 3
}

schema_attributes:

{
    "EndTime": "string",
    "Hours": "string",
    "Id": "string",
    "Offers_Id": "string",
    "ResourceRateId": "string",
    "StartTime": "string",
    "Type": "string"
}

schema_name_id: 1656
schema_scan_id: 161730327
updated: 2026-04-09 03:04:40

Version 1706973

created: 2026-04-08 03:08:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceblockset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceblockset`\n(\n `Id`  string , `StartTime`  string , `EndTime`  string , `Type`  string , `Hours`  string , `ResourceRateId`  string , `Offers_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_moloResourceBlockSet/2026-04-08/1775635392'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceblockset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceBlockSet/2026-04-08/1775635392
id: 1706973
processed: 1

raw_data:

{
    "EndTime": 2,
    "Hours": 4,
    "Id": 0,
    "Offers_Id": 6,
    "ResourceRateId": 5,
    "StartTime": 1,
    "Type": 3
}

schema_attributes:

{
    "EndTime": "string",
    "Hours": "string",
    "Id": "string",
    "Offers_Id": "string",
    "ResourceRateId": "string",
    "StartTime": "string",
    "Type": "string"
}

schema_name_id: 1656
schema_scan_id: 161675629
updated: 2026-04-08 03:08:39

Version 1705765

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceblockset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceblockset`\n(\n `Id`  string , `StartTime`  string , `EndTime`  string , `Type`  string , `Hours`  string , `ResourceRateId`  string , `Offers_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_moloResourceBlockSet/2026-04-07/1775548548'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceblockset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceBlockSet/2026-04-07/1775548548
id: 1705765
processed: 1

raw_data:

{
    "EndTime": 2,
    "Hours": 4,
    "Id": 0,
    "Offers_Id": 6,
    "ResourceRateId": 5,
    "StartTime": 1,
    "Type": 3
}

schema_attributes:

{
    "EndTime": "string",
    "Hours": "string",
    "Id": "string",
    "Offers_Id": "string",
    "ResourceRateId": "string",
    "StartTime": "string",
    "Type": "string"
}

schema_name_id: 1656
schema_scan_id: 161618618
updated: 2026-04-07 02:59:43

Version 1704507

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceblockset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceblockset`\n(\n `Id`  string , `StartTime`  string , `EndTime`  string , `Type`  string , `Hours`  string , `ResourceRateId`  string , `Offers_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_moloResourceBlockSet/2026-04-06/1775462508'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceblockset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceBlockSet/2026-04-06/1775462508
id: 1704507
processed: 1

raw_data:

{
    "EndTime": 2,
    "Hours": 4,
    "Id": 0,
    "Offers_Id": 6,
    "ResourceRateId": 5,
    "StartTime": 1,
    "Type": 3
}

schema_attributes:

{
    "EndTime": "string",
    "Hours": "string",
    "Id": "string",
    "Offers_Id": "string",
    "ResourceRateId": "string",
    "StartTime": "string",
    "Type": "string"
}

schema_name_id: 1656
schema_scan_id: 161561598
updated: 2026-04-06 03:06:36

Version 1703404

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceblockset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceblockset`\n(\n `Id`  string , `StartTime`  string , `EndTime`  string , `Type`  string , `Hours`  string , `ResourceRateId`  string , `Offers_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_moloResourceBlockSet/2026-04-05/1775376134'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceblockset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceBlockSet/2026-04-05/1775376134
id: 1703404
processed: 1

raw_data:

{
    "EndTime": 2,
    "Hours": 4,
    "Id": 0,
    "Offers_Id": 6,
    "ResourceRateId": 5,
    "StartTime": 1,
    "Type": 3
}

schema_attributes:

{
    "EndTime": "string",
    "Hours": "string",
    "Id": "string",
    "Offers_Id": "string",
    "ResourceRateId": "string",
    "StartTime": "string",
    "Type": "string"
}

schema_name_id: 1656
schema_scan_id: 161514989
updated: 2026-04-05 03:09:26

Version 1702214

created: 2026-04-04 03:08:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceblockset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceblockset`\n(\n `Id`  string , `StartTime`  string , `EndTime`  string , `Type`  string , `Hours`  string , `ResourceRateId`  string , `Offers_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_moloResourceBlockSet/2026-04-04/1775289617'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceblockset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceBlockSet/2026-04-04/1775289617
id: 1702214
processed: 1

raw_data:

{
    "EndTime": 2,
    "Hours": 4,
    "Id": 0,
    "Offers_Id": 6,
    "ResourceRateId": 5,
    "StartTime": 1,
    "Type": 3
}

schema_attributes:

{
    "EndTime": "string",
    "Hours": "string",
    "Id": "string",
    "Offers_Id": "string",
    "ResourceRateId": "string",
    "StartTime": "string",
    "Type": "string"
}

schema_name_id: 1656
schema_scan_id: 161460501
updated: 2026-04-04 03:08:26

Version 1700991

created: 2026-04-03 03:11:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceblockset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceblockset`\n(\n `Id`  string , `StartTime`  string , `EndTime`  string , `Type`  string , `Hours`  string , `ResourceRateId`  string , `Offers_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_moloResourceBlockSet/2026-04-03/1775203390'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceblockset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceBlockSet/2026-04-03/1775203390
id: 1700991
processed: 1

raw_data:

{
    "EndTime": 2,
    "Hours": 4,
    "Id": 0,
    "Offers_Id": 6,
    "ResourceRateId": 5,
    "StartTime": 1,
    "Type": 3
}

schema_attributes:

{
    "EndTime": "string",
    "Hours": "string",
    "Id": "string",
    "Offers_Id": "string",
    "ResourceRateId": "string",
    "StartTime": "string",
    "Type": "string"
}

schema_name_id: 1656
schema_scan_id: 161401963
updated: 2026-04-03 03:11:59

Schema Scans: 15

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

Scan 162167712

duration: 0:00:14.147390

exit_message:

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

id: 162167712

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_moloResourceBlockSet/2026-04-17/1776412846",
        "key": "raw/molo_moloResourceBlockSet/2026-04-17/1776412846/ResourceBlockSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceBlockSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6732931194735467163,
        "service_name": "drive-thru",
        "span_id": 9486552276427447267,
        "trace_id": 5477774909100507452
    }
}

running: False
schema_name_id: 1656
start_time: 2026-04-17 03:07:58
success: True
trace_id: 5477774909100507452

Scan 162111791

duration: 0:00:11.799264

exit_message:

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

id: 162111791

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_moloResourceBlockSet/2026-04-16/1776326600",
        "key": "raw/molo_moloResourceBlockSet/2026-04-16/1776326600/ResourceBlockSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceBlockSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7413745825208030551,
        "service_name": "drive-thru",
        "span_id": 12949789002653308351,
        "trace_id": 18222081281659734421
    }
}

running: False
schema_name_id: 1656
start_time: 2026-04-16 03:06:59
success: True
trace_id: 18222081281659734421

Scan 162056001

duration: 0:00:14.106614

exit_message:

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

id: 162056001

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_moloResourceBlockSet/2026-04-15/1776240070",
        "key": "raw/molo_moloResourceBlockSet/2026-04-15/1776240070/ResourceBlockSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceBlockSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 844803374538481916,
        "service_name": "drive-thru",
        "span_id": 6314001344407445934,
        "trace_id": 6404348621008390080
    }
}

running: False
schema_name_id: 1656
start_time: 2026-04-15 03:07:05
success: True
trace_id: 6404348621008390080

Scan 162000609

duration: 0:00:14.325764

exit_message:

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

id: 162000609

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_moloResourceBlockSet/2026-04-14/1776153834",
        "key": "raw/molo_moloResourceBlockSet/2026-04-14/1776153834/ResourceBlockSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceBlockSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8565122582177616850,
        "service_name": "drive-thru",
        "span_id": 4582721753780665330,
        "trace_id": 4259245864683826977
    }
}

running: False
schema_name_id: 1656
start_time: 2026-04-14 03:09:19
success: True
trace_id: 4259245864683826977

Scan 161941991

duration: 0:00:14.194740

exit_message:

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

id: 161941991

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_moloResourceBlockSet/2026-04-13/1776066994",
        "key": "raw/molo_moloResourceBlockSet/2026-04-13/1776066994/ResourceBlockSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceBlockSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2290168527559384880,
        "service_name": "drive-thru",
        "span_id": 5227829392265577405,
        "trace_id": 1374576166648572982
    }
}

running: False
schema_name_id: 1656
start_time: 2026-04-13 03:01:05
success: True
trace_id: 1374576166648572982

Scan 161892772

duration: 0:00:11.710602

exit_message:

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

id: 161892772

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_moloResourceBlockSet/2026-04-12/1775980705",
        "key": "raw/molo_moloResourceBlockSet/2026-04-12/1775980705/ResourceBlockSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceBlockSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8408825716665176251,
        "service_name": "drive-thru",
        "span_id": 17578999458110629673,
        "trace_id": 2098357562225136989
    }
}

running: False
schema_name_id: 1656
start_time: 2026-04-12 03:01:34
success: True
trace_id: 2098357562225136989

Scan 161841181

duration: 0:00:11.632755

exit_message:

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

id: 161841181

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_moloResourceBlockSet/2026-04-11/1775894472",
        "key": "raw/molo_moloResourceBlockSet/2026-04-11/1775894472/ResourceBlockSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceBlockSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1056640367668542977,
        "service_name": "drive-thru",
        "span_id": 7267141187897739227,
        "trace_id": 825928003608706187
    }
}

running: False
schema_name_id: 1656
start_time: 2026-04-11 03:04:50
success: True
trace_id: 825928003608706187

Scan 161786078

duration: 0:00:14.256580

exit_message:

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

id: 161786078

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_moloResourceBlockSet/2026-04-10/1775808231",
        "key": "raw/molo_moloResourceBlockSet/2026-04-10/1775808231/ResourceBlockSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceBlockSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10457535874104086590,
        "service_name": "drive-thru",
        "span_id": 5194915091158741852,
        "trace_id": 2400436758274039798
    }
}

running: False
schema_name_id: 1656
start_time: 2026-04-10 03:11:10
success: True
trace_id: 2400436758274039798

Scan 161730327

duration: 0:00:14.170314

exit_message:

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

id: 161730327

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_moloResourceBlockSet/2026-04-09/1775721563",
        "key": "raw/molo_moloResourceBlockSet/2026-04-09/1775721563/ResourceBlockSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceBlockSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6146677703256424664,
        "service_name": "drive-thru",
        "span_id": 5813431072949639876,
        "trace_id": 8695525121029234204
    }
}

running: False
schema_name_id: 1656
start_time: 2026-04-09 03:04:26
success: True
trace_id: 8695525121029234204

Scan 161675629

duration: 0:00:14.200618

exit_message:

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

id: 161675629

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_moloResourceBlockSet/2026-04-08/1775635392",
        "key": "raw/molo_moloResourceBlockSet/2026-04-08/1775635392/ResourceBlockSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceBlockSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12662920867510786006,
        "service_name": "drive-thru",
        "span_id": 11646629296757071944,
        "trace_id": 4278031719332201576
    }
}

running: False
schema_name_id: 1656
start_time: 2026-04-08 03:08:25
success: True
trace_id: 4278031719332201576

Scan 161618618

duration: 0:00:14.179790

exit_message:

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

id: 161618618

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_moloResourceBlockSet/2026-04-07/1775548548",
        "key": "raw/molo_moloResourceBlockSet/2026-04-07/1775548548/ResourceBlockSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceBlockSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4401307852186256924,
        "service_name": "drive-thru",
        "span_id": 12660732408023208206,
        "trace_id": 18032836129804841342
    }
}

running: False
schema_name_id: 1656
start_time: 2026-04-07 02:59:29
success: True
trace_id: 18032836129804841342

Scan 161561598

duration: 0:00:11.572290

exit_message:

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

id: 161561598

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_moloResourceBlockSet/2026-04-06/1775462508",
        "key": "raw/molo_moloResourceBlockSet/2026-04-06/1775462508/ResourceBlockSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceBlockSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8724934653498717080,
        "service_name": "drive-thru",
        "span_id": 15066454539379453842,
        "trace_id": 17401793671076935790
    }
}

running: False
schema_name_id: 1656
start_time: 2026-04-06 03:06:24
success: True
trace_id: 17401793671076935790

Scan 161514989

duration: 0:00:11.782360

exit_message:

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

id: 161514989

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_moloResourceBlockSet/2026-04-05/1775376134",
        "key": "raw/molo_moloResourceBlockSet/2026-04-05/1775376134/ResourceBlockSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceBlockSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6569833429153910377,
        "service_name": "drive-thru",
        "span_id": 9414632741252746754,
        "trace_id": 6784757853707553386
    }
}

running: False
schema_name_id: 1656
start_time: 2026-04-05 03:09:15
success: True
trace_id: 6784757853707553386

Scan 161460501

duration: 0:00:14.160401

exit_message:

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

id: 161460501

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_moloResourceBlockSet/2026-04-04/1775289617",
        "key": "raw/molo_moloResourceBlockSet/2026-04-04/1775289617/ResourceBlockSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceBlockSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11632470566125766422,
        "service_name": "drive-thru",
        "span_id": 7813765911527690133,
        "trace_id": 1447792365261750080
    }
}

running: False
schema_name_id: 1656
start_time: 2026-04-04 03:08:12
success: True
trace_id: 1447792365261750080

Scan 161401963

duration: 0:00:11.551470

exit_message:

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

id: 161401963

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_moloResourceBlockSet/2026-04-03/1775203390",
        "key": "raw/molo_moloResourceBlockSet/2026-04-03/1775203390/ResourceBlockSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceBlockSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8866520555630025511,
        "service_name": "drive-thru",
        "span_id": 15693431887036922412,
        "trace_id": 10675818401970639339
    }
}

running: False
schema_name_id: 1656
start_time: 2026-04-03 03:11:48
success: True
trace_id: 10675818401970639339

Partitions:

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

Schema:

attributes:

{
    "EndTime": "string",
    "Hours": "string",
    "Id": "string",
    "Offers_Id": "string",
    "ResourceRateId": "string",
    "StartTime": "string",
    "Type": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceblockset`\n(\n `Id`  string , `StartTime`  string , `EndTime`  string , `Type`  string , `Hours`  string , `ResourceRateId`  string , `Offers_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_moloResourceBlockSet/2026-04-17/1776412846'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceblockset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceblockset"
}

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