In this post, I’ll introduce two easy ways to create views in BigQuery directly in Google Cloud console.
Option 1 – Create and run your query. Then save it as view.
1. Create a query for your view & run the query
![](https://stuffbyyuki.com/wp-content/uploads/2023/05/image-1024x575.png)
2. Just click save as view
![](https://stuffbyyuki.com/wp-content/uploads/2023/05/image-1-1024x398.png)
Option 2 – Use “Create View As”
Just like you do in other databases, use
![](https://stuffbyyuki.com/wp-content/uploads/2023/05/image-2-1024x352.png)