Uqhagamshelo lweGoogle BigQuery

1. Kutheni ukhuphela idatha engahlelwanga kwiBigQuery?

Nangona ideshibhodi yeMousePlayer inika ukudlala kwakhona iiseshoni ngoko nangoko neemephu zobushushu ezibonakalayo, amaqela esayensi yedatha neBusiness Intelligence (BI) amashishini afuna ufikelelo olungqo lweSQL kwiilog zokuziphatha ezingahlelwanga. Ngokungqamanisa idatha yeMousePlayer kwiGoogle BigQuery, unako:

• Ukudibanisa idatha yokusebenza nedatha yenkqubo engasemva: Dibanisa iiseshoni zabasebenzisi zecala elibonwayo namangeniso eCRM, iilog zamasango okuhlawula neziseko zedatha zokuhlawulisa usebenzisa imibuzo yeSQL eyenzelwe wena.
• Ukuqeqesha iimodeli zeAI/ML ezenzelwe wena: Sebenzisa iindlela ezineenkcukacha zokushukuma kwemawusi neepateni zokucofa ngomsindo ukuqeqesha iialgorithm zokuqikelela ukungabuyi nokubona ubuqhophololo.
• Akukho zindleko zokugcina kwiMousePlayer: Idatha ikhutshelwa ngqo kwiprojekthi yakho yeGCP, ikunike ubunini bedatha obuyi-100% nokuhambelana nemigaqo-nkqubo yeIAM yeshishini.

2. Amandla esicwangciso seBusiness xa kuthelekiswa neseEnterprise

Uqhagamshelo lweBigQuery lufumaneka kuphela kwizicwangciso ze Business ne Enterprise . Ngokuxhomekeka kwinqanaba lakho, ungakhetha iiseti zedatha oza kuzibandakanya kukhuphelo oluzenzekelayo lwemihla ngemihla ebusuku:

Itheyibhile ekhutshelwayo	Umxholo wedatha & ulwakhiwo	Isicwangciso seBusiness	Isicwangciso seEnterprise
visitor_sessions_YYYYMMDD	Imethadatha epheleleyo yeseshoni (isichongi seseshoni, isichongi sondwendwe, i-IP, ilizwe, isixhobo, inkqubo yokusebenza, isikhangeli, ubude bexesha, umthombo wotyelelo, iiUTM, custom_user_id).	Ibandakanyiwe	Ibandakanyiwe
visitor_custom_events_YYYYMMDD	Lonke uguquko oluqhelekileyo neziganeko ezenzelwe wena (umzekelo, purchase, rage_click, error_detected, ukuthumela iifomu) kunye neeparamitha zeEAV ezineentlobo.	Ibandakanyiwe	Ibandakanyiwe
mouse_events_YYYYMMDD	Uthotho oluneenkcukacha lwendawo (X, Y, izitampu zexesha, ubunzulu bokuskrola, iindawo zokucofa, izikhethi zeCSS ekujoliswe kuzo) lokujongwa kwephepha ngakunye okurekhodiweyo.	Ayifumaneki	YeEnterprise kuphela

3. Isikhokelo sokuseta: iakhawunti yenkonzo yeGCP & iimvume zeIAM

IMousePlayer ayize icele iinkcukacha zakho zobuqu zokungena kuGoogle. Endaweni yoko, wenza iakhawunti yenkonzo eyenzelwe oku kwiGoogle Cloud Console yakho eneemvume ezincinane ezifunekayo:

1. KwiGoogle Cloud Console, yiya ku IAM & Admin → Service Accounts uze ucofe Create Service Account.
2. Nika iakhawunti yenkonzo igama (umzekelo, mouseplayer-bq-writer).
3. Yabela kanye iindima ezimbini zeIAM: BigQuery Data Editor ne BigQuery Job User.
4. Yiya kwithebhu ethi Keys yeakhawunti yakho entsha yenkonzo, cofa Add Key → Create new key, uze ukhethe JSON.
5. Vula ideshibhodi yakho yeMousePlayer, yiya ku Iiwebhusayithi zakho → Iisetingi → BigQuery, uze uncamathelise isichongi seprojekthi yakho yeGCP, isichongi seseti yedatha, imeyile yeakhawunti yenkonzo nomxholo wesitshixo seJSON.