😱 HOW did I not know yet hitting "?" in #BigQuery would let me see and edit the keyboard shortcuts.
So... New query tab is: ⌘ Alt T

Unlock Growth with Our Data Blueprint Series!
Transform your business data from overwhelming to empowering! 🚀 SEOSIRI's "Unified Data Blueprint" series guides you step-by-step.
Our NEW Chapter 5 explores Data Warehouses – the core of your analytics strategy. Plus, catch up on foundational topics:
Ready to harness your data? Explore the full series!
https://www.threads.com/@seofixup/post/DJv5cd3Tiil?xmt=AQF0ZPo5gKvBPNyeiY7StlmBT6p_WY9wCJ3PDp1SbO__pg
#data #datawarehouse #redshift #bigquery #analytics

How messy is #terraform with #gcp?

I'm trying to make a system where #rust worker ingests data of HTTP requests via #cloudrun, and passes them into #bigtable, which uses further ingestion recipe to export the data into #bigquery

I have tried to make a complete terraform declaration for this, but got into permission issues, then I have tried to make a system that generates all the artefacts like service accounts and docker image and then refers to those from terraform builds, but I almost don't see a value of doing it like that.

Does anyone have an example of #cloudrun #cdc? I am new to this and I feel really slow.

#lazyweb #askfedi

Our head of development, Dioni, released the first version of the #BigQuery module for #Drupal last month:
https://www.drupal.org/project/bigquery_integration

Hat tip to our client the Waste and Resources Action Programme (WRAP) for agreeing to share it. 😎

MCPでのデータベースとの対話+資料化
https://qiita.com/jw-automation/items/ee08849048f1517d40b2?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

#qiita #Python #AI #BigQuery #MCP #LLM

Researchers' Fields of Research

This is an interesting bibliometric study done using Google BigQuery with Dimensions search engine data.

https://researchmusings.substack.com/p/researchers-fields-of-research

#bibliometrics #Dimensions #BigQuery

ICYMI: Zeotap achieves Google Cloud Ready BigQuery certification https://ppc.land/zeotap-achieves-google-cloud-ready-bigquery-certification/ #Zeotap #GoogleCloud #BigQuery #DataPlatform #CloudComputing

ICYMI: Zeotap achieves Google Cloud Ready BigQuery certification: Enterprise customer data platform receives technical validation after rigorous testing process. https://ppc.land/zeotap-achieves-google-cloud-ready-bigquery-certification/ #Zeotap #GoogleCloud #BigQuery #DataPlatform #CloudComputing

ICYMI: Zeotap achieves Google Cloud Ready BigQuery certification: Enterprise customer data platform receives technical validation after rigorous testing process. https://ppc.land/zeotap-achieves-google-cloud-ready-bigquery-certification/ #Zeotap #GoogleCloud #BigQuery #DataPlatform #CloudComputing

ICYMI: Zeotap achieves Google Cloud Ready BigQuery certification https://ppc.land/zeotap-achieves-google-cloud-ready-bigquery-certification/ #Zeotap #GoogleCloud #BigQuery #DataPlatform #CloudComputing

Zeotap achieves Google Cloud Ready BigQuery certification: Enterprise customer data platform receives technical validation after rigorous testing process. https://ppc.land/zeotap-achieves-google-cloud-ready-bigquery-certification/ #Zeotap #GoogleCloud #BigQuery #DataPlatform #Certification

Zeotap achieves Google Cloud Ready BigQuery certification https://ppc.land/zeotap-achieves-google-cloud-ready-bigquery-certification/ #Zeotap #GoogleCloud #BigQuery #DataPlatform #Certification

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

#BigQuery #Tranco #DomainRanking

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

The Verge: Google Maps is launching tools to help cities analyze infrastructure and traffic. “Google is integrating new datasets for Google Maps Platform directly into BigQuery, the tech giant’s fully managed data analytics service, for the first time. This should make it easier for people to access data from Google Maps platform products, including Imagery Insights, Roads Management […]

https://rbfirehose.com/2025/04/10/the-verge-google-maps-is-launching-tools-to-help-cities-analyze-infrastructure-and-traffic/

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

#DataEngineering #dbt #Data #Analytics #AnalyticsEngineering #SQL #BigQuery #OpenSource

📊 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