Describes the values specified for the properties in a stage (file format, copy, and location), as well as the default values for each property.
DESCRIBE can be abbreviated to DESC.
DESC[RIBE] STAGE <name>
Specifies the identifier for the stage to describe. If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.
To post-process the output of this command, you can use the RESULT_SCAN function, which treats the output as a table that can be queried.
Describe an internal stage named
DESC STAGE mystage;