{"id":1293,"date":"2022-07-27T14:22:00","date_gmt":"2022-07-27T18:22:00","guid":{"rendered":"https:\/\/myapps.northcarolina.edu\/insight\/?p=1293"},"modified":"2022-07-27T14:56:51","modified_gmt":"2022-07-27T18:56:51","slug":"dyk-tableau-10-years-redshift-longer","status":"publish","type":"post","link":"https:\/\/myapps.northcarolina.edu\/insight\/2022\/07\/27\/dyk-tableau-10-years-redshift-longer\/","title":{"rendered":"Did You Know: Tableau data retained 10 years, Redshift longer"},"content":{"rendered":"<p>As <a href=\"https:\/\/myapps.northcarolina.edu\/insight\/resources\/?table_filter=notes\">discussed among the Insight community since June 10th, 2022<\/a>, Tableau data will be retained for 10 years, rolling. For example, the RLS Applications data extract currently dates back to Summer I 2009. With this change, it will be retained back to Summer I 2013, and dashboards using that source will align. Each year, the oldest year will be removed. This change is being made to improve efficiency and performance, especially the daily refreshes of the data, and provide a more predictable storage capacity, and limit future storage upgrade costs to subscribers.<\/p>\n<p>This change will occur beginning Monday, August 1, 2022, and continue for a few days.<\/p>\n<p>This 10 year data retention limit ONLY affects Tableau extracts and related dashboards. Redshift warehouse data will have full retention.<\/p>\n<p>As always, your feedback is welcome and encouraged via email to <a href=\"mailto:insight@northcarolina.edu?subject=Dictionary info linked from datasets list\" target=\"_blank\" rel=\"noopener\">insight@northcarolina.edu<\/a>.<\/p>\n<p>The Insight Team<br \/>\n<a href=\"https:\/\/myapps.northcarolina.edu\/insight\/\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-844\" src=\"https:\/\/myapps.northcarolina.edu\/insight\/wp-content\/uploads\/sites\/19\/2019\/11\/insight-logo.png\" alt=\"UNC Insight logo\" width=\"260\" height=\"84\" \/><\/a><br \/>\nYou can\u00a0<a href=\"https:\/\/lists.northcarolina.edu\/postorius\/lists\/insight-info.lists.northcarolina.edu\/\">subscribe directly<\/a>\u00a0to receive email notices about Insight and Did You Know. <a href=\"https:\/\/myapps.northcarolina.edu\/insight\/did-you-know\/\">Past DYK posts are available on\u00a0a blog<\/a>. If you have Insight access issues or dashboard content questions or concerns, please email\u00a0<a href=\"mailto:insight@northcarolina.edu\">insight@northcarolina.edu<\/a>\u00a0to open a ticket.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>As discussed among the Insight community since June 10th, 2022, Tableau data will be retained for 10 years, rolling. For example, the RLS Applications data extract currently dates back to Summer I 2009. With this change, it will be retained back to Summer I 2013, and dashboards using that source will align. Each year, the [&hellip;]<\/p>\n","protected":false},"author":6221,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[28,40],"tags":[64],"class_list":["post-1293","post","type-post","status-publish","format-standard","hentry","category-accouncement","category-did-you-know","tag-data-retention"],"acf":[],"_links":{"self":[{"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/posts\/1293","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/users\/6221"}],"replies":[{"embeddable":true,"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/comments?post=1293"}],"version-history":[{"count":4,"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/posts\/1293\/revisions"}],"predecessor-version":[{"id":1297,"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/posts\/1293\/revisions\/1297"}],"wp:attachment":[{"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/media?parent=1293"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/categories?post=1293"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/tags?post=1293"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}