시스템(System) 함수
시스템(System) 함수
Snowflake는 다음 유형의 시스템 함수를 제공합니다.
- 시스템에서 작업을 실행할 수 있게 하는 제어(Control) 함수(예: 쿼리 중단).
- 시스템에 대한 정보를 반환하는 정보(Information) 함수(예: 테이블의 클러스터링 깊이 계산).
- 쿼리에 대한 정보를 반환하는 정보 함수(예: EXPLAIN 계획 정보).
이 시스템 함수 중 상당수는 SYSTEM$ 접두사를 가집니다(예: SYSTEM$TYPEOF). 이 접두사를 사용하는 시스템 함수는 호출할 때 접두사를 반드시 지정해야 합니다. 예를 들어:
SELECT SYSTEM$TYPEOF('a');
본문
제어 (Control)
- EXECUTE_AI_EVALUATION
- SYSTEM$ABORT_SESSION
- SYSTEM$ABORT_TRANSACTION
- SYSTEM$ACTIVATE_CMK_INFO
- SYSTEM$ACTIVATE_CMK_INFO_POSTGRES
- SYSTEM$ADD_EVENT (Snowflake Scripting용)
- SYSTEM$ADD_PRIVATELINK_ENDPOINT_HOSTNAME
- SYSTEM$ADD_REFERENCE
- SYSTEM$AUTHORIZE_PRIVATELINK
- SYSTEM$AUTHORIZE_STAGE_PRIVATELINK_ACCESS
- SYSTEM$AUTHORIZE_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PRIVATELINK_ACCESS
- SYSTEM$BEGIN_DEBUG_APPLICATION
- SYSTEM$BLOCK_INTERNAL_STAGES_PUBLIC_ACCESS
- SYSTEM$BLOCK_INTERNAL_STAGES_PUBLIC_ACCESS_WITH_EXCEPTION
- SYSTEM$BLOCK_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PUBLIC_ACCESS
- SYSTEM$BLOCK_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PUBLIC_ACCESS_WITH_EXCEPTION
- SYSTEM$CANCEL_ALL_QUERIES
- SYSTEM$CANCEL_QUERY
- SYSTEM$CLEANUP_DATABASE_ROLE_GRANTS
- SYSTEM$COMMIT_MOVE_ORGANIZATION_ACCOUNT
- SYSTEM$CONVERT_PIPES_SQS_TO_SNS
- SYSTEM$CREATE_BILLING_EVENT
- SYSTEM$CREATE_BILLING_EVENTS
- SYSTEM$CREATE_EVALUATION_DATASET
- SYSTEM$DEACTIVATE_CMK_INFO
- SYSTEM$DEMIGRATE_DBT_PROJECT
- SYSTEM$DEPROVISION_PRIVATELINK_ENDPOINT
- SYSTEM$DEPROVISION_PRIVATELINK_ENDPOINT_TSS
- SYSTEM$DEREGISTER_CMK_INFO
- SYSTEM$DEREGISTER_CMK_INFO_POSTGRES
- SYSTEM$DISABLE_BEHAVIOR_CHANGE_BUNDLE
- SYSTEM$DISABLE_DATABASE_REPLICATION
- SYSTEM$DISABLE_FEATURE_GROUPS
- SYSTEM$DISABLE_FEATURE_GROUPS_PREVIEW
- SYSTEM$DISABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT
- SYSTEM$DISABLE_PREVIEW_ACCESS
- SYSTEM$DISABLE_PRIVATELINK_ACCESS_ONLY
- SYSTEM$ENABLE_BEHAVIOR_CHANGE_BUNDLE
- SYSTEM$ENABLE_FEATURE_GROUPS
- SYSTEM$ENABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT
- SYSTEM$ENABLE_PREVIEW_ACCESS
- SYSTEM$END_DEBUG_APPLICATION
- SYSTEM$ENFORCE_PRIVATELINK_ACCESS_ONLY
- SYSTEM$FINISH_OAUTH_FLOW
- SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER
- SYSTEM$INITIATE_MOVE_ORGANIZATION_ACCOUNT
- SYSTEM$ISSUE_PER_ACCOUNT_APP_SERVICE_CERTIFICATE
- SYSTEM$ISSUE_PER_ACCOUNT_CERTIFICATES
- SYSTEM$ISSUE_WORKLOAD_IDENTITY_FEDERATION_TOKEN
- SYSTEM$LINK_ACCOUNT_OBJECTS_BY_NAME
- SYSTEM$LINK_ORGANIZATION_USER
- SYSTEM$LINK_ORGANIZATION_USER_GROUP
- SYSTEM$MIGRATE_DBT_PROJECT
- SYSTEM$MIGRATE_SAML_IDP_REGISTRATION
- SYSTEM$OPT_IN_INTERNAL_STAGE_NETWORK_LOGS
- SYSTEM$OPT_OUT_INTERNAL_STAGE_NETWORK_LOGS
- SYSTEM$OPT_OUT_MALICIOUS_IP_PROTECTION_BY_CATEGORY
- SYSTEM$PIPE_FORCE_RESUME
- SYSTEM$PIPE_REBINDING_WITH_NOTIFICATION_CHANNEL
- SYSTEM$PROVISION_PRIVATELINK_ENDPOINT
- SYSTEM$PROVISION_PRIVATELINK_ENDPOINT_TSS
- SYSTEM$REGISTER_CMK_INFO
- SYSTEM$REGISTER_CMK_INFO_POSTGRES
- SYSTEM$REGISTER_PRIVATELINK_ENDPOINT
- SYSTEM$REMOVE_ALL_REFERENCES
- SYSTEM$REMOVE_PRIVATELINK_ENDPOINT_HOSTNAME
- SYSTEM$REMOVE_REFERENCE
- SYSTEM$RESTORE_PRIVATELINK_ENDPOINT
- SYSTEM$RESTORE_PRIVATELINK_ENDPOINT_TSS
- SYSTEM$REVOKE_PRIVATELINK
- SYSTEM$REVOKE_STAGE_PRIVATELINK_ACCESS
- SYSTEM$REVOKE_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PRIVATELINK_ACCESS
- SYSTEM$SCHEDULE_ASYNC_REPLICATION_GROUP_REFRESH
- SYSTEM$SEND_NOTIFICATIONS_TO_CATALOG
- SYSTEM$SET_APPLICATION_RESTRICTED_FEATURE_ACCESS
- SYSTEM$SET_CATALOG_INTEGRATION
- SYSTEM$SET_DEFAULT_COLUMNS_OVERRIDE_FOR_SHOW_COMMAND
- SYSTEM$SET_DEFAULT_COLUMNS_OVERRIDE_FOR_SYSTEM_OBJECT
- SYSTEM$SET_EVENT_SHARING_ACCOUNT_FOR_REGION
- SYSTEM$SET_PRIVATELINK_ENDPOINT_HOSTNAME
- SYSTEM$SET_REFERENCE
- SYSTEM$SET_ROW_TIMESTAMP_ON_ALL_SUPPORTED_TABLES
- SYSTEM$SNOWFLAKE_MANAGED_STORAGE_VOLUME_PUBLIC_ACCESS_STATUS
- SYSTEM$SNOWPIPE_STREAMING_UPDATE_CHANNEL_OFFSET_TOKEN
- SYSTEM$START_OAUTH_FLOW
- SYSTEM$START_USER_EMAIL_VERIFICATION
- SYSTEM$TASK_DEPENDENTS_ENABLE
- SYSTEM$TRIGGER_LISTING_REFRESH
- SYSTEM$UNBLOCK_INTERNAL_STAGES_PUBLIC_ACCESS
- SYSTEM$UNBLOCK_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PUBLIC_ACCESS
- SYSTEM$UNLINK_ORGANIZATION_USER
- SYSTEM$UNLINK_ORGANIZATION_USER_GROUP
- SYSTEM$UNREGISTER_PRIVATELINK_ENDPOINT
- SYSTEM$UNSET_DEFAULT_COLUMNS_OVERRIDE_FOR_SHOW_COMMAND
- SYSTEM$UNSET_DEFAULT_COLUMNS_OVERRIDE_FOR_SYSTEM_OBJECT
- SYSTEM$UNSET_EVENT_SHARING_ACCOUNT_FOR_REGION
- SYSTEM$UNVERIFY_DNS_DOMAIN
- SYSTEM$USER_TASK_CANCEL_ONGOING_EXECUTIONS
- SYSTEM$VERIFY_DNS_DOMAIN
- SYSTEM$WAIT
정보 (Information)
- EXTRACT_SEMANTIC_CATEGORIES
- GET_ANACONDA_PACKAGES_REPODATA
- SHOW_PYTHON_PACKAGES_DEPENDENCIES
- SYSTEM$ALLOWLIST
- SYSTEM$ALLOWLIST_PRIVATELINK
- SYSTEM$APP_COMPATIBILITY_CHECK
- SYSTEM$APPLICATION_GET_LOG_LEVEL
- SYSTEM$APPLICATION_GET_METRIC_LEVEL
- SYSTEM$APPLICATION_GET_TRACE_LEVEL
- SYSTEM$AUTO_REFRESH_STATUS
- SYSTEM$BEHAVIOR_CHANGE_BUNDLE_STATUS
- SYSTEM$CATALOG_LINK_STATUS
- SYSTEM$CKE_HASH_FUNCTION
- SYSTEM$CLIENT_VERSION_INFO
- SYSTEM$CLIENT_VULNERABILITY_INFO
- SYSTEM$CLUSTERING_DEPTH
- SYSTEM$CLUSTERING_INFORMATION
- SYSTEM$CLUSTERING_RATIO — 더 이상 사용하지 않음(Deprecated). 다른 클러스터링 함수 사용
- SYSTEM$CURRENT_USER_TASK_NAME
- SYSTEM$DATA_METRIC_SCAN
- SYSTEM$DATABASE_REFRESH_HISTORY — 더 이상 사용하지 않음(Deprecated). DATABASE_REFRESH_HISTORY 사용
- SYSTEM$DATABASE_REFRESH_PROGRESS, SYSTEM$DATABASE_REFRESH_PROGRESS_BY_JOB — 더 이상 사용하지 않음(Deprecated). DATABASE_REFRESH_PROGRESS, DATABASE_REFRESH_PROGRESS_BY_JOB 사용
- SYSTEM$DBT_GET_LAST_FAILED_RUN_TARGET
- SYSTEM$DBT_GET_LAST_RUN_TARGET
- SYSTEM$DBT_GET_LAST_SUCCESSFUL_RUN_TARGET
- SYSTEM$DECODE_PAT
- SYSTEM$DESC_ICEBERG_ACCESS_IDENTITY
- SYSTEM$ENCODE_CKE_PRIMARY_KEY
- SYSTEM$ESTIMATE_AUTOMATIC_CLUSTERING_COSTS
- SYSTEM$ESTIMATE_SEARCH_OPTIMIZATION_COSTS
- SYSTEM$EVALUATE_DATA_QUALITY_EXPECTATIONS
- SYSTEM$EVALUATE_DATA_QUALITY_EXPECTATIONS_PERSIST_RESULT
- SYSTEM$EXECUTE_CATALOG_OPERATION
- EXPLAIN_PRIVILEGES
- SYSTEM$EXPORT_TDS_FROM_SEMANTIC_VIEW
- SYSTEM$EXTERNAL_TABLE_PIPE_STATUS
- SYSTEM$FETCH_EXTERNAL_SECRET_FROM_INTEGRATION
- SYSTEM$GENERATE_SAML_CSR
- SYSTEM$GENERATE_SCIM_ACCESS_TOKEN
- SYSTEM$GET_ALERT_TEMPLATE
- SYSTEM$GET_ALL_DEFAULT_COLUMNS_OVERRIDES
- SYSTEM$GET_ALL_REFERENCES
- SYSTEM$GET_AWS_SNS_IAM_POLICY
- SYSTEM$GET_CATALOG_LINKED_DATABASE_CONFIG
- SYSTEM$GET_CLASSIFICATION_RESULT
- SYSTEM$GET_CMK_AKV_CONSENT_URL
- SYSTEM$GET_CMK_CONFIG
- SYSTEM$GET_CMK_CONFIG_POSTGRES
- SYSTEM$GET_CMK_INFO
- SYSTEM$GET_CMK_INFO_POSTGRES
- SYSTEM$GET_CMK_KMS_KEY_POLICY
- SYSTEM$GET_COMPUTE_POOL_PENDING_MAINTENANCE
- SYSTEM$GET_DBT_LOG
- SYSTEM$GET_DEBUG_STATUS
- SYSTEM$GET_DEFAULT_COLUMNS_OVERRIDE_FOR_SHOW_COMMAND
- SYSTEM$GET_DEFAULT_COLUMNS_OVERRIDE_FOR_SYSTEM_OBJECT
- SYSTEM$GET_DIRECTORY_TABLE_STATUS
- SYSTEM$GET_GCP_KMS_CMK_GRANT_ACCESS_CMD
- SYSTEM$GET_HASH_FOR_APPLICATION
- SYSTEM$GET_ICEBERG_TABLE_INFORMATION
- SYSTEM$GET_INSTANCE_FAMILY_PLACEMENT_GROUPS
- SYSTEM$GET_LOGIN_FAILURE_DETAILS
- SYSTEM$GET_PREDECESSOR_RETURN_VALUE
- SYSTEM$GET_PREVIEW_ACCESS_STATUS
- SYSTEM$GET_PRIVATELINK
- SYSTEM$GET_PRIVATELINK_AUTHORIZED_ENDPOINTS
- SYSTEM$GET_PRIVATELINK_CONFIG
- SYSTEM$GET_PRIVATELINK_ENDPOINTS_INFO
- SYSTEM$GET_PRIVATELINK_ENDPOINT_REGISTRATIONS
- SYSTEM$GET_PURCHASE_ATTRIBUTES
- SYSTEM$GET_REFERENCED_OBJECT_ID_HASH
- SYSTEM$GET_SECURITY_INTEGRATIONS_FOR_API_PROVIDER
- SYSTEM$GET_SERVICE_CALLER_TOKEN_EXPIRY — 호출자의 권한 로그인 토큰 만료 타임스탬프를 반환
- SYSTEM$GET_SERVICE_DNS_DOMAIN
- SYSTEM$GET_SERVICE_LOGS
- SYSTEM$GET_SERVICE_STATUS — 더 이상 사용하지 않음(Deprecated). SHOW SERVICE CONTAINERS IN SERVICE 명령 사용
- SYSTEM$GET_SNOWFLAKE_EGRESS_IP_RANGES
- SYSTEM$GET_SNOWFLAKE_PLATFORM_INFO
- SYSTEM$GET_STAGE_PRIVATELINK_AUTHORIZED_ENDPOINTS
- SYSTEM$GET_TABLE_ARCHIVE_METADATA
- SYSTEM$GET_TAG — multi-value tag에 둘 이상의 값이 지정되면 오류를 반환. SYSTEM$TAG_VALUE_CONTAINS 사용
- SYSTEM$GET_TAG_ALLOWED_VALUES
- SYSTEM$GET_TAG_ON_CURRENT_COLUMN
- SYSTEM$GET_TAG_ON_CURRENT_TABLE
- SYSTEM$GET_TASK_GRAPH_CONFIG
- SYSTEM$HOLD_PRIVILEGE_ON_ACCOUNT
- SYSTEM$INTERNAL_STAGES_PUBLIC_ACCESS_STATUS
- SYSTEM$IS_APPLICATION_ALL_MANDATORY_TELEMETRY_EVENT_DEFINITIONS_ENABLED
- SYSTEM$IS_APPLICATION_AUTHORIZED_FOR_TELEMETRY_EVENT_SHARING
- SYSTEM$IS_APPLICATION_INSTALLED_FROM_SAME_ACCOUNT
- SYSTEM$IS_APPLICATION_SHARING_EVENTS_WITH_PROVIDER
- SYSTEM$IS_GLOBAL_DATA_SHARING_ENABLED_FOR_ACCOUNT
- SYSTEM$IS_LISTING_PURCHASED
- SYSTEM$IS_LISTING_TRIAL
- SYSTEM$LAST_CHANGE_COMMIT_TIME
- SYSTEM$LIST_ALERT_TEMPLATES
- SYSTEM$LIST_APPLICATION_RESTRICTED_FEATURES
- SYSTEM$LIST_EXTERNAL_SECRETS
- SYSTEM$LIST_ICEBERG_TABLES_FROM_CATALOG
- SYSTEM$LIST_NAMESPACES_FROM_CATALOG
- SYSTEM$LOCATE_DBT_ARCHIVE
- SYSTEM$LOCATE_DBT_ARTIFACTS
- SYSTEM$LOG, SYSTEM$LOG_
(Snowflake Scripting용) - SYSTEM$PIPE_STATUS
- SYSTEM$QUERY_REFERENCE
- SYSTEM$READ_YAML_FROM_SEMANTIC_VIEW
- SYSTEM$READ_OSI_YAML_FROM_SEMANTIC_VIEW
- SYSTEM$REFERENCE
- SYSTEM$REGISTRY_LIST_IMAGES — 더 이상 사용하지 않음(Deprecated). SHOW IMAGES IN IMAGE REPOSITORY 명령 사용
- SYSTEM$REPORT_HEALTH_STATUS
- SYSTEM$SET_RETURN_VALUE
- SYSTEM$SET_SPAN_ATTRIBUTES (Snowflake Scripting용)
- SYSTEM$SHOW_ACTIVE_BEHAVIOR_CHANGE_BUNDLES
- SYSTEM$SHOW_BUDGETS_FOR_RESOURCE
- SYSTEM$SHOW_BUDGETS_IN_ACCOUNT
- SYSTEM$SHOW_EVENT_SHARING_ACCOUNTS
- SYSTEM$SHOW_MOVE_ORGANIZATION_ACCOUNT_STATUS
- SYSTEM$SHOW_OAUTH_CLIENT_SECRETS
- SYSTEM$SHOW_SENSITIVE_DATA_MONITORED_ENTITIES
- SYSTEM$STREAM_BACKLOG — 이 함수는 테이블 함수입니다
- SYSTEM$STREAM_GET_TABLE_TIMESTAMP
- SYSTEM$STREAM_HAS_DATA
- SYSTEM$SUPPORTED_DBT_VERSIONS
- SYSTEM$TAG_VALUE_CONTAINS
- SYSTEM$TASK_RUNTIME_INFO
- SYSTEM$TYPEOF
- SYSTEM$VALIDATE_STORAGE_INTEGRATION
- SYSTEM$VERIFY_CATALOG_INTEGRATION
- SYSTEM$VERIFY_CMK_INFO
- SYSTEM$VERIFY_CMK_INFO_POSTGRES
- SYSTEM$VERIFY_EXTERNAL_OAUTH_TOKEN
- SYSTEM$VERIFY_EXTERNAL_SECRET_INTEGRATION
- SYSTEM$VERIFY_EXTERNAL_VOLUME
- SYSTEM$WHITELIST — 더 이상 사용하지 않음(Deprecated). SYSTEM$ALLOWLIST 사용
- SYSTEM$WAIT_FOR_SERVICES
- SYSTEM$WHITELIST_PRIVATELINK — 더 이상 사용하지 않음(Deprecated). SYSTEM$ALLOWLIST_PRIVATELINK 사용
쿼리 정보 (Query Information)
- EXPLAIN_GRANTABLE_PRIVILEGES
- EXPLAIN_JSON
- GET_QUERY_OPERATOR_STATS
- GET_PYTHON_PROFILER_OUTPUT (SNOWFLAKE.CORE)
- SYSTEM$ESTIMATE_QUERY_ACCELERATION
- SYSTEM$EXPLAIN_PLAN_JSON
- SYSTEM$EXPLAIN_JSON_TO_TEXT
- SYSTEM$GET_RESULTSET_STATUS