SnowConvert AI: Implantação

SnowConvert AI, as part of the end-to-end migration experience, offers the option to deploy converted database objects directly to your Snowflake environment. With this deployment feature, you can review conversion results, authenticate to Snowflake, and deploy selected objects with their proper dependencies and execution order. This deployment feature is available for SQL Server and Amazon Redshift databases.

Conversion status indicators

Antes da implantação, o SnowConvert AI fornece indicadores visuais para ajudar você a entender o status de conversão de cada objeto:

Pronto para implementação

Objetos que foram convertidos com sucesso e estão prontos para implantação sem problemas.

Avisos do modelo de dados funcional (FDM)

Objetos com FDMs foram encontrados na conversão. É recomendável revisá-los antes da implantação, embora elas ainda possam ser implantadas.

Erros do item de trabalho equivalente (EWI)

Objetos com EWIs têm problemas críticos que devem ser corrigidos antes da implantação. Esses objetos não podem ser implantados até que os problemas sejam resolvidos.

Nota

Para obter informações detalhadas sobre FDMs e EWIs, consulte a documentação técnica do SnowConvert AI.

Supported authentication methods

O processo de implantação aceita dois métodos de autenticação para conectar-se ao seu ambiente Snowflake:

SSO (logon único)

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

Autenticação tradicional de nome de usuário e senha com os seguintes requisitos de segurança:

  • A autenticação multifator (MFA) deve estar habilitada para sua conta Snowflake

  • Siga as melhores práticas e recomendações de segurança do Snowflake

Nota

The account identifier must use - for separation instead of . (for example, orgname-account-name).

Aviso

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

Deployment execution order

O processo de implantação executa objetos de banco de dados em uma ordem específica para manter as devidas dependências:

  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 because they depend on table structures.

  5. Functions: Deployed to provide reusable logic.

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

Deploy converted database objects to Snowflake

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

Ensure that you meet the following prerequisites before deploying converted objects:

  • You completed conversion process with objects ready for deployment.

  • You have a valid Snowflake account with appropriate permissions.

  • You have multi-factor authentication (MFA) enabled (for Standard authentication).

Complete the following steps to deploy converted objects:

  1. In SnowConvert AI, open the project, and then select Deploy code.

  2. On the Connect to Snowflake page, complete the fields with your connection information, and then select Sign in.

    The Select objects to deploy page appears. The following image is an example of the page:

  3. Review the conversion status and resolve any errors before proceeding.

    Examine the status indicators for each object in your project. Resolve any EWI errors before proceeding.

  4. Select the objects that you want to deploy to Snowflake.

    Only select objects with successful conversion status or acceptable FDM warnings.

    Nota

    If you make changes to object files, you can refresh the conversion status by selecting Refresh files.

  5. Select Deploy.

    The deployment process starts. Objects are deployed automatically, in the proper dependency order. When deployment finishes, the Deployment results window appears.

  6. In Deployment results, review the results for success confirmations or error messages.

    The following image is an example of a Deployment results window:

Nota

Only successfully converted objects are available for deployment. You must resolve objects with EWI errors before you can deploy them.

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

Linguagem: Português