domo

Partitioned tables As you know, for cost effectiveness, some datasets are split in several tables in BigQuery. That’s particularly the case for the Google Analytics tables: ga_sessions_YYYYMMDD. The reason why these tables are split is that we can query only a subset of the whole data. Example: query to collect one week of visits per country: #standardSQL -- Query 1 SELECT date AS `date` , geoNetwork.country AS `country` , SUM(totals.visits) as `visits` FROM `XXXXXXXX.