Azure Data Factory - If Condition only run on specific hours
I'm trying to build a control flow in ADF pipeline where an If Condition should only run on specific hours of the day. The pipeline has a trigger that runs every hour, but because of run limitations in the external system, this system should only be called at 6, 8, 10, 12 and so on during the day.
In SQL I would do something like CASE WHEN DATEPART(HOUR, GETDATE()) IN (6,8,10,12) THEN 1 ELSE 0
I fully believe there is a way to construct such an expression in "dynamic content", but I really don't know where to being. Should the hours be there written in an variable array or directly in the expression?
Thanks in advance!
I think your requirement could be implemented with built-in expression supported by ADF.
Please try configure Dynamic content in the If-condition Activity as below:
@contains('06081012',substring(formatDateTime(utcnow()),11,2))
- How to trigger implicit pointer conversion inline in a C macro?
- make a portion of ggplot legend bold
- Combining or appending to pyarrow.dataset.expressions
- Different output on GCC and on Visual Studio
- Use expression with a variable r
- `quote()` and `call()`: How to distinguish between both outputs?
- Difference between an Expression and Statement in Dart?
- EF Error: The LINQ expression could not be translated. Occurs with generated Expression, not with code
- Generic expression to find partial string matches against dynamic list of fields in LINQ query
- Power Automate, get the max/biggest value from an output array
- Scope of identifiers in R formulas/expressions
- LinqKit pass variable into Expression
- How to mark a parameter with an attribute in a dynamically created Lambda Expression?
- Python - write symbolic expression (sympy) to txt file
- Reorder SymPy Expression
- How to split a long regular expression into multiple lines in JavaScript?
- Java Split a String with coma or 0(zero) followed by a whitespace
- Does python throw away unused expressions?
- SSRS report with expression error of "cannot convert to string"
- How to Convert a List of Unevaluated Expressions into a List of Expression Objects in R
- How can I pass an expression to use in a SQLAlchemy filter or where clause around?
- How to make a superscript expression in ggplot2 legend
- Excluding NULL column datasets in Doctrine query
- Nested IF ELSE in a derived column
- Get all the defined mappings from an AutoMapper defined mapping
- SSIS expression: convert date to string
- What is the "with" operator for in C#?
- Regex: 1 number or 2 numbers
- Creating Array of Arrays in Azure Data Factory
- Is there any C function that can evalute a string expression defined in the standard library?