Create Looker-on Currency with airSlate SignNow

Create looker-on currency

[Music] this video explains how to build an explore for your business users an explorer is the starting point for queries is based on a view and shows a specified set of fields from the view additional views can be joined into the explore before jumping into the details it's important to note that not all views are explorers because not all views describe an entity of interest for example a states view that corresponds to a lookup table for states names doesn't warrant an explorer because business users never need to query it directly on the other hand business users probably want a way to query an order's view so defining an explorer for orders makes sense explores are usually defined within a model file but can also be defined in a separate explore file in your lookaml model file you see your only explore order items here this explorer was automatically generated based on the order item's view you brought in when you created your project you can join additional views to this explorer when a user creates a query that includes fields from multiple joined views looker automatically generates sql join logic to bring in all fields correctly start by adding the tables you want to join to your project you'll add them as view files in the file browser click on the menu of the folder where you want to create your view and then click create view from table you could create a view from scratch but if you have an existing database table this is the recommended method choose your database connection let's say you want to join information about inventory items and products click the check boxes next to those tables then scroll to the bottom and click create views looker shows all files in your project and confirms that your two new views have been created from the tables let's click the products view to go back to your data model the editor marks new or changed files with a dot as you can see here each of your newly generated views has fields for all the columns in the underlying database table plus a count field so now you have three separate views but only one explorer to enable your users to query data from all three of these tables at once you need to join the views together in your model the first step is to make sure you are telling looker to include your newly created view files to do this you need to write an include statement that uses the file extension.view for view files you can leave out the dot lkml part of the file extension looker recommends that you include just the view files you want to join to the explorer if you include all the view files it adds clutter and can slow things down the light gray commented out code exists as an example you could use this as a starting point but in...