Snowflake to Azure SQL database by COZYROC

This gem ensures that data stored in Snowflake can be seamlessly transferred to Azure SQL Database for further processing, reporting, or analytics, leveraging the strengths of both cloud platforms.

This gem will require you to connect and expose your Azure SQL Database to the COZYROC Cloud for seamless data integration and management. To find out how to expose your Azure SQL database to COZYROC Cloud, please refer to KB Article Expose Azure SQL Database to COZYROC Cloud

Setup Guide

This gem will establish a connection between Snowflake and the desired Azure SQL database instance. Once the connection is established, the gem will then pull the data from each Snowflake table specified in the Mapping parameter and send each table data to its allocated table in the Azure SQL database.

When specifying values for the Mapping parameter, please follow the format: SnowTableName:"SqlSchema"."SqlTableName". Here the SnowTableName and SqlSchema.SqlTableName are separated by colon (:).

For example: Customer:"dbo"."tbl_Customer"

Note: This gem will assume that the destination tables are already created.

To run this gem and connect Snowflake to the Azure SQL database instance, you need to configure the parameters that are mentioned below.

Snowflake

• Server Host Required. Specify the correct [account identifier] in the server host URL.
• Token File Required. Select the Rest Token file from the drop-down list. Review the KB-Article mentioned here on how to generate the token file.
• Warehouse Required. Specify the Snowflake warehouse name.
• Database Required. Specify the Snowflake database name.
• Schema Required. Specify the Snowflake schema name.
• Timeout Required. Specify the timeout. The default is set to 60.
• Where Optional. Specify to filter the data.
• Batch Size Required. The default is set to 200.

Azure SQL Database

• Server Name Required. Specify the server name.
• Database Required. Specify the database name.
• Username Required. Specify the username.
• Password Required. Specify the password.

Mapping

• Mapping Required. This parameter accepts comma-separated values if you want to pull data from multiple Snowflake tables and send each Snowflake table data to its allocated table in the Azure SQL database, e.g. Contact:"dbo"."tbl_Contact" etc.