How you can now handle Big Data between BigQuery and Google Sheets — The ability of connecting Google Sheets with BigQuery has been existing for a long time now. Only recently Google has raised the maximum number of rows for results returned in Connected Sheets to the following figures[1]: Pivot tables increased from 30,000 to 50,000 rows Data extracts increased from 25,000 to…

How Bard is catching up to its Competitors and outgoes them — Google is reintroducing its own chatbot named Bard to the market after it has delivered a rather weak performance after its first release this February. The assistant can now organize trips and communicate with other apps. …

The Role of a Chief Data Officer at Google — A Chief Data Officer at Google plays a critical role in shaping the company’s data strategy. They are responsible for overseeing the management, governance, and utilization of data across various business units. But is their salary as high as you would expect from the data and AI giant Google? The…

How you can now query Array directly by an Index — Google has just announced that you can now use the array subscript operator which will return a value in an array directly by index[1]. So this is a quite handy feature when working with semi-structured data stored in arrays, before that, you had to use offset and ordinal. …

How you now can query Satellite Imagery and Geospatial Datasets with SQL — Google has just announced that you can now easily export data from Earth Engine into BigQuery with their new connector[1]. The Google Earth Engine combines a multi-petabyte catalog of satellite imagery and geospatial datasets with planetary-scale analysis capabilities. …

How to share secure and private Data in BigQuery Cleaning Rooms — After announcing it for Q3 this year, Data Clean Rooms are now finally in preview for BigQuery. These rooms provide a secure environment in which multiple parties can share, join, and analyze their data assets without moving or revealing the underlying data[1]. Already last year, Google has launched Analytics Hub…

How Snowflake eases working with Data stored in Arrays — When working with Snowflake SQL you will often come across data stored in Arrays. Here Snowflake now launches new functions which could help Data Engineers and Scientist. Let’s look into the new functions and how they work — the first one is ARRAY_MAX : ARRAY_MAX This function returns the element with…

How Google uses AI to ease Data Analysis via SQL — Google has launched Duet AI for BigQuery, which is an AI-powered collaborator in Google Cloud. It should help Data Scientists, Analysts and especially business users to complete, generate, and explain SQL queries[1]. Similar to how Microsoft has already integrated AI such as ChatGPT for Azure Synapse & Co. and how…

How Google combines BigQuery API and Python — Google just announced BigQuery DataFrames — the feature is now in preview. BigQuery DataFrames is a Python API that you can use to analyze data and perform machine learning tasks in BigQuery[1]. BigQuery DataFrames combines Data Analysis and Data Science capabilities by giving you the following options[1]: bigframes.pandas implements a…