Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Trying to load from a Redshift stored procedure.
I have done this before successfully.
You make a first call that populated a temp table on the source DB
Then a 2nd call to read the results from that temp table.
call:
SQL call myprocedure_sp('results');
actuals:
SQL Select * from results;
However, this case is different.
There is statement in the SQL : drop table if exists #mytemp;
Redshift naturally produces a warning here : Table "#mytemp" does not exist and will be skipped
All my other clients don't care about this, it is only a "Warning", but QlikSense does care.
@simonB2020 I don't have a way to try this out, but I am wondering if you can do something with ErrorMode and ScriptError here. Perhaps set ErrorMode to 0 so that it does not halt processing and then you examine ScriptError and decide what you want to do next?
Thanks , I tried paying with "ErrorMode" but not joy.
Resorted to a SQL side fix for now.
Tks