Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Deleting temp tables created during workflow run

Avatar

Level 2
Hi Folks, We are connecting to Teradata from ACC. So if we run a workflow with keep interim results as checked lot of temp tables gets created and it's occupying a lot of space. Do you guys know how to drop these tables or is there any configuration to auto flush this. Note : We cannot uncheck the check box ( interim results ) as it's essential for us to view the targets.
1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi KeerthiKarna,

 

It's not recommended to keep this option checked in Prod. Do you still need the interim results after your workflow completion? If not then remove the option once you don't need it for a workflow e.g after 7 days.

 

Usually database cleanup use to clean temp table once the keep interim results option is not checked.

You can also defined at db level a process to cleanup temp tables that are not modified after a certain period.

You can identified them with a request Name like '%wkf%'

 

Thanks,

David

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

Hi KeerthiKarna,

 

It's not recommended to keep this option checked in Prod. Do you still need the interim results after your workflow completion? If not then remove the option once you don't need it for a workflow e.g after 7 days.

 

Usually database cleanup use to clean temp table once the keep interim results option is not checked.

You can also defined at db level a process to cleanup temp tables that are not modified after a certain period.

You can identified them with a request Name like '%wkf%'

 

Thanks,

David

Avatar

Employee Advisor

Hi Keerth,

 

Unfortunately, the act of keeping interim results creates temporary tables. These tables cannot be dropped unless the interim results have been removed from the workflow and the Database Cleanup workflow is able to drop them. Additionally, please note that documented best practices warn against using this in production for this very reason.

 

Adobe best practices:

https://experienceleague.adobe.com/docs/campaign-classic/using/automating-with-workflows/introductio...

 

Have you thought about using the target approval process instead to view and approve the target?

 

Target approval:

https://experienceleague.adobe.com/docs/campaign-classic/using/orchestrating-campaigns/orchestrate-c...