Generate unique ids in BigQuery data import
0
votes
0
answers
96
views
I am using Zapier to import woocommerce orders into BigQuery and build a datawarehouse with paid orders from multiple sites. However, multiple sites generate an ID per site, not a unique id globally for all, so importing into the same table data from all the woocommerce orders will not have unique ids.
I would like BigQuery to automatically assign a unique id to every new order that enters the table. Is this possible?
Asked by tokyographer
(1 rep)
Aug 22, 2022, 07:26 PM
Last activity: Aug 22, 2022, 09:09 PM
Last activity: Aug 22, 2022, 09:09 PM