Schema Info
Schema Name: sfdl_dev_segment.reactfoot_facility_impression
- created: 2018-11-30 14:59:50
- disabled: False
- format: raw
- id: 1110
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_dev_segment", "table": "reactfoot_facility_impression" } - type: segment
Schema Versions: 4
-
Version 4663089
- created: 2018-12-04 15:16:08
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_facility_impression`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_facility_impression`\n(\n `version` string , `timestamp` string , `messageId` string , `userId` string , `event` string , `receivedAt` string ,`_metadata` struct< `bundled`:array, `unbundled`:array >, `anonymousId` string , `originalTimestamp` string ,`context` struct< `userAgent` : string ,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >,`library` : struct< `version` : string , `name` : string >, `ip` : string >, `projectId` string , `_origin` string , `type` string ,`properties` struct< `category` : string , `index` : string , `Hit_Timestamp` : string , `in_network` : string , `isReact` : string , `site_id` : string , `rank` : string , `label` : string , `facility_id` : string , `env` : string , `visible_threshold` : string ,`search_id` : struct< `searchId` : string , `canonicalURL` : string , `irmMarket` : string , `facilitiesPerPage` : string , `penskeResults` : string ,`landingLocation` : struct< `city` : string , `zip` : string , `country` : string , `fullState` : string , `state` : string , `longitude` : string , `subPageType` : string , `streetAddress` : string , `text` : string , `latitude` : string , `id` : string , `subLocality` : string >, `fssResults` : string , `facilities`:array ,`meta` : struct< `noindex` : string , `description` : string , `title` : string , `logo` : string ,`geo` : struct< `placeName` : string , `region` : string , `icbm` : string , `position` : string >, `canonical` : string >,`filters` : struct< `sqftRange` : string >,`seo` : struct< `canonical` : string >,`query` : struct< `distance` : string , `truckRental` : string , `namespace` : string , `variation` : string , `location` : string , `listingsPerPage` : string >,`headlines` : struct< `primary` : string , `secondary` : string >, `loading` : string ,`facets` : struct< `penske` : string , `outdoor` : string , `indoor` : string , `aaaActive` : string , `twentyFourHourAccess` : string , `seniorDiscount` : string ,`prefilterTypes` : struct< `warehouseValet` : string , `storage` : string , `warehouseDropoff` : string , `vehicle` : string >, `truckAccess` : string , `handcarts` : string , `uncovered` : string ,`typeOfListing` : struct< `2` : string , `4` : string >, `fencedLighted` : string , `floor` : string , `elevator` : string , `surveillance` : string , `vehicle` : string , `outOfNetworkStoreTrac` : string , `aaaEligile` : string ,`prefilterTypeCounts` : struct< `2` : string , `4` : string >, `power` : string , `kiosk` : string , `climateControlled` : string , `covered` : string , `militaryDiscount` : string , `bandPracticeAllowed` : string , `studentDiscount` : string , `truckRental` : string , `egateAccess` : string , `alarm` : string , `driveUp` : string , `amexActive` : string , `outOfNetworkOgf` : string , `directoryFacility` : string , `freeTruckRental` : string >, `searchType` : string ,`localPhone` : struct< `localSparephone` : string , `nationalSparephone` : string , `nationalSparephoneUnformatted` : string , `localSparephoneUnformatted` : string >, `staticMapUrl` : string ,`content` : struct< `contentTemplateId` : string , `pricingStats` : string , `contentId` : string , `nearbyCities`:array ,`drillDownLinks` : struct< `universities`:array , `amenities`:array , `vehicleStorage`:array >, `movingGuidePosts`:array , `cityTotalBookings` : string , `popularSqft` : string , `formattedStorageType` : string , `blogPosts`:array >, `isTabbed` : string ,`location` : struct< `city` : string , `zip` : string , `country` : string , `fullState` : string , `state` : string , `longitude` : string , `subPageType` : string , `streetAddress` : string , `text` : string , `latitude` : string , `id` : string , `subLocality` : string >,`searchParams` : struct< `distance` : string , `expandIfLessThan` : string , `truckRental` : string , `searchType` : string , `searchType__` : string , `sqft` : string , `moveInDate` : string , `variation` : string , `page` : string , `siteId` : string , `location` : string , `ip` : string , `namespace` : string , `maxDistance` : string , `order` : string , `listingsPerPage` : string , `visitId` : string >, `errorMessage` : string , `totalUnits` : string , `highlightedFacility` : string , `fssResultsURL` : string , `penskeResultsURL` : string , `truckResultsURL` : string , `oonFacilities`:array ,`phone` : struct< `nationalSparephoneUnformatted` : string , `nationalSparephone` : string >, `penskeURL` : string , `pageType` : string , `landingFacilities`:array , `maxDistance` : string , `numPages` : string , `truckResults` : string , `algorithm` : string ,`facilityCollection` : struct< `reviewCount` : string , `totalFacilityCount` : string , `totalFacilityIds`:array , `collection`:array , `totalUnitCount` : string , `fullServiceCorpIds`:array >,`url` : struct< `city` : string , `state` : string , `fssLanding` : string >, `bellhopsURL` : string , `totalFacilities` : string , `isBellhopsMarket` : string , `todaysDate` : string ,`experiments` : struct< `sf_6852_serp_results` : string , `red_716_tracking_prerender` : string , `sf_5635_half_nomad` : string , `sf_7046_recommended_facility_badge` : string , `sf_4830_aa_phlag_band_aid` : string , `sf_7018_upsellit` : string , `sf_7058_two_step_checkout_v2` : string >, `error` : string , `fssFaqs`:array , `page` : string >>, `channel` string , `sentAt` string \n)\nPARTITIONED BY (dt string)\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-segment-reactfoot-dev/separated_dt/facility_impression'\n", "MSCK REPAIR TABLE sfdl_dev_segment.reactfoot_facility_impression" ] - hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/facility_impression
- id: 4663089
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "unbundled": [] }, "_origin": "2018-12-04T21:16:00Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1543881600000/1543958083678.34a3c25229a4.1.11.1.a5235e70-146e-4b78-9be8-3344af113fd9.gz|segment_separator:34", "anonymousId": "d9f96e36-589a-4ca1-8d52-b6cf69083d96", "channel": "client", "context": { "ip": "34.239.223.223", "library": { "name": "analytics.js", "version": "3.7.2" }, "page": { "path": "/moving-truck-rental.html", "referrer": "", "search": "", "title": "Find A Moving Truck Near You | SpareFoot", "url": "http://localhost:9000/moving-truck-rental.html" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.110 Safari/537.36" }, "event": "facility_impression", "integrations": {}, "messageId": "ajs-d3403fc7b8fd5acb01a5c07afa773266", "originalTimestamp": "2018-12-04T21:02:29.483Z", "projectId": "iHhi46PCMy", "properties": { "Hit Timestamp": 1543957349483, "category": "storage with moving trucks near you-movingTruckLandingPage", "env": "development", "facility_id": 194245, "in_network": true, "index": 3, "isReact": true, "label": "facility card", "rank": 3, "search_id": { "algorithm": "Centaur\\Algorithm\\NonVectorFloorsDonut", "bellhopsURL": "https://www.getbellhops.com/market/austin-texas/?utm_partner=sparefoot&utm_invoca=sparefoot1&promo_coupon_code=sparefoot5&contentPass=true&ip=207.71.19.142&continentCode=NA&countryCode=US&countryCode3=US&countryName=United%20States&country=United%20States&city=Austin&postalCode=78701&latitude=30.2678&longitude=-97.7426&details%5Bcountry%5D%5Bnames%5D%5Ben%5D=United%20States&location=30.2678%2C%20-97.7426", "canonicalURL": "/moving-truck-rental.html", "content": { "blogPosts": [], "cityTotalBookings": null, "contentId": null, "contentTemplateId": "", "drillDownLinks": { "amenities": [], "universities": [], "vehicleStorage": [] }, "formattedStorageType": "self-storage", "movingGuidePosts": [], "nearbyCities": [], "popularSqft": null, "pricingStats": null, "weather": {} }, "error": false, "errorMessage": null, "experiments": { "red_716_tracking_prerender": "control", "sf_4830_aa_phlag_band_aid": "variation", "sf_5635_half_nomad": "control", "sf_6852_serp_results": "variation1", "sf_7018_upsellit": "variation", "sf_7046_recommended_facility_badge": "control", "sf_7058_two_step_checkout_v2": "control" }, "facets": { "aaaActive": 19, "aaaEligile": 0, "alarm": 70, "amexActive": 0, "bandPracticeAllowed": 36, "climateControlled": 390, "covered": 0, "directoryFacility": 0, "driveUp": 258, "egateAccess": 374, "elevator": 167, "fencedLighted": 378, "floor": 407, "freeTruckRental": 186, "handcarts": 178, "indoor": 0, "kiosk": 0, "militaryDiscount": 213, "outOfNetworkOgf": 1, "outOfNetworkStoreTrac": 0, "outdoor": 0, "penske": 14, "power": 0, "prefilterTypeCounts": { "2": 1867, "4": 5 }, "prefilterTypes": { "storage": true, "vehicle": true, "warehouseDropoff": false, "warehouseValet": true }, "seniorDiscount": 52, "studentDiscount": 8, "surveillance": 404, "truckAccess": 60, "truckRental": 408, "twentyFourHourAccess": 123, "typeOfListing": { "2": 408, "4": 0 }, "uncovered": 0, "vehicle": 186 }, "facilities": [ 154077, 50712, 194245 ], "facilitiesPerPage": 3, "facilityCollection": { "collection": [ { "account": { "cpaPercentRolloutBetaState": "weak", "earliestReservationDay": 0, "id": 16, "minBid": "1.2", "minimumRentalPeriod": "3 month", "minimumRentalPeriodAmount": 3, "newMinBid": "1.2", "tosUrl": "/legal/consumer" }, "cheapestPrice": { "text": "53.10", "value": 53.1 }, "closures": [], "corporation": { "id": 1760, "sourceId": 17, "type": "self-storage" }, "description": "CubeSmart Self Storage is committed to providing our customers with excellent products, facilities, and customer service. Our customers enjoy many perks including moving services, packing & shipping supplies, storage customization, and business services - along with the best discounts in the industry!", "distance": 2.3, "fees": { "admin": { "text": "$24.00", "value": 24 } }, "hours": { "access": { "text": {} }, "office": { "meta": "", "text": {} } }, "id": 154077, "imageDetails": [], "images": [ "15407759d28c429aae0.jpg", "15407759d28c4348685.jpg", "15407759d28c443bdc7.jpg", "15407759d28c44cce5f.jpg", "15407759d28c45b7360.jpg", "15407759d28c4656752.jpg", "15407759d28c4736364.jpg", "15407759d28c47bf276.jpg", "15407759d28c4870605.jpg", "15407759d28c48f3fdb.jpg", "15407759d28c49b0841.jpg" ], "inNetwork": true, "irmFacility": false, "irmMarket": "ATX", "isActive": true, "isFullServiceStandalone": false, "isOutOfNetwork": false, "isSelfStorage": true, "location": { "city": "Austin", "country": "US", "fullState": "Texas", "id": "23899528", "latitude": 30.238897, "longitude": -97.72587, "state": "TX", "streetAddress": "2220 E Riverside Dr", "streetView": null, "subLocality": "", "text": "2220 E Riverside Dr Austin, TX 78741", "zip": "78741" }, "messaging": { "amexActive": false, "freeTruckRental": false, "isAaaEligible": false, "isOpenNow": true, "isOpenOnMoveIn": true, "isOpenOrWillBe": false, "isUrgent": true, "penskeRental": true, "truckRental": true }, "name": "CubeSmart Self Storage - Austin - 2220 E Riverside Dr", "phone": "(512) 326-3188", "phoneUnformatted": "5123263188", "promotion": "", "recommendedUnit": { "amenitiesList": "Interior, Upstairs (Access via Elevator)", "facilityId": 154077, "height": 0, "id": 20758418, "isAvailableToBook": true, "length": 10, "maxBookingDate": { "day": 19, "dayOfWeek": 3, "dayOfWeekText": "Wednesday", "format": { "human": { "date": "December 19th, 2018", "time": "13:42 PM" }, "iso": "2018-12-19T13:42:58.000Z", "mdy": "12-19-2018", "timestamp": 1545226978, "ymd": "2018-12-19T00:00:00.000Z" }, "hour": 13, "isValidDate": true, "isValidTime": true, "minute": 42, "month": 11, "monthText": "December", "second": 58, "utcOffset": "+0000", "year": 2018 }, "price": { "text": "63.00", "value": 63 }, "promotion": "10% Off and Half Off First Month", "quantity": null, "regularPrice": { "text": "70.00", "value": 70 }, "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit", "url": "/Austin-TX-self-storage/CubeSmart-Self-Storage-Austin-2220-E-Riverside-Dr-154077/reserve/20758418", "vehicleAccommodation": null, "width": 5 }, "reviews": { "average": 4.176, "count": 17 }, "seoLocation": { "city": "Austin", "fullState": "Texas", "state": "TX" }, "serviceArea": null, "showLocalPhones": true, "staticMapUrl": "https://maps.googleapis.com/maps/api/staticmap?center=30.238897%2C-97.72587&scale=1&zoom=14&size=620x300&markers=color%3Ared%7C30.238897%2C-97.72587&format=jpg&key=AIzaSyCa5Sq1pRwayGsrOcZPcdQD2EFXGzWM3Nk&signature=1cJ0rZM-qj9AxcQlF4-GCHea0fI=", "staticMapUrlLarge": "https://maps.googleapis.com/maps/api/staticmap?center=30.238897%2C-97.72587&scale=2&zoom=14&size=640x240&markers=color%3Ared%7C30.238897%2C-97.72587&format=jpg&key=AIzaSyCa5Sq1pRwayGsrOcZPcdQD2EFXGzWM3Nk&signature=jfyxfY7pyq9tXMtCxINIOGU8P30=", "tos": "No obligation to rent. Leasing this space is month-to-month, with no long term commitment. By clicking to reserve this unit, you agree to our Terms of Service.", "unitCount": 14, "units": [ { "amenitiesList": "Interior, Upstairs (Access via Elevator)", "facilityId": 154077, "height": 0, "id": 20764939, "isAvailableToBook": true, "length": 5, "maxBookingDate": { "day": 19, "dayOfWeek": 3, "dayOfWeekText": "Wednesday", "format": { "human": { "date": "December 19th, 2018", "time": "13:42 PM" }, "iso": "2018-12-19T13:42:58.000Z", "mdy": "12-19-2018", "timestamp": 1545226978, "ymd": "2018-12-19T00:00:00.000Z" }, "hour": 13, "isValidDate": true, "isValidTime": true, "minute": 42, "month": 11, "monthText": "December", "second": 58, "utcOffset": "+0000", "year": 2018 }, "price": { "text": "53.10", "value": 53.1 }, "promotion": "10% Off and First Month Free", "quantity": null, "regularPrice": { "text": "59.00", "value": 59 }, "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit", "url": "/Austin-TX-self-storage/CubeSmart-Self-Storage-Austin-2220-E-Riverside-Dr-154077/reserve/20764939", "vehicleAccommodation": null, "width": 5 }, { "amenitiesList": "Interior, Upstairs (Access via Elevator)", "facilityId": 154077, "height": 0, "id": 20758418, "isAvailableToBook": true, "length": 10, "maxBookingDate": { "day": 19, "dayOfWeek": 3, "dayOfWeekText": "Wednesday", "format": { "human": { "date": "December 19th, 2018", "time": "13:42 PM" }, "iso": "2018-12-19T13:42:58.000Z", "mdy": "12-19-2018", "timestamp": 1545226978, "ymd": "2018-12-19T00:00:00.000Z" }, "hour": 13, "isValidDate": true, "isValidTime": true, "minute": 42, "month": 11, "monthText": "December", "second": 58, "utcOffset": "+0000", "year": 2018 }, "price": { "text": "63.00", "value": 63 }, "promotion": "10% Off and Half Off First Month", "quantity": null, "regularPrice": { "text": "70.00", "value": 70 }, "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit", "url": "/Austin-TX-self-storage/CubeSmart-Self-Storage-Austin-2220-E-Riverside-Dr-154077/reserve/20758418", "vehicleAccommodation": null, "width": 5 }, { "amenitiesList": "Interior, Upstairs (Access via Elevator)", "facilityId": 154077, "height": 0, "id": 20758421, "isAvailableToBook": true, "length": 10, "maxBookingDate": { "day": 19, "dayOfWeek": 3, "dayOfWeekText": "Wednesday", "format": { "human": { "date": "December 19th, 2018", "time": "13:42 PM" }, "iso": "2018-12-19T13:42:58.000Z", "mdy": "12-19-2018", "timestamp": 1545226978, "ymd": "2018-12-19T00:00:00.000Z" }, "hour": 13, "isValidDate": true, "isValidTime": true, "minute": 42, "month": 11, "monthText": "December", "second": 58, "utcOffset": "+0000", "year": 2018 }, "price": { "text": "98.10", "value": 98.1 }, "promotion": "10% Off and Half Off First Month", "quantity": null, "regularPrice": { "text": "109.00", "value": 109 }, "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit", "url": "/Austin-TX-self-storage/CubeSmart-Self-Storage-Austin-2220-E-Riverside-Dr-154077/reserve/20758421", "vehicleAccommodation": null, "width": 10 } ], "url": { "city": "/Austin-TX-self-storage", "facility": "/Austin-TX-self-storage/CubeSmart-Self-Storage-Austin-2220-E-Riverside-Dr-154077.html", "state": "/texas-storage", "website": "" }, "vehicleRestrictions": { "insurance": { "label": "Insurance", "required": "yes" }, "registration": { "label": "Registration", "required": "yes" }, "running": { "label": "Vehicle is drivable", "required": "yes" }, "title": { "label": "Title", "required": "yes" } }, "website": "" }, { "account": { "cpaPercentRolloutBetaState": "weak", "earliestReservationDay": 0, "id": 351, "minBid": "1.25", "minimumRentalPeriod": "3 month", "minimumRentalPeriodAmount": 3, "newMinBid": "1.25", "tosUrl": "/legal/consumer" }, "cheapestPrice": { "text": "50.00", "value": 50 }, "closures": [], "corporation": { "id": 351, "sourceId": 11, "type": "self-storage" }, "description": "Life Storage offers a wide selection of storage units with a choice of both traditional and premium storage environments.", "distance": 5.4, "fees": { "admin": { "text": "$25.00", "value": 25 } }, "hours": { "access": { "text": {} }, "office": { "meta": "", "text": {} } }, "id": 50712, "imageDetails": [], "images": [ "507125956842c5a053.jpg", "507125881ae96adafd.jpg", "507125913f9a4406f8.jpg", "507125913f9a789686.jpg", "507125956842f6c8cc.jpg", "507125af3193c67816.jpg", "507125af3193d326b5.jpg", "507125b01078708b81.jpg", "507125bb4543c099ef.jpg" ], "inNetwork": true, "irmFacility": false, "irmMarket": "ATX", "isActive": true, "isFullServiceStandalone": false, "isOutOfNetwork": false, "isSelfStorage": true, "location": { "city": "Austin", "country": "US", "fullState": "Texas", "id": "23899528", "latitude": 30.198906, "longitude": -97.7865, "state": "TX", "streetAddress": "6509 S 1st St", "streetView": null, "subLocality": "", "text": "6509 S 1st St Austin, TX 78745", "zip": "78745" }, "messaging": { "amexActive": false, "freeTruckRental": true, "isAaaEligible": false, "isOpenNow": true, "isOpenOnMoveIn": true, "isOpenOrWillBe": false, "isUrgent": true, "penskeRental": false, "truckRental": true }, "name": "Life Storage - Austin - South 1st Street", "phone": "(512) 326-3131", "phoneUnformatted": "5123263131", "promotion": "", "recommendedUnit": { "amenitiesList": "1st Floor, 9' Ceiling, Interior, Roll Up Door", "facilityId": 50712, "height": 9, "id": 777891, "isAvailableToBook": true, "length": 10, "maxBookingDate": { "day": 10, "dayOfWeek": 1, "dayOfWeekText": "Monday", "format": { "human": { "date": "December 10th, 2018", "time": "13:50 PM" }, "iso": "2018-12-10T13:50:10.000Z", "mdy": "12-10-2018", "timestamp": 1544449810, "ymd": "2018-12-10T00:00:00.000Z" }, "hour": 13, "isValidDate": true, "isValidTime": true, "minute": 50, "month": 11, "monthText": "December", "second": 10, "utcOffset": "+0000", "year": 2018 }, "price": { "text": "51.00", "value": 51 }, "promotion": "Pay the remaining days this month, next month Free!", "quantity": 4, "regularPrice": { "text": "57.00", "value": 57 }, "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit", "url": "/Austin-TX-self-storage/Life-Storage-Austin-South-1st-Street-50712/reserve/777891", "vehicleAccommodation": null, "width": 5 }, "reviews": { "average": 4.514, "count": 37 }, "seoLocation": { "city": "Austin", "fullState": "Texas", "state": "TX" }, "serviceArea": null, "showLocalPhones": true, "staticMapUrl": "https://maps.googleapis.com/maps/api/staticmap?center=30.198906%2C-97.7865&scale=1&zoom=14&size=620x300&markers=color%3Ared%7C30.198906%2C-97.7865&format=jpg&key=AIzaSyCa5Sq1pRwayGsrOcZPcdQD2EFXGzWM3Nk&signature=VxSn3k0_0bjulEhySQst3wOIgGs=", "staticMapUrlLarge": "https://maps.googleapis.com/maps/api/staticmap?center=30.198906%2C-97.7865&scale=2&zoom=14&size=640x240&markers=color%3Ared%7C30.198906%2C-97.7865&format=jpg&key=AIzaSyCa5Sq1pRwayGsrOcZPcdQD2EFXGzWM3Nk&signature=VD-xtGj4SIWS_OM6Zfpqze8fZ5M=", "tos": "No obligation to rent. Leasing this space is month-to-month, with no long term commitment. By clicking to reserve this unit, you agree to our Terms of Service.", "unitCount": 49, "units": [ { "amenitiesList": "1st Floor, 9' Ceiling, Climate Controlled, Interior, Roll Up Door", "facilityId": 50712, "height": 9, "id": 786007, "isAvailableToBook": true, "length": 5, "maxBookingDate": { "day": 8, "dayOfWeek": 6, "dayOfWeekText": "Saturday", "format": { "human": { "date": "December 8th, 2018", "time": "13:50 PM" }, "iso": "2018-12-08T13:50:10.000Z", "mdy": "12-08-2018", "timestamp": 1544277010, "ymd": "2018-12-08T00:00:00.000Z" }, "hour": 13, "isValidDate": true, "isValidTime": true, "minute": 50, "month": 11, "monthText": "December", "second": 10, "utcOffset": "+0000", "year": 2018 }, "price": { "text": "52.00", "value": 52 }, "promotion": "Pay the remaining days this month, next month Free!", "quantity": 2, "regularPrice": { "text": "58.00", "value": 58 }, "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit", "url": "/Austin-TX-self-storage/Life-Storage-Austin-South-1st-Street-50712/reserve/786007", "vehicleAccommodation": null, "width": 5 }, { "amenitiesList": "1st Floor, 9' Ceiling, Interior, Roll Up Door", "facilityId": 50712, "height": 9, "id": 777891, "isAvailableToBook": true, "length": 10, "maxBookingDate": { "day": 10, "dayOfWeek": 1, "dayOfWeekText": "Monday", "format": { "human": { "date": "December 10th, 2018", "time": "13:50 PM" }, "iso": "2018-12-10T13:50:10.000Z", "mdy": "12-10-2018", "timestamp": 1544449810, "ymd": "2018-12-10T00:00:00.000Z" }, "hour": 13, "isValidDate": true, "isValidTime": true, "minute": 50, "month": 11, "monthText": "December", "second": 10, "utcOffset": "+0000", "year": 2018 }, "price": { "text": "51.00", "value": 51 }, "promotion": "Pay the remaining days this month, next month Free!", "quantity": 4, "regularPrice": { "text": "57.00", "value": 57 }, "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit", "url": "/Austin-TX-self-storage/Life-Storage-Austin-South-1st-Street-50712/reserve/777891", "vehicleAccommodation": null, "width": 5 }, { "amenitiesList": "9' Ceiling, Drive Up Access, Roll Up Door", "facilityId": 50712, "height": 9, "id": 777894, "isAvailableToBook": true, "length": 15, "maxBookingDate": { "day": 8, "dayOfWeek": 6, "dayOfWeekText": "Saturday", "format": { "human": { "date": "December 8th, 2018", "time": "13:50 PM" }, "iso": "2018-12-08T13:50:10.000Z", "mdy": "12-08-2018", "timestamp": 1544277010, "ymd": "2018-12-08T00:00:00.000Z" }, "hour": 13, "isValidDate": true, "isValidTime": true, "minute": 50, "month": 11, "monthText": "December", "second": 10, "utcOffset": "+0000", "year": 2018 }, "price": { "text": "50.00", "value": 50 }, "promotion": "Pay the remaining days this month, next month 50% off!", "quantity": 3, "regularPrice": { "text": "56.00", "value": 56 }, "sizeText": "5' x 15'", "squareFootage": 75, "unitTypeText": "unit", "url": "/Austin-TX-self-storage/Life-Storage-Austin-South-1st-Street-50712/reserve/777894", "vehicleAccommodation": null, "width": 5 } ], "url": { "city": "/Austin-TX-self-storage", "facility": "/Austin-TX-self-storage/Life-Storage-Austin-South-1st-Street-50712.html", "state": "/texas-storage", "website": "" }, "vehicleRestrictions": { "insurance": { "label": "Insurance", "required": "yes" }, "registration": { "label": "Registration", "required": "yes" }, "running": { "label": "Vehicle is drivable", "required": "yes" }, "title": { "label": "Title", "required": "yes" } }, "website": "" }, { "account": { "earliestReservationDay": 0, "id": 6838, "minimumRentalPeriod": "3 month", "minimumRentalPeriodAmount": 3, "newMinBid": "1.5", "tosUrl": "/legal/consumer" }, "cheapestPrice": { "text": "40.00", "value": 40 }, "closures": [], "corporation": { "id": 7574, "sourceId": 7, "type": "self-storage" }, "description": "Ben White Self Storage in Austin offers a wide selection of convenient storage units, including climate controlled options. The facility is fully secured through the use of video cameras and electronic gated access. We also have a resident manager that lives on site to assist with all of your storage needs. Our non climate drive up units can be accessed easily with up to a 26 foot trucks. All vehicles including, cars, RVs, trucks, boats, etc. must be in running condition and must be up to date with licensing and registration to be stored at this facility.", "distance": 3.7, "fees": { "admin": { "text": "$20.00", "value": 20 } }, "hours": { "access": { "text": {} }, "office": { "meta": "", "text": {} } }, "id": 194245, "imageDetails": [], "images": [ "1942455602fcdbd64b9.png", "1942455602fcdd5e6ce.png", "1942455602fcdebfb8c.png" ], "inNetwork": true, "irmFacility": false, "irmMarket": "ATX", "isActive": true, "isFullServiceStandalone": false, "isOutOfNetwork": false, "isSelfStorage": true, "location": { "city": "Austin", "country": "US", "fullState": "Texas", "id": "23899528", "latitude": 30.21511, "longitude": -97.741066, "state": "TX", "streetAddress": "2229 East Ben White Boulevard", "streetView": null, "subLocality": "", "text": "2229 East Ben White Boulevard Austin, TX 78741", "zip": "78741" }, "messaging": { "amexActive": false, "freeTruckRental": false, "isAaaEligible": false, "isOpenNow": true, "isOpenOnMoveIn": true, "isOpenOrWillBe": false, "isUrgent": false, "penskeRental": false, "truckRental": true }, "name": "StorWise Ben White", "phone": "(512) 443-5858", "phoneUnformatted": "5124435858", "promotion": "", "recommendedUnit": { "amenitiesList": "1st Floor, Outdoor Access", "facilityId": 194245, "height": 0, "id": 17762899, "isAvailableToBook": true, "length": 10, "maxBookingDate": { "day": 11, "dayOfWeek": 2, "dayOfWeekText": "Tuesday", "format": { "human": { "date": "December 11th, 2018", "time": "13:40 PM" }, "iso": "2018-12-11T13:40:19.000Z", "mdy": "12-11-2018", "timestamp": 1544535619, "ymd": "2018-12-11T00:00:00.000Z" }, "hour": 13, "isValidDate": true, "isValidTime": true, "minute": 40, "month": 11, "monthText": "December", "second": 19, "utcOffset": "+0000", "year": 2018 }, "price": { "text": "69.00", "value": 69 }, "promotion": "Call for specials!", "quantity": 1, "regularPrice": { "text": "69.00", "value": 69 }, "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit", "url": "/Austin-TX-self-storage/StorWise-Ben-White-194245/reserve/17762899", "vehicleAccommodation": null, "width": 5 }, "reviews": { "average": 4.75, "count": 2 }, "seoLocation": { "city": "Austin", "fullState": "Texas", "state": "TX" }, "serviceArea": null, "showLocalPhones": true, "staticMapUrl": "https://maps.googleapis.com/maps/api/staticmap?center=30.21511%2C-97.741066&scale=1&zoom=14&size=620x300&markers=color%3Ared%7C30.21511%2C-97.741066&format=jpg&key=AIzaSyCa5Sq1pRwayGsrOcZPcdQD2EFXGzWM3Nk&signature=AyQkEy51gIfMfordvTQOKQVFGtY=", "staticMapUrlLarge": "https://maps.googleapis.com/maps/api/staticmap?center=30.21511%2C-97.741066&scale=2&zoom=14&size=640x240&markers=color%3Ared%7C30.21511%2C-97.741066&format=jpg&key=AIzaSyCa5Sq1pRwayGsrOcZPcdQD2EFXGzWM3Nk&signature=afZNw57HDE_Dn7REA2hD9uVvTI0=", "tos": "No obligation to rent. Leasing this space is month-to-month, with no long term commitment. By clicking to reserve this unit, you agree to our Terms of Service.", "unitCount": 11, "units": [ { "amenitiesList": "1st Floor, Interior", "facilityId": 194245, "height": 0, "id": 20652635, "isAvailableToBook": true, "length": 5, "maxBookingDate": { "day": 11, "dayOfWeek": 2, "dayOfWeekText": "Tuesday", "format": { "human": { "date": "December 11th, 2018", "time": "13:40 PM" }, "iso": "2018-12-11T13:40:19.000Z", "mdy": "12-11-2018", "timestamp": 1544535619, "ymd": "2018-12-11T00:00:00.000Z" }, "hour": 13, "isValidDate": true, "isValidTime": true, "minute": 40, "month": 11, "monthText": "December", "second": 19, "utcOffset": "+0000", "year": 2018 }, "price": { "text": "40.00", "value": 40 }, "promotion": "Call for specials!", "quantity": 9, "regularPrice": { "text": "40.00", "value": 40 }, "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit", "url": "/Austin-TX-self-storage/StorWise-Ben-White-194245/reserve/20652635", "vehicleAccommodation": null, "width": 5 }, { "amenitiesList": "1st Floor, Outdoor Access", "facilityId": 194245, "height": 0, "id": 17762899, "isAvailableToBook": true, "length": 10, "maxBookingDate": { "day": 11, "dayOfWeek": 2, "dayOfWeekText": "Tuesday", "format": { "human": { "date": "December 11th, 2018", "time": "13:40 PM" }, "iso": "2018-12-11T13:40:19.000Z", "mdy": "12-11-2018", "timestamp": 1544535619, "ymd": "2018-12-11T00:00:00.000Z" }, "hour": 13, "isValidDate": true, "isValidTime": true, "minute": 40, "month": 11, "monthText": "December", "second": 19, "utcOffset": "+0000", "year": 2018 }, "price": { "text": "69.00", "value": 69 }, "promotion": "Call for specials!", "quantity": 1, "regularPrice": { "text": "69.00", "value": 69 }, "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit", "url": "/Austin-TX-self-storage/StorWise-Ben-White-194245/reserve/17762899", "vehicleAccommodation": null, "width": 5 }, { "amenitiesList": "1st Floor, Available for Indoor Vehicle Storage, Outdoor Access", "facilityId": 194245, "height": 0, "id": 17438691, "isAvailableToBook": true, "length": 10, "maxBookingDate": { "day": 11, "dayOfWeek": 2, "dayOfWeekText": "Tuesday", "format": { "human": { "date": "December 11th, 2018", "time": "13:40 PM" }, "iso": "2018-12-11T13:40:19.000Z", "mdy": "12-11-2018", "timestamp": 1544535619, "ymd": "2018-12-11T00:00:00.000Z" }, "hour": 13, "isValidDate": true, "isValidTime": true, "minute": 40, "month": 11, "monthText": "December", "second": 19, "utcOffset": "+0000", "year": 2018 }, "price": { "text": "99.00", "value": 99 }, "promotion": "Call for specials!", "quantity": 6, "regularPrice": { "text": "99.00", "value": 99 }, "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit", "url": "/Austin-TX-self-storage/StorWise-Ben-White-194245/reserve/17438691", "vehicleAccommodation": null, "width": 10 } ], "url": { "city": "/Austin-TX-self-storage", "facility": "/Austin-TX-self-storage/StorWise-Ben-White-194245.html", "state": "/texas-storage", "website": "" }, "vehicleRestrictions": { "insurance": { "label": "Insurance", "required": "yes" }, "registration": { "label": "Registration", "required": "yes" }, "running": { "label": "Vehicle is drivable", "required": "yes" }, "title": { "label": "Title", "required": "yes" } }, "website": "" } ], "fullServiceCorpIds": [], "reviewCount": 56, "totalFacilityCount": 3, "totalFacilityIds": [ 154077, 50712, 194245 ], "totalUnitCount": 74 }, "filters": { "sqftRange": "" }, "fssFaqs": [], "fssResults": "fceb5c06eb5f248c32.74830680", "fssResultsURL": "/search.html?location=Austin, TX&searchType=fss-only", "headlines": { "primary": "Storage units in Austin, TX 78701", "secondary": "Find self-storage near you." }, "highlightedFacility": null, "irmMarket": "ATX", "isBellhopsMarket": true, "isTabbed": false, "landingFacilities": [ 202820, 209072, 152927, 50712 ], "landingLocation": { "city": "Austin", "country": "US", "fullState": "Texas", "id": "23899528", "latitude": 30.268, "longitude": -97.743, "state": "TX", "streetAddress": "522 Congress Avenue", "subLocality": "", "subPageType": "search", "text": "Austin, TX 78701", "zip": "78701" }, "loading": false, "localPhone": { "localSparephone": "1 (877) 691-2491", "localSparephoneUnformatted": "18776912491", "nationalSparephone": "1 (877) 691-2491", "nationalSparephoneUnformatted": "18776912491" }, "location": { "city": "Austin", "country": "US", "fullState": "Texas", "id": "23899528", "latitude": 30.268, "longitude": -97.743, "state": "TX", "streetAddress": "522 Congress Avenue", "subLocality": "", "subPageType": "search", "text": "Austin, TX 78701", "zip": "78701" }, "maxDistance": 30, "meta": { "canonical": "", "description": "Make your move easier with exclusive deals on moving trucks. Use SpareFoot to find a moving truck rental location near you.", "geo": { "icbm": "", "placeName": "", "position": "", "region": "" }, "logo": "//sparefoot.cachews.extrameter.com/images/sparefoot/sparefoot-logo.svg", "noindex": false, "structuredData": {}, "title": "Find A Moving Truck Near You | SpareFoot" }, "numPages": 11, "oonFacilities": [], "page": 1, "pageType": "movingTrucksLandingPage", "penskeResults": "15145c06eb5f25b2b9.92627458", "penskeResultsURL": "/search.html?location=Austin, TX&isPenske=true", "penskeURL": "/reroute/penske", "phone": { "nationalSparephone": "1 (877) 691-2491", "nationalSparephoneUnformatted": "18776912491" }, "polygons": {}, "query": { "distance": 30, "listingsPerPage": 3, "location": "30.2678, -97.7426", "namespace": "sparefoot", "truckRental": true, "variation": "variation" }, "searchId": "cbab5c06ea70787dc4.46875157", "searchParams": { "distance": "30", "expandIfLessThan": "1", "ip": "207.71.19.142", "listingsPerPage": "3", "location": "30.2678, -97.7426", "maxDistance": "30", "moveInDate": null, "namespace": "sparefoot", "order": "recommended", "page": "1", "searchType": null, "searchType[]": "facility", "siteId": "-1", "sqft": null, "truckRental": "true", "variation": "variation", "visitId": "49694265e63088bf892dd42f80399366" }, "searchType": "storage", "seo": { "canonical": "/moving-truck-rental.html" }, "staticMapUrl": "https://maps.googleapis.com/maps/api/staticmap?center=30.268%2C-97.743&zoom=13&size=480x175&maptype=roadmap&format=jpg&key=AIzaSyCa5Sq1pRwayGsrOcZPcdQD2EFXGzWM3Nk&signature=RgXMyl1sTptzEE0cqJIHTAyHYyM=", "todaysDate": "2018-12-04T00:00:00.000Z", "totalFacilities": 33, "totalUnits": 408, "truckResults": "2f315c06eb5f231723.16053425", "truckResultsURL": "/search.html?location=Austin, TX&truckRental=true", "url": { "city": "/Austin-TX-self-storage", "fssLanding": "/Austin-TX-full-service", "state": "/texas-storage" } }, "site_id": -1, "visible_threshold": 70 }, "receivedAt": "2018-12-04T21:02:29.576Z", "sentAt": "2018-12-04T21:02:29.488Z", "timestamp": "2018-12-04T21:02:29.571Z", "type": "track", "userId": "49694265e63088bf892dd42f80399366", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.userAgent": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.facility_id": "string", "properties.in_network": "string", "properties.index": "string", "properties.isReact": "string", "properties.label": "string", "properties.rank": "string", "properties.search_id": "string", "properties.search_id.algorithm": "string", "properties.search_id.bellhopsURL": "string", "properties.search_id.canonicalURL": "string", "properties.search_id.content.blogPosts": "", "properties.search_id.content.cityTotalBookings": "string", "properties.search_id.content.contentId": "string", "properties.search_id.content.contentTemplateId": "string", "properties.search_id.content.drillDownLinks.amenities": " ", "properties.search_id.content.drillDownLinks.universities": " ", "properties.search_id.content.drillDownLinks.vehicleStorage": " ", "properties.search_id.content.formattedStorageType": "string", "properties.search_id.content.movingGuidePosts": " ", "properties.search_id.content.nearbyCities": " ", "properties.search_id.content.popularSqft": "string", "properties.search_id.content.pricingStats": "string", "properties.search_id.error": "string", "properties.search_id.errorMessage": "string", "properties.search_id.experiments.red_716_tracking_prerender": "string", "properties.search_id.experiments.sf_4830_aa_phlag_band_aid": "string", "properties.search_id.experiments.sf_5635_half_nomad": "string", "properties.search_id.experiments.sf_6852_serp_results": "string", "properties.search_id.experiments.sf_7018_upsellit": "string", "properties.search_id.experiments.sf_7046_recommended_facility_badge": "string", "properties.search_id.experiments.sf_7058_two_step_checkout_v2": "string", "properties.search_id.facets.aaaActive": "string", "properties.search_id.facets.aaaEligile": "string", "properties.search_id.facets.alarm": "string", "properties.search_id.facets.amexActive": "string", "properties.search_id.facets.bandPracticeAllowed": "string", "properties.search_id.facets.climateControlled": "string", "properties.search_id.facets.covered": "string", "properties.search_id.facets.directoryFacility": "string", "properties.search_id.facets.driveUp": "string", "properties.search_id.facets.egateAccess": "string", "properties.search_id.facets.elevator": "string", "properties.search_id.facets.fencedLighted": "string", "properties.search_id.facets.floor": "string", "properties.search_id.facets.freeTruckRental": "string", "properties.search_id.facets.handcarts": "string", "properties.search_id.facets.indoor": "string", "properties.search_id.facets.kiosk": "string", "properties.search_id.facets.militaryDiscount": "string", "properties.search_id.facets.outOfNetworkOgf": "string", "properties.search_id.facets.outOfNetworkStoreTrac": "string", "properties.search_id.facets.outdoor": "string", "properties.search_id.facets.penske": "string", "properties.search_id.facets.power": "string", "properties.search_id.facets.prefilterTypeCounts.2": "string", "properties.search_id.facets.prefilterTypeCounts.4": "string", "properties.search_id.facets.prefilterTypes.storage": "string", "properties.search_id.facets.prefilterTypes.vehicle": "string", "properties.search_id.facets.prefilterTypes.warehouseDropoff": "string", "properties.search_id.facets.prefilterTypes.warehouseValet": "string", "properties.search_id.facets.seniorDiscount": "string", "properties.search_id.facets.studentDiscount": "string", "properties.search_id.facets.surveillance": "string", "properties.search_id.facets.truckAccess": "string", "properties.search_id.facets.truckRental": "string", "properties.search_id.facets.twentyFourHourAccess": "string", "properties.search_id.facets.typeOfListing.2": "string", "properties.search_id.facets.typeOfListing.4": "string", "properties.search_id.facets.uncovered": "string", "properties.search_id.facets.vehicle": "string", "properties.search_id.facilities": " ", "properties.search_id.facilitiesPerPage": "string", "properties.search_id.facilityCollection.collection": " ", "properties.search_id.facilityCollection.fullServiceCorpIds": " ", "properties.search_id.facilityCollection.reviewCount": "string", "properties.search_id.facilityCollection.totalFacilityCount": "string", "properties.search_id.facilityCollection.totalFacilityIds": " ", "properties.search_id.facilityCollection.totalUnitCount": "string", "properties.search_id.filters.sqftRange": "string", "properties.search_id.fssFaqs": " ", "properties.search_id.fssResults": "string", "properties.search_id.fssResultsURL": "string", "properties.search_id.headlines.primary": "string", "properties.search_id.headlines.secondary": "string", "properties.search_id.highlightedFacility": "string", "properties.search_id.irmMarket": "string", "properties.search_id.isBellhopsMarket": "string", "properties.search_id.isTabbed": "string", "properties.search_id.landingFacilities": " ", "properties.search_id.landingLocation.city": "string", "properties.search_id.landingLocation.country": "string", "properties.search_id.landingLocation.fullState": "string", "properties.search_id.landingLocation.id": "string", "properties.search_id.landingLocation.latitude": "string", "properties.search_id.landingLocation.longitude": "string", "properties.search_id.landingLocation.state": "string", "properties.search_id.landingLocation.streetAddress": "string", "properties.search_id.landingLocation.subLocality": "string", "properties.search_id.landingLocation.subPageType": "string", "properties.search_id.landingLocation.text": "string", "properties.search_id.landingLocation.zip": "string", "properties.search_id.loading": "string", "properties.search_id.localPhone.localSparephone": "string", "properties.search_id.localPhone.localSparephoneUnformatted": "string", "properties.search_id.localPhone.nationalSparephone": "string", "properties.search_id.localPhone.nationalSparephoneUnformatted": "string", "properties.search_id.location.city": "string", "properties.search_id.location.country": "string", "properties.search_id.location.fullState": "string", "properties.search_id.location.id": "string", "properties.search_id.location.latitude": "string", "properties.search_id.location.longitude": "string", "properties.search_id.location.state": "string", "properties.search_id.location.streetAddress": "string", "properties.search_id.location.subLocality": "string", "properties.search_id.location.subPageType": "string", "properties.search_id.location.text": "string", "properties.search_id.location.zip": "string", "properties.search_id.maxDistance": "string", "properties.search_id.meta.canonical": "string", "properties.search_id.meta.description": "string", "properties.search_id.meta.geo.icbm": "string", "properties.search_id.meta.geo.placeName": "string", "properties.search_id.meta.geo.position": "string", "properties.search_id.meta.geo.region": "string", "properties.search_id.meta.logo": "string", "properties.search_id.meta.noindex": "string", "properties.search_id.meta.title": "string", "properties.search_id.numPages": "string", "properties.search_id.oonFacilities": " ", "properties.search_id.page": "string", "properties.search_id.pageType": "string", "properties.search_id.penskeResults": "string", "properties.search_id.penskeResultsURL": "string", "properties.search_id.penskeURL": "string", "properties.search_id.phone.nationalSparephone": "string", "properties.search_id.phone.nationalSparephoneUnformatted": "string", "properties.search_id.query.distance": "string", "properties.search_id.query.listingsPerPage": "string", "properties.search_id.query.location": "string", "properties.search_id.query.namespace": "string", "properties.search_id.query.truckRental": "string", "properties.search_id.query.variation": "string", "properties.search_id.searchId": "string", "properties.search_id.searchParams.distance": "string", "properties.search_id.searchParams.expandIfLessThan": "string", "properties.search_id.searchParams.ip": "string", "properties.search_id.searchParams.listingsPerPage": "string", "properties.search_id.searchParams.location": "string", "properties.search_id.searchParams.maxDistance": "string", "properties.search_id.searchParams.moveInDate": "string", "properties.search_id.searchParams.namespace": "string", "properties.search_id.searchParams.order": "string", "properties.search_id.searchParams.page": "string", "properties.search_id.searchParams.searchType": "string", "properties.search_id.searchParams.searchType__": "string", "properties.search_id.searchParams.siteId": "string", "properties.search_id.searchParams.sqft": "string", "properties.search_id.searchParams.truckRental": "string", "properties.search_id.searchParams.variation": "string", "properties.search_id.searchParams.visitId": "string", "properties.search_id.searchType": "string", "properties.search_id.seo.canonical": "string", "properties.search_id.staticMapUrl": "string", "properties.search_id.todaysDate": "string", "properties.search_id.totalFacilities": "string", "properties.search_id.totalUnits": "string", "properties.search_id.truckResults": "string", "properties.search_id.truckResultsURL": "string", "properties.search_id.url.city": "string", "properties.search_id.url.fssLanding": "string", "properties.search_id.url.state": "string", "properties.site_id": "string", "properties.visible_threshold": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1110
- schema_scan_id: 4338765
- updated: 2018-12-04 15:16:20
-
Version 4663088
- created: 2018-12-04 15:00:26
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_facility_impression`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_facility_impression`\n(\n `version` string , `timestamp` string , `messageId` string , `userId` string ,`properties` struct< `category` : string , `index` : string , `Hit_Timestamp` : string , `in_network` : string , `isReact` : string , `site_id` : string , `rank` : string , `label` : string , `facility_id` : string , `env` : string , `visible_threshold` : string ,`search_id` : struct< `searchId` : string , `irmMarket` : string , `facilitiesPerPage` : string , `facilities`:array,`filters` : struct< `sqftRange` : string >,`query` : struct< `distance` : string , `truckRental` : string , `namespace` : string , `variation` : string , `location` : string , `listingsPerPage` : string >,`headlines` : struct< `primary` : string , `secondary` : string >, `loading` : string ,`facets` : struct< `penske` : string , `outdoor` : string , `indoor` : string , `aaaActive` : string , `twentyFourHourAccess` : string , `seniorDiscount` : string , `elevator` : string , `truckAccess` : string , `handcarts` : string , `driveUp` : string ,`typeOfListing` : struct< `2` : string , `4` : string >, `fencedLighted` : string , `floor` : string ,`prefilterTypes` : struct< `vehicle` : string , `storage` : string , `warehouseDropoff` : string , `warehouseValet` : string >, `surveillance` : string , `vehicle` : string , `outOfNetworkStoreTrac` : string , `aaaEligile` : string ,`prefilterTypeCounts` : struct< `2` : string , `4` : string >, `power` : string , `kiosk` : string , `climateControlled` : string , `covered` : string , `militaryDiscount` : string , `bandPracticeAllowed` : string , `studentDiscount` : string , `truckRental` : string , `egateAccess` : string , `alarm` : string , `uncovered` : string , `amexActive` : string , `outOfNetworkOgf` : string , `directoryFacility` : string , `freeTruckRental` : string >, `searchType` : string ,`localPhone` : struct< `localSparephone` : string , `localSparephoneUnformatted` : string , `nationalSparephoneUnformatted` : string , `nationalSparephone` : string >, `highlightedFacility` : string , `isTabbed` : string ,`location` : struct< `city` : string , `zip` : string , `country` : string , `fullState` : string , `streetAddress` : string , `longitude` : string , `subPageType` : string , `state` : string , `text` : string , `latitude` : string , `id` : string , `subLocality` : string >, `isBellhopsMarket` : string ,`searchParams` : struct< `distance` : string , `expandIfLessThan` : string , `truckRental` : string , `searchType` : string , `moveInDate` : string , `sqft` : string , `searchType__` : string , `variation` : string , `order` : string , `siteId` : string , `location` : string , `ip` : string , `namespace` : string , `maxDistance` : string , `page` : string , `listingsPerPage` : string , `visitId` : string >, `totalUnits` : string , `staticMapUrl` : string , `errorMessage` : string , `oonFacilities`:array , `landingFacilities`:array , `maxDistance` : string , `numPages` : string , `algorithm` : string ,`facilityCollection` : struct< `reviewCount` : string , `totalFacilityCount` : string , `totalFacilityIds`:array , `collection`:array , `totalUnitCount` : string , `fullServiceCorpIds`:array >,`url` : struct< `city` : string , `state` : string , `fssLanding` : string >, `totalFacilities` : string ,`landingLocation` : struct< `city` : string , `zip` : string , `country` : string , `fullState` : string , `streetAddress` : string , `longitude` : string , `subPageType` : string , `state` : string , `text` : string , `latitude` : string , `id` : string , `subLocality` : string >, `todaysDate` : string , `error` : string , `fssFaqs`:array , `page` : string >>, `receivedAt` string ,`_metadata` struct< `bundled`:array , `unbundled`:array >, `anonymousId` string , `originalTimestamp` string ,`context` struct< `userAgent` : string ,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >,`library` : struct< `version` : string , `name` : string >, `ip` : string >, `projectId` string , `_origin` string , `type` string , `event` string , `channel` string , `sentAt` string \n)\nPARTITIONED BY (dt string)\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-segment-reactfoot-dev/separated_dt/facility_impression'\n", "MSCK REPAIR TABLE sfdl_dev_segment.reactfoot_facility_impression" ] - hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/facility_impression
- id: 4663088
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "unbundled": [] }, "_origin": "2018-12-04T21:00:21Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1543881600000/1543957167414.cc24d8dd0445.1.11.1.d9487a45-266e-4147-948c-9d2b73fcfef2.gz|segment_separator:34", "anonymousId": "d9f96e36-589a-4ca1-8d52-b6cf69083d96", "channel": "client", "context": { "ip": "34.239.223.223", "library": { "name": "analytics.js", "version": "3.7.2" }, "page": { "path": "/moving-truck-rental.html", "referrer": "", "search": "", "title": "Find A Moving Truck Near You | SpareFoot", "url": "http://localhost:9000/moving-truck-rental.html" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.110 Safari/537.36" }, "event": "facility_impression", "integrations": {}, "messageId": "ajs-4cc4ff6cbaa3dab00d746a613efc37fa", "originalTimestamp": "2018-12-04T20:58:31.717Z", "projectId": "iHhi46PCMy", "properties": { "Hit Timestamp": 1543957111715, "category": "storage with moving trucks near you-movingTruckLandingPage", "env": "development", "facility_id": 194245, "in_network": true, "index": 3, "isReact": true, "label": "facility card", "rank": 3, "search_id": { "algorithm": "Centaur\\Algorithm\\NonVectorFloorsDonut", "content": {}, "error": false, "errorMessage": null, "facets": { "aaaActive": 19, "aaaEligile": 0, "alarm": 70, "amexActive": 0, "bandPracticeAllowed": 36, "climateControlled": 390, "covered": 0, "directoryFacility": 0, "driveUp": 258, "egateAccess": 374, "elevator": 167, "fencedLighted": 378, "floor": 407, "freeTruckRental": 186, "handcarts": 178, "indoor": 0, "kiosk": 0, "militaryDiscount": 213, "outOfNetworkOgf": 1, "outOfNetworkStoreTrac": 0, "outdoor": 0, "penske": 14, "power": 0, "prefilterTypeCounts": { "2": 1867, "4": 5 }, "prefilterTypes": { "storage": true, "vehicle": true, "warehouseDropoff": false, "warehouseValet": true }, "seniorDiscount": 52, "studentDiscount": 8, "surveillance": 404, "truckAccess": 60, "truckRental": 408, "twentyFourHourAccess": 123, "typeOfListing": { "2": 408, "4": 0 }, "uncovered": 0, "vehicle": 186 }, "facilities": [ 154077, 50712, 194245 ], "facilitiesPerPage": 3, "facilityCollection": { "collection": [ { "account": { "cpaPercentRolloutBetaState": "weak", "earliestReservationDay": 0, "id": 16, "minBid": "1.2", "minimumRentalPeriod": "3 month", "minimumRentalPeriodAmount": 3, "newMinBid": "1.2", "tosUrl": "/legal/consumer" }, "cheapestPrice": { "text": "53.10", "value": 53.1 }, "closures": [], "corporation": { "id": 1760, "sourceId": 17, "type": "self-storage" }, "description": "CubeSmart Self Storage is committed to providing our customers with excellent products, facilities, and customer service. Our customers enjoy many perks including moving services, packing & shipping supplies, storage customization, and business services - along with the best discounts in the industry!", "distance": 2.3, "fees": { "admin": { "text": "$24.00", "value": 24 } }, "hours": { "access": { "text": {} }, "office": { "meta": "", "text": {} } }, "id": 154077, "imageDetails": [], "images": [ "15407759d28c429aae0.jpg", "15407759d28c4348685.jpg", "15407759d28c443bdc7.jpg", "15407759d28c44cce5f.jpg", "15407759d28c45b7360.jpg", "15407759d28c4656752.jpg", "15407759d28c4736364.jpg", "15407759d28c47bf276.jpg", "15407759d28c4870605.jpg", "15407759d28c48f3fdb.jpg", "15407759d28c49b0841.jpg" ], "inNetwork": true, "irmFacility": false, "irmMarket": "ATX", "isActive": true, "isFullServiceStandalone": false, "isOutOfNetwork": false, "isSelfStorage": true, "location": { "city": "Austin", "country": "US", "fullState": "Texas", "id": "23899528", "latitude": 30.238897, "longitude": -97.72587, "state": "TX", "streetAddress": "2220 E Riverside Dr", "streetView": null, "subLocality": "", "text": "2220 E Riverside Dr Austin, TX 78741", "zip": "78741" }, "messaging": { "amexActive": false, "freeTruckRental": false, "isAaaEligible": false, "isOpenNow": true, "isOpenOnMoveIn": true, "isOpenOrWillBe": false, "isUrgent": true, "penskeRental": true, "truckRental": true }, "name": "CubeSmart Self Storage - Austin - 2220 E Riverside Dr", "phone": "(512) 326-3188", "phoneUnformatted": "5123263188", "promotion": "", "recommendedUnit": { "amenitiesList": "Interior, Upstairs (Access via Elevator)", "facilityId": 154077, "height": 0, "id": 20758418, "isAvailableToBook": true, "length": 10, "maxBookingDate": { "day": 19, "dayOfWeek": 3, "dayOfWeekText": "Wednesday", "format": { "human": { "date": "December 19th, 2018", "time": "13:42 PM" }, "iso": "2018-12-19T13:42:58.000Z", "mdy": "12-19-2018", "timestamp": 1545226978, "ymd": "2018-12-19T00:00:00.000Z" }, "hour": 13, "isValidDate": true, "isValidTime": true, "minute": 42, "month": 11, "monthText": "December", "second": 58, "utcOffset": "+0000", "year": 2018 }, "price": { "text": "63.00", "value": 63 }, "promotion": "10% Off and Half Off First Month", "quantity": null, "regularPrice": { "text": "70.00", "value": 70 }, "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit", "url": "/Austin-TX-self-storage/CubeSmart-Self-Storage-Austin-2220-E-Riverside-Dr-154077/reserve/20758418", "vehicleAccommodation": null, "width": 5 }, "reviews": { "average": 4.176, "count": 17 }, "seoLocation": { "city": "Austin", "fullState": "Texas", "state": "TX" }, "serviceArea": null, "showLocalPhones": true, "staticMapUrl": "https://maps.googleapis.com/maps/api/staticmap?center=30.238897%2C-97.72587&scale=1&zoom=14&size=620x300&markers=color%3Ared%7C30.238897%2C-97.72587&format=jpg&key=AIzaSyCa5Sq1pRwayGsrOcZPcdQD2EFXGzWM3Nk&signature=1cJ0rZM-qj9AxcQlF4-GCHea0fI=", "staticMapUrlLarge": "https://maps.googleapis.com/maps/api/staticmap?center=30.238897%2C-97.72587&scale=2&zoom=14&size=640x240&markers=color%3Ared%7C30.238897%2C-97.72587&format=jpg&key=AIzaSyCa5Sq1pRwayGsrOcZPcdQD2EFXGzWM3Nk&signature=jfyxfY7pyq9tXMtCxINIOGU8P30=", "tos": "No obligation to rent. Leasing this space is month-to-month, with no long term commitment. By clicking to reserve this unit, you agree to our Terms of Service.", "unitCount": 14, "units": [ { "amenitiesList": "Interior, Upstairs (Access via Elevator)", "facilityId": 154077, "height": 0, "id": 20764939, "isAvailableToBook": true, "length": 5, "maxBookingDate": { "day": 19, "dayOfWeek": 3, "dayOfWeekText": "Wednesday", "format": { "human": { "date": "December 19th, 2018", "time": "13:42 PM" }, "iso": "2018-12-19T13:42:58.000Z", "mdy": "12-19-2018", "timestamp": 1545226978, "ymd": "2018-12-19T00:00:00.000Z" }, "hour": 13, "isValidDate": true, "isValidTime": true, "minute": 42, "month": 11, "monthText": "December", "second": 58, "utcOffset": "+0000", "year": 2018 }, "price": { "text": "53.10", "value": 53.1 }, "promotion": "10% Off and First Month Free", "quantity": null, "regularPrice": { "text": "59.00", "value": 59 }, "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit", "url": "/Austin-TX-self-storage/CubeSmart-Self-Storage-Austin-2220-E-Riverside-Dr-154077/reserve/20764939", "vehicleAccommodation": null, "width": 5 }, { "amenitiesList": "Interior, Upstairs (Access via Elevator)", "facilityId": 154077, "height": 0, "id": 20758418, "isAvailableToBook": true, "length": 10, "maxBookingDate": { "day": 19, "dayOfWeek": 3, "dayOfWeekText": "Wednesday", "format": { "human": { "date": "December 19th, 2018", "time": "13:42 PM" }, "iso": "2018-12-19T13:42:58.000Z", "mdy": "12-19-2018", "timestamp": 1545226978, "ymd": "2018-12-19T00:00:00.000Z" }, "hour": 13, "isValidDate": true, "isValidTime": true, "minute": 42, "month": 11, "monthText": "December", "second": 58, "utcOffset": "+0000", "year": 2018 }, "price": { "text": "63.00", "value": 63 }, "promotion": "10% Off and Half Off First Month", "quantity": null, "regularPrice": { "text": "70.00", "value": 70 }, "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit", "url": "/Austin-TX-self-storage/CubeSmart-Self-Storage-Austin-2220-E-Riverside-Dr-154077/reserve/20758418", "vehicleAccommodation": null, "width": 5 }, { "amenitiesList": "Interior, Upstairs (Access via Elevator)", "facilityId": 154077, "height": 0, "id": 20758421, "isAvailableToBook": true, "length": 10, "maxBookingDate": { "day": 19, "dayOfWeek": 3, "dayOfWeekText": "Wednesday", "format": { "human": { "date": "December 19th, 2018", "time": "13:42 PM" }, "iso": "2018-12-19T13:42:58.000Z", "mdy": "12-19-2018", "timestamp": 1545226978, "ymd": "2018-12-19T00:00:00.000Z" }, "hour": 13, "isValidDate": true, "isValidTime": true, "minute": 42, "month": 11, "monthText": "December", "second": 58, "utcOffset": "+0000", "year": 2018 }, "price": { "text": "98.10", "value": 98.1 }, "promotion": "10% Off and Half Off First Month", "quantity": null, "regularPrice": { "text": "109.00", "value": 109 }, "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit", "url": "/Austin-TX-self-storage/CubeSmart-Self-Storage-Austin-2220-E-Riverside-Dr-154077/reserve/20758421", "vehicleAccommodation": null, "width": 10 } ], "url": { "city": "/Austin-TX-self-storage", "facility": "/Austin-TX-self-storage/CubeSmart-Self-Storage-Austin-2220-E-Riverside-Dr-154077.html", "state": "/texas-storage", "website": "" }, "vehicleRestrictions": { "insurance": { "label": "Insurance", "required": "yes" }, "registration": { "label": "Registration", "required": "yes" }, "running": { "label": "Vehicle is drivable", "required": "yes" }, "title": { "label": "Title", "required": "yes" } }, "website": "" }, { "account": { "cpaPercentRolloutBetaState": "weak", "earliestReservationDay": 0, "id": 351, "minBid": "1.25", "minimumRentalPeriod": "3 month", "minimumRentalPeriodAmount": 3, "newMinBid": "1.25", "tosUrl": "/legal/consumer" }, "cheapestPrice": { "text": "50.00", "value": 50 }, "closures": [], "corporation": { "id": 351, "sourceId": 11, "type": "self-storage" }, "description": "Life Storage offers a wide selection of storage units with a choice of both traditional and premium storage environments.", "distance": 5.4, "fees": { "admin": { "text": "$25.00", "value": 25 } }, "hours": { "access": { "text": {} }, "office": { "meta": "", "text": {} } }, "id": 50712, "imageDetails": [], "images": [ "507125956842c5a053.jpg", "507125881ae96adafd.jpg", "507125913f9a4406f8.jpg", "507125913f9a789686.jpg", "507125956842f6c8cc.jpg", "507125af3193c67816.jpg", "507125af3193d326b5.jpg", "507125b01078708b81.jpg", "507125bb4543c099ef.jpg" ], "inNetwork": true, "irmFacility": false, "irmMarket": "ATX", "isActive": true, "isFullServiceStandalone": false, "isOutOfNetwork": false, "isSelfStorage": true, "location": { "city": "Austin", "country": "US", "fullState": "Texas", "id": "23899528", "latitude": 30.198906, "longitude": -97.7865, "state": "TX", "streetAddress": "6509 S 1st St", "streetView": null, "subLocality": "", "text": "6509 S 1st St Austin, TX 78745", "zip": "78745" }, "messaging": { "amexActive": false, "freeTruckRental": true, "isAaaEligible": false, "isOpenNow": true, "isOpenOnMoveIn": true, "isOpenOrWillBe": false, "isUrgent": true, "penskeRental": false, "truckRental": true }, "name": "Life Storage - Austin - South 1st Street", "phone": "(512) 326-3131", "phoneUnformatted": "5123263131", "promotion": "", "recommendedUnit": { "amenitiesList": "1st Floor, 9' Ceiling, Interior, Roll Up Door", "facilityId": 50712, "height": 9, "id": 777891, "isAvailableToBook": true, "length": 10, "maxBookingDate": { "day": 10, "dayOfWeek": 1, "dayOfWeekText": "Monday", "format": { "human": { "date": "December 10th, 2018", "time": "13:50 PM" }, "iso": "2018-12-10T13:50:10.000Z", "mdy": "12-10-2018", "timestamp": 1544449810, "ymd": "2018-12-10T00:00:00.000Z" }, "hour": 13, "isValidDate": true, "isValidTime": true, "minute": 50, "month": 11, "monthText": "December", "second": 10, "utcOffset": "+0000", "year": 2018 }, "price": { "text": "51.00", "value": 51 }, "promotion": "Pay the remaining days this month, next month Free!", "quantity": 4, "regularPrice": { "text": "57.00", "value": 57 }, "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit", "url": "/Austin-TX-self-storage/Life-Storage-Austin-South-1st-Street-50712/reserve/777891", "vehicleAccommodation": null, "width": 5 }, "reviews": { "average": 4.514, "count": 37 }, "seoLocation": { "city": "Austin", "fullState": "Texas", "state": "TX" }, "serviceArea": null, "showLocalPhones": true, "staticMapUrl": "https://maps.googleapis.com/maps/api/staticmap?center=30.198906%2C-97.7865&scale=1&zoom=14&size=620x300&markers=color%3Ared%7C30.198906%2C-97.7865&format=jpg&key=AIzaSyCa5Sq1pRwayGsrOcZPcdQD2EFXGzWM3Nk&signature=VxSn3k0_0bjulEhySQst3wOIgGs=", "staticMapUrlLarge": "https://maps.googleapis.com/maps/api/staticmap?center=30.198906%2C-97.7865&scale=2&zoom=14&size=640x240&markers=color%3Ared%7C30.198906%2C-97.7865&format=jpg&key=AIzaSyCa5Sq1pRwayGsrOcZPcdQD2EFXGzWM3Nk&signature=VD-xtGj4SIWS_OM6Zfpqze8fZ5M=", "tos": "No obligation to rent. Leasing this space is month-to-month, with no long term commitment. By clicking to reserve this unit, you agree to our Terms of Service.", "unitCount": 49, "units": [ { "amenitiesList": "1st Floor, 9' Ceiling, Climate Controlled, Interior, Roll Up Door", "facilityId": 50712, "height": 9, "id": 786007, "isAvailableToBook": true, "length": 5, "maxBookingDate": { "day": 8, "dayOfWeek": 6, "dayOfWeekText": "Saturday", "format": { "human": { "date": "December 8th, 2018", "time": "13:50 PM" }, "iso": "2018-12-08T13:50:10.000Z", "mdy": "12-08-2018", "timestamp": 1544277010, "ymd": "2018-12-08T00:00:00.000Z" }, "hour": 13, "isValidDate": true, "isValidTime": true, "minute": 50, "month": 11, "monthText": "December", "second": 10, "utcOffset": "+0000", "year": 2018 }, "price": { "text": "52.00", "value": 52 }, "promotion": "Pay the remaining days this month, next month Free!", "quantity": 2, "regularPrice": { "text": "58.00", "value": 58 }, "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit", "url": "/Austin-TX-self-storage/Life-Storage-Austin-South-1st-Street-50712/reserve/786007", "vehicleAccommodation": null, "width": 5 }, { "amenitiesList": "1st Floor, 9' Ceiling, Interior, Roll Up Door", "facilityId": 50712, "height": 9, "id": 777891, "isAvailableToBook": true, "length": 10, "maxBookingDate": { "day": 10, "dayOfWeek": 1, "dayOfWeekText": "Monday", "format": { "human": { "date": "December 10th, 2018", "time": "13:50 PM" }, "iso": "2018-12-10T13:50:10.000Z", "mdy": "12-10-2018", "timestamp": 1544449810, "ymd": "2018-12-10T00:00:00.000Z" }, "hour": 13, "isValidDate": true, "isValidTime": true, "minute": 50, "month": 11, "monthText": "December", "second": 10, "utcOffset": "+0000", "year": 2018 }, "price": { "text": "51.00", "value": 51 }, "promotion": "Pay the remaining days this month, next month Free!", "quantity": 4, "regularPrice": { "text": "57.00", "value": 57 }, "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit", "url": "/Austin-TX-self-storage/Life-Storage-Austin-South-1st-Street-50712/reserve/777891", "vehicleAccommodation": null, "width": 5 }, { "amenitiesList": "9' Ceiling, Drive Up Access, Roll Up Door", "facilityId": 50712, "height": 9, "id": 777894, "isAvailableToBook": true, "length": 15, "maxBookingDate": { "day": 8, "dayOfWeek": 6, "dayOfWeekText": "Saturday", "format": { "human": { "date": "December 8th, 2018", "time": "13:50 PM" }, "iso": "2018-12-08T13:50:10.000Z", "mdy": "12-08-2018", "timestamp": 1544277010, "ymd": "2018-12-08T00:00:00.000Z" }, "hour": 13, "isValidDate": true, "isValidTime": true, "minute": 50, "month": 11, "monthText": "December", "second": 10, "utcOffset": "+0000", "year": 2018 }, "price": { "text": "50.00", "value": 50 }, "promotion": "Pay the remaining days this month, next month 50% off!", "quantity": 3, "regularPrice": { "text": "56.00", "value": 56 }, "sizeText": "5' x 15'", "squareFootage": 75, "unitTypeText": "unit", "url": "/Austin-TX-self-storage/Life-Storage-Austin-South-1st-Street-50712/reserve/777894", "vehicleAccommodation": null, "width": 5 } ], "url": { "city": "/Austin-TX-self-storage", "facility": "/Austin-TX-self-storage/Life-Storage-Austin-South-1st-Street-50712.html", "state": "/texas-storage", "website": "" }, "vehicleRestrictions": { "insurance": { "label": "Insurance", "required": "yes" }, "registration": { "label": "Registration", "required": "yes" }, "running": { "label": "Vehicle is drivable", "required": "yes" }, "title": { "label": "Title", "required": "yes" } }, "website": "" }, { "account": { "earliestReservationDay": 0, "id": 6838, "minimumRentalPeriod": "3 month", "minimumRentalPeriodAmount": 3, "newMinBid": "1.5", "tosUrl": "/legal/consumer" }, "cheapestPrice": { "text": "40.00", "value": 40 }, "closures": [], "corporation": { "id": 7574, "sourceId": 7, "type": "self-storage" }, "description": "Ben White Self Storage in Austin offers a wide selection of convenient storage units, including climate controlled options. The facility is fully secured through the use of video cameras and electronic gated access. We also have a resident manager that lives on site to assist with all of your storage needs. Our non climate drive up units can be accessed easily with up to a 26 foot trucks. All vehicles including, cars, RVs, trucks, boats, etc. must be in running condition and must be up to date with licensing and registration to be stored at this facility.", "distance": 3.7, "fees": { "admin": { "text": "$20.00", "value": 20 } }, "hours": { "access": { "text": {} }, "office": { "meta": "", "text": {} } }, "id": 194245, "imageDetails": [], "images": [ "1942455602fcdbd64b9.png", "1942455602fcdd5e6ce.png", "1942455602fcdebfb8c.png" ], "inNetwork": true, "irmFacility": false, "irmMarket": "ATX", "isActive": true, "isFullServiceStandalone": false, "isOutOfNetwork": false, "isSelfStorage": true, "location": { "city": "Austin", "country": "US", "fullState": "Texas", "id": "23899528", "latitude": 30.21511, "longitude": -97.741066, "state": "TX", "streetAddress": "2229 East Ben White Boulevard", "streetView": null, "subLocality": "", "text": "2229 East Ben White Boulevard Austin, TX 78741", "zip": "78741" }, "messaging": { "amexActive": false, "freeTruckRental": false, "isAaaEligible": false, "isOpenNow": true, "isOpenOnMoveIn": true, "isOpenOrWillBe": false, "isUrgent": false, "penskeRental": false, "truckRental": true }, "name": "StorWise Ben White", "phone": "(512) 443-5858", "phoneUnformatted": "5124435858", "promotion": "", "recommendedUnit": { "amenitiesList": "1st Floor, Outdoor Access", "facilityId": 194245, "height": 0, "id": 17762899, "isAvailableToBook": true, "length": 10, "maxBookingDate": { "day": 11, "dayOfWeek": 2, "dayOfWeekText": "Tuesday", "format": { "human": { "date": "December 11th, 2018", "time": "13:40 PM" }, "iso": "2018-12-11T13:40:19.000Z", "mdy": "12-11-2018", "timestamp": 1544535619, "ymd": "2018-12-11T00:00:00.000Z" }, "hour": 13, "isValidDate": true, "isValidTime": true, "minute": 40, "month": 11, "monthText": "December", "second": 19, "utcOffset": "+0000", "year": 2018 }, "price": { "text": "69.00", "value": 69 }, "promotion": "Call for specials!", "quantity": 1, "regularPrice": { "text": "69.00", "value": 69 }, "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit", "url": "/Austin-TX-self-storage/StorWise-Ben-White-194245/reserve/17762899", "vehicleAccommodation": null, "width": 5 }, "reviews": { "average": 4.75, "count": 2 }, "seoLocation": { "city": "Austin", "fullState": "Texas", "state": "TX" }, "serviceArea": null, "showLocalPhones": true, "staticMapUrl": "https://maps.googleapis.com/maps/api/staticmap?center=30.21511%2C-97.741066&scale=1&zoom=14&size=620x300&markers=color%3Ared%7C30.21511%2C-97.741066&format=jpg&key=AIzaSyCa5Sq1pRwayGsrOcZPcdQD2EFXGzWM3Nk&signature=AyQkEy51gIfMfordvTQOKQVFGtY=", "staticMapUrlLarge": "https://maps.googleapis.com/maps/api/staticmap?center=30.21511%2C-97.741066&scale=2&zoom=14&size=640x240&markers=color%3Ared%7C30.21511%2C-97.741066&format=jpg&key=AIzaSyCa5Sq1pRwayGsrOcZPcdQD2EFXGzWM3Nk&signature=afZNw57HDE_Dn7REA2hD9uVvTI0=", "tos": "No obligation to rent. Leasing this space is month-to-month, with no long term commitment. By clicking to reserve this unit, you agree to our Terms of Service.", "unitCount": 11, "units": [ { "amenitiesList": "1st Floor, Interior", "facilityId": 194245, "height": 0, "id": 20652635, "isAvailableToBook": true, "length": 5, "maxBookingDate": { "day": 11, "dayOfWeek": 2, "dayOfWeekText": "Tuesday", "format": { "human": { "date": "December 11th, 2018", "time": "13:40 PM" }, "iso": "2018-12-11T13:40:19.000Z", "mdy": "12-11-2018", "timestamp": 1544535619, "ymd": "2018-12-11T00:00:00.000Z" }, "hour": 13, "isValidDate": true, "isValidTime": true, "minute": 40, "month": 11, "monthText": "December", "second": 19, "utcOffset": "+0000", "year": 2018 }, "price": { "text": "40.00", "value": 40 }, "promotion": "Call for specials!", "quantity": 9, "regularPrice": { "text": "40.00", "value": 40 }, "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit", "url": "/Austin-TX-self-storage/StorWise-Ben-White-194245/reserve/20652635", "vehicleAccommodation": null, "width": 5 }, { "amenitiesList": "1st Floor, Outdoor Access", "facilityId": 194245, "height": 0, "id": 17762899, "isAvailableToBook": true, "length": 10, "maxBookingDate": { "day": 11, "dayOfWeek": 2, "dayOfWeekText": "Tuesday", "format": { "human": { "date": "December 11th, 2018", "time": "13:40 PM" }, "iso": "2018-12-11T13:40:19.000Z", "mdy": "12-11-2018", "timestamp": 1544535619, "ymd": "2018-12-11T00:00:00.000Z" }, "hour": 13, "isValidDate": true, "isValidTime": true, "minute": 40, "month": 11, "monthText": "December", "second": 19, "utcOffset": "+0000", "year": 2018 }, "price": { "text": "69.00", "value": 69 }, "promotion": "Call for specials!", "quantity": 1, "regularPrice": { "text": "69.00", "value": 69 }, "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit", "url": "/Austin-TX-self-storage/StorWise-Ben-White-194245/reserve/17762899", "vehicleAccommodation": null, "width": 5 }, { "amenitiesList": "1st Floor, Available for Indoor Vehicle Storage, Outdoor Access", "facilityId": 194245, "height": 0, "id": 17438691, "isAvailableToBook": true, "length": 10, "maxBookingDate": { "day": 11, "dayOfWeek": 2, "dayOfWeekText": "Tuesday", "format": { "human": { "date": "December 11th, 2018", "time": "13:40 PM" }, "iso": "2018-12-11T13:40:19.000Z", "mdy": "12-11-2018", "timestamp": 1544535619, "ymd": "2018-12-11T00:00:00.000Z" }, "hour": 13, "isValidDate": true, "isValidTime": true, "minute": 40, "month": 11, "monthText": "December", "second": 19, "utcOffset": "+0000", "year": 2018 }, "price": { "text": "99.00", "value": 99 }, "promotion": "Call for specials!", "quantity": 6, "regularPrice": { "text": "99.00", "value": 99 }, "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit", "url": "/Austin-TX-self-storage/StorWise-Ben-White-194245/reserve/17438691", "vehicleAccommodation": null, "width": 10 } ], "url": { "city": "/Austin-TX-self-storage", "facility": "/Austin-TX-self-storage/StorWise-Ben-White-194245.html", "state": "/texas-storage", "website": "" }, "vehicleRestrictions": { "insurance": { "label": "Insurance", "required": "yes" }, "registration": { "label": "Registration", "required": "yes" }, "running": { "label": "Vehicle is drivable", "required": "yes" }, "title": { "label": "Title", "required": "yes" } }, "website": "" } ], "fullServiceCorpIds": [], "reviewCount": 56, "totalFacilityCount": 3, "totalFacilityIds": [ 154077, 50712, 194245 ], "totalUnitCount": 74 }, "filters": { "sqftRange": "" }, "fssFaqs": [], "headlines": { "primary": "Storage units in Austin, TX 78701", "secondary": "Find self-storage near you." }, "highlightedFacility": null, "irmMarket": "ATX", "isBellhopsMarket": true, "isTabbed": false, "landingFacilities": [ 202820, 209072, 152927, 50712 ], "landingLocation": { "city": "Austin", "country": "US", "fullState": "Texas", "id": "23899528", "latitude": 30.268, "longitude": -97.743, "state": "TX", "streetAddress": "522 Congress Avenue", "subLocality": "", "subPageType": "search", "text": "Austin, TX 78701", "zip": "78701" }, "loading": false, "localPhone": { "localSparephone": "1 (877) 691-2491", "localSparephoneUnformatted": "18776912491", "nationalSparephone": "1 (877) 691-2491", "nationalSparephoneUnformatted": "18776912491" }, "location": { "city": "Austin", "country": "US", "fullState": "Texas", "id": "23899528", "latitude": 30.268, "longitude": -97.743, "state": "TX", "streetAddress": "522 Congress Avenue", "subLocality": "", "subPageType": "search", "text": "Austin, TX 78701", "zip": "78701" }, "maxDistance": 30, "meta": {}, "numPages": 11, "oonFacilities": [], "page": 1, "phone": {}, "polygons": {}, "query": { "distance": 30, "listingsPerPage": 3, "location": "30.2678, -97.7426", "namespace": "sparefoot", "truckRental": true, "variation": "variation" }, "searchId": "cbab5c06ea70787dc4.46875157", "searchParams": { "distance": "30", "expandIfLessThan": "1", "ip": "207.71.19.142", "listingsPerPage": "3", "location": "30.2678, -97.7426", "maxDistance": "30", "moveInDate": null, "namespace": "sparefoot", "order": "recommended", "page": "1", "searchType": null, "searchType[]": "facility", "siteId": "-1", "sqft": null, "truckRental": "true", "variation": "variation", "visitId": "49694265e63088bf892dd42f80399366" }, "searchType": "storage", "staticMapUrl": "https://maps.googleapis.com/maps/api/staticmap?center=30.268%2C-97.743&zoom=13&size=480x175&maptype=roadmap&format=jpg&key=AIzaSyCa5Sq1pRwayGsrOcZPcdQD2EFXGzWM3Nk&signature=RgXMyl1sTptzEE0cqJIHTAyHYyM=", "todaysDate": "2018-12-04T00:00:00.000Z", "totalFacilities": 33, "totalUnits": 408, "url": { "city": "/Austin-TX-self-storage", "fssLanding": "/Austin-TX-full-service", "state": "/texas-storage" } }, "site_id": -1, "visible_threshold": 70 }, "receivedAt": "2018-12-04T20:58:31.967Z", "sentAt": "2018-12-04T20:58:31.732Z", "timestamp": "2018-12-04T20:58:31.952Z", "type": "track", "userId": "49694265e63088bf892dd42f80399366", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.userAgent": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.facility_id": "string", "properties.in_network": "string", "properties.index": "string", "properties.isReact": "string", "properties.label": "string", "properties.rank": "string", "properties.search_id": "string", "properties.search_id.algorithm": "string", "properties.search_id.error": "string", "properties.search_id.errorMessage": "string", "properties.search_id.facets.aaaActive": "string", "properties.search_id.facets.aaaEligile": "string", "properties.search_id.facets.alarm": "string", "properties.search_id.facets.amexActive": "string", "properties.search_id.facets.bandPracticeAllowed": "string", "properties.search_id.facets.climateControlled": "string", "properties.search_id.facets.covered": "string", "properties.search_id.facets.directoryFacility": "string", "properties.search_id.facets.driveUp": "string", "properties.search_id.facets.egateAccess": "string", "properties.search_id.facets.elevator": "string", "properties.search_id.facets.fencedLighted": "string", "properties.search_id.facets.floor": "string", "properties.search_id.facets.freeTruckRental": "string", "properties.search_id.facets.handcarts": "string", "properties.search_id.facets.indoor": "string", "properties.search_id.facets.kiosk": "string", "properties.search_id.facets.militaryDiscount": "string", "properties.search_id.facets.outOfNetworkOgf": "string", "properties.search_id.facets.outOfNetworkStoreTrac": "string", "properties.search_id.facets.outdoor": "string", "properties.search_id.facets.penske": "string", "properties.search_id.facets.power": "string", "properties.search_id.facets.prefilterTypeCounts.2": "string", "properties.search_id.facets.prefilterTypeCounts.4": "string", "properties.search_id.facets.prefilterTypes.storage": "string", "properties.search_id.facets.prefilterTypes.vehicle": "string", "properties.search_id.facets.prefilterTypes.warehouseDropoff": "string", "properties.search_id.facets.prefilterTypes.warehouseValet": "string", "properties.search_id.facets.seniorDiscount": "string", "properties.search_id.facets.studentDiscount": "string", "properties.search_id.facets.surveillance": "string", "properties.search_id.facets.truckAccess": "string", "properties.search_id.facets.truckRental": "string", "properties.search_id.facets.twentyFourHourAccess": "string", "properties.search_id.facets.typeOfListing.2": "string", "properties.search_id.facets.typeOfListing.4": "string", "properties.search_id.facets.uncovered": "string", "properties.search_id.facets.vehicle": "string", "properties.search_id.facilities": "", "properties.search_id.facilitiesPerPage": "string", "properties.search_id.facilityCollection.collection": " ", "properties.search_id.facilityCollection.fullServiceCorpIds": " ", "properties.search_id.facilityCollection.reviewCount": "string", "properties.search_id.facilityCollection.totalFacilityCount": "string", "properties.search_id.facilityCollection.totalFacilityIds": " ", "properties.search_id.facilityCollection.totalUnitCount": "string", "properties.search_id.filters.sqftRange": "string", "properties.search_id.fssFaqs": " ", "properties.search_id.headlines.primary": "string", "properties.search_id.headlines.secondary": "string", "properties.search_id.highlightedFacility": "string", "properties.search_id.irmMarket": "string", "properties.search_id.isBellhopsMarket": "string", "properties.search_id.isTabbed": "string", "properties.search_id.landingFacilities": " ", "properties.search_id.landingLocation.city": "string", "properties.search_id.landingLocation.country": "string", "properties.search_id.landingLocation.fullState": "string", "properties.search_id.landingLocation.id": "string", "properties.search_id.landingLocation.latitude": "string", "properties.search_id.landingLocation.longitude": "string", "properties.search_id.landingLocation.state": "string", "properties.search_id.landingLocation.streetAddress": "string", "properties.search_id.landingLocation.subLocality": "string", "properties.search_id.landingLocation.subPageType": "string", "properties.search_id.landingLocation.text": "string", "properties.search_id.landingLocation.zip": "string", "properties.search_id.loading": "string", "properties.search_id.localPhone.localSparephone": "string", "properties.search_id.localPhone.localSparephoneUnformatted": "string", "properties.search_id.localPhone.nationalSparephone": "string", "properties.search_id.localPhone.nationalSparephoneUnformatted": "string", "properties.search_id.location.city": "string", "properties.search_id.location.country": "string", "properties.search_id.location.fullState": "string", "properties.search_id.location.id": "string", "properties.search_id.location.latitude": "string", "properties.search_id.location.longitude": "string", "properties.search_id.location.state": "string", "properties.search_id.location.streetAddress": "string", "properties.search_id.location.subLocality": "string", "properties.search_id.location.subPageType": "string", "properties.search_id.location.text": "string", "properties.search_id.location.zip": "string", "properties.search_id.maxDistance": "string", "properties.search_id.numPages": "string", "properties.search_id.oonFacilities": " ", "properties.search_id.page": "string", "properties.search_id.query.distance": "string", "properties.search_id.query.listingsPerPage": "string", "properties.search_id.query.location": "string", "properties.search_id.query.namespace": "string", "properties.search_id.query.truckRental": "string", "properties.search_id.query.variation": "string", "properties.search_id.searchId": "string", "properties.search_id.searchParams.distance": "string", "properties.search_id.searchParams.expandIfLessThan": "string", "properties.search_id.searchParams.ip": "string", "properties.search_id.searchParams.listingsPerPage": "string", "properties.search_id.searchParams.location": "string", "properties.search_id.searchParams.maxDistance": "string", "properties.search_id.searchParams.moveInDate": "string", "properties.search_id.searchParams.namespace": "string", "properties.search_id.searchParams.order": "string", "properties.search_id.searchParams.page": "string", "properties.search_id.searchParams.searchType": "string", "properties.search_id.searchParams.searchType__": "string", "properties.search_id.searchParams.siteId": "string", "properties.search_id.searchParams.sqft": "string", "properties.search_id.searchParams.truckRental": "string", "properties.search_id.searchParams.variation": "string", "properties.search_id.searchParams.visitId": "string", "properties.search_id.searchType": "string", "properties.search_id.staticMapUrl": "string", "properties.search_id.todaysDate": "string", "properties.search_id.totalFacilities": "string", "properties.search_id.totalUnits": "string", "properties.search_id.url.city": "string", "properties.search_id.url.fssLanding": "string", "properties.search_id.url.state": "string", "properties.site_id": "string", "properties.visible_threshold": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1110
- schema_scan_id: 4338484
- updated: 2018-12-04 15:00:39
-
Version 4663083
- created: 2018-12-03 12:00:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_facility_impression`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_facility_impression`\n(\n `version` string , `timestamp` string , `messageId` string , `userId` string , `event` string , `receivedAt` string ,`_metadata` struct< `bundled`:array, `unbundled`:array >, `anonymousId` string , `originalTimestamp` string ,`context` struct< `userAgent` : string ,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >,`library` : struct< `version` : string , `name` : string >, `ip` : string >, `projectId` string , `_origin` string , `type` string ,`properties` struct< `category` : string , `index` : string , `Hit_Timestamp` : string , `in_network` : string , `isReact` : string , `site_id` : string , `rank` : string , `label` : string , `facility_id` : string , `env` : string , `visible_threshold` : string ,`search_id` : struct< `searchId` : string , `irmMarket` : string , `facilitiesPerPage` : string , `facilities`:array , `loading` : string , `searchType` : string , `staticMapUrl` : string ,`searchParams` : struct< `sqft` : string , `moveInDate` : string , `location` : string , `searchType` : string , `order` : string >, `totalUnits` : string , `highlightedFacility` : string , `errorMessage` : string , `oonFacilities`:array , `landingFacilities`:array , `numPages` : string , `totalFacilities` : string ,`landingLocation` : struct< `city` : string , `zip` : string , `country` : string , `fullState` : string , `state` : string , `longitude` : string , `subPageType` : string , `streetAddress` : string , `text` : string , `latitude` : string , `id` : string , `subLocality` : string >, `error` : string , `isBellhopsMarket` : string , `fssFaqs`:array , `page` : string >>, `channel` string , `sentAt` string \n)\nPARTITIONED BY (dt string)\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-segment-reactfoot-dev/separated_dt/facility_impression'\n", "MSCK REPAIR TABLE sfdl_dev_segment.reactfoot_facility_impression" ] - hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/facility_impression
- id: 4663083
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "unbundled": [] }, "_origin": "2018-12-03T18:00:55Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1543795200000/1543859962983.62735d796fbe.1.11.1.f67f81e9-7f48-48e2-9bed-15ad42cc8174.gz|segment_separator:34", "anonymousId": "d9f96e36-589a-4ca1-8d52-b6cf69083d96", "channel": "client", "context": { "ip": "34.239.223.223", "library": { "name": "analytics.js", "version": "3.7.2" }, "page": { "path": "/rv-storage.html", "referrer": "", "search": "", "title": "RV Storage: Rent Cheap RV & Camper Storage Near You | SpareFoot", "url": "http://localhost:9000/rv-storage.html" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.110 Safari/537.36" }, "event": "facility_impression", "integrations": {}, "messageId": "ajs-2eb5ef458f6dfeeedb4cdf73922d2e0a", "originalTimestamp": "2018-12-03T17:48:23.064Z", "projectId": "iHhi46PCMy", "properties": { "Hit Timestamp": 1543859303063, "category": "rv storage near you-storageRvLandingPage", "env": "development", "facility_id": 209072, "in_network": true, "index": 1, "isReact": true, "label": "facility card", "rank": 1, "search_id": { "content": {}, "error": false, "errorMessage": null, "facilities": [], "facilitiesPerPage": 15, "fssFaqs": [], "headlines": {}, "highlightedFacility": null, "irmMarket": null, "isBellhopsMarket": false, "landingFacilities": [ 202820, 209072, 152927, 50712 ], "landingLocation": { "city": "Austin", "country": "US", "fullState": "Texas", "id": "23899528", "latitude": 30.268, "longitude": -97.743, "state": "TX", "streetAddress": "522 Congress Avenue", "subLocality": "", "subPageType": "search", "text": "Austin, TX 78701", "zip": "78701" }, "loading": false, "location": {}, "meta": {}, "numPages": 0, "oonFacilities": [], "page": 1, "phone": {}, "polygons": {}, "searchId": null, "searchParams": { "location": null, "moveInDate": null, "order": "recommended", "searchType": null, "sqft": null }, "searchType": null, "staticMapUrl": null, "totalFacilities": 0, "totalUnits": 0, "url": {} }, "site_id": -1, "visible_threshold": 70 }, "receivedAt": "2018-12-03T17:48:23.088Z", "sentAt": "2018-12-03T17:48:23.067Z", "timestamp": "2018-12-03T17:48:23.085Z", "type": "track", "userId": "49694265e63088bf892dd42f80399366", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.userAgent": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.facility_id": "string", "properties.in_network": "string", "properties.index": "string", "properties.isReact": "string", "properties.label": "string", "properties.rank": "string", "properties.search_id": "string", "properties.search_id.error": "string", "properties.search_id.errorMessage": "string", "properties.search_id.facilities": "", "properties.search_id.facilitiesPerPage": "string", "properties.search_id.fssFaqs": " ", "properties.search_id.highlightedFacility": "string", "properties.search_id.irmMarket": "string", "properties.search_id.isBellhopsMarket": "string", "properties.search_id.landingFacilities": " ", "properties.search_id.landingLocation.city": "string", "properties.search_id.landingLocation.country": "string", "properties.search_id.landingLocation.fullState": "string", "properties.search_id.landingLocation.id": "string", "properties.search_id.landingLocation.latitude": "string", "properties.search_id.landingLocation.longitude": "string", "properties.search_id.landingLocation.state": "string", "properties.search_id.landingLocation.streetAddress": "string", "properties.search_id.landingLocation.subLocality": "string", "properties.search_id.landingLocation.subPageType": "string", "properties.search_id.landingLocation.text": "string", "properties.search_id.landingLocation.zip": "string", "properties.search_id.loading": "string", "properties.search_id.numPages": "string", "properties.search_id.oonFacilities": " ", "properties.search_id.page": "string", "properties.search_id.searchId": "string", "properties.search_id.searchParams.location": "string", "properties.search_id.searchParams.moveInDate": "string", "properties.search_id.searchParams.order": "string", "properties.search_id.searchParams.searchType": "string", "properties.search_id.searchParams.sqft": "string", "properties.search_id.searchType": "string", "properties.search_id.staticMapUrl": "string", "properties.search_id.totalFacilities": "string", "properties.search_id.totalUnits": "string", "properties.site_id": "string", "properties.visible_threshold": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1110
- schema_scan_id: 4335767
- updated: 2018-12-03 12:01:10
-
Version 4663061
- created: 2018-11-30 14:59:50
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_facility_impression`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_facility_impression`\n(\n `version` string , `timestamp` string , `projectId` string , `userId` string ,`properties` struct< `category` : string , `index` : string , `Hit_Timestamp` : string , `in_network` : string , `isReact` : string , `site_id` : string , `rank` : string , `label` : string , `facility_id` : string , `env` : string , `visible_threshold` : string , `search_id` : string >, `receivedAt` string ,`_metadata` struct< `bundled`:array, `unbundled`:array >, `anonymousId` string , `originalTimestamp` string ,`context` struct< `userAgent` : string ,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >,`library` : struct< `version` : string , `name` : string >, `ip` : string >, `messageId` string , `_origin` string , `type` string , `event` string , `channel` string , `sentAt` string \n)\nPARTITIONED BY (dt string)\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-segment-reactfoot-dev/separated_dt/facility_impression'\n", "MSCK REPAIR TABLE sfdl_dev_segment.reactfoot_facility_impression" ] - hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/facility_impression
- id: 4663061
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "unbundled": [] }, "_origin": "2018-11-30T20:59:44Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1543536000000/1543611566724.18855c58f9b7.1.11.1.13bd789c-50f2-4e98-a74d-c3886edc60cb.gz|segment_separator:34", "anonymousId": "d9f96e36-589a-4ca1-8d52-b6cf69083d96", "channel": "client", "context": { "ip": "66.162.93.78", "library": { "name": "analytics.js", "version": "3.7.2" }, "page": { "path": "/Austin-TX-self-storage/Storage-Stall-143170.html", "referrer": "http://localhost:9000/search.html?location=Austin%2C%20TX&searchType=storage&order=recommended&page=10&listingsPerPage=15", "search": "", "title": "Storage Stall - Austin, TX | SpareFoot", "url": "http://localhost:9000/Austin-TX-self-storage/Storage-Stall-143170.html" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.102 Safari/537.36" }, "event": "facility_impression", "integrations": {}, "messageId": "ajs-0e04053c20ff0bb66015a4544c141de8", "originalTimestamp": "2018-11-30T20:50:30.919Z", "projectId": "iHhi46PCMy", "properties": { "Hit Timestamp": 1543611030917, "category": "facility list-oonFacilityPage", "env": "development", "facility_id": 156115, "in_network": true, "index": 1, "isReact": true, "label": "facility card", "rank": 1, "search_id": "d2b15c019f1f70df90.97107404", "site_id": -1, "visible_threshold": 70 }, "receivedAt": "2018-11-30T20:50:30.948Z", "sentAt": "2018-11-30T20:50:30.921Z", "timestamp": "2018-11-30T20:50:30.946Z", "type": "track", "userId": "49694265e63088bf892dd42f80399366", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.userAgent": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.facility_id": "string", "properties.in_network": "string", "properties.index": "string", "properties.isReact": "string", "properties.label": "string", "properties.rank": "string", "properties.search_id": "string", "properties.site_id": "string", "properties.visible_threshold": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1110
- schema_scan_id: 4322340
- updated: 2018-11-30 15:00:01
Schema Scans: 4
Last at 2018-12-04 15:16:08
-
Scan 4338765
- duration: 0:00:14.115453
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 3, "partitions_applied": false, "success": true } - id: 4338765
- payload:
{ "datatype_dict": null, "file_format": "json", "partition": { "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/facility_impression/dt=2018-12-04/", "name": "dt", "type": "string", "value": "2018-12-04" }, "s3": { "bucket": "sfdl-segment-reactfoot-dev", "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/facility_impression", "key": "separated_dt/facility_impression/dt=2018-12-04/1543958083678.34a3c25229a4.1.11.1.a5235e70-146e-4b78-9be8-3344af113fd9.gz.json.gz" }, "schema": { "name": "sfdl_dev_segment.reactfoot_facility_impression", "type": "segment" } } - running: False
- schema_name_id: 1110
- start_time: 2018-12-04 15:16:08
- success: True
- trace_id: 3646801742641768124
-
Scan 4338484
- duration: 0:00:16.259701
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 3, "partitions_applied": false, "success": true } - id: 4338484
- payload:
{ "datatype_dict": null, "file_format": "json", "partition": { "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/facility_impression/dt=2018-12-04/", "name": "dt", "type": "string", "value": "2018-12-04" }, "s3": { "bucket": "sfdl-segment-reactfoot-dev", "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/facility_impression", "key": "separated_dt/facility_impression/dt=2018-12-04/1543957167414.cc24d8dd0445.1.11.1.d9487a45-266e-4147-948c-9d2b73fcfef2.gz.json.gz" }, "schema": { "name": "sfdl_dev_segment.reactfoot_facility_impression", "type": "segment" } } - running: False
- schema_name_id: 1110
- start_time: 2018-12-04 15:00:26
- success: True
- trace_id: 346013428025530691
-
Scan 4335767
- duration: 0:00:16.603322
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 2, "partitions_applied": false, "success": true } - id: 4335767
- payload:
{ "datatype_dict": null, "file_format": "json", "partition": { "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/facility_impression/dt=2018-12-03/", "name": "dt", "type": "string", "value": "2018-12-03" }, "s3": { "bucket": "sfdl-segment-reactfoot-dev", "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/facility_impression", "key": "separated_dt/facility_impression/dt=2018-12-03/1543859962983.62735d796fbe.1.11.1.f67f81e9-7f48-48e2-9bed-15ad42cc8174.gz.json.gz" }, "schema": { "name": "sfdl_dev_segment.reactfoot_facility_impression", "type": "segment" } } - running: False
- schema_name_id: 1110
- start_time: 2018-12-03 12:00:56
- success: True
- trace_id: 13884428780275062714
-
Scan 4322340
- duration: 0:00:13.736456
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 1, "partitions_applied": false, "success": true } - id: 4322340
- payload:
{ "datatype_dict": null, "file_format": "json", "partition": { "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/facility_impression/dt=2018-11-30/", "name": "dt", "type": "string", "value": "2018-11-30" }, "s3": { "bucket": "sfdl-segment-reactfoot-dev", "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/facility_impression", "key": "separated_dt/facility_impression/dt=2018-11-30/1543611566724.18855c58f9b7.1.11.1.13bd789c-50f2-4e98-a74d-c3886edc60cb.gz.json.gz" }, "schema": { "name": "sfdl_dev_segment.reactfoot_facility_impression", "type": "segment" } } - running: False
- schema_name_id: 1110
- start_time: 2018-11-30 14:59:50
- success: True
- trace_id: 14608691683091364772
- count: 4
- ddl:
[ "ALTER TABLE\n `sfdl_dev_segment.reactfoot_facility_impression`\nADD\n\n\n PARTITION (dt='2018-12-04') location 's3://sfdl-segment-reactfoot-dev/separated_dt/facility_impression/dt=2018-12-04/'\n PARTITION (dt='2018-12-05') location 's3://sfdl-segment-reactfoot-dev/separated_dt/facility_impression/dt=2018-12-05/'\n PARTITION (dt='2018-12-06') location 's3://sfdl-segment-reactfoot-dev/separated_dt/facility_impression/dt=2018-12-06/'\n PARTITION (dt='2018-12-07') location 's3://sfdl-segment-reactfoot-dev/separated_dt/facility_impression/dt=2018-12-07/'\n;" ] - name: dt
- state:
[ { "info": { "id": 132609, "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/facility_impression/dt=2018-12-04/", "name": "dt", "value": "2018-12-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2018-12-04 10:49:20", "last_data": "2018-12-04 17:43:47" }, "parquet": { "first_performed": "2018-12-04 11:11:55", "in_progress": null, "job_id": null, "last_performed": "2018-12-05 10:52:29", "queued": false } } }, { "info": { "id": 132668, "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/facility_impression/dt=2018-12-05/", "name": "dt", "value": "2018-12-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2018-12-05 10:37:18", "last_data": "2018-12-05 15:43:57" }, "parquet": { "first_performed": "2018-12-05 10:52:29", "in_progress": null, "job_id": null, "last_performed": "2018-12-06 11:50:54", "queued": false } } }, { "info": { "id": 132711, "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/facility_impression/dt=2018-12-06/", "name": "dt", "value": "2018-12-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2018-12-06 11:38:19", "last_data": "2018-12-06 18:55:25" }, "parquet": { "first_performed": "2018-12-06 11:50:54", "in_progress": null, "job_id": null, "last_performed": "2018-12-06 18:57:27", "queued": false } } }, { "info": { "id": 132725, "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/facility_impression/dt=2018-12-07/", "name": "dt", "value": "2018-12-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2018-12-06 18:37:08", "last_data": "2018-12-07 14:45:29" }, "parquet": { "first_performed": "2018-12-06 18:53:20", "in_progress": null, "job_id": null, "last_performed": "2018-12-07 18:57:38", "queued": false } } } ] - type: string
- attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.userAgent": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.facility_id": "string", "properties.in_network": "string", "properties.index": "string", "properties.isReact": "string", "properties.label": "string", "properties.rank": "string", "properties.search_id": "string", "properties.search_id.algorithm": "string", "properties.search_id.bellhopsURL": "string", "properties.search_id.canonicalURL": "string", "properties.search_id.content.blogPosts": "", "properties.search_id.content.cityTotalBookings": "string", "properties.search_id.content.contentId": "string", "properties.search_id.content.contentTemplateId": "string", "properties.search_id.content.drillDownLinks.amenities": " ", "properties.search_id.content.drillDownLinks.universities": " ", "properties.search_id.content.drillDownLinks.vehicleStorage": " ", "properties.search_id.content.formattedStorageType": "string", "properties.search_id.content.movingGuidePosts": " ", "properties.search_id.content.nearbyCities": " ", "properties.search_id.content.popularSqft": "string", "properties.search_id.content.pricingStats": "string", "properties.search_id.error": "string", "properties.search_id.errorMessage": "string", "properties.search_id.experiments.red_716_tracking_prerender": "string", "properties.search_id.experiments.sf_4830_aa_phlag_band_aid": "string", "properties.search_id.experiments.sf_5635_half_nomad": "string", "properties.search_id.experiments.sf_6852_serp_results": "string", "properties.search_id.experiments.sf_7018_upsellit": "string", "properties.search_id.experiments.sf_7046_recommended_facility_badge": "string", "properties.search_id.experiments.sf_7058_two_step_checkout_v2": "string", "properties.search_id.facets.aaaActive": "string", "properties.search_id.facets.aaaEligile": "string", "properties.search_id.facets.alarm": "string", "properties.search_id.facets.amexActive": "string", "properties.search_id.facets.bandPracticeAllowed": "string", "properties.search_id.facets.climateControlled": "string", "properties.search_id.facets.covered": "string", "properties.search_id.facets.directoryFacility": "string", "properties.search_id.facets.driveUp": "string", "properties.search_id.facets.egateAccess": "string", "properties.search_id.facets.elevator": "string", "properties.search_id.facets.fencedLighted": "string", "properties.search_id.facets.floor": "string", "properties.search_id.facets.freeTruckRental": "string", "properties.search_id.facets.handcarts": "string", "properties.search_id.facets.indoor": "string", "properties.search_id.facets.kiosk": "string", "properties.search_id.facets.militaryDiscount": "string", "properties.search_id.facets.outOfNetworkOgf": "string", "properties.search_id.facets.outOfNetworkStoreTrac": "string", "properties.search_id.facets.outdoor": "string", "properties.search_id.facets.penske": "string", "properties.search_id.facets.power": "string", "properties.search_id.facets.prefilterTypeCounts.2": "string", "properties.search_id.facets.prefilterTypeCounts.4": "string", "properties.search_id.facets.prefilterTypes.storage": "string", "properties.search_id.facets.prefilterTypes.vehicle": "string", "properties.search_id.facets.prefilterTypes.warehouseDropoff": "string", "properties.search_id.facets.prefilterTypes.warehouseValet": "string", "properties.search_id.facets.seniorDiscount": "string", "properties.search_id.facets.studentDiscount": "string", "properties.search_id.facets.surveillance": "string", "properties.search_id.facets.truckAccess": "string", "properties.search_id.facets.truckRental": "string", "properties.search_id.facets.twentyFourHourAccess": "string", "properties.search_id.facets.typeOfListing.2": "string", "properties.search_id.facets.typeOfListing.4": "string", "properties.search_id.facets.uncovered": "string", "properties.search_id.facets.vehicle": "string", "properties.search_id.facilities": " ", "properties.search_id.facilitiesPerPage": "string", "properties.search_id.facilityCollection.collection": " ", "properties.search_id.facilityCollection.fullServiceCorpIds": " ", "properties.search_id.facilityCollection.reviewCount": "string", "properties.search_id.facilityCollection.totalFacilityCount": "string", "properties.search_id.facilityCollection.totalFacilityIds": " ", "properties.search_id.facilityCollection.totalUnitCount": "string", "properties.search_id.filters.sqftRange": "string", "properties.search_id.fssFaqs": " ", "properties.search_id.fssResults": "string", "properties.search_id.fssResultsURL": "string", "properties.search_id.headlines.primary": "string", "properties.search_id.headlines.secondary": "string", "properties.search_id.highlightedFacility": "string", "properties.search_id.irmMarket": "string", "properties.search_id.isBellhopsMarket": "string", "properties.search_id.isTabbed": "string", "properties.search_id.landingFacilities": " ", "properties.search_id.landingLocation.city": "string", "properties.search_id.landingLocation.country": "string", "properties.search_id.landingLocation.fullState": "string", "properties.search_id.landingLocation.id": "string", "properties.search_id.landingLocation.latitude": "string", "properties.search_id.landingLocation.longitude": "string", "properties.search_id.landingLocation.state": "string", "properties.search_id.landingLocation.streetAddress": "string", "properties.search_id.landingLocation.subLocality": "string", "properties.search_id.landingLocation.subPageType": "string", "properties.search_id.landingLocation.text": "string", "properties.search_id.landingLocation.zip": "string", "properties.search_id.loading": "string", "properties.search_id.localPhone.localSparephone": "string", "properties.search_id.localPhone.localSparephoneUnformatted": "string", "properties.search_id.localPhone.nationalSparephone": "string", "properties.search_id.localPhone.nationalSparephoneUnformatted": "string", "properties.search_id.location.city": "string", "properties.search_id.location.country": "string", "properties.search_id.location.fullState": "string", "properties.search_id.location.id": "string", "properties.search_id.location.latitude": "string", "properties.search_id.location.longitude": "string", "properties.search_id.location.state": "string", "properties.search_id.location.streetAddress": "string", "properties.search_id.location.subLocality": "string", "properties.search_id.location.subPageType": "string", "properties.search_id.location.text": "string", "properties.search_id.location.zip": "string", "properties.search_id.maxDistance": "string", "properties.search_id.meta.canonical": "string", "properties.search_id.meta.description": "string", "properties.search_id.meta.geo.icbm": "string", "properties.search_id.meta.geo.placeName": "string", "properties.search_id.meta.geo.position": "string", "properties.search_id.meta.geo.region": "string", "properties.search_id.meta.logo": "string", "properties.search_id.meta.noindex": "string", "properties.search_id.meta.title": "string", "properties.search_id.numPages": "string", "properties.search_id.oonFacilities": " ", "properties.search_id.page": "string", "properties.search_id.pageType": "string", "properties.search_id.penskeResults": "string", "properties.search_id.penskeResultsURL": "string", "properties.search_id.penskeURL": "string", "properties.search_id.phone.nationalSparephone": "string", "properties.search_id.phone.nationalSparephoneUnformatted": "string", "properties.search_id.query.distance": "string", "properties.search_id.query.listingsPerPage": "string", "properties.search_id.query.location": "string", "properties.search_id.query.namespace": "string", "properties.search_id.query.truckRental": "string", "properties.search_id.query.variation": "string", "properties.search_id.searchId": "string", "properties.search_id.searchParams.distance": "string", "properties.search_id.searchParams.expandIfLessThan": "string", "properties.search_id.searchParams.ip": "string", "properties.search_id.searchParams.listingsPerPage": "string", "properties.search_id.searchParams.location": "string", "properties.search_id.searchParams.maxDistance": "string", "properties.search_id.searchParams.moveInDate": "string", "properties.search_id.searchParams.namespace": "string", "properties.search_id.searchParams.order": "string", "properties.search_id.searchParams.page": "string", "properties.search_id.searchParams.searchType": "string", "properties.search_id.searchParams.searchType__": "string", "properties.search_id.searchParams.siteId": "string", "properties.search_id.searchParams.sqft": "string", "properties.search_id.searchParams.truckRental": "string", "properties.search_id.searchParams.variation": "string", "properties.search_id.searchParams.visitId": "string", "properties.search_id.searchType": "string", "properties.search_id.seo.canonical": "string", "properties.search_id.staticMapUrl": "string", "properties.search_id.todaysDate": "string", "properties.search_id.totalFacilities": "string", "properties.search_id.totalUnits": "string", "properties.search_id.truckResults": "string", "properties.search_id.truckResultsURL": "string", "properties.search_id.url.city": "string", "properties.search_id.url.fssLanding": "string", "properties.search_id.url.state": "string", "properties.site_id": "string", "properties.visible_threshold": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - created: 2018-12-04 15:16:08
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_facility_impression`\n(\n `version` string , `timestamp` string , `messageId` string , `userId` string , `event` string , `receivedAt` string ,`_metadata` struct< `bundled`:array, `unbundled`:array >, `anonymousId` string , `originalTimestamp` string ,`context` struct< `userAgent` : string ,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >,`library` : struct< `version` : string , `name` : string >, `ip` : string >, `projectId` string , `_origin` string , `type` string ,`properties` struct< `category` : string , `index` : string , `Hit_Timestamp` : string , `in_network` : string , `isReact` : string , `site_id` : string , `rank` : string , `label` : string , `facility_id` : string , `env` : string , `visible_threshold` : string ,`search_id` : struct< `searchId` : string , `canonicalURL` : string , `irmMarket` : string , `facilitiesPerPage` : string , `penskeResults` : string ,`landingLocation` : struct< `city` : string , `zip` : string , `country` : string , `fullState` : string , `state` : string , `longitude` : string , `subPageType` : string , `streetAddress` : string , `text` : string , `latitude` : string , `id` : string , `subLocality` : string >, `fssResults` : string , `facilities`:array ,`meta` : struct< `noindex` : string , `description` : string , `title` : string , `logo` : string ,`geo` : struct< `placeName` : string , `region` : string , `icbm` : string , `position` : string >, `canonical` : string >,`filters` : struct< `sqftRange` : string >,`seo` : struct< `canonical` : string >,`query` : struct< `distance` : string , `truckRental` : string , `namespace` : string , `variation` : string , `location` : string , `listingsPerPage` : string >,`headlines` : struct< `primary` : string , `secondary` : string >, `loading` : string ,`facets` : struct< `penske` : string , `outdoor` : string , `indoor` : string , `aaaActive` : string , `twentyFourHourAccess` : string , `seniorDiscount` : string ,`prefilterTypes` : struct< `warehouseValet` : string , `storage` : string , `warehouseDropoff` : string , `vehicle` : string >, `truckAccess` : string , `handcarts` : string , `uncovered` : string ,`typeOfListing` : struct< `2` : string , `4` : string >, `fencedLighted` : string , `floor` : string , `elevator` : string , `surveillance` : string , `vehicle` : string , `outOfNetworkStoreTrac` : string , `aaaEligile` : string ,`prefilterTypeCounts` : struct< `2` : string , `4` : string >, `power` : string , `kiosk` : string , `climateControlled` : string , `covered` : string , `militaryDiscount` : string , `bandPracticeAllowed` : string , `studentDiscount` : string , `truckRental` : string , `egateAccess` : string , `alarm` : string , `driveUp` : string , `amexActive` : string , `outOfNetworkOgf` : string , `directoryFacility` : string , `freeTruckRental` : string >, `searchType` : string ,`localPhone` : struct< `localSparephone` : string , `nationalSparephone` : string , `nationalSparephoneUnformatted` : string , `localSparephoneUnformatted` : string >, `staticMapUrl` : string ,`content` : struct< `contentTemplateId` : string , `pricingStats` : string , `contentId` : string , `nearbyCities`:array ,`drillDownLinks` : struct< `universities`:array , `amenities`:array , `vehicleStorage`:array >, `movingGuidePosts`:array , `cityTotalBookings` : string , `popularSqft` : string , `formattedStorageType` : string , `blogPosts`:array >, `isTabbed` : string ,`location` : struct< `city` : string , `zip` : string , `country` : string , `fullState` : string , `state` : string , `longitude` : string , `subPageType` : string , `streetAddress` : string , `text` : string , `latitude` : string , `id` : string , `subLocality` : string >,`searchParams` : struct< `distance` : string , `expandIfLessThan` : string , `truckRental` : string , `searchType` : string , `searchType__` : string , `sqft` : string , `moveInDate` : string , `variation` : string , `page` : string , `siteId` : string , `location` : string , `ip` : string , `namespace` : string , `maxDistance` : string , `order` : string , `listingsPerPage` : string , `visitId` : string >, `errorMessage` : string , `totalUnits` : string , `highlightedFacility` : string , `fssResultsURL` : string , `penskeResultsURL` : string , `truckResultsURL` : string , `oonFacilities`:array ,`phone` : struct< `nationalSparephoneUnformatted` : string , `nationalSparephone` : string >, `penskeURL` : string , `pageType` : string , `landingFacilities`:array , `maxDistance` : string , `numPages` : string , `truckResults` : string , `algorithm` : string ,`facilityCollection` : struct< `reviewCount` : string , `totalFacilityCount` : string , `totalFacilityIds`:array , `collection`:array , `totalUnitCount` : string , `fullServiceCorpIds`:array >,`url` : struct< `city` : string , `state` : string , `fssLanding` : string >, `bellhopsURL` : string , `totalFacilities` : string , `isBellhopsMarket` : string , `todaysDate` : string ,`experiments` : struct< `sf_6852_serp_results` : string , `red_716_tracking_prerender` : string , `sf_5635_half_nomad` : string , `sf_7046_recommended_facility_badge` : string , `sf_4830_aa_phlag_band_aid` : string , `sf_7018_upsellit` : string , `sf_7058_two_step_checkout_v2` : string >, `error` : string , `fssFaqs`:array , `page` : string >>, `channel` string , `sentAt` string \n)\nPARTITIONED BY (dt string)\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-segment-reactfoot-dev/separated_dt/facility_impression'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_facility_impression`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_segment.reactfoot_facility_impression" }
- hostname: schemamanager-5447774fc6-4w58v
- name: schema_manager
- process_start: 2026-04-02 21:43:44
- sf_env: dev
- version: 2427328685
{
"name": {
"created": "2018-11-30 14:59:50",
"disabled": false,
"format": "raw",
"id": 1110,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_dev_segment",
"table": "reactfoot_facility_impression"
},
"type": "segment"
},
"partition": {
"count": 4,
"ddl": [
"ALTER TABLE\n `sfdl_dev_segment.reactfoot_facility_impression`\nADD\n\n\n PARTITION (dt='2018-12-04') location 's3://sfdl-segment-reactfoot-dev/separated_dt/facility_impression/dt=2018-12-04/'\n PARTITION (dt='2018-12-05') location 's3://sfdl-segment-reactfoot-dev/separated_dt/facility_impression/dt=2018-12-05/'\n PARTITION (dt='2018-12-06') location 's3://sfdl-segment-reactfoot-dev/separated_dt/facility_impression/dt=2018-12-06/'\n PARTITION (dt='2018-12-07') location 's3://sfdl-segment-reactfoot-dev/separated_dt/facility_impression/dt=2018-12-07/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 132609,
"location": "s3://sfdl-segment-reactfoot-dev/separated_dt/facility_impression/dt=2018-12-04/",
"name": "dt",
"value": "2018-12-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2018-12-04 10:49:20",
"last_data": "2018-12-04 17:43:47"
},
"parquet": {
"first_performed": "2018-12-04 11:11:55",
"in_progress": null,
"job_id": null,
"last_performed": "2018-12-05 10:52:29",
"queued": false
}
}
},
{
"info": {
"id": 132668,
"location": "s3://sfdl-segment-reactfoot-dev/separated_dt/facility_impression/dt=2018-12-05/",
"name": "dt",
"value": "2018-12-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2018-12-05 10:37:18",
"last_data": "2018-12-05 15:43:57"
},
"parquet": {
"first_performed": "2018-12-05 10:52:29",
"in_progress": null,
"job_id": null,
"last_performed": "2018-12-06 11:50:54",
"queued": false
}
}
},
{
"info": {
"id": 132711,
"location": "s3://sfdl-segment-reactfoot-dev/separated_dt/facility_impression/dt=2018-12-06/",
"name": "dt",
"value": "2018-12-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2018-12-06 11:38:19",
"last_data": "2018-12-06 18:55:25"
},
"parquet": {
"first_performed": "2018-12-06 11:50:54",
"in_progress": null,
"job_id": null,
"last_performed": "2018-12-06 18:57:27",
"queued": false
}
}
},
{
"info": {
"id": 132725,
"location": "s3://sfdl-segment-reactfoot-dev/separated_dt/facility_impression/dt=2018-12-07/",
"name": "dt",
"value": "2018-12-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2018-12-06 18:37:08",
"last_data": "2018-12-07 14:45:29"
},
"parquet": {
"first_performed": "2018-12-06 18:53:20",
"in_progress": null,
"job_id": null,
"last_performed": "2018-12-07 18:57:38",
"queued": false
}
}
}
],
"type": "string"
},
"schema": {
"attributes": {
"_origin": "string",
"anonymousId": "string",
"channel": "string",
"context.ip": "string",
"context.library.name": "string",
"context.library.version": "string",
"context.page.path": "string",
"context.page.referrer": "string",
"context.page.search": "string",
"context.page.title": "string",
"context.page.url": "string",
"context.userAgent": "string",
"event": "string",
"messageId": "string",
"originalTimestamp": "string",
"projectId": "string",
"properties.Hit_Timestamp": "string",
"properties.category": "string",
"properties.env": "string",
"properties.facility_id": "string",
"properties.in_network": "string",
"properties.index": "string",
"properties.isReact": "string",
"properties.label": "string",
"properties.rank": "string",
"properties.search_id": "string",
"properties.search_id.algorithm": "string",
"properties.search_id.bellhopsURL": "string",
"properties.search_id.canonicalURL": "string",
"properties.search_id.content.blogPosts": "",
"properties.search_id.content.cityTotalBookings": "string",
"properties.search_id.content.contentId": "string",
"properties.search_id.content.contentTemplateId": "string",
"properties.search_id.content.drillDownLinks.amenities": "",
"properties.search_id.content.drillDownLinks.universities": "",
"properties.search_id.content.drillDownLinks.vehicleStorage": "",
"properties.search_id.content.formattedStorageType": "string",
"properties.search_id.content.movingGuidePosts": "",
"properties.search_id.content.nearbyCities": "",
"properties.search_id.content.popularSqft": "string",
"properties.search_id.content.pricingStats": "string",
"properties.search_id.error": "string",
"properties.search_id.errorMessage": "string",
"properties.search_id.experiments.red_716_tracking_prerender": "string",
"properties.search_id.experiments.sf_4830_aa_phlag_band_aid": "string",
"properties.search_id.experiments.sf_5635_half_nomad": "string",
"properties.search_id.experiments.sf_6852_serp_results": "string",
"properties.search_id.experiments.sf_7018_upsellit": "string",
"properties.search_id.experiments.sf_7046_recommended_facility_badge": "string",
"properties.search_id.experiments.sf_7058_two_step_checkout_v2": "string",
"properties.search_id.facets.aaaActive": "string",
"properties.search_id.facets.aaaEligile": "string",
"properties.search_id.facets.alarm": "string",
"properties.search_id.facets.amexActive": "string",
"properties.search_id.facets.bandPracticeAllowed": "string",
"properties.search_id.facets.climateControlled": "string",
"properties.search_id.facets.covered": "string",
"properties.search_id.facets.directoryFacility": "string",
"properties.search_id.facets.driveUp": "string",
"properties.search_id.facets.egateAccess": "string",
"properties.search_id.facets.elevator": "string",
"properties.search_id.facets.fencedLighted": "string",
"properties.search_id.facets.floor": "string",
"properties.search_id.facets.freeTruckRental": "string",
"properties.search_id.facets.handcarts": "string",
"properties.search_id.facets.indoor": "string",
"properties.search_id.facets.kiosk": "string",
"properties.search_id.facets.militaryDiscount": "string",
"properties.search_id.facets.outOfNetworkOgf": "string",
"properties.search_id.facets.outOfNetworkStoreTrac": "string",
"properties.search_id.facets.outdoor": "string",
"properties.search_id.facets.penske": "string",
"properties.search_id.facets.power": "string",
"properties.search_id.facets.prefilterTypeCounts.2": "string",
"properties.search_id.facets.prefilterTypeCounts.4": "string",
"properties.search_id.facets.prefilterTypes.storage": "string",
"properties.search_id.facets.prefilterTypes.vehicle": "string",
"properties.search_id.facets.prefilterTypes.warehouseDropoff": "string",
"properties.search_id.facets.prefilterTypes.warehouseValet": "string",
"properties.search_id.facets.seniorDiscount": "string",
"properties.search_id.facets.studentDiscount": "string",
"properties.search_id.facets.surveillance": "string",
"properties.search_id.facets.truckAccess": "string",
"properties.search_id.facets.truckRental": "string",
"properties.search_id.facets.twentyFourHourAccess": "string",
"properties.search_id.facets.typeOfListing.2": "string",
"properties.search_id.facets.typeOfListing.4": "string",
"properties.search_id.facets.uncovered": "string",
"properties.search_id.facets.vehicle": "string",
"properties.search_id.facilities": "",
"properties.search_id.facilitiesPerPage": "string",
"properties.search_id.facilityCollection.collection": "",
"properties.search_id.facilityCollection.fullServiceCorpIds": "",
"properties.search_id.facilityCollection.reviewCount": "string",
"properties.search_id.facilityCollection.totalFacilityCount": "string",
"properties.search_id.facilityCollection.totalFacilityIds": "",
"properties.search_id.facilityCollection.totalUnitCount": "string",
"properties.search_id.filters.sqftRange": "string",
"properties.search_id.fssFaqs": "",
"properties.search_id.fssResults": "string",
"properties.search_id.fssResultsURL": "string",
"properties.search_id.headlines.primary": "string",
"properties.search_id.headlines.secondary": "string",
"properties.search_id.highlightedFacility": "string",
"properties.search_id.irmMarket": "string",
"properties.search_id.isBellhopsMarket": "string",
"properties.search_id.isTabbed": "string",
"properties.search_id.landingFacilities": "",
"properties.search_id.landingLocation.city": "string",
"properties.search_id.landingLocation.country": "string",
"properties.search_id.landingLocation.fullState": "string",
"properties.search_id.landingLocation.id": "string",
"properties.search_id.landingLocation.latitude": "string",
"properties.search_id.landingLocation.longitude": "string",
"properties.search_id.landingLocation.state": "string",
"properties.search_id.landingLocation.streetAddress": "string",
"properties.search_id.landingLocation.subLocality": "string",
"properties.search_id.landingLocation.subPageType": "string",
"properties.search_id.landingLocation.text": "string",
"properties.search_id.landingLocation.zip": "string",
"properties.search_id.loading": "string",
"properties.search_id.localPhone.localSparephone": "string",
"properties.search_id.localPhone.localSparephoneUnformatted": "string",
"properties.search_id.localPhone.nationalSparephone": "string",
"properties.search_id.localPhone.nationalSparephoneUnformatted": "string",
"properties.search_id.location.city": "string",
"properties.search_id.location.country": "string",
"properties.search_id.location.fullState": "string",
"properties.search_id.location.id": "string",
"properties.search_id.location.latitude": "string",
"properties.search_id.location.longitude": "string",
"properties.search_id.location.state": "string",
"properties.search_id.location.streetAddress": "string",
"properties.search_id.location.subLocality": "string",
"properties.search_id.location.subPageType": "string",
"properties.search_id.location.text": "string",
"properties.search_id.location.zip": "string",
"properties.search_id.maxDistance": "string",
"properties.search_id.meta.canonical": "string",
"properties.search_id.meta.description": "string",
"properties.search_id.meta.geo.icbm": "string",
"properties.search_id.meta.geo.placeName": "string",
"properties.search_id.meta.geo.position": "string",
"properties.search_id.meta.geo.region": "string",
"properties.search_id.meta.logo": "string",
"properties.search_id.meta.noindex": "string",
"properties.search_id.meta.title": "string",
"properties.search_id.numPages": "string",
"properties.search_id.oonFacilities": "",
"properties.search_id.page": "string",
"properties.search_id.pageType": "string",
"properties.search_id.penskeResults": "string",
"properties.search_id.penskeResultsURL": "string",
"properties.search_id.penskeURL": "string",
"properties.search_id.phone.nationalSparephone": "string",
"properties.search_id.phone.nationalSparephoneUnformatted": "string",
"properties.search_id.query.distance": "string",
"properties.search_id.query.listingsPerPage": "string",
"properties.search_id.query.location": "string",
"properties.search_id.query.namespace": "string",
"properties.search_id.query.truckRental": "string",
"properties.search_id.query.variation": "string",
"properties.search_id.searchId": "string",
"properties.search_id.searchParams.distance": "string",
"properties.search_id.searchParams.expandIfLessThan": "string",
"properties.search_id.searchParams.ip": "string",
"properties.search_id.searchParams.listingsPerPage": "string",
"properties.search_id.searchParams.location": "string",
"properties.search_id.searchParams.maxDistance": "string",
"properties.search_id.searchParams.moveInDate": "string",
"properties.search_id.searchParams.namespace": "string",
"properties.search_id.searchParams.order": "string",
"properties.search_id.searchParams.page": "string",
"properties.search_id.searchParams.searchType": "string",
"properties.search_id.searchParams.searchType__": "string",
"properties.search_id.searchParams.siteId": "string",
"properties.search_id.searchParams.sqft": "string",
"properties.search_id.searchParams.truckRental": "string",
"properties.search_id.searchParams.variation": "string",
"properties.search_id.searchParams.visitId": "string",
"properties.search_id.searchType": "string",
"properties.search_id.seo.canonical": "string",
"properties.search_id.staticMapUrl": "string",
"properties.search_id.todaysDate": "string",
"properties.search_id.totalFacilities": "string",
"properties.search_id.totalUnits": "string",
"properties.search_id.truckResults": "string",
"properties.search_id.truckResultsURL": "string",
"properties.search_id.url.city": "string",
"properties.search_id.url.fssLanding": "string",
"properties.search_id.url.state": "string",
"properties.site_id": "string",
"properties.visible_threshold": "string",
"receivedAt": "string",
"sentAt": "string",
"timestamp": "string",
"type": "string",
"userId": "string",
"version": "string"
},
"created": "2018-12-04 15:16:08",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_facility_impression`\n(\n `version` string , `timestamp` string , `messageId` string , `userId` string , `event` string , `receivedAt` string ,`_metadata` struct< `bundled`:array , `unbundled`:array >, `anonymousId` string , `originalTimestamp` string ,`context` struct< `userAgent` : string ,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >,`library` : struct< `version` : string , `name` : string >, `ip` : string >, `projectId` string , `_origin` string , `type` string ,`properties` struct< `category` : string , `index` : string , `Hit_Timestamp` : string , `in_network` : string , `isReact` : string , `site_id` : string , `rank` : string , `label` : string , `facility_id` : string , `env` : string , `visible_threshold` : string ,`search_id` : struct< `searchId` : string , `canonicalURL` : string , `irmMarket` : string , `facilitiesPerPage` : string , `penskeResults` : string ,`landingLocation` : struct< `city` : string , `zip` : string , `country` : string , `fullState` : string , `state` : string , `longitude` : string , `subPageType` : string , `streetAddress` : string , `text` : string , `latitude` : string , `id` : string , `subLocality` : string >, `fssResults` : string , `facilities`:array ,`meta` : struct< `noindex` : string , `description` : string , `title` : string , `logo` : string ,`geo` : struct< `placeName` : string , `region` : string , `icbm` : string , `position` : string >, `canonical` : string >,`filters` : struct< `sqftRange` : string >,`seo` : struct< `canonical` : string >,`query` : struct< `distance` : string , `truckRental` : string , `namespace` : string , `variation` : string , `location` : string , `listingsPerPage` : string >,`headlines` : struct< `primary` : string , `secondary` : string >, `loading` : string ,`facets` : struct< `penske` : string , `outdoor` : string , `indoor` : string , `aaaActive` : string , `twentyFourHourAccess` : string , `seniorDiscount` : string ,`prefilterTypes` : struct< `warehouseValet` : string , `storage` : string , `warehouseDropoff` : string , `vehicle` : string >, `truckAccess` : string , `handcarts` : string , `uncovered` : string ,`typeOfListing` : struct< `2` : string , `4` : string >, `fencedLighted` : string , `floor` : string , `elevator` : string , `surveillance` : string , `vehicle` : string , `outOfNetworkStoreTrac` : string , `aaaEligile` : string ,`prefilterTypeCounts` : struct< `2` : string , `4` : string >, `power` : string , `kiosk` : string , `climateControlled` : string , `covered` : string , `militaryDiscount` : string , `bandPracticeAllowed` : string , `studentDiscount` : string , `truckRental` : string , `egateAccess` : string , `alarm` : string , `driveUp` : string , `amexActive` : string , `outOfNetworkOgf` : string , `directoryFacility` : string , `freeTruckRental` : string >, `searchType` : string ,`localPhone` : struct< `localSparephone` : string , `nationalSparephone` : string , `nationalSparephoneUnformatted` : string , `localSparephoneUnformatted` : string >, `staticMapUrl` : string ,`content` : struct< `contentTemplateId` : string , `pricingStats` : string , `contentId` : string , `nearbyCities`:array ,`drillDownLinks` : struct< `universities`:array , `amenities`:array , `vehicleStorage`:array >, `movingGuidePosts`:array , `cityTotalBookings` : string , `popularSqft` : string , `formattedStorageType` : string , `blogPosts`:array >, `isTabbed` : string ,`location` : struct< `city` : string , `zip` : string , `country` : string , `fullState` : string , `state` : string , `longitude` : string , `subPageType` : string , `streetAddress` : string , `text` : string , `latitude` : string , `id` : string , `subLocality` : string >,`searchParams` : struct< `distance` : string , `expandIfLessThan` : string , `truckRental` : string , `searchType` : string , `searchType__` : string , `sqft` : string , `moveInDate` : string , `variation` : string , `page` : string , `siteId` : string , `location` : string , `ip` : string , `namespace` : string , `maxDistance` : string , `order` : string , `listingsPerPage` : string , `visitId` : string >, `errorMessage` : string , `totalUnits` : string , `highlightedFacility` : string , `fssResultsURL` : string , `penskeResultsURL` : string , `truckResultsURL` : string , `oonFacilities`:array ,`phone` : struct< `nationalSparephoneUnformatted` : string , `nationalSparephone` : string >, `penskeURL` : string , `pageType` : string , `landingFacilities`:array , `maxDistance` : string , `numPages` : string , `truckResults` : string , `algorithm` : string ,`facilityCollection` : struct< `reviewCount` : string , `totalFacilityCount` : string , `totalFacilityIds`:array , `collection`:array , `totalUnitCount` : string , `fullServiceCorpIds`:array >,`url` : struct< `city` : string , `state` : string , `fssLanding` : string >, `bellhopsURL` : string , `totalFacilities` : string , `isBellhopsMarket` : string , `todaysDate` : string ,`experiments` : struct< `sf_6852_serp_results` : string , `red_716_tracking_prerender` : string , `sf_5635_half_nomad` : string , `sf_7046_recommended_facility_badge` : string , `sf_4830_aa_phlag_band_aid` : string , `sf_7018_upsellit` : string , `sf_7058_two_step_checkout_v2` : string >, `error` : string , `fssFaqs`:array , `page` : string >>, `channel` string , `sentAt` string \n)\nPARTITIONED BY (dt string)\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-segment-reactfoot-dev/separated_dt/facility_impression'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_facility_impression`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_segment.reactfoot_facility_impression"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}