ADF If Condition expression Cannot fit ''until_dbt_job_finish_or_error'' into the function parameter 'dbt_statuscheck'.(6)

JB 106 Reputation points
2024-07-11T19:40:28.4233333+00:00

I have see these squiggly red lines in my If Expression under 'until_dbt_job_finish_or_error' and when I hover over it says "Cannot fit ''until_dbt_job_finish_or_error'' into the function parameter 'dbt_statuscheck'.(6)" The pipeline calls a dbt cloud job, then monitors that job for completion. The If Condition is to force fail the pipeline if the dbt job is cancelled or fails or the until monitor times out. The pipeline seems to execute without error having tested by forcing a timeout and cancelling a dbt job run and having an error in the dbt job run.

Does anyone know how to fix the squiggly lines? I don't think it is a datatype issue as they are all text.

Thank you for your help.User's image

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,881 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Bhargava-MSFT 31,121 Reputation points Microsoft Employee
    2024-07-11T20:27:48.14+00:00

    Hello JB,

    can you try simplifying the expression to just check for the Timeout status of the until_dbt_job_finish_or_error activity

    @equals(activity('until_dbt_job_finish_or_error').status, 'Timeout')

    If the simplified expression works without errors, proceed to reintroduce the or function and the contains check.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.