Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.

In-Database Update and/or Delete

DELETE from Source_Data Where ID in

SELECT ID from My_Temp_Table where FLAG = 'Y'




Essentially, I want to update a DB table with either an update or with the deletion of rows.  I can't delete all of the data.  My work around will be to create/insert into a table the keys that i want to delete and try to use a input/output tool with SQL that performs the delete.  Any other suggestions are welcome, but a tool is best.




Alteryx Certified Partner
Alteryx Certified Partner


Alteryx Partner
Love that new functionality, when is it coming to DB platforms other than SQL Server? There are a few out there: Redshift , Snowflake, PostGres....

This really needs to be added for other platforms, like Teradata for us. A lot of companies don't use SQL server and still require this functionality.

We also really need this for PostgreSQL !


I don't see the 'Delete Rows' or 'Update Rows' options when using the In-DB Write Tool.


Running 2019.1 and connecting to an Azure SQL Server DB using v17 ODBC drivers.


@MarqueeCrew @ARich - any ideas?


Many thanks in advance!




It'd nice to be able to run ANY Sql query from the INDB tools.

Example : in my PostgreSQL db, i'd like to be able to run such queries from Alteryx :

comment on column "ERF_MCHB_MCH1"."WERKS" is 'Division';

@acowpy I am in the same situation, I don't have access to the Delete/Update Rows options of the Write In-DB Tool. Did you find the solution to workaround the limitation? Thanks in advance

Hi @Al8an, in my case I eventually found our from Alteryx support that its because Alteryx does not support Update/Delete Output options with Microsoft Azure SQL Database.




Hi all, I have created an Idea for inclusion of Azure SQl Server instances. Please upvote!! 🙂


@MarqueeCrew @Al8an @NicolasFabre81 @zbrookler @fpinchon @ARich 



Thanks for the follow-up @acowpy !