How to replace ${param} by :param

ZD
New Contributor III

Hello,

We previously used ${param} in our SQL queries:

SELECT * FROM json.`${source_path}/file.json`

However, this syntax is now deprecated. The recommended approach is to use :param instead.

param.PNG

But when I attempt to replace ${param} with :param, I encounter the below error:

SELECT * FROM json.`:source_path/file.json`

java.net.URISyntaxException: Relative path in absolute URI: :source_path/file.json

How can I correctly reference the parameter in this case?