Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


What is the difference between Current_DW and Export_DW tables in Enterprise Insights?

We are seeing more data in the Export_DW tables than the Current_DW tables coming from Enterprise Insights  Could you help me understand the difference between these two tables and what are uses cases of Export vs. Current?

2 answers

2 accepted

0 votes
Answer accepted
Heidi Hendry
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Dec 08, 2022

Hi Jason,

You may find this video helpful too in order to expand your understanding of the Jira Align Enterprise Insights Data Schema. Sam discusses export_dw and current_dw in the video as well as other useful topics.

Understanding the Jira Align Enterprise Insights Data Schema | Atlassian - YouTube

Outstanding, thank you very much, this is exactly what I was looking for.

0 votes
Answer accepted
Derek Huether
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
Dec 07, 2022 • edited

Hey Jason!
This is an excellent question.

The "export_dw" schema is designed for those bringing the data into a data lake.

  • It contains a "Date DW Modified" column on every view which identifies the last time that a row was modified in the EI database.  Incremental loading is very straightforward using this column.

  • It contains a "Deleted Flag" to identify deleted rows in the source system.  "Soft Delete"

If you're writing reports directly (Tableau, Power BI,...) from Enterprise Insights data, I recommend using current_dw.

I hope this helps,


This is very helpful.  A followup questions is why does the export_dw show more accurate info (meaning it matches what I see in the tool) for Sprint Team members than the current_dw?  Why would the current_dw seemingly be less accurate with what is currently shown in the tool UI?

Derek Huether
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
Dec 08, 2022 • edited

I'm not sure specifically what you're seeing in your environment but current_dw & export_dw are based on the same underlying table.  The only difference is that current_dw filters out deleted records.

Like Jason likes this

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events