Spatialists19h ago
geoparquet-io: Fast #GeoParquet tool: geoparquet-io is an open-source #CLI tool and #Python library for converting, inspecting, optimizing, and partitioning #GeoParquet files, automatically applying GeoParquet performance best practices along the way. Its extract command can pull geodata from sources such as #WFS, #Esri ArcGIS Feature Services, or #BigQuery into GeoParquet.
https://spatialists.ch/posts/2026/04/06-geoparquet-io-fast-geoparquet-tool/ #GIS #GISchat #geospatial #SwissGIS
geoparquet-io: Fast GeoParquet tool – Spatialists – geospatial news

#geoparquet-io is an open-source #CLI tool and #Python library for converting, inspecting, optimizing, and partitioning #GeoParquet files, automatically applying GeoParquet performance best practices along the way. Its extract command can pull geodata from sources such as #WFS, #Esri ArcGIS Feature Services, or BigQuery into GeoParquet.

Spatialists – geospatial news
Nicolas MØUART4d ago

CNN Vs Fox News Vs MSNBC vs BBC coverage. Is it fair competition? I doubt, #Arte is so much better.

NB: they used #BigQuery and #SQL

Mapping The Geography Of Television News 2009-2018
https://blog.gdeltproject.org/mapping-the-geography-of-television-news-2009-2018/ #media #nonsocialmedia #geopolitics

Rini MMar 29
Built an end-to-end data pipeline using GCP, Airflow, PySpark, and BigQuery to analyze thermal anomaly data (India 🇮🇳 vs USA 🇺🇸).
Uncovered patterns in fire frequency, intensity, and seasonality through interactive dashboards.
#DataEngineering #GCP #Airflow #BigQuery #PySpark
Leiden MadtricsMar 24

🌐 In our new blog post, Juan Pablo Bascur introduces the ORION Dashboard: a tool that makes #openresearchdata accessible, interactive, and easy to explore. It enables easy exploration of CWTS #OpenAlex data on #BigQuery, letting users analyse institutions, funders, and research topics via interactive visualisations and reproducible SQL queries, without any coding skills required 👩‍💻.

🔎 Discover the blog post here 👉 https://www.leidenmadtrics.nl/articles/orion-dashboard-bringing-open-research-data-within-reach

ORION dashboard: bringing open research data within reach

The ORION dashboard enables easy exploration of CWTS OpenAlex data on BigQuery, letting users analyse institutions, funders, and research topics via interactive visualisations and reproducible SQL queries without any coding skills required.

HabrMar 24

TCO или Полная Стоимость Владение современных подходов в ETL для DB MPP

О чем эта статья : В данной статье я хочу сравнить TCO старых добрых ETL как например Informatica, ODI, MarkitEDM и подобных им vs DBT + AirFlow и подобных им Очень легко проанализировать стоимость лицензий или вычислений и хранения в случае облачной БД, но очень сложно — TCO. Стоимость разработки одной фичи, стоимость поддержки, стоимость сопровождения, стоимость изменений. Очень заманчиво учитывать только расходы на лицензии и вычисления и предполагать, что все остальные расходы одинаковы, хотя это не так. По умолчанию облачные MPP-базы обычно дешевле по хранению и вычислениям и не имеют лицензионной платы, и возникает соблазн использовать такой же безлицензионный подход в ETL, но есть недостатки :

https://habr.com/ru/articles/1014362/

#mppбазы #informatica #dbt #etl #airflow #oracle #bigquery

TCO или Полная Стоимость Владение современных подходов в ETL для DB MPP

О чем эта статья : В данной статье я хочу сравнить TCO старых добрых ETL как например Informatica, ODI, MarkitEDM и подобных им vs DBT + AirFlow и подобных им Очень легко проанализировать стоимость...

Хабр
Luke MillerMar 23

Secretly convinced BigQuery's main use case is pulling pypi stats

#Python #BigQuery #pypi

I to się liczyMar 19

Claude Code + BigQuery → agent analityczny, który pracuje na Twoich danych 24/7

Bez kopiowania zapytań. Bez pośredników. Bez przełączania między narzędziami.

To wszystko dzięki połączeniu Claude'a bezpośrednio do BigQuery przez MCP.

#iToSięLiczy
#AI #BigQuery #GoogleCloud #GA4 #DataDrivenMarketing #Automatyzacja #MarketingAnalytics

sayzardMar 16

AshutoshShrivastava (@ai_for_success)

Google이 BigQuery Studio 내 Gemini 기반 어시스턴트를 업그레이드: 현재 활성 쿼리 탭의 문맥을 이해해 코드 복붙·문맥 설명 불필요, 고급 SQL 생성 및 AI 연산자 포함한 쿼리 생성 기능 추가.

https://x.com/ai_for_success/status/2033595501933957463

#google #gemini #bigquery #sql #aiassistant

AshutoshShrivastava (@ai_for_success) on X

🚨 Google has upgraded the Gemini powered assistant inside BigQuery Studio. TLDR - Gemini assistant in BigQuery Studio now understands your active query tabs - No need to copy paste code or explain context again - Can generate advanced SQL including AI operators and

X (formerly Twitter)
Valentin DeleplaceMar 12

BigQuery pipe syntax by example
by Antonella Blasetti

❤️❤️ Pipe syntax is so, so awesome! Seriously.

https://medium.com/google-cloud/bigquery-pipe-syntax-by-example-blasetta-0f3df50ba331

#BigQuery #SQL #GoogleCloud

BigQuery pipe syntax by example

SQL faster to write and far easier to maintain

Medium
AI Daily PostMar 9

🚀 The new LangChain GTM Agent can pull data straight from Salesforce and BigQuery, monitor funding rounds, product launches, and AI trends—all in an open‑source, automated workflow. Perfect for teams that need real‑time business intelligence without vendor lock‑in. Dive in to see how it streamlines data pipelines and boosts decision‑making. #LangChain #GTMAgent #Salesforce #BigQuery

🔗 https://aidailypost.com/news/langchain-gtm-agent-pulls-salesforce-bigquery-data-tracks-funding