You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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?
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.
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,
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.