How do I create a BigQuery View

Question

How could I create a BigQuery view via UI command or BQ command line?

I want to create a view like:

CREATE VIEW mydataset.myview AS
SELECT field1, field2 
FROM mydataset.mytable

Answer 1

1. Edit your query in the web UI
2. Choose "Save View" (near the "Run Query" button)
3. configure the name and dataset

...

Answer 2

It looks like now is supported the views creation through standard sql. It requires specify project, dataset and table/view name. For example

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