I think you can try this.

Please try adding a space between the Curly brackets "{ { param_name } } "

1. select EOWinventory
2. from snapshot.weekly_inventory_status
3. where Monday_Date = '{{projection_date}}' group by Monday_Date

Can you try this

This was the issue! I wasn't calling it from the sql editor. Thank you!

You do have to put a space between the brackets on either side of the parameter and it should work

{{ schema_name }}

SELECT * FROM {{ schema_table_name }}

Databricks requires that you wrap date and time values in single quotes (')

SELECT *

FROM usage_logs

WHERE date = '{{ date_param }}'

Hello @User16756723392331126896 (Customer)​ ,

I tried this out, I was able to get the text query parameter by default which I changed to date by clicking on the gear button.

Here are a few things -

In mac I typed Control + P (not Command + P)

When I tried your query, it actually still did not give me a date parameter, but it was text, I clicked on the gear button and changed it to date from drop down.

Using double quotes seems to have solved it.

I know the document needs update and I will get that going but I hope this helps.

In case it does, please select it as the answer that resolved your issue and let me know if you still face any issue.

Thanks &. Regards,

Nandini

I don't see the need for spaces around the parameter name...

I have just been typing {{param_name}} and it appears automatically in SQL editor

Correct, that was an older workaround, which is now fixed in the later versions, sorry about that.

@Brian Labrom​ if my answer helps, it would be great if you could upvote it or mark is at Best answer to close the loop.