Schema Info

Schema Name: sfdl_prod_segment.reactfoot_product_list_viewed

created: 2017-11-02 14:02:24
disabled: False
format: raw
id: 131
is_partitioned: True
is_schema_datatyped: False

name:

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

type: segment

Schema Versions: 15

Version 157534

created: 2020-07-28 06:12:42

ddl:

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

hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed
id: 157534
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2020-07-28T10:50:07Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1595894400000/1595933217338.7a853f86712f.baa71ec.ca845833-c5fa-4c3d-8817-df78f9b06680.gz|segment_separator:37",
    "anonymousId": "c56ae69a-7749-4284-b633-b6cfe5271ff2",
    "channel": "client",
    "context": {
        "campaign": {},
        "ip": "66.102.8.205",
        "library": {
            "name": "analytics.js",
            "version": "3.13.5"
        },
        "locale": "en-US",
        "page": {
            "path": "/Washington-DC-self-storage.html",
            "referrer": "",
            "search": "",
            "title": "",
            "url": "https://www.sparefoot.com/Washington-DC-self-storage.html"
        },
        "userAgent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.92 Safari/537.36"
    },
    "event": "Product List Viewed",
    "integrations": {},
    "messageId": "ajs-a537d04d48a39ab7399ca53d3c10fcb7",
    "originalTimestamp": "2020-07-28T09:53:07.265Z",
    "projectId": "a0wkEvFBBK",
    "properties": {
        "Hit Timestamp": 1595929987192,
        "category": "Selinsgrove, PA-vehicleLandingPage",
        "env": "production",
        "isReact": true,
        "list_id": "search results: null",
        "page": 1,
        "productIds": [
            214194,
            209835,
            212913
        ],
        "products": [
            {
                "distance": 29.5,
                "hasClosestBadge": false,
                "hasContactlessBadge": true,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 107528,
                "inNetwork": true,
                "name": "Muncy Self Storage, Inc.",
                "position": 4,
                "rank": 4,
                "reviewAverage": 4.583,
                "reviewCount": 18,
                "unitCount": 1,
                "units": [
                    {
                        "id": 10041051,
                        "maxBookingDate": "2020-07-31T02:20:02.000Z",
                        "priceValue": 172,
                        "promotion": "Waived admin fee when you reserve online",
                        "sizeText": "10' x 30'",
                        "squareFootage": 300,
                        "unitTypeText": "unit"
                    }
                ]
            }
        ],
        "searchTerm": null,
        "search_id": null,
        "site_id": -1,
        "value": 0
    },
    "receivedAt": "2020-07-28T09:53:28.950Z",
    "sentAt": "2020-07-28T09:53:07.272Z",
    "timestamp": "2020-07-28T09:53:28.943Z",
    "type": "track",
    "userId": "error",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.amp.id": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.campaign.term": "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",
    "integrations.campaign.content": "string",
    "integrations.campaign.medium": "string",
    "integrations.campaign.name": "string",
    "integrations.campaign.source": "string",
    "integrations.library.name": "string",
    "integrations.library.version": "string",
    "integrations.page.path": "string",
    "integrations.page.referrer": "string",
    "integrations.page.search": "string",
    "integrations.page.title": "string",
    "integrations.page.url": "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",
            "hasClosestBadge": "string",
            "hasContactlessBadge": "string",
            "hasRecommendedBadge": "string",
            "hasTopratedBadge": "string",
            "id": "string",
            "inNetwork": "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.searchTerm": "string",
    "properties.search_id": "string",
    "properties.site_id": "string",
    "properties.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 131
schema_scan_id: 40312275
updated: 2020-07-28 06:23:39

Version 157532

created: 2020-07-28 06:08:39

ddl:

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

hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed
id: 157532
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2020-07-28T10:13:12Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1595894400000/1595930807750.7c46c64530d3.baa71ec.7c12e660-b184-4ebe-b1e0-55653ac50af1.gz|segment_separator:37",
    "anonymousId": "375fe116-3341-4ff5-8ca6-57ba212d14d7",
    "channel": "client",
    "context": {
        "campaign": {},
        "ip": "174.128.181.5",
        "library": {
            "name": "analytics.js",
            "version": "3.13.5"
        },
        "locale": "en-US",
        "page": {
            "path": "/search.html",
            "referrer": "https://www.sparefoot.com/santa-clara-ca-self-storage.html?&tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=pro_national_nogeo_noproduct_dynamic&utm_content=&ploc=21176&iloc=1014249&mkwid=s%7Cpcrid%7C341926302869%7Cpkw%7C%7Cpmt%7Cb%7Cpdv%7Cm%7Cpgrid%7C32834077751%7Cptaid%7Cdsa-660763673706&pgrid=32834077751&ptaid=dsa-660763673706&gclid=EAIaIQobChMI2evLhMTv6gIVDNvACh25rQsHEAAYAyAAEgLOBvD_BwE",
            "search": "?location=Palo%20Alto%2C%20CA%2094306%2C%20USA&order=recommended&latitude=37.4177563&longitude=-122.1235054&zip=94306",
            "title": "",
            "url": "https://www.sparefoot.com/search.html?location=Palo%20Alto%2C%20CA%2094306%2C%20USA&order=recommended&latitude=37.4177563&longitude=-122.1235054&zip=94306"
        },
        "userAgent": "Mozilla/5.0 (iPhone; CPU iPhone OS 13_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/80.0.3987.95 Mobile/15E148 Safari/604.1"
    },
    "event": "Product List Viewed",
    "integrations": {},
    "messageId": "ajs-f5ca9daba3cf50e38d0d7564fef1e651",
    "originalTimestamp": "2020-07-28T09:19:30.054Z",
    "projectId": "a0wkEvFBBK",
    "properties": {
        "Hit Timestamp": 1595927969847,
        "env": "production",
        "isReact": true,
        "list_id": "search results: null",
        "page": 1,
        "productIds": [],
        "products": [],
        "searchTerm": null,
        "search_id": null,
        "site_id": -1,
        "value": 0
    },
    "receivedAt": "2020-07-28T09:19:30.234Z",
    "sentAt": "2020-07-28T09:19:30.057Z",
    "timestamp": "2020-07-28T09:19:30.231Z",
    "type": "track",
    "userId": "2ed8bbaa28c33f18ad0b55642fd19d85",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.amp.id": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.campaign.term": "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",
    "integrations.campaign.content": "string",
    "integrations.campaign.medium": "string",
    "integrations.campaign.name": "string",
    "integrations.campaign.source": "string",
    "integrations.library.name": "string",
    "integrations.library.version": "string",
    "integrations.page.path": "string",
    "integrations.page.referrer": "string",
    "integrations.page.search": "string",
    "integrations.page.title": "string",
    "integrations.page.url": "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.searchTerm": "string",
    "properties.search_id": "string",
    "properties.site_id": "string",
    "properties.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 131
schema_scan_id: 40312209
updated: 2020-07-28 06:13:14

Version 157531

created: 2020-07-28 06:07:16

ddl:

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

hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed
id: 157531
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2020-07-28T11:06:53Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1595894400000/1595934393595.046a4f835cfb.baa71ec.4addbf74-cacb-4204-a98d-4dc324c21233.gz|segment_separator:37",
    "anonymousId": "9f8b28f7-9d65-4400-8dfa-5c745a810346",
    "channel": "client",
    "context": {
        "campaign": {},
        "ip": "120.29.84.174",
        "library": {
            "name": "analytics.js",
            "version": "3.13.5"
        },
        "locale": "en-US",
        "page": {
            "path": "/Chester-PA-self-storage.html",
            "referrer": "https://www.google.com/",
            "search": "?city=Chester&state=PA&location=Chester%2C%20PA&searchType=storage&order=distance&page=1&listingsPerPage=15&subPageType=cityLandingPage&includeBadgedFacilities=true",
            "title": "15 Cheap Storage Units Chester, PA (from $19) | Compare & Save",
            "url": "https://www.sparefoot.com/Chester-PA-self-storage.html?city=Chester&state=PA&location=Chester%2C%20PA&searchType=storage&order=distance&page=1&listingsPerPage=15&subPageType=cityLandingPage&includeBadgedFacilities=true"
        },
        "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.89 Safari/537.36"
    },
    "event": "Product List Viewed",
    "integrations": {},
    "messageId": "ajs-695f94f3f2488fac5bafb90f4bd5c9fe",
    "originalTimestamp": "2020-07-28T10:24:01.066Z",
    "projectId": "a0wkEvFBBK",
    "properties": {
        "Hit Timestamp": 1595931841059,
        "category": "Chester, PA-cityLandingPage",
        "env": "production",
        "isReact": true,
        "list_id": "search results: Chester, PA",
        "page": 1,
        "productIds": [
            50481,
            203272,
            201898,
            50489,
            200887,
            205562,
            149828,
            213809,
            217248,
            152882,
            152883,
            179945,
            190765,
            191083,
            192261
        ],
        "products": [
            {
                "distance": 5.2,
                "hasClosestBadge": false,
                "hasContactlessBadge": true,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 199142,
                "inNetwork": true,
                "name": "Folcroft Secured Storage",
                "position": 15,
                "rank": 15,
                "reviewAverage": 4.786,
                "reviewCount": 7,
                "unitCount": 3,
                "units": [
                    {
                        "id": 17639474,
                        "maxBookingDate": "2020-08-04T04:18:27.000Z",
                        "priceValue": 153,
                        "promotion": "",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            }
        ],
        "searchTerm": "Chester, PA",
        "search_id": "773a5f1ffc8d949296.12269410",
        "site_id": -1,
        "value": 15
    },
    "receivedAt": "2020-07-28T10:24:05.900Z",
    "sentAt": "2020-07-28T10:24:01.076Z",
    "timestamp": "2020-07-28T10:24:05.890Z",
    "type": "track",
    "userId": "62e27f7d68789e6fe05cb5e77b73448d",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.amp.id": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.campaign.term": "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",
    "integrations.campaign.content": "string",
    "integrations.campaign.medium": "string",
    "integrations.campaign.name": "string",
    "integrations.campaign.source": "string",
    "integrations.library.name": "string",
    "integrations.library.version": "string",
    "integrations.page.path": "string",
    "integrations.page.referrer": "string",
    "integrations.page.search": "string",
    "integrations.page.title": "string",
    "integrations.page.url": "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",
            "hasClosestBadge": "string",
            "hasContactlessBadge": "string",
            "hasRecommendedBadge": "string",
            "hasTopratedBadge": "string",
            "id": "string",
            "inNetwork": "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.searchTerm": "string",
    "properties.search_id": "string",
    "properties.site_id": "string",
    "properties.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 131
schema_scan_id: 40312157
updated: 2020-07-28 06:11:49

Version 157525

created: 2020-07-28 05:55:52

ddl:

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

hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed
id: 157525
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2020-07-28T10:13:24Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1595894400000/1595930809882.9112e2721a43.baa71ec.1139c474-369c-420b-8d0e-0b27ea84fcc0.gz|segment_separator:37",
    "anonymousId": "504f8b09-f052-446d-855d-95eac81ff529",
    "channel": "client",
    "context": {
        "campaign": {},
        "ip": "172.56.40.233",
        "library": {
            "name": "analytics.js",
            "version": "3.13.5"
        },
        "locale": "en-US",
        "page": {
            "path": "/Ogden-UT-self-storage.html",
            "referrer": "https://www.google.com/",
            "search": "",
            "title": "",
            "url": "https://www.sparefoot.com/Ogden-UT-self-storage.html"
        },
        "userAgent": "Mozilla/5.0 (Linux; Android 9; SM-A102U) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.106 Mobile Safari/537.36"
    },
    "event": "Product List Viewed",
    "integrations": {},
    "messageId": "ajs-da17faaa36171f385a377575f76eafb1",
    "originalTimestamp": "2020-07-28T09:29:03.181Z",
    "projectId": "a0wkEvFBBK",
    "properties": {
        "Hit Timestamp": 1595928537293,
        "env": "production",
        "isReact": true,
        "list_id": "search results: null",
        "page": 1,
        "productIds": [],
        "products": [],
        "searchTerm": null,
        "search_id": null,
        "site_id": -1,
        "value": 0
    },
    "receivedAt": "2020-07-28T09:29:06.990Z",
    "sentAt": "2020-07-28T09:29:03.193Z",
    "timestamp": "2020-07-28T09:29:06.978Z",
    "type": "track",
    "userId": "error",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.amp.id": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.campaign.term": "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",
    "integrations.campaign.content": "string",
    "integrations.campaign.medium": "string",
    "integrations.campaign.name": "string",
    "integrations.campaign.source": "string",
    "integrations.library.name": "string",
    "integrations.library.version": "string",
    "integrations.page.path": "string",
    "integrations.page.referrer": "string",
    "integrations.page.search": "string",
    "integrations.page.title": "string",
    "integrations.page.url": "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.searchTerm": "string",
    "properties.search_id": "string",
    "properties.site_id": "string",
    "properties.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 131
schema_scan_id: 40312004
updated: 2020-07-28 06:08:14

Version 157524

created: 2020-07-28 05:55:02

ddl:

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

hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed
id: 157524
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2020-07-28T10:12:03Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1595894400000/1595930810395.7349d09321c9.baa71ec.d00d7303-32c5-4de6-92a6-dcda9a94ba89.gz|segment_separator:37",
    "anonymousId": "eecdeb81-2afe-4626-9927-775d07cad63a",
    "channel": "client",
    "context": {
        "campaign": {
            "content": "",
            "medium": "paidother",
            "name": "discovery_pro_national_similar",
            "source": "google"
        },
        "ip": "68.185.201.42",
        "library": {
            "name": "analytics.js",
            "version": "3.13.5"
        },
        "locale": "en-US",
        "page": {
            "path": "/Denton-TX-self-storage.html",
            "referrer": "https://www.google.com/",
            "search": "",
            "title": "",
            "url": "https://www.sparefoot.com/Denton-TX-self-storage.html"
        },
        "userAgent": "Mozilla/5.0 (Linux; Android 9; LM-X420) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.89 Mobile Safari/537.36"
    },
    "event": "Product List Viewed",
    "integrations": {},
    "messageId": "ajs-2836b2ddf4e9fbd52986ddd94d5b6e0a",
    "originalTimestamp": "2020-07-28T09:08:29.686Z",
    "projectId": "a0wkEvFBBK",
    "properties": {
        "Hit Timestamp": 1595927303623,
        "category": "Park Ridge, IL 60068-storageDealsLandingPage",
        "env": "production",
        "isReact": true,
        "list_id": "search results: null",
        "page": 1,
        "productIds": [
            202696,
            124512,
            125299,
            125090,
            125047,
            87175,
            125054,
            125053,
            124498,
            124496,
            124587,
            77482,
            125045,
            77484,
            197533
        ],
        "products": [
            {
                "distance": 11.6,
                "hasClosestBadge": false,
                "hasContactlessBadge": true,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 202393,
                "inNetwork": true,
                "name": "U-STOR-IT Elmhurst",
                "position": 15,
                "rank": 15,
                "reviewAverage": 4.955,
                "reviewCount": 22,
                "unitCount": 2,
                "units": [
                    {
                        "id": 21748180,
                        "maxBookingDate": "2020-08-08T05:37:24.000Z",
                        "priceValue": 35,
                        "promotion": "The first full month free",
                        "sizeText": "5' x 8'",
                        "squareFootage": 40,
                        "unitTypeText": "unit"
                    }
                ]
            }
        ],
        "searchTerm": null,
        "search_id": null,
        "site_id": -1,
        "value": 0
    },
    "receivedAt": "2020-07-28T09:08:30.500Z",
    "sentAt": "2020-07-28T09:08:29.701Z",
    "timestamp": "2020-07-28T09:08:30.485Z",
    "type": "track",
    "userId": "d67228a661e8ce6b757d65e39494745e",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.amp.id": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.campaign.term": "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",
    "integrations.campaign.content": "string",
    "integrations.campaign.medium": "string",
    "integrations.campaign.name": "string",
    "integrations.campaign.source": "string",
    "integrations.library.name": "string",
    "integrations.library.version": "string",
    "integrations.page.path": "string",
    "integrations.page.referrer": "string",
    "integrations.page.search": "string",
    "integrations.page.title": "string",
    "integrations.page.url": "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",
            "hasClosestBadge": "string",
            "hasContactlessBadge": "string",
            "hasRecommendedBadge": "string",
            "hasTopratedBadge": "string",
            "id": "string",
            "inNetwork": "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.searchTerm": "string",
    "properties.search_id": "string",
    "properties.site_id": "string",
    "properties.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 131
schema_scan_id: 40311996
updated: 2020-07-28 05:59:24

Version 157522

created: 2020-07-28 05:47:35

ddl:

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

hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed
id: 157522
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2020-07-28T10:11:19Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1595894400000/1595930805316.0f2d259f130f.baa71ec.54e48846-f696-43a0-ab4f-c91e651c707a.gz|segment_separator:37",
    "anonymousId": "504f8b09-f052-446d-855d-95eac81ff529",
    "channel": "client",
    "context": {
        "campaign": {},
        "ip": "172.56.40.233",
        "library": {
            "name": "analytics.js",
            "version": "3.13.5"
        },
        "locale": "en-US",
        "page": {
            "path": "/search.html",
            "referrer": "https://www.sparefoot.com/Ogden-UT-self-storage.html",
            "search": "?location=84401&order=recommended",
            "title": "",
            "url": "https://www.sparefoot.com/search.html?location=84401&order=recommended"
        },
        "userAgent": "Mozilla/5.0 (Linux; Android 9; SM-A102U) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.106 Mobile Safari/537.36"
    },
    "event": "Product List Viewed",
    "integrations": {},
    "messageId": "ajs-ced0cf11bbc7cf3a1fec926d4ed9752d",
    "originalTimestamp": "2020-07-28T09:30:10.068Z",
    "projectId": "a0wkEvFBBK",
    "properties": {
        "Hit Timestamp": 1595928609491,
        "env": "production",
        "isReact": true,
        "list_id": "search results: null",
        "page": 1,
        "productIds": [],
        "products": [],
        "searchTerm": null,
        "search_id": null,
        "site_id": -1,
        "value": 0
    },
    "receivedAt": "2020-07-28T09:30:13.275Z",
    "sentAt": "2020-07-28T09:30:10.098Z",
    "timestamp": "2020-07-28T09:30:13.245Z",
    "type": "track",
    "userId": "error",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.amp.id": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.campaign.term": "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",
    "integrations.campaign.content": "string",
    "integrations.campaign.medium": "string",
    "integrations.campaign.name": "string",
    "integrations.campaign.source": "string",
    "integrations.library.name": "string",
    "integrations.library.version": "string",
    "integrations.page.path": "string",
    "integrations.page.referrer": "string",
    "integrations.page.search": "string",
    "integrations.page.title": "string",
    "integrations.page.url": "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.searchTerm": "string",
    "properties.search_id": "string",
    "properties.site_id": "string",
    "properties.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 131
schema_scan_id: 40311951
updated: 2020-07-28 05:55:41

Version 157521

created: 2020-07-28 05:46:15

ddl:

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

hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed
id: 157521
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2020-07-28T10:10:28Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1595894400000/1595930791753.f5060610ee0f.baa71ec.685c51b1-3ae3-48c9-b38b-9171c0a95aab.gz|segment_separator:37",
    "anonymousId": "084f3968-e1c0-4910-ae6f-d48895ffe4c8",
    "channel": "client",
    "context": {
        "campaign": {},
        "ip": "204.236.203.124",
        "library": {
            "name": "analytics.js",
            "version": "3.13.5"
        },
        "locale": "en-US",
        "page": {
            "path": "/Austin-TX-self-storage",
            "referrer": "",
            "search": "?SELENIUM=true",
            "title": "",
            "url": "https://www.sparefoot.com/Austin-TX-self-storage?SELENIUM=true"
        },
        "userAgent": "Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.89 Safari/537.36"
    },
    "event": "Product List Viewed",
    "integrations": {},
    "messageId": "ajs-73d8e227b96bb79de11c42fcabb2cbdf",
    "originalTimestamp": "2020-07-28T09:36:20.648Z",
    "projectId": "a0wkEvFBBK",
    "properties": {
        "Hit Timestamp": 1595928980230,
        "category": "Irmo, SC",
        "env": "production",
        "isReact": true,
        "list_id": "search results: null",
        "page": 1,
        "productIds": [
            87477,
            141301,
            88306,
            87478,
            88311,
            101313,
            82518,
            74252,
            141790,
            176877,
            92248,
            82516,
            197629,
            74256,
            141308
        ],
        "products": [
            {
                "distance": 11.9,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 87477,
                "inNetwork": true,
                "name": "Chapin Self Storage",
                "position": 1,
                "rank": 91,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 1,
                "units": [
                    {
                        "id": -87477,
                        "maxBookingDate": "1970-01-01T00:00:00.000Z",
                        "priceValue": 0,
                        "promotion": "",
                        "sizeText": null,
                        "squareFootage": 0,
                        "unitTypeText": ""
                    }
                ]
            },
            {
                "distance": 11.5,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 141301,
                "inNetwork": true,
                "name": "Palmetto Storage Company Inc",
                "position": 2,
                "rank": 92,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 1,
                "units": [
                    {
                        "id": -141301,
                        "maxBookingDate": "1970-01-01T00:00:00.000Z",
                        "priceValue": 0,
                        "promotion": "",
                        "sizeText": null,
                        "squareFootage": 0,
                        "unitTypeText": ""
                    }
                ]
            },
            {
                "distance": 9.1,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 88306,
                "inNetwork": true,
                "name": "Mini-U-Store Warehouses Inc",
                "position": 3,
                "rank": 93,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 1,
                "units": [
                    {
                        "id": -88306,
                        "maxBookingDate": "1970-01-01T00:00:00.000Z",
                        "priceValue": 0,
                        "promotion": "",
                        "sizeText": null,
                        "squareFootage": 0,
                        "unitTypeText": ""
                    }
                ]
            },
            {
                "distance": 10,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 87478,
                "inNetwork": true,
                "name": "Watford Mini Storage",
                "position": 4,
                "rank": 94,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 1,
                "units": [
                    {
                        "id": -87478,
                        "maxBookingDate": "1970-01-01T00:00:00.000Z",
                        "priceValue": 0,
                        "promotion": "",
                        "sizeText": null,
                        "squareFootage": 0,
                        "unitTypeText": ""
                    }
                ]
            },
            {
                "distance": 9.3,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 88311,
                "inNetwork": true,
                "name": "Q'S Quik Mini Storage",
                "position": 5,
                "rank": 95,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 1,
                "units": [
                    {
                        "id": -88311,
                        "maxBookingDate": "1970-01-01T00:00:00.000Z",
                        "priceValue": 0,
                        "promotion": "",
                        "sizeText": null,
                        "squareFootage": 0,
                        "unitTypeText": ""
                    }
                ]
            },
            {
                "distance": 9.3,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 101313,
                "inNetwork": true,
                "name": "Ez Storage",
                "position": 6,
                "rank": 96,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 1,
                "units": [
                    {
                        "id": -101313,
                        "maxBookingDate": "1970-01-01T00:00:00.000Z",
                        "priceValue": 0,
                        "promotion": "",
                        "sizeText": null,
                        "squareFootage": 0,
                        "unitTypeText": ""
                    }
                ]
            },
            {
                "distance": 9.4,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 82518,
                "inNetwork": true,
                "name": "Meeting Street Mini's Storage",
                "position": 7,
                "rank": 97,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 1,
                "units": [
                    {
                        "id": -82518,
                        "maxBookingDate": "1970-01-01T00:00:00.000Z",
                        "priceValue": 0,
                        "promotion": "",
                        "sizeText": null,
                        "squareFootage": 0,
                        "unitTypeText": ""
                    }
                ]
            },
            {
                "distance": 9.7,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 74252,
                "inNetwork": true,
                "name": "Berry's Air Freight Inc",
                "position": 8,
                "rank": 98,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 1,
                "units": [
                    {
                        "id": -74252,
                        "maxBookingDate": "1970-01-01T00:00:00.000Z",
                        "priceValue": 0,
                        "promotion": "",
                        "sizeText": null,
                        "squareFootage": 0,
                        "unitTypeText": ""
                    }
                ]
            },
            {
                "distance": 9.7,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 141790,
                "inNetwork": true,
                "name": "Attic Space Self Storage Llc",
                "position": 9,
                "rank": 99,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 1,
                "units": [
                    {
                        "id": -141790,
                        "maxBookingDate": "1970-01-01T00:00:00.000Z",
                        "priceValue": 0,
                        "promotion": "",
                        "sizeText": null,
                        "squareFootage": 0,
                        "unitTypeText": ""
                    }
                ]
            },
            {
                "distance": 14.7,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 176877,
                "inNetwork": true,
                "name": "Spring Valley Storage & Business Centre - Columbia - 9005 Two Notch Rd",
                "position": 10,
                "rank": 100,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 1,
                "units": [
                    {
                        "id": -176877,
                        "maxBookingDate": "1970-01-01T00:00:00.000Z",
                        "priceValue": 0,
                        "promotion": "",
                        "sizeText": null,
                        "squareFootage": 0,
                        "unitTypeText": ""
                    }
                ]
            },
            {
                "distance": 9.9,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 92248,
                "inNetwork": true,
                "name": "Aaro Rental Centers",
                "position": 11,
                "rank": 101,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 1,
                "units": [
                    {
                        "id": -92248,
                        "maxBookingDate": "1970-01-01T00:00:00.000Z",
                        "priceValue": 0,
                        "promotion": "",
                        "sizeText": null,
                        "squareFootage": 0,
                        "unitTypeText": ""
                    }
                ]
            },
            {
                "distance": 10.1,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 82516,
                "inNetwork": true,
                "name": "Cayce Mini Warehouse",
                "position": 12,
                "rank": 102,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 1,
                "units": [
                    {
                        "id": -82516,
                        "maxBookingDate": "1970-01-01T00:00:00.000Z",
                        "priceValue": 0,
                        "promotion": "",
                        "sizeText": null,
                        "squareFootage": 0,
                        "unitTypeText": ""
                    }
                ]
            },
            {
                "distance": 11.2,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 197629,
                "inNetwork": true,
                "name": "Palmetto Storage Company Inc - Columbia - 1011 Heyward St",
                "position": 13,
                "rank": 103,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 1,
                "units": [
                    {
                        "id": -197629,
                        "maxBookingDate": "1970-01-01T00:00:00.000Z",
                        "priceValue": 0,
                        "promotion": "",
                        "sizeText": null,
                        "squareFootage": 0,
                        "unitTypeText": ""
                    }
                ]
            },
            {
                "distance": 10.2,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 74256,
                "inNetwork": true,
                "name": "Center City Storage",
                "position": 14,
                "rank": 104,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 1,
                "units": [
                    {
                        "id": -74256,
                        "maxBookingDate": "1970-01-01T00:00:00.000Z",
                        "priceValue": 0,
                        "promotion": "",
                        "sizeText": null,
                        "squareFootage": 0,
                        "unitTypeText": ""
                    }
                ]
            },
            {
                "distance": 10.4,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 141308,
                "inNetwork": true,
                "name": "Nilson Van & Storage",
                "position": 15,
                "rank": 105,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 1,
                "units": [
                    {
                        "id": -141308,
                        "maxBookingDate": "1970-01-01T00:00:00.000Z",
                        "priceValue": 0,
                        "promotion": "",
                        "sizeText": null,
                        "squareFootage": 0,
                        "unitTypeText": ""
                    }
                ]
            }
        ],
        "searchTerm": null,
        "search_id": null,
        "site_id": -1,
        "value": 0
    },
    "receivedAt": "2020-07-28T09:36:27.184Z",
    "sentAt": "2020-07-28T09:36:20.653Z",
    "timestamp": "2020-07-28T09:36:27.179Z",
    "type": "track",
    "userId": "SELENIUM",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.amp.id": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.campaign.term": "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",
    "integrations.campaign.content": "string",
    "integrations.campaign.medium": "string",
    "integrations.campaign.name": "string",
    "integrations.campaign.source": "string",
    "integrations.library.name": "string",
    "integrations.library.version": "string",
    "integrations.page.path": "string",
    "integrations.page.referrer": "string",
    "integrations.page.search": "string",
    "integrations.page.title": "string",
    "integrations.page.url": "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.searchTerm": "string",
    "properties.search_id": "string",
    "properties.site_id": "string",
    "properties.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 131
schema_scan_id: 40311941
updated: 2020-07-28 05:50:40

Version 157519

created: 2020-07-28 05:34:47

ddl:

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

hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed
id: 157519
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2020-07-28T10:07:41Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1595894400000/1595930788494.8481e2c01b9f.baa71ec.29ceae22-d5fd-448c-86f9-1194f9de9ebb.gz|segment_separator:37",
    "anonymousId": "0e62c817-e87c-4de5-bd31-642c2a24b0ec",
    "channel": "client",
    "context": {
        "campaign": {},
        "ip": "172.58.7.84",
        "library": {
            "name": "analytics.js",
            "version": "3.13.5"
        },
        "locale": "en-US",
        "page": {
            "path": "/Fayetteville-GA-self-storage/car-storage.html",
            "referrer": "https://www.google.com/",
            "search": "",
            "title": "",
            "url": "https://www.sparefoot.com/Fayetteville-GA-self-storage/car-storage.html"
        },
        "userAgent": "Mozilla/5.0 (Linux; Android 10; SM-G981U) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.89 Mobile Safari/537.36"
    },
    "event": "Product List Viewed",
    "integrations": {},
    "messageId": "ajs-f4a99e6991c0e68f2dd9101d85a12f19",
    "originalTimestamp": "2020-07-28T09:16:56.710Z",
    "projectId": "a0wkEvFBBK",
    "properties": {
        "Hit Timestamp": 1595927813088,
        "env": "production",
        "isReact": true,
        "list_id": "search results: null",
        "page": 1,
        "productIds": [],
        "products": [],
        "searchTerm": null,
        "search_id": null,
        "site_id": -1,
        "value": 0
    },
    "receivedAt": "2020-07-28T09:16:58.210Z",
    "sentAt": "2020-07-28T09:16:56.721Z",
    "timestamp": "2020-07-28T09:16:58.199Z",
    "type": "track",
    "userId": "98391d4b969f82f7cc8579ab1e5b43b9",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.amp.id": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.campaign.term": "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",
    "integrations.campaign.content": "string",
    "integrations.campaign.medium": "string",
    "integrations.campaign.name": "string",
    "integrations.campaign.source": "string",
    "integrations.library.name": "string",
    "integrations.library.version": "string",
    "integrations.page.path": "string",
    "integrations.page.referrer": "string",
    "integrations.page.search": "string",
    "integrations.page.title": "string",
    "integrations.page.url": "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.searchTerm": "string",
    "properties.search_id": "string",
    "properties.site_id": "string",
    "properties.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 131
schema_scan_id: 40311771
updated: 2020-07-28 05:47:17

Version 157518

created: 2020-07-28 05:30:25

ddl:

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

hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed
id: 157518
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2020-07-28T10:10:11Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1595894400000/1595930804767.80fe6df13684.baa71ec.c8e084d0-e90d-42f7-adcd-15b00170cedd.gz|segment_separator:37",
    "anonymousId": "2403a2f9-c5e7-4602-869d-2544294cf861",
    "channel": "client",
    "context": {
        "campaign": {
            "content": "",
            "medium": "paidsearch",
            "name": "pro_national_nogeo_noproduct_dynamic",
            "source": "google"
        },
        "ip": "73.10.10.27",
        "library": {
            "name": "analytics.js",
            "version": "3.13.5"
        },
        "locale": "en-US",
        "page": {
            "path": "/Hillsborough-Township-NJ-self-storage.html",
            "referrer": "https://www.google.com/",
            "search": "?tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=pro_national_nogeo_noproduct_dynamic&utm_content=&ploc=9004025&iloc=9004025&mkwid=sy1w4wbDa|pcrid|271766729961|pkw||pmt|b|pdv|m|pgrid|48255060418|ptaid|aud-406186939906:dsa-663064472108&pgrid=48255060418&ptaid=aud-406186939906:dsa-663064472108&gclid=CjwKCAjw9vn4BRBaEiwAh0muDPs5l9XE_GVuMQa9bfN8UZethC1VlHfDU9R3O4pw2jYKETmOD_1nyBoC8uAQAvD_BwE",
            "title": "15 Cheap Storage Units Hillsborough Township, NJ (from $19) | Compare & Save",
            "url": "https://www.sparefoot.com/Hillsborough-Township-NJ-self-storage.html?tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=pro_national_nogeo_noproduct_dynamic&utm_content=&ploc=9004025&iloc=9004025&mkwid=sy1w4wbDa|pcrid|271766729961|pkw||pmt|b|pdv|m|pgrid|48255060418|ptaid|aud-406186939906:dsa-663064472108&pgrid=48255060418&ptaid=aud-406186939906:dsa-663064472108&gclid=CjwKCAjw9vn4BRBaEiwAh0muDPs5l9XE_GVuMQa9bfN8UZethC1VlHfDU9R3O4pw2jYKETmOD_1nyBoC8uAQAvD_BwE"
        },
        "userAgent": "Mozilla/5.0 (Linux; Android 9; SM-G950U) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.89 Mobile Safari/537.36"
    },
    "event": "Product List Viewed",
    "integrations": {},
    "messageId": "ajs-df86681ed80da95e0feeb3107f1c3a20",
    "originalTimestamp": "2020-07-28T09:18:34.053Z",
    "projectId": "a0wkEvFBBK",
    "properties": {
        "Hit Timestamp": 1595927912532,
        "category": "Hillsborough Township, NJ-cityLandingPage",
        "env": "production",
        "isReact": true,
        "list_id": "search results: Hillsborough Township, NJ",
        "page": 1,
        "productIds": [
            148227,
            148199,
            148056,
            148060,
            148102,
            148099,
            148107,
            148111,
            148188,
            148105,
            147998,
            148196,
            148042,
            148038,
            148203
        ],
        "products": [
            {
                "distance": 14,
                "hasClosestBadge": false,
                "hasContactlessBadge": true,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 202472,
                "inNetwork": true,
                "name": "Prime Storage - Edison",
                "position": 15,
                "rank": 15,
                "reviewAverage": 4.923,
                "reviewCount": 13,
                "unitCount": 3,
                "units": [
                    {
                        "id": 18623226,
                        "maxBookingDate": "2020-08-10T19:52:44.000Z",
                        "priceValue": 48,
                        "promotion": "First Month FREE",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    }
                ]
            }
        ],
        "searchTerm": "Hillsborough Township, NJ",
        "search_id": "359c5f1f8574ce0512.21193374",
        "site_id": -1,
        "value": 15
    },
    "receivedAt": "2020-07-28T09:18:34.568Z",
    "sentAt": "2020-07-28T09:18:34.080Z",
    "timestamp": "2020-07-28T09:18:34.541Z",
    "type": "track",
    "userId": "5a3d67d2ff6ca12a2c6b9cb1bcb00c2e",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.amp.id": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.campaign.term": "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",
    "integrations.campaign.content": "string",
    "integrations.campaign.medium": "string",
    "integrations.campaign.name": "string",
    "integrations.campaign.source": "string",
    "integrations.library.name": "string",
    "integrations.library.version": "string",
    "integrations.page.path": "string",
    "integrations.page.referrer": "string",
    "integrations.page.search": "string",
    "integrations.page.title": "string",
    "integrations.page.url": "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",
            "hasClosestBadge": "string",
            "hasContactlessBadge": "string",
            "hasRecommendedBadge": "string",
            "hasTopratedBadge": "string",
            "id": "string",
            "inNetwork": "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.searchTerm": "string",
    "properties.search_id": "string",
    "properties.site_id": "string",
    "properties.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 131
schema_scan_id: 40311749
updated: 2020-07-28 05:41:08

Version 157517

created: 2020-07-28 05:29:40

ddl:

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

hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed
id: 157517
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2020-07-28T10:08:04Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1595894400000/1595930788845.5b79ba696bc1.baa71ec.66aacfb2-fabc-43b5-a0c2-6beb4b0db36f.gz|segment_separator:37",
    "anonymousId": "a57f2f49-4ec3-4fdd-add3-1f9f1e91b9e2",
    "channel": "client",
    "context": {
        "campaign": {},
        "ip": "104.156.164.4",
        "library": {
            "name": "analytics.js",
            "version": "3.13.5"
        },
        "locale": "en-US",
        "page": {
            "path": "/search.html",
            "referrer": "https://www.sparefoot.com/search.html?location=Austin%2C%20TX%2C%20USA&latitude=30.267153&longitude=-97.7430608",
            "search": "?location=Austin%2C%20TX%2C%20USA&order=recommended&latitude=30.267153&longitude=-97.7430608",
            "title": "",
            "url": "https://www.sparefoot.com/search.html?location=Austin%2C%20TX%2C%20USA&order=recommended&latitude=30.267153&longitude=-97.7430608"
        },
        "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Firefox/78.0"
    },
    "event": "Product List Viewed",
    "integrations": {},
    "messageId": "ajs-327dda68091fc78d910fd09056a7a4ff",
    "originalTimestamp": "2020-07-28T09:23:45.913Z",
    "projectId": "a0wkEvFBBK",
    "properties": {
        "Hit Timestamp": 1595928225766,
        "env": "production",
        "isReact": true,
        "list_id": "search results: null",
        "page": 1,
        "productIds": [],
        "products": [],
        "searchTerm": null,
        "search_id": null,
        "site_id": -1,
        "value": 0
    },
    "receivedAt": "2020-07-28T09:23:54.581Z",
    "sentAt": "2020-07-28T09:23:45.915Z",
    "timestamp": "2020-07-28T09:23:54.579Z",
    "type": "track",
    "userId": "7799fc36cbd7520e417be60ac4ce4a8d",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.amp.id": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.campaign.term": "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",
    "integrations.campaign.content": "string",
    "integrations.campaign.medium": "string",
    "integrations.campaign.name": "string",
    "integrations.campaign.source": "string",
    "integrations.library.name": "string",
    "integrations.library.version": "string",
    "integrations.page.path": "string",
    "integrations.page.referrer": "string",
    "integrations.page.search": "string",
    "integrations.page.title": "string",
    "integrations.page.url": "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.searchTerm": "string",
    "properties.search_id": "string",
    "properties.site_id": "string",
    "properties.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 131
schema_scan_id: 40311743
updated: 2020-07-28 05:34:10

Version 157516

created: 2020-07-28 05:25:46

ddl:

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

hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed
id: 157516
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2020-07-28T10:09:58Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1595894400000/1595930799713.9fcc2d7c308a.baa71ec.03e86c4d-8c75-4343-ba72-8f80d857d20e.gz|segment_separator:37",
    "anonymousId": "9d8bb449-3a0d-4ab6-b8e5-46f4d079aa17",
    "channel": "client",
    "context": {
        "campaign": {
            "content": "",
            "medium": "paidsearch",
            "name": "pro_national_nogeo_noproduct_dynamic",
            "source": "google"
        },
        "ip": "34.239.223.223",
        "library": {
            "name": "analytics.js",
            "version": "3.13.5"
        },
        "locale": "en-US",
        "page": {
            "path": "/Malden-MA-self-storage.html",
            "referrer": "",
            "search": "",
            "title": "",
            "url": "https://www.sparefoot.com/Malden-MA-self-storage.html"
        },
        "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.89 Safari/537.36"
    },
    "event": "Product List Viewed",
    "integrations": {},
    "messageId": "ajs-a9e2f1352d0a53d0310992c4ad5bdbb3",
    "originalTimestamp": "2020-07-28T09:12:02.430Z",
    "projectId": "a0wkEvFBBK",
    "properties": {
        "Hit Timestamp": 1595927515968,
        "category": "New York, NY-cityLandingPage",
        "env": "production",
        "isReact": true,
        "list_id": "search results: null",
        "page": 1,
        "productIds": [
            202920,
            201364,
            201372,
            201304,
            201365,
            210491,
            216845,
            201361,
            201362,
            201368,
            201366,
            104547,
            201373,
            110406,
            201367
        ],
        "products": [
            {
                "distance": 3.9,
                "hasClosestBadge": false,
                "hasContactlessBadge": true,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 202920,
                "inNetwork": true,
                "name": "CubeSmart Self Storage - New York - 444 West 55th Street",
                "position": 1,
                "rank": 1,
                "reviewAverage": 4.889,
                "reviewCount": 18,
                "unitCount": 1,
                "units": [
                    {
                        "id": 23576274,
                        "maxBookingDate": "2020-08-12T01:56:36.000Z",
                        "priceValue": 134.55,
                        "promotion": "35% Off & Free Move-In Truck & Driver!",
                        "sizeText": "4' x 6'",
                        "squareFootage": 24,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 0.9,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 201364,
                "inNetwork": true,
                "name": "Manhattan Mini Storage - SoHo - Spring Street",
                "position": 2,
                "rank": 2,
                "reviewAverage": 5,
                "reviewCount": 1,
                "unitCount": 1,
                "units": [
                    {
                        "id": 18309704,
                        "maxBookingDate": "2020-08-27T01:57:17.000Z",
                        "priceValue": 200,
                        "promotion": "Free use of movers when you reserve online",
                        "sizeText": "4' x 5'",
                        "squareFootage": 20,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 0.9,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 201372,
                "inNetwork": true,
                "name": "Manhattan Mini Storage - Hudson Square - Varick Street",
                "position": 3,
                "rank": 3,
                "reviewAverage": 4.5,
                "reviewCount": 2,
                "unitCount": 1,
                "units": [
                    {
                        "id": 18309783,
                        "maxBookingDate": "2020-08-27T01:57:15.000Z",
                        "priceValue": 140,
                        "promotion": "Free use of movers when you reserve online",
                        "sizeText": "4' x 4'",
                        "squareFootage": 16,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 0.6,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 201304,
                "inNetwork": true,
                "name": "Manhattan Mini Storage - Lower East Side - South Street",
                "position": 4,
                "rank": 4,
                "reviewAverage": 4.333,
                "reviewCount": 9,
                "unitCount": 1,
                "units": [
                    {
                        "id": 18309628,
                        "maxBookingDate": "2020-08-27T01:57:17.000Z",
                        "priceValue": 36,
                        "promotion": "Free use of movers when you reserve online",
                        "sizeText": "4' x 4'",
                        "squareFootage": 16,
                        "unitTypeText": "locker"
                    }
                ]
            },
            {
                "distance": 1.1,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 201365,
                "inNetwork": true,
                "name": "Manhattan Mini Storage - East Village - Second Avenue",
                "position": 5,
                "rank": 5,
                "reviewAverage": 4.5,
                "reviewCount": 2,
                "unitCount": 1,
                "units": [
                    {
                        "id": 18309732,
                        "maxBookingDate": "2020-08-27T01:57:17.000Z",
                        "priceValue": 110,
                        "promotion": "Free use of movers when you reserve online",
                        "sizeText": "4' x 4'",
                        "squareFootage": 16,
                        "unitTypeText": "locker"
                    }
                ]
            },
            {
                "distance": 2.9,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 210491,
                "inNetwork": true,
                "name": "The Arts Building Storage",
                "position": 6,
                "rank": 6,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 2,
                "units": [
                    {
                        "id": 21616056,
                        "maxBookingDate": "2020-09-26T02:14:49.000Z",
                        "priceValue": 150,
                        "promotion": "Free lock when you reserve online",
                        "sizeText": "4' x 4'",
                        "squareFootage": 16,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 20806868,
                        "maxBookingDate": "2020-09-26T02:14:49.000Z",
                        "priceValue": 250,
                        "promotion": "Free lock when you reserve online",
                        "sizeText": "7' x 4'",
                        "squareFootage": 28,
                        "unitTypeText": "locker"
                    }
                ]
            },
            {
                "distance": 7.2,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 216845,
                "inNetwork": true,
                "name": "GoodFriend Self-Storage - East Harlem",
                "position": 7,
                "rank": 7,
                "reviewAverage": 5,
                "reviewCount": 2,
                "unitCount": 3,
                "units": [
                    {
                        "id": 23057916,
                        "maxBookingDate": "2020-09-26T02:09:54.000Z",
                        "priceValue": 39,
                        "promotion": "2 Months 1/2 Off",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "locker"
                    },
                    {
                        "id": 23057445,
                        "maxBookingDate": "2020-09-26T02:09:54.000Z",
                        "priceValue": 289,
                        "promotion": "2 Months 1/2 Off",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 23057534,
                        "maxBookingDate": "2020-09-26T02:09:54.000Z",
                        "priceValue": 399,
                        "promotion": "2 Months 1/2 Off",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 2.4,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 201361,
                "inNetwork": true,
                "name": "Manhattan Mini Storage - Chelsea - West 23rd Street",
                "position": 8,
                "rank": 8,
                "reviewAverage": 4.4,
                "reviewCount": 10,
                "unitCount": 1,
                "units": [
                    {
                        "id": 18309621,
                        "maxBookingDate": "2020-08-27T01:57:17.000Z",
                        "priceValue": 54,
                        "promotion": "Free use of movers when you reserve online",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "locker"
                    }
                ]
            },
            {
                "distance": 2.4,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 201362,
                "inNetwork": true,
                "name": "Manhattan Mini Storage - Chelsea Piers - 531 West 21st Street",
                "position": 9,
                "rank": 9,
                "reviewAverage": 4.714,
                "reviewCount": 7,
                "unitCount": 1,
                "units": [
                    {
                        "id": 18309641,
                        "maxBookingDate": "2020-08-27T01:57:17.000Z",
                        "priceValue": 36,
                        "promotion": "Free use of movers when you reserve online",
                        "sizeText": "4' x 4'",
                        "squareFootage": 16,
                        "unitTypeText": "locker"
                    }
                ]
            },
            {
                "distance": 3.5,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 201368,
                "inNetwork": true,
                "name": "Manhattan Mini Storage - West Side Highway - West 44th Street",
                "position": 10,
                "rank": 10,
                "reviewAverage": 5,
                "reviewCount": 2,
                "unitCount": 1,
                "units": [
                    {
                        "id": 18309750,
                        "maxBookingDate": "2020-08-27T01:57:17.000Z",
                        "priceValue": 174,
                        "promotion": "Free use of movers when you reserve online",
                        "sizeText": "4' x 6'",
                        "squareFootage": 24,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 3.4,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 201366,
                "inNetwork": true,
                "name": "Manhattan Mini Storage - Hell's Kitchen - West 43rd Street",
                "position": 11,
                "rank": 11,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 1,
                "units": [
                    {
                        "id": 18309724,
                        "maxBookingDate": "2020-08-27T01:57:17.000Z",
                        "priceValue": 39,
                        "promotion": "Free use of movers when you reserve online",
                        "sizeText": "4' x 4'",
                        "squareFootage": 16,
                        "unitTypeText": "locker"
                    }
                ]
            },
            {
                "distance": 10.6,
                "hasClosestBadge": false,
                "hasContactlessBadge": true,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 104547,
                "inNetwork": true,
                "name": "CubeSmart Self Storage - New York - 1810 Southern Blvd",
                "position": 12,
                "rank": 12,
                "reviewAverage": 4.5,
                "reviewCount": 2,
                "unitCount": 2,
                "units": [
                    {
                        "id": 23556987,
                        "maxBookingDate": "2020-08-05T02:00:49.000Z",
                        "priceValue": 34.45,
                        "promotion": "35% Off & Free Move-In Truck & Driver!",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "locker"
                    },
                    {
                        "id": 23571021,
                        "maxBookingDate": "2020-08-05T02:00:49.000Z",
                        "priceValue": 126.1,
                        "promotion": "35% Off & Free Move-In Truck & Driver!",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 7.8,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 201373,
                "inNetwork": true,
                "name": "Manhattan Mini Storage - Upper Manhattan - Riverside",
                "position": 13,
                "rank": 13,
                "reviewAverage": 4.25,
                "reviewCount": 2,
                "unitCount": 1,
                "units": [
                    {
                        "id": 18309796,
                        "maxBookingDate": "2020-08-27T01:57:15.000Z",
                        "priceValue": 544,
                        "promotion": "Free use of movers when you reserve online",
                        "sizeText": "10' x 10'",
                        "squareFootage": 100,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 8.1,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 110406,
                "inNetwork": true,
                "name": "Harlem Self-Storage LLC",
                "position": 14,
                "rank": 14,
                "reviewAverage": 4.5,
                "reviewCount": 11,
                "unitCount": 3,
                "units": [
                    {
                        "id": 10409108,
                        "maxBookingDate": "2020-08-27T01:59:36.000Z",
                        "priceValue": 39,
                        "promotion": "",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "locker"
                    },
                    {
                        "id": 10409123,
                        "maxBookingDate": "2020-08-27T01:59:36.000Z",
                        "priceValue": 159,
                        "promotion": "",
                        "sizeText": "5' x 10'",
                        "squareFootage": 50,
                        "unitTypeText": "unit"
                    },
                    {
                        "id": 10409128,
                        "maxBookingDate": "2020-08-27T01:59:36.000Z",
                        "priceValue": 199,
                        "promotion": "",
                        "sizeText": "8' x 10'",
                        "squareFootage": 80,
                        "unitTypeText": "unit"
                    }
                ]
            },
            {
                "distance": 11.7,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 201367,
                "inNetwork": true,
                "name": "Manhattan Mini Storage - Inwood",
                "position": 15,
                "rank": 15,
                "reviewAverage": 5,
                "reviewCount": 1,
                "unitCount": 1,
                "units": [
                    {
                        "id": 18309741,
                        "maxBookingDate": "2020-08-27T01:57:17.000Z",
                        "priceValue": 200,
                        "promotion": "Free use of movers when you reserve online",
                        "sizeText": "4' x 6'",
                        "squareFootage": 24,
                        "unitTypeText": "unit"
                    }
                ]
            }
        ],
        "searchTerm": null,
        "search_id": null,
        "site_id": -1,
        "value": 0
    },
    "receivedAt": "2020-07-28T09:12:07.375Z",
    "sentAt": "2020-07-28T09:12:02.433Z",
    "timestamp": "2020-07-28T09:12:07.372Z",
    "type": "track",
    "userId": "33cad19b2eec7f8ed3e5a10518712cd7",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.amp.id": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.campaign.term": "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",
    "integrations.campaign.content": "string",
    "integrations.campaign.medium": "string",
    "integrations.campaign.name": "string",
    "integrations.campaign.source": "string",
    "integrations.library.name": "string",
    "integrations.library.version": "string",
    "integrations.page.path": "string",
    "integrations.page.referrer": "string",
    "integrations.page.search": "string",
    "integrations.page.title": "string",
    "integrations.page.url": "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.searchTerm": "string",
    "properties.search_id": "string",
    "properties.site_id": "string",
    "properties.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 131
schema_scan_id: 40311741
updated: 2020-07-28 05:30:09

Version 157515

created: 2020-07-28 05:20:39

ddl:

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

hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed
id: 157515
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2020-07-28T10:06:54Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1595894400000/1595930787482.683ee04372fa.baa71ec.e9add5af-1471-432d-b2e1-6ed919b5270a.gz|segment_separator:37",
    "anonymousId": "861475f8-2591-413e-a864-4f609b551ec2",
    "channel": "client",
    "context": {
        "campaign": {},
        "ip": "204.236.203.124",
        "library": {
            "name": "analytics.js",
            "version": "3.13.5"
        },
        "locale": "en-US",
        "page": {
            "path": "/Perryville-AK-self-storage",
            "referrer": "",
            "search": "?SELENIUM=true",
            "title": "",
            "url": "https://www.sparefoot.com/Perryville-AK-self-storage?SELENIUM=true"
        },
        "userAgent": "Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.89 Safari/537.36"
    },
    "event": "Product List Viewed",
    "integrations": {},
    "messageId": "ajs-da939a3b26604fd16d7ed937c6c20fa8",
    "originalTimestamp": "2020-07-28T09:52:00.460Z",
    "projectId": "a0wkEvFBBK",
    "properties": {
        "Hit Timestamp": 1595929920206,
        "env": "production",
        "isReact": true,
        "list_id": "search results: null",
        "page": 1,
        "productIds": [],
        "products": [],
        "searchTerm": null,
        "search_id": null,
        "site_id": -1,
        "value": 0
    },
    "receivedAt": "2020-07-28T09:52:08.687Z",
    "sentAt": "2020-07-28T09:52:00.465Z",
    "timestamp": "2020-07-28T09:52:08.682Z",
    "type": "track",
    "userId": "SELENIUM",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.amp.id": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.campaign.term": "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",
    "integrations.campaign.content": "string",
    "integrations.campaign.medium": "string",
    "integrations.campaign.name": "string",
    "integrations.campaign.source": "string",
    "integrations.library.name": "string",
    "integrations.library.version": "string",
    "integrations.page.path": "string",
    "integrations.page.referrer": "string",
    "integrations.page.search": "string",
    "integrations.page.title": "string",
    "integrations.page.url": "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.searchTerm": "string",
    "properties.search_id": "string",
    "properties.site_id": "string",
    "properties.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 131
schema_scan_id: 40311670
updated: 2020-07-28 05:29:29

Version 157514

created: 2020-07-28 05:11:42

ddl:

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

hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed
id: 157514
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2020-07-28T10:07:10Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1595894400000/1595930794039.046a4f835cfb.baa71ec.1615e0f9-cc12-4cc5-b9d8-3f3f10492607.gz|segment_separator:37",
    "anonymousId": "eecdeb81-2afe-4626-9927-775d07cad63a",
    "channel": "client",
    "context": {
        "campaign": {},
        "ip": "68.185.201.42",
        "library": {
            "name": "analytics.js",
            "version": "3.13.5"
        },
        "locale": "en-US",
        "page": {
            "path": "/search.html",
            "referrer": "https://www.sparefoot.com/Denton-TX-self-storage.html",
            "search": "?location=76209&order=recommended",
            "title": "",
            "url": "https://www.sparefoot.com/search.html?location=76209&order=recommended"
        },
        "userAgent": "Mozilla/5.0 (Linux; Android 9; LM-X420) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.89 Mobile Safari/537.36"
    },
    "event": "Product List Viewed",
    "integrations": {},
    "messageId": "ajs-5a778c49770acd2a660b1f4365ca3db9",
    "originalTimestamp": "2020-07-28T09:09:58.331Z",
    "projectId": "a0wkEvFBBK",
    "properties": {
        "Hit Timestamp": 1595927397671,
        "category": "Essex Junction, VT 05452-searchPage",
        "env": "production",
        "isReact": true,
        "list_id": "search results: null",
        "page": 1,
        "productIds": [
            148227,
            148199,
            148056,
            148060,
            148102,
            148099,
            148107,
            148111,
            148188,
            148105,
            147998,
            148196,
            148042,
            148038,
            148203
        ],
        "products": [
            {
                "distance": 29.6,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 148227,
                "inNetwork": true,
                "name": "Robin Hood Storage",
                "position": 1,
                "rank": 1,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 1,
                "units": [
                    {
                        "id": -148227,
                        "maxBookingDate": "1970-01-01T00:00:00.000Z",
                        "priceValue": 0,
                        "promotion": "",
                        "sizeText": null,
                        "squareFootage": 0,
                        "unitTypeText": ""
                    }
                ]
            },
            {
                "distance": 6.8,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 148199,
                "inNetwork": true,
                "name": "Burlington Self Storage",
                "position": 2,
                "rank": 2,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 1,
                "units": [
                    {
                        "id": -148199,
                        "maxBookingDate": "1970-01-01T00:00:00.000Z",
                        "priceValue": 0,
                        "promotion": "",
                        "sizeText": null,
                        "squareFootage": 0,
                        "unitTypeText": ""
                    }
                ]
            },
            {
                "distance": 10.9,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 148056,
                "inNetwork": true,
                "name": "Lyman Storage",
                "position": 3,
                "rank": 3,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 1,
                "units": [
                    {
                        "id": -148056,
                        "maxBookingDate": "1970-01-01T00:00:00.000Z",
                        "priceValue": 0,
                        "promotion": "",
                        "sizeText": null,
                        "squareFootage": 0,
                        "unitTypeText": ""
                    }
                ]
            },
            {
                "distance": 10.7,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 148060,
                "inNetwork": true,
                "name": "Storage Solutions",
                "position": 4,
                "rank": 4,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 1,
                "units": [
                    {
                        "id": -148060,
                        "maxBookingDate": "1970-01-01T00:00:00.000Z",
                        "priceValue": 0,
                        "promotion": "",
                        "sizeText": null,
                        "squareFootage": 0,
                        "unitTypeText": ""
                    }
                ]
            },
            {
                "distance": 10.4,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 148102,
                "inNetwork": true,
                "name": "Milton Mini Storage",
                "position": 5,
                "rank": 5,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 1,
                "units": [
                    {
                        "id": -148102,
                        "maxBookingDate": "1970-01-01T00:00:00.000Z",
                        "priceValue": 0,
                        "promotion": "",
                        "sizeText": null,
                        "squareFootage": 0,
                        "unitTypeText": ""
                    }
                ]
            },
            {
                "distance": 9.4,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 148099,
                "inNetwork": true,
                "name": "Ace Storage",
                "position": 6,
                "rank": 6,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 1,
                "units": [
                    {
                        "id": -148099,
                        "maxBookingDate": "1970-01-01T00:00:00.000Z",
                        "priceValue": 0,
                        "promotion": "",
                        "sizeText": null,
                        "squareFootage": 0,
                        "unitTypeText": ""
                    }
                ]
            },
            {
                "distance": 9.2,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 148107,
                "inNetwork": true,
                "name": "Catamount Storage",
                "position": 7,
                "rank": 7,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 1,
                "units": [
                    {
                        "id": -148107,
                        "maxBookingDate": "1970-01-01T00:00:00.000Z",
                        "priceValue": 0,
                        "promotion": "",
                        "sizeText": null,
                        "squareFootage": 0,
                        "unitTypeText": ""
                    }
                ]
            },
            {
                "distance": 9,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 148111,
                "inNetwork": true,
                "name": "Class Centre Mini Storage Inc",
                "position": 8,
                "rank": 8,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 1,
                "units": [
                    {
                        "id": -148111,
                        "maxBookingDate": "1970-01-01T00:00:00.000Z",
                        "priceValue": 0,
                        "promotion": "",
                        "sizeText": null,
                        "squareFootage": 0,
                        "unitTypeText": ""
                    }
                ]
            },
            {
                "distance": 8.3,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 148188,
                "inNetwork": true,
                "name": "Shelburne Village Self Storage",
                "position": 9,
                "rank": 9,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 1,
                "units": [
                    {
                        "id": -148188,
                        "maxBookingDate": "1970-01-01T00:00:00.000Z",
                        "priceValue": 0,
                        "promotion": "",
                        "sizeText": null,
                        "squareFootage": 0,
                        "unitTypeText": ""
                    }
                ]
            },
            {
                "distance": 8.2,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 148105,
                "inNetwork": true,
                "name": "Green State Storage",
                "position": 10,
                "rank": 10,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 1,
                "units": [
                    {
                        "id": -148105,
                        "maxBookingDate": "1970-01-01T00:00:00.000Z",
                        "priceValue": 0,
                        "promotion": "",
                        "sizeText": null,
                        "squareFootage": 0,
                        "unitTypeText": ""
                    }
                ]
            },
            {
                "distance": 8.1,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 147998,
                "inNetwork": true,
                "name": "Action Moving & Storage Inc",
                "position": 11,
                "rank": 11,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 1,
                "units": [
                    {
                        "id": -147998,
                        "maxBookingDate": "1970-01-01T00:00:00.000Z",
                        "priceValue": 0,
                        "promotion": "",
                        "sizeText": null,
                        "squareFootage": 0,
                        "unitTypeText": ""
                    }
                ]
            },
            {
                "distance": 5.6,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 148196,
                "inNetwork": true,
                "name": "Easy Self Storage Llc",
                "position": 12,
                "rank": 12,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 1,
                "units": [
                    {
                        "id": -148196,
                        "maxBookingDate": "1970-01-01T00:00:00.000Z",
                        "priceValue": 0,
                        "promotion": "",
                        "sizeText": null,
                        "squareFootage": 0,
                        "unitTypeText": ""
                    }
                ]
            },
            {
                "distance": 17.3,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 148042,
                "inNetwork": true,
                "name": "Beaver Valley Storage",
                "position": 13,
                "rank": 13,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 1,
                "units": [
                    {
                        "id": -148042,
                        "maxBookingDate": "1970-01-01T00:00:00.000Z",
                        "priceValue": 0,
                        "promotion": "",
                        "sizeText": null,
                        "squareFootage": 0,
                        "unitTypeText": ""
                    }
                ]
            },
            {
                "distance": 4.1,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 148038,
                "inNetwork": true,
                "name": "Leo's Self Storage",
                "position": 14,
                "rank": 14,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 1,
                "units": [
                    {
                        "id": -148038,
                        "maxBookingDate": "1970-01-01T00:00:00.000Z",
                        "priceValue": 0,
                        "promotion": "",
                        "sizeText": null,
                        "squareFootage": 0,
                        "unitTypeText": ""
                    }
                ]
            },
            {
                "distance": 3.3,
                "hasClosestBadge": false,
                "hasContactlessBadge": false,
                "hasRecommendedBadge": false,
                "hasTopratedBadge": false,
                "id": 148203,
                "inNetwork": true,
                "name": "Climate Care Self Storage",
                "position": 15,
                "rank": 15,
                "reviewAverage": 0,
                "reviewCount": 0,
                "unitCount": 1,
                "units": [
                    {
                        "id": -148203,
                        "maxBookingDate": "1970-01-01T00:00:00.000Z",
                        "priceValue": 0,
                        "promotion": "",
                        "sizeText": null,
                        "squareFootage": 0,
                        "unitTypeText": ""
                    }
                ]
            }
        ],
        "searchTerm": null,
        "search_id": null,
        "site_id": -1,
        "value": 0
    },
    "receivedAt": "2020-07-28T09:10:11.677Z",
    "sentAt": "2020-07-28T09:10:10.362Z",
    "timestamp": "2020-07-28T09:09:59.646Z",
    "type": "track",
    "userId": "d67228a661e8ce6b757d65e39494745e",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.amp.id": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.campaign.term": "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",
    "integrations.campaign.content": "string",
    "integrations.campaign.medium": "string",
    "integrations.campaign.name": "string",
    "integrations.campaign.source": "string",
    "integrations.library.name": "string",
    "integrations.library.version": "string",
    "integrations.page.path": "string",
    "integrations.page.referrer": "string",
    "integrations.page.search": "string",
    "integrations.page.title": "string",
    "integrations.page.url": "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.searchTerm": "string",
    "properties.search_id": "string",
    "properties.site_id": "string",
    "properties.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 131
schema_scan_id: 40311626
updated: 2020-07-28 05:22:48

Version 157513

created: 2020-07-28 05:06:48

ddl:

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

hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed
id: 157513
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2020-07-28T10:06:30Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1595894400000/1595930786469.5f9bff2d577e.baa71ec.4ce018fe-80ff-44c3-9086-5c683fc55caf.gz|segment_separator:37",
    "anonymousId": "fa564553-dcae-4038-a66a-6775fab911fb",
    "channel": "client",
    "context": {
        "campaign": {},
        "ip": "107.77.216.188",
        "library": {
            "name": "analytics.js",
            "version": "3.13.5"
        },
        "locale": "en-US",
        "page": {
            "path": "/search.html",
            "referrer": "https://www.sparefoot.com/search.html?location=33612",
            "search": "?location=Tampa%2C%20FL%2033612%2C%20USA&order=recommended&latitude=28.0563834&longitude=-82.4427769&zip=33612",
            "title": "",
            "url": "https://www.sparefoot.com/search.html?location=Tampa%2C%20FL%2033612%2C%20USA&order=recommended&latitude=28.0563834&longitude=-82.4427769&zip=33612"
        },
        "userAgent": "Mozilla/5.0 (Linux; Android 9; SAMSUNG SM-G950U) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/10.2 Chrome/71.0.3578.99 Mobile Safari/537.36"
    },
    "event": "Product List Viewed",
    "integrations": {},
    "messageId": "ajs-efceafb834c8e34f9e5fddbd3453c92c",
    "originalTimestamp": "2020-07-28T09:08:06.616Z",
    "projectId": "a0wkEvFBBK",
    "properties": {
        "Hit Timestamp": 1595927284980,
        "env": "production",
        "isReact": true,
        "list_id": "search results: null",
        "page": 1,
        "productIds": [],
        "products": [],
        "searchTerm": null,
        "search_id": null,
        "site_id": -1,
        "value": 0
    },
    "receivedAt": "2020-07-28T09:08:10.268Z",
    "sentAt": "2020-07-28T09:08:06.652Z",
    "timestamp": "2020-07-28T09:08:10.232Z",
    "type": "track",
    "userId": "4f75ab190ff2e1a42a4ace5846a0437a",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.amp.id": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.campaign.term": "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",
    "integrations.campaign.content": "string",
    "integrations.campaign.medium": "string",
    "integrations.campaign.name": "string",
    "integrations.campaign.source": "string",
    "integrations.library.name": "string",
    "integrations.library.version": "string",
    "integrations.page.path": "string",
    "integrations.page.referrer": "string",
    "integrations.page.search": "string",
    "integrations.page.title": "string",
    "integrations.page.url": "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.searchTerm": "string",
    "properties.search_id": "string",
    "properties.site_id": "string",
    "properties.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 131
schema_scan_id: 40311605
updated: 2020-07-28 05:18:26

Version 150735

created: 2020-06-21 19:17:20

ddl:

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

hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed
id: 150735
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2020-06-22T00:17:10Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1592697600000/1592784496097.45403eac059f.baa71ec.915a17d1-2940-4148-8c35-ebaf2b4bfc3a.gz|segment_separator:37",
    "anonymousId": "f2a03118-1e65-479e-862c-6625246be678",
    "channel": "client",
    "context": {
        "campaign": {},
        "ip": "67.168.58.19",
        "library": {
            "name": "analytics.js",
            "version": "3.13.5"
        },
        "locale": "en",
        "page": {
            "path": "/Seattle-WA-self-storage.html",
            "referrer": "https://www.google.com",
            "search": "",
            "title": "15 Cheap Storage Units Seattle, WA + Contact-Free Move-Ins",
            "url": "https://www.sparefoot.com/Seattle-WA-self-storage.html"
        },
        "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.1.1 Safari/605.1.15"
    },
    "event": "Product List Viewed",
    "integrations": {},
    "messageId": "ajs-c24dc793a9854e3388ffaf4a0c560b13",
    "originalTimestamp": "2020-06-21T23:09:26.224Z",
    "projectId": "a0wkEvFBBK",
    "properties": {
        "Hit Timestamp": 1592780965938,
        "category": "Seattle, WA-cityLandingPage",
        "env": "production",
        "isReact": true,
        "list_id": "search results: Seattle, WA",
        "page": 1,
        "productIds": [
            209007,
            203729,
            63404,
            211490,
            214044,
            214081,
            63403,
            158901,
            213914,
            213915,
            214127,
            214919,
            215659,
            214051,
            215643
        ],
        "products": [
            {
                "distance": 13.8,
                "hasContactlessMoveIns": true,
                "id": 211455,
                "inNetwork": true,
                "name": "Narrows Self Storage - Bremerton",
                "position": 11,
                "rank": 11,
                "reviewAverage": 4.5,
                "reviewCount": 2,
                "unitCount": 3,
                "units": [
                    {
                        "id": 21329383,
                        "maxBookingDate": "2020-06-24T14:05:15.000Z",
                        "priceValue": 65,
                        "promotion": "",
                        "sizeText": "5' x 5'",
                        "squareFootage": 25,
                        "unitTypeText": "unit"
                    }
                ]
            }
        ],
        "searchTerm": "Seattle, WA",
        "search_id": "210b5eefe8a4d37b16.55321240",
        "site_id": -1,
        "value": 15
    },
    "receivedAt": "2020-06-21T23:09:26.619Z",
    "sentAt": "2020-06-21T23:09:26.229Z",
    "timestamp": "2020-06-21T23:09:26.614Z",
    "type": "track",
    "userId": "50c1e7214c3b10b8d420976d2f1cbed2",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.amp.id": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.campaign.term": "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",
    "integrations.campaign.content": "string",
    "integrations.campaign.medium": "string",
    "integrations.campaign.name": "string",
    "integrations.campaign.source": "string",
    "integrations.library.name": "string",
    "integrations.library.version": "string",
    "integrations.page.path": "string",
    "integrations.page.referrer": "string",
    "integrations.page.search": "string",
    "integrations.page.title": "string",
    "integrations.page.url": "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",
            "hasContactlessMoveIns": "string",
            "id": "string",
            "inNetwork": "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.searchTerm": "string",
    "properties.search_id": "string",
    "properties.site_id": "string",
    "properties.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 131
schema_scan_id: 39069967
updated: 2020-06-21 19:30:55

Schema Scans: 15

Last at 2020-07-28 06:12:42

Scan 40312275

duration: 0:04:40.178957

exit_message:

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

id: 40312275

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2020-07-28/",
        "name": "dt",
        "type": "string",
        "value": "2020-07-28"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-prod",
        "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed",
        "key": "separated_dt/Product List Viewed/dt=2020-07-28/1595933217338.7a853f86712f.baa71ec.ca845833-c5fa-4c3d-8817-df78f9b06680.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.reactfoot_Product_List_Viewed",
        "type": "segment"
    }
}

running: False
schema_name_id: 131
start_time: 2020-07-28 06:12:42
success: True
trace_id: 17296483544806478141

Scan 40312209

duration: 0:04:44.325437

exit_message:

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

id: 40312209

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2020-07-28/",
        "name": "dt",
        "type": "string",
        "value": "2020-07-28"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-prod",
        "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed",
        "key": "separated_dt/Product List Viewed/dt=2020-07-28/1595930807750.7c46c64530d3.baa71ec.7c12e660-b184-4ebe-b1e0-55653ac50af1.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.reactfoot_Product_List_Viewed",
        "type": "segment"
    }
}

running: False
schema_name_id: 131
start_time: 2020-07-28 06:08:39
success: True
trace_id: 2861129124637216110

Scan 40312157

duration: 0:04:42.549573

exit_message:

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

id: 40312157

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2020-07-28/",
        "name": "dt",
        "type": "string",
        "value": "2020-07-28"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-prod",
        "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed",
        "key": "separated_dt/Product List Viewed/dt=2020-07-28/1595934393595.046a4f835cfb.baa71ec.4addbf74-cacb-4204-a98d-4dc324c21233.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.reactfoot_Product_List_Viewed",
        "type": "segment"
    }
}

running: False
schema_name_id: 131
start_time: 2020-07-28 06:07:16
success: True
trace_id: 5659294587851293715

Scan 40312004

duration: 0:10:53.082703

exit_message:

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

id: 40312004

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2020-07-28/",
        "name": "dt",
        "type": "string",
        "value": "2020-07-28"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-prod",
        "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed",
        "key": "separated_dt/Product List Viewed/dt=2020-07-28/1595930809882.9112e2721a43.baa71ec.1139c474-369c-420b-8d0e-0b27ea84fcc0.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.reactfoot_Product_List_Viewed",
        "type": "segment"
    }
}

running: False
schema_name_id: 131
start_time: 2020-07-28 05:55:52
success: True
trace_id: 4940217373426931611

Scan 40311996

duration: 0:04:31.579716

exit_message:

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

id: 40311996

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2020-07-28/",
        "name": "dt",
        "type": "string",
        "value": "2020-07-28"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-prod",
        "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed",
        "key": "separated_dt/Product List Viewed/dt=2020-07-28/1595930810395.7349d09321c9.baa71ec.d00d7303-32c5-4de6-92a6-dcda9a94ba89.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.reactfoot_Product_List_Viewed",
        "type": "segment"
    }
}

running: False
schema_name_id: 131
start_time: 2020-07-28 05:55:01
success: True
trace_id: 3763571824448987511

Scan 40311951

duration: 0:04:35.973905

exit_message:

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

id: 40311951

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2020-07-28/",
        "name": "dt",
        "type": "string",
        "value": "2020-07-28"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-prod",
        "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed",
        "key": "separated_dt/Product List Viewed/dt=2020-07-28/1595930805316.0f2d259f130f.baa71ec.54e48846-f696-43a0-ab4f-c91e651c707a.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.reactfoot_Product_List_Viewed",
        "type": "segment"
    }
}

running: False
schema_name_id: 131
start_time: 2020-07-28 05:47:35
success: True
trace_id: 10590817143047003329

Scan 40311941

duration: 0:04:36.836236

exit_message:

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

id: 40311941

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2020-07-28/",
        "name": "dt",
        "type": "string",
        "value": "2020-07-28"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-prod",
        "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed",
        "key": "separated_dt/Product List Viewed/dt=2020-07-28/1595930791753.f5060610ee0f.baa71ec.685c51b1-3ae3-48c9-b38b-9171c0a95aab.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.reactfoot_Product_List_Viewed",
        "type": "segment"
    }
}

running: False
schema_name_id: 131
start_time: 2020-07-28 05:46:13
success: True
trace_id: 15340651277735691877

Scan 40311771

duration: 0:10:41.208644

exit_message:

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

id: 40311771

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2020-07-28/",
        "name": "dt",
        "type": "string",
        "value": "2020-07-28"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-prod",
        "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed",
        "key": "separated_dt/Product List Viewed/dt=2020-07-28/1595930788494.8481e2c01b9f.baa71ec.29ceae22-d5fd-448c-86f9-1194f9de9ebb.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.reactfoot_Product_List_Viewed",
        "type": "segment"
    }
}

running: False
schema_name_id: 131
start_time: 2020-07-28 05:34:47
success: True
trace_id: 15053740441289929548

Scan 40311749

duration: 0:10:51.594123

exit_message:

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

id: 40311749

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2020-07-28/",
        "name": "dt",
        "type": "string",
        "value": "2020-07-28"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-prod",
        "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed",
        "key": "separated_dt/Product List Viewed/dt=2020-07-28/1595930804767.80fe6df13684.baa71ec.c8e084d0-e90d-42f7-adcd-15b00170cedd.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.reactfoot_Product_List_Viewed",
        "type": "segment"
    }
}

running: False
schema_name_id: 131
start_time: 2020-07-28 05:30:25
success: True
trace_id: 14131556904996676654

Scan 40311743

duration: 0:04:39.823326

exit_message:

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

id: 40311743

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2020-07-28/",
        "name": "dt",
        "type": "string",
        "value": "2020-07-28"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-prod",
        "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed",
        "key": "separated_dt/Product List Viewed/dt=2020-07-28/1595930788845.5b79ba696bc1.baa71ec.66aacfb2-fabc-43b5-a0c2-6beb4b0db36f.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.reactfoot_Product_List_Viewed",
        "type": "segment"
    }
}

running: False
schema_name_id: 131
start_time: 2020-07-28 05:29:40
success: True
trace_id: 16781357048221381859

Scan 40311741

duration: 0:04:33.308503

exit_message:

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

id: 40311741

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2020-07-28/",
        "name": "dt",
        "type": "string",
        "value": "2020-07-28"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-prod",
        "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed",
        "key": "separated_dt/Product List Viewed/dt=2020-07-28/1595930799713.9fcc2d7c308a.baa71ec.03e86c4d-8c75-4343-ba72-8f80d857d20e.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.reactfoot_Product_List_Viewed",
        "type": "segment"
    }
}

running: False
schema_name_id: 131
start_time: 2020-07-28 05:25:45
success: True
trace_id: 10061791186499202245

Scan 40311670

duration: 0:04:39.222880

exit_message:

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

id: 40311670

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2020-07-28/",
        "name": "dt",
        "type": "string",
        "value": "2020-07-28"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-prod",
        "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed",
        "key": "separated_dt/Product List Viewed/dt=2020-07-28/1595930787482.683ee04372fa.baa71ec.e9add5af-1471-432d-b2e1-6ed919b5270a.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.reactfoot_Product_List_Viewed",
        "type": "segment"
    }
}

running: False
schema_name_id: 131
start_time: 2020-07-28 05:20:39
success: True
trace_id: 6595264069715040596

Scan 40311626

duration: 0:11:09.440709

exit_message:

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

id: 40311626

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2020-07-28/",
        "name": "dt",
        "type": "string",
        "value": "2020-07-28"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-prod",
        "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed",
        "key": "separated_dt/Product List Viewed/dt=2020-07-28/1595930794039.046a4f835cfb.baa71ec.1615e0f9-cc12-4cc5-b9d8-3f3f10492607.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.reactfoot_Product_List_Viewed",
        "type": "segment"
    }
}

running: False
schema_name_id: 131
start_time: 2020-07-28 05:11:42
success: True
trace_id: 6697369735895383464

Scan 40311605

duration: 0:04:49.138512

exit_message:

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

id: 40311605

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2020-07-28/",
        "name": "dt",
        "type": "string",
        "value": "2020-07-28"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-prod",
        "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed",
        "key": "separated_dt/Product List Viewed/dt=2020-07-28/1595930786469.5f9bff2d577e.baa71ec.4ce018fe-80ff-44c3-9086-5c683fc55caf.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.reactfoot_Product_List_Viewed",
        "type": "segment"
    }
}

running: False
schema_name_id: 131
start_time: 2020-07-28 05:06:48
success: True
trace_id: 4645163573056375570

Scan 39069967

duration: 0:04:39.190077

exit_message:

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

id: 39069967

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2020-06-21/",
        "name": "dt",
        "type": "string",
        "value": "2020-06-21"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-prod",
        "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed",
        "key": "separated_dt/Product List Viewed/dt=2020-06-21/1592784496097.45403eac059f.baa71ec.915a17d1-2940-4148-8c35-ebaf2b4bfc3a.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.reactfoot_Product_List_Viewed",
        "type": "segment"
    }
}

running: False
schema_name_id: 131
start_time: 2020-06-21 19:17:20
success: True
trace_id: 3299964747683512643

Partitions:

count: 3

ddl:

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

name: dt

state:

[
    {
        "info": {
            "id": 541036,
            "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2021-02-09/",
            "name": "dt",
            "value": "2021-02-09"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2021-02-08 18:03:48",
                "last_data": "2021-02-09 18:48:10"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 541218,
            "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2021-02-10/",
            "name": "dt",
            "value": "2021-02-10"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2021-02-09 18:05:10",
                "last_data": "2021-02-10 19:04:21"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 541395,
            "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2021-02-11/",
            "name": "dt",
            "value": "2021-02-11"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2021-02-10 18:05:36",
                "last_data": "2021-02-11 15:32:33"
            },
            "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.amp.id": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.campaign.term": "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",
    "integrations.campaign.content": "string",
    "integrations.campaign.medium": "string",
    "integrations.campaign.name": "string",
    "integrations.campaign.source": "string",
    "integrations.library.name": "string",
    "integrations.library.version": "string",
    "integrations.page.path": "string",
    "integrations.page.referrer": "string",
    "integrations.page.search": "string",
    "integrations.page.title": "string",
    "integrations.page.url": "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",
            "hasClosestBadge": "string",
            "hasContactlessBadge": "string",
            "hasRecommendedBadge": "string",
            "hasTopratedBadge": "string",
            "id": "string",
            "inNetwork": "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.searchTerm": "string",
    "properties.search_id": "string",
    "properties.site_id": "string",
    "properties.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

created: 2020-07-28 06:12:42

ddl:

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

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2017-11-02 14:02:24",
        "disabled": false,
        "format": "raw",
        "id": 131,
        "is_partitioned": true,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_segment",
            "table": "reactfoot_product_list_viewed"
        },
        "type": "segment"
    },
    "partition": {
        "count": 3,
        "ddl": [
            "ALTER TABLE\n    `sfdl_prod_segment.reactfoot_product_list_viewed`\nADD\n\n\n PARTITION (dt='2021-02-09') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2021-02-09/'\n PARTITION (dt='2021-02-10') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2021-02-10/'\n PARTITION (dt='2021-02-11') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2021-02-11/'\n;"
        ],
        "name": "dt",
        "state": [
            {
                "info": {
                    "id": 541036,
                    "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2021-02-09/",
                    "name": "dt",
                    "value": "2021-02-09"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2021-02-08 18:03:48",
                        "last_data": "2021-02-09 18:48:10"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 541218,
                    "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2021-02-10/",
                    "name": "dt",
                    "value": "2021-02-10"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2021-02-09 18:05:10",
                        "last_data": "2021-02-10 19:04:21"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 541395,
                    "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2021-02-11/",
                    "name": "dt",
                    "value": "2021-02-11"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2021-02-10 18:05:36",
                        "last_data": "2021-02-11 15:32:33"
                    },
                    "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.amp.id": "string",
            "context.campaign.content": "string",
            "context.campaign.medium": "string",
            "context.campaign.name": "string",
            "context.campaign.source": "string",
            "context.campaign.term": "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",
            "integrations.campaign.content": "string",
            "integrations.campaign.medium": "string",
            "integrations.campaign.name": "string",
            "integrations.campaign.source": "string",
            "integrations.library.name": "string",
            "integrations.library.version": "string",
            "integrations.page.path": "string",
            "integrations.page.referrer": "string",
            "integrations.page.search": "string",
            "integrations.page.title": "string",
            "integrations.page.url": "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",
                    "hasClosestBadge": "string",
                    "hasContactlessBadge": "string",
                    "hasRecommendedBadge": "string",
                    "hasTopratedBadge": "string",
                    "id": "string",
                    "inNetwork": "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.searchTerm": "string",
            "properties.search_id": "string",
            "properties.site_id": "string",
            "properties.value": "string",
            "receivedAt": "string",
            "sentAt": "string",
            "timestamp": "string",
            "type": "string",
            "userId": "string",
            "version": "string"
        },
        "created": "2020-07-28 06:12:42",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_product_list_viewed`\n(\n`userId`STRING,`originalTimestamp`STRING,`properties`struct<`searchTerm`:STRING,`list_id`:STRING,`search_id`:STRING,`page`:STRING,`isReact`:STRING,`category`:STRING,`Hit_Timestamp`:STRING,`site_id`:STRING,`productIds`:array,`value`:STRING,`env`:STRING,`products`:array>,`position`:STRING,`reviewAverage`:STRING,`id`:STRING>>>,`sentAt`STRING,`receivedAt`STRING,`version`STRING,`projectId`STRING,`messageId`STRING,`channel`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`anonymousId`STRING,`context`struct<`locale`:STRING,`userAgent`:STRING,`ip`:STRING,`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`title`:STRING,`referrer`:STRING>,`campaign`:struct<`source`:STRING,`term`:STRING,`medium`:STRING,`content`:STRING,`name`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>,`amp`:struct<`id`:STRING>>,`_origin`STRING,`type`STRING,`event`STRING,`integrations`struct<`library`:struct<`version`:STRING,`name`:STRING>,`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`referrer`:STRING,`title`:STRING>,`campaign`:struct<`content`:STRING,`source`:STRING,`medium`:STRING,`name`:STRING>>,`timestamp`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-prod/separated_dt/Product List Viewed'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_product_list_viewed`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_product_list_viewed"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}