Connect to a data source
A data source is a supported database or application housing the data you’d like to access. Data sources could be within Atlassian or external, third-party tools.
When you connect a data source to Insights, you set up an integration with it. This means that when you ask questions in Insights, your answers will contain the most up-to-date data that’s available from the connected data sources
Atlassian data sources
Atlassian Data Lake
If you use Insights (previously Analytics), your organization is connected to Atlassian Data Lake, giving you access to data across Atlassian apps within your organization. Read about Atlassian Data Lake
If you’ve turned on Insights, your workspace automatically includes permission-enforced connection to Atlassian Data Lake. Queries to Atlassian Data Lake run as the signed-in user and results are limited to the data that person has permission to access. So two people running the same query may get different results.
When Insights becomes available for your workspace, this connection automatically appears under Connectors in Atlassian Administration. Understand data management in Insights
Teamwork Graph
In addition to Atlassian Data Lake, you can also connect to Teamwork Graph, which connects teamwork data from across Atlassian apps, like Jira and Confluence, as well as external tools.
When you access Insights, you will be prompted to connect Teamwork Graph. Follow the instructions to connect it to Insights.
Jira Align Enterprise Insights
If you have Jira Align, your Insights app is automatically connected to it. This will enable your organization to access your Jira Align data in Insights. Read about Jira Align Enterprise Insights
Third-party data sources
Insights also lets you connect to your third-party data sources. With the help of Atlassian and third-party data sources, Insights can provide more robust answers and create detailed dashboards.
The supported data sources include:
Data source | Availability in plans (Standard, Premium, and Enterprise) |
|---|---|
BigQuery | Standard, Premium, and Enterprise plans |
Databricks | Standard, Premium, and Enterprise plans |
Google sheets | Standard, Premium, and Enterprise plans |
Microsoft SQL server | Standard, Premium, and Enterprise plans |
MySQL | Standard, Premium, and Enterprise plans |
Oracle | Standard, Premium, and Enterprise plans |
Postgres | Standard, Premium, and Enterprise plans |
Redshift | Standard, Premium, and Enterprise plans |
Snowflake | Standard, Premium, and Enterprise plans |
Airflow | Enterprise only |
dbt Cloud | Enterprise only |
dbt Core | Enterprise only |
Fivetran | Enterprise only |
Glue | Enterprise only |
Looker | Enterprise only |
PowerBI | Enterprise only |
Quicksight | Enterprise only |
Tableau | Enterprise only |
Read what metadata is collected from third-party data sources
Connect to a third-party data source
To connect to a third-party data source:
Under Data context, select Data sources.
Select Add data source.
Select the third-party app or tool you want to connect to.
Add the required information and follow the steps in the UI to establish a connection. Refer to the third-party app’s integration documentation, if required.
Set query permissions for data sources
Organization admins can control access to internal and third-party data sources by setting permissions on who can query certain sources.
To modify query permissions for data sources:
Select Data sources from the sidebar.
Select a data source from the list. If you don’t see the data source you need, select Add data source to connect to the data source.
Select Preferences and find the Query permissions section.
Add the users or groups you want to provide permission to for Rovo Insights and Previews. By default, all users in the organization are granted permission to query a data source.
Was this helpful?