Categories:

System functions (System Control)

SYSTEM$DISABLE_PREVIEW_ACCESS

Disables access to open preview and private preview features.

See also:

SYSTEM$GET_PREVIEW_ACCESS_STATUS, SYSTEM$ENABLE_PREVIEW_ACCESS

Syntax

SYSTEM$DISABLE_PREVIEW_ACCESS()

Arguments

None.

Returns

Returns a VARCHAR status message that preview features have been disabled:

+----------------------------------------------------------------+
| SYSTEM$DISABLE_PREVIEW_ACCESS()                                |
+----------------------------------------------------------------+
| Preview access has been successfully disabled for this account |
+----------------------------------------------------------------+

Access control requirements

  • Only account administrators (users with the ACCOUNTADMIN role) can execute this function.

Usage notes

  • Applies to both private and open preview features.
  • This is an all-or-nothing setting that affects all users and all previews within an account.
  • Any user in the account who is using a preview feature will lose access to that feature immediately after SYSTEM$DISABLE_PREVIEW_ACCESS is executed.
  • Snowflake Marketplace products, which are managed separately through IMPORTED PRIVILEGES, are not covered as part of this capability.
  • Client-side libraries (such as Snowpark API) are not covered as part of this capability.

Examples

Disable preview features:

USE ROLE ACCOUNTADMIN;
SELECT SYSTEM$DISABLE_PREVIEW_ACCESS();