Delete "clusters_by_authorized_accounts" table
Nobody has claimed this yet.
- Dominant language
- Go
- Stars
- 218
- Forks
- 72
- Avg merge
- 1d 12h
- Merged PRs (30d)
- 427
Description
Description
The cluster_by_cluster_id already has authorized_nca_id with exactly the same type and values as clusters_by_authorized_accounts (confirmed in prod) so we don't need to crate a new column and migrate data, just add index.
- Add SAI index on a new column
- Switch reads to a new column
- Code clean up
Details
CREATE CUSTOM INDEX idx_cluster_by_auth_ids ON cluster_by_cluster_id (authorized_nca_ids) USING 'StorageAttachedIndex';
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by locating references to the clusters_by_authorized_accounts and cluster_by_cluster_id tables, then inspect the schema and read paths that use them. Confirm the existing authorized_nca_id values and the proposed authorized_nca_ids SAI index. Done means reads use the new indexed column and the old table and related code are removed.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- cassandra, go
- Domain
- databases
- Issue type
- Refactor
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Quiet
- Clarity
- Mostly clear
- Newbie friendliness
- 48/100