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

IN DB Update Tools

A functionality that my team really needs is the ability to use update and delete statements through in database tools. We use Teradata on my team and I'm sure many other platforms also need this functionality. I am really shocked and disappointed that in the update to 2018.4 Alteryx decided that it would add this new functionality to it's Write In DB tool, but only added it for SQL server. Moreover, this functionality is a hole that has been missing in these tools for a long time. Patches in functionality like that need to be added to all platforms, not just one. So please add update functionality to the Write In DB tool for Teradata and other platforms. The original post where Alteryx decided to make only this small change is here: https://community.alteryx.com/t5/Alteryx-Designer-Ideas/In-Database-Update-and-or-Delete/idi-p/13153...

7 Comments
pwebster
5 - Atom

This is very disappointing news.  Alteryx, this isn't a fix if it only applies to one platform.  Our group has struggled with spool space issues when trying to use the current In DB tools, and we were very hopeful that 2018.4 would finally allow us to move past these problems.  Instead, we may have to consider other options. 

 

Alteryx, please consider making the Write In DB tool work for Teradata and other platforms ASAP! 

JSchiele
7 - Meteor

Agreed - This is a huge gap that needs to be solved for.  This is impacting our ability to work with larger data sets without having to run manual TD queries. We were hoping that the latest upgrade would solve for spool space issues, however without the capability to write in db w/ Teradata platform we are unable to move our processes entirely to Alteryx.

chrisha
11 - Bolide
Same with PostgreSQL and MySQL database servers... even if database is not huge, this is much more efficient and close to what I'd be doing in any other tool.
WS1
5 - Atom

The ability to run Teradata updates and deletes in Alteryx will definitely resolve spool space issues we are encountering.   Please add this functionality to Alteryx.

JMKay
5 - Atom

I'd be licking my chops if I was a SQL Server user, but unfortunately am not... We are primarily a Teradata shop, so I feel that this functionality within Teradata (and other DB platforms) is not only just a nice to have, but is really necessary to truly incorporate all of our processing in a workflow.

MichalK
8 - Asteroid

I'm fully behind this idea. Why is the linked thread marked as 'Implemented' when the option to update In-DB is still not available?

 

I'm also curious what are the technical barriers to having 'update' alongside creating/deleting/overwriting tables... after all, it should all come down to passing a SQL statement to the target DB?

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes