Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.

Allow for a column list to be specified when using the Write Data In-DB tool

There is a known error when using the Write Data In-DB Tool. When writing to a table in MS SQL database that has a "identity" column you get the following error: Error: Write Data In-DB (X): Error running PreSQL on "NoTable": [DB Connection]An explicit value for the identity column in table [table_name] can only be specified when a column list is used and IDENTITY_INSERT is ON.


Essential this error happens when the table you are trying to write to has a column with the following configuration or similar: IDENTITY(1, 1) NOT NULL 


I am suggesting that the Write Data In-DB Tool should be configurable insert only to specified columns as identified by the user. Similar to the functionality of this SQL statement:

INSERT INTO [table_name]
    (column1, column2, column 3, etc...)
    VALUES (new_value1, new_value2, new_value3, etc...)


This would 1) solve the above issue (for which there is no viable workaround), and 2) allow users more flexibility in how they write their data.


The following community posts are related: