{"id":31936,"date":"2022-06-11T09:24:00","date_gmt":"2022-06-11T07:24:00","guid":{"rendered":"https:\/\/fotc.com\/bigquery-ce-este-tutorial\/"},"modified":"2023-05-11T10:02:03","modified_gmt":"2023-05-11T08:02:03","slug":"bigquery-ce-este-tutorial","status":"publish","type":"post","link":"https:\/\/fotc.com\/ro\/blog\/bigquery-ce-este-tutorial\/","title":{"rendered":"BigQuery \u2013 ce este \u0219i cum s\u0103 \u00eencepe\u021bi? [Tutorial]"},"content":{"rendered":"\n<div class=\"wp-block-yoast-seo-table-of-contents yoast-table-of-contents collapsed\"><h2>     Cuprins       <\/h2><ul><li><a href=\"#h-ce-este-bigquery-de-la-google\" data-level=\"2\">Ce este BigQuery de la Google?<\/a><ul><li><a href=\"#h-tehnologie-f-r-servere\" data-level=\"3\">Tehnologie f\u0103r\u0103 servere<\/a><\/li><li><a href=\"#h-analiz-instantanee\" data-level=\"3\">Analiz\u0103 instantanee<\/a><\/li><li><a href=\"#h-costuri-flexibile\" data-level=\"3\">Costuri flexibile<\/a><\/li><li><a href=\"#h-f-r-interferen-e-n-codul-surs\" data-level=\"3\">F\u0103r\u0103 interferen\u021be \u00een codul surs\u0103<\/a><\/li><li><a href=\"#h-copie-de-rezerv-automat\" data-level=\"3\">Copie de rezerv\u0103 automat\u0103<\/a><\/li><li><a href=\"#h-analiza-datelor-din-diferite-surse\" data-level=\"3\">Analiza datelor din diferite surse<\/a><\/li><li><a href=\"#h-suport-pentru-machine-learning-ml\" data-level=\"3\">Suport pentru machine learning (ML)<\/a><\/li><li><a href=\"#h-analize-de-afaceri-bi\" data-level=\"3\">Analize de afaceri (BI)<\/a><\/li><\/ul><\/li><li><a href=\"#h-exemple-de-utilizare-bigquery\" data-level=\"2\">Exemple de utilizare BigQuery<\/a><\/li><li><a href=\"#h-cum-s-ncep-cu-bigquery-ghid-pas-cu-pas\" data-level=\"2\">Cum s\u0103 \u00eencep cu BigQuery? Ghid pas cu pas<\/a><\/li><li><a href=\"#h-afla-i-posibilit-ile-gcp-i-bigquery\" data-level=\"2\">Afla\u021bi posibilit\u0103\u021bile GCP \u0219i BigQuery<\/a><\/li><\/ul><\/div>\n\n\n\n<p><span>Datele reprezint\u0103 noul aur &#8211; companiile \u0219i organiza\u021biile orientate spre dezvoltare sunt con\u0219tiente de acest lucru. Companiile con\u0219tiente analizeaz\u0103 procesele existente, fac modific\u0103ri \u0219i \u00eembun\u0103t\u0103\u021biri pe baza cifrelor. Unii merg mai departe &#8211; cu tool-uri precum BigQuery de la Google \u2013 profit\u00e2nd de oportunit\u0103\u021bile oferite de tehnologie, anticipeaz\u0103 tendin\u021bele, posibilele schimb\u0103ri de pe pia\u021b\u0103, efectele deciziilor de afaceri care \u00eenc\u0103 nu au fost luate.<\/span><br>\n<\/p>\n\n\n\n<!--more-->\n\n\n\n<p><span>Pe m\u0103sur\u0103 ce afacerea cre\u0219te, seturile de date se extind \u2013 gigaocte\u021bii se transform\u0103 \u00een teraocte\u021bi sau petaocte\u021bi.&nbsp; Pentru a men\u021bine un nivel adecvat al costurilor de \u00eentre\u021binere a instrumentului de analiz\u0103 \u0219i un timp relativ scurt de generare a rapoartelor, trebuie s\u0103 face\u021bi alegerea corect\u0103 \u00een ceea ce prive\u0219te tehnologia. \u00cen ajutor v\u0103 vine <strong>BigQuery \u2013 un serviciu dedicat efectu\u0103rii de analize BigData. Acesta angreneaz\u0103 mai multe instrumente de analiz\u0103, printre altele, popularul Google Analytics<\/strong>.<\/span><\/p>\n\n\n\n<h2 id=\"h-ce-este-bigquery-de-la-google\"><span>Ce este BigQuery<\/span> <span>de la Google?<\/span><\/h2>\n\n\n\n<p><span>Acesta este un depozit de date scalabil \u00een cloud (cloud data warehouse).&nbsp; El permite deservirea a milioane de interog\u0103ri (query) \u0219i <strong>efectuarea de analize avansate de petabytes de date \u00een limbajul SQL<\/strong>, f\u0103r\u0103 a fi nevoie s\u0103 v\u0103 face\u021bi griji cu privire la \u00eentre\u021binerea costisitoare a unei infrastructurii avansate.<\/span><\/p>\n\n\n\n<p><span>BigQuery este unul dintre serviciile disponibile \u00een <\/span><a href=\"https:\/\/fotc.com\/ro\/google-cloud-platform\/\"><span>Google Cloud Platform (GCP)<\/span><\/a><span>.<\/span><span><strong> Stocarea \u0219i procesarea seturilor de date se desf\u0103\u0219oar\u0103 \u00een cloud, pe o infrastructur\u0103 GCP stabil\u0103, sigur\u0103 \u0219i scalabil\u0103<\/strong> (aici ve\u021bi afla mai multe despre <\/span><a href=\"https:\/\/fotc.com\/ro\/blog\/google-cloud-platform-ce-este\/\"><span>ce este Google Cloud Platform \u0219i cum sus\u021bine afacerile<\/span><\/a><span>).<\/span><\/p>\n\n\n\n<p><span>Cu ajutorul serviciului, pute\u021bi crea propriul instrument de analiz\u0103 pentru a urm\u0103ri dezvoltarea, procesele sau modific\u0103rile \u00een curs \u2013 de exemplu, \u00een interiorul sau \u00een jurul companiei. \u00cen combina\u021bie cu \u00eenv\u0103\u021barea automatizat\u0103 (ML \u2013 machine learning), permite construirea unui sistem care, de exemplu, va anticipa apari\u021bia diver\u0219ilor factori \u0219i va lua \u00een considerare efectele lor poten\u021biale. BigQuery v\u0103 poate ajuta, de asemenea, s\u0103 optimiza\u021bi performan\u021ba \u0219i costurile de \u00eentre\u021binere ale unui sistem de analiz\u0103 BigData existent.<\/span><\/p>\n\n\n\n<h3 id=\"h-tehnologie-f-r-servere\"><span>Tehnologie f\u0103r\u0103 servere<\/span><\/h3>\n\n\n\n<p><span>BigQuery este un depozit de date \u00een cloud. Utiliz\u00e2nd serviciile Google Cloud Platform, v\u0103 pute\u021bi concentra pe scalarea afacerii \u0219i pe extragerea din analiz\u0103 a ceea ce este mai bun. <strong>Nu trebuie s\u0103 petrece\u021bi timp suplimentar \u0219i buget pentru men\u021binerea infrastructurii<\/strong>, efectuarea actualiz\u0103rilor sau asigurarea unui nivel adecvat de securitate a serverelor.<\/span><\/p>\n\n\n\n<h3 id=\"h-analiz-instantanee\"><span>Analiz\u0103 instantanee<\/span><\/h3>\n\n\n\n<p><span>Pentru prelucrarea a terabytes de date BigQuery are nevoie de c\u00e2teva secunde, iar pentru un petabyte \u2013 de aprox. 3 minute. Depozitele (warehouses) proceseaz\u0103 seturi mari de date de c\u00e2teva zeci de ori mai rapid dec\u00e2t sistemele de baze de date. <strong>Acest lucru v\u0103 permite s\u0103 efectua\u021bi analize chiar \u0219i \u00een timp real \u0219i s\u0103 observa\u021bi modific\u0103rile \u00een timp real.<\/strong><\/span><\/p>\n\n\n\n<h3 id=\"h-costuri-flexibile\"><span>Costuri flexibile<\/span><\/h3>\n\n\n\n<p><span>Costul serviciului BigQuery se ajusteaz\u0103 la cerin\u021bele curente ale afacerii dvs. <strong>Ca \u0219i \u00een cazul GCP, se pl\u0103te\u0219te \u00een func\u021bie de consum<\/strong>. Costul de stocare a datelor (data storage) este de 20 USD\/TB. Dac\u0103 datele nu sunt prelucrate timp de 90 de zile sau mai mult, pachetul se modific\u0103 \u00een stocare pe termen lung, iar pre\u021bul serviciului scade cu 50%. Prelucrarea datelor cost\u0103 5 USD\/TB, iar primul terabyte \u00een fiecare lun\u0103 este gratuit.<\/span><\/p>\n\n\n\n<p><span>Aceast\u0103 metod\u0103 de tarifare se traduce \u00eentr-un <strong>TCO (total cost of ownership) mai mic \u00een medie cu 30% pe parcursul a trei ani<\/strong> dec\u00e2t \u00een cazul altor solu\u021bii de analiz\u0103 BigData.&nbsp; <\/span><\/p>\n\n\n\n<h3 id=\"h-f-r-interferen-e-n-codul-surs\"><span>F\u0103r\u0103 interferen\u021be \u00een codul surs\u0103<\/span><\/h3>\n\n\n\n<p><span>Pentru a utiliza BigQuery, <strong>nu este nevoie s\u0103 efectua\u021bi modific\u0103ri majore sau s\u0103 rescrie\u021bi codul surs\u0103.<\/strong> Asta pentru c\u0103 BigQuery accept\u0103 ANSI SQL:2011 \u0219i ofer\u0103 interfe\u021be software gratuite ODBC \u0219i JDBC.<\/span><\/p>\n\n\n\n<h3 id=\"h-copie-de-rezerv-automat\"><span>Copie de rezerv\u0103 automat\u0103<\/span><\/h3>\n\n\n\n<p><span>Instrumentul efectueaz\u0103 un backup automat \u0219i stocheaz\u0103 istoricul modific\u0103rilor timp de 7 zile. Acest lucru faciliteaz\u0103 compararea rezultatelor cu perioada anterioar\u0103 sau restabilirea datelor.<\/span><\/p>\n\n\n\n<h3 id=\"h-analiza-datelor-din-diferite-surse\"><span>Analiza datelor din diferite surse<\/span><\/h3>\n\n\n\n<p><span>Cu <strong>BigQuery<\/strong>, pute\u021bi analiza date provenite dintr-o varietate de surse \u2013 din Google Marketing Platform, Google Analytics, YouTube \u0219i sute de aplica\u021bii externe SaaS. De asemenea, pute\u021bi muta datele \u00een BigQuery din alte solu\u021bii de infrastructur\u0103 dec\u00e2t GCP.<\/span><\/p>\n\n\n\n<h3 id=\"h-suport-pentru-machine-learning-ml\"><span>Suport pentru machine learning (ML)<\/span><\/h3>\n\n\n\n<p><span>Una dintre func\u021biile disponibile este BigQuery ML, dedicat\u0103 pentru crearea \u0219i dezvoltarea capacit\u0103\u021bii de \u00eenv\u0103\u021bare automatizat\u0103 folosind interog\u0103ri SQL standard. BigQuery ML \u00eembun\u0103t\u0103\u021be\u0219te viteza de dezvoltare a produselor care accept\u0103 \u00eenv\u0103\u021barea automatizat\u0103, reduc\u00e2nd \u00een acela\u0219i timp cerin\u021bele pentru scrierea codului surs\u0103 \u0219i mutarea datelor.<\/span><\/p>\n\n\n\n<h3 id=\"h-analize-de-afaceri-bi\"><span>Analize de afaceri (BI)<\/span><\/h3>\n\n\n\n<p><span>BigQuery este un instrument excelent pentru efectuarea de analize de afaceri (BI \u2013 business intelligence).&nbsp; Serviciul permite <strong>analizarea unor seturi uria\u0219e de date \u0219i crearea de rapoarte extinse \u00een c\u00e2teva secunde<\/strong>. \u00cen acela\u0219i mod, sprijin\u0103 crearea de rapoarte &#8220;ad hoc&#8221; \u2013 adic\u0103 rapoarte care includ un set definit de date \u0219i nu necesit\u0103 implicarea departamentului de analize sau IT pentru a preg\u0103ti un sumar.<\/span><\/p>\n\n\n\n<p><span>\u00cen ambele cazuri, rapoartele pot fi prezentate utiliz\u00e2nd instrumente de vizualizare a datelor, cum ar fi Google Data Studio, Looker \u0219i Tableau.<\/span><\/p>\n\n\n\n<h2 id=\"h-exemple-de-utilizare-bigquery\"><span>Exemple de utilizare BigQuery<\/span><\/h2>\n\n\n\n<p><span>Iat\u0103 c\u00e2teva exemple de utilizare a capacit\u0103\u021bilor BigQuery de c\u0103tre companii bine-cunoscute:<\/span><\/p>\n\n\n\n<ul><li><span><strong>UPS<\/strong> colecteaz\u0103 zilnic date despre sute de mii de expedieri \u2013 inclusiv greutatea, dimensiunile, loca\u021bia acestora. Prin utilizarea capacit\u0103\u021bilor de \u00eenv\u0103\u021bare automatizat\u0103 \u0219i de analiz\u0103 a datelor, compania este capabil\u0103 s\u0103 determine exact cum s\u0103 \u00eencarce ma\u0219inile de livrare \u0219i containerele pentru a cre\u0219te c\u00e2t mai mult eficien\u021ba. Sistemul permite, de asemenea, preg\u0103tirea pentru perioade de trafic crescut \u2013 de exemplu, \u00een preajma Cr\u0103ciunului;<\/span><\/li><li><span><strong>20th Century Fox<\/strong> utilizeaz\u0103 serviciile Google Cloud, inclusiv BigQuery \u0219i capacit\u0103\u021bile machine learning. Creeaz\u0103 modele de preferin\u021be ale vizitatorilor \u0219i analizeaz\u0103 clipurile promo\u021bionale ale filmelor pentru a determina c\u00e2t succes va avea o anumit\u0103 produc\u021bie;<\/span><\/li><li><span><strong>Safari Books Online<\/strong> este o bibliotec\u0103 online cu milioane de utilizatori care const\u0103 din peste 30000 de c\u0103r\u021bi \u0219i filme. Safari Books Online folose\u0219te BigQuery pentru a gestiona datele pe care le de\u021bine deja \u0219i pentru potrivi cel mai bine sugestiile de titluri \u0219i cele mai bune oferte pentru cititori;<\/span><\/li><li><span><strong>Dow Jones (DJIA)<\/strong> este unul dintre cei mai mari indici bursieri care include companii precum Apple, Amazon si Boeing. Folosind BigQuery \u0219i ML, Dow creeaz\u0103 platforma Data, News &amp; Analytics Platform (DNA) care permite companiilor s\u0103 analizeze efectele evenimentelor \u2013 de exemplu, ce schimb\u0103ri au fost cauzate la burs\u0103 de uraganul Irma;<\/span><\/li><li><span><strong>Spotify<\/strong>, cu ajutorul BigQuery, aduce utilizatorului melodia aleas\u0103 \u00een c\u00e2teva momente dup\u0103 ap\u0103sarea butonului de redare play&nbsp; Nu ar fi fost nimic neobi\u0219nuit dac\u0103 platforma nu ar fi fost folosit\u0103 de mai mult de 200 de milioane de utilizatori, iar \u00een fiecare zi sunt ad\u0103ugate 40.000 de melodii \u0219i \u00eenregistr\u0103ri noi.<\/span><\/li><\/ul>\n\n\n\n<h2 id=\"h-cum-s-ncep-cu-bigquery-ghid-pas-cu-pas\">Cum s\u0103 \u00eencep cu BigQuery? Ghid pas cu pas<\/h2>\n\n\n\n<p><span>Pentru a \u00eencepe utilizarea BigQuery, trebuie s\u0103 ave\u021bi un cont pe <strong>Google Cloud Platform<\/strong>. De asemenea, trebuie s\u0103 <strong>cuno\u0219te\u021bi limbajul SQL<\/strong>.<\/span><\/p>\n\n\n\n<p><span>Accesa\u021bi site-ul <\/span><a href=\"https:\/\/console.cloud.google.com\/\"><span>consolei Google.<\/span><\/a><span>&nbsp;&nbsp;<\/span><\/p>\n\n\n\n<p><span>Selecta\u021bi proiectul la care ve\u021bi lucra. Lista de proiecte se afl\u0103 \u00een meniul vertical de l\u00e2ng\u0103 titlul <strong>Google Cloud Platform<\/strong>.<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/fotc.com\/app\/uploads\/2021\/08\/image01.png\" alt=\"jak zaczac z BigQuery krok 1\" class=\"wp-image-31820\"\/><\/figure>\n\n\n\n<p><span>Dup\u0103 ce a\u021bi selectat un proiect, activa\u021bi <strong>Cloudshell<\/strong> \u00een col\u021bul din dreapta sus.<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/fotc.com\/app\/uploads\/2021\/08\/image02.png\" alt=\"jak zaczac z BigQuery krok 2\" class=\"wp-image-31824\"\/><\/figure>\n\n\n\n<p>Ve\u021bi ob\u021bine aceast\u0103 vizualizare:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/fotc.com\/app\/uploads\/2021\/08\/image03-1024x344.png\" alt=\"jak zaczac z BigQuery krok 3\" class=\"wp-image-31828\"\/><\/figure>\n\n\n\n<p>Pentru a vedea cum arat\u0103 baza de date \u0219i pentru a revizui informa\u021biile generale (schem\u0103, num\u0103r de r\u00e2nduri, dimensiuni \u00een octe\u021bi), utiliza\u021bi urm\u0103toarea comand\u0103:<\/p>\n\n\n<pre class=\"brush: xml; title: ; notranslate\" title=\"\">bq show bigquery-public-data:samples.shakespeare<\/pre>\n\n\n\n<p>Rezultatul interog\u0103rii va ar\u0103ta astfel:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/fotc.com\/app\/uploads\/2021\/08\/image04.png\" alt=\"jak zaczac z BigQuery krok 4\" class=\"wp-image-31832\"\/><\/figure>\n\n\n\n<p>\u00cen comenzile bq, vom folosi steagul <strong>\u2013use_leagcy_sql<\/strong> &#8211; acesta seteaz\u0103 SQL standard drept limb\u0103 de interogare.<\/p>\n\n\n\n<p><span>Pentru a valida \u0219i a verifica interogarea (query), este \u00eendeajuns s\u0103 ad\u0103uga\u021bi un steag dry_run. Iat\u0103 cum arat\u0103 un exemplu de interogare cu acest steag:<\/span><\/p>\n\n\n<pre class=\"brush: xml; title: ; notranslate\" title=\"\">bq query --use_legacy_sql=false --dry_run \\\n'SELECT\nword\nFROM\n`bigquery-public-data`.samples.shakespeare\nLIMIT 5'<\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/fotc.com\/app\/uploads\/2021\/08\/image05-1024x37.png\" alt=\"jak zaczac z BigQuery krok 5\" class=\"wp-image-31836\"\/><\/figure>\n\n\n\n<p><span>Dac\u0103 interogarea trimis\u0103 c\u0103tre baza de date este corect\u0103, pute\u021bi vedea r\u0103spunsul acesteia elimin\u00e2nd steagul <strong>\u2013dry_run<\/strong><\/span><\/p>\n\n\n<pre class=\"brush: xml; title: ; notranslate\" title=\"\">bq query --use_legacy_sql=false \\\n'SELECT\nword\nFROM\n`bigquery-public-data`.samples.shakespeare\nLIMIT 5'<\/pre>\n\n\n\n<p><span>Acesta este un exemplu de rezultat al unei astfel de interog\u0103ri:<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/fotc.com\/app\/uploads\/2021\/08\/image06.png\" alt=\"jak zaczac z BigQuery krok 6\" class=\"wp-image-31840\"\/><\/figure>\n\n\n\n<p><span>Pentru a extrage anumite date din \u00eenregistr\u0103ri, poate fi utilizat\u0103 clauza where care selecteaz\u0103 datele \u00een func\u021bie de o anumit\u0103 valoare, regul\u0103 sau expresie regulat\u0103. Dac\u0103 dori\u021bi s\u0103 extrage\u021bi din baza de date numai \u00eenregistr\u0103rile care con\u021bin \u00een coloana <strong>word<\/strong> cuv\u00e2ntul <\/span><i><span>raising<\/span><\/i><span>, este \u00eendeajuns s\u0103 utiliza\u021bi urm\u0103toarea interogare:<\/span><\/p>\n\n\n<pre class=\"brush: xml; title: ; notranslate\" title=\"\">bq query --use_legacy_sql=false --dry_run \\\n'SELECT\nword\nFROM\n`bigquery-public-data`.samples.shakespeare\nWHERE\nword = raising\nLIMIT 5'<\/pre>\n\n\n\n<p><span>Mai \u00eent\u00e2i, valida\u021bi interogarea.<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/fotc.com\/app\/uploads\/2021\/08\/image07-1024x39.png\" alt=\"jak zaczac z BigQuery krok 7\" class=\"wp-image-31844\"\/><\/figure>\n\n\n\n<p>Apoi, efectua\u021bi comanda de mai jos, f\u0103r\u0103 \u2013dry_run:<\/p>\n\n\n<pre class=\"brush: xml; title: ; notranslate\" title=\"\">bq query --use_legacy_sql=false \\\n'SELECT\nword\nFROM\n`bigquery-public-data`.samples.shakespeare\nWHERE\nword = raising\nLIMIT 5'<\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/fotc.com\/app\/uploads\/2021\/08\/image08.png\" alt=\"jak zaczac z BigQuery krok 8\" class=\"wp-image-31848\"\/><\/figure>\n\n\n\n<p>Dac\u0103 dori\u021bi s\u0103 afla\u021bi c\u00e2te asemenea \u00eenregistr\u0103ri sunt \u00een baza de date, utiliza\u021bi func\u021bia de agregare <strong>COUNT (\u00eenregistrarea pe care dori\u021bi s\u0103 o num\u0103ra\u021bi)<\/strong>. Interogarea ar trebui s\u0103 arate \u00een modul urm\u0103tor:<\/p>\n\n\n<pre class=\"brush: xml; title: ; notranslate\" title=\"\">bq query --use_legacy_sql=false \\\n'SELECT\nCOUNT(word) as num_of_words\nFROM\n`bigquery-public-data`.samples.shakespeare\nWHERE\nword = raising\u2019<\/pre>\n\n\n\n<p><span><br>\nFiec\u0103rui tabel i se poate ad\u0103uga propria denumire folosind cuv\u00e2ntul cheie <strong>as<\/strong>. \u00cen acest caz, avem un nume care descrie ce a fost agregat \u00een coloana dat\u0103. Rezultatul interog\u0103rii arat\u0103 dup\u0103 cum urmeaz\u0103:<br>\n<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/fotc.com\/app\/uploads\/2021\/08\/image09.png\" alt=\"jak zaczac z BigQuery krok 9\" class=\"wp-image-31852\"\/><\/figure>\n\n\n\n<p><span>S\u0103 presupunem c\u0103 dori\u021bi s\u0103 g\u0103si\u021bi toate pozi\u021biile care con\u021bin cuv\u00e2ntul <\/span><i><span>raisin.<\/span><\/i><span> \u00cen acest caz, utiliza\u021bi cuv\u00e2ntul cheie LIKE care v\u0103 va ajuta s\u0103 c\u0103uta\u021bi dup\u0103 cuv\u00e2ntul-cheie specificat.<\/span><\/p>\n\n\n\n<p><span>Dac\u0103 plasa\u021bi semnul <strong>%<\/strong> \u00eenaintea cuv\u00e2ntului de c\u0103utare, sistemul va include, de asemenea, rezultate cu prefix, de exemplu, dispraisin.&nbsp; Dac\u0103 ad\u0103uga\u021bi acest caracter \u00een ambele p\u0103r\u021bi, de exemplu,<strong> %raisin%<\/strong>, ve\u021bi ob\u021bine rezultate care includ prefix \u0219i sufix, de exemplu, <strong>dispraisingly%<\/strong><\/span><\/p>\n\n\n\n<p><span>C\u00e2nd ave\u021bi mai multe coloane cu o func\u021bie de agregare, trebuie s\u0103 indica\u021bi comanda <strong>GROUP BY<\/strong> care va defini \u00een func\u021bie de ce coloane dori\u021bi s\u0103 grupa\u021bi r\u00e2ndurile. <\/span><\/p>\n\n\n<pre class=\"brush: xml; title: ; notranslate\" title=\"\">bq query --use_legacy_sql=false \\\n'SELECT\nword,\nCOUNT(word_count) AS count\nFROM\n`bigquery-public-data`.samples.shakespeare\nWHERE\nword LIKE %raisin%\nGROUP BY\nword'<\/pre>\n\n\n\n<p><span>Rezultatul interog\u0103rii este dup\u0103 urmeaz\u0103:<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/fotc.com\/app\/uploads\/2021\/08\/image10-1.png\" alt=\"jak zaczac z BigQuery krok 10\" class=\"wp-image-31856\"\/><\/figure>\n\n\n\n<h2 id=\"h-afla-i-posibilit-ile-gcp-i-bigquery\"><span>Afla\u021bi posibilit\u0103\u021bile GCP \u0219i BigQuery<\/span><\/h2>\n\n\n\n<p><span>Poten\u021bialul BigQuery poate fi descoperit cel mai bine \u00een practic\u0103. Dac\u0103 dori\u021bi s\u0103 afla\u021bi ce posibilit\u0103\u021bi ofer\u0103 solu\u021biile Google Cloud (inclusiv serviciul de analiz\u0103 descris) companiei dvs., <\/span><a href=\"https:\/\/fotc.com\/ro\/contact\/\"><span>contacta\u021bi un partener certificat Google Cloud Premier Partner.<\/span><\/a><span>&nbsp;&nbsp;<\/span><\/p>\n\n\n\n<p><span>Ve\u021bi primi un voucher \u00een valoare de <strong>500 USD<\/strong> pentru primele activit\u0103\u021bi pe Google Cloud Platform, iar speciali\u0219tii FOTC v\u0103 vor ajuta s\u0103 descoperi\u021bi poten\u021bialul BigQuery.&nbsp; <\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Datele reprezint\u0103 noul aur &#8211; companiile \u0219i organiza\u021biile orientate spre dezvoltare sunt con\u0219tiente de acest lucru. Companiile con\u0219tiente analizeaz\u0103 procesele existente, fac modific\u0103ri \u0219i \u00eembun\u0103t\u0103\u021biri pe baza cifrelor. Unii merg mai departe &#8211; cu tool-uri precum BigQuery de la Google \u2013 profit\u00e2nd de oportunit\u0103\u021bile oferite de tehnologie, anticipeaz\u0103 tendin\u021bele, posibilele schimb\u0103ri de pe pia\u021b\u0103, efectele&#8230;<\/p>\n","protected":false},"author":13,"featured_media":20340,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_editorskit_title_hidden":false,"_editorskit_reading_time":7,"_editorskit_typography_data":[],"_editorskit_blocks_typography":"","_editorskit_is_block_options_detached":false,"_editorskit_block_options_position":"{}"},"categories":[562],"tags":[192,193,139],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v16.7 (Yoast SEO v19.6) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>BigQuery \u2013 ce este \u0219i cum s\u0103 \u00eencepe\u021bi? [Tutorial] - FOTC<\/title>\n<meta name=\"description\" content=\"BigQuery este un serviciu Google Cloud Platform care este utilizat pentru stocarea \u0219i procesarea a terabytes \u0219i petabytes de date. Dac\u0103 ave\u021bi sau dori\u021bi s\u0103 crea\u021bi un instrument de analiz\u0103 BigData, verifica\u021bi ce v\u0103 poate oferi BigQuery \u0219i cum pute\u021bi s\u0103 \u00eencepe\u021bi utilizarea serviciului.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fotc.com\/ro\/blog\/bigquery-ce-este-tutorial\/\" \/>\n<meta property=\"og:locale\" content=\"ro_RO\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"BigQuery \u2013 ce este \u0219i cum s\u0103 \u00eencepe\u021bi? [Tutorial]\" \/>\n<meta property=\"og:description\" content=\"BigQuery este un serviciu Google Cloud Platform care este utilizat pentru stocarea \u0219i procesarea a terabytes \u0219i petabytes de date. Dac\u0103 ave\u021bi sau dori\u021bi s\u0103 crea\u021bi un instrument de analiz\u0103 BigData, verifica\u021bi ce v\u0103 poate oferi BigQuery \u0219i cum pute\u021bi s\u0103 \u00eencepe\u021bi utilizarea serviciului.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fotc.com\/ro\/blog\/bigquery-ce-este-tutorial\/\" \/>\n<meta property=\"og:site_name\" content=\"FOTC\" \/>\n<meta property=\"article:published_time\" content=\"2022-06-11T07:24:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-11T08:02:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/fotc.com\/app\/uploads\/2021\/08\/BigQuery-co-to-jest-i-jak-zaczac_RO.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=\"Ida O\u017carowska\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fotc.com\/ro\/blog\/bigquery-ce-este-tutorial\/\",\"url\":\"https:\/\/fotc.com\/ro\/blog\/bigquery-ce-este-tutorial\/\",\"name\":\"BigQuery \u2013 ce este \u0219i cum s\u0103 \u00eencepe\u021bi? [Tutorial] - FOTC\",\"isPartOf\":{\"@id\":\"https:\/\/fotc.com\/#website\"},\"datePublished\":\"2022-06-11T07:24:00+00:00\",\"dateModified\":\"2023-05-11T08:02:03+00:00\",\"author\":{\"@id\":\"https:\/\/fotc.com\/#\/schema\/person\/84a7428ea802a35722a1839225ab0dfb\"},\"description\":\"BigQuery este un serviciu Google Cloud Platform care este utilizat pentru stocarea \u0219i procesarea a terabytes \u0219i petabytes de date. Dac\u0103 ave\u021bi sau dori\u021bi s\u0103 crea\u021bi un instrument de analiz\u0103 BigData, verifica\u021bi ce v\u0103 poate oferi BigQuery \u0219i cum pute\u021bi s\u0103 \u00eencepe\u021bi utilizarea serviciului.\",\"breadcrumb\":{\"@id\":\"https:\/\/fotc.com\/ro\/blog\/bigquery-ce-este-tutorial\/#breadcrumb\"},\"inLanguage\":\"ro-RO\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fotc.com\/ro\/blog\/bigquery-ce-este-tutorial\/\"]}],\"accessibilityFeature\":[\"tableOfContents\"]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fotc.com\/ro\/blog\/bigquery-ce-este-tutorial\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"RO\",\"item\":\"https:\/\/fotc.com\/ro\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google Cloud\",\"item\":\"https:\/\/fotc.com\/pl\/blog\/category\/google-cloud-platform-pl\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"BigQuery \u2013 ce este \u0219i cum s\u0103 \u00eencepe\u021bi? [Tutorial]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fotc.com\/#website\",\"url\":\"https:\/\/fotc.com\/\",\"name\":\"FOTC\",\"description\":\"Partner Google Cloud\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fotc.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"ro-RO\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/fotc.com\/#\/schema\/person\/84a7428ea802a35722a1839225ab0dfb\",\"name\":\"Ida O\u017carowska\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ro-RO\",\"@id\":\"https:\/\/fotc.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e05ba028ea67bd9a1d51e046729088a9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e05ba028ea67bd9a1d51e046729088a9?s=96&d=mm&r=g\",\"caption\":\"Ida O\u017carowska\"},\"description\":\"Ida has a Master's Degree in Communication Management from the University of Wroc\u0142aw. For over 7 years, she has been creating content that connects the worlds of technology and business. At FOTC, she is a Content Manager.\",\"url\":\"https:\/\/fotc.com\/ro\/blog\/author\/ida-ozarowska\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"BigQuery \u2013 ce este \u0219i cum s\u0103 \u00eencepe\u021bi? [Tutorial] - FOTC","description":"BigQuery este un serviciu Google Cloud Platform care este utilizat pentru stocarea \u0219i procesarea a terabytes \u0219i petabytes de date. Dac\u0103 ave\u021bi sau dori\u021bi s\u0103 crea\u021bi un instrument de analiz\u0103 BigData, verifica\u021bi ce v\u0103 poate oferi BigQuery \u0219i cum pute\u021bi s\u0103 \u00eencepe\u021bi utilizarea serviciului.","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:\/\/fotc.com\/ro\/blog\/bigquery-ce-este-tutorial\/","og_locale":"ro_RO","og_type":"article","og_title":"BigQuery \u2013 ce este \u0219i cum s\u0103 \u00eencepe\u021bi? [Tutorial]","og_description":"BigQuery este un serviciu Google Cloud Platform care este utilizat pentru stocarea \u0219i procesarea a terabytes \u0219i petabytes de date. Dac\u0103 ave\u021bi sau dori\u021bi s\u0103 crea\u021bi un instrument de analiz\u0103 BigData, verifica\u021bi ce v\u0103 poate oferi BigQuery \u0219i cum pute\u021bi s\u0103 \u00eencepe\u021bi utilizarea serviciului.","og_url":"https:\/\/fotc.com\/ro\/blog\/bigquery-ce-este-tutorial\/","og_site_name":"FOTC","article_published_time":"2022-06-11T07:24:00+00:00","article_modified_time":"2023-05-11T08:02:03+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/fotc.com\/app\/uploads\/2021\/08\/BigQuery-co-to-jest-i-jak-zaczac_RO.png","type":"image\/png"}],"author":"Ida O\u017carowska","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/fotc.com\/ro\/blog\/bigquery-ce-este-tutorial\/","url":"https:\/\/fotc.com\/ro\/blog\/bigquery-ce-este-tutorial\/","name":"BigQuery \u2013 ce este \u0219i cum s\u0103 \u00eencepe\u021bi? [Tutorial] - FOTC","isPartOf":{"@id":"https:\/\/fotc.com\/#website"},"datePublished":"2022-06-11T07:24:00+00:00","dateModified":"2023-05-11T08:02:03+00:00","author":{"@id":"https:\/\/fotc.com\/#\/schema\/person\/84a7428ea802a35722a1839225ab0dfb"},"description":"BigQuery este un serviciu Google Cloud Platform care este utilizat pentru stocarea \u0219i procesarea a terabytes \u0219i petabytes de date. Dac\u0103 ave\u021bi sau dori\u021bi s\u0103 crea\u021bi un instrument de analiz\u0103 BigData, verifica\u021bi ce v\u0103 poate oferi BigQuery \u0219i cum pute\u021bi s\u0103 \u00eencepe\u021bi utilizarea serviciului.","breadcrumb":{"@id":"https:\/\/fotc.com\/ro\/blog\/bigquery-ce-este-tutorial\/#breadcrumb"},"inLanguage":"ro-RO","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fotc.com\/ro\/blog\/bigquery-ce-este-tutorial\/"]}],"accessibilityFeature":["tableOfContents"]},{"@type":"BreadcrumbList","@id":"https:\/\/fotc.com\/ro\/blog\/bigquery-ce-este-tutorial\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"RO","item":"https:\/\/fotc.com\/ro\/"},{"@type":"ListItem","position":2,"name":"Google Cloud","item":"https:\/\/fotc.com\/pl\/blog\/category\/google-cloud-platform-pl\/"},{"@type":"ListItem","position":3,"name":"BigQuery \u2013 ce este \u0219i cum s\u0103 \u00eencepe\u021bi? [Tutorial]"}]},{"@type":"WebSite","@id":"https:\/\/fotc.com\/#website","url":"https:\/\/fotc.com\/","name":"FOTC","description":"Partner Google Cloud","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fotc.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"ro-RO"},{"@type":"Person","@id":"https:\/\/fotc.com\/#\/schema\/person\/84a7428ea802a35722a1839225ab0dfb","name":"Ida O\u017carowska","image":{"@type":"ImageObject","inLanguage":"ro-RO","@id":"https:\/\/fotc.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e05ba028ea67bd9a1d51e046729088a9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e05ba028ea67bd9a1d51e046729088a9?s=96&d=mm&r=g","caption":"Ida O\u017carowska"},"description":"Ida has a Master's Degree in Communication Management from the University of Wroc\u0142aw. For over 7 years, she has been creating content that connects the worlds of technology and business. At FOTC, she is a Content Manager.","url":"https:\/\/fotc.com\/ro\/blog\/author\/ida-ozarowska\/"}]}},"_links":{"self":[{"href":"https:\/\/fotc.com\/ro\/wp-json\/wp\/v2\/posts\/31936"}],"collection":[{"href":"https:\/\/fotc.com\/ro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fotc.com\/ro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fotc.com\/ro\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/fotc.com\/ro\/wp-json\/wp\/v2\/comments?post=31936"}],"version-history":[{"count":0,"href":"https:\/\/fotc.com\/ro\/wp-json\/wp\/v2\/posts\/31936\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fotc.com\/ro\/wp-json\/wp\/v2\/media\/20340"}],"wp:attachment":[{"href":"https:\/\/fotc.com\/ro\/wp-json\/wp\/v2\/media?parent=31936"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fotc.com\/ro\/wp-json\/wp\/v2\/categories?post=31936"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fotc.com\/ro\/wp-json\/wp\/v2\/tags?post=31936"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}