Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to append non-partitioned table to a partitioned table in GCP using BIGQUERY TOOL

blitz45
8 - Asteroid

Hi Everyone, 

 

I have pushed a table from Alteryx to GCP using the BIGQUERY tool. I partitioned the table within GCP. Now, I have a new table with the same fields that I need to append into GCP. Is there a way I can automatically append in the workflow? I tried appending it using the big query tool and marking 'Append to table'. However, it only created a new non-partitioned table with the same name in GCP. Any way I could append the table into the partitioned table in GCP? 

0 REPLIES 0
Labels