Missing workspaces in workspaces_latest but present in audit

Danish11052000
Contributor

While validating workspace coverage, we observed that some workspace_id exist in system.access.audit but return NULL in system.access.workspaces_latest.

 
 
select distinct a.workspace_id, w.workspace_name
from system.access.audit a
left join system.access.workspaces_latest w
on w.workspace_id = a.workspace_id
where w.workspace_name is null;​



Is there a known reason behind this behavior?
Would really appreciate it if anyone is aware and can share insights.