How to create a BigQuery view

Question

How do I create a BigQuery view using a UI command or a BQ command line?

I wanted to create a view like:

create view mydataset.myview as select field1, field2 from mydataset.mytable

Answer 1

• Edit the request in the web interface
• Select "Save View" (next to the "Run Query" button)
• customize name and data set

...

Answer 2

It looks like it now supports creating views through standard sql. It is required to specify the project, data set and table / view name. for instance

create view 'myproject.mydataset.myview' as select * from 'myproject.mydataset.mytable';