Schema Info
Schema Name: sfdl_prod_segment.reactfoot_click
- created: 2017-11-02 14:10:36
- disabled: False
- format: raw
- id: 140
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_prod_segment", "table": "reactfoot_click" } - type: segment
Schema Versions: 3
-
Version 1174479
- created: 2025-01-27 20:56:11
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_click`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_click`\n(\n`version`STRING,`sentAt`STRING,`context`struct<`ip`:STRING,`userAgentData`:struct<`mobile`:STRING,`brands`:array,`unbundled`:array >,`integrations`struct<`library`:struct<`version`:STRING,`name`:STRING>,`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`referrer`:STRING,`title`:STRING>,`campaign`:struct<`content`:STRING,`source`:STRING,`medium`:STRING,`name`:STRING>>,`projectId`STRING,`type`STRING,`messageId`STRING,`channel`STRING,`properties`struct<`label`:STRING,`value`:STRING,`env`:STRING,`site_id`:STRING,`searchId`:STRING,`extras`:struct<`facilityId`:STRING,`priceMeta`:STRING,`sizeBucket`:STRING,`unitId`:STRING>,`moveInDateSelected`:STRING,`chatbot`:STRING,`category`:STRING,`isReact`:STRING,`Hit_Timestamp`:STRING,`breadcrumb`:STRING,`extra`:struct<`unitId`:STRING,`facilityId`:STRING>>,`originalTimestamp`STRING,`event`STRING,`receivedAt`STRING,`_origin`STRING,`userId`STRING,`timestamp`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-segment-reactfoot-prod/separated_dt/click'\n", "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_click" ] - hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/click
- id: 1174479
- processed: 1
- raw_data:
{ "__segment_internal": {}, "_metadata": { "bundled": [ "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c13c7c1386430001b3c90e" ], "unbundled": [] }, "_origin": "2025-01-28T02:55:19Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1738022400000/1738032896467.events-archiver-480-5..be077558-c70a-464a-a4db-e0921ab2f61d.gz|analytics-segment-separator-prod:$LATEST", "anonymousId": "78675c35-3268-4d1b-b9a9-7763b6a9bba2", "channel": "client", "context": { "campaign": { "content": "LM_SFDC_ADV+_CONVERSION_WEB Ad set", "id": "120215387432540476", "medium": "paid", "name": "LM_SFDC_ADV+_CONVERSION_WEB", "source": "ig", "term": "", "tm_source": "facebook" }, "ip": "2600:387:15:5d37::3", "library": { "name": "analytics.js", "version": "next-1.76.0" }, "locale": "en-US", "page": { "path": "/Whitney-TX-self-storage/Go-Store-It-Whitney-101-East-Adams-Avenue-236262.html", "referrer": "https://www.google.com/", "search": "?tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=SF+Google%7CGeneral%7CDynamic&pdv=m&pgrid=32834077871&cpgnid=611394405&ptaid=dsa-652984629820&mkwid=sZMy1mHbi|pcrid|271805932931|pkw||pmt||pdv|m|pgrid|32834077871|cpgnid|611394405|ptaid|dsa-652984629820|adext|&gad_source=1&gclid=CjwKCAiA-ty8BhA_EiwAkyoa3xg4D9sEgx4IQ3GbU71om0VXODongz_Ef9ChSMNYVDeS75iHjGnkyRoCV6kQAvD_BwE", "title": "Go Store It - Whitney - 101 East Adams Avenue | 101 East Adams Avenue | SpareFoot", "url": "https://www.sparefoot.com/Whitney-TX-self-storage/Go-Store-It-Whitney-101-East-Adams-Avenue-236262.html?tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=SF+Google%7CGeneral%7CDynamic&pdv=m&pgrid=32834077871&cpgnid=611394405&ptaid=dsa-652984629820&mkwid=sZMy1mHbi|pcrid|271805932931|pkw||pmt||pdv|m|pgrid|32834077871|cpgnid|611394405|ptaid|dsa-652984629820|adext|&gad_source=1&gclid=CjwKCAiA-ty8BhA_EiwAkyoa3xg4D9sEgx4IQ3GbU71om0VXODongz_Ef9ChSMNYVDeS75iHjGnkyRoCV6kQAvD_BwE" }, "timezone": "America/Chicago", "userAgent": "Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36", "userAgentData": { "brands": [ { "brand": "Not_A Brand", "version": "24" } ], "mobile": true, "platform": "Android" } }, "event": "click", "integrations": {}, "messageId": "ajs-next-1738029447594-fbecd38d-124c-4b67-85fc-dd0896af29f9", "originalTimestamp": "2025-01-28T01:57:27.594Z", "projectId": "a0wkEvFBBK", "properties": { "Hit Timestamp": 1738029447594, "category": "search filters content-storageDealsLandingPage", "env": "production", "isReact": true, "label": "cameras-checkbox", "searchId": "098d679843cad33250.71153907", "site_id": -1, "value": false }, "receivedAt": "2025-01-28T01:57:28.176Z", "sentAt": "2025-01-28T01:57:27.630Z", "timestamp": "2025-01-28T01:57:28.140Z", "type": "track", "userId": "a31a6dcc5c470e5dab4b4d2e1f657f02", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.amp.id": "string", "context.campaign.c": "string", "context.campaign.co": "string", "context.campaign.con": "string", "context.campaign.cont": "string", "context.campaign.conten": "string", "context.campaign.content": "string", "context.campaign.id": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.soupnc_0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000": "string", "context.campaign.source": "string", "context.campaign.term": "string", "context.campaign.tm_source": "string", "context.campaign.utm_campaign": "string", "context.campaign.utm_content": "string", "context.campaign.utm_medium": "string", "context.campaign.utm_source": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.timezone": "string", "context.userAgent": "string", "context.userAgentData.brands": [ { "brand": "string", "version": "string" } ], "context.userAgentData.mobile": "string", "context.userAgentData.platform": "string", "event": "string", "integrations.campaign.content": "string", "integrations.campaign.medium": "string", "integrations.campaign.name": "string", "integrations.campaign.source": "string", "integrations.library.name": "string", "integrations.library.version": "string", "integrations.page.path": "string", "integrations.page.referrer": "string", "integrations.page.search": "string", "integrations.page.title": "string", "integrations.page.url": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.breadcrumb": "string", "properties.category": "string", "properties.chatbot": "string", "properties.env": "string", "properties.extra.facilityId": "string", "properties.extra.unitId": "string", "properties.extras.facilityId": "string", "properties.extras.priceMeta": "string", "properties.extras.sizeBucket": "string", "properties.extras.unitId": "string", "properties.isReact": "string", "properties.label": "string", "properties.moveInDateSelected": "string", "properties.searchId": "string", "properties.site_id": "string", "properties.value": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 140
- schema_scan_id: 136113479
- updated: 2025-01-27 21:06:00
-
Version 945424
- created: 2024-07-15 21:09:22
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_click`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_click`\n(\n`userId`STRING,`sentAt`STRING,`type`STRING,`channel`STRING,`timestamp`STRING,`properties`struct<`site_id`:STRING,`env`:STRING,`searchId`:STRING,`extra`:struct<`unitId`:STRING,`facilityId`:STRING>,`isReact`:STRING,`chatbot`:STRING,`moveInDateSelected`:STRING,`Hit_Timestamp`:STRING,`breadcrumb`:STRING,`value`:STRING,`label`:STRING,`category`:STRING,`extras`:struct<`facilityId`:STRING,`priceMeta`:STRING,`sizeBucket`:STRING,`unitId`:STRING>>,`anonymousId`STRING,`originalTimestamp`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array >,`version`STRING,`_origin`STRING,`integrations`struct<`library`:struct<`version`:STRING,`name`:STRING>,`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`referrer`:STRING,`title`:STRING>,`campaign`:struct<`content`:STRING,`source`:STRING,`medium`:STRING,`name`:STRING>>,`receivedAt`STRING,`context`struct<`amp`:struct<`id`:STRING>,`userAgentData`:struct<`brands`:array - hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/click
- id: 945424
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c55a4597f7a100011813be", "59c13c7c1386430001b3c90e" ], "failedInitializations": [ "Google Tag Manager", "Google Analytics" ], "unbundled": [] }, "_origin": "2024-07-16T02:08:39Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1721088000000/1721095580559.events-archiver-480-11..310d5c0b-0edc-4675-9c4f-db69aa779522.gz|analytics-segment-separator-prod:$LATEST", "anonymousId": "3d8ecc85-3a82-45fe-81bc-db6772998de0", "channel": "client", "context": { "campaign": { "content": "{_ctid}", "id": "120209935477750476", "medium": "paid", "name": "{_cid}", "source": "facebook", "term": "120209956864000476" }, "ip": "2603:6011:a800:86:d86e:5aac:cbdd:26cf", "library": { "name": "analytics.js", "version": "next-1.70.0" }, "locale": "en-US", "page": { "path": "/lpg/lf/hp-copy", "referrer": "https://www.google.com/", "search": "?&tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=SF+Google%7CPMAX&utm_content=&ploc=9015799&iloc=&mkwid=|pcrid||pkw||pmt||pdv|m|pgrid||cpgnid|18795194638|ptaid||adext|&pgrid=&ptaid=&gad_source=1&gclid=Cj0KCQjwkdO0BhDxARIsANkNcrfNIRvbU2qbnkEPCkix4ieuscRNmm0WSUx8Worjodngmmny_dk0IYMaAj1rEALw_wcB", "title": "Cheap Storage Units: Rent Storage Units Near You", "url": "https://www.sparefoot.com/lpg/lf/hp-copy?&tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=SF+Google%7CPMAX&utm_content=&ploc=9015799&iloc=&mkwid=|pcrid||pkw||pmt||pdv|m|pgrid||cpgnid|18795194638|ptaid||adext|&pgrid=&ptaid=&gad_source=1&gclid=Cj0KCQjwkdO0BhDxARIsANkNcrfNIRvbU2qbnkEPCkix4ieuscRNmm0WSUx8Worjodngmmny_dk0IYMaAj1rEALw_wcB" }, "timezone": "America/New_York", "userAgent": "Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Mobile Safari/537.36", "userAgentData": { "brands": [ { "brand": "Google Chrome", "version": "126" } ], "mobile": true, "platform": "Android" } }, "event": "click", "integrations": {}, "messageId": "ajs-next-1721092269713-db5271fa-7877-4776-b305-a23bc6012196", "originalTimestamp": "2024-07-16T01:11:09.713Z", "projectId": "a0wkEvFBBK", "properties": { "Hit Timestamp": 1721092438123, "category": "mobile map-searchPage", "env": "production", "extra": { "facilityId": 204142, "unitId": 21759653 }, "isReact": true, "label": "view map", "searchId": "e9fc6695c94d936fc4.91049371", "site_id": -1 }, "receivedAt": "2024-07-16T01:11:10.773Z", "sentAt": "2024-07-16T01:11:09.805Z", "timestamp": "2024-07-16T01:11:10.681Z", "type": "track", "userId": "6df527482358aa1b4624ed21103441dc", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.amp.id": "string", "context.campaign.c": "string", "context.campaign.co": "string", "context.campaign.con": "string", "context.campaign.cont": "string", "context.campaign.conten": "string", "context.campaign.content": "string", "context.campaign.id": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.soupnc_0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000": "string", "context.campaign.source": "string", "context.campaign.term": "string", "context.campaign.utm_campaign": "string", "context.campaign.utm_content": "string", "context.campaign.utm_medium": "string", "context.campaign.utm_source": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.timezone": "string", "context.userAgent": "string", "context.userAgentData.brands": [ { "brand": "string", "version": "string" } ], "context.userAgentData.mobile": "string", "context.userAgentData.platform": "string", "event": "string", "integrations.campaign.content": "string", "integrations.campaign.medium": "string", "integrations.campaign.name": "string", "integrations.campaign.source": "string", "integrations.library.name": "string", "integrations.library.version": "string", "integrations.page.path": "string", "integrations.page.referrer": "string", "integrations.page.search": "string", "integrations.page.title": "string", "integrations.page.url": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.breadcrumb": "string", "properties.category": "string", "properties.chatbot": "string", "properties.env": "string", "properties.extra.facilityId": "string", "properties.extra.unitId": "string", "properties.extras.facilityId": "string", "properties.extras.priceMeta": "string", "properties.extras.sizeBucket": "string", "properties.extras.unitId": "string", "properties.isReact": "string", "properties.label": "string", "properties.moveInDateSelected": "string", "properties.searchId": "string", "properties.site_id": "string", "properties.value": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 140
- schema_scan_id: 123069219
- updated: 2024-07-15 21:17:46
-
Version 762886
- created: 2024-02-01 10:20:25
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_click`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_click`\n(\n`originalTimestamp`STRING,`anonymousId`STRING,`properties`struct<`category`:STRING,`env`:STRING,`site_id`:STRING,`Hit_Timestamp`:STRING,`value`:STRING,`breadcrumb`:STRING,`isReact`:STRING,`label`:STRING,`extras`:struct<`facilityId`:STRING,`priceMeta`:STRING,`sizeBucket`:STRING,`unitId`:STRING>,`extra`:struct<`facilityId`:STRING,`unitId`:STRING>,`moveInDateSelected`:STRING,`chatbot`:STRING,`searchId`:STRING>,`version`STRING,`timestamp`STRING,`projectId`STRING,`userId`STRING,`type`STRING,`receivedAt`STRING,`integrations`struct<`library`:struct<`version`:STRING,`name`:STRING>,`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`referrer`:STRING,`title`:STRING>,`campaign`:struct<`content`:STRING,`source`:STRING,`medium`:STRING,`name`:STRING>>,`event`STRING,`messageId`STRING,`context`struct<`campaign`:struct<`utm_campaign`:STRING,`utm_medium`:STRING,`conten`:STRING,`content`:STRING,`utm_content`:STRING,`medium`:STRING,`cont`:STRING,`soupnc_0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000`:STRING,`name`:STRING,`c`:STRING,`co`:STRING,`utm_source`:STRING,`con`:STRING,`term`:STRING,`source`:STRING>,`page`:struct<`path`:STRING,`title`:STRING,`referrer`:STRING,`url`:STRING,`search`:STRING>,`ip`:STRING,`userAgentData`:struct<`brands`:array,`unbundled`:array >,`sentAt`STRING,`channel`STRING,`_origin`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-segment-reactfoot-prod/separated_dt/click'\n", "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_click" ] - hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/click
- id: 762886
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c55a4597f7a100011813be", "59c13c7c1386430001b3c90e" ], "failedInitializations": [ "Google Tag Manager", "Google Analytics" ], "unbundled": [] }, "_origin": "2024-02-01T16:20:10Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1706745600000/1706804304496.events-archiver-480-7..14aed4f4-ca91-4040-b814-39933d50509c.gz|analytics-segment-separator-prod:$LATEST", "anonymousId": "4bcfc86a-6ebb-4dfb-a19d-4f528c451f2c", "channel": "client", "context": { "campaign": {}, "ip": "2607:fb91:2f8b:162f:c844:37c0:61fc:d421", "library": { "name": "analytics.js", "version": "next-1.63.0" }, "locale": "en-US", "page": { "path": "/Nashville-TN-self-storage.html", "referrer": "https://www.sparefoot.com/lpg/lf/hp-copy?tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=pro_national_nogeo_noproduct_bmm&utm_content=&ploc=1026082&iloc=1025911&mkwid=sXQ0AzRMN|pcrid|312641405000|pkw|%2Binexpensive%20%2Bstorage|pmt|b|pdv|m|pgrid|41458788419|cpgnid|749884499|ptaid|kwd-23479487727|adext|&pgrid=41458788419&ptaid=kwd-23479487727&gclid=Cj0KCQiAn-2tBhDVARIsAGmStVlArSvVH7SjEhnZX7KlN4Q1pg3wpBdQENuDyTOFclexzxW7Cz-mH3gaAj6QEALw_wcB", "search": "?location=37211&informedSearch=true", "title": "15 Cheap Self-Storage Units in Nashville, TN (From $19)", "url": "https://www.sparefoot.com/Nashville-TN-self-storage.html?location=37211&informedSearch=true" }, "timezone": "America/Chicago", "userAgent": "Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/121.0.0.0 Mobile Safari/537.36", "userAgentData": { "brands": [ { "brand": "Chromium", "version": "121" } ], "mobile": true, "platform": "Android" } }, "event": "click", "integrations": {}, "messageId": "ajs-next-548192571b681e2a4f83d045671b1914", "originalTimestamp": "2024-02-01T15:19:19.793Z", "projectId": "a0wkEvFBBK", "properties": { "Hit Timestamp": 1706800759781, "category": "search pagination-cityLandingPage", "env": "production", "extra": { "facilityId": 233429, "unitId": 30644575 }, "extras": { "facilityId": 215849, "priceMeta": "68.00", "sizeBucket": "5x5", "unitId": 22591235 }, "isReact": true, "label": "search pagination-page number 2", "searchId": "274165bbb5bac21696.91672524", "site_id": -1 }, "receivedAt": "2024-02-01T15:19:22.413Z", "sentAt": "2024-02-01T15:19:21.409Z", "timestamp": "2024-02-01T15:19:20.797Z", "type": "track", "userId": "81346aa180fdafd8470cda3bf07aac93", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.amp.id": "string", "context.campaign.c": "string", "context.campaign.co": "string", "context.campaign.con": "string", "context.campaign.cont": "string", "context.campaign.conten": "string", "context.campaign.content": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.soupnc_0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000": "string", "context.campaign.source": "string", "context.campaign.term": "string", "context.campaign.utm_campaign": "string", "context.campaign.utm_content": "string", "context.campaign.utm_medium": "string", "context.campaign.utm_source": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.timezone": "string", "context.userAgent": "string", "context.userAgentData.brands": [ { "brand": "string", "version": "string" } ], "context.userAgentData.mobile": "string", "context.userAgentData.platform": "string", "event": "string", "integrations.campaign.content": "string", "integrations.campaign.medium": "string", "integrations.campaign.name": "string", "integrations.campaign.source": "string", "integrations.library.name": "string", "integrations.library.version": "string", "integrations.page.path": "string", "integrations.page.referrer": "string", "integrations.page.search": "string", "integrations.page.title": "string", "integrations.page.url": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.breadcrumb": "string", "properties.category": "string", "properties.chatbot": "string", "properties.env": "string", "properties.extra.facilityId": "string", "properties.extra.unitId": "string", "properties.extras.facilityId": "string", "properties.extras.priceMeta": "string", "properties.extras.sizeBucket": "string", "properties.extras.unitId": "string", "properties.isReact": "string", "properties.label": "string", "properties.moveInDateSelected": "string", "properties.searchId": "string", "properties.site_id": "string", "properties.value": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 140
- schema_scan_id: 111276751
- updated: 2024-02-01 10:21:32
Schema Scans: 3
Last at 2025-01-27 20:56:09
-
Scan 136113479
- duration: 0:00:13.165404
- exit_message:
{ "exception": "failed to apply schema `Query failed: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask `MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_click``: ['CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`', 'DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_click`', \"CREATE EXTERNAL TABLE IF NOT EXISTS\\n`sfdl_prod_segment.reactfoot_click`\\n(\\n`version`STRING,`sentAt`STRING,`context`struct<`ip`:STRING,`userAgentData`:struct<`mobile`:STRING,`brands`:array,`unbundled`:array >,`integrations`struct<`library`:struct<`version`:STRING,`name`:STRING>,`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`referrer`:STRING,`title`:STRING>,`campaign`:struct<`content`:STRING,`source`:STRING,`medium`:STRING,`name`:STRING>>,`projectId`STRING,`type`STRING,`messageId`STRING,`channel`STRING,`properties`struct<`label`:STRING,`value`:STRING,`env`:STRING,`site_id`:STRING,`searchId`:STRING,`extras`:struct<`facilityId`:STRING,`priceMeta`:STRING,`sizeBucket`:STRING,`unitId`:STRING>,`moveInDateSelected`:STRING,`chatbot`:STRING,`category`:STRING,`isReact`:STRING,`Hit_Timestamp`:STRING,`breadcrumb`:STRING,`extra`:struct<`unitId`:STRING,`facilityId`:STRING>>,`originalTimestamp`STRING,`event`STRING,`receivedAt`STRING,`_origin`STRING,`userId`STRING,`timestamp`STRING\\n)\\nPARTITIONED BY (dt string)\\nROW FORMAT SERDE\\n'org.openx.data.jsonserde.JsonSerDe'\\n \\nSTORED AS INPUTFORMAT\\n 'org.apache.hadoop.mapred.TextInputFormat'\\nOUTPUTFORMAT\\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\\nLOCATION\\n 's3://sfdl-segment-reactfoot-prod/separated_dt/click'\\n\", 'MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_click']\nTraceback (most recent call last):\n File \"/schema_manager/schema_generator/table_generator.py\", line 24, in apply_latest_version\n self.runner.run_multi_query(schema_version.ddl, timeout=DDLQueueWorker.TIMEOUT)\n File \"/usr/local/lib/python3.12/site-packages/stodl/athena_runner/runner.py\", line 133, in run_multi_query\n result = self.run_single_query(query, timeout, database)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File \"/usr/local/lib/python3.12/site-packages/stodl/athena_runner/runner.py\", line 51, in run_single_query\n return self._run_single_query(query, timeout, database)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File \"/usr/local/lib/python3.12/site-packages/stodl/athena_runner/runner.py\", line 120, in _run_single_query\n raise e\n File \"/usr/local/lib/python3.12/site-packages/stodl/athena_runner/runner.py\", line 103, in _run_single_query\n raise AthenaRunnerQueryException('Query failed: {} `{}`'.format(info['QueryExecution']['Status']['StateChangeReason'], query))\nstodl.athena_runner.exceptions.AthenaRunnerQueryException: Query failed: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask `MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_click`\n\nDuring handling of the above exception, another exception occurred:\n\nTraceback (most recent call last):\n File \"/schema_manager/schema_generator/schema_scanner.py\", line 102, in scan\n response = service.run()\n ^^^^^^^^^^^^^\n File \"/schema_manager/schema_generator/process_hive_table.py\", line 98, in run\n response['ddl_changed'] = table_generator.run()\n ^^^^^^^^^^^^^^^^^^^^^\n File \"/schema_manager/schema_generator/table_generator.py\", line 35, in run\n self.apply_latest_version()\n File \"/schema_manager/schema_generator/table_generator.py\", line 26, in apply_latest_version\n raise Exception('failed to apply schema `{}`: {}'.format(e, schema_version.ddl))\nException: failed to apply schema `Query failed: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask `MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_click``: ['CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`', 'DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_click`', \"CREATE EXTERNAL TABLE IF NOT EXISTS\\n`sfdl_prod_segment.reactfoot_click`\\n(\\n`version`STRING,`sentAt`STRING,`context`struct<`ip`:STRING,`userAgentData`:struct<`mobile`:STRING,`brands`:array ,`unbundled`:array >,`integrations`struct<`library`:struct<`version`:STRING,`name`:STRING>,`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`referrer`:STRING,`title`:STRING>,`campaign`:struct<`content`:STRING,`source`:STRING,`medium`:STRING,`name`:STRING>>,`projectId`STRING,`type`STRING,`messageId`STRING,`channel`STRING,`properties`struct<`label`:STRING,`value`:STRING,`env`:STRING,`site_id`:STRING,`searchId`:STRING,`extras`:struct<`facilityId`:STRING,`priceMeta`:STRING,`sizeBucket`:STRING,`unitId`:STRING>,`moveInDateSelected`:STRING,`chatbot`:STRING,`category`:STRING,`isReact`:STRING,`Hit_Timestamp`:STRING,`breadcrumb`:STRING,`extra`:struct<`unitId`:STRING,`facilityId`:STRING>>,`originalTimestamp`STRING,`event`STRING,`receivedAt`STRING,`_origin`STRING,`userId`STRING,`timestamp`STRING\\n)\\nPARTITIONED BY (dt string)\\nROW FORMAT SERDE\\n'org.openx.data.jsonserde.JsonSerDe'\\n \\nSTORED AS INPUTFORMAT\\n 'org.apache.hadoop.mapred.TextInputFormat'\\nOUTPUTFORMAT\\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\\nLOCATION\\n 's3://sfdl-segment-reactfoot-prod/separated_dt/click'\\n\", 'MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_click']\n: Expecting value: line 1 column 1 (char 0)" } - id: 136113479
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-01-28/", "name": "dt", "type": "string", "value": "2025-01-28" }, "s3": { "bucket": "sfdl-segment-reactfoot-prod", "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/click", "key": "separated_dt/click/dt=2025-01-28/1738032896467.events-archiver-480-5..be077558-c70a-464a-a4db-e0921ab2f61d.json.gz" }, "schema": { "name": "sfdl_prod_segment.reactfoot_click", "type": "segment" } } - running: False
- schema_name_id: 140
- start_time: 2025-01-27 20:56:09
- success: False
- trace_id: 4488612767323670999
-
Scan 123069219
- duration: 0:02:01.696943
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 2487, "partitions_applied": false, "success": true } - id: 123069219
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2024-07-16/", "name": "dt", "type": "string", "value": "2024-07-16" }, "s3": { "bucket": "sfdl-segment-reactfoot-prod", "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/click", "key": "separated_dt/click/dt=2024-07-16/1721095580559.events-archiver-480-11..310d5c0b-0edc-4675-9c4f-db69aa779522.json.gz" }, "schema": { "name": "sfdl_prod_segment.reactfoot_click", "type": "segment" } } - running: False
- schema_name_id: 140
- start_time: 2024-07-15 21:09:20
- success: True
- trace_id: 7403179836324708810
-
Scan 111276751
- duration: 0:04:05.481657
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 2321, "partitions_applied": false, "success": true } - id: 111276751
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2024-02-01/", "name": "dt", "type": "string", "value": "2024-02-01" }, "s3": { "bucket": "sfdl-segment-reactfoot-prod", "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/click", "key": "separated_dt/click/dt=2024-02-01/1706804304496.events-archiver-480-7..14aed4f4-ca91-4040-b814-39933d50509c.json.gz" }, "schema": { "name": "sfdl_prod_segment.reactfoot_click", "type": "segment" } } - running: False
- schema_name_id: 140
- start_time: 2024-02-01 10:20:23
- success: True
- trace_id: 1875238564630287457
- count: 66
- ddl:
[ "ALTER TABLE\n `sfdl_prod_segment.reactfoot_click`\nADD\n\n\n PARTITION (dt='2025-10-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-15/'\n PARTITION (dt='2025-10-16') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-16/'\n PARTITION (dt='2025-10-17') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-17/'\n PARTITION (dt='2025-10-18') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-18/'\n PARTITION (dt='2025-10-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-20/'\n PARTITION (dt='2025-10-25') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-25/'\n PARTITION (dt='2025-10-28') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-28/'\n PARTITION (dt='2025-10-31') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-31/'\n PARTITION (dt='2025-11-01') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-01/'\n PARTITION (dt='2025-11-02') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-02/'\n PARTITION (dt='2025-11-03') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-03/'\n PARTITION (dt='2025-11-07') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-07/'\n PARTITION (dt='2025-11-10') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-10/'\n PARTITION (dt='2025-11-11') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-11/'\n PARTITION (dt='2025-11-16') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-16/'\n PARTITION (dt='2025-11-19') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-19/'\n PARTITION (dt='2025-11-25') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-25/'\n PARTITION (dt='2025-11-29') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-29/'\n PARTITION (dt='2025-12-01') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-01/'\n PARTITION (dt='2025-12-04') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-04/'\n PARTITION (dt='2025-12-06') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-06/'\n PARTITION (dt='2025-12-07') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-07/'\n PARTITION (dt='2025-12-14') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-14/'\n PARTITION (dt='2025-12-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-15/'\n PARTITION (dt='2025-12-16') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-16/'\n PARTITION (dt='2025-12-18') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-18/'\n PARTITION (dt='2025-12-19') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-19/'\n PARTITION (dt='2025-12-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-20/'\n PARTITION (dt='2025-12-21') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-21/'\n PARTITION (dt='2025-12-24') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-24/'\n PARTITION (dt='2025-12-26') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-26/'\n PARTITION (dt='2025-12-29') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-29/'\n PARTITION (dt='2025-12-30') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-30/'\n PARTITION (dt='2025-12-31') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-31/'\n PARTITION (dt='2026-01-02') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-02/'\n PARTITION (dt='2026-01-03') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-03/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-07/'\n PARTITION (dt='2026-01-08') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-08/'\n PARTITION (dt='2026-01-10') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-10/'\n PARTITION (dt='2026-01-11') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-11/'\n PARTITION (dt='2026-01-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-15/'\n PARTITION (dt='2026-01-16') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-16/'\n PARTITION (dt='2026-01-17') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-17/'\n PARTITION (dt='2026-01-18') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-18/'\n PARTITION (dt='2026-01-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-20/'\n PARTITION (dt='2026-01-21') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-21/'\n PARTITION (dt='2026-01-26') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-26/'\n PARTITION (dt='2026-01-29') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-29/'\n PARTITION (dt='2026-01-31') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-31/'\n PARTITION (dt='2026-02-05') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-02-05/'\n PARTITION (dt='2026-02-08') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-02-08/'\n PARTITION (dt='2026-02-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-02-20/'\n PARTITION (dt='2026-02-24') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-02-24/'\n PARTITION (dt='2026-02-25') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-02-25/'\n PARTITION (dt='2026-03-02') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-02/'\n PARTITION (dt='2026-03-03') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-03/'\n PARTITION (dt='2026-03-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-15/'\n PARTITION (dt='2026-03-17') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-17/'\n PARTITION (dt='2026-03-19') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-19/'\n PARTITION (dt='2026-03-23') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-23/'\n PARTITION (dt='2026-03-24') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-24/'\n PARTITION (dt='2026-03-27') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-27/'\n PARTITION (dt='2026-04-05') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-04-05/'\n PARTITION (dt='2026-04-09') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-04-09/'\n PARTITION (dt='2026-04-10') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-04-10/'\n PARTITION (dt='2026-04-13') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-04-13/'\n;" ] - name: dt
- state:
[ { "info": { "id": 1566175, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-15/", "name": "dt", "value": "2025-10-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-15 14:56:26", "last_data": "2025-10-15 14:56:26" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1566401, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-16/", "name": "dt", "value": "2025-10-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-16 11:57:14", "last_data": "2025-10-16 13:47:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1595803, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-17/", "name": "dt", "value": "2025-10-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-17 17:45:51", "last_data": "2025-10-17 17:45:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1596003, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-18/", "name": "dt", "value": "2025-10-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-18 08:59:19", "last_data": "2025-10-18 08:59:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1596728, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-20/", "name": "dt", "value": "2025-10-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-20 04:45:11", "last_data": "2025-10-20 04:45:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1597916, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-25/", "name": "dt", "value": "2025-10-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-24 22:56:19", "last_data": "2025-10-24 23:08:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1598642, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-28/", "name": "dt", "value": "2025-10-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-28 04:59:51", "last_data": "2025-10-28 16:53:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1599344, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-31/", "name": "dt", "value": "2025-10-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-31 04:56:14", "last_data": "2025-10-31 10:05:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1599910, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-01/", "name": "dt", "value": "2025-11-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-01 19:43:12", "last_data": "2025-11-01 19:43:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1600140, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-02/", "name": "dt", "value": "2025-11-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-02 18:49:08", "last_data": "2025-11-02 18:49:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1600277, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-03/", "name": "dt", "value": "2025-11-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-03 06:40:54", "last_data": "2025-11-03 16:51:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1601142, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-07/", "name": "dt", "value": "2025-11-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-06 19:00:33", "last_data": "2025-11-06 19:00:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1602065, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-10/", "name": "dt", "value": "2025-11-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-10 15:54:52", "last_data": "2025-11-10 15:54:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1602302, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-11/", "name": "dt", "value": "2025-11-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-11 15:45:20", "last_data": "2025-11-11 18:19:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1605675, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-16/", "name": "dt", "value": "2025-11-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-16 16:18:28", "last_data": "2025-11-16 16:51:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1606410, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-19/", "name": "dt", "value": "2025-11-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-19 17:52:23", "last_data": "2025-11-19 17:58:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1608266, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-25/", "name": "dt", "value": "2025-11-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-25 05:01:13", "last_data": "2025-11-25 05:01:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1609296, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-29/", "name": "dt", "value": "2025-11-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-29 17:52:28", "last_data": "2025-11-29 18:14:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1609754, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-01/", "name": "dt", "value": "2025-12-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-01 11:11:14", "last_data": "2025-12-01 11:16:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1610482, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-04/", "name": "dt", "value": "2025-12-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-04 18:07:11", "last_data": "2025-12-04 18:14:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1611082, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-06/", "name": "dt", "value": "2025-12-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-05 20:07:12", "last_data": "2025-12-05 20:07:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1611328, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-07/", "name": "dt", "value": "2025-12-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-07 03:05:30", "last_data": "2025-12-07 03:13:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1613445, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-14/", "name": "dt", "value": "2025-12-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-14 17:33:11", "last_data": "2025-12-14 17:46:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1613497, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-15/", "name": "dt", "value": "2025-12-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-14 19:06:15", "last_data": "2025-12-14 19:06:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1616319, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-16/", "name": "dt", "value": "2025-12-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-16 10:04:34", "last_data": "2025-12-16 10:04:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1616766, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-18/", "name": "dt", "value": "2025-12-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-17 20:55:17", "last_data": "2025-12-18 06:56:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1616988, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-19/", "name": "dt", "value": "2025-12-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-19 00:55:08", "last_data": "2025-12-19 00:55:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1617341, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-20/", "name": "dt", "value": "2025-12-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-20 12:04:43", "last_data": "2025-12-20 18:03:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1617419, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-21/", "name": "dt", "value": "2025-12-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-20 20:07:32", "last_data": "2025-12-20 20:08:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1618239, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-24/", "name": "dt", "value": "2025-12-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-24 13:57:52", "last_data": "2025-12-24 13:57:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1618576, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-26/", "name": "dt", "value": "2025-12-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-26 07:57:34", "last_data": "2025-12-26 08:02:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1619201, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-29/", "name": "dt", "value": "2025-12-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-28 21:54:18", "last_data": "2025-12-28 21:56:28" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1619402, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-30/", "name": "dt", "value": "2025-12-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-29 18:54:43", "last_data": "2025-12-29 18:54:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1619676, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-31/", "name": "dt", "value": "2025-12-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-31 05:54:40", "last_data": "2025-12-31 05:54:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1620228, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-02/", "name": "dt", "value": "2026-01-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-02 12:59:39", "last_data": "2026-01-02 14:01:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1620350, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-03/", "name": "dt", "value": "2026-01-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-03 04:56:35", "last_data": "2026-01-03 05:54:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1621221, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-07/", "name": "dt", "value": "2026-01-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-07 05:55:18", "last_data": "2026-01-07 14:02:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1621542, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-08/", "name": "dt", "value": "2026-01-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-08 10:03:01", "last_data": "2026-01-08 17:02:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1621864, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-10/", "name": "dt", "value": "2026-01-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-10 00:55:23", "last_data": "2026-01-10 01:00:24" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1622069, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-11/", "name": "dt", "value": "2026-01-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-10 20:01:42", "last_data": "2026-01-11 00:58:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1623266, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-15/", "name": "dt", "value": "2026-01-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-15 15:58:29", "last_data": "2026-01-15 15:58:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1623354, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-16/", "name": "dt", "value": "2026-01-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-16 02:01:07", "last_data": "2026-01-16 02:01:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1625759, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-17/", "name": "dt", "value": "2026-01-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-17 09:53:15", "last_data": "2026-01-17 09:53:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1626139, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-18/", "name": "dt", "value": "2026-01-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-18 07:59:42", "last_data": "2026-01-18 07:59:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1626522, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-20/", "name": "dt", "value": "2026-01-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-19 22:59:05", "last_data": "2026-01-19 23:00:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1626842, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-21/", "name": "dt", "value": "2026-01-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-21 08:57:22", "last_data": "2026-01-21 08:57:22" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1627985, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-26/", "name": "dt", "value": "2026-01-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-26 15:52:37", "last_data": "2026-01-26 15:54:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1628642, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-29/", "name": "dt", "value": "2026-01-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-29 15:34:19", "last_data": "2026-01-29 17:16:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1629090, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-31/", "name": "dt", "value": "2026-01-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-31 13:48:42", "last_data": "2026-01-31 13:48:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1630128, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-02-05/", "name": "dt", "value": "2026-02-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-05 03:01:06", "last_data": "2026-02-05 11:02:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1630749, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-02-08/", "name": "dt", "value": "2026-02-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-07 19:02:59", "last_data": "2026-02-08 15:59:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1635700, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-02-20/", "name": "dt", "value": "2026-02-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-19 20:03:12", "last_data": "2026-02-19 20:04:32" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1636715, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-02-24/", "name": "dt", "value": "2026-02-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-24 05:57:11", "last_data": "2026-02-24 05:57:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1637101, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-02-25/", "name": "dt", "value": "2026-02-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-25 12:00:08", "last_data": "2026-02-25 12:02:32" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1641682, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-02/", "name": "dt", "value": "2026-03-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-02 14:32:24", "last_data": "2026-03-02 14:32:24" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1641788, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-03/", "name": "dt", "value": "2026-03-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-02 21:01:41", "last_data": "2026-03-02 21:04:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1646065, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-15/", "name": "dt", "value": "2026-03-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-15 15:46:18", "last_data": "2026-03-15 15:46:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1648094, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-17/", "name": "dt", "value": "2026-03-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-16 20:59:24", "last_data": "2026-03-16 20:59:24" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1648520, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-19/", "name": "dt", "value": "2026-03-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-18 19:59:12", "last_data": "2026-03-18 20:03:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1649518, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-23/", "name": "dt", "value": "2026-03-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-23 01:00:07", "last_data": "2026-03-23 01:00:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1649871, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-24/", "name": "dt", "value": "2026-03-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-24 09:58:04", "last_data": "2026-03-24 09:58:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1650557, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-27/", "name": "dt", "value": "2026-03-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-27 13:57:16", "last_data": "2026-03-27 13:57:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1656456, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-04-05/", "name": "dt", "value": "2026-04-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-05 12:47:00", "last_data": "2026-04-05 12:47:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1657528, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-04-09/", "name": "dt", "value": "2026-04-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-09 13:00:15", "last_data": "2026-04-09 13:07:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1657749, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-04-10/", "name": "dt", "value": "2026-04-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-10 18:51:03", "last_data": "2026-04-10 18:51:03" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1658383, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-04-13/", "name": "dt", "value": "2026-04-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-13 17:00:33", "last_data": "2026-04-13 17:00:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } } ] - type: string
- attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.amp.id": "string", "context.campaign.c": "string", "context.campaign.co": "string", "context.campaign.con": "string", "context.campaign.cont": "string", "context.campaign.conten": "string", "context.campaign.content": "string", "context.campaign.id": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.soupnc_0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000": "string", "context.campaign.source": "string", "context.campaign.term": "string", "context.campaign.tm_source": "string", "context.campaign.utm_campaign": "string", "context.campaign.utm_content": "string", "context.campaign.utm_medium": "string", "context.campaign.utm_source": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.timezone": "string", "context.userAgent": "string", "context.userAgentData.brands": [ { "brand": "string", "version": "string" } ], "context.userAgentData.mobile": "string", "context.userAgentData.platform": "string", "event": "string", "integrations.campaign.content": "string", "integrations.campaign.medium": "string", "integrations.campaign.name": "string", "integrations.campaign.source": "string", "integrations.library.name": "string", "integrations.library.version": "string", "integrations.page.path": "string", "integrations.page.referrer": "string", "integrations.page.search": "string", "integrations.page.title": "string", "integrations.page.url": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.breadcrumb": "string", "properties.category": "string", "properties.chatbot": "string", "properties.env": "string", "properties.extra.facilityId": "string", "properties.extra.unitId": "string", "properties.extras.facilityId": "string", "properties.extras.priceMeta": "string", "properties.extras.sizeBucket": "string", "properties.extras.unitId": "string", "properties.isReact": "string", "properties.label": "string", "properties.moveInDateSelected": "string", "properties.searchId": "string", "properties.site_id": "string", "properties.value": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - created: 2025-01-27 20:56:11
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_click`\n(\n`version`STRING,`sentAt`STRING,`context`struct<`ip`:STRING,`userAgentData`:struct<`mobile`:STRING,`brands`:array,`unbundled`:array >,`integrations`struct<`library`:struct<`version`:STRING,`name`:STRING>,`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`referrer`:STRING,`title`:STRING>,`campaign`:struct<`content`:STRING,`source`:STRING,`medium`:STRING,`name`:STRING>>,`projectId`STRING,`type`STRING,`messageId`STRING,`channel`STRING,`properties`struct<`label`:STRING,`value`:STRING,`env`:STRING,`site_id`:STRING,`searchId`:STRING,`extras`:struct<`facilityId`:STRING,`priceMeta`:STRING,`sizeBucket`:STRING,`unitId`:STRING>,`moveInDateSelected`:STRING,`chatbot`:STRING,`category`:STRING,`isReact`:STRING,`Hit_Timestamp`:STRING,`breadcrumb`:STRING,`extra`:struct<`unitId`:STRING,`facilityId`:STRING>>,`originalTimestamp`STRING,`event`STRING,`receivedAt`STRING,`_origin`STRING,`userId`STRING,`timestamp`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-segment-reactfoot-prod/separated_dt/click'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_click`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_click" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2017-11-02 14:10:36",
"disabled": false,
"format": "raw",
"id": 140,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_prod_segment",
"table": "reactfoot_click"
},
"type": "segment"
},
"partition": {
"count": 66,
"ddl": [
"ALTER TABLE\n `sfdl_prod_segment.reactfoot_click`\nADD\n\n\n PARTITION (dt='2025-10-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-15/'\n PARTITION (dt='2025-10-16') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-16/'\n PARTITION (dt='2025-10-17') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-17/'\n PARTITION (dt='2025-10-18') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-18/'\n PARTITION (dt='2025-10-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-20/'\n PARTITION (dt='2025-10-25') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-25/'\n PARTITION (dt='2025-10-28') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-28/'\n PARTITION (dt='2025-10-31') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-31/'\n PARTITION (dt='2025-11-01') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-01/'\n PARTITION (dt='2025-11-02') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-02/'\n PARTITION (dt='2025-11-03') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-03/'\n PARTITION (dt='2025-11-07') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-07/'\n PARTITION (dt='2025-11-10') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-10/'\n PARTITION (dt='2025-11-11') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-11/'\n PARTITION (dt='2025-11-16') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-16/'\n PARTITION (dt='2025-11-19') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-19/'\n PARTITION (dt='2025-11-25') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-25/'\n PARTITION (dt='2025-11-29') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-29/'\n PARTITION (dt='2025-12-01') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-01/'\n PARTITION (dt='2025-12-04') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-04/'\n PARTITION (dt='2025-12-06') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-06/'\n PARTITION (dt='2025-12-07') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-07/'\n PARTITION (dt='2025-12-14') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-14/'\n PARTITION (dt='2025-12-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-15/'\n PARTITION (dt='2025-12-16') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-16/'\n PARTITION (dt='2025-12-18') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-18/'\n PARTITION (dt='2025-12-19') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-19/'\n PARTITION (dt='2025-12-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-20/'\n PARTITION (dt='2025-12-21') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-21/'\n PARTITION (dt='2025-12-24') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-24/'\n PARTITION (dt='2025-12-26') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-26/'\n PARTITION (dt='2025-12-29') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-29/'\n PARTITION (dt='2025-12-30') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-30/'\n PARTITION (dt='2025-12-31') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-31/'\n PARTITION (dt='2026-01-02') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-02/'\n PARTITION (dt='2026-01-03') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-03/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-07/'\n PARTITION (dt='2026-01-08') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-08/'\n PARTITION (dt='2026-01-10') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-10/'\n PARTITION (dt='2026-01-11') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-11/'\n PARTITION (dt='2026-01-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-15/'\n PARTITION (dt='2026-01-16') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-16/'\n PARTITION (dt='2026-01-17') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-17/'\n PARTITION (dt='2026-01-18') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-18/'\n PARTITION (dt='2026-01-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-20/'\n PARTITION (dt='2026-01-21') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-21/'\n PARTITION (dt='2026-01-26') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-26/'\n PARTITION (dt='2026-01-29') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-29/'\n PARTITION (dt='2026-01-31') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-31/'\n PARTITION (dt='2026-02-05') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-02-05/'\n PARTITION (dt='2026-02-08') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-02-08/'\n PARTITION (dt='2026-02-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-02-20/'\n PARTITION (dt='2026-02-24') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-02-24/'\n PARTITION (dt='2026-02-25') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-02-25/'\n PARTITION (dt='2026-03-02') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-02/'\n PARTITION (dt='2026-03-03') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-03/'\n PARTITION (dt='2026-03-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-15/'\n PARTITION (dt='2026-03-17') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-17/'\n PARTITION (dt='2026-03-19') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-19/'\n PARTITION (dt='2026-03-23') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-23/'\n PARTITION (dt='2026-03-24') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-24/'\n PARTITION (dt='2026-03-27') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-27/'\n PARTITION (dt='2026-04-05') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-04-05/'\n PARTITION (dt='2026-04-09') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-04-09/'\n PARTITION (dt='2026-04-10') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-04-10/'\n PARTITION (dt='2026-04-13') location 's3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-04-13/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 1566175,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-15/",
"name": "dt",
"value": "2025-10-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-15 14:56:26",
"last_data": "2025-10-15 14:56:26"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1566401,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-16/",
"name": "dt",
"value": "2025-10-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-16 11:57:14",
"last_data": "2025-10-16 13:47:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1595803,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-17/",
"name": "dt",
"value": "2025-10-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-17 17:45:51",
"last_data": "2025-10-17 17:45:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1596003,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-18/",
"name": "dt",
"value": "2025-10-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-18 08:59:19",
"last_data": "2025-10-18 08:59:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1596728,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-20/",
"name": "dt",
"value": "2025-10-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-20 04:45:11",
"last_data": "2025-10-20 04:45:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1597916,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-25/",
"name": "dt",
"value": "2025-10-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-24 22:56:19",
"last_data": "2025-10-24 23:08:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1598642,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-28/",
"name": "dt",
"value": "2025-10-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-28 04:59:51",
"last_data": "2025-10-28 16:53:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1599344,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-10-31/",
"name": "dt",
"value": "2025-10-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-31 04:56:14",
"last_data": "2025-10-31 10:05:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1599910,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-01/",
"name": "dt",
"value": "2025-11-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-01 19:43:12",
"last_data": "2025-11-01 19:43:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1600140,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-02/",
"name": "dt",
"value": "2025-11-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-02 18:49:08",
"last_data": "2025-11-02 18:49:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1600277,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-03/",
"name": "dt",
"value": "2025-11-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-03 06:40:54",
"last_data": "2025-11-03 16:51:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1601142,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-07/",
"name": "dt",
"value": "2025-11-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-06 19:00:33",
"last_data": "2025-11-06 19:00:33"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1602065,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-10/",
"name": "dt",
"value": "2025-11-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-10 15:54:52",
"last_data": "2025-11-10 15:54:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1602302,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-11/",
"name": "dt",
"value": "2025-11-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-11 15:45:20",
"last_data": "2025-11-11 18:19:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1605675,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-16/",
"name": "dt",
"value": "2025-11-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-16 16:18:28",
"last_data": "2025-11-16 16:51:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1606410,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-19/",
"name": "dt",
"value": "2025-11-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-19 17:52:23",
"last_data": "2025-11-19 17:58:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1608266,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-25/",
"name": "dt",
"value": "2025-11-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-25 05:01:13",
"last_data": "2025-11-25 05:01:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1609296,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-11-29/",
"name": "dt",
"value": "2025-11-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-29 17:52:28",
"last_data": "2025-11-29 18:14:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1609754,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-01/",
"name": "dt",
"value": "2025-12-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-01 11:11:14",
"last_data": "2025-12-01 11:16:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1610482,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-04/",
"name": "dt",
"value": "2025-12-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-04 18:07:11",
"last_data": "2025-12-04 18:14:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1611082,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-06/",
"name": "dt",
"value": "2025-12-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-05 20:07:12",
"last_data": "2025-12-05 20:07:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1611328,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-07/",
"name": "dt",
"value": "2025-12-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-07 03:05:30",
"last_data": "2025-12-07 03:13:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1613445,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-14/",
"name": "dt",
"value": "2025-12-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-14 17:33:11",
"last_data": "2025-12-14 17:46:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1613497,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-15/",
"name": "dt",
"value": "2025-12-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-14 19:06:15",
"last_data": "2025-12-14 19:06:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1616319,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-16/",
"name": "dt",
"value": "2025-12-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-16 10:04:34",
"last_data": "2025-12-16 10:04:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1616766,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-18/",
"name": "dt",
"value": "2025-12-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-17 20:55:17",
"last_data": "2025-12-18 06:56:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1616988,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-19/",
"name": "dt",
"value": "2025-12-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-19 00:55:08",
"last_data": "2025-12-19 00:55:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1617341,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-20/",
"name": "dt",
"value": "2025-12-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-20 12:04:43",
"last_data": "2025-12-20 18:03:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1617419,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-21/",
"name": "dt",
"value": "2025-12-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-20 20:07:32",
"last_data": "2025-12-20 20:08:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1618239,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-24/",
"name": "dt",
"value": "2025-12-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-24 13:57:52",
"last_data": "2025-12-24 13:57:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1618576,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-26/",
"name": "dt",
"value": "2025-12-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-26 07:57:34",
"last_data": "2025-12-26 08:02:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1619201,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-29/",
"name": "dt",
"value": "2025-12-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-28 21:54:18",
"last_data": "2025-12-28 21:56:28"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1619402,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-30/",
"name": "dt",
"value": "2025-12-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-29 18:54:43",
"last_data": "2025-12-29 18:54:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1619676,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2025-12-31/",
"name": "dt",
"value": "2025-12-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-31 05:54:40",
"last_data": "2025-12-31 05:54:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1620228,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-02/",
"name": "dt",
"value": "2026-01-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-02 12:59:39",
"last_data": "2026-01-02 14:01:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1620350,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-03/",
"name": "dt",
"value": "2026-01-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-03 04:56:35",
"last_data": "2026-01-03 05:54:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1621221,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-07/",
"name": "dt",
"value": "2026-01-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-07 05:55:18",
"last_data": "2026-01-07 14:02:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1621542,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-08/",
"name": "dt",
"value": "2026-01-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-08 10:03:01",
"last_data": "2026-01-08 17:02:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1621864,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-10/",
"name": "dt",
"value": "2026-01-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-10 00:55:23",
"last_data": "2026-01-10 01:00:24"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1622069,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-11/",
"name": "dt",
"value": "2026-01-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-10 20:01:42",
"last_data": "2026-01-11 00:58:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1623266,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-15/",
"name": "dt",
"value": "2026-01-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-15 15:58:29",
"last_data": "2026-01-15 15:58:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1623354,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-16/",
"name": "dt",
"value": "2026-01-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-16 02:01:07",
"last_data": "2026-01-16 02:01:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1625759,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-17/",
"name": "dt",
"value": "2026-01-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-17 09:53:15",
"last_data": "2026-01-17 09:53:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1626139,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-18/",
"name": "dt",
"value": "2026-01-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-18 07:59:42",
"last_data": "2026-01-18 07:59:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1626522,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-20/",
"name": "dt",
"value": "2026-01-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-19 22:59:05",
"last_data": "2026-01-19 23:00:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1626842,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-21/",
"name": "dt",
"value": "2026-01-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-21 08:57:22",
"last_data": "2026-01-21 08:57:22"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1627985,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-26/",
"name": "dt",
"value": "2026-01-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-26 15:52:37",
"last_data": "2026-01-26 15:54:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1628642,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-29/",
"name": "dt",
"value": "2026-01-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-29 15:34:19",
"last_data": "2026-01-29 17:16:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1629090,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-01-31/",
"name": "dt",
"value": "2026-01-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-31 13:48:42",
"last_data": "2026-01-31 13:48:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1630128,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-02-05/",
"name": "dt",
"value": "2026-02-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-05 03:01:06",
"last_data": "2026-02-05 11:02:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1630749,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-02-08/",
"name": "dt",
"value": "2026-02-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-07 19:02:59",
"last_data": "2026-02-08 15:59:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1635700,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-02-20/",
"name": "dt",
"value": "2026-02-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-19 20:03:12",
"last_data": "2026-02-19 20:04:32"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1636715,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-02-24/",
"name": "dt",
"value": "2026-02-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-24 05:57:11",
"last_data": "2026-02-24 05:57:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1637101,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-02-25/",
"name": "dt",
"value": "2026-02-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-25 12:00:08",
"last_data": "2026-02-25 12:02:32"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1641682,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-02/",
"name": "dt",
"value": "2026-03-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-02 14:32:24",
"last_data": "2026-03-02 14:32:24"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1641788,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-03/",
"name": "dt",
"value": "2026-03-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-02 21:01:41",
"last_data": "2026-03-02 21:04:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1646065,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-15/",
"name": "dt",
"value": "2026-03-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-15 15:46:18",
"last_data": "2026-03-15 15:46:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1648094,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-17/",
"name": "dt",
"value": "2026-03-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-16 20:59:24",
"last_data": "2026-03-16 20:59:24"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1648520,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-19/",
"name": "dt",
"value": "2026-03-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-18 19:59:12",
"last_data": "2026-03-18 20:03:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1649518,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-23/",
"name": "dt",
"value": "2026-03-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-23 01:00:07",
"last_data": "2026-03-23 01:00:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1649871,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-24/",
"name": "dt",
"value": "2026-03-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-24 09:58:04",
"last_data": "2026-03-24 09:58:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1650557,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-03-27/",
"name": "dt",
"value": "2026-03-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-27 13:57:16",
"last_data": "2026-03-27 13:57:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1656456,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-04-05/",
"name": "dt",
"value": "2026-04-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-05 12:47:00",
"last_data": "2026-04-05 12:47:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1657528,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-04-09/",
"name": "dt",
"value": "2026-04-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-09 13:00:15",
"last_data": "2026-04-09 13:07:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1657749,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-04-10/",
"name": "dt",
"value": "2026-04-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-10 18:51:03",
"last_data": "2026-04-10 18:51:03"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1658383,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/click/dt=2026-04-13/",
"name": "dt",
"value": "2026-04-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-13 17:00:33",
"last_data": "2026-04-13 17:00:33"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
}
],
"type": "string"
},
"schema": {
"attributes": {
"_origin": "string",
"anonymousId": "string",
"channel": "string",
"context.amp.id": "string",
"context.campaign.c": "string",
"context.campaign.co": "string",
"context.campaign.con": "string",
"context.campaign.cont": "string",
"context.campaign.conten": "string",
"context.campaign.content": "string",
"context.campaign.id": "string",
"context.campaign.medium": "string",
"context.campaign.name": "string",
"context.campaign.soupnc_0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000": "string",
"context.campaign.source": "string",
"context.campaign.term": "string",
"context.campaign.tm_source": "string",
"context.campaign.utm_campaign": "string",
"context.campaign.utm_content": "string",
"context.campaign.utm_medium": "string",
"context.campaign.utm_source": "string",
"context.ip": "string",
"context.library.name": "string",
"context.library.version": "string",
"context.locale": "string",
"context.page.path": "string",
"context.page.referrer": "string",
"context.page.search": "string",
"context.page.title": "string",
"context.page.url": "string",
"context.timezone": "string",
"context.userAgent": "string",
"context.userAgentData.brands": [
{
"brand": "string",
"version": "string"
}
],
"context.userAgentData.mobile": "string",
"context.userAgentData.platform": "string",
"event": "string",
"integrations.campaign.content": "string",
"integrations.campaign.medium": "string",
"integrations.campaign.name": "string",
"integrations.campaign.source": "string",
"integrations.library.name": "string",
"integrations.library.version": "string",
"integrations.page.path": "string",
"integrations.page.referrer": "string",
"integrations.page.search": "string",
"integrations.page.title": "string",
"integrations.page.url": "string",
"messageId": "string",
"originalTimestamp": "string",
"projectId": "string",
"properties.Hit_Timestamp": "string",
"properties.breadcrumb": "string",
"properties.category": "string",
"properties.chatbot": "string",
"properties.env": "string",
"properties.extra.facilityId": "string",
"properties.extra.unitId": "string",
"properties.extras.facilityId": "string",
"properties.extras.priceMeta": "string",
"properties.extras.sizeBucket": "string",
"properties.extras.unitId": "string",
"properties.isReact": "string",
"properties.label": "string",
"properties.moveInDateSelected": "string",
"properties.searchId": "string",
"properties.site_id": "string",
"properties.value": "string",
"receivedAt": "string",
"sentAt": "string",
"timestamp": "string",
"type": "string",
"userId": "string",
"version": "string"
},
"created": "2025-01-27 20:56:11",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_click`\n(\n`version`STRING,`sentAt`STRING,`context`struct<`ip`:STRING,`userAgentData`:struct<`mobile`:STRING,`brands`:array>,`platform`:STRING>,`library`:struct<`name`:STRING,`version`:STRING>,`userAgent`:STRING,`amp`:struct<`id`:STRING>,`locale`:STRING,`timezone`:STRING,`campaign`:struct<`cont`:STRING,`medium`:STRING,`soupnc_0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000`:STRING,`utm_medium`:STRING,`id`:STRING,`term`:STRING,`utm_content`:STRING,`conten`:STRING,`utm_source`:STRING,`source`:STRING,`name`:STRING,`content`:STRING,`c`:STRING,`utm_campaign`:STRING,`co`:STRING,`tm_source`:STRING,`con`:STRING>,`page`:struct<`url`:STRING,`path`:STRING,`title`:STRING,`referrer`:STRING,`search`:STRING>>,`anonymousId`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`integrations`struct<`library`:struct<`version`:STRING,`name`:STRING>,`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`referrer`:STRING,`title`:STRING>,`campaign`:struct<`content`:STRING,`source`:STRING,`medium`:STRING,`name`:STRING>>,`projectId`STRING,`type`STRING,`messageId`STRING,`channel`STRING,`properties`struct<`label`:STRING,`value`:STRING,`env`:STRING,`site_id`:STRING,`searchId`:STRING,`extras`:struct<`facilityId`:STRING,`priceMeta`:STRING,`sizeBucket`:STRING,`unitId`:STRING>,`moveInDateSelected`:STRING,`chatbot`:STRING,`category`:STRING,`isReact`:STRING,`Hit_Timestamp`:STRING,`breadcrumb`:STRING,`extra`:struct<`unitId`:STRING,`facilityId`:STRING>>,`originalTimestamp`STRING,`event`STRING,`receivedAt`STRING,`_origin`STRING,`userId`STRING,`timestamp`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-segment-reactfoot-prod/separated_dt/click'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_click`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_click"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}