SHOW <objects>¶

Lists the existing objects for the specified object type. The output includes metadata for the objects, including:

• Common properties (name, creation timestamp, owning role, comment, etc.)
• Object-specific properties

See also:

CREATE <object> , DESCRIBE <object>

SHOW commands¶

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

Account Operations

• SHOW ACCOUNTS
• SHOW CONNECTIONS
• SHOW GLOBAL ACCOUNTS
• SHOW ORGANIZATION ACCOUNTS
• SHOW PARAMETERS
• SHOW REGIONS
• SHOW RELEASE DIRECTIVES
• SHOW REPLICATION ACCOUNTS
• SHOW VERSIONS IN APPLICATION PACKAGE

Session / User Operations:

• SHOW LOCKS
• SHOW PARAMETERS
• SHOW TRANSACTIONS
• SHOW VARIABLES

Account Objects:

• SHOW APPLICATIONS
• SHOW APPLICATION PACKAGES
• SHOW CATALOG INTEGRATIONS
• SHOW COMPUTE POOLS
• SHOW COMPUTE POOL INSTANCE FAMILIES
• SHOW DATABASE ROLES
• SHOW DATABASES
• SHOW EXTERNAL VOLUMES
• SHOW FAILOVER GROUPS
• SHOW INTEGRATIONS
• SHOW FEATURE POLICIES
• SHOW FUNCTIONS
• SHOW GRANTS
• SHOW NETWORK POLICIES
• SHOW NOTIFICATION INTEGRATIONS
• SHOW OPENFLOW DATA PLANE INTEGRATIONS
• SHOW ORGANIZATION PROFILES
• SHOW PARAMETERS
• SHOW POSTGRES INSTANCES
• SHOW REPLICATION DATABASES
• SHOW REPLICATION GROUPS
• SHOW RESOURCE MONITORS
• SHOW ROLES
• SHOW SHARES
• SHOW SPECIFICATIONS
• SHOW USER PROGRAMMATIC ACCESS TOKENS
• SHOW USERS
• SHOW WAREHOUSES

Database Objects:

• SHOW AGENTS
• SHOW AGGREGATION POLICIES
• SHOW ALERTS
• SHOW AUTHENTICATION POLICIES
• SHOW BACKUP POLICIES
• SHOW BACKUP SETS
• SHOW CHANNELS
• SHOW CLASSES
• SHOW COLUMNS
• SHOW CONFIGURATIONS
• SHOW CONTACTS
• SHOW CORTEX SEARCH SERVICES
• SHOW DATA METRIC FUNCTIONS
• SHOW DATASETS
• SHOW DBT PROJECTS
• SHOW DCM PROJECTS
• SHOW DEPLOYMENTS IN DCM PROJECT
• SHOW DYNAMIC TABLES
• SHOW ENTITIES IN DCM PROJECT
• SHOW EVENT TABLES
• SHOW EXPERIMENTS
• SHOW EXTERNAL AGENTS
• SHOW EXTERNAL FUNCTIONS
• SHOW EXTERNAL TABLES
• SHOW FILE FORMATS
• SHOW FUNCTIONS
• SHOW GATEWAYS
• SHOW GIT BRANCHES
• SHOW GIT REPOSITORIES
• SHOW GIT TAGS
• SHOW GRANTS IN DCM PROJECT
• SHOW HYBRID TABLES
• SHOW ICEBERG TABLES
• SHOW INDEXES
• SHOW IMAGE REPOSITORIES
• SHOW JOIN POLICIES
• SHOW LISTINGS
• SHOW MAINTENANCE POLICIES
• SHOW MASKING POLICIES
• SHOW MATERIALIZED VIEWS
• SHOW MCP SERVERS
• SHOW MODEL MONITORS
• SHOW MODELS
• SHOW NETWORK RULES
• SHOW NOTEBOOKS
• SHOW NOTEBOOK PROJECTS
• SHOW OBJECTS
• SHOW OBJECTS OWNED BY APPLICATION
• SHOW ONLINE FEATURE TABLES
• SHOW PACKAGES POLICIES
• SHOW PASSWORD POLICIES
• SHOW PIPES
• SHOW PRIVACY POLICIES
• SHOW PROCEDURES
• SHOW PROJECTION POLICIES
• SHOW ROW ACCESS POLICIES
• SHOW SCHEMAS
• SHOW SECRETS
• SHOW SEMANTIC DIMENSIONS
• SHOW SEMANTIC DIMENSIONS FOR METRIC
• SHOW SEMANTIC FACTS
• SHOW SEMANTIC METRICS
• SHOW SEMANTIC VIEWS
• SHOW SEQUENCES
• SHOW SERVICES
• SHOW SESSION POLICIES
• SHOW SNAPSHOT POLICIES — Deprecated (deprecated; prefer SHOW BACKUP POLICIES)
• SHOW SNAPSHOT SETS — Deprecated (deprecated; prefer SHOW BACKUP SETS)
• SHOW SNAPSHOTS
• SHOW SPECIFICATIONS
• SHOW STAGES
• SHOW STORAGE LIFECYCLE POLICIES
• SHOW STREAMLITS
• SHOW STREAMS
• SHOW TABLES
• SHOW TAGS
• SHOW TASKS
• SHOW TYPES
• SHOW USER FUNCTIONS
• SHOW USER PROCEDURES
• SHOW VERSIONS IN DATASET
• SHOW VERSIONS IN DBT PROJECT
• SHOW VERSIONS IN LISTING
• SHOW VERSIONS IN MODEL
• SHOW VIEWS
• SHOW WORKSPACES

Classes:

• SHOW BUDGET
• SHOW SNOWFLAKE.ML.CLASSIFICATION
• SHOW CLASSIFICATION_PROFILE
• SHOW CUSTOM_CLASSIFIER
• Lists all forecasting models.