Schema Info
Schema Name: sfdl_dev_rds.sparefoot_sparefoot_site_content
- created: 2022-08-11 14:51:57
- disabled: False
- format: raw
- id: 1938
- is_partitioned: False
- is_schema_datatyped: False
- name:
{ "database": "sfdl_dev_rds", "table": "sparefoot_sparefoot_site_content" } - type: rds
Schema Versions: 3
-
Version 4761399
- created: 2025-07-02 15:19:04
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`", "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_sparefoot_site_content`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/sparefoot_site_content/2025-07-02/1751487540'\n", "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_sparefoot_site_content" ] - hive_path: s3://sfdl-rds-sparefoot-dev/raw/sparefoot_site_content/2025-07-02/1751487540
- id: 4761399
- 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: 1938
- schema_scan_id: 6814357
- updated: 2025-07-02 15:19:18
-
Version 4708677
- created: 2024-08-14 08:53:15
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`", "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_sparefoot_site_content`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/sparefoot_site_content/2024-08-14/1723643585'\n", "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_sparefoot_site_content" ] - hive_path: s3://sfdl-rds-sparefoot-dev/raw/sparefoot_site_content/2024-08-14/1723643585
- id: 4708677
- 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: 1938
- schema_scan_id: 6564693
- updated: 2024-08-14 08:53:26
-
Version 4705836
- created: 2024-05-14 02:48:37
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`", "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_sparefoot_site_content`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/sparefoot_site_content/2024-05-14/1715672902'\n", "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_sparefoot_site_content" ] - hive_path: s3://sfdl-rds-sparefoot-dev/raw/sparefoot_site_content/2024-05-14/1715672902
- id: 4705836
- 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: 1938
- schema_scan_id: 6490515
- updated: 2024-05-14 02:48:51
Schema Scans: 3
Last at 2025-07-02 15:19:03
-
Scan 6814357
- duration: 0:00:14.975236
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6814357
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-dev", "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/sparefoot_site_content/2025-07-02/1751487540", "key": "raw/sparefoot_site_content/2025-07-02/1751487540/site_content_1.parquet.gz" }, "schema": { "name": "sfdl_dev_rds.sparefoot_sparefoot_site_content", "type": "rds" }, "trace_context": { "parent_id": 12071043578122252890, "service_name": "sparefoot", "span_id": 17797321554111550912, "trace_id": 12071043578122252890 } } - running: False
- schema_name_id: 1938
- start_time: 2025-07-02 15:19:03
- success: True
- trace_id: 12071043578122252890
-
Scan 6564693
- duration: 0:00:12.447251
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6564693
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-dev", "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/sparefoot_site_content/2024-08-14/1723643585", "key": "raw/sparefoot_site_content/2024-08-14/1723643585/site_content_1.parquet.gz" }, "schema": { "name": "sfdl_dev_rds.sparefoot_sparefoot_site_content", "type": "rds" }, "trace_context": { "parent_id": 9442242888560222847, "service_name": "sparefoot", "span_id": 1833598878304003899, "trace_id": 9442242888560222847 } } - running: False
- schema_name_id: 1938
- start_time: 2024-08-14 08:53:13
- success: True
- trace_id: 9442242888560222847
-
Scan 6490515
- duration: 0:00:15.175440
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6490515
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-dev", "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/sparefoot_site_content/2024-05-14/1715672902", "key": "raw/sparefoot_site_content/2024-05-14/1715672902/site_content_1.parquet.gz" }, "schema": { "name": "sfdl_dev_rds.sparefoot_sparefoot_site_content", "type": "rds" }, "trace_context": { "parent_id": 253267884164387909, "service_name": "sparefoot", "span_id": 14030374330408354544, "trace_id": 253267884164387909 } } - running: False
- schema_name_id: 1938
- start_time: 2024-05-14 02:48:36
- success: True
- trace_id: 253267884164387909
- 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: 2025-07-02 15:19:04
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/sparefoot_site_content/2025-07-02/1751487540'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_sparefoot_site_content`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_sparefoot_site_content" }
- hostname: schemamanager-5447774fc6-4w58v
- name: schema_manager
- process_start: 2026-04-02 21:43:44
- sf_env: dev
- version: 2427328685
{
"name": {
"created": "2022-08-11 14:51:57",
"disabled": false,
"format": "raw",
"id": 1938,
"is_partitioned": false,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_dev_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": "2025-07-02 15:19:04",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/sparefoot_site_content/2025-07-02/1751487540'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_sparefoot_site_content`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_sparefoot_site_content"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}