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

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.

9 Comments
JayR
6 - Meteoroid

All about this! ^

HJackson
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.

SVBurger
5 - Atom

This would be very helpful!

cmcclellan
13 - Pulsar

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. 

cmcclellan
13 - Pulsar

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.

KylieF
Alteryx Community Team
Alteryx Community Team
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.

Ashwini_Bende
5 - Atom

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

Scouter60_RUS
7 - Meteor

Very Helpful but I am thinking this may have died on the vine

CristonS
Alteryx Alumni (Retired)
Status changed to: Implemented

This tool now supports Append Existing and Overwrite table functionality!

 

The Google BigQuery tools are available here on the Gallery, with many more upgrades.

 

Thanks again for your idea.