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
How do I get SnowConvert?
SnowConvert can be downloaded and used for assessments 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 assessment access code via the tool interface.
How do I get an access code for SnowConvert?
You can request an access code for assessment mode in the Project Creation screen in the “Get an Assessment Access Code” link or in the help menu. You can request an access code for conversion mode in the Conversion screen in the “Inquire about an access code” link or in the help Menu.
Please note that conversion access codes are exclusively provided to users who have an active statement of work for SnowConvert support with Snowflake Professional Services. If you are interested in a PS engagement or have any further questions, for the fastest response we recommend reaching out to:
Your Snowflake Account Sales Representative
Your Snowflake Professional Services Sales Director
If you do not know either of these contacts, please reach out to Matt Kvancz at matthew.kvancz@snowflake.com. He will be able to assist you further with your inquiry.
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 .configIf you get a message telling you something likeOperation not permittedthen 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-onlyunder Attributes.
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 SnowConvert is not auto-updating?
Internet connection
SnowConvert is an application that will let the end user know when there is a new version available to be downloaded, make sure that your system has a valid Internet connection. If there is still issues or you get an error just like the one above then it will be better to verify you have access to internet.
If you still have issues then there could be a Firewall rule blocking you.
Firewall Blocked
SnowConvert searches for new versions online, on an Azure Blob Storage account. This site may be blocked by a Firewall rule on your local environment. The best way to validate is if you visit this web site https://sctoolsartifacts.blob.core.windows.net/ if there is blocker, the web page should return a message like "Destination unreachable". For this case contact your network administrator to have the sctoolartifacts webpage on the white list.
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 + Rthis will open the Run command window and then type%appdata%\Snowflake Incinto it and hit enter.Locate the file named
.profileand delete the file.
MacOS
Close SnowConvert if you have it open
Open a finder window and press on your keyboard
⌘ + Shift ⇧ + Gthis 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 I am not receiving an assessment license ?
SnowConvert uses this Azure web portal API to assign Assessment Licenses. If there is an error on this communication you will get a message like this:
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
