[Udhyam]: High BigQuery cost

[rvignesh89]

Summary

Udhyam are seeing high BQ cost and want to find ways to reduce cost.

Discord Thread

https://discord.com/channels/717975833226248303/1470738366025957558

[radhikaT4D]

@rvignesh89 this is moved to dev priorities, since oncall isn't looking into it. Do update and close as you deem fit.

[rvignesh89]

Status

• Build dashboard for Udhyam to track costs
• Proposed a cost reduction plan
• Udhyam have turned off/deleted some Looker Studio dashboards to reduce unnecessary queries which seems to have helped

Awaiting test from Udhyam to observe if partitioning does indeed help their queries.