How to Create a View in BigQuery

Any view has an associated select to obtain the view data, in order to create a view you need to use a SQL statement defining the view name and the view select:

create view Database_test_IB1.employees_making_more_than_100k as
select emp_id, first_name, last_name
from   Database_test_IB1.employee
where  salary > 100000.00;

IN THIS PAGE