I want to run a parametrized sql query in a task. Query:
select * from {{client}}.catalog.table
with client value being {{task.name}}.
if client is a string parameter, it is replaced with quotes which throws an error.
if table is a dropdown list parameter, it throws: The following parameter values are invalid: [{'key': 'client', 'value': 'randomclient'}].
How can I solve?