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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state:
    []
  • type: None
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
Raw:
{
    "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"
    }
}