What a clear cut explanation! Easy to understand. Great job!
@googlecloudtech3 жыл бұрын
Glad you enjoyed 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.
@Santiagosony3 жыл бұрын
Isn’t Authorized Views a feature? Why is it with a Cross?
@tenaandrew3 жыл бұрын
yeah maybe they didnt check it
@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?
@ShivamKumar-vv2op3 жыл бұрын
Thanks for sharing
@jerryjosejames66792 жыл бұрын
Are there any videos on Temporary tables?
@prasannpattar94833 жыл бұрын
Great explanation. But why are these episodes out of sync.
@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
@trishakr3 жыл бұрын
Wow.
@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.
@alphaXroyal12 жыл бұрын
Aunt May?
@shiveshgupta2212 жыл бұрын
lolz
@verdipratama3 жыл бұрын
beauty
@MrButter7652 жыл бұрын
fr
@jaydeest2 жыл бұрын
simp incel
@vishnureddy18192 жыл бұрын
great explanation, you look like aunt may from new spider man.