Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-25-2026 06:03 AM
Hi @Daniel_dlh,
No problem. Glad it works.
That quoting is expected. SQL task parameters are bound as values, so string params are always inserted as '...' literals. You can’t turn that off, but you can work around it by using IDENTIFIER() and building a full name as a string.
For example, instead of:
SELECT *
FROM {{ catalog }}.schema.table;
do:
SELECT *
FROM IDENTIFIER({{ catalog }} || '.schema.table');
with catalog = my_catalog in your parameters. The engine sees IDENTIFIER('my_catalog.schema.table'), which is valid and resolves to the correct object.
Let me know if that works.
If this answer resolves your question, could you mark it as “Accept as Solution”? That helps other users quickly find the correct fix.
Regards,
Ashwin | Delivery Solution Architect @ Databricks
Helping you build and scale the Data Intelligence Platform.
***Opinions are my own***
Ashwin | Delivery Solution Architect @ Databricks
Helping you build and scale the Data Intelligence Platform.
***Opinions are my own***