Schema Info
Schema Name: sfdl_prod_drivethru.molo_molotransientrateoverridesset
- created: 2023-10-17 02:03:16
- disabled: False
- format: raw
- id: 1814
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "molo_molotransientrateoverridesset" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717763
- created: 2026-04-17 03:09:58
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientrateoverridesset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientrateoverridesset`\n(\n `Id` string , `PeriodCount` string , `TransientPrice_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_moloTransientRateOverridesSet/2026-04-17/1776413225'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientrateoverridesset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientRateOverridesSet/2026-04-17/1776413225
- id: 1717763
- processed: 1
- raw_data:
{ "Id": 0, "PeriodCount": 1, "TransientPrice_Id": 2 } - schema_attributes:
{ "Id": "string", "PeriodCount": "string", "TransientPrice_Id": "string" } - schema_name_id: 1814
- schema_scan_id: 162167782
- updated: 2026-04-17 03:10:09
-
Version 1716580
- created: 2026-04-16 03:14:35
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientrateoverridesset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientrateoverridesset`\n(\n `Id` string , `PeriodCount` string , `TransientPrice_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_moloTransientRateOverridesSet/2026-04-16/1776326745'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientrateoverridesset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientRateOverridesSet/2026-04-16/1776326745
- id: 1716580
- processed: 1
- raw_data:
{ "Id": 0, "PeriodCount": 1, "TransientPrice_Id": 2 } - schema_attributes:
{ "Id": "string", "PeriodCount": "string", "TransientPrice_Id": "string" } - schema_name_id: 1814
- schema_scan_id: 162112043
- updated: 2026-04-16 03:14:49
-
Version 1715359
- created: 2026-04-15 03:12:06
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientrateoverridesset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientrateoverridesset`\n(\n `Id` string , `PeriodCount` string , `TransientPrice_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_moloTransientRateOverridesSet/2026-04-15/1776240206'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientrateoverridesset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientRateOverridesSet/2026-04-15/1776240206
- id: 1715359
- processed: 1
- raw_data:
{ "Id": 0, "PeriodCount": 1, "TransientPrice_Id": 2 } - schema_attributes:
{ "Id": "string", "PeriodCount": "string", "TransientPrice_Id": "string" } - schema_name_id: 1814
- schema_scan_id: 162056158
- updated: 2026-04-15 03:12:20
-
Version 1714128
- created: 2026-04-14 03:10:24
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientrateoverridesset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientrateoverridesset`\n(\n `Id` string , `PeriodCount` string , `TransientPrice_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_moloTransientRateOverridesSet/2026-04-14/1776154172'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientrateoverridesset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientRateOverridesSet/2026-04-14/1776154172
- id: 1714128
- processed: 1
- raw_data:
{ "Id": 0, "PeriodCount": 1, "TransientPrice_Id": 2 } - schema_attributes:
{ "Id": "string", "PeriodCount": "string", "TransientPrice_Id": "string" } - schema_name_id: 1814
- schema_scan_id: 162000645
- updated: 2026-04-14 03:10:38
-
Version 1712905
- created: 2026-04-13 03:03:52
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientrateoverridesset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientrateoverridesset`\n(\n `Id` string , `PeriodCount` string , `TransientPrice_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_moloTransientRateOverridesSet/2026-04-13/1776067165'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientrateoverridesset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientRateOverridesSet/2026-04-13/1776067165
- id: 1712905
- processed: 1
- raw_data:
{ "Id": 0, "PeriodCount": 1, "TransientPrice_Id": 2 } - schema_attributes:
{ "Id": "string", "PeriodCount": "string", "TransientPrice_Id": "string" } - schema_name_id: 1814
- schema_scan_id: 161942599
- updated: 2026-04-13 03:04:04
-
Version 1711732
- created: 2026-04-12 03:07:10
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientrateoverridesset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientrateoverridesset`\n(\n `Id` string , `PeriodCount` string , `TransientPrice_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_moloTransientRateOverridesSet/2026-04-12/1775980867'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientrateoverridesset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientRateOverridesSet/2026-04-12/1775980867
- id: 1711732
- processed: 1
- raw_data:
{ "Id": 0, "PeriodCount": 1, "TransientPrice_Id": 2 } - schema_attributes:
{ "Id": "string", "PeriodCount": "string", "TransientPrice_Id": "string" } - schema_name_id: 1814
- schema_scan_id: 161893420
- updated: 2026-04-12 03:07:24
-
Version 1710484
- created: 2026-04-11 03:07:49
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientrateoverridesset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientrateoverridesset`\n(\n `Id` string , `PeriodCount` string , `TransientPrice_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_moloTransientRateOverridesSet/2026-04-11/1775894641'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientrateoverridesset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientRateOverridesSet/2026-04-11/1775894641
- id: 1710484
- processed: 1
- raw_data:
{ "Id": 0, "PeriodCount": 1, "TransientPrice_Id": 2 } - schema_attributes:
{ "Id": "string", "PeriodCount": "string", "TransientPrice_Id": "string" } - schema_name_id: 1814
- schema_scan_id: 161841274
- updated: 2026-04-11 03:08:00
-
Version 1709317
- created: 2026-04-10 03:08:48
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientrateoverridesset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientrateoverridesset`\n(\n `Id` string , `PeriodCount` string , `TransientPrice_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_moloTransientRateOverridesSet/2026-04-10/1775808399'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientrateoverridesset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientRateOverridesSet/2026-04-10/1775808399
- id: 1709317
- processed: 1
- raw_data:
{ "Id": 0, "PeriodCount": 1, "TransientPrice_Id": 2 } - schema_attributes:
{ "Id": "string", "PeriodCount": "string", "TransientPrice_Id": "string" } - schema_name_id: 1814
- schema_scan_id: 161786015
- updated: 2026-04-10 03:08:59
-
Version 1708139
- created: 2026-04-09 03:03:57
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientrateoverridesset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientrateoverridesset`\n(\n `Id` string , `PeriodCount` string , `TransientPrice_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_moloTransientRateOverridesSet/2026-04-09/1775721728'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientrateoverridesset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientRateOverridesSet/2026-04-09/1775721728
- id: 1708139
- processed: 1
- raw_data:
{ "Id": 0, "PeriodCount": 1, "TransientPrice_Id": 2 } - schema_attributes:
{ "Id": "string", "PeriodCount": "string", "TransientPrice_Id": "string" } - schema_name_id: 1814
- schema_scan_id: 161730302
- updated: 2026-04-09 03:04:11
-
Version 1706965
- created: 2026-04-08 03:08:10
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientrateoverridesset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientrateoverridesset`\n(\n `Id` string , `PeriodCount` string , `TransientPrice_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_moloTransientRateOverridesSet/2026-04-08/1775635558'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientrateoverridesset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientRateOverridesSet/2026-04-08/1775635558
- id: 1706965
- processed: 1
- raw_data:
{ "Id": 0, "PeriodCount": 1, "TransientPrice_Id": 2 } - schema_attributes:
{ "Id": "string", "PeriodCount": "string", "TransientPrice_Id": "string" } - schema_name_id: 1814
- schema_scan_id: 161675620
- updated: 2026-04-08 03:08:24
-
Version 1705824
- created: 2026-04-07 03:02:18
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientrateoverridesset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientrateoverridesset`\n(\n `Id` string , `PeriodCount` string , `TransientPrice_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_moloTransientRateOverridesSet/2026-04-07/1775548718'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientrateoverridesset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientRateOverridesSet/2026-04-07/1775548718
- id: 1705824
- processed: 1
- raw_data:
{ "Id": 0, "PeriodCount": 1, "TransientPrice_Id": 2 } - schema_attributes:
{ "Id": "string", "PeriodCount": "string", "TransientPrice_Id": "string" } - schema_name_id: 1814
- schema_scan_id: 161619235
- updated: 2026-04-07 03:02:32
-
Version 1704659
- created: 2026-04-06 03:12:23
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientrateoverridesset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientrateoverridesset`\n(\n `Id` string , `PeriodCount` string , `TransientPrice_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_moloTransientRateOverridesSet/2026-04-06/1775462669'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientrateoverridesset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientRateOverridesSet/2026-04-06/1775462669
- id: 1704659
- processed: 1
- raw_data:
{ "Id": 0, "PeriodCount": 1, "TransientPrice_Id": 2 } - schema_attributes:
{ "Id": "string", "PeriodCount": "string", "TransientPrice_Id": "string" } - schema_name_id: 1814
- schema_scan_id: 161561814
- updated: 2026-04-06 03:12:37
-
Version 1703390
- created: 2026-04-05 03:08:42
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientrateoverridesset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientrateoverridesset`\n(\n `Id` string , `PeriodCount` string , `TransientPrice_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_moloTransientRateOverridesSet/2026-04-05/1775376299'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientrateoverridesset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientRateOverridesSet/2026-04-05/1775376299
- id: 1703390
- processed: 1
- raw_data:
{ "Id": 0, "PeriodCount": 1, "TransientPrice_Id": 2 } - schema_attributes:
{ "Id": "string", "PeriodCount": "string", "TransientPrice_Id": "string" } - schema_name_id: 1814
- schema_scan_id: 161514974
- updated: 2026-04-05 03:08:53
-
Version 1702256
- created: 2026-04-04 03:09:59
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientrateoverridesset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientrateoverridesset`\n(\n `Id` string , `PeriodCount` string , `TransientPrice_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_moloTransientRateOverridesSet/2026-04-04/1775289783'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientrateoverridesset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientRateOverridesSet/2026-04-04/1775289783
- id: 1702256
- processed: 1
- raw_data:
{ "Id": 0, "PeriodCount": 1, "TransientPrice_Id": 2 } - schema_attributes:
{ "Id": "string", "PeriodCount": "string", "TransientPrice_Id": "string" } - schema_name_id: 1814
- schema_scan_id: 161460556
- updated: 2026-04-04 03:10:13
-
Version 1701064
- created: 2026-04-03 03:15:48
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientrateoverridesset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientrateoverridesset`\n(\n `Id` string , `PeriodCount` string , `TransientPrice_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_moloTransientRateOverridesSet/2026-04-03/1775203549'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientrateoverridesset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientRateOverridesSet/2026-04-03/1775203549
- id: 1701064
- processed: 1
- raw_data:
{ "Id": 0, "PeriodCount": 1, "TransientPrice_Id": 2 } - schema_attributes:
{ "Id": "string", "PeriodCount": "string", "TransientPrice_Id": "string" } - schema_name_id: 1814
- schema_scan_id: 161402057
- updated: 2026-04-03 03:15:59
Schema Scans: 15
Last at 2026-04-17 03:09:58
-
Scan 162167782
- duration: 0:00:11.537094
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162167782
- 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_moloTransientRateOverridesSet/2026-04-17/1776413225", "key": "raw/molo_moloTransientRateOverridesSet/2026-04-17/1776413225/TransientRateOverridesSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransientRateOverridesSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1520405542152730047, "service_name": "drive-thru", "span_id": 14305472030139404094, "trace_id": 16414602570305964862 } } - running: False
- schema_name_id: 1814
- start_time: 2026-04-17 03:09:58
- success: True
- trace_id: 16414602570305964862
-
Scan 162112043
- duration: 0:00:14.035097
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162112043
- 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_moloTransientRateOverridesSet/2026-04-16/1776326745", "key": "raw/molo_moloTransientRateOverridesSet/2026-04-16/1776326745/TransientRateOverridesSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransientRateOverridesSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 789922142827575891, "service_name": "drive-thru", "span_id": 1886337900441397859, "trace_id": 2920751373094450882 } } - running: False
- schema_name_id: 1814
- start_time: 2026-04-16 03:14:35
- success: True
- trace_id: 2920751373094450882
-
Scan 162056158
- duration: 0:00:14.045272
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162056158
- 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_moloTransientRateOverridesSet/2026-04-15/1776240206", "key": "raw/molo_moloTransientRateOverridesSet/2026-04-15/1776240206/TransientRateOverridesSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransientRateOverridesSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7374121873823830506, "service_name": "drive-thru", "span_id": 7703711236139918337, "trace_id": 5280050492938796273 } } - running: False
- schema_name_id: 1814
- start_time: 2026-04-15 03:12:06
- success: True
- trace_id: 5280050492938796273
-
Scan 162000645
- duration: 0:00:14.174419
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162000645
- 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_moloTransientRateOverridesSet/2026-04-14/1776154172", "key": "raw/molo_moloTransientRateOverridesSet/2026-04-14/1776154172/TransientRateOverridesSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransientRateOverridesSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17922304380234336283, "service_name": "drive-thru", "span_id": 7950441439888485758, "trace_id": 312225301915787665 } } - running: False
- schema_name_id: 1814
- start_time: 2026-04-14 03:10:24
- success: True
- trace_id: 312225301915787665
-
Scan 161942599
- duration: 0:00:11.564353
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161942599
- 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_moloTransientRateOverridesSet/2026-04-13/1776067165", "key": "raw/molo_moloTransientRateOverridesSet/2026-04-13/1776067165/TransientRateOverridesSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransientRateOverridesSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9921517493490429433, "service_name": "drive-thru", "span_id": 5938997218966394527, "trace_id": 13099667839011801622 } } - running: False
- schema_name_id: 1814
- start_time: 2026-04-13 03:03:52
- success: True
- trace_id: 13099667839011801622
-
Scan 161893420
- duration: 0:00:14.135651
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161893420
- 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_moloTransientRateOverridesSet/2026-04-12/1775980867", "key": "raw/molo_moloTransientRateOverridesSet/2026-04-12/1775980867/TransientRateOverridesSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransientRateOverridesSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13929900246654988840, "service_name": "drive-thru", "span_id": 6472041295349825475, "trace_id": 7946477605301559213 } } - running: False
- schema_name_id: 1814
- start_time: 2026-04-12 03:07:10
- success: True
- trace_id: 7946477605301559213
-
Scan 161841274
- duration: 0:00:11.477864
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161841274
- 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_moloTransientRateOverridesSet/2026-04-11/1775894641", "key": "raw/molo_moloTransientRateOverridesSet/2026-04-11/1775894641/TransientRateOverridesSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransientRateOverridesSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17235487647680500774, "service_name": "drive-thru", "span_id": 10871383317688826595, "trace_id": 4886003244598589859 } } - running: False
- schema_name_id: 1814
- start_time: 2026-04-11 03:07:48
- success: True
- trace_id: 4886003244598589859
-
Scan 161786015
- duration: 0:00:11.570235
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161786015
- 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_moloTransientRateOverridesSet/2026-04-10/1775808399", "key": "raw/molo_moloTransientRateOverridesSet/2026-04-10/1775808399/TransientRateOverridesSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransientRateOverridesSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 18358140195942492851, "service_name": "drive-thru", "span_id": 16409075423411534496, "trace_id": 5462914637572029674 } } - running: False
- schema_name_id: 1814
- start_time: 2026-04-10 03:08:47
- success: True
- trace_id: 5462914637572029674
-
Scan 161730302
- duration: 0:00:14.042649
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161730302
- 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_moloTransientRateOverridesSet/2026-04-09/1775721728", "key": "raw/molo_moloTransientRateOverridesSet/2026-04-09/1775721728/TransientRateOverridesSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransientRateOverridesSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12321654007317134341, "service_name": "drive-thru", "span_id": 17767741888182701958, "trace_id": 11320758866811533285 } } - running: False
- schema_name_id: 1814
- start_time: 2026-04-09 03:03:57
- success: True
- trace_id: 11320758866811533285
-
Scan 161675620
- duration: 0:00:14.025515
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161675620
- 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_moloTransientRateOverridesSet/2026-04-08/1775635558", "key": "raw/molo_moloTransientRateOverridesSet/2026-04-08/1775635558/TransientRateOverridesSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransientRateOverridesSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5728989698437990028, "service_name": "drive-thru", "span_id": 11334727164189520015, "trace_id": 17981620960297052717 } } - running: False
- schema_name_id: 1814
- start_time: 2026-04-08 03:08:10
- success: True
- trace_id: 17981620960297052717
-
Scan 161619235
- duration: 0:00:14.174375
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161619235
- 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_moloTransientRateOverridesSet/2026-04-07/1775548718", "key": "raw/molo_moloTransientRateOverridesSet/2026-04-07/1775548718/TransientRateOverridesSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransientRateOverridesSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6744023977124789256, "service_name": "drive-thru", "span_id": 1117492031075969357, "trace_id": 13629581325936411268 } } - running: False
- schema_name_id: 1814
- start_time: 2026-04-07 03:02:18
- success: True
- trace_id: 13629581325936411268
-
Scan 161561814
- duration: 0:00:14.030416
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161561814
- 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_moloTransientRateOverridesSet/2026-04-06/1775462669", "key": "raw/molo_moloTransientRateOverridesSet/2026-04-06/1775462669/TransientRateOverridesSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransientRateOverridesSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 18394753477684787142, "service_name": "drive-thru", "span_id": 936067267247565724, "trace_id": 5755261613498695011 } } - running: False
- schema_name_id: 1814
- start_time: 2026-04-06 03:12:23
- success: True
- trace_id: 5755261613498695011
-
Scan 161514974
- duration: 0:00:11.445497
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161514974
- 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_moloTransientRateOverridesSet/2026-04-05/1775376299", "key": "raw/molo_moloTransientRateOverridesSet/2026-04-05/1775376299/TransientRateOverridesSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransientRateOverridesSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11784326231453513884, "service_name": "drive-thru", "span_id": 9918034641913866083, "trace_id": 1244565482539026413 } } - running: False
- schema_name_id: 1814
- start_time: 2026-04-05 03:08:42
- success: True
- trace_id: 1244565482539026413
-
Scan 161460556
- duration: 0:00:14.093014
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161460556
- 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_moloTransientRateOverridesSet/2026-04-04/1775289783", "key": "raw/molo_moloTransientRateOverridesSet/2026-04-04/1775289783/TransientRateOverridesSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransientRateOverridesSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6528056660791573897, "service_name": "drive-thru", "span_id": 646234496802175127, "trace_id": 11721769673341409852 } } - running: False
- schema_name_id: 1814
- start_time: 2026-04-04 03:09:59
- success: True
- trace_id: 11721769673341409852
-
Scan 161402057
- duration: 0:00:11.513850
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161402057
- 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_moloTransientRateOverridesSet/2026-04-03/1775203549", "key": "raw/molo_moloTransientRateOverridesSet/2026-04-03/1775203549/TransientRateOverridesSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransientRateOverridesSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11910947251883362784, "service_name": "drive-thru", "span_id": 2473256608573541235, "trace_id": 2286616490174499914 } } - running: False
- schema_name_id: 1814
- start_time: 2026-04-03 03:15:47
- success: True
- trace_id: 2286616490174499914
- attributes:
{ "Id": "string", "PeriodCount": "string", "TransientPrice_Id": "string" } - created: 2026-04-17 03:09:58
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientrateoverridesset`\n(\n `Id` string , `PeriodCount` string , `TransientPrice_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_moloTransientRateOverridesSet/2026-04-17/1776413225'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientrateoverridesset`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientrateoverridesset" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2023-10-17 02:03:16",
"disabled": false,
"format": "raw",
"id": 1814,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "molo_molotransientrateoverridesset"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"Id": "string",
"PeriodCount": "string",
"TransientPrice_Id": "string"
},
"created": "2026-04-17 03:09:58",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientrateoverridesset`\n(\n `Id` string , `PeriodCount` string , `TransientPrice_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_moloTransientRateOverridesSet/2026-04-17/1776413225'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientrateoverridesset`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientrateoverridesset"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}