As you can see from the examples below, we can use this view in a variety of different ways.
Sometimes coming up with a short descriptive name for your view is easier said than done. You can also see that we have take the birth date column and calculated age.
The example below shows all of the code from the view.
You can think of a view as a lens looking at one or more tables.
A view is really nothing more than a logical representation of one or more tables in a database.
You could also do a SELECT *, or further restrict the columns you want to see.
You can also add additional row restriction to the view as we have done.
When you create a view in a dataset, the dataset's access controls determine the users and groups allowed to access the view.
For example, if you assign the role at the dataset level, the user can create, update, get, and delete views only in that dataset.
You can update the SQL query used to define a view using the web UI, CLI, or API.