Empty tables with the Delete action#

#Objective

This action is used to empty one, or multiple, tables in the database. Using the perimeter in the preferences section, you can limit the deletion to a specific subset of data. The perimeter can be preformed on:

• Based on predefined set (A table attribute)
• Date perimeter of the workflow
• Based on attribute of the Project (An attribute of the Project)

#Setup example

{ 
	"params": {
		"tables": [
			"dwh/default_dataset/table_1", 
			"dwh/analytics_dataset/table_2"
		]
	}
}

#Parameters

*This parameter should be used carefully, as if the action terminates early, it will result in partial deletion of data, and if multiple tables are selected, some tables may not be deleted at all.

#Go further

If you need training or technical assistance to implement our solutions, contact your sales representative or click on this link to get a quote and ask our Professional Services experts for a custom analysis of your project.

Ask questions, give your feedback and interact directly with the team building the Data Platform on the dedicated Discord channel.

If you need support with your OVHcloud services, create a request in our Help Centre.

Join our community of users.