2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

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.

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.