Database column this maps toįor models based on SQL queries, you can tell Metabase if the column has the same type as an existing database column. DescriptionĪ place to write helpful context for the column. What people will see as the column’s name. If you only set one kind of metadata, set the Column type to let Metabase know what kind of data it’s working with. Metadata will also make filtering nicer by showing the correct filter widget, and it will help Metabase to pick the right visulization for the results. With models, however, you can tell Metabase what kind of data is in each returned column so that Metabase can still do its drill-through magic. What this means in practice is that people won’t be able to drill-through the results, or explore the results with the query builder, because Metabase doesn’t understand what the results are. When you write a SQL query, Metabase can display the results, but it can’t “know” what kind of data it’s returning (like it can with questions built using the query builder). To edit the model’s underlying query, click Edit definition. To start a new question based on the model, click Explore. The model detail page also shows some basic info about the model: Actions: lists the actions in the model, and allows you to create new actions.Used by: lists the items based on the model.From a model: click on the info button in the upper right, then click Model details.From a collection: click on the book icon next to a model.Click on the … > Turn this into a model.Ask a question using either the query builder or the SQL editor, or select an existing saved question that you want to convert to a model.The advantage of using the query builder is that Metabase will be able to fill out some of the metadata for you if you use SQL, you’ll have to fill out that metadata manually. Choose either the query builder or a native query (if you want to use SQL).
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |