Hi @Sujatha Pillai​ 

You can try using the below SQL code using widgets

CREATE WIDGET TEXT pathname DEFAULT "pathvalue"
 
CREATE OR REPLACE TEMPORARY VIEW abc_delivery_log
USING CSV
OPTIONS (
 header="true",
 delimiter=",",
 inferSchema="true",
 path = getArgument('pathname')
);

and using widgets you can pass the variable value

Happy Learning!!