Google BigQuery

Mountain View, CA, USA
Jul 21, 2021   |  By Rajesh Gwalani
Chronicle, Google Cloud’s security analytics platform, is built on Google’s infrastructure to help security teams run security operations at unprecedented speed and scale. Today, we’re excited to announce that we’re bringing more industry-leading Google technology to security teams by integrating Chronicle with Looker and BigQuery.
Jul 20, 2021   |  By Mark Etherington
At Crux Informatics, our mission is to get data flowing by removing obstacles in the delivery and ingestion of data at scale. We want to remove any friction across the data supply chain that stops companies from getting the most value out of data, so they can make smarter business decisions. But as you may know, if you’re in the business of data, this industry never stands still. It’s constantly evolving and changing.
Jul 2, 2021   |  By Leigha Jarett
Last week in our BigQuery Reference Guide series, we spoke about the BigQuery resource hierarchy - specifically digging into project and dataset structures. This week, we’re going one level deeper and talking through some of the resources within datasets. In this post, we’ll talk through the different types of tables available inside of BigQuery, and how to leverage routines for data transformation.
Jul 1, 2021   |  By Polong Lin
When it comes to anomaly detection, one of the key challenges that many organizations face is that it can be difficult to know how to define what an anomaly is. How do you define and anticipate unusual network intrusions, manufacturing defects, or insurance fraud? If you have labeled data with known anomalies, then you can choose from a variety of supervised machine learning model types that are already supported in BigQuery ML.
Jun 30, 2021   |  By Jagan R. Athreya
Mercury, the Roman god of commerce, is often depicted carrying a purse, symbolic of business transactions, wearing winged sandals, illustrating his abilities to move at great speeds. Transactions power the world’s business systems today, ranging from millions of packages moving worldwide tracked in real time by logistics companies to global payments from personal loans to securities trading to intergovernmental transactions, keeping goods and services flowing worldwide.
Jun 29, 2021   |  By Snehanshu Shah
When ATB Financial decided to migrate its vast SAP landscape to the cloud, the primary goal was to focus on things that matter to customers as opposed to IT infrastructure. Based in Alberta, Canada, ATB Financial serves over 800,000 customers through hundreds of branches as well as digital banking options. To keep pace with competition from large banks and FinTech startups and to meet the increasing 24/7 demands of customers, digital transformation was a must.
Jun 29, 2021   |  By Dan Peng
June is the month which holds the summer solstice, and (at least in the northern hemisphere) we enjoy the longest days of sunshine out of the entire year. Just as the sun is making its longest trips across the sky, the BigQuery team is delighted to announce our next set of user-friendly SQL features.
Jun 28, 2021   |  By Maggy Hu
Today we’re announcing preview availability of a new public dataset for Google Trends. For the first time we’re bringing Google-owned Search data into Google Cloud Datasets for convenient analysis in BigQuery, or through your favorite business intelligence tools.
Jun 28, 2021   |  By Steve Walker
Google’s cloud data warehouse, BigQuery, has enabled organizations around the world to accelerate their digital transformation and empower their data analysts to unlock actionable insights from their data. Using BigQuery ML, data analysts are able to create sophisticated machine learning models with just SQL and uncover predictive insights from their data much faster.
Jun 25, 2021   |  By Leigha Jarett
Starting this week, we’re adding new content to the BigQuery Spotlight Youtube series. Throughout the summer we’ll be adding new videos and blog posts focused on helping new BigQuery architects and administrators master the fundamentals. You can find complimentary material for the topics discussed in the official BigQuery documentation.
Jul 22, 2021   |  By Google BigQuery
How does BigQuery’s internal storage work? In this episode of BigQuery Spotlight, we share how BigQuery stores data so you can make informed decisions on how to optimize your BigQuery storage. We’ll also talk about partitioning, as well as clustering and how it allows for efficient lookups.
Jul 15, 2021   |  By Google BigQuery
What are jobs in BigQuery and how does the reservation model work? In this episode of BigQuery Spotlight, we’ll review jobs, reservations, and best practices for managing workload in BigQuery. We’ll also walk you through the difference between BI Engine reservations and standard reservations, so you can decide what will work best for you.
Jul 1, 2021   |  By Google BigQuery
What is a BigQuery table and how does it work? In this episode of BigQuery Spotlight, we’ll review the different types of tables in BigQuery, including managed tables, external tables, and virtual tables with logical and materialized views. We’ll also walk you through the use of views, which are virtual tables defined by a SQL query.
Jun 24, 2021   |  By Google BigQuery
What are folders, projects, and datasets and how do they come together to support warehousing fundamentals like security and cost management? In this episode of BigQuery Spotlight, we’ll review the BigQuery resource model and how this resource hierarchy is reflected in the Cloud Console, where you’ll interact with and analyze your BigQuery data. Moreover, we’ll give you some helpful tips when it comes to structuring your own BigQuery resources. Watch to learn the best way to structure your BigQuery deployments!
Jun 2, 2021   |  By Google BigQuery
How can you replicate data from a relational database in real time? In this video, we’ll show you you can combine Datastream with Dataflow templates to replicate data from a relational database. Watch to learn how you can use this streaming analytics service in unison with Datastream to easily replicate data from Oracle to BigQuery in real time!
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.

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.