community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

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.

 

Thanks,

Mark

50 Comments
Alteryx Certified Partner
Alteryx Certified Partner

Thanks!

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 !

Meteor

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 @AlexP - any ideas?

 

Many thanks in advance!

 

alt.png

 

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';

Atom
@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
Meteor

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.

 

 

Meteor

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

 

https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Update-Delete-Output-for-Microsoft-Azure-SQL...

 

@MarqueeCrew @Al8an @NicolasFabre81 @zbrookler @fpinchon @AlexP 

 

 

Atom
Thanks for the follow-up @acowpy !