{"id":8531,"date":"2026-01-08T13:18:31","date_gmt":"2026-01-08T12:18:31","guid":{"rendered":"https:\/\/igloonet.cz\/blog\/?p=8531"},"modified":"2026-01-08T15:01:24","modified_gmt":"2026-01-08T14:01:24","slug":"jak-dostat-data-do-bigquery","status":"publish","type":"post","link":"https:\/\/igloonet.cz\/blog\/jak-dostat-data-do-bigquery\/","title":{"rendered":"Jak dostat data do&nbsp;BigQuery"},"content":{"rendered":"<div id=\"fb-root\"><\/div>\n<p>BigQuery dnes pat\u0159\u00ed mezi nejd\u016fle\u017eit\u011bj\u0161\u00ed n\u00e1stroje v&nbsp;digit\u00e1ln\u00ed analytice. Umo\u017e\u0148uje efektivn\u011b zpracov\u00e1vat velk\u00e9 objemy dat, shrom\u00e1\u017edit je na&nbsp;jednom m\u00edst\u011b, sjednotit a&nbsp;pracovat s&nbsp;nimi bez ohledu na&nbsp;to, odkud poch\u00e1zej\u00ed. Jak dat p\u0159ib\u00fdv\u00e1 a&nbsp;jejich kvalita \u010dasto kles\u00e1, roste pot\u0159eba spolehliv\u00e9ho a&nbsp;flexibiln\u00edho datov\u00e9ho skladu. BigQuery nav\u00edc t\u011b\u017e\u00ed z&nbsp;\u00fazk\u00e9 integrace s&nbsp;dal\u0161\u00edmi slu\u017ebami Googlu. Snadno k&nbsp;n\u011bmu p\u0159ipoj\u00edte data z&nbsp;Google Analytics 4, Google Ads, Search Console \u010di Google Play. Mo\u017enosti t\u00edm ale nekon\u010d\u00ed. BigQuery nen\u00ed omezen\u00e9 jen na&nbsp;ofici\u00e1ln\u00ed konektory. Data do&nbsp;n\u011bj lze dostat mnoha r\u016fzn\u00fdmi zp\u016fsoby a&nbsp;stejn\u011b tak existuje \u0159ada cest, jak je z&nbsp;n\u011bj op\u011bt vyexportovat. Tento \u010dl\u00e1nek se zam\u011b\u0159uje pr\u00e1v\u011b na&nbsp;prvn\u00ed \u010d\u00e1st: praktick\u00e9 metody, jak data do&nbsp;BigQuery na\u010d\u00edtat, a&nbsp;to od&nbsp;nejjednodu\u0161\u0161\u00edch a\u017e po ty, kter\u00e9 vyu\u017eijete ve&nbsp;v\u011bt\u0161\u00edch a&nbsp;komplexn\u011bj\u0161\u00edch datov\u00fdch ekosyst\u00e9mech.<\/p>\n<p><!--more--><\/p>\n<h2>Pro\u010d m\u00edt data v&nbsp;BigQuery<\/h2>\n<p>BigQuery je v&nbsp;digit\u00e1ln\u00ed analytice p\u0159irozenou volbou zejm\u00e9na d\u00edky pr\u00e1ci s&nbsp;daty z&nbsp;GA4. D\u00edky nativn\u00ed integraci dok\u00e1\u017ee p\u0159ij\u00edmat event-level stream, tedy mnohem detailn\u011bj\u0161\u00ed data, ne\u017e jak\u00e1 vid\u00edme v&nbsp;rozhran\u00ed GA4. M\u00edsto agregovan\u00fdch metrik z\u00edsk\u00e1me kompletn\u00ed historii jednotliv\u00fdch ud\u00e1lost\u00ed, v\u010detn\u011b parametr\u016f, kter\u00e9 UI v\u016fbec nezobrazuje. Rozhran\u00ed GA4 je vhodn\u00e9 pro rychl\u00e9 p\u0159ehledy, ale pracuje s&nbsp;p\u0159edzpracovan\u00fdmi daty, m\u011bn\u00ed definice metrik a&nbsp;m\u00e1 limity, kter\u00e9 zt\u011b\u017euj\u00ed hlub\u0161\u00ed anal\u00fdzu. Pokud pot\u0159ebujeme p\u0159esnou rekonstrukci u\u017eivatelsk\u00fdch cest, audit m\u011b\u0159en\u00ed, kontrolu atribu\u010dn\u00edch model\u016f nebo vlastn\u00ed logiku v\u00fdpo\u010dt\u016f, BigQuery n\u00e1m umo\u017e\u0148uje pracovat bez podobn\u00fdch omezen\u00ed.<\/p>\n<p>Dal\u0161\u00ed z\u00e1sadn\u00ed v\u00fdhodou jednotn\u00e9ho datov\u00e9ho skladu je prost\u00fd fakt, \u017ee&nbsp;data m\u00e1me na&nbsp;jednom m\u00edst\u011b. Zn\u00ed to ban\u00e1ln\u011b, ale s&nbsp;rostouc\u00edm po\u010dtem datov\u00fdch zdroj\u016f je to kritick\u00fd faktor. Uk\u00e1\u017eeme si to na&nbsp;b\u011b\u017en\u00e9 situaci.<\/p>\n<p>P\u0159edstavme si e-shop, kter\u00fd pou\u017e\u00edv\u00e1 GA4, n\u011bkolik reklamn\u00edch syst\u00e9m\u016f (Google Ads, Facebook, Sklik, Bing, Pinterest) a&nbsp;intern\u00ed syst\u00e9m pro objedn\u00e1vky a&nbsp;\u00fa\u010detnictv\u00ed. Bez datov\u00e9ho skladu jsou tato data rozpt\u00fdlen\u00e1 v&nbsp;samostatn\u00fdch platform\u00e1ch. To komplikuje jejich porovn\u00e1n\u00ed, zpomaluje debugging a&nbsp;prakticky znemo\u017e\u0148uje konzistentn\u00ed reporting nap\u0159\u00ed\u010d zdroji.<\/p>\n<p>Ano, n\u011bkter\u00e9 v\u011bci lze propojit p\u0159\u00edmo v&nbsp;Looker Studiu. GA4 i&nbsp;Google Ads p\u0159ipoj\u00edme bez probl\u00e9m\u016f. U&nbsp;dal\u0161\u00edch platforem jsme ale z\u00e1visl\u00ed na&nbsp;extern\u00edch konektorech nebo skriptech, kter\u00e9 pos\u00edlaj\u00ed data do&nbsp;Google Sheets. Intern\u00ed data do&nbsp;vizualiza\u010dn\u00edho n\u00e1stroje \u010dasto nedostaneme v\u016fbec, p\u0159\u00edpadn\u011b jen s&nbsp;velk\u00fdm \u00fasil\u00edm.<\/p>\n<p>Takov\u00fd workflow m\u00e1 n\u011bkolik slabin:<\/p>\n<ul>\n<li aria-level=\"1\"><b>je drah\u00fd<\/b> \u2013 konektory stoj\u00ed pen\u00edze a&nbsp;\u010dasto \u00fa\u010dtuj\u00ed podle objemu dat, u\u017eivatel\u016f nebo reklamn\u00edch \u00fa\u010dt\u016f,<\/li>\n<li aria-level=\"1\"><b>je rozt\u0159\u00ed\u0161t\u011bn\u00fd<\/b> \u2013 ka\u017ed\u00fd zdroj je napojen jinak a&nbsp;chov\u00e1 se&nbsp;jinak,<\/li>\n<li aria-level=\"1\"><b>nenab\u00edz\u00ed robustn\u00ed transformace <\/b>\u2013 v\u011bt\u0161inu \u00faprav bu\u010f neprovedeme, nebo je \u201elep\u00edme\u201c p\u0159\u00edmo v&nbsp;Lookeru, co\u017e vytv\u00e1\u0159\u00ed prostor pro&nbsp;chyby.<\/li>\n<\/ul>\n<p>Jakmile nesed\u00ed \u010d\u00edsla, za\u010d\u00edn\u00e1 zdlouhav\u00e9 hled\u00e1n\u00ed probl\u00e9mu. Kontrolujeme vizualizace, transformace v&nbsp;Looker Studiu, chov\u00e1n\u00ed konektor\u016f, API limity i&nbsp;samotn\u00e1 zdrojov\u00e1 data, kter\u00e1 jsou nav\u00edc roztrou\u0161en\u00e1 v&nbsp;r\u016fzn\u00fdch syst\u00e9mech. A&nbsp;pr\u00e1v\u011b tento chaos \u0159e\u0161\u00ed centralizace do&nbsp;BigQuery.<\/p>\n<p>Nezanedbatelnou v\u00fdhodou je i&nbsp;to, \u017ee&nbsp;BigQuery je sou\u010d\u00e1st\u00ed \u0161ir\u0161\u00edho ekosyst\u00e9mu Google Cloud Platform. D\u00edky tomu m\u016f\u017eeme p\u0159i pr\u00e1ci s&nbsp;daty vyu\u017e\u00edt celou \u0159adu dal\u0161\u00edch slu\u017eeb, kter\u00e9 na&nbsp;sebe p\u0159irozen\u011b navazuj\u00ed. A\u0165 u\u017e pot\u0159ebujeme data z\u00edsk\u00e1vat, transformovat, pl\u00e1novat pipeline, vytv\u00e1\u0159et reporty, hl\u00eddat jejich kvalitu nebo nad nimi stav\u011bt modely \u010di automatizace, GCP nab\u00edz\u00ed n\u00e1stroje, kter\u00e9 s&nbsp;BigQuery funguj\u00ed bez zbyte\u010dn\u00fdch p\u0159ek\u00e1\u017eek.<\/p>\n<h2>Co lze do&nbsp;BigQuery nahr\u00e1t<\/h2>\n<p>BigQuery dok\u00e1\u017ee pracovat s&nbsp;t\u00e9m\u011b\u0159 jak\u00fdmkoli typem dat, a&nbsp;proto v&nbsp;n\u011bm m\u016f\u017eeme centralizovat v\u011bt\u0161inu toho, co se v&nbsp;b\u011b\u017en\u00e9m marketingov\u00e9m nebo e-commerce ekosyst\u00e9mu vyskytuje. U\u017e jsme zmi\u0148ovali GA4, kter\u00e9 jsou jedn\u00edm z&nbsp;hlavn\u00edch d\u016fvod\u016f, pro\u010d BigQuery pou\u017e\u00edv\u00e1me, ale mo\u017enosti sahaj\u00ed mnohem d\u00e1l. Do&nbsp;BigQuery m\u016f\u017eeme nahr\u00e1t data nejen z&nbsp;cel\u00e9 \u0159ady Google slu\u017eeb, ale i&nbsp;z&nbsp;extern\u00edch platforem. U&nbsp;n\u011bkter\u00fdch syst\u00e9m\u016f je integrace jednoduch\u00e1, u&nbsp;jin\u00fdch slo\u017eit\u011bj\u0161\u00ed a&nbsp;z\u00e1le\u017e\u00ed na&nbsp;tom, jak vypad\u00e1 jejich API (nebo jestli API v\u016fbec maj\u00ed) nebo jak\u00fd p\u0159\u00edstup n\u00e1m poskytne klient. Ve&nbsp;v\u011bt\u0161in\u011b p\u0159\u00edpad\u016f jde bu\u010f o&nbsp;propojen\u00ed dvou datab\u00e1z\u00ed (nap\u0159. intern\u00ed datab\u00e1ze a&nbsp;BigQuery), nebo o&nbsp;stahov\u00e1n\u00ed dat vystaven\u00fdch p\u0159es&nbsp;API.<\/p>\n<p>BigQuery v\u0161ak nemus\u00edme pou\u017e\u00edvat jen pro \u201e\u017eiv\u00e9\u201c datov\u00e9 zdroje. Do&nbsp;jednoho m\u00edsta m\u016f\u017eeme konsolidovat i&nbsp;pomocn\u00e1 data, nap\u0159\u00edklad m\u011bnov\u00e9 kurzy, a&nbsp;tak\u00e9 historick\u00e9 datov\u00e9 sady, kter\u00e9 byly dosud ulo\u017een\u00e9 t\u0159eba v&nbsp;Google Sheets. T\u00edm p\u00e1dem neza\u010d\u00edn\u00e1me v&nbsp;BigQuery na&nbsp;pr\u00e1zdno. Naopak si do&nbsp;n\u011bj m\u016f\u017eeme p\u0159en\u00e9st prakticky celou historii, pokud je dostupn\u00e1. To vyu\u017eijeme zejm\u00e9na u&nbsp;syst\u00e9m\u016f, kde je sta\u017een\u00ed star\u0161\u00edch dat omezen\u00e9 nebo \u00fapln\u011b nemo\u017en\u00e9.<\/p>\n<p>V souvislosti s&nbsp;historick\u00fdmi daty je d\u016fle\u017eit\u00e9 zm\u00ednit napojen\u00ed GA4 do&nbsp;BigQuery. Velmi \u010dasto se na&nbsp;to zapom\u00edn\u00e1 a&nbsp;n\u00e1sledky jsou bohu\u017eel nevratn\u00e9. Historick\u00e1 data z&nbsp;GA4 do&nbsp;BigQuery zp\u011btn\u011b nedostanete. Export za\u010d\u00edn\u00e1 fungovat a\u017e od&nbsp;okam\u017eiku, kdy integraci zapnete, a&nbsp;od&nbsp;t\u00e9 chv\u00edle se tak\u00e9 vytv\u00e1\u0159ej\u00ed denn\u00ed tabulky s&nbsp;event-level daty. Pokud tedy pl\u00e1nujete pracovat s&nbsp;podrobn\u011bj\u0161\u00ed histori\u00ed, je nejlep\u0161\u00ed napojen\u00ed prov\u00e9st co nejd\u0159\u00edve. Samotn\u00e1 integrace zabere jen n\u011bkolik minut a&nbsp;ve&nbsp;v\u011bt\u0161in\u011b p\u0159\u00edpad\u016f je i&nbsp;cenov\u011b zanedbateln\u00e1 (\u010dasto neplat\u00edte nic). BigQuery na\u010d\u00edt\u00e1n\u00ed dat z&nbsp;GA4 ne\u00fa\u010dtuje do&nbsp;jednoho milionu event\u016f denn\u011b a&nbsp;n\u00e1klady na&nbsp;ulo\u017een\u00e1 data za\u010dnou b\u00fdt znateln\u00e9 a\u017e tehdy, kdy\u017e v&nbsp;n\u011bm m\u00e1te opravdu velk\u00e9 objemy. Podobn\u011b je to s&nbsp;historick\u00fdmi daty i&nbsp;u&nbsp;Google Search Console.<\/p>\n<p>Z \u010deho naopak m\u016f\u017eeme data dostat i&nbsp;zp\u011btn\u011b, jsou vlastn\u00ed datab\u00e1ze (u&nbsp;nich z\u00e1le\u017e\u00ed p\u0159edev\u0161\u00edm na&nbsp;\u017eivotnosti dat na&nbsp;klientov\u011b stran\u011b). Historick\u00e1 data z\u00edsk\u00e1me i&nbsp;z&nbsp;reklamn\u00edch syst\u00e9m\u016f. Situace je zde sice velmi individu\u00e1ln\u00ed, ale zpravidla lze pracovat i&nbsp;s&nbsp;daty n\u011bkolik let zp\u011btn\u011b. Mus\u00edme ale po\u010d\u00edtat, \u017ee&nbsp;transfer zabere v\u00edce \u010dasu (nap\u0159. 300&nbsp;dn\u00ed zp\u011btn\u011b u&nbsp;GAds se p\u0159en\u00e1\u0161\u00ed cca t\u00fdden). V&nbsp;p\u0159\u00edpad\u011b Facebooku n\u00e1s m\u016f\u017ee limitovat z\u00edsk\u00e1n\u00ed produktov\u00fdch dat, kter\u00e1 sice z\u00edsk\u00e1me historicky, ale pouze skrze vytv\u00e1\u0159en\u00ed a&nbsp;stahov\u00e1n\u00ed report\u016f, co\u017e velmi zat\u011b\u017euje API a&nbsp;tud\u00ed\u017e je nutn\u00e9 prov\u00e1d\u011bt tento transfer velmi pomalu.<\/p>\n<h2>Jak dostat data do&nbsp;BigQuery<\/h2>\n<p>Te\u010f u\u017e v\u00edme, pro\u010d BigQuery pou\u017e\u00edv\u00e1me a&nbsp;jak \u0161irok\u00e9 spektrum dat do&nbsp;n\u011bj m\u016f\u017eeme ulo\u017eit. Zb\u00fdv\u00e1 je\u0161t\u011b posledn\u00ed krok - jak tam ta data dostat? Mo\u017enost\u00ed je mnoho, ale za\u010dneme t\u011bmi nejjednodu\u0161\u0161\u00edmi, kter\u00e9 lze nastavit p\u0159\u00edmo v&nbsp;jednotliv\u00fdch n\u00e1stroj\u00edch bez jak\u00e9hokoli k\u00f3du.<\/p>\n<p>Prvn\u00ed na&nbsp;\u0159ad\u011b jsou u\u017e zmi\u0148ovan\u00e9 <b>GA4<\/b>. Integrace prob\u00edh\u00e1 p\u0159\u00edmo v&nbsp;rozhran\u00ed n\u00e1stroje a&nbsp;jej\u00ed nastaven\u00ed zabere jen n\u011bkolik minut. Jedin\u00e9, co pot\u0159ebujete, je existuj\u00edc\u00ed projekt v&nbsp;GCP a&nbsp;aktivn\u00ed billing. Bez n\u011bj se v\u00e1m budou data po 60 dnech automaticky mazat, a&nbsp;to nejen z&nbsp;GA4 exportu, ale ze v\u0161ech dataset\u016f ulo\u017een\u00fdch v&nbsp;BigQuery.<\/p>\n<p>Na stejn\u00e9m principu funguje i&nbsp;propojen\u00ed s&nbsp;<b>Google Search Console<\/b>. Tak\u00e9 zde se data pos\u00edlaj\u00ed p\u0159\u00edmo z&nbsp;n\u00e1stroje do&nbsp;BigQuery a&nbsp;export se spust\u00ed a\u017e od&nbsp;chv\u00edle, kdy integraci zapnete. Odm\u011bnou jsou ale podstatn\u011b detailn\u011bj\u0161\u00ed a&nbsp;analyti\u010dt\u011bj\u0161\u00ed data, ne\u017e jak\u00e1 m\u00e1te k&nbsp;dispozici p\u0159\u00edmo v&nbsp;rozhran\u00ed GSC, zejm\u00e9na p\u0159i pr\u00e1ci s&nbsp;dotazy a&nbsp;URL.<\/p>\n<blockquote><p><i><b>\ud83d\udca1<\/b><\/i>Pro funguj\u00edc\u00ed p\u0159enos ze Search Console pot\u0159ebujete m\u00edt zalo\u017een\u00fd service account v&nbsp;GCP s&nbsp;pr\u00e1vy <i>BigQuery Job User<\/i> a&nbsp;<i>BigQuery Data Editor<\/i>.<\/p><\/blockquote>\n<h3>Nativn\u00ed Data transfers<\/h3>\n<p>U Google slu\u017eeb je\u0161t\u011b z\u016fstaneme a&nbsp;pod\u00edv\u00e1me se na&nbsp;mo\u017enost, kter\u00e1 je p\u0159i pr\u00e1ci s&nbsp;BigQuery mimo\u0159\u00e1dn\u011b u\u017eite\u010dn\u00e1: nativn\u00ed Data Transfers. Jde o&nbsp;integra\u010dn\u00ed n\u00e1stroj p\u0159\u00edmo v&nbsp;GCP, kter\u00fd umo\u017e\u0148uje automaticky p\u0159en\u00e1\u0161et data z&nbsp;vybran\u00fdch slu\u017eeb do&nbsp;BigQuery bez nutnosti ps\u00e1t vlastn\u00ed k\u00f3d. Pr\u00e1v\u011b zde se za\u010d\u00edn\u00e1 naplno projevovat v\u00fdhoda toho, \u017ee&nbsp;BigQuery tvo\u0159\u00ed sou\u010d\u00e1st \u0161ir\u0161\u00edho cloudov\u00e9ho ekosyst\u00e9mu.<\/p>\n<p>Mezi nej\u010dast\u011bj\u0161\u00ed napojen\u00ed pat\u0159\u00ed <b>Google Ads <\/b>a&nbsp;samotn\u00e1 integrace je velmi jednoduch\u00e1. V&nbsp;prost\u0159ed\u00ed GCP zvol\u00edme Data Transfer, zad\u00e1me Customer ID a&nbsp;n\u00e1sledn\u011b se automaticky spust\u00ed denn\u00ed export dat. V\u00fdsledkem je rozs\u00e1hl\u00e1 sada tabulek (obvykle kolem 120), se kterou m\u016f\u017eeme d\u00e1le pracovat, transformovat ji nebo propojovat s&nbsp;dal\u0161\u00edmi zdroji. Google ned\u00e1vno p\u0159idal mo\u017enost vytvo\u0159it vlastn\u00ed dotaz u\u017e p\u0159i zakl\u00e1d\u00e1n\u00ed transferu a&nbsp;rovnou ukl\u00e1dat agregovan\u00e1 data do&nbsp;v\u00fdsledn\u00e9 tabulky. Tento p\u0159\u00edstup m\u016f\u017ee u\u0161et\u0159it prostor, ale p\u0159in\u00e1\u0161\u00ed riziko. Pokud toti\u017e zjist\u00edme, \u017ee&nbsp;pot\u0159ebujeme dal\u0161\u00ed metriky nebo dimenze, kter\u00e9 jsme do&nbsp;p\u016fvodn\u00edho dotazu nezahrnuli, mus\u00edme cel\u00fd proces nastavovat znovu. Z&nbsp;praktick\u00fdch d\u016fvod\u016f je proto \u010dasto v\u00fdhodn\u011bj\u0161\u00ed stahovat kompletn\u00ed datovou sadu a&nbsp;rozhodovat se a\u017e v&nbsp;BigQuery, jak s&nbsp;n\u00ed budeme pracovat.<\/p>\n<p>S\u00edlu Data transfers je vid\u011bt i&nbsp;u&nbsp;dal\u0161\u00edch slu\u017eeb. Krom\u011b Google Ads a&nbsp;jin\u00fdch Google platforem lze t\u00edmto zp\u016fsobem napojit i&nbsp;n\u011bkter\u00e9 extern\u00ed syst\u00e9my, nap\u0159\u00edklad Stripe, PayPal nebo Facebook. A&nbsp;pr\u00e1v\u011b u&nbsp;Facebooku stoj\u00ed za to se zastavit, proto\u017ee zde se dob\u0159e ukazuje, jak\u00e9 maj\u00ed nativn\u00ed konektory v\u00fdhody a&nbsp;limity.<\/p>\n<div id=\"attachment_8534\" style=\"width: 608px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/igloonet.cz\/blog\/wp-content\/uploads\/2026\/01\/BQ2.gif\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-8534\" class=\"size-full wp-image-8534\" src=\"https:\/\/igloonet.cz\/blog\/wp-content\/uploads\/2026\/01\/BQ2.gif\" alt=\"Ve\u0161ker\u00e9 slu\u017eby, kter\u00e9 lze nativn\u011b napojit p\u0159es Data transfers\" width=\"598\" height=\"608\"><\/a><p id=\"caption-attachment-8534\" class=\"wp-caption-text\">Ve\u0161ker\u00e9 slu\u017eby, kter\u00e9 lze nativn\u011b napojit p\u0159es Data transfers<\/p><\/div>\n<p>Je\u0161t\u011b doned\u00e1vna byl nativn\u00ed <b>Facebook<\/b> konektor pom\u011brn\u011b omezen\u00fd. Umo\u017e\u0148oval sice z\u00edskat velk\u00e9 mno\u017estv\u00ed dat t\u00e9m\u011b\u0159 bez n\u00e1mahy, ale z\u00e1rove\u0148 bez mo\u017enosti ovlivnit jejich strukturu. Nav\u00edc stahoval v\u0161echna data propojen\u00e1 s&nbsp;\u00fa\u010dtem, co\u017e bylo problematick\u00e9, pokud jsme m\u011bli v&nbsp;jednom \u00fa\u010dtu v\u00edce klient\u016f a&nbsp;pot\u0159ebovali data jen pro n\u011bkter\u00e9 z&nbsp;nich. Dal\u0161\u00ed komplikac\u00ed byla nutnost opakovan\u00e9 reautorizace API tokenu, kter\u00e1 \u010dasto sv\u00e1d\u011bla k&nbsp;nasazen\u00ed dlouhodob\u00e9ho tokenu, co\u017e z&nbsp;bezpe\u010dnostn\u00edho hlediska nen\u00ed ide\u00e1ln\u00ed \u0159e\u0161en\u00ed.<\/p>\n<p>Situace se v\u0161ak v&nbsp;posledn\u00edch m\u011bs\u00edc\u00edch v\u00fdrazn\u011b zlep\u0161ila. Nov\u00e1 verze konektoru umo\u017e\u0148uje vybrat, kter\u00e9 tabulky, metriky a&nbsp;dimenze chceme stahovat (i&nbsp;kdy\u017e v\u00fdb\u011br je st\u00e1le omezen\u00fd), a&nbsp;hlavn\u011b umo\u017e\u0148uje omezit stahov\u00e1n\u00ed pouze na&nbsp;\u00fa\u010dty, ke&nbsp;kter\u00fdm token skute\u010dn\u011b poskytuje p\u0159\u00edstup. Z\u016fst\u00e1v\u00e1 pouze pravideln\u00e1 nutnost obnovy tokenu, co\u017e je u&nbsp;Facebook API standard.<\/p>\n<h3>Keboola<\/h3>\n<p>Pokud naraz\u00edme na&nbsp;platformu, kter\u00e1 nem\u00e1 v&nbsp;GCP vlastn\u00ed konektor, nebo n\u00e1m nativn\u00ed p\u0159\u00edstup z&nbsp;n\u011bjak\u00e9ho d\u016fvodu nevyhovuje, jednou z&nbsp;nejpou\u017e\u00edvan\u011bj\u0161\u00edch alternativ je <b>Keboola<\/b>. Nab\u00edz\u00ed pohodln\u00e9 prost\u0159ed\u00ed, kter\u00e9 v&nbsp;mnoha ohledech p\u0159ipom\u00edn\u00e1 nativn\u00ed konektory, ale z\u00e1rove\u0148 poskytuje v\u011bt\u0161\u00ed flexibilitu a&nbsp;kontrolu nad na\u010d\u00edt\u00e1n\u00edm dat. Nev\u00fdhodou je jednak cena a&nbsp;jednak skute\u010dnost, \u017ee&nbsp;p\u0159id\u00e1v\u00e1me do&nbsp;na\u0161eho technologick\u00e9ho stacku dal\u0161\u00ed n\u00e1stroj, o&nbsp;kter\u00fd se mus\u00edme starat.<\/p>\n<p>Cenov\u00fd model Kebooly je zalo\u017een\u00fd na&nbsp;spot\u0159ebovan\u00fdch minut\u00e1ch. Na&nbsp;za\u010d\u00e1tku z\u00edsk\u00e1te 120 minut a&nbsp;ka\u017ed\u00fd m\u011bs\u00edc dal\u0161\u00edch 60. Pokud pot\u0159ebujete v\u00edce, lze si dal\u0161\u00ed bal\u00ed\u010dek p\u0159ikoupit za necel\u00fdch dev\u011bt dolar\u016f. Je dobr\u00e9 po\u010d\u00edtat s&nbsp;t\u00edm, \u017ee&nbsp;pro ka\u017ed\u00fd datov\u00fd tok vytv\u00e1\u0159\u00edme dva transfery \u2013 jeden ze zdroje do&nbsp;Kebooly a&nbsp;druh\u00fd z&nbsp;Kebooly do&nbsp;BigQuery.<\/p>\n<p>Odm\u011bnou je ale \u0161irok\u00e1 nab\u00eddka konektor\u016f, kter\u00e9 nejsou v&nbsp;GCP b\u011b\u017en\u011b dostupn\u00e9. Keboola pokr\u00fdv\u00e1 v\u011bt\u0161inu marketingov\u00fdch a&nbsp;e-commerce platforem, jako jsou Bing, Sklik, TikTok, Pinterest, LinkedIn, Heureka, Shoptet \u010di Shopify. Ka\u017ed\u00fd z&nbsp;konektor\u016f se m\u016f\u017ee chovat trochu jinak, zejm\u00e9na pokud jde o&nbsp;autorizaci nebo pr\u00e1ci s&nbsp;datov\u00fdmi rozsahy, ale Keboola k&nbsp;nim v\u011bt\u0161inou poskytuje p\u0159ehlednou dokumentaci.<\/p>\n<div id=\"attachment_8533\" style=\"width: 1364px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/igloonet.cz\/blog\/wp-content\/uploads\/2026\/01\/BQ3.png\"><img srcset=\"https:\/\/igloonet.cz\/blog\/wp-content\/uploads\/2026\/01\/BQ3-150x150.png 150w, https:\/\/igloonet.cz\/blog\/wp-content\/uploads\/2026\/01\/BQ3-300x179.png 300w, https:\/\/igloonet.cz\/blog\/wp-content\/uploads\/2026\/01\/BQ3-1024x613.png 1024w, https:\/\/igloonet.cz\/blog\/wp-content\/uploads\/2026\/01\/BQ3.png 1354w\" sizes=\"(min-width: 1024px) 1354px, (min-width: 300px) 1024px, (min-width: 150px) 300px, 150px\" aria-describedby=\"caption-attachment-8533\" class=\"size-full wp-image-8533\" alt=\"Z\u00e1kladn\u00ed nastaven\u00ed reportu kampan\u00ed z Skliku na denn\u00ed granularit\u011b\" width=\"1354\" height=\"810\"><\/a><p id=\"caption-attachment-8533\" class=\"wp-caption-text\">Z\u00e1kladn\u00ed nastaven\u00ed reportu kampan\u00ed z&nbsp;Skliku na&nbsp;denn\u00ed granularit\u011b<\/p><\/div>\n<p>Velkou v\u00fdhodou je pr\u016fb\u011b\u017en\u00e1 \u00fadr\u017eba konektor\u016f. Keboola je aktivn\u011b aktualizuje, tak\u017ee p\u0159i zm\u011bn\u00e1ch v&nbsp;API obvykle nen\u00ed pot\u0159eba d\u011blat z\u00e1sahy na&nbsp;na\u0161\u00ed stran\u011b. Dal\u0161\u00edm plusem je podpora inkrement\u00e1ln\u00edho na\u010d\u00edt\u00e1n\u00ed dat p\u0159\u00edmo do&nbsp;BigQuery, kter\u00e9 v\u00fdrazn\u011b sni\u017euje mno\u017estv\u00ed redundantn\u00edch dat a&nbsp;usnad\u0148uje \u0159\u00edzen\u00ed datov\u00fdch pipeline.<\/p>\n<blockquote><p><i><b>\ud83d\udca1<\/b><\/i>Keboola ale nen\u00ed jednoro\u017ecem v&nbsp;oblasti konektor\u016f a&nbsp;m\u00e1 sv\u00e9 alternativy. Za n\u00e1s m\u016f\u017eeme doporu\u010dit nap\u0159. Airbyte, kter\u00fd se vyzna\u010duje vysokou podporou open-source \u0159e\u0161en\u00ed. Jako takov\u00fd se zam\u011b\u0159uje prim\u00e1rn\u011b na&nbsp;konektory (Extract &amp;&nbsp;Load). Keboola oproti tomu poskytuje komplexn\u011bj\u0161\u00ed \u0159e\u0161en\u00ed na&nbsp;orchestraci cel\u00e9 pipeline, kter\u00e9 m\u016f\u017ee b\u00fdt ale v&nbsp;mnoha p\u0159\u00edpadech zbyte\u010dn\u00e9.<\/p><\/blockquote>\n<h3>Cloud Functions<\/h3>\n<p>Keboola v\u0161ak nen\u00ed \u0159e\u0161en\u00edm pro ka\u017ed\u00e9ho. M\u016f\u017ee b\u00fdt dra\u017e\u0161\u00ed, p\u0159id\u00e1v\u00e1 dal\u0161\u00ed n\u00e1stroj do&nbsp;na\u0161eho technologick\u00e9ho stacku a&nbsp;ne v\u017edy n\u00e1m poskytne takovou m\u00edru kontroly, kterou pot\u0159ebujeme. Pokud se neboj\u00edte napsat p\u00e1r \u0159\u00e1dk\u016f k\u00f3du a&nbsp;chcete z\u016fstat v&nbsp;prost\u0159ed\u00ed GCP, pak jsou elegantn\u00edm \u0159e\u0161en\u00edm <b>Cloud Functions<\/b>.<\/p>\n<p>Jejich z\u00e1sadn\u00ed v\u00fdhodou je to, \u017ee&nbsp;jsou p\u0159\u00edmou sou\u010d\u00e1st\u00ed GCP. B\u011bh funkc\u00ed se tak \u00fa\u010dtuje spolu s&nbsp;ostatn\u00edmi cloudov\u00fdmi slu\u017ebami a&nbsp;v&nbsp;praxi jde o&nbsp;velmi n\u00edzk\u00e9 n\u00e1klady. P\u0159i denn\u00edm stahov\u00e1n\u00ed dat z&nbsp;reklamn\u00edch syst\u00e9m\u016f se u&nbsp;na\u0161ich klient\u016f dost\u00e1v\u00e1me na&nbsp;jednotky a\u017e ni\u017e\u0161\u00ed des\u00edtky korun m\u011bs\u00ed\u010dn\u011b.<\/p>\n<div id=\"attachment_8535\" style=\"width: 944px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/igloonet.cz\/blog\/wp-content\/uploads\/2026\/01\/BQ4.gif\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-8535\" class=\"size-full wp-image-8535\" src=\"https:\/\/igloonet.cz\/blog\/wp-content\/uploads\/2026\/01\/BQ4.gif\" alt=\"Konektor, kter\u00fd stahuje denn\u00ed kampa\u0148ov\u00e1 data z Facebooku\" width=\"934\" height=\"608\"><\/a><p id=\"caption-attachment-8535\" class=\"wp-caption-text\">Konektor, kter\u00fd stahuje denn\u00ed kampa\u0148ov\u00e1 data z&nbsp;Facebooku<\/p><\/div>\n<p>Cloud Functions z\u00e1rove\u0148 poskytuj\u00ed plnou kontrolu nad t\u00edm, jak data z\u00edsk\u00e1v\u00e1me a&nbsp;jak s&nbsp;nimi d\u00e1le pracujeme. Typicky pou\u017e\u00edv\u00e1me Python, ve&nbsp;kter\u00e9m ur\u010dujeme, odkud data stahujeme, jak\u00fd dotaz pos\u00edl\u00e1me, jak data validujeme a&nbsp;kam je ukl\u00e1d\u00e1me. Tato svoboda ale p\u0159in\u00e1\u0161\u00ed i&nbsp;vy\u0161\u0161\u00ed n\u00e1roky na&nbsp;\u00fadr\u017ebu. Je pot\u0159eba hl\u00eddat verze API, zm\u011bny ve&nbsp;form\u00e1tu odpov\u011bd\u00ed i&nbsp;p\u0159\u00edpadn\u00e9 limitace jednotliv\u00fdch endpoint\u016f.<\/p>\n<p>Co se t\u00fd\u010de zdroj\u016f dat, mo\u017enosti jsou velmi \u0161irok\u00e9. V\u011bt\u0161ina platforem dnes poskytuje REST API, odkud lze data p\u0159\u00edmo stahovat. Podobn\u011b m\u016f\u017eeme pracovat s&nbsp;XML zdroji, jako jsou produktov\u00e9 feedy nebo sm\u011bnn\u00e9 kurzy \u010cNB. A&nbsp;pokud m\u00e1 klient vlastn\u00ed datab\u00e1zi, m\u016f\u017eeme data napojit p\u0159\u00edmo z&nbsp;n\u00ed \u2013 sta\u010d\u00ed p\u0159\u00edstup na&nbsp;\u00farovni datab\u00e1zov\u00e9ho u\u017eivatele a&nbsp;vhodn\u00fd konektor.<\/p>\n<p>Cloud Functions se nav\u00edc neomezuj\u00ed jen na&nbsp;stahov\u00e1n\u00ed dat. Umo\u017e\u0148uj\u00ed vytv\u00e1\u0159et cel\u00e9 automatiza\u010dn\u00ed procesy, \u0159\u00eddit alerting a&nbsp;odes\u00edlat notifikace do&nbsp;projektov\u00fdch n\u00e1stroj\u016f \u010di e-mailu, spou\u0161t\u011bt pravideln\u00e9 kontroly datov\u00e9 kvality nebo obsluhovat dal\u0161\u00ed \u010d\u00e1sti datov\u00e9 pipeline. Pr\u00e1v\u011b jejich flexibilita je d\u016fvodem, pro\u010d je najdeme prakticky v&nbsp;ka\u017ed\u00e9m modern\u00edm datov\u00e9m stacku v&nbsp;GCP.<\/p>\n<h2>Co preferujeme v&nbsp;igloo&nbsp;\ud83d\udc27<\/h2>\n<p>V\u00fd\u0161e jsme pro\u0161li r\u016fzn\u00e9 zp\u016fsoby, jak dostat data do&nbsp;BigQuery, a&nbsp;je p\u0159irozen\u00e9 se pt\u00e1t, zda je n\u011bkter\u00fd z&nbsp;nich nejlep\u0161\u00ed. Odpov\u011b\u010f je jednoduch\u00e1: nen\u00ed. Ka\u017ed\u00fd p\u0159\u00edstup m\u00e1 sv\u00e9 siln\u00e9 i&nbsp;slab\u00e9 str\u00e1nky a&nbsp;teprve v&nbsp;konkr\u00e9tn\u00edm kontextu za\u010d\u00edn\u00e1 d\u00e1vat smysl, pro\u010d se rozhodnout pr\u00e1v\u011b pro n\u011bj. Nejde tedy o&nbsp;to hledat univerz\u00e1ln\u00ed \u0159e\u0161en\u00ed, ale vyb\u00edrat takov\u00e9, kter\u00e9 nejl\u00e9pe odpov\u00edd\u00e1 tomu, \u010deho chceme dos\u00e1hnout.<\/p>\n<p>U n\u00e1stroj\u016f od&nbsp;Googlu je situace nejjednodu\u0161\u0161\u00ed. Napojen\u00ed GA4, Google Ads \u010di Search Console je stabiln\u00ed, rychl\u00e9 a&nbsp;\u0159e\u0161\u00ed prakticky v\u0161echno, co od&nbsp;datov\u00e9ho p\u0159\u00edsunu pot\u0159ebujeme. Pokud existuje nativn\u00ed konektor, pou\u017e\u00edv\u00e1me ho t\u00e9m\u011b\u0159 bez v\u00e1h\u00e1n\u00ed. S&nbsp;minim\u00e1ln\u00edm \u00fasil\u00edm z\u00edsk\u00e1me data ve&nbsp;vysok\u00e9 granularit\u011b a&nbsp;bez nutnosti se starat o&nbsp;pr\u016fb\u011b\u017enou \u00fadr\u017ebu. Je to pohodln\u00e9, funk\u010dn\u00ed a&nbsp;hlavn\u011b spolehliv\u00e9.<\/p>\n<p>U ostatn\u00edch zdroj\u016f u\u017e p\u0159ich\u00e1z\u00ed rozhodov\u00e1n\u00ed, kter\u00e9 mus\u00ed zohlednit \u00fadr\u017ebu, cenu i&nbsp;to, jak technicky otev\u0159en\u00fd je dan\u00fd ekosyst\u00e9m. Pokud n\u011bkdo hled\u00e1 p\u0159edev\u0161\u00edm pohodl\u00ed a&nbsp;p\u0159edv\u00eddatelnost n\u00e1klad\u016f, d\u00e1v\u00e1 smysl Keboola. Jej\u00ed konektory funguj\u00ed stabiln\u011b, v\u011bt\u0161inu starost\u00ed p\u0159eb\u00edr\u00e1 za n\u00e1s a&nbsp;po po\u010d\u00e1te\u010dn\u00edm nastaven\u00ed zpravidla nen\u00ed t\u00e9m\u011b\u0159 pot\u0159eba se j\u00ed v\u011bnovat. Nev\u00fdhodou je cena a&nbsp;skute\u010dnost, \u017ee&nbsp;roz\u0161i\u0159uje technologick\u00fd stack o&nbsp;dal\u0161\u00ed n\u00e1stroj, kter\u00fd mus\u00edme m\u00edt na&nbsp;radaru. Tam, kde u\u017e Keboola b\u011b\u017e\u00ed, je volba snadn\u00e1. Tam, kde neb\u011b\u017e\u00ed, je to v\u017edy o&nbsp;zv\u00e1\u017een\u00ed kompromisu mezi pohodl\u00edm a&nbsp;n\u00e1klady.<\/p>\n<p>Cloud Functions p\u0159edstavuj\u00ed opa\u010dn\u00fd p\u00f3l. Jsou levn\u00e9, flexibiln\u00ed a&nbsp;umo\u017e\u0148uj\u00ed absolutn\u00ed kontrolu nad t\u00edm, jak data z\u00edsk\u00e1v\u00e1me, validujeme a&nbsp;ukl\u00e1d\u00e1me. Cena provozu je zanedbateln\u00e1 a&nbsp;v&nbsp;prost\u0159ed\u00ed GCP se v\u0161e chov\u00e1 konzistentn\u011b. Na&nbsp;druhou stranu vy\u017eaduj\u00ed ur\u010ditou m\u00edru technick\u00e9 zralosti: je pot\u0159eba hl\u00eddat verze API, reagovat na&nbsp;zm\u011bny datov\u00fdch struktur nebo \u0159e\u0161it neo\u010dek\u00e1van\u00e9 p\u00e1dy konektor\u016f. N\u011bkdy je to pr\u00e1ce nav\u00edc, ale \u010dasto je to pr\u00e1v\u011b ta pr\u00e1ce, kter\u00e1 n\u00e1m umo\u017en\u00ed \u0159e\u0161en\u00ed p\u0159izp\u016fsobit p\u0159esn\u011b tomu, co klient skute\u010dn\u011b pot\u0159ebuje.<\/p>\n<p>A jak\u00fd p\u0159\u00edstup tedy v&nbsp;igloonetu up\u0159ednost\u0148ujeme? Nejprve vyu\u017eijeme v\u0161echno, co Google nab\u00edz\u00ed nativn\u011b. Pokud klient pou\u017e\u00edv\u00e1 Keboolu, r\u00e1di na&nbsp;ni nav\u00e1\u017eeme. A&nbsp;ve&nbsp;v\u0161ech ostatn\u00edch situac\u00edch vol\u00edme Cloud Functions, proto\u017ee n\u00e1m d\u00e1vaj\u00ed mo\u017enost reagovat rychle, udr\u017eet plnou kontrolu nad datovou pipeline a&nbsp;neb\u00fdt z\u00e1visl\u00ed na&nbsp;omezen\u00edch \u017e\u00e1dn\u00e9ho extern\u00edho konektoru. Implementace skrze Cloud Functions z\u00e1vis\u00ed rovn\u011b\u017e na&nbsp;\u201emainstreamovosti\u201c n\u00e1stroje \u2013 pokud reklamn\u00ed n\u00e1stroj \u010di datab\u00e1zi vyu\u017e\u00edv\u00e1 v\u011bt\u0161ina klient\u016f, napojen\u00ed a&nbsp;n\u00e1sledn\u00e1 \u00fadr\u017eba je jednodu\u0161\u0161\u00ed a&nbsp;levn\u011bj\u0161\u00ed. U&nbsp;okrajov\u00fdch n\u00e1stroj\u016f vol\u00edme zpravidla jin\u00e1 \u0159e\u0161en\u00ed (nap\u0159. Keboola).<\/p>\n<p>A na&nbsp;konec \u2013 neexistuje jedin\u00e1 spr\u00e1vn\u00e1 cesta. Existuje jen takov\u00e1, kter\u00e1 nejl\u00e9pe podporuje konkr\u00e9tn\u00ed c\u00edl pr\u00e1ce s&nbsp;daty.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>BigQuery dnes pat\u0159\u00ed mezi nejd\u016fle\u017eit\u011bj\u0161\u00ed n\u00e1stroje v&nbsp;digit\u00e1ln\u00ed analytice. Umo\u017e\u0148uje efektivn\u011b zpracov\u00e1vat velk\u00e9 objemy dat, shrom\u00e1\u017edit je na&nbsp;jednom m\u00edst\u011b, sjednotit a&nbsp;pracovat s&nbsp;nimi bez ohledu na&nbsp;to, odkud poch\u00e1zej\u00ed. Jak dat p\u0159ib\u00fdv\u00e1 a&nbsp;jejich kvalita \u010dasto kles\u00e1, roste pot\u0159eba spolehliv\u00e9ho a&nbsp;flexibiln\u00edho datov\u00e9ho skladu. BigQuery nav\u00edc t\u011b\u017e\u00ed z&nbsp;\u00fazk\u00e9 integrace s&nbsp;dal\u0161\u00edmi slu\u017ebami Googlu. Snadno k&nbsp;n\u011bmu p\u0159ipoj\u00edte data z&nbsp;Google Analytics 4, Google Ads, Search Console \u010di Google Play. Mo\u017enosti t\u00edm ale nekon\u010d\u00ed. BigQuery nen\u00ed omezen\u00e9 jen na&nbsp;ofici\u00e1ln\u00ed konektory. Data do&nbsp;n\u011bj lze dostat mnoha r\u016fzn\u00fdmi zp\u016fsoby a&nbsp;stejn\u011b tak<\/p>\n","protected":false},"author":48,"featured_media":8532,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"wp_typography_post_enhancements_disabled":false,"footnotes":""},"categories":[370,70],"tags":[340,432,102],"class_list":["post-8531","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-analytika","category-marketing","tag-data","tag-data-driven","tag-marketing-2"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Jak dostat data do BigQuery | igloonet blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/igloonet.cz\/blog\/jak-dostat-data-do-bigquery\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Jak dostat data do BigQuery | igloonet blog\" \/>\n<meta property=\"og:description\" content=\"BigQuery dnes pat\u0159\u00ed mezi nejd\u016fle\u017eit\u011bj\u0161\u00ed n\u00e1stroje v&nbsp;digit\u00e1ln\u00ed analytice. Umo\u017e\u0148uje efektivn\u011b zpracov\u00e1vat velk\u00e9 objemy dat, shrom\u00e1\u017edit je na&nbsp;jednom m\u00edst\u011b, sjednotit a&nbsp;pracovat s&nbsp;nimi bez ohledu na&nbsp;to, odkud poch\u00e1zej\u00ed. Jak dat p\u0159ib\u00fdv\u00e1 a&nbsp;jejich kvalita \u010dasto kles\u00e1, roste pot\u0159eba spolehliv\u00e9ho a&nbsp;flexibiln\u00edho datov\u00e9ho skladu. BigQuery nav\u00edc t\u011b\u017e\u00ed z&nbsp;\u00fazk\u00e9 integrace s&nbsp;dal\u0161\u00edmi slu\u017ebami Googlu. Snadno k&nbsp;n\u011bmu p\u0159ipoj\u00edte data z&nbsp;Google Analytics 4, Google Ads, Search Console \u010di Google Play. Mo\u017enosti t\u00edm ale nekon\u010d\u00ed. BigQuery nen\u00ed omezen\u00e9 jen na&nbsp;ofici\u00e1ln\u00ed konektory. Data do&nbsp;n\u011bj lze dostat mnoha r\u016fzn\u00fdmi zp\u016fsoby a&nbsp;stejn\u011b tak\" \/>\n<meta property=\"og:url\" content=\"https:\/\/igloonet.cz\/blog\/jak-dostat-data-do-bigquery\/\" \/>\n<meta property=\"og:site_name\" content=\"igloonet blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/igloonet\" \/>\n<meta property=\"article:published_time\" content=\"2026-01-08T12:18:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-08T14:01:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/igloonet.cz\/blog\/wp-content\/uploads\/2026\/01\/BQ1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Dominik Jirotka\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@igloonet\" \/>\n<meta name=\"twitter:site\" content=\"@igloonet\" \/>\n<meta name=\"twitter:label1\" content=\"Napsal(a)\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dominik Jirotka\" \/>\n\t<meta name=\"twitter:label2\" content=\"Odhadovan\u00e1 doba \u010dten\u00ed\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 minut\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/igloonet.cz\/blog\/jak-dostat-data-do-bigquery\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/igloonet.cz\/blog\/jak-dostat-data-do-bigquery\/\"},\"author\":{\"name\":\"Dominik Jirotka\",\"@id\":\"https:\/\/igloonet.cz\/blog\/#\/schema\/person\/9260068e4481933e8379d52d272fc53c\"},\"headline\":\"Jak dostat data do&nbsp;BigQuery\",\"datePublished\":\"2026-01-08T12:18:31+00:00\",\"dateModified\":\"2026-01-08T14:01:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/igloonet.cz\/blog\/jak-dostat-data-do-bigquery\/\"},\"wordCount\":3219,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/igloonet.cz\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/igloonet.cz\/blog\/jak-dostat-data-do-bigquery\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/igloonet.cz\/blog\/wp-content\/uploads\/2026\/01\/BQ1.png\",\"keywords\":[\"data\",\"data-driven\",\"marketing\"],\"articleSection\":[\"Analytika\",\"Marketing\"],\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/igloonet.cz\/blog\/jak-dostat-data-do-bigquery\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/igloonet.cz\/blog\/jak-dostat-data-do-bigquery\/\",\"url\":\"https:\/\/igloonet.cz\/blog\/jak-dostat-data-do-bigquery\/\",\"name\":\"Jak dostat data do BigQuery | igloonet blog\",\"isPartOf\":{\"@id\":\"https:\/\/igloonet.cz\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/igloonet.cz\/blog\/jak-dostat-data-do-bigquery\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/igloonet.cz\/blog\/jak-dostat-data-do-bigquery\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/igloonet.cz\/blog\/wp-content\/uploads\/2026\/01\/BQ1.png\",\"datePublished\":\"2026-01-08T12:18:31+00:00\",\"dateModified\":\"2026-01-08T14:01:24+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/igloonet.cz\/blog\/jak-dostat-data-do-bigquery\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/igloonet.cz\/blog\/jak-dostat-data-do-bigquery\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@id\":\"https:\/\/igloonet.cz\/blog\/jak-dostat-data-do-bigquery\/#primaryimage\",\"url\":\"https:\/\/igloonet.cz\/blog\/wp-content\/uploads\/2026\/01\/BQ1.png\",\"contentUrl\":\"https:\/\/igloonet.cz\/blog\/wp-content\/uploads\/2026\/01\/BQ1.png\",\"width\":1200,\"height\":628,\"caption\":\"Jak dostat data do BigQuery\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/igloonet.cz\/blog\/jak-dostat-data-do-bigquery\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Analytika\",\"item\":\"https:\/\/igloonet.cz\/blog\/rubriky\/analytika\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Jak dostat data do BigQuery\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/igloonet.cz\/blog\/#website\",\"url\":\"https:\/\/igloonet.cz\/blog\/\",\"name\":\"igloonet blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/igloonet.cz\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/igloonet.cz\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"cs\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/igloonet.cz\/blog\/#organization\",\"name\":\"igloonet\",\"url\":\"https:\/\/igloonet.cz\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@id\":\"https:\/\/igloonet.cz\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/igloonet.cz\/blog\/wp-content\/uploads\/2015\/07\/RGB_LVPC_igloonet.png\",\"contentUrl\":\"https:\/\/igloonet.cz\/blog\/wp-content\/uploads\/2015\/07\/RGB_LVPC_igloonet.png\",\"width\":650,\"height\":465,\"caption\":\"igloonet\"},\"image\":{\"@id\":\"https:\/\/igloonet.cz\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/igloonet\",\"https:\/\/x.com\/igloonet\",\"https:\/\/instagram.com\/igloonet\/\",\"https:\/\/www.linkedin.com\/company\/igloonet\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/igloonet.cz\/blog\/#\/schema\/person\/9260068e4481933e8379d52d272fc53c\",\"name\":\"Dominik Jirotka\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@id\":\"https:\/\/igloonet.cz\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f3ac0b81c16291284c809de13692cc0226e9496613bc8e99465fe731ce191d90?s=96&d=retro&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f3ac0b81c16291284c809de13692cc0226e9496613bc8e99465fe731ce191d90?s=96&d=retro&r=g\",\"caption\":\"Dominik Jirotka\"},\"url\":\"https:\/\/igloonet.cz\/blog\/author\/domino\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Jak dostat data do BigQuery | igloonet blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/igloonet.cz\/blog\/jak-dostat-data-do-bigquery\/","og_locale":"cs_CZ","og_type":"article","og_title":"Jak dostat data do BigQuery | igloonet blog","og_description":"BigQuery dnes pat\u0159\u00ed mezi nejd\u016fle\u017eit\u011bj\u0161\u00ed n\u00e1stroje v&nbsp;digit\u00e1ln\u00ed analytice. Umo\u017e\u0148uje efektivn\u011b zpracov\u00e1vat velk\u00e9 objemy dat, shrom\u00e1\u017edit je na&nbsp;jednom m\u00edst\u011b, sjednotit a&nbsp;pracovat s&nbsp;nimi bez ohledu na&nbsp;to, odkud poch\u00e1zej\u00ed. Jak dat p\u0159ib\u00fdv\u00e1 a&nbsp;jejich kvalita \u010dasto kles\u00e1, roste pot\u0159eba spolehliv\u00e9ho a&nbsp;flexibiln\u00edho datov\u00e9ho skladu. BigQuery nav\u00edc t\u011b\u017e\u00ed z&nbsp;\u00fazk\u00e9 integrace s&nbsp;dal\u0161\u00edmi slu\u017ebami Googlu. Snadno k&nbsp;n\u011bmu p\u0159ipoj\u00edte data z&nbsp;Google Analytics 4, Google Ads, Search Console \u010di Google Play. Mo\u017enosti t\u00edm ale nekon\u010d\u00ed. BigQuery nen\u00ed omezen\u00e9 jen na&nbsp;ofici\u00e1ln\u00ed konektory. Data do&nbsp;n\u011bj lze dostat mnoha r\u016fzn\u00fdmi zp\u016fsoby a&nbsp;stejn\u011b tak","og_url":"https:\/\/igloonet.cz\/blog\/jak-dostat-data-do-bigquery\/","og_site_name":"igloonet blog","article_publisher":"https:\/\/www.facebook.com\/igloonet","article_published_time":"2026-01-08T12:18:31+00:00","article_modified_time":"2026-01-08T14:01:24+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/igloonet.cz\/blog\/wp-content\/uploads\/2026\/01\/BQ1.png","type":"image\/png"}],"author":"Dominik Jirotka","twitter_card":"summary_large_image","twitter_creator":"@igloonet","twitter_site":"@igloonet","twitter_misc":{"Napsal(a)":"Dominik Jirotka","Odhadovan\u00e1 doba \u010dten\u00ed":"14 minut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/igloonet.cz\/blog\/jak-dostat-data-do-bigquery\/#article","isPartOf":{"@id":"https:\/\/igloonet.cz\/blog\/jak-dostat-data-do-bigquery\/"},"author":{"name":"Dominik Jirotka","@id":"https:\/\/igloonet.cz\/blog\/#\/schema\/person\/9260068e4481933e8379d52d272fc53c"},"headline":"Jak dostat data do&nbsp;BigQuery","datePublished":"2026-01-08T12:18:31+00:00","dateModified":"2026-01-08T14:01:24+00:00","mainEntityOfPage":{"@id":"https:\/\/igloonet.cz\/blog\/jak-dostat-data-do-bigquery\/"},"wordCount":3219,"commentCount":0,"publisher":{"@id":"https:\/\/igloonet.cz\/blog\/#organization"},"image":{"@id":"https:\/\/igloonet.cz\/blog\/jak-dostat-data-do-bigquery\/#primaryimage"},"thumbnailUrl":"https:\/\/igloonet.cz\/blog\/wp-content\/uploads\/2026\/01\/BQ1.png","keywords":["data","data-driven","marketing"],"articleSection":["Analytika","Marketing"],"inLanguage":"cs","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/igloonet.cz\/blog\/jak-dostat-data-do-bigquery\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/igloonet.cz\/blog\/jak-dostat-data-do-bigquery\/","url":"https:\/\/igloonet.cz\/blog\/jak-dostat-data-do-bigquery\/","name":"Jak dostat data do BigQuery | igloonet blog","isPartOf":{"@id":"https:\/\/igloonet.cz\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/igloonet.cz\/blog\/jak-dostat-data-do-bigquery\/#primaryimage"},"image":{"@id":"https:\/\/igloonet.cz\/blog\/jak-dostat-data-do-bigquery\/#primaryimage"},"thumbnailUrl":"https:\/\/igloonet.cz\/blog\/wp-content\/uploads\/2026\/01\/BQ1.png","datePublished":"2026-01-08T12:18:31+00:00","dateModified":"2026-01-08T14:01:24+00:00","breadcrumb":{"@id":"https:\/\/igloonet.cz\/blog\/jak-dostat-data-do-bigquery\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/igloonet.cz\/blog\/jak-dostat-data-do-bigquery\/"]}]},{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/igloonet.cz\/blog\/jak-dostat-data-do-bigquery\/#primaryimage","url":"https:\/\/igloonet.cz\/blog\/wp-content\/uploads\/2026\/01\/BQ1.png","contentUrl":"https:\/\/igloonet.cz\/blog\/wp-content\/uploads\/2026\/01\/BQ1.png","width":1200,"height":628,"caption":"Jak dostat data do BigQuery"},{"@type":"BreadcrumbList","@id":"https:\/\/igloonet.cz\/blog\/jak-dostat-data-do-bigquery\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Analytika","item":"https:\/\/igloonet.cz\/blog\/rubriky\/analytika\/"},{"@type":"ListItem","position":2,"name":"Jak dostat data do BigQuery"}]},{"@type":"WebSite","@id":"https:\/\/igloonet.cz\/blog\/#website","url":"https:\/\/igloonet.cz\/blog\/","name":"igloonet blog","description":"","publisher":{"@id":"https:\/\/igloonet.cz\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/igloonet.cz\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"cs"},{"@type":"Organization","@id":"https:\/\/igloonet.cz\/blog\/#organization","name":"igloonet","url":"https:\/\/igloonet.cz\/blog\/","logo":{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/igloonet.cz\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/igloonet.cz\/blog\/wp-content\/uploads\/2015\/07\/RGB_LVPC_igloonet.png","contentUrl":"https:\/\/igloonet.cz\/blog\/wp-content\/uploads\/2015\/07\/RGB_LVPC_igloonet.png","width":650,"height":465,"caption":"igloonet"},"image":{"@id":"https:\/\/igloonet.cz\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/igloonet","https:\/\/x.com\/igloonet","https:\/\/instagram.com\/igloonet\/","https:\/\/www.linkedin.com\/company\/igloonet"]},{"@type":"Person","@id":"https:\/\/igloonet.cz\/blog\/#\/schema\/person\/9260068e4481933e8379d52d272fc53c","name":"Dominik Jirotka","image":{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/igloonet.cz\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f3ac0b81c16291284c809de13692cc0226e9496613bc8e99465fe731ce191d90?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f3ac0b81c16291284c809de13692cc0226e9496613bc8e99465fe731ce191d90?s=96&d=retro&r=g","caption":"Dominik Jirotka"},"url":"https:\/\/igloonet.cz\/blog\/author\/domino\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/igloonet.cz\/blog\/wp-json\/wp\/v2\/posts\/8531","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/igloonet.cz\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/igloonet.cz\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/igloonet.cz\/blog\/wp-json\/wp\/v2\/users\/48"}],"replies":[{"embeddable":true,"href":"https:\/\/igloonet.cz\/blog\/wp-json\/wp\/v2\/comments?post=8531"}],"version-history":[{"count":4,"href":"https:\/\/igloonet.cz\/blog\/wp-json\/wp\/v2\/posts\/8531\/revisions"}],"predecessor-version":[{"id":8544,"href":"https:\/\/igloonet.cz\/blog\/wp-json\/wp\/v2\/posts\/8531\/revisions\/8544"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/igloonet.cz\/blog\/wp-json\/wp\/v2\/media\/8532"}],"wp:attachment":[{"href":"https:\/\/igloonet.cz\/blog\/wp-json\/wp\/v2\/media?parent=8531"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/igloonet.cz\/blog\/wp-json\/wp\/v2\/categories?post=8531"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/igloonet.cz\/blog\/wp-json\/wp\/v2\/tags?post=8531"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}