1 of 1 people found this helpful
No, there really isn't a way to prevent http_requests from being trimmed. I've seen the folks who are interested in saving history "forever" develop three methods to save this info...this is not a complete list, of course - there are other techniques you could use:
- Leverage an incremental extract to "import" these rows into Tableau
- Use a SQL Server Integration Services package to move/copy rows from http_requests in postgres to SQL Server
- Use Postgres SQL scripts to copy the http_requests table rows to a different database.
In the latter two cases, you do all your reporting against SQL Server and/or the second postgres database vs. going after "our" workgroup database.
Hope this helps.
I have already looked at doing an incremental refresh as my "Plan B" I guess I will have to roll with that.