When referencing a schema that is updated every few minutes from another schema (with MV, etc.), referencing the table being processed will occasionally cause an error. Considering the transaction, I think that the error will not occur if you refer t...

I would like to perform level-based aggregation to calculate composition ratios, etc. in a pivot table, but there is no support, so I would be happy if you could implement it.

It's a pivot table format insight, but the column headers don't disappear when scrolled, but the row headers disappear when scrolled and it's hard to see. I want to fix the row header so that it doesn't disappear on scroll.

I think this function is useful for realizing aggregation with complex conditions such as subqueries on the dashboard without modifying the schema.