To understand who is accessing content or running queries in your Lightdash projects, we’ve built usage analytics to help you track this.
There are two ways of understanding user activity:
Each project has usage analytics dashboards created by Lightdash giving you an overview of your project’s content and user activity.
To see your usage analytics dashboards for a project, just click on the settings
icon, project settings
, then usage analytics
.
Or you can also use our search bar to get direct access to the different analytics dashboards by typing the name of the dashboard (eg: User activity)
This dashboard gives you an overview of the users in your project and the activity of your users.
Here’s an overview of the fields used in the dashboard:
viewer
role that have access to the project.editor
role that have access to the project.admin
role that have access to the project.Query tags are metadata which is added to your data warehouse queries and gives you information about the user_id
, project_id
and organization_id
for each query executed.
Query tags are stored differently in each data warehouse:
Data Warehouse | Query Tag |
---|---|
BigQuery | Persists in the labels parameter in your job history. |
Snowflake | Persists in the comment parameter in your query history. |
Trino | Appends to the SQL in your query history. |
Redshift | Appends to the SQL in your query history. |
Databricks | Appends to the SQL in your query history. |
Postgres | Appends to the SQL in your query history. |
To understand who is accessing content or running queries in your Lightdash projects, we’ve built usage analytics to help you track this.
There are two ways of understanding user activity:
Each project has usage analytics dashboards created by Lightdash giving you an overview of your project’s content and user activity.
To see your usage analytics dashboards for a project, just click on the settings
icon, project settings
, then usage analytics
.
Or you can also use our search bar to get direct access to the different analytics dashboards by typing the name of the dashboard (eg: User activity)
This dashboard gives you an overview of the users in your project and the activity of your users.
Here’s an overview of the fields used in the dashboard:
viewer
role that have access to the project.editor
role that have access to the project.admin
role that have access to the project.Query tags are metadata which is added to your data warehouse queries and gives you information about the user_id
, project_id
and organization_id
for each query executed.
Query tags are stored differently in each data warehouse:
Data Warehouse | Query Tag |
---|---|
BigQuery | Persists in the labels parameter in your job history. |
Snowflake | Persists in the comment parameter in your query history. |
Trino | Appends to the SQL in your query history. |
Redshift | Appends to the SQL in your query history. |
Databricks | Appends to the SQL in your query history. |
Postgres | Appends to the SQL in your query history. |