hi @Marostegui @Ladsgroup

regarding wb_terms new schema changes and migration plan (context T221764) .. I got informed by @Addshore that replication from production to labs (for tools) for the new tables might require some manual change so that those tables are included in replication.

Is there a documentation or a place where I can look to know what that change may look like?
Is this something we have to do (wb_terms team in wmde)?

For replication to labs, you need cloud services team (@Bstorm and @Andrew ) to update the views (which first needs a patch in puppet in modules/profile/templates/labs/db/views/maintain-views.yaml) then gets by cloud services team but I think the tables need to at least exist in production.

@alaa_wmde the new tables (and all its columns) will get replicated to labs unless specified otherwise, however, as @Ladsgroup points out, to actually be able to query data, you need to have the views created.
So first step would be to confirm if all the tables and all its columns should be replicated or if we need to filter things out?
This can be a good start:
https://wikitech.wikimedia.org/wiki/Portal:Data_Services/Admin/Wiki_Replicas#Step_1:_sanitization
https://wikitech.wikimedia.org/wiki/Labsdb_redaction

Thanks for the elaborate response @Ladsgroup and @Marostegui

As far as I can see, wb_terms is listed in https://github.com/wikimedia/puppet/blob/production/modules/profile/templates/labs/db/views/maintain-views.yaml#L138, and there does not seem to be any column filtering setup on it in https://phabricator.wikimedia.org/source/operations-puppet/browse/production/modules/role/files/mariadb/filtered_tables.txt.

This means our new schema tables will as well be configured to copy, without any column filtering, at least for the beginning.

I'll create a patch for the views for now, and will pass the filtering topic through the team to check before we go live

Yeah, wb_terms is replicated as is.