How to use the SnowConvert CLI
Installation
Depending on your Operating System, you can review the corresponding installation guide:
Commands
Summary
Each command can be used with the following syntax:
The available commands are listed below. If you want to check a detailed explanation for a command, you can click on the command.
install-ac
Install an access code.
show-ac
Show the installed access code(s).
Perform a Teradata conversion/assessment.
Perform an Oracle conversion/assessment.
Perform an SQL Server conversion/assessment.
Perform an Scala conversion/assessment.
Perform a Python conversion/assessment.
-h
Show help.
-v
Show the version of the tool.
Installing an access code
Before converting your code, you need to install an access code. You can do this by specifying the access code, or by specifying the path to the file that contains the access code information (this is useful when installing the access code without an Internet connection or under restrictive firewall settings).
You can use the following command to install the access code by writing the code:
This command is equivalent to the previous command:
If you want to install an access code using a file, you can use the --file / -f option, as shown in the following commands:
If there is an error during the installation of the license, an error will be shown. If you need an access code, you can reach out to snowconvert-support@snowflake.com .
Converting
You can use the following commands to convert your source code. You must provide an input path (where the source code is) and an output path (where the converted code will be placed). There is a different command for each product:
SnowConvert Teradata: teradata
SnowConvert Oracle: oracle
SnowConvert SQL Server: sql-server
SparkSnowConvert Scala: scala
SparkSnowConvert Python: python
In each of these cases, you can use -i instead of --input, or -o instead of --output. For example, instead of writing snowct teradata --input <input-path> --output <output-path> you can write snowct teradata -i <input-path> -o <output-path>.
Each of these commands might also receive additional parameters. In the following links, you can review which additional parameters are available for each product:
SnowConvert Teradata
SnowConvert Oracle
SnowConvert SQL Server
SparkSnowConvert Scala
SparkSnowConvert Python
Performing an Assessment
When performing an assessment you can use the same commands that you would use for conversion, but you need to add the option --assessment or -a. The commands you would use would look like these:
In each of theses cases, you can use -i instead of --input, or -o instead of --output, just like with conversions. Each of these commands might also receive additional parameters (check the Converting section).
Checking which access codes are installed
If you want to know which access codes are installed on your computer, you can use the following command:
This command will show the information for each access code that is installed on your computer.
The following commands will instead show the information for the access code that is being used for a specific product:
You can use -p instead of --platform. You can also use the show-ac command instead of the show-access-code command.
Checking the version of the tool
You can use any of the following commands to check the version of the tool and the version for each code processing engine (SnowConvert Teradata, SnowConvert Oracle, SnowConvert SQL Server, SparkSnowConvert Scala, SparkSnowConvert Python):
Need more help?
If you want to see general help for the CLI, you can use the following commands:
You can get more information about a command by executing this command:
For example, you can execute snowct install-access-code --help to get more information about how to install an access code, or you can execute snowct teradata --help to get more information about how to execute conversions/assessments using SnowConvert Teradata. This will also show information about the additional options that are available for SnowConvert Teradata.
Last updated