Page MenuHomePhabricator

Update country_meta_data columns
Closed, ResolvedPublic

Description

Update the binary column to be inline with current standards as per T318850

Event Timeline

ntsako moved this task from Backlog to In QA Review on the Equity-Landscape board.
ntsako added a project: Data-Engineering.

Hi @JAnstee_WMF,

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

@ntsako I missed a final comment on our column naming input from Product Analytics (T318850: Provide recommendations for Regional data) where they wanted us to add the prefix "is_" to our last four column headers in the country_meta_data table.
it would include changing:
imf_country TO is_imf_country,
pwt_country TO is_pwt_country
un_country TO is_un_country
world_bank_country TO is_world_bank_country

This is consistent with binary column naming conventions for this type of data column.

I quickly updated these in the root file so you can update on hive

Reassigning to you and placing in out fixes column

JAnstee_WMF triaged this task as High priority.
JAnstee_WMF added a project: Movement-Insights.
JAnstee_WMF subscribed.

@ntsako Signing off on the change implemented!

Link to workbook

@ntsako Awaiting word on one additional association change and will ping once I have an answer so it can be included in this next push

@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