Schema Info
Schema Name: sfdl_prod_segment.sfdc_productlistviewed
- created: 2023-01-29 18:13:22
- disabled: False
- format: raw
- id: 1258
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_prod_segment", "table": "sfdc_productlistviewed" } - type: segment
Schema Versions: 2
-
Version 505401
- created: 2023-05-03 13:49:51
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "DROP TABLE IF EXISTS `sfdl_prod_segment.sfdc_productlistviewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.sfdc_productlistviewed`\n(\n`userId`STRING,`projectId`STRING,`sentAt`STRING,`context`struct<`locale`:STRING,`page`:struct<`path`:STRING,`referrer`:STRING,`search`:STRING,`title`:STRING,`url`:STRING>,`userAgent`:STRING,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING,`source`:STRING>,`library`:struct<`name`:STRING,`version`:STRING>,`ip`:STRING>,`properties`struct<`env`:STRING,`productIds`:array,`page`:STRING,`searchTerm`:STRING,`search_id`:STRING,`category`:STRING,`products`:array ,`value`:STRING,`list_id`:STRING,`isReact`:STRING,`site_id`:STRING,`Hit_Timestamp`:STRING>,`originalTimestamp`STRING,`_origin`STRING,`type`STRING,`timestamp`STRING,`channel`STRING,`receivedAt`STRING,`anonymousId`STRING,`version`STRING,`event`STRING,`messageId`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-sfdc-prod/separated_dt/Product List Viewed'\n", "MSCK REPAIR TABLE sfdl_prod_segment.sfdc_productlistviewed" ] - hive_path: s3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed
- id: 505401
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "FullStory", "Google Analytics", "Segment.io" ], "bundledIds": [ "wnVmulcSeT", "x15SFsQknT" ], "unbundled": [] }, "_origin": "2023-05-03T18:49:39Z|s3://sfdl-segment-sfdc-prod/segment-logs/SgsnnfL86n/1683072000000/1683139510015.events-archiver-480-54.8ebb200.211040a6-84a0-48eb-a6b1-57af33dfce65.gz|analytics-segment-separator-prod:$LATEST", "anonymousId": "22c0d0b9-db4e-4f08-82c7-d26c922c8921", "channel": "client", "context": { "campaign": { "content": "control", "medium": "paidsearch", "name": "pro_national_nogeo_noproduct_mobile-geobmm", "source": "google" }, "ip": "107.190.251.35", "library": { "name": "analytics.js", "version": "next-1.51.6" }, "locale": "en-US", "page": { "path": "/New-York-NY-self-storage.html", "referrer": "https://www.google.com/", "search": "?tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=pro_national_nogeo_noproduct_mobile-geobmm&utm_content=control&ploc=9031008&iloc=1022900&mkwid=sTo3Avhos|pcrid|591132266319|pkw|%2Bstorage%20%2Bunits%20%2Bin%20%2Bnew%20%2Byork%20%2Bny|pmt|b|pdv|c|pgrid|47109517848|cpgnid|644890316|ptaid|kwd-350959946347|adext|&pgrid=47109517848&ptaid=kwd-350959946347&gclid=CjwKCAjw6IiiBhAOEiwALNqncd6fW-uc4DBTX-to6Yffmj8SlPrKvMU3uL2EVlyeDQIzlV26KoRR3RoCN7QQAvD_BwE", "title": "15 Cheap Storage Units in New York City (From $5) - SpareFoot", "url": "https://www.sparefoot.com/New-York-NY-self-storage.html?tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=pro_national_nogeo_noproduct_mobile-geobmm&utm_content=control&ploc=9031008&iloc=1022900&mkwid=sTo3Avhos|pcrid|591132266319|pkw|%2Bstorage%20%2Bunits%20%2Bin%20%2Bnew%20%2Byork%20%2Bny|pmt|b|pdv|c|pgrid|47109517848|cpgnid|644890316|ptaid|kwd-350959946347|adext|&pgrid=47109517848&ptaid=kwd-350959946347&gclid=CjwKCAjw6IiiBhAOEiwALNqncd6fW-uc4DBTX-to6Yffmj8SlPrKvMU3uL2EVlyeDQIzlV26KoRR3RoCN7QQAvD_BwE" }, "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36" }, "event": "Product List Viewed", "integrations": {}, "messageId": "ajs-next-78a19e30882793214957e8a174cacddb", "originalTimestamp": "2023-04-21T17:57:05.236Z", "projectId": "SgsnnfL86n", "properties": { "Hit Timestamp": 1682099825234, "category": "New York, NY-cityLandingPage", "env": "production", "isReact": true, "list_id": "search results: New York, NY", "page": 1, "productIds": [ 223279, 222446, 221899, 223279, 223272, 223281, 223284, 223278, 223273, 223276, 223282, 223277, 223275, 228109, 226660, 227947 ], "products": [ { "distance": 0.9, "hasContactlessBadge": true, "hasErentalBadge": false, "hasOmibadgeBadge": false, "id": 223279, "inNetwork": true, "isTopYielder": false, "name": "Manhattan Mini Storage - Spring & Varick", "position": 1, "rank": 1, "reviewAverage": 0, "reviewCount": 0, "unitCount": 1, "units": [ { "id": 27438373, "maxBookingDate": "2023-05-05T11:02:28.000Z", "priceValue": 384.99, "promotion": "Free Month", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 1.8, "hasContactlessBadge": false, "hasErentalBadge": true, "hasOmibadgeBadge": false, "id": 222446, "inNetwork": true, "isTopYielder": false, "name": "Storage Post - East Village", "position": 2, "rank": 2, "reviewAverage": 4.667, "reviewCount": 3, "unitCount": 1, "units": [ { "id": 29447622, "maxBookingDate": "2023-05-21T11:02:53.000Z", "priceValue": 435, "promotion": "50% Off 1st Month", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 3.8, "hasContactlessBadge": false, "hasErentalBadge": false, "hasOmibadgeBadge": false, "id": 221899, "inNetwork": true, "isTopYielder": false, "name": "Life Storage - New York - 622 West 51st Street", "position": 3, "rank": 3, "reviewAverage": 4.767, "reviewCount": 15, "unitCount": 1, "units": [ { "id": 26199377, "maxBookingDate": "2023-04-22T11:03:02.000Z", "priceValue": 395, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 0.9, "id": 223279, "inNetwork": true, "isTopYielder": true, "name": "Manhattan Mini Storage - Spring & Varick", "position": 4, "rank": 4, "reviewAverage": 0, "reviewCount": 0, "unitCount": 1, "units": [ {} ] }, { "distance": 2.7, "hasContactlessBadge": true, "hasErentalBadge": false, "hasOmibadgeBadge": false, "id": 223272, "inNetwork": true, "isTopYielder": false, "name": "Manhattan Mini Storage - 29th St & 11th Ave", "position": 5, "rank": 5, "reviewAverage": 4, "reviewCount": 1, "unitCount": 1, "units": [ { "id": 28206835, "maxBookingDate": "2023-05-05T11:02:29.000Z", "priceValue": 717.99, "promotion": "Free Month", "sizeText": "9' x 11'", "squareFootage": 99, "unitTypeText": "unit" } ] }, { "distance": 0.6, "hasContactlessBadge": true, "hasErentalBadge": false, "hasOmibadgeBadge": false, "id": 223281, "inNetwork": true, "isTopYielder": false, "name": "Manhattan Mini Storage - South St & Catherine Slip", "position": 6, "rank": 6, "reviewAverage": 0, "reviewCount": 0, "unitCount": 1, "units": [ { "id": 28322302, "maxBookingDate": "2023-05-05T11:02:28.000Z", "priceValue": 519.99, "promotion": "Free Month", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 2.3, "hasContactlessBadge": true, "hasErentalBadge": false, "hasOmibadgeBadge": false, "id": 223284, "inNetwork": true, "isTopYielder": false, "name": "Manhattan Mini Storage - Chelsea Piers", "position": 7, "rank": 7, "reviewAverage": 0, "reviewCount": 0, "unitCount": 1, "units": [ { "id": 27438293, "maxBookingDate": "2023-05-05T11:02:28.000Z", "priceValue": 374.99, "promotion": "Free Month", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 3.5, "hasContactlessBadge": true, "hasErentalBadge": false, "hasOmibadgeBadge": false, "id": 223278, "inNetwork": true, "isTopYielder": false, "name": "Manhattan Mini Storage - 44th St & 11th Ave", "position": 8, "rank": 8, "reviewAverage": 0, "reviewCount": 0, "unitCount": 1, "units": [ { "id": 28634554, "maxBookingDate": "2023-05-05T11:02:29.000Z", "priceValue": 438.99, "promotion": "Free Month", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 2.2, "hasContactlessBadge": true, "hasErentalBadge": false, "hasOmibadgeBadge": false, "id": 223273, "inNetwork": true, "isTopYielder": false, "name": "Manhattan Mini Storage - 17th St & 11th Ave", "position": 9, "rank": 9, "reviewAverage": 0, "reviewCount": 0, "unitCount": 1, "units": [ { "id": 27437925, "maxBookingDate": "2023-05-05T11:02:29.000Z", "priceValue": 372.99, "promotion": "Free Month", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 3.4, "hasContactlessBadge": true, "hasErentalBadge": false, "hasOmibadgeBadge": false, "id": 223276, "inNetwork": true, "isTopYielder": false, "name": "Manhattan Mini Storage - 43rd St & 11th Ave", "position": 10, "rank": 10, "reviewAverage": 0, "reviewCount": 0, "unitCount": 1, "units": [ { "id": 27438042, "maxBookingDate": "2023-05-05T11:02:29.000Z", "priceValue": 379.99, "promotion": "Free Month", "sizeText": "7' x 14'", "squareFootage": 98, "unitTypeText": "unit" } ] }, { "distance": 6.4, "hasContactlessBadge": true, "hasErentalBadge": false, "hasOmibadgeBadge": false, "id": 223282, "inNetwork": true, "isTopYielder": false, "name": "Manhattan Mini Storage - 107th St & Columbus Ave", "position": 11, "rank": 11, "reviewAverage": 0, "reviewCount": 0, "unitCount": 1, "units": [ { "id": 28528271, "maxBookingDate": "2023-05-05T11:02:28.000Z", "priceValue": 859.99, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 4.1, "hasContactlessBadge": true, "hasErentalBadge": false, "hasOmibadgeBadge": false, "id": 223277, "inNetwork": true, "isTopYielder": false, "name": "Manhattan Mini Storage - 62nd St & 1st Ave", "position": 12, "rank": 12, "reviewAverage": 0, "reviewCount": 0, "unitCount": 1, "units": [ { "id": 27822165, "maxBookingDate": "2023-05-05T11:02:29.000Z", "priceValue": 799.99, "promotion": "", "sizeText": "7' x 14'", "squareFootage": 98, "unitTypeText": "unit" } ] }, { "distance": 7.8, "hasContactlessBadge": true, "hasErentalBadge": false, "hasOmibadgeBadge": false, "id": 223275, "inNetwork": true, "isTopYielder": false, "name": "Manhattan Mini Storage - 135th St & Riverside Drive", "position": 13, "rank": 13, "reviewAverage": 5, "reviewCount": 1, "unitCount": 1, "units": [ { "id": 27437945, "maxBookingDate": "2023-05-05T11:02:29.000Z", "priceValue": 284.99, "promotion": "Free Month", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 8.1, "hasContactlessBadge": false, "hasErentalBadge": false, "hasOmibadgeBadge": false, "id": 228109, "inNetwork": true, "isTopYielder": false, "name": "Prime Storage - Harlem", "position": 14, "rank": 14, "reviewAverage": 0, "reviewCount": 0, "unitCount": 1, "units": [ { "id": 29734585, "maxBookingDate": "2023-05-05T11:00:09.000Z", "priceValue": 275, "promotion": "First Month FREE", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 11.4, "hasContactlessBadge": true, "hasErentalBadge": false, "hasOmibadgeBadge": false, "id": 226660, "inNetwork": true, "isTopYielder": false, "name": "CubeSmart Self Storage - 308 Dyckman Street", "position": 15, "rank": 15, "reviewAverage": 0, "reviewCount": 0, "unitCount": 1, "units": [ { "id": 27983887, "maxBookingDate": "2023-05-06T11:00:42.000Z", "priceValue": 408, "promotion": "15% Off and First Month Free", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 8.8, "hasContactlessBadge": false, "hasErentalBadge": false, "hasOmibadgeBadge": false, "id": 227947, "inNetwork": true, "isTopYielder": false, "name": "StorQuest - New York / 8th", "position": 16, "rank": 16, "reviewAverage": 0, "reviewCount": 0, "unitCount": 1, "units": [ { "id": 28632020, "maxBookingDate": "2023-04-28T11:00:10.000Z", "priceValue": 195, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] } ], "searchTerm": "New York, NY", "search_id": "64e16442ce71138ff6.01120573", "site_id": -1, "value": 16 }, "receivedAt": "2023-05-03T17:53:23.207Z", "sentAt": "2023-05-03T17:53:23.073Z", "timestamp": "2023-04-21T17:57:05.370Z", "type": "track", "userId": "143260930b60923dd6cb1f3b14e9998d", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.content": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.source": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.userAgent": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.isReact": "string", "properties.list_id": "string", "properties.page": "string", "properties.productIds": [ "int" ], "properties.products": [ "string" ], "properties.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: 1258
- schema_scan_id: 92068705
- updated: 2023-05-03 13:50:38
-
Version 430394
- created: 2023-01-29 18:13:23
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "DROP TABLE IF EXISTS `sfdl_prod_segment.sfdc_productlistviewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.sfdc_productlistviewed`\n(\n`anonymousId`STRING,`channel`STRING,`context`struct<`ip`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`locale`:STRING,`page`:struct<`path`:STRING,`referrer`:STRING,`search`:STRING,`title`:STRING,`url`:STRING>,`userAgent`:STRING>,`event`STRING,`messageId`STRING,`originalTimestamp`STRING,`projectId`STRING,`properties`struct<`Hit_Timestamp`:STRING,`category`:STRING,`env`:STRING,`isReact`:STRING,`list_id`:STRING,`page`:STRING,`productIds`:array,`products`:array ,`searchTerm`:STRING,`search_id`:STRING,`site_id`:STRING,`value`:STRING>,`receivedAt`STRING,`sentAt`STRING,`timestamp`STRING,`type`STRING,`userId`STRING,`version`STRING,`_origin`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-sfdc-prod/separated_dt/Product List Viewed'\n", "MSCK REPAIR TABLE sfdl_prod_segment.sfdc_productlistviewed" ] - hive_path: s3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed
- id: 430394
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "FullStory", "Google Analytics", "Segment.io" ], "bundledIds": [ "wnVmulcSeT", "x15SFsQknT" ], "unbundled": [] }, "_origin": "2023-01-30T00:13:07Z|s3://sfdl-segment-sfdc-prod/segment-logs/SgsnnfL86n/1674950400000/1675037451771.events-archiver-480-6.8ebb200.a4f3465c-bee4-4bba-8270-6a17af9636a9.gz|analytics-segment-separator-prod:$LATEST", "anonymousId": "fb3570a7-39b9-439b-8ffd-daec810a19b8", "channel": "client", "context": { "ip": "76.219.144.212", "library": { "name": "analytics.js", "version": "next-1.49.2" }, "locale": "en-US", "page": { "path": "/Spring-TX-self-storage.html", "referrer": "https://www.sparefoot.com/?&tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=pro_national_nogeo_noproduct_dynamic&utm_content=&ploc=9027724&iloc=&mkwid=sZMy1mHbi|pcrid|271805932931|pkw||pmt||pdv|m|pgrid|32834077871|ptaid|dsa-105354360795&pgrid=32834077871&ptaid=dsa-105354360795&gclid=Cj0KCQiAic6eBhCoARIsANlox85uW218WxyNs9UPLeUzpYfzbiRYZVtOkwPyHGgAmEMdXHg8PUqEaFoaAnAuEALw_wcB", "search": "?searchType=storage&page=1&latitude=30.106759504813688&longitude=-95.420055&boundary=-95.4821535031128%2030.005146466391253%20-95.35795649688721%2030.208372543236123&listingsPerPage=15&zip=77386&subPageType=cityLandingPage", "title": "15 Cheap Storage Units in Spring, TX (From $19) - SpareFoot", "url": "https://www.sparefoot.com/Spring-TX-self-storage.html?searchType=storage&page=1&latitude=30.106759504813688&longitude=-95.420055&boundary=-95.4821535031128%2030.005146466391253%20-95.35795649688721%2030.208372543236123&listingsPerPage=15&zip=77386&subPageType=cityLandingPage" }, "userAgent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36" }, "event": "Product List Viewed", "integrations": {}, "messageId": "ajs-next-8dba99f02cb0922f105f7c5b2c016735", "originalTimestamp": "2023-01-28T04:59:12.028Z", "projectId": "SgsnnfL86n", "properties": { "Hit Timestamp": 1674881952018, "category": "Spring, TX-cityLandingPage", "env": "production", "isReact": true, "list_id": "search results: Spring, TX", "page": 1, "productIds": [ 152756, 213582, 211476, 152756, 224519, 212296, 220854, 210552, 152755, 223826, 220847, 223948, 63292, 213599, 213646, 216962 ], "products": [ { "distance": 1.3, "hasContactlessBadge": true, "hasErentalBadge": false, "hasOmibadgeBadge": false, "id": 152756, "inNetwork": true, "isTopYielder": false, "name": "CubeSmart Self Storage - Spring - 1310 Rayford Road", "position": 1, "rank": 1, "reviewAverage": 4.65, "reviewCount": 10, "unitCount": 2, "units": [ { "id": 26717929, "maxBookingDate": "2023-02-11T21:39:37.000Z", "priceValue": 62.93, "promotion": "35% Off", "sizeText": "5' x 7.5'", "squareFootage": 37.5, "unitTypeText": "unit" }, { "id": 25883653, "maxBookingDate": "2023-02-11T21:39:37.000Z", "priceValue": 64.27, "promotion": "35% Off", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 1.9, "hasContactlessBadge": true, "hasErentalBadge": false, "hasOmibadgeBadge": false, "id": 213582, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Spring - 24919 North Freeway", "position": 2, "rank": 2, "reviewAverage": 4.6, "reviewCount": 30, "unitCount": 3, "units": [ { "id": 26050916, "maxBookingDate": "2023-02-26T21:53:59.000Z", "priceValue": 38, "promotion": "$1 first month rent", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 25088262, "maxBookingDate": "2023-02-26T21:53:59.000Z", "priceValue": 48, "promotion": "$1 first month rent", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 25088263, "maxBookingDate": "2023-02-26T21:53:59.000Z", "priceValue": 92, "promotion": "$1 first month rent", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 2.5, "hasContactlessBadge": true, "hasErentalBadge": false, "hasOmibadgeBadge": false, "id": 211476, "inNetwork": true, "isTopYielder": false, "name": "CubeSmart Self Storage - Spring - 610 Sawdust Road", "position": 3, "rank": 3, "reviewAverage": 4.778, "reviewCount": 9, "unitCount": 3, "units": [ { "id": 25876048, "maxBookingDate": "2023-02-11T21:55:29.000Z", "priceValue": 35.48, "promotion": "35% Off", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 26628964, "maxBookingDate": "2023-02-11T21:55:29.000Z", "priceValue": 50.21, "promotion": "35% Off", "sizeText": "10' x 5'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 26787513, "maxBookingDate": "2023-02-11T21:55:29.000Z", "priceValue": 66.95, "promotion": "35% Off", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 1.3, "id": 152756, "inNetwork": true, "isTopYielder": true, "name": "CubeSmart Self Storage - Spring - 1310 Rayford Road", "position": 4, "rank": 4, "reviewAverage": 4.65, "reviewCount": 10, "unitCount": 2, "units": [ {}, {} ] }, { "distance": 3.3, "hasContactlessBadge": true, "hasErentalBadge": false, "hasOmibadgeBadge": false, "id": 224519, "inNetwork": true, "isTopYielder": false, "name": "RecNation RV & Boat Storage - Conroe, TX - 28153 Robinson Road", "position": 5, "rank": 5, "reviewAverage": 0, "reviewCount": 0, "unitCount": 1, "units": [ { "id": 27120938, "maxBookingDate": "2023-02-10T21:44:14.000Z", "priceValue": 119, "promotion": "30% Off First 3 Months!", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 3.4, "hasContactlessBadge": false, "hasErentalBadge": false, "hasOmibadgeBadge": false, "id": 212296, "inNetwork": true, "isTopYielder": false, "name": "Spring Self Storage", "position": 6, "rank": 6, "reviewAverage": 3.875, "reviewCount": 4, "unitCount": 2, "units": [ { "id": 21750662, "maxBookingDate": "2023-02-03T21:54:58.000Z", "priceValue": 52, "promotion": "Units are Smart units powered by Storage Defender; a $12.00 monthly fee will be added to all units", "sizeText": "10' x 5'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 21750679, "maxBookingDate": "2023-02-03T21:54:58.000Z", "priceValue": 75, "promotion": "Units are Smart units powered by Storage Defender; a $12.00 monthly fee will be added to all units", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 3.4, "hasContactlessBadge": true, "hasErentalBadge": false, "hasOmibadgeBadge": false, "id": 220854, "inNetwork": true, "isTopYielder": false, "name": "Storage King USA - 107 - The Woodlands, TX - Sawdust Road", "position": 7, "rank": 7, "reviewAverage": 0, "reviewCount": 0, "unitCount": 3, "units": [ { "id": 25768775, "maxBookingDate": "2023-01-29T21:48:05.000Z", "priceValue": 62, "promotion": "", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 25768973, "maxBookingDate": "2023-01-29T21:48:05.000Z", "priceValue": 56, "promotion": "", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 25768996, "maxBookingDate": "2023-01-29T21:48:05.000Z", "priceValue": 108, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 1.7, "hasContactlessBadge": true, "hasErentalBadge": false, "hasOmibadgeBadge": false, "id": 210552, "inNetwork": true, "isTopYielder": false, "name": "Life Storage - Spring - 3411 Rayford Road", "position": 8, "rank": 8, "reviewAverage": 5, "reviewCount": 1, "unitCount": 2, "units": [ { "id": 20835088, "maxBookingDate": "2023-01-28T21:55:58.000Z", "priceValue": 61, "promotion": "", "sizeText": "10' x 5'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 20812940, "maxBookingDate": "2023-01-28T21:55:58.000Z", "priceValue": 97, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 2.5, "hasContactlessBadge": true, "hasErentalBadge": false, "hasOmibadgeBadge": false, "id": 152755, "inNetwork": true, "isTopYielder": false, "name": "CubeSmart Self Storage - Spring - 765 Sawdust Road", "position": 9, "rank": 9, "reviewAverage": 4.667, "reviewCount": 3, "unitCount": 3, "units": [ { "id": 25880008, "maxBookingDate": "2023-02-11T21:39:37.000Z", "priceValue": 40.17, "promotion": "35% Off", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 25872906, "maxBookingDate": "2023-02-11T21:39:37.000Z", "priceValue": 64.94, "promotion": "35% Off", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 26773647, "maxBookingDate": "2023-02-11T21:39:37.000Z", "priceValue": 66.95, "promotion": "35% Off", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 2.4, "hasContactlessBadge": true, "hasErentalBadge": false, "hasOmibadgeBadge": false, "id": 223826, "inNetwork": true, "isTopYielder": false, "name": "CubeSmart Self Storage - TX SPRING BUDDE ROAD", "position": 10, "rank": 10, "reviewAverage": 0, "reviewCount": 0, "unitCount": 2, "units": [ { "id": 26868944, "maxBookingDate": "2023-02-11T21:44:58.000Z", "priceValue": 31.47, "promotion": "35% Off", "sizeText": "8' x 5'", "squareFootage": 40, "unitTypeText": "unit" }, { "id": 26868947, "maxBookingDate": "2023-02-11T21:44:58.000Z", "priceValue": 76.99, "promotion": "35% Off", "sizeText": "8' x 12'", "squareFootage": 96, "unitTypeText": "unit" } ] }, { "distance": 2.1, "hasContactlessBadge": true, "hasErentalBadge": false, "hasOmibadgeBadge": false, "id": 220847, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Spring - 28823 Birnham Woods Dr", "position": 11, "rank": 11, "reviewAverage": 3, "reviewCount": 1, "unitCount": 2, "units": [ { "id": 25765838, "maxBookingDate": "2023-02-26T21:48:05.000Z", "priceValue": 70, "promotion": "$1 first month rent", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 26151304, "maxBookingDate": "2023-02-26T21:48:05.000Z", "priceValue": 114, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 2.5, "hasContactlessBadge": false, "hasErentalBadge": false, "hasOmibadgeBadge": false, "id": 223948, "inNetwork": true, "isTopYielder": false, "name": "Devon Self Storage - DSP", "position": 12, "rank": 12, "reviewAverage": 4, "reviewCount": 5, "unitCount": 3, "units": [ { "id": 26913224, "maxBookingDate": "2023-02-03T21:44:50.000Z", "priceValue": 23, "promotion": "First Month FREE", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 26913246, "maxBookingDate": "2023-02-03T21:44:50.000Z", "priceValue": 50, "promotion": "Limited Availability", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 27139907, "maxBookingDate": "2023-02-03T21:44:50.000Z", "priceValue": 107, "promotion": "Half Month FREE", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 1.9, "hasContactlessBadge": true, "hasErentalBadge": false, "hasOmibadgeBadge": false, "id": 63292, "inNetwork": true, "isTopYielder": false, "name": "CubeSmart Self Storage - Spring - 1220 W Riley Fuzzel Road", "position": 13, "rank": 13, "reviewAverage": 4.514, "reviewCount": 37, "unitCount": 3, "units": [ { "id": 25870163, "maxBookingDate": "2023-02-04T21:41:26.000Z", "priceValue": 22.76, "promotion": "35% Off", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 26627532, "maxBookingDate": "2023-02-04T21:41:26.000Z", "priceValue": 40.17, "promotion": "35% Off", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 26627537, "maxBookingDate": "2023-02-04T21:41:26.000Z", "priceValue": 83.02, "promotion": "35% Off", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 1.7, "hasContactlessBadge": true, "hasErentalBadge": false, "hasOmibadgeBadge": false, "id": 213599, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Spring - 22330 Interstate 45", "position": 14, "rank": 14, "reviewAverage": 4.966, "reviewCount": 296, "unitCount": 3, "units": [ { "id": 22243921, "maxBookingDate": "2023-02-11T21:53:59.000Z", "priceValue": 50, "promotion": "50% off 1st Month", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22243904, "maxBookingDate": "2023-02-11T21:53:59.000Z", "priceValue": 56, "promotion": "50% off 1st Month", "sizeText": "10' x 5'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22243887, "maxBookingDate": "2023-02-11T21:53:59.000Z", "priceValue": 86, "promotion": "50% off 1st Month", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 3.5, "hasContactlessBadge": true, "hasErentalBadge": false, "hasOmibadgeBadge": false, "id": 213646, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Spring - 2101 Old Holzwarth Rd", "position": 15, "rank": 15, "reviewAverage": 4.739, "reviewCount": 23, "unitCount": 3, "units": [ { "id": 22241946, "maxBookingDate": "2023-02-11T21:53:59.000Z", "priceValue": 38, "promotion": "", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22241945, "maxBookingDate": "2023-02-11T21:53:59.000Z", "priceValue": 60, "promotion": "", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22241940, "maxBookingDate": "2023-02-11T21:53:59.000Z", "priceValue": 130, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 3, "hasContactlessBadge": false, "hasErentalBadge": false, "hasOmibadgeBadge": false, "id": 216962, "inNetwork": true, "isTopYielder": false, "name": "Spring Storage / Climated Controlled", "position": 16, "rank": 16, "reviewAverage": 4.5, "reviewCount": 6, "unitCount": 1, "units": [ { "id": 23145428, "maxBookingDate": "2023-03-28T21:51:02.000Z", "priceValue": 80, "promotion": "Special Offer when you stay more than Six Months!", "sizeText": "6' x 10'", "squareFootage": 60, "unitTypeText": "unit" } ] } ], "searchTerm": "Spring, TX", "search_id": "f64a63d4ab9362d952.00007606", "site_id": -1, "value": 16 }, "receivedAt": "2023-01-29T23:34:48.727Z", "sentAt": "2023-01-29T23:34:48.507Z", "timestamp": "2023-01-28T04:59:12.248Z", "type": "track", "userId": "68e5407da279bfbca3caec3a651daeec", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.userAgent": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.isReact": "string", "properties.list_id": "string", "properties.page": "string", "properties.productIds": [ "int" ], "properties.products": [ "string" ], "properties.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: 1258
- schema_scan_id: 84806110
- updated: 2023-01-29 18:14:05
Schema Scans: 2
Last at 2023-05-03 13:49:50
-
Scan 92068705
- duration: 0:00:58.668103
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 459, "partitions_applied": false, "success": true } - id: 92068705
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed/dt=2023-05-03/", "name": "dt", "type": "string", "value": "2023-05-03" }, "s3": { "bucket": "sfdl-segment-sfdc-prod", "hive_path": "s3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed", "key": "separated_dt/Product List Viewed/dt=2023-05-03/1683139510015.events-archiver-480-54.8ebb200.211040a6-84a0-48eb-a6b1-57af33dfce65.json.gz" }, "schema": { "name": "sfdl_prod_segment.sfdc_ProductListViewed", "type": "segment" } } - running: False
- schema_name_id: 1258
- start_time: 2023-05-03 13:49:50
- success: True
- trace_id: 84577666827022929
-
Scan 84806110
- duration: 0:01:20.496146
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 441, "partitions_applied": false, "success": true } - id: 84806110
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed/dt=2023-01-29/", "name": "dt", "type": "string", "value": "2023-01-29" }, "s3": { "bucket": "sfdl-segment-sfdc-prod", "hive_path": "s3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed", "key": "separated_dt/Product List Viewed/dt=2023-01-29/1675037451771.events-archiver-480-6.8ebb200.a4f3465c-bee4-4bba-8270-6a17af9636a9.json.gz" }, "schema": { "name": "sfdl_prod_segment.sfdc_ProductListViewed", "type": "segment" } } - running: False
- schema_name_id: 1258
- start_time: 2023-01-29 18:13:22
- success: True
- trace_id: 15485150802629072382
- count: 3
- ddl:
[ "ALTER TABLE\n `sfdl_prod_segment.sfdc_productlistviewed`\nADD\n\n\n PARTITION (dt='2023-05-31') location 's3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed/dt=2023-05-31/'\n PARTITION (dt='2023-06-06') location 's3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed/dt=2023-06-06/'\n PARTITION (dt='2023-06-08') location 's3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed/dt=2023-06-08/'\n;" ] - name: dt
- state:
[ { "info": { "id": 926549, "location": "s3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed/dt=2023-05-31/", "name": "dt", "value": "2023-05-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-05-31 13:39:08", "last_data": "2023-05-31 13:39:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 927684, "location": "s3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed/dt=2023-06-06/", "name": "dt", "value": "2023-06-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-06-06 11:07:03", "last_data": "2023-06-06 11:07:03" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 927954, "location": "s3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed/dt=2023-06-08/", "name": "dt", "value": "2023-06-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-06-07 20:38:27", "last_data": "2023-06-07 20:38:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } } ] - type: string
- attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.content": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.source": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.userAgent": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.isReact": "string", "properties.list_id": "string", "properties.page": "string", "properties.productIds": [ "int" ], "properties.products": [ "string" ], "properties.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: 2023-05-03 13:49:51
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.sfdc_productlistviewed`\n(\n`userId`STRING,`projectId`STRING,`sentAt`STRING,`context`struct<`locale`:STRING,`page`:struct<`path`:STRING,`referrer`:STRING,`search`:STRING,`title`:STRING,`url`:STRING>,`userAgent`:STRING,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING,`source`:STRING>,`library`:struct<`name`:STRING,`version`:STRING>,`ip`:STRING>,`properties`struct<`env`:STRING,`productIds`:array,`page`:STRING,`searchTerm`:STRING,`search_id`:STRING,`category`:STRING,`products`:array ,`value`:STRING,`list_id`:STRING,`isReact`:STRING,`site_id`:STRING,`Hit_Timestamp`:STRING>,`originalTimestamp`STRING,`_origin`STRING,`type`STRING,`timestamp`STRING,`channel`STRING,`receivedAt`STRING,`anonymousId`STRING,`version`STRING,`event`STRING,`messageId`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-sfdc-prod/separated_dt/Product List Viewed'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.sfdc_productlistviewed`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.sfdc_productlistviewed" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2023-01-29 18:13:22",
"disabled": false,
"format": "raw",
"id": 1258,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_prod_segment",
"table": "sfdc_productlistviewed"
},
"type": "segment"
},
"partition": {
"count": 3,
"ddl": [
"ALTER TABLE\n `sfdl_prod_segment.sfdc_productlistviewed`\nADD\n\n\n PARTITION (dt='2023-05-31') location 's3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed/dt=2023-05-31/'\n PARTITION (dt='2023-06-06') location 's3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed/dt=2023-06-06/'\n PARTITION (dt='2023-06-08') location 's3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed/dt=2023-06-08/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 926549,
"location": "s3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed/dt=2023-05-31/",
"name": "dt",
"value": "2023-05-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-05-31 13:39:08",
"last_data": "2023-05-31 13:39:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 927684,
"location": "s3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed/dt=2023-06-06/",
"name": "dt",
"value": "2023-06-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-06-06 11:07:03",
"last_data": "2023-06-06 11:07:03"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 927954,
"location": "s3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed/dt=2023-06-08/",
"name": "dt",
"value": "2023-06-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-06-07 20:38:27",
"last_data": "2023-06-07 20:38:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
}
],
"type": "string"
},
"schema": {
"attributes": {
"_origin": "string",
"anonymousId": "string",
"channel": "string",
"context.campaign.content": "string",
"context.campaign.medium": "string",
"context.campaign.name": "string",
"context.campaign.source": "string",
"context.ip": "string",
"context.library.name": "string",
"context.library.version": "string",
"context.locale": "string",
"context.page.path": "string",
"context.page.referrer": "string",
"context.page.search": "string",
"context.page.title": "string",
"context.page.url": "string",
"context.userAgent": "string",
"event": "string",
"messageId": "string",
"originalTimestamp": "string",
"projectId": "string",
"properties.Hit_Timestamp": "string",
"properties.category": "string",
"properties.env": "string",
"properties.isReact": "string",
"properties.list_id": "string",
"properties.page": "string",
"properties.productIds": [
"int"
],
"properties.products": [
"string"
],
"properties.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": "2023-05-03 13:49:51",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.sfdc_productlistviewed`\n(\n`userId`STRING,`projectId`STRING,`sentAt`STRING,`context`struct<`locale`:STRING,`page`:struct<`path`:STRING,`referrer`:STRING,`search`:STRING,`title`:STRING,`url`:STRING>,`userAgent`:STRING,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING,`source`:STRING>,`library`:struct<`name`:STRING,`version`:STRING>,`ip`:STRING>,`properties`struct<`env`:STRING,`productIds`:array,`page`:STRING,`searchTerm`:STRING,`search_id`:STRING,`category`:STRING,`products`:array,`value`:STRING,`list_id`:STRING,`isReact`:STRING,`site_id`:STRING,`Hit_Timestamp`:STRING>,`originalTimestamp`STRING,`_origin`STRING,`type`STRING,`timestamp`STRING,`channel`STRING,`receivedAt`STRING,`anonymousId`STRING,`version`STRING,`event`STRING,`messageId`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-sfdc-prod/separated_dt/Product List Viewed'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.sfdc_productlistviewed`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.sfdc_productlistviewed"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}