Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_cdp_matches

created: 2022-08-18 18:12:41
disabled: False
format: raw
id: 1151
is_partitioned: False
is_schema_datatyped: False

name:

{
    "database": "sfdl_prod_rds",
    "table": "sparefoot_sparefoot_cdp_matches"
}

type: rds

Schema Versions: 15

Version 1718436

created: 2026-04-17 14:59:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`\n(\n `confirmation_code`  string , `created`  timestamp , `facility_tenant_id`  string , `m_booking_email`  int , `m_booking_first_and_last_name`  int , `m_booking_first_initial_and_last_name`  int , `m_booking_last_name_only`  int , `m_booking_phone`  int , `m_confirmation_code`  int , `m_customer_id`  int , `m_days_between_scheduled_and_actual_move_in`  int , `m_lead_id`  int , `m_sister_facility_distance`  int , `m_tenant_email`  int , `m_tenant_first_and_last_name`  int , `m_tenant_first_initial_and_last_name`  int , `m_tenant_last_name_only`  int , `m_tenant_phone`  int , `match_reasons`  string , `match_run_id`  int , `match_score`  double \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_cdp_matches/2026-04-17/1776455752'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_cdp_matches"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_cdp_matches/2026-04-17/1776455752
id: 1718436
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "created": "timestamp[ns]",
    "facility_tenant_id": "string",
    "m_booking_email": "int32",
    "m_booking_first_and_last_name": "int32",
    "m_booking_first_initial_and_last_name": "int32",
    "m_booking_last_name_only": "int32",
    "m_booking_phone": "int32",
    "m_confirmation_code": "int32",
    "m_customer_id": "int32",
    "m_days_between_scheduled_and_actual_move_in": "int32",
    "m_lead_id": "int32",
    "m_sister_facility_distance": "int32",
    "m_tenant_email": "int32",
    "m_tenant_first_and_last_name": "int32",
    "m_tenant_first_initial_and_last_name": "int32",
    "m_tenant_last_name_only": "int32",
    "m_tenant_phone": "int32",
    "match_reasons": "string",
    "match_run_id": "int32",
    "match_score": "double"
}

schema_attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "facility_tenant_id": "string",
    "m_booking_email": "int",
    "m_booking_first_and_last_name": "int",
    "m_booking_first_initial_and_last_name": "int",
    "m_booking_last_name_only": "int",
    "m_booking_phone": "int",
    "m_confirmation_code": "int",
    "m_customer_id": "int",
    "m_days_between_scheduled_and_actual_move_in": "int",
    "m_lead_id": "int",
    "m_sister_facility_distance": "int",
    "m_tenant_email": "int",
    "m_tenant_first_and_last_name": "int",
    "m_tenant_first_initial_and_last_name": "int",
    "m_tenant_last_name_only": "int",
    "m_tenant_phone": "int",
    "match_reasons": "string",
    "match_run_id": "int",
    "match_score": "double"
}

schema_name_id: 1151
schema_scan_id: 162195670
updated: 2026-04-17 15:00:01

Version 1718286

created: 2026-04-17 10:01:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`\n(\n `confirmation_code`  string , `created`  timestamp , `facility_tenant_id`  string , `m_booking_email`  int , `m_booking_first_and_last_name`  int , `m_booking_first_initial_and_last_name`  int , `m_booking_last_name_only`  int , `m_booking_phone`  int , `m_confirmation_code`  int , `m_customer_id`  int , `m_days_between_scheduled_and_actual_move_in`  int , `m_lead_id`  int , `m_sister_facility_distance`  int , `m_tenant_email`  int , `m_tenant_first_and_last_name`  int , `m_tenant_first_initial_and_last_name`  int , `m_tenant_last_name_only`  int , `m_tenant_phone`  int , `match_reasons`  string , `match_run_id`  int , `match_score`  double \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_cdp_matches/2026-04-17/1776437843'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_cdp_matches"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_cdp_matches/2026-04-17/1776437843
id: 1718286
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "created": "timestamp[ns]",
    "facility_tenant_id": "string",
    "m_booking_email": "int32",
    "m_booking_first_and_last_name": "int32",
    "m_booking_first_initial_and_last_name": "int32",
    "m_booking_last_name_only": "int32",
    "m_booking_phone": "int32",
    "m_confirmation_code": "int32",
    "m_customer_id": "int32",
    "m_days_between_scheduled_and_actual_move_in": "int32",
    "m_lead_id": "int32",
    "m_sister_facility_distance": "int32",
    "m_tenant_email": "int32",
    "m_tenant_first_and_last_name": "int32",
    "m_tenant_first_initial_and_last_name": "int32",
    "m_tenant_last_name_only": "int32",
    "m_tenant_phone": "int32",
    "match_reasons": "string",
    "match_run_id": "int32",
    "match_score": "double"
}

schema_attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "facility_tenant_id": "string",
    "m_booking_email": "int",
    "m_booking_first_and_last_name": "int",
    "m_booking_first_initial_and_last_name": "int",
    "m_booking_last_name_only": "int",
    "m_booking_phone": "int",
    "m_confirmation_code": "int",
    "m_customer_id": "int",
    "m_days_between_scheduled_and_actual_move_in": "int",
    "m_lead_id": "int",
    "m_sister_facility_distance": "int",
    "m_tenant_email": "int",
    "m_tenant_first_and_last_name": "int",
    "m_tenant_first_initial_and_last_name": "int",
    "m_tenant_last_name_only": "int",
    "m_tenant_phone": "int",
    "match_reasons": "string",
    "match_run_id": "int",
    "match_score": "double"
}

schema_name_id: 1151
schema_scan_id: 162180005
updated: 2026-04-17 10:01:25

Version 1717491

created: 2026-04-17 00:51:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`\n(\n `confirmation_code`  string , `created`  timestamp , `facility_tenant_id`  string , `m_booking_email`  int , `m_booking_first_and_last_name`  int , `m_booking_first_initial_and_last_name`  int , `m_booking_last_name_only`  int , `m_booking_phone`  int , `m_confirmation_code`  int , `m_customer_id`  int , `m_days_between_scheduled_and_actual_move_in`  int , `m_lead_id`  int , `m_sister_facility_distance`  int , `m_tenant_email`  int , `m_tenant_first_and_last_name`  int , `m_tenant_first_initial_and_last_name`  int , `m_tenant_last_name_only`  int , `m_tenant_phone`  int , `match_reasons`  string , `match_run_id`  int , `match_score`  double \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_cdp_matches/2026-04-17/1776405055'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_cdp_matches"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_cdp_matches/2026-04-17/1776405055
id: 1717491
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "created": "timestamp[ns]",
    "facility_tenant_id": "string",
    "m_booking_email": "int32",
    "m_booking_first_and_last_name": "int32",
    "m_booking_first_initial_and_last_name": "int32",
    "m_booking_last_name_only": "int32",
    "m_booking_phone": "int32",
    "m_confirmation_code": "int32",
    "m_customer_id": "int32",
    "m_days_between_scheduled_and_actual_move_in": "int32",
    "m_lead_id": "int32",
    "m_sister_facility_distance": "int32",
    "m_tenant_email": "int32",
    "m_tenant_first_and_last_name": "int32",
    "m_tenant_first_initial_and_last_name": "int32",
    "m_tenant_last_name_only": "int32",
    "m_tenant_phone": "int32",
    "match_reasons": "string",
    "match_run_id": "int32",
    "match_score": "double"
}

schema_attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "facility_tenant_id": "string",
    "m_booking_email": "int",
    "m_booking_first_and_last_name": "int",
    "m_booking_first_initial_and_last_name": "int",
    "m_booking_last_name_only": "int",
    "m_booking_phone": "int",
    "m_confirmation_code": "int",
    "m_customer_id": "int",
    "m_days_between_scheduled_and_actual_move_in": "int",
    "m_lead_id": "int",
    "m_sister_facility_distance": "int",
    "m_tenant_email": "int",
    "m_tenant_first_and_last_name": "int",
    "m_tenant_first_initial_and_last_name": "int",
    "m_tenant_last_name_only": "int",
    "m_tenant_phone": "int",
    "match_reasons": "string",
    "match_run_id": "int",
    "match_score": "double"
}

schema_name_id: 1151
schema_scan_id: 162163858
updated: 2026-04-17 00:51:34

Version 1717380

created: 2026-04-16 20:54:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`\n(\n `confirmation_code`  string , `created`  timestamp , `facility_tenant_id`  string , `m_booking_email`  int , `m_booking_first_and_last_name`  int , `m_booking_first_initial_and_last_name`  int , `m_booking_last_name_only`  int , `m_booking_phone`  int , `m_confirmation_code`  int , `m_customer_id`  int , `m_days_between_scheduled_and_actual_move_in`  int , `m_lead_id`  int , `m_sister_facility_distance`  int , `m_tenant_email`  int , `m_tenant_first_and_last_name`  int , `m_tenant_first_initial_and_last_name`  int , `m_tenant_last_name_only`  int , `m_tenant_phone`  int , `match_reasons`  string , `match_run_id`  int , `match_score`  double \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_cdp_matches/2026-04-16/1776390835'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_cdp_matches"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_cdp_matches/2026-04-16/1776390835
id: 1717380
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "created": "timestamp[ns]",
    "facility_tenant_id": "string",
    "m_booking_email": "int32",
    "m_booking_first_and_last_name": "int32",
    "m_booking_first_initial_and_last_name": "int32",
    "m_booking_last_name_only": "int32",
    "m_booking_phone": "int32",
    "m_confirmation_code": "int32",
    "m_customer_id": "int32",
    "m_days_between_scheduled_and_actual_move_in": "int32",
    "m_lead_id": "int32",
    "m_sister_facility_distance": "int32",
    "m_tenant_email": "int32",
    "m_tenant_first_and_last_name": "int32",
    "m_tenant_first_initial_and_last_name": "int32",
    "m_tenant_last_name_only": "int32",
    "m_tenant_phone": "int32",
    "match_reasons": "string",
    "match_run_id": "int32",
    "match_score": "double"
}

schema_attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "facility_tenant_id": "string",
    "m_booking_email": "int",
    "m_booking_first_and_last_name": "int",
    "m_booking_first_initial_and_last_name": "int",
    "m_booking_last_name_only": "int",
    "m_booking_phone": "int",
    "m_confirmation_code": "int",
    "m_customer_id": "int",
    "m_days_between_scheduled_and_actual_move_in": "int",
    "m_lead_id": "int",
    "m_sister_facility_distance": "int",
    "m_tenant_email": "int",
    "m_tenant_first_and_last_name": "int",
    "m_tenant_first_initial_and_last_name": "int",
    "m_tenant_last_name_only": "int",
    "m_tenant_phone": "int",
    "match_reasons": "string",
    "match_run_id": "int",
    "match_score": "double"
}

schema_name_id: 1151
schema_scan_id: 162156369
updated: 2026-04-16 20:54:51

Version 1717211

created: 2026-04-16 15:02:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`\n(\n `confirmation_code`  string , `created`  timestamp , `facility_tenant_id`  string , `m_booking_email`  int , `m_booking_first_and_last_name`  int , `m_booking_first_initial_and_last_name`  int , `m_booking_last_name_only`  int , `m_booking_phone`  int , `m_confirmation_code`  int , `m_customer_id`  int , `m_days_between_scheduled_and_actual_move_in`  int , `m_lead_id`  int , `m_sister_facility_distance`  int , `m_tenant_email`  int , `m_tenant_first_and_last_name`  int , `m_tenant_first_initial_and_last_name`  int , `m_tenant_last_name_only`  int , `m_tenant_phone`  int , `match_reasons`  string , `match_run_id`  int , `match_score`  double \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_cdp_matches/2026-04-16/1776369517'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_cdp_matches"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_cdp_matches/2026-04-16/1776369517
id: 1717211
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "created": "timestamp[ns]",
    "facility_tenant_id": "string",
    "m_booking_email": "int32",
    "m_booking_first_and_last_name": "int32",
    "m_booking_first_initial_and_last_name": "int32",
    "m_booking_last_name_only": "int32",
    "m_booking_phone": "int32",
    "m_confirmation_code": "int32",
    "m_customer_id": "int32",
    "m_days_between_scheduled_and_actual_move_in": "int32",
    "m_lead_id": "int32",
    "m_sister_facility_distance": "int32",
    "m_tenant_email": "int32",
    "m_tenant_first_and_last_name": "int32",
    "m_tenant_first_initial_and_last_name": "int32",
    "m_tenant_last_name_only": "int32",
    "m_tenant_phone": "int32",
    "match_reasons": "string",
    "match_run_id": "int32",
    "match_score": "double"
}

schema_attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "facility_tenant_id": "string",
    "m_booking_email": "int",
    "m_booking_first_and_last_name": "int",
    "m_booking_first_initial_and_last_name": "int",
    "m_booking_last_name_only": "int",
    "m_booking_phone": "int",
    "m_confirmation_code": "int",
    "m_customer_id": "int",
    "m_days_between_scheduled_and_actual_move_in": "int",
    "m_lead_id": "int",
    "m_sister_facility_distance": "int",
    "m_tenant_email": "int",
    "m_tenant_first_and_last_name": "int",
    "m_tenant_first_initial_and_last_name": "int",
    "m_tenant_last_name_only": "int",
    "m_tenant_phone": "int",
    "match_reasons": "string",
    "match_run_id": "int",
    "match_score": "double"
}

schema_name_id: 1151
schema_scan_id: 162140497
updated: 2026-04-16 15:03:15

Version 1717063

created: 2026-04-16 09:51:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`\n(\n `confirmation_code`  string , `created`  timestamp , `facility_tenant_id`  string , `m_booking_email`  int , `m_booking_first_and_last_name`  int , `m_booking_first_initial_and_last_name`  int , `m_booking_last_name_only`  int , `m_booking_phone`  int , `m_confirmation_code`  int , `m_customer_id`  int , `m_days_between_scheduled_and_actual_move_in`  int , `m_lead_id`  int , `m_sister_facility_distance`  int , `m_tenant_email`  int , `m_tenant_first_and_last_name`  int , `m_tenant_first_initial_and_last_name`  int , `m_tenant_last_name_only`  int , `m_tenant_phone`  int , `match_reasons`  string , `match_run_id`  int , `match_score`  double \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_cdp_matches/2026-04-16/1776351064'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_cdp_matches"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_cdp_matches/2026-04-16/1776351064
id: 1717063
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "created": "timestamp[ns]",
    "facility_tenant_id": "string",
    "m_booking_email": "int32",
    "m_booking_first_and_last_name": "int32",
    "m_booking_first_initial_and_last_name": "int32",
    "m_booking_last_name_only": "int32",
    "m_booking_phone": "int32",
    "m_confirmation_code": "int32",
    "m_customer_id": "int32",
    "m_days_between_scheduled_and_actual_move_in": "int32",
    "m_lead_id": "int32",
    "m_sister_facility_distance": "int32",
    "m_tenant_email": "int32",
    "m_tenant_first_and_last_name": "int32",
    "m_tenant_first_initial_and_last_name": "int32",
    "m_tenant_last_name_only": "int32",
    "m_tenant_phone": "int32",
    "match_reasons": "string",
    "match_run_id": "int32",
    "match_score": "double"
}

schema_attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "facility_tenant_id": "string",
    "m_booking_email": "int",
    "m_booking_first_and_last_name": "int",
    "m_booking_first_initial_and_last_name": "int",
    "m_booking_last_name_only": "int",
    "m_booking_phone": "int",
    "m_confirmation_code": "int",
    "m_customer_id": "int",
    "m_days_between_scheduled_and_actual_move_in": "int",
    "m_lead_id": "int",
    "m_sister_facility_distance": "int",
    "m_tenant_email": "int",
    "m_tenant_first_and_last_name": "int",
    "m_tenant_first_initial_and_last_name": "int",
    "m_tenant_last_name_only": "int",
    "m_tenant_phone": "int",
    "match_reasons": "string",
    "match_run_id": "int",
    "match_score": "double"
}

schema_name_id: 1151
schema_scan_id: 162123243
updated: 2026-04-16 09:51:38

Version 1716254

created: 2026-04-16 00:49:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`\n(\n `confirmation_code`  string , `created`  timestamp , `facility_tenant_id`  string , `m_booking_email`  int , `m_booking_first_and_last_name`  int , `m_booking_first_initial_and_last_name`  int , `m_booking_last_name_only`  int , `m_booking_phone`  int , `m_confirmation_code`  int , `m_customer_id`  int , `m_days_between_scheduled_and_actual_move_in`  int , `m_lead_id`  int , `m_sister_facility_distance`  int , `m_tenant_email`  int , `m_tenant_first_and_last_name`  int , `m_tenant_first_initial_and_last_name`  int , `m_tenant_last_name_only`  int , `m_tenant_phone`  int , `match_reasons`  string , `match_run_id`  int , `match_score`  double \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_cdp_matches/2026-04-16/1776318577'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_cdp_matches"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_cdp_matches/2026-04-16/1776318577
id: 1716254
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "created": "timestamp[ns]",
    "facility_tenant_id": "string",
    "m_booking_email": "int32",
    "m_booking_first_and_last_name": "int32",
    "m_booking_first_initial_and_last_name": "int32",
    "m_booking_last_name_only": "int32",
    "m_booking_phone": "int32",
    "m_confirmation_code": "int32",
    "m_customer_id": "int32",
    "m_days_between_scheduled_and_actual_move_in": "int32",
    "m_lead_id": "int32",
    "m_sister_facility_distance": "int32",
    "m_tenant_email": "int32",
    "m_tenant_first_and_last_name": "int32",
    "m_tenant_first_initial_and_last_name": "int32",
    "m_tenant_last_name_only": "int32",
    "m_tenant_phone": "int32",
    "match_reasons": "string",
    "match_run_id": "int32",
    "match_score": "double"
}

schema_attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "facility_tenant_id": "string",
    "m_booking_email": "int",
    "m_booking_first_and_last_name": "int",
    "m_booking_first_initial_and_last_name": "int",
    "m_booking_last_name_only": "int",
    "m_booking_phone": "int",
    "m_confirmation_code": "int",
    "m_customer_id": "int",
    "m_days_between_scheduled_and_actual_move_in": "int",
    "m_lead_id": "int",
    "m_sister_facility_distance": "int",
    "m_tenant_email": "int",
    "m_tenant_first_and_last_name": "int",
    "m_tenant_first_initial_and_last_name": "int",
    "m_tenant_last_name_only": "int",
    "m_tenant_phone": "int",
    "match_reasons": "string",
    "match_run_id": "int",
    "match_score": "double"
}

schema_name_id: 1151
schema_scan_id: 162107916
updated: 2026-04-16 00:50:07

Version 1716147

created: 2026-04-15 21:03:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`\n(\n `confirmation_code`  string , `created`  timestamp , `facility_tenant_id`  string , `m_booking_email`  int , `m_booking_first_and_last_name`  int , `m_booking_first_initial_and_last_name`  int , `m_booking_last_name_only`  int , `m_booking_phone`  int , `m_confirmation_code`  int , `m_customer_id`  int , `m_days_between_scheduled_and_actual_move_in`  int , `m_lead_id`  int , `m_sister_facility_distance`  int , `m_tenant_email`  int , `m_tenant_first_and_last_name`  int , `m_tenant_first_initial_and_last_name`  int , `m_tenant_last_name_only`  int , `m_tenant_phone`  int , `match_reasons`  string , `match_run_id`  int , `match_score`  double \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_cdp_matches/2026-04-15/1776304797'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_cdp_matches"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_cdp_matches/2026-04-15/1776304797
id: 1716147
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "created": "timestamp[ns]",
    "facility_tenant_id": "string",
    "m_booking_email": "int32",
    "m_booking_first_and_last_name": "int32",
    "m_booking_first_initial_and_last_name": "int32",
    "m_booking_last_name_only": "int32",
    "m_booking_phone": "int32",
    "m_confirmation_code": "int32",
    "m_customer_id": "int32",
    "m_days_between_scheduled_and_actual_move_in": "int32",
    "m_lead_id": "int32",
    "m_sister_facility_distance": "int32",
    "m_tenant_email": "int32",
    "m_tenant_first_and_last_name": "int32",
    "m_tenant_first_initial_and_last_name": "int32",
    "m_tenant_last_name_only": "int32",
    "m_tenant_phone": "int32",
    "match_reasons": "string",
    "match_run_id": "int32",
    "match_score": "double"
}

schema_attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "facility_tenant_id": "string",
    "m_booking_email": "int",
    "m_booking_first_and_last_name": "int",
    "m_booking_first_initial_and_last_name": "int",
    "m_booking_last_name_only": "int",
    "m_booking_phone": "int",
    "m_confirmation_code": "int",
    "m_customer_id": "int",
    "m_days_between_scheduled_and_actual_move_in": "int",
    "m_lead_id": "int",
    "m_sister_facility_distance": "int",
    "m_tenant_email": "int",
    "m_tenant_first_and_last_name": "int",
    "m_tenant_first_initial_and_last_name": "int",
    "m_tenant_last_name_only": "int",
    "m_tenant_phone": "int",
    "match_reasons": "string",
    "match_run_id": "int",
    "match_score": "double"
}

schema_name_id: 1151
schema_scan_id: 162102139
updated: 2026-04-15 21:03:33

Version 1716012

created: 2026-04-15 14:56:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`\n(\n `confirmation_code`  string , `created`  timestamp , `facility_tenant_id`  string , `m_booking_email`  int , `m_booking_first_and_last_name`  int , `m_booking_first_initial_and_last_name`  int , `m_booking_last_name_only`  int , `m_booking_phone`  int , `m_confirmation_code`  int , `m_customer_id`  int , `m_days_between_scheduled_and_actual_move_in`  int , `m_lead_id`  int , `m_sister_facility_distance`  int , `m_tenant_email`  int , `m_tenant_first_and_last_name`  int , `m_tenant_first_initial_and_last_name`  int , `m_tenant_last_name_only`  int , `m_tenant_phone`  int , `match_reasons`  string , `match_run_id`  int , `match_score`  double \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_cdp_matches/2026-04-15/1776282965'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_cdp_matches"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_cdp_matches/2026-04-15/1776282965
id: 1716012
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "created": "timestamp[ns]",
    "facility_tenant_id": "string",
    "m_booking_email": "int32",
    "m_booking_first_and_last_name": "int32",
    "m_booking_first_initial_and_last_name": "int32",
    "m_booking_last_name_only": "int32",
    "m_booking_phone": "int32",
    "m_confirmation_code": "int32",
    "m_customer_id": "int32",
    "m_days_between_scheduled_and_actual_move_in": "int32",
    "m_lead_id": "int32",
    "m_sister_facility_distance": "int32",
    "m_tenant_email": "int32",
    "m_tenant_first_and_last_name": "int32",
    "m_tenant_first_initial_and_last_name": "int32",
    "m_tenant_last_name_only": "int32",
    "m_tenant_phone": "int32",
    "match_reasons": "string",
    "match_run_id": "int32",
    "match_score": "double"
}

schema_attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "facility_tenant_id": "string",
    "m_booking_email": "int",
    "m_booking_first_and_last_name": "int",
    "m_booking_first_initial_and_last_name": "int",
    "m_booking_last_name_only": "int",
    "m_booking_phone": "int",
    "m_confirmation_code": "int",
    "m_customer_id": "int",
    "m_days_between_scheduled_and_actual_move_in": "int",
    "m_lead_id": "int",
    "m_sister_facility_distance": "int",
    "m_tenant_email": "int",
    "m_tenant_first_and_last_name": "int",
    "m_tenant_first_initial_and_last_name": "int",
    "m_tenant_last_name_only": "int",
    "m_tenant_phone": "int",
    "match_reasons": "string",
    "match_run_id": "int",
    "match_score": "double"
}

schema_name_id: 1151
schema_scan_id: 162083528
updated: 2026-04-15 14:56:56

Version 1715820

created: 2026-04-15 09:24:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`\n(\n `confirmation_code`  string , `created`  timestamp , `facility_tenant_id`  string , `m_booking_email`  int , `m_booking_first_and_last_name`  int , `m_booking_first_initial_and_last_name`  int , `m_booking_last_name_only`  int , `m_booking_phone`  int , `m_confirmation_code`  int , `m_customer_id`  int , `m_days_between_scheduled_and_actual_move_in`  int , `m_lead_id`  int , `m_sister_facility_distance`  int , `m_tenant_email`  int , `m_tenant_first_and_last_name`  int , `m_tenant_first_initial_and_last_name`  int , `m_tenant_last_name_only`  int , `m_tenant_phone`  int , `match_reasons`  string , `match_run_id`  int , `match_score`  double \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_cdp_matches/2026-04-15/1776263038'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_cdp_matches"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_cdp_matches/2026-04-15/1776263038
id: 1715820
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "created": "timestamp[ns]",
    "facility_tenant_id": "string",
    "m_booking_email": "int32",
    "m_booking_first_and_last_name": "int32",
    "m_booking_first_initial_and_last_name": "int32",
    "m_booking_last_name_only": "int32",
    "m_booking_phone": "int32",
    "m_confirmation_code": "int32",
    "m_customer_id": "int32",
    "m_days_between_scheduled_and_actual_move_in": "int32",
    "m_lead_id": "int32",
    "m_sister_facility_distance": "int32",
    "m_tenant_email": "int32",
    "m_tenant_first_and_last_name": "int32",
    "m_tenant_first_initial_and_last_name": "int32",
    "m_tenant_last_name_only": "int32",
    "m_tenant_phone": "int32",
    "match_reasons": "string",
    "match_run_id": "int32",
    "match_score": "double"
}

schema_attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "facility_tenant_id": "string",
    "m_booking_email": "int",
    "m_booking_first_and_last_name": "int",
    "m_booking_first_initial_and_last_name": "int",
    "m_booking_last_name_only": "int",
    "m_booking_phone": "int",
    "m_confirmation_code": "int",
    "m_customer_id": "int",
    "m_days_between_scheduled_and_actual_move_in": "int",
    "m_lead_id": "int",
    "m_sister_facility_distance": "int",
    "m_tenant_email": "int",
    "m_tenant_first_and_last_name": "int",
    "m_tenant_first_initial_and_last_name": "int",
    "m_tenant_last_name_only": "int",
    "m_tenant_phone": "int",
    "match_reasons": "string",
    "match_run_id": "int",
    "match_score": "double"
}

schema_name_id: 1151
schema_scan_id: 162066818
updated: 2026-04-15 09:24:40

Version 1715062

created: 2026-04-15 00:52:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`\n(\n `confirmation_code`  string , `created`  timestamp , `facility_tenant_id`  string , `m_booking_email`  int , `m_booking_first_and_last_name`  int , `m_booking_first_initial_and_last_name`  int , `m_booking_last_name_only`  int , `m_booking_phone`  int , `m_confirmation_code`  int , `m_customer_id`  int , `m_days_between_scheduled_and_actual_move_in`  int , `m_lead_id`  int , `m_sister_facility_distance`  int , `m_tenant_email`  int , `m_tenant_first_and_last_name`  int , `m_tenant_first_initial_and_last_name`  int , `m_tenant_last_name_only`  int , `m_tenant_phone`  int , `match_reasons`  string , `match_run_id`  int , `match_score`  double \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_cdp_matches/2026-04-15/1776232333'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_cdp_matches"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_cdp_matches/2026-04-15/1776232333
id: 1715062
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "created": "timestamp[ns]",
    "facility_tenant_id": "string",
    "m_booking_email": "int32",
    "m_booking_first_and_last_name": "int32",
    "m_booking_first_initial_and_last_name": "int32",
    "m_booking_last_name_only": "int32",
    "m_booking_phone": "int32",
    "m_confirmation_code": "int32",
    "m_customer_id": "int32",
    "m_days_between_scheduled_and_actual_move_in": "int32",
    "m_lead_id": "int32",
    "m_sister_facility_distance": "int32",
    "m_tenant_email": "int32",
    "m_tenant_first_and_last_name": "int32",
    "m_tenant_first_initial_and_last_name": "int32",
    "m_tenant_last_name_only": "int32",
    "m_tenant_phone": "int32",
    "match_reasons": "string",
    "match_run_id": "int32",
    "match_score": "double"
}

schema_attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "facility_tenant_id": "string",
    "m_booking_email": "int",
    "m_booking_first_and_last_name": "int",
    "m_booking_first_initial_and_last_name": "int",
    "m_booking_last_name_only": "int",
    "m_booking_phone": "int",
    "m_confirmation_code": "int",
    "m_customer_id": "int",
    "m_days_between_scheduled_and_actual_move_in": "int",
    "m_lead_id": "int",
    "m_sister_facility_distance": "int",
    "m_tenant_email": "int",
    "m_tenant_first_and_last_name": "int",
    "m_tenant_first_initial_and_last_name": "int",
    "m_tenant_last_name_only": "int",
    "m_tenant_phone": "int",
    "match_reasons": "string",
    "match_run_id": "int",
    "match_score": "double"
}

schema_name_id: 1151
schema_scan_id: 162052183
updated: 2026-04-15 00:52:50

Version 1714941

created: 2026-04-14 20:58:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`\n(\n `confirmation_code`  string , `created`  timestamp , `facility_tenant_id`  string , `m_booking_email`  int , `m_booking_first_and_last_name`  int , `m_booking_first_initial_and_last_name`  int , `m_booking_last_name_only`  int , `m_booking_phone`  int , `m_confirmation_code`  int , `m_customer_id`  int , `m_days_between_scheduled_and_actual_move_in`  int , `m_lead_id`  int , `m_sister_facility_distance`  int , `m_tenant_email`  int , `m_tenant_first_and_last_name`  int , `m_tenant_first_initial_and_last_name`  int , `m_tenant_last_name_only`  int , `m_tenant_phone`  int , `match_reasons`  string , `match_run_id`  int , `match_score`  double \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_cdp_matches/2026-04-14/1776218232'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_cdp_matches"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_cdp_matches/2026-04-14/1776218232
id: 1714941
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "created": "timestamp[ns]",
    "facility_tenant_id": "string",
    "m_booking_email": "int32",
    "m_booking_first_and_last_name": "int32",
    "m_booking_first_initial_and_last_name": "int32",
    "m_booking_last_name_only": "int32",
    "m_booking_phone": "int32",
    "m_confirmation_code": "int32",
    "m_customer_id": "int32",
    "m_days_between_scheduled_and_actual_move_in": "int32",
    "m_lead_id": "int32",
    "m_sister_facility_distance": "int32",
    "m_tenant_email": "int32",
    "m_tenant_first_and_last_name": "int32",
    "m_tenant_first_initial_and_last_name": "int32",
    "m_tenant_last_name_only": "int32",
    "m_tenant_phone": "int32",
    "match_reasons": "string",
    "match_run_id": "int32",
    "match_score": "double"
}

schema_attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "facility_tenant_id": "string",
    "m_booking_email": "int",
    "m_booking_first_and_last_name": "int",
    "m_booking_first_initial_and_last_name": "int",
    "m_booking_last_name_only": "int",
    "m_booking_phone": "int",
    "m_confirmation_code": "int",
    "m_customer_id": "int",
    "m_days_between_scheduled_and_actual_move_in": "int",
    "m_lead_id": "int",
    "m_sister_facility_distance": "int",
    "m_tenant_email": "int",
    "m_tenant_first_and_last_name": "int",
    "m_tenant_first_initial_and_last_name": "int",
    "m_tenant_last_name_only": "int",
    "m_tenant_phone": "int",
    "match_reasons": "string",
    "match_run_id": "int",
    "match_score": "double"
}

schema_name_id: 1151
schema_scan_id: 162044822
updated: 2026-04-14 20:58:16

Version 1714786

created: 2026-04-14 15:01:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`\n(\n `confirmation_code`  string , `created`  timestamp , `facility_tenant_id`  string , `m_booking_email`  int , `m_booking_first_and_last_name`  int , `m_booking_first_initial_and_last_name`  int , `m_booking_last_name_only`  int , `m_booking_phone`  int , `m_confirmation_code`  int , `m_customer_id`  int , `m_days_between_scheduled_and_actual_move_in`  int , `m_lead_id`  int , `m_sister_facility_distance`  int , `m_tenant_email`  int , `m_tenant_first_and_last_name`  int , `m_tenant_first_initial_and_last_name`  int , `m_tenant_last_name_only`  int , `m_tenant_phone`  int , `match_reasons`  string , `match_run_id`  int , `match_score`  double \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_cdp_matches/2026-04-14/1776196711'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_cdp_matches"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_cdp_matches/2026-04-14/1776196711
id: 1714786
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "created": "timestamp[ns]",
    "facility_tenant_id": "string",
    "m_booking_email": "int32",
    "m_booking_first_and_last_name": "int32",
    "m_booking_first_initial_and_last_name": "int32",
    "m_booking_last_name_only": "int32",
    "m_booking_phone": "int32",
    "m_confirmation_code": "int32",
    "m_customer_id": "int32",
    "m_days_between_scheduled_and_actual_move_in": "int32",
    "m_lead_id": "int32",
    "m_sister_facility_distance": "int32",
    "m_tenant_email": "int32",
    "m_tenant_first_and_last_name": "int32",
    "m_tenant_first_initial_and_last_name": "int32",
    "m_tenant_last_name_only": "int32",
    "m_tenant_phone": "int32",
    "match_reasons": "string",
    "match_run_id": "int32",
    "match_score": "double"
}

schema_attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "facility_tenant_id": "string",
    "m_booking_email": "int",
    "m_booking_first_and_last_name": "int",
    "m_booking_first_initial_and_last_name": "int",
    "m_booking_last_name_only": "int",
    "m_booking_phone": "int",
    "m_confirmation_code": "int",
    "m_customer_id": "int",
    "m_days_between_scheduled_and_actual_move_in": "int",
    "m_lead_id": "int",
    "m_sister_facility_distance": "int",
    "m_tenant_email": "int",
    "m_tenant_first_and_last_name": "int",
    "m_tenant_first_initial_and_last_name": "int",
    "m_tenant_last_name_only": "int",
    "m_tenant_phone": "int",
    "match_reasons": "string",
    "match_run_id": "int",
    "match_score": "double"
}

schema_name_id: 1151
schema_scan_id: 162028683
updated: 2026-04-14 15:01:49

Version 1714632

created: 2026-04-14 09:44:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`\n(\n `confirmation_code`  string , `created`  timestamp , `facility_tenant_id`  string , `m_booking_email`  int , `m_booking_first_and_last_name`  int , `m_booking_first_initial_and_last_name`  int , `m_booking_last_name_only`  int , `m_booking_phone`  int , `m_confirmation_code`  int , `m_customer_id`  int , `m_days_between_scheduled_and_actual_move_in`  int , `m_lead_id`  int , `m_sister_facility_distance`  int , `m_tenant_email`  int , `m_tenant_first_and_last_name`  int , `m_tenant_first_initial_and_last_name`  int , `m_tenant_last_name_only`  int , `m_tenant_phone`  int , `match_reasons`  string , `match_run_id`  int , `match_score`  double \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_cdp_matches/2026-04-14/1776177822'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_cdp_matches"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_cdp_matches/2026-04-14/1776177822
id: 1714632
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "created": "timestamp[ns]",
    "facility_tenant_id": "string",
    "m_booking_email": "int32",
    "m_booking_first_and_last_name": "int32",
    "m_booking_first_initial_and_last_name": "int32",
    "m_booking_last_name_only": "int32",
    "m_booking_phone": "int32",
    "m_confirmation_code": "int32",
    "m_customer_id": "int32",
    "m_days_between_scheduled_and_actual_move_in": "int32",
    "m_lead_id": "int32",
    "m_sister_facility_distance": "int32",
    "m_tenant_email": "int32",
    "m_tenant_first_and_last_name": "int32",
    "m_tenant_first_initial_and_last_name": "int32",
    "m_tenant_last_name_only": "int32",
    "m_tenant_phone": "int32",
    "match_reasons": "string",
    "match_run_id": "int32",
    "match_score": "double"
}

schema_attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "facility_tenant_id": "string",
    "m_booking_email": "int",
    "m_booking_first_and_last_name": "int",
    "m_booking_first_initial_and_last_name": "int",
    "m_booking_last_name_only": "int",
    "m_booking_phone": "int",
    "m_confirmation_code": "int",
    "m_customer_id": "int",
    "m_days_between_scheduled_and_actual_move_in": "int",
    "m_lead_id": "int",
    "m_sister_facility_distance": "int",
    "m_tenant_email": "int",
    "m_tenant_first_and_last_name": "int",
    "m_tenant_first_initial_and_last_name": "int",
    "m_tenant_last_name_only": "int",
    "m_tenant_phone": "int",
    "match_reasons": "string",
    "match_run_id": "int",
    "match_score": "double"
}

schema_name_id: 1151
schema_scan_id: 162011471
updated: 2026-04-14 09:44:24

Version 1713862

created: 2026-04-14 00:46:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`\n(\n `confirmation_code`  string , `created`  timestamp , `facility_tenant_id`  string , `m_booking_email`  int , `m_booking_first_and_last_name`  int , `m_booking_first_initial_and_last_name`  int , `m_booking_last_name_only`  int , `m_booking_phone`  int , `m_confirmation_code`  int , `m_customer_id`  int , `m_days_between_scheduled_and_actual_move_in`  int , `m_lead_id`  int , `m_sister_facility_distance`  int , `m_tenant_email`  int , `m_tenant_first_and_last_name`  int , `m_tenant_first_initial_and_last_name`  int , `m_tenant_last_name_only`  int , `m_tenant_phone`  int , `match_reasons`  string , `match_run_id`  int , `match_score`  double \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_cdp_matches/2026-04-14/1776145581'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_cdp_matches"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_cdp_matches/2026-04-14/1776145581
id: 1713862
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "created": "timestamp[ns]",
    "facility_tenant_id": "string",
    "m_booking_email": "int32",
    "m_booking_first_and_last_name": "int32",
    "m_booking_first_initial_and_last_name": "int32",
    "m_booking_last_name_only": "int32",
    "m_booking_phone": "int32",
    "m_confirmation_code": "int32",
    "m_customer_id": "int32",
    "m_days_between_scheduled_and_actual_move_in": "int32",
    "m_lead_id": "int32",
    "m_sister_facility_distance": "int32",
    "m_tenant_email": "int32",
    "m_tenant_first_and_last_name": "int32",
    "m_tenant_first_initial_and_last_name": "int32",
    "m_tenant_last_name_only": "int32",
    "m_tenant_phone": "int32",
    "match_reasons": "string",
    "match_run_id": "int32",
    "match_score": "double"
}

schema_attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "facility_tenant_id": "string",
    "m_booking_email": "int",
    "m_booking_first_and_last_name": "int",
    "m_booking_first_initial_and_last_name": "int",
    "m_booking_last_name_only": "int",
    "m_booking_phone": "int",
    "m_confirmation_code": "int",
    "m_customer_id": "int",
    "m_days_between_scheduled_and_actual_move_in": "int",
    "m_lead_id": "int",
    "m_sister_facility_distance": "int",
    "m_tenant_email": "int",
    "m_tenant_first_and_last_name": "int",
    "m_tenant_first_initial_and_last_name": "int",
    "m_tenant_last_name_only": "int",
    "m_tenant_phone": "int",
    "match_reasons": "string",
    "match_run_id": "int",
    "match_score": "double"
}

schema_name_id: 1151
schema_scan_id: 161996449
updated: 2026-04-14 00:47:05

Schema Scans: 15

Last at 2026-04-17 14:59:41

Scan 162195670

duration: 0:00:20.512406

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162195670

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_cdp_matches/2026-04-17/1776455752",
        "key": "raw/sparefoot_cdp_matches/2026-04-17/1776455752/cdp_matches_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_cdp_matches",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11677197432099544881,
        "service_name": "sparefoot",
        "span_id": 8500228774731732359,
        "trace_id": 11677197432099544881
    }
}

running: False
schema_name_id: 1151
start_time: 2026-04-17 14:59:41
success: True
trace_id: 11677197432099544881

Scan 162180005

duration: 0:00:18.576448

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162180005

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_cdp_matches/2026-04-17/1776437843",
        "key": "raw/sparefoot_cdp_matches/2026-04-17/1776437843/cdp_matches_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_cdp_matches",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8541275529109188694,
        "service_name": "sparefoot",
        "span_id": 3379402439818801714,
        "trace_id": 8541275529109188694
    }
}

running: False
schema_name_id: 1151
start_time: 2026-04-17 10:01:07
success: True
trace_id: 8541275529109188694

Scan 162163858

duration: 0:00:12.252661

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162163858

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_cdp_matches/2026-04-17/1776405055",
        "key": "raw/sparefoot_cdp_matches/2026-04-17/1776405055/cdp_matches_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_cdp_matches",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5384126229844261480,
        "service_name": "sparefoot",
        "span_id": 18097992593931704665,
        "trace_id": 5384126229844261480
    }
}

running: False
schema_name_id: 1151
start_time: 2026-04-17 00:51:21
success: True
trace_id: 5384126229844261480

Scan 162156369

duration: 0:00:14.943094

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162156369

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_cdp_matches/2026-04-16/1776390835",
        "key": "raw/sparefoot_cdp_matches/2026-04-16/1776390835/cdp_matches_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_cdp_matches",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14208406054352000320,
        "service_name": "sparefoot",
        "span_id": 11887237194691497363,
        "trace_id": 14208406054352000320
    }
}

running: False
schema_name_id: 1151
start_time: 2026-04-16 20:54:36
success: True
trace_id: 14208406054352000320

Scan 162140497

duration: 0:00:19.146558

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162140497

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_cdp_matches/2026-04-16/1776369517",
        "key": "raw/sparefoot_cdp_matches/2026-04-16/1776369517/cdp_matches_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_cdp_matches",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11575171994710217566,
        "service_name": "sparefoot",
        "span_id": 17127013530251353410,
        "trace_id": 11575171994710217566
    }
}

running: False
schema_name_id: 1151
start_time: 2026-04-16 15:02:56
success: True
trace_id: 11575171994710217566

Scan 162123243

duration: 0:00:14.869044

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162123243

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_cdp_matches/2026-04-16/1776351064",
        "key": "raw/sparefoot_cdp_matches/2026-04-16/1776351064/cdp_matches_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_cdp_matches",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6135076354990661484,
        "service_name": "sparefoot",
        "span_id": 9254932674790120117,
        "trace_id": 6135076354990661484
    }
}

running: False
schema_name_id: 1151
start_time: 2026-04-16 09:51:23
success: True
trace_id: 6135076354990661484

Scan 162107916

duration: 0:00:12.309737

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162107916

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_cdp_matches/2026-04-16/1776318577",
        "key": "raw/sparefoot_cdp_matches/2026-04-16/1776318577/cdp_matches_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_cdp_matches",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10652029963122892010,
        "service_name": "sparefoot",
        "span_id": 3554496378386298596,
        "trace_id": 10652029963122892010
    }
}

running: False
schema_name_id: 1151
start_time: 2026-04-16 00:49:55
success: True
trace_id: 10652029963122892010

Scan 162102139

duration: 0:00:14.810562

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162102139

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_cdp_matches/2026-04-15/1776304797",
        "key": "raw/sparefoot_cdp_matches/2026-04-15/1776304797/cdp_matches_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_cdp_matches",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3800978017614118233,
        "service_name": "sparefoot",
        "span_id": 2836192065409822044,
        "trace_id": 3800978017614118233
    }
}

running: False
schema_name_id: 1151
start_time: 2026-04-15 21:03:18
success: True
trace_id: 3800978017614118233

Scan 162083528

duration: 0:00:12.215434

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162083528

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_cdp_matches/2026-04-15/1776282965",
        "key": "raw/sparefoot_cdp_matches/2026-04-15/1776282965/cdp_matches_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_cdp_matches",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10516427526469010430,
        "service_name": "sparefoot",
        "span_id": 12342655040488021672,
        "trace_id": 10516427526469010430
    }
}

running: False
schema_name_id: 1151
start_time: 2026-04-15 14:56:44
success: True
trace_id: 10516427526469010430

Scan 162066818

duration: 0:00:14.670986

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162066818

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_cdp_matches/2026-04-15/1776263038",
        "key": "raw/sparefoot_cdp_matches/2026-04-15/1776263038/cdp_matches_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_cdp_matches",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10024376356424535314,
        "service_name": "sparefoot",
        "span_id": 10476414037895588337,
        "trace_id": 10024376356424535314
    }
}

running: False
schema_name_id: 1151
start_time: 2026-04-15 09:24:26
success: True
trace_id: 10024376356424535314

Scan 162052183

duration: 0:00:14.819139

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162052183

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_cdp_matches/2026-04-15/1776232333",
        "key": "raw/sparefoot_cdp_matches/2026-04-15/1776232333/cdp_matches_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_cdp_matches",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4191695393748900234,
        "service_name": "sparefoot",
        "span_id": 2266687387180840968,
        "trace_id": 4191695393748900234
    }
}

running: False
schema_name_id: 1151
start_time: 2026-04-15 00:52:36
success: True
trace_id: 4191695393748900234

Scan 162044822

duration: 0:00:12.352155

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162044822

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_cdp_matches/2026-04-14/1776218232",
        "key": "raw/sparefoot_cdp_matches/2026-04-14/1776218232/cdp_matches_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_cdp_matches",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7536725987071082211,
        "service_name": "sparefoot",
        "span_id": 16637202078908018901,
        "trace_id": 7536725987071082211
    }
}

running: False
schema_name_id: 1151
start_time: 2026-04-14 20:58:04
success: True
trace_id: 7536725987071082211

Scan 162028683

duration: 0:00:15.099659

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162028683

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_cdp_matches/2026-04-14/1776196711",
        "key": "raw/sparefoot_cdp_matches/2026-04-14/1776196711/cdp_matches_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_cdp_matches",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9662491879188102548,
        "service_name": "sparefoot",
        "span_id": 7450619738067860786,
        "trace_id": 9662491879188102548
    }
}

running: False
schema_name_id: 1151
start_time: 2026-04-14 15:01:34
success: True
trace_id: 9662491879188102548

Scan 162011471

duration: 0:00:12.230937

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162011471

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_cdp_matches/2026-04-14/1776177822",
        "key": "raw/sparefoot_cdp_matches/2026-04-14/1776177822/cdp_matches_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_cdp_matches",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14985246647928863229,
        "service_name": "sparefoot",
        "span_id": 8439185164897445040,
        "trace_id": 14985246647928863229
    }
}

running: False
schema_name_id: 1151
start_time: 2026-04-14 09:44:12
success: True
trace_id: 14985246647928863229

Scan 161996449

duration: 0:00:14.671122

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161996449

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_cdp_matches/2026-04-14/1776145581",
        "key": "raw/sparefoot_cdp_matches/2026-04-14/1776145581/cdp_matches_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_cdp_matches",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4242508701903098577,
        "service_name": "sparefoot",
        "span_id": 1055239038604929800,
        "trace_id": 4242508701903098577
    }
}

running: False
schema_name_id: 1151
start_time: 2026-04-14 00:46:51
success: True
trace_id: 4242508701903098577

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "facility_tenant_id": "string",
    "m_booking_email": "int",
    "m_booking_first_and_last_name": "int",
    "m_booking_first_initial_and_last_name": "int",
    "m_booking_last_name_only": "int",
    "m_booking_phone": "int",
    "m_confirmation_code": "int",
    "m_customer_id": "int",
    "m_days_between_scheduled_and_actual_move_in": "int",
    "m_lead_id": "int",
    "m_sister_facility_distance": "int",
    "m_tenant_email": "int",
    "m_tenant_first_and_last_name": "int",
    "m_tenant_first_initial_and_last_name": "int",
    "m_tenant_last_name_only": "int",
    "m_tenant_phone": "int",
    "match_reasons": "string",
    "match_run_id": "int",
    "match_score": "double"
}

created: 2026-04-17 14:59:42

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_cdp_matches`\n(\n `confirmation_code`  string , `created`  timestamp , `facility_tenant_id`  string , `m_booking_email`  int , `m_booking_first_and_last_name`  int , `m_booking_first_initial_and_last_name`  int , `m_booking_last_name_only`  int , `m_booking_phone`  int , `m_confirmation_code`  int , `m_customer_id`  int , `m_days_between_scheduled_and_actual_move_in`  int , `m_lead_id`  int , `m_sister_facility_distance`  int , `m_tenant_email`  int , `m_tenant_first_and_last_name`  int , `m_tenant_first_initial_and_last_name`  int , `m_tenant_last_name_only`  int , `m_tenant_phone`  int , `match_reasons`  string , `match_run_id`  int , `match_score`  double \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_cdp_matches/2026-04-17/1776455752'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_cdp_matches"
}

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 18:12:41",
        "disabled": false,
        "format": "raw",
        "id": 1151,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_rds",
            "table": "sparefoot_sparefoot_cdp_matches"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "confirmation_code": "string",
            "created": "timestamp",
            "facility_tenant_id": "string",
            "m_booking_email": "int",
            "m_booking_first_and_last_name": "int",
            "m_booking_first_initial_and_last_name": "int",
            "m_booking_last_name_only": "int",
            "m_booking_phone": "int",
            "m_confirmation_code": "int",
            "m_customer_id": "int",
            "m_days_between_scheduled_and_actual_move_in": "int",
            "m_lead_id": "int",
            "m_sister_facility_distance": "int",
            "m_tenant_email": "int",
            "m_tenant_first_and_last_name": "int",
            "m_tenant_first_initial_and_last_name": "int",
            "m_tenant_last_name_only": "int",
            "m_tenant_phone": "int",
            "match_reasons": "string",
            "match_run_id": "int",
            "match_score": "double"
        },
        "created": "2026-04-17 14:59:42",
        "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_cdp_matches`\n(\n `confirmation_code`  string , `created`  timestamp , `facility_tenant_id`  string , `m_booking_email`  int , `m_booking_first_and_last_name`  int , `m_booking_first_initial_and_last_name`  int , `m_booking_last_name_only`  int , `m_booking_phone`  int , `m_confirmation_code`  int , `m_customer_id`  int , `m_days_between_scheduled_and_actual_move_in`  int , `m_lead_id`  int , `m_sister_facility_distance`  int , `m_tenant_email`  int , `m_tenant_first_and_last_name`  int , `m_tenant_first_initial_and_last_name`  int , `m_tenant_last_name_only`  int , `m_tenant_phone`  int , `match_reasons`  string , `match_run_id`  int , `match_score`  double \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_cdp_matches/2026-04-17/1776455752'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_cdp_matches`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_cdp_matches"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}