Schema Info
Schema Name: sfdl_prod_drivethru.molo_molorecordstatusset
- created: 2023-10-17 01:56:26
- disabled: False
- format: raw
- id: 1631
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "molo_molorecordstatusset" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717699
- created: 2026-04-17 03:07:24
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecordstatusset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecordstatusset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-17/1776412821'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecordstatusset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-17/1776412821
- id: 1717699
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1631
- schema_scan_id: 162167690
- updated: 2026-04-17 03:07:38
-
Version 1716547
- created: 2026-04-16 03:13:25
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecordstatusset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecordstatusset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-16/1776326576'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecordstatusset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-16/1776326576
- id: 1716547
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1631
- schema_scan_id: 162112004
- updated: 2026-04-16 03:13:37
-
Version 1715248
- created: 2026-04-15 03:06:43
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecordstatusset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecordstatusset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-15/1776240046'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecordstatusset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-15/1776240046
- id: 1715248
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1631
- schema_scan_id: 162055986
- updated: 2026-04-15 03:06:55
-
Version 1714094
- created: 2026-04-14 03:09:05
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecordstatusset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecordstatusset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-14/1776153778'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecordstatusset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-14/1776153778
- id: 1714094
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1631
- schema_scan_id: 162000600
- updated: 2026-04-14 03:09:16
-
Version 1712820
- created: 2026-04-13 02:59:51
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecordstatusset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecordstatusset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-13/1776066970'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecordstatusset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-13/1776066970
- id: 1712820
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1631
- schema_scan_id: 161941820
- updated: 2026-04-13 03:00:05
-
Version 1711613
- created: 2026-04-12 03:01:28
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecordstatusset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecordstatusset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-12/1775980682'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecordstatusset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-12/1775980682
- id: 1711613
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1631
- schema_scan_id: 161892753
- updated: 2026-04-12 03:01:39
-
Version 1710406
- created: 2026-04-11 03:04:49
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecordstatusset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecordstatusset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-11/1775894448'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecordstatusset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-11/1775894448
- id: 1710406
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1631
- schema_scan_id: 161841179
- updated: 2026-04-11 03:05:03
-
Version 1709233
- created: 2026-04-10 03:05:40
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecordstatusset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecordstatusset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-10/1775808201'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecordstatusset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-10/1775808201
- id: 1709233
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1631
- schema_scan_id: 161785918
- updated: 2026-04-10 03:05:54
-
Version 1708102
- created: 2026-04-09 03:02:26
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecordstatusset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecordstatusset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-09/1775721539'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecordstatusset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-09/1775721539
- id: 1708102
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1631
- schema_scan_id: 161730179
- updated: 2026-04-09 03:02:40
-
Version 1707010
- created: 2026-04-08 03:09:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecordstatusset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecordstatusset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-08/1775635367'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecordstatusset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-08/1775635367
- id: 1707010
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1631
- schema_scan_id: 161675674
- updated: 2026-04-08 03:10:07
-
Version 1705754
- created: 2026-04-07 02:58:57
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecordstatusset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecordstatusset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-07/1775548517'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecordstatusset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-07/1775548517
- id: 1705754
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1631
- schema_scan_id: 161618534
- updated: 2026-04-07 02:59:10
-
Version 1704526
- created: 2026-04-06 03:07:10
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecordstatusset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecordstatusset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-06/1775462484'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecordstatusset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-06/1775462484
- id: 1704526
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1631
- schema_scan_id: 161561630
- updated: 2026-04-06 03:07:23
-
Version 1703313
- created: 2026-04-05 03:05:40
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecordstatusset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecordstatusset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-05/1775376110'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecordstatusset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-05/1775376110
- id: 1703313
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1631
- schema_scan_id: 161514891
- updated: 2026-04-05 03:05:53
-
Version 1702181
- created: 2026-04-04 03:06:19
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecordstatusset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecordstatusset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-04/1775289594'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecordstatusset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-04/1775289594
- id: 1702181
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1631
- schema_scan_id: 161460422
- updated: 2026-04-04 03:06:30
-
Version 1700862
- created: 2026-04-03 03:06:21
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecordstatusset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecordstatusset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-03/1775203366'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecordstatusset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-03/1775203366
- id: 1700862
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1631
- schema_scan_id: 161401772
- updated: 2026-04-03 03:06:35
Schema Scans: 15
Last at 2026-04-17 03:07:24
-
Scan 162167690
- duration: 0:00:14.035207
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162167690
- 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_moloRecordStatusSet/2026-04-17/1776412821", "key": "raw/molo_moloRecordStatusSet/2026-04-17/1776412821/RecordStatusSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloRecordStatusSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14128301901050969383, "service_name": "drive-thru", "span_id": 103184812704270536, "trace_id": 13147150547080731471 } } - running: False
- schema_name_id: 1631
- start_time: 2026-04-17 03:07:24
- success: True
- trace_id: 13147150547080731471
-
Scan 162112004
- duration: 0:00:11.669843
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162112004
- 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_moloRecordStatusSet/2026-04-16/1776326576", "key": "raw/molo_moloRecordStatusSet/2026-04-16/1776326576/RecordStatusSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloRecordStatusSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15199057725959038264, "service_name": "drive-thru", "span_id": 8848089901161565557, "trace_id": 9911644848745185575 } } - running: False
- schema_name_id: 1631
- start_time: 2026-04-16 03:13:25
- success: True
- trace_id: 9911644848745185575
-
Scan 162055986
- duration: 0:00:11.436836
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162055986
- 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_moloRecordStatusSet/2026-04-15/1776240046", "key": "raw/molo_moloRecordStatusSet/2026-04-15/1776240046/RecordStatusSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloRecordStatusSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14895152917110509879, "service_name": "drive-thru", "span_id": 6760205963752210676, "trace_id": 4244968313091613452 } } - running: False
- schema_name_id: 1631
- start_time: 2026-04-15 03:06:43
- success: True
- trace_id: 4244968313091613452
-
Scan 162000600
- duration: 0:00:11.590041
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162000600
- 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_moloRecordStatusSet/2026-04-14/1776153778", "key": "raw/molo_moloRecordStatusSet/2026-04-14/1776153778/RecordStatusSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloRecordStatusSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14246451614380549743, "service_name": "drive-thru", "span_id": 2222338678350136864, "trace_id": 8970309703970045170 } } - running: False
- schema_name_id: 1631
- start_time: 2026-04-14 03:09:05
- success: True
- trace_id: 8970309703970045170
-
Scan 161941820
- duration: 0:00:14.051120
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161941820
- 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_moloRecordStatusSet/2026-04-13/1776066970", "key": "raw/molo_moloRecordStatusSet/2026-04-13/1776066970/RecordStatusSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloRecordStatusSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5599022201752291441, "service_name": "drive-thru", "span_id": 11446056885069329099, "trace_id": 4491617212716732861 } } - running: False
- schema_name_id: 1631
- start_time: 2026-04-13 02:59:51
- success: True
- trace_id: 4491617212716732861
-
Scan 161892753
- duration: 0:00:11.481472
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161892753
- 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_moloRecordStatusSet/2026-04-12/1775980682", "key": "raw/molo_moloRecordStatusSet/2026-04-12/1775980682/RecordStatusSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloRecordStatusSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10296789487319780488, "service_name": "drive-thru", "span_id": 11935364903891877930, "trace_id": 6619392353221798277 } } - running: False
- schema_name_id: 1631
- start_time: 2026-04-12 03:01:28
- success: True
- trace_id: 6619392353221798277
-
Scan 161841179
- duration: 0:00:14.003615
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161841179
- 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_moloRecordStatusSet/2026-04-11/1775894448", "key": "raw/molo_moloRecordStatusSet/2026-04-11/1775894448/RecordStatusSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloRecordStatusSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8680912900433255617, "service_name": "drive-thru", "span_id": 4474085367648594780, "trace_id": 15077124698716234853 } } - running: False
- schema_name_id: 1631
- start_time: 2026-04-11 03:04:49
- success: True
- trace_id: 15077124698716234853
-
Scan 161785918
- duration: 0:00:13.992029
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161785918
- 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_moloRecordStatusSet/2026-04-10/1775808201", "key": "raw/molo_moloRecordStatusSet/2026-04-10/1775808201/RecordStatusSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloRecordStatusSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7833505272789945929, "service_name": "drive-thru", "span_id": 16163390743949001770, "trace_id": 15188308269086714963 } } - running: False
- schema_name_id: 1631
- start_time: 2026-04-10 03:05:40
- success: True
- trace_id: 15188308269086714963
-
Scan 161730179
- duration: 0:00:14.370755
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161730179
- 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_moloRecordStatusSet/2026-04-09/1775721539", "key": "raw/molo_moloRecordStatusSet/2026-04-09/1775721539/RecordStatusSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloRecordStatusSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7814976077036297738, "service_name": "drive-thru", "span_id": 18255380705417753610, "trace_id": 12748647157003658755 } } - running: False
- schema_name_id: 1631
- start_time: 2026-04-09 03:02:26
- success: True
- trace_id: 12748647157003658755
-
Scan 161675674
- duration: 0:00:11.504751
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161675674
- 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_moloRecordStatusSet/2026-04-08/1775635367", "key": "raw/molo_moloRecordStatusSet/2026-04-08/1775635367/RecordStatusSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloRecordStatusSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16187183040968466475, "service_name": "drive-thru", "span_id": 3086600768504777550, "trace_id": 378862270880327379 } } - running: False
- schema_name_id: 1631
- start_time: 2026-04-08 03:09:56
- success: True
- trace_id: 378862270880327379
-
Scan 161618534
- duration: 0:00:13.994561
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161618534
- 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_moloRecordStatusSet/2026-04-07/1775548517", "key": "raw/molo_moloRecordStatusSet/2026-04-07/1775548517/RecordStatusSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloRecordStatusSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9654534723997086652, "service_name": "drive-thru", "span_id": 12733668147808793628, "trace_id": 6618398699501410907 } } - running: False
- schema_name_id: 1631
- start_time: 2026-04-07 02:58:57
- success: True
- trace_id: 6618398699501410907
-
Scan 161561630
- duration: 0:00:13.984723
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161561630
- 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_moloRecordStatusSet/2026-04-06/1775462484", "key": "raw/molo_moloRecordStatusSet/2026-04-06/1775462484/RecordStatusSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloRecordStatusSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13022751824676364239, "service_name": "drive-thru", "span_id": 6305337350766069226, "trace_id": 1884453335310866916 } } - running: False
- schema_name_id: 1631
- start_time: 2026-04-06 03:07:09
- success: True
- trace_id: 1884453335310866916
-
Scan 161514891
- duration: 0:00:14.054534
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161514891
- 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_moloRecordStatusSet/2026-04-05/1775376110", "key": "raw/molo_moloRecordStatusSet/2026-04-05/1775376110/RecordStatusSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloRecordStatusSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11116022671279482424, "service_name": "drive-thru", "span_id": 971998895968258254, "trace_id": 11603254675619362404 } } - running: False
- schema_name_id: 1631
- start_time: 2026-04-05 03:05:39
- success: True
- trace_id: 11603254675619362404
-
Scan 161460422
- duration: 0:00:11.383780
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161460422
- 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_moloRecordStatusSet/2026-04-04/1775289594", "key": "raw/molo_moloRecordStatusSet/2026-04-04/1775289594/RecordStatusSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloRecordStatusSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4656045421289132415, "service_name": "drive-thru", "span_id": 3955236483045096033, "trace_id": 7020774304270111385 } } - running: False
- schema_name_id: 1631
- start_time: 2026-04-04 03:06:19
- success: True
- trace_id: 7020774304270111385
-
Scan 161401772
- duration: 0:00:14.193802
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161401772
- 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_moloRecordStatusSet/2026-04-03/1775203366", "key": "raw/molo_moloRecordStatusSet/2026-04-03/1775203366/RecordStatusSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloRecordStatusSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10764277416924957611, "service_name": "drive-thru", "span_id": 7299219958501904249, "trace_id": 13563733174078466263 } } - running: False
- schema_name_id: 1631
- start_time: 2026-04-03 03:06:21
- success: True
- trace_id: 13563733174078466263
- attributes:
{ "Id": "string", "Name": "string" } - created: 2026-04-17 03:07:24
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecordstatusset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-17/1776412821'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecordstatusset`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecordstatusset" }
- 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 01:56:26",
"disabled": false,
"format": "raw",
"id": 1631,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "molo_molorecordstatusset"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"Id": "string",
"Name": "string"
},
"created": "2026-04-17 03:07:24",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecordstatusset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecordStatusSet/2026-04-17/1776412821'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecordstatusset`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecordstatusset"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}