Schema Info
Schema Name: sfdl_prod_segment.ssdc_productclicked
- created: 2021-02-11 16:27:53
- disabled: False
- format: raw
- id: 836
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_prod_segment", "table": "ssdc_productclicked" } - type: segment
Schema Versions: 3
-
Version 1149041
- created: 2025-01-05 23:55:12
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "DROP TABLE IF EXISTS `sfdl_prod_segment.ssdc_productclicked`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.ssdc_productclicked`\n(\n`_origin`STRING,`version`STRING,`receivedAt`STRING,`timestamp`STRING,`anonymousId`STRING,`projectId`STRING,`userId`STRING,`messageId`STRING,`type`STRING,`sentAt`STRING,`event`STRING,`originalTimestamp`STRING,`channel`STRING,`context`struct<`library`:struct<`name`:STRING,`version`:STRING>,`page`:struct<`url`:STRING,`title`:STRING,`path`:STRING,`referrer`:STRING,`search`:STRING>,`timezone`:STRING,`locale`:STRING,`userAgentData`:struct<`platform`:STRING,`mobile`:STRING,`brands`:array - hive_path: s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked
- id: 1149041
- processed: 1
- raw_data:
{ "__segment_internal": {}, "_metadata": { "bundled": [ "Google Tag Manager", "Segment.io" ], "bundledIds": [ "5aba5e646e396464865d9ca3" ], "unbundled": [] }, "_origin": "2025-01-06T05:54:45Z|s3://sfdl-segment-ssdc-prod/segment-logs/5yGJd9z7eL/1736121600000/1736142733981.events-archiver-480-4..1817457d-18a8-46f6-8ce7-aec1cf06ae3c.gz|analytics-segment-separator-prod:$LATEST", "anonymousId": "692e730f-c2fa-4a34-a0ac-55cb0c7a8061", "channel": "client", "context": { "campaign": { "content": "Self Storage Interest 2", "id": "120211779234010078", "medium": "paid", "name": "SSDC Facebook|Storage Interest Audience", "source": "facebook", "term": "120214062341980078" }, "ip": "96.241.125.97", "library": { "name": "analytics.js", "version": "next-1.76.0" }, "locale": "en-US", "page": { "path": "/self-storage/maryland/rockville/495-self-storage-north-bethesda-227750/", "referrer": "https://www.selfstorage.com/search?distance=10&listingsPerPage=30&location=20854&page=1&sort=price&type=vehicle", "search": "", "title": "495 Self Storage - North Bethesda: Lowest Rates - SelfStorage.com", "url": "https://www.selfstorage.com/self-storage/maryland/rockville/495-self-storage-north-bethesda-227750/" }, "timezone": "America/New_York", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36", "userAgentData": { "brands": [ { "brand": "Google Chrome", "version": "131" }, { "brand": "Chromium", "version": "131" }, { "brand": "Not_A Brand", "version": "24" } ], "mobile": false, "platform": "Windows" } }, "event": "Product Clicked", "integrations": {}, "messageId": "ajs-next-1736139269409-88450e5d-1c6e-45c0-87da-e6d71c0e88ac", "originalTimestamp": "2025-01-06T04:54:29.409Z", "projectId": "5yGJd9z7eL", "properties": { "Hit Timestamp": 1736139269408, "brand": "self-storage", "category": "Rockville, MD", "env": "production", "isReact": true, "list": "undefined: undefined", "name": "Public Storage - Rockville - 5420 Randolph Road - 214819", "position": 5, "price": null, "product_id": 214819, "quantity": 1, "site_id": 27, "variant": null }, "receivedAt": "2025-01-06T04:54:39.656Z", "sentAt": "2025-01-06T04:54:29.467Z", "timestamp": "2025-01-06T04:54:39.598Z", "type": "track", "userId": "f47643eb5aafdf1d5be0c1d354e4da13", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.campaign__": "string", "context.campaign.content": "string", "context.campaign.content__": "string", "context.campaign.id": "string", "context.campaign.medium": "string", "context.campaign.medium__": "string", "context.campaign.name": "string", "context.campaign.source": "string", "context.campaign.source__": "string", "context.campaign.term": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.timezone": "string", "context.userAgent": "string", "context.userAgentData.brands": [ { "brand": "string", "version": "string" } ], "context.userAgentData.mobile": "string", "context.userAgentData.platform": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.brand": "string", "properties.category": "string", "properties.env": "string", "properties.id": "string", "properties.inNetwork": "string", "properties.isReact": "string", "properties.label": "string", "properties.list": "string", "properties.name": "string", "properties.position": "string", "properties.price": "string", "properties.product_id": "string", "properties.quantity": "string", "properties.rank": "string", "properties.search_id": "string", "properties.site_id": "string", "properties.variant": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 836
- schema_scan_id: 134852761
- updated: 2025-01-05 23:56:17
-
Version 962714
- created: 2024-07-31 01:07:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "DROP TABLE IF EXISTS `sfdl_prod_segment.ssdc_productclicked`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.ssdc_productclicked`\n(\n`channel`STRING,`_origin`STRING,`type`STRING,`sentAt`STRING,`projectId`STRING,`context`struct<`locale`:STRING,`campaign`:struct<`medium__`:STRING,`name`:STRING,`source__`:STRING,`term`:STRING,`campaign__`:STRING,`content__`:STRING,`medium`:STRING,`source`:STRING,`content`:STRING>,`timezone`:STRING,`userAgent`:STRING,`library`:struct<`version`:STRING,`name`:STRING>,`page`:struct<`title`:STRING,`path`:STRING,`search`:STRING,`url`:STRING,`referrer`:STRING>,`ip`:STRING,`userAgentData`:struct<`mobile`:STRING,`brands`:array - hive_path: s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked
- id: 962714
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "evfdze8kT9", "5aba5e646e396464865d9ca3" ], "unbundled": [] }, "_origin": "2024-07-31T06:07:26Z|s3://sfdl-segment-ssdc-prod/segment-logs/5yGJd9z7eL/1722384000000/1722405965566.events-archiver-480-39..a182a08a-706d-4b7d-b65c-c4e7964ccfa2.gz|analytics-segment-separator-prod:$LATEST", "anonymousId": "0344f626-84c9-4b95-b7d4-fc3d7056063b", "channel": "client", "context": { "campaign": { "content": "", "medium": "paidsearch", "name": "SSDC Bing|PMAX", "source": "bing", "term": "www.selfstorage.com" }, "ip": "98.37.82.29", "library": { "name": "analytics.js", "version": "next-1.72.1" }, "locale": "en-US", "page": { "path": "/self-storage/california/san-bernardino/", "referrer": "https://www.bing.com/", "search": "?city=San%20Bernardino&latitude=34.1402037&location=San%20Bernardino%2C%20CA%2092405%2C%20USA&locationSource=google_autocomplete&longitude=-117.2970026&state=CA&zip=92405&tsid=bing-ppc&cid=SSDC%20Bing%7CPMAX&utm_source=bing&utm_medium=paidsearch&utm_campaign=SSDC%20Bing%7CPMAX&utm_content=&ploc=87648&iloc=&mkwid=|pcrid|76622414739607|pkw|www.selfstorage.com|pmt|bb|pdv|m|pgrid|1225956516578609|ptaid|kwd-2328422030783152:loc-190&pgrid=1225956516578609&ptaid=kwd-2328422030783152:loc-190&msclkid=85f665e6a30c18761560034f640ffd91&utm_term=www.selfstorage.com", "title": "SelfStorage.com: Find Cheap Storage Units Near You", "url": "https://www.selfstorage.com/self-storage/california/san-bernardino/?city=San%20Bernardino&latitude=34.1402037&location=San%20Bernardino%2C%20CA%2092405%2C%20USA&locationSource=google_autocomplete&longitude=-117.2970026&state=CA&zip=92405&tsid=bing-ppc&cid=SSDC%20Bing%7CPMAX&utm_source=bing&utm_medium=paidsearch&utm_campaign=SSDC%20Bing%7CPMAX&utm_content=&ploc=87648&iloc=&mkwid=|pcrid|76622414739607|pkw|www.selfstorage.com|pmt|bb|pdv|m|pgrid|1225956516578609|ptaid|kwd-2328422030783152:loc-190&pgrid=1225956516578609&ptaid=kwd-2328422030783152:loc-190&msclkid=85f665e6a30c18761560034f640ffd91&utm_term=www.selfstorage.com" }, "timezone": "America/Los_Angeles", "userAgent": "Mozilla/5.0 (Linux; Android 11; GM1917 Build/QQ3A.200705.002; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/103.0.5060.122 Mobile Safari/537.36", "userAgentData": { "brands": [ { "brand": "Not)A;Brand", "version": "99" }, { "brand": "Google Chrome", "version": "127" }, { "brand": "Chromium", "version": "127" } ], "mobile": false, "platform": "Android" } }, "event": "Product Clicked", "integrations": {}, "messageId": "ajs-next-1722402658729-999801b9-b4e1-4fe8-a2e5-70c7a06e11e4", "originalTimestamp": "2024-07-31T05:10:58.729Z", "projectId": "5yGJd9z7eL", "properties": { "Hit Timestamp": 1722405904944, "brand": "self-storage", "category": "Junction City, KS", "env": "production", "isReact": true, "list": "undefined: undefined", "name": "All-American Storage - 208531", "position": 1, "price": null, "product_id": 208531, "quantity": 1, "site_id": 27, "variant": null }, "receivedAt": "2024-07-31T05:10:59.284Z", "sentAt": "2024-07-31T05:10:58.874Z", "timestamp": "2024-07-31T05:10:59.139Z", "type": "track", "userId": "30b5835e26a76d0362c6a2db12dc2634", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.campaign__": "string", "context.campaign.content": "string", "context.campaign.content__": "string", "context.campaign.medium": "string", "context.campaign.medium__": "string", "context.campaign.name": "string", "context.campaign.source": "string", "context.campaign.source__": "string", "context.campaign.term": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.timezone": "string", "context.userAgent": "string", "context.userAgentData.brands": [ { "brand": "string", "version": "string" } ], "context.userAgentData.mobile": "string", "context.userAgentData.platform": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.brand": "string", "properties.category": "string", "properties.env": "string", "properties.id": "string", "properties.inNetwork": "string", "properties.isReact": "string", "properties.label": "string", "properties.list": "string", "properties.name": "string", "properties.position": "string", "properties.price": "string", "properties.product_id": "string", "properties.quantity": "string", "properties.rank": "string", "properties.search_id": "string", "properties.site_id": "string", "properties.variant": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 836
- schema_scan_id: 124155256
- updated: 2024-07-31 01:09:09
-
Version 677134
- created: 2023-11-16 14:51:27
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "DROP TABLE IF EXISTS `sfdl_prod_segment.ssdc_productclicked`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.ssdc_productclicked`\n(\n`event`STRING,`type`STRING,`timestamp`STRING,`version`STRING,`properties`struct<`quantity`:STRING,`product_id`:STRING,`search_id`:STRING,`price`:STRING,`variant`:STRING,`list`:STRING,`inNetwork`:STRING,`label`:STRING,`rank`:STRING,`id`:STRING,`category`:STRING,`isReact`:STRING,`brand`:STRING,`env`:STRING,`name`:STRING,`position`:STRING,`site_id`:STRING,`Hit_Timestamp`:STRING>,`projectId`STRING,`anonymousId`STRING,`originalTimestamp`STRING,`channel`STRING,`userId`STRING,`sentAt`STRING,`messageId`STRING,`receivedAt`STRING,`_origin`STRING,`context`struct<`page`:struct<`referrer`:STRING,`url`:STRING,`title`:STRING,`path`:STRING,`search`:STRING>,`campaign`:struct<`name`:STRING,`content__`:STRING,`campaign__`:STRING,`source__`:STRING,`medium`:STRING,`content`:STRING,`source`:STRING,`medium__`:STRING>,`userAgent`:STRING,`locale`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`userAgentData`:struct<`platform`:STRING,`mobile`:STRING,`brands`:array - hive_path: s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked
- id: 677134
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "evfdze8kT9", "5aba5e646e396464865d9ca3" ], "failedInitializations": [ "Google Analytics", "Google Tag Manager" ], "unbundled": [] }, "_origin": "2023-11-16T20:41:12Z|s3://sfdl-segment-ssdc-prod/segment-logs/5yGJd9z7eL/1700092800000/1700167052599.events-archiver-480-48..f029af4f-ffa5-4d52-80e2-c60447e6ba62.gz|analytics-segment-separator-prod:$LATEST", "anonymousId": "4f070eb0-cd18-4d98-9b7e-924ea5590ae0", "channel": "client", "context": { "campaign": {}, "ip": "98.208.135.60", "library": { "name": "analytics.js", "version": "next-1.55.0" }, "locale": "en-US", "page": { "path": "/self-storage/california/stockton/", "referrer": "", "search": "?city=Stockton&latitude=37.9983748&location=Stockton%2C%20CA%2095207%2C%20USA&locationSource=google_autocomplete&longitude=-121.3198491&state=CA&zip=95207", "title": "SelfStorage.com: Find Cheap Storage Units Near You", "url": "https://www.selfstorage.com/self-storage/california/stockton/?city=Stockton&latitude=37.9983748&location=Stockton%2C%20CA%2095207%2C%20USA&locationSource=google_autocomplete&longitude=-121.3198491&state=CA&zip=95207" }, "timezone": "America/New_York", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0", "userAgentData": { "brands": [ { "brand": "Microsoft Edge", "version": "119" }, { "brand": "Chromium", "version": "119" }, { "brand": "Not?A_Brand", "version": "24" } ], "mobile": false, "platform": "Windows" } }, "event": "Product Clicked", "integrations": {}, "messageId": "ajs-next-162480c0e7c1b6f4655ec69cc889cd88", "originalTimestamp": "2023-11-16T20:09:37.964Z", "projectId": "5yGJd9z7eL", "properties": { "Hit Timestamp": 1700165377963, "brand": "undefined", "category": "undefined, undefined", "env": "production", "isReact": true, "list": "undefined: undefined", "name": "undefined - undefined", "price": 38, "quantity": 1, "site_id": 27, "variant": null }, "receivedAt": "2023-11-16T20:09:39.441Z", "sentAt": "2023-11-16T20:09:39.164Z", "timestamp": "2023-11-16T20:09:38.241Z", "type": "track", "userId": "6f632cfda696efab62c73dcfc8eefefb", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.campaign__": "string", "context.campaign.content": "string", "context.campaign.content__": "string", "context.campaign.medium": "string", "context.campaign.medium__": "string", "context.campaign.name": "string", "context.campaign.source": "string", "context.campaign.source__": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.timezone": "string", "context.userAgent": "string", "context.userAgentData.brands": [ { "brand": "string", "version": "string" } ], "context.userAgentData.mobile": "string", "context.userAgentData.platform": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.brand": "string", "properties.category": "string", "properties.env": "string", "properties.id": "string", "properties.inNetwork": "string", "properties.isReact": "string", "properties.label": "string", "properties.list": "string", "properties.name": "string", "properties.position": "string", "properties.price": "string", "properties.product_id": "string", "properties.quantity": "string", "properties.rank": "string", "properties.search_id": "string", "properties.site_id": "string", "properties.variant": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 836
- schema_scan_id: 106041959
- updated: 2023-11-16 15:15:31
Schema Scans: 3
Last at 2025-01-05 23:55:10
-
Scan 134852761
- duration: 0:00:15.646613
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 0, "partitions_applied": false, "success": true } - id: 134852761
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-01-06/", "name": "dt", "type": "string", "value": "2025-01-06" }, "s3": { "bucket": "sfdl-segment-ssdc-prod", "hive_path": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked", "key": "separated_dt/Product Clicked/dt=2025-01-06/1736142733981.events-archiver-480-4..1817457d-18a8-46f6-8ce7-aec1cf06ae3c.json.gz" }, "schema": { "name": "sfdl_prod_segment.ssdc_ProductClicked", "type": "segment" } } - running: False
- schema_name_id: 836
- start_time: 2025-01-05 23:55:10
- success: True
- trace_id: 16379692596079108392
-
Scan 124155256
- duration: 0:05:03.092171
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 2788, "partitions_applied": false, "success": true } - id: 124155256
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2024-07-31/", "name": "dt", "type": "string", "value": "2024-07-31" }, "s3": { "bucket": "sfdl-segment-ssdc-prod", "hive_path": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked", "key": "separated_dt/Product Clicked/dt=2024-07-31/1722405965566.events-archiver-480-39..a182a08a-706d-4b7d-b65c-c4e7964ccfa2.json.gz" }, "schema": { "name": "sfdl_prod_segment.ssdc_ProductClicked", "type": "segment" } } - running: False
- schema_name_id: 836
- start_time: 2024-07-31 01:07:44
- success: True
- trace_id: 5758350911331037627
-
Scan 106041959
- duration: 0:05:58.811205
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 2530, "partitions_applied": false, "success": true } - id: 106041959
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2023-11-16/", "name": "dt", "type": "string", "value": "2023-11-16" }, "s3": { "bucket": "sfdl-segment-ssdc-prod", "hive_path": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked", "key": "separated_dt/Product Clicked/dt=2023-11-16/1700167052599.events-archiver-480-48..f029af4f-ffa5-4d52-80e2-c60447e6ba62.json.gz" }, "schema": { "name": "sfdl_prod_segment.ssdc_ProductClicked", "type": "segment" } } - running: False
- schema_name_id: 836
- start_time: 2023-11-16 14:51:25
- success: True
- trace_id: 1129980966496041088
- count: 113
- ddl:
[ "ALTER TABLE\n `sfdl_prod_segment.ssdc_productclicked`\nADD\n\n\n PARTITION (dt='2025-10-15') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-15/'\n PARTITION (dt='2025-10-17') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-17/'\n PARTITION (dt='2025-10-18') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-18/'\n PARTITION (dt='2025-10-19') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-19/'\n PARTITION (dt='2025-10-20') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-20/'\n PARTITION (dt='2025-10-21') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-21/'\n PARTITION (dt='2025-10-22') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-22/'\n PARTITION (dt='2025-10-23') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-23/'\n PARTITION (dt='2025-10-24') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-24/'\n PARTITION (dt='2025-10-25') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-25/'\n PARTITION (dt='2025-10-26') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-26/'\n PARTITION (dt='2025-10-30') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-30/'\n PARTITION (dt='2025-10-31') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-31/'\n PARTITION (dt='2025-11-01') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-01/'\n PARTITION (dt='2025-11-02') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-02/'\n PARTITION (dt='2025-11-03') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-03/'\n PARTITION (dt='2025-11-04') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-04/'\n PARTITION (dt='2025-11-05') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-05/'\n PARTITION (dt='2025-11-06') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-06/'\n PARTITION (dt='2025-11-09') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-09/'\n PARTITION (dt='2025-11-12') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-12/'\n PARTITION (dt='2025-11-13') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-13/'\n PARTITION (dt='2025-11-15') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-15/'\n PARTITION (dt='2025-11-17') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-17/'\n PARTITION (dt='2025-11-18') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-18/'\n PARTITION (dt='2025-11-19') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-19/'\n PARTITION (dt='2025-11-20') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-20/'\n PARTITION (dt='2025-11-21') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-21/'\n PARTITION (dt='2025-11-23') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-23/'\n PARTITION (dt='2025-11-24') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-24/'\n PARTITION (dt='2025-11-25') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-25/'\n PARTITION (dt='2025-11-27') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-27/'\n PARTITION (dt='2025-11-28') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-28/'\n PARTITION (dt='2025-11-29') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-29/'\n PARTITION (dt='2025-11-30') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-30/'\n PARTITION (dt='2025-12-01') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-01/'\n PARTITION (dt='2025-12-03') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-03/'\n PARTITION (dt='2025-12-04') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-04/'\n PARTITION (dt='2025-12-05') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-05/'\n PARTITION (dt='2025-12-06') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-06/'\n PARTITION (dt='2025-12-07') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-07/'\n PARTITION (dt='2025-12-08') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-08/'\n PARTITION (dt='2025-12-10') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-10/'\n PARTITION (dt='2025-12-11') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-11/'\n PARTITION (dt='2025-12-12') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-12/'\n PARTITION (dt='2025-12-13') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-13/'\n PARTITION (dt='2025-12-14') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-14/'\n PARTITION (dt='2025-12-15') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-15/'\n PARTITION (dt='2025-12-16') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-16/'\n PARTITION (dt='2025-12-18') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-18/'\n PARTITION (dt='2025-12-19') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-19/'\n PARTITION (dt='2025-12-20') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-20/'\n PARTITION (dt='2025-12-21') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-21/'\n PARTITION (dt='2025-12-25') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-25/'\n PARTITION (dt='2025-12-26') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-26/'\n PARTITION (dt='2025-12-28') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-28/'\n PARTITION (dt='2025-12-29') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-29/'\n PARTITION (dt='2025-12-30') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-30/'\n PARTITION (dt='2025-12-31') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-31/'\n PARTITION (dt='2026-01-01') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-01/'\n PARTITION (dt='2026-01-02') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-02/'\n PARTITION (dt='2026-01-05') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-05/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-07/'\n PARTITION (dt='2026-01-08') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-08/'\n PARTITION (dt='2026-01-10') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-10/'\n PARTITION (dt='2026-01-11') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-11/'\n PARTITION (dt='2026-01-12') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-12/'\n PARTITION (dt='2026-01-14') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-14/'\n PARTITION (dt='2026-01-17') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-17/'\n PARTITION (dt='2026-01-18') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-18/'\n PARTITION (dt='2026-01-20') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-20/'\n PARTITION (dt='2026-01-27') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-27/'\n PARTITION (dt='2026-01-28') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-28/'\n PARTITION (dt='2026-01-29') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-29/'\n PARTITION (dt='2026-01-31') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-31/'\n PARTITION (dt='2026-02-01') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-01/'\n PARTITION (dt='2026-02-03') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-03/'\n PARTITION (dt='2026-02-04') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-04/'\n PARTITION (dt='2026-02-05') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-05/'\n PARTITION (dt='2026-02-06') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-06/'\n PARTITION (dt='2026-02-07') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-07/'\n PARTITION (dt='2026-02-09') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-09/'\n PARTITION (dt='2026-02-10') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-10/'\n PARTITION (dt='2026-02-11') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-11/'\n PARTITION (dt='2026-02-12') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-12/'\n PARTITION (dt='2026-02-14') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-14/'\n PARTITION (dt='2026-02-18') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-18/'\n PARTITION (dt='2026-02-22') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-22/'\n PARTITION (dt='2026-02-23') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-23/'\n PARTITION (dt='2026-02-24') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-24/'\n PARTITION (dt='2026-02-25') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-25/'\n PARTITION (dt='2026-02-28') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-28/'\n PARTITION (dt='2026-03-01') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-01/'\n PARTITION (dt='2026-03-05') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-05/'\n PARTITION (dt='2026-03-08') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-08/'\n PARTITION (dt='2026-03-09') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-09/'\n PARTITION (dt='2026-03-11') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-11/'\n PARTITION (dt='2026-03-15') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-15/'\n PARTITION (dt='2026-03-18') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-18/'\n PARTITION (dt='2026-03-21') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-21/'\n PARTITION (dt='2026-03-23') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-23/'\n PARTITION (dt='2026-03-24') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-24/'\n PARTITION (dt='2026-03-25') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-25/'\n PARTITION (dt='2026-03-27') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-27/'\n PARTITION (dt='2026-03-30') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-30/'\n PARTITION (dt='2026-03-31') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-31/'\n PARTITION (dt='2026-04-02') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-04-02/'\n PARTITION (dt='2026-04-07') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-04-07/'\n PARTITION (dt='2026-04-08') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-04-08/'\n PARTITION (dt='2026-04-09') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-04-09/'\n PARTITION (dt='2026-04-10') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-04-10/'\n PARTITION (dt='2026-04-12') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-04-12/'\n PARTITION (dt='2026-04-14') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-04-14/'\n;" ] - name: dt
- state:
[ { "info": { "id": 1566051, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-15/", "name": "dt", "value": "2025-10-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-15 04:50:53", "last_data": "2025-10-15 14:36:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1568597, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-17/", "name": "dt", "value": "2025-10-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-17 00:58:35", "last_data": "2025-10-17 01:03:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1595890, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-18/", "name": "dt", "value": "2025-10-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-17 23:52:57", "last_data": "2025-10-18 12:06:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1596155, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-19/", "name": "dt", "value": "2025-10-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-19 02:54:45", "last_data": "2025-10-19 02:54:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1596717, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-20/", "name": "dt", "value": "2025-10-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-19 21:54:27", "last_data": "2025-10-20 09:21:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1596967, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-21/", "name": "dt", "value": "2025-10-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-21 03:41:02", "last_data": "2025-10-21 04:07:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1597192, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-22/", "name": "dt", "value": "2025-10-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-21 22:04:28", "last_data": "2025-10-22 16:49:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1597566, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-23/", "name": "dt", "value": "2025-10-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-23 16:53:14", "last_data": "2025-10-23 16:56:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1597829, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-24/", "name": "dt", "value": "2025-10-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-24 17:10:01", "last_data": "2025-10-24 17:12:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1597974, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-25/", "name": "dt", "value": "2025-10-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-25 08:06:52", "last_data": "2025-10-25 18:16:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1598153, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-26/", "name": "dt", "value": "2025-10-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-25 21:58:03", "last_data": "2025-10-26 06:06:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1599232, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-30/", "name": "dt", "value": "2025-10-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-30 16:30:19", "last_data": "2025-10-30 16:35:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1599461, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-31/", "name": "dt", "value": "2025-10-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-31 12:07:05", "last_data": "2025-10-31 12:07:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1599624, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-01/", "name": "dt", "value": "2025-11-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-01 09:11:07", "last_data": "2025-11-01 09:18:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1600135, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-02/", "name": "dt", "value": "2025-11-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-02 12:59:21", "last_data": "2025-11-02 13:55:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1600371, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-03/", "name": "dt", "value": "2025-11-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-03 11:17:48", "last_data": "2025-11-03 11:46:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1600634, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-04/", "name": "dt", "value": "2025-11-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-04 18:59:11", "last_data": "2025-11-04 18:59:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1600760, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-05/", "name": "dt", "value": "2025-11-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-05 06:59:12", "last_data": "2025-11-05 07:01:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1601084, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-06/", "name": "dt", "value": "2025-11-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-06 11:07:33", "last_data": "2025-11-06 12:19:30" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1601824, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-09/", "name": "dt", "value": "2025-11-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-09 14:06:41", "last_data": "2025-11-09 14:22:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1602396, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-12/", "name": "dt", "value": "2025-11-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-11 22:57:42", "last_data": "2025-11-12 10:19:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1602780, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-13/", "name": "dt", "value": "2025-11-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-13 16:04:08", "last_data": "2025-11-13 17:10:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1603100, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-15/", "name": "dt", "value": "2025-11-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-14 22:01:14", "last_data": "2025-11-15 16:37:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1605814, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-17/", "name": "dt", "value": "2025-11-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-17 08:07:38", "last_data": "2025-11-17 10:52:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1606073, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-18/", "name": "dt", "value": "2025-11-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-18 06:56:03", "last_data": "2025-11-18 11:34:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1606262, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-19/", "name": "dt", "value": "2025-11-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-18 20:56:22", "last_data": "2025-11-19 15:02:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1606507, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-20/", "name": "dt", "value": "2025-11-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-20 00:57:25", "last_data": "2025-11-20 18:03:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1606704, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-21/", "name": "dt", "value": "2025-11-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-20 19:06:43", "last_data": "2025-11-21 14:59:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1607754, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-23/", "name": "dt", "value": "2025-11-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-22 21:07:01", "last_data": "2025-11-23 13:11:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1607986, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-24/", "name": "dt", "value": "2025-11-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-23 22:12:41", "last_data": "2025-11-24 16:58:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1608371, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-25/", "name": "dt", "value": "2025-11-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-25 12:50:09", "last_data": "2025-11-25 12:59:30" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1608692, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-27/", "name": "dt", "value": "2025-11-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-26 21:09:17", "last_data": "2025-11-26 21:09:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1609067, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-28/", "name": "dt", "value": "2025-11-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-28 17:59:30", "last_data": "2025-11-28 17:59:30" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1609150, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-29/", "name": "dt", "value": "2025-11-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-28 21:59:49", "last_data": "2025-11-29 14:44:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1609427, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-30/", "name": "dt", "value": "2025-11-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-30 06:58:49", "last_data": "2025-11-30 11:15:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1609765, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-01/", "name": "dt", "value": "2025-12-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-01 13:57:53", "last_data": "2025-12-01 15:14:30" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1610240, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-03/", "name": "dt", "value": "2025-12-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-03 14:48:25", "last_data": "2025-12-03 14:48:25" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1610329, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-04/", "name": "dt", "value": "2025-12-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-03 20:07:31", "last_data": "2025-12-03 20:07:31" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1610710, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-05/", "name": "dt", "value": "2025-12-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-05 13:08:57", "last_data": "2025-12-05 13:20:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1611086, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-06/", "name": "dt", "value": "2025-12-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-05 23:57:44", "last_data": "2025-12-06 10:48:25" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1611459, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-07/", "name": "dt", "value": "2025-12-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-07 17:02:57", "last_data": "2025-12-07 17:13:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1611688, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-08/", "name": "dt", "value": "2025-12-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-08 10:58:23", "last_data": "2025-12-08 16:11:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1612144, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-10/", "name": "dt", "value": "2025-12-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-09 19:00:45", "last_data": "2025-12-10 07:59:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1612506, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-11/", "name": "dt", "value": "2025-12-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-10 21:58:36", "last_data": "2025-12-10 21:58:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1612759, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-12/", "name": "dt", "value": "2025-12-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-11 21:09:32", "last_data": "2025-12-11 21:16:25" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1613121, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-13/", "name": "dt", "value": "2025-12-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-13 06:51:53", "last_data": "2025-12-13 11:05:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1613351, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-14/", "name": "dt", "value": "2025-12-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-14 07:54:51", "last_data": "2025-12-14 07:54:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1613525, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-15/", "name": "dt", "value": "2025-12-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-14 20:02:20", "last_data": "2025-12-14 20:02:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1616247, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-16/", "name": "dt", "value": "2025-12-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-16 08:01:51", "last_data": "2025-12-16 11:07:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1616804, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-18/", "name": "dt", "value": "2025-12-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-18 04:54:07", "last_data": "2025-12-18 16:00:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1617126, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-19/", "name": "dt", "value": "2025-12-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-19 12:20:21", "last_data": "2025-12-19 12:21:03" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1617338, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-20/", "name": "dt", "value": "2025-12-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-20 10:14:43", "last_data": "2025-12-20 10:22:25" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1617594, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-21/", "name": "dt", "value": "2025-12-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-21 14:01:25", "last_data": "2025-12-21 14:06:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1618316, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-25/", "name": "dt", "value": "2025-12-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-24 22:54:33", "last_data": "2025-12-24 22:54:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1618524, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-26/", "name": "dt", "value": "2025-12-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-25 22:00:24", "last_data": "2025-12-25 22:03:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1619092, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-28/", "name": "dt", "value": "2025-12-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-28 13:53:56", "last_data": "2025-12-28 14:02:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1619172, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-29/", "name": "dt", "value": "2025-12-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-28 18:55:40", "last_data": "2025-12-29 16:03:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1619563, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-30/", "name": "dt", "value": "2025-12-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-30 15:03:40", "last_data": "2025-12-30 15:03:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1619778, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-31/", "name": "dt", "value": "2025-12-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-31 16:54:12", "last_data": "2025-12-31 16:57:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1619860, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-01/", "name": "dt", "value": "2026-01-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-31 23:54:21", "last_data": "2025-12-31 23:59:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1620089, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-02/", "name": "dt", "value": "2026-01-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-01 20:58:23", "last_data": "2026-01-01 20:58:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1620777, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-05/", "name": "dt", "value": "2026-01-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-05 05:55:00", "last_data": "2026-01-05 16:00:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1621294, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-07/", "name": "dt", "value": "2026-01-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-07 09:55:59", "last_data": "2026-01-07 15:04:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1621545, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-08/", "name": "dt", "value": "2026-01-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-08 11:01:59", "last_data": "2026-01-08 11:42:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1621989, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-10/", "name": "dt", "value": "2026-01-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-10 09:54:29", "last_data": "2026-01-10 10:00:26" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1622217, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-11/", "name": "dt", "value": "2026-01-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-11 09:56:34", "last_data": "2026-01-11 10:56:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1622296, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-12/", "name": "dt", "value": "2026-01-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-11 19:53:31", "last_data": "2026-01-11 19:57:30" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1622993, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-14/", "name": "dt", "value": "2026-01-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-14 12:51:29", "last_data": "2026-01-14 12:51:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1625773, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-17/", "name": "dt", "value": "2026-01-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-17 12:33:13", "last_data": "2026-01-17 12:33:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1626226, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-18/", "name": "dt", "value": "2026-01-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-18 09:58:43", "last_data": "2026-01-18 10:05:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1626685, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-20/", "name": "dt", "value": "2026-01-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-20 10:55:27", "last_data": "2026-01-20 11:48:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1628202, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-27/", "name": "dt", "value": "2026-01-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-27 12:58:06", "last_data": "2026-01-27 12:58:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1628423, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-28/", "name": "dt", "value": "2026-01-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-28 16:55:19", "last_data": "2026-01-28 16:59:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1628635, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-29/", "name": "dt", "value": "2026-01-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-29 09:58:35", "last_data": "2026-01-29 10:58:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1628955, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-31/", "name": "dt", "value": "2026-01-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-30 22:58:38", "last_data": "2026-01-31 18:00:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1629213, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-01/", "name": "dt", "value": "2026-02-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-01 06:55:22", "last_data": "2026-02-01 12:26:25" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1629586, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-03/", "name": "dt", "value": "2026-02-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-02 18:57:30", "last_data": "2026-02-02 18:57:30" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1630030, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-04/", "name": "dt", "value": "2026-02-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-04 16:33:36", "last_data": "2026-02-04 16:57:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1630118, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-05/", "name": "dt", "value": "2026-02-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-04 23:52:03", "last_data": "2026-02-05 14:54:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1630335, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-06/", "name": "dt", "value": "2026-02-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-05 22:56:05", "last_data": "2026-02-06 07:56:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1630556, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-07/", "name": "dt", "value": "2026-02-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-06 23:00:20", "last_data": "2026-02-07 10:02:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1630982, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-09/", "name": "dt", "value": "2026-02-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-08 21:57:44", "last_data": "2026-02-08 22:01:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1631281, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-10/", "name": "dt", "value": "2026-02-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-10 08:56:32", "last_data": "2026-02-10 11:02:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1631661, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-11/", "name": "dt", "value": "2026-02-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-11 10:59:22", "last_data": "2026-02-11 11:01:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1631725, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-12/", "name": "dt", "value": "2026-02-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-11 19:00:00", "last_data": "2026-02-11 19:00:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1632269, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-14/", "name": "dt", "value": "2026-02-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-13 20:52:27", "last_data": "2026-02-14 09:51:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1635411, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-18/", "name": "dt", "value": "2026-02-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-18 16:47:30", "last_data": "2026-02-18 16:59:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1636124, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-22/", "name": "dt", "value": "2026-02-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-21 23:55:20", "last_data": "2026-02-22 14:56:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1636528, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-23/", "name": "dt", "value": "2026-02-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-23 10:01:54", "last_data": "2026-02-23 17:02:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1636724, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-24/", "name": "dt", "value": "2026-02-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-24 08:00:17", "last_data": "2026-02-24 08:00:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1636891, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-25/", "name": "dt", "value": "2026-02-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-24 22:53:09", "last_data": "2026-02-25 09:58:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1641117, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-28/", "name": "dt", "value": "2026-02-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-27 19:58:51", "last_data": "2026-02-27 20:02:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1641387, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-01/", "name": "dt", "value": "2026-03-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-01 06:56:15", "last_data": "2026-03-01 06:56:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1642205, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-05/", "name": "dt", "value": "2026-03-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-04 19:00:53", "last_data": "2026-03-04 19:01:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1642860, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-08/", "name": "dt", "value": "2026-03-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-07 19:01:23", "last_data": "2026-03-07 19:01:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1643855, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-09/", "name": "dt", "value": "2026-03-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-09 17:47:51", "last_data": "2026-03-09 17:47:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1645085, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-11/", "name": "dt", "value": "2026-03-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-11 09:38:30", "last_data": "2026-03-11 15:01:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1645851, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-15/", "name": "dt", "value": "2026-03-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-14 19:59:10", "last_data": "2026-03-15 06:51:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1648309, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-18/", "name": "dt", "value": "2026-03-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-17 20:56:34", "last_data": "2026-03-17 20:56:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1648979, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-21/", "name": "dt", "value": "2026-03-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-20 20:03:10", "last_data": "2026-03-20 20:03:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1649651, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-23/", "name": "dt", "value": "2026-03-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-23 10:00:06", "last_data": "2026-03-23 18:38:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1649811, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-24/", "name": "dt", "value": "2026-03-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-24 09:00:57", "last_data": "2026-03-24 09:00:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1650097, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-25/", "name": "dt", "value": "2026-03-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-25 14:35:37", "last_data": "2026-03-25 14:39:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1650417, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-27/", "name": "dt", "value": "2026-03-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-26 20:56:00", "last_data": "2026-03-26 21:02:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1651612, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-30/", "name": "dt", "value": "2026-03-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-30 11:59:32", "last_data": "2026-03-30 12:02:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1651923, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-31/", "name": "dt", "value": "2026-03-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-31 14:50:27", "last_data": "2026-03-31 14:50:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1652433, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-04-02/", "name": "dt", "value": "2026-04-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-02 08:00:49", "last_data": "2026-04-02 14:52:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1656899, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-04-07/", "name": "dt", "value": "2026-04-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-07 13:55:40", "last_data": "2026-04-07 13:55:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1657123, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-04-08/", "name": "dt", "value": "2026-04-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-08 14:38:57", "last_data": "2026-04-08 14:42:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1657392, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-04-09/", "name": "dt", "value": "2026-04-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-08 23:02:06", "last_data": "2026-04-08 23:02:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1657630, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-04-10/", "name": "dt", "value": "2026-04-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-10 04:56:54", "last_data": "2026-04-10 16:48:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1658167, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-04-12/", "name": "dt", "value": "2026-04-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-12 09:59:31", "last_data": "2026-04-12 10:02:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1658466, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-04-14/", "name": "dt", "value": "2026-04-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-14 00:55:46", "last_data": "2026-04-14 00:55:58" }, "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.campaign__": "string", "context.campaign.content": "string", "context.campaign.content__": "string", "context.campaign.id": "string", "context.campaign.medium": "string", "context.campaign.medium__": "string", "context.campaign.name": "string", "context.campaign.source": "string", "context.campaign.source__": "string", "context.campaign.term": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.timezone": "string", "context.userAgent": "string", "context.userAgentData.brands": [ { "brand": "string", "version": "string" } ], "context.userAgentData.mobile": "string", "context.userAgentData.platform": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.brand": "string", "properties.category": "string", "properties.env": "string", "properties.id": "string", "properties.inNetwork": "string", "properties.isReact": "string", "properties.label": "string", "properties.list": "string", "properties.name": "string", "properties.position": "string", "properties.price": "string", "properties.product_id": "string", "properties.quantity": "string", "properties.rank": "string", "properties.search_id": "string", "properties.site_id": "string", "properties.variant": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - created: 2025-01-05 23:55:12
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.ssdc_productclicked`\n(\n`_origin`STRING,`version`STRING,`receivedAt`STRING,`timestamp`STRING,`anonymousId`STRING,`projectId`STRING,`userId`STRING,`messageId`STRING,`type`STRING,`sentAt`STRING,`event`STRING,`originalTimestamp`STRING,`channel`STRING,`context`struct<`library`:struct<`name`:STRING,`version`:STRING>,`page`:struct<`url`:STRING,`title`:STRING,`path`:STRING,`referrer`:STRING,`search`:STRING>,`timezone`:STRING,`locale`:STRING,`userAgentData`:struct<`platform`:STRING,`mobile`:STRING,`brands`:array
- 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:27:53",
"disabled": false,
"format": "raw",
"id": 836,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_prod_segment",
"table": "ssdc_productclicked"
},
"type": "segment"
},
"partition": {
"count": 113,
"ddl": [
"ALTER TABLE\n `sfdl_prod_segment.ssdc_productclicked`\nADD\n\n\n PARTITION (dt='2025-10-15') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-15/'\n PARTITION (dt='2025-10-17') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-17/'\n PARTITION (dt='2025-10-18') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-18/'\n PARTITION (dt='2025-10-19') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-19/'\n PARTITION (dt='2025-10-20') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-20/'\n PARTITION (dt='2025-10-21') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-21/'\n PARTITION (dt='2025-10-22') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-22/'\n PARTITION (dt='2025-10-23') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-23/'\n PARTITION (dt='2025-10-24') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-24/'\n PARTITION (dt='2025-10-25') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-25/'\n PARTITION (dt='2025-10-26') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-26/'\n PARTITION (dt='2025-10-30') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-30/'\n PARTITION (dt='2025-10-31') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-31/'\n PARTITION (dt='2025-11-01') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-01/'\n PARTITION (dt='2025-11-02') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-02/'\n PARTITION (dt='2025-11-03') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-03/'\n PARTITION (dt='2025-11-04') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-04/'\n PARTITION (dt='2025-11-05') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-05/'\n PARTITION (dt='2025-11-06') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-06/'\n PARTITION (dt='2025-11-09') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-09/'\n PARTITION (dt='2025-11-12') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-12/'\n PARTITION (dt='2025-11-13') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-13/'\n PARTITION (dt='2025-11-15') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-15/'\n PARTITION (dt='2025-11-17') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-17/'\n PARTITION (dt='2025-11-18') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-18/'\n PARTITION (dt='2025-11-19') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-19/'\n PARTITION (dt='2025-11-20') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-20/'\n PARTITION (dt='2025-11-21') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-21/'\n PARTITION (dt='2025-11-23') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-23/'\n PARTITION (dt='2025-11-24') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-24/'\n PARTITION (dt='2025-11-25') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-25/'\n PARTITION (dt='2025-11-27') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-27/'\n PARTITION (dt='2025-11-28') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-28/'\n PARTITION (dt='2025-11-29') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-29/'\n PARTITION (dt='2025-11-30') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-30/'\n PARTITION (dt='2025-12-01') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-01/'\n PARTITION (dt='2025-12-03') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-03/'\n PARTITION (dt='2025-12-04') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-04/'\n PARTITION (dt='2025-12-05') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-05/'\n PARTITION (dt='2025-12-06') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-06/'\n PARTITION (dt='2025-12-07') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-07/'\n PARTITION (dt='2025-12-08') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-08/'\n PARTITION (dt='2025-12-10') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-10/'\n PARTITION (dt='2025-12-11') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-11/'\n PARTITION (dt='2025-12-12') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-12/'\n PARTITION (dt='2025-12-13') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-13/'\n PARTITION (dt='2025-12-14') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-14/'\n PARTITION (dt='2025-12-15') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-15/'\n PARTITION (dt='2025-12-16') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-16/'\n PARTITION (dt='2025-12-18') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-18/'\n PARTITION (dt='2025-12-19') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-19/'\n PARTITION (dt='2025-12-20') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-20/'\n PARTITION (dt='2025-12-21') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-21/'\n PARTITION (dt='2025-12-25') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-25/'\n PARTITION (dt='2025-12-26') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-26/'\n PARTITION (dt='2025-12-28') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-28/'\n PARTITION (dt='2025-12-29') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-29/'\n PARTITION (dt='2025-12-30') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-30/'\n PARTITION (dt='2025-12-31') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-31/'\n PARTITION (dt='2026-01-01') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-01/'\n PARTITION (dt='2026-01-02') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-02/'\n PARTITION (dt='2026-01-05') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-05/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-07/'\n PARTITION (dt='2026-01-08') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-08/'\n PARTITION (dt='2026-01-10') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-10/'\n PARTITION (dt='2026-01-11') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-11/'\n PARTITION (dt='2026-01-12') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-12/'\n PARTITION (dt='2026-01-14') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-14/'\n PARTITION (dt='2026-01-17') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-17/'\n PARTITION (dt='2026-01-18') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-18/'\n PARTITION (dt='2026-01-20') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-20/'\n PARTITION (dt='2026-01-27') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-27/'\n PARTITION (dt='2026-01-28') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-28/'\n PARTITION (dt='2026-01-29') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-29/'\n PARTITION (dt='2026-01-31') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-31/'\n PARTITION (dt='2026-02-01') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-01/'\n PARTITION (dt='2026-02-03') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-03/'\n PARTITION (dt='2026-02-04') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-04/'\n PARTITION (dt='2026-02-05') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-05/'\n PARTITION (dt='2026-02-06') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-06/'\n PARTITION (dt='2026-02-07') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-07/'\n PARTITION (dt='2026-02-09') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-09/'\n PARTITION (dt='2026-02-10') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-10/'\n PARTITION (dt='2026-02-11') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-11/'\n PARTITION (dt='2026-02-12') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-12/'\n PARTITION (dt='2026-02-14') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-14/'\n PARTITION (dt='2026-02-18') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-18/'\n PARTITION (dt='2026-02-22') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-22/'\n PARTITION (dt='2026-02-23') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-23/'\n PARTITION (dt='2026-02-24') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-24/'\n PARTITION (dt='2026-02-25') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-25/'\n PARTITION (dt='2026-02-28') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-28/'\n PARTITION (dt='2026-03-01') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-01/'\n PARTITION (dt='2026-03-05') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-05/'\n PARTITION (dt='2026-03-08') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-08/'\n PARTITION (dt='2026-03-09') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-09/'\n PARTITION (dt='2026-03-11') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-11/'\n PARTITION (dt='2026-03-15') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-15/'\n PARTITION (dt='2026-03-18') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-18/'\n PARTITION (dt='2026-03-21') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-21/'\n PARTITION (dt='2026-03-23') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-23/'\n PARTITION (dt='2026-03-24') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-24/'\n PARTITION (dt='2026-03-25') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-25/'\n PARTITION (dt='2026-03-27') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-27/'\n PARTITION (dt='2026-03-30') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-30/'\n PARTITION (dt='2026-03-31') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-31/'\n PARTITION (dt='2026-04-02') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-04-02/'\n PARTITION (dt='2026-04-07') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-04-07/'\n PARTITION (dt='2026-04-08') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-04-08/'\n PARTITION (dt='2026-04-09') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-04-09/'\n PARTITION (dt='2026-04-10') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-04-10/'\n PARTITION (dt='2026-04-12') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-04-12/'\n PARTITION (dt='2026-04-14') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-04-14/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 1566051,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-15/",
"name": "dt",
"value": "2025-10-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-15 04:50:53",
"last_data": "2025-10-15 14:36:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1568597,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-17/",
"name": "dt",
"value": "2025-10-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-17 00:58:35",
"last_data": "2025-10-17 01:03:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1595890,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-18/",
"name": "dt",
"value": "2025-10-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-17 23:52:57",
"last_data": "2025-10-18 12:06:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1596155,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-19/",
"name": "dt",
"value": "2025-10-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-19 02:54:45",
"last_data": "2025-10-19 02:54:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1596717,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-20/",
"name": "dt",
"value": "2025-10-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-19 21:54:27",
"last_data": "2025-10-20 09:21:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1596967,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-21/",
"name": "dt",
"value": "2025-10-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-21 03:41:02",
"last_data": "2025-10-21 04:07:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1597192,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-22/",
"name": "dt",
"value": "2025-10-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-21 22:04:28",
"last_data": "2025-10-22 16:49:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1597566,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-23/",
"name": "dt",
"value": "2025-10-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-23 16:53:14",
"last_data": "2025-10-23 16:56:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1597829,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-24/",
"name": "dt",
"value": "2025-10-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-24 17:10:01",
"last_data": "2025-10-24 17:12:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1597974,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-25/",
"name": "dt",
"value": "2025-10-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-25 08:06:52",
"last_data": "2025-10-25 18:16:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1598153,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-26/",
"name": "dt",
"value": "2025-10-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-25 21:58:03",
"last_data": "2025-10-26 06:06:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1599232,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-30/",
"name": "dt",
"value": "2025-10-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-30 16:30:19",
"last_data": "2025-10-30 16:35:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1599461,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-10-31/",
"name": "dt",
"value": "2025-10-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-31 12:07:05",
"last_data": "2025-10-31 12:07:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1599624,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-01/",
"name": "dt",
"value": "2025-11-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-01 09:11:07",
"last_data": "2025-11-01 09:18:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1600135,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-02/",
"name": "dt",
"value": "2025-11-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-02 12:59:21",
"last_data": "2025-11-02 13:55:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1600371,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-03/",
"name": "dt",
"value": "2025-11-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-03 11:17:48",
"last_data": "2025-11-03 11:46:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1600634,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-04/",
"name": "dt",
"value": "2025-11-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-04 18:59:11",
"last_data": "2025-11-04 18:59:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1600760,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-05/",
"name": "dt",
"value": "2025-11-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-05 06:59:12",
"last_data": "2025-11-05 07:01:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1601084,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-06/",
"name": "dt",
"value": "2025-11-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-06 11:07:33",
"last_data": "2025-11-06 12:19:30"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1601824,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-09/",
"name": "dt",
"value": "2025-11-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-09 14:06:41",
"last_data": "2025-11-09 14:22:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1602396,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-12/",
"name": "dt",
"value": "2025-11-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-11 22:57:42",
"last_data": "2025-11-12 10:19:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1602780,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-13/",
"name": "dt",
"value": "2025-11-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-13 16:04:08",
"last_data": "2025-11-13 17:10:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1603100,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-15/",
"name": "dt",
"value": "2025-11-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-14 22:01:14",
"last_data": "2025-11-15 16:37:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1605814,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-17/",
"name": "dt",
"value": "2025-11-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-17 08:07:38",
"last_data": "2025-11-17 10:52:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1606073,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-18/",
"name": "dt",
"value": "2025-11-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-18 06:56:03",
"last_data": "2025-11-18 11:34:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1606262,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-19/",
"name": "dt",
"value": "2025-11-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-18 20:56:22",
"last_data": "2025-11-19 15:02:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1606507,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-20/",
"name": "dt",
"value": "2025-11-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-20 00:57:25",
"last_data": "2025-11-20 18:03:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1606704,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-21/",
"name": "dt",
"value": "2025-11-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-20 19:06:43",
"last_data": "2025-11-21 14:59:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1607754,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-23/",
"name": "dt",
"value": "2025-11-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-22 21:07:01",
"last_data": "2025-11-23 13:11:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1607986,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-24/",
"name": "dt",
"value": "2025-11-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-23 22:12:41",
"last_data": "2025-11-24 16:58:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1608371,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-25/",
"name": "dt",
"value": "2025-11-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-25 12:50:09",
"last_data": "2025-11-25 12:59:30"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1608692,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-27/",
"name": "dt",
"value": "2025-11-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-26 21:09:17",
"last_data": "2025-11-26 21:09:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1609067,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-28/",
"name": "dt",
"value": "2025-11-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-28 17:59:30",
"last_data": "2025-11-28 17:59:30"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1609150,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-29/",
"name": "dt",
"value": "2025-11-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-28 21:59:49",
"last_data": "2025-11-29 14:44:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1609427,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-11-30/",
"name": "dt",
"value": "2025-11-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-30 06:58:49",
"last_data": "2025-11-30 11:15:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1609765,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-01/",
"name": "dt",
"value": "2025-12-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-01 13:57:53",
"last_data": "2025-12-01 15:14:30"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1610240,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-03/",
"name": "dt",
"value": "2025-12-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-03 14:48:25",
"last_data": "2025-12-03 14:48:25"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1610329,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-04/",
"name": "dt",
"value": "2025-12-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-03 20:07:31",
"last_data": "2025-12-03 20:07:31"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1610710,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-05/",
"name": "dt",
"value": "2025-12-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-05 13:08:57",
"last_data": "2025-12-05 13:20:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1611086,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-06/",
"name": "dt",
"value": "2025-12-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-05 23:57:44",
"last_data": "2025-12-06 10:48:25"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1611459,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-07/",
"name": "dt",
"value": "2025-12-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-07 17:02:57",
"last_data": "2025-12-07 17:13:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1611688,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-08/",
"name": "dt",
"value": "2025-12-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-08 10:58:23",
"last_data": "2025-12-08 16:11:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1612144,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-10/",
"name": "dt",
"value": "2025-12-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-09 19:00:45",
"last_data": "2025-12-10 07:59:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1612506,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-11/",
"name": "dt",
"value": "2025-12-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-10 21:58:36",
"last_data": "2025-12-10 21:58:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1612759,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-12/",
"name": "dt",
"value": "2025-12-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-11 21:09:32",
"last_data": "2025-12-11 21:16:25"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1613121,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-13/",
"name": "dt",
"value": "2025-12-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-13 06:51:53",
"last_data": "2025-12-13 11:05:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1613351,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-14/",
"name": "dt",
"value": "2025-12-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-14 07:54:51",
"last_data": "2025-12-14 07:54:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1613525,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-15/",
"name": "dt",
"value": "2025-12-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-14 20:02:20",
"last_data": "2025-12-14 20:02:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1616247,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-16/",
"name": "dt",
"value": "2025-12-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-16 08:01:51",
"last_data": "2025-12-16 11:07:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1616804,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-18/",
"name": "dt",
"value": "2025-12-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-18 04:54:07",
"last_data": "2025-12-18 16:00:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1617126,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-19/",
"name": "dt",
"value": "2025-12-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-19 12:20:21",
"last_data": "2025-12-19 12:21:03"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1617338,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-20/",
"name": "dt",
"value": "2025-12-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-20 10:14:43",
"last_data": "2025-12-20 10:22:25"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1617594,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-21/",
"name": "dt",
"value": "2025-12-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-21 14:01:25",
"last_data": "2025-12-21 14:06:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1618316,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-25/",
"name": "dt",
"value": "2025-12-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-24 22:54:33",
"last_data": "2025-12-24 22:54:33"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1618524,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-26/",
"name": "dt",
"value": "2025-12-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-25 22:00:24",
"last_data": "2025-12-25 22:03:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1619092,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-28/",
"name": "dt",
"value": "2025-12-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-28 13:53:56",
"last_data": "2025-12-28 14:02:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1619172,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-29/",
"name": "dt",
"value": "2025-12-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-28 18:55:40",
"last_data": "2025-12-29 16:03:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1619563,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-30/",
"name": "dt",
"value": "2025-12-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-30 15:03:40",
"last_data": "2025-12-30 15:03:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1619778,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2025-12-31/",
"name": "dt",
"value": "2025-12-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-31 16:54:12",
"last_data": "2025-12-31 16:57:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1619860,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-01/",
"name": "dt",
"value": "2026-01-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-31 23:54:21",
"last_data": "2025-12-31 23:59:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1620089,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-02/",
"name": "dt",
"value": "2026-01-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-01 20:58:23",
"last_data": "2026-01-01 20:58:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1620777,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-05/",
"name": "dt",
"value": "2026-01-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-05 05:55:00",
"last_data": "2026-01-05 16:00:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1621294,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-07/",
"name": "dt",
"value": "2026-01-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-07 09:55:59",
"last_data": "2026-01-07 15:04:33"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1621545,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-08/",
"name": "dt",
"value": "2026-01-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-08 11:01:59",
"last_data": "2026-01-08 11:42:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1621989,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-10/",
"name": "dt",
"value": "2026-01-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-10 09:54:29",
"last_data": "2026-01-10 10:00:26"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1622217,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-11/",
"name": "dt",
"value": "2026-01-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-11 09:56:34",
"last_data": "2026-01-11 10:56:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1622296,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-12/",
"name": "dt",
"value": "2026-01-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-11 19:53:31",
"last_data": "2026-01-11 19:57:30"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1622993,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-14/",
"name": "dt",
"value": "2026-01-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-14 12:51:29",
"last_data": "2026-01-14 12:51:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1625773,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-17/",
"name": "dt",
"value": "2026-01-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-17 12:33:13",
"last_data": "2026-01-17 12:33:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1626226,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-18/",
"name": "dt",
"value": "2026-01-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-18 09:58:43",
"last_data": "2026-01-18 10:05:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1626685,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-20/",
"name": "dt",
"value": "2026-01-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-20 10:55:27",
"last_data": "2026-01-20 11:48:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1628202,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-27/",
"name": "dt",
"value": "2026-01-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-27 12:58:06",
"last_data": "2026-01-27 12:58:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1628423,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-28/",
"name": "dt",
"value": "2026-01-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-28 16:55:19",
"last_data": "2026-01-28 16:59:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1628635,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-29/",
"name": "dt",
"value": "2026-01-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-29 09:58:35",
"last_data": "2026-01-29 10:58:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1628955,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-01-31/",
"name": "dt",
"value": "2026-01-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-30 22:58:38",
"last_data": "2026-01-31 18:00:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1629213,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-01/",
"name": "dt",
"value": "2026-02-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-01 06:55:22",
"last_data": "2026-02-01 12:26:25"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1629586,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-03/",
"name": "dt",
"value": "2026-02-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-02 18:57:30",
"last_data": "2026-02-02 18:57:30"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1630030,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-04/",
"name": "dt",
"value": "2026-02-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-04 16:33:36",
"last_data": "2026-02-04 16:57:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1630118,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-05/",
"name": "dt",
"value": "2026-02-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-04 23:52:03",
"last_data": "2026-02-05 14:54:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1630335,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-06/",
"name": "dt",
"value": "2026-02-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-05 22:56:05",
"last_data": "2026-02-06 07:56:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1630556,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-07/",
"name": "dt",
"value": "2026-02-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-06 23:00:20",
"last_data": "2026-02-07 10:02:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1630982,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-09/",
"name": "dt",
"value": "2026-02-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-08 21:57:44",
"last_data": "2026-02-08 22:01:33"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1631281,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-10/",
"name": "dt",
"value": "2026-02-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-10 08:56:32",
"last_data": "2026-02-10 11:02:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1631661,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-11/",
"name": "dt",
"value": "2026-02-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-11 10:59:22",
"last_data": "2026-02-11 11:01:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1631725,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-12/",
"name": "dt",
"value": "2026-02-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-11 19:00:00",
"last_data": "2026-02-11 19:00:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1632269,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-14/",
"name": "dt",
"value": "2026-02-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-13 20:52:27",
"last_data": "2026-02-14 09:51:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1635411,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-18/",
"name": "dt",
"value": "2026-02-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-18 16:47:30",
"last_data": "2026-02-18 16:59:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1636124,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-22/",
"name": "dt",
"value": "2026-02-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-21 23:55:20",
"last_data": "2026-02-22 14:56:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1636528,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-23/",
"name": "dt",
"value": "2026-02-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-23 10:01:54",
"last_data": "2026-02-23 17:02:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1636724,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-24/",
"name": "dt",
"value": "2026-02-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-24 08:00:17",
"last_data": "2026-02-24 08:00:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1636891,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-25/",
"name": "dt",
"value": "2026-02-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-24 22:53:09",
"last_data": "2026-02-25 09:58:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1641117,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-02-28/",
"name": "dt",
"value": "2026-02-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-27 19:58:51",
"last_data": "2026-02-27 20:02:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1641387,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-01/",
"name": "dt",
"value": "2026-03-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-01 06:56:15",
"last_data": "2026-03-01 06:56:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1642205,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-05/",
"name": "dt",
"value": "2026-03-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-04 19:00:53",
"last_data": "2026-03-04 19:01:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1642860,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-08/",
"name": "dt",
"value": "2026-03-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-07 19:01:23",
"last_data": "2026-03-07 19:01:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1643855,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-09/",
"name": "dt",
"value": "2026-03-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-09 17:47:51",
"last_data": "2026-03-09 17:47:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1645085,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-11/",
"name": "dt",
"value": "2026-03-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-11 09:38:30",
"last_data": "2026-03-11 15:01:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1645851,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-15/",
"name": "dt",
"value": "2026-03-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-14 19:59:10",
"last_data": "2026-03-15 06:51:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1648309,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-18/",
"name": "dt",
"value": "2026-03-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-17 20:56:34",
"last_data": "2026-03-17 20:56:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1648979,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-21/",
"name": "dt",
"value": "2026-03-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-20 20:03:10",
"last_data": "2026-03-20 20:03:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1649651,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-23/",
"name": "dt",
"value": "2026-03-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-23 10:00:06",
"last_data": "2026-03-23 18:38:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1649811,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-24/",
"name": "dt",
"value": "2026-03-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-24 09:00:57",
"last_data": "2026-03-24 09:00:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1650097,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-25/",
"name": "dt",
"value": "2026-03-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-25 14:35:37",
"last_data": "2026-03-25 14:39:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1650417,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-27/",
"name": "dt",
"value": "2026-03-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-26 20:56:00",
"last_data": "2026-03-26 21:02:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1651612,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-30/",
"name": "dt",
"value": "2026-03-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-30 11:59:32",
"last_data": "2026-03-30 12:02:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1651923,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-03-31/",
"name": "dt",
"value": "2026-03-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-31 14:50:27",
"last_data": "2026-03-31 14:50:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1652433,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-04-02/",
"name": "dt",
"value": "2026-04-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-02 08:00:49",
"last_data": "2026-04-02 14:52:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1656899,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-04-07/",
"name": "dt",
"value": "2026-04-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-07 13:55:40",
"last_data": "2026-04-07 13:55:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1657123,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-04-08/",
"name": "dt",
"value": "2026-04-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-08 14:38:57",
"last_data": "2026-04-08 14:42:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1657392,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-04-09/",
"name": "dt",
"value": "2026-04-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-08 23:02:06",
"last_data": "2026-04-08 23:02:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1657630,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-04-10/",
"name": "dt",
"value": "2026-04-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-10 04:56:54",
"last_data": "2026-04-10 16:48:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1658167,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-04-12/",
"name": "dt",
"value": "2026-04-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-12 09:59:31",
"last_data": "2026-04-12 10:02:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1658466,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2026-04-14/",
"name": "dt",
"value": "2026-04-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-14 00:55:46",
"last_data": "2026-04-14 00:55:58"
},
"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.campaign__": "string",
"context.campaign.content": "string",
"context.campaign.content__": "string",
"context.campaign.id": "string",
"context.campaign.medium": "string",
"context.campaign.medium__": "string",
"context.campaign.name": "string",
"context.campaign.source": "string",
"context.campaign.source__": "string",
"context.campaign.term": "string",
"context.ip": "string",
"context.library.name": "string",
"context.library.version": "string",
"context.locale": "string",
"context.page.path": "string",
"context.page.referrer": "string",
"context.page.search": "string",
"context.page.title": "string",
"context.page.url": "string",
"context.timezone": "string",
"context.userAgent": "string",
"context.userAgentData.brands": [
{
"brand": "string",
"version": "string"
}
],
"context.userAgentData.mobile": "string",
"context.userAgentData.platform": "string",
"event": "string",
"messageId": "string",
"originalTimestamp": "string",
"projectId": "string",
"properties.Hit_Timestamp": "string",
"properties.brand": "string",
"properties.category": "string",
"properties.env": "string",
"properties.id": "string",
"properties.inNetwork": "string",
"properties.isReact": "string",
"properties.label": "string",
"properties.list": "string",
"properties.name": "string",
"properties.position": "string",
"properties.price": "string",
"properties.product_id": "string",
"properties.quantity": "string",
"properties.rank": "string",
"properties.search_id": "string",
"properties.site_id": "string",
"properties.variant": "string",
"receivedAt": "string",
"sentAt": "string",
"timestamp": "string",
"type": "string",
"userId": "string",
"version": "string"
},
"created": "2025-01-05 23:55:12",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.ssdc_productclicked`\n(\n`_origin`STRING,`version`STRING,`receivedAt`STRING,`timestamp`STRING,`anonymousId`STRING,`projectId`STRING,`userId`STRING,`messageId`STRING,`type`STRING,`sentAt`STRING,`event`STRING,`originalTimestamp`STRING,`channel`STRING,`context`struct<`library`:struct<`name`:STRING,`version`:STRING>,`page`:struct<`url`:STRING,`title`:STRING,`path`:STRING,`referrer`:STRING,`search`:STRING>,`timezone`:STRING,`locale`:STRING,`userAgentData`:struct<`platform`:STRING,`mobile`:STRING,`brands`:array>>,`ip`:STRING,`userAgent`:STRING,`campaign`:struct<`source__`:STRING,`source`:STRING,`campaign__`:STRING,`content__`:STRING,`id`:STRING,`content`:STRING,`medium__`:STRING,`name`:STRING,`term`:STRING,`medium`:STRING>>,`properties`struct<`label`:STRING,`Hit_Timestamp`:STRING,`env`:STRING,`position`:STRING,`category`:STRING,`variant`:STRING,`site_id`:STRING,`price`:STRING,`search_id`:STRING,`id`:STRING,`inNetwork`:STRING,`product_id`:STRING,`brand`:STRING,`list`:STRING,`rank`:STRING,`name`:STRING,`isReact`:STRING,`quantity`: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/Product Clicked'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.ssdc_productclicked`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.ssdc_productclicked"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}