Add organization_id as sharding key for authentication_events table.
Add org_id as sharding key for authentication_events table
Background
Investigation in #553447 (closed) revealed that not all events in the authentication_events table have an associated user_id. Therefore, org_id has been identified as a more suitable sharding key.
Goal
Add organization_id as the sharding key for the authentication_events table to improve data distribution and query performance.
Tasks
-
Add org_id column as sharding key -
Verify data distribution
Related Issues
Edited by Aboobacker MK