Skip to content

Issue in the [Operational Observability] Highest Failure Jobs dataset in LakeFlow System Tables Dashboard v0.1.lvdash.json #29

Description

@pradipbasak

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.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions