Slow query.
Why is the query below taking so long?
This slows down the Data Flow.
When looking at the package you will see that the speed is faster
select sim.opportunityid,sim.csh_origem,sim.csh_mktcanal,sim.csh_term,sim.csh_mktcampanha,sim.csh_urlcampanha
from opportunity as sim where sim.csh_simulacaoparceiro = False and sim.createdon >= datetime('now', 'localtime','-3 days')