Pular para o conteúdo
Kitbay
Enviar
SkillOficial

bigquery-optimization

Apache-2.0Atualizado em 11 de nov. de 202623.842Estrelas no GitHub

A Google skill with workflows for lowering BigQuery cost and speeding it up.

O que a skill ensina

A Google skill with workflows for lowering BigQuery cost and speeding it up. It covers modelling a move from on-demand pricing to Editions and right-sizing reservations, choosing logical or physical storage billing, designing partitioning and clustering with ready DDL templates, setting partition expiry for inactive data, tuning single SQL queries, and judging when search indexes, materialised views or BI Engine help. Before work starts it asks for the Cloud SDK, the BigQuery and Reservation APIs, sign-in and suitable IAM roles. It pairs with Google's observability and troubleshooting skills but can be used alone. It is a SKILL.md with reference files.

O que faz

  • Model a move from on-demand pricing to Editions
  • Recommend logical or physical storage billing
  • Generate partitioning and clustering DDL
  • Optimise individual SQL queries
  • Evaluate search indexes, materialised views and BI Engine