Example of a comparison between traditional SQL and the #BigQuery  Pipe Syntax 🔥

✅ Pipe Syntax (reads top → bottom)

Why I like it:
→ Reads like a data pipeline
→ No nested subqueries
→ Less cognitive load in some situations

docs.cloud.google.com/bigquery/docs/…

#GoogleCloud

More details here

#BigQuery
- Conversational analytics docs.cloud.google.com/bigquery/doc...
- Remote models docs.cloud.google.com/bigquery/doc...

#CloudSQL docs.cloud.google.com/sql/docs/mys...

#Memorystore docs.cloud.google.com/memorystore/...

Features of the week on #GoogleCloud

- #BigQuery conversational analytics adds ObjectRef, BQML functions (AI.FORECAST/GENERATE) in preview
- #BigQuery Gemini embeddings & open models are GA
- #CloudSQL Data API for executing administrative SQL is GA
- #Memorystore for Valkey 9.0 is GA

#FotWGCP

BigQuery pipe syntax by example SQL faster to write and far easier to maintain

BigQuery pipe syntax by example
by Antonella Blasetti

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

medium.com/google-cloud...

#BigQuery #SQL #GoogleCloud

#GA4 → BigQuery should unlock deeper analytics, but poor setup leads to mismatched metrics, missing data, and rising costs.

Here are the 𝟱 𝗯𝗶𝗴𝗴𝗲𝘀𝘁 𝗺𝗶𝘀𝘁𝗮𝗸𝗲𝘀 companies make when integrating GA4 with #BigQuery and how to avoid them.

🔗 calibrate-analytics.com/insights/202...

🤖 Can we hack LLM prices?

💸 Here are some tips on how to radically reduce AI costs.

#ai #llm #python #rust #data #analysis #vertex #google #gemini #multimodal #bigquery #tips #image #video #social #media #batch #model #prompt #it #dev #programming #software #code #tech

LangChain’s new GTM Agent can pull data straight from Salesforce & BigQuery, track funding rounds, launches, and even run AI queries—all open‑source. Ready to supercharge your BI and data automation? Dive in! #LangChain #Salesforce #BigQuery

🔗 aidailypost.com/news/langcha...

Customizable Quick Keys This 60-second video shows off the customizable quick keys of Nexus that power users love.

When power users need to get work done, they use Nexus's customizable quick keys.

youtu.be/j06hS6Qp_6c

#snowflake #databricks #db2 #teradata #oracle #bigquery #ibm #sqlserver #synapse #postgres #vertica #greenplum #redshift #aws #googlecloud #awscloud #azurecloud #cloud #sql #etl #postgres

More details here

#BigQuery
- Spanner docs.cloud.google.com/bigquery/doc...
- Replication docs.cloud.google.com/bigquery/doc...

#AlloyDB docs.cloud.google.com/alloydb/docs...

#VertexAI docs.cloud.google.com/vertex-ai/ge...

#CloudFunctions
Runtime support docs.cloud.google.com/run/docs/run...

Features of the week on #GoogleCloud

- #BigQuery Continuous queries to stream data to Spanner & replication monitoring are GA
- #AlloyDB Auto vector embeddings & AI SQL functions are GA
- #VertexAI Gemini 3.1 Flash-Lite in preview
- #CloudFunctions Ruby 4.0 (Preview) and PHP 8.5 (GA)

#FotWGCP

More details here

#BigQuery
- Agent docs.cloud.google.com/bigquery/doc...
- Undelete dataset docs.cloud.google.com/bigquery/doc...

#CloudRun
- Multiregion docs.cloud.google.com/run/docs/mul...
- MCP server docs.cloud.google.com/run/docs/ref...

#CloudFunctions
docs.cloud.google.com/functions/do...

Features of the week on #GoogleCloud

- #BigQuery Custom glossary terms for agents in preview & Dataset undelete is GA
- #CloudRun Multi-region service health & Remote MCP server in preview
- #CloudFunctions Direct VPC egress for 2nd gen is GA
- #Gemini 3.1 flash image (AKA NanoBanana2)

#FotWGCP

Think your analytics stack is working?

If you deal with manual reporting, mismatched dashboards, rising BigQuery costs, delayed insights, or data accuracy questions, it's time to reevaluate.

Read more:
🔗 calibrate-analytics.com/insights/202...

#DataAnalytics #BigQuery #MarketingAnalytics

Google BigQuery A fast, highly scalable, cost-effective, and fully managed cloud data warehouse for analytics, with built-in machine learning.

The latest update for #BigQuery includes "Simplify your #AI workflow with autonomous embedding generation in BigQuery" and "Building a conversational agent in BigQuery using the Conversational #Analytics API".

#bigdata https://opsmtrs.com/3CfptMn

You don’t need to be a #SQL expert to get real value from #LookerStudio.

Here are 5 ways to “fake it till you make it” with #BigQuery and build clean, reliable dashboards without heavy SQL.

Read more:
🔗 calibrate-analytics.com/insights/202...

#DataAnalytics #DataWarehouse #DashboardTips

JustPark is hiring a Data Platform Lead in London to own its data stack (BigQuery, dbt, SQL, Python, Airflow, CDC). The role’s biggest draw: unifying ParkHub & JustPark data platforms & pushing AI/ML into production. #DataEngineering #BigQuery #dbt #AI #LondonJobs aihackerjobs.com/company/just...

Google BigQuery A fast, highly scalable, cost-effective, and fully managed cloud data warehouse for analytics, with built-in machine learning.

The latest update for #BigQuery includes "New BigQuery global queries let you explore distributed data with a single SQL statement" and "Introducing Conversational #Analytics in BigQuery".

#bigdata https://opsmtrs.com/3CfptMn

#nervous #bigquery

I don’t hate SQL. I hate metadata friction. I don’t struggle with writing SQL, but what I struggle with is everything around it. You know the...

I don’t hate SQL. I hate metadata friction. I don’t struggle with writing SQL, but what I struggle with is everything around it. You know the drill: Open BigQuery console. Write a simple query ...

#bigquery #ai #automation #llm

Origin | Interest | Match

More details here

#BigQuery docs.cloud.google.com/bigquery/doc...

#CloudSQL
- Vertex AI docs.cloud.google.com/sql/docs/mys...
- MCP server docs.cloud.google.com/sql/docs/mys...

#Spanner docs.cloud.google.com/spanner/docs...

#Firestore docs.cloud.google.com/firestore/na...

Features of the week on #GoogleCloud

- #BigQuery: Generate relationship graphs/insights for datasets (Preview)
- #CloudSQL: Model endpoint management and Vertex AI integration (GA) + MCP server (Preview).
- #Spanner : MCP servers (Preview).
- #Firestore: MCP servers (Preview).

#FotWGCP

Module 4 complete: Analytics Engineering with dbt ✅

Built data transformations:
• 8 dbt models in 3 layers (staging → intermediate → core)
• Hybrid approach: Local dbt Core CLI + Cloud BigQuery

#DataEngineering #BigQuery #dbt @datatalks.bsky.social

#Gemini in Looker Studio Pro lets you chat directly with your data and get real-time answers on campaigns, spend, and engagement.

Our step-by-step guide shows how to set it up with Google Cloud, #BigQuery, and Launchpad.
🔗 calibrate-analytics.com/insights/202...

#DataAnalytics #DataWarehouse

Module 3 complete: Data Warehousing & BigQuery ✅

Built optimized data warehouse:
• 20.3M taxi records in BigQuery
• Partitioning by date: 91% cost reduction (310MB → 27MB)
• Clustering by VendorID for faster queries

#DataEngineering #BigQuery
@datatalks.bsky.social

Want a quick way to see your GA4 #funnel without extra tools? ▼

Simply connect your GA4 BigQuery dataset directly to #GoogleSheets.

We show you how:
🔗 calibrate-analytics.com/insights/202...

#GA4 #GoogleAnalytics #BigQuery #DataAnalytics #MarketingAnalytics #DashboardTips #DataWarehouse

GA4 BigQuery exports can’t backfill missing data, but 𝘺𝘰𝘶𝘳 𝘳𝘦𝘱𝘰𝘳𝘵𝘪𝘯𝘨 𝘴𝘵𝘪𝘭𝘭 𝘤𝘢𝘯.

Pull historical #GA4 data and load it into #BigQuery without any coding needed.

Read more:
🔗 calibrate-analytics.com/insights/202...

#DataAnalytics #MarketingAnalytics #GA4Backfill

Google BigQuery A fast, highly scalable, cost-effective, and fully managed cloud data warehouse for analytics, with built-in machine learning.

The latest update for #BigQuery includes "Introducing Conversational #Analytics in BigQuery" and "BigQuery AI supports Gemini 3.0, simplified embedding generation and new similarity function".

#bigdata https://opsmtrs.com/3CfptMn

Google BigQuery Adds SQL-Native Managed Inference for Hugging Face Models Google has launched SQL-native managed inference for 180,000+ Hugging Face models in BigQuery. The preview release collapses the ML lifecycle into a unified SQL interface, eliminating the need for sep...

Google recently launched third-party generative AI inference for open models in BigQuery, allowing data teams to deploy and run any model from Hugging Face or Vertex AI Model Garden using plain SQL. #google #bigquery #googlecloud #vertex #huggingface #infoq www.infoq.com/news/2026/01...

Speaking of migrating data infrastructure…
(If you missed it, our last post breaks down how we approached it with BigQuery)

If you have gone through a migration, what was harder than expected? Performance, cost control, changing existing workflows?

#DataEngineering #BigQuery #GoogleCloudPartner

How IPinfo went from fighting infrastructure to building products with Google Cloud BigQuery 👇

#BigQuery #DataEngineering #IPData #GoogleCloudPartner