In both the usage_with_cost and most_recent_jobs CTEs, one of the filter condition in the WHERE sub-clause is the following:-
if(
:param_workspace = '<ALL WORKSPACES>',
true,
workspace_id = :param_workspace
)The problem with this is, workspace_id expects a BIGINT but when we select a workspace from the dashboard it passes the workspace_name, not the workspace_id. Therefore, the Highest Failure Jobs visual in the Operational Observability tab renders with a TYPE_MISMATCH error. It explicitly says that STRING type can't be type-casted to BIGINT.
In both the
usage_with_costandmost_recent_jobsCTEs, one of the filter condition in theWHEREsub-clause is the following:-The problem with this is,
workspace_idexpects aBIGINTbut when we select a workspace from the dashboard it passes theworkspace_name, not theworkspace_id. Therefore, theHighest Failure Jobsvisual in theOperational Observabilitytab renders with aTYPE_MISMATCHerror. It explicitly says thatSTRINGtype can't be type-casted toBIGINT.