For AI agents: the complete documentation index is available at https://docs.ovhcloud.com/pl/llms.txt, the full documentation bundle is available at https://docs.ovhcloud.com/pl/llms-full.txt, and this page is available as Markdown at https://docs.ovhcloud.com/pl/guides/public-cloud/data-platform/dpe-actions-delete.md.

Empty tables with the Delete action

Pokaż jako Markdown

This action is used to empty one, or multiple, tables in the database

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)
Info

Pro-tip

The perimeter type Based on predefined set can have multiple values, but only one attribute can be selected. Whilst unorthodox, you can use segmentation to act as an additional attribute based on a table attribute.

Setup example

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

Parameters

ParameterDescriptionExampleRequired
tablesTables to delete.["dwh/default_dataset/table1", "dwh/analytics_dataset/table2"]Yes

*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

For training or technical assistance implementing our solutions, contact your sales representative or visit our Professional Services page to request a quote and have your project analysed by our experts.

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.

Czy ta strona była pomocna?