Page MenuHomePhabricator

ntsako (Ntsako)
Disabled

Projects

User Details

User Since
Jan 4 2022, 7:07 PM (120 w, 18 h)
Roles
Disabled
LDAP User
Unknown
MediaWiki User
NMaphophe (WMF) [ Global Accounts ]
This account has been disabled.

Recent Activity

Jul 31 2023

ntsako closed T333457: Expose gdi schema as a production schema on DataHub as Resolved.
Jul 31 2023, 1:23 PM · Equity-Landscape
ntsako added a comment to T333457: Expose gdi schema as a production schema on DataHub.

GDI schema data is loaded on DataHub PROD.

Jul 31 2023, 1:23 PM · Equity-Landscape
ntsako moved T338338: Freedom Inputs, transformations, and outputs from In Development to In QA Review on the Equity-Landscape board.
Jul 31 2023, 1:22 PM · Equity-Landscape
ntsako moved T338339: Programs Inputs, Transformation, & Outputs from In Development to In QA Review on the Equity-Landscape board.
Jul 31 2023, 1:22 PM · Equity-Landscape

Jul 28 2023

ntsako moved T341145: Add unique_grantees and primarily located affiliates metrics to input metrics parquet file from In Development to In QA Review on the Equity-Landscape board.
Jul 28 2023, 6:45 AM · Movement-Insights, Equity-Landscape
ntsako moved T333457: Expose gdi schema as a production schema on DataHub from In Development to In QA Review on the Equity-Landscape board.
Jul 28 2023, 6:44 AM · Equity-Landscape

Jul 24 2023

ntsako added a comment to T342269: [Spike] Review Equity Landscape Pipeline and Data Collection Approach.

Where do the CSV source files in HDFS come from?

Jul 24 2023, 12:00 PM · Data Products (Sprint 0), Movement-Insights, Equity-Landscape

Jul 19 2023

ntsako added a comment to T341145: Add unique_grantees and primarily located affiliates metrics to input metrics parquet file.

primary_located_affiliates: based on affiliate_country

Jul 19 2023, 3:21 PM · Movement-Insights, Equity-Landscape
ntsako added a comment to T341145: Add unique_grantees and primarily located affiliates metrics to input metrics parquet file.

unique_grantees: based on unique_grantee_id

count distinct unique IDs from grants_input_metrics table for the specific calendar year
Jul 19 2023, 3:14 PM · Movement-Insights, Equity-Landscape
ntsako moved T341145: Add unique_grantees and primarily located affiliates metrics to input metrics parquet file from Up Next to In Development on the Equity-Landscape board.
Jul 19 2023, 2:28 PM · Movement-Insights, Equity-Landscape

Jul 18 2023

ntsako closed T315886: Load language data, a subtask of T305475: Milestone: Ingest and Transform Input Data, as Resolved.
Jul 18 2023, 5:09 PM · Equity-Landscape
ntsako closed T315886: Load language data as Resolved.
Jul 18 2023, 5:09 PM · Equity-Landscape
ntsako added a comment to T315886: Load language data.

Done

Jul 18 2023, 5:09 PM · Equity-Landscape
ntsako moved T315886: Load language data from In QA Review to Pending Deploy on the Equity-Landscape board.
Jul 18 2023, 4:54 PM · Equity-Landscape
ntsako closed T329185: Access output metrics, a subtask of T306625: Extract + Transformation Raw Data into Input Metrics, as Resolved.
Jul 18 2023, 4:52 PM · Equity-Landscape
ntsako closed T329185: Access output metrics as Resolved.
Jul 18 2023, 4:52 PM · Equity-Landscape
ntsako added a comment to T329185: Access output metrics.

Done

Jul 18 2023, 4:52 PM · Equity-Landscape
ntsako closed T306624: Population output rank metrics, a subtask of T305475: Milestone: Ingest and Transform Input Data, as Resolved.
Jul 18 2023, 4:52 PM · Equity-Landscape
ntsako closed T306624: Population output rank metrics as Resolved.
Jul 18 2023, 4:52 PM · Equity-Landscape
ntsako added a comment to T306624: Population output rank metrics.

Done

Jul 18 2023, 4:51 PM · Equity-Landscape
ntsako closed T330295: 2022 - Affiliates input metrics as Resolved.
Jul 18 2023, 4:51 PM · Equity-Landscape
ntsako closed T330295: 2022 - Affiliates input metrics , a subtask of T306625: Extract + Transformation Raw Data into Input Metrics, as Resolved.
Jul 18 2023, 4:51 PM · Equity-Landscape
ntsako added a comment to T330295: 2022 - Affiliates input metrics .

Done

Jul 18 2023, 4:51 PM · Equity-Landscape
ntsako closed T309279: Population input metrics as Resolved.
Jul 18 2023, 4:51 PM · Equity-Landscape
ntsako closed T309279: Population input metrics, a subtask of T306625: Extract + Transformation Raw Data into Input Metrics, as Resolved.
Jul 18 2023, 4:51 PM · Equity-Landscape
ntsako added a comment to T309279: Population input metrics.

Done

Jul 18 2023, 4:50 PM · Equity-Landscape
ntsako closed T324968: Access input metrics, a subtask of T306625: Extract + Transformation Raw Data into Input Metrics, as Resolved.
Jul 18 2023, 4:50 PM · Equity-Landscape
ntsako closed T324968: Access input metrics as Resolved.
Jul 18 2023, 4:50 PM · Equity-Landscape
ntsako added a comment to T324968: Access input metrics.

Done

Jul 18 2023, 4:50 PM · Equity-Landscape
ntsako closed T332726: Update the metric descriptions of hive tables, a subtask of T320525: Column labels standardization, as Resolved.
Jul 18 2023, 2:28 PM · Equity-Landscape
ntsako closed T332726: Update the metric descriptions of hive tables as Resolved.
Jul 18 2023, 2:28 PM · Equity-Landscape
ntsako added a comment to T332726: Update the metric descriptions of hive tables.

Done.

Jul 18 2023, 2:28 PM · Equity-Landscape

Jul 10 2023

ntsako added a comment to T338137: spark3 in yarn master mode exhibits warnings when the HDFS namenodes are in the failed over state.

I also experienced similar issues to the one above.

Jul 10 2023, 11:16 AM · Data-Platform-SRE, Data-Engineering

Jul 5 2023

ntsako closed T330897: 2022 - Social Progress index as Resolved.
Jul 5 2023, 2:55 PM · Equity-Landscape
ntsako closed T330897: 2022 - Social Progress index, a subtask of T306625: Extract + Transformation Raw Data into Input Metrics, as Resolved.
Jul 5 2023, 2:55 PM · Equity-Landscape
ntsako closed T329149: grants data column rename as Resolved.
Jul 5 2023, 2:38 PM · Equity-Landscape
ntsako added a comment to T329149: grants data column rename.

Data updated in production

Jul 5 2023, 2:38 PM · Equity-Landscape

Jun 29 2023

ntsako closed T338120: Update country_meta_data columns as Resolved.
Jun 29 2023, 2:16 PM · Equity-Landscape
ntsako added a comment to T338120: Update country_meta_data columns.

@JAnstee_WMF The table itself has been migrated to prod. I'll close this task and you can ping me to run the update for the new workbook in prod as well under gdi.country_meta_data

Jun 29 2023, 2:15 PM · Equity-Landscape

Jun 28 2023

ntsako moved T305474: Milestone: Transformation Definitions Complete: from In Development to Up Next on the Equity-Landscape board.
Jun 28 2023, 3:47 PM · Equity-Landscape
ntsako moved T305473: Milestone: Input Data Models Complete. from In Development to Up Next on the Equity-Landscape board.
Jun 28 2023, 3:47 PM · Equity-Landscape

Jun 23 2023

ntsako removed projects from T329185: Access output metrics: Data Pipelines, Data-Engineering-Planning.
Jun 23 2023, 12:32 PM · Equity-Landscape
ntsako moved T330295: 2022 - Affiliates input metrics from In QA Review to Pending Deploy on the Equity-Landscape board.
Jun 23 2023, 12:28 PM · Equity-Landscape
ntsako moved T329149: grants data column rename from In QA Review to Pending Deploy on the Equity-Landscape board.
Jun 23 2023, 12:28 PM · Equity-Landscape
ntsako moved T332726: Update the metric descriptions of hive tables from In Code Review to Pending Deploy on the Equity-Landscape board.
Jun 23 2023, 12:11 PM · Equity-Landscape
ntsako moved T338120: Update country_meta_data columns from In Code Review to Pending Deploy on the Equity-Landscape board.
Jun 23 2023, 12:11 PM · Equity-Landscape

Jun 21 2023

ntsako added a comment to T338338: Freedom Inputs, transformations, and outputs.

Expected output

Jun 21 2023, 2:45 PM · Equity-Landscape
ntsako removed a project from T330897: 2022 - Social Progress index: Data-Engineering.
Jun 21 2023, 2:12 PM · Equity-Landscape
ntsako removed a project from T309279: Population input metrics: Data-Engineering.
Jun 21 2023, 2:12 PM · Equity-Landscape
ntsako removed a project from T306624: Population output rank metrics: Data-Engineering.
Jun 21 2023, 2:12 PM · Equity-Landscape
ntsako removed a project from T324968: Access input metrics: Data-Engineering.
Jun 21 2023, 2:12 PM · Equity-Landscape
ntsako removed a project from T330295: 2022 - Affiliates input metrics : Data-Engineering.
Jun 21 2023, 2:12 PM · Equity-Landscape
ntsako removed a project from T338120: Update country_meta_data columns: Data-Engineering.
Jun 21 2023, 2:12 PM · Equity-Landscape
ntsako removed a project from T305474: Milestone: Transformation Definitions Complete:: Data-Engineering.
Jun 21 2023, 2:11 PM · Equity-Landscape
ntsako removed a project from T306614: Transformations Flowchart: Data-Engineering.
Jun 21 2023, 2:11 PM · Movement-Insights, Equity-Landscape
ntsako removed a project from T305473: Milestone: Input Data Models Complete.: Data-Engineering.
Jun 21 2023, 2:10 PM · Equity-Landscape
ntsako removed a project from T306625: Extract + Transformation Raw Data into Input Metrics: Data-Engineering.
Jun 21 2023, 2:10 PM · Equity-Landscape
ntsako removed a project from T305475: Milestone: Ingest and Transform Input Data: Data-Engineering.
Jun 21 2023, 2:10 PM · Equity-Landscape
ntsako removed a project from T305468: Deploy the GDI Equity Landscape Dashboard : Data-Engineering.
Jun 21 2023, 2:10 PM · Epic, Equity-Landscape
ntsako removed a project from T305481: Milestone: Publish the Dashboard!: Data-Engineering.
Jun 21 2023, 2:10 PM · Equity-Landscape
ntsako removed a project from T305478: Milestone: Data Visualization Table Views defined: Data-Engineering.
Jun 21 2023, 2:09 PM · Equity-Landscape
ntsako removed a project from T305479: Milestone: Dashboard Template Complete: Data-Engineering.
Jun 21 2023, 2:09 PM · Equity-Landscape
ntsako removed a project from T305480: Milestone: Create and Publish Data Visualisation Views:: Data-Engineering.
Jun 21 2023, 2:09 PM · Equity-Landscape
ntsako removed a project from T305476: Milestone: Dashboard Mockup Complete: Data-Engineering.
Jun 21 2023, 2:09 PM · Equity-Landscape
ntsako claimed T338338: Freedom Inputs, transformations, and outputs.
Jun 21 2023, 11:35 AM · Equity-Landscape
ntsako moved T338338: Freedom Inputs, transformations, and outputs from Up Next to In Development on the Equity-Landscape board.
Jun 21 2023, 10:12 AM · Equity-Landscape
ntsako moved T338338: Freedom Inputs, transformations, and outputs from In Development to Up Next on the Equity-Landscape board.
Jun 21 2023, 10:12 AM · Equity-Landscape
ntsako moved T338338: Freedom Inputs, transformations, and outputs from Up Next to In Development on the Equity-Landscape board.
Jun 21 2023, 10:11 AM · Equity-Landscape

Jun 19 2023

ntsako claimed T338339: Programs Inputs, Transformation, & Outputs.
Jun 19 2023, 11:22 AM · Equity-Landscape
ntsako moved T338339: Programs Inputs, Transformation, & Outputs from Up Next to In Development on the Equity-Landscape board.
Jun 19 2023, 11:21 AM · Equity-Landscape

Jun 15 2023

ntsako moved T338120: Update country_meta_data columns from Bugs, Errors, or other Issues to In Code Review on the Equity-Landscape board.
Jun 15 2023, 10:29 AM · Equity-Landscape

Jun 8 2023

ntsako added a comment to T309279: Population input metrics.

Data loaded in production

Jun 8 2023, 1:49 PM · Equity-Landscape
ntsako added a comment to T330897: 2022 - Social Progress index.

Data loaded in production

Jun 8 2023, 1:49 PM · Equity-Landscape

Jun 5 2023

ntsako added a comment to T338120: Update country_meta_data columns.

I have update ntsako.country_meta_data, please sign-off if everything is in order.

Jun 5 2023, 8:38 AM · Equity-Landscape
ntsako reassigned T338120: Update country_meta_data columns from ntsako to JAnstee_WMF.
Jun 5 2023, 8:36 AM · Equity-Landscape
ntsako moved T338120: Update country_meta_data columns from Backlog to In QA Review on the Equity-Landscape board.
Jun 5 2023, 8:36 AM · Equity-Landscape
ntsako created T338120: Update country_meta_data columns.
Jun 5 2023, 8:35 AM · Equity-Landscape

May 31 2023

ntsako moved T333457: Expose gdi schema as a production schema on DataHub from Up Next to In Development on the Equity-Landscape board.
May 31 2023, 11:05 AM · Equity-Landscape
ntsako moved T323007: Heatmap overlay for Table from Up Next to In QA Review on the Equity-Landscape board.
May 31 2023, 11:04 AM · Equity-Landscape
ntsako moved T305475: Milestone: Ingest and Transform Input Data from In Development to Up Next on the Equity-Landscape board.
May 31 2023, 10:46 AM · Equity-Landscape
ntsako moved T306625: Extract + Transformation Raw Data into Input Metrics from In Development to Up Next on the Equity-Landscape board.
May 31 2023, 10:46 AM · Equity-Landscape
ntsako moved T332726: Update the metric descriptions of hive tables from In QA Review to In Code Review on the Equity-Landscape board.
May 31 2023, 10:46 AM · Equity-Landscape

May 29 2023

ntsako moved T329185: Access output metrics from In QA Review to Pending Deploy on the Equity-Landscape board.
May 29 2023, 1:27 PM · Equity-Landscape
ntsako moved T330897: 2022 - Social Progress index from In QA Review to Pending Deploy on the Equity-Landscape board.
May 29 2023, 1:22 PM · Equity-Landscape
ntsako moved T309279: Population input metrics from In QA Review to Pending Deploy on the Equity-Landscape board.
May 29 2023, 1:19 PM · Equity-Landscape
ntsako moved T306624: Population output rank metrics from In QA Review to Pending Deploy on the Equity-Landscape board.
May 29 2023, 1:19 PM · Equity-Landscape
ntsako moved T324968: Access input metrics from In QA Review to Pending Deploy on the Equity-Landscape board.
May 29 2023, 1:19 PM · Equity-Landscape
ntsako moved T323003: Add data vizualizations to the EL dashboard from In Development to In QA Review on the Equity-Landscape board.
May 29 2023, 1:15 PM · Equity-Landscape
ntsako reassigned T337334: country_meta_data table needs update from ntsako to JAnstee_WMF.
May 29 2023, 1:14 PM · Product-Analytics, Equity-Landscape
ntsako added a comment to T337334: country_meta_data table needs update.

Hi @JAnstee_WMF please note that this has been loaded.

May 29 2023, 1:14 PM · Product-Analytics, Equity-Landscape
ntsako moved T337334: country_meta_data table needs update from In Development to In QA Review on the Equity-Landscape board.
May 29 2023, 1:13 PM · Product-Analytics, Equity-Landscape
ntsako moved T333533: Rich text visualizer (Cards) from In Development to In QA Review on the Equity-Landscape board.
May 29 2023, 1:13 PM · Equity-Landscape
ntsako moved T333532: Barchart (Horizontal) from In Development to In QA Review on the Equity-Landscape board.
May 29 2023, 1:12 PM · Equity-Landscape
ntsako moved T323004: World Map (Heat map) from In Development to In QA Review on the Equity-Landscape board.
May 29 2023, 1:12 PM · Equity-Landscape
ntsako moved T314946: JSON outputs of final data tables from In Development to In QA Review on the Equity-Landscape board.
May 29 2023, 1:12 PM · Equity-Landscape
ntsako moved T323005: Treemap Chart from In Development to In QA Review on the Equity-Landscape board.
May 29 2023, 1:12 PM · Equity-Landscape
ntsako moved T323006: Barchart (Multi-column) from In Development to In QA Review on the Equity-Landscape board.
May 29 2023, 1:12 PM · Equity-Landscape
ntsako updated Other Assignee for T314946: JSON outputs of final data tables, removed: KCVelaga_WMF.
May 29 2023, 1:12 PM · Equity-Landscape

May 24 2023

ntsako moved T337334: country_meta_data table needs update from Bugs, Errors, or other Issues to In Development on the Equity-Landscape board.
May 24 2023, 3:19 PM · Product-Analytics, Equity-Landscape
ntsako added a comment to T332726: Update the metric descriptions of hive tables.

The year partition column comment needs to be

May 24 2023, 2:47 PM · Equity-Landscape