Schema Info

Schema Name: sfdl_stage_rds.sparefoot_sparefoot_site_content

created: 2022-08-12 10:19:22
disabled: False
format: raw
id: 1329
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 906560

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_site_content/2026-04-17/1776403163
id: 906560
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: 1329
schema_scan_id: 6415127
updated: 2026-04-17 00:20:02

Version 906348

created: 2026-04-16 00:11:39

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_site_content/2026-04-16/1776316281
id: 906348
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: 1329
schema_scan_id: 6414583
updated: 2026-04-16 00:11:53

Version 906103

created: 2026-04-15 00:07:06

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_site_content/2026-04-15/1776229621
id: 906103
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: 1329
schema_scan_id: 6414061
updated: 2026-04-15 00:07:20

Version 905887

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_site_content/2026-04-14/1776143335
id: 905887
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: 1329
schema_scan_id: 6413552
updated: 2026-04-14 00:09:22

Version 905687

created: 2026-04-13 00:15:09

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_site_content/2026-04-13/1776057281
id: 905687
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: 1329
schema_scan_id: 6413020
updated: 2026-04-13 00:15:23

Version 905507

created: 2026-04-12 00:12:09

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_site_content/2026-04-12/1775970724
id: 905507
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: 1329
schema_scan_id: 6412659
updated: 2026-04-12 00:12:23

Version 905265

created: 2026-04-11 00:06:13

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_site_content/2026-04-11/1775883959
id: 905265
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: 1329
schema_scan_id: 6412236
updated: 2026-04-11 00:06:24

Version 905086

created: 2026-04-10 00:11:40

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_site_content/2026-04-10/1775797895
id: 905086
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: 1329
schema_scan_id: 6411768
updated: 2026-04-10 00:11:52

Version 904869

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_site_content/2026-04-09/1775711655
id: 904869
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: 1329
schema_scan_id: 6411256
updated: 2026-04-09 00:14:34

Version 904623

created: 2026-04-08 00:06:56

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_site_content/2026-04-08/1775624791
id: 904623
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: 1329
schema_scan_id: 6410718
updated: 2026-04-08 00:07:09

Version 904429

created: 2026-04-07 00:10:52

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_site_content/2026-04-07/1775538639
id: 904429
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: 1329
schema_scan_id: 6410232
updated: 2026-04-07 00:11:06

Version 904212

created: 2026-04-06 00:07:19

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_site_content/2026-04-06/1775452033
id: 904212
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: 1329
schema_scan_id: 6409684
updated: 2026-04-06 00:07:30

Version 904010

created: 2026-04-05 00:08:18

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_site_content/2026-04-05/1775365694
id: 904010
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: 1329
schema_scan_id: 6409304
updated: 2026-04-05 00:08:30

Version 903805

created: 2026-04-04 00:08:04

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_site_content/2026-04-04/1775279279
id: 903805
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: 1329
schema_scan_id: 6408920
updated: 2026-04-04 00:08:18

Version 903621

created: 2026-04-03 00:12:48

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_site_content/2026-04-03/1775193161
id: 903621
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: 1329
schema_scan_id: 6408456
updated: 2026-04-03 00:12:59

Schema Scans: 15

Last at 2026-04-17 00:19:50

Scan 6415127

duration: 0:00:12.681118

exit_message:

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

id: 6415127

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_site_content/2026-04-17/1776403163",
        "key": "raw/sparefoot_site_content/2026-04-17/1776403163/site_content_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17709559638682063115,
        "service_name": "sparefoot",
        "span_id": 18359550309581709934,
        "trace_id": 17709559638682063115
    }
}

running: False
schema_name_id: 1329
start_time: 2026-04-17 00:19:50
success: True
trace_id: 17709559638682063115

Scan 6414583

duration: 0:00:15.137115

exit_message:

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

id: 6414583

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_site_content/2026-04-16/1776316281",
        "key": "raw/sparefoot_site_content/2026-04-16/1776316281/site_content_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1611338112856893556,
        "service_name": "sparefoot",
        "span_id": 4385399732203132155,
        "trace_id": 1611338112856893556
    }
}

running: False
schema_name_id: 1329
start_time: 2026-04-16 00:11:38
success: True
trace_id: 1611338112856893556

Scan 6414061

duration: 0:00:15.195324

exit_message:

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

id: 6414061

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_site_content/2026-04-15/1776229621",
        "key": "raw/sparefoot_site_content/2026-04-15/1776229621/site_content_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11982837821586614709,
        "service_name": "sparefoot",
        "span_id": 13496330927203921085,
        "trace_id": 11982837821586614709
    }
}

running: False
schema_name_id: 1329
start_time: 2026-04-15 00:07:04
success: True
trace_id: 11982837821586614709

Scan 6413552

duration: 0:00:15.287134

exit_message:

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

id: 6413552

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_site_content/2026-04-14/1776143335",
        "key": "raw/sparefoot_site_content/2026-04-14/1776143335/site_content_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8635052530711357090,
        "service_name": "sparefoot",
        "span_id": 16510927705103241138,
        "trace_id": 8635052530711357090
    }
}

running: False
schema_name_id: 1329
start_time: 2026-04-14 00:09:07
success: True
trace_id: 8635052530711357090

Scan 6413020

duration: 0:00:15.218562

exit_message:

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

id: 6413020

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_site_content/2026-04-13/1776057281",
        "key": "raw/sparefoot_site_content/2026-04-13/1776057281/site_content_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11769394586269524939,
        "service_name": "sparefoot",
        "span_id": 10176684774459221986,
        "trace_id": 11769394586269524939
    }
}

running: False
schema_name_id: 1329
start_time: 2026-04-13 00:15:08
success: True
trace_id: 11769394586269524939

Scan 6412659

duration: 0:00:15.112803

exit_message:

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

id: 6412659

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_site_content/2026-04-12/1775970724",
        "key": "raw/sparefoot_site_content/2026-04-12/1775970724/site_content_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3516049297138487460,
        "service_name": "sparefoot",
        "span_id": 9480710970752564485,
        "trace_id": 3516049297138487460
    }
}

running: False
schema_name_id: 1329
start_time: 2026-04-12 00:12:08
success: True
trace_id: 3516049297138487460

Scan 6412236

duration: 0:00:12.571861

exit_message:

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

id: 6412236

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_site_content/2026-04-11/1775883959",
        "key": "raw/sparefoot_site_content/2026-04-11/1775883959/site_content_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1950210262867798074,
        "service_name": "sparefoot",
        "span_id": 14266972222985722685,
        "trace_id": 1950210262867798074
    }
}

running: False
schema_name_id: 1329
start_time: 2026-04-11 00:06:12
success: True
trace_id: 1950210262867798074

Scan 6411768

duration: 0:00:12.737736

exit_message:

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

id: 6411768

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_site_content/2026-04-10/1775797895",
        "key": "raw/sparefoot_site_content/2026-04-10/1775797895/site_content_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10843050056611412636,
        "service_name": "sparefoot",
        "span_id": 3117176570639046172,
        "trace_id": 10843050056611412636
    }
}

running: False
schema_name_id: 1329
start_time: 2026-04-10 00:11:39
success: True
trace_id: 10843050056611412636

Scan 6411256

duration: 0:00:15.956689

exit_message:

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

id: 6411256

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_site_content/2026-04-09/1775711655",
        "key": "raw/sparefoot_site_content/2026-04-09/1775711655/site_content_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6154141557457941143,
        "service_name": "sparefoot",
        "span_id": 426457048680058462,
        "trace_id": 6154141557457941143
    }
}

running: False
schema_name_id: 1329
start_time: 2026-04-09 00:14:18
success: True
trace_id: 6154141557457941143

Scan 6410718

duration: 0:00:15.175853

exit_message:

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

id: 6410718

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_site_content/2026-04-08/1775624791",
        "key": "raw/sparefoot_site_content/2026-04-08/1775624791/site_content_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15890708263357455702,
        "service_name": "sparefoot",
        "span_id": 5858086530086439650,
        "trace_id": 15890708263357455702
    }
}

running: False
schema_name_id: 1329
start_time: 2026-04-08 00:06:54
success: True
trace_id: 15890708263357455702

Scan 6410232

duration: 0:00:15.453327

exit_message:

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

id: 6410232

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_site_content/2026-04-07/1775538639",
        "key": "raw/sparefoot_site_content/2026-04-07/1775538639/site_content_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7392586736965901599,
        "service_name": "sparefoot",
        "span_id": 13298528424334343627,
        "trace_id": 7392586736965901599
    }
}

running: False
schema_name_id: 1329
start_time: 2026-04-07 00:10:51
success: True
trace_id: 7392586736965901599

Scan 6409684

duration: 0:00:12.599856

exit_message:

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

id: 6409684

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_site_content/2026-04-06/1775452033",
        "key": "raw/sparefoot_site_content/2026-04-06/1775452033/site_content_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3982313670022413935,
        "service_name": "sparefoot",
        "span_id": 15557512878067546269,
        "trace_id": 3982313670022413935
    }
}

running: False
schema_name_id: 1329
start_time: 2026-04-06 00:07:17
success: True
trace_id: 3982313670022413935

Scan 6409304

duration: 0:00:12.640888

exit_message:

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

id: 6409304

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_site_content/2026-04-05/1775365694",
        "key": "raw/sparefoot_site_content/2026-04-05/1775365694/site_content_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17881138090794155364,
        "service_name": "sparefoot",
        "span_id": 9630560666211806521,
        "trace_id": 17881138090794155364
    }
}

running: False
schema_name_id: 1329
start_time: 2026-04-05 00:08:17
success: True
trace_id: 17881138090794155364

Scan 6408920

duration: 0:00:15.112246

exit_message:

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

id: 6408920

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_site_content/2026-04-04/1775279279",
        "key": "raw/sparefoot_site_content/2026-04-04/1775279279/site_content_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16117318413038692518,
        "service_name": "sparefoot",
        "span_id": 4361953947221655707,
        "trace_id": 16117318413038692518
    }
}

running: False
schema_name_id: 1329
start_time: 2026-04-04 00:08:03
success: True
trace_id: 16117318413038692518

Scan 6408456

duration: 0:00:12.698226

exit_message:

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

id: 6408456

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_site_content/2026-04-03/1775193161",
        "key": "raw/sparefoot_site_content/2026-04-03/1775193161/site_content_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8643448701892379434,
        "service_name": "sparefoot",
        "span_id": 18343354604627050677,
        "trace_id": 8643448701892379434
    }
}

running: False
schema_name_id: 1329
start_time: 2026-04-03 00:12:47
success: True
trace_id: 8643448701892379434

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

ddl:

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

Server:

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

Raw:

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