Hello all,

This is a follow-up on previous announcements related to the migration of wb_terms table (March 23rd https://www.wikidata.org/wiki/Wikidata:Project_chat/Archive/2020/03#Important_for_tool_maintainers:_last_steps_of_wb_terms_table_migration, April 6th https://www.wikidata.org/wiki/Wikidata:Project_chat/Archive/2020/04#wb_terms_table_will_be_empty_today) that concerns tool developers querying the database replicas on Labs.

As the last step of the migration, and as mentioned in the previous discussions, the table wb_terms_no_longer_updated will be dropped. We are doing this because the last steps of database migration have been achieved and announced a month ago, and we don’t want to keep a table containing outdated information accessible for too long. The table has already been deleted in production (without any impact on tools or users) and the replicas on Labs will be deleted on April 29th. (Ticket https://phabricator.wikimedia.org/T248086)

If you’re maintaining tools querying the database with the replicas, you can adapt your code to the new table structure https://doc.wikimedia.org/Wikibase/master/php/md_docs_storage_terms.html (the former shared link doesn't work anymore). You can also have a look at suggestions to optimize your queries https://www.wikidata.org/wiki/User:Amir_Sarabadani_(WMDE)/Database_normalization.

If you have any questions or issues, feel free to reach out to me. Thanks for your understanding,