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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

About extracting data from DB

Highlighted
Alteryx Certified Partner

Hi,

 

I am currently working on some ETL tasks. When I setup the connection to an SQL server on the cloud, sometimes I cannot get all the data from a large table. The table should have ~2m rows but I usually can get 200k rows. I dont know why and when I re-start the computer or restart alteryx to run again, sometimes it works. Does anybody know why? And is there any way to aviod this happening?

Thanks.

 

Kenneth

ACE Emeritus
ACE Emeritus

Hi @kennethli,

Can you clarify what happens in the instances where you do not get the expected number of rows?  Is there an error message given or does it just return fewer rows for reasons unknown?  (Aside: I know ETL processes can sometimes get complicated, and if there is a random (unspecified) order returned in one section of a query, that could conceivably impact downstream portions of the query.  Just a thought, if anything along those lines is going on.)

 

Labels