Hi,
I have a GCP billing in Bigquery (Standard Data Export). I want to create a new table in Bigquery based on that billing. The table should be daily updated and that means I need to understand how Standard Data Export is created.
I've noticed that it has virtual _PARTITIONTIME column, so I thought I can use it to recognize new records and add them to my new table. But then I've also noticed that there can be significant difference between _PARTITIONTIME and a date of a real usage_time (in my case it goes up to 38 days). I wonder how my Standard Data Export is created? Are the records only added to it or do we have to deal also with updates? By updates I mean deleting/changing early created records and inserting new ones instead of them with new _PARTITIONITME. It is important for me, because I need to know how much my previous costs can change.
LinkedIn
Twitter
