Schema Info
Schema Name: sfdl_stage_segment.storagescout_productviewed
- created: 2021-02-11 08:16:45
- disabled: False
- format: raw
- id: 1020
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_stage_segment", "table": "storagescout_productviewed" } - type: segment
Schema Versions: 2
-
Version 604475
- created: 2023-10-02 08:49:47
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "DROP TABLE IF EXISTS `sfdl_stage_segment.storagescout_productviewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.storagescout_productviewed`\n(\n`properties`struct<`product_id`:STRING,`category`:STRING,`variant`:STRING,`brand`:STRING,`env`:STRING,`label`:STRING,`name`:STRING,`Hit_Timestamp`:STRING,`isReact`:STRING,`site_id`:STRING,`currency`:STRING,`price`:STRING,`quantity`:STRING>,`sentAt`STRING,`version`STRING,`userId`STRING,`projectId`STRING,`messageId`STRING,`context`struct<`userAgent`:STRING,`userAgentData`:struct<`brands`:array - hive_path: s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed
- id: 604475
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "5cfe783d418588000189e438", "5ce847aa3bcc70000140d5a5" ], "unbundled": [] }, "_origin": "2023-10-02T13:49:35Z|s3://sfdl-segment-storagescout-stage/segment-logs/TYN5JDpyiK/1696204800000/1696254548674.events-archiver-480-59..0324d57f-f855-40d0-b635-0cc94f215a64.gz|analytics-segment-separator-stage:$LATEST", "anonymousId": "82624da9-e4de-4093-a66e-3745706fb947", "channel": "client", "context": { "ip": "162.238.214.89", "library": { "name": "analytics.js", "version": "next-1.55.0" }, "locale": "en-US", "page": { "path": "/self-storage/alaska/perryville/403-brooks-road/", "referrer": "https://sparefoot.atlassian.net/", "search": "", "title": "SiteLink Demo Facility Storage Units | Perryville, AK | USStorageSearch.com", "url": "https://www.usstoragesearch.extrameter.com/self-storage/alaska/perryville/403-brooks-road/" }, "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36", "userAgentData": { "brands": [ { "brand": "Google Chrome", "version": "117" }, { "brand": "Not;A=Brand", "version": "8" }, { "brand": "Chromium", "version": "117" } ], "mobile": false, "platform": "Windows" } }, "event": "Product Viewed", "integrations": {}, "messageId": "ajs-next-f36b38d1d4d5d2db7b48e94b25e7fb64", "originalTimestamp": "2023-10-02T13:38:25.992Z", "projectId": "TYN5JDpyiK", "properties": { "Hit Timestamp": 1696253903987, "brand": "self-storage", "category": "Perryville, Alaska", "currency": "usd", "env": "stage", "isReact": true, "label": "enhancedecommerce", "name": "SiteLink Demo Facility - 105463", "price": null, "product_id": 105463, "quantity": 1, "site_id": 413, "variant": null }, "receivedAt": "2023-10-02T13:38:26.189Z", "sentAt": "2023-10-02T13:38:25.997Z", "timestamp": "2023-10-02T13:38:26.184Z", "type": "track", "userId": "d21c440b0b5f4087ec97af00324bba3c", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.userAgent": "string", "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.currency": "string", "properties.env": "string", "properties.isReact": "string", "properties.label": "string", "properties.name": "string", "properties.price": "string", "properties.product_id": "string", "properties.quantity": "string", "properties.site_id": "string", "properties.variant": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1020
- schema_scan_id: 5220472
- updated: 2023-10-02 08:50:01
-
Version 313903
- created: 2021-02-11 08:16:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "DROP TABLE IF EXISTS `sfdl_stage_segment.storagescout_productviewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.storagescout_productviewed`\n(\n`anonymousId`STRING,`channel`STRING,`context`struct<`ip`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`locale`:STRING,`page`:struct<`path`:STRING,`referrer`:STRING,`search`:STRING,`title`:STRING,`url`:STRING>,`userAgent`:STRING>,`event`STRING,`messageId`STRING,`originalTimestamp`STRING,`projectId`STRING,`properties`struct<`Hit_Timestamp`:STRING,`brand`:STRING,`category`:STRING,`currency`:STRING,`env`:STRING,`isReact`:STRING,`label`:STRING,`name`:STRING,`price`:STRING,`product_id`:STRING,`quantity`:STRING,`site_id`:STRING,`variant`:STRING>,`receivedAt`STRING,`sentAt`STRING,`timestamp`STRING,`type`STRING,`userId`STRING,`version`STRING,`_origin`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed'\n", "MSCK REPAIR TABLE sfdl_stage_segment.storagescout_productviewed" ] - hive_path: s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed
- id: 313903
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "unbundled": [] }, "_origin": "2021-02-11T14:16:33Z|s3://sfdl-segment-storagescout-stage/segment-logs/TYN5JDpyiK/1613001600000/1613052918563.727a11785036.fde281a.30bc63c2-2a58-4cea-a8e1-5ef98de03ec9.gz|analytics-segment-separator-stage:$LATEST", "anonymousId": "7f7ae9bd-c2e9-4f89-b121-1c4ecc6c6482", "channel": "client", "context": { "ip": "34.239.223.223", "library": { "name": "analytics.js", "version": "4.0.4" }, "locale": "en-US", "page": { "path": "/self-storage/ak/perryville-storage-units/storedge-demo-facility-test-test-205902/", "referrer": "", "search": "", "title": "storEDGE Demo Facility TEST Test Storage Units | Perryville, AK | USStorageSearch.com", "url": "https://www.storagescout.extrameter.com/self-storage/ak/perryville-storage-units/storedge-demo-facility-test-test-205902/" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 11_2_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.150 Safari/537.36" }, "event": "Product Viewed", "integrations": {}, "messageId": "ajs-d3bbbd8efaf8953f527cf02882fadee2", "originalTimestamp": "2021-02-11T14:07:03.189Z", "projectId": "TYN5JDpyiK", "properties": { "Hit Timestamp": 1613052423071, "brand": "self-storage", "category": "Perryville, Alaska", "currency": "usd", "env": "stage", "isReact": true, "label": "enhancedecommerce", "name": "storEDGE Demo Facility TEST Test - 205902", "price": null, "product_id": 205902, "quantity": 1, "site_id": 413, "variant": null }, "receivedAt": "2021-02-11T14:07:03.584Z", "sentAt": "2021-02-11T14:07:03.191Z", "timestamp": "2021-02-11T14:07:03.582Z", "type": "track", "userId": "93a895b41d8e55d95e63049511a47ff1", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.userAgent": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.brand": "string", "properties.category": "string", "properties.currency": "string", "properties.env": "string", "properties.isReact": "string", "properties.label": "string", "properties.name": "string", "properties.price": "string", "properties.product_id": "string", "properties.quantity": "string", "properties.site_id": "string", "properties.variant": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1020
- schema_scan_id: 3142576
- updated: 2021-02-11 08:17:14
Schema Scans: 2
Last at 2023-10-02 08:49:46
-
Scan 5220472
- duration: 0:00:26.249160
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 96, "partitions_applied": false, "success": true } - id: 5220472
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2023-10-02/", "name": "dt", "type": "string", "value": "2023-10-02" }, "s3": { "bucket": "sfdl-segment-storagescout-stage", "hive_path": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed", "key": "separated_dt/Product Viewed/dt=2023-10-02/1696254548674.events-archiver-480-59..0324d57f-f855-40d0-b635-0cc94f215a64.json.gz" }, "schema": { "name": "sfdl_stage_segment.storagescout_ProductViewed", "type": "segment" } } - running: False
- schema_name_id: 1020
- start_time: 2023-10-02 08:49:46
- success: True
- trace_id: 11172675671005241153
-
Scan 3142576
- duration: 0:00:33.283802
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 76, "partitions_applied": false, "success": true } - id: 3142576
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-02-11/", "name": "dt", "type": "string", "value": "2021-02-11" }, "s3": { "bucket": "sfdl-segment-storagescout-stage", "hive_path": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed", "key": "separated_dt/Product Viewed/dt=2021-02-11/1613052918563.727a11785036.fde281a.30bc63c2-2a58-4cea-a8e1-5ef98de03ec9.json.gz" }, "schema": { "name": "sfdl_stage_segment.storagescout_ProductViewed", "type": "segment" } } - running: False
- schema_name_id: 1020
- start_time: 2021-02-11 08:16:45
- success: True
- trace_id: 12874349333038433700
- count: 95
- ddl:
[ "ALTER TABLE\n `sfdl_stage_segment.storagescout_productviewed`\nADD\n\n\n PARTITION (dt='2019-05-08') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-08/'\n PARTITION (dt='2019-05-09') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-09/'\n PARTITION (dt='2019-05-13') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-13/'\n PARTITION (dt='2019-05-17') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-17/'\n PARTITION (dt='2019-05-20') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-20/'\n PARTITION (dt='2019-05-21') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-21/'\n PARTITION (dt='2019-05-22') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-22/'\n PARTITION (dt='2019-05-23') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-23/'\n PARTITION (dt='2019-05-24') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-24/'\n PARTITION (dt='2019-05-25') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-25/'\n PARTITION (dt='2019-05-27') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-27/'\n PARTITION (dt='2019-05-28') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-28/'\n PARTITION (dt='2019-05-29') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-29/'\n PARTITION (dt='2019-05-30') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-30/'\n PARTITION (dt='2019-05-31') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-31/'\n PARTITION (dt='2019-06-02') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-02/'\n PARTITION (dt='2019-06-03') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-03/'\n PARTITION (dt='2019-06-04') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-04/'\n PARTITION (dt='2019-06-05') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-05/'\n PARTITION (dt='2019-06-06') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-06/'\n PARTITION (dt='2019-06-07') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-07/'\n PARTITION (dt='2019-06-10') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-10/'\n PARTITION (dt='2019-06-11') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-11/'\n PARTITION (dt='2019-06-12') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-12/'\n PARTITION (dt='2019-06-13') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-13/'\n PARTITION (dt='2019-06-14') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-14/'\n PARTITION (dt='2019-06-17') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-17/'\n PARTITION (dt='2019-06-18') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-18/'\n PARTITION (dt='2019-06-19') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-19/'\n PARTITION (dt='2019-06-20') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-20/'\n PARTITION (dt='2019-06-21') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-21/'\n PARTITION (dt='2019-06-24') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-24/'\n PARTITION (dt='2019-06-25') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-25/'\n PARTITION (dt='2019-06-26') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-26/'\n PARTITION (dt='2019-06-28') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-28/'\n PARTITION (dt='2019-07-01') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-01/'\n PARTITION (dt='2019-07-02') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-02/'\n PARTITION (dt='2019-07-05') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-05/'\n PARTITION (dt='2019-07-08') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-08/'\n PARTITION (dt='2019-07-09') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-09/'\n PARTITION (dt='2019-07-10') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-10/'\n PARTITION (dt='2019-07-11') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-11/'\n PARTITION (dt='2019-07-12') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-12/'\n PARTITION (dt='2019-07-15') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-15/'\n PARTITION (dt='2019-07-16') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-16/'\n PARTITION (dt='2019-07-17') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-17/'\n PARTITION (dt='2019-07-18') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-18/'\n PARTITION (dt='2019-07-19') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-19/'\n PARTITION (dt='2019-07-25') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-25/'\n PARTITION (dt='2019-08-12') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-08-12/'\n PARTITION (dt='2019-08-13') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-08-13/'\n PARTITION (dt='2019-08-14') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-08-14/'\n PARTITION (dt='2019-08-19') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-08-19/'\n PARTITION (dt='2019-08-20') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-08-20/'\n PARTITION (dt='2019-08-29') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-08-29/'\n PARTITION (dt='2019-09-04') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-09-04/'\n PARTITION (dt='2019-10-04') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-10-04/'\n PARTITION (dt='2019-10-15') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-10-15/'\n PARTITION (dt='2019-10-21') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-10-21/'\n PARTITION (dt='2019-10-22') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-10-22/'\n PARTITION (dt='2019-10-23') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-10-23/'\n PARTITION (dt='2019-10-24') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-10-24/'\n PARTITION (dt='2019-11-01') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-11-01/'\n PARTITION (dt='2019-11-06') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-11-06/'\n PARTITION (dt='2019-11-13') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-11-13/'\n PARTITION (dt='2019-11-15') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-11-15/'\n PARTITION (dt='2019-11-19') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-11-19/'\n PARTITION (dt='2019-11-21') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-11-21/'\n PARTITION (dt='2019-12-03') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-12-03/'\n PARTITION (dt='2020-01-06') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2020-01-06/'\n PARTITION (dt='2020-01-25') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2020-01-25/'\n PARTITION (dt='2020-02-17') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2020-02-17/'\n PARTITION (dt='2020-05-18') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2020-05-18/'\n PARTITION (dt='2020-05-27') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2020-05-27/'\n PARTITION (dt='2020-05-28') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2020-05-28/'\n PARTITION (dt='2021-02-11') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-02-11/'\n PARTITION (dt='2021-03-04') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-03-04/'\n PARTITION (dt='2021-03-05') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-03-05/'\n PARTITION (dt='2021-03-08') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-03-08/'\n PARTITION (dt='2021-05-05') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-05-05/'\n PARTITION (dt='2021-05-13') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-05-13/'\n PARTITION (dt='2021-06-22') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-06-22/'\n PARTITION (dt='2021-06-23') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-06-23/'\n PARTITION (dt='2021-06-24') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-06-24/'\n PARTITION (dt='2021-06-25') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-06-25/'\n PARTITION (dt='2021-07-12') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-07-12/'\n PARTITION (dt='2021-07-20') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-07-20/'\n PARTITION (dt='2021-08-20') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-08-20/'\n PARTITION (dt='2021-09-23') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-09-23/'\n PARTITION (dt='2021-09-30') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-09-30/'\n PARTITION (dt='2022-01-24') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2022-01-24/'\n PARTITION (dt='2022-02-28') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2022-02-28/'\n PARTITION (dt='2022-06-06') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2022-06-06/'\n PARTITION (dt='2023-02-09') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2023-02-09/'\n PARTITION (dt='2023-10-02') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2023-10-02/'\n;" ] - name: dt
- state:
[ { "info": { "id": 466584, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-08/", "name": "dt", "value": "2019-05-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:06", "last_data": "2023-10-02 08:50:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466657, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-09/", "name": "dt", "value": "2019-05-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:12", "last_data": "2023-10-02 08:50:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466628, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-13/", "name": "dt", "value": "2019-05-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:10", "last_data": "2023-10-02 08:50:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466591, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-17/", "name": "dt", "value": "2019-05-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:06", "last_data": "2023-10-02 08:50:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466579, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-20/", "name": "dt", "value": "2019-05-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:05", "last_data": "2023-10-02 08:50:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466634, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-21/", "name": "dt", "value": "2019-05-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:10", "last_data": "2023-10-02 08:50:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466652, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-22/", "name": "dt", "value": "2019-05-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:12", "last_data": "2023-10-02 08:50:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466598, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-23/", "name": "dt", "value": "2019-05-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:07", "last_data": "2023-10-02 08:50:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466604, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-24/", "name": "dt", "value": "2019-05-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:08", "last_data": "2023-10-02 08:50:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466647, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-25/", "name": "dt", "value": "2019-05-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:11", "last_data": "2023-10-02 08:50:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466585, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-27/", "name": "dt", "value": "2019-05-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:06", "last_data": "2023-10-02 08:50:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466650, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-28/", "name": "dt", "value": "2019-05-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:12", "last_data": "2023-10-02 08:50:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466581, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-29/", "name": "dt", "value": "2019-05-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:06", "last_data": "2023-10-02 08:50:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466596, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-30/", "name": "dt", "value": "2019-05-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:07", "last_data": "2023-10-02 08:50:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466578, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-31/", "name": "dt", "value": "2019-05-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:05", "last_data": "2023-10-02 08:50:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466570, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-02/", "name": "dt", "value": "2019-06-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:05", "last_data": "2023-10-02 08:50:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466586, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-03/", "name": "dt", "value": "2019-06-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:06", "last_data": "2023-10-02 08:50:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466605, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-04/", "name": "dt", "value": "2019-06-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:08", "last_data": "2023-10-02 08:50:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466571, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-05/", "name": "dt", "value": "2019-06-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:05", "last_data": "2023-10-02 08:50:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466567, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-06/", "name": "dt", "value": "2019-06-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:04", "last_data": "2023-10-02 08:50:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466626, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-07/", "name": "dt", "value": "2019-06-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:09", "last_data": "2023-10-02 08:50:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466644, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-10/", "name": "dt", "value": "2019-06-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:11", "last_data": "2023-10-02 08:50:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466609, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-11/", "name": "dt", "value": "2019-06-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:08", "last_data": "2023-10-02 08:50:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466653, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-12/", "name": "dt", "value": "2019-06-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:12", "last_data": "2023-10-02 08:50:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466574, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-13/", "name": "dt", "value": "2019-06-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:05", "last_data": "2023-10-02 08:50:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466582, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-14/", "name": "dt", "value": "2019-06-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:06", "last_data": "2023-10-02 08:50:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466602, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-17/", "name": "dt", "value": "2019-06-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:07", "last_data": "2023-10-02 08:50:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466641, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-18/", "name": "dt", "value": "2019-06-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:11", "last_data": "2023-10-02 08:50:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466576, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-19/", "name": "dt", "value": "2019-06-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:05", "last_data": "2023-10-02 08:50:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466572, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-20/", "name": "dt", "value": "2019-06-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:05", "last_data": "2023-10-02 08:50:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466627, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-21/", "name": "dt", "value": "2019-06-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:10", "last_data": "2023-10-02 08:50:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466583, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-24/", "name": "dt", "value": "2019-06-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:06", "last_data": "2023-10-02 08:50:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466590, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-25/", "name": "dt", "value": "2019-06-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:06", "last_data": "2023-10-02 08:50:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466638, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-26/", "name": "dt", "value": "2019-06-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:11", "last_data": "2023-10-02 08:50:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466623, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-28/", "name": "dt", "value": "2019-06-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:09", "last_data": "2023-10-02 08:50:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466587, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-01/", "name": "dt", "value": "2019-07-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:06", "last_data": "2023-10-02 08:50:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466610, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-02/", "name": "dt", "value": "2019-07-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:08", "last_data": "2023-10-02 08:50:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466606, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-05/", "name": "dt", "value": "2019-07-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:08", "last_data": "2023-10-02 08:50:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466648, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-08/", "name": "dt", "value": "2019-07-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:11", "last_data": "2023-10-02 08:50:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466635, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-09/", "name": "dt", "value": "2019-07-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:10", "last_data": "2023-10-02 08:50:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466608, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-10/", "name": "dt", "value": "2019-07-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:08", "last_data": "2023-10-02 08:50:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466592, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-11/", "name": "dt", "value": "2019-07-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:07", "last_data": "2023-10-02 08:50:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466607, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-12/", "name": "dt", "value": "2019-07-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:08", "last_data": "2023-10-02 08:50:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466637, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-15/", "name": "dt", "value": "2019-07-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:10", "last_data": "2023-10-02 08:50:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466617, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-16/", "name": "dt", "value": "2019-07-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:09", "last_data": "2023-10-02 08:50:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466639, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-17/", "name": "dt", "value": "2019-07-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:11", "last_data": "2023-10-02 08:50:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466573, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-18/", "name": "dt", "value": "2019-07-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:05", "last_data": "2023-10-02 08:50:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466642, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-19/", "name": "dt", "value": "2019-07-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:11", "last_data": "2023-10-02 08:50:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466599, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-25/", "name": "dt", "value": "2019-07-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:07", "last_data": "2023-10-02 08:50:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466632, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-08-12/", "name": "dt", "value": "2019-08-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:10", "last_data": "2023-10-02 08:50:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466603, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-08-13/", "name": "dt", "value": "2019-08-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:07", "last_data": "2023-10-02 08:50:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466629, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-08-14/", "name": "dt", "value": "2019-08-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:10", "last_data": "2023-10-02 08:50:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466651, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-08-19/", "name": "dt", "value": "2019-08-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:12", "last_data": "2023-10-02 08:50:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466613, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-08-20/", "name": "dt", "value": "2019-08-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:08", "last_data": "2023-10-02 08:50:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466631, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-08-29/", "name": "dt", "value": "2019-08-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:10", "last_data": "2023-10-02 08:50:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466589, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-09-04/", "name": "dt", "value": "2019-09-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:06", "last_data": "2023-10-02 08:50:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466618, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-10-04/", "name": "dt", "value": "2019-10-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:09", "last_data": "2023-10-02 08:50:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466611, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-10-15/", "name": "dt", "value": "2019-10-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:08", "last_data": "2023-10-02 08:50:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466593, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-10-21/", "name": "dt", "value": "2019-10-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:07", "last_data": "2023-10-02 08:50:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466620, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-10-22/", "name": "dt", "value": "2019-10-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:09", "last_data": "2023-10-02 08:50:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466649, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-10-23/", "name": "dt", "value": "2019-10-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:11", "last_data": "2023-10-02 08:50:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466654, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-10-24/", "name": "dt", "value": "2019-10-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:12", "last_data": "2023-10-02 08:50:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466630, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-11-01/", "name": "dt", "value": "2019-11-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:10", "last_data": "2023-10-02 08:50:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466600, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-11-06/", "name": "dt", "value": "2019-11-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:07", "last_data": "2023-10-02 08:50:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466655, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-11-13/", "name": "dt", "value": "2019-11-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:12", "last_data": "2023-10-02 08:50:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466614, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-11-15/", "name": "dt", "value": "2019-11-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:08", "last_data": "2023-10-02 08:50:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466621, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-11-19/", "name": "dt", "value": "2019-11-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:09", "last_data": "2023-10-02 08:50:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466577, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-11-21/", "name": "dt", "value": "2019-11-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:05", "last_data": "2023-10-02 08:50:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466636, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-12-03/", "name": "dt", "value": "2019-12-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:10", "last_data": "2023-10-02 08:50:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466658, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2020-01-06/", "name": "dt", "value": "2020-01-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:12", "last_data": "2023-10-02 08:50:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466601, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2020-01-25/", "name": "dt", "value": "2020-01-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:07", "last_data": "2023-10-02 08:50:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466612, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2020-02-17/", "name": "dt", "value": "2020-02-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:08", "last_data": "2023-10-02 08:50:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466622, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2020-05-18/", "name": "dt", "value": "2020-05-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:09", "last_data": "2023-10-02 08:50:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466643, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2020-05-27/", "name": "dt", "value": "2020-05-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:11", "last_data": "2023-10-02 08:50:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466597, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2020-05-28/", "name": "dt", "value": "2020-05-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:07", "last_data": "2023-10-02 08:50:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466588, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-02-11/", "name": "dt", "value": "2021-02-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:06", "last_data": "2023-10-02 08:50:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466619, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-03-04/", "name": "dt", "value": "2021-03-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:09", "last_data": "2023-10-02 08:50:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466595, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-03-05/", "name": "dt", "value": "2021-03-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:07", "last_data": "2023-10-02 08:50:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466633, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-03-08/", "name": "dt", "value": "2021-03-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:10", "last_data": "2023-10-02 08:50:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466568, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-05-05/", "name": "dt", "value": "2021-05-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:04", "last_data": "2023-10-02 08:50:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466624, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-05-13/", "name": "dt", "value": "2021-05-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:09", "last_data": "2023-10-02 08:50:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466640, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-06-22/", "name": "dt", "value": "2021-06-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:11", "last_data": "2023-10-02 08:50:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466615, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-06-23/", "name": "dt", "value": "2021-06-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:09", "last_data": "2023-10-02 08:50:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466616, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-06-24/", "name": "dt", "value": "2021-06-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:09", "last_data": "2023-10-02 08:50:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466594, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-06-25/", "name": "dt", "value": "2021-06-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:07", "last_data": "2023-10-02 08:50:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466645, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-07-12/", "name": "dt", "value": "2021-07-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:11", "last_data": "2023-10-02 08:50:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466656, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-07-20/", "name": "dt", "value": "2021-07-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:12", "last_data": "2023-10-02 08:50:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466625, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-08-20/", "name": "dt", "value": "2021-08-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:09", "last_data": "2023-10-02 08:50:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466569, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-09-23/", "name": "dt", "value": "2021-09-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:05", "last_data": "2023-10-02 08:50:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466580, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-09-30/", "name": "dt", "value": "2021-09-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:05", "last_data": "2023-10-02 08:50:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466646, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2022-01-24/", "name": "dt", "value": "2022-01-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:11", "last_data": "2023-10-02 08:50:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466575, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2022-02-28/", "name": "dt", "value": "2022-02-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:50:05", "last_data": "2023-10-02 08:50:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 289016, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2022-06-06/", "name": "dt", "value": "2022-06-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2022-06-06 13:43:13", "last_data": "2022-06-06 13:53:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 395310, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2023-02-09/", "name": "dt", "value": "2023-02-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-02-08 23:38:42", "last_data": "2023-02-09 00:16:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466566, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2023-10-02/", "name": "dt", "value": "2023-10-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 08:49:48", "last_data": "2023-10-02 08:51:43" }, "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.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.userAgent": "string", "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.currency": "string", "properties.env": "string", "properties.isReact": "string", "properties.label": "string", "properties.name": "string", "properties.price": "string", "properties.product_id": "string", "properties.quantity": "string", "properties.site_id": "string", "properties.variant": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - created: 2023-10-02 08:49:47
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.storagescout_productviewed`\n(\n`properties`struct<`product_id`:STRING,`category`:STRING,`variant`:STRING,`brand`:STRING,`env`:STRING,`label`:STRING,`name`:STRING,`Hit_Timestamp`:STRING,`isReact`:STRING,`site_id`:STRING,`currency`:STRING,`price`:STRING,`quantity`:STRING>,`sentAt`STRING,`version`STRING,`userId`STRING,`projectId`STRING,`messageId`STRING,`context`struct<`userAgent`:STRING,`userAgentData`:struct<`brands`:array
- hostname: schemamanager-5c55c886bf-h2ts4
- name: schema_manager
- process_start: 2025-10-21 13:03:27
- sf_env: stage
- version: 2112174301
{
"name": {
"created": "2021-02-11 08:16:45",
"disabled": false,
"format": "raw",
"id": 1020,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_stage_segment",
"table": "storagescout_productviewed"
},
"type": "segment"
},
"partition": {
"count": 95,
"ddl": [
"ALTER TABLE\n `sfdl_stage_segment.storagescout_productviewed`\nADD\n\n\n PARTITION (dt='2019-05-08') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-08/'\n PARTITION (dt='2019-05-09') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-09/'\n PARTITION (dt='2019-05-13') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-13/'\n PARTITION (dt='2019-05-17') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-17/'\n PARTITION (dt='2019-05-20') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-20/'\n PARTITION (dt='2019-05-21') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-21/'\n PARTITION (dt='2019-05-22') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-22/'\n PARTITION (dt='2019-05-23') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-23/'\n PARTITION (dt='2019-05-24') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-24/'\n PARTITION (dt='2019-05-25') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-25/'\n PARTITION (dt='2019-05-27') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-27/'\n PARTITION (dt='2019-05-28') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-28/'\n PARTITION (dt='2019-05-29') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-29/'\n PARTITION (dt='2019-05-30') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-30/'\n PARTITION (dt='2019-05-31') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-31/'\n PARTITION (dt='2019-06-02') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-02/'\n PARTITION (dt='2019-06-03') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-03/'\n PARTITION (dt='2019-06-04') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-04/'\n PARTITION (dt='2019-06-05') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-05/'\n PARTITION (dt='2019-06-06') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-06/'\n PARTITION (dt='2019-06-07') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-07/'\n PARTITION (dt='2019-06-10') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-10/'\n PARTITION (dt='2019-06-11') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-11/'\n PARTITION (dt='2019-06-12') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-12/'\n PARTITION (dt='2019-06-13') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-13/'\n PARTITION (dt='2019-06-14') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-14/'\n PARTITION (dt='2019-06-17') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-17/'\n PARTITION (dt='2019-06-18') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-18/'\n PARTITION (dt='2019-06-19') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-19/'\n PARTITION (dt='2019-06-20') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-20/'\n PARTITION (dt='2019-06-21') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-21/'\n PARTITION (dt='2019-06-24') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-24/'\n PARTITION (dt='2019-06-25') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-25/'\n PARTITION (dt='2019-06-26') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-26/'\n PARTITION (dt='2019-06-28') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-28/'\n PARTITION (dt='2019-07-01') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-01/'\n PARTITION (dt='2019-07-02') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-02/'\n PARTITION (dt='2019-07-05') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-05/'\n PARTITION (dt='2019-07-08') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-08/'\n PARTITION (dt='2019-07-09') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-09/'\n PARTITION (dt='2019-07-10') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-10/'\n PARTITION (dt='2019-07-11') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-11/'\n PARTITION (dt='2019-07-12') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-12/'\n PARTITION (dt='2019-07-15') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-15/'\n PARTITION (dt='2019-07-16') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-16/'\n PARTITION (dt='2019-07-17') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-17/'\n PARTITION (dt='2019-07-18') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-18/'\n PARTITION (dt='2019-07-19') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-19/'\n PARTITION (dt='2019-07-25') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-25/'\n PARTITION (dt='2019-08-12') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-08-12/'\n PARTITION (dt='2019-08-13') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-08-13/'\n PARTITION (dt='2019-08-14') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-08-14/'\n PARTITION (dt='2019-08-19') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-08-19/'\n PARTITION (dt='2019-08-20') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-08-20/'\n PARTITION (dt='2019-08-29') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-08-29/'\n PARTITION (dt='2019-09-04') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-09-04/'\n PARTITION (dt='2019-10-04') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-10-04/'\n PARTITION (dt='2019-10-15') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-10-15/'\n PARTITION (dt='2019-10-21') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-10-21/'\n PARTITION (dt='2019-10-22') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-10-22/'\n PARTITION (dt='2019-10-23') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-10-23/'\n PARTITION (dt='2019-10-24') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-10-24/'\n PARTITION (dt='2019-11-01') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-11-01/'\n PARTITION (dt='2019-11-06') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-11-06/'\n PARTITION (dt='2019-11-13') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-11-13/'\n PARTITION (dt='2019-11-15') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-11-15/'\n PARTITION (dt='2019-11-19') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-11-19/'\n PARTITION (dt='2019-11-21') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-11-21/'\n PARTITION (dt='2019-12-03') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-12-03/'\n PARTITION (dt='2020-01-06') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2020-01-06/'\n PARTITION (dt='2020-01-25') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2020-01-25/'\n PARTITION (dt='2020-02-17') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2020-02-17/'\n PARTITION (dt='2020-05-18') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2020-05-18/'\n PARTITION (dt='2020-05-27') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2020-05-27/'\n PARTITION (dt='2020-05-28') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2020-05-28/'\n PARTITION (dt='2021-02-11') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-02-11/'\n PARTITION (dt='2021-03-04') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-03-04/'\n PARTITION (dt='2021-03-05') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-03-05/'\n PARTITION (dt='2021-03-08') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-03-08/'\n PARTITION (dt='2021-05-05') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-05-05/'\n PARTITION (dt='2021-05-13') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-05-13/'\n PARTITION (dt='2021-06-22') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-06-22/'\n PARTITION (dt='2021-06-23') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-06-23/'\n PARTITION (dt='2021-06-24') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-06-24/'\n PARTITION (dt='2021-06-25') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-06-25/'\n PARTITION (dt='2021-07-12') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-07-12/'\n PARTITION (dt='2021-07-20') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-07-20/'\n PARTITION (dt='2021-08-20') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-08-20/'\n PARTITION (dt='2021-09-23') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-09-23/'\n PARTITION (dt='2021-09-30') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-09-30/'\n PARTITION (dt='2022-01-24') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2022-01-24/'\n PARTITION (dt='2022-02-28') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2022-02-28/'\n PARTITION (dt='2022-06-06') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2022-06-06/'\n PARTITION (dt='2023-02-09') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2023-02-09/'\n PARTITION (dt='2023-10-02') location 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2023-10-02/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 466584,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-08/",
"name": "dt",
"value": "2019-05-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:06",
"last_data": "2023-10-02 08:50:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466657,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-09/",
"name": "dt",
"value": "2019-05-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:12",
"last_data": "2023-10-02 08:50:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466628,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-13/",
"name": "dt",
"value": "2019-05-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:10",
"last_data": "2023-10-02 08:50:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466591,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-17/",
"name": "dt",
"value": "2019-05-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:06",
"last_data": "2023-10-02 08:50:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466579,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-20/",
"name": "dt",
"value": "2019-05-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:05",
"last_data": "2023-10-02 08:50:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466634,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-21/",
"name": "dt",
"value": "2019-05-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:10",
"last_data": "2023-10-02 08:50:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466652,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-22/",
"name": "dt",
"value": "2019-05-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:12",
"last_data": "2023-10-02 08:50:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466598,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-23/",
"name": "dt",
"value": "2019-05-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:07",
"last_data": "2023-10-02 08:50:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466604,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-24/",
"name": "dt",
"value": "2019-05-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:08",
"last_data": "2023-10-02 08:50:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466647,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-25/",
"name": "dt",
"value": "2019-05-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:11",
"last_data": "2023-10-02 08:50:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466585,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-27/",
"name": "dt",
"value": "2019-05-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:06",
"last_data": "2023-10-02 08:50:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466650,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-28/",
"name": "dt",
"value": "2019-05-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:12",
"last_data": "2023-10-02 08:50:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466581,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-29/",
"name": "dt",
"value": "2019-05-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:06",
"last_data": "2023-10-02 08:50:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466596,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-30/",
"name": "dt",
"value": "2019-05-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:07",
"last_data": "2023-10-02 08:50:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466578,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-05-31/",
"name": "dt",
"value": "2019-05-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:05",
"last_data": "2023-10-02 08:50:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466570,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-02/",
"name": "dt",
"value": "2019-06-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:05",
"last_data": "2023-10-02 08:50:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466586,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-03/",
"name": "dt",
"value": "2019-06-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:06",
"last_data": "2023-10-02 08:50:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466605,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-04/",
"name": "dt",
"value": "2019-06-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:08",
"last_data": "2023-10-02 08:50:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466571,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-05/",
"name": "dt",
"value": "2019-06-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:05",
"last_data": "2023-10-02 08:50:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466567,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-06/",
"name": "dt",
"value": "2019-06-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:04",
"last_data": "2023-10-02 08:50:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466626,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-07/",
"name": "dt",
"value": "2019-06-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:09",
"last_data": "2023-10-02 08:50:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466644,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-10/",
"name": "dt",
"value": "2019-06-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:11",
"last_data": "2023-10-02 08:50:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466609,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-11/",
"name": "dt",
"value": "2019-06-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:08",
"last_data": "2023-10-02 08:50:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466653,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-12/",
"name": "dt",
"value": "2019-06-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:12",
"last_data": "2023-10-02 08:50:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466574,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-13/",
"name": "dt",
"value": "2019-06-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:05",
"last_data": "2023-10-02 08:50:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466582,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-14/",
"name": "dt",
"value": "2019-06-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:06",
"last_data": "2023-10-02 08:50:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466602,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-17/",
"name": "dt",
"value": "2019-06-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:07",
"last_data": "2023-10-02 08:50:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466641,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-18/",
"name": "dt",
"value": "2019-06-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:11",
"last_data": "2023-10-02 08:50:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466576,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-19/",
"name": "dt",
"value": "2019-06-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:05",
"last_data": "2023-10-02 08:50:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466572,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-20/",
"name": "dt",
"value": "2019-06-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:05",
"last_data": "2023-10-02 08:50:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466627,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-21/",
"name": "dt",
"value": "2019-06-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:10",
"last_data": "2023-10-02 08:50:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466583,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-24/",
"name": "dt",
"value": "2019-06-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:06",
"last_data": "2023-10-02 08:50:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466590,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-25/",
"name": "dt",
"value": "2019-06-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:06",
"last_data": "2023-10-02 08:50:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466638,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-26/",
"name": "dt",
"value": "2019-06-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:11",
"last_data": "2023-10-02 08:50:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466623,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-06-28/",
"name": "dt",
"value": "2019-06-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:09",
"last_data": "2023-10-02 08:50:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466587,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-01/",
"name": "dt",
"value": "2019-07-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:06",
"last_data": "2023-10-02 08:50:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466610,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-02/",
"name": "dt",
"value": "2019-07-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:08",
"last_data": "2023-10-02 08:50:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466606,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-05/",
"name": "dt",
"value": "2019-07-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:08",
"last_data": "2023-10-02 08:50:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466648,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-08/",
"name": "dt",
"value": "2019-07-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:11",
"last_data": "2023-10-02 08:50:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466635,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-09/",
"name": "dt",
"value": "2019-07-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:10",
"last_data": "2023-10-02 08:50:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466608,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-10/",
"name": "dt",
"value": "2019-07-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:08",
"last_data": "2023-10-02 08:50:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466592,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-11/",
"name": "dt",
"value": "2019-07-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:07",
"last_data": "2023-10-02 08:50:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466607,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-12/",
"name": "dt",
"value": "2019-07-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:08",
"last_data": "2023-10-02 08:50:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466637,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-15/",
"name": "dt",
"value": "2019-07-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:10",
"last_data": "2023-10-02 08:50:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466617,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-16/",
"name": "dt",
"value": "2019-07-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:09",
"last_data": "2023-10-02 08:50:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466639,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-17/",
"name": "dt",
"value": "2019-07-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:11",
"last_data": "2023-10-02 08:50:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466573,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-18/",
"name": "dt",
"value": "2019-07-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:05",
"last_data": "2023-10-02 08:50:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466642,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-19/",
"name": "dt",
"value": "2019-07-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:11",
"last_data": "2023-10-02 08:50:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466599,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-07-25/",
"name": "dt",
"value": "2019-07-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:07",
"last_data": "2023-10-02 08:50:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466632,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-08-12/",
"name": "dt",
"value": "2019-08-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:10",
"last_data": "2023-10-02 08:50:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466603,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-08-13/",
"name": "dt",
"value": "2019-08-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:07",
"last_data": "2023-10-02 08:50:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466629,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-08-14/",
"name": "dt",
"value": "2019-08-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:10",
"last_data": "2023-10-02 08:50:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466651,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-08-19/",
"name": "dt",
"value": "2019-08-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:12",
"last_data": "2023-10-02 08:50:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466613,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-08-20/",
"name": "dt",
"value": "2019-08-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:08",
"last_data": "2023-10-02 08:50:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466631,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-08-29/",
"name": "dt",
"value": "2019-08-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:10",
"last_data": "2023-10-02 08:50:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466589,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-09-04/",
"name": "dt",
"value": "2019-09-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:06",
"last_data": "2023-10-02 08:50:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466618,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-10-04/",
"name": "dt",
"value": "2019-10-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:09",
"last_data": "2023-10-02 08:50:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466611,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-10-15/",
"name": "dt",
"value": "2019-10-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:08",
"last_data": "2023-10-02 08:50:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466593,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-10-21/",
"name": "dt",
"value": "2019-10-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:07",
"last_data": "2023-10-02 08:50:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466620,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-10-22/",
"name": "dt",
"value": "2019-10-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:09",
"last_data": "2023-10-02 08:50:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466649,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-10-23/",
"name": "dt",
"value": "2019-10-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:11",
"last_data": "2023-10-02 08:50:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466654,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-10-24/",
"name": "dt",
"value": "2019-10-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:12",
"last_data": "2023-10-02 08:50:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466630,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-11-01/",
"name": "dt",
"value": "2019-11-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:10",
"last_data": "2023-10-02 08:50:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466600,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-11-06/",
"name": "dt",
"value": "2019-11-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:07",
"last_data": "2023-10-02 08:50:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466655,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-11-13/",
"name": "dt",
"value": "2019-11-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:12",
"last_data": "2023-10-02 08:50:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466614,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-11-15/",
"name": "dt",
"value": "2019-11-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:08",
"last_data": "2023-10-02 08:50:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466621,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-11-19/",
"name": "dt",
"value": "2019-11-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:09",
"last_data": "2023-10-02 08:50:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466577,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-11-21/",
"name": "dt",
"value": "2019-11-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:05",
"last_data": "2023-10-02 08:50:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466636,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2019-12-03/",
"name": "dt",
"value": "2019-12-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:10",
"last_data": "2023-10-02 08:50:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466658,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2020-01-06/",
"name": "dt",
"value": "2020-01-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:12",
"last_data": "2023-10-02 08:50:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466601,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2020-01-25/",
"name": "dt",
"value": "2020-01-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:07",
"last_data": "2023-10-02 08:50:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466612,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2020-02-17/",
"name": "dt",
"value": "2020-02-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:08",
"last_data": "2023-10-02 08:50:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466622,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2020-05-18/",
"name": "dt",
"value": "2020-05-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:09",
"last_data": "2023-10-02 08:50:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466643,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2020-05-27/",
"name": "dt",
"value": "2020-05-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:11",
"last_data": "2023-10-02 08:50:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466597,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2020-05-28/",
"name": "dt",
"value": "2020-05-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:07",
"last_data": "2023-10-02 08:50:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466588,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-02-11/",
"name": "dt",
"value": "2021-02-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:06",
"last_data": "2023-10-02 08:50:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466619,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-03-04/",
"name": "dt",
"value": "2021-03-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:09",
"last_data": "2023-10-02 08:50:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466595,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-03-05/",
"name": "dt",
"value": "2021-03-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:07",
"last_data": "2023-10-02 08:50:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466633,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-03-08/",
"name": "dt",
"value": "2021-03-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:10",
"last_data": "2023-10-02 08:50:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466568,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-05-05/",
"name": "dt",
"value": "2021-05-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:04",
"last_data": "2023-10-02 08:50:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466624,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-05-13/",
"name": "dt",
"value": "2021-05-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:09",
"last_data": "2023-10-02 08:50:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466640,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-06-22/",
"name": "dt",
"value": "2021-06-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:11",
"last_data": "2023-10-02 08:50:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466615,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-06-23/",
"name": "dt",
"value": "2021-06-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:09",
"last_data": "2023-10-02 08:50:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466616,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-06-24/",
"name": "dt",
"value": "2021-06-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:09",
"last_data": "2023-10-02 08:50:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466594,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-06-25/",
"name": "dt",
"value": "2021-06-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:07",
"last_data": "2023-10-02 08:50:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466645,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-07-12/",
"name": "dt",
"value": "2021-07-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:11",
"last_data": "2023-10-02 08:50:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466656,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-07-20/",
"name": "dt",
"value": "2021-07-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:12",
"last_data": "2023-10-02 08:50:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466625,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-08-20/",
"name": "dt",
"value": "2021-08-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:09",
"last_data": "2023-10-02 08:50:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466569,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-09-23/",
"name": "dt",
"value": "2021-09-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:05",
"last_data": "2023-10-02 08:50:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466580,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2021-09-30/",
"name": "dt",
"value": "2021-09-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:05",
"last_data": "2023-10-02 08:50:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466646,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2022-01-24/",
"name": "dt",
"value": "2022-01-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:11",
"last_data": "2023-10-02 08:50:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466575,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2022-02-28/",
"name": "dt",
"value": "2022-02-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:50:05",
"last_data": "2023-10-02 08:50:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 289016,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2022-06-06/",
"name": "dt",
"value": "2022-06-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2022-06-06 13:43:13",
"last_data": "2022-06-06 13:53:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 395310,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2023-02-09/",
"name": "dt",
"value": "2023-02-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-02-08 23:38:42",
"last_data": "2023-02-09 00:16:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466566,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed/dt=2023-10-02/",
"name": "dt",
"value": "2023-10-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 08:49:48",
"last_data": "2023-10-02 08:51:43"
},
"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.ip": "string",
"context.library.name": "string",
"context.library.version": "string",
"context.locale": "string",
"context.page.path": "string",
"context.page.referrer": "string",
"context.page.search": "string",
"context.page.title": "string",
"context.page.url": "string",
"context.userAgent": "string",
"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.currency": "string",
"properties.env": "string",
"properties.isReact": "string",
"properties.label": "string",
"properties.name": "string",
"properties.price": "string",
"properties.product_id": "string",
"properties.quantity": "string",
"properties.site_id": "string",
"properties.variant": "string",
"receivedAt": "string",
"sentAt": "string",
"timestamp": "string",
"type": "string",
"userId": "string",
"version": "string"
},
"created": "2023-10-02 08:49:47",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.storagescout_productviewed`\n(\n`properties`struct<`product_id`:STRING,`category`:STRING,`variant`:STRING,`brand`:STRING,`env`:STRING,`label`:STRING,`name`:STRING,`Hit_Timestamp`:STRING,`isReact`:STRING,`site_id`:STRING,`currency`:STRING,`price`:STRING,`quantity`:STRING>,`sentAt`STRING,`version`STRING,`userId`STRING,`projectId`STRING,`messageId`STRING,`context`struct<`userAgent`:STRING,`userAgentData`:struct<`brands`:array>,`mobile`:STRING,`platform`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>,`ip`:STRING,`locale`:STRING,`page`:struct<`path`:STRING,`url`:STRING,`search`:STRING,`title`:STRING,`referrer`:STRING>>,`anonymousId`STRING,`receivedAt`STRING,`channel`STRING,`originalTimestamp`STRING,`type`STRING,`event`STRING,`timestamp`STRING,`_origin`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-segment-storagescout-stage/separated_dt/Product Viewed'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_stage_segment.storagescout_productviewed`",
"repair_table": "MSCK REPAIR TABLE sfdl_stage_segment.storagescout_productviewed"
}
},
"server": {
"hostname": "schemamanager-5c55c886bf-h2ts4",
"name": "schema_manager",
"process_start": "2025-10-21 13:03:27",
"sf_env": "stage",
"version": "2112174301"
}
}