Schema Info

Schema Name: sfdl_dev_segment.reactfoot_product_list_viewed

created: 2017-11-01 17:01:22
disabled: False
format: raw
id: 457
is_partitioned: True
is_schema_datatyped: False

name:

{
    "database": "sfdl_dev_segment",
    "table": "reactfoot_product_list_viewed"
}

type: segment

Schema Versions: 13

Version 4684332

created: 2021-01-19 17:23:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
    "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_product_list_viewed`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_product_list_viewed`\n(\n`integrations`struct<`_empty_`:STRING>,`event`STRING,`version`STRING,`timestamp`STRING,`originalTimestamp`STRING,`receivedAt`STRING,`projectId`STRING,`userId`STRING,`_origin`STRING,`anonymousId`STRING,`properties`struct<`search_id`:STRING,`value`:STRING,`env`:STRING,`searchId`:STRING,`site_id`:STRING,`products`:array>,`position`:STRING,`reviewAverage`:STRING,`id`:STRING>>,`searchTerm`:STRING,`isReact`:STRING,`category`:STRING,`list_id`:STRING,`page`:STRING,`Hit_Timestamp`:STRING,`productIds`:array>,`channel`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`messageId`STRING,`context`struct<`locale`:STRING,`userAgent`:STRING,`page`:struct<`title`:STRING,`search`:STRING,`url`:STRING,`path`:STRING,`referrer`:STRING>,`ip`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING>>,`type`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/Product List Viewed'\n",
    "MSCK REPAIR TABLE sfdl_dev_segment.reactfoot_product_list_viewed"
]

hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed
id: 4684332
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2021-01-19T23:19:33Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1611014400000/1611098133599.a9b5dd643d48.fde281a.5b21dce5-2e2e-4247-9b5f-c02ebd079bb4.gz|segment_separator:34",
    "anonymousId": "54bb8c84-3fde-4666-bfa6-91ec6dd65831",
    "channel": "client",
    "context": {
        "campaign": {},
        "ip": "34.239.223.223",
        "library": {
            "name": "analytics.js",
            "version": "4.0.4"
        },
        "locale": "en-US",
        "page": {
            "path": "/.html",
            "referrer": "http://localhost:9000/",
            "search": "?location=austin%20tx&searchType=storage&order=star_rating_sf&page=1&listingsPerPage=15",
            "title": "10 Cheap Austin TX Self-Storage Facilities | SpareFoot",
            "url": "http://localhost:9000/.html?location=austin%20tx&searchType=storage&order=star_rating_sf&page=1&listingsPerPage=15"
        },
        "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.141 Safari/537.36"
    },
    "event": "Product List Viewed",
    "integrations": {},
    "messageId": "ajs-a3b34933f771fbdded7de74f9c07bb77",
    "originalTimestamp": "2021-01-19T22:16:46.727Z",
    "projectId": "iHhi46PCMy",
    "properties": {
        "Hit Timestamp": 1611094606721,
        "category": "Austin, TX-searchPage",
        "env": "development",
        "isReact": true,
        "list_id": "search results: austin tx",
        "page": 1,
        "productIds": [
            213719,
            213433,
            205886,
            213719,
            63542,
            205937,
            212220,
            213452,
            213660,
            214569,
            156046,
            211055,
            217342,
            218586,
            213453,
            213412
        ],
        "products": [
            {
                "distance": 2.2,
                "hasContactlessBadge": true,
                "hasErentalBadge": true,
                "id": 213593,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Public Storage - Austin - 2121 South IH-35",
                "position": 15,
                "rank": 15,
                "reviewAverage": 4.941,
                "reviewCount": 17,
                "unitCount": 2,
                "units": [
                    {
                        "id": 22222912,
                        "maxBookingDate": "2021-02-15T16:00:48.000Z",
                        "priceValue": 104,
                        "promotion": "$1 first month rent",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            }
        ],
        "searchTerm": "austin tx",
        "search_id": "a4ee60075a4d10b771.89411330",
        "site_id": -1,
        "value": 15
    },
    "receivedAt": "2021-01-19T22:16:47.058Z",
    "sentAt": "2021-01-19T22:16:46.733Z",
    "timestamp": "2021-01-19T22:16:47.052Z",
    "type": "track",
    "userId": "error",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "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.isReact": "string",
    "properties.list_id": "string",
    "properties.page": "string",
    "properties.productIds": [
        "int"
    ],
    "properties.products": [
        {
            "distance": "string",
            "hasContactlessBadge": "string",
            "hasErentalBadge": "string",
            "id": "string",
            "inNetwork": "string",
            "isTopYielder": "string",
            "name": "string",
            "position": "string",
            "rank": "string",
            "reviewAverage": "string",
            "reviewCount": "string",
            "unitCount": "string",
            "units": [
                {
                    "id": "string",
                    "maxBookingDate": "string",
                    "priceValue": "string",
                    "promotion": "string",
                    "sizeText": "string",
                    "squareFootage": "string",
                    "unitTypeText": "string"
                }
            ]
        }
    ],
    "properties.searchId": "string",
    "properties.searchTerm": "string",
    "properties.search_id": "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.contentStats.highestMonth": "string",
    "properties.search_id.content.contentStats.lowestMonth": "string",
    "properties.search_id.content.contentStats.yearlyPriceVariance": "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.averagePrices.10x10.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.10x15.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.10x20.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.5x10.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.5x5.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.overall.price": "string",
    "properties.search_id.content.pricingStats.lowestPrices": "",
    "properties.search_id.content.weather.almanacNormalHigh": "string",
    "properties.search_id.content.weather.almanacNormalLow": "string",
    "properties.search_id.content.weather.almanacRecordHigh": "string",
    "properties.search_id.content.weather.almanacRecordLow": "string",
    "properties.search_id.content.weather.forecastHigh": "string",
    "properties.search_id.content.weather.forecastLow": "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.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.landingFacilities": "",
    "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.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.headline": "string",
    "properties.search_id.meta.logo": "string",
    "properties.search_id.meta.noindex": "string",
    "properties.search_id.meta.tags.links": "",
    "properties.search_id.meta.tags.meta.description": "string",
    "properties.search_id.meta.tags.og.description": "string",
    "properties.search_id.meta.tags.og.image": "string",
    "properties.search_id.meta.tags.og.site": "string",
    "properties.search_id.meta.tags.og.title": "string",
    "properties.search_id.meta.tags.og.url": "string",
    "properties.search_id.meta.tags.title": "string",
    "properties.search_id.meta.title": "string",
    "properties.search_id.meta.uri": "string",
    "properties.search_id.numPages": "string",
    "properties.search_id.oonFacilities": "",
    "properties.search_id.page": "string",
    "properties.search_id.phone.nationalSparephone": "string",
    "properties.search_id.phone.nationalSparephoneUnformatted": "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.namespace": "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.variation": "string",
    "properties.search_id.searchParams.visitId": "string",
    "properties.search_id.searchType": "string",
    "properties.search_id.staticMapUrl": "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.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 457
schema_scan_id: 5744008
updated: 2021-01-19 17:25:45

Version 4684331

created: 2021-01-19 17:20:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
    "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_product_list_viewed`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_product_list_viewed`\n(\n`integrations`struct<`_empty_`:STRING>,`event`STRING,`version`STRING,`timestamp`STRING,`originalTimestamp`STRING,`receivedAt`STRING,`projectId`STRING,`userId`STRING,`_origin`STRING,`anonymousId`STRING,`properties`struct<`search_id`:STRING,`value`:STRING,`page`:STRING,`searchId`:STRING,`site_id`:STRING,`products`:array,`searchTerm`:STRING,`isReact`:STRING,`category`:STRING,`list_id`:STRING,`env`:STRING,`Hit_Timestamp`:STRING,`productIds`:array>,`channel`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`messageId`STRING,`context`struct<`locale`:STRING,`userAgent`:STRING,`page`:struct<`title`:STRING,`search`:STRING,`url`:STRING,`path`:STRING,`referrer`:STRING>,`ip`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING>>,`type`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/Product List Viewed'\n",
    "MSCK REPAIR TABLE sfdl_dev_segment.reactfoot_product_list_viewed"
]

hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed
id: 4684331
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2021-01-19T23:18:07Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1611014400000/1611098122098.7e6817953e19.fde281a.ca0ab7ca-da68-43f2-8bbb-b21993637240.gz|segment_separator:34",
    "anonymousId": "54bb8c84-3fde-4666-bfa6-91ec6dd65831",
    "channel": "client",
    "context": {
        "campaign": {},
        "ip": "34.239.223.223",
        "library": {
            "name": "analytics.js",
            "version": "4.0.4"
        },
        "locale": "en-US",
        "page": {
            "path": "/.html",
            "referrer": "http://localhost:9000/",
            "search": "?location=austin%20tx&searchType=storage&order=price&page=1&listingsPerPage=15",
            "title": "10 Cheap Austin TX Self-Storage Facilities | SpareFoot",
            "url": "http://localhost:9000/.html?location=austin%20tx&searchType=storage&order=price&page=1&listingsPerPage=15"
        },
        "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.141 Safari/537.36"
    },
    "event": "Product List Viewed",
    "integrations": {},
    "messageId": "ajs-ca5bdfcccbc44ae903ae964fb9a03c63",
    "originalTimestamp": "2021-01-19T22:25:34.631Z",
    "projectId": "iHhi46PCMy",
    "properties": {
        "Hit Timestamp": 1611095134629,
        "category": "Austin, TX-searchPage",
        "env": "development",
        "isReact": true,
        "list_id": "search results: austin tx",
        "page": 1,
        "productIds": [
            201698,
            216743,
            201714,
            218409,
            209426,
            218335,
            217342,
            206451,
            205886,
            210550,
            199407,
            203581,
            214569,
            69694,
            205806
        ],
        "products": [
            {
                "distance": 4.7,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 201698,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "US Storage Centers - Austin - 201 West Stassney Lane",
                "position": 1,
                "rank": 1,
                "reviewAverage": 4.708,
                "reviewCount": 36,
                "unitCount": 3,
                "units": [
                    {
                        "id": 18393255,
                        "maxBookingDate": "2021-01-31T03:47:03.000Z",
                        "priceValue": 18.5,
                        "promotion": "1 Month 25% Off (2nd)",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 18393315,
                        "maxBookingDate": "2021-01-31T03:47:03.000Z",
                        "priceValue": 25.5,
                        "promotion": "1 Month 25% Off (2nd)",
                        "sizeText": "10' x 5'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 18393391,
                        "maxBookingDate": "2021-01-31T03:47:03.000Z",
                        "priceValue": 94.5,
                        "promotion": "1 Month 25% Off (2nd)",
                        "sizeText": "20' x 5'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 6.1,
                "hasContactlessBadge": false,
                "hasErentalBadge": true,
                "id": 216743,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "A Mini Storage of Texas",
                "position": 2,
                "rank": 2,
                "reviewAverage": 5,
                "reviewCount": 1,
                "unitCount": 3,
                "units": [
                    {
                        "id": 23001623,
                        "maxBookingDate": "2021-01-22T03:15:31.000Z",
                        "priceValue": 19,
                        "promotion": "FIRST FULL Month Free on select sizes. Call for specials.",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 23001675,
                        "maxBookingDate": "2021-01-22T03:15:31.000Z",
                        "priceValue": 29,
                        "promotion": "FIRST FULL Month Free on select sizes. Call for specials.",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 23001741,
                        "maxBookingDate": "2021-01-22T03:15:31.000Z",
                        "priceValue": 49,
                        "promotion": "FIRST FULL Month Free on select sizes. Call for specials.",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 14,
                "hasContactlessBadge": false,
                "hasErentalBadge": false,
                "id": 201714,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "My Attic Self Storage",
                "position": 3,
                "rank": 3,
                "reviewAverage": 4.887,
                "reviewCount": 31,
                "unitCount": 3,
                "units": [
                    {
                        "id": 21831056,
                        "maxBookingDate": "2020-12-02T04:14:58.000Z",
                        "priceValue": 20,
                        "promotion": "1st full month free",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 21831096,
                        "maxBookingDate": "2020-12-02T04:14:58.000Z",
                        "priceValue": 50,
                        "promotion": "1st full month free",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 21831152,
                        "maxBookingDate": "2020-12-02T04:14:58.000Z",
                        "priceValue": 95,
                        "promotion": "1st full month free",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 14.5,
                "hasContactlessBadge": true,
                "hasErentalBadge": true,
                "id": 218409,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Public Storage - Austin - 2513 Ranch Rd 620 N",
                "position": 4,
                "rank": 4,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 3,
                "units": [
                    {
                        "id": 24105957,
                        "maxBookingDate": "2021-02-16T04:00:23.000Z",
                        "priceValue": 22,
                        "promotion": "$1 first month rent",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 24105947,
                        "maxBookingDate": "2021-02-16T04:00:23.000Z",
                        "priceValue": 38,
                        "promotion": "$1 first month rent",
                        "sizeText": "10' x 5'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 24105951,
                        "maxBookingDate": "2021-02-16T04:00:23.000Z",
                        "priceValue": 90,
                        "promotion": "$1 first month rent",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 11.4,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 209426,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "CubeSmart Self Storage - Pflugerville - 13601 Dessau Rd",
                "position": 5,
                "rank": 5,
                "reviewAverage": 4.813,
                "reviewCount": 16,
                "unitCount": 3,
                "units": [
                    {
                        "id": 24485563,
                        "maxBookingDate": "2021-02-01T04:01:38.000Z",
                        "priceValue": 22.5,
                        "promotion": "25% Off",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 24418623,
                        "maxBookingDate": "2021-02-01T04:01:38.000Z",
                        "priceValue": 35.25,
                        "promotion": "25% Off",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 24485572,
                        "maxBookingDate": "2021-02-01T04:01:38.000Z",
                        "priceValue": 57,
                        "promotion": "25% Off",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 13.4,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 218335,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "CubeSmart Self Storage - TX Austin West Parmer Lane",
                "position": 6,
                "rank": 6,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 3,
                "units": [
                    {
                        "id": 24509826,
                        "maxBookingDate": "2021-02-01T03:30:17.000Z",
                        "priceValue": 24.65,
                        "promotion": "15% Off and First Month Free",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 24272481,
                        "maxBookingDate": "2021-02-01T03:30:17.000Z",
                        "priceValue": 40.8,
                        "promotion": "15% Off and First Month Free",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 24481520,
                        "maxBookingDate": "2021-02-01T03:30:17.000Z",
                        "priceValue": 74.8,
                        "promotion": "15% Off and First Month Free",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 4,
                "hasContactlessBadge": false,
                "hasErentalBadge": false,
                "id": 217342,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Bergstrom Storage",
                "position": 7,
                "rank": 7,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 3,
                "units": [
                    {
                        "id": 23348808,
                        "maxBookingDate": "2021-03-18T01:15:39.000Z",
                        "priceValue": 24,
                        "promotion": "1st full month free",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 23348801,
                        "maxBookingDate": "2021-03-18T01:15:39.000Z",
                        "priceValue": 48,
                        "promotion": "1st full month free",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 23348804,
                        "maxBookingDate": "2021-03-18T01:15:39.000Z",
                        "priceValue": 71,
                        "promotion": "1st full month free",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 4.6,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 206451,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "US Storage Centers - Austin - 5405 Wasson Road",
                "position": 8,
                "rank": 8,
                "reviewAverage": 5,
                "reviewCount": 3,
                "unitCount": 3,
                "units": [
                    {
                        "id": 19684529,
                        "maxBookingDate": "2021-01-22T03:47:44.000Z",
                        "priceValue": 56.5,
                        "promotion": "1 Month 25% Off (1st)",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 19684802,
                        "maxBookingDate": "2021-01-22T03:47:44.000Z",
                        "priceValue": 25.5,
                        "promotion": "1 Month 25% Off (1st)",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 19684690,
                        "maxBookingDate": "2021-01-22T03:47:44.000Z",
                        "priceValue": 48.5,
                        "promotion": "1 Month 25% Off (1st)",
                        "sizeText": "20' x 5'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 4.1,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 205886,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "CubeSmart Self Storage - Austin - 6130 East Ben White Boulevard",
                "position": 9,
                "rank": 9,
                "reviewAverage": 4.783,
                "reviewCount": 46,
                "unitCount": 3,
                "units": [
                    {
                        "id": 24453350,
                        "maxBookingDate": "2021-02-01T00:01:34.000Z",
                        "priceValue": 32.25,
                        "promotion": "25% Off",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 24493905,
                        "maxBookingDate": "2021-02-01T00:01:34.000Z",
                        "priceValue": 47.25,
                        "promotion": "25% Off",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 24485084,
                        "maxBookingDate": "2021-02-01T00:01:34.000Z",
                        "priceValue": 84,
                        "promotion": "25% Off",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 12.4,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 210550,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Life Storage - Austin - 5547 McNeil Drive",
                "position": 10,
                "rank": 10,
                "reviewAverage": 4.523,
                "reviewCount": 43,
                "unitCount": 3,
                "units": [
                    {
                        "id": 21367874,
                        "maxBookingDate": "2021-02-15T03:01:25.000Z",
                        "priceValue": 27,
                        "promotion": "One Month Free!",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 21018963,
                        "maxBookingDate": "2021-02-15T03:01:25.000Z",
                        "priceValue": 32,
                        "promotion": "One Month Free!",
                        "sizeText": "7' x 5'",
                        "squareFootage": 35,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 20945253,
                        "maxBookingDate": "2021-01-30T03:01:25.000Z",
                        "priceValue": 106,
                        "promotion": "One Month Free!",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 8.2,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 199407,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "CubeSmart Self Storage - Austin - 10707 N Interstate Hwy 35",
                "position": 11,
                "rank": 11,
                "reviewAverage": 4.652,
                "reviewCount": 33,
                "unitCount": 3,
                "units": [
                    {
                        "id": 24493692,
                        "maxBookingDate": "2021-02-01T02:17:02.000Z",
                        "priceValue": 27.75,
                        "promotion": "25% Off",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 24484058,
                        "maxBookingDate": "2021-02-01T02:17:02.000Z",
                        "priceValue": 37.5,
                        "promotion": "25% Off",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 24484060,
                        "maxBookingDate": "2021-02-01T02:17:02.000Z",
                        "priceValue": 71.25,
                        "promotion": "25% Off",
                        "sizeText": "5' x 20'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 13,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 203581,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "CubeSmart Self Storage - Austin - 9206 Anderson Mill Rd",
                "position": 12,
                "rank": 12,
                "reviewAverage": 5,
                "reviewCount": 2,
                "unitCount": 3,
                "units": [
                    {
                        "id": 23664082,
                        "maxBookingDate": "2020-08-26T02:52:19.000Z",
                        "priceValue": 27.9,
                        "promotion": "10% Off and Half Off First Month",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 23355991,
                        "maxBookingDate": "2020-08-26T02:52:19.000Z",
                        "priceValue": 53.55,
                        "promotion": "15% Off and First Month Free",
                        "sizeText": "10' x 5'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 23538961,
                        "maxBookingDate": "2020-08-26T02:52:19.000Z",
                        "priceValue": 90.1,
                        "promotion": "15% Off and First Month Free",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 3.5,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 214569,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Life Storage - Austin - 4909 South Interstate 35 Frontage Road",
                "position": 13,
                "rank": 13,
                "reviewAverage": 5,
                "reviewCount": 2,
                "unitCount": 3,
                "units": [
                    {
                        "id": 22395366,
                        "maxBookingDate": "2021-02-15T03:45:43.000Z",
                        "priceValue": 39,
                        "promotion": "One Month Free!",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 22395377,
                        "maxBookingDate": "2021-02-15T03:45:43.000Z",
                        "priceValue": 62,
                        "promotion": "One Month Free!",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 22395395,
                        "maxBookingDate": "2021-02-15T03:45:43.000Z",
                        "priceValue": 101,
                        "promotion": "One Month Free!",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 2.3,
                "hasContactlessBadge": false,
                "hasErentalBadge": false,
                "id": 69694,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Stor Self Storage - South Lamar",
                "position": 14,
                "rank": 14,
                "reviewAverage": 4.833,
                "reviewCount": 6,
                "unitCount": 3,
                "units": [
                    {
                        "id": 15220705,
                        "maxBookingDate": "2021-01-24T00:48:07.000Z",
                        "priceValue": 75,
                        "promotion": "13th Month Free",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 15221563,
                        "maxBookingDate": "2021-01-24T00:48:07.000Z",
                        "priceValue": 95,
                        "promotion": "13th Month Free",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 15230044,
                        "maxBookingDate": "2021-01-24T00:48:07.000Z",
                        "priceValue": 165,
                        "promotion": "13th Month Free",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 3.8,
                "hasContactlessBadge": false,
                "hasErentalBadge": true,
                "id": 205806,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "St. Elmo Storage - 405 St Elmo Road",
                "position": 15,
                "rank": 15,
                "reviewAverage": 4.038,
                "reviewCount": 13,
                "unitCount": 2,
                "units": [
                    {
                        "id": 19424349,
                        "maxBookingDate": "2021-01-20T03:31:56.000Z",
                        "priceValue": 39,
                        "promotion": "Ask about our 2020 Move In Special available on Select Units",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 19424470,
                        "maxBookingDate": "2021-01-20T03:31:56.000Z",
                        "priceValue": 79,
                        "promotion": "Ask about our 2020 Move In Special available on Select Units",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            }
        ],
        "searchTerm": "austin tx",
        "search_id": "4cf460075c5ca1f9f0.21462952",
        "site_id": -1,
        "value": 15
    },
    "receivedAt": "2021-01-19T22:25:35.966Z",
    "sentAt": "2021-01-19T22:25:34.637Z",
    "timestamp": "2021-01-19T22:25:35.960Z",
    "type": "track",
    "userId": "error",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "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.isReact": "string",
    "properties.list_id": "string",
    "properties.page": "string",
    "properties.productIds": [
        "int"
    ],
    "properties.products": [
        "string"
    ],
    "properties.searchId": "string",
    "properties.searchTerm": "string",
    "properties.search_id": "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.contentStats.highestMonth": "string",
    "properties.search_id.content.contentStats.lowestMonth": "string",
    "properties.search_id.content.contentStats.yearlyPriceVariance": "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.averagePrices.10x10.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.10x15.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.10x20.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.5x10.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.5x5.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.overall.price": "string",
    "properties.search_id.content.pricingStats.lowestPrices": "",
    "properties.search_id.content.weather.almanacNormalHigh": "string",
    "properties.search_id.content.weather.almanacNormalLow": "string",
    "properties.search_id.content.weather.almanacRecordHigh": "string",
    "properties.search_id.content.weather.almanacRecordLow": "string",
    "properties.search_id.content.weather.forecastHigh": "string",
    "properties.search_id.content.weather.forecastLow": "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.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.landingFacilities": "",
    "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.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.headline": "string",
    "properties.search_id.meta.logo": "string",
    "properties.search_id.meta.noindex": "string",
    "properties.search_id.meta.tags.links": "",
    "properties.search_id.meta.tags.meta.description": "string",
    "properties.search_id.meta.tags.og.description": "string",
    "properties.search_id.meta.tags.og.image": "string",
    "properties.search_id.meta.tags.og.site": "string",
    "properties.search_id.meta.tags.og.title": "string",
    "properties.search_id.meta.tags.og.url": "string",
    "properties.search_id.meta.tags.title": "string",
    "properties.search_id.meta.title": "string",
    "properties.search_id.meta.uri": "string",
    "properties.search_id.numPages": "string",
    "properties.search_id.oonFacilities": "",
    "properties.search_id.page": "string",
    "properties.search_id.phone.nationalSparephone": "string",
    "properties.search_id.phone.nationalSparephoneUnformatted": "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.namespace": "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.variation": "string",
    "properties.search_id.searchParams.visitId": "string",
    "properties.search_id.searchType": "string",
    "properties.search_id.staticMapUrl": "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.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 457
schema_scan_id: 5743991
updated: 2021-01-19 17:23:09

Version 4684330

created: 2021-01-19 17:17:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
    "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_product_list_viewed`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_product_list_viewed`\n(\n`integrations`struct<`_empty_`:STRING>,`event`STRING,`version`STRING,`timestamp`STRING,`originalTimestamp`STRING,`receivedAt`STRING,`projectId`STRING,`userId`STRING,`_origin`STRING,`anonymousId`STRING,`properties`struct<`search_id`:STRING,`value`:STRING,`searchId`:STRING,`site_id`:STRING,`products`:array,`searchTerm`:STRING,`isReact`:STRING,`productIds`:array,`category`:STRING,`list_id`:STRING,`env`:STRING,`Hit_Timestamp`:STRING,`page`:STRING>,`channel`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`messageId`STRING,`context`struct<`locale`:STRING,`userAgent`:STRING,`page`:struct<`title`:STRING,`search`:STRING,`url`:STRING,`path`:STRING,`referrer`:STRING>,`ip`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING>>,`type`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/Product List Viewed'\n",
    "MSCK REPAIR TABLE sfdl_dev_segment.reactfoot_product_list_viewed"
]

hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed
id: 4684330
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2021-01-19T23:17:30Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1611014400000/1611098120885.ded3d6ab077b.fde281a.dd0d69f4-5d1b-44e7-b19b-08966e739f8d.gz|segment_separator:34",
    "anonymousId": "54bb8c84-3fde-4666-bfa6-91ec6dd65831",
    "channel": "client",
    "context": {
        "campaign": {},
        "ip": "34.239.223.223",
        "library": {
            "name": "analytics.js",
            "version": "4.0.4"
        },
        "locale": "en-US",
        "page": {
            "path": "/search.html",
            "referrer": "http://localhost:9000/",
            "search": "?location=austin%20tx",
            "title": "",
            "url": "http://localhost:9000/search.html?location=austin%20tx"
        },
        "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.141 Safari/537.36"
    },
    "event": "Product List Viewed",
    "integrations": {},
    "messageId": "ajs-08a88e700dca5545072263411c164fde",
    "originalTimestamp": "2021-01-19T22:16:03.201Z",
    "projectId": "iHhi46PCMy",
    "properties": {
        "Hit Timestamp": 1611094562187,
        "env": "development",
        "isReact": true,
        "list_id": "search results: null",
        "page": 1,
        "productIds": [],
        "products": [],
        "searchTerm": null,
        "search_id": null,
        "site_id": -1,
        "value": 0
    },
    "receivedAt": "2021-01-19T22:16:03.953Z",
    "sentAt": "2021-01-19T22:16:03.210Z",
    "timestamp": "2021-01-19T22:16:03.944Z",
    "type": "track",
    "userId": "error",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "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.isReact": "string",
    "properties.list_id": "string",
    "properties.page": "string",
    "properties.productIds": [
        "string"
    ],
    "properties.products": [
        "string"
    ],
    "properties.searchId": "string",
    "properties.searchTerm": "string",
    "properties.search_id": "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.contentStats.highestMonth": "string",
    "properties.search_id.content.contentStats.lowestMonth": "string",
    "properties.search_id.content.contentStats.yearlyPriceVariance": "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.averagePrices.10x10.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.10x15.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.10x20.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.5x10.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.5x5.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.overall.price": "string",
    "properties.search_id.content.pricingStats.lowestPrices": "",
    "properties.search_id.content.weather.almanacNormalHigh": "string",
    "properties.search_id.content.weather.almanacNormalLow": "string",
    "properties.search_id.content.weather.almanacRecordHigh": "string",
    "properties.search_id.content.weather.almanacRecordLow": "string",
    "properties.search_id.content.weather.forecastHigh": "string",
    "properties.search_id.content.weather.forecastLow": "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.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.landingFacilities": "",
    "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.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.headline": "string",
    "properties.search_id.meta.logo": "string",
    "properties.search_id.meta.noindex": "string",
    "properties.search_id.meta.tags.links": "",
    "properties.search_id.meta.tags.meta.description": "string",
    "properties.search_id.meta.tags.og.description": "string",
    "properties.search_id.meta.tags.og.image": "string",
    "properties.search_id.meta.tags.og.site": "string",
    "properties.search_id.meta.tags.og.title": "string",
    "properties.search_id.meta.tags.og.url": "string",
    "properties.search_id.meta.tags.title": "string",
    "properties.search_id.meta.title": "string",
    "properties.search_id.meta.uri": "string",
    "properties.search_id.numPages": "string",
    "properties.search_id.oonFacilities": "",
    "properties.search_id.page": "string",
    "properties.search_id.phone.nationalSparephone": "string",
    "properties.search_id.phone.nationalSparephoneUnformatted": "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.namespace": "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.variation": "string",
    "properties.search_id.searchParams.visitId": "string",
    "properties.search_id.searchType": "string",
    "properties.search_id.staticMapUrl": "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.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 457
schema_scan_id: 5743979
updated: 2021-01-19 17:20:28

Version 4684329

created: 2021-01-19 17:07:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
    "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_product_list_viewed`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_product_list_viewed`\n(\n`integrations`struct<`_empty_`:STRING>,`event`STRING,`version`STRING,`timestamp`STRING,`originalTimestamp`STRING,`receivedAt`STRING,`projectId`STRING,`userId`STRING,`_origin`STRING,`anonymousId`STRING,`properties`struct<`search_id`:STRING,`value`:STRING,`env`:STRING,`searchId`:STRING,`site_id`:STRING,`products`:array>,`position`:STRING,`reviewAverage`:STRING,`id`:STRING>>,`searchTerm`:STRING,`isReact`:STRING,`category`:STRING,`list_id`:STRING,`page`:STRING,`Hit_Timestamp`:STRING,`productIds`:array>,`channel`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`messageId`STRING,`context`struct<`locale`:STRING,`userAgent`:STRING,`page`:struct<`title`:STRING,`search`:STRING,`url`:STRING,`path`:STRING,`referrer`:STRING>,`ip`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING>>,`type`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/Product List Viewed'\n",
    "MSCK REPAIR TABLE sfdl_dev_segment.reactfoot_product_list_viewed"
]

hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed
id: 4684329
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2021-01-19T23:07:07Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1611014400000/1611097416438.db7aa8f52935.fde281a.e69994b7-ea6b-4690-be9c-e604fd094deb.gz|segment_separator:34",
    "anonymousId": "54bb8c84-3fde-4666-bfa6-91ec6dd65831",
    "channel": "client",
    "context": {
        "campaign": {},
        "ip": "34.239.223.223",
        "library": {
            "name": "analytics.js",
            "version": "4.0.4"
        },
        "locale": "en-US",
        "page": {
            "path": "/.html",
            "referrer": "http://localhost:9000/",
            "search": "?location=austin%20tx&searchType=storage&order=distance&page=1&listingsPerPage=15",
            "title": "10 Cheap Austin TX Self-Storage Facilities | SpareFoot",
            "url": "http://localhost:9000/.html?location=austin%20tx&searchType=storage&order=distance&page=1&listingsPerPage=15"
        },
        "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.141 Safari/537.36"
    },
    "event": "Product List Viewed",
    "integrations": {},
    "messageId": "ajs-0eab829253f8ad5a52ed04cd323f8ddd",
    "originalTimestamp": "2021-01-19T22:25:44.271Z",
    "projectId": "iHhi46PCMy",
    "properties": {
        "Hit Timestamp": 1611095144269,
        "category": "Austin, TX-searchPage",
        "env": "development",
        "isReact": true,
        "list_id": "search results: austin tx",
        "page": 1,
        "productIds": [
            213719,
            213433,
            205886,
            213719,
            63542,
            205937,
            212220,
            213452,
            213660,
            214569,
            156046,
            211055,
            217342,
            218586,
            213453,
            213412
        ],
        "products": [
            {
                "distance": 3.6,
                "hasContactlessBadge": true,
                "hasErentalBadge": true,
                "id": 213535,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Public Storage - Austin - 2301 E Ben White Blvd",
                "position": 15,
                "rank": 15,
                "reviewAverage": 4.474,
                "reviewCount": 19,
                "unitCount": 3,
                "units": [
                    {
                        "id": 22911926,
                        "maxBookingDate": "2021-02-16T02:46:07.000Z",
                        "priceValue": 92,
                        "promotion": "$1 first month rent",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            }
        ],
        "searchTerm": "austin tx",
        "search_id": "f6ec60075c6643f521.93043539",
        "site_id": -1,
        "value": 15
    },
    "receivedAt": "2021-01-19T22:25:44.580Z",
    "sentAt": "2021-01-19T22:25:44.277Z",
    "timestamp": "2021-01-19T22:25:44.574Z",
    "type": "track",
    "userId": "error",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "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.isReact": "string",
    "properties.list_id": "string",
    "properties.page": "string",
    "properties.productIds": [
        "int"
    ],
    "properties.products": [
        {
            "distance": "string",
            "hasContactlessBadge": "string",
            "hasErentalBadge": "string",
            "id": "string",
            "inNetwork": "string",
            "isTopYielder": "string",
            "name": "string",
            "position": "string",
            "rank": "string",
            "reviewAverage": "string",
            "reviewCount": "string",
            "unitCount": "string",
            "units": [
                {
                    "id": "string",
                    "maxBookingDate": "string",
                    "priceValue": "string",
                    "promotion": "string",
                    "sizeText": "string",
                    "squareFootage": "string",
                    "unitTypeText": "string"
                }
            ]
        }
    ],
    "properties.searchId": "string",
    "properties.searchTerm": "string",
    "properties.search_id": "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.contentStats.highestMonth": "string",
    "properties.search_id.content.contentStats.lowestMonth": "string",
    "properties.search_id.content.contentStats.yearlyPriceVariance": "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.averagePrices.10x10.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.10x15.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.10x20.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.5x10.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.5x5.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.overall.price": "string",
    "properties.search_id.content.pricingStats.lowestPrices": "",
    "properties.search_id.content.weather.almanacNormalHigh": "string",
    "properties.search_id.content.weather.almanacNormalLow": "string",
    "properties.search_id.content.weather.almanacRecordHigh": "string",
    "properties.search_id.content.weather.almanacRecordLow": "string",
    "properties.search_id.content.weather.forecastHigh": "string",
    "properties.search_id.content.weather.forecastLow": "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.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.landingFacilities": "",
    "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.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.headline": "string",
    "properties.search_id.meta.logo": "string",
    "properties.search_id.meta.noindex": "string",
    "properties.search_id.meta.tags.links": "",
    "properties.search_id.meta.tags.meta.description": "string",
    "properties.search_id.meta.tags.og.description": "string",
    "properties.search_id.meta.tags.og.image": "string",
    "properties.search_id.meta.tags.og.site": "string",
    "properties.search_id.meta.tags.og.title": "string",
    "properties.search_id.meta.tags.og.url": "string",
    "properties.search_id.meta.tags.title": "string",
    "properties.search_id.meta.title": "string",
    "properties.search_id.meta.uri": "string",
    "properties.search_id.numPages": "string",
    "properties.search_id.oonFacilities": "",
    "properties.search_id.page": "string",
    "properties.search_id.phone.nationalSparephone": "string",
    "properties.search_id.phone.nationalSparephoneUnformatted": "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.namespace": "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.variation": "string",
    "properties.search_id.searchParams.visitId": "string",
    "properties.search_id.searchType": "string",
    "properties.search_id.staticMapUrl": "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.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 457
schema_scan_id: 5743946
updated: 2021-01-19 17:10:14

Version 4684328

created: 2021-01-19 16:15:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
    "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_product_list_viewed`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_product_list_viewed`\n(\n`integrations`struct<`_empty_`:STRING>,`event`STRING,`version`STRING,`timestamp`STRING,`originalTimestamp`STRING,`receivedAt`STRING,`projectId`STRING,`userId`STRING,`_origin`STRING,`anonymousId`STRING,`properties`struct<`search_id`:STRING,`value`:STRING,`page`:STRING,`searchId`:STRING,`site_id`:STRING,`products`:array,`searchTerm`:STRING,`isReact`:STRING,`category`:STRING,`list_id`:STRING,`env`:STRING,`Hit_Timestamp`:STRING,`productIds`:array>,`channel`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`messageId`STRING,`context`struct<`locale`:STRING,`userAgent`:STRING,`page`:struct<`title`:STRING,`search`:STRING,`url`:STRING,`path`:STRING,`referrer`:STRING>,`ip`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING>>,`type`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/Product List Viewed'\n",
    "MSCK REPAIR TABLE sfdl_dev_segment.reactfoot_product_list_viewed"
]

hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed
id: 4684328
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2021-01-19T22:15:34Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1611014400000/1611094516353.dd4b770bc6c6.fde281a.d0cc62f4-1637-472f-8f0a-f6fddcbcb446.gz|segment_separator:34",
    "anonymousId": "03bb5652-24ae-4b7b-a4f4-93be13695ccd",
    "channel": "client",
    "context": {
        "campaign": {},
        "ip": "34.239.223.223",
        "library": {
            "name": "analytics.js",
            "version": "4.0.4"
        },
        "locale": "en-US",
        "page": {
            "path": "/Austin-TX-self-storage.html",
            "referrer": "http://localhost:9000/",
            "search": "?location=Austin%2C%20TX%2C%20USA",
            "title": "15 Cheap Storage Units Austin, TX (from $19) | Compare & Save",
            "url": "http://localhost:9000/Austin-TX-self-storage.html?location=Austin%2C%20TX%2C%20USA"
        },
        "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36"
    },
    "event": "Product List Viewed",
    "integrations": {},
    "messageId": "ajs-a7ecc55310f2db98b13c729aed6ad260",
    "originalTimestamp": "2021-01-19T22:12:47.100Z",
    "projectId": "iHhi46PCMy",
    "properties": {
        "Hit Timestamp": 1611094366279,
        "category": "Austin, TX-searchPage",
        "env": "development",
        "isReact": true,
        "list_id": "search results: Austin, TX, USA",
        "page": 1,
        "productIds": [
            213660,
            213719,
            213433,
            213660,
            211055,
            212220,
            205886,
            63542,
            205937,
            213452,
            156046,
            214569,
            213453,
            217342,
            70392,
            209426
        ],
        "products": [
            {
                "distance": 13.3,
                "hasContactlessBadge": true,
                "hasErentalBadge": true,
                "id": 213660,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Public Storage - Austin - 13675 N US Highway 183",
                "position": 1,
                "rank": 1,
                "reviewAverage": 4.698,
                "reviewCount": 53,
                "unitCount": 3,
                "units": [
                    {
                        "id": 22222395,
                        "maxBookingDate": "2021-02-16T01:45:58.000Z",
                        "priceValue": 34,
                        "promotion": "$1 first month rent",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 22222475,
                        "maxBookingDate": "2021-02-16T01:45:58.000Z",
                        "priceValue": 58,
                        "promotion": "$1 first month rent",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 22222460,
                        "maxBookingDate": "2021-02-16T01:45:58.000Z",
                        "priceValue": 90,
                        "promotion": "$1 first month rent",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 1.8,
                "hasContactlessBadge": true,
                "hasErentalBadge": true,
                "id": 213719,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Public Storage - Austin - 1800 S Lamar Blvd",
                "position": 2,
                "rank": 2,
                "reviewAverage": 4.554,
                "reviewCount": 28,
                "unitCount": 3,
                "units": [
                    {
                        "id": 22221361,
                        "maxBookingDate": "2021-02-15T21:45:57.000Z",
                        "priceValue": 54,
                        "promotion": "$1 first month rent",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 22221347,
                        "maxBookingDate": "2021-02-15T21:45:57.000Z",
                        "priceValue": 82,
                        "promotion": "$1 first month rent",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 22221357,
                        "maxBookingDate": "2021-02-15T21:45:57.000Z",
                        "priceValue": 128,
                        "promotion": "$1 first month rent",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 3.7,
                "hasContactlessBadge": true,
                "hasErentalBadge": true,
                "id": 213433,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Public Storage - Austin - 4202 Santiago Street",
                "position": 3,
                "rank": 3,
                "reviewAverage": 4.71,
                "reviewCount": 31,
                "unitCount": 3,
                "units": [
                    {
                        "id": 22221143,
                        "maxBookingDate": "2021-02-16T03:30:55.000Z",
                        "priceValue": 42,
                        "promotion": "$1 first month rent",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 22221141,
                        "maxBookingDate": "2021-02-16T03:30:55.000Z",
                        "priceValue": 64,
                        "promotion": "$1 first month rent",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 22221159,
                        "maxBookingDate": "2021-02-16T03:30:55.000Z",
                        "priceValue": 86,
                        "promotion": "$1 first month rent",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 13.3,
                "id": 213660,
                "inNetwork": true,
                "isTopYielder": true,
                "name": "Public Storage - Austin - 13675 N US Highway 183",
                "position": 4,
                "rank": 4,
                "reviewAverage": 4.698,
                "reviewCount": 53,
                "unitCount": 3,
                "units": [
                    {},
                    {},
                    {}
                ]
            },
            {
                "distance": 11.1,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 211055,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "CubeSmart Self Storage - Pflugerville - 2220 E Howard Ln",
                "position": 5,
                "rank": 5,
                "reviewAverage": 4,
                "reviewCount": 1,
                "unitCount": 3,
                "units": [
                    {
                        "id": 24169999,
                        "maxBookingDate": "2021-02-16T02:01:27.000Z",
                        "priceValue": 30,
                        "promotion": "25% Off",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 24201030,
                        "maxBookingDate": "2021-02-16T02:01:27.000Z",
                        "priceValue": 39.75,
                        "promotion": "25% Off",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 24197080,
                        "maxBookingDate": "2021-02-16T02:01:27.000Z",
                        "priceValue": 78,
                        "promotion": "25% Off",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 7.2,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 212220,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Northgate Storage",
                "position": 6,
                "rank": 6,
                "reviewAverage": 4.929,
                "reviewCount": 14,
                "unitCount": 2,
                "units": [
                    {
                        "id": 21718450,
                        "maxBookingDate": "2021-03-18T00:31:05.000Z",
                        "priceValue": 52,
                        "promotion": "1st Full Month Free",
                        "sizeText": "10' x 5'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 21718272,
                        "maxBookingDate": "2021-03-18T00:31:05.000Z",
                        "priceValue": 88,
                        "promotion": "1st Full Month Free",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 4.1,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 205886,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "CubeSmart Self Storage - Austin - 6130 East Ben White Boulevard",
                "position": 7,
                "rank": 7,
                "reviewAverage": 4.783,
                "reviewCount": 46,
                "unitCount": 3,
                "units": [
                    {
                        "id": 24453350,
                        "maxBookingDate": "2021-02-01T00:01:34.000Z",
                        "priceValue": 32.25,
                        "promotion": "25% Off",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 24493905,
                        "maxBookingDate": "2021-02-01T00:01:34.000Z",
                        "priceValue": 47.25,
                        "promotion": "25% Off",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 24485084,
                        "maxBookingDate": "2021-02-01T00:01:34.000Z",
                        "priceValue": 84,
                        "promotion": "25% Off",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 4.8,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 63542,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "CubeSmart Self Storage - Austin - 610 E Stassney Ln",
                "position": 8,
                "rank": 8,
                "reviewAverage": 4.57,
                "reviewCount": 43,
                "unitCount": 3,
                "units": [
                    {
                        "id": 24489276,
                        "maxBookingDate": "2021-02-01T03:33:19.000Z",
                        "priceValue": 39.75,
                        "promotion": "25% Off",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 24448962,
                        "maxBookingDate": "2021-02-01T03:33:19.000Z",
                        "priceValue": 59.25,
                        "promotion": "25% Off",
                        "sizeText": "10' x 5'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 24489277,
                        "maxBookingDate": "2021-02-01T03:33:19.000Z",
                        "priceValue": 84,
                        "promotion": "25% Off",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 4.9,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 205937,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "ATX Self Storage",
                "position": 9,
                "rank": 9,
                "reviewAverage": 4.816,
                "reviewCount": 49,
                "unitCount": 3,
                "units": [
                    {
                        "id": 21827860,
                        "maxBookingDate": "2021-02-16T03:16:42.000Z",
                        "priceValue": 31,
                        "promotion": "50% Off 1st Full Month",
                        "sizeText": "5' x 4'",
                        "squareFootage": 20,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 21827883,
                        "maxBookingDate": "2021-02-16T03:16:42.000Z",
                        "priceValue": 55,
                        "promotion": "50% Off 1st Full Month",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 21827942,
                        "maxBookingDate": "2021-02-16T03:16:42.000Z",
                        "priceValue": 104,
                        "promotion": "50% Off 1st Full Month",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 6,
                "hasContactlessBadge": true,
                "hasErentalBadge": true,
                "id": 213452,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Public Storage - Austin - 7200 S 1st Street",
                "position": 10,
                "rank": 10,
                "reviewAverage": 4.808,
                "reviewCount": 26,
                "unitCount": 3,
                "units": [
                    {
                        "id": 22222063,
                        "maxBookingDate": "2021-02-16T03:30:55.000Z",
                        "priceValue": 38,
                        "promotion": "$1 first month rent",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 22222062,
                        "maxBookingDate": "2021-02-16T03:30:55.000Z",
                        "priceValue": 62,
                        "promotion": "$1 first month rent",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 22222065,
                        "maxBookingDate": "2021-02-16T03:30:55.000Z",
                        "priceValue": 104,
                        "promotion": "$1 first month rent",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 5.7,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 156046,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "CubeSmart Self Storage - Austin - 1905 E William Cannon Dr",
                "position": 11,
                "rank": 11,
                "reviewAverage": 4.25,
                "reviewCount": 16,
                "unitCount": 3,
                "units": [
                    {
                        "id": 24348930,
                        "maxBookingDate": "2021-02-01T03:17:32.000Z",
                        "priceValue": 42.75,
                        "promotion": "25% Off",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 24483351,
                        "maxBookingDate": "2021-02-01T03:17:32.000Z",
                        "priceValue": 57,
                        "promotion": "25% Off",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 24483353,
                        "maxBookingDate": "2021-02-01T03:17:32.000Z",
                        "priceValue": 84,
                        "promotion": "25% Off",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 3.5,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 214569,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Life Storage - Austin - 4909 South Interstate 35 Frontage Road",
                "position": 12,
                "rank": 12,
                "reviewAverage": 5,
                "reviewCount": 2,
                "unitCount": 3,
                "units": [
                    {
                        "id": 22395366,
                        "maxBookingDate": "2021-02-15T03:45:43.000Z",
                        "priceValue": 39,
                        "promotion": "One Month Free!",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 22395377,
                        "maxBookingDate": "2021-02-15T03:45:43.000Z",
                        "priceValue": 62,
                        "promotion": "One Month Free!",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 22395395,
                        "maxBookingDate": "2021-02-15T03:45:43.000Z",
                        "priceValue": 101,
                        "promotion": "One Month Free!",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 6,
                "hasContactlessBadge": true,
                "hasErentalBadge": true,
                "id": 213453,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Public Storage - Austin - 8101 N Lamar Blvd",
                "position": 13,
                "rank": 13,
                "reviewAverage": 4.649,
                "reviewCount": 47,
                "unitCount": 3,
                "units": [
                    {
                        "id": 22224698,
                        "maxBookingDate": "2021-02-16T03:30:55.000Z",
                        "priceValue": 32,
                        "promotion": "$1 first month rent",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 22224659,
                        "maxBookingDate": "2021-02-16T03:30:55.000Z",
                        "priceValue": 42,
                        "promotion": "$1 first month rent",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 22224639,
                        "maxBookingDate": "2021-02-16T03:30:55.000Z",
                        "priceValue": 84,
                        "promotion": "$1 first month rent",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 4,
                "hasContactlessBadge": false,
                "hasErentalBadge": false,
                "id": 217342,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Bergstrom Storage",
                "position": 14,
                "rank": 14,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 3,
                "units": [
                    {
                        "id": 23348808,
                        "maxBookingDate": "2021-03-18T01:15:39.000Z",
                        "priceValue": 24,
                        "promotion": "1st full month free",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 23348801,
                        "maxBookingDate": "2021-03-18T01:15:39.000Z",
                        "priceValue": 48,
                        "promotion": "1st full month free",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 23348804,
                        "maxBookingDate": "2021-03-18T01:15:39.000Z",
                        "priceValue": 71,
                        "promotion": "1st full month free",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 14,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 70392,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "StorageMart - FM 1325 & Shoreline Dr",
                "position": 15,
                "rank": 15,
                "reviewAverage": 4.418,
                "reviewCount": 147,
                "unitCount": 3,
                "units": [
                    {
                        "id": 20598531,
                        "maxBookingDate": "2021-01-31T03:48:14.000Z",
                        "priceValue": 34.99,
                        "promotion": "First Month FREE",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 20598530,
                        "maxBookingDate": "2021-01-31T03:48:14.000Z",
                        "priceValue": 47.99,
                        "promotion": "First Month FREE",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 20559571,
                        "maxBookingDate": "2021-01-31T03:48:14.000Z",
                        "priceValue": 64.99,
                        "promotion": "First Month FREE",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 11.4,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 209426,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "CubeSmart Self Storage - Pflugerville - 13601 Dessau Rd",
                "position": 16,
                "rank": 16,
                "reviewAverage": 4.813,
                "reviewCount": 16,
                "unitCount": 3,
                "units": [
                    {
                        "id": 24485563,
                        "maxBookingDate": "2021-02-01T04:01:38.000Z",
                        "priceValue": 22.5,
                        "promotion": "25% Off",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 24418623,
                        "maxBookingDate": "2021-02-01T04:01:38.000Z",
                        "priceValue": 35.25,
                        "promotion": "25% Off",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 24485572,
                        "maxBookingDate": "2021-02-01T04:01:38.000Z",
                        "priceValue": 57,
                        "promotion": "25% Off",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            }
        ],
        "searchTerm": "Austin, TX, USA",
        "search_id": "8af26007595b4c5d18.14186511",
        "site_id": -1,
        "value": 16
    },
    "receivedAt": "2021-01-19T22:12:47.715Z",
    "sentAt": "2021-01-19T22:12:47.107Z",
    "timestamp": "2021-01-19T22:12:47.708Z",
    "type": "track",
    "userId": "error",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "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.isReact": "string",
    "properties.list_id": "string",
    "properties.page": "string",
    "properties.productIds": [
        "int"
    ],
    "properties.products": [
        "string"
    ],
    "properties.searchId": "string",
    "properties.searchTerm": "string",
    "properties.search_id": "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.contentStats.highestMonth": "string",
    "properties.search_id.content.contentStats.lowestMonth": "string",
    "properties.search_id.content.contentStats.yearlyPriceVariance": "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.averagePrices.10x10.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.10x15.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.10x20.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.5x10.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.5x5.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.overall.price": "string",
    "properties.search_id.content.pricingStats.lowestPrices": "",
    "properties.search_id.content.weather.almanacNormalHigh": "string",
    "properties.search_id.content.weather.almanacNormalLow": "string",
    "properties.search_id.content.weather.almanacRecordHigh": "string",
    "properties.search_id.content.weather.almanacRecordLow": "string",
    "properties.search_id.content.weather.forecastHigh": "string",
    "properties.search_id.content.weather.forecastLow": "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.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.landingFacilities": "",
    "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.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.headline": "string",
    "properties.search_id.meta.logo": "string",
    "properties.search_id.meta.noindex": "string",
    "properties.search_id.meta.tags.links": "",
    "properties.search_id.meta.tags.meta.description": "string",
    "properties.search_id.meta.tags.og.description": "string",
    "properties.search_id.meta.tags.og.image": "string",
    "properties.search_id.meta.tags.og.site": "string",
    "properties.search_id.meta.tags.og.title": "string",
    "properties.search_id.meta.tags.og.url": "string",
    "properties.search_id.meta.tags.title": "string",
    "properties.search_id.meta.title": "string",
    "properties.search_id.meta.uri": "string",
    "properties.search_id.numPages": "string",
    "properties.search_id.oonFacilities": "",
    "properties.search_id.page": "string",
    "properties.search_id.phone.nationalSparephone": "string",
    "properties.search_id.phone.nationalSparephoneUnformatted": "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.namespace": "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.variation": "string",
    "properties.search_id.searchParams.visitId": "string",
    "properties.search_id.searchType": "string",
    "properties.search_id.staticMapUrl": "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.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 457
schema_scan_id: 5743839
updated: 2021-01-19 16:18:20

Version 4684327

created: 2021-01-19 15:27:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
    "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_product_list_viewed`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_product_list_viewed`\n(\n`integrations`struct<`_empty_`:STRING>,`event`STRING,`version`STRING,`timestamp`STRING,`originalTimestamp`STRING,`receivedAt`STRING,`projectId`STRING,`userId`STRING,`_origin`STRING,`anonymousId`STRING,`properties`struct<`search_id`:STRING,`value`:STRING,`searchId`:STRING,`site_id`:STRING,`products`:array,`searchTerm`:STRING,`isReact`:STRING,`productIds`:array,`category`:STRING,`list_id`:STRING,`env`:STRING,`Hit_Timestamp`:STRING,`page`:STRING>,`channel`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`messageId`STRING,`context`struct<`locale`:STRING,`userAgent`:STRING,`page`:struct<`title`:STRING,`search`:STRING,`url`:STRING,`path`:STRING,`referrer`:STRING>,`ip`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING>>,`type`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/Product List Viewed'\n",
    "MSCK REPAIR TABLE sfdl_dev_segment.reactfoot_product_list_viewed"
]

hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed
id: 4684327
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2021-01-19T21:26:56Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1611014400000/1611090943768.8bcaf413aec8.fde281a.93f57f20-a216-4ffd-bdd4-2b32b8d7e5f5.gz|segment_separator:34",
    "anonymousId": "54bb8c84-3fde-4666-bfa6-91ec6dd65831",
    "channel": "client",
    "context": {
        "campaign": {},
        "ip": "34.239.223.223",
        "library": {
            "name": "analytics.js",
            "version": "4.0.4"
        },
        "locale": "en-US",
        "page": {
            "path": "/search.html",
            "referrer": "http://localhost:9000/",
            "search": "?location=austin%20tx",
            "title": "",
            "url": "http://localhost:9000/search.html?location=austin%20tx"
        },
        "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.141 Safari/537.36"
    },
    "event": "Product List Viewed",
    "integrations": {},
    "messageId": "ajs-09b0fcd0c742f3771926b2b8b5c5e889",
    "originalTimestamp": "2021-01-19T20:58:00.267Z",
    "projectId": "iHhi46PCMy",
    "properties": {
        "Hit Timestamp": 1611089880063,
        "env": "development",
        "isReact": true,
        "list_id": "search results: null",
        "page": 1,
        "productIds": [],
        "products": [],
        "searchTerm": null,
        "search_id": null,
        "site_id": -1,
        "value": 0
    },
    "receivedAt": "2021-01-19T20:58:00.915Z",
    "sentAt": "2021-01-19T20:58:00.270Z",
    "timestamp": "2021-01-19T20:58:00.912Z",
    "type": "track",
    "userId": "error",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "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.isReact": "string",
    "properties.list_id": "string",
    "properties.page": "string",
    "properties.productIds": [
        "string"
    ],
    "properties.products": [
        "string"
    ],
    "properties.searchId": "string",
    "properties.searchTerm": "string",
    "properties.search_id": "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.contentStats.highestMonth": "string",
    "properties.search_id.content.contentStats.lowestMonth": "string",
    "properties.search_id.content.contentStats.yearlyPriceVariance": "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.averagePrices.10x10.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.10x15.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.10x20.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.5x10.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.5x5.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.overall.price": "string",
    "properties.search_id.content.pricingStats.lowestPrices": "",
    "properties.search_id.content.weather.almanacNormalHigh": "string",
    "properties.search_id.content.weather.almanacNormalLow": "string",
    "properties.search_id.content.weather.almanacRecordHigh": "string",
    "properties.search_id.content.weather.almanacRecordLow": "string",
    "properties.search_id.content.weather.forecastHigh": "string",
    "properties.search_id.content.weather.forecastLow": "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.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.landingFacilities": "",
    "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.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.headline": "string",
    "properties.search_id.meta.logo": "string",
    "properties.search_id.meta.noindex": "string",
    "properties.search_id.meta.tags.links": "",
    "properties.search_id.meta.tags.meta.description": "string",
    "properties.search_id.meta.tags.og.description": "string",
    "properties.search_id.meta.tags.og.image": "string",
    "properties.search_id.meta.tags.og.site": "string",
    "properties.search_id.meta.tags.og.title": "string",
    "properties.search_id.meta.tags.og.url": "string",
    "properties.search_id.meta.tags.title": "string",
    "properties.search_id.meta.title": "string",
    "properties.search_id.meta.uri": "string",
    "properties.search_id.numPages": "string",
    "properties.search_id.oonFacilities": "",
    "properties.search_id.page": "string",
    "properties.search_id.phone.nationalSparephone": "string",
    "properties.search_id.phone.nationalSparephoneUnformatted": "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.namespace": "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.variation": "string",
    "properties.search_id.searchParams.visitId": "string",
    "properties.search_id.searchType": "string",
    "properties.search_id.staticMapUrl": "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.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 457
schema_scan_id: 5743825
updated: 2021-01-19 15:29:41

Version 4684326

created: 2021-01-15 13:08:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
    "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_product_list_viewed`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_product_list_viewed`\n(\n`integrations`struct<`_empty_`:STRING>,`event`STRING,`version`STRING,`timestamp`STRING,`originalTimestamp`STRING,`receivedAt`STRING,`projectId`STRING,`userId`STRING,`_origin`STRING,`anonymousId`STRING,`properties`struct<`search_id`:STRING,`value`:STRING,`env`:STRING,`searchId`:STRING,`site_id`:STRING,`products`:array>,`position`:STRING,`reviewAverage`:STRING,`id`:STRING>>,`searchTerm`:STRING,`isReact`:STRING,`category`:STRING,`list_id`:STRING,`page`:STRING,`Hit_Timestamp`:STRING,`productIds`:array>,`channel`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`messageId`STRING,`context`struct<`locale`:STRING,`userAgent`:STRING,`page`:struct<`title`:STRING,`search`:STRING,`url`:STRING,`path`:STRING,`referrer`:STRING>,`ip`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING>>,`type`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/Product List Viewed'\n",
    "MSCK REPAIR TABLE sfdl_dev_segment.reactfoot_product_list_viewed"
]

hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed
id: 4684326
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2021-01-15T19:07:41Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1610668800000/1610737410869.b3282638195e.fde281a.437f35d6-df21-4efe-9d81-f883f01f44cf.gz|segment_separator:34",
    "anonymousId": "9f33ba3c-2de6-4249-a65f-4683c3c7ad9a",
    "channel": "client",
    "context": {
        "campaign": {},
        "ip": "34.239.223.223",
        "library": {
            "name": "analytics.js",
            "version": "4.0.4"
        },
        "locale": "en-US",
        "page": {
            "path": "/Austin-TX-self-storage.html",
            "referrer": "https://sparefoot.moreyard.com/",
            "search": "",
            "title": "15 Cheap Storage Units Austin, TX (from $19) | Compare & Save",
            "url": "https://www.sparefoot.moreyard.com/Austin-TX-self-storage.html"
        },
        "userAgent": "Mozilla/5.0 (iPhone; CPU iPhone OS 10_3_3 like Mac OS X) AppleWebKit/603.3.8 (KHTML, like Gecko) Version/10.0 Mobile/14G60 Safari/602.1"
    },
    "event": "Product List Viewed",
    "integrations": {},
    "messageId": "ajs-ea24ec5100d2c80aad83a559f305f011",
    "originalTimestamp": "2021-01-15T18:30:28.687Z",
    "projectId": "iHhi46PCMy",
    "properties": {
        "Hit Timestamp": 1610735428203,
        "category": "Austin, TX-cityLandingPage",
        "env": "dev",
        "isReact": true,
        "list_id": "search results: Austin, TX",
        "page": 1,
        "productIds": [
            156046,
            213453,
            217342,
            156046,
            213522,
            156115,
            213511,
            63539,
            210057,
            157542,
            209072,
            213442,
            152776,
            203677,
            212050,
            194245
        ],
        "products": [
            {
                "distance": 1.2,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 209852,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "CubeSmart Self Storage - Austin - 1411 W 5th St",
                "position": 16,
                "rank": 16,
                "reviewAverage": 5,
                "reviewCount": 7,
                "unitCount": 3,
                "units": [
                    {
                        "id": 24169210,
                        "maxBookingDate": "2021-02-14T03:50:07.000Z",
                        "priceValue": 53.25,
                        "promotion": "25% Off",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    }
                ]
            }
        ],
        "searchTerm": "Austin, TX",
        "search_id": "6bb66001df414f9e80.57495280",
        "site_id": -1,
        "value": 16
    },
    "receivedAt": "2021-01-15T18:30:29.497Z",
    "sentAt": "2021-01-15T18:30:28.713Z",
    "timestamp": "2021-01-15T18:30:29.471Z",
    "type": "track",
    "userId": "94d82c6c7a7cd176a24b9d9f852f14d3",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "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.isReact": "string",
    "properties.list_id": "string",
    "properties.page": "string",
    "properties.productIds": [
        "int"
    ],
    "properties.products": [
        {
            "distance": "string",
            "hasContactlessBadge": "string",
            "hasErentalBadge": "string",
            "id": "string",
            "inNetwork": "string",
            "isTopYielder": "string",
            "name": "string",
            "position": "string",
            "rank": "string",
            "reviewAverage": "string",
            "reviewCount": "string",
            "unitCount": "string",
            "units": [
                {
                    "id": "string",
                    "maxBookingDate": "string",
                    "priceValue": "string",
                    "promotion": "string",
                    "sizeText": "string",
                    "squareFootage": "string",
                    "unitTypeText": "string"
                }
            ]
        }
    ],
    "properties.searchId": "string",
    "properties.searchTerm": "string",
    "properties.search_id": "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.contentStats.highestMonth": "string",
    "properties.search_id.content.contentStats.lowestMonth": "string",
    "properties.search_id.content.contentStats.yearlyPriceVariance": "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.averagePrices.10x10.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.10x15.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.10x20.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.5x10.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.5x5.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.overall.price": "string",
    "properties.search_id.content.pricingStats.lowestPrices": "",
    "properties.search_id.content.weather.almanacNormalHigh": "string",
    "properties.search_id.content.weather.almanacNormalLow": "string",
    "properties.search_id.content.weather.almanacRecordHigh": "string",
    "properties.search_id.content.weather.almanacRecordLow": "string",
    "properties.search_id.content.weather.forecastHigh": "string",
    "properties.search_id.content.weather.forecastLow": "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.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.landingFacilities": "",
    "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.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.headline": "string",
    "properties.search_id.meta.logo": "string",
    "properties.search_id.meta.noindex": "string",
    "properties.search_id.meta.tags.links": "",
    "properties.search_id.meta.tags.meta.description": "string",
    "properties.search_id.meta.tags.og.description": "string",
    "properties.search_id.meta.tags.og.image": "string",
    "properties.search_id.meta.tags.og.site": "string",
    "properties.search_id.meta.tags.og.title": "string",
    "properties.search_id.meta.tags.og.url": "string",
    "properties.search_id.meta.tags.title": "string",
    "properties.search_id.meta.title": "string",
    "properties.search_id.meta.uri": "string",
    "properties.search_id.numPages": "string",
    "properties.search_id.oonFacilities": "",
    "properties.search_id.page": "string",
    "properties.search_id.phone.nationalSparephone": "string",
    "properties.search_id.phone.nationalSparephoneUnformatted": "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.namespace": "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.variation": "string",
    "properties.search_id.searchParams.visitId": "string",
    "properties.search_id.searchType": "string",
    "properties.search_id.staticMapUrl": "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.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 457
schema_scan_id: 5742510
updated: 2021-01-15 13:10:55

Version 4684325

created: 2021-01-15 13:05:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
    "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_product_list_viewed`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_product_list_viewed`\n(\n`integrations`struct<`_empty_`:STRING>,`event`STRING,`version`STRING,`timestamp`STRING,`originalTimestamp`STRING,`receivedAt`STRING,`projectId`STRING,`userId`STRING,`_origin`STRING,`anonymousId`STRING,`properties`struct<`search_id`:STRING,`value`:STRING,`page`:STRING,`searchId`:STRING,`site_id`:STRING,`products`:array,`searchTerm`:STRING,`isReact`:STRING,`category`:STRING,`list_id`:STRING,`env`:STRING,`Hit_Timestamp`:STRING,`productIds`:array>,`channel`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`messageId`STRING,`context`struct<`locale`:STRING,`userAgent`:STRING,`page`:struct<`title`:STRING,`search`:STRING,`url`:STRING,`path`:STRING,`referrer`:STRING>,`ip`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING>>,`type`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/Product List Viewed'\n",
    "MSCK REPAIR TABLE sfdl_dev_segment.reactfoot_product_list_viewed"
]

hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed
id: 4684325
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2021-01-15T19:05:06Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1610668800000/1610737403675.7afa618686ae.fde281a.bd7bac95-658b-4885-8f75-5c26e4acf816.gz|segment_separator:34",
    "anonymousId": "a5fe9cc0-fd48-4d13-a5ef-333c2929a937",
    "channel": "client",
    "context": {
        "campaign": {},
        "ip": "34.239.223.223",
        "library": {
            "name": "analytics.js",
            "version": "4.0.4"
        },
        "locale": "en-us",
        "page": {
            "path": "/.html",
            "referrer": "https://sparefoot.moreyard.com/Providence-RI-self-storage.html",
            "search": "?latitude=31.95216223802497&longitude=-99.31640625",
            "title": "Cheap Coleman TX Self-Storage Facilities | SpareFoot",
            "url": "https://www.sparefoot.moreyard.com/.html?latitude=31.95216223802497&longitude=-99.31640625"
        },
        "userAgent": "Mozilla/5.0 (iPhone; CPU iPhone OS 9_0 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13A342 Safari/601.1"
    },
    "event": "Product List Viewed",
    "integrations": {},
    "messageId": "ajs-fd93f6777b47554136f042b2454bf757",
    "originalTimestamp": "2021-01-15T18:28:48.398Z",
    "projectId": "iHhi46PCMy",
    "properties": {
        "Hit Timestamp": 1610735328028,
        "category": "Coleman, TX 76834-searchPage",
        "env": "dev",
        "isReact": true,
        "list_id": "search results: Coleman, TX 76834",
        "page": 1,
        "productIds": [],
        "products": [],
        "searchTerm": "Coleman, TX 76834",
        "search_id": "5f576001dedfc23189.60222652",
        "site_id": -1,
        "value": 0
    },
    "receivedAt": "2021-01-15T18:28:49.988Z",
    "sentAt": "2021-01-15T18:28:48.401Z",
    "timestamp": "2021-01-15T18:28:49.985Z",
    "type": "track",
    "userId": "133410e4a71175be0c09afa0dcca6ed9",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "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.isReact": "string",
    "properties.list_id": "string",
    "properties.page": "string",
    "properties.productIds": [
        "string"
    ],
    "properties.products": [
        "string"
    ],
    "properties.searchId": "string",
    "properties.searchTerm": "string",
    "properties.search_id": "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.contentStats.highestMonth": "string",
    "properties.search_id.content.contentStats.lowestMonth": "string",
    "properties.search_id.content.contentStats.yearlyPriceVariance": "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.averagePrices.10x10.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.10x15.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.10x20.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.5x10.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.5x5.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.overall.price": "string",
    "properties.search_id.content.pricingStats.lowestPrices": "",
    "properties.search_id.content.weather.almanacNormalHigh": "string",
    "properties.search_id.content.weather.almanacNormalLow": "string",
    "properties.search_id.content.weather.almanacRecordHigh": "string",
    "properties.search_id.content.weather.almanacRecordLow": "string",
    "properties.search_id.content.weather.forecastHigh": "string",
    "properties.search_id.content.weather.forecastLow": "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.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.landingFacilities": "",
    "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.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.headline": "string",
    "properties.search_id.meta.logo": "string",
    "properties.search_id.meta.noindex": "string",
    "properties.search_id.meta.tags.links": "",
    "properties.search_id.meta.tags.meta.description": "string",
    "properties.search_id.meta.tags.og.description": "string",
    "properties.search_id.meta.tags.og.image": "string",
    "properties.search_id.meta.tags.og.site": "string",
    "properties.search_id.meta.tags.og.title": "string",
    "properties.search_id.meta.tags.og.url": "string",
    "properties.search_id.meta.tags.title": "string",
    "properties.search_id.meta.title": "string",
    "properties.search_id.meta.uri": "string",
    "properties.search_id.numPages": "string",
    "properties.search_id.oonFacilities": "",
    "properties.search_id.page": "string",
    "properties.search_id.phone.nationalSparephone": "string",
    "properties.search_id.phone.nationalSparephoneUnformatted": "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.namespace": "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.variation": "string",
    "properties.search_id.searchParams.visitId": "string",
    "properties.search_id.searchType": "string",
    "properties.search_id.staticMapUrl": "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.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 457
schema_scan_id: 5742504
updated: 2021-01-15 13:08:12

Version 4684324

created: 2021-01-15 12:24:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
    "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_product_list_viewed`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_product_list_viewed`\n(\n`integrations`struct<`_empty_`:STRING>,`event`STRING,`version`STRING,`timestamp`STRING,`originalTimestamp`STRING,`receivedAt`STRING,`projectId`STRING,`userId`STRING,`_origin`STRING,`anonymousId`STRING,`properties`struct<`search_id`:STRING,`value`:STRING,`searchId`:STRING,`site_id`:STRING,`products`:array,`searchTerm`:STRING,`isReact`:STRING,`productIds`:array,`category`:STRING,`list_id`:STRING,`env`:STRING,`Hit_Timestamp`:STRING,`page`:STRING>,`channel`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`messageId`STRING,`context`struct<`locale`:STRING,`userAgent`:STRING,`page`:struct<`title`:STRING,`search`:STRING,`url`:STRING,`path`:STRING,`referrer`:STRING>,`ip`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING>>,`type`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/Product List Viewed'\n",
    "MSCK REPAIR TABLE sfdl_dev_segment.reactfoot_product_list_viewed"
]

hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed
id: 4684324
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2021-01-15T18:23:41Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1610668800000/1610734535955.f83d63fe07ed.fde281a.0994c20b-1706-4884-b16c-c75003c1fdac.gz|segment_separator:34",
    "anonymousId": "6dc5fc09-93be-4bfe-9a60-64f5ca1bd80f",
    "channel": "client",
    "context": {
        "ip": "34.239.223.223",
        "library": {
            "name": "analytics.js",
            "version": "4.0.4"
        },
        "locale": "en-US",
        "page": {
            "path": "/Plano-TX-self-storage.html",
            "referrer": "",
            "search": "",
            "title": "15 Cheap Storage Units Plano, TX (from $19) | Compare & Save",
            "url": "https://www.sparefoot.moreyard.com/Plano-TX-self-storage.html"
        },
        "userAgent": "Mozilla/5.0 (Windows NT 6.3; WOW64; Trident/7.0; .NET4.0E; .NET4.0C; .NET CLR 3.5.30729; .NET CLR 2.0.50727; .NET CLR 3.0.30729; rv:11.0) like Gecko"
    },
    "event": "Product List Viewed",
    "integrations": {},
    "messageId": "ajs-f05c2648488bad15ed060f8afb2eb0cb",
    "originalTimestamp": "2021-01-15T17:18:56.012Z",
    "projectId": "iHhi46PCMy",
    "properties": {
        "Hit Timestamp": 1610731134045,
        "category": "Plano, TX-cityLandingPage",
        "env": "dev",
        "isReact": true,
        "list_id": "search results: Plano, TX",
        "page": 1,
        "productIds": [
            216349,
            199186,
            211302,
            216349,
            205022,
            206465,
            209218,
            209241,
            212183,
            208622,
            205052,
            213521,
            157522,
            202799,
            213641,
            210056
        ],
        "products": [
            {
                "distance": 6.5,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 216349,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "All Storage - Garland - 5760 Bunker Hill",
                "position": 1,
                "rank": 1,
                "reviewAverage": 4.357,
                "reviewCount": 7,
                "unitCount": 3,
                "units": [
                    {
                        "id": 22715180,
                        "maxBookingDate": "2021-02-14T04:09:30.000Z",
                        "priceValue": 21,
                        "promotion": "2 Months Free",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 22715275,
                        "maxBookingDate": "2021-02-14T04:09:30.000Z",
                        "priceValue": 44,
                        "promotion": "2 Months Free",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 22715413,
                        "maxBookingDate": "2021-02-14T04:09:30.000Z",
                        "priceValue": 70,
                        "promotion": "2 Months Free",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 11.3,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 199186,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Advantage Storage - Garland",
                "position": 2,
                "rank": 2,
                "reviewAverage": 4.75,
                "reviewCount": 8,
                "unitCount": 3,
                "units": [
                    {
                        "id": 17647696,
                        "maxBookingDate": "2021-01-22T03:57:29.000Z",
                        "priceValue": 22,
                        "promotion": "50% OFF FIRST MONTH!",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 17647723,
                        "maxBookingDate": "2021-01-22T03:57:29.000Z",
                        "priceValue": 52,
                        "promotion": "50% OFF FIRST MONTH!",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 17647751,
                        "maxBookingDate": "2021-01-22T03:57:29.000Z",
                        "priceValue": 67,
                        "promotion": "50% OFF FIRST MONTH!",
                        "sizeText": "5' x 15'",
                        "squareFootage": 75,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 9.2,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 211302,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "All Storage - Rowlett - 1800 Castle Dr.",
                "position": 3,
                "rank": 3,
                "reviewAverage": 4.893,
                "reviewCount": 14,
                "unitCount": 3,
                "units": [
                    {
                        "id": 21240656,
                        "maxBookingDate": "2021-01-29T03:48:36.000Z",
                        "priceValue": 22,
                        "promotion": "2 Months Free",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 21240765,
                        "maxBookingDate": "2021-01-29T03:48:36.000Z",
                        "priceValue": 79,
                        "promotion": "2 Months Free",
                        "sizeText": "10' x 5'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 21241061,
                        "maxBookingDate": "2021-01-29T03:48:36.000Z",
                        "priceValue": 74,
                        "promotion": "2 Months Free",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 6.5,
                "id": 216349,
                "inNetwork": true,
                "isTopYielder": true,
                "name": "All Storage - Garland - 5760 Bunker Hill",
                "position": 4,
                "rank": 4,
                "reviewAverage": 4.357,
                "reviewCount": 7,
                "unitCount": 3,
                "units": [
                    {},
                    {},
                    {}
                ]
            },
            {
                "distance": 7.2,
                "hasContactlessBadge": true,
                "hasErentalBadge": true,
                "id": 205022,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Simply Self Storage - 1379 Andrews Parkway - Allen",
                "position": 5,
                "rank": 5,
                "reviewAverage": 4.776,
                "reviewCount": 29,
                "unitCount": 2,
                "units": [
                    {
                        "id": 19303527,
                        "maxBookingDate": "2021-01-29T03:52:46.000Z",
                        "priceValue": 43,
                        "promotion": "50% Off - First Full Month",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 19303971,
                        "maxBookingDate": "2021-01-29T03:52:46.000Z",
                        "priceValue": 73,
                        "promotion": "50% Off - First Full Month",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 4.7,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 206465,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "All Storage - Plano - 500 Talbert Dr",
                "position": 6,
                "rank": 6,
                "reviewAverage": 4.845,
                "reviewCount": 29,
                "unitCount": 3,
                "units": [
                    {
                        "id": 20437657,
                        "maxBookingDate": "2021-01-29T03:52:01.000Z",
                        "priceValue": 37,
                        "promotion": "",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 19697523,
                        "maxBookingDate": "2021-01-29T03:52:01.000Z",
                        "priceValue": 47,
                        "promotion": "",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 19697933,
                        "maxBookingDate": "2021-01-29T03:52:01.000Z",
                        "priceValue": 60,
                        "promotion": "2 Months Free",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 9.5,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 209218,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Storage Center at Craig Ranch",
                "position": 7,
                "rank": 7,
                "reviewAverage": 5,
                "reviewCount": 7,
                "unitCount": 3,
                "units": [
                    {
                        "id": 20258498,
                        "maxBookingDate": "2021-02-14T03:50:42.000Z",
                        "priceValue": 27,
                        "promotion": "1st Month Free (Select Units)",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 20258438,
                        "maxBookingDate": "2021-02-14T03:50:42.000Z",
                        "priceValue": 42,
                        "promotion": "1st Month Free (Select Units)",
                        "sizeText": "10' x 5'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 20258442,
                        "maxBookingDate": "2021-02-14T03:50:42.000Z",
                        "priceValue": 82,
                        "promotion": "1st Month Free (Select Units)",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 11.5,
                "hasContactlessBadge": true,
                "hasErentalBadge": true,
                "id": 209241,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Simply Self Storage - 4740 4th Army Drive - Frisco",
                "position": 8,
                "rank": 8,
                "reviewAverage": 4.8,
                "reviewCount": 5,
                "unitCount": 3,
                "units": [
                    {
                        "id": 20273146,
                        "maxBookingDate": "2021-01-29T03:50:42.000Z",
                        "priceValue": 26,
                        "promotion": "",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 20273206,
                        "maxBookingDate": "2021-01-29T03:50:42.000Z",
                        "priceValue": 47,
                        "promotion": "",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 20273388,
                        "maxBookingDate": "2021-01-29T03:50:42.000Z",
                        "priceValue": 106,
                        "promotion": "First Full Month - Free",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 12.6,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 212183,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "All Storage - Frisco - 6475 All Stars Ave.",
                "position": 9,
                "rank": 9,
                "reviewAverage": 4.947,
                "reviewCount": 19,
                "unitCount": 3,
                "units": [
                    {
                        "id": 21692683,
                        "maxBookingDate": "2021-02-14T03:47:30.000Z",
                        "priceValue": 28,
                        "promotion": "2 Months Free",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 21692693,
                        "maxBookingDate": "2021-02-14T03:47:30.000Z",
                        "priceValue": 50,
                        "promotion": "2 Months Free",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 21692756,
                        "maxBookingDate": "2021-02-14T03:47:30.000Z",
                        "priceValue": 81,
                        "promotion": "2 Months Free",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 9.9,
                "hasContactlessBadge": true,
                "hasErentalBadge": true,
                "id": 208622,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Simply Self Storage - 3801 Hardin Boulevard - Stonebridge Ranch",
                "position": 10,
                "rank": 10,
                "reviewAverage": 4.5,
                "reviewCount": 5,
                "unitCount": 3,
                "units": [
                    {
                        "id": 19981669,
                        "maxBookingDate": "2021-01-29T03:51:17.000Z",
                        "priceValue": 21,
                        "promotion": "50% Off - First 3 Full Months!",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 19981747,
                        "maxBookingDate": "2021-01-29T03:51:17.000Z",
                        "priceValue": 43,
                        "promotion": "50% Off - First 3 Full Months!",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 19982150,
                        "maxBookingDate": "2021-01-29T03:51:17.000Z",
                        "priceValue": 75,
                        "promotion": "50% Off - First 3 Full Months!",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 13.6,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 205052,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "All Storage - McKinney - 1415 N Custer Rd",
                "position": 11,
                "rank": 11,
                "reviewAverage": 4.781,
                "reviewCount": 16,
                "unitCount": 3,
                "units": [
                    {
                        "id": 19310991,
                        "maxBookingDate": "2021-01-29T03:52:42.000Z",
                        "priceValue": 39,
                        "promotion": "2 Months Free",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 19311348,
                        "maxBookingDate": "2021-01-29T03:52:42.000Z",
                        "priceValue": 45,
                        "promotion": "2 Months Free",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 19311262,
                        "maxBookingDate": "2021-01-29T03:52:42.000Z",
                        "priceValue": 112,
                        "promotion": "",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 1.3,
                "hasContactlessBadge": true,
                "hasErentalBadge": true,
                "id": 213521,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Public Storage - Plano - 3401 Avenue K",
                "position": 12,
                "rank": 12,
                "reviewAverage": 4.672,
                "reviewCount": 32,
                "unitCount": 3,
                "units": [
                    {
                        "id": 22237643,
                        "maxBookingDate": "2021-02-14T03:45:19.000Z",
                        "priceValue": 22,
                        "promotion": "$1 first month rent",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 22237634,
                        "maxBookingDate": "2021-02-14T03:45:19.000Z",
                        "priceValue": 30,
                        "promotion": "$1 first month rent",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 22237628,
                        "maxBookingDate": "2021-02-14T03:45:19.000Z",
                        "priceValue": 54,
                        "promotion": "$1 first month rent",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 9.1,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 157522,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "CubeSmart Self Storage - Dallas - 5818 Lyndon B Johnson Fwy",
                "position": 13,
                "rank": 13,
                "reviewAverage": 4.74,
                "reviewCount": 48,
                "unitCount": 3,
                "units": [
                    {
                        "id": 24446449,
                        "maxBookingDate": "2021-01-30T03:58:07.000Z",
                        "priceValue": 17.25,
                        "promotion": "25% Off",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 24453139,
                        "maxBookingDate": "2021-01-30T03:58:07.000Z",
                        "priceValue": 33.75,
                        "promotion": "25% Off",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 24483601,
                        "maxBookingDate": "2021-01-30T03:58:07.000Z",
                        "priceValue": 83.25,
                        "promotion": "25% Off",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 12.6,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 202799,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "All Storage - Carrollton West - 2409 Old Denton Rd",
                "position": 14,
                "rank": 14,
                "reviewAverage": 4.421,
                "reviewCount": 38,
                "unitCount": 3,
                "units": [
                    {
                        "id": 18714539,
                        "maxBookingDate": "2021-01-29T03:54:54.000Z",
                        "priceValue": 35,
                        "promotion": "First Month Free!",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 20581048,
                        "maxBookingDate": "2021-01-29T03:54:54.000Z",
                        "priceValue": 40,
                        "promotion": "1st Month Free!",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 18956224,
                        "maxBookingDate": "2021-01-29T03:54:54.000Z",
                        "priceValue": 105,
                        "promotion": "50% Off First 2 Months!",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 11.3,
                "hasContactlessBadge": true,
                "hasErentalBadge": true,
                "id": 213641,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Public Storage - Lewisville - 4900 State Highway 121",
                "position": 15,
                "rank": 15,
                "reviewAverage": 4.778,
                "reviewCount": 45,
                "unitCount": 3,
                "units": [
                    {
                        "id": 23021397,
                        "maxBookingDate": "2021-02-14T03:45:16.000Z",
                        "priceValue": 16,
                        "promotion": "$1 first month rent",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 22237301,
                        "maxBookingDate": "2021-02-14T03:45:16.000Z",
                        "priceValue": 40,
                        "promotion": "$1 first month rent",
                        "sizeText": "10' x 5'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 23021401,
                        "maxBookingDate": "2021-02-14T03:45:16.000Z",
                        "priceValue": 86,
                        "promotion": "$1 first month rent",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 1.1,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 210056,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Life Storage - Plano - 1010 Jupiter Road",
                "position": 16,
                "rank": 16,
                "reviewAverage": 4.875,
                "reviewCount": 4,
                "unitCount": 3,
                "units": [
                    {
                        "id": 24406283,
                        "maxBookingDate": "2021-02-13T03:50:03.000Z",
                        "priceValue": 29,
                        "promotion": "One Month Free!",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 20973441,
                        "maxBookingDate": "2021-02-13T03:50:03.000Z",
                        "priceValue": 44,
                        "promotion": "One Month Free!",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 20973450,
                        "maxBookingDate": "2021-02-13T03:50:03.000Z",
                        "priceValue": 96,
                        "promotion": "One Month Free!",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            }
        ],
        "searchTerm": "Plano, TX",
        "search_id": "436d6001ce78360fb1.33003186",
        "site_id": -1,
        "value": 16
    },
    "receivedAt": "2021-01-15T17:18:58.535Z",
    "sentAt": "2021-01-15T17:18:56.049Z",
    "timestamp": "2021-01-15T17:18:58.498Z",
    "type": "track",
    "userId": "d857de8f40a4f9b26c5157ef28900638",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "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.isReact": "string",
    "properties.list_id": "string",
    "properties.page": "string",
    "properties.productIds": [
        "int"
    ],
    "properties.products": [
        "string"
    ],
    "properties.searchId": "string",
    "properties.searchTerm": "string",
    "properties.search_id": "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.contentStats.highestMonth": "string",
    "properties.search_id.content.contentStats.lowestMonth": "string",
    "properties.search_id.content.contentStats.yearlyPriceVariance": "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.averagePrices.10x10.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.10x15.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.10x20.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.5x10.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.5x5.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.overall.price": "string",
    "properties.search_id.content.pricingStats.lowestPrices": "",
    "properties.search_id.content.weather.almanacNormalHigh": "string",
    "properties.search_id.content.weather.almanacNormalLow": "string",
    "properties.search_id.content.weather.almanacRecordHigh": "string",
    "properties.search_id.content.weather.almanacRecordLow": "string",
    "properties.search_id.content.weather.forecastHigh": "string",
    "properties.search_id.content.weather.forecastLow": "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.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.landingFacilities": "",
    "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.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.headline": "string",
    "properties.search_id.meta.logo": "string",
    "properties.search_id.meta.noindex": "string",
    "properties.search_id.meta.tags.links": "",
    "properties.search_id.meta.tags.meta.description": "string",
    "properties.search_id.meta.tags.og.description": "string",
    "properties.search_id.meta.tags.og.image": "string",
    "properties.search_id.meta.tags.og.site": "string",
    "properties.search_id.meta.tags.og.title": "string",
    "properties.search_id.meta.tags.og.url": "string",
    "properties.search_id.meta.tags.title": "string",
    "properties.search_id.meta.title": "string",
    "properties.search_id.meta.uri": "string",
    "properties.search_id.numPages": "string",
    "properties.search_id.oonFacilities": "",
    "properties.search_id.page": "string",
    "properties.search_id.phone.nationalSparephone": "string",
    "properties.search_id.phone.nationalSparephoneUnformatted": "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.namespace": "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.variation": "string",
    "properties.search_id.searchParams.visitId": "string",
    "properties.search_id.searchType": "string",
    "properties.search_id.staticMapUrl": "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.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 457
schema_scan_id: 5742491
updated: 2021-01-15 12:26:50

Version 4684323

created: 2021-01-15 12:19:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
    "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_product_list_viewed`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_product_list_viewed`\n(\n`integrations`struct<`_empty_`:STRING>,`event`STRING,`version`STRING,`timestamp`STRING,`originalTimestamp`STRING,`receivedAt`STRING,`projectId`STRING,`userId`STRING,`_origin`STRING,`anonymousId`STRING,`properties`struct<`search_id`:STRING,`value`:STRING,`env`:STRING,`searchId`:STRING,`site_id`:STRING,`products`:array,`searchTerm`:STRING,`isReact`:STRING,`category`:STRING,`list_id`:STRING,`page`:STRING,`Hit_Timestamp`:STRING,`productIds`:array>,`channel`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`messageId`STRING,`context`struct<`locale`:STRING,`userAgent`:STRING,`page`:struct<`title`:STRING,`search`:STRING,`url`:STRING,`path`:STRING,`referrer`:STRING>,`ip`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING>>,`type`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/Product List Viewed'\n",
    "MSCK REPAIR TABLE sfdl_dev_segment.reactfoot_product_list_viewed"
]

hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed
id: 4684323
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2021-01-15T18:19:04Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1610668800000/1610734522794.8812454c863c.fde281a.9e06409b-0c57-4222-aff6-f5fa3da71b24.gz|segment_separator:34",
    "anonymousId": "03bb5652-24ae-4b7b-a4f4-93be13695ccd",
    "channel": "client",
    "context": {
        "campaign": {},
        "ip": "34.239.223.223",
        "library": {
            "name": "analytics.js",
            "version": "4.0.4"
        },
        "locale": "en-US",
        "page": {
            "path": "/search.html",
            "referrer": "http://localhost:9000/",
            "search": "?location=Austin%2C%20TX%2C%20USA",
            "title": "",
            "url": "http://localhost:9000/search.html?location=Austin%2C%20TX%2C%20USA"
        },
        "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36"
    },
    "event": "Product List Viewed",
    "integrations": {},
    "messageId": "ajs-864167ab39c327b6e7cf85f32ac9c5fd",
    "originalTimestamp": "2021-01-15T17:19:50.981Z",
    "projectId": "iHhi46PCMy",
    "properties": {
        "Hit Timestamp": 1610731190798,
        "env": "development",
        "isReact": true,
        "list_id": "search results: null",
        "page": 1,
        "productIds": [],
        "products": [],
        "searchTerm": null,
        "search_id": null,
        "site_id": -1,
        "value": 0
    },
    "receivedAt": "2021-01-15T17:19:51.324Z",
    "sentAt": "2021-01-15T17:19:50.984Z",
    "timestamp": "2021-01-15T17:19:51.321Z",
    "type": "track",
    "userId": "error",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "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.isReact": "string",
    "properties.list_id": "string",
    "properties.page": "string",
    "properties.productIds": [
        "string"
    ],
    "properties.products": [
        "string"
    ],
    "properties.searchId": "string",
    "properties.searchTerm": "string",
    "properties.search_id": "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.contentStats.highestMonth": "string",
    "properties.search_id.content.contentStats.lowestMonth": "string",
    "properties.search_id.content.contentStats.yearlyPriceVariance": "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.averagePrices.10x10.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.10x15.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.10x20.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.5x10.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.5x5.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.overall.price": "string",
    "properties.search_id.content.pricingStats.lowestPrices": "",
    "properties.search_id.content.weather.almanacNormalHigh": "string",
    "properties.search_id.content.weather.almanacNormalLow": "string",
    "properties.search_id.content.weather.almanacRecordHigh": "string",
    "properties.search_id.content.weather.almanacRecordLow": "string",
    "properties.search_id.content.weather.forecastHigh": "string",
    "properties.search_id.content.weather.forecastLow": "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.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.landingFacilities": "",
    "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.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.headline": "string",
    "properties.search_id.meta.logo": "string",
    "properties.search_id.meta.noindex": "string",
    "properties.search_id.meta.tags.links": "",
    "properties.search_id.meta.tags.meta.description": "string",
    "properties.search_id.meta.tags.og.description": "string",
    "properties.search_id.meta.tags.og.image": "string",
    "properties.search_id.meta.tags.og.site": "string",
    "properties.search_id.meta.tags.og.title": "string",
    "properties.search_id.meta.tags.og.url": "string",
    "properties.search_id.meta.tags.title": "string",
    "properties.search_id.meta.title": "string",
    "properties.search_id.meta.uri": "string",
    "properties.search_id.numPages": "string",
    "properties.search_id.oonFacilities": "",
    "properties.search_id.page": "string",
    "properties.search_id.phone.nationalSparephone": "string",
    "properties.search_id.phone.nationalSparephoneUnformatted": "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.namespace": "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.variation": "string",
    "properties.search_id.searchParams.visitId": "string",
    "properties.search_id.searchType": "string",
    "properties.search_id.staticMapUrl": "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.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 457
schema_scan_id: 5742475
updated: 2021-01-15 12:21:58

Version 4684322

created: 2021-01-14 15:27:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
    "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_product_list_viewed`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_product_list_viewed`\n(\n`integrations`struct<`_empty_`:STRING>,`event`STRING,`version`STRING,`timestamp`STRING,`originalTimestamp`STRING,`receivedAt`STRING,`projectId`STRING,`userId`STRING,`_origin`STRING,`anonymousId`STRING,`properties`struct<`search_id`:STRING,`value`:STRING,`page`:STRING,`searchId`:STRING,`site_id`:STRING,`products`:array>,`position`:STRING,`reviewAverage`:STRING,`id`:STRING>>,`searchTerm`:STRING,`isReact`:STRING,`category`:STRING,`list_id`:STRING,`env`:STRING,`Hit_Timestamp`:STRING,`productIds`:array>,`channel`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`messageId`STRING,`context`struct<`locale`:STRING,`userAgent`:STRING,`page`:struct<`title`:STRING,`search`:STRING,`url`:STRING,`path`:STRING,`referrer`:STRING>,`ip`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING>>,`type`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/Product List Viewed'\n",
    "MSCK REPAIR TABLE sfdl_dev_segment.reactfoot_product_list_viewed"
]

hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed
id: 4684322
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2021-01-14T21:26:47Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1610582400000/1610658941665.d620080c67f3.fde281a.b0bbb2de-1a1c-4ca2-a29a-871cb704456a.gz|segment_separator:34",
    "anonymousId": "967b3728-c8e8-42d3-954e-8dfe6cafda7b",
    "channel": "client",
    "context": {
        "ip": "34.239.223.223",
        "library": {
            "name": "analytics.js",
            "version": "4.0.4"
        },
        "locale": "en-US",
        "page": {
            "path": "/Boulder-CO-self-storage.html",
            "referrer": "",
            "search": "",
            "title": "15 Cheap Storage Units Boulder, CO (from $19) | Compare & Save",
            "url": "http://localhost:9000/Boulder-CO-self-storage.html"
        },
        "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 11_1_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.141 Safari/537.36"
    },
    "event": "Product List Viewed",
    "integrations": {},
    "messageId": "ajs-c4d565d4b32dcefb6ae7a47fd25fce88",
    "originalTimestamp": "2021-01-14T20:20:53.855Z",
    "projectId": "iHhi46PCMy",
    "properties": {
        "Hit Timestamp": 1610655652812,
        "category": "Boulder, CO-cityLandingPage",
        "env": "development",
        "isReact": true,
        "list_id": "search results: Boulder, CO",
        "page": 1,
        "productIds": [
            215166,
            201185,
            201183,
            215166,
            210917,
            214381,
            200324,
            210238,
            217217,
            108022,
            216636,
            216304,
            215881,
            200325,
            210611,
            201184
        ],
        "products": [
            {
                "distance": 5.4,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 201184,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Life Storage - Boulder - Odell Place",
                "position": 16,
                "rank": 16,
                "reviewAverage": 4.1,
                "reviewCount": 10,
                "unitCount": 2,
                "units": [
                    {
                        "id": 18318926,
                        "maxBookingDate": "2021-02-12T11:57:59.000Z",
                        "priceValue": 151,
                        "promotion": "",
                        "sizeText": "9' x 10'",
                        "squareFootage": 90,
                        "unitTypeText": "unit"
                    }
                ]
            }
        ],
        "searchTerm": "Boulder, CO",
        "search_id": "b2d16000a50c181919.99733134",
        "site_id": -1,
        "value": 16
    },
    "receivedAt": "2021-01-14T20:20:54.477Z",
    "sentAt": "2021-01-14T20:20:53.859Z",
    "timestamp": "2021-01-14T20:20:54.473Z",
    "type": "track",
    "userId": "error",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "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.isReact": "string",
    "properties.list_id": "string",
    "properties.page": "string",
    "properties.productIds": [
        "int"
    ],
    "properties.products": [
        {
            "distance": "string",
            "hasContactlessBadge": "string",
            "hasErentalBadge": "string",
            "id": "string",
            "inNetwork": "string",
            "isTopYielder": "string",
            "name": "string",
            "position": "string",
            "rank": "string",
            "reviewAverage": "string",
            "reviewCount": "string",
            "unitCount": "string",
            "units": [
                {
                    "id": "string",
                    "maxBookingDate": "string",
                    "priceValue": "string",
                    "promotion": "string",
                    "sizeText": "string",
                    "squareFootage": "string",
                    "unitTypeText": "string"
                }
            ]
        }
    ],
    "properties.searchId": "string",
    "properties.searchTerm": "string",
    "properties.search_id": "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.contentStats.highestMonth": "string",
    "properties.search_id.content.contentStats.lowestMonth": "string",
    "properties.search_id.content.contentStats.yearlyPriceVariance": "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.averagePrices.10x10.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.10x15.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.10x20.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.5x10.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.5x5.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.overall.price": "string",
    "properties.search_id.content.pricingStats.lowestPrices": "",
    "properties.search_id.content.weather.almanacNormalHigh": "string",
    "properties.search_id.content.weather.almanacNormalLow": "string",
    "properties.search_id.content.weather.almanacRecordHigh": "string",
    "properties.search_id.content.weather.almanacRecordLow": "string",
    "properties.search_id.content.weather.forecastHigh": "string",
    "properties.search_id.content.weather.forecastLow": "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.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.landingFacilities": "",
    "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.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.headline": "string",
    "properties.search_id.meta.logo": "string",
    "properties.search_id.meta.noindex": "string",
    "properties.search_id.meta.tags.links": "",
    "properties.search_id.meta.tags.meta.description": "string",
    "properties.search_id.meta.tags.og.description": "string",
    "properties.search_id.meta.tags.og.image": "string",
    "properties.search_id.meta.tags.og.site": "string",
    "properties.search_id.meta.tags.og.title": "string",
    "properties.search_id.meta.tags.og.url": "string",
    "properties.search_id.meta.tags.title": "string",
    "properties.search_id.meta.title": "string",
    "properties.search_id.meta.uri": "string",
    "properties.search_id.numPages": "string",
    "properties.search_id.oonFacilities": "",
    "properties.search_id.page": "string",
    "properties.search_id.phone.nationalSparephone": "string",
    "properties.search_id.phone.nationalSparephoneUnformatted": "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.namespace": "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.variation": "string",
    "properties.search_id.searchParams.visitId": "string",
    "properties.search_id.searchType": "string",
    "properties.search_id.staticMapUrl": "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.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 457
schema_scan_id: 5741921
updated: 2021-01-14 15:29:45

Version 4684321

created: 2021-01-14 15:19:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
    "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_product_list_viewed`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_product_list_viewed`\n(\n`integrations`struct<`_empty_`:STRING>,`event`STRING,`version`STRING,`timestamp`STRING,`originalTimestamp`STRING,`receivedAt`STRING,`projectId`STRING,`userId`STRING,`_origin`STRING,`anonymousId`STRING,`properties`struct<`search_id`:STRING,`value`:STRING,`searchId`:STRING,`site_id`:STRING,`products`:array,`searchTerm`:STRING,`isReact`:STRING,`productIds`:array,`category`:STRING,`list_id`:STRING,`env`:STRING,`Hit_Timestamp`:STRING,`page`:STRING>,`channel`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`messageId`STRING,`context`struct<`locale`:STRING,`userAgent`:STRING,`page`:struct<`title`:STRING,`search`:STRING,`url`:STRING,`path`:STRING,`referrer`:STRING>,`ip`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING>>,`type`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/Product List Viewed'\n",
    "MSCK REPAIR TABLE sfdl_dev_segment.reactfoot_product_list_viewed"
]

hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed
id: 4684321
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2021-01-14T21:17:34Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1610582400000/1610658919923.e460f5add6c4.fde281a.2685c18e-7d4e-4113-8bbc-99ad3d86e5f5.gz|segment_separator:34",
    "anonymousId": "967b3728-c8e8-42d3-954e-8dfe6cafda7b",
    "channel": "client",
    "context": {
        "ip": "34.239.223.223",
        "library": {
            "name": "analytics.js",
            "version": "4.0.4"
        },
        "locale": "en-US",
        "page": {
            "path": "/Boulder-CO-self-storage.html",
            "referrer": "",
            "search": "",
            "title": "15 Cheap Storage Units Boulder, CO (from $19) | Compare & Save",
            "url": "http://localhost:9000/Boulder-CO-self-storage.html"
        },
        "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 11_1_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.141 Safari/537.36"
    },
    "event": "Product List Viewed",
    "integrations": {},
    "messageId": "ajs-24c485e8eec1586c498377bfa2f9f278",
    "originalTimestamp": "2021-01-14T20:51:18.351Z",
    "projectId": "iHhi46PCMy",
    "properties": {
        "Hit Timestamp": 1610657478348,
        "category": "Boulder, CO-cityLandingPage",
        "env": "development",
        "isReact": true,
        "list_id": "search results: Boulder, CO",
        "page": 1,
        "productIds": [
            215166,
            201185,
            201183,
            215166,
            210917,
            214381,
            200324,
            210238,
            217217,
            108022,
            216636,
            216304,
            215881,
            200325,
            210611,
            201184
        ],
        "products": [
            {
                "distance": 12.7,
                "hasContactlessBadge": true,
                "hasErentalBadge": true,
                "id": 215166,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Public Storage - Broomfield - 6800 W 118th Ave",
                "position": 1,
                "rank": 1,
                "reviewAverage": 4.833,
                "reviewCount": 45,
                "unitCount": 3,
                "units": [
                    {
                        "id": 23972603,
                        "maxBookingDate": "2021-02-13T12:36:59.000Z",
                        "priceValue": 32,
                        "promotion": "$1 first month rent",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 24285479,
                        "maxBookingDate": "2021-02-13T12:36:59.000Z",
                        "priceValue": 58,
                        "promotion": "$1 first month rent",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 22509775,
                        "maxBookingDate": "2021-02-13T12:36:59.000Z",
                        "priceValue": 108,
                        "promotion": "$1 first month rent",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 2.8,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 201185,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Life Storage - Boulder - 5815 Arapahoe Avenue",
                "position": 2,
                "rank": 2,
                "reviewAverage": 4.533,
                "reviewCount": 45,
                "unitCount": 3,
                "units": [
                    {
                        "id": 18271044,
                        "maxBookingDate": "2021-02-12T12:44:35.000Z",
                        "priceValue": 52,
                        "promotion": "One Month Free!",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 18268243,
                        "maxBookingDate": "2021-02-12T12:44:35.000Z",
                        "priceValue": 79,
                        "promotion": "One Month Free!",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 18273420,
                        "maxBookingDate": "2021-01-27T12:44:35.000Z",
                        "priceValue": 106,
                        "promotion": "One Month Free!",
                        "sizeText": "5' x 15'",
                        "squareFootage": 75,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 3.5,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 201183,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Life Storage - Boulder - 6338 Arapahoe Avenue",
                "position": 3,
                "rank": 3,
                "reviewAverage": 4.3,
                "reviewCount": 35,
                "unitCount": 2,
                "units": [
                    {
                        "id": 18318135,
                        "maxBookingDate": "2021-02-12T12:44:35.000Z",
                        "priceValue": 76,
                        "promotion": "One Month Free!",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 18318138,
                        "maxBookingDate": "2021-02-12T12:44:35.000Z",
                        "priceValue": 126,
                        "promotion": "One Month Free!",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 12.7,
                "id": 215166,
                "inNetwork": true,
                "isTopYielder": true,
                "name": "Public Storage - Broomfield - 6800 W 118th Ave",
                "position": 4,
                "rank": 4,
                "reviewAverage": 4.833,
                "reviewCount": 45,
                "unitCount": 3,
                "units": [
                    {},
                    {},
                    {}
                ]
            },
            {
                "distance": 11.2,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 210917,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "CubeSmart Self Storage - Broomfield",
                "position": 5,
                "rank": 5,
                "reviewAverage": 5,
                "reviewCount": 6,
                "unitCount": 3,
                "units": [
                    {
                        "id": 24453464,
                        "maxBookingDate": "2021-01-29T12:41:04.000Z",
                        "priceValue": 36.75,
                        "promotion": "25% Off",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 24369615,
                        "maxBookingDate": "2021-01-29T12:41:04.000Z",
                        "priceValue": 62.25,
                        "promotion": "25% Off",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 24447584,
                        "maxBookingDate": "2021-01-29T12:41:04.000Z",
                        "priceValue": 75.75,
                        "promotion": "25% Off",
                        "sizeText": "7.5' x 10'",
                        "squareFootage": 75,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 14.4,
                "hasContactlessBadge": true,
                "hasErentalBadge": true,
                "id": 214381,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Public Storage - Arvada - 14872 W 69th Ave",
                "position": 6,
                "rank": 6,
                "reviewAverage": 4.694,
                "reviewCount": 18,
                "unitCount": 3,
                "units": [
                    {
                        "id": 23440951,
                        "maxBookingDate": "2021-02-13T12:37:46.000Z",
                        "priceValue": 38,
                        "promotion": "$1 first month rent",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 22331260,
                        "maxBookingDate": "2021-02-13T12:37:46.000Z",
                        "priceValue": 78,
                        "promotion": "$1 first month rent",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 22331263,
                        "maxBookingDate": "2021-02-13T12:37:46.000Z",
                        "priceValue": 98,
                        "promotion": "$1 first month rent",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 3.4,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 200324,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Guardian Storage - Boulder",
                "position": 7,
                "rank": 7,
                "reviewAverage": 4.593,
                "reviewCount": 27,
                "unitCount": 3,
                "units": [
                    {
                        "id": 18579618,
                        "maxBookingDate": "2021-02-13T12:44:46.000Z",
                        "priceValue": 51,
                        "promotion": "Get 1 Month Free!",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 18579849,
                        "maxBookingDate": "2021-02-13T12:44:46.000Z",
                        "priceValue": 72,
                        "promotion": "Get 1 Month Free!",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 18580079,
                        "maxBookingDate": "2021-02-13T12:44:46.000Z",
                        "priceValue": 162,
                        "promotion": "Get 1 Month Free!",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 12.5,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 210238,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "StorQuest - Arvada / State Hwy 72",
                "position": 8,
                "rank": 8,
                "reviewAverage": 4.818,
                "reviewCount": 11,
                "unitCount": 3,
                "units": [
                    {
                        "id": 20909454,
                        "maxBookingDate": "2021-01-21T12:41:28.000Z",
                        "priceValue": 50,
                        "promotion": "Plus 50% Off First 2 Months! Other charges may apply. *Valid for 5 months.",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 20909011,
                        "maxBookingDate": "2021-01-21T12:41:28.000Z",
                        "priceValue": 75,
                        "promotion": "Plus 50% Off First 2 Months! Other charges may apply. *Valid for 5 months.",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 20908931,
                        "maxBookingDate": "2021-01-21T12:41:28.000Z",
                        "priceValue": 98,
                        "promotion": "Plus 50% Off First 2 Months! Other charges may apply. *Valid for 5 months.",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 1.7,
                "hasContactlessBadge": false,
                "hasErentalBadge": false,
                "id": 217217,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "StorQuest - Boulder / Pearl",
                "position": 9,
                "rank": 9,
                "reviewAverage": 5,
                "reviewCount": 1,
                "unitCount": 3,
                "units": [
                    {
                        "id": 23541875,
                        "maxBookingDate": "2021-01-21T12:35:25.000Z",
                        "priceValue": 58,
                        "promotion": "Plus 50% Off First 2 Months! Other charges may apply. *Valid for 5 months.",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 23541929,
                        "maxBookingDate": "2021-01-21T12:35:25.000Z",
                        "priceValue": 80,
                        "promotion": "Plus 50% Off First 2 Months! Other charges may apply. *Valid for 5 months.",
                        "sizeText": "10' x 5'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 23541952,
                        "maxBookingDate": "2021-01-21T12:35:25.000Z",
                        "priceValue": 169,
                        "promotion": "Plus 50% Off First 2 Months! Other charges may apply. *Valid for 5 months.",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 8.1,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 108022,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "StorQuest - Louisville/Lock",
                "position": 10,
                "rank": 10,
                "reviewAverage": 4.259,
                "reviewCount": 29,
                "unitCount": 3,
                "units": [
                    {
                        "id": 13809017,
                        "maxBookingDate": "2020-12-27T15:32:03.000Z",
                        "priceValue": 45,
                        "promotion": "Plus 50% Off First Month! Other charges may apply. *Valid for 5 months.",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 13808255,
                        "maxBookingDate": "2020-12-27T15:32:03.000Z",
                        "priceValue": 95,
                        "promotion": "Plus 50% Off First 2 Months! Other charges may apply. *Valid for 5 months.",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 16664484,
                        "maxBookingDate": "2020-12-27T15:32:03.000Z",
                        "priceValue": 139,
                        "promotion": "Plus 50% Off First Month! Other charges may apply. *Valid for 5 months.",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 9,
                "hasContactlessBadge": true,
                "hasErentalBadge": true,
                "id": 216636,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Clover Basin Self Storage",
                "position": 11,
                "rank": 11,
                "reviewAverage": 5,
                "reviewCount": 1,
                "unitCount": 3,
                "units": [
                    {
                        "id": 22905689,
                        "maxBookingDate": "2021-01-28T12:35:52.000Z",
                        "priceValue": 57,
                        "promotion": "1st Month Free",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 22905847,
                        "maxBookingDate": "2021-01-28T12:35:52.000Z",
                        "priceValue": 67,
                        "promotion": "1st Month Free",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 22905121,
                        "maxBookingDate": "2021-01-28T12:35:52.000Z",
                        "priceValue": 112,
                        "promotion": "1st Month Free",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 6.6,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 216304,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Superior Self Storage",
                "position": 12,
                "rank": 12,
                "reviewAverage": 4.5,
                "reviewCount": 2,
                "unitCount": 3,
                "units": [
                    {
                        "id": 22674389,
                        "maxBookingDate": "2020-12-11T02:45:17.000Z",
                        "priceValue": 40,
                        "promotion": "We require at least 2 month's stay for SpareFoot customers.",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 22674482,
                        "maxBookingDate": "2020-12-11T02:45:17.000Z",
                        "priceValue": 60,
                        "promotion": "We require at least 2 month's stay for SpareFoot customers.",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 22674606,
                        "maxBookingDate": "2020-12-11T02:45:17.000Z",
                        "priceValue": 110,
                        "promotion": "We require at least 2 month's stay for SpareFoot customers.",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 14.2,
                "hasContactlessBadge": true,
                "hasErentalBadge": true,
                "id": 215881,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Public Storage - Longmont - 2331 Wedgewood Ave",
                "position": 13,
                "rank": 13,
                "reviewAverage": 4.803,
                "reviewCount": 33,
                "unitCount": 3,
                "units": [
                    {
                        "id": 22594115,
                        "maxBookingDate": "2021-02-13T12:36:31.000Z",
                        "priceValue": 80,
                        "promotion": "$1 first month rent",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 22594111,
                        "maxBookingDate": "2021-02-13T12:36:31.000Z",
                        "priceValue": 90,
                        "promotion": "$1 first month rent",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 22594104,
                        "maxBookingDate": "2021-02-13T12:36:31.000Z",
                        "priceValue": 122,
                        "promotion": "50% off 1st Month",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 13,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 200325,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Guardian Storage - Longmont",
                "position": 14,
                "rank": 14,
                "reviewAverage": 4.813,
                "reviewCount": 8,
                "unitCount": 3,
                "units": [
                    {
                        "id": 18037428,
                        "maxBookingDate": "2021-02-13T12:44:46.000Z",
                        "priceValue": 75,
                        "promotion": "1 Month Free!",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 18037128,
                        "maxBookingDate": "2021-02-13T12:44:46.000Z",
                        "priceValue": 103,
                        "promotion": "1 Month Free!",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 18037496,
                        "maxBookingDate": "2021-02-13T12:44:46.000Z",
                        "priceValue": 141,
                        "promotion": "1 Month Free!",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 11.4,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 210611,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "CubeSmart Self Storage - Erie - 1401 E County Line Rd",
                "position": 15,
                "rank": 15,
                "reviewAverage": 4,
                "reviewCount": 5,
                "unitCount": 3,
                "units": [
                    {
                        "id": 24169788,
                        "maxBookingDate": "2021-01-29T12:41:24.000Z",
                        "priceValue": 63.75,
                        "promotion": "25% Off",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 24447551,
                        "maxBookingDate": "2021-01-29T12:41:24.000Z",
                        "priceValue": 66.75,
                        "promotion": "25% Off",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 24453441,
                        "maxBookingDate": "2021-01-29T12:41:24.000Z",
                        "priceValue": 116.25,
                        "promotion": "25% Off",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 5.4,
                "hasContactlessBadge": true,
                "hasErentalBadge": false,
                "id": 201184,
                "inNetwork": true,
                "isTopYielder": false,
                "name": "Life Storage - Boulder - Odell Place",
                "position": 16,
                "rank": 16,
                "reviewAverage": 4.1,
                "reviewCount": 10,
                "unitCount": 2,
                "units": [
                    {
                        "id": 18318924,
                        "maxBookingDate": "2021-02-12T12:44:35.000Z",
                        "priceValue": 105,
                        "promotion": "One Month Free!",
                        "sizeText": "5' x 9'",
                        "squareFootage": 45,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 18318926,
                        "maxBookingDate": "2021-02-12T12:44:35.000Z",
                        "priceValue": 151,
                        "promotion": "One Month Free!",
                        "sizeText": "9' x 10'",
                        "squareFootage": 90,
                        "unitTypeText": "unit"
                    }
                ]
            }
        ],
        "searchTerm": "Boulder, CO",
        "search_id": "3bc66000ae92680f32.33077865",
        "site_id": -1,
        "value": 16
    },
    "receivedAt": "2021-01-14T20:51:18.851Z",
    "sentAt": "2021-01-14T20:51:18.355Z",
    "timestamp": "2021-01-14T20:51:18.847Z",
    "type": "track",
    "userId": "error",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "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.isReact": "string",
    "properties.list_id": "string",
    "properties.page": "string",
    "properties.productIds": [
        "int"
    ],
    "properties.products": [
        "string"
    ],
    "properties.searchId": "string",
    "properties.searchTerm": "string",
    "properties.search_id": "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.contentStats.highestMonth": "string",
    "properties.search_id.content.contentStats.lowestMonth": "string",
    "properties.search_id.content.contentStats.yearlyPriceVariance": "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.averagePrices.10x10.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.10x15.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.10x20.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.5x10.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.5x5.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.overall.price": "string",
    "properties.search_id.content.pricingStats.lowestPrices": "",
    "properties.search_id.content.weather.almanacNormalHigh": "string",
    "properties.search_id.content.weather.almanacNormalLow": "string",
    "properties.search_id.content.weather.almanacRecordHigh": "string",
    "properties.search_id.content.weather.almanacRecordLow": "string",
    "properties.search_id.content.weather.forecastHigh": "string",
    "properties.search_id.content.weather.forecastLow": "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.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.landingFacilities": "",
    "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.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.headline": "string",
    "properties.search_id.meta.logo": "string",
    "properties.search_id.meta.noindex": "string",
    "properties.search_id.meta.tags.links": "",
    "properties.search_id.meta.tags.meta.description": "string",
    "properties.search_id.meta.tags.og.description": "string",
    "properties.search_id.meta.tags.og.image": "string",
    "properties.search_id.meta.tags.og.site": "string",
    "properties.search_id.meta.tags.og.title": "string",
    "properties.search_id.meta.tags.og.url": "string",
    "properties.search_id.meta.tags.title": "string",
    "properties.search_id.meta.title": "string",
    "properties.search_id.meta.uri": "string",
    "properties.search_id.numPages": "string",
    "properties.search_id.oonFacilities": "",
    "properties.search_id.page": "string",
    "properties.search_id.phone.nationalSparephone": "string",
    "properties.search_id.phone.nationalSparephoneUnformatted": "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.namespace": "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.variation": "string",
    "properties.search_id.searchParams.visitId": "string",
    "properties.search_id.searchType": "string",
    "properties.search_id.staticMapUrl": "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.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 457
schema_scan_id: 5741909
updated: 2021-01-14 15:22:19

Version 4684320

created: 2021-01-14 15:17:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
    "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_product_list_viewed`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_product_list_viewed`\n(\n`integrations`struct<`_empty_`:STRING>,`event`STRING,`version`STRING,`timestamp`STRING,`originalTimestamp`STRING,`receivedAt`STRING,`projectId`STRING,`userId`STRING,`_origin`STRING,`anonymousId`STRING,`properties`struct<`search_id`:STRING,`value`:STRING,`env`:STRING,`searchId`:STRING,`site_id`:STRING,`products`:array,`searchTerm`:STRING,`isReact`:STRING,`category`:STRING,`list_id`:STRING,`page`:STRING,`Hit_Timestamp`:STRING,`productIds`:array>,`channel`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`messageId`STRING,`context`struct<`locale`:STRING,`userAgent`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`page`:struct<`title`:STRING,`search`:STRING,`url`:STRING,`path`:STRING,`referrer`:STRING>,`ip`:STRING,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING>>,`type`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/Product List Viewed'\n",
    "MSCK REPAIR TABLE sfdl_dev_segment.reactfoot_product_list_viewed"
]

hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed
id: 4684320
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2021-01-14T21:16:28Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1610582400000/1610658927893.677a3104e83b.fde281a.f9827fc6-6718-4679-98de-0e17ddbd3a75.gz|segment_separator:34",
    "anonymousId": "cd10903f-6b90-45b5-9523-af0e3cda0f53",
    "channel": "client",
    "context": {
        "campaign": {},
        "ip": "34.239.223.223",
        "library": {
            "name": "analytics.js",
            "version": "4.0.4"
        },
        "locale": "en-US",
        "page": {
            "path": "/search",
            "referrer": "",
            "search": "?q=sparefoot.moreyard%2FBoulder-CO-self-storage.html&rlz=1C5CHFA_enUS890US890&oq=sparefoot.moreyard%2FBoulder-CO-self-storage.html&aqs=chrome..69i57j69i58.2307j0j4&sourceid=chrome&ie=UTF-8",
            "title": "",
            "url": "https://sparefoot.moreyard.com/search?q=sparefoot.moreyard%2FBoulder-CO-self-storage.html&rlz=1C5CHFA_enUS890US890&oq=sparefoot.moreyard%2FBoulder-CO-self-storage.html&aqs=chrome..69i57j69i58.2307j0j4&sourceid=chrome&ie=UTF-8"
        },
        "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 11_1_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.141 Safari/537.36"
    },
    "event": "Product List Viewed",
    "integrations": {},
    "messageId": "ajs-931b27bd032be41bc8e2023ea1b3a642",
    "originalTimestamp": "2021-01-14T20:21:06.844Z",
    "projectId": "iHhi46PCMy",
    "properties": {
        "Hit Timestamp": 1610655666195,
        "env": "dev",
        "isReact": true,
        "list_id": "search results: null",
        "page": 1,
        "productIds": [],
        "products": [],
        "searchTerm": null,
        "search_id": null,
        "site_id": -1,
        "value": 0
    },
    "receivedAt": "2021-01-14T20:21:07.488Z",
    "sentAt": "2021-01-14T20:21:06.846Z",
    "timestamp": "2021-01-14T20:21:07.486Z",
    "type": "track",
    "userId": "83efe9f3e02352af468c186c5e142878",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "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.isReact": "string",
    "properties.list_id": "string",
    "properties.page": "string",
    "properties.productIds": [
        "string"
    ],
    "properties.products": [
        "string"
    ],
    "properties.searchId": "string",
    "properties.searchTerm": "string",
    "properties.search_id": "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.contentStats.highestMonth": "string",
    "properties.search_id.content.contentStats.lowestMonth": "string",
    "properties.search_id.content.contentStats.yearlyPriceVariance": "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.averagePrices.10x10.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.10x15.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.10x20.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.5x10.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.5x5.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.overall.price": "string",
    "properties.search_id.content.pricingStats.lowestPrices": "",
    "properties.search_id.content.weather.almanacNormalHigh": "string",
    "properties.search_id.content.weather.almanacNormalLow": "string",
    "properties.search_id.content.weather.almanacRecordHigh": "string",
    "properties.search_id.content.weather.almanacRecordLow": "string",
    "properties.search_id.content.weather.forecastHigh": "string",
    "properties.search_id.content.weather.forecastLow": "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.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.landingFacilities": "",
    "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.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.headline": "string",
    "properties.search_id.meta.logo": "string",
    "properties.search_id.meta.noindex": "string",
    "properties.search_id.meta.tags.links": "",
    "properties.search_id.meta.tags.meta.description": "string",
    "properties.search_id.meta.tags.og.description": "string",
    "properties.search_id.meta.tags.og.image": "string",
    "properties.search_id.meta.tags.og.site": "string",
    "properties.search_id.meta.tags.og.title": "string",
    "properties.search_id.meta.tags.og.url": "string",
    "properties.search_id.meta.tags.title": "string",
    "properties.search_id.meta.title": "string",
    "properties.search_id.meta.uri": "string",
    "properties.search_id.numPages": "string",
    "properties.search_id.oonFacilities": "",
    "properties.search_id.page": "string",
    "properties.search_id.phone.nationalSparephone": "string",
    "properties.search_id.phone.nationalSparephoneUnformatted": "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.namespace": "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.variation": "string",
    "properties.search_id.searchParams.visitId": "string",
    "properties.search_id.searchType": "string",
    "properties.search_id.staticMapUrl": "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.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 457
schema_scan_id: 5741897
updated: 2021-01-14 15:19:40

Schema Scans: 13

Last at 2021-01-19 17:23:20

Scan 5744008

duration: 0:02:30.833603

exit_message:

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

id: 5744008

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2021-01-19/",
        "name": "dt",
        "type": "string",
        "value": "2021-01-19"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-dev",
        "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed",
        "key": "separated_dt/Product List Viewed/dt=2021-01-19/1611098133599.a9b5dd643d48.fde281a.5b21dce5-2e2e-4247-9b5f-c02ebd079bb4.gz.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_segment.reactfoot_Product_List_Viewed",
        "type": "segment"
    }
}

running: False
schema_name_id: 457
start_time: 2021-01-19 17:23:20
success: True
trace_id: 2471148902783309638

Scan 5743991

duration: 0:02:38.941484

exit_message:

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

id: 5743991

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2021-01-19/",
        "name": "dt",
        "type": "string",
        "value": "2021-01-19"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-dev",
        "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed",
        "key": "separated_dt/Product List Viewed/dt=2021-01-19/1611098122098.7e6817953e19.fde281a.ca0ab7ca-da68-43f2-8bbb-b21993637240.gz.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_segment.reactfoot_Product_List_Viewed",
        "type": "segment"
    }
}

running: False
schema_name_id: 457
start_time: 2021-01-19 17:20:37
success: True
trace_id: 18221380821824581633

Scan 5743979

duration: 0:02:45.904071

exit_message:

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

id: 5743979

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2021-01-19/",
        "name": "dt",
        "type": "string",
        "value": "2021-01-19"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-dev",
        "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed",
        "key": "separated_dt/Product List Viewed/dt=2021-01-19/1611098120885.ded3d6ab077b.fde281a.dd0d69f4-5d1b-44e7-b19b-08966e739f8d.gz.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_segment.reactfoot_Product_List_Viewed",
        "type": "segment"
    }
}

running: False
schema_name_id: 457
start_time: 2021-01-19 17:17:48
success: True
trace_id: 9357360753386075519

Scan 5743946

duration: 0:02:40.888856

exit_message:

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

id: 5743946

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2021-01-19/",
        "name": "dt",
        "type": "string",
        "value": "2021-01-19"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-dev",
        "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed",
        "key": "separated_dt/Product List Viewed/dt=2021-01-19/1611097416438.db7aa8f52935.fde281a.e69994b7-ea6b-4690-be9c-e604fd094deb.gz.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_segment.reactfoot_Product_List_Viewed",
        "type": "segment"
    }
}

running: False
schema_name_id: 457
start_time: 2021-01-19 17:07:39
success: True
trace_id: 8708647105863126332

Scan 5743839

duration: 0:02:44.201730

exit_message:

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

id: 5743839

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2021-01-19/",
        "name": "dt",
        "type": "string",
        "value": "2021-01-19"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-dev",
        "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed",
        "key": "separated_dt/Product List Viewed/dt=2021-01-19/1611094516353.dd4b770bc6c6.fde281a.d0cc62f4-1637-472f-8f0a-f6fddcbcb446.gz.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_segment.reactfoot_Product_List_Viewed",
        "type": "segment"
    }
}

running: False
schema_name_id: 457
start_time: 2021-01-19 16:15:42
success: True
trace_id: 16297212142200779966

Scan 5743825

duration: 0:02:36.520951

exit_message:

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

id: 5743825

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2021-01-19/",
        "name": "dt",
        "type": "string",
        "value": "2021-01-19"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-dev",
        "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed",
        "key": "separated_dt/Product List Viewed/dt=2021-01-19/1611090943768.8bcaf413aec8.fde281a.93f57f20-a216-4ffd-bdd4-2b32b8d7e5f5.gz.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_segment.reactfoot_Product_List_Viewed",
        "type": "segment"
    }
}

running: False
schema_name_id: 457
start_time: 2021-01-19 15:27:11
success: True
trace_id: 17848588378024252600

Scan 5742510

duration: 0:02:41.177875

exit_message:

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

id: 5742510

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2021-01-15/",
        "name": "dt",
        "type": "string",
        "value": "2021-01-15"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-dev",
        "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed",
        "key": "separated_dt/Product List Viewed/dt=2021-01-15/1610737410869.b3282638195e.fde281a.437f35d6-df21-4efe-9d81-f883f01f44cf.gz.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_segment.reactfoot_Product_List_Viewed",
        "type": "segment"
    }
}

running: False
schema_name_id: 457
start_time: 2021-01-15 13:08:19
success: True
trace_id: 11064583491090254217

Scan 5742504

duration: 0:02:40.921156

exit_message:

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

id: 5742504

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2021-01-15/",
        "name": "dt",
        "type": "string",
        "value": "2021-01-15"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-dev",
        "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed",
        "key": "separated_dt/Product List Viewed/dt=2021-01-15/1610737403675.7afa618686ae.fde281a.bd7bac95-658b-4885-8f75-5c26e4acf816.gz.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_segment.reactfoot_Product_List_Viewed",
        "type": "segment"
    }
}

running: False
schema_name_id: 457
start_time: 2021-01-15 13:05:37
success: True
trace_id: 14210037474376442672

Scan 5742491

duration: 0:02:36.998896

exit_message:

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

id: 5742491

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2021-01-15/",
        "name": "dt",
        "type": "string",
        "value": "2021-01-15"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-dev",
        "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed",
        "key": "separated_dt/Product List Viewed/dt=2021-01-15/1610734535955.f83d63fe07ed.fde281a.0994c20b-1706-4884-b16c-c75003c1fdac.gz.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_segment.reactfoot_Product_List_Viewed",
        "type": "segment"
    }
}

running: False
schema_name_id: 457
start_time: 2021-01-15 12:24:19
success: True
trace_id: 13702930172447011256

Scan 5742475

duration: 0:02:46.191456

exit_message:

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

id: 5742475

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2021-01-15/",
        "name": "dt",
        "type": "string",
        "value": "2021-01-15"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-dev",
        "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed",
        "key": "separated_dt/Product List Viewed/dt=2021-01-15/1610734522794.8812454c863c.fde281a.9e06409b-0c57-4222-aff6-f5fa3da71b24.gz.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_segment.reactfoot_Product_List_Viewed",
        "type": "segment"
    }
}

running: False
schema_name_id: 457
start_time: 2021-01-15 12:19:18
success: True
trace_id: 12956973418614153951

Scan 5741921

duration: 0:02:33.179727

exit_message:

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

id: 5741921

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2021-01-14/",
        "name": "dt",
        "type": "string",
        "value": "2021-01-14"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-dev",
        "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed",
        "key": "separated_dt/Product List Viewed/dt=2021-01-14/1610658941665.d620080c67f3.fde281a.b0bbb2de-1a1c-4ca2-a29a-871cb704456a.gz.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_segment.reactfoot_Product_List_Viewed",
        "type": "segment"
    }
}

running: False
schema_name_id: 457
start_time: 2021-01-14 15:27:18
success: True
trace_id: 9567252711002590041

Scan 5741909

duration: 0:02:36.909922

exit_message:

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

id: 5741909

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2021-01-14/",
        "name": "dt",
        "type": "string",
        "value": "2021-01-14"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-dev",
        "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed",
        "key": "separated_dt/Product List Viewed/dt=2021-01-14/1610658919923.e460f5add6c4.fde281a.2685c18e-7d4e-4113-8bbc-99ad3d86e5f5.gz.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_segment.reactfoot_Product_List_Viewed",
        "type": "segment"
    }
}

running: False
schema_name_id: 457
start_time: 2021-01-14 15:19:49
success: True
trace_id: 1962115800865408386

Scan 5741897

duration: 0:02:45.674677

exit_message:

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

id: 5741897

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2021-01-14/",
        "name": "dt",
        "type": "string",
        "value": "2021-01-14"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-dev",
        "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed",
        "key": "separated_dt/Product List Viewed/dt=2021-01-14/1610658927893.677a3104e83b.fde281a.f9827fc6-6718-4679-98de-0e17ddbd3a75.gz.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_segment.reactfoot_Product_List_Viewed",
        "type": "segment"
    }
}

running: False
schema_name_id: 457
start_time: 2021-01-14 15:17:00
success: True
trace_id: 2497176763237248958

Partitions:

count: 3

ddl:

[
    "ALTER TABLE\n    `sfdl_dev_segment.reactfoot_product_list_viewed`\nADD\n\n\n PARTITION (dt='2021-02-03') location 's3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2021-02-03/'\n PARTITION (dt='2021-02-08') location 's3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2021-02-08/'\n PARTITION (dt='2021-02-09') location 's3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2021-02-09/'\n;"
]

name: dt

state:

[
    {
        "info": {
            "id": 164837,
            "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2021-02-03/",
            "name": "dt",
            "value": "2021-02-03"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2021-02-03 14:16:23",
                "last_data": "2021-02-03 14:17:19"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 164962,
            "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2021-02-08/",
            "name": "dt",
            "value": "2021-02-08"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2021-02-08 10:15:10",
                "last_data": "2021-02-08 16:16:41"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 164997,
            "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2021-02-09/",
            "name": "dt",
            "value": "2021-02-09"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2021-02-09 09:07:19",
                "last_data": "2021-02-09 09:10:30"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    }
]

type: string

Schema:

attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "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.isReact": "string",
    "properties.list_id": "string",
    "properties.page": "string",
    "properties.productIds": [
        "int"
    ],
    "properties.products": [
        {
            "distance": "string",
            "hasContactlessBadge": "string",
            "hasErentalBadge": "string",
            "id": "string",
            "inNetwork": "string",
            "isTopYielder": "string",
            "name": "string",
            "position": "string",
            "rank": "string",
            "reviewAverage": "string",
            "reviewCount": "string",
            "unitCount": "string",
            "units": [
                {
                    "id": "string",
                    "maxBookingDate": "string",
                    "priceValue": "string",
                    "promotion": "string",
                    "sizeText": "string",
                    "squareFootage": "string",
                    "unitTypeText": "string"
                }
            ]
        }
    ],
    "properties.searchId": "string",
    "properties.searchTerm": "string",
    "properties.search_id": "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.contentStats.highestMonth": "string",
    "properties.search_id.content.contentStats.lowestMonth": "string",
    "properties.search_id.content.contentStats.yearlyPriceVariance": "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.averagePrices.10x10.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.10x15.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.10x20.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.5x10.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.5x5.price": "string",
    "properties.search_id.content.pricingStats.averagePrices.overall.price": "string",
    "properties.search_id.content.pricingStats.lowestPrices": "",
    "properties.search_id.content.weather.almanacNormalHigh": "string",
    "properties.search_id.content.weather.almanacNormalLow": "string",
    "properties.search_id.content.weather.almanacRecordHigh": "string",
    "properties.search_id.content.weather.almanacRecordLow": "string",
    "properties.search_id.content.weather.forecastHigh": "string",
    "properties.search_id.content.weather.forecastLow": "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.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.landingFacilities": "",
    "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.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.headline": "string",
    "properties.search_id.meta.logo": "string",
    "properties.search_id.meta.noindex": "string",
    "properties.search_id.meta.tags.links": "",
    "properties.search_id.meta.tags.meta.description": "string",
    "properties.search_id.meta.tags.og.description": "string",
    "properties.search_id.meta.tags.og.image": "string",
    "properties.search_id.meta.tags.og.site": "string",
    "properties.search_id.meta.tags.og.title": "string",
    "properties.search_id.meta.tags.og.url": "string",
    "properties.search_id.meta.tags.title": "string",
    "properties.search_id.meta.title": "string",
    "properties.search_id.meta.uri": "string",
    "properties.search_id.numPages": "string",
    "properties.search_id.oonFacilities": "",
    "properties.search_id.page": "string",
    "properties.search_id.phone.nationalSparephone": "string",
    "properties.search_id.phone.nationalSparephoneUnformatted": "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.namespace": "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.variation": "string",
    "properties.search_id.searchParams.visitId": "string",
    "properties.search_id.searchType": "string",
    "properties.search_id.staticMapUrl": "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.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

created: 2021-01-19 17:23:20

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_product_list_viewed`\n(\n`integrations`struct<`_empty_`:STRING>,`event`STRING,`version`STRING,`timestamp`STRING,`originalTimestamp`STRING,`receivedAt`STRING,`projectId`STRING,`userId`STRING,`_origin`STRING,`anonymousId`STRING,`properties`struct<`search_id`:STRING,`value`:STRING,`env`:STRING,`searchId`:STRING,`site_id`:STRING,`products`:array>,`position`:STRING,`reviewAverage`:STRING,`id`:STRING>>,`searchTerm`:STRING,`isReact`:STRING,`category`:STRING,`list_id`:STRING,`page`:STRING,`Hit_Timestamp`:STRING,`productIds`:array>,`channel`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`messageId`STRING,`context`struct<`locale`:STRING,`userAgent`:STRING,`page`:struct<`title`:STRING,`search`:STRING,`url`:STRING,`path`:STRING,`referrer`:STRING>,`ip`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING>>,`type`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/Product List Viewed'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_product_list_viewed`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_segment.reactfoot_product_list_viewed"
}

Server:

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

Raw:

{
    "name": {
        "created": "2017-11-01 17:01:22",
        "disabled": false,
        "format": "raw",
        "id": 457,
        "is_partitioned": true,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_dev_segment",
            "table": "reactfoot_product_list_viewed"
        },
        "type": "segment"
    },
    "partition": {
        "count": 3,
        "ddl": [
            "ALTER TABLE\n    `sfdl_dev_segment.reactfoot_product_list_viewed`\nADD\n\n\n PARTITION (dt='2021-02-03') location 's3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2021-02-03/'\n PARTITION (dt='2021-02-08') location 's3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2021-02-08/'\n PARTITION (dt='2021-02-09') location 's3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2021-02-09/'\n;"
        ],
        "name": "dt",
        "state": [
            {
                "info": {
                    "id": 164837,
                    "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2021-02-03/",
                    "name": "dt",
                    "value": "2021-02-03"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2021-02-03 14:16:23",
                        "last_data": "2021-02-03 14:17:19"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 164962,
                    "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2021-02-08/",
                    "name": "dt",
                    "value": "2021-02-08"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2021-02-08 10:15:10",
                        "last_data": "2021-02-08 16:16:41"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 164997,
                    "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2021-02-09/",
                    "name": "dt",
                    "value": "2021-02-09"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2021-02-09 09:07:19",
                        "last_data": "2021-02-09 09:10:30"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            }
        ],
        "type": "string"
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "anonymousId": "string",
            "channel": "string",
            "context.campaign.content": "string",
            "context.campaign.medium": "string",
            "context.campaign.name": "string",
            "context.ip": "string",
            "context.library.name": "string",
            "context.library.version": "string",
            "context.locale": "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.isReact": "string",
            "properties.list_id": "string",
            "properties.page": "string",
            "properties.productIds": [
                "int"
            ],
            "properties.products": [
                {
                    "distance": "string",
                    "hasContactlessBadge": "string",
                    "hasErentalBadge": "string",
                    "id": "string",
                    "inNetwork": "string",
                    "isTopYielder": "string",
                    "name": "string",
                    "position": "string",
                    "rank": "string",
                    "reviewAverage": "string",
                    "reviewCount": "string",
                    "unitCount": "string",
                    "units": [
                        {
                            "id": "string",
                            "maxBookingDate": "string",
                            "priceValue": "string",
                            "promotion": "string",
                            "sizeText": "string",
                            "squareFootage": "string",
                            "unitTypeText": "string"
                        }
                    ]
                }
            ],
            "properties.searchId": "string",
            "properties.searchTerm": "string",
            "properties.search_id": "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.contentStats.highestMonth": "string",
            "properties.search_id.content.contentStats.lowestMonth": "string",
            "properties.search_id.content.contentStats.yearlyPriceVariance": "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.averagePrices.10x10.price": "string",
            "properties.search_id.content.pricingStats.averagePrices.10x15.price": "string",
            "properties.search_id.content.pricingStats.averagePrices.10x20.price": "string",
            "properties.search_id.content.pricingStats.averagePrices.5x10.price": "string",
            "properties.search_id.content.pricingStats.averagePrices.5x5.price": "string",
            "properties.search_id.content.pricingStats.averagePrices.overall.price": "string",
            "properties.search_id.content.pricingStats.lowestPrices": "",
            "properties.search_id.content.weather.almanacNormalHigh": "string",
            "properties.search_id.content.weather.almanacNormalLow": "string",
            "properties.search_id.content.weather.almanacRecordHigh": "string",
            "properties.search_id.content.weather.almanacRecordLow": "string",
            "properties.search_id.content.weather.forecastHigh": "string",
            "properties.search_id.content.weather.forecastLow": "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.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.landingFacilities": "",
            "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.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.headline": "string",
            "properties.search_id.meta.logo": "string",
            "properties.search_id.meta.noindex": "string",
            "properties.search_id.meta.tags.links": "",
            "properties.search_id.meta.tags.meta.description": "string",
            "properties.search_id.meta.tags.og.description": "string",
            "properties.search_id.meta.tags.og.image": "string",
            "properties.search_id.meta.tags.og.site": "string",
            "properties.search_id.meta.tags.og.title": "string",
            "properties.search_id.meta.tags.og.url": "string",
            "properties.search_id.meta.tags.title": "string",
            "properties.search_id.meta.title": "string",
            "properties.search_id.meta.uri": "string",
            "properties.search_id.numPages": "string",
            "properties.search_id.oonFacilities": "",
            "properties.search_id.page": "string",
            "properties.search_id.phone.nationalSparephone": "string",
            "properties.search_id.phone.nationalSparephoneUnformatted": "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.namespace": "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.variation": "string",
            "properties.search_id.searchParams.visitId": "string",
            "properties.search_id.searchType": "string",
            "properties.search_id.staticMapUrl": "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.value": "string",
            "receivedAt": "string",
            "sentAt": "string",
            "timestamp": "string",
            "type": "string",
            "userId": "string",
            "version": "string"
        },
        "created": "2021-01-19 17:23:20",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_product_list_viewed`\n(\n`integrations`struct<`_empty_`:STRING>,`event`STRING,`version`STRING,`timestamp`STRING,`originalTimestamp`STRING,`receivedAt`STRING,`projectId`STRING,`userId`STRING,`_origin`STRING,`anonymousId`STRING,`properties`struct<`search_id`:STRING,`value`:STRING,`env`:STRING,`searchId`:STRING,`site_id`:STRING,`products`:array>,`position`:STRING,`reviewAverage`:STRING,`id`:STRING>>,`searchTerm`:STRING,`isReact`:STRING,`category`:STRING,`list_id`:STRING,`page`:STRING,`Hit_Timestamp`:STRING,`productIds`:array>,`channel`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`messageId`STRING,`context`struct<`locale`:STRING,`userAgent`:STRING,`page`:struct<`title`:STRING,`search`:STRING,`url`:STRING,`path`:STRING,`referrer`:STRING>,`ip`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING>>,`type`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/Product List Viewed'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_product_list_viewed`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_segment.reactfoot_product_list_viewed"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}