Hi @sathyafmt ,

Are you using Serverless SQL Warehouse?
It seems accessing Volumes in Serverless SQL Warehouse is not implemented yet.

When running the code in SQL Warehouse I am getting the same error as you:

When running in notebook, it works just fine

Could you check whether you can create a table and it reads from the directory?

CREATE TABLE my_json_table
USING json
OPTIONS (
  path '/Volumes/my_catalog/my_schema/jsondir/test.json',
  multiline 'true'
);

 When running this using SQL Serverless Warehouse I got an error:

Then when trying to enable volumes I got an error:

To sum up I believe as of now in Serverless SQL Warehouse volumes are not supported.