Add a Data Model
When possible, you should try to modify or extend an existing data model instead of adding new data models for each new analysis. This section shows you how to quickly add data if you're getting started, you should also check out Data Models Overview and Data Modeling Best Practices
Preparing Data for Glean— Each Glean model is based on an underlying data table. For more technical advice see the best practices section on creating denormalized data tables. If your data isn't quite in the right format in your database, it's possible to specify an underlying data query that will run as you explore data.
- From your project homepage (opens in a new tab), click
New Model
. - Select the data connection you'd like to use or
Uploads
if you want to use a file from your computer. - Select either an existing table or click
SQL Editor
to use a custom query. - Click
Build Model
to create the initial data model (all date fields and a row count measure are added by default). - Edit the name of the data model at the top of the page.
- Add additional measures and attributes by clicking
Add measure
andAdd attribute
next to the name of the field. - Create a SQL based custom measure by clicking
+ Add custom measure
(see Measures for more details). - Click
Save Model
then clickOpen in Explore
to start exploring the data.