Removes the specified named internal or external stage from the current/specified schema. The status of the files in the stage depends on the stage type:
For an internal stage, all of the files in the stage are purged from Snowflake, regardless of their load status. This prevents the files from continuing to using storage and, consequently, accruing storage charges. However, this also means that the staged files cannot be recovered after a stage is dropped.
For an external stage, only the stage itself is dropped; any data files in the referenced external location (Amazon S3, Google Cloud Storage, or Microsoft Azure) are not removed.
DROP STAGE [ IF EXISTS ] <name>
Copy
Parameters¶name
Specifies the identifier for the stage to drop. If the identifier contains spaces, special characters, or mixed-case characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.
Dropped stages cannot be recovered; they must be recreated.
This command cannot be used to drop the stage associated with a table or user; only named stages (internal or external) can be dropped.
When the IF EXISTS clause is specified and the target object doesn’t exist, the command completes successfully without returning an error.
DROP STAGE my_stage; --------------------------------+ status | --------------------------------+ MY_STAGE successfully dropped. | --------------------------------+Copy
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4