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環境に接続するための2つの認証方法をサポートしています。

SSO （シングルサインオン）

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.

言語: 日本語