Databricks Community

EdemSeitkh · 01-23-2024

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_snap...

EdemSeitkh · 01-24-2024

@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.

EdemSeitkh · 01-23-2024

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

Databricks Community

User Stats

User Activity

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

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

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