Schema Info
Schema Name: sfdl_prod_segment.ssdc_conpageview
- created: 2021-02-11 16:29:59
- disabled: False
- format: raw
- id: 839
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_prod_segment", "table": "ssdc_conpageview" } - type: segment
Schema Versions: 3
-
Version 1266496
- created: 2025-04-15 08:58:19
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "DROP TABLE IF EXISTS `sfdl_prod_segment.ssdc_conpageview`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.ssdc_conpageview`\n(\n`integrations`struct<`Google_Analytics`:STRING,`All`:STRING>,`messageId`STRING,`type`STRING,`sentAt`STRING,`originalTimestamp`STRING,`timestamp`STRING,`_origin`STRING,`context`struct<`library`:struct<`version`:STRING,`name`:STRING>,`campaign`:struct<`mderreldium`:STRING,`cam`:STRING,`medium_5B_5D`:STRING,`medium_5b_5d`:STRING,`colantent`:STRING,`expid`:STRING,`utm_term`:STRING,`source_5b_5d`:STRING,`source_2020`:STRING,`utm_content`:STRING,`device`:STRING,`utm_medium`:STRING,`medium`:STRING,`referrer`:STRING,`utm_campaign`:STRING,`medium__`:STRING,`content`:STRING,`keyword`:STRING,`content__`:STRING,`term`:STRING,`sour`:STRING,`id`:STRING,`clkid`:STRING,`campaig`:STRING,`content_5b_5d`:STRING,`campaign__`:STRING,`utm_source`:STRING,`s_3A_2F_2Fwww`:struct<`selfstorage`:struct<`com_2Flpg_2Flf_2Fhp_copy_3Futm_source`:STRING>>,`campaign_5B_5D`:STRING,`capermpaign`:STRING,`t`:STRING,`s_3A_2F_2Fstorage`:struct<`com_2Fpaid_landing_2F_3Futm_source`:STRING>,`source`:STRING,`source_5B_5D`:STRING,`c`:STRING,`soue`:STRING,`campaign_5b_5d`:STRING,`source__`:STRING,`content_5B_5D`:STRING,`name`:STRING,`20on_20lineutm_campaign`:STRING>,`locale`:STRING,`userAgentData`:struct<`mobile`:STRING,`brands`:array>>,`isReact`:STRING,`site_id`:STRING,`env`:STRING>,`projectId`STRING,`receivedAt`STRING,`userId`STRING,`event`STRING,`anonymousId`STRING,`channel`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-ssdc-prod/separated_dt/CON PAGEVIEW'\n", "MSCK REPAIR TABLE sfdl_prod_segment.ssdc_conpageview" ] - hive_path: s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW
- id: 1266496
- processed: 1
- raw_data:
{ "__segment_internal": {}, "_metadata": { "bundled": [ "Google Tag Manager", "Segment.io" ], "bundledIds": [ "5aba5e646e396464865d9ca3" ], "failedInitializations": [ "Google Tag Manager" ], "retryCount": 2, "unbundled": [] }, "_origin": "2025-04-15T13:55:01Z|s3://sfdl-segment-ssdc-prod/segment-logs/5yGJd9z7eL/1744675200000/1744725236110.events-archiver-480-36..8ddc19da-e172-4333-9715-46cbbb626581.gz|analytics-segment-separator-prod:$LATEST", "anonymousId": "6db91b3d-9566-4bd0-9540-c2b6cc237954", "channel": "client", "context": { "campaign": { "content": "Climate Controlled", "id": "120211033152860078_v2_s01", "medium": "paid", "name": "Test - SSDC Facebook|General", "source": "facebook", "source%2020": "", "term": "120211033152950078" }, "ip": "107.122.105.112", "library": { "name": "analytics.js", "version": "next-1.77.0" }, "locale": "en-US", "page": { "path": "/lpg/lf/storage-location", "referrer": "https://www.google.com/", "search": "?tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=SSDC+Google%7CGeneral%7CBroad&utm_content=&ploc=9012103&iloc=9053135&mkwid=ssAmD0pXW%7Cpcrid%7C671257858962%7Cpkw%7Cself%20storage%7Cpmt%7Cb%7Cpdv%7Cm%7Cpgrid%7C9749850691%7Ccpgnid%7C194353051%7Cptaid%7Ckwd-10373131%7Cadext%7C&pgrid=9749850691&ptaid=kwd-10373131&gad_source=1&gclid=Cj0KCQjwh_i_BhCzARIsANimeoF3cjt7bP8Cy_mlqFmj3wLBY0PwiZZ9qEnwoaPFg01ygfcxzCcGir8aAsIdEALw_wcB", "title": "SelfStorage.com: Find Cheap Storage Units Near You", "url": "https://www.selfstorage.com/lpg/lf/storage-location?tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=SSDC+Google%7CGeneral%7CBroad&utm_content=&ploc=9012103&iloc=9053135&mkwid=ssAmD0pXW%7Cpcrid%7C671257858962%7Cpkw%7Cself%20storage%7Cpmt%7Cb%7Cpdv%7Cm%7Cpgrid%7C9749850691%7Ccpgnid%7C194353051%7Cptaid%7Ckwd-10373131%7Cadext%7C&pgrid=9749850691&ptaid=kwd-10373131&gad_source=1&gclid=Cj0KCQjwh_i_BhCzARIsANimeoF3cjt7bP8Cy_mlqFmj3wLBY0PwiZZ9qEnwoaPFg01ygfcxzCcGir8aAsIdEALw_wcB" }, "timezone": "America/New_York", "userAgent": "Mozilla/5.0 (Linux; Android 13; 21091116UG Build/TP1A.220624.014; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/135.0.7049.76 Mobile Safari/537.36 [FB_IAB/FB4A;FBAV/508.0.0.74.47;IABMV/1;]", "userAgentData": { "brands": [ { "brand": "Chromium", "version": "135" } ], "mobile": true, "platform": "Android" } }, "event": "CON PAGEVIEW", "integrations": { "All": true, "Google Analytics": false }, "messageId": "ajs-next-1744721630520-4bd0d540-c2b6-4c23-b954-512e34e355c3", "originalTimestamp": "2025-04-15T12:53:50.520Z", "projectId": "5yGJd9z7eL", "properties": { "CON": { "environment": "production", "facility": { "id": 232718, "title": "Mini Mall Storage - Bloomington - N Jackson St" }, "location": { "city": "District Heights", "id": 23813113, "state": "MD", "zip": "20747" }, "page_subtype": "cityLandingPage", "page_type": "searchPage", "ppc": { "adwords": { "date_end": "2025-04-29", "date_start": "2025-04-15", "page_type": "other" } }, "search_result": { "id": "f50d67fe570690d847.49236933", "listing_ids": [ 231277, 214054, 230094, 230093, 231674, 214020, 209142, 223103, 235799, 231212, 230233, 217666, 230214, 226192, 234201, 237954, 238350, 210485, 221897, 212931, 237936, 212328, 226183, 226188, 226182, 205961, 223104, 235696 ], "page": 1, "query": "District Heights, MD 20747, USA" }, "site_content": {}, "site_id": 27, "site_type": "desktop", "timestamp": "2025-04-15 08:54:30", "transaction": { "confirmation_code": "SA3KYD2KX", "email": "[email protected]", "id": "SA3KYD2KX", "npv": "480.85" }, "unit": { "id": 30447207, "price": "163.00" }, "visit_id": "2b0096bf75fc46f1a2bccf9731f4dab6" }, "Hit Timestamp": 1744721629896, "env": "production", "isReact": true, "site_id": 27 }, "receivedAt": "2025-04-15T12:53:50.952Z", "sentAt": "2025-04-15T12:53:50.527Z", "timestamp": "2025-04-15T12:53:50.945Z", "type": "track", "userId": "ab84f27959924de998ebaeedace8fa36", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.20on_20lineutm_campaign": "string", "context.campaign.c": "string", "context.campaign.cam": "string", "context.campaign.campaig": "string", "context.campaign.campaign_5B_5D": "string", "context.campaign.campaign_5b_5d": "string", "context.campaign.campaign__": "string", "context.campaign.capermpaign": "string", "context.campaign.clkid": "string", "context.campaign.colantent": "string", "context.campaign.content": "string", "context.campaign.content_5B_5D": "string", "context.campaign.content_5b_5d": "string", "context.campaign.content__": "string", "context.campaign.device": "string", "context.campaign.expid": "string", "context.campaign.id": "string", "context.campaign.keyword": "string", "context.campaign.mderreldium": "string", "context.campaign.medium": "string", "context.campaign.medium_5B_5D": "string", "context.campaign.medium_5b_5d": "string", "context.campaign.medium__": "string", "context.campaign.name": "string", "context.campaign.referrer": "string", "context.campaign.s_3A_2F_2Fstorage.com_2Fpaid_landing_2F_3Futm_source": "string", "context.campaign.s_3A_2F_2Fwww.selfstorage.com_2Flpg_2Flf_2Fhp_copy_3Futm_source": "string", "context.campaign.soue": "string", "context.campaign.sour": "string", "context.campaign.source": "string", "context.campaign.source_2020": "string", "context.campaign.source_5B_5D": "string", "context.campaign.source_5b_5d": "string", "context.campaign.source__": "string", "context.campaign.t": "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.campaign.utm_term": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.timezone": "string", "context.userAgent": "string", "context.userAgentData.brands": [ { "brand": "string", "version": "string" } ], "context.userAgentData.mobile": "string", "context.userAgentData.platform": "string", "event": "string", "integrations.All": "string", "integrations.Google_Analytics": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.CON.__cpLocation.city": "string", "properties.CON.__cpLocation.id": "string", "properties.CON.__cpLocation.state": "string", "properties.CON.__cpLocation.zip": "string", "properties.CON.environment": "string", "properties.CON.facility.id": "string", "properties.CON.facility.title": "string", "properties.CON.location.city": "string", "properties.CON.location.id": "string", "properties.CON.location.state": "string", "properties.CON.location.zip": "string", "properties.CON.page_subtype": "string", "properties.CON.page_type": "string", "properties.CON.ppc.adwords.date_end": "string", "properties.CON.ppc.adwords.date_start": "string", "properties.CON.ppc.adwords.page_type": "string", "properties.CON.search_result.id": "string", "properties.CON.search_result.listing_ids": [ "int" ], "properties.CON.search_result.page": "string", "properties.CON.search_result.query": "string", "properties.CON.site_content.id": "string", "properties.CON.site_id": "string", "properties.CON.site_type": "string", "properties.CON.timestamp": "string", "properties.CON.transaction.confirmation_code": "string", "properties.CON.transaction.email": "string", "properties.CON.transaction.id": "string", "properties.CON.transaction.npv": "string", "properties.CON.unit.id": "string", "properties.CON.unit.price": "string", "properties.CON.visit_id": "string", "properties.Hit_Timestamp": "string", "properties.env": "string", "properties.isReact": "string", "properties.site_id": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 839
- schema_scan_id: 140603046
- updated: 2025-04-15 09:07:06
-
Version 1177168
- created: 2025-01-30 01:58:29
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "DROP TABLE IF EXISTS `sfdl_prod_segment.ssdc_conpageview`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.ssdc_conpageview`\n(\n`version`STRING,`receivedAt`STRING,`integrations`struct<`All`:STRING,`Google_Analytics`:STRING>,`type`STRING,`sentAt`STRING,`originalTimestamp`STRING,`channel`STRING,`context`struct<`page`:struct<`url`:STRING,`title`:STRING,`path`:STRING,`referrer`:STRING,`search`:STRING>,`library`:struct<`name`:STRING,`version`:STRING>,`timezone`:STRING,`locale`:STRING,`userAgentData`:struct<`platform`:STRING,`mobile`:STRING,`brands`:array,`query`:STRING,`page`:STRING,`id`:STRING>,`facility`:struct<`title`:STRING,`id`:STRING>,`location`:struct<`id`:STRING,`zip`:STRING,`state`:STRING,`city`:STRING>,`site_content`:struct<`id`:STRING>,`page_type`:STRING,`site_type`:STRING,`timestamp`:STRING,`page_subtype`:STRING,`unit`:struct<`price`:STRING,`id`:STRING>,`visit_id`:STRING,`transaction`:struct<`id`:STRING,`npv`:STRING,`confirmation_code`:STRING,`email`:STRING>,`__cpLocation`:struct<`zip`:STRING,`id`:STRING,`city`:STRING,`state`:STRING>,`environment`:STRING>>,`timestamp`STRING,`anonymousId`STRING,`projectId`STRING,`userId`STRING,`messageId`STRING,`event`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-ssdc-prod/separated_dt/CON PAGEVIEW'\n", "MSCK REPAIR TABLE sfdl_prod_segment.ssdc_conpageview" ] - hive_path: s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW
- id: 1177168
- processed: 1
- raw_data:
{ "__segment_internal": {}, "_metadata": { "bundled": [ "Google Tag Manager", "Segment.io" ], "bundledIds": [ "5aba5e646e396464865d9ca3" ], "failedInitializations": [ "Google Tag Manager" ], "unbundled": [] }, "_origin": "2025-01-30T07:58:06Z|s3://sfdl-segment-ssdc-prod/segment-logs/5yGJd9z7eL/1738195200000/1738223806577.events-archiver-480-26..1edbac55-10d6-470d-bc79-6614b763aea6.gz|analytics-segment-separator-prod:$LATEST", "anonymousId": "8ffe2eb4-7cfd-44ff-a526-0c7f2188e755", "channel": "client", "context": { "campaign": { "content": "", "mderreldium": "paidsearch", "medium": "paidsearch", "name": "", "source": "bing", "term": "+storage +unit" }, "ip": "98.54.155.8", "library": { "name": "analytics.js", "version": "next-1.77.0" }, "locale": "en-US", "page": { "path": "/self-storage/louisiana/monroe/inside-the-box-self-storage-239428/", "referrer": "", "search": "", "title": "Inside the Box Self Storage: Lowest Rates - SelfStorage.com", "url": "https://www.selfstorage.com/self-storage/louisiana/monroe/inside-the-box-self-storage-239428/" }, "timezone": "America/Chicago", "userAgent": "Mozilla/5.0 (Linux; Android 12; SM-N960F Build/PPR1.180610.011; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/132.0.6834.122 Mobile Safari/537.36", "userAgentData": { "brands": [ { "brand": "Android WebView", "version": "132" } ], "mobile": true, "platform": "Android" } }, "event": "CON PAGEVIEW", "integrations": { "All": true, "Google Analytics": false }, "messageId": "ajs-next-1738220243973-0bd7311d-e9b3-43b5-8a10-ba542b5e4590", "originalTimestamp": "2025-01-30T06:57:23.973Z", "projectId": "5yGJd9z7eL", "properties": { "CON": { "environment": "production", "facility": { "id": 239428, "title": "Inside the Box Self Storage" }, "location": { "city": "Lawndale", "id": 29049800, "state": "CA", "zip": "90260" }, "page_subtype": "cityLandingPage", "page_type": "searchPage", "ppc": { "adwords": { "date_end": "2025-02-13", "date_start": "2025-01-30", "page_type": "offerdetail" } }, "search_result": { "id": "f59b679b25044332a1.22547028", "listing_ids": [ 236667, 228216, 221655, 221656, 229010, 208989, 228182, 231952, 215505, 223892, 228220, 223914, 219483, 205832, 236813, 228604, 218342, 221967 ], "page": 1, "query": "33.88721600875519, -118.3411459285433" }, "site_content": { "id": 1383 }, "site_id": 27, "site_type": "desktop", "timestamp": "2025-01-29 23:09:57", "transaction": { "confirmation_code": "V7HJSJN44", "email": "[email protected]", "id": "V7HJSJN44", "npv": "127.50" }, "unit": { "id": 32069350, "price": 50 }, "visit_id": "982e1a67f52f37323eba0997b2ccd7f4" }, "Hit Timestamp": 1738220243622, "env": "production", "isReact": true, "site_id": 27 }, "receivedAt": "2025-01-30T06:57:24.504Z", "sentAt": "2025-01-30T06:57:23.995Z", "timestamp": "2025-01-30T06:57:24.482Z", "type": "track", "userId": "446737e6f06cc7f7ec18fd86d76ea273", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.20on_20lineutm_campaign": "string", "context.campaign.c": "string", "context.campaign.cam": "string", "context.campaign.campaig": "string", "context.campaign.campaign_5B_5D": "string", "context.campaign.campaign_5b_5d": "string", "context.campaign.campaign__": "string", "context.campaign.capermpaign": "string", "context.campaign.clkid": "string", "context.campaign.colantent": "string", "context.campaign.content": "string", "context.campaign.content_5B_5D": "string", "context.campaign.content_5b_5d": "string", "context.campaign.content__": "string", "context.campaign.device": "string", "context.campaign.expid": "string", "context.campaign.id": "string", "context.campaign.keyword": "string", "context.campaign.mderreldium": "string", "context.campaign.medium": "string", "context.campaign.medium_5B_5D": "string", "context.campaign.medium_5b_5d": "string", "context.campaign.medium__": "string", "context.campaign.name": "string", "context.campaign.referrer": "string", "context.campaign.s_3A_2F_2Fstorage.com_2Fpaid_landing_2F_3Futm_source": "string", "context.campaign.s_3A_2F_2Fwww.selfstorage.com_2Flpg_2Flf_2Fhp_copy_3Futm_source": "string", "context.campaign.soue": "string", "context.campaign.sour": "string", "context.campaign.source": "string", "context.campaign.source_5B_5D": "string", "context.campaign.source_5b_5d": "string", "context.campaign.source__": "string", "context.campaign.t": "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.campaign.utm_term": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.timezone": "string", "context.userAgent": "string", "context.userAgentData.brands": [ { "brand": "string", "version": "string" } ], "context.userAgentData.mobile": "string", "context.userAgentData.platform": "string", "event": "string", "integrations.All": "string", "integrations.Google_Analytics": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.CON.__cpLocation.city": "string", "properties.CON.__cpLocation.id": "string", "properties.CON.__cpLocation.state": "string", "properties.CON.__cpLocation.zip": "string", "properties.CON.environment": "string", "properties.CON.facility.id": "string", "properties.CON.facility.title": "string", "properties.CON.location.city": "string", "properties.CON.location.id": "string", "properties.CON.location.state": "string", "properties.CON.location.zip": "string", "properties.CON.page_subtype": "string", "properties.CON.page_type": "string", "properties.CON.ppc.adwords.date_end": "string", "properties.CON.ppc.adwords.date_start": "string", "properties.CON.ppc.adwords.page_type": "string", "properties.CON.search_result.id": "string", "properties.CON.search_result.listing_ids": [ "int" ], "properties.CON.search_result.page": "string", "properties.CON.search_result.query": "string", "properties.CON.site_content.id": "string", "properties.CON.site_id": "string", "properties.CON.site_type": "string", "properties.CON.timestamp": "string", "properties.CON.transaction.confirmation_code": "string", "properties.CON.transaction.email": "string", "properties.CON.transaction.id": "string", "properties.CON.transaction.npv": "string", "properties.CON.unit.id": "string", "properties.CON.unit.price": "string", "properties.CON.visit_id": "string", "properties.Hit_Timestamp": "string", "properties.env": "string", "properties.isReact": "string", "properties.site_id": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 839
- schema_scan_id: 136248877
- updated: 2025-01-30 02:06:33
-
Version 1125869
- created: 2024-12-16 09:55:12
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "DROP TABLE IF EXISTS `sfdl_prod_segment.ssdc_conpageview`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.ssdc_conpageview`\n(\n`integrations`struct<`Google_Analytics`:STRING,`All`:STRING>,`context`struct<`locale`:STRING,`page`:struct<`url`:STRING,`search`:STRING,`title`:STRING,`referrer`:STRING,`path`:STRING>,`userAgent`:STRING,`userAgentData`:struct<`platform`:STRING,`mobile`:STRING,`brands`:array,`query`:STRING>,`ppc`:struct<`adwords`:struct<`date_start`:STRING,`date_end`:STRING,`page_type`:STRING>>,`site_type`:STRING,`__cpLocation`:struct<`zip`:STRING,`id`:STRING,`city`:STRING,`state`:STRING>,`site_id`:STRING,`location`:struct<`city`:STRING,`id`:STRING,`state`:STRING,`zip`:STRING>,`facility`:struct<`id`:STRING,`title`:STRING>,`transaction`:struct<`email`:STRING,`id`:STRING,`confirmation_code`:STRING,`npv`:STRING>,`site_content`:struct<`id`:STRING>,`unit`:struct<`id`:STRING,`price`:STRING>,`page_type`:STRING,`environment`:STRING>,`isReact`:STRING,`env`:STRING,`Hit_Timestamp`:STRING,`site_id`:STRING>,`userId`STRING,`channel`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-ssdc-prod/separated_dt/CON PAGEVIEW'\n", "MSCK REPAIR TABLE sfdl_prod_segment.ssdc_conpageview" ] - hive_path: s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW
- id: 1125869
- processed: 1
- raw_data:
{ "__segment_internal": {}, "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "evfdze8kT9", "5aba5e646e396464865d9ca3" ], "unbundled": [] }, "_origin": "2024-12-16T15:54:55Z|s3://sfdl-segment-ssdc-prod/segment-logs/5yGJd9z7eL/1734307200000/1734364383093.events-archiver-480-30..002dea51-2d57-4e2f-8cb0-3f81634a34f2.gz|analytics-segment-separator-prod:$LATEST", "anonymousId": "cbc8ce99-1e2f-40aa-bc25-28e0a3d97025", "channel": "client", "context": { "campaign": { "capermpaign": "pro_national_nogeo_noproduct_dynamic", "content": "", "medium": "paidsearch", "name": "SSDC Google|Remarketing|General|Exact", "source": "bing", "term": "self-storage/texas/" }, "ip": "71.235.48.177", "library": { "name": "analytics.js", "version": "next-1.76.0" }, "locale": "en-US", "page": { "path": "/self-storage/new-hampshire/suncook/", "referrer": "https://www.google.com/", "search": "?tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=SSDC+Google%7CRemarketing%7CGeneral%7CExact&utm_content=&ploc=9001994&iloc=&mkwid=syZzWQAqy|pcrid|708226797542|pkw|car%20garages%20for%20rent|pmt|b|pdv|m|pgrid|165300032603|cpgnid|597345759|ptaid|kwd-296500553454|adext|&pgrid=165300032603&ptaid=kwd-296500553454&gad_source=1&gclid=Cj0KCQiAvP-6BhDyARIsAJ3uv7ZbsslD3okSeBns7c7G9VzAKbawCoZyvN4HtXeHrDwBy2WnumSJooEaAlb3EALw_wcB", "title": "SelfStorage.com: Find Cheap Storage Units Near You", "url": "https://www.selfstorage.com/self-storage/new-hampshire/suncook/?tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=SSDC+Google%7CRemarketing%7CGeneral%7CExact&utm_content=&ploc=9001994&iloc=&mkwid=syZzWQAqy|pcrid|708226797542|pkw|car%20garages%20for%20rent|pmt|b|pdv|m|pgrid|165300032603|cpgnid|597345759|ptaid|kwd-296500553454|adext|&pgrid=165300032603&ptaid=kwd-296500553454&gad_source=1&gclid=Cj0KCQiAvP-6BhDyARIsAJ3uv7ZbsslD3okSeBns7c7G9VzAKbawCoZyvN4HtXeHrDwBy2WnumSJooEaAlb3EALw_wcB" }, "timezone": "America/New_York", "userAgent": "Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36", "userAgentData": { "brands": [ { "brand": "Not_A Brand", "version": "24" } ], "mobile": true, "platform": "Android" } }, "event": "CON PAGEVIEW", "integrations": { "All": true, "Google Analytics": false }, "messageId": "ajs-next-1734360927356-19ddb733-9b09-4da3-b83b-b2fed89c2eb2", "originalTimestamp": "2024-12-16T14:55:27.356Z", "projectId": "5yGJd9z7eL", "properties": { "CON": { "environment": "production", "facility": { "id": 221794, "title": "LocalStorage Waterbury" }, "location": { "city": "Reno", "id": 45940759, "state": "NV", "zip": "89502" }, "page_subtype": "cityLandingPage", "page_type": "searchPage", "ppc": { "adwords": { "date_end": "2024-12-30", "date_start": "2024-12-16", "page_type": "other" } }, "search_result": { "id": "377767603f8b5078b0.84323106", "listing_ids": [ 213349, 229829, 213389, 213293, 210758, 230010, 221704, 229212, 229793, 198540, 213384, 213064, 228679, 210771, 220575, 238743, 228953, 199548, 216280, 107199, 237709, 232905, 217830, 213383, 236397, 233641, 156852, 229200, 223456, 236428 ], "page": 1, "query": "39.49180724006484, -119.78429319730377" }, "site_content": {}, "site_id": 27, "site_type": "desktop", "timestamp": "2024-12-16 06:54:13", "transaction": { "confirmation_code": "P76PFFAK4", "email": "[email protected]", "id": "P76PFFAK4", "npv": "492.25" }, "unit": { "id": 28957131, "price": 64 }, "visit_id": "db8472fad4e81b320bad6971f90ec468" }, "Hit Timestamp": 1734360927356, "env": "production", "isReact": true, "site_id": 27 }, "receivedAt": "2024-12-16T14:55:27.709Z", "sentAt": "2024-12-16T14:55:27.382Z", "timestamp": "2024-12-16T14:55:27.683Z", "type": "track", "userId": "250e6ab300e094ae0ae9b6c954c31f98", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.20on_20lineutm_campaign": "string", "context.campaign.c": "string", "context.campaign.cam": "string", "context.campaign.campaig": "string", "context.campaign.campaign_5B_5D": "string", "context.campaign.campaign_5b_5d": "string", "context.campaign.campaign__": "string", "context.campaign.capermpaign": "string", "context.campaign.clkid": "string", "context.campaign.colantent": "string", "context.campaign.content": "string", "context.campaign.content_5B_5D": "string", "context.campaign.content_5b_5d": "string", "context.campaign.content__": "string", "context.campaign.device": "string", "context.campaign.expid": "string", "context.campaign.id": "string", "context.campaign.keyword": "string", "context.campaign.medium": "string", "context.campaign.medium_5B_5D": "string", "context.campaign.medium_5b_5d": "string", "context.campaign.medium__": "string", "context.campaign.name": "string", "context.campaign.referrer": "string", "context.campaign.s_3A_2F_2Fstorage.com_2Fpaid_landing_2F_3Futm_source": "string", "context.campaign.s_3A_2F_2Fwww.selfstorage.com_2Flpg_2Flf_2Fhp_copy_3Futm_source": "string", "context.campaign.soue": "string", "context.campaign.sour": "string", "context.campaign.source": "string", "context.campaign.source_5B_5D": "string", "context.campaign.source_5b_5d": "string", "context.campaign.source__": "string", "context.campaign.t": "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.campaign.utm_term": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.timezone": "string", "context.userAgent": "string", "context.userAgentData.brands": [ { "brand": "string", "version": "string" } ], "context.userAgentData.mobile": "string", "context.userAgentData.platform": "string", "event": "string", "integrations.All": "string", "integrations.Google_Analytics": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.CON.__cpLocation.city": "string", "properties.CON.__cpLocation.id": "string", "properties.CON.__cpLocation.state": "string", "properties.CON.__cpLocation.zip": "string", "properties.CON.environment": "string", "properties.CON.facility.id": "string", "properties.CON.facility.title": "string", "properties.CON.location.city": "string", "properties.CON.location.id": "string", "properties.CON.location.state": "string", "properties.CON.location.zip": "string", "properties.CON.page_subtype": "string", "properties.CON.page_type": "string", "properties.CON.ppc.adwords.date_end": "string", "properties.CON.ppc.adwords.date_start": "string", "properties.CON.ppc.adwords.page_type": "string", "properties.CON.search_result.id": "string", "properties.CON.search_result.listing_ids": [ "int" ], "properties.CON.search_result.page": "string", "properties.CON.search_result.query": "string", "properties.CON.site_content.id": "string", "properties.CON.site_id": "string", "properties.CON.site_type": "string", "properties.CON.timestamp": "string", "properties.CON.transaction.confirmation_code": "string", "properties.CON.transaction.email": "string", "properties.CON.transaction.id": "string", "properties.CON.transaction.npv": "string", "properties.CON.unit.id": "string", "properties.CON.unit.price": "string", "properties.CON.visit_id": "string", "properties.Hit_Timestamp": "string", "properties.env": "string", "properties.isReact": "string", "properties.site_id": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 839
- schema_scan_id: 133705559
- updated: 2024-12-16 10:07:34
Schema Scans: 3
Last at 2025-04-15 08:58:17
-
Scan 140603046
- duration: 0:01:00.129297
- exit_message:
{ "exception": "Query failed: FAILED: SemanticException [Error 10001]: Table not found sfdl_prod_segment.ssdc_conpageview `SHOW PARTITIONS `sfdl_prod_segment.ssdc_conpageview``\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.ssdc_conpageview `SHOW PARTITIONS `sfdl_prod_segment.ssdc_conpageview``\n: Expecting value: line 1 column 1 (char 0)" } - id: 140603046
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-04-15/", "name": "dt", "type": "string", "value": "2025-04-15" }, "s3": { "bucket": "sfdl-segment-ssdc-prod", "hive_path": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW", "key": "separated_dt/CON PAGEVIEW/dt=2025-04-15/1744725236110.events-archiver-480-36..8ddc19da-e172-4333-9715-46cbbb626581.json.gz" }, "schema": { "name": "sfdl_prod_segment.ssdc_CONPAGEVIEW", "type": "segment" } } - running: False
- schema_name_id: 839
- start_time: 2025-04-15 08:58:17
- success: False
- trace_id: 6921018353659656534
-
Scan 136248877
- duration: 0:02:51.857958
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 2250, "partitions_applied": false, "success": true } - id: 136248877
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-01-30/", "name": "dt", "type": "string", "value": "2025-01-30" }, "s3": { "bucket": "sfdl-segment-ssdc-prod", "hive_path": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW", "key": "separated_dt/CON PAGEVIEW/dt=2025-01-30/1738223806577.events-archiver-480-26..1edbac55-10d6-470d-bc79-6614b763aea6.json.gz" }, "schema": { "name": "sfdl_prod_segment.ssdc_CONPAGEVIEW", "type": "segment" } } - running: False
- schema_name_id: 839
- start_time: 2025-01-30 01:58:26
- success: True
- trace_id: 15202944124680419893
-
Scan 133705559
- duration: 0:06:46.877013
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 295, "partitions_applied": false, "success": true } - id: 133705559
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2024-12-16/", "name": "dt", "type": "string", "value": "2024-12-16" }, "s3": { "bucket": "sfdl-segment-ssdc-prod", "hive_path": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW", "key": "separated_dt/CON PAGEVIEW/dt=2024-12-16/1734364383093.events-archiver-480-30..002dea51-2d57-4e2f-8cb0-3f81634a34f2.json.gz" }, "schema": { "name": "sfdl_prod_segment.ssdc_CONPAGEVIEW", "type": "segment" } } - running: False
- schema_name_id: 839
- start_time: 2024-12-16 09:55:09
- success: True
- trace_id: 7546372939673024703
- count: 110
- ddl:
[ "ALTER TABLE\n `sfdl_prod_segment.ssdc_conpageview`\nADD\n\n\n PARTITION (dt='2025-10-15') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-15/'\n PARTITION (dt='2025-10-16') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-16/'\n PARTITION (dt='2025-10-17') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-17/'\n PARTITION (dt='2025-10-18') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-18/'\n PARTITION (dt='2025-10-19') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-19/'\n PARTITION (dt='2025-10-20') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-20/'\n PARTITION (dt='2025-10-22') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-22/'\n PARTITION (dt='2025-10-26') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-26/'\n PARTITION (dt='2025-10-28') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-28/'\n PARTITION (dt='2025-10-29') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-29/'\n PARTITION (dt='2025-10-30') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-30/'\n PARTITION (dt='2025-11-01') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-01/'\n PARTITION (dt='2025-11-02') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-02/'\n PARTITION (dt='2025-11-03') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-03/'\n PARTITION (dt='2025-11-04') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-04/'\n PARTITION (dt='2025-11-05') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-05/'\n PARTITION (dt='2025-11-07') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-07/'\n PARTITION (dt='2025-11-08') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-08/'\n PARTITION (dt='2025-11-09') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-09/'\n PARTITION (dt='2025-11-10') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-10/'\n PARTITION (dt='2025-11-11') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-11/'\n PARTITION (dt='2025-11-12') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-12/'\n PARTITION (dt='2025-11-13') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-13/'\n PARTITION (dt='2025-11-14') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-14/'\n PARTITION (dt='2025-11-16') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-16/'\n PARTITION (dt='2025-11-17') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-17/'\n PARTITION (dt='2025-11-19') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-19/'\n PARTITION (dt='2025-11-21') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-21/'\n PARTITION (dt='2025-11-22') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-22/'\n PARTITION (dt='2025-11-23') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-23/'\n PARTITION (dt='2025-11-24') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-24/'\n PARTITION (dt='2025-11-25') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-25/'\n PARTITION (dt='2025-11-27') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-27/'\n PARTITION (dt='2025-11-28') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-28/'\n PARTITION (dt='2025-11-29') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-29/'\n PARTITION (dt='2025-11-30') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-30/'\n PARTITION (dt='2025-12-01') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-01/'\n PARTITION (dt='2025-12-02') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-02/'\n PARTITION (dt='2025-12-03') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-03/'\n PARTITION (dt='2025-12-04') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-04/'\n PARTITION (dt='2025-12-05') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-05/'\n PARTITION (dt='2025-12-06') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-06/'\n PARTITION (dt='2025-12-07') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-07/'\n PARTITION (dt='2025-12-08') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-08/'\n PARTITION (dt='2025-12-10') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-10/'\n PARTITION (dt='2025-12-11') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-11/'\n PARTITION (dt='2025-12-12') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-12/'\n PARTITION (dt='2025-12-13') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-13/'\n PARTITION (dt='2025-12-17') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-17/'\n PARTITION (dt='2025-12-18') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-18/'\n PARTITION (dt='2025-12-19') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-19/'\n PARTITION (dt='2025-12-22') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-22/'\n PARTITION (dt='2025-12-24') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-24/'\n PARTITION (dt='2025-12-25') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-25/'\n PARTITION (dt='2025-12-26') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-26/'\n PARTITION (dt='2025-12-27') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-27/'\n PARTITION (dt='2025-12-28') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-28/'\n PARTITION (dt='2025-12-30') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-30/'\n PARTITION (dt='2025-12-31') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-31/'\n PARTITION (dt='2026-01-01') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-01/'\n PARTITION (dt='2026-01-03') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-03/'\n PARTITION (dt='2026-01-04') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-04/'\n PARTITION (dt='2026-01-06') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-06/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-07/'\n PARTITION (dt='2026-01-09') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-09/'\n PARTITION (dt='2026-01-11') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-11/'\n PARTITION (dt='2026-01-12') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-12/'\n PARTITION (dt='2026-01-13') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-13/'\n PARTITION (dt='2026-01-14') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-14/'\n PARTITION (dt='2026-01-16') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-16/'\n PARTITION (dt='2026-01-19') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-19/'\n PARTITION (dt='2026-01-20') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-20/'\n PARTITION (dt='2026-01-21') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-21/'\n PARTITION (dt='2026-01-23') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-23/'\n PARTITION (dt='2026-01-24') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-24/'\n PARTITION (dt='2026-01-25') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-25/'\n PARTITION (dt='2026-01-26') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-26/'\n PARTITION (dt='2026-01-27') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-27/'\n PARTITION (dt='2026-01-28') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-28/'\n PARTITION (dt='2026-01-29') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-29/'\n PARTITION (dt='2026-01-30') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-30/'\n PARTITION (dt='2026-01-31') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-31/'\n PARTITION (dt='2026-02-02') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-02/'\n PARTITION (dt='2026-02-04') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-04/'\n PARTITION (dt='2026-02-05') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-05/'\n PARTITION (dt='2026-02-06') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-06/'\n PARTITION (dt='2026-02-11') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-11/'\n PARTITION (dt='2026-02-15') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-15/'\n PARTITION (dt='2026-02-19') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-19/'\n PARTITION (dt='2026-02-22') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-22/'\n PARTITION (dt='2026-02-25') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-25/'\n PARTITION (dt='2026-02-27') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-27/'\n PARTITION (dt='2026-02-28') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-28/'\n PARTITION (dt='2026-03-01') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-01/'\n PARTITION (dt='2026-03-03') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-03/'\n PARTITION (dt='2026-03-05') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-05/'\n PARTITION (dt='2026-03-07') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-07/'\n PARTITION (dt='2026-03-08') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-08/'\n PARTITION (dt='2026-03-15') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-15/'\n PARTITION (dt='2026-03-17') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-17/'\n PARTITION (dt='2026-03-19') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-19/'\n PARTITION (dt='2026-03-20') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-20/'\n PARTITION (dt='2026-03-24') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-24/'\n PARTITION (dt='2026-03-27') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-27/'\n PARTITION (dt='2026-03-28') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-28/'\n PARTITION (dt='2026-03-29') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-29/'\n PARTITION (dt='2026-04-01') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-04-01/'\n PARTITION (dt='2026-04-02') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-04-02/'\n PARTITION (dt='2026-04-07') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-04-07/'\n PARTITION (dt='2026-04-14') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-04-14/'\n;" ] - name: dt
- state:
[ { "info": { "id": 1566048, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-15/", "name": "dt", "value": "2025-10-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-15 03:57:41", "last_data": "2025-10-15 03:57:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1566407, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-16/", "name": "dt", "value": "2025-10-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-16 13:48:10", "last_data": "2025-10-16 13:51:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1595801, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-17/", "name": "dt", "value": "2025-10-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-17 14:03:08", "last_data": "2025-10-17 14:18:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1595898, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-18/", "name": "dt", "value": "2025-10-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-18 01:53:30", "last_data": "2025-10-18 15:49:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1596147, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-19/", "name": "dt", "value": "2025-10-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-18 22:54:54", "last_data": "2025-10-19 16:59:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1596737, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-20/", "name": "dt", "value": "2025-10-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-20 05:17:07", "last_data": "2025-10-20 05:17:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1597165, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-22/", "name": "dt", "value": "2025-10-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-21 19:59:31", "last_data": "2025-10-22 12:15:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1598112, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-26/", "name": "dt", "value": "2025-10-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-25 19:54:44", "last_data": "2025-10-26 18:18:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1598615, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-28/", "name": "dt", "value": "2025-10-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-27 21:09:03", "last_data": "2025-10-27 21:18:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1598995, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-29/", "name": "dt", "value": "2025-10-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-29 14:12:44", "last_data": "2025-10-29 18:25:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1599090, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-30/", "name": "dt", "value": "2025-10-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-29 22:03:53", "last_data": "2025-10-29 22:03:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1599902, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-01/", "name": "dt", "value": "2025-11-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-01 15:53:54", "last_data": "2025-11-01 15:55:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1600010, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-02/", "name": "dt", "value": "2025-11-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-02 02:55:25", "last_data": "2025-11-02 18:08:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1600266, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-03/", "name": "dt", "value": "2025-11-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-03 05:52:10", "last_data": "2025-11-03 05:59:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1600614, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-04/", "name": "dt", "value": "2025-11-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-04 11:02:02", "last_data": "2025-11-04 11:08:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1600710, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-05/", "name": "dt", "value": "2025-11-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-04 21:15:04", "last_data": "2025-11-04 21:15:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1601232, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-07/", "name": "dt", "value": "2025-11-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-07 06:53:36", "last_data": "2025-11-07 06:53:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1601528, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-08/", "name": "dt", "value": "2025-11-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-08 09:02:16", "last_data": "2025-11-08 16:42:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1601826, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-09/", "name": "dt", "value": "2025-11-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-09 16:12:11", "last_data": "2025-11-09 16:29:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1601915, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-10/", "name": "dt", "value": "2025-11-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-09 20:05:53", "last_data": "2025-11-09 20:13:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1602303, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-11/", "name": "dt", "value": "2025-11-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-11 16:06:29", "last_data": "2025-11-11 16:06:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1602368, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-12/", "name": "dt", "value": "2025-11-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-11 19:06:33", "last_data": "2025-11-12 14:05:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1602634, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-13/", "name": "dt", "value": "2025-11-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-13 00:03:15", "last_data": "2025-11-13 17:00:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1602879, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-14/", "name": "dt", "value": "2025-11-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-14 03:01:53", "last_data": "2025-11-14 18:27:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1605678, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-16/", "name": "dt", "value": "2025-11-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-16 18:01:19", "last_data": "2025-11-16 18:02:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1605811, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-17/", "name": "dt", "value": "2025-11-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-17 08:00:40", "last_data": "2025-11-17 08:06:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1606339, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-19/", "name": "dt", "value": "2025-11-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-19 09:05:55", "last_data": "2025-11-19 17:00:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1606874, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-21/", "name": "dt", "value": "2025-11-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-21 11:02:59", "last_data": "2025-11-21 11:02:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1607553, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-22/", "name": "dt", "value": "2025-11-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-22 06:47:09", "last_data": "2025-11-22 06:47:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1607895, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-23/", "name": "dt", "value": "2025-11-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-23 10:04:02", "last_data": "2025-11-23 10:04:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1608130, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-24/", "name": "dt", "value": "2025-11-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-24 12:02:08", "last_data": "2025-11-24 12:07:32" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1608225, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-25/", "name": "dt", "value": "2025-11-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-24 20:53:00", "last_data": "2025-11-24 21:01:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1608663, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-27/", "name": "dt", "value": "2025-11-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-26 19:02:49", "last_data": "2025-11-27 16:05:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1608919, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-28/", "name": "dt", "value": "2025-11-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-28 00:09:21", "last_data": "2025-11-28 00:13:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1609294, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-29/", "name": "dt", "value": "2025-11-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-29 14:02:56", "last_data": "2025-11-29 14:06:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1609382, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-30/", "name": "dt", "value": "2025-11-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-30 00:53:01", "last_data": "2025-11-30 18:01:26" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1609600, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-01/", "name": "dt", "value": "2025-12-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-30 20:03:33", "last_data": "2025-12-01 17:13:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1610001, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-02/", "name": "dt", "value": "2025-12-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-02 17:24:52", "last_data": "2025-12-02 17:33:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1610075, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-03/", "name": "dt", "value": "2025-12-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-02 19:10:57", "last_data": "2025-12-03 08:57:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1610386, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-04/", "name": "dt", "value": "2025-12-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-04 07:03:29", "last_data": "2025-12-04 07:07:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1610712, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-05/", "name": "dt", "value": "2025-12-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-05 14:54:08", "last_data": "2025-12-05 17:58:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1611093, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-06/", "name": "dt", "value": "2025-12-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-06 02:13:53", "last_data": "2025-12-06 07:08:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1611460, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-07/", "name": "dt", "value": "2025-12-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-07 18:06:11", "last_data": "2025-12-07 18:06:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1611551, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-08/", "name": "dt", "value": "2025-12-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-08 02:01:47", "last_data": "2025-12-08 15:31:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1612265, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-10/", "name": "dt", "value": "2025-12-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-09 21:02:07", "last_data": "2025-12-10 14:40:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1612502, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-11/", "name": "dt", "value": "2025-12-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-10 19:59:07", "last_data": "2025-12-10 19:59:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1612848, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-12/", "name": "dt", "value": "2025-12-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-12 09:11:44", "last_data": "2025-12-12 09:11:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1613201, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-13/", "name": "dt", "value": "2025-12-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-13 14:45:41", "last_data": "2025-12-13 14:45:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1616597, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-17/", "name": "dt", "value": "2025-12-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-17 08:08:22", "last_data": "2025-12-17 12:02:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1616806, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-18/", "name": "dt", "value": "2025-12-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-18 05:01:56", "last_data": "2025-12-18 16:44:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1617127, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-19/", "name": "dt", "value": "2025-12-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-19 14:53:14", "last_data": "2025-12-19 14:53:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1617667, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-22/", "name": "dt", "value": "2025-12-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-21 21:06:01", "last_data": "2025-12-21 21:52:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1618172, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-24/", "name": "dt", "value": "2025-12-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-24 09:00:06", "last_data": "2025-12-24 09:00:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1618315, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-25/", "name": "dt", "value": "2025-12-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-24 22:53:54", "last_data": "2025-12-24 22:53:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1618518, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-26/", "name": "dt", "value": "2025-12-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-25 20:01:41", "last_data": "2025-12-25 20:01:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1618744, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-27/", "name": "dt", "value": "2025-12-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-26 21:01:53", "last_data": "2025-12-26 21:01:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1618992, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-28/", "name": "dt", "value": "2025-12-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-28 06:57:49", "last_data": "2025-12-28 12:04:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1619431, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-30/", "name": "dt", "value": "2025-12-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-30 01:01:05", "last_data": "2025-12-30 14:00:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1619678, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-31/", "name": "dt", "value": "2025-12-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-31 06:00:05", "last_data": "2025-12-31 06:00:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1620014, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-01/", "name": "dt", "value": "2026-01-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-01 12:05:03", "last_data": "2026-01-01 12:06:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1620310, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-03/", "name": "dt", "value": "2026-01-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-02 19:56:02", "last_data": "2026-01-02 19:56:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1620664, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-04/", "name": "dt", "value": "2026-01-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-04 18:41:16", "last_data": "2026-01-04 18:41:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1621094, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-06/", "name": "dt", "value": "2026-01-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-06 11:57:52", "last_data": "2026-01-06 12:03:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1621222, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-07/", "name": "dt", "value": "2026-01-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-07 05:57:46", "last_data": "2026-01-07 13:56:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1621743, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-09/", "name": "dt", "value": "2026-01-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-09 14:32:49", "last_data": "2026-01-09 14:32:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1622080, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-11/", "name": "dt", "value": "2026-01-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-11 02:57:34", "last_data": "2026-01-11 13:04:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1622299, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-12/", "name": "dt", "value": "2026-01-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-11 21:55:01", "last_data": "2026-01-12 13:56:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1622776, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-13/", "name": "dt", "value": "2026-01-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-13 14:52:46", "last_data": "2026-01-13 16:51:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1622994, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-14/", "name": "dt", "value": "2026-01-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-14 15:44:57", "last_data": "2026-01-14 15:47:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1625584, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-16/", "name": "dt", "value": "2026-01-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-16 09:57:06", "last_data": "2026-01-16 09:57:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1626437, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-19/", "name": "dt", "value": "2026-01-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-19 10:54:02", "last_data": "2026-01-19 10:54:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1626521, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-20/", "name": "dt", "value": "2026-01-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-19 22:55:30", "last_data": "2026-01-19 22:55:30" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1626913, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-21/", "name": "dt", "value": "2026-01-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-21 15:58:53", "last_data": "2026-01-21 16:04:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1627173, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-23/", "name": "dt", "value": "2026-01-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-22 18:55:05", "last_data": "2026-01-22 18:55:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1627554, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-24/", "name": "dt", "value": "2026-01-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-24 12:51:56", "last_data": "2026-01-24 12:51:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1627769, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-25/", "name": "dt", "value": "2026-01-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-25 12:54:23", "last_data": "2026-01-25 12:54:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1627884, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-26/", "name": "dt", "value": "2026-01-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-26 05:58:27", "last_data": "2026-01-26 05:58:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1628105, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-27/", "name": "dt", "value": "2026-01-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-27 04:51:38", "last_data": "2026-01-27 04:51:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1628283, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-28/", "name": "dt", "value": "2026-01-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-27 20:03:07", "last_data": "2026-01-28 18:37:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1628503, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-29/", "name": "dt", "value": "2026-01-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-28 21:56:34", "last_data": "2026-01-29 12:54:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1628873, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-30/", "name": "dt", "value": "2026-01-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-30 13:55:45", "last_data": "2026-01-30 18:34:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1628957, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-31/", "name": "dt", "value": "2026-01-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-31 00:00:05", "last_data": "2026-01-31 13:00:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1629520, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-02/", "name": "dt", "value": "2026-02-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-02 11:55:01", "last_data": "2026-02-02 12:00:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1629893, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-04/", "name": "dt", "value": "2026-02-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-03 20:59:32", "last_data": "2026-02-03 22:58:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1630114, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-05/", "name": "dt", "value": "2026-02-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-04 21:55:56", "last_data": "2026-02-04 21:55:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1630334, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-06/", "name": "dt", "value": "2026-02-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-05 22:52:48", "last_data": "2026-02-05 22:52:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1631437, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-11/", "name": "dt", "value": "2026-02-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-10 21:57:42", "last_data": "2026-02-10 21:57:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1632476, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-15/", "name": "dt", "value": "2026-02-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-14 20:00:10", "last_data": "2026-02-14 20:04:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1635624, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-19/", "name": "dt", "value": "2026-02-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-19 17:55:41", "last_data": "2026-02-19 17:55:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1636315, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-22/", "name": "dt", "value": "2026-02-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-22 12:00:33", "last_data": "2026-02-22 12:02:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1637097, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-25/", "name": "dt", "value": "2026-02-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-25 09:55:14", "last_data": "2026-02-25 09:55:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1637730, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-27/", "name": "dt", "value": "2026-02-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-26 19:57:16", "last_data": "2026-02-27 15:46:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1641121, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-28/", "name": "dt", "value": "2026-02-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-27 23:01:04", "last_data": "2026-02-27 23:01:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1641486, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-01/", "name": "dt", "value": "2026-03-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-01 12:51:29", "last_data": "2026-03-01 12:55:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1641925, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-03/", "name": "dt", "value": "2026-03-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-03 12:52:41", "last_data": "2026-03-03 13:03:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1642222, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-05/", "name": "dt", "value": "2026-03-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-04 20:00:16", "last_data": "2026-03-04 20:00:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1642704, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-07/", "name": "dt", "value": "2026-03-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-07 04:59:17", "last_data": "2026-03-07 04:59:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1643109, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-08/", "name": "dt", "value": "2026-03-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-08 18:00:45", "last_data": "2026-03-08 18:00:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1645902, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-15/", "name": "dt", "value": "2026-03-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-15 06:57:08", "last_data": "2026-03-15 13:03:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1648227, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-17/", "name": "dt", "value": "2026-03-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-17 10:58:25", "last_data": "2026-03-17 11:02:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1648694, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-19/", "name": "dt", "value": "2026-03-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-19 17:57:16", "last_data": "2026-03-19 17:57:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1648775, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-20/", "name": "dt", "value": "2026-03-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-20 01:01:31", "last_data": "2026-03-20 01:01:31" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1649875, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-24/", "name": "dt", "value": "2026-03-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-24 11:56:03", "last_data": "2026-03-24 12:04:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1650459, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-27/", "name": "dt", "value": "2026-03-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-27 06:47:44", "last_data": "2026-03-27 06:51:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1650639, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-28/", "name": "dt", "value": "2026-03-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-28 00:59:35", "last_data": "2026-03-28 00:59:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1650842, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-29/", "name": "dt", "value": "2026-03-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-28 22:59:08", "last_data": "2026-03-28 23:02:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1652149, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-04-01/", "name": "dt", "value": "2026-04-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-01 14:04:02", "last_data": "2026-04-01 14:04:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1652522, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-04-02/", "name": "dt", "value": "2026-04-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-02 11:00:07", "last_data": "2026-04-02 11:00:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1656896, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-04-07/", "name": "dt", "value": "2026-04-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-07 13:50:33", "last_data": "2026-04-07 13:53:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1658436, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-04-14/", "name": "dt", "value": "2026-04-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-13 19:55:04", "last_data": "2026-04-13 19:55:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } } ] - type: string
- attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.20on_20lineutm_campaign": "string", "context.campaign.c": "string", "context.campaign.cam": "string", "context.campaign.campaig": "string", "context.campaign.campaign_5B_5D": "string", "context.campaign.campaign_5b_5d": "string", "context.campaign.campaign__": "string", "context.campaign.capermpaign": "string", "context.campaign.clkid": "string", "context.campaign.colantent": "string", "context.campaign.content": "string", "context.campaign.content_5B_5D": "string", "context.campaign.content_5b_5d": "string", "context.campaign.content__": "string", "context.campaign.device": "string", "context.campaign.expid": "string", "context.campaign.id": "string", "context.campaign.keyword": "string", "context.campaign.mderreldium": "string", "context.campaign.medium": "string", "context.campaign.medium_5B_5D": "string", "context.campaign.medium_5b_5d": "string", "context.campaign.medium__": "string", "context.campaign.name": "string", "context.campaign.referrer": "string", "context.campaign.s_3A_2F_2Fstorage.com_2Fpaid_landing_2F_3Futm_source": "string", "context.campaign.s_3A_2F_2Fwww.selfstorage.com_2Flpg_2Flf_2Fhp_copy_3Futm_source": "string", "context.campaign.soue": "string", "context.campaign.sour": "string", "context.campaign.source": "string", "context.campaign.source_2020": "string", "context.campaign.source_5B_5D": "string", "context.campaign.source_5b_5d": "string", "context.campaign.source__": "string", "context.campaign.t": "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.campaign.utm_term": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.timezone": "string", "context.userAgent": "string", "context.userAgentData.brands": [ { "brand": "string", "version": "string" } ], "context.userAgentData.mobile": "string", "context.userAgentData.platform": "string", "event": "string", "integrations.All": "string", "integrations.Google_Analytics": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.CON.__cpLocation.city": "string", "properties.CON.__cpLocation.id": "string", "properties.CON.__cpLocation.state": "string", "properties.CON.__cpLocation.zip": "string", "properties.CON.environment": "string", "properties.CON.facility.id": "string", "properties.CON.facility.title": "string", "properties.CON.location.city": "string", "properties.CON.location.id": "string", "properties.CON.location.state": "string", "properties.CON.location.zip": "string", "properties.CON.page_subtype": "string", "properties.CON.page_type": "string", "properties.CON.ppc.adwords.date_end": "string", "properties.CON.ppc.adwords.date_start": "string", "properties.CON.ppc.adwords.page_type": "string", "properties.CON.search_result.id": "string", "properties.CON.search_result.listing_ids": [ "int" ], "properties.CON.search_result.page": "string", "properties.CON.search_result.query": "string", "properties.CON.site_content.id": "string", "properties.CON.site_id": "string", "properties.CON.site_type": "string", "properties.CON.timestamp": "string", "properties.CON.transaction.confirmation_code": "string", "properties.CON.transaction.email": "string", "properties.CON.transaction.id": "string", "properties.CON.transaction.npv": "string", "properties.CON.unit.id": "string", "properties.CON.unit.price": "string", "properties.CON.visit_id": "string", "properties.Hit_Timestamp": "string", "properties.env": "string", "properties.isReact": "string", "properties.site_id": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - created: 2025-04-15 08:58:19
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.ssdc_conpageview`\n(\n`integrations`struct<`Google_Analytics`:STRING,`All`:STRING>,`messageId`STRING,`type`STRING,`sentAt`STRING,`originalTimestamp`STRING,`timestamp`STRING,`_origin`STRING,`context`struct<`library`:struct<`version`:STRING,`name`:STRING>,`campaign`:struct<`mderreldium`:STRING,`cam`:STRING,`medium_5B_5D`:STRING,`medium_5b_5d`:STRING,`colantent`:STRING,`expid`:STRING,`utm_term`:STRING,`source_5b_5d`:STRING,`source_2020`:STRING,`utm_content`:STRING,`device`:STRING,`utm_medium`:STRING,`medium`:STRING,`referrer`:STRING,`utm_campaign`:STRING,`medium__`:STRING,`content`:STRING,`keyword`:STRING,`content__`:STRING,`term`:STRING,`sour`:STRING,`id`:STRING,`clkid`:STRING,`campaig`:STRING,`content_5b_5d`:STRING,`campaign__`:STRING,`utm_source`:STRING,`s_3A_2F_2Fwww`:struct<`selfstorage`:struct<`com_2Flpg_2Flf_2Fhp_copy_3Futm_source`:STRING>>,`campaign_5B_5D`:STRING,`capermpaign`:STRING,`t`:STRING,`s_3A_2F_2Fstorage`:struct<`com_2Fpaid_landing_2F_3Futm_source`:STRING>,`source`:STRING,`source_5B_5D`:STRING,`c`:STRING,`soue`:STRING,`campaign_5b_5d`:STRING,`source__`:STRING,`content_5B_5D`:STRING,`name`:STRING,`20on_20lineutm_campaign`:STRING>,`locale`:STRING,`userAgentData`:struct<`mobile`:STRING,`brands`:array>>,`isReact`:STRING,`site_id`:STRING,`env`:STRING>,`projectId`STRING,`receivedAt`STRING,`userId`STRING,`event`STRING,`anonymousId`STRING,`channel`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-ssdc-prod/separated_dt/CON PAGEVIEW'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.ssdc_conpageview`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.ssdc_conpageview" }
- 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:29:59",
"disabled": false,
"format": "raw",
"id": 839,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_prod_segment",
"table": "ssdc_conpageview"
},
"type": "segment"
},
"partition": {
"count": 110,
"ddl": [
"ALTER TABLE\n `sfdl_prod_segment.ssdc_conpageview`\nADD\n\n\n PARTITION (dt='2025-10-15') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-15/'\n PARTITION (dt='2025-10-16') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-16/'\n PARTITION (dt='2025-10-17') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-17/'\n PARTITION (dt='2025-10-18') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-18/'\n PARTITION (dt='2025-10-19') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-19/'\n PARTITION (dt='2025-10-20') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-20/'\n PARTITION (dt='2025-10-22') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-22/'\n PARTITION (dt='2025-10-26') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-26/'\n PARTITION (dt='2025-10-28') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-28/'\n PARTITION (dt='2025-10-29') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-29/'\n PARTITION (dt='2025-10-30') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-30/'\n PARTITION (dt='2025-11-01') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-01/'\n PARTITION (dt='2025-11-02') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-02/'\n PARTITION (dt='2025-11-03') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-03/'\n PARTITION (dt='2025-11-04') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-04/'\n PARTITION (dt='2025-11-05') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-05/'\n PARTITION (dt='2025-11-07') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-07/'\n PARTITION (dt='2025-11-08') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-08/'\n PARTITION (dt='2025-11-09') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-09/'\n PARTITION (dt='2025-11-10') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-10/'\n PARTITION (dt='2025-11-11') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-11/'\n PARTITION (dt='2025-11-12') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-12/'\n PARTITION (dt='2025-11-13') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-13/'\n PARTITION (dt='2025-11-14') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-14/'\n PARTITION (dt='2025-11-16') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-16/'\n PARTITION (dt='2025-11-17') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-17/'\n PARTITION (dt='2025-11-19') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-19/'\n PARTITION (dt='2025-11-21') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-21/'\n PARTITION (dt='2025-11-22') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-22/'\n PARTITION (dt='2025-11-23') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-23/'\n PARTITION (dt='2025-11-24') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-24/'\n PARTITION (dt='2025-11-25') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-25/'\n PARTITION (dt='2025-11-27') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-27/'\n PARTITION (dt='2025-11-28') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-28/'\n PARTITION (dt='2025-11-29') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-29/'\n PARTITION (dt='2025-11-30') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-30/'\n PARTITION (dt='2025-12-01') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-01/'\n PARTITION (dt='2025-12-02') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-02/'\n PARTITION (dt='2025-12-03') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-03/'\n PARTITION (dt='2025-12-04') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-04/'\n PARTITION (dt='2025-12-05') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-05/'\n PARTITION (dt='2025-12-06') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-06/'\n PARTITION (dt='2025-12-07') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-07/'\n PARTITION (dt='2025-12-08') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-08/'\n PARTITION (dt='2025-12-10') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-10/'\n PARTITION (dt='2025-12-11') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-11/'\n PARTITION (dt='2025-12-12') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-12/'\n PARTITION (dt='2025-12-13') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-13/'\n PARTITION (dt='2025-12-17') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-17/'\n PARTITION (dt='2025-12-18') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-18/'\n PARTITION (dt='2025-12-19') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-19/'\n PARTITION (dt='2025-12-22') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-22/'\n PARTITION (dt='2025-12-24') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-24/'\n PARTITION (dt='2025-12-25') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-25/'\n PARTITION (dt='2025-12-26') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-26/'\n PARTITION (dt='2025-12-27') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-27/'\n PARTITION (dt='2025-12-28') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-28/'\n PARTITION (dt='2025-12-30') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-30/'\n PARTITION (dt='2025-12-31') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-31/'\n PARTITION (dt='2026-01-01') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-01/'\n PARTITION (dt='2026-01-03') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-03/'\n PARTITION (dt='2026-01-04') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-04/'\n PARTITION (dt='2026-01-06') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-06/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-07/'\n PARTITION (dt='2026-01-09') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-09/'\n PARTITION (dt='2026-01-11') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-11/'\n PARTITION (dt='2026-01-12') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-12/'\n PARTITION (dt='2026-01-13') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-13/'\n PARTITION (dt='2026-01-14') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-14/'\n PARTITION (dt='2026-01-16') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-16/'\n PARTITION (dt='2026-01-19') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-19/'\n PARTITION (dt='2026-01-20') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-20/'\n PARTITION (dt='2026-01-21') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-21/'\n PARTITION (dt='2026-01-23') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-23/'\n PARTITION (dt='2026-01-24') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-24/'\n PARTITION (dt='2026-01-25') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-25/'\n PARTITION (dt='2026-01-26') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-26/'\n PARTITION (dt='2026-01-27') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-27/'\n PARTITION (dt='2026-01-28') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-28/'\n PARTITION (dt='2026-01-29') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-29/'\n PARTITION (dt='2026-01-30') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-30/'\n PARTITION (dt='2026-01-31') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-31/'\n PARTITION (dt='2026-02-02') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-02/'\n PARTITION (dt='2026-02-04') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-04/'\n PARTITION (dt='2026-02-05') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-05/'\n PARTITION (dt='2026-02-06') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-06/'\n PARTITION (dt='2026-02-11') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-11/'\n PARTITION (dt='2026-02-15') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-15/'\n PARTITION (dt='2026-02-19') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-19/'\n PARTITION (dt='2026-02-22') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-22/'\n PARTITION (dt='2026-02-25') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-25/'\n PARTITION (dt='2026-02-27') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-27/'\n PARTITION (dt='2026-02-28') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-28/'\n PARTITION (dt='2026-03-01') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-01/'\n PARTITION (dt='2026-03-03') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-03/'\n PARTITION (dt='2026-03-05') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-05/'\n PARTITION (dt='2026-03-07') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-07/'\n PARTITION (dt='2026-03-08') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-08/'\n PARTITION (dt='2026-03-15') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-15/'\n PARTITION (dt='2026-03-17') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-17/'\n PARTITION (dt='2026-03-19') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-19/'\n PARTITION (dt='2026-03-20') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-20/'\n PARTITION (dt='2026-03-24') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-24/'\n PARTITION (dt='2026-03-27') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-27/'\n PARTITION (dt='2026-03-28') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-28/'\n PARTITION (dt='2026-03-29') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-29/'\n PARTITION (dt='2026-04-01') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-04-01/'\n PARTITION (dt='2026-04-02') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-04-02/'\n PARTITION (dt='2026-04-07') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-04-07/'\n PARTITION (dt='2026-04-14') location 's3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-04-14/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 1566048,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-15/",
"name": "dt",
"value": "2025-10-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-15 03:57:41",
"last_data": "2025-10-15 03:57:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1566407,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-16/",
"name": "dt",
"value": "2025-10-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-16 13:48:10",
"last_data": "2025-10-16 13:51:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1595801,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-17/",
"name": "dt",
"value": "2025-10-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-17 14:03:08",
"last_data": "2025-10-17 14:18:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1595898,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-18/",
"name": "dt",
"value": "2025-10-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-18 01:53:30",
"last_data": "2025-10-18 15:49:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1596147,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-19/",
"name": "dt",
"value": "2025-10-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-18 22:54:54",
"last_data": "2025-10-19 16:59:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1596737,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-20/",
"name": "dt",
"value": "2025-10-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-20 05:17:07",
"last_data": "2025-10-20 05:17:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1597165,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-22/",
"name": "dt",
"value": "2025-10-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-21 19:59:31",
"last_data": "2025-10-22 12:15:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1598112,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-26/",
"name": "dt",
"value": "2025-10-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-25 19:54:44",
"last_data": "2025-10-26 18:18:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1598615,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-28/",
"name": "dt",
"value": "2025-10-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-27 21:09:03",
"last_data": "2025-10-27 21:18:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1598995,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-29/",
"name": "dt",
"value": "2025-10-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-29 14:12:44",
"last_data": "2025-10-29 18:25:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1599090,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-10-30/",
"name": "dt",
"value": "2025-10-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-29 22:03:53",
"last_data": "2025-10-29 22:03:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1599902,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-01/",
"name": "dt",
"value": "2025-11-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-01 15:53:54",
"last_data": "2025-11-01 15:55:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1600010,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-02/",
"name": "dt",
"value": "2025-11-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-02 02:55:25",
"last_data": "2025-11-02 18:08:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1600266,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-03/",
"name": "dt",
"value": "2025-11-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-03 05:52:10",
"last_data": "2025-11-03 05:59:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1600614,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-04/",
"name": "dt",
"value": "2025-11-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-04 11:02:02",
"last_data": "2025-11-04 11:08:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1600710,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-05/",
"name": "dt",
"value": "2025-11-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-04 21:15:04",
"last_data": "2025-11-04 21:15:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1601232,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-07/",
"name": "dt",
"value": "2025-11-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-07 06:53:36",
"last_data": "2025-11-07 06:53:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1601528,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-08/",
"name": "dt",
"value": "2025-11-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-08 09:02:16",
"last_data": "2025-11-08 16:42:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1601826,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-09/",
"name": "dt",
"value": "2025-11-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-09 16:12:11",
"last_data": "2025-11-09 16:29:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1601915,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-10/",
"name": "dt",
"value": "2025-11-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-09 20:05:53",
"last_data": "2025-11-09 20:13:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1602303,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-11/",
"name": "dt",
"value": "2025-11-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-11 16:06:29",
"last_data": "2025-11-11 16:06:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1602368,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-12/",
"name": "dt",
"value": "2025-11-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-11 19:06:33",
"last_data": "2025-11-12 14:05:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1602634,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-13/",
"name": "dt",
"value": "2025-11-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-13 00:03:15",
"last_data": "2025-11-13 17:00:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1602879,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-14/",
"name": "dt",
"value": "2025-11-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-14 03:01:53",
"last_data": "2025-11-14 18:27:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1605678,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-16/",
"name": "dt",
"value": "2025-11-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-16 18:01:19",
"last_data": "2025-11-16 18:02:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1605811,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-17/",
"name": "dt",
"value": "2025-11-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-17 08:00:40",
"last_data": "2025-11-17 08:06:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1606339,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-19/",
"name": "dt",
"value": "2025-11-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-19 09:05:55",
"last_data": "2025-11-19 17:00:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1606874,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-21/",
"name": "dt",
"value": "2025-11-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-21 11:02:59",
"last_data": "2025-11-21 11:02:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1607553,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-22/",
"name": "dt",
"value": "2025-11-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-22 06:47:09",
"last_data": "2025-11-22 06:47:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1607895,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-23/",
"name": "dt",
"value": "2025-11-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-23 10:04:02",
"last_data": "2025-11-23 10:04:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1608130,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-24/",
"name": "dt",
"value": "2025-11-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-24 12:02:08",
"last_data": "2025-11-24 12:07:32"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1608225,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-25/",
"name": "dt",
"value": "2025-11-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-24 20:53:00",
"last_data": "2025-11-24 21:01:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1608663,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-27/",
"name": "dt",
"value": "2025-11-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-26 19:02:49",
"last_data": "2025-11-27 16:05:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1608919,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-28/",
"name": "dt",
"value": "2025-11-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-28 00:09:21",
"last_data": "2025-11-28 00:13:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1609294,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-29/",
"name": "dt",
"value": "2025-11-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-29 14:02:56",
"last_data": "2025-11-29 14:06:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1609382,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-11-30/",
"name": "dt",
"value": "2025-11-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-30 00:53:01",
"last_data": "2025-11-30 18:01:26"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1609600,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-01/",
"name": "dt",
"value": "2025-12-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-30 20:03:33",
"last_data": "2025-12-01 17:13:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1610001,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-02/",
"name": "dt",
"value": "2025-12-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-02 17:24:52",
"last_data": "2025-12-02 17:33:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1610075,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-03/",
"name": "dt",
"value": "2025-12-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-02 19:10:57",
"last_data": "2025-12-03 08:57:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1610386,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-04/",
"name": "dt",
"value": "2025-12-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-04 07:03:29",
"last_data": "2025-12-04 07:07:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1610712,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-05/",
"name": "dt",
"value": "2025-12-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-05 14:54:08",
"last_data": "2025-12-05 17:58:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1611093,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-06/",
"name": "dt",
"value": "2025-12-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-06 02:13:53",
"last_data": "2025-12-06 07:08:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1611460,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-07/",
"name": "dt",
"value": "2025-12-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-07 18:06:11",
"last_data": "2025-12-07 18:06:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1611551,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-08/",
"name": "dt",
"value": "2025-12-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-08 02:01:47",
"last_data": "2025-12-08 15:31:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1612265,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-10/",
"name": "dt",
"value": "2025-12-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-09 21:02:07",
"last_data": "2025-12-10 14:40:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1612502,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-11/",
"name": "dt",
"value": "2025-12-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-10 19:59:07",
"last_data": "2025-12-10 19:59:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1612848,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-12/",
"name": "dt",
"value": "2025-12-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-12 09:11:44",
"last_data": "2025-12-12 09:11:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1613201,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-13/",
"name": "dt",
"value": "2025-12-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-13 14:45:41",
"last_data": "2025-12-13 14:45:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1616597,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-17/",
"name": "dt",
"value": "2025-12-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-17 08:08:22",
"last_data": "2025-12-17 12:02:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1616806,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-18/",
"name": "dt",
"value": "2025-12-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-18 05:01:56",
"last_data": "2025-12-18 16:44:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1617127,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-19/",
"name": "dt",
"value": "2025-12-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-19 14:53:14",
"last_data": "2025-12-19 14:53:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1617667,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-22/",
"name": "dt",
"value": "2025-12-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-21 21:06:01",
"last_data": "2025-12-21 21:52:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1618172,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-24/",
"name": "dt",
"value": "2025-12-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-24 09:00:06",
"last_data": "2025-12-24 09:00:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1618315,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-25/",
"name": "dt",
"value": "2025-12-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-24 22:53:54",
"last_data": "2025-12-24 22:53:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1618518,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-26/",
"name": "dt",
"value": "2025-12-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-25 20:01:41",
"last_data": "2025-12-25 20:01:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1618744,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-27/",
"name": "dt",
"value": "2025-12-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-26 21:01:53",
"last_data": "2025-12-26 21:01:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1618992,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-28/",
"name": "dt",
"value": "2025-12-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-28 06:57:49",
"last_data": "2025-12-28 12:04:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1619431,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-30/",
"name": "dt",
"value": "2025-12-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-30 01:01:05",
"last_data": "2025-12-30 14:00:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1619678,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2025-12-31/",
"name": "dt",
"value": "2025-12-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-31 06:00:05",
"last_data": "2025-12-31 06:00:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1620014,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-01/",
"name": "dt",
"value": "2026-01-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-01 12:05:03",
"last_data": "2026-01-01 12:06:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1620310,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-03/",
"name": "dt",
"value": "2026-01-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-02 19:56:02",
"last_data": "2026-01-02 19:56:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1620664,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-04/",
"name": "dt",
"value": "2026-01-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-04 18:41:16",
"last_data": "2026-01-04 18:41:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1621094,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-06/",
"name": "dt",
"value": "2026-01-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-06 11:57:52",
"last_data": "2026-01-06 12:03:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1621222,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-07/",
"name": "dt",
"value": "2026-01-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-07 05:57:46",
"last_data": "2026-01-07 13:56:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1621743,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-09/",
"name": "dt",
"value": "2026-01-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-09 14:32:49",
"last_data": "2026-01-09 14:32:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1622080,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-11/",
"name": "dt",
"value": "2026-01-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-11 02:57:34",
"last_data": "2026-01-11 13:04:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1622299,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-12/",
"name": "dt",
"value": "2026-01-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-11 21:55:01",
"last_data": "2026-01-12 13:56:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1622776,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-13/",
"name": "dt",
"value": "2026-01-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-13 14:52:46",
"last_data": "2026-01-13 16:51:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1622994,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-14/",
"name": "dt",
"value": "2026-01-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-14 15:44:57",
"last_data": "2026-01-14 15:47:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1625584,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-16/",
"name": "dt",
"value": "2026-01-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-16 09:57:06",
"last_data": "2026-01-16 09:57:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1626437,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-19/",
"name": "dt",
"value": "2026-01-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-19 10:54:02",
"last_data": "2026-01-19 10:54:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1626521,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-20/",
"name": "dt",
"value": "2026-01-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-19 22:55:30",
"last_data": "2026-01-19 22:55:30"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1626913,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-21/",
"name": "dt",
"value": "2026-01-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-21 15:58:53",
"last_data": "2026-01-21 16:04:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1627173,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-23/",
"name": "dt",
"value": "2026-01-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-22 18:55:05",
"last_data": "2026-01-22 18:55:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1627554,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-24/",
"name": "dt",
"value": "2026-01-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-24 12:51:56",
"last_data": "2026-01-24 12:51:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1627769,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-25/",
"name": "dt",
"value": "2026-01-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-25 12:54:23",
"last_data": "2026-01-25 12:54:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1627884,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-26/",
"name": "dt",
"value": "2026-01-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-26 05:58:27",
"last_data": "2026-01-26 05:58:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1628105,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-27/",
"name": "dt",
"value": "2026-01-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-27 04:51:38",
"last_data": "2026-01-27 04:51:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1628283,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-28/",
"name": "dt",
"value": "2026-01-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-27 20:03:07",
"last_data": "2026-01-28 18:37:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1628503,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-29/",
"name": "dt",
"value": "2026-01-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-28 21:56:34",
"last_data": "2026-01-29 12:54:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1628873,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-30/",
"name": "dt",
"value": "2026-01-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-30 13:55:45",
"last_data": "2026-01-30 18:34:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1628957,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-01-31/",
"name": "dt",
"value": "2026-01-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-31 00:00:05",
"last_data": "2026-01-31 13:00:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1629520,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-02/",
"name": "dt",
"value": "2026-02-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-02 11:55:01",
"last_data": "2026-02-02 12:00:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1629893,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-04/",
"name": "dt",
"value": "2026-02-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-03 20:59:32",
"last_data": "2026-02-03 22:58:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1630114,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-05/",
"name": "dt",
"value": "2026-02-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-04 21:55:56",
"last_data": "2026-02-04 21:55:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1630334,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-06/",
"name": "dt",
"value": "2026-02-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-05 22:52:48",
"last_data": "2026-02-05 22:52:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1631437,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-11/",
"name": "dt",
"value": "2026-02-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-10 21:57:42",
"last_data": "2026-02-10 21:57:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1632476,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-15/",
"name": "dt",
"value": "2026-02-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-14 20:00:10",
"last_data": "2026-02-14 20:04:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1635624,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-19/",
"name": "dt",
"value": "2026-02-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-19 17:55:41",
"last_data": "2026-02-19 17:55:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1636315,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-22/",
"name": "dt",
"value": "2026-02-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-22 12:00:33",
"last_data": "2026-02-22 12:02:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1637097,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-25/",
"name": "dt",
"value": "2026-02-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-25 09:55:14",
"last_data": "2026-02-25 09:55:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1637730,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-27/",
"name": "dt",
"value": "2026-02-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-26 19:57:16",
"last_data": "2026-02-27 15:46:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1641121,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-02-28/",
"name": "dt",
"value": "2026-02-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-27 23:01:04",
"last_data": "2026-02-27 23:01:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1641486,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-01/",
"name": "dt",
"value": "2026-03-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-01 12:51:29",
"last_data": "2026-03-01 12:55:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1641925,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-03/",
"name": "dt",
"value": "2026-03-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-03 12:52:41",
"last_data": "2026-03-03 13:03:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1642222,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-05/",
"name": "dt",
"value": "2026-03-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-04 20:00:16",
"last_data": "2026-03-04 20:00:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1642704,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-07/",
"name": "dt",
"value": "2026-03-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-07 04:59:17",
"last_data": "2026-03-07 04:59:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1643109,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-08/",
"name": "dt",
"value": "2026-03-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-08 18:00:45",
"last_data": "2026-03-08 18:00:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1645902,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-15/",
"name": "dt",
"value": "2026-03-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-15 06:57:08",
"last_data": "2026-03-15 13:03:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1648227,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-17/",
"name": "dt",
"value": "2026-03-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-17 10:58:25",
"last_data": "2026-03-17 11:02:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1648694,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-19/",
"name": "dt",
"value": "2026-03-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-19 17:57:16",
"last_data": "2026-03-19 17:57:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1648775,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-20/",
"name": "dt",
"value": "2026-03-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-20 01:01:31",
"last_data": "2026-03-20 01:01:31"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1649875,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-24/",
"name": "dt",
"value": "2026-03-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-24 11:56:03",
"last_data": "2026-03-24 12:04:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1650459,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-27/",
"name": "dt",
"value": "2026-03-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-27 06:47:44",
"last_data": "2026-03-27 06:51:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1650639,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-28/",
"name": "dt",
"value": "2026-03-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-28 00:59:35",
"last_data": "2026-03-28 00:59:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1650842,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-03-29/",
"name": "dt",
"value": "2026-03-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-28 22:59:08",
"last_data": "2026-03-28 23:02:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1652149,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-04-01/",
"name": "dt",
"value": "2026-04-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-01 14:04:02",
"last_data": "2026-04-01 14:04:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1652522,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-04-02/",
"name": "dt",
"value": "2026-04-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-02 11:00:07",
"last_data": "2026-04-02 11:00:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1656896,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-04-07/",
"name": "dt",
"value": "2026-04-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-07 13:50:33",
"last_data": "2026-04-07 13:53:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1658436,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/CON PAGEVIEW/dt=2026-04-14/",
"name": "dt",
"value": "2026-04-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-13 19:55:04",
"last_data": "2026-04-13 19:55:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
}
],
"type": "string"
},
"schema": {
"attributes": {
"_origin": "string",
"anonymousId": "string",
"channel": "string",
"context.campaign.20on_20lineutm_campaign": "string",
"context.campaign.c": "string",
"context.campaign.cam": "string",
"context.campaign.campaig": "string",
"context.campaign.campaign_5B_5D": "string",
"context.campaign.campaign_5b_5d": "string",
"context.campaign.campaign__": "string",
"context.campaign.capermpaign": "string",
"context.campaign.clkid": "string",
"context.campaign.colantent": "string",
"context.campaign.content": "string",
"context.campaign.content_5B_5D": "string",
"context.campaign.content_5b_5d": "string",
"context.campaign.content__": "string",
"context.campaign.device": "string",
"context.campaign.expid": "string",
"context.campaign.id": "string",
"context.campaign.keyword": "string",
"context.campaign.mderreldium": "string",
"context.campaign.medium": "string",
"context.campaign.medium_5B_5D": "string",
"context.campaign.medium_5b_5d": "string",
"context.campaign.medium__": "string",
"context.campaign.name": "string",
"context.campaign.referrer": "string",
"context.campaign.s_3A_2F_2Fstorage.com_2Fpaid_landing_2F_3Futm_source": "string",
"context.campaign.s_3A_2F_2Fwww.selfstorage.com_2Flpg_2Flf_2Fhp_copy_3Futm_source": "string",
"context.campaign.soue": "string",
"context.campaign.sour": "string",
"context.campaign.source": "string",
"context.campaign.source_2020": "string",
"context.campaign.source_5B_5D": "string",
"context.campaign.source_5b_5d": "string",
"context.campaign.source__": "string",
"context.campaign.t": "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.campaign.utm_term": "string",
"context.ip": "string",
"context.library.name": "string",
"context.library.version": "string",
"context.locale": "string",
"context.page.path": "string",
"context.page.referrer": "string",
"context.page.search": "string",
"context.page.title": "string",
"context.page.url": "string",
"context.timezone": "string",
"context.userAgent": "string",
"context.userAgentData.brands": [
{
"brand": "string",
"version": "string"
}
],
"context.userAgentData.mobile": "string",
"context.userAgentData.platform": "string",
"event": "string",
"integrations.All": "string",
"integrations.Google_Analytics": "string",
"messageId": "string",
"originalTimestamp": "string",
"projectId": "string",
"properties.CON.__cpLocation.city": "string",
"properties.CON.__cpLocation.id": "string",
"properties.CON.__cpLocation.state": "string",
"properties.CON.__cpLocation.zip": "string",
"properties.CON.environment": "string",
"properties.CON.facility.id": "string",
"properties.CON.facility.title": "string",
"properties.CON.location.city": "string",
"properties.CON.location.id": "string",
"properties.CON.location.state": "string",
"properties.CON.location.zip": "string",
"properties.CON.page_subtype": "string",
"properties.CON.page_type": "string",
"properties.CON.ppc.adwords.date_end": "string",
"properties.CON.ppc.adwords.date_start": "string",
"properties.CON.ppc.adwords.page_type": "string",
"properties.CON.search_result.id": "string",
"properties.CON.search_result.listing_ids": [
"int"
],
"properties.CON.search_result.page": "string",
"properties.CON.search_result.query": "string",
"properties.CON.site_content.id": "string",
"properties.CON.site_id": "string",
"properties.CON.site_type": "string",
"properties.CON.timestamp": "string",
"properties.CON.transaction.confirmation_code": "string",
"properties.CON.transaction.email": "string",
"properties.CON.transaction.id": "string",
"properties.CON.transaction.npv": "string",
"properties.CON.unit.id": "string",
"properties.CON.unit.price": "string",
"properties.CON.visit_id": "string",
"properties.Hit_Timestamp": "string",
"properties.env": "string",
"properties.isReact": "string",
"properties.site_id": "string",
"receivedAt": "string",
"sentAt": "string",
"timestamp": "string",
"type": "string",
"userId": "string",
"version": "string"
},
"created": "2025-04-15 08:58:19",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.ssdc_conpageview`\n(\n`integrations`struct<`Google_Analytics`:STRING,`All`:STRING>,`messageId`STRING,`type`STRING,`sentAt`STRING,`originalTimestamp`STRING,`timestamp`STRING,`_origin`STRING,`context`struct<`library`:struct<`version`:STRING,`name`:STRING>,`campaign`:struct<`mderreldium`:STRING,`cam`:STRING,`medium_5B_5D`:STRING,`medium_5b_5d`:STRING,`colantent`:STRING,`expid`:STRING,`utm_term`:STRING,`source_5b_5d`:STRING,`source_2020`:STRING,`utm_content`:STRING,`device`:STRING,`utm_medium`:STRING,`medium`:STRING,`referrer`:STRING,`utm_campaign`:STRING,`medium__`:STRING,`content`:STRING,`keyword`:STRING,`content__`:STRING,`term`:STRING,`sour`:STRING,`id`:STRING,`clkid`:STRING,`campaig`:STRING,`content_5b_5d`:STRING,`campaign__`:STRING,`utm_source`:STRING,`s_3A_2F_2Fwww`:struct<`selfstorage`:struct<`com_2Flpg_2Flf_2Fhp_copy_3Futm_source`:STRING>>,`campaign_5B_5D`:STRING,`capermpaign`:STRING,`t`:STRING,`s_3A_2F_2Fstorage`:struct<`com_2Fpaid_landing_2F_3Futm_source`:STRING>,`source`:STRING,`source_5B_5D`:STRING,`c`:STRING,`soue`:STRING,`campaign_5b_5d`:STRING,`source__`:STRING,`content_5B_5D`:STRING,`name`:STRING,`20on_20lineutm_campaign`:STRING>,`locale`:STRING,`userAgentData`:struct<`mobile`:STRING,`brands`:array>,`platform`:STRING>,`timezone`:STRING,`page`:struct<`title`:STRING,`search`:STRING,`referrer`:STRING,`path`:STRING,`url`:STRING>,`ip`:STRING,`userAgent`:STRING>,`version`STRING,`properties`struct<`Hit_Timestamp`:STRING,`CON`:struct<`unit`:struct<`id`:STRING,`price`:STRING>,`facility`:struct<`title`:STRING,`id`:STRING>,`site_content`:struct<`id`:STRING>,`timestamp`:STRING,`__cpLocation`:struct<`zip`:STRING,`id`:STRING,`city`:STRING,`state`:STRING>,`ppc`:struct<`adwords`:struct<`page_type`:STRING,`date_end`:STRING,`date_start`:STRING>>,`page_type`:STRING,`transaction`:struct<`npv`:STRING,`id`:STRING,`email`:STRING,`confirmation_code`:STRING>,`environment`:STRING,`page_subtype`:STRING,`site_type`:STRING,`location`:struct<`id`:STRING,`city`:STRING,`zip`:STRING,`state`:STRING>,`site_id`:STRING,`visit_id`:STRING,`search_result`:struct<`page`:STRING,`id`:STRING,`query`:STRING,`listing_ids`:array>>,`isReact`:STRING,`site_id`:STRING,`env`:STRING>,`projectId`STRING,`receivedAt`STRING,`userId`STRING,`event`STRING,`anonymousId`STRING,`channel`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-ssdc-prod/separated_dt/CON PAGEVIEW'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.ssdc_conpageview`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.ssdc_conpageview"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}