Schema Info

Schema Name: sfdl_stage_rds.sparefoot_sparefoot_cdp_matches

created: 2022-08-12 11:06:37
disabled: False
format: raw
id: 1404
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 906591

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_cdp_matches`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_cdp_matches/2026-04-17/1776405054'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_cdp_matches"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_cdp_matches/2026-04-17/1776405054
id: 906591
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: 1404
schema_scan_id: 6415159
updated: 2026-04-17 00:51:47

Version 906376

created: 2026-04-16 00:51:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_cdp_matches`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_cdp_matches/2026-04-16/1776318655'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_cdp_matches"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_cdp_matches/2026-04-16/1776318655
id: 906376
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: 1404
schema_scan_id: 6414615
updated: 2026-04-16 00:51:42

Version 906163

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_cdp_matches`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_cdp_matches/2026-04-15/1776232329'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_cdp_matches"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_cdp_matches/2026-04-15/1776232329
id: 906163
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: 1404
schema_scan_id: 6414127
updated: 2026-04-15 00:52:46

Version 905949

created: 2026-04-14 00:54:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_cdp_matches`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_cdp_matches/2026-04-14/1776146038'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_cdp_matches"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_cdp_matches/2026-04-14/1776146038
id: 905949
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: 1404
schema_scan_id: 6413618
updated: 2026-04-14 00:54:46

Version 905733

created: 2026-04-13 00:58:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_cdp_matches`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_cdp_matches/2026-04-13/1776059868'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_cdp_matches"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_cdp_matches/2026-04-13/1776059868
id: 905733
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: 1404
schema_scan_id: 6413078
updated: 2026-04-13 00:58:21

Version 905531

created: 2026-04-12 00:52:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_cdp_matches`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_cdp_matches/2026-04-12/1775973144'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_cdp_matches"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_cdp_matches/2026-04-12/1775973144
id: 905531
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: 1404
schema_scan_id: 6412683
updated: 2026-04-12 00:53:08

Version 905329

created: 2026-04-11 00:48:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_cdp_matches`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_cdp_matches/2026-04-11/1775886493'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_cdp_matches"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_cdp_matches/2026-04-11/1775886493
id: 905329
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: 1404
schema_scan_id: 6412302
updated: 2026-04-11 00:48:52

Version 905115

created: 2026-04-10 00:49:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_cdp_matches`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_cdp_matches/2026-04-10/1775800160'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_cdp_matches"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_cdp_matches/2026-04-10/1775800160
id: 905115
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: 1404
schema_scan_id: 6411804
updated: 2026-04-10 00:49:57

Version 904901

created: 2026-04-09 00:51:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_cdp_matches`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_cdp_matches/2026-04-09/1775713855'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_cdp_matches"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_cdp_matches/2026-04-09/1775713855
id: 904901
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: 1404
schema_scan_id: 6411288
updated: 2026-04-09 00:51:31

Version 904686

created: 2026-04-08 00:45:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_cdp_matches`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_cdp_matches/2026-04-08/1775627081'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_cdp_matches"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_cdp_matches/2026-04-08/1775627081
id: 904686
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: 1404
schema_scan_id: 6410789
updated: 2026-04-08 00:45:23

Version 904473

created: 2026-04-07 00:51:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_cdp_matches`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_cdp_matches/2026-04-07/1775541075'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_cdp_matches"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_cdp_matches/2026-04-07/1775541075
id: 904473
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: 1404
schema_scan_id: 6410277
updated: 2026-04-07 00:51:57

Version 904259

created: 2026-04-06 00:51:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_cdp_matches`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_cdp_matches/2026-04-06/1775454636'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_cdp_matches"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_cdp_matches/2026-04-06/1775454636
id: 904259
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: 1404
schema_scan_id: 6409735
updated: 2026-04-06 00:51:23

Version 904057

created: 2026-04-05 00:51:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_cdp_matches`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_cdp_matches/2026-04-05/1775368254'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_cdp_matches"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_cdp_matches/2026-04-05/1775368254
id: 904057
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: 1404
schema_scan_id: 6409353
updated: 2026-04-05 00:51:25

Version 903855

created: 2026-04-04 00:51:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_cdp_matches`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_cdp_matches/2026-04-04/1775281869'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_cdp_matches"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_cdp_matches/2026-04-04/1775281869
id: 903855
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: 1404
schema_scan_id: 6408972
updated: 2026-04-04 00:51:56

Version 903641

created: 2026-04-03 00:50:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_cdp_matches`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_cdp_matches/2026-04-03/1775195386'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_cdp_matches"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_cdp_matches/2026-04-03/1775195386
id: 903641
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: 1404
schema_scan_id: 6408477
updated: 2026-04-03 00:50:21

Schema Scans: 15

Last at 2026-04-17 00:51:32

Scan 6415159

duration: 0:00:14.831463

exit_message:

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

id: 6415159

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_cdp_matches/2026-04-17/1776405054",
        "key": "raw/sparefoot_cdp_matches/2026-04-17/1776405054/cdp_matches_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_cdp_matches",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16539586925756962226,
        "service_name": "sparefoot",
        "span_id": 16954557575982564318,
        "trace_id": 16539586925756962226
    }
}

running: False
schema_name_id: 1404
start_time: 2026-04-17 00:51:32
success: True
trace_id: 16539586925756962226

Scan 6414615

duration: 0:00:14.934321

exit_message:

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

id: 6414615

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_cdp_matches/2026-04-16/1776318655",
        "key": "raw/sparefoot_cdp_matches/2026-04-16/1776318655/cdp_matches_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_cdp_matches",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7979013232191321022,
        "service_name": "sparefoot",
        "span_id": 2491430878059895160,
        "trace_id": 7979013232191321022
    }
}

running: False
schema_name_id: 1404
start_time: 2026-04-16 00:51:27
success: True
trace_id: 7979013232191321022

Scan 6414127

duration: 0:00:12.459789

exit_message:

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

id: 6414127

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_cdp_matches/2026-04-15/1776232329",
        "key": "raw/sparefoot_cdp_matches/2026-04-15/1776232329/cdp_matches_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_cdp_matches",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7565723810637955221,
        "service_name": "sparefoot",
        "span_id": 11984825831021891445,
        "trace_id": 7565723810637955221
    }
}

running: False
schema_name_id: 1404
start_time: 2026-04-15 00:52:34
success: True
trace_id: 7565723810637955221

Scan 6413618

duration: 0:00:12.180297

exit_message:

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

id: 6413618

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_cdp_matches/2026-04-14/1776146038",
        "key": "raw/sparefoot_cdp_matches/2026-04-14/1776146038/cdp_matches_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_cdp_matches",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1056484274297859045,
        "service_name": "sparefoot",
        "span_id": 15112745505159722312,
        "trace_id": 1056484274297859045
    }
}

running: False
schema_name_id: 1404
start_time: 2026-04-14 00:54:34
success: True
trace_id: 1056484274297859045

Scan 6413078

duration: 0:00:14.927416

exit_message:

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

id: 6413078

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_cdp_matches/2026-04-13/1776059868",
        "key": "raw/sparefoot_cdp_matches/2026-04-13/1776059868/cdp_matches_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_cdp_matches",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9228329306995586227,
        "service_name": "sparefoot",
        "span_id": 10363639184426240753,
        "trace_id": 9228329306995586227
    }
}

running: False
schema_name_id: 1404
start_time: 2026-04-13 00:58:06
success: True
trace_id: 9228329306995586227

Scan 6412683

duration: 0:00:14.930612

exit_message:

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

id: 6412683

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_cdp_matches/2026-04-12/1775973144",
        "key": "raw/sparefoot_cdp_matches/2026-04-12/1775973144/cdp_matches_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_cdp_matches",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15514674818171163883,
        "service_name": "sparefoot",
        "span_id": 9680328647129588513,
        "trace_id": 15514674818171163883
    }
}

running: False
schema_name_id: 1404
start_time: 2026-04-12 00:52:53
success: True
trace_id: 15514674818171163883

Scan 6412302

duration: 0:00:12.174311

exit_message:

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

id: 6412302

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_cdp_matches/2026-04-11/1775886493",
        "key": "raw/sparefoot_cdp_matches/2026-04-11/1775886493/cdp_matches_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_cdp_matches",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17215214715079827675,
        "service_name": "sparefoot",
        "span_id": 10622078806531884637,
        "trace_id": 17215214715079827675
    }
}

running: False
schema_name_id: 1404
start_time: 2026-04-11 00:48:40
success: True
trace_id: 17215214715079827675

Scan 6411804

duration: 0:00:12.208685

exit_message:

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

id: 6411804

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_cdp_matches/2026-04-10/1775800160",
        "key": "raw/sparefoot_cdp_matches/2026-04-10/1775800160/cdp_matches_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_cdp_matches",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13981294740150708932,
        "service_name": "sparefoot",
        "span_id": 8645216454476371855,
        "trace_id": 13981294740150708932
    }
}

running: False
schema_name_id: 1404
start_time: 2026-04-10 00:49:45
success: True
trace_id: 13981294740150708932

Scan 6411288

duration: 0:00:12.459110

exit_message:

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

id: 6411288

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_cdp_matches/2026-04-09/1775713855",
        "key": "raw/sparefoot_cdp_matches/2026-04-09/1775713855/cdp_matches_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_cdp_matches",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4138518550056220664,
        "service_name": "sparefoot",
        "span_id": 10544138732848841730,
        "trace_id": 4138518550056220664
    }
}

running: False
schema_name_id: 1404
start_time: 2026-04-09 00:51:18
success: True
trace_id: 4138518550056220664

Scan 6410789

duration: 0:00:12.473352

exit_message:

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

id: 6410789

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_cdp_matches/2026-04-08/1775627081",
        "key": "raw/sparefoot_cdp_matches/2026-04-08/1775627081/cdp_matches_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_cdp_matches",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7489280947087613031,
        "service_name": "sparefoot",
        "span_id": 15887615449308033422,
        "trace_id": 7489280947087613031
    }
}

running: False
schema_name_id: 1404
start_time: 2026-04-08 00:45:11
success: True
trace_id: 7489280947087613031

Scan 6410277

duration: 0:00:14.826869

exit_message:

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

id: 6410277

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_cdp_matches/2026-04-07/1775541075",
        "key": "raw/sparefoot_cdp_matches/2026-04-07/1775541075/cdp_matches_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_cdp_matches",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15400607562965133654,
        "service_name": "sparefoot",
        "span_id": 5819526624036527247,
        "trace_id": 15400607562965133654
    }
}

running: False
schema_name_id: 1404
start_time: 2026-04-07 00:51:43
success: True
trace_id: 15400607562965133654

Scan 6409735

duration: 0:00:14.801421

exit_message:

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

id: 6409735

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_cdp_matches/2026-04-06/1775454636",
        "key": "raw/sparefoot_cdp_matches/2026-04-06/1775454636/cdp_matches_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_cdp_matches",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15112644516835900224,
        "service_name": "sparefoot",
        "span_id": 15316463200174780001,
        "trace_id": 15112644516835900224
    }
}

running: False
schema_name_id: 1404
start_time: 2026-04-06 00:51:08
success: True
trace_id: 15112644516835900224

Scan 6409353

duration: 0:00:12.257380

exit_message:

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

id: 6409353

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_cdp_matches/2026-04-05/1775368254",
        "key": "raw/sparefoot_cdp_matches/2026-04-05/1775368254/cdp_matches_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_cdp_matches",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2943773015453959124,
        "service_name": "sparefoot",
        "span_id": 6799523869963251490,
        "trace_id": 2943773015453959124
    }
}

running: False
schema_name_id: 1404
start_time: 2026-04-05 00:51:12
success: True
trace_id: 2943773015453959124

Scan 6408972

duration: 0:00:14.718699

exit_message:

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

id: 6408972

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_cdp_matches/2026-04-04/1775281869",
        "key": "raw/sparefoot_cdp_matches/2026-04-04/1775281869/cdp_matches_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_cdp_matches",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14717060610198142769,
        "service_name": "sparefoot",
        "span_id": 2229562213070997947,
        "trace_id": 14717060610198142769
    }
}

running: False
schema_name_id: 1404
start_time: 2026-04-04 00:51:41
success: True
trace_id: 14717060610198142769

Scan 6408477

duration: 0:00:12.584987

exit_message:

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

id: 6408477

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_cdp_matches/2026-04-03/1775195386",
        "key": "raw/sparefoot_cdp_matches/2026-04-03/1775195386/cdp_matches_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_cdp_matches",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10798709156483979888,
        "service_name": "sparefoot",
        "span_id": 609721192030076466,
        "trace_id": 10798709156483979888
    }
}

running: False
schema_name_id: 1404
start_time: 2026-04-03 00:50:08
success: True
trace_id: 10798709156483979888

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 00:51:33

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_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-stage/raw/sparefoot_cdp_matches/2026-04-17/1776405054'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_cdp_matches`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_cdp_matches"
}

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2022-08-12 11:06:37",
        "disabled": false,
        "format": "raw",
        "id": 1404,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_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 00:51:33",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_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-stage/raw/sparefoot_cdp_matches/2026-04-17/1776405054'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_cdp_matches`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_cdp_matches"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}