Schema Info
Schema Name: sfdl_prod_drivethru.molo_moloreverserebillsettingsset
- created: 2025-07-11 02:15:38
- disabled: False
- format: raw
- id: 4251
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "molo_moloreverserebillsettingsset" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717754
- created: 2026-04-17 03:09:38
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreverserebillsettingsset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreverserebillsettingsset`\n(\n `Id` string , `Setting` string , `RecordStatus_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_moloReverseRebillSettingsSet/2026-04-17/1776412848'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreverserebillsettingsset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloReverseRebillSettingsSet/2026-04-17/1776412848
- id: 1717754
- processed: 1
- raw_data:
{ "Id": 0, "RecordStatus_Id": 2, "Setting": 1 } - schema_attributes:
{ "Id": "string", "RecordStatus_Id": "string", "Setting": "string" } - schema_name_id: 4251
- schema_scan_id: 162167766
- updated: 2026-04-17 03:09:51
-
Version 1716403
- created: 2026-04-16 03:07:52
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreverserebillsettingsset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreverserebillsettingsset`\n(\n `Id` string , `Setting` string , `RecordStatus_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_moloReverseRebillSettingsSet/2026-04-16/1776326602'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreverserebillsettingsset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloReverseRebillSettingsSet/2026-04-16/1776326602
- id: 1716403
- processed: 1
- raw_data:
{ "Id": 0, "RecordStatus_Id": 2, "Setting": 1 } - schema_attributes:
{ "Id": "string", "RecordStatus_Id": "string", "Setting": "string" } - schema_name_id: 4251
- schema_scan_id: 162111830
- updated: 2026-04-16 03:08:03
-
Version 1715304
- created: 2026-04-15 03:09:16
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreverserebillsettingsset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreverserebillsettingsset`\n(\n `Id` string , `Setting` string , `RecordStatus_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_moloReverseRebillSettingsSet/2026-04-15/1776240072'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreverserebillsettingsset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloReverseRebillSettingsSet/2026-04-15/1776240072
- id: 1715304
- processed: 1
- raw_data:
{ "Id": 0, "RecordStatus_Id": 2, "Setting": 1 } - schema_attributes:
{ "Id": "string", "RecordStatus_Id": "string", "Setting": "string" } - schema_name_id: 4251
- schema_scan_id: 162056088
- updated: 2026-04-15 03:09:27
-
Version 1714084
- created: 2026-04-14 03:08:44
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreverserebillsettingsset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreverserebillsettingsset`\n(\n `Id` string , `Setting` string , `RecordStatus_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_moloReverseRebillSettingsSet/2026-04-14/1776153836'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreverserebillsettingsset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloReverseRebillSettingsSet/2026-04-14/1776153836
- id: 1714084
- processed: 1
- raw_data:
{ "Id": 0, "RecordStatus_Id": 2, "Setting": 1 } - schema_attributes:
{ "Id": "string", "RecordStatus_Id": "string", "Setting": "string" } - schema_name_id: 4251
- schema_scan_id: 162000590
- updated: 2026-04-14 03:08:58
-
Version 1712852
- created: 2026-04-13 03:00:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreverserebillsettingsset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreverserebillsettingsset`\n(\n `Id` string , `Setting` string , `RecordStatus_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_moloReverseRebillSettingsSet/2026-04-13/1776066996'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreverserebillsettingsset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloReverseRebillSettingsSet/2026-04-13/1776066996
- id: 1712852
- processed: 1
- raw_data:
{ "Id": 0, "RecordStatus_Id": 2, "Setting": 1 } - schema_attributes:
{ "Id": "string", "RecordStatus_Id": "string", "Setting": "string" } - schema_name_id: 4251
- schema_scan_id: 161941939
- updated: 2026-04-13 03:01:00
-
Version 1711647
- created: 2026-04-12 03:02:33
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreverserebillsettingsset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreverserebillsettingsset`\n(\n `Id` string , `Setting` string , `RecordStatus_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_moloReverseRebillSettingsSet/2026-04-12/1775980708'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreverserebillsettingsset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloReverseRebillSettingsSet/2026-04-12/1775980708
- id: 1711647
- processed: 1
- raw_data:
{ "Id": 0, "RecordStatus_Id": 2, "Setting": 1 } - schema_attributes:
{ "Id": "string", "RecordStatus_Id": "string", "Setting": "string" } - schema_name_id: 4251
- schema_scan_id: 161892935
- updated: 2026-04-12 03:02:47
-
Version 1710416
- created: 2026-04-11 03:05:11
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreverserebillsettingsset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreverserebillsettingsset`\n(\n `Id` string , `Setting` string , `RecordStatus_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_moloReverseRebillSettingsSet/2026-04-11/1775894475'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreverserebillsettingsset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloReverseRebillSettingsSet/2026-04-11/1775894475
- id: 1710416
- processed: 1
- raw_data:
{ "Id": 0, "RecordStatus_Id": 2, "Setting": 1 } - schema_attributes:
{ "Id": "string", "RecordStatus_Id": "string", "Setting": "string" } - schema_name_id: 4251
- schema_scan_id: 161841196
- updated: 2026-04-11 03:05:25
-
Version 1709393
- created: 2026-04-10 03:11:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreverserebillsettingsset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreverserebillsettingsset`\n(\n `Id` string , `Setting` string , `RecordStatus_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_moloReverseRebillSettingsSet/2026-04-10/1775808232'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreverserebillsettingsset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloReverseRebillSettingsSet/2026-04-10/1775808232
- id: 1709393
- processed: 1
- raw_data:
{ "Id": 0, "RecordStatus_Id": 2, "Setting": 1 } - schema_attributes:
{ "Id": "string", "RecordStatus_Id": "string", "Setting": "string" } - schema_name_id: 4251
- schema_scan_id: 161786096
- updated: 2026-04-10 03:12:00
-
Version 1708191
- created: 2026-04-09 03:06:32
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreverserebillsettingsset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreverserebillsettingsset`\n(\n `Id` string , `Setting` string , `RecordStatus_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_moloReverseRebillSettingsSet/2026-04-09/1775721566'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreverserebillsettingsset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloReverseRebillSettingsSet/2026-04-09/1775721566
- id: 1708191
- processed: 1
- raw_data:
{ "Id": 0, "RecordStatus_Id": 2, "Setting": 1 } - schema_attributes:
{ "Id": "string", "RecordStatus_Id": "string", "Setting": "string" } - schema_name_id: 4251
- schema_scan_id: 161730430
- updated: 2026-04-09 03:06:46
-
Version 1706988
- created: 2026-04-08 03:09:02
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreverserebillsettingsset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreverserebillsettingsset`\n(\n `Id` string , `Setting` string , `RecordStatus_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_moloReverseRebillSettingsSet/2026-04-08/1775635394'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreverserebillsettingsset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloReverseRebillSettingsSet/2026-04-08/1775635394
- id: 1706988
- processed: 1
- raw_data:
{ "Id": 0, "RecordStatus_Id": 2, "Setting": 1 } - schema_attributes:
{ "Id": "string", "RecordStatus_Id": "string", "Setting": "string" } - schema_name_id: 4251
- schema_scan_id: 161675646
- updated: 2026-04-08 03:09:16
-
Version 1705774
- created: 2026-04-07 02:59:44
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreverserebillsettingsset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreverserebillsettingsset`\n(\n `Id` string , `Setting` string , `RecordStatus_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_moloReverseRebillSettingsSet/2026-04-07/1775548550'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreverserebillsettingsset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloReverseRebillSettingsSet/2026-04-07/1775548550
- id: 1705774
- processed: 1
- raw_data:
{ "Id": 0, "RecordStatus_Id": 2, "Setting": 1 } - schema_attributes:
{ "Id": "string", "RecordStatus_Id": "string", "Setting": "string" } - schema_name_id: 4251
- schema_scan_id: 161618672
- updated: 2026-04-07 02:59:58
-
Version 1704617
- created: 2026-04-06 03:10:50
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreverserebillsettingsset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreverserebillsettingsset`\n(\n `Id` string , `Setting` string , `RecordStatus_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_moloReverseRebillSettingsSet/2026-04-06/1775462510'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreverserebillsettingsset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloReverseRebillSettingsSet/2026-04-06/1775462510
- id: 1704617
- processed: 1
- raw_data:
{ "Id": 0, "RecordStatus_Id": 2, "Setting": 1 } - schema_attributes:
{ "Id": "string", "RecordStatus_Id": "string", "Setting": "string" } - schema_name_id: 4251
- schema_scan_id: 161561765
- updated: 2026-04-06 03:11:01
-
Version 1703301
- created: 2026-04-05 03:05:08
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreverserebillsettingsset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreverserebillsettingsset`\n(\n `Id` string , `Setting` string , `RecordStatus_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_moloReverseRebillSettingsSet/2026-04-05/1775376136'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreverserebillsettingsset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloReverseRebillSettingsSet/2026-04-05/1775376136
- id: 1703301
- processed: 1
- raw_data:
{ "Id": 0, "RecordStatus_Id": 2, "Setting": 1 } - schema_attributes:
{ "Id": "string", "RecordStatus_Id": "string", "Setting": "string" } - schema_name_id: 4251
- schema_scan_id: 161514878
- updated: 2026-04-05 03:05:22
-
Version 1702109
- created: 2026-04-04 03:03:19
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreverserebillsettingsset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreverserebillsettingsset`\n(\n `Id` string , `Setting` string , `RecordStatus_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_moloReverseRebillSettingsSet/2026-04-04/1775289619'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreverserebillsettingsset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloReverseRebillSettingsSet/2026-04-04/1775289619
- id: 1702109
- processed: 1
- raw_data:
{ "Id": 0, "RecordStatus_Id": 2, "Setting": 1 } - schema_attributes:
{ "Id": "string", "RecordStatus_Id": "string", "Setting": "string" } - schema_name_id: 4251
- schema_scan_id: 161460236
- updated: 2026-04-04 03:03:30
-
Version 1700943
- created: 2026-04-03 03:09:54
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreverserebillsettingsset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreverserebillsettingsset`\n(\n `Id` string , `Setting` string , `RecordStatus_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_moloReverseRebillSettingsSet/2026-04-03/1775203392'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreverserebillsettingsset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloReverseRebillSettingsSet/2026-04-03/1775203392
- id: 1700943
- processed: 1
- raw_data:
{ "Id": 0, "RecordStatus_Id": 2, "Setting": 1 } - schema_attributes:
{ "Id": "string", "RecordStatus_Id": "string", "Setting": "string" } - schema_name_id: 4251
- schema_scan_id: 161401901
- updated: 2026-04-03 03:10:08
Schema Scans: 15
Last at 2026-04-17 03:09:37
-
Scan 162167766
- duration: 0:00:14.010628
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162167766
- 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_moloReverseRebillSettingsSet/2026-04-17/1776412848", "key": "raw/molo_moloReverseRebillSettingsSet/2026-04-17/1776412848/ReverseRebillSettingsSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloReverseRebillSettingsSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6282051202150382768, "service_name": "drive-thru", "span_id": 15000520296939415122, "trace_id": 2027620770808706450 } } - running: False
- schema_name_id: 4251
- start_time: 2026-04-17 03:09:37
- success: True
- trace_id: 2027620770808706450
-
Scan 162111830
- duration: 0:00:11.543636
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162111830
- 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_moloReverseRebillSettingsSet/2026-04-16/1776326602", "key": "raw/molo_moloReverseRebillSettingsSet/2026-04-16/1776326602/ReverseRebillSettingsSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloReverseRebillSettingsSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15000329375777706613, "service_name": "drive-thru", "span_id": 17531279933317896587, "trace_id": 15325786331503063956 } } - running: False
- schema_name_id: 4251
- start_time: 2026-04-16 03:07:52
- success: True
- trace_id: 15325786331503063956
-
Scan 162056088
- duration: 0:00:11.485523
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162056088
- 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_moloReverseRebillSettingsSet/2026-04-15/1776240072", "key": "raw/molo_moloReverseRebillSettingsSet/2026-04-15/1776240072/ReverseRebillSettingsSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloReverseRebillSettingsSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5315114998493594109, "service_name": "drive-thru", "span_id": 13229311226117097251, "trace_id": 16023712917492799328 } } - running: False
- schema_name_id: 4251
- start_time: 2026-04-15 03:09:16
- success: True
- trace_id: 16023712917492799328
-
Scan 162000590
- duration: 0:00:14.084475
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162000590
- 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_moloReverseRebillSettingsSet/2026-04-14/1776153836", "key": "raw/molo_moloReverseRebillSettingsSet/2026-04-14/1776153836/ReverseRebillSettingsSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloReverseRebillSettingsSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 719778057537790656, "service_name": "drive-thru", "span_id": 9994945162154824526, "trace_id": 214094039595054053 } } - running: False
- schema_name_id: 4251
- start_time: 2026-04-14 03:08:44
- success: True
- trace_id: 214094039595054053
-
Scan 161941939
- duration: 0:00:14.467576
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161941939
- 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_moloReverseRebillSettingsSet/2026-04-13/1776066996", "key": "raw/molo_moloReverseRebillSettingsSet/2026-04-13/1776066996/ReverseRebillSettingsSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloReverseRebillSettingsSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10363085775595235390, "service_name": "drive-thru", "span_id": 15236042730947607115, "trace_id": 9577011174050744200 } } - running: False
- schema_name_id: 4251
- start_time: 2026-04-13 03:00:46
- success: True
- trace_id: 9577011174050744200
-
Scan 161892935
- duration: 0:00:14.066949
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161892935
- 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_moloReverseRebillSettingsSet/2026-04-12/1775980708", "key": "raw/molo_moloReverseRebillSettingsSet/2026-04-12/1775980708/ReverseRebillSettingsSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloReverseRebillSettingsSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14533616594937411283, "service_name": "drive-thru", "span_id": 16224639464798420472, "trace_id": 10455545932983709393 } } - running: False
- schema_name_id: 4251
- start_time: 2026-04-12 03:02:33
- success: True
- trace_id: 10455545932983709393
-
Scan 161841196
- duration: 0:00:14.047958
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161841196
- 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_moloReverseRebillSettingsSet/2026-04-11/1775894475", "key": "raw/molo_moloReverseRebillSettingsSet/2026-04-11/1775894475/ReverseRebillSettingsSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloReverseRebillSettingsSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15529373828990372970, "service_name": "drive-thru", "span_id": 541058164111799291, "trace_id": 12847089556965117824 } } - running: False
- schema_name_id: 4251
- start_time: 2026-04-11 03:05:11
- success: True
- trace_id: 12847089556965117824
-
Scan 161786096
- duration: 0:00:14.213896
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161786096
- 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_moloReverseRebillSettingsSet/2026-04-10/1775808232", "key": "raw/molo_moloReverseRebillSettingsSet/2026-04-10/1775808232/ReverseRebillSettingsSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloReverseRebillSettingsSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3943551077118403824, "service_name": "drive-thru", "span_id": 5100754115263817065, "trace_id": 8403546568159366118 } } - running: False
- schema_name_id: 4251
- start_time: 2026-04-10 03:11:46
- success: True
- trace_id: 8403546568159366118
-
Scan 161730430
- duration: 0:00:14.019985
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161730430
- 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_moloReverseRebillSettingsSet/2026-04-09/1775721566", "key": "raw/molo_moloReverseRebillSettingsSet/2026-04-09/1775721566/ReverseRebillSettingsSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloReverseRebillSettingsSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2676485968886799491, "service_name": "drive-thru", "span_id": 1958511092723463828, "trace_id": 7804244261207036108 } } - running: False
- schema_name_id: 4251
- start_time: 2026-04-09 03:06:32
- success: True
- trace_id: 7804244261207036108
-
Scan 161675646
- duration: 0:00:13.973417
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161675646
- 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_moloReverseRebillSettingsSet/2026-04-08/1775635394", "key": "raw/molo_moloReverseRebillSettingsSet/2026-04-08/1775635394/ReverseRebillSettingsSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloReverseRebillSettingsSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1295348331560956391, "service_name": "drive-thru", "span_id": 17415898889571590308, "trace_id": 70325148965188012 } } - running: False
- schema_name_id: 4251
- start_time: 2026-04-08 03:09:02
- success: True
- trace_id: 70325148965188012
-
Scan 161618672
- duration: 0:00:14.026103
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161618672
- 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_moloReverseRebillSettingsSet/2026-04-07/1775548550", "key": "raw/molo_moloReverseRebillSettingsSet/2026-04-07/1775548550/ReverseRebillSettingsSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloReverseRebillSettingsSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6700620756370459662, "service_name": "drive-thru", "span_id": 1175914090916000131, "trace_id": 12265467920223080242 } } - running: False
- schema_name_id: 4251
- start_time: 2026-04-07 02:59:44
- success: True
- trace_id: 12265467920223080242
-
Scan 161561765
- duration: 0:00:11.555212
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161561765
- 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_moloReverseRebillSettingsSet/2026-04-06/1775462510", "key": "raw/molo_moloReverseRebillSettingsSet/2026-04-06/1775462510/ReverseRebillSettingsSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloReverseRebillSettingsSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12343726743175461219, "service_name": "drive-thru", "span_id": 766390535432402295, "trace_id": 2938456664387905981 } } - running: False
- schema_name_id: 4251
- start_time: 2026-04-06 03:10:50
- success: True
- trace_id: 2938456664387905981
-
Scan 161514878
- duration: 0:00:14.093160
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161514878
- 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_moloReverseRebillSettingsSet/2026-04-05/1775376136", "key": "raw/molo_moloReverseRebillSettingsSet/2026-04-05/1775376136/ReverseRebillSettingsSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloReverseRebillSettingsSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5769805772244430087, "service_name": "drive-thru", "span_id": 12434444320202221475, "trace_id": 395263263023638242 } } - running: False
- schema_name_id: 4251
- start_time: 2026-04-05 03:05:08
- success: True
- trace_id: 395263263023638242
-
Scan 161460236
- duration: 0:00:11.551479
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161460236
- 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_moloReverseRebillSettingsSet/2026-04-04/1775289619", "key": "raw/molo_moloReverseRebillSettingsSet/2026-04-04/1775289619/ReverseRebillSettingsSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloReverseRebillSettingsSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6306969982718130838, "service_name": "drive-thru", "span_id": 9064668440639219784, "trace_id": 16152833247580884101 } } - running: False
- schema_name_id: 4251
- start_time: 2026-04-04 03:03:19
- success: True
- trace_id: 16152833247580884101
-
Scan 161401901
- duration: 0:00:14.185670
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161401901
- 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_moloReverseRebillSettingsSet/2026-04-03/1775203392", "key": "raw/molo_moloReverseRebillSettingsSet/2026-04-03/1775203392/ReverseRebillSettingsSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloReverseRebillSettingsSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7578047349083062190, "service_name": "drive-thru", "span_id": 12365635666515291934, "trace_id": 15084832316614362038 } } - running: False
- schema_name_id: 4251
- start_time: 2026-04-03 03:09:54
- success: True
- trace_id: 15084832316614362038
- attributes:
{ "Id": "string", "RecordStatus_Id": "string", "Setting": "string" } - created: 2026-04-17 03:09:38
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreverserebillsettingsset`\n(\n `Id` string , `Setting` string , `RecordStatus_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_moloReverseRebillSettingsSet/2026-04-17/1776412848'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreverserebillsettingsset`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreverserebillsettingsset" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2025-07-11 02:15:38",
"disabled": false,
"format": "raw",
"id": 4251,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "molo_moloreverserebillsettingsset"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"Id": "string",
"RecordStatus_Id": "string",
"Setting": "string"
},
"created": "2026-04-17 03:09:38",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreverserebillsettingsset`\n(\n `Id` string , `Setting` string , `RecordStatus_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_moloReverseRebillSettingsSet/2026-04-17/1776412848'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreverserebillsettingsset`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreverserebillsettingsset"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}