How to append non-partitioned table to a partitioned table in GCP using BIGQUERY TOOL
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
blitz45
8 - Asteroid
‎10-16-2023
11:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Labels:
- Labels:
- Designer Cloud
- Developer
- Google Analytics
0 REPLIES 0
