[05:45:03] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 10AbuseFilter, 06DBA, 07Schema-change-in-production: Drop the afl_ip column and the afl_ip_timestamp index from the abuse_filter_log table - https://phabricator.wikimedia.org/T407997#11326076 (10Marostegui) [09:30:02] (03CR) 10A-pizzata: [C:03+1] Add Data quality check for Pageview Human-Bot ratio anomaly [analytics/refinery/source] - 10https://gerrit.wikimedia.org/r/1199485 (https://phabricator.wikimedia.org/T407239) (owner: 10Snwachukwu) [11:04:22] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 06Movement-Insights, 06Data-Platform-SRE (2025.10.17 - 2025.11.07), 07Epic: Create example dbt models using Iceberg - https://phabricator.wikimedia.org/T408687#11326741 (10JAllemandou) One thing I wish to highlight here is that for the moment on... [11:07:49] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 06SRE: Move Druid realtime configuration out of Refinery into standalone repo on GitLab - https://phabricator.wikimedia.org/T407994#11326744 (10JAllemandou) The reason for which I suggested doing this task is that Druid-realtime are a specific type o... [11:15:01] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 06Movement-Insights, 06Data-Platform-SRE (2025.10.17 - 2025.11.07), 07Epic: Create example dbt models using Iceberg - https://phabricator.wikimedia.org/T408687#11326754 (10JMonton-WMF) Then we could discard the `merge` strategy and use the [[ htt... [11:48:50] 06Data-Engineering, 10LDAP-Access-Requests, 06SRE: Grant Access to analytics-privatedata-users for mvernon - https://phabricator.wikimedia.org/T408793 (10MatthewVernon) 03NEW [11:54:49] 06Data-Engineering, 06SRE, 10SRE-Access-Requests: Grant Access to analytics-privatedata-users for mvernon - https://phabricator.wikimedia.org/T408793#11326898 (10taavi) [12:33:39] 07Analytics-Data-Problem, 06Data-Engineering, 06Movement-Insights, 06Product-Analytics, 13Patch-For-Review: webrequest dataset sets referer_class "unknown" instead of "external (search engine)" for origin-based referer values - https://phabricator.wikimedia.org/T383088#11326959 (10JAllemandou) 05Ope... [12:34:24] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 06Movement-Insights: Improve referrer tracking/classification using `utm_source` URL parameter - https://phabricator.wikimedia.org/T408185#11326963 (10JAllemandou) a:05JAllemandou→03None [12:40:34] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 10Data-Platform, 07Essential-Work, 06Movement-Insights (FY25-26 H1), 13Patch-For-Review: NEWFEATURE REQUEST: Add new referral sources to pageview data - https://phabricator.wikimedia.org/T406531#11326976 (10JAllemandou) Back from holidays, I'll... [13:28:44] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 10AbuseFilter, 06DBA, 07Schema-change-in-production: Drop the afl_ip column and the afl_ip_timestamp index from the abuse_filter_log table - https://phabricator.wikimedia.org/T407997#11327097 (10Marostegui) [13:38:34] 06Data-Engineering, 10MediaWiki-Core-Hooks: Spike: investigate incorrect page_id values in pageview_hourly - https://phabricator.wikimedia.org/T408798#11327155 (10Milimetric) [13:41:28] (03PS1) 10Aqu: Add min.wikisource & pcm.wikiquote to pageview allowlist [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1200066 [13:41:44] 06Data-Engineering, 10MediaWiki-Core-Hooks: Spike: investigate incorrect page_id values in pageview_hourly - https://phabricator.wikimedia.org/T408798#11327158 (10Milimetric) For this hour, I looked at the data and found some low variability in country and access method: ` select DISTINCT country, access_met... [13:43:25] (03PS2) 10Aqu: Add min.wikisource & pcm.wikiquote to pageview allowlist [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1200066 [13:45:39] (03CR) 10A-pizzata: [C:03+1] Add min.wikisource & pcm.wikiquote to pageview allowlist [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1200066 (owner: 10Aqu) [13:46:10] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 10AbuseFilter, 06DBA, 07Schema-change-in-production: Drop the afl_ip column and the afl_ip_timestamp index from the abuse_filter_log table - https://phabricator.wikimedia.org/T407997#11327191 (10Marostegui) [13:47:05] (03CR) 10Mforns: Add min.wikisource & pcm.wikiquote to pageview allowlist (031 comment) [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1200066 (owner: 10Aqu) [13:54:06] (03CR) 10Aqu: [C:03+2] Add min.wikisource to pageview allowlist [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1198722 (https://phabricator.wikimedia.org/T408343) (owner: 10Gerrit maintenance bot) [13:54:10] (03CR) 10Aqu: [C:03+2] Add pcm.wikiquote to pageview allowlist [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1198724 (https://phabricator.wikimedia.org/T408351) (owner: 10Gerrit maintenance bot) [13:57:25] 06Data-Engineering, 10MediaWiki-Core-Hooks: Spike: investigate incorrect page_id values in pageview_hourly - https://phabricator.wikimedia.org/T408798#11327263 (10Milimetric) Looking at webrequest in more detail for that specific second IP, all these requests appear to be diffs requested every few seconds duri... [14:01:48] (03Abandoned) 10Aqu: Add min.wikisource & pcm.wikiquote to pageview allowlist [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1200066 (owner: 10Aqu) [14:02:51] (03CR) 10Aqu: [V:03+2 C:03+2] Add pcm.wikiquote to pageview allowlist [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1198724 (https://phabricator.wikimedia.org/T408351) (owner: 10Gerrit maintenance bot) [14:03:09] (03CR) 10Aqu: [V:03+2 C:03+2] Add min.wikisource to pageview allowlist [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1198722 (https://phabricator.wikimedia.org/T408343) (owner: 10Gerrit maintenance bot) [14:40:29] (03PS6) 10Joal: Update referer classification patterns [analytics/refinery/source] - 10https://gerrit.wikimedia.org/r/1198313 (https://phabricator.wikimedia.org/T406531) [14:41:51] (03PS7) 10Joal: Update referer classification patterns [analytics/refinery/source] - 10https://gerrit.wikimedia.org/r/1198313 (https://phabricator.wikimedia.org/T406531) [14:42:54] (03CR) 10Joal: "I updated the code with latest requests and corrected comments. Let me know what you folks think :)" [analytics/refinery/source] - 10https://gerrit.wikimedia.org/r/1198313 (https://phabricator.wikimedia.org/T406531) (owner: 10Joal) [15:00:38] (03PS1) 10CDanis: druid: webrequest_live: add x_is_browser [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1200087 [15:02:05] 06Data-Engineering, 10MediaWiki-Core-Hooks, 06MW-Interfaces-Team: Spike: investigate incorrect page_id values in pageview_hourly - https://phabricator.wikimedia.org/T408798#11327689 (10Ottomata) [15:02:10] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 10MediaWiki-Page-derived-data, 07OKR-Work, 13Patch-For-Review: Global Editor Metrics - Data Pipeline - https://phabricator.wikimedia.org/T405039#11327690 (10Ottomata) [15:37:10] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 13Patch-For-Review: Implement the data layout, UI, and documentation for the XML file export - https://phabricator.wikimedia.org/T401022#11327936 (10xcollazo) >>! In T401022#11324943, @xcollazo wrote: > Rerunning `mw_content_xml_export_current_mid_mo... [15:40:18] 06Data-Engineering, 10MediaWiki-Core-Hooks, 06MW-Interfaces-Team: Spike: investigate incorrect page_id values in pageview_hourly - https://phabricator.wikimedia.org/T408798#11327989 (10Ottomata) [15:43:37] (03CR) 10Vgutierrez: [C:03+1] "looking good from the CDN PoV" [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1200087 (owner: 10CDanis) [15:54:16] 06Data-Engineering, 10DPE-Mediawiki-Content: When wikis cannot be exported due to SiteInfo, don't fail them - https://phabricator.wikimedia.org/T408819 (10xcollazo) 03NEW [15:54:38] 06Data-Engineering, 10DPE-Mediawiki-Content: When wikis cannot be exported due to SiteInfo, don't fail them - https://phabricator.wikimedia.org/T408819#11328086 (10xcollazo) [15:54:39] 10Data-Engineering-Roadmap, 10DPE-Mediawiki-Content, 07Epic: Dumps 2.0 Phase III: Production level dumps (SDS 1.2) - https://phabricator.wikimedia.org/T366752#11328087 (10xcollazo) [16:02:14] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 06Data-Persistence, 10Data-Persistence-Design-Review, 06Growth-Team, and 3 others: Data Persistence Design Review: Improve Tone Suggested Edits newcomer task - https://phabricator.wikimedia.org/T401021#11328139 (10Michael) @AikoChou, @BWojtowicz-... [16:03:39] 06Data-Engineering, 10MediaWiki-Core-Hooks, 06MW-Interfaces-Team: Spike: investigate incorrect page_id values in pageview_hourly - https://phabricator.wikimedia.org/T408798#11328143 (10BPirkle) p:05Triage→03Medium I'm unclear on the impact of this bug. If it is more impactful than a "Medium" priority, pl... [16:10:23] (03CR) 10Xcollazo: [C:03+1] "LGTM, thank you for the alphabetical ordering!" [analytics/refinery/source] - 10https://gerrit.wikimedia.org/r/1198313 (https://phabricator.wikimedia.org/T406531) (owner: 10Joal) [16:11:35] 06Data-Engineering, 10MediaWiki-Core-Hooks, 06MW-Interfaces-Team: Spike: investigate incorrect page_id values in pageview_hourly - https://phabricator.wikimedia.org/T408798#11328175 (10Ottomata) For {T405039}, we are using pageview_hourly to compute editor impact metrics. We wanted to include the page_title... [16:17:16] (03PS18) 10Ottomata: Add HQL for edit_per_editor_per_page_daily and pageview_per_editor_per_page_daily [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1196892 (https://phabricator.wikimedia.org/T407559) [16:25:56] (03CR) 10Ottomata: Add HQL for edit_per_editor_per_page_daily and pageview_per_editor_per_page_daily (032 comments) [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1196892 (https://phabricator.wikimedia.org/T407559) (owner: 10Ottomata) [16:26:29] 06Data-Engineering, 06SRE, 10SRE-Access-Requests: Grant Access to analytics-privatedata-users for mvernon - https://phabricator.wikimedia.org/T408793#11328329 (10KOfori) This has my approval. [16:36:05] (03PS19) 10Ottomata: Add HQL for edit_per_editor_per_page_daily and pageview_per_editor_per_page_daily [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1196892 (https://phabricator.wikimedia.org/T407559) [16:46:42] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 06Movement-Insights, 06Data-Platform-SRE (2025.10.17 - 2025.11.07), 07Epic: Create example dbt models using Iceberg - https://phabricator.wikimedia.org/T408687#11328518 (10amastilovic) `insert_overwrite` is what @JAllemandou is describing, perfect. [16:49:38] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 06Growth-Team, 10MediaWiki-Page-derived-data, 06Wikipedia-Android-App-Backlog, and 3 others: Global Editor Metrics - HTTP API endpoints - https://phabricator.wikimedia.org/T405041#11328533 (10Ottomata) I just deployed the pageviews/v3/per_editor... [17:06:34] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th): Create dbt folder structure - https://phabricator.wikimedia.org/T407322#11328635 (10amastilovic) @JMonton-WMF I think we could use this task to include a `.dbtignore` file that will let `dbt` commands ignore the `.ipynb_checkpoint` folders: https://doc... [17:16:46] (03CR) 10Snwachukwu: [C:03+1] Update referer classification patterns [analytics/refinery/source] - 10https://gerrit.wikimedia.org/r/1198313 (https://phabricator.wikimedia.org/T406531) (owner: 10Joal) [17:31:28] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th): Create dbt folder structure - https://phabricator.wikimedia.org/T407322#11328821 (10JMonton-WMF) Sounds good. I've [[ https://gitlab.wikimedia.org/repos/data-engineering/dbt-jobs/-/merge_requests/1 | updated the MR ]] to include the .dbignore and remov... [17:35:23] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 10Data-Platform, 07Essential-Work, 06Movement-Insights (FY25-26 H1), 13Patch-For-Review: NEWFEATURE REQUEST: Add new referral sources to pageview data - https://phabricator.wikimedia.org/T406531#11328828 (10JAllemandou) Code got pushed and revi... [17:36:15] FIRING: HdfsRpcQueueLength: RPC call queue length on the analytics-hadoop cluster is too high. - https://wikitech.wikimedia.org/wiki/Analytics/Systems/Cluster/Hadoop/Alerts#HDFS_Namenode_RPC_length_queue - https://grafana.wikimedia.org/d/000000585/hadoop?var-hadoop_cluster=analytics-hadoop&orgId=1&panelId=54&fullscreen - https://alerts.wikimedia.org/?q=alertname%3DHdfsRpcQueueLength [17:40:24] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 06Movement-Insights, 06Data-Platform-SRE (2025.10.17 - 2025.11.07), 07Epic: Create example dbt models using Iceberg - https://phabricator.wikimedia.org/T408687#11328863 (10JAllemandou) To my understanding, the `insert_overwrite` strategy only wor... [17:41:15] RESOLVED: HdfsRpcQueueLength: RPC call queue length on the analytics-hadoop cluster is too high. - https://wikitech.wikimedia.org/wiki/Analytics/Systems/Cluster/Hadoop/Alerts#HDFS_Namenode_RPC_length_queue - https://grafana.wikimedia.org/d/000000585/hadoop?var-hadoop_cluster=analytics-hadoop&orgId=1&panelId=54&fullscreen - https://alerts.wikimedia.org/?q=alertname%3DHdfsRpcQueueLength [18:09:23] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 10Event-Platform: mediawiki_event_enrichment should enrich all events for the page_content_change stream - https://phabricator.wikimedia.org/T408850 (10xcollazo) 03NEW [18:09:34] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 10Event-Platform: mediawiki_event_enrichment should enrich all events for the page_content_change stream - https://phabricator.wikimedia.org/T408850#11329016 (10xcollazo) p:05Triage→03High [18:10:47] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 10Event-Platform: mediawiki_event_enrichment should enrich all events for the page_content_change stream - https://phabricator.wikimedia.org/T408850#11329021 (10xcollazo) [18:16:23] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 10Event-Platform: mediawiki_event_enrichment should enrich all events for the page_content_change stream - https://phabricator.wikimedia.org/T408850#11329049 (10Ottomata) Wow nice find. Def high priority and probably a great task for @JMonton-WMF to... [18:24:29] 10Data-Engineering-Roadmap, 10DPE-Mediawiki-Content, 07Epic: Dumps 2.0 Phase III: Production level dumps (SDS 1.2) - https://phabricator.wikimedia.org/T366752#11329105 (10xcollazo) [18:24:30] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 10Event-Platform: mediawiki_event_enrichment should enrich all events for the page_content_change stream - https://phabricator.wikimedia.org/T408850#11329104 (10xcollazo) [18:28:16] 06Data-Engineering, 10LDAP-Access-Requests, 06SRE, 10SRE-Access-Requests, 13Patch-For-Review: Grant Access to wmf LDAP and analytics-privatedata-users shell group for SherryYang-WMF - https://phabricator.wikimedia.org/T408639#11329123 (10Dzahn) [18:28:35] 06Data-Engineering, 06SRE, 10SRE-Access-Requests: Add dpogorzelski to ML and Data Platform posix groups - https://phabricator.wikimedia.org/T408579#11329137 (10Dzahn) [18:33:24] (03PS20) 10Ottomata: Add HQL for edit_per_editor_per_page_daily and pageview_per_editor_per_page_daily [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1196892 (https://phabricator.wikimedia.org/T407559) [18:33:39] (03CR) 10Ottomata: Add HQL for edit_per_editor_per_page_daily and pageview_per_editor_per_page_daily (031 comment) [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1196892 (https://phabricator.wikimedia.org/T407559) (owner: 10Ottomata) [18:57:31] (03PS4) 10Snwachukwu: Add Data quality check for Pageview Human-Bot ratio anomaly [analytics/refinery/source] - 10https://gerrit.wikimedia.org/r/1199485 (https://phabricator.wikimedia.org/T407239) [19:01:40] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 06Data-Persistence, 10Data-Persistence-Design-Review, 06Growth-Team, and 3 others: Data Persistence Design Review: Improve Tone Suggested Edits newcomer task - https://phabricator.wikimedia.org/T401021#11329271 (10achou) It’s good that we’re disc... [19:27:50] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 10MediaWiki-Page-derived-data, 07OKR-Work, 13Patch-For-Review: Global Editor Metrics - Data Pipeline - https://phabricator.wikimedia.org/T405039#11329322 (10Ottomata) @mforns and I were debugging our pageviews/per_editor queries yesterday, and we... [19:33:57] (03CR) 10Aleksandar Mastilovic: [C:03+1] "LGTM in general." [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1196892 (https://phabricator.wikimedia.org/T407559) (owner: 10Ottomata) [19:35:55] 06Data-Engineering, 10LDAP-Access-Requests, 06SRE, 10SRE-Access-Requests, 13Patch-For-Review: Grant Access to wmf LDAP and analytics-privatedata-users shell group for SherryYang-WMF - https://phabricator.wikimedia.org/T408639#11329331 (10Dzahn) Hello @SherryYang-WMF give it max. 30 minutes from now and y... [19:36:51] 06Data-Engineering, 10LDAP-Access-Requests, 06SRE, 10SRE-Access-Requests, 13Patch-For-Review: Grant Access to wmf LDAP and analytics-privatedata-users shell group for SherryYang-WMF - https://phabricator.wikimedia.org/T408639#11329332 (10Dzahn) 05Open→03Resolved a:03Dzahn [19:42:44] 06Data-Engineering, 10MediaWiki-Core-Hooks, 06MW-Interfaces-Team: Spike: investigate incorrect page_id values in pageview_hourly - https://phabricator.wikimedia.org/T408798#11329353 (10Ottomata) It seems there is more to look into here, but I wrote up the implications for Global Editor Metrics here: at T4050... [19:43:47] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 13Patch-For-Review: Implement the data layout, UI, and documentation for the XML file export - https://phabricator.wikimedia.org/T401022#11329354 (10xcollazo) Confirmed `SHA256SUMS` is WAD for a big wiki like `commonswiki`: ` analytics@an-launcher100... [19:47:53] (03CR) 10Ottomata: Add HQL for edit_per_editor_per_page_daily and pageview_per_editor_per_page_daily (031 comment) [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1196892 (https://phabricator.wikimedia.org/T407559) (owner: 10Ottomata) [19:51:20] (03CR) 10Aleksandar Mastilovic: [C:03+1] Add HQL for edit_per_editor_per_page_daily and pageview_per_editor_per_page_daily (031 comment) [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1196892 (https://phabricator.wikimedia.org/T407559) (owner: 10Ottomata) [19:52:08] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 06Data-Persistence, 10Data-Persistence-Design-Review, 06Growth-Team, and 3 others: Data Persistence Design Review: Improve Tone Suggested Edits newcomer task - https://phabricator.wikimedia.org/T401021#11329384 (10Ottomata) > We won't use a diffe... [19:52:57] 06Data-Engineering, 10MediaWiki-Core-Hooks, 06MW-Interfaces-Team: Spike: investigate incorrect page_id values in pageview_hourly - https://phabricator.wikimedia.org/T408798#11329386 (10Ottomata) Relevant: {T371321} [19:53:05] 06Data-Engineering, 10MediaWiki-Core-Hooks, 06MW-Interfaces-Team: Spike: investigate incorrect page_id values in pageview_hourly - https://phabricator.wikimedia.org/T408798#11329388 (10Ottomata) [19:53:08] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 10MediaWiki-Page-derived-data, 07OKR-Work, 13Patch-For-Review: Global Editor Metrics - Data Pipeline - https://phabricator.wikimedia.org/T405039#11329389 (10Ottomata) [19:53:11] 06Data-Engineering, 10MediaWiki-Core-Hooks, 06MW-Interfaces-Team: Spike: investigate incorrect page_id values in pageview_hourly - https://phabricator.wikimedia.org/T408798#11329390 (10Ottomata) Relevant: {T371321} [19:56:45] 06Data-Engineering, 06SRE, 10SRE-Access-Requests, 13Patch-For-Review: Grant Access to analytics-privatedata-users for mvernon - https://phabricator.wikimedia.org/T408793#11329422 (10Dzahn) @MatthewVernon You have been added to the group. Give it the usual couple minutes for puppet to deploy it across the f... [20:04:40] (03CR) 10Aleksandar Mastilovic: [C:03+1] Add HQL for edit_per_editor_per_page_daily and pageview_per_editor_per_page_daily (031 comment) [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1196892 (https://phabricator.wikimedia.org/T407559) (owner: 10Ottomata) [20:09:53] 06Data-Engineering, 06SRE, 10SRE-Access-Requests, 13Patch-For-Review: Grant Access to analytics-privatedata-users for mvernon - https://phabricator.wikimedia.org/T408793#11329460 (10Dzahn) @MatthewVernon I created the Kerberos principal for you per https://wikitech.wikimedia.org/wiki/Data_Platform/Systems/... [20:10:15] 06Data-Engineering, 06SRE, 10SRE-Access-Requests, 13Patch-For-Review: Grant Access to analytics-privatedata-users for mvernon - https://phabricator.wikimedia.org/T408793#11329461 (10Dzahn) 05Open→03Resolved a:03Dzahn [20:18:48] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 06Movement-Insights, 06Data-Platform-SRE (2025.10.17 - 2025.11.07), 07Epic: Create example dbt models using Iceberg - https://phabricator.wikimedia.org/T408687#11329483 (10amastilovic) That specific use-case sounds like what `dbt` calls a `microb... [20:23:33] (03CR) 10Ottomata: Add HQL for edit_per_editor_per_page_daily and pageview_per_editor_per_page_daily (031 comment) [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1196892 (https://phabricator.wikimedia.org/T407559) (owner: 10Ottomata) [20:28:08] (03CR) 10Aleksandar Mastilovic: [C:03+1] Add HQL for edit_per_editor_per_page_daily and pageview_per_editor_per_page_daily (031 comment) [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1196892 (https://phabricator.wikimedia.org/T407559) (owner: 10Ottomata) [20:32:58] (03PS21) 10Ottomata: Add HQL for edit_per_editor_per_page_daily and pageview_per_editor_per_page_daily [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1196892 (https://phabricator.wikimedia.org/T407559) [21:48:56] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 06Data-Persistence, 10Data-Persistence-Design-Review, 06Growth-Team, and 3 others: Data Persistence Design Review: Improve Tone Suggested Edits newcomer task - https://phabricator.wikimedia.org/T401021#11329865 (10Eevans) Ok, I've updated https:/... [22:34:14] 06Data-Engineering, 10MediaWiki-Core-Hooks, 06MW-Interfaces-Team: Spike: investigate incorrect page_id values in pageview_hourly - https://phabricator.wikimedia.org/T408798#11329946 (10Milimetric) 05Open→03Invalid Useful context from IRC follows below. Basically Timo points out this is not a bug. I... [22:37:36] 06Data-Engineering, 10MediaWiki-Core-Hooks, 06MW-Interfaces-Team, 06MediaWiki-Platform-Team (Radar): Spike: investigate incorrect page_id values in pageview_hourly - https://phabricator.wikimedia.org/T408798#11329949 (10Krinkle) [22:39:16] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 10Data-Platform, 07Essential-Work, 06Movement-Insights (FY25-26 H1), 13Patch-For-Review: NEWFEATURE REQUEST: Add new referral sources to pageview data - https://phabricator.wikimedia.org/T406531#11329952 (10Mayakp.wiki) thank you @JAllemandou ! [23:05:23] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 06Data-Platform-SRE: Add terms of use to https://dumps.wikimedia.org/index.html - https://phabricator.wikimedia.org/T408881 (10Ahoelzl) 03NEW [23:06:28] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 06Data-Platform-SRE: Add terms of use to https://dumps.wikimedia.org/index.html - https://phabricator.wikimedia.org/T408881#11330015 (10Ahoelzl) Mock up {F68693579} [23:12:22] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 06Data-Platform-SRE: Add terms of use to https://dumps.wikimedia.org/index.html - https://phabricator.wikimedia.org/T408881#11330038 (10Ahoelzl) The index.html page is generated using a template file "donwload-index.html". The file is generated in t... [23:13:42] 06Data-Engineering (Q2 FY25/26 October 1st - December 31th), 06Data-Platform-SRE: Add terms of use to https://dumps.wikimedia.org/index.html - https://phabricator.wikimedia.org/T408881#11330039 (10Ahoelzl) Please also edit index.html directly cloudsdumps1002 server dumps directory to make the change visible as...