Тёмный

Connect to BigQuery with Dynamic Date Ranges 

Vision Labs
Подписаться 2,6 тыс.
Просмотров 1,7 тыс.
50% 1

Опубликовано:

 

16 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 8   
@cltrhyve5932
@cltrhyve5932 4 месяца назад
amazing, I have been trying to figure this out for awhile
@Vision-Labs
@Vision-Labs 4 месяца назад
Wohoooo glad we could help! -JJ
@albertstanulis5278
@albertstanulis5278 Год назад
nice one :)
@stkchan9762
@stkchan9762 Год назад
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?
@Vision-Labs
@Vision-Labs Год назад
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
@OronM
@OronM Год назад
@@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....?
Далее
How to get started with BigQuery
17:19
Просмотров 41 тыс.
Connecting Looker Studio to Views in BigQuery
20:29
Просмотров 4,6 тыс.
BigQuery Variables 👴🏼
11:53
Просмотров 2,9 тыс.
Google Data Studio Advanced Date Selection
13:06
Просмотров 10 тыс.
How To Use Date Range Controls in Looker Studio
7:04
Просмотров 4,4 тыс.
Range Lookup in Power BI in the Power Query Editor
12:41