Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_site_content

created: 2022-08-18 17:19:51
disabled: False
format: raw
id: 1103
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 1718401

created: 2026-04-17 14:16:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_site_content`\n(\n `avg_10x10_price`  double , `avg_cleanliness_rating`  double , `avg_overall_rating`  double , `avg_paperwork_rating`  double , `avg_price`  double , `avg_price_per_sqft`  double , `avg_security_rating`  double , `avg_service_rating`  double , `avg_value_rating`  double , `body`  string , `content_id`  int , `content_template_id`  int , `created_timestamp`  timestamp , `facilities`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `image_path`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `movingtruck_url`  string , `penske_url`  string , `popular_amenity_uri`  string , `popular_neighborhood_uri`  string , `popular_size_uri`  string , `popular_university_uri`  string , `popular_vehicle_uri`  string , `popular_zip_uri`  string , `publish`  smallint , `reviews_count`  int , `site_id`  int , `subtitle`  string , `title`  string , `updated_timestamp`  timestamp , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-17/1776453392'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_site_content"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-17/1776453392
id: 1718401
processed: 1

raw_data:

{
    "avg_10x10_price": "double",
    "avg_cleanliness_rating": "double",
    "avg_overall_rating": "double",
    "avg_paperwork_rating": "double",
    "avg_price": "double",
    "avg_price_per_sqft": "double",
    "avg_security_rating": "double",
    "avg_service_rating": "double",
    "avg_value_rating": "double",
    "body": "string",
    "content_id": "int32",
    "content_template_id": "int32",
    "created_timestamp": "timestamp[ns]",
    "facilities": "int32",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "image_path": "string",
    "location_id": "int32",
    "meta_description": "string",
    "meta_keywords": "string",
    "movingtruck_url": "string",
    "penske_url": "string",
    "popular_amenity_uri": "string",
    "popular_neighborhood_uri": "string",
    "popular_size_uri": "string",
    "popular_university_uri": "string",
    "popular_vehicle_uri": "string",
    "popular_zip_uri": "string",
    "publish": "int16",
    "reviews_count": "int32",
    "site_id": "int32",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp[ns]",
    "uri": "string"
}

schema_attributes:

{
    "avg_10x10_price": "double",
    "avg_cleanliness_rating": "double",
    "avg_overall_rating": "double",
    "avg_paperwork_rating": "double",
    "avg_price": "double",
    "avg_price_per_sqft": "double",
    "avg_security_rating": "double",
    "avg_service_rating": "double",
    "avg_value_rating": "double",
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "created_timestamp": "timestamp",
    "facilities": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "image_path": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "movingtruck_url": "string",
    "penske_url": "string",
    "popular_amenity_uri": "string",
    "popular_neighborhood_uri": "string",
    "popular_size_uri": "string",
    "popular_university_uri": "string",
    "popular_vehicle_uri": "string",
    "popular_zip_uri": "string",
    "publish": "smallint",
    "reviews_count": "int",
    "site_id": "int",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp",
    "uri": "string"
}

schema_name_id: 1103
schema_scan_id: 162194038
updated: 2026-04-17 14:16:51

Version 1718227

created: 2026-04-17 09:26:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_site_content`\n(\n `avg_10x10_price`  double , `avg_cleanliness_rating`  double , `avg_overall_rating`  double , `avg_paperwork_rating`  double , `avg_price`  double , `avg_price_per_sqft`  double , `avg_security_rating`  double , `avg_service_rating`  double , `avg_value_rating`  double , `body`  string , `content_id`  int , `content_template_id`  int , `created_timestamp`  timestamp , `facilities`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `image_path`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `movingtruck_url`  string , `penske_url`  string , `popular_amenity_uri`  string , `popular_neighborhood_uri`  string , `popular_size_uri`  string , `popular_university_uri`  string , `popular_vehicle_uri`  string , `popular_zip_uri`  string , `publish`  smallint , `reviews_count`  int , `site_id`  int , `subtitle`  string , `title`  string , `updated_timestamp`  timestamp , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-17/1776435956'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_site_content"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-17/1776435956
id: 1718227
processed: 1

raw_data:

{
    "avg_10x10_price": "double",
    "avg_cleanliness_rating": "double",
    "avg_overall_rating": "double",
    "avg_paperwork_rating": "double",
    "avg_price": "double",
    "avg_price_per_sqft": "double",
    "avg_security_rating": "double",
    "avg_service_rating": "double",
    "avg_value_rating": "double",
    "body": "string",
    "content_id": "int32",
    "content_template_id": "int32",
    "created_timestamp": "timestamp[ns]",
    "facilities": "int32",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "image_path": "string",
    "location_id": "int32",
    "meta_description": "string",
    "meta_keywords": "string",
    "movingtruck_url": "string",
    "penske_url": "string",
    "popular_amenity_uri": "string",
    "popular_neighborhood_uri": "string",
    "popular_size_uri": "string",
    "popular_university_uri": "string",
    "popular_vehicle_uri": "string",
    "popular_zip_uri": "string",
    "publish": "int16",
    "reviews_count": "int32",
    "site_id": "int32",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp[ns]",
    "uri": "string"
}

schema_attributes:

{
    "avg_10x10_price": "double",
    "avg_cleanliness_rating": "double",
    "avg_overall_rating": "double",
    "avg_paperwork_rating": "double",
    "avg_price": "double",
    "avg_price_per_sqft": "double",
    "avg_security_rating": "double",
    "avg_service_rating": "double",
    "avg_value_rating": "double",
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "created_timestamp": "timestamp",
    "facilities": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "image_path": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "movingtruck_url": "string",
    "penske_url": "string",
    "popular_amenity_uri": "string",
    "popular_neighborhood_uri": "string",
    "popular_size_uri": "string",
    "popular_university_uri": "string",
    "popular_vehicle_uri": "string",
    "popular_zip_uri": "string",
    "publish": "smallint",
    "reviews_count": "int",
    "site_id": "int",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp",
    "uri": "string"
}

schema_name_id: 1103
schema_scan_id: 162178333
updated: 2026-04-17 09:26:23

Version 1717445

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_site_content`\n(\n `avg_10x10_price`  double , `avg_cleanliness_rating`  double , `avg_overall_rating`  double , `avg_paperwork_rating`  double , `avg_price`  double , `avg_price_per_sqft`  double , `avg_security_rating`  double , `avg_service_rating`  double , `avg_value_rating`  double , `body`  string , `content_id`  int , `content_template_id`  int , `created_timestamp`  timestamp , `facilities`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `image_path`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `movingtruck_url`  string , `penske_url`  string , `popular_amenity_uri`  string , `popular_neighborhood_uri`  string , `popular_size_uri`  string , `popular_university_uri`  string , `popular_vehicle_uri`  string , `popular_zip_uri`  string , `publish`  smallint , `reviews_count`  int , `site_id`  int , `subtitle`  string , `title`  string , `updated_timestamp`  timestamp , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-17/1776402435'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_site_content"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-17/1776402435
id: 1717445
processed: 1

raw_data:

{
    "avg_10x10_price": "double",
    "avg_cleanliness_rating": "double",
    "avg_overall_rating": "double",
    "avg_paperwork_rating": "double",
    "avg_price": "double",
    "avg_price_per_sqft": "double",
    "avg_security_rating": "double",
    "avg_service_rating": "double",
    "avg_value_rating": "double",
    "body": "string",
    "content_id": "int32",
    "content_template_id": "int32",
    "created_timestamp": "timestamp[ns]",
    "facilities": "int32",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "image_path": "string",
    "location_id": "int32",
    "meta_description": "string",
    "meta_keywords": "string",
    "movingtruck_url": "string",
    "penske_url": "string",
    "popular_amenity_uri": "string",
    "popular_neighborhood_uri": "string",
    "popular_size_uri": "string",
    "popular_university_uri": "string",
    "popular_vehicle_uri": "string",
    "popular_zip_uri": "string",
    "publish": "int16",
    "reviews_count": "int32",
    "site_id": "int32",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp[ns]",
    "uri": "string"
}

schema_attributes:

{
    "avg_10x10_price": "double",
    "avg_cleanliness_rating": "double",
    "avg_overall_rating": "double",
    "avg_paperwork_rating": "double",
    "avg_price": "double",
    "avg_price_per_sqft": "double",
    "avg_security_rating": "double",
    "avg_service_rating": "double",
    "avg_value_rating": "double",
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "created_timestamp": "timestamp",
    "facilities": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "image_path": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "movingtruck_url": "string",
    "penske_url": "string",
    "popular_amenity_uri": "string",
    "popular_neighborhood_uri": "string",
    "popular_size_uri": "string",
    "popular_university_uri": "string",
    "popular_vehicle_uri": "string",
    "popular_zip_uri": "string",
    "publish": "smallint",
    "reviews_count": "int",
    "site_id": "int",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp",
    "uri": "string"
}

schema_name_id: 1103
schema_scan_id: 162163579
updated: 2026-04-17 00:07:47

Version 1717330

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_site_content`\n(\n `avg_10x10_price`  double , `avg_cleanliness_rating`  double , `avg_overall_rating`  double , `avg_paperwork_rating`  double , `avg_price`  double , `avg_price_per_sqft`  double , `avg_security_rating`  double , `avg_service_rating`  double , `avg_value_rating`  double , `body`  string , `content_id`  int , `content_template_id`  int , `created_timestamp`  timestamp , `facilities`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `image_path`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `movingtruck_url`  string , `penske_url`  string , `popular_amenity_uri`  string , `popular_neighborhood_uri`  string , `popular_size_uri`  string , `popular_university_uri`  string , `popular_vehicle_uri`  string , `popular_zip_uri`  string , `publish`  smallint , `reviews_count`  int , `site_id`  int , `subtitle`  string , `title`  string , `updated_timestamp`  timestamp , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-16/1776388527'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_site_content"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-16/1776388527
id: 1717330
processed: 1

raw_data:

{
    "avg_10x10_price": "double",
    "avg_cleanliness_rating": "double",
    "avg_overall_rating": "double",
    "avg_paperwork_rating": "double",
    "avg_price": "double",
    "avg_price_per_sqft": "double",
    "avg_security_rating": "double",
    "avg_service_rating": "double",
    "avg_value_rating": "double",
    "body": "string",
    "content_id": "int32",
    "content_template_id": "int32",
    "created_timestamp": "timestamp[ns]",
    "facilities": "int32",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "image_path": "string",
    "location_id": "int32",
    "meta_description": "string",
    "meta_keywords": "string",
    "movingtruck_url": "string",
    "penske_url": "string",
    "popular_amenity_uri": "string",
    "popular_neighborhood_uri": "string",
    "popular_size_uri": "string",
    "popular_university_uri": "string",
    "popular_vehicle_uri": "string",
    "popular_zip_uri": "string",
    "publish": "int16",
    "reviews_count": "int32",
    "site_id": "int32",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp[ns]",
    "uri": "string"
}

schema_attributes:

{
    "avg_10x10_price": "double",
    "avg_cleanliness_rating": "double",
    "avg_overall_rating": "double",
    "avg_paperwork_rating": "double",
    "avg_price": "double",
    "avg_price_per_sqft": "double",
    "avg_security_rating": "double",
    "avg_service_rating": "double",
    "avg_value_rating": "double",
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "created_timestamp": "timestamp",
    "facilities": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "image_path": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "movingtruck_url": "string",
    "penske_url": "string",
    "popular_amenity_uri": "string",
    "popular_neighborhood_uri": "string",
    "popular_size_uri": "string",
    "popular_university_uri": "string",
    "popular_vehicle_uri": "string",
    "popular_zip_uri": "string",
    "publish": "smallint",
    "reviews_count": "int",
    "site_id": "int",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp",
    "uri": "string"
}

schema_name_id: 1103
schema_scan_id: 162156075
updated: 2026-04-16 20:18:26

Version 1717153

created: 2026-04-16 14:15:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_site_content`\n(\n `avg_10x10_price`  double , `avg_cleanliness_rating`  double , `avg_overall_rating`  double , `avg_paperwork_rating`  double , `avg_price`  double , `avg_price_per_sqft`  double , `avg_security_rating`  double , `avg_service_rating`  double , `avg_value_rating`  double , `body`  string , `content_id`  int , `content_template_id`  int , `created_timestamp`  timestamp , `facilities`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `image_path`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `movingtruck_url`  string , `penske_url`  string , `popular_amenity_uri`  string , `popular_neighborhood_uri`  string , `popular_size_uri`  string , `popular_university_uri`  string , `popular_vehicle_uri`  string , `popular_zip_uri`  string , `publish`  smallint , `reviews_count`  int , `site_id`  int , `subtitle`  string , `title`  string , `updated_timestamp`  timestamp , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-16/1776366890'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_site_content"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-16/1776366890
id: 1717153
processed: 1

raw_data:

{
    "avg_10x10_price": "double",
    "avg_cleanliness_rating": "double",
    "avg_overall_rating": "double",
    "avg_paperwork_rating": "double",
    "avg_price": "double",
    "avg_price_per_sqft": "double",
    "avg_security_rating": "double",
    "avg_service_rating": "double",
    "avg_value_rating": "double",
    "body": "string",
    "content_id": "int32",
    "content_template_id": "int32",
    "created_timestamp": "timestamp[ns]",
    "facilities": "int32",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "image_path": "string",
    "location_id": "int32",
    "meta_description": "string",
    "meta_keywords": "string",
    "movingtruck_url": "string",
    "penske_url": "string",
    "popular_amenity_uri": "string",
    "popular_neighborhood_uri": "string",
    "popular_size_uri": "string",
    "popular_university_uri": "string",
    "popular_vehicle_uri": "string",
    "popular_zip_uri": "string",
    "publish": "int16",
    "reviews_count": "int32",
    "site_id": "int32",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp[ns]",
    "uri": "string"
}

schema_attributes:

{
    "avg_10x10_price": "double",
    "avg_cleanliness_rating": "double",
    "avg_overall_rating": "double",
    "avg_paperwork_rating": "double",
    "avg_price": "double",
    "avg_price_per_sqft": "double",
    "avg_security_rating": "double",
    "avg_service_rating": "double",
    "avg_value_rating": "double",
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "created_timestamp": "timestamp",
    "facilities": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "image_path": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "movingtruck_url": "string",
    "penske_url": "string",
    "popular_amenity_uri": "string",
    "popular_neighborhood_uri": "string",
    "popular_size_uri": "string",
    "popular_university_uri": "string",
    "popular_vehicle_uri": "string",
    "popular_zip_uri": "string",
    "publish": "smallint",
    "reviews_count": "int",
    "site_id": "int",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp",
    "uri": "string"
}

schema_name_id: 1103
schema_scan_id: 162138034
updated: 2026-04-16 14:15:22

Version 1716995

created: 2026-04-16 09:14:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_site_content`\n(\n `avg_10x10_price`  double , `avg_cleanliness_rating`  double , `avg_overall_rating`  double , `avg_paperwork_rating`  double , `avg_price`  double , `avg_price_per_sqft`  double , `avg_security_rating`  double , `avg_service_rating`  double , `avg_value_rating`  double , `body`  string , `content_id`  int , `content_template_id`  int , `created_timestamp`  timestamp , `facilities`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `image_path`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `movingtruck_url`  string , `penske_url`  string , `popular_amenity_uri`  string , `popular_neighborhood_uri`  string , `popular_size_uri`  string , `popular_university_uri`  string , `popular_vehicle_uri`  string , `popular_zip_uri`  string , `publish`  smallint , `reviews_count`  int , `site_id`  int , `subtitle`  string , `title`  string , `updated_timestamp`  timestamp , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-16/1776348878'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_site_content"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-16/1776348878
id: 1716995
processed: 1

raw_data:

{
    "avg_10x10_price": "double",
    "avg_cleanliness_rating": "double",
    "avg_overall_rating": "double",
    "avg_paperwork_rating": "double",
    "avg_price": "double",
    "avg_price_per_sqft": "double",
    "avg_security_rating": "double",
    "avg_service_rating": "double",
    "avg_value_rating": "double",
    "body": "string",
    "content_id": "int32",
    "content_template_id": "int32",
    "created_timestamp": "timestamp[ns]",
    "facilities": "int32",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "image_path": "string",
    "location_id": "int32",
    "meta_description": "string",
    "meta_keywords": "string",
    "movingtruck_url": "string",
    "penske_url": "string",
    "popular_amenity_uri": "string",
    "popular_neighborhood_uri": "string",
    "popular_size_uri": "string",
    "popular_university_uri": "string",
    "popular_vehicle_uri": "string",
    "popular_zip_uri": "string",
    "publish": "int16",
    "reviews_count": "int32",
    "site_id": "int32",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp[ns]",
    "uri": "string"
}

schema_attributes:

{
    "avg_10x10_price": "double",
    "avg_cleanliness_rating": "double",
    "avg_overall_rating": "double",
    "avg_paperwork_rating": "double",
    "avg_price": "double",
    "avg_price_per_sqft": "double",
    "avg_security_rating": "double",
    "avg_service_rating": "double",
    "avg_value_rating": "double",
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "created_timestamp": "timestamp",
    "facilities": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "image_path": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "movingtruck_url": "string",
    "penske_url": "string",
    "popular_amenity_uri": "string",
    "popular_neighborhood_uri": "string",
    "popular_size_uri": "string",
    "popular_university_uri": "string",
    "popular_vehicle_uri": "string",
    "popular_zip_uri": "string",
    "publish": "smallint",
    "reviews_count": "int",
    "site_id": "int",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp",
    "uri": "string"
}

schema_name_id: 1103
schema_scan_id: 162122531
updated: 2026-04-16 09:14:57

Version 1716187

created: 2026-04-16 00:05:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_site_content`\n(\n `avg_10x10_price`  double , `avg_cleanliness_rating`  double , `avg_overall_rating`  double , `avg_paperwork_rating`  double , `avg_price`  double , `avg_price_per_sqft`  double , `avg_security_rating`  double , `avg_service_rating`  double , `avg_value_rating`  double , `body`  string , `content_id`  int , `content_template_id`  int , `created_timestamp`  timestamp , `facilities`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `image_path`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `movingtruck_url`  string , `penske_url`  string , `popular_amenity_uri`  string , `popular_neighborhood_uri`  string , `popular_size_uri`  string , `popular_university_uri`  string , `popular_vehicle_uri`  string , `popular_zip_uri`  string , `publish`  smallint , `reviews_count`  int , `site_id`  int , `subtitle`  string , `title`  string , `updated_timestamp`  timestamp , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-16/1776315943'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_site_content"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-16/1776315943
id: 1716187
processed: 1

raw_data:

{
    "avg_10x10_price": "double",
    "avg_cleanliness_rating": "double",
    "avg_overall_rating": "double",
    "avg_paperwork_rating": "double",
    "avg_price": "double",
    "avg_price_per_sqft": "double",
    "avg_security_rating": "double",
    "avg_service_rating": "double",
    "avg_value_rating": "double",
    "body": "string",
    "content_id": "int32",
    "content_template_id": "int32",
    "created_timestamp": "timestamp[ns]",
    "facilities": "int32",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "image_path": "string",
    "location_id": "int32",
    "meta_description": "string",
    "meta_keywords": "string",
    "movingtruck_url": "string",
    "penske_url": "string",
    "popular_amenity_uri": "string",
    "popular_neighborhood_uri": "string",
    "popular_size_uri": "string",
    "popular_university_uri": "string",
    "popular_vehicle_uri": "string",
    "popular_zip_uri": "string",
    "publish": "int16",
    "reviews_count": "int32",
    "site_id": "int32",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp[ns]",
    "uri": "string"
}

schema_attributes:

{
    "avg_10x10_price": "double",
    "avg_cleanliness_rating": "double",
    "avg_overall_rating": "double",
    "avg_paperwork_rating": "double",
    "avg_price": "double",
    "avg_price_per_sqft": "double",
    "avg_security_rating": "double",
    "avg_service_rating": "double",
    "avg_value_rating": "double",
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "created_timestamp": "timestamp",
    "facilities": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "image_path": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "movingtruck_url": "string",
    "penske_url": "string",
    "popular_amenity_uri": "string",
    "popular_neighborhood_uri": "string",
    "popular_size_uri": "string",
    "popular_university_uri": "string",
    "popular_vehicle_uri": "string",
    "popular_zip_uri": "string",
    "publish": "smallint",
    "reviews_count": "int",
    "site_id": "int",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp",
    "uri": "string"
}

schema_name_id: 1103
schema_scan_id: 162107736
updated: 2026-04-16 00:06:01

Version 1716110

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_site_content`\n(\n `avg_10x10_price`  double , `avg_cleanliness_rating`  double , `avg_overall_rating`  double , `avg_paperwork_rating`  double , `avg_price`  double , `avg_price_per_sqft`  double , `avg_security_rating`  double , `avg_service_rating`  double , `avg_value_rating`  double , `body`  string , `content_id`  int , `content_template_id`  int , `created_timestamp`  timestamp , `facilities`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `image_path`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `movingtruck_url`  string , `penske_url`  string , `popular_amenity_uri`  string , `popular_neighborhood_uri`  string , `popular_size_uri`  string , `popular_university_uri`  string , `popular_vehicle_uri`  string , `popular_zip_uri`  string , `publish`  smallint , `reviews_count`  int , `site_id`  int , `subtitle`  string , `title`  string , `updated_timestamp`  timestamp , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-15/1776302682'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_site_content"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-15/1776302682
id: 1716110
processed: 1

raw_data:

{
    "avg_10x10_price": "double",
    "avg_cleanliness_rating": "double",
    "avg_overall_rating": "double",
    "avg_paperwork_rating": "double",
    "avg_price": "double",
    "avg_price_per_sqft": "double",
    "avg_security_rating": "double",
    "avg_service_rating": "double",
    "avg_value_rating": "double",
    "body": "string",
    "content_id": "int32",
    "content_template_id": "int32",
    "created_timestamp": "timestamp[ns]",
    "facilities": "int32",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "image_path": "string",
    "location_id": "int32",
    "meta_description": "string",
    "meta_keywords": "string",
    "movingtruck_url": "string",
    "penske_url": "string",
    "popular_amenity_uri": "string",
    "popular_neighborhood_uri": "string",
    "popular_size_uri": "string",
    "popular_university_uri": "string",
    "popular_vehicle_uri": "string",
    "popular_zip_uri": "string",
    "publish": "int16",
    "reviews_count": "int32",
    "site_id": "int32",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp[ns]",
    "uri": "string"
}

schema_attributes:

{
    "avg_10x10_price": "double",
    "avg_cleanliness_rating": "double",
    "avg_overall_rating": "double",
    "avg_paperwork_rating": "double",
    "avg_price": "double",
    "avg_price_per_sqft": "double",
    "avg_security_rating": "double",
    "avg_service_rating": "double",
    "avg_value_rating": "double",
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "created_timestamp": "timestamp",
    "facilities": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "image_path": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "movingtruck_url": "string",
    "penske_url": "string",
    "popular_amenity_uri": "string",
    "popular_neighborhood_uri": "string",
    "popular_size_uri": "string",
    "popular_university_uri": "string",
    "popular_vehicle_uri": "string",
    "popular_zip_uri": "string",
    "publish": "smallint",
    "reviews_count": "int",
    "site_id": "int",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp",
    "uri": "string"
}

schema_name_id: 1103
schema_scan_id: 162100326
updated: 2026-04-15 20:25:08

Version 1715968

created: 2026-04-15 14:16:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_site_content`\n(\n `avg_10x10_price`  double , `avg_cleanliness_rating`  double , `avg_overall_rating`  double , `avg_paperwork_rating`  double , `avg_price`  double , `avg_price_per_sqft`  double , `avg_security_rating`  double , `avg_service_rating`  double , `avg_value_rating`  double , `body`  string , `content_id`  int , `content_template_id`  int , `created_timestamp`  timestamp , `facilities`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `image_path`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `movingtruck_url`  string , `penske_url`  string , `popular_amenity_uri`  string , `popular_neighborhood_uri`  string , `popular_size_uri`  string , `popular_university_uri`  string , `popular_vehicle_uri`  string , `popular_zip_uri`  string , `publish`  smallint , `reviews_count`  int , `site_id`  int , `subtitle`  string , `title`  string , `updated_timestamp`  timestamp , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-15/1776280589'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_site_content"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-15/1776280589
id: 1715968
processed: 1

raw_data:

{
    "avg_10x10_price": "double",
    "avg_cleanliness_rating": "double",
    "avg_overall_rating": "double",
    "avg_paperwork_rating": "double",
    "avg_price": "double",
    "avg_price_per_sqft": "double",
    "avg_security_rating": "double",
    "avg_service_rating": "double",
    "avg_value_rating": "double",
    "body": "string",
    "content_id": "int32",
    "content_template_id": "int32",
    "created_timestamp": "timestamp[ns]",
    "facilities": "int32",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "image_path": "string",
    "location_id": "int32",
    "meta_description": "string",
    "meta_keywords": "string",
    "movingtruck_url": "string",
    "penske_url": "string",
    "popular_amenity_uri": "string",
    "popular_neighborhood_uri": "string",
    "popular_size_uri": "string",
    "popular_university_uri": "string",
    "popular_vehicle_uri": "string",
    "popular_zip_uri": "string",
    "publish": "int16",
    "reviews_count": "int32",
    "site_id": "int32",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp[ns]",
    "uri": "string"
}

schema_attributes:

{
    "avg_10x10_price": "double",
    "avg_cleanliness_rating": "double",
    "avg_overall_rating": "double",
    "avg_paperwork_rating": "double",
    "avg_price": "double",
    "avg_price_per_sqft": "double",
    "avg_security_rating": "double",
    "avg_service_rating": "double",
    "avg_value_rating": "double",
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "created_timestamp": "timestamp",
    "facilities": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "image_path": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "movingtruck_url": "string",
    "penske_url": "string",
    "popular_amenity_uri": "string",
    "popular_neighborhood_uri": "string",
    "popular_size_uri": "string",
    "popular_university_uri": "string",
    "popular_vehicle_uri": "string",
    "popular_zip_uri": "string",
    "publish": "smallint",
    "reviews_count": "int",
    "site_id": "int",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp",
    "uri": "string"
}

schema_name_id: 1103
schema_scan_id: 162081723
updated: 2026-04-15 14:16:48

Version 1715750

created: 2026-04-15 08:38:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_site_content`\n(\n `avg_10x10_price`  double , `avg_cleanliness_rating`  double , `avg_overall_rating`  double , `avg_paperwork_rating`  double , `avg_price`  double , `avg_price_per_sqft`  double , `avg_security_rating`  double , `avg_service_rating`  double , `avg_value_rating`  double , `body`  string , `content_id`  int , `content_template_id`  int , `created_timestamp`  timestamp , `facilities`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `image_path`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `movingtruck_url`  string , `penske_url`  string , `popular_amenity_uri`  string , `popular_neighborhood_uri`  string , `popular_size_uri`  string , `popular_university_uri`  string , `popular_vehicle_uri`  string , `popular_zip_uri`  string , `publish`  smallint , `reviews_count`  int , `site_id`  int , `subtitle`  string , `title`  string , `updated_timestamp`  timestamp , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-15/1776260263'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_site_content"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-15/1776260263
id: 1715750
processed: 1

raw_data:

{
    "avg_10x10_price": "double",
    "avg_cleanliness_rating": "double",
    "avg_overall_rating": "double",
    "avg_paperwork_rating": "double",
    "avg_price": "double",
    "avg_price_per_sqft": "double",
    "avg_security_rating": "double",
    "avg_service_rating": "double",
    "avg_value_rating": "double",
    "body": "string",
    "content_id": "int32",
    "content_template_id": "int32",
    "created_timestamp": "timestamp[ns]",
    "facilities": "int32",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "image_path": "string",
    "location_id": "int32",
    "meta_description": "string",
    "meta_keywords": "string",
    "movingtruck_url": "string",
    "penske_url": "string",
    "popular_amenity_uri": "string",
    "popular_neighborhood_uri": "string",
    "popular_size_uri": "string",
    "popular_university_uri": "string",
    "popular_vehicle_uri": "string",
    "popular_zip_uri": "string",
    "publish": "int16",
    "reviews_count": "int32",
    "site_id": "int32",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp[ns]",
    "uri": "string"
}

schema_attributes:

{
    "avg_10x10_price": "double",
    "avg_cleanliness_rating": "double",
    "avg_overall_rating": "double",
    "avg_paperwork_rating": "double",
    "avg_price": "double",
    "avg_price_per_sqft": "double",
    "avg_security_rating": "double",
    "avg_service_rating": "double",
    "avg_value_rating": "double",
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "created_timestamp": "timestamp",
    "facilities": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "image_path": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "movingtruck_url": "string",
    "penske_url": "string",
    "popular_amenity_uri": "string",
    "popular_neighborhood_uri": "string",
    "popular_size_uri": "string",
    "popular_university_uri": "string",
    "popular_vehicle_uri": "string",
    "popular_zip_uri": "string",
    "publish": "smallint",
    "reviews_count": "int",
    "site_id": "int",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp",
    "uri": "string"
}

schema_name_id: 1103
schema_scan_id: 162064355
updated: 2026-04-15 08:39:09

Version 1715013

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_site_content`\n(\n `avg_10x10_price`  double , `avg_cleanliness_rating`  double , `avg_overall_rating`  double , `avg_paperwork_rating`  double , `avg_price`  double , `avg_price_per_sqft`  double , `avg_security_rating`  double , `avg_service_rating`  double , `avg_value_rating`  double , `body`  string , `content_id`  int , `content_template_id`  int , `created_timestamp`  timestamp , `facilities`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `image_path`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `movingtruck_url`  string , `penske_url`  string , `popular_amenity_uri`  string , `popular_neighborhood_uri`  string , `popular_size_uri`  string , `popular_university_uri`  string , `popular_vehicle_uri`  string , `popular_zip_uri`  string , `publish`  smallint , `reviews_count`  int , `site_id`  int , `subtitle`  string , `title`  string , `updated_timestamp`  timestamp , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-15/1776230048'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_site_content"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-15/1776230048
id: 1715013
processed: 1

raw_data:

{
    "avg_10x10_price": "double",
    "avg_cleanliness_rating": "double",
    "avg_overall_rating": "double",
    "avg_paperwork_rating": "double",
    "avg_price": "double",
    "avg_price_per_sqft": "double",
    "avg_security_rating": "double",
    "avg_service_rating": "double",
    "avg_value_rating": "double",
    "body": "string",
    "content_id": "int32",
    "content_template_id": "int32",
    "created_timestamp": "timestamp[ns]",
    "facilities": "int32",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "image_path": "string",
    "location_id": "int32",
    "meta_description": "string",
    "meta_keywords": "string",
    "movingtruck_url": "string",
    "penske_url": "string",
    "popular_amenity_uri": "string",
    "popular_neighborhood_uri": "string",
    "popular_size_uri": "string",
    "popular_university_uri": "string",
    "popular_vehicle_uri": "string",
    "popular_zip_uri": "string",
    "publish": "int16",
    "reviews_count": "int32",
    "site_id": "int32",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp[ns]",
    "uri": "string"
}

schema_attributes:

{
    "avg_10x10_price": "double",
    "avg_cleanliness_rating": "double",
    "avg_overall_rating": "double",
    "avg_paperwork_rating": "double",
    "avg_price": "double",
    "avg_price_per_sqft": "double",
    "avg_security_rating": "double",
    "avg_service_rating": "double",
    "avg_value_rating": "double",
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "created_timestamp": "timestamp",
    "facilities": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "image_path": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "movingtruck_url": "string",
    "penske_url": "string",
    "popular_amenity_uri": "string",
    "popular_neighborhood_uri": "string",
    "popular_size_uri": "string",
    "popular_university_uri": "string",
    "popular_vehicle_uri": "string",
    "popular_zip_uri": "string",
    "publish": "smallint",
    "reviews_count": "int",
    "site_id": "int",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp",
    "uri": "string"
}

schema_name_id: 1103
schema_scan_id: 162051966
updated: 2026-04-15 00:14:33

Version 1714891

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_site_content`\n(\n `avg_10x10_price`  double , `avg_cleanliness_rating`  double , `avg_overall_rating`  double , `avg_paperwork_rating`  double , `avg_price`  double , `avg_price_per_sqft`  double , `avg_security_rating`  double , `avg_service_rating`  double , `avg_value_rating`  double , `body`  string , `content_id`  int , `content_template_id`  int , `created_timestamp`  timestamp , `facilities`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `image_path`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `movingtruck_url`  string , `penske_url`  string , `popular_amenity_uri`  string , `popular_neighborhood_uri`  string , `popular_size_uri`  string , `popular_university_uri`  string , `popular_vehicle_uri`  string , `popular_zip_uri`  string , `publish`  smallint , `reviews_count`  int , `site_id`  int , `subtitle`  string , `title`  string , `updated_timestamp`  timestamp , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-14/1776215705'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_site_content"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-14/1776215705
id: 1714891
processed: 1

raw_data:

{
    "avg_10x10_price": "double",
    "avg_cleanliness_rating": "double",
    "avg_overall_rating": "double",
    "avg_paperwork_rating": "double",
    "avg_price": "double",
    "avg_price_per_sqft": "double",
    "avg_security_rating": "double",
    "avg_service_rating": "double",
    "avg_value_rating": "double",
    "body": "string",
    "content_id": "int32",
    "content_template_id": "int32",
    "created_timestamp": "timestamp[ns]",
    "facilities": "int32",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "image_path": "string",
    "location_id": "int32",
    "meta_description": "string",
    "meta_keywords": "string",
    "movingtruck_url": "string",
    "penske_url": "string",
    "popular_amenity_uri": "string",
    "popular_neighborhood_uri": "string",
    "popular_size_uri": "string",
    "popular_university_uri": "string",
    "popular_vehicle_uri": "string",
    "popular_zip_uri": "string",
    "publish": "int16",
    "reviews_count": "int32",
    "site_id": "int32",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp[ns]",
    "uri": "string"
}

schema_attributes:

{
    "avg_10x10_price": "double",
    "avg_cleanliness_rating": "double",
    "avg_overall_rating": "double",
    "avg_paperwork_rating": "double",
    "avg_price": "double",
    "avg_price_per_sqft": "double",
    "avg_security_rating": "double",
    "avg_service_rating": "double",
    "avg_value_rating": "double",
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "created_timestamp": "timestamp",
    "facilities": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "image_path": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "movingtruck_url": "string",
    "penske_url": "string",
    "popular_amenity_uri": "string",
    "popular_neighborhood_uri": "string",
    "popular_size_uri": "string",
    "popular_university_uri": "string",
    "popular_vehicle_uri": "string",
    "popular_zip_uri": "string",
    "publish": "smallint",
    "reviews_count": "int",
    "site_id": "int",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp",
    "uri": "string"
}

schema_name_id: 1103
schema_scan_id: 162044249
updated: 2026-04-14 20:15:54

Version 1714727

created: 2026-04-14 14:14:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_site_content`\n(\n `avg_10x10_price`  double , `avg_cleanliness_rating`  double , `avg_overall_rating`  double , `avg_paperwork_rating`  double , `avg_price`  double , `avg_price_per_sqft`  double , `avg_security_rating`  double , `avg_service_rating`  double , `avg_value_rating`  double , `body`  string , `content_id`  int , `content_template_id`  int , `created_timestamp`  timestamp , `facilities`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `image_path`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `movingtruck_url`  string , `penske_url`  string , `popular_amenity_uri`  string , `popular_neighborhood_uri`  string , `popular_size_uri`  string , `popular_university_uri`  string , `popular_vehicle_uri`  string , `popular_zip_uri`  string , `publish`  smallint , `reviews_count`  int , `site_id`  int , `subtitle`  string , `title`  string , `updated_timestamp`  timestamp , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-14/1776194040'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_site_content"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-14/1776194040
id: 1714727
processed: 1

raw_data:

{
    "avg_10x10_price": "double",
    "avg_cleanliness_rating": "double",
    "avg_overall_rating": "double",
    "avg_paperwork_rating": "double",
    "avg_price": "double",
    "avg_price_per_sqft": "double",
    "avg_security_rating": "double",
    "avg_service_rating": "double",
    "avg_value_rating": "double",
    "body": "string",
    "content_id": "int32",
    "content_template_id": "int32",
    "created_timestamp": "timestamp[ns]",
    "facilities": "int32",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "image_path": "string",
    "location_id": "int32",
    "meta_description": "string",
    "meta_keywords": "string",
    "movingtruck_url": "string",
    "penske_url": "string",
    "popular_amenity_uri": "string",
    "popular_neighborhood_uri": "string",
    "popular_size_uri": "string",
    "popular_university_uri": "string",
    "popular_vehicle_uri": "string",
    "popular_zip_uri": "string",
    "publish": "int16",
    "reviews_count": "int32",
    "site_id": "int32",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp[ns]",
    "uri": "string"
}

schema_attributes:

{
    "avg_10x10_price": "double",
    "avg_cleanliness_rating": "double",
    "avg_overall_rating": "double",
    "avg_paperwork_rating": "double",
    "avg_price": "double",
    "avg_price_per_sqft": "double",
    "avg_security_rating": "double",
    "avg_service_rating": "double",
    "avg_value_rating": "double",
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "created_timestamp": "timestamp",
    "facilities": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "image_path": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "movingtruck_url": "string",
    "penske_url": "string",
    "popular_amenity_uri": "string",
    "popular_neighborhood_uri": "string",
    "popular_size_uri": "string",
    "popular_university_uri": "string",
    "popular_vehicle_uri": "string",
    "popular_zip_uri": "string",
    "publish": "smallint",
    "reviews_count": "int",
    "site_id": "int",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp",
    "uri": "string"
}

schema_name_id: 1103
schema_scan_id: 162026106
updated: 2026-04-14 14:15:09

Version 1714595

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_site_content`\n(\n `avg_10x10_price`  double , `avg_cleanliness_rating`  double , `avg_overall_rating`  double , `avg_paperwork_rating`  double , `avg_price`  double , `avg_price_per_sqft`  double , `avg_security_rating`  double , `avg_service_rating`  double , `avg_value_rating`  double , `body`  string , `content_id`  int , `content_template_id`  int , `created_timestamp`  timestamp , `facilities`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `image_path`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `movingtruck_url`  string , `penske_url`  string , `popular_amenity_uri`  string , `popular_neighborhood_uri`  string , `popular_size_uri`  string , `popular_university_uri`  string , `popular_vehicle_uri`  string , `popular_zip_uri`  string , `publish`  smallint , `reviews_count`  int , `site_id`  int , `subtitle`  string , `title`  string , `updated_timestamp`  timestamp , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-14/1776175749'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_site_content"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-14/1776175749
id: 1714595
processed: 1

raw_data:

{
    "avg_10x10_price": "double",
    "avg_cleanliness_rating": "double",
    "avg_overall_rating": "double",
    "avg_paperwork_rating": "double",
    "avg_price": "double",
    "avg_price_per_sqft": "double",
    "avg_security_rating": "double",
    "avg_service_rating": "double",
    "avg_value_rating": "double",
    "body": "string",
    "content_id": "int32",
    "content_template_id": "int32",
    "created_timestamp": "timestamp[ns]",
    "facilities": "int32",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "image_path": "string",
    "location_id": "int32",
    "meta_description": "string",
    "meta_keywords": "string",
    "movingtruck_url": "string",
    "penske_url": "string",
    "popular_amenity_uri": "string",
    "popular_neighborhood_uri": "string",
    "popular_size_uri": "string",
    "popular_university_uri": "string",
    "popular_vehicle_uri": "string",
    "popular_zip_uri": "string",
    "publish": "int16",
    "reviews_count": "int32",
    "site_id": "int32",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp[ns]",
    "uri": "string"
}

schema_attributes:

{
    "avg_10x10_price": "double",
    "avg_cleanliness_rating": "double",
    "avg_overall_rating": "double",
    "avg_paperwork_rating": "double",
    "avg_price": "double",
    "avg_price_per_sqft": "double",
    "avg_security_rating": "double",
    "avg_service_rating": "double",
    "avg_value_rating": "double",
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "created_timestamp": "timestamp",
    "facilities": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "image_path": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "movingtruck_url": "string",
    "penske_url": "string",
    "popular_amenity_uri": "string",
    "popular_neighborhood_uri": "string",
    "popular_size_uri": "string",
    "popular_university_uri": "string",
    "popular_vehicle_uri": "string",
    "popular_zip_uri": "string",
    "publish": "smallint",
    "reviews_count": "int",
    "site_id": "int",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp",
    "uri": "string"
}

schema_name_id: 1103
schema_scan_id: 162010966
updated: 2026-04-14 09:11:19

Version 1713803

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_site_content`\n(\n `avg_10x10_price`  double , `avg_cleanliness_rating`  double , `avg_overall_rating`  double , `avg_paperwork_rating`  double , `avg_price`  double , `avg_price_per_sqft`  double , `avg_security_rating`  double , `avg_service_rating`  double , `avg_value_rating`  double , `body`  string , `content_id`  int , `content_template_id`  int , `created_timestamp`  timestamp , `facilities`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `image_path`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `movingtruck_url`  string , `penske_url`  string , `popular_amenity_uri`  string , `popular_neighborhood_uri`  string , `popular_size_uri`  string , `popular_university_uri`  string , `popular_vehicle_uri`  string , `popular_zip_uri`  string , `publish`  smallint , `reviews_count`  int , `site_id`  int , `subtitle`  string , `title`  string , `updated_timestamp`  timestamp , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-14/1776143327'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_site_content"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-14/1776143327
id: 1713803
processed: 1

raw_data:

{
    "avg_10x10_price": "double",
    "avg_cleanliness_rating": "double",
    "avg_overall_rating": "double",
    "avg_paperwork_rating": "double",
    "avg_price": "double",
    "avg_price_per_sqft": "double",
    "avg_security_rating": "double",
    "avg_service_rating": "double",
    "avg_value_rating": "double",
    "body": "string",
    "content_id": "int32",
    "content_template_id": "int32",
    "created_timestamp": "timestamp[ns]",
    "facilities": "int32",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "image_path": "string",
    "location_id": "int32",
    "meta_description": "string",
    "meta_keywords": "string",
    "movingtruck_url": "string",
    "penske_url": "string",
    "popular_amenity_uri": "string",
    "popular_neighborhood_uri": "string",
    "popular_size_uri": "string",
    "popular_university_uri": "string",
    "popular_vehicle_uri": "string",
    "popular_zip_uri": "string",
    "publish": "int16",
    "reviews_count": "int32",
    "site_id": "int32",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp[ns]",
    "uri": "string"
}

schema_attributes:

{
    "avg_10x10_price": "double",
    "avg_cleanliness_rating": "double",
    "avg_overall_rating": "double",
    "avg_paperwork_rating": "double",
    "avg_price": "double",
    "avg_price_per_sqft": "double",
    "avg_security_rating": "double",
    "avg_service_rating": "double",
    "avg_value_rating": "double",
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "created_timestamp": "timestamp",
    "facilities": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "image_path": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "movingtruck_url": "string",
    "penske_url": "string",
    "popular_amenity_uri": "string",
    "popular_neighborhood_uri": "string",
    "popular_size_uri": "string",
    "popular_university_uri": "string",
    "popular_vehicle_uri": "string",
    "popular_zip_uri": "string",
    "publish": "smallint",
    "reviews_count": "int",
    "site_id": "int",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp",
    "uri": "string"
}

schema_name_id: 1103
schema_scan_id: 161996336
updated: 2026-04-14 00:09:03

Schema Scans: 15

Last at 2026-04-17 14:16:36

Scan 162194038

duration: 0:00:15.105003

exit_message:

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

id: 162194038

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_site_content/2026-04-17/1776453392",
        "key": "raw/sparefoot_site_content/2026-04-17/1776453392/site_content_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 967444597111233843,
        "service_name": "sparefoot",
        "span_id": 5004068015326969231,
        "trace_id": 967444597111233843
    }
}

running: False
schema_name_id: 1103
start_time: 2026-04-17 14:16:36
success: True
trace_id: 967444597111233843

Scan 162178333

duration: 0:00:15.234382

exit_message:

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

id: 162178333

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_site_content/2026-04-17/1776435956",
        "key": "raw/sparefoot_site_content/2026-04-17/1776435956/site_content_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 589365876003619177,
        "service_name": "sparefoot",
        "span_id": 709967775361302001,
        "trace_id": 589365876003619177
    }
}

running: False
schema_name_id: 1103
start_time: 2026-04-17 09:26:07
success: True
trace_id: 589365876003619177

Scan 162163579

duration: 0:00:12.596831

exit_message:

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

id: 162163579

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_site_content/2026-04-17/1776402435",
        "key": "raw/sparefoot_site_content/2026-04-17/1776402435/site_content_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 18286386218803485248,
        "service_name": "sparefoot",
        "span_id": 16890476552757242940,
        "trace_id": 18286386218803485248
    }
}

running: False
schema_name_id: 1103
start_time: 2026-04-17 00:07:35
success: True
trace_id: 18286386218803485248

Scan 162156075

duration: 0:00:15.060854

exit_message:

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

id: 162156075

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_site_content/2026-04-16/1776388527",
        "key": "raw/sparefoot_site_content/2026-04-16/1776388527/site_content_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9054284184214002297,
        "service_name": "sparefoot",
        "span_id": 12565235003390544430,
        "trace_id": 9054284184214002297
    }
}

running: False
schema_name_id: 1103
start_time: 2026-04-16 20:18:11
success: True
trace_id: 9054284184214002297

Scan 162138034

duration: 0:00:15.347832

exit_message:

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

id: 162138034

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_site_content/2026-04-16/1776366890",
        "key": "raw/sparefoot_site_content/2026-04-16/1776366890/site_content_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4689996782721799051,
        "service_name": "sparefoot",
        "span_id": 7543239026555545594,
        "trace_id": 4689996782721799051
    }
}

running: False
schema_name_id: 1103
start_time: 2026-04-16 14:15:07
success: True
trace_id: 4689996782721799051

Scan 162122531

duration: 0:00:15.034634

exit_message:

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

id: 162122531

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_site_content/2026-04-16/1776348878",
        "key": "raw/sparefoot_site_content/2026-04-16/1776348878/site_content_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16567021192024670176,
        "service_name": "sparefoot",
        "span_id": 15954760628299477429,
        "trace_id": 16567021192024670176
    }
}

running: False
schema_name_id: 1103
start_time: 2026-04-16 09:14:42
success: True
trace_id: 16567021192024670176

Scan 162107736

duration: 0:00:14.872195

exit_message:

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

id: 162107736

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_site_content/2026-04-16/1776315943",
        "key": "raw/sparefoot_site_content/2026-04-16/1776315943/site_content_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1452572006453273412,
        "service_name": "sparefoot",
        "span_id": 8187386238114007568,
        "trace_id": 1452572006453273412
    }
}

running: False
schema_name_id: 1103
start_time: 2026-04-16 00:05:46
success: True
trace_id: 1452572006453273412

Scan 162100326

duration: 0:00:15.088606

exit_message:

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

id: 162100326

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_site_content/2026-04-15/1776302682",
        "key": "raw/sparefoot_site_content/2026-04-15/1776302682/site_content_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4754402682449049718,
        "service_name": "sparefoot",
        "span_id": 10421408970521695166,
        "trace_id": 4754402682449049718
    }
}

running: False
schema_name_id: 1103
start_time: 2026-04-15 20:24:53
success: True
trace_id: 4754402682449049718

Scan 162081723

duration: 0:00:14.960081

exit_message:

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

id: 162081723

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_site_content/2026-04-15/1776280589",
        "key": "raw/sparefoot_site_content/2026-04-15/1776280589/site_content_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 18003368601834814594,
        "service_name": "sparefoot",
        "span_id": 17028121558798532088,
        "trace_id": 18003368601834814594
    }
}

running: False
schema_name_id: 1103
start_time: 2026-04-15 14:16:33
success: True
trace_id: 18003368601834814594

Scan 162064355

duration: 0:00:12.420415

exit_message:

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

id: 162064355

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_site_content/2026-04-15/1776260263",
        "key": "raw/sparefoot_site_content/2026-04-15/1776260263/site_content_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9869313991181867629,
        "service_name": "sparefoot",
        "span_id": 6322937653504525004,
        "trace_id": 9869313991181867629
    }
}

running: False
schema_name_id: 1103
start_time: 2026-04-15 08:38:56
success: True
trace_id: 9869313991181867629

Scan 162051966

duration: 0:00:15.121697

exit_message:

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

id: 162051966

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_site_content/2026-04-15/1776230048",
        "key": "raw/sparefoot_site_content/2026-04-15/1776230048/site_content_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6494895983818273844,
        "service_name": "sparefoot",
        "span_id": 15103626170173769766,
        "trace_id": 6494895983818273844
    }
}

running: False
schema_name_id: 1103
start_time: 2026-04-15 00:14:18
success: True
trace_id: 6494895983818273844

Scan 162044249

duration: 0:00:15.075796

exit_message:

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

id: 162044249

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_site_content/2026-04-14/1776215705",
        "key": "raw/sparefoot_site_content/2026-04-14/1776215705/site_content_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5698847310977558805,
        "service_name": "sparefoot",
        "span_id": 13128466694279152641,
        "trace_id": 5698847310977558805
    }
}

running: False
schema_name_id: 1103
start_time: 2026-04-14 20:15:39
success: True
trace_id: 5698847310977558805

Scan 162026106

duration: 0:00:15.059249

exit_message:

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

id: 162026106

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_site_content/2026-04-14/1776194040",
        "key": "raw/sparefoot_site_content/2026-04-14/1776194040/site_content_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 18315353272608212183,
        "service_name": "sparefoot",
        "span_id": 2739981480654351051,
        "trace_id": 18315353272608212183
    }
}

running: False
schema_name_id: 1103
start_time: 2026-04-14 14:14:54
success: True
trace_id: 18315353272608212183

Scan 162010966

duration: 0:00:12.659428

exit_message:

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

id: 162010966

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_site_content/2026-04-14/1776175749",
        "key": "raw/sparefoot_site_content/2026-04-14/1776175749/site_content_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9321957940516791743,
        "service_name": "sparefoot",
        "span_id": 16478200968098237148,
        "trace_id": 9321957940516791743
    }
}

running: False
schema_name_id: 1103
start_time: 2026-04-14 09:11:07
success: True
trace_id: 9321957940516791743

Scan 161996336

duration: 0:00:12.474129

exit_message:

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

id: 161996336

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_site_content/2026-04-14/1776143327",
        "key": "raw/sparefoot_site_content/2026-04-14/1776143327/site_content_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12256366113163330989,
        "service_name": "sparefoot",
        "span_id": 15795405039389007264,
        "trace_id": 12256366113163330989
    }
}

running: False
schema_name_id: 1103
start_time: 2026-04-14 00:08:51
success: True
trace_id: 12256366113163330989

Partitions:

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

Schema:

attributes:

{
    "avg_10x10_price": "double",
    "avg_cleanliness_rating": "double",
    "avg_overall_rating": "double",
    "avg_paperwork_rating": "double",
    "avg_price": "double",
    "avg_price_per_sqft": "double",
    "avg_security_rating": "double",
    "avg_service_rating": "double",
    "avg_value_rating": "double",
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "created_timestamp": "timestamp",
    "facilities": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "image_path": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "movingtruck_url": "string",
    "penske_url": "string",
    "popular_amenity_uri": "string",
    "popular_neighborhood_uri": "string",
    "popular_size_uri": "string",
    "popular_university_uri": "string",
    "popular_vehicle_uri": "string",
    "popular_zip_uri": "string",
    "publish": "smallint",
    "reviews_count": "int",
    "site_id": "int",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp",
    "uri": "string"
}

created: 2026-04-17 14:16:37

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_site_content`\n(\n `avg_10x10_price`  double , `avg_cleanliness_rating`  double , `avg_overall_rating`  double , `avg_paperwork_rating`  double , `avg_price`  double , `avg_price_per_sqft`  double , `avg_security_rating`  double , `avg_service_rating`  double , `avg_value_rating`  double , `body`  string , `content_id`  int , `content_template_id`  int , `created_timestamp`  timestamp , `facilities`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `image_path`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `movingtruck_url`  string , `penske_url`  string , `popular_amenity_uri`  string , `popular_neighborhood_uri`  string , `popular_size_uri`  string , `popular_university_uri`  string , `popular_vehicle_uri`  string , `popular_zip_uri`  string , `publish`  smallint , `reviews_count`  int , `site_id`  int , `subtitle`  string , `title`  string , `updated_timestamp`  timestamp , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-17/1776453392'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_site_content`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_site_content"
}

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:19:51",
        "disabled": false,
        "format": "raw",
        "id": 1103,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_rds",
            "table": "sparefoot_sparefoot_site_content"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "avg_10x10_price": "double",
            "avg_cleanliness_rating": "double",
            "avg_overall_rating": "double",
            "avg_paperwork_rating": "double",
            "avg_price": "double",
            "avg_price_per_sqft": "double",
            "avg_security_rating": "double",
            "avg_service_rating": "double",
            "avg_value_rating": "double",
            "body": "string",
            "content_id": "int",
            "content_template_id": "int",
            "created_timestamp": "timestamp",
            "facilities": "int",
            "head_title": "string",
            "hireahelper_anchor": "string",
            "hireahelper_url": "string",
            "image_path": "string",
            "location_id": "int",
            "meta_description": "string",
            "meta_keywords": "string",
            "movingtruck_url": "string",
            "penske_url": "string",
            "popular_amenity_uri": "string",
            "popular_neighborhood_uri": "string",
            "popular_size_uri": "string",
            "popular_university_uri": "string",
            "popular_vehicle_uri": "string",
            "popular_zip_uri": "string",
            "publish": "smallint",
            "reviews_count": "int",
            "site_id": "int",
            "subtitle": "string",
            "title": "string",
            "updated_timestamp": "timestamp",
            "uri": "string"
        },
        "created": "2026-04-17 14:16:37",
        "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_site_content`\n(\n `avg_10x10_price`  double , `avg_cleanliness_rating`  double , `avg_overall_rating`  double , `avg_paperwork_rating`  double , `avg_price`  double , `avg_price_per_sqft`  double , `avg_security_rating`  double , `avg_service_rating`  double , `avg_value_rating`  double , `body`  string , `content_id`  int , `content_template_id`  int , `created_timestamp`  timestamp , `facilities`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `image_path`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `movingtruck_url`  string , `penske_url`  string , `popular_amenity_uri`  string , `popular_neighborhood_uri`  string , `popular_size_uri`  string , `popular_university_uri`  string , `popular_vehicle_uri`  string , `popular_zip_uri`  string , `publish`  smallint , `reviews_count`  int , `site_id`  int , `subtitle`  string , `title`  string , `updated_timestamp`  timestamp , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_site_content/2026-04-17/1776453392'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_site_content`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_site_content"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}