Installation Guide

Deploy the Interactive Assessment Application in Snowflake.

This section guides you through deploying the Interactive Assessment Application (IAA) in your Snowflake account. The IAA is a Streamlit app that leverages the power of Snowflake within Snowflake to analyze the output data from the Snowpark Migration Accelerator (SMA). This document provides the necessary steps and resources to analyze your workload within your Snowflake environment using the IAA.

Step-by-step Guide

Before deploying the IAA, ensure you have the following prerequisites:

You have executed the SMA have the output data ready for analysis.
You have a Snowflake account. (This is required to host and run the IAA.) If not, a Snowflake Trial Account will work.
You have VSCode or Jupyter installed to run the notebook: VSCode or Jupyter.
Ensure you have Python 3.11 or later installed. This version is required for compatibility with the IAA notebook.
- You may already have Python installed on your system. If not, follow one of the options below.
  - For Linux or Mac, you can use the script: deployment/pre_req_install_python_3.sh.
  - For Windows, you can get it from the official Python website if you don't have Python.
  - Another alternative is to install with Miniconda docs.conda.io

Uploading all the mappings table might take longer than selecting just the latest. We recomend uploading the latest if you are not interest in comparing your execution with previous versions

In VS Code you can select the Map folder, that contains all the folders with the APIs and EWIs versions and delete those that you would not like to upload, in this case you can leave only the 7.1.2 version.

Once you've completed checking the prerequisites, proceed to the 'Deployment' tab.

Let's deploy the IAA!

This step by step guide applies to VS Code

Repository

Go to the Snowflake Labs' open-source GitHub: https://github.com/Snowflake-Labs/IAA-Support.
Click the "Code" button, and copy your preferred method for cloning the repository (e.g., HTTPS or SSH)
Choose the directory where you want to save the repository on your local machine, if applicable

Executing the Notebook in VS Code

Note: This deployment process uses the Snowflake CLI.

Open the downloaded repo in the VSCode environment.
In VS Code click Yes, I trust the authors

iaa_config.toml file

Part 1: Getting Credentials from "Connect a tool to Snowflake"

In your Snowflake account, click your initials in the bottom-left corner.
Select "Connect a tool to Snowflake".
Open the file `iaa_config.toml`.
Copy the following information from the "Connect a tool to Snowflake" window and paste it into the `iaa_config.toml` file:
1. Account Identifier
2. User Name

Part 2: Providing Additional Details

In the `iaa_config.toml` file, also provide the following information:

Password: Enter your Snowflake password.
Database Name: Enter the name of the database you want to use for the IAA.
Schema Name: Enter the name of the schema you want to use for the IAA.
Warehouse Name: Enter the name of the warehouse running in your Snowflake account.

Save the changes in the `iaa_config.toml` file.

Warning: The cell that validates the connection entries may fail if the .toml information is wrong, in that case, verify the input information.

Kernel

In order to executes the .ipynb file you need to install the Python and Jupyter extensions in VS Code.

Select the python environment that comply with the version required to execute the notebook. (3.11 or later).

Executing the Notebook

To deploy the app in your Snowflake account, please select "Run all" the cells.

These cells configure automatically the local environment and establish the connection to your Snowflake account to prepare for the Streamlit app deployment. Specifically, these cells will:

Verify the Python3.11 requirement
Verify check the Snowflake CLI Requirement
Execute the iaa_config.toml file is executed to connect with the Snowflake Account Configuration:
1. Read the local .toml file
2. Validate connection Entries
3. Establish a connection to Snowflake
Prepare the environment to deploy the Streamlit app in Snowflake
1. Configure local environment
2. Retrieve Connection Entries
Deploy the Streamlit app to Snowflake using the Snowflake CLI:
1. Deploy the App Schema to SiS.
2. Deploy the Maps Stage to SiS.
3. Deploy the APP to SiS.
4. Refresh the Deployment
5. Retrieve the app information and provide an access button.
That's it! It is time to Upload your SMA Output

It is time to upload your SMA Output!

Locate the SMA output zip file, named in the format ‘AssessmentFiles_*.zip’, in the output folder.

Go to your Snowflake Account

Data > Databases > [Your IAA Database] > Stages > SMA_EXECUTIONS

Upload you AssessmentFiles.zip.

Open the IAA to explore your execution information. This step can take around 30 seconds.

Once open the IAA the landing page will look like this:

Lets Explore your execution using the IAA.

PreviousOverview NextGeneral Troubleshooting

Last updated 9 months ago

Installation Guide

Step-by-step Guide