Use the Enterprise Insights schema in Atlassian Analytics

Atlassian Analytics uses a customized schema from Enterprise Insights (EI) to build dashboard templates and provide you with the ability to customize reports, based on data from your Jira Align instance.

On this page:

• What is the Enterprise Insights schema?
• Schema differences in Atlassian Analytics
  • Unavailable tables and columns
  • Hidden tables and columns
• Sync an updated schema

What is the Enterprise Insights schema?

A data schema is a blueprint or mapping that defines how data is organized, stored, and managed in a database. It outlines the tables and columns within the system. Tables refer to objects or concepts in Jira Align, including different work item types, time containers, and pages. Columns represent fields or attributes available within each table.

To learn more about the schema used by Enterprise Insights, review this video:

Schema differences in Atlassian Analytics

To make it easier to navigate and use the Enterprise Insights schema in Atlassian Analytics, we’ve removed some tables and set the visibility of rarely-used tables and columns to hidden.

Entries in the schema are based on the current_DW schema tab found inside the full Enterprise Insights schema file.

Unavailable tables and columns

To determine if a specific table and column are available in Atlassian Analytics, you can check the schema file:

1. Open the latest Enterprise Insights schema file.
2. Select the AA_Schema tab.
3. Find the table and column name you’re interested in, and check the Available column.
   1. If the cell is set to Yes, the table/column is available for use in Atlassian Analytics.
   2. If the cell is set to No, the table/column has been removed from the schema and is unavailable.
4. If you would like to use an unavailable table or column with Atlassian Analytics, contact Jira Align Support to open an enhancement request.

Hidden tables and columns

The quickest way to determine if a table or column is visible or hidden in the schema is through Atlassian Analytics:

1. Select Data from the top navigation bar to see your data sources.
2. Select your Enterprise Insights data source.
3. Select the Schema tab at the top of the page.
4. Enter the table or column name in the search bar at the top. Results will display automatically.
5. To the right of the table or column you want to review, ensure the Visible checkbox is checked.
6. If the Visible option is not checked, the table or column is hidden from Atlassian Analytics. If you have permission to manage the data source, you can check the checkbox to make the table or column visible.

Note: You must have permission to manage the data source to check the Visible checkbox.

You can also review the latest Enterprise Insights schema file, and check the Default visibility column in the AA_Schema tab. If a cell is set to Hidden, follow the instructions above to make that table/column visible.

When creating a query in Atlassian Analytics, you can also use the Show full schema toggle in the schema browser to see all available tables and columns:

Sync an updated schema

In rare cases, the schema may be updated to respond to an enhancement request to add an unavailable table or column. After the schema is updated, you’ll need to sync in Atlassian Analytics to see changes. To sync your updated schema, follow the instructions in the Sync schemas article.