Schema Info
Schema Name: sfdl_prod_drivethru.molo_molotransientchargemethods
- created: 2023-10-17 02:03:13
- disabled: False
- format: raw
- id: 1811
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "molo_molotransientchargemethods" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717811
- created: 2026-04-17 03:12:43
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientchargemethods`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientchargemethods`\n(\n `Id` string , `Name` string , `TimePeriodForBilling` string , `Abbreviation` 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_moloTransientChargeMethods/2026-04-17/1776413222'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientchargemethods" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientChargeMethods/2026-04-17/1776413222
- id: 1717811
- processed: 1
- raw_data:
{ "Abbreviation": 3, "Id": 0, "Name": 1, "TimePeriodForBilling": 2 } - schema_attributes:
{ "Abbreviation": "string", "Id": "string", "Name": "string", "TimePeriodForBilling": "string" } - schema_name_id: 1811
- schema_scan_id: 162167847
- updated: 2026-04-17 03:12:57
-
Version 1716587
- created: 2026-04-16 03:14:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientchargemethods`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientchargemethods`\n(\n `Id` string , `Name` string , `TimePeriodForBilling` string , `Abbreviation` 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_moloTransientChargeMethods/2026-04-16/1776326745'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientchargemethods" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientChargeMethods/2026-04-16/1776326745
- id: 1716587
- processed: 1
- raw_data:
{ "Abbreviation": 3, "Id": 0, "Name": 1, "TimePeriodForBilling": 2 } - schema_attributes:
{ "Abbreviation": "string", "Id": "string", "Name": "string", "TimePeriodForBilling": "string" } - schema_name_id: 1811
- schema_scan_id: 162112052
- updated: 2026-04-16 03:15:08
-
Version 1715350
- created: 2026-04-15 03:11:41
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientchargemethods`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientchargemethods`\n(\n `Id` string , `Name` string , `TimePeriodForBilling` string , `Abbreviation` 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_moloTransientChargeMethods/2026-04-15/1776240206'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientchargemethods" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientChargeMethods/2026-04-15/1776240206
- id: 1715350
- processed: 1
- raw_data:
{ "Abbreviation": 3, "Id": 0, "Name": 1, "TimePeriodForBilling": 2 } - schema_attributes:
{ "Abbreviation": "string", "Id": "string", "Name": "string", "TimePeriodForBilling": "string" } - schema_name_id: 1811
- schema_scan_id: 162056148
- updated: 2026-04-15 03:11:52
-
Version 1714124
- created: 2026-04-14 03:10:14
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientchargemethods`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientchargemethods`\n(\n `Id` string , `Name` string , `TimePeriodForBilling` string , `Abbreviation` 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_moloTransientChargeMethods/2026-04-14/1776154171'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientchargemethods" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientChargeMethods/2026-04-14/1776154171
- id: 1714124
- processed: 1
- raw_data:
{ "Abbreviation": 3, "Id": 0, "Name": 1, "TimePeriodForBilling": 2 } - schema_attributes:
{ "Abbreviation": "string", "Id": "string", "Name": "string", "TimePeriodForBilling": "string" } - schema_name_id: 1811
- schema_scan_id: 162000641
- updated: 2026-04-14 03:10:28
-
Version 1712942
- created: 2026-04-13 03:05:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientchargemethods`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientchargemethods`\n(\n `Id` string , `Name` string , `TimePeriodForBilling` string , `Abbreviation` 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_moloTransientChargeMethods/2026-04-13/1776067165'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientchargemethods" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientChargeMethods/2026-04-13/1776067165
- id: 1712942
- processed: 1
- raw_data:
{ "Abbreviation": 3, "Id": 0, "Name": 1, "TimePeriodForBilling": 2 } - schema_attributes:
{ "Abbreviation": "string", "Id": "string", "Name": "string", "TimePeriodForBilling": "string" } - schema_name_id: 1811
- schema_scan_id: 161942738
- updated: 2026-04-13 03:05:57
-
Version 1711751
- created: 2026-04-12 03:07:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientchargemethods`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientchargemethods`\n(\n `Id` string , `Name` string , `TimePeriodForBilling` string , `Abbreviation` 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_moloTransientChargeMethods/2026-04-12/1775980867'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientchargemethods" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientChargeMethods/2026-04-12/1775980867
- id: 1711751
- processed: 1
- raw_data:
{ "Abbreviation": 3, "Id": 0, "Name": 1, "TimePeriodForBilling": 2 } - schema_attributes:
{ "Abbreviation": "string", "Id": "string", "Name": "string", "TimePeriodForBilling": "string" } - schema_name_id: 1811
- schema_scan_id: 161893451
- updated: 2026-04-12 03:08:07
-
Version 1710524
- created: 2026-04-11 03:09:21
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientchargemethods`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientchargemethods`\n(\n `Id` string , `Name` string , `TimePeriodForBilling` string , `Abbreviation` 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_moloTransientChargeMethods/2026-04-11/1775894642'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientchargemethods" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientChargeMethods/2026-04-11/1775894642
- id: 1710524
- processed: 1
- raw_data:
{ "Abbreviation": 3, "Id": 0, "Name": 1, "TimePeriodForBilling": 2 } - schema_attributes:
{ "Abbreviation": "string", "Id": "string", "Name": "string", "TimePeriodForBilling": "string" } - schema_name_id: 1811
- schema_scan_id: 161841319
- updated: 2026-04-11 03:09:32
-
Version 1709322
- created: 2026-04-10 03:09:01
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientchargemethods`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientchargemethods`\n(\n `Id` string , `Name` string , `TimePeriodForBilling` string , `Abbreviation` 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_moloTransientChargeMethods/2026-04-10/1775808398'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientchargemethods" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientChargeMethods/2026-04-10/1775808398
- id: 1709322
- processed: 1
- raw_data:
{ "Abbreviation": 3, "Id": 0, "Name": 1, "TimePeriodForBilling": 2 } - schema_attributes:
{ "Abbreviation": "string", "Id": "string", "Name": "string", "TimePeriodForBilling": "string" } - schema_name_id: 1811
- schema_scan_id: 161786022
- updated: 2026-04-10 03:09:14
-
Version 1708251
- created: 2026-04-09 03:09:04
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientchargemethods`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientchargemethods`\n(\n `Id` string , `Name` string , `TimePeriodForBilling` string , `Abbreviation` 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_moloTransientChargeMethods/2026-04-09/1775721727'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientchargemethods" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientChargeMethods/2026-04-09/1775721727
- id: 1708251
- processed: 1
- raw_data:
{ "Abbreviation": 3, "Id": 0, "Name": 1, "TimePeriodForBilling": 2 } - schema_attributes:
{ "Abbreviation": "string", "Id": "string", "Name": "string", "TimePeriodForBilling": "string" } - schema_name_id: 1811
- schema_scan_id: 161730520
- updated: 2026-04-09 03:09:18
-
Version 1706923
- created: 2026-04-08 03:06:28
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientchargemethods`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientchargemethods`\n(\n `Id` string , `Name` string , `TimePeriodForBilling` string , `Abbreviation` 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_moloTransientChargeMethods/2026-04-08/1775635557'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientchargemethods" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientChargeMethods/2026-04-08/1775635557
- id: 1706923
- processed: 1
- raw_data:
{ "Abbreviation": 3, "Id": 0, "Name": 1, "TimePeriodForBilling": 2 } - schema_attributes:
{ "Abbreviation": "string", "Id": "string", "Name": "string", "TimePeriodForBilling": "string" } - schema_name_id: 1811
- schema_scan_id: 161675557
- updated: 2026-04-08 03:06:42
-
Version 1705855
- created: 2026-04-07 03:03:38
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientchargemethods`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientchargemethods`\n(\n `Id` string , `Name` string , `TimePeriodForBilling` string , `Abbreviation` 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_moloTransientChargeMethods/2026-04-07/1775548718'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientchargemethods" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientChargeMethods/2026-04-07/1775548718
- id: 1705855
- processed: 1
- raw_data:
{ "Abbreviation": 3, "Id": 0, "Name": 1, "TimePeriodForBilling": 2 } - schema_attributes:
{ "Abbreviation": "string", "Id": "string", "Name": "string", "TimePeriodForBilling": "string" } - schema_name_id: 1811
- schema_scan_id: 161619366
- updated: 2026-04-07 03:03:49
-
Version 1704493
- created: 2026-04-06 03:05:50
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientchargemethods`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientchargemethods`\n(\n `Id` string , `Name` string , `TimePeriodForBilling` string , `Abbreviation` 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_moloTransientChargeMethods/2026-04-06/1775462669'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientchargemethods" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientChargeMethods/2026-04-06/1775462669
- id: 1704493
- processed: 1
- raw_data:
{ "Abbreviation": 3, "Id": 0, "Name": 1, "TimePeriodForBilling": 2 } - schema_attributes:
{ "Abbreviation": "string", "Id": "string", "Name": "string", "TimePeriodForBilling": "string" } - schema_name_id: 1811
- schema_scan_id: 161561581
- updated: 2026-04-06 03:06:04
-
Version 1703448
- created: 2026-04-05 03:10:52
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientchargemethods`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientchargemethods`\n(\n `Id` string , `Name` string , `TimePeriodForBilling` string , `Abbreviation` 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_moloTransientChargeMethods/2026-04-05/1775376299'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientchargemethods" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientChargeMethods/2026-04-05/1775376299
- id: 1703448
- processed: 1
- raw_data:
{ "Abbreviation": 3, "Id": 0, "Name": 1, "TimePeriodForBilling": 2 } - schema_attributes:
{ "Abbreviation": "string", "Id": "string", "Name": "string", "TimePeriodForBilling": "string" } - schema_name_id: 1811
- schema_scan_id: 161515038
- updated: 2026-04-05 03:11:03
-
Version 1702187
- created: 2026-04-04 03:06:33
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientchargemethods`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientchargemethods`\n(\n `Id` string , `Name` string , `TimePeriodForBilling` string , `Abbreviation` 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_moloTransientChargeMethods/2026-04-04/1775289783'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientchargemethods" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientChargeMethods/2026-04-04/1775289783
- id: 1702187
- processed: 1
- raw_data:
{ "Abbreviation": 3, "Id": 0, "Name": 1, "TimePeriodForBilling": 2 } - schema_attributes:
{ "Abbreviation": "string", "Id": "string", "Name": "string", "TimePeriodForBilling": "string" } - schema_name_id: 1811
- schema_scan_id: 161460432
- updated: 2026-04-04 03:06:44
-
Version 1701024
- created: 2026-04-03 03:13:27
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientchargemethods`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientchargemethods`\n(\n `Id` string , `Name` string , `TimePeriodForBilling` string , `Abbreviation` 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_moloTransientChargeMethods/2026-04-03/1775203548'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientchargemethods" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientChargeMethods/2026-04-03/1775203548
- id: 1701024
- processed: 1
- raw_data:
{ "Abbreviation": 3, "Id": 0, "Name": 1, "TimePeriodForBilling": 2 } - schema_attributes:
{ "Abbreviation": "string", "Id": "string", "Name": "string", "TimePeriodForBilling": "string" } - schema_name_id: 1811
- schema_scan_id: 161402001
- updated: 2026-04-03 03:13:41
Schema Scans: 15
Last at 2026-04-17 03:12:43
-
Scan 162167847
- duration: 0:00:14.140069
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162167847
- 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_moloTransientChargeMethods/2026-04-17/1776413222", "key": "raw/molo_moloTransientChargeMethods/2026-04-17/1776413222/TransientChargeMethods.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransientChargeMethods", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16241364083778862140, "service_name": "drive-thru", "span_id": 4886731051597662844, "trace_id": 14802442561360888689 } } - running: False
- schema_name_id: 1811
- start_time: 2026-04-17 03:12:43
- success: True
- trace_id: 14802442561360888689
-
Scan 162112052
- duration: 0:00:11.756373
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162112052
- 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_moloTransientChargeMethods/2026-04-16/1776326745", "key": "raw/molo_moloTransientChargeMethods/2026-04-16/1776326745/TransientChargeMethods.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransientChargeMethods", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5818553782163626442, "service_name": "drive-thru", "span_id": 4178980548434948731, "trace_id": 10123468500644342467 } } - running: False
- schema_name_id: 1811
- start_time: 2026-04-16 03:14:56
- success: True
- trace_id: 10123468500644342467
-
Scan 162056148
- duration: 0:00:11.623941
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162056148
- 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_moloTransientChargeMethods/2026-04-15/1776240206", "key": "raw/molo_moloTransientChargeMethods/2026-04-15/1776240206/TransientChargeMethods.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransientChargeMethods", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6059218605069953327, "service_name": "drive-thru", "span_id": 3441639606734280000, "trace_id": 2966592370733034127 } } - running: False
- schema_name_id: 1811
- start_time: 2026-04-15 03:11:40
- success: True
- trace_id: 2966592370733034127
-
Scan 162000641
- duration: 0:00:14.110154
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162000641
- 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_moloTransientChargeMethods/2026-04-14/1776154171", "key": "raw/molo_moloTransientChargeMethods/2026-04-14/1776154171/TransientChargeMethods.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransientChargeMethods", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12539075741115649068, "service_name": "drive-thru", "span_id": 6161866430010177390, "trace_id": 13743772004399135794 } } - running: False
- schema_name_id: 1811
- start_time: 2026-04-14 03:10:14
- success: True
- trace_id: 13743772004399135794
-
Scan 161942738
- duration: 0:00:11.629207
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161942738
- 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_moloTransientChargeMethods/2026-04-13/1776067165", "key": "raw/molo_moloTransientChargeMethods/2026-04-13/1776067165/TransientChargeMethods.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransientChargeMethods", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16677203763447066772, "service_name": "drive-thru", "span_id": 11732044589477396311, "trace_id": 5807320323113921687 } } - running: False
- schema_name_id: 1811
- start_time: 2026-04-13 03:05:46
- success: True
- trace_id: 5807320323113921687
-
Scan 161893451
- duration: 0:00:11.596254
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161893451
- 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_moloTransientChargeMethods/2026-04-12/1775980867", "key": "raw/molo_moloTransientChargeMethods/2026-04-12/1775980867/TransientChargeMethods.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransientChargeMethods", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1111180361952229403, "service_name": "drive-thru", "span_id": 8793897476889155641, "trace_id": 17254844733883736794 } } - running: False
- schema_name_id: 1811
- start_time: 2026-04-12 03:07:55
- success: True
- trace_id: 17254844733883736794
-
Scan 161841319
- duration: 0:00:11.518907
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161841319
- 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_moloTransientChargeMethods/2026-04-11/1775894642", "key": "raw/molo_moloTransientChargeMethods/2026-04-11/1775894642/TransientChargeMethods.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransientChargeMethods", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13303461186229727670, "service_name": "drive-thru", "span_id": 3133145789125305593, "trace_id": 4485196706376004222 } } - running: False
- schema_name_id: 1811
- start_time: 2026-04-11 03:09:21
- success: True
- trace_id: 4485196706376004222
-
Scan 161786022
- duration: 0:00:14.129959
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161786022
- 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_moloTransientChargeMethods/2026-04-10/1775808398", "key": "raw/molo_moloTransientChargeMethods/2026-04-10/1775808398/TransientChargeMethods.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransientChargeMethods", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17462231490762558148, "service_name": "drive-thru", "span_id": 557191375700306483, "trace_id": 10167619353367633525 } } - running: False
- schema_name_id: 1811
- start_time: 2026-04-10 03:09:00
- success: True
- trace_id: 10167619353367633525
-
Scan 161730520
- duration: 0:00:14.223240
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161730520
- 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_moloTransientChargeMethods/2026-04-09/1775721727", "key": "raw/molo_moloTransientChargeMethods/2026-04-09/1775721727/TransientChargeMethods.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransientChargeMethods", "type": "drivethrucsv" }, "trace_context": { "parent_id": 35588852127639774, "service_name": "drive-thru", "span_id": 6864849622750337059, "trace_id": 13882344395745082613 } } - running: False
- schema_name_id: 1811
- start_time: 2026-04-09 03:09:04
- success: True
- trace_id: 13882344395745082613
-
Scan 161675557
- duration: 0:00:14.182147
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161675557
- 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_moloTransientChargeMethods/2026-04-08/1775635557", "key": "raw/molo_moloTransientChargeMethods/2026-04-08/1775635557/TransientChargeMethods.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransientChargeMethods", "type": "drivethrucsv" }, "trace_context": { "parent_id": 72005398049869233, "service_name": "drive-thru", "span_id": 10147121510154665176, "trace_id": 15663463787011508109 } } - running: False
- schema_name_id: 1811
- start_time: 2026-04-08 03:06:28
- success: True
- trace_id: 15663463787011508109
-
Scan 161619366
- duration: 0:00:11.601995
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161619366
- 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_moloTransientChargeMethods/2026-04-07/1775548718", "key": "raw/molo_moloTransientChargeMethods/2026-04-07/1775548718/TransientChargeMethods.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransientChargeMethods", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16291765774454835667, "service_name": "drive-thru", "span_id": 17653540892403756889, "trace_id": 6044154126753132335 } } - running: False
- schema_name_id: 1811
- start_time: 2026-04-07 03:03:38
- success: True
- trace_id: 6044154126753132335
-
Scan 161561581
- duration: 0:00:13.992682
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161561581
- 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_moloTransientChargeMethods/2026-04-06/1775462669", "key": "raw/molo_moloTransientChargeMethods/2026-04-06/1775462669/TransientChargeMethods.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransientChargeMethods", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5760182265322758828, "service_name": "drive-thru", "span_id": 5294720766520922423, "trace_id": 5883391378503661120 } } - running: False
- schema_name_id: 1811
- start_time: 2026-04-06 03:05:50
- success: True
- trace_id: 5883391378503661120
-
Scan 161515038
- duration: 0:00:11.496804
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161515038
- 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_moloTransientChargeMethods/2026-04-05/1775376299", "key": "raw/molo_moloTransientChargeMethods/2026-04-05/1775376299/TransientChargeMethods.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransientChargeMethods", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5146719649325881842, "service_name": "drive-thru", "span_id": 17755249499025747388, "trace_id": 14784670289437371185 } } - running: False
- schema_name_id: 1811
- start_time: 2026-04-05 03:10:52
- success: True
- trace_id: 14784670289437371185
-
Scan 161460432
- duration: 0:00:11.540085
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161460432
- 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_moloTransientChargeMethods/2026-04-04/1775289783", "key": "raw/molo_moloTransientChargeMethods/2026-04-04/1775289783/TransientChargeMethods.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransientChargeMethods", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14658442369662586653, "service_name": "drive-thru", "span_id": 9224428821935138229, "trace_id": 7714973915734856215 } } - running: False
- schema_name_id: 1811
- start_time: 2026-04-04 03:06:33
- success: True
- trace_id: 7714973915734856215
-
Scan 161402001
- duration: 0:00:14.196632
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161402001
- 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_moloTransientChargeMethods/2026-04-03/1775203548", "key": "raw/molo_moloTransientChargeMethods/2026-04-03/1775203548/TransientChargeMethods.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransientChargeMethods", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10671403888358114960, "service_name": "drive-thru", "span_id": 12209304344913828527, "trace_id": 4876605060243064378 } } - running: False
- schema_name_id: 1811
- start_time: 2026-04-03 03:13:27
- success: True
- trace_id: 4876605060243064378
- attributes:
{ "Abbreviation": "string", "Id": "string", "Name": "string", "TimePeriodForBilling": "string" } - created: 2026-04-17 03:12:43
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientchargemethods`\n(\n `Id` string , `Name` string , `TimePeriodForBilling` string , `Abbreviation` 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_moloTransientChargeMethods/2026-04-17/1776413222'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientchargemethods`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientchargemethods" }
- 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:13",
"disabled": false,
"format": "raw",
"id": 1811,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "molo_molotransientchargemethods"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"Abbreviation": "string",
"Id": "string",
"Name": "string",
"TimePeriodForBilling": "string"
},
"created": "2026-04-17 03:12:43",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientchargemethods`\n(\n `Id` string , `Name` string , `TimePeriodForBilling` string , `Abbreviation` 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_moloTransientChargeMethods/2026-04-17/1776413222'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientchargemethods`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientchargemethods"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}