SnowConvert AI: 배포

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

배포하기 전에, SnowConvert AI는 각 오브젝트의 변환 상태를 이해하는 데 도움이 되는 시각적 표시기를 제공합니다.

배포 준비 완료

성공적으로 변환되어 문제 없이 오브젝트를 배포할 준비가 되었습니다.

함수 데이터 모델(FDM) 경고

FDMs이 있는 오브젝트가 변환에서 발견되었습니다. 배포하기 전에 이러한 내용을 검토하는 것이 좋지만, 배포는 여전히 가능합니다.

동등한 작업 항목(EWI) 오류

EWIs가 있는 오브젝트에는 배포 전에 해결해야 하는 중요한 문제가 있습니다. 이러한 오브젝트는 문제가 해결될 때까지 배포할 수 없습니다.

참고

FDMs 및 EWIs에 대한 자세한 내용은 SnowConvert AI기술 설명서를 참조하세요.

Supported authentication methods

배포 프로세스에서는 Snowflake 환경에 연결하기 위한 두 가지 인증 방법을 지원합니다.

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

다음과 같은 보안 요구 사항이 있는 기존 사용자 이름 및 비밀번호 인증:

  • Snowflake 계정에 다단계 인증(MFA)을 활성화해야 합니다.

  • Snowflake의 보안 모범 사례 및 권장 사항을 따릅니다.

참고

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

경고

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

Deployment execution order

배포 프로세스는 적절한 종속성을 유지하기 위해 특정 순서로 데이터베이스 오브젝트를 실행합니다.

  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.

    참고

    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:

참고

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.

언어: 한국어