SnowConvert AI - Preview Features Settings¶

Understanding Snowflake Preview Features¶

Snowflake Public Preview features are new capabilities that have been implemented and tested in Snowflake but may not have complete usability or corner-case handling. When you enable preview features in SnowConvert AI, the conversion process can generate code that uses these preview features when they provide better conversion results.

How to Use Preview Features¶

1. Enable in SnowConvert AI: Enter any of the available flags in the textbox within the Preview Features Settings to allow SnowConvert AI to generate code using Snowflake preview features

2. Enable in Snowflake: Ensure that preview features are enabled in your Snowflake account using system functions like SYSTEM_ENABLE_PREVIEW_ACCESS

3. Test thoroughly: Always test the converted code in a non-production Snowflake environment when using preview features

Important Considerations¶

• Snowflake account compatibility: Your Snowflake account must have preview features enabled to use the generated code

• Feature stability: Snowflake preview features may change behavior or be removed in future Snowflake releases

• Production restrictions: Code using preview features should not be deployed to production Snowflake environments

• Documentation: SnowConvert AI may add comments indicating when preview features are being used

Accessing Preview Features Settings¶

To configure preview features in SnowConvert AI:

1. Navigate to the Conversion Settings section in the SnowConvert AI interface

2. Select the Preview Features tab or section

3. Enter any of the available flags in the textbox to allow SnowConvert AI to use Snowflake preview features. Please be sure that each flag is spelled correctly; if any flag is misspelled, all flags will be ignored during conversion.

4. Proceed with conversion - SnowConvert AI will automatically use preview features when they improve conversion results.

Using Preview Features from CLI¶

When using SnowConvert AI from the command line interface (CLI), you can enable preview features by using the --previewFlags argument. The value must be wrapped with quotes and contain the flags in the following format:

--previewFlags "\"--enableFlag1 --enableFlag2\""

Example:

snowct [command] --previewFlags "\"--enableSnowScriptUDF\"" [other arguments]

For multiple flags:

snowct [command] --previewFlags "\"--enableSnowScriptUDF --enableAnotherFlag\"" [other arguments]

Best Practices¶

• Understand implications: Ensure you understand that the converted code will require Snowflake preview features to be enabled

--enableSnowScriptUDF¶

Available since version 1.18.0

This option enables SnowConvert AI to translate User-Defined Functions, taking advantage of the SnowScript UDF Preview Feature. Learn more from the documentation here: Snowflake Scripting UDFs.

Available only for the following languages:

• Sql Server.

• Azure Synapse.