Schema Info
Schema Name: sfdl_prod_segment.ssdc_experiment_bucketing
- created: 2018-03-22 10:01:36
- disabled: False
- format: raw
- id: 310
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_prod_segment", "table": "ssdc_experiment_bucketing" } - type: segment
Schema Versions: 4
-
Version 1266450
- created: 2025-04-15 07:59:22
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "DROP TABLE IF EXISTS `sfdl_prod_segment.ssdc_experiment_bucketing`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.ssdc_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<`library`:struct<`version`:STRING,`name`:STRING>,`campaign`:struct<`cam`:STRING,`conte_20int`:STRING,`medium_5B_5D`:STRING,`sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3Dcontrol_26ploc_3D1012727_26iloc_3D9073451_26mkwid_3DsyurQSeRX_7Cpcrid_7C591132448308_7Cpkw_7Cstorage_2520units_2520san_2520francisco_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C46181760673_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_302938169436_7Cadext_7C23522909876_26pgrid_3D46181760673_26ptaid_3Dkwd_302938169436_26gad_source_3D5`:STRING,`colantent`:STRING,`expid`:STRING,`3Butm_medium`:STRING,`utm_term`:STRING,`utm_content`:STRING,`conten`:STRING,`device`:STRING,`utm_medium`:STRING,`medium`:STRING,`med`:STRING,`referrer`:STRING,`medium__`:STRING,`cokwid`:STRING,`sself_20storage`:STRING,`content__`:STRING,`term`:STRING,`sour`:STRING,`id`:STRING,`audience`:STRING,`clkid`:STRING,`campaig`:STRING,`campaign__`:STRING,`utm_source`:STRING,`t`:STRING,`sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9031532_26iloc_3D_26mkwid_3DsBQyUqhqA_7Cpcrid_7C696163551515_7Cpkw_7Cstorage_2520units_2520in_2520irvine_2520ca_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C51459594868_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_2336767968704_7Cadext_7C23522909753_26pgrid_3D51459594868_26ptaid_3Dkwd_2336767968704_26gad_source_3D5`:STRING,`source_5B_5D`:STRING,`c`:STRING,`syahoource`:STRING,`campai6661e9bbed8258a64c1acc8`:STRING,`sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9006703_26iloc_3D_26mkwid_3DsRDnqlcZ5_7Cpcrid_7C696163462457_7Cpkw_7Cct_2520self_2520storage_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C42564149266_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_305827747823_7Cadext_7C23522909753_26pgrid_3D42564149266_26ptaid_3Dkwd_305827747823_26gad_source_3D5`:STRING,`campaign_5b_5d`:STRING,`content_5B_5D`:STRING,`sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9033328_26iloc_3D_26mkwid_3DsnvUD3btz_7Cpcrid_7C696163443785_7Cpkw_7Cstorage_2520units_2520renton_2520wa_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C9925369291_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_302193213759_7Cadext_7C23522909783_26pgrid_3D9925369291_26ptaid_3Dkwd_302193213759_26gad_source_3D5`:STRING,`sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9060252_26iloc_3D_26mkwid_3DsuRMGswaK_7Cpcrid_7C673402998617_7Cpkw_7Cclimate_2520control_2520storage_2520chicago_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C55910009687_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_295688063246_7Cadext_7C23522909783_26pgrid_3D55910009687_26ptaid_3Dkwd_295688063246_26gad_source_3D5`:STRING,`conte`:STRING,`3Butm_content`:STRING,`20on_20lineutm_campaign`:STRING,`ca`:STRING,`medium_5b_5d`:STRING,`mdium`:STRING,`source_5b_5d`:STRING,`preview`:STRING,`E`:STRING,`source_2020`:STRING,`mediumsepaidsearch`:STRING,`utm_campaign`:STRING,`3Butm_campaign`:STRING,`content`:STRING,`3Butm_source`:STRING,`keyword`:STRING,`sourc`:STRING,`mediu`:STRING,`content_5b_5d`:STRING,`s_3A_2F_2Fwww`:struct<`selfstorage`:struct<`com_2Flpg_2Flf_2Fhp_copy_3Futm_source`:STRING>>,`campaign_5B_5D`:STRING,`capermpaign`:STRING,`campa`:STRING,`s_3A_2F_2Fstorage`:struct<`com_2Fpaid_landing_2F_3Futm_source`:STRING>,`source`:STRING,`source__`:STRING,`s`:STRING,`name`: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-ssdc-prod/separated_dt/experiment_bucketing'\n", "MSCK REPAIR TABLE sfdl_prod_segment.ssdc_experiment_bucketing" ] - hive_path: s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing
- id: 1266450
- processed: 1
- raw_data:
{ "__segment_internal": {}, "_metadata": { "bundled": [ "Google Tag Manager", "Segment.io" ], "bundledIds": [ "5aba5e646e396464865d9ca3" ], "unbundled": [] }, "_origin": "2025-04-15T12:59:09Z|s3://sfdl-segment-ssdc-prod/segment-logs/5yGJd9z7eL/1744675200000/1744721935966.events-archiver-480-19..2f6f1613-5e1e-46ad-97bb-ac934e0e6e49.gz|analytics-segment-separator-prod:$LATEST", "anonymousId": "d736e6be-8ff9-457f-bf30-680f5b33819a", "channel": "client", "context": { "campaign": { "content": "", "medium": "paidsearch", "name": "SSDC_Bing_General_Broad", "source": "bing", "source%2020": "", "term": "+self +storage +units" }, "ip": "35.33.224.187", "library": { "name": "analytics.js", "version": "next-1.77.0" }, "locale": "en-US", "page": { "path": "/lpg/lf/storage-location", "referrer": "https://www.selfstorage.com/lpg/lf/storage-location?tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=SSDC+Google%7CPMAX&utm_content=&ploc=1023191&iloc=&mkwid=|pcrid||pkw||pmt||pdv|m|pgrid||cpgnid|21142830401|ptaid||adext|&pgrid=&ptaid=&gad_source=5&gclid=CjwKCAjwwe2_BhBEEiwAM1I7sbiNhwr6kvrvwZ3vWp7UyzWjVtQVTR7NHVIHcUdvc84oJjWrtEKwgxoCmk0QAvD_BwE&__cf_chl_tk=HLbdWxq_izwNbftHnZaPHZOq5TOnPp0t.ywdZgqf5gE-1744558482-1.0.1.1-yFAHLDTSpZUp1EICRZGOWx.DqDKU6ayKvTsyMLjmaCA", "search": "?tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=SSDC+Google%7CPMAX&utm_content=&ploc=1023191&iloc=&mkwid=|pcrid||pkw||pmt||pdv|m|pgrid||cpgnid|21142830401|ptaid||adext|&pgrid=&ptaid=&gad_source=5&gclid=CjwKCAjwwe2_BhBEEiwAM1I7sbiNhwr6kvrvwZ3vWp7UyzWjVtQVTR7NHVIHcUdvc84oJjWrtEKwgxoCmk0QAvD_BwE", "title": "SelfStorage.com: Find Cheap Storage Units Near You", "url": "https://www.selfstorage.com/lpg/lf/storage-location?tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=SSDC+Google%7CPMAX&utm_content=&ploc=1023191&iloc=&mkwid=|pcrid||pkw||pmt||pdv|m|pgrid||cpgnid|21142830401|ptaid||adext|&pgrid=&ptaid=&gad_source=5&gclid=CjwKCAjwwe2_BhBEEiwAM1I7sbiNhwr6kvrvwZ3vWp7UyzWjVtQVTR7NHVIHcUdvc84oJjWrtEKwgxoCmk0QAvD_BwE" }, "timezone": "America/New_York", "userAgent": "Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Mobile Safari/537.36", "userAgentData": { "brands": [ { "brand": "Chromium", "version": "135" } ], "mobile": true, "platform": "Android" } }, "event": "experiment_bucketing", "integrations": { "All": true, "Google Analytics": false }, "messageId": "ajs-next-1744718502050-dc51868a-47b4-4e55-9dc2-ed107b211e34", "originalTimestamp": "2025-04-15T12:01:42.050Z", "projectId": "5yGJd9z7eL", "properties": { "Hit Timestamp": 1744718501459, "env": "production", "experiment_name": "sf_12127_ssdc_paid_landing_refresh", "experiment_variation": "variation", "isReact": true, "site_id": 27 }, "receivedAt": "2025-04-15T12:01:43.907Z", "sentAt": "2025-04-15T12:01:42.100Z", "timestamp": "2025-04-15T12:01:43.857Z", "type": "track", "userId": "ca060ec4a27df9f9b6e99ec5f319ffe4", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.20on_20lineutm_campaign": "string", "context.campaign.3Butm_campaign": "string", "context.campaign.3Butm_content": "string", "context.campaign.3Butm_medium": "string", "context.campaign.3Butm_source": "string", "context.campaign.E": "string", "context.campaign.audience": "string", "context.campaign.c": "string", "context.campaign.ca": "string", "context.campaign.cam": "string", "context.campaign.campa": "string", "context.campaign.campai6661e9bbed8258a64c1acc8": "string", "context.campaign.campaig": "string", "context.campaign.campaign_5B_5D": "string", "context.campaign.campaign_5b_5d": "string", "context.campaign.campaign__": "string", "context.campaign.capermpaign": "string", "context.campaign.clkid": "string", "context.campaign.cokwid": "string", "context.campaign.colantent": "string", "context.campaign.conte": "string", "context.campaign.conte_20int": "string", "context.campaign.conten": "string", "context.campaign.content": "string", "context.campaign.content_5B_5D": "string", "context.campaign.content_5b_5d": "string", "context.campaign.content__": "string", "context.campaign.device": "string", "context.campaign.expid": "string", "context.campaign.id": "string", "context.campaign.keyword": "string", "context.campaign.mdium": "string", "context.campaign.med": "string", "context.campaign.mediu": "string", "context.campaign.medium": "string", "context.campaign.medium_5B_5D": "string", "context.campaign.medium_5b_5d": "string", "context.campaign.medium__": "string", "context.campaign.mediumsepaidsearch": "string", "context.campaign.name": "string", "context.campaign.preview": "string", "context.campaign.referrer": "string", "context.campaign.s": "string", "context.campaign.s_3A_2F_2Fstorage.com_2Fpaid_landing_2F_3Futm_source": "string", "context.campaign.s_3A_2F_2Fwww.selfstorage.com_2Flpg_2Flf_2Fhp_copy_3Futm_source": "string", "context.campaign.sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9006703_26iloc_3D_26mkwid_3DsRDnqlcZ5_7Cpcrid_7C696163462457_7Cpkw_7Cct_2520self_2520storage_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C42564149266_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_305827747823_7Cadext_7C23522909753_26pgrid_3D42564149266_26ptaid_3Dkwd_305827747823_26gad_source_3D5": "string", "context.campaign.sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9031532_26iloc_3D_26mkwid_3DsBQyUqhqA_7Cpcrid_7C696163551515_7Cpkw_7Cstorage_2520units_2520in_2520irvine_2520ca_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C51459594868_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_2336767968704_7Cadext_7C23522909753_26pgrid_3D51459594868_26ptaid_3Dkwd_2336767968704_26gad_source_3D5": "string", "context.campaign.sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9033328_26iloc_3D_26mkwid_3DsnvUD3btz_7Cpcrid_7C696163443785_7Cpkw_7Cstorage_2520units_2520renton_2520wa_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C9925369291_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_302193213759_7Cadext_7C23522909783_26pgrid_3D9925369291_26ptaid_3Dkwd_302193213759_26gad_source_3D5": "string", "context.campaign.sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9060252_26iloc_3D_26mkwid_3DsuRMGswaK_7Cpcrid_7C673402998617_7Cpkw_7Cclimate_2520control_2520storage_2520chicago_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C55910009687_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_295688063246_7Cadext_7C23522909783_26pgrid_3D55910009687_26ptaid_3Dkwd_295688063246_26gad_source_3D5": "string", "context.campaign.sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3Dcontrol_26ploc_3D1012727_26iloc_3D9073451_26mkwid_3DsyurQSeRX_7Cpcrid_7C591132448308_7Cpkw_7Cstorage_2520units_2520san_2520francisco_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C46181760673_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_302938169436_7Cadext_7C23522909876_26pgrid_3D46181760673_26ptaid_3Dkwd_302938169436_26gad_source_3D5": "string", "context.campaign.sour": "string", "context.campaign.sourc": "string", "context.campaign.source": "string", "context.campaign.source_2020": "string", "context.campaign.source_5B_5D": "string", "context.campaign.source_5b_5d": "string", "context.campaign.source__": "string", "context.campaign.sself_20storage": "string", "context.campaign.syahoource": "string", "context.campaign.t": "string", "context.campaign.term": "string", "context.campaign.utm_campaign": "string", "context.campaign.utm_content": "string", "context.campaign.utm_medium": "string", "context.campaign.utm_source": "string", "context.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: 310
- schema_scan_id: 140601030
- updated: 2025-04-15 08:10:45
-
Version 1244586
- created: 2025-03-29 01:47:31
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "DROP TABLE IF EXISTS `sfdl_prod_segment.ssdc_experiment_bucketing`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.ssdc_experiment_bucketing`\n(\n`projectId`STRING,`context`struct<`userAgentData`:struct<`brands`:array,`unbundled`:array >,`messageId`STRING,`userId`STRING,`originalTimestamp`STRING,`properties`struct<`Hit_Timestamp`:STRING,`env`:STRING,`experiment_variation`:STRING,`isReact`:STRING,`site_id`:STRING,`experiment_name`:STRING>,`channel`STRING,`integrations`struct<`Google_Analytics`:STRING,`All`:STRING>\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing'\n", "MSCK REPAIR TABLE sfdl_prod_segment.ssdc_experiment_bucketing" ] - hive_path: s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing
- id: 1244586
- processed: 1
- raw_data:
{ "__segment_internal": {}, "_metadata": { "bundled": [ "Google Tag Manager", "Segment.io" ], "bundledIds": [ "5aba5e646e396464865d9ca3" ], "failedInitializations": [ "Google Tag Manager" ], "unbundled": [] }, "_origin": "2025-03-29T06:47:11Z|s3://sfdl-segment-ssdc-prod/segment-logs/5yGJd9z7eL/1743206400000/1743230820621.events-archiver-480-17..0936ed15-3a2f-4998-8f43-9cc0fadd8aea.gz|analytics-segment-separator-prod:$LATEST", "anonymousId": "e9a4b591-2d2c-44d2-ad89-acca6c228b71", "channel": "client", "context": { "campaign": { "audience": "customers", "content": "Cost", "id": "120211033152860078_v2_s08", "medium": "paid", "name": "Test - SSDC Facebook|General", "source": "facebook", "term": "120211033152850078" }, "ip": "104.28.76.147", "library": { "name": "analytics.js", "version": "next-1.77.0" }, "locale": "en-US", "page": { "path": "/self-storage/maryland/brentwood/extra-space-storage-0758-brentwood-bladensburg-rd-156753/", "referrer": "https://www.selfstorage.com/search?city=UNIVERSITY%20PA&latitude=38.9732233&location=UNIVERSITY%20PA%2C%20MD%2020782%2C%20USA&locationSource=google_autocomplete&longitude=-76.94702199999999&state=MD&type=storage&zip=20782", "search": "", "title": "Extra Space Storage - 0758 - Brentwood - Bladensburg Rd: Lowest Rates - SelfStorage.com", "url": "https://www.selfstorage.com/self-storage/maryland/brentwood/extra-space-storage-0758-brentwood-bladensburg-rd-156753/" }, "timezone": "America/New_York", "userAgent": "Mozilla/5.0 (iPhone; CPU iPhone OS 18_3_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/22D82 [FBAN/FBIOS;FBAV/505.0.0.49.97;FBBV/710084827;FBDV/iPhone14,2;FBMD/iPhone;FBSN/iOS;FBSV/18.3.2;FBSS/3;FBID/phone;FBLC/en_US;FBOP/5;FBRV/714581537;IABMV/1]", "userAgentData": { "brands": [ { "brand": "Google Chrome", "version": "134" } ], "mobile": false, "platform": "" } }, "event": "experiment_bucketing", "integrations": { "All": true, "Google Analytics": false }, "messageId": "ajs-next-1743227317158-ff8e3ad2-edea-4408-a54f-f5acf66c3118", "originalTimestamp": "2025-03-29T05:48:37.158Z", "projectId": "5yGJd9z7eL", "properties": { "Hit Timestamp": 1743227317131, "env": "production", "experiment_name": "sf_12127_ssdc_paid_landing_refresh", "experiment_variation": "variation", "isReact": true, "site_id": 27 }, "receivedAt": "2025-03-29T05:48:37.533Z", "sentAt": "2025-03-29T05:48:37.161Z", "timestamp": "2025-03-29T05:48:37.530Z", "type": "track", "userId": "f833d544c36bafce508f46e5ea27fec1", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.20on_20lineutm_campaign": "string", "context.campaign.3Butm_campaign": "string", "context.campaign.3Butm_content": "string", "context.campaign.3Butm_medium": "string", "context.campaign.3Butm_source": "string", "context.campaign.E": "string", "context.campaign.audience": "string", "context.campaign.c": "string", "context.campaign.ca": "string", "context.campaign.cam": "string", "context.campaign.campa": "string", "context.campaign.campai6661e9bbed8258a64c1acc8": "string", "context.campaign.campaig": "string", "context.campaign.campaign_5B_5D": "string", "context.campaign.campaign_5b_5d": "string", "context.campaign.campaign__": "string", "context.campaign.capermpaign": "string", "context.campaign.clkid": "string", "context.campaign.cokwid": "string", "context.campaign.colantent": "string", "context.campaign.conte": "string", "context.campaign.conte_20int": "string", "context.campaign.conten": "string", "context.campaign.content": "string", "context.campaign.content_5B_5D": "string", "context.campaign.content_5b_5d": "string", "context.campaign.content__": "string", "context.campaign.device": "string", "context.campaign.expid": "string", "context.campaign.id": "string", "context.campaign.keyword": "string", "context.campaign.mdium": "string", "context.campaign.med": "string", "context.campaign.mediu": "string", "context.campaign.medium": "string", "context.campaign.medium_5B_5D": "string", "context.campaign.medium_5b_5d": "string", "context.campaign.medium__": "string", "context.campaign.mediumsepaidsearch": "string", "context.campaign.name": "string", "context.campaign.preview": "string", "context.campaign.referrer": "string", "context.campaign.s": "string", "context.campaign.s_3A_2F_2Fstorage.com_2Fpaid_landing_2F_3Futm_source": "string", "context.campaign.s_3A_2F_2Fwww.selfstorage.com_2Flpg_2Flf_2Fhp_copy_3Futm_source": "string", "context.campaign.sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9006703_26iloc_3D_26mkwid_3DsRDnqlcZ5_7Cpcrid_7C696163462457_7Cpkw_7Cct_2520self_2520storage_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C42564149266_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_305827747823_7Cadext_7C23522909753_26pgrid_3D42564149266_26ptaid_3Dkwd_305827747823_26gad_source_3D5": "string", "context.campaign.sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9031532_26iloc_3D_26mkwid_3DsBQyUqhqA_7Cpcrid_7C696163551515_7Cpkw_7Cstorage_2520units_2520in_2520irvine_2520ca_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C51459594868_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_2336767968704_7Cadext_7C23522909753_26pgrid_3D51459594868_26ptaid_3Dkwd_2336767968704_26gad_source_3D5": "string", "context.campaign.sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9033328_26iloc_3D_26mkwid_3DsnvUD3btz_7Cpcrid_7C696163443785_7Cpkw_7Cstorage_2520units_2520renton_2520wa_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C9925369291_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_302193213759_7Cadext_7C23522909783_26pgrid_3D9925369291_26ptaid_3Dkwd_302193213759_26gad_source_3D5": "string", "context.campaign.sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9060252_26iloc_3D_26mkwid_3DsuRMGswaK_7Cpcrid_7C673402998617_7Cpkw_7Cclimate_2520control_2520storage_2520chicago_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C55910009687_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_295688063246_7Cadext_7C23522909783_26pgrid_3D55910009687_26ptaid_3Dkwd_295688063246_26gad_source_3D5": "string", "context.campaign.sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3Dcontrol_26ploc_3D1012727_26iloc_3D9073451_26mkwid_3DsyurQSeRX_7Cpcrid_7C591132448308_7Cpkw_7Cstorage_2520units_2520san_2520francisco_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C46181760673_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_302938169436_7Cadext_7C23522909876_26pgrid_3D46181760673_26ptaid_3Dkwd_302938169436_26gad_source_3D5": "string", "context.campaign.sour": "string", "context.campaign.sourc": "string", "context.campaign.source": "string", "context.campaign.source_5B_5D": "string", "context.campaign.source_5b_5d": "string", "context.campaign.source__": "string", "context.campaign.sself_20storage": "string", "context.campaign.syahoource": "string", "context.campaign.t": "string", "context.campaign.term": "string", "context.campaign.utm_campaign": "string", "context.campaign.utm_content": "string", "context.campaign.utm_medium": "string", "context.campaign.utm_source": "string", "context.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: 310
- schema_scan_id: 139608895
- updated: 2025-03-29 01:48:31
-
Version 1197550
- created: 2025-02-17 01:41:59
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "DROP TABLE IF EXISTS `sfdl_prod_segment.ssdc_experiment_bucketing`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.ssdc_experiment_bucketing`\n(\n`version`STRING,`receivedAt`STRING,`integrations`struct<`All`:STRING,`Google_Analytics`:STRING>,`type`STRING,`sentAt`STRING,`originalTimestamp`STRING,`channel`STRING,`context`struct<`page`:struct<`url`:STRING,`title`:STRING,`path`:STRING,`referrer`:STRING,`search`:STRING>,`library`:struct<`name`:STRING,`version`: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-ssdc-prod/separated_dt/experiment_bucketing'\n", "MSCK REPAIR TABLE sfdl_prod_segment.ssdc_experiment_bucketing" ] - hive_path: s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing
- id: 1197550
- processed: 1
- raw_data:
{ "__segment_internal": {}, "_metadata": { "bundled": [ "Google Tag Manager", "Segment.io" ], "bundledIds": [ "5aba5e646e396464865d9ca3" ], "failedInitializations": [ "Google Tag Manager" ], "unbundled": [] }, "_origin": "2025-02-17T07:41:53Z|s3://sfdl-segment-ssdc-prod/segment-logs/5yGJd9z7eL/1739750400000/1739778092815.events-archiver-480-2..263a73a8-5cd9-494e-8d36-4b0f984d2064.gz|analytics-segment-separator-prod:$LATEST", "anonymousId": "b424d381-55ff-424a-8aa6-53a16d60e826", "channel": "client", "context": { "campaign": { "content": "", "medium": "paidsearch", "name": "SSDC Google|General|Broad", "sid%3Dgoogle-ppc%26utm_source%3Dgoogle%26utm_medium%3Dpaidsearch%26utm_campaign%3DSSDC%2BGoogle%257CGeneral%257CExact%26utm_content%3D%26ploc%3D9006703%26iloc%3D%26mkwid%3DsRDnqlcZ5%7Cpcrid%7C696163462457%7Cpkw%7Cct%2520self%2520storage%7Cpmt%7Cb%7Cpdv%7Cm%7Cpgrid%7C42564149266%7Ccpgnid%7C194908291%7Cptaid%7Ckwd-305827747823%7Cadext%7C23522909753%26pgrid%3D42564149266%26ptaid%3Dkwd-305827747823%26gad_source%3D5": "", "source": "google", "term": "+storage" }, "ip": "108.45.100.150", "library": { "name": "analytics.js", "version": "next-1.77.0" }, "locale": "en-US", "page": { "path": "/lpg/lf/storage-location", "referrer": "https://www.google.com/", "search": "?tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=SSDC+Google%7CGeneral%7CBroad&utm_content=&ploc=1027236&iloc=1027290&mkwid=s86wQIlVH|pcrid|671291968513|pkw|big%20storage|pmt|b|pdv|m|pgrid|39224245325|cpgnid|194353051|ptaid|kwd-663639500|adext|&pgrid=39224245325&ptaid=kwd-663639500&gad_source=1&gclid=CjwKCAiAtsa9BhAKEiwAUZAszYuVaTaTQIGm49_6n9rb_8QXQsqwiCiN3O8_Ya6GvGOZoVu4Q_fBgBoCVxEQAvD_BwE", "title": "SelfStorage.com: Find Cheap Storage Units Near You", "url": "https://www.selfstorage.com/lpg/lf/storage-location?tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=SSDC+Google%7CGeneral%7CBroad&utm_content=&ploc=1027236&iloc=1027290&mkwid=s86wQIlVH|pcrid|671291968513|pkw|big%20storage|pmt|b|pdv|m|pgrid|39224245325|cpgnid|194353051|ptaid|kwd-663639500|adext|&pgrid=39224245325&ptaid=kwd-663639500&gad_source=1&gclid=CjwKCAiAtsa9BhAKEiwAUZAszYuVaTaTQIGm49_6n9rb_8QXQsqwiCiN3O8_Ya6GvGOZoVu4Q_fBgBoCVxEQAvD_BwE" }, "timezone": "America/New_York", "userAgent": "Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Mobile Safari/537.36", "userAgentData": { "brands": [ { "brand": "Chromium", "version": "133" } ], "mobile": true, "platform": "Android" } }, "event": "experiment_bucketing", "integrations": { "All": true, "Google Analytics": false }, "messageId": "ajs-next-1739774647132-caa653a1-6d60-4826-9ce3-b1b0723eff3d", "originalTimestamp": "2025-02-17T06:44:07.132Z", "projectId": "5yGJd9z7eL", "properties": { "Hit Timestamp": 1739774646046, "env": "production", "experiment_name": "sf_12127_ssdc_paid_landing_refresh", "experiment_variation": "variation", "isReact": true, "site_id": 27 }, "receivedAt": "2025-02-17T06:44:07.356Z", "sentAt": "2025-02-17T06:44:07.158Z", "timestamp": "2025-02-17T06:44:07.330Z", "type": "track", "userId": "adcf81e30c68317261e528b620c86740", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.20on_20lineutm_campaign": "string", "context.campaign.3Butm_campaign": "string", "context.campaign.3Butm_content": "string", "context.campaign.3Butm_medium": "string", "context.campaign.3Butm_source": "string", "context.campaign.E": "string", "context.campaign.c": "string", "context.campaign.ca": "string", "context.campaign.cam": "string", "context.campaign.campa": "string", "context.campaign.campai6661e9bbed8258a64c1acc8": "string", "context.campaign.campaig": "string", "context.campaign.campaign_5B_5D": "string", "context.campaign.campaign_5b_5d": "string", "context.campaign.campaign__": "string", "context.campaign.capermpaign": "string", "context.campaign.clkid": "string", "context.campaign.cokwid": "string", "context.campaign.colantent": "string", "context.campaign.conte": "string", "context.campaign.conte_20int": "string", "context.campaign.conten": "string", "context.campaign.content": "string", "context.campaign.content_5B_5D": "string", "context.campaign.content_5b_5d": "string", "context.campaign.content__": "string", "context.campaign.device": "string", "context.campaign.expid": "string", "context.campaign.id": "string", "context.campaign.keyword": "string", "context.campaign.mdium": "string", "context.campaign.med": "string", "context.campaign.mediu": "string", "context.campaign.medium": "string", "context.campaign.medium_5B_5D": "string", "context.campaign.medium_5b_5d": "string", "context.campaign.medium__": "string", "context.campaign.mediumsepaidsearch": "string", "context.campaign.name": "string", "context.campaign.preview": "string", "context.campaign.referrer": "string", "context.campaign.s": "string", "context.campaign.s_3A_2F_2Fstorage.com_2Fpaid_landing_2F_3Futm_source": "string", "context.campaign.s_3A_2F_2Fwww.selfstorage.com_2Flpg_2Flf_2Fhp_copy_3Futm_source": "string", "context.campaign.sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9006703_26iloc_3D_26mkwid_3DsRDnqlcZ5_7Cpcrid_7C696163462457_7Cpkw_7Cct_2520self_2520storage_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C42564149266_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_305827747823_7Cadext_7C23522909753_26pgrid_3D42564149266_26ptaid_3Dkwd_305827747823_26gad_source_3D5": "string", "context.campaign.sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9031532_26iloc_3D_26mkwid_3DsBQyUqhqA_7Cpcrid_7C696163551515_7Cpkw_7Cstorage_2520units_2520in_2520irvine_2520ca_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C51459594868_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_2336767968704_7Cadext_7C23522909753_26pgrid_3D51459594868_26ptaid_3Dkwd_2336767968704_26gad_source_3D5": "string", "context.campaign.sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9033328_26iloc_3D_26mkwid_3DsnvUD3btz_7Cpcrid_7C696163443785_7Cpkw_7Cstorage_2520units_2520renton_2520wa_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C9925369291_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_302193213759_7Cadext_7C23522909783_26pgrid_3D9925369291_26ptaid_3Dkwd_302193213759_26gad_source_3D5": "string", "context.campaign.sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9060252_26iloc_3D_26mkwid_3DsuRMGswaK_7Cpcrid_7C673402998617_7Cpkw_7Cclimate_2520control_2520storage_2520chicago_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C55910009687_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_295688063246_7Cadext_7C23522909783_26pgrid_3D55910009687_26ptaid_3Dkwd_295688063246_26gad_source_3D5": "string", "context.campaign.sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3Dcontrol_26ploc_3D1012727_26iloc_3D9073451_26mkwid_3DsyurQSeRX_7Cpcrid_7C591132448308_7Cpkw_7Cstorage_2520units_2520san_2520francisco_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C46181760673_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_302938169436_7Cadext_7C23522909876_26pgrid_3D46181760673_26ptaid_3Dkwd_302938169436_26gad_source_3D5": "string", "context.campaign.sour": "string", "context.campaign.sourc": "string", "context.campaign.source": "string", "context.campaign.source_5B_5D": "string", "context.campaign.source_5b_5d": "string", "context.campaign.source__": "string", "context.campaign.sself_20storage": "string", "context.campaign.syahoource": "string", "context.campaign.t": "string", "context.campaign.term": "string", "context.campaign.utm_campaign": "string", "context.campaign.utm_content": "string", "context.campaign.utm_medium": "string", "context.campaign.utm_source": "string", "context.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: 310
- schema_scan_id: 137305751
- updated: 2025-02-17 01:42:55
-
Version 1197180
- created: 2025-02-17 00:02:52
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "DROP TABLE IF EXISTS `sfdl_prod_segment.ssdc_experiment_bucketing`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.ssdc_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<`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-ssdc-prod/separated_dt/experiment_bucketing'\n", "MSCK REPAIR TABLE sfdl_prod_segment.ssdc_experiment_bucketing" ] - hive_path: s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing
- id: 1197180
- processed: 1
- raw_data:
{ "__segment_internal": {}, "_metadata": { "bundled": [ "Google Tag Manager", "Segment.io" ], "bundledIds": [ "5aba5e646e396464865d9ca3" ], "failedInitializations": [ "Google Tag Manager" ], "unbundled": [] }, "_origin": "2025-02-17T05:57:42Z|s3://sfdl-segment-ssdc-prod/segment-logs/5yGJd9z7eL/1739750400000/1739771811014.events-archiver-480-33..f0f58095-c0bc-4b7e-8193-7c44b2883148.gz|analytics-segment-separator-prod:$LATEST", "anonymousId": "35ca759e-a08e-46fd-b29c-5def279f7429", "channel": "client", "context": { "campaign": { "content": "", "medium": "paidsearch", "name": "SSDC Bing|PMAX", "sid%3Dgoogle-ppc%26utm_source%3Dgoogle%26utm_medium%3Dpaidsearch%26utm_campaign%3DSSDC%2BGoogle%257CGeneral%257CExact%26utm_content%3D%26ploc%3D9031532%26iloc%3D%26mkwid%3DsBQyUqhqA%7Cpcrid%7C696163551515%7Cpkw%7Cstorage%2520units%2520in%2520irvine%2520ca%7Cpmt%7Cb%7Cpdv%7Cm%7Cpgrid%7C51459594868%7Ccpgnid%7C194908291%7Cptaid%7Ckwd-2336767968704%7Cadext%7C23522909753%26pgrid%3D51459594868%26ptaid%3Dkwd-2336767968704%26gad_source%3D5": "", "source": "bing", "term": "www.selfstorage.com" }, "ip": "74.125.216.101", "library": { "name": "analytics.js", "version": "next-1.77.0" }, "locale": "en-US", "page": { "path": "/self-storage/minnesota/st-paul/", "referrer": "", "search": "", "title": "30 Cheap Self-Storage Units in St Paul, MN (from $14)", "url": "https://www.selfstorage.com/self-storage/minnesota/st-paul/" }, "timezone": "America/Los_Angeles", "userAgent": "Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.6943.53 Mobile Safari/537.36 (compatible; AdsBot-Google-Mobile; +http://www.google.com/mobile/adsbot.html)", "userAgentData": { "brands": [ { "brand": "Chromium", "version": "133" } ], "mobile": false, "platform": "" } }, "event": "experiment_bucketing", "integrations": { "All": true, "Google Analytics": false }, "messageId": "ajs-next-1739768437953-c6fd329c-5def-479f-b429-644dc67e0f82", "originalTimestamp": "2025-02-17T05:00:37.952Z", "projectId": "5yGJd9z7eL", "properties": { "Hit Timestamp": 1739768432937, "env": "production", "experiment_name": "sf_12127_ssdc_paid_landing_refresh", "experiment_variation": "variation", "isReact": true, "site_id": 27 }, "receivedAt": "2025-02-17T05:00:29.867Z", "sentAt": "2025-02-17T05:00:38.074Z", "timestamp": "2025-02-17T05:00:29.745Z", "type": "track", "userId": "bot", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.20on_20lineutm_campaign": "string", "context.campaign.3Butm_campaign": "string", "context.campaign.3Butm_content": "string", "context.campaign.3Butm_medium": "string", "context.campaign.3Butm_source": "string", "context.campaign.E": "string", "context.campaign.c": "string", "context.campaign.ca": "string", "context.campaign.cam": "string", "context.campaign.campa": "string", "context.campaign.campai6661e9bbed8258a64c1acc8": "string", "context.campaign.campaig": "string", "context.campaign.campaign_5B_5D": "string", "context.campaign.campaign_5b_5d": "string", "context.campaign.campaign__": "string", "context.campaign.capermpaign": "string", "context.campaign.clkid": "string", "context.campaign.cokwid": "string", "context.campaign.colantent": "string", "context.campaign.conte": "string", "context.campaign.conte_20int": "string", "context.campaign.conten": "string", "context.campaign.content": "string", "context.campaign.content_5B_5D": "string", "context.campaign.content_5b_5d": "string", "context.campaign.content__": "string", "context.campaign.device": "string", "context.campaign.expid": "string", "context.campaign.id": "string", "context.campaign.keyword": "string", "context.campaign.mdium": "string", "context.campaign.med": "string", "context.campaign.mediu": "string", "context.campaign.medium": "string", "context.campaign.medium_5B_5D": "string", "context.campaign.medium_5b_5d": "string", "context.campaign.medium__": "string", "context.campaign.mediumsepaidsearch": "string", "context.campaign.name": "string", "context.campaign.preview": "string", "context.campaign.referrer": "string", "context.campaign.s": "string", "context.campaign.s_3A_2F_2Fstorage.com_2Fpaid_landing_2F_3Futm_source": "string", "context.campaign.s_3A_2F_2Fwww.selfstorage.com_2Flpg_2Flf_2Fhp_copy_3Futm_source": "string", "context.campaign.sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9031532_26iloc_3D_26mkwid_3DsBQyUqhqA_7Cpcrid_7C696163551515_7Cpkw_7Cstorage_2520units_2520in_2520irvine_2520ca_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C51459594868_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_2336767968704_7Cadext_7C23522909753_26pgrid_3D51459594868_26ptaid_3Dkwd_2336767968704_26gad_source_3D5": "string", "context.campaign.sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9033328_26iloc_3D_26mkwid_3DsnvUD3btz_7Cpcrid_7C696163443785_7Cpkw_7Cstorage_2520units_2520renton_2520wa_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C9925369291_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_302193213759_7Cadext_7C23522909783_26pgrid_3D9925369291_26ptaid_3Dkwd_302193213759_26gad_source_3D5": "string", "context.campaign.sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9060252_26iloc_3D_26mkwid_3DsuRMGswaK_7Cpcrid_7C673402998617_7Cpkw_7Cclimate_2520control_2520storage_2520chicago_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C55910009687_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_295688063246_7Cadext_7C23522909783_26pgrid_3D55910009687_26ptaid_3Dkwd_295688063246_26gad_source_3D5": "string", "context.campaign.sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3Dcontrol_26ploc_3D1012727_26iloc_3D9073451_26mkwid_3DsyurQSeRX_7Cpcrid_7C591132448308_7Cpkw_7Cstorage_2520units_2520san_2520francisco_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C46181760673_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_302938169436_7Cadext_7C23522909876_26pgrid_3D46181760673_26ptaid_3Dkwd_302938169436_26gad_source_3D5": "string", "context.campaign.sour": "string", "context.campaign.sourc": "string", "context.campaign.source": "string", "context.campaign.source_5B_5D": "string", "context.campaign.source_5b_5d": "string", "context.campaign.source__": "string", "context.campaign.sself_20storage": "string", "context.campaign.syahoource": "string", "context.campaign.t": "string", "context.campaign.term": "string", "context.campaign.utm_campaign": "string", "context.campaign.utm_content": "string", "context.campaign.utm_medium": "string", "context.campaign.utm_source": "string", "context.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: 310
- schema_scan_id: 137302797
- updated: 2025-02-17 00:11:07
Schema Scans: 4
Last at 2025-04-15 07:59:20
-
Scan 140601030
- duration: 0:04:38.643858
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 2102, "partitions_applied": false, "success": true } - id: 140601030
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-04-15/", "name": "dt", "type": "string", "value": "2025-04-15" }, "s3": { "bucket": "sfdl-segment-ssdc-prod", "hive_path": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing", "key": "separated_dt/experiment_bucketing/dt=2025-04-15/1744721935966.events-archiver-480-19..2f6f1613-5e1e-46ad-97bb-ac934e0e6e49.json.gz" }, "schema": { "name": "sfdl_prod_segment.ssdc_experiment_bucketing", "type": "segment" } } - running: False
- schema_name_id: 310
- start_time: 2025-04-15 07:59:20
- success: True
- trace_id: 5268566532882997122
-
Scan 139608895
- duration: 0:01:55.040608
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 2565, "partitions_applied": false, "success": true } - id: 139608895
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-03-29/", "name": "dt", "type": "string", "value": "2025-03-29" }, "s3": { "bucket": "sfdl-segment-ssdc-prod", "hive_path": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing", "key": "separated_dt/experiment_bucketing/dt=2025-03-29/1743230820621.events-archiver-480-17..0936ed15-3a2f-4998-8f43-9cc0fadd8aea.json.gz" }, "schema": { "name": "sfdl_prod_segment.ssdc_experiment_bucketing", "type": "segment" } } - running: False
- schema_name_id: 310
- start_time: 2025-03-29 01:47:29
- success: True
- trace_id: 16303582424913470836
-
Scan 137305751
- duration: 0:01:43.117297
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 2525, "partitions_applied": false, "success": true } - id: 137305751
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-02-17/", "name": "dt", "type": "string", "value": "2025-02-17" }, "s3": { "bucket": "sfdl-segment-ssdc-prod", "hive_path": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing", "key": "separated_dt/experiment_bucketing/dt=2025-02-17/1739778092815.events-archiver-480-2..263a73a8-5cd9-494e-8d36-4b0f984d2064.json.gz" }, "schema": { "name": "sfdl_prod_segment.ssdc_experiment_bucketing", "type": "segment" } } - running: False
- schema_name_id: 310
- start_time: 2025-02-17 01:41:57
- success: True
- trace_id: 12152600264377574894
-
Scan 137302797
- duration: 0:00:51.604487
- exit_message:
{ "exception": "failed to apply schema `Query failed: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask `MSCK REPAIR TABLE sfdl_prod_segment.ssdc_experiment_bucketing``: ['CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`', 'DROP TABLE IF EXISTS `sfdl_prod_segment.ssdc_experiment_bucketing`', \"CREATE EXTERNAL TABLE IF NOT EXISTS\\n`sfdl_prod_segment.ssdc_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<`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-ssdc-prod/separated_dt/experiment_bucketing'\\n\", 'MSCK REPAIR TABLE sfdl_prod_segment.ssdc_experiment_bucketing']\nTraceback (most recent call last):\n File \"/schema_manager/schema_generator/table_generator.py\", line 24, in apply_latest_version\n self.runner.run_multi_query(schema_version.ddl, timeout=DDLQueueWorker.TIMEOUT)\n File \"/usr/local/lib/python3.12/site-packages/stodl/athena_runner/runner.py\", line 133, in run_multi_query\n result = self.run_single_query(query, timeout, database)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File \"/usr/local/lib/python3.12/site-packages/stodl/athena_runner/runner.py\", line 51, in run_single_query\n return self._run_single_query(query, timeout, database)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File \"/usr/local/lib/python3.12/site-packages/stodl/athena_runner/runner.py\", line 120, in _run_single_query\n raise e\n File \"/usr/local/lib/python3.12/site-packages/stodl/athena_runner/runner.py\", line 103, in _run_single_query\n raise AthenaRunnerQueryException('Query failed: {} `{}`'.format(info['QueryExecution']['Status']['StateChangeReason'], query))\nstodl.athena_runner.exceptions.AthenaRunnerQueryException: Query failed: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask `MSCK REPAIR TABLE sfdl_prod_segment.ssdc_experiment_bucketing`\n\nDuring handling of the above exception, another exception occurred:\n\nTraceback (most recent call last):\n File \"/schema_manager/schema_generator/schema_scanner.py\", line 102, in scan\n response = service.run()\n ^^^^^^^^^^^^^\n File \"/schema_manager/schema_generator/process_hive_table.py\", line 98, in run\n response['ddl_changed'] = table_generator.run()\n ^^^^^^^^^^^^^^^^^^^^^\n File \"/schema_manager/schema_generator/table_generator.py\", line 35, in run\n self.apply_latest_version()\n File \"/schema_manager/schema_generator/table_generator.py\", line 26, in apply_latest_version\n raise Exception('failed to apply schema `{}`: {}'.format(e, schema_version.ddl))\nException: failed to apply schema `Query failed: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask `MSCK REPAIR TABLE sfdl_prod_segment.ssdc_experiment_bucketing``: ['CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`', 'DROP TABLE IF EXISTS `sfdl_prod_segment.ssdc_experiment_bucketing`', \"CREATE EXTERNAL TABLE IF NOT EXISTS\\n`sfdl_prod_segment.ssdc_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<`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-ssdc-prod/separated_dt/experiment_bucketing'\\n\", 'MSCK REPAIR TABLE sfdl_prod_segment.ssdc_experiment_bucketing']\n: Expecting value: line 1 column 1 (char 0)" } - id: 137302797
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-02-17/", "name": "dt", "type": "string", "value": "2025-02-17" }, "s3": { "bucket": "sfdl-segment-ssdc-prod", "hive_path": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing", "key": "separated_dt/experiment_bucketing/dt=2025-02-17/1739771811014.events-archiver-480-33..f0f58095-c0bc-4b7e-8193-7c44b2883148.json.gz" }, "schema": { "name": "sfdl_prod_segment.ssdc_experiment_bucketing", "type": "segment" } } - running: False
- schema_name_id: 310
- start_time: 2025-02-17 00:02:50
- success: False
- trace_id: 13334016256249052658
- count: 81
- ddl:
[ "ALTER TABLE\n `sfdl_prod_segment.ssdc_experiment_bucketing`\nADD\n\n\n PARTITION (dt='2025-10-19') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-10-19/'\n PARTITION (dt='2025-10-20') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-10-20/'\n PARTITION (dt='2025-10-25') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-10-25/'\n PARTITION (dt='2025-10-26') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-10-26/'\n PARTITION (dt='2025-10-28') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-10-28/'\n PARTITION (dt='2025-10-30') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-10-30/'\n PARTITION (dt='2025-11-05') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-05/'\n PARTITION (dt='2025-11-06') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-06/'\n PARTITION (dt='2025-11-08') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-08/'\n PARTITION (dt='2025-11-09') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-09/'\n PARTITION (dt='2025-11-11') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-11/'\n PARTITION (dt='2025-11-12') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-12/'\n PARTITION (dt='2025-11-13') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-13/'\n PARTITION (dt='2025-11-14') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-14/'\n PARTITION (dt='2025-11-15') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-15/'\n PARTITION (dt='2025-11-17') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-17/'\n PARTITION (dt='2025-11-19') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-19/'\n PARTITION (dt='2025-11-20') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-20/'\n PARTITION (dt='2025-11-22') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-22/'\n PARTITION (dt='2025-11-23') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-23/'\n PARTITION (dt='2025-11-25') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-25/'\n PARTITION (dt='2025-11-27') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-27/'\n PARTITION (dt='2025-11-28') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-28/'\n PARTITION (dt='2025-12-02') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-02/'\n PARTITION (dt='2025-12-03') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-03/'\n PARTITION (dt='2025-12-08') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-08/'\n PARTITION (dt='2025-12-12') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-12/'\n PARTITION (dt='2025-12-13') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-13/'\n PARTITION (dt='2025-12-17') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-17/'\n PARTITION (dt='2025-12-18') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-18/'\n PARTITION (dt='2025-12-19') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-19/'\n PARTITION (dt='2025-12-23') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-23/'\n PARTITION (dt='2025-12-24') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-24/'\n PARTITION (dt='2025-12-25') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-25/'\n PARTITION (dt='2025-12-27') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-27/'\n PARTITION (dt='2025-12-28') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-28/'\n PARTITION (dt='2025-12-29') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-29/'\n PARTITION (dt='2025-12-30') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-30/'\n PARTITION (dt='2025-12-31') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-31/'\n PARTITION (dt='2026-01-01') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-01/'\n PARTITION (dt='2026-01-02') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-02/'\n PARTITION (dt='2026-01-04') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-04/'\n PARTITION (dt='2026-01-06') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-06/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-07/'\n PARTITION (dt='2026-01-08') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-08/'\n PARTITION (dt='2026-01-09') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-09/'\n PARTITION (dt='2026-01-11') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-11/'\n PARTITION (dt='2026-01-12') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-12/'\n PARTITION (dt='2026-01-13') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-13/'\n PARTITION (dt='2026-01-16') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-16/'\n PARTITION (dt='2026-01-17') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-17/'\n PARTITION (dt='2026-01-21') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-21/'\n PARTITION (dt='2026-01-26') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-26/'\n PARTITION (dt='2026-01-27') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-27/'\n PARTITION (dt='2026-01-28') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-28/'\n PARTITION (dt='2026-01-29') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-29/'\n PARTITION (dt='2026-01-30') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-30/'\n PARTITION (dt='2026-01-31') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-31/'\n PARTITION (dt='2026-02-02') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-02/'\n PARTITION (dt='2026-02-03') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-03/'\n PARTITION (dt='2026-02-04') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-04/'\n PARTITION (dt='2026-02-10') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-10/'\n PARTITION (dt='2026-02-11') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-11/'\n PARTITION (dt='2026-02-15') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-15/'\n PARTITION (dt='2026-02-16') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-16/'\n PARTITION (dt='2026-02-18') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-18/'\n PARTITION (dt='2026-02-22') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-22/'\n PARTITION (dt='2026-02-23') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-23/'\n PARTITION (dt='2026-02-24') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-24/'\n PARTITION (dt='2026-02-25') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-25/'\n PARTITION (dt='2026-03-08') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-03-08/'\n PARTITION (dt='2026-03-10') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-03-10/'\n PARTITION (dt='2026-03-17') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-03-17/'\n PARTITION (dt='2026-03-27') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-03-27/'\n PARTITION (dt='2026-03-29') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-03-29/'\n PARTITION (dt='2026-04-01') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-04-01/'\n PARTITION (dt='2026-04-02') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-04-02/'\n PARTITION (dt='2026-04-03') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-04-03/'\n PARTITION (dt='2026-04-04') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-04-04/'\n PARTITION (dt='2026-04-07') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-04-07/'\n PARTITION (dt='2026-04-10') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-04-10/'\n;" ] - name: dt
- state:
[ { "info": { "id": 1596145, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-10-19/", "name": "dt", "value": "2025-10-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-18 22:43:13", "last_data": "2025-10-19 02:00:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1596729, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-10-20/", "name": "dt", "value": "2025-10-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-20 05:06:19", "last_data": "2025-10-20 05:06:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1598065, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-10-25/", "name": "dt", "value": "2025-10-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-25 17:57:42", "last_data": "2025-10-25 19:35:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1598137, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-10-26/", "name": "dt", "value": "2025-10-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-25 20:03:47", "last_data": "2025-10-25 20:15:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1598614, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-10-28/", "name": "dt", "value": "2025-10-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-27 21:02:17", "last_data": "2025-10-27 21:02:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1599091, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-10-30/", "name": "dt", "value": "2025-10-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-29 22:08:03", "last_data": "2025-10-29 22:08:03" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1600854, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-05/", "name": "dt", "value": "2025-11-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-05 13:18:26", "last_data": "2025-11-05 13:34:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1600985, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-06/", "name": "dt", "value": "2025-11-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-06 05:45:06", "last_data": "2025-11-06 15:12:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1601594, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-08/", "name": "dt", "value": "2025-11-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-08 16:54:32", "last_data": "2025-11-08 16:59:26" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1601679, "location": "s3://sfdl-segment-ssdc-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:11:16", "last_data": "2025-11-08 20:20:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1602158, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-11/", "name": "dt", "value": "2025-11-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-10 21:03:50", "last_data": "2025-11-11 06:10:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1602366, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-12/", "name": "dt", "value": "2025-11-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-11 19:04:52", "last_data": "2025-11-11 19:04:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1602774, "location": "s3://sfdl-segment-ssdc-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 12:02:44", "last_data": "2025-11-13 12:47:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1602878, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-14/", "name": "dt", "value": "2025-11-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-14 02:57:33", "last_data": "2025-11-14 04:52:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1603080, "location": "s3://sfdl-segment-ssdc-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:16:10", "last_data": "2025-11-14 19:24:24" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1605813, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-17/", "name": "dt", "value": "2025-11-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-17 08:05:27", "last_data": "2025-11-17 08:05:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1606372, "location": "s3://sfdl-segment-ssdc-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 10:04:47", "last_data": "2025-11-19 17:00:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1606498, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-20/", "name": "dt", "value": "2025-11-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-19 19:59:21", "last_data": "2025-11-19 20:05:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1607556, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-22/", "name": "dt", "value": "2025-11-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-22 07:02:03", "last_data": "2025-11-22 07:02:03" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1607905, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-23/", "name": "dt", "value": "2025-11-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-23 16:45:24", "last_data": "2025-11-23 16:45:24" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1608373, "location": "s3://sfdl-segment-ssdc-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 17:52:56", "last_data": "2025-11-25 17:52:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1608836, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-27/", "name": "dt", "value": "2025-11-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-27 16:04:45", "last_data": "2025-11-27 16:04:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1609065, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-28/", "name": "dt", "value": "2025-11-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-28 16:59:38", "last_data": "2025-11-28 17:03:26" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1610000, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-02/", "name": "dt", "value": "2025-12-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-02 16:57:50", "last_data": "2025-12-02 16:57:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1610039, "location": "s3://sfdl-segment-ssdc-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 18:54:37", "last_data": "2025-12-03 15:08:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1611554, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-08/", "name": "dt", "value": "2025-12-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-08 03:01:52", "last_data": "2025-12-08 03:01:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1612847, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-12/", "name": "dt", "value": "2025-12-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-12 08:48:08", "last_data": "2025-12-12 08:48:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1613079, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-13/", "name": "dt", "value": "2025-12-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-12 23:57:22", "last_data": "2025-12-13 02:15:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1616598, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-17/", "name": "dt", "value": "2025-12-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-17 08:09:45", "last_data": "2025-12-17 08:09:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1616897, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-18/", "name": "dt", "value": "2025-12-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-18 10:00:03", "last_data": "2025-12-18 16:51:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1617128, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-19/", "name": "dt", "value": "2025-12-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-19 14:54:47", "last_data": "2025-12-19 14:54:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1618021, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-23/", "name": "dt", "value": "2025-12-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-23 14:47:19", "last_data": "2025-12-23 18:03:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1618171, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-24/", "name": "dt", "value": "2025-12-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-24 08:57:33", "last_data": "2025-12-24 09:01:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1618451, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-25/", "name": "dt", "value": "2025-12-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-25 14:57:40", "last_data": "2025-12-25 14:59:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1618745, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-27/", "name": "dt", "value": "2025-12-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-26 21:02:05", "last_data": "2025-12-26 21:02:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1618990, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-28/", "name": "dt", "value": "2025-12-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-28 06:56:00", "last_data": "2025-12-28 12:00:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1619226, "location": "s3://sfdl-segment-ssdc-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 03:57:49", "last_data": "2025-12-29 03:57:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1619430, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-30/", "name": "dt", "value": "2025-12-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-30 00:57:52", "last_data": "2025-12-30 13:57:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1619679, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-31/", "name": "dt", "value": "2025-12-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-31 06:00:52", "last_data": "2025-12-31 06:00:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1620009, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-01/", "name": "dt", "value": "2026-01-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-01 11:55:12", "last_data": "2026-01-01 11:55:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1620086, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-02/", "name": "dt", "value": "2026-01-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-01 20:02:53", "last_data": "2026-01-01 20:02:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1620661, "location": "s3://sfdl-segment-ssdc-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 17:59:40", "last_data": "2026-01-04 17:59:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1621095, "location": "s3://sfdl-segment-ssdc-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 11:59:42", "last_data": "2026-01-06 11:59:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1621224, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-07/", "name": "dt", "value": "2026-01-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-07 06:00:34", "last_data": "2026-01-07 06:00:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1621543, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-08/", "name": "dt", "value": "2026-01-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-08 10:54:56", "last_data": "2026-01-08 10:58:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1621744, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-09/", "name": "dt", "value": "2026-01-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-09 14:36:46", "last_data": "2026-01-09 14:38:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1622081, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-11/", "name": "dt", "value": "2026-01-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-11 02:58:19", "last_data": "2026-01-11 02:58:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1622300, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-12/", "name": "dt", "value": "2026-01-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-11 22:00:32", "last_data": "2026-01-12 14:01:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1622659, "location": "s3://sfdl-segment-ssdc-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 04:02:10", "last_data": "2026-01-13 15:50:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1625583, "location": "s3://sfdl-segment-ssdc-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 09:55:05", "last_data": "2026-01-16 09:59:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1625649, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-17/", "name": "dt", "value": "2026-01-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-16 19:01:01", "last_data": "2026-01-17 08:58:28" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1626911, "location": "s3://sfdl-segment-ssdc-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 15:53:32", "last_data": "2026-01-21 15:57:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1627881, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-26/", "name": "dt", "value": "2026-01-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-26 05:41:09", "last_data": "2026-01-26 15:48:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1628084, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-27/", "name": "dt", "value": "2026-01-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-27 03:54:09", "last_data": "2026-01-27 04:51:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1628280, "location": "s3://sfdl-segment-ssdc-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:56:30", "last_data": "2026-01-28 16:54:31" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1628498, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-29/", "name": "dt", "value": "2026-01-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-28 19:55:39", "last_data": "2026-01-29 15:04:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1628872, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-30/", "name": "dt", "value": "2026-01-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-30 13:42:57", "last_data": "2026-01-30 18:46:24" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1628951, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-31/", "name": "dt", "value": "2026-01-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-30 19:54:23", "last_data": "2026-01-31 10:03:30" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1629522, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-02/", "name": "dt", "value": "2026-02-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-02 12:02:36", "last_data": "2026-02-02 12:04:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1629807, "location": "s3://sfdl-segment-ssdc-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 15:44:52", "last_data": "2026-02-03 15:48:24" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1629894, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-04/", "name": "dt", "value": "2026-02-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-03 21:01:23", "last_data": "2026-02-04 06:55:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1631181, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-10/", "name": "dt", "value": "2026-02-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-09 18:55:27", "last_data": "2026-02-10 18:15:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1631436, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-11/", "name": "dt", "value": "2026-02-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-10 21:57:00", "last_data": "2026-02-10 21:57:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1632676, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-15/", "name": "dt", "value": "2026-02-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-15 16:53:29", "last_data": "2026-02-15 16:53:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1634975, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-16/", "name": "dt", "value": "2026-02-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-16 15:45:57", "last_data": "2026-02-16 15:50:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1635407, "location": "s3://sfdl-segment-ssdc-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 13:42:53", "last_data": "2026-02-18 13:46:32" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1636320, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-22/", "name": "dt", "value": "2026-02-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-22 12:50:41", "last_data": "2026-02-22 12:50:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1636414, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-23/", "name": "dt", "value": "2026-02-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-23 03:56:33", "last_data": "2026-02-23 03:56:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1636585, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-24/", "name": "dt", "value": "2026-02-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-23 18:53:41", "last_data": "2026-02-23 20:58:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1637072, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-25/", "name": "dt", "value": "2026-02-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-25 09:42:47", "last_data": "2026-02-25 09:58:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1643108, "location": "s3://sfdl-segment-ssdc-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 17:58:06", "last_data": "2026-03-08 18:03:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1644929, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-03-10/", "name": "dt", "value": "2026-03-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-10 16:46:31", "last_data": "2026-03-10 16:46:31" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1648096, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-03-17/", "name": "dt", "value": "2026-03-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-16 21:58:52", "last_data": "2026-03-16 21:58:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1650558, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-03-27/", "name": "dt", "value": "2026-03-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-27 17:48:15", "last_data": "2026-03-27 17:51:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1650843, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-03-29/", "name": "dt", "value": "2026-03-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-28 22:59:15", "last_data": "2026-03-28 23:02:32" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1651997, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-04-01/", "name": "dt", "value": "2026-04-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-31 20:01:12", "last_data": "2026-04-01 14:07:31" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1652521, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-04-02/", "name": "dt", "value": "2026-04-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-02 10:56:00", "last_data": "2026-04-02 10:56:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1652727, "location": "s3://sfdl-segment-ssdc-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 10:01:49", "last_data": "2026-04-03 10:03:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1652958, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-04-04/", "name": "dt", "value": "2026-04-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-04 18:48:14", "last_data": "2026-04-04 18:48:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1656898, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-04-07/", "name": "dt", "value": "2026-04-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-07 13:55:38", "last_data": "2026-04-07 13:55:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1657682, "location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-04-10/", "name": "dt", "value": "2026-04-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-10 09:01:13", "last_data": "2026-04-10 09:04:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } } ] - type: string
- attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.20on_20lineutm_campaign": "string", "context.campaign.3Butm_campaign": "string", "context.campaign.3Butm_content": "string", "context.campaign.3Butm_medium": "string", "context.campaign.3Butm_source": "string", "context.campaign.E": "string", "context.campaign.audience": "string", "context.campaign.c": "string", "context.campaign.ca": "string", "context.campaign.cam": "string", "context.campaign.campa": "string", "context.campaign.campai6661e9bbed8258a64c1acc8": "string", "context.campaign.campaig": "string", "context.campaign.campaign_5B_5D": "string", "context.campaign.campaign_5b_5d": "string", "context.campaign.campaign__": "string", "context.campaign.capermpaign": "string", "context.campaign.clkid": "string", "context.campaign.cokwid": "string", "context.campaign.colantent": "string", "context.campaign.conte": "string", "context.campaign.conte_20int": "string", "context.campaign.conten": "string", "context.campaign.content": "string", "context.campaign.content_5B_5D": "string", "context.campaign.content_5b_5d": "string", "context.campaign.content__": "string", "context.campaign.device": "string", "context.campaign.expid": "string", "context.campaign.id": "string", "context.campaign.keyword": "string", "context.campaign.mdium": "string", "context.campaign.med": "string", "context.campaign.mediu": "string", "context.campaign.medium": "string", "context.campaign.medium_5B_5D": "string", "context.campaign.medium_5b_5d": "string", "context.campaign.medium__": "string", "context.campaign.mediumsepaidsearch": "string", "context.campaign.name": "string", "context.campaign.preview": "string", "context.campaign.referrer": "string", "context.campaign.s": "string", "context.campaign.s_3A_2F_2Fstorage.com_2Fpaid_landing_2F_3Futm_source": "string", "context.campaign.s_3A_2F_2Fwww.selfstorage.com_2Flpg_2Flf_2Fhp_copy_3Futm_source": "string", "context.campaign.sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9006703_26iloc_3D_26mkwid_3DsRDnqlcZ5_7Cpcrid_7C696163462457_7Cpkw_7Cct_2520self_2520storage_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C42564149266_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_305827747823_7Cadext_7C23522909753_26pgrid_3D42564149266_26ptaid_3Dkwd_305827747823_26gad_source_3D5": "string", "context.campaign.sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9031532_26iloc_3D_26mkwid_3DsBQyUqhqA_7Cpcrid_7C696163551515_7Cpkw_7Cstorage_2520units_2520in_2520irvine_2520ca_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C51459594868_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_2336767968704_7Cadext_7C23522909753_26pgrid_3D51459594868_26ptaid_3Dkwd_2336767968704_26gad_source_3D5": "string", "context.campaign.sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9033328_26iloc_3D_26mkwid_3DsnvUD3btz_7Cpcrid_7C696163443785_7Cpkw_7Cstorage_2520units_2520renton_2520wa_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C9925369291_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_302193213759_7Cadext_7C23522909783_26pgrid_3D9925369291_26ptaid_3Dkwd_302193213759_26gad_source_3D5": "string", "context.campaign.sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9060252_26iloc_3D_26mkwid_3DsuRMGswaK_7Cpcrid_7C673402998617_7Cpkw_7Cclimate_2520control_2520storage_2520chicago_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C55910009687_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_295688063246_7Cadext_7C23522909783_26pgrid_3D55910009687_26ptaid_3Dkwd_295688063246_26gad_source_3D5": "string", "context.campaign.sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3Dcontrol_26ploc_3D1012727_26iloc_3D9073451_26mkwid_3DsyurQSeRX_7Cpcrid_7C591132448308_7Cpkw_7Cstorage_2520units_2520san_2520francisco_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C46181760673_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_302938169436_7Cadext_7C23522909876_26pgrid_3D46181760673_26ptaid_3Dkwd_302938169436_26gad_source_3D5": "string", "context.campaign.sour": "string", "context.campaign.sourc": "string", "context.campaign.source": "string", "context.campaign.source_2020": "string", "context.campaign.source_5B_5D": "string", "context.campaign.source_5b_5d": "string", "context.campaign.source__": "string", "context.campaign.sself_20storage": "string", "context.campaign.syahoource": "string", "context.campaign.t": "string", "context.campaign.term": "string", "context.campaign.utm_campaign": "string", "context.campaign.utm_content": "string", "context.campaign.utm_medium": "string", "context.campaign.utm_source": "string", "context.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-15 07:59:22
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.ssdc_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<`library`:struct<`version`:STRING,`name`:STRING>,`campaign`:struct<`cam`:STRING,`conte_20int`:STRING,`medium_5B_5D`:STRING,`sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3Dcontrol_26ploc_3D1012727_26iloc_3D9073451_26mkwid_3DsyurQSeRX_7Cpcrid_7C591132448308_7Cpkw_7Cstorage_2520units_2520san_2520francisco_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C46181760673_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_302938169436_7Cadext_7C23522909876_26pgrid_3D46181760673_26ptaid_3Dkwd_302938169436_26gad_source_3D5`:STRING,`colantent`:STRING,`expid`:STRING,`3Butm_medium`:STRING,`utm_term`:STRING,`utm_content`:STRING,`conten`:STRING,`device`:STRING,`utm_medium`:STRING,`medium`:STRING,`med`:STRING,`referrer`:STRING,`medium__`:STRING,`cokwid`:STRING,`sself_20storage`:STRING,`content__`:STRING,`term`:STRING,`sour`:STRING,`id`:STRING,`audience`:STRING,`clkid`:STRING,`campaig`:STRING,`campaign__`:STRING,`utm_source`:STRING,`t`:STRING,`sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9031532_26iloc_3D_26mkwid_3DsBQyUqhqA_7Cpcrid_7C696163551515_7Cpkw_7Cstorage_2520units_2520in_2520irvine_2520ca_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C51459594868_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_2336767968704_7Cadext_7C23522909753_26pgrid_3D51459594868_26ptaid_3Dkwd_2336767968704_26gad_source_3D5`:STRING,`source_5B_5D`:STRING,`c`:STRING,`syahoource`:STRING,`campai6661e9bbed8258a64c1acc8`:STRING,`sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9006703_26iloc_3D_26mkwid_3DsRDnqlcZ5_7Cpcrid_7C696163462457_7Cpkw_7Cct_2520self_2520storage_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C42564149266_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_305827747823_7Cadext_7C23522909753_26pgrid_3D42564149266_26ptaid_3Dkwd_305827747823_26gad_source_3D5`:STRING,`campaign_5b_5d`:STRING,`content_5B_5D`:STRING,`sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9033328_26iloc_3D_26mkwid_3DsnvUD3btz_7Cpcrid_7C696163443785_7Cpkw_7Cstorage_2520units_2520renton_2520wa_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C9925369291_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_302193213759_7Cadext_7C23522909783_26pgrid_3D9925369291_26ptaid_3Dkwd_302193213759_26gad_source_3D5`:STRING,`sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9060252_26iloc_3D_26mkwid_3DsuRMGswaK_7Cpcrid_7C673402998617_7Cpkw_7Cclimate_2520control_2520storage_2520chicago_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C55910009687_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_295688063246_7Cadext_7C23522909783_26pgrid_3D55910009687_26ptaid_3Dkwd_295688063246_26gad_source_3D5`:STRING,`conte`:STRING,`3Butm_content`:STRING,`20on_20lineutm_campaign`:STRING,`ca`:STRING,`medium_5b_5d`:STRING,`mdium`:STRING,`source_5b_5d`:STRING,`preview`:STRING,`E`:STRING,`source_2020`:STRING,`mediumsepaidsearch`:STRING,`utm_campaign`:STRING,`3Butm_campaign`:STRING,`content`:STRING,`3Butm_source`:STRING,`keyword`:STRING,`sourc`:STRING,`mediu`:STRING,`content_5b_5d`:STRING,`s_3A_2F_2Fwww`:struct<`selfstorage`:struct<`com_2Flpg_2Flf_2Fhp_copy_3Futm_source`:STRING>>,`campaign_5B_5D`:STRING,`capermpaign`:STRING,`campa`:STRING,`s_3A_2F_2Fstorage`:struct<`com_2Fpaid_landing_2F_3Futm_source`:STRING>,`source`:STRING,`source__`:STRING,`s`:STRING,`name`: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-ssdc-prod/separated_dt/experiment_bucketing'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.ssdc_experiment_bucketing`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.ssdc_experiment_bucketing" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2018-03-22 10:01:36",
"disabled": false,
"format": "raw",
"id": 310,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_prod_segment",
"table": "ssdc_experiment_bucketing"
},
"type": "segment"
},
"partition": {
"count": 81,
"ddl": [
"ALTER TABLE\n `sfdl_prod_segment.ssdc_experiment_bucketing`\nADD\n\n\n PARTITION (dt='2025-10-19') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-10-19/'\n PARTITION (dt='2025-10-20') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-10-20/'\n PARTITION (dt='2025-10-25') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-10-25/'\n PARTITION (dt='2025-10-26') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-10-26/'\n PARTITION (dt='2025-10-28') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-10-28/'\n PARTITION (dt='2025-10-30') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-10-30/'\n PARTITION (dt='2025-11-05') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-05/'\n PARTITION (dt='2025-11-06') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-06/'\n PARTITION (dt='2025-11-08') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-08/'\n PARTITION (dt='2025-11-09') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-09/'\n PARTITION (dt='2025-11-11') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-11/'\n PARTITION (dt='2025-11-12') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-12/'\n PARTITION (dt='2025-11-13') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-13/'\n PARTITION (dt='2025-11-14') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-14/'\n PARTITION (dt='2025-11-15') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-15/'\n PARTITION (dt='2025-11-17') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-17/'\n PARTITION (dt='2025-11-19') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-19/'\n PARTITION (dt='2025-11-20') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-20/'\n PARTITION (dt='2025-11-22') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-22/'\n PARTITION (dt='2025-11-23') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-23/'\n PARTITION (dt='2025-11-25') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-25/'\n PARTITION (dt='2025-11-27') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-27/'\n PARTITION (dt='2025-11-28') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-28/'\n PARTITION (dt='2025-12-02') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-02/'\n PARTITION (dt='2025-12-03') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-03/'\n PARTITION (dt='2025-12-08') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-08/'\n PARTITION (dt='2025-12-12') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-12/'\n PARTITION (dt='2025-12-13') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-13/'\n PARTITION (dt='2025-12-17') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-17/'\n PARTITION (dt='2025-12-18') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-18/'\n PARTITION (dt='2025-12-19') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-19/'\n PARTITION (dt='2025-12-23') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-23/'\n PARTITION (dt='2025-12-24') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-24/'\n PARTITION (dt='2025-12-25') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-25/'\n PARTITION (dt='2025-12-27') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-27/'\n PARTITION (dt='2025-12-28') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-28/'\n PARTITION (dt='2025-12-29') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-29/'\n PARTITION (dt='2025-12-30') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-30/'\n PARTITION (dt='2025-12-31') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-31/'\n PARTITION (dt='2026-01-01') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-01/'\n PARTITION (dt='2026-01-02') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-02/'\n PARTITION (dt='2026-01-04') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-04/'\n PARTITION (dt='2026-01-06') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-06/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-07/'\n PARTITION (dt='2026-01-08') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-08/'\n PARTITION (dt='2026-01-09') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-09/'\n PARTITION (dt='2026-01-11') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-11/'\n PARTITION (dt='2026-01-12') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-12/'\n PARTITION (dt='2026-01-13') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-13/'\n PARTITION (dt='2026-01-16') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-16/'\n PARTITION (dt='2026-01-17') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-17/'\n PARTITION (dt='2026-01-21') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-21/'\n PARTITION (dt='2026-01-26') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-26/'\n PARTITION (dt='2026-01-27') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-27/'\n PARTITION (dt='2026-01-28') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-28/'\n PARTITION (dt='2026-01-29') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-29/'\n PARTITION (dt='2026-01-30') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-30/'\n PARTITION (dt='2026-01-31') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-31/'\n PARTITION (dt='2026-02-02') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-02/'\n PARTITION (dt='2026-02-03') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-03/'\n PARTITION (dt='2026-02-04') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-04/'\n PARTITION (dt='2026-02-10') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-10/'\n PARTITION (dt='2026-02-11') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-11/'\n PARTITION (dt='2026-02-15') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-15/'\n PARTITION (dt='2026-02-16') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-16/'\n PARTITION (dt='2026-02-18') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-18/'\n PARTITION (dt='2026-02-22') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-22/'\n PARTITION (dt='2026-02-23') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-23/'\n PARTITION (dt='2026-02-24') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-24/'\n PARTITION (dt='2026-02-25') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-25/'\n PARTITION (dt='2026-03-08') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-03-08/'\n PARTITION (dt='2026-03-10') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-03-10/'\n PARTITION (dt='2026-03-17') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-03-17/'\n PARTITION (dt='2026-03-27') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-03-27/'\n PARTITION (dt='2026-03-29') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-03-29/'\n PARTITION (dt='2026-04-01') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-04-01/'\n PARTITION (dt='2026-04-02') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-04-02/'\n PARTITION (dt='2026-04-03') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-04-03/'\n PARTITION (dt='2026-04-04') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-04-04/'\n PARTITION (dt='2026-04-07') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-04-07/'\n PARTITION (dt='2026-04-10') location 's3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-04-10/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 1596145,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-10-19/",
"name": "dt",
"value": "2025-10-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-18 22:43:13",
"last_data": "2025-10-19 02:00:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1596729,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-10-20/",
"name": "dt",
"value": "2025-10-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-20 05:06:19",
"last_data": "2025-10-20 05:06:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1598065,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-10-25/",
"name": "dt",
"value": "2025-10-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-25 17:57:42",
"last_data": "2025-10-25 19:35:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1598137,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-10-26/",
"name": "dt",
"value": "2025-10-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-25 20:03:47",
"last_data": "2025-10-25 20:15:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1598614,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-10-28/",
"name": "dt",
"value": "2025-10-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-27 21:02:17",
"last_data": "2025-10-27 21:02:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1599091,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-10-30/",
"name": "dt",
"value": "2025-10-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-29 22:08:03",
"last_data": "2025-10-29 22:08:03"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1600854,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-05/",
"name": "dt",
"value": "2025-11-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-05 13:18:26",
"last_data": "2025-11-05 13:34:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1600985,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-06/",
"name": "dt",
"value": "2025-11-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-06 05:45:06",
"last_data": "2025-11-06 15:12:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1601594,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-08/",
"name": "dt",
"value": "2025-11-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-08 16:54:32",
"last_data": "2025-11-08 16:59:26"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1601679,
"location": "s3://sfdl-segment-ssdc-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:11:16",
"last_data": "2025-11-08 20:20:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1602158,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-11/",
"name": "dt",
"value": "2025-11-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-10 21:03:50",
"last_data": "2025-11-11 06:10:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1602366,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-12/",
"name": "dt",
"value": "2025-11-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-11 19:04:52",
"last_data": "2025-11-11 19:04:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1602774,
"location": "s3://sfdl-segment-ssdc-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 12:02:44",
"last_data": "2025-11-13 12:47:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1602878,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-14/",
"name": "dt",
"value": "2025-11-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-14 02:57:33",
"last_data": "2025-11-14 04:52:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1603080,
"location": "s3://sfdl-segment-ssdc-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:16:10",
"last_data": "2025-11-14 19:24:24"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1605813,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-17/",
"name": "dt",
"value": "2025-11-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-17 08:05:27",
"last_data": "2025-11-17 08:05:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1606372,
"location": "s3://sfdl-segment-ssdc-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 10:04:47",
"last_data": "2025-11-19 17:00:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1606498,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-20/",
"name": "dt",
"value": "2025-11-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-19 19:59:21",
"last_data": "2025-11-19 20:05:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1607556,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-22/",
"name": "dt",
"value": "2025-11-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-22 07:02:03",
"last_data": "2025-11-22 07:02:03"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1607905,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-23/",
"name": "dt",
"value": "2025-11-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-23 16:45:24",
"last_data": "2025-11-23 16:45:24"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1608373,
"location": "s3://sfdl-segment-ssdc-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 17:52:56",
"last_data": "2025-11-25 17:52:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1608836,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-27/",
"name": "dt",
"value": "2025-11-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-27 16:04:45",
"last_data": "2025-11-27 16:04:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1609065,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-11-28/",
"name": "dt",
"value": "2025-11-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-28 16:59:38",
"last_data": "2025-11-28 17:03:26"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1610000,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-02/",
"name": "dt",
"value": "2025-12-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-02 16:57:50",
"last_data": "2025-12-02 16:57:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1610039,
"location": "s3://sfdl-segment-ssdc-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 18:54:37",
"last_data": "2025-12-03 15:08:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1611554,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-08/",
"name": "dt",
"value": "2025-12-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-08 03:01:52",
"last_data": "2025-12-08 03:01:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1612847,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-12/",
"name": "dt",
"value": "2025-12-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-12 08:48:08",
"last_data": "2025-12-12 08:48:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1613079,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-13/",
"name": "dt",
"value": "2025-12-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-12 23:57:22",
"last_data": "2025-12-13 02:15:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1616598,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-17/",
"name": "dt",
"value": "2025-12-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-17 08:09:45",
"last_data": "2025-12-17 08:09:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1616897,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-18/",
"name": "dt",
"value": "2025-12-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-18 10:00:03",
"last_data": "2025-12-18 16:51:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1617128,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-19/",
"name": "dt",
"value": "2025-12-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-19 14:54:47",
"last_data": "2025-12-19 14:54:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1618021,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-23/",
"name": "dt",
"value": "2025-12-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-23 14:47:19",
"last_data": "2025-12-23 18:03:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1618171,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-24/",
"name": "dt",
"value": "2025-12-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-24 08:57:33",
"last_data": "2025-12-24 09:01:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1618451,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-25/",
"name": "dt",
"value": "2025-12-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-25 14:57:40",
"last_data": "2025-12-25 14:59:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1618745,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-27/",
"name": "dt",
"value": "2025-12-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-26 21:02:05",
"last_data": "2025-12-26 21:02:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1618990,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-28/",
"name": "dt",
"value": "2025-12-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-28 06:56:00",
"last_data": "2025-12-28 12:00:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1619226,
"location": "s3://sfdl-segment-ssdc-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 03:57:49",
"last_data": "2025-12-29 03:57:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1619430,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-30/",
"name": "dt",
"value": "2025-12-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-30 00:57:52",
"last_data": "2025-12-30 13:57:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1619679,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2025-12-31/",
"name": "dt",
"value": "2025-12-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-31 06:00:52",
"last_data": "2025-12-31 06:00:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1620009,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-01/",
"name": "dt",
"value": "2026-01-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-01 11:55:12",
"last_data": "2026-01-01 11:55:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1620086,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-02/",
"name": "dt",
"value": "2026-01-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-01 20:02:53",
"last_data": "2026-01-01 20:02:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1620661,
"location": "s3://sfdl-segment-ssdc-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 17:59:40",
"last_data": "2026-01-04 17:59:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1621095,
"location": "s3://sfdl-segment-ssdc-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 11:59:42",
"last_data": "2026-01-06 11:59:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1621224,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-07/",
"name": "dt",
"value": "2026-01-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-07 06:00:34",
"last_data": "2026-01-07 06:00:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1621543,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-08/",
"name": "dt",
"value": "2026-01-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-08 10:54:56",
"last_data": "2026-01-08 10:58:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1621744,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-09/",
"name": "dt",
"value": "2026-01-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-09 14:36:46",
"last_data": "2026-01-09 14:38:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1622081,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-11/",
"name": "dt",
"value": "2026-01-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-11 02:58:19",
"last_data": "2026-01-11 02:58:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1622300,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-12/",
"name": "dt",
"value": "2026-01-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-11 22:00:32",
"last_data": "2026-01-12 14:01:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1622659,
"location": "s3://sfdl-segment-ssdc-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 04:02:10",
"last_data": "2026-01-13 15:50:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1625583,
"location": "s3://sfdl-segment-ssdc-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 09:55:05",
"last_data": "2026-01-16 09:59:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1625649,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-17/",
"name": "dt",
"value": "2026-01-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-16 19:01:01",
"last_data": "2026-01-17 08:58:28"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1626911,
"location": "s3://sfdl-segment-ssdc-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 15:53:32",
"last_data": "2026-01-21 15:57:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1627881,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-26/",
"name": "dt",
"value": "2026-01-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-26 05:41:09",
"last_data": "2026-01-26 15:48:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1628084,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-27/",
"name": "dt",
"value": "2026-01-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-27 03:54:09",
"last_data": "2026-01-27 04:51:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1628280,
"location": "s3://sfdl-segment-ssdc-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:56:30",
"last_data": "2026-01-28 16:54:31"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1628498,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-29/",
"name": "dt",
"value": "2026-01-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-28 19:55:39",
"last_data": "2026-01-29 15:04:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1628872,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-30/",
"name": "dt",
"value": "2026-01-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-30 13:42:57",
"last_data": "2026-01-30 18:46:24"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1628951,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-01-31/",
"name": "dt",
"value": "2026-01-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-30 19:54:23",
"last_data": "2026-01-31 10:03:30"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1629522,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-02/",
"name": "dt",
"value": "2026-02-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-02 12:02:36",
"last_data": "2026-02-02 12:04:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1629807,
"location": "s3://sfdl-segment-ssdc-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 15:44:52",
"last_data": "2026-02-03 15:48:24"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1629894,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-04/",
"name": "dt",
"value": "2026-02-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-03 21:01:23",
"last_data": "2026-02-04 06:55:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1631181,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-10/",
"name": "dt",
"value": "2026-02-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-09 18:55:27",
"last_data": "2026-02-10 18:15:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1631436,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-11/",
"name": "dt",
"value": "2026-02-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-10 21:57:00",
"last_data": "2026-02-10 21:57:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1632676,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-15/",
"name": "dt",
"value": "2026-02-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-15 16:53:29",
"last_data": "2026-02-15 16:53:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1634975,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-16/",
"name": "dt",
"value": "2026-02-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-16 15:45:57",
"last_data": "2026-02-16 15:50:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1635407,
"location": "s3://sfdl-segment-ssdc-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 13:42:53",
"last_data": "2026-02-18 13:46:32"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1636320,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-22/",
"name": "dt",
"value": "2026-02-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-22 12:50:41",
"last_data": "2026-02-22 12:50:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1636414,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-23/",
"name": "dt",
"value": "2026-02-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-23 03:56:33",
"last_data": "2026-02-23 03:56:33"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1636585,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-24/",
"name": "dt",
"value": "2026-02-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-23 18:53:41",
"last_data": "2026-02-23 20:58:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1637072,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-02-25/",
"name": "dt",
"value": "2026-02-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-25 09:42:47",
"last_data": "2026-02-25 09:58:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1643108,
"location": "s3://sfdl-segment-ssdc-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 17:58:06",
"last_data": "2026-03-08 18:03:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1644929,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-03-10/",
"name": "dt",
"value": "2026-03-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-10 16:46:31",
"last_data": "2026-03-10 16:46:31"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1648096,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-03-17/",
"name": "dt",
"value": "2026-03-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-16 21:58:52",
"last_data": "2026-03-16 21:58:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1650558,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-03-27/",
"name": "dt",
"value": "2026-03-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-27 17:48:15",
"last_data": "2026-03-27 17:51:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1650843,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-03-29/",
"name": "dt",
"value": "2026-03-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-28 22:59:15",
"last_data": "2026-03-28 23:02:32"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1651997,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-04-01/",
"name": "dt",
"value": "2026-04-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-31 20:01:12",
"last_data": "2026-04-01 14:07:31"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1652521,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-04-02/",
"name": "dt",
"value": "2026-04-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-02 10:56:00",
"last_data": "2026-04-02 10:56:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1652727,
"location": "s3://sfdl-segment-ssdc-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 10:01:49",
"last_data": "2026-04-03 10:03:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1652958,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-04-04/",
"name": "dt",
"value": "2026-04-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-04 18:48:14",
"last_data": "2026-04-04 18:48:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1656898,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-04-07/",
"name": "dt",
"value": "2026-04-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-07 13:55:38",
"last_data": "2026-04-07 13:55:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1657682,
"location": "s3://sfdl-segment-ssdc-prod/separated_dt/experiment_bucketing/dt=2026-04-10/",
"name": "dt",
"value": "2026-04-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-10 09:01:13",
"last_data": "2026-04-10 09:04:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
}
],
"type": "string"
},
"schema": {
"attributes": {
"_origin": "string",
"anonymousId": "string",
"channel": "string",
"context.campaign.20on_20lineutm_campaign": "string",
"context.campaign.3Butm_campaign": "string",
"context.campaign.3Butm_content": "string",
"context.campaign.3Butm_medium": "string",
"context.campaign.3Butm_source": "string",
"context.campaign.E": "string",
"context.campaign.audience": "string",
"context.campaign.c": "string",
"context.campaign.ca": "string",
"context.campaign.cam": "string",
"context.campaign.campa": "string",
"context.campaign.campai6661e9bbed8258a64c1acc8": "string",
"context.campaign.campaig": "string",
"context.campaign.campaign_5B_5D": "string",
"context.campaign.campaign_5b_5d": "string",
"context.campaign.campaign__": "string",
"context.campaign.capermpaign": "string",
"context.campaign.clkid": "string",
"context.campaign.cokwid": "string",
"context.campaign.colantent": "string",
"context.campaign.conte": "string",
"context.campaign.conte_20int": "string",
"context.campaign.conten": "string",
"context.campaign.content": "string",
"context.campaign.content_5B_5D": "string",
"context.campaign.content_5b_5d": "string",
"context.campaign.content__": "string",
"context.campaign.device": "string",
"context.campaign.expid": "string",
"context.campaign.id": "string",
"context.campaign.keyword": "string",
"context.campaign.mdium": "string",
"context.campaign.med": "string",
"context.campaign.mediu": "string",
"context.campaign.medium": "string",
"context.campaign.medium_5B_5D": "string",
"context.campaign.medium_5b_5d": "string",
"context.campaign.medium__": "string",
"context.campaign.mediumsepaidsearch": "string",
"context.campaign.name": "string",
"context.campaign.preview": "string",
"context.campaign.referrer": "string",
"context.campaign.s": "string",
"context.campaign.s_3A_2F_2Fstorage.com_2Fpaid_landing_2F_3Futm_source": "string",
"context.campaign.s_3A_2F_2Fwww.selfstorage.com_2Flpg_2Flf_2Fhp_copy_3Futm_source": "string",
"context.campaign.sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9006703_26iloc_3D_26mkwid_3DsRDnqlcZ5_7Cpcrid_7C696163462457_7Cpkw_7Cct_2520self_2520storage_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C42564149266_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_305827747823_7Cadext_7C23522909753_26pgrid_3D42564149266_26ptaid_3Dkwd_305827747823_26gad_source_3D5": "string",
"context.campaign.sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9031532_26iloc_3D_26mkwid_3DsBQyUqhqA_7Cpcrid_7C696163551515_7Cpkw_7Cstorage_2520units_2520in_2520irvine_2520ca_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C51459594868_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_2336767968704_7Cadext_7C23522909753_26pgrid_3D51459594868_26ptaid_3Dkwd_2336767968704_26gad_source_3D5": "string",
"context.campaign.sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9033328_26iloc_3D_26mkwid_3DsnvUD3btz_7Cpcrid_7C696163443785_7Cpkw_7Cstorage_2520units_2520renton_2520wa_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C9925369291_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_302193213759_7Cadext_7C23522909783_26pgrid_3D9925369291_26ptaid_3Dkwd_302193213759_26gad_source_3D5": "string",
"context.campaign.sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9060252_26iloc_3D_26mkwid_3DsuRMGswaK_7Cpcrid_7C673402998617_7Cpkw_7Cclimate_2520control_2520storage_2520chicago_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C55910009687_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_295688063246_7Cadext_7C23522909783_26pgrid_3D55910009687_26ptaid_3Dkwd_295688063246_26gad_source_3D5": "string",
"context.campaign.sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3Dcontrol_26ploc_3D1012727_26iloc_3D9073451_26mkwid_3DsyurQSeRX_7Cpcrid_7C591132448308_7Cpkw_7Cstorage_2520units_2520san_2520francisco_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C46181760673_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_302938169436_7Cadext_7C23522909876_26pgrid_3D46181760673_26ptaid_3Dkwd_302938169436_26gad_source_3D5": "string",
"context.campaign.sour": "string",
"context.campaign.sourc": "string",
"context.campaign.source": "string",
"context.campaign.source_2020": "string",
"context.campaign.source_5B_5D": "string",
"context.campaign.source_5b_5d": "string",
"context.campaign.source__": "string",
"context.campaign.sself_20storage": "string",
"context.campaign.syahoource": "string",
"context.campaign.t": "string",
"context.campaign.term": "string",
"context.campaign.utm_campaign": "string",
"context.campaign.utm_content": "string",
"context.campaign.utm_medium": "string",
"context.campaign.utm_source": "string",
"context.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-15 07:59:22",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.ssdc_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<`library`:struct<`version`:STRING,`name`:STRING>,`campaign`:struct<`cam`:STRING,`conte_20int`:STRING,`medium_5B_5D`:STRING,`sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3Dcontrol_26ploc_3D1012727_26iloc_3D9073451_26mkwid_3DsyurQSeRX_7Cpcrid_7C591132448308_7Cpkw_7Cstorage_2520units_2520san_2520francisco_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C46181760673_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_302938169436_7Cadext_7C23522909876_26pgrid_3D46181760673_26ptaid_3Dkwd_302938169436_26gad_source_3D5`:STRING,`colantent`:STRING,`expid`:STRING,`3Butm_medium`:STRING,`utm_term`:STRING,`utm_content`:STRING,`conten`:STRING,`device`:STRING,`utm_medium`:STRING,`medium`:STRING,`med`:STRING,`referrer`:STRING,`medium__`:STRING,`cokwid`:STRING,`sself_20storage`:STRING,`content__`:STRING,`term`:STRING,`sour`:STRING,`id`:STRING,`audience`:STRING,`clkid`:STRING,`campaig`:STRING,`campaign__`:STRING,`utm_source`:STRING,`t`:STRING,`sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9031532_26iloc_3D_26mkwid_3DsBQyUqhqA_7Cpcrid_7C696163551515_7Cpkw_7Cstorage_2520units_2520in_2520irvine_2520ca_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C51459594868_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_2336767968704_7Cadext_7C23522909753_26pgrid_3D51459594868_26ptaid_3Dkwd_2336767968704_26gad_source_3D5`:STRING,`source_5B_5D`:STRING,`c`:STRING,`syahoource`:STRING,`campai6661e9bbed8258a64c1acc8`:STRING,`sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9006703_26iloc_3D_26mkwid_3DsRDnqlcZ5_7Cpcrid_7C696163462457_7Cpkw_7Cct_2520self_2520storage_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C42564149266_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_305827747823_7Cadext_7C23522909753_26pgrid_3D42564149266_26ptaid_3Dkwd_305827747823_26gad_source_3D5`:STRING,`campaign_5b_5d`:STRING,`content_5B_5D`:STRING,`sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9033328_26iloc_3D_26mkwid_3DsnvUD3btz_7Cpcrid_7C696163443785_7Cpkw_7Cstorage_2520units_2520renton_2520wa_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C9925369291_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_302193213759_7Cadext_7C23522909783_26pgrid_3D9925369291_26ptaid_3Dkwd_302193213759_26gad_source_3D5`:STRING,`sid_3Dgoogle_ppc_26utm_source_3Dgoogle_26utm_medium_3Dpaidsearch_26utm_campaign_3DSSDC_2BGoogle_257CGeneral_257CExact_26utm_content_3D_26ploc_3D9060252_26iloc_3D_26mkwid_3DsuRMGswaK_7Cpcrid_7C673402998617_7Cpkw_7Cclimate_2520control_2520storage_2520chicago_7Cpmt_7Cb_7Cpdv_7Cm_7Cpgrid_7C55910009687_7Ccpgnid_7C194908291_7Cptaid_7Ckwd_295688063246_7Cadext_7C23522909783_26pgrid_3D55910009687_26ptaid_3Dkwd_295688063246_26gad_source_3D5`:STRING,`conte`:STRING,`3Butm_content`:STRING,`20on_20lineutm_campaign`:STRING,`ca`:STRING,`medium_5b_5d`:STRING,`mdium`:STRING,`source_5b_5d`:STRING,`preview`:STRING,`E`:STRING,`source_2020`:STRING,`mediumsepaidsearch`:STRING,`utm_campaign`:STRING,`3Butm_campaign`:STRING,`content`:STRING,`3Butm_source`:STRING,`keyword`:STRING,`sourc`:STRING,`mediu`:STRING,`content_5b_5d`:STRING,`s_3A_2F_2Fwww`:struct<`selfstorage`:struct<`com_2Flpg_2Flf_2Fhp_copy_3Futm_source`:STRING>>,`campaign_5B_5D`:STRING,`capermpaign`:STRING,`campa`:STRING,`s_3A_2F_2Fstorage`:struct<`com_2Fpaid_landing_2F_3Futm_source`:STRING>,`source`:STRING,`source__`:STRING,`s`:STRING,`name`:STRING>,`locale`:STRING,`userAgentData`:struct<`brands`:array>,`mobile`:STRING,`platform`:STRING>,`timezone`:STRING,`page`:struct<`search`:STRING,`title`:STRING,`referrer`:STRING,`path`:STRING,`url`: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-ssdc-prod/separated_dt/experiment_bucketing'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.ssdc_experiment_bucketing`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.ssdc_experiment_bucketing"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}