How to replace ${param} by :param
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-22-2025 08:02 PM
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.
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?