Update - Revamp Google BigQuery Output Tool - Allow for overwriting

[CHRockhill]

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.

[JayR]

All about this! ^

[HJackson]

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]

This would be very helpful!

[cmcclellan]

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]

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]

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]

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

[Scouter60_RUS]

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

[CristonS]

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.