community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

In-Databse Streaming out - Any way to check status?

Highlighted
Asteroid

As part of a process I run I am pulling in a large dataset from Hadoop and then streaming to my local machine to write to a SQL database.  The streaming out portion of the flow is what takes the longest amount of time by far.

 

Is there a way to check the status of that step?  I was hoping to be able to see a percentage complete for instance.

 

Thanks!

 

Alteryx
Alteryx

@rhyatt

 

I don't think that you can get a percentage complete, because the In-DB tools don't necessarily assess the size of the table before acting on it.  However, I have found that if I go into the DSN via ODBC Administrator and Configure -> Advanced Options -> Rows fetched per block to some comparatively small number, then when I run a workflow, the Connection Progress will update periodically as the stream progresses.  This does assume that you have the Workflow Configuration -> Connection Progress set to some form of "Show."  (Incidentally, I have Server 2018.2.)

 

DSN Configuration.png

 

Show Connection Progress.pngInterim update.png

 

Labels