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.

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!

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!

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.

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;

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;

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;

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.

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.

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!