I-IPinfo ibandakanya inkonzo yayo ne-Google Cloud Platform, ukunika abasebenzisi be-BigQuery ukufinyelela kwe-IP intelligence ngokushesha ku-cloud workflows zabo. Ukuze i-IPinfo Lite, i-IPinfo Core, i-Plus, ne-Custom datasets - ezokufinyelelwa kwama-US-multi kanye ne-EU-multi-regions - ama-developer ne-analytics angakwazi ukwandisa ama-data pipelines zabo nge-IP ephelele, konke ngaphandle kokuphumelela ku-GCP ecosystem. New Dataset Izincwajana New Dataset Izincwajana Yini lokhu kubaluleke Noma ufuna ukucubungula umsebenzi obuthambile, ukucubungula impendulo, noma ukucubungula imibala ye-traffic, idatha ye-IP iyiphi isixhumanisi esizayo. Kodwa ukuhlanganiswa kwizinto ze-third-party yokukhuthaza kungabangela ukucubungula: APIs ze-API, i-ETL pipelines, imibuzo ye-freshness, kanye ne-storage overhead zihlanganisa. I-IPINFO Datasets izixazulule lokhu. Ibhizinisi-Native Ibhizinisi-Native Time-to-insight okusheshayo: Enrich amayunithi amayunithi amayunithi amayunithi amayunithi amayunithi amayunithi amayunithi amayunithi amayunithi amayunithi amayunithi amayunithi amayunithi amayunithi amayunithi amayunithi amayunithi amayunithi Ngaphandle kwe-lift yokusebenza: "Zero-copy" ama-shares ezikhishwe kubalulekile ukuba akukho ukuchithwa kwedatha, ukugcina, noma ukuxhumana. Ukuhweba okuzenzakalelayo: Zonke ama-datasets zitholakala nge-Google Cloud Marketplace, nge-facturing ehlanganisiwe kanye ne-region-bound options for compliance. Umphumela: Idatha yakho ibhekwa emkhakheni yakho yedatha futhi usuka kusuka ku-logs ebomvu kuya ku-input enikezwayo ngaphandle kokubili okungenani. Ukusuka ku-dataset eyodwa kuya ku-portfolio ephelele NgoLwesihlanu, inkampani yethu yokuqala yedatha ku-Google Cloud Marketplace: idatha ye-IP ku-Country kanye ne-ASN, efumaneka njenge-share elawulwa nge-BigQuery. It inikeza abasebenzisi indlela elula, ngaphandle kwe-code ukuvikela ama-IP nge-location kanye ne-network ownership. Ukulungiswa Ukulungiswa I-dataset efanayo iyatholakala ngoku njenge , futhi ifakwe kumadokhumenti amabili omtsha yokukhiqiza: Waze , kanye Ngezinye, lezi zinketho zithumela abadlali ububanzi obuningi futhi ukunambitheka ukucindezeleka ama-IP ebonakalayo ezivela ku-web traffic logs, iziganeko zokhuseleko, izitebhisi zokuhlola, kanye nezinye izinga lokusebenza ezivela ku-BigQuery, futhi ukwenza imisebenzi kulesi khasi. I-IPinfo Lite I-IPinfo Core Imininingwane Plus I-Custom Datasets I-IPinfo Lite I-IPinfo Core Imininingwane Plus I-Custom Datasets Ngaphandle kwe-Integration: A Closer Look Izixhumi ze-IPinfo zithunyelwe njenge-shares ezigcwele ku-BigQuery, okungenani akudingeki ukulanda, ukuchithwa, noma ukuhlanganiswa. Uma usithunyelwe nge-Google Cloud Marketplace, idatha iyatholakala ngokushesha ku-BigQuery project yakho. Akukho ama-API keys. Akukho izivakashi ze-external. Hlola i-IP yakho ngokushesha nge-city-level geolocation, idatha ye-ASN, ama-anonymizer flags, nokunye. Ngiyaxolisa Waze , sinikeza idatha yakho ye-GCP IP emkhakheni yakho ye-BigQuery ngokushesha nge-updates ezivamile, ngokuvumelana ne-subscription yakho. I-IPinfo Lite iyahlanjiswa ngosuku zonke ku-BigQuery. I-IPinfo Core ne-IPinfo Plus iyahlanjiswa ngenyanga ngokushesha ngokushesha. Ingabe ufuna idatha ezintsha (ngosuku zonke noma ngenyanga) noma izindlu ezengeziwe? I-Team yethu ye-Custom Data Solutions ingathumela idatha eyakhiwe ngokuhambisana ne-cadence ne-region yakho. I-Data Push ye-Cloud Snowflake Datasets I-Data Push ye-Cloud Snowflake Datasets Quick Demo: Usebenzisa i-Lite UDF Konke idatha iqukethe i-User-Defined Function (UDF) eyakhiwe, okwenza kube lula ukufuna i-IP kanye nokuthumela idatha eyenziwe ku-inline ku-queries yakho. I-UDF igama lihlanganisa idatha futhi inikeza ukuthuthukiswa okusheshayo, ku-in-storage. I-Routines ye-dataset, futhi akukho ikhodi eyenziwe ngempumelelo yokuqala ukusetshenziswa kwayo. Ngezansi i-demo encane elibonisa i-Lite searchup ku-BigQuery console: Isibonelo – return Full Lite idokhumenti: SELECT
    ip,
    ipinfo_lite.lite(ip) AS lite
FROM 
    ipinfo_lite.ip_sample;
 Umzekelo - Khetha kuphela izindlu ezidingekayo: SELECT
    ip,
    ipinfo_lite.lite(ip).country AS country,
FROM 
    ipinfo_lite.ip_sample;
 Usayizi: Ukuze ama-log tables amakhulu, ukunambitheka ama-IP ahlukene ngaphambi kokufaka (bheka I-Cost & Performance Best Practices ngezansi). Ukuze uthole isikhokelo se-step-by-step ku-enrichment ye-Cloud Logging data esekelwe, . Thola i-IPinfo GCP developer docs Thola i-IPinfo GCP developer docs I-Cost & Performance Best Practices (i-BigQuery) I-BigQuery inikeza ikakhulukazi kwi-byte eyenziwe (ukuguqulwa kwe-query) kanye ne-storage. Ukukhishwa kwe-IP kuncane kunesibopho se-rough log ifakwe uma ufakele ama-queries ngokufanele. Lapha ukuthi sincoma ukulawula ukusetshenziswa ngenkathi ukugcina ukusebenza okuphakeme: I-IP ye-SELECT DISTINCT ye-Pull from your log sources, i-enrich once, then join back. Ukunciphisa ngokushesha i-UDF calls. I-Filter Early. Ukunciphisa i-date partitions, i-log types, noma i-services ezithile ngaphambi kokuphumelela. Khetha kuphela izindlu ezidingekayo. Ukuhlola kubhalwe idokhumenti eyodwa esakhiwo (BigQuery STRUCT) nge izindlu ezininzi zihlanganisa. Project kuphela izindlu ezidingekayo njengelizwe, i-asn.name, noma ama-privacy flags ezidingekayo ukuze isisombululo asebenza ngokushesha futhi ongaphakeme. Ukusebenzisa i-dry runs / query validator. I-preview bytes i-scanned ngaphambi kokusebenza kwezinto ezinkulu. I-IP-Dimensional Table (I-IP-Dimensional Table) I-IP-Dimensional Table (I-IP-Dimensional Table) I-IP-Dimensional Table (I-IP-Dimensional Table) I-IP-Dimensional Table (I-IP-Dimensional Table) I-IP-Dimensional Table (I-IP-Dimensional Table) I-IP-Dimensional Table (I-IP-Dimensional Table) I-IP-Dimensional Table (I-IP-Dimensional Table) I-IP-Dimensional Table (I-IP-Dimensional Table) I-Cache emaphaketheni emaphaketheni emaphaketheni emaphaketheni emaphaketheni emaphaketheni emaphaketheni emaphaketheni emaphaketheni emaphaketheni emaphaketheni emaphaketheni Ukusebenza nge LIMIT noma isampula izinsuku kuqala; Scale uma imiphumela ukhangela ngokufanele. Ngokuhambisana nezimo zihlanganisa kubaluleke kakhulu kuphela ukugcina ukuvikelwa ngokukhawuleza nokushintshana. I-Data I-Type I-Data Set Inikeza? I-IPinfo Lite (Ukuqala lapha) I-IPinfo Lite dataset yethu yamahhala inikeza inkampani ye-IP enikezwa ku-BigQuery. It inikeza idatha esifanele ye-pacific kanye ne-ASN ye-IPv4 ne-IPv6, okuvuthwa ngosuku zonke. Njengoba i-Lightweight kanye ne-self-serving nge-BigQuery Analytics Hub, i-Lite yindlela elula yokufaka idatha ye-IPinfo, ukulawula isampula sakho sokuvuthwa, nokuvumelana nokuphatheleka kwama-field ngaphambi kokuphumelela ku-datasets amakhulu. Uma ungenza ukuvikelwa kwe-IPs ku-BigQuery, ungakwazi ukuvikela ukuxhumana okuhlobene nge-premium datasets etholakalayo nge-Google Cloud Marketplace: Ukusuka ku-Click ku-Query ku-Minutes I-IPinfo Lite ikhasimende etholakalayo ngokusebenzisa i-Google Cloud Analytics Hub platform, kodwa kumadokhumenti etholakalayo etholakalayo efana ne-IPinfo Core, i-IPinfo Plus, kanye nezinye ikhasimende etholakalayo ze-IP, sikhasimende etholakalayo ngokusebenzisa i-Google Cloud Marketplace. Ukuqala kunezingciphisa kuphela. Ngiyazi indlela yokuqala: I-IPinfo Lite (US/EU): Izixhumi ze-country & i-ASN zithunyelwe ngosuku. Ukufinyelela ngqo nge-BigQuery Analytics Hub - akukho izindleko noma ikhadi lokudluliselwa. I-IPinfo Core (i-US/EU): Ubhalisele nge-Google Cloud Marketplace ukuze uqinise ama-IPs nge-city-level accuracy, ama-VPN/proxy/hosting flags, kanye ne-operator info. I-IPinfo Plus (US/EU): Sishayela kanye nokuthumela zonke ama-IPinfo Core ama-signals kanye nama-IP data ezininzi kuhlanganise ukucaciswa kwenkonzo, ukucaciswa kwe-radius kanye ne-location / i-ASN last change timestamp. I-Datasets ye-Custom (Any region): Qhagamshelana nathi ukuze ufake i-datasets ye-custom ukuze kufinyeleleke nezidingo zakho. Us UKUSEBENZA Ukubhalisa Thola ku-Sales Ukubhalisa Thola ku-Sales Ngena ngemvume Ingabe unemibuzo? Hlola us . BigQuery ukuhlanganiswa Guide BigQuery ukuhlanganiswa Guide Ungasebenzisa kanjani idatha ye-IPinfo ku-BigQuery I-team e-Security, i-Data Engineering, i-Growth, ne-Analytics isebenzisa idatha ye-IPinfo e-BigQuery kakhulu kunazo zonke. Ngezantsi zihlanganisa izakhiwo ezivamile ezivela ekukhiqizeni. I-on-ramp yabasebenzisi abaninzi: ukulayisha i-logs kusuka ku-Cloud Logging ku-BigQuery, ukulayisha i-IPs, ukucubungula nge-IPinfo Core noma Plus, bese ukuxhuma. Lokhu kusiza i-VPN / i-proxy / i-hosting traffic, i-geo anomalies, ne-abuse spikes emizuzu. Log enrichment & fraud/risk detection. I-Materialize iphasiwedi yedijithali ye-IP eyodwa eyenziwe nge-Core noma i-Plus, bese uqhagamshelane nezinye i-fact tables (i-auth, i-product events, i-facturing) ngokuhambisana nezidingo. I-Centralizes i-IP context futhi ivimbele izivakashi ze-UDF ezivame. Reusable enriched IP lookup table . Ukulungiselela ukusetshenziswa ngamazwe / isifunda / idolobha ukulawula ukuthuthukiswa, lokuphelelwa, noma ukucubungula inethiwekhi. Easy ukucubungula ku-Dashboard ku-Looker noma i-Data Studio. Geo aggregation & traffic analytics I-Group Inbound Traffic ngu-ASN noma i-hosting class (i-cloud vs. i-ISP ye-consumer) ukuze ufunde ukucindezeleka kanye nokuguqulwa kwe-firewall / i-WAF Policy. Security posture & threat surface mapping . Zihlanganisa i-privacy flags (i-anonymous, i-hosting, i-satellite, i-mobile) ne-auth imiphumela, ama-rate limits, noma ama-payment attempts ukucacisa i-botting, i-scraping, noma ama-acquisition ye-akhawunti. Anomalous access & abuse hunting Ukusebenzisa ukucubungula kwelizwe / isifunda ukuze ukhuthaze amasethi yokufinyelela ukuthi i-downstream i-services ibhalisele ukufinyelela kwekhwalithi, ukucubungula kwezimali, noma ukucubungula kwezimali. Regional feature controls & licensing Ukongeza i-geo ne-network context kuya ku-attribution data ukusabela ukusebenza kwe-campaign ngama-market, i-mobile vs. fixed, noma i-privacy posture (i-VPN / i-anonymous njenge-cohort). Marketing & growth segmentation I-Export ye-IP fields eyenziwe njenge-model features ye-fraud scoring, i-churn prediction, noma ukucubungula e-Vertex AI / i-BigQuery ML. ML feature engineering Uma usahlanganyela i-PII-reduced datasets phakathi kwamakhasimende, ukunambitheka amaqembu amabili nge-geo/network attributes ezivamile ukuze kuvumela ukuhlaziywa okuqukethwe ngaphandle kokubonisa ama-identifier. Data clean rooms & partner joins I-Egress, i-Latency, ne-Usage ye-Service ifana ne-user geography ne-network class; i-Snapshot geo distribution ye-access ye-audit kanye ne-regulatory reporting. Infrastructure & cost observability + compliance reporting Thola i-IP Intelligence lapho idatha yakho ivela Njengoba umphakeli wamanje we-IP we-BigQuery integration ngokusebenzisa i-Google Cloud Marketplace, sincoma izidingo ezizodwa ze-BigQuery abasebenzisi. Noma ufuna ukhuseleko kwezimpendulo, ukuthuthukiswa kwe-Personalization, noma ukuvikelwa kokusebenza kwe-compliance, ungathola ngokuzenzakalelayo ukufinyelela kwe-IP intelligence lapho ufuna, lapho idatha yakho ibhizinisi. Ukuhlola ububanzi obuphelele we-IPinfo datasets ku-GCP, ukuze ufunde okwengeziwe, uxhumane i-datasets, futhi uxhumane iqembu lethu. Thola iwebhusayithi yethu Thola iwebhusayithi yethu I-Google Cloud iyisisindo se-Google LLC. mayelana nombhali: U-Fernanda Donnini Njengoba umphathi we-product marketing, i-Fernanda inikeza amakhasimende ukholelwa kahle ukuthi imikhiqizo ye-IPinfo inokufuneka izidingo zabo.

This story contains new, firsthand information uncovered by the writer.

Read Documentation

Try Our Free Tools

View All Products and Pricing

Lo msindo ukhiqizwa ngolimi lokuqala lwendaba!

Kude kakhulu; Uzofunda

Download free Tech Leaders Productivity Report!

I-IP Data, i-Engineered for Google Cloud: I-IPinfo isixazululwa nge-datasets entsha ye-BigQuery

About Author

IMIBONO

HANG TAGS

LESI SIHLOKO SETHULWE NGAPHAKATHI

Related Stories

Zulu Network: Moving The Bitcoin Economy Forward With a Two-Tiered Bitcoin Layer 2 Architecture

The Billionaires F*cked Up

Zulu Network: Moving The Bitcoin Economy Forward With a Two-Tiered Bitcoin Layer 2 Architecture

The Billionaires F*cked Up

Light-Mode

Classic

Newspaper

Dark-Mode

Neon Noir

Minty

HN StartUps