Schema Info
Schema Name: sfdl_stage_rds.sparefoot_sparefoot_consumer_lead
- created: 2022-08-12 10:30:29
- disabled: False
- format: raw
- id: 1359
- is_partitioned: False
- is_schema_datatyped: False
- name:
{ "database": "sfdl_stage_rds", "table": "sparefoot_sparefoot_consumer_lead" } - type: rds
Schema Versions: 15
-
Version 906557
- created: 2026-04-17 00:19:38
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_consumer_lead`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_consumer_lead/2026-04-17/1776403172'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_consumer_lead" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_consumer_lead/2026-04-17/1776403172
- id: 906557
- 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: 1359
- schema_scan_id: 6415125
- updated: 2026-04-17 00:19:49
-
Version 906330
- created: 2026-04-16 00:09:01
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_consumer_lead`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_consumer_lead/2026-04-16/1776316113'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_consumer_lead" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_consumer_lead/2026-04-16/1776316113
- id: 906330
- 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: 1359
- schema_scan_id: 6414565
- updated: 2026-04-16 00:09:12
-
Version 906149
- created: 2026-04-15 00:28:43
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_consumer_lead`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_consumer_lead/2026-04-15/1776230916'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_consumer_lead" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_consumer_lead/2026-04-15/1776230916
- id: 906149
- 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: 1359
- schema_scan_id: 6414113
- updated: 2026-04-15 00:28:57
-
Version 905905
- created: 2026-04-14 00:11:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_consumer_lead`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_consumer_lead/2026-04-14/1776143437'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_consumer_lead" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_consumer_lead/2026-04-14/1776143437
- id: 905905
- 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: 1359
- schema_scan_id: 6413571
- updated: 2026-04-14 00:11:18
-
Version 905684
- created: 2026-04-13 00:15:00
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_consumer_lead`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_consumer_lead/2026-04-13/1776057275'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_consumer_lead" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_consumer_lead/2026-04-13/1776057275
- id: 905684
- 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: 1359
- schema_scan_id: 6413016
- updated: 2026-04-13 00:15:14
-
Version 905472
- created: 2026-04-12 00:07:43
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_consumer_lead`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_consumer_lead/2026-04-12/1775970456'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_consumer_lead" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_consumer_lead/2026-04-12/1775970456
- id: 905472
- 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: 1359
- schema_scan_id: 6412622
- updated: 2026-04-12 00:07:57
-
Version 905306
- created: 2026-04-11 00:13:08
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_consumer_lead`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_consumer_lead/2026-04-11/1775884382'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_consumer_lead" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_consumer_lead/2026-04-11/1775884382
- id: 905306
- 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: 1359
- schema_scan_id: 6412279
- updated: 2026-04-11 00:13:19
-
Version 905102
- created: 2026-04-10 00:13:28
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_consumer_lead`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_consumer_lead/2026-04-10/1775797975'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_consumer_lead" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_consumer_lead/2026-04-10/1775797975
- id: 905102
- 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: 1359
- schema_scan_id: 6411785
- updated: 2026-04-10 00:13:40
-
Version 904874
- created: 2026-04-09 00:14:52
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_consumer_lead`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_consumer_lead/2026-04-09/1775711686'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_consumer_lead" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_consumer_lead/2026-04-09/1775711686
- id: 904874
- 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: 1359
- schema_scan_id: 6411261
- updated: 2026-04-09 00:15:06
-
Version 904663
- created: 2026-04-08 00:13:51
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_consumer_lead`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_consumer_lead/2026-04-08/1775625218'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_consumer_lead" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_consumer_lead/2026-04-08/1775625218
- id: 904663
- 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: 1359
- schema_scan_id: 6410760
- updated: 2026-04-08 00:14:05
-
Version 904411
- created: 2026-04-07 00:06:55
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_consumer_lead`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_consumer_lead/2026-04-07/1775538409'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_consumer_lead" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_consumer_lead/2026-04-07/1775538409
- id: 904411
- 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: 1359
- schema_scan_id: 6410212
- updated: 2026-04-07 00:07:09
-
Version 904242
- created: 2026-04-06 00:13:21
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_consumer_lead`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_consumer_lead/2026-04-06/1775452395'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_consumer_lead" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_consumer_lead/2026-04-06/1775452395
- id: 904242
- 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: 1359
- schema_scan_id: 6409715
- updated: 2026-04-06 00:13:32
-
Version 904002
- created: 2026-04-05 00:07:17
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_consumer_lead`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_consumer_lead/2026-04-05/1775365632'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_consumer_lead" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_consumer_lead/2026-04-05/1775365632
- id: 904002
- 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: 1359
- schema_scan_id: 6409296
- updated: 2026-04-05 00:07:31
-
Version 903812
- created: 2026-04-04 00:09:30
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_consumer_lead`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_consumer_lead/2026-04-04/1775279361'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_consumer_lead" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_consumer_lead/2026-04-04/1775279361
- id: 903812
- 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: 1359
- schema_scan_id: 6408928
- updated: 2026-04-04 00:09:44
-
Version 903594
- created: 2026-04-03 00:08:48
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_consumer_lead`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_consumer_lead/2026-04-03/1775192922'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_consumer_lead" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_consumer_lead/2026-04-03/1775192922
- id: 903594
- 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: 1359
- schema_scan_id: 6408427
- updated: 2026-04-03 00:08:59
Schema Scans: 15
Last at 2026-04-17 00:19:38
-
Scan 6415125
- duration: 0:00:11.774935
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6415125
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_consumer_lead/2026-04-17/1776403172", "key": "raw/sparefoot_consumer_lead/2026-04-17/1776403172/consumer_lead_1.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_consumer_lead", "type": "rds" }, "trace_context": { "parent_id": 17810293407955812100, "service_name": "sparefoot", "span_id": 1099442088077706586, "trace_id": 17810293407955812100 } } - running: False
- schema_name_id: 1359
- start_time: 2026-04-17 00:19:38
- success: True
- trace_id: 17810293407955812100
-
Scan 6414565
- duration: 0:00:11.967105
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6414565
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_consumer_lead/2026-04-16/1776316113", "key": "raw/sparefoot_consumer_lead/2026-04-16/1776316113/consumer_lead_1.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_consumer_lead", "type": "rds" }, "trace_context": { "parent_id": 17108659990682151930, "service_name": "sparefoot", "span_id": 11509376196505548024, "trace_id": 17108659990682151930 } } - running: False
- schema_name_id: 1359
- start_time: 2026-04-16 00:09:01
- success: True
- trace_id: 17108659990682151930
-
Scan 6414113
- duration: 0:00:14.243987
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6414113
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_consumer_lead/2026-04-15/1776230916", "key": "raw/sparefoot_consumer_lead/2026-04-15/1776230916/consumer_lead_1.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_consumer_lead", "type": "rds" }, "trace_context": { "parent_id": 2885784159697283672, "service_name": "sparefoot", "span_id": 2296261484825949323, "trace_id": 2885784159697283672 } } - running: False
- schema_name_id: 1359
- start_time: 2026-04-15 00:28:42
- success: True
- trace_id: 2885784159697283672
-
Scan 6413571
- duration: 0:00:11.808692
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6413571
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_consumer_lead/2026-04-14/1776143437", "key": "raw/sparefoot_consumer_lead/2026-04-14/1776143437/consumer_lead_1.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_consumer_lead", "type": "rds" }, "trace_context": { "parent_id": 11803137096809041068, "service_name": "sparefoot", "span_id": 12610313223623336503, "trace_id": 11803137096809041068 } } - running: False
- schema_name_id: 1359
- start_time: 2026-04-14 00:11:06
- success: True
- trace_id: 11803137096809041068
-
Scan 6413016
- duration: 0:00:14.581259
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6413016
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_consumer_lead/2026-04-13/1776057275", "key": "raw/sparefoot_consumer_lead/2026-04-13/1776057275/consumer_lead_1.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_consumer_lead", "type": "rds" }, "trace_context": { "parent_id": 1728009913007890981, "service_name": "sparefoot", "span_id": 17319161061679345566, "trace_id": 1728009913007890981 } } - running: False
- schema_name_id: 1359
- start_time: 2026-04-13 00:14:59
- success: True
- trace_id: 1728009913007890981
-
Scan 6412622
- duration: 0:00:14.246613
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6412622
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_consumer_lead/2026-04-12/1775970456", "key": "raw/sparefoot_consumer_lead/2026-04-12/1775970456/consumer_lead_1.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_consumer_lead", "type": "rds" }, "trace_context": { "parent_id": 13906970760250274461, "service_name": "sparefoot", "span_id": 6528957078938527974, "trace_id": 13906970760250274461 } } - running: False
- schema_name_id: 1359
- start_time: 2026-04-12 00:07:43
- success: True
- trace_id: 13906970760250274461
-
Scan 6412279
- duration: 0:00:11.656436
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6412279
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_consumer_lead/2026-04-11/1775884382", "key": "raw/sparefoot_consumer_lead/2026-04-11/1775884382/consumer_lead_1.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_consumer_lead", "type": "rds" }, "trace_context": { "parent_id": 7715800425557750457, "service_name": "sparefoot", "span_id": 3050209916010908669, "trace_id": 7715800425557750457 } } - running: False
- schema_name_id: 1359
- start_time: 2026-04-11 00:13:07
- success: True
- trace_id: 7715800425557750457
-
Scan 6411785
- duration: 0:00:11.918398
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6411785
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_consumer_lead/2026-04-10/1775797975", "key": "raw/sparefoot_consumer_lead/2026-04-10/1775797975/consumer_lead_1.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_consumer_lead", "type": "rds" }, "trace_context": { "parent_id": 17191838456243878812, "service_name": "sparefoot", "span_id": 1305512986524670816, "trace_id": 17191838456243878812 } } - running: False
- schema_name_id: 1359
- start_time: 2026-04-10 00:13:28
- success: True
- trace_id: 17191838456243878812
-
Scan 6411261
- duration: 0:00:14.265404
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6411261
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_consumer_lead/2026-04-09/1775711686", "key": "raw/sparefoot_consumer_lead/2026-04-09/1775711686/consumer_lead_1.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_consumer_lead", "type": "rds" }, "trace_context": { "parent_id": 4509836078911820706, "service_name": "sparefoot", "span_id": 12113227776432762447, "trace_id": 4509836078911820706 } } - running: False
- schema_name_id: 1359
- start_time: 2026-04-09 00:14:52
- success: True
- trace_id: 4509836078911820706
-
Scan 6410760
- duration: 0:00:14.272663
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6410760
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_consumer_lead/2026-04-08/1775625218", "key": "raw/sparefoot_consumer_lead/2026-04-08/1775625218/consumer_lead_1.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_consumer_lead", "type": "rds" }, "trace_context": { "parent_id": 913954784175687562, "service_name": "sparefoot", "span_id": 9152051178814012475, "trace_id": 913954784175687562 } } - running: False
- schema_name_id: 1359
- start_time: 2026-04-08 00:13:51
- success: True
- trace_id: 913954784175687562
-
Scan 6410212
- duration: 0:00:14.274888
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6410212
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_consumer_lead/2026-04-07/1775538409", "key": "raw/sparefoot_consumer_lead/2026-04-07/1775538409/consumer_lead_1.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_consumer_lead", "type": "rds" }, "trace_context": { "parent_id": 5114089251216294696, "service_name": "sparefoot", "span_id": 6493591803337442931, "trace_id": 5114089251216294696 } } - running: False
- schema_name_id: 1359
- start_time: 2026-04-07 00:06:55
- success: True
- trace_id: 5114089251216294696
-
Scan 6409715
- duration: 0:00:11.779106
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6409715
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_consumer_lead/2026-04-06/1775452395", "key": "raw/sparefoot_consumer_lead/2026-04-06/1775452395/consumer_lead_1.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_consumer_lead", "type": "rds" }, "trace_context": { "parent_id": 17150723584278641065, "service_name": "sparefoot", "span_id": 12526141688668759949, "trace_id": 17150723584278641065 } } - running: False
- schema_name_id: 1359
- start_time: 2026-04-06 00:13:20
- success: True
- trace_id: 17150723584278641065
-
Scan 6409296
- duration: 0:00:14.329891
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6409296
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_consumer_lead/2026-04-05/1775365632", "key": "raw/sparefoot_consumer_lead/2026-04-05/1775365632/consumer_lead_1.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_consumer_lead", "type": "rds" }, "trace_context": { "parent_id": 16090194528083470932, "service_name": "sparefoot", "span_id": 1208505535332094122, "trace_id": 16090194528083470932 } } - running: False
- schema_name_id: 1359
- start_time: 2026-04-05 00:07:17
- success: True
- trace_id: 16090194528083470932
-
Scan 6408928
- duration: 0:00:14.264966
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6408928
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_consumer_lead/2026-04-04/1775279361", "key": "raw/sparefoot_consumer_lead/2026-04-04/1775279361/consumer_lead_1.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_consumer_lead", "type": "rds" }, "trace_context": { "parent_id": 17295755741324053067, "service_name": "sparefoot", "span_id": 13959634606550735757, "trace_id": 17295755741324053067 } } - running: False
- schema_name_id: 1359
- start_time: 2026-04-04 00:09:30
- success: True
- trace_id: 17295755741324053067
-
Scan 6408427
- duration: 0:00:11.751817
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6408427
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_consumer_lead/2026-04-03/1775192922", "key": "raw/sparefoot_consumer_lead/2026-04-03/1775192922/consumer_lead_1.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_consumer_lead", "type": "rds" }, "trace_context": { "parent_id": 17394590565158469182, "service_name": "sparefoot", "span_id": 5487268930175974985, "trace_id": 17394590565158469182 } } - running: False
- schema_name_id: 1359
- start_time: 2026-04-03 00:08:48
- success: True
- trace_id: 17394590565158469182
- 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 00:19:38
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_consumer_lead/2026-04-17/1776403172'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_consumer_lead`", "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_consumer_lead" }
- hostname: schemamanager-5c55c886bf-h2ts4
- name: schema_manager
- process_start: 2025-10-21 13:03:27
- sf_env: stage
- version: 2112174301
{
"name": {
"created": "2022-08-12 10:30:29",
"disabled": false,
"format": "raw",
"id": 1359,
"is_partitioned": false,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_stage_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 00:19:38",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_consumer_lead/2026-04-17/1776403172'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_consumer_lead`",
"repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_consumer_lead"
}
},
"server": {
"hostname": "schemamanager-5c55c886bf-h2ts4",
"name": "schema_manager",
"process_start": "2025-10-21 13:03:27",
"sf_env": "stage",
"version": "2112174301"
}
}