Query filter among Favorites not returning some favorite queries

[alm958]

Query filter among Favorites not returning some favorite queries. When I search among My queries, they are returned and show as being Favorites.  But they do not show up in results when I limit search to Favorites.  This seems to be new behavior in the last month or two and I did not experience this previously.

[savlahanish27]

This looks like a known inconsistency in how the Favourites filter works in Databricks SQL - you're not doing anything wrong.

What's likely happening: the Favourites filter in the query browser uses a different lookup than the star/favourite flag shown in "My queries." If a query was favourited before a recent workspace update, the flag may not have carried over correctly to the new filter index.

A few things worth trying:

• Un-favourite and re-favourite the affected queries - this forces a fresh write to the favourites index and often resolves the mismatch
• Check if the missing queries are ones, you own vs ones shared with you - there's been inconsistency with how favourited shared queries appear under the Favourites filter specifically
• If you're on a shared workspace, confirm whether the behaviour is the same across users or just your account

[Louis_Frolio]

Greetings @alm958 , I did some digging and here are some suggestions.

Thanks for flagging this. From what you described, this doesn't look like expected Databricks SQL behavior.

The clue is that the same queries still show up under My queries as favorited. That points toward a mismatch in the Favorites filter rather than a problem with the queries themselves. I can't confirm the exact root cause from public documentation, so I'd hold off on treating any single explanation as settled. My best read is that this is a UI or indexing quirk, not anything you did wrong.

A few things worth trying, roughly in order:

1. Un-favorite and then re-favorite one of the affected queries, then refresh.
2. Check whether the missing items are older favorites.
3. Check whether the missing queries are ones you own or ones shared with you.
4. Do a hard refresh, or try a fresh browser session, to rule out cached state.
5. See whether another user in the same workspace runs into the same thing.

If your workspace still exposes more than one query-listing experience, compare the behavior across them. If they disagree, that's another sign the issue sits on the product side rather than with the query.

If re-favoriting doesn't fix it, I'd open a Databricks support case and include:

1. the name or query ID of an affected query
2. a screenshot showing it under My queries but missing under Favorites
3. your workspace cloud and region
4. whether this happens for multiple users in the same workspace
5. a HAR capture taken while you reproduce the issue, if you can grab one

So, short version: you're probably not doing anything wrong. Run the quick re-favorite test, and if it sticks around, it's worth escalating.

Cheers, Louis.