SnowConvert AI - Frequently Asked Questions (FAQ)¶

What database platforms does SnowConvert AI translate SQL code from?¶

SnowConvert AI can translate SQL code from Teradata, Oracle, SQL Server, Amazon Redshift, Sybase IQ, Google BigQuery, Azure Synapse, Greenplum, PostgresSQL, Vertica, Hive, Spark, Databricks, Netezza and IBM DB2.

With the release of version 1.2.0 what changes for current SnowConvert AI users?¶

To unlock SnowConvert AI features, users need to obtain an access code from Snowflake. This code enables either assessment or conversion functionalities. The following changes are being implemented in this release:

• SnowConvert AI will automatically generate an access code when requested by the user.

• The process has been simplified: SnowConvert AI will now produce both the assessment report and converted code in a single step, eliminating the need for separate Assessment and Conversion modes.

• 现在，单个访问码将授予对所有支持的平台的访问权限，而不是仅限于一个源平台。用户体验的所有其他方面保持不变。

To ensure you get the best conversion results, we recommend regularly updating to the latest version of SnowConvert AI. Each new version includes improved conversion rules and enhanced code quality.

Before installing a new version of SnowConvert AI, please uninstall any existing version from your system. After uninstalling, download and install the latest version.

How do I get SnowConvert AI?¶

SnowConvert AI can be officially downloaded in the Snowsight Snowflake web page.

However, it is highly recommended to take the free course "SnowConvert AI for Conversion (https://training.snowflake.com/lmt/!clmsLink.dt?site=sf&region=us&lang=en-us&type=O&id=130596852)". This course is both an overview and a technical hands on training of how to use SnowConvert AI for assessments and conversions. Once you complete the course you will receive an email with the download instructions, and can generate an access code via the tool interface.

How do I get an access code for SnowConvert AI?¶

You can obtain an access code by following the instructions in How to Get an Access Code.

如果您需要其他帮助，请通过以下方式联系我们的客户支持团队：snowconvert-support@snowflake.com

What are the system requirements for using SnowConvert AI?¶

How do I give permission to SnowConvert AI config folder?¶

Providing access to the SnowConvert AI configuration folder depends on your operating system.

SnowConvert AI requires read, write, and execute permissions for its configuration folder (.config on MacOS or AppData on Windows). This folder stores temporary files, logs, and license information. To grant SnowConvert AI access to this folder, follow these steps:

如何确保 .config 是文件夹而不是文件？¶

此问题仅影响 macOS 系统。

SnowConvert AI requires read, write, and execute permissions for the configuration folder (.config on macOS). This folder is used to store temporary files, log files, and license information.

.config 必须是目录（文件夹）。如果您发现 .config 以文件形式存在，则需要将其转换为目录并设置相应的权限。

要解决此问题，请执行以下步骤：

1. 在主目录 '/Users/[Username]/' 下找到 .config 文件。

2. 删除 .config 文件。

3. 在同一位置创建一个名为 .config 的新文件夹。

4. 启动终端。

5. 键入 cd ~ 并按 Enter 导航到主目录。

6. 通过键入 chmod 777 .config 来更改文件夹权限。如果看到 Operation not permitted 错误，请改用 sudo chmod 777 .config。

7. Exit Terminal and start SnowConvert AI.

什么是顶级代码单元？¶

代码单元是可以执行的最小的独立代码。虽然代码单元通常由单个语句组成，但也可以是完整的脚本文件，因为它们是作为一个单元执行的。代码单元可以是分层的，有些单元包含在其他单元中。当代码单元未嵌套在任何其他单元中时，则被称为顶级代码单元。

Does SnowConvert AI provide resources to understand how it translates SQL code?¶

您可以在以下位置找到每个来源的转换参考资料：

• Teradata

• Oracle

• SQL Server

什么是代码完整性指标？¶

The Code Completeness score shows whether all necessary code components are present in your codebase. A score below 100 indicates that SnowConvert AI has detected missing object references that may be required for successful migration.

Are there release notes available for previous versions of SnowConvert AI?¶

版本说明可在此处获得：release-notes

Is SnowConvert AI a free tool, or are there paid plans available?¶

SnowConvert AI is now free for everyone and allows full conversion functionality of your workload.

Besides, if you need additional support you are provided with the option of a Professional Service Engagement.

Why SnowConvert AI is not auto-updating?¶

如何移除我的许可证？¶

To remove all SnowConvert AI licenses, you need to delete the .profile file in the config folder. The file location depends on your operating system. Follow the steps specific to your operating system to locate and delete this file.

为什么我没有收到访问码？¶

SnowConvert AI communicates with an API to generate access codes. If this communication fails, you will receive an error message similar to this:

If you are using a version older than 1.13.0 we encourage you to update SnowConvert AI to the latest version. If for any reason is not possible to update, you need to ensure your network allows both incoming and outgoing connections to the licensing API at https://api-sc-licensing-prod.azurewebsites.net/ (https://api-sc-licensing-prod.azurewebsites.net/). Please work with your network administrator to configure these permissions.

If the error persists after updating, you need to ensure your network allows both incoming and outgoing connections to the licensing API at https://snowconvert.snowflake.com/licensing (https://snowconvert.snowflake.com/licensing). Please work with your network administrator to configure these permissions.