A tour of BigQuery tables

[@kksrikanth]

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

[@googlecloudtech]

Glad you enjoyed it!

[@Santiagosony]

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

[@tenaandrew]

yeah maybe they didnt check it

[@kevinyang2909]

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.

[@herikim1088]

I saw case that users who had access to other projects but who had no access to my team's bigquery project tables had access to data by logical view.

[@shreyaspatil465]

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?

[@PremAnand-kb9qo]

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

[@googlecloudtech]

One option is using CAST to change the column's data type. cloud.google.com/bigquery/docs/managing-table-schemas#cast_a_columns_data_type

[@herikim1088]

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

[@aliciawilliams5520]

External tables are read-only by BigQuery, you can read more in cloud.google.com/bigquery/docs/external-tables#limitations. However, one idea would be to use an EXPORT DATA statement (cloud.google.com/bigquery/docs/reference/standard-sql/other-statements#export_data_statement) to overwrite the original GCS csv file (after appending data and preventative de-duping with SQL). You also may consider upgrading to a BigLake External Table (cloud.google.com/bigquery/docs/external-data-cloud-storage#upgrade-external-tables-to-biglake-tables) if you want some additional features related to performance and security.

[@jerryjosejames6679]

Are there any videos on Temporary tables?

[@ShivamKumar-vv2op]

Thanks for sharing

[@prasannpattar9483]

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

[@trishakr]

Wow.

[@alphaXroyal1]

Aunt May?

[@shiveshgupta221]

lolz

[@verdipratama]

beauty

[@MrButter765]

fr

[@jaydeest]

simp incel

[@vishnureddy1819]

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