Google BigQuery

Mountain View, CA, USA
Sep 9, 2021   |  By Drew Whang
Advertising agencies are faced with the challenge of providing the precision data that marketers require to make better decisions at a time when customers’ digital footprints are rapidly changing. They need to transform customer information and real-time data into actionable insights to inform clients what to execute to ensure the highest campaign performance.
Sep 8, 2021   |  By Anna Epishova
When you build a data warehouse, the important question is how to ingest data from the source system to the data warehouse. If the table is small you can fully reload a table on a regular basis, however, if the table is large a common technique is to perform incremental table updates. This post demonstrates how you can enhance incremental pipeline performance when you ingest data into BigQuery.
Sep 1, 2021   |  By Carlos Augusto
Organizations are increasingly investing in modern cloud warehouses and data lake solutions to augment analytics environments and improve business decisions. The business value of such repositories increases as customer relationship data is loaded and additional insights are generated.
Sep 1, 2021   |  By Leigha Jarett
Over the past few weeks, we have been publishing videos and blogs that walk through the fundamentals of architecting and administering your BigQuery data warehouse. Throughout this series, we have focused on teaching foundational concepts and applying best practices observed directly from customers. Below, you can find links to each week’s content: Query Processing : Ever wonder what happens when you click “run” on a new BigQuery query?
Aug 26, 2021   |  By Jean-Francois Macresy
French multinational automotive manufacturer Renault Group has been investing in Industry 4.0 since the early days. A primary objective of this transformation has been to leverage manufacturing and industrial equipment data through a robust and scalable platform. Renault designed an industrial data acquisition layer and connected it to Google Cloud, using optimized big data products and services that together form Renault's Industrial Data Platform.
Aug 26, 2021   |  By Jignesh Mehta
Last week, we shared information on BigQuery APIs and how to use them, along with another blog on workload management best practices. This blog focuses on effectively monitoring BigQuery usage and related metrics to operationalize workload management we discussed so far.
Aug 19, 2021   |  By Jignesh Mehta
In the most recent season of BigQuery Spotlight, we discussed key concepts like the BigQuery Resource hierarchy, query processing, and the reservation model. This blog focuses on extending those concepts to operationalize workload management for various scenarios.
Aug 19, 2021   |  By Leigha Jarett
So far in this series, we’ve been focused on generic concepts and console-based workflows. However, when you’re working with huge amounts of data or surfacing information to lots of different stakeholders, leveraging BigQuery programmatically becomes essential. In today’s post, we’re going to take a tour of BigQuery’s API landscape - so you can better understand what each API does and what types of workflows you can automate with it.
Aug 19, 2021   |  By Snehanshu Shah
If the COVID-19 pandemic has taught us anything, it is that speed and intelligence are of the essence when it comes to making business decisions. Organizations must find ways of keeping ahead of competitors and disruptions by continually leveraging data to make smart decisions. The problem? Data may be everywhere, but it’s not always available in a form that businesses can use to generate analytics in real time.
Aug 12, 2021   |  By Leigha Jarett
Hopefully you’ve been following along with our BigQuery Admin series and are well on your way to getting ramped up with BigQuery. Now that you’re equipped with the fundamentals, let's talk about something that’s relevant for all data professionals - data governance.
Sep 13, 2021   |  By Google BigQuery
Here to bring you the latest news in the Cloud is Alicia Williams. Chapters: Tune in every week for a new episode and let us know what you think of the latest announcements in the comments below!
Aug 26, 2021   |  By Google BigQuery
Want to ensure that your BigQuery environment stays cost effective and secure? In this episode of BigQuery Spotlight, we’ll examine how monitoring your data warehouse can optimize costs, help you pinpoint which queries need to be optimized, and audit both data-sharing and access. Watch to learn how BigQuery gives you the flexibility to export any of these data sources back into your data warehouse for custom reporting.
Aug 19, 2021   |  By Google BigQuery
Want to become more scalable with programmatic data workflows? In this episode of BigQuery Spotlight, we’ll examine BigQuery APIs so you can manage data warehousing resources, and take action on your data, programmatically and effectively.
Aug 17, 2021   |  By Google BigQuery
Data harnessed through tools such as BigQuery allow organizations to deliver personalized experiences, make data-driven business decisions, and unlock new streams of revenue. In this video, we go through the challenges of putting data into action and show how APIs can help. Watch to learn how Apigee makes it simple and easy to package your business data as APIs!
Aug 12, 2021   |  By Google BigQuery
Want everyone in your organization to be able to easily find the data they need, while minimizing overall risk, and ensuring regulatory compliance? In this episode of BigQuery Spotlight, we’ll examine BigQuery data governance so you can ensure your data is secure. We’ll also go over Cloud Data Loss Prevention and an open-source framework for data quality validation.
Aug 5, 2021   |  By Google BigQuery
Did you know that optimizing SQL queries can be cost efficient? In this episode of BigQuery Spotlight, we speak to some strategies for optimizing your BigQuery queries. We’ll walk through what happens behind the scenes for more complex queries, and show you specific tactics you can use to optimize your SQL. Watch to learn some great techniques on how to make your queries more performant!
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!

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.