I am creating a view with parameter eg

Set id=1

create or replace view viewname as select * from table where col1=$id

and calling this view in streamsets  in jdbc query consumer by defining session variable eg

set I’d=1;

select * from viewname;

but streamsets is giving error as session variable does not exist

i guess it is considering two different session for above statement I also tried removing colon from set statement but no luck 

Any suggestions will help 

thank you