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.
We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!
Be sure to review our Idea Submission Guidelines for more information!
During the design phase, we make some experimentations and create tables with Alteryx.
But, sometimes, after this phase or after a mistake, we need to drop those tables.
We know that it's possible to write a drop table statement in Pre-SQL or Post-SQL but it requires SQL skills and it could be done only if you write in a table.
It will be great if we could drop a table directly in the Query builder of the Input tool by making a right click on the table in the discovery tree.
Extension : It also be great to have the same thing in the HDFS browse.
It may bee good to have a tool for listing existing tables, creating dates and updated dates...
List and drop in conjunction with create would make Alteryx a DWH tool I presume...
It would be really nice effectively if we could have a "IN-Db drop box". If you use Alteryx as Dataprep tool, you can sometimes cut your in-db workflow in many workflows... Each workflows can finally create some intermediate tables in HDFS and if you want conserv only the final table/result at the end of devs, we can't drop all these intermediates tables of HDFS.
Thanks for the feedback- please continue to star if you'd like to see this!
More broadly - I think that we need to extend the capability of Alteryx to look at the broader need of BI people.
For example - you can't sync two tables; you can't do a dimension update that takes care of Slowly Changing Dimensions, etc.
So I agree with the idea - and think that there's a much broader need here to extend Alteryx to the needs of the bigger BI shops who are using this not just as a prep tool, but as an ETL pipeline too.
+1 would really like some kind of tool-based way for non-SQL coders to drop tables. Seems like such a simple addition.
I completely agree and support @aweiss2k 's point.
If we could have tool based way to truncate, add, delete tables it would very helpful to Non-SQL people
Hello,Would be very useful. Also very affordable, maybe one day or two of a developer 😄Best regards,Simon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.