TIL the Tranco domain ranking data is available as a public data source in BigQuery - so you can do e.g.:

```
select
domain,
rank
from `tranco.daily.daily`
where date = date_sub(current_date(), interval 1 day)
and domain in ("bbc.co.uk", "bbc.com")
order by rank asc
```
https://tranco-list.eu

New geospatial data in Google BigQuery: #Google is adding geospatial content to its #DWH solution #BigQuery. Additions encompass annotated Street View #imagery, Places (#POI) data, and #traffic data, among others.
https://spatialists.ch/posts/2025/04-14-new-geospatial-data-in-google-bigquery/ #GIS #GISchat #geospatial #SwissGIS

Diving into #Vermont wildlife for the #30DayChartChallenge "circle" day! Using #Python & #plotly to compare monthly #Moose and #BlackBear sightings Data wrangled with #BigQuery and #SQL. Any guesses which animal is seen more consistently throughout the year? #DataViz #Wildlife #RadialChart

BigQuery pricing model cost us $10k in 22 seconds

https://www.linkedin.com/posts/yingjun-wu_%F0%9D%90%81%F0%9D%90%A2%F0%9D%90%A0%F0%9D%90%90%F0%9D%90%AE%F0%9D%90%9E%F0%9D%90%AB%F0%9D%90%B2%F0%9D%90%AC-%F0%9D%90%91%F0%9D%90%88%F0%9D%90%83%F0%9D%90%88%F0%9D%90%82%F0%9D%90%94%F0%9D%90%8B%F0%9D%90%8E%F0%9D%90%94-activity-7307736315079405569-F2Ng

#HackerNews #BigQuery #Cost #$10k #DataAnalysis #CloudComputing #PricingModel #TechNews

"Map of Python" is the digital dabbling of a cartographer, lost in the vast jungle of 500,000+ #Python packages, desperately trying to create art from JSON blobs. But hey, at least there's #BigQuery to save the day from the horror of actually downloading data!
https://fi-le.net/pypi/ #DataVisualization #Cartography #ArtInTech #HackerNews #ngated

No more manually cross-referencing dbt docs from dev and prod

No more manually checking schemas in your data warehouse

No more manually comparing row-counts on models.

See a trend?

Read how an experienced data professional validates zero regression on a #dbt PR:

https://www.linkedin.com/posts/abdelm_recce-dbt-activity-7300436694808358914-aKiF?rcm=ACoAAAVLBgkB6r61wCsOcKgFDrtf_EEEe3UjdXs

Exploring dbt for Data Transformation
The journey continues! In this part of the project, I'm learning how dbt models help automate data transformation. I'm building out models in dbt for these taxi datasets to create clean, analysis-ready data in #BigQuery. It’s fascinating to see how everything connects! #DataEngineering #dbt #GCP #ETL #DataTalksClub

Started Module 4 of #DataEngineering Zoomcamp!
Just kicked off the Analytics Engineering module and I'm diving into transforming the Green Taxi, Yellow Taxi, and FHV NY Taxi datasets loaded in #BigQuery. Excited to see how dbt can help create analytical views for better decision-making! #dbt #DataTalksClub #GCP #AnalyticsEngineering #ETL

> We are adding additional services to your project(s) to create a unified platform for AI-powered data analytics.

【BigQuery】画像から類似画像を検索！マルチモーダルエンベディングの簡単解説
https://qiita.com/te_yama/items/d320f81ddffae447b495?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

This week! Join us on 19 February for our #CommunityCall! This month, we'll present the different avenues for accessing the #OpenAIREGraph's data (such as #API, #Zenodo, #GoogleCloud, etc.) with a brief recap of our #BigQuery training from October. Register now! Registration and agenda in link below,

Register now https://tinyurl.com/y27vxyrp

DataTalksClub's Data Engineering Zoomcamp Week 3 - BigQuery as a data warehousing solution.

For this week's module, we used Google's BigQuery to read Parquet files from a GCS bucket, and compare querying on regular, external and partitioned/clustered tables.

My answers to this module: https://github.com/goosethedev/de-zoomcamp-2025/blob/ecb1f1f3fc69b8d10703eb07328567dab2acf688/03-data-warehousing/README.md

Join us on 19 February for our #CommunityCall! This month, we'll present the different avenues for accessing the #OpenAIREGraph's data (such as #API, #Zenodo, #GoogleCloud, etc.) with a brief recap of our #BigQuery training from October. Register now! Registration and agenda in link below,

Register now https://tinyurl.com/y27vxyrp

TROCCO クックブックをやってみた
https://qiita.com/manabian/items/0ba949e54502c53a82e4?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

FFS. Turns out (after I built a feature) that you can't supply a schema for BigQuery Materialised Views.

> Error: googleapi: Error 400: Schema field shouldn't be used as input with a materialized view, invalid

So it's impossible to have column descriptions for MVs? That sucks.

Whilst migrating our log pipeline to use the BigQuery Storage API & thus end-to-end streaming of data from Storage (GCS) via Eventarc & Cloud Run (read, transform, enrich - NodeJS) to BigQuery, I tested some big files, many times the largest we've ever seen in the wild.

It runs at just over 3 log lines/rows per millisecond end-to-end (i.e. inc. writing to BigQuery) over 3.2M log lines.

Would be interested to know how that compares with similar systems.

We released our product as Open Source today!

So if you're into Google Analytics and Big Query: check it out, it's free to use.

Tags: #gpl #ga4 #bigquery #measure #sql #dbt #dataform

https://ga4dataform.com/were-open-source-ga4dataform-community-is-released/

Google Analytics updates BigQuery Export with enhanced traffic source analysis: Learn about the latest Google Analytics BigQuery export enhancement adding session-scoped traffic source fields for deeper insights. https://ppc.land/google-analytics-updates-bigquery-export-with-enhanced-traffic-source-analysis/?utm_source=dlvr.it&utm_medium=mastodon #GoogleAnalytics #BigQuery #DataAnalytics #TrafficSource #DigitalMarketing

Anyone else who use BigQuery seeing elevated errors? 502s?

#gcp #bigQuery

(I do miss the days when Twitter was a reliable communication path for finding out down-for-everyone-or-just-me?)