Categories
- All Categories
- Oracle Analytics Learning Hub
- 33 Oracle Analytics Sharing Center
- 22 Oracle Analytics Lounge
- 256 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 97 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
We are moving this forum's discussions to a new location. During this transition, this forum will become read-only starting 15th January 2026. For any new questions, please email us at analytics-community-ww_mb@oracle.com. Thank you for your understanding and continued participation!
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Is there a way to clear a database table daily before the pipeline loads?
Kevin Riedy
Rank 5 - Community Champion
Is there a way to clear out a database table for one of our data augmentations before running the daily pipeline load?
We have a need to load in brand new data every day and we do not want to retain any cumulative records.
0
Best Answer
-
@Kevin Riedy The Versioned Dataset feature enables to run the corresponding Data Augmentation pipeline as a full load every time. This means the data in the target table will be truncated and reloaded every time.
- Refer: Optional: Select the Versioned Dataset check box to enable full load of the source table data everytime and then click Next.
4
Answers
-
Hi @Ashish-Oracle that was exactly what I was looking for. Thank you for the speedy response!
1