Yes, when connecting BQ to looker studio there will be some recurring costs of refreshing data or reloading the same daterange outside of the refresh window. For the most part it's fairly Nominal cost. Here you can see the cost of maintaining our report lookerstudio.google.com/u/0/reporting/baa0bfb0-70c8-4b0c-9a8d-c44ae220e3f2/page/p_zrzmceua4c?params=%7B%22df192%22:%22include%25EE%2580%25800%25EE%2580%2580IN%25EE%2580%2580BetterThanData%22%7D But can be different depending on volume. Ideally, you have a the smallest possible dataset connected to looker studio. We will have more free videos in the future on this :) - JJ
@@Vision-Labs Great video as always! Since cost is an issue here, why not make the BQ view run daily to fetch just the previous day and add it to the rest of the days (incremental), and make LS read from that data set, which will not incur any cost when changing the dates....?
thank you very much. in summary, in what cases would i prefer connecting via custom query rather than direct to the table?
Custom Queries should very rarely be used. Only when you really need to update the physical query.
amazing, I have been trying to figure this out for awhile
Wohoooo glad we could help!
-JJ
Do you have a way to optimize costs, as I understand that every time we change the date range, it means we make a query, which can be make cost over?
Yes, when connecting BQ to looker studio there will be some recurring costs of refreshing data or reloading the same daterange outside of the refresh window.
For the most part it's fairly Nominal cost. Here you can see the cost of maintaining our report
lookerstudio.google.com/u/0/reporting/baa0bfb0-70c8-4b0c-9a8d-c44ae220e3f2/page/p_zrzmceua4c?params=%7B%22df192%22:%22include%25EE%2580%25800%25EE%2580%2580IN%25EE%2580%2580BetterThanData%22%7D
But can be different depending on volume. Ideally, you have a the smallest possible dataset connected to looker studio.
We will have more free videos in the future on this :)
- JJ
@@Vision-Labs Great video as always!
Since cost is an issue here, why not make the BQ view run daily to fetch just the previous day and add it to the rest of the days (incremental), and make LS read from that data set, which will not incur any cost when changing the dates....?
nice one :)
thank you very much. in summary, in what cases would i prefer connecting via custom query rather than direct to the table?