[ Resolved ] Azure Data Factory - Expected EOF, found '*' at 8 - DevDummy

Latest

Views | Thoughts | Concepts | Techniques

Wednesday, October 14, 2020

[ Resolved ] Azure Data Factory - Expected EOF, found '*' at 8

Error Message

Expected EOF, found '*' at 8

When trying to preview the dataset in edit mode.

Cause of the issue


@ prefix on the dynamic query section with generic SQL query

@SELECT * FROM Books WHERE bookid = pipeline().parameters.validBookId

How it happens

When adding a dynamic content such as a parameter, variable, system variable, or a function by selecting them from a list, it is adding the placeholder in the cursor location but '@' as a prefix to the existing string.

Resolution

Update the dynamic value with the format of '@{<dynamic_value>}' to take the String representation of the value.

Example : SELECT * FROM Books WHERE bookid = @{pipeline().parameters.validBookId}

Note: 

@pipeline().parameters.validBookId -> gives numerical value
@{pipeline().parameters.validBookId} -> gives string value

Reference: https://docs.microsoft.com/en-us/azure/data-factory/control-flow-expression-language-functions

...







No comments:

Post a comment