Learn how to connect and manage your connected Atlassian data and external data.
Learn how to create insightful charts and dashboards with your organization’s data.
Learn how to use Visual SQL to create queries and transform data for making charts.
Need feedback on data? Learn how to share charts and dashboards with teammates so they can leave comments.
Learn how to grant resource access to the people who need it.
Learn how to manage your workspace and how to monitor your workspace activity.
Atlassian Analytics is in open beta
Only customers with a Cloud Enterprise plan for Jira Software or Jira Service Management have access to Atlassian Analytics.
Atlassian Analytics is able to pull multiple schemas for new Redshift, BigQuery, Snowflake, Amazon Athena, and PostgreSQL data sources. For other data sources, you can only have one schema per data source connection in Atlassian Analytics, so you’d need to create separate data source connections to add more schemas.
If your data source can’t pull in multiple schemas, you can create custom tables that pull from tables in your other schemas. Custom tables allow you to write SQL that Atlassian Analytics inserts directly into visual mode queries. So, you can create a custom table with the following SQL (replacing schema_name and table_name with relevant information from your database):
For reference, you can run the following command for MySQL and PostgreSQL data sources to view all available tables and views in all schemas:
Reflect multiple schemas
You must have permission to manage the data source to add more schemas.
If Atlassian Analytics supports multiple schemas for your data source, you can reflect them into one data source by doing the following:
Go to the Data tab.
Select the data source in which you’d like to reflect multiple schemas.
Go to the Connection tab.
From the schema selector, select the schemas you’d like to add to Atlassian Analytics.
Select Save. This will take you to another screen.
Select the schemas and tables to include in Atlassian Analytics.
Atlassian Analytics automatically applies your changes then takes you to the Schema tab, where you can edit your schemas as needed.
Get a list of available schemas
Most schemas are defaulted to public unless a specific schema is used. To find out which schema to reflect for your data source, you can run the following query on your data source to list all available schemas; however, not all data sources have this functionality.
Microsoft SQL Server
You can leave the schema blank since for MySQL, physically a schema is synonymous with a database.
Was this helpful?