The real workflow includes other tools but since about 93% of time was being spent in the data extraction, I created a simple workflow to test the extraction tools. Well, this is was just a test case to try to figure out what I was doing wrong. ![]() So I decided to come here and ask the community how to make the SQL Server data extractions faster in Alteryx as we (me and my team) must be doing something wrong.įROM. My colleagues have the same issues (though most of them never used other tools before - they believe this to be normal).īefore posting here, I browsed the forum for similar issues and while found some complaints on the extraction being slow, no real solution was provided. I followed all the connection instructions in Alteryx website for both data connections and In-Db Connections and I'm still getting very slow extraction times. My guess is that I'm doing something very wrong. ![]() When running the same query in Alteryx using either in the Input Tool or the In-Db (Connect DB + Data Stream Out) it takes around 20-25 minutes. Issue: When exporting the data from this query using MS SQL Server Management Studio, the total time is 0:40 to 0:60s. ![]() My company uses Alteryx as its dataflow tool and I need to extract the data from a simple query (below) and saved to some local file. I believe I'm doing something wrong in Alteryx since I'm a new user.
0 Comments
Leave a Reply. |