Nuove viste nelle data share per semplificare le query sugli Usage Groups

In precedenza, quando si scriveva una query sulle nostre data share che coinvolgevano gli Usage Groups, la definizione completa dell'Usage Group era presente nella query, aumentando la complessità e compromettendo la leggibilità.

1with select start_day as day, sum_query_cost from ( select start_day as day, -- full usage group definition included case when warehouse_name in ('DBT_S', 'DBT_M') or user_name in ('SVC_DBT') then 'Analytics Engineering' when warehouse_name in ('Warehouse 1', 'Warehouse 2') or user_role in ('MARKETING_ANALYST') or database_name in ('MARKETING') then 'Marketing Team' when ... when ... else 'Uncategorized' end as usage_group, sum(sum_query_cost) as sum_query_cost from select_datashare.transformed.daily_workloads_usage_groups where start_day >= '2024-09-01' and start_day <= '2024-09-14' group by all ) where usage_group in ('Marketing Team') order by day desc nulls last

Abbiamo quindi creato nuove viste, che astraggono la definizione dell'Usage Group rendendo le query più semplici.

1select start_day as day, sum(sum_query_cost) as sum_query_cost from select_datashare.transformed.daily_workloads_usage_groups where usage_group in ('Marketing Team') and start_day >= '2024-09-01' and start_day <= '2024-09-14' group by all order by day desc nulls last