Schema Info
Schema Name: sfdl_prod_rds.sparefoot_sparefoot_consumer_lead
- created: 2022-08-18 17:18:14
- disabled: False
- format: raw
- id: 1096
- is_partitioned: False
- is_schema_datatyped: False
- name:
{ "database": "sfdl_prod_rds", "table": "sparefoot_sparefoot_consumer_lead" } - type: rds
Schema Versions: 15
-
Version 1718390
- created: 2026-04-17 14:14:19
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`\n(\n `consumer_lead_id` int , `first_name` string , `insert_time` timestamp , `last_name` string , `lead_hash` string , `primary_email` string , `primary_phone` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-17/1776453253'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_consumer_lead" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-17/1776453253
- id: 1718390
- processed: 1
- raw_data:
{ "consumer_lead_id": "int32", "first_name": "string", "insert_time": "timestamp[ns]", "last_name": "string", "lead_hash": "string", "primary_email": "string", "primary_phone": "string" } - schema_attributes:
{ "consumer_lead_id": "int", "first_name": "string", "insert_time": "timestamp", "last_name": "string", "lead_hash": "string", "primary_email": "string", "primary_phone": "string" } - schema_name_id: 1096
- schema_scan_id: 162193997
- updated: 2026-04-17 14:14:30
-
Version 1718214
- created: 2026-04-17 09:23:27
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`\n(\n `consumer_lead_id` int , `first_name` string , `insert_time` timestamp , `last_name` string , `lead_hash` string , `primary_email` string , `primary_phone` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-17/1776435801'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_consumer_lead" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-17/1776435801
- id: 1718214
- processed: 1
- raw_data:
{ "consumer_lead_id": "int32", "first_name": "string", "insert_time": "timestamp[ns]", "last_name": "string", "lead_hash": "string", "primary_email": "string", "primary_phone": "string" } - schema_attributes:
{ "consumer_lead_id": "int", "first_name": "string", "insert_time": "timestamp", "last_name": "string", "lead_hash": "string", "primary_email": "string", "primary_phone": "string" } - schema_name_id: 1096
- schema_scan_id: 162178311
- updated: 2026-04-17 09:23:38
-
Version 1717435
- created: 2026-04-17 00:06:50
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`\n(\n `consumer_lead_id` int , `first_name` string , `insert_time` timestamp , `last_name` string , `lead_hash` string , `primary_email` string , `primary_phone` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-17/1776402376'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_consumer_lead" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-17/1776402376
- id: 1717435
- processed: 1
- raw_data:
{ "consumer_lead_id": "int32", "first_name": "string", "insert_time": "timestamp[ns]", "last_name": "string", "lead_hash": "string", "primary_email": "string", "primary_phone": "string" } - schema_attributes:
{ "consumer_lead_id": "int", "first_name": "string", "insert_time": "timestamp", "last_name": "string", "lead_hash": "string", "primary_email": "string", "primary_phone": "string" } - schema_name_id: 1096
- schema_scan_id: 162163566
- updated: 2026-04-17 00:07:04
-
Version 1717331
- created: 2026-04-16 20:18:27
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`\n(\n `consumer_lead_id` int , `first_name` string , `insert_time` timestamp , `last_name` string , `lead_hash` string , `primary_email` string , `primary_phone` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-16/1776388627'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_consumer_lead" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-16/1776388627
- id: 1717331
- processed: 1
- raw_data:
{ "consumer_lead_id": "int32", "first_name": "string", "insert_time": "timestamp[ns]", "last_name": "string", "lead_hash": "string", "primary_email": "string", "primary_phone": "string" } - schema_attributes:
{ "consumer_lead_id": "int", "first_name": "string", "insert_time": "timestamp", "last_name": "string", "lead_hash": "string", "primary_email": "string", "primary_phone": "string" } - schema_name_id: 1096
- schema_scan_id: 162156076
- updated: 2026-04-16 20:18:38
-
Version 1717177
- created: 2026-04-16 14:18:03
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`\n(\n `consumer_lead_id` int , `first_name` string , `insert_time` timestamp , `last_name` string , `lead_hash` string , `primary_email` string , `primary_phone` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-16/1776367074'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_consumer_lead" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-16/1776367074
- id: 1717177
- processed: 1
- raw_data:
{ "consumer_lead_id": "int32", "first_name": "string", "insert_time": "timestamp[ns]", "last_name": "string", "lead_hash": "string", "primary_email": "string", "primary_phone": "string" } - schema_attributes:
{ "consumer_lead_id": "int", "first_name": "string", "insert_time": "timestamp", "last_name": "string", "lead_hash": "string", "primary_email": "string", "primary_phone": "string" } - schema_name_id: 1096
- schema_scan_id: 162138116
- updated: 2026-04-16 14:18:14
-
Version 1716978
- created: 2026-04-16 09:09:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`\n(\n `consumer_lead_id` int , `first_name` string , `insert_time` timestamp , `last_name` string , `lead_hash` string , `primary_email` string , `primary_phone` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-16/1776348580'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_consumer_lead" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-16/1776348580
- id: 1716978
- processed: 1
- raw_data:
{ "consumer_lead_id": "int32", "first_name": "string", "insert_time": "timestamp[ns]", "last_name": "string", "lead_hash": "string", "primary_email": "string", "primary_phone": "string" } - schema_attributes:
{ "consumer_lead_id": "int", "first_name": "string", "insert_time": "timestamp", "last_name": "string", "lead_hash": "string", "primary_email": "string", "primary_phone": "string" } - schema_name_id: 1096
- schema_scan_id: 162122499
- updated: 2026-04-16 09:10:00
-
Version 1716190
- created: 2026-04-16 00:06:11
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`\n(\n `consumer_lead_id` int , `first_name` string , `insert_time` timestamp , `last_name` string , `lead_hash` string , `primary_email` string , `primary_phone` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-16/1776315960'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_consumer_lead" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-16/1776315960
- id: 1716190
- processed: 1
- raw_data:
{ "consumer_lead_id": "int32", "first_name": "string", "insert_time": "timestamp[ns]", "last_name": "string", "lead_hash": "string", "primary_email": "string", "primary_phone": "string" } - schema_attributes:
{ "consumer_lead_id": "int", "first_name": "string", "insert_time": "timestamp", "last_name": "string", "lead_hash": "string", "primary_email": "string", "primary_phone": "string" } - schema_name_id: 1096
- schema_scan_id: 162107743
- updated: 2026-04-16 00:06:22
-
Version 1716083
- created: 2026-04-15 20:18:42
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`\n(\n `consumer_lead_id` int , `first_name` string , `insert_time` timestamp , `last_name` string , `lead_hash` string , `primary_email` string , `primary_phone` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-15/1776302315'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_consumer_lead" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-15/1776302315
- id: 1716083
- processed: 1
- raw_data:
{ "consumer_lead_id": "int32", "first_name": "string", "insert_time": "timestamp[ns]", "last_name": "string", "lead_hash": "string", "primary_email": "string", "primary_phone": "string" } - schema_attributes:
{ "consumer_lead_id": "int", "first_name": "string", "insert_time": "timestamp", "last_name": "string", "lead_hash": "string", "primary_email": "string", "primary_phone": "string" } - schema_name_id: 1096
- schema_scan_id: 162100289
- updated: 2026-04-15 20:18:53
-
Version 1715950
- created: 2026-04-15 14:11:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`\n(\n `consumer_lead_id` int , `first_name` string , `insert_time` timestamp , `last_name` string , `lead_hash` string , `primary_email` string , `primary_phone` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-15/1776280269'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_consumer_lead" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-15/1776280269
- id: 1715950
- processed: 1
- raw_data:
{ "consumer_lead_id": "int32", "first_name": "string", "insert_time": "timestamp[ns]", "last_name": "string", "lead_hash": "string", "primary_email": "string", "primary_phone": "string" } - schema_attributes:
{ "consumer_lead_id": "int", "first_name": "string", "insert_time": "timestamp", "last_name": "string", "lead_hash": "string", "primary_email": "string", "primary_phone": "string" } - schema_name_id: 1096
- schema_scan_id: 162081676
- updated: 2026-04-15 14:12:07
-
Version 1715760
- created: 2026-04-15 08:40:37
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`\n(\n `consumer_lead_id` int , `first_name` string , `insert_time` timestamp , `last_name` string , `lead_hash` string , `primary_email` string , `primary_phone` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-15/1776260379'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_consumer_lead" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-15/1776260379
- id: 1715760
- processed: 1
- raw_data:
{ "consumer_lead_id": "int32", "first_name": "string", "insert_time": "timestamp[ns]", "last_name": "string", "lead_hash": "string", "primary_email": "string", "primary_phone": "string" } - schema_attributes:
{ "consumer_lead_id": "int", "first_name": "string", "insert_time": "timestamp", "last_name": "string", "lead_hash": "string", "primary_email": "string", "primary_phone": "string" } - schema_name_id: 1096
- schema_scan_id: 162064428
- updated: 2026-04-15 08:40:51
-
Version 1714998
- created: 2026-04-15 00:08:01
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`\n(\n `consumer_lead_id` int , `first_name` string , `insert_time` timestamp , `last_name` string , `lead_hash` string , `primary_email` string , `primary_phone` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-15/1776229671'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_consumer_lead" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-15/1776229671
- id: 1714998
- processed: 1
- raw_data:
{ "consumer_lead_id": "int32", "first_name": "string", "insert_time": "timestamp[ns]", "last_name": "string", "lead_hash": "string", "primary_email": "string", "primary_phone": "string" } - schema_attributes:
{ "consumer_lead_id": "int", "first_name": "string", "insert_time": "timestamp", "last_name": "string", "lead_hash": "string", "primary_email": "string", "primary_phone": "string" } - schema_name_id: 1096
- schema_scan_id: 162051933
- updated: 2026-04-15 00:08:13
-
Version 1714918
- created: 2026-04-14 20:26:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`\n(\n `consumer_lead_id` int , `first_name` string , `insert_time` timestamp , `last_name` string , `lead_hash` string , `primary_email` string , `primary_phone` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-14/1776216400'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_consumer_lead" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-14/1776216400
- id: 1714918
- processed: 1
- raw_data:
{ "consumer_lead_id": "int32", "first_name": "string", "insert_time": "timestamp[ns]", "last_name": "string", "lead_hash": "string", "primary_email": "string", "primary_phone": "string" } - schema_attributes:
{ "consumer_lead_id": "int", "first_name": "string", "insert_time": "timestamp", "last_name": "string", "lead_hash": "string", "primary_email": "string", "primary_phone": "string" } - schema_name_id: 1096
- schema_scan_id: 162044343
- updated: 2026-04-14 20:26:58
-
Version 1714704
- created: 2026-04-14 14:10:40
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`\n(\n `consumer_lead_id` int , `first_name` string , `insert_time` timestamp , `last_name` string , `lead_hash` string , `primary_email` string , `primary_phone` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-14/1776193835'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_consumer_lead" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-14/1776193835
- id: 1714704
- processed: 1
- raw_data:
{ "consumer_lead_id": "int32", "first_name": "string", "insert_time": "timestamp[ns]", "last_name": "string", "lead_hash": "string", "primary_email": "string", "primary_phone": "string" } - schema_attributes:
{ "consumer_lead_id": "int", "first_name": "string", "insert_time": "timestamp", "last_name": "string", "lead_hash": "string", "primary_email": "string", "primary_phone": "string" } - schema_name_id: 1096
- schema_scan_id: 162026077
- updated: 2026-04-14 14:10:52
-
Version 1714591
- created: 2026-04-14 09:09:48
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`\n(\n `consumer_lead_id` int , `first_name` string , `insert_time` timestamp , `last_name` string , `lead_hash` string , `primary_email` string , `primary_phone` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-14/1776175773'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_consumer_lead" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-14/1776175773
- id: 1714591
- processed: 1
- raw_data:
{ "consumer_lead_id": "int32", "first_name": "string", "insert_time": "timestamp[ns]", "last_name": "string", "lead_hash": "string", "primary_email": "string", "primary_phone": "string" } - schema_attributes:
{ "consumer_lead_id": "int", "first_name": "string", "insert_time": "timestamp", "last_name": "string", "lead_hash": "string", "primary_email": "string", "primary_phone": "string" } - schema_name_id: 1096
- schema_scan_id: 162010961
- updated: 2026-04-14 09:10:42
-
Version 1713830
- created: 2026-04-14 00:15:41
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`\n(\n `consumer_lead_id` int , `first_name` string , `insert_time` timestamp , `last_name` string , `lead_hash` string , `primary_email` string , `primary_phone` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-14/1776143736'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_consumer_lead" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-14/1776143736
- id: 1713830
- processed: 1
- raw_data:
{ "consumer_lead_id": "int32", "first_name": "string", "insert_time": "timestamp[ns]", "last_name": "string", "lead_hash": "string", "primary_email": "string", "primary_phone": "string" } - schema_attributes:
{ "consumer_lead_id": "int", "first_name": "string", "insert_time": "timestamp", "last_name": "string", "lead_hash": "string", "primary_email": "string", "primary_phone": "string" } - schema_name_id: 1096
- schema_scan_id: 161996374
- updated: 2026-04-14 00:15:52
Schema Scans: 15
Last at 2026-04-17 14:14:19
-
Scan 162193997
- duration: 0:00:11.763459
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162193997
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-prod", "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-17/1776453253", "key": "raw/sparefoot_consumer_lead/2026-04-17/1776453253/consumer_lead_1.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_consumer_lead", "type": "rds" }, "trace_context": { "parent_id": 5019534579671295487, "service_name": "sparefoot", "span_id": 14910849054548767483, "trace_id": 5019534579671295487 } } - running: False
- schema_name_id: 1096
- start_time: 2026-04-17 14:14:19
- success: True
- trace_id: 5019534579671295487
-
Scan 162178311
- duration: 0:00:11.680501
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162178311
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-prod", "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-17/1776435801", "key": "raw/sparefoot_consumer_lead/2026-04-17/1776435801/consumer_lead_1.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_consumer_lead", "type": "rds" }, "trace_context": { "parent_id": 8706884556276555310, "service_name": "sparefoot", "span_id": 4854368832419042679, "trace_id": 8706884556276555310 } } - running: False
- schema_name_id: 1096
- start_time: 2026-04-17 09:23:26
- success: True
- trace_id: 8706884556276555310
-
Scan 162163566
- duration: 0:00:14.271695
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162163566
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-prod", "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-17/1776402376", "key": "raw/sparefoot_consumer_lead/2026-04-17/1776402376/consumer_lead_1.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_consumer_lead", "type": "rds" }, "trace_context": { "parent_id": 5470451402879226629, "service_name": "sparefoot", "span_id": 11861951249584973691, "trace_id": 5470451402879226629 } } - running: False
- schema_name_id: 1096
- start_time: 2026-04-17 00:06:49
- success: True
- trace_id: 5470451402879226629
-
Scan 162156076
- duration: 0:00:11.829421
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162156076
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-prod", "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-16/1776388627", "key": "raw/sparefoot_consumer_lead/2026-04-16/1776388627/consumer_lead_1.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_consumer_lead", "type": "rds" }, "trace_context": { "parent_id": 17146647226767591632, "service_name": "sparefoot", "span_id": 7243874504084168142, "trace_id": 17146647226767591632 } } - running: False
- schema_name_id: 1096
- start_time: 2026-04-16 20:18:26
- success: True
- trace_id: 17146647226767591632
-
Scan 162138116
- duration: 0:00:11.743313
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162138116
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-prod", "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-16/1776367074", "key": "raw/sparefoot_consumer_lead/2026-04-16/1776367074/consumer_lead_1.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_consumer_lead", "type": "rds" }, "trace_context": { "parent_id": 15980027719534579054, "service_name": "sparefoot", "span_id": 13410461124409760007, "trace_id": 15980027719534579054 } } - running: False
- schema_name_id: 1096
- start_time: 2026-04-16 14:18:02
- success: True
- trace_id: 15980027719534579054
-
Scan 162122499
- duration: 0:00:14.152812
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162122499
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-prod", "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-16/1776348580", "key": "raw/sparefoot_consumer_lead/2026-04-16/1776348580/consumer_lead_1.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_consumer_lead", "type": "rds" }, "trace_context": { "parent_id": 9456005160585138443, "service_name": "sparefoot", "span_id": 14470669026144574771, "trace_id": 9456005160585138443 } } - running: False
- schema_name_id: 1096
- start_time: 2026-04-16 09:09:46
- success: True
- trace_id: 9456005160585138443
-
Scan 162107743
- duration: 0:00:11.775099
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162107743
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-prod", "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-16/1776315960", "key": "raw/sparefoot_consumer_lead/2026-04-16/1776315960/consumer_lead_1.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_consumer_lead", "type": "rds" }, "trace_context": { "parent_id": 12038664460153942995, "service_name": "sparefoot", "span_id": 1308888160680705454, "trace_id": 12038664460153942995 } } - running: False
- schema_name_id: 1096
- start_time: 2026-04-16 00:06:10
- success: True
- trace_id: 12038664460153942995
-
Scan 162100289
- duration: 0:00:11.796636
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162100289
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-prod", "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-15/1776302315", "key": "raw/sparefoot_consumer_lead/2026-04-15/1776302315/consumer_lead_1.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_consumer_lead", "type": "rds" }, "trace_context": { "parent_id": 2495481686199430821, "service_name": "sparefoot", "span_id": 13287592787568460548, "trace_id": 2495481686199430821 } } - running: False
- schema_name_id: 1096
- start_time: 2026-04-15 20:18:41
- success: True
- trace_id: 2495481686199430821
-
Scan 162081676
- duration: 0:00:11.891960
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162081676
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-prod", "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-15/1776280269", "key": "raw/sparefoot_consumer_lead/2026-04-15/1776280269/consumer_lead_1.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_consumer_lead", "type": "rds" }, "trace_context": { "parent_id": 6811132391261334110, "service_name": "sparefoot", "span_id": 4416809177364875167, "trace_id": 6811132391261334110 } } - running: False
- schema_name_id: 1096
- start_time: 2026-04-15 14:11:55
- success: True
- trace_id: 6811132391261334110
-
Scan 162064428
- duration: 0:00:14.356608
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162064428
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-prod", "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-15/1776260379", "key": "raw/sparefoot_consumer_lead/2026-04-15/1776260379/consumer_lead_1.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_consumer_lead", "type": "rds" }, "trace_context": { "parent_id": 6480365683760376743, "service_name": "sparefoot", "span_id": 9030852418498264136, "trace_id": 6480365683760376743 } } - running: False
- schema_name_id: 1096
- start_time: 2026-04-15 08:40:37
- success: True
- trace_id: 6480365683760376743
-
Scan 162051933
- duration: 0:00:11.867824
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162051933
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-prod", "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-15/1776229671", "key": "raw/sparefoot_consumer_lead/2026-04-15/1776229671/consumer_lead_1.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_consumer_lead", "type": "rds" }, "trace_context": { "parent_id": 15187941678947301184, "service_name": "sparefoot", "span_id": 17164628444678774439, "trace_id": 15187941678947301184 } } - running: False
- schema_name_id: 1096
- start_time: 2026-04-15 00:08:01
- success: True
- trace_id: 15187941678947301184
-
Scan 162044343
- duration: 0:00:11.759198
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162044343
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-prod", "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-14/1776216400", "key": "raw/sparefoot_consumer_lead/2026-04-14/1776216400/consumer_lead_1.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_consumer_lead", "type": "rds" }, "trace_context": { "parent_id": 1065414583203867559, "service_name": "sparefoot", "span_id": 18191581718629893975, "trace_id": 1065414583203867559 } } - running: False
- schema_name_id: 1096
- start_time: 2026-04-14 20:26:46
- success: True
- trace_id: 1065414583203867559
-
Scan 162026077
- duration: 0:00:11.754676
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162026077
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-prod", "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-14/1776193835", "key": "raw/sparefoot_consumer_lead/2026-04-14/1776193835/consumer_lead_1.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_consumer_lead", "type": "rds" }, "trace_context": { "parent_id": 2935212180352147623, "service_name": "sparefoot", "span_id": 16304547550610060815, "trace_id": 2935212180352147623 } } - running: False
- schema_name_id: 1096
- start_time: 2026-04-14 14:10:40
- success: True
- trace_id: 2935212180352147623
-
Scan 162010961
- duration: 0:00:55.059386
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162010961
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-prod", "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-14/1776175773", "key": "raw/sparefoot_consumer_lead/2026-04-14/1776175773/consumer_lead_1.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_consumer_lead", "type": "rds" }, "trace_context": { "parent_id": 2670898946607485672, "service_name": "sparefoot", "span_id": 9983553662076817137, "trace_id": 2670898946607485672 } } - running: False
- schema_name_id: 1096
- start_time: 2026-04-14 09:09:47
- success: True
- trace_id: 2670898946607485672
-
Scan 161996374
- duration: 0:00:11.616776
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161996374
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-prod", "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-14/1776143736", "key": "raw/sparefoot_consumer_lead/2026-04-14/1776143736/consumer_lead_1.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_consumer_lead", "type": "rds" }, "trace_context": { "parent_id": 11223118179894846145, "service_name": "sparefoot", "span_id": 15946313196152935158, "trace_id": 11223118179894846145 } } - running: False
- schema_name_id: 1096
- start_time: 2026-04-14 00:15:41
- success: True
- trace_id: 11223118179894846145
- attributes:
{ "consumer_lead_id": "int", "first_name": "string", "insert_time": "timestamp", "last_name": "string", "lead_hash": "string", "primary_email": "string", "primary_phone": "string" } - created: 2026-04-17 14:14:19
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`\n(\n `consumer_lead_id` int , `first_name` string , `insert_time` timestamp , `last_name` string , `lead_hash` string , `primary_email` string , `primary_phone` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-17/1776453253'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_consumer_lead" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2022-08-18 17:18:14",
"disabled": false,
"format": "raw",
"id": 1096,
"is_partitioned": false,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_prod_rds",
"table": "sparefoot_sparefoot_consumer_lead"
},
"type": "rds"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"consumer_lead_id": "int",
"first_name": "string",
"insert_time": "timestamp",
"last_name": "string",
"lead_hash": "string",
"primary_email": "string",
"primary_phone": "string"
},
"created": "2026-04-17 14:14:19",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`\n(\n `consumer_lead_id` int , `first_name` string , `insert_time` timestamp , `last_name` string , `lead_hash` string , `primary_email` string , `primary_phone` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_consumer_lead/2026-04-17/1776453253'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_consumer_lead`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_consumer_lead"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}