Preview features¶

Preview features have been implemented and tested in Snowflake; however, full usability and corner-case handling may not be complete yet. We do not guarantee the use of these features against defects that may produce unexpected or undesired results. Additionally, we may change the behavior of features while they are in preview. If we change the behavior of a preview feature, we do our best to notify users before making the change, but we do not guarantee to always pre-announce changes.

In addition, preview features can be disabled, enabled, or viewed for an entire account. See Managing access to all preview features, on this page, for details.

Preview availability¶

Availability is determined on a per-feature basis:

Open:

Most preview features are Open, meaning they are enabled by default for all accounts and, therefore, openly available for use.

On Request:

Some preview features are provided On Request, particularly in the early stages of the preview period. To request access to these features for your account, you must contact Snowflake.

Some preview features are available only in certain Snowflake editions or in specific cloud platforms or regions.

Features currently in preview¶

The following features are currently available for preview, listed roughly in the order in which they were introduced:

Managing access to all preview features¶

Snowflake provides the ability for account administrators to manage access to preview features at the account level.

• Account administrators can enable or disable access to preview features for their entire Snowflake account. Additionally, account administrators can check whether all preview features are enabled or disabled.
• This setting affects all users and all preview features (including private preview features) within the account.
• By default, access to all preview features is enabled for most accounts.

The following limitations apply to enabling and disabling preview feature access:

Checking the status of preview features in your account¶

To check whether preview features are enabled in your account, call the SYSTEM$GET_PREVIEW_ACCESS_STATUS function.

For example:

SELECT SYSTEM$GET_PREVIEW_ACCESS_STATUS();

Which returns:

+-------------------------------------------------------+
| SYSTEM$GET_PREVIEW_ACCESS_STATUS()                    |
+-------------------------------------------------------+
| Preview access is [ENABLED|DISABLED] for this account |
+-------------------------------------------------------+

Indicating the current state of preview features for the account.

Enabling preview features in your account¶

To enable preview features for your account, call the SYSTEM$ENABLE_PREVIEW_ACCESS function.

For example:

SELECT SYSTEM$ENABLE_PREVIEW_ACCESS();

Which returns:

+---------------------------------------------------------------+
| SELECT SYSTEM$ENABLE_PREVIEW_ACCESS();                        |
+---------------------------------------------------------------+
| Preview access has been successfully enabled for this account |
+---------------------------------------------------------------+

Disabling preview features in your account¶

To disable preview features for your account, call the SYSTEM$DISABLE_PREVIEW_ACCESS function.

SELECT SYSTEM$DISABLE_PREVIEW_ACCESS();

Which returns:

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