Schema Info
Schema Name: sfdl_prod_segment.reactfoot_experiment_bucketing
- created: 2017-11-02 14:05:27
- disabled: False
- format: raw
- id: 139
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_prod_segment", "table": "reactfoot_experiment_bucketing" } - type: segment
Schema Versions: 3
-
Version 1260557
- created: 2025-04-10 21:01:44
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_experiment_bucketing`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_experiment_bucketing`\n(\n`integrations`struct<`Google_Analytics`:STRING,`All`:STRING>,`messageId`STRING,`sentAt`STRING,`type`STRING,`originalTimestamp`STRING,`timestamp`STRING,`_origin`STRING,`context`struct<`amp`:struct<`id`:STRING>,`page`:struct<`title`:STRING,`search`:STRING,`referrer`:STRING,`path`:STRING,`url`:STRING>,`campaign`:struct<`ca`:STRING,`content`:STRING,`term`:STRING,`sou`:STRING,`id`:STRING,`con`:STRING,`audience`:STRING,`7510010745838ontent`:STRING,`campaig`:STRING,`expid`:STRING,`utm_source`:STRING,`so`:STRING,`utm_id`:STRING,`cont`:STRING,`utm_term`:STRING,`soupnc_0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000`:STRING,`camp`:STRING,`source`:STRING,`ing`:STRING,`c`:STRING,`utm_content`:STRING,`contentf`:STRING,`conten`:STRING,`utm_medium`:STRING,`tm_source`:STRING,`medium`:STRING,`campaignW`:STRING,`referrer`:STRING,`utm_campaign`:STRING,`name`:STRING,`co`:STRING>,`locale`:STRING,`userAgentData`:struct<`brands`:array,`unbundled`:array >,`properties`struct<`Hit_Timestamp`:STRING,`isReact`:STRING,`site_id`:STRING,`env`:STRING,`experiment_variation`:STRING,`experiment_name`:STRING>,`projectId`STRING,`receivedAt`STRING,`userId`STRING,`event`STRING,`anonymousId`STRING,`channel`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing'\n", "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_experiment_bucketing" ] - hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing
- id: 1260557
- processed: 1
- raw_data:
{ "__segment_internal": {}, "_metadata": { "bundled": [ "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c13c7c1386430001b3c90e" ], "failedInitializations": [ "Google Tag Manager" ], "unbundled": [] }, "_origin": "2025-04-11T01:59:58Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1744329600000/1744336653318.events-archiver-480-22..2f9dcedf-e5a5-4c09-8d33-8585d298a965.gz|analytics-segment-separator-prod:$LATEST", "anonymousId": "0acfd454-e015-4521-97fc-822ac8ddf879", "channel": "client", "context": { "campaign": { "audience": "fb_new_customer", "content": "LM_SFDC_ADV+_CONVERSION_WEB_V2 Ad set", "id": "120216510040870476_v2_s01", "medium": "paid", "name": "LM_SFDC_ADV+_CONVERSION_WEB_V2 Campaign", "source": "facebook", "term": "dfw self storage" }, "ip": "2607:fb91:1139:236:b0b9:d86f:4010:538", "library": { "name": "analytics.js", "version": "next-1.77.0" }, "locale": "en-US", "page": { "path": "/Denver-CO-self-storage/Midgard-Self-Storage-Denver-741-Osage-Street-224758.html", "referrer": "https://www.sparefoot.com/Lakewood-CO-self-storage/Public-Storage-Lakewood-7701-W-6th-Ave-215776.html?searchType=vehicle", "search": "", "title": "Midgard Self Storage - Denver - 741 Osage Street | 741 Osage Street | SpareFoot", "url": "https://www.sparefoot.com/Denver-CO-self-storage/Midgard-Self-Storage-Denver-741-Osage-Street-224758.html" }, "timezone": "America/Denver", "userAgent": "Mozilla/5.0 (iPhone; CPU iPhone OS 18_1_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/134.0.6998.99 Mobile/15E148 Safari/604.1", "userAgentData": { "brands": [ { "brand": "Chromium", "version": "135" } ], "mobile": true, "platform": "Android" } }, "event": "experiment_bucketing", "integrations": { "All": true, "Google Analytics": false }, "messageId": "ajs-next-1744333205259-74252bbb-a192-4746-9381-de42adabb28a", "originalTimestamp": "2025-04-11T01:00:05.259Z", "projectId": "a0wkEvFBBK", "properties": { "Hit Timestamp": 1744333205049, "env": "production", "experiment_name": "sf_12510_hidden_facilities", "experiment_variation": "variation", "isReact": true, "site_id": -1 }, "receivedAt": "2025-04-11T01:00:05.581Z", "sentAt": "2025-04-11T01:00:05.264Z", "timestamp": "2025-04-11T01:00:05.576Z", "type": "track", "userId": "f002838a9641832cd40969c1e6c85b90", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.amp.id": "string", "context.campaign.7510010745838ontent": "string", "context.campaign.audience": "string", "context.campaign.c": "string", "context.campaign.ca": "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.medium": "string", "context.campaign.name": "string", "context.campaign.referrer": "string", "context.campaign.so": "string", "context.campaign.sou": "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_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: 139
- schema_scan_id: 140355457
- updated: 2025-04-10 21:11:22
-
Version 1174376
- created: 2025-01-27 14:16:24
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_experiment_bucketing`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_experiment_bucketing`\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>,`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/experiment_bucketing'\n", "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_experiment_bucketing" ] - hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing
- id: 1174376
- processed: 1
- raw_data:
{ "__segment_internal": {}, "_metadata": { "bundled": [ "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c13c7c1386430001b3c90e" ], "failedInitializations": [ "Google Tag Manager" ], "retryCount": 2, "unbundled": [] }, "_origin": "2025-01-27T20:16:18Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1737936000000/1738008875356.events-archiver-480-33..b97204c5-9e4e-4d23-add4-b55043d5547f.gz|analytics-segment-separator-prod:$LATEST", "anonymousId": "e558e957-4b33-4f79-9ddb-71b8a7235ae1", "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": "FL-self-storage", "tm_source": "facebook" }, "ip": "68.104.231.64", "library": { "name": "analytics.js", "version": "next-1.76.0" }, "locale": "en-US", "page": { "path": "/Peoria-AZ-self-storage/Mission-RV-Mini-Storage-205890.html", "referrer": "https://www.google.com/", "search": "", "title": "Mission RV & Mini Storage | 9649 W Olive Ave | SpareFoot", "url": "https://www.sparefoot.com/Peoria-AZ-self-storage/Mission-RV-Mini-Storage-205890.html" }, "timezone": "America/Phoenix", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36", "userAgentData": { "brands": [ { "brand": "Not_A Brand", "version": "24" } ], "mobile": false, "platform": "Windows" } }, "event": "experiment_bucketing", "integrations": { "All": true, "Google Analytics": false }, "messageId": "ajs-next-1738005296896-9ddb71b8-a723-4ae1-a6fd-fcbfe7ab299e", "originalTimestamp": "2025-01-27T19:14:56.896Z", "projectId": "a0wkEvFBBK", "properties": { "Hit Timestamp": 1738005295115, "env": "production", "experiment_name": "sf_13380_sfdc_new_filter", "experiment_variation": "variation", "isReact": true, "site_id": -1 }, "receivedAt": "2025-01-27T19:14:57.392Z", "sentAt": "2025-01-27T19:14:56.918Z", "timestamp": "2025-01-27T19:14:57.370Z", "type": "track", "userId": "59563ea9c360bec30da09e3ab62df572", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.amp.id": "string", "context.campaign.7510010745838ontent": "string", "context.campaign.c": "string", "context.campaign.ca": "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.medium": "string", "context.campaign.name": "string", "context.campaign.referrer": "string", "context.campaign.so": "string", "context.campaign.sou": "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_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: 139
- schema_scan_id: 136094979
- updated: 2025-01-27 14:26:12
-
Version 1154809
- created: 2025-01-10 15:48:48
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_experiment_bucketing`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_experiment_bucketing`\n(\n`version`STRING,`receivedAt`STRING,`integrations`struct<`Google_Analytics`:STRING,`All`:STRING>,`type`STRING,`sentAt`STRING,`originalTimestamp`STRING,`channel`STRING,`context`struct<`amp`:struct<`id`:STRING>,`library`:struct<`name`:STRING,`version`:STRING>,`page`:struct<`url`:STRING,`title`:STRING,`path`:STRING,`referrer`:STRING,`search`:STRING>,`timezone`:STRING,`locale`:STRING,`userAgentData`:struct<`platform`:STRING,`mobile`:STRING,`brands`:array,`unbundled`:array >,`timestamp`STRING,`anonymousId`STRING,`projectId`STRING,`userId`STRING,`messageId`STRING,`event`STRING,`_origin`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing'\n", "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_experiment_bucketing" ] - hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing
- id: 1154809
- processed: 1
- raw_data:
{ "__segment_internal": {}, "_metadata": { "bundled": [ "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c13c7c1386430001b3c90e" ], "failedInitializations": [ "Google Tag Manager" ], "unbundled": [] }, "_origin": "2025-01-10T21:48:35Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1736467200000/1736545621502.events-archiver-480-17..62964f9c-cfa5-440a-9654-80a9453a9028.gz|analytics-segment-separator-prod:$LATEST", "anonymousId": "781e6e34-91a6-49df-ac0c-1b1fe54c926c", "channel": "client", "context": { "campaign": { "content": "", "contentf": "", "medium": "paidsearch", "name": "SF Google|PMAX", "source": "google", "term": "" }, "ip": "2603:8001:4b00:8f83:b5fa:93c0:cc19:ef4d", "library": { "name": "analytics.js", "version": "next-1.76.0" }, "locale": "en-US", "page": { "path": "/reservation/confirmation/HJ5M737EV", "referrer": "https://www.sparefoot.com/Calimesa-CA-self-storage/L004-SFL-Calimesa-236632.html?searchType=storage&unitSizeFilters=5x10&unitType=unit&unitId=31896483", "search": "", "title": "(L004) SFL Calimesa | 540 West Avenue L | SpareFoot", "url": "https://www.sparefoot.com/reservation/confirmation/HJ5M737EV" }, "timezone": "America/Los_Angeles", "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": "experiment_bucketing", "integrations": { "All": true, "Google Analytics": false }, "messageId": "ajs-next-1736542048134-66b792bf-d6e3-49c4-869e-f621f30f3f06", "originalTimestamp": "2025-01-10T20:47:28.134Z", "projectId": "a0wkEvFBBK", "properties": { "Hit Timestamp": 1736542047708, "env": "production", "experiment_name": "sf_13380_sfdc_new_filter", "experiment_variation": "control", "isReact": true, "site_id": -1 }, "receivedAt": "2025-01-10T20:47:28.030Z", "sentAt": "2025-01-10T20:47:28.164Z", "timestamp": "2025-01-10T20:47:28.000Z", "type": "track", "userId": "464a96fb12030adfd9d069ba38b173bc", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.amp.id": "string", "context.campaign.7510010745838ontent": "string", "context.campaign.c": "string", "context.campaign.ca": "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.medium": "string", "context.campaign.name": "string", "context.campaign.referrer": "string", "context.campaign.so": "string", "context.campaign.sou": "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_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: 139
- schema_scan_id: 135125172
- updated: 2025-01-10 15:57:35
Schema Scans: 6
Last at 2026-04-17 14:52:33
-
Scan 162195008
- duration: 0:00:01.672092
- exit_message:
{ "ddl_changed": false, "partitions_applied": false, "success": true } - id: 162195008
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-04-17/", "name": "dt", "type": "string", "value": "2026-04-17" }, "s3": { "bucket": "sfdl-segment-reactfoot-prod", "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing", "key": "separated_dt/experiment_bucketing/dt=2026-04-17/1776455126758.events-archiver-480-20..64c42597-a227-4256-904b-de40851b1a64.json.gz" }, "schema": { "name": "sfdl_prod_segment.reactfoot_experiment_bucketing", "type": "segment" } } - running: False
- schema_name_id: 139
- start_time: 2026-04-17 14:52:33
- success: True
- trace_id: 17267366076021673062
-
Scan 162194774
- duration: 0:00:01.942891
- exit_message:
{ "ddl_changed": false, "partitions_applied": false, "success": true } - id: 162194774
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-04-17/", "name": "dt", "type": "string", "value": "2026-04-17" }, "s3": { "bucket": "sfdl-segment-reactfoot-prod", "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing", "key": "separated_dt/experiment_bucketing/dt=2026-04-17/1776455126758.events-archiver-480-20..64c42597-a227-4256-904b-de40851b1a64.json.gz" }, "schema": { "name": "sfdl_prod_segment.reactfoot_experiment_bucketing", "type": "segment" } } - running: False
- schema_name_id: 139
- start_time: 2026-04-17 14:51:18
- success: True
- trace_id: 8514058090123751487
-
Scan 162194502
- duration: 0:00:04.580776
- exit_message:
{ "ddl_changed": false, "partitions_applied": true, "success": true } - id: 162194502
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-04-17/", "name": "dt", "type": "string", "value": "2026-04-17" }, "s3": { "bucket": "sfdl-segment-reactfoot-prod", "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing", "key": "separated_dt/experiment_bucketing/dt=2026-04-17/1776455126758.events-archiver-480-20..64c42597-a227-4256-904b-de40851b1a64.json.gz" }, "schema": { "name": "sfdl_prod_segment.reactfoot_experiment_bucketing", "type": "segment" } } - running: False
- schema_name_id: 139
- start_time: 2026-04-17 14:46:19
- success: True
- trace_id: 7514467911449168367
-
Scan 140355457
- duration: 0:01:50.023795
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 2756, "partitions_applied": false, "success": true } - id: 140355457
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-04-11/", "name": "dt", "type": "string", "value": "2025-04-11" }, "s3": { "bucket": "sfdl-segment-reactfoot-prod", "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing", "key": "separated_dt/experiment_bucketing/dt=2025-04-11/1744336653318.events-archiver-480-22..2f9dcedf-e5a5-4c09-8d33-8585d298a965.json.gz" }, "schema": { "name": "sfdl_prod_segment.reactfoot_experiment_bucketing", "type": "segment" } } - running: False
- schema_name_id: 139
- start_time: 2025-04-10 21:01:42
- success: True
- trace_id: 6819479644951582028
-
Scan 136094979
- duration: 0:04:42.918214
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 2682, "partitions_applied": false, "success": true } - id: 136094979
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/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_bucketing", "key": "separated_dt/experiment_bucketing/dt=2025-01-27/1738008875356.events-archiver-480-33..b97204c5-9e4e-4d23-add4-b55043d5547f.json.gz" }, "schema": { "name": "sfdl_prod_segment.reactfoot_experiment_bucketing", "type": "segment" } } - running: False
- schema_name_id: 139
- start_time: 2025-01-27 14:16:22
- success: True
- trace_id: 12156321050155288223
-
Scan 135125172
- duration: 0:01:04.829161
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 0, "partitions_applied": false, "success": true } - id: 135125172
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/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_bucketing", "key": "separated_dt/experiment_bucketing/dt=2025-01-10/1736545621502.events-archiver-480-17..62964f9c-cfa5-440a-9654-80a9453a9028.json.gz" }, "schema": { "name": "sfdl_prod_segment.reactfoot_experiment_bucketing", "type": "segment" } } - running: False
- schema_name_id: 139
- start_time: 2025-01-10 15:48:46
- success: True
- trace_id: 2251281513586124860
- count: 71
- ddl:
[ "ALTER TABLE\n `sfdl_prod_segment.reactfoot_experiment_bucketing`\nADD\n\n\n PARTITION (dt='2025-10-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-15/'\n PARTITION (dt='2025-10-16') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-16/'\n PARTITION (dt='2025-10-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-20/'\n PARTITION (dt='2025-10-21') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-21/'\n PARTITION (dt='2025-10-23') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-23/'\n PARTITION (dt='2025-10-24') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-24/'\n PARTITION (dt='2025-10-26') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-26/'\n PARTITION (dt='2025-10-27') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-27/'\n PARTITION (dt='2025-10-28') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-28/'\n PARTITION (dt='2025-10-30') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-30/'\n PARTITION (dt='2025-11-03') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-03/'\n PARTITION (dt='2025-11-04') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-04/'\n PARTITION (dt='2025-11-09') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-09/'\n PARTITION (dt='2025-11-11') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-11/'\n PARTITION (dt='2025-11-12') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-12/'\n PARTITION (dt='2025-11-13') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-13/'\n PARTITION (dt='2025-11-14') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-14/'\n PARTITION (dt='2025-11-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-15/'\n PARTITION (dt='2025-11-19') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-19/'\n PARTITION (dt='2025-11-23') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-23/'\n PARTITION (dt='2025-11-25') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-25/'\n PARTITION (dt='2025-11-26') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-26/'\n PARTITION (dt='2025-11-28') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-28/'\n PARTITION (dt='2025-11-30') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-30/'\n PARTITION (dt='2025-12-01') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-01/'\n PARTITION (dt='2025-12-02') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-02/'\n PARTITION (dt='2025-12-03') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-03/'\n PARTITION (dt='2025-12-04') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-04/'\n PARTITION (dt='2025-12-05') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-05/'\n PARTITION (dt='2025-12-06') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-06/'\n PARTITION (dt='2025-12-12') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-12/'\n PARTITION (dt='2025-12-14') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-14/'\n PARTITION (dt='2025-12-16') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-16/'\n PARTITION (dt='2025-12-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-20/'\n PARTITION (dt='2025-12-29') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-29/'\n PARTITION (dt='2025-12-30') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-30/'\n PARTITION (dt='2026-01-03') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-03/'\n PARTITION (dt='2026-01-04') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-04/'\n PARTITION (dt='2026-01-06') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-06/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-07/'\n PARTITION (dt='2026-01-13') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-13/'\n PARTITION (dt='2026-01-14') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-14/'\n PARTITION (dt='2026-01-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-15/'\n PARTITION (dt='2026-01-16') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-16/'\n PARTITION (dt='2026-01-18') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-18/'\n PARTITION (dt='2026-01-19') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-19/'\n PARTITION (dt='2026-01-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-20/'\n PARTITION (dt='2026-01-21') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-21/'\n PARTITION (dt='2026-01-28') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-28/'\n PARTITION (dt='2026-01-29') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-29/'\n PARTITION (dt='2026-01-31') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-31/'\n PARTITION (dt='2026-02-03') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-03/'\n PARTITION (dt='2026-02-10') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-10/'\n PARTITION (dt='2026-02-11') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-11/'\n PARTITION (dt='2026-02-12') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-12/'\n PARTITION (dt='2026-02-13') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-13/'\n PARTITION (dt='2026-02-14') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-14/'\n PARTITION (dt='2026-02-17') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-17/'\n PARTITION (dt='2026-02-18') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-18/'\n PARTITION (dt='2026-02-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-20/'\n PARTITION (dt='2026-02-28') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-28/'\n PARTITION (dt='2026-03-01') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-01/'\n PARTITION (dt='2026-03-02') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-02/'\n PARTITION (dt='2026-03-08') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-08/'\n PARTITION (dt='2026-03-11') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-11/'\n PARTITION (dt='2026-03-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-15/'\n PARTITION (dt='2026-03-21') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-21/'\n PARTITION (dt='2026-03-23') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-23/'\n PARTITION (dt='2026-03-28') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-28/'\n PARTITION (dt='2026-04-03') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-04-03/'\n PARTITION (dt='2026-04-17') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-04-17/'\n;" ] - name: dt
- state:
[ { "info": { "id": 1566074, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-15/", "name": "dt", "value": "2025-10-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-15 06:54:53", "last_data": "2025-10-15 06:57:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1568504, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-16/", "name": "dt", "value": "2025-10-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-16 18:41:01", "last_data": "2025-10-16 18:41:01" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1596719, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-20/", "name": "dt", "value": "2025-10-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-19 21:58:04", "last_data": "2025-10-20 17:22:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1597035, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-21/", "name": "dt", "value": "2025-10-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-21 10:08:26", "last_data": "2025-10-21 16:32:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1597474, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-23/", "name": "dt", "value": "2025-10-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-23 07:50:16", "last_data": "2025-10-23 15:49:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1597678, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-24/", "name": "dt", "value": "2025-10-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-23 21:59:54", "last_data": "2025-10-24 16:14:03" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1598296, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-26/", "name": "dt", "value": "2025-10-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-26 16:59:47", "last_data": "2025-10-26 17:35:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1598527, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-27/", "name": "dt", "value": "2025-10-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-27 18:04:51", "last_data": "2025-10-27 18:07:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1598761, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-28/", "name": "dt", "value": "2025-10-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-28 11:35:38", "last_data": "2025-10-28 18:27:24" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1599231, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-30/", "name": "dt", "value": "2025-10-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-30 15:50:19", "last_data": "2025-10-30 16:05:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1600267, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-03/", "name": "dt", "value": "2025-11-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-03 05:52:51", "last_data": "2025-11-03 18:13:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1600610, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-04/", "name": "dt", "value": "2025-11-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-04 10:04:52", "last_data": "2025-11-04 10:24:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1601678, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-09/", "name": "dt", "value": "2025-11-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-08 20:01:36", "last_data": "2025-11-08 20:15:01" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1602301, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-11/", "name": "dt", "value": "2025-11-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-11 15:02:41", "last_data": "2025-11-11 15:12:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1602535, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-12/", "name": "dt", "value": "2025-11-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-12 11:03:36", "last_data": "2025-11-12 11:34:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1602713, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-13/", "name": "dt", "value": "2025-11-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-13 09:54:07", "last_data": "2025-11-13 18:07:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1602866, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-14/", "name": "dt", "value": "2025-11-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-13 21:55:20", "last_data": "2025-11-13 21:55:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1603074, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-15/", "name": "dt", "value": "2025-11-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-14 19:02:03", "last_data": "2025-11-15 14:37:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1606409, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-19/", "name": "dt", "value": "2025-11-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-19 17:00:59", "last_data": "2025-11-19 17:02:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1607755, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-23/", "name": "dt", "value": "2025-11-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-22 21:08:56", "last_data": "2025-11-22 21:20:28" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1608361, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-25/", "name": "dt", "value": "2025-11-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-25 10:10:13", "last_data": "2025-11-25 10:10:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1608604, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-26/", "name": "dt", "value": "2025-11-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-26 16:02:50", "last_data": "2025-11-26 16:02:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1608911, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-28/", "name": "dt", "value": "2025-11-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-27 20:00:15", "last_data": "2025-11-27 20:07:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1609373, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-30/", "name": "dt", "value": "2025-11-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-29 20:06:12", "last_data": "2025-11-29 20:11:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1609604, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-01/", "name": "dt", "value": "2025-12-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-30 23:00:39", "last_data": "2025-11-30 23:11:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1609859, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-02/", "name": "dt", "value": "2025-12-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-01 23:56:31", "last_data": "2025-12-02 13:02:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1610060, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-03/", "name": "dt", "value": "2025-12-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-02 19:00:00", "last_data": "2025-12-02 19:15:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1610325, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-04/", "name": "dt", "value": "2025-12-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-03 19:54:17", "last_data": "2025-12-03 20:06:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1610570, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-05/", "name": "dt", "value": "2025-12-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-04 22:58:49", "last_data": "2025-12-04 23:05:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1611049, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-06/", "name": "dt", "value": "2025-12-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-05 19:00:28", "last_data": "2025-12-05 22:04:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1612761, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-12/", "name": "dt", "value": "2025-12-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-11 22:55:14", "last_data": "2025-12-12 15:11:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1613251, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-14/", "name": "dt", "value": "2025-12-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-13 19:02:07", "last_data": "2025-12-13 19:13:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1616317, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-16/", "name": "dt", "value": "2025-12-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-16 09:56:14", "last_data": "2025-12-16 13:14:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1617345, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-20/", "name": "dt", "value": "2025-12-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-20 12:57:39", "last_data": "2025-12-20 13:01:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1619245, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-29/", "name": "dt", "value": "2025-12-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-29 06:56:27", "last_data": "2025-12-29 11:54:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1619398, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-30/", "name": "dt", "value": "2025-12-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-29 18:54:11", "last_data": "2025-12-29 18:54:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1620444, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-03/", "name": "dt", "value": "2026-01-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-03 10:53:17", "last_data": "2026-01-03 10:57:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1620569, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-04/", "name": "dt", "value": "2026-01-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-04 07:54:14", "last_data": "2026-01-04 08:00:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1621033, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-06/", "name": "dt", "value": "2026-01-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-06 08:59:40", "last_data": "2026-01-06 08:59:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1621178, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-07/", "name": "dt", "value": "2026-01-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-06 19:58:08", "last_data": "2026-01-06 20:04:03" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1622750, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-13/", "name": "dt", "value": "2026-01-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-13 11:05:27", "last_data": "2026-01-13 11:05:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1622894, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-14/", "name": "dt", "value": "2026-01-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-14 06:47:04", "last_data": "2026-01-14 07:04:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1623078, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-15/", "name": "dt", "value": "2026-01-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-15 01:51:43", "last_data": "2026-01-15 01:58:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1623352, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-16/", "name": "dt", "value": "2026-01-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-16 01:58:01", "last_data": "2026-01-16 16:51:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1626091, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-18/", "name": "dt", "value": "2026-01-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-17 23:00:57", "last_data": "2026-01-17 23:59:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1626268, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-19/", "name": "dt", "value": "2026-01-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-18 18:53:00", "last_data": "2026-01-19 10:59:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1626692, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-20/", "name": "dt", "value": "2026-01-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-20 13:55:33", "last_data": "2026-01-20 13:55:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1626841, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-21/", "name": "dt", "value": "2026-01-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-21 08:53:19", "last_data": "2026-01-21 08:54:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1628279, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-28/", "name": "dt", "value": "2026-01-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-27 19:54:37", "last_data": "2026-01-27 20:03:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1628542, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-29/", "name": "dt", "value": "2026-01-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-29 05:01:04", "last_data": "2026-01-29 17:01:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1629078, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-31/", "name": "dt", "value": "2026-01-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-31 09:40:19", "last_data": "2026-01-31 09:56:30" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1629805, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-03/", "name": "dt", "value": "2026-02-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-03 14:41:13", "last_data": "2026-02-03 16:02:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1631345, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-10/", "name": "dt", "value": "2026-02-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-10 11:45:37", "last_data": "2026-02-10 12:02:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1631666, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-11/", "name": "dt", "value": "2026-02-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-11 17:42:47", "last_data": "2026-02-11 17:53:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1631887, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-12/", "name": "dt", "value": "2026-02-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-12 14:45:44", "last_data": "2026-02-12 14:50:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1631966, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-13/", "name": "dt", "value": "2026-02-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-12 20:52:30", "last_data": "2026-02-13 12:59:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1632271, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-14/", "name": "dt", "value": "2026-02-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-13 20:56:47", "last_data": "2026-02-13 21:02:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1635183, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-17/", "name": "dt", "value": "2026-02-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-17 10:49:34", "last_data": "2026-02-17 14:58:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1635409, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-18/", "name": "dt", "value": "2026-02-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-18 14:56:56", "last_data": "2026-02-18 15:00:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1635835, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-20/", "name": "dt", "value": "2026-02-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-20 12:57:19", "last_data": "2026-02-20 12:58:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1641128, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-28/", "name": "dt", "value": "2026-02-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-28 01:52:16", "last_data": "2026-02-28 01:56:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1641335, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-01/", "name": "dt", "value": "2026-03-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-28 21:53:20", "last_data": "2026-03-01 18:35:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1641683, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-02/", "name": "dt", "value": "2026-03-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-02 14:32:26", "last_data": "2026-03-02 14:46:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1643008, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-08/", "name": "dt", "value": "2026-03-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-08 09:57:14", "last_data": "2026-03-08 10:00:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1645147, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-11/", "name": "dt", "value": "2026-03-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-11 18:46:22", "last_data": "2026-03-11 19:03:22" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1645993, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-15/", "name": "dt", "value": "2026-03-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-15 09:46:55", "last_data": "2026-03-15 15:59:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1649241, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-21/", "name": "dt", "value": "2026-03-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-21 15:58:38", "last_data": "2026-03-21 16:03:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1649659, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-23/", "name": "dt", "value": "2026-03-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-23 17:45:55", "last_data": "2026-03-23 17:48:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1650769, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-28/", "name": "dt", "value": "2026-03-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-28 13:46:01", "last_data": "2026-03-28 13:57:30" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1652736, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-04-03/", "name": "dt", "value": "2026-04-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-03 12:48:09", "last_data": "2026-04-03 12:48:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1661442, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-04-17/", "name": "dt", "value": "2026-04-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-17 14:46:21", "last_data": "2026-04-17 14:52:35" }, "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.7510010745838ontent": "string", "context.campaign.audience": "string", "context.campaign.c": "string", "context.campaign.ca": "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.medium": "string", "context.campaign.name": "string", "context.campaign.referrer": "string", "context.campaign.so": "string", "context.campaign.sou": "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_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-04-10 21:01:44
- 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_bucketing`\n(\n`integrations`struct<`Google_Analytics`:STRING,`All`:STRING>,`messageId`STRING,`sentAt`STRING,`type`STRING,`originalTimestamp`STRING,`timestamp`STRING,`_origin`STRING,`context`struct<`amp`:struct<`id`:STRING>,`page`:struct<`title`:STRING,`search`:STRING,`referrer`:STRING,`path`:STRING,`url`:STRING>,`campaign`:struct<`ca`:STRING,`content`:STRING,`term`:STRING,`sou`:STRING,`id`:STRING,`con`:STRING,`audience`:STRING,`7510010745838ontent`:STRING,`campaig`:STRING,`expid`:STRING,`utm_source`:STRING,`so`:STRING,`utm_id`:STRING,`cont`:STRING,`utm_term`:STRING,`soupnc_0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000`:STRING,`camp`:STRING,`source`:STRING,`ing`:STRING,`c`:STRING,`utm_content`:STRING,`contentf`:STRING,`conten`:STRING,`utm_medium`:STRING,`tm_source`:STRING,`medium`:STRING,`campaignW`:STRING,`referrer`:STRING,`utm_campaign`:STRING,`name`:STRING,`co`:STRING>,`locale`:STRING,`userAgentData`:struct<`brands`:array,`unbundled`:array >,`properties`struct<`Hit_Timestamp`:STRING,`isReact`:STRING,`site_id`:STRING,`env`:STRING,`experiment_variation`:STRING,`experiment_name`:STRING>,`projectId`STRING,`receivedAt`STRING,`userId`STRING,`event`STRING,`anonymousId`STRING,`channel`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_experiment_bucketing`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_experiment_bucketing" }
- 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:05:27",
"disabled": false,
"format": "raw",
"id": 139,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_prod_segment",
"table": "reactfoot_experiment_bucketing"
},
"type": "segment"
},
"partition": {
"count": 71,
"ddl": [
"ALTER TABLE\n `sfdl_prod_segment.reactfoot_experiment_bucketing`\nADD\n\n\n PARTITION (dt='2025-10-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-15/'\n PARTITION (dt='2025-10-16') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-16/'\n PARTITION (dt='2025-10-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-20/'\n PARTITION (dt='2025-10-21') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-21/'\n PARTITION (dt='2025-10-23') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-23/'\n PARTITION (dt='2025-10-24') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-24/'\n PARTITION (dt='2025-10-26') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-26/'\n PARTITION (dt='2025-10-27') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-27/'\n PARTITION (dt='2025-10-28') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-28/'\n PARTITION (dt='2025-10-30') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-30/'\n PARTITION (dt='2025-11-03') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-03/'\n PARTITION (dt='2025-11-04') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-04/'\n PARTITION (dt='2025-11-09') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-09/'\n PARTITION (dt='2025-11-11') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-11/'\n PARTITION (dt='2025-11-12') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-12/'\n PARTITION (dt='2025-11-13') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-13/'\n PARTITION (dt='2025-11-14') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-14/'\n PARTITION (dt='2025-11-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-15/'\n PARTITION (dt='2025-11-19') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-19/'\n PARTITION (dt='2025-11-23') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-23/'\n PARTITION (dt='2025-11-25') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-25/'\n PARTITION (dt='2025-11-26') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-26/'\n PARTITION (dt='2025-11-28') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-28/'\n PARTITION (dt='2025-11-30') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-30/'\n PARTITION (dt='2025-12-01') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-01/'\n PARTITION (dt='2025-12-02') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-02/'\n PARTITION (dt='2025-12-03') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-03/'\n PARTITION (dt='2025-12-04') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-04/'\n PARTITION (dt='2025-12-05') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-05/'\n PARTITION (dt='2025-12-06') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-06/'\n PARTITION (dt='2025-12-12') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-12/'\n PARTITION (dt='2025-12-14') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-14/'\n PARTITION (dt='2025-12-16') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-16/'\n PARTITION (dt='2025-12-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-20/'\n PARTITION (dt='2025-12-29') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-29/'\n PARTITION (dt='2025-12-30') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-30/'\n PARTITION (dt='2026-01-03') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-03/'\n PARTITION (dt='2026-01-04') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-04/'\n PARTITION (dt='2026-01-06') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-06/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-07/'\n PARTITION (dt='2026-01-13') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-13/'\n PARTITION (dt='2026-01-14') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-14/'\n PARTITION (dt='2026-01-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-15/'\n PARTITION (dt='2026-01-16') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-16/'\n PARTITION (dt='2026-01-18') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-18/'\n PARTITION (dt='2026-01-19') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-19/'\n PARTITION (dt='2026-01-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-20/'\n PARTITION (dt='2026-01-21') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-21/'\n PARTITION (dt='2026-01-28') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-28/'\n PARTITION (dt='2026-01-29') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-29/'\n PARTITION (dt='2026-01-31') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-31/'\n PARTITION (dt='2026-02-03') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-03/'\n PARTITION (dt='2026-02-10') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-10/'\n PARTITION (dt='2026-02-11') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-11/'\n PARTITION (dt='2026-02-12') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-12/'\n PARTITION (dt='2026-02-13') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-13/'\n PARTITION (dt='2026-02-14') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-14/'\n PARTITION (dt='2026-02-17') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-17/'\n PARTITION (dt='2026-02-18') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-18/'\n PARTITION (dt='2026-02-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-20/'\n PARTITION (dt='2026-02-28') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-28/'\n PARTITION (dt='2026-03-01') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-01/'\n PARTITION (dt='2026-03-02') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-02/'\n PARTITION (dt='2026-03-08') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-08/'\n PARTITION (dt='2026-03-11') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-11/'\n PARTITION (dt='2026-03-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-15/'\n PARTITION (dt='2026-03-21') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-21/'\n PARTITION (dt='2026-03-23') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-23/'\n PARTITION (dt='2026-03-28') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-28/'\n PARTITION (dt='2026-04-03') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-04-03/'\n PARTITION (dt='2026-04-17') location 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-04-17/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 1566074,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-15/",
"name": "dt",
"value": "2025-10-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-15 06:54:53",
"last_data": "2025-10-15 06:57:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1568504,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-16/",
"name": "dt",
"value": "2025-10-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-16 18:41:01",
"last_data": "2025-10-16 18:41:01"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1596719,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-20/",
"name": "dt",
"value": "2025-10-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-19 21:58:04",
"last_data": "2025-10-20 17:22:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1597035,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-21/",
"name": "dt",
"value": "2025-10-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-21 10:08:26",
"last_data": "2025-10-21 16:32:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1597474,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-23/",
"name": "dt",
"value": "2025-10-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-23 07:50:16",
"last_data": "2025-10-23 15:49:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1597678,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-24/",
"name": "dt",
"value": "2025-10-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-23 21:59:54",
"last_data": "2025-10-24 16:14:03"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1598296,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-26/",
"name": "dt",
"value": "2025-10-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-26 16:59:47",
"last_data": "2025-10-26 17:35:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1598527,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-27/",
"name": "dt",
"value": "2025-10-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-27 18:04:51",
"last_data": "2025-10-27 18:07:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1598761,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-28/",
"name": "dt",
"value": "2025-10-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-28 11:35:38",
"last_data": "2025-10-28 18:27:24"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1599231,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-10-30/",
"name": "dt",
"value": "2025-10-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-30 15:50:19",
"last_data": "2025-10-30 16:05:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1600267,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-03/",
"name": "dt",
"value": "2025-11-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-03 05:52:51",
"last_data": "2025-11-03 18:13:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1600610,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-04/",
"name": "dt",
"value": "2025-11-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-04 10:04:52",
"last_data": "2025-11-04 10:24:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1601678,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-09/",
"name": "dt",
"value": "2025-11-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-08 20:01:36",
"last_data": "2025-11-08 20:15:01"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1602301,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-11/",
"name": "dt",
"value": "2025-11-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-11 15:02:41",
"last_data": "2025-11-11 15:12:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1602535,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-12/",
"name": "dt",
"value": "2025-11-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-12 11:03:36",
"last_data": "2025-11-12 11:34:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1602713,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-13/",
"name": "dt",
"value": "2025-11-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-13 09:54:07",
"last_data": "2025-11-13 18:07:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1602866,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-14/",
"name": "dt",
"value": "2025-11-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-13 21:55:20",
"last_data": "2025-11-13 21:55:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1603074,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-15/",
"name": "dt",
"value": "2025-11-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-14 19:02:03",
"last_data": "2025-11-15 14:37:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1606409,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-19/",
"name": "dt",
"value": "2025-11-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-19 17:00:59",
"last_data": "2025-11-19 17:02:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1607755,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-23/",
"name": "dt",
"value": "2025-11-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-22 21:08:56",
"last_data": "2025-11-22 21:20:28"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1608361,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-25/",
"name": "dt",
"value": "2025-11-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-25 10:10:13",
"last_data": "2025-11-25 10:10:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1608604,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-26/",
"name": "dt",
"value": "2025-11-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-26 16:02:50",
"last_data": "2025-11-26 16:02:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1608911,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-28/",
"name": "dt",
"value": "2025-11-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-27 20:00:15",
"last_data": "2025-11-27 20:07:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1609373,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-11-30/",
"name": "dt",
"value": "2025-11-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-29 20:06:12",
"last_data": "2025-11-29 20:11:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1609604,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-01/",
"name": "dt",
"value": "2025-12-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-30 23:00:39",
"last_data": "2025-11-30 23:11:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1609859,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-02/",
"name": "dt",
"value": "2025-12-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-01 23:56:31",
"last_data": "2025-12-02 13:02:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1610060,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-03/",
"name": "dt",
"value": "2025-12-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-02 19:00:00",
"last_data": "2025-12-02 19:15:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1610325,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-04/",
"name": "dt",
"value": "2025-12-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-03 19:54:17",
"last_data": "2025-12-03 20:06:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1610570,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-05/",
"name": "dt",
"value": "2025-12-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-04 22:58:49",
"last_data": "2025-12-04 23:05:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1611049,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-06/",
"name": "dt",
"value": "2025-12-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-05 19:00:28",
"last_data": "2025-12-05 22:04:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1612761,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-12/",
"name": "dt",
"value": "2025-12-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-11 22:55:14",
"last_data": "2025-12-12 15:11:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1613251,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-14/",
"name": "dt",
"value": "2025-12-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-13 19:02:07",
"last_data": "2025-12-13 19:13:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1616317,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-16/",
"name": "dt",
"value": "2025-12-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-16 09:56:14",
"last_data": "2025-12-16 13:14:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1617345,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-20/",
"name": "dt",
"value": "2025-12-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-20 12:57:39",
"last_data": "2025-12-20 13:01:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1619245,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-29/",
"name": "dt",
"value": "2025-12-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-29 06:56:27",
"last_data": "2025-12-29 11:54:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1619398,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2025-12-30/",
"name": "dt",
"value": "2025-12-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-29 18:54:11",
"last_data": "2025-12-29 18:54:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1620444,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-03/",
"name": "dt",
"value": "2026-01-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-03 10:53:17",
"last_data": "2026-01-03 10:57:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1620569,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-04/",
"name": "dt",
"value": "2026-01-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-04 07:54:14",
"last_data": "2026-01-04 08:00:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1621033,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-06/",
"name": "dt",
"value": "2026-01-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-06 08:59:40",
"last_data": "2026-01-06 08:59:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1621178,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-07/",
"name": "dt",
"value": "2026-01-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-06 19:58:08",
"last_data": "2026-01-06 20:04:03"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1622750,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-13/",
"name": "dt",
"value": "2026-01-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-13 11:05:27",
"last_data": "2026-01-13 11:05:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1622894,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-14/",
"name": "dt",
"value": "2026-01-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-14 06:47:04",
"last_data": "2026-01-14 07:04:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1623078,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-15/",
"name": "dt",
"value": "2026-01-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-15 01:51:43",
"last_data": "2026-01-15 01:58:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1623352,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-16/",
"name": "dt",
"value": "2026-01-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-16 01:58:01",
"last_data": "2026-01-16 16:51:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1626091,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-18/",
"name": "dt",
"value": "2026-01-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-17 23:00:57",
"last_data": "2026-01-17 23:59:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1626268,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-19/",
"name": "dt",
"value": "2026-01-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-18 18:53:00",
"last_data": "2026-01-19 10:59:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1626692,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-20/",
"name": "dt",
"value": "2026-01-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-20 13:55:33",
"last_data": "2026-01-20 13:55:33"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1626841,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-21/",
"name": "dt",
"value": "2026-01-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-21 08:53:19",
"last_data": "2026-01-21 08:54:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1628279,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-28/",
"name": "dt",
"value": "2026-01-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-27 19:54:37",
"last_data": "2026-01-27 20:03:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1628542,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-29/",
"name": "dt",
"value": "2026-01-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-29 05:01:04",
"last_data": "2026-01-29 17:01:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1629078,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-01-31/",
"name": "dt",
"value": "2026-01-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-31 09:40:19",
"last_data": "2026-01-31 09:56:30"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1629805,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-03/",
"name": "dt",
"value": "2026-02-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-03 14:41:13",
"last_data": "2026-02-03 16:02:33"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1631345,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-10/",
"name": "dt",
"value": "2026-02-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-10 11:45:37",
"last_data": "2026-02-10 12:02:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1631666,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-11/",
"name": "dt",
"value": "2026-02-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-11 17:42:47",
"last_data": "2026-02-11 17:53:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1631887,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-12/",
"name": "dt",
"value": "2026-02-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-12 14:45:44",
"last_data": "2026-02-12 14:50:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1631966,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-13/",
"name": "dt",
"value": "2026-02-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-12 20:52:30",
"last_data": "2026-02-13 12:59:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1632271,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-14/",
"name": "dt",
"value": "2026-02-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-13 20:56:47",
"last_data": "2026-02-13 21:02:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1635183,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-17/",
"name": "dt",
"value": "2026-02-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-17 10:49:34",
"last_data": "2026-02-17 14:58:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1635409,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-18/",
"name": "dt",
"value": "2026-02-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-18 14:56:56",
"last_data": "2026-02-18 15:00:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1635835,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-20/",
"name": "dt",
"value": "2026-02-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-20 12:57:19",
"last_data": "2026-02-20 12:58:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1641128,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-02-28/",
"name": "dt",
"value": "2026-02-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-28 01:52:16",
"last_data": "2026-02-28 01:56:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1641335,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-01/",
"name": "dt",
"value": "2026-03-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-28 21:53:20",
"last_data": "2026-03-01 18:35:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1641683,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-02/",
"name": "dt",
"value": "2026-03-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-02 14:32:26",
"last_data": "2026-03-02 14:46:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1643008,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-08/",
"name": "dt",
"value": "2026-03-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-08 09:57:14",
"last_data": "2026-03-08 10:00:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1645147,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-11/",
"name": "dt",
"value": "2026-03-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-11 18:46:22",
"last_data": "2026-03-11 19:03:22"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1645993,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-15/",
"name": "dt",
"value": "2026-03-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-15 09:46:55",
"last_data": "2026-03-15 15:59:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1649241,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-21/",
"name": "dt",
"value": "2026-03-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-21 15:58:38",
"last_data": "2026-03-21 16:03:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1649659,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-23/",
"name": "dt",
"value": "2026-03-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-23 17:45:55",
"last_data": "2026-03-23 17:48:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1650769,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-03-28/",
"name": "dt",
"value": "2026-03-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-28 13:46:01",
"last_data": "2026-03-28 13:57:30"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1652736,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-04-03/",
"name": "dt",
"value": "2026-04-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-03 12:48:09",
"last_data": "2026-04-03 12:48:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1661442,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing/dt=2026-04-17/",
"name": "dt",
"value": "2026-04-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-17 14:46:21",
"last_data": "2026-04-17 14:52:35"
},
"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.7510010745838ontent": "string",
"context.campaign.audience": "string",
"context.campaign.c": "string",
"context.campaign.ca": "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.medium": "string",
"context.campaign.name": "string",
"context.campaign.referrer": "string",
"context.campaign.so": "string",
"context.campaign.sou": "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_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-04-10 21:01:44",
"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_bucketing`\n(\n`integrations`struct<`Google_Analytics`:STRING,`All`:STRING>,`messageId`STRING,`sentAt`STRING,`type`STRING,`originalTimestamp`STRING,`timestamp`STRING,`_origin`STRING,`context`struct<`amp`:struct<`id`:STRING>,`page`:struct<`title`:STRING,`search`:STRING,`referrer`:STRING,`path`:STRING,`url`:STRING>,`campaign`:struct<`ca`:STRING,`content`:STRING,`term`:STRING,`sou`:STRING,`id`:STRING,`con`:STRING,`audience`:STRING,`7510010745838ontent`:STRING,`campaig`:STRING,`expid`:STRING,`utm_source`:STRING,`so`:STRING,`utm_id`:STRING,`cont`:STRING,`utm_term`:STRING,`soupnc_0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000`:STRING,`camp`:STRING,`source`:STRING,`ing`:STRING,`c`:STRING,`utm_content`:STRING,`contentf`:STRING,`conten`:STRING,`utm_medium`:STRING,`tm_source`:STRING,`medium`:STRING,`campaignW`:STRING,`referrer`:STRING,`utm_campaign`:STRING,`name`:STRING,`co`:STRING>,`locale`:STRING,`userAgentData`:struct<`brands`:array>,`mobile`:STRING,`platform`:STRING>,`timezone`:STRING,`library`:struct<`version`:STRING,`name`:STRING>,`ip`:STRING,`userAgent`:STRING>,`version`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`properties`struct<`Hit_Timestamp`:STRING,`isReact`:STRING,`site_id`:STRING,`env`:STRING,`experiment_variation`:STRING,`experiment_name`:STRING>,`projectId`STRING,`receivedAt`STRING,`userId`STRING,`event`STRING,`anonymousId`STRING,`channel`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-segment-reactfoot-prod/separated_dt/experiment_bucketing'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_experiment_bucketing`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_experiment_bucketing"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}