This guide will take you from defining data models to exploring data and sharing data with your team.
Once you get access to Glean, you will be invited to login to a project. Users can belong to multiple projects, but data cannot be shared between projects. So users, permissions, database connections, data models and every other resource is isolated in the context of a project. Typically your entire organization can be managed in a single project.
Not ready to connect to a database?
You can use a Sandbox demo project to test the functionality of Glean with sample datasets.
1. Add a database connection
Also see database connections for configurations specific to different database types.
If you use a firewall to restrict access to your database, you'll need to allowlist Glean's IPs.
Glean will always connect to your database from one of these IP addresses.
- Go to the
+ New Database Connection
- Select the type of database; either Athena, BigQuery, Snowflake, Postgres or Redshift
- Enter the credentials according to your type of database
Testto test your connection
Addto complete the process
2. Define a data model
Every chart and analysis is based on a Glean data model.
- Go to your
project homepageand click
New Data Model
Select a database connection, click on a table name, and click
Using a SQL Query
Each Glean data model is based on an underlying data table. If the data in your data isn't quite in the right format, it's possible to specify an underlying query as the basis for your data model.
Define the data model
- Edit the name of the data model at the top of the page
- Add additional metrics and attributes by clicking
Add Attributenext to the name of the field
- Create a SQL based custom metric by clicking
+ Add Custom Metric(see Metrics for more details)
Save Modelthen click
Open in Exploreto start exploring the data
3. Start interacting with your data
- Go to the
- Click on the name of the data model we just created
You're ready to begin interacting with your data
Next, learn how to use the
Attributes Tray to filter and breakout your data