How to pass task name as parameter in scheduled job that will be used as a schema name in query

jeroaranda — Thu, 30 May 2024 00:21:49 GMT

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?

Re: How to pass task name as parameter in scheduled job that will be used as a schema name in query

Zach_Jacobson23 — Fri, 22 Nov 2024 16:22:38 GMT

Try this:

select * from identifier(:catalog||'.schema.table')

The :catalog is a parameter within DBSQL

Replace schema and table with actual names

topic Re: How to pass task name as parameter in scheduled job that will be used as a schema name in query in Data Engineering

How to pass task name as parameter in scheduled job that will be used as a schema name in query

Re: How to pass task name as parameter in scheduled job that will be used as a schema name in query