![[ Resolved ] Azure Data Factory - Expected EOF, Found '*' At 8](https://cdn.blogarama.com/images/posts_thumbs_site_id/12949/1294899-2762501754.jpg "[ 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 '@{} ' 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
