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

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

Avatar

1 badge earned

Collect

Participate in fun challenges

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

Challenges
Coins

Gift kudos to your peers

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

Recognition
Ribbon

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!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,457,958
Community Members
 
Community Events
176
Community Groups

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 Atlassian Team 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

0 votes
Answer accepted

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,

Derek

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?

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
TAGS

Atlassian Community Events