A tour of BigQuery tables

preview_player
Показать описание

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.

Timestamps:
0:00 - Intro
0:21 - What is a table?
1:20 - Managed tables
2:37 - External Tables
4:44 - Views
6:24 - Recap and Summary

#BigQuerySpotlight

product: Cloud - Data Analytics - BigQuery; re_ty: Publish;
Рекомендации по теме
Комментарии
Автор

What a clear cut explanation! Easy to understand. Great job!

kksrikanth
Автор

I'm confused. Do Logical Views support Authorized Views? She said they do but there's a red X next to it in the list.

kevinyang
Автор

Isn’t Authorized Views a feature? Why is it with a Cross?

Santiagosony
Автор

is it possible to update only the modified or newly added data, so that every time it does not have to go through the whole table?

shreyaspatil
Автор

Are there any videos on Temporary tables?

jerryjosejames
Автор

Great explanation. But why are these episodes out of sync.

prasannpattar
Автор

how can i change the integer column to string? is there any commands available ?

PremAnand-kbqo
Автор

Can anybody answer, could we insert more data on external table which is made from csv table on cloud storage?

herikim
Автор

great explanation, you look like aunt may from new spider man.

vishnureddy