Pass catalog/schema/table name as a parameter to sql task

[EdemSeitkh]

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! 

[EdemSeitkh · Accepted solution]

workaround that worked for me was to create databricks sql query, add enum parameter and use that query in task, instead of git file. 

[jeroaranda]

dropdownlist works well, however it doesnt work when i do a dynamic parameter like {{task.name}}.

Any one got a solution?

[shan_chandra]

@EdemSeitkh  -  you may need to populate in a single quote -'{{ catalog }}'.  Hopefully, you had created a sql query in DBSQL query editor and it will provide the parameters to populate in the UI itself like below example. 

[EdemSeitkh]

@shan_chandra yes, i have created with DBSQL query and it worked fine. Previously it was using direct file from git and had this issue i described. 

[lathaniel]

@EdemSeitkh  can you elaborate on your workaround? Curious how you were able to implement an enum paramter in DBSQL.

I'm running into this same issue now.

[detom]

This works 

USE CATALOG IDENTIFIER({{ catalog_name }});
USE SCHEMA IDENTIFIER({{ schema_name }});