Skip to Main Content
DoiT logo
Pillar Optimization
Categories BigQuery Lens
Created by Guest
Created on Apr 29, 2021

Change Potential Savings calculations

Recommendations overlap each other, so the final “potential savings” is not accurate because it is not achievable. for example, On our demo project, we are showing savings of 88%! ( 3170 / 3643) is it possible that current logic will show customers more than 100% of savings? I suggest: 1. separating the recommendations into those categories Schema design - implementing this change won’t change your business logic but might save you money. Change the logic - change the way you are using big query. If it fits your business, you might be able to reduce costs (limit query job, enforce partitioning, delete old data) Use superquery - it will cache data so that you will scan less in bigquery. 2. Present the impact by order of priority or order of magnitude of savings. This will have a similar impact and avoid presenting inaccurate savings.
  • Attach files
  • Guest
    Reply
    |
    Oct 13, 2022

    Potential cost savings exist, depending on the nature of your business (limit query job, enforce partitioning, delete old data) Use superquery to reduce the amount of data scanned in 2048 bigquery by caching it. Show the effects in descending order of importance or cost reduction. Savings projections won't be skewed in any way, and the effect will be the same .

  • Guest
    Reply
    |
    May 23, 2022

    Hi! Have you thought about starting a blog on the topic of trading or a paid channel? After all, this is a very promising direction in our time. If you suddenly decide to do this, I advise you https://www.screencapture.com/blog/how-to-record-a-video-on-mac.html as for me, it is easy to use and does not require any experience in video recording

  • Guest
    Reply
    |
    May 2, 2022

    Now, in the realm of trading, there are many technologies that may assist you, such as macd crypto MA, WMA, and EMA technologies, which can help you forecast which way the market is heading and where it might go. The most comprehensive explanation to these technologies can be found here ma in crypto, where it is written in a straightforward manner about all of the benefits of this technology as well as a description of all forms of moving averages. I strongly advise you to

  • Guest
    Reply
    |
    Apr 29, 2021
    screenshot of 88% potential savings