3 Replies Latest reply on Dec 2, 2016 1:42 PM by Jeff Strauss

    How to reduce extract size horizontally (rows) from an existing TDE?


      Hi experts,

      looking for help with following questions.


      I have a TDE which I have been accumulating by incremental extracts for last few years -- this is basically tableau's postgres_http_requests history - this table in DB keeps for last few weeks data but we need to keep history- Original TDE which I created in 2014 with all columns has now grown too big (5 gb). - I need to reduce the size of data in existing TDE to last one year only - how can I achieve it?


      I have tried hiding the columns but it doesn't reduce size of TDE.

      if I create a  new TDE, that means we will lose all previous 4 year history and will have last few weeks only as it will re-source from postgres_http_requests


      Also, if I create a new TDE with weekly incremental refresh, how can I make sure that it keep only last 1 year data, i-e it may still continue growing beyond one year even if we have data source level filter "Last 12 months"?


      Any idea how can I achieve this?