Training and Support

Get started the right way by working through our SnowConvert Code Labs.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

SnowConvert Code Labs

We highly recommend that you go through these labs in order to get the most out of SnowConvert. These are client-facing labs are designed to guide you on how to take full advantage of all the SnowConvert functionality. You can find them here and it comprises the following topics:

1. Intro

Execute a Teradata database migration using the SnowConvert for Teradata tool. The lab covers:

• How to download and install the SnowConvert for Teradata tool

• How to extract Teradata DDL scripts

• How to use the SnowConvert for Teradata tool

• Which are the SnowConvert for Teradata Outputs

• Troubleshooting and tips

• Handling large DDL files

• Encoding Issues

Check out the lab here.

2. Assessment

SnowConvert for Teradata Assessments and how to use them for migration planning.

Coming soon... this lab is not available yet.

3. Tables and Views

Tasks related to Tables and Views migration using the SnowConvert Teradata tools, how to deploy, and how to finish any issues that required some manual revision.

Coming soon... this lab is not available yet.

4. Functions

Tasks related to Functions migration using the SnowConvert Teradata tool, how to deploy and how to finish any issues that required some manual revision. The lab covers:

• How the migration tool automates the conversion from Teradata Functions.

• Platform Differences.

• Create a function in Snowflake using SQL.

• Create a function in Snowflake using Javascript.

• Guidelines to rewrite some functions in Snowflake.

Check out the lab here.

5. Macros and Procedures

Tasks related to Macros and Procedures migration using the SnowConvert Teradata tool, how to deploy them, and how to finish any issues that required some manual revision.

Coming soon... this lab is not available yet.

6. BTEQ

Tasks related to BTEQ migration using the SnowConvert Teradata tool, how to deploy and how to finish any issues that required some manual revision.

Coming soon... this lab is not available yet.

7. Helpers in JavaScript SP

SnowConvert use of Javascript for Stored procedures and the Snowflake API to interact with them. The lab will cover:

• Review the current Snowflake API for Stored Procedures

• Understand its different usage pattern

• Understand some of the current limitations

Check out the lab here.

8. Embedded BTEQ

Shell scripting, embedded code, and how to handle these situations with SnowConvert. The lab will cover:

• Shell scripting

• Problems about embedded shell scripting with BTEQ

• Shell scripts with BTEQ

Check out the lab here.

9. Azure Function Labs

Create, publish and run an Azure function for Teradata BTEQ files that were migrated to Python scripts using the SnowConvert for Teradata tool. The lab covers:

• How to convert BTEQ files to Python Scripts using SnowConvert for Teradata tool.

• How to run migrated BTEQ files as Python scripts.

• How to create and publish an Azure Function for run Python scripts

Check out the lab here.

10. Power BI Lab for Snowflake

Convert a Power BI report pointing to a SQL database to a Snowflake database using the SnowConvert for SQL tool. The lab covers:

• How to connect a Power BI report to SQL Server

• Migrate SQL Scripts using SnowConvert

• How to update the Power BI report and connect to Snowflake

Check out the lab here.

11. SSRS Migration Lab for Snowflake

Convert a SSRS report pointing to a SQL database to a Snowflake database using minor DDL and DML changes. The lab covers:

• How to connect a SSRS report to SQL Server

• Migrate SQL Scripts

• How to update the SSRS report and connect to Snowflake

Check out the lab here.

Let's dive into the code conversions that SnowConvert can perform in the next sections.