Add Looker-on Initials with airSlate SignNow

Add signed looker-on

hi I'm Jake Newman documentation manager at liquor the previous video in this series talked about auto-generated explores and how to role modeling to production this video shows how to use the editor to join more views to your Explorer along the way we'll show the relevant documentation links to learn more about each topic in this video first we'll navigate to our project we can see our data modeling files the first thing we'll do is add two additional views so that we can get information from two additional database tables we could make the views from scratch but let's let look or generate them let's pick the two database tables and click create view looker created a view file for each additional database table the editor uses green dots to highlight files that are new or changed each of our newly generated views inventory items and product has fields for all of the columns in the corresponding database table plus account field the new views do not yet appear in our Explorer our model is already set up to include all view files by the way looker provides sample luca mel in the comments we could use that as a starting place but we'll write our definitions from scratch next we'll join our new views to our order items explore if you are familiar with sequel joins work the same way in looker enabling looker to combine data from multiple views then users can explore data from multiple views at the same time our Explorer is based on the order items view inside the Explorers definition we'll add a join for the inventory table before we talk about these individual parameters notice how the editors suggests possible the Kamel parameters values and field names as we type if you've worked with sequel before this will probably look familiar our documentation covers these parameters in detail but basically we've joined the order items explorers view to our inventory items view we're using a left outer join which means we'll include all of the qualifying rows in our order items view and use any matching rows in the inventory items view both views include an ID for the inventory item so we've joined on those fields since there could be many orders that include a particular type of item but that type of item only has one row in the inventory items view we specify that the views have a many to one relationship so we're ready to save these changes because we changed our model file it has a green dot and the Rose we changed have green highlighting will add another joint for our products table now our new view files are joined to our order items Explorer we'll save and validate the editor catches most errors while you type or when you save validation catches some additional types of errors in this case everything validates still in Def mode let's look at our Explorer our two new views are now part of the explore and expanding inventory items in the field picker we see our auto-generated fields as another example our product database table has more columns scrolling down we see all of the corresponding view fields plus the auto-generated count field now users can select fields from all of these views to create their queries and looker writes a sequel query that includes only the joints that are needed to return the appropriate data in this video we generated several views and join them into our explore in the next video we will see how to use the luca mel editors features while creating additional fields that weren't in our database table