Materialized Views
-
Materialized views can be created from datasets in other projects within the CTA organization by utilizing Authorized Datasets (see this article for instructions on how to create an Authorized Dataset) or Authorized Views. However, a materialized view must reside in the same organization as the base tables, so public datasets provided by Google are not supported for use in Materialized Views.
Temporary Tables
- In order to save a temporary table in BigQuery, you will need to change your settings to session mode. To enable this, from the Query Editor, go to more and select Query Settings. Then scroll down to ‘Session Management’ and click the check box to ‘Use Session Mode’. You'll be able to confirm that you are in session mode if you see the following icon.
- If you want to insert more data into, query or otherwise manipulate your temporary table, you’ll need to find the full name/ID of your table. To find this, go to the PERSONAL HISTORY along the bottom of the BigQuery Console. Select the stacked dot Actions menu beside the job you ran to create the temporary table and select Show job details.
From there you can click on the link for the destination table, and find the table name/ID in the DETAILS.
You can copy the name directly to your clipboard and paste it into your Query Editor.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article