GCP Billing & FinOps

Hi, I have the same problem.

About change billing project id don´t resolved for me.  

I will open a ticket about this case for me.

In my case I had to do a split based on the characters for each column analyzing the bigquery schema, but that took a lot of steps and the data update flow hits the limit of the pro version (dataflow refresh limit 2 hours) and I end up having an error and not updating the data. I had to remove unused columns, among others, but it worries me because I have an error every 5 days, etc.

I say this because I also load much larger Autonomous DW (OCI) data and I don't suffer from refresh.

I realized that there is no way to transform this column into json and try to convert it into a table or somehow load the data correctly.

It can be noticed that with split I explored the divisor character because for each column you can have two or more values, being name and key value..

look after this job (long time kkk)