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?
Hi @ZD
Please try this syntax in Your notebook for SQL:
%sql
declare _my_path = 'some_path';
select _my_path;
Hi @ZD ,
But it does, you can use it in following way. Define 3 parameters:
- file_format
- base_path
- file_name
And then concatenate those parameters inside identifier clause:
SELECT *
FROM identifier(:file_format || :base_path || :file_name)
Or maybe I didn't understand your requirments properly.
