Frequently Asked Questions (FAQ)
All of the information you could ever want to know about running SnowConvert.
What database platforms does SnowConvert translate SQL code from?
SnowConvert supports translations from SQL code from Teradata, Oracle, and SQL Server
With the release of version 1.2.0 what changes for current SnowConvert users?
Currently, users must request an access code from Snowflake that will unlock features in SnowConvert. This access can relate to either the assessment or conversion capabilities. With this release, the following will change:
Access codes will be requested directly within SnowConvert, and one will automatically be generated for the user.
Assessment and Conversion modes will be eliminated. Once activated, SnowConvert will generate both the assessment information and converted code in one, single step.
The generated access code will provide access to all supported platforms, not just one source platform, while the rest of the user experience will remain unchanged.
Since Snowflake is continually improving the quality of the output code, it is best practice to upgrade to the latest version of SnowConvert to benefit from the most up-to-date conversion rules.
If you are a current user of SnowConvert, our recommendation is to first uninstall the existing version, then re-download and install the new version.
How do I get SnowConvert?
SnowConvert can be downloaded once you have completed the free course "SnowConvert for Conversion". This course is both an overview and a technical hands on training of how to use SnowConvert 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?
You can follow this guide How to Get an Access Code.
If you need special assistance, please get in touch with our customer support team at snowconvert-support@snowflake.com
What are the system requirements for using SnowConvert?
For MacOS
Ventura 13.3.1 or higher
4 GB of RAM or higher*
For Windows
Windows 11 or later
4 GB of RAM or higher*
How do I give permission to SnowConvert config folder?
Giving access to the configuration folder for SnowConvert varies from OS.
SnowConvert needs to have write, read and execute permission on the configuration folder ( .config
for MacOs or AppData
for Windows), here is where we store temporary files, logs and license information. In order to give access SnowConvert to this folder then we need to follow these steps:
For MacOs
Open a Terminal window.
Type
cd ~
and hit enter.type
chmod 777 .config
If you get a message telling you something likeOperation not permitted
then execute command assudo chmod 777 .config
.Close the terminal window and open SnowConvert.
For Windows
Press Windows key + R to launch the Run dialog window.
Type in the following and click OK or press Enter:
%AppData%
Locate the Snowflake Inc folder and right click on it, make sure there is no check marks on the field
Read-only
under Attributes.
How do I make sure that .config is a folder instead of a file?
This issue applies to macOS only.
SnowConvert needs to have access (read, write, and execute) to the configuration folder ( .config
for macOS), for storing temporary files, logs, and license information.
It is required for the .config
to be a folder. If for any reason .config
appears as a file, it must be changed to a folder with the necessary permissions.
Following these steps might solve the issue:
Locate the
.config
file. It should be in'/Users/[Username]/'
.Remove the
.config
file.Create a new folder named
.config
in the same location where the file was removed.Open a Terminal window.
Type
cd ~
and hit enter.type
chmod 777 .config
If you get a message telling you something likeOperation not permitted
then execute the command assudo chmod 777 .config
.Close the terminal window and open SnowConvert.
What is a Top-Level Code Unit?
A Code Unit, as the name suggests, is the most atomic, standalone executable element. In most cases, these are statements, but they also include script files as well because those are executed as a single element. Some Code Units can be nested inside other Code Units. When there is no other Code Unit above it in a hierarchy of Units, it's called a Top-Level Code Unit
Does SnowConvert provide resources to understand how it translates SQL code?
Yes, you can find the translation reference for each source here:
What is the code completeness metric?
The Code Completeness score is an indication of how complete the provided code base is. Anything less than a score of 100 means SnowConvert identified missing object references in the code.
Are there release notes available for previous versions of SnowConvert?
Release notes can be find here: https://docs.snowconvert.com/sc/general/release-notes/release-notes
Is SnowConvert a free tool, or are there paid plans available?
SnowConvert offers two functionality modes: Assessment Mode (free) and Conversion Mode (requires a Professional Service Engagement). Assessment mode allows analyzing code and converting tables for free. Conversion mode allows full conversion functionality of your workload.
Why is SnowConvert not Auto Updating?
Situation:
Your firewall is blocking SnowConvert from communicating with Azure Blob Storage. This API is essential for SnowConvert to receive notifications about new versions and updates.
Fix:
Ask your IT department to:
Add https://sctoolsartifacts.blob.core.windows.net/ DNS to the whitelist.
EnsureSnowCovert has both inbound and outbound communication permissions.
Note: We recommend using DNS instead of IP addresses as Microsoft frequently changes the IP ranges. To get the IP ranges please visit this Microsoft website https://www.microsoft.com/en-us/download/details.aspx?id=56519 and download the .json file and look for: "name": "AppService.WestUS2"
, there you will get a list of IP ranges.
How can I remove my licenses ?
If you need to remove all the licenses listed on SnowConvert you will need to delete the .profile
file located on the config folder. The path of the file varies from Operating system, so make sure to follow the steps for your local system:
Windows
Close SnowConvert if you have it open.
Using your keyboard press:
⊞ Win + R
this will open the Run command window and then type%appdata%\Snowflake Inc
into it and hit enter.Locate the file named
.profile
and delete the file.
MacOS
Close SnowConvert if you have it open
Open a finder window and press on your keyboard
⌘ + Shift ⇧ + G
this will open the "Go to Folder", type~/.config/Snowflake Inc/
this will open the config fileThe file ".profile" should be listed here, on Mac, this file will be hidden, so make sure to enable the visibility of hidden files by pressing on your keyboard
⌘ + Shift ⇧ + .
Locate the file and delete it.
Once the file is properly deleted when you open SnowConvert you will have the license list empty.
Why am I not receiving an access code?
Situation:
Your firewall is blocking SnowConvert from communicating with the Licensing API. This API is necessary for SnowConvert to request and validate licenses.
Fix:
Ask your IT department to:
Add https://api-sc-licensing-prod.azurewebsites.net/ DNS to the whitelist
Ensure SnowConvert has both inbound and outbound communication permissions
Note: We recommend using DNS instead of IP addresses as Microsoft frequently changes the IP ranges. To get the IP ranges please visit this Microsoft website https://www.microsoft.com/en-us/download/details.aspx?id=56519 and download the .json file and look for: "name": "AppService.WestUS2",
there you will get a list of IP ranges.
SnowConvert requires both Inbound and outbound permissions to the API : https://api-sc-licensing-prod.azurewebsites.net/. Please contact you local network administrator so they can grant SnowConvert access.
Last updated