-1

We have exported our GCP billing information to bigquery. When querying over it I've noticed that there seems to be a one-to-many relationship between service and sku. In other words, every instance of a sku seems to have the same service.

If this is indeed the case I can build some nice drill-down type reports whereby the report user drill from service to sku. before I build such a report though I want to confirm that this is indeed the case.

Can multiple instances of a SKU map to different services?

jamiet
  • 10,501
  • 14
  • 80
  • 159

1 Answers1

0

Ah, seems the answer is "no, there isn't a one-to-many relationship between service and sku"

enter image description here

enter image description here

That's a shame.

jamiet
  • 10,501
  • 14
  • 80
  • 159