Connector Improvement: Custom parameter for data retention in SAP Shadow Tables
Answered
Hi Fivetran R&D Teams,
We know that the default data retention in SAP shadow tables is 30 days, and it cannot be changed. Can we change that data retention into parameter ? We want to shorten the data retention to 7 days (1 week)
Because we have shadow table such as PRCD_ELEMENTS with 330 million rows, it make some alert on our SAP Dasboard.
You can check on this ticket (#352949) for our case.
Thank you
-
Official comment
Hi Yusuf,
Thank you for your improvement request. We are actively reviewing the number of rows in the shadow table. We are currently evaluating different options to reduce the impact, and we will update this thread as soon as a solution is planned for implementation.
Alternatively, you can always run the clean-up job from the /fivetran//config/trigger transaction and schedule a cleanup job yourself more frequently than the standard 30 days. See more on https://fivetran.com/docs/connectors/databases/sap/troubleshooting/managing-triggers-and-shadow-tables#cleanshadowtablecontent .
Best regards,
Edwin
Please sign in to leave a comment.
Comments
1 comment