Catalog indexers should remove records related to dataset , dataset tables when not in DB
Is your idea related to a problem? Please describe.
Catalog indexer currently works by looping through all the dataset , then its tables , folders, etc. Suppose if the dataset was deleted but all its tables are already present in the RDS dataset_table table Or if they are deleted, then the re-indexer task doesn't delete all the deleted tables
Describe the solution you'd like Catalog indexer should not only check and update indexer for items on the dataset's which are present, but also should be able to delete items which are present in Catalog index but the corresponding item is not present in RDS database
P.S. Don't attach files. Please, prefer add code snippets directly in the message body.
This is handled by starting a re-indexer task from the Admin Menu