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.
ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
1 Day Left! - The Alteryx Community will be temporarily unavailable for a few hours due to implementation of the new SSO experience starting tomorrow at 5pm MDT. Please plan accordingly. For more information, read the blog.
When running a workflow that contains queries connected to SQL Server or Azure Synapse (formerly known as Azure Data Warehouse), respectively; the following error occurs:
Error: Input Data (1): Error SQLExecute: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Cursor support is not an implemented feature for SQL Server Parallel DataWarehousing TDS endpoint.
Error: Input Data (1): Error SQLExecute: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cursors are not supported on a table which has a clustered columnstore index.[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Statement(s) could not be prepared.
Alt SQL Server Error
Invalid cursor state UPDATE <table_name> SET <followed by every field name in the data>
Input Data Tool
SQL Server ODBC Drivers
Native Client 11
SQL Server OLEDB
Azure Synapse (Azure Data Warehouse)
The SQL Server table involved the data set contains a ColumnStore Index. By default, ODBC automatically opens a cursor for every result set returned from a SQL statement.
Cursors are not supported on Azure Synapse. By default, the Synapse SQL pool creates a clustered columnstore index when no index options are specified on a table.
Connect to the SQL Server database using OleDB drivers instead of ODBC, if possible.
1. In the Choose Table or Specify Query window, select the SQL Editor tab.
2. After the SQL query, enter the line: SET NOCOUNT ON at the end as such:
--SQL query code here-- SET NOCOUNT ON
3. Click OK and re-run the workflow.
Opening the Visual Query Builder to edit the query will cause the parsing error seen below, which can be ignored.
It's also possible to set the SQL Editor as the default to avoid the error from showing up right away.