Nuevas vistas en los data shares para simplificar las consultas de Usage Groups

Anteriormente, al escribir una consulta contra nuestros data shares que involucraban Usage Groups, la definición completa de Usage Group estaba presente en la consulta, lo que aumentaba la complejidad y dificultaba la legibilidad.

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

Desde entonces, hemos creado nuevas vistas que abstraen la definición de Usage Group, lo que resulta en consultas más simples.

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