Schema Info
Schema Name: sfdl_prod_segment.reactfoot_productlistviewed
- created: 2021-02-11 16:04:02
- disabled: False
- format: raw
- id: 821
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_prod_segment", "table": "reactfoot_productlistviewed" } - type: segment
Schema Versions: 3
-
Version 1256863
- created: 2025-04-07 23:58:50
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_productlistviewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_productlistviewed`\n(\n`projectId`STRING,`timestamp`STRING,`type`STRING,`context`struct<`amp`:struct<`id`:STRING>,`userAgentData`:struct<`brands`:array,`search_id`:STRING,`list_id`:STRING,`isReact`:STRING,`env`:STRING>,`channel`STRING,`anonymousId`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_productlistviewed" ] - hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed
- id: 1256863
- processed: 1
- raw_data:
{ "__segment_internal": {}, "_metadata": { "bundled": [ "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c13c7c1386430001b3c90e" ], "unbundled": [] }, "_origin": "2025-04-08T04:57:36Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1744070400000/1744088207531.events-archiver-480-30..a73d65bb-2f1f-4221-8a00-a9a6f9b99289.gz|analytics-segment-separator-prod:$LATEST", "anonymousId": "9b8020aa-fc47-41a3-9c64-2f501d09462e", "channel": "client", "context": { "campaign": { "content": "01302025_LAL_Reservers_OLD", "id": "120216509598370476_v2_s11", "medium": "paid", "name": "LM_SF_PROSP_CONVESION_WEB_V2", "source": "fb-SiteLink-1", "term": "120216509598700476", "tm_source": "facebook" }, "ip": "50.204.239.194", "library": { "name": "analytics.js", "version": "next-1.77.0" }, "locale": "en-US", "page": { "path": "/Essex-MD-self-storage/car-storage.html", "referrer": "https://www.google.com/", "search": "", "title": "Essex, MD Car Storage Units & Vehicle Parking", "url": "https://www.sparefoot.com/Essex-MD-self-storage/car-storage.html" }, "timezone": "America/New_York", "userAgent": "Mozilla/5.0 (Linux; Android 14; SM-A156U Build/UP1A.231005.007; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/134.0.6998.170 Mobile Safari/537.36 [FB_IAB/FB4A;FBAV/506.1.0.74.27;IABMV/1;]", "userAgentData": { "brands": [ { "brand": "Google Chrome", "version": "134" } ], "mobile": false, "platform": "macOS" } }, "event": "Product List Viewed", "integrations": {}, "messageId": "ajs-next-1744084603023-fc47e1a3-dc64-4f50-9d09-462eb18635a8", "originalTimestamp": "2025-04-08T03:56:43.023Z", "projectId": "a0wkEvFBBK", "properties": { "Hit Timestamp": 1744084602401, "category": "Essex, MD-vehicleLandingPage", "env": "production", "isReact": true, "list_id": "search results: Essex, MD", "page": 1, "productIds": [ 200773, 215707, 219319, 105923, 223759, 200787, 219930, 153151, 222648, 200772, 215778, 215782, 235726, 215671, 153150 ], "products": [ { "distance": 11.2, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 219825, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Baltimore - 7401 Old Pimlico Rd", "position": 16, "rank": 16, "reviewAverage": 4.5, "reviewCount": 2, "unitCount": 1, "units": [ { "id": 32034779, "maxBookingDate": "2025-05-07T21:51:39.000Z", "priceValue": 318, "promotion": "2nd Month Free", "sizeText": "12' x 25'", "squareFootage": 300, "unitTypeText": "unit" } ] } ], "searchTerm": "Essex, MD", "search_id": "fc1f67f49e795851f8.04535822", "site_id": -1, "value": 16 }, "receivedAt": "2025-04-08T03:56:43.357Z", "sentAt": "2025-04-08T03:56:43.030Z", "timestamp": "2025-04-08T03:56:43.350Z", "type": "track", "userId": "31fdb26a8a27474a06d734f511805922", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.amp.id": "string", "context.campaign.c": "string", "context.campaign.conten": "string", "context.campaign.content": "string", "context.campaign.id": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.so": "string", "context.campaign.source": "string", "context.campaign.term": "string", "context.campaign.tm_source": "string", "context.campaign.utm_campaign": "string", "context.campaign.utm_content": "string", "context.campaign.utm_medium": "string", "context.campaign.utm_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.timezone": "string", "context.userAgent": "string", "context.userAgentData.brands": [ { "brand": "string", "version": "string" } ], "context.userAgentData.mobile": "string", "context.userAgentData.platform": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.isReact": "string", "properties.label": "string", "properties.list_id": "string", "properties.page": "string", "properties.productIds": [ "int" ], "properties.products": [ { "distance": "string", "hasContactlessBadge": "string", "hasOmiBadge": "string", "hasOmibadgeBadge": "string", "id": "string", "inNetwork": "string", "isTopYielder": "string", "name": "string", "position": "string", "rank": "string", "reviewAverage": "string", "reviewCount": "string", "unitCount": "string", "units": [ { "id": "string", "maxBookingDate": "string", "priceValue": "string", "promotion": "string", "sizeText": "string", "squareFootage": "string", "unitTypeText": "string" } ] } ], "properties.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: 821
- schema_scan_id: 140187459
- updated: 2025-04-08 00:08:07
-
Version 1093147
- created: 2024-11-20 18:32:17
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_productlistviewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_productlistviewed`\n(\n`event`STRING,`projectId`STRING,`channel`STRING,`sentAt`STRING,`messageId`STRING,`version`STRING,`type`STRING,`context`struct<`userAgent`:STRING,`campaign`:struct<`c`:STRING,`name`:STRING,`so`:STRING,`utm_content`:STRING,`id`:STRING,`utm_campaign`:STRING,`utm_source`:STRING,`content`:STRING,`utm_medium`:STRING,`medium`:STRING,`source`:STRING,`conten`:STRING,`term`:STRING>,`page`:struct<`referrer`:STRING,`path`:STRING,`title`:STRING,`search`:STRING,`url`:STRING>,`userAgentData`:struct<`mobile`:STRING,`brands`:array,`site_id`:STRING>,`anonymousId`STRING,`originalTimestamp`STRING,`receivedAt`STRING,`timestamp`STRING,`userId`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-reactfoot-prod/separated_dt/Product List Viewed'\n", "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_productlistviewed" ] - hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed
- id: 1093147
- processed: 1
- raw_data:
{ "__segment_internal": {}, "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c55a4597f7a100011813be", "59c13c7c1386430001b3c90e" ], "unbundled": [] }, "_origin": "2024-11-21T00:31:49Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1732060800000/1732149090997.events-archiver-480-26..d7bda1bf-773e-4500-9479-7a6424e49c54.gz|analytics-segment-separator-prod:$LATEST", "anonymousId": "2fa31e4b-c8d7-43f3-9df7-1cc1ebb2033a", "channel": "client", "context": { "campaign": { "content": "Self Storage Interest", "id": "120212206740170476", "medium": "paid", "name": "SF Facebook|Storage Interest Audience", "source": "facebook", "term": "120212206740160476" }, "ip": "2601:40f:4500:5560:2422:b301:779d:bf9e", "library": { "name": "analytics.js", "version": "next-1.76.0" }, "locale": "en-US", "page": { "path": "/Westland-MI-self-storage.html", "referrer": "https://www.bing.com/", "search": "?irgwc=1&tsid=impact&utm_source=impact&utm_medium=affiliate&utm_campaign=390418&click_id=Vu4yZz0m7xyNUwpRysQveTkDUkCQh-1dw2PCxA0&utm_content=Online%20Tracking%20Link_ONLINE_TRACKING_LINK&ad_id=483123&campaign_id=8436&ad_size=&partner_name=Wildfire%20Systems", "title": "15 Cheap Self-Storage Units in Westland, MI (From $19)", "url": "https://www.sparefoot.com/Westland-MI-self-storage.html?irgwc=1&tsid=impact&utm_source=impact&utm_medium=affiliate&utm_campaign=390418&click_id=Vu4yZz0m7xyNUwpRysQveTkDUkCQh-1dw2PCxA0&utm_content=Online%20Tracking%20Link_ONLINE_TRACKING_LINK&ad_id=483123&campaign_id=8436&ad_size=&partner_name=Wildfire%20Systems" }, "timezone": "America/New_York", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36 Edg/131.0.0.0", "userAgentData": { "brands": [ { "brand": "Microsoft Edge", "version": "131" }, { "brand": "Chromium", "version": "131" }, { "brand": "Not_A Brand", "version": "24" } ], "mobile": false, "platform": "Windows" } }, "event": "Product List Viewed", "integrations": {}, "messageId": "ajs-next-1732145506343-c8d793f3-5df7-4cc1-abb2-033a6645eec7", "originalTimestamp": "2024-11-20T23:31:46.343Z", "projectId": "a0wkEvFBBK", "properties": { "Hit Timestamp": 1732145505427, "category": "Westland, MI-cityLandingPage", "env": "production", "isReact": true, "list_id": "search results: Westland, MI", "page": 1, "productIds": [ 235486, 223498, 223915, 214112, 200997, 201630, 202012, 156567, 226550, 229029, 231415, 215047, 231650, 206264, 215073 ], "products": [ { "distance": 1.7, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 223018, "inNetwork": true, "isTopYielder": false, "name": "Stor-N-Lock Self Storage", "position": 12, "rank": 12, "reviewAverage": 0, "reviewCount": 0, "unitCount": 3, "units": [ { "id": 26541327, "maxBookingDate": "2024-12-11T17:20:27.000Z", "priceValue": 43, "promotion": "50% Off First 3 Months", "sizeText": "4' x 4'", "squareFootage": 16, "unitTypeText": "unit" } ] } ], "searchTerm": "Westland, MI", "search_id": "1c53673e715e468282.19736411", "site_id": -1, "value": 16 }, "receivedAt": "2024-11-20T23:31:46.397Z", "sentAt": "2024-11-20T23:31:46.376Z", "timestamp": "2024-11-20T23:31:46.364Z", "type": "track", "userId": "043ab5030db576230fa513b59e2d90c3", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.amp.id": "string", "context.campaign.c": "string", "context.campaign.conten": "string", "context.campaign.content": "string", "context.campaign.id": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.so": "string", "context.campaign.source": "string", "context.campaign.term": "string", "context.campaign.utm_campaign": "string", "context.campaign.utm_content": "string", "context.campaign.utm_medium": "string", "context.campaign.utm_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.timezone": "string", "context.userAgent": "string", "context.userAgentData.brands": [ { "brand": "string", "version": "string" } ], "context.userAgentData.mobile": "string", "context.userAgentData.platform": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.isReact": "string", "properties.label": "string", "properties.list_id": "string", "properties.page": "string", "properties.productIds": [ "int" ], "properties.products": [ { "distance": "string", "hasContactlessBadge": "string", "hasOmiBadge": "string", "hasOmibadgeBadge": "string", "id": "string", "inNetwork": "string", "isTopYielder": "string", "name": "string", "position": "string", "rank": "string", "reviewAverage": "string", "reviewCount": "string", "unitCount": "string", "units": [ { "id": "string", "maxBookingDate": "string", "priceValue": "string", "promotion": "string", "sizeText": "string", "squareFootage": "string", "unitTypeText": "string" } ] } ], "properties.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: 821
- schema_scan_id: 132038310
- updated: 2024-11-20 18:41:30
-
Version 962536
- created: 2024-07-30 16:29:35
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_productlistviewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_productlistviewed`\n(\n`version`STRING,`userId`STRING,`sentAt`STRING,`type`STRING,`_origin`STRING,`channel`STRING,`timestamp`STRING,`receivedAt`STRING,`context`struct<`amp`:struct<`id`:STRING>,`userAgentData`:struct<`brands`:array,`isReact`:STRING,`Hit_Timestamp`:STRING,`category`:STRING,`value`:STRING,`label`:STRING,`page`:STRING,`searchTerm`:STRING,`search_id`:STRING>,`event`STRING,`anonymousId`STRING,`originalTimestamp`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-reactfoot-prod/separated_dt/Product List Viewed'\n", "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_productlistviewed" ] - hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed
- id: 962536
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c55a4597f7a100011813be", "59c13c7c1386430001b3c90e" ], "unbundled": [] }, "_origin": "2024-07-30T21:29:21Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1722297600000/1722374934298.events-archiver-480-50..5c138f08-025d-4f5e-89d4-9724495c556c.gz|analytics-segment-separator-prod:$LATEST", "anonymousId": "cdd6838d-49f1-426e-a147-4030becda53f", "channel": "client", "context": { "campaign": { "content": "", "medium": "paidsearch", "name": "pro_national_nogeo_noproduct_dynamic", "source": "bing", "term": "MO-self-storage" }, "ip": "47.213.153.175", "library": { "name": "analytics.js", "version": "next-1.72.1" }, "locale": "en-US", "page": { "path": "/Ozark-MO-self-storage.html", "referrer": "https://www.bing.com/", "search": "?tsid=bing-ppc&cid=pro_national_nogeo_noproduct_dynamic&utm_source=bing&utm_medium=paidsearch&utm_campaign=pro_national_nogeo_noproduct_dynamic&utm_content=&ploc=85553&iloc=55240&mkwid=pXjVO2Gf|pcrid|77309492705824|pkw|MO-self-storage|pmt|bb|pdv|c|pgrid|1236950728126187|ptaid|dat-2329109225093945:loc-190&pgrid=1236950728126187&ptaid=dat-2329109225093945:loc-190&msclkid=29187be18ffc1316a83e1d48c2b3b858&utm_term=MO-self-storage", "title": "15 Cheap Self-Storage Units in Ozark, MO (From $19)", "url": "https://www.sparefoot.com/Ozark-MO-self-storage.html?tsid=bing-ppc&cid=pro_national_nogeo_noproduct_dynamic&utm_source=bing&utm_medium=paidsearch&utm_campaign=pro_national_nogeo_noproduct_dynamic&utm_content=&ploc=85553&iloc=55240&mkwid=pXjVO2Gf|pcrid|77309492705824|pkw|MO-self-storage|pmt|bb|pdv|c|pgrid|1236950728126187|ptaid|dat-2329109225093945:loc-190&pgrid=1236950728126187&ptaid=dat-2329109225093945:loc-190&msclkid=29187be18ffc1316a83e1d48c2b3b858&utm_term=MO-self-storage" }, "timezone": "America/Chicago", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36 Edg/127.0.0.0", "userAgentData": { "brands": [ { "brand": "Chromium", "version": "127" } ], "mobile": false, "platform": "Windows" } }, "event": "Product List Viewed", "integrations": {}, "messageId": "ajs-next-1722371442470-49f1526e-2147-4030-becd-a53f0f4bdd10", "originalTimestamp": "2024-07-30T20:30:42.470Z", "projectId": "a0wkEvFBBK", "properties": { "Hit Timestamp": 1722371441409, "category": "Ozark, MO-cityLandingPage", "env": "production", "isReact": true, "list_id": "search results: Ozark, MO", "page": 1, "productIds": [ 221864, 213700, 205804, 221864, 236694, 63546, 105290, 228405, 221860, 201583, 221843, 218929, 228022, 221862, 228905, 219245 ], "products": [ { "distance": 15, "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 234407, "inNetwork": true, "isTopYielder": false, "name": "StorageMart - N Glenstone Ave", "position": 6, "rank": 6, "reviewAverage": 4.688, "reviewCount": 8, "unitCount": 1, "units": [ { "id": 31182737, "maxBookingDate": "2024-08-05T13:15:44.000Z", "priceValue": 97, "promotion": "", "sizeText": "10' x 9'", "squareFootage": 90, "unitTypeText": "unit" } ] } ], "searchTerm": "Ozark, MO", "search_id": "3c9966a94d6eeb2ac7.49129484", "site_id": -1, "value": 16 }, "receivedAt": "2024-07-30T20:30:42.789Z", "sentAt": "2024-07-30T20:30:42.506Z", "timestamp": "2024-07-30T20:30:42.753Z", "type": "track", "userId": "612e0f93f4baafd45a5f949113978079", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.amp.id": "string", "context.campaign.c": "string", "context.campaign.conten": "string", "context.campaign.content": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.so": "string", "context.campaign.source": "string", "context.campaign.term": "string", "context.campaign.utm_campaign": "string", "context.campaign.utm_content": "string", "context.campaign.utm_medium": "string", "context.campaign.utm_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.timezone": "string", "context.userAgent": "string", "context.userAgentData.brands": [ { "brand": "string", "version": "string" } ], "context.userAgentData.mobile": "string", "context.userAgentData.platform": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.isReact": "string", "properties.label": "string", "properties.list_id": "string", "properties.page": "string", "properties.productIds": [ "int" ], "properties.products": [ { "distance": "string", "hasContactlessBadge": "string", "hasOmiBadge": "string", "hasOmibadgeBadge": "string", "id": "string", "inNetwork": "string", "isTopYielder": "string", "name": "string", "position": "string", "rank": "string", "reviewAverage": "string", "reviewCount": "string", "unitCount": "string", "units": [ { "id": "string", "maxBookingDate": "string", "priceValue": "string", "promotion": "string", "sizeText": "string", "squareFootage": "string", "unitTypeText": "string" } ] } ], "properties.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: 821
- schema_scan_id: 124127691
- updated: 2024-07-30 16:30:32
Schema Scans: 3
Last at 2025-04-07 23:58:48
-
Scan 140187459
- duration: 0:05:11.364715
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 2753, "partitions_applied": false, "success": true } - id: 140187459
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-04-08/", "name": "dt", "type": "string", "value": "2025-04-08" }, "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=2025-04-08/1744088207531.events-archiver-480-30..a73d65bb-2f1f-4221-8a00-a9a6f9b99289.json.gz" }, "schema": { "name": "sfdl_prod_segment.reactfoot_ProductListViewed", "type": "segment" } } - running: False
- schema_name_id: 821
- start_time: 2025-04-07 23:58:48
- success: True
- trace_id: 2122463796147748621
-
Scan 132038310
- duration: 0:00:59.540805
- exit_message:
{ "exception": "Query failed: FAILED: SemanticException [Error 10001]: Table not found sfdl_prod_segment.reactfoot_productlistviewed `SHOW PARTITIONS `sfdl_prod_segment.reactfoot_productlistviewed``\nTraceback (most recent call last):\n File \"/schema_manager/schema_generator/schema_scanner.py\", line 102, in scan\n response = service.run()\n ^^^^^^^^^^^^^\n File \"/schema_manager/schema_generator/process_hive_table.py\", line 105, in run\n response['ingested_partitions'] = pi.run() # *total* current number of partitions in the table\n ^^^^^^^^\n File \"/schema_manager/schema_manager/service/partition_ingester.py\", line 17, in run\n result = self.runner.run_single_query(ddl, timeout=ATHENA_TIMEOUT)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File \"/usr/local/lib/python3.12/site-packages/stodl/athena_runner/runner.py\", line 51, in run_single_query\n return self._run_single_query(query, timeout, database)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File \"/usr/local/lib/python3.12/site-packages/stodl/athena_runner/runner.py\", line 120, in _run_single_query\n raise e\n File \"/usr/local/lib/python3.12/site-packages/stodl/athena_runner/runner.py\", line 103, in _run_single_query\n raise AthenaRunnerQueryException('Query failed: {} `{}`'.format(info['QueryExecution']['Status']['StateChangeReason'], query))\nstodl.athena_runner.exceptions.AthenaRunnerQueryException: Query failed: FAILED: SemanticException [Error 10001]: Table not found sfdl_prod_segment.reactfoot_productlistviewed `SHOW PARTITIONS `sfdl_prod_segment.reactfoot_productlistviewed``\n: Expecting value: line 1 column 1 (char 0)" } - id: 132038310
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2024-11-20/", "name": "dt", "type": "string", "value": "2024-11-20" }, "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=2024-11-20/1732149090997.events-archiver-480-26..d7bda1bf-773e-4500-9479-7a6424e49c54.json.gz" }, "schema": { "name": "sfdl_prod_segment.reactfoot_ProductListViewed", "type": "segment" } } - running: False
- schema_name_id: 821
- start_time: 2024-11-20 18:32:15
- success: False
- trace_id: 4806220435180848354
-
Scan 124127691
- duration: 0:00:15.959020
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 0, "partitions_applied": false, "success": true } - id: 124127691
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2024-07-30/", "name": "dt", "type": "string", "value": "2024-07-30" }, "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=2024-07-30/1722374934298.events-archiver-480-50..5c138f08-025d-4f5e-89d4-9724495c556c.json.gz" }, "schema": { "name": "sfdl_prod_segment.reactfoot_ProductListViewed", "type": "segment" } } - running: False
- schema_name_id: 821
- start_time: 2024-07-30 16:29:33
- success: True
- trace_id: 5979124752813533163
- count: 70
- ddl:
[ "ALTER TABLE\n `sfdl_prod_segment.reactfoot_productlistviewed`\nADD\n\n\n PARTITION (dt='2025-10-16') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-10-16/'\n PARTITION (dt='2025-10-17') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-10-17/'\n PARTITION (dt='2025-10-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-10-20/'\n PARTITION (dt='2025-10-24') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-10-24/'\n PARTITION (dt='2025-10-26') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-10-26/'\n PARTITION (dt='2025-10-27') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-10-27/'\n PARTITION (dt='2025-10-30') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-10-30/'\n PARTITION (dt='2025-11-03') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-03/'\n PARTITION (dt='2025-11-06') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-06/'\n PARTITION (dt='2025-11-08') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-08/'\n PARTITION (dt='2025-11-09') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-09/'\n PARTITION (dt='2025-11-10') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-10/'\n PARTITION (dt='2025-11-13') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-13/'\n PARTITION (dt='2025-11-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-15/'\n PARTITION (dt='2025-11-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-20/'\n PARTITION (dt='2025-11-22') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-22/'\n PARTITION (dt='2025-11-25') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-25/'\n PARTITION (dt='2025-11-26') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-26/'\n PARTITION (dt='2025-12-02') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-02/'\n PARTITION (dt='2025-12-04') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-04/'\n PARTITION (dt='2025-12-05') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-05/'\n PARTITION (dt='2025-12-07') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-07/'\n PARTITION (dt='2025-12-08') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-08/'\n PARTITION (dt='2025-12-09') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-09/'\n PARTITION (dt='2025-12-11') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-11/'\n PARTITION (dt='2025-12-12') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-12/'\n PARTITION (dt='2025-12-13') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-13/'\n PARTITION (dt='2025-12-14') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-14/'\n PARTITION (dt='2025-12-16') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-16/'\n PARTITION (dt='2025-12-17') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-17/'\n PARTITION (dt='2025-12-19') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-19/'\n PARTITION (dt='2025-12-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-20/'\n PARTITION (dt='2025-12-22') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-22/'\n PARTITION (dt='2025-12-26') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-26/'\n PARTITION (dt='2025-12-29') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-29/'\n PARTITION (dt='2025-12-31') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-31/'\n PARTITION (dt='2026-01-05') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-05/'\n PARTITION (dt='2026-01-06') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-06/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-07/'\n PARTITION (dt='2026-01-08') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-08/'\n PARTITION (dt='2026-01-11') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-11/'\n PARTITION (dt='2026-01-14') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-14/'\n PARTITION (dt='2026-01-16') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-16/'\n PARTITION (dt='2026-01-18') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-18/'\n PARTITION (dt='2026-01-21') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-21/'\n PARTITION (dt='2026-01-25') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-25/'\n PARTITION (dt='2026-01-28') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-28/'\n PARTITION (dt='2026-01-29') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-29/'\n PARTITION (dt='2026-01-30') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-30/'\n PARTITION (dt='2026-02-01') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-01/'\n PARTITION (dt='2026-02-02') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-02/'\n PARTITION (dt='2026-02-05') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-05/'\n PARTITION (dt='2026-02-06') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-06/'\n PARTITION (dt='2026-02-07') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-07/'\n PARTITION (dt='2026-02-10') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-10/'\n PARTITION (dt='2026-02-16') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-16/'\n PARTITION (dt='2026-02-17') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-17/'\n PARTITION (dt='2026-02-18') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-18/'\n PARTITION (dt='2026-02-19') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-19/'\n PARTITION (dt='2026-02-22') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-22/'\n PARTITION (dt='2026-03-02') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-02/'\n PARTITION (dt='2026-03-07') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-07/'\n PARTITION (dt='2026-03-09') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-09/'\n PARTITION (dt='2026-03-11') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-11/'\n PARTITION (dt='2026-03-13') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-13/'\n PARTITION (dt='2026-03-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-15/'\n PARTITION (dt='2026-03-25') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-25/'\n PARTITION (dt='2026-03-30') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-30/'\n PARTITION (dt='2026-04-02') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-04-02/'\n PARTITION (dt='2026-04-07') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-04-07/'\n;" ] - name: dt
- state:
[ { "info": { "id": 1566305, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-10-16/", "name": "dt", "value": "2025-10-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-16 06:51:35", "last_data": "2025-10-16 06:51:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1595800, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-10-17/", "name": "dt", "value": "2025-10-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-17 12:54:14", "last_data": "2025-10-17 12:57:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1596718, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-10-20/", "name": "dt", "value": "2025-10-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-19 21:54:32", "last_data": "2025-10-20 10:59:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1597824, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-10-24/", "name": "dt", "value": "2025-10-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-24 12:21:34", "last_data": "2025-10-24 16:43:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1598290, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-10-26/", "name": "dt", "value": "2025-10-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-26 11:06:06", "last_data": "2025-10-26 11:06:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1598545, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-10-27/", "name": "dt", "value": "2025-10-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-27 19:44:15", "last_data": "2025-10-27 19:47:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1599087, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-10-30/", "name": "dt", "value": "2025-10-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-29 21:56:35", "last_data": "2025-10-29 21:58:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1600268, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-03/", "name": "dt", "value": "2025-11-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-03 05:54:20", "last_data": "2025-11-03 18:05:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1601090, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-06/", "name": "dt", "value": "2025-11-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-06 15:51:35", "last_data": "2025-11-06 15:53:31" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1601587, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-08/", "name": "dt", "value": "2025-11-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-08 10:51:34", "last_data": "2025-11-08 10:51:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1601827, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-09/", "name": "dt", "value": "2025-11-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-09 17:40:43", "last_data": "2025-11-09 17:40:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1601884, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-10/", "name": "dt", "value": "2025-11-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-09 19:02:32", "last_data": "2025-11-09 19:02:32" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1602635, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-13/", "name": "dt", "value": "2025-11-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-13 00:06:56", "last_data": "2025-11-13 00:06:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1603272, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-15/", "name": "dt", "value": "2025-11-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-15 13:48:16", "last_data": "2025-11-15 13:54:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1606496, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-20/", "name": "dt", "value": "2025-11-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-19 19:57:30", "last_data": "2025-11-20 17:14:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1607552, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-22/", "name": "dt", "value": "2025-11-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-22 06:45:44", "last_data": "2025-11-22 16:48:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1608270, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-25/", "name": "dt", "value": "2025-11-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-25 07:09:11", "last_data": "2025-11-25 07:09:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1608597, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-26/", "name": "dt", "value": "2025-11-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-26 11:58:49", "last_data": "2025-11-26 11:58:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1609858, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-02/", "name": "dt", "value": "2025-12-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-01 23:54:56", "last_data": "2025-12-02 16:19:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1610330, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-04/", "name": "dt", "value": "2025-12-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-03 20:11:18", "last_data": "2025-12-04 12:49:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1610715, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-05/", "name": "dt", "value": "2025-12-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-05 15:46:16", "last_data": "2025-12-05 15:54:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1611393, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-07/", "name": "dt", "value": "2025-12-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-07 09:18:50", "last_data": "2025-12-07 09:18:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1611542, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-08/", "name": "dt", "value": "2025-12-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-07 21:05:35", "last_data": "2025-12-07 21:05:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1611900, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-09/", "name": "dt", "value": "2025-12-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-09 11:43:22", "last_data": "2025-12-09 16:09:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1612669, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-11/", "name": "dt", "value": "2025-12-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-11 11:06:16", "last_data": "2025-12-11 15:11:25" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1612802, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-12/", "name": "dt", "value": "2025-12-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-12 06:53:56", "last_data": "2025-12-12 15:02:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1613003, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-13/", "name": "dt", "value": "2025-12-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-12 19:12:15", "last_data": "2025-12-12 19:12:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1613266, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-14/", "name": "dt", "value": "2025-12-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-13 19:03:03", "last_data": "2025-12-13 19:03:03" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1616465, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-16/", "name": "dt", "value": "2025-12-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-16 17:07:09", "last_data": "2025-12-16 17:07:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1616567, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-17/", "name": "dt", "value": "2025-12-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-17 03:55:45", "last_data": "2025-12-17 03:55:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1616968, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-19/", "name": "dt", "value": "2025-12-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-18 19:06:43", "last_data": "2025-12-18 19:06:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1617346, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-20/", "name": "dt", "value": "2025-12-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-20 12:59:10", "last_data": "2025-12-20 17:03:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1617705, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-22/", "name": "dt", "value": "2025-12-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-22 07:03:33", "last_data": "2025-12-22 17:49:25" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1618665, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-26/", "name": "dt", "value": "2025-12-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-26 10:57:02", "last_data": "2025-12-26 10:57:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1619197, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-29/", "name": "dt", "value": "2025-12-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-28 20:02:14", "last_data": "2025-12-29 15:02:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1619677, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-31/", "name": "dt", "value": "2025-12-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-31 05:59:35", "last_data": "2025-12-31 07:57:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1620737, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-05/", "name": "dt", "value": "2026-01-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-04 19:58:26", "last_data": "2026-01-04 19:58:26" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1621101, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-06/", "name": "dt", "value": "2026-01-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-06 16:47:45", "last_data": "2026-01-06 16:47:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1621180, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-07/", "name": "dt", "value": "2026-01-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-06 20:04:44", "last_data": "2026-01-06 20:04:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1621549, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-08/", "name": "dt", "value": "2026-01-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-08 13:03:17", "last_data": "2026-01-08 13:47:26" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1622070, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-11/", "name": "dt", "value": "2026-01-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-10 20:54:52", "last_data": "2026-01-10 20:54:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1622892, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-14/", "name": "dt", "value": "2026-01-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-14 06:31:08", "last_data": "2026-01-14 12:57:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1623351, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-16/", "name": "dt", "value": "2026-01-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-16 01:57:53", "last_data": "2026-01-16 01:57:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1626092, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-18/", "name": "dt", "value": "2026-01-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-17 23:58:18", "last_data": "2026-01-17 23:58:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1626904, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-21/", "name": "dt", "value": "2026-01-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-21 10:55:56", "last_data": "2026-01-21 11:00:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1627770, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-25/", "name": "dt", "value": "2026-01-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-25 13:57:27", "last_data": "2026-01-25 14:01:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1628281, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-28/", "name": "dt", "value": "2026-01-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-27 19:56:53", "last_data": "2026-01-27 19:56:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1628641, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-29/", "name": "dt", "value": "2026-01-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-29 13:58:59", "last_data": "2026-01-29 13:58:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1628727, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-30/", "name": "dt", "value": "2026-01-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-29 19:55:34", "last_data": "2026-01-29 20:02:24" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1629308, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-01/", "name": "dt", "value": "2026-02-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-01 12:01:21", "last_data": "2026-02-01 12:01:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1629526, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-02/", "name": "dt", "value": "2026-02-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-02 14:51:48", "last_data": "2026-02-02 14:51:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1630250, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-05/", "name": "dt", "value": "2026-02-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-05 10:51:04", "last_data": "2026-02-05 10:51:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1630473, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-06/", "name": "dt", "value": "2026-02-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-06 14:53:23", "last_data": "2026-02-06 14:53:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1630692, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-07/", "name": "dt", "value": "2026-02-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-07 16:33:55", "last_data": "2026-02-07 16:33:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1631344, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-10/", "name": "dt", "value": "2026-02-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-10 11:02:52", "last_data": "2026-02-10 11:56:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1632751, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-16/", "name": "dt", "value": "2026-02-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-16 00:52:04", "last_data": "2026-02-16 00:52:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1635184, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-17/", "name": "dt", "value": "2026-02-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-17 10:58:46", "last_data": "2026-02-17 10:58:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1635408, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-18/", "name": "dt", "value": "2026-02-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-18 14:56:53", "last_data": "2026-02-18 14:56:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1635487, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-19/", "name": "dt", "value": "2026-02-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-19 00:57:18", "last_data": "2026-02-19 01:00:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1636121, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-22/", "name": "dt", "value": "2026-02-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-21 21:55:56", "last_data": "2026-02-22 10:44:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1641686, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-02/", "name": "dt", "value": "2026-03-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-02 14:52:41", "last_data": "2026-03-02 14:52:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1642738, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-07/", "name": "dt", "value": "2026-03-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-07 09:00:06", "last_data": "2026-03-07 09:00:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1643736, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-09/", "name": "dt", "value": "2026-03-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-09 04:59:46", "last_data": "2026-03-09 18:45:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1645148, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-11/", "name": "dt", "value": "2026-03-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-11 19:00:15", "last_data": "2026-03-11 19:03:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1645554, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-13/", "name": "dt", "value": "2026-03-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-13 11:01:36", "last_data": "2026-03-13 11:01:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1645995, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-15/", "name": "dt", "value": "2026-03-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-15 09:55:58", "last_data": "2026-03-15 09:55:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1649958, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-25/", "name": "dt", "value": "2026-03-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-24 22:02:16", "last_data": "2026-03-24 22:02:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1651709, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-30/", "name": "dt", "value": "2026-03-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-30 14:57:37", "last_data": "2026-03-30 14:57:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1652224, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-04-02/", "name": "dt", "value": "2026-04-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-01 20:01:04", "last_data": "2026-04-01 20:01:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1656903, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-04-07/", "name": "dt", "value": "2026-04-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-07 17:59:02", "last_data": "2026-04-07 17:59:02" }, "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.amp.id": "string", "context.campaign.c": "string", "context.campaign.conten": "string", "context.campaign.content": "string", "context.campaign.id": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.so": "string", "context.campaign.source": "string", "context.campaign.term": "string", "context.campaign.tm_source": "string", "context.campaign.utm_campaign": "string", "context.campaign.utm_content": "string", "context.campaign.utm_medium": "string", "context.campaign.utm_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.timezone": "string", "context.userAgent": "string", "context.userAgentData.brands": [ { "brand": "string", "version": "string" } ], "context.userAgentData.mobile": "string", "context.userAgentData.platform": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.isReact": "string", "properties.label": "string", "properties.list_id": "string", "properties.page": "string", "properties.productIds": [ "int" ], "properties.products": [ { "distance": "string", "hasContactlessBadge": "string", "hasOmiBadge": "string", "hasOmibadgeBadge": "string", "id": "string", "inNetwork": "string", "isTopYielder": "string", "name": "string", "position": "string", "rank": "string", "reviewAverage": "string", "reviewCount": "string", "unitCount": "string", "units": [ { "id": "string", "maxBookingDate": "string", "priceValue": "string", "promotion": "string", "sizeText": "string", "squareFootage": "string", "unitTypeText": "string" } ] } ], "properties.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: 2025-04-07 23:58:50
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_productlistviewed`\n(\n`projectId`STRING,`timestamp`STRING,`type`STRING,`context`struct<`amp`:struct<`id`:STRING>,`userAgentData`:struct<`brands`:array,`search_id`:STRING,`list_id`:STRING,`isReact`:STRING,`env`:STRING>,`channel`STRING,`anonymousId`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_productlistviewed`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_productlistviewed" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2021-02-11 16:04:02",
"disabled": false,
"format": "raw",
"id": 821,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_prod_segment",
"table": "reactfoot_productlistviewed"
},
"type": "segment"
},
"partition": {
"count": 70,
"ddl": [
"ALTER TABLE\n `sfdl_prod_segment.reactfoot_productlistviewed`\nADD\n\n\n PARTITION (dt='2025-10-16') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-10-16/'\n PARTITION (dt='2025-10-17') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-10-17/'\n PARTITION (dt='2025-10-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-10-20/'\n PARTITION (dt='2025-10-24') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-10-24/'\n PARTITION (dt='2025-10-26') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-10-26/'\n PARTITION (dt='2025-10-27') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-10-27/'\n PARTITION (dt='2025-10-30') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-10-30/'\n PARTITION (dt='2025-11-03') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-03/'\n PARTITION (dt='2025-11-06') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-06/'\n PARTITION (dt='2025-11-08') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-08/'\n PARTITION (dt='2025-11-09') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-09/'\n PARTITION (dt='2025-11-10') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-10/'\n PARTITION (dt='2025-11-13') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-13/'\n PARTITION (dt='2025-11-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-15/'\n PARTITION (dt='2025-11-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-20/'\n PARTITION (dt='2025-11-22') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-22/'\n PARTITION (dt='2025-11-25') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-25/'\n PARTITION (dt='2025-11-26') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-26/'\n PARTITION (dt='2025-12-02') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-02/'\n PARTITION (dt='2025-12-04') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-04/'\n PARTITION (dt='2025-12-05') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-05/'\n PARTITION (dt='2025-12-07') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-07/'\n PARTITION (dt='2025-12-08') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-08/'\n PARTITION (dt='2025-12-09') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-09/'\n PARTITION (dt='2025-12-11') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-11/'\n PARTITION (dt='2025-12-12') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-12/'\n PARTITION (dt='2025-12-13') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-13/'\n PARTITION (dt='2025-12-14') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-14/'\n PARTITION (dt='2025-12-16') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-16/'\n PARTITION (dt='2025-12-17') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-17/'\n PARTITION (dt='2025-12-19') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-19/'\n PARTITION (dt='2025-12-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-20/'\n PARTITION (dt='2025-12-22') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-22/'\n PARTITION (dt='2025-12-26') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-26/'\n PARTITION (dt='2025-12-29') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-29/'\n PARTITION (dt='2025-12-31') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-31/'\n PARTITION (dt='2026-01-05') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-05/'\n PARTITION (dt='2026-01-06') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-06/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-07/'\n PARTITION (dt='2026-01-08') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-08/'\n PARTITION (dt='2026-01-11') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-11/'\n PARTITION (dt='2026-01-14') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-14/'\n PARTITION (dt='2026-01-16') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-16/'\n PARTITION (dt='2026-01-18') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-18/'\n PARTITION (dt='2026-01-21') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-21/'\n PARTITION (dt='2026-01-25') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-25/'\n PARTITION (dt='2026-01-28') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-28/'\n PARTITION (dt='2026-01-29') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-29/'\n PARTITION (dt='2026-01-30') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-30/'\n PARTITION (dt='2026-02-01') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-01/'\n PARTITION (dt='2026-02-02') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-02/'\n PARTITION (dt='2026-02-05') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-05/'\n PARTITION (dt='2026-02-06') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-06/'\n PARTITION (dt='2026-02-07') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-07/'\n PARTITION (dt='2026-02-10') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-10/'\n PARTITION (dt='2026-02-16') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-16/'\n PARTITION (dt='2026-02-17') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-17/'\n PARTITION (dt='2026-02-18') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-18/'\n PARTITION (dt='2026-02-19') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-19/'\n PARTITION (dt='2026-02-22') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-22/'\n PARTITION (dt='2026-03-02') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-02/'\n PARTITION (dt='2026-03-07') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-07/'\n PARTITION (dt='2026-03-09') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-09/'\n PARTITION (dt='2026-03-11') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-11/'\n PARTITION (dt='2026-03-13') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-13/'\n PARTITION (dt='2026-03-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-15/'\n PARTITION (dt='2026-03-25') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-25/'\n PARTITION (dt='2026-03-30') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-30/'\n PARTITION (dt='2026-04-02') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-04-02/'\n PARTITION (dt='2026-04-07') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-04-07/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 1566305,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-10-16/",
"name": "dt",
"value": "2025-10-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-16 06:51:35",
"last_data": "2025-10-16 06:51:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1595800,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-10-17/",
"name": "dt",
"value": "2025-10-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-17 12:54:14",
"last_data": "2025-10-17 12:57:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1596718,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-10-20/",
"name": "dt",
"value": "2025-10-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-19 21:54:32",
"last_data": "2025-10-20 10:59:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1597824,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-10-24/",
"name": "dt",
"value": "2025-10-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-24 12:21:34",
"last_data": "2025-10-24 16:43:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1598290,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-10-26/",
"name": "dt",
"value": "2025-10-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-26 11:06:06",
"last_data": "2025-10-26 11:06:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1598545,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-10-27/",
"name": "dt",
"value": "2025-10-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-27 19:44:15",
"last_data": "2025-10-27 19:47:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1599087,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-10-30/",
"name": "dt",
"value": "2025-10-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-29 21:56:35",
"last_data": "2025-10-29 21:58:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1600268,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-03/",
"name": "dt",
"value": "2025-11-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-03 05:54:20",
"last_data": "2025-11-03 18:05:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1601090,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-06/",
"name": "dt",
"value": "2025-11-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-06 15:51:35",
"last_data": "2025-11-06 15:53:31"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1601587,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-08/",
"name": "dt",
"value": "2025-11-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-08 10:51:34",
"last_data": "2025-11-08 10:51:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1601827,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-09/",
"name": "dt",
"value": "2025-11-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-09 17:40:43",
"last_data": "2025-11-09 17:40:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1601884,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-10/",
"name": "dt",
"value": "2025-11-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-09 19:02:32",
"last_data": "2025-11-09 19:02:32"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1602635,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-13/",
"name": "dt",
"value": "2025-11-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-13 00:06:56",
"last_data": "2025-11-13 00:06:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1603272,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-15/",
"name": "dt",
"value": "2025-11-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-15 13:48:16",
"last_data": "2025-11-15 13:54:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1606496,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-20/",
"name": "dt",
"value": "2025-11-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-19 19:57:30",
"last_data": "2025-11-20 17:14:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1607552,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-22/",
"name": "dt",
"value": "2025-11-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-22 06:45:44",
"last_data": "2025-11-22 16:48:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1608270,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-25/",
"name": "dt",
"value": "2025-11-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-25 07:09:11",
"last_data": "2025-11-25 07:09:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1608597,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-11-26/",
"name": "dt",
"value": "2025-11-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-26 11:58:49",
"last_data": "2025-11-26 11:58:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1609858,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-02/",
"name": "dt",
"value": "2025-12-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-01 23:54:56",
"last_data": "2025-12-02 16:19:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1610330,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-04/",
"name": "dt",
"value": "2025-12-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-03 20:11:18",
"last_data": "2025-12-04 12:49:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1610715,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-05/",
"name": "dt",
"value": "2025-12-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-05 15:46:16",
"last_data": "2025-12-05 15:54:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1611393,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-07/",
"name": "dt",
"value": "2025-12-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-07 09:18:50",
"last_data": "2025-12-07 09:18:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1611542,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-08/",
"name": "dt",
"value": "2025-12-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-07 21:05:35",
"last_data": "2025-12-07 21:05:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1611900,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-09/",
"name": "dt",
"value": "2025-12-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-09 11:43:22",
"last_data": "2025-12-09 16:09:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1612669,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-11/",
"name": "dt",
"value": "2025-12-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-11 11:06:16",
"last_data": "2025-12-11 15:11:25"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1612802,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-12/",
"name": "dt",
"value": "2025-12-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-12 06:53:56",
"last_data": "2025-12-12 15:02:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1613003,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-13/",
"name": "dt",
"value": "2025-12-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-12 19:12:15",
"last_data": "2025-12-12 19:12:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1613266,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-14/",
"name": "dt",
"value": "2025-12-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-13 19:03:03",
"last_data": "2025-12-13 19:03:03"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1616465,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-16/",
"name": "dt",
"value": "2025-12-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-16 17:07:09",
"last_data": "2025-12-16 17:07:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1616567,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-17/",
"name": "dt",
"value": "2025-12-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-17 03:55:45",
"last_data": "2025-12-17 03:55:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1616968,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-19/",
"name": "dt",
"value": "2025-12-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-18 19:06:43",
"last_data": "2025-12-18 19:06:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1617346,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-20/",
"name": "dt",
"value": "2025-12-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-20 12:59:10",
"last_data": "2025-12-20 17:03:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1617705,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-22/",
"name": "dt",
"value": "2025-12-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-22 07:03:33",
"last_data": "2025-12-22 17:49:25"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1618665,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-26/",
"name": "dt",
"value": "2025-12-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-26 10:57:02",
"last_data": "2025-12-26 10:57:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1619197,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-29/",
"name": "dt",
"value": "2025-12-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-28 20:02:14",
"last_data": "2025-12-29 15:02:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1619677,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2025-12-31/",
"name": "dt",
"value": "2025-12-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-31 05:59:35",
"last_data": "2025-12-31 07:57:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1620737,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-05/",
"name": "dt",
"value": "2026-01-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-04 19:58:26",
"last_data": "2026-01-04 19:58:26"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1621101,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-06/",
"name": "dt",
"value": "2026-01-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-06 16:47:45",
"last_data": "2026-01-06 16:47:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1621180,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-07/",
"name": "dt",
"value": "2026-01-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-06 20:04:44",
"last_data": "2026-01-06 20:04:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1621549,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-08/",
"name": "dt",
"value": "2026-01-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-08 13:03:17",
"last_data": "2026-01-08 13:47:26"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1622070,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-11/",
"name": "dt",
"value": "2026-01-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-10 20:54:52",
"last_data": "2026-01-10 20:54:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1622892,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-14/",
"name": "dt",
"value": "2026-01-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-14 06:31:08",
"last_data": "2026-01-14 12:57:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1623351,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-16/",
"name": "dt",
"value": "2026-01-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-16 01:57:53",
"last_data": "2026-01-16 01:57:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1626092,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-18/",
"name": "dt",
"value": "2026-01-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-17 23:58:18",
"last_data": "2026-01-17 23:58:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1626904,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-21/",
"name": "dt",
"value": "2026-01-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-21 10:55:56",
"last_data": "2026-01-21 11:00:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1627770,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-25/",
"name": "dt",
"value": "2026-01-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-25 13:57:27",
"last_data": "2026-01-25 14:01:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1628281,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-28/",
"name": "dt",
"value": "2026-01-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-27 19:56:53",
"last_data": "2026-01-27 19:56:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1628641,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-29/",
"name": "dt",
"value": "2026-01-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-29 13:58:59",
"last_data": "2026-01-29 13:58:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1628727,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-01-30/",
"name": "dt",
"value": "2026-01-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-29 19:55:34",
"last_data": "2026-01-29 20:02:24"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1629308,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-01/",
"name": "dt",
"value": "2026-02-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-01 12:01:21",
"last_data": "2026-02-01 12:01:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1629526,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-02/",
"name": "dt",
"value": "2026-02-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-02 14:51:48",
"last_data": "2026-02-02 14:51:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1630250,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-05/",
"name": "dt",
"value": "2026-02-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-05 10:51:04",
"last_data": "2026-02-05 10:51:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1630473,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-06/",
"name": "dt",
"value": "2026-02-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-06 14:53:23",
"last_data": "2026-02-06 14:53:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1630692,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-07/",
"name": "dt",
"value": "2026-02-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-07 16:33:55",
"last_data": "2026-02-07 16:33:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1631344,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-10/",
"name": "dt",
"value": "2026-02-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-10 11:02:52",
"last_data": "2026-02-10 11:56:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1632751,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-16/",
"name": "dt",
"value": "2026-02-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-16 00:52:04",
"last_data": "2026-02-16 00:52:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1635184,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-17/",
"name": "dt",
"value": "2026-02-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-17 10:58:46",
"last_data": "2026-02-17 10:58:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1635408,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-18/",
"name": "dt",
"value": "2026-02-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-18 14:56:53",
"last_data": "2026-02-18 14:56:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1635487,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-19/",
"name": "dt",
"value": "2026-02-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-19 00:57:18",
"last_data": "2026-02-19 01:00:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1636121,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-02-22/",
"name": "dt",
"value": "2026-02-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-21 21:55:56",
"last_data": "2026-02-22 10:44:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1641686,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-02/",
"name": "dt",
"value": "2026-03-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-02 14:52:41",
"last_data": "2026-03-02 14:52:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1642738,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-07/",
"name": "dt",
"value": "2026-03-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-07 09:00:06",
"last_data": "2026-03-07 09:00:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1643736,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-09/",
"name": "dt",
"value": "2026-03-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-09 04:59:46",
"last_data": "2026-03-09 18:45:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1645148,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-11/",
"name": "dt",
"value": "2026-03-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-11 19:00:15",
"last_data": "2026-03-11 19:03:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1645554,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-13/",
"name": "dt",
"value": "2026-03-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-13 11:01:36",
"last_data": "2026-03-13 11:01:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1645995,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-15/",
"name": "dt",
"value": "2026-03-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-15 09:55:58",
"last_data": "2026-03-15 09:55:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1649958,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-25/",
"name": "dt",
"value": "2026-03-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-24 22:02:16",
"last_data": "2026-03-24 22:02:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1651709,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-03-30/",
"name": "dt",
"value": "2026-03-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-30 14:57:37",
"last_data": "2026-03-30 14:57:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1652224,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-04-02/",
"name": "dt",
"value": "2026-04-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-01 20:01:04",
"last_data": "2026-04-01 20:01:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1656903,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product List Viewed/dt=2026-04-07/",
"name": "dt",
"value": "2026-04-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-07 17:59:02",
"last_data": "2026-04-07 17:59:02"
},
"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.c": "string",
"context.campaign.conten": "string",
"context.campaign.content": "string",
"context.campaign.id": "string",
"context.campaign.medium": "string",
"context.campaign.name": "string",
"context.campaign.so": "string",
"context.campaign.source": "string",
"context.campaign.term": "string",
"context.campaign.tm_source": "string",
"context.campaign.utm_campaign": "string",
"context.campaign.utm_content": "string",
"context.campaign.utm_medium": "string",
"context.campaign.utm_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.timezone": "string",
"context.userAgent": "string",
"context.userAgentData.brands": [
{
"brand": "string",
"version": "string"
}
],
"context.userAgentData.mobile": "string",
"context.userAgentData.platform": "string",
"event": "string",
"messageId": "string",
"originalTimestamp": "string",
"projectId": "string",
"properties.Hit_Timestamp": "string",
"properties.category": "string",
"properties.env": "string",
"properties.isReact": "string",
"properties.label": "string",
"properties.list_id": "string",
"properties.page": "string",
"properties.productIds": [
"int"
],
"properties.products": [
{
"distance": "string",
"hasContactlessBadge": "string",
"hasOmiBadge": "string",
"hasOmibadgeBadge": "string",
"id": "string",
"inNetwork": "string",
"isTopYielder": "string",
"name": "string",
"position": "string",
"rank": "string",
"reviewAverage": "string",
"reviewCount": "string",
"unitCount": "string",
"units": [
{
"id": "string",
"maxBookingDate": "string",
"priceValue": "string",
"promotion": "string",
"sizeText": "string",
"squareFootage": "string",
"unitTypeText": "string"
}
]
}
],
"properties.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": "2025-04-07 23:58:50",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_productlistviewed`\n(\n`projectId`STRING,`timestamp`STRING,`type`STRING,`context`struct<`amp`:struct<`id`:STRING>,`userAgentData`:struct<`brands`:array>,`mobile`:STRING,`platform`:STRING>,`page`:struct<`path`:STRING,`search`:STRING,`url`:STRING,`title`:STRING,`referrer`:STRING>,`ip`:STRING,`userAgent`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`locale`:STRING,`timezone`:STRING,`campaign`:struct<`id`:STRING,`utm_campaign`:STRING,`tm_source`:STRING,`content`:STRING,`utm_content`:STRING,`medium`:STRING,`conten`:STRING,`term`:STRING,`source`:STRING,`utm_medium`:STRING,`so`:STRING,`utm_source`:STRING,`c`:STRING,`name`:STRING>>,`receivedAt`STRING,`version`STRING,`sentAt`STRING,`_origin`STRING,`messageId`STRING,`event`STRING,`userId`STRING,`originalTimestamp`STRING,`properties`struct<`products`:array>,`isTopYielder`:STRING>>,`label`:STRING,`category`:STRING,`page`:STRING,`Hit_Timestamp`:STRING,`searchTerm`:STRING,`value`:STRING,`site_id`:STRING,`productIds`:array,`search_id`:STRING,`list_id`:STRING,`isReact`:STRING,`env`:STRING>,`channel`STRING,`anonymousId`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_productlistviewed`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_productlistviewed"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}