SnowConvert: Data Extraction

SnowConvert AI, as part of the end-to-end migration experience, offers the option to extract database objects from your source system to prepare them for the conversion process. This extraction feature is available for SQL Server and Amazon Redshift databases, allowing you to connect to your source database, browse the catalog, and select specific objects for migration.

Supported Authentication Methods

The extraction process supports different authentication methods depending on your source database type:

SQL Server Authentication

For SQL Server databases, you can use the following authentication methods:

Standard Authentication

Windows Authentication

Connection Security Options

Both SQL Server authentication methods require verification of security settings if configured in your database:

  • Trust Server Certificate: Must be enabled if the database requires trusted certificate validation

  • Encrypt Connection: Must be enabled if the database requires encrypted connections

Amazon Redshift Authentication

For Amazon Redshift databases, you can use the following authentication methods:

IAM Provisioned Cluster

IAM Serverless

Standard

Supported Database Objects

The extraction process supports different database objects depending on your source database type:

SQL Server Objects

  • Tables

  • Views

  • Functions

  • Stored procedures

Amazon Redshift Objects

  • Tables

  • Views

  • Materialized views

  • Stored procedures

How to use this feature

This feature is the first step in the end-to-end migration process, allowing you to select and extract the specific database objects you want to migrate to Snowflake.

Usage

  1. Authenticate to your source database by selecting one of the supported authentication methods and providing the required credentials.

  2. Connect to the database catalog by clicking the “Connect to Database” button. You will see a “Connection established” notification and the catalog will display all available objects for extraction.

  3. Browse and select objects from the database catalog. You can expand databases and schemas to view their contained objects.

  4. Extract selected objects by choosing the objects you want to migrate and clicking “Extract Objects”. The system will retrieve the metadata and structure information for the selected items.

  5. Review extraction results by clicking “View Last Extraction Results” to confirm all objects were successfully extracted before proceeding to the conversion process.

Note

Only successfully extracted objects will be available for the subsequent conversion step.

After completing the extraction process, you can proceed to the conversion process to transform your database objects for Snowflake compatibility.