假设我有实体A、B和C,要在BigQuery中存储one-to-many关系。A -- (one to many) --> B --- (one to many) --> C
对于“常规”SQL数据库,我将根据A和C的主键在A和B中创建带有主键和外键的表B、A和C。它对BigQuery有用吗?是否最好将该结构去奥马尔化,并将所有A、B和C存储在一个表中
gift_card' AS PaymentType) FROM UNNEST(PaymentLines) WHERE PaymentMethod = 'gift_card')这里的问题是,我只需要将支付类型更新为“gift_card”,其中PaymentMethod = to 'gift_card',但是我的代码在它执行后将PaymentMethod和PaymentType更新为'gift_card更新1