Getting Started
Last updated
Last updated
This guide will walk you through the basic steps of using the SnowConvert Migration Assistant to resolve post-conversion issues in your SQL code.
You have installed the Snowflake Visual Studio Code extension version 1.13.0 or later.
You have .sql files that contain EWIs from SnowConvert.
You have a Snowflake account with access to CORTEX and claude-3-5-sonnet.
Open the VS Code settings panel and navigate to Extensions. Select the Snowflake extension, and open the settings panel for the Snowflake extension.
In the Snowflake extension settings, you must:
Check “Enable Public Preview features”
Check “Enable SnowConvert Migration Assistant”
When you open the Snowflake extension by clicking the Snowflake icon on the left navigation bar, you will see a “SnowConvert Issues” panel at the bottom of the Snowflake extension panel, with a prompt to select a migration folder.
Open any folder containing .sql file outputs from SnowConvert that contain EWIs. You can open a parent folder to work with EWIs from all files in the folder and all its subfolders. You can open a different folder by clicking the folder icon at the top right of the list.
Once you’ve opened a folder containing .sql files with EWIs, you will see a list of all the EWIs in that folder, and the files containing them. Clicking on an EWI from the list will focus the code editor on the line of code where the EWI was found.
To get AI-powered assistance and recommended solutions for an EWI, click the lightbulb icon located next to the EWI in the list.
Once you click the lightbulb icon, the SnowConvert Migration Assistant will query Snowflake Cortex AI with the EWI in question and a snippet of the code context surrounding the EWI. The call to Cortex happens entirely within your Snowflake account, using the connection details you configured in the Snowflake VS Code Extension.
Once a result has been generated, it will appear in a panel to the right of the code editor. The result will contain an explanation of the EWI in the context of your code, and a suggested fix to make the code run correctly on Snowflake. If the assistant is unable to generate a response with high confidence, it will abstain from providing a recommended solution.
