SHOW
SHOW
지정된 객체 유형의 기존 객체를 나열하는 명령이에요. 출력에는 객체의 메타데이터가 포함되며, 여기에는 다음이 포함돼요:
- 공통 속성(이름, 생성 타임스탬프, 소유 역할, 주석 등)
- 객체별 속성
출처: 문서
본문
SHOW 명령 목록 (SHOW commands)
특정 구문, 사용 메모, 예시는 다음을 참조해요.
계정 작업 (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 NODES IN COMPUTE POOL,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 BASE MODELS,SHOW CORTEX SEARCH SERVICES,SHOW DATA METRIC FUNCTIONS,SHOW DATA MOVEMENT POLICIES,SHOW DATA MOVEMENT RULES,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 INTERACTIVE TABLES,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 CODE BUNDLES,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 RESTRICTED SESSION SCOPES,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(사용 중단;SHOW BACKUP POLICIES권장),SHOW SNAPSHOT SETS — Deprecated(사용 중단;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 SNOWFLAKE.ML.ANOMALY_DETECTION,SHOW BUDGET,SHOW SNOWFLAKE.ML.CLASSIFICATION,SHOW CLASSIFICATION_PROFILE,SHOW CUSTOM_CLASSIFIER,SHOW SNOWFLAKE.ML.FORECAST