Use the Enterprise Insights schema in Atlassian Analytics


Vector.png

The old navigation will be removed from Jira Align in early 2024.
Learn more about the upcoming changes


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?

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:

ShowFullSchema.gif

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.

Was this article helpful?
0 out of 0 found this helpful
Print Friendly Version of this pagePrint Get a PDF version of this webpagePDF

Join the Atlassian Community!

The Atlassian Community is a unique, highly collaborative space where customers and Atlassians come together. Ask questions and get answers, start discussions, and collaborate with thousands of other Jira Align customers. Visit the Jira Align Community Collection today.

Need to contact Jira Align Support? Please open a support request.