Unable to reference in databricks resource query

Queries and Resources
,
1

In databricks resource query, when I'm running below query, its returning null.
SELECT * FROM operations.store.trigger_jira_raw WHERE issue_key IN ( {{concatenatedKeys}} )

but when I'm running this query below, its returning proper data for these issue keys.
SELECT * FROM operations.store.trigger_jira_raw WHERE issue_key IN ('SCO-2549', 'SCO-1843', 'SCO-1844', 'SCO-16164', 'SCO-16112', 'SCO-16113', 'SCO-16136', 'SCO-9562', 'SCO-16244', 'SCO-16222', 'SCO-16256', 'SCO-16300')

Value stored in concatenatedKeys is "'SCO-2549', 'SCO-1843', 'SCO-1844', 'SCO-16164', 'SCO-16112', 'SCO-16113', 'SCO-16136', 'SCO-9562', 'SCO-16244', 'SCO-16222', 'SCO-16256', 'SCO-16300'"

Can someone help here?

2

Hey @shourya.mehta!

Does using the following work for you?

SELECT * FROM operations.store.trigger_jira_raw WHERE CONTAINS({{concatenatedKeys}}, issue_key)

A slightly more complex but precise method might be:

SELECT * FROM operations.store.trigger_jira_raw WHERE ARRAY_CONTAINS(SPLIT({{concatenatedKeys}}, ','), city)
1 Like
3