Frequently Asked Questions (FAQ)
All of the information you could ever want to know about running SnowConvert.
Last updated
All of the information you could ever want to know about running SnowConvert.
Last updated
SnowConvert supports translations from SQL code from Teradata, Oracle, SQL Server, Amazon Redshift, Sybase IQ, Google BigQuery, Azure Synapse, Greenplum, PostgresSQL and Netezza.
SnowConvert can be officially downloaded in the Snowsight Snowflake web page.
However, it is highly recommended to take the free course "". 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.
You can follow this guide .
If you need special assistance, please get in touch with our customer support team at
Ventura 13.3.1 or higher
4 GB of RAM or higher*
Windows 11 or later
4 GB of RAM or higher*
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:
Open a Terminal window.
Type cd ~
and hit enter.
type chmod 777 .config
If you get a message telling you something like Operation not permitted
then execute command as sudo chmod 777 .config
.
Close the terminal window and open SnowConvert.
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.
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 like Operation not permitted
then execute the command as sudo chmod 777 .config
.
Close the terminal window and open SnowConvert.
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
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.
SnowConvert 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.
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.
Ask your IT department to:
EnsureSnowCovert has both inbound and outbound communication permissions.
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:
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.
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 file
The 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.
Your firewall is blocking SnowConvert from communicating with the Licensing API. This API is necessary for SnowConvert to request and validate licenses.
Ask your IT department to:
Ensure SnowConvert has both inbound and outbound communication permissions
Depending on the selected encoding, SnowConvert will not be able to parse the input; you should validate the correct encoding in the settings options before starting a conversion. .
Release notes can be find here:
Add DNS to the whitelist.
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 and download the .json file and look for: "name": "AppService.WestUS2"
, there you will get a list of IP ranges.
Add DNS to the whitelist
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 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 : . Please contact you local network administrator so they can grant SnowConvert access.