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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
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 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
Raw:
{
    "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"
    }
}