This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?
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.)