Schema Info
Schema Name: sfdl_prod_drivethru.molo_molologinprovidersset
- created: 2023-10-17 01:56:46
- disabled: False
- format: raw
- id: 1641
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "molo_molologinprovidersset" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717664
- created: 2026-04-17 03:05:52
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molologinprovidersset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molologinprovidersset`\n(\n `Id` string , `ProviderName` string , `URL` 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_moloLoginProvidersSet/2026-04-17/1776412805'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molologinprovidersset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloLoginProvidersSet/2026-04-17/1776412805
- id: 1717664
- processed: 1
- raw_data:
{ "Id": 0, "ProviderName": 1, "RecordStatus_Id": 3, "URL": 2 } - schema_attributes:
{ "Id": "string", "ProviderName": "string", "RecordStatus_Id": "string", "URL": "string" } - schema_name_id: 1641
- schema_scan_id: 162167641
- updated: 2026-04-17 03:06:06
-
Version 1716424
- created: 2026-04-16 03:08:43
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molologinprovidersset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molologinprovidersset`\n(\n `Id` string , `ProviderName` string , `URL` 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_moloLoginProvidersSet/2026-04-16/1776326557'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molologinprovidersset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloLoginProvidersSet/2026-04-16/1776326557
- id: 1716424
- processed: 1
- raw_data:
{ "Id": 0, "ProviderName": 1, "RecordStatus_Id": 3, "URL": 2 } - schema_attributes:
{ "Id": "string", "ProviderName": "string", "RecordStatus_Id": "string", "URL": "string" } - schema_name_id: 1641
- schema_scan_id: 162111858
- updated: 2026-04-16 03:08:54
-
Version 1715220
- created: 2026-04-15 03:05:35
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molologinprovidersset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molologinprovidersset`\n(\n `Id` string , `ProviderName` string , `URL` 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_moloLoginProvidersSet/2026-04-15/1776240028'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molologinprovidersset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloLoginProvidersSet/2026-04-15/1776240028
- id: 1715220
- processed: 1
- raw_data:
{ "Id": 0, "ProviderName": 1, "RecordStatus_Id": 3, "URL": 2 } - schema_attributes:
{ "Id": "string", "ProviderName": "string", "RecordStatus_Id": "string", "URL": "string" } - schema_name_id: 1641
- schema_scan_id: 162055949
- updated: 2026-04-15 03:05:48
-
Version 1713959
- created: 2026-04-14 03:03:31
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molologinprovidersset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molologinprovidersset`\n(\n `Id` string , `ProviderName` string , `URL` 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_moloLoginProvidersSet/2026-04-14/1776153754'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molologinprovidersset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloLoginProvidersSet/2026-04-14/1776153754
- id: 1713959
- processed: 1
- raw_data:
{ "Id": 0, "ProviderName": 1, "RecordStatus_Id": 3, "URL": 2 } - schema_attributes:
{ "Id": "string", "ProviderName": "string", "RecordStatus_Id": "string", "URL": "string" } - schema_name_id: 1641
- schema_scan_id: 162000388
- updated: 2026-04-14 03:03:45
-
Version 1712770
- created: 2026-04-13 02:58:21
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molologinprovidersset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molologinprovidersset`\n(\n `Id` string , `ProviderName` string , `URL` 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_moloLoginProvidersSet/2026-04-13/1776066950'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molologinprovidersset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloLoginProvidersSet/2026-04-13/1776066950
- id: 1712770
- processed: 1
- raw_data:
{ "Id": 0, "ProviderName": 1, "RecordStatus_Id": 3, "URL": 2 } - schema_attributes:
{ "Id": "string", "ProviderName": "string", "RecordStatus_Id": "string", "URL": "string" } - schema_name_id: 1641
- schema_scan_id: 161941664
- updated: 2026-04-13 02:58:33
-
Version 1711584
- created: 2026-04-12 03:00:31
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molologinprovidersset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molologinprovidersset`\n(\n `Id` string , `ProviderName` string , `URL` 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_moloLoginProvidersSet/2026-04-12/1775980662'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molologinprovidersset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloLoginProvidersSet/2026-04-12/1775980662
- id: 1711584
- processed: 1
- raw_data:
{ "Id": 0, "ProviderName": 1, "RecordStatus_Id": 3, "URL": 2 } - schema_attributes:
{ "Id": "string", "ProviderName": "string", "RecordStatus_Id": "string", "URL": "string" } - schema_name_id: 1641
- schema_scan_id: 161892614
- updated: 2026-04-12 03:00:45
-
Version 1710365
- created: 2026-04-11 03:03:01
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molologinprovidersset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molologinprovidersset`\n(\n `Id` string , `ProviderName` string , `URL` 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_moloLoginProvidersSet/2026-04-11/1775894423'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molologinprovidersset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloLoginProvidersSet/2026-04-11/1775894423
- id: 1710365
- processed: 1
- raw_data:
{ "Id": 0, "ProviderName": 1, "RecordStatus_Id": 3, "URL": 2 } - schema_attributes:
{ "Id": "string", "ProviderName": "string", "RecordStatus_Id": "string", "URL": "string" } - schema_name_id: 1641
- schema_scan_id: 161841098
- updated: 2026-04-11 03:03:14
-
Version 1709353
- created: 2026-04-10 03:10:11
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molologinprovidersset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molologinprovidersset`\n(\n `Id` string , `ProviderName` string , `URL` 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_moloLoginProvidersSet/2026-04-10/1775808180'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molologinprovidersset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloLoginProvidersSet/2026-04-10/1775808180
- id: 1709353
- processed: 1
- raw_data:
{ "Id": 0, "ProviderName": 1, "RecordStatus_Id": 3, "URL": 2 } - schema_attributes:
{ "Id": "string", "ProviderName": "string", "RecordStatus_Id": "string", "URL": "string" } - schema_name_id: 1641
- schema_scan_id: 161786052
- updated: 2026-04-10 03:10:25
-
Version 1708081
- created: 2026-04-09 03:01:42
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molologinprovidersset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molologinprovidersset`\n(\n `Id` string , `ProviderName` string , `URL` 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_moloLoginProvidersSet/2026-04-09/1775721520'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molologinprovidersset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloLoginProvidersSet/2026-04-09/1775721520
- id: 1708081
- processed: 1
- raw_data:
{ "Id": 0, "ProviderName": 1, "RecordStatus_Id": 3, "URL": 2 } - schema_attributes:
{ "Id": "string", "ProviderName": "string", "RecordStatus_Id": "string", "URL": "string" } - schema_name_id: 1641
- schema_scan_id: 161730091
- updated: 2026-04-09 03:01:56
-
Version 1706853
- created: 2026-04-08 03:03:25
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molologinprovidersset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molologinprovidersset`\n(\n `Id` string , `ProviderName` string , `URL` 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_moloLoginProvidersSet/2026-04-08/1775635348'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molologinprovidersset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloLoginProvidersSet/2026-04-08/1775635348
- id: 1706853
- processed: 1
- raw_data:
{ "Id": 0, "ProviderName": 1, "RecordStatus_Id": 3, "URL": 2 } - schema_attributes:
{ "Id": "string", "ProviderName": "string", "RecordStatus_Id": "string", "URL": "string" } - schema_name_id: 1641
- schema_scan_id: 161675430
- updated: 2026-04-08 03:03:36
-
Version 1705693
- created: 2026-04-07 02:56:37
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molologinprovidersset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molologinprovidersset`\n(\n `Id` string , `ProviderName` string , `URL` 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_moloLoginProvidersSet/2026-04-07/1775548499'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molologinprovidersset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloLoginProvidersSet/2026-04-07/1775548499
- id: 1705693
- processed: 1
- raw_data:
{ "Id": 0, "ProviderName": 1, "RecordStatus_Id": 3, "URL": 2 } - schema_attributes:
{ "Id": "string", "ProviderName": "string", "RecordStatus_Id": "string", "URL": "string" } - schema_name_id: 1641
- schema_scan_id: 161618389
- updated: 2026-04-07 02:56:50
-
Version 1704579
- created: 2026-04-06 03:09:23
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molologinprovidersset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molologinprovidersset`\n(\n `Id` string , `ProviderName` string , `URL` 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_moloLoginProvidersSet/2026-04-06/1775462465'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molologinprovidersset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloLoginProvidersSet/2026-04-06/1775462465
- id: 1704579
- processed: 1
- raw_data:
{ "Id": 0, "ProviderName": 1, "RecordStatus_Id": 3, "URL": 2 } - schema_attributes:
{ "Id": "string", "ProviderName": "string", "RecordStatus_Id": "string", "URL": "string" } - schema_name_id: 1641
- schema_scan_id: 161561716
- updated: 2026-04-06 03:09:34
-
Version 1703215
- created: 2026-04-05 03:01:43
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molologinprovidersset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molologinprovidersset`\n(\n `Id` string , `ProviderName` string , `URL` 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_moloLoginProvidersSet/2026-04-05/1775376090'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molologinprovidersset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloLoginProvidersSet/2026-04-05/1775376090
- id: 1703215
- processed: 1
- raw_data:
{ "Id": 0, "ProviderName": 1, "RecordStatus_Id": 3, "URL": 2 } - schema_attributes:
{ "Id": "string", "ProviderName": "string", "RecordStatus_Id": "string", "URL": "string" } - schema_name_id: 1641
- schema_scan_id: 161514776
- updated: 2026-04-05 03:01:57
-
Version 1702112
- created: 2026-04-04 03:03:25
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molologinprovidersset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molologinprovidersset`\n(\n `Id` string , `ProviderName` string , `URL` 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_moloLoginProvidersSet/2026-04-04/1775289574'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molologinprovidersset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloLoginProvidersSet/2026-04-04/1775289574
- id: 1702112
- processed: 1
- raw_data:
{ "Id": 0, "ProviderName": 1, "RecordStatus_Id": 3, "URL": 2 } - schema_attributes:
{ "Id": "string", "ProviderName": "string", "RecordStatus_Id": "string", "URL": "string" } - schema_name_id: 1641
- schema_scan_id: 161460246
- updated: 2026-04-04 03:03:36
-
Version 1700883
- created: 2026-04-03 03:07:22
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molologinprovidersset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molologinprovidersset`\n(\n `Id` string , `ProviderName` string , `URL` 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_moloLoginProvidersSet/2026-04-03/1775203346'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molologinprovidersset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloLoginProvidersSet/2026-04-03/1775203346
- id: 1700883
- processed: 1
- raw_data:
{ "Id": 0, "ProviderName": 1, "RecordStatus_Id": 3, "URL": 2 } - schema_attributes:
{ "Id": "string", "ProviderName": "string", "RecordStatus_Id": "string", "URL": "string" } - schema_name_id: 1641
- schema_scan_id: 161401813
- updated: 2026-04-03 03:07:35
Schema Scans: 15
Last at 2026-04-17 03:05:52
-
Scan 162167641
- duration: 0:00:14.162438
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162167641
- 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_moloLoginProvidersSet/2026-04-17/1776412805", "key": "raw/molo_moloLoginProvidersSet/2026-04-17/1776412805/LoginProvidersSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloLoginProvidersSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2339360531990686893, "service_name": "drive-thru", "span_id": 2349355479321825034, "trace_id": 12520023792733062447 } } - running: False
- schema_name_id: 1641
- start_time: 2026-04-17 03:05:52
- success: True
- trace_id: 12520023792733062447
-
Scan 162111858
- duration: 0:00:11.861120
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162111858
- 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_moloLoginProvidersSet/2026-04-16/1776326557", "key": "raw/molo_moloLoginProvidersSet/2026-04-16/1776326557/LoginProvidersSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloLoginProvidersSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8107900900351188123, "service_name": "drive-thru", "span_id": 839124162521876356, "trace_id": 8399820159656332479 } } - running: False
- schema_name_id: 1641
- start_time: 2026-04-16 03:08:43
- success: True
- trace_id: 8399820159656332479
-
Scan 162055949
- duration: 0:00:14.115607
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162055949
- 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_moloLoginProvidersSet/2026-04-15/1776240028", "key": "raw/molo_moloLoginProvidersSet/2026-04-15/1776240028/LoginProvidersSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloLoginProvidersSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3804871360329451008, "service_name": "drive-thru", "span_id": 2955691469346915792, "trace_id": 6968397631533874808 } } - running: False
- schema_name_id: 1641
- start_time: 2026-04-15 03:05:34
- success: True
- trace_id: 6968397631533874808
-
Scan 162000388
- duration: 0:00:14.201490
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162000388
- 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_moloLoginProvidersSet/2026-04-14/1776153754", "key": "raw/molo_moloLoginProvidersSet/2026-04-14/1776153754/LoginProvidersSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloLoginProvidersSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16719969223172236126, "service_name": "drive-thru", "span_id": 5202111105539364801, "trace_id": 72893872474153596 } } - running: False
- schema_name_id: 1641
- start_time: 2026-04-14 03:03:30
- success: True
- trace_id: 72893872474153596
-
Scan 161941664
- duration: 0:00:11.605453
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161941664
- 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_moloLoginProvidersSet/2026-04-13/1776066950", "key": "raw/molo_moloLoginProvidersSet/2026-04-13/1776066950/LoginProvidersSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloLoginProvidersSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3765659891121078779, "service_name": "drive-thru", "span_id": 9967869001110160541, "trace_id": 14256554517612072024 } } - running: False
- schema_name_id: 1641
- start_time: 2026-04-13 02:58:21
- success: True
- trace_id: 14256554517612072024
-
Scan 161892614
- duration: 0:00:14.041328
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161892614
- 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_moloLoginProvidersSet/2026-04-12/1775980662", "key": "raw/molo_moloLoginProvidersSet/2026-04-12/1775980662/LoginProvidersSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloLoginProvidersSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16678555948243566830, "service_name": "drive-thru", "span_id": 12526540094895790086, "trace_id": 3919099847941320347 } } - running: False
- schema_name_id: 1641
- start_time: 2026-04-12 03:00:31
- success: True
- trace_id: 3919099847941320347
-
Scan 161841098
- duration: 0:00:14.100488
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161841098
- 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_moloLoginProvidersSet/2026-04-11/1775894423", "key": "raw/molo_moloLoginProvidersSet/2026-04-11/1775894423/LoginProvidersSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloLoginProvidersSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1581617090017541496, "service_name": "drive-thru", "span_id": 592690411110915369, "trace_id": 17349603607325781349 } } - running: False
- schema_name_id: 1641
- start_time: 2026-04-11 03:03:00
- success: True
- trace_id: 17349603607325781349
-
Scan 161786052
- duration: 0:00:14.124050
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161786052
- 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_moloLoginProvidersSet/2026-04-10/1775808180", "key": "raw/molo_moloLoginProvidersSet/2026-04-10/1775808180/LoginProvidersSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloLoginProvidersSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7700116080879062622, "service_name": "drive-thru", "span_id": 11818763601934771263, "trace_id": 3599470656458553054 } } - running: False
- schema_name_id: 1641
- start_time: 2026-04-10 03:10:11
- success: True
- trace_id: 3599470656458553054
-
Scan 161730091
- duration: 0:00:14.211896
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161730091
- 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_moloLoginProvidersSet/2026-04-09/1775721520", "key": "raw/molo_moloLoginProvidersSet/2026-04-09/1775721520/LoginProvidersSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloLoginProvidersSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16498147293750924130, "service_name": "drive-thru", "span_id": 11514009045054948458, "trace_id": 17630180938993521001 } } - running: False
- schema_name_id: 1641
- start_time: 2026-04-09 03:01:42
- success: True
- trace_id: 17630180938993521001
-
Scan 161675430
- duration: 0:00:11.596691
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161675430
- 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_moloLoginProvidersSet/2026-04-08/1775635348", "key": "raw/molo_moloLoginProvidersSet/2026-04-08/1775635348/LoginProvidersSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloLoginProvidersSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8870646127365902943, "service_name": "drive-thru", "span_id": 14126441954653500293, "trace_id": 8651868606373019739 } } - running: False
- schema_name_id: 1641
- start_time: 2026-04-08 03:03:25
- success: True
- trace_id: 8651868606373019739
-
Scan 161618389
- duration: 0:00:14.123951
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161618389
- 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_moloLoginProvidersSet/2026-04-07/1775548499", "key": "raw/molo_moloLoginProvidersSet/2026-04-07/1775548499/LoginProvidersSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloLoginProvidersSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15196850362655393082, "service_name": "drive-thru", "span_id": 6952813370488652158, "trace_id": 15315610617430980186 } } - running: False
- schema_name_id: 1641
- start_time: 2026-04-07 02:56:36
- success: True
- trace_id: 15315610617430980186
-
Scan 161561716
- duration: 0:00:11.653781
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161561716
- 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_moloLoginProvidersSet/2026-04-06/1775462465", "key": "raw/molo_moloLoginProvidersSet/2026-04-06/1775462465/LoginProvidersSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloLoginProvidersSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6967261112811864562, "service_name": "drive-thru", "span_id": 3325465501145461644, "trace_id": 6775142453834518324 } } - running: False
- schema_name_id: 1641
- start_time: 2026-04-06 03:09:22
- success: True
- trace_id: 6775142453834518324
-
Scan 161514776
- duration: 0:00:14.788204
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161514776
- 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_moloLoginProvidersSet/2026-04-05/1775376090", "key": "raw/molo_moloLoginProvidersSet/2026-04-05/1775376090/LoginProvidersSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloLoginProvidersSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 685980986084727787, "service_name": "drive-thru", "span_id": 4830783087300917581, "trace_id": 10773223424395150442 } } - running: False
- schema_name_id: 1641
- start_time: 2026-04-05 03:01:42
- success: True
- trace_id: 10773223424395150442
-
Scan 161460246
- duration: 0:00:11.593957
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161460246
- 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_moloLoginProvidersSet/2026-04-04/1775289574", "key": "raw/molo_moloLoginProvidersSet/2026-04-04/1775289574/LoginProvidersSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloLoginProvidersSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6669519789059224220, "service_name": "drive-thru", "span_id": 16799286965765948712, "trace_id": 11701745264064421406 } } - running: False
- schema_name_id: 1641
- start_time: 2026-04-04 03:03:24
- success: True
- trace_id: 11701745264064421406
-
Scan 161401813
- duration: 0:00:14.197449
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161401813
- 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_moloLoginProvidersSet/2026-04-03/1775203346", "key": "raw/molo_moloLoginProvidersSet/2026-04-03/1775203346/LoginProvidersSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloLoginProvidersSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5353716482822187677, "service_name": "drive-thru", "span_id": 4207855567701066112, "trace_id": 13453845793663486499 } } - running: False
- schema_name_id: 1641
- start_time: 2026-04-03 03:07:21
- success: True
- trace_id: 13453845793663486499
- attributes:
{ "Id": "string", "ProviderName": "string", "RecordStatus_Id": "string", "URL": "string" } - created: 2026-04-17 03:05:52
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molologinprovidersset`\n(\n `Id` string , `ProviderName` string , `URL` 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_moloLoginProvidersSet/2026-04-17/1776412805'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molologinprovidersset`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molologinprovidersset" }
- 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:46",
"disabled": false,
"format": "raw",
"id": 1641,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "molo_molologinprovidersset"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"Id": "string",
"ProviderName": "string",
"RecordStatus_Id": "string",
"URL": "string"
},
"created": "2026-04-17 03:05:52",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molologinprovidersset`\n(\n `Id` string , `ProviderName` string , `URL` 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_moloLoginProvidersSet/2026-04-17/1776412805'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molologinprovidersset`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molologinprovidersset"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}