Data Operation - Truncate

Undraw Data Processing

About

truncate is a intermediate operation that will delete the content of a data resource but not it's metadata

Arguments

Truncate supports the following arguments:

Name Default Description
force false Delete the foreign keys constraints if true
cascade false Truncate recursively the dependent resources
processing-type batch The processing type (all at once or one by one)

Note

  • If you want to truncate in a stream fashion (ie one by one), you should set the order argument of the select to drop so that the tables are truncated in order.
  • force is applied in batch mode only if all foreign tables are present in the batch.
  • the truncated data resources are returned
  • on a file system, force or cascade have the same effect, they will truncate all files recursively in a directory.

Cli

Truncate is also available via the data truncate command

Task Runner