Hi, i am trying to pass catalog name as a parameter into query for sql task, and it pastes it with single quotes, which results in error. Is there a way to pass raw value or other possible workarounds?
query:
INSERT INTO {{ catalog }}.pas.product_snapshot
SELECT ...
task parameters
{ "catalog": "dev" }
error message:
[PARSE_SYNTAX_ERROR] Syntax error at or near ''dev''.(line 1, pos 12) == SQL == INSERT INTO 'dev'.pas.product_snapshot SELECT ...
Thanks!