Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_facility_yields

created: 2022-08-18 17:22:17
disabled: False
format: raw
id: 1119
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 1718392

created: 2026-04-17 14:15:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_yields`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_yields`\n(\n `avg_large_unit_price`  double , `avg_medium_unit_price`  double , `avg_small_unit_price`  double , `cpa`  double , `geo_specific_npv`  double , `last_modified`  timestamp , `listing_avail_id`  int , `move_in_rate`  double , `override_cpa`  double , `override_cpa_expire`  date , `override_move_in_rate`  double , `override_move_in_rate_expire`  date , `override_submit_rate`  double , `override_submit_rate_expire`  date , `resale_large_unit_price`  double , `resale_medium_unit_price`  double , `resale_small_unit_price`  double , `submit_rate`  double , `use_override_cpa`  smallint , `use_override_move_in_rate`  smallint , `use_override_submit_rate`  smallint \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_facility_yields/2026-04-17/1776453316'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_yields"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_yields/2026-04-17/1776453316
id: 1718392
processed: 1

raw_data:

{
    "avg_large_unit_price": "double",
    "avg_medium_unit_price": "double",
    "avg_small_unit_price": "double",
    "cpa": "double",
    "geo_specific_npv": "double",
    "last_modified": "timestamp[ns]",
    "listing_avail_id": "int32",
    "move_in_rate": "double",
    "override_cpa": "double",
    "override_cpa_expire": "date32[day]",
    "override_move_in_rate": "double",
    "override_move_in_rate_expire": "date32[day]",
    "override_submit_rate": "double",
    "override_submit_rate_expire": "date32[day]",
    "resale_large_unit_price": "double",
    "resale_medium_unit_price": "double",
    "resale_small_unit_price": "double",
    "submit_rate": "double",
    "use_override_cpa": "int16",
    "use_override_move_in_rate": "int16",
    "use_override_submit_rate": "int16"
}

schema_attributes:

{
    "avg_large_unit_price": "double",
    "avg_medium_unit_price": "double",
    "avg_small_unit_price": "double",
    "cpa": "double",
    "geo_specific_npv": "double",
    "last_modified": "timestamp",
    "listing_avail_id": "int",
    "move_in_rate": "double",
    "override_cpa": "double",
    "override_cpa_expire": "date",
    "override_move_in_rate": "double",
    "override_move_in_rate_expire": "date",
    "override_submit_rate": "double",
    "override_submit_rate_expire": "date",
    "resale_large_unit_price": "double",
    "resale_medium_unit_price": "double",
    "resale_small_unit_price": "double",
    "submit_rate": "double",
    "use_override_cpa": "smallint",
    "use_override_move_in_rate": "smallint",
    "use_override_submit_rate": "smallint"
}

schema_name_id: 1119
schema_scan_id: 162194006
updated: 2026-04-17 14:15:34

Version 1718216

created: 2026-04-17 09:23:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_yields`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_yields`\n(\n `avg_large_unit_price`  double , `avg_medium_unit_price`  double , `avg_small_unit_price`  double , `cpa`  double , `geo_specific_npv`  double , `last_modified`  timestamp , `listing_avail_id`  int , `move_in_rate`  double , `override_cpa`  double , `override_cpa_expire`  date , `override_move_in_rate`  double , `override_move_in_rate_expire`  date , `override_submit_rate`  double , `override_submit_rate_expire`  date , `resale_large_unit_price`  double , `resale_medium_unit_price`  double , `resale_small_unit_price`  double , `submit_rate`  double , `use_override_cpa`  smallint , `use_override_move_in_rate`  smallint , `use_override_submit_rate`  smallint \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_facility_yields/2026-04-17/1776435821'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_yields"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_yields/2026-04-17/1776435821
id: 1718216
processed: 1

raw_data:

{
    "avg_large_unit_price": "double",
    "avg_medium_unit_price": "double",
    "avg_small_unit_price": "double",
    "cpa": "double",
    "geo_specific_npv": "double",
    "last_modified": "timestamp[ns]",
    "listing_avail_id": "int32",
    "move_in_rate": "double",
    "override_cpa": "double",
    "override_cpa_expire": "date32[day]",
    "override_move_in_rate": "double",
    "override_move_in_rate_expire": "date32[day]",
    "override_submit_rate": "double",
    "override_submit_rate_expire": "date32[day]",
    "resale_large_unit_price": "double",
    "resale_medium_unit_price": "double",
    "resale_small_unit_price": "double",
    "submit_rate": "double",
    "use_override_cpa": "int16",
    "use_override_move_in_rate": "int16",
    "use_override_submit_rate": "int16"
}

schema_attributes:

{
    "avg_large_unit_price": "double",
    "avg_medium_unit_price": "double",
    "avg_small_unit_price": "double",
    "cpa": "double",
    "geo_specific_npv": "double",
    "last_modified": "timestamp",
    "listing_avail_id": "int",
    "move_in_rate": "double",
    "override_cpa": "double",
    "override_cpa_expire": "date",
    "override_move_in_rate": "double",
    "override_move_in_rate_expire": "date",
    "override_submit_rate": "double",
    "override_submit_rate_expire": "date",
    "resale_large_unit_price": "double",
    "resale_medium_unit_price": "double",
    "resale_small_unit_price": "double",
    "submit_rate": "double",
    "use_override_cpa": "smallint",
    "use_override_move_in_rate": "smallint",
    "use_override_submit_rate": "smallint"
}

schema_name_id: 1119
schema_scan_id: 162178313
updated: 2026-04-17 09:24:07

Version 1717438

created: 2026-04-17 00:07:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_yields`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_yields`\n(\n `avg_large_unit_price`  double , `avg_medium_unit_price`  double , `avg_small_unit_price`  double , `cpa`  double , `geo_specific_npv`  double , `last_modified`  timestamp , `listing_avail_id`  int , `move_in_rate`  double , `override_cpa`  double , `override_cpa_expire`  date , `override_move_in_rate`  double , `override_move_in_rate_expire`  date , `override_submit_rate`  double , `override_submit_rate_expire`  date , `resale_large_unit_price`  double , `resale_medium_unit_price`  double , `resale_small_unit_price`  double , `submit_rate`  double , `use_override_cpa`  smallint , `use_override_move_in_rate`  smallint , `use_override_submit_rate`  smallint \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_facility_yields/2026-04-17/1776402384'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_yields"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_yields/2026-04-17/1776402384
id: 1717438
processed: 1

raw_data:

{
    "avg_large_unit_price": "double",
    "avg_medium_unit_price": "double",
    "avg_small_unit_price": "double",
    "cpa": "double",
    "geo_specific_npv": "double",
    "last_modified": "timestamp[ns]",
    "listing_avail_id": "int32",
    "move_in_rate": "double",
    "override_cpa": "double",
    "override_cpa_expire": "date32[day]",
    "override_move_in_rate": "double",
    "override_move_in_rate_expire": "date32[day]",
    "override_submit_rate": "double",
    "override_submit_rate_expire": "date32[day]",
    "resale_large_unit_price": "double",
    "resale_medium_unit_price": "double",
    "resale_small_unit_price": "double",
    "submit_rate": "double",
    "use_override_cpa": "int16",
    "use_override_move_in_rate": "int16",
    "use_override_submit_rate": "int16"
}

schema_attributes:

{
    "avg_large_unit_price": "double",
    "avg_medium_unit_price": "double",
    "avg_small_unit_price": "double",
    "cpa": "double",
    "geo_specific_npv": "double",
    "last_modified": "timestamp",
    "listing_avail_id": "int",
    "move_in_rate": "double",
    "override_cpa": "double",
    "override_cpa_expire": "date",
    "override_move_in_rate": "double",
    "override_move_in_rate_expire": "date",
    "override_submit_rate": "double",
    "override_submit_rate_expire": "date",
    "resale_large_unit_price": "double",
    "resale_medium_unit_price": "double",
    "resale_small_unit_price": "double",
    "submit_rate": "double",
    "use_override_cpa": "smallint",
    "use_override_move_in_rate": "smallint",
    "use_override_submit_rate": "smallint"
}

schema_name_id: 1119
schema_scan_id: 162163570
updated: 2026-04-17 00:07:19

Version 1717315

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_yields`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_yields`\n(\n `avg_large_unit_price`  double , `avg_medium_unit_price`  double , `avg_small_unit_price`  double , `cpa`  double , `geo_specific_npv`  double , `last_modified`  timestamp , `listing_avail_id`  int , `move_in_rate`  double , `override_cpa`  double , `override_cpa_expire`  date , `override_move_in_rate`  double , `override_move_in_rate_expire`  date , `override_submit_rate`  double , `override_submit_rate_expire`  date , `resale_large_unit_price`  double , `resale_medium_unit_price`  double , `resale_small_unit_price`  double , `submit_rate`  double , `use_override_cpa`  smallint , `use_override_move_in_rate`  smallint , `use_override_submit_rate`  smallint \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_facility_yields/2026-04-16/1776388349'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_yields"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_yields/2026-04-16/1776388349
id: 1717315
processed: 1

raw_data:

{
    "avg_large_unit_price": "double",
    "avg_medium_unit_price": "double",
    "avg_small_unit_price": "double",
    "cpa": "double",
    "geo_specific_npv": "double",
    "last_modified": "timestamp[ns]",
    "listing_avail_id": "int32",
    "move_in_rate": "double",
    "override_cpa": "double",
    "override_cpa_expire": "date32[day]",
    "override_move_in_rate": "double",
    "override_move_in_rate_expire": "date32[day]",
    "override_submit_rate": "double",
    "override_submit_rate_expire": "date32[day]",
    "resale_large_unit_price": "double",
    "resale_medium_unit_price": "double",
    "resale_small_unit_price": "double",
    "submit_rate": "double",
    "use_override_cpa": "int16",
    "use_override_move_in_rate": "int16",
    "use_override_submit_rate": "int16"
}

schema_attributes:

{
    "avg_large_unit_price": "double",
    "avg_medium_unit_price": "double",
    "avg_small_unit_price": "double",
    "cpa": "double",
    "geo_specific_npv": "double",
    "last_modified": "timestamp",
    "listing_avail_id": "int",
    "move_in_rate": "double",
    "override_cpa": "double",
    "override_cpa_expire": "date",
    "override_move_in_rate": "double",
    "override_move_in_rate_expire": "date",
    "override_submit_rate": "double",
    "override_submit_rate_expire": "date",
    "resale_large_unit_price": "double",
    "resale_medium_unit_price": "double",
    "resale_small_unit_price": "double",
    "submit_rate": "double",
    "use_override_cpa": "smallint",
    "use_override_move_in_rate": "smallint",
    "use_override_submit_rate": "smallint"
}

schema_name_id: 1119
schema_scan_id: 162156038
updated: 2026-04-16 20:16:05

Version 1717178

created: 2026-04-16 14:18:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_yields`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_yields`\n(\n `avg_large_unit_price`  double , `avg_medium_unit_price`  double , `avg_small_unit_price`  double , `cpa`  double , `geo_specific_npv`  double , `last_modified`  timestamp , `listing_avail_id`  int , `move_in_rate`  double , `override_cpa`  double , `override_cpa_expire`  date , `override_move_in_rate`  double , `override_move_in_rate_expire`  date , `override_submit_rate`  double , `override_submit_rate_expire`  date , `resale_large_unit_price`  double , `resale_medium_unit_price`  double , `resale_small_unit_price`  double , `submit_rate`  double , `use_override_cpa`  smallint , `use_override_move_in_rate`  smallint , `use_override_submit_rate`  smallint \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_facility_yields/2026-04-16/1776367082'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_yields"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_yields/2026-04-16/1776367082
id: 1717178
processed: 1

raw_data:

{
    "avg_large_unit_price": "double",
    "avg_medium_unit_price": "double",
    "avg_small_unit_price": "double",
    "cpa": "double",
    "geo_specific_npv": "double",
    "last_modified": "timestamp[ns]",
    "listing_avail_id": "int32",
    "move_in_rate": "double",
    "override_cpa": "double",
    "override_cpa_expire": "date32[day]",
    "override_move_in_rate": "double",
    "override_move_in_rate_expire": "date32[day]",
    "override_submit_rate": "double",
    "override_submit_rate_expire": "date32[day]",
    "resale_large_unit_price": "double",
    "resale_medium_unit_price": "double",
    "resale_small_unit_price": "double",
    "submit_rate": "double",
    "use_override_cpa": "int16",
    "use_override_move_in_rate": "int16",
    "use_override_submit_rate": "int16"
}

schema_attributes:

{
    "avg_large_unit_price": "double",
    "avg_medium_unit_price": "double",
    "avg_small_unit_price": "double",
    "cpa": "double",
    "geo_specific_npv": "double",
    "last_modified": "timestamp",
    "listing_avail_id": "int",
    "move_in_rate": "double",
    "override_cpa": "double",
    "override_cpa_expire": "date",
    "override_move_in_rate": "double",
    "override_move_in_rate_expire": "date",
    "override_submit_rate": "double",
    "override_submit_rate_expire": "date",
    "resale_large_unit_price": "double",
    "resale_medium_unit_price": "double",
    "resale_small_unit_price": "double",
    "submit_rate": "double",
    "use_override_cpa": "smallint",
    "use_override_move_in_rate": "smallint",
    "use_override_submit_rate": "smallint"
}

schema_name_id: 1119
schema_scan_id: 162138120
updated: 2026-04-16 14:18:32

Version 1717009

created: 2026-04-16 09:16:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_yields`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_yields`\n(\n `avg_large_unit_price`  double , `avg_medium_unit_price`  double , `avg_small_unit_price`  double , `cpa`  double , `geo_specific_npv`  double , `last_modified`  timestamp , `listing_avail_id`  int , `move_in_rate`  double , `override_cpa`  double , `override_cpa_expire`  date , `override_move_in_rate`  double , `override_move_in_rate_expire`  date , `override_submit_rate`  double , `override_submit_rate_expire`  date , `resale_large_unit_price`  double , `resale_medium_unit_price`  double , `resale_small_unit_price`  double , `submit_rate`  double , `use_override_cpa`  smallint , `use_override_move_in_rate`  smallint , `use_override_submit_rate`  smallint \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_facility_yields/2026-04-16/1776349001'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_yields"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_yields/2026-04-16/1776349001
id: 1717009
processed: 1

raw_data:

{
    "avg_large_unit_price": "double",
    "avg_medium_unit_price": "double",
    "avg_small_unit_price": "double",
    "cpa": "double",
    "geo_specific_npv": "double",
    "last_modified": "timestamp[ns]",
    "listing_avail_id": "int32",
    "move_in_rate": "double",
    "override_cpa": "double",
    "override_cpa_expire": "date32[day]",
    "override_move_in_rate": "double",
    "override_move_in_rate_expire": "date32[day]",
    "override_submit_rate": "double",
    "override_submit_rate_expire": "date32[day]",
    "resale_large_unit_price": "double",
    "resale_medium_unit_price": "double",
    "resale_small_unit_price": "double",
    "submit_rate": "double",
    "use_override_cpa": "int16",
    "use_override_move_in_rate": "int16",
    "use_override_submit_rate": "int16"
}

schema_attributes:

{
    "avg_large_unit_price": "double",
    "avg_medium_unit_price": "double",
    "avg_small_unit_price": "double",
    "cpa": "double",
    "geo_specific_npv": "double",
    "last_modified": "timestamp",
    "listing_avail_id": "int",
    "move_in_rate": "double",
    "override_cpa": "double",
    "override_cpa_expire": "date",
    "override_move_in_rate": "double",
    "override_move_in_rate_expire": "date",
    "override_submit_rate": "double",
    "override_submit_rate_expire": "date",
    "resale_large_unit_price": "double",
    "resale_medium_unit_price": "double",
    "resale_small_unit_price": "double",
    "submit_rate": "double",
    "use_override_cpa": "smallint",
    "use_override_move_in_rate": "smallint",
    "use_override_submit_rate": "smallint"
}

schema_name_id: 1119
schema_scan_id: 162122571
updated: 2026-04-16 09:17:07

Version 1716195

created: 2026-04-16 00:07:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_yields`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_yields`\n(\n `avg_large_unit_price`  double , `avg_medium_unit_price`  double , `avg_small_unit_price`  double , `cpa`  double , `geo_specific_npv`  double , `last_modified`  timestamp , `listing_avail_id`  int , `move_in_rate`  double , `override_cpa`  double , `override_cpa_expire`  date , `override_move_in_rate`  double , `override_move_in_rate_expire`  date , `override_submit_rate`  double , `override_submit_rate_expire`  date , `resale_large_unit_price`  double , `resale_medium_unit_price`  double , `resale_small_unit_price`  double , `submit_rate`  double , `use_override_cpa`  smallint , `use_override_move_in_rate`  smallint , `use_override_submit_rate`  smallint \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_facility_yields/2026-04-16/1776316046'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_yields"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_yields/2026-04-16/1776316046
id: 1716195
processed: 1

raw_data:

{
    "avg_large_unit_price": "double",
    "avg_medium_unit_price": "double",
    "avg_small_unit_price": "double",
    "cpa": "double",
    "geo_specific_npv": "double",
    "last_modified": "timestamp[ns]",
    "listing_avail_id": "int32",
    "move_in_rate": "double",
    "override_cpa": "double",
    "override_cpa_expire": "date32[day]",
    "override_move_in_rate": "double",
    "override_move_in_rate_expire": "date32[day]",
    "override_submit_rate": "double",
    "override_submit_rate_expire": "date32[day]",
    "resale_large_unit_price": "double",
    "resale_medium_unit_price": "double",
    "resale_small_unit_price": "double",
    "submit_rate": "double",
    "use_override_cpa": "int16",
    "use_override_move_in_rate": "int16",
    "use_override_submit_rate": "int16"
}

schema_attributes:

{
    "avg_large_unit_price": "double",
    "avg_medium_unit_price": "double",
    "avg_small_unit_price": "double",
    "cpa": "double",
    "geo_specific_npv": "double",
    "last_modified": "timestamp",
    "listing_avail_id": "int",
    "move_in_rate": "double",
    "override_cpa": "double",
    "override_cpa_expire": "date",
    "override_move_in_rate": "double",
    "override_move_in_rate_expire": "date",
    "override_submit_rate": "double",
    "override_submit_rate_expire": "date",
    "resale_large_unit_price": "double",
    "resale_medium_unit_price": "double",
    "resale_small_unit_price": "double",
    "submit_rate": "double",
    "use_override_cpa": "smallint",
    "use_override_move_in_rate": "smallint",
    "use_override_submit_rate": "smallint"
}

schema_name_id: 1119
schema_scan_id: 162107749
updated: 2026-04-16 00:07:46

Version 1716096

created: 2026-04-15 20:20:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_yields`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_yields`\n(\n `avg_large_unit_price`  double , `avg_medium_unit_price`  double , `avg_small_unit_price`  double , `cpa`  double , `geo_specific_npv`  double , `last_modified`  timestamp , `listing_avail_id`  int , `move_in_rate`  double , `override_cpa`  double , `override_cpa_expire`  date , `override_move_in_rate`  double , `override_move_in_rate_expire`  date , `override_submit_rate`  double , `override_submit_rate_expire`  date , `resale_large_unit_price`  double , `resale_medium_unit_price`  double , `resale_small_unit_price`  double , `submit_rate`  double , `use_override_cpa`  smallint , `use_override_move_in_rate`  smallint , `use_override_submit_rate`  smallint \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_facility_yields/2026-04-15/1776302456'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_yields"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_yields/2026-04-15/1776302456
id: 1716096
processed: 1

raw_data:

{
    "avg_large_unit_price": "double",
    "avg_medium_unit_price": "double",
    "avg_small_unit_price": "double",
    "cpa": "double",
    "geo_specific_npv": "double",
    "last_modified": "timestamp[ns]",
    "listing_avail_id": "int32",
    "move_in_rate": "double",
    "override_cpa": "double",
    "override_cpa_expire": "date32[day]",
    "override_move_in_rate": "double",
    "override_move_in_rate_expire": "date32[day]",
    "override_submit_rate": "double",
    "override_submit_rate_expire": "date32[day]",
    "resale_large_unit_price": "double",
    "resale_medium_unit_price": "double",
    "resale_small_unit_price": "double",
    "submit_rate": "double",
    "use_override_cpa": "int16",
    "use_override_move_in_rate": "int16",
    "use_override_submit_rate": "int16"
}

schema_attributes:

{
    "avg_large_unit_price": "double",
    "avg_medium_unit_price": "double",
    "avg_small_unit_price": "double",
    "cpa": "double",
    "geo_specific_npv": "double",
    "last_modified": "timestamp",
    "listing_avail_id": "int",
    "move_in_rate": "double",
    "override_cpa": "double",
    "override_cpa_expire": "date",
    "override_move_in_rate": "double",
    "override_move_in_rate_expire": "date",
    "override_submit_rate": "double",
    "override_submit_rate_expire": "date",
    "resale_large_unit_price": "double",
    "resale_medium_unit_price": "double",
    "resale_small_unit_price": "double",
    "submit_rate": "double",
    "use_override_cpa": "smallint",
    "use_override_move_in_rate": "smallint",
    "use_override_submit_rate": "smallint"
}

schema_name_id: 1119
schema_scan_id: 162100307
updated: 2026-04-15 20:21:13

Version 1715957

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_yields`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_yields`\n(\n `avg_large_unit_price`  double , `avg_medium_unit_price`  double , `avg_small_unit_price`  double , `cpa`  double , `geo_specific_npv`  double , `last_modified`  timestamp , `listing_avail_id`  int , `move_in_rate`  double , `override_cpa`  double , `override_cpa_expire`  date , `override_move_in_rate`  double , `override_move_in_rate_expire`  date , `override_submit_rate`  double , `override_submit_rate_expire`  date , `resale_large_unit_price`  double , `resale_medium_unit_price`  double , `resale_small_unit_price`  double , `submit_rate`  double , `use_override_cpa`  smallint , `use_override_move_in_rate`  smallint , `use_override_submit_rate`  smallint \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_facility_yields/2026-04-15/1776280361'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_yields"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_yields/2026-04-15/1776280361
id: 1715957
processed: 1

raw_data:

{
    "avg_large_unit_price": "double",
    "avg_medium_unit_price": "double",
    "avg_small_unit_price": "double",
    "cpa": "double",
    "geo_specific_npv": "double",
    "last_modified": "timestamp[ns]",
    "listing_avail_id": "int32",
    "move_in_rate": "double",
    "override_cpa": "double",
    "override_cpa_expire": "date32[day]",
    "override_move_in_rate": "double",
    "override_move_in_rate_expire": "date32[day]",
    "override_submit_rate": "double",
    "override_submit_rate_expire": "date32[day]",
    "resale_large_unit_price": "double",
    "resale_medium_unit_price": "double",
    "resale_small_unit_price": "double",
    "submit_rate": "double",
    "use_override_cpa": "int16",
    "use_override_move_in_rate": "int16",
    "use_override_submit_rate": "int16"
}

schema_attributes:

{
    "avg_large_unit_price": "double",
    "avg_medium_unit_price": "double",
    "avg_small_unit_price": "double",
    "cpa": "double",
    "geo_specific_npv": "double",
    "last_modified": "timestamp",
    "listing_avail_id": "int",
    "move_in_rate": "double",
    "override_cpa": "double",
    "override_cpa_expire": "date",
    "override_move_in_rate": "double",
    "override_move_in_rate_expire": "date",
    "override_submit_rate": "double",
    "override_submit_rate_expire": "date",
    "resale_large_unit_price": "double",
    "resale_medium_unit_price": "double",
    "resale_small_unit_price": "double",
    "submit_rate": "double",
    "use_override_cpa": "smallint",
    "use_override_move_in_rate": "smallint",
    "use_override_submit_rate": "smallint"
}

schema_name_id: 1119
schema_scan_id: 162081685
updated: 2026-04-15 14:13:09

Version 1715758

created: 2026-04-15 08:40:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_yields`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_yields`\n(\n `avg_large_unit_price`  double , `avg_medium_unit_price`  double , `avg_small_unit_price`  double , `cpa`  double , `geo_specific_npv`  double , `last_modified`  timestamp , `listing_avail_id`  int , `move_in_rate`  double , `override_cpa`  double , `override_cpa_expire`  date , `override_move_in_rate`  double , `override_move_in_rate_expire`  date , `override_submit_rate`  double , `override_submit_rate_expire`  date , `resale_large_unit_price`  double , `resale_medium_unit_price`  double , `resale_small_unit_price`  double , `submit_rate`  double , `use_override_cpa`  smallint , `use_override_move_in_rate`  smallint , `use_override_submit_rate`  smallint \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_facility_yields/2026-04-15/1776260305'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_yields"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_yields/2026-04-15/1776260305
id: 1715758
processed: 1

raw_data:

{
    "avg_large_unit_price": "double",
    "avg_medium_unit_price": "double",
    "avg_small_unit_price": "double",
    "cpa": "double",
    "geo_specific_npv": "double",
    "last_modified": "timestamp[ns]",
    "listing_avail_id": "int32",
    "move_in_rate": "double",
    "override_cpa": "double",
    "override_cpa_expire": "date32[day]",
    "override_move_in_rate": "double",
    "override_move_in_rate_expire": "date32[day]",
    "override_submit_rate": "double",
    "override_submit_rate_expire": "date32[day]",
    "resale_large_unit_price": "double",
    "resale_medium_unit_price": "double",
    "resale_small_unit_price": "double",
    "submit_rate": "double",
    "use_override_cpa": "int16",
    "use_override_move_in_rate": "int16",
    "use_override_submit_rate": "int16"
}

schema_attributes:

{
    "avg_large_unit_price": "double",
    "avg_medium_unit_price": "double",
    "avg_small_unit_price": "double",
    "cpa": "double",
    "geo_specific_npv": "double",
    "last_modified": "timestamp",
    "listing_avail_id": "int",
    "move_in_rate": "double",
    "override_cpa": "double",
    "override_cpa_expire": "date",
    "override_move_in_rate": "double",
    "override_move_in_rate_expire": "date",
    "override_submit_rate": "double",
    "override_submit_rate_expire": "date",
    "resale_large_unit_price": "double",
    "resale_medium_unit_price": "double",
    "resale_small_unit_price": "double",
    "submit_rate": "double",
    "use_override_cpa": "smallint",
    "use_override_move_in_rate": "smallint",
    "use_override_submit_rate": "smallint"
}

schema_name_id: 1119
schema_scan_id: 162064422
updated: 2026-04-15 08:40:33

Version 1715009

created: 2026-04-15 00:12:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_yields`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_yields`\n(\n `avg_large_unit_price`  double , `avg_medium_unit_price`  double , `avg_small_unit_price`  double , `cpa`  double , `geo_specific_npv`  double , `last_modified`  timestamp , `listing_avail_id`  int , `move_in_rate`  double , `override_cpa`  double , `override_cpa_expire`  date , `override_move_in_rate`  double , `override_move_in_rate_expire`  date , `override_submit_rate`  double , `override_submit_rate_expire`  date , `resale_large_unit_price`  double , `resale_medium_unit_price`  double , `resale_small_unit_price`  double , `submit_rate`  double , `use_override_cpa`  smallint , `use_override_move_in_rate`  smallint , `use_override_submit_rate`  smallint \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_facility_yields/2026-04-15/1776229957'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_yields"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_yields/2026-04-15/1776229957
id: 1715009
processed: 1

raw_data:

{
    "avg_large_unit_price": "double",
    "avg_medium_unit_price": "double",
    "avg_small_unit_price": "double",
    "cpa": "double",
    "geo_specific_npv": "double",
    "last_modified": "timestamp[ns]",
    "listing_avail_id": "int32",
    "move_in_rate": "double",
    "override_cpa": "double",
    "override_cpa_expire": "date32[day]",
    "override_move_in_rate": "double",
    "override_move_in_rate_expire": "date32[day]",
    "override_submit_rate": "double",
    "override_submit_rate_expire": "date32[day]",
    "resale_large_unit_price": "double",
    "resale_medium_unit_price": "double",
    "resale_small_unit_price": "double",
    "submit_rate": "double",
    "use_override_cpa": "int16",
    "use_override_move_in_rate": "int16",
    "use_override_submit_rate": "int16"
}

schema_attributes:

{
    "avg_large_unit_price": "double",
    "avg_medium_unit_price": "double",
    "avg_small_unit_price": "double",
    "cpa": "double",
    "geo_specific_npv": "double",
    "last_modified": "timestamp",
    "listing_avail_id": "int",
    "move_in_rate": "double",
    "override_cpa": "double",
    "override_cpa_expire": "date",
    "override_move_in_rate": "double",
    "override_move_in_rate_expire": "date",
    "override_submit_rate": "double",
    "override_submit_rate_expire": "date",
    "resale_large_unit_price": "double",
    "resale_medium_unit_price": "double",
    "resale_small_unit_price": "double",
    "submit_rate": "double",
    "use_override_cpa": "smallint",
    "use_override_move_in_rate": "smallint",
    "use_override_submit_rate": "smallint"
}

schema_name_id: 1119
schema_scan_id: 162051958
updated: 2026-04-15 00:12:54

Version 1714912

created: 2026-04-14 20:25:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_yields`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_yields`\n(\n `avg_large_unit_price`  double , `avg_medium_unit_price`  double , `avg_small_unit_price`  double , `cpa`  double , `geo_specific_npv`  double , `last_modified`  timestamp , `listing_avail_id`  int , `move_in_rate`  double , `override_cpa`  double , `override_cpa_expire`  date , `override_move_in_rate`  double , `override_move_in_rate_expire`  date , `override_submit_rate`  double , `override_submit_rate_expire`  date , `resale_large_unit_price`  double , `resale_medium_unit_price`  double , `resale_small_unit_price`  double , `submit_rate`  double , `use_override_cpa`  smallint , `use_override_move_in_rate`  smallint , `use_override_submit_rate`  smallint \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_facility_yields/2026-04-14/1776216305'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_yields"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_yields/2026-04-14/1776216305
id: 1714912
processed: 1

raw_data:

{
    "avg_large_unit_price": "double",
    "avg_medium_unit_price": "double",
    "avg_small_unit_price": "double",
    "cpa": "double",
    "geo_specific_npv": "double",
    "last_modified": "timestamp[ns]",
    "listing_avail_id": "int32",
    "move_in_rate": "double",
    "override_cpa": "double",
    "override_cpa_expire": "date32[day]",
    "override_move_in_rate": "double",
    "override_move_in_rate_expire": "date32[day]",
    "override_submit_rate": "double",
    "override_submit_rate_expire": "date32[day]",
    "resale_large_unit_price": "double",
    "resale_medium_unit_price": "double",
    "resale_small_unit_price": "double",
    "submit_rate": "double",
    "use_override_cpa": "int16",
    "use_override_move_in_rate": "int16",
    "use_override_submit_rate": "int16"
}

schema_attributes:

{
    "avg_large_unit_price": "double",
    "avg_medium_unit_price": "double",
    "avg_small_unit_price": "double",
    "cpa": "double",
    "geo_specific_npv": "double",
    "last_modified": "timestamp",
    "listing_avail_id": "int",
    "move_in_rate": "double",
    "override_cpa": "double",
    "override_cpa_expire": "date",
    "override_move_in_rate": "double",
    "override_move_in_rate_expire": "date",
    "override_submit_rate": "double",
    "override_submit_rate_expire": "date",
    "resale_large_unit_price": "double",
    "resale_medium_unit_price": "double",
    "resale_small_unit_price": "double",
    "submit_rate": "double",
    "use_override_cpa": "smallint",
    "use_override_move_in_rate": "smallint",
    "use_override_submit_rate": "smallint"
}

schema_name_id: 1119
schema_scan_id: 162044332
updated: 2026-04-14 20:25:26

Version 1714708

created: 2026-04-14 14:11:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_yields`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_yields`\n(\n `avg_large_unit_price`  double , `avg_medium_unit_price`  double , `avg_small_unit_price`  double , `cpa`  double , `geo_specific_npv`  double , `last_modified`  timestamp , `listing_avail_id`  int , `move_in_rate`  double , `override_cpa`  double , `override_cpa_expire`  date , `override_move_in_rate`  double , `override_move_in_rate_expire`  date , `override_submit_rate`  double , `override_submit_rate_expire`  date , `resale_large_unit_price`  double , `resale_medium_unit_price`  double , `resale_small_unit_price`  double , `submit_rate`  double , `use_override_cpa`  smallint , `use_override_move_in_rate`  smallint , `use_override_submit_rate`  smallint \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_facility_yields/2026-04-14/1776193859'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_yields"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_yields/2026-04-14/1776193859
id: 1714708
processed: 1

raw_data:

{
    "avg_large_unit_price": "double",
    "avg_medium_unit_price": "double",
    "avg_small_unit_price": "double",
    "cpa": "double",
    "geo_specific_npv": "double",
    "last_modified": "timestamp[ns]",
    "listing_avail_id": "int32",
    "move_in_rate": "double",
    "override_cpa": "double",
    "override_cpa_expire": "date32[day]",
    "override_move_in_rate": "double",
    "override_move_in_rate_expire": "date32[day]",
    "override_submit_rate": "double",
    "override_submit_rate_expire": "date32[day]",
    "resale_large_unit_price": "double",
    "resale_medium_unit_price": "double",
    "resale_small_unit_price": "double",
    "submit_rate": "double",
    "use_override_cpa": "int16",
    "use_override_move_in_rate": "int16",
    "use_override_submit_rate": "int16"
}

schema_attributes:

{
    "avg_large_unit_price": "double",
    "avg_medium_unit_price": "double",
    "avg_small_unit_price": "double",
    "cpa": "double",
    "geo_specific_npv": "double",
    "last_modified": "timestamp",
    "listing_avail_id": "int",
    "move_in_rate": "double",
    "override_cpa": "double",
    "override_cpa_expire": "date",
    "override_move_in_rate": "double",
    "override_move_in_rate_expire": "date",
    "override_submit_rate": "double",
    "override_submit_rate_expire": "date",
    "resale_large_unit_price": "double",
    "resale_medium_unit_price": "double",
    "resale_small_unit_price": "double",
    "submit_rate": "double",
    "use_override_cpa": "smallint",
    "use_override_move_in_rate": "smallint",
    "use_override_submit_rate": "smallint"
}

schema_name_id: 1119
schema_scan_id: 162026082
updated: 2026-04-14 14:11:29

Version 1714594

created: 2026-04-14 09:11:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_yields`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_yields`\n(\n `avg_large_unit_price`  double , `avg_medium_unit_price`  double , `avg_small_unit_price`  double , `cpa`  double , `geo_specific_npv`  double , `last_modified`  timestamp , `listing_avail_id`  int , `move_in_rate`  double , `override_cpa`  double , `override_cpa_expire`  date , `override_move_in_rate`  double , `override_move_in_rate_expire`  date , `override_submit_rate`  double , `override_submit_rate_expire`  date , `resale_large_unit_price`  double , `resale_medium_unit_price`  double , `resale_small_unit_price`  double , `submit_rate`  double , `use_override_cpa`  smallint , `use_override_move_in_rate`  smallint , `use_override_submit_rate`  smallint \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_facility_yields/2026-04-14/1776175686'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_yields"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_yields/2026-04-14/1776175686
id: 1714594
processed: 1

raw_data:

{
    "avg_large_unit_price": "double",
    "avg_medium_unit_price": "double",
    "avg_small_unit_price": "double",
    "cpa": "double",
    "geo_specific_npv": "double",
    "last_modified": "timestamp[ns]",
    "listing_avail_id": "int32",
    "move_in_rate": "double",
    "override_cpa": "double",
    "override_cpa_expire": "date32[day]",
    "override_move_in_rate": "double",
    "override_move_in_rate_expire": "date32[day]",
    "override_submit_rate": "double",
    "override_submit_rate_expire": "date32[day]",
    "resale_large_unit_price": "double",
    "resale_medium_unit_price": "double",
    "resale_small_unit_price": "double",
    "submit_rate": "double",
    "use_override_cpa": "int16",
    "use_override_move_in_rate": "int16",
    "use_override_submit_rate": "int16"
}

schema_attributes:

{
    "avg_large_unit_price": "double",
    "avg_medium_unit_price": "double",
    "avg_small_unit_price": "double",
    "cpa": "double",
    "geo_specific_npv": "double",
    "last_modified": "timestamp",
    "listing_avail_id": "int",
    "move_in_rate": "double",
    "override_cpa": "double",
    "override_cpa_expire": "date",
    "override_move_in_rate": "double",
    "override_move_in_rate_expire": "date",
    "override_submit_rate": "double",
    "override_submit_rate_expire": "date",
    "resale_large_unit_price": "double",
    "resale_medium_unit_price": "double",
    "resale_small_unit_price": "double",
    "submit_rate": "double",
    "use_override_cpa": "smallint",
    "use_override_move_in_rate": "smallint",
    "use_override_submit_rate": "smallint"
}

schema_name_id: 1119
schema_scan_id: 162010965
updated: 2026-04-14 09:11:14

Version 1713797

created: 2026-04-14 00:06:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_yields`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_yields`\n(\n `avg_large_unit_price`  double , `avg_medium_unit_price`  double , `avg_small_unit_price`  double , `cpa`  double , `geo_specific_npv`  double , `last_modified`  timestamp , `listing_avail_id`  int , `move_in_rate`  double , `override_cpa`  double , `override_cpa_expire`  date , `override_move_in_rate`  double , `override_move_in_rate_expire`  date , `override_submit_rate`  double , `override_submit_rate_expire`  date , `resale_large_unit_price`  double , `resale_medium_unit_price`  double , `resale_small_unit_price`  double , `submit_rate`  double , `use_override_cpa`  smallint , `use_override_move_in_rate`  smallint , `use_override_submit_rate`  smallint \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_facility_yields/2026-04-14/1776143213'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_yields"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_yields/2026-04-14/1776143213
id: 1713797
processed: 1

raw_data:

{
    "avg_large_unit_price": "double",
    "avg_medium_unit_price": "double",
    "avg_small_unit_price": "double",
    "cpa": "double",
    "geo_specific_npv": "double",
    "last_modified": "timestamp[ns]",
    "listing_avail_id": "int32",
    "move_in_rate": "double",
    "override_cpa": "double",
    "override_cpa_expire": "date32[day]",
    "override_move_in_rate": "double",
    "override_move_in_rate_expire": "date32[day]",
    "override_submit_rate": "double",
    "override_submit_rate_expire": "date32[day]",
    "resale_large_unit_price": "double",
    "resale_medium_unit_price": "double",
    "resale_small_unit_price": "double",
    "submit_rate": "double",
    "use_override_cpa": "int16",
    "use_override_move_in_rate": "int16",
    "use_override_submit_rate": "int16"
}

schema_attributes:

{
    "avg_large_unit_price": "double",
    "avg_medium_unit_price": "double",
    "avg_small_unit_price": "double",
    "cpa": "double",
    "geo_specific_npv": "double",
    "last_modified": "timestamp",
    "listing_avail_id": "int",
    "move_in_rate": "double",
    "override_cpa": "double",
    "override_cpa_expire": "date",
    "override_move_in_rate": "double",
    "override_move_in_rate_expire": "date",
    "override_submit_rate": "double",
    "override_submit_rate_expire": "date",
    "resale_large_unit_price": "double",
    "resale_medium_unit_price": "double",
    "resale_small_unit_price": "double",
    "submit_rate": "double",
    "use_override_cpa": "smallint",
    "use_override_move_in_rate": "smallint",
    "use_override_submit_rate": "smallint"
}

schema_name_id: 1119
schema_scan_id: 161996310
updated: 2026-04-14 00:07:12

Schema Scans: 15

Last at 2026-04-17 14:15:19

Scan 162194006

duration: 0:00:14.641243

exit_message:

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

id: 162194006

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_facility_yields/2026-04-17/1776453316",
        "key": "raw/sparefoot_facility_yields/2026-04-17/1776453316/facility_yields_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_yields",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10706353729521283762,
        "service_name": "sparefoot",
        "span_id": 17848063477271104526,
        "trace_id": 10706353729521283762
    }
}

running: False
schema_name_id: 1119
start_time: 2026-04-17 14:15:19
success: True
trace_id: 10706353729521283762

Scan 162178313

duration: 0:00:14.626671

exit_message:

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

id: 162178313

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_facility_yields/2026-04-17/1776435821",
        "key": "raw/sparefoot_facility_yields/2026-04-17/1776435821/facility_yields_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_yields",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10819573902561276512,
        "service_name": "sparefoot",
        "span_id": 15172465248161220862,
        "trace_id": 10819573902561276512
    }
}

running: False
schema_name_id: 1119
start_time: 2026-04-17 09:23:53
success: True
trace_id: 10819573902561276512

Scan 162163570

duration: 0:00:14.890423

exit_message:

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

id: 162163570

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_facility_yields/2026-04-17/1776402384",
        "key": "raw/sparefoot_facility_yields/2026-04-17/1776402384/facility_yields_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_yields",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13227633269985195855,
        "service_name": "sparefoot",
        "span_id": 17054518666219940850,
        "trace_id": 13227633269985195855
    }
}

running: False
schema_name_id: 1119
start_time: 2026-04-17 00:07:04
success: True
trace_id: 13227633269985195855

Scan 162156038

duration: 0:00:12.180198

exit_message:

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

id: 162156038

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_facility_yields/2026-04-16/1776388349",
        "key": "raw/sparefoot_facility_yields/2026-04-16/1776388349/facility_yields_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_yields",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4149095748926450215,
        "service_name": "sparefoot",
        "span_id": 2683244026551330336,
        "trace_id": 4149095748926450215
    }
}

running: False
schema_name_id: 1119
start_time: 2026-04-16 20:15:53
success: True
trace_id: 4149095748926450215

Scan 162138120

duration: 0:00:12.036224

exit_message:

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

id: 162138120

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_facility_yields/2026-04-16/1776367082",
        "key": "raw/sparefoot_facility_yields/2026-04-16/1776367082/facility_yields_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_yields",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8108623831594795399,
        "service_name": "sparefoot",
        "span_id": 12777319850852156450,
        "trace_id": 8108623831594795399
    }
}

running: False
schema_name_id: 1119
start_time: 2026-04-16 14:18:20
success: True
trace_id: 8108623831594795399

Scan 162122571

duration: 0:00:14.668524

exit_message:

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

id: 162122571

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_facility_yields/2026-04-16/1776349001",
        "key": "raw/sparefoot_facility_yields/2026-04-16/1776349001/facility_yields_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_yields",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17190264776294565294,
        "service_name": "sparefoot",
        "span_id": 2843314497192407864,
        "trace_id": 17190264776294565294
    }
}

running: False
schema_name_id: 1119
start_time: 2026-04-16 09:16:53
success: True
trace_id: 17190264776294565294

Scan 162107749

duration: 0:00:14.639636

exit_message:

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

id: 162107749

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_facility_yields/2026-04-16/1776316046",
        "key": "raw/sparefoot_facility_yields/2026-04-16/1776316046/facility_yields_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_yields",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10310427166099919248,
        "service_name": "sparefoot",
        "span_id": 4031178939812834009,
        "trace_id": 10310427166099919248
    }
}

running: False
schema_name_id: 1119
start_time: 2026-04-16 00:07:31
success: True
trace_id: 10310427166099919248

Scan 162100307

duration: 0:00:14.632641

exit_message:

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

id: 162100307

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_facility_yields/2026-04-15/1776302456",
        "key": "raw/sparefoot_facility_yields/2026-04-15/1776302456/facility_yields_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_yields",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15813909239567829110,
        "service_name": "sparefoot",
        "span_id": 16750711618345597880,
        "trace_id": 15813909239567829110
    }
}

running: False
schema_name_id: 1119
start_time: 2026-04-15 20:20:58
success: True
trace_id: 15813909239567829110

Scan 162081685

duration: 0:00:14.662307

exit_message:

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

id: 162081685

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_facility_yields/2026-04-15/1776280361",
        "key": "raw/sparefoot_facility_yields/2026-04-15/1776280361/facility_yields_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_yields",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9326684413563028643,
        "service_name": "sparefoot",
        "span_id": 7697824963720957385,
        "trace_id": 9326684413563028643
    }
}

running: False
schema_name_id: 1119
start_time: 2026-04-15 14:12:55
success: True
trace_id: 9326684413563028643

Scan 162064422

duration: 0:00:12.132405

exit_message:

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

id: 162064422

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_facility_yields/2026-04-15/1776260305",
        "key": "raw/sparefoot_facility_yields/2026-04-15/1776260305/facility_yields_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_yields",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5293070502428026354,
        "service_name": "sparefoot",
        "span_id": 1108345954572123389,
        "trace_id": 5293070502428026354
    }
}

running: False
schema_name_id: 1119
start_time: 2026-04-15 08:40:21
success: True
trace_id: 5293070502428026354

Scan 162051958

duration: 0:00:12.258215

exit_message:

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

id: 162051958

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_facility_yields/2026-04-15/1776229957",
        "key": "raw/sparefoot_facility_yields/2026-04-15/1776229957/facility_yields_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_yields",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9319672722425477330,
        "service_name": "sparefoot",
        "span_id": 4010579180918271436,
        "trace_id": 9319672722425477330
    }
}

running: False
schema_name_id: 1119
start_time: 2026-04-15 00:12:42
success: True
trace_id: 9319672722425477330

Scan 162044332

duration: 0:00:12.370330

exit_message:

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

id: 162044332

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_facility_yields/2026-04-14/1776216305",
        "key": "raw/sparefoot_facility_yields/2026-04-14/1776216305/facility_yields_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_yields",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4850338882046405555,
        "service_name": "sparefoot",
        "span_id": 5976204473354263322,
        "trace_id": 4850338882046405555
    }
}

running: False
schema_name_id: 1119
start_time: 2026-04-14 20:25:14
success: True
trace_id: 4850338882046405555

Scan 162026082

duration: 0:00:14.530904

exit_message:

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

id: 162026082

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_facility_yields/2026-04-14/1776193859",
        "key": "raw/sparefoot_facility_yields/2026-04-14/1776193859/facility_yields_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_yields",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11453214150077315516,
        "service_name": "sparefoot",
        "span_id": 14100102574850979667,
        "trace_id": 11453214150077315516
    }
}

running: False
schema_name_id: 1119
start_time: 2026-04-14 14:11:14
success: True
trace_id: 11453214150077315516

Scan 162010965

duration: 0:00:12.337775

exit_message:

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

id: 162010965

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_facility_yields/2026-04-14/1776175686",
        "key": "raw/sparefoot_facility_yields/2026-04-14/1776175686/facility_yields_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_yields",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11699611905722563609,
        "service_name": "sparefoot",
        "span_id": 7093982492423043085,
        "trace_id": 11699611905722563609
    }
}

running: False
schema_name_id: 1119
start_time: 2026-04-14 09:11:01
success: True
trace_id: 11699611905722563609

Scan 161996310

duration: 0:00:14.584007

exit_message:

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

id: 161996310

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_facility_yields/2026-04-14/1776143213",
        "key": "raw/sparefoot_facility_yields/2026-04-14/1776143213/facility_yields_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_yields",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12272286078226314473,
        "service_name": "sparefoot",
        "span_id": 18265426277080957864,
        "trace_id": 12272286078226314473
    }
}

running: False
schema_name_id: 1119
start_time: 2026-04-14 00:06:57
success: True
trace_id: 12272286078226314473

Partitions:

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

Schema:

attributes:

{
    "avg_large_unit_price": "double",
    "avg_medium_unit_price": "double",
    "avg_small_unit_price": "double",
    "cpa": "double",
    "geo_specific_npv": "double",
    "last_modified": "timestamp",
    "listing_avail_id": "int",
    "move_in_rate": "double",
    "override_cpa": "double",
    "override_cpa_expire": "date",
    "override_move_in_rate": "double",
    "override_move_in_rate_expire": "date",
    "override_submit_rate": "double",
    "override_submit_rate_expire": "date",
    "resale_large_unit_price": "double",
    "resale_medium_unit_price": "double",
    "resale_small_unit_price": "double",
    "submit_rate": "double",
    "use_override_cpa": "smallint",
    "use_override_move_in_rate": "smallint",
    "use_override_submit_rate": "smallint"
}

created: 2026-04-17 14:15:20

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_facility_yields`\n(\n `avg_large_unit_price`  double , `avg_medium_unit_price`  double , `avg_small_unit_price`  double , `cpa`  double , `geo_specific_npv`  double , `last_modified`  timestamp , `listing_avail_id`  int , `move_in_rate`  double , `override_cpa`  double , `override_cpa_expire`  date , `override_move_in_rate`  double , `override_move_in_rate_expire`  date , `override_submit_rate`  double , `override_submit_rate_expire`  date , `resale_large_unit_price`  double , `resale_medium_unit_price`  double , `resale_small_unit_price`  double , `submit_rate`  double , `use_override_cpa`  smallint , `use_override_move_in_rate`  smallint , `use_override_submit_rate`  smallint \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_facility_yields/2026-04-17/1776453316'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_yields`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_yields"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2022-08-18 17:22:17",
        "disabled": false,
        "format": "raw",
        "id": 1119,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_rds",
            "table": "sparefoot_sparefoot_facility_yields"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "avg_large_unit_price": "double",
            "avg_medium_unit_price": "double",
            "avg_small_unit_price": "double",
            "cpa": "double",
            "geo_specific_npv": "double",
            "last_modified": "timestamp",
            "listing_avail_id": "int",
            "move_in_rate": "double",
            "override_cpa": "double",
            "override_cpa_expire": "date",
            "override_move_in_rate": "double",
            "override_move_in_rate_expire": "date",
            "override_submit_rate": "double",
            "override_submit_rate_expire": "date",
            "resale_large_unit_price": "double",
            "resale_medium_unit_price": "double",
            "resale_small_unit_price": "double",
            "submit_rate": "double",
            "use_override_cpa": "smallint",
            "use_override_move_in_rate": "smallint",
            "use_override_submit_rate": "smallint"
        },
        "created": "2026-04-17 14:15:20",
        "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_facility_yields`\n(\n `avg_large_unit_price`  double , `avg_medium_unit_price`  double , `avg_small_unit_price`  double , `cpa`  double , `geo_specific_npv`  double , `last_modified`  timestamp , `listing_avail_id`  int , `move_in_rate`  double , `override_cpa`  double , `override_cpa_expire`  date , `override_move_in_rate`  double , `override_move_in_rate_expire`  date , `override_submit_rate`  double , `override_submit_rate_expire`  date , `resale_large_unit_price`  double , `resale_medium_unit_price`  double , `resale_small_unit_price`  double , `submit_rate`  double , `use_override_cpa`  smallint , `use_override_move_in_rate`  smallint , `use_override_submit_rate`  smallint \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_facility_yields/2026-04-17/1776453316'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_yields`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_yields"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}