跳到主要内容

REMOVE { internalStage | externalStage }

Removes files from an external (cloud storage) or internal stage.

Syntax

REMOVE { internalStage | externalStage } [ PATTERN = '<regex_pattern>' ]

Where:

internalStage

internalStage ::= @<internal_stage_name>[/<file>]

externalStage

externalStage ::= @<external_stage_name>[/<file>]

PATTERN = 'regex_pattern'

A regular expression pattern string, enclosed in single quotes, filters files to remove by their filename.

Examples

This command removes all the files with a name matching the patten 'ontime.' from the stage named playground*:

REMOVE @playground PATTERN = 'ontime.*'