Schema Info
Schema Name: sfdl_prod_segment.reactfoot_experiment_impression
- created: 2017-11-02 14:03:46
- disabled: False
- format: raw
- id: 137
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_prod_segment", "table": "reactfoot_experiment_impression" } - type: segment
Schema Versions: 3
-
Version 1174330
- created: 2025-01-27 13:51:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_experiment_impression`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_experiment_impression`\n(\n`version`STRING,`sentAt`STRING,`context`struct<`ip`:STRING,`userAgentData`:struct<`mobile`:STRING,`brands`:array,`unbundled`:array >,`integrations`struct<`Google_Analytics`:STRING,`All`:STRING>,`projectId`STRING,`type`STRING,`messageId`STRING,`channel`STRING,`properties`struct<`experiment_name`:STRING,`isReact`:STRING,`env`:STRING,`experiment_variation`:STRING,`Hit_Timestamp`:STRING,`site_id`:STRING>,`event`STRING,`originalTimestamp`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/experiment_impression'\n", "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_experiment_impression" ] - hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression
- id: 1174330
- processed: 1
- raw_data:
{ "__segment_internal": {}, "_metadata": { "bundled": [ "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c13c7c1386430001b3c90e" ], "unbundled": [] }, "_origin": "2025-01-27T19:49:58Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1737936000000/1738007214440.events-archiver-480-43..81b2a094-1e09-4979-ac19-178be9990f78.gz|analytics-segment-separator-prod:$LATEST", "anonymousId": "426dee93-5bc8-4fff-b183-701e915bb946", "channel": "client", "context": { "campaign": { "content": "Non Reservers| 30 Days", "id": "120211029826580476", "medium": "paid", "name": "SF Facebook|General|Remarketing", "source": "facebook", "term": "", "tm_source": "facebook" }, "ip": "2600:100c:b21c:2ca0:f814:51e8:dcc3:e547", "library": { "name": "analytics.js", "version": "next-1.76.0" }, "locale": "en-US", "page": { "path": "/lpg/lf/hp-copy", "referrer": "https://7efd7499b775b90009dc1e5f560dfa19.safeframe.googlesyndication.com/", "search": "?tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=SF+Google%7CPMAX&utm_content=&ploc=9027073&utm_term=&location={location}&iloc=&mkwid=|pcrid||pkw||pmt||pdv|m|pgrid||cpgnid|18795194638|ptaid||adext|&pgrid=&ptaid=&gad_source=5&gclid=CjwKCAiA-ty8BhA_EiwAkyoa32B93grpj3vDqIQldEceU7m8V0GwSd3j3SXHO5b9ZiNaSKmh6eGWHhoCpIMQAvD_BwE", "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=9027073&utm_term=&location={location}&iloc=&mkwid=|pcrid||pkw||pmt||pdv|m|pgrid||cpgnid|18795194638|ptaid||adext|&pgrid=&ptaid=&gad_source=5&gclid=CjwKCAiA-ty8BhA_EiwAkyoa32B93grpj3vDqIQldEceU7m8V0GwSd3j3SXHO5b9ZiNaSKmh6eGWHhoCpIMQAvD_BwE" }, "timezone": "America/Chicago", "userAgent": "Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Mobile Safari/537.36", "userAgentData": { "brands": [ { "brand": "Not A(Brand", "version": "8" }, { "brand": "Chromium", "version": "132" }, { "brand": "Google Chrome", "version": "132" } ], "mobile": true, "platform": "Android" } }, "event": "experiment_impression", "integrations": { "All": true, "Google Analytics": false }, "messageId": "ajs-next-1738003972180-c7647353-48b7-4040-be79-b267a88ac2e0", "originalTimestamp": "2025-01-27T18:52:52.180Z", "projectId": "a0wkEvFBBK", "properties": { "Hit Timestamp": 1738003971493, "env": "production", "experiment_name": "sf_12700_sfdc_paid_landing_refresh", "experiment_variation": "control", "isReact": true, "site_id": -1 }, "receivedAt": "2025-01-27T18:52:52.270Z", "sentAt": "2025-01-27T18:52:52.218Z", "timestamp": "2025-01-27T18:52:52.232Z", "type": "track", "userId": "633f78d6eff0fa56133cb70c46be7c5c", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.amp.id": "string", "context.campaign.c": "string", "context.campaign.camp": "string", "context.campaign.campaig": "string", "context.campaign.campaignW": "string", "context.campaign.co": "string", "context.campaign.con": "string", "context.campaign.cont": "string", "context.campaign.conten": "string", "context.campaign.content": "string", "context.campaign.contentf": "string", "context.campaign.expid": "string", "context.campaign.id": "string", "context.campaign.ing": "string", "context.campaign.m": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.referrer": "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_id": "string", "context.campaign.utm_medium": "string", "context.campaign.utm_source": "string", "context.campaign.utm_term": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.timezone": "string", "context.userAgent": "string", "context.userAgentData.brands": [ { "brand": "string", "version": "string" } ], "context.userAgentData.mobile": "string", "context.userAgentData.platform": "string", "event": "string", "integrations.All": "string", "integrations.Google_Analytics": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.env": "string", "properties.experiment_name": "string", "properties.experiment_variation": "string", "properties.isReact": "string", "properties.site_id": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 137
- schema_scan_id: 136093782
- updated: 2025-01-27 14:00:59
-
Version 1154810
- created: 2025-01-10 15:49:32
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_experiment_impression`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_experiment_impression`\n(\n`version`STRING,`sentAt`STRING,`context`struct<`ip`:STRING,`userAgentData`:struct<`mobile`:STRING,`brands`:array,`unbundled`:array >,`integrations`struct<`All`:STRING,`Google_Analytics`:STRING>,`projectId`STRING,`type`STRING,`messageId`STRING,`channel`STRING,`properties`struct<`experiment_name`:STRING,`isReact`:STRING,`env`:STRING,`experiment_variation`:STRING,`Hit_Timestamp`:STRING,`site_id`:STRING>,`event`STRING,`originalTimestamp`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/experiment_impression'\n", "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_experiment_impression" ] - hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression
- id: 1154810
- processed: 1
- raw_data:
{ "__segment_internal": {}, "_metadata": { "bundled": [ "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c13c7c1386430001b3c90e" ], "unbundled": [] }, "_origin": "2025-01-10T21:49:11Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1736467200000/1736545700643.events-archiver-480-34..f4e394cb-7053-40bb-8abc-3679be95b8b6.gz|analytics-segment-separator-prod:$LATEST", "anonymousId": "92720934-a0f1-4753-bdff-d2ab0388ca4e", "channel": "client", "context": { "campaign": { "content": "", "contentf": "", "medium": "paidsearch", "name": "SF Google|Brand", "source": "google", "term": "sparefoot" }, "ip": "147.81.108.196", "library": { "name": "analytics.js", "version": "next-1.76.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%7CBrand&utm_content=&ploc=1015612&utm_term=sparefoot&location=%7Blocation%7D&iloc=&mkwid=sAPsYtwFU%7Cpcrid%7C707650817657%7Cpkw%7Csparefoot%7Cpmt%7Ce%7Cpdv%7Cm%7Cpgrid%7C22648438511%7Ccpgnid%7C293483831%7Cptaid%7Ckwd-18405084123%7Cadext%7C&pgrid=22648438511&ptaid=kwd-18405084123&gad_source=1&gbraid=0AAAAAD0HYGlqBIReldDv8GIwTifU9toLZ&gclid=EAIaIQobChMI0Mv31oXsigMVDhitBh102htSEAAYASAAEgKZWPD_BwE", "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%7CBrand&utm_content=&ploc=1015612&utm_term=sparefoot&location=%7Blocation%7D&iloc=&mkwid=sAPsYtwFU%7Cpcrid%7C707650817657%7Cpkw%7Csparefoot%7Cpmt%7Ce%7Cpdv%7Cm%7Cpgrid%7C22648438511%7Ccpgnid%7C293483831%7Cptaid%7Ckwd-18405084123%7Cadext%7C&pgrid=22648438511&ptaid=kwd-18405084123&gad_source=1&gbraid=0AAAAAD0HYGlqBIReldDv8GIwTifU9toLZ&gclid=EAIaIQobChMI0Mv31oXsigMVDhitBh102htSEAAYASAAEgKZWPD_BwE" }, "timezone": "Pacific/Honolulu", "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": "Google Chrome", "version": "131" }, { "brand": "Chromium", "version": "131" }, { "brand": "Not_A Brand", "version": "24" } ], "mobile": true, "platform": "Android" } }, "event": "experiment_impression", "integrations": { "All": true, "Google Analytics": false }, "messageId": "ajs-next-1736542706742-a0f17753-fdff-42ab-8388-ca4e68c65917", "originalTimestamp": "2025-01-10T20:58:26.742Z", "projectId": "a0wkEvFBBK", "properties": { "Hit Timestamp": 1736542706268, "env": "production", "experiment_name": "sf_12700_sfdc_paid_landing_refresh", "experiment_variation": "control", "isReact": true, "site_id": -1 }, "receivedAt": "2025-01-10T20:58:27.244Z", "sentAt": "2025-01-10T20:58:26.746Z", "timestamp": "2025-01-10T20:58:27.240Z", "type": "track", "userId": "8660c93dbbdc367b76f5328e1158548a", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.amp.id": "string", "context.campaign.c": "string", "context.campaign.camp": "string", "context.campaign.campaig": "string", "context.campaign.campaignW": "string", "context.campaign.co": "string", "context.campaign.con": "string", "context.campaign.cont": "string", "context.campaign.conten": "string", "context.campaign.content": "string", "context.campaign.contentf": "string", "context.campaign.expid": "string", "context.campaign.id": "string", "context.campaign.ing": "string", "context.campaign.m": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.referrer": "string", "context.campaign.source": "string", "context.campaign.term": "string", "context.campaign.utm_campaign": "string", "context.campaign.utm_content": "string", "context.campaign.utm_id": "string", "context.campaign.utm_medium": "string", "context.campaign.utm_source": "string", "context.campaign.utm_term": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.timezone": "string", "context.userAgent": "string", "context.userAgentData.brands": [ { "brand": "string", "version": "string" } ], "context.userAgentData.mobile": "string", "context.userAgentData.platform": "string", "event": "string", "integrations.All": "string", "integrations.Google_Analytics": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.env": "string", "properties.experiment_name": "string", "properties.experiment_variation": "string", "properties.isReact": "string", "properties.site_id": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 137
- schema_scan_id: 135125235
- updated: 2025-01-10 15:57:49
-
Version 1136242
- created: 2024-12-25 12:57:09
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_experiment_impression`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_experiment_impression`\n(\n`integrations`struct<`Google_Analytics`:STRING,`All`:STRING>,`anonymousId`STRING,`sentAt`STRING,`projectId`STRING,`event`STRING,`_origin`STRING,`channel`STRING,`timestamp`STRING,`type`STRING,`version`STRING,`messageId`STRING,`properties`struct<`site_id`:STRING,`Hit_Timestamp`:STRING,`isReact`:STRING,`experiment_name`:STRING,`env`:STRING,`experiment_variation`:STRING>,`context`struct<`timezone`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`campaign`:struct<`content`:STRING,`campaignW`:STRING,`utm_term`:STRING,`con`:STRING,`source`:STRING,`medium`:STRING,`utm_campaign`:STRING,`expid`:STRING,`campaig`:STRING,`ing`:STRING,`utm_source`:STRING,`utm_id`:STRING,`m`:STRING,`camp`:STRING,`conten`:STRING,`id`:STRING,`utm_medium`:STRING,`referrer`:STRING,`utm_content`:STRING,`c`:STRING,`term`:STRING,`cont`:STRING,`name`:STRING,`co`:STRING>,`ip`:STRING,`userAgentData`:struct<`platform`:STRING,`mobile`:STRING,`brands`:array,`unbundled`:array >,`userId`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/experiment_impression'\n", "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_experiment_impression" ] - hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression
- id: 1136242
- processed: 1
- raw_data:
{ "__segment_internal": {}, "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c55a4597f7a100011813be", "59c13c7c1386430001b3c90e" ], "unbundled": [] }, "_origin": "2024-12-25T18:54:57Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1735084800000/1735152780918.events-archiver-480-30..bc34915c-d862-482e-b583-adfff828295f.gz|analytics-segment-separator-prod:$LATEST", "anonymousId": "d82f788e-b486-4aec-bc2e-929d9bc41461", "channel": "client", "context": { "campaign": { "content": "", "id": "120211029505070476", "medium": "paidsearch", "name": "SF Google|PMAX", "source": "facebook", "term": "", "utm_campaign": "SF Facebook|General|Remarketing", "utm_content": "Non Reservers| 30 Days", "utm_id": "120211029826580476", "utm_medium": "paid", "utm_term": "120211029826540476" }, "ip": "147.189.139.226", "library": { "name": "analytics.js", "version": "next-1.76.0" }, "locale": "en-US", "page": { "path": "/lpg/lf/hp-copy", "referrer": "http://toolszap.com/", "search": "?tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=SF+Google|PMAX&utm_content=&ploc=9011839&utm_term=&location={location}&iloc=&mkwid=|pcrid||pkw||pmt||pdv|c|pgrid||cpgnid|18795194638|ptaid||adext|&pgrid=&ptaid=&gad_source=5&gclid=EAIaIQobChMIzvXJ1L_DigMVy7zRBB0wqyD-EAEYASAAEgLp9fD_BwE", "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|PMAX&utm_content=&ploc=9011839&utm_term=&location={location}&iloc=&mkwid=|pcrid||pkw||pmt||pdv|c|pgrid||cpgnid|18795194638|ptaid||adext|&pgrid=&ptaid=&gad_source=5&gclid=EAIaIQobChMIzvXJ1L_DigMVy7zRBB0wqyD-EAEYASAAEgLp9fD_BwE" }, "timezone": "America/New_York", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36 CCleaner/130.0.0.0", "userAgentData": { "brands": [ { "brand": "Not_A Brand", "version": "24" } ], "mobile": false, "platform": "" } }, "event": "experiment_impression", "integrations": { "All": true, "Google Analytics": false }, "messageId": "ajs-next-1735149729566-b4869aec-fc2e-429d-9bc4-1461c70976cf", "originalTimestamp": "2024-12-25T18:02:09.566Z", "projectId": "a0wkEvFBBK", "properties": { "Hit Timestamp": 1735149725923, "env": "production", "experiment_name": "sf_12700_sfdc_paid_landing_refresh", "experiment_variation": "control", "isReact": true, "site_id": -1 }, "receivedAt": "2024-12-25T18:02:11.281Z", "sentAt": "2024-12-25T18:02:09.761Z", "timestamp": "2024-12-25T18:02:11.086Z", "type": "track", "userId": "5f160f084384739be307cf937f2bce4b", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.amp.id": "string", "context.campaign.c": "string", "context.campaign.camp": "string", "context.campaign.campaig": "string", "context.campaign.campaignW": "string", "context.campaign.co": "string", "context.campaign.con": "string", "context.campaign.cont": "string", "context.campaign.conten": "string", "context.campaign.content": "string", "context.campaign.expid": "string", "context.campaign.id": "string", "context.campaign.ing": "string", "context.campaign.m": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.referrer": "string", "context.campaign.source": "string", "context.campaign.term": "string", "context.campaign.utm_campaign": "string", "context.campaign.utm_content": "string", "context.campaign.utm_id": "string", "context.campaign.utm_medium": "string", "context.campaign.utm_source": "string", "context.campaign.utm_term": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.timezone": "string", "context.userAgent": "string", "context.userAgentData.brands": [ { "brand": "string", "version": "string" } ], "context.userAgentData.mobile": "string", "context.userAgentData.platform": "string", "event": "string", "integrations.All": "string", "integrations.Google_Analytics": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.env": "string", "properties.experiment_name": "string", "properties.experiment_variation": "string", "properties.isReact": "string", "properties.site_id": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 137
- schema_scan_id: 134200375
- updated: 2024-12-25 13:05:41
Schema Scans: 3
Last at 2025-01-27 13:51:54
-
Scan 136093782
- duration: 0:04:42.336349
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 2682, "partitions_applied": false, "success": true } - id: 136093782
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-01-27/", "name": "dt", "type": "string", "value": "2025-01-27" }, "s3": { "bucket": "sfdl-segment-reactfoot-prod", "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression", "key": "separated_dt/experiment_impression/dt=2025-01-27/1738007214440.events-archiver-480-43..81b2a094-1e09-4979-ac19-178be9990f78.json.gz" }, "schema": { "name": "sfdl_prod_segment.reactfoot_experiment_impression", "type": "segment" } } - running: False
- schema_name_id: 137
- start_time: 2025-01-27 13:51:54
- success: True
- trace_id: 11813709326197896719
-
Scan 135125235
- duration: 0:01:46.085073
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 2665, "partitions_applied": false, "success": true } - id: 135125235
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-01-10/", "name": "dt", "type": "string", "value": "2025-01-10" }, "s3": { "bucket": "sfdl-segment-reactfoot-prod", "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression", "key": "separated_dt/experiment_impression/dt=2025-01-10/1736545700643.events-archiver-480-34..f4e394cb-7053-40bb-8abc-3679be95b8b6.json.gz" }, "schema": { "name": "sfdl_prod_segment.reactfoot_experiment_impression", "type": "segment" } } - running: False
- schema_name_id: 137
- start_time: 2025-01-10 15:49:30
- success: True
- trace_id: 284072598759034065
-
Scan 134200375
- duration: 0:01:43.976355
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 2649, "partitions_applied": false, "success": true } - id: 134200375
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2024-12-25/", "name": "dt", "type": "string", "value": "2024-12-25" }, "s3": { "bucket": "sfdl-segment-reactfoot-prod", "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression", "key": "separated_dt/experiment_impression/dt=2024-12-25/1735152780918.events-archiver-480-30..bc34915c-d862-482e-b583-adfff828295f.json.gz" }, "schema": { "name": "sfdl_prod_segment.reactfoot_experiment_impression", "type": "segment" } } - running: False
- schema_name_id: 137
- start_time: 2024-12-25 12:57:07
- success: True
- trace_id: 2364949211917773545
- count: 22
- ddl:
[ "ALTER TABLE\n `sfdl_prod_segment.reactfoot_experiment_impression`\nADD\n\n\n PARTITION (dt='2025-10-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-10-20/'\n PARTITION (dt='2025-10-24') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-10-24/'\n PARTITION (dt='2025-10-26') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-10-26/'\n PARTITION (dt='2025-10-28') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-10-28/'\n PARTITION (dt='2025-11-03') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-11-03/'\n PARTITION (dt='2025-11-04') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-11-04/'\n PARTITION (dt='2025-11-09') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-11-09/'\n PARTITION (dt='2025-11-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-11-15/'\n PARTITION (dt='2025-11-19') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-11-19/'\n PARTITION (dt='2025-11-23') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-11-23/'\n PARTITION (dt='2025-11-28') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-11-28/'\n PARTITION (dt='2025-12-03') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-12-03/'\n PARTITION (dt='2025-12-05') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-12-05/'\n PARTITION (dt='2025-12-06') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-12-06/'\n PARTITION (dt='2025-12-12') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-12-12/'\n PARTITION (dt='2025-12-16') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-12-16/'\n PARTITION (dt='2026-02-10') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2026-02-10/'\n PARTITION (dt='2026-02-11') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2026-02-11/'\n PARTITION (dt='2026-02-13') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2026-02-13/'\n PARTITION (dt='2026-02-14') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2026-02-14/'\n PARTITION (dt='2026-02-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2026-02-20/'\n PARTITION (dt='2026-03-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2026-03-15/'\n;" ] - name: dt
- state:
[ { "info": { "id": 1596716, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-10-20/", "name": "dt", "value": "2025-10-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-19 21:52:58", "last_data": "2025-10-20 10:08:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1597679, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-10-24/", "name": "dt", "value": "2025-10-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-23 22:00:46", "last_data": "2025-10-24 16:06:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1598297, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-10-26/", "name": "dt", "value": "2025-10-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-26 17:02:12", "last_data": "2025-10-26 17:02:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1598767, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-10-28/", "name": "dt", "value": "2025-10-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-28 18:04:07", "last_data": "2025-10-28 18:04:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1600264, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-11-03/", "name": "dt", "value": "2025-11-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-03 05:47:06", "last_data": "2025-11-03 05:47:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1600612, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-11-04/", "name": "dt", "value": "2025-11-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-04 10:15:02", "last_data": "2025-11-04 10:15:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1601677, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-11-09/", "name": "dt", "value": "2025-11-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-08 20:00:16", "last_data": "2025-11-08 20:04:32" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1603274, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-11-15/", "name": "dt", "value": "2025-11-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-15 14:09:21", "last_data": "2025-11-15 14:17:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1606411, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-11-19/", "name": "dt", "value": "2025-11-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-19 17:55:16", "last_data": "2025-11-19 17:55:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1607756, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-11-23/", "name": "dt", "value": "2025-11-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-22 21:14:08", "last_data": "2025-11-22 21:19:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1608912, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-11-28/", "name": "dt", "value": "2025-11-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-27 20:02:50", "last_data": "2025-11-27 20:02:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1610074, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-12-03/", "name": "dt", "value": "2025-12-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-02 19:10:51", "last_data": "2025-12-02 19:10:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1610571, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-12-05/", "name": "dt", "value": "2025-12-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-04 23:06:44", "last_data": "2025-12-04 23:06:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1611084, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-12-06/", "name": "dt", "value": "2025-12-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-05 22:03:09", "last_data": "2025-12-05 22:03:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1612803, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-12-12/", "name": "dt", "value": "2025-12-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-12 07:02:32", "last_data": "2025-12-12 07:02:32" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1616291, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-12-16/", "name": "dt", "value": "2025-12-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-16 09:40:12", "last_data": "2025-12-16 12:50:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1631346, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2026-02-10/", "name": "dt", "value": "2026-02-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-10 11:49:25", "last_data": "2026-02-10 11:56:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1631669, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2026-02-11/", "name": "dt", "value": "2026-02-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-11 18:31:04", "last_data": "2026-02-11 18:34:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1632192, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2026-02-13/", "name": "dt", "value": "2026-02-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-13 12:57:58", "last_data": "2026-02-13 12:57:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1632270, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2026-02-14/", "name": "dt", "value": "2026-02-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-13 20:56:13", "last_data": "2026-02-13 20:56:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1635836, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2026-02-20/", "name": "dt", "value": "2026-02-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-20 12:59:15", "last_data": "2026-02-20 13:04:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1646066, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2026-03-15/", "name": "dt", "value": "2026-03-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-15 15:47:30", "last_data": "2026-03-15 15:47:30" }, "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.camp": "string", "context.campaign.campaig": "string", "context.campaign.campaignW": "string", "context.campaign.co": "string", "context.campaign.con": "string", "context.campaign.cont": "string", "context.campaign.conten": "string", "context.campaign.content": "string", "context.campaign.contentf": "string", "context.campaign.expid": "string", "context.campaign.id": "string", "context.campaign.ing": "string", "context.campaign.m": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.referrer": "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_id": "string", "context.campaign.utm_medium": "string", "context.campaign.utm_source": "string", "context.campaign.utm_term": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.timezone": "string", "context.userAgent": "string", "context.userAgentData.brands": [ { "brand": "string", "version": "string" } ], "context.userAgentData.mobile": "string", "context.userAgentData.platform": "string", "event": "string", "integrations.All": "string", "integrations.Google_Analytics": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.env": "string", "properties.experiment_name": "string", "properties.experiment_variation": "string", "properties.isReact": "string", "properties.site_id": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - created: 2025-01-27 13:51:56
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_experiment_impression`\n(\n`version`STRING,`sentAt`STRING,`context`struct<`ip`:STRING,`userAgentData`:struct<`mobile`:STRING,`brands`:array,`unbundled`:array >,`integrations`struct<`Google_Analytics`:STRING,`All`:STRING>,`projectId`STRING,`type`STRING,`messageId`STRING,`channel`STRING,`properties`struct<`experiment_name`:STRING,`isReact`:STRING,`env`:STRING,`experiment_variation`:STRING,`Hit_Timestamp`:STRING,`site_id`:STRING>,`event`STRING,`originalTimestamp`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/experiment_impression'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_experiment_impression`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_experiment_impression" }
- 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:03:46",
"disabled": false,
"format": "raw",
"id": 137,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_prod_segment",
"table": "reactfoot_experiment_impression"
},
"type": "segment"
},
"partition": {
"count": 22,
"ddl": [
"ALTER TABLE\n `sfdl_prod_segment.reactfoot_experiment_impression`\nADD\n\n\n PARTITION (dt='2025-10-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-10-20/'\n PARTITION (dt='2025-10-24') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-10-24/'\n PARTITION (dt='2025-10-26') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-10-26/'\n PARTITION (dt='2025-10-28') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-10-28/'\n PARTITION (dt='2025-11-03') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-11-03/'\n PARTITION (dt='2025-11-04') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-11-04/'\n PARTITION (dt='2025-11-09') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-11-09/'\n PARTITION (dt='2025-11-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-11-15/'\n PARTITION (dt='2025-11-19') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-11-19/'\n PARTITION (dt='2025-11-23') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-11-23/'\n PARTITION (dt='2025-11-28') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-11-28/'\n PARTITION (dt='2025-12-03') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-12-03/'\n PARTITION (dt='2025-12-05') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-12-05/'\n PARTITION (dt='2025-12-06') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-12-06/'\n PARTITION (dt='2025-12-12') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-12-12/'\n PARTITION (dt='2025-12-16') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-12-16/'\n PARTITION (dt='2026-02-10') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2026-02-10/'\n PARTITION (dt='2026-02-11') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2026-02-11/'\n PARTITION (dt='2026-02-13') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2026-02-13/'\n PARTITION (dt='2026-02-14') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2026-02-14/'\n PARTITION (dt='2026-02-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2026-02-20/'\n PARTITION (dt='2026-03-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2026-03-15/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 1596716,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-10-20/",
"name": "dt",
"value": "2025-10-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-19 21:52:58",
"last_data": "2025-10-20 10:08:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1597679,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-10-24/",
"name": "dt",
"value": "2025-10-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-23 22:00:46",
"last_data": "2025-10-24 16:06:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1598297,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-10-26/",
"name": "dt",
"value": "2025-10-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-26 17:02:12",
"last_data": "2025-10-26 17:02:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1598767,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-10-28/",
"name": "dt",
"value": "2025-10-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-28 18:04:07",
"last_data": "2025-10-28 18:04:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1600264,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-11-03/",
"name": "dt",
"value": "2025-11-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-03 05:47:06",
"last_data": "2025-11-03 05:47:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1600612,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-11-04/",
"name": "dt",
"value": "2025-11-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-04 10:15:02",
"last_data": "2025-11-04 10:15:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1601677,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-11-09/",
"name": "dt",
"value": "2025-11-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-08 20:00:16",
"last_data": "2025-11-08 20:04:32"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1603274,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-11-15/",
"name": "dt",
"value": "2025-11-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-15 14:09:21",
"last_data": "2025-11-15 14:17:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1606411,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-11-19/",
"name": "dt",
"value": "2025-11-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-19 17:55:16",
"last_data": "2025-11-19 17:55:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1607756,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-11-23/",
"name": "dt",
"value": "2025-11-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-22 21:14:08",
"last_data": "2025-11-22 21:19:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1608912,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-11-28/",
"name": "dt",
"value": "2025-11-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-27 20:02:50",
"last_data": "2025-11-27 20:02:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1610074,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-12-03/",
"name": "dt",
"value": "2025-12-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-02 19:10:51",
"last_data": "2025-12-02 19:10:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1610571,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-12-05/",
"name": "dt",
"value": "2025-12-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-04 23:06:44",
"last_data": "2025-12-04 23:06:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1611084,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-12-06/",
"name": "dt",
"value": "2025-12-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-05 22:03:09",
"last_data": "2025-12-05 22:03:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1612803,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-12-12/",
"name": "dt",
"value": "2025-12-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-12 07:02:32",
"last_data": "2025-12-12 07:02:32"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1616291,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2025-12-16/",
"name": "dt",
"value": "2025-12-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-16 09:40:12",
"last_data": "2025-12-16 12:50:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1631346,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2026-02-10/",
"name": "dt",
"value": "2026-02-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-10 11:49:25",
"last_data": "2026-02-10 11:56:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1631669,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2026-02-11/",
"name": "dt",
"value": "2026-02-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-11 18:31:04",
"last_data": "2026-02-11 18:34:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1632192,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2026-02-13/",
"name": "dt",
"value": "2026-02-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-13 12:57:58",
"last_data": "2026-02-13 12:57:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1632270,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2026-02-14/",
"name": "dt",
"value": "2026-02-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-13 20:56:13",
"last_data": "2026-02-13 20:56:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1635836,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2026-02-20/",
"name": "dt",
"value": "2026-02-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-20 12:59:15",
"last_data": "2026-02-20 13:04:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1646066,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_impression/dt=2026-03-15/",
"name": "dt",
"value": "2026-03-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-15 15:47:30",
"last_data": "2026-03-15 15:47:30"
},
"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.camp": "string",
"context.campaign.campaig": "string",
"context.campaign.campaignW": "string",
"context.campaign.co": "string",
"context.campaign.con": "string",
"context.campaign.cont": "string",
"context.campaign.conten": "string",
"context.campaign.content": "string",
"context.campaign.contentf": "string",
"context.campaign.expid": "string",
"context.campaign.id": "string",
"context.campaign.ing": "string",
"context.campaign.m": "string",
"context.campaign.medium": "string",
"context.campaign.name": "string",
"context.campaign.referrer": "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_id": "string",
"context.campaign.utm_medium": "string",
"context.campaign.utm_source": "string",
"context.campaign.utm_term": "string",
"context.ip": "string",
"context.library.name": "string",
"context.library.version": "string",
"context.locale": "string",
"context.page.path": "string",
"context.page.referrer": "string",
"context.page.search": "string",
"context.page.title": "string",
"context.page.url": "string",
"context.timezone": "string",
"context.userAgent": "string",
"context.userAgentData.brands": [
{
"brand": "string",
"version": "string"
}
],
"context.userAgentData.mobile": "string",
"context.userAgentData.platform": "string",
"event": "string",
"integrations.All": "string",
"integrations.Google_Analytics": "string",
"messageId": "string",
"originalTimestamp": "string",
"projectId": "string",
"properties.Hit_Timestamp": "string",
"properties.env": "string",
"properties.experiment_name": "string",
"properties.experiment_variation": "string",
"properties.isReact": "string",
"properties.site_id": "string",
"receivedAt": "string",
"sentAt": "string",
"timestamp": "string",
"type": "string",
"userId": "string",
"version": "string"
},
"created": "2025-01-27 13:51:56",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_experiment_impression`\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,`campaign`:struct<`cont`:STRING,`medium`:STRING,`m`:STRING,`referrer`:STRING,`co`:STRING,`camp`:STRING,`utm_medium`:STRING,`id`:STRING,`campaignW`:STRING,`term`:STRING,`utm_content`:STRING,`conten`:STRING,`utm_term`:STRING,`utm_id`:STRING,`source`:STRING,`utm_source`:STRING,`contentf`:STRING,`name`:STRING,`content`:STRING,`campaig`:STRING,`c`:STRING,`expid`:STRING,`utm_campaign`:STRING,`ing`:STRING,`tm_source`:STRING,`con`:STRING>,`timezone`:STRING,`page`:struct<`url`:STRING,`path`:STRING,`title`:STRING,`referrer`:STRING,`search`:STRING>>,`anonymousId`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`integrations`struct<`Google_Analytics`:STRING,`All`:STRING>,`projectId`STRING,`type`STRING,`messageId`STRING,`channel`STRING,`properties`struct<`experiment_name`:STRING,`isReact`:STRING,`env`:STRING,`experiment_variation`:STRING,`Hit_Timestamp`:STRING,`site_id`:STRING>,`event`STRING,`originalTimestamp`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/experiment_impression'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_experiment_impression`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_experiment_impression"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}