• Products
  • Documentation
  • Resources

Atlassian Analytics is in an early access program

Only people who are part of this invite-only early access program have access to Atlassian Analytics.

How is data structured in the Atlassian Data Lake?

Each product has its own set of tables and columns in the Atlassian Data Lake. If you choose to include all data for your products, more columns are added to each of those tables.

Only data for Jira Software, Jira Service Management, Jira Work Management, and Opsgenie are available in the Atlassian Data Lake at this time. Data for more products are coming soon.

The product tables capture product data in a star schema, meaning some tables refer to other tables. Because of this, you may need to join multiple queries to get the data you need in Atlassian Analytics.

Learn more about the:

Data freshness

These tables rapidly reflect changes in your products, typically within half an hour. This makes them especially useful for custom analysis, or when having the most up-to-date information is important.

Dates and timestamps in the Data Lake are in UTC

Keep in mind that all columns with dates and timestamps (for example, created_at, updated_at, etc) are in the UTC time zone. To convert these to use a different time zone, either change your workspace time zone in your workspace settings or the individual dashboard’s time zone in its dashboard settings.

Additional Help