Latest posts tagged with #bigquery on Bluesky
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
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...
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
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...
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
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
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 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
