Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Update - Revamp Google BigQuery Output Tool - Allow for overwriting

Currently, when one uses the Google BigQuery Output tool, the only options are to create a table, or append data to an existing table.  It would be more useful if there was a process to replace all data in the table rather than appending. Having the option to overwrite an existing table in Google BigQuery would be optimal.

7 Comments
6 - Meteoroid

All about this! ^

7 - Meteor

Enabling more complex queries that allow for drop/delete functionality is vital for data creation and maintenance. The limitation of append inhibits utilization of this tool, and essentially renders it useless for most write-to-db operations.

5 - Atom

This would be very helpful!

Alteryx Partner

Agreed on everything above.  I've just started using GBQ and very frustrating to read that Alteryx allows very complex queries only to find that you can insert into an existing table and really nothing else 😞 

 

We now have to write a lot of macros to do the basic functionality that should be provided - simple stuff like truncating a table or creating a new table. 

Alteryx Partner

I also discovered that this tool uses a streaming input which prevents further DML for a long time.  

 

Based on that, we wrote our own macros to interact with the tables in the way we require - to do a truncate/insert if required and an easier way to insert.

Moderator
Moderator
Status changed to: Under Review

Thank you for posting to the Alteryx Community. Your idea is currently being reviewed by the Alteryx Development Team for a possible future release. Please note that this review process can take some time, we’ll do our best to keep you up to date on the status of your idea.

5 - Atom

Yes, it would be useful to have an overwrite feature from this tool