Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Input Data Tool: Can we control use of Cursors?

Originally posted here: https://community.alteryx.com/t5/Data-Sources/Input-Data-Tool-Can-we-control-use-of-Cursors/m-p/5871...

 

Hi there,

 

I've profiled a simple query using SQL Server Profiler (Query: Select * from northwind.dbo.orders; row limit: 107; read Uncommitted: true) and interestingly it opens up a cursor if you connect via ODBC or SQL Native; but not by OleDB - full queries and profile details are on the discussion thread above.

 

However - in some circumstances a cursor is not usable - e.g. https://community.alteryx.com/t5/Data-Sources/Error-SQL-Execute-Cursors-Not-supported-on-Clustered-C... because SQL doesn't allow cursors on columnstore indexed tables & columns

 

Is there any way (even if we need to manually adjust via the XML settings) to ask Alteryx not to create the cursor and execute directly on the server as written?

 

Thank you

Sean

13 Comments
KylieF
Alteryx Community Team
Alteryx Community Team
Status changed to: Under Review

Hi there! 

 

Thank you for your post! This is an interesting request and we're currently looking into the technical requirements around it. Once we have a full understanding of the technical side we'll update this idea again with a response on when or if we'd be able to provide the user more control over when Alteryx makes a cursor.

KylieF
Alteryx Community Team
Alteryx Community Team
Status changed to: Revisit

This idea is being updated to Revisit at this time, while our product team likes this idea and plan to look into adding this feature to the MS SQL connector, this particular connector is not on the near future roadmap for updating. We'll update this idea again once we know when or if the MS SQL connector will be added to the near future roadmap for updates.

cphillips1
6 - Meteoroid

This issue occurs when you connect to MS Access 2016 (*.accdb) file also. When I use the SQL Editor with the statement "SELECT * FROM 'table1' it pulls 4-5 duplicates of several of the records. When I open up the table in Access there are no duplicates.