SnowConvert: Deployment

SnowConvert AI, as part of the end-to-end migration experience, offers the option to deploy converted database objects directly to your Snowflake environment. This deployment feature allows you to review conversion results, authenticate to Snowflake, and deploy selected objects with their proper dependencies and execution order.

Conversion Status Indicators

Before deployment, SnowConvert provides visual indicators to help you understand the conversion status of each object:

Ready for Deployment

Objects that have been successfully converted and are ready for deployment without any issues.

Functional Data Model (FDM) Warnings

Objects with FDMs have been found in the conversion. It is recommended to review these before deployment, though they can still be deployed.

Equivalent Work Item (EWI) Errors

Objects with EWIs have critical issues that must be fixed before deployment. These objects cannot be deployed until the issues are resolved.

Note

For detailed information about FDMs and EWIs, please refer to the SnowConvert Technical Documentation.

Supported Authentication Methods

The deployment process supports two authentication methods to connect to your Snowflake environment:

SSO (Single Sign-On)

Allows authentication using your organization’s Single Sign-On provider configured with Snowflake. This method provides seamless integration with your existing identity management system.

Standard Authentication

Traditional username and password authentication with the following security requirements:

  • Multi-factor authentication (MFA) must be enabled for your Snowflake account

  • Follows Snowflake’s security best practices and recommendations

Note

The account identifier should use “-” for separation instead of “.”, formatted like this: orgname-account-name.

Warning

Please ensure you follow Snowflake’s security recommendations and have multi-factor authentication (MFA) enabled.

Deployment Execution Order

The deployment process executes database objects in a specific order to maintain proper dependencies:

  1. Databases - Created first to establish the container structure

  2. Schemas - Created within databases to organize objects

  3. Tables - Created to establish data structures

  4. Views - Created after tables since they depend on table structures

  5. Functions - Deployed to provide reusable logic

  6. Stored Procedures - Deployed last as they may reference other objects

How to use this feature

This feature allows you to deploy your converted database objects to Snowflake. After deployment, you can proceed with data migration to complete the end-to-end migration process.

Prerequisites

  • Completed conversion process with objects ready for deployment

  • Valid Snowflake account with appropriate permissions

  • Multi-factor authentication (MFA) enabled (for Standard authentication)

Usage

  1. Review conversion status by examining the status indicators for each object in your project. Focus on resolving any EWI errors before proceeding.

  2. Select objects for deployment by choosing the objects you want to deploy to Snowflake. Only objects with successful conversion status or acceptable FDM warnings should be selected.

Note

If you make changes to object files, you can refresh the tree by clicking the “Refresh Tree” button to update the conversion status.

  1. Initiate deployment by clicking the “Deploy” button. This will prompt you to authenticate to your Snowflake environment.

  2. Authenticate to Snowflake by selecting either SSO or Standard authentication method and providing the required credentials according to your organization’s setup.

  3. Monitor deployment progress as the system executes the deployment process. Objects will be deployed in the proper dependency order automatically.

  4. Review deployment results once the process is complete. The system will display the execution results for each deployed object, including any success confirmations or error messages.

Note

Only successfully converted objects will be available for deployment. Objects with EWI errors must be resolved before they can be deployed.

After completing the deployment process, your database objects will be available in your Snowflake environment. You can then proceed with data migration to transfer your data, completing the full migration process and making everything ready for use in your applications and workflows.

Language: English