Searching a table should expand the schema

[gaganyadav80]

1. Search a table
2. The schema is filtered but I have to manually expand it to see the matched results

Recording:

Screen.Recording.2025-01-20.at.11.13.13.mov

[invisal]

We need to balance when to auto expand when not to auto expand. For example, if you type only one character "a", it could match with a lot of tables if you have a lot of schema.

• Option 1: If there is more than 3 characters, all the search should auto expand
• Option 2: If there is only one schema left, it should auto expand

Or if you have any particular approach dealing with this

[gaganyadav80]

I think Option 1 sounds good. The option 2 will be covered with the first one as well because once 3 or more characters are typed and there is a single match it should be auto expanded.