Schema Info

Schema Name: sfdl_dev_rds.sparefoot_site_content

created: 2022-03-07 17:05:40
disabled: False
format: raw
id: 1736
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_dev_rds",
    "table": "sparefoot_site_content"
}

type: rds

Schema Versions: 3

Version 4689074

created: 2022-03-16 17:12:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_site_content`\n(\n`facilities`int,`meta_description`string,`created_timestamp`timestamp,`reviews_count`int,`avg_security_rating`decimal(2,1),`image_path`varchar(128),`head_title`varchar(256),`body`string,`avg_service_rating`decimal(2,1),`uri`varchar(128),`movingtruck_url`varchar(64),`title`varchar(256),`meta_keywords`varchar(528),`avg_price_per_sqft`string,`site_id`int,`popular_zip_uri`varchar(128),`updated_timestamp`timestamp,`popular_vehicle_uri`varchar(128),`publish`tinyint,`content_template_id`int,`avg_overall_rating`decimal(2,1),`penske_url`varchar(255),`popular_size_uri`varchar(128),`popular_neighborhood_uri`varchar(128),`subtitle`varchar(256),`popular_university_uri`varchar(128),`avg_10x10_price`string,`popular_amenity_uri`varchar(128),`avg_paperwork_rating`decimal(2,1),`avg_value_rating`decimal(2,1),`avg_price`string,`hireahelper_anchor`varchar(64),`location_id`int,`content_id`int,`avg_cleanliness_rating`decimal(2,1),`hireahelper_url`varchar(64)\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\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/site_content/2022-03-16/1647468673'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_site_content"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/site_content/2022-03-16/1647468673
id: 4689074
processed: 1

raw_data:

{
    "avg_10x10_price": null,
    "avg_cleanliness_rating": null,
    "avg_overall_rating": null,
    "avg_paperwork_rating": null,
    "avg_price": null,
    "avg_price_per_sqft": null,
    "avg_security_rating": null,
    "avg_service_rating": null,
    "avg_value_rating": null,
    "body": "",
    "content_id": 427165,
    "content_template_id": 13,
    "created_timestamp": "2018-12-12 04:03:20",
    "facilities": 1,
    "head_title": "Cheap 24 Hour Access Storage Units in Abbotsford, WI | Compare & Save",
    "hireahelper_anchor": null,
    "hireahelper_url": null,
    "image_path": null,
    "location_id": 208753,
    "meta_description": "Find cheap 24 hour access self storage in Abbotsford, WI. Compare prices, read reviews, and reserve a unit for FREE today.",
    "meta_keywords": "",
    "movingtruck_url": null,
    "penske_url": null,
    "popular_amenity_uri": null,
    "popular_neighborhood_uri": null,
    "popular_size_uri": null,
    "popular_university_uri": null,
    "popular_vehicle_uri": null,
    "popular_zip_uri": null,
    "publish": 1,
    "reviews_count": null,
    "site_id": -1,
    "subtitle": "",
    "title": "",
    "updated_timestamp": "2022-02-20 08:34:33",
    "uri": "Abbotsford-WI-self-storage/24-hour-access"
}

schema_attributes:

{
    "avg_10x10_price": "string",
    "avg_cleanliness_rating": "string",
    "avg_overall_rating": "string",
    "avg_paperwork_rating": "string",
    "avg_price": "string",
    "avg_price_per_sqft": "string",
    "avg_security_rating": "string",
    "avg_service_rating": "string",
    "avg_value_rating": "string",
    "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": "tinyint",
    "reviews_count": "int",
    "site_id": "int",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp",
    "uri": "string"
}

schema_name_id: 1736
schema_scan_id: 5904838
updated: 2022-03-16 17:13:04

Version 4688952

created: 2022-03-15 20:35:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_site_content`\n(\n`facilities`int,`meta_description`string,`created_timestamp`timestamp,`reviews_count`int,`avg_security_rating`decimal(2,1),`image_path`varchar(128),`head_title`varchar(256),`body`string,`avg_service_rating`decimal(2,1),`uri`varchar(128),`movingtruck_url`varchar(64),`title`varchar(256),`meta_keywords`varchar(528),`avg_price_per_sqft`string,`site_id`int,`popular_zip_uri`varchar(128),`updated_timestamp`timestamp,`popular_vehicle_uri`varchar(128),`publish`tinyint,`content_template_id`int,`avg_overall_rating`decimal(2,1),`penske_url`varchar(255),`popular_size_uri`varchar(128),`popular_neighborhood_uri`varchar(128),`subtitle`varchar(256),`popular_university_uri`varchar(128),`avg_10x10_price`string,`popular_amenity_uri`varchar(128),`avg_paperwork_rating`decimal(2,1),`avg_value_rating`decimal(2,1),`avg_price`string,`hireahelper_anchor`varchar(64),`location_id`int,`content_id`int,`avg_cleanliness_rating`decimal(2,1),`hireahelper_url`varchar(64)\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\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/site_content/2022-03-15/1647394486'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_site_content"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/site_content/2022-03-15/1647394486
id: 4688952
processed: 1

raw_data:

{
    "avg_10x10_price": null,
    "avg_cleanliness_rating": null,
    "avg_overall_rating": null,
    "avg_paperwork_rating": null,
    "avg_price": null,
    "avg_price_per_sqft": null,
    "avg_security_rating": null,
    "avg_service_rating": null,
    "avg_value_rating": null,
    "body": "",
    "content_id": 427165,
    "content_template_id": 13,
    "created_timestamp": "2018-12-12 04:03:20",
    "facilities": 1,
    "head_title": "Cheap 24 Hour Access Storage Units in Abbotsford, WI | Compare & Save",
    "hireahelper_anchor": null,
    "hireahelper_url": null,
    "image_path": null,
    "location_id": 208753,
    "meta_description": "Find cheap 24 hour access self storage in Abbotsford, WI. Compare prices, read reviews, and reserve a unit for FREE today.",
    "meta_keywords": "",
    "movingtruck_url": null,
    "penske_url": null,
    "popular_amenity_uri": null,
    "popular_neighborhood_uri": null,
    "popular_size_uri": null,
    "popular_university_uri": null,
    "popular_vehicle_uri": null,
    "popular_zip_uri": null,
    "publish": 1,
    "reviews_count": null,
    "site_id": -1,
    "subtitle": "",
    "title": "",
    "updated_timestamp": "2022-02-20 08:34:33",
    "uri": "Abbotsford-WI-self-storage/24-hour-access"
}

schema_attributes:

{
    "avg_10x10_price": "string",
    "avg_cleanliness_rating": "string",
    "avg_overall_rating": "string",
    "avg_paperwork_rating": "string",
    "avg_price": "string",
    "avg_price_per_sqft": "string",
    "avg_security_rating": "string",
    "avg_service_rating": "string",
    "avg_value_rating": "string",
    "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": "tinyint",
    "reviews_count": "int",
    "site_id": "int",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp",
    "uri": "string"
}

schema_name_id: 1736
schema_scan_id: 5904333
updated: 2022-03-15 20:35:59

Version 4688758

created: 2022-03-07 17:06:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_site_content`\n(\n`content_id`int,`content_template_id`int,`site_id`int,`uri`varchar(128),`head_title`varchar(256),`meta_description`string,`meta_keywords`varchar(528),`title`varchar(256),`subtitle`varchar(256),`body`string,`publish`tinyint,`location_id`int,`hireahelper_url`varchar(64),`hireahelper_anchor`varchar(64),`movingtruck_url`varchar(64),`penske_url`varchar(255),`facilities`int,`avg_price`decimal(11,2),`avg_price_per_sqft`decimal(11,2),`avg_10x10_price`decimal(11,2),`created_timestamp`timestamp,`updated_timestamp`timestamp,`avg_overall_rating`decimal(2,1),`avg_security_rating`decimal(2,1),`avg_paperwork_rating`decimal(2,1),`avg_cleanliness_rating`decimal(2,1),`avg_value_rating`decimal(2,1),`avg_service_rating`decimal(2,1),`reviews_count`int,`popular_amenity_uri`varchar(128),`popular_neighborhood_uri`varchar(128),`popular_size_uri`varchar(128),`popular_university_uri`varchar(128),`popular_vehicle_uri`varchar(128),`popular_zip_uri`varchar(128),`image_path`varchar(128)\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\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/site_content/2022-03-07/1646694314'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_site_content"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/site_content/2022-03-07/1646694314
id: 4688758
processed: 1

raw_data:

{
    "avg_10x10_price": null,
    "avg_cleanliness_rating": null,
    "avg_overall_rating": null,
    "avg_paperwork_rating": null,
    "avg_price": null,
    "avg_price_per_sqft": null,
    "avg_security_rating": null,
    "avg_service_rating": null,
    "avg_value_rating": null,
    "body": "",
    "content_id": 427165,
    "content_template_id": 13,
    "created_timestamp": "2018-12-12 04:03:20",
    "facilities": 1,
    "head_title": "Cheap 24 Hour Access Storage Units in Abbotsford, WI | Compare & Save",
    "hireahelper_anchor": null,
    "hireahelper_url": null,
    "image_path": null,
    "location_id": 208753,
    "meta_description": "Find cheap 24 hour access self storage in Abbotsford, WI. Compare prices, read reviews, and reserve a unit for FREE today.",
    "meta_keywords": "",
    "movingtruck_url": null,
    "penske_url": null,
    "popular_amenity_uri": null,
    "popular_neighborhood_uri": null,
    "popular_size_uri": null,
    "popular_university_uri": null,
    "popular_vehicle_uri": null,
    "popular_zip_uri": null,
    "publish": 1,
    "reviews_count": null,
    "site_id": -1,
    "subtitle": "",
    "title": "",
    "updated_timestamp": "2022-02-20 08:34:33",
    "uri": "Abbotsford-WI-self-storage/24-hour-access"
}

schema_attributes:

{
    "avg_10x10_price": "string",
    "avg_cleanliness_rating": "string",
    "avg_overall_rating": "string",
    "avg_paperwork_rating": "string",
    "avg_price": "string",
    "avg_price_per_sqft": "string",
    "avg_security_rating": "string",
    "avg_service_rating": "string",
    "avg_value_rating": "string",
    "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": "tinyint",
    "reviews_count": "int",
    "site_id": "int",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp",
    "uri": "string"
}

schema_name_id: 1736
schema_scan_id: 5902380
updated: 2022-03-07 17:06:34

Schema Scans: 3

Last at 2022-03-16 17:12:12

Scan 5904838

duration: 0:00:55.162573

exit_message:

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

id: 5904838

payload:

{
    "datatype_dict": {
        "avg_10x10_price": "string",
        "avg_cleanliness_rating": "decimal(2,1)",
        "avg_overall_rating": "decimal(2,1)",
        "avg_paperwork_rating": "decimal(2,1)",
        "avg_price": "string",
        "avg_price_per_sqft": "string",
        "avg_security_rating": "decimal(2,1)",
        "avg_service_rating": "decimal(2,1)",
        "avg_value_rating": "decimal(2,1)",
        "body": "string",
        "content_id": "int",
        "content_template_id": "int",
        "created_timestamp": "timestamp",
        "facilities": "int",
        "force_publish": "tinyint",
        "head_title": "varchar(256)",
        "hireahelper_anchor": "varchar(64)",
        "hireahelper_url": "varchar(64)",
        "image_path": "varchar(128)",
        "location_id": "int",
        "meta_description": "string",
        "meta_keywords": "varchar(528)",
        "movingtruck_url": "varchar(64)",
        "penske_url": "varchar(255)",
        "popular_amenity_uri": "varchar(128)",
        "popular_neighborhood_uri": "varchar(128)",
        "popular_size_uri": "varchar(128)",
        "popular_university_uri": "varchar(128)",
        "popular_vehicle_uri": "varchar(128)",
        "popular_zip_uri": "varchar(128)",
        "publish": "tinyint",
        "reviews_count": "int",
        "site_id": "int",
        "subtitle": "varchar(256)",
        "title": "varchar(256)",
        "updated_timestamp": "timestamp",
        "uri": "varchar(128)"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-dev",
        "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/site_content/2022-03-16/1647468673",
        "key": "raw/site_content/2022-03-16/1647468673/site_content-8.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12113423021334539574,
        "service_name": "sparefoot",
        "span_id": 11123495864132178183,
        "trace_id": 12113423021334539574
    }
}

running: False
schema_name_id: 1736
start_time: 2022-03-16 17:12:12
success: True
trace_id: 12113423021334539574

Scan 5904333

duration: 0:00:53.930220

exit_message:

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

id: 5904333

payload:

{
    "datatype_dict": {
        "avg_10x10_price": "string",
        "avg_cleanliness_rating": "decimal(2,1)",
        "avg_overall_rating": "decimal(2,1)",
        "avg_paperwork_rating": "decimal(2,1)",
        "avg_price": "string",
        "avg_price_per_sqft": "string",
        "avg_security_rating": "decimal(2,1)",
        "avg_service_rating": "decimal(2,1)",
        "avg_value_rating": "decimal(2,1)",
        "body": "string",
        "content_id": "int",
        "content_template_id": "int",
        "created_timestamp": "timestamp",
        "facilities": "int",
        "force_publish": "tinyint",
        "head_title": "varchar(256)",
        "hireahelper_anchor": "varchar(64)",
        "hireahelper_url": "varchar(64)",
        "image_path": "varchar(128)",
        "location_id": "int",
        "meta_description": "string",
        "meta_keywords": "varchar(528)",
        "movingtruck_url": "varchar(64)",
        "penske_url": "varchar(255)",
        "popular_amenity_uri": "varchar(128)",
        "popular_neighborhood_uri": "varchar(128)",
        "popular_size_uri": "varchar(128)",
        "popular_university_uri": "varchar(128)",
        "popular_vehicle_uri": "varchar(128)",
        "popular_zip_uri": "varchar(128)",
        "publish": "tinyint",
        "reviews_count": "int",
        "site_id": "int",
        "subtitle": "varchar(256)",
        "title": "varchar(256)",
        "updated_timestamp": "timestamp",
        "uri": "varchar(128)"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-dev",
        "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/site_content/2022-03-15/1647394486",
        "key": "raw/site_content/2022-03-15/1647394486/data-8.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14431461328745333167,
        "service_name": "sparefoot",
        "span_id": 14175549288838420238,
        "trace_id": 14431461328745333167
    }
}

running: False
schema_name_id: 1736
start_time: 2022-03-15 20:35:08
success: True
trace_id: 14431461328745333167

Scan 5902380

duration: 0:00:56.723422

exit_message:

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

id: 5902380

payload:

{
    "datatype_dict": {
        "avg_10x10_price": "decimal(11,2)",
        "avg_cleanliness_rating": "decimal(2,1)",
        "avg_overall_rating": "decimal(2,1)",
        "avg_paperwork_rating": "decimal(2,1)",
        "avg_price": "decimal(11,2)",
        "avg_price_per_sqft": "decimal(11,2)",
        "avg_security_rating": "decimal(2,1)",
        "avg_service_rating": "decimal(2,1)",
        "avg_value_rating": "decimal(2,1)",
        "body": "string",
        "content_id": "int",
        "content_template_id": "int",
        "created_timestamp": "timestamp",
        "facilities": "int",
        "force_publish": "tinyint",
        "head_title": "varchar(256)",
        "hireahelper_anchor": "varchar(64)",
        "hireahelper_url": "varchar(64)",
        "image_path": "varchar(128)",
        "location_id": "int",
        "meta_description": "string",
        "meta_keywords": "varchar(528)",
        "movingtruck_url": "varchar(64)",
        "penske_url": "varchar(255)",
        "popular_amenity_uri": "varchar(128)",
        "popular_neighborhood_uri": "varchar(128)",
        "popular_size_uri": "varchar(128)",
        "popular_university_uri": "varchar(128)",
        "popular_vehicle_uri": "varchar(128)",
        "popular_zip_uri": "varchar(128)",
        "publish": "tinyint",
        "reviews_count": "int",
        "site_id": "int",
        "subtitle": "varchar(256)",
        "title": "varchar(256)",
        "updated_timestamp": "timestamp",
        "uri": "varchar(128)"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-dev",
        "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/site_content/2022-03-07/1646694314",
        "key": "raw/site_content/2022-03-07/1646694314/data-8.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_site_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 18425923963822678457,
        "service_name": "sparefoot",
        "span_id": 15488617229933169014,
        "trace_id": 18425923963822678457
    }
}

running: False
schema_name_id: 1736
start_time: 2022-03-07 17:05:40
success: True
trace_id: 18425923963822678457

Partitions:

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

Schema:

attributes:

{
    "avg_10x10_price": "string",
    "avg_cleanliness_rating": "string",
    "avg_overall_rating": "string",
    "avg_paperwork_rating": "string",
    "avg_price": "string",
    "avg_price_per_sqft": "string",
    "avg_security_rating": "string",
    "avg_service_rating": "string",
    "avg_value_rating": "string",
    "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": "tinyint",
    "reviews_count": "int",
    "site_id": "int",
    "subtitle": "string",
    "title": "string",
    "updated_timestamp": "timestamp",
    "uri": "string"
}

created: 2022-03-16 17:12:53

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_site_content`\n(\n`facilities`int,`meta_description`string,`created_timestamp`timestamp,`reviews_count`int,`avg_security_rating`decimal(2,1),`image_path`varchar(128),`head_title`varchar(256),`body`string,`avg_service_rating`decimal(2,1),`uri`varchar(128),`movingtruck_url`varchar(64),`title`varchar(256),`meta_keywords`varchar(528),`avg_price_per_sqft`string,`site_id`int,`popular_zip_uri`varchar(128),`updated_timestamp`timestamp,`popular_vehicle_uri`varchar(128),`publish`tinyint,`content_template_id`int,`avg_overall_rating`decimal(2,1),`penske_url`varchar(255),`popular_size_uri`varchar(128),`popular_neighborhood_uri`varchar(128),`subtitle`varchar(256),`popular_university_uri`varchar(128),`avg_10x10_price`string,`popular_amenity_uri`varchar(128),`avg_paperwork_rating`decimal(2,1),`avg_value_rating`decimal(2,1),`avg_price`string,`hireahelper_anchor`varchar(64),`location_id`int,`content_id`int,`avg_cleanliness_rating`decimal(2,1),`hireahelper_url`varchar(64)\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\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/site_content/2022-03-16/1647468673'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_site_content`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_site_content"
}

Server:

hostname: schemamanager-5447774fc6-4w58v
name: schema_manager
process_start: 2026-04-02 21:43:44
sf_env: dev
version: 2427328685

Raw:

{
    "name": {
        "created": "2022-03-07 17:05:40",
        "disabled": false,
        "format": "raw",
        "id": 1736,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_rds",
            "table": "sparefoot_site_content"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "avg_10x10_price": "string",
            "avg_cleanliness_rating": "string",
            "avg_overall_rating": "string",
            "avg_paperwork_rating": "string",
            "avg_price": "string",
            "avg_price_per_sqft": "string",
            "avg_security_rating": "string",
            "avg_service_rating": "string",
            "avg_value_rating": "string",
            "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": "tinyint",
            "reviews_count": "int",
            "site_id": "int",
            "subtitle": "string",
            "title": "string",
            "updated_timestamp": "timestamp",
            "uri": "string"
        },
        "created": "2022-03-16 17:12:53",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_site_content`\n(\n`facilities`int,`meta_description`string,`created_timestamp`timestamp,`reviews_count`int,`avg_security_rating`decimal(2,1),`image_path`varchar(128),`head_title`varchar(256),`body`string,`avg_service_rating`decimal(2,1),`uri`varchar(128),`movingtruck_url`varchar(64),`title`varchar(256),`meta_keywords`varchar(528),`avg_price_per_sqft`string,`site_id`int,`popular_zip_uri`varchar(128),`updated_timestamp`timestamp,`popular_vehicle_uri`varchar(128),`publish`tinyint,`content_template_id`int,`avg_overall_rating`decimal(2,1),`penske_url`varchar(255),`popular_size_uri`varchar(128),`popular_neighborhood_uri`varchar(128),`subtitle`varchar(256),`popular_university_uri`varchar(128),`avg_10x10_price`string,`popular_amenity_uri`varchar(128),`avg_paperwork_rating`decimal(2,1),`avg_value_rating`decimal(2,1),`avg_price`string,`hireahelper_anchor`varchar(64),`location_id`int,`content_id`int,`avg_cleanliness_rating`decimal(2,1),`hireahelper_url`varchar(64)\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\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/site_content/2022-03-16/1647468673'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_site_content`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_site_content"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}