Write rows to DB as soon as they go through Alteryx process

[alts2h]

Hi all,

I'm facing a problem with Output Tool...

I'm trying to write rows to database as soon as they go through Alteryx process.

Here is my test workflow:

While I run this workflow, I'm running the following SQL statement on DB.

select * from test (which is the table I'm writting in).

Here is what I get:

After 2 sec: no row

After 4 sec: no rows

After 6 sec: All 3 rows

And here is what I'd like to get:

After 2 sec: 1 row

After 4 sec: 2 rows

After 6 sec: All 3 rows

Any suggestion?

Thanks a lot!