DESCRIBE <object>¶

Syntax¶

DESC[RIBE] <object_type> <object_name>

For specific syntax, usage notes, and examples, see:

Session/Query Operations:

• DESCRIBE RESULT

• DESCRIBE TRANSACTION

Account Objects:

• DESCRIBE APPLICATION

• DESCRIBE AUTHENTICATION POLICY

• DESCRIBE CATALOG INTEGRATION

• DESCRIBE COMPUTE POOL

• DESCRIBE DATABASE

• DESCRIBE EXTERNAL VOLUME

• DESCRIBE INTEGRATION

• DESCRIBE NETWORK POLICY

• DESCRIBE SHARE

• DESCRIBE USER

• DESCRIBE WAREHOUSE

Database Objects:

• DESCRIBE AGGREGATION POLICY

• DESCRIBE ALERT

• DESCRIBE AUTHENTICATION POLICY

• DESCRIBE CORTEX SEARCH SERVICE

• DESCRIBE DYNAMIC TABLE

• DESCRIBE EVENT TABLE

• DESCRIBE EXTERNAL TABLE

• DESCRIBE FILE FORMAT

• DESCRIBE FUNCTION

• DESCRIBE GIT REPOSITORY

• DESCRIBE ICEBERG TABLE

• DESCRIBE LISTING

• DESCRIBE MASKING POLICY

• DESCRIBE MATERIALIZED VIEW

• DESCRIBE NETWORK RULE

• DESCRIBE NOTEBOOK

• DESCRIBE PACKAGES POLICY

• DESCRIBE PASSWORD POLICY

• DESCRIBE PIPE

• DESCRIBE PRIVACY POLICY

• DESCRIBE PROCEDURE

• DESCRIBE PROJECTION POLICY

• DESCRIBE ROW ACCESS POLICY

• DESCRIBE SCHEMA

• DESCRIBE SECRET

• DESCRIBE SEQUENCE

• DESCRIBE SERVICE

• DESCRIBE SESSION POLICY

• DESCRIBE SNAPSHOT

• DESCRIBE STAGE

• DESCRIBE STREAMLIT

• DESCRIBE STREAM

• DESCRIBE TABLE

• DESCRIBE TASK

• DESCRIBE VIEW

Usage notes¶

• 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.