Publishing and using a data model
1. Publishing and using a data model
Now that you've created a basic data model, let's see how they're used in a workbook, and some of the administrative tools we have available to manage them.2. Data models in the workbook
First, recall that the main advantage of data models is that their elements can be used as a data source in workbooks.3. Data models in the workbook
To use a data model as a source in a workbook, use the add Element bar to add a table. In the Select source modal, select Data sources, and explore your Documents. Here, you can select a data model and element to add.4. Data models in the workbook
You can also identify when a workbook table is sourced from a data model using the workbook lineage. In a workbook, select lineage. On the left-hand edge of the graph, look for sources with the data model icon. These identify the data model element, and the table directly downstream of them uses the data model as a source. You can open the data model directly from the lineage by selecting the source, and clicking open.5. Published data models
To get an overview of everywhere a data model is referenced, you can use the published version of the data model. When you're done editing a data model, click publish, and then select Go to published version.6. Published data models
You'll notice that the layout is different from when editing. This layout lists every data model table, and provides several administrative options for them.7. Published data models
For each source, you can select Explore to open a workbook and explore the table as a data source. You can also select View details to see the columns, metrics, and lineage for that table. Under lineage, you can see all the workbooks that reference this data model table as a source.8. Published data models
The published version offers an excellent layout for centrally administering your data model, and will become increasingly useful as we discuss features like metrics and relationships later in this course.9. The ERD view
Finally, as we develop more complex data models, we'll rely on the Entity Relationship Diagram or ERD view to easily track and review sources in the model and their relationships.10. The ERD view
The ERD view shows all the current sources, and their columns. It also shows details of advanced features, like relationships between tables, materialization schedules for sources, and column-level security.11. The ERD view
For now, our data models are simple, but as we add more tables and leverage more features, the ERD view will become vital to tracking the contents of our data model and how they're related.12. Let's practice!
Now for an exercise, where you'll leverage a data model as a source in a workbook.Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.