Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

biquery performance issue

Hello Team,

I have this table which has one driving table and then almost 17 tables left joined on this, now because of this the data has kind of replicated and the table size has grown big.

 

currently its process 37G data. I would like to tune this table badly. But we don't have any dates or int column to which i can create partition on. any suggestion on this would be really helpful.

 

 

 

1 2 212
2 REPLIES 2