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