Google BigQuery

Mountain View, CA, USA
Mar 3, 2021   |  By Aja Hammerly
Many people think of Cloud Run just as a way of hosting websites. Cloud Run is great at that, but there's so much more you can do with it. Here we'll explore how you can use Cloud Run and BigQuery together to create an inventory management system. I'm using a subset of the Iowa Liquor Control Board data set to create a smaller inventory file for my fictional store. In my inventory management scenario we get a csv file dropped into Cloud Storage to bulk load new inventory.
Feb 25, 2021   |  By Vinay Balasubramaniam
Today, we are excited to announce the general availability (GA) of BigQuery materialized views. Materialized views (MV’s) are precomputed views that periodically cache results of a query to provide customers increased performance and efficiency.
Feb 25, 2021   |  By Vinay Balasubramaniam
Business analysts working with larger and larger data sets are finding traditional BI methods can't keep up with their need for speed. BigQuery BI Engine is designed to meet this need by accelerating the most popular dashboards and reports that connect to BigQuery. With the freshest data available, your analysts can identify trends faster, reduce risk, match the pace of customer demand, even improve operational efficiency in an ever-changing business climate.
Feb 24, 2021   |  By Karl Weinmeister
Spreadsheets are everywhere! They are one of the most useful productivity tools available. They make organizing, calculating, and presenting data a breeze. Google Sheets is the spreadsheet application included in Google Workspace, which has over 2 billion users. Machine learning, or ML for short, has also become an essential business tool. Making predictions with data at low cost and high accuracy has transformed industries.
Feb 12, 2021   |  By Nikhil Mishra
As the owner of Analytics, Monetization and Growth Platforms at Yahoo, one of the core brands of Verizon Media, I'm entrusted to make sure that any solution we select is fully tested across real-world scenarios. Today, we just completed a massive migration of Hadoop and enterprise data warehouse (EDW) workloads to Google Cloud’s BigQuery and Looker.
Feb 10, 2021   |  By Lak Lakshmanan
Many BigQuery users ask for database triggers—a way to run some procedural code in response to events on a particular BigQuery table, model, or dataset. Maybe you want to run an ELT job whenever a new table partition is created, or maybe you want to retrain your ML model whenever new rows are inserted into the table. In the general category of “Cloud gets easier”, this article will show how to quite simply and cleanly tie together BigQuery and Cloud Run.
Feb 9, 2021   |  By Anant Damle
Democratization of data within an organization is essential to help users derive innovative insights for growth. In a big data environment, traceability of where the data in the data warehouse originated and how it flows through a business is critical. This traceability information is called data lineage. Being able to track, manage, and view data lineage helps you to simplify tracking data errors, forensics, and data dependency identification.
Feb 3, 2021   |  By Bhooshan Mogal
Businesses today have a growing demand for real-time data integration, analysis, and action. More often than not, the valuable data driving these actions—transactional and operational data—is stored either on-prem or in public clouds in traditional relational databases that aren’t suitable for continuous analytics.
Feb 3, 2021   |  By Polong Lin
Continuous evaluation—the process of ensuring a production machine learning model is still performing well on new data—is an essential part in any ML workflow. Performing continuous evaluation can help you catch model drift, a phenomenon that occurs when the data used to train your model no longer reflects the current environment.
Jan 27, 2021   |  By Skander Hannachi
Retail businesses understand the value of demand forecasting—using their intuition, product and market experience, and seasonal patterns and cycles to plan for future demand. Beyond the need for forecasts that are as accurate as possible, modern retailers also face the challenge of being able to perform demand planning at scale.
Aug 12, 2020   |  By Google BigQuery
In this video, you will learn how you can manage costs in BigQuery by setting a custom quota that specifies a limit on the amount of query data processed per day.
Jul 15, 2020   |  By Google BigQuery
In this video, you will learn how to write and run queries from BigQuery tables directly in the BigQuery web UI. Product: BigQuery; fullname: Alicia Williams;
Jun 15, 2020   |  By Google BigQuery
Here to bring you the latest news in the Cloud is Stephanie Wong Tune in every week for a new episode and let us know what you think of the latest announcements in the comments below! Product: BigQuery; fullname: Stephanie Wong;
May 27, 2020   |  By Google BigQuery
Want to know how to create and organize your data sets in BigQuery? In this video, we show how to utilize BigQuery, so you can visualize your data via charts. product: BigQuery; fullname: Roger Martinez;
May 20, 2020   |  By Google BigQuery
With BigQuery turning 10 this month, hear from some of the founding engineers about their experience working with product, and how the innovation has been helped transform internal and external stakeholders.
Feb 20, 2020   |  By Google BigQuery
In this video, we’ll introduce the BigQuery sandbox as a way to analyze data in BigQuery without providing a credit card, and show you how to set up your own sandbox.
Apr 26, 2019   |  By Google BigQuery
You don't have to be a data scientist or a developer to start using machine learning. Join Trevor and Stephanie as they show you how to easily get started with BigQuery Machine Learning, even without a Computer Science degree. Try it out for yourself!
Apr 19, 2019   |  By Google BigQuery
Improve your BigQuery SQL query times and reduce overall costs by partitioning and clustering your tables! Join Nick and Stephanie as they give a quick demo of how to set it up, use it to the fullest extent, and try it out for yourself!
Jan 17, 2019   |  By Google BigQuery
To get the best performance out of Cloud Bigtable, it is essential to think about how you compose your row key. In this episode of Cloud Performance Atlas, Colt McAnlis helps some fitness professionals with their Bigtable index performance. Will we have the performance to get an extra workout in? Stay tuned to find out!
Jan 3, 2019   |  By Google BigQuery
Bigtable is a scalable database service that in order to be as performant as possible, has to be local to a specific region. In this episode of Cloud Performance Atlas, Colt McAnlis helps some high fliers get their bigtable performance under control. Will their performance be cleared for landing? Stay tuned to find out!

BigQuery is Google's serverless, highly scalable, enterprise data warehouse designed to make all your data analysts productive at an unmatched price-performance. Because there is no infrastructure to manage, you can focus on analyzing data to find meaningful insights using familiar SQL without the need for a database administrator.

Analyze all your data by creating a logical data warehouse over managed, columnar storage, as well as data from object storage and spreadsheets. Build and operationalize machine learning solutions with simple SQL. Easily and securely share insights within your organization and beyond as datasets, queries, spreadsheets, and reports. BigQuery allows organizations to capture and analyze data in real time using its powerful streaming ingestion capability so that your insights are always current, and it’s free for up to 1 TB of data analyzed each month and 10 GB of data stored.