跳到主要内容

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.*'