79414546

Date: 2025-02-05 11:17:33
Score: 2.5
Natty:
Report link

Looks like the issue is with how the dynamic query is being formed in ADF. The error 'The template function 'iem' is not defined or not valid' suggests there might be a syntax issue in your expression. Make sure you're properly escaping the double quotes in your dynamic query. Try using @concat('"', variables('schema'), '"."', variables('table'), '"') to explicitly wrap the schema and table names in double quotes. Also, verify that there are no extra spaces or unexpected characters in the variable values. If you're using @{} syntax, double-check that all functions and variables are correctly referenced.

Reasons:
  • Long answer (-0.5):
  • No code block (0.5):
  • User mentioned (1): @concat
  • Single line (0.5):
  • Low reputation (1):
Posted by: Douglas Henrique